PO.CO.Schematic.Depths


Description

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.

Formula

=LAMBDA(MD_ft, Survey_MD, Survey_Inc, Survey_Azi, Survey_TVD, LET( n, COUNT(Survey_MD), k, IF(MD_ft < INDEX(Survey_MD, 1), 0, MATCH(MD_ft, Survey_MD, 1)), lo, MAX(1, MIN(k, n - 1)), hi, lo + 1, md_lo, INDEX(Survey_MD, lo), md_hi, INDEX(Survey_MD, hi), inc_lo, RADIANS(INDEX(Survey_Inc, lo)), inc_hi, RADIANS(INDEX(Survey_Inc, hi)), azi_lo, RADIANS(INDEX(Survey_Azi, lo)), azi_hi, RADIANS(INDEX(Survey_Azi, hi)), tvd_lo, INDEX(Survey_TVD, lo), dogleg, 2 * ASIN(SQRT(MIN(1, SIN((inc_hi - inc_lo) / 2)^2 + SIN(inc_lo) * SIN(inc_hi) * SIN((azi_hi - azi_lo) / 2)^2))), frac, (MD_ft - md_lo) / (md_hi - md_lo), cos_at, IF(dogleg < 0.000000001, COS(inc_lo), (SIN((1 - frac) * dogleg) * COS(inc_lo) + SIN(frac * dogleg) * COS(inc_hi)) / SIN(dogleg)), part, frac * dogleg, ratio, IF(part < 0.000000001, 1, 2 / part * TAN(part / 2)), IF(k = 0, tvd_lo - (md_lo - MD_ft), IF(k >= n, INDEX(Survey_TVD, hi) + (MD_ft - md_hi) * COS(inc_hi), tvd_lo + (MD_ft - md_lo) / 2 * (COS(inc_lo) + cos_at) * ratio))))

Parameters

Parameter Unit Description
MD_ft ft Measured depth (one value or a column)
Survey_MD ft Station measured depths, increasing, the first at the surface
Survey_Inc deg Station inclinations
Survey_Azi deg Station azimuths
Survey_TVD ft Station TVDs, by minimum curvature from the first

Examples

Invocation Expected
=PO.CO.Schematic.Depths(1500, {0;1000;2000;3000}, {0;0;20;20}, {0;0;90;90}, {0;1000;1979.81553605;2919.50815684}) 1497.465385
=PO.CO.Schematic.Depths(2000, {0;1000;2000;3000}, {0;0;20;20}, {0;0;90;90}, {0;1000;1979.81553605;2919.50815684}) 1979.815536
=PO.CO.Schematic.Depths(2500, {0;1000;2000;3000}, {0;0;20;20}, {0;0;90;90}, {0;1000;1979.81553605;2919.50815684}) 2449.661846
=PO.CO.Schematic.Depths(500, {0;1000;2000;3000}, {0;0;20;20}, {0;0;90;90}, {0;1000;1979.81553605;2919.50815684}) 500
=PO.CO.Schematic.Depths(3500, {0;1000;2000;3000}, {0;0;20;20}, {0;0;90;90}, {0;1000;1979.81553605;2919.50815684}) 3389.354467
=PO.CO.Schematic.Depths(1500, {0;1000;2000}, {0;30;30}, {0;0;90}, {0;954.92965855;1860.73102702}) 1407.830343

Need a custom LAMBDA? Suggest a New Lambda