Wednesday, June 6, 2007

Who's this Guy?

Joe Dougherty is a homebrewer with professional aspirations in West Philly who is quickly becoming enveloped by his hobby-turned-obsession.

Follow him as he makes some beers, drinks some beers, and occasionally makes an interesting point amongst what will probably turn out to be largely tangential pontification.

That being said, the first order of business is to share a tool that I frequently use to make calculations for the beers I brew. (
Download it) This spreadsheet calculates the following:
  • Original Gravity (all-grain, extract, or a combination of the two)
  • Final Gravity (based on theoretical apparent attenuation rate)
  • ABV%
  • IBU contributions from 6 possible hop additions (using Tinseth Calculations)

As mentioned on the spreadsheet itself, the gravity calculations are averages based on figures as per Ray Daniel's Designing Great Beers (Brewers Publications, 2000). Likewise, the IBU calculations are adapted from the ever-useful Glenn Tinseth's Hop Page. I intend to add some more features (GU:BU ratio is the first to come to mind) in the future. I'll be sure to update as these features are added.

It is obviously not as detailed as a utility like BeerTools, but it will give you some quick 'n dirty numbers so that you have a vague idea of what you're doing (much like myself).

1 comment:

Brew Dude John said...

Hey Joe,

Cool spreadsheet. I downloaded it and I will give it a try when I start formulating my Porter recipe.