Port Inventory

This forum is for discussing all things Port (as in from PORTugal) - vintages, recommendations, tasting notes, etc.

Moderators: Glenn E., Roy Hersh, Andy Velebil

Post Reply
User avatar
Gary Richardson
Posts: 341
Joined: Wed Dec 26, 2007 5:37 pm
Location: Clarksville, Maryland, United States of America - USA

Port Inventory

Post by Gary Richardson »

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?
Mahmoud Ali
Posts: 495
Joined: Sat Nov 22, 2008 6:50 am
Location: Edmonton, Alberta, Canada

Re: Port Inventory

Post by Mahmoud Ali »

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.
Moses Botbol
Posts: 6037
Joined: Wed Aug 30, 2006 7:38 am
Location: Boston, USA

Re: Port Inventory

Post by Moses Botbol »

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
User avatar
Glenn E.
Posts: 8383
Joined: Wed Jan 23, 2008 10:49 am
Location: Sammamish, Washington, United States of America - USA
Contact:

Re: Port Inventory

Post by Glenn E. »

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
Moses Botbol
Posts: 6037
Joined: Wed Aug 30, 2006 7:38 am
Location: Boston, USA

Re: Port Inventory

Post by Moses Botbol »

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.
I use to have a spreadsheet and for the same reason as Glenn; gave it up.
Welsh Corgis | F1 |British Cars
User avatar
Gary Richardson
Posts: 341
Joined: Wed Dec 26, 2007 5:37 pm
Location: Clarksville, Maryland, United States of America - USA

Re: Port Inventory

Post by Gary Richardson »

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.
User avatar
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

Post by Andy Velebil »

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
User avatar
Eric Ifune
Posts: 3535
Joined: Tue Aug 02, 2005 8:02 pm
Location: Las Vegas, Nevada, United States of America - USA

Re: Port Inventory

Post by Eric Ifune »

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.
Eric Menchen
Posts: 6679
Joined: Wed Sep 24, 2008 9:48 pm
Location: Longmont, Colorado, United States of America - USA

Re: Port Inventory

Post by Eric Menchen »

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.)
User avatar
John M.
Posts: 2162
Joined: Fri Feb 27, 2009 2:15 pm
Location: Hunterdon County, New Jersey, USA

Re: Port Inventory

Post by John M. »

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!
Gerwin de Graaf
Posts: 367
Joined: Thu Jul 02, 2009 12:56 pm
Location: Sprundel, Netherlands

Re: Port Inventory

Post by Gerwin de Graaf »

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 :D ) 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.
User avatar
Gary Richardson
Posts: 341
Joined: Wed Dec 26, 2007 5:37 pm
Location: Clarksville, Maryland, United States of America - USA

Re: Port Inventory

Post by Gary Richardson »

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 :D ) 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.
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.
LOUISSS J
Posts: 114
Joined: Wed Dec 30, 2015 7:09 pm
Location: St-Hubert, Québec, Canada

Re: Port Inventory

Post by LOUISSS J »

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.
Post Reply