PO.RTA.FlowingMB
Description
Returns the oil in place a producing well has contacted, in STB, by the flowing material balance of Agarwal-Gardner and Mattar-Anderson. From each point's cumulative oil Np and rate q it forms the material-balance time tc = Np/q, fits the inverse normalized pressure (pi − pwf)/q against it with a straight line, and returns 1/(slope·ct). It needs no shut-in: the flowing pressures the well already records stand in for the average reservoir pressures a tank material balance asks for. Pass only the points in boundary-dominated flow; transient points sit off the line.
Formula
=LAMBDA(n_p, q, p_i, p_wf, ct, IF((ct<=0)+(SLOPE((p_i-p_wf)/q, n_p/q)<=0), NA(), 1/(SLOPE((p_i-p_wf)/q, n_p/q)*ct)))Parameters
| Parameter | Unit | Description |
|---|---|---|
n_p |
STB | Cumulative oil at each point, a column |
q |
STB/d | Oil rate at each point, a column the same length; above 0 |
p_i |
psi | Initial reservoir pressure |
p_wf |
psi | Flowing bottomhole pressure at each point, a column, or one value when it is held constant |
ct |
1/psi | Total compressibility; above 0 |
Examples
| Invocation | Expected |
|---|---|
=PO.RTA.FlowingMB({15000;28500;40800;52200}, {500;450;410;380}, 5000, {3700;3530;3364;3196}, 0.00001) |
5000000 |
=PO.RTA.FlowingMB({17574.6125;31186.2625;42691.6375;52836.45625;62010.31875;70438.4625}, {577.4;447.2;378;333.3;301.4;276.9}, 5000, 1000, 0.000015) |
2027819.892 |
=PO.RTA.FlowingMB({24000;45000;64200;82200;99300}, {800;700;640;600;570}, 4000, {2000;1900;1820;1760;1700}, 0.00002) |
4756487.685 |