Spike Brewing 12.5 Conical Fermenter Giveaway!

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

Reply
 
LinkBack Thread Tools
Old 03-10-2009, 03:10 PM   #11
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,147
Liked 18 Times on 17 Posts

Default

emailed to kai at braukaiser dot com

__________________

Next: ?
Fermenting: Munich Helles v4, Dusseldorf Altbier v5, Oktoberfest v5, Dopplebock v2, Cider, Barrel Fermented Dreg Lambic, Brett Trois Helles, Carrot Blossom Cedar Mead
Drinking: Mitis Saxon (brewed @ Earth - Bread + Brewery), Rye Berliner Weisse, Sauerkraut Fermented Gose, Conan DIPA, 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, 04:38 PM   #12
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

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

Kai

Kaiser is offline
 
Reply With Quote Quick reply to this message
Old 03-10-2009, 05:18 PM   #13
JVD_X
HBT_LIFETIMESUPPORTER.png
Feedback Score: 4 reviews
 
JVD_X's Avatar
Recipes 
 
Join Date: Jan 2008
Location: Gainesville, Virginia
Posts: 1,492
Liked 3 Times on 3 Posts

Default

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

JVD_X is offline
 
Reply With Quote Quick reply to this message
Old 03-11-2009, 03:57 AM   #14
AZ_IPA
PKU
HBT_LIFETIMESUPPORTER.png
Feedback Score: 0 reviews
 
AZ_IPA's Avatar
Recipes 
 
Join Date: Jun 2008
Location: The Cold Part of AZ
Posts: 42,240
Liked 6071 Times on 5305 Posts
Likes Given: 712

Default

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?

__________________
AZ_IPA is online now
 
Reply With Quote Quick reply to this message
Old 03-11-2009, 04:20 AM   #15
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 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
Kaiser is offline
 
Reply With Quote Quick reply to this message
Old 03-11-2009, 05:03 AM   #16
AZ_IPA
PKU
HBT_LIFETIMESUPPORTER.png
Feedback Score: 0 reviews
 
AZ_IPA's Avatar
Recipes 
 
Join Date: Jun 2008
Location: The Cold Part of AZ
Posts: 42,240
Liked 6071 Times on 5305 Posts
Likes Given: 712

Default

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)
__________________
AZ_IPA is online now
 
Reply With Quote Quick reply to this message
Old 03-11-2009, 01:47 PM   #17
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 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
__________________
BrauKaiser.com - brewing science blog - Twitter - water and mash chemistry calculator
Kaiser is offline
 
Reply With Quote Quick reply to this message
Old 03-11-2009, 04:22 PM   #18
SpanishCastleAle
Feedback Score: 0 reviews
Recipes 
 
Join Date: Jan 2009
Location: Central Florida
Posts: 4,384
Liked 29 Times on 29 Posts

Default

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
SpanishCastleAle is offline
 
Reply With Quote Quick reply to this message
Old 03-11-2009, 04:27 PM   #19
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 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
__________________
BrauKaiser.com - brewing science blog - Twitter - water and mash chemistry calculator
Kaiser is offline
 
Reply With Quote Quick reply to this message
Old 03-11-2009, 05:31 PM   #20
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

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]
Coastarine 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