基于VBS脚本的WinCC与Excel工业数据处理在流速仪检定系统中的应用  

The Application of Industrial Data Processing of WinCC and Excel in Current Meter Verification System Based on VBS Script

作　　者：胡兵[1,2] 南新元 HU Bing;NAN Xin-yuan(Department of electrical and information engineering, Xinjiang institute of electrical engineering, Urumqi 830011 China;College of electrical engineering, Xinjiang University, Urumqi 830047 China)

机构地区：[1]新疆工程学院电气与信息工程系,新疆乌鲁木齐830011 [2]新疆大学电气工程学院,新疆乌鲁木齐830047

出　　处：《自动化技术与应用》2018年第4期146-150,共5页Techniques of Automation and Applications

基　　金：2017年度新疆维吾尔自治区高校科研计划项目青年项目(编号XJEDU2017S059);2016年度新疆工程学院科研基金项目(编号2016xgy141812)

摘　　要：流速仪检定需要拟合转子转速与水流速度之间的函数关系,常用的数据处理软件功能强大,但不适合工业应用。为此,提出基于VBS脚本的WinCC与Excel工业数据处理,采用VBS脚本程序编程将WinCC监控界面中的流速仪转子转速信号和水流速度信号实时数据写入到Excel中,运用Excel表格与公式编辑进行实时数据处理,重点介绍了WinCC与Excel实时数据传输与Excel实时数据处理的实现方法。运行结果表明,系统稳定可靠,操作简单,满足流速仪检定性能要求。系统的成功应用,满足企业对检定数据处理的要求,具有成本低、操作简单的优点,为类似工程应用提供参考。The function relation between the rotor speed and the flow velocity should be fitted for the requirement of current meter calibration, although the common data processing software is powerful but it is not suitable for industrial application. So the data processing industry by WinCC and Excel which is put forward based on VBS script, and the real-time data of current meter rotor speed signal and flow velocity signal is written which appears on WinCC monitoring interface to Excel by the VBS script programming, and Excel spreadsheet and formula editing are used for real-time data processing, the method of real-time data transmission and Excel real-time data processing of WinCC and Excel are mainly introduced. The results show that the system is stable and reliable, and the operation is simple. The successful application of the system meets the requirement of enterprises to deal with the verification data, has the advantages of low cost and simple operation, and provides reference for similar engineering applications.

关 键 词：VBS脚本 流速仪检定 最小二乘法 WINCC EXCEL 

分 类 号：TP273[自动化与计算机技术—检测技术与自动化装置] TH764[自动化与计算机技术—控制科学与工程]