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] |