PO.IPR.VW.PSS.Rate.ByKlins
Description
Calculates Klins-Clark modified Vogel IPR flow rate for oil, [STB/d]. Klins & Clark (1993) correlation.
Syntax
=PO.IPR.VW.PSS.Rate.ByKlins(QoMax, Pres, Pb, Pwf)Parameters
| Parameter | Description |
|---|---|
| QoMax | Maximum oil flow rate (AOF), [STB/d]. |
| Pres | Average reservoir pressure, [psia]. |
| Pb | Bubble point pressure, [psia]. |
| Pwf | Bottom-hole flowing pressure, [psia]. |
SI Unit Version
Lambda Name
PO.IPR.VW.PSS.Rate.ByKlins.SIFormula
=LAMBDA(QoMax, Pres, Pb, Pwf, LET(
QoMax_STBd, PO.UnitConverter(QoMax, "m3/d", "STB/d"),
Pres_psi, PO.UnitConverter(Pres, "kPa", "psi"),
Pb_psi, PO.UnitConverter(Pb, "kPa", "psi"),
Pwf_psi, PO.UnitConverter(Pwf, "kPa", "psi"),
result_STBd, PO.IPR.VW.PSS.Rate.ByKlins(QoMax_STBd, Pres_psi, Pb_psi, Pwf_psi),
PO.UnitConverter(result_STBd, "STB/d", "m3/d")))SI Parameters
| Parameter | Unit | Description |
|---|---|---|
QoMax |
m3/d | Maximum oil flow rate (AOF), [m3/d] |
Pres |
kPa | Average reservoir pressure, [kPa] |
Pb |
kPa | Bubble point pressure, [kPa] |
Pwf |
kPa | Bottom-hole flowing pressure, [kPa] |
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.VW.PSS.Rate.ByKlins.SI - In Refers to, paste the LAMBDA formula without the trailing invocation
(...) - Click OK
Now use =PO.IPR.VW.PSS.Rate.ByKlins.SI(...) anywhere in your workbook.