Short Circuit Calculation Spreadsheet

Post by J Daniel | 11/06/2019 | Spreadsheet App, Spreadsheet Sample | 4638 Views | No Comments

Short Circuit Calculation Spreadsheet – Simple tool designed for data estimation and conservative short-circuit scenarios. In this way, it automatically applies the coefficients and factors of the ANSI and IEC standards, compares the results with the data published by manufacturers and also emits alarms and warnings when the devices exceed their capacity.

The review and verification of standards is ongoing to ensure its permanent validity.

The Short Circuit module and the Protective Selectivity module are perfectly integrated with the Electric Arc module to carry out the calculation of risks due to the presence of an electric arc.

 

General Capabilities

Calculation of faults intensities (faults) three-phase, single-phase (L-G) and two-phase (L-L, & L-L-G).
Evaluation of devices according to current total or maximum missing.
Automatic adjustment of resistance and length of conductors (both lines and cables)

Global or individual adjustment of tolerance in the impedance of devices for maximum or minimum fault current.
Modeling fault impedance for unbalanced faults.
Admittance in parallel (shunt) for branches and capacitive loads (unbalanced faults)

Graphical selection or in a bar chart to calculate the fault current.
It automatically determines the missing current in motor terminals without the need to add additional bars.
The phase shift introduced by the transformers can be included in the calculation.

Earthing models for motors, generators and transformers.
It allows calculating the contribution of engines according to load category, demand factor or both.
Availability to verify the data sheets of manufacturers included in the bookstores.

 

ANSI / IEEE regulations

Evaluation of equipment in single-phase and panel systems
Determines the maximum and minimum fault current
Calculation of the current of ½ cycle, of 1,5-4 cycles, and of 30 cycles, for balanced and unbalanced faults (three-phase, single-phase and two-phase)
Verification of the momentary capacity and of interruption of the devices
Verification of closing capacity (closing & latching)
Evaluation of symmetric capacities or nominal total of the switches
Special handling of generator switches for generator and system faults
Interruption capacity depending on the contact opening time of the switch, according to regulations or defined by the user
If the user defines it, the coefficient is automatically included so as not to contemplate the decay of the CA component in the calculation of the fault (NACD)
User options for automatic adjustment of HVCB contribution levels
Generation of reports (ANSI & IEC)

1. Reports of faults in load terminals
2. Equipment exceeded is automatically highlighted
3. Current profiles (Ia, Ib, Ic, I1, I2, & I0)
4. Voltage profiles (Va, Vb, Vc, V1, V2, & V0)
5. Individual contribution of current missing for Isym, Ia, & 3I0
6. Impedance in phase and sequence (+, -, 0)
7. View of alerts that allows to visualize the violations of the marginal and critical limits
8. Export single-line diagrams to CAD file processing systems
9. Input data, detailed individual or total short-circuit contributions, and summaries
10. Visualization of results in next generation graphics.
11. Export report of results in recognizable format by editing software
12. Full-color Crystal Report® customizable viewer

 

IEC regulations

1. Evaluation of equipment in single-phase and panel systems, UPS
2. Calculation of faults intensities (faults) three-phase, single-phase (L-G) and two-phase (L-L, & L-L-G)
3. Transient short-circuit calculation IEC 61363
4. Compare the nominal capacities of the equipment against calculated fault values
5. The user can define the voltages of the “c” factor
6. Cutting capacity of low voltage circuit breakers according to nominal or maximum service capacity
7. Different methodologies are used to calculate the R / X ratio
8. The phase shift introduced by the transformers can be included in the calculation
9. Negative or positive impedance settings for max / min lk˝ & Ik
10. Automatic application of correction factors K (i.e., KT, KG, KSO)
11. Automatically determines mesh and non-mesh networks to calculate Ib, Ik, & Idc
12. The Ib value of the mesh networks is adjusted with the individual contributions of the machines to improve the accuracy
13. Short circuits are considered both far away and close to the generator
14. Generates graphics of compatible relay test sets for transient short-circuits
15. Detailed IEC team evaluation reports and full contributions for unbalanced faults

Flexible operation:

Calculation of faults intensities (faults) three-phase, single-phase (L-G) and two-phase (L-L, & L-L-G).
Availability to verify the data sheets of manufacturers included in the bookstores.
Comparison of interruption capacities (calculated vs. published by manufacturers).
Automatically takes into account all the necessary multiplying factors according to the type of calculation.
Automatically adjusts the interruption capacity of the equipment according to pre-fault or nominal voltages.
Calculation options:

1. The user defines the pre-fault (fault) voltages (ANSI) and the “c” factor (IEC).
2. Different methodologies are used to calculate the R / X ratio (IEC).
3. It allows to adjust the marginal and critical limits for verification of exceeded equipment.
4. It includes the action of thermal devices in the short circuit calculation.
5. There are no limitations on voltage levels.
6. It allows calculating the contribution of engines according to the load categories.
7. Additional impedances can be included for the calculation of ground faults.
8. Unlimited number of bars * and elements.
9. Automatic verification of errors.
10. Graphical visualization of exceeded equipment.
11. Graphic display of bars with low / over voltage.
12. Allows to simulate island subsystems.
13. Allows taking into account radial or ring systems.
14. Possibility of integrating single-phase, three-phase systems and DC systems into the same project.
15. It allows to simulate the effect of several online generators, as well as connections to external networks.
16. It allows to use library of equipment customized by the user.
17. It allows the graphical visualization of the results directly in the single-line diagram with configurable formats by the
18. user in a dynamic way.
19. Graphic visualization of impedance of equipment and earthing.
20. Take into account the effect of the impedance of feeders to motors in the decay of the contribution to the fault current (as Option)

* The maximum number of energized bars to be taken into account in the calculation is subject to the license restrictions.

 

Available calculations

1. Verification of the making and breaking capacity of cutting equipment.
2. Verification of the closing-latching and interrupting capacity of cutting equipment.
3. Automatic comparison of results for cuts in 2, 3, 5, and 8 cycles.
4. The user can define the contact parting time (ANSI).
5. Cutting cycle depending on the delay in the opening of the switch.
6. Interruption cycle based on the contact parting time (ANSI) of the switch.
7. Calculation of capacity for switches associated with generators.
8. Contribution of engines to faults according to load categories.
9. Ith calculation and capacity verification according to IEC.
10. Cable impedance adjustment by temperature.
11. Selection by user of the bars to be considered at fault (graphic or by tables).
12. Earthing models for motors, generators and transformers.
13. Effect of impedances in the calculation of ground faults (ANSI & IEC).
14. If the user defines it, the coefficient that does not include the decay of the CA component in the calculation is automatically included.
15. Option for interruption capacity reports vs. delay in the opening of the circuit breaker (IEC).
16. Effect of transformer connections on unbalanced faults (ANSI).

Calculation of single-phase circuits

Calculation of overload and evaluation of single-phase, three-phase systems, switchboards and UPS systems.
The ANSI and IEC standards are used to calculate the short-circuit current for points in the network belonging to the main frames, secondary panels, UPS and phase adapters.
The current of the devices in these networks is compared to evaluate the protection equipment and automatically generate critical alerts and marginal alerts based on the alarm limits defined by the user.

 

IEEE C37.04 Standard Rating Structure for AC High-Voltage Circuit Breakers Rated on a Symmetrical Current including Supplements: IEEE C37.04f, IEEE C37.04g, IEEE C37.04h, IEEE C37.04i

IEEE C37.010 Standard Application Guide for AC High-Voltage Circuit Breakers Rated on a Symmetrical Current

IEEE C37.010b Standard and Emergency Load Current-Carrying Capability

IEEE C37.010e Supplement to IEEE C37.010

IEEE C37.13 Standard for Low-Voltage AC Power Circuit Breakers Used in Enclosures

IEEE C37.013 Standard for AC High-Voltage Generator Circuit Breakers Rated on a Symmetrical Current Basis

IEEE C37.20.1 Standard for Metal Enclosed Low-Voltage Power Circuit Breaker Switchgear

IEEE 399 Power System Analysis – the Brown Book

IEEE 141 Electric Power Distribution for Industrial Plants – the Red Book

IEEE242 IEEE Recommended Practice for Protection and Coordination of Industrial and Commercial Power Systems – the Buff Book

UL 489_9 Standard for Safety for Molded-Case Circuit Breakers, Molded-Case Switches, and Circuit Breaker Enclosures

IEC 62271-100 High-Voltage Switchgear and Controlgear, Part 100:High-Voltage Alternating-Current Circuit Breakers

IEC 62271-200 High-Voltage Switchgear and Controlgear, Part 200: AC Metal-Enclosed Switchgear and Controlgear for Rated Voltages Above 1 kV and up to and including 52 kV

IEC 62271-203 High-Voltage Switchgear and Controlgear,

Part 203: Gas-Insulated Metal-Enclosed Switchgear for Rated Voltages Above 52 kV

IEC 60282-2 High-Voltage Fuses, Part 2: Expulsion Fuses

IEC 60909-0 Short Circuit Currents in Three-Phase AC Systems, Part 0: Calculation of Currents (including 2002 Corrigendum 1)

IEC 60909-1 Short Circuit Currents in Three-Phase AC Systems, Part 1: Factors for the Calculation of Short Circuit Currents According to IEC 60909-0

IEC 60909-2 Electrical Equipment – Data for Short Circuit Current Calculations in Accordance with IEC 909 (1988)

IEC 60909-4 Short Circuit Currents in Three-Phase AC Systems, Part 4: Examples for the Calculation of Short Circuit Currents

IEC 60947-1 Low Voltage Switchgear and Controlgear,

Part 1: General Rules

IEC 60947-2 Low Voltage Switchgear and Controlgear,

Part 2: Circuit Breakers

IEC 61363-1 Electrical Installations of Ships and Mobile and Fixed Offshore Units, Part 1: Procedures for Calculating Short Circuit Currents in Three-Phase AC

 

Templates free short circuit calculation spreadsheet, short circuit calculation xls, short circuit current calculation xls, short circuit calculation software free download, short circuit calculation formula, bussmann fault current calculator, best software for short circuit calculation, download electrical engineering program excel base, fault current calculation software free download, arc fault calculator, maximum available fault current calculator,

Incoming search terms:

• short circuit calculation excel
• calculation in spreadsheet
• short circuit current calculation excel
• circuit calculations
• estimated available fault current EXCEL spreadsheet
• low voltage circuit breaker spreadsheet
• free short circuit current calculation excel
• free short circuit calculator
• fault current calculator excel sheet
• xls short circuit calculations

Other Collections of Short Circuit Calculation Spreadsheet