There’s been a bit of discussion recently about how people keep track of their cellars which seems to fall into 2 main camps… Cellartracker vs. Spreadsheet. I did tinker with CT for a while but eventually found a spreadsheet served my purposes better. In the spirit of sharing and learning I’m sure there are people here with interesting ways of building spreadsheets to track various things and thought it would be good to compare notes? I’m happy to kick things off.
My spreadsheet has evolved over the last few years and got a bit more fancy over time. Currently, the main column headings are…
Producer, Wine ,Colour, Country, Category, Grape Composition, Vintage, Source, Cost (EP), Cost (DP), Delivery, Stock Expected, Stock Added, Stock Remaining, Total Stock, % of cellar, Location, Drinking Window (years), Position in Drinking Window, % Maturity.
The function of most of those are obvious, but as it keeps a record of all wines bought whether physically in hand yet or not then delivery and stock expected are helpful. As is Location as some wines are physically in my cellar in Sweden, some in Reserves in TWS and some not yet delivered from EP campaigns.
I also have a graphical representation of drinking window and position within that window so I can keep an eye on when things are reaching maturity - and some of the columns do that in number/% form as well.
Overall, it looks like this…
Would love to hear how others keep track of cellars outside of Cellartracker? I can’t be the only geek on here!