Show me your ACIII Program

[ZoeReef]

OK, consider me "wow'd" This is awesome.

Have you ever considered offering this on a disk?

You are light years ahead of my VB knowledge and I can't see trying to learn that, but what you have here is way up there on the 'kewl' factor and even more so, the trend lines make "trending" very intuitive. You can see when measurements are moving.

 

[jnarowe]

uh...so do you like chocolate?? Can you compile your code into a self executable file and send it to other people? The trend line alone is worth some bucks!

 

[kbecker]

Thank you all for the kind words, but excel is far more powerful then most users realise. The trend line is a built-in function of excel.

 

[jnarowe]

Well I am sure but putting it all together into a usable system is not within the capabilities of some of us...namely, ME!

 

[Double-J]

<a href=showthread.php?s=&postid=7359347#post7359347 target=_blank>Originally posted</a> by jnarowe
Well I am sure but putting it all together into a usable system is not within the capabilities of some of us...namely, ME!

Agreed, That would be awesome if you could put it in some kind of ready to use program, It's probably a lot to ask.

 

[kbecker]

Well this is still a work in progress. After this last trip, I realized I need convert my device names to logical names; ie LT1 = Day Light, MON = Moon Light, etc. My tank sitter (non-reefer) was confused when he was checking up on the tank from his home.

 

[ZoeReef]

kbecker.. You have something that is really great here. Obviously those willing to spend the extra for a controller are intensely interested in how things are going, and what you already have makes a complex task even more intuitive. On a scale of 1-10 in excel, I'm probably a 4. I'm comfortable generating charts etc, but the scripting that imports it and creates new charts is beyond what I know. Everything in reefing seems to be a work in progress, and if you are inclined to share what you have, I wouldn't get stuck (my modus operandi) trying to develop the ultimate. Thanks for the tip on the trend. I'll be looking that one up.

 

[kbecker]

The following link will have a copy of a modified verison of my sheet. I have removed my ftp address (so you can replace it) and removed all my server back up code (this would generate a ton of errors as address are hard coded).

The terms and conditions for usage is that I am providing this AS IS for your reverse engineering enjoyment. If you make any improvements to the sheet, please post it for others to enjoy.

My Reef Data Excel sheet

 

[ZoeReef]

hey..u da man. AWESOME. Accepted. I'm still awaiting the arrival of my unit so I won't be able to sync as yet.

Reverse engineering we go. ALL YOU EXCEL REVERSE ENGINEERS..PLEASE POST WHAT YOU FIGURE OUT HERE!

 

[jnarowe]

I can't figure any of that out...looks pretty though!

 

[ZoeReef]

jna..it's really not. Go back up this page to where he has pasted some 'raw' data.

Go to your downloaded page and type about 10 rows of that data into the appropriate boxes on the first page of excel sheet.

When you then go to page 2, you will see that the graphs have begun to be charted.

The scripts he is talking about are use to import that data into page 1. The graphs are then plotted automatically. NOW..the issue becomes (and I dont know this answer..yet)...how to work with the scripts to import that data. That should be fairly straight forward.

 

[jnarowe]

I see. I only have a viewer so i need to get Excel to make it work. Thanks for the help!

 

[Double-J]

Zoereef. If you open up internet explorer (not firefox) and log on to your controller then
1) Open Datalog
2) Right click on the data
3) export it to excel
4) then paste it in the correct spot
5) from here it should be querrying from excel

Then do the same for the Status.

Kbecker how do you stop the querry that you have. It seems like every five minutes I get this error message coming up from your AC IP and I can't seem to find a way to get rid of it. You defenetaly it much easier!!! I appreciate it.

Kbecker

 

[ZoeReef]

thanks tiny. I won't have my system up and running until the end of the month and when I do, then I will try this.

If I am able to step through it manually, then I'm sure automating it will not be far behind. The great thing about what kbecker has done here is to really expand our idea of 'what can be done'.

 

[laverda]

Wow! Their is some great info in this thread! I have to get my AC3 working/communicating properly so I can use some of this info. Especially the nice charts kbecker.

 

[JohnLe712]

Wow...These codes are way more than i can imagine. Thanks so much for sharing. .

 

[mobert]

When using MAX Change after a power outage for metal halide lights, should the MAX Change be then "ON" or "OFF"?

In otherwords, does OFF mean that the Metal Halides will stay off and cool down before trying to restart? What would ON do? Would it make something stay ON for a set time before it could turn off?