PO.DE.Dir.CurveTangent
Description
The curve that takes a well from its present inclination to a tangent (hold) inclination at a constant build or drop rate, in the vertical plane: how much hole it needs, and the TVD and horizontal departure it gains. Output 0 returns the curve length (MD), 1 the TVD gained and 2 the horizontal departure gained, all in ft.
Formula
=LAMBDA(Inc1_deg, Inc2_deg, BUR_deg100ft, Output, LET(
radius, 18000 / (PI() * BUR_deg100ft),
dInc, Inc2_deg - Inc1_deg,
dir, SIGN(dInc),
curveMD, ABS(dInc) * 100 / BUR_deg100ft,
curveTVD, dir * radius * (SIN(RADIANS(Inc2_deg)) - SIN(RADIANS(Inc1_deg))),
curveHD, dir * radius * (COS(RADIANS(Inc1_deg)) - COS(RADIANS(Inc2_deg))),
IF(Output = 1, curveTVD, IF(Output = 2, curveHD, curveMD))))Parameters
| Parameter | Unit | Description |
|---|---|---|
Inc1_deg |
deg | Inclination where the curve starts |
Inc2_deg |
deg | Tangent inclination where it ends; below Inc1_deg for a drop |
BUR_deg100ft |
°/100 ft | Build (or drop) rate, positive |
Output |
dimensionless | 0 curve length; 1 TVD gained; 2 horizontal departure gained |
Examples
| Invocation | Expected |
|---|---|
=PO.DE.Dir.CurveTangent(0, 51.565, 2, 0) |
2578.27 |
=PO.DE.Dir.CurveTangent(0, 51.565, 2, 1) |
2244.04 |
=PO.DE.Dir.CurveTangent(0, 51.565, 2, 2) |
1083.98 |
=PO.DE.Dir.CurveTangent(60, 30, 3, 0) |
1000 |
=PO.DE.Dir.CurveTangent(60, 30, 3, 1) |
699.05703 |
=PO.DE.Dir.CurveTangent(60, 30, 3, 2) |
699.05703 |
=PO.DE.Dir.CurveTangent(30, 30, 2, 1) |
0 |