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

Operating

19 h

NPT

5 h

Excluded

0 h

Unclassified

0 h

Cumulative cost

Actual accrual · linear budget reference

USD 320k

NPT cause Pareto

Lost circulation

5 h · USD 77k

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.