论文部分内容阅读
在换热网络综合过程中,夹点计算是换热网络优化的主要环节,而“问题表格法”是比较常用而又准确的求取匹配换热的冷热物流间的夹点位置的方法,但需要大量的数学运算。本文基于Excel软件和VBA编程语言,开发出通用化的“问题表格法”以确定夹点位置的电算程序,能准确计算出夹点位置和最小加热(冷却)公用工程负荷,及绘制出总组合曲线。经过大量的运算表明该程序计算准确,速度快,而且,全部过程均在Excel后台完成,只需要输入相关的物流数据,即可输出准确的结果,该电算程序可在工程设计、研究中应用。
In the heat exchanger network synthesis process, the pinch point calculation is the main part of the heat exchanger network optimization, and “problem table method ” is more commonly used and accurate to find the pinch point position between the hot and cold logistics matching heat exchange Method, but requires a lot of math. Based on the Excel software and the VBA programming language, this paper develops a generalized “Problem Table Method” to determine the location of pinch points, accurately calculate the pinch location and the minimum heating (cooling) utility load, and draw Out of the total portfolio curve. After a large number of calculations show that the program is accurate, fast, and, the whole process is completed in Excel background, just enter the relevant logistics data, you can output accurate results, the computer program can be used in engineering design, research .