EXCEL在非理想系泡露点计算中的应用

APPLICATION OF EXCEL IN CALCULATIONS OF NON-IDEAL SYSTEM BUBBLE-AND-DEW POINT MIXTURE

因为泡、露点方程与温度呈高度非线性关系,与压力也呈一定程度的非线性关系,所以泡露点计算需迭代试差完成。对于非理想系,需计算函数关系非常复杂的活度系数式和逸度系数式,因此迭代计算更加繁复。利用Excel提供的数组公式、相关的函数功能及其规划求解,就可轻松完成非理想系的泡露点计算。同时,Excel的计算过程简单直观,这一点于教与学两方面都十分有利。

Since the bubble-and-dew point equations are generally highly nonlinear with temperature and are moderately nonlinear with pressure as well,therefore,iterative procedures are required to solve bubble-and-dew point calculations.For non-ideal system,the activity coefficient equations and fugacity coefficient equations are to be calculated,all are of the functions with very complicated relations,so that the iteration calculations will be much complex.However,such works of non-ideal system bubble-and-dew point calculations can be easily completed with Excel by its array formula,related functions and programming.Meanwhile,the procedure of calculating with Excel is simple and direct,which benefits teaching and learning in both.