利用电子表格自动处理数据高效检定常用玻璃量器
刘雪萍1，邓书武2，邓耀熙3
1. 广西卫生职业技术学院医学基础部，南宁 530023； 2. 广西医科大学第一附属医院药学部，南宁 530021； 3. 首都经济贸易大学管理工程学院，北京 100070
Efficiently verifying common glass gauge by using spreadsheet to automatically processing data
LIU Xueping, DENG Shuwu, DENG Yaoxi1 2 3
1. Department of Basic Medicine, Guangxi Health Science College, Nanning 530023, China; 2. Department of Pharmacy, the First Affiliated Hospital of Guangxi Medical University, Nanning 530021, China; 3. School of Engineering and Management, Capital University of Economics and Business, Beijing 100070, China
摘要：建立利用电子表格自动处理数据高效检定常用玻璃量器的方法。设计电子表格，利用表格处理数据，对常用玻璃量器检定数据自动检索、自动计算以及自动修约。 该方法与传统衡量法相比，实现了数据自动计算处理，而且自动修约符合规定，消除了人为计算失误，提高了计算准确率，检定时间比传统方法缩减了约 42%，统计学方法表明统计结果具有显著性差异（P＜0.01）。该方法不仅成本低，而且提高了检定效率，降低了计算的差错率。
Abstract：An efficient method was established for verifying common glass gauge by using spreadsheet to automatically processing data. A spreadsheet was designed to process data and automatically retrieve, calculate and round off the calibration data of commonly used glass measuring instruments. Compared with traditional measurement, the method achieved automatic data calculation and processing, and automatic rounding meets regulations, eliminated human calculation errors and improved calculating accuracy. Besides, the verification time of the method had been reduced by approximately 42%. Statistical methods showed that the statistical results was significant differences (P<0.01). The method not only has low cost, but also improves verification efficiency and reduces calculation error rate.
关键词：玻璃量器；检定；自动计算；WPSOffice办公软件；数据修约
Keywords：glass gauge; verify; automatically calculate; WPS Office software; rounding numbers
基金：广西高校中青年教师科研基础能力提升项目（2021KY1370），广西壮族自治区中医药管理局自筹经费科研课题（GXZYA20220222）
本文引用格式：
刘雪萍，邓书武，邓耀熙.利用电子表格自动处理数据高效检定常用玻璃量器[J].化学分析计量，2023，32(10)：98.
LIU Xueping，DENG Shuwu，DENG Yaoxi. Efficiently verifying common glass gauge by using spreadsheet to automatically processingdata[J]. Chemical Analysis and Meterage，2023，32(10)：98.
相似文章：
