reports in excel with ABB ac800m plc
Hi everybody
I was designing a project with AC800m plc and compact HMI, i want to create a schedule report in excel in schedule structure, but the tag was unsuccessful
in 800xa i know that its posible because the link its direct, but ac800m not,
excel and template appear and depend of the time selected ( every hour,day) but the information of the variables is deleted
this option its posible in ac800m using some configuration or version compatiblity or definitely was null and only apply in 800xa
please help me about this topic
best regards
Answers
AFAIK the Excel Data Direct and Scheduring software packages are identical between 800xA and CHMI.
One of the differences is tag creation. With 800xA and AC800 Connect your application's objects and variables immediately become visible in the Control Structure.
CHMI lacks the AC800 Connect software and its suggested to make use of PLC Connect instead to upload/create your objects from the AC800 OPC Server.
The first thing you need to resolve is being able to "Subscribe for live data" in some Control Connection aspect of your CHMI system, either from Generic OPC Upload or PLC Connect uploading (here the Control Connection aspect is named Real PCA, Integer PCA, etc).
Once you get live data in Plant Explorer to work you should be able to use Data Direct too, e.g. the ABBGetOPCDA() function.
If historized values are required, you must deploy and configure Log Templates and Log Configurations where you sample values from some Control Connection aspect and store them in the Basic History service, then you can read the logs using ABBGetOPCHDA() function in Excel Data Direct.
Excel Data Direct have a browser with which you can browse for tags or logs and "Insert value" or "Insert function" into Excel, the latter will expose the ABBGetXXX() functions and parameters required.
Good luck
/Stefan
Add new comment