基于Excel的电子天平校准研究与应用

Research and Application of Electronic Balance Calibration Based on Excel

随着电子天平新版检定规程的发布实施,很多电子天平将以校准证书的形式出现。本文通过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.