Track waterflood pattern performance: monthly WOR, instantaneous and cumulative voidage replacement ratio from reservoir volumes, displacement efficiency against the pattern's hydrocarbon pore volume, and like-for-like benchmark targets.
Track waterflood pattern performance: monthly WOR, instantaneous and cumulative voidage replacement ratio from reservoir volumes, displacement efficiency against the pattern's hydrocarbon pore volume, and like-for-like benchmark targets.
Reservoir and production engineers monitoring waterflood pattern performance and voidage balance.
Tracks monthly oil, water and injection, converts them to reservoir volumes with Bo and Bw, and calculates the voidage replacement ratio month by month and cumulatively, with a QC flag against your VRR target and tolerance. Computes HCPV from the pattern area, thickness, porosity and initial water saturation, displacement efficiency to date (ED = Np·Bo/HCPV) and the implied volumetric sweep (EV) against the maximum displacement efficiency set by Sor. Compares cumulative VRR, current ED and current WOR with your targets, each against its own measure. Pattern type is a descriptive label only; no calculation or benchmark depends on it. Assumes the reservoir is above the bubble point (no free-gas voidage).
• Instructions & Legend • Pattern Assumptions — pattern type (descriptive), area, thickness, porosity, Swi, Sor, Bo, Bw, VRR target and tolerance, ED target, WOR ceiling • Monthly Production — 36 months of oil, water and cumulative injection • Voidage Balance — production and injection voidage (RB), monthly and cumulative VRR, QC flag • WOR & Displacement — WOR, cumulative oil, ED and EV per month • Oil vs Water Crossplot — pattern maturity • VRR vs WOR Crossplot — voidage diagnostic • Cum Oil vs Inj Crossplot • Pattern Summary — cumulative VRR, current WOR and ED, ED max, EV, cumulative oil and injection • Benchmark Targets — cumulative VRR vs target, ED vs target, WOR vs ceiling, pass/fail • Summary — pattern area, headline figures, benchmark pass count
VRR = injection voidage / production voidage (instantaneous and cumulative); production voidage = (Qo·Bo + Qw·Bw) × days; HCPV = 7758 × A × h × φ × (1 − Swi); ED = Np·Bo / HCPV; ED max = 1 − Sor/(1 − Swi); EV = ED / ED max; WOR = Qw/Qo
• Excel 2016+; 850+ formulas; 36-month sample; WOR and VRR charts, live crossplots • MDT professional color scheme throughout • Yellow cells = inputs; white cells = formulas
Built by petroleum engineers for petroleum engineers. All workbooks require only Microsoft Excel (2016+) — no plugins, no subscriptions. www.reservoir-risk-solutions.com
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.
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.