灰关联分析法优选空调冷热源系统在Excel中的实现  

The Implementation of Gray Relational Analysis Algorithm for Optimum Selection of Air Conditioning Heating and Cooling Source System in Excel

作　　者：胡海华[1,2] 王孟孟[1,2] 潘镇镇 赵宝月[1] 

机构地区：[1]湖南工业大学土木工程学院,湖南株洲412007 [2]湖南工业大学协同创新中心,湖南株洲412007

出　　处：《湖南工业大学学报》2014年第5期93-97,共5页Journal of Hunan University of Technology

基　　金："十二五"国家科技支撑计划基金资助项目(2011BAJ03B07)

摘　　要：以灰色系统理论为依据、Excel软件为实现工具,提出利用Excel软件实现灰关联分析法优选空调冷热源系统。介绍了灰关联分析法原理,以及在Excel软件中需要使用的函数;通过一个工程实例,详细说明了在Excel软件中,利用灰关联分析法对5种冷热源系统的待选方案进行优选的过程。实例结果表明,5种冷热源系统的待选方案与参考方案的关联度大小排序为R(1)>R(3)>R(2)>R(4)>R(5),该计算结果与实际吻合,表明此方法科学、简单、实用,可供不同层次的暖通工程技术人员参考使用。With gray system theory as the basis and the Excel software as the implementation tool, put forward a Excel algorithm based on gray relational analysis for the optimum selection of air conditioning heating and cooling source system. Introduced the principle of gray correlation analysis method and the function needed to use in Excel software. Through an engineering example, described the process of using gray relational analysis method to select the optimal plan from five air conditioning heating and cooling source systems by Excel software. The results show that, the correlation degree sorting between the schemes of the five heating and cold source systems and the reference scheme is R（1）〉R（3）〉 R（2）〉R（4）〉R（5） and the calculated results agree with the actual, which indicates that the method is scientific, simple and practical. Provides reference for different levels of HVAC engineering.

关 键 词：灰关联分析法 EXCEL 优选 空调冷热源系统 

分 类 号：TU831[建筑科学—供热、供燃气、通风及空调工程]