Tropical Fish Forums UK
The Aquarium. => Tank Logs. => Topic started by: clive1512 on March 29, 2011, 09:03:05 pm
-
Hi
Please see reply below for the latest update (now version 12a)
-
*applause*
Superb, thanks for sharing.
-
Nice one Clive :)
-
That looks excellent... you've obviously worked hard on that. Thank you :)
-
Wow, an incredibly detailed and useful spreadsheet. I particularly like the disease database and the conversion calculator at the back :)
-
quick question, there is a comment on cell B15 sheet Jan. How do I remove it? I am using excel 2003
-
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
-
thanks that little red triangle has been doing my nut lol
-
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
-
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
-
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
-
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
-
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)
Maintenance
(http://www.mediafire.com/imgbnc.php/0df031f9f29d8d51f998e11b39df9453f9c6c2f0c6c02d23d0e08591d42c05e96g.jpg)
Disease database
(http://www.mediafire.com/imgbnc.php/11ada88842005526e58337aa7c88e2a34a04dc797012277b717786337fda629b6g.jpg)
Calculator
(http://www.mediafire.com/imgbnc.php/c74afd781e9bff66fefaf519ebea06a6a567a2c73efe6a97f3190760109919f36g.jpg)
Compatibility guide
(http://www.mediafire.com/imgbnc.php/8fafdb51bc82101707108d5a0c7c5d98e633c328bb43693a8411c843c62e484a6g.jpg)
Notes
(http://www.mediafire.com/imgbnc.php/e04489019b9b04b368accae1e4951075af8e69a58126288873889994508574196g.jpg)
The file is on Mediafire here:
http://www.mediafire.com/file/9osa0m3pp2a3eel/My%20Aquarium%20V4.xlsm (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 (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 (http://www.microsoft.com/downloads/en/details.aspx?FamilyId=941B3470-3AE9-4AEE-8F43-C6BB74CD1466&displaylang=en)
-
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
-
Excellent work!
-
Erm is it possible to run this in Open Office? I can't seem to get the macros to work :(
-
bumping as I really want to use this but don't run Windows any longer...
-
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*
-
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?
-
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.
-
Wow nice work
-
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
-
Clive, can you confirm if I can get it to work with Open Office please?
-
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
-
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)
-
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? :(
-
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.
-
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?
-
I am just installing office 2003 on my PC then I will try the download
-
Clive do you have the 2003 file please?
-
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:
http://www.microsoft.com/downloads/en/details.aspx?FamilyId=941B3470-3AE9-4AEE-8F43-C6BB74CD1466&displaylang=en (http://www.microsoft.com/downloads/en/details.aspx?FamilyId=941B3470-3AE9-4AEE-8F43-C6BB74CD1466&displaylang=en)
Otherwise the Excel 2003 file is here:
http://www.mediafire.com/file/eln774dhreszb37/My%20Aquarium%20V12a.xls (http://www.mediafire.com/file/eln774dhreszb37/My%20Aquarium%20V12a.xls)
Regards
Clive
-
thanks for the compatibility link, I forgot about that lol
-
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?
-
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?
-
i couldn't download it earlier but it might have been a server blip. I will try again when i get home.
-
yep appears to be a server blip as I just downloaded it fine :D thanks for the help
-
Glad to be of help Colin. Any problems, give me a shout.
-
Hi mate, keep getting the error
Run-time error '438':
Object doesn't support this property or method
any ideas?
-
Hi Colin
What version of Excel are you using?
-
Was using 2003 but pc died now so can't do anything now. I used the ms converter. Also tested on windows
-
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
-
thanks, I will be back on a computer a little bit as we have aquired an old computer off a friend.
-
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. :)
-
Hi Clive' great stuff very handy, Thanks for sharing.Mark
-
new to this can someone please explain this to me and is there a 2010 excel version
-
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.
-
*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.
-
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?
-
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
-
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.
-
This works.....
http://www.mediafire.com/download/cowdzx32ahc30o1/My+Aquarium+V4.xls