2. Cable Size _ Voltage Drop Calculation.xlsx

	A	B	C	D	E	H	I	J	M	N	P	Q	R	V
1
2		Cable Size & Voltage Drop Calculation										1
3
4		Input Data Sheet				Calculation			Results				FALSE
5
6
7		Electrical Load	9.25	Kw		Total Electrical Load	9.25	KW	(1) No of Parallel Run of Cable:	Not Proper	0
8		Motor Load	0.00	Kw		Total Electrical Load in KVA	11.56	KVA	(2) Cable Short Circuit Capacity:	Not Applicable	1	0.86
9		Total Load	9.25	Kw		Total Full Load Curent	50.27	Amp	(3) Cable Voltage Drop:	High	0
10		Type of Supply System	Single Phase			Electrical Load Starting Current	50.27	Amp	(4) Selection of Cable Type:	Not Proper	0
11		System Voltage V(L-N)	230.00	Volt		Electrical Motor Starting Current	0.00	Amp	(5) Motor Starting Voltage Drop	High	0
12		System Voltage V(L-N)	230	Volt		Total Starting Current	50.27	Amp			1
13		Demand Factor	1.00			Starting CosØ	0.75		:Required Action for Proper Cable Selection:
14		Power Factor	0.80			Starting SinØ	0.66		=>Increase No of Run of Cable or Select Higher Capacity of Cable
15		Short circuit Current(If You Know)		K.Amp		Runing CosØ	0.80
16		Allowable voltage drop at Running	5%			Runing SinØ	0.60		=>Select Higher Size of Cable to reduce Voltage Drop
17		Allowable voltage drop at Starting	10%			Cable Derating Factor:
18		Motor Lock Rotor Current (If You Know):		Amp		Cable Installation Media	Ground		=>Select Other Type of Motor Starter
19		Motor Lock Rotor Current:	2.00	X Full Load Current		Ground Temp. Correction Factor (K1)	0.89		=>Increase No's of Run of Cable to reduce Voltage Drop
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 Not Proper		FALSE
22		Type of Cable:	LT PVC (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 not Proper		2
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.02	Nos
30	Type	Cable Laying Arrangement	Trefoil			Voltage Drop Calculation:
31		Distance Between each Cable	0.25 mt			Receving end Voltage	194	Volt
32		No's of Cable in Trench	1			Allowable voltage drop at Running	11.5	Volt
33			1			Allowable voltage drop at Starting	23	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	15.8%
36		Nature of Soil (k3)	Damp Soil			Voltage Drop at Running	15.8%
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
52
53
54			Single Phase
55			Three Phase
56			Air
57			Ground
58			Single Tire Horizontal
59			Multi Tire Horizontal
60			Trefoil
61			Air
62			Ground
63			Duct
64
65
66
67
68			PVC Flexible (Up to 1.1 KV)											Single Phase
69			LT PVC (Up to 1.1 KV)											Three Phase
70			LT XLPE (Up to 1.1 KV)
71			HT XLPE ( 6.6 KV-Earthed)
72			HT XLPE ( 11 KV-Earthed)
73			HT XLPE ( 11 KV-Un Earthed)
74			HT XLPE ( 66 KV-Earthed)
75
76			Air Temperature (K1)	0.98
77			Group Correction Factor for Air (K2)	1.00
78
79					1
80			Ground Temp. Correction Factor (K1)	0.89
81			Soil Correction Factor for Air (K2)	1.05
82			Cable Laying Depth Factor (K3)	0.96
83			Group Factor for Ground (K4)	1.00
84
85					1.00
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100