PO.IPR.HW.SS.PI.ByEconomides
Description
Calculates steady state productivity index for horizontal well using Economides-Brand-Frick model (anisotropic reservoir, rectangular drainage), [STB/(d.psi)]. Economides et al. (1994) correlation.
Syntax
=PO.IPR.HW.SS.PI.ByEconomides(L, Rw, Xe, Ye, h, Kx, Ky, Kz, Bl, Ul, Zw)Parameters
| Parameter | Description |
|---|---|
| L | Length of horizontal section, [ft]. |
| Rw | Wellbore radius, [ft]. |
| Xe | Drainage extent in x-direction (along well), [ft]. |
| Ye | Drainage extent in y-direction (perpendicular), [ft]. |
| h | Reservoir thickness, [ft]. |
| Kx | Permeability in x-direction, [mD]. |
| Ky | Permeability in y-direction, [mD]. |
| Kz | Permeability in z-direction (vertical), [mD]. |
| Bl | Liquid formation volume factor, [bbl/STB]. |
| Ul | Liquid viscosity, [cP]. |
| Zw | Well vertical position from reservoir bottom, [ft]. |
SI Unit Version
Lambda Name
PO.IPR.HW.SS.PI.ByEconomides.SIFormula
=LAMBDA(L, Rw, Xe, Ye, h, Kx, Ky, Kz, Bl, Ul, Zw, LET(
L_ft, PO.UnitConverter(L, "m", "ft"),
Rw_ft, PO.UnitConverter(Rw, "m", "ft"),
Xe_ft, PO.UnitConverter(Xe, "m", "ft"),
Ye_ft, PO.UnitConverter(Ye, "m", "ft"),
h_ft, PO.UnitConverter(h, "m", "ft"),
Zw_ft, PO.UnitConverter(Zw, "m", "ft"),
result_STBdpsi, PO.IPR.HW.SS.PI.ByEconomides(L_ft, Rw_ft, Xe_ft, Ye_ft, h_ft, Kx, Ky, Kz, Bl, Ul, Zw_ft),
result_STBdpsi * PO.UnitConverter(1, "bbl/d", "m3/d") / PO.UnitConverter(1, "psi", "kPa")))SI Parameters
| Parameter | Unit | Description |
|---|---|---|
L |
m | Length of horizontal section, [m] |
Rw |
m | Wellbore radius, [m] |
Xe |
m | Drainage extent in x-direction (along well), [m] |
Ye |
m | Drainage extent in y-direction (perpendicular), [m] |
h |
m | Reservoir thickness, [m] |
Kx |
- | Permeability in x-direction, [mD] |
Ky |
- | Permeability in y-direction, [mD] |
Kz |
- | Permeability in z-direction (vertical), [mD] |
Bl |
- | Liquid formation volume factor, [m3/sm3] |
Ul |
- | Liquid viscosity, [cP] |
Zw |
m | Well vertical position from reservoir bottom, [m] |
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.HW.SS.PI.ByEconomides.SI - In Refers to, paste the LAMBDA formula without the trailing invocation
(...) - Click OK
Now use =PO.IPR.HW.SS.PI.ByEconomides.SI(...) anywhere in your workbook.