用迭代循环和条件函数求解精馏塔理论塔板数  

Using "Iterative Loop and If Function" to Calculate Rectification Column Theoretical Plate Numbers

作　　者：赵蕾[1] 周爱东[1] 王庆[1] 

机构地区：[1]南京大学化学化工学院,江苏南京210093

出　　处：《化工高等教育》2009年第6期77-81,共5页Higher Education in Chemical Engineering

摘　　要：我们以乙醇-正丙醇体系为例,建立了一套基于Excel的计算方法。运用Excel的迭代循环求解溶液的泡点温度、运用条件函数判断计算终点,从而快速准确地计算出精馏塔理论塔板数。In the system of ethanol-propanol, a set of calculation methods based on Excel is erected. In the set, the ＂iterative loop＂ can be used to calculate the bubble point temperature of solution, and the ＂if function＂ used to determine the end-point of result. It can get the numbers of theoretical plate of rectification column quickly and exactly.

关 键 词：EXCEL 迭代循环 条件函数 精馏 理论塔板数 

分 类 号：TQ053.5[化学工程]