基于正则表达式的砝码检定证书自动生成方法  

Automatic Generation Method of Weight Verification Certificate Based on Regular Expression

作　　者：蔡晓思 刘中文 Cai Xiaosi;Liu Zhongwen

机构地区：[1]广东省计量科学研究院力学重点实验室,广东广州510405

出　　处：《计量与测试技术》2018年第6期108-109,112,共3页Metrology & Measurement Technique

摘　　要：针对砝码质量值检定过程中数据多且复杂的问题,利用VBA平台,提出一种基于正则表达式的砝码检定证书自动生成方法,能实时准确筛选出原始记录页中砝码质量值数据并自动生成砝码证书内页,避免重复录入,极大提高证书编辑效率与准确度,减少重复工作。In view of the mass and complex data in verification process of weight of the counterpoise,using VBA platform,an automatic generation method of counterpoise verification certificate based on regular expression is proposed. It can accurately screen out the weight value data from the original recording pages in real time and automatically generates internal pages of the counterpoise certificate,avoiding duplicate input,greatly improving the efficiency and accuracy of certificate editing,and reducing duplicate work.

关 键 词：VBA 砝码 证书自动生成 正则表达式 

分 类 号：TB9[一般工业技术—计量学]