Decline Model Comparison
Spreadsheet
33 rows x 5 columns
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Decline Model Comparison | ||||
| 2 | Common Parameters | ||||
| 3 | Initial Rate | 24000 | bbl/month | ||
| 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.4 | - | ||
| 11 | m exponent | 1.3 | - | ||
| 12 | |||||
| 13 | PLE Parameters | ||||
| 14 | Di | 0.18 | 1/month | ||
| 15 | n exponent | 0.54 | - | ||
| 16 | Dinf | 0.005 | 1/month | ||
| 17 | |||||
| 18 | Rate Comparison (bbl/month) | ||||
| 19 | t (months) | Arps | Duong | PLE | Spread (%) |
| 20 | 1 | 22202.69251 | 24000 | 19946.50281 | 18.38343082 |
| 21 | 6 | 15866.74091 | 16268.16302 | 14503.4374 | 11.35155474 |
| 22 | 12 | 11516.01654 | 11022.74144 | 11351.53938 | 4.366516128 |
| 23 | 24 | 7107.230066 | 6784.319493 | 7820.138595 | 14.31237076 |
| 24 | 36 | 4958.032068 | 4920.999704 | 5763.823051 | 16.16373782 |
| 25 | 60 | 2928.593635 | 3176.323237 | 3440.689256 | 16.09417823 |
| 26 | 120 | 1294.75181 | 1667.226702 | 1209.340923 | 32.93100324 |
| 27 | |||||
| 28 | Cumulative Production (Mstb) | ||||
| 29 | t (months) | Arps | Duong | PLE | |
| 30 | 60 | 467.9721563 | 464.9361142 | 482.4559651 | |
| 31 | 120 | 583.521501 | 600.9000519 | 608.039298 | |
| 32 | 240 | 681.5489894 | 740.106871 | 676.3441459 | |
| 33 | 360 | 729.6528108 | 820.6037451 | 690.4618075 |
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)
Units: rates are bbl/month and every decline constant is 1/month, so the cumulative block is a true volume (shown as Mstb). All three model families are unit-agnostic — rate and time must share the same time base.
All three parameter sets describe one well. That is what makes the comparison mean anything. The Arps curve is the reference; the Duong and PLE parameters are fitted to it rather than chosen independently — both anchored at month 12, with Duong matched through month 24 and PLE through month 120. Three unrelated parameter sets would produce a spread that says nothing about the models, only about the parameters.
Read the spread column with that in mind. It is tightest (~4%) at month 12 where the fits are anchored, sits in the mid-teens through month 60, and widens to about a third by month 120 — models constrained by the same history separating once the history runs out. The wider figure at month 1 is expected: PLE's qi is a fitted parameter, not the observed initial rate, so its curve starts below the other two by construction.
If you re-fit one model, re-fit the others to the same history or this stops being a comparison.
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
- Click Insert to place it into your worksheet. Modify the input values to match your data.