All four Arps methods, Fetkovich rate-cumulative diagnostic, probabilistic P10/P50/P90 EUR, and a full EUR sensitivity matrix — the most complete DCA workbook available.
Decline Curve Analysis — Arps DCA, EUR Sensitivity, P10/P50/P90 & Rate-Cumulative Diagnostic
$89 USD — one-time purchase
All four Arps methods, Fetkovich rate-cumulative diagnostic, probabilistic P10/P50/P90 EUR, and a full EUR sensitivity matrix — the most complete DCA workbook available.
Reservoir engineers, production engineers, and A&D analysts who need to match production decline, calculate EUR, generate 30-year forecasts, and quantify reserves uncertainty.
Implements all four Arps decline methods simultaneously (exponential, hyperbolic, harmonic, modified hyperbolic with Dterm), matches to monthly production history, generates a 30-year annual forecast, plots the Fetkovich rate-vs-cumulative diagnostic, and produces probabilistic EUR ranges (P10/P50/P90) with a b-factor interpretation guide.
• Instructions • DCA Assumptions — qi, Di, b, Dterm, economic limit, GOR, forecast period • Production History — 24-month actual rate data entry • Arps DCA — all 4 decline curves vs actual; log-scale rate-time chart • 30-Year Forecast — annual oil/gas/cumulative table • Rate vs Cumulative — Fetkovich log-log diagnostic plot • EUR Sensitivity — b-exponent × annual decline rate matrix (5×7) • P10-P50-P90 EUR — low/base/high case EUR with b-factor interpretation guide • Decline Rate Reference — nominal vs effective Di conversion table; half-life by rate
• Modified hyperbolic: transitions from hyperbolic to exponential at Dterm (SPE best practice) • Rate-cumulative: identifies BDF vs transient flow regime • P10/P50/P90: qi range 1200–2800 BOPD, Di range 35–55%/yr, b range 0.6–1.0 • EUR sensitivity heat map: 7 × 6 matrix, current b and Di highlighted • Decline rate table: 12 Di values (10–80%/yr), nominal → effective → monthly conversion
• Excel 2016+ compatible • 1,216 formulas across 9 tabs • 24-month production dataset (qi=1,850 BOPD, Di=45%/yr, b=0.80) • MDT professional color scheme
9-tab DCA workbook: all 4 Arps methods, 30-year forecast, Fetkovich rate-cumulative, EUR sensitivity matrix, P10/P50/P90 probabilistic EUR, and decline rate conversion table.
decline curve analysis, DCA, Arps, EUR, production forecast, hyperbolic decline, Fetkovich, P10 P50 P90, reserves uncertainty, Excel template, petroleum engineering
Built by petroleum engineers for petroleum engineers. All workbooks require only Microsoft Excel (2016+) — no plugins, no subscriptions. reservoirrisksolutions.com
Is this a one-time purchase?
Yes. Each workbook is sold as a one-time purchase with no recurring subscription.
How do I access purchased files?
After checkout, your file appears in Excel Library under your account for download.
Do these templates require macros or plugins?
No. Templates are designed for Excel 2016+ and do not require VBA macros or external add-ins.