VBA在电学计量中的实践方法研究  

Study on the Practical Method of VBA in Electrical Metrology

作　　者：刘润 LIU Run

机构地区：[1]泸州市市场检验检测中心,四川泸州646000

出　　处：《计量与测试技术》2020年第3期56-58,63,共4页Metrology & Measurement Technique

摘　　要：本文提出了在电学计量中技术指标核算和数据处理的难点,分析了Excel VBA在数据自动化处理方面的优势。提出了通过将复杂参数存入数组实现快速运算的方法,并通过数字多用表校准举例验证该方法的可行性。文中还对VBA在计量检定结果处理中的应用做了详细阐述,最后对结果进行了分析。This paper puts forward the difficulties of technical index accounting and data processing in electrical measurement,and analyzes the advantages of Excel VBA in data automation processing.This paper presents a method of fast computation by storing complex parameters into an array,and verifies the feasibility of this method by calibrating a digital multimeter.The application of VBA in metrological verification is also described in detail.Finally,the results are analyzed.

关 键 词：VBA 数字多用表 不确定度 修约 耐电压测试仪 

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