Agreed, the formula does not lie but there are outside variables and the input variables may be off. For example, alot of rain like we have had in the last few months or cloud cover changes the PPM demand.
FC demand can vary based on a lot of conditions, sunshine amount, temperature and pool use. It can take a while for you to learn your pool's needs. I usually have to adjust mine based on the season, spring and fall is one setting and mid summer is another setting. If I have a huge FC demand like a party, I will just manually dose using liquid chlorine so I don't have to fool with the % or run time. Tracking your FC over time will help you figure out the rhythm. It is best to overshoot your FC vs undershoot.
Matt...next step for you bud....have someone build this into an app, then put it on the app store for $1.99 or whatever.
great job!
Beta 1.3 | 02/22/2018 | Conditional formating to show good, ok, and bad values for percent table, adjustable in Setup tab |
Add sliders for Calculate Runtime and Calculate SWG % input cells | ||
Use ceiling function to round the SWG% in the Calculate SWG % | ||
Bold Column in SWG % table based on the FC demand ppm cell | ||
Beta 1.4 | 03/19/2018 | Update instructions |
Add description of colored ranges | ||
Renamed "Min Runtime" to "Max Acceptable" and Max Runtime to Max Possible (24) | ||
Added setting for SWG % increments, only effects "Calculate SWG %" in bottom left |
I made some changes/updates to the SWG Runtime Calculator:
Beta 1.3 02/22/2018 Conditional formating to show good, ok, and bad values for percent table, adjustable in Setup tab Add sliders for Calculate Runtime and Calculate SWG % input cells Use ceiling function to round the SWG% in the Calculate SWG % Bold Column in SWG % table based on the FC demand ppm cell Beta 1.4 03/19/2018 Update instructions Add description of colored ranges Renamed "Min Runtime" to "Max Acceptable" and Max Runtime to Max Possible (24) Added setting for SWG % increments, only effects "Calculate SWG %" in bottom left
Download: SWG Runtime Calculator | Github
Just checked it out and it worked fine with no glitches. The helpful links section only has 1 working link (chlorine/cya chart and water balance for sag are not set as links). Thanks for the update!!
Just checked it out and it worked fine with no glitches. The helpful links section only has 1 working link (chlorine/cya chart and water balance for sag are not set as links). Thanks for the update!!
1.4.1 | 05/18/2018 | Fixed Helpful Links hyperlinks |
Added link for Recommended Pool Levels by Surface Type |
Just fixed the weirdly missing links. I blame Microsoft, lol
1.4.1 05/18/2018 Fixed Helpful Links hyperlinks Added link for Recommended Pool Levels by Surface Type
Download: SWG Runtime Calculator | Github
- - - Updated - - -
BTW, that download link will always point to the latest release.
Star and watch the Github repository to get notifications for any updates.