Learn from experienced engineers and study specialized technical articles, guides & courses. Save 50% on courses with the Enterprise Plan.

# Calculate electrical load of panelboard (Excel spreadsheet)

## 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.
 Software: Calculate Electrical Load of Panel Version: 22.8.2012 Developer: Jignesh Parmar Size: 181 Kb Price: Free Download: Right here | Video Courses | Membership | Download Updates

Get access to premium HV/MV/LV technical articles, advanced electrical engineering guides, papers, and much more! It will help you to shape up your technical skills in your everyday life as an electrical engineer.
50% Discount 💥 - Save 50% on all 90+ video courses with Enterprise Membership plan.

1. Abdrabbi Bourezg
Aug 17, 2023

Dears All ,
Best regards

2. 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.

3. Khalid
Mar 20, 2021

This sheet is protected by a password

• Abd Aziz
Feb 24, 2022

do you get the password?

4. DANIEL ZEBENE
Feb 17, 2021

can i get electrical CAD design software applications pls?

5. 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

7. 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

8. 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

9. Aymen Azeez
Sep 01, 2019

plz can you share to us an example for calculating

10. Julius Echemita
Sep 01, 2019

Many Thanks Edvard.

11. Nguyễn Ngọc Thùy
Feb 15, 2019

good for work but if copy add row then it conduce to wrong result. please help me. thank you

12. APAJ
Dec 07, 2018

this excel is password protected

• Mr Astra
Jun 14, 2022

I need the protected password for my job to comply the conditions by my own

13. 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.

14. Praveen Kumar Sharma
Jun 24, 2018

Plz share password for electrical panel load calculation

15. Anupama
May 04, 2017

One of the best site for all electrical engineers .Thank you for everything team :)

16. Rahul Hungwe
Feb 18, 2017

Sir, please explain the calculation method for doing calculation,
Spreadsheet will give direct result but to get it conceptually we must know exact calculation method

17. John B.
Nov 16, 2016

How do I unlock the spreadsheet?

18. anand
Oct 13, 2015

want to connect..send me link to get registered..

19. Thanh Canh
Aug 21, 2013

Excel shows this error when a formula or function “UnBalance Neutral Current”

20. paul.pate
Aug 20, 2013

I am having the same issue with the Panel spreadsheet. I get a webpage not available error.

21. engscientist
Aug 14, 2013

Edvard, keep up the good work. You have an amazing ability to make what seems to be very complex electrical engineering issues understandable even to a child. Great job!

22. makoy
May 07, 2013

This calculation is not applicable for TW, THW THWN/THHN insulated cables and the number sets per phase. But it is very useful for BS standard cables.

23. Arsalan786
Apr 12, 2013

You guys are doing really very great job, the big thing is that its all free for us, i am the design engineer and its really very help full for me, your excel spread sheets and software, i just want to know that can we relia 100% on the spread sheets of cables size/ voltage drop calculation, and again real thanks to all the team of this site and developers of softwares,

Note : I want lighting quantity spread sheet, if you have that sheet so please paste the link.

Mar 18, 2013

Thanks Edvard. This very helpful….

25. ARUN R
Feb 13, 2013

Really nice work and so help full. Keep going. Thank you for the admin and the team for this informative and educative site without aim any financial profit. i am new in this site and it is really help me a lot thank you admin

• Edvard
Feb 14, 2013

Thank you Arun!

26. juquie
Jan 30, 2013

Very good work
Congratulations

• Edvard
Feb 14, 2013

Thanks Juquie!

27. Irsam
Dec 04, 2011

Please email me the software for Calculate Electrical Load of Panel , i don’t have the login.
Thanks,

28. nchrista
Jul 31, 2011

[email protected]

• Edvard
Aug 01, 2011

There was some problems on EEP with certain IP addresses when logged in. Try downloading now.

BR,

### Subscribe to Weekly Newsletter

Subscribe to our Weekly Digest newsletter and receive free updates on new technical articles, video courses and guides (PDF).