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]

Need a custom LAMBDA? Suggest a New Lambda