Excel在平板平面度测量中的应用  

The application of excel in flat plate flatness measurement

作　　者：崔洪彬 张振宇 王越瑶 程银宝 CUI Hongbin;ZHANG Zhenyu;WANG Yueyao;CHENG Yinbao(Hangzhou Xinjigezhi Measurement Technology Co.,Ltd,Hangzhou 311100,China;College of Metrology&Measurement Engineering,China Jiliang University,Hangzhou 310018,China)

机构地区：[1]杭州新吉格致测量技术有限公司,浙江杭州311100 [2]中国计量大学计量测试与仪器学院,浙江杭州310018

出　　处：《工业计量》2024年第6期86-90,共5页Industrial Metrology

基　　金：国家市场监督管理总局科技计划项目(2021MK188)。

摘　　要：为了方便工程师计算平板的平面度,解决计算方法相对较繁琐、计算量大等问题,文章使用Excel软件的函数计算功能,结合平板的计量检定规程中推荐的方法,实现平板平面度的快速、准确计算,其优势在于可即时、自动判断是否需要通过旋转平面来满足最小条件原则,从而得到更精确的平面度计算值。In order to facilitate engineers in calculating the flatness of flat plates and solve problems such as relatively complex calculation methods and large computational workload,this article uses the function calculation function of Excel software,combined with the recommended methods in the measurement and verification regulations of flat plates,to achieve fast and accurate calculation of flat plate flatness.Its advantage is that it can instantly and automatically determine whether to rotate the plane to meet the minimum condition principle,Thus obtaining more accurate flatness calculation values.

关 键 词：平板 平面度 最小条件原则评定 对角线布点评定 

分 类 号：TG832[金属学及工艺—公差测量技术]