Drive Mechanism Identifier: Drive Indices, GOR/WOR Diagnostics & Dykstra-Parsons Coefficient
Identify your reservoir energy source with four material-balance drive indices, track GOR and WOR, estimate recovery factor by mechanism, and quantify permeability heterogeneity with the Dykstra-Parsons coefficient.
TAGLINE
Identify your reservoir energy source with four material-balance drive indices, track GOR and WOR, estimate recovery factor 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 four drive indices (solution gas, gas cap, water, rock/water expansion) from a Havlena-Odeh material balance on cumulative production and pressure, with water influx solved from the balance; the four indices sum to 1.0 in every period. Tracks GOR and WOR trends with warning thresholds. Gives the dominant drive and a confidence rating for each half-year period, and classifies the reservoir as a dominant or combination drive. Estimates a recovery factor live from index-weighted benchmark ranges. Calculates the Dykstra-Parsons coefficient (V_DP) as a permeability heterogeneity measure.
TABS INCLUDED (12)
• Instructions • Production Data — 10 half-year periods: cumulative Np, pressure, period-average GOR and WOR, Bo, Rs, Bg; reservoir and rock inputs • Drive Index Calc — Bt, Eo, Eg, Efw, underground withdrawal, water influx; four drive indices per period • Diagnostics — GOR/WOR trends, anomaly flags, GOR and WOR vs cumulative oil plots • Mechanism Summary — primary and secondary drive, GOR/WOR trend, pressure support, expected RF, recommendation • Drive Indices — four indices per period with dominant drive and confidence; stacked chart • GOR & WOR Analysis — half-yearly GOR and WOR trend with warning thresholds • Pressure vs Np — pressure vs cumulative oil plot • Drive Classification — dominant or combination drive verdict with confidence and index ranking • Summary Dashboard — current drive, indices, recovery to date, RF estimate, recommended action • Recovery Factor by Drive — benchmark RF ranges with an index-weighted estimate for your reservoir • Dykstra-Parsons Coeff — V_DP from 20-layer k data (log-probability fit); heterogeneity classification
KEY FEATURES
• Drive indices: DDI + SDI + WDI + EDI = 1.0 per period, from the material balance • Classification: top index ≥ 0.65 = dominant drive, otherwise combination drive; confidence from the margin between indices • RF benchmarks: solution gas 8–20%, gas cap 20–35%, water drive 35–55%, gravity 50–70%; your estimate is index-weighted (screening) • Dykstra-Parsons: V_DP = 1 − (k84.1/k50); five-category interpretation from homogeneous to extremely heterogeneous
TECHNICAL SPECS
• Excel 2016+ compatible • 700+ formulas across 12 tabs • 10 half-year periods; 20-layer permeability data for Dykstra-Parsons • MDT color scheme
ABOUT RESERVOIR RISK SOLUTIONS
Built by petroleum engineers for petroleum engineers. All workbooks require only Microsoft Excel (2016+) — no plugins, no subscriptions. www.reservoir-risk-solutions.com
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
Licence
Single-user licence: the purchaser may use and modify this workbook for their own work, including work for their employer and clients. It may not be resold, shared publicly or redistributed as a template. Results are engineering estimates for screening and must be checked by a qualified professional before they are relied on.
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.
