Decline Model Comparison
Spreadsheet
33 rows x 5 columns
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Decline Model Comparison | ||||
| 2 | Common Parameters | ||||
| 3 | Initial Rate | 800 | bbl/day | ||
| 4 | |||||
| 5 | Arps Parameters | ||||
| 6 | Initial Decline (Di) | 0.08 | 1/month | ||
| 7 | b-exponent | 0.7 | - | ||
| 8 | |||||
| 9 | Duong Parameters | ||||
| 10 | a constant | 1.3 | - | ||
| 11 | m exponent | 1.15 | - | ||
| 12 | |||||
| 13 | PLE Parameters | ||||
| 14 | Di | 0.1 | 1/month | ||
| 15 | n exponent | 0.4 | - | ||
| 16 | Dinf | 0.005 | 1/month | ||
| 17 | |||||
| 18 | Rate Comparison (bbl/day) | ||||
| 19 | t (months) | Arps | Duong | PLE | Spread (%) |
| 20 | 1 | 740.0897503 | 800 | 720.2596181 | 10.58337039 |
| 21 | 6 | 528.8913636 | 785.7325622 | 632.6039004 | 39.57028477 |
| 22 | 12 | 383.8672181 | 681.04463 | 575.0285662 | 54.36369685 |
| 23 | 24 | 236.9076689 | 553.3795434 | 496.7521632 | 73.76741083 |
| 24 | 36 | 165.2677356 | 476.8708562 | 439.3583892 | 86.43661316 |
| 25 | 60 | 97.61978784 | 385.0030307 | 354.3409722 | 103.0092028 |
| 26 | 120 | 43.15839368 | 275.6745379 | 222.7210496 | 128.8049681 |
| 27 | |||||
| 28 | Cumulative Production (Mstb) | ||||
| 29 | t (months) | Arps | Duong | PLE | |
| 30 | 60 | 15.59907188 | 32.83936372 | 29.17073174 | |
| 31 | 120 | 19.4507167 | 52.18092049 | 46.08260491 | |
| 32 | 240 | 22.71829965 | 79.2079051 | 64.21141892 | |
| 33 | 360 | 24.32176036 | 99.17037442 | 72.4665763 |
Description
Compare multiple decline curve models for the same well. Different models may be more appropriate depending on reservoir type and flow regime. Arps is standard for conventional, Duong for unconventional transient, and PLE for tight/shale.
Models Compared:
- Arps: Classic hyperbolic decline (conventional reservoirs)
- Duong: Power-law decline (unconventional, transient linear flow)
- PLE: Power Law Exponential (tight/shale, early time)
How to use this blueprint
- In Excel, go to the Petroleum Office ribbon tab and click Blueprint Manager
- Search for Decline Model Comparison
- 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.