---
cid: po.bp.pta.gas.pseudopressure
hub: pta
tags: [gas, pseudo-pressure, pseudo-time, buildup, Horner, rate-dependent-skin, non-Darcy, well-testing]
facets: { discipline: reservoir, phase: gas, property: pseudo-pressure }
title: Gas Buildup in Pseudo-Pressure
summary: "Reads permeability, mechanical skin and the rate-dependent skin coefficient from two gas-well buildups after two rates."
slug: po.pta.gas.pseudopressure
type: worksheet
---

# Gas Buildup in Pseudo-Pressure

## Description

What permeability, mechanical skin and rate-dependent skin does a gas well show in two buildups after two rates? You paste each buildup's shut-in times and pressures and set the rates, the flow time, the gas and the rock. The sheet reads each buildup in the real-gas pseudo-pressure m(p) against pseudo-time, which make the gas flow equation behave like a liquid's, and fits its Horner line for k and the apparent skin S′. You read off k, the mechanical skin S and the rate-dependent coefficient D.

**Parameters:**
- **Reservoir, gas and well**: pi, T, the gas gravity, h, φ, Swi, the rock and water compressibility, rw and the base pressure of m(p) (`GPB_Pi`, `GPB_T`, `GPB_SG`, `GPB_h`, `GPB_phi`, `GPB_Swi`, `GPB_cf`, `GPB_rw`, `GPB_Pbase`)
- **The two buildups**: the two rates, the flow time before each, and the flowing pressure at each shut-in (`GPB_q1`, `GPB_q2`, `GPB_tp`, `GPB_Pwf1`, `GPB_Pwf2`; 0 takes the model's)
- **Analysis settings**: the Bourdet window (`GPB_L`, 0.2), the radial-flow window in pseudo-time (`GPB_From`, `GPB_To`, 2.37 to 23.7 hr), how flat the derivative must be over it (`GPB_Flat`, ±10 %), and the round-trip tolerance on k and D (`GPB_Tol`, ±5 %)
- **Synthetic model**: k, S, D and the wellbore storage coefficient the buildups are made from (`GPB_ModelK`, `GPB_ModelS`, `GPB_ModelD`, `GPB_C`)
- **Shut-in data**: Δt and pws of each buildup, the regions `GPB_Data1` and `GPB_Data2`

**How to use it:** Paste each buildup's Δt and pws over columns B and C. Type the flowing pressure at each shut-in into the two pwf inputs, set the rates and the flow time, and move the window onto the flat stretch of the derivative. Column A, the model's pseudo-time grid, is then unused, and the round-trip check doesn't apply. Two buildups after two different rates are needed for D. With only one, S′ is the result, and S = S′ − D·q needs a D from a correlation, such as the add-in's non-Darcy coefficient for a gas well. The sheet ships two synthetic buildups made from a model, so every result can be checked against the model that made it. A log-log plot draws the second buildup's Δm(p) and its derivative, a Horner plot draws both buildups with their lines, and a third plot draws S′ against rate.

**Method:** A gas well's skin grows with rate, S′ = S + D·q, because the flow near the well is turbulent; the two buildups' S′ therefore split into the mechanical skin S and the rate-dependent coefficient D. At pi the sheet takes Z by Dranchuk and Abou-Kassem at Sutton's pseudo-critical properties, and μg by Lee, Gonzalez and Eakin. It takes ct = (1 − Swi)·cg + cf with cg by its definition, and m(pi) from the pseudo-pressure integral (50 trapezoid steps). For each buildup row:

- μg·ct at pws, from the same functions;
- pseudo-time, Δta = Σ (μi·cti)·Δt/(μg·ct), the trapezoid of 1/(μg·ct) between rows, normalized at pi, from the flowing pressure at shut-in;
- m(pws) − m(pwf), the Horner ratio (tp + Δta)/Δta, Agarwal's te = tp·Δta/(tp + Δta), and the Bourdet derivative of Δm against ln te.

The Horner line is the least-squares line of m(pws) against log₁₀ of the ratio over the window's rows. Its slope's magnitude is m, and its value at Δta = 1 hr is m1hr. Then k = 1637·q·T/(m·h), and S′ = 1.151·[(m1hr − m(pwf))/m − log₁₀(k/(φ·μi·cti·rw²)) + 3.23], the liquid Horner skin with m(p) for p and μi·cti for μ·ct. D = (S′2 − S′1)/(q2 − q1), S = S′1 − D·q1, and k is the two buildups' mean.

- **The synthetic buildups** are the liquid solution written in m(p) and pseudo-time, which is what the two variables are for. The vertical-well model with storage and skin gives the buildup of a well with storage C and skin S + D·q, at q from 0 to tp and then shut in, on a grid of pseudo-times, with B = 1 and μi·cti in the diffusivity. Times 1422·T/(141.2·μi), that is Δm. A natural cubic spline through an m(p) table from 0.3·pi to 1.2·pi turns m(pws) back into pws. The real time Δt then follows by running the pseudo-time sum backwards along the model's pws. The analysis starts again from Δt and pws alone, as it would on a gauge's data.

**Example:** The gas and the well are the gas-inflow family's reference well: a 0.7 gravity sweet gas at 3,000 psia and 160 °F, 8 mD over 40 ft, rw 0.354 ft, a skin of 2, and D = 4.52 × 10⁻⁴ d/Mscf from the non-Darcy coefficient correlation with half the pay open. The sheet takes φ = 15 %, Swi = 25 %, cf = 4 × 10⁻⁶ 1/psi and C = 0.01 bbl/psi. At pi, Z = 0.8512, μi = 0.02131 cp, cti = 2.234 × 10⁻⁴ 1/psi and m(pi) = 6.135 × 10⁸ psi²/cp. The well flows 24 hr at 3,000 Mscf/d, and again at 8,000 Mscf/d, each to 2,737 and 2,107 psia, and each buildup is read for 23.7 hr of pseudo-time. Over the window from 2.37 to 23.7 hr, both derivatives are flat within ±1 %. Buildup 1 gives m = 9.591 × 10⁶ psi²/cp/cycle, k = 7.93 mD and S′ = 3.26. Buildup 2 gives m = 2.563 × 10⁷, k = 7.92 mD and S′ = 5.47. So k = 7.92 mD, D = 4.43 × 10⁻⁴ d/Mscf and S = 1.93. That is 0.9 % below the model's k, 2.0 % below its D and 0.07 below its skin, within the ±5 % tolerance. The small shortfall is the Horner line's, fitted over a buildup as long as the flow before it. Turbulence makes 65 % of S′ at 8,000 Mscf/d. Pseudo-time runs 0.6 % and 1.6 % behind real time at the end of the two buildups, more after the larger drawdown.

The sheet was checked against a standalone script. It rebuilds both buildups from the Engineering library's liquid PTA model and its Gauss-Legendre m(p), over the library's DAK, LGE and Sutton correlations, with m(p) inverted by bisection rather than a spline and cg by differencing DAK's Z. It then repeats the analysis with the library's Horner skin. It gives pwf 2,737.37 and 2,107.02 psia, slopes 9,590,592 and 25,629,117, k 7.93277 and 7.91599 mD, S′ 3.25768 and 5.47348, D 4.43159 × 10⁻⁴ and S 1.92821, all within 0.02 % of the sheet. Z and μg at pi are the gas-inflow sheets' (0.8512, 0.02131 cp), and the library's m(pi) is 613,556,320 psi²/cp, 0.007 % above the sheet's 50-step trapezoid. No printed two-rate gas buildup with pseudo-time and every input given was available, so the sheet is not compared with a published one.

## Validity

A single-phase dry or sweet gas in a homogeneous, infinite-acting reservoir, with radial flow over the window. DAK at Sutton's pseudo-criticals holds for a sweet gas: correct a sour gas's pseudo-criticals by Wichert-Aziz first. Pseudo-time evaluated at the wellbore pressure corrects the storage period and the early derivative, where μg·ct changes most. The flow period's own pseudo-time is taken as tp, because the reservoir around the well stays near pi while it flows. Horner's line is fitted over a buildup as long as the flow before it, so its slope reads about 1 % steep: a longer flow period reduces that. The model treats each buildup as starting from pi, as in an isochronal test. After a flow-after-flow sequence, use the multi-rate superposition time instead, as on the Drill-Stem Test Analysis sheet. D comes from the difference of two S′, so the two rates should differ by a factor of two or more. With close rates, the noise in the two skins swamps D·Δq. The sheet does not fit the whole buildup by nonlinear regression on a gas model; the add-in has no function for it.

Named alternatives: the pressure-squared form below about 2,000 psia and the pressure form above about 3,000 psia, which the Gas Well Deliverability sheet compares; the LIT or backpressure deliverability test for D; and nonlinear regression of the whole buildup on a gas model.

## References

- Al-Hussainy, R., Ramey, H.J. Jr. and Crawford, P.B. (1966). The Flow of Real Gases Through Porous Media. *JPT* 18(5), 624–636.
- Agarwal, R.G. (1979). "Real Gas Pseudo-Time": A New Function for Pressure Buildup Analysis of MHF Gas Wells. SPE-8279-MS.
- Lee, J. and Wattenbarger, R.A. (1996). *Gas Reservoir Engineering*. SPE Textbook Series Vol. 5 (gas well testing, pseudo-time, non-Darcy skin).
- Earlougher, R.C. Jr. (1977). *Advances in Well Test Analysis*. SPE Monograph 5 (gas well testing).
- Dranchuk, P.M. and Abou-Kassem, J.H. (1975). Calculation of Z Factors for Natural Gases Using Equations of State. *JCPT* 14(3), 34–36.
- Lee, A.L., Gonzalez, M.H. and Eakin, B.E. (1966). The Viscosity of Natural Gases. *JPT* 18(8), 997–1000.

## Functions used

`PO.PVT.Ppc.BySutton`, `PO.PVT.Tpc.BySutton`, `PO.PVT.Z.ByDAK`, `PO.PVT.Ug.ByLGE`, `PO.PVT.Cg.ByDefinition`, `PO.PVT.PseudoP`, `PO.Spline.Cubic.Interp`, `PO.PTA.Pw.VW`, `PO.PTA.Horner.S`, `PO.DCA.Diag.Bourdet.SemiLog`

## Spreadsheet: PtaGasPseudopressure

|     | A                                                                                                                                                      | B                                                                                                                                                                                | C                                                                                                                                                                                                                                                                                                                   | D                                                                                                                                         | E                                                            | F                                                                              | G                          | H                   | I                          | J                                                                    | K                                                                 |
|-----|--------------------------------------------------------------------------------------------------------------------------------------------------------|----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|-------------------------------------------------------------------------------------------------------------------------------------------|--------------------------------------------------------------|--------------------------------------------------------------------------------|----------------------------|---------------------|----------------------------|----------------------------------------------------------------------|-------------------------------------------------------------------|
| 1   | Gas Buildup in Pseudo-Pressure                                                                                                                         |                                                                                                                                                                                  | Petroleum Office                                                                                                                                                                                                                                                                                                    |                                                                                                                                           |                                                              |                                                                                |                            |                     |                            |                                                                      |                                                                   |
| 2   | Blue cells on yellow are inputs. Two buildups after two rates, each read in m(p) against pseudo-time; their two apparent skins split into S and D·q.   |                                                                                                                                                                                  |                                                                                                                                                                                                                                                                                                                     |                                                                                                                                           |                                                              |                                                                                |                            |                     |                            |                                                                      |                                                                   |
| 3   | Reservoir, Gas and Well                                                                                                                                |                                                                                                                                                                                  |                                                                                                                                                                                                                                                                                                                     | Model p (psia)                                                                                                                            | m(p) (psi²/cp)                                               |                                                                                |                            |                     |                            |                                                                      |                                                                   |
| 4   | Initial reservoir pressure, pi                                                                                                                         | 3000                                                                                                                                                                             | psia                                                                                                                                                                                                                                                                                                                | =GPB_Pi*(15)/50                                                                                                                           | =PO.PVT.PseudoP(D4,GPB_T+GPB_R0,GPB_SG,GPB_Pbase,GPB_Steps)  |                                                                                |                            |                     |                            |                                                                      |                                                                   |
| 5   | Reservoir temperature, T                                                                                                                               | 160                                                                                                                                                                              | °F                                                                                                                                                                                                                                                                                                                  | =GPB_Pi*(18)/50                                                                                                                           | =PO.PVT.PseudoP(D5,GPB_T+GPB_R0,GPB_SG,GPB_Pbase,GPB_Steps)  |                                                                                |                            |                     |                            |                                                                      |                                                                   |
| 6   | Gas specific gravity (air = 1), sweet gas                                                                                                              | 0.7                                                                                                                                                                              | air = 1                                                                                                                                                                                                                                                                                                             | =GPB_Pi*(21)/50                                                                                                                           | =PO.PVT.PseudoP(D6,GPB_T+GPB_R0,GPB_SG,GPB_Pbase,GPB_Steps)  |                                                                                |                            |                     |                            |                                                                      |                                                                   |
| 7   | Net pay, h                                                                                                                                             | 40                                                                                                                                                                               | ft                                                                                                                                                                                                                                                                                                                  | =GPB_Pi*(24)/50                                                                                                                           | =PO.PVT.PseudoP(D7,GPB_T+GPB_R0,GPB_SG,GPB_Pbase,GPB_Steps)  |                                                                                |                            |                     |                            |                                                                      |                                                                   |
| 8   | Porosity, φ                                                                                                                                            | 0.15                                                                                                                                                                             | %                                                                                                                                                                                                                                                                                                                   | =GPB_Pi*(27)/50                                                                                                                           | =PO.PVT.PseudoP(D8,GPB_T+GPB_R0,GPB_SG,GPB_Pbase,GPB_Steps)  |                                                                                |                            |                     |                            |                                                                      |                                                                   |
| 9   | Water saturation, Swi                                                                                                                                  | 0.25                                                                                                                                                                             | %                                                                                                                                                                                                                                                                                                                   | =GPB_Pi*(30)/50                                                                                                                           | =PO.PVT.PseudoP(D9,GPB_T+GPB_R0,GPB_SG,GPB_Pbase,GPB_Steps)  |                                                                                |                            |                     |                            |                                                                      |                                                                   |
| 10  | Rock and water compressibility, cf + Swi·cw                                                                                                            | 0.000004                                                                                                                                                                         | 1/psi                                                                                                                                                                                                                                                                                                               | =GPB_Pi*(33)/50                                                                                                                           | =PO.PVT.PseudoP(D10,GPB_T+GPB_R0,GPB_SG,GPB_Pbase,GPB_Steps) |                                                                                |                            |                     |                            |                                                                      |                                                                   |
| 11  | Wellbore radius, rw                                                                                                                                    | 0.354                                                                                                                                                                            | ft                                                                                                                                                                                                                                                                                                                  | =GPB_Pi*(36)/50                                                                                                                           | =PO.PVT.PseudoP(D11,GPB_T+GPB_R0,GPB_SG,GPB_Pbase,GPB_Steps) |                                                                                |                            |                     |                            |                                                                      |                                                                   |
| 12  | Base pressure of m(p)                                                                                                                                  | 14.7                                                                                                                                                                             | psia                                                                                                                                                                                                                                                                                                                | =GPB_Pi*(39)/50                                                                                                                           | =PO.PVT.PseudoP(D12,GPB_T+GPB_R0,GPB_SG,GPB_Pbase,GPB_Steps) |                                                                                |                            |                     |                            |                                                                      |                                                                   |
| 13  | The Two Buildups                                                                                                                                       |                                                                                                                                                                                  |                                                                                                                                                                                                                                                                                                                     | =GPB_Pi*(42)/50                                                                                                                           | =PO.PVT.PseudoP(D13,GPB_T+GPB_R0,GPB_SG,GPB_Pbase,GPB_Steps) |                                                                                |                            |                     |                            |                                                                      |                                                                   |
| 14  | Rate before buildup 1, q1                                                                                                                              | 3000                                                                                                                                                                             | Mscf/d                                                                                                                                                                                                                                                                                                              | =GPB_Pi*(45)/50                                                                                                                           | =PO.PVT.PseudoP(D14,GPB_T+GPB_R0,GPB_SG,GPB_Pbase,GPB_Steps) |                                                                                |                            |                     |                            |                                                                      |                                                                   |
| 15  | Rate before buildup 2, q2                                                                                                                              | 8000                                                                                                                                                                             | Mscf/d                                                                                                                                                                                                                                                                                                              | =GPB_Pi*(48)/50                                                                                                                           | =PO.PVT.PseudoP(D15,GPB_T+GPB_R0,GPB_SG,GPB_Pbase,GPB_Steps) |                                                                                |                            |                     |                            |                                                                      |                                                                   |
| 16  | Flow before each buildup, tp                                                                                                                           | 24                                                                                                                                                                               | hr                                                                                                                                                                                                                                                                                                                  | =GPB_Pi*(51)/50                                                                                                                           | =PO.PVT.PseudoP(D16,GPB_T+GPB_R0,GPB_SG,GPB_Pbase,GPB_Steps) |                                                                                |                            |                     |                            |                                                                      |                                                                   |
| 17  | pwf at shut-in, test 1 (0: the model's)                                                                                                                | 0                                                                                                                                                                                | psia                                                                                                                                                                                                                                                                                                                | =GPB_Pi*(54)/50                                                                                                                           | =PO.PVT.PseudoP(D17,GPB_T+GPB_R0,GPB_SG,GPB_Pbase,GPB_Steps) |                                                                                |                            |                     |                            |                                                                      |                                                                   |
| 18  | pwf at shut-in, test 2 (0: the model's)                                                                                                                | 0                                                                                                                                                                                | psia                                                                                                                                                                                                                                                                                                                | =GPB_Pi*(57)/50                                                                                                                           | =PO.PVT.PseudoP(D18,GPB_T+GPB_R0,GPB_SG,GPB_Pbase,GPB_Steps) |                                                                                |                            |                     |                            |                                                                      |                                                                   |
| 19  | Analysis Settings                                                                                                                                      |                                                                                                                                                                                  |                                                                                                                                                                                                                                                                                                                     | =GPB_Pi*(60)/50                                                                                                                           | =PO.PVT.PseudoP(D19,GPB_T+GPB_R0,GPB_SG,GPB_Pbase,GPB_Steps) |                                                                                |                            |                     |                            |                                                                      |                                                                   |
| 20  | Bourdet smoothing window, L                                                                                                                            | 0.2                                                                                                                                                                              | cycles                                                                                                                                                                                                                                                                                                              |                                                                                                                                           |                                                              |                                                                                |                            |                     |                            |                                                                      |                                                                   |
| 21  | IARF window from pseudo-time Δta                                                                                                                       | 2.37                                                                                                                                                                             | hr                                                                                                                                                                                                                                                                                                                  |                                                                                                                                           |                                                              |                                                                                |                            |                     |                            |                                                                      |                                                                   |
| 22  | IARF window to pseudo-time Δta                                                                                                                         | 23.7                                                                                                                                                                             | hr                                                                                                                                                                                                                                                                                                                  |                                                                                                                                           |                                                              |                                                                                |                            |                     |                            |                                                                      |                                                                   |
| 23  | Derivative flat within ± over the window                                                                                                               | 0.1                                                                                                                                                                              | %                                                                                                                                                                                                                                                                                                                   |                                                                                                                                           |                                                              |                                                                                |                            |                     |                            |                                                                      |                                                                   |
| 24  | Round trip: k and D recovered within ±                                                                                                                 | 0.05                                                                                                                                                                             | %                                                                                                                                                                                                                                                                                                                   |                                                                                                                                           |                                                              |                                                                                |                            |                     |                            |                                                                      |                                                                   |
| 25  | Synthetic Buildup Model                                                                                                                                |                                                                                                                                                                                  |                                                                                                                                                                                                                                                                                                                     |                                                                                                                                           |                                                              |                                                                                |                            |                     |                            |                                                                      |                                                                   |
| 26  | Model permeability                                                                                                                                     | 8                                                                                                                                                                                | mD                                                                                                                                                                                                                                                                                                                  |                                                                                                                                           |                                                              |                                                                                |                            |                     |                            |                                                                      |                                                                   |
| 27  | Model mechanical skin, S                                                                                                                               | 2                                                                                                                                                                                | —                                                                                                                                                                                                                                                                                                                   |                                                                                                                                           |                                                              |                                                                                |                            |                     |                            |                                                                      |                                                                   |
| 28  | Model rate-dependent skin coefficient, D                                                                                                               | 0.000452                                                                                                                                                                         | d/Mscf                                                                                                                                                                                                                                                                                                              |                                                                                                                                           |                                                              |                                                                                |                            |                     |                            |                                                                      |                                                                   |
| 29  | Wellbore storage coefficient, C                                                                                                                        | 0.01                                                                                                                                                                             | bbl/psi                                                                                                                                                                                                                                                                                                             |                                                                                                                                           |                                                              |                                                                                |                            |                     |                            |                                                                      |                                                                   |
| 31  | Gas at the Initial Pressure                                                                                                                            |                                                                                                                                                                                  |                                                                                                                                                                                                                                                                                                                     |                                                                                                                                           |                                                              |                                                                                |                            |                     |                            |                                                                      |                                                                   |
| 32  | Reservoir temperature, absolute                                                                                                                        | =GPB_T+GPB_R0                                                                                                                                                                    | °R                                                                                                                                                                                                                                                                                                                  |                                                                                                                                           |                                                              |                                                                                |                            |                     |                            |                                                                      |                                                                   |
| 33  | Pseudo-critical pressure (Sutton)                                                                                                                      | =PO.PVT.Ppc.BySutton(GPB_SG)                                                                                                                                                     | psia                                                                                                                                                                                                                                                                                                                |                                                                                                                                           |                                                              |                                                                                |                            |                     |                            |                                                                      |                                                                   |
| 34  | Pseudo-reduced temperature, T/Tpc (Sutton)                                                                                                             | =GPB_TR/PO.PVT.Tpc.BySutton(GPB_SG)                                                                                                                                              | —                                                                                                                                                                                                                                                                                                                   |                                                                                                                                           |                                                              |                                                                                |                            |                     |                            |                                                                      |                                                                   |
| 35  | Z-factor at pi                                                                                                                                         | =PO.PVT.Z.ByDAK(GPB_Pi/GPB_Ppc,GPB_Tpr)                                                                                                                                          | —                                                                                                                                                                                                                                                                                                                   |                                                                                                                                           |                                                              |                                                                                |                            |                     |                            |                                                                      |                                                                   |
| 36  | Gas viscosity at pi, μi                                                                                                                                | =PO.PVT.Ug.ByLGE(GPB_Zi,GPB_SG,GPB_Pi,GPB_TR)                                                                                                                                    | cp                                                                                                                                                                                                                                                                                                                  |                                                                                                                                           |                                                              |                                                                                |                            |                     |                            |                                                                      |                                                                   |
| 37  | Total compressibility at pi, cti                                                                                                                       | =(1-GPB_Swi)*PO.PVT.Cg.ByDefinition(GPB_Pi,GPB_TR,GPB_SG)+GPB_cf                                                                                                                 | 1/psi                                                                                                                                                                                                                                                                                                               |                                                                                                                                           |                                                              |                                                                                |                            |                     |                            |                                                                      |                                                                   |
| 38  | μi·cti, the pseudo-time's reference                                                                                                                    | =GPB_Mui*GPB_Cti                                                                                                                                                                 | cp/psi                                                                                                                                                                                                                                                                                                              |                                                                                                                                           |                                                              |                                                                                |                            |                     |                            |                                                                      |                                                                   |
| 39  | Pseudo-pressure at pi, m(pi)                                                                                                                           | =PO.PVT.PseudoP(GPB_Pi,GPB_TR,GPB_SG,GPB_Pbase,GPB_Steps)                                                                                                                        | psi²/cp                                                                                                                                                                                                                                                                                                             |                                                                                                                                           |                                                              |                                                                                |                            |                     |                            |                                                                      |                                                                   |
| 40  | Model Δm per liquid-solution Δp, 1422·T/(141.2·μi)                                                                                                     | =GPB_K1422*GPB_TR/(GPB_K1412*GPB_Mui)                                                                                                                                            | —                                                                                                                                                                                                                                                                                                                   |                                                                                                                                           |                                                              |                                                                                |                            |                     |                            |                                                                      |                                                                   |
| 41  | The Synthetic Model at Shut-In                                                                                                                         |                                                                                                                                                                                  |                                                                                                                                                                                                                                                                                                                     |                                                                                                                                           |                                                              |                                                                                |                            |                     |                            |                                                                      |                                                                   |
| 42  | Model apparent skin, test 1, S + D·q1                                                                                                                  | =GPB_ModelS+GPB_ModelD*GPB_q1                                                                                                                                                    | —                                                                                                                                                                                                                                                                                                                   |                                                                                                                                           |                                                              |                                                                                |                            |                     |                            |                                                                      |                                                                   |
| 43  | Model apparent skin, test 2, S + D·q2                                                                                                                  | =GPB_ModelS+GPB_ModelD*GPB_q2                                                                                                                                                    | —                                                                                                                                                                                                                                                                                                                   |                                                                                                                                           |                                                              |                                                                                |                            |                     |                            |                                                                      |                                                                   |
| 44  | Model flowing pressure at shut-in, test 1                                                                                                              | =PO.Spline.Cubic.Interp(GPB_MTab,GPB_PTab,GPB_mPi-GPB_Scale*PO.PTA.Pw.VW(GPB_tp,GPB_q1,1,GPB_Mui,GPB_C,GPB_rw,GPB_S1,GPB_Cti,GPB_phi,GPB_h,GPB_ModelK))                          | psia                                                                                                                                                                                                                                                                                                                |                                                                                                                                           |                                                              |                                                                                |                            |                     |                            |                                                                      |                                                                   |
| 45  | Model flowing pressure at shut-in, test 2                                                                                                              | =PO.Spline.Cubic.Interp(GPB_MTab,GPB_PTab,GPB_mPi-GPB_Scale*PO.PTA.Pw.VW(GPB_tp,GPB_q2,1,GPB_Mui,GPB_C,GPB_rw,GPB_S2,GPB_Cti,GPB_phi,GPB_h,GPB_ModelK))                          | psia                                                                                                                                                                                                                                                                                                                |                                                                                                                                           |                                                              |                                                                                |                            |                     |                            |                                                                      |                                                                   |
| 46  | pwf at shut-in used, test 1                                                                                                                            | =IF(GPB_Pwf1>0,GPB_Pwf1,GPB_PwfModel1)                                                                                                                                           | psia                                                                                                                                                                                                                                                                                                                |                                                                                                                                           |                                                              |                                                                                |                            |                     |                            |                                                                      |                                                                   |
| 47  | pwf at shut-in used, test 2                                                                                                                            | =IF(GPB_Pwf2>0,GPB_Pwf2,GPB_PwfModel2)                                                                                                                                           | psia                                                                                                                                                                                                                                                                                                                |                                                                                                                                           |                                                              |                                                                                |                            |                     |                            |                                                                      |                                                                   |
| 48  | Buildup 1: Horner Line in m(p) Against Pseudo-Time                                                                                                     |                                                                                                                                                                                  |                                                                                                                                                                                                                                                                                                                     |                                                                                                                                           |                                                              |                                                                                |                            |                     |                            |                                                                      |                                                                   |
| 49  | m(pwf), test 1                                                                                                                                         | =LET(pwf_psia,GPB_PwfU1,PO.PVT.PseudoP(pwf_psia,GPB_TR,GPB_SG,GPB_Pbase,GPB_Steps))                                                                                              | psi²/cp                                                                                                                                                                                                                                                                                                             |                                                                                                                                           |                                                              |                                                                                |                            |                     |                            |                                                                      |                                                                   |
| 50  | μg·ct at pwf, test 1                                                                                                                                   | =PO.PVT.Ug.ByLGE(PO.PVT.Z.ByDAK(GPB_PwfU1/GPB_Ppc,GPB_Tpr),GPB_SG,GPB_PwfU1,GPB_TR)*((1-GPB_Swi)*PO.PVT.Cg.ByDefinition(GPB_PwfU1,GPB_TR,GPB_SG)+GPB_cf)                         | cp/psi                                                                                                                                                                                                                                                                                                              |                                                                                                                                           |                                                              |                                                                                |                            |                     |                            |                                                                      |                                                                   |
| 51  | Points in the IARF window, test 1                                                                                                                      | =SUM($K$122:$K$149)                                                                                                                                                              | —                                                                                                                                                                                                                                                                                                                   |                                                                                                                                           |                                                              |                                                                                |                            |                     |                            |                                                                      |                                                                   |
| 52  | Derivative spread over the window, test 1                                                                                                              | =(MAX(FILTER($J$122:$J$149,$K$122:$K$149=1))-MIN(FILTER($J$122:$J$149,$K$122:$K$149=1)))/(MAX(FILTER($J$122:$J$149,$K$122:$K$149=1))+MIN(FILTER($J$122:$J$149,$K$122:$K$149=1))) | %                                                                                                                                                                                                                                                                                                                   |                                                                                                                                           |                                                              |                                                                                |                            |                     |                            |                                                                      |                                                                   |
| 53  | Semilog slope in m(p), test 1                                                                                                                          | =-SLOPE(FILTER($F$122:$F$149,$K$122:$K$149=1),LOG10(FILTER($H$122:$H$149,$K$122:$K$149=1)))                                                                                      | psi²/cp/cycle                                                                                                                                                                                                                                                                                                       |                                                                                                                                           |                                                              |                                                                                |                            |                     |                            |                                                                      |                                                                   |
| 54  | Line's m(p) at Δta = 1 hr, test 1                                                                                                                      | =INTERCEPT(FILTER($F$122:$F$149,$K$122:$K$149=1),LOG10(FILTER($H$122:$H$149,$K$122:$K$149=1)))-GPB_M1*LOG10(GPB_tp+1)                                                            | psi²/cp                                                                                                                                                                                                                                                                                                             |                                                                                                                                           |                                                              |                                                                                |                            |                     |                            |                                                                      |                                                                   |
| 55  | Permeability, k = 1637·q·T/(m·h), test 1                                                                                                               | =GPB_K1637*GPB_q1*GPB_TR/(GPB_M1*GPB_h)                                                                                                                                          | mD                                                                                                                                                                                                                                                                                                                  |                                                                                                                                           |                                                              |                                                                                |                            |                     |                            |                                                                      |                                                                   |
| 56  | Apparent skin, S′ = S + D·q1                                                                                                                           | =PO.PTA.Horner.S(GPB_m1hr1,GPB_mPwf1,GPB_M1,GPB_k1,GPB_phi,GPB_Mui,GPB_Cti,GPB_rw)                                                                                               | —                                                                                                                                                                                                                                                                                                                   |                                                                                                                                           |                                                              |                                                                                |                            |                     |                            |                                                                      |                                                                   |
| 57  | Pseudo-time over real time at the last point, test 1                                                                                                   | =E149/B149                                                                                                                                                                       | —                                                                                                                                                                                                                                                                                                                   |                                                                                                                                           |                                                              |                                                                                |                            |                     |                            |                                                                      |                                                                   |
| 58  | Buildup 2: Horner Line in m(p) Against Pseudo-Time                                                                                                     |                                                                                                                                                                                  |                                                                                                                                                                                                                                                                                                                     |                                                                                                                                           |                                                              |                                                                                |                            |                     |                            |                                                                      |                                                                   |
| 59  | m(pwf), test 2                                                                                                                                         | =LET(pwf_psia,GPB_PwfU2,PO.PVT.PseudoP(pwf_psia,GPB_TR,GPB_SG,GPB_Pbase,GPB_Steps))                                                                                              | psi²/cp                                                                                                                                                                                                                                                                                                             |                                                                                                                                           |                                                              |                                                                                |                            |                     |                            |                                                                      |                                                                   |
| 60  | μg·ct at pwf, test 2                                                                                                                                   | =PO.PVT.Ug.ByLGE(PO.PVT.Z.ByDAK(GPB_PwfU2/GPB_Ppc,GPB_Tpr),GPB_SG,GPB_PwfU2,GPB_TR)*((1-GPB_Swi)*PO.PVT.Cg.ByDefinition(GPB_PwfU2,GPB_TR,GPB_SG)+GPB_cf)                         | cp/psi                                                                                                                                                                                                                                                                                                              |                                                                                                                                           |                                                              |                                                                                |                            |                     |                            |                                                                      |                                                                   |
| 61  | Points in the IARF window, test 2                                                                                                                      | =SUM($K$154:$K$181)                                                                                                                                                              | —                                                                                                                                                                                                                                                                                                                   |                                                                                                                                           |                                                              |                                                                                |                            |                     |                            |                                                                      |                                                                   |
| 62  | Derivative spread over the window, test 2                                                                                                              | =(MAX(FILTER($J$154:$J$181,$K$154:$K$181=1))-MIN(FILTER($J$154:$J$181,$K$154:$K$181=1)))/(MAX(FILTER($J$154:$J$181,$K$154:$K$181=1))+MIN(FILTER($J$154:$J$181,$K$154:$K$181=1))) | %                                                                                                                                                                                                                                                                                                                   |                                                                                                                                           |                                                              |                                                                                |                            |                     |                            |                                                                      |                                                                   |
| 63  | Semilog slope in m(p), test 2                                                                                                                          | =-SLOPE(FILTER($F$154:$F$181,$K$154:$K$181=1),LOG10(FILTER($H$154:$H$181,$K$154:$K$181=1)))                                                                                      | psi²/cp/cycle                                                                                                                                                                                                                                                                                                       |                                                                                                                                           |                                                              |                                                                                |                            |                     |                            |                                                                      |                                                                   |
| 64  | Line's m(p) at Δta = 1 hr, test 2                                                                                                                      | =INTERCEPT(FILTER($F$154:$F$181,$K$154:$K$181=1),LOG10(FILTER($H$154:$H$181,$K$154:$K$181=1)))-GPB_M2*LOG10(GPB_tp+1)                                                            | psi²/cp                                                                                                                                                                                                                                                                                                             |                                                                                                                                           |                                                              |                                                                                |                            |                     |                            |                                                                      |                                                                   |
| 65  | Permeability, k = 1637·q·T/(m·h), test 2                                                                                                               | =GPB_K1637*GPB_q2*GPB_TR/(GPB_M2*GPB_h)                                                                                                                                          | mD                                                                                                                                                                                                                                                                                                                  |                                                                                                                                           |                                                              |                                                                                |                            |                     |                            |                                                                      |                                                                   |
| 66  | Apparent skin, S′ = S + D·q2                                                                                                                           | =PO.PTA.Horner.S(GPB_m1hr2,GPB_mPwf2,GPB_M2,GPB_k2,GPB_phi,GPB_Mui,GPB_Cti,GPB_rw)                                                                                               | —                                                                                                                                                                                                                                                                                                                   |                                                                                                                                           |                                                              |                                                                                |                            |                     |                            |                                                                      |                                                                   |
| 67  | Pseudo-time over real time at the last point, test 2                                                                                                   | =E181/B181                                                                                                                                                                       | —                                                                                                                                                                                                                                                                                                                   |                                                                                                                                           |                                                              |                                                                                |                            |                     |                            |                                                                      |                                                                   |
| 68  | Rate-Dependent Skin from the Two Buildups                                                                                                              |                                                                                                                                                                                  |                                                                                                                                                                                                                                                                                                                     |                                                                                                                                           |                                                              |                                                                                |                            |                     |                            |                                                                      |                                                                   |
| 69  | Permeability, k (mean of the two)                                                                                                                      | =(GPB_k1+GPB_k2)/2                                                                                                                                                               | mD                                                                                                                                                                                                                                                                                                                  |                                                                                                                                           |                                                              |                                                                                |                            |                     |                            |                                                                      |                                                                   |
| 70  | Permeability-thickness, kh                                                                                                                             | =GPB_k*GPB_h                                                                                                                                                                     | mD·ft                                                                                                                                                                                                                                                                                                               |                                                                                                                                           |                                                              |                                                                                |                            |                     |                            |                                                                      |                                                                   |
| 71  | Rate-dependent skin coefficient, D = ΔS′/Δq                                                                                                            | =(GPB_Sa2-GPB_Sa1)/(GPB_q2-GPB_q1)                                                                                                                                               | d/Mscf                                                                                                                                                                                                                                                                                                              |                                                                                                                                           |                                                              |                                                                                |                            |                     |                            |                                                                      |                                                                   |
| 72  | Mechanical skin, S = S′1 − D·q1                                                                                                                        | =GPB_Sa1-GPB_D*GPB_q1                                                                                                                                                            | —                                                                                                                                                                                                                                                                                                                   |                                                                                                                                           |                                                              |                                                                                |                            |                     |                            |                                                                      |                                                                   |
| 73  | Turbulence's share of S′ at q2                                                                                                                         | =GPB_D*GPB_q2/GPB_Sa2                                                                                                                                                            | %                                                                                                                                                                                                                                                                                                                   |                                                                                                                                           |                                                              |                                                                                |                            |                     |                            |                                                                      |                                                                   |
| 74  | k against the model                                                                                                                                    | =GPB_k/GPB_ModelK-1                                                                                                                                                              | %                                                                                                                                                                                                                                                                                                                   |                                                                                                                                           |                                                              |                                                                                |                            |                     |                            |                                                                      |                                                                   |
| 75  | S against the model                                                                                                                                    | =GPB_S-GPB_ModelS                                                                                                                                                                | —                                                                                                                                                                                                                                                                                                                   |                                                                                                                                           |                                                              |                                                                                |                            |                     |                            |                                                                      |                                                                   |
| 76  | D against the model                                                                                                                                    | =GPB_D/GPB_ModelD-1                                                                                                                                                              | %                                                                                                                                                                                                                                                                                                                   |                                                                                                                                           |                                                              |                                                                                |                            |                     |                            |                                                                      |                                                                   |
| 77  | Rate check                                                                                                                                             | =IF(OR(MIN(GPB_q1,GPB_q2)<=0,GPB_q1=GPB_q2),"FAIL","PASS")                                                                                                                       | =IF(OR(MIN(GPB_q1,GPB_q2)<=0,GPB_q1=GPB_q2),"D needs two buildups after two different rates above 0","the rates differ by a factor of "&FIXED(MAX(GPB_q1,GPB_q2)/MIN(GPB_q1,GPB_q2),1)&", so S′ splits into S and D·q")                                                                                             |                                                                                                                                           |                                                              |                                                                                |                            |                     |                            |                                                                      |                                                                   |
| 78  | IARF window check                                                                                                                                      | =IF(MAX(GPB_Flat1,GPB_Flat2)<=GPB_Flat,"PASS","WARN")                                                                                                                            | =IF(MAX(GPB_Flat1,GPB_Flat2)<=GPB_Flat,"over Δta "&FIXED(GPB_From,2)&" to "&FIXED(GPB_To,1)&" hr both derivatives are flat within ±"&FIXED(MAX(GPB_Flat1,GPB_Flat2)*100,1)&"%","a derivative spans ±"&FIXED(MAX(GPB_Flat1,GPB_Flat2)*100,1)&"% over the window: move it onto the flat stretch of the log-log plot") |                                                                                                                                           |                                                              |                                                                                |                            |                     |                            |                                                                      |                                                                   |
| 79  | Turbulence check                                                                                                                                       | =IF(GPB_D>0,"PASS","WARN")                                                                                                                                                       | =IF(GPB_D>0,"S′ rises with rate, D = "&FIXED(GPB_D*1000*1000,0)&"E-6 d/Mscf, "&FIXED(GPB_TurbShare*100,0)&"% of S′ at q2","S′ does not rise with rate: D is not above 0, so the buildups don't resolve turbulence")                                                                                                 |                                                                                                                                           |                                                              |                                                                                |                            |                     |                            |                                                                      |                                                                   |
| 80  | Round trip on the synthetic data                                                                                                                       | =IF(AND(ABS(GPB_kErr)<=GPB_Tol,ABS(GPB_DErr)<=GPB_Tol),"PASS","WARN")                                                                                                            | =IF(AND(ABS(GPB_kErr)<=GPB_Tol,ABS(GPB_DErr)<=GPB_Tol),"k "&FIXED(GPB_kErr*100,1)&"%, D "&FIXED(GPB_DErr*100,1)&"% and S "&FIXED(GPB_SErr,2)&" from the model (ignore for real data)","k is "&FIXED(GPB_kErr*100,1)&"% and D "&FIXED(GPB_DErr*100,1)&"% from the model: check the window (ignore for real data)")   |                                                                                                                                           |                                                              |                                                                                |                            |                     |                            |                                                                      |                                                                   |
| 84  | Calculation Constants                                                                                                                                  |                                                                                                                                                                                  |                                                                                                                                                                                                                                                                                                                     |                                                                                                                                           |                                                              |                                                                                |                            |                     |                            |                                                                      |                                                                   |
| 85  | Rankine at 0 °F                                                                                                                                        | 459.67                                                                                                                                                                           | °R                                                                                                                                                                                                                                                                                                                  |                                                                                                                                           |                                                              |                                                                                |                            |                     |                            |                                                                      |                                                                   |
| 86  | Trapezoid steps of each m(p) integral                                                                                                                  | 50                                                                                                                                                                               | —                                                                                                                                                                                                                                                                                                                   |                                                                                                                                           |                                                              |                                                                                |                            |                     |                            |                                                                      |                                                                   |
| 87  | Gas pressure group, m(p) form                                                                                                                          | 1422                                                                                                                                                                             | —                                                                                                                                                                                                                                                                                                                   |                                                                                                                                           |                                                              |                                                                                |                            |                     |                            |                                                                      |                                                                   |
| 88  | Liquid pressure group                                                                                                                                  | 141.2                                                                                                                                                                            | —                                                                                                                                                                                                                                                                                                                   |                                                                                                                                           |                                                              |                                                                                |                            |                     |                            |                                                                      |                                                                   |
| 89  | Gas semilog permeability constant                                                                                                                      | 1637                                                                                                                                                                             | —                                                                                                                                                                                                                                                                                                                   |                                                                                                                                           |                                                              |                                                                                |                            |                     |                            |                                                                      |                                                                   |
| 90  | Slack on the window's ends, for rounding                                                                                                               | 0.001                                                                                                                                                                            | —                                                                                                                                                                                                                                                                                                                   |                                                                                                                                           |                                                              |                                                                                |                            |                     |                            |                                                                      |                                                                   |
| 91  | Pseudo-pressure in one 10⁶ psi²/cp                                                                                                                     | 1000000                                                                                                                                                                          | psi²/cp                                                                                                                                                                                                                                                                                                             |                                                                                                                                           |                                                              |                                                                                |                            |                     |                            |                                                                      |                                                                   |
| 94  | Rate Histories for the Model                                                                                                                           |                                                                                                                                                                                  |                                                                                                                                                                                                                                                                                                                     |                                                                                                                                           |                                                              |                                                                                |                            |                     |                            |                                                                      |                                                                   |
| 95  | Start (hr)                                                                                                                                             | Rate 1 (Mscf/d)                                                                                                                                                                  |                                                                                                                                                                                                                                                                                                                     | Start (hr)                                                                                                                                | Rate 2 (Mscf/d)                                              |                                                                                |                            |                     |                            |                                                                      |                                                                   |
| 96  | =0                                                                                                                                                     | =GPB_q1                                                                                                                                                                          |                                                                                                                                                                                                                                                                                                                     | =0                                                                                                                                        | =GPB_q2                                                      |                                                                                |                            |                     |                            |                                                                      |                                                                   |
| 97  | =GPB_tp                                                                                                                                                | =0                                                                                                                                                                               |                                                                                                                                                                                                                                                                                                                     | =GPB_tp                                                                                                                                   | =0                                                           |                                                                                |                            |                     |                            |                                                                      |                                                                   |
| 100 | The Two Horner Lines                                                                                                                                   |                                                                                                                                                                                  |                                                                                                                                                                                                                                                                                                                     |                                                                                                                                           |                                                              |                                                                                |                            |                     |                            |                                                                      |                                                                   |
| 101 | Horner ratio (—)                                                                                                                                       | Δm line 1 (10⁶ psi²/cp)                                                                                                                                                          | Δm line 2 (10⁶ psi²/cp)                                                                                                                                                                                                                                                                                             |                                                                                                                                           |                                                              |                                                                                |                            |                     |                            |                                                                      |                                                                   |
| 102 | =MAX($H$122:$H$149)^(0/8)                                                                                                                              | =(GPB_m1hr1-GPB_M1*(LOG10(A102)-LOG10(GPB_tp+1))-GPB_mPwf1)/GPB_Mega                                                                                                             | =(GPB_m1hr2-GPB_M2*(LOG10(A102)-LOG10(GPB_tp+1))-GPB_mPwf2)/GPB_Mega                                                                                                                                                                                                                                                |                                                                                                                                           |                                                              |                                                                                |                            |                     |                            |                                                                      |                                                                   |
| 103 | =MAX($H$122:$H$149)^(1/8)                                                                                                                              | =(GPB_m1hr1-GPB_M1*(LOG10(A103)-LOG10(GPB_tp+1))-GPB_mPwf1)/GPB_Mega                                                                                                             | =(GPB_m1hr2-GPB_M2*(LOG10(A103)-LOG10(GPB_tp+1))-GPB_mPwf2)/GPB_Mega                                                                                                                                                                                                                                                |                                                                                                                                           |                                                              |                                                                                |                            |                     |                            |                                                                      |                                                                   |
| 104 | =MAX($H$122:$H$149)^(2/8)                                                                                                                              | =(GPB_m1hr1-GPB_M1*(LOG10(A104)-LOG10(GPB_tp+1))-GPB_mPwf1)/GPB_Mega                                                                                                             | =(GPB_m1hr2-GPB_M2*(LOG10(A104)-LOG10(GPB_tp+1))-GPB_mPwf2)/GPB_Mega                                                                                                                                                                                                                                                |                                                                                                                                           |                                                              |                                                                                |                            |                     |                            |                                                                      |                                                                   |
| 105 | =MAX($H$122:$H$149)^(3/8)                                                                                                                              | =(GPB_m1hr1-GPB_M1*(LOG10(A105)-LOG10(GPB_tp+1))-GPB_mPwf1)/GPB_Mega                                                                                                             | =(GPB_m1hr2-GPB_M2*(LOG10(A105)-LOG10(GPB_tp+1))-GPB_mPwf2)/GPB_Mega                                                                                                                                                                                                                                                |                                                                                                                                           |                                                              |                                                                                |                            |                     |                            |                                                                      |                                                                   |
| 106 | =MAX($H$122:$H$149)^(4/8)                                                                                                                              | =(GPB_m1hr1-GPB_M1*(LOG10(A106)-LOG10(GPB_tp+1))-GPB_mPwf1)/GPB_Mega                                                                                                             | =(GPB_m1hr2-GPB_M2*(LOG10(A106)-LOG10(GPB_tp+1))-GPB_mPwf2)/GPB_Mega                                                                                                                                                                                                                                                |                                                                                                                                           |                                                              |                                                                                |                            |                     |                            |                                                                      |                                                                   |
| 107 | =MAX($H$122:$H$149)^(5/8)                                                                                                                              | =(GPB_m1hr1-GPB_M1*(LOG10(A107)-LOG10(GPB_tp+1))-GPB_mPwf1)/GPB_Mega                                                                                                             | =(GPB_m1hr2-GPB_M2*(LOG10(A107)-LOG10(GPB_tp+1))-GPB_mPwf2)/GPB_Mega                                                                                                                                                                                                                                                |                                                                                                                                           |                                                              |                                                                                |                            |                     |                            |                                                                      |                                                                   |
| 108 | =MAX($H$122:$H$149)^(6/8)                                                                                                                              | =(GPB_m1hr1-GPB_M1*(LOG10(A108)-LOG10(GPB_tp+1))-GPB_mPwf1)/GPB_Mega                                                                                                             | =(GPB_m1hr2-GPB_M2*(LOG10(A108)-LOG10(GPB_tp+1))-GPB_mPwf2)/GPB_Mega                                                                                                                                                                                                                                                |                                                                                                                                           |                                                              |                                                                                |                            |                     |                            |                                                                      |                                                                   |
| 109 | =MAX($H$122:$H$149)^(7/8)                                                                                                                              | =(GPB_m1hr1-GPB_M1*(LOG10(A109)-LOG10(GPB_tp+1))-GPB_mPwf1)/GPB_Mega                                                                                                             | =(GPB_m1hr2-GPB_M2*(LOG10(A109)-LOG10(GPB_tp+1))-GPB_mPwf2)/GPB_Mega                                                                                                                                                                                                                                                |                                                                                                                                           |                                                              |                                                                                |                            |                     |                            |                                                                      |                                                                   |
| 110 | =MAX($H$122:$H$149)^(8/8)                                                                                                                              | =(GPB_m1hr1-GPB_M1*(LOG10(A110)-LOG10(GPB_tp+1))-GPB_mPwf1)/GPB_Mega                                                                                                             | =(GPB_m1hr2-GPB_M2*(LOG10(A110)-LOG10(GPB_tp+1))-GPB_mPwf2)/GPB_Mega                                                                                                                                                                                                                                                |                                                                                                                                           |                                                              |                                                                                |                            |                     |                            |                                                                      |                                                                   |
| 112 | Apparent Skin Against Rate                                                                                                                             |                                                                                                                                                                                  |                                                                                                                                                                                                                                                                                                                     |                                                                                                                                           |                                                              |                                                                                |                            |                     |                            |                                                                      |                                                                   |
| 113 | Rate (Mscf/d)                                                                                                                                          | S + D·q (—)                                                                                                                                                                      | Buildup S′ (—)                                                                                                                                                                                                                                                                                                      |                                                                                                                                           |                                                              |                                                                                |                            |                     |                            |                                                                      |                                                                   |
| 114 | =0                                                                                                                                                     | =GPB_S                                                                                                                                                                           |                                                                                                                                                                                                                                                                                                                     |                                                                                                                                           |                                                              |                                                                                |                            |                     |                            |                                                                      |                                                                   |
| 115 | =GPB_q1                                                                                                                                                | =GPB_S+GPB_D*GPB_q1                                                                                                                                                              | =GPB_Sa1                                                                                                                                                                                                                                                                                                            |                                                                                                                                           |                                                              |                                                                                |                            |                     |                            |                                                                      |                                                                   |
| 116 | =GPB_q2                                                                                                                                                | =GPB_S+GPB_D*GPB_q2                                                                                                                                                              | =GPB_Sa2                                                                                                                                                                                                                                                                                                            |                                                                                                                                           |                                                              |                                                                                |                            |                     |                            |                                                                      |                                                                   |
| 119 | Buildup 1: Shut-In Data, Pseudo-Time and m(p)                                                                                                          |                                                                                                                                                                                  |                                                                                                                                                                                                                                                                                                                     |                                                                                                                                           |                                                              |                                                                                |                            |                     |                            |                                                                      |                                                                   |
| 120 | How to use it: paste each buildup's Δt and pws over columns B and C, type pwf at shut-in, and set the rates; column A is the model's pseudo-time grid. |                                                                                                                                                                                  |                                                                                                                                                                                                                                                                                                                     |                                                                                                                                           |                                                              |                                                                                |                            |                     |                            |                                                                      |                                                                   |
| 121 | Model Δta (hr)                                                                                                                                         | Δt (hr)                                                                                                                                                                          | pws (psia)                                                                                                                                                                                                                                                                                                          | μg·ct (cp/psi)                                                                                                                            | Δta (hr)                                                     | m(pws) (psi²/cp)                                                               | Δm (10⁶ psi²/cp)           | Horner ratio (—)    | te (hr)                    | Derivative (10⁶ psi²/cp)                                             | IARF (—)                                                          |
| 122 | =0.01                                                                                                                                                  | =A122/(GPB_McI*(1/D122+1/GPB_McPwf1)/2)                                                                                                                                          | =PO.Spline.Cubic.Interp(GPB_MTab,GPB_PTab,GPB_mPi-GPB_Scale*PO.PTA.Pw.VW(GPB_tp+A122,$A$96:$B$97,1,GPB_Mui,GPB_C,GPB_rw,GPB_S1,GPB_Cti,GPB_phi,GPB_h,GPB_ModelK))                                                                                                                                                   | =PO.PVT.Ug.ByLGE(PO.PVT.Z.ByDAK(C122/GPB_Ppc,GPB_Tpr),GPB_SG,C122,GPB_TR)*((1-GPB_Swi)*PO.PVT.Cg.ByDefinition(C122,GPB_TR,GPB_SG)+GPB_cf) | =B122*GPB_McI*(1/D122+1/GPB_McPwf1)/2                        | =LET(pws_psia,C122,PO.PVT.PseudoP(pws_psia,GPB_TR,GPB_SG,GPB_Pbase,GPB_Steps)) | =(F122-GPB_mPwf1)/GPB_Mega | =(GPB_tp+E122)/E122 | =GPB_tp*E122/(GPB_tp+E122) | =PO.DCA.Diag.Bourdet.SemiLog($I$122:$I$149,$G$122:$G$149,I122,GPB_L) | =IF(AND(E122>=GPB_From*(1-GPB_Eps),E122<=GPB_To*(1+GPB_Eps)),1,0) |
| 123 | =0.0133                                                                                                                                                | =B122+(A123-A122)/(GPB_McI*(1/D123+1/D122)/2)                                                                                                                                    | =PO.Spline.Cubic.Interp(GPB_MTab,GPB_PTab,GPB_mPi-GPB_Scale*PO.PTA.Pw.VW(GPB_tp+A123,$A$96:$B$97,1,GPB_Mui,GPB_C,GPB_rw,GPB_S1,GPB_Cti,GPB_phi,GPB_h,GPB_ModelK))                                                                                                                                                   | =PO.PVT.Ug.ByLGE(PO.PVT.Z.ByDAK(C123/GPB_Ppc,GPB_Tpr),GPB_SG,C123,GPB_TR)*((1-GPB_Swi)*PO.PVT.Cg.ByDefinition(C123,GPB_TR,GPB_SG)+GPB_cf) | =E122+(B123-B122)*GPB_McI*(1/D123+1/D122)/2                  | =LET(pws_psia,C123,PO.PVT.PseudoP(pws_psia,GPB_TR,GPB_SG,GPB_Pbase,GPB_Steps)) | =(F123-GPB_mPwf1)/GPB_Mega | =(GPB_tp+E123)/E123 | =GPB_tp*E123/(GPB_tp+E123) | =PO.DCA.Diag.Bourdet.SemiLog($I$122:$I$149,$G$122:$G$149,I123,GPB_L) | =IF(AND(E123>=GPB_From*(1-GPB_Eps),E123<=GPB_To*(1+GPB_Eps)),1,0) |
| 124 | =0.0178                                                                                                                                                | =B123+(A124-A123)/(GPB_McI*(1/D124+1/D123)/2)                                                                                                                                    | =PO.Spline.Cubic.Interp(GPB_MTab,GPB_PTab,GPB_mPi-GPB_Scale*PO.PTA.Pw.VW(GPB_tp+A124,$A$96:$B$97,1,GPB_Mui,GPB_C,GPB_rw,GPB_S1,GPB_Cti,GPB_phi,GPB_h,GPB_ModelK))                                                                                                                                                   | =PO.PVT.Ug.ByLGE(PO.PVT.Z.ByDAK(C124/GPB_Ppc,GPB_Tpr),GPB_SG,C124,GPB_TR)*((1-GPB_Swi)*PO.PVT.Cg.ByDefinition(C124,GPB_TR,GPB_SG)+GPB_cf) | =E123+(B124-B123)*GPB_McI*(1/D124+1/D123)/2                  | =LET(pws_psia,C124,PO.PVT.PseudoP(pws_psia,GPB_TR,GPB_SG,GPB_Pbase,GPB_Steps)) | =(F124-GPB_mPwf1)/GPB_Mega | =(GPB_tp+E124)/E124 | =GPB_tp*E124/(GPB_tp+E124) | =PO.DCA.Diag.Bourdet.SemiLog($I$122:$I$149,$G$122:$G$149,I124,GPB_L) | =IF(AND(E124>=GPB_From*(1-GPB_Eps),E124<=GPB_To*(1+GPB_Eps)),1,0) |
| 125 | =0.0237                                                                                                                                                | =B124+(A125-A124)/(GPB_McI*(1/D125+1/D124)/2)                                                                                                                                    | =PO.Spline.Cubic.Interp(GPB_MTab,GPB_PTab,GPB_mPi-GPB_Scale*PO.PTA.Pw.VW(GPB_tp+A125,$A$96:$B$97,1,GPB_Mui,GPB_C,GPB_rw,GPB_S1,GPB_Cti,GPB_phi,GPB_h,GPB_ModelK))                                                                                                                                                   | =PO.PVT.Ug.ByLGE(PO.PVT.Z.ByDAK(C125/GPB_Ppc,GPB_Tpr),GPB_SG,C125,GPB_TR)*((1-GPB_Swi)*PO.PVT.Cg.ByDefinition(C125,GPB_TR,GPB_SG)+GPB_cf) | =E124+(B125-B124)*GPB_McI*(1/D125+1/D124)/2                  | =LET(pws_psia,C125,PO.PVT.PseudoP(pws_psia,GPB_TR,GPB_SG,GPB_Pbase,GPB_Steps)) | =(F125-GPB_mPwf1)/GPB_Mega | =(GPB_tp+E125)/E125 | =GPB_tp*E125/(GPB_tp+E125) | =PO.DCA.Diag.Bourdet.SemiLog($I$122:$I$149,$G$122:$G$149,I125,GPB_L) | =IF(AND(E125>=GPB_From*(1-GPB_Eps),E125<=GPB_To*(1+GPB_Eps)),1,0) |
| 126 | =0.0316                                                                                                                                                | =B125+(A126-A125)/(GPB_McI*(1/D126+1/D125)/2)                                                                                                                                    | =PO.Spline.Cubic.Interp(GPB_MTab,GPB_PTab,GPB_mPi-GPB_Scale*PO.PTA.Pw.VW(GPB_tp+A126,$A$96:$B$97,1,GPB_Mui,GPB_C,GPB_rw,GPB_S1,GPB_Cti,GPB_phi,GPB_h,GPB_ModelK))                                                                                                                                                   | =PO.PVT.Ug.ByLGE(PO.PVT.Z.ByDAK(C126/GPB_Ppc,GPB_Tpr),GPB_SG,C126,GPB_TR)*((1-GPB_Swi)*PO.PVT.Cg.ByDefinition(C126,GPB_TR,GPB_SG)+GPB_cf) | =E125+(B126-B125)*GPB_McI*(1/D126+1/D125)/2                  | =LET(pws_psia,C126,PO.PVT.PseudoP(pws_psia,GPB_TR,GPB_SG,GPB_Pbase,GPB_Steps)) | =(F126-GPB_mPwf1)/GPB_Mega | =(GPB_tp+E126)/E126 | =GPB_tp*E126/(GPB_tp+E126) | =PO.DCA.Diag.Bourdet.SemiLog($I$122:$I$149,$G$122:$G$149,I126,GPB_L) | =IF(AND(E126>=GPB_From*(1-GPB_Eps),E126<=GPB_To*(1+GPB_Eps)),1,0) |
| 127 | =0.0422                                                                                                                                                | =B126+(A127-A126)/(GPB_McI*(1/D127+1/D126)/2)                                                                                                                                    | =PO.Spline.Cubic.Interp(GPB_MTab,GPB_PTab,GPB_mPi-GPB_Scale*PO.PTA.Pw.VW(GPB_tp+A127,$A$96:$B$97,1,GPB_Mui,GPB_C,GPB_rw,GPB_S1,GPB_Cti,GPB_phi,GPB_h,GPB_ModelK))                                                                                                                                                   | =PO.PVT.Ug.ByLGE(PO.PVT.Z.ByDAK(C127/GPB_Ppc,GPB_Tpr),GPB_SG,C127,GPB_TR)*((1-GPB_Swi)*PO.PVT.Cg.ByDefinition(C127,GPB_TR,GPB_SG)+GPB_cf) | =E126+(B127-B126)*GPB_McI*(1/D127+1/D126)/2                  | =LET(pws_psia,C127,PO.PVT.PseudoP(pws_psia,GPB_TR,GPB_SG,GPB_Pbase,GPB_Steps)) | =(F127-GPB_mPwf1)/GPB_Mega | =(GPB_tp+E127)/E127 | =GPB_tp*E127/(GPB_tp+E127) | =PO.DCA.Diag.Bourdet.SemiLog($I$122:$I$149,$G$122:$G$149,I127,GPB_L) | =IF(AND(E127>=GPB_From*(1-GPB_Eps),E127<=GPB_To*(1+GPB_Eps)),1,0) |
| 128 | =0.0562                                                                                                                                                | =B127+(A128-A127)/(GPB_McI*(1/D128+1/D127)/2)                                                                                                                                    | =PO.Spline.Cubic.Interp(GPB_MTab,GPB_PTab,GPB_mPi-GPB_Scale*PO.PTA.Pw.VW(GPB_tp+A128,$A$96:$B$97,1,GPB_Mui,GPB_C,GPB_rw,GPB_S1,GPB_Cti,GPB_phi,GPB_h,GPB_ModelK))                                                                                                                                                   | =PO.PVT.Ug.ByLGE(PO.PVT.Z.ByDAK(C128/GPB_Ppc,GPB_Tpr),GPB_SG,C128,GPB_TR)*((1-GPB_Swi)*PO.PVT.Cg.ByDefinition(C128,GPB_TR,GPB_SG)+GPB_cf) | =E127+(B128-B127)*GPB_McI*(1/D128+1/D127)/2                  | =LET(pws_psia,C128,PO.PVT.PseudoP(pws_psia,GPB_TR,GPB_SG,GPB_Pbase,GPB_Steps)) | =(F128-GPB_mPwf1)/GPB_Mega | =(GPB_tp+E128)/E128 | =GPB_tp*E128/(GPB_tp+E128) | =PO.DCA.Diag.Bourdet.SemiLog($I$122:$I$149,$G$122:$G$149,I128,GPB_L) | =IF(AND(E128>=GPB_From*(1-GPB_Eps),E128<=GPB_To*(1+GPB_Eps)),1,0) |
| 129 | =0.075                                                                                                                                                 | =B128+(A129-A128)/(GPB_McI*(1/D129+1/D128)/2)                                                                                                                                    | =PO.Spline.Cubic.Interp(GPB_MTab,GPB_PTab,GPB_mPi-GPB_Scale*PO.PTA.Pw.VW(GPB_tp+A129,$A$96:$B$97,1,GPB_Mui,GPB_C,GPB_rw,GPB_S1,GPB_Cti,GPB_phi,GPB_h,GPB_ModelK))                                                                                                                                                   | =PO.PVT.Ug.ByLGE(PO.PVT.Z.ByDAK(C129/GPB_Ppc,GPB_Tpr),GPB_SG,C129,GPB_TR)*((1-GPB_Swi)*PO.PVT.Cg.ByDefinition(C129,GPB_TR,GPB_SG)+GPB_cf) | =E128+(B129-B128)*GPB_McI*(1/D129+1/D128)/2                  | =LET(pws_psia,C129,PO.PVT.PseudoP(pws_psia,GPB_TR,GPB_SG,GPB_Pbase,GPB_Steps)) | =(F129-GPB_mPwf1)/GPB_Mega | =(GPB_tp+E129)/E129 | =GPB_tp*E129/(GPB_tp+E129) | =PO.DCA.Diag.Bourdet.SemiLog($I$122:$I$149,$G$122:$G$149,I129,GPB_L) | =IF(AND(E129>=GPB_From*(1-GPB_Eps),E129<=GPB_To*(1+GPB_Eps)),1,0) |
| 130 | =0.1                                                                                                                                                   | =B129+(A130-A129)/(GPB_McI*(1/D130+1/D129)/2)                                                                                                                                    | =PO.Spline.Cubic.Interp(GPB_MTab,GPB_PTab,GPB_mPi-GPB_Scale*PO.PTA.Pw.VW(GPB_tp+A130,$A$96:$B$97,1,GPB_Mui,GPB_C,GPB_rw,GPB_S1,GPB_Cti,GPB_phi,GPB_h,GPB_ModelK))                                                                                                                                                   | =PO.PVT.Ug.ByLGE(PO.PVT.Z.ByDAK(C130/GPB_Ppc,GPB_Tpr),GPB_SG,C130,GPB_TR)*((1-GPB_Swi)*PO.PVT.Cg.ByDefinition(C130,GPB_TR,GPB_SG)+GPB_cf) | =E129+(B130-B129)*GPB_McI*(1/D130+1/D129)/2                  | =LET(pws_psia,C130,PO.PVT.PseudoP(pws_psia,GPB_TR,GPB_SG,GPB_Pbase,GPB_Steps)) | =(F130-GPB_mPwf1)/GPB_Mega | =(GPB_tp+E130)/E130 | =GPB_tp*E130/(GPB_tp+E130) | =PO.DCA.Diag.Bourdet.SemiLog($I$122:$I$149,$G$122:$G$149,I130,GPB_L) | =IF(AND(E130>=GPB_From*(1-GPB_Eps),E130<=GPB_To*(1+GPB_Eps)),1,0) |
| 131 | =0.133                                                                                                                                                 | =B130+(A131-A130)/(GPB_McI*(1/D131+1/D130)/2)                                                                                                                                    | =PO.Spline.Cubic.Interp(GPB_MTab,GPB_PTab,GPB_mPi-GPB_Scale*PO.PTA.Pw.VW(GPB_tp+A131,$A$96:$B$97,1,GPB_Mui,GPB_C,GPB_rw,GPB_S1,GPB_Cti,GPB_phi,GPB_h,GPB_ModelK))                                                                                                                                                   | =PO.PVT.Ug.ByLGE(PO.PVT.Z.ByDAK(C131/GPB_Ppc,GPB_Tpr),GPB_SG,C131,GPB_TR)*((1-GPB_Swi)*PO.PVT.Cg.ByDefinition(C131,GPB_TR,GPB_SG)+GPB_cf) | =E130+(B131-B130)*GPB_McI*(1/D131+1/D130)/2                  | =LET(pws_psia,C131,PO.PVT.PseudoP(pws_psia,GPB_TR,GPB_SG,GPB_Pbase,GPB_Steps)) | =(F131-GPB_mPwf1)/GPB_Mega | =(GPB_tp+E131)/E131 | =GPB_tp*E131/(GPB_tp+E131) | =PO.DCA.Diag.Bourdet.SemiLog($I$122:$I$149,$G$122:$G$149,I131,GPB_L) | =IF(AND(E131>=GPB_From*(1-GPB_Eps),E131<=GPB_To*(1+GPB_Eps)),1,0) |
| 132 | =0.178                                                                                                                                                 | =B131+(A132-A131)/(GPB_McI*(1/D132+1/D131)/2)                                                                                                                                    | =PO.Spline.Cubic.Interp(GPB_MTab,GPB_PTab,GPB_mPi-GPB_Scale*PO.PTA.Pw.VW(GPB_tp+A132,$A$96:$B$97,1,GPB_Mui,GPB_C,GPB_rw,GPB_S1,GPB_Cti,GPB_phi,GPB_h,GPB_ModelK))                                                                                                                                                   | =PO.PVT.Ug.ByLGE(PO.PVT.Z.ByDAK(C132/GPB_Ppc,GPB_Tpr),GPB_SG,C132,GPB_TR)*((1-GPB_Swi)*PO.PVT.Cg.ByDefinition(C132,GPB_TR,GPB_SG)+GPB_cf) | =E131+(B132-B131)*GPB_McI*(1/D132+1/D131)/2                  | =LET(pws_psia,C132,PO.PVT.PseudoP(pws_psia,GPB_TR,GPB_SG,GPB_Pbase,GPB_Steps)) | =(F132-GPB_mPwf1)/GPB_Mega | =(GPB_tp+E132)/E132 | =GPB_tp*E132/(GPB_tp+E132) | =PO.DCA.Diag.Bourdet.SemiLog($I$122:$I$149,$G$122:$G$149,I132,GPB_L) | =IF(AND(E132>=GPB_From*(1-GPB_Eps),E132<=GPB_To*(1+GPB_Eps)),1,0) |
| 133 | =0.237                                                                                                                                                 | =B132+(A133-A132)/(GPB_McI*(1/D133+1/D132)/2)                                                                                                                                    | =PO.Spline.Cubic.Interp(GPB_MTab,GPB_PTab,GPB_mPi-GPB_Scale*PO.PTA.Pw.VW(GPB_tp+A133,$A$96:$B$97,1,GPB_Mui,GPB_C,GPB_rw,GPB_S1,GPB_Cti,GPB_phi,GPB_h,GPB_ModelK))                                                                                                                                                   | =PO.PVT.Ug.ByLGE(PO.PVT.Z.ByDAK(C133/GPB_Ppc,GPB_Tpr),GPB_SG,C133,GPB_TR)*((1-GPB_Swi)*PO.PVT.Cg.ByDefinition(C133,GPB_TR,GPB_SG)+GPB_cf) | =E132+(B133-B132)*GPB_McI*(1/D133+1/D132)/2                  | =LET(pws_psia,C133,PO.PVT.PseudoP(pws_psia,GPB_TR,GPB_SG,GPB_Pbase,GPB_Steps)) | =(F133-GPB_mPwf1)/GPB_Mega | =(GPB_tp+E133)/E133 | =GPB_tp*E133/(GPB_tp+E133) | =PO.DCA.Diag.Bourdet.SemiLog($I$122:$I$149,$G$122:$G$149,I133,GPB_L) | =IF(AND(E133>=GPB_From*(1-GPB_Eps),E133<=GPB_To*(1+GPB_Eps)),1,0) |
| 134 | =0.316                                                                                                                                                 | =B133+(A134-A133)/(GPB_McI*(1/D134+1/D133)/2)                                                                                                                                    | =PO.Spline.Cubic.Interp(GPB_MTab,GPB_PTab,GPB_mPi-GPB_Scale*PO.PTA.Pw.VW(GPB_tp+A134,$A$96:$B$97,1,GPB_Mui,GPB_C,GPB_rw,GPB_S1,GPB_Cti,GPB_phi,GPB_h,GPB_ModelK))                                                                                                                                                   | =PO.PVT.Ug.ByLGE(PO.PVT.Z.ByDAK(C134/GPB_Ppc,GPB_Tpr),GPB_SG,C134,GPB_TR)*((1-GPB_Swi)*PO.PVT.Cg.ByDefinition(C134,GPB_TR,GPB_SG)+GPB_cf) | =E133+(B134-B133)*GPB_McI*(1/D134+1/D133)/2                  | =LET(pws_psia,C134,PO.PVT.PseudoP(pws_psia,GPB_TR,GPB_SG,GPB_Pbase,GPB_Steps)) | =(F134-GPB_mPwf1)/GPB_Mega | =(GPB_tp+E134)/E134 | =GPB_tp*E134/(GPB_tp+E134) | =PO.DCA.Diag.Bourdet.SemiLog($I$122:$I$149,$G$122:$G$149,I134,GPB_L) | =IF(AND(E134>=GPB_From*(1-GPB_Eps),E134<=GPB_To*(1+GPB_Eps)),1,0) |
| 135 | =0.422                                                                                                                                                 | =B134+(A135-A134)/(GPB_McI*(1/D135+1/D134)/2)                                                                                                                                    | =PO.Spline.Cubic.Interp(GPB_MTab,GPB_PTab,GPB_mPi-GPB_Scale*PO.PTA.Pw.VW(GPB_tp+A135,$A$96:$B$97,1,GPB_Mui,GPB_C,GPB_rw,GPB_S1,GPB_Cti,GPB_phi,GPB_h,GPB_ModelK))                                                                                                                                                   | =PO.PVT.Ug.ByLGE(PO.PVT.Z.ByDAK(C135/GPB_Ppc,GPB_Tpr),GPB_SG,C135,GPB_TR)*((1-GPB_Swi)*PO.PVT.Cg.ByDefinition(C135,GPB_TR,GPB_SG)+GPB_cf) | =E134+(B135-B134)*GPB_McI*(1/D135+1/D134)/2                  | =LET(pws_psia,C135,PO.PVT.PseudoP(pws_psia,GPB_TR,GPB_SG,GPB_Pbase,GPB_Steps)) | =(F135-GPB_mPwf1)/GPB_Mega | =(GPB_tp+E135)/E135 | =GPB_tp*E135/(GPB_tp+E135) | =PO.DCA.Diag.Bourdet.SemiLog($I$122:$I$149,$G$122:$G$149,I135,GPB_L) | =IF(AND(E135>=GPB_From*(1-GPB_Eps),E135<=GPB_To*(1+GPB_Eps)),1,0) |
| 136 | =0.562                                                                                                                                                 | =B135+(A136-A135)/(GPB_McI*(1/D136+1/D135)/2)                                                                                                                                    | =PO.Spline.Cubic.Interp(GPB_MTab,GPB_PTab,GPB_mPi-GPB_Scale*PO.PTA.Pw.VW(GPB_tp+A136,$A$96:$B$97,1,GPB_Mui,GPB_C,GPB_rw,GPB_S1,GPB_Cti,GPB_phi,GPB_h,GPB_ModelK))                                                                                                                                                   | =PO.PVT.Ug.ByLGE(PO.PVT.Z.ByDAK(C136/GPB_Ppc,GPB_Tpr),GPB_SG,C136,GPB_TR)*((1-GPB_Swi)*PO.PVT.Cg.ByDefinition(C136,GPB_TR,GPB_SG)+GPB_cf) | =E135+(B136-B135)*GPB_McI*(1/D136+1/D135)/2                  | =LET(pws_psia,C136,PO.PVT.PseudoP(pws_psia,GPB_TR,GPB_SG,GPB_Pbase,GPB_Steps)) | =(F136-GPB_mPwf1)/GPB_Mega | =(GPB_tp+E136)/E136 | =GPB_tp*E136/(GPB_tp+E136) | =PO.DCA.Diag.Bourdet.SemiLog($I$122:$I$149,$G$122:$G$149,I136,GPB_L) | =IF(AND(E136>=GPB_From*(1-GPB_Eps),E136<=GPB_To*(1+GPB_Eps)),1,0) |
| 137 | =0.75                                                                                                                                                  | =B136+(A137-A136)/(GPB_McI*(1/D137+1/D136)/2)                                                                                                                                    | =PO.Spline.Cubic.Interp(GPB_MTab,GPB_PTab,GPB_mPi-GPB_Scale*PO.PTA.Pw.VW(GPB_tp+A137,$A$96:$B$97,1,GPB_Mui,GPB_C,GPB_rw,GPB_S1,GPB_Cti,GPB_phi,GPB_h,GPB_ModelK))                                                                                                                                                   | =PO.PVT.Ug.ByLGE(PO.PVT.Z.ByDAK(C137/GPB_Ppc,GPB_Tpr),GPB_SG,C137,GPB_TR)*((1-GPB_Swi)*PO.PVT.Cg.ByDefinition(C137,GPB_TR,GPB_SG)+GPB_cf) | =E136+(B137-B136)*GPB_McI*(1/D137+1/D136)/2                  | =LET(pws_psia,C137,PO.PVT.PseudoP(pws_psia,GPB_TR,GPB_SG,GPB_Pbase,GPB_Steps)) | =(F137-GPB_mPwf1)/GPB_Mega | =(GPB_tp+E137)/E137 | =GPB_tp*E137/(GPB_tp+E137) | =PO.DCA.Diag.Bourdet.SemiLog($I$122:$I$149,$G$122:$G$149,I137,GPB_L) | =IF(AND(E137>=GPB_From*(1-GPB_Eps),E137<=GPB_To*(1+GPB_Eps)),1,0) |
| 138 | =1                                                                                                                                                     | =B137+(A138-A137)/(GPB_McI*(1/D138+1/D137)/2)                                                                                                                                    | =PO.Spline.Cubic.Interp(GPB_MTab,GPB_PTab,GPB_mPi-GPB_Scale*PO.PTA.Pw.VW(GPB_tp+A138,$A$96:$B$97,1,GPB_Mui,GPB_C,GPB_rw,GPB_S1,GPB_Cti,GPB_phi,GPB_h,GPB_ModelK))                                                                                                                                                   | =PO.PVT.Ug.ByLGE(PO.PVT.Z.ByDAK(C138/GPB_Ppc,GPB_Tpr),GPB_SG,C138,GPB_TR)*((1-GPB_Swi)*PO.PVT.Cg.ByDefinition(C138,GPB_TR,GPB_SG)+GPB_cf) | =E137+(B138-B137)*GPB_McI*(1/D138+1/D137)/2                  | =LET(pws_psia,C138,PO.PVT.PseudoP(pws_psia,GPB_TR,GPB_SG,GPB_Pbase,GPB_Steps)) | =(F138-GPB_mPwf1)/GPB_Mega | =(GPB_tp+E138)/E138 | =GPB_tp*E138/(GPB_tp+E138) | =PO.DCA.Diag.Bourdet.SemiLog($I$122:$I$149,$G$122:$G$149,I138,GPB_L) | =IF(AND(E138>=GPB_From*(1-GPB_Eps),E138<=GPB_To*(1+GPB_Eps)),1,0) |
| 139 | =1.33                                                                                                                                                  | =B138+(A139-A138)/(GPB_McI*(1/D139+1/D138)/2)                                                                                                                                    | =PO.Spline.Cubic.Interp(GPB_MTab,GPB_PTab,GPB_mPi-GPB_Scale*PO.PTA.Pw.VW(GPB_tp+A139,$A$96:$B$97,1,GPB_Mui,GPB_C,GPB_rw,GPB_S1,GPB_Cti,GPB_phi,GPB_h,GPB_ModelK))                                                                                                                                                   | =PO.PVT.Ug.ByLGE(PO.PVT.Z.ByDAK(C139/GPB_Ppc,GPB_Tpr),GPB_SG,C139,GPB_TR)*((1-GPB_Swi)*PO.PVT.Cg.ByDefinition(C139,GPB_TR,GPB_SG)+GPB_cf) | =E138+(B139-B138)*GPB_McI*(1/D139+1/D138)/2                  | =LET(pws_psia,C139,PO.PVT.PseudoP(pws_psia,GPB_TR,GPB_SG,GPB_Pbase,GPB_Steps)) | =(F139-GPB_mPwf1)/GPB_Mega | =(GPB_tp+E139)/E139 | =GPB_tp*E139/(GPB_tp+E139) | =PO.DCA.Diag.Bourdet.SemiLog($I$122:$I$149,$G$122:$G$149,I139,GPB_L) | =IF(AND(E139>=GPB_From*(1-GPB_Eps),E139<=GPB_To*(1+GPB_Eps)),1,0) |
| 140 | =1.78                                                                                                                                                  | =B139+(A140-A139)/(GPB_McI*(1/D140+1/D139)/2)                                                                                                                                    | =PO.Spline.Cubic.Interp(GPB_MTab,GPB_PTab,GPB_mPi-GPB_Scale*PO.PTA.Pw.VW(GPB_tp+A140,$A$96:$B$97,1,GPB_Mui,GPB_C,GPB_rw,GPB_S1,GPB_Cti,GPB_phi,GPB_h,GPB_ModelK))                                                                                                                                                   | =PO.PVT.Ug.ByLGE(PO.PVT.Z.ByDAK(C140/GPB_Ppc,GPB_Tpr),GPB_SG,C140,GPB_TR)*((1-GPB_Swi)*PO.PVT.Cg.ByDefinition(C140,GPB_TR,GPB_SG)+GPB_cf) | =E139+(B140-B139)*GPB_McI*(1/D140+1/D139)/2                  | =LET(pws_psia,C140,PO.PVT.PseudoP(pws_psia,GPB_TR,GPB_SG,GPB_Pbase,GPB_Steps)) | =(F140-GPB_mPwf1)/GPB_Mega | =(GPB_tp+E140)/E140 | =GPB_tp*E140/(GPB_tp+E140) | =PO.DCA.Diag.Bourdet.SemiLog($I$122:$I$149,$G$122:$G$149,I140,GPB_L) | =IF(AND(E140>=GPB_From*(1-GPB_Eps),E140<=GPB_To*(1+GPB_Eps)),1,0) |
| 141 | =2.37                                                                                                                                                  | =B140+(A141-A140)/(GPB_McI*(1/D141+1/D140)/2)                                                                                                                                    | =PO.Spline.Cubic.Interp(GPB_MTab,GPB_PTab,GPB_mPi-GPB_Scale*PO.PTA.Pw.VW(GPB_tp+A141,$A$96:$B$97,1,GPB_Mui,GPB_C,GPB_rw,GPB_S1,GPB_Cti,GPB_phi,GPB_h,GPB_ModelK))                                                                                                                                                   | =PO.PVT.Ug.ByLGE(PO.PVT.Z.ByDAK(C141/GPB_Ppc,GPB_Tpr),GPB_SG,C141,GPB_TR)*((1-GPB_Swi)*PO.PVT.Cg.ByDefinition(C141,GPB_TR,GPB_SG)+GPB_cf) | =E140+(B141-B140)*GPB_McI*(1/D141+1/D140)/2                  | =LET(pws_psia,C141,PO.PVT.PseudoP(pws_psia,GPB_TR,GPB_SG,GPB_Pbase,GPB_Steps)) | =(F141-GPB_mPwf1)/GPB_Mega | =(GPB_tp+E141)/E141 | =GPB_tp*E141/(GPB_tp+E141) | =PO.DCA.Diag.Bourdet.SemiLog($I$122:$I$149,$G$122:$G$149,I141,GPB_L) | =IF(AND(E141>=GPB_From*(1-GPB_Eps),E141<=GPB_To*(1+GPB_Eps)),1,0) |
| 142 | =3.16                                                                                                                                                  | =B141+(A142-A141)/(GPB_McI*(1/D142+1/D141)/2)                                                                                                                                    | =PO.Spline.Cubic.Interp(GPB_MTab,GPB_PTab,GPB_mPi-GPB_Scale*PO.PTA.Pw.VW(GPB_tp+A142,$A$96:$B$97,1,GPB_Mui,GPB_C,GPB_rw,GPB_S1,GPB_Cti,GPB_phi,GPB_h,GPB_ModelK))                                                                                                                                                   | =PO.PVT.Ug.ByLGE(PO.PVT.Z.ByDAK(C142/GPB_Ppc,GPB_Tpr),GPB_SG,C142,GPB_TR)*((1-GPB_Swi)*PO.PVT.Cg.ByDefinition(C142,GPB_TR,GPB_SG)+GPB_cf) | =E141+(B142-B141)*GPB_McI*(1/D142+1/D141)/2                  | =LET(pws_psia,C142,PO.PVT.PseudoP(pws_psia,GPB_TR,GPB_SG,GPB_Pbase,GPB_Steps)) | =(F142-GPB_mPwf1)/GPB_Mega | =(GPB_tp+E142)/E142 | =GPB_tp*E142/(GPB_tp+E142) | =PO.DCA.Diag.Bourdet.SemiLog($I$122:$I$149,$G$122:$G$149,I142,GPB_L) | =IF(AND(E142>=GPB_From*(1-GPB_Eps),E142<=GPB_To*(1+GPB_Eps)),1,0) |
| 143 | =4.22                                                                                                                                                  | =B142+(A143-A142)/(GPB_McI*(1/D143+1/D142)/2)                                                                                                                                    | =PO.Spline.Cubic.Interp(GPB_MTab,GPB_PTab,GPB_mPi-GPB_Scale*PO.PTA.Pw.VW(GPB_tp+A143,$A$96:$B$97,1,GPB_Mui,GPB_C,GPB_rw,GPB_S1,GPB_Cti,GPB_phi,GPB_h,GPB_ModelK))                                                                                                                                                   | =PO.PVT.Ug.ByLGE(PO.PVT.Z.ByDAK(C143/GPB_Ppc,GPB_Tpr),GPB_SG,C143,GPB_TR)*((1-GPB_Swi)*PO.PVT.Cg.ByDefinition(C143,GPB_TR,GPB_SG)+GPB_cf) | =E142+(B143-B142)*GPB_McI*(1/D143+1/D142)/2                  | =LET(pws_psia,C143,PO.PVT.PseudoP(pws_psia,GPB_TR,GPB_SG,GPB_Pbase,GPB_Steps)) | =(F143-GPB_mPwf1)/GPB_Mega | =(GPB_tp+E143)/E143 | =GPB_tp*E143/(GPB_tp+E143) | =PO.DCA.Diag.Bourdet.SemiLog($I$122:$I$149,$G$122:$G$149,I143,GPB_L) | =IF(AND(E143>=GPB_From*(1-GPB_Eps),E143<=GPB_To*(1+GPB_Eps)),1,0) |
| 144 | =5.62                                                                                                                                                  | =B143+(A144-A143)/(GPB_McI*(1/D144+1/D143)/2)                                                                                                                                    | =PO.Spline.Cubic.Interp(GPB_MTab,GPB_PTab,GPB_mPi-GPB_Scale*PO.PTA.Pw.VW(GPB_tp+A144,$A$96:$B$97,1,GPB_Mui,GPB_C,GPB_rw,GPB_S1,GPB_Cti,GPB_phi,GPB_h,GPB_ModelK))                                                                                                                                                   | =PO.PVT.Ug.ByLGE(PO.PVT.Z.ByDAK(C144/GPB_Ppc,GPB_Tpr),GPB_SG,C144,GPB_TR)*((1-GPB_Swi)*PO.PVT.Cg.ByDefinition(C144,GPB_TR,GPB_SG)+GPB_cf) | =E143+(B144-B143)*GPB_McI*(1/D144+1/D143)/2                  | =LET(pws_psia,C144,PO.PVT.PseudoP(pws_psia,GPB_TR,GPB_SG,GPB_Pbase,GPB_Steps)) | =(F144-GPB_mPwf1)/GPB_Mega | =(GPB_tp+E144)/E144 | =GPB_tp*E144/(GPB_tp+E144) | =PO.DCA.Diag.Bourdet.SemiLog($I$122:$I$149,$G$122:$G$149,I144,GPB_L) | =IF(AND(E144>=GPB_From*(1-GPB_Eps),E144<=GPB_To*(1+GPB_Eps)),1,0) |
| 145 | =7.5                                                                                                                                                   | =B144+(A145-A144)/(GPB_McI*(1/D145+1/D144)/2)                                                                                                                                    | =PO.Spline.Cubic.Interp(GPB_MTab,GPB_PTab,GPB_mPi-GPB_Scale*PO.PTA.Pw.VW(GPB_tp+A145,$A$96:$B$97,1,GPB_Mui,GPB_C,GPB_rw,GPB_S1,GPB_Cti,GPB_phi,GPB_h,GPB_ModelK))                                                                                                                                                   | =PO.PVT.Ug.ByLGE(PO.PVT.Z.ByDAK(C145/GPB_Ppc,GPB_Tpr),GPB_SG,C145,GPB_TR)*((1-GPB_Swi)*PO.PVT.Cg.ByDefinition(C145,GPB_TR,GPB_SG)+GPB_cf) | =E144+(B145-B144)*GPB_McI*(1/D145+1/D144)/2                  | =LET(pws_psia,C145,PO.PVT.PseudoP(pws_psia,GPB_TR,GPB_SG,GPB_Pbase,GPB_Steps)) | =(F145-GPB_mPwf1)/GPB_Mega | =(GPB_tp+E145)/E145 | =GPB_tp*E145/(GPB_tp+E145) | =PO.DCA.Diag.Bourdet.SemiLog($I$122:$I$149,$G$122:$G$149,I145,GPB_L) | =IF(AND(E145>=GPB_From*(1-GPB_Eps),E145<=GPB_To*(1+GPB_Eps)),1,0) |
| 146 | =10                                                                                                                                                    | =B145+(A146-A145)/(GPB_McI*(1/D146+1/D145)/2)                                                                                                                                    | =PO.Spline.Cubic.Interp(GPB_MTab,GPB_PTab,GPB_mPi-GPB_Scale*PO.PTA.Pw.VW(GPB_tp+A146,$A$96:$B$97,1,GPB_Mui,GPB_C,GPB_rw,GPB_S1,GPB_Cti,GPB_phi,GPB_h,GPB_ModelK))                                                                                                                                                   | =PO.PVT.Ug.ByLGE(PO.PVT.Z.ByDAK(C146/GPB_Ppc,GPB_Tpr),GPB_SG,C146,GPB_TR)*((1-GPB_Swi)*PO.PVT.Cg.ByDefinition(C146,GPB_TR,GPB_SG)+GPB_cf) | =E145+(B146-B145)*GPB_McI*(1/D146+1/D145)/2                  | =LET(pws_psia,C146,PO.PVT.PseudoP(pws_psia,GPB_TR,GPB_SG,GPB_Pbase,GPB_Steps)) | =(F146-GPB_mPwf1)/GPB_Mega | =(GPB_tp+E146)/E146 | =GPB_tp*E146/(GPB_tp+E146) | =PO.DCA.Diag.Bourdet.SemiLog($I$122:$I$149,$G$122:$G$149,I146,GPB_L) | =IF(AND(E146>=GPB_From*(1-GPB_Eps),E146<=GPB_To*(1+GPB_Eps)),1,0) |
| 147 | =13.3                                                                                                                                                  | =B146+(A147-A146)/(GPB_McI*(1/D147+1/D146)/2)                                                                                                                                    | =PO.Spline.Cubic.Interp(GPB_MTab,GPB_PTab,GPB_mPi-GPB_Scale*PO.PTA.Pw.VW(GPB_tp+A147,$A$96:$B$97,1,GPB_Mui,GPB_C,GPB_rw,GPB_S1,GPB_Cti,GPB_phi,GPB_h,GPB_ModelK))                                                                                                                                                   | =PO.PVT.Ug.ByLGE(PO.PVT.Z.ByDAK(C147/GPB_Ppc,GPB_Tpr),GPB_SG,C147,GPB_TR)*((1-GPB_Swi)*PO.PVT.Cg.ByDefinition(C147,GPB_TR,GPB_SG)+GPB_cf) | =E146+(B147-B146)*GPB_McI*(1/D147+1/D146)/2                  | =LET(pws_psia,C147,PO.PVT.PseudoP(pws_psia,GPB_TR,GPB_SG,GPB_Pbase,GPB_Steps)) | =(F147-GPB_mPwf1)/GPB_Mega | =(GPB_tp+E147)/E147 | =GPB_tp*E147/(GPB_tp+E147) | =PO.DCA.Diag.Bourdet.SemiLog($I$122:$I$149,$G$122:$G$149,I147,GPB_L) | =IF(AND(E147>=GPB_From*(1-GPB_Eps),E147<=GPB_To*(1+GPB_Eps)),1,0) |
| 148 | =17.8                                                                                                                                                  | =B147+(A148-A147)/(GPB_McI*(1/D148+1/D147)/2)                                                                                                                                    | =PO.Spline.Cubic.Interp(GPB_MTab,GPB_PTab,GPB_mPi-GPB_Scale*PO.PTA.Pw.VW(GPB_tp+A148,$A$96:$B$97,1,GPB_Mui,GPB_C,GPB_rw,GPB_S1,GPB_Cti,GPB_phi,GPB_h,GPB_ModelK))                                                                                                                                                   | =PO.PVT.Ug.ByLGE(PO.PVT.Z.ByDAK(C148/GPB_Ppc,GPB_Tpr),GPB_SG,C148,GPB_TR)*((1-GPB_Swi)*PO.PVT.Cg.ByDefinition(C148,GPB_TR,GPB_SG)+GPB_cf) | =E147+(B148-B147)*GPB_McI*(1/D148+1/D147)/2                  | =LET(pws_psia,C148,PO.PVT.PseudoP(pws_psia,GPB_TR,GPB_SG,GPB_Pbase,GPB_Steps)) | =(F148-GPB_mPwf1)/GPB_Mega | =(GPB_tp+E148)/E148 | =GPB_tp*E148/(GPB_tp+E148) | =PO.DCA.Diag.Bourdet.SemiLog($I$122:$I$149,$G$122:$G$149,I148,GPB_L) | =IF(AND(E148>=GPB_From*(1-GPB_Eps),E148<=GPB_To*(1+GPB_Eps)),1,0) |
| 149 | =23.7                                                                                                                                                  | =B148+(A149-A148)/(GPB_McI*(1/D149+1/D148)/2)                                                                                                                                    | =PO.Spline.Cubic.Interp(GPB_MTab,GPB_PTab,GPB_mPi-GPB_Scale*PO.PTA.Pw.VW(GPB_tp+A149,$A$96:$B$97,1,GPB_Mui,GPB_C,GPB_rw,GPB_S1,GPB_Cti,GPB_phi,GPB_h,GPB_ModelK))                                                                                                                                                   | =PO.PVT.Ug.ByLGE(PO.PVT.Z.ByDAK(C149/GPB_Ppc,GPB_Tpr),GPB_SG,C149,GPB_TR)*((1-GPB_Swi)*PO.PVT.Cg.ByDefinition(C149,GPB_TR,GPB_SG)+GPB_cf) | =E148+(B149-B148)*GPB_McI*(1/D149+1/D148)/2                  | =LET(pws_psia,C149,PO.PVT.PseudoP(pws_psia,GPB_TR,GPB_SG,GPB_Pbase,GPB_Steps)) | =(F149-GPB_mPwf1)/GPB_Mega | =(GPB_tp+E149)/E149 | =GPB_tp*E149/(GPB_tp+E149) | =PO.DCA.Diag.Bourdet.SemiLog($I$122:$I$149,$G$122:$G$149,I149,GPB_L) | =IF(AND(E149>=GPB_From*(1-GPB_Eps),E149<=GPB_To*(1+GPB_Eps)),1,0) |
| 151 | Buildup 2: Shut-In Data, Pseudo-Time and m(p)                                                                                                          |                                                                                                                                                                                  |                                                                                                                                                                                                                                                                                                                     |                                                                                                                                           |                                                              |                                                                                |                            |                     |                            |                                                                      |                                                                   |
| 152 | Pseudo-time Δta adds up Δt·(μg·ct)i/(μg·ct) step by step along the measured pws; the derivative is taken on Agarwal's te = tp·Δta/(tp + Δta).          |                                                                                                                                                                                  |                                                                                                                                                                                                                                                                                                                     |                                                                                                                                           |                                                              |                                                                                |                            |                     |                            |                                                                      |                                                                   |
| 153 | Model Δta (hr)                                                                                                                                         | Δt (hr)                                                                                                                                                                          | pws (psia)                                                                                                                                                                                                                                                                                                          | μg·ct (cp/psi)                                                                                                                            | Δta (hr)                                                     | m(pws) (psi²/cp)                                                               | Δm (10⁶ psi²/cp)           | Horner ratio (—)    | te (hr)                    | Derivative (10⁶ psi²/cp)                                             | IARF (—)                                                          |
| 154 | =0.01                                                                                                                                                  | =A154/(GPB_McI*(1/D154+1/GPB_McPwf2)/2)                                                                                                                                          | =PO.Spline.Cubic.Interp(GPB_MTab,GPB_PTab,GPB_mPi-GPB_Scale*PO.PTA.Pw.VW(GPB_tp+A154,$D$96:$E$97,1,GPB_Mui,GPB_C,GPB_rw,GPB_S2,GPB_Cti,GPB_phi,GPB_h,GPB_ModelK))                                                                                                                                                   | =PO.PVT.Ug.ByLGE(PO.PVT.Z.ByDAK(C154/GPB_Ppc,GPB_Tpr),GPB_SG,C154,GPB_TR)*((1-GPB_Swi)*PO.PVT.Cg.ByDefinition(C154,GPB_TR,GPB_SG)+GPB_cf) | =B154*GPB_McI*(1/D154+1/GPB_McPwf2)/2                        | =LET(pws_psia,C154,PO.PVT.PseudoP(pws_psia,GPB_TR,GPB_SG,GPB_Pbase,GPB_Steps)) | =(F154-GPB_mPwf2)/GPB_Mega | =(GPB_tp+E154)/E154 | =GPB_tp*E154/(GPB_tp+E154) | =PO.DCA.Diag.Bourdet.SemiLog($I$154:$I$181,$G$154:$G$181,I154,GPB_L) | =IF(AND(E154>=GPB_From*(1-GPB_Eps),E154<=GPB_To*(1+GPB_Eps)),1,0) |
| 155 | =0.0133                                                                                                                                                | =B154+(A155-A154)/(GPB_McI*(1/D155+1/D154)/2)                                                                                                                                    | =PO.Spline.Cubic.Interp(GPB_MTab,GPB_PTab,GPB_mPi-GPB_Scale*PO.PTA.Pw.VW(GPB_tp+A155,$D$96:$E$97,1,GPB_Mui,GPB_C,GPB_rw,GPB_S2,GPB_Cti,GPB_phi,GPB_h,GPB_ModelK))                                                                                                                                                   | =PO.PVT.Ug.ByLGE(PO.PVT.Z.ByDAK(C155/GPB_Ppc,GPB_Tpr),GPB_SG,C155,GPB_TR)*((1-GPB_Swi)*PO.PVT.Cg.ByDefinition(C155,GPB_TR,GPB_SG)+GPB_cf) | =E154+(B155-B154)*GPB_McI*(1/D155+1/D154)/2                  | =LET(pws_psia,C155,PO.PVT.PseudoP(pws_psia,GPB_TR,GPB_SG,GPB_Pbase,GPB_Steps)) | =(F155-GPB_mPwf2)/GPB_Mega | =(GPB_tp+E155)/E155 | =GPB_tp*E155/(GPB_tp+E155) | =PO.DCA.Diag.Bourdet.SemiLog($I$154:$I$181,$G$154:$G$181,I155,GPB_L) | =IF(AND(E155>=GPB_From*(1-GPB_Eps),E155<=GPB_To*(1+GPB_Eps)),1,0) |
| 156 | =0.0178                                                                                                                                                | =B155+(A156-A155)/(GPB_McI*(1/D156+1/D155)/2)                                                                                                                                    | =PO.Spline.Cubic.Interp(GPB_MTab,GPB_PTab,GPB_mPi-GPB_Scale*PO.PTA.Pw.VW(GPB_tp+A156,$D$96:$E$97,1,GPB_Mui,GPB_C,GPB_rw,GPB_S2,GPB_Cti,GPB_phi,GPB_h,GPB_ModelK))                                                                                                                                                   | =PO.PVT.Ug.ByLGE(PO.PVT.Z.ByDAK(C156/GPB_Ppc,GPB_Tpr),GPB_SG,C156,GPB_TR)*((1-GPB_Swi)*PO.PVT.Cg.ByDefinition(C156,GPB_TR,GPB_SG)+GPB_cf) | =E155+(B156-B155)*GPB_McI*(1/D156+1/D155)/2                  | =LET(pws_psia,C156,PO.PVT.PseudoP(pws_psia,GPB_TR,GPB_SG,GPB_Pbase,GPB_Steps)) | =(F156-GPB_mPwf2)/GPB_Mega | =(GPB_tp+E156)/E156 | =GPB_tp*E156/(GPB_tp+E156) | =PO.DCA.Diag.Bourdet.SemiLog($I$154:$I$181,$G$154:$G$181,I156,GPB_L) | =IF(AND(E156>=GPB_From*(1-GPB_Eps),E156<=GPB_To*(1+GPB_Eps)),1,0) |
| 157 | =0.0237                                                                                                                                                | =B156+(A157-A156)/(GPB_McI*(1/D157+1/D156)/2)                                                                                                                                    | =PO.Spline.Cubic.Interp(GPB_MTab,GPB_PTab,GPB_mPi-GPB_Scale*PO.PTA.Pw.VW(GPB_tp+A157,$D$96:$E$97,1,GPB_Mui,GPB_C,GPB_rw,GPB_S2,GPB_Cti,GPB_phi,GPB_h,GPB_ModelK))                                                                                                                                                   | =PO.PVT.Ug.ByLGE(PO.PVT.Z.ByDAK(C157/GPB_Ppc,GPB_Tpr),GPB_SG,C157,GPB_TR)*((1-GPB_Swi)*PO.PVT.Cg.ByDefinition(C157,GPB_TR,GPB_SG)+GPB_cf) | =E156+(B157-B156)*GPB_McI*(1/D157+1/D156)/2                  | =LET(pws_psia,C157,PO.PVT.PseudoP(pws_psia,GPB_TR,GPB_SG,GPB_Pbase,GPB_Steps)) | =(F157-GPB_mPwf2)/GPB_Mega | =(GPB_tp+E157)/E157 | =GPB_tp*E157/(GPB_tp+E157) | =PO.DCA.Diag.Bourdet.SemiLog($I$154:$I$181,$G$154:$G$181,I157,GPB_L) | =IF(AND(E157>=GPB_From*(1-GPB_Eps),E157<=GPB_To*(1+GPB_Eps)),1,0) |
| 158 | =0.0316                                                                                                                                                | =B157+(A158-A157)/(GPB_McI*(1/D158+1/D157)/2)                                                                                                                                    | =PO.Spline.Cubic.Interp(GPB_MTab,GPB_PTab,GPB_mPi-GPB_Scale*PO.PTA.Pw.VW(GPB_tp+A158,$D$96:$E$97,1,GPB_Mui,GPB_C,GPB_rw,GPB_S2,GPB_Cti,GPB_phi,GPB_h,GPB_ModelK))                                                                                                                                                   | =PO.PVT.Ug.ByLGE(PO.PVT.Z.ByDAK(C158/GPB_Ppc,GPB_Tpr),GPB_SG,C158,GPB_TR)*((1-GPB_Swi)*PO.PVT.Cg.ByDefinition(C158,GPB_TR,GPB_SG)+GPB_cf) | =E157+(B158-B157)*GPB_McI*(1/D158+1/D157)/2                  | =LET(pws_psia,C158,PO.PVT.PseudoP(pws_psia,GPB_TR,GPB_SG,GPB_Pbase,GPB_Steps)) | =(F158-GPB_mPwf2)/GPB_Mega | =(GPB_tp+E158)/E158 | =GPB_tp*E158/(GPB_tp+E158) | =PO.DCA.Diag.Bourdet.SemiLog($I$154:$I$181,$G$154:$G$181,I158,GPB_L) | =IF(AND(E158>=GPB_From*(1-GPB_Eps),E158<=GPB_To*(1+GPB_Eps)),1,0) |
| 159 | =0.0422                                                                                                                                                | =B158+(A159-A158)/(GPB_McI*(1/D159+1/D158)/2)                                                                                                                                    | =PO.Spline.Cubic.Interp(GPB_MTab,GPB_PTab,GPB_mPi-GPB_Scale*PO.PTA.Pw.VW(GPB_tp+A159,$D$96:$E$97,1,GPB_Mui,GPB_C,GPB_rw,GPB_S2,GPB_Cti,GPB_phi,GPB_h,GPB_ModelK))                                                                                                                                                   | =PO.PVT.Ug.ByLGE(PO.PVT.Z.ByDAK(C159/GPB_Ppc,GPB_Tpr),GPB_SG,C159,GPB_TR)*((1-GPB_Swi)*PO.PVT.Cg.ByDefinition(C159,GPB_TR,GPB_SG)+GPB_cf) | =E158+(B159-B158)*GPB_McI*(1/D159+1/D158)/2                  | =LET(pws_psia,C159,PO.PVT.PseudoP(pws_psia,GPB_TR,GPB_SG,GPB_Pbase,GPB_Steps)) | =(F159-GPB_mPwf2)/GPB_Mega | =(GPB_tp+E159)/E159 | =GPB_tp*E159/(GPB_tp+E159) | =PO.DCA.Diag.Bourdet.SemiLog($I$154:$I$181,$G$154:$G$181,I159,GPB_L) | =IF(AND(E159>=GPB_From*(1-GPB_Eps),E159<=GPB_To*(1+GPB_Eps)),1,0) |
| 160 | =0.0562                                                                                                                                                | =B159+(A160-A159)/(GPB_McI*(1/D160+1/D159)/2)                                                                                                                                    | =PO.Spline.Cubic.Interp(GPB_MTab,GPB_PTab,GPB_mPi-GPB_Scale*PO.PTA.Pw.VW(GPB_tp+A160,$D$96:$E$97,1,GPB_Mui,GPB_C,GPB_rw,GPB_S2,GPB_Cti,GPB_phi,GPB_h,GPB_ModelK))                                                                                                                                                   | =PO.PVT.Ug.ByLGE(PO.PVT.Z.ByDAK(C160/GPB_Ppc,GPB_Tpr),GPB_SG,C160,GPB_TR)*((1-GPB_Swi)*PO.PVT.Cg.ByDefinition(C160,GPB_TR,GPB_SG)+GPB_cf) | =E159+(B160-B159)*GPB_McI*(1/D160+1/D159)/2                  | =LET(pws_psia,C160,PO.PVT.PseudoP(pws_psia,GPB_TR,GPB_SG,GPB_Pbase,GPB_Steps)) | =(F160-GPB_mPwf2)/GPB_Mega | =(GPB_tp+E160)/E160 | =GPB_tp*E160/(GPB_tp+E160) | =PO.DCA.Diag.Bourdet.SemiLog($I$154:$I$181,$G$154:$G$181,I160,GPB_L) | =IF(AND(E160>=GPB_From*(1-GPB_Eps),E160<=GPB_To*(1+GPB_Eps)),1,0) |
| 161 | =0.075                                                                                                                                                 | =B160+(A161-A160)/(GPB_McI*(1/D161+1/D160)/2)                                                                                                                                    | =PO.Spline.Cubic.Interp(GPB_MTab,GPB_PTab,GPB_mPi-GPB_Scale*PO.PTA.Pw.VW(GPB_tp+A161,$D$96:$E$97,1,GPB_Mui,GPB_C,GPB_rw,GPB_S2,GPB_Cti,GPB_phi,GPB_h,GPB_ModelK))                                                                                                                                                   | =PO.PVT.Ug.ByLGE(PO.PVT.Z.ByDAK(C161/GPB_Ppc,GPB_Tpr),GPB_SG,C161,GPB_TR)*((1-GPB_Swi)*PO.PVT.Cg.ByDefinition(C161,GPB_TR,GPB_SG)+GPB_cf) | =E160+(B161-B160)*GPB_McI*(1/D161+1/D160)/2                  | =LET(pws_psia,C161,PO.PVT.PseudoP(pws_psia,GPB_TR,GPB_SG,GPB_Pbase,GPB_Steps)) | =(F161-GPB_mPwf2)/GPB_Mega | =(GPB_tp+E161)/E161 | =GPB_tp*E161/(GPB_tp+E161) | =PO.DCA.Diag.Bourdet.SemiLog($I$154:$I$181,$G$154:$G$181,I161,GPB_L) | =IF(AND(E161>=GPB_From*(1-GPB_Eps),E161<=GPB_To*(1+GPB_Eps)),1,0) |
| 162 | =0.1                                                                                                                                                   | =B161+(A162-A161)/(GPB_McI*(1/D162+1/D161)/2)                                                                                                                                    | =PO.Spline.Cubic.Interp(GPB_MTab,GPB_PTab,GPB_mPi-GPB_Scale*PO.PTA.Pw.VW(GPB_tp+A162,$D$96:$E$97,1,GPB_Mui,GPB_C,GPB_rw,GPB_S2,GPB_Cti,GPB_phi,GPB_h,GPB_ModelK))                                                                                                                                                   | =PO.PVT.Ug.ByLGE(PO.PVT.Z.ByDAK(C162/GPB_Ppc,GPB_Tpr),GPB_SG,C162,GPB_TR)*((1-GPB_Swi)*PO.PVT.Cg.ByDefinition(C162,GPB_TR,GPB_SG)+GPB_cf) | =E161+(B162-B161)*GPB_McI*(1/D162+1/D161)/2                  | =LET(pws_psia,C162,PO.PVT.PseudoP(pws_psia,GPB_TR,GPB_SG,GPB_Pbase,GPB_Steps)) | =(F162-GPB_mPwf2)/GPB_Mega | =(GPB_tp+E162)/E162 | =GPB_tp*E162/(GPB_tp+E162) | =PO.DCA.Diag.Bourdet.SemiLog($I$154:$I$181,$G$154:$G$181,I162,GPB_L) | =IF(AND(E162>=GPB_From*(1-GPB_Eps),E162<=GPB_To*(1+GPB_Eps)),1,0) |
| 163 | =0.133                                                                                                                                                 | =B162+(A163-A162)/(GPB_McI*(1/D163+1/D162)/2)                                                                                                                                    | =PO.Spline.Cubic.Interp(GPB_MTab,GPB_PTab,GPB_mPi-GPB_Scale*PO.PTA.Pw.VW(GPB_tp+A163,$D$96:$E$97,1,GPB_Mui,GPB_C,GPB_rw,GPB_S2,GPB_Cti,GPB_phi,GPB_h,GPB_ModelK))                                                                                                                                                   | =PO.PVT.Ug.ByLGE(PO.PVT.Z.ByDAK(C163/GPB_Ppc,GPB_Tpr),GPB_SG,C163,GPB_TR)*((1-GPB_Swi)*PO.PVT.Cg.ByDefinition(C163,GPB_TR,GPB_SG)+GPB_cf) | =E162+(B163-B162)*GPB_McI*(1/D163+1/D162)/2                  | =LET(pws_psia,C163,PO.PVT.PseudoP(pws_psia,GPB_TR,GPB_SG,GPB_Pbase,GPB_Steps)) | =(F163-GPB_mPwf2)/GPB_Mega | =(GPB_tp+E163)/E163 | =GPB_tp*E163/(GPB_tp+E163) | =PO.DCA.Diag.Bourdet.SemiLog($I$154:$I$181,$G$154:$G$181,I163,GPB_L) | =IF(AND(E163>=GPB_From*(1-GPB_Eps),E163<=GPB_To*(1+GPB_Eps)),1,0) |
| 164 | =0.178                                                                                                                                                 | =B163+(A164-A163)/(GPB_McI*(1/D164+1/D163)/2)                                                                                                                                    | =PO.Spline.Cubic.Interp(GPB_MTab,GPB_PTab,GPB_mPi-GPB_Scale*PO.PTA.Pw.VW(GPB_tp+A164,$D$96:$E$97,1,GPB_Mui,GPB_C,GPB_rw,GPB_S2,GPB_Cti,GPB_phi,GPB_h,GPB_ModelK))                                                                                                                                                   | =PO.PVT.Ug.ByLGE(PO.PVT.Z.ByDAK(C164/GPB_Ppc,GPB_Tpr),GPB_SG,C164,GPB_TR)*((1-GPB_Swi)*PO.PVT.Cg.ByDefinition(C164,GPB_TR,GPB_SG)+GPB_cf) | =E163+(B164-B163)*GPB_McI*(1/D164+1/D163)/2                  | =LET(pws_psia,C164,PO.PVT.PseudoP(pws_psia,GPB_TR,GPB_SG,GPB_Pbase,GPB_Steps)) | =(F164-GPB_mPwf2)/GPB_Mega | =(GPB_tp+E164)/E164 | =GPB_tp*E164/(GPB_tp+E164) | =PO.DCA.Diag.Bourdet.SemiLog($I$154:$I$181,$G$154:$G$181,I164,GPB_L) | =IF(AND(E164>=GPB_From*(1-GPB_Eps),E164<=GPB_To*(1+GPB_Eps)),1,0) |
| 165 | =0.237                                                                                                                                                 | =B164+(A165-A164)/(GPB_McI*(1/D165+1/D164)/2)                                                                                                                                    | =PO.Spline.Cubic.Interp(GPB_MTab,GPB_PTab,GPB_mPi-GPB_Scale*PO.PTA.Pw.VW(GPB_tp+A165,$D$96:$E$97,1,GPB_Mui,GPB_C,GPB_rw,GPB_S2,GPB_Cti,GPB_phi,GPB_h,GPB_ModelK))                                                                                                                                                   | =PO.PVT.Ug.ByLGE(PO.PVT.Z.ByDAK(C165/GPB_Ppc,GPB_Tpr),GPB_SG,C165,GPB_TR)*((1-GPB_Swi)*PO.PVT.Cg.ByDefinition(C165,GPB_TR,GPB_SG)+GPB_cf) | =E164+(B165-B164)*GPB_McI*(1/D165+1/D164)/2                  | =LET(pws_psia,C165,PO.PVT.PseudoP(pws_psia,GPB_TR,GPB_SG,GPB_Pbase,GPB_Steps)) | =(F165-GPB_mPwf2)/GPB_Mega | =(GPB_tp+E165)/E165 | =GPB_tp*E165/(GPB_tp+E165) | =PO.DCA.Diag.Bourdet.SemiLog($I$154:$I$181,$G$154:$G$181,I165,GPB_L) | =IF(AND(E165>=GPB_From*(1-GPB_Eps),E165<=GPB_To*(1+GPB_Eps)),1,0) |
| 166 | =0.316                                                                                                                                                 | =B165+(A166-A165)/(GPB_McI*(1/D166+1/D165)/2)                                                                                                                                    | =PO.Spline.Cubic.Interp(GPB_MTab,GPB_PTab,GPB_mPi-GPB_Scale*PO.PTA.Pw.VW(GPB_tp+A166,$D$96:$E$97,1,GPB_Mui,GPB_C,GPB_rw,GPB_S2,GPB_Cti,GPB_phi,GPB_h,GPB_ModelK))                                                                                                                                                   | =PO.PVT.Ug.ByLGE(PO.PVT.Z.ByDAK(C166/GPB_Ppc,GPB_Tpr),GPB_SG,C166,GPB_TR)*((1-GPB_Swi)*PO.PVT.Cg.ByDefinition(C166,GPB_TR,GPB_SG)+GPB_cf) | =E165+(B166-B165)*GPB_McI*(1/D166+1/D165)/2                  | =LET(pws_psia,C166,PO.PVT.PseudoP(pws_psia,GPB_TR,GPB_SG,GPB_Pbase,GPB_Steps)) | =(F166-GPB_mPwf2)/GPB_Mega | =(GPB_tp+E166)/E166 | =GPB_tp*E166/(GPB_tp+E166) | =PO.DCA.Diag.Bourdet.SemiLog($I$154:$I$181,$G$154:$G$181,I166,GPB_L) | =IF(AND(E166>=GPB_From*(1-GPB_Eps),E166<=GPB_To*(1+GPB_Eps)),1,0) |
| 167 | =0.422                                                                                                                                                 | =B166+(A167-A166)/(GPB_McI*(1/D167+1/D166)/2)                                                                                                                                    | =PO.Spline.Cubic.Interp(GPB_MTab,GPB_PTab,GPB_mPi-GPB_Scale*PO.PTA.Pw.VW(GPB_tp+A167,$D$96:$E$97,1,GPB_Mui,GPB_C,GPB_rw,GPB_S2,GPB_Cti,GPB_phi,GPB_h,GPB_ModelK))                                                                                                                                                   | =PO.PVT.Ug.ByLGE(PO.PVT.Z.ByDAK(C167/GPB_Ppc,GPB_Tpr),GPB_SG,C167,GPB_TR)*((1-GPB_Swi)*PO.PVT.Cg.ByDefinition(C167,GPB_TR,GPB_SG)+GPB_cf) | =E166+(B167-B166)*GPB_McI*(1/D167+1/D166)/2                  | =LET(pws_psia,C167,PO.PVT.PseudoP(pws_psia,GPB_TR,GPB_SG,GPB_Pbase,GPB_Steps)) | =(F167-GPB_mPwf2)/GPB_Mega | =(GPB_tp+E167)/E167 | =GPB_tp*E167/(GPB_tp+E167) | =PO.DCA.Diag.Bourdet.SemiLog($I$154:$I$181,$G$154:$G$181,I167,GPB_L) | =IF(AND(E167>=GPB_From*(1-GPB_Eps),E167<=GPB_To*(1+GPB_Eps)),1,0) |
| 168 | =0.562                                                                                                                                                 | =B167+(A168-A167)/(GPB_McI*(1/D168+1/D167)/2)                                                                                                                                    | =PO.Spline.Cubic.Interp(GPB_MTab,GPB_PTab,GPB_mPi-GPB_Scale*PO.PTA.Pw.VW(GPB_tp+A168,$D$96:$E$97,1,GPB_Mui,GPB_C,GPB_rw,GPB_S2,GPB_Cti,GPB_phi,GPB_h,GPB_ModelK))                                                                                                                                                   | =PO.PVT.Ug.ByLGE(PO.PVT.Z.ByDAK(C168/GPB_Ppc,GPB_Tpr),GPB_SG,C168,GPB_TR)*((1-GPB_Swi)*PO.PVT.Cg.ByDefinition(C168,GPB_TR,GPB_SG)+GPB_cf) | =E167+(B168-B167)*GPB_McI*(1/D168+1/D167)/2                  | =LET(pws_psia,C168,PO.PVT.PseudoP(pws_psia,GPB_TR,GPB_SG,GPB_Pbase,GPB_Steps)) | =(F168-GPB_mPwf2)/GPB_Mega | =(GPB_tp+E168)/E168 | =GPB_tp*E168/(GPB_tp+E168) | =PO.DCA.Diag.Bourdet.SemiLog($I$154:$I$181,$G$154:$G$181,I168,GPB_L) | =IF(AND(E168>=GPB_From*(1-GPB_Eps),E168<=GPB_To*(1+GPB_Eps)),1,0) |
| 169 | =0.75                                                                                                                                                  | =B168+(A169-A168)/(GPB_McI*(1/D169+1/D168)/2)                                                                                                                                    | =PO.Spline.Cubic.Interp(GPB_MTab,GPB_PTab,GPB_mPi-GPB_Scale*PO.PTA.Pw.VW(GPB_tp+A169,$D$96:$E$97,1,GPB_Mui,GPB_C,GPB_rw,GPB_S2,GPB_Cti,GPB_phi,GPB_h,GPB_ModelK))                                                                                                                                                   | =PO.PVT.Ug.ByLGE(PO.PVT.Z.ByDAK(C169/GPB_Ppc,GPB_Tpr),GPB_SG,C169,GPB_TR)*((1-GPB_Swi)*PO.PVT.Cg.ByDefinition(C169,GPB_TR,GPB_SG)+GPB_cf) | =E168+(B169-B168)*GPB_McI*(1/D169+1/D168)/2                  | =LET(pws_psia,C169,PO.PVT.PseudoP(pws_psia,GPB_TR,GPB_SG,GPB_Pbase,GPB_Steps)) | =(F169-GPB_mPwf2)/GPB_Mega | =(GPB_tp+E169)/E169 | =GPB_tp*E169/(GPB_tp+E169) | =PO.DCA.Diag.Bourdet.SemiLog($I$154:$I$181,$G$154:$G$181,I169,GPB_L) | =IF(AND(E169>=GPB_From*(1-GPB_Eps),E169<=GPB_To*(1+GPB_Eps)),1,0) |
| 170 | =1                                                                                                                                                     | =B169+(A170-A169)/(GPB_McI*(1/D170+1/D169)/2)                                                                                                                                    | =PO.Spline.Cubic.Interp(GPB_MTab,GPB_PTab,GPB_mPi-GPB_Scale*PO.PTA.Pw.VW(GPB_tp+A170,$D$96:$E$97,1,GPB_Mui,GPB_C,GPB_rw,GPB_S2,GPB_Cti,GPB_phi,GPB_h,GPB_ModelK))                                                                                                                                                   | =PO.PVT.Ug.ByLGE(PO.PVT.Z.ByDAK(C170/GPB_Ppc,GPB_Tpr),GPB_SG,C170,GPB_TR)*((1-GPB_Swi)*PO.PVT.Cg.ByDefinition(C170,GPB_TR,GPB_SG)+GPB_cf) | =E169+(B170-B169)*GPB_McI*(1/D170+1/D169)/2                  | =LET(pws_psia,C170,PO.PVT.PseudoP(pws_psia,GPB_TR,GPB_SG,GPB_Pbase,GPB_Steps)) | =(F170-GPB_mPwf2)/GPB_Mega | =(GPB_tp+E170)/E170 | =GPB_tp*E170/(GPB_tp+E170) | =PO.DCA.Diag.Bourdet.SemiLog($I$154:$I$181,$G$154:$G$181,I170,GPB_L) | =IF(AND(E170>=GPB_From*(1-GPB_Eps),E170<=GPB_To*(1+GPB_Eps)),1,0) |
| 171 | =1.33                                                                                                                                                  | =B170+(A171-A170)/(GPB_McI*(1/D171+1/D170)/2)                                                                                                                                    | =PO.Spline.Cubic.Interp(GPB_MTab,GPB_PTab,GPB_mPi-GPB_Scale*PO.PTA.Pw.VW(GPB_tp+A171,$D$96:$E$97,1,GPB_Mui,GPB_C,GPB_rw,GPB_S2,GPB_Cti,GPB_phi,GPB_h,GPB_ModelK))                                                                                                                                                   | =PO.PVT.Ug.ByLGE(PO.PVT.Z.ByDAK(C171/GPB_Ppc,GPB_Tpr),GPB_SG,C171,GPB_TR)*((1-GPB_Swi)*PO.PVT.Cg.ByDefinition(C171,GPB_TR,GPB_SG)+GPB_cf) | =E170+(B171-B170)*GPB_McI*(1/D171+1/D170)/2                  | =LET(pws_psia,C171,PO.PVT.PseudoP(pws_psia,GPB_TR,GPB_SG,GPB_Pbase,GPB_Steps)) | =(F171-GPB_mPwf2)/GPB_Mega | =(GPB_tp+E171)/E171 | =GPB_tp*E171/(GPB_tp+E171) | =PO.DCA.Diag.Bourdet.SemiLog($I$154:$I$181,$G$154:$G$181,I171,GPB_L) | =IF(AND(E171>=GPB_From*(1-GPB_Eps),E171<=GPB_To*(1+GPB_Eps)),1,0) |
| 172 | =1.78                                                                                                                                                  | =B171+(A172-A171)/(GPB_McI*(1/D172+1/D171)/2)                                                                                                                                    | =PO.Spline.Cubic.Interp(GPB_MTab,GPB_PTab,GPB_mPi-GPB_Scale*PO.PTA.Pw.VW(GPB_tp+A172,$D$96:$E$97,1,GPB_Mui,GPB_C,GPB_rw,GPB_S2,GPB_Cti,GPB_phi,GPB_h,GPB_ModelK))                                                                                                                                                   | =PO.PVT.Ug.ByLGE(PO.PVT.Z.ByDAK(C172/GPB_Ppc,GPB_Tpr),GPB_SG,C172,GPB_TR)*((1-GPB_Swi)*PO.PVT.Cg.ByDefinition(C172,GPB_TR,GPB_SG)+GPB_cf) | =E171+(B172-B171)*GPB_McI*(1/D172+1/D171)/2                  | =LET(pws_psia,C172,PO.PVT.PseudoP(pws_psia,GPB_TR,GPB_SG,GPB_Pbase,GPB_Steps)) | =(F172-GPB_mPwf2)/GPB_Mega | =(GPB_tp+E172)/E172 | =GPB_tp*E172/(GPB_tp+E172) | =PO.DCA.Diag.Bourdet.SemiLog($I$154:$I$181,$G$154:$G$181,I172,GPB_L) | =IF(AND(E172>=GPB_From*(1-GPB_Eps),E172<=GPB_To*(1+GPB_Eps)),1,0) |
| 173 | =2.37                                                                                                                                                  | =B172+(A173-A172)/(GPB_McI*(1/D173+1/D172)/2)                                                                                                                                    | =PO.Spline.Cubic.Interp(GPB_MTab,GPB_PTab,GPB_mPi-GPB_Scale*PO.PTA.Pw.VW(GPB_tp+A173,$D$96:$E$97,1,GPB_Mui,GPB_C,GPB_rw,GPB_S2,GPB_Cti,GPB_phi,GPB_h,GPB_ModelK))                                                                                                                                                   | =PO.PVT.Ug.ByLGE(PO.PVT.Z.ByDAK(C173/GPB_Ppc,GPB_Tpr),GPB_SG,C173,GPB_TR)*((1-GPB_Swi)*PO.PVT.Cg.ByDefinition(C173,GPB_TR,GPB_SG)+GPB_cf) | =E172+(B173-B172)*GPB_McI*(1/D173+1/D172)/2                  | =LET(pws_psia,C173,PO.PVT.PseudoP(pws_psia,GPB_TR,GPB_SG,GPB_Pbase,GPB_Steps)) | =(F173-GPB_mPwf2)/GPB_Mega | =(GPB_tp+E173)/E173 | =GPB_tp*E173/(GPB_tp+E173) | =PO.DCA.Diag.Bourdet.SemiLog($I$154:$I$181,$G$154:$G$181,I173,GPB_L) | =IF(AND(E173>=GPB_From*(1-GPB_Eps),E173<=GPB_To*(1+GPB_Eps)),1,0) |
| 174 | =3.16                                                                                                                                                  | =B173+(A174-A173)/(GPB_McI*(1/D174+1/D173)/2)                                                                                                                                    | =PO.Spline.Cubic.Interp(GPB_MTab,GPB_PTab,GPB_mPi-GPB_Scale*PO.PTA.Pw.VW(GPB_tp+A174,$D$96:$E$97,1,GPB_Mui,GPB_C,GPB_rw,GPB_S2,GPB_Cti,GPB_phi,GPB_h,GPB_ModelK))                                                                                                                                                   | =PO.PVT.Ug.ByLGE(PO.PVT.Z.ByDAK(C174/GPB_Ppc,GPB_Tpr),GPB_SG,C174,GPB_TR)*((1-GPB_Swi)*PO.PVT.Cg.ByDefinition(C174,GPB_TR,GPB_SG)+GPB_cf) | =E173+(B174-B173)*GPB_McI*(1/D174+1/D173)/2                  | =LET(pws_psia,C174,PO.PVT.PseudoP(pws_psia,GPB_TR,GPB_SG,GPB_Pbase,GPB_Steps)) | =(F174-GPB_mPwf2)/GPB_Mega | =(GPB_tp+E174)/E174 | =GPB_tp*E174/(GPB_tp+E174) | =PO.DCA.Diag.Bourdet.SemiLog($I$154:$I$181,$G$154:$G$181,I174,GPB_L) | =IF(AND(E174>=GPB_From*(1-GPB_Eps),E174<=GPB_To*(1+GPB_Eps)),1,0) |
| 175 | =4.22                                                                                                                                                  | =B174+(A175-A174)/(GPB_McI*(1/D175+1/D174)/2)                                                                                                                                    | =PO.Spline.Cubic.Interp(GPB_MTab,GPB_PTab,GPB_mPi-GPB_Scale*PO.PTA.Pw.VW(GPB_tp+A175,$D$96:$E$97,1,GPB_Mui,GPB_C,GPB_rw,GPB_S2,GPB_Cti,GPB_phi,GPB_h,GPB_ModelK))                                                                                                                                                   | =PO.PVT.Ug.ByLGE(PO.PVT.Z.ByDAK(C175/GPB_Ppc,GPB_Tpr),GPB_SG,C175,GPB_TR)*((1-GPB_Swi)*PO.PVT.Cg.ByDefinition(C175,GPB_TR,GPB_SG)+GPB_cf) | =E174+(B175-B174)*GPB_McI*(1/D175+1/D174)/2                  | =LET(pws_psia,C175,PO.PVT.PseudoP(pws_psia,GPB_TR,GPB_SG,GPB_Pbase,GPB_Steps)) | =(F175-GPB_mPwf2)/GPB_Mega | =(GPB_tp+E175)/E175 | =GPB_tp*E175/(GPB_tp+E175) | =PO.DCA.Diag.Bourdet.SemiLog($I$154:$I$181,$G$154:$G$181,I175,GPB_L) | =IF(AND(E175>=GPB_From*(1-GPB_Eps),E175<=GPB_To*(1+GPB_Eps)),1,0) |
| 176 | =5.62                                                                                                                                                  | =B175+(A176-A175)/(GPB_McI*(1/D176+1/D175)/2)                                                                                                                                    | =PO.Spline.Cubic.Interp(GPB_MTab,GPB_PTab,GPB_mPi-GPB_Scale*PO.PTA.Pw.VW(GPB_tp+A176,$D$96:$E$97,1,GPB_Mui,GPB_C,GPB_rw,GPB_S2,GPB_Cti,GPB_phi,GPB_h,GPB_ModelK))                                                                                                                                                   | =PO.PVT.Ug.ByLGE(PO.PVT.Z.ByDAK(C176/GPB_Ppc,GPB_Tpr),GPB_SG,C176,GPB_TR)*((1-GPB_Swi)*PO.PVT.Cg.ByDefinition(C176,GPB_TR,GPB_SG)+GPB_cf) | =E175+(B176-B175)*GPB_McI*(1/D176+1/D175)/2                  | =LET(pws_psia,C176,PO.PVT.PseudoP(pws_psia,GPB_TR,GPB_SG,GPB_Pbase,GPB_Steps)) | =(F176-GPB_mPwf2)/GPB_Mega | =(GPB_tp+E176)/E176 | =GPB_tp*E176/(GPB_tp+E176) | =PO.DCA.Diag.Bourdet.SemiLog($I$154:$I$181,$G$154:$G$181,I176,GPB_L) | =IF(AND(E176>=GPB_From*(1-GPB_Eps),E176<=GPB_To*(1+GPB_Eps)),1,0) |
| 177 | =7.5                                                                                                                                                   | =B176+(A177-A176)/(GPB_McI*(1/D177+1/D176)/2)                                                                                                                                    | =PO.Spline.Cubic.Interp(GPB_MTab,GPB_PTab,GPB_mPi-GPB_Scale*PO.PTA.Pw.VW(GPB_tp+A177,$D$96:$E$97,1,GPB_Mui,GPB_C,GPB_rw,GPB_S2,GPB_Cti,GPB_phi,GPB_h,GPB_ModelK))                                                                                                                                                   | =PO.PVT.Ug.ByLGE(PO.PVT.Z.ByDAK(C177/GPB_Ppc,GPB_Tpr),GPB_SG,C177,GPB_TR)*((1-GPB_Swi)*PO.PVT.Cg.ByDefinition(C177,GPB_TR,GPB_SG)+GPB_cf) | =E176+(B177-B176)*GPB_McI*(1/D177+1/D176)/2                  | =LET(pws_psia,C177,PO.PVT.PseudoP(pws_psia,GPB_TR,GPB_SG,GPB_Pbase,GPB_Steps)) | =(F177-GPB_mPwf2)/GPB_Mega | =(GPB_tp+E177)/E177 | =GPB_tp*E177/(GPB_tp+E177) | =PO.DCA.Diag.Bourdet.SemiLog($I$154:$I$181,$G$154:$G$181,I177,GPB_L) | =IF(AND(E177>=GPB_From*(1-GPB_Eps),E177<=GPB_To*(1+GPB_Eps)),1,0) |
| 178 | =10                                                                                                                                                    | =B177+(A178-A177)/(GPB_McI*(1/D178+1/D177)/2)                                                                                                                                    | =PO.Spline.Cubic.Interp(GPB_MTab,GPB_PTab,GPB_mPi-GPB_Scale*PO.PTA.Pw.VW(GPB_tp+A178,$D$96:$E$97,1,GPB_Mui,GPB_C,GPB_rw,GPB_S2,GPB_Cti,GPB_phi,GPB_h,GPB_ModelK))                                                                                                                                                   | =PO.PVT.Ug.ByLGE(PO.PVT.Z.ByDAK(C178/GPB_Ppc,GPB_Tpr),GPB_SG,C178,GPB_TR)*((1-GPB_Swi)*PO.PVT.Cg.ByDefinition(C178,GPB_TR,GPB_SG)+GPB_cf) | =E177+(B178-B177)*GPB_McI*(1/D178+1/D177)/2                  | =LET(pws_psia,C178,PO.PVT.PseudoP(pws_psia,GPB_TR,GPB_SG,GPB_Pbase,GPB_Steps)) | =(F178-GPB_mPwf2)/GPB_Mega | =(GPB_tp+E178)/E178 | =GPB_tp*E178/(GPB_tp+E178) | =PO.DCA.Diag.Bourdet.SemiLog($I$154:$I$181,$G$154:$G$181,I178,GPB_L) | =IF(AND(E178>=GPB_From*(1-GPB_Eps),E178<=GPB_To*(1+GPB_Eps)),1,0) |
| 179 | =13.3                                                                                                                                                  | =B178+(A179-A178)/(GPB_McI*(1/D179+1/D178)/2)                                                                                                                                    | =PO.Spline.Cubic.Interp(GPB_MTab,GPB_PTab,GPB_mPi-GPB_Scale*PO.PTA.Pw.VW(GPB_tp+A179,$D$96:$E$97,1,GPB_Mui,GPB_C,GPB_rw,GPB_S2,GPB_Cti,GPB_phi,GPB_h,GPB_ModelK))                                                                                                                                                   | =PO.PVT.Ug.ByLGE(PO.PVT.Z.ByDAK(C179/GPB_Ppc,GPB_Tpr),GPB_SG,C179,GPB_TR)*((1-GPB_Swi)*PO.PVT.Cg.ByDefinition(C179,GPB_TR,GPB_SG)+GPB_cf) | =E178+(B179-B178)*GPB_McI*(1/D179+1/D178)/2                  | =LET(pws_psia,C179,PO.PVT.PseudoP(pws_psia,GPB_TR,GPB_SG,GPB_Pbase,GPB_Steps)) | =(F179-GPB_mPwf2)/GPB_Mega | =(GPB_tp+E179)/E179 | =GPB_tp*E179/(GPB_tp+E179) | =PO.DCA.Diag.Bourdet.SemiLog($I$154:$I$181,$G$154:$G$181,I179,GPB_L) | =IF(AND(E179>=GPB_From*(1-GPB_Eps),E179<=GPB_To*(1+GPB_Eps)),1,0) |
| 180 | =17.8                                                                                                                                                  | =B179+(A180-A179)/(GPB_McI*(1/D180+1/D179)/2)                                                                                                                                    | =PO.Spline.Cubic.Interp(GPB_MTab,GPB_PTab,GPB_mPi-GPB_Scale*PO.PTA.Pw.VW(GPB_tp+A180,$D$96:$E$97,1,GPB_Mui,GPB_C,GPB_rw,GPB_S2,GPB_Cti,GPB_phi,GPB_h,GPB_ModelK))                                                                                                                                                   | =PO.PVT.Ug.ByLGE(PO.PVT.Z.ByDAK(C180/GPB_Ppc,GPB_Tpr),GPB_SG,C180,GPB_TR)*((1-GPB_Swi)*PO.PVT.Cg.ByDefinition(C180,GPB_TR,GPB_SG)+GPB_cf) | =E179+(B180-B179)*GPB_McI*(1/D180+1/D179)/2                  | =LET(pws_psia,C180,PO.PVT.PseudoP(pws_psia,GPB_TR,GPB_SG,GPB_Pbase,GPB_Steps)) | =(F180-GPB_mPwf2)/GPB_Mega | =(GPB_tp+E180)/E180 | =GPB_tp*E180/(GPB_tp+E180) | =PO.DCA.Diag.Bourdet.SemiLog($I$154:$I$181,$G$154:$G$181,I180,GPB_L) | =IF(AND(E180>=GPB_From*(1-GPB_Eps),E180<=GPB_To*(1+GPB_Eps)),1,0) |
| 181 | =23.7                                                                                                                                                  | =B180+(A181-A180)/(GPB_McI*(1/D181+1/D180)/2)                                                                                                                                    | =PO.Spline.Cubic.Interp(GPB_MTab,GPB_PTab,GPB_mPi-GPB_Scale*PO.PTA.Pw.VW(GPB_tp+A181,$D$96:$E$97,1,GPB_Mui,GPB_C,GPB_rw,GPB_S2,GPB_Cti,GPB_phi,GPB_h,GPB_ModelK))                                                                                                                                                   | =PO.PVT.Ug.ByLGE(PO.PVT.Z.ByDAK(C181/GPB_Ppc,GPB_Tpr),GPB_SG,C181,GPB_TR)*((1-GPB_Swi)*PO.PVT.Cg.ByDefinition(C181,GPB_TR,GPB_SG)+GPB_cf) | =E180+(B181-B180)*GPB_McI*(1/D181+1/D180)/2                  | =LET(pws_psia,C181,PO.PVT.PseudoP(pws_psia,GPB_TR,GPB_SG,GPB_Pbase,GPB_Steps)) | =(F181-GPB_mPwf2)/GPB_Mega | =(GPB_tp+E181)/E181 | =GPB_tp*E181/(GPB_tp+E181) | =PO.DCA.Diag.Bourdet.SemiLog($I$154:$I$181,$G$154:$G$181,I181,GPB_L) | =IF(AND(E181>=GPB_From*(1-GPB_Eps),E181<=GPB_To*(1+GPB_Eps)),1,0) |

## Lambdas

| Name | RefersTo | Comment |
|------|----------|---------|
| PO.PVT.PseudoP | =LAMBDA(p, t_r, sg_g, p_base, steps, IF((p<p_base)+(t_r<=0)+(sg_g<=0)+(steps<1)+(p_base/PO.PVT.Ppc.BySutton(sg_g)<0.01), NA(), LET(ppc, PO.PVT.Ppc.BySutton(sg_g), tpr, t_r/PO.PVT.Tpc.BySutton(sg_g), n, INT(steps), dp, (p-p_base)/n, f, MAP(p_base+dp*SEQUENCE(n+1, 1, 0), LAMBDA(x, LET(z, PO.PVT.Z.ByDAK(x/ppc, tpr), x/(PO.PVT.Ug.ByLGE(z, sg_g, x, t_r)*z)))), 2*dp*(SUM(f)-(INDEX(f, 1)+INDEX(f, n+1))/2)))) | Real-gas pseudo-pressure m(p) = 2*integral of p/(ug*Z) dp from p_base to p (psi2/cp), trapezoid rule in steps; Z by DAK and ug by LGE at Sutton pseudo-criticals. p, p_base psia (p_base >= 7), t_r degR, sg_g air = 1. |

## Names

| Name | RefersTo | Comment |
|------|----------|---------|
| GPB_Pi | $B$4 | Initial reservoir pressure, pi, psia |
| GPB_T | $B$5 | Reservoir temperature, T, °F |
| GPB_SG | $B$6 | Gas specific gravity (air = 1), sweet gas, air = 1 |
| GPB_h | $B$7 | Net pay, h, ft |
| GPB_phi | $B$8 | Porosity, φ, % |
| GPB_Swi | $B$9 | Water saturation, Swi, % |
| GPB_cf | $B$10 | Rock and water compressibility, cf + Swi·cw, 1/psi |
| GPB_rw | $B$11 | Wellbore radius, rw, ft |
| GPB_Pbase | $B$12 | Base pressure of m(p), psia |
| GPB_q1 | $B$14 | Rate before buildup 1, q1, Mscf/d |
| GPB_q2 | $B$15 | Rate before buildup 2, q2, Mscf/d |
| GPB_tp | $B$16 | Flow before each buildup, tp, hr |
| GPB_Pwf1 | $B$17 | pwf at shut-in, test 1 (0: the model's), psia |
| GPB_Pwf2 | $B$18 | pwf at shut-in, test 2 (0: the model's), psia |
| GPB_L | $B$20 | Bourdet smoothing window, L, cycles |
| GPB_From | $B$21 | IARF window from pseudo-time Δta, hr |
| GPB_To | $B$22 | IARF window to pseudo-time Δta, hr |
| GPB_Flat | $B$23 | Derivative flat within ± over the window, % |
| GPB_Tol | $B$24 | Round trip: k and D recovered within ±, % |
| GPB_ModelK | $B$26 | Model permeability, mD |
| GPB_ModelS | $B$27 | Model mechanical skin, S |
| GPB_ModelD | $B$28 | Model rate-dependent skin coefficient, D, d/Mscf |
| GPB_C | $B$29 | Wellbore storage coefficient, C, bbl/psi |
| GPB_Inputs | $B$4:$B$29 | The reservoir, the gas and the well, the two rates and flow time, the shut-in pressures, the window and tolerances, and the synthetic model |
| GPB_TR | $B$32 | Reservoir temperature, absolute, °R |
| GPB_Ppc | $B$33 | Pseudo-critical pressure (Sutton), psia |
| GPB_Tpr | $B$34 | Pseudo-reduced temperature, T/Tpc (Sutton) |
| GPB_Zi | $B$35 | Z-factor at pi |
| GPB_Mui | $B$36 | Gas viscosity at pi, μi, cp |
| GPB_Cti | $B$37 | Total compressibility at pi, cti, 1/psi |
| GPB_McI | $B$38 | μi·cti, the pseudo-time's reference, cp/psi |
| GPB_mPi | $B$39 | Pseudo-pressure at pi, m(pi), psi²/cp |
| GPB_Scale | $B$40 | Model Δm per liquid-solution Δp, 1422·T/(141.2·μi) |
| GPB_S1 | $B$42 | Model apparent skin, test 1, S + D·q1 |
| GPB_S2 | $B$43 | Model apparent skin, test 2, S + D·q2 |
| GPB_PwfModel1 | $B$44 | Model flowing pressure at shut-in, test 1, psia |
| GPB_PwfModel2 | $B$45 | Model flowing pressure at shut-in, test 2, psia |
| GPB_PwfU1 | $B$46 | pwf at shut-in used, test 1, psia |
| GPB_PwfU2 | $B$47 | pwf at shut-in used, test 2, psia |
| GPB_mPwf1 | $B$49 | m(pwf), test 1, psi²/cp |
| GPB_McPwf1 | $B$50 | μg·ct at pwf, test 1, cp/psi |
| GPB_N1 | $B$51 | Points in the IARF window, test 1 |
| GPB_Flat1 | $B$52 | Derivative spread over the window, test 1, % |
| GPB_M1 | $B$53 | Semilog slope in m(p), test 1, psi²/cp/cycle |
| GPB_m1hr1 | $B$54 | Line's m(p) at Δta = 1 hr, test 1, psi²/cp |
| GPB_k1 | $B$55 | Permeability, k = 1637·q·T/(m·h), test 1, mD |
| GPB_Sa1 | $B$56 | Apparent skin, S′ = S + D·q1 |
| GPB_TaRatio1 | $B$57 | Pseudo-time over real time at the last point, test 1 |
| GPB_mPwf2 | $B$59 | m(pwf), test 2, psi²/cp |
| GPB_McPwf2 | $B$60 | μg·ct at pwf, test 2, cp/psi |
| GPB_N2 | $B$61 | Points in the IARF window, test 2 |
| GPB_Flat2 | $B$62 | Derivative spread over the window, test 2, % |
| GPB_M2 | $B$63 | Semilog slope in m(p), test 2, psi²/cp/cycle |
| GPB_m1hr2 | $B$64 | Line's m(p) at Δta = 1 hr, test 2, psi²/cp |
| GPB_k2 | $B$65 | Permeability, k = 1637·q·T/(m·h), test 2, mD |
| GPB_Sa2 | $B$66 | Apparent skin, S′ = S + D·q2 |
| GPB_TaRatio2 | $B$67 | Pseudo-time over real time at the last point, test 2 |
| GPB_k | $B$69 | Permeability, k (mean of the two), mD |
| GPB_kh | $B$70 | Permeability-thickness, kh, mD·ft |
| GPB_D | $B$71 | Rate-dependent skin coefficient, D = ΔS′/Δq, d/Mscf |
| GPB_S | $B$72 | Mechanical skin, S = S′1 − D·q1 |
| GPB_TurbShare | $B$73 | Turbulence's share of S′ at q2, % |
| GPB_kErr | $B$74 | k against the model, % |
| GPB_SErr | $B$75 | S against the model |
| GPB_DErr | $B$76 | D against the model, % |
| GPB_RateCheck | $B$77 | Rate check verdict |
| GPB_RateCheckNote | $C$77 | Rate check comment |
| GPB_WindowCheck | $B$78 | IARF window check verdict |
| GPB_WindowCheckNote | $C$78 | IARF window check comment |
| GPB_TurbCheck | $B$79 | Turbulence check verdict |
| GPB_TurbCheckNote | $C$79 | Turbulence check comment |
| GPB_TripCheck | $B$80 | Round trip on the synthetic data verdict |
| GPB_TripCheckNote | $C$80 | Round trip on the synthetic data comment |
| GPB_Results | $B$32:$B$80 | The gas at pi, the model at shut-in, each buildup's Horner line, k and S′, the mean k, D and S, the round trip and the checks |
| GPB_R0 | $B$85 | Rankine at 0 °F, °R |
| GPB_Steps | $B$86 | Trapezoid steps of each m(p) integral |
| GPB_K1422 | $B$87 | Gas pressure group, m(p) form |
| GPB_K1412 | $B$88 | Liquid pressure group |
| GPB_K1637 | $B$89 | Gas semilog permeability constant |
| GPB_Mega | $B$91 | Pseudo-pressure in one 10⁶ psi²/cp, psi²/cp |
| GPB_Eps | $B$90 | Slack on the window's ends, for rounding |
| GPB_MpTable | $D$4:$E$19 | Pressures from 0.3·pi to 1.2·pi and their m(p), which the model's spline reads backwards |
| GPB_PTab | $D$4:$D$19 | The m(p) table's pressures, psia |
| GPB_MTab | $E$4:$E$19 | The m(p) table's pseudo-pressures, psi²/cp |
| GPB_Rates1 | $A$96:$B$97 | Test 1's model: q1 from 0 to tp, then shut in |
| GPB_Rates2 | $D$96:$E$97 | Test 2's model: q2 from 0 to tp, then shut in |
| GPB_Lines | $A$102:$C$110 | Each buildup's Horner line as Δm(p), from a ratio of 1 to the data's largest |
| GPB_Curve | $A$114:$C$116 | The line S + D·q from q = 0, and the two buildups' apparent skins on it |
| GPB_Data1 | $A$122:$C$149 | Buildup 1: the model's pseudo-time grid, and Δt and pws (the model's until you paste a gauge's) |
| GPB_Analysis1 | $D$122:$K$149 | Buildup 1 per row: μg·ct at pws, pseudo-time, m(pws), Δm, the Horner ratio, te, the Bourdet derivative and the IARF window |
| GPB_Data2 | $A$154:$C$181 | Buildup 2: the model's pseudo-time grid, and Δt and pws (the model's until you paste a gauge's) |
| GPB_Analysis2 | $D$154:$K$181 | Buildup 2 per row: μg·ct at pws, pseudo-time, m(pws), Δm, the Horner ratio, te, the Bourdet derivative and the IARF window |

---

## Related Blueprints
- [Gas Well Deliverability](/blueprint/po.ipr.gas.deliverability.md)
- [Horner Buildup Analysis](/blueprint/po.pta.horner.pstar.md)
- [Buildup Boundary Signatures](/blueprint/po.pta.buildup.boundary.md)
- [Drill-Stem Test Analysis](/blueprint/po.pta.dst.sequence.md)
- [Injection Falloff and Step-Rate Test](/blueprint/po.pta.injection.falloff.md)
- [Gas Reservoir Production Forecast](/blueprint/po.mbe.gas.forecast.md)

