×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Relay Coordination Using Microsoft Excel

Relay Coordination Using Microsoft Excel

Relay Coordination Using Microsoft Excel

(OP)
Hello All,

Can someone point me in the right direction? I would like to electronically plot the coordinated TCC curves for a simple power system. I only need to coordinate three overcurrent devices (Multilin 469, Multilin MIFII, and Multilin 750), all at the same voltage level.

Instead of (a)using expensive power system engineering software (which we don't own and can't justify purchasing) or (b)using the time-honored method of overlaying TCC tracing paper on each relay's TCC curve, is there a way to create a TCC chart electronically using Microsoft Excel?

Thanks in advance for all your help!

RE: Relay Coordination Using Microsoft Excel

Yes you may. You can create a graph and select the logarithmic graph type. You can plot the relay curves by adding a curve that is referenced to table. You may create a table with embedded formula corresponding to the IEC or ANSI formula given by the manufacturer (IEC A, B, C etc) and simulate by varying short circuit and values against the PMS setting. You can simulate the S.C. ratings in fine steps and a range covering your calculated S.C. Then to you may also make a range with fine steps of your relay current settings. To add some fancy stuff, you can provide a scroller for your relay current settings using visual basic toggles and rest, use your imagination and creativity. I did this once and it worked and gave me smooth relay curve and I can move the curve upwards and downwards by scrolling the time and current scroll bars.

GO PLACIDLY, AMIDST THE NOISE AND HASTE-Desiderata

RE: Relay Coordination Using Microsoft Excel

(OP)
Thanks for your responses, folks. Much appreciated.

I already have the TCC tables for the three relays loaded into Excel and can create the curves in an Excel chart. My question is, how can I plot the curves from the three different relays, each with their own different current pickup points in Excel?

Thanks!

RE: Relay Coordination Using Microsoft Excel

Years ago I put together a crude calculator in Excel to deal with the GEC relays and IIRC the Merlin Gerin ST series tripping units for their Masterpact ACBs. If I can find it I will upload it to somewhere and post a link. When you improve it maybe you could post it back!
 

----------------------------------
  Sometimes I only open my mouth to swap feet...

RE: Relay Coordination Using Microsoft Excel

Look the program at http://pp.kpnet.fi/ijl
It contains several more or less standard relay curves, although no (literally) Multilin relays. The user can define new curves.

RE: Relay Coordination Using Microsoft Excel

Make a column of currents
Make a column for each relay
Use the formulae for standard relays curves to develope tripping time in each of the relay columns using the currents in the first colum
Plot the three relay columns on one graph with the current column as the X axis
Use log/log scale
Easy

RE: Relay Coordination Using Microsoft Excel

Use two columns for each curve, one for time and the other for current.  Then select scatter plot with connected lines for the plot type.  Once the plot is created, double click each axis and choose logarithmic scale in the scale tab and adjust the scale range as desired.  

With the scatter plot you can choose which column is the x values and which is the y for each curve.  If you are using the same time or current points for two or more plots you can use the same column for each.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources