Skip to main content
NEWBS 7671, IEC 60364-6

Earth Fault Loop Impedance Test Record (Excel)

Free download · Excel (.xlsx)

Record earth fault loop impedance (Zs) test results with this Excel template. Captures circuit reference, protection device details, required disconnection time, maximum Zs from BS 7671 tables, measured external loop impedance Ze, measured circuit (R1+R2), total measured Zs, pass/fail comparison, prospective fault current, test instrument details, and tester information. Essential for BS 7671 Part 6 initial verification and periodic inspection.

What's Included

Front:Circuit Ref, Protection Device Type/Rating, Disconnection Time s, Max Zs from Table Ω, Measured Ze Ω, Measured (R1+R2) Ω.
Back:Total Zs Measured Ω, Pass/Fail, Prospective Fault Current Ipf A, Test Instrument, Cal Date, Tested By.
Size:Excel (.xlsx)
Format:PDF, print-ready

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 Calculator

Frequently Asked Questions

What is an earth fault loop impedance test record?

An earth fault loop impedance test record documents the measured Zs values for each circuit during initial verification or periodic inspection per BS 7671 Part 6 and IEC 60364-6. It verifies that protective devices will disconnect within the required time during an earth fault.

What should a Zs test record include?

Key fields include circuit reference, protection device type and rating, required disconnection time (0.4s or 5s), maximum Zs from BS 7671 tables, measured external loop Ze, measured circuit (R1+R2), total measured Zs, pass/fail result, prospective fault current, and test instrument with calibration date.

What is the difference between Zs calculation and Zs measurement?

Zs calculation uses tabulated conductor resistances and cable lengths to predict the loop impedance at design stage. Zs measurement uses a loop impedance tester on the live circuit to verify the actual installed value. The measured value must not exceed 80% of the maximum tabulated Zs (to account for temperature rise).