Bordeaux Wine Enthusiasts

A post that caught my eye on the Square's board was a listing of the average vintage of wines in member's cellars. It pushed my excel skills to the limit, but I managed (I think) to do the calculation and got 1999.78 from 38 vintages. Younger than I thought.

I wonder what Francois' would be?

stefan

Surely you are signed up to cellartracker, stefan, no?
In ten seconds there I got my answer:
2002.2 from 18 vintages.

No, I am wedded to my excel file, Jim.

stefan

My few bottles of NV Champagne skewed my formula. I show 487 different wines, with a mean average age of 2006, a median of 2005, and the oldest being a 1982 Leonetti Cab (Washington State).
------------------------
EDIT: I discovered a wine entered in my Excel spreadsheet with the 2995 vintage.....the corrected mean average is 2004.3, with 16 vintages.

I wonder how much my 1918 Haut Brion affected my 935 bottle cellar....

I would guess my average to be somewhere in the vicinity of 1996, with one bottle of 1845 Madeira included.

Glenn

JimHow wrote:Surely you are signed up to cellartracker, stefan, no?
In ten seconds there I got my answer:
2002.2 from 18 vintages.

What a coincidence, my cellar is 2002.1 from 21 vintages. Thank goodness for Cellartracker.

2000.6 in 32 vintages. Weird anomoly I would not have expected: just one bottle of wine from vintage 1990.

Ok. Now I'm curious about my own cellar. Back shortly with an answer (from an Excel file, like Stefan).

Jon

Without the aid of Cellar Tracker, I had to use the old fashioned Excel method. It turns out that my average vintage is 2001.2 from 1424 bottles over 25 vintages (not including NV). I was a little surprised by that average until I realized it was influenced by 21.7% of my bottles being from 2005 - largely impacted by Burgundy purchases from that vintage.

Jon

2000.2 in 27 vintages.

2001.07 in sixteen vintages.

I thought that older wines would bring my average age down, but on further inspection I see that I have only 65 bottles from before 1980, the oldest being from 1959. Most of the post 2000 wines I have are in case lots.

Clearly I need to enter the auction market.

stefan

1999 in 31 vintages, no doubt influenced by heavy Bordeaux buying in 2005 and heavy Rhone buying in 2007.

My median bottle is even younger (2000). My median wine (so that multiple bottles carry no weight) is from 1998.

Before doing this, I thought my collection was older. This gives me an excuse to buy more older wine.

stefan

Average vintage of bottle: 1992
Median vintage by bottle : 1995 (sense, since the older vintages go back a lot farther)

Average vintage of wine: 1991 (just slightly fewer of the older bottles)
Median vintage of wine : 1993

I'm happy with these numbers, given what's in the cellar (Bordeaux, Barolo and Barbaresco, red Burgs, Sauternes, Port, ...), although Gail seems to think we have a lot of wine going OTH to her taste...