Heating and air conditioning- load calculation on excel : mechanical engineering only please

profilehazard7
LoadCalculationv3zonebyzoneclass.xlsx
Home>Engineering homework help>Mechanical Engineering homework help>Heating and air conditioning- load calculation on excel : mechanical engineering only please

Whole

1 Running Feet of Exposed Wall 120 Design Conditions
2 Space Dimensions, ft2 756 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 960 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 45 1917.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 15 375 Winter Cfm= AC/HR = 2.2 (Table 5; under 900 ft^2; poor)
(Cooling) Basement/Other 0 0 Volum = 6048.00
7 Other a 11A 41.3 13.9 21 867.30 291.9 Winter Cfm= 221.76
Doors b Tab2 & 4 0 0
8 Net a Tab2 12E 5.3 1.8 894.00 4738.20 1609.20 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 756 1738.80 1134 Volum = 6048.00
b 0 0 Summer Cfm= 80.64
10 Floors a Tab2 22b 28.7 0 120 3444.00 0
b Tab4 22b
11 Infiltration: Sensible (1.1xcfmxTD) 17075.52 1774.08 Residential
12 Sub-Total Btuh Loss(5+7+8+9+10+11) 29780.82 Number of People = (4)
13 Duct Btuh Loss 10% 2978.08
14 Total Btuh Loss (12+13) 32758.90 TONS CFM
15 People at 300 and Appliances at 1200 Btuh (Sensible) 2400.00 1.48 592.59
16 Sub-Sensible Btuh Gain (6+7+8+9+10+11+15) 8964.18 510.3181354307
17 Duct Btuh Gain 10% 896.42
18 Total Sensible Btuh Gain = 16+17 9860.60
19 Infiltration: Latent Heat (0.68* gr. Diff*summer cfm) 1645.06
20 Internal Loads (230X No. of people (includes appliance ) (Latent) 920.00 2.7299085 ton
21 LTS (space dimention ft^2 x 3.413) 2580.23 1.4814288333 ton
22 OA (number of people x cfm/person + cfm/sq ft x floor dimention ft^2) * 42.4 2771.26
23 Total Cooling Capacity= 18+19+20+21+22(TOTAL GAIN) 17777.15
22 1.1*TD for summer
20.4 0.68*grain diff
42.4

Zone1

1 Running Feet of Exposed Wall 54 Design Conditions
2 Space Dimensions, ft2 324 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 432 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 0 0 0 60
Doors (double pane; no shading) South or SE&SW 25 15 375 Winter Cfm= AC/HR = 2.2 (Table 5; under 900 ft^2; poor)
(Cooling) Basement/Other 0 0 Volum = 2592.00
7 Other a 11A 41.3 13.9 21 867.30 291.9 Winter Cfm= 95.04
Doors b Tab2 & 4 0 0
8 Net a Tab2 12E 5.3 1.8 396.00 2098.80 712.80 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 324 745.20 486 Volum = 2592.00
b 0 0 Summer Cfm= 34.56
10 Floors a Tab2 22b 28.7 0 54 1549.80 0
b Tab4 22b
11 Infiltration: Sensible (1.1xcfmxTD) 7318.08 760.32 Residential
12 Sub-Total Btuh Loss(5+7+8+9+10+11) 13218.18 Number of People = (4)
13 Duct Btuh Loss 10% 1321.82
14 Total Btuh Loss (12+13) 14540.00 TONS CFM
15 People at 300 and Appliances at 1200 Btuh (Sensible) 1200.00 0.57 228.13
16 Sub-Sensible Btuh Gain (6+7+8+9+10+11+15) 3826.02 568.1125774689
17 Duct Btuh Gain 10% 382.60
18 Total Sensible Btuh Gain = 16+17 4208.62
19 Infiltration: Latent Heat (0.68* gr. Diff*summer cfm) 705.02
20 Internal Loads (230X No. of people (includes appliance ) (Latent) 0.00 1.2116665 ton
21 LTS (space dimention ft^2 x 3.413) 1105.81 0.5703095 ton
22 OA (number of people x cfm/person + cfm/sq ft x floor dimention ft^2) * 42.4 824.26
23 Total Cooling Capacity= 18+19+20+21+22(TOTAL GAIN) 6843.71
22 1.1*TD for summer
20.4 0.68*grain diff
42.4

Zone2

1 Running Feet of Exposed Wall 12 Design Conditions
2 Space Dimensions, ft2 144 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 96 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 = 1152.00
7 Other a 11A 41.3 13.9 0 0.00 0 Winter Cfm= 42.24
Doors b Tab2 & 4 0 0
8 Net a Tab2 12E 5.3 1.8 81.00 429.30 145.80 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 144 331.20 216 Volum = 1152.00
b 0 0 Summer Cfm= 15.36
10 Floors a Tab2 22b 28.7 0 12 344.40 0
b Tab4 22b
11 Infiltration: Sensible (1.1xcfmxTD) 3252.48 337.92 Residential
12 Sub-Total Btuh Loss(5+7+8+9+10+11) 4996.38 Number of People = (4)
13 Duct Btuh Loss 10% 499.64
14 Total Btuh Loss (12+13) 5496.02 TONS CFM
15 People at 300 and Appliances at 1200 Btuh (Sensible) 600.00 0.35 141.46
16 Sub-Sensible Btuh Gain (6+7+8+9+10+11+15) 1989.72 407.1780206813
17 Duct Btuh Gain 10% 198.97
18 Total Sensible Btuh Gain = 16+17 2188.69
19 Infiltration: Latent Heat (0.68* gr. Diff*summer cfm) 313.34
20 Internal Loads (230X No. of people (includes appliance ) (Latent) 460.00 0.4580015 ton
21 LTS (space dimention ft^2 x 3.413) 491.47 0.3536536667 ton
22 OA (number of people x cfm/person + cfm/sq ft x floor dimention ft^2) * 42.4 790.34
23 Total Cooling Capacity= 18+19+20+21+22(TOTAL GAIN) 4243.84
22 1.1*TD for summer
20.4 0.68*grain diff
42.4

Zone3

1 Running Feet of Exposed Wall 24 Design Conditions
2 Space Dimensions, ft2 144 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 192 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 = 1152.00
7 Other a 11A 41.3 13.9 0 0.00 0 Winter Cfm= 42.24
Doors b Tab2 & 4 0 0
8 Net a Tab2 12E 5.3 1.8 177.00 938.10 318.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 144 331.20 216 Volum = 1152.00
b 0 0 Summer Cfm= 15.36
10 Floors a Tab2 22b 28.7 0 24 688.80 0
b Tab4 22b
11 Infiltration: Sensible (1.1xcfmxTD) 3252.48 337.92 Residential
12 Sub-Total Btuh Loss(5+7+8+9+10+11) 5849.58 Number of People = (4)
13 Duct Btuh Loss 10% 584.96
14 Total Btuh Loss (12+13) 6434.54 TONS CFM
15 People at 300 and Appliances at 1200 Btuh (Sensible) 600.00 0.37 147.80
16 Sub-Sensible Btuh Gain (6+7+8+9+10+11+15) 2162.52 389.7225121585
17 Duct Btuh Gain 10% 216.25
18 Total Sensible Btuh Gain = 16+17 2378.77
19 Infiltration: Latent Heat (0.68* gr. Diff*summer cfm) 313.34
20 Internal Loads (230X No. of people (includes appliance ) (Latent) 460.00 0.5362115 ton
21 LTS (space dimention ft^2 x 3.413) 491.47 0.3694936667 ton
22 OA (number of people x cfm/person + cfm/sq ft x floor dimention ft^2) * 42.4 790.34
23 Total Cooling Capacity= 18+19+20+21+22(TOTAL GAIN) 4433.92
22 1.1*TD for summer
20.4 0.68*grain diff
42.4

Zone4

1 Running Feet of Exposed Wall 30 Design Conditions
2 Space Dimensions, ft2 144 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 240 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 0 0.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 0 0 0 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 = 1152.00
7 Other a 11A 41.3 13.9 0 0.00 0 Winter Cfm= 42.24
Doors b Tab2 & 4 0 0
8 Net a Tab2 12E 5.3 1.8 240.00 1272.00 432.00 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 144 331.20 216 Volum = 1152.00
b 0 0 Summer Cfm= 15.36
10 Floors a Tab2 22b 28.7 0 30 861.00 0
b Tab4 22b
11 Infiltration: Sensible (1.1xcfmxTD) 3252.48 337.92 Residential
12 Sub-Total Btuh Loss(5+7+8+9+10+11) 5716.68 Number of People = (4)
13 Duct Btuh Loss 10% 571.67
14 Total Btuh Loss (12+13) 6288.35 TONS CFM
15 People at 300 and Appliances at 1200 Btuh (Sensible) 0.00 0.19 75.19
16 Sub-Sensible Btuh Gain (6+7+8+9+10+11+15) 985.92 766.0715425702
17 Duct Btuh Gain 10% 98.59 Htg Load 32758.90 32758.902
18 Total Sensible Btuh Gain = 16+17 1084.51 Clg Load 17777.15 17777.146
19 Infiltration: Latent Heat (0.68* gr. Diff*summer cfm) 313.34
20 Internal Loads (230X No. of people (includes appliance ) (Latent) 0.00 0.524029 ton
21 LTS (space dimention ft^2 x 3.413) 491.47 0.187972 ton
22 OA (number of people x cfm/person + cfm/sq ft x floor dimention ft^2) * 42.4 366.34
23 Total Cooling Capacity= 18+19+20+21+22(TOTAL GAIN) 2255.66
22 1.1*TD for summer
20.4 0.68*grain diff
42.4

Sheet5