Aquarium Log Sheet

[VB68]

Could you please add me to the growing list. Looks like it could be very useful. thanks chneal2009@hotmail.com

[miyzfrider]

I would appreciate a copy as well. Email is lcarlson41@gmail.com. One thought, if you have a gmail account, you can post things like this in Google Docs and share it with a link. Maybe an option??? Thanks.

[MojaveReefer]

Originally Posted by 535freak

I would like one too please. Thanks.
maliagracie@sbcglobal.net

Originally Posted by Lofty

I started to make one at first, but stopped using it because it wasnt very user friendly... My email is dan.marketwise@gmail.com

Thank you!!

Originally Posted by Lamball1

OOOOOhhh, please me too: lamball1@hotmail.com

thx

Originally Posted by PistolShrmp

Please send one to me as well.

jcoate2004 (at) yahoo (dot) com

Thanks!!

Originally Posted by Firegrant

I would love a copy of this wonderful tool!

grantmusser(at)gmail(dot)com

Thanks!

Originally Posted by carlos413

Could I please get a copy of this file? thanks
djnyceone@gmail.com

Originally Posted by lolgranny

Could someone shoot me a copy of this? Its very well done!!!

I would appreciate it,
Thank you

daughtersftw@yahoo.com

Originally Posted by Garibaldi

I'd like to get a copy also when you have the chance. It's a lot nicer than the one I put together myself.

asmosely@bellsouth.net

Thanks!

Originally Posted by phasezero

Would love to try this log out. Send to jefabian@comcast.net

Thanks again for your time and effort.

Originally Posted by theshiver

Please add me to the list lurch@windstream.net

Originally Posted by dhickey

Please add me to the email. Thanks in advance!

d.hickey79@yahoo.com

Originally Posted by VB68

Could you please add me to the growing list. Looks like it could be very useful. thanks chneal2009@hotmail.com

Originally Posted by miyzfrider

I would appreciate a copy as well. Email is lcarlson41@gmail.com. One thought, if you have a gmail account, you can post things like this in Google Docs and share it with a link. Maybe an option??? Thanks.

Okay I got it out to all of you. Apologies for the delay this go around, overtime at work has been brutal, many 16 hour days this past week and a half.

@Carlson41 - Google docs does not support everything the sheet is programmed to do, there is a lot of work done in visual basic, and soon the conditional formatting.

More on the Conditional formatting...this is the feature most requested to be added in. I have gone through a few iterations of it trying to get the cleanest formulas and code possible. I have a working version with the adjustable "Acceptable Range" and conditional formatting and it looks and works great, however, some folks (myself included) don't like the conditional formatting a lot.

My new addition currently being worked in is a button to disable the conditional formatting for users that do not want it, this is not a "built in" feature of excel and requires some working around with visual basic and creative formulas to achieve. You will be able to turn it on and view on target or out of tolerance cells at a glance, or turn it off and view the chart without colored cells. I should have this working the way I want it for a release within a week or two depending on how much time I get to sit here on the computer.

Thank you all again for trying this sheet out, it's been a great pleasure to share this, I hope it has been helpful to you all. I can't wait for you guys to see the updated version.

Note: This sheet is being created in Excel 2010, some conditional formatting, colors, etc. are not backwardly compatible with Excel 2007 or 2003. I'm doing my best to ensure all users will have the same experience but it will not always be possible. Most everything should be fine with Excel 2007, some will not work with 2003.

-Sean

[Lamball1]

Thanks a lot! It works great!

[Lowefx]

I also would like a copy, as i am starting a new tank this week. Many thanks. lowefx@gmail.com

Thank you!

[schoi]

Can I please get a copy as well? melloyello512@gmail.com

[miyzfrider]

Originally Posted by MojaveReefer

@Carlson41 - Google docs does not support everything the sheet is programmed to do, there is a lot of work done in visual basic, and soon the conditional formatting.
-Sean

Sean, first, thanks so much for shooting that my way so quick! I look forward to playing around with it and will definitely post back if I have any thoughts or ideas.

What I was suggesting was just simply placing it up on Google to share, not as a "live" Google docs file. You have the option when uploading a doc or xls file to convert it to Google Docs format or not. If you just uploaded it as an Excel file, and didn't convert it, then I'd think you could share it as an xls file from there. I gave it a try on my Google account and it worked just fine. You just have to choose to download the original if it does open as a Google Docs document.

Regardless, thanks again!!

Lars

[MojaveReefer]

Originally Posted by miyzfrider

Sean, first, thanks so much for shooting that my way so quick! I look forward to playing around with it and will definitely post back if I have any thoughts or ideas.

What I was suggesting was just simply placing it up on Google to share, not as a "live" Google docs file. You have the option when uploading a doc or xls file to convert it to Google Docs format or not. If you just uploaded it as an Excel file, and didn't convert it, then I'd think you could share it as an xls file from there. I gave it a try on my Google account and it worked just fine. You just have to choose to download the original if it does open as a Google Docs document.

Regardless, thanks again!!

Lars

Oh okay Lars, I misunderstood you. I'm going to get around to uploading it somewhere eventually. I'd like it to be pretty well finished first though, I think I would lose a lot of the feedback I could be receiving by not communicating with the folks that are trying it. I think it may be all set to go in the near future though.

[MojaveReefer]

Well everyone I made some time today to put the finishing touches on the adjustable parameters, conditional formatting, and the ability to turn conditional formatting on or off at the click of a button. I am very pleased and excited with the way this has turned out, I hope you all enjoy it was well.

New Features

*Adjustable Parameters - Not everyone runs their tank the same, I've made it possible to set your own parameters.

*Conditional Formatting - Provides at a glance in or out of tolerance viewing by coloring cells. I also added the ability to turn this feature on or off.

Other Changes

*Reduced archive size from 4000 entries to 1000 entries to improve long term performance.

*Miscellaneous cosmetic and functional changes



Here are some screen shots of the new results sheet


Conditional Formatting Off

All you have to do for adjusting the parameters is type in the number you want, I have my temp set From 77 To 82, if I wanted to run my tank a little cooler all I would need to do is replace the 77 with whatever number I choose, It works the same with all the parameters. The graphing is also tied in to the adjustable parameters so you won't miss a beat.




Conditional Formatting On

The small check box above the notes section is what turns the conditional formatting on or off, checked box = on unchecked box = off, it's that easy. Please be aware if you click the archive button while the conditional formatting is on it will copy over colored cells to the archive, if that's how you like it great! If not be sure to turn it off before archiving.



If anyone would like an updated copy please let me know. I need everyone's help to continue to make this better, please leave me your thoughts or any bugs that you may find so I can fix and improve. Thanks

-Sean

[miyzfrider]

I'd love a new copy Sean! Thanks again, and regarding the Google Docs idea, no problem. Just a suggestion to help you sometime so you don't have to email it constantly.

Great work!

lcarlson41@gmail.com

[MojaveReefer]

Originally Posted by Lowefx

I also would like a copy, as i am starting a new tank this week. Many thanks. lowefx@gmail.com

Thank you!

Originally Posted by schoi

Can I please get a copy as well? melloyello512@gmail.com

Sent out a brand spanking new copy to you guys, enjoy

Originally Posted by miyzfrider

I'd love a new copy Sean! Thanks again, and regarding the Google Docs idea, no problem. Just a suggestion to help you sometime so you don't have to email it constantly.

Great work!

lcarlson41@gmail.com

I re-sent yesterdays group the new version, didn't want you guys to feel left out.

-Sean

[theshiver]

Please put me in line for update lurch@windstream.net

[MojaveReefer]

Originally Posted by theshiver

Please put me in line for update lurch@windstream.net

already took care of ya shiver

-Sean

[catchprj]

That looks fantastic! I would love a copy

Thanks!

detartrated@gmail.com

[MojaveReefer]

Originally Posted by catchprj

That looks fantastic! I would love a copy

Thanks!

detartrated@gmail.com

Sent, enjoy it!

-Sean

[theshiver]

Thanks for all your hard work I love it. Is there a way on the TDS page to be able to enter gallons so we can track our RODI filter/resin life?

[MojaveReefer]

Originally Posted by theshiver

Thanks for all your hard work I love it. Is there a way on the TDS page to be able to enter gallons so we can track our RODI filter/resin life?

I like what you're thinking about here, hadn't crossed my mind to track RO/DI filter/membrane/resin. The short answer is no there is not, it can't be tracked right now. I could definitely add that in, I just need to know what has to be tracked. Is it gallons of RO/DI created? Gallons run through the system? (if this is the case how will you know how many gallons have passed through it) After the tracked figure is sourced I'd need to know what the cutoffs for replacing filters, membrane, and resin would be. The only issue I see with this is everyone's water source is so different that it would be highly inaccurate. I think the best that I could do to make an effective tool for tracking these figures would be countdown reminder. You would put in the date you changed your filter/membrane/resin and then set how many days from then you wanted it changed, the sheet would then remind you it's time to change said part. That's what's going through my head, let me know if you have something else going through yours and maybe we can make something happen. Thanks for the great idea

-Sean

[MojaveReefer]

...double post

[wkonops]

I can see that your spreadsheet looks great, better than anything I have seen. I would love a copy, if you could send one to me I would appreciate it.

Thank you in advance,
Walter

wkonops@yahoo.com

[Jarred1]

Can you please send me a copy of the spread sheet to alyaj06 @ gmail . Com

[MojaveReefer]

Originally Posted by wkonops

I can see that your spreadsheet looks great, better than anything I have seen. I would love a copy, if you could send one to me I would appreciate it.

Thank you in advance,
Walter

wkonops@yahoo.com

Thank you for the kind words Walter, I sent your copy out.

-Sean

[signalman]

Spreadsheet looks great. Can you send me a copy to mccoykd@me.com it would be much appreciated.

[MojaveReefer]

Originally Posted by Jarred1

Can you please send me a copy of the spread sheet to alyaj06 @ gmail . Com

Originally Posted by signalman

Spreadsheet looks great. Can you send me a copy to mccoykd@me.com it would be much appreciated.

Sent out to you guys, enjoy

-Sean

[theshiver]

Originally Posted by MojaveReefer

I like what you're thinking about here, hadn't crossed my mind to track RO/DI filter/membrane/resin. The short answer is no there is not, it can't be tracked right now. I could definitely add that in, I just need to know what has to be tracked. Is it gallons of RO/DI created? Gallons run through the system? (if this is the case how will you know how many gallons have passed through it) After the tracked figure is sourced I'd need to know what the cutoffs for replacing filters, membrane, and resin would be. The only issue I see with this is everyone's water source is so different that it would be highly inaccurate. I think the best that I could do to make an effective tool for tracking these figures would be countdown reminder. You would put in the date you changed your filter/membrane/resin and then set how many days from then you wanted it changed, the sheet would then remind you it's time to change said part. That's what's going through my head, let me know if you have something else going through yours and maybe we can make something happen. Thanks for the great idea

-Sean

What I was thinking for our DI Resin, is if we entered our TDS and Gallons at the same time we could see at what Gallon usage our TDS starts to climb, and at what Gallon usage the TDS is to high. From there set your color, good/bad/neutral, and have a count down timer for filters and membrane. However, this would only work for the RO/DI units that have flow meters instaled. Just a thought.

[Reefers Digest]

I would appreciate a copy.

chrisozolins@gmail.com

Thanks Sean.