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 |