Loading…
Latest month vs. the month before it — the ▲/▼ under each number below.
Oil on the left axis (BOPD); gas and water share the right axis. Drag across the chart to zoom the whole dashboard to that range; click a legend item to hide/show a series.
Tip: hover any point to see active/inactive producer & injector counts for that month alongside oil/gas/water.
Monthly well count, same range as the chart above. Drag to zoom the whole dashboard; click a legend item to hide/show a line.
Always shown as a monthly average — spans full history regardless of the Field Review Period above.
Average BOPD by month, with recovery % (sold ÷ produced).
Produced vs. injected water, average BWPD by month.
Gas production, gas re-injection, gas lift and purchased CO2 — average MCFD/MMCFD by month.
Straight from Active_Producers&Injectors — a well counts as inactive that month when its production (producers: Oil, Gas & Water) or injection (injectors: Water inj & Gas/CO2 inj) is all zero. Status text (incl. Plugged & Abandoned) is ignored. Always shown from full history, independent of the Field Review Period above.
Every well whose active/inactive status flipped between the two most recent months, so a count drop (e.g. Active Producers 39 → 37) is traceable to the specific wells behind it.
Every month-over-month flip in the dataset. Sortable/searchable; always full history, independent of the Field Review Period above.
Wells with no active production in the most recent month, with the month they went inactive and how many months that's been.
Trailing 12-month monthly average (not an all-time total).
Average daily rate the field actually injected vs. the assigned target, by month, from the daily Injection export. Averaged (not summed) so a partial trailing month doesn't plot a misleading drop.
Well-days with a nonzero target but zero actual — more likely a stuck meter or a reporting gap than a genuine zero. Worth a field check before trusting the number.
How many injector wells are actually on Water vs CO2 vs both at once vs shut in, each month — the WAG (water-alternating-gas) cycle shows up as Water and CO2 trading places. Hover the chart for exact monthly counts; end-of-line value labels are left off since several categories often sit close together.
Every well currently classified as an injector: what it's on now, the latest reported rate vs target, and when it last switched.
Injectors that haven't changed fluid in 60+ days, longest first. A WAG well sitting still this long is either between cycles by design or worth a field check.
Every change in actual injected fluid for every injector, most recent first. Sortable/searchable; always full history.
Category is a keyword-based suggestion from Remarks — edit it directly in the table below. Click a slice, or use the filter buttons, to narrow the table to one category.
Separate regulatory list from the DOWNWELLS sheet — wells formally reported inactive to the Railroad Commission. Not all of these are also in the working down-wells list above, and not all down wells are on this list.
Wells that were on the down list but marked fixed in your workbook (shown here for reference only — not counted in the KPIs or charts above).
Dashed line is the overall trend.
Click a line to see its monthly average across all months.
Small scrollable table — click a lease/well to see its monthly cost history. Use the search box to filter, or scroll for more.
Choose a chemical to see its monthly quantity/cost, which wells used it, and treatment dates.
Total lease operating expense per month — now includes Workover costs.
All categories, incl. Workover. Click a row to drill into its subcategories.
Top 8 by monthly average shown.
Includes Workover categories (marked). Shows subcategories and line items, all as monthly averages where applicable.
Avg monthly LOE for wells the source data can tie to a specific well number (workover line items tagged "KATZ #—"), against that well's avg oil rate over the same range — a high $/BOPD flags a well costing more to run than it's producing.
How many months each well had workover activity, and total workover cost. Full event-level detail is on the Workover tab.
All wells — scroll for more.
Line items grouped by well and month. "Avg Oil Before/After" = average monthly oil rate over the 2 calendar months immediately before vs. after the workover month (workover month itself excluded). The (Xmo) next to each figure shows how many months were actually available — fewer than 2 near the edge of the data.
Workover-tagged LOE line items billed at the KATZ LEASE level rather than to one well (rentals, transportation, regulatory, etc.).
Equipment issues and required actions across satellites and separators, sorted by priority.
Type any well name to jump straight to its full history.