Port Inventory
Moderators: Glenn E., Roy Hersh, Andy Velebil
- Gary Richardson
- Posts: 341
- Joined: Wed Dec 26, 2007 5:37 pm
- Location: Clarksville, Maryland, United States of America - USA
Port Inventory
Somehow, about a year ago, my cellar mapping chart that I maintain in Excel became different from my inventory list that I also maintain in Excel. Of course, that drove me crazy every time I pulled a bottle. Tonight, I finally fixed it. I was off by a 1965 Delaforce Colheita and 2 1987 Souza VPs. Glad to have it fixed as now I can sleep soundly again.
Anyone else have a similar experience?
Anyone else have a similar experience?
-
- Posts: 495
- Joined: Sat Nov 22, 2008 6:50 am
- Location: Edmonton, Alberta, Canada
Re: Port Inventory
I would update my 10 year-old Excel cellar list if I thought it would garner me a 1965 Delaforce Colheita and couple of 1987 Souza VPs.
Mahmoud.
Mahmoud.
-
- Posts: 6037
- Joined: Wed Aug 30, 2006 7:38 am
- Location: Boston, USA
Re: Port Inventory
I don't keep any inventory, so each time I go down to the cellar, I am surprised by the discoveries I find!
Welsh Corgis | F1 |British Cars
- Glenn E.
- Posts: 8383
- Joined: Wed Jan 23, 2008 10:49 am
- Location: Sammamish, Washington, United States of America - USA
- Contact:
Re: Port Inventory
I used to keep an inventory in Cellartracker, but that got out of date and rapidly became useless. So I no longer bother and now I'm much more like Moses. I do still have a pretty good picture in my head, but occasionally find something that surprises me.
Glenn Elliott
-
- Posts: 6037
- Joined: Wed Aug 30, 2006 7:38 am
- Location: Boston, USA
Re: Port Inventory
I use to have a spreadsheet and for the same reason as Glenn; gave it up.Glenn E. wrote:I used to keep an inventory in Cellartracker, but that got out of date and rapidly became useless. So I no longer bother and now I'm much more like Moses. I do still have a pretty good picture in my head, but occasionally find something that surprises me.
Welsh Corgis | F1 |British Cars
- Gary Richardson
- Posts: 341
- Joined: Wed Dec 26, 2007 5:37 pm
- Location: Clarksville, Maryland, United States of America - USA
Re: Port Inventory
So how do you all know what you have and what to drink? Or do you just dig around when you are ready to open a bottle? I would think after you get above 100 bottles or so, you would need some kind of inventory system.
- Andy Velebil
- Posts: 16811
- Joined: Tue Aug 02, 2005 4:49 pm
- Location: Los Angeles, California, United States of America - USA
- Contact:
Re: Port Inventory
I use Cellartracker. works pretty good. I know a few things still listed in inventory are missing, consumed, whatever. I just live with it and don't verify anything until I actually pull it from the cellar and have it in hand. I'd estimate the miss-inventoried is not more than 8-12 bottles, so not the end of the world if my inventory is off a little.
Andy Velebil Good wine is a good familiar creature if it be well used. William Shakespeare http://www.fortheloveofport.com
- Eric Ifune
- Posts: 3535
- Joined: Tue Aug 02, 2005 8:02 pm
- Location: Las Vegas, Nevada, United States of America - USA
Re: Port Inventory
I still use WineWin. I believe it was the earliest computer based tracking system. It came on floppy disks. Still works although not nearly as easy as Cellar Tracker.
-
- Posts: 6679
- Joined: Wed Sep 24, 2008 9:48 pm
- Location: Longmont, Colorado, United States of America - USA
Re: Port Inventory
I use CellarTracker, and appreciate that I can easily access it wherever I may be, say at a tasting. I also keep an Excel spreadsheet that shows where the bottles are located, because while CellarTracker has a location field, that isn't so easy to update when I want move bottles. The Excel thing is laid out with grids for each rack. Once or twice a year, usually during shipping season, I rectify the two to account for things that may have been missed in one or the other. For the last three years they've been off by one bottle which I can't seem to track down. (It could be something like a "temp probe" entry, but I think I have those properly accounted for.)
Re: Port Inventory
I have under 100 bottles so I use an EXCEL sheet. Works fine...sometimes its off a little but I always know the important ones.
Any Port in a storm!
-
- Posts: 367
- Joined: Thu Jul 02, 2009 12:56 pm
- Location: Sprundel, Netherlands
Re: Port Inventory
I use an excell spreadsheet to keep my wine and port inventory. There I keep all records and information on my ports, as wel as the location in my cellar (a grid system specifies the location). Ihave a little over 600 bottles of port in total (including those that are meant for my two boys, so there not all mine to drink
) of which are 500+ VP. And I fnd that excell still works well for me. Only my tastingnotes or other tekst information on the wine/port I keep in tekst files. In the excell sheet there's a link to the notes and stuff.

- Gary Richardson
- Posts: 341
- Joined: Wed Dec 26, 2007 5:37 pm
- Location: Clarksville, Maryland, United States of America - USA
Re: Port Inventory
Thanks. That is pretty much the same thing I do. But, I keep all of my tasting notes, "wish list" of Ports I would like to try, inventory and cellar location all in Excel. I find it to be useful, just frustrating when my inventory and cellar location files become different from each other.Gerwin de Graaf wrote:I use an excell spreadsheet to keep my wine and port inventory. There I keep all records and information on my ports, as wel as the location in my cellar (a grid system specifies the location). Ihave a little over 600 bottles of port in total (including those that are meant for my two boys, so there not all mine to drink) of which are 500+ VP. And I fnd that excell still works well for me. Only my tastingnotes or other tekst information on the wine/port I keep in tekst files. In the excell sheet there's a link to the notes and stuff.
Re: Port Inventory
I all keep in an Excel program that I have made. I can't live without it.
With this i have all the bottles i have (port, wine and beer), the year i should drink the port (it changes sometimes) end my notes when i drink a bottle.
It helps to know what i have and what i should drink... and it probably help to be patient.
With this i have all the bottles i have (port, wine and beer), the year i should drink the port (it changes sometimes) end my notes when i drink a bottle.
It helps to know what i have and what i should drink... and it probably help to be patient.