PO.FA.Scale.MixRatio


Description

The ion concentrations of a mixture of formation water and injection water, the input a scale-compatibility study needs at each mixing ratio. When seawater breaks through to a producer, the barium and strontium of the formation water meet the sulfate of the seawater, and the mixture can be far more supersaturated in barite or celestite than either water alone. Each ion mixes in proportion to the volumes: c = (1 − f)·c_formation + f·c_injection, with f the injection water's volume fraction. Pass the two analyses as matching rows of ions and a single fraction for one mixture, or a column of fractions for the whole mixing table; feed each mixed analysis to `PO.FA.Scale.SI.OddoTomson` in sheet cells.

Formula

=LAMBDA(formation, injection, fraction, IF(OR(fraction<0, fraction>1), NA(), formation*(1-fraction)+injection*fraction))

Parameters

Parameter Unit Description
formation mg/L Formation water: one ion's concentration or a row of them
injection mg/L Injection water, the same ions in the same order and shape
fraction frac Injection water's volume fraction of the mixture, 0 to 1: a value, or a column of values for a mixing table

Examples

Invocation Expected
=PO.FA.Scale.MixRatio({2000,300,300,250,10,500}, {412,1290,8,0.01,2712,142}, 0.5) [1206, 795, 154, 125.005, 1361, 321]
=PO.FA.Scale.MixRatio({2000,300,300,250,10,500}, {412,1290,8,0.01,2712,142}, 0.3) [1523.6, 597, 212.4, 175.003, 820.6, 392.6]
=PO.FA.Scale.MixRatio(250, 0.01, {0;0.25;0.5;0.75;1}) [250, 187.5025, 125.005, 62.5075, 0.01]
=PO.FA.Scale.MixRatio({2000,300}, {412,1290}, {0;0.5;1}) [2000, 300, 1206, 795, 412, 1290]
=IF(ISNA(PO.FA.Scale.MixRatio({2000,300}, {412,1290}, 1.2)), 1, 0) 1

Need a custom LAMBDA? Suggest a New Lambda