PO.PTA.Pulse.Analysis
Description
The Kamal-Brigham analysis of a pulse test, without reading their charts. The active well alternates between flowing and shut in. An observation well a distance r away sees a small oscillating pressure on top of the trend. For one pulse you read two things off that response: the time lag tL, from the end of the pulse to the extremum it causes, and the amplitude Δp, the extremum's vertical distance from the line tangent to the curve at the two neighbouring extrema of the opposite kind. The function computes the line-source response of the whole pulse train inside the formula. It finds the diffusivity whose response has the measured lag, reads the dimensionless amplitude off that response, and returns the interwell permeability and the porosity-compressibility product φ·ct. It can also return the two chart ordinates Kamal and Brigham plot, (tL)D/rD² and ΔpD·(tL/ΔtC)², for checking against the charts.
Formula
=LAMBDA(tL, dp, dtC, Fp, n, q, B, mu, h, robs, output, IF(OR(n<2, n<>ROUND(n, 0), Fp<=0, Fp>=1, tL<=0, dp<=0, dtC<=0), NA(), LET(
lam, tL/dtC, nn, 600, jc, SEQUENCE(n+2, 1, 0), xs, jc/2+(Fp-0.5)*(1-(-1)^jc)/2, sgc, (-1)^jc, sgn, (-1)^(n+1), xepv, (n-1)/2+(Fp-0.5)*(1-(-1)^(n-1))/2, xen, n/2+(Fp-0.5)*(1-(-1)^n)/2, xenx, (n+1)/2+(Fp-0.5)*(1-(-1)^(n+1))/2, xenn, (n+2)/2+(Fp-0.5)*(1-(-1)^(n+2))/2, ig, SEQUENCE(nn+1, 1, 0), wz, xenx-xen, dz, xen+wz*ig/nn-TRANSPOSE(xs), pos, (dz>0)*1, dzc, pos*dz+1-pos, lgc, REDUCE(-9, SEQUENCE(121), LAMBDA(acc, i, IF(acc>-9, acc, LET(
aa, 10^(-3.05+0.05*i), dv, MMULT(pos*EXP(-aa/(4*dzc))/dzc, sgc), cnt, SUM((dv*sgn>0)*1), da, SUM((ig=cnt-1)*dv), db, SUM((ig=cnt)*dv), lagx, IF(OR(cnt=0, cnt>nn), 2, wz*(cnt-1+da/(da-db))/nn), IF(lagx>=lam, -3.05+0.05*i, -9))))), lg, REDUCE(lgc-0.05, SEQUENCE(30), LAMBDA(acc, i, LET(
aa, 10^(acc+0.05/2^i), dv, MMULT(pos*EXP(-aa/(4*dzc))/dzc, sgc), cnt, SUM((dv*sgn>0)*1), da, SUM((ig=cnt-1)*dv), db, SUM((ig=cnt)*dv), lagx, IF(OR(cnt=0, cnt>nn), 2, wz*(cnt-1+da/(da-db))/nn), acc+IF(lagx<lam, 0.05/2^i, 0)))), la, 10^lg, lagf, LET(
aa, la, dv, MMULT(pos*EXP(-aa/(4*dzc))/dzc, sgc), cnt, SUM((dv*sgn>0)*1), da, SUM((ig=cnt-1)*dv), db, SUM((ig=cnt)*dv), lagx, IF(OR(cnt=0, cnt>nn), 2, wz*(cnt-1+da/(da-db))/nn), lagx), ik, SEQUENCE(2*nn+1), inw, (ik<=nn)*1, inx, (ik>nn)*(ik<=2*nn), atc, (ik>2*nn)*1, gx, inw*(xepv+(xen-xepv)*ik/nn)+inx*(xenx+(xenn-xenx)*(ik-nn)/nn)+atc*(xen+lam), dx, gx-TRANSPOSE(xs), px, (dx>0)*1, zx, la/(4*(px*dx+1-px)), lo, (zx<=1)*1, eone, lo*(-LN(zx)-0.57721566+zx*(0.99999193+zx*(-0.24991055+zx*(0.05519968+zx*(-0.00976004+zx*0.00107857)))))+(1-lo)*EXP(0-zx)/zx*(zx^4+8.5733287401*zx^3+18.059016973*zx^2+8.6347608925*zx+0.2677737343)/(zx^4+9.5733223454*zx^3+25.6329561486*zx^2+21.0996530827*zx+3.9584969228), pdx, MMULT(px*eone, sgc)/2, big, 10^300, sl, REDUCE(0, SEQUENCE(60), LAMBDA(acc, i, LET(
v, sgn*(pdx-acc*gx), f, MIN(v+(1-inw)*big)-MIN(v+(1-inx)*big), acc+IF(sgn*f<0, 1, -1)*100/2^i))), base, sgn*MIN(sgn*(pdx-sl*gx)+(1-inw)*big), ad, ABS(SUM(atc*pdx)-base-sl*(xen+lam)), perm, 141.2*q*B*mu*ad/(h*dp), IF(OR(lgc<-2.99, ABS(lagf-lam)>0.0001*lam), NA(), IF(output="k", perm, IF(output="phict", 0.0002637*perm*la*dtC/(mu*robs^2), IF(output="tLD", lam/la, IF(output="dpD", ad*lam^2, NA()))))))))Parameters
| Parameter | Unit | Description |
|---|---|---|
tL |
h | Time lag: from the end of pulse n to the extremum it causes at the observation well |
dp |
psi | Pulse amplitude: the extremum's vertical distance from the line tangent to the two neighbouring extrema |
dtC |
h | Cycle length: one flowing period plus one shut-in period |
Fp |
fraction | Pulse ratio F′ = flowing period / cycle length, between 0 and 1 |
n |
count | Pulse number, 2 or more: odd pulses are flowing periods, even pulses shut-in periods (the first flowing period is pulse 1) |
q |
bbl/d | Rate of the active well while flowing (injection as a positive rate gives the same k and φ·ct) |
B |
bbl/STB | Formation volume factor |
mu |
cp | Viscosity |
h |
ft | Net pay thickness |
robs |
ft | Distance between the active and observation wells |
output |
text | "k" permeability [md], "phict" φ·ct [1/psi], "tLD" (tL)D/rD² or "dpD" ΔpD·(tL/ΔtC)² |
Examples
| Invocation | Expected |
|---|---|
=PO.PTA.Pulse.Analysis(0.2531538841644654, 0.6487085461697342, 2, 0.5, 2, 300, 1.2, 1, 30, 400, "k") |
150 |
=PO.PTA.Pulse.Analysis(0.2531538841644654, 0.6487085461697342, 2, 0.5, 2, 300, 1.2, 1, 30, 400, "phict") |
1E-06 |
=PO.PTA.Pulse.Analysis(0.2531538841644654, 0.6487085461697342, 2, 0.5, 2, 300, 1.2, 1, 30, 400, "tLD") |
0.0625843868 |
=PO.PTA.Pulse.Analysis(0.2531538841644654, 0.6487085461697342, 2, 0.5, 2, 300, 1.2, 1, 30, 400, "dpD") |
0.0009200981019 |
=PO.PTA.Pulse.Analysis(0.493182017098043, 0.7780993118067427, 2, 0.5, 5, 300, 1.2, 1, 30, 400, "k") |
150 |
=PO.PTA.Pulse.Analysis(0.493182017098043, 0.7780993118067427, 2, 0.5, 5, 300, 1.2, 1, 30, 400, "phict") |
1E-06 |
=PO.PTA.Pulse.Analysis(0.555192714240345, 0.3593026698667723, 3, 0.3, 4, 250, 1.25, 0.8, 25, 300, "k") |
60 |
=PO.PTA.Pulse.Analysis(0.555192714240345, 0.3593026698667723, 3, 0.3, 4, 250, 1.25, 0.8, 25, 300, "phict") |
2.5E-06 |
=PO.PTA.Pulse.Analysis(2.005473649324714, 0.3246179991947824, 3, 0.3, 3, 250, 1.25, 0.8, 25, 300, "k") |
60 |
=IF(ISNA(PO.PTA.Pulse.Analysis(0.66, 0.63, 2, 0.5, 1, 300, 1.2, 1, 30, 400, "k")), 1, 0) |
1 |