Search

Premium Membership

Save 15% on Pro Premium Plan with discount code: UX778 (expires on October 31st). Study specialized LV/MV/HV technical articles and papers.

Home / Download Center / Electrical Software Reviews / Load Listing, Calculations and Generator Sizing Spreadsheet

Introduction to Load Flow

This calculator is commonly used for load listing, load calculations and generator size selection.

Load Listing, Calculations and Generator Sizing Spreadsheet
Load Listing, Calculations and Generator Sizing Spreadsheet

Values used in calculations

Loading factor

Ratio between Absorbed Power and Rated Power

Load Factor
Motors between: 0kW – 15 kW0.7
Motors between: 15kW – 45 kW0.75
Motors between: 45kW – 150 kW0.83
Motors larger than 150 kW0.85

Efficiency

Percentage between Output Power and Input Power

Efficiency
Motors between: 0kW – 15 kW0.85
Motors between: 15kW – 45 kW0.89
Motors between: 45kW – 150 kW0.91
Motors larger than 150 kW0.94

Power Factor

Ratio between Active Power and Total Power

Power Factor
Motors between: 0kW – 15 kW0.75
Motors between: 15kW – 45 kW0.8
Motors between: 45kW – 150 kW0.82
Motors larger than 150 kW0.91

Calculations:

  • KW Consumed by a Motor = Absorbed Power x Efficiency x Power Factor
  • KVAR consumed by a Motor = KW x tan (cos-1(p.f))
  • KVA consumed by a motor = (KW2+ KVA2)1/2
  • Multiplication Factor for Continuous Load = 100%
  • Multiplication Factor for Intermittent Load = 50%
  • Multiplication Factor for Stand by Load = 10%
  • Max. Normal Operating Load = 100% of Continuous Load + 50% of Intermittent Load
  • Max. Peak Operating Load = 100% of Continuous Load + 50% of Intermittent Load + 10% of Standby Load or Biggest individual standby
  • Normal Operating Load with Growth Factor = 110% of Max. Normal Operating Load
  • Peak Operating Load with Growth Factor = 110% of Max. Peak Operating Load
  • Generator Size on 70% Load Factor = Peak Operating Load with Growth Factor / 70%
Software:Load Listing, Calculations and Generator Sizing Spreadsheet
Version:1.0 New
Developer:Shafqat Ali
Size:20.44 KB
Price:Free
Download:Right here | Video Courses | Membership | Download Updates
Load Listing, Calculations and Generator Sizing Spreadsheet
Load Listing, Calculations and Generator Sizing Spreadsheet

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

9 Comments


  1. Ramakant
    Jul 08, 2021

    Which standard (IS, IEC, NEMA) are used Load factor & power factor values? I have efficiency data as per IS 12615.


  2. Josh Presutti
    Feb 17, 2021

    The unprotect feature to save as unprotected file does not work if the copy you are creating is already protected. Is there any way to get the password so that the sheet can be expanded upon? It isnt changing the source calculations, formatting, etc. but you cant expand upon it in any way such as when you have 56 loads.


  3. William D. Smith
    Feb 24, 2020

    Seems like a lot of work to figure out loads of every appliance you want available. Obviously, one would not be using them all at once. I thought that the way to figure load was to take the total breaker amps times a reduction factor times voltage equals the generator wattage size required.

    If so, what is the typical reduction factor?

    Thanks, Bill


  4. Manirul
    Oct 05, 2018

    Effect of Starting sequence and nature of starting for Motor load have not shown in the spread sheet


  5. SHAHUL
    May 18, 2016

    i cannot edit the excel sheet, it is protected and asking password, please give me the password


    • HAMITI
      Sep 08, 2019

      Bonjour ,vous copie la feuille Excel dans une autre feuille Excel en suite renomme la feuille Excel


  6. kumaravel
    Aug 19, 2015

    i would like to receiver all articular related to electrical to my above specified E-mail ID


  7. Amin
    Dec 17, 2013

    hi,thanks for good software and articles.
    but some of these EXCEL Sheets are protected and we cant enter data for calculations please help me.
    Thanks again.


    • Benjamin Kaul
      Apr 01, 2019

      Create a copy…
      Go to,
      Sheet 1,
      Move or Copy,
      Tick Create a copy
      Click on drop down menu and select New Book
      …save an unprotected file…

Leave a Reply to Josh Presutti

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!

  +  79  =  eighty eight

Learn to Design Power Systems

Learn to design LV/MV/HV power systems through professional video courses. Lifetime access. Apply a 15% discount code EAB77 and enjoy learning!

Subscribe to Newsletter

Subscribe to our Weekly Digest newsletter and receive free updates on new technical articles, video courses and electrical guides.