HBT 2015 Big Giveaway - Enter Now

Huge Supporting Membership Discounts - 20% Off

 Home Brew Forums > Could someone please check my calcs for this kettle-efficiency spreadsheet?
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

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.

Cheers and beers,

Glenim.

__________________

04-03-2008, 01:45 PM   #2
Soperbrew
Who rated my beer?
Feedback Score: 0 reviews

Recipes

Join Date: Feb 2008
Location: Chandler, Arizona
Posts: 2,664
Liked 71 Times on 70 Posts
Likes Given: 22

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

__________________

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

Thanks, should say points per pound per gallon.

Cheers.

__________________