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.
TITLE
Material Balance Workbook — Havlena-Odeh, Gas P/z Analysis & Drive Energy Indices
PRICE
$99 USD — one-time purchase
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. Eo graphical OOIP determination for oil reservoirs, 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 — PVT inputs: Boi, Boi, Bgi, Np, Rs, Rsi • Production History — 7 reporting periods with Np, Gp, Wp, pressure • MBE Analysis — F, Eo, Eg, Efw calculated; F vs Np trend • 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 auto-estimated from stable period average • 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 • 228 formulas across 9 tabs • 7-period oil production dataset + 10-period gas P/z dataset • MDT color scheme; yellow cells for all adjustable parameters
SHOP COPY
9-tab material balance workbook: Havlena-Odeh OOIP, Campbell plot, gas P/z OGIP analysis, drive energy indices (Eo/Eg/Ef,w), and pressure vs Np depletion trend.
SUGGESTED TAGS
material balance, Havlena-Odeh, MBE, OOIP, gas P/z, drive mechanism, recovery factor, Campbell plot, reservoir engineering, Excel template, petroleum engineering
ABOUT RESERVOIR RISK SOLUTIONS
Built by petroleum engineers for petroleum engineers. All workbooks require only Microsoft Excel (2016+) — no plugins, no subscriptions. reservoirrisksolutions.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
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.
