CYBER MONDAY OFFER đź’Ą Save 20% on PRO Membership Plan and Video Courses with the coupon CYM23 and learn from experienced engineers.

# Power factor correction calculations for power system – MS Excel Spreadsheet

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

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.

1. Samir Amin
Nov 09, 2023

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

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

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

4. [email protected]
Jun 14, 2023

i need excel sheet of electrical load calculation

5. ABHINAV
Apr 15, 2023

GOOD

6. Benjamin Tettey
Jan 31, 2023

Template very good how do I download?
Thank you

7. masauso phiri
Jan 30, 2023

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

9. [email protected]
Nov 07, 2022

need it for study

10. sanati hassan
Sep 28, 2022

tnx ur cooperations

11. Hussien chehab
Jun 09, 2022

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

12. chems
May 10, 2022

good very nice

13. Zagi Mefah
May 25, 2020

Need training on power factor correction

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

Sep 01, 2019

very nice

Aug 31, 2019

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

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

18. Segun Omotosho my
May 17, 2019

Good topics,
Thanks so much.

thanks so much

19. Jacques Habimana
May 17, 2019

Merci beaucoup pour votre contribution dans le mĂ©tier

20. Isaac Asiedu Mensah
May 16, 2019

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

21. Andres Avelar
May 16, 2019

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

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

23. Hapsari Dewi
Nov 14, 2016

Thank You for the article and the excel spreadsheet

24. SUBODH JHA
Aug 19, 2014

THANKS FOR SUCH A GOOD INFORMATION & KNOWLEDGE.

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

26. Abdul Azim Mohammad
Aug 10, 2014

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