- Before
- Builds the balance once a year for the whole system, then has to decide where crews go on a figure whose doubt is a single grade at the end. “I can't send a crew on a number I don't trust.”
- Now
- Opens a balance for every zone each month with a band on every figure, ranked by certain loss, and sends survey and meter-test orders up to $25,000 from the same screen.
One month's balance, from the meters to a leak survey on Quarry Lane
Lumina Utilities supplies the Eastvale supply area: 18 district metered areas, 136,330 connections and 991 km of mains, with 61.99 M m³ put into supply in the 12 months to 30 Sep 2026. On Tuesday 13 October the agents rebuild the balance at 06:12. Here is what happens next, screen by screen, in the working solution.
- 01Morning
The balance opens as a waterfall, a band on every bar
Hannah Okoye · Water loss managerHannah owns the balance, the leak survey budget and the annual audit. Her home screen is the standard water balance for Eastvale: 61.99 M m³ put into supply, 45.51 M m³ billed, 0.79 M m³ unbilled authorised, 3.01 M m³ apparent losses, and real losses as what is left. Non-revenue water is 26.6% ± 1.2, worth $16.44M a year. Beside it, all 18 zones are ranked by the part of their real loss that is certain.
“Real losses are what is left once everything else is counted, so their band carries the doubt of every other figure.”
- 0206:12 · 41 s
From 2.1 million flows to 19 balances
Seven agentsThe meter data reconciler reads 4 production and 18 zone inlet meters — 2.1 million 15-minute flows — fills three missing nights for Weir Lane and applies each meter's tested error. The billing period aligner fits 1,084,212 reads to 1 Oct – 30 Sep and flags 1,910 estimated and 418 stuck meters. The water balance builder counts 412 hydrant permits, 96 mains-flushing jobs and the fire service log. The apparent loss estimator sizes meter under-registration from 2,412 bench tests. Then 19 balances are built, each with a 95% band.
Night-flow analyst: “16 zones agree within their band · Kestrel Fields (−41%) and Weir Lane (−27%) do not: inlet meters in doubt”
- 03Ranked by likely value
Kestrel Fields looks worst — and its meter was last tested in 2019
Meter data reconcilerRanked by likely value, Zone 07 Kestrel Fields comes first: real losses of 32.6%. But the band is ± 12.1 pts, from 20.5% to 44.7%, because its mechanical inlet meter was last tested on 19 Aug 2019. Night flow gives only 0.60 M m³ of real losses for the year against 1.02 M m³ in the balance — 41% apart. The action offered is an inlet meter test, $3,200 and one day, not a survey.
“The band is ±12.1 pts: most of this figure could be the inlet meter. A survey now could find nothing.”
- 04Ranked by certain loss
Ashcombe Heights: 31.0%, and the highest that is certain
Water balance builderRanked by certain loss, Zone 12 Ashcombe Heights is first. Its 7,420 connections and 64 km of mains took in 3.41 M m³; real losses are 1.06 M m³, 31.0% ± 2.2, with a certain part of 28.8%. Its electromagnetic inlet meter was verified on 9 Sep 2026, so confidence is high. ILI 7.0, 390 litres per connection a day, $1.25M of lost water a year.
“Certain real loss 28.8% is above the 20% trigger, and the band is within ±3 pts.”
- 05On the map
Eighteen zones, coloured by what is certain
Hannah Okoye · Water loss managerThe zone map draws every district metered area by its certain real loss, with zones whose band is wider than ±6 pts hatched — Kestrel Fields and Weir Lane. Hannah can colour it by likely loss or by band width instead. Ashcombe Heights, on the River Ash, is the darkest zone, and its summary offers the leak survey.
- 06The night of 14 June
Night flow agrees: up 58 m³/h since June
Night-flow analystMinimum night flow between 02:00 and 04:00 stepped from 128 to 186 m³/h on the night of 14 June, minutes after Pump 2 at the Ashcombe booster tripped and restarted, with a pressure surge from 58 to 81 m. No burst was reported. Bottom-up, the night flows give 1.02 M m³ for the year — within 4% of the balance's 1.06 M m³, inside its band. At today's rate the zone is losing 1.36 M m³ a year.
Intervention planner: “The step test of 1–2 Oct puts 86 of the 162 m³/h net night flow on Quarry Lane — 19 km of mains, mostly 1950s cast iron.”
- 07Every day, 05:00
The daily night-flow watch, for every zone
Tomás Reyes · Network engineerEach morning the night-flow analyst checks all 18 zones and lists what changed: the Ashcombe Heights step, Kestrel Fields' night flow too low for its balance, three missing nights and a pump-station meter reading 6–9% above its pump curve in Weir Lane, Copperhill creeping up 0.12 m³/h a night since May, and the Cardew Park burst on Fenwick Road, repaired and verified. Tomás has a step test booked in Copperhill for 20 Oct.
The night-flow analyst flags; it never closes a zone's alert.
- 08One click
A leak survey order, inside her limit
Hannah Okoye · Water loss managerHannah sends the survey from the balance. The order goes to Calder Acoustic Surveys under framework contract LW-2024-07: 64 km of mains and 7,420 services, Quarry Lane first, acoustic correlation and ground microphone on the nights of Thu 15 Oct to Mon 19 Oct. It costs $19,840 — 64 km at $310 — within her $25,000 limit.
Target: “net night flow 162 → 70 m³/h · 0.77 M m³ and $479K a year”
- 09Booked
The plan, ranked by certain water won back per dollar
Intervention plannerSurvey order LS-2610-12 moves to Booked. The plan shows every action with its water and value a year, cost, payback and owner: night pressure 71 → 55 m at PRV RE-2 in Riverside East for 0.31 M m³ and $192K a year, the Kestrel Fields meter test first, 1,240 customer meters over 20 years old being replaced in Sandown Edge, and the Fenwick Road burst repaired and verified.
The intervention planner proposes; it never dispatches a crew or spends money.
- 10Signed · 13 Oct
The annual water audit, signed by the director
Owen Mbeki · Director, water networkThe audit report writer drafts the annual water audit from the same figures: the water balance in thousand m³ with its 95% bands, the performance indicators with their data grades — real losses of 255 litres per connection a day, ILI 4.9, 15 of 18 zones with high confidence — and a board note in plain words, every figure cited. Hannah sends it to Owen, and Owen signs.
Board note: “Two zones, Kestrel Fields and Weir Lane, show high losses we cannot yet trust: their inlet meters are in doubt. We will test those meters before sending crews.”