PO.IPR.GW.PSS.Rate.NonDarcy
Description
Calculates gas well stabilized flow rate for pseudosteady state condition with Non-Darcy flow equation, [mscf/D].
Syntax
=PO.IPR.GW.PSS.Rate.NonDarcy(K, h, P_average, Pwf, Z, Ug, Re, Rw, S, T_degR, D)Parameters
| Parameter | Description |
|---|---|
| K | Permeability, [mD]. |
| h | Reservoir thickness, [ft]. |
| P_average | Average reservoir pressure, [psi]. |
| Pwf | Bottom-hole flowing pressure, [psi]. |
| Z | Gas compressibility factor (Z), [dimensionless]. |
| Ug | Gas viscosity, [cP]. |
| Re | Drainage radius, [ft]. |
| Rw | Wellbore radius, [ft]. |
| S | Skin factor, [dimensionless]. |
| T_degR | Reservoir temperature, [degR]. |
| D | Non-Darcy coefficient, [D/mscf]. |
SI Unit Version
Lambda Name
PO.IPR.GW.PSS.Rate.NonDarcy.SIFormula
=LAMBDA(K, h, P_average, Pwf, Z, Ug, Re, Rw, S, T, D, LET(
h_ft, PO.UnitConverter(h, "m", "ft"),
P_average_psi, PO.UnitConverter(P_average, "kPa", "psi"),
Pwf_psi, PO.UnitConverter(Pwf, "kPa", "psi"),
Re_ft, PO.UnitConverter(Re, "m", "ft"),
Rw_ft, PO.UnitConverter(Rw, "m", "ft"),
T_degR, PO.UnitConverter(T, "degK", "degR"),
D_1Mscfd, D / PO.UnitConverter(1, "sm3/d", "Mscf/d"),
result_Mscfd, PO.IPR.GW.PSS.Rate.NonDarcy(K, h_ft, P_average_psi, Pwf_psi, Z, Ug, Re_ft, Rw_ft, S, T_degR, D_1Mscfd),
PO.UnitConverter(result_Mscfd, "Mscf/d", "sm3/d")))SI Parameters
| Parameter | Unit | Description |
|---|---|---|
K |
- | Permeability, [mD] |
h |
m | Reservoir thickness, [m] |
P_average |
kPa | Average reservoir pressure, [kPa] |
Pwf |
kPa | Bottom-hole flowing pressure, [kPa] |
Z |
- | Gas compressibility factor (Z), [dimensionless] |
Ug |
- | Gas viscosity, [cP] |
Re |
m | Drainage radius, [m] |
Rw |
m | Wellbore radius, [m] |
S |
- | Skin factor, [dimensionless] |
T |
degK | Reservoir temperature, [degK] |
D |
1/(sm3/d) | Non-Darcy coefficient, [1/(sm3/d)] |
How to save as a reusable Excel function
LAMBDA is a built-in Excel feature (Microsoft 365) that lets you create custom functions without VBA. The formula above works as-is when pasted into a cell.
To save a LAMBDA as a reusable named function:
- Go to Formulas → Name Manager → New
- Enter a name, e.g.
PO.IPR.GW.PSS.Rate.NonDarcy.SI - In Refers to, paste the LAMBDA formula without the trailing invocation
(...) - Click OK
Now use =PO.IPR.GW.PSS.Rate.NonDarcy.SI(...) anywhere in your workbook.