PO.PP.Cutoff.PermFromCore


Description

The porosity cut-off that matches a permeability cut-off (often 1 mD for oil, 0.1 mD for gas), read off the core poro-perm line. It fits log10(k) = A + B φ to the core plugs and solves it at the permeability cut-off. Returns the porosity cut-off as a fraction, ready for `PO.PP.Pay.NetPay`.

Formula

=LAMBDA(Phi_core, K_core, K_cut, LET( lk, LOG10(K_core), b, SLOPE(lk, Phi_core), (LOG10(K_cut)-INTERCEPT(lk, Phi_core))/b))

Parameters

Parameter Unit Description
Phi_core fraction Core porosity column
K_core mD Core permeability column, same rows, every value above 0
K_cut mD Permeability cut-off

Examples

Invocation Expected
=PO.PP.Cutoff.PermFromCore({0.1;0.15;0.2;0.25}, {3.16227766;17.7827941;100;562.341325}, 1) 0.066666667
=PO.PP.Cutoff.PermFromCore({0.08;0.12;0.16;0.2;0.24}, {0.5;3;12;90;300}, 1) 0.095318713
=PO.PP.Cutoff.PermFromCore({0.08;0.12;0.16;0.2;0.24}, {0.5;3;12;90;300}, 0.1) 0.038447406

Need a custom LAMBDA? Suggest a New Lambda