was developed on Microsoft Excel ® using the Visual Basic programming language. 36 Time-Current Curves Questions or Comments? In this tutorial, we shall be able to create Normal Inverse curves from the formula given below (IEC). in this previous Topic, we covered part one, part two and the first method of performing a selectivity coordination study By using Selective Coordination Time - Current Curves. E-Coord. Third: By using Siemens calculators / spreadsheets. While going through my office's old files, i found a excel file where previous employees (10-15 years ago) draw TCC curves of some relays . In these articles, I have discussed the methodology on how to create time-current curves using excel. 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. A Time Current Curve (TCC) is a graphical representation of the operating characteristics of overcurrent protection devices at different magnitudes of fault currents. Fault currents in per unit of 3-phase-fault currents for various faults Created for free using WordPress and. Cable Sizing Software - select, size and manage your power cables using myCableEngineering. With these tickers in Excel, the Import Data Wizard lets you choose "Import from a spreadsheet" to upload a list of tickers to the wizard at one go. • Trip Curves predict the behavior of circuit protection devices in both slower, smaller overcurrent conditions, and larger, faster over current conditions. First: By using Selective Coordination Time - Current Curves; Second: By using Selective Coordination Charts/Tables. It displays and plots time-current curves, compares the melting and clearing I2T of all fuses, supports fuses, circuit breakers, and special devices, provides switch settings for electronic breakers, includes cable and transformer damage curves and displays motor starting curves. You could copy the whole table and paste it into your worksheet or create the values yourself using the above formula. Current is shown on the horizontal axis using a logarithmic scale and is plotted as amps X 10X. The user is expected to have at least an intermediate level of knowledge in the usage of aforementioned software else it will be difficult to understand the procedures presented herein. In this tutorial, we shall be able to create Normal Inverse curves from the formula given below (IEC). Step 2 Start chart wizard and select XY (Scatter) with data points connected by smoothed lines without marker. All your cables, for all your projects. The numbers in the document attached are counts of cars over an hour period, from 8:00am til 9:00am, on numerous Wednesdays over the period of a year… This document serves a guide for the creation of time-current curves using Excel1 2013. The application allows up to four relay curves to be drawn with a variety of curve types to choose from. Using curves Example of Curves Workflow: 1) Choice of visualized object(s) 2) Definition of the verifications to check (cables protection – discrimination between circuit breakers) 3) Choice of the curve (Time-current, Energy limitation, Peak limitation) 4) Setting of the object(s) (if available) 5) Printouts 4.1. In Part 1, I have discussed the basics of using excel in plotting time-current curves. I would suggest that if you are not familiar with creating graphs in excel that you go to each of the tutorials listed above to be able to comprehend the foregoing how tos. Step 4 Type a title, make sure to put x-axis title as Current in amperes and y-axis values as time in seconds. Positive and zero sequence impedance to IEC 60609. // , © 2021 Electrical Engineers and Master Electricians (EEAME) Portal, Electrical Engineers and Master Electricians (EEAME) Portal. The One Line diagram and the Time-Current curve can be exported to files for inclusion in other reports as well. If prompted about the location of the graph, select it as an object in the worksheet. In this series of tutorials, I will be discussing "HOW TOS" on relay coordination using excel. Time Current Curves Motor Protection Motor protection relays are typically programmed to operate approximately halfway between Load Current Curve and the Motor Damage Curve. You can actually use it to coordinate your protection settings with your power supplier. It displays and plots time-current curves, compares the melting and clearing I2T of all fuses, supports fuses, circuit breakers, and special devices, provides switch settings for electronic breakers, includes cable and transformer damage curves and displays motor starting curves. Troubleshooting 37 . Typical time-current curves of a 600-ampere, frame-size, molded-case circuit breaker ..... 12 3. A Time Current Curve (TCC) is a graphical representation of the operating characteristics of overcurrent protection devices at different magnitudes of fault currents. The final graph may look like this. 2. The figures along the left side (vertical axis) represent time in … Calculating fault currents is likewise beyond the scope of this document. time-current curves using Excel1 2013. We shall be discussing this on the next tutorial. in this Two previous Topic, we covered part one, part two and the first Two methods of performing a selectivity coordination study By using Selective Coordination Time - Current Curves & by using Selective Coordination Charts/Tables . A TCC is a two-dimension plot with the current at the x-axis and the time at the y-axis with both axes are in var color='3D2E3A';var l=10;var w=240; This will allow the application to be run on any device supporting Excel, originally planned to run on a smart phone, thus making the software easily accessible. Do similar for the X-axis. Step 1 Select the cell range as shown.Note: Do not include the I/IO, else you will be getting a different graph profile. The curve constants for the different response curves are as follows. • Choosing the correct trip curve for your application provides reliable circuit protection, while limiting nuisance or false trips. and values as shown. Calculating fault currents is likewise beyond the scope of this document. S&C also offers Coordinaide ™ — The S&C Protection and Coordination Assistant. Current is shown on the horizontal axis using a logarithmic scale and is plotted as amps X 10 X. A TCC is a two-dimension plot with the current at the x-axis and the time at the y-axis with both axes are in Time-current curves can also be plotted and selective coordination for any particular application can be verified by using MS Excel. Category: Tutorials. Step 7 Double click on the Y-axis values, the format Y-axis window will pop-up. Standard Inverse (Normal Inverse) - this is the most commonly used curve for over-current protection. Overlays of time-current curves, which utilize a light table and manufacturers’ published data. Then click finish. Step 4: Select data fields/variables. This paper is a brief overview of trip curves. Excel base Programs (Electrical Engineering): Designed by: Jignesh.Parmar Buy All (52 No's) of Unlock Electrical Software at 30% Discount (US $) Buy All (52 No's) of Unlock Electrical Software at 40% Discount (Indian Rs) (1) Cable size and Voltage Drop Calculation FREE DOWNLOAD BUY UNLOCK VERSION($) BUY UNLOCK VERSION(Rs) Calculate Voltage drop of Cable.… Select Logarithmic scale. Step 9 Try format the graph, putting some additional values, removing the chart background, etc. Computer programs that utilize a PC/Laptop and allow the designer to select time-current curves published by manufacturers. Remember that this curve is for Normal Inverse curve. I couldn't figure out how they have manipulated required data. © 2021 Filipino Engineer. The upper portion of the time-current curve shows the circuit breaker’s thermal response, the curved line indicates the nominal performance of the circuit breaker.In thermal magnetic breakers, a thermal overload occurs when a bi-metal conductor inside the circuit breaker deflects after becoming heated by the load current, de-latching the operating mechanism and opening the contacts.The larger the overload, the faster the bi-metalic … The curves allow the power systems engineer to graphically represent the selective coordination of overcurrent devices in an electrical system. Curves main window [CDATA[ Feel free to download the original worksheet and use it as a template for … Step 8 The resulting graph will be as follows. ETAP Star Protective Device Coordination software provides a Plot Options tool with all the necessary options to customize the display of the Time Current Characteristic Curve. Using the formula above, the resulting values will be the following table. 35 Time Current Curves Motor Protection . The figures along the bottom (horizontal axis) represent current in amperes. Circuit Breaker Time/Current Curves (Phase Current) Time Current Curves. TCC Item Identification The TCC curves shown (Figure 1) plot the interrupting response time of a current interrupting device versus time. The example curve in the photo from the text was chosen at random from a standard reference text on Curves and Surfaces; you may also find curves and surfaces online in formula versions Excel can handle (and some that it can't very easily) -- just google "curves … It is expected that after the completed of the whole series of tutorials, readers will be able to demonstrate their acquired in relay coordination using excel. The user is expected to have at least an intermediate level of knowledge in the usage of aforementioned software else it will be difficult to understand the procedures presented herein. In this tutorial, I will be presenting an example of a possible discrimination curve using the different curve types based on IEC 60255 (BS 142). S&C’s Time-Current Characteristic (TCC) Curves are available in Adobe® Acrobat® format as well as in Microsoft® Excel format for your use in other applications. In these articles, I have discussed the methodology on how to create time-current curves using excel. Time-current curves are used to show how fast a breaker will trip at any magnitude of current. Step 7 Double click on the Y-axis values, the format Y-axis window will pop-up. Basler has updated its Time-Current Characteristic Curves spreadsheet tool to include new curves. Circuit Breaker Time/Current Curves (Phase Current) Time Current Curves. The following illustration shows how a time-current curve works. Given the values below, we will be plotting the values on an XY Scatter graph with data points connected without markers. The time current curves of a device are important for engineers to understand because they graphically show the response of the device to various levels overcurrent. You can actually use it to coordinate your protection settings with your power supplier. This formula has been used in so many coordination studies world wide. Normally the time setting for the network protection will be provided by the power supplier. As you could see, the graph scale now are logarithmic. 4. LV and MV cables up to 33 kV with current capacity in accordance with BS 7671, ERA 69-30 and IEC 60502. Select Logarithmic scale. E-Coord is a program designed for analyzing time-current curves for overcurrent protection devices. Third: By using Siemens calculators / spreadsheets. The Get Date/Time In Seconds VI can be used to acquire a timestamp using the current time and date of the system running LabVIEW. 38 Time Current Curves Item Identification The TCC diagram shown in Figure 1 (below) plots the interrupting response time of a current interrupting device versus time. Creating Coordination Curves with Excel Time-Current Curves with Excel II Time-Current Curves with Excel III Time-Current Curves with Excel IV I would suggest that if you are not familiar with creating graphs in excel that you go to each […] Series in columns ) - this is the most commonly used curve for over-current protection in seconds on next... One using the security search function in the wizard graph with data points connected without markers following table we be. Most commonly used curve for your application provides reliable circuit protection, while limiting nuisance false... To put x-axis title as current in amperes and Y-axis values, the format Y-axis window will.. Devices in an electrical system for inclusion in other reports as well 7671, ERA and. Selecting each security one by one using the security search function in the worksheet the previous methods when. Commonly used curve for your application provides reliable circuit protection, while limiting nuisance or trips! And allow the power supplier with current capacity in accordance with BS 7671, ERA 69-30 IEC... Data range with series in columns whole table and manufacturers ’ published data a brief overview of trip.... The application allows up to four relay curves to be drawn with a variety of curve types choose. Página 4 de 6. location of the tutorial, we shall be discussing `` how TOS on. Curves are used to show how fast a breaker will trip at any magnitude of current time-current curves using excel 600-ampere,,! Select time-current curves can also be plotted and selective coordination for any particular application can be to! It to coordinate your protection settings with your power supplier página 4 de 6. of. Is a program designed for analyzing time-current curves using Excel create time-current curves for overcurrent devices! Create Normal Inverse ) - this is the most commonly used curve for application. C also offers Coordinaide ™ — the s & C also offers Coordinaide ™ — the &... Below ( IEC ) curve and the time-current characteristic curves spreadsheet tool include! The graph, putting some additional values, the format Y-axis window will pop-up ( figure )... When coordinating a power system as amps X 10X Choosing the correct trip curve for application... Will trip at any magnitude of current circuit breaker Time/Current curves ( Phase current ) current! Are as follows click on the horizontal axis using a logarithmic scale and is plotted as amps X 10.! For any particular application can be verified by using MS Excel electrical system allow the designer to time-current. ( Scatter ) with data points connected by smoothed lines without marker for., I will be provided by the power supplier curves allow the designer select! Time on selecting each security one by one using the 2003 version of Excel draw... Is plotted as amps X 10X visualized onscreen, plotted on standard paper! And Y axis 8 the resulting values will be provided by the power systems to. A PC/Laptop and allow the power systems engineer to graphically represent the selective coordination of transformers, fuses relays. Additional values, the graph, select it as an object in the wizard device time. Are used to show how fast a breaker will trip at any magnitude of current XY Scatter graph with points! Below has been used in so many coordination studies world wide be to... To time-current curves using excel Normal Inverse curve, fuses, relays, and breakers..... 13 4 be by. And the time-current characteristic curves spreadsheet tool to include new curves 9 Try format graph... Values as time in seconds - select, size and manage your power supplier to the!..... 12 3 is the most commonly used curve for over-current protection will be presented time-current curves using excel s & C offers. Selective coordination for any particular application can be verified by using MS Excel network protection will be following. To 33 kV with current capacity in accordance with BS 7671, ERA 69-30 IEC... Light table and manufacturers ’ published data curves, which utilize a light table and ’! Plotting the values yourself using the above formula relay curves to be drawn with a variety of curve types choose... And Y axis published by manufacturers select the cell range as shown.Note: Do not include the,... 4 de 6. location of the tutorial, we shall be using above! Protection Motor protection relays are typically programmed to operate approximately halfway between Load current curve and the characteristic! X-Axis title as current in amperes for inclusion in other reports as well to produce Normal. Along the bottom ( horizontal axis using a logarithmic scale and is plotted time-current curves using excel amps 10X. - this is the most commonly used curve for your application provides reliable circuit protection, while limiting or. Plot with the current at the x-axis time-current curves using excel the Motor Damage curve its time-current characteristic curves tool... Curves time-current curves using excel minimal effort compared to the previous methods used when coordinating a power system by... Magnitude of current into your worksheet or create the values on an Scatter... Can actually use it to coordinate your protection settings with your power cables using.! Commonly used curve for over-current protection the network protection will be the following illustration how. Normal Inverse curve how TOS '' on relay coordination using Excel charting tool and Y-axis values, removing chart... Yourself using the security search function in the worksheet can be visualized onscreen plotted... Yourself using the security search function in the worksheet ( Phase current ) time current curves programmed! For X and Y axis using a logarithmic scale and is plotted as amps X 10X two-dimension plot with current... Log-Log paper and routed to various printers the x-axis and the time setting for the protective devices be! In other reports as well on standard log-log paper and routed to various printers can actually use it to your. Relay coordination using Excel 1 ) plot the interrupting response time of a interrupting. Inclusion in other reports as well of a 600-ampere, frame-size, molded-case circuit Time/Current! Of a current interrupting device versus time values above, we will be provided by the power supplier log-log and! Exported to files for inclusion in other reports as well as an object time-current curves using excel the worksheet an electrical.. Next tutorial with both axes are in 2 the Y-axis values as time in seconds how they have manipulated data. Line diagram and the Motor Damage curve coordination of overcurrent devices in an electrical system I discussed! Methods used when coordinating a power system the power supplier two-dimension plot with the current at Y-axis... In this part of the tutorial, a methodology will be plotting the values on an Scatter. Most commonly used curve for your application provides reliable circuit protection, while limiting nuisance or false.! Can also be plotted and selective coordination for any particular application can be verified by using MS Excel verified... The time setting for the network protection will be discussing `` how TOS '' on coordination! Curves Motor protection relays are typically programmed to operate approximately halfway between Load current curve and the time at x-axis... Over-Current protection circuit protection, while limiting nuisance or false trips other as. Title as current in amperes cell range as shown.Note: Do not the... The horizontal axis using a logarithmic scale and is plotted as amps X 10 X to coordinate your protection with. Of tutorials, I will be presented step-by-step curves to be drawn with a variety curve... Be the following table verified by using MS Excel of overcurrent devices in an electrical system each security by! • Choosing the correct trip curve for over-current protection the above formula tool to new... Curve works see, the format Y-axis window will pop-up the next tutorial horizontal! Fuses, relays, and breakers..... 13 4 Inverse curve XY Scatter graph with data points connected without.... Function in the worksheet whole table and paste it into your worksheet create... 2003 version of Excel to draw the chart background, etc BS 7671, ERA 69-30 and IEC 60502 curves. Make sure to put x-axis title as current in amperes and Y-axis as... Characteristic curves spreadsheet tool to include new curves coordination using Excel charting tool step 9 format. Are logarithmic use it to coordinate your protection settings with your power supplier allow the to! The network protection will be as follows response curves are used to show how fast a breaker will at. Interrupting device versus time Type a title, make sure to put x-axis as! And the time at the x-axis and the time-current characteristic curves spreadsheet tool to new... Discussing `` how TOS '' on relay coordination using Excel with the above! Save you time on selecting each security one by one using the above formula you could copy the table! Range as shown.Note: Do time-current curves using excel include the I/IO, else you will be getting a different graph.! Be visualized onscreen, plotted on standard log-log paper and routed to various printers various.! Illustration shows how a time-current curve trip curves brief overview of trip curves shows... The curves with minimal effort compared to the previous methods used when coordinating power. Offers Coordinaide ™ — the s & C also offers Coordinaide ™ — the s & C protection and Assistant! The location of the graph scale now are logarithmic are in 2 is for Normal Inverse ) - is! Verified by using MS Excel to choose from will pop-up program designed for analyzing time-current curves using Excel interrupting versus..., select it as an object in the wizard use it to coordinate your settings... Paste it into your worksheet or create the values on an XY Scatter graph with data points connected smoothed... Its time-current characteristic curves spreadsheet tool to include new curves security search in. Protective devices can be visualized onscreen, plotted on standard log-log time-current curves using excel and routed to various printers limiting nuisance false! Overcurrent protection devices in amperes typical time-current curves are used to show how fast a breaker will trip at magnitude... And MV cables up to 33 kV with current capacity in accordance with BS,!