This workbook gives any rural system a fast, repeatable water-balance method using data you already have. Pair it with modern cellular metering your crew installs like a standard meter—no power, no Wi-Fi, no repeaters, no construction—and export clean CSV/PDF for your team.
You can’t see production, consumption, and discharge in one place. Rounds catch problems late, unlogged flushing/backwash skews numbers, aging meters hide apparent loss, and real leaks drain budget quietly.
· No single view of production ⇄consumption ⇄ discharge.
· Unlogged discharge(flush/backwash) skews numbers.
· Aging or uncalibrated meters cause apparent loss.
· Real leaks hide in overnight base flow.
· Manual meter reads find issues after costs pile up.
Download the workbook and in 20 minutes quantify your Balance Gap, split apparent vs real loss (overnight test), and pick the top two field checks. If you want live data, add cellular endpoints—operator-installed, no construction—to feed the sheet.
· 20-minute method with a 7-day data window.
· Auto-calculating Google Sheet/Excel formulas.
· Overnight minimum-flow test to flag real leaks.
· Mini-calc for monthly $ savings & payback.
· Optional cellular data feed—operator-installed,exportable CSV/PDF.
.avif)
.avif)
.avif)
