《电子表格在(卷材背面漆)配方正交设计中的应用》

The Application of Excel to Orthogonal Design Table of Formulation for Coil Back Coating

利用计算机电子表格Excel突出的制表与计算功能,研制出一种新型的正交表数据处理器YDL。它能准确直接处理正交设计表中的复杂数据。当确定了影响因素并划分了水平,直接把各水平值输入附表中,则在正交表中能立即显示出某些重要的理论参数和原料成本,给设计者提供有价值的参考,为广大科技开发人员节省大量时间,并提供精确的理论数据。

A new orthogonal table data language (YDL) is developed by excel in computer, which has excellent function of tabulation and computation. It can treat complicated data in the orthogonal design table accurately and directly. If influence factors are determined and levels are divided, all level values can be input to attached table, then some important theoretical parameters and raw material cost will be indicated immediately in the orthogonal table. Many scientists can obtain valuable data in short time and acquire accurate theoretical data.