- Before
- Owns the leak program, but the night data sits in the meter data store and nobody looks at it before the bill goes out.
- Now
- Opens the night-flow wall each morning with each home that stayed above zero ranked by liters lost, its likely leak and its cost a day, and decides only the alerts held for review.
One home's water runs all night: the leak alert, the follow-up and the credit
A large water utility reads its water meters every 15 minutes. On the night from Monday to Tuesday, the toilet tank at one home has been running since Saturday afternoon, and the resident has no idea. Here is what happens next, screen by screen, in the working solution.
A worked example on sample data. Names, IDs and figures on the screens and in this section come from the demo.
- 0105:10
Each meter's night, read before anyone is at work
Night flow readerThe night flow reader reads every water meter's 15-minute reads from 00:00 to 05:00. By 05:14, 9,840 homes did not reach zero, and 1,582 meters with gaps are sent back to meter operations to be re-read instead of flagged. By 05:15, 1,286 have stayed above zero for three nights in a row, 214 of them new this morning. The leak type reader finishes at 05:18 and the cost calculator at 05:19.
Cost at each tier: “≈ $46,800 a day” across this morning's continuous-flow homes.
- 02Morning
Healthy homes drop to zero; the leaking ones stay above it
Water conservation leadThe conservation lead opens the night-flow wall for one district: 118 homes with continuous flow, 21 new this morning. Each small line is one home from midnight to 5 am, on the same scale, with the zero line dashed under it. With “Only never-zero homes” on, four lines are left lit, at 940, 520, 1,320 and 1,100 L a day; the last is the home in this story. A fifth home, at about 120 L a day, sits under the 150 L alert line and is watched, not alerted.
The home: “1,100 L/day · low 0.74”
- 0307:00
201 alerts sent after quiet hours, 9 held for a person
Alert writerWhen quiet hours end at 07:00, 201 alerts go out by app and SMS, and 4 customers with no mobile number get a letter and an app message. Nine are held for the conservation lead: five burst-sized flows and two customers on the medical register are called first, and two have a leak type under the 85% needed to name it automatically. The largest, in another district, is 9,400 L a day; the call note for the water desk is already drafted.
Call note: “…if the meter still turns, a valve is stuck open. In this case, please close the main stop valve until a plumber has looked at it…”
- 04Held for you
One home: flat all night, lowest at 03:15, no time at zero
Leak type readerThe home's line has not stopped since Saturday at 14:20. Lowest flow 0.74 L/min at 03:15, 0 minutes at zero in three nights, about 1,100 liters a day, flat night over night. The leak type reader ranks toilet tank at 81%, float valve at 12% and underground supply pipe at 5%, and gives its reasons: steady 0.74–0.80 L/min with no pauses, unchanged night over night, and a start two minutes after a 9-liter flush.
“Held for you: Leak type 81%: under the 85% needed to name it automatically. Keep the leak type in the wording, edit it, or send without it.”
- 05Priced
About 28 dollars a day, at the customer's own tier
Cost calculatorThe last bills put the home on Tier 3, above 40 m³ a month, at $25.45 per 1,000 liters. So far the leak has cost about 2,970 liters and $75.59; if it runs to the next read it will be about 24.2 m³ and $615.89 on the bill. Beside it are the contact preferences: the utility's app then SMS, a preferred language, quiet hours 21:00–07:00, not on the priority services register, no leak adjustment in 12 months.
Run log: “1,100 L a day × $25.45 / 1,000 L = about $28 a day”
- 0607:41
One click, and the customer knows before the bill
Water conservation leadThe conservation lead reads the reasons, keeps “most often a toilet tank” in the wording and presses Send alert. The customer gets it in their preferred language, with the liters, the cost a day and one check they can do themselves. The follow-up watcher will check the next two nights; if the line still has not reached zero by Friday 07:00, the water desk gets a call task.
“Your water has not stopped since Saturday: about 1,100 liters a day, about $28 a day. Most often a toilet tank: put a few drops of food coloring in the tank; color in the bowl within 15 minutes means a leak. Reply FIXED when repaired, or HELP for a free water check.”
- 07The same morning
Delivered, read, replied, and did the flow stop?
Alert writer and Follow-up watcherOver the last seven days more than 1,400 alerts went out: 99% delivered, 87% read, 44% answered by the customer, and 53% of homes with the flow stopped within 72 hours. Each row names the home, the possible leak, the liters and the cost a day. One townhouse has already replied “FIXED, flapper replaced”; alerts not read yet can be resent by email.
“Every alert names the home, the liters, the cost a day and one thing to check.”
- 0872 hours later
The leaks still running get a call, medical register first
Water desk agentThe water desk's list holds the leaks still running 72 hours after the alert: 381 open, 38 calls due today, with a home on the medical register at the top. Another home read its alert last Friday and did not reply; 5,040 liters and $128.27 have gone since. At a third the customer replied FIXED, but the meter disagrees, so the case stays open.
Call note drafted by the follow-up watcher: “If it is the tank, a flush valve seal costs about $40 at any hardware store.”
- 09Repaired
Six policy checks, each cited, and the credit worked out
Adjustment checkerOne customer was alerted about a supply pipe leak, and the pipe was replaced 4 days later, with the plumber's invoice as proof and zero flow on the next two nights. The adjustment checker runs the leak adjustment policy: customer-side leak, repaired within 30 days of the first alert, proof of repair, two zero nights, no adjustment in 12 months, excess over 3 m³. The 52.4 m³ excess is re-rated from $25.45 to 15.40.
Credit drafted: $526.62 · “Over $500: a supervisor co-signs after you.”
- 10Signed
The adjuster signs, with the meaning of the signature
Billing adjusterThe billing adjuster approves the credit of $526.62 on the account with a password, and the meaning of the signature is recorded with it. Because it is over $500, it goes to the billing supervisor to co-sign. No agent applies a credit or changes a bill.
“Meaning of signature: I have checked the policy checks and the evidence.”