Excel在理想反应器计算中的应用

Application of Excel in the idea reactor′s calculation

以理想反应器的计算为例,实现了用Excel求解变温操作、N级反应下多釜串联的最优容积比。计算结果表明:利用Excel卓越的图表和函数计算功能,将其复杂的编程过程变成方便的菜单和工具栏操作,尤其是它的自动填充功能、单变量求解功能、规划求解功能以及if()函数功能。使繁杂的理想反应器的过程计算变得十分简单、便捷,并且非常容易掌握。

It shows to solve variable temperature operation,optimal multi-reactor series compared under multi-stage reaction by means of Excel,as an example of the idea reactor′s calculation. The result of calculation indicates that the complex calculation of idea reactor processes are changed to be very simple by use of the Excellent functions of calculation,tables and figures in Excel,which bandy operating menu and tool bar,especially auto-filling,goal-seek,solver and if function replace the troublesome programming. And this way is simple to learn and master,and convenient for application than others.