## 在EXCEL环境下的加热炉热平衡计算软件开发

The Furnace Heat Balance of Calculate Software Development under the Excel Environment
Abstract:     Through the furnace heat balance test, we can analyze the work of the furnace, and adjust the furnace conditions, so that staff are better able to operate. Multiple and complex because of data, the subject is to be implemented by software processing of the test data, to improve the thermal balance calculation accuracy. This article describes the environment in EXCEL VBA programming language developed by means of furnace heat balance calculation software, to achieve the function of each part. The software running on the computer environment has a good working interface, enabling smooth man-machine dialogue; has high accuracy, performance computing to one decimal nine; also can save a lot of calculation and preparation of the report.
Keywords:    Furnace; Thermal Efficiency; Heat Balance; VBA
目录
1 绪论    1
1.1    课题背景及意义    1
1.1.1 目前国内外能源消耗状况    1 源自L六^维:论`文~网-.加7位QQ3249`114 www.lwfree.cn
1.1.2炉窑节能的措施    6
1.2本文主要工作    6
1.2.1 炉窑热诊断开发软件发展现状    6
1.2.2 本文研究目标    7
2 基于Excel环境下的炉窑热平衡测试软件计算软件开发    8
2.1 开发工具的选择    8
2.1.1  Microsoft Office Excel 2010 特点    8
2.2 开发总体思想    8
2.2.1 开发环境    9
2.2.2 开发对象    9
2.2.3 热平衡计算项目    9
2.2.4 软件要解决的问题    10
2.3 内插法的问题    10
3 炉窑热平衡测试软件开发    26
3.1 软件工作基本流程    26
3.2 数据输入工作簿    29
3.3 热平衡计算工作簿    31
3.4 各类数据库工作簿    32
3.4.1 气体比热数据库表    32
3.4.2 钢坯比热数据库表    33
3.4.3 常用材料表面法向发射率    34
3.4.4 含水量工作表    35
3.4.5蒸汽带走热量工作表    36
3.5 结果工作簿    37
3.6 炉窑合格与否判断    38
4 结论    40

1 绪论

------分隔线----------------------------