The Great Bottle Opener Giveaway

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

Reply
 
LinkBack 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 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, 01:37 PM   #2
babalu87
Feedback Score: 0 reviews
Recipes 
 
Join Date: Feb 2008
Location: Middleborough, MA
Posts: 1,914
Liked 7 Times on 6 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, 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,146
Liked 17 Times on 16 Posts

Default

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

__________________

Next: Oktoberfest v5
Fermenting: Conan DIPA, 1830's English Mild @ Earth - Bread + Brewery, Dopplebock, Cider, Rye Berliner Weisse, Barrel Fermented Dreg Lambic, Brett Trois Helles, Sauerkraut Fermented Gose, Carrot Blossom Cedar Mead
Drinking: Tropicale Thunder v2, Lambic, Brett Trois IPA, Brett Blonde, Kriek, Saison, Sour Blonde, RIS v1 & v2, Barleywine
Barrel aged: RIS, Rye Barleywine, Tripel

dstar26t is offline
 
Reply With Quote Quick reply to this message
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 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, 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 20 Times on 18 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, 02: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, 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,146
Liked 17 Times on 16 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: Oktoberfest v5
Fermenting: Conan DIPA, 1830's English Mild @ Earth - Bread + Brewery, Dopplebock, Cider, Rye Berliner Weisse, Barrel Fermented Dreg Lambic, Brett Trois Helles, Sauerkraut Fermented Gose, Carrot Blossom Cedar Mead
Drinking: Tropicale Thunder v2, Lambic, Brett Trois IPA, Brett Blonde, Kriek, Saison, Sour Blonde, RIS v1 & v2, Barleywine
Barrel aged: RIS, Rye Barleywine, Tripel


Last edited by dstar26t; 03-10-2009 at 02:37 PM.
dstar26t is offline
 
Reply With Quote Quick reply to this message
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 20 Times on 18 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, 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 Quick reply to this message
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 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 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