need a formula

Distillation methods and improvements.

Moderator: Site Moderator

Post Reply
Uncle Jesse
Site Admin
Posts: 3935
Joined: Wed Apr 21, 2004 3:00 pm

need a formula

Post by Uncle Jesse »

for converting brix to plato.

no, not plato to brix, i already have that one.
If only the best birds sang, the woods would be silent.
aj
Novice
Posts: 77
Joined: Fri Apr 13, 2007 12:56 pm
Location: A merry land, far afield of the land of tundra and moose wherein I cut my teeth and my still.

Post by aj »

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".
"I would like to observe the vermouth from across the room while I drink my martini." -- Winston Churchill
Uncle Jesse
Site Admin
Posts: 3935
Joined: Wed Apr 21, 2004 3:00 pm

yep

Post by Uncle Jesse »

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".
Plato is a revision of Brix to make it more accurate. And yes, they are almost but not quite identical.
If only the best birds sang, the woods would be silent.
triggernum5
Bootlegger
Posts: 134
Joined: Fri Feb 09, 2007 8:05 pm

Post by triggernum5 »

°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..)
wineo
Distiller
Posts: 1322
Joined: Sat Mar 17, 2007 7:33 pm

Post by wineo »

Brix x 1.04=Plato
Plato devided by 1.04=brix
wineo
stoker
Distiller
Posts: 1093
Joined: Fri Dec 02, 2005 9:16 am
Location: not there

Post by stoker »

°Brix = 261.3(1 - 1/SG) @ 20°C
Plato = 260.0(1 - 1/SG) @ 17.5°C
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.

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-
Uncle Jesse
Site Admin
Posts: 3935
Joined: Wed Apr 21, 2004 3:00 pm

Post by Uncle Jesse »

here is brix to plato, basically i do brix to specific gravity then use this value to figure plato


=(-676.67+1286.4*SG-800.47*SG*SG+190.74*SG*SG*SG)
If only the best birds sang, the woods would be silent.
Uncle Jesse
Site Admin
Posts: 3935
Joined: Wed Apr 21, 2004 3:00 pm

also

Post by Uncle Jesse »

my plato to brix formula...maybe it's as accurate as i need, not sure

=SUM(plato-1)*250
If only the best birds sang, the woods would be silent.
junkyard dawg
Master of Distillation
Posts: 3086
Joined: Fri Feb 03, 2006 11:40 am
Location: Texas

Post by junkyard dawg »

whats a
a sucrose expansion curve to work out a corrective thermal expanion measure
not to sound like a dumbass or nothin...
Uncle Jesse
Site Admin
Posts: 3935
Joined: Wed Apr 21, 2004 3:00 pm

Yeh

Post by Uncle Jesse »

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.
junkyard dawg
Master of Distillation
Posts: 3086
Joined: Fri Feb 03, 2006 11:40 am
Location: Texas

Post by junkyard dawg »

say it like that and it sounds simple... :wink:

Jesse I'm curious how you are using this equation and data. Where in your endeavor does this data go? General record keeping? Process control? Govt. paperwork? I like that excel page btw.
stoker
Distiller
Posts: 1093
Joined: Fri Dec 02, 2005 9:16 am
Location: not there

Re: also

Post by stoker »

Uncle Jesse wrote: =SUM(plato-1)*250
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'.
-I have too much blood in my alcohol system-
stoker
Distiller
Posts: 1093
Joined: Fri Dec 02, 2005 9:16 am
Location: not there

Post by stoker »

junkyard dawg wrote:whats a
a sucrose expansion curve to work out a corrective thermal expanion measure
not to sound like a dumbass or nothin...
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.
-I have too much blood in my alcohol system-
triggernum5
Bootlegger
Posts: 134
Joined: Fri Feb 09, 2007 8:05 pm

Post by triggernum5 »

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..:)
First you get the sugar.. Then you get the power.. Then, you get the women...
Uncle Jesse
Site Admin
Posts: 3935
Joined: Wed Apr 21, 2004 3:00 pm

more

Post by Uncle Jesse »

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.
If only the best birds sang, the woods would be silent.
wineo
Distiller
Posts: 1322
Joined: Sat Mar 17, 2007 7:33 pm

Post by wineo »

And a anal exam.Damn they dont make it easy,do they.
wineo
Uncle Jesse
Site Admin
Posts: 3935
Joined: Wed Apr 21, 2004 3:00 pm

well

Post by Uncle Jesse »

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.
Uncle Jesse
Site Admin
Posts: 3935
Joined: Wed Apr 21, 2004 3:00 pm

OK

Post by Uncle Jesse »

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.
If only the best birds sang, the woods would be silent.
Samogon
Novice
Posts: 68
Joined: Fri Jan 26, 2007 3:22 pm

Re: OK

Post by Samogon »

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.
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.
Post Reply