Tools & Resources
WIOA welcomes contributions from any persons or organsiations which can be used as a resource by operational people in the water industry to improve their efficiency, knowledge or skills.
Guide to measurement and use of Ct
Disinfection of water (potable or recycled) with a chemical disinfectant (chlorine or chloramine) requires time for the chemical to react with and kill the target microbial pathogens. Ideally, the time for the reaction is provided in a purpose-built reactor or contact tank as this is specifically designed for this purpose and provides a controllable process. The reality however is quite different. Most water supplies rely on disinfection to occur in clear water tanks and reservoirs of various sizes, with various arrangements of inlet and outlet structures and varying levels of short-circuiting. The effective contact time is often less than is assumed.
Many water utilities use a target free or total chlorine residual in their treatment systems to achieve a level of disinfection that they understand to be adequate. This approach to disinfection can be improved in most cases.
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. 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.
Management of Distribution System Mains Breaks (Water RF 2014)
Revision of – the Water Main Disinfection Standard
Flushing Velocity Calculator
Excel calculator for pipe diameter, flushing rate and flushing time.
Flushing Velocity Calculator – Spreadsheet (Excel Spreadsheet)
Water Treatment Analyser Tools
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.
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)
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 firstname.lastname@example.org.
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:
- Calculates different forms of alkalinity and carbon dioxide: OH, CO3, HCO3 and CO2
- Can be used for wastewater treatment as NH3, PO4 and NO3 analytes
- Can be used for RO/demineralisation modelling as Ba, Sr and silica
- Fluoride added
Measuring Alkalinity – Gran Plot Technique
Gran Plot Spreadsheet (Excel Spreadsheet. Version 5.0-95. 62 KB)
Water Balance Model Spreadsheets
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)
The Water Research Foundation – Web and software-based applications that help professionals understand and apply research results.
The Smart Water Networks Forum – The SWAN Interactive Architecture Tool allows you to navigate through smart water solution diagrams according to your specific business drives and challenge areas.
Intelligent Water Networks – The IWN investigates new technologies and innovations to meet common challenges such as population growth, ageing infrastructure and climate variability in a more efficient manner.