Menu
Search
Load Listing, Calculations and Generator Sizing Spreadsheet
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.


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 | Get Download Updates | Get Technical articles
Load Listing, Calculations and Generator Sizing Spreadsheet
Load Listing, Calculations and Generator Sizing Spreadsheet

Shape Up Your Knowledge //

Want to be a better electrical engineer? Subscribe to professional technical articles. Sharpen up your knowledge in field of electrical engineering now!

Subscribe Now

Page edited by E.C. (Google).

3 Comments


  1. SHAHUL
    May 18, 2016

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


  2. kumaravel
    Aug 19, 2015

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


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

Leave a Comment

Tell us what you're thinking... we care about your opinion!

Time limit is exhausted. Please reload CAPTCHA.