I am currently putting the finishing touches on my AG brewing spreadsheet in Excel and i've hit a snag.
Currently I am calculating PBG in my pre-brewday estimation section by using the following calculation:
((Grain points total*efficiency)+(points of sugar))/Pre-boil volume
This equation is yielding expected results given the other equation in my sheet. It's when I attempt to calculate efficiency in my actuals (brew day values) section that I hit a snag: I had calculated the points contribution of the sugars separate from the grains because thier contribution is 100% efficient, yet actual efficiency is the quotient of measured PBG and grain potential. I am effectively getting a lower efficiency in my actuals section that the estimation section.
I know its a simple fix but if anyone can chime in on this it would be much appreciated.
Currently I am calculating PBG in my pre-brewday estimation section by using the following calculation:
((Grain points total*efficiency)+(points of sugar))/Pre-boil volume
This equation is yielding expected results given the other equation in my sheet. It's when I attempt to calculate efficiency in my actuals (brew day values) section that I hit a snag: I had calculated the points contribution of the sugars separate from the grains because thier contribution is 100% efficient, yet actual efficiency is the quotient of measured PBG and grain potential. I am effectively getting a lower efficiency in my actuals section that the estimation section.
I know its a simple fix but if anyone can chime in on this it would be much appreciated.