Efficiency analysis spreadsheet - Page 2 - Home Brew Forums

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

Reply
 
Thread Tools
Old 03-10-2009, 03:10 PM   #11
dstar26t
If it's worth doing, it's worth overdoing
HBT_SUPPORTER.png
Recipes 
 
Jan 2008
Ridley Park, PA
Posts: 1,151
Liked 57 Times on 42 Posts


emailed to kai at braukaiser dot com
__________________
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, 04:38 PM   #12
Kaiser
 
Kaiser's Avatar
Recipes 
 
Nov 2005
Pepperell, MA
Posts: 3,895
Liked 128 Times on 74 Posts


I saw that and updated the spreadsheet to include optional moisture content information.

Kai

 
Reply With Quote
Old 03-10-2009, 05:18 PM   #13
JVD_X
HBT_LIFETIMESUPPORTER.png
 
JVD_X's Avatar
Recipes 
 
Jan 2008
Gainesville, Virginia
Posts: 1,478
Liked 4 Times on 4 Posts


Quote:
Originally Posted by Kaiser View Post
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 - that's awesome - thank you.
__________________
- JVD_X

 
Reply With Quote
Old 03-11-2009, 03:57 AM   #14
AZ_IPA
PKU
HBT_LIFETIMESUPPORTER.png
 
AZ_IPA's Avatar
Recipes 
 
Jun 2008
The Cold Part of AZ
Posts: 52,672
Liked 8718 Times on 7006 Posts


Thanks Kai -

I, and others, really appreciate your work on effeciency theory and calculations.

Of note - I calculated via your spreadsheet that my mash efficiency was only 87%. Interesting.

On a side note - have you done your "cold sparge" experiments yet?

 
Reply With Quote
Old 03-11-2009, 04:20 AM   #15
Kaiser
 
Kaiser's Avatar
Recipes 
 
Nov 2005
Pepperell, MA
Posts: 3,895
Liked 128 Times on 74 Posts


Quote:
Originally Posted by AZ_IPA View Post
Of note - I calculated via your spreadsheet that my mash efficiency was only 87%. Interesting.
did you mean efficiency of conversion?

Quote:
On a side note - have you done your "cold sparge" experiments yet?
No I haven't. This one has moved to the back burner a little bit though I'm curious to give it a try.

Kai

 
Reply With Quote
Old 03-11-2009, 05:03 AM   #16
AZ_IPA
PKU
HBT_LIFETIMESUPPORTER.png
 
AZ_IPA's Avatar
Recipes 
 
Jun 2008
The Cold Part of AZ
Posts: 52,672
Liked 8718 Times on 7006 Posts


Quote:
Originally Posted by Kaiser View Post
did you mean efficiency of conversion?
yes, sorry - 87% conversion.

I'm assuming if I can get that up to ~95% I'll likely see a somewhat corresponding increase in the into the kettle efficiency (which was 72% in this case)

 
Reply With Quote
Old 03-11-2009, 01:47 PM   #17
Kaiser
 
Kaiser's Avatar
Recipes 
 
Nov 2005
Pepperell, MA
Posts: 3,895
Liked 128 Times on 74 Posts


Quote:
Originally Posted by AZ_IPA View Post
yes, sorry - 87% conversion.
Quote:
Originally Posted by AZ_IPA View Post


I used to call it mash efficiency but that conflicted with many other brewer’s definitions of mash efficiency being the efficiency into the kettle. So I changed it to conversion efficiency b/c that had not been taken yet and it makes more clearly what it is measuring.

Quote:
I'm assuming if I can get that up to ~95% I'll likely see a somewhat corresponding
increase in the into the kettle efficiency (which was 72% in this case)


with 72% into kettle and 87% conversion efficiency your lauter efficiency must have been around 72 / .87 = 82%. With the same lauter efficiency and a conversion efficiency of 95% you should expect an efficiency into the kettle of 95% * .82 = 78%

depending on how you sparge, 82% lauter efficicncy can also be improved to 85-90% (at least for average gravity beers and batch sparging).

Kai

 
Reply With Quote
Old 03-11-2009, 04:22 PM   #18
SpanishCastleAle
 
SpanishCastleAle's Avatar
Recipes 
 
Jan 2009
Central Florida
Posts: 4,345
Liked 36 Times on 36 Posts


Kaiser,
I use a Zapap lauter tun and it has a decent amount of space beneath the false bottom that I prefill with hot water before adding the mash. Will I be able to get a good true first runnings sample? Maybe take 3-4 different samples during the early part and pick the highest one?

I hope to try using it this weekend.
__________________
Early brewers were primarily women, mostly because it was deemed a woman's job. Mesopotamian men, of some 3,800 years ago, were obviously complete assclowns and had yet to realize the pleasure of brewing beer.- Beer Advocate

 
Reply With Quote
Old 03-11-2009, 04:27 PM   #19
Kaiser
 
Kaiser's Avatar
Recipes 
 
Nov 2005
Pepperell, MA
Posts: 3,895
Liked 128 Times on 74 Posts


Quote:
Originally Posted by SpanishCastleAle View Post
Kaiser,
I use a Zapap lauter tun and it has a decent amount of space beneath the false bottom that I prefill with hot water before adding the mash. Will I be able to get a good true first runnings sample? Maybe take 3-4 different samples during the early part and pick the highest one?
In that case I suggest running into the kettle and once a significant amount has been collected but the sparge has not started to dilute the runnings yet, mix it well and take a sample. The amount of water used for mash, that you enter, needs to include the water you had under the false bottom.

Kai

 
Reply With Quote
Old 03-11-2009, 05:31 PM   #20
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


I don't know much about the moisture content of grain, but if beersmith says that german pilsner has 4%, is it safe to assume that is correct for my grain (which is still sealed from brewmaster's warehouse).
__________________
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
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