PO.DE.Dir.DoglegSeverity(Inc1_deg, Azi1_deg, Inc2_deg, Azi2_deg, dMD_ft)

Dogleg severity between two survey stations. The dogleg β = 2 asin √(sin²(ΔI/2) + sin I₁ sin I₂ sin²(ΔA/2)), the haversine form of the arccos expression, which stays exact when a course barely changes direction. DLS = β × 100 / ΔMD °/100 ft.

PO.DE.Dir.RatioFactor(Dogleg_deg)

Ratio factor of the minimum curvature method, which bends the balanced-tangential increments onto a circular arc. RF = (2/β) tan(β/2), with β the course dogleg in radians, and 1 for a straight course.

PO.DE.Dir.MinCurv.dTVD(Inc1_deg, Inc2_deg, dMD_ft, RF)

True vertical depth gained over a survey course by minimum curvature. ΔTVD = ΔMD/2 (cos I₁ + cos I₂) RF, with RF from PO.DE.Dir.RatioFactor.

PO.DE.Dir.MinCurv.dNorth(Inc1_deg, Azi1_deg, Inc2_deg, Azi2_deg, dMD_ft, RF)

Northing gained over a survey course by minimum curvature. ΔN = ΔMD/2 (sin I₁ cos A₁ + sin I₂ cos A₂) RF.

PO.DE.Dir.MinCurv.dEast(Inc1_deg, Azi1_deg, Inc2_deg, Azi2_deg, dMD_ft, RF)

Easting gained over a survey course by minimum curvature. ΔE = ΔMD/2 (sin I₁ sin A₁ + sin I₂ sin A₂) RF.

PO.DE.Dir.VerticalSection(North_ft, East_ft, VSAzi_deg)

Horizontal displacement projected onto the plane of the vertical section. VS = N cos(VSA) + E sin(VSA).

PO.CO.Schematic.Depths(MD_ft, Survey_MD, Survey_Inc, Survey_Azi, Survey_TVD)

The true vertical depth of a measured depth on a directional survey: the depth bookkeeping a completion schematic needs to state every shoe, packer, valve and perforation in both MD and TVD. The survey is the stations' measured depth, inclination, azimuth and TVD, the last worked down the stations by minimum curvature (`PO.DE.Dir.MinCurv.dTVD` with `PO.DE.Dir.RatioFactor`). Between two stations the well is the minimum-curvature arc that joins them, so a depth there is not read off a straight line. The direction a fraction f of the way along the arc is the stations' directions weighted by sin((1 − f)β) and sin(fβ), over sin β, where β is the course's dogleg. The TVD gained is the minimum-curvature increment from the station above to that point over the part of the course it covers, f × ΔMD, whose dogleg is fβ. A depth exactly on a station returns that station's TVD. Above the first station the well is taken as vertical, and below the last it runs straight on at the last station's inclination. Survey down to TD to avoid the second. MD_ft may be one depth or a column of depths, which returns a column of TVDs.

PO.DE.Dir.ClosureDistance(North_ft, East_ft)

Straight-line horizontal distance from the surface location to a station. Closure = √(N² + E²).

PO.DE.Dir.ClosureAzimuth(North_ft, East_ft)

Direction of a station from the surface location, in degrees from north, 0 to 360. Excel's ATAN2(x, y) takes x first, so ATAN2(N, E) is the angle from north toward east. A station on the surface location returns 0.

PO.DE.Dir.CurveTangent(Inc1_deg, Inc2_deg, BUR_deg100ft, Output)

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.

PO.DE.Dir.ToolfaceSteer(Inc_deg, Azi_deg, Dogleg_deg, TF_deg, Output)

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.

Need a custom LAMBDA? Request a Lambda