A couple of items. First, adding 50 ppm of Borates also increases the TA by 6.1 ppm. However, the buffering of pH from Borates is more than would be implied by this small TA increase because most of the Borate "buffer" is in the form of the neutral Boric Acid species that does not get reported in TA. Technically, at normal pool pH, the Borate buffer is more effective at resisting a rise in pH than a lowering of pH while the Carbonate buffer is the opposite, though the Carbonate buffer is closer to being equal in its resistance in both directions. The TA only measures the buffering capability to resist a lowering in pH (i.e. to resist acidic changes) and does not measure any buffering capacity to resist a rise in pH.
As for the spreadsheet, it may be found at the end of the first post in this thread in The China Shop under the heading "Spreadsheet for Detailed Calculations" where there is a link called PoolEquations.zip
This spreadsheet is in The China Shop for a reason. It is very complex, highly technical, and will scare away vampires. Nevertheless, if you ignore the lower part of the spreadsheet where the detailed calculations are performed and ignore all the chemical equations in the descriptions, it might be OK to use. There are no instructions with it and it is not designed for public consumption. My plan was to someday try and distill into simpler though somewhat less accurate formulas some of what is done so that it could be included into Michael's BleachCalc (he already has a lot of it -- though his acid/base calculations are only accurate at a fixed "typical" starting pH and TA) and also into a simpler spreadsheet form for Mac users (since BleachCalc is only for the PC). This is a large task that I have not gotten around to yet.
Richard
Bookmarks