PO.MBE.Gas.URF
Description
Calculates ultimate recovery factor based on abandonment pressure, [fraction 0-1].
Syntax
=PO.MBE.Gas.URF(Pi, zi, pa, za)Parameters
| Parameter | Description |
|---|---|
| Pi | Initial reservoir pressure, [psi]. |
| zi | Initial gas compressibility factor. |
| pa | Abandonment pressure, [psi]. |
| za | Gas compressibility factor at abandonment. |
SI Unit Version
Lambda Name
PO.MBE.Gas.URF.SIFormula
=LAMBDA(Pi, zi, pa, za, LET(
Pi_psi, PO.UnitConverter(Pi, "kPa", "psi"),
pa_psi, PO.UnitConverter(pa, "kPa", "psi"),
PO.MBE.Gas.URF(Pi_psi, zi, pa_psi, za)))SI Parameters
| Parameter | Unit | Description |
|---|---|---|
Pi |
kPa | Initial reservoir pressure, [kPa] |
zi |
- | Initial gas compressibility factor |
pa |
kPa | Abandonment pressure, [kPa] |
za |
- | Gas compressibility factor at abandonment |
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.MBE.Gas.URF.SI - In Refers to, paste the LAMBDA formula without the trailing invocation
(...) - Click OK
Now use =PO.MBE.Gas.URF.SI(...) anywhere in your workbook.