PO.PP.Perm.PoroPermFit


Description

Fits the semi-log permeability transform to core plugs: log10(k) = A + B φ, by least squares. The sheet then turns a log porosity into a permeability with 10^(A + B φ), and R² says how much of the scatter the line explains. Returns three cells in a row: {A, B, R²}.

Formula

=LAMBDA(Phi_core, K_core, LET( lk, LOG10(K_core), HSTACK(INTERCEPT(lk, Phi_core), SLOPE(lk, Phi_core), RSQ(lk, Phi_core))))

Parameters

Parameter Unit Description
Phi_core fraction Core porosity column
K_core mD Core permeability column, same rows, every value above 0

Examples

Invocation Expected
=PO.PP.Perm.PoroPermFit({0.1;0.15;0.2;0.25}, {3.16227766;17.7827941;100;562.341325}) [-1, 15, 1]
=PO.PP.Perm.PoroPermFit({0.08;0.12;0.16;0.2;0.24}, {0.5;3;12;90;300}) [-1.676042248, 17.58355939, 0.995248383]

Need a custom LAMBDA? Suggest a New Lambda