Arc Flash Study Scenario Comparison Calculator

The Arc Flash Study Scenario Comparison Calculator compares two recorded study values and reports the numerical difference only when their methods, units, availability, and source records are compatible.

The result identifies:

• Absolute difference between the two entered values
• Percent difference based on the higher entered value
• Known values recorded across both scenarios
• Basis status, confirming whether the entries can be compared
• Comparison result, indicating whether the worksheet accepted the records as comparable
• Source note, confirming that both study records were identified

A result such as 0.8 entered unit and 16% shows that two compatible recorded values differ numerically. It does not establish why they differ, whether either value is valid, or whether the equipment has an arc flash hazard requiring a particular boundary, label, PPE category, or energized-work decision.

Recorded Scenario Inputs

Arc flash studies can contain values developed under different methods, editions, assumptions, equipment configurations, protective-device settings, and source data. A direct numerical comparison is useful only when the records identify a matching calculation basis.

Input field	Electrical record purpose
Scenario A method and version	Records the study method and version used for scenario A
Scenario B method and version	Records the study method and version used for scenario B
Scenario A unit basis	Identifies the entered unit used in scenario A
Scenario B unit basis	Identifies the entered unit used in scenario B
Scenario A value status	Records whether scenario A has a known value
Scenario B value status	Records whether scenario B has a known value
Scenario A value (entered unit)	Records the numeric value exactly as documented for scenario A
Scenario B value (entered unit)	Records the numeric value exactly as documented for scenario B
Scenario A source record	Identifies the document, record, or study reference supporting scenario A
Scenario B source record	Identifies the document, record, or study reference supporting scenario B

The entered values must remain in their original declared unit basis. The worksheet does not convert values from one basis to another. If one record uses kJ/cm² and the other uses a different basis, the entries are not comparable within this worksheet.

The Scenario A value status and Scenario B value status fields distinguish a known recorded value from a missing or otherwise unavailable value. The calculator reports the count of known entries as Known values.

Comparison Conditions

The calculator compares the two records only after the following fields align:

• Scenario A method and version matches Scenario B method and version
• Scenario A unit basis matches Scenario B unit basis
• Both value-status fields identify values that are present
• Both Scenario A source record and Scenario B source record are supplied

When these conditions are met, the output reports:

• Basis status: comparable
• Comparison result: Entered values comparable
• Source note: Sources recorded

These statuses support a controlled document comparison. They do not validate the underlying arc flash model, field data collection, protective-device coordination, equipment condition, or the applicability of either study record to the installed equipment.

Difference Calculation

For two compatible entered values, the calculator determines the absolute numerical difference:

[Delta = lvert A – Brvert]

Where:

\(\displaystyle A = \text{Scenario A value in the entered unit}\)

\(\displaystyle B = \text{Scenario B value in the entered unit}\)

The calculator also reports percent difference using the larger entered value as the reference:

[mathrm{Percent difference} = frac{lvert A-Brvert}{max(A,B)} times 100%]

The output retains the selected unit basis for the absolute result. If both scenarios are recorded in kJ/cm², the absolute difference is displayed in kJ/cm². Percent difference is unitless.

Calculation Example

A reviewer is comparing two records that use the same documented method and version, study-method-v1, with each scenario recorded in kJ/cm².

Field	Scenario A	Scenario B
Method and version	study-method-v1	study-method-v1
Unit basis	kJ/cm²	kJ/cm²
Value status	Present	Present
Value	4.2	5.0
Source record	record-a	record-b

The absolute difference is:

[lvert 4.2 – 5.0rvert = 0.8]

\(\displaystyle \Delta = 0.8 \mathrm{kJ/cm^2}\)

The percent difference is:

\(\displaystyle \frac{0.8}{5.0} \times 100\% = 16\%\)

\(\displaystyle \mathrm{Percent difference} = 16\%\)

With both values present, the calculator reports:

• Known values: 2 count
• Basis status: comparable
• Comparison result: Entered values comparable
• Source note: Sources recorded

The 16% result measures the separation between the two recorded numbers. It is not a pass/fail threshold and does not establish an acceptable arc flash exposure level.

Study and Field Limits

This worksheet is a record-comparison calculation only. It does not calculate incident energy, arc flash boundary, available fault current, arcing current, clearing time, equipment label data, PPE requirements, or an energized-work conclusion.

A field or engineering decision still requires review of the actual study documentation and the equipment conditions represented by each scenario. That review may include equipment identification, system configuration, source and transformer information, conductor and raceway arrangement, protective-device settings, coordination data, operating condition, and the current condition of the installed electrical system.

Electrical installation checks such as conductor ampacity, terminal rating, insulation temperature rating, current-carrying conductor adjustment, correction factors, feeder loading, branch-circuit loading, voltage drop, raceway fill, and motor circuit requirements are separate calculations. They cannot be inferred from the difference between two recorded arc flash study values.

The responsible electrical engineer, qualified person, equipment owner, and AHJ must use the applicable project documents and governing requirements when determining labels, work practices, equipment condition, or energized-work controls.

Before comparing two scenarios, use the Arc Flash Input Data Completeness Calculator to identify missing or unknown study records.