Excel和Aspen Plus软件在《化工热力学》汽液平衡数据计算中的应用  

Application of Excel&Aspen Plus Software in the Calculation of Vapor-Liquid Equilibrium Data for Chemical Engineering Thermodynamics

作　　者：殷留义 李咏波 李林 刘金凤 马莹 勾世谈 王筠 薛莹莹 徐永燕 Yin Liuyi;Li Yongbo;Li Lin;Liu Jinfeng;Ma Ying;Gou Shitan;Wang Yun;Xue Yingying;Xu Yongyan(Zhoukou Normal University,College of Chemistry and Chemical Engineering,Zhoukou 466001,China)

机构地区：[1]周口师范学院化学化工学院,河南周口466001

出　　处：《广东化工》2023年第17期168-170,共3页Guangdong Chemical Industry

基　　金：河南省高等学校重点科研项目计划(21B530011);河南省科技攻关(222102320253);周口师范学院教育教学改革研究项目(J2022031,J2022032,J2022030,J2021006);教育部产学合作协同育人项目(202102028049);河南省高等教育教学改革研究与实践项目(2021SJGLX521)。

摘　　要：本文利用Excel提供的单变量求解及相关函数功能,无需编程,就可使问题得到圆满解决。同时,通过Aspen Plus软件的物性分析功能也能快捷地对汽-液相平衡进行计算,并利用Aspen Plus软件绘图功能将Excel和Aspen Plus得到的汽液平衡数据以相图的形式直观表示出来。将Excel和Aspen Plus软件应用于汽-液相平衡数据计算,简单明了,且不易出错,将其作为有效的教学改革工具应用到化工热力学教学中,不仅可以实现理论与实际应用的结合,也可以提高学生的学习兴趣。In this paper,the above mentioned problems can be solved successfully by Excel using the single variable solution and related functions provided without programming.Additionally,the vapor-liquid equilibrium can also be calculated quickly by Aspen Plus software using the physical property analysis function.Furthermore,the vapor-liquid equilibrium data obtained by Excel and Aspen Plus can be visually expressed in the form of phase diagram by using the drawing function of Aspen Plus software.It is simple and not easy to make mistakes calculating vapor-liquid phase equilibrium data by Excel and Aspen Plus software.Therefore,Excel and Aspen Plus software as an effective teaching reform tool used in the teaching of chemical engineering thermodynamics can not only realize the combination of theory and practical application,but also improve students'learning interest.

关 键 词：EXCEL Aspen Plus 化工热力学 汽液平衡数据计算 相图 

分 类 号：G642[文化科学—高等教育学]