Test Tracking Spreadsheet

[Dale.s]

Over the winter ive been working on a spreadsheet for tracking my pool testing results. Ive decided to share it for anybody that is interested.

Top left of the main page you can click check boxs to decide what tests you are going to preform, if you pick FC but not CC, then CC will be recorded as 0. Simply click being testing to start, you will be given instructions for each test, and a box to enter you results, hit add result to begin next test.

The last recorded result for each item is displayed in the top right.

Bottom middle of the screen is a line graph that displays FC readings for the last 10 tests, this is usfull to help you dial in just how much you need to add, or where to set your salt cell.

All the instructions are for what i use, TF-100, salt and borate strips from tftestkits.net

All instuctions apart from salt and borate are the instructions included with the TF-100, salt and borate where copied from the bottles.

If there is enough interest ill be more then happy to keep posting updates as i continue to work on it.

 

[sonflower]

Thank you for sharing.

The .zip file downloaded ok but when I unzipped there was an .xlsm file - it did not automatically open in Excel. When I changed the extension to .xls and opened the file in Excel it did not convert correctly.

 

[Dale.s]

It was made with excel 2007, what version are you using? I can see if i can save it in a older format tomorrow.

 

[sonflower]

Oh I have Excel 2000 (dinosaur pc)

Sorry for the hassle!

 

[Dale.s]

Decided to break out the laptop tonight instead of the morning for ya .

Re-saved it as a 97-2003 excel file, everything seems to still work even though it gave me a bunch of warnings, if you see somthing not working right lemmie know and ill see what i can do.

 

[alf1096]

thanks

 

[sonflower]

Dale I was able to access it this time (from work, last night was from home). I had to enable macros which I did. Now I will e-mail it to the house & see if my dino pc can handle those fancy macros. Looking forward to logging test results & seeing how this fancy formula contraption works.

Thank you for sharing!

I eddited this post to mention the following:
Dale, you may think about uploading to scribd.com. I uploaded my 1 pool .xls file http://www.scribd.com/doc/38093832/Pool-chemical-quick-reference to scribd. When I search scribd for pool references there are quite a few on there. Just a thought.

 

[phalcon51]

Thanks for sharing this. I can see this being very useful. One question - I'm relatively unfamiliar with Excel. Is there a way to show a 10 day graph for each of the items selected for testing on the main page? I'm only seeing the graph for free chlorine.

Thanks.

 

[Dale.s]

That would be possible, but could be messy showing it all on one graph. I will add a graph for each item on its result page though. That way when you pick the ph tab you will see all ph results, and a graph with the last 10.

 

[Dale.s]

New version for you!

Main page now has charts for FC and pH.

Each tab (apart from CC) now has a graph, the axis on the graphs will self adjust based on the data so you get a graph in the middle, not just a line on top.

FC and Ph show last 10 tests - tested most
CH, TA, CYA, Borates and Salt show last 5 tests - tested least
Temp shows last 15 tests - Added with each test

Please Note: There is fake data for every tab with a graph, this is needed to populate the graphs and avoid errors, do not delete this data untill you have the required amount of data added (5, 10 or 15 tests depending on tab)

 

[phalcon51]

Fantastic! Thanks!!

 

[FSI_C-12IP]

I REALLY like your spreadsheet, Dale!

 

[phalcon51]

Dale, Thanks again for your spreadsheet, I'm using it daily. I have a question I hope you can answer. Each time I start it up I get a security warning saying that some active content has been disabled (macros and ActiveX). I have to tick a box each time to enable these functions before I can use the spreadsheet. How can I fix this permanently?

Thanks,

Gary

 

[Dale.s]

I don't believe you can fix that for just one sheet. There is a option to turn down the security level so it won't show up, however that will effect every sheet you use. Personally I think it best to deal with it and know your protected all the time. I may well be wrong and you can do it for one sheet mind

 

[phalcon51]

I really don't use Excel for anything else. It just came with Office, so I'm not worried at this point about macros or ActiveX. If I change the settings does it only affect Excel documents or all Office applications? If all, I'll just enable it each time.

Thanks,

Gary

 

[mas985]

I have one here that is based on the formulas from the Pool Math but it also has a macro that will record all of the results into a single line on a log sheet. See Chemistry Calculator. Both Excel and Google Sheets.

http://www.troublefreepool.com/thre...you-lost-your-head?p=6231&viewfull=1#post6231