Sponsors

Recent Topics

Ammonia Calculator

Articles on TFF UK

Advertisements


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

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

Offline Colin

  • Hero Member
  • ****
  • Thank You
  • -Given: 0
  • -Receive: 0
  • Posts: 1230
Erm is it possible to run this in Open Office? I can't seem to get the macros to work :(

TropicalFishForums

  • Advertisement
  • ***

    Offline Colin

    • Hero Member
    • ****
    • Thank You
    • -Given: 0
    • -Receive: 0
    • Posts: 1230
    bumping as I really want to use this but don't run Windows any longer...

    Offline wobblewobble

    • Hero Member
    • ****
    • Thank You
    • -Given: 0
    • -Receive: 0
    • Posts: 2241
    wow that is amazing work!

    i dont know whether its a possibility but have you thought of going on dragons den with this one  *coffee*

    Offline wobblewobble

    • Hero Member
    • ****
    • Thank You
    • -Given: 0
    • -Receive: 0
    • Posts: 2241
    can i just ask - i am no computer expert and everytime i open its telling me the macros have been disabled and i need to enable to make the spreadsheet work. How do I stop this from happening?

    Offline Colin

    • Hero Member
    • ****
    • Thank You
    • -Given: 0
    • -Receive: 0
    • Posts: 1230
    From memory, I no longer have office. You go to tools, security, macro security - set that to medium I believe.

    then when you open the file you will be asked to activate the macros, say yes, you want it to ask you because there are some macros that can be harmful to computers.

    Offline Thyseus

    • Est. Member
    • ***
    • Thank You
    • -Given: 0
    • -Receive: 1
    • Posts: 997
    • New Fish Keeper
    Wow nice work
    Fluval Roma 90
    Juwel Lido 120

    Guppys, Corys, Tetras, Danios, Cichlids

    clive1512

    • Guest
    Hi all

    Many thanks for all your kind comments.
    Sorry I haven't got back to anyone sooner, I have been so busy at work together with working on a seriously dramatic update to the workbook. I will be posting it soon (I hope)

    Again, many thanks for your comments

    Offline Colin

    • Hero Member
    • ****
    • Thank You
    • -Given: 0
    • -Receive: 0
    • Posts: 1230
    Clive, can you confirm if I can get it to work with Open Office please?

    clive1512

    • Guest
    Hi Colin
    Yes, it has been tested in Openoffice (although not by me) and works fully

    In the post immediately following this reply, I have posted the update.

    When I get time, I will install Openoffice and personally test it

    Regards

    clive1512

    • Guest
    I have made a lot of dramatic changes to the 'Water parameters' Excel workbook (now called My Aquarium)
    For those who have seen the previous version, you will see how dramatic the changes have been.
    See the description below...

    Home page
    From here, you can access the various sections...

    My fish
    List your fish species and record when you add fish & when (if any) have died. This information is used in the 'fish charts' section.

    Fish charts
    See what effect if any, changing one water parameter has on other parameters. In addition, using the information when you added fish & when (if any) have died, along with other selectable data (such as ammonia nitrates etc), you can see any correlation and maybe a possible reason for your fishes demise. Viewable in year view & monthly view, with the ability to print off the charts with any selected chart lines.

    Monthly water parameters
    Record pH, ammonia, nitrites, nitrates, GH, KH, Fe, Co2, (with 'at a glance' charts), fertilisers, root tablets & Co2 bubbles per sec (all used in the fish charts section)

    Tank details
    List your equipment etc
    Up to 2 filters (used in the maintenance section)
    Up to 8 lighting tubes/bulbs (used in the maintenance section)
    up to 8 fertilisers (used in the monthly water parameters & fish charts sections)
    Root tablets in use? (used in the monthly water parameters & fish charts sections)
    Co2 bubble counter in use? (used in the monthly water parameters & fish charts sections)
    Heating, air pump etc

    Maintenance
    Record water changes
    Record gravel vacumn
    Record filter media changes
    Record light tubes/bulb renewals
    Record equipment cleaning

    Disease database
    Database of the most common diseases

    Calculator
    Measurement conversion tables
    Calculate volume, weight & stock level in imperial or metric (with ability to print)
    Ammonia strength calculator (with ability to print)
    Calculate Co2 (with ability to print)
    Fertiliser dosing calculator for the most common fertilisers in use today

    Compatibility guide
    Using known traits, this guide will give you an indication on the compatibility of different species

    Notes
    Various:
    Forum member profile info, useful websites, a calendar & personal notes

    Save

    Backup

    Save As - on completion, there is an option to completely clear all data or partially clear all data (leaving tank details & fish names).

    General
    Auto adjusts workbook display to the best suited for your current screen resolution (does not! change your screen resolution)

    In order to preserve the formatting within the workbook, Cutting, Copying & Pasting have been disabled. Pasting (text only) can still be achieved by right click and paste.

    I would like to add my sincere thanks and gratitude to Toosie for all his help (advise & testing), without whom the workbook would not have grown to this level of detail.

    The file is here:
    http://www.mediafire.com/file/l4g0ispjlv8il4z/My%20Aquarium%20V12a.xlsm

    lukehib

    • Guest
    Re: Seriously dramatic changes to the 'Water parameters' Excel workbook
    « Reply #25 on: May 29, 2011, 05:15:20 pm »
    I can't seem to get it working in Open Office. On the main page with all the 'links' to other spread sheets when I click on them nothing happens. Its as if there just a picture. I have enabled macro aswell. Any tips?  :(

    Offline Colin

    • Hero Member
    • ****
    • Thank You
    • -Given: 0
    • -Receive: 0
    • Posts: 1230
    Re: Seriously dramatic changes to the 'Water parameters' Excel workbook
    « Reply #26 on: May 29, 2011, 05:25:15 pm »
    its not compatible with open office, Clive has said he will work on converting it but it will take time :( fortunately for me I have a copy of Office 2003 somewhere I can use.

    Offline Apache

    • Full Member
    • **
    • Thank You
    • -Given: 0
    • -Receive: 0
    • Posts: 349
    • MMMMmmmm.... Beeeeeer.....
    Re: Seriously dramatic changes to the 'Water parameters' Excel workbook
    « Reply #27 on: May 31, 2011, 06:18:31 pm »
    Has anyone else downloaded it today?

    I did in work just to have a look. It crashed my PC, not allowing it to be shutdown, then when booted back it it ran excruciatingly slowly, with the HD running permanently. I ran Kaspersky AV and it found 'Katusha Trojan' in my downloads folder, the only thing in there being the spreadsheet.

    Is it possible someone's hacked the download site?
    "two very small men cutting steps in the roof of the world"

    Offline Colin

    • Hero Member
    • ****
    • Thank You
    • -Given: 0
    • -Receive: 0
    • Posts: 1230
    Re: Seriously dramatic changes to the 'Water parameters' Excel workbook
    « Reply #28 on: May 31, 2011, 06:28:56 pm »
    I am just installing office 2003 on my PC then I will try the download

    Offline Colin

    • Hero Member
    • ****
    • Thank You
    • -Given: 0
    • -Receive: 0
    • Posts: 1230
    Re: Seriously dramatic changes to the 'Water parameters' Excel workbook
    « Reply #29 on: May 31, 2011, 06:34:23 pm »
    Clive do you have the 2003 file please?