平衡级分离计算的电子表格  

Spreadsheet for calculation of equilibrium-staged separation

作　　者：牛秀明 陈宏刚[2] 

机构地区：[1]山东医学高等专科学校济南校区,山东济南250002 [2]中国石油大学华东重质油国家重点实验室,山东东营257061

出　　处：《计算机与应用化学》2008年第5期558-560,共3页Computers and Applied Chemistry

基　　金：国家自然科学基金(20776159);山东省优秀中青年科学家科研奖励基金资助项目(2007BS08009)

摘　　要：以微软Excel电子表格软件为平台,开发一个用于平衡级分离过程计算的电子表格ESS,举例详细介绍它的强大功能和独特优点。ESS具有良好的人机界面,使用灵活、方便;仅利用公式和函数功能,避开复杂的VBA和宏,无需编程,改进和维护非常方便,符合工程计算的习惯和规范;使用ESS,可充分利用Excel先进丰富的数值计算功能,解决工程问题和用图形表示多因素和变量之间的复杂非线性相互关系都很方便。ESS的强大图形处理功能和稳定的数值计算特点,可广泛用于教学、科研和工程计算。The design and operation calculation of equilibrium-staged separation process are usually done either by graphic method or by expensive large-scale commercial software. Using Microsoft Excel as platform, the spreadsheet ESS for simple equilibrium-staged separation process is developed. The ESS is flexible, easy-to-use, friendly to user. It just utilizes the formula and functions of Excel avoiding the complex VBA and macro so user can easily maintain and upgrade it. In addition, Fully utilizing the advanced numerical algorithm, ESS is able to solve and represent the nonlinear relationship among various variables using chart and graphic. It then can be widely applied in teaching, scientific research and engineering computations.

关 键 词：电子表格 平衡级分离 EXCEL 

分 类 号：TQ015.9[化学工程]