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

Optimizing Design for Rolling Schedule Based on EXCEL Calculator

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

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.