← Watercalcs Estimates only — verify before relying on results. Estimates only · Terms of Use
Compliance Indices
v3.2
You're looking at example data. Your own data is safe and comes back when you turn this off. Changes made to the example aren't kept.
Scores can't be calculated right now. The calculation service can't be reached. Your entries are saved and the scores will show once the connection is back.
Step 1 of 6

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

  1. Want to see it filled in first? Turn on Worked example above.
  2. Add a supply, then its treatment plants (with daily output) and distribution zones (with population served).
  3. If a supply has more than one plant, tick which plants feed each zone.
  4. 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.

Your organisation, as it should appear on reports. A supply is a scheme with its own plants and zones; add one for each.
Step 2 of 6

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.

Taste, colour and odour problems are in the same list with lower risk factors. They count, but less than health risks.
Compliance Index
–
Lower is better. 0 is lowest risk.
Plant contribution
–
Zone contribution
–
Plants
Zones
Category breakdown
How much each type of failure adds to the Compliance Index.
Results by plant and zone
Step 3 of 6

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.

Assurance Index
–
Lower is better. 0 is lowest risk.
Plants & sources
–
Zones
–
Organisation-wide
–
Organisation-wide
Requirements that apply to your organisation as a whole rather than one plant or zone, such as staff training, laboratory accreditation and instrument calibration. These are added to the Assurance Index in full. Count the days missed for requirements checked every day, or 1 for a one-off.
Plants
Zones
Results by plant and zone
Step 4 of 6

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.

Compliance Index
–
Water quality failures, weighted by health risk
Assurance Index
–
Missed requirements, weighted by risk
How to read these scores
  • 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.
Supplier-level summary
Plant indices detail
Zone indices detail
My Water
A consumer-facing view: what does a person in a given zone actually see in terms of the failures touching their water?
Any zone on the Network tab; the view counts only the plants that feed it.
Step 5 of 6

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.

Add a short note to each snapshot so you remember what changed.

Save a snapshot

For example "after filter upgrade" or "2026/27 year end", so you remember what changed.
Trend
History

Green and red arrows mark a better or worse score than the snapshot before. Colour bands are prompts to look, not instructions to act.

Step 6 of 6

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.