Back to Excel templates

Decline Curve Analysis — Arps DCA, EUR Sensitivity, P10/P50/P90 & Rate-Cumulative Diagnostic

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 engineeringintermediateFeatured

TITLE

Decline Curve Analysis — Arps DCA, EUR Sensitivity, P10/P50/P90 & Rate-Cumulative Diagnostic

PRICE

$89 USD — one-time purchase

TAGLINE

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.

WHO IT'S FOR

Reservoir engineers, production engineers, and A&D analysts who need to match production decline, calculate EUR, generate 30-year forecasts, and quantify reserves uncertainty.

WHAT IT DOES

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.

TABS INCLUDED (9)

• 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

KEY FEATURES

• 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

TECHNICAL SPECS

• 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

SHOP COPY

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.

SUGGESTED TAGS

decline curve analysis, DCA, Arps, EUR, production forecast, hyperbolic decline, Fetkovich, P10 P50 P90, reserves uncertainty, Excel template, petroleum engineering

ABOUT RESERVOIR RISK SOLUTIONS

Built by petroleum engineers for petroleum engineers. All workbooks require only Microsoft Excel (2016+) — no plugins, no subscriptions. reservoirrisksolutions.com

decline curveArpsEURFetkovichP10 P50 P90

What you get

  • Instant workbook access after payment in your Excel Library
  • Formula-driven worksheet designed for petroleum workflows
  • No recurring fees and no plugin requirements

FAQ

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.

Decline Curve Analysis — Arps DCA, EUR Sensitivity, P10/P50/P90 & Rate-Cumulative Diagnostic
$89 + tax, where applicable · one-timeOpen Excel Library