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 |