利用PRO/Ⅱ和Excel求解精馏塔最优回流比  

Determination of optimum reflux ratio of distillation column using PRO/Ⅱand Excel

作　　者：刘保柱[1] 

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

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

摘　　要：利用Excel附带的Visual Basic for Applications(VBA)编制最优回流比求解程序,程序调用PRO/Ⅱ分别进行不同塔板数下的工艺模拟和水力学计算,计算数据读入Excel内进行设备和运行费用的计算对比,最终得到最优回流比。对算例的计算表明该方法结果可靠,对其推广应用将有助于提高设计质量和设计效率。A program of reflux ratio optimization was developed using Visual Basic for Applications（VBA） that provided by Excel. It calls PRO/Ⅱ to finish process simulation and hydraulics computation and put data into Excel, capital cost and operation cost was computed and compared to get optimum reflux ratio. Compution of a example proved that result is reliable. The method can improve the quality and efficiency of design.

关 键 词：精馏 回流比 模拟 EXCEL PRO/Ⅱ 

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