DST Sequence Analysis — Horner Interpretation
Spreadsheet
58 rows x 7 columns
| 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_datato 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
- In Excel, go to the Petroleum Office ribbon tab and click Blueprint Manager
- Search for DST Sequence Analysis — Horner Interpretation
- Click on the blueprint to preview the spreadsheet template
- Click Insert to place it into your worksheet. Modify the input values to match your data.