Seriously dramatic changes to the 'Water parameters' Excel workbook

[clive1512]

Hi
Please see reply below for the latest update (now version 12a)

[TropicalFishForums]

[L_Plates]

 

Superb, thanks for sharing.

[plankton]

Nice one Clive

[DEE]

That looks excellent... you've obviously worked hard on that. Thank you

[stonec0ld]

Wow, an incredibly detailed and useful spreadsheet. I particularly like the disease database and the conversion calculator at the back

[Colin]

quick question, there is a comment on cell B15 sheet Jan. How do I remove it? I am using excel 2003

[clive1512]

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

[Colin]

thanks that little red triangle has been doing my nut lol

[clive1512]

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

[Colin]

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

[Colin]

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]

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]

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

[karl2784]

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

[vess]

Excellent work!