PO.PP.Pay.NetPay
Description
Sums an interpreted interval into the reservoir summary: gross thickness, net reservoir, net pay, net-to-gross and the pay-averaged porosity and water saturation. A sample is reservoir when its Vsh is at or below the shale cut-off and its porosity at or above the porosity cut-off, and pay when it is reservoir and its Sw is at or below the saturation cut-off. Returns six cells in a row: {gross, net reservoir, net pay, net-to-gross, average pay porosity, average pay Sw}. Thicknesses are in the unit of H.
Formula
=LAMBDA(H, Vsh, PhiEff_frac, Sw, Vsh_cut, Phi_cut, Sw_cut, LET(
res, (Vsh<=Vsh_cut)*(PhiEff_frac>=Phi_cut),
pay, res*(Sw<=Sw_cut),
gross, SUM(H),
net, SUM(H*res),
np, SUM(H*pay),
hp, SUM(H*PhiEff_frac*pay),
HSTACK(gross, net, np, net/gross, IF(np>0, hp/np, 0), IF(hp>0, SUM(H*PhiEff_frac*Sw*pay)/hp, 0))))Parameters
| Parameter | Unit | Description |
|---|---|---|
H |
ft or m | Thickness each sample represents (the depth step, or a bed thickness), one column |
Vsh |
fraction | Shale volume column, same rows as H |
PhiEff_frac |
fraction | Effective porosity column |
Sw |
fraction | Water saturation column |
Vsh_cut |
fraction | Largest Vsh that counts as reservoir |
Phi_cut |
fraction | Smallest porosity that counts as reservoir |
Sw_cut |
fraction | Largest Sw that counts as pay |
Examples
| Invocation | Expected |
|---|---|
=PO.PP.Pay.NetPay({0.5;0.5;0.5;0.5;1}, {0.1;0.2;0.5;0.15;0.3}, {0.2;0.18;0.1;0.22;0.12}, {0.3;0.6;0.9;0.4;0.5}, 0.4, 0.1, 0.5) |
[3, 2.5, 2, 0.833333333, 0.165, 0.406060606] |
=PO.PP.Pay.NetPay({0.5;0.5;0.5;0.5;1}, {0.1;0.2;0.5;0.15;0.3}, {0.2;0.18;0.1;0.22;0.12}, {0.3;0.6;0.9;0.4;0.5}, 0.4, 0.1, 0.2) |
[3, 2.5, 0, 0.833333333, 0, 0] |