Hi there,

We use a mathematical formula which approximates the amount ethanol and water contract when mixed for diluting our spirit pre bottling.

This assists us to bottle spirit in an efficient manner and without recourse for spending money on software to do the same. However, our method is not quite right as at times we need to adjust our spirit prior to bottling to ensure the ABV is in the right tolerance range.

This can be time consuming so if anyone knows a fool proof method we would be very grateful !

Cheers

Reply:

Download TTB tables, they are free, then a bit of high-school math and you will have the correct answer.

The actual formula is a monster and I don't have it, except in the background of Alcodens program

Reply:30 minutes ago, PeteB said:

Reply:

TTB tables do account for shrinkage, but there is __not__ a table that shows if you add a certain amount of water to a certain proof, there is your answer.

That is where the maths comes in.

I have only used TTB tables for mental stimulation, and it has been some time. (I am Aussie so I don't use them)

I suggest you post a theoretical blend that you are trying to achieve and someone will post the math of how it is done. If no-one posts then I will re-learn and post the method for you

Pete

Reply:

Ok so here is one theoretical blend.

You have 100 gallons of 160 proof ethanol and you add 100 gallons of water. What is your final proof and what is your total gallons. Assuming everything is at 60 degrees.

Reply:

Disclaimer: I am the author of the AlcoDens blending app mentioned below, so I am probably biased.

This question of how to do blending calculations comes up fairly often, so I wrote this article to compare 3 of the methods.

I have not seen any really comprehensive guide to performing calculations using the TTB Tables, but I am aware of two distillers who are in the process of preparing books that will cover this. Hopefully early next year (2018) things will be better.

The theoretical blend proposed by whiskeytango is unfortunately not in the form for which the TTB Tables were structured. The tables are designed to easily answer the question of how much water to add to dilute the 100 gallons of 160 proof down to 80 proof. But it can be done. I will show my solution but perhaps someone who actually uses the TTB tables can show an easier way.

From Table 6, 160 proof spirit contains 80 parts of alcohol and 22.87 parts of water. BTW, the fact that these add up to 102.87 shows how the tables do include the effect of contraction.

If we now add 100 gallons of water to 100 gallons of 160 proof spirit we still have 80 parts (gallons) of alcohol but we now have 122.87 parts of water. The ratio of parts of alcohol to parts of water is 80/122.87 = 0.6511. Now we have to scan through Table 6 to find what proof corresponds to this ratio. As I said, the tables are not structured to make this easy.

At 81 proof the ratio is 40.5/62.95 = 0.6434

At 82 proof the ratio is 41.0/62.47 = 0.6563

By interpolation we see that a ratio of 0.6511 corresponds to a strength of 81.6 proof.

This diluted spirit obviously contains 81.6/2 = 40.8 parts of alcohol. This came from the original 80 gallons of alcohol in the 160 proof spirit. If 80 gallons is 40.8 parts then the total parts (i.e. 100) must be 80x(100/40.8)= 196.08 gallons.

Naturally, I checked this with AlcoDens to make sure I had the correct answers. Because I do not do these calculations using the TTB Tables very often I did make a few mistakes along the way, but the values above compare well with the AlcoDens answer shown below.

Reply:9 hours ago, whiskeytango said:

Reply:

Thanks Tom, using Table 4 is a bit easier because it provides data for every 0.1 proof and it is probably easier to understand.

For comparison with my earlier calculation here is the Table 4 method.

160 pf spirit has 0.13903 WG/lb. Table 4 only starts at 1 proof and from standard engineering tables the specific volume of water at 60 degrees F is 0.12008 WG/lb.

The weight of the spirit is therefore 100/0.13903 = 719.27 lbs and the weight of the water is 100/0.12008 = 832.78 lbs

The total weight is 719.27+832.78 = 1552.05 lbs. This contains the same 160 PGs that were in the original spirit so we have 160/1552.05 = 0.10309 PG/lb

Table 4 shows (without interpolation) that this is 81.6 proof and the specific volume is 0.12633 WG/lb

Total volume is 1552.05 x 0.12633 = 196.07 gallons

This is definitely shorter and more direct than my earlier calculation. But AlcoDens still wins, especially if the temperature is not 60 F and the calculated PG/lb requires interpolation.

Reply:18 hours ago, whiskeytango said:

Reply:5 hours ago, PeteB said:

Reply:

PeteB - The calculation for the quantity of water required to dilute to a target proof is illustrated in the article I referenced before. The example is based on volumes, but it could easily be converted to weights using a similar method to what I showed above when using Tom's suggestion to use Table 4.

whiskeytango - The questions you are asking are exactly those AlcoDens was designed to answer. The formulas are way too complex to use in manual calculations. They are freely available from the OIML site if you want to see just how involved they are.

QuoteReply:

Great program. This is exactly what we need at our distillery. Its not so easy to use at first, until you get the hang of it.

Reply:1 hour ago, John Bassett said:

Reply:5 hours ago, John Bassett said:

Reply:

Thanks to @John Bassett and @HedgeBird for the kind words.

@PeteB - please will you make a screen shot of where the problem occurred. I guess it wasn't on the Hydrometer Correction calculator? If it was on one of the blending calculators then maybe I could lock the choice between Proof, ABV and Mass the way that the Standard Temperature can be locked. This would allow all the choices to be fixed for normal work, but leave the option open for the one weird day when you need to blend some European (or Aussie!) ABV spirit with some American Proof spirit.