Pool Water Chemistry (Warning: Can Get Technical)

[ubalr1]

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

Darn! The previous version was working fine for me (PC). Now this version gives me the "solver error". I must have installed it wrong, or did not remove the first one correctly. Any other issues reported with this new version.

Double darn!! The original version is no longer available. I can't even go back to that one. I'm drifting aimlessly now, I was getting very attached to that 'working' spreadsheet.