PO.FRAC.DFIT.GFunction
Description
Nolte's G-function of a fracture falloff, the time axis of the G-function plot that a diagnostic fracture injection test (DFIT) is read on. You pass the shut-in times, the pumping time and the falloff pressures. The function returns, as a column, the dimensionless shut-in time ΔtD, Nolte's g(ΔtD), G(ΔtD), the pressure derivative dP/dG, or the superposition derivative G·dP/dG. While the fracture is open and leakoff is normal, the pressure falls on a straight line against G and G·dP/dG on a straight line through the origin. Closure is where G·dP/dG leaves that line. Pressure-dependent leakoff, height recession and tip extension each bend it in their own way. The leakoff exponent α is a required mode: 1 for a fracture whose area grows linearly with time (low leakoff, high efficiency, the usual choice) and 0.5 for one whose area grows with √t (high leakoff, low efficiency).
Formula
=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)))))Parameters
| Parameter | Unit | Description |
|---|---|---|
dt |
min | Shut-in time of each falloff point, from the end of pumping (any unit, the same as tp) |
tp |
min | Pumping time, the injection's duration |
p |
psi | Bottomhole pressure at each shut-in time, at least 2 points |
alpha |
— | Leakoff exponent: 1 (area grows linearly with time) or 0.5 (area grows with √t) |
output |
text | Column of "dtD" (Δt/tp), "gNolte" g(ΔtD), "G" G(ΔtD), "dPdG" −dp/dG [psi] or "GdPdG" G·dP/dG [psi] |
Examples
| Invocation | Expected |
|---|---|
=PO.FRAC.DFIT.GFunction({0;5;10;20;40}, 20, {5000;4953.731750571215;4917.9076398816915;4859.361843312254;4767.807741906944}, 1, "dtD") |
[0, 0.25, 0.5, 1, 2] |
=PO.FRAC.DFIT.GFunction({0;5;10;20;40}, 20, {5000;4953.731750571215;4917.9076398816915;4859.361843312254;4767.807741906944}, 1, "gNolte") |
[1.333333333, 1.696723315, 1.978085222, 2.437902833, 3.156967064] |
=PO.FRAC.DFIT.GFunction({0;5;10;20;40}, 20, {5000;4953.731750571215;4917.9076398816915;4859.361843312254;4767.807741906944}, 1, "G") |
[0, 0.4626824943, 0.8209236012, 1.406381567, 2.321922581] |
=PO.FRAC.DFIT.GFunction({0;5;10;20;40}, 20, {5000;4953.731750571215;4917.9076398816915;4859.361843312254;4767.807741906944}, 1, "dPdG") |
[100, 100, 100, 100, 100] |
=PO.FRAC.DFIT.GFunction({0;5;10;20;40}, 20, {5000;4953.731750571215;4917.9076398816915;4859.361843312254;4767.807741906944}, 1, "GdPdG") |
[0, 46.26824943, 82.09236012, 140.6381567, 232.1922581] |
=PO.FRAC.DFIT.GFunction({0;5;10;20;40}, 20, {5000;4900;4830;4700;4500}, 1, "dPdG") |
[216.1309348, 207.0838258, 211.9319662, 219.8535805, 218.4500715] |
=PO.FRAC.DFIT.GFunction({0;5;10;20;40}, 20, {5000;4900;4830;4700;4500}, 1, "GdPdG") |
[0, 95.81406104, 173.9799529, 309.198023, 507.2241539] |
=PO.FRAC.DFIT.GFunction({0;5;10;20;40}, 20, {5000;4900;4830;4700;4500}, 0.5, "G") |
[0, 0.3987016841, 0.7248366601, 1.273239545, 2.151591944] |
=PO.FRAC.DFIT.GFunction({0;5;10;20;40}, 20, {5000;4900;4830;4700;4500}, 0.5, "gNolte") |
[1.570796327, 1.883935897, 2.140081708, 2.570796327, 3.260652688] |
=PO.FRAC.DFIT.GFunction({0;80}, 20, {5000;4500}, 1, "gNolte") |
[1.333333333, 4.240453183] |
=PO.FRAC.DFIT.GFunction({0;80}, 20, {5000;4500}, 0.5, "gNolte") |
[1.570796327, 4.318238045] |
=IF(ISNA(PO.FRAC.DFIT.GFunction({0;5;10}, 20, {5000;4900;4830}, 0.75, "G")), 1, 0) |
1 |