Energy consumption on excel

hazard7
CopyofLoadCalculation.xlsx
Home>Engineering homework help>Mechanical Engineering homework help>Energy consumption on excel

whole

1 Running Feet of Exposed Wall 188.2 Design Conditions
2 Space Dimensions, ft2 542 Winter : Outside 0 °F
3 Ceiling Dimensions ft 8 Inside 70 °F
Type Constr. HTM Area Btuh T.D. 70 °F
of Exposure No. Htg. Clg. or Length Htg.(Loss) Clg.(Gain)
4 Gross a 1505.6 Summer: Outside 95 °F
Exposed b Inside 75 °F
Walls and c T.D. 20 °F
Partitions d Daily Range: M
5 Windows a Tab2 3b 42.6 105 4473.00 Difference of Grains: 30
and Glass b (50% relative humidity)
Doors (total 80.3ft x 3ft) c
(Heating) d Heat Loss Infiltration
6 Windows North 0 30 0 Winter Cfm= AC/HR X Volum
and Glass E&W NE&NW 46 30 1380 60
Doors (double pane; no shading) South or SE&SW 25 30 750 Winter Cfm= AC/HR = 2.2 (Table 5; under 900 ft^2; poor)
(Cooling) Basement/Other 0 0 Volum = 4336.00
7 Other a 11A 41.3 13.9 0 0.00 0 Winter Cfm= 158.99
Doors b Tab2 & 4 0 0
8 Net a Tab2 12E 5.3 1.8 1400.60 7423.18 2521.08 Heat Gain Infiltration
Exposed b Tab4 12E 0 0 Summer Cfm= AC/HR X Volum
Walls and c 0 0 60
Partitions d 0 0 Summer Cfm= AC/HR = 0.8 (Table 5; under 900 ft^2; poor)
9 Ceiling a Tab2 16G 2.3 1.5 542 1246.60 813 Volum = 4336.00
b 0 0 Summer Cfm= 57.81
10 Floors a Tab2 22b 28.7 0 188.2 5401.34 0
b Tab4 22b
11 Infiltration: Sensible (1.1xcfmxTD) 12241.97 1271.89 Residential
12 Sub-Total Btuh Loss(5+7+8+9+10+11) 30786.09 Number of People = (4)
13 Duct Btuh Loss 10% 3078.61
14 Total Btuh Loss (12+13) 33864.70 TONS CFM
15 People at 300 and Appliances at 1200 Btuh (Sensible) 1800.00 1.35 539.85
16 Sub-Sensible Btuh Gain (6+7+8+9+10+11+15) 8535.97 401.5990690278
17 Duct Btuh Gain 10% 853.60
18 Total Sensible Btuh Gain = 16+17 9389.57
19 Infiltration: Latent Heat (0.68* gr. Diff*summer cfm) 1179.39
20 Internal Loads (230X No. of people (includes appliance ) (Latent) 1380.00 2.8220585556 ton
21 LTS (space dimention ft^2 x 3.413) 1849.85 1.3496047222 ton
22 OA (number of people x cfm/person + cfm/sq ft x floor dimention ft^2) * 42.4 2396.45
23 Total Cooling Capacity= 18+19+20+21+22(TOTAL GAIN) 16195.26
22 1.1*TD for summer
20.4 0.68*grain diff
42.4

Zone1

1 Running Feet of Exposed Wall 71.2 Design Conditions
2 Space Dimensions, ft2 252.84 Winter : Outside 0 °F
3 Ceiling Dimensions ft 8 Inside 70 °F
Type Constr. HTM Area Btuh T.D. 70 °F
of Exposure No. Htg. Clg. or Length Htg.(Loss) Clg.(Gain)
4 Gross a 569.6 Summer: Outside 95 °F
Exposed b Inside 75 °F
Walls and c T.D. 20 °F
Partitions d Daily Range: M
5 Windows a Tab2 3b 42.6 30 1278.00 Difference of Grains: 30
and Glass b (50% relative humidity)
Doors (total 80.3ft x 3ft) c
(Heating) d Heat Loss Infiltration
6 Windows North 0 0 0 Winter Cfm= AC/HR X Volum
and Glass E&W NE&NW 46 30 1380 60
Doors (double pane; no shading) South or SE&SW 25 0 0 Winter Cfm= AC/HR = 2.2 (Table 5; under 900 ft^2; poor)
(Cooling) Basement/Other 0 0 Volum = 2022.72
7 Other a 11A 41.3 13.9 0 0.00 0 Winter Cfm= 74.17
Doors b Tab2 & 4 0 0
8 Net a Tab2 12E 5.3 1.8 539.60 2859.88 971.28 Heat Gain Infiltration
Exposed b Tab4 12E 0 0 Summer Cfm= AC/HR X Volum
Walls and c 0 0 60
Partitions d 0 0 Summer Cfm= AC/HR = 0.8 (Table 5; under 900 ft^2; poor)
9 Ceiling a Tab2 16G 2.3 1.5 252.84 581.53 379.26 Volum = 2022.72
b 0 0 Summer Cfm= 26.97
10 Floors a Tab2 22b 28.7 0 71.2 2043.44 0
b Tab4 22b
11 Infiltration: Sensible (1.1xcfmxTD) 5710.81 593.33 Residential
12 Sub-Total Btuh Loss(5+7+8+9+10+11) 12473.66 Number of People = (4)
13 Duct Btuh Loss 10% 1247.37
14 Total Btuh Loss (12+13) 13721.03 TONS CFM
15 People at 300 and Appliances at 1200 Btuh (Sensible) 3000.00 0.95 380.35
16 Sub-Sensible Btuh Gain (6+7+8+9+10+11+15) 6323.87 265.9093086806
17 Duct Btuh Gain 10% 632.39
18 Total Sensible Btuh Gain = 16+17 6956.26
19 Infiltration: Latent Heat (0.68* gr. Diff*summer cfm) 550.18
20 Internal Loads (230X No. of people (includes appliance ) (Latent) 1380.00 1.1434192733 ton
21 LTS (space dimention ft^2 x 3.413) 862.94 0.9508505033 ton
22 OA (number of people x cfm/person + cfm/sq ft x floor dimention ft^2) * 42.4 1660.82
23 Total Cooling Capacity= 18+19+20+21+22(TOTAL GAIN) 11410.21
22 1.1*TD for summer
20.4 0.68*grain diff
42.4

Zone2

1 Running Feet of Exposed Wall 74 Design Conditions
2 Space Dimensions, ft2 212.29 Winter : Outside 0 °F
3 Ceiling Dimensions ft 8 Inside 70 °F
Type Constr. HTM Area Btuh T.D. 70 °F
of Exposure No. Htg. Clg. or Length Htg.(Loss) Clg.(Gain)
4 Gross a 592 Summer: Outside 95 °F
Exposed b Inside 75 °F
Walls and c T.D. 20 °F
Partitions d Daily Range: M
5 Windows a Tab2 3b 42.6 60 2556.00 Difference of Grains: 30
and Glass b (50% relative humidity)
Doors (total 80.3ft x 3ft) c
(Heating) d Heat Loss Infiltration
6 Windows North 0 30 0 Winter Cfm= AC/HR X Volum
and Glass E&W NE&NW 46 0 0 60
Doors (double pane; no shading) South or SE&SW 0 30 0 Winter Cfm= AC/HR = 2.2 (Table 5; under 900 ft^2; poor)
(Cooling) Basement/Other 0 0 Volum = 1698.32
7 Other a 11A 41.3 13.9 0 0.00 0 Winter Cfm= 62.27
Doors b Tab2 & 4 0 0
8 Net a Tab2 12E 5.3 1.8 532.00 2819.60 957.60 Heat Gain Infiltration
Exposed b Tab4 12E 0 0 Summer Cfm= AC/HR X Volum
Walls and c 0 0 60
Partitions d 0 0 Summer Cfm= AC/HR = 0.8 (Table 5; under 900 ft^2; poor)
9 Ceiling a Tab2 16G 2.3 1.5 212.29 488.27 318.435 Volum = 1698.32
b 0 0 Summer Cfm= 22.64
10 Floors a Tab2 22b 28.7 0 74 2123.80 0
b Tab4 22b
11 Infiltration: Sensible (1.1xcfmxTD) 4794.92 498.17 Residential
12 Sub-Total Btuh Loss(5+7+8+9+10+11) 12782.59 Number of People = (4)
13 Duct Btuh Loss 10% 1278.26
14 Total Btuh Loss (12+13) 14060.85 TONS CFM
15 People at 300 and Appliances at 1200 Btuh (Sensible) 0.00 0.31 122.61
16 Sub-Sensible Btuh Gain (6+7+8+9+10+11+15) 1774.21 692.5917181038
17 Duct Btuh Gain 10% 177.42
18 Total Sensible Btuh Gain = 16+17 1951.63
19 Infiltration: Latent Heat (0.68* gr. Diff*summer cfm) 461.94
20 Internal Loads (230X No. of people (includes appliance ) (Latent) 0.00 1.1717374594 ton
21 LTS (space dimention ft^2 x 3.413) 724.55 0.3065153603 ton
22 OA (number of people x cfm/person + cfm/sq ft x floor dimention ft^2) * 42.4 540.07
23 Total Cooling Capacity= 18+19+20+21+22(TOTAL GAIN) 3678.18
22 1.1*TD for summer
20.4 0.68*grain diff
42.4

Zone3

1 Running Feet of Exposed Wall 60.7 Design Conditions
2 Space Dimensions, ft2 77.52 Winter : Outside 0 °F
3 Ceiling Dimensions ft 8 Inside 70 °F
Type Constr. HTM Area Btuh T.D. 70 °F
of Exposure No. Htg. Clg. or Length Htg.(Loss) Clg.(Gain)
4 Gross a 485.6 Summer: Outside 95 °F
Exposed b Inside 75 °F
Walls and c T.D. 20 °F
Partitions d Daily Range: M
5 Windows a Tab2 3b 42.6 15 639.00 Difference of Grains: 30
and Glass b (50% relative humidity)
Doors (total 80.3ft x 3ft) c
(Heating) d Heat Loss Infiltration
6 Windows North 0 0 0 Winter Cfm= AC/HR X Volum
and Glass E&W NE&NW 46 15 690 60
Doors (double pane; no shading) South or SE&SW 0 0 0 Winter Cfm= AC/HR = 2.2 (Table 5; under 900 ft^2; poor)
(Cooling) Basement/Other 0 0 Volum = 620.16
7 Other a 11A 41.3 13.9 0 0.00 0 Winter Cfm= 22.74
Doors b Tab2 & 4 0 0
8 Net a Tab2 12E 5.3 1.8 470.60 2494.18 847.08 Heat Gain Infiltration
Exposed b Tab4 12E 0 0 Summer Cfm= AC/HR X Volum
Walls and c 0 0 60
Partitions d 0 0 Summer Cfm= AC/HR = 0.8 (Table 5; under 900 ft^2; poor)
9 Ceiling a Tab2 16G 2.3 1.5 77.52 178.30 116.28 Volum = 620.16
b 0 0 Summer Cfm= 8.27
10 Floors a Tab2 22b 28.7 0 60.7 1742.09 0
b Tab4 22b
11 Infiltration: Sensible (1.1xcfmxTD) 1750.92 181.91 Residential
12 Sub-Total Btuh Loss(5+7+8+9+10+11) 6804.48 Number of People = (4)
13 Duct Btuh Loss 10% 680.45
14 Total Btuh Loss (12+13) 7484.93 TONS CFM
15 People at 300 and Appliances at 1200 Btuh (Sensible) 0.00 0.22 88.31
16 Sub-Sensible Btuh Gain (6+7+8+9+10+11+15) 1835.27 351.130540388
17 Duct Btuh Gain 10% 183.53
18 Total Sensible Btuh Gain = 16+17 2018.80
19 Infiltration: Latent Heat (0.68* gr. Diff*summer cfm) 168.68
20 Internal Loads (230X No. of people (includes appliance ) (Latent) 0.00 0.6237444033 ton
21 LTS (space dimention ft^2 x 3.413) 264.58 0.2207725933 ton
22 OA (number of people x cfm/person + cfm/sq ft x floor dimention ft^2) * 42.4 197.21
23 Total Cooling Capacity= 18+19+20+21+22(TOTAL GAIN) 2649.27
22 1.1*TD for summer
20.4 0.68*grain diff
42.4