Material Balance Workbook: Havlena-Odeh, Gas P/z Analysis & Drive Energy Indices
Determine OOIP and OGIP from production/pressure history using Havlena-Odeh, P/z straight-line, and drive energy index methods in one integrated workbook.
TAGLINE
Determine OOIP and OGIP from production/pressure history using Havlena-Odeh, P/z straight-line, and drive energy index methods in one integrated workbook.
WHO IT'S FOR
Reservoir engineers performing volumetric OOIP validation, drive mechanism analysis, or gas reservoir characterisation using production and pressure history data.
WHAT IT DOES
Implements three complementary material balance methods: the Havlena-Odeh F vs. Et (Eo + m·Eg + Efw) straight-line fit for oil reservoirs, giving OOIP live from the data, a P/z vs. Gp straight-line analysis for gas OGIP and recovery factor, and a drive energy index breakdown (Eo, Eg, Ef,w) showing the relative contribution of each energy source over time.
TABS INCLUDED (9)
• Instructions • Reservoir Properties — initial conditions and PVT: Pi, Boi, Bgi, Rsi, Bw, gas-cap ratio m • Production History — 8 reporting periods with Np, Rp, Wp, pressure, Bo, Rs, Bg • MBE Analysis — F, Eo, Eg, Efw and Et; least-squares OOIP fit with R² • Summary — OOIP estimate, RF, dominant mechanism • Campbell Plot — F/Eo vs Np diagnostic for aquifer influx detection • Pressure Analysis — reservoir pressure vs cumulative production • Gas P/z Analysis — P/z vs Gp table; OGIP from x-intercept; abandonment RF • Drive Energy Analysis — Eo/Eg/Ef,w indices; solution gas/gas cap/water drive % per period
KEY FEATURES
• Gas P/z: 10-period pressure history; OGIP from the least-squares P/z line's x-intercept • Drive energy: per-period breakdown showing dominant energy source shifting over time • Recovery factor from P/z: RF = 1 − (Pa/za)/(Pi/zi) • Campbell plot: detects strong aquifer by F/Eo rising above OOIP line
TECHNICAL SPECS
• Excel 2016+ compatible • 300+ formulas across 9 tabs • 8-period oil production dataset + 10-period gas P/z dataset • MDT color scheme; yellow cells for all adjustable parameters
ABOUT RESERVOIR RISK SOLUTIONS
Built by petroleum engineers for petroleum engineers. All workbooks require only Microsoft Excel (2016+) — no plugins, no subscriptions. www.reservoir-risk-solutions.com
What you get
- Instant workbook access after payment in your Excel Library
- Formula-driven worksheet designed for petroleum workflows
- No recurring fees and no plugin requirements
Licence
Single-user licence: the purchaser may use and modify this workbook for their own work, including work for their employer and clients. It may not be resold, shared publicly or redistributed as a template. Results are engineering estimates for screening and must be checked by a qualified professional before they are relied on.
FAQ
Is this a one-time purchase?
Yes. Each workbook is sold as a one-time purchase with no recurring subscription.
How do I access purchased files?
After checkout, your file appears in Excel Library under your account for download.
Do these templates require macros or plugins?
No. Templates are designed for Excel 2016+ and do not require VBA macros or external add-ins.
