Pool Testing with Excel

Jump to latest Follow Reply
You know that the CYA scale between the lines in logarithmic and you cannot estimate the value between the lines? We round up. If the dot disappears between 20 and 30 we call it 30.

You have the TFP recommendations. I would highlight test values in red or yellow that are outside the recommendations.
 
  • Like
Reactions: KevinL and stinsontx
I ended up adding the CSI tables and calculations, LSI, and RSI formulas are working OK, but don't really plan on trying to work chemical calculations like PoolMath. I'm not that dedicated. :)

The chart visuals are nice to look at. Like you, probably won't be using it all that long once the pool is predictable and stabilized. By that time I'll probably be on to building the Stenner injector system.

Mrs Stinsontx continues to wonder.....

200.gif
 
  • Like
Reactions: Newdude
stinsontx said:
I ended up adding the CSI tables and calculations, LSI, and RSI formulas are working OK, but don't really plan on trying to work chemical calculations like PoolMath. I'm not that dedicated. :)

The chart visuals are nice to look at. Like you, probably won't be using it all that long once the pool is predictable and stabilized. By that time I'll probably be on to building the Stenner injector system.

Mrs Stinsontx continues to wonder.....

View attachment 392930
Click to expand...
Is that spreadsheet something you can share?
 
  • Like
Reactions: KevinL

Enjoying this content?

Support TFP with a donation.

Give Support
While I use PoolMath, and it does all the calcs for me, but, building a spreadsheet like that is still something I would have done, just because I can, and because it looks cool (well to me at least, my wife, she thinks I'm nuts anyway). Much respect for the work, love the charts!

In real life, for me at least, building the spreadsheet, calcs, formulas, macros, and charts would have been the fun part (I know, "fun"?, but to each their own) but would see the use of it waning each week as the work to keep up the data would no longer be fun. Like I said, much respect for the work!
 
  • Like
Reactions: stinsontx
I kind of wish PoolMath had a plotting functionality, but then also don't know how useful it will ultimately be. For example, I test my FC every evening at roughly the same time, let PoolMath tell me how much I need to add, and then I add it. But I don't go remeasure FC after adding. So my PoolMath measurements just indicate chronically low FC. A plot wouldn't show the drift over that 24 hour period. I suppose it would be a nice visual for seasonal daily loss assuming I add to the same target year-round. But again, probably not all that useful.

But nice spreadsheet. Take it next level and build a Shiny app!
 
  • Like
Reactions: cznkane and stinsontx
Thank you for the kind feedback on this spreadsheet. Initially the intention was to help visualize some of the trends/patterns with my swimming pool while learning to apply the TFP method, never as an alternative to the Pool Math application.

Applying the TFP method to my swimming pool has increased the enjoyment of our family swimming pool tremendously. The heat wave in the Houston area was very strong this summer (lots of 100+ degree days), but my pool has never looked better and the maintenance has been so easy. I have even helped a handful of other folks with pool problems by teaching them the TFP method and pointing them to this website. Success!
 
  • Like
Reactions: gingrbredman, RickRude and mknauss
I use PoolMath all the time, but also have a spreadsheet to more easily see trends. When I check the pool, numbers go in Excel, then into PoolMath when I'm done for both pool and hot tub. One interesting calculation I've created is something I call "% Required to Generate". I look at the difference in FC between my current check and my last check, calculate the actual FC generated by my cell during that time (includes current cell % and actual hours run based on my schedule) to get actual real FC loss or gain, and finally calculate the % I need to set my cell to to maintain the current FC. It has helped me tremendously with regards to maintaining a stable FC during rainy and pollen periods.
 
I graph, in excel, my SCG production settings through the season. Makes a nice curve. The info has come in handy a few times when I needed to compare where I was at a particular point vs the production in a previous year.
 
Henryrose88 said:
Question,
I'm trying to setup an excel tracker
What Total Alkalinity Correction Factor tables are you using?
The ones i've seen on the internet show with a TA 50 - CF 1.7, TA of 75 - CF 1.9 .. my calcs are coming out wrong compares to tool math..
Click to expand...

TA doesn't need correction for logging purposes. Once you subtract something from it, it is no longer "Total". All of the Alkalinity is real.

You only have to subtract CYA Alkalinity and (if applicable) Borate Alkalinity to get Carbonate Alkalinity when using that to calculate CSI. That should only be done as part of the CSI-formula, no need to actually log the corrected value.
 

Enjoying this content?

Support TFP with a donation.

Give Support
You must log in or register to reply here.
Thread Status
Hello , This thread has been inactive for over 60 days. New postings here are unlikely to be seen or responded to by other members. For better visibility, consider Starting A New Thread.

Similar threads

M
Help! New Fiberglass pool owner with white discoloration after opening!
Replies
2
Views
75
Testing and Balancing Your Water
msh7rsd
M
R
CSI vs LSI and effect of a negative CSI on a pool heater?
Replies
4
Views
124
Testing and Balancing Your Water
ajw22
ajw22
J
pool testing
Replies
5
Views
133
Testing and Balancing Your Water
Donldson
Donldson
T
New pool Startup over, what’s the next steps
Replies
4
Views
176
Testing and Balancing Your Water
Tom09
T
EmilyOTR
CSI
Replies
2
Views
82
Testing and Balancing Your Water
EmilyOTR
EmilyOTR
Top Bottom
Back
Jump to latest Follow Reply