Pool Water Chemistry (Warning: Can Get Technical)

[chem geek]

I updated the PoolEquations.zip spreadsheet as well as the graphs and charts in the first post in this thread (and the links) to reflect the fact that FC (and CC and TC) are measure in ppm of Cl2 equivalent and not as HOCl. I also changed the HOCl concentration to also be in ppm of Cl2 equivalent so all chlorine is measured in the same way and this made the changes to everything rather minor.

I also added the Borax and Borates (ppm Boron) to the spreadsheet, though I need to do some cleanup to make it easier to use. I still need to replace the Solver calculation with my own iteration so that the spreadsheet will work reliably on a PC (it works fine on my Mac).

[EDIT] I made an initial error and have now corrected it so be sure that the first line of the spreadsheet not only gives the date 8/15/06, but also has the word "CORRECTED2" after this date. [END-EDIT]

Richard