摘要
在对一个零件进行合格性判断时,需要对诸多实测数据进行归纳、统计和运算,这一过程通常是手工进行的。但当加工零件数量和实测数据较多时,手工进行则易产生较多错误,且效率较低。为此利用excel内置的VBA及宏功能,通过编制程序的方式,实现数据的快速运算与处理功能,从而达到对零件进行高效且准确的合格性判断。结合实例给出了这一控制过程。
When a part need to be judged, lot of data measurement need to be concluded, analysed and counted. Usually this process is done manually and inefficiency. This paper describes in detail how to use the excel built-in VBA and macro functions, the realization of the data fast calculation and processing functions, and gives the detailed process of combining examples.
出处
《装备制造技术》
2016年第7期245-248,共4页
Equipment Manufacturing Technology
关键词
尺寸控制
合格性判断
电子表格
VBA
size control
qualified judgement
electronic spreadsheet
VBA