Full pressure transient analysis suite: Horner, log-log diagnostic with Bourdet derivative, MDH alternative, and a radius-of-investigation drainage area calculator.
Pressure Buildup Analysis — Horner Plot, Log-Log Diagnostic, MDH & Radius of Investigation
$99 USD — one-time purchase
Full pressure transient analysis suite: Horner, log-log diagnostic with Bourdet derivative, MDH alternative, and a radius-of-investigation drainage area calculator.
Reservoir and production engineers who run pressure buildup or drawdown tests and need a structured, SPE-standard workbook for interpretation.
Builds the Horner plot from shut-in pressure vs time data 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.
• 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*, damage ratio, interpretation • Radius of Investigation — ri vs Δt table with 16 time steps; boundary flag; skin interpretation guide
• Horner: k = 162.6qBμ/(mh); s = 1.1513[(P1hr−Pwf)/m − log(k/φμctrw²) + 3.2275] • Bourdet derivative: identifies radial flow (unit-slope), linear flow (0.5-slope), 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
• Excel 2016+ compatible • 437 formulas across 8 tabs • 20-point dataset (tp=72 hrs, test at 3,400–3,800 psia) • MDT color scheme
8-tab pressure buildup workbook: Horner plot, log-log diagnostic with Bourdet derivative, MDH alternative, radius of investigation table, and skin interpretation guide.
pressure buildup, Horner plot, log-log diagnostic, Bourdet derivative, MDH, radius of investigation, skin factor, permeability, well testing, 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.