Excel在复杂化工方程求解中的应用  

The Application of Excel in Solving Complicated Chemical Equations

作　　者：赵延龄[1] 

机构地区：[1]兰州交通大学化工学院,甘肃兰州730070

出　　处：《广州化工》2013年第8期60-61,共2页GuangZhou Chemical Industry

摘　　要：在化工过程研究及设计中,经常需要求解对象模型的方程以得到所需的数值,而化工方程表达式一般较复杂,数学求解计算量很大,精度较低。本文通过举例介绍了Excel软件的单变量求解、距阵求解、规划求解、积分式求解等功能在复杂化工方程中的应用,说明用Excel可以求解此类方程,并且具有节约方程求解时间、提高数值精度的特点。In the studying and designing of chemical engineering solving an equation in a mathematical model of con- trolled plant often needed to acquire the essential numerical value, but it＇s usually too complicated to employ the chemical engineering equation expression. On the other hand, it caused too much calculation as well as too low accuracy. The ap- plication of Excel was introduced in complicated chemical equations with its excellent solving functions of single argument, matrix, programming, integral equation, etc. , demonstrating that Excel can solve such equations, and that it can also save time in solving equation and improve the accuracy of the figures.

关 键 词：EXCEL 数学模型 解方程 化工 计算 

分 类 号：O-069[理学]