PO.PTA.DST.Superposition
Description
The Horner time ratio of a shut-in that follows more than one flow period, as a drill-stem test's final shut-in follows its initial flow, initial shut-in and final flow. Plot the shut-in pressure against it on a reversed log axis, exactly as against (tp + Δt)/Δt: the straight line's slope gives k and its value at a ratio of 1 gives p*. After a single flow period it is the Horner ratio itself. The rate history is laid out as `PO.PTA.Pw.VW`'s `prod_data`.
Formula
=LAMBDA(t, rate_history, LET(
ts, INDEX(rate_history, 0, 1),
q, INDEX(rate_history, 0, 2),
i, SEQUENCE(ROWS(ts)),
active, --(ts<t),
q_prev, MMULT(--(i=TRANSPOSE(i)+1), q),
q_ref, INDEX(q, MAX(active*(q<>0)*i)),
q_now, INDEX(q, MAX(active*i)),
x, SUM(active*(q-q_prev)*LOG10(active*(t-ts)+(1-active)))/q_ref,
IF(q_now<>0, NA(), 10^x)))Parameters
| Parameter | Unit | Description |
|---|---|---|
t |
h | Elapsed time since the test opened, inside a shut-in |
rate_history |
h, bbl/d | One row per rate step: its start time in the first column, rising, and the rate from then on in the second (0 for a shut-in) |
Examples
| Invocation | Expected |
|---|---|
=PO.PTA.DST.Superposition(6, {0,200;0.05,0;1,250;5,0}) |
5.033585293 |
=PO.PTA.DST.Superposition(5.5, {0,200;0.05,0;1,250;5,0}) |
9.065994666 |
=PO.PTA.DST.Superposition(11, {0,200;0.05,0;1,250;5,0}) |
1.672752172 |
=PO.PTA.DST.Superposition(0.5, {0,200;0.05,0;1,250;5,0}) |
1.111111111 |
=PO.PTA.DST.Superposition(58, {0,250;48,0}) |
5.8 |