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.