4.3 Article

Application of the Microsoft Excel Solver tool in the solution of optimization problems of heat exchanger network systems

期刊

EDUCATION FOR CHEMICAL ENGINEERS
卷 26, 期 -, 页码 41-47

出版社

ELSEVIER SCI LTD
DOI: 10.1016/j.ece.2018.10.003

关键词

Heat exchanger networks; Excel Solver; Optimization; Linear programming

向作者/读者索取更多资源

Optimization of heat exchanger networks (HENS) is a field of interest in Chemical Engineering. The aim is to use the residual heat of process streams to raise the temperature of other process streams which are cold, thus minimizing the use of hot and cold utilities. The usual way to deal with this task is to pose a linear programming problem according to a transshipment model in order to minimize either the general services consumptions or the number of hot and cold stream matchings required. This optimization is subjected to several restrictions given by the energy balances corresponding to each heat exchange. The high number of variables and equations obliges the use of specific software to solve these problems, e.g. GAMS (General Algebraic Modelling System). However, this software is not intuitive and requires a long time of training and a certain level of practice for the students to adequately use it. This work describes the use of Microsoft Excel-Solver for the sequential solving of HENS optimization problems according to the transshipment model. Solver is a much simpler, intuitive and easily available tool for the students who, besides, usually learn how to use it in the first years of their degree, in Informatics or similar subjects. Thus, it is not necessary to spend extra time in the teaching of the software, time that may be devoted to other contents. This paper presents an example of HENS problem proposed in the subject Simulation and Optimization of Chemical Processes corresponding to the Joint Master in Chemical Engineering of the Rey Juan Carlos University and the Autonoma University of Madrid and solved by the students using Excel-Solver. (C) 2018 Institution of Chemical Engineers. Published by Elsevier B.V. All rights reserved.

作者

我是这篇论文的作者
点击您的名字以认领此论文并将其添加到您的个人资料中。

评论

主要评分

4.3
评分不足

次要评分

新颖性
-
重要性
-
科学严谨性
-
评价这篇论文

推荐

暂无数据
暂无数据