{"product_id":"book-tracker-reading-log","title":"Book Tracker Dashboard Spreadsheet","description":"\u003cp\u003eThis book tracker keeps your whole library in one tab and works out what to read next. It is for readers who follow series, set a yearly reading challenge and want to see how big the unread pile has quietly become.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003ePlease read:\u003c\/strong\u003e This is a tracker tool only, not financial, tax, legal, medical or any other professional advice or advisory service. It records and calculates what you enter; you are solely responsible for checking all figures, rates, dates and results and for every decision you make. By purchasing, downloading or using it, you accept these terms (your statutory consumer rights are not affected).\u003c\/p\u003e\u003ch2\u003eThe dashboard\u003c\/h2\u003e\u003cp\u003eNothing on the dashboard is typed. Pick the full year or any month and the whole page follows.\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eFive live cards for books, pages, hours, rating and challenge, each with month-by-month bars\u003c\/li\u003e\n\u003cli\u003eThe reading year: pages read each month, with the books you finished on top\u003c\/li\u003e\n\u003cli\u003eGenres ranked by what you actually read, with each genre's share, and your top authors counted\u003c\/li\u003e\n\u003cli\u003eCurrently reading: up to three books on the go, with your page and how far in you are\u003c\/li\u003e\n\u003cli\u003eReading challenge: books read against your goal, how far ahead you are and what you need each week\u003c\/li\u003e\n\u003cli\u003eRatings by stars, formats from paperback to audiobook, and challenge pace against your goal\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eOne library, nine tabs reading it\u003c\/h2\u003e\u003cp\u003eThe Library tab holds up to 400 books, each with title, author, series, pages, price, where it came from and a status. Nine other tabs read it, and nothing is typed twice.\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eSeries tracker: the lowest-numbered book you have not read is named for every series, and it says plainly when the next one is not on your shelf yet. It moves the moment you mark a book finished.\u003c\/li\u003e\n\u003cli\u003eChallenge: ahead or behind today, not on the 31st of December, with books a week, pages a day and the date you finish at your current pace\u003c\/li\u003e\n\u003cli\u003eTBR tracker: books waiting, counted and priced, so you see the money already sitting on the shelf. The demo has nineteen of them.\u003c\/li\u003e\n\u003cli\u003eBy Genre: share measured in pages, with ratings and spend\u003c\/li\u003e\n\u003cli\u003eReading log: optional daily pages and minutes, with pages an hour\u003c\/li\u003e\n\u003cli\u003eMonthly: finished, pages, hours and average rating\u003c\/li\u003e\n\u003cli\u003eWishlist: the total against what is left in your book budget\u003c\/li\u003e\n\u003cli\u003eDays per book, calculated from the dates you already type\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eLight and dark editions\u003c\/h2\u003e\u003cp\u003eEvery download includes a light edition and a dark mode template edition. Every tab is restyled, not only the dashboard, and both use the same formulas. Each comes filled with a worked example of 62 books, 41 read this year and three series on the go, and as a blank copy, in Excel and in Google Sheets. The file has no cover images and no ISBN lookup, which is why it needs no subscription.\u003c\/p\u003e\u003ch2\u003eWorks with\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003eMicrosoft Excel 2016 or later, on Windows or Mac. There is no formula in it that Excel 2016 cannot read.\u003c\/li\u003e\n\u003cli\u003eGoogle Sheets with a free Google account. The Google Sheets version is a real workbook, not a PDF with a link in it.\u003c\/li\u003e\n\u003cli\u003eNo dynamic arrays, no macros and no add-ins, so it behaves the same on Excel 2016, 2019, 2021 and Microsoft 365 and in LibreOffice\u003c\/li\u003e\n\u003cli\u003eNo subscription\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eWhat you download\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003eLight edition: the Excel workbook filled with a worked example, and a blank one\u003c\/li\u003e\n\u003cli\u003eDark edition: the same two files in the dark design\u003c\/li\u003e\n\u003cli\u003eThe instruction guide, with one-click links to the Google Sheets versions (light and dark, filled and blank)\u003c\/li\u003e\n\u003cli\u003eThe terms of use as a PDF\u003c\/li\u003e\n\u003c\/ul\u003e\u003cp\u003eYour files are ready to download as soon as payment clears. Questions before or after you buy? Use our contact page and we will help.\u003c\/p\u003e\u003ch2\u003eFrequently asked questions\u003c\/h2\u003e\u003ch3\u003eDoes it work in Excel or Google Sheets?\u003c\/h3\u003e\u003cp\u003eBoth. The Excel workbooks run on Excel 2016 or later on Windows or Mac with no Microsoft 365 needed, and the instruction guide has one-click links to the Google Sheets versions.\u003c\/p\u003e\u003ch3\u003eHow does it know the next book in a series?\u003c\/h3\u003e\u003cp\u003eIt finds the lowest-numbered book in each series that you have not read and names it. If that book is not in your library yet, it says so.\u003c\/p\u003e\u003ch3\u003eHow does the reading challenge work?\u003c\/h3\u003e\u003cp\u003eSet a yearly goal and it compares what you have read with where you should be today, then shows the books a week and pages a day needed from here.\u003c\/p\u003e\u003ch3\u003eDoes it show book covers?\u003c\/h3\u003e\u003cp\u003eNo. There are no cover images and no ISBN lookup, which keeps it working without a subscription.\u003c\/p\u003e\u003ch3\u003eWhat is the difference between the light and dark editions?\u003c\/h3\u003e\u003cp\u003eOnly the look. Both have the same tabs and formulas, and both come in every download.\u003c\/p\u003e","brand":"OPXVIA","offers":[{"title":"Default Title","offer_id":67597865648222,"sku":"OPX-097","price":25.0,"currency_code":"CAD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0769\/2094\/6782\/files\/book-tracker-reading-log-01.jpg?v=1790832484","url":"https:\/\/opxviashop.com\/products\/book-tracker-reading-log","provider":"OPXVIA","version":"1.0","type":"link"}