Cable Continuity and Loop Resistance Test Record Template
Record continuity and loop resistance of instrument cable pairs. The sheet calculates the expected copper loop resistance from length and cross section and flags pairs that are open or too high.
Download
- How to Use sheet with steps
- Template sheet, blank and ready
- Example sheet, filled in
- 124 built in formulas
- A4 landscape print setup
- Works in Excel, Google Sheets and LibreOffice
Preview of the Filled Example
This is the Example sheet from the download, so you can see exactly how the completed cable continuity and loop resistance test record looks.
Continuity results
| No | Cable tag | Pair | From | To | Length (m) | Size (mm²) | Expected loop (Ω) | Measured loop (Ω) | Result | By | Remarks |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | MC 2001 | 1 | JB 2001 | MAR 01 | 250 | 1.00 | 8.60 | 8.90 | PASS | Tech B | |
| 2 | MC 2001 | 2 | JB 2001 | MAR 01 | 250 | 1.00 | 8.60 | 8.80 | PASS | Tech B | |
| 3 | MC 2001 | 3 | JB 2001 | MAR 01 | 250 | 1.00 | 8.60 | 15.20 | FAIL | Tech B | Loose terminal at JB |
About the Cable Continuity and Loop Resistance Test Record
Continuity tests prove each core is connected end to end and correctly identified. Comparing the loop resistance with the expected copper value also finds loose terminals and wrong cable sizes.
How to fill in this template
- Enter length and conductor size for each pair from the cable schedule.
- Short the pair at the far end.
- Measure loop resistance at the near end.
- Compare with the expected value; high readings point to loose or wrong terminations.
- Remove shorts and restore terminations.
What the formulas do
- Expected loop resistance = 2 × length × 0.0172 ÷ cross section (Ω).
- PASS if measured ≤ expected × (1 + allowed excess).
Related tools
Frequently Asked Questions
Why compare with an expected value?
A loose or corroded terminal adds resistance that a simple beep test misses.
Does temperature matter?
Copper resistance rises about 0.4 % per °C; the allowed excess covers normal ambient variation.
How do I check core identity?
Short one pair at a time and confirm which pair reads low at the other end.
Learn more on the blog
Instrument cable schedule
A practical guide on instrumentationblog.in that explains the procedure behind this template and how engineers apply it on real plants.
Read Full Article