PO.PE.Chan.WORDerivative
Description
The time derivative of the water-oil ratio, WOR′ = dWOR/dt, at one point of a well's production history: the second curve of Chan's water-control diagnostic. Plotted with WOR against time on log-log axes, its trend tells the excess water's source. A WOR′ that keeps rising with a positive slope is near-wellbore channelling or a high-permeability layer watering out; a WOR′ whose slope turns negative after breakthrough, while WOR still climbs slowly, is bottom-water coning, the case a downhole water sink treats.
Formula
=LAMBDA(time, wor, at, LET(
n, COUNT(time),
k, MATCH(at, time, 0),
k_lo, MAX(1, k-1),
k_hi, MIN(n, k+1),
t_k, INDEX(time, k),
t_lo, INDEX(time, k_lo),
t_hi, INDEX(time, k_hi),
w_k, INDEX(wor, k),
w_lo, INDEX(wor, k_lo),
w_hi, INDEX(wor, k_hi),
IF(k=1, (w_hi-w_k)/(t_hi-t_k), IF(k=n, (w_k-w_lo)/(t_k-t_lo), ((w_k-w_lo)/(t_k-t_lo)*(t_hi-t_k)+(w_hi-w_k)/(t_hi-t_k)*(t_k-t_lo))/(t_hi-t_lo)))))Parameters
| Parameter | Unit | Description |
|---|---|---|
time |
day | Production times, one column or one row, rising, each value once |
wor |
— | The water-oil ratio (water rate over oil rate) at each time, in the same layout |
at |
day | The time to evaluate at, one of the values in time |
Examples
| Invocation | Expected |
|---|---|
=PO.PE.Chan.WORDerivative({30;60;90;150}, {0.2;0.35;0.45;0.55}, 90) |
0.002777778 |
=PO.PE.Chan.WORDerivative({30;60;90;150}, {0.2;0.35;0.45;0.55}, 60) |
0.004166667 |
=PO.PE.Chan.WORDerivative({30;60;90;150}, {0.2;0.35;0.45;0.55}, 30) |
0.005 |
=PO.PE.Chan.WORDerivative({30;60;90;150}, {0.2;0.35;0.45;0.55}, 150) |
0.001666667 |
=PO.PE.Chan.WORDerivative({10,20,40}, {0.1,0.3,0.5}, 20) |
0.016666667 |