PO.IPR.HW.PSS.PI.ByBabuOdeh
Description
Calculates pseudosteady state productivity index for horizontal well using Babu-Odeh method for a box-shaped, anisotropic reservoir, with a well placed parallel to X(box length)-direction, [STB/(d.psi)].
Syntax
=PO.IPR.HW.PSS.PI.ByBabuOdeh(size_x, size_y, size_z, Kx, Ky, Kz, L, Rw, Bl, Ul, S, x1, y0, z0)Parameters
| Parameter | Description |
|---|---|
| size_x | Length size of the reservoir drainage box. X-direction, parallel to the well, [ft]. |
| size_y | Width size of the reservoir drainage box. Y-direction, perpendicular to the well, [ft]. |
| size_z | Reservoir thickness. Z-direction, [ft]. |
| Kx | Horizontal permeability in X-direction, [mD]. |
| Ky | Horizontal permeability in Y-direction, [mD]. |
| Kz | Vertical permeability, [mD]. |
| L | Length of the horizontal part of the well, [ft]. |
| Rw | Wellbore radius, [ft]. |
| Bl | Liquid formation volume factor, [bbl/STB]. |
| Ul | Liquid viscosity, [cP]. |
| S | Skin factor, [dimensionless]. |
| x1 | X location of the heel of the well. For the centrally placed well is equal to 0.5*(boxLength-wellLength), [ft]. |
| y0 | Y location of the heel of the well. For the centrally placed well is equal to 0.5*boxWidth, [ft]. |
| z0 | Z location of the heel of the well. For the centrally placed well is equal to 0.5*reservoirHeight, [ft]. |
SI Unit Version
Lambda Name
PO.IPR.HW.PSS.PI.ByBabuOdeh.SIFormula
=LAMBDA(size_x, size_y, size_z, Kx, Ky, Kz, L, Rw, Bl, Ul, S, x1, y0, z0, LET(
size_x_ft, PO.UnitConverter(size_x, "m", "ft"),
size_y_ft, PO.UnitConverter(size_y, "m", "ft"),
size_z_ft, PO.UnitConverter(size_z, "m", "ft"),
L_ft, PO.UnitConverter(L, "m", "ft"),
Rw_ft, PO.UnitConverter(Rw, "m", "ft"),
x1_ft, PO.UnitConverter(x1, "m", "ft"),
y0_ft, PO.UnitConverter(y0, "m", "ft"),
z0_ft, PO.UnitConverter(z0, "m", "ft"),
result_STBdpsi, PO.IPR.HW.PSS.PI.ByBabuOdeh(size_x_ft, size_y_ft, size_z_ft, Kx, Ky, Kz, L_ft, Rw_ft, Bl, Ul, S, x1_ft, y0_ft, z0_ft),
result_STBdpsi * PO.UnitConverter(1, "bbl/d", "m3/d") / PO.UnitConverter(1, "psi", "kPa")))SI Parameters
| Parameter | Unit | Description |
|---|---|---|
size_x |
m | Length size of the reservoir drainage box. X-direction, parallel to the well, [m] |
size_y |
m | Width size of the reservoir drainage box. Y-direction, perpendicular to the well, [m] |
size_z |
m | Reservoir thickness. Z-direction, [m] |
Kx |
- | Horizontal permeability in X-direction, [mD] |
Ky |
- | Horizontal permeability in Y-direction, [mD] |
Kz |
- | Vertical permeability, [mD] |
L |
m | Length of the horizontal part of the well, [m] |
Rw |
m | Wellbore radius, [m] |
Bl |
- | Liquid formation volume factor, [m3/sm3] |
Ul |
- | Liquid viscosity, [cP] |
S |
- | Skin factor, [dimensionless] |
x1 |
m | X location of the heel of the well. For the centrally placed well is equal to 0.5*(boxLength-wellLength), [m] |
y0 |
m | Y location of the heel of the well. For the centrally placed well is equal to 0.5*boxWidth, [m] |
z0 |
m | Z location of the heel of the well. For the centrally placed well is equal to 0.5*reservoirHeight, [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.PSS.PI.ByBabuOdeh.SI - In Refers to, paste the LAMBDA formula without the trailing invocation
(...) - Click OK
Now use =PO.IPR.HW.PSS.PI.ByBabuOdeh.SI(...) anywhere in your workbook.