Calculate-Size-of-Diesel-Generator-22-8-12.xlsx

	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	U	V	W	Y	Z	BA	BB	BC
1
2																		Jignesh.N.Parmar www.electricalnotes.wordpress.com jiguparmar@yahoo.com
3
4		System Voltage ( P-P )	415	Volt		Linear Load:		General Equipments, Heater
5		System Voltage ( P-N )	230	Volt		Non-Linear Load:		UPS,Invertor,Ballast,VFD
6		Future Load Expansion	0%	%	1
7		Average Intermittent Use of Equipment	0.8	(0.7 To 1.0)		0.8
8	Total Connected Load on Diesel Generator Set											Starting Condition			Running Condition
9	Sr.No	Equipment	Load Type	Supply	Qty	Load		Starting P.F	Running P.F	Diversity Factor	Motor Starter	Starting Amp	Starting Kva	Starting Kw	Full Load Kva	Full Load Kw	Full Load Amp
10	Sr.No	Equipment	Load Type	Supply	Qty	Load	Kw/Hp	Starting P.F	Running P.F	Diversity Factor	Motor Starter	Starting Amp	Starting Kva	Starting Kw	Full Load Kva	Full Load Kw	Full Load Amp	RESULTS
11		Tower Crain-E	Motor	3Ph	1	43	Kw	0.8	0.8	0.5	Y-D	150	108	86	27	22	37	Starting Kva	296				Linear	Dol	1Ph
12		Tower Crain-C	Motor	3Ph	1	43	Kw	0.8	0.8	0.5	Y-D	150	108	86	27	22	37	Starting Kw	237				Non-Linear	Y-D	3Ph
13		Tower Crain-C	Motor	3Ph	1	43	Kw	0.8	0.8	0.5	Auto.Tra.	112	81	65	27	22	37	Starting Amp	411				Motor	Auto.Tra.
14												0	0	0	0	0	0	Running Kva	81				Kw	Soft.
15												0	0	0	0	0	0	Running Kw	65				Hp	Freq.Conv
16												0	0	0	0	0	0	Running Amp	112
17												0	0	0	0	0	0	Alternator Details
18												0	0	0	0	0	0	Voltage (P-N)	230
19												0	0	0	0	0	0	Efficiency	80%
20												0	0	0	0	0	0	Engine Overload Capacity	130%	(Appro 130% To 150%)
21												0	0	0	0	0	0
22												0	0	0	0	0	0	Required Generator Rating
23												0	0	0	0	0	0	Generator KVA	237	(Select D.G near This Value)
24												0	0	0	0	0	0	Engine KW	67
25												0	0	0	0	0	0								66
26												0	0	0	0	0	0								150
27												0	0	0	0	0	0	Calculate D.G Set Efficiency & Unit Rate of Power			Calculate Approximate Fuel Consumption				1.5
28												0	0	0	0	0	0	Calculate D.G Set Efficiency & Unit Rate of Power			Calculate Approximate Fuel Consumption				99
29												0	0	0	0	0	0	D.G Size ( Kva )	1000
30												0	0	0	0	0	0	D.G P.F	1		D.G Size (Kva)	115
31												0	0	0	0	0	0	D.G Running Hours	20		D.G P.F	0.8
32												0	0	0	0	0	0	Diesel Consumption (Liter)	1000		D.G Operation	Full Load
33												0	0	0	0	0	0	KWH Reading of Meter	10000
34												0	0	0	0	0	0	M.F of KWH Meter	1		Required Diesel
35												0	0	0	0	0	0	Diesel Rate /Liter (Rs)	40		Liter/Hour	23.11
36												0	0	0	0	0	0	Efficiency of D.G	63%
37												0	0	0	0	0	0	KWH/Liter (Unit Per Liter)	10
38												0	0	0	0	0	0	Unit Rate of Power (Rs)	4.0
39												0	0	0	0	0	0
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62							future
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100