Protection Discrimination Study Record (Excel)
Free download · Excel (.xlsx)
Record protection coordination and discrimination studies with this Excel template. Captures upstream and downstream device pairs, their types (MCB/MCCB/Fuse/Relay), ratings, settings/curves, fault level at point, clearing times, time margin, and whether discrimination is achieved (total or partial). Documents the method used (time grading, current grading, or energy let-through). Essential for verifying that only the device nearest to a fault operates, maintaining supply to healthy circuits.
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
Protection Device Schedule
Free protection device schedule template Excel. Document MCB/MCCB/ACB ratings, trip settings, and discrimination status per IEC 60947 and BS 7671. No signup required.
Short-Circuit Record
Download a free short-circuit calculation record template Excel per IEC 60909-0:2016. Columns for node impedance, Ik", ip peak, breaking current, thermal withstand, and equipment rating verification. No signup required.
IEC 61439 Commissioning
Download a free switchboard commissioning checklist aligned to IEC 61439-1/2. Covers visual inspection, insulation resistance, busbar torque, protection settings, earth continuity, and functional testing. No signup required.
Frequently Asked Questions
What is a protection discrimination study?
A protection discrimination study analyses pairs of upstream and downstream protection devices to verify that only the device nearest to a fault operates. This ensures healthy circuits maintain supply. It is required by IEC 60947 and BS 7671 Regulation 536.4.
What should a discrimination study record include?
Key fields include upstream and downstream device tags, types, ratings, trip settings/curves, fault level at the discrimination point, clearing times for both devices, time margin between them, and whether total or partial discrimination is achieved.
What is the difference between total and partial discrimination?
Total discrimination means the downstream device always clears the fault before the upstream device trips, at all fault levels up to the maximum prospective fault current. Partial discrimination is achieved only up to a certain fault level — above that level, both devices may trip simultaneously.