Power Factor Correction Sizing Record (Excel)
Free download · Excel (.xlsx)
Power factor correction sizing requires documented load analysis, reactive power calculations, and capacitor bank selection — not guesswork. This Excel template provides a structured PFC sizing record with columns for Load Description, Active Power P (kW), Existing Power Factor cosφ1, Target Power Factor cosφ2, Existing Reactive Power Q1 (kVAr), Target Reactive Power Q2 (kVAr), Required Compensation Qc (kVAr), Selected Bank Rating (kVAr), Type (Fixed/Automatic), Number of Steps, Detuning Reactor (Y/N), Harmonic Filter requirement, Standard Reference, and Notes. Built-in formulas auto-calculate Qc from the kW and power factor values using the tangent method: Qc = P × (tan(arccos(cosφ1)) - tan(arccos(cosφ2))). Conditional formatting highlights loads where harmonic distortion may require detuned reactors. Use alongside ECalPro's power factor calculator for instant kVAr sizing and harmonic risk assessment.
What's Included
How to Print
- ●Open in Microsoft Excel 2016+, Google Sheets, or LibreOffice Calc
- ●Add your company logo and project details to the header
- ●Copy data rows to add more circuits or equipment
- ●Print on A4 or A3 landscape for site records
- ●Keep completed records for design verification and audit trail
Try the Interactive Calculator
Need precise calculations beyond quick reference? Try our free online calculator with full clause references and professional report output.
Open CalculatorRelated Downloads
PFC Study Template
Free power factor correction study template. Calculate required kVAR, select capacitor banks, assess harmonic risks. Step-by-step methodology included.
Max Demand Record
Download a free maximum demand assessment record template Excel per AS/NZS 3000, BS 7671, and NEC Art 220. Columns for load groups, demand factors, diversity, phase assignment, and transformer sizing. No signup required.
Load Schedule
Download a free electrical load schedule template Excel per IEC 60364 and NEC Art 220. Columns for equipment tag, rated power, phases, demand factor, feeder ref, and annual energy. No signup required.
Motor Load List
Free motor load list template Excel download for electrical engineering. Columns for tag, description, kW, voltage, FLA, efficiency, PF, starting method, diversity factor, demand kVA.
Frequently Asked Questions
How does this differ from the PFC study template?
The PFC study template documents the full study methodology including payback analysis and harmonic resonance assessment. This sizing record focuses on the per-load reactive power calculation and capacitor bank selection — ideal for recording the detailed sizing calculations that feed into the study.
When should I use a detuned reactor?
When the system has significant non-linear loads (VFDs, UPS, LED drivers, welders) that produce harmonic currents. A 7% detuned reactor shifts the system resonant frequency below the 5th harmonic, preventing dangerous capacitor overcurrents. The Detuning Reactor column flags this requirement.
Fixed or automatic capacitor bank — which should I choose?
Use fixed banks for constant loads (e.g., continuously running motors). Use automatic stepped banks for variable loads where reactive power demand fluctuates. Automatic banks use a PF controller to switch steps as the load changes.