Network
Getting started
New to this tool? Turn on Worked example (top right) to see three supplies filled in, then turn it off to enter your own. Your own data is kept aside and comes back when it is off.
This tool turns a year of drinking water failures into two scores for your organisation: the Compliance Index and the Assurance Index. Lower is better. The scores are most useful for comparing: this year against last year, or one supply against another.
- Compliance Index: how often the water itself fell short of the standards, weighted by how much each problem matters for health.
- Assurance Index: how often the checks, monitoring and records required by the Drinking Water Quality Assurance Rules were missed.
Bigger plants and zones count for more. A problem at a plant that makes most of your water moves the score more than the same problem at a small one.
What's in each tab
- Network: your supplies, treatment plants and distribution zones. Set this up once.
- Compliance: water quality failures, such as E. coli detections, high turbidity, or metals over the limit.
- Assurance: missed requirements, such as monitoring gaps, overdue plans or skipped inspections.
- Dashboard: both scores, what each plant and zone adds to them, and a My Water view for any one zone.
- Records: save a snapshot of your scores to compare over time.
- Report & Save: print a PDF report, export to Excel, or save your work to a file.
About this model and Settings
About this model (top right) explains the method and where it comes from.
Settings holds the risk factors. Every type of failure has a risk factor from 1 (minor) to 5 (serious), shown in the tool as f=1 to f=5. Sensible defaults are already set; you can change any of them in Settings.
How to start
- Want to see it filled in first? Turn on Worked example above.
- Add a supply, then its treatment plants (with daily output) and distribution zones (with population served).
- If a supply has more than one plant, tick which plants feed each zone.
- Record failures on the Compliance and Assurance tabs. The scores update as you go.
Clear all (bottom of this tab, two clicks) removes every supply, plant, zone and failure; snapshots and risk factors are kept.
Compliance
Guide: using this tab
Record anything that went wrong with the water itself. Each failure is multiplied by its risk factor, then scaled by the size of the plant or zone, and added into the Compliance Index.
- Protozoa barrier failures (plants): days the treatment that removes or kills protozoa such as Giardia and Cryptosporidium didn't work as it should, for example filtered water turbidity too high or UV dose too low. Always f=5.
- Bacterial barrier failures (plants and zones): days disinfection fell short, for example chlorine too low. Always f=5.
- Parameter failures: a test result over the limit for a specific substance or measure, such as E. coli, lead or iron. Pick it from the list and enter the days or samples over the limit. Each has its own risk factor, shown next to its name.
Days or samples? The Rules check treatment and monitoring one day at a time, so plants with continuous online monitoring count each day that didn't comply. Smaller plants that rely on sampling count each failed sample instead. Use the same approach each year so your scores stay comparable.
The list only shows parameters that can be recorded at that location. Anything that comes from the source water or from treatment, such as pH, fluoride, nitrate, iron or manganese, can be recorded at a plant or a zone. Things that form or change in the pipes, such as lead, copper or trihalomethanes, are zone only.
Record each failure once, where it was measured. If a result over the limit at the plant outlet also shows up in the zones it supplies, record it at the plant only, or it will be counted twice.
Assurance
Guide: using this tab
Record requirements under the Drinking Water Quality Assurance Rules that were missed. These are the checks, monitoring and records that show your water is being kept safe, even when the water itself was fine.
For each plant, each zone, and your organisation as a whole, add a row for each requirement that was missed and how often: the number of days for requirements checked every day, or 1 for a one-off such as an overdue plan. The list only shows requirements that apply at that level. Each has its own risk factor, shown next to its name.
Plan status also counts: each plant's source water risk management plan and each zone's water safety plan add 0 if up to date, 2 if under review, and 5 if missing or expired. Set these on the Network tab.
Dashboard
Guide: using this tab
Both scores in one place. Lower is better. The tables show how much each plant and zone adds to the totals, so you can see where to focus.
My Water, at the bottom, shows one zone from a customer's point of view: everything that affected the water reaching that zone, counting only the plants that supply it.
- Lower is better. 0 means no failures were recorded, which is the lowest risk.
- A higher score means more failures, more serious failures, or failures at bigger plants and zones.
- There's no pass mark. Compare each score with itself: this year against last year, or one supply against another.
- The two scores are worked out differently, so don't compare the Compliance Index with the Assurance Index.
- A dash (–) means the score isn't available yet.
Records
Guide: using this tab
Track your scores over time. Save a snapshot whenever it makes sense, for example at the end of each reporting year or after an upgrade.
Each snapshot shows both scores and the change since the one before. A green down arrow means things improved; a red up arrow means they got worse. Click Details on a row to see every plant and zone as they were at that time.
Save a snapshot
Green and red arrows mark a better or worse score than the snapshot before. Colour bands are prompts to look, not instructions to act.
Report & Save
Guide: using this tab
Everything you take out of the tool is here.
- PDF report: choose which tabs to include and click Generate PDF. When the print window opens, choose Save as PDF.
- Export to Excel: all your results and entries as a spreadsheet file.
- Save to file: keeps everything (network, failures, risk factors and snapshots) in one file on your computer. Use Open a saved file to carry on later or share with a colleague.
Generate PDF report
Tick the tabs to include. When the print window opens, choose Save as PDF.
Export to Excel
All your results and entries as a CSV file, ready to open in Excel.
Save or open your work
Save your network, failures, risk factors and snapshots to a file on your computer. Open it later to carry on, or share it with a colleague. If example data is showing, your own data is saved, not the example.