Cable Size _ Voltage Drop Calculation (1.1.19).xls

	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	4.00	Kw	Total Electrical Load	4.00	KW	(1) No of Parallel Run of Cable:	O.K	1
8		Motor Load	0.00	Kw	Total Electrical Load in KVA	5.33	KVA	(2) Cable Short Circuit Capacity:	Not Applicable	1	0.86
9		Total Load	4.00	Kw	Total Full Load Curent	7.42	Amp	(3) Cable Voltage Drop:	Within Limit	1
10		Type of Supply System	Three Phase		Electrical Load Starting Current	7.42	Amp	(4) Selection of Cable Type:	O.K	1
11		System Voltage V(L-L)	415.00	Volt	Electrical Motor Starting Current	0.00	Amp	(5) Motor Starting Voltage Drop	Within Limit	1
12		System Voltage V(L-N)	240	Volt	Total Starting Current	7.42	Amp			1
13		Demand Factor	1.00		Starting CosØ	0.75
14		Power Factor	0.75		Starting SinØ	0.66
15		Short circuit Current(If You Know)		K.Amp	Runing CosØ	0.75
16		Allowable voltage drop at Running	5%		Runing SinØ	0.66
17		Allowable voltage drop at Starting	10%		Cable Derating Factor:
18		Motor Lock Rotor Current (If You Know):		Amp	Cable Installation Media	Ground
19		Motor Lock Rotor Current:	2.00	X Full Load Current	Ground Temp. Correction Factor (K1)	0.89
20		Motor Starting Power Factor:	0.75		Group Factor for Ground (K4)	1.00
21		Cable Detail:			Cable Laying Depth Factor (K3)	0.96		Cable Selection is Proper		TRUE
22		Type of Cable:	LT XLPE (Up to 1.1 KV)		Soil Correction Factor for Air (K2)	1.05
23		Cable Conductor:	CU		Total Derating Factor	0.90
24		Size of Cable:	4cX 6		Cable Calculation
25		No of Parallel Run of Cable	1	No's	Conductor Resistance.	2.19	Ohm / km
26		Cable Length (Distance)	200	Meter	Conductor Reactance	0.1	Mho/km	Motor starter is Proper		1
27		Cable Laying Method:			Cable Current Capacity	55	Amp
28		Cable Installation Media	Ground	2	Derating Current	49	Amp
29		Ground Temperature (K2)	35	°C	Min.Required No of Runs of Cable	1.00	Nos
30	Type	Cable Laying Arrangement	Trefoil		Voltage Drop Calculation:
31		Distance Between each Cable	0.25 mt		Receving end Voltage	411	Volt
32		No's of Cable in Trench	1		Allowable voltage drop at Running	20.75	Volt
33			1		Allowable voltage drop at Starting	41.5	Volt
34		Cable Laying on The Depth of	1.5	Meter	S.C Capacity of Selected Cable	0.858	K.Amp
35		Soil Thermal Resistiivty	Not Known	Km/Watt	Voltage Drop at Starting	1.1%
36		Nature of Soil (k3)	Damp Soil		Voltage Drop at Running	1.1%
37
38		N.B: Enter Your Data in White Background Cell
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