cable sizing & voltage drop calc (ACC TO BS code).xlsx

	A	B	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG	AH	AI	AJ	AK
1
2
3	SER NO.	FROM	TO	LOAD LOCATION	LOAD CABACITY			CIRCUIT BREAKER					DERATING FACTORS				Target Ampacity It	STARTER		CABLE DATA								CHECK PROTECTION CRITERIA		Cable length (m)	Total Cable length (m)	VD mV/A/m	Cable V.D		ACCUMULATIVE
4	SER NO.	FROM	TO	LOAD LOCATION	DEMAND LOAD (KVA)	(V)	Design Current Ib (A)	C.B RATING IC.B	C.B Poles	AF	I2	AT	K1	K2	K3	D.f	Target Ampacity It	TYPE	Ic (STARTING)	Cable Laying	Cable Ampacity CCC	NO.	NO of cables	C.S.A (mm²)	TOTAL NO OF CABLES	Insulation	Derated Cable Ampacity Iz	Iz >= ICB	I2 <= 1.45 IZ	Cable length (m)	Total Cable length (m)	VD mV/A/m	(V)	%	V.D %
5	LOW VOLTAGE POWER SUPPLAY
6	1	TRANSFORMER (TR-01)	MCC-PS	PUMPING STATION	289٫54	400	417٫93	800	4	800	502	502	0٫85	1٫0	0٫65	0٫6	756	FEEDER	756	in upvc conduit	764	0٫99	2	(1X630)	2(3*(1X630))+1X630	CU/XLPE/PVC	844٫22	SUCCESS	SUCCESS	68	136	0٫150	2٫131	0٫53	0٫53
7	2	GENERATOR (G-01)	MCC-PS	PUMPING STATION	289٫54	400	417٫93	800	4	800	502	502	0٫85	1٫0	0٫65	0٫6	756	FEEDER	756	in upvc conduit	764	0٫99	2	(1X630)	2(3*(1X630))+1X630	CU/XLPE/PVC	844٫22	SUCCESS	SUCCESS	49٫5	99	0٫150	1٫6	0٫39	0٫39
8	LOW VOLTAGE PANEL
9	3	MCC-PS	PUMP MOTOR-01 (DUTY)	PUMPING STATION	93٫75	400	135٫32	200	3	250	149	149	0٫91	1٫0	0٫75	0٫68	198	VFD	238	in trench	179	1٫33	2	(3X95)	2(3X95)+E(1X95)	CU/XLPE/PVC	244٫34	SUCCESS	SUCCESS	24٫75	49٫5	0٫43	0٫72	0٫18	0٫71
10	4		PUMP MOTOR-02 (DUTY)	PUMPING STATION	93٫75	400	135٫32	200	3	250	149	149	0٫91	1٫0	0٫75	0٫68	198	VFD	238	in trench	179	1٫33	2	(3X95)	2(3X95)+E(1X95)	CU/XLPE/PVC	244٫34	SUCCESS	SUCCESS	22٫55	45٫1	0٫43	0٫66	0٫16	0٫70
11	5		PUMP MOTOR-03 (STANDBY)	PUMPING STATION	93٫75	400	135٫32	200	3	250	149	149	0٫91	1٫0	0٫75	0٫68	198	VFD	238	in trench	179	1٫33	2	(3X95)	2(3X95)+E(1X95)	CU/XLPE/PVC	244٫34	SUCCESS	SUCCESS	20٫35	40٫7	0٫43	0٫59	0٫15	0٫68
12	6		MCC-MOV-PS	PUMPING STATION	26٫25	400	37٫89	50	4	100	42	42	0٫77	1٫0	1٫00	0٫77	49	-	49	in trench	62	0٫79	1	(4X16)	(4X16)+E(1X16)	CU/PVC/PVC	47٫74	FAILED	SUCCEED	6٫8	6٫8	2٫8	0٫72	0٫18	0٫71
13	7		LP-PS	PUMPING STATION	24٫98	400	36٫06	50	4	100	40	40	0٫77	1٫0	1٫00	0٫77	47	-	47	in trench	62	0٫76	1	(4X16)	(4X16)+E(1X16)	CU/PVC/PVC	47٫74	FAILED	SUCCEED	7٫5	7٫5	2٫8	0٫76	0٫19	0٫72
14	8		PLC-PS	PUMPING STATION	5٫00	400	7٫22	30	4	100	8	8	0٫77	1٫0	1٫00	0٫77	9	-	9	in trench	34	0٫28	1	(4X6)	(4X6))+E(1X6)	CU/PVC/PVC	26٫18	FAILED	SUCCEED	10٫0	10٫0	7٫3	0٫53	0٫13	0٫66
15	9		PCP-CRN	PUMPING STATION	2٫50	400	3٫61	30	3	100	4	4	0٫77	1٫0	1٫00	0٫77	5	-	5	in trench	34	0٫14	1	(4X6)	(4X6))+E(1X6)	CU/PVC/PVC	26٫18	FAILED	SUCCEED	17٫5	17٫5	7٫3	0٫46	0٫12	0٫65
16	10		DP-CL	CHLORINATION BUILDING	18٫30	400	26٫41	50	4	100	29	29	0٫77	1٫0	0٫65	0٫50	53	-	53	in upvc conduit	62	0٫85	1	(4X16)	(4X16))+E(1X16)	CU/PVC/PVC	31٫03	FAILED	SUCCEED	87٫5	87٫5	2٫8	6٫47	1٫62	2٫15
17	11		LP-TK	TICKETING BUILDING	10٫03	400	14٫48	40	4	100	16	16	0٫77	1٫0	0٫41	0٫32	46	-	46	in upvc conduit	46	1٫00	1	(4X10)	(4X10)+E(1X10)	CU/PVC/PVC	14٫52	FAILED	SUCCEED	129٫5	129٫5	4٫4	8٫25	2٫06	2٫60
18	12		LP-SC	SEC ROOM	1٫65	400	2٫38	30	4	100	3	3	0٫77	1٫0	0٫65	0٫50	5	-	5	in upvc conduit	34	0٫14	1	(4X6)	(4X6))+E(1X6)	CU/PVC/PVC	17٫02	FAILED	SUCCEED	71٫25	71٫25	7٫3	0٫86	0٫21	0٫75
19	13		LP-GH	GUARD HOUSE	9٫28	400	13٫39	40	4	100	15	15	0٫77	1٫0	0٫65	0٫50	27	-	27	in upvc conduit	46	0٫58	1	(4X10)	(4X10)+E(1X10)	CU/PVC/PVC	23٫02	FAILED	SUCCEED	82٫0	82٫0	4٫4	4٫83	1٫21	1٫74
20	14		LP-ET	ELEVATED TANK	1٫02	400	1٫47	30	3	100	2	2	0٫77	1٫0	0٫41	0٫32	5	-	5	in upvc conduit	34	0٫14	1	(4X6)	(4X6))+E(1X6)	CU/PVC/PVC	10٫73	FAILED	SUCCEED	73٫5	73٫5	7٫3	0٫79	0٫20	0٫73
21	15		CATHODIC PROTECTION TANK (01)	STEEL TANK	5٫00	400	7٫22	30	4	100	8	8	0٫77	1٫0	0٫41	0٫32	23	-	23	in upvc conduit	34	0٫67	1	(4X6)	(4X6))+E(1X6)	CU/PVC/PVC	10٫73	FAILED	SUCCEED	28٫5	28٫5	7٫3	1٫50	0٫38	0٫91
22	16		CATHODIC PROTECTION TANK (02)	STEEL TANK	5٫00	400	7٫22	30	4	100	8	8	0٫77	1٫0	0٫41	0٫32	23	-	23	in upvc conduit	34	0٫67	1	(4X6)	(4X6))+E(1X6)	CU/PVC/PVC	10٫73	FAILED	SUCCEED	117٫0	117٫0	7٫3	6٫16	1٫54	2٫07
23	17		LP-OL1	OUTDOOR LIGHTING	1٫45	400	2٫09	30	4	100	2	2	0٫77	1٫0	0٫65	0٫50	4	-	4	in upvc conduit	34	0٫12	1	(4X6)	(4X6))+E(1X6)	CU/PVC/PVC	17٫02	FAILED	SUCCEED	82٫0	82٫0	7٫3	1٫25	0٫31	0٫85
24	18		LP-OL2	OUTDOOR LIGHTING	1٫55	400	2٫24	30	4	100	2	2	0٫77	1٫0	0٫41	0٫32	7	-	7	in upvc conduit	46	0٫15	1	(4X10)	(4X10)+E(1X10)	CU/PVC/PVC	14٫52	FAILED	SUCCEED	130٫0	130٫0	4٫4	1٫28	0٫32	0٫85
25
26	CABLES DERATING FACTORS
27
28		K1	Ground (or air) temperature derating factor (at 40°c)
29		K2	Depth of laying mt. (at 0.8 m)
30		K3	Reduction factors for more than one circuit,cables laid in ducts in the ground/in floor
31		D.F=	K1K2K3
32	Notes
33
34
35	1	Design Current (Ib) =
36	2	AMPERE FRAME STANDERD VALUES (AF) =		100 - 160 - 250 - 400 - 630 - 1000 - 1250 - 1600 - 2000 - 2500 - 3200 - 4000 - 5000 - 6300 A according to IEC Code
37	3	Max Thermal Current (I2) =		1.2 Ib for feeders , 1.1 Ib for branches , min value = 1.05 Ib
38	4	Ampere Trip (AT) =		I2
39	5	Target Ampacity (It) =		Ib / D.F
40	6	Ic (starting) =		It / starting factor , (for VFD) starting factor = (1.2 : 1.5) * It
41	7	Derated Cable Ampacity (Iz) =		no of cables × Cable Ampacity (CCC) × Derating Factor (D.F)
42	8	Accumulative Voltage Drop % =
43
44
45
46
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