(1) Cable Size _ Voltage Drop Calculation (1.8.23).xlsx

	A	B	C	D	H	I	J	M	N	P	Q	R
1
2		Cable Size & Voltage Drop Calculation						jignesh.parmar www.electricalnotes.wordpress.com jiguparmar@yahoo.com			1
3
4		:Input Data Sheet:			:Calculation:			:Results:				FALSE
5
6
7		Electrical Load	35.00	Kw	Total Electrical Load	55.00	KW	(1) No of Parallel Run of Cable:	Not Proper	0
8		Motor Load	20.00	Kw	Total Electrical Load in KVA	64.71	KVA	(2) Cable Short Circuit Capacity:	Less	0	-79.43
9		Total Load	55.00	Kw	Total Full Load Curent	93.40	Amp	(3) Cable Voltage Drop:	Within Limit	1
10		Type of Supply System	Three Phase		Electrical Load Starting Current	59.43	Amp	(4) Selection of Cable Type:	Not Proper	0
11		System Voltage V(L-L)	400.00	Volt	Electrical Motor Starting Current	67.93	Amp	(5) Motor Starting Voltage Drop	Within Limit	1
12		System Voltage V(L-N)	231	Volt	Total Starting Current	127.36	Amp			1
13		Demand Factor	1.00		Starting CosØ	0.75		:Required Action for Proper Cable Selection:
14		Power Factor	0.85		Starting SinØ	0.66		√ Increase No of Run of Cable or Select Higher Capacity of Cable
15		Short circuit Current(If You Know)	80.00	K.Amp	Runing CosØ	0.85		√ Select Higher Capacity of Cable to meet S.C Level
16		Allowable voltage drop at Running	6,5%		Runing SinØ	0.53
17		Allowable voltage drop at Starting	7%		Cable Derating Factor:
18		Motor Lock Rotor Current (If You Know):		Amp	Cable Installation Media	Air
19		Motor Lock Rotor Current:	2.00	X Full Load Current	Air Temperature (K1)	0.98
20		Motor Starting Power Factor:	0.75		Group Correction Factor for Air (K2)	1.00
21		Cable Detail:						Cable Selection is Not Proper		FALSE
22		Type of Cable:	LT XLPE (Up to 1.1 KV)
23		Cable Conductor:	CU		Total Derating Factor	0.98
24		Size of Cable:	4cX4		Cable Calculation
25		No of Parallel Run of Cable	1	No's	Conductor Resistance.	3.69	Ohm / km
26		Cable Length (Distance)	20	Meter	Conductor Reactance	0.11	Mho/km	Motor starter is Proper		1
27		Cable Laying Method:			Cable Current Capacity	39	Amp
28		Cable Installation Media	Air	1	Derating Current	38	Amp
29		Air Temperature (K1)	35	°C	Min.Required No of Runs of Cable	2.44	Nos
30	Type	Cable Laying Arrangement	Trefoil		Voltage Drop Calculation:			Voltage Drop at Starting	3.5%
31		Distance Between each Cable	0.25 mt		Receving end Voltage	390	Volt	Voltage Drop at Running	2.6%
32		No's of Cable per Tray or Rack	1		Allowable voltage drop at Running	#VALUE!	Volt
33		No's of Tray or Rack	1		Allowable voltage drop at Starting	26.4	Volt
34			1.5		S.C Capacity of Selected Cable	0.572	K.Amp
35			Not Known		Voltage Drop at Starting	3.5%
36			Damp Soil		Voltage Drop at Running	2.6%
37
38
39		Formula For % Voltage Drop:=
40		(1.732 X (Full Load Current)X(RCosØ+j SinØ)XLengthX100) / Line VoltageXNo of RunX1000
41
42
43
44
45
46
47
48
49
50
51
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212