need a formula
Moderator: Site Moderator
-
- Site Admin
- Posts: 3935
- Joined: Wed Apr 21, 2004 3:00 pm
need a formula
for converting brix to plato.
no, not plato to brix, i already have that one.
no, not plato to brix, i already have that one.
If only the best birds sang, the woods would be silent.
-
- Site Admin
- Posts: 3935
- Joined: Wed Apr 21, 2004 3:00 pm
yep
Plato is a revision of Brix to make it more accurate. And yes, they are almost but not quite identical.aj wrote:Aren't they almost identical, save for 5th or 6th decimal calculation? I've always heard them referred to with a slash between them like "plato/brix".
If only the best birds sang, the woods would be silent.
-
- Bootlegger
- Posts: 134
- Joined: Fri Feb 09, 2007 8:05 pm
°Brix = 261.3(1 - 1/SG) @ 20°C
Plato = 260.0(1 - 1/SG) @ 17.5°C
Therefore disregarding temperature for the moment:
°Brix = Plato + 1.3(1 - 1/SG)
Plato = °Brix - 1.3(1 - 1/SG)
I don't have a sucrose expansion curve to work out a corrective thermal expanion measure, but I've read that Einstein found sucrose in solution to behave nearly like an ideal gas, so it shouldn't matter..
(Also, from a glance at a chart comparing various molar values of sucrose, concentration didn't affect the exapansion rate to any extent beyond the degree of error in the experiment..)
Plato = 260.0(1 - 1/SG) @ 17.5°C
Therefore disregarding temperature for the moment:
°Brix = Plato + 1.3(1 - 1/SG)
Plato = °Brix - 1.3(1 - 1/SG)
I don't have a sucrose expansion curve to work out a corrective thermal expanion measure, but I've read that Einstein found sucrose in solution to behave nearly like an ideal gas, so it shouldn't matter..
(Also, from a glance at a chart comparing various molar values of sucrose, concentration didn't affect the exapansion rate to any extent beyond the degree of error in the experiment..)
if that's correct you can ignore the temperature, eliminate the SG, and have Brix in function of plato and plato in funtion of brix.°Brix = 261.3(1 - 1/SG) @ 20°C
Plato = 260.0(1 - 1/SG) @ 17.5°C
jesse, you said you have brix to plato, why can't you convert it to plato-brix?

-I have too much blood in my alcohol system-
-
- Site Admin
- Posts: 3935
- Joined: Wed Apr 21, 2004 3:00 pm
-
- Site Admin
- Posts: 3935
- Joined: Wed Apr 21, 2004 3:00 pm
also
my plato to brix formula...maybe it's as accurate as i need, not sure
=SUM(plato-1)*250
=SUM(plato-1)*250
If only the best birds sang, the woods would be silent.
-
- Master of Distillation
- Posts: 3086
- Joined: Fri Feb 03, 2006 11:40 am
- Location: Texas
-
- Site Admin
- Posts: 3935
- Joined: Wed Apr 21, 2004 3:00 pm
Yeh
I'm no math genius either but as I understand it this is a way to mathematically express a curve, not just a line. Visualize a graph.
If only the best birds sang, the woods would be silent.
-
- Master of Distillation
- Posts: 3086
- Joined: Fri Feb 03, 2006 11:40 am
- Location: Texas
Re: also
I checked some formulas in your sheet, and you use everywhere "sum", why is that? it's not wrong, but it's the same as dividing everyting by '1'.Uncle Jesse wrote: =SUM(plato-1)*250
-I have too much blood in my alcohol system-
he talks about the effect of temperature on the SG, brix and plato. if temperature rises, so does the volume and the density will drop. and you'll have wrong SG,brix and plato readings.junkyard dawg wrote:whats a
not to sound like a dumbass or nothin...a sucrose expansion curve to work out a corrective thermal expanion measure
-I have too much blood in my alcohol system-
-
- Bootlegger
- Posts: 134
- Joined: Fri Feb 09, 2007 8:05 pm
As far as the expansion curve goes, I think its ignorable.. In one of my earliest posts about an ABV eqn though, I was somewhat drilled for ignoring the ETOH solution expansion curve since its not quite as linear as what I believe sucrose to be.. Solutions/liquids can do funny things.. Water is probably the best example.. Its densest @4°C before H-bonding comes into play, and its solid is actually less dense than its liquid (fish are grateful for that anomaly:) ) Ignoring solid state, if it was linear, it would be densest at 0°C,and would expand an equal amount for every degree increase to 100°C which it does not.. Throw some impurities in there, and all logic can go overboard.. Luckily simplified concepts work well enough here..
Note, almost all science is simplified.. Take gravity for instance.. Newton's eqn works well enough for most applications NASA is involved in, but when its not, they turn to Einstein's general relativity.. Thats probably over simplified too, but many many scientists have been burned even in 21st century for trying to take on Albert..
Note, almost all science is simplified.. Take gravity for instance.. Newton's eqn works well enough for most applications NASA is involved in, but when its not, they turn to Einstein's general relativity.. Thats probably over simplified too, but many many scientists have been burned even in 21st century for trying to take on Albert..

First you get the sugar.. Then you get the power.. Then, you get the women...
-
- Site Admin
- Posts: 3935
- Joined: Wed Apr 21, 2004 3:00 pm
more
these are just formulas I have found useful in the past. what I really need is the formulas which correspond to these 7 tables:
http://www.ttb.gov/foia/gauging_manual_toc.shtml#e
determination of tax requires precise determination of weight and volume.
http://www.ttb.gov/foia/gauging_manual_toc.shtml#e
determination of tax requires precise determination of weight and volume.
If only the best birds sang, the woods would be silent.
-
- Site Admin
- Posts: 3935
- Joined: Wed Apr 21, 2004 3:00 pm
well
Managed to find this online: http://catalog.gpo.gov/F?func=find-b&fi ... of+spirits and have calls in to NIST, Bureau of Weights and Measures, TTB, the Government Printing Office and also the northern california state branch of the federal library trying to find the formulas used to determine the tables which are part of Gauging Manual of Title 27 of the CFR.
If only the best birds sang, the woods would be silent.
-
- Site Admin
- Posts: 3935
- Joined: Wed Apr 21, 2004 3:00 pm
OK
It turns out that the tables in the Gauging Manual of Title 27 CFR were extrapolated from data published in the Journal of the National Bureau of Standards in 1913, a copy of which is available on microfilm at the Federal Records branch of the state library in Sacramento.
So I gotta drive a few hours to go check for the formulas I want.
So I gotta drive a few hours to go check for the formulas I want.
If only the best birds sang, the woods would be silent.
Re: OK
I've had good success getting stuff like that by interlibrary 'loan'. For articles, they will often mail you a photocopy (from microfilm) for cost. Might be worth investigating to save yourself the drive. I was getting stuff from a university, rather than a state library, however. Go through your local library or their website. If your local library sucks (i.e. you're in a small town) try to find someone with access to a university library.Uncle Jesse wrote:It turns out that the tables in the Gauging Manual of Title 27 CFR were extrapolated from data published in the Journal of the National Bureau of Standards in 1913, a copy of which is available on microfilm at the Federal Records branch of the state library in Sacramento.
So I gotta drive a few hours to go check for the formulas I want.