Messages

31

Open Discussion / Re: Copy 500 element array to Excel?

« on: September 12, 2017, 10:29:18 PM »

Archie,

I would use a bit from PLC to do this.

Thanks.

32

Open Discussion / Copy 500 element array to Excel?

« on: September 12, 2017, 08:00:12 PM »

Hello,

I've been reading through the forum and particularly looking at the KeepingRecordsFromCLXtoExcelFile demo. I'm looking to copy an array of the last 500 cycle time averages for each of the 7 sections of the cell. A total of 3500 tags to 1 excel file.

I have 0 coding experience but do have a few AHMI projects up and working. I've downloaded the KeepingRecordsFromCLXtoExcelFile AHMI project and have set BasicLabel1 to Array address. Currently when I start the project I get the value from AverageCycleArray[0] displayed. I want to work with getting this to excel then move on to the complete array.

I believe I read in one of the post that I can save this to an excel file even without MS Office installed?
If so how to do this?
Will I need a BasicLabel for each array element?

Thanks,

33

Additional Components / Re: Multistate Indicator

« on: August 26, 2017, 02:02:52 AM »

Hello,

Is it possible to reference a tag value in the message box? I'm looking at a cycle timer and going to set up 3 different colors on the multi state dependent on limits set up in PLC I will get a 0, 1, or 2 to control the states. I want the actual timer value to be the message, is this doable? I tried using the multi state and then putting a basic label over top with transparent background but transparent appears to always be white.

34

Open Discussion / Re: Project built, now what?

« on: August 09, 2017, 04:19:25 AM »

Thanks guys, I do believe I will go with a mini PC.

Again, great program and I will be doing a lot more with it.

Thanks.

35

Open Discussion / Project built, now what?

« on: August 08, 2017, 04:00:48 AM »

First off thanks for a great resource. I had looked at AHMI a few times in the past and just a few days ago finally downloaded.

My first project consist of pretty much making a replica of one of our AB Panelview screens. This is a packing area with overhead crane and we have people 40+ feet away looking at a 10" screen and yelling to the person with hand scanner. I will put this on a Raspberry Pi and use the HDMI to a 55" screen.

It took a while to get the string variables worked out but looks good and much more responsive than the AB.

I've looked at a couple dozen tutorials but looking for something specific to loading onto the Pi. Can anyone point me to anything.

Thanks.