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