Calculator #42

Cable Test Record Calculator

Continuity, loop resistance, insulation resistance, screen / sheath and test voltage for each cable section, checked and recorded in one place.

About this calculator

After a cable is laid, each section is tested before it is energised. This tool takes your readings, compares the loop resistance with what the conductor and length should give at the test temperature, corrects insulation resistance to 20 °C, checks every result against your acceptance limits and issues a PDF record with sign-off boxes.

Quick start Illustrative readings only.

Cable & Test Conditions

Nominal DC resistance at 20 °C. Use the manufacturer figure if you have it.
From the cable data sheet.
Rule note

Measured on the cable or the soil beside it, not the air temperature.

Your project limit on measured against expected resistance.

Acceptance Criteria

Rule note

Set this from the project specification or owner requirement. It is not a universal figure.

Rule note

Correcting a warm reading to 20 °C raises it, so as measured is the stricter choice above 20 °C. Below 20 °C the corrected reading is lower and therefore stricter.

Sheath to earth, from your specification.
Rule note

10-minute ÷ 1-minute reading. A value under 1 means the reading fell during the test. It is of limited use when the 1-minute reading is very high.

Test Readings by Section

How to enter readings

Loop length is the total conductor length in the measured loop, so a loop that goes out and back counts both ways. Leave a reading blank if it has not been taken; the section shows as incomplete. IR is conductor to earth, in MΩ.

SectionLoop length (m)ContinuityLoop R (Ω)IR 1 min (MΩ)IR 10 min (MΩ)Screen cont.Screen IR (MΩ)
FAQ

Cable Test Record Calculator: Frequently Asked Questions

Quick answers on checking and recording continuity, loop resistance and insulation resistance for each cable section.

What does the Cable Test Record Calculator do?

After a cable is laid, each section is tested before it is energised. This tool takes your readings for continuity, loop resistance, insulation resistance, screen or sheath and test voltage. It compares the loop resistance with what the conductor and length should give at the test temperature, corrects insulation resistance to 20 degrees C, checks every result against your acceptance limits, and issues a PDF record with sign-off boxes.

How is the loop resistance checked?

The expected resistance is the conductor resistance at 20 degrees C times the loop length divided by 1,000, times 1 plus 0.00393 times the temperature minus 20. The deviation is the measured minus the expected, divided by the expected, times 100, and it is compared with your tolerance. A high reading points to a poor joint or termination, or a longer route than entered, and the tool also shows the length implied by the measured value.

How is insulation resistance corrected?

Insulation resistance falls as the cable warms, and as a rule of thumb it halves for each 10 degrees C rise. The corrected value is the reading times 2 to the power of (temperature minus 20) divided by 10. Multiplying by length in km gives a figure in megohm-km that does not depend on how long the section is.

What is the polarisation index?

It is the 10-minute reading divided by the 1-minute reading. A value below the flag limit does not fail the section but is noted for review. A value under 1 means the reading fell during the test. It is of limited meaning when the 1-minute reading is already very high, and IEEE 43, a rotating-machine standard used here only as guidance, treats readings above about 5,000 megohms this way, so do not over-read a low index on a clean, dry cable.

How do I enter readings and limits?

Loop length is the total conductor length in the measured loop, so a loop that goes out and back counts both ways. Insulation resistance is conductor to earth, in megohms. Leave a reading blank if it has not been taken, and the section shows as incomplete. The minimum insulation resistance, test voltage and tolerance are yours to set from the project specification. You can apply the minimum to the reading as measured or corrected to 20 degrees C. Above 20 degrees C the as-measured choice is stricter.

How are the section and record results decided?

A section fails if any check fails. It is incomplete if a required reading is missing or invalid, and it passes with notes, shown as PASS*, if only a review note is raised, such as a low polarisation index or a test voltage above the cable rating. The record fails if any section fails, is incomplete if any section is, and otherwise passes.

Can you give a worked example?

Section S1 is 6 mm squared copper at 3.08 ohms per km, with a loop of 1,200 m at 30 degrees C, so the temperature factor is 1.0393 and the expected loop resistance is 3.841 ohms. The measured 3.86 ohms is a deviation of plus 0.49 percent. An insulation reading of 2,500 megohms at 1,000 V corrects to 5,000 megohms at 20 degrees C, which is 6,000 megohm-km, and the polarisation index is 1.24. Against plus or minus 5 percent and 100 megohms, the section passes.

Is the output a test certificate?

No. It is a working test record and not an approved test certificate. The tool applies the limits you enter and does not know your specification, so confirm limits, test voltages and the test method against the project specification and the cable manufacturer before accepting a cable. It uses copper conductors and a rule-of-thumb insulation correction, whereas some specifications give their own factor. It does not cover high-voltage withstand tests, cable fault location or trend analysis across repeat tests.

More Tools

Related Knowledge Hub Resources

Talk to Precision AGL Academy

Follow the Academy

Record result—