Keeping track of your port
- SushiNorth
- Martinez 1985
- Posts: 1341
- Joined: 07:45 Mon 18 Feb 2008
- Location: NJ & NY
Keeping track of your port
(I looked through our back conversations for this, but finding nothing I figured I'd ask...)
What do you use to keep track of your port/wine collection? It's clearly important, as we don't want to go disturbing bottles as we search for the right one.
I looked at several, but in the end opted for expanding my excel spreadsheet. Here were my criteria:
1) Offline. I don't want to worry about a service going down or dealing with offers.
2) Data flexibility. I want to be able to import and export easily, and re-arrange to my tastes
3) Storage tracking. I need to know which bottles are where, ideally as a chart of the racks.
4) bottle-by-bottle tracking: I want to know which bottles I have, when i acquired them, for what price and from whom.
5) Tasting notes: Mine, and the reviewers.
6) Shopping Chart: In one glance, what I've got and what the rating is for anything on a retailer's shelf.
I looked at software, but anything under $30 was worthless and anything over that wasn't worth a bottle of port . If anyone had suggestions, I'm still willing to try out software. Alternatively, if anyone wants the spreadsheet I'm happy to share. The trickiest part is the tasting notes, as excel isn't set up well for them, and the shopping chart as most of the ratings I have to enter individually. (This whole thing started as a giant exercise to tag my cellar, add more shelves, and generally get organized. I've a photo of some of that, coming soon)
What do you use to keep track of your port/wine collection? It's clearly important, as we don't want to go disturbing bottles as we search for the right one.
I looked at several, but in the end opted for expanding my excel spreadsheet. Here were my criteria:
1) Offline. I don't want to worry about a service going down or dealing with offers.
2) Data flexibility. I want to be able to import and export easily, and re-arrange to my tastes
3) Storage tracking. I need to know which bottles are where, ideally as a chart of the racks.
4) bottle-by-bottle tracking: I want to know which bottles I have, when i acquired them, for what price and from whom.
5) Tasting notes: Mine, and the reviewers.
6) Shopping Chart: In one glance, what I've got and what the rating is for anything on a retailer's shelf.
I looked at software, but anything under $30 was worthless and anything over that wasn't worth a bottle of port . If anyone had suggestions, I'm still willing to try out software. Alternatively, if anyone wants the spreadsheet I'm happy to share. The trickiest part is the tasting notes, as excel isn't set up well for them, and the shopping chart as most of the ratings I have to enter individually. (This whole thing started as a giant exercise to tag my cellar, add more shelves, and generally get organized. I've a photo of some of that, coming soon)
Re: Keeping track of your port
I've got a very long term project where I'm writing my own localized PC application using c# using all those pretty windows boxes, or maybe i'll do it in java.
I don';t know yet but I've got a data model written on a piece of paper and I have in mind the same concerns as you when thinking about this.
I don';t know yet but I've got a data model written on a piece of paper and I have in mind the same concerns as you when thinking about this.
Disclosure: Distributor of Quevedo wines and Quinta do Gomariz
-
- Quinta do Vesuvio 1994
- Posts: 3032
- Joined: 22:16 Mon 25 Jun 2007
- Location: Los Angeles, Ca USA
- Contact:
Re: Keeping track of your port
probably the best program out there is called Cellar Tracker, its free or you can pay a little and get wine critics reviews. I think it is now the single largest database for peoples TN's inthe world. I've used it for several years and love it.
http://www.cellartracker.com
http://www.cellartracker.com
Re: Keeping track of your port
I just use an Excel spreadsheet. I also have a CellarTracker account but fail miserably when it comes to keeping it up to date.
I don't really see the point in using complicated software for this unless you have a commercial cellar.
Derek
I don't really see the point in using complicated software for this unless you have a commercial cellar.
Derek
"The first duty of Port is to be red"
Ernest H. Cockburn
Ernest H. Cockburn
Re: Keeping track of your port
Perhaps you could make it state side so we could argue the merits of having a sophisticated cellar application =)
Disclosure: Distributor of Quevedo wines and Quinta do Gomariz
Re: Keeping track of your port
That would have to involve the opening and drinking of a number of well documented bottles of port, obviouslyg-man wrote:Perhaps you could make it state side so we could argue the merits of having a sophisticated cellar application =)
"The first duty of Port is to be red"
Ernest H. Cockburn
Ernest H. Cockburn
- SushiNorth
- Martinez 1985
- Posts: 1341
- Joined: 07:45 Mon 18 Feb 2008
- Location: NJ & NY
Re: Keeping track of your port
Someone did ask for this spreadsheet, btw, so I'm tuning it up to make it easier to share. Meanwhile, I mentioned this whole thing came about because of a cellar reorg... here I am somewhere in the midst of it (new shelves, some new bottles on the left, lots of tags, etc. There's another 35 bottles of port in the wine fridge (out of view), but together that's the cellar.
- RonnieRoots
- Fonseca 1980
- Posts: 1981
- Joined: 08:28 Thu 21 Jun 2007
- Location: Middle Earth
Re: Keeping track of your port
Like Andy, I've been using CellarTracker for a couple of years now, and I'm very happy with it. It can give you just about any piece of information that you want, and it's very easy to maintain.
- JacobH
- Quinta do Vesuvio 1994
- Posts: 3300
- Joined: 16:37 Sat 03 May 2008
- Location: London, UK
- Contact:
Re: Keeping track of your port
I tend only to note what I’ve drunk, with any relevant TNs and ratings, rather than what’s currently in the cellar. I use an XML file which is then turned into a webpage with an XSL-style-sheet so I can consult it when I’m scratching my head, inside the wine merchant, trying to work out what I’ve had in the past and if it’s any good! I quite like this method as it means it’s easy to add extra elements (the equivalent of a spreadsheet column) for individual odd bottles, though getting everything to work nicely together took some time!
-Jacob
-Jacob
Re: Keeping track of your port
CellarTracker is the best and most professional software for maintaining a wine cellar. Period. It has more bells and whistles than anybody could possibly conceive of using, but it is very simple for the person just looking for basic cellar management software. Disclosure: the inventor is a very close friend and in my STG tasting group. Nonetheless, with nearly 60,000 users storing almost 10 million bottles ... nothing even comes remotely close!
Roy Hersh
http://www.fortheloveofport.com
http://www.fortheloveofport.com
Re: Keeping track of your port
I'm using Wine XT which is a nifty little program for the Mac.
Frequently Ask Questions
- RonnieRoots
- Fonseca 1980
- Posts: 1981
- Joined: 08:28 Thu 21 Jun 2007
- Location: Middle Earth
Re: Keeping track of your port
I tried that as well, but ended up liking CellarTracker better. But I agree it's a good program.Rubby wrote:I'm using Wine XT which is a nifty little program for the Mac.
- Alex Bridgeman
- Graham’s 1948
- Posts: 14915
- Joined: 13:41 Mon 25 Jun 2007
- Location: Berkshire, UK
Re: Keeping track of your port
I also use an Excel spreadsheet, but since I started loading pictures into the spreadsheet it has become quite large and slow to load and save. Soon, I am going to have to make a choice to either move to Cellar Tracker (which I like for the ability to access via the web) or to remove the pictures and store them separately.
But I don't have to decide just yet.
But I don't have to decide just yet.
Top Ports in 2023: Taylor 1896 Colheita, b. 2021. A perfect Port.
2024: Niepoort 1900 Colheita, b.1971. A near perfect Port.
2024: Niepoort 1900 Colheita, b.1971. A near perfect Port.
- mosesbotbol
- Warre’s Otima 10 year old Tawny
- Posts: 598
- Joined: 19:54 Wed 18 Jul 2007
- Location: Boston, USA
Re: Keeping track of your port
I am doing nothing right now
I like the spreadsheet idea initally and then move to Cellar Tracker or something. I would like a web based solution as I keep wine in a couple of locations and want to have a single data source.
Port is coming and going so quick, I think my list would never be 100% acurate.
I like the spreadsheet idea initally and then move to Cellar Tracker or something. I would like a web based solution as I keep wine in a couple of locations and want to have a single data source.
Port is coming and going so quick, I think my list would never be 100% acurate.
F1 | Welsh Corgi | Did Someone Mention Port?
Re: Keeping track of your port
looking through my mini fridges for the fonsecas for tasting the other day I was very much surprised to find ...
a Taylor 2003, a Taylor 77 and a Dow 94 that I totally forgot about!!!!
Decanting the taylor 77 tongiht!
a Taylor 2003, a Taylor 77 and a Dow 94 that I totally forgot about!!!!
Decanting the taylor 77 tongiht!
Disclosure: Distributor of Quevedo wines and Quinta do Gomariz
- Alex Bridgeman
- Graham’s 1948
- Posts: 14915
- Joined: 13:41 Mon 25 Jun 2007
- Location: Berkshire, UK
Re: Keeping track of your port
I love little surprises like that! That's why, despite tracking my port on a spreadsheet, I still carry out a stocktake once a year or so.g-man wrote:looking through my mini fridges for the fonsecas for tasting the other day I was very much surprised to find ...
a Taylor 2003, a Taylor 77 and a Dow 94 that I totally forgot about!!!!
Decanting the taylor 77 tonight!
Top Ports in 2023: Taylor 1896 Colheita, b. 2021. A perfect Port.
2024: Niepoort 1900 Colheita, b.1971. A near perfect Port.
2024: Niepoort 1900 Colheita, b.1971. A near perfect Port.
Re: Keeping track of your port
Following two instances in which AHB, allowed in my father’s cellar without my close supervision, failed to find what should have been there, I too did a stock take. Nine bottles of Cockburn 1970, said my spreadsheet. Three were in the rack. “Someone’s been eating my porridge†, growled the Papa bear. Thinks: I bought 17 at that auction, and 2 at that auction, and a single or two in mixed lots. We drank six on such-and-such a date, and eight a year later. And a few singles here and there. Nine is starting to sound optimistic.AHB wrote:I love little surprises like that! That's why, despite tracking my port on a spreadsheet, I still carry out a stocktake once a year or so.
Alas all such surprises were of the non-good variety. C’est la vie.
- SushiNorth
- Martinez 1985
- Posts: 1341
- Joined: 07:45 Mon 18 Feb 2008
- Location: NJ & NY
Re: Keeping track of your port
Heh, i find the trouble is not remembering to add them to the list, it's remembering (in either inebriated or hungover state) to take them off!
- uncle tom
- Dalva Golden White Colheita 1952
- Posts: 3520
- Joined: 23:43 Wed 20 Jun 2007
- Location: Near Saffron Walden, England
Re: Keeping track of your port
I think there are two philosophies to choose from here.
1) Stock manage perfectly, and know exactly what you have and where it is.
2) Buy when the whim to do so inspires you, stow the bottles safely and forget all about them. Then, years later, when browsing for a bottle to drink, discover them afresh to your pleasant surprise.
Option 1) is the choice of the cold, computer assisted, (but cellar limited..) age
Option 2) enjoys a little old word romance, but is intrinsically chaotic!
I must admit that option 2) used to be my preferred way; but was abandoned when i kept finding that after taking home a litle stash, my pleasure was dashed by the discovery that I had already bought the same wine some time before, and had clean forgotton about it...
I now give every bottle a neck tag (a cut down luggage tag) which I find usually holds secure after two half-hitches, but is infallible if given three..
Each tag carries a three digit number followed by a letter. The number is the case number, the letter represents the bottle in the case. If I only bought one bottle of a wine, I still allocate a case number, and the letter will be 'A'
Each rack in my cellar is given a number, each column in that rack is given a letter, and each row in the rack is given a number. This gives me a reference.
Each case gets a line on my main stock database, and each line links to a separate 'case notes' file, derived from a template
On my main stock database, the date of purchase, source, date, shipper, type, format, vintage, quantity, quantity consumed, price and storage location are recorded. Detail regarding condition, levels and drinking history are recorded on the case notes file.
Thus the most recent addition to my cellar records were two bottles.
The main database notes that they were purchased from Christies on July 14th. they were Warre vintage port bottles from 1963, and that the two of them cost me £70. They have been stored in rack 7, column D, rows 17-18 (07D17)
In the case notes file is recorded that they were English bottled by Berry Bros, have only neck tags to confirm identification, and were part of a mixed lot with cost apportioned.
Within the case notes file, each bottle has a dedicated line, which at this point notes the levels to be IN (both of them) and the last date of inspection (31/08/2008) Space is provided for tasting notes to be recorded for each bottle.
Simple!
Tom
1) Stock manage perfectly, and know exactly what you have and where it is.
2) Buy when the whim to do so inspires you, stow the bottles safely and forget all about them. Then, years later, when browsing for a bottle to drink, discover them afresh to your pleasant surprise.
Option 1) is the choice of the cold, computer assisted, (but cellar limited..) age
Option 2) enjoys a little old word romance, but is intrinsically chaotic!
I must admit that option 2) used to be my preferred way; but was abandoned when i kept finding that after taking home a litle stash, my pleasure was dashed by the discovery that I had already bought the same wine some time before, and had clean forgotton about it...
I now give every bottle a neck tag (a cut down luggage tag) which I find usually holds secure after two half-hitches, but is infallible if given three..
Each tag carries a three digit number followed by a letter. The number is the case number, the letter represents the bottle in the case. If I only bought one bottle of a wine, I still allocate a case number, and the letter will be 'A'
Each rack in my cellar is given a number, each column in that rack is given a letter, and each row in the rack is given a number. This gives me a reference.
Each case gets a line on my main stock database, and each line links to a separate 'case notes' file, derived from a template
On my main stock database, the date of purchase, source, date, shipper, type, format, vintage, quantity, quantity consumed, price and storage location are recorded. Detail regarding condition, levels and drinking history are recorded on the case notes file.
Thus the most recent addition to my cellar records were two bottles.
The main database notes that they were purchased from Christies on July 14th. they were Warre vintage port bottles from 1963, and that the two of them cost me £70. They have been stored in rack 7, column D, rows 17-18 (07D17)
In the case notes file is recorded that they were English bottled by Berry Bros, have only neck tags to confirm identification, and were part of a mixed lot with cost apportioned.
Within the case notes file, each bottle has a dedicated line, which at this point notes the levels to be IN (both of them) and the last date of inspection (31/08/2008) Space is provided for tasting notes to be recorded for each bottle.
Simple!
Tom
I may be drunk, Miss, but in the morning I shall be sober and you will still be ugly - W.S. Churchill
- SushiNorth
- Martinez 1985
- Posts: 1341
- Joined: 07:45 Mon 18 Feb 2008
- Location: NJ & NY
Re: Keeping track of your port
That's what did it for me.uncle tom wrote:I must admit that option 2) used to be my preferred way; but was abandoned when i kept finding that after taking home a litle stash, my pleasure was dashed by the discovery that I had already bought the same wine some time before, and had clean forgotton about it...
I understand the logic in this (batching the bottles that came together into a "case") but for me I skip that level of distinction, each bottle gets a row. I use inexpensive manila stockcard tags, prestrung, that I purchase at a local office supply store (Staples). I record House, SQVP or type (where applicable), vintage, purchase date, purchase store, store location (city/state/country), and price paid (before tax).uncle tom wrote:I now give every bottle a neck tag (a cut down luggage tag) ...Each tag carries a three digit number followed by a letter. The number is the case number, the letter represents the bottle in the case.
The same data is recorded into the spreadsheet, along with rack cluster, rack name, and slot number: RShelves-3Front-5.
I don't use ID numbers for the bottles, though I'd considered it, since the tags are detailed and I keep the location synchronized enough that it becomes a unique ID.
And you'll all be happy to know that my recent acquisitions included one more Graham's 80 (to make 3), and Graham's 83 for the upcoming offline
Re: Keeping track of your port
i guess it also depends on the size of the cellar, I've got a miniscule 200 bottles that warrants the pleasure of finding forgotten treasures =)
Disclosure: Distributor of Quevedo wines and Quinta do Gomariz
- uncle tom
- Dalva Golden White Colheita 1952
- Posts: 3520
- Joined: 23:43 Wed 20 Jun 2007
- Location: Near Saffron Walden, England
Re: Keeping track of your port
Why do you Americans have such a hatred of tax inclusive prices?and price paid (before tax).
You go to the US, buy something that has a nice round price tag, and then get a few percent of sales tax added that leaves you with a pocket full of change..
..the reason why is probably related to the reason for having a 10c coin that is half the size of the 5c...
Tom
I may be drunk, Miss, but in the morning I shall be sober and you will still be ugly - W.S. Churchill
Re: Keeping track of your port
...and we have a 5p that is about one quarter the size of a 2puncle tom wrote: ..the reason why is probably related to the reason for having a 10c coin that is half the size of the 5c...
"The first duty of Port is to be red"
Ernest H. Cockburn
Ernest H. Cockburn
-
- Quinta do Vesuvio 1994
- Posts: 3032
- Joined: 22:16 Mon 25 Jun 2007
- Location: Los Angeles, Ca USA
- Contact:
Re: Keeping track of your port
At least we don't have that huge VAT. My tax is only 8.25% or 7.75% depending on what side of the County line I buy on.
Still havn't figured out why we have a penny these days...totally annoying when i have a pocket full of them.
Still havn't figured out why we have a penny these days...totally annoying when i have a pocket full of them.
Re: Keeping track of your port
Put 300 of them in a sock and take it with you the next time you meet some bad guys at 3amAndy V wrote:Still havn't figured out why we have a penny these days...totally annoying when i have a pocket full of them.
"The first duty of Port is to be red"
Ernest H. Cockburn
Ernest H. Cockburn