Power Cable Calculations.xlsx

	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	20	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	1	0	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		27.7592716	17.76593382	10.65956029	6.995336442	4.219409283	2.553852987	1.776593382	1.22140795	0.8994003997	0.6329113924	0.4663557628	0.3775260937	0.3220075505	0.2664890073	0.2220741728	0.1998667555	0.1887630469	0	0
22	Value of Vd for 3ϕ 4w		105	68	41	27	16	10	7	5	3	2	2	1	1	1	1	1	1	0	0
23	Value of Vd for 1ϕ 1w		61	39	23	15	9	6	4	3	2	1	1	1	1	1	0	0	0	0	0
24	Value of Vd for 1ϕ 2w		122	78	47	31	19	11	8	5	4	3	2	2	1	1	1	1	1	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