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

 Kaiser 03-10-2009 01:31 PM

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.