In this tutorial, we shall be able to create Normal Inverse curves from the formula given below (IEC). This formula has been used in so many coordination studies world wide. You can actually use it to coordinate your protection settings with your power supplier. Normally the time setting for the network protection will be provided by the power supplier. We shall be discussing this on the next tutorial.
k = time, s
α, β = constants, see table below
I = Input Current
IO = Pickup setting
The curve constants for the different response curves are as follows.
|Normal Inverse (Type A)||0.02||0.14|
|Very Inverse (Type B)||1.00||13.5|
|Extremely Inverse (Type C)||2.00||80.0|
|Long Time Inverse||1.00||120|
Using the formula above, the resulting values will be the following table. You could copy the whole table and paste it into your worksheet or create the values yourself using the above formula. Remember that this curve is for Normal Inverse curve.
With the values above, We shall be using the 2003 version of Excel to draw the chart. If you have 2007 version, it is not a problem, the steps would just be different but the resulting graph will still be the same.
Select the cell range as shown.
Note: Do not include the I/IO, else you will be getting a different graph profile.
Start chart wizard and select XY (Scatter) with data points connected by smoothed lines without marker.
Select the data range with series in columns
Type a title, make sure to put x-axis title as Current in amperes and y-axis values as time in seconds.
Click the gridlines tab and tick all the major and minor gridlines for X and Y axis. Then click finish. If prompted about the location of the graph, select it as an object in the worksheet.
The resulting graph will be
Double click on the Y-axis values, the format Y-axis window will pop-up. Select Logarithmic scale. and values as shown. Do similar for the X-axis.
The resulting graph will be as follows. As you could see, the graph scale now are logarithmic.
Try format the graph, putting some additional values, removing the chart background, etc. The final graph may look like this.