{"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","url":"https:\/\/opxviashop.com\/products\/video-game-backlog-tracker","provider":"OPXVIA","version":"1.0","type":"link"}