Sponsors

Recent Topics

Ammonia Calculator

Articles on TFF UK

Advertisements


Members
Stats
  • Total Posts: 873221
  • Total Topics: 70242
  • Online Today: 66
  • Online Ever: 874
  • (January 15, 2020, 07:42:34 am)
Users Online
Users: 1
Guests: 73
Total: 74

Author Topic: Seriously dramatic changes to the 'Water parameters' Excel workbook  (Read 17949 times)

clive1512

  • Guest
Hi
Please see reply below for the latest update (now version 12a)
« Last Edit: May 19, 2011, 10:44:20 pm by clive1512 »

TropicalFishForums

  • Advertisement
  • ***

    L_Plates

    • Guest
    Re: Final version of my spreadsheet
    « Reply #1 on: March 29, 2011, 09:08:29 pm »
     *applause*

    Superb, thanks for sharing.

    Offline plankton

    • TFF Staff Retired
    • Superhero Member
    • *****
    • Thank You
    • -Given: 162
    • -Receive: 6657
    • Posts: 82699
    • I will say this only once, OK a million times....
    Re: Final version of my spreadsheet
    « Reply #2 on: March 29, 2011, 10:39:37 pm »
    Nice one Clive :)
    Sent from my PC as I still don't understand the the logic for mobile internet usage ;) *grin*
    I really hate "autocorrupt"!!!

    "We found this spoon sir"

    Take it easy
    Ian

    Offline DEE

    • TFF Staff Retired
    • Superhero Member
    • *****
    • Thank You
    • -Given: 32
    • -Receive: 105
    • Posts: 7753
    Re: Final version of my spreadsheet
    « Reply #3 on: March 29, 2011, 10:41:48 pm »
    That looks excellent... you've obviously worked hard on that. Thank you :)
    It's an obsession!   *fish2*

    Offline stonec0ld

    • Superhero Member
    • *****
    • Thank You
    • -Given: 1
    • -Receive: 20
    • Posts: 5251
    Re: Final version of my spreadsheet
    « Reply #4 on: March 29, 2011, 11:16:19 pm »
    Wow, an incredibly detailed and useful spreadsheet. I particularly like the disease database and the conversion calculator at the back :)

    Offline Colin

    • Hero Member
    • ****
    • Thank You
    • -Given: 0
    • -Receive: 0
    • Posts: 1230
    Re: Final version of my spreadsheet
    « Reply #5 on: April 09, 2011, 01:13:48 pm »
    quick question, there is a comment on cell B15 sheet Jan. How do I remove it? I am using excel 2003

    clive1512

    • Guest
    Re: Final version of my spreadsheet
    « Reply #6 on: April 09, 2011, 08:34:43 pm »
    Hi
    To remove a comment in Excel 2003:

    Select the cell(s) containing the comment(s) you want to delete

    Then on the Edit menu, point to Clear, and then click Comments

    Offline Colin

    • Hero Member
    • ****
    • Thank You
    • -Given: 0
    • -Receive: 0
    • Posts: 1230
    Re: Final version of my spreadsheet
    « Reply #7 on: April 09, 2011, 08:40:01 pm »
    thanks that little red triangle has been doing my nut lol

    clive1512

    • Guest
    Re: Final version of my spreadsheet
    « Reply #8 on: April 09, 2011, 09:11:47 pm »
    The little red triangle is very useful at times.

    I know I said that it is my 'final version', but I have updated it somewhat. It now includes various other functions.

    I will be posting it soon

    Regards

    Offline Colin

    • Hero Member
    • ****
    • Thank You
    • -Given: 0
    • -Receive: 0
    • Posts: 1230
    Re: Final version of my spreadsheet
    « Reply #9 on: April 09, 2011, 09:14:16 pm »
    oh yeah, comments are fine but that one in particular was rather annoying as I wanted to get rid of it as it didn't have anything relivent for me in it lol

    Offline Colin

    • Hero Member
    • ****
    • Thank You
    • -Given: 0
    • -Receive: 0
    • Posts: 1230
    Re: Final version of my spreadsheet
    « Reply #10 on: April 14, 2011, 04:06:41 pm »
    The little red triangle is very useful at times.

    I know I said that it is my 'final version', but I have updated it somewhat. It now includes various other functions.

    I will be posting it soon

    Regards

    I am looking forward to the updated sheet :D

    clive1512

    • Guest
    Re: Latest version of my spreadsheet
    « Reply #11 on: April 15, 2011, 12:17:09 am »
    Thanks Colin

    I have been asked to add some more functions I.E. The ability to record GH, KH, Fe and CO2

    Also to change the Calculator to include water volume, weight & stock level (I have just finished this part)

    It shouldn't be to long before I can release the 'next' version

    clive1512

    • Guest
    Hi all

    I have completed a major update to my water parameters spreadsheet (now version 4)

    The functions are now as follows:

    Home page
    Water parameters (now with the option for recording GH, KH, Fe & CO2)
    Tank details
    Tank maintenance
    Disease database
    Calculator (now with the choice to input in either imperial or metric & the ability to calculate Volume, Weight & stocking level.
    Output is both imperial & metric)
    Compatibility guide
    Notes (calendar & other notes sections)
    New menu structure with the ability to save & backup from each page

    Important
    The speadsheet was created using Visual Basic, in order to use it, you must enable Macros when asked


    Screenshots

    Home page


    Water parameters (with pH, Ammonia, Nitrites & Nitrates)


    Water parameters (with GH, KH, Fe & CO2)


    Tank details


    Maintenance


    Disease database


    Calculator


    Compatibility guide


    Notes


    The file is on Mediafire here:

    http://www.mediafire.com/file/9osa0m3pp2a3eel/My%20Aquarium%20V4.xlsm

    For those users of Microsoft Office XP and 2003 Excel, here is the xls file:
    (Remember, xls files are much larger than xlsx or xlsm files)

    http://www.mediafire.com/file/cowdzx32ahc30o1/My%20Aquarium%20V4.xls

    Alternatively there is a 'Microsoft Office Compatibility Pack for Word, Excel, and PowerPoint File Formats' available here:
    (This of course will allow you to open and use the much smaller xlsx and xlsm files)

    http://www.microsoft.com/downloads/en/details.aspx?FamilyId=941B3470-3AE9-4AEE-8F43-C6BB74CD1466&displaylang=en
    « Last Edit: April 16, 2011, 02:54:01 am by clive1512 »

    Offline karl2784

    • Full Member
    • **
    • Thank You
    • -Given: 5
    • -Receive: 1
    • Posts: 426
    This is cool. :)
    Only thing is - I can't remember exact dates I bought my fish so I just put month/year ish and ot automaically changes to default date eg 01/01/1905 lol but can't change the call format due to security...
    Carl
    Juwel Rio 350L:
    20 Black Neons
    1 BN Plec
    3 Golden Barb
    2 Cherry Barbs
    5 Harlequin Rasbora
    3 Otos
    3 Precox Rainbows
    4 Blind Caves
    3 cobra guppies
    15 Clouds
    Live Plants
    Bogwood

    Offline vess

    • Retired
    • TFF Supporter
    • Hero Member
    • *****
    • Thank You
    • -Given: 6
    • -Receive: 231
    • Posts: 3977
    Excellent work!