Alcohol Dilution Calculators

Spreadsheet Version

Intended Use of the Calculators

The calculators are for use in diluting ethyl alcohol (ethanol) or isopropyl alcohol (isopropanol) with water. The accuracy of the results from the calculator is sufficient for home and some commercial use.

Some Examples of Use:

Assumptions

Technical Notes

Equations

Terms Used

Term Definition
Concentrated alcohol the alcohol that you have, whose concentration (in %volume/volume) you know, and which you want diluted by adding water
Initial alcohol concentration concentration, in %v/v, of the concentrated alcohol
Diluted alcohol the alcohol that you obtain after adding water to the concentrated alcohol
Final alcohol concentration concentration, in %v/v, of the diluted alcohol

Which Calculator to Use?

There are two calculators to choose from:

Calculator A

INSTRUCTIONS:

  1. When typing in numbers, do not enter any spaces or commas. Other than digits, the decimal point (dot) is the only non-numeric character that will be recognized. A number that contains spaces or any other non-numeric character other than a single decimal point (dot) is not considered a valid input and will be ignored.
  2. Enter all of the requested values in Table A1
  3. In Table A2 enter one and only one of the values and select your preferred units for both weight and volume
  4. You may enter requested value for Table A3 if desired
  5. Click on the CALCULATE button
  6. Results will appear in Table A4
Table A1 : Required Information
Select or enter values for all of the following items
Type of alcohol
Temperature of the alcohol and water
(volume of the liquids is temperature-dependent)
%vol/vol
(min value is 40%, max is 100%)
%vol/vol
(min value is 40%, max is 100%)
Table A2 : More Necessary Information
Enter the value for one and only one of the following four items Select preferred units for both weight and volume
W
E
I
G
H
T



V
O
L
U
M
E





Table A3 : Optional Information
Value Units
any currency per unit volume
Table A4a : Summary of Data Provided by the User
Information Value
Type of alcohol
Temperature
Initial alcohol concentration
Final alcohol concentration
Preferred unit of weight
Preferred unit of volume
Cost of concentrated alcohol
Table A4b : Computation Results
Description Value Units
W
E
I
G
H
T
Weight of concentrated alcohol
(weight of alcohol to be diluted)
Weight of water
(weight of water needed to dilute the concentrated alcohol)
Weight of diluted alcohol
(weight of concentrated alcohol + added water)
V
O
L
U
M
E
Volume of concentrated alcohol
(volume of alcohol to be diluted)
Volume of 100% alcohol
(volume of pure alcohol if separated from all the water)
Volume of added water
(volume of water needed to dilute the alcohol)
Volume of diluted alcohol
(volume of concentrated alcohol and added water)
Volume loss due to contraction
%
Final alcohol concentration
(concentration of diluted alcohol)
%v/v
C
O
S
T
Total cost any currency of choice
Cost per unit volume

Calculator B

INSTRUCTIONS:

  1. When typing in numbers, do not enter any spaces or commas. Other than digits, the decimal point (dot) is the only non-numeric character that will be recognized. A number that contains spaces or any other non-numeric character other than a single decimal point (dot) is not considered a valid input and will be ignored
  2. Enter all of the requested values in Table B1
  3. In Table B2 enter the requested pair of values and select your preferred units for both weight and volume
  4. You may enter requested value for Table B3 if desired
  5. Click on the CALCULATE button
  6. Results will appear in Table B4
Table B1 : Required Information
Select or enter values for all of the following items
Type of alcohol
Temperature of the alcohol and water
(volume of the liquids is temperature-dependent)
%vol/vol
(min value is 40%, max is 100%)
Table B2 : More Necessary Information
Enter two values:
1. Desired weight or volume of the alcohol to be diluted, and
2. Desired weight or volume of water to be added
Select preferred units for both weight and volume
W
E
I
G
H
T



V
O
L
U
M
E





Table B3 : Optional Information
Value Units
any currency per unit volume
Table B4a : Summary of Data Provided by the User
Information Value
Type of alcohol
Temperature
Initial alcohol concentration
Preferred unit of weight
Preferred unit of volume
Cost of concentrated alcohol
Table B4b : Computation Results
Description Value Units
W
E
I
G
H
T
Weight of concentrated alcohol
(weight of alcohol to be diluted)
Weight of water
(weight of water needed to dilute the concentrated alcohol)
Weight of diluted alcohol
(weight of concentrated alcohol + added water)
V
O
L
U
M
E
Volume of concentrated alcohol
(volume of alcohol to be diluted)
Volume of 100% alcohol
(volume of pure alcohol if separated from all the water)
Volume of added water
(volume of water needed to dilute the alcohol)
Volume of diluted alcohol
(volume of concentrated alcohol and added water)
Volume loss due to contraction
%
Final alcohol concentration
(concentration of diluted alcohol)
%v/v
C
O
S
T
Total cost any currency of choice
Cost per unit volume