(39) Street Light Pole Voltage Drop Calculation (1.8.23).xlsx

	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S
1
2		Street Light Voltage Drop Calculator													Jignesh.Parmar www.electricalnotes.wordpress.com jiguparmar@yahoo.com
3
4	:Pole Detail:		:Current Detail:			:Summary:				:Voltage Drop Detail:
5	No of Poles on "R" Ph	4 Nos	Load on "R" Phase		12 Amp	Total Disatance		0.8	Km	Cable Voltage Drop		Permissible	Actual	Status
6	No of Poles on "Y" Ph	6 Nos	Load on "Y" Phase		18 Amp	Total Lighting Load		8	Watt	Voltage Drop in R Phase		6.0%	3.81%	O.K
7	No of Poles on "B" Ph	5 Nos	Load on "B" Phase		15 Amp	Total No of Pole		16	Nos	Voltage Drop in Y Phase		6.0%	5.27%	O.K
8	Total No of Poles	16 Nos				Total No of Luminar		32	Nos	Voltage Drop in B Phase		6.0%	5.38%	O.K
9
10
11	Street Light Pole Cable Route		System Detail		Voltage Distribution at each Pole			Pole Detail		Luminar / Fixture Details				Total Distance (Meter)	Cable Detail			Voltage Drop
12	Pole (From)	Pole (To)	System Voltage (P-P)	System Voltage (L-N)	Phase for Pole	Select Phase for Luminar	P.F	No of Pole	Pole Distance (Meter)	Each Luminar (Watt)	No of Luminar/Pole	Total Watt	Amp	Total Distance (Meter)	No of Cable Run	Rsistance (Ω/Km)	Reactance (Ω/Km)	Voltage Drop

13	A	B	415	230	1Ph	R	0.75	1	50	250	2	500	2.9	50.0	1	2.29	0.097	0.11%
14	B	C	415	230	1Ph	Y	0.75	1	50	250	2	500	2.9	100.0	1	2.29	0.097	0.22%
15	C	D	415	230	1Ph	B	0.75	1	50	250	2	500	2.9	150.0	1	2.29	0.097	0.34%
16	D	E	415	230	1Ph	Y	0.75	1	50	250	2	500	2.9	200.0	1	2.29	0.097	0.45%
17	E	F	415	230	1Ph	Y	0.75	1	50	250	2	500	2.9	250.0	1	2.29	0.097	0.56%
18	F	G	415	230	1Ph	B	0.75	1	50	250	2	500	2.9	300.0	1	2.29	0.097	0.67%
19	G	H	415	230	1Ph	R	0.75	1	50	250	2	500	2.9	350.0	1	2.29	0.097	0.79%
20	H	I	415	230	1Ph	Y	0.75	1	50	250	2	500	2.9	400.0	1	2.29	0.097	0.90%
21	I	J	415	230	1Ph	B	0.75	1	50	250	2	500	2.9	450.0	1	2.29	0.097	1.01%
22	J	K	415	230	1Ph	R	0.75	1	50	250	2	500	2.9	500.0	1	2.29	0.097	1.12%
23	K	L	415	230	1Ph	Y	0.75	1	50	250	2	500	2.9	550.0	1	2.29	0.097	1.23%
24	L	M	415	230	1Ph	B	0.75	1	50	250	2	500	2.9	600.0	1	2.29	0.097	1.35%
25	M	N	415	230	1Ph	R	0.75	1	50	250	2	500	2.9	650.0	1	2.29	0.097	1.46%
26	N	O	415	230	1Ph	Y	0.75	1	50	250	2	500	2.9	700.0	1	2.29	0.097	1.57%
27	O	P	415	230	1Ph	B	0.75	1	50	250	2	500	2.9	750.0	1	2.29	0.097	1.68%
28	P	Q	415	230	3Ph	-	0.75	1	50	250	2	500	0.9	800.0	1	2.29	0.097	1.00%
29	Q
30
31
32
33
34
35
36
37
38
39
40
41
42
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