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 |