Spreadsheet: 699047d1602348739-need-formula-for-cell-minus-2-lookups-and-then-use-a-third-lookup-sat-index-calculation-example-help-101020
Sheet: Sheet1

 |  |  |  |  |  | New Saturation Index |  | Industry Uses this Standard with Tables
 |  |  |  |  | Insert values into blue cells |  |  | ENTER WATER CONDITIONS IN G4:G10 ONLY
 |  |  |  |  |  | Measured | Factor
 |  |  |  |  | pH* | 7.5 |  |  | Saturation Index Formula
 |  |  |  |  | CH* | 350 |  |  | SI = pH + TF + CF + (TA – (CYA x F) –(BF)) – TDS F
 |  |  |  |  | TA* | 90
 |  |  |  |  | Temp* | 80 |  |  | Balanced water is - 0.3 to + 0.5
 |  |  |  |  | TDS* | 900 |  |  | Negative values indicate corrosive water
 |  |  |  |  | CYA* | 50 |  |  | Positive values indicate scale forming water
 |  |  |  |  | B | 50
 |  |  |  |  | SI
 |  |  |  |  | * Required Input
 |  |  |  |  |  |  |  | `
 |  |  |  |  | CH (Calcium Hardness) |  |  | TA (Total Alkalinity) |  |  | Temp
 |  |  |  |  | Expressed as ppm |  |  | Expressed as ppm |  |  |  | Temperature Factor
 |  |  |  |  | CaCO3 | = | CF | CaCO3 | = | AF | ° F | = | TF
 |  |  |  |  | 5 |  | 0.3 | 5 |  | 0.7 | 32 |  | 0
 |  |  |  |  | 25 |  | 1 | 25 |  | 1.4 | 37 |  | 0.06
 |  |  |  |  | 50 |  | 1.3 | 50 |  | 1.7 | 46 |  | 0.16
 |  |  |  |  | 63 |  | 1.4 | 63 |  | 1.8 | 53 |  | 0.24
 |  |  |  |  | 75 |  | 1.5 | 72 |  | 1.9 | 60 |  | 0.32
 |  |  |  |  | 100 |  | 1.6 | 96 |  | 2 | 66 |  | 0.38
 |  |  |  |  | 124 |  | 1.7 | 124 |  | 2.1 | 76 |  | 0.49
 |  |  |  |  | 150 |  | 1.8 | 146 |  | 2.2 | 84 |  | 0.57
 |  |  |  |  | 200 |  | 1.9 | 194 |  | 2.3 | 94 |  | 0.68
 |  |  |  |  | 246 |  | 2 | 246 |  | 2.4 | 105 |  | 0.79
 |  |  |  |  | 300 |  | 2.1 | 300 |  | 2.5 | Changed 9/28/20
 |  |  |  |  | 400 |  | 2.2 | 400 |  | 2.6
 |  |  |  |  | 800 |  | 2.5 | 800 |  | 2.9
 |  |  |  |  | TDS, ppm |  |  | [NAME] (Cyanuric Acid), ppm |  |  | B (Borate), ppm |  | 50 ppm | 70 ppm
 |  |  |  |  | TDS | = | Factor | pH | = | Factor | pH | = | ppm reduction | ppm reduction
 |  |  |  |  | 100 |  | -12.1 | 6.2 |  | 0.08 | 6.2 |  | 0.29 | 0.41
 |  |  |  |  | 500 |  | -12.14 | 6.3 |  | 0.09 | 6.3 |  | 0.37 | 0.51
 |  |  |  |  | 950 |  | -12.2 | 6.4 |  | 0.11 | 6.4 |  | 0.46 | 0.65
 |  |  |  |  | 1500 |  | -12.25 | 6.5 |  | 0.13 | 6.5 |  | 0.58 | 0.81
 |  |  |  |  | 1950 |  | -12.29 | 6.6 |  | 0.15 | 6.6 |  | 0.73 | 1.02
 |  |  |  |  | 2500 |  | -12.32 | 6.7 |  | 0.17 | 6.7 |  | 0.92 | 1.29
 |  |  |  |  | 3000 |  | -12.35 | 6.8 |  | 0.19 | 6.8 |  | 1.15 | 1.62
 |  |  |  |  | 4000 |  | -12.39 | 6.9 |  | 0.21 | 6.9 |  | 1.45 | 2.03
 |  |  |  |  | 5000 |  | -12.43 | 7 |  | 0.23 | 7 |  | 1.82 | 2.55
 |  |  |  |  |  |  |  | 7.1 |  | 0.25 | 7.1 |  | 2.39 | 3.21
 |  |  |  |  |  |  |  | 7.2 |  | 0.27 | 7.2 |  | 2.88 | 4.03
 |  |  |  |  |  |  |  | 7.3 |  | 0.29 | 7.3 |  | 3.61 | 5.06
 |  |  |  |  |  |  |  | 7.4 |  | 0.31 | 7.4 |  | 4.53 | 6.34
 |  |  |  |  |  |  |  | 7.5 |  | 0.32 | 7.5 |  | 5.67 | 7.94
 |  |  |  |  |  |  |  | 7.6 |  | 0.33 | 7.6 |  | 7.1 | 9.93
 |  |  |  |  |  |  |  | 7.7 |  | 0.34 | 7.7 |  | 8.86 | 12.41
 |  |  |  |  |  |  |  | 7.8 |  | 0.35 | 7.8 |  | 11.05 | 15.47
 |  |  |  |  |  |  |  | 7.9 |  | 0.36 | 7.9 |  | 13.74 | 19.24
 |  |  |  |  |  |  |  | 8 |  | 0.36 | 8 |  | 17.04 | 23.85
 |  |  |  |  |  |  |  | 8.1 |  | 0.36 | 8.1 |  | 21.05 | 29.46
 |  |  |  |  |  |  |  | 8.4 |  | 0.36 | 8.2 |  | 25.89 | 36.24
 |  |  |  |  |  |  |  | 8.5 |  | 0.36 | 8.3 |  | 31.67 | 44.34
 |  |  |  |  |  |  |  |  |  |  | 8.4 |  | 38.51 | 53.91
 |  |  |  |  |  |  |  |  |  |  | 8.5 |  | 46.48 | 65.07