Spreadsheet to do pool calculations

[Corban987]

Hi

This is my first post. I have been looking for a spreadsheet to do the calculations, and I found this thread. I decided to create my own based off the website http://www.poolcalculator.com/ All I did was format the calculations from the website into the spreadsheet for ease of use.

I thought I would share it, I prefer to use a spreadsheet.

EDIT: - Deleted my first upload, Just uploaded an updated version with a few fixes and layout changes, graphs - protected the cells with the formulas so they can't be typed in. (No password required to unprotect them)

 

[ghetohound]

Hi

This is my first post. I have been looking for a spreadsheet to do the calculations, and I found this thread. I decided to create my own based off the website http://www.poolcalculator.com/ All I did was format the calculations from the website into the spreadsheet for ease of use.

I thought I would share it, I prefer to use a spreadsheet.

Hi, Thanks! The spreadsheet is cool and I don't have to sign onto the internet to plug in my numbers (newbie at this). Would it be difficult to make a second sheet so I can keep a running table of my numbers by date?

Barb

 

[Corban987]

Hi

I can add another worksheet so you can tabulate your readings each week, and create graphs. I was planning to do this for myself. I will now have to work out how to automate the upper and lower limits of each graph depending on where you choose your recommended settings from as well as your target level and your actual levels. As I said I was planning this for myself but had no agenda for time.

I have also corrected a few mistakes in the spreadsheet, the CH label had CA not CH, and the formula for pH had a dummy reference for borax levels as I hadn't done the borax section when I was working out the pH formulas from http://www.poolcalculator.com/ - I will upload a new version soon with these additions, then another version later with the graphs automated. Being in excel it will require some knowledge of using excel to manipulate the graphing ranges etc.

If anything else needs adding or correcting let me know I will fix and share!

 

[Corban987]

Updated Spreadsheet - Added Graphs and changed layout, locked the cells that shouldn't need editing (no password)