Happy HolidaySs Giveaway - Last Sponsor Giveaway of the Year!

Come Enter the BrewDeals/FastFerment Giveaway!


Home Brew Forums > Home Brewing Beer > All Grain & Partial Mash Brewing > Efficiency analysis spreadsheet
Reply
 
LinkBack Thread Tools
Old 03-11-2009, 06:55 PM   #21
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
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).


I’d think so.

So far I haven’t really accounted for moisture in my grain and always worked with the 80% as a good approximation of extract potential. Turns out that with 4% moisture the actual extract is more like 77%.

Kai
Kaiser is offline
 
Reply With Quote Quick reply to this message
Old 03-11-2009, 07:08 PM   #22
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

Sounds good, I'm using the extract values from beersmith too. Those are probably as good numbers as I'm going to get.

__________________
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-12-2009, 12:16 AM   #23
mthompson
Feedback Score: 1 reviews
Recipes 
 
Join Date: Sep 2008
Location: Plymouth, WI
Posts: 530
Liked 44 Times on 28 Posts
Likes Given: 2

Default

Any thoughts on why I cannot access the file. the link says "403 Forbidden blah, blah, blah" and so does the .xls when I right-click/save file as.

Thanks,

__________________
MT
------------------------------------------------------------------------------------------
Save me, O God! For the waters have come up to my neck. - Psalm 69:1
mthompson is offline
 
Reply With Quote Quick reply to this message
Old 03-12-2009, 01:24 AM   #24
freddyb
Feedback Score: 0 reviews
Recipes 
 
Join Date: Apr 2008
Posts: 214
Liked 7 Times on 7 Posts

Default

Quote:
Originally Posted by mthompson View Post
Any thoughts on why I cannot access the file. the link says "403 Forbidden blah, blah, blah" and so does the .xls when I right-click/save file as.

Thanks,
I get the same error too. Can some one email the file to me? soonerbh at gmail.

Thanks!
__________________
freddyb is offline
 
Reply With Quote Quick reply to this message
Old 03-12-2009, 03:51 AM   #25
Got Trub?
Feedback Score: 0 reviews
Recipes 
 
Join Date: Apr 2007
Location: Washington State
Posts: 1,538
Liked 7 Times on 5 Posts

Default

Quote:
Originally Posted by Coastarine View Post
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?
100% is only possible in the laboratory.

I was just listening to one of Jamil's podcasts where he discussed not trying to get much > 70% efficiency to avoid extracting undesirable flavours. It was either the Kolsch or the Dusseldorf Alt podcast.

GT
__________________
Got Trub? is offline
 
Reply With Quote Quick reply to this message
Old 03-12-2009, 05:49 AM   #26
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 mthompson View Post
Any thoughts on why I cannot access the file. the link says "403 Forbidden blah, blah, blah" and so does the .xls when I right-click/save file as.

Thanks,
There must be a problem with my hosting provider. If it hasn't cleared up by tomorrow I'll have to contact them.

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-12-2009, 05:58 AM   #27
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 Got Trub? View Post
100% is only possible in the laboratory.
100% conversion efficiency is certainly possible but you may have to work for it by either milling really fine (which may cause you to spend the whole day lautering) or use a decoction schedule during which all or almost all the grain is boiled.

Quote:
I was just listening to one of Jamil's podcasts where he discussed not trying to get much > 70% efficiency to avoid extracting undesirable flavours. It was either the Kolsch or the Dusseldorf Alt podcast.
Now what Jamil is talking about here is the efficiency into the kettle. This includes lautering losses and I agree with him that you need to leave some efficiency behind at this stage for wort quality sake. I don't agree with his 70% though and for me that number is more like 80-85%.

But what needs to be taken into account here is how did you get the 70%:

I can have a very poor conversion efficiency of 75% and excessive lautering with an efficiency of 93%. The combined efficiency is 70% but the intensive lauter may have caused oversparging. Or I can have a very good conversion efficiency of 93% or more and a very relaxed lauter with an efficiency of 75% (this can easily achieved with no-sparge) which will produce a very high quality wort. If you ask me I'll take the latter of the two options.

I get my 80-85% from aiming for a conversion efficiency of 95%. I then need a lauter efficiency of 84-89% which can easily be achieved with a 2 run-off batch sparge and only 15% boil off.

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-12-2009, 02:43 PM   #28
Homercidal
Moderator
HBT_MODERATOR.png
Feedback Score: 0 reviews
 
Homercidal's Avatar
Recipes 
 
Join Date: Feb 2008
Location: Reed City, MI
Posts: 24,130
Liked 2347 Times on 1666 Posts
Likes Given: 1307

Default

Argh! I get the forbidden error too. Can't wait to see this!

__________________
Homercidal is offline
 
Reply With Quote Quick reply to this message
Old 03-12-2009, 03:01 PM   #29
bluehouse
Feedback Score: 0 reviews
Recipes 
 
Join Date: Jan 2009
Posts: 377
Liked 2 Times on 2 Posts

Default

Still forbidden.

__________________
bluehouse is offline
 
Reply With Quote Quick reply to this message
Old 03-12-2009, 03:02 PM   #30
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 Homercidal View Post
Argh! I get the forbidden error too. Can't wait to see this!
Sorry about that. I hope to get this resolved by today. As far as I know I'm current with my payments to them.

Unfortunately I don't even have another place to put the spreadsheet. HBT doen't let me host anythin else but pictures.

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 07:03 PM
how to use spreadsheet Stubbs5150 Brew Science 2 08-30-2009 09:26 PM
AG spreadsheet? Does it exist? perkins98 All Grain & Partial Mash Brewing 7 03-31-2009 09: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 06:24 AM



Newest Threads

LATEST SPONSOR DEALS