Pool Testing with Excel

[stinsontx]

Anyone else use Excel to track pool results in addition to Pool Math? I am about to put in formulas for CSI and LSI, slow week at the Stinson house. Any other interesting ideas folks would like to share?

 

[ajw22]

GIGO

How do you measure CYA of 25?

 

[stinsontx]

GIGO

How do you measure CYA of 25?

Easy, I just lie to myself and type it in the spreadsheet. In all seriousness, pool was in startup and I was just guesstimating.

 

[ajw22]

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.

 

[mknauss]

Use PoolMath

 

[stinsontx]

I use PoolMath everyday, but as a geek I am compelled to share ideas about spreadsheets.

Yes, aware that CYA is log.

 

[stinsontx]

 

[Sunnydaze]

I logged my testing and chemical additions religiously in the beginning in a notebook. After i got the hang of things and my pool became consistent and predictable, i stopped logging as often. Spreadsheets fulfil my nerdiness though

 

[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.....

 

[D1Lotus]

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

Is that spreadsheet something you can share?

 

[stinsontx]

Is that spreadsheet something you can share?

Happy to send, can you send me your contact information in a private message?

 

[D1Lotus]

Happy to send, can you send me your contact information in a private message?

PM sent.

 

[gingrbredman]

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!

 

[RickRude]

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!

 

[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!

 

[ryandkysmom]

I messaged you w my email

 

[Henryrose88]

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..

 

[PoolBrews]

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.

 

[revitup]

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.

 

[mgtfp]

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..

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.