Free engineering calculators and unit convertersceo@instrumentationblog.in
Electrical · Free Excel Calculator

Power Factor Correction Capacitor Calculator

Size a power factor correction capacitor bank. The workbook calculates the kVAR needed to reach your target power factor, the drop in current and kVA, and the capacitance per phase for star or delta connection.

Excel (.xlsx)Worked exampleWorks offlineFree, no sign up

Download

  • Calculator sheet with a worked example
  • How to Use sheet with steps
  • 31 built in formulas, no macros
  • Yellow input cells, grey results
  • Calculation sign off block
  • Excel, Google Sheets and LibreOffice

Worked Example

These are the results of the example already filled in the workbook. Replace the yellow cells with your own data.

Active power P (kW)100
Existing power factor0.8
Target power factor0.95
Line voltage (V)415
Frequency (Hz)50
Bank connectionDelta
Capacitor rating (kVAR)42.1
kVA before125.0
kVA after105.3
Line current before (A)173.9
Line current after (A)146.4
Capacitor line current (A)58.6
Capacitance per phase (µF)259.6

kVAR for other target power factors

Target PFkVAR neededLine current (A)kVA
0.8513.0163.7117.6
0.9026.6154.6111.1
0.9232.4151.2108.7
0.9542.1146.4105.3
0.9749.9143.4103.1
0.9854.7142.0102.0
0.9960.8140.5101.0
1.0075.0139.1100.0
Advertisement

About this Calculator

Low power factor raises current, cable losses and the demand charge on the electricity bill. Capacitor banks are a simple fix when sized correctly; this workbook shows how much correction you need and what it saves in current and kVA.

Basis: Power triangle: Qc = P × (tan φ1 − tan φ2); capacitance from Q = V² × 2πfC.

How to use

  1. Enter the load power in kW, the existing and target power factor, voltage and frequency.
  2. Choose star or delta for the capacitor bank.
  3. Read the kVAR rating, current reduction and capacitance per phase.
  4. Use the table to compare the cost of different target power factors.

Formulas used

  • Qc = P × (tan(acos PF1) − tan(acos PF2)).
  • I = P ÷ (√3 × V × PF).
  • Delta: C per phase = Qc ÷ 3 ÷ (2πf V²); Star: C per phase = Qc ÷ (2πf V²).

Related tools

Advertisement

Frequently Asked Questions

How do I calculate kVAR for power factor correction?

kVAR = kW × (tan φ1 − tan φ2), where φ1 and φ2 are the angles of the existing and target power factor.

What target power factor should I choose?

Usually 0.95 to 0.98. Going to unity costs more and risks leading power factor at light load.

Why does capacitance differ for star and delta?

In delta each capacitor sees line voltage; in star it sees phase voltage, so star needs three times the capacitance for the same kVAR.

You May Also Like

Learn more on the blog

Basics of Ohm's law

A practical guide on instrumentationblog.in that explains the engineering behind this workbook.

Read Full Article

More Excel Calculation Tools