PO.PTA.Bilinear.Fit


Description

The bilinear-flow specialized plot of a well with a finite-conductivity vertical fracture: the least-squares line through the pressure drop against the fourth root of time over the points you pass, and the fracture conductivity kf·w its slope gives. In bilinear flow the fluid moves linearly along the fracture and linearly from the formation into it at the same time. The log-log derivative then has a slope of ¼, and Δp plots as a straight line through the origin against Δt^¼. Pass only the points inside that quarter-slope window, for example with `FILTER`. The intercept should be close to zero; a large one points to fracture-face or choked-fracture skin, or to points outside the window.

Formula

=LAMBDA(t, dp, q, B, mu, h, phi, ct, k, output, LET( x, t^0.25, m, SLOPE(dp, x), icpt, INTERCEPT(dp, x), kfw, (141.2*2.4508334*0.0002637^0.25*q*B*mu/(h*m))^2/SQRT(phi*mu*ct*k), IF(m<=0, NA(), IF(output="m", m, IF(output="b", icpt, IF(output="kfw", kfw, NA()))))))

Parameters

Parameter Unit Description
t h Elapsed times of the bilinear-flow points, all > 0
dp psi Pressure drop pi − pwf at each time
q bbl/d Flow rate
B bbl/STB Formation volume factor
mu cp Viscosity
h ft Net pay thickness
phi fraction Porosity
ct 1/psi Total compressibility
k md Formation permeability, from radial flow or another test
output text "m" slope [psi/h^¼], "b" intercept [psi] or "kfw" fracture conductivity kf·w [md·ft]

Examples

Invocation Expected
=PO.PTA.Bilinear.Fit({1;2;4;8}, {392.74784542834624;467.0585321853783;555.4293295975795;660.5205106386328}, 200, 1.2, 0.8, 50, 0.08, 0.000012, 0.5, "kfw") 300
=PO.PTA.Bilinear.Fit({1;2;4;8}, {392.74784542834624;467.0585321853783;555.4293295975795;660.5205106386328}, 200, 1.2, 0.8, 50, 0.08, 0.000012, 0.5, "m") 392.7478454
=PO.PTA.Bilinear.Fit({1;2;4;8}, {392.74784542834624;467.0585321853783;555.4293295975795;660.5205106386328}, 200, 1.2, 0.8, 50, 0.08, 0.000012, 0.5, "b") 0
=PO.PTA.Bilinear.Fit({1;2;4;8}, {555.4293295975792;660.5205106386328;785.4956908566927;934.1170643707567}, 200, 1.2, 0.8, 50, 0.08, 0.000012, 0.5, "kfw") 150
=PO.PTA.Bilinear.Fit({4;6;8;10;12}, {547.4497;604.128;648.3408;685.0614;716.4336}, 200, 1.2, 0.8, 50, 0.08, 0.000012, 0.5, "kfw") 323.4375053
=PO.PTA.Bilinear.Fit({4;6;8;10;12}, {547.4497;604.128;648.3408;685.0614;716.4336}, 200, 1.2, 0.8, 50, 0.08, 0.000012, 0.5, "b") 12.34336464
=IF(ISNA(PO.PTA.Bilinear.Fit({1;2;4}, {300;290;280}, 200, 1.2, 0.8, 50, 0.08, 0.000012, 0.5, "kfw")), 1, 0) 1

Need a custom LAMBDA? Suggest a New Lambda