摘要
化工热力学基础数据计算中常常需要解多个参数的高次方程,这往往需要采用试差或迭代的方法实现,在教学活动中,手工计算工作量大,效果不佳。利用办公软件Excel计算可以解决这个问题。本文提出在Excel中实现了迭代的方法用于SRK方程摩尔体积及压缩因子的计算,与"单变量求解"法比较,方法更加直观、便于理解,对化工热力学的课堂教学起到了很好的作用。
In the calculation of basic data of chemical engineering thermodynamics,it is often necessary to solve the high-order equation with Multi-parameters,which often needs to be realized by trial and error or iteration method.In the teaching,manual calculation is complicated,workload is large,and the effect is not good.This problem can be solved by using Excel office-software.In this paper,the iterative method in excel is proposed to calculate the molar volume and compression factor of SRK equation.Compared with the"single variable solution"method,the method is more intuitive and easy to understand,which plays a good role in the classroom teaching of chemical thermodynamics.
作者
刘惠青
Liu Huiqing(Shanxi TV University,Taiyuan,Shanxi,030027)
出处
《山西广播电视大学学报》
2019年第3期91-94,共4页
Journal of Shanxi Radio & TV University
关键词
化工热力学
基础数据
迭代法
EXCEL
Chemical Engineering Thermodynamics
basic data
iteration method
Excel
作者简介
刘惠青(1965—),女,山西临汾人,山西广播电视大学,副教授。
