Relay Protection Setting Calculation Excel Plugin

You can use specialized Excel templates and spreadsheets to calculate and document relay protection settings, including IDMT, overcurrent, and distance relays, with built-in formulas and curve plotting features.Excel Templates and PluginsECalPro Relay Settings Record Template This Excel template allows you to document relay settings for coordination studies and maintenance audits. It includes fields for relay tag, model, location, rated current, CT ratio, pickup (Is), time multiplier (TMS), curve type, highset, and definite time settings. Dropdown lists and conditional formatting help track overdue tests. While it is primarily a record-keeping tool, it integrates with ECalPro's online Protection Coordination Calculator for generating and verifying time-current curves .Romero Engineering Spreadsheets Romero Engineering provides free Excel spreadsheets for various protection calculations:Inverse-time overcurrent plotting (SEL "U" and IEEE curves)Loss-of-field element settings for generatorsTransformer phase differential tap calculationsPOTT scheme visualization for SEL 400 series relaysSymmetrical components conversion These spreadsheets allow plotting, calculation, and visualization of relay elements directly in Excel .CYME Protective Device Analysis Excel Tools CYME software offers Excel-based tools to analyze time-current curves, verify coordination between devices, and simulate sequences of operation for faults. It includes a library of over 100,000 protective device curves and can calculate precise time and current margins to prevent misoperation .Protection Relay Calculation Spreadsheets Several online resources provide Excel spreadsheets specifically for IDMT overcurrent relays (50/51/50N/51N), thermal relays, and other protection devices. These spreadsheets automate calculations for pickup currents, TMS, and coordination curves, reducing manual errors and saving time .Key Features to Look ForAutomated Calculations: Pickup current, TMS, highset, and definite time settings.Curve Plotting: Ability to visualize IEC or IEEE standard time-current curves.Coordination Verification: Check selectivity between upstream and downstream devices.Documentation: Maintain a structured relay settings register for audits and maintenance.Compatibility: Works with Microsoft Excel 2016 or later, Google Sheets, or LibreOffice Calc. Some advanced dropdowns and conditional formatting may require Excel .RecommendationsFor documentation and basic calculations, start with the ECalPro template.For detailed coordination studies and curve plotting, use Romero Engineering spreadsheets or CYME Excel tools.Always verify calculations against manufacturer relay manuals and IEC/IEEE standards to ensure proper protection coordination. These Excel tools provide a practical, cost-effective way to perform relay protection setting calculations, visualize curves, and maintain accurate records for substation or industrial power systems.