| Excel在钢的伸长率换算中的应用 |
| |
| 引用本文： | 李军伟,陈旭,张国民. Excel在钢的伸长率换算中的应用[J]. 理化检验(物理分册), 2012, 0(3): 163-164,167 |
| |
| 作者姓名： | 李军伟 陈旭 张国民 |
| |
| 作者单位： | 鞍钢股份鲅鱼圈分公司化检验中心 |
| |
| 摘 要： | 依据GB/T 17600.1-1998进行钢的伸长率换算,需要不断查公式、查表,应用起来比较繁琐。介绍了一种利用Excel的计算功能,结合Visual Basic编程,实现钢的伸长率快速换算的方法。即在Excel中先通过Visual Basic编辑器创建自定义函数进行编程,在Excel文档中加以应用,不用再反复查公式、查表并计算。
|
| 关 键 词： | 伸长率 快速换算 软件 编程 |
Application of Excel in Elongation Value Conversion of Steel |
| |
| Affiliation: | LI Jun-wei,CHEN Xu,ZHAN Guo-min(Bayuquan Subsidiary Test Center,Anshan Iron and Steel Co.,Ltd.,Yingkou 115007,China) |
| |
| Abstract: | According to GB/T 17600.1-1998,it is a cumbersome process to convert the elongation value of steel by continuous checking the formula and the date table.A method of elongation value conversion of steel was introduced through calculation of Excel and the program compiling of visual basic.The customed function was compiled through visual basic,then cited by Excel to convert the elongation value of steel,it isn’t necessary to calculate by checking the formula and the date table. |
| |
| Keywords: | elongation value fast conversion software program compiling |
| 本文献已被 CNKI 维普 等数据库收录！ |
|
