PO.MBE.Aq.Sch.We
Description
Calculates cumulative water influx (Schilthuis) using trapezoidal integration, [bbl]. We = C × ∫(pi − p)dt.
Syntax
=PO.MBE.Aq.Sch.We(C, Pi, pressures, times)Parameters
| Parameter | Description |
|---|---|
| C | Aquifer constant, [bbl/day/psi]. |
| Pi | Initial pressure, [psi]. |
| pressures | Reservoir pressures at each time step, [psi]. |
| times | Times corresponding to pressures, [days]. |
SI Unit Version
Lambda Name
PO.MBE.Aq.Sch.We.SIFormula
=LAMBDA(C, Pi, pressures, times, LET(
C_field, C * PO.UnitConverter(1, "psi", "kPa") / PO.UnitConverter(1, "bbl/d", "m3/d"),
Pi_psi, PO.UnitConverter(Pi, "kPa", "psi"),
pressures_psi, MAP(pressures, LAMBDA(p, PO.UnitConverter(p, "kPa", "psi"))),
result_bbl, PO.MBE.Aq.Sch.We(C_field, Pi_psi, pressures_psi, times),
MAP(result_bbl, LAMBDA(v, PO.UnitConverter(v, "bbl", "m3")))))SI Parameters
| Parameter | Unit | Description |
|---|---|---|
C |
m3/d/kPa | Aquifer constant, [m3/d/kPa] |
Pi |
kPa | Initial pressure, [kPa] |
pressures |
kPa | Reservoir pressures at each time step, [kPa] (array) |
times |
days | Times corresponding to pressures, [days] (array) |
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.Aq.Sch.We.SI - In Refers to, paste the LAMBDA formula without the trailing invocation
(...) - Click OK
Now use =PO.MBE.Aq.Sch.We.SI(...) anywhere in your workbook.