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