Search

Premium Membership ♕

Save 50% on all EEP Academy courses with Enterprise Membership Plan and study specialized LV/MV/HV technical articles & guides.

Home / Download Center / Electrical Software Reviews / 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 a 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:
Download:Here » Get EEP Membership | Video Courses | Download Updates
Power factor correction calculations for power system - MS Excel Spreadsheet
Power factor correction calculations for power system – MS Excel 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.
50% Discount 💥 - Save 50% on all 90+ video courses with Enterprise Membership plan.

More Information

22 Comments


  1. Benjamin Tettey
    Jan 31, 2023

    Template very good how do I download?
    Thank you


  2. masauso phiri
    Jan 30, 2023

    How do I download this spreadsheet


  3. Val
    Jan 28, 2023

    Hi, I would highly appreciate if you could share it with me. It will help me with my university.

    Thank you.


  4. [email protected]
    Nov 07, 2022

    need it for study


  5. sanati hassan
    Sep 28, 2022

    tnx ur cooperations


  6. Hussien chehab
    Jun 09, 2022

    Hope we can do a schedule for PF correction instead of calculating each type of load separately
    Thanks


  7. chems
    May 10, 2022

    good very nice

Leave a Comment

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!

three  ×    =  eighteen

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 Hand-Crafted Courses
Smart Grid Forums Events