---
cid: po.bp.frac.dfit.gfunction
hub: frac
tags: [frac, DFIT, minifrac, G-function, closure-stress, net-pressure, fluid-efficiency, after-closure-analysis, pore-pressure, fracture-diagnostics]
facets: { discipline: completions, property: closure-stress, method-type: analytical }
title: DFIT G-Function Analysis
summary: "Where a DFIT's fracture closed and at what stress, with the net pressure, fluid efficiency and pore pressure from the falloff."
slug: po.frac.dfit.gfunction
type: worksheet
---

# DFIT G-Function Analysis

## Description

Where did the minifrac's fracture close and at what stress, how much net pressure held it open, how efficient was the fluid, and what is the pore pressure? You enter a diagnostic fracture injection test (DFIT): the injection time and rate, the fluid and depth, and the falloff's shut-in times and surface pressures. You read off the bottomhole ISIP, the closure picked on Nolte's G-function, the closure stress, the net pressure, the fluid efficiency and the fracture volume at shut-in, and the pore pressure from the after-closure line.

**Parameters:**
- **Injection and wellbore**: the injection time `DFIT_Tp`, the rate `DFIT_Q`, the leakoff exponent `DFIT_Alpha` (1 or 0.5), the fluid density in the hole `DFIT_RhoFluid` and the depth `DFIT_Tvd`
- **Closure pick**: the G window the tangent is fitted over (`DFIT_GLo`, `DFIT_GHi`), how far below it a point must fall to be closure `DFIT_Tol`, and your own closure G `DFIT_GcUser` (0 takes the pick)
- **After closure**: the largest FL fitted `DFIT_FLMax` and the normal pore-pressure gradient `DFIT_NormalGrad`
- **Data**: Δt since shut-in and the surface pressure, the region `DFIT_Data`

**How to use it:** Read the test the way a frac engineer does before the main treatment. Paste Δt since shut-in and the surface pressure over columns A and B, starting with the shut-in point, set tp and the rate, and trim the formulas to your rows. A downhole gauge's record goes in column B with the fluid density set to 0, so the column adds nothing. Smooth a noisy record before the derivative is read, set the tangent window past any early tortuosity or storage, and check the pick by eye on the G-function plot; your own closure G overrides the pick. The sheet adds the static column to the surface pressure, computes G, dP/dG and the superposition derivative G·dP/dG one element a cell, and picks closure by tangent deviation: a straight line through the origin is fitted to G·dP/dG over a window of early G, and closure is the first point that falls a set fraction below it. The pick is yours to override. After closure, a least-squares line of pressure against Nolte's linear-flow function FL gives the pore pressure at FL = 0, flagged against a normal gradient. A G-function plot and an after-closure plot draw both reads. The synthetic falloff is a stand-in for data.

**Method:** The bottomhole pressure is the surface pressure plus the static column, so the bottomhole ISIP is the surface ISIP + 0.052·ρ·TVD. With ΔtD = Δt/tp, Nolte's g = (4/3)·[(1 + ΔtD)^1.5 − ΔtD^1.5] for α = 1 and G = (4/π)·(g − 4/3); dP/dG is a central difference and G·dP/dG its product with G. While the fracture is open with normal leakoff the pressure falls on a straight line in G, so G·dP/dG lies on a line through the origin; its slope is the least-squares fit Σ G·(G·dP/dG)/Σ G² over the G window. Closure is the first point past the window's start whose G·dP/dG is more than the set fraction below that line. The closure time and stress at Gc are interpolated linearly in G between the points either side. The net pressure is the bottomhole ISIP − pc, and the fluid efficiency is η = Gc/(Gc + 4·g0/π), Gc/(Gc + 1.698) for α = 1; η times the volume injected is the fracture volume at shut-in. After closure, FL = (2/π)·asin(√(tc/t)), with t from the start of pumping and tc = tp + Δtc (Nolte 1997). In reservoir linear flow p = pr + mL·FL, so the least-squares line through the after-closure points with FL up to the largest FL fitted gives pr at FL = 0.

**Example:** The default is a minifrac ahead of the Fracture Design Screening (Unified Fracture Design) treatment, at the same 8,000 ft with 8.5 ppg fluid in the hole: 20 bbl pumped at 4 bbl/min for 5 min, shut in at 2,650 psi at surface, and read for a day. The falloff is synthetic. It falls on the normal-leakoff line from the screening sheet's 6,186 psi bottomhole ISIP to its 5,600 psi closure, 15 min after shut-in, and then decays towards a 3,600 psi (0.45 psi/ft) pore pressure, its first post-closure decline half the pre-closure rate.

The 3,536 psi column puts the ISIP at 6,186 psi at the perforations. Seven points from G = 0.21 to 1.41 fit a tangent of slope 191.36 psi, and the first point to fall more than 5 % below it is at Δt = 15 min, G = 3.062: G·dP/dG is 442 there against the line's 586, because its central difference already takes in the slower decline after closure. Closure is at 5,600 psi, 0.700 psi/ft, and the net pressure at shut-in is 586 psi, the screening sheet's. The efficiency is 3.062/(3.062 + 1.698) = 64.3 %, so 12.9 of the 20 bbl were still in the fracture at shut-in. Nine after-closure points have FL ≤ 0.2 (Δt from 250 min). Their line has a slope of 5,132 psi and an R² of 0.9985, and meets FL = 0 at 3,675 psi, 0.459 psi/ft: normally pressured, under the 0.465 psi/ft normal gradient. The intercept reads 75 psi (2 %) above the model's 3,600 psi, because a day's falloff hasn't reached pure linear flow; FL ≤ 0.1 (three points) reads 3,625 psi.

## Validity

The G-function's assumptions: a single planar fracture, Carter leakoff (flux ∝ 1/√(t − τ)), a constant injection rate and a fracture area that stops growing at shut-in. Pressure-dependent leakoff (a hump above the tangent), height recession or transverse storage (a belly below it) and tip extension (a rising G·dP/dG at a steeper line) each change the curve; the tangent pick then needs your judgement, which is what your own closure G is for. The tangent pick is late by up to one point, because the central difference at the first post-closure point mixes both slopes, so space the points closely around the expected closure. The after-closure function FL is Nolte's for linear flow from a fracture whose leakoff was Carter's; it reaches pore pressure only once true linear flow is established, which in tight rock can take days, and before that the intercept reads high. The sheet does not give radial after-closure flow (FR, giving kh) or the √t and log-log diagnostics. Spurt loss is left out of the efficiency.

Named alternatives: the DFIT fluid-efficiency function on its own takes a Gc read elsewhere, and the injection falloff and step-rate test sheet flags fracture closure on a water injector's derivative and gives the extension pressure.

## References

- Nolte, K.G. (1979). "Determination of Fracture Parameters from Fracturing Pressure Decline." SPE 8341.
- Nolte, K.G. (1986). "A General Analysis of Fracturing Pressure Decline With Application to Three Models." *SPE Formation Evaluation* 1(6), 571–583.
- Nolte, K.G. (1997). "Background for After-Closure Analysis of Fracture Calibration Tests." SPE 39407.
- Barree, R.D., Barree, V.L. and Craig, D.P. (2009). "Holistic Fracture Diagnostics: Consistent Interpretation of Prefrac Injection Tests Using Multiple Analysis Methods." *SPE Production & Operations* 24(3), 396–406.
- Economides, M.J. and Nolte, K.G. (eds.) (2000). *Reservoir Stimulation*, 3rd ed. Wiley, ch. 9 "Fracture Evaluation Using Pressure Diagnostics".

## Functions used

`PO.FRAC.Eval.ISIP`, `PO.FRAC.DFIT.GFunction`, `PO.FRAC.DFIT.Efficiency`

## Spreadsheet: FracDfitGFunction

|    | A                                                                                                                                                              | B                                                                                                                                                                                                                                                                                                                       | C                                                                                                                                                                                                                                                                                                                                                                                                | D                                                                                                                         | E                                                                                                                            | F                                                                                                                             | G             | H                                               | I                                                     | J                                          | K                      |
|----|----------------------------------------------------------------------------------------------------------------------------------------------------------------|-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|---------------------------------------------------------------------------------------------------------------------------|------------------------------------------------------------------------------------------------------------------------------|-------------------------------------------------------------------------------------------------------------------------------|---------------|-------------------------------------------------|-------------------------------------------------------|--------------------------------------------|------------------------|
| 1  | DFIT G-Function Analysis                                                                                                                                       |                                                                                                                                                                                                                                                                                                                         | Petroleum Office                                                                                                                                                                                                                                                                                                                                                                                 |                                                                                                                           |                                                                                                                              |                                                                                                                               |               |                                                 |                                                       |                                            |                        |
| 2  | Blue cells on yellow are inputs. Paste the falloff's Δt and surface pressure over columns A and B; closure, net pressure, efficiency and pore pressure follow. |                                                                                                                                                                                                                                                                                                                         |                                                                                                                                                                                                                                                                                                                                                                                                  |                                                                                                                           |                                                                                                                              |                                                                                                                               |               |                                                 |                                                       |                                            |                        |
| 3  | Injection and Wellbore                                                                                                                                         |                                                                                                                                                                                                                                                                                                                         |                                                                                                                                                                                                                                                                                                                                                                                                  |                                                                                                                           |                                                                                                                              |                                                                                                                               |               |                                                 |                                                       |                                            |                        |
| 4  | Injection (pumping) time, tp                                                                                                                                   | 5                                                                                                                                                                                                                                                                                                                       | min                                                                                                                                                                                                                                                                                                                                                                                              |                                                                                                                           |                                                                                                                              |                                                                                                                               |               |                                                 |                                                       |                                            |                        |
| 5  | Injection rate                                                                                                                                                 | 4                                                                                                                                                                                                                                                                                                                       | bbl/min                                                                                                                                                                                                                                                                                                                                                                                          |                                                                                                                           |                                                                                                                              |                                                                                                                               |               |                                                 |                                                       |                                            |                        |
| 6  | Leakoff exponent α (1 or 0.5)                                                                                                                                  | 1                                                                                                                                                                                                                                                                                                                       | —                                                                                                                                                                                                                                                                                                                                                                                                |                                                                                                                           |                                                                                                                              |                                                                                                                               |               |                                                 |                                                       |                                            |                        |
| 7  | Fluid density in the wellbore                                                                                                                                  | 8.5                                                                                                                                                                                                                                                                                                                     | ppg                                                                                                                                                                                                                                                                                                                                                                                              |                                                                                                                           |                                                                                                                              |                                                                                                                               |               |                                                 |                                                       |                                            |                        |
| 8  | True vertical depth of the perforations                                                                                                                        | 8000                                                                                                                                                                                                                                                                                                                    | ft                                                                                                                                                                                                                                                                                                                                                                                               |                                                                                                                           |                                                                                                                              |                                                                                                                               |               |                                                 |                                                       |                                            |                        |
| 9  | Closure Pick on G·dP/dG                                                                                                                                        |                                                                                                                                                                                                                                                                                                                         |                                                                                                                                                                                                                                                                                                                                                                                                  |                                                                                                                           |                                                                                                                              |                                                                                                                               |               |                                                 |                                                       |                                            |                        |
| 10 | Tangent fitted from G =                                                                                                                                        | 0.2                                                                                                                                                                                                                                                                                                                     | —                                                                                                                                                                                                                                                                                                                                                                                                |                                                                                                                           |                                                                                                                              |                                                                                                                               |               |                                                 |                                                       |                                            |                        |
| 11 | Tangent fitted to G =                                                                                                                                          | 1.5                                                                                                                                                                                                                                                                                                                     | —                                                                                                                                                                                                                                                                                                                                                                                                |                                                                                                                           |                                                                                                                              |                                                                                                                               |               |                                                 |                                                       |                                            |                        |
| 12 | Closure where G·dP/dG falls this far below the line                                                                                                            | 0.05                                                                                                                                                                                                                                                                                                                    | %                                                                                                                                                                                                                                                                                                                                                                                                |                                                                                                                           |                                                                                                                              |                                                                                                                               |               |                                                 |                                                       |                                            |                        |
| 13 | Closure G you pick (0 takes the tangent pick)                                                                                                                  | 0                                                                                                                                                                                                                                                                                                                       | —                                                                                                                                                                                                                                                                                                                                                                                                |                                                                                                                           |                                                                                                                              |                                                                                                                               |               |                                                 |                                                       |                                            |                        |
| 14 | After-Closure Linear Flow                                                                                                                                      |                                                                                                                                                                                                                                                                                                                         |                                                                                                                                                                                                                                                                                                                                                                                                  |                                                                                                                           |                                                                                                                              |                                                                                                                               |               |                                                 |                                                       |                                            |                        |
| 15 | Points fitted where FL is at most                                                                                                                              | 0.2                                                                                                                                                                                                                                                                                                                     | —                                                                                                                                                                                                                                                                                                                                                                                                |                                                                                                                           |                                                                                                                              |                                                                                                                               |               |                                                 |                                                       |                                            |                        |
| 16 | Normal pore-pressure gradient                                                                                                                                  | 0.465                                                                                                                                                                                                                                                                                                                   | psi/ft                                                                                                                                                                                                                                                                                                                                                                                           |                                                                                                                           |                                                                                                                              |                                                                                                                               |               |                                                 |                                                       |                                            |                        |
| 18 | Shut-in                                                                                                                                                        |                                                                                                                                                                                                                                                                                                                         |                                                                                                                                                                                                                                                                                                                                                                                                  |                                                                                                                           |                                                                                                                              |                                                                                                                               |               |                                                 |                                                       |                                            |                        |
| 19 | ISIP read at surface, the first point                                                                                                                          | =B54                                                                                                                                                                                                                                                                                                                    | psi                                                                                                                                                                                                                                                                                                                                                                                              |                                                                                                                           |                                                                                                                              |                                                                                                                               |               |                                                 |                                                       |                                            |                        |
| 20 | Bottomhole ISIP                                                                                                                                                | =PO.FRAC.Eval.ISIP(DFIT_IsipSurf,DFIT_RhoFluid,DFIT_Tvd,0,"ISIP")                                                                                                                                                                                                                                                       | psi                                                                                                                                                                                                                                                                                                                                                                                              |                                                                                                                           |                                                                                                                              |                                                                                                                               |               |                                                 |                                                       |                                            |                        |
| 21 | Static column of the fluid, added to every point                                                                                                               | =DFIT_Isip-DFIT_IsipSurf                                                                                                                                                                                                                                                                                                | psi                                                                                                                                                                                                                                                                                                                                                                                              |                                                                                                                           |                                                                                                                              |                                                                                                                               |               |                                                 |                                                       |                                            |                        |
| 22 | Volume injected                                                                                                                                                | =DFIT_Q*DFIT_Tp                                                                                                                                                                                                                                                                                                         | bbl                                                                                                                                                                                                                                                                                                                                                                                              |                                                                                                                           |                                                                                                                              |                                                                                                                               |               |                                                 |                                                       |                                            |                        |
| 23 | Normal-Leakoff Line and the Closure Pick                                                                                                                       |                                                                                                                                                                                                                                                                                                                         |                                                                                                                                                                                                                                                                                                                                                                                                  |                                                                                                                           |                                                                                                                              |                                                                                                                               |               |                                                 |                                                       |                                            |                        |
| 24 | Points the tangent is fitted to                                                                                                                                | =SUMPRODUCT(($D$54:$D$96>=DFIT_GLo)*($D$54:$D$96<=DFIT_GHi))                                                                                                                                                                                                                                                            | —                                                                                                                                                                                                                                                                                                                                                                                                |                                                                                                                           |                                                                                                                              |                                                                                                                               |               |                                                 |                                                       |                                            |                        |
| 25 | Tangent's slope, dP/dG of normal leakoff                                                                                                                       | =SUMPRODUCT(($D$54:$D$96>=DFIT_GLo)*($D$54:$D$96<=DFIT_GHi)*$D$54:$D$96*$F$54:$F$96)/SUMPRODUCT(($D$54:$D$96>=DFIT_GLo)*($D$54:$D$96<=DFIT_GHi)*$D$54:$D$96^2)                                                                                                                                                          | psi                                                                                                                                                                                                                                                                                                                                                                                              |                                                                                                                           |                                                                                                                              |                                                                                                                               |               |                                                 |                                                       |                                            |                        |
| 26 | G where G·dP/dG first leaves the tangent (0 none)                                                                                                              | =IF(SUM($H$54:$H$96)=0,0,MINIFS($D$54:$D$96,$H$54:$H$96,1))                                                                                                                                                                                                                                                             | —                                                                                                                                                                                                                                                                                                                                                                                                |                                                                                                                           |                                                                                                                              |                                                                                                                               |               |                                                 |                                                       |                                            |                        |
| 27 | G at closure, Gc (the pick or yours)                                                                                                                           | =IF(DFIT_GcUser>0,DFIT_GcUser,DFIT_GcPick)                                                                                                                                                                                                                                                                              | —                                                                                                                                                                                                                                                                                                                                                                                                |                                                                                                                           |                                                                                                                              |                                                                                                                               |               |                                                 |                                                       |                                            |                        |
| 28 | Shut-in time at closure, Δtc                                                                                                                                   | =LET(i,MIN(MATCH(DFIT_Gc,$D$54:$D$96,1),ROWS($D$54:$D$96)-1),glow,INDEX($D$54:$D$96,i),ghigh,INDEX($D$54:$D$96,i+1),ylow,INDEX($A$54:$A$96,i),yhigh,INDEX($A$54:$A$96,i+1),ylow+(yhigh-ylow)*(DFIT_Gc-glow)/(ghigh-glow))                                                                                               | min                                                                                                                                                                                                                                                                                                                                                                                              |                                                                                                                           |                                                                                                                              |                                                                                                                               |               |                                                 |                                                       |                                            |                        |
| 29 | Time at closure from the start of pumping, tc                                                                                                                  | =DFIT_Tp+DFIT_DtC                                                                                                                                                                                                                                                                                                       | min                                                                                                                                                                                                                                                                                                                                                                                              |                                                                                                                           |                                                                                                                              |                                                                                                                               |               |                                                 |                                                       |                                            |                        |
| 30 | Closure stress, the pressure at Gc                                                                                                                             | =LET(i,MIN(MATCH(DFIT_Gc,$D$54:$D$96,1),ROWS($D$54:$D$96)-1),glow,INDEX($D$54:$D$96,i),ghigh,INDEX($D$54:$D$96,i+1),ylow,INDEX($C$54:$C$96,i),yhigh,INDEX($C$54:$C$96,i+1),ylow+(yhigh-ylow)*(DFIT_Gc-glow)/(ghigh-glow))                                                                                               | psi                                                                                                                                                                                                                                                                                                                                                                                              |                                                                                                                           |                                                                                                                              |                                                                                                                               |               |                                                 |                                                       |                                            |                        |
| 31 | Closure stress gradient                                                                                                                                        | =DFIT_Pc/DFIT_Tvd                                                                                                                                                                                                                                                                                                       | psi/ft                                                                                                                                                                                                                                                                                                                                                                                           |                                                                                                                           |                                                                                                                              |                                                                                                                               |               |                                                 |                                                       |                                            |                        |
| 32 | Net pressure at shut-in, ISIP − closure                                                                                                                        | =DFIT_Isip-DFIT_Pc                                                                                                                                                                                                                                                                                                      | psi                                                                                                                                                                                                                                                                                                                                                                                              |                                                                                                                           |                                                                                                                              |                                                                                                                               |               |                                                 |                                                       |                                            |                        |
| 33 | Fracture (ISIP) gradient                                                                                                                                       | =DFIT_Isip/DFIT_Tvd                                                                                                                                                                                                                                                                                                     | psi/ft                                                                                                                                                                                                                                                                                                                                                                                           |                                                                                                                           |                                                                                                                              |                                                                                                                               |               |                                                 |                                                       |                                            |                        |
| 34 | Fluid efficiency, η                                                                                                                                            | =PO.FRAC.DFIT.Efficiency(DFIT_Gc,DFIT_Alpha)                                                                                                                                                                                                                                                                            | %                                                                                                                                                                                                                                                                                                                                                                                                |                                                                                                                           |                                                                                                                              |                                                                                                                               |               |                                                 |                                                       |                                            |                        |
| 35 | Fracture volume at shut-in, η·V                                                                                                                                | =DFIT_Eta*DFIT_Vinj                                                                                                                                                                                                                                                                                                     | bbl                                                                                                                                                                                                                                                                                                                                                                                              |                                                                                                                           |                                                                                                                              |                                                                                                                               |               |                                                 |                                                       |                                            |                        |
| 36 | After-Closure Linear Flow (Nolte FL)                                                                                                                           |                                                                                                                                                                                                                                                                                                                         |                                                                                                                                                                                                                                                                                                                                                                                                  |                                                                                                                           |                                                                                                                              |                                                                                                                               |               |                                                 |                                                       |                                            |                        |
| 37 | Points in the linear-flow fit                                                                                                                                  | =SUM($J$54:$J$96)                                                                                                                                                                                                                                                                                                       | —                                                                                                                                                                                                                                                                                                                                                                                                |                                                                                                                           |                                                                                                                              |                                                                                                                               |               |                                                 |                                                       |                                            |                        |
| 38 | Slope of pressure on FL                                                                                                                                        | =LET(nn,DFIT_NAca,sumx,SUMPRODUCT($J$54:$J$96,$I$54:$I$96),sumy,SUMPRODUCT($J$54:$J$96,$C$54:$C$96),sumxy,SUMPRODUCT($J$54:$J$96,$I$54:$I$96,$C$54:$C$96),sumxx,SUMPRODUCT($J$54:$J$96,$I$54:$I$96,$I$54:$I$96),(nn*sumxy-sumx*sumy)/(nn*sumxx-sumx^2))                                                                 | psi                                                                                                                                                                                                                                                                                                                                                                                              |                                                                                                                           |                                                                                                                              |                                                                                                                               |               |                                                 |                                                       |                                            |                        |
| 39 | Pore pressure, the line at FL = 0                                                                                                                              | =(SUMPRODUCT($J$54:$J$96,$C$54:$C$96)-DFIT_MAca*SUMPRODUCT($J$54:$J$96,$I$54:$I$96))/DFIT_NAca                                                                                                                                                                                                                          | psi                                                                                                                                                                                                                                                                                                                                                                                              |                                                                                                                           |                                                                                                                              |                                                                                                                               |               |                                                 |                                                       |                                            |                        |
| 40 | Pore-pressure gradient                                                                                                                                         | =DFIT_Pr/DFIT_Tvd                                                                                                                                                                                                                                                                                                       | psi/ft                                                                                                                                                                                                                                                                                                                                                                                           |                                                                                                                           |                                                                                                                              |                                                                                                                               |               |                                                 |                                                       |                                            |                        |
| 41 | R² of the linear-flow line                                                                                                                                     | =LET(nn,DFIT_NAca,sumx,SUMPRODUCT($J$54:$J$96,$I$54:$I$96),sumy,SUMPRODUCT($J$54:$J$96,$C$54:$C$96),sumxy,SUMPRODUCT($J$54:$J$96,$I$54:$I$96,$C$54:$C$96),sumxx,SUMPRODUCT($J$54:$J$96,$I$54:$I$96,$I$54:$I$96),(nn*sumxy-sumx*sumy)^2/((nn*sumxx-sumx^2)*(nn*SUMPRODUCT($J$54:$J$96,$C$54:$C$96,$C$54:$C$96)-sumy^2))) | —                                                                                                                                                                                                                                                                                                                                                                                                |                                                                                                                           |                                                                                                                              |                                                                                                                               |               |                                                 |                                                       |                                            |                        |
| 42 | Closure check                                                                                                                                                  | =IF(AND(DFIT_GcUser<=0,DFIT_GcPick=0),"FAIL",IF(DFIT_GcUser>0,"WARN","PASS"))                                                                                                                                                                                                                                           | =IF(AND(DFIT_GcUser<=0,DFIT_GcPick=0),"G·dP/dG never leaves the tangent; the fracture hadn't closed by the last point",IF(DFIT_GcUser>0,"your closure at G "&FIXED(DFIT_Gc,2)&" ("&FIXED(DFIT_Pc,0)&" psi) replaces the tangent pick at G "&FIXED(DFIT_GcPick,2),"closure at G "&FIXED(DFIT_Gc,2)&", Δt "&FIXED(DFIT_DtC,1)&" min, "&FIXED(DFIT_Pc,0)&" psi ("&FIXED(DFIT_PcGrad,2)&" psi/ft)")) |                                                                                                                           |                                                                                                                              |                                                                                                                               |               |                                                 |                                                       |                                            |                        |
| 43 | Pore-pressure flag                                                                                                                                             | =IF(DFIT_NAca<DFIT_MinN,"FAIL",IF(DFIT_PrGrad>DFIT_NormalGrad,"WARN","PASS"))                                                                                                                                                                                                                                           | =IF(DFIT_NAca<DFIT_MinN,"fewer than "&DFIT_MinN&" after-closure points with FL at most "&FIXED(DFIT_FLMax,2)&"; extend the falloff",IF(DFIT_PrGrad>DFIT_NormalGrad,"overpressured; the linear-flow line gives "&FIXED(DFIT_Pr,0)&" psi, above the normal gradient","normally pressured; the linear-flow line gives "&FIXED(DFIT_Pr,0)&" psi over "&DFIT_NAca&" points"))                         |                                                                                                                           |                                                                                                                              |                                                                                                                               |               |                                                 |                                                       |                                            |                        |
| 46 | Calculation Constants                                                                                                                                          |                                                                                                                                                                                                                                                                                                                         |                                                                                                                                                                                                                                                                                                                                                                                                  |                                                                                                                           |                                                                                                                              |                                                                                                                               |               |                                                 |                                                       |                                            |                        |
| 47 | Fewest points a line is fitted to                                                                                                                              | 3                                                                                                                                                                                                                                                                                                                       | —                                                                                                                                                                                                                                                                                                                                                                                                |                                                                                                                           |                                                                                                                              |                                                                                                                               |               |                                                 |                                                       |                                            |                        |
| 49 | Falloff Data and the G-Function of Every Point                                                                                                                 |                                                                                                                                                                                                                                                                                                                         |                                                                                                                                                                                                                                                                                                                                                                                                  |                                                                                                                           |                                                                                                                              |                                                                                                                               |               |                                                 |                                                       |                                            |                        |
| 50 | How to use it: paste Δt since shut-in and the surface pressure over columns A and B from the shut-in point on, set tp, and trim the formulas to your rows.     |                                                                                                                                                                                                                                                                                                                         |                                                                                                                                                                                                                                                                                                                                                                                                  |                                                                                                                           |                                                                                                                              |                                                                                                                               |               |                                                 |                                                       |                                            |                        |
| 51 | The data are synthetic: a 5 min injection that closes 15 min after shut-in at the screening sheet's 5,600 psi, then decays to a 3,600 psi pore pressure.       |                                                                                                                                                                                                                                                                                                                         |                                                                                                                                                                                                                                                                                                                                                                                                  |                                                                                                                           |                                                                                                                              |                                                                                                                               |               |                                                 |                                                       |                                            |                        |
| 52 | G, dP/dG and G·dP/dG are PO.FRAC.DFIT.GFunction's columns; off is 1 below the tangent; FL is Nolte's linear-flow function after closure.                       |                                                                                                                                                                                                                                                                                                                         |                                                                                                                                                                                                                                                                                                                                                                                                  |                                                                                                                           |                                                                                                                              |                                                                                                                               |               |                                                 |                                                       |                                            |                        |
| 53 | Δt (min)                                                                                                                                                       | Surface p (psi)                                                                                                                                                                                                                                                                                                         | Bottomhole p (psi)                                                                                                                                                                                                                                                                                                                                                                               | G                                                                                                                         | dP/dG (psi)                                                                                                                  | G·dP/dG (psi)                                                                                                                 | Tangent (psi) | Off                                             | FL                                                    | In fit                                     | FL line (psi)          |
| 54 | 0                                                                                                                                                              | 2650                                                                                                                                                                                                                                                                                                                    | =B54+DFIT_Hydro                                                                                                                                                                                                                                                                                                                                                                                  | =CHOOSEROWS(LET(BhPressure_psi,$C$54:$C$96,PO.FRAC.DFIT.GFunction($A$54:$A$96,DFIT_Tp,BhPressure_psi,DFIT_Alpha,"G")),1)  | =CHOOSEROWS(LET(BhPressure_psi,$C$54:$C$96,PO.FRAC.DFIT.GFunction($A$54:$A$96,DFIT_Tp,BhPressure_psi,DFIT_Alpha,"dPdG")),1)  | =CHOOSEROWS(LET(BhPressure_psi,$C$54:$C$96,PO.FRAC.DFIT.GFunction($A$54:$A$96,DFIT_Tp,BhPressure_psi,DFIT_Alpha,"GdPdG")),1)  | =DFIT_M*D54   | =IF(AND(D54>DFIT_GLo,F54<(1-DFIT_Tol)*G54),1,0) | =2/PI()*ASIN(SQRT(MIN(1,DFIT_TcTotal/(DFIT_Tp+A54)))) | =IF(AND(A54>DFIT_DtC,I54<=DFIT_FLMax),1,0) | =DFIT_Pr+DFIT_MAca*I54 |
| 55 | 0.25                                                                                                                                                           | 2628.97                                                                                                                                                                                                                                                                                                                 | =B55+DFIT_Hydro                                                                                                                                                                                                                                                                                                                                                                                  | =CHOOSEROWS(LET(BhPressure_psi,$C$54:$C$96,PO.FRAC.DFIT.GFunction($A$54:$A$96,DFIT_Tp,BhPressure_psi,DFIT_Alpha,"G")),2)  | =CHOOSEROWS(LET(BhPressure_psi,$C$54:$C$96,PO.FRAC.DFIT.GFunction($A$54:$A$96,DFIT_Tp,BhPressure_psi,DFIT_Alpha,"dPdG")),2)  | =CHOOSEROWS(LET(BhPressure_psi,$C$54:$C$96,PO.FRAC.DFIT.GFunction($A$54:$A$96,DFIT_Tp,BhPressure_psi,DFIT_Alpha,"GdPdG")),2)  | =DFIT_M*D55   | =IF(AND(D55>DFIT_GLo,F55<(1-DFIT_Tol)*G55),1,0) | =2/PI()*ASIN(SQRT(MIN(1,DFIT_TcTotal/(DFIT_Tp+A55)))) | =IF(AND(A55>DFIT_DtC,I55<=DFIT_FLMax),1,0) | =DFIT_Pr+DFIT_MAca*I55 |
| 56 | 0.5                                                                                                                                                            | 2610.35                                                                                                                                                                                                                                                                                                                 | =B56+DFIT_Hydro                                                                                                                                                                                                                                                                                                                                                                                  | =CHOOSEROWS(LET(BhPressure_psi,$C$54:$C$96,PO.FRAC.DFIT.GFunction($A$54:$A$96,DFIT_Tp,BhPressure_psi,DFIT_Alpha,"G")),3)  | =CHOOSEROWS(LET(BhPressure_psi,$C$54:$C$96,PO.FRAC.DFIT.GFunction($A$54:$A$96,DFIT_Tp,BhPressure_psi,DFIT_Alpha,"dPdG")),3)  | =CHOOSEROWS(LET(BhPressure_psi,$C$54:$C$96,PO.FRAC.DFIT.GFunction($A$54:$A$96,DFIT_Tp,BhPressure_psi,DFIT_Alpha,"GdPdG")),3)  | =DFIT_M*D56   | =IF(AND(D56>DFIT_GLo,F56<(1-DFIT_Tol)*G56),1,0) | =2/PI()*ASIN(SQRT(MIN(1,DFIT_TcTotal/(DFIT_Tp+A56)))) | =IF(AND(A56>DFIT_DtC,I56<=DFIT_FLMax),1,0) | =DFIT_Pr+DFIT_MAca*I56 |
| 57 | 1                                                                                                                                                              | 2576.88                                                                                                                                                                                                                                                                                                                 | =B57+DFIT_Hydro                                                                                                                                                                                                                                                                                                                                                                                  | =CHOOSEROWS(LET(BhPressure_psi,$C$54:$C$96,PO.FRAC.DFIT.GFunction($A$54:$A$96,DFIT_Tp,BhPressure_psi,DFIT_Alpha,"G")),4)  | =CHOOSEROWS(LET(BhPressure_psi,$C$54:$C$96,PO.FRAC.DFIT.GFunction($A$54:$A$96,DFIT_Tp,BhPressure_psi,DFIT_Alpha,"dPdG")),4)  | =CHOOSEROWS(LET(BhPressure_psi,$C$54:$C$96,PO.FRAC.DFIT.GFunction($A$54:$A$96,DFIT_Tp,BhPressure_psi,DFIT_Alpha,"GdPdG")),4)  | =DFIT_M*D57   | =IF(AND(D57>DFIT_GLo,F57<(1-DFIT_Tol)*G57),1,0) | =2/PI()*ASIN(SQRT(MIN(1,DFIT_TcTotal/(DFIT_Tp+A57)))) | =IF(AND(A57>DFIT_DtC,I57<=DFIT_FLMax),1,0) | =DFIT_Pr+DFIT_MAca*I57 |
| 58 | 1.5                                                                                                                                                            | 2546.72                                                                                                                                                                                                                                                                                                                 | =B58+DFIT_Hydro                                                                                                                                                                                                                                                                                                                                                                                  | =CHOOSEROWS(LET(BhPressure_psi,$C$54:$C$96,PO.FRAC.DFIT.GFunction($A$54:$A$96,DFIT_Tp,BhPressure_psi,DFIT_Alpha,"G")),5)  | =CHOOSEROWS(LET(BhPressure_psi,$C$54:$C$96,PO.FRAC.DFIT.GFunction($A$54:$A$96,DFIT_Tp,BhPressure_psi,DFIT_Alpha,"dPdG")),5)  | =CHOOSEROWS(LET(BhPressure_psi,$C$54:$C$96,PO.FRAC.DFIT.GFunction($A$54:$A$96,DFIT_Tp,BhPressure_psi,DFIT_Alpha,"GdPdG")),5)  | =DFIT_M*D58   | =IF(AND(D58>DFIT_GLo,F58<(1-DFIT_Tol)*G58),1,0) | =2/PI()*ASIN(SQRT(MIN(1,DFIT_TcTotal/(DFIT_Tp+A58)))) | =IF(AND(A58>DFIT_DtC,I58<=DFIT_FLMax),1,0) | =DFIT_Pr+DFIT_MAca*I58 |
| 59 | 2                                                                                                                                                              | 2518.91                                                                                                                                                                                                                                                                                                                 | =B59+DFIT_Hydro                                                                                                                                                                                                                                                                                                                                                                                  | =CHOOSEROWS(LET(BhPressure_psi,$C$54:$C$96,PO.FRAC.DFIT.GFunction($A$54:$A$96,DFIT_Tp,BhPressure_psi,DFIT_Alpha,"G")),6)  | =CHOOSEROWS(LET(BhPressure_psi,$C$54:$C$96,PO.FRAC.DFIT.GFunction($A$54:$A$96,DFIT_Tp,BhPressure_psi,DFIT_Alpha,"dPdG")),6)  | =CHOOSEROWS(LET(BhPressure_psi,$C$54:$C$96,PO.FRAC.DFIT.GFunction($A$54:$A$96,DFIT_Tp,BhPressure_psi,DFIT_Alpha,"GdPdG")),6)  | =DFIT_M*D59   | =IF(AND(D59>DFIT_GLo,F59<(1-DFIT_Tol)*G59),1,0) | =2/PI()*ASIN(SQRT(MIN(1,DFIT_TcTotal/(DFIT_Tp+A59)))) | =IF(AND(A59>DFIT_DtC,I59<=DFIT_FLMax),1,0) | =DFIT_Pr+DFIT_MAca*I59 |
| 60 | 3                                                                                                                                                              | 2468.37                                                                                                                                                                                                                                                                                                                 | =B60+DFIT_Hydro                                                                                                                                                                                                                                                                                                                                                                                  | =CHOOSEROWS(LET(BhPressure_psi,$C$54:$C$96,PO.FRAC.DFIT.GFunction($A$54:$A$96,DFIT_Tp,BhPressure_psi,DFIT_Alpha,"G")),7)  | =CHOOSEROWS(LET(BhPressure_psi,$C$54:$C$96,PO.FRAC.DFIT.GFunction($A$54:$A$96,DFIT_Tp,BhPressure_psi,DFIT_Alpha,"dPdG")),7)  | =CHOOSEROWS(LET(BhPressure_psi,$C$54:$C$96,PO.FRAC.DFIT.GFunction($A$54:$A$96,DFIT_Tp,BhPressure_psi,DFIT_Alpha,"GdPdG")),7)  | =DFIT_M*D60   | =IF(AND(D60>DFIT_GLo,F60<(1-DFIT_Tol)*G60),1,0) | =2/PI()*ASIN(SQRT(MIN(1,DFIT_TcTotal/(DFIT_Tp+A60)))) | =IF(AND(A60>DFIT_DtC,I60<=DFIT_FLMax),1,0) | =DFIT_Pr+DFIT_MAca*I60 |
| 61 | 4                                                                                                                                                              | 2422.79                                                                                                                                                                                                                                                                                                                 | =B61+DFIT_Hydro                                                                                                                                                                                                                                                                                                                                                                                  | =CHOOSEROWS(LET(BhPressure_psi,$C$54:$C$96,PO.FRAC.DFIT.GFunction($A$54:$A$96,DFIT_Tp,BhPressure_psi,DFIT_Alpha,"G")),8)  | =CHOOSEROWS(LET(BhPressure_psi,$C$54:$C$96,PO.FRAC.DFIT.GFunction($A$54:$A$96,DFIT_Tp,BhPressure_psi,DFIT_Alpha,"dPdG")),8)  | =CHOOSEROWS(LET(BhPressure_psi,$C$54:$C$96,PO.FRAC.DFIT.GFunction($A$54:$A$96,DFIT_Tp,BhPressure_psi,DFIT_Alpha,"GdPdG")),8)  | =DFIT_M*D61   | =IF(AND(D61>DFIT_GLo,F61<(1-DFIT_Tol)*G61),1,0) | =2/PI()*ASIN(SQRT(MIN(1,DFIT_TcTotal/(DFIT_Tp+A61)))) | =IF(AND(A61>DFIT_DtC,I61<=DFIT_FLMax),1,0) | =DFIT_Pr+DFIT_MAca*I61 |
| 62 | 5                                                                                                                                                              | 2380.88                                                                                                                                                                                                                                                                                                                 | =B62+DFIT_Hydro                                                                                                                                                                                                                                                                                                                                                                                  | =CHOOSEROWS(LET(BhPressure_psi,$C$54:$C$96,PO.FRAC.DFIT.GFunction($A$54:$A$96,DFIT_Tp,BhPressure_psi,DFIT_Alpha,"G")),9)  | =CHOOSEROWS(LET(BhPressure_psi,$C$54:$C$96,PO.FRAC.DFIT.GFunction($A$54:$A$96,DFIT_Tp,BhPressure_psi,DFIT_Alpha,"dPdG")),9)  | =CHOOSEROWS(LET(BhPressure_psi,$C$54:$C$96,PO.FRAC.DFIT.GFunction($A$54:$A$96,DFIT_Tp,BhPressure_psi,DFIT_Alpha,"GdPdG")),9)  | =DFIT_M*D62   | =IF(AND(D62>DFIT_GLo,F62<(1-DFIT_Tol)*G62),1,0) | =2/PI()*ASIN(SQRT(MIN(1,DFIT_TcTotal/(DFIT_Tp+A62)))) | =IF(AND(A62>DFIT_DtC,I62<=DFIT_FLMax),1,0) | =DFIT_Pr+DFIT_MAca*I62 |
| 63 | 6                                                                                                                                                              | 2341.84                                                                                                                                                                                                                                                                                                                 | =B63+DFIT_Hydro                                                                                                                                                                                                                                                                                                                                                                                  | =CHOOSEROWS(LET(BhPressure_psi,$C$54:$C$96,PO.FRAC.DFIT.GFunction($A$54:$A$96,DFIT_Tp,BhPressure_psi,DFIT_Alpha,"G")),10) | =CHOOSEROWS(LET(BhPressure_psi,$C$54:$C$96,PO.FRAC.DFIT.GFunction($A$54:$A$96,DFIT_Tp,BhPressure_psi,DFIT_Alpha,"dPdG")),10) | =CHOOSEROWS(LET(BhPressure_psi,$C$54:$C$96,PO.FRAC.DFIT.GFunction($A$54:$A$96,DFIT_Tp,BhPressure_psi,DFIT_Alpha,"GdPdG")),10) | =DFIT_M*D63   | =IF(AND(D63>DFIT_GLo,F63<(1-DFIT_Tol)*G63),1,0) | =2/PI()*ASIN(SQRT(MIN(1,DFIT_TcTotal/(DFIT_Tp+A63)))) | =IF(AND(A63>DFIT_DtC,I63<=DFIT_FLMax),1,0) | =DFIT_Pr+DFIT_MAca*I63 |
| 64 | 7                                                                                                                                                              | 2305.14                                                                                                                                                                                                                                                                                                                 | =B64+DFIT_Hydro                                                                                                                                                                                                                                                                                                                                                                                  | =CHOOSEROWS(LET(BhPressure_psi,$C$54:$C$96,PO.FRAC.DFIT.GFunction($A$54:$A$96,DFIT_Tp,BhPressure_psi,DFIT_Alpha,"G")),11) | =CHOOSEROWS(LET(BhPressure_psi,$C$54:$C$96,PO.FRAC.DFIT.GFunction($A$54:$A$96,DFIT_Tp,BhPressure_psi,DFIT_Alpha,"dPdG")),11) | =CHOOSEROWS(LET(BhPressure_psi,$C$54:$C$96,PO.FRAC.DFIT.GFunction($A$54:$A$96,DFIT_Tp,BhPressure_psi,DFIT_Alpha,"GdPdG")),11) | =DFIT_M*D64   | =IF(AND(D64>DFIT_GLo,F64<(1-DFIT_Tol)*G64),1,0) | =2/PI()*ASIN(SQRT(MIN(1,DFIT_TcTotal/(DFIT_Tp+A64)))) | =IF(AND(A64>DFIT_DtC,I64<=DFIT_FLMax),1,0) | =DFIT_Pr+DFIT_MAca*I64 |
| 65 | 8                                                                                                                                                              | 2270.39                                                                                                                                                                                                                                                                                                                 | =B65+DFIT_Hydro                                                                                                                                                                                                                                                                                                                                                                                  | =CHOOSEROWS(LET(BhPressure_psi,$C$54:$C$96,PO.FRAC.DFIT.GFunction($A$54:$A$96,DFIT_Tp,BhPressure_psi,DFIT_Alpha,"G")),12) | =CHOOSEROWS(LET(BhPressure_psi,$C$54:$C$96,PO.FRAC.DFIT.GFunction($A$54:$A$96,DFIT_Tp,BhPressure_psi,DFIT_Alpha,"dPdG")),12) | =CHOOSEROWS(LET(BhPressure_psi,$C$54:$C$96,PO.FRAC.DFIT.GFunction($A$54:$A$96,DFIT_Tp,BhPressure_psi,DFIT_Alpha,"GdPdG")),12) | =DFIT_M*D65   | =IF(AND(D65>DFIT_GLo,F65<(1-DFIT_Tol)*G65),1,0) | =2/PI()*ASIN(SQRT(MIN(1,DFIT_TcTotal/(DFIT_Tp+A65)))) | =IF(AND(A65>DFIT_DtC,I65<=DFIT_FLMax),1,0) | =DFIT_Pr+DFIT_MAca*I65 |
| 66 | 9                                                                                                                                                              | 2237.31                                                                                                                                                                                                                                                                                                                 | =B66+DFIT_Hydro                                                                                                                                                                                                                                                                                                                                                                                  | =CHOOSEROWS(LET(BhPressure_psi,$C$54:$C$96,PO.FRAC.DFIT.GFunction($A$54:$A$96,DFIT_Tp,BhPressure_psi,DFIT_Alpha,"G")),13) | =CHOOSEROWS(LET(BhPressure_psi,$C$54:$C$96,PO.FRAC.DFIT.GFunction($A$54:$A$96,DFIT_Tp,BhPressure_psi,DFIT_Alpha,"dPdG")),13) | =CHOOSEROWS(LET(BhPressure_psi,$C$54:$C$96,PO.FRAC.DFIT.GFunction($A$54:$A$96,DFIT_Tp,BhPressure_psi,DFIT_Alpha,"GdPdG")),13) | =DFIT_M*D66   | =IF(AND(D66>DFIT_GLo,F66<(1-DFIT_Tol)*G66),1,0) | =2/PI()*ASIN(SQRT(MIN(1,DFIT_TcTotal/(DFIT_Tp+A66)))) | =IF(AND(A66>DFIT_DtC,I66<=DFIT_FLMax),1,0) | =DFIT_Pr+DFIT_MAca*I66 |
| 67 | 10                                                                                                                                                             | 2205.68                                                                                                                                                                                                                                                                                                                 | =B67+DFIT_Hydro                                                                                                                                                                                                                                                                                                                                                                                  | =CHOOSEROWS(LET(BhPressure_psi,$C$54:$C$96,PO.FRAC.DFIT.GFunction($A$54:$A$96,DFIT_Tp,BhPressure_psi,DFIT_Alpha,"G")),14) | =CHOOSEROWS(LET(BhPressure_psi,$C$54:$C$96,PO.FRAC.DFIT.GFunction($A$54:$A$96,DFIT_Tp,BhPressure_psi,DFIT_Alpha,"dPdG")),14) | =CHOOSEROWS(LET(BhPressure_psi,$C$54:$C$96,PO.FRAC.DFIT.GFunction($A$54:$A$96,DFIT_Tp,BhPressure_psi,DFIT_Alpha,"GdPdG")),14) | =DFIT_M*D67   | =IF(AND(D67>DFIT_GLo,F67<(1-DFIT_Tol)*G67),1,0) | =2/PI()*ASIN(SQRT(MIN(1,DFIT_TcTotal/(DFIT_Tp+A67)))) | =IF(AND(A67>DFIT_DtC,I67<=DFIT_FLMax),1,0) | =DFIT_Pr+DFIT_MAca*I67 |
| 68 | 11                                                                                                                                                             | 2175.31                                                                                                                                                                                                                                                                                                                 | =B68+DFIT_Hydro                                                                                                                                                                                                                                                                                                                                                                                  | =CHOOSEROWS(LET(BhPressure_psi,$C$54:$C$96,PO.FRAC.DFIT.GFunction($A$54:$A$96,DFIT_Tp,BhPressure_psi,DFIT_Alpha,"G")),15) | =CHOOSEROWS(LET(BhPressure_psi,$C$54:$C$96,PO.FRAC.DFIT.GFunction($A$54:$A$96,DFIT_Tp,BhPressure_psi,DFIT_Alpha,"dPdG")),15) | =CHOOSEROWS(LET(BhPressure_psi,$C$54:$C$96,PO.FRAC.DFIT.GFunction($A$54:$A$96,DFIT_Tp,BhPressure_psi,DFIT_Alpha,"GdPdG")),15) | =DFIT_M*D68   | =IF(AND(D68>DFIT_GLo,F68<(1-DFIT_Tol)*G68),1,0) | =2/PI()*ASIN(SQRT(MIN(1,DFIT_TcTotal/(DFIT_Tp+A68)))) | =IF(AND(A68>DFIT_DtC,I68<=DFIT_FLMax),1,0) | =DFIT_Pr+DFIT_MAca*I68 |
| 69 | 12                                                                                                                                                             | 2146.07                                                                                                                                                                                                                                                                                                                 | =B69+DFIT_Hydro                                                                                                                                                                                                                                                                                                                                                                                  | =CHOOSEROWS(LET(BhPressure_psi,$C$54:$C$96,PO.FRAC.DFIT.GFunction($A$54:$A$96,DFIT_Tp,BhPressure_psi,DFIT_Alpha,"G")),16) | =CHOOSEROWS(LET(BhPressure_psi,$C$54:$C$96,PO.FRAC.DFIT.GFunction($A$54:$A$96,DFIT_Tp,BhPressure_psi,DFIT_Alpha,"dPdG")),16) | =CHOOSEROWS(LET(BhPressure_psi,$C$54:$C$96,PO.FRAC.DFIT.GFunction($A$54:$A$96,DFIT_Tp,BhPressure_psi,DFIT_Alpha,"GdPdG")),16) | =DFIT_M*D69   | =IF(AND(D69>DFIT_GLo,F69<(1-DFIT_Tol)*G69),1,0) | =2/PI()*ASIN(SQRT(MIN(1,DFIT_TcTotal/(DFIT_Tp+A69)))) | =IF(AND(A69>DFIT_DtC,I69<=DFIT_FLMax),1,0) | =DFIT_Pr+DFIT_MAca*I69 |
| 70 | 13                                                                                                                                                             | 2117.83                                                                                                                                                                                                                                                                                                                 | =B70+DFIT_Hydro                                                                                                                                                                                                                                                                                                                                                                                  | =CHOOSEROWS(LET(BhPressure_psi,$C$54:$C$96,PO.FRAC.DFIT.GFunction($A$54:$A$96,DFIT_Tp,BhPressure_psi,DFIT_Alpha,"G")),17) | =CHOOSEROWS(LET(BhPressure_psi,$C$54:$C$96,PO.FRAC.DFIT.GFunction($A$54:$A$96,DFIT_Tp,BhPressure_psi,DFIT_Alpha,"dPdG")),17) | =CHOOSEROWS(LET(BhPressure_psi,$C$54:$C$96,PO.FRAC.DFIT.GFunction($A$54:$A$96,DFIT_Tp,BhPressure_psi,DFIT_Alpha,"GdPdG")),17) | =DFIT_M*D70   | =IF(AND(D70>DFIT_GLo,F70<(1-DFIT_Tol)*G70),1,0) | =2/PI()*ASIN(SQRT(MIN(1,DFIT_TcTotal/(DFIT_Tp+A70)))) | =IF(AND(A70>DFIT_DtC,I70<=DFIT_FLMax),1,0) | =DFIT_Pr+DFIT_MAca*I70 |
| 71 | 14                                                                                                                                                             | 2090.5                                                                                                                                                                                                                                                                                                                  | =B71+DFIT_Hydro                                                                                                                                                                                                                                                                                                                                                                                  | =CHOOSEROWS(LET(BhPressure_psi,$C$54:$C$96,PO.FRAC.DFIT.GFunction($A$54:$A$96,DFIT_Tp,BhPressure_psi,DFIT_Alpha,"G")),18) | =CHOOSEROWS(LET(BhPressure_psi,$C$54:$C$96,PO.FRAC.DFIT.GFunction($A$54:$A$96,DFIT_Tp,BhPressure_psi,DFIT_Alpha,"dPdG")),18) | =CHOOSEROWS(LET(BhPressure_psi,$C$54:$C$96,PO.FRAC.DFIT.GFunction($A$54:$A$96,DFIT_Tp,BhPressure_psi,DFIT_Alpha,"GdPdG")),18) | =DFIT_M*D71   | =IF(AND(D71>DFIT_GLo,F71<(1-DFIT_Tol)*G71),1,0) | =2/PI()*ASIN(SQRT(MIN(1,DFIT_TcTotal/(DFIT_Tp+A71)))) | =IF(AND(A71>DFIT_DtC,I71<=DFIT_FLMax),1,0) | =DFIT_Pr+DFIT_MAca*I71 |
| 72 | 15                                                                                                                                                             | 2064                                                                                                                                                                                                                                                                                                                    | =B72+DFIT_Hydro                                                                                                                                                                                                                                                                                                                                                                                  | =CHOOSEROWS(LET(BhPressure_psi,$C$54:$C$96,PO.FRAC.DFIT.GFunction($A$54:$A$96,DFIT_Tp,BhPressure_psi,DFIT_Alpha,"G")),19) | =CHOOSEROWS(LET(BhPressure_psi,$C$54:$C$96,PO.FRAC.DFIT.GFunction($A$54:$A$96,DFIT_Tp,BhPressure_psi,DFIT_Alpha,"dPdG")),19) | =CHOOSEROWS(LET(BhPressure_psi,$C$54:$C$96,PO.FRAC.DFIT.GFunction($A$54:$A$96,DFIT_Tp,BhPressure_psi,DFIT_Alpha,"GdPdG")),19) | =DFIT_M*D72   | =IF(AND(D72>DFIT_GLo,F72<(1-DFIT_Tol)*G72),1,0) | =2/PI()*ASIN(SQRT(MIN(1,DFIT_TcTotal/(DFIT_Tp+A72)))) | =IF(AND(A72>DFIT_DtC,I72<=DFIT_FLMax),1,0) | =DFIT_Pr+DFIT_MAca*I72 |
| 73 | 16                                                                                                                                                             | 2051.07                                                                                                                                                                                                                                                                                                                 | =B73+DFIT_Hydro                                                                                                                                                                                                                                                                                                                                                                                  | =CHOOSEROWS(LET(BhPressure_psi,$C$54:$C$96,PO.FRAC.DFIT.GFunction($A$54:$A$96,DFIT_Tp,BhPressure_psi,DFIT_Alpha,"G")),20) | =CHOOSEROWS(LET(BhPressure_psi,$C$54:$C$96,PO.FRAC.DFIT.GFunction($A$54:$A$96,DFIT_Tp,BhPressure_psi,DFIT_Alpha,"dPdG")),20) | =CHOOSEROWS(LET(BhPressure_psi,$C$54:$C$96,PO.FRAC.DFIT.GFunction($A$54:$A$96,DFIT_Tp,BhPressure_psi,DFIT_Alpha,"GdPdG")),20) | =DFIT_M*D73   | =IF(AND(D73>DFIT_GLo,F73<(1-DFIT_Tol)*G73),1,0) | =2/PI()*ASIN(SQRT(MIN(1,DFIT_TcTotal/(DFIT_Tp+A73)))) | =IF(AND(A73>DFIT_DtC,I73<=DFIT_FLMax),1,0) | =DFIT_Pr+DFIT_MAca*I73 |
| 74 | 17                                                                                                                                                             | 2038.39                                                                                                                                                                                                                                                                                                                 | =B74+DFIT_Hydro                                                                                                                                                                                                                                                                                                                                                                                  | =CHOOSEROWS(LET(BhPressure_psi,$C$54:$C$96,PO.FRAC.DFIT.GFunction($A$54:$A$96,DFIT_Tp,BhPressure_psi,DFIT_Alpha,"G")),21) | =CHOOSEROWS(LET(BhPressure_psi,$C$54:$C$96,PO.FRAC.DFIT.GFunction($A$54:$A$96,DFIT_Tp,BhPressure_psi,DFIT_Alpha,"dPdG")),21) | =CHOOSEROWS(LET(BhPressure_psi,$C$54:$C$96,PO.FRAC.DFIT.GFunction($A$54:$A$96,DFIT_Tp,BhPressure_psi,DFIT_Alpha,"GdPdG")),21) | =DFIT_M*D74   | =IF(AND(D74>DFIT_GLo,F74<(1-DFIT_Tol)*G74),1,0) | =2/PI()*ASIN(SQRT(MIN(1,DFIT_TcTotal/(DFIT_Tp+A74)))) | =IF(AND(A74>DFIT_DtC,I74<=DFIT_FLMax),1,0) | =DFIT_Pr+DFIT_MAca*I74 |
| 75 | 18                                                                                                                                                             | 2025.94                                                                                                                                                                                                                                                                                                                 | =B75+DFIT_Hydro                                                                                                                                                                                                                                                                                                                                                                                  | =CHOOSEROWS(LET(BhPressure_psi,$C$54:$C$96,PO.FRAC.DFIT.GFunction($A$54:$A$96,DFIT_Tp,BhPressure_psi,DFIT_Alpha,"G")),22) | =CHOOSEROWS(LET(BhPressure_psi,$C$54:$C$96,PO.FRAC.DFIT.GFunction($A$54:$A$96,DFIT_Tp,BhPressure_psi,DFIT_Alpha,"dPdG")),22) | =CHOOSEROWS(LET(BhPressure_psi,$C$54:$C$96,PO.FRAC.DFIT.GFunction($A$54:$A$96,DFIT_Tp,BhPressure_psi,DFIT_Alpha,"GdPdG")),22) | =DFIT_M*D75   | =IF(AND(D75>DFIT_GLo,F75<(1-DFIT_Tol)*G75),1,0) | =2/PI()*ASIN(SQRT(MIN(1,DFIT_TcTotal/(DFIT_Tp+A75)))) | =IF(AND(A75>DFIT_DtC,I75<=DFIT_FLMax),1,0) | =DFIT_Pr+DFIT_MAca*I75 |
| 76 | 20                                                                                                                                                             | 2001.75                                                                                                                                                                                                                                                                                                                 | =B76+DFIT_Hydro                                                                                                                                                                                                                                                                                                                                                                                  | =CHOOSEROWS(LET(BhPressure_psi,$C$54:$C$96,PO.FRAC.DFIT.GFunction($A$54:$A$96,DFIT_Tp,BhPressure_psi,DFIT_Alpha,"G")),23) | =CHOOSEROWS(LET(BhPressure_psi,$C$54:$C$96,PO.FRAC.DFIT.GFunction($A$54:$A$96,DFIT_Tp,BhPressure_psi,DFIT_Alpha,"dPdG")),23) | =CHOOSEROWS(LET(BhPressure_psi,$C$54:$C$96,PO.FRAC.DFIT.GFunction($A$54:$A$96,DFIT_Tp,BhPressure_psi,DFIT_Alpha,"GdPdG")),23) | =DFIT_M*D76   | =IF(AND(D76>DFIT_GLo,F76<(1-DFIT_Tol)*G76),1,0) | =2/PI()*ASIN(SQRT(MIN(1,DFIT_TcTotal/(DFIT_Tp+A76)))) | =IF(AND(A76>DFIT_DtC,I76<=DFIT_FLMax),1,0) | =DFIT_Pr+DFIT_MAca*I76 |
| 77 | 22.5                                                                                                                                                           | 1972.72                                                                                                                                                                                                                                                                                                                 | =B77+DFIT_Hydro                                                                                                                                                                                                                                                                                                                                                                                  | =CHOOSEROWS(LET(BhPressure_psi,$C$54:$C$96,PO.FRAC.DFIT.GFunction($A$54:$A$96,DFIT_Tp,BhPressure_psi,DFIT_Alpha,"G")),24) | =CHOOSEROWS(LET(BhPressure_psi,$C$54:$C$96,PO.FRAC.DFIT.GFunction($A$54:$A$96,DFIT_Tp,BhPressure_psi,DFIT_Alpha,"dPdG")),24) | =CHOOSEROWS(LET(BhPressure_psi,$C$54:$C$96,PO.FRAC.DFIT.GFunction($A$54:$A$96,DFIT_Tp,BhPressure_psi,DFIT_Alpha,"GdPdG")),24) | =DFIT_M*D77   | =IF(AND(D77>DFIT_GLo,F77<(1-DFIT_Tol)*G77),1,0) | =2/PI()*ASIN(SQRT(MIN(1,DFIT_TcTotal/(DFIT_Tp+A77)))) | =IF(AND(A77>DFIT_DtC,I77<=DFIT_FLMax),1,0) | =DFIT_Pr+DFIT_MAca*I77 |
| 78 | 25                                                                                                                                                             | 1944.97                                                                                                                                                                                                                                                                                                                 | =B78+DFIT_Hydro                                                                                                                                                                                                                                                                                                                                                                                  | =CHOOSEROWS(LET(BhPressure_psi,$C$54:$C$96,PO.FRAC.DFIT.GFunction($A$54:$A$96,DFIT_Tp,BhPressure_psi,DFIT_Alpha,"G")),25) | =CHOOSEROWS(LET(BhPressure_psi,$C$54:$C$96,PO.FRAC.DFIT.GFunction($A$54:$A$96,DFIT_Tp,BhPressure_psi,DFIT_Alpha,"dPdG")),25) | =CHOOSEROWS(LET(BhPressure_psi,$C$54:$C$96,PO.FRAC.DFIT.GFunction($A$54:$A$96,DFIT_Tp,BhPressure_psi,DFIT_Alpha,"GdPdG")),25) | =DFIT_M*D78   | =IF(AND(D78>DFIT_GLo,F78<(1-DFIT_Tol)*G78),1,0) | =2/PI()*ASIN(SQRT(MIN(1,DFIT_TcTotal/(DFIT_Tp+A78)))) | =IF(AND(A78>DFIT_DtC,I78<=DFIT_FLMax),1,0) | =DFIT_Pr+DFIT_MAca*I78 |
| 79 | 30                                                                                                                                                             | 1892.9                                                                                                                                                                                                                                                                                                                  | =B79+DFIT_Hydro                                                                                                                                                                                                                                                                                                                                                                                  | =CHOOSEROWS(LET(BhPressure_psi,$C$54:$C$96,PO.FRAC.DFIT.GFunction($A$54:$A$96,DFIT_Tp,BhPressure_psi,DFIT_Alpha,"G")),26) | =CHOOSEROWS(LET(BhPressure_psi,$C$54:$C$96,PO.FRAC.DFIT.GFunction($A$54:$A$96,DFIT_Tp,BhPressure_psi,DFIT_Alpha,"dPdG")),26) | =CHOOSEROWS(LET(BhPressure_psi,$C$54:$C$96,PO.FRAC.DFIT.GFunction($A$54:$A$96,DFIT_Tp,BhPressure_psi,DFIT_Alpha,"GdPdG")),26) | =DFIT_M*D79   | =IF(AND(D79>DFIT_GLo,F79<(1-DFIT_Tol)*G79),1,0) | =2/PI()*ASIN(SQRT(MIN(1,DFIT_TcTotal/(DFIT_Tp+A79)))) | =IF(AND(A79>DFIT_DtC,I79<=DFIT_FLMax),1,0) | =DFIT_Pr+DFIT_MAca*I79 |
| 80 | 40                                                                                                                                                             | 1800.56                                                                                                                                                                                                                                                                                                                 | =B80+DFIT_Hydro                                                                                                                                                                                                                                                                                                                                                                                  | =CHOOSEROWS(LET(BhPressure_psi,$C$54:$C$96,PO.FRAC.DFIT.GFunction($A$54:$A$96,DFIT_Tp,BhPressure_psi,DFIT_Alpha,"G")),27) | =CHOOSEROWS(LET(BhPressure_psi,$C$54:$C$96,PO.FRAC.DFIT.GFunction($A$54:$A$96,DFIT_Tp,BhPressure_psi,DFIT_Alpha,"dPdG")),27) | =CHOOSEROWS(LET(BhPressure_psi,$C$54:$C$96,PO.FRAC.DFIT.GFunction($A$54:$A$96,DFIT_Tp,BhPressure_psi,DFIT_Alpha,"GdPdG")),27) | =DFIT_M*D80   | =IF(AND(D80>DFIT_GLo,F80<(1-DFIT_Tol)*G80),1,0) | =2/PI()*ASIN(SQRT(MIN(1,DFIT_TcTotal/(DFIT_Tp+A80)))) | =IF(AND(A80>DFIT_DtC,I80<=DFIT_FLMax),1,0) | =DFIT_Pr+DFIT_MAca*I80 |
| 81 | 50                                                                                                                                                             | 1720.92                                                                                                                                                                                                                                                                                                                 | =B81+DFIT_Hydro                                                                                                                                                                                                                                                                                                                                                                                  | =CHOOSEROWS(LET(BhPressure_psi,$C$54:$C$96,PO.FRAC.DFIT.GFunction($A$54:$A$96,DFIT_Tp,BhPressure_psi,DFIT_Alpha,"G")),28) | =CHOOSEROWS(LET(BhPressure_psi,$C$54:$C$96,PO.FRAC.DFIT.GFunction($A$54:$A$96,DFIT_Tp,BhPressure_psi,DFIT_Alpha,"dPdG")),28) | =CHOOSEROWS(LET(BhPressure_psi,$C$54:$C$96,PO.FRAC.DFIT.GFunction($A$54:$A$96,DFIT_Tp,BhPressure_psi,DFIT_Alpha,"GdPdG")),28) | =DFIT_M*D81   | =IF(AND(D81>DFIT_GLo,F81<(1-DFIT_Tol)*G81),1,0) | =2/PI()*ASIN(SQRT(MIN(1,DFIT_TcTotal/(DFIT_Tp+A81)))) | =IF(AND(A81>DFIT_DtC,I81<=DFIT_FLMax),1,0) | =DFIT_Pr+DFIT_MAca*I81 |
| 82 | 60                                                                                                                                                             | 1651.32                                                                                                                                                                                                                                                                                                                 | =B82+DFIT_Hydro                                                                                                                                                                                                                                                                                                                                                                                  | =CHOOSEROWS(LET(BhPressure_psi,$C$54:$C$96,PO.FRAC.DFIT.GFunction($A$54:$A$96,DFIT_Tp,BhPressure_psi,DFIT_Alpha,"G")),29) | =CHOOSEROWS(LET(BhPressure_psi,$C$54:$C$96,PO.FRAC.DFIT.GFunction($A$54:$A$96,DFIT_Tp,BhPressure_psi,DFIT_Alpha,"dPdG")),29) | =CHOOSEROWS(LET(BhPressure_psi,$C$54:$C$96,PO.FRAC.DFIT.GFunction($A$54:$A$96,DFIT_Tp,BhPressure_psi,DFIT_Alpha,"GdPdG")),29) | =DFIT_M*D82   | =IF(AND(D82>DFIT_GLo,F82<(1-DFIT_Tol)*G82),1,0) | =2/PI()*ASIN(SQRT(MIN(1,DFIT_TcTotal/(DFIT_Tp+A82)))) | =IF(AND(A82>DFIT_DtC,I82<=DFIT_FLMax),1,0) | =DFIT_Pr+DFIT_MAca*I82 |
| 83 | 80                                                                                                                                                             | 1534.95                                                                                                                                                                                                                                                                                                                 | =B83+DFIT_Hydro                                                                                                                                                                                                                                                                                                                                                                                  | =CHOOSEROWS(LET(BhPressure_psi,$C$54:$C$96,PO.FRAC.DFIT.GFunction($A$54:$A$96,DFIT_Tp,BhPressure_psi,DFIT_Alpha,"G")),30) | =CHOOSEROWS(LET(BhPressure_psi,$C$54:$C$96,PO.FRAC.DFIT.GFunction($A$54:$A$96,DFIT_Tp,BhPressure_psi,DFIT_Alpha,"dPdG")),30) | =CHOOSEROWS(LET(BhPressure_psi,$C$54:$C$96,PO.FRAC.DFIT.GFunction($A$54:$A$96,DFIT_Tp,BhPressure_psi,DFIT_Alpha,"GdPdG")),30) | =DFIT_M*D83   | =IF(AND(D83>DFIT_GLo,F83<(1-DFIT_Tol)*G83),1,0) | =2/PI()*ASIN(SQRT(MIN(1,DFIT_TcTotal/(DFIT_Tp+A83)))) | =IF(AND(A83>DFIT_DtC,I83<=DFIT_FLMax),1,0) | =DFIT_Pr+DFIT_MAca*I83 |
| 84 | 100                                                                                                                                                            | 1440.91                                                                                                                                                                                                                                                                                                                 | =B84+DFIT_Hydro                                                                                                                                                                                                                                                                                                                                                                                  | =CHOOSEROWS(LET(BhPressure_psi,$C$54:$C$96,PO.FRAC.DFIT.GFunction($A$54:$A$96,DFIT_Tp,BhPressure_psi,DFIT_Alpha,"G")),31) | =CHOOSEROWS(LET(BhPressure_psi,$C$54:$C$96,PO.FRAC.DFIT.GFunction($A$54:$A$96,DFIT_Tp,BhPressure_psi,DFIT_Alpha,"dPdG")),31) | =CHOOSEROWS(LET(BhPressure_psi,$C$54:$C$96,PO.FRAC.DFIT.GFunction($A$54:$A$96,DFIT_Tp,BhPressure_psi,DFIT_Alpha,"GdPdG")),31) | =DFIT_M*D84   | =IF(AND(D84>DFIT_GLo,F84<(1-DFIT_Tol)*G84),1,0) | =2/PI()*ASIN(SQRT(MIN(1,DFIT_TcTotal/(DFIT_Tp+A84)))) | =IF(AND(A84>DFIT_DtC,I84<=DFIT_FLMax),1,0) | =DFIT_Pr+DFIT_MAca*I84 |
| 85 | 120                                                                                                                                                            | 1362.87                                                                                                                                                                                                                                                                                                                 | =B85+DFIT_Hydro                                                                                                                                                                                                                                                                                                                                                                                  | =CHOOSEROWS(LET(BhPressure_psi,$C$54:$C$96,PO.FRAC.DFIT.GFunction($A$54:$A$96,DFIT_Tp,BhPressure_psi,DFIT_Alpha,"G")),32) | =CHOOSEROWS(LET(BhPressure_psi,$C$54:$C$96,PO.FRAC.DFIT.GFunction($A$54:$A$96,DFIT_Tp,BhPressure_psi,DFIT_Alpha,"dPdG")),32) | =CHOOSEROWS(LET(BhPressure_psi,$C$54:$C$96,PO.FRAC.DFIT.GFunction($A$54:$A$96,DFIT_Tp,BhPressure_psi,DFIT_Alpha,"GdPdG")),32) | =DFIT_M*D85   | =IF(AND(D85>DFIT_GLo,F85<(1-DFIT_Tol)*G85),1,0) | =2/PI()*ASIN(SQRT(MIN(1,DFIT_TcTotal/(DFIT_Tp+A85)))) | =IF(AND(A85>DFIT_DtC,I85<=DFIT_FLMax),1,0) | =DFIT_Pr+DFIT_MAca*I85 |
| 86 | 150                                                                                                                                                            | 1267.27                                                                                                                                                                                                                                                                                                                 | =B86+DFIT_Hydro                                                                                                                                                                                                                                                                                                                                                                                  | =CHOOSEROWS(LET(BhPressure_psi,$C$54:$C$96,PO.FRAC.DFIT.GFunction($A$54:$A$96,DFIT_Tp,BhPressure_psi,DFIT_Alpha,"G")),33) | =CHOOSEROWS(LET(BhPressure_psi,$C$54:$C$96,PO.FRAC.DFIT.GFunction($A$54:$A$96,DFIT_Tp,BhPressure_psi,DFIT_Alpha,"dPdG")),33) | =CHOOSEROWS(LET(BhPressure_psi,$C$54:$C$96,PO.FRAC.DFIT.GFunction($A$54:$A$96,DFIT_Tp,BhPressure_psi,DFIT_Alpha,"GdPdG")),33) | =DFIT_M*D86   | =IF(AND(D86>DFIT_GLo,F86<(1-DFIT_Tol)*G86),1,0) | =2/PI()*ASIN(SQRT(MIN(1,DFIT_TcTotal/(DFIT_Tp+A86)))) | =IF(AND(A86>DFIT_DtC,I86<=DFIT_FLMax),1,0) | =DFIT_Pr+DFIT_MAca*I86 |
| 87 | 200                                                                                                                                                            | 1146.18                                                                                                                                                                                                                                                                                                                 | =B87+DFIT_Hydro                                                                                                                                                                                                                                                                                                                                                                                  | =CHOOSEROWS(LET(BhPressure_psi,$C$54:$C$96,PO.FRAC.DFIT.GFunction($A$54:$A$96,DFIT_Tp,BhPressure_psi,DFIT_Alpha,"G")),34) | =CHOOSEROWS(LET(BhPressure_psi,$C$54:$C$96,PO.FRAC.DFIT.GFunction($A$54:$A$96,DFIT_Tp,BhPressure_psi,DFIT_Alpha,"dPdG")),34) | =CHOOSEROWS(LET(BhPressure_psi,$C$54:$C$96,PO.FRAC.DFIT.GFunction($A$54:$A$96,DFIT_Tp,BhPressure_psi,DFIT_Alpha,"GdPdG")),34) | =DFIT_M*D87   | =IF(AND(D87>DFIT_GLo,F87<(1-DFIT_Tol)*G87),1,0) | =2/PI()*ASIN(SQRT(MIN(1,DFIT_TcTotal/(DFIT_Tp+A87)))) | =IF(AND(A87>DFIT_DtC,I87<=DFIT_FLMax),1,0) | =DFIT_Pr+DFIT_MAca*I87 |
| 88 | 250                                                                                                                                                            | 1055.56                                                                                                                                                                                                                                                                                                                 | =B88+DFIT_Hydro                                                                                                                                                                                                                                                                                                                                                                                  | =CHOOSEROWS(LET(BhPressure_psi,$C$54:$C$96,PO.FRAC.DFIT.GFunction($A$54:$A$96,DFIT_Tp,BhPressure_psi,DFIT_Alpha,"G")),35) | =CHOOSEROWS(LET(BhPressure_psi,$C$54:$C$96,PO.FRAC.DFIT.GFunction($A$54:$A$96,DFIT_Tp,BhPressure_psi,DFIT_Alpha,"dPdG")),35) | =CHOOSEROWS(LET(BhPressure_psi,$C$54:$C$96,PO.FRAC.DFIT.GFunction($A$54:$A$96,DFIT_Tp,BhPressure_psi,DFIT_Alpha,"GdPdG")),35) | =DFIT_M*D88   | =IF(AND(D88>DFIT_GLo,F88<(1-DFIT_Tol)*G88),1,0) | =2/PI()*ASIN(SQRT(MIN(1,DFIT_TcTotal/(DFIT_Tp+A88)))) | =IF(AND(A88>DFIT_DtC,I88<=DFIT_FLMax),1,0) | =DFIT_Pr+DFIT_MAca*I88 |
| 89 | 300                                                                                                                                                            | 984.45                                                                                                                                                                                                                                                                                                                  | =B89+DFIT_Hydro                                                                                                                                                                                                                                                                                                                                                                                  | =CHOOSEROWS(LET(BhPressure_psi,$C$54:$C$96,PO.FRAC.DFIT.GFunction($A$54:$A$96,DFIT_Tp,BhPressure_psi,DFIT_Alpha,"G")),36) | =CHOOSEROWS(LET(BhPressure_psi,$C$54:$C$96,PO.FRAC.DFIT.GFunction($A$54:$A$96,DFIT_Tp,BhPressure_psi,DFIT_Alpha,"dPdG")),36) | =CHOOSEROWS(LET(BhPressure_psi,$C$54:$C$96,PO.FRAC.DFIT.GFunction($A$54:$A$96,DFIT_Tp,BhPressure_psi,DFIT_Alpha,"GdPdG")),36) | =DFIT_M*D89   | =IF(AND(D89>DFIT_GLo,F89<(1-DFIT_Tol)*G89),1,0) | =2/PI()*ASIN(SQRT(MIN(1,DFIT_TcTotal/(DFIT_Tp+A89)))) | =IF(AND(A89>DFIT_DtC,I89<=DFIT_FLMax),1,0) | =DFIT_Pr+DFIT_MAca*I89 |
| 90 | 400                                                                                                                                                            | 878.67                                                                                                                                                                                                                                                                                                                  | =B90+DFIT_Hydro                                                                                                                                                                                                                                                                                                                                                                                  | =CHOOSEROWS(LET(BhPressure_psi,$C$54:$C$96,PO.FRAC.DFIT.GFunction($A$54:$A$96,DFIT_Tp,BhPressure_psi,DFIT_Alpha,"G")),37) | =CHOOSEROWS(LET(BhPressure_psi,$C$54:$C$96,PO.FRAC.DFIT.GFunction($A$54:$A$96,DFIT_Tp,BhPressure_psi,DFIT_Alpha,"dPdG")),37) | =CHOOSEROWS(LET(BhPressure_psi,$C$54:$C$96,PO.FRAC.DFIT.GFunction($A$54:$A$96,DFIT_Tp,BhPressure_psi,DFIT_Alpha,"GdPdG")),37) | =DFIT_M*D90   | =IF(AND(D90>DFIT_GLo,F90<(1-DFIT_Tol)*G90),1,0) | =2/PI()*ASIN(SQRT(MIN(1,DFIT_TcTotal/(DFIT_Tp+A90)))) | =IF(AND(A90>DFIT_DtC,I90<=DFIT_FLMax),1,0) | =DFIT_Pr+DFIT_MAca*I90 |
| 91 | 500                                                                                                                                                            | 802.59                                                                                                                                                                                                                                                                                                                  | =B91+DFIT_Hydro                                                                                                                                                                                                                                                                                                                                                                                  | =CHOOSEROWS(LET(BhPressure_psi,$C$54:$C$96,PO.FRAC.DFIT.GFunction($A$54:$A$96,DFIT_Tp,BhPressure_psi,DFIT_Alpha,"G")),38) | =CHOOSEROWS(LET(BhPressure_psi,$C$54:$C$96,PO.FRAC.DFIT.GFunction($A$54:$A$96,DFIT_Tp,BhPressure_psi,DFIT_Alpha,"dPdG")),38) | =CHOOSEROWS(LET(BhPressure_psi,$C$54:$C$96,PO.FRAC.DFIT.GFunction($A$54:$A$96,DFIT_Tp,BhPressure_psi,DFIT_Alpha,"GdPdG")),38) | =DFIT_M*D91   | =IF(AND(D91>DFIT_GLo,F91<(1-DFIT_Tol)*G91),1,0) | =2/PI()*ASIN(SQRT(MIN(1,DFIT_TcTotal/(DFIT_Tp+A91)))) | =IF(AND(A91>DFIT_DtC,I91<=DFIT_FLMax),1,0) | =DFIT_Pr+DFIT_MAca*I91 |
| 92 | 600                                                                                                                                                            | 744.48                                                                                                                                                                                                                                                                                                                  | =B92+DFIT_Hydro                                                                                                                                                                                                                                                                                                                                                                                  | =CHOOSEROWS(LET(BhPressure_psi,$C$54:$C$96,PO.FRAC.DFIT.GFunction($A$54:$A$96,DFIT_Tp,BhPressure_psi,DFIT_Alpha,"G")),39) | =CHOOSEROWS(LET(BhPressure_psi,$C$54:$C$96,PO.FRAC.DFIT.GFunction($A$54:$A$96,DFIT_Tp,BhPressure_psi,DFIT_Alpha,"dPdG")),39) | =CHOOSEROWS(LET(BhPressure_psi,$C$54:$C$96,PO.FRAC.DFIT.GFunction($A$54:$A$96,DFIT_Tp,BhPressure_psi,DFIT_Alpha,"GdPdG")),39) | =DFIT_M*D92   | =IF(AND(D92>DFIT_GLo,F92<(1-DFIT_Tol)*G92),1,0) | =2/PI()*ASIN(SQRT(MIN(1,DFIT_TcTotal/(DFIT_Tp+A92)))) | =IF(AND(A92>DFIT_DtC,I92<=DFIT_FLMax),1,0) | =DFIT_Pr+DFIT_MAca*I92 |
| 93 | 800                                                                                                                                                            | 660.29                                                                                                                                                                                                                                                                                                                  | =B93+DFIT_Hydro                                                                                                                                                                                                                                                                                                                                                                                  | =CHOOSEROWS(LET(BhPressure_psi,$C$54:$C$96,PO.FRAC.DFIT.GFunction($A$54:$A$96,DFIT_Tp,BhPressure_psi,DFIT_Alpha,"G")),40) | =CHOOSEROWS(LET(BhPressure_psi,$C$54:$C$96,PO.FRAC.DFIT.GFunction($A$54:$A$96,DFIT_Tp,BhPressure_psi,DFIT_Alpha,"dPdG")),40) | =CHOOSEROWS(LET(BhPressure_psi,$C$54:$C$96,PO.FRAC.DFIT.GFunction($A$54:$A$96,DFIT_Tp,BhPressure_psi,DFIT_Alpha,"GdPdG")),40) | =DFIT_M*D93   | =IF(AND(D93>DFIT_GLo,F93<(1-DFIT_Tol)*G93),1,0) | =2/PI()*ASIN(SQRT(MIN(1,DFIT_TcTotal/(DFIT_Tp+A93)))) | =IF(AND(A93>DFIT_DtC,I93<=DFIT_FLMax),1,0) | =DFIT_Pr+DFIT_MAca*I93 |
| 94 | 1000                                                                                                                                                           | 601.19                                                                                                                                                                                                                                                                                                                  | =B94+DFIT_Hydro                                                                                                                                                                                                                                                                                                                                                                                  | =CHOOSEROWS(LET(BhPressure_psi,$C$54:$C$96,PO.FRAC.DFIT.GFunction($A$54:$A$96,DFIT_Tp,BhPressure_psi,DFIT_Alpha,"G")),41) | =CHOOSEROWS(LET(BhPressure_psi,$C$54:$C$96,PO.FRAC.DFIT.GFunction($A$54:$A$96,DFIT_Tp,BhPressure_psi,DFIT_Alpha,"dPdG")),41) | =CHOOSEROWS(LET(BhPressure_psi,$C$54:$C$96,PO.FRAC.DFIT.GFunction($A$54:$A$96,DFIT_Tp,BhPressure_psi,DFIT_Alpha,"GdPdG")),41) | =DFIT_M*D94   | =IF(AND(D94>DFIT_GLo,F94<(1-DFIT_Tol)*G94),1,0) | =2/PI()*ASIN(SQRT(MIN(1,DFIT_TcTotal/(DFIT_Tp+A94)))) | =IF(AND(A94>DFIT_DtC,I94<=DFIT_FLMax),1,0) | =DFIT_Pr+DFIT_MAca*I94 |
| 95 | 1200                                                                                                                                                           | 556.78                                                                                                                                                                                                                                                                                                                  | =B95+DFIT_Hydro                                                                                                                                                                                                                                                                                                                                                                                  | =CHOOSEROWS(LET(BhPressure_psi,$C$54:$C$96,PO.FRAC.DFIT.GFunction($A$54:$A$96,DFIT_Tp,BhPressure_psi,DFIT_Alpha,"G")),42) | =CHOOSEROWS(LET(BhPressure_psi,$C$54:$C$96,PO.FRAC.DFIT.GFunction($A$54:$A$96,DFIT_Tp,BhPressure_psi,DFIT_Alpha,"dPdG")),42) | =CHOOSEROWS(LET(BhPressure_psi,$C$54:$C$96,PO.FRAC.DFIT.GFunction($A$54:$A$96,DFIT_Tp,BhPressure_psi,DFIT_Alpha,"GdPdG")),42) | =DFIT_M*D95   | =IF(AND(D95>DFIT_GLo,F95<(1-DFIT_Tol)*G95),1,0) | =2/PI()*ASIN(SQRT(MIN(1,DFIT_TcTotal/(DFIT_Tp+A95)))) | =IF(AND(A95>DFIT_DtC,I95<=DFIT_FLMax),1,0) | =DFIT_Pr+DFIT_MAca*I95 |
| 96 | 1440                                                                                                                                                           | 515.68                                                                                                                                                                                                                                                                                                                  | =B96+DFIT_Hydro                                                                                                                                                                                                                                                                                                                                                                                  | =CHOOSEROWS(LET(BhPressure_psi,$C$54:$C$96,PO.FRAC.DFIT.GFunction($A$54:$A$96,DFIT_Tp,BhPressure_psi,DFIT_Alpha,"G")),43) | =CHOOSEROWS(LET(BhPressure_psi,$C$54:$C$96,PO.FRAC.DFIT.GFunction($A$54:$A$96,DFIT_Tp,BhPressure_psi,DFIT_Alpha,"dPdG")),43) | =CHOOSEROWS(LET(BhPressure_psi,$C$54:$C$96,PO.FRAC.DFIT.GFunction($A$54:$A$96,DFIT_Tp,BhPressure_psi,DFIT_Alpha,"GdPdG")),43) | =DFIT_M*D96   | =IF(AND(D96>DFIT_GLo,F96<(1-DFIT_Tol)*G96),1,0) | =2/PI()*ASIN(SQRT(MIN(1,DFIT_TcTotal/(DFIT_Tp+A96)))) | =IF(AND(A96>DFIT_DtC,I96<=DFIT_FLMax),1,0) | =DFIT_Pr+DFIT_MAca*I96 |

## Lambdas

| Name | RefersTo | Comment |
|------|----------|---------|
| PO.FRAC.Eval.ISIP | =LAMBDA(isip_surf, rho_fluid, tvd, closure, output, IF(OR(rho_fluid<0, tvd<=0), NA(), LET(isip_bh, isip_surf+0.052*rho_fluid*tvd, IF(output="ISIP", isip_bh, IF(output="Pnet", isip_bh-closure, IF(output="Gradient", isip_bh/tvd, NA())))))) | Instantaneous shut-in pressure at the fracture from the surface ISIP plus the static column 0.052·ρ·TVD; output "ISIP" (psi), "Pnet" (ISIP − closure, psi) or "Gradient" (psi/ft). |
| PO.FRAC.DFIT.GFunction | =LAMBDA(dt, tp, p, alpha, output, IF(OR(tp<=0, AND(alpha<>1, alpha<>0.5)), NA(), LET(td, dt/tp, gn, IF(alpha=1, 4/3*((1+td)^1.5-td^1.5), (1+td)*ASIN(1/SQRT(1+td))+SQRT(td)), gz, IF(alpha=1, 4/3, PI()/2), bigg, 4/PI()*(gn-gz), cnt, ROWS(p), ix, SEQUENCE(cnt), jx, TRANSPOSE(ix), nxt, --(jx=ix+(ix<cnt)), prv, --(jx=ix-(ix>1)), dpdg, -(MMULT(nxt, p)-MMULT(prv, p))/(MMULT(nxt, bigg)-MMULT(prv, bigg)), sel, IF(output="dtD", 1, IF(output="gNolte", 2, IF(output="G", 3, IF(output="dPdG", 4, IF(output="GdPdG", 5, 0))))), IF(sel=0, NA(), CHOOSE(sel, td, gn, bigg, dpdg, bigg*dpdg))))) | Nolte G-function of a fracture falloff for leakoff exponent alpha 1 or 0.5; output column "dtD", "gNolte" g(ΔtD), "G", "dPdG" (−dp/dG) or "GdPdG" (G·dP/dG), central differences. |
| PO.FRAC.DFIT.Efficiency | =LAMBDA(Gc, alpha, IF(AND(alpha<>1, alpha<>0.5), NA(), IF(Gc<0, NA(), Gc/(Gc+4/PI()*IF(alpha=1, 4/3, PI()/2))))) | Fracturing fluid efficiency from the G-function at closure (Nolte material balance): η = Gc/(Gc + 4·g0/π), Gc/(2 + Gc) for alpha 0.5 and Gc/(Gc + 16/(3π)) for alpha 1. |

## Names

| Name | RefersTo | Comment |
|------|----------|---------|
| DFIT_Tp | $B$4 | Injection (pumping) time, tp, min |
| DFIT_Q | $B$5 | Injection rate, bbl/min |
| DFIT_Alpha | $B$6 | Leakoff exponent α (1 or 0.5) |
| DFIT_RhoFluid | $B$7 | Fluid density in the wellbore, ppg |
| DFIT_Tvd | $B$8 | True vertical depth of the perforations, ft |
| DFIT_GLo | $B$10 | Tangent fitted from G = |
| DFIT_GHi | $B$11 | Tangent fitted to G = |
| DFIT_Tol | $B$12 | Closure where G·dP/dG falls this far below the line, % |
| DFIT_GcUser | $B$13 | Closure G you pick (0 takes the tangent pick) |
| DFIT_FLMax | $B$15 | Points fitted where FL is at most |
| DFIT_NormalGrad | $B$16 | Normal pore-pressure gradient, psi/ft |
| DFIT_Inputs | $B$4:$B$16 | The injection, the fluid column and depth, the window and tolerance of the closure pick with its override, and the after-closure window |
| DFIT_IsipSurf | $B$19 | ISIP read at surface, the first point, psi |
| DFIT_Isip | $B$20 | Bottomhole ISIP, psi |
| DFIT_Hydro | $B$21 | Static column of the fluid, added to every point, psi |
| DFIT_Vinj | $B$22 | Volume injected, bbl |
| DFIT_NFit | $B$24 | Points the tangent is fitted to |
| DFIT_M | $B$25 | Tangent's slope, dP/dG of normal leakoff, psi |
| DFIT_GcPick | $B$26 | G where G·dP/dG first leaves the tangent (0 none) |
| DFIT_Gc | $B$27 | G at closure, Gc (the pick or yours) |
| DFIT_DtC | $B$28 | Shut-in time at closure, Δtc, min |
| DFIT_TcTotal | $B$29 | Time at closure from the start of pumping, tc, min |
| DFIT_Pc | $B$30 | Closure stress, the pressure at Gc, psi |
| DFIT_PcGrad | $B$31 | Closure stress gradient, psi/ft |
| DFIT_Pnet | $B$32 | Net pressure at shut-in, ISIP − closure, psi |
| DFIT_IsipGrad | $B$33 | Fracture (ISIP) gradient, psi/ft |
| DFIT_Eta | $B$34 | Fluid efficiency, η, % |
| DFIT_Vfrac | $B$35 | Fracture volume at shut-in, η·V, bbl |
| DFIT_NAca | $B$37 | Points in the linear-flow fit |
| DFIT_MAca | $B$38 | Slope of pressure on FL, psi |
| DFIT_Pr | $B$39 | Pore pressure, the line at FL = 0, psi |
| DFIT_PrGrad | $B$40 | Pore-pressure gradient, psi/ft |
| DFIT_R2 | $B$41 | R² of the linear-flow line |
| DFIT_ClosureCheck | $B$42 | Closure check verdict |
| DFIT_ClosureCheckNote | $C$42 | Closure check comment |
| DFIT_PoreCheck | $B$43 | Pore-pressure flag verdict |
| DFIT_PoreCheckNote | $C$43 | Pore-pressure flag comment |
| DFIT_Results | $B$19:$B$43 | The ISIP, the tangent and the closure pick, closure stress, net pressure and efficiency, the after-closure pore pressure, and the two checks |
| DFIT_MinN | $B$47 | Fewest points a line is fitted to |
| DFIT_Data | $A$54:$B$96 | The falloff: Δt since shut-in and the surface pressure, synthetic until you paste a gauge's |
| DFIT_Analysis | $C$54:$K$96 | Per point: the bottomhole pressure, G, dP/dG and G·dP/dG, the tangent, the off-tangent flag, FL, the linear-flow window and its line |
| DFIT_GPlot | $C$54:$G$82 | G-Function Plot |

---

## Related Blueprints
- [Fracture Pump Schedule (Nolte Pad and Proppant Ramp)](/blueprint/po.frac.pump.schedule.md)
- [Fracture Design Screening (Unified Fracture Design)](/blueprint/po.frac.design.screening.md)
- [Fracture Geometry Models Compared](/blueprint/po.frac.kgd.radial.geometry.md)
- [Proppant Settling and Transport](/blueprint/po.frac.proppant.settling.md)
- [Tubing Stress and Movement](/blueprint/po.de.tubing.stress.md)
- [Surge and Swab Trip Speed](/blueprint/po.de.surge.swab.md)

