PO.CO.Damage.Flow


Description

Returns how much of its undamaged productivity a well delivers, from the PI it has and the PI it would have with no skin. The measure picks the form. "FE" is the flow efficiency J/J_ideal. "DR" is the damage ratio J_ideal/J, the factor a skin-free well would make more at the same drawdown. "DF" is the damage factor 1 − J/J_ideal, the share of the rate the skin costs. A damaged well's flow efficiency is below 1 and its damage ratio above 1; a stimulated well's are the other way round.

Formula

=LAMBDA(j_actual, j_ideal, measure, IF((j_actual<=0)+(j_ideal<=0), NA(), IF(measure="FE", j_actual/j_ideal, IF(measure="DR", j_ideal/j_actual, IF(measure="DF", 1-j_actual/j_ideal, NA())))))

Parameters

Parameter Unit Description
j_actual STB/d/psi The well's PI, with its skin; above 0
j_ideal STB/d/psi Its PI with no skin; above 0
measure — "FE" flow efficiency, "DR" damage ratio or "DF" damage factor

Examples

Invocation Expected
=PO.CO.Damage.Flow(1.2692011, 2.1047526, "FE") 0.603017
=PO.CO.Damage.Flow(1.2692011, 2.1047526, "DR") 1.658329
=PO.CO.Damage.Flow(1.2692011, 2.1047526, "DF") 0.396983
=PO.CO.Damage.Flow(1.5, 2.5, "FE") 0.6
=PO.CO.Damage.Flow(3, 2, "DR") 0.666667

Need a custom LAMBDA? Suggest a New Lambda