I recently deiced to a brew a recipe from the Brew Like a Monk book but I ran into a problem. The recipe was listed in percent of grain needed for the total grain bill.
Belgian Pilsner 60%
Wheat Malt 40%
Of course that is a very basic example because the one listed in the book had about 7 ingredients in the grain bill. After a bit of thought I remember that Designing Great Beers has the information on how to calculate the needed pounds of grain but who wants to do that by hand every time.So I created a spreadsheet that will do all the math for you. You have to enter a few things to get the right output.
What needs to be entered: (all measurements are in US units. I might add metric units if I get enough requests)
An example of what the spreadsheet looks like is below and also there is a link to download the sheet. If you use the sheet and have any feedback please let me know. I also ask that if you want to share the sheet please link to this page and not directly to the download.
|Genrate Lbs from Percentv1.1.xls||36 KB|