Excel在金属材料室温拉伸试验数值修约中的应用

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中VisualBasic编辑器直接创建0.05,0.5,1,5和10间隔修约自定义函数,来实现试验数值按规定间隔的修约。结果表明:这两种方法都很简便易行,且都可实现快速对金属材料室温拉伸试验数值进行0.05,0.5,1,5和10间隔修约;同时,这两种方法也可用于其他检测数值的修约。

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.