PO.DE.Dir.DoglegSeverity


Description

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.

Formula

=LAMBDA(Inc1_deg, Azi1_deg, Inc2_deg, Azi2_deg, dMD_ft, DEGREES(2 * ASIN(SQRT(MIN(1, SIN(RADIANS(Inc2_deg - Inc1_deg) / 2)^2 + SIN(RADIANS(Inc1_deg)) * SIN(RADIANS(Inc2_deg)) * SIN(RADIANS(Azi2_deg - Azi1_deg) / 2)^2)))) * 100 / dMD_ft)

Parameters

Parameter Unit Description
Inc1_deg deg Inclination at the upper station
Azi1_deg deg Azimuth at the upper station
Inc2_deg deg Inclination at the lower station
Azi2_deg deg Azimuth at the lower station
dMD_ft ft Measured depth between the stations

Examples

Invocation Expected
=PO.DE.Dir.DoglegSeverity(10, 45, 12, 50, 100) 2.2140954
=PO.DE.Dir.DoglegSeverity(20, 90, 20, 90, 100) 0

Need a custom LAMBDA? Suggest a New Lambda