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] |