Decline Curve Analysis — Arps with EUR

Complete Arps decline analysis: forecast rate and cumulative production over 20 years, calculate EUR at economic limit, and compare b-exponent sensitivity (b=0, 0.5, 1.0). Named input cells for qi, Di, b, and economic limit rate.


Inputs

Named cells you can edit — every result recalculates from them.

Name Description Default Unit
DCA_Qi Initial Rate (qi) 1000 bbl/day
DCA_Di Initial Decline Rate (Di) 0.05 1/month
DCA_b b-Exponent 0.5 (0=exp, 1=harmonic)
DCA_Qecon Economic Limit Rate 10 bbl/day

3 sheets, shown with the values the file opens with

A B C D E F
1 Decline Curve Analysis — Inputs
2 Arps decline model: q(t) = qi / (1 + b·Di·t)^(1/b). The b-exponent controls the decline shape — 0 = exponential (steepest), 1 = harmonic (most optimistic). EUR is the cumulative production when rate drops below the economic limit.
3
4 Well Parameters
5 Initial Rate (qi) 1000 bbl/day
6 Initial Decline Rate (Di) 0.05 1/month
7 b-Exponent 0.5 (0=exp, 1=harmonic)
8
9 Economic Parameters
10 Economic Limit Rate 10 bbl/day
11
12 Calculated EUR
13 EUR 36 Mstb
14 Time to Economic Limit 360 months
Opens inNeeds the Petroleum Office add-in: its PO functions show #NAME? without it once Excel recalculates.
Functions used PO.DCA.Arps.DPO.DCA.Arps.EURPO.DCA.Arps.ProdPO.DCA.Arps.RatePO.DCA.Arps.Time
FileDeclineFunctions.xlsx, 19 KB
CategoryProduction
For agents and tools Structure (.json) · Descriptor (.md)
Tags:
decline-curvearpseureconomic-limitproduction-forecastb-exponentsensitivity

Need a workbook we don't have? Suggest a Workbook