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]

Need a custom LAMBDA? Suggest a New Lambda