利用Excel和VBA开发板式塔设计软件  

Development of software for design of tray by Excel and VBA

作　　者：刘保柱[1] 

机构地区：[1]浙江工业大学化学工程与材料学院,浙江杭州310032

出　　处：《计算机与应用化学》2006年第10期1035-1037,共3页Computers and Applied Chemistry

摘　　要：大多数塔板设计软件都不允许用户修改其中的计算公式,而基于Excel和VBA开发的软件却可以做到这一点。软件以Excel工作表作为界面,利用Excel公式和函数进行简单的计算,利用VBA(Visual Basic for Applications)编制自定义函数实现复杂计算。软件采用Excel图表功能绘制塔板负荷性能图,并设置条件格式、数据有效性、工作表保护以提高软件易用性和安全性。软件计算结果准确,可供工程设计或者教学使用,其开发思路也可供开发类似软件时参考。For most software for structure design of tray, the expressions can＇t be modified by the user. The software developed based on Excel and VBA can do it easy. It completed simple computation using formula and function of Excel, VBA （Visual Basic for Applications） was used to program user-defined function for complex computation. Capacity graph of tray was drawn by Graph control of Excel. Setting of conditional Formatting, data validation and Worksheet Protection made the software safe and easy to use. The results of software is accurate and can be used for design and teaching. The idea can be consulted by others for development of similar software.

关 键 词：塔板 Excel VBA 负荷性能图 

分 类 号：TQ015.9[化学工程] TP311.1[自动化与计算机技术—计算机软件与理论]