- Jul 17, 2010
- 13
- Pool Size
- 27500
- Surface
- Plaster
- Chlorine
- Salt Water Generator
- SWG Type
- Jandy Aquapure 1400
Been maintaining my own spreadsheet over the years but now that I have a newly installed granite pool I'm also going to start watching CSI metrics more than I have in the past when I had vinyl pools.
I track the following values each week throughout the season...
2018 Season
Date
FC (3/5/28/70; 4/6/31/80)
CC
TC
T/A (60-80)
CH (350-450)
CYA (70-80)
pH (7.2-7.8) ideal 7.4-7.6
Temp
Salt (3000-3500)
Borates (30-50)
CSI [btwn -.60 <-> +.60]
Pressure Gauge PSI
I've looked for hours ( unsuccessfully ) if someone created a formula that one would use in an excel spreadsheet to calculate CSI. What I do now is enter the values in pool math and enter the value manually in my spreadsheet... although not a major problem, it would be much easier if that formula that's in the pool calculator be converted to a 'formula' for excel to use.
Just asking if someone perhaps is already doing that and if they are willing to share?
Thanks in advance
---John
I track the following values each week throughout the season...
2018 Season
Date
FC (3/5/28/70; 4/6/31/80)
CC
TC
T/A (60-80)
CH (350-450)
CYA (70-80)
pH (7.2-7.8) ideal 7.4-7.6
Temp
Salt (3000-3500)
Borates (30-50)
CSI [btwn -.60 <-> +.60]
Pressure Gauge PSI
I've looked for hours ( unsuccessfully ) if someone created a formula that one would use in an excel spreadsheet to calculate CSI. What I do now is enter the values in pool math and enter the value manually in my spreadsheet... although not a major problem, it would be much easier if that formula that's in the pool calculator be converted to a 'formula' for excel to use.
Just asking if someone perhaps is already doing that and if they are willing to share?
Thanks in advance
---John