Identify your reservoir energy source from production history, benchmark recovery factors by mechanism, and quantify permeability heterogeneity with the Dykstra-Parsons coefficient.
Drive Mechanism Identifier — Drive Indices, GOR/WOR Diagnostics & Dykstra-Parsons Coefficient
$59 USD — one-time purchase
Identify your reservoir energy source from production history, benchmark recovery factors by mechanism, and quantify permeability heterogeneity with the Dykstra-Parsons coefficient.
Reservoir engineers performing reservoir surveillance, production performance analysis, or decline diagnostics who need to understand reservoir energy and heterogeneity.
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.
• 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
• 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
• Excel 2016+ compatible • 120 formulas across 12 tabs • 10-period dataset; 20-layer permeability data for Dykstra-Parsons • MDT color scheme
12-tab drive mechanism workbook: normalised drive indices, GOR/WOR diagnostics, SPE recovery factor benchmarks, and Dykstra-Parsons permeability heterogeneity coefficient.
drive mechanism, drive index, solution gas, water drive, GOR WOR, Dykstra-Parsons, reservoir heterogeneity, recovery factor, 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.