Efficiency analysis spreadsheet - Home Brew Forums
Home Brew Forums > Home Brewing Beer > All Grain & Partial Mash Brewing > Efficiency analysis spreadsheet

Reply
 
Thread Tools
Old 03-10-2009, 01:31 PM   #1
Kaiser
 
Kaiser's Avatar
Recipes 
 
Nov 2005
Pepperell, MA
Posts: 3,895
Liked 127 Times on 73 Posts



Last night I finally took the time and implemented my methods for analyzing efficiency losses on the way to the kettle in a spread sheet. Give it a try if you are curious about a breakdown of your efficiency: http://braukaiser.com/documents/efficiency_calculator.xls

Kai



 
Reply With Quote
Old 03-10-2009, 01:37 PM   #2
babalu87
Recipes 
 
Feb 2008
Middleborough, MA
Posts: 1,895
Liked 8 Times on 7 Posts


Great stuff Kai!

Damn, I really have to try and find a sitter for the kids on the 28th



 
Reply With Quote
Old 03-10-2009, 01:53 PM   #3
dstar26t
If it's worth doing, it's worth overdoing
HBT_SUPPORTER.png
Recipes 
 
Jan 2008
Ridley Park, PA
Posts: 1,152
Liked 56 Times on 41 Posts


Kaiser,
Are you assuming a moisture content for the grain to calculate the potential gravity?
__________________
Next: ?
Fermenting: Azacca Oat Pilsner, Egregious-ish, Barrel Fermented Dreg DelcoLambic, Sacch Trois Helles
Drinking: RIS v7, Doppelbock, RIS v6, Carrot Blossom Cedar Mead, Sauerkraut Fermented Gose, Gueuze, Brett Blonde, Kriek, Saison, Sour Blonde
Barrel aged: Rye Barleywine, Tripel, Wee-Heavy

 
Reply With Quote
Old 03-10-2009, 01:59 PM   #4
Kaiser
 
Kaiser's Avatar
Recipes 
 
Nov 2005
Pepperell, MA
Posts: 3,895
Liked 127 Times on 73 Posts


Quote:
Originally Posted by dstar26t View Post
Kaiser,
Are you assuming a moisture content for the grain to calculate the potential gravity?
No, so far I have been neglecting the moisture issue. I know that it skews the gravity potential but I find it hard to measure. Maybe I should add a field for that.

Thanks,
Kai

 
Reply With Quote
Old 03-10-2009, 02:02 PM   #5
Coastarine
We get it, you hate BMC.
HBT_LIFETIMESUPPORTER.png
 
Coastarine's Avatar
Recipes 
 
Apr 2008
New Bern, NC
Posts: 2,516
Liked 25 Times on 22 Posts


Sweet! Now I'm going to be playing with my refractometer all through the sacc rest!
__________________
SEMPER FIDELIS ET SEMPER PARATUS Bringin' the 'pane...the propane.Coming Up:..[Hefewiezen][BCS Robust Porter][EdWort's Haus Pale Ale][Peated Ale]
Fermenting:.
Conditioning:[Oaked Cider][ESB]
On Tap.........[The Munchner][Spiced Cider][English Cider][Simcoe IPA][Triple Hops Grooved][Cider'n 'gnac]

 
Reply With Quote
Old 03-10-2009, 02:08 PM   #6
Kaiser
 
Kaiser's Avatar
Recipes 
 
Nov 2005
Pepperell, MA
Posts: 3,895
Liked 127 Times on 73 Posts


Quote:
Originally Posted by Coastarine View Post
Sweet! Now I'm going to be playing with my refractometer all through the sacc rest!
Plotting the gravity every 10 - 15 min is a nice exercise that tells you a lot how conversion progresses durng the sacc rest. It can also show you if you can expect further gains from longer mashing.

Kai

 
Reply With Quote
Old 03-10-2009, 02:22 PM   #7
dstar26t
If it's worth doing, it's worth overdoing
HBT_SUPPORTER.png
Recipes 
 
Jan 2008
Ridley Park, PA
Posts: 1,152
Liked 56 Times on 41 Posts


Kaiser,

Can I send you my spreadsheet? My efficiency into kettle is different than yours by 5% and I'm not sure why. I don't think I agree with the way you calculate the 100% extract efficiency gravity for the grain (your total extract weight - C21 on the "detailed calculations" sheet).

Nate
__________________
Next: ?
Fermenting: Azacca Oat Pilsner, Egregious-ish, Barrel Fermented Dreg DelcoLambic, Sacch Trois Helles
Drinking: RIS v7, Doppelbock, RIS v6, Carrot Blossom Cedar Mead, Sauerkraut Fermented Gose, Gueuze, Brett Blonde, Kriek, Saison, Sour Blonde
Barrel aged: Rye Barleywine, Tripel, Wee-Heavy


 
Reply With Quote
Old 03-10-2009, 02:28 PM   #8
Coastarine
We get it, you hate BMC.
HBT_LIFETIMESUPPORTER.png
 
Coastarine's Avatar
Recipes 
 
Apr 2008
New Bern, NC
Posts: 2,516
Liked 25 Times on 22 Posts


Quote:
Originally Posted by Kaiser View Post
Plotting the gravity every 10 - 15 min is a nice exercise that tells you a lot how conversion progresses durng the sacc rest. It can also show you if you can expect further gains from longer mashing.

Kai
That leads somewhat into my next question; which is can I expect 100% conversion? Also, I know that some extract should be expected to be left in the spent grain to avoid getting unpleasant stuff from the grain, what would be a reasonable target value? 5 or 10% maybe?
__________________
SEMPER FIDELIS ET SEMPER PARATUS Bringin' the 'pane...the propane.Coming Up:..[Hefewiezen][BCS Robust Porter][EdWort's Haus Pale Ale][Peated Ale]
Fermenting:.
Conditioning:[Oaked Cider][ESB]
On Tap.........[The Munchner][Spiced Cider][English Cider][Simcoe IPA][Triple Hops Grooved][Cider'n 'gnac]

 
Reply With Quote
Old 03-10-2009, 02:29 PM   #9
BuzzCraft
Recipes 
 
Jan 2009
Blacksburg, VA
Posts: 426
Liked 1 Times on 1 Posts


Very nice....thanks for doing this.

 
Reply With Quote
Old 03-10-2009, 03:01 PM   #10
Kaiser
 
Kaiser's Avatar
Recipes 
 
Nov 2005
Pepperell, MA
Posts: 3,895
Liked 127 Times on 73 Posts


Quote:
Originally Posted by dstar26t View Post
Can I send you my spreadsheet? My efficiency into kettle is different than yours by 5% and I'm not sure why. I don't think I agree with the way you calculate the 100% extract efficiency gravity for the grain (your total extract weight - C21 on the "detailed calculations" sheet).
Sure, that's the kind of feedback I'm looking for as well.

Kai



 
Reply With Quote
Reply
Thread Tools


Similar Threads
Thread Thread Starter Forum Replies Last Post
Hop profiles spreadsheet MattHollingsworth Recipes/Ingredients 5 02-13-2011 07:03 PM
how to use spreadsheet Stubbs5150 Brew Science 2 08-30-2009 08:26 PM
AG spreadsheet? Does it exist? perkins98 All Grain & Partial Mash Brewing 7 03-31-2009 08:22 PM
spreadsheet shrades Mead Forum 7 01-20-2009 12:57 AM
Could someone please check my calcs for this kettle-efficiency spreadsheet? denimglen All Grain & Partial Mash Brewing 2 04-04-2008 05:24 AM


Forum Jump