基于VBA的Excel测量数据监控平台搭建  

Setting up the Measurement Data Monitoring Platform with Excel Based on VBA

作　　者：张彬 Zhang Bin(Eaw-volkswagen Automotive Co., Ltd., Foshan Branch Foshan 52823)

机构地区：[1]一汽-大众汽车有限公司佛山分公司,佛山528237

出　　处：《办公自动化》2017年第17期45-47,共3页Office Informatization

摘　　要：基于VBA开发的三坐标测量数据监控系统,具备实时,高效的特征。实现了测量异常点检测及尺寸质量问题预警两大功能。并且该平台易于扩展,增加对新车型新零件的监控成本低,也可以用于其它类型质量特征数据的自动监控。The monitoring system for CMM（Coordinate Measuring Machine）measurement data based on VBA possesses some benefits including reahime performance and high efficiency. And it has two functions. One is the detection of ab- normity points brought by measurement process, the other is size warning for quality problem. The platform is easy to ex- pand, the cost for monitoring new vehicles or new parts is low, and the platform can be used to monitoring other quality characteristics.

关 键 词：VBA EXEEL 测量数据 监控平台 自动化 

分 类 号：TP311.52[自动化与计算机技术—计算机软件与理论] TP317.3[自动化与计算机技术—计算机科学与技术]