Inventory Mishap

CellarTracker Main Site

Inventory Mishap

View related threads: (in this forum | in all forums)

Logged in as: Guest

Users viewing this topic: none

Printable Version

All Forums >> [Cellar Talk] >> General Discussion >> Inventory Mishap

Page: [1]

Message

<< Older Topic Newer Topic >>

Inventory Mishap - 6/25/2008 6:28:59 PM

apes

Posts: 165
Joined: 1/29/2008
From: CT
Status: offline

So, admitting I have time on my hands and tend to be a little anal (better word?) about some things, I came across a problem today, which led to an idea. I currently have an inventory of almost 300 wines, all stored and inventoried (by bins) in a wine cellar. While checking my inventory on CT I found that I have (according to CT) a couple of bottles in the same bin number. Now that is obviously impossible, but instead of correcting the problem I have decided to locate the misplaced bottle and drink it. So, I think I will try and do an inventory check once a month, and when I find an error, I will open that bottle that night. Should make inventory day a little more fun.
Well, maybe not if it's too young

Post #: 1

RE: Inventory Mishap - 6/25/2008 10:25:16 PM

Blue Shorts

Posts: 316
Joined: 2/5/2008
From: Santa Cruz, California
Status: online

I've done that on a few occasions. A couple of times it was a cellartracker glitch. it seems that when I used to track front and back it would not sort properly.

I used to track using a system of 01A2 for row 1, column A, back. When I would sort, it would mess up. I now onit the last position and all is fine. I suppose I should have mentioned it to Eric, but didn't.

_____________________________

The best wine is the one that you haven't yet tried.

(in reply to apes)

Post #: 2

RE: Inventory Mishap - 6/26/2008 1:58:42 PM

RoundersRob

Posts: 745
Joined: 7/1/2006
From: Santa Cruz, CA
Status: online

A couple of months ago I was reorganizing my cabinet and found a bottle of Vieux Chateau Certan down in the bottom corner that wasn't anywhere in my inventory. It was like getting a surprise christmas present.

(in reply to apes)

Post #: 3

RE: Inventory Mishap - 6/26/2008 4:53:01 PM

GalvezGuy

Posts: 320
Joined: 5/10/2007
From: Galveston, TX
Status: offline

I love those type of surprises. I have found that I have more of some wine than I thought I had. The last time it happened was with my 96 Montrose.

_____________________________

If you're gonna be dumb you better be tough

(in reply to RoundersRob)

Post #: 4

RE: Inventory Mishap - 6/26/2008 7:42:10 PM

Blue Shorts

Posts: 316
Joined: 2/5/2008
From: Santa Cruz, California
Status: online

Those are good problems to have. I hate the opposite... where you think you have one bottle of something you love, only to find out that you don't

_____________________________

The best wine is the one that you haven't yet tried.

(in reply to GalvezGuy)

Post #: 5

RE: Inventory Mishap - 6/26/2008 8:29:33 PM

Paul S

Posts: 504
Joined: 1/15/2008
From: Singapore
Status: offline

Haha, yes! My last accident was a good one - thought I had drank all my Dead Arm 2005 up save for one solitary bottle that I am saving, but I found out that I have a pair instead.

(in reply to Blue Shorts)

Post #: 6

RE: Inventory Mishap - 7/4/2008 9:34:17 AM

last chance

Posts: 8
Joined: 3/20/2007
From: Issaquah, WA
Status: offline

So am I the only one that has to use the "Missing and presumed drunk" option then? For the wine that is... I hate using that one, but at least it makes me smile when I have to.

(in reply to Paul S)

Post #: 7

RE: Inventory Mishap - 7/4/2008 12:20:37 PM

rjonas

Posts: 148
Joined: 11/5/2006
From: Newcastle, WA
Status: online

Nope, you're not alone.. I've used the "Missing or presumed drunk" option a couple of times.. Once when I was pulled out another bottle, I found one of the "missing or presumed drunk" bottles.. So happy to add it back to inventory!

FWIW, I have an excel-based macro that I got from another CT member a couple of years ago that assigns my inventory based on bins. I use a similar method that Blue Shorts described (mine goes 01A-F (row 1 column 1 Front)) and then I have a count blank/non-blank function that tells me if my inventory count matches what I have in CT inventory.

Works well for me and keeps the "missing or presumed drunk" items down to a minimum...

(in reply to last chance)

Post #: 8