PO.DE.AFE.TimeDepth


Description

One hole section of a time-depth (days versus depth) curve and its cost: drilling time from the ROP, round trips to the section's base, and flat time, priced at the spread rate plus the section's fixed costs, and added to the totals of the sections above. Returns four cells: section days, cumulative days, section cost and cumulative cost.

Formula

=LAMBDA(Top_ft, Base_ft, ROP_fthr, Trips, TripRate_fthr, Flat_hr, DayRate_usd, Fixed_usd, PrevDays, PrevCost_usd, LET( secDays, ((Base_ft - Top_ft)/ROP_fthr + Trips*2*Base_ft/TripRate_fthr + Flat_hr)/24, secCost, secDays*DayRate_usd + Fixed_usd, HSTACK(secDays, PrevDays + secDays, secCost, PrevCost_usd + secCost)))

Parameters

Parameter Unit Description
Top_ft ft Section top (measured depth)
Base_ft ft Section base (measured depth)
ROP_fthr ft/hr Average on-bottom rate of penetration, including connections
Trips count Round trips in the section (bit runs and the casing-point trip)
TripRate_fthr ft/hr One-way tripping rate (1,000 ft/hr is about 11 stands an hour)
Flat_hr hr Flat time: casing, cementing, logging, BOP test, wait on cement
DayRate_usd USD/day Spread rate: rig plus time-dependent services
Fixed_usd USD Section fixed costs: casing, cement, bits, wellhead
PrevDays days Cumulative days at the section top; 0 for the first section
PrevCost_usd USD Cumulative cost at the section top; 0 for the first section

Examples

Invocation Expected
=PO.DE.AFE.TimeDepth(5000, 9000, 40, 2, 1000, 48, 45000, 350000, 12, 1500000) [7.666667, 19.666667, 695000, 2195000]
=PO.DE.AFE.TimeDepth(0, 2000, 100, 1, 1000, 36, 40000, 200000, 0, 0) [2.5, 2.5, 300000, 300000]

Need a custom LAMBDA? Suggest a New Lambda