Temperature & ABV Relationship Charts

Distillation methods and improvements.

Moderator: Site Moderator

Jacksonbrown
Swill Maker
Posts: 315
Joined: Fri Sep 20, 2013 3:00 pm

Re: Temperature & ABV Relationship Charts

Post by Jacksonbrown »

Johnny6 wrote:When entering your "fudge factor", what would you actually enter for azeotrope into the calculation? Is the value in percent, or would the value be 0.0031 for azeotrope?

I've been curious about the contribution of altitude/ambient pressure into the calculations. Thanks.
The value is 0.0031, if the cell in excel is formatted in percent it as displays .31%. I've left it at 0.34% for my calculator
I just ploted the numbers here http://gillesenergies.webs.com/boilingpointaltitude.htm and here http://en.wikipedia.org/wiki/High-altit ... _altitudes to get the factor which just modified the temp, so it's a bit rough.
I'm sure there is a better way but this is still much better than doing nothing.
BoomTown
Site Donor
Site Donor
Posts: 1498
Joined: Thu Apr 19, 2012 7:41 am
Location: Virgina

Re: Temperature & ABV Relationship Charts

Post by BoomTown »

no comment, I just want to be able to find this when I'm studying.

Boom
“…Let’s do this one more time....”
User avatar
Tokoroa_Shiner
Distiller
Posts: 1321
Joined: Mon Jan 06, 2014 3:02 am

Re: Temperature & ABV Relationship Charts

Post by Tokoroa_Shiner »

Does anyone have the formula to go the other way? So that if i was to take a vapor temp measurement, i could convert it to an ABV in exel without having to physically reference a chart
Must read topics for new members

The Rules By Which We Live By
Safety And Related Issues
New Distillers Reading Lounge

Have Fun, Keep Safe and Shine On
User avatar
snowman_fs
Novice
Posts: 73
Joined: Tue Mar 24, 2015 6:30 pm

Re: Temperature & ABV Relationship Charts

Post by snowman_fs »

Tokoroa_Shiner wrote:Does anyone have the formula to go the other way? So that if i was to take a vapor temp measurement, i could convert it to an ABV in exel without having to physically reference a chart
I have a calculation for functions based on the dataset from vle-calc. The two sets of coefficients for step distillation calculations are:

6th order Liquid EtOH vs Deg C (For 0 to 98% EtOH, R2=.99999)
C6=2.02354E-10
C5=-6.43224E-08
C4=8.52833E-06
C3=-0.000635847
C2=0.030177921
C=-0.999296544
b=100.0713473

5th order Deg C vs Vap EtOH Above 78 Deg C (From 78 to 100 Deg C, R2=.9991)
C5=-0.000127261
C4=0.05654474
C3=-10.04471396
C2=891.6069096
C=-39542.4145
b=701024.354

If you start at 8% liquid ABV, you can find the boiling temp by using the first (6th order) equation.
Hint = 93.7 Deg C
Then find the vapor % EtOH by inserting the temp result into the second equation (5th order).
Hint = 48.7%
You can keep using the same two sets of equations to loop down until the R2 error causes trouble near azotrope.
READ MORE:
My 10 steps from 8% are as follows.
[tr][td][/td] [td]Liquid[/td] [td][/td] [td]Vap[/td][/tr] [tr][td][/td] [td]%[/td] [td]Deg C[/td] [td]%[/td][/tr] [tr][td]Starting[/td] [td]8[/td] [td]93.7[/td] [td]48.7[/td][/tr] [tr][td]Step 1[/td] [td]48.7[/td] [td]82.6[/td] [td]79.4[/td][/tr] [tr][td]Step 2[/td] [td]79.4[/td] [td]79.4[/td] [td]87.5[/td][/tr] [tr][td]Step 3[/td] [td]87.5[/td] [td]78.5[/td] [td]91.6[/td][/tr] [tr][td]Step 4[/td] [td]91.6[/td] [td]78.2[/td] [td]93.7[/td][/tr] [tr][td]Step 5[/td] [td]93.7[/td] [td]78.1[/td] [td]94.6[/td][/tr] [tr][td]Step 6[/td] [td]94.6[/td] [td]78.0[/td] [td]94.9[/td][/tr] [tr][td]Step 7[/td] [td]94.9[/td] [td]78.0[/td] [td]94.9[/td][/tr] [tr][td]Step 8[/td] [td]94.9[/td] [td]78.0[/td] [td]94.9[/td][/tr] [tr][td]Step 9[/td] [td]94.9[/td] [td]78.0[/td] [td]94.9[/td][/tr] [tr][td]Step 10[/td] [td]94.9[/td] [td]78.0[/td] [td]95.0[/td][/tr]
User avatar
eStill
Swill Maker
Posts: 150
Joined: Sun May 08, 2016 1:36 am

Re: Temperature & ABV Relationship Charts

Post by eStill »

rad14701 wrote:... from the Distillation Theory section of the parent site based on the formulas provided by Tony Ackland on the Calculations page...
I'd be curious to see a quick runthrough on how the graphs were generated, please. Or at least a copy of the tabular data. Thanks.
rad14701
retired
Posts: 20865
Joined: Wed Dec 19, 2007 4:46 pm
Location: New York, USA

Re: Temperature & ABV Relationship Charts

Post by rad14701 »

eStill wrote:
rad14701 wrote:... from the Distillation Theory section of the parent site based on the formulas provided by Tony Ackland on the Calculations page...
I'd be curious to see a quick runthrough on how the graphs were generated, please. Or at least a copy of the tabular data. Thanks.
The formula is duplicated with different temperatures to get values which are then graphed... The actual spreadsheets might be kicking around in one of the topics... Mine is starting to look like a hack job due to all of the extra graphs I've rendered from subsets of data for my own use... Not sure what you mean by run-through... Are you looking for a step by step of how several of us figured out how to render the graphs...??? Doing so is beyond the scope of these forums...
User avatar
eStill
Swill Maker
Posts: 150
Joined: Sun May 08, 2016 1:36 am

Re: Temperature & ABV Relationship Charts

Post by eStill »

rad14701 wrote: The formula is duplicated with different temperatures to get values which are then graphed...
I could be blind (not the first time I've missed the wood because of all the damn trees I the way) but I don't see a formula for obtaining ABV from temperature orvice-versa.
rad14701 wrote: Are you looking for a step by step of how several of us figured out how to render the graphs...??? Doing so is beyond the scope of these forums...
Yes, or the raw data. Your graph of vapour vs ABV matches my observations by measurement. I take 100ml at a time and measure ABV with a float, and note the temperature. As a curiosity, I'd like to make a digital thermometer which reads in ABV instead of degrees and I thought your calculated data might make for a better set of interpolation points than my measurements.
Your raw tables are all I need if you still have them, please.
rad14701
retired
Posts: 20865
Joined: Wed Dec 19, 2007 4:46 pm
Location: New York, USA

Re: Temperature & ABV Relationship Charts

Post by rad14701 »

eStill wrote:
rad14701 wrote: The formula is duplicated with different temperatures to get values which are then graphed...
I could be blind (not the first time I've missed the wood because of all the damn trees I the way) but I don't see a formula for obtaining ABV from temperature orvice-versa.
rad14701 wrote: Are you looking for a step by step of how several of us figured out how to render the graphs...??? Doing so is beyond the scope of these forums...
Yes, or the raw data. Your graph of vapour vs ABV matches my observations by measurement. I take 100ml at a time and measure ABV with a float, and note the temperature. As a curiosity, I'd like to make a digital thermometer which reads in ABV instead of degrees and I thought your calculated data might make for a better set of interpolation points than my measurements.
Your raw tables are all I need if you still have them, please.
The formula is on the parent site... And unless I'm mistaken there is an alternate formula in one of the related topics here in the forums... I'll have to check and see if I've ever uploaded the spreadsheet I used...
Maritimer
Rumrunner
Posts: 716
Joined: Sun Jul 01, 2012 6:09 am
Location: Nova Scotia, Canada

Re: Temperature & ABV Relationship Charts

Post by Maritimer »

Hi eStill,

There is a collection of data from 1957 that is quite good:

http://136.145.83.33:8000/jspui/browse? ... Herminio+M" onclick="window.open(this.href);return false;" rel="nofollow

Here is a .xls of the main table that I used OCR to convert to text:
Brau.zip
(13.21 KiB) Downloaded 378 times
PM me if you'd like to discuss things. I've got tons of data.

M
User avatar
eStill
Swill Maker
Posts: 150
Joined: Sun May 08, 2016 1:36 am

Re: Temperature & ABV Relationship Charts

Post by eStill »

Maritimer wrote:
Brau.zip
No headers on any of the columns makes deciphering a bit of a struggle. Can you help, please?
Maritimer
Rumrunner
Posts: 716
Joined: Sun Jul 01, 2012 6:09 am
Location: Nova Scotia, Canada

Re: Temperature & ABV Relationship Charts

Post by Maritimer »

Hi eStill,

If you download the other file, which is a scan of the original document, you'll see the headers. The introduction is also very interesting.

M
User avatar
eStill
Swill Maker
Posts: 150
Joined: Sun May 08, 2016 1:36 am

Re: Temperature & ABV Relationship Charts

Post by eStill »

Maritimer wrote:If you download the other file, which is a scan of the original document, you'll see the headers. The introduction is also very interesting.
"This site can’t be reached 136.145.83.33 took too long to respond."
Maritimer
Rumrunner
Posts: 716
Joined: Sun Jul 01, 2012 6:09 am
Location: Nova Scotia, Canada

Re: Temperature & ABV Relationship Charts

Post by Maritimer »

Hi eStill,

That's weird. I checked the site before posting. Anyway, here is the header you need:
headers for brau.png
(Click to see full size.)

Keep checking, though. This document is very useful.

M
hefezelle
Novice
Posts: 67
Joined: Tue Mar 06, 2018 3:24 am
Location: Austria (as in Mozart, not Koalas!)

Re: Temperature & ABV Relationship Charts

Post by hefezelle »

Here's some charts that i made. Contrary to most other charts floating around the web, you get to see the measurements (as tiny dots) from which the curve is derived, and can judge the fit on your own. The data comes from ISBN 3921567017, page 184-186. They reference this here as the original source:
literature reference.png
The conversion of mole fraction in the original data to %vol was done considering volume contraction, by implementing the formula for density suggested in this pdf.
plot1-celsius-A4.pdf
concentration vs temperature
(77.05 KiB) Downloaded 639 times
plot2-celsius-A4.pdf
temperature vs concentration
(76.29 KiB) Downloaded 488 times
plot3-celsius-A4.pdf
pot concentration vs both temperature and condensate concentration
(87.35 KiB) Downloaded 513 times
Everything should be made as simple as possible, but not simpler.
I am writing the Tried And True Recipe Book pdf and appreciate critique!
User avatar
darkjoker
Novice
Posts: 21
Joined: Tue Jun 02, 2020 2:50 pm

Re: Temperature & ABV Relationship Charts

Post by darkjoker »

Thank you so much for the chart it's really helpful to know what abv in my wash in at any given time.
User avatar
Deplorable
Site Donor
Site Donor
Posts: 3984
Joined: Thu Jun 25, 2020 12:10 pm
Location: In the East, (IYKYK)

Re: Temperature & ABV Relationship Charts

Post by Deplorable »

I have questions regarding this question.
Bill-a-newbie wrote: Sat Apr 19, 2014 7:25 am Thanks Prairiepiss, Is there an EASY way to get the temp of the boiler that does not have a thermometer?
Isnt the temperature of the charge predictable as displayed on the chart? Meaning that based off the %ABV of the output, you can determine the temp of the still contents?
Therefore if you're monitoring the ABV output throughout the run, can you not determine the temp of the remaining charge in the pot?

Now, in a pot still with a thermometer in the vapor path. you know the still is going to start to produce vapor at about 173f ( under perfect atmospheric conditions). How relative is that temperature at highest point in the vapor path relative to the charge temperature? Can I correctly assume that the temp of the charge is the same as the temp of the vapor at the highest point in the still (with 0 reflux)? Do I need to factor in temperature loss across the height of the column?
Fear and ridicule are the tactics of weak-minded cowards and tyrants who have no other leadership talent from which to draw in order to persuade.
Hügelwilli
Swill Maker
Posts: 312
Joined: Fri Feb 15, 2019 5:52 am

Re: Temperature & ABV Relationship Charts

Post by Hügelwilli »

If your still provides no rectification, the temperatures of the vapor at the highest point and in the boiler are the same. But normally also potstills provide a small amount of rectification. So the temperature at the highest point will normally be lower than in the boiler.
User avatar
jonnys_spirit
Site Donor
Site Donor
Posts: 3630
Joined: Wed Oct 21, 2015 7:58 am
Location: The Milky Way

Re: Temperature & ABV Relationship Charts

Post by jonnys_spirit »

In a pot still the liquid and vapor temp are the same once the heatup stabilizes and the column comes up to temp. You can correlate the output ABV and use the chart to determine both the liquid temp & liquid ABV as well as vapor temp & vapor ABV. When this finally clicked for me it was a bright light lighting up and "shining" the way lol... No more parrot and much less use of the proof and tralle hydrometer... I do use a vapor thermometer at the top of my riser and keep one of those charts handy to know how much ethanol is left in the boiler and when it get's close to 212*F I stop the stripping run. From there on a spirit run I can use detailed notes from prior tuns of specific recipes to determine where I made cuts before and test the theory that I can make cuts at the same place and test my ability to call it on the fly....

Cheers!
-jonny
————
i prefer my mash shaken, not stirred
————
User avatar
Deplorable
Site Donor
Site Donor
Posts: 3984
Joined: Thu Jun 25, 2020 12:10 pm
Location: In the East, (IYKYK)

Re: Temperature & ABV Relationship Charts

Post by Deplorable »

Thanks!
Fear and ridicule are the tactics of weak-minded cowards and tyrants who have no other leadership talent from which to draw in order to persuade.
User avatar
Kareltje
Distiller
Posts: 2176
Joined: Tue Feb 09, 2016 4:29 pm

Re: Temperature & ABV Relationship Charts

Post by Kareltje »

jonnys_spirit wrote: Thu Jul 09, 2020 11:46 am In a pot still the liquid and vapor temp are the same once the heatup stabilizes and the column comes up to temp. You can correlate the output ABV and use the chart to determine both the liquid temp & liquid ABV as well as vapor temp & vapor ABV. When this finally clicked for me it was a bright light lighting up and "shining" the way lol... No more parrot and much less use of the proof and tralle hydrometer... I do use a vapor thermometer at the top of my riser and keep one of those charts handy to know how much ethanol is left in the boiler and when it get's close to 212*F I stop the stripping run. From there on a spirit run I can use detailed notes from prior tuns of specific recipes to determine where I made cuts before and test the theory that I can make cuts at the same place and test my ability to call it on the fly....

Cheers!
-jonny
True!
But as a correction for your specific still (column, bridge, condensor) you could make a graph of the temperature and the percentage at the same time.
I find my thermometers have a slight difference and my cooler has a delay.
You can make graphs especially for your own specific still.
Post Reply