I received my Ward Water report and plugged the numbers into the Bru'n Water spreadhseet.
The Sparge Acidification tab is pretty straight forward, I plugged in the few attributes it asks for and based on the target pH it provides the amount of XYZ to add to the water, in this case Lactic Acid.
I am not quite sure how to use the Water Adjustment tab though.
I selected the desired water profile and I see the minerals change based on that and I also see the matching numbers from what I added in the water report tab in the existing water profile.
I am not going to dilute so I left that blank.
In looking at the Water addition section, I gather I need to manually input the different minerals and acid levels to adjust the water, is this correct? If so, how do I handle a situation such as calcium where the desired profile is 55ppm but my current water is 61ppm?
I have a few minerals such as calcium, magnesium, sodium and bicarbonate where the existing water profile exceeds the target/desired profile.
BTW here are the results from the Ward report:
Total Dissolved Solids (TDS) Est, ppm 350
Electrical Conductivity, mmho/cm 0.58
Cations / Anions, me/L 6.8 / 6.6
Sodium, Na: 35
Potassium, K: 16
Calcium, Ca: 61
Magnesium, Mg: 22
Total Hardness, CaCO3: 244
Nitrate, NO3-N: 0.1 (SAFE)
Sulfate, SO4-S: 13
Chloride, Cl: 12
Carbonate, CO3: < 1
Bicarbonate, HCO3: 335
Total Alkalinity, CaCO3: 275