Saturday, September 1, 2012

Craft Beer Total Value Ranking

As you may be aware, the purpose of this blog is to educate people as to the merits of drinking well made, delicious beer, but with a focus on "value." Out of this philosophy was born a formula (driven by my borderline obsessive desire to quantify everything) to help determine which beers to buy when price is of importance. Here is the link to the google doc that contains the spreadsheet with my rankings: https://docs.google.com/spreadsheet/ccc?key=0AiX9C2t4i6JcdGNpTnFnZ3lTVDlmWkhUaE45SzVObGc#gid=0.

A few notes:
  • Keep in mind that the Total Value Ranking is HUGELY subjective. In fact, as I will explain, the only objective parts of the formula are the price and the alcohol content. 
  • While alcohol content is a part of the equation, and this may seem to promote "getting drunk," please consider a portion of my audience. That is, I want to reach out to people who use beer primarily as means to catch a buzz, but yearn for something more from their beer. Indeed for almost all beer drinkers, the alcohol itself is a rich and integral part of the drinking experience. 
  • Remember, this is about getting the "most" for your dollar!
Here's how the final formula works:
  1. I record the beer name, the price, how many 12oz beer equivalents you get for that price (6 pack=6 beers, 22oz Bomber=1.833 beers, etc.) and the abv of that beer.
  2. Functions embedded in the cells for that beer's row then calculate the number of standard drinks you receive by purchase that particular pack, and subsequently, the price per drink.
  3. I then record either my subjective rating for the beer (on a scale of 0-5) or the beeradvocate.com rating avg. This is then used to normalize the price per drink value for taste of the beer. 
  4. When all these values are put into the spreadsheet or calculated, the beers are ranked based on Cost (price of the pack/bottle), Price/Drink, Normalized Price/Drink and Taste. 
  5. The Total Value Rating is then calculated as a compilation of these 4 rankings. The final Ranking is weighted as follows: 20% Price, 25% Price/Drink, 35% Normalized Price/Drink and 20% Taste.
Hopefully you enjoy this; it is in no way meant to be the final word on craft beer but rather one man's opinion. It is also subject to change... often... as I tweak the rankings and the weighting system. Finally I plan on updating it frequently as I try new beers (the bold beers in the first column are ones that I haven't tried yet) and I may or may not open up the document for public editing. 

As always feel free to ask away if you have any questions, comments, compliments or criticisms!