Search

Premium Membership ♕

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

Home / Download Center / Electrical Software and MS Excel Spreadsheets (Calculations of cables, voltage drop etc.) / 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)
  • I 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 Premium 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

30 Comments


  1. Hirpa Duressa
    Sep 12, 2024

    Electrical Engineering portal is very essential tool for electrical engineers. But it is difficult to get the necessary tools as it requires membership fee.


  2. William Lee Hill
    Sep 04, 2024

    Thanks for the article; please send me a copy of the spreadsheet…


  3. Osama Iftikhar
    May 18, 2024

    I need to apply PF formula in excel spreadsheet, kindly tell me how??


  4. Samir Amin
    Nov 09, 2023

    Thanks for the Great effort.
    Can you please email this excel sheet to me.


  5. khalid Naeim
    Aug 17, 2023

    Thank you very much for your nice effort .

    Please I need excel sheet for Power factor correction and other equipment for substation

    Best wishes.


  6. Peter Aiu Gebaea
    Aug 17, 2023

    This very great. I NEED a copy of that spread sheet. Can you email it to me.

    regards,

    Peter


  7. [email protected]
    Jun 14, 2023

    i need excel sheet of electrical load calculation


  8. ABHINAV
    Apr 15, 2023

    GOOD


  9. Benjamin Tettey
    Jan 31, 2023

    Template very good how do I download?
    Thank you


  10. masauso phiri
    Jan 30, 2023

    How do I download this spreadsheet


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


  12. [email protected]
    Nov 07, 2022

    need it for study


  13. sanati hassan
    Sep 28, 2022

    tnx ur cooperations


  14. Hussien chehab
    Jun 09, 2022

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


  15. chems
    May 10, 2022

    good very nice


  16. Zagi Mefah
    May 25, 2020

    Need training on power factor correction


  17. Naimish
    Feb 17, 2020

    A 1000-KVA transformer is loaded to 850 KVA at a power factor of 0.82
    lag. Calculate the leading kVAR necessary to correct the power factor to 0.95 lag.
    If the transformer has a rated conductor loss equal to 1.0% of the transformer rating,
    calculate the energy saved assuming 24-hour operation at the operating load.


  18. Akram Mufaddal Alfadeel
    Sep 01, 2019

    very nice


  19. Mojtaba Dadashi
    Aug 31, 2019

    hi, I seeking standard that report desirable Power Factor in distribution network.
    is it possible anyone guide me.


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


  21. Segun Omotosho my
    May 17, 2019

    Good topics,
    Thanks so much.

    thanks so much


  22. Jacques Habimana
    May 17, 2019

    Merci beaucoup pour votre contribution dans le métier


  23. Isaac Asiedu Mensah
    May 16, 2019

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


  24. Andres Avelar
    May 16, 2019

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


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


  26. Hapsari Dewi
    Nov 14, 2016

    Thank You for the article and the excel spreadsheet


  27. SUBODH JHA
    Aug 19, 2014

    THANKS FOR SUCH A GOOD INFORMATION & KNOWLEDGE.


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


  29. Abdul Azim Mohammad
    Aug 10, 2014

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


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

twenty seven  −  twenty five  =  

Learn How to Design Power Systems

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

EEP Hand-Crafted Video Courses

Check more than a hundred hand-crafted video courses and learn from experienced engineers. Lifetime access included.
Experience matters. Premium membership gives you an opportunity to study specialized technical articles, online video courses, electrical engineering guides, and papers written by experienced electrical engineers.