PO.RES.Waterflood.DykstraParsons


Description

The Dykstra-Parsons method for a waterflood in a layered reservoir with no crossflow between the layers. It returns the permeability variation V of the layer permeabilities, or, at the moment each layer breaks through, the vertical coverage and the water-oil ratio. Plotted against each other, coverage and WOR show how much of the section has been flooded by the time the producer reaches a given WOR. The layers are sorted by permeability inside the function, so they can be entered in any order. Each layer is a piston-like displacement with the same pressure drop across it, and the layers are of equal thickness, as in the original method.

Formula

=LAMBDA(k, Mob, Mode, LET( n, ROWS(k), Vdp, 1-EXP(-STDEV.S(LN(k))), ks, SORT(k, , -1), kr, TRANSPOSE(ks), ratio, kr/ks, below, IF(ratio<1, ratio, 1), x, IF(ratio>=1, 1, IF(Mob=1, below, (Mob-SQRT(Mob^2+below*(1-Mob^2)))/(Mob-1))), ones, SEQUENCE(n, 1, 1, 0), cov, MMULT(x, ones)/n, wat, MMULT((ratio>=1)*kr, ones), oil, MMULT((ratio<1)*kr/(Mob+x*(1-Mob)), ones), open, oil>0, IF(Mode=1, Vdp, IF(Mode=2, FILTER(cov, open), IF(Mode=3, FILTER(wat/IF(open, oil, 1), open), NA())))))

Parameters

Parameter Unit Description
k md Layer permeabilities, one column, one row per layer of equal thickness; at least two layers
Mob dimensionless End-point mobility ratio M = (krw/μw)/(kro/μo); used by Modes 2 and 3
Mode — 1 permeability variation V; 2 vertical coverage at each layer breakthrough; 3 reservoir WOR at each layer breakthrough

Examples

Invocation Expected
=PO.RES.Waterflood.DykstraParsons({50;100;10;20}, 1, 1) 0.6364076174
=PO.RES.Waterflood.DykstraParsons({50;100;10;20}, 1, 2) [0.45, 0.65, 0.875]
=PO.RES.Waterflood.DykstraParsons({50;100;10;20}, 1, 3) [1.25, 5, 17]
=PO.RES.Waterflood.DykstraParsons({50;100;10;20}, 2, 2) [0.4128534681, 0.6206927639, 0.8547152925]
=PO.RES.Waterflood.DykstraParsons({50;100;10;20}, 2, 3) [2.097841131, 8.632821479, 26.87936011]
=PO.RES.Waterflood.DykstraParsons({50;100;10;20}, 0.5, 2) [0.4965563298, 0.6870376904, 0.8952847075]
=PO.RES.Waterflood.DykstraParsons({50;100;10;20}, 0.5, 3) [0.8896046039, 3.506361948, 13.43968006]

Need a custom LAMBDA? Suggest a New Lambda