Math question

[whiskeytango]

Ok all you SMRT guys out there here is you chance to prove it.

Im looking for an equation for a simple blending process. What i would like is an equation where you can plug in

YP (your known proof) then figure you add in X (amount of water) again a known amount then you take your next proof and you can calculate a total volume after the water is added.

the hard part is counting for the loss of volume you get when you add water to alcohol since we all know 1 gallon of water plus 1 gallon of alcohol doesn't equal 2 gallons of liquid

[daveflintstone]

Just get alcodens.

[whiskeytango]

Ok so Dave doesn't know. Anyone else?

lol

But seriously they don't run on Mac and I'm not buying a computer just for this.

[SpiritedConsultant]

I don't have an equation handy, but there is a simply way. Just take a 100mL samle of the spirit and dilute to your desired ABV (e.g. 63%--> 46%), recording how much water you added and the total volume. Only takes a few min. Just be sure to let the solution reach equilibrium before taking final measurements. Now you can just scale that ratio up for the dilution of that product.

[whiskeytango]

Not sure thats how it works, its my understanding that depending on the starting proof the amount of total volume will change.

So if you're diluting 1 gallon of 190 proof with 1 gallon of water you will actually have less then if you dilute 1 gallon of 100 proof with 1 gallon of water.

[SpiritedConsultant]

Yes. That is why you need to scale up the ratio. For example, if diluting (A) ml of spirit at (X)% ABV yields ( ml at (Y)% ABV, then (A) hl of spirit at (X)% ABV yields ( hl at (Y)% ABV. Basically, as long as you keep your ABV and dilution ratio constant, you can scale up to any batch size.

[meerkat]

Disclaimer: I am the author of AlcoDens and my opinion may be biased.

You can have either a simple equation or an accurate equation. I am not aware of an equation that satisfies both criteria. I have written an online article that discusses the simple equation (i.e. Pearsons Square) and compares its results with the accurate methods (i.e. TTB Tables or AlcoDens). The article is at

http://www.katmarsoftware.com/articles/alcohol-dilution-calculator.html

We have several users of AlcoDens running the program on Macs using Parallels or other Windows emulators. Not ideal, but it works well once set up. Both AlcoDens and Parallels offer free trial versions so you can see if this option works for you without buying anything.

[Stumpy's]

Here is a spreadsheet that I use. Hopefully this will help....I tink my calculations are right....It gets me in the ballpark but I'm sure it's not perfect

https://drive.google.com/open?id=0B1supbYToj38U3ZGWmwzcU0ya0k

Adam

[ebstauffer]

I think you need to grant "ALL" users read access to your google sheet.

[Stumpy's]

Sorry...forgot to turn link sharing on. Try this

https://drive.google.com/file/d/0B1supbYToj38U3ZGWmwzcU0ya0k/view?usp=sharing

[Jedd Haas]

Disclaimer: I am the author of AlcoDens and my opinion may be biased.

You can have either a simple equation or an accurate equation. I am not aware of an equation that satisfies both criteria. I have written an online article that discusses the simple equation (i.e. Pearsons Square) and compares its results with the accurate methods (i.e. TTB Tables or AlcoDens). The article is at

http://www.katmarsoftware.com/articles/alcohol-dilution-calculator.html

We have several users of AlcoDens running the program on Macs using Parallels or other Windows emulators. Not ideal, but it works well once set up. Both AlcoDens and Parallels offer free trial versions so you can see if this option works for you without buying anything.

I don't recommend Parallels at all. I found it extremely buggy, although that was a while back. They may have improved it; and they might have also upgraded their tech support, which was nonexistent at the time I bought it.

Instead, I recommend VirtualBox, which is currently published by Oracle and is free (although you will need a copy of Windows). Once you get Windows installed, it's very reliable for running AlcoDens. I have been running AlcoDens on my Mac for several years using this method.