CAJ | 학술논문

泡点与露点计算是化工热力学课程中气液平衡计算的重要内容,也是教学中的难点。目前,教科书中只讲了计算方法,缺少实际计算的展示。本文介绍了微软电子表格Excel在泡点与露点计算中的应用。将已知量、待求量初值与计算公式输入电子表格的各单元格中,求出各组分的气相逸度与液相逸度,根据气液平衡准则,采用Excel多变量规划求解的强大计算功能,即可计算出混合物的泡点压力、泡点温度、露点压力与露点温度。计算过程简单明了,无需编程,方便教学演示,是一种值得推广的教学与实用计算方法。
포점여로점계산시화공열역학과정중기액평형계산적중요내용,야시교학중적난점。목전,교과서중지강료계산방법,결소실제계산적전시。본문개소료미연전자표격Excel재포점여로점계산중적응용。장이지량、대구량초치여계산공식수입전자표격적각단원격중,구출각조분적기상일도여액상일도,근거기액평형준칙,채용Excel다변량규화구해적강대계산공능,즉가계산출혼합물적포점압력、포점온도、로점압력여로점온도。계산과정간단명료,무수편정,방편교학연시,시일충치득추엄적교학여실용계산방법。
Bubble point and dew point calculations are the most important and difficult contents in VLE calculation in Chemical Engineering Thermodynamics. In the present using textbooks, only the computa- tion method is introduced without a particular illustration on an example. Here we introduce a method by which Microsoft Excel is used for the calculations. The known values, initial values and calculation for- mulas are input into each grid of the spread sheet. The fugacities of both vapor and liquid phases for each component are calculated. Then the powerful function of multivariable goal shooting is performed, with which we can easily get the bubble point pressure, bubble point temperature, dew point pressure and dew point temperature. The calculations with Excel are simple and intuitive and feasible for illustration in the class. It is a method worthy of being recommended to solve problems in both oractiee and elass.