基于EXCEL规划求解器的轧制规程优化设计

特殊钢 ›› 2008, Vol. 29 ›› Issue (3): 44-46.

基于EXCEL规划求解器的轧制规程优化设计

王敬忠¹, 段亚东², 杨西荣¹, 赵西成¹

1西安建筑科技大学冶金工程学院，西安710055 ；
2武汉钢铁(集团)有限责任公司硅钢厂，武汉430080

收稿日期:2007-11-26 出版日期:2008-06-01 发布日期:2022-12-22
作者简介:王教忠(1974-),男，硕士，讲师,2004年西安建筑科技大学毕业,金属材料属性加工的研究。
基金资助:
西安建筑科技大学学科建设项目资助(YJ1046)

Optimizing Design for Rolling Schedule Based on EXCEL Calculator

Wang Jingzhong¹, Duan Yadong², Yang Xirong¹, Zhao Xicheng¹

1 School o£ Metallurgical Engineering, Xi' an University of Architecture and Technology, Xi' an 710055;
2 Silicon Steel Mill, Wuhan Iron and Steel (Group) Co Ltd, Wuhan 430080

Received:2007-11-26 Published:2008-06-01 Online:2022-12-22

摘要/Abstract

摘要： 介绍了如何利用EXCEL规划求解器在多约束和多目标函数条件下对轧制规程进行优化,对优化设计的流程进行了图解分析;研究了优化计算中涉及的主要数学模型,通过实例说明了该优化规程的良好效果。计算过程表明,利用EXCEL规划求解器可以快速进行计算,使轧制规程得到优化,起到节能降耗、充分发挥轧机能力的作用。

关键词: 压下规程, EXCEL规划求解器, 优化设计

Abstract: The optimization of rolling schedule using EXCEL calculator in conditions of multi-goals and multiple restrictions has been presented in this paper. The optimizing design program was analyzed by diagrams, the main mathematical models for optimizing calculating were studied and the excellent effect of the optimizing schedule was illustrated by production example. Calculation process indicated that the calculation speed was fast by using EXCEL calculator to optimize rolling schedule, decrease energy consumption and bring the ability of mill into full play.

Key words: Rolling Schedule, EXCEL Calculator, Optimizing Design

王敬忠, 段亚东, 杨西荣, 赵西成. 基于EXCEL规划求解器的轧制规程优化设计[J]. 特殊钢, 2008, 29(3): 44-46.

Wang Jingzhong, Duan Yadong, Yang Xirong, Zhao Xicheng. Optimizing Design for Rolling Schedule Based on EXCEL Calculator[J]. Special Steel, 2008, 29(3): 44-46.