This MS Excel spreadsheet calculate following
- Continuous and non-continuous electrical load of panel
- Total energy consumption (KWH) in daily/monthly of panel
- Size of MCB of each branch circuit of panel
- Voltage / Voltage difference of each phase
- Unbalanced load in neutral wire
- Expected temperature rise in each phase
- Load in each phase
- Starting / full load / continuous / non-continuous load
- Size / type / tripping setting of main MCCB
Download link: http://electrical-engineering-portal.com/res/Electrical-Load-Calculation-and-Energy-Consumption-22-8-12.xls