房间热负荷EXCEL计算实例1

101G型主卧室

105G型卧室

221G型主卧室

228M型主卧室

1204J型起居厅

名称及方向北内墙南外墙南外窗西外墙地面楼板北外墙北外窗西外墙西内墙东内墙地面楼板北内墙南外墙南外窗西外墙南外墙南幕墙东外墙东外窗东幕墙北外墙北外窗阳台门东内墙东内门屋顶

维护结构面积计算㎡1.9*2.9

3.9*2.9-1.8*21.8*24.8*2.94.8*3.93.3*2.9-1.5*11.5*12.7*2.93.0*2.94.2*2.93.3*4.23.9*2.9

3.9*2.9-1.8*21.8*24.8*2.92.5*2.92.2*2.9

4.8*2.9-0.9*0.80.9*0.82.22*2.9

5.9*2.9-0.9*0.8-1.5*2.30.9*0.81.5*2.3

5.3*2.9-1.5*2.11.5*2.15.9*5.7

传热系数室内计算温度室外计算温度室内外计算温度差温差修正系数面积㎡

KTrw/(㎡*℃)(℃)5.512.597.711.333.63.61213.921.3318.711.658.071.331.53.6127.831.338.72.5912.182.5913.861.6511.312.597.711.333.63.61213.921.337.251.336.383.0113.21.330.723.6126.4383.0112.941.330.723.6123.455.8212.222.593.155.8233.63

0.98

t0.mtr*tom(△t)(℃)(℃)

20-1120-1120-1120-1120-1120-1120-1120-1120-1120-1120-1120-1120-1120-1120-1120-1120-1120-1120-1120-1120-1120-1120-1120-1120-1120

-11

a310.7311311311310.4

311311311310.7310.7310.4310.4311311311311311311311311311311311310.4310.431

1

基本耗热量耗热量修正Q朝向修正率风力附加修正值修正后热量高度附加(W)(%)309.68317.88403.1573.92383.01332.73167.96322.83488.97684.55283.58363.33317.88403.1573.92298.92595.32544.2480.62600.73533.5280.62622.65392.46227.331021.68

(%)

00-200-200-50000000-5000000000-200-20000-200-200-50-50-5000000000000

0

1309.680.8254.30.8322.480.95545.221383.011332.731167.960.95306.691488.971684.551283.581363.230.8254.310.8322.481573.920.8239.130.8476.250.95517.020.9576.590.95570.691533.52180.621622.451392.461227.331

1021.68

00000

000000000000000000000

房间维护结构热负荷冷风渗透耗热量户间传热量常规采暖房间设计热负荷Q1/(W0)

Q2/W

Q3/W

Q4/W

2132.062264.481513.941879.682878.06317.37234.97317.3791.55420.1185.33137.21370.66543.31332.942449.43

2499.45

1831.31

1971.23

3298.16

房间热负荷Q/W

2634.76

2636.66

2201.97

2514.54

3631.1