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
Feedback Score: 0 reviews
 
Kaiser's Avatar
Recipes 
 
Join Date: Nov 2005
Location: Pepperell, MA
Posts: 3,904
Liked 118 Times on 72 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
Old 03-10-2009, 01: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
Old 03-10-2009, 01: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,225
Liked 29 Times on 28 Posts

Default

Kaiser,
Are you assuming a moisture content for the grain to calculate the potential gravity?
__________________
Next: CAP
Fermenting: Helles, Egregious-ish, Barrel Fermented Dreg Lambic, Sacch Trois Helles
Drinking: RIS, Tripel, Tired Hands Style IPA, Carrot Blossom Cedar Mead, Dusseldorf Altbier, Dopplebock, Cider, Rye Berliner Weisse, Sauerkraut Fermented Gose, Lambic, Sacch Trois IPA, Brett Blonde, Kriek, Saison, Sour Blonde
Barrel aged: RIS, Rye Barleywine, Tripel, Wee-Heavy
dstar26t is offline
 
Reply With Quote
Old 03-10-2009, 01:59 PM   #4
Kaiser
Feedback Score: 0 reviews
 
Kaiser's Avatar
Recipes 
 
Join Date: Nov 2005
Location: Pepperell, MA
Posts: 3,904
Liked 118 Times on 72 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
Old 03-10-2009, 02: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 22 Times on 20 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
Old 03-10-2009, 02:08 PM   #6
Kaiser
Feedback Score: 0 reviews
 
Kaiser's Avatar
Recipes 
 
Join Date: Nov 2005
Location: Pepperell, MA
Posts: 3,904
Liked 118 Times on 72 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
Kaiser is offline
 
Reply With Quote
Old 03-10-2009, 02: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,225
Liked 29 Times on 28 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: CAP
Fermenting: Helles, Egregious-ish, Barrel Fermented Dreg Lambic, Sacch Trois Helles
Drinking: RIS, Tripel, Tired Hands Style IPA, Carrot Blossom Cedar Mead, Dusseldorf Altbier, Dopplebock, Cider, Rye Berliner Weisse, Sauerkraut Fermented Gose, Lambic, Sacch Trois IPA, Brett Blonde, Kriek, Saison, Sour Blonde
Barrel aged: RIS, Rye Barleywine, Tripel, Wee-Heavy

dstar26t is offline
 
Reply With Quote
Old 03-10-2009, 02: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 22 Times on 20 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
Old 03-10-2009, 02: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
Old 03-10-2009, 03:01 PM   #10
Kaiser
Feedback Score: 0 reviews
 
Kaiser's Avatar
Recipes 
 
Join Date: Nov 2005
Location: Pepperell, MA
Posts: 3,904
Liked 118 Times on 72 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


Kaiser is offline
 
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 06: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-19-2009 11:57 PM
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

Newest Threads

LATEST SPONSOR DEALS