Kegconnection Complete Starter Kit and More Giveaway!


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

Reply
 
LinkBack 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 Quick reply to this message
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,584
Liked 63 Times on 62 Posts
Likes Given: 11

Default

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

__________________
Soperbrew is offline
 
Reply With Quote Quick reply to this message
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 Quick reply to this message
Reply


Quick Reply
Message:
Options
Thread Tools


Similar Threads
Thread Thread Starter Forum Replies Last Post
Efficiency analysis spreadsheet Kaiser All Grain & Partial Mash Brewing 52 11-04-2009 08: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 12:15 PM
How to check efficiency?? BG73395 All Grain & Partial Mash Brewing 4 03-06-2007 06:11 PM