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