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

Automatic Generation Method of Weight Verification Certificate Based on Regular Expression

针对砝码质量值检定过程中数据多且复杂的问题,利用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.