---
cid: po.bp.pta.derivative.diagnostic
hub: pta
tags: [Bourdet, derivative, log-log, flow-regime, wellbore-storage, bilinear-flow, linear-flow, radial-flow, boundary, well-testing]
facets: { discipline: reservoir, property: pressure-drop }
title: Bourdet Derivative Diagnostic
summary: "Picks a drawdown's flow regimes from its Bourdet derivative slope and fits each regime's straight line over its own points."
slug: po.pta.derivative.diagnostic
type: worksheet
---

# Bourdet Derivative Diagnostic

## Description

Which flow regimes does a drawdown show, and what does each one give? You paste the times and the pressure drop and set the rate and the fluid and rock. Every row's derivative slope is read against the classic regimes: 1 for wellbore storage, ¼ for bilinear flow in a finite-conductivity fracture, ½ for linear flow and 0 for infinite-acting radial flow. You read off the storage coefficient C, the fracture conductivity kf·w, the half-length xf, and k and skin, each from its regime's straight line over its own points, and a boundary from the late derivative.

**Parameters:**
- **Well and fluid**: the rate and the fluid and rock (`BD_q`, `BD_Bo`, `BD_mu`, `BD_phi`, `BD_ct`, `BD_rw`, `BD_h`)
- **Regime picking**: the Bourdet smoothing window (`BD_L`, 0.2), the slope tolerance about each regime's slope (`BD_Tol`, ±0.1), the least R² of a window's log-log line (`BD_R2`, 0.98), the late window (`BD_Span`, the last half log cycle), how close to twice the radial level a fault must be (`BD_RTol`, ±20 %), and the round-trip tolerance on k (`BD_KTol`, ±10 %)
- **Example data**: which of three data sets fills the Δp column (`BD_Case`), and the first one's model: k, skin, C and the fault distance (`BD_ModelK`, `BD_ModelS`, `BD_C`, `BD_Lb`)
- **Data**: Δt and Δp, the region `BD_Data`

**How to use it:** Paste the times and Δp = pi − pwf over columns A and B, and set the rate and the fluid and rock. For a buildup, paste Agarwal's equivalent time te and pws − pwf. Keep the table's rows or trim its formulas to your row count. The example columns C to E and the round-trip check then don't apply. A log-log plot draws Δp and its derivative. A second plot draws Δp's own log-log slope, the derivative over Δp, against time: 1 in storage, ½ in linear and ¼ in bilinear flow, and falling in radial flow.

**Method:** The derivative is Bourdet's dΔp/d ln t, with smoothing window L. Each row gets two slopes. Δp's own log-log slope is the derivative over Δp. The derivative's slope is the least-squares slope of ln(derivative) against ln t over the five rows centred on it (`SLOPE`, `RSQ`). A row is read as one of the regime slopes, written in the Regime slope column:

- **Radial flow (0)** when the derivative's slope is within ±Tol of 0, its R² is at least the least R² set or its five values scatter less than Tol/2 about their mean (a flat line has no R²), and the middle three don't stand above both ends by more than Tol/2 (that is the storage hump's top).
- **Linear (½)** or **bilinear (¼)** when both slopes are within ±Tol of ½ or ¼ and R² is at least the least R² set.
- **Storage (1)** when Δp's slope is within ±Tol of 1; any other row is −1.

Asking Δp's slope to agree as well is what keeps out the slopes the derivative only passes through. The storage hump's rising side crosses ½, and the step up to a fault's doubled level crosses ¼, but Δp's slope is near 0.8 and 0.05 there. Radial flow is the first unbroken run of radial rows. Storage, bilinear and linear points count only before it starts, and every row after it is the boundary's.

- **Regime lines.** Each regime's line is fitted over its rows only, by `FILTER`. C = q·B·Δt/(24·Δp), averaged over the storage points. The bilinear line is Δp against t^¼, so kf·w = [44.1·q·B·μ/(h·m)]²/√(φμct·k) (the bilinear-flow fit). The linear line is Δp against √t, so xf·√k = 4.064·q·B/(m·h)·√(μ/(φct)) (the square-root-of-time fit). The MDH line is Δp against log₁₀ t, so k = 162.6·q·B·μ/(m·h) and S = 1.151·[Δp1hr/m − log₁₀(k/(φμct·rw²)) + 3.23] (the MDH fit). The fracture fits take that k.
- **Boundary.** After radial flow, the late derivative's level and slope tell a boundary: twice the radial level is a sealing fault. Over the last half log cycle (the late window), the sheet reads the derivative's mean over the radial level and its log-log slope. It also fits a second semilog line, and where it crosses the MDH line at tx, a fault lies at √(0.000148·k·tx/(φμct)) (Gray).

**Example:** The well and fluid are the PTA reference well the buildup sheets share: 250 STB/d, Bo 1.25 bbl/STB, μ 1 cp, φ 20 %, ct 1.5 × 10⁻⁵ 1/psi, rw 0.354 ft and h 30 ft. Case 1, the default, is the Buildup Boundary Signatures sheet's well (k 50 mD, S 5, C 0.001 bbl/psi) 200 ft from a sealing fault, drawn down from 0.001 to 237 hr by the add-in's linear sealing-fault model. Four points from 0.00133 hr sit at unit slope and give C = 0.00107 bbl/psi. Radial flow runs from 0.562 to 2.37 hr, 6 points at a derivative of 15.51 psi. The MDH line gives m = 35.50 psi/cycle, so k = 47.72 mD and S = 4.51, 4.6 % and 0.49 below the model's, within ±10 %. The 16 points after it climb to 1.83 times the radial level, a sealing fault. The late line has m = 65.42 psi/cycle and crosses the MDH line at 13.9 hr, which puts the fault 181 ft away, 9.6 % short of the model's 200 ft. The Buildup Boundary Signatures sheet reads the same fault at 1.83 and 180 ft from its buildup. No bilinear or linear points are found.

Cases 2 and 3 are a hydraulically fractured well in the same well and fluid but 10 mD rock: a 100 ft fracture of finite conductivity (FCD = 2, kf·w = 2,000 md·ft) and of infinite conductivity. No PO function models a fractured well, so their Δp are typed from the Engineering library's fractured vertical-well model (no storage, no skin). In case 2, 23 points from 0.0133 to 7.5 hr are bilinear, with a slope of 140.9 psi/hr^¼. Radial flow from 17.8 to 133 hr gives k = 10.48 mD and S = −4.25, so kf·w = 1,895 md·ft, 5.2 % short of the model's. In case 3, 17 points from 0.00178 to 0.178 hr are linear, with a slope of 76.54 psi/√hr. Radial flow from 23.7 hr gives k = 10.48 mD and S = −4.84, so xf = 98.6 ft against the model's 100. Both skins are the fracture's: Cinco-Ley's equivalent radius gives −4.37 at FCD = 2, and Prats' xf/2 gives −4.95. The fits read 0.1 lower because the derivative is still 5 % under its level when the run starts, which also puts k 4.8 % high.

The sheet was checked against a standalone script that rebuilds the three data sets from the Engineering library's models (the vertical-well model with a linear sealing fault, and the fractured vertical-well model). It takes the library's Bourdet derivative, which equals the sheet's at every interior point, and applies the sheet's regime rule. For the lines it uses its own least squares with the library's buildup permeability-from-slope, Horner skin and fault distance from the intersection time. It reproduces every number above to 10⁻⁸. The library's own regime finders (a five-point window at ±0.1 and R² 0.98) return the same storage, radial and bilinear windows. They report each one two points wider at each end, the window's half-width, and drop the end points, where the library's derivative isn't defined. They also show what the Δp-slope test removes: a "linear" stretch on the storage hump and a "bilinear" one on the step to the fault in case 1. No printed example interprets a full derivative by regime with every input given, so the sheet is not compared with a published one.

## Validity

The slopes are the classic regimes of a vertical well, with or without a fracture, in a homogeneous reservoir. A dual-porosity dip, a composite reservoir or changing storage also bend the derivative, and the sheet then reads them as no regime or as the wrong one. The tolerance must stay below 0.125, or the bands of ¼ and 0 and of ½ and ¼ overlap: the settings check fails above it. The five-point window spans half a log cycle at eight points a cycle. Coarser data needs a wider tolerance, and noisy data a larger L.

Each regime needs a long enough window. Unit slope only holds before the skin is felt, so with skin 5 the storage points give C 7 % high. A radial run of under half a log cycle, as in case 1, gives k within 5 %. A finite-conductivity fracture leaves the ¼ slope before its FCD-driven end, so kf·w reads 5 % low. A boundary is read from the late level alone: twice the radial level is one sealing fault, a falling derivative a constant-pressure boundary, and a late slope of ½ or 1 a channel or a closed area. The sheet does not fit type curves of a fractured or horizontal well, nor regress the whole record.

Named alternatives: the Buildup Boundary Signatures sheet reads faults and constant-pressure boundaries from a buildup, and the Horner Buildup Analysis sheet reads k and skin from one. Type curves of a fractured vertical well (Gringarten's infinite-conductivity and uniform-flux fractures, and Cinco-Ley's finite conductivity) and of a horizontal well, and nonlinear regression of the whole record, read a regime's parameters together rather than from its straight line alone; the add-in has no functions for them.

## References

- 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. SPE-12777-PA.
- Bourdet, D. (2002). *Well Test Analysis: The Use of Advanced Interpretation Models*. Elsevier (the regimes' log-log slopes).
- Cinco-Ley, H. and Samaniego-V., F. (1981). Transient Pressure Analysis for Fractured Wells. *JPT* 33(9), 1749–1766. SPE-7490.
- Gringarten, A.C., Ramey, H.J. Jr. and Raghavan, R. (1974). Unsteady-State Pressure Distributions Created by a Well With a Single Infinite-Conductivity Vertical Fracture. *SPEJ* 14(4), 347–360. SPE-4051.
- Gray, K.E. (1965). Approximating Well-to-Fault Distance from Pressure Build-up Tests. *Journal of Petroleum Technology* 17(7).
- Horne, R.N. (1995). *Modern Well Test Analysis: A Computer-Aided Approach*, 2nd ed. Petroway.

## Functions used

`PO.DCA.Diag.Bourdet.SemiLog`, `PO.PTA.Pw.VW.LinSealF`, `PO.PTA.MDH.Fit`, `PO.PTA.Bilinear.Fit`, `PO.PTA.Linear.SqrtT`

## Spreadsheet: PtaDerivativeDiagnostic

|     | A                                                                                                                                                                     | B                                                                                                                                                                                                                                                                                       | C                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             | D                   | E                     | F                                                                 | G          | H                                   | I                                 | J                                      | K                                                   | L                                                                                                                                                                                                                                                                  |
|-----|-----------------------------------------------------------------------------------------------------------------------------------------------------------------------|-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|---------------------|-----------------------|-------------------------------------------------------------------|------------|-------------------------------------|-----------------------------------|----------------------------------------|-----------------------------------------------------|--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|
| 1   | Bourdet Derivative Diagnostic                                                                                                                                         |                                                                                                                                                                                                                                                                                         | Petroleum Office                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              |                     |                       |                                                                   |            |                                     |                                   |                                        |                                                     |                                                                                                                                                                                                                                                                    |
| 2   | Blue cells on yellow are inputs. Paste a drawdown's times and Δp over columns A and B; each row is read against the storage, bilinear, linear and radial slopes.      |                                                                                                                                                                                                                                                                                         |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               |                     |                       |                                                                   |            |                                     |                                   |                                        |                                                     |                                                                                                                                                                                                                                                                    |
| 3   | Well, Fluid and Test                                                                                                                                                  |                                                                                                                                                                                                                                                                                         |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               |                     |                       |                                                                   |            |                                     |                                   |                                        |                                                     |                                                                                                                                                                                                                                                                    |
| 4   | Rate, q                                                                                                                                                               | 250                                                                                                                                                                                                                                                                                     | STB/d                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         |                     |                       |                                                                   |            |                                     |                                   |                                        |                                                     |                                                                                                                                                                                                                                                                    |
| 5   | Oil formation volume factor, Bo                                                                                                                                       | 1.25                                                                                                                                                                                                                                                                                    | bbl/STB                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       |                     |                       |                                                                   |            |                                     |                                   |                                        |                                                     |                                                                                                                                                                                                                                                                    |
| 6   | Oil viscosity, μ                                                                                                                                                      | 1                                                                                                                                                                                                                                                                                       | cp                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |                     |                       |                                                                   |            |                                     |                                   |                                        |                                                     |                                                                                                                                                                                                                                                                    |
| 7   | Porosity, φ                                                                                                                                                           | 0.2                                                                                                                                                                                                                                                                                     | %                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             |                     |                       |                                                                   |            |                                     |                                   |                                        |                                                     |                                                                                                                                                                                                                                                                    |
| 8   | Total compressibility, ct                                                                                                                                             | 0.000015                                                                                                                                                                                                                                                                                | 1/psi                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         |                     |                       |                                                                   |            |                                     |                                   |                                        |                                                     |                                                                                                                                                                                                                                                                    |
| 9   | Wellbore radius, rw                                                                                                                                                   | 0.354                                                                                                                                                                                                                                                                                   | ft                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |                     |                       |                                                                   |            |                                     |                                   |                                        |                                                     |                                                                                                                                                                                                                                                                    |
| 10  | Net pay, h                                                                                                                                                            | 30                                                                                                                                                                                                                                                                                      | ft                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |                     |                       |                                                                   |            |                                     |                                   |                                        |                                                     |                                                                                                                                                                                                                                                                    |
| 11  | Regime Picking                                                                                                                                                        |                                                                                                                                                                                                                                                                                         |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               |                     |                       |                                                                   |            |                                     |                                   |                                        |                                                     |                                                                                                                                                                                                                                                                    |
| 12  | Bourdet smoothing window, L                                                                                                                                           | 0.2                                                                                                                                                                                                                                                                                     | cycles                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        |                     |                       |                                                                   |            |                                     |                                   |                                        |                                                     |                                                                                                                                                                                                                                                                    |
| 13  | Slope tolerance about each regime's slope, ±                                                                                                                          | 0.1                                                                                                                                                                                                                                                                                     | —                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             |                     |                       |                                                                   |            |                                     |                                   |                                        |                                                     |                                                                                                                                                                                                                                                                    |
| 14  | Least R² of a window's log-log line                                                                                                                                   | 0.98                                                                                                                                                                                                                                                                                    | —                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             |                     |                       |                                                                   |            |                                     |                                   |                                        |                                                     |                                                                                                                                                                                                                                                                    |
| 15  | Late level and line over the last                                                                                                                                     | 0.5                                                                                                                                                                                                                                                                                     | cycles                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        |                     |                       |                                                                   |            |                                     |                                   |                                        |                                                     |                                                                                                                                                                                                                                                                    |
| 16  | Fault: late level within ± of twice the radial                                                                                                                        | 0.2                                                                                                                                                                                                                                                                                     | %                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             |                     |                       |                                                                   |            |                                     |                                   |                                        |                                                     |                                                                                                                                                                                                                                                                    |
| 17  | Round trip: k recovered within ±                                                                                                                                      | 0.1                                                                                                                                                                                                                                                                                     | %                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             |                     |                       |                                                                   |            |                                     |                                   |                                        |                                                     |                                                                                                                                                                                                                                                                    |
| 18  | Example Data                                                                                                                                                          |                                                                                                                                                                                                                                                                                         |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               |                     |                       |                                                                   |            |                                     |                                   |                                        |                                                     |                                                                                                                                                                                                                                                                    |
| 19  | Data: 1 fault, 2 finite-cond., 3 infinite-cond. frac                                                                                                                  | 1                                                                                                                                                                                                                                                                                       | —                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             |                     |                       |                                                                   |            |                                     |                                   |                                        |                                                     |                                                                                                                                                                                                                                                                    |
| 20  | Case 1 model permeability                                                                                                                                             | 50                                                                                                                                                                                                                                                                                      | mD                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |                     |                       |                                                                   |            |                                     |                                   |                                        |                                                     |                                                                                                                                                                                                                                                                    |
| 21  | Case 1 model skin factor                                                                                                                                              | 5                                                                                                                                                                                                                                                                                       | —                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             |                     |                       |                                                                   |            |                                     |                                   |                                        |                                                     |                                                                                                                                                                                                                                                                    |
| 22  | Case 1 wellbore storage coefficient, C                                                                                                                                | 0.001                                                                                                                                                                                                                                                                                   | bbl/psi                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       |                     |                       |                                                                   |            |                                     |                                   |                                        |                                                     |                                                                                                                                                                                                                                                                    |
| 23  | Case 1 distance to the sealing fault                                                                                                                                  | 200                                                                                                                                                                                                                                                                                     | ft                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |                     |                       |                                                                   |            |                                     |                                   |                                        |                                                     |                                                                                                                                                                                                                                                                    |
| 25  | Results: the Regimes Picked and What Each Gives                                                                                                                       |                                                                                                                                                                                                                                                                                         |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               |                     |                       |                                                                   |            |                                     |                                   |                                        |                                                     |                                                                                                                                                                                                                                                                    |
| 26  | Radial flow (zero slope) starts at Δt                                                                                                                                 | =MINIFS($A$71:$A$114,$L$71:$L$114,0)                                                                                                                                                                                                                                                    | hr                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |                     |                       |                                                                   |            |                                     |                                   |                                        |                                                     |                                                                                                                                                                                                                                                                    |
| 27  | Radial flow ends at Δt (its first run)                                                                                                                                | =MAXIFS($A$71:$A$114,$L$71:$L$114,0,$A$71:$A$114,"<"&IF(COUNTIFS($A$71:$A$114,">"&BD_RadStart,$L$71:$L$114,"<>0")=0,2*MAX($A$71:$A$114),MINIFS($A$71:$A$114,$A$71:$A$114,">"&BD_RadStart,$L$71:$L$114,"<>0")))                                                                          | hr                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |                     |                       |                                                                   |            |                                     |                                   |                                        |                                                     |                                                                                                                                                                                                                                                                    |
| 28  | Radial points                                                                                                                                                         | =SUMPRODUCT(($L$71:$L$114=0)*($A$71:$A$114>=BD_RadStart)*($A$71:$A$114<=BD_RadEnd))                                                                                                                                                                                                     | —                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             |                     |                       |                                                                   |            |                                     |                                   |                                        |                                                     |                                                                                                                                                                                                                                                                    |
| 29  | Early regimes are read before Δt                                                                                                                                      | =IF(BD_NRad=0,2*MAX($A$71:$A$114),BD_RadStart)                                                                                                                                                                                                                                          | hr                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |                     |                       |                                                                   |            |                                     |                                   |                                        |                                                     |                                                                                                                                                                                                                                                                    |
| 30  | Derivative level over radial flow                                                                                                                                     | =IF(BD_NRad=0,"not seen",SUMPRODUCT(($L$71:$L$114=0)*($A$71:$A$114>=BD_RadStart)*($A$71:$A$114<=BD_RadEnd),$F$71:$F$114)/BD_NRad)                                                                                                                                                       | psi                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           |                     |                       |                                                                   |            |                                     |                                   |                                        |                                                     |                                                                                                                                                                                                                                                                    |
| 31  | Semilog slope, m                                                                                                                                                      | =IF(BD_NRad<BD_MinN,"not seen",PO.PTA.MDH.Fit(FILTER($A$71:$A$114,($L$71:$L$114=0)*($A$71:$A$114>=BD_RadStart)*($A$71:$A$114<=BD_RadEnd)),FILTER($B$71:$B$114,($L$71:$L$114=0)*($A$71:$A$114>=BD_RadStart)*($A$71:$A$114<=BD_RadEnd)),BD_q,BD_Bo,BD_mu,BD_h,BD_phi,BD_ct,BD_rw,"m"))    | psi/cycle                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     |                     |                       |                                                                   |            |                                     |                                   |                                        |                                                     |                                                                                                                                                                                                                                                                    |
| 32  | Radial line's Δp at 1 hr                                                                                                                                              | =IF(BD_NRad<BD_MinN,"not seen",PO.PTA.MDH.Fit(FILTER($A$71:$A$114,($L$71:$L$114=0)*($A$71:$A$114>=BD_RadStart)*($A$71:$A$114<=BD_RadEnd)),FILTER($B$71:$B$114,($L$71:$L$114=0)*($A$71:$A$114>=BD_RadStart)*($A$71:$A$114<=BD_RadEnd)),BD_q,BD_Bo,BD_mu,BD_h,BD_phi,BD_ct,BD_rw,"dp1h")) | psi                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           |                     |                       |                                                                   |            |                                     |                                   |                                        |                                                     |                                                                                                                                                                                                                                                                    |
| 33  | Permeability, k                                                                                                                                                       | =IF(BD_NRad<BD_MinN,"not seen",PO.PTA.MDH.Fit(FILTER($A$71:$A$114,($L$71:$L$114=0)*($A$71:$A$114>=BD_RadStart)*($A$71:$A$114<=BD_RadEnd)),FILTER($B$71:$B$114,($L$71:$L$114=0)*($A$71:$A$114>=BD_RadStart)*($A$71:$A$114<=BD_RadEnd)),BD_q,BD_Bo,BD_mu,BD_h,BD_phi,BD_ct,BD_rw,"k"))    | mD                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |                     |                       |                                                                   |            |                                     |                                   |                                        |                                                     |                                                                                                                                                                                                                                                                    |
| 34  | Skin factor, S                                                                                                                                                        | =IF(BD_NRad<BD_MinN,"not seen",PO.PTA.MDH.Fit(FILTER($A$71:$A$114,($L$71:$L$114=0)*($A$71:$A$114>=BD_RadStart)*($A$71:$A$114<=BD_RadEnd)),FILTER($B$71:$B$114,($L$71:$L$114=0)*($A$71:$A$114>=BD_RadStart)*($A$71:$A$114<=BD_RadEnd)),BD_q,BD_Bo,BD_mu,BD_h,BD_phi,BD_ct,BD_rw,"S"))    | —                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             |                     |                       |                                                                   |            |                                     |                                   |                                        |                                                     |                                                                                                                                                                                                                                                                    |
| 35  | Unit-slope (storage) points before radial flow                                                                                                                        | =SUMPRODUCT(($L$71:$L$114=1)*($A$71:$A$114<BD_Before))                                                                                                                                                                                                                                  | —                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             |                     |                       |                                                                   |            |                                     |                                   |                                        |                                                     |                                                                                                                                                                                                                                                                    |
| 36  | Wellbore storage, C = q·B·Δt/(24·Δp) over them                                                                                                                        | =IF(BD_NSto=0,"not seen",BD_q*BD_Bo/BD_Hr*AVERAGE(FILTER($A$71:$A$114/$B$71:$B$114,($L$71:$L$114=1)*($A$71:$A$114<BD_Before))))                                                                                                                                                         | bbl/psi                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       |                     |                       |                                                                   |            |                                     |                                   |                                        |                                                     |                                                                                                                                                                                                                                                                    |
| 37  | Quarter-slope (bilinear) points                                                                                                                                       | =SUMPRODUCT(($L$71:$L$114=BD_SBil)*($A$71:$A$114<BD_Before))                                                                                                                                                                                                                            | —                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             |                     |                       |                                                                   |            |                                     |                                   |                                        |                                                     |                                                                                                                                                                                                                                                                    |
| 38  | Bilinear slope, Δp against t^¼                                                                                                                                        | =IF(BD_NBil<BD_MinN,"not seen",LET(kRadial_md,BD_K,PO.PTA.Bilinear.Fit(FILTER($A$71:$A$114,($L$71:$L$114=BD_SBil)*($A$71:$A$114<BD_Before)),FILTER($B$71:$B$114,($L$71:$L$114=BD_SBil)*($A$71:$A$114<BD_Before)),BD_q,BD_Bo,BD_mu,BD_h,BD_phi,BD_ct,kRadial_md,"m")))                   | psi/hr^¼                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      |                     |                       |                                                                   |            |                                     |                                   |                                        |                                                     |                                                                                                                                                                                                                                                                    |
| 39  | Fracture conductivity, kf·w                                                                                                                                           | =IF(BD_NBil<BD_MinN,"not seen",LET(kRadial_md,BD_K,PO.PTA.Bilinear.Fit(FILTER($A$71:$A$114,($L$71:$L$114=BD_SBil)*($A$71:$A$114<BD_Before)),FILTER($B$71:$B$114,($L$71:$L$114=BD_SBil)*($A$71:$A$114<BD_Before)),BD_q,BD_Bo,BD_mu,BD_h,BD_phi,BD_ct,kRadial_md,"kfw")))                 | md·ft                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         |                     |                       |                                                                   |            |                                     |                                   |                                        |                                                     |                                                                                                                                                                                                                                                                    |
| 40  | Half-slope (linear) points                                                                                                                                            | =SUMPRODUCT(($L$71:$L$114=BD_SLin)*($A$71:$A$114<BD_Before))                                                                                                                                                                                                                            | —                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             |                     |                       |                                                                   |            |                                     |                                   |                                        |                                                     |                                                                                                                                                                                                                                                                    |
| 41  | Linear slope, Δp against √t                                                                                                                                           | =IF(BD_NLin<BD_MinN,"not seen",LET(kRadial_md,BD_K,PO.PTA.Linear.SqrtT(FILTER($A$71:$A$114,($L$71:$L$114=BD_SLin)*($A$71:$A$114<BD_Before)),FILTER($B$71:$B$114,($L$71:$L$114=BD_SLin)*($A$71:$A$114<BD_Before)),BD_q,BD_Bo,BD_mu,BD_h,BD_phi,BD_ct,kRadial_md,"m")))                   | psi/√hr                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       |                     |                       |                                                                   |            |                                     |                                   |                                        |                                                     |                                                                                                                                                                                                                                                                    |
| 42  | Fracture half-length, xf                                                                                                                                              | =IF(BD_NLin<BD_MinN,"not seen",LET(kRadial_md,BD_K,PO.PTA.Linear.SqrtT(FILTER($A$71:$A$114,($L$71:$L$114=BD_SLin)*($A$71:$A$114<BD_Before)),FILTER($B$71:$B$114,($L$71:$L$114=BD_SLin)*($A$71:$A$114<BD_Before)),BD_q,BD_Bo,BD_mu,BD_h,BD_phi,BD_ct,kRadial_md,"xf")))                  | ft                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |                     |                       |                                                                   |            |                                     |                                   |                                        |                                                     |                                                                                                                                                                                                                                                                    |
| 43  | Points after radial flow                                                                                                                                              | =IF(BD_NRad=0,0,COUNTIFS($A$71:$A$114,">"&BD_RadEnd))                                                                                                                                                                                                                                   | —                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             |                     |                       |                                                                   |            |                                     |                                   |                                        |                                                     |                                                                                                                                                                                                                                                                    |
| 44  | Late derivative over the radial level                                                                                                                                 | =IFERROR(AVERAGE(FILTER($F$71:$F$114,$A$71:$A$114>=MAX($A$71:$A$114)/10^BD_Span))/BD_Level,0)                                                                                                                                                                                           | —                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             |                     |                       |                                                                   |            |                                     |                                   |                                        |                                                     |                                                                                                                                                                                                                                                                    |
| 45  | Late log-log slope of the derivative                                                                                                                                  | =SLOPE(LN(FILTER($F$71:$F$114,$A$71:$A$114>=MAX($A$71:$A$114)/10^BD_Span)),LN(FILTER($A$71:$A$114,$A$71:$A$114>=MAX($A$71:$A$114)/10^BD_Span)))                                                                                                                                         | —                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             |                     |                       |                                                                   |            |                                     |                                   |                                        |                                                     |                                                                                                                                                                                                                                                                    |
| 46  | Late semilog slope                                                                                                                                                    | =SLOPE(FILTER($B$71:$B$114,$A$71:$A$114>=MAX($A$71:$A$114)/10^BD_Span),LOG10(FILTER($A$71:$A$114,$A$71:$A$114>=MAX($A$71:$A$114)/10^BD_Span)))                                                                                                                                          | psi/cycle                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     |                     |                       |                                                                   |            |                                     |                                   |                                        |                                                     |                                                                                                                                                                                                                                                                    |
| 47  | Late line's Δp at 1 hr                                                                                                                                                | =INTERCEPT(FILTER($B$71:$B$114,$A$71:$A$114>=MAX($A$71:$A$114)/10^BD_Span),LOG10(FILTER($A$71:$A$114,$A$71:$A$114>=MAX($A$71:$A$114)/10^BD_Span)))                                                                                                                                      | psi                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           |                     |                       |                                                                   |            |                                     |                                   |                                        |                                                     |                                                                                                                                                                                                                                                                    |
| 48  | Δt where the radial and late lines cross                                                                                                                              | =IFERROR(10^((BD_bLate-BD_Dp1h)/(BD_M-BD_mLate)),0)                                                                                                                                                                                                                                     | hr                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |                     |                       |                                                                   |            |                                     |                                   |                                        |                                                     |                                                                                                                                                                                                                                                                    |
| 49  | Distance to a sealing fault, √(0.000148·k·tx/(φμct))                                                                                                                  | =IF(ABS(BD_Ratio/2-1)<=BD_RTol,SQRT(BD_Gray*BD_K*BD_Tx/(BD_phi*BD_mu*BD_ct)),"no fault")                                                                                                                                                                                                | ft                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |                     |                       |                                                                   |            |                                     |                                   |                                        |                                                     |                                                                                                                                                                                                                                                                    |
| 50  | The example's permeability                                                                                                                                            | =CHOOSE(BD_Case,BD_ModelK,BD_FracK,BD_FracK)                                                                                                                                                                                                                                            | mD                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |                     |                       |                                                                   |            |                                     |                                   |                                        |                                                     |                                                                                                                                                                                                                                                                    |
| 51  | k against the example's                                                                                                                                               | =IFERROR(BD_K/BD_KModel-1,0)                                                                                                                                                                                                                                                            | %                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             |                     |                       |                                                                   |            |                                     |                                   |                                        |                                                     |                                                                                                                                                                                                                                                                    |
| 52  | Fault, kf·w or xf (case 1, 2, 3) against the example                                                                                                                  | =IFERROR(CHOOSE(BD_Case,BD_Dist/BD_Lb-1,BD_Kfw/BD_FracKfw-1,BD_Xf/BD_FracXf-1),0)                                                                                                                                                                                                       | %                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             |                     |                       |                                                                   |            |                                     |                                   |                                        |                                                     |                                                                                                                                                                                                                                                                    |
| 53  | Settings check                                                                                                                                                        | =IF(OR(BD_Tol<=0,BD_Tol>=BD_SBil/2),"FAIL","PASS")                                                                                                                                                                                                                                      | =IF(OR(BD_Tol<=0,BD_Tol>=BD_SBil/2),"the slope tolerance must be above 0 and below 0.125, half the ¼ gap between regimes, or their bands overlap","every window is read against the slopes 1, ½, ¼ and 0 within ±"&FIXED(BD_Tol,2))                                                                                                                                                                                                                                                                                                                                                                                           |                     |                       |                                                                   |            |                                     |                                   |                                        |                                                     |                                                                                                                                                                                                                                                                    |
| 54  | Regime check                                                                                                                                                          | =IF(BD_NRad<BD_MinN,"WARN","PASS")                                                                                                                                                                                                                                                      | =IF(BD_NRad<BD_MinN,"no radial plateau of "&BD_MinN&" points: k and skin are not read, and the early regimes are read over the whole test",""&BD_NSto&" storage, "&BD_NBil&" bilinear, "&BD_NLin&" linear and "&BD_NRad&" radial points, then "&BD_NBnd&" after radial flow")                                                                                                                                                                                                                                                                                                                                                 |                     |                       |                                                                   |            |                                     |                                   |                                        |                                                     |                                                                                                                                                                                                                                                                    |
| 55  | Boundary check                                                                                                                                                        | =IF(BD_NRad=0,"WARN",IF(ABS(BD_Ratio/2-1)<=BD_RTol,"PASS",IF(ABS(BD_Ratio-1)<=BD_Tol,"PASS",IF(BD_Ratio<1,"WARN","WARN"))))                                                                                                                                                             | =IF(BD_NRad=0,"no radial level to compare the late derivative with",IF(ABS(BD_Ratio/2-1)<=BD_RTol,"the late derivative is "&FIXED(BD_Ratio,2)&" times the radial level, near 2: a sealing fault about "&FIXED(BD_Dist,0)&" ft away",IF(ABS(BD_Ratio-1)<=BD_Tol,"no boundary felt; the late derivative is "&FIXED(BD_Ratio,2)&" times the radial level",IF(BD_Ratio<1,"the late derivative falls to "&FIXED(BD_Ratio,2)&" of the radial level: a constant-pressure boundary","the late derivative rises "&FIXED(BD_Ratio,2)&" times, late slope "&FIXED(BD_LateSlope,2)&": two faults, a channel (½) or a closed area (1)")))) |                     |                       |                                                                   |            |                                     |                                   |                                        |                                                     |                                                                                                                                                                                                                                                                    |
| 56  | Round trip on the example data                                                                                                                                        | =IF(ABS(BD_KErr)<=BD_KTol,"PASS","WARN")                                                                                                                                                                                                                                                | =IF(ABS(BD_KErr)<=BD_KTol,"k is "&FIXED(BD_KErr*100,1)&"% from the example's, the second result "&FIXED(BD_XErr*100,1)&"% (ignore for real data)","k is "&FIXED(BD_KErr*100,1)&"% from the example's: the radial window is short or late (ignore for real data)")                                                                                                                                                                                                                                                                                                                                                             |                     |                       |                                                                   |            |                                     |                                   |                                        |                                                     |                                                                                                                                                                                                                                                                    |
| 58  | Calculation Constants and the Fractured-Well Examples                                                                                                                 |                                                                                                                                                                                                                                                                                         |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               |                     |                       |                                                                   |            |                                     |                                   |                                        |                                                     |                                                                                                                                                                                                                                                                    |
| 59  | Hours in a day                                                                                                                                                        | 24                                                                                                                                                                                                                                                                                      | hr/d                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          |                     |                       |                                                                   |            |                                     |                                   |                                        |                                                     |                                                                                                                                                                                                                                                                    |
| 60  | Bilinear-flow log-log slope                                                                                                                                           | 0.25                                                                                                                                                                                                                                                                                    | —                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             |                     |                       |                                                                   |            |                                     |                                   |                                        |                                                     |                                                                                                                                                                                                                                                                    |
| 61  | Linear-flow log-log slope                                                                                                                                             | 0.5                                                                                                                                                                                                                                                                                     | —                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             |                     |                       |                                                                   |            |                                     |                                   |                                        |                                                     |                                                                                                                                                                                                                                                                    |
| 62  | Fault distance constant (Gray)                                                                                                                                        | 0.000148                                                                                                                                                                                                                                                                                | —                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             |                     |                       |                                                                   |            |                                     |                                   |                                        |                                                     |                                                                                                                                                                                                                                                                    |
| 63  | Cases 2 and 3: permeability                                                                                                                                           | 10                                                                                                                                                                                                                                                                                      | mD                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |                     |                       |                                                                   |            |                                     |                                   |                                        |                                                     |                                                                                                                                                                                                                                                                    |
| 64  | Cases 2 and 3: fracture half-length                                                                                                                                   | 100                                                                                                                                                                                                                                                                                     | ft                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |                     |                       |                                                                   |            |                                     |                                   |                                        |                                                     |                                                                                                                                                                                                                                                                    |
| 65  | Case 2: fracture conductivity (F_CD = 2)                                                                                                                              | 2000                                                                                                                                                                                                                                                                                    | md·ft                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         |                     |                       |                                                                   |            |                                     |                                   |                                        |                                                     |                                                                                                                                                                                                                                                                    |
| 66  | Fewest points a regime's line is fitted to                                                                                                                            | 3                                                                                                                                                                                                                                                                                       | —                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             |                     |                       |                                                                   |            |                                     |                                   |                                        |                                                     |                                                                                                                                                                                                                                                                    |
| 67  | Drawdown Data and the Regime Read of Every Row                                                                                                                        |                                                                                                                                                                                                                                                                                         |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               |                     |                       |                                                                   |            |                                     |                                   |                                        |                                                     |                                                                                                                                                                                                                                                                    |
| 68  | How to use it: paste times and Δp = pi − pwf over columns A and B (for a buildup, Agarwal's te and pws − pwf); trim or extend the table's formulas to your row count. |                                                                                                                                                                                                                                                                                         |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               |                     |                       |                                                                   |            |                                     |                                   |                                        |                                                     |                                                                                                                                                                                                                                                                    |
| 69  | Columns C to E are the three examples: C live from the linear sealing-fault model, D and E typed from Engineering's fractured-well model.                             |                                                                                                                                                                                                                                                                                         |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               |                     |                       |                                                                   |            |                                     |                                   |                                        |                                                     |                                                                                                                                                                                                                                                                    |
| 70  | Δt (hr)                                                                                                                                                               | Δp (psi)                                                                                                                                                                                                                                                                                | 1 Fault model (psi)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           | 2 Finite frac (psi) | 3 Infinite frac (psi) | Derivative (psi)                                                  | Δp slope   | Der. slope                          | Window R²                         | Scatter                                | Hump                                                | Regime slope                                                                                                                                                                                                                                                       |
| 71  | 0.001                                                                                                                                                                 | =CHOOSE(BD_Case,C71,D71,E71)                                                                                                                                                                                                                                                            | =PO.PTA.Pw.VW.LinSealF(A71,BD_q,BD_Bo,BD_mu,BD_C,BD_rw,BD_ModelS,BD_ct,BD_phi,BD_h,BD_ModelK,BD_Lb)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           | 24.9815             | 2.4442                | =PO.DCA.Diag.Bourdet.SemiLog($A$71:$A$114,$B$71:$B$114,A71,BD_L)  | =F71/B71   |                                     |                                   |                                        |                                                     | =IF(ABS(G71-1)<=BD_Tol,1,-1)                                                                                                                                                                                                                                       |
| 72  | 0.00133                                                                                                                                                               | =CHOOSE(BD_Case,C72,D72,E72)                                                                                                                                                                                                                                                            | =PO.PTA.Pw.VW.LinSealF(A72,BD_q,BD_Bo,BD_mu,BD_C,BD_rw,BD_ModelS,BD_ct,BD_phi,BD_h,BD_ModelK,BD_Lb)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           | 26.7354             | 2.8188                | =PO.DCA.Diag.Bourdet.SemiLog($A$71:$A$114,$B$71:$B$114,A72,BD_L)  | =F72/B72   |                                     |                                   |                                        |                                                     | =IF(ABS(G72-1)<=BD_Tol,1,-1)                                                                                                                                                                                                                                       |
| 73  | 0.00178                                                                                                                                                               | =CHOOSE(BD_Case,C73,D73,E73)                                                                                                                                                                                                                                                            | =PO.PTA.Pw.VW.LinSealF(A73,BD_q,BD_Bo,BD_mu,BD_C,BD_rw,BD_ModelS,BD_ct,BD_phi,BD_h,BD_ModelK,BD_Lb)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           | 28.7674             | 3.2609                | =PO.DCA.Diag.Bourdet.SemiLog($A$71:$A$114,$B$71:$B$114,A73,BD_L)  | =F73/B73   | =SLOPE(LN(F71:F75),LN(A71:A75))     | =RSQ(LN(F71:F75),LN(A71:A75))     | =STDEV.P(F71:F75)/AVERAGE(F71:F75)     | =IF(MAX(F72:F74)>(1+BD_Tol/2)*MAX(F71,F75),1,0)     | =IF(AND(ABS(H73)<=BD_Tol,OR(I73>=BD_R2,J73<=BD_Tol/2),K73=0),0,IF(AND(ABS(H73-BD_SLin)<=BD_Tol,ABS(G73-BD_SLin)<=BD_Tol,I73>=BD_R2),BD_SLin,IF(AND(ABS(H73-BD_SBil)<=BD_Tol,ABS(G73-BD_SBil)<=BD_Tol,I73>=BD_R2),BD_SBil,IF(ABS(G73-1)<=BD_Tol,1,-1))))            |
| 74  | 0.00237                                                                                                                                                               | =CHOOSE(BD_Case,C74,D74,E74)                                                                                                                                                                                                                                                            | =PO.PTA.Pw.VW.LinSealF(A74,BD_q,BD_Bo,BD_mu,BD_C,BD_rw,BD_ModelS,BD_ct,BD_phi,BD_h,BD_ModelK,BD_Lb)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           | 30.9027             | 3.7628                | =PO.DCA.Diag.Bourdet.SemiLog($A$71:$A$114,$B$71:$B$114,A74,BD_L)  | =F74/B74   | =SLOPE(LN(F72:F76),LN(A72:A76))     | =RSQ(LN(F72:F76),LN(A72:A76))     | =STDEV.P(F72:F76)/AVERAGE(F72:F76)     | =IF(MAX(F73:F75)>(1+BD_Tol/2)*MAX(F72,F76),1,0)     | =IF(AND(ABS(H74)<=BD_Tol,OR(I74>=BD_R2,J74<=BD_Tol/2),K74=0),0,IF(AND(ABS(H74-BD_SLin)<=BD_Tol,ABS(G74-BD_SLin)<=BD_Tol,I74>=BD_R2),BD_SLin,IF(AND(ABS(H74-BD_SBil)<=BD_Tol,ABS(G74-BD_SBil)<=BD_Tol,I74>=BD_R2),BD_SBil,IF(ABS(G74-1)<=BD_Tol,1,-1))))            |
| 75  | 0.00316                                                                                                                                                               | =CHOOSE(BD_Case,C75,D75,E75)                                                                                                                                                                                                                                                            | =PO.PTA.Pw.VW.LinSealF(A75,BD_q,BD_Bo,BD_mu,BD_C,BD_rw,BD_ModelS,BD_ct,BD_phi,BD_h,BD_ModelK,BD_Lb)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           | 33.0722             | 4.3448                | =PO.DCA.Diag.Bourdet.SemiLog($A$71:$A$114,$B$71:$B$114,A75,BD_L)  | =F75/B75   | =SLOPE(LN(F73:F77),LN(A73:A77))     | =RSQ(LN(F73:F77),LN(A73:A77))     | =STDEV.P(F73:F77)/AVERAGE(F73:F77)     | =IF(MAX(F74:F76)>(1+BD_Tol/2)*MAX(F73,F77),1,0)     | =IF(AND(ABS(H75)<=BD_Tol,OR(I75>=BD_R2,J75<=BD_Tol/2),K75=0),0,IF(AND(ABS(H75-BD_SLin)<=BD_Tol,ABS(G75-BD_SLin)<=BD_Tol,I75>=BD_R2),BD_SLin,IF(AND(ABS(H75-BD_SBil)<=BD_Tol,ABS(G75-BD_SBil)<=BD_Tol,I75>=BD_R2),BD_SBil,IF(ABS(G75-1)<=BD_Tol,1,-1))))            |
| 76  | 0.00422                                                                                                                                                               | =CHOOSE(BD_Case,C76,D76,E76)                                                                                                                                                                                                                                                            | =PO.PTA.Pw.VW.LinSealF(A76,BD_q,BD_Bo,BD_mu,BD_C,BD_rw,BD_ModelS,BD_ct,BD_phi,BD_h,BD_ModelK,BD_Lb)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           | 35.3282             | 5.0209                | =PO.DCA.Diag.Bourdet.SemiLog($A$71:$A$114,$B$71:$B$114,A76,BD_L)  | =F76/B76   | =SLOPE(LN(F74:F78),LN(A74:A78))     | =RSQ(LN(F74:F78),LN(A74:A78))     | =STDEV.P(F74:F78)/AVERAGE(F74:F78)     | =IF(MAX(F75:F77)>(1+BD_Tol/2)*MAX(F74,F78),1,0)     | =IF(AND(ABS(H76)<=BD_Tol,OR(I76>=BD_R2,J76<=BD_Tol/2),K76=0),0,IF(AND(ABS(H76-BD_SLin)<=BD_Tol,ABS(G76-BD_SLin)<=BD_Tol,I76>=BD_R2),BD_SLin,IF(AND(ABS(H76-BD_SBil)<=BD_Tol,ABS(G76-BD_SBil)<=BD_Tol,I76>=BD_R2),BD_SBil,IF(ABS(G76-1)<=BD_Tol,1,-1))))            |
| 77  | 0.00562                                                                                                                                                               | =CHOOSE(BD_Case,C77,D77,E77)                                                                                                                                                                                                                                                            | =PO.PTA.Pw.VW.LinSealF(A77,BD_q,BD_Bo,BD_mu,BD_C,BD_rw,BD_ModelS,BD_ct,BD_phi,BD_h,BD_ModelK,BD_Lb)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           | 38.0734             | 5.7958                | =PO.DCA.Diag.Bourdet.SemiLog($A$71:$A$114,$B$71:$B$114,A77,BD_L)  | =F77/B77   | =SLOPE(LN(F75:F79),LN(A75:A79))     | =RSQ(LN(F75:F79),LN(A75:A79))     | =STDEV.P(F75:F79)/AVERAGE(F75:F79)     | =IF(MAX(F76:F78)>(1+BD_Tol/2)*MAX(F75,F79),1,0)     | =IF(AND(ABS(H77)<=BD_Tol,OR(I77>=BD_R2,J77<=BD_Tol/2),K77=0),0,IF(AND(ABS(H77-BD_SLin)<=BD_Tol,ABS(G77-BD_SLin)<=BD_Tol,I77>=BD_R2),BD_SLin,IF(AND(ABS(H77-BD_SBil)<=BD_Tol,ABS(G77-BD_SBil)<=BD_Tol,I77>=BD_R2),BD_SBil,IF(ABS(G77-1)<=BD_Tol,1,-1))))            |
| 78  | 0.0075                                                                                                                                                                | =CHOOSE(BD_Case,C78,D78,E78)                                                                                                                                                                                                                                                            | =PO.PTA.Pw.VW.LinSealF(A78,BD_q,BD_Bo,BD_mu,BD_C,BD_rw,BD_ModelS,BD_ct,BD_phi,BD_h,BD_ModelK,BD_Lb)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           | 40.9373             | 6.7415                | =PO.DCA.Diag.Bourdet.SemiLog($A$71:$A$114,$B$71:$B$114,A78,BD_L)  | =F78/B78   | =SLOPE(LN(F76:F80),LN(A76:A80))     | =RSQ(LN(F76:F80),LN(A76:A80))     | =STDEV.P(F76:F80)/AVERAGE(F76:F80)     | =IF(MAX(F77:F79)>(1+BD_Tol/2)*MAX(F76,F80),1,0)     | =IF(AND(ABS(H78)<=BD_Tol,OR(I78>=BD_R2,J78<=BD_Tol/2),K78=0),0,IF(AND(ABS(H78-BD_SLin)<=BD_Tol,ABS(G78-BD_SLin)<=BD_Tol,I78>=BD_R2),BD_SLin,IF(AND(ABS(H78-BD_SBil)<=BD_Tol,ABS(G78-BD_SBil)<=BD_Tol,I78>=BD_R2),BD_SBil,IF(ABS(G78-1)<=BD_Tol,1,-1))))            |
| 79  | 0.01                                                                                                                                                                  | =CHOOSE(BD_Case,C79,D79,E79)                                                                                                                                                                                                                                                            | =PO.PTA.Pw.VW.LinSealF(A79,BD_q,BD_Bo,BD_mu,BD_C,BD_rw,BD_ModelS,BD_ct,BD_phi,BD_h,BD_ModelK,BD_Lb)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           | 43.6984             | 7.8278                | =PO.DCA.Diag.Bourdet.SemiLog($A$71:$A$114,$B$71:$B$114,A79,BD_L)  | =F79/B79   | =SLOPE(LN(F77:F81),LN(A77:A81))     | =RSQ(LN(F77:F81),LN(A77:A81))     | =STDEV.P(F77:F81)/AVERAGE(F77:F81)     | =IF(MAX(F78:F80)>(1+BD_Tol/2)*MAX(F77,F81),1,0)     | =IF(AND(ABS(H79)<=BD_Tol,OR(I79>=BD_R2,J79<=BD_Tol/2),K79=0),0,IF(AND(ABS(H79-BD_SLin)<=BD_Tol,ABS(G79-BD_SLin)<=BD_Tol,I79>=BD_R2),BD_SLin,IF(AND(ABS(H79-BD_SBil)<=BD_Tol,ABS(G79-BD_SBil)<=BD_Tol,I79>=BD_R2),BD_SBil,IF(ABS(G79-1)<=BD_Tol,1,-1))))            |
| 80  | 0.0133                                                                                                                                                                | =CHOOSE(BD_Case,C80,D80,E80)                                                                                                                                                                                                                                                            | =PO.PTA.Pw.VW.LinSealF(A80,BD_q,BD_Bo,BD_mu,BD_C,BD_rw,BD_ModelS,BD_ct,BD_phi,BD_h,BD_ModelK,BD_Lb)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           | 46.8341             | 8.9255                | =PO.DCA.Diag.Bourdet.SemiLog($A$71:$A$114,$B$71:$B$114,A80,BD_L)  | =F80/B80   | =SLOPE(LN(F78:F82),LN(A78:A82))     | =RSQ(LN(F78:F82),LN(A78:A82))     | =STDEV.P(F78:F82)/AVERAGE(F78:F82)     | =IF(MAX(F79:F81)>(1+BD_Tol/2)*MAX(F78,F82),1,0)     | =IF(AND(ABS(H80)<=BD_Tol,OR(I80>=BD_R2,J80<=BD_Tol/2),K80=0),0,IF(AND(ABS(H80-BD_SLin)<=BD_Tol,ABS(G80-BD_SLin)<=BD_Tol,I80>=BD_R2),BD_SLin,IF(AND(ABS(H80-BD_SBil)<=BD_Tol,ABS(G80-BD_SBil)<=BD_Tol,I80>=BD_R2),BD_SBil,IF(ABS(G80-1)<=BD_Tol,1,-1))))            |
| 81  | 0.0178                                                                                                                                                                | =CHOOSE(BD_Case,C81,D81,E81)                                                                                                                                                                                                                                                            | =PO.PTA.Pw.VW.LinSealF(A81,BD_q,BD_Bo,BD_mu,BD_C,BD_rw,BD_ModelS,BD_ct,BD_phi,BD_h,BD_ModelK,BD_Lb)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           | 50.3165             | 10.312                | =PO.DCA.Diag.Bourdet.SemiLog($A$71:$A$114,$B$71:$B$114,A81,BD_L)  | =F81/B81   | =SLOPE(LN(F79:F83),LN(A79:A83))     | =RSQ(LN(F79:F83),LN(A79:A83))     | =STDEV.P(F79:F83)/AVERAGE(F79:F83)     | =IF(MAX(F80:F82)>(1+BD_Tol/2)*MAX(F79,F83),1,0)     | =IF(AND(ABS(H81)<=BD_Tol,OR(I81>=BD_R2,J81<=BD_Tol/2),K81=0),0,IF(AND(ABS(H81-BD_SLin)<=BD_Tol,ABS(G81-BD_SLin)<=BD_Tol,I81>=BD_R2),BD_SLin,IF(AND(ABS(H81-BD_SBil)<=BD_Tol,ABS(G81-BD_SBil)<=BD_Tol,I81>=BD_R2),BD_SBil,IF(ABS(G81-1)<=BD_Tol,1,-1))))            |
| 82  | 0.0237                                                                                                                                                                | =CHOOSE(BD_Case,C82,D82,E82)                                                                                                                                                                                                                                                            | =PO.PTA.Pw.VW.LinSealF(A82,BD_q,BD_Bo,BD_mu,BD_C,BD_rw,BD_ModelS,BD_ct,BD_phi,BD_h,BD_ModelK,BD_Lb)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           | 54.0215             | 11.8988               | =PO.DCA.Diag.Bourdet.SemiLog($A$71:$A$114,$B$71:$B$114,A82,BD_L)  | =F82/B82   | =SLOPE(LN(F80:F84),LN(A80:A84))     | =RSQ(LN(F80:F84),LN(A80:A84))     | =STDEV.P(F80:F84)/AVERAGE(F80:F84)     | =IF(MAX(F81:F83)>(1+BD_Tol/2)*MAX(F80,F84),1,0)     | =IF(AND(ABS(H82)<=BD_Tol,OR(I82>=BD_R2,J82<=BD_Tol/2),K82=0),0,IF(AND(ABS(H82-BD_SLin)<=BD_Tol,ABS(G82-BD_SLin)<=BD_Tol,I82>=BD_R2),BD_SLin,IF(AND(ABS(H82-BD_SBil)<=BD_Tol,ABS(G82-BD_SBil)<=BD_Tol,I82>=BD_R2),BD_SBil,IF(ABS(G82-1)<=BD_Tol,1,-1))))            |
| 83  | 0.0316                                                                                                                                                                | =CHOOSE(BD_Case,C83,D83,E83)                                                                                                                                                                                                                                                            | =PO.PTA.Pw.VW.LinSealF(A83,BD_q,BD_Bo,BD_mu,BD_C,BD_rw,BD_ModelS,BD_ct,BD_phi,BD_h,BD_ModelK,BD_Lb)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           | 58.0655             | 13.7395               | =PO.DCA.Diag.Bourdet.SemiLog($A$71:$A$114,$B$71:$B$114,A83,BD_L)  | =F83/B83   | =SLOPE(LN(F81:F85),LN(A81:A85))     | =RSQ(LN(F81:F85),LN(A81:A85))     | =STDEV.P(F81:F85)/AVERAGE(F81:F85)     | =IF(MAX(F82:F84)>(1+BD_Tol/2)*MAX(F81,F85),1,0)     | =IF(AND(ABS(H83)<=BD_Tol,OR(I83>=BD_R2,J83<=BD_Tol/2),K83=0),0,IF(AND(ABS(H83-BD_SLin)<=BD_Tol,ABS(G83-BD_SLin)<=BD_Tol,I83>=BD_R2),BD_SLin,IF(AND(ABS(H83-BD_SBil)<=BD_Tol,ABS(G83-BD_SBil)<=BD_Tol,I83>=BD_R2),BD_SBil,IF(ABS(G83-1)<=BD_Tol,1,-1))))            |
| 84  | 0.0422                                                                                                                                                                | =CHOOSE(BD_Case,C84,D84,E84)                                                                                                                                                                                                                                                            | =PO.PTA.Pw.VW.LinSealF(A84,BD_q,BD_Bo,BD_mu,BD_C,BD_rw,BD_ModelS,BD_ct,BD_phi,BD_h,BD_ModelK,BD_Lb)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           | 62.3012             | 15.8766               | =PO.DCA.Diag.Bourdet.SemiLog($A$71:$A$114,$B$71:$B$114,A84,BD_L)  | =F84/B84   | =SLOPE(LN(F82:F86),LN(A82:A86))     | =RSQ(LN(F82:F86),LN(A82:A86))     | =STDEV.P(F82:F86)/AVERAGE(F82:F86)     | =IF(MAX(F83:F85)>(1+BD_Tol/2)*MAX(F82,F86),1,0)     | =IF(AND(ABS(H84)<=BD_Tol,OR(I84>=BD_R2,J84<=BD_Tol/2),K84=0),0,IF(AND(ABS(H84-BD_SLin)<=BD_Tol,ABS(G84-BD_SLin)<=BD_Tol,I84>=BD_R2),BD_SLin,IF(AND(ABS(H84-BD_SBil)<=BD_Tol,ABS(G84-BD_SBil)<=BD_Tol,I84>=BD_R2),BD_SBil,IF(ABS(G84-1)<=BD_Tol,1,-1))))            |
| 85  | 0.0562                                                                                                                                                                | =CHOOSE(BD_Case,C85,D85,E85)                                                                                                                                                                                                                                                            | =PO.PTA.Pw.VW.LinSealF(A85,BD_q,BD_Bo,BD_mu,BD_C,BD_rw,BD_ModelS,BD_ct,BD_phi,BD_h,BD_ModelK,BD_Lb)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           | 66.7743             | 18.3172               | =PO.DCA.Diag.Bourdet.SemiLog($A$71:$A$114,$B$71:$B$114,A85,BD_L)  | =F85/B85   | =SLOPE(LN(F83:F87),LN(A83:A87))     | =RSQ(LN(F83:F87),LN(A83:A87))     | =STDEV.P(F83:F87)/AVERAGE(F83:F87)     | =IF(MAX(F84:F86)>(1+BD_Tol/2)*MAX(F83,F87),1,0)     | =IF(AND(ABS(H85)<=BD_Tol,OR(I85>=BD_R2,J85<=BD_Tol/2),K85=0),0,IF(AND(ABS(H85-BD_SLin)<=BD_Tol,ABS(G85-BD_SLin)<=BD_Tol,I85>=BD_R2),BD_SLin,IF(AND(ABS(H85-BD_SBil)<=BD_Tol,ABS(G85-BD_SBil)<=BD_Tol,I85>=BD_R2),BD_SBil,IF(ABS(G85-1)<=BD_Tol,1,-1))))            |
| 86  | 0.075                                                                                                                                                                 | =CHOOSE(BD_Case,C86,D86,E86)                                                                                                                                                                                                                                                            | =PO.PTA.Pw.VW.LinSealF(A86,BD_q,BD_Bo,BD_mu,BD_C,BD_rw,BD_ModelS,BD_ct,BD_phi,BD_h,BD_ModelK,BD_Lb)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           | 71.6414             | 21.1434               | =PO.DCA.Diag.Bourdet.SemiLog($A$71:$A$114,$B$71:$B$114,A86,BD_L)  | =F86/B86   | =SLOPE(LN(F84:F88),LN(A84:A88))     | =RSQ(LN(F84:F88),LN(A84:A88))     | =STDEV.P(F84:F88)/AVERAGE(F84:F88)     | =IF(MAX(F85:F87)>(1+BD_Tol/2)*MAX(F84,F88),1,0)     | =IF(AND(ABS(H86)<=BD_Tol,OR(I86>=BD_R2,J86<=BD_Tol/2),K86=0),0,IF(AND(ABS(H86-BD_SLin)<=BD_Tol,ABS(G86-BD_SLin)<=BD_Tol,I86>=BD_R2),BD_SLin,IF(AND(ABS(H86-BD_SBil)<=BD_Tol,ABS(G86-BD_SBil)<=BD_Tol,I86>=BD_R2),BD_SBil,IF(ABS(G86-1)<=BD_Tol,1,-1))))            |
| 87  | 0.1                                                                                                                                                                   | =CHOOSE(BD_Case,C87,D87,E87)                                                                                                                                                                                                                                                            | =PO.PTA.Pw.VW.LinSealF(A87,BD_q,BD_Bo,BD_mu,BD_C,BD_rw,BD_ModelS,BD_ct,BD_phi,BD_h,BD_ModelK,BD_Lb)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           | 76.8577             | 24.3677               | =PO.DCA.Diag.Bourdet.SemiLog($A$71:$A$114,$B$71:$B$114,A87,BD_L)  | =F87/B87   | =SLOPE(LN(F85:F89),LN(A85:A89))     | =RSQ(LN(F85:F89),LN(A85:A89))     | =STDEV.P(F85:F89)/AVERAGE(F85:F89)     | =IF(MAX(F86:F88)>(1+BD_Tol/2)*MAX(F85,F89),1,0)     | =IF(AND(ABS(H87)<=BD_Tol,OR(I87>=BD_R2,J87<=BD_Tol/2),K87=0),0,IF(AND(ABS(H87-BD_SLin)<=BD_Tol,ABS(G87-BD_SLin)<=BD_Tol,I87>=BD_R2),BD_SLin,IF(AND(ABS(H87-BD_SBil)<=BD_Tol,ABS(G87-BD_SBil)<=BD_Tol,I87>=BD_R2),BD_SBil,IF(ABS(G87-1)<=BD_Tol,1,-1))))            |
| 88  | 0.133                                                                                                                                                                 | =CHOOSE(BD_Case,C88,D88,E88)                                                                                                                                                                                                                                                            | =PO.PTA.Pw.VW.LinSealF(A88,BD_q,BD_Bo,BD_mu,BD_C,BD_rw,BD_ModelS,BD_ct,BD_phi,BD_h,BD_ModelK,BD_Lb)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           | 82.418              | 27.9991               | =PO.DCA.Diag.Bourdet.SemiLog($A$71:$A$114,$B$71:$B$114,A88,BD_L)  | =F88/B88   | =SLOPE(LN(F86:F90),LN(A86:A90))     | =RSQ(LN(F86:F90),LN(A86:A90))     | =STDEV.P(F86:F90)/AVERAGE(F86:F90)     | =IF(MAX(F87:F89)>(1+BD_Tol/2)*MAX(F86,F90),1,0)     | =IF(AND(ABS(H88)<=BD_Tol,OR(I88>=BD_R2,J88<=BD_Tol/2),K88=0),0,IF(AND(ABS(H88-BD_SLin)<=BD_Tol,ABS(G88-BD_SLin)<=BD_Tol,I88>=BD_R2),BD_SLin,IF(AND(ABS(H88-BD_SBil)<=BD_Tol,ABS(G88-BD_SBil)<=BD_Tol,I88>=BD_R2),BD_SBil,IF(ABS(G88-1)<=BD_Tol,1,-1))))            |
| 89  | 0.178                                                                                                                                                                 | =CHOOSE(BD_Case,C89,D89,E89)                                                                                                                                                                                                                                                            | =PO.PTA.Pw.VW.LinSealF(A89,BD_q,BD_Bo,BD_mu,BD_C,BD_rw,BD_ModelS,BD_ct,BD_phi,BD_h,BD_ModelK,BD_Lb)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           | 88.494              | 32.1998               | =PO.DCA.Diag.Bourdet.SemiLog($A$71:$A$114,$B$71:$B$114,A89,BD_L)  | =F89/B89   | =SLOPE(LN(F87:F91),LN(A87:A91))     | =RSQ(LN(F87:F91),LN(A87:A91))     | =STDEV.P(F87:F91)/AVERAGE(F87:F91)     | =IF(MAX(F88:F90)>(1+BD_Tol/2)*MAX(F87,F91),1,0)     | =IF(AND(ABS(H89)<=BD_Tol,OR(I89>=BD_R2,J89<=BD_Tol/2),K89=0),0,IF(AND(ABS(H89-BD_SLin)<=BD_Tol,ABS(G89-BD_SLin)<=BD_Tol,I89>=BD_R2),BD_SLin,IF(AND(ABS(H89-BD_SBil)<=BD_Tol,ABS(G89-BD_SBil)<=BD_Tol,I89>=BD_R2),BD_SBil,IF(ABS(G89-1)<=BD_Tol,1,-1))))            |
| 90  | 0.237                                                                                                                                                                 | =CHOOSE(BD_Case,C90,D90,E90)                                                                                                                                                                                                                                                            | =PO.PTA.Pw.VW.LinSealF(A90,BD_q,BD_Bo,BD_mu,BD_C,BD_rw,BD_ModelS,BD_ct,BD_phi,BD_h,BD_ModelK,BD_Lb)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           | 94.9376             | 36.7273               | =PO.DCA.Diag.Bourdet.SemiLog($A$71:$A$114,$B$71:$B$114,A90,BD_L)  | =F90/B90   | =SLOPE(LN(F88:F92),LN(A88:A92))     | =RSQ(LN(F88:F92),LN(A88:A92))     | =STDEV.P(F88:F92)/AVERAGE(F88:F92)     | =IF(MAX(F89:F91)>(1+BD_Tol/2)*MAX(F88,F92),1,0)     | =IF(AND(ABS(H90)<=BD_Tol,OR(I90>=BD_R2,J90<=BD_Tol/2),K90=0),0,IF(AND(ABS(H90-BD_SLin)<=BD_Tol,ABS(G90-BD_SLin)<=BD_Tol,I90>=BD_R2),BD_SLin,IF(AND(ABS(H90-BD_SBil)<=BD_Tol,ABS(G90-BD_SBil)<=BD_Tol,I90>=BD_R2),BD_SBil,IF(ABS(G90-1)<=BD_Tol,1,-1))))            |
| 91  | 0.316                                                                                                                                                                 | =CHOOSE(BD_Case,C91,D91,E91)                                                                                                                                                                                                                                                            | =PO.PTA.Pw.VW.LinSealF(A91,BD_q,BD_Bo,BD_mu,BD_C,BD_rw,BD_ModelS,BD_ct,BD_phi,BD_h,BD_ModelK,BD_Lb)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           | 101.9788            | 42.2897               | =PO.DCA.Diag.Bourdet.SemiLog($A$71:$A$114,$B$71:$B$114,A91,BD_L)  | =F91/B91   | =SLOPE(LN(F89:F93),LN(A89:A93))     | =RSQ(LN(F89:F93),LN(A89:A93))     | =STDEV.P(F89:F93)/AVERAGE(F89:F93)     | =IF(MAX(F90:F92)>(1+BD_Tol/2)*MAX(F89,F93),1,0)     | =IF(AND(ABS(H91)<=BD_Tol,OR(I91>=BD_R2,J91<=BD_Tol/2),K91=0),0,IF(AND(ABS(H91-BD_SLin)<=BD_Tol,ABS(G91-BD_SLin)<=BD_Tol,I91>=BD_R2),BD_SLin,IF(AND(ABS(H91-BD_SBil)<=BD_Tol,ABS(G91-BD_SBil)<=BD_Tol,I91>=BD_R2),BD_SBil,IF(ABS(G91-1)<=BD_Tol,1,-1))))            |
| 92  | 0.422                                                                                                                                                                 | =CHOOSE(BD_Case,C92,D92,E92)                                                                                                                                                                                                                                                            | =PO.PTA.Pw.VW.LinSealF(A92,BD_q,BD_Bo,BD_mu,BD_C,BD_rw,BD_ModelS,BD_ct,BD_phi,BD_h,BD_ModelK,BD_Lb)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           | 109.6497            | 48.3958               | =PO.DCA.Diag.Bourdet.SemiLog($A$71:$A$114,$B$71:$B$114,A92,BD_L)  | =F92/B92   | =SLOPE(LN(F90:F94),LN(A90:A94))     | =RSQ(LN(F90:F94),LN(A90:A94))     | =STDEV.P(F90:F94)/AVERAGE(F90:F94)     | =IF(MAX(F91:F93)>(1+BD_Tol/2)*MAX(F90,F94),1,0)     | =IF(AND(ABS(H92)<=BD_Tol,OR(I92>=BD_R2,J92<=BD_Tol/2),K92=0),0,IF(AND(ABS(H92-BD_SLin)<=BD_Tol,ABS(G92-BD_SLin)<=BD_Tol,I92>=BD_R2),BD_SLin,IF(AND(ABS(H92-BD_SBil)<=BD_Tol,ABS(G92-BD_SBil)<=BD_Tol,I92>=BD_R2),BD_SBil,IF(ABS(G92-1)<=BD_Tol,1,-1))))            |
| 93  | 0.562                                                                                                                                                                 | =CHOOSE(BD_Case,C93,D93,E93)                                                                                                                                                                                                                                                            | =PO.PTA.Pw.VW.LinSealF(A93,BD_q,BD_Bo,BD_mu,BD_C,BD_rw,BD_ModelS,BD_ct,BD_phi,BD_h,BD_ModelK,BD_Lb)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           | 117.9242            | 54.1736               | =PO.DCA.Diag.Bourdet.SemiLog($A$71:$A$114,$B$71:$B$114,A93,BD_L)  | =F93/B93   | =SLOPE(LN(F91:F95),LN(A91:A95))     | =RSQ(LN(F91:F95),LN(A91:A95))     | =STDEV.P(F91:F95)/AVERAGE(F91:F95)     | =IF(MAX(F92:F94)>(1+BD_Tol/2)*MAX(F91,F95),1,0)     | =IF(AND(ABS(H93)<=BD_Tol,OR(I93>=BD_R2,J93<=BD_Tol/2),K93=0),0,IF(AND(ABS(H93-BD_SLin)<=BD_Tol,ABS(G93-BD_SLin)<=BD_Tol,I93>=BD_R2),BD_SLin,IF(AND(ABS(H93-BD_SBil)<=BD_Tol,ABS(G93-BD_SBil)<=BD_Tol,I93>=BD_R2),BD_SBil,IF(ABS(G93-1)<=BD_Tol,1,-1))))            |
| 94  | 0.75                                                                                                                                                                  | =CHOOSE(BD_Case,C94,D94,E94)                                                                                                                                                                                                                                                            | =PO.PTA.Pw.VW.LinSealF(A94,BD_q,BD_Bo,BD_mu,BD_C,BD_rw,BD_ModelS,BD_ct,BD_phi,BD_h,BD_ModelK,BD_Lb)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           | 126.9995            | 61.1654               | =PO.DCA.Diag.Bourdet.SemiLog($A$71:$A$114,$B$71:$B$114,A94,BD_L)  | =F94/B94   | =SLOPE(LN(F92:F96),LN(A92:A96))     | =RSQ(LN(F92:F96),LN(A92:A96))     | =STDEV.P(F92:F96)/AVERAGE(F92:F96)     | =IF(MAX(F93:F95)>(1+BD_Tol/2)*MAX(F92,F96),1,0)     | =IF(AND(ABS(H94)<=BD_Tol,OR(I94>=BD_R2,J94<=BD_Tol/2),K94=0),0,IF(AND(ABS(H94-BD_SLin)<=BD_Tol,ABS(G94-BD_SLin)<=BD_Tol,I94>=BD_R2),BD_SLin,IF(AND(ABS(H94-BD_SBil)<=BD_Tol,ABS(G94-BD_SBil)<=BD_Tol,I94>=BD_R2),BD_SBil,IF(ABS(G94-1)<=BD_Tol,1,-1))))            |
| 95  | 1                                                                                                                                                                     | =CHOOSE(BD_Case,C95,D95,E95)                                                                                                                                                                                                                                                            | =PO.PTA.Pw.VW.LinSealF(A95,BD_q,BD_Bo,BD_mu,BD_C,BD_rw,BD_ModelS,BD_ct,BD_phi,BD_h,BD_ModelK,BD_Lb)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           | 136.8779            | 68.9691               | =PO.DCA.Diag.Bourdet.SemiLog($A$71:$A$114,$B$71:$B$114,A95,BD_L)  | =F95/B95   | =SLOPE(LN(F93:F97),LN(A93:A97))     | =RSQ(LN(F93:F97),LN(A93:A97))     | =STDEV.P(F93:F97)/AVERAGE(F93:F97)     | =IF(MAX(F94:F96)>(1+BD_Tol/2)*MAX(F93,F97),1,0)     | =IF(AND(ABS(H95)<=BD_Tol,OR(I95>=BD_R2,J95<=BD_Tol/2),K95=0),0,IF(AND(ABS(H95-BD_SLin)<=BD_Tol,ABS(G95-BD_SLin)<=BD_Tol,I95>=BD_R2),BD_SLin,IF(AND(ABS(H95-BD_SBil)<=BD_Tol,ABS(G95-BD_SBil)<=BD_Tol,I95>=BD_R2),BD_SBil,IF(ABS(G95-1)<=BD_Tol,1,-1))))            |
| 96  | 1.33                                                                                                                                                                  | =CHOOSE(BD_Case,C96,D96,E96)                                                                                                                                                                                                                                                            | =PO.PTA.Pw.VW.LinSealF(A96,BD_q,BD_Bo,BD_mu,BD_C,BD_rw,BD_ModelS,BD_ct,BD_phi,BD_h,BD_ModelK,BD_Lb)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           | 147.5545            | 77.5431               | =PO.DCA.Diag.Bourdet.SemiLog($A$71:$A$114,$B$71:$B$114,A96,BD_L)  | =F96/B96   | =SLOPE(LN(F94:F98),LN(A94:A98))     | =RSQ(LN(F94:F98),LN(A94:A98))     | =STDEV.P(F94:F98)/AVERAGE(F94:F98)     | =IF(MAX(F95:F97)>(1+BD_Tol/2)*MAX(F94,F98),1,0)     | =IF(AND(ABS(H96)<=BD_Tol,OR(I96>=BD_R2,J96<=BD_Tol/2),K96=0),0,IF(AND(ABS(H96-BD_SLin)<=BD_Tol,ABS(G96-BD_SLin)<=BD_Tol,I96>=BD_R2),BD_SLin,IF(AND(ABS(H96-BD_SBil)<=BD_Tol,ABS(G96-BD_SBil)<=BD_Tol,I96>=BD_R2),BD_SBil,IF(ABS(G96-1)<=BD_Tol,1,-1))))            |
| 97  | 1.78                                                                                                                                                                  | =CHOOSE(BD_Case,C97,D97,E97)                                                                                                                                                                                                                                                            | =PO.PTA.Pw.VW.LinSealF(A97,BD_q,BD_Bo,BD_mu,BD_C,BD_rw,BD_ModelS,BD_ct,BD_phi,BD_h,BD_ModelK,BD_Lb)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           | 159.4318            | 87.2775               | =PO.DCA.Diag.Bourdet.SemiLog($A$71:$A$114,$B$71:$B$114,A97,BD_L)  | =F97/B97   | =SLOPE(LN(F95:F99),LN(A95:A99))     | =RSQ(LN(F95:F99),LN(A95:A99))     | =STDEV.P(F95:F99)/AVERAGE(F95:F99)     | =IF(MAX(F96:F98)>(1+BD_Tol/2)*MAX(F95,F99),1,0)     | =IF(AND(ABS(H97)<=BD_Tol,OR(I97>=BD_R2,J97<=BD_Tol/2),K97=0),0,IF(AND(ABS(H97-BD_SLin)<=BD_Tol,ABS(G97-BD_SLin)<=BD_Tol,I97>=BD_R2),BD_SLin,IF(AND(ABS(H97-BD_SBil)<=BD_Tol,ABS(G97-BD_SBil)<=BD_Tol,I97>=BD_R2),BD_SBil,IF(ABS(G97-1)<=BD_Tol,1,-1))))            |
| 98  | 2.37                                                                                                                                                                  | =CHOOSE(BD_Case,C98,D98,E98)                                                                                                                                                                                                                                                            | =PO.PTA.Pw.VW.LinSealF(A98,BD_q,BD_Bo,BD_mu,BD_C,BD_rw,BD_ModelS,BD_ct,BD_phi,BD_h,BD_ModelK,BD_Lb)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           | 172.0878            | 97.9096               | =PO.DCA.Diag.Bourdet.SemiLog($A$71:$A$114,$B$71:$B$114,A98,BD_L)  | =F98/B98   | =SLOPE(LN(F96:F100),LN(A96:A100))   | =RSQ(LN(F96:F100),LN(A96:A100))   | =STDEV.P(F96:F100)/AVERAGE(F96:F100)   | =IF(MAX(F97:F99)>(1+BD_Tol/2)*MAX(F96,F100),1,0)    | =IF(AND(ABS(H98)<=BD_Tol,OR(I98>=BD_R2,J98<=BD_Tol/2),K98=0),0,IF(AND(ABS(H98-BD_SLin)<=BD_Tol,ABS(G98-BD_SLin)<=BD_Tol,I98>=BD_R2),BD_SLin,IF(AND(ABS(H98-BD_SBil)<=BD_Tol,ABS(G98-BD_SBil)<=BD_Tol,I98>=BD_R2),BD_SBil,IF(ABS(G98-1)<=BD_Tol,1,-1))))            |
| 99  | 3.16                                                                                                                                                                  | =CHOOSE(BD_Case,C99,D99,E99)                                                                                                                                                                                                                                                            | =PO.PTA.Pw.VW.LinSealF(A99,BD_q,BD_Bo,BD_mu,BD_C,BD_rw,BD_ModelS,BD_ct,BD_phi,BD_h,BD_ModelK,BD_Lb)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           | 185.8079            | 109.7596              | =PO.DCA.Diag.Bourdet.SemiLog($A$71:$A$114,$B$71:$B$114,A99,BD_L)  | =F99/B99   | =SLOPE(LN(F97:F101),LN(A97:A101))   | =RSQ(LN(F97:F101),LN(A97:A101))   | =STDEV.P(F97:F101)/AVERAGE(F97:F101)   | =IF(MAX(F98:F100)>(1+BD_Tol/2)*MAX(F97,F101),1,0)   | =IF(AND(ABS(H99)<=BD_Tol,OR(I99>=BD_R2,J99<=BD_Tol/2),K99=0),0,IF(AND(ABS(H99-BD_SLin)<=BD_Tol,ABS(G99-BD_SLin)<=BD_Tol,I99>=BD_R2),BD_SLin,IF(AND(ABS(H99-BD_SBil)<=BD_Tol,ABS(G99-BD_SBil)<=BD_Tol,I99>=BD_R2),BD_SBil,IF(ABS(G99-1)<=BD_Tol,1,-1))))            |
| 100 | 4.22                                                                                                                                                                  | =CHOOSE(BD_Case,C100,D100,E100)                                                                                                                                                                                                                                                         | =PO.PTA.Pw.VW.LinSealF(A100,BD_q,BD_Bo,BD_mu,BD_C,BD_rw,BD_ModelS,BD_ct,BD_phi,BD_h,BD_ModelK,BD_Lb)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          | 200.6046            | 122.9112              | =PO.DCA.Diag.Bourdet.SemiLog($A$71:$A$114,$B$71:$B$114,A100,BD_L) | =F100/B100 | =SLOPE(LN(F98:F102),LN(A98:A102))   | =RSQ(LN(F98:F102),LN(A98:A102))   | =STDEV.P(F98:F102)/AVERAGE(F98:F102)   | =IF(MAX(F99:F101)>(1+BD_Tol/2)*MAX(F98,F102),1,0)   | =IF(AND(ABS(H100)<=BD_Tol,OR(I100>=BD_R2,J100<=BD_Tol/2),K100=0),0,IF(AND(ABS(H100-BD_SLin)<=BD_Tol,ABS(G100-BD_SLin)<=BD_Tol,I100>=BD_R2),BD_SLin,IF(AND(ABS(H100-BD_SBil)<=BD_Tol,ABS(G100-BD_SBil)<=BD_Tol,I100>=BD_R2),BD_SBil,IF(ABS(G100-1)<=BD_Tol,1,-1)))) |
| 101 | 5.62                                                                                                                                                                  | =CHOOSE(BD_Case,C101,D101,E101)                                                                                                                                                                                                                                                         | =PO.PTA.Pw.VW.LinSealF(A101,BD_q,BD_Bo,BD_mu,BD_C,BD_rw,BD_ModelS,BD_ct,BD_phi,BD_h,BD_ModelK,BD_Lb)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          | 216.2128            | 137.1602              | =PO.DCA.Diag.Bourdet.SemiLog($A$71:$A$114,$B$71:$B$114,A101,BD_L) | =F101/B101 | =SLOPE(LN(F99:F103),LN(A99:A103))   | =RSQ(LN(F99:F103),LN(A99:A103))   | =STDEV.P(F99:F103)/AVERAGE(F99:F103)   | =IF(MAX(F100:F102)>(1+BD_Tol/2)*MAX(F99,F103),1,0)  | =IF(AND(ABS(H101)<=BD_Tol,OR(I101>=BD_R2,J101<=BD_Tol/2),K101=0),0,IF(AND(ABS(H101-BD_SLin)<=BD_Tol,ABS(G101-BD_SLin)<=BD_Tol,I101>=BD_R2),BD_SLin,IF(AND(ABS(H101-BD_SBil)<=BD_Tol,ABS(G101-BD_SBil)<=BD_Tol,I101>=BD_R2),BD_SBil,IF(ABS(G101-1)<=BD_Tol,1,-1)))) |
| 102 | 7.5                                                                                                                                                                   | =CHOOSE(BD_Case,C102,D102,E102)                                                                                                                                                                                                                                                         | =PO.PTA.Pw.VW.LinSealF(A102,BD_q,BD_Bo,BD_mu,BD_C,BD_rw,BD_ModelS,BD_ct,BD_phi,BD_h,BD_ModelK,BD_Lb)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          | 232.8319            | 152.6844              | =PO.DCA.Diag.Bourdet.SemiLog($A$71:$A$114,$B$71:$B$114,A102,BD_L) | =F102/B102 | =SLOPE(LN(F100:F104),LN(A100:A104)) | =RSQ(LN(F100:F104),LN(A100:A104)) | =STDEV.P(F100:F104)/AVERAGE(F100:F104) | =IF(MAX(F101:F103)>(1+BD_Tol/2)*MAX(F100,F104),1,0) | =IF(AND(ABS(H102)<=BD_Tol,OR(I102>=BD_R2,J102<=BD_Tol/2),K102=0),0,IF(AND(ABS(H102-BD_SLin)<=BD_Tol,ABS(G102-BD_SLin)<=BD_Tol,I102>=BD_R2),BD_SLin,IF(AND(ABS(H102-BD_SBil)<=BD_Tol,ABS(G102-BD_SBil)<=BD_Tol,I102>=BD_R2),BD_SBil,IF(ABS(G102-1)<=BD_Tol,1,-1)))) |
| 103 | 10                                                                                                                                                                    | =CHOOSE(BD_Case,C103,D103,E103)                                                                                                                                                                                                                                                         | =PO.PTA.Pw.VW.LinSealF(A103,BD_q,BD_Bo,BD_mu,BD_C,BD_rw,BD_ModelS,BD_ct,BD_phi,BD_h,BD_ModelK,BD_Lb)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          | 250.2168            | 169.2251              | =PO.DCA.Diag.Bourdet.SemiLog($A$71:$A$114,$B$71:$B$114,A103,BD_L) | =F103/B103 | =SLOPE(LN(F101:F105),LN(A101:A105)) | =RSQ(LN(F101:F105),LN(A101:A105)) | =STDEV.P(F101:F105)/AVERAGE(F101:F105) | =IF(MAX(F102:F104)>(1+BD_Tol/2)*MAX(F101,F105),1,0) | =IF(AND(ABS(H103)<=BD_Tol,OR(I103>=BD_R2,J103<=BD_Tol/2),K103=0),0,IF(AND(ABS(H103-BD_SLin)<=BD_Tol,ABS(G103-BD_SLin)<=BD_Tol,I103>=BD_R2),BD_SLin,IF(AND(ABS(H103-BD_SBil)<=BD_Tol,ABS(G103-BD_SBil)<=BD_Tol,I103>=BD_R2),BD_SBil,IF(ABS(G103-1)<=BD_Tol,1,-1)))) |
| 104 | 13.3                                                                                                                                                                  | =CHOOSE(BD_Case,C104,D104,E104)                                                                                                                                                                                                                                                         | =PO.PTA.Pw.VW.LinSealF(A104,BD_q,BD_Bo,BD_mu,BD_C,BD_rw,BD_ModelS,BD_ct,BD_phi,BD_h,BD_ModelK,BD_Lb)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          | 268.1635            | 186.5374              | =PO.DCA.Diag.Bourdet.SemiLog($A$71:$A$114,$B$71:$B$114,A104,BD_L) | =F104/B104 | =SLOPE(LN(F102:F106),LN(A102:A106)) | =RSQ(LN(F102:F106),LN(A102:A106)) | =STDEV.P(F102:F106)/AVERAGE(F102:F106) | =IF(MAX(F103:F105)>(1+BD_Tol/2)*MAX(F102,F106),1,0) | =IF(AND(ABS(H104)<=BD_Tol,OR(I104>=BD_R2,J104<=BD_Tol/2),K104=0),0,IF(AND(ABS(H104-BD_SLin)<=BD_Tol,ABS(G104-BD_SLin)<=BD_Tol,I104>=BD_R2),BD_SLin,IF(AND(ABS(H104-BD_SBil)<=BD_Tol,ABS(G104-BD_SBil)<=BD_Tol,I104>=BD_R2),BD_SBil,IF(ABS(G104-1)<=BD_Tol,1,-1)))) |
| 105 | 17.8                                                                                                                                                                  | =CHOOSE(BD_Case,C105,D105,E105)                                                                                                                                                                                                                                                         | =PO.PTA.Pw.VW.LinSealF(A105,BD_q,BD_Bo,BD_mu,BD_C,BD_rw,BD_ModelS,BD_ct,BD_phi,BD_h,BD_ModelK,BD_Lb)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          | 287.1353            | 205.0237              | =PO.DCA.Diag.Bourdet.SemiLog($A$71:$A$114,$B$71:$B$114,A105,BD_L) | =F105/B105 | =SLOPE(LN(F103:F107),LN(A103:A107)) | =RSQ(LN(F103:F107),LN(A103:A107)) | =STDEV.P(F103:F107)/AVERAGE(F103:F107) | =IF(MAX(F104:F106)>(1+BD_Tol/2)*MAX(F103,F107),1,0) | =IF(AND(ABS(H105)<=BD_Tol,OR(I105>=BD_R2,J105<=BD_Tol/2),K105=0),0,IF(AND(ABS(H105-BD_SLin)<=BD_Tol,ABS(G105-BD_SLin)<=BD_Tol,I105>=BD_R2),BD_SLin,IF(AND(ABS(H105-BD_SBil)<=BD_Tol,ABS(G105-BD_SBil)<=BD_Tol,I105>=BD_R2),BD_SBil,IF(ABS(G105-1)<=BD_Tol,1,-1)))) |
| 106 | 23.7                                                                                                                                                                  | =CHOOSE(BD_Case,C106,D106,E106)                                                                                                                                                                                                                                                         | =PO.PTA.Pw.VW.LinSealF(A106,BD_q,BD_Bo,BD_mu,BD_C,BD_rw,BD_ModelS,BD_ct,BD_phi,BD_h,BD_ModelK,BD_Lb)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          | 306.2928            | 223.8243              | =PO.DCA.Diag.Bourdet.SemiLog($A$71:$A$114,$B$71:$B$114,A106,BD_L) | =F106/B106 | =SLOPE(LN(F104:F108),LN(A104:A108)) | =RSQ(LN(F104:F108),LN(A104:A108)) | =STDEV.P(F104:F108)/AVERAGE(F104:F108) | =IF(MAX(F105:F107)>(1+BD_Tol/2)*MAX(F104,F108),1,0) | =IF(AND(ABS(H106)<=BD_Tol,OR(I106>=BD_R2,J106<=BD_Tol/2),K106=0),0,IF(AND(ABS(H106-BD_SLin)<=BD_Tol,ABS(G106-BD_SLin)<=BD_Tol,I106>=BD_R2),BD_SLin,IF(AND(ABS(H106-BD_SBil)<=BD_Tol,ABS(G106-BD_SBil)<=BD_Tol,I106>=BD_R2),BD_SBil,IF(ABS(G106-1)<=BD_Tol,1,-1)))) |
| 107 | 31.6                                                                                                                                                                  | =CHOOSE(BD_Case,C107,D107,E107)                                                                                                                                                                                                                                                         | =PO.PTA.Pw.VW.LinSealF(A107,BD_q,BD_Bo,BD_mu,BD_C,BD_rw,BD_ModelS,BD_ct,BD_phi,BD_h,BD_ModelK,BD_Lb)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          | 325.9704            | 243.2316              | =PO.DCA.Diag.Bourdet.SemiLog($A$71:$A$114,$B$71:$B$114,A107,BD_L) | =F107/B107 | =SLOPE(LN(F105:F109),LN(A105:A109)) | =RSQ(LN(F105:F109),LN(A105:A109)) | =STDEV.P(F105:F109)/AVERAGE(F105:F109) | =IF(MAX(F106:F108)>(1+BD_Tol/2)*MAX(F105,F109),1,0) | =IF(AND(ABS(H107)<=BD_Tol,OR(I107>=BD_R2,J107<=BD_Tol/2),K107=0),0,IF(AND(ABS(H107-BD_SLin)<=BD_Tol,ABS(G107-BD_SLin)<=BD_Tol,I107>=BD_R2),BD_SLin,IF(AND(ABS(H107-BD_SBil)<=BD_Tol,ABS(G107-BD_SBil)<=BD_Tol,I107>=BD_R2),BD_SBil,IF(ABS(G107-1)<=BD_Tol,1,-1)))) |
| 108 | 42.2                                                                                                                                                                  | =CHOOSE(BD_Case,C108,D108,E108)                                                                                                                                                                                                                                                         | =PO.PTA.Pw.VW.LinSealF(A108,BD_q,BD_Bo,BD_mu,BD_C,BD_rw,BD_ModelS,BD_ct,BD_phi,BD_h,BD_ModelK,BD_Lb)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          | 346.1015            | 263.1563              | =PO.DCA.Diag.Bourdet.SemiLog($A$71:$A$114,$B$71:$B$114,A108,BD_L) | =F108/B108 | =SLOPE(LN(F106:F110),LN(A106:A110)) | =RSQ(LN(F106:F110),LN(A106:A110)) | =STDEV.P(F106:F110)/AVERAGE(F106:F110) | =IF(MAX(F107:F109)>(1+BD_Tol/2)*MAX(F106,F110),1,0) | =IF(AND(ABS(H108)<=BD_Tol,OR(I108>=BD_R2,J108<=BD_Tol/2),K108=0),0,IF(AND(ABS(H108-BD_SLin)<=BD_Tol,ABS(G108-BD_SLin)<=BD_Tol,I108>=BD_R2),BD_SLin,IF(AND(ABS(H108-BD_SBil)<=BD_Tol,ABS(G108-BD_SBil)<=BD_Tol,I108>=BD_R2),BD_SBil,IF(ABS(G108-1)<=BD_Tol,1,-1)))) |
| 109 | 56.2                                                                                                                                                                  | =CHOOSE(BD_Case,C109,D109,E109)                                                                                                                                                                                                                                                         | =PO.PTA.Pw.VW.LinSealF(A109,BD_q,BD_Bo,BD_mu,BD_C,BD_rw,BD_ModelS,BD_ct,BD_phi,BD_h,BD_ModelK,BD_Lb)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          | 366.3087            | 283.2073              | =PO.DCA.Diag.Bourdet.SemiLog($A$71:$A$114,$B$71:$B$114,A109,BD_L) | =F109/B109 | =SLOPE(LN(F107:F111),LN(A107:A111)) | =RSQ(LN(F107:F111),LN(A107:A111)) | =STDEV.P(F107:F111)/AVERAGE(F107:F111) | =IF(MAX(F108:F110)>(1+BD_Tol/2)*MAX(F107,F111),1,0) | =IF(AND(ABS(H109)<=BD_Tol,OR(I109>=BD_R2,J109<=BD_Tol/2),K109=0),0,IF(AND(ABS(H109-BD_SLin)<=BD_Tol,ABS(G109-BD_SLin)<=BD_Tol,I109>=BD_R2),BD_SLin,IF(AND(ABS(H109-BD_SBil)<=BD_Tol,ABS(G109-BD_SBil)<=BD_Tol,I109>=BD_R2),BD_SBil,IF(ABS(G109-1)<=BD_Tol,1,-1)))) |
| 110 | 75                                                                                                                                                                    | =CHOOSE(BD_Case,C110,D110,E110)                                                                                                                                                                                                                                                         | =PO.PTA.Pw.VW.LinSealF(A110,BD_q,BD_Bo,BD_mu,BD_C,BD_rw,BD_ModelS,BD_ct,BD_phi,BD_h,BD_ModelK,BD_Lb)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          | 386.8723            | 303.6497              | =PO.DCA.Diag.Bourdet.SemiLog($A$71:$A$114,$B$71:$B$114,A110,BD_L) | =F110/B110 | =SLOPE(LN(F108:F112),LN(A108:A112)) | =RSQ(LN(F108:F112),LN(A108:A112)) | =STDEV.P(F108:F112)/AVERAGE(F108:F112) | =IF(MAX(F109:F111)>(1+BD_Tol/2)*MAX(F108,F112),1,0) | =IF(AND(ABS(H110)<=BD_Tol,OR(I110>=BD_R2,J110<=BD_Tol/2),K110=0),0,IF(AND(ABS(H110-BD_SLin)<=BD_Tol,ABS(G110-BD_SLin)<=BD_Tol,I110>=BD_R2),BD_SLin,IF(AND(ABS(H110-BD_SBil)<=BD_Tol,ABS(G110-BD_SBil)<=BD_Tol,I110>=BD_R2),BD_SBil,IF(ABS(G110-1)<=BD_Tol,1,-1)))) |
| 111 | 100                                                                                                                                                                   | =CHOOSE(BD_Case,C111,D111,E111)                                                                                                                                                                                                                                                         | =PO.PTA.Pw.VW.LinSealF(A111,BD_q,BD_Bo,BD_mu,BD_C,BD_rw,BD_ModelS,BD_ct,BD_phi,BD_h,BD_ModelK,BD_Lb)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          | 407.5334            | 324.218               | =PO.DCA.Diag.Bourdet.SemiLog($A$71:$A$114,$B$71:$B$114,A111,BD_L) | =F111/B111 | =SLOPE(LN(F109:F113),LN(A109:A113)) | =RSQ(LN(F109:F113),LN(A109:A113)) | =STDEV.P(F109:F113)/AVERAGE(F109:F113) | =IF(MAX(F110:F112)>(1+BD_Tol/2)*MAX(F109,F113),1,0) | =IF(AND(ABS(H111)<=BD_Tol,OR(I111>=BD_R2,J111<=BD_Tol/2),K111=0),0,IF(AND(ABS(H111-BD_SLin)<=BD_Tol,ABS(G111-BD_SLin)<=BD_Tol,I111>=BD_R2),BD_SLin,IF(AND(ABS(H111-BD_SBil)<=BD_Tol,ABS(G111-BD_SBil)<=BD_Tol,I111>=BD_R2),BD_SBil,IF(ABS(G111-1)<=BD_Tol,1,-1)))) |
| 112 | 133                                                                                                                                                                   | =CHOOSE(BD_Case,C112,D112,E112)                                                                                                                                                                                                                                                         | =PO.PTA.Pw.VW.LinSealF(A112,BD_q,BD_Bo,BD_mu,BD_C,BD_rw,BD_ModelS,BD_ct,BD_phi,BD_h,BD_ModelK,BD_Lb)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          | 428.1358            | 344.7493              | =PO.DCA.Diag.Bourdet.SemiLog($A$71:$A$114,$B$71:$B$114,A112,BD_L) | =F112/B112 | =SLOPE(LN(F110:F114),LN(A110:A114)) | =RSQ(LN(F110:F114),LN(A110:A114)) | =STDEV.P(F110:F114)/AVERAGE(F110:F114) | =IF(MAX(F111:F113)>(1+BD_Tol/2)*MAX(F110,F114),1,0) | =IF(AND(ABS(H112)<=BD_Tol,OR(I112>=BD_R2,J112<=BD_Tol/2),K112=0),0,IF(AND(ABS(H112-BD_SLin)<=BD_Tol,ABS(G112-BD_SLin)<=BD_Tol,I112>=BD_R2),BD_SLin,IF(AND(ABS(H112-BD_SBil)<=BD_Tol,ABS(G112-BD_SBil)<=BD_Tol,I112>=BD_R2),BD_SBil,IF(ABS(G112-1)<=BD_Tol,1,-1)))) |
| 113 | 178                                                                                                                                                                   | =CHOOSE(BD_Case,C113,D113,E113)                                                                                                                                                                                                                                                         | =PO.PTA.Pw.VW.LinSealF(A113,BD_q,BD_Bo,BD_mu,BD_C,BD_rw,BD_ModelS,BD_ct,BD_phi,BD_h,BD_ModelK,BD_Lb)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          | 449.2842            | 365.842               | =PO.DCA.Diag.Bourdet.SemiLog($A$71:$A$114,$B$71:$B$114,A113,BD_L) | =F113/B113 |                                     |                                   |                                        |                                                     | =IF(ABS(G113-1)<=BD_Tol,1,-1)                                                                                                                                                                                                                                      |
| 114 | 237                                                                                                                                                                   | =CHOOSE(BD_Case,C114,D114,E114)                                                                                                                                                                                                                                                         | =PO.PTA.Pw.VW.LinSealF(A114,BD_q,BD_Bo,BD_mu,BD_C,BD_rw,BD_ModelS,BD_ct,BD_phi,BD_h,BD_ModelK,BD_Lb)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          | 470.1282            | 386.6441              | =PO.DCA.Diag.Bourdet.SemiLog($A$71:$A$114,$B$71:$B$114,A114,BD_L) | =F114/B114 |                                     |                                   |                                        |                                                     | =IF(ABS(G114-1)<=BD_Tol,1,-1)                                                                                                                                                                                                                                      |

## 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.Bilinear.Fit | =LAMBDA(t, dp, q, B, mu, h, phi, ct, k, output, LET(x, t^0.25, m, SLOPE(dp, x), icpt, INTERCEPT(dp, x), kfw, (141.2*2.4508334*0.0002637^0.25*q*B*mu/(h*m))^2/SQRT(phi*mu*ct*k), IF(m<=0, NA(), IF(output="m", m, IF(output="b", icpt, IF(output="kfw", kfw, NA())))))) | Bilinear-flow fit of a fractured well: least squares of Δp against Δt^¼ (h) over the points given; output "m" [psi/h^¼], "b" [psi] or "kfw" [md·ft], the fracture conductivity from the slope. |
| PO.PTA.Linear.SqrtT | =LAMBDA(t, dp, q, B, mu, h, phi, ct, k, output, LET(x, SQRT(t), m, SLOPE(dp, x), icpt, INTERCEPT(dp, x), xfrk, 141.2*SQRT(PI()*0.0002637)*q*B/(m*h)*SQRT(mu/(phi*ct)), IF(m<=0, NA(), IF(output="m", m, IF(output="b", icpt, IF(output="xfrk", xfrk, IF(output="xf", xfrk/SQRT(k), NA()))))))) | Linear-flow fit of a fractured well: least squares of Δp against √Δt (h) over the points given; output "m" [psi/√h], "b" [psi], "xfrk" [ft·md^½] or "xf" [ft] at the permeability given. |

## Names

| Name | RefersTo | Comment |
|------|----------|---------|
| BD_q | $B$4 | Rate, q, STB/d |
| BD_Bo | $B$5 | Oil formation volume factor, Bo, bbl/STB |
| BD_mu | $B$6 | Oil viscosity, μ, cp |
| BD_phi | $B$7 | Porosity, φ, % |
| BD_ct | $B$8 | Total compressibility, ct, 1/psi |
| BD_rw | $B$9 | Wellbore radius, rw, ft |
| BD_h | $B$10 | Net pay, h, ft |
| BD_L | $B$12 | Bourdet smoothing window, L, cycles |
| BD_Tol | $B$13 | Slope tolerance about each regime's slope, ± |
| BD_R2 | $B$14 | Least R² of a window's log-log line |
| BD_Span | $B$15 | Late level and line over the last, cycles |
| BD_RTol | $B$16 | Fault: late level within ± of twice the radial, % |
| BD_KTol | $B$17 | Round trip: k recovered within ±, % |
| BD_Case | $B$19 | Data: 1 fault, 2 finite-cond., 3 infinite-cond. frac |
| BD_ModelK | $B$20 | Case 1 model permeability, mD |
| BD_ModelS | $B$21 | Case 1 model skin factor |
| BD_C | $B$22 | Case 1 wellbore storage coefficient, C, bbl/psi |
| BD_Lb | $B$23 | Case 1 distance to the sealing fault, ft |
| BD_Inputs | $B$4:$B$23 | Rate, fluid and rock, the Bourdet window, the slope tolerance and R², the late window, the fault and round-trip limits, and which example the data is |
| BD_RadStart | $B$26 | Radial flow (zero slope) starts at Δt, hr |
| BD_RadEnd | $B$27 | Radial flow ends at Δt (its first run), hr |
| BD_NRad | $B$28 | Radial points |
| BD_Before | $B$29 | Early regimes are read before Δt, hr |
| BD_Level | $B$30 | Derivative level over radial flow, psi |
| BD_M | $B$31 | Semilog slope, m, psi/cycle |
| BD_Dp1h | $B$32 | Radial line's Δp at 1 hr, psi |
| BD_K | $B$33 | Permeability, k, mD |
| BD_S | $B$34 | Skin factor, S |
| BD_NSto | $B$35 | Unit-slope (storage) points before radial flow |
| BD_Cfit | $B$36 | Wellbore storage, C = q·B·Δt/(24·Δp) over them, bbl/psi |
| BD_NBil | $B$37 | Quarter-slope (bilinear) points |
| BD_mBil | $B$38 | Bilinear slope, Δp against t^¼, psi/hr^¼ |
| BD_Kfw | $B$39 | Fracture conductivity, kf·w, md·ft |
| BD_NLin | $B$40 | Half-slope (linear) points |
| BD_mLin | $B$41 | Linear slope, Δp against √t, psi/√hr |
| BD_Xf | $B$42 | Fracture half-length, xf, ft |
| BD_NBnd | $B$43 | Points after radial flow |
| BD_Ratio | $B$44 | Late derivative over the radial level |
| BD_LateSlope | $B$45 | Late log-log slope of the derivative |
| BD_mLate | $B$46 | Late semilog slope, psi/cycle |
| BD_bLate | $B$47 | Late line's Δp at 1 hr, psi |
| BD_Tx | $B$48 | Δt where the radial and late lines cross, hr |
| BD_Dist | $B$49 | Distance to a sealing fault, √(0.000148·k·tx/(φμct)), ft |
| BD_KModel | $B$50 | The example's permeability, mD |
| BD_KErr | $B$51 | k against the example's, % |
| BD_XErr | $B$52 | Fault, kf·w or xf (case 1, 2, 3) against the example, % |
| BD_SetCheck | $B$53 | Settings check verdict |
| BD_SetCheckNote | $C$53 | Settings check comment |
| BD_RegimeCheck | $B$54 | Regime check verdict |
| BD_RegimeCheckNote | $C$54 | Regime check comment |
| BD_BoundaryCheck | $B$55 | Boundary check verdict |
| BD_BoundaryCheckNote | $C$55 | Boundary check comment |
| BD_TripCheck | $B$56 | Round trip on the example data verdict |
| BD_TripCheckNote | $C$56 | Round trip on the example data comment |
| BD_Results | $B$26:$B$56 | Each regime's points and fit: C, kf·w, xf, the radial window, k and S, the late level and slope, the fault distance, the round trip and the checks |
| BD_Hr | $B$59 | Hours in a day, hr/d |
| BD_SBil | $B$60 | Bilinear-flow log-log slope |
| BD_SLin | $B$61 | Linear-flow log-log slope |
| BD_Gray | $B$62 | Fault distance constant (Gray) |
| BD_FracK | $B$63 | Cases 2 and 3: permeability, mD |
| BD_FracXf | $B$64 | Cases 2 and 3: fracture half-length, ft |
| BD_MinN | $B$66 | Fewest points a regime's line is fitted to |
| BD_FracKfw | $B$65 | Case 2: fracture conductivity (F_CD = 2), md·ft |
| BD_Data | $A$71:$E$114 | Elapsed time and Δp (the chosen example's until you paste a gauge's), and the three examples |
| BD_Analysis | $F$71:$L$114 | Per row: the Bourdet derivative, Δp's log-log slope, the derivative's slope, R², scatter and hump over five rows, and the regime, as its slope: 1 storage, ¼ bilinear, ½ linear, 0 radial, −1 none |
| BD_Curve | $A$71:$F$114 | Log-Log Diagnostic |

---

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

