Reef Aquarium Parameter Excel Spreadsheet

Discussion in 'Corals' started by Matt, Dec 7, 2012.

  1. Matt

    Matt Reefer-In-Training

    Joined:
    Dec 7, 2012
    Messages:
    22
    Likes Received:
    0
    Location:
    Kansas City, MO
    Hey all,

    This is my first post on a LR forum and I thought it would be nice for my first post to be a contribution to the community. I have created an excel spreadsheet that allows you to keep track of your tank parameters over time.

    There is a section where you enter your desired parameters and a section where you enter your parameter values over time. If the value is our of your desired range, then the text will turn red notifying you of such. I have also included graphs that automatically update based on the parameters you enter. (pretty cool huh?.)

    Attached is a picture of the excel sheet I created. I'm not sure about the rules on attaching other files besides picture, so if you want the .xlsx (excel) file let me know and I will gladly give it to you.

    I would GREATLY appreciate if anyone can give me advice as to any other parameters I should add or if my parameter range isn't appropriate. These are the levels that I am using in my tank right now and it's about 5 months in doing great!

    I look forward to making future posts with questions/contributions
     
    Matt, Dec 7, 2012
    #1
    1. Advertisements

  2. Matt

    Matt Reefer-In-Training

    Joined:
    Dec 7, 2012
    Messages:
    22
    Likes Received:
    0
    Location:
    Kansas City, MO
    It would help if I actually attached the picture ... lol here it is
     

    Attached Files:

    Matt, Dec 7, 2012
    #2
    1. Advertisements

  3. Matt

    mledbet

    Joined:
    Apr 10, 2011
    Messages:
    36
    Likes Received:
    3
    Location:
    Kankakee Ill USA
    nice good information
     
    mledbet, Dec 7, 2012
    #3
  4. Matt

    Old_Moe

    Joined:
    Oct 3, 2011
    Messages:
    352
    Likes Received:
    49
    Location:
    NJ
    very cool.. but I am an excel freak.... good job!

    The one thing I would consider is doing a weekly 10%-15% rather than the big bi-weekly 25% water change.

    Just a thought.
     
    Old_Moe, Dec 7, 2012
    #4
    Matt likes this.
  5. Matt

    Matt Reefer-In-Training

    Joined:
    Dec 7, 2012
    Messages:
    22
    Likes Received:
    0
    Location:
    Kansas City, MO
    Thanks for your reply. I'm doing bi-weekly 25% water changes because I am usually a pretty busy person and it drives my girlfriend nuts when I ignore her to work on the tank (which I love to do haha). What are the pros/cons if doing a bi-weekly 25% water change vs the pros/cons of doing a weekly 10% water change?

    This is my first tank since my early teenage years so I'm definitely a little rusty on my information, plus this is the first tank that I plan on having coral in so I'm soaking up information like a sponge these days so any advice would be appreciated.
     
    Matt, Dec 7, 2012
    #5
  6. Matt

    Jimboaf We can build it

    Joined:
    Sep 27, 2012
    Messages:
    84
    Likes Received:
    1
    Location:
    R-ville, NJ
    That is awsome I will have to message you to get that
     
    Jimboaf, Dec 7, 2012
    #6
  7. Matt

    Matt Reefer-In-Training

    Joined:
    Dec 7, 2012
    Messages:
    22
    Likes Received:
    0
    Location:
    Kansas City, MO
    It seems like I am allowed to attach .zip files, so I zipped up the excel sheet and attached it to this post. If you download it and use it, please let me know what you think about it as a reply on this thread. This will also help with letting other people know that it is not a virus, I know some people do not like to download .zip files from the internet, but this forum will not let me attach a .xlsx file so that's the only choice I had. Enjoy!
     

    Attached Files:

    Matt, Dec 7, 2012
    #7
  8. Matt

    FishyReef Broke Reefer!

    Joined:
    Jan 1, 2012
    Messages:
    3,074
    Likes Received:
    342
    Location:
    Boston
    Changing out 25% at a time is harder on your livestock, and early on it helps keep your parameters more stable. Over time, as you get more corals in your tank changing weekly adds back in necessary trace elements more often so that you don't have to dose (until of course you get so many corals that water changes alone won't meet their demand!)
     
    FishyReef, Dec 7, 2012
    #8
    Matt likes this.
  9. Matt

    Lou's Reef

    Joined:
    Jul 30, 2014
    Messages:
    1
    Likes Received:
    0
    Matt, I came across your Excel spread sheet, it looks great. I have been tracking my perimeters in a layout I came up with in Publisher, but obviously, the data is in chart form. I tried formatting it with excel templates, but my charting is really mundane since I never use the program. I was trying to modify yours since it works well, but since I am brain dead, I cannot connect the graphs to the new inserted columns. Could you just duplicate the items that I follow on your chart and email it back to me? I know it probably is a simple process, but it has me mystified, and I don't know anyone who works with excel. I follow, Temp., ORP, Salinity, Alkalinity, Calcium, Iodine, Magnesium, Nitrates, Nitrite, Phosphates, Potassium, and Strontium. Thanks, Lou
     
    Lou's Reef, Jul 30, 2014
    #9
  10. Matt

    eddiewms

    Joined:
    Jan 27, 2015
    Messages:
    1
    Likes Received:
    0
    Great job Matt! I track the same things as Lou's Reef. Did you ever update the spreadsheet to include the other test?
     
    eddiewms, Jan 27, 2015
    #10
  11. Matt

    salt_for_brains Alabama Reefer VIP Member

    Joined:
    Jan 8, 2013
    Messages:
    1,857
    Likes Received:
    846
    Location:
    Leroy, Alabama
    Matt hasn't been on here in a couple years so I think you are on your own on adding the new points.
     
    salt_for_brains, Jan 28, 2015
    #11
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.