PO.IPR.GW.Backpressure.Fit
Description
Fits Rawlins and Schellhardt's backpressure equation q = C·(Pr² − Pwf²)ⁿ to a gas well's multi-rate test (flow-after-flow, isochronal or modified isochronal) by least squares on log q against log(Pr² − Pwf²). It returns one number of the fit: the exponent n, the coefficient C, the fit's R², or the rate at a drawdown, such as the absolute open flow at Pwf = 14.7 psia. The drawdown column can be Pr² − Pwf² (psi²), or a pseudo-pressure difference m(Pr) − m(Pwf) (psi²/cp) for the m(p) form, whose C then carries those units. n runs from 1 for laminar (Darcy) flow down to 0.5 for fully turbulent flow.
Formula
=LAMBDA(d, q, d_at, output, IF((MIN(d)<=0)+(MIN(q)<=0)+(COUNT(q)<2)+(COUNT(d)<>COUNT(q)), NA(), LET(
lx, LOG10(d), ly, LOG10(q), expn, SLOPE(ly, lx), coef, 10^INTERCEPT(ly, lx), IF(output="n", expn, IF(output="C", coef, IF(output="R2", RSQ(ly, lx), IF(output="q", IF(d_at<0, NA(), coef*d_at^expn), NA())))))))Parameters
| Parameter | Unit | Description |
|---|---|---|
d |
psi² | Each test's drawdown, Pr² − Pwf² (or m(Pr) − m(Pwf) in psi²/cp), a column; every value above 0 |
q |
Mscf/d | Each test's stabilized gas rate, a column of the same length; every value above 0 |
d_at |
psi² | The drawdown to read the rate at (for "q"): Pr² − 14.7² for the AOF; at least 0 |
output |
— | "n" the exponent, "C" the coefficient (Mscf/d/psi²ⁿ), "R2" the log-log fit's R², or "q" the rate at d_at (Mscf/d) |
Examples
| Invocation | Expected |
|---|---|
=PO.IPR.GW.Backpressure.Fit({1710000;3240000;5000000;6750000}, {3090;5400;8210;10350}, 8999783.91, "n") |
0.890158 |
=PO.IPR.GW.Backpressure.Fit({1710000;3240000;5000000;6750000}, {3090;5400;8210;10350}, 8999783.91, "C") |
0.00873762 |
=PO.IPR.GW.Backpressure.Fit({1710000;3240000;5000000;6750000}, {3090;5400;8210;10350}, 8999783.91, "R2") |
0.999076 |
=PO.IPR.GW.Backpressure.Fit({1710000;3240000;5000000;6750000}, {3090;5400;8210;10350}, 8999783.91, "q") |
13544.334 |
=PO.IPR.GW.Backpressure.Fit({1000000;2000000;4000000;8000000}, {630.957344;1098.560543;1912.705000;3330.212830}, 9000000, "n") |
0.8 |
=PO.IPR.GW.Backpressure.Fit({1000000;2000000;4000000;8000000}, {630.957344;1098.560543;1912.705000;3330.212830}, 9000000, "q") |
3659.266 |
=PO.IPR.GW.Backpressure.Fit({97770200;191765000;308629400;435220200}, {3090;5400;8210;10350}, 613556320, "n") |
0.819831 |
=PO.IPR.GW.Backpressure.Fit({97770200;191765000;308629400;435220200}, {3090;5400;8210;10350}, 613556320, "q") |
14016.69 |