Vote for TFF UK


AquaRank.com

Recent Topics

Gallery

IMG_0284.jpg

Posted by stonec0ld

Ammonia Calculator

Articles on TFF UK

Donate to TFF!

If we have been of help please consider making a Donation to TFF UK

Or sign up to a quarterly subscription at £10 every 3 months

Every Little Helps

Advertisements


Members
Stats
  • Total Posts: 654248
  • Total Topics: 51664
  • Online Today: 149
  • Online Ever: 340
  • (November 03, 2012, 08:29:45 PM)
Users Online

RSS Feeds

Author Topic: Spreadsheet for Freshwater tank water parameters  (Read 2336 times)

Offline clive1512

  • Newbie
  • *
  • Thank You
  • -Given: 0
  • -Receive: 0
  • Posts: 22
Spreadsheet for Freshwater tank water parameters
« on: March 14, 2011, 04:46:39 PM »
I have created an Excel (2007) spreadsheet to record my Freshwater tanks water parameters.
The spreadsheet produces 'auto adjusting' graphs, this can make it a little easier to spot trends.

Please see comment below for updated spreadsheet.
I use it to record:
ammonia
Nitrites
Nitrates
Water changes
Vacumn history

I also use the Excel 'comments' facility for recording things like adding fish/plants etc. Just hover over a cell which has a small red triangle in the top right hand corner.

I do not monitor pH as mine remains constant, although I could add this if you wish.


Screenshot (click to view full size)


I have uploaded it to Mediafire for anyone who may be interested.
The latest version can now be found further down in the replies.

I hope it of use to you.
Your thoughts/suggestions are also welcome.

N.B. Excel 2007 has the .xlsx file extension. However, the file will still load into Excel 2003 (in compatability mode) & will still work.
« Last Edit: March 26, 2011, 12:21:48 AM by clive1512 »

TropicalFishForums

  • Advertisement
  • ***

    Offline Vale!

    • TFF Staff & Supporter
    • Global Moderator
    • Hero Member
    • *****
    • Thank You
    • -Given: 5
    • -Receive: 118
    • Posts: 4501
    • It can only be attributable to human error
      • Mugshot (not for the faint-hearted or impatient)
    Re: Spreadsheet for Freshwater tank water parameters
    « Reply #1 on: March 20, 2011, 03:04:04 PM »
    Hi Clive

    I'd be interested to investigate this a little more - it does look really useful.

    I clicked on your Mediafire link ... but I'm a spreadsheet numpty so I didn't know what to do next in order to get it into my machine to play with!

    Can you prompt me through the process, please?
    "This mission is too important for me to allow you to jeopardise it."
    "I don't know what you're talking about, HAL. "
    "I know that you and Frank were planning to disconnect me, and I'm afraid that's something I cannot allow to happen."

    Offline jaytaff

    • Hero Member
    • *****
    • Thank You
    • -Given: 0
    • -Receive: 4
    • Posts: 2858
    • Fish Addict
    Re: Spreadsheet for Freshwater tank water parameters
    « Reply #2 on: March 20, 2011, 03:13:12 PM »
    Interesting sheet, I missed this...


    Vale, click link, download the xls file to somewhere on your machine (I.E Desktop),  Double click on file it should open into Excel.  If not start up Excel, then file menu/open, locate file, load in :)

    To add, if you haven't got Excel, then use Openoffice, which is free and can be downloaded from the web :)
    « Last Edit: March 20, 2011, 03:14:45 PM by jaytaff »

    Offline Vale!

    • TFF Staff & Supporter
    • Global Moderator
    • Hero Member
    • *****
    • Thank You
    • -Given: 5
    • -Receive: 118
    • Posts: 4501
    • It can only be attributable to human error
      • Mugshot (not for the faint-hearted or impatient)
    Re: Spreadsheet for Freshwater tank water parameters
    « Reply #3 on: March 20, 2011, 03:30:59 PM »
    Thanks, Jay.

    However my PC being the mardy git that it is, won't play.  When I click the link a Windows information box appears informing me that there's been a 'sandbox violation' followed by a list of things that all mention 'flash'.  Now, because of I-don't-know-why, my machine doesn't 'do' Flash and/or Javascript*.  Hence I'm unable to see how to download the file.  Am I scuppered, then?!

    I do have Excel 2007, btw.



    *also, I think, the reason why I don't/can't use smileys. And, yes, Javascript is 'enabled' on my system and I have the latest update of Flash!
    « Last Edit: March 20, 2011, 06:01:29 PM by Vale! »
    "This mission is too important for me to allow you to jeopardise it."
    "I don't know what you're talking about, HAL. "
    "I know that you and Frank were planning to disconnect me, and I'm afraid that's something I cannot allow to happen."

    Offline jaytaff

    • Hero Member
    • *****
    • Thank You
    • -Given: 0
    • -Receive: 4
    • Posts: 2858
    • Fish Addict
    Re: Spreadsheet for Freshwater tank water parameters
    « Reply #4 on: March 20, 2011, 03:36:35 PM »
    Try a different browser, thats always the next step.  I did notice when I tried to download the file via Opera browser, it did pull up redirection adverts, weird.


    Firefox downloads it ok though, failing that message me your email address, and i'll email the file to you :)

    Offline Vale!

    • TFF Staff & Supporter
    • Global Moderator
    • Hero Member
    • *****
    • Thank You
    • -Given: 5
    • -Receive: 118
    • Posts: 4501
    • It can only be attributable to human error
      • Mugshot (not for the faint-hearted or impatient)
    Re: Spreadsheet for Freshwater tank water parameters
    « Reply #5 on: March 20, 2011, 03:40:15 PM »
    Will do.  Thanks, Jay.
    "This mission is too important for me to allow you to jeopardise it."
    "I don't know what you're talking about, HAL. "
    "I know that you and Frank were planning to disconnect me, and I'm afraid that's something I cannot allow to happen."

    Offline sharkysmum

    • TFF Supporter
    • Hero Member
    • *****
    • Thank You
    • -Given: 0
    • -Receive: 0
    • Posts: 2262
    Re: Spreadsheet for Freshwater tank water parameters
    « Reply #6 on: March 20, 2011, 03:55:32 PM »
    This looks great - I love it.   :) *applause*Very useful to me for keeping track of both tanks and the cycling process.  Alas I couldn't download it either. 

    Offline jaytaff

    • Hero Member
    • *****
    • Thank You
    • -Given: 0
    • -Receive: 4
    • Posts: 2858
    • Fish Addict
    Re: Spreadsheet for Freshwater tank water parameters
    « Reply #7 on: March 20, 2011, 03:58:18 PM »
    As above, message me your email address :)

    Offline vess

    • TFF Staff & Supporter
    • Global Moderator
    • Hero Member
    • *****
    • Thank You
    • -Given: 3
    • -Receive: 156
    • Posts: 3687
    • Cory fanatic.
    Re: Spreadsheet for Freshwater tank water parameters
    « Reply #8 on: March 20, 2011, 05:20:21 PM »
    Excellent sheet, thank you.

    L

    Offline ClothahumpDisabled

    • Hero Member
    • *****
    • Thank You
    • -Given: 18
    • -Receive: 28
    • Posts: 6431
      • http://www.facebook.com/pages/Marshwood-Vale-Cider/159497434096715
      • Marshwood Vale Cider
    Re: Spreadsheet for Freshwater tank water parameters
    « Reply #9 on: March 20, 2011, 05:53:01 PM »
    Could you add pH please and if possible would it be OK to have a copy in our downloads area?
    Please do not Private Message me with fish keeping questions, put them in the Forums.




    Offline clive1512

    • Newbie
    • *
    • Thank You
    • -Given: 0
    • -Receive: 0
    • Posts: 22
    Re: Spreadsheet for Freshwater tank water parameters
    « Reply #10 on: March 24, 2011, 10:52:17 AM »
    Hi everyone.
    Sorry I haven't replied to your questions, I have been pretty busy of late.
    Many thanks for your kind comments.
    The problems with the downloading, seems to have been covered by Jay (thanks Jay).
    I will add a pH section shortly & upload it. I am also working on a 'Tank details' worksheet - though this is only likely to work with Excel 2007.

    Offline clive1512

    • Newbie
    • *
    • Thank You
    • -Given: 0
    • -Receive: 0
    • Posts: 22
    Re: Spreadsheet for Freshwater tank water parameters
    « Reply #11 on: March 24, 2011, 04:24:17 PM »
    Hi

    Please see comment below for the final updated spreadsheet.

    I have updated the spreadsheet to include a pH column.
    It also has some pretty pictures :)

    Please let me know if this is still of interest. If it is, then I will continue to upload any updates.

    The file is on mediafire once more:


    Screenshot:


    The file:
    The final and latest version can now be found further down in the replies.
    « Last Edit: March 26, 2011, 12:23:54 AM by clive1512 »

    Offline clive1512

    • Newbie
    • *
    • Thank You
    • -Given: 0
    • -Receive: 0
    • Posts: 22
    Re: Latest Spreadsheet for Freshwater tank water parameters
    « Reply #12 on: March 25, 2011, 11:15:40 PM »
    Hi, again
    I have updated (once more) the spreadsheet to now include:
    A 'Tank details' section
    A 'Maintenance log' section
    and
    An 'Aquarium calculator' section

    If this is of interest, please let me know of any additions or changes you would like to see.

    This will be the last update for awhile (unless you suggest any major changes).

    Screenshots:




       



    The file is on mediafire once more:

    The file:
    http://www.mediafire.com/file/g475hsiugzcomlp/Water_Parameters_update.xlsx

    Offline ClothahumpDisabled

    • Hero Member
    • *****
    • Thank You
    • -Given: 18
    • -Receive: 28
    • Posts: 6431
      • http://www.facebook.com/pages/Marshwood-Vale-Cider/159497434096715
      • Marshwood Vale Cider
    Re: Spreadsheet for Freshwater tank water parameters
    « Reply #13 on: March 26, 2011, 09:14:41 AM »
    I think there is something missing from the download, all I got was "My Aquarium"
    Please do not Private Message me with fish keeping questions, put them in the Forums.




    Offline clive1512

    • Newbie
    • *
    • Thank You
    • -Given: 0
    • -Receive: 0
    • Posts: 22
    Re: Spreadsheet for Freshwater tank water parameters
    « Reply #14 on: March 26, 2011, 10:35:39 AM »
    Very strange
    I just downloaded it to a different machine and all was fine