Spreadsheet for brew calculations - Home Brew Forums
Register Now For Free!

Home Brew Forums > Home Brewing Beer > Brewing Software > Spreadsheet for brew calculations

Thread Tools
Old 07-29-2013, 08:10 PM   #1
Jul 2013
Chicago, IL
Posts: 1

I signed up for an account (finally) just to upload this for others. Essentially, I took the calculations from either John Palmer's "How to Brew" and from The Morey equation. I then found what I believed to be a fairly comprehensive table for malts and their respective gravity and Lovibond from BYO.com. I also compliled a list of hop varieties and their average alpha acid %. What results is a fairly simple (if somewhat limited to additions/edits) spreadsheet to use for calculating PPG, efficiency, SRM, IBUs, and other totals.

Any feedback is welcomed, and if this proves to be valuable, I will work on creating a web based solution to host somewhere. I think this sort of thing should be free, and not so hard to locate on the web.

I hope you enjoy it, or at least find it interesting.


Reply With Quote
Thread Tools

Similar Threads
Thread Thread Starter Forum Replies Last Post
Water Report and Using How to Brew Spreadsheet gunner11 Beginners Beer Brewing Forum 0 03-16-2010 04:59 AM
Brew Planner Spreadsheet BA_from_GA Brewing Software 5 01-24-2010 04:33 AM
Help with 1st brew - calculations etc. monkeydan Beginners Beer Brewing Forum 3 01-20-2010 07:33 PM
Brew Day Spreadsheet jcarson83 General Beer Discussion 11 02-23-2007 01:56 PM
Brew Notes / Spreadsheet Indiana Red General Techniques 5 12-01-2006 03:11 AM

Forum Jump