Aquarium Log

[MojaveReefer]

Hey guys, I have this posted on another board but I thought you all may like it too.

Updated again...now with pics!

Test Results Sheet



Graphing Feature


This Log uses macros for functionality and they must be enabled to utilize the log.

Key Features
Complete test array logging
1 button archive feature
1 button clear feature
Graphs for every test
Ability to view graph from current results or archive with the click of a button
Printable blank sheet for field testing

If you guys would like to get a copy you can post or pm me an email address.

If you guys can think of some other features they would like to see added let me know and I'll try to add them.

-Sean

 

[eldiablosrt8]

Very cool

I would like to check it out

 

[MojaveReefer]

Just need an email to send it to.

 

[gdm42001]

Like it

 

[MojaveReefer]

I sent a copy your way, give me some feedback on it when you can, I'm trying to figure out what else can be added.

 

[northbay-reefer]

It would be nice to have a line for water change and a column for percentage of water change.

 

[MojaveReefer]

You mean a column style graph as opposed to the line style?

 

[northbay-reefer]

Using the same chart with the testing numbers, this way we will know when we did the water change and how it effects the parameter. Something like this

 

[MojaveReefer]

Oh I see what you're saying, like a larger indicator on the sheet when a water change is done because it will change the rest of the parameters?

If that's what you're talking about I could use some conditional formatting so that when a water change is done it will highlight the rest of that line whatever color I choose. I could also make it place "Water Change" in the comments automatically if a value is entered in the water change column.

 

[zeroinverse]

Would any of you find this useful as a web application? To do all your logging? And eventually as an iPhone app?

Or does a controller basically do all of this

 

[MojaveReefer]

Would be handy as an iPhone app, I would love to see that.

 

[gdm42001]

I sent a copy your way, give me some feedback on it when you can, I'm trying to figure out what else can be added.

Thanks Sean, looks great, will give it a workout:headwalls:

 

[northbay-reefer]

Oh I see what you're saying, like a larger indicator on the sheet when a water change is done because it will change the rest of the parameters?

If that's what you're talking about I could use some conditional formatting so that when a water change is done it will highlight the rest of that line whatever color I choose. I could also make it place "Water Change" in the comments automatically if a value is entered in the water change column.

Yessirybob

So many things can change the parameters so I am not sure you want to add all of them:

Water changes, additives, water top off, calcium reactor adjustments, adding live stock/corals, adding/subtracting equipment, the use of chemical filtration, etc.

 

[MojaveReefer]

Yeah there are a lot of factors that would flag changes in the other parameters. It would be a lot of code to write to make a spreadsheet that intelligent.

 

[brundel666]

Hi there
Just wondering if you could send me a copy of your spreadsheets.
Im new to the site but it would be really useful.
I currently have 3 freshwater tanks but im now going to try my first saltwater.
My email is karl_blake@sky.com
Hope to hear back from you and thanks

 

[MojaveReefer]

Hi there
Just wondering if you could send me a copy of your spreadsheets.
Im new to the site but it would be really useful.
I currently have 3 freshwater tanks but im now going to try my first saltwater.
My email is karl_blake@sky.com
Hope to hear back from you and thanks

I'll get it out to you after I get home, at work right now. Sorry for the late reply, I haven't been on the past couple of days.

-Sean

 

[MojaveReefer]

OK Karl I sent it out to you, let me know how it works for you.

-Sean