Monday, January 21, 2019

Electrical Panel Load Calculations Excel Sheet




An electrical panel is also called a load center. It is a metal electrical service box that accepts the main power to the home and distributes electrical current to the various circuits within the home.


The distribution of power to the various circuits are protected from over-current by the use of circuit breakers or fuses.
Once you open the door to the panel you can access all the circuit breakers or fuses. Usually one of these panels feeds all the circuits in the home but there may be a situation where there is another "sub-panel" serving a dedicated area like a new kitchen.

Circuit Breakers :-
You will find the circuit breakers stacked in the panel and controlled with a lever that places it in the "On" or "Off" position. You will also see a double pole circuit breaker at the top of the panel called the "Main". That breaker controls all the power to panel in the circuit breakers. The main breaker is used to power all the circuits on or off at one time. At the main circuit breaker you can also see the amperage capacity of the electrical panel. The main breaker will have a number on it identifying its ampere capacity, for example, "100" or "150". Today, 100 amp service is the minimum allowed by code in residential construction so 150 amp is very common. Electrical panels also come in 200 amp and 400 amp configurations.

Identifying a Circuit :-
To identify a circuit you should find stickers placed next to each breaker or a sheet adhered to the inside of the panel door that identifies the circuit served by a particular fuse or circuit breaker.

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.
How to Use This Excel Sheet :-


SYSTEM DETAILS :
1 Enter Your System Details 



MAIN PANEL DETAILS :
1 Enter Your Main Panel Capacity and Size of Incoming Cable of Main Panel
2 Enter Outgoing Circuit Capacity of Main Panel
ELECTRICAL LOAD DETAILS OF MAIN PANEL
1 Enter connected Electrical Load in KW or HP
2 Select Your Electrical Circuit
3 Select Your Electrical Circuit's Phase (3 Phase or 1 Phase)
4 Enter P.F
5 Select Cable installation media (Ground/Air)
6 Enter Appropriate Details for Air or Ground Media
7 Enter Allowable Voltage Drop for that Circuit
8 Enter Total Length of that Circuit
9 Select Type of Cable







Download Drive-1



















You May Also like These E-Books:-






5 comments:

  1. We apply new technology on the ground and doing well, providing Best Electrical Services DeSoto in a big manner and always provide premium support.

    ReplyDelete
  2. Dear Rizwan,
    Thank for the Electrical Panel Load Calculation guide.
    But the excel file download links seems to be broken
    Can you please check & update the links

    ReplyDelete
  3. I want to share with you all here on how I get my loan from Mr Benjamin who help me with loan of 400,000.00 Euro to improve my business, It was easy and swift when i apply for the loan when things was getting rough with my business Mr Benjamin grant me loan without delay. here is Mr Benjamin email/whatsapp contact: +1 989-394-3740, 247officedept@gmail.com / 

    ReplyDelete
  4. it seems very valuable for engineers specially for optomization and audits kindly share it with us

    ReplyDelete