{"title":"Hobbies \u0026 Collections","description":"\u003cp\u003eSpreadsheets for collectors and hobbies, in Excel and Google Sheets. Catalogue books, vinyl records, LEGO sets, video games, sneakers, cards and comics, coins and stamps or a wine cellar, with values and wish lists.\u003c\/p\u003e","products":[{"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"},{"product_id":"wardrobe-inventory-cost-per-wear","title":"Wardrobe Inventory and Cost Per Wear Spreadsheet","description":"\u003cp\u003eThis wardrobe inventory works out what each piece of clothing really costs you every time you wear it. It is for anyone building a capsule wardrobe or clearing out a closet who would rather decide from numbers than from a feeling about the coat at the back of the rail.\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\u003eTwo tabs do the work\u003c\/h2\u003e\u003cp\u003eItems holds what you own and the Wear Log holds what you wore. The wear log is four columns and takes about fifteen seconds a day. Everything else is arithmetic on those two tabs.\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eItems: room for 400 pieces, with category, color, brand, season and price\u003c\/li\u003e\n\u003cli\u003eTimes worn, last worn and cost per wear: three columns you never fill in\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eCost per wear on everything\u003c\/h2\u003e\u003cp\u003eCost per wear is calculated on every item, then ranked twice against a line you set: the ten most expensive per wear and the ten best value. It is worked out by category too, which shows how you really dress. An expensive coat can turn out to cost far more per wear than you thought, and a plain tee far less.\u003c\/p\u003e\u003ch2\u003eOwned against worn\u003c\/h2\u003e\u003cp\u003eThe Gaps tab sets each category's share of your wardrobe beside its share of your wearing. In the demo, knitwear makes up 9.5% of what is owned but only 2.7% of what is worn, exactly the mismatch a capsule wardrobe is meant to prevent.\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eNever worn, listed by name with the date bought and the full price, because that is what it has cost so far\u003c\/li\u003e\n\u003cli\u003eAnything not worn in ninety days is flagged\u003c\/li\u003e\n\u003cli\u003eOutfits that already work, counted by the days they actually appear in the log\u003c\/li\u003e\n\u003cli\u003eMonthly: wears, days dressed, what you bought and what it cost\u003c\/li\u003e\n\u003cli\u003eA wishlist with the total against what is left in your clothes budget\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eTen connected tabs\u003c\/h2\u003e\u003cp\u003eStart Here, Setup, Items, Wear Log, Cost Per Wear, Outfits, Gaps, Wishlist, Monthly and Dashboard. It works as a closet inventory, outfit tracker and clothing tracker in one file. There are no photographs and no style advice: it divides two numbers correctly and shows you the answer, and what that means is yours to decide.\u003c\/p\u003e\u003ch2\u003eWorks with\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003eMicrosoft Excel 2016 or later, on Windows or Mac\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. No Microsoft 365 subscription is required.\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\u003eTwo Excel files: 42 items with nine months of wear and one cardigan never worn, and a blank one for your own closet\u003c\/li\u003e\n\u003cli\u003eThe instruction guide, which has one-click links to the Google Sheets versions (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 files run on Excel 2016 or later on Windows or Mac, and the instruction guide has one-click links to the Google Sheets versions for a free Google account.\u003c\/p\u003e\u003ch3\u003eHow much do I have to log each day?\u003c\/h3\u003e\u003cp\u003eThe Wear Log is four columns and takes about fifteen seconds a day. Times worn, last worn and cost per wear are calculated for you.\u003c\/p\u003e\u003ch3\u003eHow is cost per wear worked out?\u003c\/h3\u003e\u003cp\u003eIt divides each item's price by the number of times you have worn it. Items never worn show their full price.\u003c\/p\u003e\u003ch3\u003eCan it help me declutter?\u003c\/h3\u003e\u003cp\u003eIt lists items you have never worn by name and flags anything not worn in ninety days, so you can decide what to keep.\u003c\/p\u003e\u003ch3\u003eCan I add photos of my clothes?\u003c\/h3\u003e\u003cp\u003eNo. It has no photographs and no style advice. It tracks what you own and wear and does the arithmetic.\u003c\/p\u003e","brand":"OPXVIA","offers":[{"title":"Default Title","offer_id":67597865680990,"sku":"OPX-098","price":18.0,"currency_code":"CAD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0769\/2094\/6782\/files\/wardrobe-inventory-cost-per-wear-01.jpg?v=1790832489"},{"product_id":"tv-show-movie-tracker","title":"TV Show and Movie Tracker Spreadsheet","description":"\u003cp\u003eThis tv show tracker answers the one question a watchlist is really for: what should I put on next. It is for anyone following several series at once, plus films, who wants their movie watchlist, viewing history and yearly goal in one place.\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\u003eSeasons: the next one, worked out\u003c\/h2\u003e\u003cp\u003eThe Seasons tab finds the lowest-numbered season of each show you have not watched yet. You do not type it. Mark a season finished and the next one moves up on its own. When the next season is not on your list yet, it tells you so plainly instead of leaving a blank cell. Shows you are part-way through are counted, with the episodes still to go.\u003c\/p\u003e\u003ch2\u003eThe watchlist\u003c\/h2\u003e\u003cp\u003eThe Watchlist holds 400 titles, each with show, season number and episode count, so it works as a series tracker and episode tracker as well as a film log.\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eFour statuses counted: watched, watching, to watch and gave up\u003c\/li\u003e\n\u003cli\u003eWhat you spent on rentals, buys and cinema tickets\u003c\/li\u003e\n\u003cli\u003eWhat the titles you have not watched yet are worth, which is the more honest of the two numbers\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eA watch log, if you want one\u003c\/h2\u003e\u003cp\u003eThe Watch Log has room for 900 nights, with episodes and minutes. That gives you hours watched and minutes per episode. If you would rather not log nights, skip it and everything else still works.\u003c\/p\u003e\u003ch2\u003eA goal, genres and more\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003e\n\u003cstrong\u003eChallenge:\u003c\/strong\u003e a yearly goal with pace, ahead or behind today, what you are on course for and the date you would finish at your current rate\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eBy Genre:\u003c\/strong\u003e counted on episodes rather than titles, with the average rating, so three long seasons of one genre show up properly\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eWishlist:\u003c\/strong\u003e titles you want, with a budget beside it\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eMonthly and Dashboard:\u003c\/strong\u003e month by month totals and the whole picture\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eStart Here and Setup:\u003c\/strong\u003e setup in a few minutes\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eWorks with\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003eMicrosoft Excel 2016, 2019, 2021 and Microsoft 365, on Windows and Mac, and LibreOffice\u003c\/li\u003e\n\u003cli\u003eGoogle Sheets with a free Google account. The Google Sheets version is a real workbook you copy, not a PDF with a link in it.\u003c\/li\u003e\n\u003cli\u003eNo dynamic arrays, no macros, no add-ins and no subscription\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eWhat you download\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003eTwo Excel files: a worked year with 62 titles across 17 shows, 41 finished, 272 episodes, 126 nights logged and 244 hours, and a blank copy\u003c\/li\u003e\n\u003cli\u003eThe instruction guide, which has one-click links to the Google Sheets versions\u003c\/li\u003e\n\u003cli\u003eThe terms of use as a PDF\u003c\/li\u003e\n\u003c\/ul\u003e\u003cp\u003eYour files are ready the moment payment clears. The tracker is for personal and business use on your own devices, so please do not share or resell the files. Questions? Reach us through our contact page.\u003c\/p\u003e\u003ch2\u003eFrequently asked questions\u003c\/h2\u003e\u003ch3\u003eDo I need Excel, or can I use Google Sheets?\u003c\/h3\u003e\u003cp\u003eEither. The download has Excel files for Excel 2016 or later on Windows and Mac, and the instruction guide has one-click links to copy the Google Sheets versions with a free Google account.\u003c\/p\u003e\u003ch3\u003eHow does it know which season to watch next?\u003c\/h3\u003e\u003cp\u003eThe Seasons tab finds the lowest-numbered season of each show you have not watched. Mark one finished and the next moves up automatically.\u003c\/p\u003e\u003ch3\u003eDo I have to log every night I watch?\u003c\/h3\u003e\u003cp\u003eNo. The Watch Log is optional. Skip it and the rest of the tracker still works.\u003c\/p\u003e\u003ch3\u003eCan I track films as well as TV shows?\u003c\/h3\u003e\u003cp\u003eYes. The Watchlist holds 400 titles, including films and seasons of shows, each with a status and a rating.\u003c\/p\u003e\u003ch3\u003eCan I set a yearly watching goal?\u003c\/h3\u003e\u003cp\u003eYes. The Challenge tab tracks a yearly goal with your pace, whether you are ahead or behind, and the date you would finish at your current rate.\u003c\/p\u003e","brand":"OPXVIA","offers":[{"title":"Default Title","offer_id":67597867122782,"sku":"OPX-134","price":18.0,"currency_code":"CAD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0769\/2094\/6782\/files\/tv-show-movie-tracker-01.jpg?v=1790832691"},{"product_id":"beekeeping-hive-inspection-log","title":"Beekeeping Hive Inspection Log Spreadsheet","description":"\u003cp\u003eThis hive inspection log is for beekeepers who look inside their colonies every week or two through the season and want a clear record of what they saw. One row per inspection, seven short entries, and the workbook keeps the season in order.\u003c\/p\u003e\u003cp\u003eAn inspection is a handful of quick observations made with the roof off and gloves on, and by evening most of them are gone. Typing them in takes about ninety seconds and keeps them for good.\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\u003eSeven observations, seven columns\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003e\n\u003cstrong\u003eQueen seen:\u003c\/strong\u003e yes, no, or eggs only\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eBrood frames and stores\u003c\/strong\u003e, side by side, which is how you spot a colony going backwards weeks before it is obvious\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eTemper\u003c\/strong\u003e, scored one to five, because a bad-tempered hive is a fact worth recording and acting on\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eColony state\u003c\/strong\u003e, one of six, each with its own color\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eSupers on\u003c\/strong\u003e and \u003cstrong\u003ehoney taken\u003c\/strong\u003e in kilos\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eWhat gets counted for you\u003c\/h2\u003e\u003cp\u003eHives that are queenless or weak are counted on the summary strip, so the colony that needs attention is not buried in fifty rows of notes. Varroa treatments are counted too, which makes the log useful as a simple varroa tracker and queen record alongside your honey tracker.\u003c\/p\u003e\u003ch2\u003eSix connected tabs\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003e\n\u003cstrong\u003eStart Here and Setup:\u003c\/strong\u003e a guided start and your hives\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eHives:\u003c\/strong\u003e room for 300 inspections across as many hives as you keep\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eTasks:\u003c\/strong\u003e jobs like ordering frames, making up syrup or booking a swarm collection\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eToday:\u003c\/strong\u003e what the next ten days need\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eDashboard:\u003c\/strong\u003e reads every tab and fills itself\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eA full season to learn from\u003c\/h2\u003e\u003cp\u003eThe worked example records 51 inspections across three hives in one season, from the first look in April to the September feed. It has brood against stores on every row, temper scores, 54.4 kg of honey taken, one varroa treatment and two hives flagged queenless or weak. A blank copy is ready for your own beekeeping log and apiary records.\u003c\/p\u003e\u003ch2\u003eWorks with\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003eMicrosoft Excel 2016, 2019, 2021 and Microsoft 365, on Windows and Mac, and LibreOffice\u003c\/li\u003e\n\u003cli\u003eGoogle Sheets with a free Google account. The Google Sheets version is a real workbook you make your own copy of, not a PDF with a link in it.\u003c\/li\u003e\n\u003cli\u003eNo dynamic arrays, no macros, no add-ins and no subscription\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eWhat you download\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003eThe Excel workbook filled with a worked example\u003c\/li\u003e\n\u003cli\u003eA blank Excel workbook ready for your own entries\u003c\/li\u003e\n\u003cli\u003eThe instruction guide, which has one-click links to the Google Sheets versions (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, and the Start Here tab walks you through setup in a few minutes. The template is for personal and business use on your own devices, so please do not share or resell the files. 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 and Google Sheets?\u003c\/h3\u003e\u003cp\u003eYes. You download Excel workbooks for Excel 2016 or later on Windows and Mac, and the instruction guide has one-click links to make your own copy in Google Sheets with a free Google account.\u003c\/p\u003e\u003ch3\u003eHow many hives can I record?\u003c\/h3\u003e\u003cp\u003eAs many as you like. The Hives tab has room for 300 inspections across all of them.\u003c\/p\u003e\u003ch3\u003eWhat do I record at each inspection?\u003c\/h3\u003e\u003cp\u003eQueen seen, brood frames, stores, temper from one to five, colony state, supers on and honey taken in kilos.\u003c\/p\u003e\u003ch3\u003eCan it track varroa treatments?\u003c\/h3\u003e\u003cp\u003eYes. Varroa treatments are counted, and hives that are queenless or weak are counted on the summary strip.\u003c\/p\u003e","brand":"OPXVIA","offers":[{"title":"Default Title","offer_id":67597871054942,"sku":"OPX-196","price":22.0,"currency_code":"CAD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0769\/2094\/6782\/files\/beekeeping-hive-inspection-log-01.jpg?v=1790833044"},{"product_id":"video-game-backlog-tracker","title":"Video Game Backlog and Play Log Spreadsheet","description":"\u003cp\u003eThis video game backlog tracker is for players with a pile of unplayed games and no clear idea how big it really is. List every game once, log your sessions, and the workbook tells you what to start next and what the backlog is worth.\u003c\/p\u003e\u003cp\u003eA backlog only feels like a problem because it has no size. Here it gets two: what it cost and how many hours it would take.\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\u003eWhat it works out for you\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003e\n\u003cstrong\u003eWhat to start next:\u003c\/strong\u003e the lowest-numbered game you have not finished in each series, as a formula, so it moves the moment you mark one done\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eWhat the backlog is worth:\u003c\/strong\u003e the money spent on unplayed games and the hours they need, both on the summary strip\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eHours per session:\u003c\/strong\u003e where your playing time actually went over the year\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eA yearly goal:\u003c\/strong\u003e games finished against your target, with ahead or behind worked out from the day of the year\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eTen connected tabs\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003e\n\u003cstrong\u003eStart Here and Setup:\u003c\/strong\u003e a guided start and your settings\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eBacklog:\u003c\/strong\u003e your game collection, 400 games with studio, series, hours and price, across ten genres, five formats and ten storefronts\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003ePlay Log:\u003c\/strong\u003e room for 900 sessions, with hours played per sitting\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eSeries:\u003c\/strong\u003e the next unfinished game in every series\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eChallenge:\u003c\/strong\u003e your yearly goal and whether you are on course\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eBy Genre:\u003c\/strong\u003e what you finish and how you rate it\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eWishlist:\u003c\/strong\u003e a game wishlist with a budget and what is left of it\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eMonthly and Dashboard:\u003c\/strong\u003e the year at a glance, filled in automatically\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eA real backlog to explore\u003c\/h2\u003e\u003cp\u003eThe worked example holds 62 games across 36 series. Nineteen are finished this year against a goal of twenty-four, on course for twenty-six, and 594 hours are logged across 267 sessions at 2.2 hours a sitting. Thirty-six games are still in the backlog, adding up to 1,937 hours, with three series left part-way through and the next game in each one named. A blank copy is ready for your own gaming log.\u003c\/p\u003e\u003cp\u003eIt is a plain gaming spreadsheet: you type the games and the sessions, and the formulas do all of the counting.\u003c\/p\u003e\u003ch2\u003eWorks with\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003eMicrosoft Excel 2016, 2019, 2021 and Microsoft 365, on Windows and Mac, and LibreOffice\u003c\/li\u003e\n\u003cli\u003eGoogle Sheets with a free Google account. The Google Sheets version is a real workbook you make your own copy of, not a PDF with a link in it.\u003c\/li\u003e\n\u003cli\u003eNo dynamic arrays, no macros, no add-ins and no subscription\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eWhat you download\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003eThe Excel workbook filled with a worked example\u003c\/li\u003e\n\u003cli\u003eA blank Excel workbook ready for your own entries\u003c\/li\u003e\n\u003cli\u003eThe instruction guide, which has one-click links to the Google Sheets versions (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, and the Start Here tab walks you through setup in a few minutes. The template is for personal and business use on your own devices, so please do not share or resell the files. 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\u003eCan I use it in Google Sheets as well as Excel?\u003c\/h3\u003e\u003cp\u003eYes. You download Excel workbooks for Excel 2016 or later on Windows and Mac, and the instruction guide has one-click links to make your own copy in Google Sheets with a free Google account.\u003c\/p\u003e\u003ch3\u003eHow does it decide what I should play next?\u003c\/h3\u003e\u003cp\u003eFor each series it finds the lowest-numbered game you have not finished. The answer updates as soon as you mark a game done.\u003c\/p\u003e\u003ch3\u003eHow many games can I add?\u003c\/h3\u003e\u003cp\u003eThe Backlog tab holds 400 games, and the Play Log has room for 900 sessions.\u003c\/p\u003e\u003ch3\u003eCan I set a goal for games finished this year?\u003c\/h3\u003e\u003cp\u003eYes. The Challenge tab compares games finished with your goal and works out from the date whether you are ahead or behind.\u003c\/p\u003e\u003ch3\u003eDoes it track games I want to buy?\u003c\/h3\u003e\u003cp\u003eYes. The Wishlist tab lists the games you want with a budget and shows how much of it is left.\u003c\/p\u003e","brand":"OPXVIA","offers":[{"title":"Default Title","offer_id":67597871317086,"sku":"OPX-202","price":18.0,"currency_code":"CAD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0769\/2094\/6782\/files\/video-game-backlog-tracker-01.jpg?v=1790833077"},{"product_id":"lego-collection-tracker","title":"LEGO and Model Collection Tracker Spreadsheet","description":"\u003cp\u003eThis LEGO collection tracker is for builders and collectors with shelves or a loft full of boxes and no single list of what is there. Each set gets one line with its set number, condition, where it is kept and what it is worth, and the workbook totals the lot.\u003c\/p\u003e\u003cp\u003eA sealed set and a built one are different assets, often worth very different amounts. This tracker keeps that difference on every line.\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\u003eCondition and value on every line\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003e\n\u003cstrong\u003eFive conditions\u003c\/strong\u003e as a dropdown: sealed, boxed, built, loose or no box, because on retired lego sets that one column is most of the value\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003ePaid against worth now:\u003c\/strong\u003e the gain on each set, in money and as a share of what you paid, totaled across the collection\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eThe best single line\u003c\/strong\u003e, named on the summary strip\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eAn insurance figure:\u003c\/strong\u003e the whole collection at today's value, with nothing to add up yourself\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eA lego set list you can search\u003c\/h2\u003e\u003cp\u003eTheme, subtheme and set number each have their own column, so a list of 300 sets is still easy to search a year from now. A location column records where every box lives. It works for sealed lego sets kept as an investment and for built sets on display, and for other models and any toy collection that follows the same pattern.\u003c\/p\u003e\u003ch2\u003eSix connected tabs\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003e\n\u003cstrong\u003eStart Here and Setup:\u003c\/strong\u003e a guided start and your settings\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eCollection:\u003c\/strong\u003e every set, with condition, cost and current value\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eTasks:\u003c\/strong\u003e jobs such as getting the collection insured or chasing the set that got away\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eBills:\u003c\/strong\u003e the costs that come with the hobby\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eDashboard:\u003c\/strong\u003e the whole collection on one screen, filled in automatically\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eA filled-in collection to start from\u003c\/h2\u003e\u003cp\u003eThe worked example holds 35 sets, from a large flagship set to a box of loose small cars, with a gain worked out across the whole collection and the best line named. Two sets are worth less than they cost, one reissued and one broken up for parts, which is how a real collection behaves. A blank copy is ready for yours, so you always know your lego value at a glance.\u003c\/p\u003e\u003ch2\u003eWorks with\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003eMicrosoft Excel 2016, 2019, 2021 and Microsoft 365, on Windows and Mac, and LibreOffice\u003c\/li\u003e\n\u003cli\u003eGoogle Sheets with a free Google account. The Google Sheets version is a real workbook you make your own copy of, not a PDF with a link in it.\u003c\/li\u003e\n\u003cli\u003eNo dynamic arrays, no macros, no add-ins and no subscription\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eWhat you download\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003eThe Excel workbook filled with a worked example\u003c\/li\u003e\n\u003cli\u003eA blank Excel workbook ready for your own entries\u003c\/li\u003e\n\u003cli\u003eThe instruction guide, which has one-click links to the Google Sheets versions (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, and the Start Here tab walks you through setup in a few minutes. The template is for personal and business use on your own devices, so please do not share or resell the files. 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 and Google Sheets?\u003c\/h3\u003e\u003cp\u003eYes. You download Excel workbooks for Excel 2016 or later on Windows and Mac, and the instruction guide has one-click links to make your own copy in Google Sheets with a free Google account.\u003c\/p\u003e\u003ch3\u003eDoes it look up set values for me?\u003c\/h3\u003e\u003cp\u003eNo. You type what you paid and what each set is worth now, and the file works out the gain per set and the total for insurance.\u003c\/p\u003e\u003ch3\u003eCan I record whether a set is sealed or built?\u003c\/h3\u003e\u003cp\u003eYes. Condition is a dropdown with five states: sealed, boxed, built, loose or no box.\u003c\/p\u003e\u003ch3\u003eHow many sets can I list?\u003c\/h3\u003e\u003cp\u003eThe Collection tab holds 300 sets, each with theme, subtheme, set number and where it is kept.\u003c\/p\u003e\u003ch3\u003eCan I use it for models that are not LEGO?\u003c\/h3\u003e\u003cp\u003eYes. It is a LEGO and model collection tracker, and the columns work the same way for any boxed model sets.\u003c\/p\u003e","brand":"OPXVIA","offers":[{"title":"Default Title","offer_id":67597871349854,"sku":"OPX-203","price":20.0,"currency_code":"CAD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0769\/2094\/6782\/files\/lego-collection-tracker-01.jpg?v=1790833083"},{"product_id":"sneaker-collection-tracker","title":"Sneaker Collection Tracker Spreadsheet","description":"\u003cp\u003eThis sneaker collection tracker is for sneakerheads with a wardrobe of boxes who want one list of every pair, its size, its condition and what it would fetch today. Type what you paid and what it is worth now, and the workbook works out the rest.\u003c\/p\u003e\u003cp\u003eDeadstock and worn once are different money, and the gap is usually bigger than people expect. This file records condition on every line so the value makes sense.\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\u003eCondition, size and value\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003e\n\u003cstrong\u003eFive conditions\u003c\/strong\u003e as a dropdown: deadstock, worn once, lightly worn, worn or beaters, because that column can halve what the same shoe is worth\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eSize in its own column\u003c\/strong\u003e, the first thing anyone asks and the last thing most lists record\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003ePaid against worth now:\u003c\/strong\u003e the gain per pair in money and as a share of what you paid, worked out per line\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eThe best single line\u003c\/strong\u003e, named on the summary strip\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eOne shoe inventory for the whole collection\u003c\/h2\u003e\u003cp\u003eRoom for 300 pairs, each with brand, silhouette, size and where it is kept. Clothing goes on the same list with the same columns, so a hoodie or jacket does not need a second file. Totaled together, it gives you a sneaker resale value for the whole shoe collection, ready for insurance or for deciding what to sell.\u003c\/p\u003e\u003ch2\u003eSix connected tabs\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003e\n\u003cstrong\u003eStart Here and Setup:\u003c\/strong\u003e a guided start and your settings\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eCollection:\u003c\/strong\u003e every pair and piece, with condition, cost and current value\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eTasks:\u003c\/strong\u003e getting pairs insured or chasing the one that got away\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eBills:\u003c\/strong\u003e the costs that come with the hobby\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eDashboard:\u003c\/strong\u003e the whole collection on one screen, filled in automatically\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eSee a real collection first\u003c\/h2\u003e\u003cp\u003eThe worked example holds 32 pairs and a few pieces of clothing, with the gain worked out across the lot and one pair bought at retail making up a large share of it. Two pairs are worth less than they cost, including a pair that became gardening shoes, which is what wearing them looks like as a number. A blank copy is ready for your own deadstock and daily pairs.\u003c\/p\u003e\u003ch2\u003eWorks with\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003eMicrosoft Excel 2016, 2019, 2021 and Microsoft 365, on Windows and Mac, and LibreOffice\u003c\/li\u003e\n\u003cli\u003eGoogle Sheets with a free Google account. The Google Sheets version is a real workbook you make your own copy of, not a PDF with a link in it.\u003c\/li\u003e\n\u003cli\u003eNo dynamic arrays, no macros, no add-ins and no subscription\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eWhat you download\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003eThe Excel workbook filled with a worked example\u003c\/li\u003e\n\u003cli\u003eA blank Excel workbook ready for your own entries\u003c\/li\u003e\n\u003cli\u003eThe instruction guide, which has one-click links to the Google Sheets versions (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, and the Start Here tab walks you through setup in a few minutes. The template is for personal and business use on your own devices, so please do not share or resell the files. 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\u003eCan I use it in Excel or Google Sheets?\u003c\/h3\u003e\u003cp\u003eEither. You download Excel workbooks for Excel 2016 or later on Windows and Mac, and the instruction guide has one-click links to make your own copy in Google Sheets with a free Google account.\u003c\/p\u003e\u003ch3\u003eDoes it find resale prices for me?\u003c\/h3\u003e\u003cp\u003eNo. You enter what you paid and what each pair is worth now, and the file works out the gain per pair and for the whole collection.\u003c\/p\u003e\u003ch3\u003eCan I add clothing as well as shoes?\u003c\/h3\u003e\u003cp\u003eYes. Clothing goes on the same list with the same columns, so streetwear and sneakers sit together.\u003c\/p\u003e\u003ch3\u003eHow many pairs does it hold?\u003c\/h3\u003e\u003cp\u003eThe Collection tab has room for 300 pairs, each with brand, silhouette, size, condition and where it is kept.\u003c\/p\u003e","brand":"OPXVIA","offers":[{"title":"Default Title","offer_id":67597871415390,"sku":"OPX-204","price":20.0,"currency_code":"CAD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0769\/2094\/6782\/files\/sneaker-collection-tracker-01.jpg?v=1790833089"},{"product_id":"trading-card-comic-collection-tracker","title":"Trading Card and Comic Collection Tracker","description":"\u003cp\u003eThis trading card collection tracker is for collectors of sports cards, game cards and comics who want one list with the grade, the set and the value of every item. Enter what you paid and what it is worth now, and the workbook works out the gain line by line and for the whole collection.\u003c\/p\u003e\u003cp\u003eThe same card in two different grades is really two different assets. This tracker treats grade as the valuation, so it is a dropdown on every line.\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\u003eGrade and value on every line\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003e\n\u003cstrong\u003eSix grades\u003c\/strong\u003e, from graded 10 down to raw and played\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003ePaid against worth now:\u003c\/strong\u003e the gain per line in money and as a share of what you paid, so you can see which line did the work\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eThe best single line\u003c\/strong\u003e, named on the summary strip\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eWhere each one is kept\u003c\/strong\u003e, whether in a safe, a binder or a long box\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eA card inventory that stays findable\u003c\/h2\u003e\u003cp\u003eSet, run and card number sit in separate columns, which is the only way a run stays easy to find once the list passes a hundred lines. There is room for 400 cards and comics, and comics go on the same list with the same columns as cards, so a slabbed comic and a graded card sit side by side. That makes it a comic book inventory and a list of graded cards in one file.\u003c\/p\u003e\u003ch2\u003eSix connected tabs\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003e\n\u003cstrong\u003eStart Here and Setup:\u003c\/strong\u003e a guided start and your settings\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eCollection:\u003c\/strong\u003e every card and comic, with grade, cost and current value\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eTasks:\u003c\/strong\u003e getting items graded or insured and chasing the one that got away\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eBills:\u003c\/strong\u003e the costs that come with collecting\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eDashboard:\u003c\/strong\u003e the whole collection on one screen, filled in automatically\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eA real collection to learn from\u003c\/h2\u003e\u003cp\u003eThe worked example holds 28 lines across Pokemon, basketball, football and comics, with one rookie card bought in 2016 making up a large share of the gain. A bulk lot of commons is down, a facsimile is marked as a facsimile and one rookie card is worth less than it cost, which is what real collector cards look like. A blank copy is ready for your own.\u003c\/p\u003e\u003ch2\u003eWorks with\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003eMicrosoft Excel 2016, 2019, 2021 and Microsoft 365, on Windows and Mac, and LibreOffice\u003c\/li\u003e\n\u003cli\u003eGoogle Sheets with a free Google account. The Google Sheets version is a real workbook you make your own copy of, not a PDF with a link in it.\u003c\/li\u003e\n\u003cli\u003eNo dynamic arrays, no macros, no add-ins and no subscription\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eWhat you download\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003eThe Excel workbook filled with a worked example\u003c\/li\u003e\n\u003cli\u003eA blank Excel workbook ready for your own entries\u003c\/li\u003e\n\u003cli\u003eThe instruction guide, which has one-click links to the Google Sheets versions (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, and the Start Here tab walks you through setup in a few minutes. The template is for personal and business use on your own devices, so please do not share or resell the files. 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 Google Sheets as well as Excel?\u003c\/h3\u003e\u003cp\u003eYes. You download Excel workbooks for Excel 2016 or later on Windows and Mac, and the instruction guide has one-click links to make your own copy in Google Sheets with a free Google account.\u003c\/p\u003e\u003ch3\u003eCan I record graded and raw cards?\u003c\/h3\u003e\u003cp\u003eYes. Grade is a dropdown with six options, from graded 10 to raw and played.\u003c\/p\u003e\u003ch3\u003eCan I list comics with my cards?\u003c\/h3\u003e\u003cp\u003eYes. Comics and cards go on one list with the same columns, including set, run and number.\u003c\/p\u003e\u003ch3\u003eDoes it look up card prices?\u003c\/h3\u003e\u003cp\u003eNo. You type what you paid and what each item is worth now, and the file works out the gain per line and for the whole collection.\u003c\/p\u003e\u003ch3\u003eHow many items does it hold?\u003c\/h3\u003e\u003cp\u003eThe Collection tab has room for 400 cards and comics.\u003c\/p\u003e","brand":"OPXVIA","offers":[{"title":"Default Title","offer_id":67597871448158,"sku":"OPX-205","price":20.0,"currency_code":"CAD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0769\/2094\/6782\/files\/trading-card-comic-collection-tracker-01.jpg?v=1790833094"},{"product_id":"vinyl-record-collection-tracker","title":"Vinyl Record Collection Tracker Spreadsheet","description":"\u003cp\u003eThis vinyl record collection tracker is for record collectors who want every pressing, its condition and its value in one searchable list. Type each record once with what you paid and what it is worth today, and a live dashboard shows the whole collection by genre, decade and grade.\u003c\/p\u003e\u003cp\u003eThe same album in three pressings can be three very different prices. This tracker gives the catalog number and sleeve grade their own columns so you always know which one you own.\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. It fills itself from what you enter, and a genre picker lets you view all genres or just one while the whole page follows.\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003e\n\u003cstrong\u003eGain:\u003c\/strong\u003e what the records are worth now less what you paid for them\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eRecords:\u003c\/strong\u003e how many you own, by decade, with the average worth of each\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eWorth by genre:\u003c\/strong\u003e the value of each genre and its share of the collection\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eBiggest gains:\u003c\/strong\u003e the records that have grown most since you bought them\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eMost valuable:\u003c\/strong\u003e the eight records worth the most today\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003ePaid against worth now\u003c\/strong\u003e by the year you bought each record\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eBy condition:\u003c\/strong\u003e how many records sit in each sleeve grade, mint to fair\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eWishlist and still to buy:\u003c\/strong\u003e what you still want, must-haves first, whether it is under your price, and your top prices for everything left\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eWhat sets it apart\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003e\n\u003cstrong\u003eCatalog number in its own column:\u003c\/strong\u003e a first pressing and a later reissue are the same album and different money, and the catalog number separates them\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eSleeve grade as a dropdown:\u003c\/strong\u003e six grades from mint to fair, because that is the column the price moves on\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003ePaid against worth:\u003c\/strong\u003e the gain per record in money and as a share of what you paid, with the best single line named\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eShelf location:\u003c\/strong\u003e where each record sits, which matters once the collection passes a couple of hundred\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eInside the workbook\u003c\/h2\u003e\u003cp\u003eThe connected tabs are Start Here, Setup, Collection, Wishlist, Tasks, Bills and Dashboard. The Collection tab holds 400 records with artist, label and catalog number, and the whole collection is totaled for insurance, giving you one vinyl value for everything you own. Tasks and Bills sit alongside for the jobs and costs that come with the hobby, from buying inner sleeves to a trip to a record fair.\u003c\/p\u003e\u003cp\u003eThe worked example is a music collection of 33 records, with a gain worked out on every line, so you can see how a finished album inventory reads before you start your own record inventory from the blank copy.\u003c\/p\u003e\u003ch2\u003eWorks with\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003eMicrosoft Excel 2016, 2019, 2021 and Microsoft 365, on Windows and Mac, and LibreOffice\u003c\/li\u003e\n\u003cli\u003eGoogle Sheets with a free Google account. The Google Sheets version is a real workbook you make your own copy of, not a PDF with a link in it.\u003c\/li\u003e\n\u003cli\u003eNo dynamic arrays, no macros, no add-ins and no subscription\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eWhat you download\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003eThe Excel workbook filled with a worked example\u003c\/li\u003e\n\u003cli\u003eThe same workbook, blank and ready for yours\u003c\/li\u003e\n\u003cli\u003eThe instruction guide, which has one-click links to the Google Sheets versions (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. The template is for personal and business use on your own devices, so please do not share or resell the files. 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 and Google Sheets?\u003c\/h3\u003e\u003cp\u003eYes. You download Excel workbooks for Excel 2016 or later on Windows and Mac, and the instruction guide has one-click links to make your own copy in Google Sheets with a free Google account.\u003c\/p\u003e\u003ch3\u003eCan I record different pressings of the same album?\u003c\/h3\u003e\u003cp\u003eYes. Each pressing is its own line with its catalog number, sleeve grade, price paid and value now.\u003c\/p\u003e\u003ch3\u003eDoes it look up record values for me?\u003c\/h3\u003e\u003cp\u003eNo. You type what you paid and what each record is worth now, and the workbook works out the gain and totals the collection.\u003c\/p\u003e\u003ch3\u003eHow many records can it hold?\u003c\/h3\u003e\u003cp\u003eThe Collection tab has room for 400 records with artist, label, catalog number, grade and shelf location.\u003c\/p\u003e\u003ch3\u003eCan I keep a wishlist?\u003c\/h3\u003e\u003cp\u003eYes. The dashboard shows what you still want, must-haves first, whether each is under your price and your top prices for everything left to buy.\u003c\/p\u003e","brand":"OPXVIA","offers":[{"title":"Default Title","offer_id":67597871480926,"sku":"OPX-206","price":20.0,"currency_code":"CAD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0769\/2094\/6782\/files\/vinyl-record-collection-tracker-01.jpg?v=1790833100"},{"product_id":"coin-stamp-collection-tracker","title":"Coin and Stamp Collection Tracker Spreadsheet","description":"\u003cp\u003eThis coin collection tracker is for anyone with a cabinet of coins, an album of stamps, or both, who has never added the whole thing up. Each piece goes on one line with its country, year, grade and value, and a dashboard turns the list into a valuation you can insure.\u003c\/p\u003e\u003cp\u003eGrade accounts for most of a coin's value and the year for much of the rest, yet both usually live in someone's memory. Here they are columns.\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; it fills itself from your list. Choose Whole collection, Coins or Stamps and the page follows.\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003e\n\u003cstrong\u003ePieces:\u003c\/strong\u003e how many you hold, from how many countries, by era from before 1850 onward\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eWinners and losers:\u003c\/strong\u003e the five biggest gains, then every piece worth less than you paid and by how much\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eBy country:\u003c\/strong\u003e pieces, paid, worth and gain for each country\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eGold and silver:\u003c\/strong\u003e what the precious metal pieces are worth and their share of the whole\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eGrade by grade:\u003c\/strong\u003e what you paid and what it is worth, proof down to worn\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eMetal and paper:\u003c\/strong\u003e the value held in gold, silver, base metal and paper\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eWhere it is kept:\u003c\/strong\u003e what sits in the safe, in each album and in each drawer\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eWhat sets it apart\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003e\n\u003cstrong\u003eSix grades, proof down to worn:\u003c\/strong\u003e without grade, a log is a list of things you own rather than a valuation\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eThe year in its own column:\u003c\/strong\u003e the other half of identifying a coin, and the first thing a dealer asks\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eCoins and stamps on one list:\u003c\/strong\u003e they share the same eleven columns, so one file covers your stamp collection too\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eAn insurance figure:\u003c\/strong\u003e the whole collection value at today's prices, with nothing to add up\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eInside the workbook\u003c\/h2\u003e\u003cp\u003eSix connected tabs: Start Here, Setup, Collection, Tasks, Bills and Dashboard. The Collection tab holds 400 pieces with country, series and year, a location such as cabinet, album or safe, what you paid and what each is worth now. The gain is shown per piece and as a share of what you paid, and the best single line is named. Tasks and Bills sit alongside for grading, insurance and the costs of the hobby.\u003c\/p\u003e\u003cp\u003eThe worked example holds 25 pieces across sovereigns, bullion, crowns, pre-decimal coins and four stamp albums, including facsimiles marked as such and a couple of pieces now worth less than they cost. Study it, then build your own coin inventory from the blank copy.\u003c\/p\u003e\u003ch2\u003eWorks with\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003eMicrosoft Excel 2016, 2019, 2021 and Microsoft 365, on Windows and Mac, and LibreOffice\u003c\/li\u003e\n\u003cli\u003eGoogle Sheets with a free Google account. The Google Sheets version is a real workbook you make your own copy of, not a PDF with a link in it.\u003c\/li\u003e\n\u003cli\u003eNo dynamic arrays, no macros, no add-ins and no subscription\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eWhat you download\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003eThe Excel workbook filled with a worked example\u003c\/li\u003e\n\u003cli\u003eThe same workbook, blank and ready for yours\u003c\/li\u003e\n\u003cli\u003eThe instruction guide, which has one-click links to the Google Sheets versions (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. The template is for personal and business use on your own devices, so please do not share or resell the files. 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\u003eCan I use it in Google Sheets instead of Excel?\u003c\/h3\u003e\u003cp\u003eYes. You download Excel workbooks for Excel 2016 or later on Windows and Mac, and the instruction guide has one-click links to make your own copy in Google Sheets with a free Google account.\u003c\/p\u003e\u003ch3\u003eCan I track coins and stamps in the same file?\u003c\/h3\u003e\u003cp\u003eYes. Coins and stamps share the same columns on one list, and the dashboard can show the whole collection, coins only or stamps only.\u003c\/p\u003e\u003ch3\u003eWhat grades can I choose?\u003c\/h3\u003e\u003cp\u003eSix grades from a dropdown, from proof down to worn.\u003c\/p\u003e\u003ch3\u003eDoes it look up coin prices?\u003c\/h3\u003e\u003cp\u003eNo. You enter what you paid and what each piece is worth now, and the workbook works out the gains and the total for insurance.\u003c\/p\u003e\u003ch3\u003eHow many pieces does it hold?\u003c\/h3\u003e\u003cp\u003eThe Collection tab has room for 400 pieces, each with country, series, year, grade and where it is kept.\u003c\/p\u003e","brand":"OPXVIA","offers":[{"title":"Default Title","offer_id":67597871513694,"sku":"OPX-207","price":20.0,"currency_code":"CAD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0769\/2094\/6782\/files\/coin-stamp-collection-tracker-01.jpg?v=1790833106"},{"product_id":"wine-cellar-spirits-collection-tracker","title":"Wine and Spirits Collection Tracker Spreadsheet","description":"\u003cp\u003eThis wine cellar spreadsheet is for collectors with a rack of bottles laid down and a few they are nervous about opening. Every bottle of wine or spirits goes on one line with producer, region, vintage, its state and its value, and the dashboard tells you what is ready to drink.\u003c\/p\u003e\u003cp\u003eA cellar is the one collection meant to be enjoyed, so the real question is not only what it is worth but whether tonight is the night.\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. It fills itself from your list, and you can pick Whole cellar, red, white, whisky or any type and the page follows.\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003e\n\u003cstrong\u003eReady to drink:\u003c\/strong\u003e bottles inside their window now, and those to drink by next year\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eReady, year by year:\u003c\/strong\u003e how many bottles you could open in each of the next twelve years\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eWhat to open first:\u003c\/strong\u003e anything past its best first, then by drink-by year\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003ePast their best:\u003c\/strong\u003e bottles past their drink-by year, and what they are worth\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eBottles and vintages:\u003c\/strong\u003e every bottle you hold, the average value of one, and bottles by vintage from before 2000 onward\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eGain:\u003c\/strong\u003e what the cellar is worth now over what you paid\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eBy type and by region:\u003c\/strong\u003e value across red, white, sparkling, fortified, sweet and spirits, and the regions worth most\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eWhat sets it apart\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003e\n\u003cstrong\u003eCost against worth on every bottle\u003c\/strong\u003e, with the gain totaled and shown as a share of what you paid\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eFive states:\u003c\/strong\u003e in the rack, drinking now, laying down, opened or gone, which makes it a drinking window rather than a stock count\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eGone stays on the list\u003c\/strong\u003e at zero, so the cellar log keeps a record of every bottle you have enjoyed\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eWhisky on the same list:\u003c\/strong\u003e a whisky collection uses the same eleven columns as your wine\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eInside the workbook\u003c\/h2\u003e\u003cp\u003eThe connected tabs are Start Here, Setup, the main cellar list, Tasks, Bills and Dashboard. The main list holds 300 bottles with producer, region, vintage and where each bottle is kept, and the best single line is named. Tasks and Bills sit alongside for everything else the cellar needs.\u003c\/p\u003e\u003cp\u003eThe worked example is a 30-bottle wine inventory across Bordeaux, Burgundy, the Rhone, port and a shelf of whisky, with two bottles recorded as gone. Explore it, then start your own bottle inventory from the blank copy.\u003c\/p\u003e\u003ch2\u003eWorks with\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003eMicrosoft Excel 2016, 2019, 2021 and Microsoft 365, on Windows and Mac, and LibreOffice\u003c\/li\u003e\n\u003cli\u003eGoogle Sheets with a free Google account. The Google Sheets version is a real workbook you make your own copy of, not a PDF with a link in it.\u003c\/li\u003e\n\u003cli\u003eNo dynamic arrays, no macros, no add-ins and no subscription\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eWhat you download\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003eThe Excel workbook filled with a worked example\u003c\/li\u003e\n\u003cli\u003eThe same workbook, blank and ready for yours\u003c\/li\u003e\n\u003cli\u003eThe instruction guide, which has one-click links to the Google Sheets versions (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. The template is for personal and business use on your own devices, so please do not share or resell the files. 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 and Google Sheets?\u003c\/h3\u003e\u003cp\u003eYes. You download Excel workbooks for Excel 2016 or later on Windows and Mac, and the instruction guide has one-click links to make your own copy in Google Sheets with a free Google account.\u003c\/p\u003e\u003ch3\u003eCan I track whisky and other spirits as well as wine?\u003c\/h3\u003e\u003cp\u003eYes. Wine and spirits share the same columns on one list, and the dashboard can show the whole cellar or any single type.\u003c\/p\u003e\u003ch3\u003eHow does it show what is ready to drink?\u003c\/h3\u003e\u003cp\u003eEach bottle has a drinking window and one of five states. The dashboard lists bottles ready now, those to drink by next year and anything past its best.\u003c\/p\u003e\u003ch3\u003eWhat happens when I drink a bottle?\u003c\/h3\u003e\u003cp\u003eMark it as gone. It stays on the list at zero value, so you keep a record of it.\u003c\/p\u003e\u003ch3\u003eHow many bottles does it hold?\u003c\/h3\u003e\u003cp\u003eRoom for 300 bottles, each with producer, region, vintage, state and where it is kept.\u003c\/p\u003e","brand":"OPXVIA","offers":[{"title":"Default Title","offer_id":67597871546462,"sku":"OPX-208","price":22.0,"currency_code":"CAD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0769\/2094\/6782\/files\/wine-cellar-spirits-collection-tracker-01.jpg?v=1790833112"},{"product_id":"youth-sports-team-roster-tracker","title":"Youth Sports Team Roster Tracker Spreadsheet","description":"\u003cp\u003eThis team roster tracker is for volunteer coaches and team managers running a youth sports squad through a season. It works out fair playing time, keeps attendance one session at a time and shows which families still owe the season fee.\u003c\/p\u003e\u003cp\u003eEvery youth coach eventually hears the question of whether a child is getting a fair go. The Playing Time tab answers it with numbers: minutes on the field against a fair share of the minutes available, over the games each player actually attended.\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 Whole team or one player and the whole page follows.\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003e\n\u003cstrong\u003eAttendance:\u003c\/strong\u003e across the season, with a bar for every session\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eThe squad:\u003c\/strong\u003e shirt, name, position, attendance, minutes and fees for every player\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eWho came:\u003c\/strong\u003e players at every game and practice, and the sessions a player missed\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eMinutes, game by game,\u003c\/strong\u003e against the fair share, with anyone under your line in soft red\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eBy position:\u003c\/strong\u003e how the squad splits across positions\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eFees:\u003c\/strong\u003e money collected week by week, what is still owed, and by how many players\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eWhat sets it apart\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003e\n\u003cstrong\u003eFair minutes, worked out:\u003c\/strong\u003e a column per game with each player's minutes. The tab calculates a fair share for everyone who turned up, adds it up across the season and flags anyone below the line you set on Setup\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eEvery game checked:\u003c\/strong\u003e minutes logged are compared with game length times players on the field, so a typo shows up the day you make it\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eAttendance:\u003c\/strong\u003e Y or N per player for each session, with a rate per player, a count at each session, and games shaded apart from practices\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eTeam fees:\u003c\/strong\u003e the season fee comes from Setup, a discount can be typed over it, and payments add up on the roster\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eSeven connected tabs\u003c\/h2\u003e\u003cp\u003eStart Here, Setup, Roster, Attendance, Playing Time, Payments and Dashboard. Children's details are kept to a first name, a position and a parent to call. The worked example is an eight-week spring soccer roster for a fourteen-player under-11 side, with practice twice a week and a game on Saturday: 24 sessions, 8 games, two players flagged for low minutes and three families still owing fees. It is a ready coaching template and attendance tracker you can adapt to any sport and season.\u003c\/p\u003e\u003ch2\u003eWorks with\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003eMicrosoft Excel 2016, 2019, 2021 and Microsoft 365, on Windows and Mac, and LibreOffice\u003c\/li\u003e\n\u003cli\u003eGoogle Sheets with a free Google account. The Google Sheets version is a real workbook you make your own copy of, not a PDF with a link in it.\u003c\/li\u003e\n\u003cli\u003eNo dynamic arrays, no macros, no add-ins and no subscription\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eWhat you download\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003eThe Excel workbook filled with a worked example\u003c\/li\u003e\n\u003cli\u003eThe same workbook, blank and ready for yours\u003c\/li\u003e\n\u003cli\u003eThe instruction guide, which has one-click links to the Google Sheets versions (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. The template is for personal and business use on your own devices, so please do not share or resell the files. 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 and Google Sheets?\u003c\/h3\u003e\u003cp\u003eYes. You download Excel workbooks for Excel 2016 or later on Windows and Mac, and the instruction guide has one-click links to make your own copy in Google Sheets with a free Google account.\u003c\/p\u003e\u003ch3\u003eHow is a fair share of playing time worked out?\u003c\/h3\u003e\u003cp\u003eFor each game, the tab shares the available minutes among the players who turned up, adds each player's share across the season and compares it with the minutes they actually played.\u003c\/p\u003e\u003ch3\u003eIs it only for soccer?\u003c\/h3\u003e\u003cp\u003eNo. The example is a youth soccer team, but you set the game length and players on the field, so it works for other team sports too.\u003c\/p\u003e\u003ch3\u003eCan it track season fees and discounts?\u003c\/h3\u003e\u003cp\u003eYes. The season fee comes from Setup, a discount such as a sibling rate can be typed over it, and the dashboard lists who still owes.\u003c\/p\u003e\u003ch3\u003eWhat personal details does it store?\u003c\/h3\u003e\u003cp\u003eOnly a first name, a position and a parent to call for each child.\u003c\/p\u003e","brand":"OPXVIA","offers":[{"title":"Default Title","offer_id":67597872300126,"sku":"OPX-218","price":14.0,"currency_code":"CAD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0769\/2094\/6782\/files\/youth-sports-team-roster-tracker-01.jpg?v=1790833170"}],"url":"https:\/\/opxviashop.com\/collections\/hobbies-collections.oembed","provider":"OPXVIA","version":"1.0","type":"link"}