The Big Controller Comparison Chart. - Page 11

davidryder · #**251** 04/30/2007, 09:11 PM

So you are saying it would be useful to compare a select few side by side?

RokleM · #**252** 04/30/2007, 09:24 PM

Yes... Let's say you have it narrowed down to 3-4 and you're attempting to compare and features of the 3-4 remaining models.

invincible569 · #**253** 04/30/2007, 09:28 PM

I like your idea Rokle. Maybe have them in different categories by price.. the 100-499 category, 500-899, etc. The deciding factor for most people is the price.

RokleM · #**254** 04/30/2007, 09:41 PM

If you want to get real fancy, add in the estimated prices for the add on components and the ability to select them, since hardly any of the kits are complete out of the box

jdieck · #**255** 05/01/2007, 12:42 AM

Quote:

Originally posted by RokleM
I already made my decision and went with the AC3 for many reasons, however here's a suggestion that would have made things easier: Make it so users have more ability with the spreadsheet. For example, I hated to have all the columns when I was attempting to compare a few side by side. Instead I had to copy the data out and into a new sheet to see it side by side. I understand your reasons for protecting the spreadsheet, but maybe it's possible via macros or something.

Just a thought.

Something like this?

melev · #**256** 05/01/2007, 12:54 AM

Way cool!

davidryder · #**257** 05/01/2007, 01:04 AM

A little buggy but I like it... can you iron out the errors or was that as far as you got?

davidryder · #**258** 05/01/2007, 02:52 AM

You get a run-time error when you protect the sheet and attempt to remove columns. Also clicking on "View All"

invincible569 · #**259** 05/01/2007, 05:37 AM

Quote:

Originally posted by jdieck
Something like this?

there you go. That does help. I also like how you color coded them by price range. Price should be at the top of the list because of its importance, no?

RokleM · #**260** 05/01/2007, 07:19 AM

Quote:

Originally posted by jdieck
Something like this?

jdieck · #**261** 05/01/2007, 07:49 AM

Quote:

Originally posted by davidryder
You get a run-time error when you protect the sheet and attempt to remove columns. Also clicking on "View All"

Yes, it is easy to correct but I can't solve it without the password, Because of the protection, the prgram does not allow to change formats, the way to solve it is for the macro to unprotect the sheet and protect it back again as soon as the macro finished running.
Same thing for the pics. Can't reattach them without the PW.

jdieck · #**262** 05/01/2007, 07:51 AM

Quote:

Originally posted by invincible569
there you go. That does help. I also like how you color coded them by price range. Price should be at the top of the list because of its importance, no?

I did not do the colors (I think David did), Pricing wise, if it were on top would you look at all the features?

invincible569 · #**263** 05/01/2007, 07:56 AM

Quote:

Originally posted by jdieck
I did not do the colors (I think David did), Pricing wise, if it were on top would you look at all the features?

Just as long as it fits the budget.

jdieck · #**264** 05/01/2007, 08:37 AM

Quote:

Originally posted by invincible569
Just as long as it fits the budget.

Well at least you know that the farther right you go the more expensive it will be.

===>> +++

RobbyG · #**265** 05/01/2007, 12:38 PM

Ok so a guy leaves for 12 hours and you guys make major discoveries without me

Thanks Jdieck, you and David are the Guru's of Excel.

Jdieck if you want I can email you an unlocked version. Just PM me your acct info.

RobbyG · #**266** 05/01/2007, 12:50 PM

Quote:

Originally posted by invincible569
Just as long as it fits the budget.

Budget ?? You use a budget on your Aquarium?? I knew I was missing out something when I started

Konadog · #**267** 05/01/2007, 12:52 PM

I love how this just keeps getting better!

Now on to skimmers, pumps, powerheads, etc................

jdieck · #**268** 05/01/2007, 03:51 PM

Quote:

Originally posted by RobbyG
Ok so a guy leaves for 12 hours and you guys make major discoveries without me

Thanks Jdieck, you and David are the Guru's of Excel.

Jdieck if you want I can email you an unlocked version. Just PM me your acct info.

Rob:
Your PM is full.

RobbyG · #**269** 05/01/2007, 04:33 PM

Sorry about that. I was in a 3 hour meeting and just got out.
The PM box is now cleared.

davidryder · #**270** 05/01/2007, 05:52 PM

Quote:

Originally posted by jdieck
Something like this?

Ok I love the module... did you import that or write it on the fly? Nice... I think that we should collaborate off-line and provide one version on the website so several different copies aren't floating around.

If it's ok I'll load that module into the version I have and I'll send you a link to it if you PM me your email address. From there, if you're interested, we can 'reply all' and you, Robby, and myself can discuss development. Otherwise I'll just steal your code and take it from there.

Thanks!!

invincible569 · #**271** 05/01/2007, 09:40 PM

Robby, I have noticed that at font size 8, things look a lot better and easier to read.

RobbyG · #**272** 05/01/2007, 11:00 PM

Quote:

Originally posted by invincible569
Robby, I have noticed that at font size 8, things look a lot better and easier to read.

Looking it at set to 8 and it does look better

RobbyG · #**273** 05/01/2007, 11:09 PM

Jdieck that is awesome work

it's better than I imagined

Thanks you, so very much for the upgrade.
You and David have really made it look and function so much better.
Thanks again

jdieck · #**274** 05/01/2007, 11:12 PM

Quote:

Originally posted by RobbyG
Jdieck that is awesome work it's better than I imagined
Thanks you, so very much for the upgrade.
You and David have really made it look and function so much better.
Thanks again

Hope it does the job once is up on the site.
Enjoy!

invincible569 · #**275** 05/03/2007, 01:53 PM

Robby.. need to update the Aquacontrollers to the new look

http://www.neptunesys.com/