EXCEL软件在闪蒸过程计算中的应用

Application of EXCEL in the Calculation in Flash Evaporation

闪蒸过程也称单级平衡分离过程,是计算多级平衡分离过程的基础。由于该过程计算需在泡露点计算的基础上再通过试差计算,由于进行闪蒸过程分析时手动计算工作量过大无法在课堂教学中进行。运用EXCEL软件的公式来完成闪蒸过程试差计算,模拟手算试差过程,结合教材上的编程框图可实现课堂演示闪蒸试差计算过程,又可结合计算结果对闪蒸过程影响因素进行分析。

The flash process,also called single-stage equilibrium separation process,is the foundation of the multi-stage equilibrium separation process.Because this process of calculation needs to be based on bubble point and dew point calculation,the manual calculation in flash evaporation analysis is too much to be carried out on class.In the paper,EXCEL software formula is used,simulating the manual difference testing process,combined with the programming block diagram in the textbook.The difference testing calculation of the flash process can be demonstrated to students on class,and the influencing factors of flash evaporation process are analyzed based on the calculation results.