Home Brew Forums

Home Brew Forums (http://www.homebrewtalk.com/forum.php)
-   All Grain & Partial Mash Brewing (http://www.homebrewtalk.com/f36/)
-   -   Efficiency analysis spreadsheet (http://www.homebrewtalk.com/f36/efficiency-analysis-spreadsheet-107911/)

Kaiser 03-10-2009 01:31 PM

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

babalu87 03-10-2009 01:37 PM

Great stuff Kai!

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

dstar26t 03-10-2009 01:53 PM

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

Kaiser 03-10-2009 01:59 PM

Quote:

Originally Posted by dstar26t (Post 1187655)
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

Coastarine 03-10-2009 02:02 PM

Sweet! Now I'm going to be playing with my refractometer all through the sacc rest!

Kaiser 03-10-2009 02:08 PM

Quote:

Originally Posted by Coastarine (Post 1187671)
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

dstar26t 03-10-2009 02:22 PM

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

Coastarine 03-10-2009 02:28 PM

Quote:

Originally Posted by Kaiser (Post 1187688)
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?

BuzzCraft 03-10-2009 02:29 PM

Very nice....thanks for doing this. :mug:

Kaiser 03-10-2009 03:01 PM

Quote:

Originally Posted by dstar26t (Post 1187709)
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


All times are GMT. The time now is 12:51 AM.

Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.