I've been the proud owner of my first adult-life pool since the end of 2017. The pool is chlorine and about 12,000 gallons with spa attached. I quickly made friends with my local pool shop and have learned quite a bit. Last year, I bought an electronic pool test kit, which has been extremely helpful in getting the balance just right. My wife and I love the feeling of well-balanced water as it makes all the difference, especially for my wife whose skin can get easily irritated.
I'm a very analytical person and, as such, created my own spreadsheet in Excel for tracking my pool tests historically, but also calculating things like the Combined Chlorine (CCL), True Alkalinity (Alk), and Saturation Index (SI). I'm on this forum seeking knowledge for the next step in my spreadsheet: What To Do. I was reading a lot yesterday and one thing I came across was the JSPSI, which was a wealth of information. I now have very accurate calculations for adjusting True Alkalinity (Alk), both with sodium bicarbonate and muriatic acid. What is currently eluding me is the more complex calculation for pH. My end goal is to have my spreadsheet be my one-stop shop for all my water-balance needs instead of referencing vague tables or phone apps where I have to re-enter the information.
I'm wondering if anyone can help me or point me in the right direction for finding an accurate calculation (not a table) for the addition of muriatic acid (lower) and soda ash (raise). Any help would be greatly appreciated!
I'm a very analytical person and, as such, created my own spreadsheet in Excel for tracking my pool tests historically, but also calculating things like the Combined Chlorine (CCL), True Alkalinity (Alk), and Saturation Index (SI). I'm on this forum seeking knowledge for the next step in my spreadsheet: What To Do. I was reading a lot yesterday and one thing I came across was the JSPSI, which was a wealth of information. I now have very accurate calculations for adjusting True Alkalinity (Alk), both with sodium bicarbonate and muriatic acid. What is currently eluding me is the more complex calculation for pH. My end goal is to have my spreadsheet be my one-stop shop for all my water-balance needs instead of referencing vague tables or phone apps where I have to re-enter the information.
I'm wondering if anyone can help me or point me in the right direction for finding an accurate calculation (not a table) for the addition of muriatic acid (lower) and soda ash (raise). Any help would be greatly appreciated!