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:	OK	1
8		Motor Load	0.00	Kw		Total Electrical Load in KVA	12.33	KVA	(2) Cable Short Circuit Capacity:	Not Applicable	1	0.86
9		Total Load	9.25	Kw		Total Full Load Curent	17.16	Amp	(3) Cable Voltage Drop:	Within Limit	1
10		Type of Supply System	Three Phase			Electrical Load Starting Current	17.16	Amp	(4) Selection of Cable Type:	OK	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	17.16	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	405	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	2.4%
36		Nature of Soil (k3)	Damp Soil			Voltage Drop at Running	2.4%
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