Become a TFP Supporter Pool Math Forum Rules Pool School
Results 1 to 4 of 4

Thread: Spreadsheet to do pool calculations

  1. Back To Top    #1

    Join Date
    Jun 2013
    Location
    Michigan
    Posts
    13

    Spreadsheet to do pool calculations

    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)
    Currently installing new pool into new home.
    16x32 Steel Walled, Vinyl, 4ft to 6ft depth
    Hayward SWG, Aqua 4 Plus
    Hayward 1.5 HP Pump
    Hayward Cartridge Filter
    Heater - Not Decided yet.

  2. Back To Top    #2

    Join Date
    Jun 2013
    Location
    Michigan
    Posts
    24

    Re: Spreadsheet to do pool calculations

    Quote Originally Posted by 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.

    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
    St. Clair MI, 18,600 AG, Sand, Hayward Pro Series, Top-Mount, Model #S210T93S, 1+1/2-Horsepower Matrix Pump. Installed June-2013.

  3. Back To Top    #3

    Join Date
    Jun 2013
    Location
    Michigan
    Posts
    13

    Re: Spreadsheet to do pool calculations

    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!
    Currently installing new pool into new home.
    16x32 Steel Walled, Vinyl, 4ft to 6ft depth
    Hayward SWG, Aqua 4 Plus
    Hayward 1.5 HP Pump
    Hayward Cartridge Filter
    Heater - Not Decided yet.

  4. Back To Top    #4

    Join Date
    Jun 2013
    Location
    Michigan
    Posts
    13

    Re: Spreadsheet to do pool calculations

    Updated Spreadsheet - Added Graphs and changed layout, locked the cells that shouldn't need editing (no password)
    Attached Files Attached Files
    Currently installing new pool into new home.
    16x32 Steel Walled, Vinyl, 4ft to 6ft depth
    Hayward SWG, Aqua 4 Plus
    Hayward 1.5 HP Pump
    Hayward Cartridge Filter
    Heater - Not Decided yet.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •