Application of Excel in Rounding off of Numerical Values for Metallic Materials Tensile Testing at Ambient Temperature
摘 要
针对金属材料室温拉伸试验数值修约的问题, 依据GB/T 8170-2008数据修约规则介绍了两种利用Excel软件中的自定义函数功能对室温拉伸试验数值进行数值修约的方法。即在Excel软件中先通过Visual Basic编辑器创建1间隔修约自定义函数实现1间隔修约, 再根据数据修约规则中0.5间隔修约方法运用1间隔修约自定义函数实现0.05,0.5,5和10间隔修约; 或利用Excel中 Visual Basic编辑器直接创建0.05,0.5,1,5和10间隔修约自定义函数, 来实现试验数值按规定间隔的修约。结果表明: 这两种方法都很简便易行, 且都可实现快速对金属材料室温拉伸试验数值进行0.05,0.5,1,5和10间隔修约; 同时,这两种方法也可用于其他检测数值的修约。
Abstract
Two rounding off methods of numerical values for metallic materials tensile testing at ambient temperature using Excel user defined functions were introduced according to the rounding off rules of GB/T 8170-2008. That is first creating 1 interval rounding off user defined function through the Visual Basic editor in Excel to achieve 1 interval rounding off, and then according to 0.5 interval rounding off rules to achieve 0.05, 0.5, 5 and 10 intervals rounding off using the having created 1 interval rounding off user defined function. Or creating 0.05, 0.5, 1, 5 and 10 intervals rounding off user defined functions directly through the Visual Basic editor in Excel to achieve different intervals rounding off. The results show that both these two methods can round off of the tensile testing numerical values at ambient temperature with 0.05, 0.5, 1, 5 and 10 intervals rapidly and easily, and they can be used for rounding off of the numerical values for other testing.
中图分类号 TG113.25
所属栏目 实践经验
基金项目
收稿日期 2010/5/6
修改稿日期
网络出版日期
作者单位点击查看
备注李君荣(1975-),男, 助理工程师。
引用该论文: LI Jun-rong. Application of Excel in Rounding off of Numerical Values for Metallic Materials Tensile Testing at Ambient Temperature[J]. Physical Testing and Chemical Analysis part A:Physical Testing, 2010, 46(12): 810~811
李君荣. Excel在金属材料室温拉伸试验数值修约中的应用[J]. 理化检验-物理分册, 2010, 46(12): 810~811
被引情况:
【1】岑风,陈益华,张珂, "金属材料室温拉伸试验新旧国家标准的对比分析",理化检验-物理分册 48, 804-807(2012)
【2】李军伟,陈旭,张国民, "Excel在钢的伸长率换算中的应用",理化检验-物理分册 48, 163-164(2012)
共有人对该论文发表了看法,其中:
人认为该论文很差
人认为该论文较差
人认为该论文一般
人认为该论文较好
人认为该论文很好
相关信息
标题 | 相关频次 | |
解读GB/T 232-2010《金属材料弯曲试验方法》 | 2 | |
液压万能试验机油管接头漏油改造实践 | 2 | |
金属材料抗拉强度数值修约要求和适用范围 | 1 |