Material Balance Expansion Terms
Spreadsheet
50 rows x 3 columns
| A | B | C | |
|---|---|---|---|
| 1 | Material Balance Expansion Terms | ||
| 2 | Initial Conditions | ||
| 3 | Initial Pressure (Pi) | 4200 | psia |
| 4 | Boi | 1.35 | RB/STB |
| 5 | Rsi | 650 | scf/STB |
| 6 | Bgi | 0.00095 | RB/scf |
| 7 | m (gas cap ratio) | 0.3 | - |
| 8 | Swc (connate water) | 0.25 | fraction |
| 9 | cw (water compressibility) | 3E-06 | 1/psi |
| 10 | cf (rock compressibility) | 5E-06 | 1/psi |
| 11 | |||
| 12 | PVT at Various Pressures | ||
| 13 | Pressure (psia) | Bo (RB/STB) | Rs (scf/STB) |
| 14 | 4200 | 1.35 | 650 |
| 15 | 3800 | 1.34 | 590 |
| 16 | 3400 | 1.32 | 530 |
| 17 | 3000 | 1.295 | 470 |
| 18 | 2600 | 1.265 | 410 |
| 19 | 2200 | 1.23 | 350 |
| 20 | |||
| 21 | Gas FVF at Various Pressures | ||
| 22 | Pressure (psia) | Bg (RB/scf) | |
| 23 | 4200 | 0.00095 | |
| 24 | 3800 | 0.00105 | |
| 25 | 3400 | 0.00118 | |
| 26 | 3000 | 0.00135 | |
| 27 | 2600 | 0.00158 | |
| 28 | 2200 | 0.0019 | |
| 29 | |||
| 30 | Expansion Term Calculation | ||
| 31 | Pressure (psia) | Eo (RB/STB) | Eg (RB/STB) |
| 32 | 4200 | 0 | 0 |
| 33 | 3800 | 0.053 | 0.1421052632 |
| 34 | 3400 | 0.1116 | 0.3268421053 |
| 35 | 3000 | 0.188 | 0.5684210526 |
| 36 | 2600 | 0.2942 | 0.8952631579 |
| 37 | 2200 | 0.45 | 1.35 |
| 38 | |||
| 39 | Formation/Water Expansion | ||
| 40 | Pressure (psia) | dP (psi) | Efw (RB/STB) |
| 41 | 4200 | 0 | 0 |
| 42 | 3800 | 400 | 0.005382 |
| 43 | 3400 | 800 | 0.010764 |
| 44 | 3000 | 1200 | 0.016146 |
| 45 | |||
| 46 | Total Expansion & Two-Phase FVF | ||
| 47 | Pressure (psia) | Et (RB/STB) | Bt (RB/STB) |
| 48 | 3800 | 0.1010135789 | 1.403 |
| 49 | 3400 | 0.2204166316 | 1.4616 |
| 50 | 3000 | 0.3746723158 | 1.538 |
Description
Calculate material balance expansion terms for oil reservoir analysis. These terms quantify fluid and rock expansion as pressure drops during production.
Expansion Components:
- Eo: Oil + dissolved gas expansion
- Eg: Gas cap expansion
- Efw: Formation/water expansion
- Et: Total expansion = Eo + m*Eg + Efw
How to use this blueprint
- In Excel, go to the Petroleum Office ribbon tab and click Blueprint Manager
- Search for Material Balance Expansion Terms
- 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.