| EXCEL在非理想系泡露点计算中的应用 |
| |
| 引用本文： | 班玉凤,常圣泉,朱海峰,傅承碧.EXCEL在非理想系泡露点计算中的应用[J].计算机应用与软件,2011(10). |
| |
| 作者姓名： | 班玉凤 常圣泉 朱海峰 傅承碧 |
| |
| 作者单位： | 沈阳工业大学石油化工学院;辽宁庆阳特种化工有限公司科研中心; |
| |
| 摘 要： | 因为泡、露点方程与温度呈高度非线性关系,与压力也呈一定程度的非线性关系,所以泡露点计算需迭代试差完成。对于非理想系,需计算函数关系非常复杂的活度系数式和逸度系数式,因此迭代计算更加繁复。利用Excel提供的数组公式、相关的函数功能及其规划求解,就可轻松完成非理想系的泡露点计算。同时,Excel的计算过程简单直观,这一点于教与学两方面都十分有利。
|
| 关 键 词： | 泡露点计算 Excel 数组公式 规划求解 |
APPLICATION OF EXCEL IN CALCULATIONS OF NON-IDEAL SYSTEM BUBBLE-AND-DEW POINT MIXTURE |
| |
| Ban Yufeng Chang Shengquan Zhu Haifeng Fu Chengbi.APPLICATION OF EXCEL IN CALCULATIONS OF NON-IDEAL SYSTEM BUBBLE-AND-DEW POINT MIXTURE[J].Computer Applications and Software,2011(10). |
| |
| Authors: | Ban Yufeng Chang Shengquan Zhu Haifeng Fu Chengbi |
| |
| Affiliation: | Ban Yufeng1 Chang Shengquan2 Zhu Haifeng1 Fu Chengbi1 1(College of Petrochemical Engineering,Shenyang University of Technology,Liaoyang 111003,Liaoning,China) 2(Scientific Research Center,Qingyang Chemical Industry Corporation,Liaoyang 111002,China) |
| |
| Abstract: | 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 ... |
| |
| Keywords: | Bubble-and-dew point calculations Excel Array formula Programming |
| 本文献已被 CNKI 等数据库收录！ |
|
