Pressure Buildup Analysis: Horner Plot, Log-Log Diagnostic, MDH & Radius of Investigation
Full pressure transient analysis suite: Horner, log-log diagnostic with Bourdet derivative, MDH alternative, and a radius-of-investigation drainage area calculator.
TAGLINE
Full pressure transient analysis suite: Horner, log-log diagnostic with Bourdet derivative, MDH alternative, and a radius-of-investigation drainage area calculator.
WHO IT'S FOR
Reservoir and production engineers who run pressure buildup or drawdown tests and need a structured, SPE-standard workbook for interpretation.
WHAT IT DOES
Fits the Horner straight line live to the points you flag as radial flow and extracts permeability, skin factor, flow efficiency, and P*. Generates the log-log diagnostic plot with Bourdet derivative for flow regime identification. Provides the MDH (Miller-Dyes-Hutchinson) plot as an alternative analysis method. Calculates radius of investigation as a function of shut-in time and flags potential boundary effects.
TABS INCLUDED (8)
• Instructions • Test Parameters — well and reservoir inputs (q, Bo, μ, φ, ct, rw, h) • Shut-in Data — 20 shut-in pressure vs time measurements • Horner Plot — log(Horner time) vs Pws scatter with MTR straight-line fit • Log-Log Diagnostic — ΔP and Bourdet derivative; flow regime identification • Skin & Permeability — MDH plot; permeability, skin, FE calculations • Well Test Summary — k, s, kh, FE, P*, interpretation • Radius of Investigation — ri vs Δt table with 16 time steps; boundary flag; skin interpretation guide
KEY FEATURES
• Horner: k = 162.6qBμ/(mh); s = 1.1513[(P1hr−Pwf)/m − log(k/φμctrw²) + 3.2275] • Bourdet derivative on equivalent time: wellbore storage (unit slope), linear flow (half slope), radial flow (flat), boundary effects • ri formula: ri = 0.0325√(kt/φμct) — auto-linked from Test Parameters tab • Skin guide: 5 categories from hydraulic fracture (s<−5) to severe damage (s>15) • Boundary flag: automatically triggered when calculated ri approaches drainage estimate
TECHNICAL SPECS
• Excel 2016+ compatible • 700+ formulas across 8 tabs • 20-point dataset (tp=72 hrs, test at 3,400–3,800 psia) • 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.
