---
cid: po.bp.pta.injection.falloff
hub: pta
tags: [falloff, injection, water-injection, step-rate-test, fracture-extension-pressure, Horner, MDH, skin, well-testing]
facets: { discipline: reservoir, property: permeability }
title: Injection Falloff and Step-Rate Test
summary: "Interprets a water injector's falloff for kh, skin and average pressure, and checks a step-rate test for the parting pressure."
slug: po.pta.injection.falloff
type: worksheet
---

# Injection Falloff and Step-Rate Test

## Description

What kh, skin and average pressure does a water injector's falloff give, and was the well injecting below parting pressure? You paste the falloff's shut-in times and pressures, the injection rate, time and pressure at shut-in, and each step-rate step's rate and stabilized pressure. The sheet finds the radial-flow window from the Bourdet derivative, fits the MDH and Horner lines inside it, and fits the step-rate test's two lines. You read off k, kh, skin, p*, the injectivity and the fracture extension pressure and rate.

**Parameters:**
- **Injector, water and falloff**: the injection rate and time, Bw, μw, φ, ct, rw, h, and the injection pressure at shut-in (`FO_q`, `FO_tp`, `FO_Bw`, `FO_mu`, `FO_phi`, `FO_ct`, `FO_rw`, `FO_h`, `FO_Pwf`, which takes the model's)
- **Analysis settings**: the Bourdet window (`FO_L`), the slope tolerance about 0 and ½ (`FO_Tol`, ±0.05), and the round-trip tolerance on k (`FO_KTol`, ±5 %)
- **Step-rate test**: the steps on the matrix line (`FO_nlow`, 0 picks the best split) and the step length (`FO_StepHr`)
- **Synthetic model**: k, skin, pi, C, the extension pressure and the fracture's share of the rise above it (`FO_ModelK`, `FO_ModelS`, `FO_Pi`, `FO_C`, `FO_ModelPfe`, `FO_Frac`)
- **Data**: the falloff's Δt and pws, the region `FO_Data`, and the steps' rates and pressures, the regions `FO_Steps` and `FO_StepFit`

**How to use it:** Paste the falloff's Δt and pws over columns A and B, type the injection pressure at shut-in over the model's, and set q and tp. With a varying injection rate, use tp = cumulative injection × 24/q at the last rate. Type each step's rate and stabilized bottomhole pressure over the step table's Rate and Step BHP columns. The model columns and the round-trip check then don't apply. A Horner plot, a log-log plot of Δp and its derivative, and the step-rate plot with both lines are drawn.

**Method:** After injecting at a constant rate for tp hours the well is shut in, and its bottomhole pressure falls back towards the reservoir's. The sheet reads Δp = pwf − pws against Agarwal's equivalent time te = tp·Δt/(tp + Δt).

- **Derivative and regimes.** te = tp/R, where R = (tp + Δt)/Δt is the Horner ratio. The derivative is Bourdet's dΔp/d ln te with window L. Each interior row gets the derivative's log-log slope over the five rows centred on it (the least-squares slope of ln derivative on ln te), the scatter of those five derivatives, and a storage-hump flag. A row is radial when its slope is within ±Tol of 0, its scatter is under Tol/2 and it is not on the hump. It is a fracture row when both the derivative's slope and Δp's own (derivative ÷ Δp) are within ±Tol of ½. The radial window is the first unbroken run of radial rows. A ½ slope before radial flow is a fracture's linear flow, so the sheet flags it and reads where it ends, near closure.
- **Lines.** Over the window, the MDH fit puts Δp against log₁₀ te: k = 162.6·qBμ/(m·h) and S = 1.151·[Δp1h/m − log₁₀(k/(φμct·rw²)) + 3.23]. The same points of pws against log₁₀ R give the Horner line, whose intercept at R = 1 is p*. For a new injector in an infinite-acting reservoir the average pressure is p*. The injectivity index is q/(pwf − p̄).
- **Step-rate test.** The step-rate fit puts least-squares lines through the steps below and above the break and returns their crossing, the extension pressure and rate. With the matrix-line step count at 0 it tries every split and keeps the one of least squared error. The injection pressure at shut-in is checked against the extension pressure.

**Example:** A water injector takes 1,000 STB/d for 48 hr (Bw 1.02, μw 0.5 cp) into k 20 mD, h 50 ft, φ 20 %, ct 10⁻⁵ 1/psi, with skin 2 and a liquid-filled wellbore's storage of 0.001 bbl/psi, at pi 3,000 psi. The vertical-well model on the injection rate puts the injection pressure at 3,695.89 psi. The falloff is read from 0.01 to 48 hr. The storage hump peaks before the first reading. The derivative falls to its plateau of about 36 psi, flat within ±0.05 from Δt = 0.562 to 31.6 hr, 15 points. The MDH line there has m = 83.81 psi/cycle, so k = 19.79 mD (kh 990 md·ft) and S = 1.91, 1.0 % and 0.09 below the model's, within ±5 %. p* = 2,999.42 psi, 0.58 psi under pi, and the injectivity is 1.44 STB/d/psi. No ½-slope rows appear: the injector isn't fractured.

The step-rate test runs eight 1-hour steps from 250 to 3,000 STB/d on the same well. Each step's pressure is the model's at the step's end. Above a model extension pressure of 4,000 psi the open fracture takes the extra rate, and the pressure rises only a quarter as fast. The automatic split keeps 5 steps on the matrix line (slope 0.592 psi per STB/d) and 3 on the fracture line (0.154). They cross at 1,704 STB/d and 3,998.72 psi, 1.3 psi under the model's. The injection pressure is 303 psi below it, so the well was injecting below parting pressure.

The sheet was checked against the Engineering library's falloff pressure excess (Team76.Engineering 6.0.0) on the same model, rate, injection time and 31 shut-in times. The sheet's pws minus pi equals it to 10⁻⁵ psi. A standalone script then repeats the analysis. It takes the library's semilog Bourdet derivative and applies the sheet's slope, scatter and hump rule in its own code. It fits the window with its own least squares and gets k and S from the library's buildup permeability-from-slope and Horner skin. It reproduces the window (0.562 to 31.6 hr, 15 points), m 83.8059, k 19.79, S 1.91156 and p* 2,999.42. For the step-rate test the script computes each step's matrix pressure with the library's PTA pressure drop on the step history, applies the knee, and fits every split by its own least squares. It reproduces the split of 5, 3,998.72 psi, 1,703.99 STB/d and both slopes. The same script gives the skin-5 case. No printed falloff or step-rate example with every input given was to hand, so the sheet is not compared with a published one.

## Validity

The falloff model is a single-phase liquid in an infinite, homogeneous reservoir, with constant storage and skin. A real injector's water bank around the well has a different mobility from the oil beyond it, which bends the derivative into a composite response. Read k and skin from the bank's plateau only. The sheet takes p* as the average pressure, which holds while the falloff hasn't felt a boundary; a bounded pattern needs the Matthews-Brons-Hazebroek correction. With storage at 0.001 bbl/psi the radial window starts within an hour, and the tail of the storage hump still puts k 1 % low. A larger C or skin pushes the window later and widens that bias. The ±0.05 tolerance is the window rule's: at ±0.1 the window starts on the hump's tail.

The step-rate test needs stabilized pressures, equal steps and at least three steps on each side of the break. Each pressure here is transient, read at the end of a 1-hour step, so the matrix line isn't quite straight. The extension pressure is above the closure stress, so take closure from the falloff of a fracturing injector or from a DFIT, not from this plot. Injecting at a pressure above the extension pressure fails the parting check: the falloff then starts with an open fracture, and the radial reading doesn't apply. The add-in has no fractured-injector falloff model, no composite water-bank model and no Matthews-Brons-Hazebroek average pressure, so the sheet computes none of them.

Named alternatives: the fractured-injector falloff model (an infinite- or finite-conductivity fracture that closes during the falloff, read with a fracture type curve), the composite water-bank model (the Engineering library has a mobility-bank injection test the add-in does not expose), and the Matthews-Brons-Hazebroek average pressure in a bounded pattern.

## References

- Earlougher, R.C. Jr. (1977). *Advances in Well Test Analysis*, SPE Monograph 5, ch. 7 (injection well testing).
- Agarwal, R.G. (1980). A New Method to Account for Producing Time Effects When Drawdown Type Curves Are Used to Analyze Pressure Buildup and Other Test Data. SPE 9289.
- Felsenthal, M. (1974). Step-Rate Tests Determine Safe Injection Pressures in Floods. *Oil and Gas Journal*, 28 October, 49–54.
- Singh, P.K., Agarwal, R.G. and Krase, L.D. (1987). Systematic Design and Analysis of Step-Rate Tests to Determine Formation Parting Pressure. SPE 16798.
- Bourdet, D., Ayoub, J.A. and Pirard, Y.M. (1989). Use of Pressure Derivative in Well-Test Interpretation. *SPE Formation Evaluation* 4(2), 293–302.
- Horner, D.R. (1951). Pressure Build-Up in Wells. *Proc. Third World Petroleum Congress*, Sec. II, 503–523.

## Functions used

`PO.PTA.Pw.VW`, `PO.PTA.Horner.Ratio`, `PO.DCA.Diag.Bourdet.SemiLog`, `PO.PTA.MDH.Fit`, `PO.PTA.StepRate.Fit`

## Spreadsheet: PtaInjectionFalloff

|     | A                                                                                                                                                               | B                                                                                                                                                                                                                                                                              | C                                                                                                                                                                                                                                                                                     | D                                                                                                 | E                                                               | F                           | G                           | H                                                                 | I          | J                                   | K                                      | L                                                   | M                                                     | N                                                                 |
|-----|-----------------------------------------------------------------------------------------------------------------------------------------------------------------|--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|---------------------------------------------------------------------------------------------------|-----------------------------------------------------------------|-----------------------------|-----------------------------|-------------------------------------------------------------------|------------|-------------------------------------|----------------------------------------|-----------------------------------------------------|-------------------------------------------------------|-------------------------------------------------------------------|
| 1   | Injection Falloff and Step-Rate Test                                                                                                                            |                                                                                                                                                                                                                                                                                | Petroleum Office                                                                                                                                                                                                                                                                      |                                                                                                   |                                                                 |                             |                             |                                                                   |            |                                     |                                        |                                                     |                                                       |                                                                   |
| 2   | Blue cells on yellow are inputs. Paste the falloff's Δt and pws over columns A and B, and the step rates and pressures over the step table.                     |                                                                                                                                                                                                                                                                                |                                                                                                                                                                                                                                                                                       |                                                                                                   |                                                                 |                             |                             |                                                                   |            |                                     |                                        |                                                     |                                                       |                                                                   |
| 3   | Injector, Water and Falloff                                                                                                                                     |                                                                                                                                                                                                                                                                                |                                                                                                                                                                                                                                                                                       |                                                                                                   |                                                                 |                             |                             |                                                                   |            |                                     |                                        |                                                     |                                                       |                                                                   |
| 4   | Injection rate before shut-in, q                                                                                                                                | 1000                                                                                                                                                                                                                                                                           | STB/d                                                                                                                                                                                                                                                                                 |                                                                                                   |                                                                 |                             |                             |                                                                   |            |                                     |                                        |                                                     |                                                       |                                                                   |
| 5   | Injection time before shut-in, tp                                                                                                                               | 48                                                                                                                                                                                                                                                                             | hr                                                                                                                                                                                                                                                                                    |                                                                                                   |                                                                 |                             |                             |                                                                   |            |                                     |                                        |                                                     |                                                       |                                                                   |
| 6   | Water formation volume factor, Bw                                                                                                                               | 1.02                                                                                                                                                                                                                                                                           | bbl/STB                                                                                                                                                                                                                                                                               |                                                                                                   |                                                                 |                             |                             |                                                                   |            |                                     |                                        |                                                     |                                                       |                                                                   |
| 7   | Water viscosity, μw                                                                                                                                             | 0.5                                                                                                                                                                                                                                                                            | cp                                                                                                                                                                                                                                                                                    |                                                                                                   |                                                                 |                             |                             |                                                                   |            |                                     |                                        |                                                     |                                                       |                                                                   |
| 8   | Porosity, φ                                                                                                                                                     | 0.2                                                                                                                                                                                                                                                                            | %                                                                                                                                                                                                                                                                                     |                                                                                                   |                                                                 |                             |                             |                                                                   |            |                                     |                                        |                                                     |                                                       |                                                                   |
| 9   | Total compressibility, ct                                                                                                                                       | 0.00001                                                                                                                                                                                                                                                                        | 1/psi                                                                                                                                                                                                                                                                                 |                                                                                                   |                                                                 |                             |                             |                                                                   |            |                                     |                                        |                                                     |                                                       |                                                                   |
| 10  | Wellbore radius, rw                                                                                                                                             | 0.354                                                                                                                                                                                                                                                                          | ft                                                                                                                                                                                                                                                                                    |                                                                                                   |                                                                 |                             |                             |                                                                   |            |                                     |                                        |                                                     |                                                       |                                                                   |
| 11  | Net pay, h                                                                                                                                                      | 50                                                                                                                                                                                                                                                                             | ft                                                                                                                                                                                                                                                                                    |                                                                                                   |                                                                 |                             |                             |                                                                   |            |                                     |                                        |                                                     |                                                       |                                                                   |
| 12  | Injection pressure at shut-in, pwf                                                                                                                              | =FO_PwfModel                                                                                                                                                                                                                                                                   | psi                                                                                                                                                                                                                                                                                   |                                                                                                   |                                                                 |                             |                             |                                                                   |            |                                     |                                        |                                                     |                                                       |                                                                   |
| 13  | Analysis Settings                                                                                                                                               |                                                                                                                                                                                                                                                                                |                                                                                                                                                                                                                                                                                       |                                                                                                   |                                                                 |                             |                             |                                                                   |            |                                     |                                        |                                                     |                                                       |                                                                   |
| 14  | Bourdet smoothing window, L                                                                                                                                     | 0.2                                                                                                                                                                                                                                                                            | cycles                                                                                                                                                                                                                                                                                |                                                                                                   |                                                                 |                             |                             |                                                                   |            |                                     |                                        |                                                     |                                                       |                                                                   |
| 15  | Slope tolerance about 0 (radial) and ½ (fracture)                                                                                                               | 0.05                                                                                                                                                                                                                                                                           | —                                                                                                                                                                                                                                                                                     |                                                                                                   |                                                                 |                             |                             |                                                                   |            |                                     |                                        |                                                     |                                                       |                                                                   |
| 16  | Round trip: k recovered within ±                                                                                                                                | 0.05                                                                                                                                                                                                                                                                           | %                                                                                                                                                                                                                                                                                     |                                                                                                   |                                                                 |                             |                             |                                                                   |            |                                     |                                        |                                                     |                                                       |                                                                   |
| 17  | Step-Rate Test                                                                                                                                                  |                                                                                                                                                                                                                                                                                |                                                                                                                                                                                                                                                                                       |                                                                                                   |                                                                 |                             |                             |                                                                   |            |                                     |                                        |                                                     |                                                       |                                                                   |
| 18  | Steps on the matrix line (0 picks the best split)                                                                                                               | 0                                                                                                                                                                                                                                                                              | —                                                                                                                                                                                                                                                                                     |                                                                                                   |                                                                 |                             |                             |                                                                   |            |                                     |                                        |                                                     |                                                       |                                                                   |
| 19  | Length of each rate step                                                                                                                                        | 1                                                                                                                                                                                                                                                                              | hr                                                                                                                                                                                                                                                                                    |                                                                                                   |                                                                 |                             |                             |                                                                   |            |                                     |                                        |                                                     |                                                       |                                                                   |
| 20  | Synthetic Model                                                                                                                                                 |                                                                                                                                                                                                                                                                                |                                                                                                                                                                                                                                                                                       |                                                                                                   |                                                                 |                             |                             |                                                                   |            |                                     |                                        |                                                     |                                                       |                                                                   |
| 21  | Model permeability                                                                                                                                              | 20                                                                                                                                                                                                                                                                             | mD                                                                                                                                                                                                                                                                                    |                                                                                                   |                                                                 |                             |                             |                                                                   |            |                                     |                                        |                                                     |                                                       |                                                                   |
| 22  | Model skin factor                                                                                                                                               | 2                                                                                                                                                                                                                                                                              | —                                                                                                                                                                                                                                                                                     |                                                                                                   |                                                                 |                             |                             |                                                                   |            |                                     |                                        |                                                     |                                                       |                                                                   |
| 23  | Initial reservoir pressure, pi                                                                                                                                  | 3000                                                                                                                                                                                                                                                                           | psi                                                                                                                                                                                                                                                                                   |                                                                                                   |                                                                 |                             |                             |                                                                   |            |                                     |                                        |                                                     |                                                       |                                                                   |
| 24  | Wellbore storage coefficient, C                                                                                                                                 | 0.001                                                                                                                                                                                                                                                                          | bbl/psi                                                                                                                                                                                                                                                                               |                                                                                                   |                                                                 |                             |                             |                                                                   |            |                                     |                                        |                                                     |                                                       |                                                                   |
| 25  | Model fracture extension pressure                                                                                                                               | 4000                                                                                                                                                                                                                                                                           | psi                                                                                                                                                                                                                                                                                   |                                                                                                   |                                                                 |                             |                             |                                                                   |            |                                     |                                        |                                                     |                                                       |                                                                   |
| 26  | Above it, the rise as a fraction of the matrix's                                                                                                                | 0.25                                                                                                                                                                                                                                                                           | —                                                                                                                                                                                                                                                                                     |                                                                                                   |                                                                 |                             |                             |                                                                   |            |                                     |                                        |                                                     |                                                       |                                                                   |
| 28  | Results                                                                                                                                                         |                                                                                                                                                                                                                                                                                |                                                                                                                                                                                                                                                                                       |                                                                                                   |                                                                 |                             |                             |                                                                   |            |                                     |                                        |                                                     |                                                       |                                                                   |
| 29  | Model injection pressure at shut-in                                                                                                                             | =FO_Pi+PO.PTA.Pw.VW(FO_tp,FO_q,FO_Bw,FO_mu,FO_C,FO_rw,FO_ModelS,FO_ct,FO_phi,FO_h,FO_ModelK)                                                                                                                                                                                   | psi                                                                                                                                                                                                                                                                                   |                                                                                                   |                                                                 |                             |                             |                                                                   |            |                                     |                                        |                                                     |                                                       |                                                                   |
| 30  | Radial flow (flat derivative) starts at Δt                                                                                                                      | =MINIFS($A$95:$A$125,$M$95:$M$125,1)                                                                                                                                                                                                                                           | hr                                                                                                                                                                                                                                                                                    |                                                                                                   |                                                                 |                             |                             |                                                                   |            |                                     |                                        |                                                     |                                                       |                                                                   |
| 31  | Radial flow ends at Δt (its first run)                                                                                                                          | =MAXIFS($A$95:$A$125,$M$95:$M$125,1,$A$95:$A$125,"<"&IF(COUNTIFS($A$95:$A$125,">"&FO_RadStart,$M$95:$M$125,0)=0,2*MAX($A$95:$A$125),MINIFS($A$95:$A$125,$A$95:$A$125,">"&FO_RadStart,$M$95:$M$125,0)))                                                                         | hr                                                                                                                                                                                                                                                                                    |                                                                                                   |                                                                 |                             |                             |                                                                   |            |                                     |                                        |                                                     |                                                       |                                                                   |
| 32  | Points in the radial window                                                                                                                                     | =SUMPRODUCT(($M$95:$M$125=1)*($A$95:$A$125>=FO_RadStart)*($A$95:$A$125<=FO_RadEnd))                                                                                                                                                                                            | —                                                                                                                                                                                                                                                                                     |                                                                                                   |                                                                 |                             |                             |                                                                   |            |                                     |                                        |                                                     |                                                       |                                                                   |
| 33  | Semilog slope on Agarwal's te, m                                                                                                                                | =IF(FO_NRad<FO_MinN,0,PO.PTA.MDH.Fit(FILTER($F$95:$F$125,($M$95:$M$125=1)*($A$95:$A$125>=FO_RadStart)*($A$95:$A$125<=FO_RadEnd)),FILTER($G$95:$G$125,($M$95:$M$125=1)*($A$95:$A$125>=FO_RadStart)*($A$95:$A$125<=FO_RadEnd)),FO_q,FO_Bw,FO_mu,FO_h,FO_phi,FO_ct,FO_rw,"m"))    | psi/cycle                                                                                                                                                                                                                                                                             |                                                                                                   |                                                                 |                             |                             |                                                                   |            |                                     |                                        |                                                     |                                                       |                                                                   |
| 34  | Line's Δp at te = 1 hr                                                                                                                                          | =IF(FO_NRad<FO_MinN,0,PO.PTA.MDH.Fit(FILTER($F$95:$F$125,($M$95:$M$125=1)*($A$95:$A$125>=FO_RadStart)*($A$95:$A$125<=FO_RadEnd)),FILTER($G$95:$G$125,($M$95:$M$125=1)*($A$95:$A$125>=FO_RadStart)*($A$95:$A$125<=FO_RadEnd)),FO_q,FO_Bw,FO_mu,FO_h,FO_phi,FO_ct,FO_rw,"dp1h")) | psi                                                                                                                                                                                                                                                                                   |                                                                                                   |                                                                 |                             |                             |                                                                   |            |                                     |                                        |                                                     |                                                       |                                                                   |
| 35  | Permeability, k                                                                                                                                                 | =IF(FO_NRad<FO_MinN,0,PO.PTA.MDH.Fit(FILTER($F$95:$F$125,($M$95:$M$125=1)*($A$95:$A$125>=FO_RadStart)*($A$95:$A$125<=FO_RadEnd)),FILTER($G$95:$G$125,($M$95:$M$125=1)*($A$95:$A$125>=FO_RadStart)*($A$95:$A$125<=FO_RadEnd)),FO_q,FO_Bw,FO_mu,FO_h,FO_phi,FO_ct,FO_rw,"k"))    | mD                                                                                                                                                                                                                                                                                    |                                                                                                   |                                                                 |                             |                             |                                                                   |            |                                     |                                        |                                                     |                                                       |                                                                   |
| 36  | Permeability-thickness, kh                                                                                                                                      | =FO_K*FO_h                                                                                                                                                                                                                                                                     | mD·ft                                                                                                                                                                                                                                                                                 |                                                                                                   |                                                                 |                             |                             |                                                                   |            |                                     |                                        |                                                     |                                                       |                                                                   |
| 37  | Skin factor, S                                                                                                                                                  | =IF(FO_NRad<FO_MinN,0,PO.PTA.MDH.Fit(FILTER($F$95:$F$125,($M$95:$M$125=1)*($A$95:$A$125>=FO_RadStart)*($A$95:$A$125<=FO_RadEnd)),FILTER($G$95:$G$125,($M$95:$M$125=1)*($A$95:$A$125>=FO_RadStart)*($A$95:$A$125<=FO_RadEnd)),FO_q,FO_Bw,FO_mu,FO_h,FO_phi,FO_ct,FO_rw,"S"))    | —                                                                                                                                                                                                                                                                                     |                                                                                                   |                                                                 |                             |                             |                                                                   |            |                                     |                                        |                                                     |                                                       |                                                                   |
| 38  | Horner line's p* (ratio of 1)                                                                                                                                   | =INTERCEPT(FILTER($B$95:$B$125,($M$95:$M$125=1)*($A$95:$A$125>=FO_RadStart)*($A$95:$A$125<=FO_RadEnd)),FILTER($E$95:$E$125,($M$95:$M$125=1)*($A$95:$A$125>=FO_RadStart)*($A$95:$A$125<=FO_RadEnd)))                                                                            | psi                                                                                                                                                                                                                                                                                   |                                                                                                   |                                                                 |                             |                             |                                                                   |            |                                     |                                        |                                                     |                                                       |                                                                   |
| 39  | Average pressure, p̄ (p* while infinite-acting)                                                                                                                 | =FO_Pstar                                                                                                                                                                                                                                                                      | psi                                                                                                                                                                                                                                                                                   |                                                                                                   |                                                                 |                             |                             |                                                                   |            |                                     |                                        |                                                     |                                                       |                                                                   |
| 40  | Injectivity index, q/(pwf − p̄)                                                                                                                                 | =FO_q/(FO_Pwf-FO_Pavg)                                                                                                                                                                                                                                                         | STB/d/psi                                                                                                                                                                                                                                                                             |                                                                                                   |                                                                 |                             |                             |                                                                   |            |                                     |                                        |                                                     |                                                       |                                                                   |
| 41  | ½-slope (fracture) points before radial flow                                                                                                                    | =SUMPRODUCT(($N$95:$N$125=1)*($A$95:$A$125<FO_RadStart))                                                                                                                                                                                                                       | —                                                                                                                                                                                                                                                                                     |                                                                                                   |                                                                 |                             |                             |                                                                   |            |                                     |                                        |                                                     |                                                       |                                                                   |
| 42  | Last ½-slope point, closure near Δt                                                                                                                             | =IF(FO_NHalf=0,0,MAXIFS($A$95:$A$125,$N$95:$N$125,1,$A$95:$A$125,"<"&FO_RadStart))                                                                                                                                                                                             | hr                                                                                                                                                                                                                                                                                    |                                                                                                   |                                                                 |                             |                             |                                                                   |            |                                     |                                        |                                                     |                                                       |                                                                   |
| 43  | Pressure there, near closure                                                                                                                                    | =IF(FO_NHalf=0,0,SUMIFS($B$95:$B$125,$A$95:$A$125,FO_TClose))                                                                                                                                                                                                                  | psi                                                                                                                                                                                                                                                                                   |                                                                                                   |                                                                 |                             |                             |                                                                   |            |                                     |                                        |                                                     |                                                       |                                                                   |
| 44  | Fracture extension pressure                                                                                                                                     | =PO.PTA.StepRate.Fit($B$70:$B$77,$E$70:$E$77,FO_nlow,"p")                                                                                                                                                                                                                      | psi                                                                                                                                                                                                                                                                                   |                                                                                                   |                                                                 |                             |                             |                                                                   |            |                                     |                                        |                                                     |                                                       |                                                                   |
| 45  | Fracture extension rate                                                                                                                                         | =PO.PTA.StepRate.Fit($B$70:$B$77,$E$70:$E$77,FO_nlow,"q")                                                                                                                                                                                                                      | STB/d                                                                                                                                                                                                                                                                                 |                                                                                                   |                                                                 |                             |                             |                                                                   |            |                                     |                                        |                                                     |                                                       |                                                                   |
| 46  | Matrix line's slope                                                                                                                                             | =PO.PTA.StepRate.Fit($B$70:$B$77,$E$70:$E$77,FO_nlow,"mlo")                                                                                                                                                                                                                    | psi/(STB/d)                                                                                                                                                                                                                                                                           |                                                                                                   |                                                                 |                             |                             |                                                                   |            |                                     |                                        |                                                     |                                                       |                                                                   |
| 47  | Fracture line's slope                                                                                                                                           | =PO.PTA.StepRate.Fit($B$70:$B$77,$E$70:$E$77,FO_nlow,"mhi")                                                                                                                                                                                                                    | psi/(STB/d)                                                                                                                                                                                                                                                                           |                                                                                                   |                                                                 |                             |                             |                                                                   |            |                                     |                                        |                                                     |                                                       |                                                                   |
| 48  | Steps on the matrix line                                                                                                                                        | =PO.PTA.StepRate.Fit($B$70:$B$77,$E$70:$E$77,FO_nlow,"n")                                                                                                                                                                                                                      | —                                                                                                                                                                                                                                                                                     |                                                                                                   |                                                                 |                             |                             |                                                                   |            |                                     |                                        |                                                     |                                                       |                                                                   |
| 49  | k against the model                                                                                                                                             | =FO_K/FO_ModelK-1                                                                                                                                                                                                                                                              | %                                                                                                                                                                                                                                                                                     |                                                                                                   |                                                                 |                             |                             |                                                                   |            |                                     |                                        |                                                     |                                                       |                                                                   |
| 50  | S against the model                                                                                                                                             | =FO_S-FO_ModelS                                                                                                                                                                                                                                                                | —                                                                                                                                                                                                                                                                                     |                                                                                                   |                                                                 |                             |                             |                                                                   |            |                                     |                                        |                                                     |                                                       |                                                                   |
| 51  | p̄ against pi                                                                                                                                                   | =FO_Pavg-FO_Pi                                                                                                                                                                                                                                                                 | psi                                                                                                                                                                                                                                                                                   |                                                                                                   |                                                                 |                             |                             |                                                                   |            |                                     |                                        |                                                     |                                                       |                                                                   |
| 52  | Extension pressure against the model's                                                                                                                          | =FO_Pfe-FO_ModelPfe                                                                                                                                                                                                                                                            | psi                                                                                                                                                                                                                                                                                   |                                                                                                   |                                                                 |                             |                             |                                                                   |            |                                     |                                        |                                                     |                                                       |                                                                   |
| 53  | Radial window check                                                                                                                                             | =IF(FO_NRad>=FO_MinN,"PASS","WARN")                                                                                                                                                                                                                                            | =IF(FO_NRad>=FO_MinN,"the derivative is flat within ±"&FIXED(FO_Tol,2)&" from Δt "&FIXED(FO_RadStart,2)&" to "&FIXED(FO_RadEnd,1)&" hr, "&FO_NRad&" points","no run of "&FO_MinN&" flat-derivative points: k, skin and p* are not read")                                              |                                                                                                   |                                                                 |                             |                             |                                                                   |            |                                     |                                        |                                                     |                                                       |                                                                   |
| 54  | Injection below parting check                                                                                                                                   | =IF(FO_Pwf<FO_Pfe,"PASS","FAIL")                                                                                                                                                                                                                                               | =IF(FO_Pwf<FO_Pfe,"the injector was shut in at "&FIXED(FO_Pwf,0)&" psi, "&FIXED(FO_Pfe-FO_Pwf,0)&" psi below the step-rate extension pressure","the injector was shut in at "&FIXED(FO_Pwf,0)&" psi, above the extension pressure of "&FIXED(FO_Pfe,0)&" psi: the fracture was open") |                                                                                                   |                                                                 |                             |                             |                                                                   |            |                                     |                                        |                                                     |                                                       |                                                                   |
| 55  | Fracture-closure flag on the derivative                                                                                                                         | =IF(FO_NHalf>=FO_MinN,"WARN","PASS")                                                                                                                                                                                                                                           | =IF(FO_NHalf>=FO_MinN,""&FO_NHalf&" ½-slope points before radial flow: fracture linear flow, closing near Δt "&FIXED(FO_TClose,2)&" hr at "&FIXED(FO_PClose,0)&" psi","no ½-slope stretch before radial flow, so no fracture closure on the derivative")                              |                                                                                                   |                                                                 |                             |                             |                                                                   |            |                                     |                                        |                                                     |                                                       |                                                                   |
| 56  | Round trip on the synthetic data                                                                                                                                | =IF(ABS(FO_KErr)<=FO_KTol,"PASS","WARN")                                                                                                                                                                                                                                       | =IF(ABS(FO_KErr)<=FO_KTol,"k is "&FIXED(FO_KErr*100,1)&"% from the model's, S "&FIXED(FO_SErr,2)&", p̄ "&FIXED(FO_PErr,1)&" psi (ignore for real data)","k is "&FIXED(FO_KErr*100,1)&"% from the model's: check the window (ignore for real data)")                                   |                                                                                                   |                                                                 |                             |                             |                                                                   |            |                                     |                                        |                                                     |                                                       |                                                                   |
| 58  | Calculation Constants                                                                                                                                           |                                                                                                                                                                                                                                                                                |                                                                                                                                                                                                                                                                                       |                                                                                                   |                                                                 |                             |                             |                                                                   |            |                                     |                                        |                                                     |                                                       |                                                                   |
| 59  | Fracture linear-flow log-log slope                                                                                                                              | 0.5                                                                                                                                                                                                                                                                            | —                                                                                                                                                                                                                                                                                     |                                                                                                   |                                                                 |                             |                             |                                                                   |            |                                     |                                        |                                                     |                                                       |                                                                   |
| 60  | Fewest points a line is fitted to                                                                                                                               | 3                                                                                                                                                                                                                                                                              | —                                                                                                                                                                                                                                                                                     |                                                                                                   |                                                                 |                             |                             |                                                                   |            |                                     |                                        |                                                     |                                                       |                                                                   |
| 62  | Injection History for the Model                                                                                                                                 |                                                                                                                                                                                                                                                                                |                                                                                                                                                                                                                                                                                       |                                                                                                   |                                                                 |                             |                             |                                                                   |            |                                     |                                        |                                                     |                                                       |                                                                   |
| 63  | Start (hr)                                                                                                                                                      | Rate (STB/d)                                                                                                                                                                                                                                                                   |                                                                                                                                                                                                                                                                                       |                                                                                                   |                                                                 |                             |                             |                                                                   |            |                                     |                                        |                                                     |                                                       |                                                                   |
| 64  | =0                                                                                                                                                              | =FO_q                                                                                                                                                                                                                                                                          |                                                                                                                                                                                                                                                                                       |                                                                                                   |                                                                 |                             |                             |                                                                   |            |                                     |                                        |                                                     |                                                       |                                                                   |
| 65  | =FO_tp                                                                                                                                                          | =0                                                                                                                                                                                                                                                                             |                                                                                                                                                                                                                                                                                       |                                                                                                   |                                                                 |                             |                             |                                                                   |            |                                     |                                        |                                                     |                                                       |                                                                   |
| 67  | Step-Rate Test                                                                                                                                                  |                                                                                                                                                                                                                                                                                |                                                                                                                                                                                                                                                                                       |                                                                                                   |                                                                 |                             |                             |                                                                   |            |                                     |                                        |                                                     |                                                       |                                                                   |
| 68  | How to use it: type each step's rate and the bottomhole pressure stabilized at its end over columns B and E. The model's knee is a stand-in for data.           |                                                                                                                                                                                                                                                                                |                                                                                                                                                                                                                                                                                       |                                                                                                   |                                                                 |                             |                             |                                                                   |            |                                     |                                        |                                                     |                                                       |                                                                   |
| 69  | Start (hr)                                                                                                                                                      | Rate (STB/d)                                                                                                                                                                                                                                                                   | End (hr)                                                                                                                                                                                                                                                                              | Matrix model (psi)                                                                                | Step BHP (psi)                                                  | Matrix line (psi)           | Fracture line (psi)         |                                                                   |            |                                     |                                        |                                                     |                                                       |                                                                   |
| 70  | =0                                                                                                                                                              | 250                                                                                                                                                                                                                                                                            | =A70+FO_StepHr                                                                                                                                                                                                                                                                        | =FO_Pi+PO.PTA.Pw.VW(C70,$A$70:$B$70,FO_Bw,FO_mu,FO_C,FO_rw,FO_ModelS,FO_ct,FO_phi,FO_h,FO_ModelK) | =IF(D70<=FO_ModelPfe,D70,FO_ModelPfe+FO_Frac*(D70-FO_ModelPfe)) | =FO_Pfe+FO_MLo*(B70-FO_Qfe) | =FO_Pfe+FO_MHi*(B70-FO_Qfe) |                                                                   |            |                                     |                                        |                                                     |                                                       |                                                                   |
| 71  | =C70                                                                                                                                                            | 500                                                                                                                                                                                                                                                                            | =A71+FO_StepHr                                                                                                                                                                                                                                                                        | =FO_Pi+PO.PTA.Pw.VW(C71,$A$70:$B$71,FO_Bw,FO_mu,FO_C,FO_rw,FO_ModelS,FO_ct,FO_phi,FO_h,FO_ModelK) | =IF(D71<=FO_ModelPfe,D71,FO_ModelPfe+FO_Frac*(D71-FO_ModelPfe)) | =FO_Pfe+FO_MLo*(B71-FO_Qfe) | =FO_Pfe+FO_MHi*(B71-FO_Qfe) |                                                                   |            |                                     |                                        |                                                     |                                                       |                                                                   |
| 72  | =C71                                                                                                                                                            | 750                                                                                                                                                                                                                                                                            | =A72+FO_StepHr                                                                                                                                                                                                                                                                        | =FO_Pi+PO.PTA.Pw.VW(C72,$A$70:$B$72,FO_Bw,FO_mu,FO_C,FO_rw,FO_ModelS,FO_ct,FO_phi,FO_h,FO_ModelK) | =IF(D72<=FO_ModelPfe,D72,FO_ModelPfe+FO_Frac*(D72-FO_ModelPfe)) | =FO_Pfe+FO_MLo*(B72-FO_Qfe) | =FO_Pfe+FO_MHi*(B72-FO_Qfe) |                                                                   |            |                                     |                                        |                                                     |                                                       |                                                                   |
| 73  | =C72                                                                                                                                                            | 1000                                                                                                                                                                                                                                                                           | =A73+FO_StepHr                                                                                                                                                                                                                                                                        | =FO_Pi+PO.PTA.Pw.VW(C73,$A$70:$B$73,FO_Bw,FO_mu,FO_C,FO_rw,FO_ModelS,FO_ct,FO_phi,FO_h,FO_ModelK) | =IF(D73<=FO_ModelPfe,D73,FO_ModelPfe+FO_Frac*(D73-FO_ModelPfe)) | =FO_Pfe+FO_MLo*(B73-FO_Qfe) | =FO_Pfe+FO_MHi*(B73-FO_Qfe) |                                                                   |            |                                     |                                        |                                                     |                                                       |                                                                   |
| 74  | =C73                                                                                                                                                            | 1500                                                                                                                                                                                                                                                                           | =A74+FO_StepHr                                                                                                                                                                                                                                                                        | =FO_Pi+PO.PTA.Pw.VW(C74,$A$70:$B$74,FO_Bw,FO_mu,FO_C,FO_rw,FO_ModelS,FO_ct,FO_phi,FO_h,FO_ModelK) | =IF(D74<=FO_ModelPfe,D74,FO_ModelPfe+FO_Frac*(D74-FO_ModelPfe)) | =FO_Pfe+FO_MLo*(B74-FO_Qfe) | =FO_Pfe+FO_MHi*(B74-FO_Qfe) |                                                                   |            |                                     |                                        |                                                     |                                                       |                                                                   |
| 75  | =C74                                                                                                                                                            | 2000                                                                                                                                                                                                                                                                           | =A75+FO_StepHr                                                                                                                                                                                                                                                                        | =FO_Pi+PO.PTA.Pw.VW(C75,$A$70:$B$75,FO_Bw,FO_mu,FO_C,FO_rw,FO_ModelS,FO_ct,FO_phi,FO_h,FO_ModelK) | =IF(D75<=FO_ModelPfe,D75,FO_ModelPfe+FO_Frac*(D75-FO_ModelPfe)) | =FO_Pfe+FO_MLo*(B75-FO_Qfe) | =FO_Pfe+FO_MHi*(B75-FO_Qfe) |                                                                   |            |                                     |                                        |                                                     |                                                       |                                                                   |
| 76  | =C75                                                                                                                                                            | 2500                                                                                                                                                                                                                                                                           | =A76+FO_StepHr                                                                                                                                                                                                                                                                        | =FO_Pi+PO.PTA.Pw.VW(C76,$A$70:$B$76,FO_Bw,FO_mu,FO_C,FO_rw,FO_ModelS,FO_ct,FO_phi,FO_h,FO_ModelK) | =IF(D76<=FO_ModelPfe,D76,FO_ModelPfe+FO_Frac*(D76-FO_ModelPfe)) | =FO_Pfe+FO_MLo*(B76-FO_Qfe) | =FO_Pfe+FO_MHi*(B76-FO_Qfe) |                                                                   |            |                                     |                                        |                                                     |                                                       |                                                                   |
| 77  | =C76                                                                                                                                                            | 3000                                                                                                                                                                                                                                                                           | =A77+FO_StepHr                                                                                                                                                                                                                                                                        | =FO_Pi+PO.PTA.Pw.VW(C77,$A$70:$B$77,FO_Bw,FO_mu,FO_C,FO_rw,FO_ModelS,FO_ct,FO_phi,FO_h,FO_ModelK) | =IF(D77<=FO_ModelPfe,D77,FO_ModelPfe+FO_Frac*(D77-FO_ModelPfe)) | =FO_Pfe+FO_MLo*(B77-FO_Qfe) | =FO_Pfe+FO_MHi*(B77-FO_Qfe) |                                                                   |            |                                     |                                        |                                                     |                                                       |                                                                   |
| 79  | Horner Straight Line                                                                                                                                            |                                                                                                                                                                                                                                                                                |                                                                                                                                                                                                                                                                                       |                                                                                                   |                                                                 |                             |                             |                                                                   |            |                                     |                                        |                                                     |                                                       |                                                                   |
| 80  | Horner ratio (—)                                                                                                                                                | Horner line (psi)                                                                                                                                                                                                                                                              |                                                                                                                                                                                                                                                                                       |                                                                                                   |                                                                 |                             |                             |                                                                   |            |                                     |                                        |                                                     |                                                       |                                                                   |
| 81  | =MAX($D$95:$D$125)^(0/8)                                                                                                                                        | =FO_Pstar+FO_M*LOG10(A81)                                                                                                                                                                                                                                                      |                                                                                                                                                                                                                                                                                       |                                                                                                   |                                                                 |                             |                             |                                                                   |            |                                     |                                        |                                                     |                                                       |                                                                   |
| 82  | =MAX($D$95:$D$125)^(1/8)                                                                                                                                        | =FO_Pstar+FO_M*LOG10(A82)                                                                                                                                                                                                                                                      |                                                                                                                                                                                                                                                                                       |                                                                                                   |                                                                 |                             |                             |                                                                   |            |                                     |                                        |                                                     |                                                       |                                                                   |
| 83  | =MAX($D$95:$D$125)^(2/8)                                                                                                                                        | =FO_Pstar+FO_M*LOG10(A83)                                                                                                                                                                                                                                                      |                                                                                                                                                                                                                                                                                       |                                                                                                   |                                                                 |                             |                             |                                                                   |            |                                     |                                        |                                                     |                                                       |                                                                   |
| 84  | =MAX($D$95:$D$125)^(3/8)                                                                                                                                        | =FO_Pstar+FO_M*LOG10(A84)                                                                                                                                                                                                                                                      |                                                                                                                                                                                                                                                                                       |                                                                                                   |                                                                 |                             |                             |                                                                   |            |                                     |                                        |                                                     |                                                       |                                                                   |
| 85  | =MAX($D$95:$D$125)^(4/8)                                                                                                                                        | =FO_Pstar+FO_M*LOG10(A85)                                                                                                                                                                                                                                                      |                                                                                                                                                                                                                                                                                       |                                                                                                   |                                                                 |                             |                             |                                                                   |            |                                     |                                        |                                                     |                                                       |                                                                   |
| 86  | =MAX($D$95:$D$125)^(5/8)                                                                                                                                        | =FO_Pstar+FO_M*LOG10(A86)                                                                                                                                                                                                                                                      |                                                                                                                                                                                                                                                                                       |                                                                                                   |                                                                 |                             |                             |                                                                   |            |                                     |                                        |                                                     |                                                       |                                                                   |
| 87  | =MAX($D$95:$D$125)^(6/8)                                                                                                                                        | =FO_Pstar+FO_M*LOG10(A87)                                                                                                                                                                                                                                                      |                                                                                                                                                                                                                                                                                       |                                                                                                   |                                                                 |                             |                             |                                                                   |            |                                     |                                        |                                                     |                                                       |                                                                   |
| 88  | =MAX($D$95:$D$125)^(7/8)                                                                                                                                        | =FO_Pstar+FO_M*LOG10(A88)                                                                                                                                                                                                                                                      |                                                                                                                                                                                                                                                                                       |                                                                                                   |                                                                 |                             |                             |                                                                   |            |                                     |                                        |                                                     |                                                       |                                                                   |
| 89  | =MAX($D$95:$D$125)^(8/8)                                                                                                                                        | =FO_Pstar+FO_M*LOG10(A89)                                                                                                                                                                                                                                                      |                                                                                                                                                                                                                                                                                       |                                                                                                   |                                                                 |                             |                             |                                                                   |            |                                     |                                        |                                                     |                                                       |                                                                   |
| 91  | Falloff Data and the Regime Read of Every Row                                                                                                                   |                                                                                                                                                                                                                                                                                |                                                                                                                                                                                                                                                                                       |                                                                                                   |                                                                 |                             |                             |                                                                   |            |                                     |                                        |                                                     |                                                       |                                                                   |
| 92  | How to use it: paste Δt and pws over columns A and B, type the injection pressure at shut-in into its input, and set q and tp (trim the formulas to your rows). |                                                                                                                                                                                                                                                                                |                                                                                                                                                                                                                                                                                       |                                                                                                   |                                                                 |                             |                             |                                                                   |            |                                     |                                        |                                                     |                                                       |                                                                   |
| 93  | Δp = pwf − pws on Agarwal's te; each row's derivative slope over five rows reads radial flow (0) or fracture linear flow (½).                                   |                                                                                                                                                                                                                                                                                |                                                                                                                                                                                                                                                                                       |                                                                                                   |                                                                 |                             |                             |                                                                   |            |                                     |                                        |                                                     |                                                       |                                                                   |
| 94  | Δt (hr)                                                                                                                                                         | pws (psi)                                                                                                                                                                                                                                                                      | Model pws (psi)                                                                                                                                                                                                                                                                       | Horner ratio (—)                                                                                  | log₁₀ ratio                                                     | te (hr)                     | Δp (psi)                    | Derivative (psi)                                                  | Δp slope   | Der. slope                          | Scatter                                | Hump                                                | Radial                                                | ½ slope                                                           |
| 95  | 0.01                                                                                                                                                            | =C95                                                                                                                                                                                                                                                                           | =FO_Pi+PO.PTA.Pw.VW(FO_tp+A95,$A$64:$B$65,FO_Bw,FO_mu,FO_C,FO_rw,FO_ModelS,FO_ct,FO_phi,FO_h,FO_ModelK)                                                                                                                                                                               | =PO.PTA.Horner.Ratio(FO_tp,A95)                                                                   | =LOG10(D95)                                                     | =FO_tp/D95                  | =FO_Pwf-B95                 | =PO.DCA.Diag.Bourdet.SemiLog($F$95:$F$125,$G$95:$G$125,F95,FO_L)  | =H95/G95   |                                     |                                        |                                                     | =0                                                    | =0                                                                |
| 96  | 0.0133                                                                                                                                                          | =C96                                                                                                                                                                                                                                                                           | =FO_Pi+PO.PTA.Pw.VW(FO_tp+A96,$A$64:$B$65,FO_Bw,FO_mu,FO_C,FO_rw,FO_ModelS,FO_ct,FO_phi,FO_h,FO_ModelK)                                                                                                                                                                               | =PO.PTA.Horner.Ratio(FO_tp,A96)                                                                   | =LOG10(D96)                                                     | =FO_tp/D96                  | =FO_Pwf-B96                 | =PO.DCA.Diag.Bourdet.SemiLog($F$95:$F$125,$G$95:$G$125,F96,FO_L)  | =H96/G96   |                                     |                                        |                                                     | =0                                                    | =0                                                                |
| 97  | 0.0178                                                                                                                                                          | =C97                                                                                                                                                                                                                                                                           | =FO_Pi+PO.PTA.Pw.VW(FO_tp+A97,$A$64:$B$65,FO_Bw,FO_mu,FO_C,FO_rw,FO_ModelS,FO_ct,FO_phi,FO_h,FO_ModelK)                                                                                                                                                                               | =PO.PTA.Horner.Ratio(FO_tp,A97)                                                                   | =LOG10(D97)                                                     | =FO_tp/D97                  | =FO_Pwf-B97                 | =PO.DCA.Diag.Bourdet.SemiLog($F$95:$F$125,$G$95:$G$125,F97,FO_L)  | =H97/G97   | =SLOPE(LN(H95:H99),LN(F95:F99))     | =STDEV.P(H95:H99)/AVERAGE(H95:H99)     | =IF(MAX(H96:H98)>(1+FO_Tol/2)*MAX(H95,H99),1,0)     | =IF(AND(ABS(J97)<=FO_Tol,K97<=FO_Tol/2,L97=0),1,0)    | =IF(AND(ABS(J97-FO_Half)<=FO_Tol,ABS(I97-FO_Half)<=FO_Tol),1,0)   |
| 98  | 0.0237                                                                                                                                                          | =C98                                                                                                                                                                                                                                                                           | =FO_Pi+PO.PTA.Pw.VW(FO_tp+A98,$A$64:$B$65,FO_Bw,FO_mu,FO_C,FO_rw,FO_ModelS,FO_ct,FO_phi,FO_h,FO_ModelK)                                                                                                                                                                               | =PO.PTA.Horner.Ratio(FO_tp,A98)                                                                   | =LOG10(D98)                                                     | =FO_tp/D98                  | =FO_Pwf-B98                 | =PO.DCA.Diag.Bourdet.SemiLog($F$95:$F$125,$G$95:$G$125,F98,FO_L)  | =H98/G98   | =SLOPE(LN(H96:H100),LN(F96:F100))   | =STDEV.P(H96:H100)/AVERAGE(H96:H100)   | =IF(MAX(H97:H99)>(1+FO_Tol/2)*MAX(H96,H100),1,0)    | =IF(AND(ABS(J98)<=FO_Tol,K98<=FO_Tol/2,L98=0),1,0)    | =IF(AND(ABS(J98-FO_Half)<=FO_Tol,ABS(I98-FO_Half)<=FO_Tol),1,0)   |
| 99  | 0.0316                                                                                                                                                          | =C99                                                                                                                                                                                                                                                                           | =FO_Pi+PO.PTA.Pw.VW(FO_tp+A99,$A$64:$B$65,FO_Bw,FO_mu,FO_C,FO_rw,FO_ModelS,FO_ct,FO_phi,FO_h,FO_ModelK)                                                                                                                                                                               | =PO.PTA.Horner.Ratio(FO_tp,A99)                                                                   | =LOG10(D99)                                                     | =FO_tp/D99                  | =FO_Pwf-B99                 | =PO.DCA.Diag.Bourdet.SemiLog($F$95:$F$125,$G$95:$G$125,F99,FO_L)  | =H99/G99   | =SLOPE(LN(H97:H101),LN(F97:F101))   | =STDEV.P(H97:H101)/AVERAGE(H97:H101)   | =IF(MAX(H98:H100)>(1+FO_Tol/2)*MAX(H97,H101),1,0)   | =IF(AND(ABS(J99)<=FO_Tol,K99<=FO_Tol/2,L99=0),1,0)    | =IF(AND(ABS(J99-FO_Half)<=FO_Tol,ABS(I99-FO_Half)<=FO_Tol),1,0)   |
| 100 | 0.0422                                                                                                                                                          | =C100                                                                                                                                                                                                                                                                          | =FO_Pi+PO.PTA.Pw.VW(FO_tp+A100,$A$64:$B$65,FO_Bw,FO_mu,FO_C,FO_rw,FO_ModelS,FO_ct,FO_phi,FO_h,FO_ModelK)                                                                                                                                                                              | =PO.PTA.Horner.Ratio(FO_tp,A100)                                                                  | =LOG10(D100)                                                    | =FO_tp/D100                 | =FO_Pwf-B100                | =PO.DCA.Diag.Bourdet.SemiLog($F$95:$F$125,$G$95:$G$125,F100,FO_L) | =H100/G100 | =SLOPE(LN(H98:H102),LN(F98:F102))   | =STDEV.P(H98:H102)/AVERAGE(H98:H102)   | =IF(MAX(H99:H101)>(1+FO_Tol/2)*MAX(H98,H102),1,0)   | =IF(AND(ABS(J100)<=FO_Tol,K100<=FO_Tol/2,L100=0),1,0) | =IF(AND(ABS(J100-FO_Half)<=FO_Tol,ABS(I100-FO_Half)<=FO_Tol),1,0) |
| 101 | 0.0562                                                                                                                                                          | =C101                                                                                                                                                                                                                                                                          | =FO_Pi+PO.PTA.Pw.VW(FO_tp+A101,$A$64:$B$65,FO_Bw,FO_mu,FO_C,FO_rw,FO_ModelS,FO_ct,FO_phi,FO_h,FO_ModelK)                                                                                                                                                                              | =PO.PTA.Horner.Ratio(FO_tp,A101)                                                                  | =LOG10(D101)                                                    | =FO_tp/D101                 | =FO_Pwf-B101                | =PO.DCA.Diag.Bourdet.SemiLog($F$95:$F$125,$G$95:$G$125,F101,FO_L) | =H101/G101 | =SLOPE(LN(H99:H103),LN(F99:F103))   | =STDEV.P(H99:H103)/AVERAGE(H99:H103)   | =IF(MAX(H100:H102)>(1+FO_Tol/2)*MAX(H99,H103),1,0)  | =IF(AND(ABS(J101)<=FO_Tol,K101<=FO_Tol/2,L101=0),1,0) | =IF(AND(ABS(J101-FO_Half)<=FO_Tol,ABS(I101-FO_Half)<=FO_Tol),1,0) |
| 102 | 0.075                                                                                                                                                           | =C102                                                                                                                                                                                                                                                                          | =FO_Pi+PO.PTA.Pw.VW(FO_tp+A102,$A$64:$B$65,FO_Bw,FO_mu,FO_C,FO_rw,FO_ModelS,FO_ct,FO_phi,FO_h,FO_ModelK)                                                                                                                                                                              | =PO.PTA.Horner.Ratio(FO_tp,A102)                                                                  | =LOG10(D102)                                                    | =FO_tp/D102                 | =FO_Pwf-B102                | =PO.DCA.Diag.Bourdet.SemiLog($F$95:$F$125,$G$95:$G$125,F102,FO_L) | =H102/G102 | =SLOPE(LN(H100:H104),LN(F100:F104)) | =STDEV.P(H100:H104)/AVERAGE(H100:H104) | =IF(MAX(H101:H103)>(1+FO_Tol/2)*MAX(H100,H104),1,0) | =IF(AND(ABS(J102)<=FO_Tol,K102<=FO_Tol/2,L102=0),1,0) | =IF(AND(ABS(J102-FO_Half)<=FO_Tol,ABS(I102-FO_Half)<=FO_Tol),1,0) |
| 103 | 0.1                                                                                                                                                             | =C103                                                                                                                                                                                                                                                                          | =FO_Pi+PO.PTA.Pw.VW(FO_tp+A103,$A$64:$B$65,FO_Bw,FO_mu,FO_C,FO_rw,FO_ModelS,FO_ct,FO_phi,FO_h,FO_ModelK)                                                                                                                                                                              | =PO.PTA.Horner.Ratio(FO_tp,A103)                                                                  | =LOG10(D103)                                                    | =FO_tp/D103                 | =FO_Pwf-B103                | =PO.DCA.Diag.Bourdet.SemiLog($F$95:$F$125,$G$95:$G$125,F103,FO_L) | =H103/G103 | =SLOPE(LN(H101:H105),LN(F101:F105)) | =STDEV.P(H101:H105)/AVERAGE(H101:H105) | =IF(MAX(H102:H104)>(1+FO_Tol/2)*MAX(H101,H105),1,0) | =IF(AND(ABS(J103)<=FO_Tol,K103<=FO_Tol/2,L103=0),1,0) | =IF(AND(ABS(J103-FO_Half)<=FO_Tol,ABS(I103-FO_Half)<=FO_Tol),1,0) |
| 104 | 0.133                                                                                                                                                           | =C104                                                                                                                                                                                                                                                                          | =FO_Pi+PO.PTA.Pw.VW(FO_tp+A104,$A$64:$B$65,FO_Bw,FO_mu,FO_C,FO_rw,FO_ModelS,FO_ct,FO_phi,FO_h,FO_ModelK)                                                                                                                                                                              | =PO.PTA.Horner.Ratio(FO_tp,A104)                                                                  | =LOG10(D104)                                                    | =FO_tp/D104                 | =FO_Pwf-B104                | =PO.DCA.Diag.Bourdet.SemiLog($F$95:$F$125,$G$95:$G$125,F104,FO_L) | =H104/G104 | =SLOPE(LN(H102:H106),LN(F102:F106)) | =STDEV.P(H102:H106)/AVERAGE(H102:H106) | =IF(MAX(H103:H105)>(1+FO_Tol/2)*MAX(H102,H106),1,0) | =IF(AND(ABS(J104)<=FO_Tol,K104<=FO_Tol/2,L104=0),1,0) | =IF(AND(ABS(J104-FO_Half)<=FO_Tol,ABS(I104-FO_Half)<=FO_Tol),1,0) |
| 105 | 0.178                                                                                                                                                           | =C105                                                                                                                                                                                                                                                                          | =FO_Pi+PO.PTA.Pw.VW(FO_tp+A105,$A$64:$B$65,FO_Bw,FO_mu,FO_C,FO_rw,FO_ModelS,FO_ct,FO_phi,FO_h,FO_ModelK)                                                                                                                                                                              | =PO.PTA.Horner.Ratio(FO_tp,A105)                                                                  | =LOG10(D105)                                                    | =FO_tp/D105                 | =FO_Pwf-B105                | =PO.DCA.Diag.Bourdet.SemiLog($F$95:$F$125,$G$95:$G$125,F105,FO_L) | =H105/G105 | =SLOPE(LN(H103:H107),LN(F103:F107)) | =STDEV.P(H103:H107)/AVERAGE(H103:H107) | =IF(MAX(H104:H106)>(1+FO_Tol/2)*MAX(H103,H107),1,0) | =IF(AND(ABS(J105)<=FO_Tol,K105<=FO_Tol/2,L105=0),1,0) | =IF(AND(ABS(J105-FO_Half)<=FO_Tol,ABS(I105-FO_Half)<=FO_Tol),1,0) |
| 106 | 0.237                                                                                                                                                           | =C106                                                                                                                                                                                                                                                                          | =FO_Pi+PO.PTA.Pw.VW(FO_tp+A106,$A$64:$B$65,FO_Bw,FO_mu,FO_C,FO_rw,FO_ModelS,FO_ct,FO_phi,FO_h,FO_ModelK)                                                                                                                                                                              | =PO.PTA.Horner.Ratio(FO_tp,A106)                                                                  | =LOG10(D106)                                                    | =FO_tp/D106                 | =FO_Pwf-B106                | =PO.DCA.Diag.Bourdet.SemiLog($F$95:$F$125,$G$95:$G$125,F106,FO_L) | =H106/G106 | =SLOPE(LN(H104:H108),LN(F104:F108)) | =STDEV.P(H104:H108)/AVERAGE(H104:H108) | =IF(MAX(H105:H107)>(1+FO_Tol/2)*MAX(H104,H108),1,0) | =IF(AND(ABS(J106)<=FO_Tol,K106<=FO_Tol/2,L106=0),1,0) | =IF(AND(ABS(J106-FO_Half)<=FO_Tol,ABS(I106-FO_Half)<=FO_Tol),1,0) |
| 107 | 0.316                                                                                                                                                           | =C107                                                                                                                                                                                                                                                                          | =FO_Pi+PO.PTA.Pw.VW(FO_tp+A107,$A$64:$B$65,FO_Bw,FO_mu,FO_C,FO_rw,FO_ModelS,FO_ct,FO_phi,FO_h,FO_ModelK)                                                                                                                                                                              | =PO.PTA.Horner.Ratio(FO_tp,A107)                                                                  | =LOG10(D107)                                                    | =FO_tp/D107                 | =FO_Pwf-B107                | =PO.DCA.Diag.Bourdet.SemiLog($F$95:$F$125,$G$95:$G$125,F107,FO_L) | =H107/G107 | =SLOPE(LN(H105:H109),LN(F105:F109)) | =STDEV.P(H105:H109)/AVERAGE(H105:H109) | =IF(MAX(H106:H108)>(1+FO_Tol/2)*MAX(H105,H109),1,0) | =IF(AND(ABS(J107)<=FO_Tol,K107<=FO_Tol/2,L107=0),1,0) | =IF(AND(ABS(J107-FO_Half)<=FO_Tol,ABS(I107-FO_Half)<=FO_Tol),1,0) |
| 108 | 0.422                                                                                                                                                           | =C108                                                                                                                                                                                                                                                                          | =FO_Pi+PO.PTA.Pw.VW(FO_tp+A108,$A$64:$B$65,FO_Bw,FO_mu,FO_C,FO_rw,FO_ModelS,FO_ct,FO_phi,FO_h,FO_ModelK)                                                                                                                                                                              | =PO.PTA.Horner.Ratio(FO_tp,A108)                                                                  | =LOG10(D108)                                                    | =FO_tp/D108                 | =FO_Pwf-B108                | =PO.DCA.Diag.Bourdet.SemiLog($F$95:$F$125,$G$95:$G$125,F108,FO_L) | =H108/G108 | =SLOPE(LN(H106:H110),LN(F106:F110)) | =STDEV.P(H106:H110)/AVERAGE(H106:H110) | =IF(MAX(H107:H109)>(1+FO_Tol/2)*MAX(H106,H110),1,0) | =IF(AND(ABS(J108)<=FO_Tol,K108<=FO_Tol/2,L108=0),1,0) | =IF(AND(ABS(J108-FO_Half)<=FO_Tol,ABS(I108-FO_Half)<=FO_Tol),1,0) |
| 109 | 0.562                                                                                                                                                           | =C109                                                                                                                                                                                                                                                                          | =FO_Pi+PO.PTA.Pw.VW(FO_tp+A109,$A$64:$B$65,FO_Bw,FO_mu,FO_C,FO_rw,FO_ModelS,FO_ct,FO_phi,FO_h,FO_ModelK)                                                                                                                                                                              | =PO.PTA.Horner.Ratio(FO_tp,A109)                                                                  | =LOG10(D109)                                                    | =FO_tp/D109                 | =FO_Pwf-B109                | =PO.DCA.Diag.Bourdet.SemiLog($F$95:$F$125,$G$95:$G$125,F109,FO_L) | =H109/G109 | =SLOPE(LN(H107:H111),LN(F107:F111)) | =STDEV.P(H107:H111)/AVERAGE(H107:H111) | =IF(MAX(H108:H110)>(1+FO_Tol/2)*MAX(H107,H111),1,0) | =IF(AND(ABS(J109)<=FO_Tol,K109<=FO_Tol/2,L109=0),1,0) | =IF(AND(ABS(J109-FO_Half)<=FO_Tol,ABS(I109-FO_Half)<=FO_Tol),1,0) |
| 110 | 0.75                                                                                                                                                            | =C110                                                                                                                                                                                                                                                                          | =FO_Pi+PO.PTA.Pw.VW(FO_tp+A110,$A$64:$B$65,FO_Bw,FO_mu,FO_C,FO_rw,FO_ModelS,FO_ct,FO_phi,FO_h,FO_ModelK)                                                                                                                                                                              | =PO.PTA.Horner.Ratio(FO_tp,A110)                                                                  | =LOG10(D110)                                                    | =FO_tp/D110                 | =FO_Pwf-B110                | =PO.DCA.Diag.Bourdet.SemiLog($F$95:$F$125,$G$95:$G$125,F110,FO_L) | =H110/G110 | =SLOPE(LN(H108:H112),LN(F108:F112)) | =STDEV.P(H108:H112)/AVERAGE(H108:H112) | =IF(MAX(H109:H111)>(1+FO_Tol/2)*MAX(H108,H112),1,0) | =IF(AND(ABS(J110)<=FO_Tol,K110<=FO_Tol/2,L110=0),1,0) | =IF(AND(ABS(J110-FO_Half)<=FO_Tol,ABS(I110-FO_Half)<=FO_Tol),1,0) |
| 111 | 1                                                                                                                                                               | =C111                                                                                                                                                                                                                                                                          | =FO_Pi+PO.PTA.Pw.VW(FO_tp+A111,$A$64:$B$65,FO_Bw,FO_mu,FO_C,FO_rw,FO_ModelS,FO_ct,FO_phi,FO_h,FO_ModelK)                                                                                                                                                                              | =PO.PTA.Horner.Ratio(FO_tp,A111)                                                                  | =LOG10(D111)                                                    | =FO_tp/D111                 | =FO_Pwf-B111                | =PO.DCA.Diag.Bourdet.SemiLog($F$95:$F$125,$G$95:$G$125,F111,FO_L) | =H111/G111 | =SLOPE(LN(H109:H113),LN(F109:F113)) | =STDEV.P(H109:H113)/AVERAGE(H109:H113) | =IF(MAX(H110:H112)>(1+FO_Tol/2)*MAX(H109,H113),1,0) | =IF(AND(ABS(J111)<=FO_Tol,K111<=FO_Tol/2,L111=0),1,0) | =IF(AND(ABS(J111-FO_Half)<=FO_Tol,ABS(I111-FO_Half)<=FO_Tol),1,0) |
| 112 | 1.33                                                                                                                                                            | =C112                                                                                                                                                                                                                                                                          | =FO_Pi+PO.PTA.Pw.VW(FO_tp+A112,$A$64:$B$65,FO_Bw,FO_mu,FO_C,FO_rw,FO_ModelS,FO_ct,FO_phi,FO_h,FO_ModelK)                                                                                                                                                                              | =PO.PTA.Horner.Ratio(FO_tp,A112)                                                                  | =LOG10(D112)                                                    | =FO_tp/D112                 | =FO_Pwf-B112                | =PO.DCA.Diag.Bourdet.SemiLog($F$95:$F$125,$G$95:$G$125,F112,FO_L) | =H112/G112 | =SLOPE(LN(H110:H114),LN(F110:F114)) | =STDEV.P(H110:H114)/AVERAGE(H110:H114) | =IF(MAX(H111:H113)>(1+FO_Tol/2)*MAX(H110,H114),1,0) | =IF(AND(ABS(J112)<=FO_Tol,K112<=FO_Tol/2,L112=0),1,0) | =IF(AND(ABS(J112-FO_Half)<=FO_Tol,ABS(I112-FO_Half)<=FO_Tol),1,0) |
| 113 | 1.78                                                                                                                                                            | =C113                                                                                                                                                                                                                                                                          | =FO_Pi+PO.PTA.Pw.VW(FO_tp+A113,$A$64:$B$65,FO_Bw,FO_mu,FO_C,FO_rw,FO_ModelS,FO_ct,FO_phi,FO_h,FO_ModelK)                                                                                                                                                                              | =PO.PTA.Horner.Ratio(FO_tp,A113)                                                                  | =LOG10(D113)                                                    | =FO_tp/D113                 | =FO_Pwf-B113                | =PO.DCA.Diag.Bourdet.SemiLog($F$95:$F$125,$G$95:$G$125,F113,FO_L) | =H113/G113 | =SLOPE(LN(H111:H115),LN(F111:F115)) | =STDEV.P(H111:H115)/AVERAGE(H111:H115) | =IF(MAX(H112:H114)>(1+FO_Tol/2)*MAX(H111,H115),1,0) | =IF(AND(ABS(J113)<=FO_Tol,K113<=FO_Tol/2,L113=0),1,0) | =IF(AND(ABS(J113-FO_Half)<=FO_Tol,ABS(I113-FO_Half)<=FO_Tol),1,0) |
| 114 | 2.37                                                                                                                                                            | =C114                                                                                                                                                                                                                                                                          | =FO_Pi+PO.PTA.Pw.VW(FO_tp+A114,$A$64:$B$65,FO_Bw,FO_mu,FO_C,FO_rw,FO_ModelS,FO_ct,FO_phi,FO_h,FO_ModelK)                                                                                                                                                                              | =PO.PTA.Horner.Ratio(FO_tp,A114)                                                                  | =LOG10(D114)                                                    | =FO_tp/D114                 | =FO_Pwf-B114                | =PO.DCA.Diag.Bourdet.SemiLog($F$95:$F$125,$G$95:$G$125,F114,FO_L) | =H114/G114 | =SLOPE(LN(H112:H116),LN(F112:F116)) | =STDEV.P(H112:H116)/AVERAGE(H112:H116) | =IF(MAX(H113:H115)>(1+FO_Tol/2)*MAX(H112,H116),1,0) | =IF(AND(ABS(J114)<=FO_Tol,K114<=FO_Tol/2,L114=0),1,0) | =IF(AND(ABS(J114-FO_Half)<=FO_Tol,ABS(I114-FO_Half)<=FO_Tol),1,0) |
| 115 | 3.16                                                                                                                                                            | =C115                                                                                                                                                                                                                                                                          | =FO_Pi+PO.PTA.Pw.VW(FO_tp+A115,$A$64:$B$65,FO_Bw,FO_mu,FO_C,FO_rw,FO_ModelS,FO_ct,FO_phi,FO_h,FO_ModelK)                                                                                                                                                                              | =PO.PTA.Horner.Ratio(FO_tp,A115)                                                                  | =LOG10(D115)                                                    | =FO_tp/D115                 | =FO_Pwf-B115                | =PO.DCA.Diag.Bourdet.SemiLog($F$95:$F$125,$G$95:$G$125,F115,FO_L) | =H115/G115 | =SLOPE(LN(H113:H117),LN(F113:F117)) | =STDEV.P(H113:H117)/AVERAGE(H113:H117) | =IF(MAX(H114:H116)>(1+FO_Tol/2)*MAX(H113,H117),1,0) | =IF(AND(ABS(J115)<=FO_Tol,K115<=FO_Tol/2,L115=0),1,0) | =IF(AND(ABS(J115-FO_Half)<=FO_Tol,ABS(I115-FO_Half)<=FO_Tol),1,0) |
| 116 | 4.22                                                                                                                                                            | =C116                                                                                                                                                                                                                                                                          | =FO_Pi+PO.PTA.Pw.VW(FO_tp+A116,$A$64:$B$65,FO_Bw,FO_mu,FO_C,FO_rw,FO_ModelS,FO_ct,FO_phi,FO_h,FO_ModelK)                                                                                                                                                                              | =PO.PTA.Horner.Ratio(FO_tp,A116)                                                                  | =LOG10(D116)                                                    | =FO_tp/D116                 | =FO_Pwf-B116                | =PO.DCA.Diag.Bourdet.SemiLog($F$95:$F$125,$G$95:$G$125,F116,FO_L) | =H116/G116 | =SLOPE(LN(H114:H118),LN(F114:F118)) | =STDEV.P(H114:H118)/AVERAGE(H114:H118) | =IF(MAX(H115:H117)>(1+FO_Tol/2)*MAX(H114,H118),1,0) | =IF(AND(ABS(J116)<=FO_Tol,K116<=FO_Tol/2,L116=0),1,0) | =IF(AND(ABS(J116-FO_Half)<=FO_Tol,ABS(I116-FO_Half)<=FO_Tol),1,0) |
| 117 | 5.62                                                                                                                                                            | =C117                                                                                                                                                                                                                                                                          | =FO_Pi+PO.PTA.Pw.VW(FO_tp+A117,$A$64:$B$65,FO_Bw,FO_mu,FO_C,FO_rw,FO_ModelS,FO_ct,FO_phi,FO_h,FO_ModelK)                                                                                                                                                                              | =PO.PTA.Horner.Ratio(FO_tp,A117)                                                                  | =LOG10(D117)                                                    | =FO_tp/D117                 | =FO_Pwf-B117                | =PO.DCA.Diag.Bourdet.SemiLog($F$95:$F$125,$G$95:$G$125,F117,FO_L) | =H117/G117 | =SLOPE(LN(H115:H119),LN(F115:F119)) | =STDEV.P(H115:H119)/AVERAGE(H115:H119) | =IF(MAX(H116:H118)>(1+FO_Tol/2)*MAX(H115,H119),1,0) | =IF(AND(ABS(J117)<=FO_Tol,K117<=FO_Tol/2,L117=0),1,0) | =IF(AND(ABS(J117-FO_Half)<=FO_Tol,ABS(I117-FO_Half)<=FO_Tol),1,0) |
| 118 | 7.5                                                                                                                                                             | =C118                                                                                                                                                                                                                                                                          | =FO_Pi+PO.PTA.Pw.VW(FO_tp+A118,$A$64:$B$65,FO_Bw,FO_mu,FO_C,FO_rw,FO_ModelS,FO_ct,FO_phi,FO_h,FO_ModelK)                                                                                                                                                                              | =PO.PTA.Horner.Ratio(FO_tp,A118)                                                                  | =LOG10(D118)                                                    | =FO_tp/D118                 | =FO_Pwf-B118                | =PO.DCA.Diag.Bourdet.SemiLog($F$95:$F$125,$G$95:$G$125,F118,FO_L) | =H118/G118 | =SLOPE(LN(H116:H120),LN(F116:F120)) | =STDEV.P(H116:H120)/AVERAGE(H116:H120) | =IF(MAX(H117:H119)>(1+FO_Tol/2)*MAX(H116,H120),1,0) | =IF(AND(ABS(J118)<=FO_Tol,K118<=FO_Tol/2,L118=0),1,0) | =IF(AND(ABS(J118-FO_Half)<=FO_Tol,ABS(I118-FO_Half)<=FO_Tol),1,0) |
| 119 | 10                                                                                                                                                              | =C119                                                                                                                                                                                                                                                                          | =FO_Pi+PO.PTA.Pw.VW(FO_tp+A119,$A$64:$B$65,FO_Bw,FO_mu,FO_C,FO_rw,FO_ModelS,FO_ct,FO_phi,FO_h,FO_ModelK)                                                                                                                                                                              | =PO.PTA.Horner.Ratio(FO_tp,A119)                                                                  | =LOG10(D119)                                                    | =FO_tp/D119                 | =FO_Pwf-B119                | =PO.DCA.Diag.Bourdet.SemiLog($F$95:$F$125,$G$95:$G$125,F119,FO_L) | =H119/G119 | =SLOPE(LN(H117:H121),LN(F117:F121)) | =STDEV.P(H117:H121)/AVERAGE(H117:H121) | =IF(MAX(H118:H120)>(1+FO_Tol/2)*MAX(H117,H121),1,0) | =IF(AND(ABS(J119)<=FO_Tol,K119<=FO_Tol/2,L119=0),1,0) | =IF(AND(ABS(J119-FO_Half)<=FO_Tol,ABS(I119-FO_Half)<=FO_Tol),1,0) |
| 120 | 13.3                                                                                                                                                            | =C120                                                                                                                                                                                                                                                                          | =FO_Pi+PO.PTA.Pw.VW(FO_tp+A120,$A$64:$B$65,FO_Bw,FO_mu,FO_C,FO_rw,FO_ModelS,FO_ct,FO_phi,FO_h,FO_ModelK)                                                                                                                                                                              | =PO.PTA.Horner.Ratio(FO_tp,A120)                                                                  | =LOG10(D120)                                                    | =FO_tp/D120                 | =FO_Pwf-B120                | =PO.DCA.Diag.Bourdet.SemiLog($F$95:$F$125,$G$95:$G$125,F120,FO_L) | =H120/G120 | =SLOPE(LN(H118:H122),LN(F118:F122)) | =STDEV.P(H118:H122)/AVERAGE(H118:H122) | =IF(MAX(H119:H121)>(1+FO_Tol/2)*MAX(H118,H122),1,0) | =IF(AND(ABS(J120)<=FO_Tol,K120<=FO_Tol/2,L120=0),1,0) | =IF(AND(ABS(J120-FO_Half)<=FO_Tol,ABS(I120-FO_Half)<=FO_Tol),1,0) |
| 121 | 17.8                                                                                                                                                            | =C121                                                                                                                                                                                                                                                                          | =FO_Pi+PO.PTA.Pw.VW(FO_tp+A121,$A$64:$B$65,FO_Bw,FO_mu,FO_C,FO_rw,FO_ModelS,FO_ct,FO_phi,FO_h,FO_ModelK)                                                                                                                                                                              | =PO.PTA.Horner.Ratio(FO_tp,A121)                                                                  | =LOG10(D121)                                                    | =FO_tp/D121                 | =FO_Pwf-B121                | =PO.DCA.Diag.Bourdet.SemiLog($F$95:$F$125,$G$95:$G$125,F121,FO_L) | =H121/G121 | =SLOPE(LN(H119:H123),LN(F119:F123)) | =STDEV.P(H119:H123)/AVERAGE(H119:H123) | =IF(MAX(H120:H122)>(1+FO_Tol/2)*MAX(H119,H123),1,0) | =IF(AND(ABS(J121)<=FO_Tol,K121<=FO_Tol/2,L121=0),1,0) | =IF(AND(ABS(J121-FO_Half)<=FO_Tol,ABS(I121-FO_Half)<=FO_Tol),1,0) |
| 122 | 23.7                                                                                                                                                            | =C122                                                                                                                                                                                                                                                                          | =FO_Pi+PO.PTA.Pw.VW(FO_tp+A122,$A$64:$B$65,FO_Bw,FO_mu,FO_C,FO_rw,FO_ModelS,FO_ct,FO_phi,FO_h,FO_ModelK)                                                                                                                                                                              | =PO.PTA.Horner.Ratio(FO_tp,A122)                                                                  | =LOG10(D122)                                                    | =FO_tp/D122                 | =FO_Pwf-B122                | =PO.DCA.Diag.Bourdet.SemiLog($F$95:$F$125,$G$95:$G$125,F122,FO_L) | =H122/G122 | =SLOPE(LN(H120:H124),LN(F120:F124)) | =STDEV.P(H120:H124)/AVERAGE(H120:H124) | =IF(MAX(H121:H123)>(1+FO_Tol/2)*MAX(H120,H124),1,0) | =IF(AND(ABS(J122)<=FO_Tol,K122<=FO_Tol/2,L122=0),1,0) | =IF(AND(ABS(J122-FO_Half)<=FO_Tol,ABS(I122-FO_Half)<=FO_Tol),1,0) |
| 123 | 31.6                                                                                                                                                            | =C123                                                                                                                                                                                                                                                                          | =FO_Pi+PO.PTA.Pw.VW(FO_tp+A123,$A$64:$B$65,FO_Bw,FO_mu,FO_C,FO_rw,FO_ModelS,FO_ct,FO_phi,FO_h,FO_ModelK)                                                                                                                                                                              | =PO.PTA.Horner.Ratio(FO_tp,A123)                                                                  | =LOG10(D123)                                                    | =FO_tp/D123                 | =FO_Pwf-B123                | =PO.DCA.Diag.Bourdet.SemiLog($F$95:$F$125,$G$95:$G$125,F123,FO_L) | =H123/G123 | =SLOPE(LN(H121:H125),LN(F121:F125)) | =STDEV.P(H121:H125)/AVERAGE(H121:H125) | =IF(MAX(H122:H124)>(1+FO_Tol/2)*MAX(H121,H125),1,0) | =IF(AND(ABS(J123)<=FO_Tol,K123<=FO_Tol/2,L123=0),1,0) | =IF(AND(ABS(J123-FO_Half)<=FO_Tol,ABS(I123-FO_Half)<=FO_Tol),1,0) |
| 124 | 42.2                                                                                                                                                            | =C124                                                                                                                                                                                                                                                                          | =FO_Pi+PO.PTA.Pw.VW(FO_tp+A124,$A$64:$B$65,FO_Bw,FO_mu,FO_C,FO_rw,FO_ModelS,FO_ct,FO_phi,FO_h,FO_ModelK)                                                                                                                                                                              | =PO.PTA.Horner.Ratio(FO_tp,A124)                                                                  | =LOG10(D124)                                                    | =FO_tp/D124                 | =FO_Pwf-B124                | =PO.DCA.Diag.Bourdet.SemiLog($F$95:$F$125,$G$95:$G$125,F124,FO_L) | =H124/G124 |                                     |                                        |                                                     | =0                                                    | =0                                                                |
| 125 | 48                                                                                                                                                              | =C125                                                                                                                                                                                                                                                                          | =FO_Pi+PO.PTA.Pw.VW(FO_tp+A125,$A$64:$B$65,FO_Bw,FO_mu,FO_C,FO_rw,FO_ModelS,FO_ct,FO_phi,FO_h,FO_ModelK)                                                                                                                                                                              | =PO.PTA.Horner.Ratio(FO_tp,A125)                                                                  | =LOG10(D125)                                                    | =FO_tp/D125                 | =FO_Pwf-B125                | =PO.DCA.Diag.Bourdet.SemiLog($F$95:$F$125,$G$95:$G$125,F125,FO_L) | =H125/G125 |                                     |                                        |                                                     | =0                                                    | =0                                                                |

## Lambdas

| Name | RefersTo | Comment |
|------|----------|---------|
| PO.PTA.MDH.Fit | =LAMBDA(t, dp, q, B, mu, h, phi, ct, rw, output, LET(x, LOG10(t), m, SLOPE(dp, x), dp_1h, INTERCEPT(dp, x), perm, 162.6*q*B*mu/(m*h), skin, 1.151*(dp_1h/m-LOG10(perm/(phi*mu*ct*rw^2))+3.23), IF(m<=0, NA(), IF(output="k", perm, IF(output="S", skin, IF(output="m", m, IF(output="dp1h", dp_1h, NA()))))))) | MDH semilog straight-line fit of a drawdown: least squares of Δp against log10(t) over the points given; output "k" [mD], "S" [dimensionless], "m" [psi/cycle] or "dp1h" [psi], the line's Δp at 1 h. |
| PO.PTA.StepRate.Fit | =LAMBDA(q, p, nlow, output, LET(cnt, ROWS(q), qa, AVERAGE(q), pa, AVERAGE(p), qc, q-qa, pc, p-pa, ix, SEQUENCE(cnt), kk, SEQUENCE(cnt-3, 1, 2), msk, --(TRANSPOSE(ix)<=kk), nlo, kk, nhi, cnt-kk, sxlo, MMULT(msk, qc), sylo, MMULT(msk, pc), sxxlo, MMULT(msk, qc^2), sxylo, MMULT(msk, qc*pc), syylo, MMULT(msk, pc^2), sxhi, SUM(qc)-sxlo, syhi, SUM(pc)-sylo, sxxhi, SUM(qc^2)-sxxlo, sxyhi, SUM(qc*pc)-sxylo, syyhi, SUM(pc^2)-syylo, cxxlo, sxxlo-sxlo^2/nlo, cxylo, sxylo-sxlo*sylo/nlo, cxxhi, sxxhi-sxhi^2/nhi, cxyhi, sxyhi-sxhi*syhi/nhi, sse, syylo-sylo^2/nlo-cxylo^2/cxxlo+syyhi-syhi^2/nhi-cxyhi^2/cxxhi, pick, IF(nlow>0, nlow, MIN(IF(sse=MIN(sse), kk, cnt))), sel, --(kk=pick), slo, SUM(sel*cxylo/cxxlo), shi, SUM(sel*cxyhi/cxxhi), ilo, SUM(sel*(sylo-slo*sxlo)/nlo), ihi, SUM(sel*(syhi-shi*sxhi)/nhi), qx, IF(slo>shi, (ihi-ilo)/(slo-shi), 0), IF(OR(cnt<5, nlow<0, nlow=1, nlow>cnt-2, slo<=shi), NA(), IF(output="p", pa+ilo+slo*qx, IF(output="q", qa+qx, IF(output="mlo", slo, IF(output="mhi", shi, IF(output="n", pick, NA())))))))) | Two-line step-rate test fit: least squares of the matrix and the fracture lines, split at nlow points (0 picks the split of least total squared error); output "p" extension pressure, "q" extension rate, "mlo", "mhi" slopes or "n" split. |

## Names

| Name | RefersTo | Comment |
|------|----------|---------|
| FO_q | $B$4 | Injection rate before shut-in, q, STB/d |
| FO_tp | $B$5 | Injection time before shut-in, tp, hr |
| FO_Bw | $B$6 | Water formation volume factor, Bw, bbl/STB |
| FO_mu | $B$7 | Water viscosity, μw, cp |
| FO_phi | $B$8 | Porosity, φ, % |
| FO_ct | $B$9 | Total compressibility, ct, 1/psi |
| FO_rw | $B$10 | Wellbore radius, rw, ft |
| FO_h | $B$11 | Net pay, h, ft |
| FO_Pwf | $B$12 | Injection pressure at shut-in, pwf, psi |
| FO_L | $B$14 | Bourdet smoothing window, L, cycles |
| FO_Tol | $B$15 | Slope tolerance about 0 (radial) and ½ (fracture) |
| FO_KTol | $B$16 | Round trip: k recovered within ±, % |
| FO_nlow | $B$18 | Steps on the matrix line (0 picks the best split) |
| FO_StepHr | $B$19 | Length of each rate step, hr |
| FO_ModelK | $B$21 | Model permeability, mD |
| FO_ModelS | $B$22 | Model skin factor |
| FO_Pi | $B$23 | Initial reservoir pressure, pi, psi |
| FO_C | $B$24 | Wellbore storage coefficient, C, bbl/psi |
| FO_ModelPfe | $B$25 | Model fracture extension pressure, psi |
| FO_Frac | $B$26 | Above it, the rise as a fraction of the matrix's |
| FO_Inputs | $B$4:$B$26 | Rate, injection time, water and rock, the pressure at shut-in, the window settings, the step-rate split and step length, and the synthetic model |
| FO_PwfModel | $B$29 | Model injection pressure at shut-in, psi |
| FO_RadStart | $B$30 | Radial flow (flat derivative) starts at Δt, hr |
| FO_RadEnd | $B$31 | Radial flow ends at Δt (its first run), hr |
| FO_NRad | $B$32 | Points in the radial window |
| FO_M | $B$33 | Semilog slope on Agarwal's te, m, psi/cycle |
| FO_Dp1h | $B$34 | Line's Δp at te = 1 hr, psi |
| FO_K | $B$35 | Permeability, k, mD |
| FO_Kh | $B$36 | Permeability-thickness, kh, mD·ft |
| FO_S | $B$37 | Skin factor, S |
| FO_Pstar | $B$38 | Horner line's p* (ratio of 1), psi |
| FO_Pavg | $B$39 | Average pressure, p̄ (p* while infinite-acting), psi |
| FO_II | $B$40 | Injectivity index, q/(pwf − p̄), STB/d/psi |
| FO_NHalf | $B$41 | ½-slope (fracture) points before radial flow |
| FO_TClose | $B$42 | Last ½-slope point, closure near Δt, hr |
| FO_PClose | $B$43 | Pressure there, near closure, psi |
| FO_Pfe | $B$44 | Fracture extension pressure, psi |
| FO_Qfe | $B$45 | Fracture extension rate, STB/d |
| FO_MLo | $B$46 | Matrix line's slope, psi/(STB/d) |
| FO_MHi | $B$47 | Fracture line's slope, psi/(STB/d) |
| FO_NLo | $B$48 | Steps on the matrix line |
| FO_KErr | $B$49 | k against the model, % |
| FO_SErr | $B$50 | S against the model |
| FO_PErr | $B$51 | p̄ against pi, psi |
| FO_PfeErr | $B$52 | Extension pressure against the model's, psi |
| FO_WindowCheck | $B$53 | Radial window check verdict |
| FO_WindowCheckNote | $C$53 | Radial window check comment |
| FO_PartingCheck | $B$54 | Injection below parting check verdict |
| FO_PartingCheckNote | $C$54 | Injection below parting check comment |
| FO_ClosureCheck | $B$55 | Fracture-closure flag on the derivative verdict |
| FO_ClosureCheckNote | $C$55 | Fracture-closure flag on the derivative comment |
| FO_TripCheck | $B$56 | Round trip on the synthetic data verdict |
| FO_TripCheckNote | $C$56 | Round trip on the synthetic data comment |
| FO_Results | $B$29:$B$56 | The model pwf, the radial window, k, kh, S, p* and p̄, the injectivity, the closure flag, the step-rate fit, the round trip and the checks |
| FO_Half | $B$59 | Fracture linear-flow log-log slope |
| FO_MinN | $B$60 | Fewest points a line is fitted to |
| FO_Rates | $A$64:$B$65 | The model's rate steps: q from 0 to tp, then shut in |
| FO_Steps | $A$70:$B$77 | The step-rate test: each step's start and rate |
| FO_StepFit | $C$70:$G$77 | Each step's end, the matrix model's pressure, the step's pressure (the model's knee), and the two fitted lines |
| FO_Data | $A$95:$B$125 | The falloff: Δt since shut-in and the shut-in pressure (the synthetic model's until you paste a gauge's) |
| FO_Analysis | $C$95:$N$125 | Per row: the model pws, the Horner ratio, te, Δp, the Bourdet derivative, Δp's and the derivative's log-log slopes, scatter, the storage hump, and the radial and ½-slope flags |
| FO_Horner | $B$95:$D$125 | Horner Plot of the Falloff |

---

## Related Blueprints
- [Constant-Rate Drawdown Analysis (MDH)](/blueprint/po.pta.drawdown.analysis.md)
- [Interference and Pulse Test](/blueprint/po.pta.interference.test.md)
- [Horner Buildup Analysis](/blueprint/po.pta.horner.pstar.md)
- [Multi-Rate Drawdown (Odeh-Jones Superposition)](/blueprint/po.pta.multirate.test.md)
- [Buildup Boundary Signatures](/blueprint/po.pta.buildup.boundary.md)
- [Bourdet Derivative Diagnostic](/blueprint/po.pta.derivative.diagnostic.md)

