Monthly averages from the daily production sheet (per day, over the days that have data). Active producers = wells the allocation gave any oil, water or gas that month; active injectors = wells that metered any water or CO2. Hover a month on the chart for the active counts.
Oil / water / gas — monthly average
Oil BOPD left axis; water BWPD and gas MCFD right axes. Click a legend entry to hide it.
Active wells
Producers and injectors active each month, from the allocation. Click a month to compare it with the month before.
Which wells dropped?
Pick any two months: wells active in the first but not the second (dropped), and wells active in the second but not the first (new / back).
Inactive now — since when
Wells with history that made / injected nothing in the latest month: last active month and how long they have been quiet. Those on the down list are marked.
Monthly summary
Every month on file.
Oil produced (field oil BOPD) against oil sold — the Skimmed Oil LACT meter (custody transfer). Sold can be above or below produced because of tank stock. NGL is shown separately where the field reports it.
Produced vs sold — BOPD
Both on one axis.
Sold − produced, BBL in the month
Positive = sold more than produced (tank drawn down).
Monthly detail
Where the water and the gas go, from the daily production sheet: produced vs injected / disposed, and the gas streams (total, HC gas, CO2 recycled and purchased, lift gas, gas to the pilot plant, NGL).
Water — BWPD
Produced, injected, SWD.
Gas — MCFD
Every gas stream the sheet reports.
Monthly balance
By suspected cause
Down wells now. Click a bar to filter.
By category
Downhole / surface / electrical, from the cause wording (editable per row).
Down oil
What the down wells were making when they went down.
Down wells
Pulled / back online
Kept for the record. Reopen moves a well back to the down list.
Facility and equipment issues that are not about one well — compressors, transformers, booster pumps, the skim system. Open items from the inputs workbook; add or resolve here and the next run writes it back.
Equipment status
Change a state here; it is saved to the Equipment tab on the next run.
Open issues
Resolved
LOE detail lines from the inputs workbook. Accounts starting W/O are workover; a sub-account like GLSAU #235A ties the line to a well, so well spend can be set against what the well makes (allocated BOPD).
Monthly LOE
Reported field total where given (LOE Monthly tab), else the sum of the lines; workover part shown separately.
By category — average per month
Click a bar to filter the lines.
Workover & well spend vs production
Per well over the selected months: spend, average BOPD (allocation), and $ per barrel. Click a well for its lines and history.
Lines
From the Payroll tab (one row per employee per cheque). Monthly totals by check date.
Gross pay and overtime — monthly
Gross pay left axis; OT hours right axis.
By employee — selected months
Cheques
From the Chemical tab (vendor invoice lines). Lease GLSAU 235R ties a line to well 235R, so cost can be set against the well's oil.
Monthly chemical cost
Sales w/ tax, by month.
By product line — average per month
Click a bar to filter.
By well — cost vs oil
Average monthly chemical cost per well against its allocated BOPD; $ per barrel.
Lines
Allocated oil rolled up by pump type (from the master's API sheet) and by satellite (the well test 'Sep' column, latest per well). Click a group to see its wells — this month, last month, three months ago.
Monthly by group
Click a legend entry to hide a group; click a bar to pick it.
Groups — now vs before
Wells
Click a well for its full history.
The switch list: every injector's water / CO2 target as recorded in the Injection sheet, every change counted as a switch, with what the field actually injected while that target was in force. Click an injector to see its switches against its pattern's production.
Target vs actual — field total
Sum of every injector's target and what was metered, per day, averaged over the month.
Injector mix
How many injectors were on CO2, on water, or had no target at the end of each month.
Possible meter / comms gaps — last 30 days
Well-days with a target but nothing metered: a meter or comms problem, or a switch the sheet does not know about yet.
Injectors
Per pattern: CO2 injected (MCF/d) ÷ oil credited to the pattern (BOPD) = MCF per barrel; the lower the better. Also IWR and water per barrel. From the allocation's pattern maths.
Patterns this month
Click a pattern for its history.
Pattern history
Everything about one well: production history (allocation), injection, pump and satellite, patterns, down-well events, LOE and chemical lines.