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.
The test sheet that you provided in the course is different from the one in the video. Is their a reason for this.
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.
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.
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?
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.
Chris,
The overcurrent test sheet is great. Do you happen to have a template for any other relays? We are moving to all SEL, but have a ton of Basler CDS and BE1s and SIEMENS 7SJ62 and 7SA52 relays. I work for a coop where I am the tester, technician, engineer, etc. Any documentation would be greatly appreciated. Also, is you drawing comparison chart available for download?
Best regards,
Thanks. I have all of the templates I used when testing relays, but they aren’t polished like this one is. If what you’re trying to test is current related, it would probably be better to modify this one to fit you’re new relay. That’s what I would do. If you need another relay’s test sheet that is probably half finished and full of bugs I would just fix on the fly, you can email me at [email protected].
You can download everything I use in the seminar at https://valence.relaytraining.com/forums-page/topic/all-course-downloads/
Chris i am failing to log in creat a checklist of all elements, outputs and signals to be tested.
Everything seems to be working properly. Can you be more specific about the problem you are experiencing?