|
01/15/2012, 12:59 PM | #326 |
Registered Member
Join Date: Apr 2011
Posts: 26
|
Could you please add me to the growing list. Looks like it could be very useful. thanks chneal2009@hotmail.com
|
01/15/2012, 08:03 PM | #327 |
Registered Member
Join Date: Dec 2011
Posts: 103
|
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.
|
01/15/2012, 08:40 PM | #328 | |||||||||||||
Aquarium Log Guy
Join Date: Aug 2011
Location: Mohave Desert
Posts: 346
|
Quote:
Quote:
Quote:
Quote:
Quote:
Quote:
Quote:
Quote:
Quote:
Quote:
Quote:
Quote:
Quote:
@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
__________________
Sean |
|||||||||||||
01/15/2012, 08:41 PM | #329 |
Registered Member
Join Date: Nov 2010
Posts: 203
|
Thanks a lot! It works great!
|
01/16/2012, 11:22 AM | #330 |
Registered Member
Join Date: Jan 2012
Location: Winchester, VA
Posts: 695
|
I also would like a copy, as i am starting a new tank this week. Many thanks. lowefx@gmail.com
Thank you! |
01/16/2012, 06:01 PM | #331 |
Registered Member
Join Date: Aug 2011
Location: Austin
Posts: 76
|
__________________
75G DT, 20GL Sump, RO 160XS Skimmer, Mag 9.5 Return, (1) Vortech MP 40, (2) Tunze, Tunze Osmolator, 700GPH Gl******* Overflow, AI SOL SB Blacks |
01/16/2012, 06:35 PM | #332 | |
Registered Member
Join Date: Dec 2011
Posts: 103
|
Quote:
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 |
|
01/16/2012, 06:38 PM | #333 | |
Aquarium Log Guy
Join Date: Aug 2011
Location: Mohave Desert
Posts: 346
|
Quote:
__________________
Sean |
|
01/16/2012, 07:06 PM | #334 |
Aquarium Log Guy
Join Date: Aug 2011
Location: Mohave Desert
Posts: 346
|
Update to Version 2.0!!!
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
__________________
Sean Last edited by MojaveReefer; 01/16/2012 at 07:15 PM. |
01/16/2012, 07:12 PM | #335 |
Registered Member
Join Date: Dec 2011
Posts: 103
|
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 |
01/16/2012, 07:23 PM | #336 | |||
Aquarium Log Guy
Join Date: Aug 2011
Location: Mohave Desert
Posts: 346
|
Quote:
Quote:
Quote:
-Sean
__________________
Sean |
|||
01/16/2012, 07:24 PM | #337 |
Registered Member
Join Date: Apr 2009
Location: sw missouri
Posts: 156
|
|
01/16/2012, 07:26 PM | #338 |
Aquarium Log Guy
Join Date: Aug 2011
Location: Mohave Desert
Posts: 346
|
__________________
Sean |
01/16/2012, 07:27 PM | #339 |
Registered Member
Join Date: Jun 2011
Posts: 38
|
|
01/16/2012, 07:30 PM | #340 | |
Aquarium Log Guy
Join Date: Aug 2011
Location: Mohave Desert
Posts: 346
|
Quote:
-Sean
__________________
Sean |
|
01/16/2012, 07:41 PM | #341 |
Registered Member
Join Date: Apr 2009
Location: sw missouri
Posts: 156
|
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?
|
01/16/2012, 08:09 PM | #342 | |
Aquarium Log Guy
Join Date: Aug 2011
Location: Mohave Desert
Posts: 346
|
Quote:
-Sean
__________________
Sean |
|
01/16/2012, 08:18 PM | #343 |
Aquarium Log Guy
Join Date: Aug 2011
Location: Mohave Desert
Posts: 346
|
...double post
__________________
Sean |
01/16/2012, 09:05 PM | #344 |
Registered Member
Join Date: Jan 2012
Posts: 1
|
Spreadsheet
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 |
01/16/2012, 09:08 PM | #345 |
Registered Member
Join Date: Dec 2009
Location: West Palm Beach, FL
Posts: 1,262
|
Can you please send me a copy of the spread sheet to alyaj06 @ gmail . Com
__________________
"It happens, and as long as the clowns out there keep paying top dollar, they will stay top dollar. Just a way of life, imagine how much cheaper a Tahoe or Yukon would cost if the word "bling" was never invented..." |
01/16/2012, 09:11 PM | #346 | |
Aquarium Log Guy
Join Date: Aug 2011
Location: Mohave Desert
Posts: 346
|
Quote:
-Sean
__________________
Sean |
|
01/16/2012, 09:11 PM | #347 |
Registered Member
Join Date: Apr 2011
Posts: 8
|
Spreadsheet
|
01/16/2012, 09:29 PM | #348 | ||
Aquarium Log Guy
Join Date: Aug 2011
Location: Mohave Desert
Posts: 346
|
Quote:
Quote:
-Sean
__________________
Sean |
||
01/16/2012, 10:44 PM | #349 | |
Registered Member
Join Date: Apr 2009
Location: sw missouri
Posts: 156
|
Quote:
|
|
01/16/2012, 10:57 PM | #350 |
Registered Member
Join Date: Mar 2011
Location: Port Credit, Ontario
Posts: 111
|
|
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Anybody have a good log sheet they use? | sbonder | New to the Hobby | 4 | 02/24/2010 11:25 AM |
looking for printable water parameter log sheet | cdbias2 | The Reef Chemistry Forum | 3 | 05/10/2007 06:30 PM |
saltwater log sheets | robcropper | Reef Discussion | 4 | 12/18/2006 07:49 AM |
saltwater log sheets | robcropper | New to the Hobby | 1 | 12/17/2006 11:00 PM |
Excel Spreadsheet for Reef Aquarium Logging | theop | Reef Discussion | 8 | 01/27/2006 05:15 PM |