用Excel图解法求精馏塔理论塔板数  

Graphic solution to rectification column theoretical plate numbers by using excel

作　　者：时景荣[1] 罗传义[1] 

机构地区：[1]吉林化工学院,吉林吉林132022

出　　处：《计算机与应用化学》2005年第7期561-564,共4页Computers and Applied Chemistry

摘　　要：介绍了用Excel图解法求精馏塔理论塔板数,并给出了VBA程序。该方法简便实用。给出的用户界面即为程序的输入、输出界面,是动态的和智能化的,用户只需输入相关数据,立即显示全部计算数据和图形结果。经过实例验证,准确无误,具有较强的实用性。This paper introduce an Excel-based graphic solution to the theoretical plate numbers of a rectification column and a VBA program. This method is simple, convenient and pragmatic. The user interface is just an interface for input and output, which is dynamic and intellectual. After entering input correlative data, the display would be given for all data and graphics. A living examples has verified its accuracy and higher practical value.

关 键 词：VBA程序 电子表格 精馏塔 理论塔板数 二次开发 

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