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

Need a custom LAMBDA? Suggest a New Lambda