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 |