运用Excel对精馏塔进行逐板计算和简捷计算  

Plate-by-plate and Simplified Calculations for Distillation Column by Application of Excel Method

作　　者：许军[1] 齐鸣斋[1] 刘玉兰[1] 

机构地区：[1]华东理工大学化学工程联合国家重点实验室,上海200237

出　　处：《化工高等教育》2013年第1期66-70,共5页Higher Education in Chemical Engineering

摘　　要：本文递推了精馏塔逐板计算的详细过程。在此基础上利用Excel函数及数学变换推导了精馏塔理论塔板数的气-液相组成、理论塔板数。该方法简单易学、方便快捷。本文将此捷算法与逐板计算做了比较,结果较吻合。A detail deduction of the formulae for the plate-by-plate calculation in the distillation column is discussed. On the basis of deduction, excel function and some mathematical processing are utilized to cal- culate the composing of the vapor-liquid phase of theoretical plate numbers. This novel method supported by reliable results is simple to learn and utilize, and convenient for application. By comparison of two cal- culation methods, their calculated results match well with each other.

关 键 词：逐板计算 Excel方法 理论塔板数 

分 类 号：TQ015-4[化学工程] G642[文化科学—高等教育学]