Effective Compressibility Calculations
Spreadsheet
41 rows x 3 columns
| A | B | C | |
|---|---|---|---|
| 1 | Effective Compressibility Calculations | ||
| 2 | Fluid Properties | ||
| 3 | Oil Compressibility (Co) | 1.2E-05 | 1/psi |
| 4 | Water Compressibility (Cw) | 3E-06 | 1/psi |
| 5 | Gas Compressibility (Cg) | 0.00025 | 1/psi |
| 6 | Rock Compressibility (Cf) | 4.5E-06 | 1/psi |
| 7 | _1E6 | 1000000 | (E-6 conversion) |
| 8 | Saturation Data | ||
| 9 | Sw (water saturation) | 0.25 | fraction |
| 10 | So (oil saturation) | 0.75 | fraction |
| 11 | Sg (gas saturation) | 0 | fraction |
| 12 | |||
| 13 | Undersaturated Oil Reservoir | ||
| 14 | Ce (effective) | 1.9E-05 | 1/psi |
| 15 | Ce in E-6 | 19 | (x10^-6)/psi |
| 16 | |||
| 17 | Dry Gas Reservoir | ||
| 18 | Sg for gas reservoir | 0.7 | fraction |
| 19 | Sw for gas reservoir | 0.3 | fraction |
| 20 | Ce (effective) | 7.714285714E-06 | 1/psi |
| 21 | Ce in E-6 | 7.714285714 | (x10^-6)/psi |
| 22 | |||
| 23 | Geopressured Reservoir | ||
| 24 | Rsw (solution GWR) | 10 | scf/STB |
| 25 | Bg (gas FVF) | 0.002 | RB/scf |
| 26 | Ce (geopressured) | 0.008579142857 | 1/psi |
| 27 | Ce in E-6 | 8579.142857 | (x10^-6)/psi |
| 28 | Pore Volume Compressibility | ||
| 29 | Net Overburden Stress | 8000 | psi |
| 30 | Cpv (pore volume) | 7E-06 | 1/psi |
| 31 | Cpv in E-6 | 7 | (x10^-6)/psi |
| 32 | |||
| 33 | Total System Compressibility | ||
| 34 | Ct (total) | 0.0001804 | 1/psi |
| 35 | Ct in E-6 | 180.4 | (x10^-6)/psi |
| 36 | |||
| 37 | Comparison | ||
| 38 | Reservoir Type | Ce (1/psi) | Ce (E-6) |
| 39 | Undersaturated Oil | 1.9E-05 | 19 |
| 40 | Dry Gas | 7.714285714E-06 | 7.714285714 |
| 41 | Geopressured Gas | 0.008579142857 | 8579.142857 |
Description
Calculate effective compressibility for different reservoir types. Effective compressibility is critical for material balance and pressure buildup analysis.
Compressibility Types:
- Undersaturated Oil: Above bubble point, single-phase
- Gas: Standard gas reservoir
- Geopressured: Abnormally high pressure, includes rock/water effects
- Total System: Combined fluid and rock compressibility
How to use this blueprint
- In Excel, go to the Petroleum Office ribbon tab and click Blueprint Manager
- Search for Effective Compressibility Calculations
- 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.