Premium Membership

Learn about power engineering and HV/MV/LV substations. Study specialized technical articles, electrical guides, and papers.

Home / Download Center / Electrical Software Reviews / Calculate electrical load of panelboard (Excel spreadsheet)
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.
More Information


  1. Luis Doradea
    May 29, 2020

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

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

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

  4. Aymen Azeez
    Sep 01, 2019

    plz can you share to us an example for calculating

  5. Julius Echemita
    Sep 01, 2019

    Many Thanks Edvard.

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

  7. APAJ
    Dec 07, 2018

    this excel is password protected

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

  9. Praveen Kumar Sharma
    Jun 24, 2018

    Plz share password for electrical panel load calculation

  10. Anupama
    May 04, 2017

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

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

  12. John B.
    Nov 16, 2016

    How do I unlock the spreadsheet?

  13. anand
    Oct 13, 2015

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

  14. Thanh Canh
    Aug 21, 2013

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

  15. paul.pate
    Aug 20, 2013

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

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

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

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

  19. mohammad.sadeque
    Mar 18, 2013

    Thanks Edvard. This very helpful….

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

  21. juquie
    Jan 30, 2013

    Very good work

  22. Irsam
    Dec 04, 2011

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

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

EEP Academy Video Courses

The learning platform for LV/MV/HV electrical engineers. Learn from experienced engineers and sharpen up your knowledge.
Schneider Electric - Coming back stronger together!