Study specialized electrical engineering articles, papers & video courses in low/high voltage areas. Save 50% on all courses with the Enterprise Plan.

## Electrical load calculation of panelboard

This MS Excel spreadsheet has possibilities to calculate the following:

• Voltage / Voltage Difference of Each Phase
• Unbalanced Load in Neutral Wire.
• Expected Temperature rise in Each Phase.
• Load in Each Phase and Outgoing Feeders.
• Size of Cables for Each Outgoing Feeder.

1. mohamed rizwan
Jul 15, 2021

I am an electrical engineer , but I am working in lift related field , I don’t have such experience pure electrical side , I need to update my knowledge.

2. Khalid
Mar 20, 2021

This sheet is protected by a password

• Abd Aziz
Feb 24, 2022

3. DANIEL ZEBENE
Feb 17, 2021

can i get electrical CAD design software applications pls?

4. Hassan
Jan 20, 2021

Not Working

May 29, 2020

5000/(RAIZ(3) x 415) = 7 amp per phase.
It is not 2 amp per phase

6. Ashutosh Vyas
Apr 20, 2020

Dear Sir,
You people are doing tremendous job it is very helpful for practicing Engineers, I have just one quarry that in the sheet there is no option for 3.5 core cable.please help me how can i find the values when the cable used is of 3.5 core.

Regards
Ashutosh Vyas

7. Venkatesh M Gudagudi
Sep 03, 2019

Great efforts by you all guys, really making us to understand not only the electrical calculations & how its done but also the excel sheet usage & making us understand the subject.

Thanks Once again

8. Aymen Azeez
Sep 01, 2019

plz can you share to us an example for calculating

9. Julius Echemita
Sep 01, 2019

Many Thanks Edvard.

10. Nguyá»…n Ngá»Ťc ThĂąy
Feb 15, 2019

11. APAJ
Dec 07, 2018

12. Jonathan Aiken
Jul 05, 2018

The current calculations per phase for 3ph loads on this spreadsheet do not appear to be correct. E.g. Input 5kW 3 phase load into spreadsheet. Current per phase should be 7A however the current per phase given at the top of the spreadsheet in Load Details section is 2A. Please review.

• soof
Jul 06, 2018

It gives 7A. verify your other data

• Jonathan Aiken
Jul 10, 2018

Soof, The phase currents given under ‘Load Details on Main Panel’ and ‘Feeder Wise Electrical Load on Main Panel’ do not appear correct when using 3 phase loads. Again, with 5kW 3ph load, these sections show 2A per phase; by my reckoning this should be 7A per phase….or perhaps I’m missing something.