Pool Water Chemistry (Warning: Can Get Technical)

[chem geek]

Hope you had a fine vacation Richard.

The speadsheet is working fine for me now. I had to uncheck the Solver in "Add-Ins". Thanks.

Couple of questions:
1) Can I change the concentration of Sodium Hypo? You have 11.9% in there. I use the 6% bleach.
2) I don't know what my Total Sulfates or Total Borates are. Can I still get accurate results using the spreadsheet?

I finally figured out how to remove Excel's thinking that there were references to Solver (when there weren't any more) so will update the spreadsheet with that fixed soon [EDIT] just uploaded an update today 8/27/06 with the Solver references removed [END-EDIT] [EDIT] and again today 8/28/06 with further improvements listing different concentrations for bleach in a pull-down menu. [END-EDIT]

Yes, you can get accurate results without the Total Sulfates or Borates entered, unless you have intentionally added lots of Borates (say, more than 30 ppm). The sulfates are there in case one has very high sulfate water (> 100 ppm) in which case this starts to affect the calcium carbonate water balance.

Richard