Manufacturer Uses OPC to Power Excel Spreadsheets

A maker of electric mirror adjustment actuators upgrades its automation system with OPC DataHub from Cogent Real-Time Systems, simplifying data flow to an Excel workbook and improving reliability.

AW 3099 OPC Cogent
Mirror Controls International(MCI)设计,开发和制造电镜调节执行器和电动式镜面执行器。MCI每年的销售额超过4000万台,是全球最大的执行者独立制造商。他们在爱尔兰Manorhamilton的工厂提供了宝马,大众汽车,捷豹,劳斯·罗伊斯和福特等主要欧洲汽车公司。该设施最近通过从Cogent实时系统实现OPC DataHub来升级其自动化系统。

MCi takes pride in developing its own ideas and solving its own problems. One example is the Manorhamilton engineering team’s approach to collecting and viewing production data. On each of two production lines, the team has developed a system that collects production data and feeds it to some sophisticated Excel spreadsheets. The data flows from the Saia programmable logic controller (PLC) to a Merz OPC server, and then to Microsoft Excel, which compiles the data and charts hourly production totals, downtime, and product quality.

很有用,该系统已经存在很长时间的问题。团队成员Paraic McDonagh说:“在过去的几年中,我们一直在开发数据监测系统。”“它运行良好,但是有一个缺点 - Excel插件中有错误,迫使我们经常重新启动PC。”

After much effort to work with or work around the faulty plug-in, the team finally turned to the web for a solution. When they found the OPC DataHub, they figured it might be possible to just drop it into their system and configure the reliable link to Excel that they needed. They soon realized that the OPC DataHub could not only solve their problem as hoped, but was able to enhance their system in other ways as well.

“Setting this up was as simple as attaching the OPC DataHub to the Merz OPC server and dragging the data points into Excel,” said McDonagh. “And by replacing the troublesome Excel plug-in with the OPC DataHub we were able to simplify the SCADA system into a single workbook. What's more, since the OPC DataHub can be run as a service, our operator now only needs to open a workbook to have the entire system up and running.”

“Here's how it works,” continued McDonagh. “The OPC DataHub feeds raw data into a column of cells in the ‘RAW_DATA’ sheet of the workbook. Then an Excel macro triggers every hour, causing the cell values to shift one column to the right. After 24 hours, the data begins to roll over on an hourly basis. Since the PLC counters do not reset, a separate ‘CALC_DATA’ sheet calculates the difference between each hour column and thus determines the actual count value to display. All other worksheets are a manipulation of this data for display purposes—graphs, tables etc.

“We are very happy with the software,” said McDonagh. “It’s stable. A big plus for us is a high degree of confidence that prompt technical support is available from Cogent when we need it. That was not the case with our buggy Excel plug-in. Now the system is up and running with the OPC DataHub, and we haven't had to restart the PCs at all.”

For more information on OPC solutions from Cogent Real-Time Systems, visitwww.opcdatahub.com.

More in Home