EXCEL迭代计算在自动喷水灭火系统水力计算中的应用  

Application of EXCEL Iterative Calculation in Hydraulic Calculation of Automatic Sprinkler System

作　　者：余小明 YU Xiao-ming(Guangzhou Watson Architectural and Engineering Design Consultant Co.Ltd.,Guangzhou 510045,China)

机构地区：[1]广州华森建筑与工程设计顾问有限公司,广东广州510045

出　　处：《中国给水排水》2020年第10期41-46,共6页China Water & Wastewater

摘　　要：自动喷水灭火系统的水力计算相对较为复杂,有些需借助专业软件进行计算,然而随着新版《自动喷水灭火系统设计规范》(GB 50084—2017)的实施,水力计算方法舍弃旧版《自动喷水灭火系统设计规范》(GB 50084—2001)舍维列夫公式,采用海澄-威廉公式,原有的一些简便计算方法也无法适用。以往的一些计算方法,大都根据管网末端最不利点喷头开始计算,最终得出系统所需要的压力及流量,而采用EXCEL迭代计算可以根据系统管道压力值,得出所选任意区域的喷头及管段流量值,并可根据相关计算结果,优化喷头的布置。The hydraulic calculation of automatic sprinkler system is relatively complex;some of which need to use professional software for calculation.However,with the implementation of the new version of Code for Design of Sprinkler Systems(GB 50084-2017),the hydraulic calculation method abandoned the Shevirev formula of old version of Code for Design of Sprinkler Systems(GB 50084-2001)and adopted the Hazen-Williams formula,some of the original simple calculation methods could not be applied.Previous calculation methods always based on the most unfavorable point nozzle at the end of the pipe network,the pressure and flow rate of the system are calculated.The EXCEL iterative calculation can be used to calculate the flow rate of the nozzle and pipe section in any selected area according to the pressure value of the pipe system,and according to the calculation results,optimize the layout of the nozzle.

关 键 词：迭代计算 自动喷水灭火系统 水力计算 喷水强度 作用面积 喷淋管径 设计流量 

分 类 号：TU892[建筑科学]