基于Excel的模拟墙体导热问题分析

摘要

Application software Excel was applied to simulate isothermal and convection boundary model due to avoidless apparatus and measurement error in two dimension temperature field of electric analog. The problem of two dimension wall heat conduction was solved using numerical method under isothermal and convection boundary condition. The result of simulation conforms to the electric analog experiment. Aiming to discuss building energy conservation, the model based on Excel was used to calculate the heat-shielding performance of 4 different coefficients of heat conductivity building materials in Urumqi.%针对二维导热物体温度场电模拟存在无法避免的仪器和测量所导致的误差,采用Excel软件,模拟了等温边界模型和对流边界模型,应用数值法求解等温及对流边界条件下墙角的二维稳态导热问题,模拟结果与电模拟实验进行了对比,一致性较好.应用基于Excel的电算模型,对4种不同导热系数的建筑材料在乌鲁木齐地区使用的保温隔热性能进行计算,探讨了建筑物的节能问题.