Page 1 of 1

Port Inventory

Posted: Fri Nov 25, 2016 8:49 pm
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?

Re: Port Inventory

Posted: Sat Nov 26, 2016 4:42 am
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.

Re: Port Inventory

Posted: Sat Nov 26, 2016 6:39 am
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!

Re: Port Inventory

Posted: Sat Nov 26, 2016 9:47 am
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.

Re: Port Inventory

Posted: Sat Nov 26, 2016 10:14 am
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.

Re: Port Inventory

Posted: Sat Nov 26, 2016 6:12 pm
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.

Re: Port Inventory

Posted: Sun Nov 27, 2016 12:24 am
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.

Re: Port Inventory

Posted: Sun Nov 27, 2016 6:55 am
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.

Re: Port Inventory

Posted: Mon Nov 28, 2016 2:21 pm
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.)

Re: Port Inventory

Posted: Mon Nov 28, 2016 6:30 pm
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.

Re: Port Inventory

Posted: Wed Nov 30, 2016 2:17 am
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.

Re: Port Inventory

Posted: Wed Nov 30, 2016 7:57 am
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.

Re: Port Inventory

Posted: Thu Jan 05, 2017 1:19 pm
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.