Excel迭代在冷水管道绝热层厚度计算中的应用  

The Application of Excel Iteration in Calculation of Insulation Layer Thickness of Cold Water Pipeline

作　　者：郈爱杰 张涛 沈程 Hou Aijie;Zhang Tao;Shen Cheng(China Automotive Engineering Corporation,Tianjin,300013)

机构地区：[1]中国汽车工业工程有限公司

出　　处：《制冷与空调（四川）》2019年第5期502-508,520,共8页Refrigeration and Air Conditioning

摘　　要：根据GB 502642013《工业设备及管道绝热工程设计规范》(以下简称《规范》)和GB/T 8175《设备及管道绝热设计导则》(以下简称《导则》)的相关计算公式和参数确定方法,以柳州地区冷水管道绝热为例,采用Excel表格迭代的方法,计算了柔性泡沫橡塑、离心玻璃棉、硬质聚氨酯泡沫作为冷水管道绝热材料时的绝热层厚度。该计算方法具有简便、快捷、准确的优点,计算结果与文献数据有较好的一致性。According to the relevant calculation formulas and methods of parameter determined which are from GB50264-2013 Industrial Equipment and Pipeline Thermal Insulation Engineering Design Specification"(hereinafter referred to as"Specifications")and GB/T8175 Guidelines for Equipment and Pipeline Thermal Insulation Design(hereinafter referred to as"Guidelines"),and taking the cold water pipeline insulation in Liuzhou area as an example,the iterative method of Excel table is used to calculate the thickness of the insulation layer when flexible foam rubber,centrifugal glass wool and rigid polyurethane foam are used as insulation materials for cold water pipelines.The iteration calculation method is simple,fast and accurate,and in good agreement with the data from specification.

关 键 词：管道绝热 Excel表格迭代计算 绝热层厚度 

分 类 号：TU86[建筑科学]