| 利用Excel VBA开发除尘管网平衡计算软件 |
| |
| 引用本文： | 黄勇波,封洪波. 利用Excel VBA开发除尘管网平衡计算软件[J]. 建筑热能通风空调, 2008, 27(5) |
| |
| 作者姓名： | 黄勇波 封洪波 |
| |
| 作者单位： | 中冶赛迪工程技术股份有限公司;中冶赛迪工程技术股份有限公司 |
| |
| 摘 要： | 利用Excel VBA平台开发了除尘管网平衡优化软件.采用模拟管网内实际流动工况的方法进行水力计算,求解各支管的风量分配,并据此进行整个管网的风量平衡计算.管网经优化后,抽风点的风量偏差控制在10%以内,而不满足上述要求的抽风点点数占总点数的百分率控制在5%以内.软件的开发实现了在计算机上对管网系统的动态模拟,对现场调试工作及系统故障的分析解决都有指导作用,大大提高了设计师的工作效率和现场施工质量.优化后的除尘管网,不仅可以保证除尘效果,达到环保要求;还能节省投资,节约能源.
|
| 关 键 词： | Excel VBA 除尘管网 阻力平衡 |
Developing Balancing Software for Dedusting Duct System with Excel VBA |
| |
| HUANG Yong-bo,FENG Hong-bo. Developing Balancing Software for Dedusting Duct System with Excel VBA[J]. Building Energy & Environment, 2008, 27(5) |
| |
| Authors: | HUANG Yong-bo FENG Hong-bo |
| |
| Abstract: | A hydraulic resistance balance software for dedusting duct system is developed with Excel VBA.In order to obtain the air distribution and balance the whole duct system,dynamic hydraulic calculating method is used.For duct system optimized using this software,the air-rate deviation for every suction is less than 10% and the percent of un-balanced suction point is less than 5.Using the software to designing dedusting duct system,is helpful not only for field work,but also for improving work efficiency and the quality of construction.All efforts are made to guarantee the dedusting effect and save energy. |
| |
| Keywords: | Excel VBA |
| 本文献已被 CNKI 维普 万方数据 等数据库收录！ |
|
