# Motor Insulation Resistance Test Log Worksheet > Source: https://netray.co/tools/motor-insulation-resistance-test-log-worksheet > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: Free Tools ## Short answer An editable megger test log that calculates dielectric absorption ratio, polarization index and insulation resistance corrected to 40C. ## Category maintenance ## Industry Manufacturing ## Audience - Electrical maintenance - Reliability engineer - Motor shop technician ## Tool **Kind:** worksheet **Mode:** editable **Columns:** #### Test date **Key:** date **Type:** date #### Motor **Key:** motor **Type:** text #### Test voltage **Key:** volts **Type:** number **Unit:** V **Format:** integer #### Winding temperature **Key:** temp **Type:** number **Unit:** C **Format:** decimal #### IR at 30 s **Key:** ir30 **Type:** number **Unit:** MOhm **Format:** decimal #### IR at 1 min **Key:** ir60 **Type:** number **Unit:** MOhm **Format:** decimal #### IR at 10 min **Key:** ir600 **Type:** number **Unit:** MOhm **Format:** decimal #### DAR (1 min / 30 s) **Key:** dar **Type:** number **Expr:** if(gt(ir30,0),ir60 / ir30,0) **Format:** decimal #### PI (10 min / 1 min) **Key:** pi **Type:** number **Expr:** if(gt(ir60,0),ir600 / ir60,0) **Format:** decimal #### 1 min IR corrected to 40C **Key:** ir40 **Type:** number **Expr:** ir60 * pow(0.5, (40 - temp) / 10) **Format:** decimal #### Result **Key:** result **Type:** select **Options:** - Pass - Marginal - Fail - Dry and retest **Rows:** **Date:** 2026-10-03 **Motor:** M-101 Fan motor 75 kW **Volts:** 1000 **Temp:** 32 **Ir30:** 850 **Ir60:** 1200 **Ir600:** 3100 **Result:** Pass **Date:** 2026-10-03 **Motor:** M-114 Pump motor 37 kW **Volts:** 500 **Temp:** 28 **Ir30:** 120 **Ir60:** 150 **Ir600:** 240 **Result:** Marginal **Date:** 2026-10-04 **Motor:** M-122 Compressor 160 kW **Volts:** 1000 **Temp:** 45 **Ir30:** 40 **Ir60:** 42 **Ir600:** 44 **Result:** Dry and retest **Date:** 2026-10-04 **Motor:** M-130 Conveyor motor 15 kW **Volts:** 500 **Temp:** 25 **Ir30:** 2200 **Ir60:** 3400 **Result:** Pass **Ir600:** 8800 **Totals:** #### Lowest polarization index **Key:** pi **Agg:** min **Format:** decimal #### Lowest corrected IR **Key:** ir40 **Agg:** min **Format:** decimal #### Motors tested **Key:** motor **Agg:** count **Format:** integer **Notes:** Test only de-energized, isolated and discharged windings under your electrical safety procedure. The 40C correction here uses the common rule that insulation resistance halves for every 10C rise. Acceptance values depend on the standard (for example IEEE 43), the insulation class and voltage, so use your procedure for pass limits. ## Content **Intro:** A megger reading on its own does not say much. The trend, the temperature and the shape of the curve do. This log records the three timed readings, applies the temperature correction and calculates the two ratios technicians ask for. **Sections:** #### How to use the log **Body:** Isolate and discharge the motor, record the winding temperature, apply the test voltage and note the reading at 30 seconds, 1 minute and 10 minutes. Enter the values in a row and the worksheet calculates DAR, PI and the one minute value corrected to 40C. Pick a result, add the test voltage you used and export to Excel to chart the corrected IR by motor over the years. **Bullets:** - Use the same test voltage each time for comparable trends - Record winding temperature, not just ambient - Discharge windings fully after the test #### DAR, PI and the corrected value **Body:** DAR is the ratio of the one minute to the thirty second reading. PI is the ratio of the ten minute to the one minute reading. Clean dry insulation keeps charging, so the readings rise and the ratios climb. Wet or dirty insulation leaks, so the readings flatten and both ratios approach one. The temperature correction brings readings to a common 40C reference, because insulation resistance falls sharply when warm. A minimum 1 minute value in the order of 1 MOhm per kV plus 1 MOhm is a long-standing rule of thumb, verify with the standard. #### Worked example **Body:** A fan motor tested at 32C reads 1200 MOhm at one minute. Correcting to 40C gives about 1200 times 0.5 to the power of minus 0.8, which is roughly 2090 MOhm, the winding is cooler than reference so the corrected figure rises. With 10 minute reading at 3100, PI is about 2.6. That is a healthy trend unless the history shows a fall. A motor that was 5000 MOhm last year and 2100 now deserves a look even though it passes. #### Common mistakes **Body:** Common errors include testing a warm motor and forgetting the correction, testing with surge arresters or cables still connected, skipping the discharge, and treating a single pass as proof of health. Surface moisture can be dried out and the test repeated. Keep the leads and the instrument calibrated. **Cta:** Netray can help link motor test results to equipment records in your ERP so trends appear alongside work order history. **Faq:** #### What is a good polarization index? **Answer:** Many standards and practitioners treat a PI of 2.0 or more as acceptable for most insulation classes, and a PI below 1 as a serious concern. Exact limits depend on the standard and class, so check IEEE 43 or your motor manufacturer. #### Why correct to 40C? **Answer:** Insulation resistance changes strongly with temperature, so readings taken in different seasons cannot be compared directly. Correcting to a standard temperature, typically 40C, makes trends meaningful. #### Can I use this for transformers or cables? **Answer:** The ratios and correction work in the same way, but acceptance limits and test voltages differ. Rename the columns and use the limits from the relevant standard for the equipment. #### How often should motors be tested? **Answer:** Annually is common for important motors, and before and after any rewind or long storage. Wet environments justify more frequent tests. ## Search terms insulation resistance test log, megger test record motor, polarization index calculator excel, dielectric absorption ratio worksheet, motor winding insulation test template, ir test temperature correction 40c, motor testing log spreadsheet --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json