Search

Premium Membership

Get access to premium HV/MV/LV electrical guides, technical articles, research studies and much more.
Home / Download Center / Electrical Software / Power factor correction calculations for power system – MS Excel Spreadsheet
Power factor correction calculations for power system - MS Excel Spreadsheet
Power factor correction calculations for power system – MS Excel Spreadsheet

Power Factor correction using static capacitor

Calculation formulas as follows:

  • Q1 =  I losses + Cu losses
  • Q2 = PkW · (Tanφ1 – Tanφ2)
  • losses = 2% ·  Str
  • Cu losses = USC% · Str
  • Q = Q1 + Q2

Where:

  • Q1 = Reactive power to be compensated at the terminals of a transformer due to no load and load losses.
  • Q2 = Reactive power to be compensated due to total reactive components of lighting, power and mechanical loads.
  • Q = Overall reactive power to be compensated to achieve target power factor.
  • I losses = Transformer no load losses = Iron core losses.
  • Cu losses = Transformer load losses = Copper losses.
  • Str = Transformer rating (KVA).
  • P = Maximum demand load on the Main distribution board (kW).
  • φ1 = Inverse cosine of power factor before compensation.
  • φ2 = Inverse cosine of target power factor.
  • Usc% = Short circuit percentage impedance voltage of the transformer.

Power Factor Values assumptions before compensation:

  • For lighting outlets = 0.96
  • For power outlets and receptacles = 0.8
  • For motors = 0.8

Inputs = Transformer size + Transformer type + kVA Max. demand load for the whole system + PF before compensation + Target value of PF.

Outputs = Reactive power to be compensated at the terminals of a transformer due to no load and load losses.

  • Reactive power to be compensated due to total reactive components of lighting, power and mechanical loads
  • Overall reactive power to be compensated to achieve target power factor + circuit breaker size required to protect the capacitor bank.

Software: Power factor correction calculations for power system – MS Excel Spreadsheet
Version:
Developer: Mahmoud Salama
Size: 126 KB
Price: FREE
Download: Right here | Get Download Updates | Get Premium Membership
Power factor correction calculations for power system
Power factor correction calculations for power system

Premium Membership

Premium membership gives you an access to specialized technical articles and extra premium content (electrical guides and software).
More Information

11 Comments


  1. md rahmat kamil
    May 17, 2019

    sir request 1kva transformer design and calculation winding bobbin size select
    testing report valve with reference range
    send me sir pdf


  2. Segun Omotosho my
    May 17, 2019

    Good topics,
    Thanks so much.

    thanks so much


  3. Jacques Habimana
    May 17, 2019

    Merci beaucoup pour votre contribution dans le métier


  4. Isaac Asiedu Mensah
    May 16, 2019

    This is helping me to learn more. Infact I’m very happy, please keep it up


  5. Andres Avelar
    May 16, 2019

    LES AGRADEZCO POR LA OPORTUNIDAD QUE NOS DAN EN AMPLIAR NUESTROS CONOCIMIENTOS AL PRESENTAR EXCELENTES ARTÍCULOS. FELICIDADES


  6. Jordan Araujo
    Nov 17, 2016

    Thanks for such a great and very useful tools for electrical engineering. This is a great website for our profession.


  7. Hapsari Dewi
    Nov 14, 2016

    Thank You for the article and the excel spreadsheet


  8. SUBODH JHA
    Aug 19, 2014

    THANKS FOR SUCH A GOOD INFORMATION & KNOWLEDGE.


  9. Mahmoud Salama
    Aug 15, 2014

    Many Thanks for publishing this calculation sheet on your reputable site. it gave me much pleasure and confidence to create other sheets to share knowledge and introduce Fast tools.


  10. Abdul Azim Mohammad
    Aug 10, 2014

    Thank you somuch for your various articles on elect engg subsubjects which are extremely helpful for we engineers


  11. Mohammad Aljundi
    Aug 10, 2014

    I just want to express my deep gratitude for all the very useful tools you post here.

Leave a Comment

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