Factor 0 Posted September 5, 2017 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 Share this post Link to post Share on other sites

PeteB 47 Posted September 5, 2017 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 Share this post Link to post Share on other sites

whiskeytango 11 Posted September 5, 2017 30 minutes ago, PeteB said: 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 Will the ttb tables actually account for the shrinkage of liquid when you combine alcohol and water? Iv never seen this listed on their tables. Share this post Link to post Share on other sites

PeteB 47 Posted September 6, 2017 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 Share this post Link to post Share on other sites

whiskeytango 11 Posted September 6, 2017 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. Share this post Link to post Share on other sites

meerkat 14 Posted September 6, 2017 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. Share this post Link to post Share on other sites

Tom Lenerz 15 Posted September 6, 2017 9 hours ago, whiskeytango said: 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. Do it by weight, and do it with TTB table 4. https://www.ttb.gov/foia/Gauging_Manual_Tables/Table_4.pdf Share this post Link to post Share on other sites

meerkat 14 Posted September 6, 2017 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. 1 Share this post Link to post Share on other sites

PeteB 47 Posted September 6, 2017 18 hours ago, whiskeytango said: You have 100 gallons of 160 proof ethanol and you add 100 gallons of water The answer for this blend does clearly show shrinkage, but it is not the most common type of diluting done in a distillery. More often the question would be: How much water do I need to add to bring the proof down to 80? Meerkat could you show these calculations please. As Tom said above use mass not volume for your measurements then you don't have to do temperature calculations. I have done TTB calculations in the past and sometimes it is easier to understand and calculate if it it done in volume at 60f, but at the end convert back to mass for actual measurement. Share this post Link to post Share on other sites

whiskeytango 11 Posted September 7, 2017 5 hours ago, PeteB said: The answer for this blend does clearly show shrinkage, but it is not the most common type of diluting done in a distillery. More often the question would be: How much water do I need to add to bring the proof down to 80? Meerkat could you show these calculations please. As Tom said above use mass not volume for your measurements then you don't have to do temperature calculations. I have done TTB calculations in the past and sometimes it is easier to understand and calculate if it it done in volume at 60f, but at the end convert back to mass for actual measurement. Yes very true, your request is much more common. What i would like is a formula that lets me take a density reading and determine that i have X proof alcohol. Then i would like to add an exact amount of water then take a new density reading showing a lower proof because of the water i added. Then i would love to be able to have something that says i have an unknown volume of X proof that i add a known volume of water to and also have a final proof. So by using the change in proof and the known quality of water added determine my total volume of spirit at the final proof. Does that make sense? Share this post Link to post Share on other sites

meerkat 14 Posted September 7, 2017 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. Quote What i would like is a formula that lets me take a density reading and determine that i have X proof alcohol. The AlcoDens calculator for doing this can convert back and forth between Mass (Weight) %, Density, Volume % (ABV), Proof and Molar % Quote Then i would like to add an exact amount of water then take a new density reading showing a lower proof because of the water i added. Then i would love to be able to have something that says i have an unknown volume of X proof that i add a known volume of water to and also have a final proof. So by using the change in proof and the known quality of water added determine my total volume of spirit at the final proof. As an example assume there is an unknown quantity of 150 proof spirit to which we add 100 lbs of water. After mixing the proof is 100 proof. What was the unknown volume of 150 proof spirit and what volume of 100 proof spirit has been produced? In the example shown below Source 2 is the pure water (Proof = 0). I have set the Source 2 quantity to mass and given the weight as 100 lbs, but you could equally well give the quantity as volume. In the bottom right panel you tell the program that the quantity of Source 2 is the known quantity. Set the Source 1 and Final Blend quantities to Volume and it will calculate how much 150 proof spirit was used and how much 100 proof has been produced. THis could be solved using Tom's Table 4 method provided all quantities are in weight terms by starting off with the classic "Let X be the mass of 150 proof spirit" and noting that the number of proof gallons does not change when you add pure water. Once the answers have been calculated in weight terms they can easily be converted to volumes. Share this post Link to post Share on other sites

John Bassett 1 Posted December 13, 2017 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. 1 Share this post Link to post Share on other sites

HedgeBird 31 Posted December 13, 2017 1 hour ago, John Bassett said: Great program. This is exactly what we need at our distillery. Its kinda what everyone needs at every distillery! 1 Share this post Link to post Share on other sites

PeteB 47 Posted December 13, 2017 5 hours ago, John Bassett said: ,,,,,,,,,,,,,,,. Its not so easy to use at first, until you get the hang of it. that is the same with any program when using for the first time. Meerkat I had a potential issue yesterday, we use both ABV and proof hydrometers (proof ones are so much cheaper) and this program makes it so easy to use both even in the one calculation just with one click of a mouse. Yesterday I notice Mass% was clicked instead of Volume%. I suggest on next update you make it slightly more difficult to change, maybe right then left click. Share this post Link to post Share on other sites

meerkat 14 Posted December 14, 2017 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. Share this post Link to post Share on other sites