Search

Premium Membership ♕

Limited Time Offer: Save 15% on PRO Plan with discount code: LRN15 and study specialized LV/MV/HV technical articles and studies.

Home / Download Center / Electrical Software and MS Excel Spreadsheets (Calculations of cables, voltage drop etc.) / Calculation of Electrical Load and Energy Consumption Of Panel
Calculation of Electrical Load and Panel Energy Consumption
Calculation of Electrical Load and Panel Energy Consumption

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 New
Developer:Jignesh Parmar
Size:210 Kb
Price:Free
Download:Right here | Video Courses | Membership | Download Updates
Calculation Of Electrical Load and Energy Consumption of Panel
Calculation Of Electrical Load and Energy Consumption of Panel

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.
50% Discount 💥 - Save 50% on all 90+ video courses with Enterprise Membership plan.

More Information

26 Comments


  1. Shevon Fernando
    May 30, 2022

    Please keep me updated. So help full


  2. fgomes000
    Jul 15, 2021

    Good day,
    I have bought your software Electrical Panel Load & Energy Consumption but i would like to purchase the editable version of the Electrical Load Calculation for Panel.
    I need to edit more line since i using the software for a residential electrical design. How can i get hold of it?
    Your Prompt Reply would be greatly appreciated.
    Regards,


  3. Kiran Kumar K,C,
    Mar 23, 2021

    Dear,
    Please provide the load calculation sheet for the residence and housing sector


  4. edwin
    Oct 13, 2020

    hello, Jignesh!
    i find the same error that other people find previous me, Y and B in the amp calculation is wrong. can you send me the password for fix this?


  5. sausageman
    Jul 10, 2019

    when i saw this my left leg fell off, causing me to fall into a puddle and sprain my wrist, now i cannot eat a biscuit while drinking tea, im not impressed and will continue to use old formulas so i can enjoy tea and biscuits


  6. pravesh
    Feb 02, 2018

    There is some mis formulation on sheet in Ampere of Y phase and B phase is same
    Please verify it and correct it

    Thanks


  7. Roomi
    Jun 30, 2017

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


  8. pravesh
    May 09, 2017

    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.


  9. Mohammed Obeid
    Dec 06, 2016

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


  10. Pablo Buenconsejo
    Oct 05, 2015

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


  11. aurelio gumasing
    Feb 05, 2015

    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
      Oct 01, 2015

      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!


      • Pieter Saayman
        Jul 21, 2019

        Well Said, Inns


  12. Satbir Singh
    Jun 26, 2014

    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.


  13. Samuel A
    Feb 06, 2014

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


  14. Preethy Nalluri
    Nov 13, 2013

    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.


  15. EEP4JOE
    Mar 16, 2013

    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
      Mar 16, 2013

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


  16. MOHAN PATIL
    Mar 15, 2013

    good artical


  17. shabadbs
    Nov 10, 2012

    i would like to receive eng technical articles


  18. ARUNSHARATH
    Oct 02, 2012

    Excellent. Will be very useful in load calculation.


  19. Bala
    Jun 20, 2012

    VERY WELL DONE!


  20. tharanath1981
    Apr 06, 2012

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


  21. Edvard
    Jun 26, 2011

    Yes it is! Thanks to mr. Jignesh Parmar!


  22. lwnt
    Jun 26, 2011

    good program

Leave a Reply to Pablo Buenconsejo

Tell us what you're thinking. We care about your opinion! Please keep in mind that comments are moderated and rel="nofollow" is in use. So, please do not use a spammy keyword or a domain as your name, or it will be deleted. Let's have a professional and meaningful conversation instead. Thanks for dropping by!

4  ×    =  twelve

Learn How to Design Power Systems

Learn to design LV/MV/HV power systems through professional video courses. Lifetime access. Enjoy learning!

Subscribe to Weekly Newsletter

Subscribe to our Weekly Digest newsletter and receive free updates on new technical articles, video courses and guides (PDF).
EEP Academy Courses - A hand crafted cutting-edge electrical engineering knowledge