VBA环境下热连轧带钢轧制力偏差统计分析实践

Analytical Practices on Statistics of Deviations for Rolling Force of Hot Continuous Rolled Strip Steel with Visual Basic forApplications(VBA)

文章展示了一项通过VBA语言环境计算并统计CSP热连轧机组各机架预测轧制力与实际轧制力偏差的设计。在VBA语言环境下,计算某范围的各机架预测轧制力与实际轧制力偏差,并根据各项轧制参数分类统计,大大缩短了分析时间及人工计算误差,同时直观体现出各轧制参数、规格对预测轧制力精准度的影响,结合实际案例进行分析,说明各轧制参数对预测轧制力精准度的影响,对调整轧机二级相应参数具有较大的参考意义。

In this paper,it is introduced a design of calculating and recording the deviations of predicted and actual rolling forces for all stands of CSP hot continuous rolling mill by the VBA language environment.The deviations of predicted and actual rolling forces for all stands in a certain range are calculated and with classified statistic based on various rolling parameters in the VBA language environment so that the analysis time is greatly shortened and errors of manual computation are reduced as well as the effects of various rolling parameters and specifications on accuracy of predicted rolling forces could be reflected intuitively.Moreover,the effects of various rolling parameters on accuracy of predicted rolling forces are illustrated through analysis combining with the practical examples,which is with great reference significances for adjusting the corresponding secondary parameters for rolling mill.