Excel规划求解在陶瓷配方设计中的应用

Application of Programming Solution in Formulation Designing of Ceramics

配方设计是陶瓷企业一项重要的综合性技术工作,关乎生产的稳定和陶瓷产品性能的优劣。本文将Excel办公软件中的规划求解功能引入陶瓷配方设计中,通过原料种类和成分输入、运算关系确定、变量约束条件设置和目标设置等步骤,可规划优选出符合约束条件和目标的原料配比,免去人工配比试错的工作,具有重要的推广价值。

Formulation designing is an important and technical work for ceramics company, which concerns the stability of production and the quality of products. This paper introduced the programming solution into the designing of ceramic formulations. By input of raw materials and components, determination of operation relationships, setting of variable constraints and objective, formulation which meets the requirements could be obtained.