摘要
基于VBA开发的三坐标测量数据监控系统,具备实时,高效的特征。实现了测量异常点检测及尺寸质量问题预警两大功能。并且该平台易于扩展,增加对新车型新零件的监控成本低,也可以用于其它类型质量特征数据的自动监控。
The monitoring system for CMM(Coordinate Measuring Machine)measurement data based on VBA possesses some benefits including realtime performance and high efficiency. And it has two functions. One is the detection of abnormity points brought by measurement process,the other is size warning for quality problem. The platform is easy to expand,the cost for monitoring new vehicles or new parts is low,and the platform can be used to monitoring other quality characteristics.
引文
[1]周卫.基于VBA的Excel测量程序开发技术[J].测绘通报.2005(6):37-40.
[2]郑发路,袁洪,李在峥,杨明君.基于VBA的千分尺证书记录系统[J].计测技术,2016,36(3):65-67.
[3]段长生.基于VBA开发的温度计量Excel数据处理软件[J].计测技术,2008,28(s1):68-70.
[4]Adrian Kingsley-Hughes,Kathie Kingsley-Hughes,Daniel Read,富宏毅,陈钢译.VBScipt程序员参考手册(第3版)[M].北京:清华大学出版社,2009.
[5]罗刚君.Excel VBA程序开发自学宝典(第2版)[M].北京:电子工业出版社,2013.