Be part of our community & join our international next generation forum now!
I'm revisiting a subject I sorta half-ass fixed a while back, but I'd really like a good (or better) answer that I can use in an Excel formula that crops up in much of my ethanol accounting spreadsheets. When last I did this, I fed 20 fairly good %ABV,%ABW pairs into a time-bombed limited (hence the only 20 points) trial version of somebody's curve-fitting program, and got the following:
As you can see from that first co-efficient, there will be a .068% error when converting 0%ABV to %ABW ( the answer you get is 0%ABV equals .068384%ABW, and that's bogus.
Does anyone have a better polynomial than my crappy one?
Zymurgy Bob, a simple potstiller