PO.PTA.Pw.VW.LinConP
Description
Calculates wellbore pressure drop for vertical well in infinite homogeneous reservoir with linear constant pressure boundary, [psi].
Syntax
=PO.PTA.Pw.VW.LinConP(time, prod_data, B, Ul, C, Rw, S, Ct, porosity, h, K, L)Parameters
| Parameter | Description |
|---|---|
| time | Elapsed time, [h]. |
| prod_data | Flow rate at surface, [bbl/D] or array of time [h] / flow rate [bbl/D] of production data. |
| B | Formation volume factor, [bbl/STB]. |
| Ul | Viscosity, [cP]. |
| C | Wellbore storage coefficient, [bbl/psi]. |
| Rw | Wellbore radius, [ft]. |
| S | Skin factor, [dimensionless]. |
| Ct | Total compressibility, [1/psi]. |
| porosity | Porosity, [fraction]. |
| h | Net pay thickness, [ft]. |
| K | Permeability, [mD]. |
| L | Distance to boundary, [ft]. |
SI Unit Version
Lambda Name
PO.PTA.Pw.VW.LinConP.SIFormula
=LAMBDA(time, prod_data, B, Ul, C, Rw, S, Ct, porosity, h, K, L, LET(
prod_data_f, PO.UnitConverter(prod_data, "m3/d", "bbl/d"),
C_f, PO.UnitConverter(C, "m3/kPa", "bbl/psi"),
Rw_f, PO.UnitConverter(Rw, "m", "ft"),
Ct_f, PO.UnitConverter(Ct, "1/kPa", "1/psi"),
h_f, PO.UnitConverter(h, "m", "ft"),
L_f, PO.UnitConverter(L, "m", "ft"),
result, PO.PTA.Pw.VW.LinConP(time, prod_data_f, B, Ul, C_f, Rw_f, S, Ct_f, porosity, h_f, K, L_f),
PO.UnitConverter(result, "psi", "kPa")))SI Parameters
| Parameter | Unit | Description |
|---|---|---|
time |
- | Elapsed time, [h] |
prod_data |
m3/d | Flow rate at surface, [m3/d] (scalar). For array production data, convert rates to bbl/d externally |
B |
- | Formation volume factor, [m3/sm3] |
Ul |
- | Viscosity, [cP] |
C |
m3/kPa | Wellbore storage coefficient, [m3/kPa] |
Rw |
m | Wellbore radius, [m] |
S |
- | Skin factor, [dimensionless] |
Ct |
1/kPa | Total compressibility, [1/kPa] |
porosity |
- | Porosity, [fraction] |
h |
m | Net pay thickness, [m] |
K |
- | Permeability, [mD] |
L |
m | Distance to boundary, [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.PTA.Pw.VW.LinConP.SI - In Refers to, paste the LAMBDA formula without the trailing invocation
(...) - Click OK
Now use =PO.PTA.Pw.VW.LinConP.SI(...) anywhere in your workbook.