Cooling load calculation sheet .xlsx

	C	D	E	F	G	H	I	J	K	L	N	O	P	Q	R	S
1
2
3		Cooling load calculations
4		Cooling load calculations
5	Note:
6	Inputs in green boxes are to be given from psychrometric charts
7	Inputs in orange boxes are to be given from ISHRAE/ ASHRAE handbooks
8	Other inputs are to be given in grey coloured boxes only
9	Detailed notes are marked for red cornered boxes
10
11	Project location	PUNE
12	Building type	COMMERCIAL
13	Project	BANQUET HALL
14
15	Project area (sq.ft)	4200.00
16	Ceiling height (ft)	11.00
17	Space volume (Cu.ft)	46200.00
18	Design conditions	Summer mean monthly max for the month of may								The distribution changes as per the input values
19		DBT (°F)	(°C)	WBT (°F)	(°C)	RH(%)	HR(GR/lb)			The distribution changes as per the input values
20	Outside design conditions	100.94	38.30	88.62	31.46	60.00	175
21	Inside design conditions	75.20	24.00	62.85	17.14	50.00	66
22	Difference	25.74		25.77		10.00	109.00
23
24	Room sensible heat load	Area in sq.ft			Eqv. temp difference (ΔT)(°F)				(Btu/(hr ft2 oF)	(Btu/hr)	By-pass factor (BF)	0.12
25	Solar heat gain through glass	Area in sq.ft			Eqv. temp difference (ΔT)(°F)				U	Heat gain	Contact factor (CF)	0.88
26	Glass- N		136.00	x	28.00			x	1.210	4607.68
27	Glass- NE			x				x		0.00	Ventilation
28	Glass- E		68.00	x	163.00			x	1.210	13411.64	CFM per person	5.00	x	No. of persons	200	1000.00
29	Glass- SE			x				x		0.00	CFM per sq.ft	0.06	x		4200.00	252.00
30	Glass- S			x				x		0.00	Air change per hour		=		1
31	Glass- SW			x				x		0.00	Total CFM	46200.00	x	1	=	770.00
32	Glass- W			x				x		0.00
33	Glass- NW			x				x		0.00
34									Sum	18019.32
35
36	Room sensible heat load	Area in sq.ft			Eqv. temp difference (ΔT)(°F)				(Btu/(hr ft2 oF)	(Btu/hr)
37	Solar heat gain through wall	Area in sq.ft			Eqv. temp difference (ΔT)(°F)				U	Heat gain
38	Wall- N		689.00	x	10.00			x	0.355	2445.95
39	Wall- NE			x				x		0.00
40	Wall- E		548.00	x	30.00			x	0.355	5836.20
41	Wall- SE			x				x		0.00
42	Wall- S		825.00	x	20.00			x	0.355	5857.50	Effective Room Sensible Heat Factor= Effective Room Sensible Heat/
43	Wall- SW			x				x		0.00	Effective Room Total Heat
44	Wall- W			x				x		0.00	Effective Room Sensible Heat Factor=			0.71
45	Wall- NW			x				x		0.00	Effective Room Sensible Heat Factor=			0.71
46									Sum	14139.65
47
48	Solar heat gain through roof		4200.00	x	14.00			x	0.290	17052.00	Outside Air Sensible Heat (OASH)=
49											Total CFM x	ΔDBT x	CF x	1.08	18836.74
50	Transmission gains except	Area in sq.ft			Temp difference (ΔT)(°F)				(Btu/(hr ft2 oF)	(Btu/hr)
51	walls and roofs	Area in sq.ft			Temp difference (ΔT)(°F)				U	Heat gain	Outside Air Latent Heat (OALH)=
52	Glass		204.00	x	25.74			x	1.210	6353.66	Total CFM x	ΔHR x	CF x	0.68	50223.71
53	Partition	W-Wall	616.00	x	20.74			x	0.504	6439.02
54	Floor		4200.00	x	20.74			x	0.080	6968.64	Outside Air Total Heat (OATH)=				69060.45
55
56	Infiltration and	CFM			Temp difference (ΔT)(°F)				Factor		Apparatus Dew Point (ADP)
57	outside air	CFM			Temp difference (ΔT)(°F)				Factor		Indicated ADP (°F)		0.00
58	Infiltrated air			x		25.74		x	1.08	0.00	Selected ADP (°F)		54.00
59	Outside air		770.00	x		25.74		x	0.1296	2568.65
60											Dehumidified Rise
61	Internal heat gain										(Room DBT- ADP) x CF (°F)		18.656
62	People	No.of people	200	x		255	Btu/person	x		51000.00
63	Lighting		4200.00	x		1.00		x	3.41	14322.00	Dehumidified Air quantity (CFM)
64	Appliances, equipments					150		x	3.41	511.50	Effective Room Sensible Heat		7159.01		CFM
65									sum	65833.50	Dehumidified Rise x 1.08		7159.01		CFM
66											This parameter is useful while		3364.73		L/s
67									Total	137374.44	selecting the capacity of AC system		3364.73		L/s
68					Leak loss, Safety factor, etc			5-15 % of total value		6868.72
69
70						Effective room sensible heat			Total	144243.16	Grand Sub total heat load =				271944.74
71
72	Room latent heat gain										Leak gain, safety factor (1-3%)				8158.34
73	Infiltrated air			x		109.00		x	0.68	0.00
74	Outside air		770.00	x		109.00		x	0.0816	6848.69	Grand Total Heat Load =				280103.08
75	People	No.of people	200	x		245	Btu/person			49000.00	Grand Total Heat Load =				Btu/hr
76									sum	55848.69
77												Tonnage =		23.34
78					Leak loss, Safety factor, etc			2.5%-5% of total value		2792.43		Tonnage =		TR
79
80						Effective room latent heat			Total	58641.12	Notes:
81
82							Effective room total heat			202884.29
83
84
85
86	Source	%	Heat gain
87	Glass	8.70	24372.98
88	Walls and floor	9.83	27547.31
89	Roof	6.09	17052.00
90	Ventilation	28.02	78477.78
92	People	35.70	100000.00
93	Lighting and equipments	5.30	14833.50
94	Other factors	6.36	17819.50
95	Total	100.00	280103.08	Btu/hr
96
97
98
99
100
101