Premium Membership ♕

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

Calculate Electrical Load of Panelboard
Calculate Electrical Load of Panelboard

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.
  • Starting/Full Load/Continuous/Non Continuous Load
  • Size of Cables for Each Outgoing Feeder.
Software:Calculate Electrical Load of Panel
Version:22.8.2012 New
Developer:Jignesh Parmar
Size:181 Kb
Download:Right here | Video Courses | Membership | Download Updates
Calculate Electrical Load of Panelboard
Calculate Electrical Load of Panelboard

Premium Membership

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.

More Information


  1. Abdrabbi Bourezg
    Aug 17, 2023

    Dears All ,
    Would you please share the password
    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
    Could you please help

    • Abd Aziz
      Feb 24, 2022

      do you get the password?

    Feb 17, 2021

    can i get electrical CAD design software applications pls?

  5. Hassan
    Jan 20, 2021

    Not Working

  6. Luis Doradea
    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.

    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.

  24. mohammad.sadeque
    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

  26. juquie
    Jan 30, 2013

    Very good work

  27. Irsam
    Dec 04, 2011

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

  28. nchrista
    Jul 31, 2011

    Please email me a copy of that panel loading spreadsheet. It won’t allow me to download it. Just keeps asking me to login first.

    [email protected]

    • Edvard
      Aug 01, 2011

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


Leave a Comment

Tell us what you're thinking. We care about your opinion! Please keep in mind that comments are moderated and rel="nofollow" is in use. So, please do not use a spammy keyword or a domain as your name, or it will be deleted. Let's have a professional and meaningful conversation instead. Thanks for dropping by!

Enter Captcha Here :

Learn How to Design Power Systems

Learn to design LV/MV/HV power systems through professional video courses. Lifetime access. Enjoy learning!

Subscribe to Weekly Newsletter

Subscribe to our Weekly Digest newsletter and receive free updates on new technical articles, video courses and guides (PDF).
EEP Academy Courses - A hand crafted cutting-edge electrical engineering knowledge