PO.DE.Dir.ToolfaceSteer


Description

Where a dogleg drilled at a given toolface takes the hole: the new inclination and azimuth after a dogleg set at a toolface angle measured from the high side of the hole, right (clockwise looking down the hole) positive. This is the closed form of the Ragland ("Ouija board") diagram a directional driller reads to orient a motor or whipstock. Output 0 returns the new inclination, 1 the new azimuth (0 to 360°) and 2 the azimuth change (−180 to 180°, right positive), all in degrees.

Formula

=LAMBDA(Inc_deg, Azi_deg, Dogleg_deg, TF_deg, Output, LET( incA, RADIANS(Inc_deg), dog, RADIANS(Dogleg_deg), tface, RADIANS(TF_deg), cosNew, COS(incA) * COS(dog) - SIN(incA) * SIN(dog) * COS(tface), incNew, DEGREES(ACOS(MAX(-1, MIN(1, cosNew)))), along, COS(dog) * SIN(incA) + SIN(dog) * COS(tface) * COS(incA), across, SIN(dog) * SIN(tface), dAzi, IF(ABS(along) + ABS(across) = 0, 0, DEGREES(ATAN2(along, across))), aziNew, MOD(Azi_deg + dAzi, 360), IF(Output = 1, aziNew, IF(Output = 2, dAzi, incNew))))

Parameters

Parameter Unit Description
Inc_deg deg Inclination before the dogleg
Azi_deg deg Azimuth before the dogleg
Dogleg_deg deg Total angle change over the course: the motor's DLS × course length / 100
TF_deg deg Toolface from high side: 0 builds, 180 drops, 90 turns right, 270 turns left
Output dimensionless 0 new inclination; 1 new azimuth; 2 azimuth change

Examples

Invocation Expected
=PO.DE.Dir.ToolfaceSteer(4, 40, 2, 45, 1) 55
=PO.DE.Dir.ToolfaceSteer(4, 40, 2, 45, 0) 5.5955747
=PO.DE.Dir.ToolfaceSteer(4, 40, 2, 45, 2) 14.660359
=PO.DE.Dir.ToolfaceSteer(30, 45, 3, 0, 0) 33
=PO.DE.Dir.ToolfaceSteer(30, 45, 3, 180, 0) 27
=PO.DE.Dir.ToolfaceSteer(30, 45, 3, 0, 1) 45
=PO.DE.Dir.ToolfaceSteer(20, 350, 4, 90, 1) 1.5550088
=PO.DE.Dir.ToolfaceSteer(0, 0, 3, 120, 1) 120

Need a custom LAMBDA? Suggest a New Lambda