Ms-excel在编制煤/气混烧电站锅炉热力计算中的应用  

The Application of Ms-excel in the Thermal Calculation of Coal and Gas Mixed Power Boiler

作　　者：王文欢[1] 潘卫国[1] 孙坚荣[1] 周云龙[2] 

机构地区：[1]上海电力学院能源与环境工程学院,上海200090 [2]东北电力学院能源与机械工程学院,辽宁吉林132012

出　　处：《锅炉技术》2006年第6期51-55,共5页Boiler Technology

基　　金：上海市重点学科建设项目资助(P1302)

摘　　要：采用Ms-excel编制热力计算程序,充分利用其内置的函数库、强大VBA编程功能,以及加载宏,绘制图表、拟合公式等功能,使煤/气混烧电站锅炉热力计算程序实现界面友好化,计算速度快,修改方便等优点,同样为广大锅炉设计、改造等工作者提供一种更方便的编制热力计算方法。The thermal calculation of pulverized coal and gas mixed-burning power boiler is compiled based on the Ms-excel, which can easily utilize the functions of Ms-excel such as the function base, VBA programming, macro loading chart drawing, formula fitting and so on. It is realized so many advantages such as friendly interface, fast calculation, facility modification. At the same time, it affords more convenient method of compiling the thermal calculation for the boiler designer and modifier.

关 键 词：锅炉 热力计算 Ms-excel 函数 宏 

分 类 号：TK212[动力工程及工程热物理—动力机械及工程]