## Electrical load calculation and energy consumption

**This MS Excel spreadsheet calculates the 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

Software: | Calculate electrical load and energy consumption of panel |

Version: | 22.8.2012 |

Developer: | Jignesh Parmar |

Size: | 210 Kb |

Price: | Free |

Download: | Right here | Get Download Updates | Get Technical articles |

pravesh

There is some mis formulation on sheet in Ampere of Y phase and B phase is same

Please verify it and correct it

Thanks

Roomi

Without password, It is not of much use for me. Can anybody tell what is the protected sheet password of this sheet.

pravesh

In this sheet updated sheet there is minor mistake in B phase & Y phase calculation. If you enter load on Y phase automatically it will increase in B phase also . So please check it and correct if I am right than.

Mohammed Obeid

This spread sheet is protected – does anyone know what the password is.

Pablo Buenconsejo

Great reference and time saver tool when performing such tedious tasks! Test and sample a calculation, use with caution.

aurelio gumasing

You are kindly requested to check your definition of diversity factor. In electrical engineering there is no diversity factor less than one but you use 0.80. This will totally affect your whole computation. if you find any diversity less than one please email me where you got it.

Inns

Just noted the reference in the comments made to diversity factor: the article and associated spreadsheet is correct in using a diversity factor of 0.8 (diversity of 1 (unity) is possible in theory). If the case that a diversity factor was never less than 1 than there would be no need to ever apply a diversity factor!

Satbir Singh

Hi These spreadsheet looks really great help to electrical engineers. I am able to see them on ipad but could not download on laptop. Can anyone suggest how to do it on laptop.

Samuel A

Great site. Thank you for your willingness to share what you have and saving our time in reinventing the wheel.

Preethy Nalluri

This is preethy.Can you please help me in providing formulas for the below.

Suppose for 1HP feeder Amps is 2 & contactor is 7,OLR range is 2.2-3.2.

How can these valves be calculated by using formula.

EEP4JOE

It is great and handy calculator with one exception. That is when calculating the total monthly consumption, the number of hours per day is used twice in the calculation. Please see below for details.

Average Using/ Day (Hours) Average Using/ Month (Hours) No of Unit Consumed/Day No of Unit Consumed/Month

18 540 900 486000

10 300 350 105000

icarus51

EEP4JOE: Like you, I believe the formulas in Column “U” (# Units Consumed Per Month) are incorrect.

For example “U13” formula is “=P13*S13*R13”. The value in Cell “S13” is already calculated as a monthly value. Multiplying “S13” by “R13” results in “U13” multiplying the daily use twice.

Since the cells in Column “U” are protected, only the author can correct the problem..

MOHAN PATIL

good artical

shabadbs

i would like to receive eng technical articles

Edvard

Go ahead and subscribe for technical articles here:

http://eepurl.com/lmhNv

Kind regards!

ARUNSHARATH

Excellent. Will be very useful in load calculation.

Bala

VERY WELL DONE!

tharanath1981

Yes……….. This is a Great Site…….. I was looking for a site like this……… Thank you friends

Edvard

Yes it is! Thanks to mr. Jignesh Parmar!

lwnt

good program