• Welcome to the new forum! We upgraded our forum software with a host of new boards, capabilities and features. It is also more secure.
    Jump in and join the conversation! You can learn more about the upgrade and new features here.

Formula for Estimated Final Gravity

jeremiahhansen

Apprentice
Joined
Jan 1, 2013
Messages
6
Reaction score
0
Hey all, I really love BeerSmith2 and am trying to understand it better by learning how the various fields are calculated.  I've got many of them figured out but am stuck on the estimated final gravity.  Could someone please help me with this?  Here's what I've got so far (I'm doing these in Excel):

Inputs:
EstBatchGravityPoints54.51
YeastMinAttenuation72 (%)
YeastMaxAttenuation80 (%)
MashTemp150 (deg F)
AttenuationAdjustSlope-1.250 (%)
AttenuationAdjustCenterTemp153.50 (deg F)

Calculations:
EstAttenuationAdjust4.38%=(MashTemp - AttenuationAdjustCenterTemp) * AttenuationAdjustSlope
EstAttenuation80.38%=((YeastMinAttenuation + YeastMaxAttenuation) / 2) + EstAttenuationAdjust
EstFinalGravityPoints10.70=(1 - EstAttenuation) * EstBatchGravityPoints
EstFinalSpecificGravity1.011=(EstFinalGravityPoints / 1000) + 1

But my estimated final gravity (EstFinalSpecificGravity) doesn't match BeerSmith, which gives 1.010 (and it varies more widely in different scenarios).  Please help!
 
Perhaps a more extreme example would be helpful?  This one looks so close that it could almost be explained by a rounding error.  (I know, it probably isn't that simple, but it's close.)
 
Back
Top