Calculating Dogleg Severity in Excel: Equations, Step-by-Step Worked Examples, and Trajectory Pitfalls

When reviewing directional survey records prior to running tight-tolerance casing strings in complex North Sea wellbores, drilling engineers routinely rely on spreadsheet calculations to evaluate wellbore geometry. Receiving a raw survey listing containing measured depth, inclination, and azimuth data requires immediate, precise calculation of interval dogleg severity. Relying on unverified spreadsheet templates during high-angle directional runs risks underestimating localized wellbore curvature. Undetected doglegs lead directly to operational failures, including stuck pipe, severe casing wear, and compromised completion string runs.

Defining Wellbore Curvature and Survey Input Parameters

According to ISO 15551-1:2015(en), dogleg severity is defined as the total angular change of a wellbore trajectory normalized over a standard reference length, typically 30 metres or 100 feet. The measurement reflects the overall spatial curvature generated by simultaneous changes in inclination and azimuth between two discrete survey stations.

Figure 1. Spatial geometry of two survey stations showing inclination and azimuth vectors used to resolve the total subtended dogleg angle.

To demonstrate the mathematical framework, consider a standard directional survey interval. The upper survey station sits at measured depth $MD_1 = 2500.00\text{ m}$, with an inclination $Inc_1 = 45.00^\circ$ and an azimuth $Az_1 = 130.00^\circ$. The lower survey station sits at measured depth $MD_2 = 2530.00\text{ m}$, with an inclination $Inc_2 = 52.00^\circ$ and an azimuth $Az_2 = 139.00^\circ$.

The spatial geometry between two survey stations relies on vector spherical trigonometry. As documented in reference literature such as Dogleg Severity Calculation based on Radius of Curvature and the Dogleg Severity Guide, Calculation & Formula, the total subtended dogleg angle $\beta$ is computed using the spatial vector dot product:

$$\cos(\beta) = \cos(Inc_1) \cdot \cos(Inc_2) + \sin(Inc_1) \cdot \sin(Inc_2) \cdot \cos(Az_2 - Az_1)$$

where $Inc_1$ and $Inc_2$ represent the inclination angles at the upper and lower survey stations in degrees, $Az_1$ and $Az_2$ represent the azimuth angles at the upper and lower stations in degrees, and $\beta$ is the total subtended angular change in degrees or radians.

Step-by-Step Implementation of the Radius of Curvature Equation in Excel

Calculating dogleg severity in Microsoft Excel requires converting angular measurements from degrees to radians, evaluating the vector dot product, calculating the arccosine, and scaling the result to the desired reference interval.

Excel trigonometric functions require angle inputs in radians rather than degrees. We convert the survey angles using the factor $\pi / 180$:

$$Inc_1 = 45.00^\circ \times \left(\frac{\pi}{180}\right) = 0.7854\text{ rad}$$ $$Inc_2 = 52.00^\circ \times \left(\frac{\pi}{180}\right) = 0.9076\text{ rad}$$ $$\Delta Az = (139.00^\circ - 130.00^\circ) \times \left(\frac{\pi}{180}\right) = 9.00^\circ \times \left(\frac{\pi}{180}\right) = 0.1571\text{ rad}$$

Evaluating the cosine of the total subtended dogleg angle yields:

$$\cos(\beta) = \cos(0.7854) \cdot \cos(0.9076) + \sin(0.7854) \cdot \sin(0.9076) \cdot \cos(0.1571) = 0.9897$$

Taking the arccosine of $0.9897$ gives a total subtended angle $\beta$ of $0.1437\text{ radians}$, which converts to $8.233^\circ$.

Normalizing this $8.233^\circ$ angular change over the $30.00\text{ m}$ course length ($MD_2 - MD_1 = 2530.00\text{ m} - 2500.00\text{ m} = 30.00\text{ m}$) produces a calculated dogleg severity:

$$\text{DLS} = \beta \cdot \left(\frac{30}{MD_2 - MD_1}\right) = 8.233^\circ \cdot \left(\frac{30}{30.00}\right) = 8.23^\circ / 30\text{ m}$$

Assuming $MD_1$, $Inc_1$, and $Az_1$ are stored in cells A2, B2, and C2, and $MD_2$, $Inc_2$, and $Az_2$ are stored in cells A3, B3, and C3, the single-cell Excel formula is:

=DEGREES(ACOS(COS(RADIANS(B2))*COS(RADIANS(B3))+SIN(RADIANS(B2))*SIN(RADIANS(B3))*COS(RADIANS(C3-C2))))*(30/(A3-A2))

Automating trajectory evaluation using continuous dogleg severity computation eliminates manual cell referencing errors and updates wellbore curvature values instantaneously with every new survey station.

Common Spreadsheet Formula Pitfalls and Trajectory Errors

Implementing directional calculation formulas in spreadsheets introduces several potential points of failure, ranging from syntax oversights to software precision limits.

Omitting the RADIANS function causes Excel to interpret raw degree inputs directly as radians. If cell inputs of $45.00^\circ$ and $52.00^\circ$ are passed directly into COS() without conversion, Excel computes $\cos(45\text{ rad})$, producing corrupt outputs that can exceed $50^\circ / 30\text{ m}$ on low-angle wells.

Crossing true North ($0^\circ / 360^\circ$) can lead to logical errors when calculating azimuth differences directly. If a well turns from $355^\circ$ to $5^\circ$, a basic arithmetic subtraction ($5^\circ - 355^\circ$) yields $-350^\circ$ instead of the true $10^\circ$ turn angle. In the radius of curvature formula, because $\cos(x) = \cos(-x)$ and $\cos(360^\circ - x) = \cos(x)$, the expression $\cos(Az_2 - Az_1)$ naturally handles the crossover. However, custom user-defined logic that attempts to calculate absolute azimuth differences prior to trigonometric operations will generate severe trajectory errors if North crossover conditionals are omitted.

Floating-point rounding errors represent another significant failure mode. Near straight wellbore sections where inclination and azimuth remain essentially constant, the evaluated cosine term can calculate to a value slightly greater than $1.0$ (such as $1.0000000000000002$) due to internal binary representation limits, as noted in computational analysis by John D. Cook. Passing any value strictly greater than $1.0$ into Excel's ACOS function creates a #NUM! domain error that corrupts subsequent summary formulas.

Survey spacing introduces structural calculation risk. As detailed in directional logging analyses published by Coring Magazine, coarse 30 m survey intervals smooth out high-frequency micro-doglegs generated by steerable mud motors. Taking discrete surveys every 30 metres disguises localized, high-rate bends over shorter distances, underestimating the fatigue damage applied to drill pipe and production tubulars.

Sanity Checking Excel Results and Managing Operational Wellbore Risk

Validating spreadsheet calculations against simplified geometric benchmarks prevents formula errors from propagating into field execution.

A pure inclination build from $10.00^\circ$ to $14.00^\circ$ at a constant azimuth over $30.00\text{ m}$ serves as a reliable benchmark check. Because the azimuth difference is zero, $\cos(Az_2 - Az_1) = 1.0$, reducing the spatial formula to $\beta = Inc_2 - Inc_1$. The equation must return exactly $4.00^\circ / 30\text{ m}$ DLS. Any deviation indicates a structural formula error in cell referencing or radian conversion.

Understanding how inclination amplifies azimuth sensitivity is essential for evaluating high-angle wellbore risk. At an inclination of $80.00^\circ$, a $10.00^\circ$ azimuth turn over $30.00\text{ m}$ generates a dogleg severity of $9.70^\circ / 30\text{ m}$ ($9.85^\circ / 100\text{ ft}$). At an inclination of $10.00^\circ$, the identical $10.00^\circ$ azimuth turn produces a dogleg severity of only $1.70^\circ / 30\text{ m}$ ($1.73^\circ / 100\text{ ft}$). As inclination increases toward horizontal, the horizontal projection vector expands, meaning azimuth changes traverse a much larger spatial arc.

To guard against floating-point #NUM! errors in long survey listings, spreadsheet calculations should incorporate explicit clamping functions using Excel's MIN and MAX functions:

=DEGREES(ACOS(MIN(1, MAX(-1, COS(RADIANS(B2))*COS(RADIANS(B3))+SIN(RADIANS(B2))*SIN(RADIANS(B3))*COS(RADIANS(C3-C2))))))*(30/(A3-A2))

This protective structure ensures that rounding anomalies near vertical or straight wellbore sections do not disrupt spreadsheet calculations during live operations.