Ethanol Mixing Calculator

Download as xls, pdf, or txt
Download as xls, pdf, or txt
You are on page 1of 3

www.ghd.com.

au
GHD Tel. (03) 8687 8000 Fax. (03) 8687 8111
180 Lonsdale Street Melbourne Vic 3000

Binary Mixture - Ethanol & Water

This calculation determines the volume required of a known alcohol % that is required to be added to a known
Simply enter values in the first 4 columns and read the answer in last column.

The answer column has the formula and has been locked to prevent accidental alteration.

Enter Start % Enter Start Volume Enter Final % Enter Mixing %


Start % Alcohol Start Volume (L) Final % Alcohol Mixing % Alcohol
11% 100 18% 20%
11% 100 18% 30%
11% 100 18% 40%
11% 100 18% 50%
11% 100 18% 60%
11% 100 18% 70%
11% 100 18% 80%
11% 100 18% 90%
11% 100 18% 100%
12% 100 18% 20%
12% 100 18% 30%
12% 100 18% 40%
12% 100 18% 50%
12% 100 18% 60%
12% 100 18% 70%
12% 100 18% 80%
12% 100 18% 90%
12% 100 18% 100%
14% 100 18% 20%
14% 100 18% 30%
14% 100 18% 40%
14% 100 18% 50%
14% 100 18% 60%
14% 100 18% 70%
14% 100 18% 80%
14% 100 18% 90%
14% 100 18% 100%

14% 100 18% 70%

12/08/2021 23:04:08 Sheet1 1 of 3


C:\Program Files\Microsoft Office\Office\XLStart\book.xlt Page
www.ghd.com.au
GHD Tel. (03) 8687 8000 Fax. (03) 8687 8111
180 Lonsdale Street Melbourne Vic 3000

is required to be added to a known volume and alcohol % starting mixture to achieve a final % (desired) alcohol %.

ental alteration.

ANSWER
Mixing Volume (L)
350.0
58.3
31.8
21.9
16.7
13.5
11.3
9.7
8.5
300.0
50.0
27.3
18.8
14.3
11.5
9.7
8.3
7.3
200.0
33.3
18.2
12.5
9.5
7.7
6.5
5.6
4.9

7.692

12/08/2021 23:04:08 Sheet1 2 of 3


C:\Program Files\Microsoft Office\Office\XLStart\book.xlt Page
www.ghd.com.au
GHD Tel. (03) 8687 8000 Fax. (03) 8687 8111
180 Lonsdale Street Melbourne Vic 3000

red) alcohol %.

12/08/2021 23:04:08 Sheet1 3 of 3


C:\Program Files\Microsoft Office\Office\XLStart\book.xlt Page

You might also like