DST Sequence Analysis — Horner Interpretation


Spreadsheet

58 rows x 7 columns

fx
A B C D E F G
1 DST Sequence Analysis
2 Interpretation Inputs
3 Flow rate, q 250 STB/D
4 FVF, Bo 1.25 bbl/STB
5 Viscosity, μ 1 cP
6 Porosity, φ 0.2 fraction
7 Total compressibility, ct 1.5E-05 1/psi
8 Wellbore radius, rw 0.354 ft
9 Net pay, h 30 ft
10 Bourdet L (smoothing) 0.2
11
12 Forward Model
13 Permeability, k 100 mD
14 Skin factor, S 3 dimensionless
15 Initial pressure, Pi 5000 psia
16 Wellbore storage, C 0.0005 bbl/psi
17
18 DST Schedule Time (h) Rate (STB/D)
19 Initial Flow (IF) 0 250
20 Initial Shut-In (ISI) 0.05 0
21 Final Flow (FF) 1 250
22 Final Shut-In (FSI) 5 0
23
24 DST Computed Values
25 tp (FF duration) 4 h
26 ISIP (end of ISI) 4999.61906 psia
27 Pwf (end of FF) 4857.615836 psia
28
29 Δt (h) Pws model ΔPws Horner Time log₁₀(HT) IARF Bourdet dPws/dlog₁₀(HT)
30 0.01 4944.263613 86.64777673 401 2.603144373 0 -31.61918376
31 0.05 4966.228175 108.6123385 81 1.908485019 0 -23.01605504
32 0.1 4971.951143 114.3353071 41 1.612783857 0 -18.72176562
33 0.2 4977.210542 119.5947055 21 1.322219295 0 -17.83269682
34 0.5 4983.647705 126.0318688 9 0.9542425094 0 -17.33304422
35 1 4988.043959 130.4281223 5 0.6989700043 0 -17.16939222
36 2 4991.842861 134.2270251 3 0.4771212547 1 -17.10523796
37 3 4993.708166 136.0923297 2.333333333 0.3679767853 1 -17.08820989
38 4 4994.851834 137.2359981 2 0.3010299957 1 -17.08556222
39 5 4995.63351 138.0176736 1.8 0.2552725051 1 -17.08499432
40 6 4996.204546 138.58871 1.666666667 0.2218487496 1 -17.08638755
41
42 Interpretation Results
43 IARF slope, m -17.09007839 psi/cycle
44 P* (extrapolated) 4999.996475 psia
45 P at Δt=1hr 4988.051023 psia
46 Permeability, k 99.10721072 mD
47 Skin factor, S 2.809866684 dimensionless
48 Radius of investigation 457.2602568 ft
49 Effective wellbore radius 0.0213154088 ft
50 End of WBS (unit slope) 0.03930396832 h
51
52 DST Cross-Check
53 ISIP − P* -0.3774154291 psia
54
55 Validation Input Recovered Error %
56 k (mD) 100 99.10721072 -0.892789282
57 S (dimensionless) 3 2.809866684 -6.337777197
58 P* (psia) 5000 4999.996475 -7.049664186E-05

Description

Standard four-period drill stem test analysis: Initial Flow (IF) → Initial Shut-In (ISI) → Final Flow (FF) → Final Shut-In (FSI). Forward model generates synthetic gauge data using PO.PTA.Pw.VW with built-in superposition across all rate changes. Horner analysis of the FSI buildup extracts permeability, skin, and extrapolated pressure P*. Cross-checks ISIP against Horner P* as an independent reservoir pressure estimate.

DST convention. A standard DST has four periods: IF flushes the tool and provides a preliminary flow test; ISI allows initial pressure recovery; FF is the main flow period for permeability determination; FSI is the main buildup for quantitative analysis. The IF is intentionally short (5–30 min) to minimize reservoir depletion before ISI.

Horner producing time. The Horner method uses tp = FF duration (4h), ignoring the IF period. This is standard DST practice — the ISI recovery effectively resets the pressure field if the IF was short relative to the ISI. For the default case (3 min IF, 57 min ISI), the IF transient has largely dissipated by the start of FF.

ISIP as pressure estimate. The Initial Shut-In Pressure is the best direct Pi estimate from a DST. Unlike the Horner P* (which is extrapolated), ISIP is measured at the end of a short-flow/long-shut-in sequence. In low-permeability formations where ISI doesn't reach IARF, ISIP still systematically underestimates Pi — Horner analysis of the FSI then provides a better extrapolated value.

Full superposition vs simplified Horner. PO.PTA.Pw.VW computes the exact pressure response accounting for all four rate changes via superposition. The Horner interpretation, however, uses the simplified tp-approximation that assumes a single drawdown at rate q for tp hours. For short IF with adequate ISI recovery, this approximation introduces negligible error. For two-cycle DSTs where IF is a significant fraction of FF, consider the rigorous superposition time approach (Odeh-Jones 1965).

Two-cycle Horner error. When the IF period is long relative to FF, or when ISI fails to reach radial flow, the single-cycle Horner analysis can overestimate permeability by 2× or more (Russell, PETSOC-90-06). This blueprint's default parameters (3 min IF, 4h FF) keep the error small, but the cross-check row quantifies any discrepancy.

Reference: Earlougher, R.C. Jr. (1977). "Advances in Well Test Analysis." SPE Monograph Vol. 5, Chapter 14. Horne, R.N. (1995). "Modern Well Test Analysis." Petroway Inc.

Workflow

  • Interpretation Inputs (rows 3–10): Reservoir and fluid properties for the test well — q (DST flow rate), Bo, μ, φ, ct, rw, h, and Bourdet smoothing L. Flow rate q is common to both IF and FF periods.
  • Forward Model (rows 12–16): k, S, Pi, C for synthetic data generation. In real DST interpretation, these are unknown and the goal of analysis.
  • DST Schedule (rows 18–22): Four periods defined as [time, rate] pairs. IF starts at t=0 (3 min flow), ISI at t=0.05h (57 min shut-in), FF at t=1.0h (4h flow), FSI at t=5.0h (6h shut-in). The array $B$19:$C$22 is passed as prod_data to PO.PTA.Pw.VW.
  • Computed Values (rows 24–27): tp = FF duration (used as producing time for Horner analysis). ISIP = pressure at end of ISI (independent Pi estimate). Pwf = last flowing pressure at end of FF (needed for skin calculation).
  • FSI Data Table (rows 29–40): Column A = shut-in time Δt during FSI. Column B = Pws from forward model with full 4-period superposition. Column C = pressure rise ΔPws = Pws − Pwf. Column D–E = Horner time coordinates. Column F = IARF flag. Column G = Bourdet derivative on the log₁₀(HT) axis, with SORT/SORTBY to handle descending x-values.
  • IARF Selection: Examine column G for a stabilization plateau. For the default case (k=100 mD, S=3, C=0.0005 bbl/psi), IARF begins at approximately Δt ≥ 2h. Set column F = 1 for these points.
  • Interpretation Results (rows 42–50): Same Horner analysis as po.pta.horner.pstar — slope m from AVERAGEIF on Bourdet, P* at HT=1, P1hr, k, S, rinv, rwa, and end-of-WBS estimate.
  • DST Cross-Check (row 53): Compares ISIP (from ISI period) against P* (from FSI Horner extrapolation). In a good test, both should approximate Pi. The difference quantifies how well the ISI recovered from the IF disturbance.
  • Validation (rows 55–58): Round-trip error check. Expected: k < 2%, P* < 0.01%. Skin error is typically 5–10% due to the Horner tp-approximation ignoring the IF period — this is an inherent limitation of simplified DST analysis, not a blueprint error.
How to use this blueprint
  1. In Excel, go to the Petroleum Office ribbon tab and click Blueprint Manager
  2. Search for DST Sequence Analysis — Horner Interpretation
  3. Click on the blueprint to preview the spreadsheet template
  4. Click Insert to place it into your worksheet. Modify the input values to match your data.
Tags:
DSTdrill-stem-testHornerbuildupISIPFSIPsuperpositionwell-testingBourdetiarf

Need a custom calculation? Request a Blueprint

An unhandled error has occurred. Reload X