Pool Water Chemistry (Warning: Can Get Technical)

[chem geek]

ubalr1,

I'm sorry you now get the Solver error. I assume this only occurs when clicking on the "Calculate pH/TA" button, right? This has been reported as very flaky on a PC and I was able to reproduce the problem on a PC and it sometimes would work and then it wouldn't, so I don't think it's only the version change but something very strange with PC's solver getting a spreadsheet created on the Mac.

I plan to replace the use of Solver, but am going on vacation (to Canada) for 2-1/2 weeks. I'm taking my computer and one of the things I'll do during down time (on the train, for example) is work on the spreadsheet. Yes, I consider that fun (shows how geeky I am).

I don't have the earlier version myself anymore. As soon as I replace the Solver with my own iterative code, I'll post it and let everyone know by a post to this thread. Again, sorry you got "hooked" with a working version. It's pretty neat when it works, eh?

I just put up the latest version just in case that one works for you. You can download it and try it out.

Richard