The other thing to remember is that there
are different equations, and they all give slightly different results.
The constant 0.129 is only valid for a narrow range of gravities . . . fine if you are brewing in that range, but not so good if you are brewing stronger/weaker beers.
I would assume, that as you are working in a commercial brewery, you need to know the abv for duty purposes? If this is the case then the
only equation that matters is the
one provided by HMCE (Section 30 ). Now this is the
OG-FG * f = abv%
Where f is a non constant fudge factor
"The value of 'f' is not constant because the yield of alcohol is not constant for all fermentations. In lower strength beers, more of the 'sugars' available for fermentation are consumed in yeast reproduction than in producing alcohol."
If you have excel (This works for 2003) Then enter the OG in Cell A1, The FG in Cell B1 (Don't forget the Decimal point) then paste the following formula into cell C1 (formatted as percentage to 2 decimal places).
Code:
=(IF((A1-B1)<=0.0069,(A1-B1)*1.25,IF(AND((A1-B1)>=0.007,(A1-B1)<=0.0104),(A1-B1)*1.26,IF(AND((A1-B1)>=0.0105,(A1-B1)<=0.0172),(A1-B1)*1.27,IF(AND((A1-B1)>=0.0173,(A1-B1)<=0.0261),(A1-B1)*1.28,IF(AND((A1-B1)>=0.0262,(A1-B1)<=0.036),(A1-B1)*1.29,IF(AND((A1-B1)>=0.0361,(A1-B1)<=0.0465),(A1-B1)*1.3,IF(AND((A1-B1)>=0.0466,(A1-B1)<=0.0571),(A1-B1)*1.31,)))))))&IF(AND((A1-B1)>=0.0572,(A1-B1)<=0.0679),(A1-B1)*1.32,IF(AND((A1-B1)>=0.068,(A1-B1)<=0.0788),(A1-B1)*1.33,IF(AND((A1-B1)>=0.0789,(A1-B1)<=0.0897),(A1-B1)*1.34,IF((A1-B1)>=0.0898,(A1-B1)*1.35,)))))+0
I believe that we have used a different formula that is much more common in homebrew books as we are home brewers and do not need to be pedantic for HMCE duty purposes. I go by OG - FG / 10 to get an idea of abv 48-12/10 = 3.6% close enough for my purposes.
Like a lot of things in brewing there are many ways to make a beer, and achieve the results you need, while blindly learning 'some equations' is useful, quite often understanding the reasoning behind the equation, as well as it's limitations is much more important.