Productivity Index Calculation
Spreadsheet
29 rows x 4 columns
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Productivity Index Analysis | |||
| 2 | Reservoir Properties | |||
| 3 | Permeability | 75 | md | |
| 4 | Net Pay | 40 | ft | |
| 5 | Drainage Radius | 1500 | ft | |
| 6 | Wellbore Radius | 0.354 | ft | |
| 7 | Oil Viscosity | 1.8 | cp | |
| 8 | Formation Volume Factor | 1.22 | rb/stb | |
| 9 | ||||
| 10 | Derived Properties | |||
| 11 | Drainage Area | 162.2723478 | acres | |
| 12 | Effective Wellbore Radius (s=0) | 0.354 | ft | |
| 13 | ||||
| 14 | Productivity Index vs Skin | |||
| 15 | Skin Factor | PI (stb/d/psi) | % of Ideal (s=0) | rwa (ft) |
| 16 | -1.5 | 1.585641061 | 1.245833985 | 1.586517931 |
| 17 | -1 | 1.465547285 | 1.151476622 | 0.9622717673 |
| 18 | -0.5 | 1.362364126 | 1.070405888 | 0.5836473298 |
| 19 | 0 | 1.272754701 | 1 | 0.354 |
| 20 | 1 | 1.124788852 | 0.8837436239 | 0.1302293222 |
| 21 | 2 | 1.007643832 | 0.7917030916 | 0.04790869027 |
| 22 | 3 | 0.9125981455 | 0.7170259475 | 0.0176246222 |
| 23 | 5 | 0.7677605944 | 0.6032274669 | 0.002385233238 |
| 24 | 10 | 0.5496675917 | 0.4318723719 | 1.607157514E-05 |
| 25 | ||||
| 26 | Summary | |||
| 27 | Ideal PI (s=0) | 1.272754701 | stb/d/psi | |
| 28 | Damaged PI (s=5) | 0.7677605944 | stb/d/psi | |
| 29 | PI Loss from Damage | 0.3967725331 | % |
Description
Calculate well productivity index (PI) and understand the impact of skin damage. Also shows drainage radius and effective wellbore radius calculations.
Key Relationships:
- PI = kh / (141.2 * Bo * Uo * [ln(re/rw) + s])
- Higher skin reduces PI (damaged well)
- Negative skin increases PI (stimulated well)
How to use this blueprint
- In Excel, go to the Petroleum Office ribbon tab and click Blueprint Manager
- Search for Productivity Index Calculation
- 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.