PO.RES.Waterflood.Stiles


Description

Stiles' method for a waterflood in a layered reservoir. The layers flood in order of permeability, the most permeable first, and the front in every layer advances in proportion to its permeability. At the moment each layer breaks through, the function returns either the fraction of the floodable volume swept so far or the surface water cut. Plotted against each other they give the water cut against recovery. Unlike Dykstra-Parsons, Stiles takes layers of any thickness and treats the mobility ratio as one; the oil and water mobilities enter only the water cut, through the ratio A.

Formula

=LAMBDA(k, h, A_wo, Mode, LET( f, (TRANSPOSE(k)>=k)*1, kh_cum, MMULT(f, k*h), h_cum, MMULT(f, h), kh_tot, SUM(k*h), h_tot, SUM(h), swept, (h_cum+(kh_tot-kh_cum)/k)/h_tot, fw, A_wo*kh_cum/(A_wo*kh_cum+kh_tot-kh_cum), IF(Mode=1, SORT(swept), IF(Mode=2, SORT(fw), NA()))))

Parameters

Parameter Unit Description
k md Layer permeabilities, one column, in any order
h ft Layer thicknesses, same rows as k
A_wo dimensionless (krw μo Bo)/(kro μw Bw): water to oil mobility ratio, times Bo/Bw for surface rates
Mode — 1 fraction of the floodable volume swept at each layer breakthrough; 2 surface water cut at each layer breakthrough

Examples

Invocation Expected
=PO.RES.Waterflood.Stiles({20;100;10;50}, {30;10;40;20}, 2, 1) [0.3, 0.5, 0.8, 1]
=PO.RES.Waterflood.Stiles({20;100;10;50}, {30;10;40;20}, 2, 2) [0.5, 0.8, 0.9285714286, 1]
=PO.RES.Waterflood.Stiles({20;100;10;50}, {30;10;40;20}, 1, 2) [0.3333333333, 0.6666666667, 0.8666666667, 1]

Need a custom LAMBDA? Suggest a New Lambda