Happy HolidaySs Giveaway - Winners Re-Re-Re-Drawn - 24 hours to Claim!

Get your HBT Growlers, Shirts and Membership before the Rush!


Home Brew Forums > Home Brewing Beer > All Grain & Partial Mash Brewing > Efficiency analysis spreadsheet
Reply
 
LinkBack Thread Tools
Old 03-10-2009, 02:31 PM   #1
Kaiser
Feedback Score: 0 reviews
 
Kaiser's Avatar
Recipes 
 
Join Date: Nov 2005
Location: Pepperell, MA
Posts: 3,904
Liked 114 Times on 71 Posts
Likes Given: 4

Default Efficiency analysis spreadsheet

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
Kaiser is offline
 
Reply With Quote Quick reply to this message
Old 03-10-2009, 02:37 PM   #2
babalu87
Feedback Score: 0 reviews
Recipes 
 
Join Date: Feb 2008
Location: Middleborough, MA
Posts: 1,914
Liked 8 Times on 7 Posts
Likes Given: 12

Default

Great stuff Kai!

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

__________________
babalu87 is offline
 
Reply With Quote Quick reply to this message
Old 03-10-2009, 02:53 PM   #3
dstar26t
If it's worth doing, it's worth overdoing
HBT_SUPPORTER.png
Feedback Score: 0 reviews
Recipes 
 
Join Date: Jan 2008
Location: Ridley Park, PA
Posts: 1,191
Liked 27 Times on 26 Posts

Default

Kaiser,
Are you assuming a moisture content for the grain to calculate the potential gravity?

__________________
Next: Egregious-ish
Fermenting: JeanBeer, Barrel Fermented Dreg Lambic, Brett Trois Helles, Carrot Blossom Cedar Mead
Drinking: RIS, Coffee RIS, Jalapeno RIS, Heavy Hopper v2, Dusseldorf Altbier v5, Oktoberfest v5, Dopplebock v2, Cider, Rye Berliner Weisse, Sauerkraut Fermented Gose, Lambic, Brett Trois IPA, Brett Blonde, Kriek, Saison, Sour Blonde, RIS
Barrel aged: RIS, Rye Barleywine, Tripel, Wee-Heavy
dstar26t is offline
 
Reply With Quote Quick reply to this message
Old 03-10-2009, 02:59 PM   #4
Kaiser
Feedback Score: 0 reviews
 
Kaiser's Avatar
Recipes 
 
Join Date: Nov 2005
Location: Pepperell, MA
Posts: 3,904
Liked 114 Times on 71 Posts
Likes Given: 4

Default

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
Kaiser is offline
 
Reply With Quote Quick reply to this message
Old 03-10-2009, 03:02 PM   #5
Coastarine
We get it, you hate BMC.
HBT_LIFETIMESUPPORTER.png
Feedback Score: 0 reviews
 
Coastarine's Avatar
Recipes 
 
Join Date: Apr 2008
Location: New Bern, NC
Posts: 2,582
Liked 21 Times on 19 Posts
Likes Given: 1

Default

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]
Coastarine is offline
 
Reply With Quote Quick reply to this message
Old 03-10-2009, 03:08 PM   #6
Kaiser
Feedback Score: 0 reviews
 
Kaiser's Avatar
Recipes 
 
Join Date: Nov 2005
Location: Pepperell, MA
Posts: 3,904
Liked 114 Times on 71 Posts
Likes Given: 4

Default

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
__________________
BrauKaiser.com - brewing science blog - Twitter - water and mash chemistry calculator
Kaiser is offline
 
Reply With Quote Quick reply to this message
Old 03-10-2009, 03:22 PM   #7
dstar26t
If it's worth doing, it's worth overdoing
HBT_SUPPORTER.png
Feedback Score: 0 reviews
Recipes 
 
Join Date: Jan 2008
Location: Ridley Park, PA
Posts: 1,191
Liked 27 Times on 26 Posts

Default

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: Egregious-ish
Fermenting: JeanBeer, Barrel Fermented Dreg Lambic, Brett Trois Helles, Carrot Blossom Cedar Mead
Drinking: RIS, Coffee RIS, Jalapeno RIS, Heavy Hopper v2, Dusseldorf Altbier v5, Oktoberfest v5, Dopplebock v2, Cider, Rye Berliner Weisse, Sauerkraut Fermented Gose, Lambic, Brett Trois IPA, Brett Blonde, Kriek, Saison, Sour Blonde, RIS
Barrel aged: RIS, Rye Barleywine, Tripel, Wee-Heavy

dstar26t is offline
 
Reply With Quote Quick reply to this message
Old 03-10-2009, 03:28 PM   #8
Coastarine
We get it, you hate BMC.
HBT_LIFETIMESUPPORTER.png
Feedback Score: 0 reviews
 
Coastarine's Avatar
Recipes 
 
Join Date: Apr 2008
Location: New Bern, NC
Posts: 2,582
Liked 21 Times on 19 Posts
Likes Given: 1

Default

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]
Coastarine is offline
 
Reply With Quote Quick reply to this message
Old 03-10-2009, 03:29 PM   #9
BuzzCraft
Feedback Score: 0 reviews
Recipes 
 
Join Date: Jan 2009
Location: Blacksburg, VA
Posts: 426
Default

Very nice....thanks for doing this.

__________________
BuzzCraft is offline
 
Reply With Quote Quick reply to this message
Old 03-10-2009, 04:01 PM   #10
Kaiser
Feedback Score: 0 reviews
 
Kaiser's Avatar
Recipes 
 
Join Date: Nov 2005
Location: Pepperell, MA
Posts: 3,904
Liked 114 Times on 71 Posts
Likes Given: 4

Default

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
__________________
BrauKaiser.com - brewing science blog - Twitter - water and mash chemistry calculator
Kaiser 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
Hop profiles spreadsheet MattHollingsworth Recipes/Ingredients 5 02-13-2011 07:03 PM
how to use spreadsheet Stubbs5150 Brew Science 2 08-30-2009 09:26 PM
AG spreadsheet? Does it exist? perkins98 All Grain & Partial Mash Brewing 7 03-31-2009 09: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 06:24 AM



Newest Threads

LATEST SPONSOR DEALS