基于Excel的精馏塔理论塔板数的图解法  

Graphic solution to rectification column theoretical plate numbers by using Excel

作　　者：许可[1] 刘军坛[1] 彭伟功[1] 郑宾国[1] 崔节虎[1] 

机构地区：[1]郑州航空工业管理学院,河南郑州450015

出　　处：《化学工程师》2010年第6期16-19,共4页Chemical Engineer

基　　金：郑州航空工业管理学院2009年教育科学研究立项课题(zhjy09-50)

摘　　要：本文介绍了用Excel图解法求精馏塔理论板数的方法,采用Excel电子表格作为输入输出界面,用VBA程序进行理论塔板数的计算,计算结果以表格和图形的方式表示。该方法可以快速计算出理论塔板数、加料板位置及每一块理论塔板上的气液组成。通过实例证明该方法较为准确并且简单实用。This work introduced an Excel-based graphic solution to rectification column theoretical plate numbers. The Excel worksheet was used as the input and output interface ,the computation was accomplished by using VBA program. The results were expressed as table and graph. This method could quickly compute the theoretical number of tower plates,the position of charging plate and the vapour-liquid composition of every theoretical tower plate. The application examples verified its accuracy and practical value.

关 键 词：精馏塔 理论板数 Excel VBA程序 

分 类 号：TP311[自动化与计算机技术—计算机软件与理论]