Back to Excel templates

Drive Mechanism Identifier — Drive Indices, GOR/WOR Diagnostics & Dykstra-Parsons Coefficient

Identify your reservoir energy source from production history, benchmark recovery factors by mechanism, and quantify permeability heterogeneity with the Dykstra-Parsons coefficient.

reservoir engineeringintermediate

TITLE

Drive Mechanism Identifier — Drive Indices, GOR/WOR Diagnostics & Dykstra-Parsons Coefficient

PRICE

$59 USD — one-time purchase

TAGLINE

Identify your reservoir energy source from production history, benchmark recovery factors by mechanism, and quantify permeability heterogeneity with the Dykstra-Parsons coefficient.

WHO IT'S FOR

Reservoir engineers performing reservoir surveillance, production performance analysis, or decline diagnostics who need to understand reservoir energy and heterogeneity.

WHAT IT DOES

Calculates normalised solution gas, gas cap, and water drive indices from production and pressure data (Craft & Hawkins method). Tracks GOR and WOR trends as diagnostic indicators. Classifies the dominant drive mechanism per period. Benchmarks expected recovery factor ranges from SPE literature. Calculates the Dykstra-Parsons coefficient (V_DP) as a permeability heterogeneity measure.

TABS INCLUDED (12)

• Instructions • Production Data — 10-period rate, GOR, WOR, pressure history • Drive Index Calc — Eo, Eg, Efw energy terms; normalised DI per period • Diagnostics — GOR/WOR trend plots and anomaly flags • Mechanism Summary — dominant drive per period; confidence rating • Drive Indices — stacked bar chart data (solution gas / gas cap / water) • GOR & WOR Analysis — monthly GOR trend with warning thresholds • Pressure vs Np — depletion rate diagnostic • Drive Classification — mechanism ID: pure/mixed/combination drive • Summary Dashboard — current dominant drive, RF estimate, recommended action • Recovery Factor by Drive — SPE benchmark RF ranges with your reservoir estimate • Dykstra-Parsons Coeff — V_DP from 20-layer k data; heterogeneity classification

KEY FEATURES

• RF benchmarks: solution gas 8–20%, gas cap 20–35%, water drive 35–55%, gravity 50–70% • Dykstra-Parsons: V_DP = 1 − (k84.1/k50); five-category interpretation from homogeneous to extremely heterogeneous • Drive index: DI_SG + DI_GC + DI_WD = 1.0 per period by definition

TECHNICAL SPECS

• Excel 2016+ compatible • 120 formulas across 12 tabs • 10-period dataset; 20-layer permeability data for Dykstra-Parsons • MDT color scheme

SHOP COPY

12-tab drive mechanism workbook: normalised drive indices, GOR/WOR diagnostics, SPE recovery factor benchmarks, and Dykstra-Parsons permeability heterogeneity coefficient.

SUGGESTED TAGS

drive mechanism, drive index, solution gas, water drive, GOR WOR, Dykstra-Parsons, reservoir heterogeneity, recovery factor, 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

drive mechanismGOR WORDykstra-Parsonsreservoir

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.

Drive Mechanism Identifier — Drive Indices, GOR/WOR Diagnostics & Dykstra-Parsons Coefficient
$59 + tax, where applicable · one-timeOpen Excel Library