Could someone please check my calcs for this kettle-efficiency spreadsheet? - Home Brew Forums
Home Brew Forums > Home Brewing Beer > All Grain & Partial Mash Brewing > Could someone please check my calcs for this kettle-efficiency spreadsheet?

Reply
 
Thread Tools
Old 04-03-2008, 08:29 AM   #1
denimglen
Recipes 
 
Feb 2006
Auckland, New Zealand
Posts: 438
Liked 1 Times on 1 Posts



Hello all,

I've just roughed up a spreadsheet on Excel to use during the brewday to adjust gravity one way or another if it's too high/low.

Basically just follow the flow chart entering in the values as necessary.

If the gravity is too low then you can calculate the extract to add or the length of the boil to reach the correct gravity at a smaller volume.

If the gravity is too high then you can calculate a how much to dilute the kettle to before boiling to reach a larger volume at the correct gravity.

Also, the second worksheet in the spreadsheet is used to figure out the L or Gal per hour boil off.

There's probably something out there already that does these calcs but it was interesting making it.

Anyways, I was wondering if some of you guys/gals could check over the calculations to see if they're all OK, I've punched in a few sets of numbers and it seems to be good but it would be awesome if someone else could check it out.

Link to file: http://rapidshare.com/files/104491668/brewday.xlsx.html
Cheers and beers,


Glenim.



 
Reply With Quote
Old 04-03-2008, 01:45 PM   #2
Soperbrew
Who rated my beer?
HBT_LIFETIMESUPPORTER.png
 
Soperbrew's Avatar
Recipes 
 
Feb 2008
Chandler, Arizona
Posts: 2,452
Liked 90 Times on 84 Posts


Explain the GU/Mass input in the add extract box.

 
Reply With Quote
Old 04-04-2008, 05:24 AM   #3
denimglen
Recipes 
 
Feb 2006
Auckland, New Zealand
Posts: 438
Liked 1 Times on 1 Posts


Thanks, should say points per pound per gallon.

Cheers.

 
Reply With Quote
Reply
Thread Tools


Similar Threads
Thread Thread Starter Forum Replies Last Post
Efficiency analysis spreadsheet Kaiser All Grain & Partial Mash Brewing 52 11-04-2009 09:29 PM
Check out this huge kettle agroff383 Equipment/Sanitation 2 04-03-2009 12:37 AM
How to I check my efficiency? pnj All Grain & Partial Mash Brewing 7 03-12-2009 07:44 PM
Efficiency Check... yeqmaster All Grain & Partial Mash Brewing 5 01-08-2009 01:15 PM
How to check efficiency?? BG73395 All Grain & Partial Mash Brewing 4 03-06-2007 07:11 PM


Forum Jump