The Arc Flash Scenario Comparison Report contains the buses and scenarios based on your selections in the one-line and in the Scenario Comparison Report Options dialog box (see Scenario Comparison Report Options). The base case is listed first, and then the scenarios are listed alphabetically. The scenario that has the highest incident energy for any bus is identified as the “worst case” for that bus.
You can print this report, export it to Excel, export it to a CSV file, or print arc flash hazard warning labels from this spreadsheet view.
The columns on this report are similar to those for the Arc Flash Hazard Spreadsheet. See Spreadsheet Column Headings for more information.
The Arc Flash Scenario Report includes a Default view. In this view, the boundary distance units for arc flash are set to inches and a predetermined selection of available columns are displayed.
The Arc Flash Scenario Report also has configurable views. This enables you to select the boundary distance units and the columns that appear in the report.
To add a new view:
Figure 1: Manage Arc Flash Views Dialog Box
Figure 2: Manage Arc Flash Views - Adding a New View
The Arc Flash Scenario Comparison Report can show either all scenarios for each bus or just the worst case scenario for each bus. To change the view, select either All Scenarios or Worst Scenarios from the Scenario Comparison Report tab.
Figure 3: Scenario Comparison Report Tab for Arc Flash
The red 'X' identifies the worst case scenario for each bus.
Figure 4: Viewing All Scenarios for Each Bus
When viewing the worst case for each bus, the report adjusts to display only the worst case scenario for each bus.
Figure 5: Viewing Only the Worst Case for Each Bus
To remove any faulted bus or equipment from view on the spreadsheet, right-click on any spreadsheet cell related to the bus or equipment and select Hide Equipment.
Note: To show equipment you have hidden on the spreadsheet, run the report again.
You can filter the results shown in the spreadsheet by clicking Filter.
Figure 6: Scenario Comparison Report Filter
You can use the filter option to limit which buses are shown in the report, based on which scenario is the worst case scenario for the bus. For example, if you expect a particular scenario to be the worst case scenario for all of the buses, you might want to show only buses that have other scenarios as the worst case. This helps you find exceptions to the expected results.
The Find feature locates specific text within the spreadsheet. As you begin typing, the program searches the spreadsheet for text that matches the text you enter. The search is not case-sensitive, but the character order must match. For example, searching ATS and ats displays the same results, but ATS 4 and ATS 04 displays different results.
The text is highlighted in the spreadsheet, and the number of occurrences where the text appears in the spreadsheet is displayed to the right of the Find box.
Figure 7: Finding Text
You can copy information to the clipboard and then paste it into another document, such as Microsoft Word® or Excel®.
First, select the cells you want to copy, and then click Copy.
To remove any result columns from the spreadsheet, right-click on the column header and select Hide Column.
Note: To show columns you have hidden on the spreadsheet, run the report again.
You can export the scenario comparison report to Excel® by clicking Excel in the Export group.
Figure 8: Export to Excel® Button
This opens the report information in a Microsoft Excel file. You can view, edit, and modify the data there.
Note: Any changes you make to the report information in Excel are not written back to EasyPower.
You can export the scenario comparison report to a CSV (comma separated value) file by clicking CSV in the Export group.
Figure 9: Export to CSV
This opens a dialog box where you can save the report information in a CSV file. You can then view, edit, and modify the data there.
Note: Any changes you make to the report information in the CSV file are not written back to EasyPower.
Figure 10: Scenario Comparison Report Print Menu - Arc Flash
You can also print arc flash labels from the spreadsheet information. See Printing Arc Flash Labels for more information.