Thanks again to all..
Yooper.. You mentioned my Cl is high. It's only 8ppm.. according to EZ the acceptable range is 0-150
The whole thing is fun.. but, frustrating at the same time.. Considering my water profile is constant.. at least for this learning process.. it changes a bit during the year..
Ca: 20ppm; Mg 18.5ppm; Na 8ppm; Cl: 8ppm; Sulfate(SO4): 18.5ppm; HCO3: 158ppm; Total Alkalinity: 130ppm and Total Hardness: 131ppm.
With just 2G mash water and 2G sparge water.. UNDILUTED with the grains I'm using, the pH is 5.68.. a bit high and the Ca is low at 20ppm (range should be 50-150) and the SO4 is low at 19ppm (should be 50-350) and the Cl/SO4 ratio is low at .43 and should be above .77
If I modify the water by 50% RO, the pH drops a bit to 5.63; Ca drops to 10; SO4 drops to 9 but the Mg drops to 9 and should be between 10-30ppm.. of course the Na and Cl cut in half too.. but the ratio is still at .43
However, if I take the 50/50 water and add 1gm Gypsum, 1.5gm CaCl2, 1gm MgSO4 and 1 oz of acidulated malt... everything falls into place beautifully for the generic spreadsheet. The resulting water profile is
Ca: 94(50-150); Mg: 15(10-30); Na:4(0-150); Cl: 100(0-250); SO4: 109(50-350); Cl/SO4 ratio: .92(.77-1.3).. What isn't beautiful is that the effective Alkalinity is reading -39 and the Residual Alkalinity is -115. Also my CA and SO4 seem a bit low.
So, I'm at the point of... How do I get my alkalinity up while maintaining salt balances and pH levels.. arggh.
I know I'm over thinking this.. but, as I said, It's fun/frustrating..
Now, This spreadsheet doesn't take into consideration STYLE. It seems if I want to brew a pale ale vs a dark stout.. some numbers would want to change..