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

Optimization of heat exchanger networks (HEN_S) 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 HEN_S 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 HEN_S 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 Autónoma University of Madrid and solved by the students using Excel-Solver.     

Excel在管道安装计算中的应用

在工业管道安装中,采用传统的几何作图法或计算公式法对管件或管线连接放样计算效率低,容易出错,利用Excel软件的函数计算功能编程计算,快捷准确,方便高效。     

利用VB编程控制Excel处理测量数据

介绍了利用VB 6.0编程控制电子表格Excel处理测量数据的编程方法与技巧,从而实现测量数据处理可视化和制表自动化,提高了测量数据处理的效率和准确性.     

多层次模糊综合评定在测绘质量管理中的运用

阐述了用模糊数学的计算方法来评定测绘产品的质量优良等级的方法,并进一步结合Excel的计算功能,实现产品质量评定的科学化.     

Excel在岩土工程计算中的应用

以滑坡剩余推力法计算和地基沉降量计算为例,介绍了Excel在岩土工程计算中的一些应用,实践结果表明:Excel软件有其独特的优点,利用其进行岩土计算可以大大提高工作效率,值得推广应用。     

用有限差分法计算Winkle梁的一种方法

介绍了一种用有限差分法计算winkle弹性基础梁的简单实用的方法，此方法中Excel软件、Matlab软件联合使用，优势互补，组成一个开放的、易修改的、具有软件性质的计算模块。     

Excel在制冷机组故障检测与诊断工具开发中的应用

用Excel表格作为后台数据库,在VC平台上结合.NET数据库技术,开发了大型制冷机组的故障检测与诊断工具。用现场实验数据进行检验表明,该故障检测与诊断工具具有运行稳健,故障检测准确、快速等优点,能够用于生产现场的实时故障检测与诊断。     

测绘仪器精度状况管理方法探讨

测绘仪器精度状况管理是一项繁杂的、经常性的工作，Excel具有数据库的最基本的功能，利用Excel进行测绘仪器精度状况管理可以极大地提高效率，而且非常经济。本文以常规大地测量仪器为例子提出了其具体办法。     

Excel用于排水管网的设计及优化

采用以Excel为数据库的编程方法对排水管网进行了优化设计。Excel可与其他应用软件实现资源共享，支持VBasic编程，便于排水管网优化设计计算。对污水管道采用两相优化理论设计，对雨水管道采用与地面坡度一致法进行优化计算。将污水、雨水、合流制管网及混合管网统一为排水管网，用一套程序同时完成各种体制的排水管网的优化设计计算。     

在Excel中进行断面数据的计算与输出

在进行断面测量时通常使用水准仪配水准尺来测量高程,使用轻便卷尺来丈量距离,根据前后视的读数和后视点的高程来计算出断面点的高程.本文介绍了在Excel中制作断面记录模板,只需输入观测数据即可实现断面数据的自动计算和输出,减少了出错几率,提高了工作效率.