
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 ![]() |
Developer: | Jignesh Parmar |
Size: | 181 Kb |
Price: | Free |
Download: | Right here | Video Courses | Membership | Download Updates |

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.
This sheet is protected by a password
Could you please help
do you get the password?
can i get electrical CAD design software applications pls?
Not Working
5000/(RAIZ(3) x 415) = 7 amp per phase.
It is not 2 amp per phase
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
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
plz can you share to us an example for calculating
Many Thanks Edvard.
good for work but if copy add row then it conduce to wrong result. please help me. thank you
this excel is password protected
I need the protected password for my job to comply the conditions by my own
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.
It gives 7A. verify your other data
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.