I created a very simple ss to track pool conditions based on the recommended levels in pool school. It also color codes the cells in your out of range based on whether you have an algae problem or not. I used 50 ppm cause I am currently battling black algae again. The charts tab also plots your results so you can visually see the impacts of adding chemicals. I am sure there is a better one out there but I am bored as heck at work today so I just thew this thing together.
Simple Excel Spreadsheet to track pool conditions
- Thread starter bhodge
- Start date
It will not allow me to update .xlsx files and regular .xls doesn't support all the conditional formatting it uses. I renamed to .txt to upload, download and rename to .xlsx and see if it works
Thanks Much. :-D
I opened in Open Office but had to open OO first and then file, open.
Just thinking the other day I'd love to have something like this. Really, Really, Really appreciate.
gg=alice
I opened in Open Office but had to open OO first and then file, open.
Just thinking the other day I'd love to have something like this. Really, Really, Really appreciate.
gg=alice
Just downloaded and it looks great, good work! Got 2 quick suggestions, add the conditional formating to the CC row (over 0.5 = red) and make sheet 3 a chart for just chlorine levels, we tend to worry more about FC then the others so a chart same size as the first with a smaller scale would make seeing our FC trends much easier. Great work!
Oh just noticed the rules for conditional formating are coded and not using the values from the "min max" column, could that be changed?
Oh just noticed the rules for conditional formating are coded and not using the values from the "min max" column, could that be changed?
coog61
0
I downloaded and changed the extension to *.xls, then opened in Excel, but still can't read. How do it convert this?
Thanks
Dave
Thanks
Dave
flyboy320
Well-known member
