Spreadsheet for Water Treatment Operators

Knowing water cation and anion analyses, pH, EC and temperature, this spreadsheet calculates various water quality parameters including: hardness, ALK/(Cl+SO4) & SO4/(Cl+SO4) ratios (used in some corrosivity assessment models), Sodium Adsorption Ration (SAR), TDS (as mg/L & meq/L), Ionic Strength (by two methods), Acidity, Corrosivity Indices (Langelier Saturation Index [LSI], Aggressiveness Index, Larson Index & Calcium Carbonate Precipitation Potential [CCPP] by graphical method [see paper by P.Gebbie presented at 2000 AWWOA Conference, Warrnambool]) & estimated coagulant doses for surface water treatment. Please direct any queries &/or comments you may have about this resource to George Wall at model@wioa.org.au.

Spreadsheet for water treatment operators (Excel Spreadsheet. Version 5.0-95. 2.85 MB)

Conversion program for various units of distance, temperature, volume, time, speed, mass, power, density, pressure, energy and many others, including the ability to create custom conversions.

Convert 4.10 (ZIP 168k)

Note: The download is ZIPped to save space and time. You will need to unZIP it once it has been downloaded. If you don't have a ZIP utility, you can get one from WinZip.

Gran Plot Spreadsheet (Excel Spreadsheet. Version 5.0-95. 62 KB)

Blank Balance Model 5.0-95.xls (Excel Spreadsheet. Version 5.0-95. 19 KB)
Blank Balance Model 97-2000.xls (Excel Spreadsheet. Version 97-2000. 20 KB)

Last updated on 08-Feb-2012