Lighting-Lumen-Calculation-22-8-12.xlsx

	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	Y	Z	AA	AB	AC	AD	AQ	AR	AS	AT	AV	AW	AY
1
2											Jignesh.Parmar www.electricalnotes.wordpress.com jiguparmar@yahoo.com
3							Total Lumens Output		17285.71
4							Total Required No of Fittings		6																			0	0	0
5																											0	0.5	0	0	4	8	200
6	Room Ref.	Room Data			Fittings height from Ground Floor(mt)	Required Lux	Lamps per Fitting	Wattage of Each Lamp	Total Wattage of Fitting	Lumens per Fitting	Lumens Output	Required No.of Fittings.	Select No of Fitting along with Length	Nos of Fitting along with Width	Space Height Ration for Length	Space Height Ration for width	Selection of Fitting along with Length and Width										0.5	0.6	0.63	0.53	8	13	950
7	Room Ref.	Length (mt)	Width (mt)	Height (mt)	Fittings height from Ground Floor(mt)	Required Lux	Lamps per Fitting	Wattage of Each Lamp	Total Wattage of Fitting	Lumens per Fitting	Lumens Output	Required No.of Fittings.	Select No of Fitting along with Length	Nos of Fitting along with Width	Space Height Ration for Length	Space Height Ration for width	Selection of Fitting along with Length and Width				Area	Area x lux	M.F	U.F	M.FxU.F	No.Fitt.	0.6	0.7	0.64	0.54	13	15	1200
8

9	Room-1	22	2.2	2.8	2.8	200	2	18	36	3000	17285.71	6	1	5	0.36	1.79	O.K	0	0	0	48.4	9680	0.8	0.7	0.56	5.761904762	0.7	0.8	0.65	0.55	15	18	1300
10									0	0		0		0				1	1	0	0	0	0	0	0		0.8	0.9	0.66	0.56	18	26	1500
11									0	0		0		0				1	1	0	0	0	0	0	0		0.9	1	0.67	0.57	26	30	2000
12									0	0		0		0				1	1	0	0	0	0	0	0		1	1.1	0.68	0.58	30	40	2650
13									0	0		0		0				1	1	0	0	0	0	0	0		1.1	1.2	0.69	0.59	40	50	3000
14									0	0		0		0				1	1	0	0	0	0	0	0		1.2	1.3	0.7	0.6	50	60	4800
15									0	0		0		0				1	1	0	0	0	0	0	0		1.3	1.4	0.71	0.61	60	70	5000
16									0	0		0		0				1	1	0	0	0	0	0	0		1.4	1.5	0.72	0.62	70	80	5800
17									0	0		0		0				1	1	0	0	0	0	0	0		1.5	1.6	0.73	0.63	80	90	7350
18									0	0		0		0				1	1	0	0	0	0	0	0		1.6	1.7	0.74	0.64	90	100	8000
19									0	0		0		0				1	1	0	0	0	0	0	0		1.7	1.8	0.75	0.65	100	110	8600
20									0	0		0		0				1	1	0	0	0	0	0	0		1.8	1.9	0.76	0.66	110	120	9500
21									0	0		0		0				1	1	0	0	0	0	0	0		1.9	2	0.77	0.67	120	130	1100
22									0	0		0		0				1	1	0	0	0	0	0	0		2	2.1	0.78	0.68	130	140	1200
23									0	0		0		0				1	1	0	0	0	0	0	0		2.1	2.2	0.79	0.69	140	150	1400
24									0	0		0		0				1	1	0	0	0	0	0	0		2.2	2.3	0.8	0.7
25									0	0		0		0				1	1	0	0	0	0	0	0		2.3	2.4	0.81	0.71
26									0	0		0		0				1	1	0	0	0	0	0	0		2.4	2.5	0.82	0.72
27									0	0		0		0				1	1	0	0	0	0	0	0		2.5	2.6	0.83	0.73
28									0	0		0		0				1	1	0	0	0	0	0	0		2.6	2.7	0.82	0.72
29									0	0		0		0				1	1	0	0	0	0	0	0		2.7	2.8	0.81	0.71
30									0	0		0		0				1	1	0	0	0	0	0	0		2.8	2.9	0.8	0.7
31									0	0		0		0				1	1	0	0	0	0	0	0		2.9	3	0.79	0.69
32									0	0		0		0				1	1	0	0	0	0	0	0		3	3.1	0.78	0.68
33									0	0		0		0				1	1	0	0	0	0	0	0		3.1	3.2	0.77	0.67
34									0	0		0		0				1	1	0	0	0	0	0	0		3.2	3.3	0.76	0.66
35									0	0		0		0				1	1	0	0	0	0	0	0		3.3	3.4	0.75	0.65
36									0	0		0		0				1	1	0	0	0	0	0	0		3.4	3.5	0.74	0.64
37									0	0		0		0				1	1	0	0	0	0	0	0		3.5	3.6	0.73	0.63
38									0	0		0		0				1	1	0	0	0	0	0	0		3.6	3.7	0.72	0.62
39									0	0		0		0				1	1	0	0	0	0	0	0		3.7	3.8	0.71	0.61
40									0	0		0		0				1	1	0	0	0	0	0	0		3.8	3.9	0.7	0.6
41									0	0		0		0				1	1	0	0	0	0	0	0		3.9	4	0.69	0.59
42									0	0		0		0				1	1	0	0	0	0	0	0		4	4.1	0.68	0.58
43									0	0		0		0				1	1	0	0	0	0	0	0		4.1	4.2	0.67	0.57
44									0	0		0		0				1	1	0	0	0	0	0	0		4.2	4.3	0.66	0.56
45									0	0		0		0				1	1	0	0	0	0	0	0		4.3	4.4	0.65	0.55
46									0	0		0		0				1	1	0	0	0	0	0	0		4.4	4.5	0.64	0.54
47									0	0		0		0				1	1	0	0	0	0	0	0		4.5	4.6	0.63	0.53
48									0	0		0		0				1	1	0	0	0	0	0	0		4.6	4.7	0.62	0.52
49									0	0		0		0				1	1	0	0	0	0	0	0		4.7	4.8	0.61	0.51
50																											4.8	4.9	0.6	0.5
51	Total Lumens Output		17285.71																								4.9	5	0.59	0.49
52	Total Required No of Fittings		6																								5	5.1	0.58	0.48
53																											5.1	5.2	0.57	0.47
54																											5.2	5.3	0.56	0.46
55																											5.3	5.4	0.55	0.45
56																											5.4	5.5	0.54	0.44
57																											5.5	5.6	0.53	0.43
58																											5.6	5.7	0.52	0.42
59																											5.7	5.8	0.51	0.41
60																											5.8	5.9	0.5	0.4
61	Formula:																										5.9	6	0.49	0.39
62	Lumens Output = Lux(Required) x Area / M.F x U.F																										6	6.1	0.48	0.38
63																											6.1	6.2	0.47	0.37
64	Where																										6.2	6.3	0.46	0.36
65	M.F =	Maintenance Factor																									6.3	6.4	0.45	0.35
66	U.F =	Utilisation Factor																									6.4	6.5	0.44	0.34
67	R.I =	Area x (Length x Breadth) / Height x (Length + Breadth)																									6.5	6.6	0.43	0.33
68																											6.6	6.7	0.42	0.32
69																											6.7	6.8	0.41	0.31
70																											6.8	6.9	0.4	0.3
71																											6.9	7	0.39	0.29
72																											7	7.1	0.38	0.28
73																											7.1	7.2	0.37	0.27
74																											7.2	7.3	0.36	0.26
75																											7.3	7.4	0.35	0.25
76																											7.4	7.5	0.34	0.24
77																											7.5	7.6	0.33	0.23
78																											7.6	7.7	0.32	0.22
79																											7.7	7.8	0.31	0.21
80																											7.8	7.9	0.3	0.2
81																											7.9	8	0.29	0.19
82																											8	8.1	0.28	0.18
83																											8.1	8.2	0.27	0.17
84																											8.2	8.3	0.26	0.16
85																											8.3	8.4	0.25	0.15
86																											8.4	8.5	0.24	0.14
87																											8.5	8.6	0.23	0.13
88																											8.6	8.7	0.22	0.12
89																											8.7	8.8	0.21	0.11
90																											8.8	8.9	0.2	0.1
91																											8.9	9	0.19	0.09
92																											9	9.1	0.18	0.08
93																											9.1	9.2	0.17	0.07
94																											9.2	9.3	0.16	0.06
95																											9.3	9.4	0.15	0.05
96																											9.4	9.5	0.14	0.04
97																											9.5	9.6	0.13	0.03
98																											9.6	9.7	0.12	0.02
99																											9.7	9.8	0.11	0.01
100