Water Parameter tracking tool!!!

[Iconz]

Alright everyone! I don't know if anyone has one of these yet, but if you don't, I've got a TREAT for you! I've created an Excel spreadsheet that tracks all of your water parm's and puts each one onto a chart for easy reading! If anyone has a special request or need, just let me know, and I can probably make it happen for ya! I've entered dummy data in here to kinda give everyone an idea on how it will look.

Enjoy!!

-JD

Here is the file! (http://www.captivereefs.com/WaterParams.xls)

[Iconz]

Here's some screen shots!!

http://i118.photobucket.com/albums/o101/iconz_reef/mainpage.jpg

http://i118.photobucket.com/albums/o101/iconz_reef/nitratechart.jpg

http://i118.photobucket.com/albums/o101/iconz_reef/Temp.jpg

[graphixx]

OOOHHHHHHHH I LIKE!!!! Right on my friend, that is awesome!!!!!

[Sweetpea]

Very, very nice!

[jojo22]

SWEET BUD. I will definately be useing that when I get ready to start up the 72 gal. (which looks like it may be a while.)

[Iconz]

Heh, my new employer has given me my 3rd week of doing nothing, and I mean NOTHING! So, I've used to become more of a reefgeek :)... go figure eh?

Glad you all like, if you need anything similar for anything else, don't hesitate to ask!

[jojo22]

I think my hair line is reseading but have no desire to chart it but will let you know if I think of anything

[Iconz]

hahahaha!

Example:

11/29/06 - 1/4 inch of loss from previous week
12/12/06 - no trace of hair whatsoever...

:(

[RHAPALA]

this looks great bro i just think i may down load it and give it a go


obtw toooo funny on joes hair line AHAHAHAHAHA

[hummer]

dude u must of spent a ton of time on that verry inpressuv(sp)u should sell it great idea...

[dakar]

Looks like a lot of work went into this...thanks. I'm assuming you are releasing it to the general public, mind if we add a main link to the front page for all to find it easier?

I copied your spreadsheet to our webserver, and edited your link to point to CR to download. Public file share servers are just too easy to be corrupted with malware.

(Just let me know if you make updates to it or whatnot and we can update the file).

*Stickied and Featured!*

[Iconz]

Wow! I'm honored! Sure, you can put it on the front page! Also, seriously... If you all have ANY sugguestions, ideas, preferences, etc... LET ME KNOW! I won't be offended, and I know it will only get better with input from the public! So, feel free to make sugguestions!

T(h)anks!
-JD

[jojo22]

Congats on the great idea!!!!!!!!!

[iVgOnMaD]

cool... dude...

[pogodzib]

Looks good. Much easier that keeping track of things in a notepad or paying for software to track the tank parameters. The only things that I see that are missing are columns for alkalinity and ORP. I'd also recommend having the default zoom being set no larger than 100% on your graph sheets.

[Iconz]

Alkalinity has been taken care of and added in! The ORP, however, I haven't read hardly anywhere that this is something to be worried about; and, in turn, have not found the proper levels to incorporate a measurment range. If you can provide that for me, I can add it in no problem!

Thanks for the feedback!
-JD


By the way... Has anyone been using this? If so, how do you like it? My system isn't wet yet, else I would be.

Dakar, get with me about getting this updated file version, please.

[pogodzib]

I just through out ORP for the people that have ozonizers. Everyone that uses an ozonizer should monitor their ORP (oxygen reduction potential). The ideal range is in the 350 - 450 mv range. Typically, a tank with dirty water will have a lower ORP. I have seen people with dirty water around 200 mv. On the other end of the spectrum, a ORP in the 550 mv area is dangerous to the tank's inhabitants.

BTW - I was planning on trying out your spreadsheet once you added alkalinity to it (not that it wasn't easy enough to do myself).

[Iconz]

I have alkalinity setup so that you could entier it in as DKH and/or MEQ/L. I'll get ORP put in for a range of 200 - 600. If you'll pm me your email, i'll send you the updated file.

[Iconz]

Alright, ORP is in place, I've also made a couple of cosmetic changes that will be nice.

[dakar]

JD if you would zip up the new file and email it to me at dakar@captivereefing.com I'll upload it to the CR server to replace the older version.

[Iconz]

done! :)

[dakar]

done! :)

And done :)

[lemonyx]

I must be blind but I clicked on the link and took me to the front page and I just don't see it. Somebody point it out to me please. It's probably right in front of my eyes and can't see it. :shrug:

I found it :doh:

[greenstarfish03]

link seems to be broken? Anyone have this?

[jimsflies]

I'll have to see if I can find it in the old site stuff. Most of the old attachments are gone...it was an unfortunate casualty of moving to the new site and my inexperience. I have had some experts look into recovering the attachments, but they said it couldn't be done. (Meaning we can't match them back to the old posts. I may be able to dig through the attachments and find this particular file though.)

[greenstarfish03]

Thanks. Just let me know if you find it. If not no big deal. It just looked cool and helpful.

[meteors16]

I would love to try it but the link doesn't seem to be working!!

[rarelyseriousb]

I would love to us a tracking tool like this right now. If we cant get this file back can we take down the post?

[jimsflies]

I found the old file and fixed the link.

[rarelyseriousb]

thanks a lot this will help

[rbeaudrie]

Thanks!!

[creefer]

It's a great tool. I have modified the file to track MB7, Reef Biofuel, 2-part dosing, and water changes. It's helped me to find the "sweet spot" and maintain it. Definitely a benefit.

[whitetiger61]

i use this all the time..its a great tool for me..i have it on my desktop for easy access

Rick