Create a Checklist of All Elements to be Tested


Create a Checklist of All Elements to be Tested

Topic Progress:

Watch this video as we start creating our test plan by transferring the protective element information from our summary sheet into our test software.


Download the test sheet to follow along



Click “Mark Complete” below after watching the video so you can keep track of your progress.

Collapse Comments

The test sheet that you provided in the course is different from the one in the video. Is their a reason for this.

Chris Werstiuk (Administrator) October 4, 2016 at 11:51 am

Thanks for the question.

The downloaded spreadsheet is the template used in the video. As tests are performed, information is added and subtracted. Other than that, they should be identical.

Was there something specific you are seeing that I can’t?

When you are going through the course. The metering is not identical. On your spreadsheet. You have power vars etc included with the current and voltage elements. This is not on the spreadsheet provided. Also there is differences with the amount of test elements. I am not that good with excel and the spreadsheet that you have here is excellent and would save so much time with calculations.

Chris Werstiuk (Administrator) October 7, 2016 at 7:18 pm

You’re right!

I cleaned up the one behind the download button to be much cleaner than the original and be more like the relay we are testing in the example. VARs and Watts aren’t really important if the voltages and currents pass both meter tests.

Here’s the original. It probably has a few bugs in it because it was really written for me and I would just fix them on the fly.

Thanks for the Spreadsheet. Really appreciate the info

i have 50BF; Breaker failure , 50: Instantaneous phase overcurrent protection , 50N: Instantaneous earth over current protection, 51: AC Inverse time phase over current protection, 51N; AC inverse time earth over current protection . This relays in my project . so the same thing i need to check for all of this relays or it will be different.

Chris Werstiuk (Administrator) July 7, 2017 at 7:44 am

You would add any element that is enabled in each relay

For these test sheets, how do you go about getting the forumulas for the Timing curves? I noticed the timing tests have results for U1, U2, U3 and U4 curves. How would you derive the formula if you had a relay using a U5 curve?

Chris Werstiuk (Administrator) September 22, 2020 at 8:39 am

Thanks for your question.

All of the values are based on the manufacturer’s curves.

Do a search for the exact curve in the manual until you find the formula. Then you can manually calculate the expected results, or you can build it into a spreadsheet like I’ve done in the examples.

Most automated test-sets already have the curves in their libraries that you can use during your tests. However, some software (like Doble’s Protection Suite) has the curves built in, but they are quite difficult to apply properly. Therefore, I would build my own calculations in these cases.

Leave a Comment