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

Need a custom LAMBDA? Suggest a New Lambda