Petromium Tools / Formula set COST-NPT-001

Drilling Cost & NPT Tracker

Activity timeline · spread accrual · explicit NPT attribution · SPE bit-run audit· V2.0

Context

Depth units

Stored only in this browser · rate basis and every depth/duration unit are independently editable

Animated reconciliation

Rig-time, cumulative cost, and NPT Pareto

Rig-time ribbon

Direct user classification · gaps stay unclassified · 24 h in the window

ControlledCOST-NPT-001 v1.0.0

Figure data

Classified activity periods behind the rig-time ribbon
Activity	Class	Hours	Attributed cost (USD)
Rotary / slide drilling	operating	4	84,167
Trip for bit / BHA	operating	3	29,375
Rotary / slide drilling	operating	5	48,958
Treat lost circulation	npt	5	76,958
Circulate and condition	operating	3	29,375
Rotary / slide drilling	operating	4	39,167

Time not covered by a classified period is reported as unclassified rather than assumed operating.

Operating

19 h

NPT

5 h

Excluded

0 h

Unclassified

0 h

Cumulative cost

Actual accrual against a linear budget reference · USD 320k to date

In reviewCOST-NPT-001 v1.0.0

Figure data

Cumulative cost samples behind the figure
Elapsed (h)	Actual cost (USD)
0	0
4	84,167
7	113,542
12	162,500
13	200,292
17	239,458
18	261,250
20	280,833
24	320,000

NPT cause Pareto

Classified causes by hours

Schematic · not to scaleControlledCOST-NPT-001 v1.0.0

Lost circulation

5 h · USD 77k

Figure data

All classified NPT causes behind the Pareto figure
Cause	Hours	Cost (USD)
Lost circulation	5	76,958

The figure shows the five largest causes; every classified cause is listed here.

Review · not an approval

Reporting-window status

Actual report cost

USD 320,000

Attributed NPT cost

USD 76,958

NPT / counted

20.83%

Budget variance

USD 20,000

All classifications, cause labels, responsibility labels, rates, and costs are direct entries. This tool does not infer policy, root cause, liability, contractual responsibility, or approval.

Timeline, rates, and costs remain separate

Drilling cost and NPT worksheet

Worksheet nameWell / wellboreRigAFE / cost referenceReport start · ISO timestampReport end · ISO timestampCurrency label · no FXReport-window budget · USDOptionalPlanned counted hoursOptionalControlled source reference

Activity timeline

Overlaps are blocked. Gaps remain unclassified. Time class and plan status are deliberately independent.

01

Start · ISO timestampEnd · ISO timestampPhaseActivity codeTime classPlan statusStart MD

End MD

NPT cause · user policyOptionalResponsibility · user policyOptionalDDR / tour-sheet sourceNotesOptional

02

Start · ISO timestampEnd · ISO timestampPhaseActivity codeTime classPlan statusStart MD

End MD

NPT cause · user policyOptionalResponsibility · user policyOptionalDDR / tour-sheet sourceNotesOptional

03

Start · ISO timestampEnd · ISO timestampPhaseActivity codeTime classPlan statusStart MD

End MD

NPT cause · user policyOptionalResponsibility · user policyOptionalDDR / tour-sheet sourceNotesOptional

04

Start · ISO timestampEnd · ISO timestampPhaseActivity codeTime classPlan statusStart MD

End MD

NPT cause · user policyOptionalResponsibility · user policyOptionalDDR / tour-sheet sourceNotesOptional

05

Start · ISO timestampEnd · ISO timestampPhaseActivity codeTime classPlan statusStart MD

End MD

NPT cause · user policyOptionalResponsibility · user policyOptionalDDR / tour-sheet sourceNotesOptional

06

Start · ISO timestampEnd · ISO timestampPhaseActivity codeTime classPlan statusStart MD

End MD

NPT cause · user policyOptionalResponsibility · user policyOptionalDDR / tour-sheet sourceNotesOptional

Time-rate cost components

Multiple components may overlap. Switching day/hour basis preserves the same effective hourly rate.

01

CategoryStart · ISO timestampEnd · ISO timestampEntered rate · USDRate basisSupplier / contract referenceNotesOptional

02

CategoryStart · ISO timestampEnd · ISO timestampEntered rate · USDRate basisSupplier / contract referenceNotesOptional

03

CategoryStart · ISO timestampEnd · ISO timestampEntered rate · USDRate basisSupplier / contract referenceNotesOptional

Direct cost ledger

A direct cost becomes NPT-attributed only when linked to an explicitly NPT-classified activity.

01

Timestamp · ISOCategoryActual amount · USDBudget amount · USDOptionalLinked activityOptionalSupplier / ticket / invoice referenceNotesOptional

02

Timestamp · ISOCategoryActual amount · USDBudget amount · USDOptionalLinked activityOptionalSupplier / ticket / invoice referenceNotesOptional

03

Timestamp · ISOCategoryActual amount · USDBudget amount · USDOptionalLinked activityOptionalSupplier / ticket / invoice referenceNotesOptional

SPE PEH bit-run comparison

Independent Eq. 11.1 relationship; no bit or drilling-practice recommendation is made.

01

Drilled distance

Bit cost · USDRotating time

Trip time

Rig cost · USD/hSource reference

Calculated: USD 16,150 total · USD 14.04 per ft

Worksheet notesOptional

Calculation complete

Calculation audit

0 warnings

Report hours

24 h

Counted hours

24 h

Entered drilled

450 ft

All-in cost / ft

USD 711.11

Time-rate cost

USD 235,000

Direct cost

USD 85,000

Both NPT denominators are retained: 20.83% counted and 20.83% elapsed.

Calculation observations

USER_CLASSIFICATION_POLICY

NPT, plan status, cause, and responsibility are direct user classifications; the tool does not infer company policy, root cause, or liability.

REFERENCE_DATA_REPLACEMENT

The loaded values are a reference example only and must be replaced with controlled DDR, tour-sheet, cost, AFE, and contract records.

Operational warning: reconcile controlled DDR/tour sheets, company NPT policy, time zone, contracts, tickets, invoices, accrual cutoff, AFE/WBS, taxes, FX, and finance-approved values. Attribution is not liability or approval.

COST-NPT-001 v1.0.0 · explicit time classes · overlap accrual · SPE PEH Eq. 11.1Reference example loaded — replace it with controlled DDR, cost, contract, and NPT-policy records.