Havlena-Odeh Oil MBE Analysis
Spreadsheet
36 rows x 6 columns
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Havlena-Odeh Oil Material Balance | |||||
| 2 | Reservoir Properties | |||||
| 3 | Initial Pressure (Pi) | 4000 | psia | |||
| 4 | Initial Bo (Boi) | 1.35 | RB/STB | |||
| 5 | Initial Rs (Rsi) | 600 | scf/STB | |||
| 6 | Initial Bg (Bgi) | 0.0008 | RB/scf | |||
| 7 | Water FVF (Bw) | 1.02 | RB/STB | |||
| 8 | Connate Sw | 0.25 | fraction | |||
| 9 | Water Compressibility | 3E-06 | 1/psi | |||
| 10 | Formation Compressibility | 5E-06 | 1/psi | |||
| 11 | Gas Cap Ratio (m est.) | 0.4 | ||||
| 12 | ||||||
| 13 | Production History & PVT | |||||
| 14 | P (psia) | Bo (RB/STB) | Rs (scf/STB) | Bg (RB/scf) | Np (MSTB) | Gp (MMscf) |
| 15 | 3600 | 1.325 | 540 | 0.00092 | 2700 | 2430 |
| 16 | 3200 | 1.298 | 480 | 0.00105 | 5600 | 5600 |
| 17 | 2800 | 1.27 | 420 | 0.00122 | 8500 | 9350 |
| 18 | 2400 | 1.242 | 360 | 0.00145 | 11100 | 13875 |
| 19 | 2000 | 1.215 | 300 | 0.00175 | 13600 | 19040 |
| 20 | ||||||
| 21 | MBE Calculations | |||||
| 22 | F (RB) | Eo (RB/STB) | Eg (RB/STB) | F/Eo | Eg/Eo | N est (MMSTB) |
| 23 | 4471740 | 0.0302 | 0.2025 | 148070860.9 | 6.705298013 | 40.21348921 |
| 24 | 10326400 | 0.074 | 0.421875 | 139545945.9 | 5.701013514 | 42.5392379 |
| 25 | 17846600 | 0.1396 | 0.70875 | 127840974.2 | 5.077005731 | 42.18057197 |
| 26 | 28110750 | 0.24 | 1.096875 | 117128125 | 4.5703125 | 41.41546961 |
| 27 | 42704000 | 0.39 | 1.603125 | 109497435.9 | 4.110576923 | 41.40993939 |
| 28 | ||||||
| 29 | Havlena-Odeh Regression | |||||
| 30 | N (OOIP) | 48.26745014 | MMSTB | |||
| 31 | m (gas cap ratio) | 0.3173272495 | ||||
| 32 | Efw (last step) | 0.02726867406 | RB/STB | |||
| 33 | ||||||
| 34 | Drive Indices (last step) | |||||
| 35 | DDI | GDI | CDI | Sum | ||
| 36 | 0.4408089536 | 0.5749903478 | 0.03082121969 | 1.046620521 |
Description
Estimate OOIP and gas cap ratio for a saturated oil reservoir using the Havlena-Odeh straight-line method. Production history with PVT data at each pressure step are used to compute underground withdrawals (F) and expansion terms (Eo, Eg). Plotting F/Eo vs Eg/Eo yields a straight line whose intercept is N (OOIP) and slope is N·m.
Havlena-Odeh equation: F/Eo = N + N·m·(Eg/Eo)
Workflow
- Inputs: Initial reservoir conditions (Pi, Boi, Rsi, Bgi), rock/fluid compressibility (cw, cf, Swc), production history with PVT (P, Bo, Rs, Bg, Np, Gp)
- Step 1: Calculate underground withdrawal F = Np·[Bo + (Rp−Rs)·Bg] at each pressure step
- Step 2: Calculate expansion terms Eo and Eg at each step
- Step 3: Plot F/Eo vs Eg/Eo — should be linear (Campbell plot)
- Step 4: Regress for N and m using NandM function
- Output: OOIP (N), gas cap ratio (m), drive indices
How to use this blueprint
- In Excel, go to the Petroleum Office ribbon tab and click Blueprint Manager
- Search for Havlena-Odeh Oil MBE Analysis
- Click on the blueprint to preview the spreadsheet template
- Click Insert to place it into your worksheet. Modify the input values to match your data.