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

Need a custom LAMBDA? Suggest a New Lambda