Elec-Load-Calc-and-Energy-Consump.xlsx

	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	AD	AE	AF	AG	AH	AI	AJ	AK	AL	AM	AO	AP
1		Date	6-Feb-26														410
2				ELECTRICAL PANEL DETAIL													Approximate Energy Consumption
3	Jignesh Parmar www.electricalnotes.wordpress.com jiguparmar@yahoo.com								Load On R Phase :			462	Amp	Voltage (Pahse-Neutral)		230	Initial Reading of Meter (KWH)			345
4				Total KW		85		Kw	Load On Y Phase :			0	Amp	Voltage (R-Y)		348	Last Reading of Meter (KWH)			500
5				Total KVA		106		Kva	Load On B Phase :			0	Amp	Voltage (Y-B)		378	Meter Multiplying Factor			1
6				Total Load		577		Amp	Starting Current :			1005	Amp	Voltage (R-B)		410	Actual Energy Consumption KWH			155
7		Enter Your Detail in		MCCB Size		600		Amp	Full Load Current :			462	Amp	Voltage Difference(%)		8	Appro.Total KWH (Daily)			1250
8		White Background Cells		Type		C Type			Continious Load			462	Amp	UnBalance Neutral(Amp)		1005	Appro.Total KWH (Monthly)			591000								577.45
9				Tripping		5774		Amp	Non Continious Load			0	Amp	Expected Temp Rise in Phase(°C)		17	Appro. KWH (Weekly) Average.			147750
10
11		Equipment Details										Electrical Load Detail					Energy Consumption Detail				C.B Detail			462	0	0	0	462	0
12	Sr. No	Application	1Ph 3Ph	Load on Phase	Unit Power (Kw)	P.f	Qty	Type of Load	Demand Factor	Motor Starter	Use	Absorb ( Kva )	Full Load Current (Amp)	Starting Current (Amp)	Estimated Power (KW)	Estimated Power (Kva)	Average Using/ Day (Hours)	Average Using/ Month (Hours)	No of Unit Consumed/Day	No of Unit Consumed/Month	Size of MCB	Type of MCB	Tripping (Amp)	R	Y	B	3	Con	Non		2	NEC	Trip

13	1	Desai Construction	1	R	50	0.8	1	Motor	1	Y-D	Cont	63	272	815	50	63	18	540	900	486000	600	C Type	2717	272	0	0	0	272	0	C Type	2	340	2717	MCCB/ELCB
14	2	Cota Cabin	1	R	35	0.8	1	Ind.Load	1		Cont	44	190	190	35	44	10	300	350	105000	225	C Type	1902	190	0	0	0	190	0	C Type	2	238	1902	0.5	1
15			1	Y								0	0	0	0	0			0	0			0	0	0	0	0	0	0		0	0	0	1	2
16			3									0	0	0	0	0			0	0			0	0	0	0	0	0	0		0	0	0	2	4
17												0	0	0	0	0			0	0			0	0	0	0	0	0	0		0	0	0	4	6
18												0	0	0	0	0			0	0			0	0	0	0	0	0	0		0	0	0	6	10
19												0	0	0	0	0			0	0			0	0	0	0	0	0	0		0	0	0	10	16
20												0	0	0	0	0			0	0			0	0	0	0	0	0	0		0	0	0	16	20
21												0	0	0	0	0			0	0			0	0	0	0	0	0	0		0	0	0	20	32
22												0	0	0	0	0			0	0			0	0	0	0	0	0	0		0	0	0	32	45
23												0	0	0	0	0			0	0			0	0	0	0	0	0	0		0	0	0	45	50
24												0	0	0	0	0			0	0			0	0	0	0	0	0	0		0	0	0	50	63
25												0	0	0	0	0			0	0			0	0	0	0	0	0	0		0	0	0	63	80
26												0	0	0	0	0			0	0			0	0	0	0	0	0	0		0	0	0	80	100
27												0	0	0	0	0			0	0			0	0	0	0	0	0	0		0	0	0	100	225
28												0	0	0	0	0			0	0			0	0	0	0	0	0	0		0	0	0	225	600
29												0	0	0	0	0			0	0			0	0	0	0	0	0	0		0	0	0	600	800
30												0	0	0	0	0			0	0			0	0	0	0	0	0	0		0	0	0	800	1600
31												0	0	0	0	0			0	0			0	0	0	0	0	0	0		0	0	0	1600	2000
32												0	0	0	0	0			0	0			0	0	0	0	0	0	0		0	0	0	2000	3000
33												0	0	0	0	0			0	0			0	0	0	0	0	0	0		0	0	0	3000	3200
34												0	0	0	0	0			0	0			0	0	0	0	0	0	0		0	0	0	3200	4000
35												0	0	0	0	0			0	0			0	0	0	0	0	0	0		0	0	0	4000	5000
36												0	0	0	0	0			0	0			0	0	0	0	0	0	0		0	0	0	5000	6000
37												0	0	0	0	0			0	0			0	0	0	0	0	0	0		0	0	0	6000	6000
38												0	0	0	0	0			0	0			0	0	0	0	0	0	0		0	0	0
39												0	0	0	0	0			0	0			0	0	0	0	0	0	0		0	0	0
40												0	0	0	0	0			0	0			0	0	0	0	0	0	0		0	0	0
41												0	0	0	0	0			0	0			0	0	0	0	0	0	0		0	0	0
42												0	0	0	0	0			0	0			0	0	0	0	0	0	0		0	0	0
43												0	0	0	0	0			0	0			0	0	0	0	0	0	0		0	0	0
44												0	0	0	0	0			0	0			0	0	0	0	0	0	0		0	0	0
45												0	0	0	0	0			0	0			0	0	0	0	0	0	0		0	0	0
46												0	0	0	0	0			0	0			0	0	0	0	0	0	0		0	0	0
47												106	462	1005	85	106			1250	591000											0	462	9239
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