Bleach Dilution Calculator

Select application from dropdown menu below

EPA recommended free chlorine level, PPM

 

Select Hill Brothers bleach concentration, WT.%

Enter starting volume of water, US. Gal

Enter target free chlorine level, PPM

(select application from dropdown menu above for recommended free chlorine level)

Target free chlorine level cannot be reached with the selected bleach concentration. Adjust target free chlorine level accordingly.
Required amount of bleach is:

US. Gallons

and

US. Fl oz

WARNING: Target free chlorine level is outside the EPA recommendation for the selected application.

Target Available Chlorine, PPM

Use and Application

1000 to10000

5

10

200

600

[Other application ]

total wt current batch *((0-desired conc%)/((desired conc%-bleach concwt%)

IF('Calculator and EPA menu'!C7=5.25%, 'Calculator and EPA menu'!C8*'Calculator and EPA menu'!C9*B16,'Calculator and EPA menu'!C8*'Calculator and EPA menu'!C9*B27)

Link https://www.publichealthontario.ca/en/health-topics/environmental-occupational-health/water-quality/chlorine-dilution-calculator

only allow numbers greater than zero: https://www.extendoffice.com/documents/excel/3968-excel-only-allow-negative-numbers.html

Link to compare calc to Ontario http://www.foodsafe.ca/dilution-calculator.html

link to compare https://www2.health.vic.gov.au/public-health/infectious-diseases/infection-control-guidelines/chlorine-dilutions-calculator

Dropdown concentration

Reference for Notice disclaimer: https://www.youtube.com/watch?v=KkTaQ5OjAGc

Hide cells and columns, https://www.youtube.com/watch?v=u04xB74PNGY

12.50%

for 5.25%

for 12.50%

5.25%

US. Gal

US. Gal

Required Amount of Hill Brothers Sodium Hypochlorite:

5.25% density

wt.% Free chlorine

wt. of Free chlorine per gallon

US. Gal

Density of Water

ppm

gal bleach / (targetppm*totalgallonsof solution)

Split gals and oz

Total gallons of 5.25% bleach

US. Gal

fl oz

Total Gallons of H2O

Total Gallons of solution

Note: A factor of 1.0375 was included to account

for correct volume of 1 gallon of bleach for maximum target ppm of 50000

12.50%

Added round function to round to 2 decimal places

wt.% Free chlorine

wt. of Free chlorine per gallon

Density of Water

ppm of Free chlorine in 1 gallon of 12.50% + 1 gal H2O

Error to account for negative numbers:

gal bleach / (ppm*total gallons)

US. Gal

fl oz

Error to account for #DIV/0!:

US. Gal

fl oz

Note: A factor of 1.089119 was included to account

for correct volume of 1 gallon of bleach for maximum target

ppm of 119000

To show 1 gallon instead of 128 fl oz

US. Gal

fl oz

Make Zero Blank

Make values blank when [click here to select concentration]

Below is data validation criteria for C9 in "Calculator and EPA menu" tab

Use gallons, and, US fl oz only when necessary

Specify requirement only when value is present

To show fields below only when C9 data validation (in calculator tab) is true

To show values only when C9 data validation (in calculator tab) is true

5 to 10

5

10

Swimming pool water disinfection (new pool or spring startup)

5

SPAS, HOT TUBS, IMMERSION TANKS, ETC.

600

SANITIZATION OF POROUS FOOD CONTACT SURFACES SPRAY/FOG METHOD

200 to 600

200

600

SANITIZATION OF NONPOROUS FOOD CONTACT SURFACES SPRAY/FOG METHOD

200

SANITIZATION OF NONPOROUS NON-FOOD CONTACT SURFACES (RINSE METHOD)

100

WAREWASHING (FOR SANITIZING TABLEWARE IN LOW TEMPERATURE DISHWASHING MACHINE)

200

COMMERCIAL LAUNDRY SANITIZERS

500

AGRICULTURAL - POST HARVEST PROTECTION

25

AGRICULTURAL - FRUIT AND VEGETABLE WASHING

10

AQUACULTURAL - FISH PONDS

1000

Note: Cell references are on "Calculator and EPA menu" page