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

Need a custom LAMBDA? Suggest a New Lambda