Excel在平板平面度测量中的应用
The application of excel in flat plate flatness measurement
崔洪彬 1张振宇 1王越瑶 2程银宝2
作者信息
- 1. 杭州新吉格致测量技术有限公司,浙江 杭州 311100
- 2. 中国计量大学计量测试与仪器学院,浙江 杭州 310018
- 折叠
摘要
为了方便工程师计算平板的平面度,解决计算方法相对较繁琐、计算量大等问题,文章使用Excel软件的函数计算功能,结合平板的计量检定规程中推荐的方法,实现平板平面度的快速、准确计算,其优势在于可即时、自动判断是否需要通过旋转平面来满足最小条件原则,从而得到更精确的平面度计算值.
Abstract
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 ad-vantage is that it can instantly and automatically determine whether to rotate the plane to meet the mini-mum condition principle,Thus obtaining more accurate flatness calculation values.
关键词
平板/平面度/最小条件原则评定/对角线布点评定Key words
excel/flat/flatness/minimum condition principle evaluation/diagonal point layout eval-uation引用本文复制引用
出版年
2024
NETL
NSTL
万方数据