摘要
随着电子天平新版检定规程的发布实施,很多电子天平将以校准证书的形式出现。本文通过Excel中函数和VBA的功能,通过按照JJF 1847—2020《电子天平校准规范》附录A中的电子天平测量结果的不确定度评定公式进行计算,采用混合编程解决了电子天平校准的原始记录和证书生成问题。
With the release and implementation of the new calibration regulations for electronic balances,many electronic balances will appear in the form of calibration certificates.This article uses functions in Excel and VBA functions,and calculates the uncertainty evaluation formula for electronic balance measurement results in Appendix A of JJF 1847—2020 Calibration Specification for Electronic Balances.By using hybrid programming,the problem of original record and certificate generation for electronic balance calibration is solved.
作者
安民军
AN Minjun(Gansu Institute of Metrology,Lanzhou 730050,China)
基金
甘肃省市场监督管理局科技计划资助项目:电子天平检定管理系统研究与开发(SSCJG-JL-B202202)。
关键词
电子天平
校准规范
EXCEL
electronic balance
calibration specifications
Excel