Load-Flow-Spreadsheet.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q
1	LOAD LISTING, CALCULATIONS & GENERATOR SIZING
2
3	Sr.	Equipment Name	Equip ID No	Absorbed Power	Rated Power	Load Factor	Eff	cosØ	MCC	Nature of Load*	Continous		Intermittent		Standby		Remarks
4	Sr.	Equipment Name	Equip ID No	Absorbed Power	Rated Power	Load Factor	Eff	cosØ	MCC	Nature of Load*	KW	KVAR	KW	KVAR	KW	KVAR	Remarks

5	1	Pump Water	WP 1	11	15	0.7	0.85	0.75	Maiin	C	12.94	11.41
6	2	Pump Water	WP2	11	15	0.7	0.85	0.75	Main	C	12.94	11.41
7	3	Pump Water	WP3	11	15	0.7	0.85	0.75	Main	S					12.94	11.41
8	4	Exhaust Fan	FN1	3	4	0.7	0.85	0.75	Main	I			3.53	3.11
9	5	Exhaust Fan	FN2	3	4	0.7	0.85	0.75	Main	S					3.53	3.11
10	6	Fire Water Pump	FP1	18	22	0.75	0.89	0.8	Emer	I			20.22	15.17
11	7	Fire Water Pump	FP2	18	22	0.75	0.89	0.8	Emer	S					20.22	15.17
12	8	Lighting Load		15	20	0.75	0.89	0.8	Emer	C	16.85	12.64
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28		Sum									42.74	35.47	23.75	18.28	36.70	29.69
29
30
31		Maximum Load =	100%	of continous load +		50%	of Intermittent load +			10%	of standby or biggest individual load (higher one)
32
33
34
35											KW	KVAR	KVA	cosØ	Amp	Volts
36		Maximum of normal running load									55	45	71	0.7744888427	102	400
37		Peak load									75	60	96	0.7813513049	138	400
38
39		Maximum of normal running load with 10% Growth Factor									60.07468605	49.06784646	77.56688379	0.7744888427	112	400
40		Peak load with 10% Growth Factor									82.32187707	65.75323972	105.3583408	0.7813513049	152	400
41
42		Reccemended Generator Size when	70%	loading							117.6026815	93.9331996	150.5119154	0.7813513049	217	400
43
44
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165