Power Cable Calculations.xls

	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V
1
2	Power Cable Calculations					Cable type :		Copper/ PVC/ Armoured/ Twin or Multicore
3
4
5				Length	100	meters
6				Amperage	100	ampers
7				Temp.	45	°C				Cable to use			4 X	#VALUE!	mm²
8				Grouping	5	cables
9
10			0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0
16
17	Size of cable mm²		1.5	2.5	4	6	10	16	25	35	50	70	95	120	150	180	240	300	400	500	630
18	Current carring capacity		18	24	31	41	56	73	97	119	147	180	219	257	295	333	393	451	523	-	-
20	Daitals of volage drop
21	% of voltage drop		138.796358	88.82966911	53.29780147	34.97668221	21.09704641	12.76926493	8.882966911	6.107039751	4.497001999	3.164556962	2.331778814	1.887630469	1.610037753	1.332445037	1.110370864	0.9993337775	0.9438152343	0	0
22	Value of Vd for 3ϕ 4w		527	338	203	133	80	49	34	23	17	12	9	7	6	5	4	4	4	0	0
23	Value of Vd for 1ϕ 1w		305	195	117	77	46	28	19	13	10	7	5	4	4	3	2	2	2	0	0
24	Value of Vd for 1ϕ 2w		609	390	234	153	93	56	39	27	20	14	10	8	7	6	5	4	4	0	0
25	Correction factors
26	Temperature		30	35	40	45	50	55	60	65
27	factor		1	0.94	0.87	0.79	0.71	0.61	0.5	0.35						All data are according to IEE.
28	Grouping		1	2	3	4	5	7	10	-						Set by engineer Younis N. Jawad
29	factor		1	0.8	0.7	0.65	0.6	0.54	0.48	-							younisn@gmail.com
30
32
33
34
35
36
37
38
39
40
41
42
43	Copper/ PVC/ Non Armoured/ Single Core
44	size	1	1.5	2.5	4	6	10	16	25	35	50	70	95	120	150	180	240	300	400	500	630
45	current	16	20	26	36	45	61	81	106	130	160	200	240	280	320	365	430	500	610	710	820
46	voltage	37	24	15	9.2	6.2	3.7	2.3	1.5	1.1	0.82	0.59	0.45	0.38	0.34	0.3	0.27	0.25	0.24	0.23	0.22
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107