Useful Tools and Resources

Water Treatment Analyser Tools

Water Treatment Analyser Article from Operator Newsletter (96kb PDF)

The Water Treatment Alliance and the Water Services Association, with support from the Victorian Department of Health, have developed some Excel based software tools to allow Water Utilities and Water Treatment Plant (WTP) operators to assess the performance of their plants at the two key control points for pathogen control, namely media filtration and chlorine-based disinfection.

Instructions for use:

• Select the Analyser from the links below
• Select “Save” and navigate to your preferred folder location, and select Save.
  Do not change the workbook name.
• Close MS Excel.
• The tools must be opened from MS Excel and not from file manager.
• Start Excel. Go to File/Open, navigate to the saved file location and select the file. Click on open.
• Follow the on-screen instructions to use the tools.

Disinfection

The WTAnalyser allows you to download and extract data from SCADA trends for detailed analysis. Since the trending system samples at short time intervals, very large amounts of data make up the trends. The first step is to extract a subset of the data for further analysis.

Water Treatment Analyser Disinfection - Spreadsheet (v3.0 Excel Spreadsheet)

Filtration

This tool has been developed to assist you in analysing the performance of filters at your plant. It extracts data from other MS Excel or csv files. Once data is selected it is automatically processed into a graphical and statistical format that will tell you how your filters are performing.

Water Treatment Analyser Filtration - Spreadsheet (v3.2 Excel Spreadsheet)

H2Ea - Spreadsheet for Water Treatment Operators V2.0

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 info@wioa.org.au.

H2Eau Spreadsheet for water treatment operators (Excel Spreadsheet. Version 2.0 Nov 2012- 3MB)

The new version updated in November 2012 has fixed the error in the previous version, as well as several enhancements:

1. Calculates different forms of alkalinity and carbon dioxide: OH, CO3, HCO3 and CO2
2. Can be used for wastewater treatment as NH3, PO4 and NO3 analytes
3. Can be used for RO/demineralisation modelling as Ba, Sr and silica
4. Fluoride added

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 23-Nov-2012