Every well in this file, ranked side by side. Click a column to sort, click a row to open that well. The colour zones follow the specific-capacity action thresholds; the risk score is likelihood × consequence.

The schematic redraws from the construction tables. Move the pointer down the borehole, or drag the slider, to read what exists at any depth.

Casing strings, screen intervals and lithology are repeating tables — add as many rows as the well has. Everything here drives the schematic and the validation engine.

The reference every trend runs against. Record the test conditions — specific capacity is rate- and duration-dependent, and without conditions it cannot be compared to anything.

Column, suction and strainer lengths drive the pump-setting geometry. Get those three right and submergence and headroom follow automatically.

Log pump, motor, VFD and column replacements or renovations here. The efficiency trend, energy analytics and Pump IQ re-baseline at the most recent dated entry — a new pump isn't judged against a worn one's numbers, and a worn pump can't hide behind a new one's.

One row per test on a fixed protocol — annual pump tests, quarterly SC checks, multi-speed VFD efficiency tests. Set the Hz column on VFD steps: only design-speed rows (≥59 Hz, or blank) feed the trends, so a 55 Hz reading never masquerades as capacity loss. Rehab events re-baseline the capacity fit; equipment events re-baseline the efficiency fit; both are marked on every chart.

Recovery ratio is computed: of the capacity the well had lost, how much came back. Track it by method and by contractor across a fleet and it becomes a procurement document.

Deterministic arithmetic on what you entered. Where an input is missing the calculation says so rather than filling in a number quietly.

One score, two directions. The well side reads specific capacity against its current baseline — reset by each rehabilitation — plus the step-test well-loss coefficient. The pump side reads wire-to-water efficiency against its baseline, reset at each equipment change. Unscored components drop out and the weights re-normalise; every weight and threshold is editable below.

Compared on equivalent uniform annual cost, never first cost. The verdict updates as you type; normalize to dollars per acre-foot of firm capacity before it goes anywhere near a board.

Where every source document physically lives — the video file, the completion report, the lab PDFs. A record that points at documents nobody can find is a record that decays.

Anything this template doesn't carry natively — agency-specific IDs, treatment system details, easement notes. Custom fields save with the well and print with the report.

Two automatic audits. The engineering checks test what you entered for internal consistency; the gap register lists what you haven't entered yet, and where to go get it.