---
cid: po.bp.pta.interference.test
hub: pta
tags: [interference-test, pulse-test, line-source, exponential-integral, Kamal-Brigham, permeability, well-testing]
facets: { discipline: reservoir, property: permeability }
title: Interference and Pulse Test
summary: "Estimates interwell kh and storativity from an interference test by the line-source solution and checks them with a pulse test."
slug: po.pta.interference.test
type: worksheet
---

# Interference and Pulse Test

## Description

What interwell permeability-thickness kh and storativity φct does an interference test give, and does a pulse test between the same two wells agree? You paste the observation well's times and pressure drop, and set the active well's rate, the fluid, h, the well spacing and one pulse's lag and amplitude. The sheet reads the drop on the line-source solution at the observation well, from its late-time semilog line and from a match of the whole curve. You read off kh, k and φct from each, and from the pulse.

**Parameters:**
- **Active well, fluid and spacing**: the rate, Bo, μ, h and the distance to the observation well (`IT_q`, `IT_Bo`, `IT_mu`, `IT_h`, `IT_r`)
- **Analysis settings**: where the semilog line starts (`IT_From`), the x it must be below there (`IT_xMax`, 0.05), the Bourdet window (`IT_L`), the gauge's resolution (`IT_Res`) and the agreement tolerance (`IT_KTol`, ±5 %)
- **Pulse test**: the cycle length, pulse ratio, pulse number, time lag and amplitude (`IT_dtC`, `IT_Fp`, `IT_n`, `IT_tL`, `IT_PDp`)
- **Synthetic model**: k, φ and ct (`IT_ModelK`, `IT_phi`, `IT_ct`)
- **Data**: time and Δp at the observation well, the region `IT_Data`

**How to use it:** Paste the times since the active well opened and the observation well's Δp = pi − p over columns A and B, and set the rate, the fluid, h and r. Remove the trend before you take Δp. Read the pulse's lag and amplitude off the observation gauge after drift correction, as the pulse analysis defines them: the lag from the end of pulse n to its extremum, and the amplitude from the line tangent to the two neighbouring extrema. The model columns and the round-trip check then don't apply. A semilog plot draws the observed Δp, the match and the semilog line, and a log-log plot draws Δp and its Bourdet derivative.

**Method:** One well produces at a constant rate. An observation well a distance r away records the small pressure drop that reaches it. In an infinite, homogeneous reservoir that drop is the line-source solution, Δp = −70.6·qBμ/(kh)·Ei(−x) with x = φμct·r²/(4·0.0002637·k·t). The sheet draws it with the exponential integral beside its late-time logarithm, −Ei(−x) ≈ −ln x − γ, so you can see where the semilog line holds.

- **Semilog line.** The line is fitted by least squares over the points from the line's start time. Its slope m gives k = 162.6·qBμ/(m·h). Its Δp at 1 hr gives φct = k/(μr²)·10^−(Δp1h/m + log₁₀(1/(4·0.0002637)) + γ/ln 10), the line-source form of the MDH skin equation at zero skin. The line holds once x is small. The sheet reports x at the line's first point and warns above the x limit.
- **Match.** The match fits Δp = A·E1(B/t) to every point, with A = 70.6·qBμ/(kh) and B = φμct·r²/(4·0.0002637·k). It works in ln A and ln B. The sensitivities are A·E1(B/t) and −A·e^(−B/t), because the derivative of E1(x) is −e^(−x)/x. Each Gauss-Newton pass therefore needs one column of E1 values and five sums. It starts from the semilog line and takes four passes, each written out as its own columns, so the sheet holds no circular reference. Then k = 70.6·qBμ/(A·h) and φct = B·4·0.0002637·k/(μr²).
- **Pulse test.** The pulse analysis (Kamal and Brigham) finds the diffusivity whose line-source pulse train has the measured lag, then reads k from the amplitude. Odd pulses are flow periods and even pulses shut-ins.

**Example:** The PTA reference well (250 STB/d, Bo 1.25 bbl/STB, μ 1 cp, h 30 ft) produces into the buildup sheets' reservoir (k 50 mD, φ 20 %, ct 1.5 × 10⁻⁵ 1/psi, so φct = 3 × 10⁻⁶ 1/psi). The observation well is 300 ft away, read from 1 to 316 hr. The drop reaches 0.015 psi at 1 hr and 52.4 psi at 316 hr.

The semilog line over the 4 points from 133 hr has m = 33.01 psi/cycle and crosses Δp = 0 near 8.2 hr, so k = 51.31 mD and φct = 2.764 × 10⁻⁶ 1/psi, 2.6 % high and 7.9 % low. x is 0.035 at 133 hr, under the 0.05 limit: the line is close, but even there −Ei(−x) has not quite reached its logarithm. The match starts from that line and lands on k = 50.00 mD, kh = 1,500 md·ft and φct = 3.000 × 10⁻⁶ 1/psi. The first pass takes it to 50.04 mD, the second to within 10⁻⁶, and the third and fourth change nothing. The pulse test runs 6-hour pulses, a 12-hour cycle at F′ = ½, between the same wells. Pulse 4, a shut-in, lags 1.5571 hr behind its end with an amplitude of 2.4515 psi, which gives k = 50.00 mD and φct = 3.000 × 10⁻⁶ 1/psi. On Kamal and Brigham's chart that is (tL)D/rD² = 0.0760 and ΔpD·(tL/ΔtC)² = 0.00140. The amplitude is 245 times the 0.01 psi gauge resolution.

The sheet was checked against the Engineering library's interference-test pressure drop (Team76.Engineering 6.0.0), the line-source drop at the observation well, on the same well, fluid, rock, rate and 21 times. The sheet's Δp column (the exponential integral with 141.2/2 and 4 × 0.0002637) equals it to 10⁻⁶ psi at every time. A standalone script then repeats the analysis on the library's Δp. It fits the semilog line with its own least squares and runs its own Gauss-Newton with its own E1 (power series and continued fraction, not the add-in's exponential integral), to convergence rather than four passes. A brute-force grid over k and φct finds the same minimum. It reproduces m 33.0087, k 51.3122, φct 2.76429 × 10⁻⁶ and x 0.0345607, every pass of the match to 10⁻⁶, and the converged k = 50 and φct = 3 × 10⁻⁶. The pulse readings come from the independent pulse forward model of the pulse analysis's own reference checks (line source, extrema by bisection, the tangent line by golden-section search). At the extremum, its pressure agrees with the library's interference-test pressure drop over the pulse train's rate history to 10⁻¹⁴ psi. No printed interference or pulse example with every input given was to hand (Earlougher's chapter 9 examples were not), so the sheet is not compared with a published one.

## Validity

The line source assumes an infinite, homogeneous, isotropic reservoir between the wells, a constant rate, and an observation well that doesn't flow. The active well's storage and skin don't reach the observation well in this model: at a few hundred feet they matter only for the first hours. A sealing fault or a constant-pressure boundary bends the late data. Anisotropy needs three observation wells. The semilog line holds only when x is small, below about 0.05, which at 300 ft takes the 4 points from 133 hr. Over a shorter test the match is the answer and the line only its starting point. The match is least squares in Δp, so the late points weigh most, and it needs a start within a factor of about two of the answer.

The pulse test needs drift-free readings and a lag shorter than one pulse. Pulse 1 has no tangent line, so the pulse analysis returns #N/A for n = 1. The pulse and interference results are both interwell averages, so they should agree. A large difference points at a misread lag. The sheet does not type-curve match storage and skin at the active well, read anisotropy or regress the whole record with a boundary; the add-in has no function for these.

Named alternatives: type-curve matching of interference data with wellbore storage and skin at the active well (Tongpenyai and Raghavan), anisotropic interference from three observation wells (Ramey), and nonlinear regression of the whole record with a boundary.

## References

- Theis, C.V. (1935). The Relation Between the Lowering of the Piezometric Surface and the Rate and Duration of Discharge of a Well Using Ground-Water Storage. *Trans. AGU* 16, 519–524.
- Earlougher, R.C. Jr. (1977). *Advances in Well Test Analysis*, SPE Monograph 5, ch. 9 (multiple-well testing).
- Kamal, M. and Brigham, W.E. (1975). Pulse-Testing Response for Unequal Pulse and Shut-In Periods. *SPEJ* 15(5), 399–410.
- Abramowitz, M. and Stegun, I.A. (1964). *Handbook of Mathematical Functions*, ch. 5 (the exponential integral).
- Horne, R.N. (1995). *Modern Well Test Analysis: A Computer-Aided Approach*, 2nd ed. Petroway (interference testing).

## Functions used

`PO.Math.Ei`, `PO.PTA.Horner.k`, `PO.PTA.Pulse.Analysis`, `PO.DCA.Diag.Bourdet.SemiLog`

## Spreadsheet: PtaInterferenceTest

|     | A                                                                                                                                                                    | B                                                                                                        | C                                                                                                                                                                                                                                        | D                                  | E                             | F                                              | G                                                                                                                                                                                                                         | H                                                                                                                                                                                                                         | I                           | J                           | K                           | L                           | M                |
|-----|----------------------------------------------------------------------------------------------------------------------------------------------------------------------|----------------------------------------------------------------------------------------------------------|------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|------------------------------------|-------------------------------|------------------------------------------------|---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|-----------------------------|-----------------------------|-----------------------------|-----------------------------|------------------|
| 1   | Interference and Pulse Test                                                                                                                                          |                                                                                                          | Petroleum Office                                                                                                                                                                                                                         |                                    |                               |                                                |                                                                                                                                                                                                                           |                                                                                                                                                                                                                           |                             |                             |                             |                             |                  |
| 2   | Blue cells on yellow are inputs. Paste the observation well's times and Δp over columns A and B; kh and φct follow from the semilog line and the match.              |                                                                                                          |                                                                                                                                                                                                                                          |                                    |                               |                                                |                                                                                                                                                                                                                           |                                                                                                                                                                                                                           |                             |                             |                             |                             |                  |
| 3   | Active Well, Fluid and Observation Well                                                                                                                              |                                                                                                          |                                                                                                                                                                                                                                          |                                    |                               |                                                |                                                                                                                                                                                                                           |                                                                                                                                                                                                                           |                             |                             |                             |                             |                  |
| 4   | Active well's rate, q                                                                                                                                                | 250                                                                                                      | STB/d                                                                                                                                                                                                                                    |                                    |                               |                                                |                                                                                                                                                                                                                           |                                                                                                                                                                                                                           |                             |                             |                             |                             |                  |
| 5   | Oil formation volume factor, Bo                                                                                                                                      | 1.25                                                                                                     | bbl/STB                                                                                                                                                                                                                                  |                                    |                               |                                                |                                                                                                                                                                                                                           |                                                                                                                                                                                                                           |                             |                             |                             |                             |                  |
| 6   | Oil viscosity, μ                                                                                                                                                     | 1                                                                                                        | cp                                                                                                                                                                                                                                       |                                    |                               |                                                |                                                                                                                                                                                                                           |                                                                                                                                                                                                                           |                             |                             |                             |                             |                  |
| 7   | Net pay, h                                                                                                                                                           | 30                                                                                                       | ft                                                                                                                                                                                                                                       |                                    |                               |                                                |                                                                                                                                                                                                                           |                                                                                                                                                                                                                           |                             |                             |                             |                             |                  |
| 8   | Distance to the observation well, r                                                                                                                                  | 300                                                                                                      | ft                                                                                                                                                                                                                                       |                                    |                               |                                                |                                                                                                                                                                                                                           |                                                                                                                                                                                                                           |                             |                             |                             |                             |                  |
| 9   | Analysis Settings                                                                                                                                                    |                                                                                                          |                                                                                                                                                                                                                                          |                                    |                               |                                                |                                                                                                                                                                                                                           |                                                                                                                                                                                                                           |                             |                             |                             |                             |                  |
| 10  | Semilog line over the points from t                                                                                                                                  | 120                                                                                                      | hr                                                                                                                                                                                                                                       |                                    |                               |                                                |                                                                                                                                                                                                                           |                                                                                                                                                                                                                           |                             |                             |                             |                             |                  |
| 11  | Semilog line valid while x at its start is ≤                                                                                                                         | 0.05                                                                                                     | —                                                                                                                                                                                                                                        |                                    |                               |                                                |                                                                                                                                                                                                                           |                                                                                                                                                                                                                           |                             |                             |                             |                             |                  |
| 12  | Bourdet smoothing window, L                                                                                                                                          | 0.2                                                                                                      | cycles                                                                                                                                                                                                                                   |                                    |                               |                                                |                                                                                                                                                                                                                           |                                                                                                                                                                                                                           |                             |                             |                             |                             |                  |
| 13  | Gauge resolution                                                                                                                                                     | 0.01                                                                                                     | psi                                                                                                                                                                                                                                      |                                    |                               |                                                |                                                                                                                                                                                                                           |                                                                                                                                                                                                                           |                             |                             |                             |                             |                  |
| 14  | Round trip and pulse: k agrees within ±                                                                                                                              | 0.05                                                                                                     | %                                                                                                                                                                                                                                        |                                    |                               |                                                |                                                                                                                                                                                                                           |                                                                                                                                                                                                                           |                             |                             |                             |                             |                  |
| 15  | Pulse Test Between the Same Wells (Kamal-Brigham)                                                                                                                    |                                                                                                          |                                                                                                                                                                                                                                          |                                    |                               |                                                |                                                                                                                                                                                                                           |                                                                                                                                                                                                                           |                             |                             |                             |                             |                  |
| 16  | Cycle length, ΔtC (one flow and one shut-in)                                                                                                                         | 12                                                                                                       | hr                                                                                                                                                                                                                                       |                                    |                               |                                                |                                                                                                                                                                                                                           |                                                                                                                                                                                                                           |                             |                             |                             |                             |                  |
| 17  | Pulse ratio, F′ = flowing period / cycle                                                                                                                             | 0.5                                                                                                      | —                                                                                                                                                                                                                                        |                                    |                               |                                                |                                                                                                                                                                                                                           |                                                                                                                                                                                                                           |                             |                             |                             |                             |                  |
| 18  | Pulse read, n (2 or more; odd flows, even shut-ins)                                                                                                                  | 4                                                                                                        | —                                                                                                                                                                                                                                        |                                    |                               |                                                |                                                                                                                                                                                                                           |                                                                                                                                                                                                                           |                             |                             |                             |                             |                  |
| 19  | Time lag from the end of pulse n, tL                                                                                                                                 | 1.557117                                                                                                 | hr                                                                                                                                                                                                                                       |                                    |                               |                                                |                                                                                                                                                                                                                           |                                                                                                                                                                                                                           |                             |                             |                             |                             |                  |
| 20  | Pulse amplitude from the tangent line, Δp                                                                                                                            | 2.451508                                                                                                 | psi                                                                                                                                                                                                                                      |                                    |                               |                                                |                                                                                                                                                                                                                           |                                                                                                                                                                                                                           |                             |                             |                             |                             |                  |
| 21  | Synthetic Response Model                                                                                                                                             |                                                                                                          |                                                                                                                                                                                                                                          |                                    |                               |                                                |                                                                                                                                                                                                                           |                                                                                                                                                                                                                           |                             |                             |                             |                             |                  |
| 22  | Model permeability                                                                                                                                                   | 50                                                                                                       | mD                                                                                                                                                                                                                                       |                                    |                               |                                                |                                                                                                                                                                                                                           |                                                                                                                                                                                                                           |                             |                             |                             |                             |                  |
| 23  | Model porosity, φ                                                                                                                                                    | 0.2                                                                                                      | %                                                                                                                                                                                                                                        |                                    |                               |                                                |                                                                                                                                                                                                                           |                                                                                                                                                                                                                           |                             |                             |                             |                             |                  |
| 24  | Model total compressibility, ct                                                                                                                                      | 0.000015                                                                                                 | 1/psi                                                                                                                                                                                                                                    |                                    |                               |                                                |                                                                                                                                                                                                                           |                                                                                                                                                                                                                           |                             |                             |                             |                             |                  |
| 26  | Results                                                                                                                                                              |                                                                                                          |                                                                                                                                                                                                                                          |                                    |                               |                                                |                                                                                                                                                                                                                           |                                                                                                                                                                                                                           |                             |                             |                             |                             |                  |
| 27  | Model line-source coefficient, A = 70.6·qBμ/(kh)                                                                                                                     | =IT_cP*IT_q*IT_Bo*IT_mu/(IT_ModelK*IT_h)                                                                 | psi                                                                                                                                                                                                                                      |                                    |                               |                                                |                                                                                                                                                                                                                           |                                                                                                                                                                                                                           |                             |                             |                             |                             |                  |
| 28  | Points on the semilog line                                                                                                                                           | =COUNTIFS($A$85:$A$105,">="&IT_From)                                                                     | —                                                                                                                                                                                                                                        |                                    |                               |                                                |                                                                                                                                                                                                                           |                                                                                                                                                                                                                           |                             |                             |                             |                             |                  |
| 29  | Semilog slope, m                                                                                                                                                     | =SLOPE(FILTER($B$85:$B$105,$A$85:$A$105>=IT_From),LOG10(FILTER($A$85:$A$105,$A$85:$A$105>=IT_From)))     | psi/cycle                                                                                                                                                                                                                                |                                    |                               |                                                |                                                                                                                                                                                                                           |                                                                                                                                                                                                                           |                             |                             |                             |                             |                  |
| 30  | Semilog line's Δp at 1 hr                                                                                                                                            | =INTERCEPT(FILTER($B$85:$B$105,$A$85:$A$105>=IT_From),LOG10(FILTER($A$85:$A$105,$A$85:$A$105>=IT_From))) | psi                                                                                                                                                                                                                                      |                                    |                               |                                                |                                                                                                                                                                                                                           |                                                                                                                                                                                                                           |                             |                             |                             |                             |                  |
| 31  | Semilog k = 162.6·qBμ/(m·h)                                                                                                                                          | =PO.PTA.Horner.k(IT_M,IT_q,IT_Bo,IT_mu,IT_h)                                                             | mD                                                                                                                                                                                                                                       |                                    |                               |                                                |                                                                                                                                                                                                                           |                                                                                                                                                                                                                           |                             |                             |                             |                             |                  |
| 32  | Semilog constant, log₁₀(1/(4·0.0002637)) + γ/ln 10                                                                                                                   | =LOG10(1/IT_cX)+IT_Euler/LN(10)                                                                          | —                                                                                                                                                                                                                                        |                                    |                               |                                                |                                                                                                                                                                                                                           |                                                                                                                                                                                                                           |                             |                             |                             |                             |                  |
| 33  | Semilog φct = k/(μr²)·10^−(Δp1h/m + constant)                                                                                                                        | =IT_KSl/(IT_mu*IT_r^2)*10^(0-(IT_Dp1h/IT_M+IT_LsC))                                                      | 1/psi                                                                                                                                                                                                                                    |                                    |                               |                                                |                                                                                                                                                                                                                           |                                                                                                                                                                                                                           |                             |                             |                             |                             |                  |
| 34  | x at the line's first point                                                                                                                                          | =IT_PhictSl*IT_mu*IT_r^2/(IT_cX*IT_KSl*MINIFS($A$85:$A$105,$A$85:$A$105,">="&IT_From))                   | —                                                                                                                                                                                                                                        |                                    |                               |                                                |                                                                                                                                                                                                                           |                                                                                                                                                                                                                           |                             |                             |                             |                             |                  |
| 35  | Matched k (two-parameter match)                                                                                                                                      | =IT_cP*IT_q*IT_Bo*IT_mu/($B$67*IT_h)                                                                     | mD                                                                                                                                                                                                                                       |                                    |                               |                                                |                                                                                                                                                                                                                           |                                                                                                                                                                                                                           |                             |                             |                             |                             |                  |
| 36  | Matched kh                                                                                                                                                           | =IT_K*IT_h                                                                                               | mD·ft                                                                                                                                                                                                                                    |                                    |                               |                                                |                                                                                                                                                                                                                           |                                                                                                                                                                                                                           |                             |                             |                             |                             |                  |
| 37  | Matched φct                                                                                                                                                          | =$C$67*IT_cX*IT_K/(IT_mu*IT_r^2)                                                                         | 1/psi                                                                                                                                                                                                                                    |                                    |                               |                                                |                                                                                                                                                                                                                           |                                                                                                                                                                                                                           |                             |                             |                             |                             |                  |
| 38  | Match RMS misfit                                                                                                                                                     | =SQRT($F$67/ROWS($A$85:$A$105))                                                                          | psi                                                                                                                                                                                                                                      |                                    |                               |                                                |                                                                                                                                                                                                                           |                                                                                                                                                                                                                           |                             |                             |                             |                             |                  |
| 39  | Last pass's change in ln A and ln B                                                                                                                                  | =ABS($G$67)+ABS($H$67)                                                                                   | —                                                                                                                                                                                                                                        |                                    |                               |                                                |                                                                                                                                                                                                                           |                                                                                                                                                                                                                           |                             |                             |                             |                             |                  |
| 40  | Pulse-test k                                                                                                                                                         | =PO.PTA.Pulse.Analysis(IT_tL,IT_PDp,IT_dtC,IT_Fp,IT_n,IT_q,IT_Bo,IT_mu,IT_h,IT_r,"k")                    | mD                                                                                                                                                                                                                                       |                                    |                               |                                                |                                                                                                                                                                                                                           |                                                                                                                                                                                                                           |                             |                             |                             |                             |                  |
| 41  | Pulse-test φct                                                                                                                                                       | =PO.PTA.Pulse.Analysis(IT_tL,IT_PDp,IT_dtC,IT_Fp,IT_n,IT_q,IT_Bo,IT_mu,IT_h,IT_r,"phict")                | 1/psi                                                                                                                                                                                                                                    |                                    |                               |                                                |                                                                                                                                                                                                                           |                                                                                                                                                                                                                           |                             |                             |                             |                             |                  |
| 42  | Kamal-Brigham abscissa, (tL)D/rD²                                                                                                                                    | =PO.PTA.Pulse.Analysis(IT_tL,IT_PDp,IT_dtC,IT_Fp,IT_n,IT_q,IT_Bo,IT_mu,IT_h,IT_r,"tLD")                  | —                                                                                                                                                                                                                                        |                                    |                               |                                                |                                                                                                                                                                                                                           |                                                                                                                                                                                                                           |                             |                             |                             |                             |                  |
| 43  | Kamal-Brigham ordinate, ΔpD·(tL/ΔtC)²                                                                                                                                | =PO.PTA.Pulse.Analysis(IT_tL,IT_PDp,IT_dtC,IT_Fp,IT_n,IT_q,IT_Bo,IT_mu,IT_h,IT_r,"dpD")                  | —                                                                                                                                                                                                                                        |                                    |                               |                                                |                                                                                                                                                                                                                           |                                                                                                                                                                                                                           |                             |                             |                             |                             |                  |
| 44  | Model φct                                                                                                                                                            | =IT_phi*IT_ct                                                                                            | 1/psi                                                                                                                                                                                                                                    |                                    |                               |                                                |                                                                                                                                                                                                                           |                                                                                                                                                                                                                           |                             |                             |                             |                             |                  |
| 45  | Matched k against the model's                                                                                                                                        | =IT_K/IT_ModelK-1                                                                                        | %                                                                                                                                                                                                                                        |                                    |                               |                                                |                                                                                                                                                                                                                           |                                                                                                                                                                                                                           |                             |                             |                             |                             |                  |
| 46  | Matched φct against the model's                                                                                                                                      | =IT_Phict/IT_PhictModel-1                                                                                | %                                                                                                                                                                                                                                        |                                    |                               |                                                |                                                                                                                                                                                                                           |                                                                                                                                                                                                                           |                             |                             |                             |                             |                  |
| 47  | Semilog k against the match                                                                                                                                          | =IT_KSl/IT_K-1                                                                                           | %                                                                                                                                                                                                                                        |                                    |                               |                                                |                                                                                                                                                                                                                           |                                                                                                                                                                                                                           |                             |                             |                             |                             |                  |
| 48  | Pulse k against the match                                                                                                                                            | =IT_KPulse/IT_K-1                                                                                        | %                                                                                                                                                                                                                                        |                                    |                               |                                                |                                                                                                                                                                                                                           |                                                                                                                                                                                                                           |                             |                             |                             |                             |                  |
| 49  | Semilog validity check                                                                                                                                               | =IF(IT_XFrom<=IT_xMax,"PASS","WARN")                                                                     | =IF(IT_XFrom<=IT_xMax,"x is "&FIXED(IT_XFrom,2)&" at the line's first point, so −Ei(−x) is near its logarithm there","x is "&FIXED(IT_XFrom,2)&" at the line's first point: start the line later; the match does not need it")           |                                    |                               |                                                |                                                                                                                                                                                                                           |                                                                                                                                                                                                                           |                             |                             |                             |                             |                  |
| 50  | Match check                                                                                                                                                          | =IF(IT_Conv<=IT_ConvTol,"PASS","WARN")                                                                   | =IF(IT_Conv<=IT_ConvTol,"the match converged; RMS misfit "&FIXED(IT_Rms,2)&" psi, semilog k "&FIXED(IT_SlErr*100,1)&"% from it","the last pass still moved ln A and ln B by "&FIXED(IT_Conv,2)&": check the semilog start and the data") |                                    |                               |                                                |                                                                                                                                                                                                                           |                                                                                                                                                                                                                           |                             |                             |                             |                             |                  |
| 51  | Pulse against interference check                                                                                                                                     | =IF(ABS(IT_PulseErr)<=IT_KTol,"PASS","WARN")                                                             | =IF(ABS(IT_PulseErr)<=IT_KTol,"the pulse test's k is "&FIXED(IT_PulseErr*100,1)&"% from the match's","the pulse test's k is "&FIXED(IT_PulseErr*100,1)&"% from the match's: check the lag and amplitude readings")                       |                                    |                               |                                                |                                                                                                                                                                                                                           |                                                                                                                                                                                                                           |                             |                             |                             |                             |                  |
| 52  | Gauge resolution check                                                                                                                                               | =IF(IT_PDp>=10*IT_Res,"PASS","FAIL")                                                                     | =IF(IT_PDp>=10*IT_Res,"the pulse amplitude is "&FIXED(IT_PDp/IT_Res,0)&" times the gauge's resolution","the pulse amplitude is under ten times the gauge's resolution of "&FIXED(IT_Res,2)&" psi: it cannot be read")                    |                                    |                               |                                                |                                                                                                                                                                                                                           |                                                                                                                                                                                                                           |                             |                             |                             |                             |                  |
| 53  | Round trip on the synthetic data                                                                                                                                     | =IF(ABS(IT_KErr)<=IT_KTol,"PASS","WARN")                                                                 | =IF(ABS(IT_KErr)<=IT_KTol,"k is "&FIXED(IT_KErr*100,1)&"% and φct "&FIXED(ROUND(IT_PErr*100,1)+0,1)&"% from the model's (ignore for real data)","k is "&FIXED(IT_KErr*100,1)&"% from the model's (ignore for real data)")                |                                    |                               |                                                |                                                                                                                                                                                                                           |                                                                                                                                                                                                                           |                             |                             |                             |                             |                  |
| 55  | Calculation Constants                                                                                                                                                |                                                                                                          |                                                                                                                                                                                                                                          |                                    |                               |                                                |                                                                                                                                                                                                                           |                                                                                                                                                                                                                           |                             |                             |                             |                             |                  |
| 56  | Line-source pressure constant, 141.2/2                                                                                                                               | 70.6                                                                                                     | —                                                                                                                                                                                                                                        |                                    |                               |                                                |                                                                                                                                                                                                                           |                                                                                                                                                                                                                           |                             |                             |                             |                             |                  |
| 57  | Line-source time constant, 4 × 0.0002637                                                                                                                             | 0.0010548                                                                                                | —                                                                                                                                                                                                                                        |                                    |                               |                                                |                                                                                                                                                                                                                           |                                                                                                                                                                                                                           |                             |                             |                             |                             |                  |
| 58  | Euler's constant, γ                                                                                                                                                  | 0.5772156649                                                                                             | —                                                                                                                                                                                                                                        |                                    |                               |                                                |                                                                                                                                                                                                                           |                                                                                                                                                                                                                           |                             |                             |                             |                             |                  |
| 59  | Match converged when ln A and ln B move less than                                                                                                                    | 0.000001                                                                                                 | —                                                                                                                                                                                                                                        |                                    |                               |                                                |                                                                                                                                                                                                                           |                                                                                                                                                                                                                           |                             |                             |                             |                             |                  |
| 61  | Two-Parameter Match: Gauss-Newton Passes on Δp = A·E1(B/t)                                                                                                           |                                                                                                          |                                                                                                                                                                                                                                          |                                    |                               |                                                |                                                                                                                                                                                                                           |                                                                                                                                                                                                                           |                             |                             |                             |                             |                  |
| 62  | Pass (—)                                                                                                                                                             | A (psi)                                                                                                  | B (hr)                                                                                                                                                                                                                                   | k (mD)                             | φct (1/psi)                   | Misfit Σr² (—)                                 | Step ln A (—)                                                                                                                                                                                                             | Step ln B (—)                                                                                                                                                                                                             |                             |                             |                             |                             |                  |
| 63  | =0                                                                                                                                                                   | =IT_cP*IT_q*IT_Bo*IT_mu/(IT_KSl*IT_h)                                                                    | =IT_PhictSl*IT_mu*IT_r^2/(IT_cX*IT_KSl)                                                                                                                                                                                                  | =IT_cP*IT_q*IT_Bo*IT_mu/(B63*IT_h) | =C63*IT_cX*D63/(IT_mu*IT_r^2) | =SUMPRODUCT(($B$85:$B$105-B63*$H$85:$H$105)^2) | =LET(ja,B63*$H$85:$H$105,jb,0-B63*EXP(0-C63/$A$85:$A$105),rr,$B$85:$B$105-ja,saa,SUMPRODUCT(ja,ja),sbb,SUMPRODUCT(jb,jb),sab,SUMPRODUCT(ja,jb),ga,SUMPRODUCT(ja,rr),gb,SUMPRODUCT(jb,rr),(ga*sbb-gb*sab)/(saa*sbb-sab^2)) | =LET(ja,B63*$H$85:$H$105,jb,0-B63*EXP(0-C63/$A$85:$A$105),rr,$B$85:$B$105-ja,saa,SUMPRODUCT(ja,ja),sbb,SUMPRODUCT(jb,jb),sab,SUMPRODUCT(ja,jb),ga,SUMPRODUCT(ja,rr),gb,SUMPRODUCT(jb,rr),(saa*gb-sab*ga)/(saa*sbb-sab^2)) |                             |                             |                             |                             |                  |
| 64  | =A63+1                                                                                                                                                               | =B63*EXP(G63)                                                                                            | =C63*EXP(H63)                                                                                                                                                                                                                            | =IT_cP*IT_q*IT_Bo*IT_mu/(B64*IT_h) | =C64*IT_cX*D64/(IT_mu*IT_r^2) | =SUMPRODUCT(($B$85:$B$105-B64*$I$85:$I$105)^2) | =LET(ja,B64*$I$85:$I$105,jb,0-B64*EXP(0-C64/$A$85:$A$105),rr,$B$85:$B$105-ja,saa,SUMPRODUCT(ja,ja),sbb,SUMPRODUCT(jb,jb),sab,SUMPRODUCT(ja,jb),ga,SUMPRODUCT(ja,rr),gb,SUMPRODUCT(jb,rr),(ga*sbb-gb*sab)/(saa*sbb-sab^2)) | =LET(ja,B64*$I$85:$I$105,jb,0-B64*EXP(0-C64/$A$85:$A$105),rr,$B$85:$B$105-ja,saa,SUMPRODUCT(ja,ja),sbb,SUMPRODUCT(jb,jb),sab,SUMPRODUCT(ja,jb),ga,SUMPRODUCT(ja,rr),gb,SUMPRODUCT(jb,rr),(saa*gb-sab*ga)/(saa*sbb-sab^2)) |                             |                             |                             |                             |                  |
| 65  | =A64+1                                                                                                                                                               | =B64*EXP(G64)                                                                                            | =C64*EXP(H64)                                                                                                                                                                                                                            | =IT_cP*IT_q*IT_Bo*IT_mu/(B65*IT_h) | =C65*IT_cX*D65/(IT_mu*IT_r^2) | =SUMPRODUCT(($B$85:$B$105-B65*$J$85:$J$105)^2) | =LET(ja,B65*$J$85:$J$105,jb,0-B65*EXP(0-C65/$A$85:$A$105),rr,$B$85:$B$105-ja,saa,SUMPRODUCT(ja,ja),sbb,SUMPRODUCT(jb,jb),sab,SUMPRODUCT(ja,jb),ga,SUMPRODUCT(ja,rr),gb,SUMPRODUCT(jb,rr),(ga*sbb-gb*sab)/(saa*sbb-sab^2)) | =LET(ja,B65*$J$85:$J$105,jb,0-B65*EXP(0-C65/$A$85:$A$105),rr,$B$85:$B$105-ja,saa,SUMPRODUCT(ja,ja),sbb,SUMPRODUCT(jb,jb),sab,SUMPRODUCT(ja,jb),ga,SUMPRODUCT(ja,rr),gb,SUMPRODUCT(jb,rr),(saa*gb-sab*ga)/(saa*sbb-sab^2)) |                             |                             |                             |                             |                  |
| 66  | =A65+1                                                                                                                                                               | =B65*EXP(G65)                                                                                            | =C65*EXP(H65)                                                                                                                                                                                                                            | =IT_cP*IT_q*IT_Bo*IT_mu/(B66*IT_h) | =C66*IT_cX*D66/(IT_mu*IT_r^2) | =SUMPRODUCT(($B$85:$B$105-B66*$K$85:$K$105)^2) | =LET(ja,B66*$K$85:$K$105,jb,0-B66*EXP(0-C66/$A$85:$A$105),rr,$B$85:$B$105-ja,saa,SUMPRODUCT(ja,ja),sbb,SUMPRODUCT(jb,jb),sab,SUMPRODUCT(ja,jb),ga,SUMPRODUCT(ja,rr),gb,SUMPRODUCT(jb,rr),(ga*sbb-gb*sab)/(saa*sbb-sab^2)) | =LET(ja,B66*$K$85:$K$105,jb,0-B66*EXP(0-C66/$A$85:$A$105),rr,$B$85:$B$105-ja,saa,SUMPRODUCT(ja,ja),sbb,SUMPRODUCT(jb,jb),sab,SUMPRODUCT(ja,jb),ga,SUMPRODUCT(ja,rr),gb,SUMPRODUCT(jb,rr),(saa*gb-sab*ga)/(saa*sbb-sab^2)) |                             |                             |                             |                             |                  |
| 67  | =A66+1                                                                                                                                                               | =B66*EXP(G66)                                                                                            | =C66*EXP(H66)                                                                                                                                                                                                                            | =IT_cP*IT_q*IT_Bo*IT_mu/(B67*IT_h) | =C67*IT_cX*D67/(IT_mu*IT_r^2) | =SUMPRODUCT(($B$85:$B$105-B67*$L$85:$L$105)^2) | =LET(ja,B67*$L$85:$L$105,jb,0-B67*EXP(0-C67/$A$85:$A$105),rr,$B$85:$B$105-ja,saa,SUMPRODUCT(ja,ja),sbb,SUMPRODUCT(jb,jb),sab,SUMPRODUCT(ja,jb),ga,SUMPRODUCT(ja,rr),gb,SUMPRODUCT(jb,rr),(ga*sbb-gb*sab)/(saa*sbb-sab^2)) | =LET(ja,B67*$L$85:$L$105,jb,0-B67*EXP(0-C67/$A$85:$A$105),rr,$B$85:$B$105-ja,saa,SUMPRODUCT(ja,ja),sbb,SUMPRODUCT(jb,jb),sab,SUMPRODUCT(ja,jb),ga,SUMPRODUCT(ja,rr),gb,SUMPRODUCT(jb,rr),(saa*gb-sab*ga)/(saa*sbb-sab^2)) |                             |                             |                             |                             |                  |
| 69  | Late-Time Semilog Line                                                                                                                                               |                                                                                                          |                                                                                                                                                                                                                                          |                                    |                               |                                                |                                                                                                                                                                                                                           |                                                                                                                                                                                                                           |                             |                             |                             |                             |                  |
| 70  | t (hr)                                                                                                                                                               | Semilog line (psi)                                                                                       |                                                                                                                                                                                                                                          |                                    |                               |                                                |                                                                                                                                                                                                                           |                                                                                                                                                                                                                           |                             |                             |                             |                             |                  |
| 71  | =10^(0-IT_Dp1h/IT_M)*(MAX($A$85:$A$105)/10^(0-IT_Dp1h/IT_M))^(0/8)                                                                                                   | =IT_Dp1h+IT_M*LOG10(A71)                                                                                 |                                                                                                                                                                                                                                          |                                    |                               |                                                |                                                                                                                                                                                                                           |                                                                                                                                                                                                                           |                             |                             |                             |                             |                  |
| 72  | =10^(0-IT_Dp1h/IT_M)*(MAX($A$85:$A$105)/10^(0-IT_Dp1h/IT_M))^(1/8)                                                                                                   | =IT_Dp1h+IT_M*LOG10(A72)                                                                                 |                                                                                                                                                                                                                                          |                                    |                               |                                                |                                                                                                                                                                                                                           |                                                                                                                                                                                                                           |                             |                             |                             |                             |                  |
| 73  | =10^(0-IT_Dp1h/IT_M)*(MAX($A$85:$A$105)/10^(0-IT_Dp1h/IT_M))^(2/8)                                                                                                   | =IT_Dp1h+IT_M*LOG10(A73)                                                                                 |                                                                                                                                                                                                                                          |                                    |                               |                                                |                                                                                                                                                                                                                           |                                                                                                                                                                                                                           |                             |                             |                             |                             |                  |
| 74  | =10^(0-IT_Dp1h/IT_M)*(MAX($A$85:$A$105)/10^(0-IT_Dp1h/IT_M))^(3/8)                                                                                                   | =IT_Dp1h+IT_M*LOG10(A74)                                                                                 |                                                                                                                                                                                                                                          |                                    |                               |                                                |                                                                                                                                                                                                                           |                                                                                                                                                                                                                           |                             |                             |                             |                             |                  |
| 75  | =10^(0-IT_Dp1h/IT_M)*(MAX($A$85:$A$105)/10^(0-IT_Dp1h/IT_M))^(4/8)                                                                                                   | =IT_Dp1h+IT_M*LOG10(A75)                                                                                 |                                                                                                                                                                                                                                          |                                    |                               |                                                |                                                                                                                                                                                                                           |                                                                                                                                                                                                                           |                             |                             |                             |                             |                  |
| 76  | =10^(0-IT_Dp1h/IT_M)*(MAX($A$85:$A$105)/10^(0-IT_Dp1h/IT_M))^(5/8)                                                                                                   | =IT_Dp1h+IT_M*LOG10(A76)                                                                                 |                                                                                                                                                                                                                                          |                                    |                               |                                                |                                                                                                                                                                                                                           |                                                                                                                                                                                                                           |                             |                             |                             |                             |                  |
| 77  | =10^(0-IT_Dp1h/IT_M)*(MAX($A$85:$A$105)/10^(0-IT_Dp1h/IT_M))^(6/8)                                                                                                   | =IT_Dp1h+IT_M*LOG10(A77)                                                                                 |                                                                                                                                                                                                                                          |                                    |                               |                                                |                                                                                                                                                                                                                           |                                                                                                                                                                                                                           |                             |                             |                             |                             |                  |
| 78  | =10^(0-IT_Dp1h/IT_M)*(MAX($A$85:$A$105)/10^(0-IT_Dp1h/IT_M))^(7/8)                                                                                                   | =IT_Dp1h+IT_M*LOG10(A78)                                                                                 |                                                                                                                                                                                                                                          |                                    |                               |                                                |                                                                                                                                                                                                                           |                                                                                                                                                                                                                           |                             |                             |                             |                             |                  |
| 79  | =10^(0-IT_Dp1h/IT_M)*(MAX($A$85:$A$105)/10^(0-IT_Dp1h/IT_M))^(8/8)                                                                                                   | =IT_Dp1h+IT_M*LOG10(A79)                                                                                 |                                                                                                                                                                                                                                          |                                    |                               |                                                |                                                                                                                                                                                                                           |                                                                                                                                                                                                                           |                             |                             |                             |                             |                  |
| 81  | Observation-Well Data, the Line Source and the Match                                                                                                                 |                                                                                                          |                                                                                                                                                                                                                                          |                                    |                               |                                                |                                                                                                                                                                                                                           |                                                                                                                                                                                                                           |                             |                             |                             |                             |                  |
| 82  | How to use it: paste the times since the active well opened and Δp = pi − p at the observation well over columns A and B (trim or extend the formulas to your rows). |                                                                                                          |                                                                                                                                                                                                                                          |                                    |                               |                                                |                                                                                                                                                                                                                           |                                                                                                                                                                                                                           |                             |                             |                             |                             |                  |
| 83  | Columns C to F are the synthetic model: x, −Ei(−x), the line-source Δp and its semilog approximation −A·(ln x + γ).                                                  |                                                                                                          |                                                                                                                                                                                                                                          |                                    |                               |                                                |                                                                                                                                                                                                                           |                                                                                                                                                                                                                           |                             |                             |                             |                             |                  |
| 84  | t (hr)                                                                                                                                                               | Δp (psi)                                                                                                 | x                                                                                                                                                                                                                                        | −Ei(−x)                            | Model Δp (psi)                | Semilog approx. (psi)                          | Derivative (psi)                                                                                                                                                                                                          | E1, pass 0                                                                                                                                                                                                                | E1, pass 1                  | E1, pass 2                  | E1, pass 3                  | E1, pass 4                  | Matched Δp (psi) |
| 85  | 1                                                                                                                                                                    | =E85                                                                                                     | =IT_phi*IT_ct*IT_mu*IT_r^2/(IT_cX*IT_ModelK*A85)                                                                                                                                                                                         | =0-PO.Math.Ei(0-C85)               | =IT_AModel*D85                | =IT_AModel*(0-LN(C85)-IT_Euler)                | =PO.DCA.Diag.Bourdet.SemiLog($A$85:$A$105,$B$85:$B$105,A85,IT_L)                                                                                                                                                          | =0-PO.Math.Ei(0-$C$63/A85)                                                                                                                                                                                                | =0-PO.Math.Ei(0-$C$64/A85)  | =0-PO.Math.Ei(0-$C$65/A85)  | =0-PO.Math.Ei(0-$C$66/A85)  | =0-PO.Math.Ei(0-$C$67/A85)  | =$B$67*L85       |
| 86  | 1.33                                                                                                                                                                 | =E86                                                                                                     | =IT_phi*IT_ct*IT_mu*IT_r^2/(IT_cX*IT_ModelK*A86)                                                                                                                                                                                         | =0-PO.Math.Ei(0-C86)               | =IT_AModel*D86                | =IT_AModel*(0-LN(C86)-IT_Euler)                | =PO.DCA.Diag.Bourdet.SemiLog($A$85:$A$105,$B$85:$B$105,A86,IT_L)                                                                                                                                                          | =0-PO.Math.Ei(0-$C$63/A86)                                                                                                                                                                                                | =0-PO.Math.Ei(0-$C$64/A86)  | =0-PO.Math.Ei(0-$C$65/A86)  | =0-PO.Math.Ei(0-$C$66/A86)  | =0-PO.Math.Ei(0-$C$67/A86)  | =$B$67*L86       |
| 87  | 1.78                                                                                                                                                                 | =E87                                                                                                     | =IT_phi*IT_ct*IT_mu*IT_r^2/(IT_cX*IT_ModelK*A87)                                                                                                                                                                                         | =0-PO.Math.Ei(0-C87)               | =IT_AModel*D87                | =IT_AModel*(0-LN(C87)-IT_Euler)                | =PO.DCA.Diag.Bourdet.SemiLog($A$85:$A$105,$B$85:$B$105,A87,IT_L)                                                                                                                                                          | =0-PO.Math.Ei(0-$C$63/A87)                                                                                                                                                                                                | =0-PO.Math.Ei(0-$C$64/A87)  | =0-PO.Math.Ei(0-$C$65/A87)  | =0-PO.Math.Ei(0-$C$66/A87)  | =0-PO.Math.Ei(0-$C$67/A87)  | =$B$67*L87       |
| 88  | 2.37                                                                                                                                                                 | =E88                                                                                                     | =IT_phi*IT_ct*IT_mu*IT_r^2/(IT_cX*IT_ModelK*A88)                                                                                                                                                                                         | =0-PO.Math.Ei(0-C88)               | =IT_AModel*D88                | =IT_AModel*(0-LN(C88)-IT_Euler)                | =PO.DCA.Diag.Bourdet.SemiLog($A$85:$A$105,$B$85:$B$105,A88,IT_L)                                                                                                                                                          | =0-PO.Math.Ei(0-$C$63/A88)                                                                                                                                                                                                | =0-PO.Math.Ei(0-$C$64/A88)  | =0-PO.Math.Ei(0-$C$65/A88)  | =0-PO.Math.Ei(0-$C$66/A88)  | =0-PO.Math.Ei(0-$C$67/A88)  | =$B$67*L88       |
| 89  | 3.16                                                                                                                                                                 | =E89                                                                                                     | =IT_phi*IT_ct*IT_mu*IT_r^2/(IT_cX*IT_ModelK*A89)                                                                                                                                                                                         | =0-PO.Math.Ei(0-C89)               | =IT_AModel*D89                | =IT_AModel*(0-LN(C89)-IT_Euler)                | =PO.DCA.Diag.Bourdet.SemiLog($A$85:$A$105,$B$85:$B$105,A89,IT_L)                                                                                                                                                          | =0-PO.Math.Ei(0-$C$63/A89)                                                                                                                                                                                                | =0-PO.Math.Ei(0-$C$64/A89)  | =0-PO.Math.Ei(0-$C$65/A89)  | =0-PO.Math.Ei(0-$C$66/A89)  | =0-PO.Math.Ei(0-$C$67/A89)  | =$B$67*L89       |
| 90  | 4.22                                                                                                                                                                 | =E90                                                                                                     | =IT_phi*IT_ct*IT_mu*IT_r^2/(IT_cX*IT_ModelK*A90)                                                                                                                                                                                         | =0-PO.Math.Ei(0-C90)               | =IT_AModel*D90                | =IT_AModel*(0-LN(C90)-IT_Euler)                | =PO.DCA.Diag.Bourdet.SemiLog($A$85:$A$105,$B$85:$B$105,A90,IT_L)                                                                                                                                                          | =0-PO.Math.Ei(0-$C$63/A90)                                                                                                                                                                                                | =0-PO.Math.Ei(0-$C$64/A90)  | =0-PO.Math.Ei(0-$C$65/A90)  | =0-PO.Math.Ei(0-$C$66/A90)  | =0-PO.Math.Ei(0-$C$67/A90)  | =$B$67*L90       |
| 91  | 5.62                                                                                                                                                                 | =E91                                                                                                     | =IT_phi*IT_ct*IT_mu*IT_r^2/(IT_cX*IT_ModelK*A91)                                                                                                                                                                                         | =0-PO.Math.Ei(0-C91)               | =IT_AModel*D91                | =IT_AModel*(0-LN(C91)-IT_Euler)                | =PO.DCA.Diag.Bourdet.SemiLog($A$85:$A$105,$B$85:$B$105,A91,IT_L)                                                                                                                                                          | =0-PO.Math.Ei(0-$C$63/A91)                                                                                                                                                                                                | =0-PO.Math.Ei(0-$C$64/A91)  | =0-PO.Math.Ei(0-$C$65/A91)  | =0-PO.Math.Ei(0-$C$66/A91)  | =0-PO.Math.Ei(0-$C$67/A91)  | =$B$67*L91       |
| 92  | 7.5                                                                                                                                                                  | =E92                                                                                                     | =IT_phi*IT_ct*IT_mu*IT_r^2/(IT_cX*IT_ModelK*A92)                                                                                                                                                                                         | =0-PO.Math.Ei(0-C92)               | =IT_AModel*D92                | =IT_AModel*(0-LN(C92)-IT_Euler)                | =PO.DCA.Diag.Bourdet.SemiLog($A$85:$A$105,$B$85:$B$105,A92,IT_L)                                                                                                                                                          | =0-PO.Math.Ei(0-$C$63/A92)                                                                                                                                                                                                | =0-PO.Math.Ei(0-$C$64/A92)  | =0-PO.Math.Ei(0-$C$65/A92)  | =0-PO.Math.Ei(0-$C$66/A92)  | =0-PO.Math.Ei(0-$C$67/A92)  | =$B$67*L92       |
| 93  | 10                                                                                                                                                                   | =E93                                                                                                     | =IT_phi*IT_ct*IT_mu*IT_r^2/(IT_cX*IT_ModelK*A93)                                                                                                                                                                                         | =0-PO.Math.Ei(0-C93)               | =IT_AModel*D93                | =IT_AModel*(0-LN(C93)-IT_Euler)                | =PO.DCA.Diag.Bourdet.SemiLog($A$85:$A$105,$B$85:$B$105,A93,IT_L)                                                                                                                                                          | =0-PO.Math.Ei(0-$C$63/A93)                                                                                                                                                                                                | =0-PO.Math.Ei(0-$C$64/A93)  | =0-PO.Math.Ei(0-$C$65/A93)  | =0-PO.Math.Ei(0-$C$66/A93)  | =0-PO.Math.Ei(0-$C$67/A93)  | =$B$67*L93       |
| 94  | 13.3                                                                                                                                                                 | =E94                                                                                                     | =IT_phi*IT_ct*IT_mu*IT_r^2/(IT_cX*IT_ModelK*A94)                                                                                                                                                                                         | =0-PO.Math.Ei(0-C94)               | =IT_AModel*D94                | =IT_AModel*(0-LN(C94)-IT_Euler)                | =PO.DCA.Diag.Bourdet.SemiLog($A$85:$A$105,$B$85:$B$105,A94,IT_L)                                                                                                                                                          | =0-PO.Math.Ei(0-$C$63/A94)                                                                                                                                                                                                | =0-PO.Math.Ei(0-$C$64/A94)  | =0-PO.Math.Ei(0-$C$65/A94)  | =0-PO.Math.Ei(0-$C$66/A94)  | =0-PO.Math.Ei(0-$C$67/A94)  | =$B$67*L94       |
| 95  | 17.8                                                                                                                                                                 | =E95                                                                                                     | =IT_phi*IT_ct*IT_mu*IT_r^2/(IT_cX*IT_ModelK*A95)                                                                                                                                                                                         | =0-PO.Math.Ei(0-C95)               | =IT_AModel*D95                | =IT_AModel*(0-LN(C95)-IT_Euler)                | =PO.DCA.Diag.Bourdet.SemiLog($A$85:$A$105,$B$85:$B$105,A95,IT_L)                                                                                                                                                          | =0-PO.Math.Ei(0-$C$63/A95)                                                                                                                                                                                                | =0-PO.Math.Ei(0-$C$64/A95)  | =0-PO.Math.Ei(0-$C$65/A95)  | =0-PO.Math.Ei(0-$C$66/A95)  | =0-PO.Math.Ei(0-$C$67/A95)  | =$B$67*L95       |
| 96  | 23.7                                                                                                                                                                 | =E96                                                                                                     | =IT_phi*IT_ct*IT_mu*IT_r^2/(IT_cX*IT_ModelK*A96)                                                                                                                                                                                         | =0-PO.Math.Ei(0-C96)               | =IT_AModel*D96                | =IT_AModel*(0-LN(C96)-IT_Euler)                | =PO.DCA.Diag.Bourdet.SemiLog($A$85:$A$105,$B$85:$B$105,A96,IT_L)                                                                                                                                                          | =0-PO.Math.Ei(0-$C$63/A96)                                                                                                                                                                                                | =0-PO.Math.Ei(0-$C$64/A96)  | =0-PO.Math.Ei(0-$C$65/A96)  | =0-PO.Math.Ei(0-$C$66/A96)  | =0-PO.Math.Ei(0-$C$67/A96)  | =$B$67*L96       |
| 97  | 31.6                                                                                                                                                                 | =E97                                                                                                     | =IT_phi*IT_ct*IT_mu*IT_r^2/(IT_cX*IT_ModelK*A97)                                                                                                                                                                                         | =0-PO.Math.Ei(0-C97)               | =IT_AModel*D97                | =IT_AModel*(0-LN(C97)-IT_Euler)                | =PO.DCA.Diag.Bourdet.SemiLog($A$85:$A$105,$B$85:$B$105,A97,IT_L)                                                                                                                                                          | =0-PO.Math.Ei(0-$C$63/A97)                                                                                                                                                                                                | =0-PO.Math.Ei(0-$C$64/A97)  | =0-PO.Math.Ei(0-$C$65/A97)  | =0-PO.Math.Ei(0-$C$66/A97)  | =0-PO.Math.Ei(0-$C$67/A97)  | =$B$67*L97       |
| 98  | 42.2                                                                                                                                                                 | =E98                                                                                                     | =IT_phi*IT_ct*IT_mu*IT_r^2/(IT_cX*IT_ModelK*A98)                                                                                                                                                                                         | =0-PO.Math.Ei(0-C98)               | =IT_AModel*D98                | =IT_AModel*(0-LN(C98)-IT_Euler)                | =PO.DCA.Diag.Bourdet.SemiLog($A$85:$A$105,$B$85:$B$105,A98,IT_L)                                                                                                                                                          | =0-PO.Math.Ei(0-$C$63/A98)                                                                                                                                                                                                | =0-PO.Math.Ei(0-$C$64/A98)  | =0-PO.Math.Ei(0-$C$65/A98)  | =0-PO.Math.Ei(0-$C$66/A98)  | =0-PO.Math.Ei(0-$C$67/A98)  | =$B$67*L98       |
| 99  | 56.2                                                                                                                                                                 | =E99                                                                                                     | =IT_phi*IT_ct*IT_mu*IT_r^2/(IT_cX*IT_ModelK*A99)                                                                                                                                                                                         | =0-PO.Math.Ei(0-C99)               | =IT_AModel*D99                | =IT_AModel*(0-LN(C99)-IT_Euler)                | =PO.DCA.Diag.Bourdet.SemiLog($A$85:$A$105,$B$85:$B$105,A99,IT_L)                                                                                                                                                          | =0-PO.Math.Ei(0-$C$63/A99)                                                                                                                                                                                                | =0-PO.Math.Ei(0-$C$64/A99)  | =0-PO.Math.Ei(0-$C$65/A99)  | =0-PO.Math.Ei(0-$C$66/A99)  | =0-PO.Math.Ei(0-$C$67/A99)  | =$B$67*L99       |
| 100 | 75                                                                                                                                                                   | =E100                                                                                                    | =IT_phi*IT_ct*IT_mu*IT_r^2/(IT_cX*IT_ModelK*A100)                                                                                                                                                                                        | =0-PO.Math.Ei(0-C100)              | =IT_AModel*D100               | =IT_AModel*(0-LN(C100)-IT_Euler)               | =PO.DCA.Diag.Bourdet.SemiLog($A$85:$A$105,$B$85:$B$105,A100,IT_L)                                                                                                                                                         | =0-PO.Math.Ei(0-$C$63/A100)                                                                                                                                                                                               | =0-PO.Math.Ei(0-$C$64/A100) | =0-PO.Math.Ei(0-$C$65/A100) | =0-PO.Math.Ei(0-$C$66/A100) | =0-PO.Math.Ei(0-$C$67/A100) | =$B$67*L100      |
| 101 | 100                                                                                                                                                                  | =E101                                                                                                    | =IT_phi*IT_ct*IT_mu*IT_r^2/(IT_cX*IT_ModelK*A101)                                                                                                                                                                                        | =0-PO.Math.Ei(0-C101)              | =IT_AModel*D101               | =IT_AModel*(0-LN(C101)-IT_Euler)               | =PO.DCA.Diag.Bourdet.SemiLog($A$85:$A$105,$B$85:$B$105,A101,IT_L)                                                                                                                                                         | =0-PO.Math.Ei(0-$C$63/A101)                                                                                                                                                                                               | =0-PO.Math.Ei(0-$C$64/A101) | =0-PO.Math.Ei(0-$C$65/A101) | =0-PO.Math.Ei(0-$C$66/A101) | =0-PO.Math.Ei(0-$C$67/A101) | =$B$67*L101      |
| 102 | 133                                                                                                                                                                  | =E102                                                                                                    | =IT_phi*IT_ct*IT_mu*IT_r^2/(IT_cX*IT_ModelK*A102)                                                                                                                                                                                        | =0-PO.Math.Ei(0-C102)              | =IT_AModel*D102               | =IT_AModel*(0-LN(C102)-IT_Euler)               | =PO.DCA.Diag.Bourdet.SemiLog($A$85:$A$105,$B$85:$B$105,A102,IT_L)                                                                                                                                                         | =0-PO.Math.Ei(0-$C$63/A102)                                                                                                                                                                                               | =0-PO.Math.Ei(0-$C$64/A102) | =0-PO.Math.Ei(0-$C$65/A102) | =0-PO.Math.Ei(0-$C$66/A102) | =0-PO.Math.Ei(0-$C$67/A102) | =$B$67*L102      |
| 103 | 178                                                                                                                                                                  | =E103                                                                                                    | =IT_phi*IT_ct*IT_mu*IT_r^2/(IT_cX*IT_ModelK*A103)                                                                                                                                                                                        | =0-PO.Math.Ei(0-C103)              | =IT_AModel*D103               | =IT_AModel*(0-LN(C103)-IT_Euler)               | =PO.DCA.Diag.Bourdet.SemiLog($A$85:$A$105,$B$85:$B$105,A103,IT_L)                                                                                                                                                         | =0-PO.Math.Ei(0-$C$63/A103)                                                                                                                                                                                               | =0-PO.Math.Ei(0-$C$64/A103) | =0-PO.Math.Ei(0-$C$65/A103) | =0-PO.Math.Ei(0-$C$66/A103) | =0-PO.Math.Ei(0-$C$67/A103) | =$B$67*L103      |
| 104 | 237                                                                                                                                                                  | =E104                                                                                                    | =IT_phi*IT_ct*IT_mu*IT_r^2/(IT_cX*IT_ModelK*A104)                                                                                                                                                                                        | =0-PO.Math.Ei(0-C104)              | =IT_AModel*D104               | =IT_AModel*(0-LN(C104)-IT_Euler)               | =PO.DCA.Diag.Bourdet.SemiLog($A$85:$A$105,$B$85:$B$105,A104,IT_L)                                                                                                                                                         | =0-PO.Math.Ei(0-$C$63/A104)                                                                                                                                                                                               | =0-PO.Math.Ei(0-$C$64/A104) | =0-PO.Math.Ei(0-$C$65/A104) | =0-PO.Math.Ei(0-$C$66/A104) | =0-PO.Math.Ei(0-$C$67/A104) | =$B$67*L104      |
| 105 | 316                                                                                                                                                                  | =E105                                                                                                    | =IT_phi*IT_ct*IT_mu*IT_r^2/(IT_cX*IT_ModelK*A105)                                                                                                                                                                                        | =0-PO.Math.Ei(0-C105)              | =IT_AModel*D105               | =IT_AModel*(0-LN(C105)-IT_Euler)               | =PO.DCA.Diag.Bourdet.SemiLog($A$85:$A$105,$B$85:$B$105,A105,IT_L)                                                                                                                                                         | =0-PO.Math.Ei(0-$C$63/A105)                                                                                                                                                                                               | =0-PO.Math.Ei(0-$C$64/A105) | =0-PO.Math.Ei(0-$C$65/A105) | =0-PO.Math.Ei(0-$C$66/A105) | =0-PO.Math.Ei(0-$C$67/A105) | =$B$67*L105      |

## Lambdas

| Name | RefersTo | Comment |
|------|----------|---------|
| PO.PTA.Pulse.Analysis | =LAMBDA(tL, dp, dtC, Fp, n, q, B, mu, h, robs, output, IF(OR(n<2, n<>ROUND(n, 0), Fp<=0, Fp>=1, tL<=0, dp<=0, dtC<=0), NA(), LET(lam, tL/dtC, nn, 600, jc, SEQUENCE(n+2, 1, 0), xs, jc/2+(Fp-0.5)*(1-(-1)^jc)/2, sgc, (-1)^jc, sgn, (-1)^(n+1), xepv, (n-1)/2+(Fp-0.5)*(1-(-1)^(n-1))/2, xen, n/2+(Fp-0.5)*(1-(-1)^n)/2, xenx, (n+1)/2+(Fp-0.5)*(1-(-1)^(n+1))/2, xenn, (n+2)/2+(Fp-0.5)*(1-(-1)^(n+2))/2, ig, SEQUENCE(nn+1, 1, 0), wz, xenx-xen, dz, xen+wz*ig/nn-TRANSPOSE(xs), pos, (dz>0)*1, dzc, pos*dz+1-pos, lgc, REDUCE(-9, SEQUENCE(121), LAMBDA(acc, i, IF(acc>-9, acc, LET(aa, 10^(-3.05+0.05*i), dv, MMULT(pos*EXP(-aa/(4*dzc))/dzc, sgc), cnt, SUM((dv*sgn>0)*1), da, SUM((ig=cnt-1)*dv), db, SUM((ig=cnt)*dv), lagx, IF(OR(cnt=0, cnt>nn), 2, wz*(cnt-1+da/(da-db))/nn), IF(lagx>=lam, -3.05+0.05*i, -9))))), lg, REDUCE(lgc-0.05, SEQUENCE(30), LAMBDA(acc, i, LET(aa, 10^(acc+0.05/2^i), dv, MMULT(pos*EXP(-aa/(4*dzc))/dzc, sgc), cnt, SUM((dv*sgn>0)*1), da, SUM((ig=cnt-1)*dv), db, SUM((ig=cnt)*dv), lagx, IF(OR(cnt=0, cnt>nn), 2, wz*(cnt-1+da/(da-db))/nn), acc+IF(lagx<lam, 0.05/2^i, 0)))), la, 10^lg, lagf, LET(aa, la, dv, MMULT(pos*EXP(-aa/(4*dzc))/dzc, sgc), cnt, SUM((dv*sgn>0)*1), da, SUM((ig=cnt-1)*dv), db, SUM((ig=cnt)*dv), lagx, IF(OR(cnt=0, cnt>nn), 2, wz*(cnt-1+da/(da-db))/nn), lagx), ik, SEQUENCE(2*nn+1), inw, (ik<=nn)*1, inx, (ik>nn)*(ik<=2*nn), atc, (ik>2*nn)*1, gx, inw*(xepv+(xen-xepv)*ik/nn)+inx*(xenx+(xenn-xenx)*(ik-nn)/nn)+atc*(xen+lam), dx, gx-TRANSPOSE(xs), px, (dx>0)*1, zx, la/(4*(px*dx+1-px)), lo, (zx<=1)*1, eone, lo*(-LN(zx)-0.57721566+zx*(0.99999193+zx*(-0.24991055+zx*(0.05519968+zx*(-0.00976004+zx*0.00107857)))))+(1-lo)*EXP(0-zx)/zx*(zx^4+8.5733287401*zx^3+18.059016973*zx^2+8.6347608925*zx+0.2677737343)/(zx^4+9.5733223454*zx^3+25.6329561486*zx^2+21.0996530827*zx+3.9584969228), pdx, MMULT(px*eone, sgc)/2, big, 10^300, sl, REDUCE(0, SEQUENCE(60), LAMBDA(acc, i, LET(v, sgn*(pdx-acc*gx), f, MIN(v+(1-inw)*big)-MIN(v+(1-inx)*big), acc+IF(sgn*f<0, 1, -1)*100/2^i))), base, sgn*MIN(sgn*(pdx-sl*gx)+(1-inw)*big), ad, ABS(SUM(atc*pdx)-base-sl*(xen+lam)), perm, 141.2*q*B*mu*ad/(h*dp), IF(OR(lgc<-2.99, ABS(lagf-lam)>0.0001*lam), NA(), IF(output="k", perm, IF(output="phict", 0.0002637*perm*la*dtC/(mu*robs^2), IF(output="tLD", lam/la, IF(output="dpD", ad*lam^2, NA())))))))) | Kamal-Brigham pulse test from the time lag and amplitude of pulse n (≥ 2) on the line-source response; output "k" [md], "phict" [1/psi], "tLD" (tL)D/rD² or "dpD" ΔpD·(tL/ΔtC)², the chart ordinates. |

## Names

| Name | RefersTo | Comment |
|------|----------|---------|
| IT_q | $B$4 | Active well's rate, q, STB/d |
| IT_Bo | $B$5 | Oil formation volume factor, Bo, bbl/STB |
| IT_mu | $B$6 | Oil viscosity, μ, cp |
| IT_h | $B$7 | Net pay, h, ft |
| IT_r | $B$8 | Distance to the observation well, r, ft |
| IT_From | $B$10 | Semilog line over the points from t, hr |
| IT_xMax | $B$11 | Semilog line valid while x at its start is ≤ |
| IT_L | $B$12 | Bourdet smoothing window, L, cycles |
| IT_Res | $B$13 | Gauge resolution, psi |
| IT_KTol | $B$14 | Round trip and pulse: k agrees within ±, % |
| IT_dtC | $B$16 | Cycle length, ΔtC (one flow and one shut-in), hr |
| IT_Fp | $B$17 | Pulse ratio, F′ = flowing period / cycle |
| IT_n | $B$18 | Pulse read, n (2 or more; odd flows, even shut-ins) |
| IT_tL | $B$19 | Time lag from the end of pulse n, tL, hr |
| IT_PDp | $B$20 | Pulse amplitude from the tangent line, Δp, psi |
| IT_ModelK | $B$22 | Model permeability, mD |
| IT_phi | $B$23 | Model porosity, φ, % |
| IT_ct | $B$24 | Model total compressibility, ct, 1/psi |
| IT_Inputs | $B$4:$B$24 | The active well's rate, the fluid, h and the well spacing, the semilog window, the gauge, the pulse readings and the synthetic model |
| IT_AModel | $B$27 | Model line-source coefficient, A = 70.6·qBμ/(kh), psi |
| IT_NSl | $B$28 | Points on the semilog line |
| IT_M | $B$29 | Semilog slope, m, psi/cycle |
| IT_Dp1h | $B$30 | Semilog line's Δp at 1 hr, psi |
| IT_KSl | $B$31 | Semilog k = 162.6·qBμ/(m·h), mD |
| IT_LsC | $B$32 | Semilog constant, log₁₀(1/(4·0.0002637)) + γ/ln 10 |
| IT_PhictSl | $B$33 | Semilog φct = k/(μr²)·10^−(Δp1h/m + constant), 1/psi |
| IT_XFrom | $B$34 | x at the line's first point |
| IT_K | $B$35 | Matched k (two-parameter match), mD |
| IT_Kh | $B$36 | Matched kh, mD·ft |
| IT_Phict | $B$37 | Matched φct, 1/psi |
| IT_Rms | $B$38 | Match RMS misfit, psi |
| IT_Conv | $B$39 | Last pass's change in ln A and ln B |
| IT_KPulse | $B$40 | Pulse-test k, mD |
| IT_PhictPulse | $B$41 | Pulse-test φct, 1/psi |
| IT_TLD | $B$42 | Kamal-Brigham abscissa, (tL)D/rD² |
| IT_DpD | $B$43 | Kamal-Brigham ordinate, ΔpD·(tL/ΔtC)² |
| IT_PhictModel | $B$44 | Model φct, 1/psi |
| IT_KErr | $B$45 | Matched k against the model's, % |
| IT_PErr | $B$46 | Matched φct against the model's, % |
| IT_SlErr | $B$47 | Semilog k against the match, % |
| IT_PulseErr | $B$48 | Pulse k against the match, % |
| IT_SemilogCheck | $B$49 | Semilog validity check verdict |
| IT_SemilogCheckNote | $C$49 | Semilog validity check comment |
| IT_MatchCheck | $B$50 | Match check verdict |
| IT_MatchCheckNote | $C$50 | Match check comment |
| IT_PulseCheck | $B$51 | Pulse against interference check verdict |
| IT_PulseCheckNote | $C$51 | Pulse against interference check comment |
| IT_GaugeCheck | $B$52 | Gauge resolution check verdict |
| IT_GaugeCheckNote | $C$52 | Gauge resolution check comment |
| IT_TripCheck | $B$53 | Round trip on the synthetic data verdict |
| IT_TripCheckNote | $C$53 | Round trip on the synthetic data comment |
| IT_Results | $B$27:$B$53 | The semilog line, k and φct from it, the match's k, kh and φct, the pulse test's k and φct, the round trip and the checks |
| IT_cP | $B$56 | Line-source pressure constant, 141.2/2 |
| IT_cX | $B$57 | Line-source time constant, 4 × 0.0002637 |
| IT_Euler | $B$58 | Euler's constant, γ |
| IT_ConvTol | $B$59 | Match converged when ln A and ln B move less than |
| IT_Passes | $A$63:$H$67 | The match's passes: A and B, the k and φct they give, the misfit and the Gauss-Newton step |
| IT_Data | $A$85:$B$105 | Time and the observation well's Δp (the synthetic model's until you paste a gauge's) |
| IT_Analysis | $C$85:$M$105 | Per row: the model's x, −Ei(−x), Δp and semilog approximation, the Bourdet derivative, the E1 column of each match pass, and the matched Δp |
| IT_Curve | $A$85:$M$105 | Observation-Well Response, Semilog |

---

## Related Blueprints
- [Injection Falloff and Step-Rate Test](/blueprint/po.pta.injection.falloff.md)
- [Multi-Rate Drawdown (Odeh-Jones Superposition)](/blueprint/po.pta.multirate.test.md)
- [Horner Buildup Analysis](/blueprint/po.pta.horner.pstar.md)
- [Drill-Stem Test Analysis](/blueprint/po.pta.dst.sequence.md)
- [Buildup Boundary Signatures](/blueprint/po.pta.buildup.boundary.md)
- [Constant-Rate Drawdown Analysis (MDH)](/blueprint/po.pta.drawdown.analysis.md)

