(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	5.00	Kw	Total Electrical Load	5.00	KW	(1) No of Parallel Run of Cable:	O.K	1
8		Motor Load	0.00	Kw	Total Electrical Load in KVA	5.00	KVA	(2) Cable Short Circuit Capacity:	Not Applicable	1	0.57
9		Total Load	5.00	Kw	Total Full Load Curent	20.83	Amp	(3) Cable Voltage Drop:	High	0
10		Type of Supply System	Single Phase		Electrical Load Starting Current	20.83	Amp	(4) Selection of Cable Type:	Not Proper	0
11		System Voltage V(L-N)	240.00	Volt	Electrical Motor Starting Current	0.00	Amp	(5) Motor Starting Voltage Drop	High	0
12		System Voltage V(L-N)	240	Volt	Total Starting Current	20.83	Amp			1
13		Demand Factor	1.00		Starting CosØ			:Required Action for Proper Cable Selection:
14		Power Factor	1.00		Starting SinØ	1.00
15		Short circuit Current(If You Know)		K.Amp	Runing CosØ	1.00
16		Allowable voltage drop at Running			Runing SinØ	0.00		√ Select Higher Size of Cable to reduce Voltage Drop
17		Allowable voltage drop at Starting			Cable Derating Factor:
18		Motor Lock Rotor Current (If You Know):		Amp	Cable Installation Media	Air		√ Select Other Type of Motor Starter
19		Motor Lock Rotor Current:		X Full Load Current	Air Temperature (K1)	0.98		√ Increase No's of Run of Cable to reduce Voltage Drop
20		Motor Starting Power Factor:			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)	50	Meter	Conductor Reactance	0.11	Mho/km	Motor Starter is not Proper		2
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	1.00	Nos
30	Type	Cable Laying Arrangement	Trefoil		Voltage Drop Calculation:			Voltage Drop at Starting	3.2%
31		Distance Between each Cable	0.25 mt		Receving end Voltage	232	Volt	Voltage Drop at Running	3.2%
32		No's of Cable per Tray or Rack	1		Allowable voltage drop at Running	0	Volt
33		No's of Tray or Rack	1		Allowable voltage drop at Starting	0	Volt
34			1.5		S.C Capacity of Selected Cable	0.572	K.Amp
35			Not Known		Voltage Drop at Starting	3.2%
36			Damp Soil		Voltage Drop at Running	3.2%
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