Harmonic Distortion Assessment Template (Excel)
Free download · Excel (.xlsx)
Assess harmonic distortion compliance with this Excel template. Captures PCC identification, system voltage, short circuit capacity, maximum demand load, Isc/IL ratio, non-linear load details, estimated current THD, individual harmonic limits from IEEE 519 Table 2, measured/estimated levels, voltage THD limits from Table 1, compliance status, and proposed mitigation measures (passive filter/active filter/multi-pulse/phase shifting). Essential for VFD-heavy installations.
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
Power Quality Record
Free power quality and harmonics measurement record template Excel. Document THD, voltage imbalance, flicker per IEC 61000-4-30 and IEEE 519. No signup required.
PFC Sizing Record
Download a free power factor correction sizing record template Excel per IEC 60831 and IEEE 1036. Columns for existing PF, target PF, required kVAr, bank selection, detuning, and harmonic filter. No signup required.
Design Basis Template
Free electrical design basis template Excel. Document project standards, supply data, voltage drop limits, cable criteria, and design margins. No signup required.
Frequently Asked Questions
What is a harmonic distortion assessment?
A harmonic distortion assessment evaluates whether non-linear loads (VFDs, UPS, LED drivers) in an installation will cause current and voltage harmonic levels to exceed IEEE 519 or IEC 61000-3-6 limits at the point of common coupling (PCC). It determines whether mitigation (filters) is required.
What should a harmonic assessment include?
Key fields include PCC identification, system voltage, short circuit capacity (MVAsc), maximum demand (MVA), Isc/IL ratio (determines applicable IEEE 519 limits), non-linear load inventory, estimated current THD, individual harmonic levels versus limits, voltage THD, and proposed mitigation if non-compliant.
How do you determine IEEE 519 harmonic limits?
IEEE 519 Table 2 bases current harmonic limits on the Isc/IL ratio at the PCC — the ratio of available short circuit current to maximum demand load current. Higher ratios (stiffer systems) allow higher harmonic levels. For Isc/IL of 20–50 (typical): 8% total current THD, 5% voltage THD.