BSEE WAR activity codes · epic #1063 · Stones (WR 508)
Every reference figure the domain owner has given us for rig days, recomputed
on the new war_rig_days basis, with the disagreement quantified. The headline is
not the agreement — it is the coverage: how little of the 22-bore Stones
population any owner figure actually reaches.
1 · The verdict
The repository contains 19 reference figures bearing on rig days, 13 of them attributable to the owner. Sorted by what they can actually prove, they collapse to a single wellbore.
The independent evidence base is unchanged: one wellbore, 608124009500 (Stones SN105). It is the only bore the owner worked through by hand, from the raw WAR record, without running any code of ours. Every other owner figure is either the output of his own extractor — which encodes the calendar spud→TD definition the new basis is replacing — or a World Oil table that was itself built from this repository's model output, and so cannot independently confirm anything about it.
The 22-bore Stones list is owner-supplied and does widen the population we can compute over. It does not widen the population we can check. Twenty-one of the twenty-two bores below are computed-only and are labelled as such.
What did strengthen. On the one bore we can check, the new basis lands materially closer to the owner's hand count than the number we publish today: he counted 93 completion days from the daily remarks; the WAR basis gives 94 for the same post-re-entry rig period (2015-10-15 → 2016-01-16), against 152 on the currently published basis. That is a 1-day gap replacing a 59-day one.
2 · Every owner figure we could find
Grouped by evidence tier. Every row cites the committed file it came from; none of these numbers were reconstructed, inferred or rounded to improve agreement. Where we cannot compute the same quantity, the row says so rather than substituting a proxy.
| Subject | Figure | Source | Owner | Ours | Δ | Agreement | How we compute it |
|---|---|---|---|---|---|---|---|
| Owner, hand-worked from the raw WAR record — Can validate the new basis. | |||||||
| 608124009500 · Stones SN105 | Spud date | rig_days_by_milestone.md:16 | 2014-07-24 | 2014-07-24 | — | exact | WAR WELL_ACTV_START_DT · Identifies the record set, not the day rule. |
| 608124009500 · Stones SN105 | Total-depth date | rig_days_by_milestone.md:16 | 2014-12-26 | 2014-12-26 | — | exact | WAR TOTAL_DEPTH_DATE · Identifies the record set, not the day rule. |
| 608124009500 · Stones SN105 | Total measured depth | rig_days_by_milestone.md:16 | 31225 ft | 31225 | 0 | exact | max DRILLING_MD · Physical attribute — confirms we read the same records. |
| 608124009500 · Stones SN105 | True vertical depth | rig_days_by_milestone.md:16 | 28307 ft | 28306 | -1 | within rounding | max DRILLING_TVD · Physical attribute — confirms we read the same records. |
| 608124009500 · Stones SN105 | Max mud weight | rig_days_by_milestone.md:16 | 14.0 ppg | 14 | 0 | exact | max DRILL_FLUID_WGT · Physical attribute — confirms we read the same records. |
| 608124009500 · Stones SN105 | Bottom-hole pressure | rig_days_by_milestone.md:16 | 20607 psi | n/a | — | not checkable | no such column in WAR · No bottom-hole-pressure column exists on mv_war_main or mv_war_main_prop — not checkable from WAR. |
| 608124009500 · Stones SN105 | Drilling days (his milestone rule) | rig_days_by_milestone.md:16 | 155 d | 151 | -4 | within one WAR week | WAR DRL, merged · Calendar TD − spud, exclusive. Compared against WAR DRL. |
| 608124009500 · Stones SN105 | Completion days (his remark count) | rig_days_by_milestone.md:39 | 93 d | 94 | +1 | within one WAR week | TA stub + COM from the re-entry · "93 days of date column" — distinct daily remark dates after the rig returned on 2015-10-15. |
| 608124009500 · Stones SN105 | D&C days total | rig_days_by_milestone.md:41 | 248 d | 245 | -3 | within one WAR week | DRL + post-re-entry · His own addition, 155 + 93. |
| Owner-shipped script output (his rule, our data) — Measures the size of the change, not its correctness — it encodes the calendar definition the new basis replaces. | |||||||
| Stones field | Wellbores | financial_project_summary.xlsx | 22 | 22 | 0 | exact | bores with WAR coverage · Population, not a day count — the one owner figure that covers all 22 bores. |
| Stones field | Total drilling days | financial_project_summary.xlsx | 1457 d | 1105 | -352 | materially different | Σ WAR DRL over 22 bores · Owner's calendar spud→TD rule, summed over 22 bores. |
| Stones field | Total completion days | financial_project_summary.xlsx | 1145 d | 574 | -571 | materially different | Σ WAR COM over 22 bores · Owner's post-TD segment rule, summed over 22 bores. |
| Stones field | World Oil Table 1 D&C days | build_wo_per_well_dc.py:56 | 2625 d | 1679 | -946 | materially different | Σ WAR DRL+COM over 22 bores · Owner-tabulated, but the article's tables are this repository's own model output — circular, see §5. |
| Held in the repo, authorship not established — Reported for completeness. Not counted as owner evidence. | |||||||
| 608124009500 · Stones SN105 | Drilling days (milestone, inclusive) | rig_days_summary.md:21 | 156 d | 151 | -5 | within one WAR week | WAR DRL, merged · Not an independent anchor: 156 = 155 + 1, the same figure under the inclusive convention (proved in §4). |
| 608124009500 · Stones SN105 | Rig days by WAR — DRL | rig_days_summary.md:18 | 151 d | 151 | 0 | exact | WAR DRL, merged |
| 608124009500 · Stones SN105 | Rig days by WAR — PND | rig_days_summary.md:18 | 49 d | 49 | 0 | exact | WAR PND, merged |
| 608124009500 · Stones SN105 | Rig days by WAR — COM | rig_days_summary.md:18 | 87 d | 91 | +4 | within one WAR week | WAR COM, merged · See §3 — a 4-day TA/COM boundary reallocation. |
| 608124009500 · Stones SN105 | Rig days by WAR — TA | rig_days_summary.md:18 | 21 d | 17 | -4 | within one WAR week | WAR TA, merged · See §3 — a 4-day TA/COM boundary reallocation. |
| 608124009500 · Stones SN105 | Rig days by WAR — all codes | rig_days_summary.md:18 | 308 d | 308 | 0 | exact | all codes, merged · Sum of the four code figures. |
3 · The one disagreement in the by-code split
The by-code figures held in rig_days_summary.md are
DRL 151, PND 49, COM 87, TA 21. We reproduce
DRL 151, PND 49, COM 91, TA 17 —
two codes exact, the total exact at 308, and exactly four days moved from TA to COM.
It is a boundary-placement difference, not a counting difference.
| SN_WAR | Week start | Week end | Days | Code | Attribution |
|---|---|---|---|---|---|
-264094 | 2015-02-01 | 2015-02-07 | 7 | PND | |
-264847 | 2015-02-08 | 2015-02-14 | 7 | TA | |
-265082 | 2015-02-15 | 2015-02-21 | 7 | TA | |
-277427 | 2015-10-15 | 2015-10-17 | 3 | TA | 3-day partial return — the rig comes back on location |
-277474 | 2015-10-18 | 2015-10-24 | 7 | COM | our TA→COM boundary |
-277786 | 2015-10-25 | 2015-10-31 | 7 | COM | |
-278055 | 2015-11-01 | 2015-11-07 | 7 | COM | |
-278336 | 2015-11-08 | 2015-11-14 | 7 | COM | |
-278618 | 2015-11-15 | 2015-11-21 | 7 | COM | |
-278896 | 2015-11-22 | 2015-11-28 | 7 | COM | |
-279118 | 2015-11-29 | 2015-12-05 | 7 | COM | |
-279412 | 2015-12-06 | 2015-12-12 | 7 | COM | |
-279773 | 2015-12-13 | 2015-12-19 | 7 | COM | |
-280045 | 2015-12-20 | 2015-12-26 | 7 | COM | |
-280285 | 2015-12-27 | 2016-01-02 | 7 | COM | |
-280494 | 2016-01-03 | 2016-01-09 | 7 | COM | |
-280852 | 2016-01-10 | 2016-01-16 | 7 | COM |
The well is temporarily abandoned in February 2015 and the rig does not return until
2015-10-15. That return is reported as a 3-day partial
WAR week (2015-10-15–2015-10-17) — the only place
in the well's entire record where an activity-code change does not fall on a Sunday week
boundary. We take
the code change at the WAR record boundary, so COM begins 2015-10-18.
The 87/21 split is reproduced exactly, and only, if that boundary is placed four days later at
2015-10-22: TA then runs a nominal full week
(14 + 7 = 21) and COM runs 2015-10-22–2016-01-16 = 87 days.
Provenance caveat on this anchor. The {"COM": 87, ...}
block sits under a “Summary and Way Forward” heading that follows the
owner's signature and ends by asking him which completion method to adopt — so
on the committed record it reads as our summary put to him, not his own
output. We therefore file it as repo-legacy, not owner evidence. It also cannot be reproduced
from the WAR rows this repository holds under any convention we tested (inclusive, exclusive,
merged or unmerged), because the committed extract
war_data_608124009500.csv is byte-consistent with the current WAR tables and
puts the code change at 2015-10-18. Confirming authorship is
ask 1.
4 · Two definitions, one well
The owner's drilling rule is calendar: “I have been taking the spud date – the td date as drilling days.” Spud 07/24/2014, TD 12/26/2014.
| Statement | Source | Days | Arithmetic |
|---|---|---|---|
| Drilling days | rig_days_by_milestone.md:16 |
155 | TD − spud, exclusive = 155 |
| Drilling days | rig_days_summary.md:21 |
156 | TD − spud + 1, the stated formula = 156 |
| Published extract | drilling_and_completion_days_v21_kc.csv |
155 | the exclusive convention, as shipped |
| WAR DRL, this basis | merged DRL weeks 2014-07-23 → 2014-12-20 | 151 | inclusive over the merged span |
The 155/156 pair is one figure, not two. 156 = 155 + 1 exactly; the two documents state the same milestone under the exclusive and inclusive conventions. That halves the apparent anchor count and is why the ledger files 156 as repo-legacy.
The 4-day gap to WAR DRL is the reporting quantum, not an error.
The last DRL week ends 2014-12-20; TD is reached 12/26/2014, which falls inside the
following week — and that week is returned as PND, not DRL. The
calendar rule charges the whole TD week to drilling; the WAR rule charges it to whatever code the
operator filed. On a continuously drilled well the two differ by at most one WAR week. On a
suspended or batch-drilled well they diverge without bound: the calendar rule keeps
counting through months of rig-off-well time, the WAR rule does not. That is the entire reason
#1063 exists, and it is exactly why agreement on this one continuously-drilled well cannot be
read as agreement on the population.
5 · Coverage
All 22 bores on the owner's Stones list carry WAR activity and are computable on the new basis. Exactly one of them carries an owner figure to check against. The rest are shown so the change is visible — they are not validated.
| API12 | Well | WAR DRL | WAR COM | WAR D&C | PND | TA | Published DRL | Published COM | Δ D&C | Owner figure? |
|---|---|---|---|---|---|---|---|---|---|---|
608124001500 | 001 | 72 | 0 | 72 | 0 | 47 | 69 | 52 | -49 | none |
608124002200 | 002 | 7 | 0 | 7 | 0 | 0 | 0 | 13 | -6 | none |
608124007700 | 001 | 119 | 0 | 119 | 24 | 26 | 123 | 49 | -53 | none |
608124008700 | 004 | 70 | 0 | 70 | 9 | 0 | 71 | 24 | -25 | none |
608124009200 | 005 | 38 | 0 | 38 | 7 | 0 | 39 | 4 | -5 | none |
608124009201 | 005 | 77 | 0 | 77 | 0 | 0 | 81 | 12 | -16 | none |
608124009500 | SN105 | 151 | 91 | 242 | 49 | 17 | 155 | 152 | -65 | hand-worked |
608124009900 | SN109 | 70 | 51 | 121 | 56 | 6 | 79 | 101 | -59 | none |
608124010300 | 009 | 6 | 0 | 6 | 0 | 0 | 1 | 10 | -5 | none |
608124010400 | SN208 | 71 | 77 | 148 | 14 | 49 | 88 | 117 | -57 | none |
608124010500 | 008 | 3 | 0 | 3 | 0 | 5 | 1 | 15 | -13 | none |
608124011000 | 011 | 75 | 0 | 75 | 21 | 0 | 77 | 24 | -26 | none |
608124011001 | SN110 | 7 | 76 | 83 | 21 | 26 | 23 | 112 | -52 | none |
608124011200 | SN206 | 63 | 61 | 124 | 7 | 0 | 78 | 67 | -21 | none |
608124011700 | SN207 | 56 | 32 | 88 | 14 | 0 | 62 | 40 | -14 | none |
608124012300 | SN213 | 38 | 34 | 72 | 42 | 0 | 39 | 108 | -75 | none |
608124012900 | SN115 | 42 | 41 | 83 | 16 | 0 | 184 | 56 | -157 | none |
608124013400 | SN216 | 35 | 40 | 75 | 8 | 0 | 80 | 48 | -53 | none |
608124013700 | SN114 | 49 | 0 | 49 | 7 | 0 | 156 | 17 | -124 | none |
608124013701 | SN114 | 7 | 45 | 52 | 35 | 0 | 4 | 80 | -32 | none |
608124014300 | SN219 | 49 | 0 | 49 | 8 | 7 | 45 | 17 | -13 | none |
608124014301 | SN219 | 0 | 26 | 26 | 28 | 0 | 2 | 50 | -26 | none |
| Stones — 22 bores | 1,105 | 574 | 1,679 | 366 | 183 | 1,457 | 1,168 | -946 | 1 of 22 | |
Against the owner's own V30 field totals
(1,457 drilling,
1,145 completion) the WAR basis returns
1,105 and
574. Both gaps are large, both are expected
by construction, and neither is evidence either way: his totals are his
calendar rule summed over the same bores, so the difference measures the definition change,
not its correctness. Note also that the published extract totals
1,168 completion days against the
1,145 in his shipped workbook — a
+23-day
divergence that predates this basis change and is tracked as
#846.
The World Oil Table 1 anchor is circular. Stones prints 2,625 D&C days there, and the owner tabulated that table — but the validation page records that “the article's four tables are this repository's FDAS V30 model output”. Comparing our numbers to it compares our numbers to themselves. It is a useful measure of how far published figures will move (-946 days for Stones); it is not a check.
6 · Grain
Three of the eighteen Stones wells carry a sidetrack. Rolling those up by summing per-bore days double-counts the single WAR week that reports both bores across the sidetrack transition; the module unions instead.
| API10 | Bores | All WAR days (union) | All WAR days (summed) | Double-counted | D&C (union) | D&C (summed) |
|---|---|---|---|---|---|---|
6081240110 | 2 bore(s): 00,01 | 233 | 240 | 7 | 158 | 158 |
6081240137 | 2 bore(s): 00,01 | 175 | 182 | 7 | 101 | 101 |
6081240143 | 2 bore(s): 00,01 | 117 | 124 | 7 | 75 | 75 |
Seven days per sidetrack boundary, every time. On these three wells the
double-counted week happens to be filed under a non-D&C code, so the D&C columns are
unaffected and the two roll-ups agree — which is precisely why the defect is easy to
miss. Where the straddling week is filed DRL or COM, summing
over-reports D&C by a full week per sidetrack. Both grains are published so a consumer
can never pick the wrong one by accident.
7 · Caveats that apply to every number above
A WAR is a weekly return (Form BSEE-0133 under 30 CFR 250.743; Sunday 00:00 to Saturday 23:59) carrying one activity code for the whole week. A phase boundary can therefore only ever be located to within one week. Every figure on this page — ours and the owner's — inherits a ±7-day uncertainty at each code transition, which is why the ledger treats |Δ| ≤ 7 as within-quantum rather than as agreement.
The WAR tables in this checkout run 1988-04 to 2026-02, but density is not uniform: only 867 returns exist before 1998, and the first month carrying more than fifty is 1997-10. A bore that spudded before then will under-report, silently. Stones is unaffected — its earliest spud is 2004-12-31 — but the same basis applied to older Gulf inventory is not safe without a per-bore coverage check. (Note: we found no April-2004 step in this feed; see the corrections note.)
PND is undefinedBSEE publishes no code list for WELL_ACTIVITY_CD; the table we hold is the
BOREHOLE_STAT_CD list, and its own note reads “PND means we guessed it as
unknown.” PND runs to 366 days across
these 22 bores — more than the
574 completion days the DRL_COM basis
reports, and excluded from the D&C total on that basis. Fold it into completion
instead and Stones D&C moves from 1,679 to
2,045 days. It is therefore never merged
silently into either bucket; it is carried in its own column and a basis includes it
explicitly or not at all. Until BSEE confirms its meaning
(#1065), any basis that includes or excludes PND is a choice, not
a fact.
8 · The most useful output of this exercise
Ranked by how much each would move the evidence base. The first three are cheap for him and would take the independent anchor count from one bore to a population.
The same exercise he did for 608124009500 — count the distinct daily remark dates after TD — on a handful of deliberately varied bores: one continuously drilled, one suspended mid-drilling, one batch-drilled, one sidetracked, one with a late recompletion. Five bores chosen that way settles more than fifty chosen at random.
Did he produce {"COM": 87, "DRL": 151, "PND": 49, "TA": 21}, or did we?
If his, we have a second independent anchor and a 4-day boundary rule to reconcile. If ours,
the ledger's repo-legacy tier is empty and the evidence base is thinner still. One sentence
from him decides which.
rig_days_summary.md ends by asking us to pick among his three completion
methods and marks method 3 preferred. That question is still open, and it is upstream of
every completion number on this page. Answering it — or having him confirm the WAR
code basis supersedes all three — is #1064.
Anything outside BSEE — a rig day-rate invoice, an operator DDR, a spud-to-rig-release date pair — for even one Lower Tertiary well. Every anchor we hold is derived from the same WAR feed, so none of them can detect a systematic bias in that feed. One external source breaks the circularity.
He supplied parsed remarks for this bore but never a day count from them. The raw material
for a second hand-worked anchor is already committed
(api_608124003301_remarks_parsed.xlsx, 32 weeks) — it needs only his
count.
PND meansNot his to answer, but he has the BSEE relationships. PND is the single largest unattributed block in the Stones record.
Corrections to the brief this page was built from. (a) The
{"COM": 87, ...} split and rig_days_by_WAR.md are not
demonstrably owner-authored — both sit in our voice, and the latter closes
“This is how we can calculate…”. (b) There is no April-2004
eWell step in this feed; monthly returns rise smoothly through 2003–2005, and the real
floor is 1997-10. (c) rig_days_by_milestone.md carries two owner figures the brief
did not list — completion = 93 days and D&C = 248 — and they are the most
valuable anchors in the repository.