9 replies to this topic

[chuck_d]

Do any of you guys use software or a spreadsheet to keep track of your current cellar inventory?  I just got back from Asheville with a haul, and am updating my spreadsheet when I figured their must be some software out there for this.  I love my spreadsheets, so I'll probably end up keep using Excel with my own homegrown solution, but I like to mine software packages for features that I can implement.  So is anyone using anything to do this?  Or if you are building your own spreadsheet for this, what all do you include and how do you organize it?

 

Cheers,

chuck_d

Edited by chuck_d, 28 March 2016 - 10:46 PM.

[SchwanzBrewer]

I have a ton of commerical beer in my fridge at the house. Every time I go to the liquor store I try and pick up something I've never tried. Mostly belgian beers. I am way too lazy to track what I have so I just pick something and put it on untapped when I've tried it.

 

I suspect you can get a bar code app or something like that that will keep track of your inventory easily on your phone.

[HVB]

I just use my head.  There are only a few types of beer I care about cellering these days and they are mostly sours.  I can pretty much remember what I have down there.

[neddles]

I just use my head.  There are only a few types of beer I care about cellering these days and they are mostly sours.  I can pretty much remember what I have down there.

Pretty much this. I wish I had enough that I could't keep track of it but, alas...

[positiveContact]

I believe I have 2 commercial beers at my house right now

[HVB]

Pretty much this. I wish I had enough that I could't keep track of it but, alas...

I probably have about 50 or so various bottles of sours.  Because some are rare or hard to come by I know what the heck I have down there.

 

 

I believe I have 2 commercial beers at my house right now

 

I wish I could say that ..lol

[positiveContact]

maybe start selling some of the stuff you've got?

[HVB]

maybe start selling some of the stuff you've got?

I have considered that and a few of the bottles will fetch a lot of money (I have seen some of the bottles I have pull down $2-300 or more) but I also have reservations and instead plan to have another large sour tasting.  I do not mind keeping sour beers, they age very well.  Many of the other beers I had cellared did not fair as well.

[chuck_d]

I've got 3 coolers dedicated to beer storage in our dining room.  A chest freezer, a lockable wine cooler where my precious items go, and this thing that used to be my kegerator which has a slightly larger footprint than a dorm fridge and is like 2.5x as tall: https://dieseldrafts...rew-draft-beer/

 

In addition, I also have a bunch of bottles in a closet.  So I've easily got over 100 bottles in my "cellar".  I dream of a house with a basement where I can build a walk-in climate controlled cellar for storing my beers.

 

Last night I just created a spreadsheet with the following columns:

Brewery, Beer, Style, ABV, OG, Volume, Package, Quantity, Purchased, Packaged, Best By, Best After, For Trade?, Notes

 

Purchased & Packaged are dates as well as Best By & Best After

 

[cavman]

Cellarhq is popular, but like Drew said most don't age that well. I would only keep lambic for long periods.