Decline Diagnostics Analysis
Spreadsheet
38 rows x 6 columns
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Decline Diagnostics Analysis | |||||
| 2 | Arps Parameters (for D calculation) | |||||
| 3 | Initial Rate (qi) | 1000 | bbl/day | |||
| 4 | Initial Decline (Di) | 0.08 | 1/month | |||
| 5 | b-exponent | 0.6 | - | |||
| 6 | ||||||
| 7 | Production Data (Example) | |||||
| 8 | ||||||
| 9 | ||||||
| 10 | t (months) | q (bbl/d) | Np (Mstb) | |||
| 11 | 1 | 920 | 27.6 | |||
| 12 | 2 | 850 | 53.1 | |||
| 13 | 3 | 795 | 76.7 | |||
| 14 | 4 | 750 | 98.7 | |||
| 15 | 6 | 675 | 138.1 | |||
| 16 | 9 | 595 | 190.5 | |||
| 17 | 12 | 535 | 237.2 | |||
| 18 | 18 | 455 | 316.8 | |||
| 19 | 24 | 400 | 385.2 | |||
| 20 | 36 | 330 | 505.6 | |||
| 21 | 48 | 280 | 605.8 | |||
| 22 | 60 | 245 | 691.7 | |||
| 23 | ||||||
| 24 | Diagnostic Calculations | |||||
| 25 | 1 | 920 | -70 | 0.07608695652 | -13.63785714 | 0.07633587812 |
| 26 | 3 | 795 | -50 | 0.1886792453 | 2.173901746 | 0.06993007174 |
| 27 | 6 | 675 | -33.16666667 | 0.2948148148 | 5.081440969 | 0.0621118063 |
| 28 | 12 | 535 | -17.77777778 | 0.3987538941 | 6.584412125 | 0.05076143237 |
| 29 | 24 | 400 | -8.055555556 | 0.4833333333 | 5.490333084 | 0.03717473855 |
| 30 | 36 | 330 | -5 | 0.5454545455 | 0.8319343477 | 0.02932553237 |
| 31 | 48 | 280 | -3.541666667 | 0.6071428571 | 1.320064537 | 0.02421309425 |
| 32 | 60 | 245 | -2.916666667 | 0.7142857143 | 6.525 | 0.02061857521 |
| 33 | ||||||
| 34 | Flow Regime Interpretation | |||||
| 35 | Beta Value | Flow Regime | ||||
| 36 | 0.5 | Linear flow (fracture dominated) | ||||
| 37 | 1 | Radial/BDF flow | ||||
| 38 | 0.25 | Bilinear flow |
Description
Diagnostic analysis for decline curve interpretation using derivative-based methods. These tools help identify flow regimes and validate decline model selection.
Diagnostic Functions:
- Bourdet Derivative: Smoothed rate derivative for flow regime identification
- Beta Parameter: β = t × D identifies decline type (linear, radial, etc.)
- b(t) Parameter: Time-varying b-factor shows transition from transient to BDF
- D(t): Instantaneous decline rate
How to use this blueprint
- In Excel, go to the Petroleum Office ribbon tab and click Blueprint Manager
- Search for Decline Diagnostics 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.