Back to Excel templates

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.

reservoir engineeringadvanced

TITLE

Pressure Buildup Analysis — Horner Plot, Log-Log Diagnostic, MDH & Radius of Investigation

PRICE

$99 USD — one-time purchase

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

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.

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*, damage ratio, 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: 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

TECHNICAL SPECS

• Excel 2016+ compatible • 437 formulas across 8 tabs • 20-point dataset (tp=72 hrs, test at 3,400–3,800 psia) • MDT color scheme

SHOP COPY

8-tab pressure buildup workbook: Horner plot, log-log diagnostic with Bourdet derivative, MDH alternative, radius of investigation table, and skin interpretation guide.

SUGGESTED TAGS

pressure buildup, Horner plot, log-log diagnostic, Bourdet derivative, MDH, radius of investigation, skin factor, permeability, well testing, Excel template, petroleum engineering

ABOUT RESERVOIR RISK SOLUTIONS

Built by petroleum engineers for petroleum engineers. All workbooks require only Microsoft Excel (2016+) — no plugins, no subscriptions. reservoirrisksolutions.com

well testHornerBourdetMDHradius of investigation

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

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.

Pressure Buildup Analysis — Horner Plot, Log-Log Diagnostic, MDH & Radius of Investigation
$99 + tax, where applicable · one-timeOpen Excel Library