Continuity of Protective Conductors Test Record (Excel)
Free download · Excel (.xlsx)
Record continuity test results for protective conductors with this Excel template. Captures circuit reference, conductor sizes, tabulated R1 and R2 values per metre, cable length, expected and measured (R1+R2), measured/expected ratio, pass/fail, ring final circuit end-to-end values (R1, R2, Rn), cross-connection verification, instrument details, and tester information. Essential for BS 7671 Part 6 initial verification of CPC integrity.
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
Zs Test Record
Free earth fault loop impedance test record template Excel. Document measured Zs, Ze, R1+R2 values and pass/fail per BS 7671 and IEC 60364-6. No signup required.
IR Test Record
Download a free insulation resistance test record template Excel per IEC 60364-6 and BS 7671. Columns for circuit data, test voltage, L-N, L-E, N-E readings, temperature, humidity, and pass/fail. No signup required.
RCD Test Record
Free RCD tripping time test record template Excel. Document trip times at 1× and 5× IΔn, ramp test, pass/fail per BS 7671 and IEC 61008. No signup required.
Frequently Asked Questions
What is a continuity test record?
A continuity test record documents the measured resistance of protective conductors (R1+R2) for every circuit per BS 7671 Part 6 and IEC 60364-6. It verifies that CPCs provide a low-impedance path for earth fault current, ensuring protective devices operate correctly.
What should a continuity test record include?
Key fields include circuit reference, phase and CPC conductor sizes, tabulated R1 and R2 values per metre, cable length, expected (R1+R2), measured (R1+R2), measured/expected ratio, pass/fail. For ring circuits: end-to-end R1, R2, and Rn values plus cross-connection verification.
How do you test ring final circuit continuity?
BS 7671 requires a three-step process: (1) measure end-to-end resistance of R1, R2, and Rn conductors, (2) cross-connect L-CPC at one end and measure at each socket — readings should be consistent (within 0.05Ω), (3) the value at the midpoint equals (R1+R2)/4 which is used for Zs calculation.