Excel在玻纤配合料计算中的应用

Use of Excel in Calculation of Fiber Glass Batch

介绍了在玻璃纤维生产中,利用Excel中的规划求解工具进行玻纤配合料的计算步骤,以实例详细阐述了玻纤配合料的计算过程,说明如何保存和使用一个非常简单实用的Excel计算模型,从而提高生产过程中工程技术人员的工作效率和计算精度。经过验证,计算结果准确无误。

Steps of calculating fiber glass batch by programming solver in Excel are introduced. The calculation process is showed by an example,upon which a method is proposed for saving and using a simple and useful model to help technicians to improve working efficiency and calculating precision. The result of calculation is proved correct by validation.