Research on Data Processing Method Based on Automatic Measurement System of Mass in Small Nominal Value
-
摘要: 为提升检测效率,实验室逐步采用质量自动测量系统代替人工测量。目前质量自动测量系统直接生成的数据侧重对测量结果的呈现,但缺少ISO 17025中对原始记录及证书报告编制工作要求的关键信息要素,同时开展微小质量测量时容易因砝码掉落造成测量中断生成非完整数据,测量结束后往往需要检测人员对数据进行拼接重组、人为汇总计算、手动录入环境条件及委托单信息等,因此在实际检测工作中,自动测量系统的数据分析及处理过程仍需耗费大量人力。结合微小质量测量工作特点,基于质量自动测量系统提出了测量数据自动处理的改进方法,增加检测数据自动切分重组、超差判定、非完整数据处理等功能,实现数据自动分析、原始记录及证书报告的自动生成,减少人为因素干扰,进一步提升质量检测效率与数据自动化处理分析能力。Abstract: To improve measurement efficiency, calibration laboratories are gradually employing automatic measurement systems instead of manual measurements. At present, the data directly generated by the automatic measurement system focuses on the presentation of the measurement results but lacks the key information elements required by ISO-17025 for the original records and certificate reports. In the meantime, when carrying out mass measurements in small nominal values, it is easy to generate incomplete data due to measurement interruptions caused by falling weights. After the measurement, it is often necessary for inspectors to process data manually. Therefore, in the actual inspection work, the data analysis and processing of the automatic measurement system still require a lot of manpower. In this paper, combined with the features of mass measurements in small nominal value, a data analysis and processing method based on the automatic measurement system was proposed. Functions such as automatic segmentation and reorganization of data, identification of unqualified results, and processing of incomplete data were added. reduces the interference of human factors. The method realized automatic analysis of data, automatic generation of original records and certificate reports, reduced human factor interference, and further enhanced the efficiency of quality inspection and automatic data processing and analysis.
-
表 1 由质量自动测量系统直接生成的测量记录保存信息
Table 1. Measurement record directly generated by the automatic mass measurement system
日期 测量时间 测量序列 测量工位 示值 差值 差值均值 修正值 标准差 2021/10/8 13:22:55 010101A c4 499.9928 2021/10/8 13:24:03 010101B a1 499.9975 2021/10/8 13:25:11 010101A c4 499.9921 0.00507 2021/10/8 13:26:19 010102B a1 499.9970 2021/10/8 13:27:26 010102A c4 499.9921 2021/10/8 13:28:34 010102B a1 499.9967 0.00473 0.00490 0.00260 0.00024 2021/10/8 13:29:43 010201A c5 200.0011 2021/10/8 13:30:51 010201B a2 200.0120 2021/10/8 13:31:59 010201A c5 200.0009 0.01100 2021/10/8 13:33:07 010202B a2 200.0119 2021/10/8 13:34:16 010202A c5 200.0010 2021/10/8 13:35:24 010202B a2 200.0119 0.01090 0.01095 0.01395 0.00007 -
[1] 杨囡, 王健, 任孝平. 自动无扰动系统的微克质量标准研究[J]. 中国计量学院学报, 2015, 26(2): 172-187. [2] Kim M S, Pratt J R. SI traceability: Current status and future trends for forces below 10 microNewtons[J]. Measurement, 2010, 43(2): 169-182. doi: 10.1016/j.measurement.2009.09.005 [3] Madec T, Mann G, Meury P A, et al. Micro-mass standards to calibrate the sensitivity of mass comparators[J]. Metrologia, 2007, 44(5): 266-274. doi: 10.1088/0026-1394/44/5/002 [4] Ren X, Cai C, Yi L, et al. Mass Metrology Based on Robotic Mass Measurement System[J]. Lecture Notes in Electrical Engineering, 2013, 254: 477-484. [5] T Fehling, T Frohlich, D Heydenbluth. Design and Performance of the new Sartorius Robot-System[C]. IMEKO. 20th IMEKO TC3 International Conference on Measurement of Force, Mass and Torque 2007, 2009: 95-102. [6] Gordon P, Stuart D. Design and Assessment of an Automatic 50 kg Weight Exchanger[C]. Measurement Science Conference 1970-2005 Proceedings, 2005: 268-277. [7] 王肖磊, 王健, 钟瑞麟, 等. 精密空气密度测量装置的研制[J]. 计量技术, 2010(10): 18-20. [8] Arthur R. A New Mass Comparator Generation for the Automatic Calibration of Weight Sets[C]. International Measurement Confederation. Proceedings of the 17th international conference on force, mass, torque and pressure measurements. Istanbul, Turkey, 2001: 310-319. [9] BIPM. International Recommendation Weights of Classes E1, E2, F1, F2, M1, M1-2, M2, M2-3 and M3, Part 1: Metrological and technical requirements: OIML R 111-1 [S]. Switzerland, 2004. [10] Lee W G, Choi N Y. Calibration Designs Of Mass Standards For 2 Comparators In A Decade Series[C]. XVI Imeko World Congress Imeko 2000, Proceedings Volume III, 2000: 157-160. [11] 国家质量监督检验检疫总局. 砝码检定规程: JJG 99-2006 [S]. 北京: 中国计量出版社, 2006. [12] Schwartz R. Guide to mass determination with high accuracy[J]. Physikalisch-Technisch Bundesanstalt, Braunschweig, 1995, 4: 40. [13] Ulrich J G. A Special Weight Set for the Determination of OIML Weight Sets and Its Use[J]. Bulletin OIML, 1989, 12: 14. [14] Fröhlich T, Fehling T, Heydenbluth D. Mass Dissemination using a Robot System[J]. Technisches Messen:Sensoren, Gerate, Systeme, 2009, 76(7-8): 382-387. [15] Zoltan Z. New Primary Balance Of Bev For High-Precision Mass Determination And Realization of The Mass Scale In The Range From 10 g up to 1 kg[C]. International Measurement Federation. 20th IMEKO world congress 2012: 20th IMEKO (International Measurement Federation) world congress, 2012: 9-14. [16] Frohlich T, Fehling T, Gatzemeier B, et al. Mass dissemination using a fully automated mass comparator robot system[C]. IMEKO. 20th IMEKO TC3 International Conference on Measurement of Force, Mass and Torque, 2007. [17] 彭程, 王健. 用于量值传递的高精度单晶硅球质量测量研究[J]. 计量学报, 2021, 42(3): 265-270. doi: 10.3969/j.issn.1000-1158.2021.03.01 [18] 罗志勇, 刘子勇, 刘吉萍, 等. 便携式空气密度精密测量仪的研制[J]. 计量学报, 2001, 22(1): 52-56. doi: 10.3321/j.issn:1000-1158.2001.01.010 [19] 王肖磊, 王健, 钟瑞麟, 等. 砝码质量测量中的空气密度测量装置的研究[J]. 计量学报, 2011, 32(1): 41-43. [20] 王健, 钟瑞麟, 蔡常青, 等. 一种新型衡器自动测量系统[J]. 计量学报, 2012, 33(5): 421-422.