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

Need a custom LAMBDA? Suggest a New Lambda