Decline Model Comparison


Spreadsheet

33 rows x 5 columns

fx
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
  1. In Excel, go to the Petroleum Office ribbon tab and click Blueprint Manager
  2. Search for Decline Model Comparison
  3. Click on the blueprint to preview
  4. Click Insert to place it into your worksheet. Modify the input values to match your data.
Tags:
declineArpsDuongplecomparisonmodelsforecast

Need a custom calculation? Request a Blueprint