摘要
应用MicrosoftExcel软件及其规划求解工具,通过输入公式、调用函数编写计算程序,建立水泥生产四组原料配料计算Excel模板。计算结果表明:Excel配料计算模板可以快速、准确得到原料配合比的最优解,有助于实现新型干法水泥厂生料质量及时、有效地管理和控制。
The computing program was prepared by inputting formulas and calling functions using Microsoft Office Excel.The proportioning calculation model of four-component raw materials was built for cement producting.The experimental re-sults showed that Excel estimate model had a higher calculating rate and accuracy.Accomplish the more effective control of product quality.
出处
《长春理工大学学报(自然科学版)》
2009年第4期695-697,676,共4页
Journal of Changchun University of Science and Technology(Natural Science Edition)
关键词
EXCEL
规划求解
配料计算
模板设计
Excel
computing program
protortioning calculation
model design