OK, I'm setting up my new cellar.  The issue for me is that the racks are all two deep.  Since I normally track in Excel, I'm not sure how to track bottle positions.  Does anyone else here have the same problem?  Normally, I would track something in the top left in A1, the row below it in A2, etc.  But with two bottles per position, should A1 be the front (or back?) of the top left position, and the bottle in the back(front?) in A2.  Or should I track front and back bottles on different sheets?

 

Granted, this is an extremely geeky question.  How would you solve this problem?

Joe - If I could do that, sure.  But excel only allows one entry in cell A1.  So, if I keep the front bottles on a different sheet than the back bottles, that would work.  Or like kpak, keeping them offset byt the number of rows (interesting approach).

 

I'm going to divide my cellar into 4 quadrants (aren't you glad I didn't say a different number of quadrants?) .  One quadrant will be whites, one will be cabs, one Pinot/Syrah, and the fourth will be meritage.

 

Incidentally, I have the 1900 bottle model... and it really only holds 1528 in the racks.   The remaining area is not sufficient to hold an additional 30 cases, unless you have no interest in being able to access your wine.  This is deceptive advertising.   

That is an interesting approach. Are you building a map of the cellar?  In my spreadsheet there is no cell "A1".  Doing what Joe suggests I might have two entries:
Bob's Pinot bin A1

Randy's Cab bin A1

 

I've never thought to search by bin number

It'll do exactly what you want, eh?  I know, I know.  You "creative" guys are used to doing all the hard work and then having someone in Redmond figure out how to make it a little better and go to market with it, eh?   

Excel will allow more than one entry in Cell A1.  What I do is label the slots in my racks as 1-16, going from top to bottom, and A-E going from left to right.  The bottle in the front of slot 1A is listed in CellarTracker (and in my wine inventory list) as 1A-F. (With the "F" signifyng "Front".)  The wine behind it is 1A-B ("Back").  Unlike Bob, I do not always pair up my wines.  The one in front could be a Pinot, and the one in back a Cab.  But if I do have the same wine paired up in the same slot, then the entry would say 1A-FB indicating that this particular wine is in both the front and back.

 

 In the visual spreadsheet that I have created, I type in the name of the wine in the front first, and then just keep hitting the space bar until the cursor drops down to the next line of text. (You have to have your cell alignment set to "wrap text"). This way you can get more than one wine in each cell.

 

When I am all done, my wine list will read:

This tells me that I have 5 bottles at $75, and they are stored as follows: two bottles in slot 1A in both the front and back positions; one bottle in the front of slot 2B, and two bottles in slot 4D in both the front and back positions. 

 

On my visual spreadsheet, Cell 1A will read:

 

Cell 2-B might read:

Take a look at www.cellartracker.com as all the work has already been done.

 

No affiliation other than using it for my own cellar.

 

Jeff