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

Thread: Excel Sheet for Charting Pool Health History

  1. Back To Top    #1
    toadlife's Avatar
    Join Date
    May 2009
    Location
    Lemoore, CA
    Posts
    57

    Excel Sheet for Charting Pool Health History

    Hi everyone,

    I've created an Excel spreadsheet for charting various chemicals in my pool and thought others might find it useful.

    It contains a section for recording measurements of Chlorine, pH, TA, TH and CYA, and a section for recording the addition of Chlorine, and Muriatic Acid.

    The sheet has four line charts which chart the data you input in the measurement sections.

    The first chart, called "Chem Tracking" shows your chlorine level and ph over time and also places dots on the graph which indicate added chlorine and muriatic acid along how many ounces you added. Of course, you might have to customize this with your specific chemicals (I will probably never need to raise my pH as our tap water is at 8.2), but it's a good template for graphing your pool's health history.

    The other charts are simple line charts that track, ph,TA,TH, and CYA over time.

    I've never owned a pool until now, so I'm sure I will find ways to improve this later on.

    You can download the Excel file, here. (Excel 2003 Format)

    To use it, just delete the example data from the "measurements" and "chem log" sheets and input your own. Unless I made some stupid mistake, a graph should automatically show the data you input.
    21,000 Gallon IG Plaster with Spillover Spa (Built in 1978) | 48 sq/ft Hayward DE Filter | 3.0 HP Pentair Variable Speed Pump | Hayward H250FDN Heater| 8 Gallon Liquidator | Taylor K-2005 | Taylor FAS-DPD Chlorine Test | Taylor "SpeedStir"

  2. Back To Top    #2

    Join Date
    Apr 2009
    Location
    Orange Park, FL
    Posts
    104

    Re: Excel Sheet for Charting Pool Health History

    Very nice. What's next - UCLs and LCLs?
    15x30 IG vinyl liner pool, pool cage
    Hayward S-220T high rate sand filter and Hayward super pump w/1hp motor
    Hayward SwimPure Plus SWG
    Polaris 380 cleaner and booster pump

  3. Back To Top    #3

    Join Date
    Jan 2009
    Location
    Cupertino, CA
    Posts
    1,966

    Re: Excel Sheet for Charting Pool Health History

    Quote Originally Posted by jagfan
    Very nice. What's next - UCLs and LCLs?
    Oooh, control-chart geekdom!
    --paulr
    BBB "Intermediate Swimmer"
    IG plaster pool 18.5K gal, Hayward Pro-Grid DE filter, 3/4 HP Hydramax II; Polaris 380, 3/4 HP booster
    AG spa 325 gal, probably Sundance of some kind
    Water testing instructions on one page

  4. Back To Top    #4
    kenmar's Avatar
    Join Date
    Apr 2009
    Location
    Schnecksville, PA
    Posts
    288

    Re: Excel Sheet for Charting Pool Health History

    Very nice. What's next - UCLs and LCLs?
    Very nice. What's next - UCLs and LCLs?
    How about a CPk?
    20'x40' / 30,000 Gal / In Ground / Vinyl
    Pentair FNS 48 DE Filter / Pentair Challenger 1.5 HP Pump
    Jandy Lite2 400k BTU Propane Heater / Dolphin Dynamic cleaning robot
    TF-100 Test Kit / BBB
    Creator of SimplePool (BBB Friendly Android App) http://www.simplepool.net

  5. Back To Top    #5
    H2O_Keeper's Avatar
    Join Date
    Nov 2008
    Location
    SW Indiana
    Posts
    140

    Re: Excel Sheet for Charting Pool Health History

    How about standard deviations, historgrams, KPI's...LOL

    Seriously though, nice thought with the graphs. I couldnt get the one in this thread to dynamically change as more dates are added but I could reselect the data and make it work.
    21K Gal, IG, Vinyl, Bleach-Borax-Baking Soda, 3/4HP Hayward pump, Hayward sand filter, 200,000BTU Heater, TF100 Testkit
    "All that we are arises with our thoughts." - Buddha
    “When fate hands you a lemon, make lemonade.” - Dale Carnegie

  6. Back To Top    #6
    toadlife's Avatar
    Join Date
    May 2009
    Location
    Lemoore, CA
    Posts
    57

    Re: Excel Sheet for Charting Pool Health History

    Quote Originally Posted by H2O_Keeper
    How about standard deviations, historgrams, KPI's...LOL

    Seriously though, nice thought with the graphs. I couldnt get the one in this thread to dynamically change as more dates are added but I could reselect the data and make it work.
    For the bottom axis I manually defined the time ranges, so new values put in were probably off the right edge of the chart. I did that because using the auto setting made the time range an entire week which made the two days of data I had squished together and hard to read.

    Time ranges are funny in Excel. The are defined in days since 01/01/1901. So 05/13/2009, the time when my charts start, has to be defined as "39946.0" in the axis configuration.
    21,000 Gallon IG Plaster with Spillover Spa (Built in 1978) | 48 sq/ft Hayward DE Filter | 3.0 HP Pentair Variable Speed Pump | Hayward H250FDN Heater| 8 Gallon Liquidator | Taylor K-2005 | Taylor FAS-DPD Chlorine Test | Taylor "SpeedStir"

  7. Back To Top    #7
    toadlife's Avatar
    Join Date
    May 2009
    Location
    Lemoore, CA
    Posts
    57

    Re: Excel Sheet for Charting Pool Health History

    As for KPI's and whatnot, if I ever am tasked with taking care of my boss's pool, I might look into that. Nothing like a good dashboard with virtual buttons to sooth the executive soul.

    21,000 Gallon IG Plaster with Spillover Spa (Built in 1978) | 48 sq/ft Hayward DE Filter | 3.0 HP Pentair Variable Speed Pump | Hayward H250FDN Heater| 8 Gallon Liquidator | Taylor K-2005 | Taylor FAS-DPD Chlorine Test | Taylor "SpeedStir"

  8. Back To Top    #8

    Join Date
    Mar 2009
    Location
    eastern washington state
    Posts
    275

    Re: Excel Sheet for Charting Pool Health History

    hi everyone
    I dont have excel and i would love to have a copie of the charting sheet, could someone email it to me
    at hayfarmer@basininternet.com
    thanks so much
    jim
    live in eastern washington state
    18x36, Vinyl inground 24k
    Hayward 1 hp filter pump
    1 skimmer/2 returns
    24" sand filter, polaris 280 with booster pump.

  9. Back To Top    #9
    H2O_Keeper's Avatar
    Join Date
    Nov 2008
    Location
    SW Indiana
    Posts
    140

    Re: Excel Sheet for Charting Pool Health History

    There are several good logs throughout TFP. See this thread for a few.

    testing-log-t10015.html
    21K Gal, IG, Vinyl, Bleach-Borax-Baking Soda, 3/4HP Hayward pump, Hayward sand filter, 200,000BTU Heater, TF100 Testkit
    "All that we are arises with our thoughts." - Buddha
    “When fate hands you a lemon, make lemonade.” - Dale Carnegie

  10. Back To Top    #10

    Re: Excel Sheet for Charting Pool Health History

    thanks....

    think you can make this an iphone app
    25,000 gal IG Utopia pool/Raypack gas heater/BBB

  11. Back To Top    #11
    toadlife's Avatar
    Join Date
    May 2009
    Location
    Lemoore, CA
    Posts
    57

    Re: Excel Sheet for Charting Pool Health History

    Quote Originally Posted by ideliver
    thanks....

    think you can make this an iphone app
    I'm a Windows mobile person myself. The file opens in Excel mobile, but when you save it it screws the graphs up.
    21,000 Gallon IG Plaster with Spillover Spa (Built in 1978) | 48 sq/ft Hayward DE Filter | 3.0 HP Pentair Variable Speed Pump | Hayward H250FDN Heater| 8 Gallon Liquidator | Taylor K-2005 | Taylor FAS-DPD Chlorine Test | Taylor "SpeedStir"

  12. Back To Top    #12
    Bob_Funk's Avatar
    Join Date
    May 2009
    Location
    Seattle-It really rains all the time
    Posts
    113

    Re: Excel Sheet for Charting Pool Health History

    Quote Originally Posted by hayfarmer
    hi everyone
    I dont have excel and i would love to have a copie of the charting sheet, could someone email it to me
    at hayfarmer@basininternet.com
    thanks so much
    jim
    the chart has the date horizontal & cl vertical if you want to make your own.

    just use open office if you want to use the excel file, it's free

    http://www.openoffice.org/
    I consider myself very lucky I found this site before the pool store found me-pool owner since Nov 2008- Stunningly clear 17,000 gal fiberglass pool, thanks to this site, installed in 1982-24" 3.1sq. ft sta-rite sand filter, 1 hp - 2 speed wisperflo pump-WFDS-4

Posting Permissions

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