The Aquarium. => Tank Logs. => Topic started by: clive1512 on March 29, 2011, 09:03:05 pm
Title: Seriously dramatic changes to the 'Water parameters' Excel workbook
Post by: clive1512 on March 29, 2011, 09:03:05 pm
Hi Please see reply below for the latest update (now version 12a)
Title: Re: Final version of my spreadsheet
Post by: L_Plates on March 29, 2011, 09:08:29 pm
*applause*
Superb, thanks for sharing.
Title: Re: Final version of my spreadsheet
Post by: plankton on March 29, 2011, 10:39:37 pm
Nice one Clive :)
Title: Re: Final version of my spreadsheet
Post by: DEE on March 29, 2011, 10:41:48 pm
That looks excellent... you've obviously worked hard on that. Thank you :)
Title: Re: Final version of my spreadsheet
Post by: stonec0ld 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 :)
Title: Re: Final version of my spreadsheet
Post by: Colin 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
Title: Re: Final version of my spreadsheet
Post by: clive1512 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
Title: Re: Final version of my spreadsheet
Post by: Colin on April 09, 2011, 08:40:01 pm
thanks that little red triangle has been doing my nut lol
Title: Re: Final version of my spreadsheet
Post by: clive1512 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
Title: Re: Final version of my spreadsheet
Post by: Colin 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
Title: Re: Final version of my spreadsheet
Post by: Colin on April 14, 2011, 04:06:41 pm
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
Title: Re: Latest version of my spreadsheet
Post by: clive1512 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
Title: Re: Major update to Spreadsheet for recording Aquarium water parameters and more
Post by: clive1512 on April 15, 2011, 10:00:43 pm
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 (http://www.mediafire.com/imgbnc.php/3f5fdcffee4c5844e6efd3d3d61765e0d85f3435c4cd8a668fe5b2fb31786fa36g.jpg)
Water parameters (with pH, Ammonia, Nitrites & Nitrates) (http://www.mediafire.com/imgbnc.php/34a3d4e05fcb33b9654b20d3a0db132c1fc84e9fba01bf44da120c3b6d3a24796g.jpg)
Water parameters (with GH, KH, Fe & CO2) (http://www.mediafire.com/imgbnc.php/a2e14d2e20f9f4b3ef1ce0cd17f9e7a6c06ade5291b86343a01aea212081e7f16g.jpg)
Tank details (http://www.mediafire.com/imgbnc.php/a5813d4ecc6eb9c2e077007a5c6dab969e28f20adf43dcf396c70afbb604d1ba6g.jpg)
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)
Title: Re: Major update to Spreadsheet for recording Aquarium water parameters & more
Post by: karl2784 on April 25, 2011, 03:06:10 pm
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
Title: Re: Major update to Spreadsheet for recording Aquarium water parameters & more
Post by: vess on April 25, 2011, 11:29:03 pm
Excellent work!
Title: Re: Major update to Spreadsheet for recording Aquarium water parameters & more
Post by: Colin on April 26, 2011, 02:02:31 pm
Erm is it possible to run this in Open Office? I can't seem to get the macros to work :(
Title: Re: Major update to Spreadsheet for recording Aquarium water parameters & more
Post by: Colin on April 30, 2011, 02:45:34 pm
bumping as I really want to use this but don't run Windows any longer...
Title: Re: Major update to Spreadsheet for recording Aquarium water parameters & more
Post by: wobblewobble on April 30, 2011, 06:19:04 pm
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*
Title: Re: Major update to Spreadsheet for recording Aquarium water parameters & more
Post by: wobblewobble on April 30, 2011, 06:48:21 pm
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?
Title: Re: Major update to Spreadsheet for recording Aquarium water parameters & more
Post by: Colin on April 30, 2011, 07:41:03 pm
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.
Title: Re: Major update to Spreadsheet for recording Aquarium water parameters & more
Post by: Thyseus on May 10, 2011, 09:53:30 am
Wow nice work
Title: Re: Major update to Spreadsheet for recording Aquarium water parameters & more
Post by: clive1512 on May 19, 2011, 09:19:26 pm
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
Title: Re: Major update to Spreadsheet for recording Aquarium water parameters & more
Post by: Colin on May 19, 2011, 09:42:31 pm
Clive, can you confirm if I can get it to work with Open Office please?
Title: Re: Major update to Spreadsheet for recording Aquarium water parameters & more
Post by: clive1512 on May 19, 2011, 10:35:01 pm
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
Title: Re: Major update to Spreadsheet for recording Aquarium water parameters & more
Post by: clive1512 on May 19, 2011, 10:42:20 pm
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 (http://www.mediafire.com/file/l4g0ispjlv8il4z/My%20Aquarium%20V12a.xlsm)
Title: Re: Seriously dramatic changes to the 'Water parameters' Excel workbook
Post by: lukehib 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? :(
Title: Re: Seriously dramatic changes to the 'Water parameters' Excel workbook
Post by: Colin 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.
Title: Re: Seriously dramatic changes to the 'Water parameters' Excel workbook
Post by: Apache 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?
Title: Re: Seriously dramatic changes to the 'Water parameters' Excel workbook
Post by: Colin on May 31, 2011, 06:28:56 pm
I am just installing office 2003 on my PC then I will try the download
Title: Re: Seriously dramatic changes to the 'Water parameters' Excel workbook
Post by: Colin on May 31, 2011, 06:34:23 pm
Clive do you have the 2003 file please?
Title: Re: Seriously dramatic changes to the 'Water parameters' Excel workbook
Post by: clive1512 on June 01, 2011, 01:50:45 am
Hi Colin
I have uploaded the file in Excel 2003 format. However, I believe I mentioned that the file would be a great deal larger. It is in fact 84.5 Mb. Large file size is a known problem with Excel versions earlier than 2007
May I suggest trying the MS Compatibilty pack first, found here:
Title: Re: Seriously dramatic changes to the 'Water parameters' Excel workbook
Post by: Colin on June 01, 2011, 11:40:29 am
thanks for the compatibility link, I forgot about that lol
Title: Re: Seriously dramatic changes to the 'Water parameters' Excel workbook
Post by: Colin on June 01, 2011, 12:21:11 pm
I am having some trouble with mediafire loading really slowly and not letting me download the 2007+ file at all when it does load, is anyone else having this problem?
Title: Re: Seriously dramatic changes to the 'Water parameters' Excel workbook
Post by: clive1512 on June 01, 2011, 03:16:56 pm
Hi Colin
I have just contacted three of my colleagues (in different parts of the UK). They have just downloaded and opened the workbook without any problems. Not sure what the problem you have is. Is it that you cannot download the file at all?
Title: Re: Seriously dramatic changes to the 'Water parameters' Excel workbook
Post by: Colin on June 01, 2011, 04:07:17 pm
i couldn't download it earlier but it might have been a server blip. I will try again when i get home.
Title: Re: Seriously dramatic changes to the 'Water parameters' Excel workbook
Post by: Colin on June 01, 2011, 06:08:11 pm
yep appears to be a server blip as I just downloaded it fine :D thanks for the help
Title: Re: Seriously dramatic changes to the 'Water parameters' Excel workbook
Post by: clive1512 on June 01, 2011, 08:44:15 pm
Glad to be of help Colin. Any problems, give me a shout.
Title: Re: Seriously dramatic changes to the 'Water parameters' Excel workbook
Post by: Colin on June 08, 2011, 08:27:33 pm
Object doesn't support this property or method any ideas?
Title: Re: Seriously dramatic changes to the 'Water parameters' Excel workbook
Post by: clive1512 on June 10, 2011, 12:17:18 am
Hi Colin
What version of Excel are you using?
Title: Re: Seriously dramatic changes to the 'Water parameters' Excel workbook
Post by: Colin on June 10, 2011, 12:23:08 am
Was using 2003 but pc died now so can't do anything now. I used the ms converter. Also tested on windows
Title: Re: Seriously dramatic changes to the 'Water parameters' Excel workbook
Post by: clive1512 on June 11, 2011, 01:28:59 pm
Sorry to hear that your PC died :( I have been told that the MS Compatibility pack works without any problems with the 2003 .XLS version of the workbook.
Hope you get your PC sorted out. If I can be of help. feel free to give a pm
Regards
Title: Re: Seriously dramatic changes to the 'Water parameters' Excel workbook
Post by: Colin on June 18, 2011, 05:47:19 pm
thanks, I will be back on a computer a little bit as we have aquired an old computer off a friend.
Title: Re: Seriously dramatic changes to the 'Water parameters' Excel workbook
Post by: LostInTheArk on August 09, 2011, 10:08:22 pm
Wow this looks amazing.
Thank you for all your continued hard work. Makes it a lot easier for people instead of making their own excel sheet especially for those of us who aren't so technically minded. :)
Title: Re: Seriously dramatic changes to the 'Water parameters' Excel workbook
Post by: mark on August 09, 2011, 10:36:59 pm
Hi Clive' great stuff very handy, Thanks for sharing.Mark
Title: Re: Seriously dramatic changes to the 'Water parameters' Excel workbook
Post by: cwdeighton on November 17, 2011, 09:07:15 pm
new to this can someone please explain this to me and is there a 2010 excel version
Title: Re: Seriously dramatic changes to the 'Water parameters' Excel workbook
Post by: jaytaff on November 17, 2011, 09:42:07 pm
Not sure if quite a few various people in thread even frequent the forums anymore to be honest ....
But either way, its a spreadsheet to keep info about tanks etc.
Title: Re: Seriously dramatic changes to the 'Water parameters' Excel workbook
Post by: ziawhit on March 22, 2012, 10:32:18 am
*applause*
Just came across this, i had sorted myself a crappy little printed sheet, but this is far superior and sooo much better. Many thanks for this. I will be sure to let others know.
Title: Re: Seriously dramatic changes to the 'Water parameters' Excel workbook
Post by: Gash on February 15, 2013, 10:25:41 am
Hi Clive
Just tried the download link and i get the message " key not correct or file has been deleted", is the spreadsheet still available please?
Title: Re: Seriously dramatic changes to the 'Water parameters' Excel workbook
Post by: Wookiejedi on May 10, 2014, 04:28:12 pm
WOW thats a serious Tank log. It puts my little one to shame. SO I think I shall try this.
Thanks for your hard work making this thumbsup
Title: Re: Seriously dramatic changes to the 'Water parameters' Excel workbook
Post by: robfosters on August 21, 2014, 10:54:23 am
It's been a hell of a long time since the last post, but I really need this spreadsheet.
Does anyone have a link or can anyone email it to me please?
Thanks.
Title: Re: Seriously dramatic changes to the 'Water parameters' Excel workbook
Post by: plankton on August 22, 2014, 09:33:31 am