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.     

VFP环境下报表设计研究

Visual FoxPro是小型数据库应用系统开发工具,而报表设计是数据库应用系统开发的一个重要组成部分,直接决定系统的输出是否能够满足用户的需要。为此详细研究了报表设计方法,结合Microsoft的OLE技术,引入面向对象方法,提出了一种新的报表设计方法。实践应用证明,该方法非常适合设计复杂的报表。     

混凝土构件承载力计算的Excel实现

运用Excel软件,高效解决了混凝土结构计算中较复杂的圆形截面偏压构件的承载力计算问题。该编程计算方法同样适用于土力学、水力学、钢结构等领域。对于解决工程中的各种学科计算问题有着广阔的应用前景。     

用VBA开发基于Excel的数据统计

Excel是广泛应用的电子数据表格程序,如在Excel中使用VBA（Visual Basic for Application）编程将有很多机会开发出有价值的应用程序,本文介绍一种基于Excel的VBA编程方法,来扩展Excel的功能,以实现学生评优和奖学金评选的数据统计的计算功能。     

利用Excel表格进行供暖系统计算

利用Excel表格进行供暖工程设计计算，可以减少工作量，提高工作效率。介绍了房间热负荷和供暖管道水力计算方法。     

交点计算的几种方法

在工程测量中，经常涉及到交点计算，如何运用现有的工具快速地计算出交点非常重要。本文介绍了利用控制器、AutoCAD绘图软件和Excel计算交点的方法，供大家参考。     

基于欧玛技术的大学英语考试总评成绩计算方法

以基于欧玛技术的阅卷系统为例,介绍了用Excel实现大学英语分类成绩的接口及合并计算总评成绩的基本方法与步骤.     

Excel2000及AutoCAD2004在高炉炉壳圆锥管段下料中的应用

介绍Excel2 0 0 0与普通的计算法相结合 ,AutoCAD2 0 0 4与普通的图解法相结合的方法快速、准确获取高炉壳圆锥管段下料所需数据 ,以供人工号料 ,半自动切割或数控切割。     

对单件小批铸造生产作业计划进行计算机辅助控制

为有效控制单件小批铸造生产计划的科学制定,石家庄煤矿机械有限责任公司铸造生产中的调度与生产管理方法、生产经验与计算机应用简易结合,取得了良好的效果。促进了公司在铸造工序的管理进步,很好地将经济指标、生产指标、管理目标相统一,提高了铸造的市场适应力与反应力。     

Excel二次开发在模拟水氡观测中的应用

尝试对Excel工作表进行二次开发,将其应用到台站模拟水氡观测工作当中,可以自动计算出模拟水氡观测的标定、季检结果,需要作图的还可以自动作图,杜绝了人工计算产生的不必要误差,减轻了劳动强度,实现了观测资料的数字化存档,对台站模拟水氡观测日常工作具有很大帮助。经吉林省地震局多个台站使用,Excel工作表自动计算结果与人工计算结果两者完全相符,效果良好。