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

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

作　　者：刘政峰 丛培瑶 贾瑞杰 王爱君[1] Liu Zheng-feng;Cong Pei-yao;Jia Rui-jie;Wang Ai-jun(CSP Plant of Inner Mongolia Baotou Steel Union Co.,Ltd.,Baotou 014010,Inner Mongolia Autonomous Region,China)

机构地区：[1]内蒙古包钢钢联股份有限公司薄板坯连铸连轧厂,内蒙古包头014010

出　　处：《包钢科技》2023年第2期83-87,共5页Science & Technology of Baotou Steel

摘　　要：文章展示了一项通过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.

关 键 词：预测轧制力偏差 VBA 轧制力 统计 

分 类 号：TG335[金属学及工艺—金属压力加工]