Workbook

Power BI-ready Excel with your exact tabs and columns. Download the blank template or the Stone Creek sample, fill it, upload it back, and every map and measure updates.

Blank template

Seven required tabs plus well readings, gas quality, and a 2022–2028 calendar. Liquid-level and well-reading calculated columns are live Excel formulas.

Download template

Sample wellfield

Stone Creek MSW with 46 wells, 18 months of soundings, pumps, SEM, gas, and well readings — the same data loaded in this preview.

Download sample

DAX for Power BI

Measures, latest-value patterns, health score, collection deficit, and issue flags. Paste into DAX query view, Run, then Update model.

Download .dax

Load your file

Now using the demo site. Headers are matched case-insensitively.

Tab contract

Sheet names must match. Extra columns are ignored. Duplicate pump-installed flags were collapsed so Power BI can relate on well name.

liquid levels
well name, date, depth to fluid, depth to bottom, measured fluid, elevations, lengths, monitoring port, pump, available perf, submerged %, sediment, screen blocked %, screen above sounded, liquids above sounded, solid pipe without liquids
temp liquids
well name, date, technician, depth of fluid, step to bottom, top of casing, temperature depth / °F, elevations, reading number
pump data
well name, date, technician, states, cycle counts, days, cycles/day, air regulator, notes, last fluid / pump / force-main
pump installed
well name, has/had pump, type, force main, air, status, install / decommission, only-FM / only-air / both, well status, FM/air status
well information
well name, alias, type, vert. well type, dates, elevations, lengths, depth total, latitude, longitude, elevation
well readings
date, well name, Well alias, wellhead type/size, orifice plate, CH4, CO2, O2, temp, adjusted temp, balance, initial/adjusted static, differential, available, flow, power, system / barometric pressure, H2S, valve settings, percent open screen, MMBTU, device, full comment
SEM data
event, exceedance location/description, lat, long, root cause, initial exceedance date and time, initial value
calendar
Date, DateKey, Year, YearMonth, Quarter, ISO week, US holidays, Oct fiscal year, season, month/quarter/year flags — 2022-01-01 to 2028-12-31
gas quality
Optional slim chemistry tab. Prefer well readings for field tunes — this app maps that tab into methane, vacuum, and flow analysis automatically.

Power BI wiring

Get Data → Excel → the Wellfield workbook (every sheet except Power BI guide). Mark calendar[Date] as the date table. Relate every fact date to it, and every well name to well information. Then open DAX query view, paste Wellfield_PowerBI.dax, Run, and click Update model with changes. Health, collection deficit, gallons (0.45 gal/cycle), and the issue flags will land as measures. For maps use lat/long; the liquid isopach (IDW of well liquid elevations) stays in this app — Power BI has no native contour.