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

Thread: Simple Excel Spreadsheet to track pool conditions

  1. Back To Top    #1

    Join Date
    May 2008
    Location
    Tucson
    Posts
    30

    Simple Excel Spreadsheet to track pool conditions

    I created a very simple ss to track pool conditions based on the recommended levels in pool school. It also color codes the cells in your out of range based on whether you have an algae problem or not. I used 50 ppm cause I am currently battling black algae again. The charts tab also plots your results so you can visually see the impacts of adding chemicals. I am sure there is a better one out there but I am bored as heck at work today so I just thew this thing together.
    ~25000 gallon free-form in-ground plaster pool located in Tucson in full sun
    TFT-100 Test Kit
    Hayward DE4820 filter
    Caretaker system
    Hayward 1 1/2 HP Super Pump

  2. Back To Top    #2

    Join Date
    Mar 2010
    Location
    Western North Carolina
    Posts
    77

    Re: Simple Excel Spreadsheet to track pool conditions

    any way you could post it for download?
    16'x34' IG Vinyl. 1.5HP Hayward 2spd. Hayward S244T sand. Nitro wall climber.

  3. Back To Top    #3

    Join Date
    Feb 2010
    Location
    Blessing, Tx (South of Houston)
    Posts
    82

    Re: Simple Excel Spreadsheet to track pool conditions

    Quote Originally Posted by ncbrit
    any way you could post it for download?
    I second that, i love new toys! :P
    Intex 18' AGP - Intex SWG - 19 inch Sand Dollar Sand Filter - 1HP Pentair Dynamo Pump - 4X20 Solar Panel - Goldline Solar Controller.

  4. Back To Top    #4

    Join Date
    May 2008
    Location
    Tucson
    Posts
    30

    Re: Simple Excel Spreadsheet to track pool conditions

    Sorry, thought it attached
    ~25000 gallon free-form in-ground plaster pool located in Tucson in full sun
    TFT-100 Test Kit
    Hayward DE4820 filter
    Caretaker system
    Hayward 1 1/2 HP Super Pump

  5. Back To Top    #5

    Join Date
    May 2008
    Location
    Tucson
    Posts
    30

    Re: Simple Excel Spreadsheet to track pool conditions

    It will not allow me to update .xlsx files and regular .xls doesn't support all the conditional formatting it uses. I renamed to .txt to upload, download and rename to .xlsx and see if it works
    Attached Files Attached Files
    ~25000 gallon free-form in-ground plaster pool located in Tucson in full sun
    TFT-100 Test Kit
    Hayward DE4820 filter
    Caretaker system
    Hayward 1 1/2 HP Super Pump

  6. Back To Top    #6

    Join Date
    Aug 2009
    Location
    North Central Texas
    Posts
    1,358

    Re: Simple Excel Spreadsheet to track pool conditions

    Thanks Much.

    I opened in Open Office but had to open OO first and then file, open.

    Just thinking the other day I'd love to have something like this. Really, Really, Really appreciate.

    gg=alice
    1981, 25K, IG, Blue Plaster 1996, somewhat oval, widens a bit at shallow end, 1.5" pipes, 2" at Pad, 1 separate main drain, 1 skimmer, 4 returns + dedicated cleaner return, 10 ft deep end with very fast decline from shallow, Pentair Quad 80 DE, Pentair Intelliflo VF, 3/4 HP Booster Pump (equipment pad about 8 ft below top of pool), Challanger 3/4 Trash/Emergency Pump 120v, Polaris 280 (pressure), iRobot Verro cleaner (robotic), Aquabot Turbo (robotic), Jacuzzi Tracker 4X (vacuum) Pool Blaster (Buster), Two (2) PoolSkims, Solar Breeze (solar powered top skimmer) (beta to ver. 2, release date 2010), ColorSplash LED replacement bulb. Aries 550 gal separate spa, 2002 (our 3rd and BEST spa) , BBB-Bromine

  7. Back To Top    #7

    Join Date
    Aug 2009
    Location
    North Central Texas
    Posts
    1,358

    Re: Simple Excel Spreadsheet to track pool conditions

    One can download Office compatibility pack if needed, too.

    gg=alice
    1981, 25K, IG, Blue Plaster 1996, somewhat oval, widens a bit at shallow end, 1.5" pipes, 2" at Pad, 1 separate main drain, 1 skimmer, 4 returns + dedicated cleaner return, 10 ft deep end with very fast decline from shallow, Pentair Quad 80 DE, Pentair Intelliflo VF, 3/4 HP Booster Pump (equipment pad about 8 ft below top of pool), Challanger 3/4 Trash/Emergency Pump 120v, Polaris 280 (pressure), iRobot Verro cleaner (robotic), Aquabot Turbo (robotic), Jacuzzi Tracker 4X (vacuum) Pool Blaster (Buster), Two (2) PoolSkims, Solar Breeze (solar powered top skimmer) (beta to ver. 2, release date 2010), ColorSplash LED replacement bulb. Aries 550 gal separate spa, 2002 (our 3rd and BEST spa) , BBB-Bromine

  8. Back To Top    #8

    Join Date
    Feb 2010
    Location
    Blessing, Tx (South of Houston)
    Posts
    82

    Re: Simple Excel Spreadsheet to track pool conditions

    Just downloaded and it looks great, good work! Got 2 quick suggestions, add the conditional formating to the CC row (over 0.5 = red) and make sheet 3 a chart for just chlorine levels, we tend to worry more about FC then the others so a chart same size as the first with a smaller scale would make seeing our FC trends much easier. Great work!

    Oh just noticed the rules for conditional formating are coded and not using the values from the "min max" column, could that be changed?
    Intex 18' AGP - Intex SWG - 19 inch Sand Dollar Sand Filter - 1HP Pentair Dynamo Pump - 4X20 Solar Panel - Goldline Solar Controller.

  9. Back To Top    #9

    Join Date
    Apr 2010
    Location
    Plano, TX
    Posts
    44

    Re: Simple Excel Spreadsheet to track pool conditions

    This is nice to have. Thanks for sharing.
    Plano, TX
    25,000 Gallons, Plaster, DE Filter, No SWG

  10. Back To Top    #10
    coog61's Avatar
    Join Date
    Nov 2009
    Location
    Richmond, TX
    Posts
    82

    Re: Simple Excel Spreadsheet to track pool conditions

    I downloaded and changed the extension to *.xls, then opened in Excel, but still can't read. How do it convert this?

    Thanks
    Dave
    17,500 Gallon, SWG 33' x 21' freeform w/ Sunstone Cobalt Plaster. Attached 6 X 6 Spa raised 12" w/ 6 Jets with Moss Rock Spillover. 25' Moss Rock Waterfall. Pentair Intelliflo VS-3050 for Pool, 2 HP Whisperflo for Waterfall, Pentair Clean & Clear Cartridge 320, Pentair 400K BTU Max-E-Therm heater, Pentair Intellichor, Pentair EasyTouch 4P, Pentair Legend Platinum Cleaner w/ 3/4 hp pump, autofill system, nat gas fire pit. BBB convert

    http://www.troublefreepool.com/new-tx-pool-t17907.html

  11. Back To Top    #11
    flyboy320's Avatar
    Join Date
    Jul 2009
    Location
    Burlington, Ontario, Canada
    Posts
    216

    Re: Simple Excel Spreadsheet to track pool conditions

    Quote Originally Posted by coog61
    I downloaded and changed the extension to *.xls, then opened in Excel, but still can't read. How do it convert this?

    Thanks
    Dave
    Try renaming it to *.xlsx
    10K gal IG, vinyl, 1 HP Jandy Stealth pump, Jandy CS cartridge filter, Delta UV system, Hasa Liquidator

  12. Back To Top    #12
    jule's Avatar
    Join Date
    May 2010
    Location
    New London, Wisconsin
    Posts
    139

    Re: Simple Excel Spreadsheet to track pool conditions

    Thanks for sharing bhodge!
    22 ft octagon, inground, 4 ft ave depth - figured @ 11,400 gallons, well water
    Steel walls with sand bottom and vinyl liner : under full sun
    Harmsco Betterfilter w/14 paper cartridges
    1 hp Hayward motor

    Baqua to Chlorine in 2010.

    ~Wisconsin~

Posting Permissions

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