PO.GM.Stress.Overburden
Description
Overburden (vertical) stress at a depth, by integrating a bulk-density log down from its first depth, the Sv every pore-pressure and fracture-gradient method starts from. Returns three cells: Sv in psi, the overburden gradient Sv/Z in psi/ft, and the same gradient as an equivalent mud weight in ppg.
Formula
=LAMBDA(Z_ft, TVD_ft, Rho_gcc, Sv0_psi, LET(
n, ROWS(TVD_ft),
i, SEQUENCE(n),
shift, --(i=TRANSPOSE(i)+1),
d_prev, MMULT(shift, TVD_ft),
r_prev, MMULT(shift, Rho_gcc),
d_end, IF(TVD_ft<Z_ft, TVD_ft, Z_ft),
width, IF(i>1, IF(d_end>d_prev, d_end-d_prev, 0), 0),
r_end, r_prev+(Rho_gcc-r_prev)*IF(TVD_ft>d_prev, (d_end-d_prev)/(TVD_ft-d_prev), 0),
d_last, INDEX(TVD_ft, n),
tail, IF(Z_ft>d_last, (Z_ft-d_last)*INDEX(Rho_gcc, n), 0),
sv, Sv0_psi+0.433528*(SUM(width*(r_prev+r_end)/2)+tail),
IF(Z_ft<INDEX(TVD_ft, 1), NA(), HSTACK(sv, sv/Z_ft, sv/Z_ft/0.052))))Parameters
| Parameter | Unit | Description |
|---|---|---|
Z_ft |
ft | True vertical depth at which to evaluate Sv, at or below the first log depth |
TVD_ft |
ft | Log depth column, true vertical, increasing, two or more rows |
Rho_gcc |
g/cc | Bulk density at each log depth (measured, or from `PO.GM.Density.Gardner` in the sheet) |
Sv0_psi |
psi | Overburden stress at the first log depth: the water column, air gap and unlogged section above it |
Examples
| Invocation | Expected |
|---|---|
=PO.GM.Stress.Overburden(3000, {1000;2000;3000;4000}, {2;2.2;2.3;2.4}, 850) |
[2735.8468, 0.911948933, 17.53747949] |
=PO.GM.Stress.Overburden(2500, {1000;2000;3000;4000}, {2;2.2;2.3;2.4}, 850) |
[2242.7087, 0.89708348, 17.25160539] |
=PO.GM.Stress.Overburden(4500, {1000;2000;3000;4000}, {2;2.2;2.3;2.4}, 850) |
[4274.8712, 0.949971378, 18.26868034] |
=PO.GM.Stress.Overburden(1000, {1000;2000;3000;4000}, {2;2.2;2.3;2.4}, 850) |
[850, 0.85, 16.34615385] |
=PO.GM.Stress.Overburden(2000, {500;1500;2500}, {1.9;2.1;2.25}, 0) |
[1330.38905, 0.665194525, 12.7922024] |