Coldbreak Brewing HERMS Giveaway!

HomeBrewSupply AMCYL Brew Kettle Giveaway!


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
Feedback Score: 0 reviews
Recipes 
 
Join Date: Feb 2006
Location: Auckland, New Zealand
Posts: 438
Liked 1 Times on 1 Posts
Likes Given: 1

Default Could someone please check my calcs for this kettle-efficiency spreadsheet?

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.


denimglen is offline
 
Reply With Quote
Old 04-03-2008, 01:45 PM   #2
Soperbrew
Who rated my beer?
HBT_LIFETIMESUPPORTER.png
Feedback Score: 0 reviews
 
Soperbrew's Avatar
Recipes 
 
Join Date: Feb 2008
Location: Chandler, Arizona
Posts: 2,728
Liked 89 Times on 83 Posts
Likes Given: 29

Default

Explain the GU/Mass input in the add extract box.
Soperbrew is offline
 
Reply With Quote
Old 04-04-2008, 05:24 AM   #3
denimglen
Feedback Score: 0 reviews
Recipes 
 
Join Date: Feb 2006
Location: Auckland, New Zealand
Posts: 438
Liked 1 Times on 1 Posts
Likes Given: 1

Default

Thanks, should say points per pound per gallon.

Cheers.
denimglen is offline
 
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

Newest Threads

LATEST SPONSOR DEALS