Multi-Sheet Switchboard Summary Report - Intergraph Smart Electrical - Help - Hexagon

General

The multi-sheet load summary report includes the following:

• a cover sheet

• a general notes sheet

• a switchboard summary sheet that shows all the PDBs included in the report and their properties

• a transformer sizing sheet

• a bus summary sheet for each bus belonging to the PDBs in the report

Displaying Plant Item Values for Plant Operating Cases

Just before the software starts generating your report, it automatically opens a dialog box which allows you to select the plant operating cases for which you want to run the report. As a result, the generated report will contain sets of load data, each set for a different operating case that you select. This way you can compare the various bus loadings at different operating cases and use them as a basis for equipment sizing. If only one operating case exists in the plant, the software generates the report without opening this dialog box.

Prior to generating your report, select an appropriate template that enables case data. The following templates are available with the shipped reports:

• Multi-Sheet Switchboard Summary.xlsm

• All Feeder Load Summary.xlsm

Calculations Based on the Largest Non-Continuous Load

When you generate a report based on the largest non-continuous load (see Calculate Bus Loading According to the Largest Non-Continuous Load), the report displays special indications to this effect.

• The report title states that the report is calculated according to the largest non-continuous load.

• At the bottom of the report, in the Notes section, the report contains an explanation of how the values in the active and reactive columns have been calculated.

• In case the bus loading calculation has been made based on the largest non-continuous load, a background color is used to mark the active and/or reactive values of the largest non-continuous load regardless of whether it's a load directly connected to the bus or rolled up from one of the downstream buses.

• In case the bus loading calculation has been made based on the sigma of the non-continuous loads, no background color is used to mark the largest load.

• If the largest load comes from a downstream feeder circuit that feeds downstream buses, the software adds and shows the downstream largest load item tag and its kw and kva values to enable you to double-check these values if needed. There can be up to three loads with a total of up to six lines, two for each operating mode: the largest intermittent kw, largest intermittent kvar, largest spare kw, largest spare kvar, largest stand-by kw, and largest stand-by kvar.

• The bus totals also show the equation and the values that the software used to make the calculations.

• In case the software detects that the largest load is one of the loads connected to a downstream bus, the report also shows the following:

  • The active and reactive calculated values of the relevant circuits are marked with a background color.

  • The name of the largest load appears below the circuit values.

  • The full equation used to make the calculation is shown at the bottom.

• When using a feeder-incomer connection within the same PDB, the calculation will be the same as for a coupler-riser connection. Therefore, all the results in the switch gear worksheet will display a summation of all buses instead of the upper drilled down peak value of the upper bus.

The Report Scope

The scope of the report is as follows:

• For a registered report, the report includes all the buses in the current plant (belonging to all the PDBs in the plant). Note that you can define the scope by applying a custom filter to your registered report.

• For a plant report, the scope includes only the buses that belong to the PDBs that you select for the report.

• The software takes into account any existing equipment that is connected in parallel.

Adding Rows Above the Grids:

1. In Smart Electrical, select Reports > Edit and select the Multi-Sheet Switchboard Summary template.

2. In Excel, select Add-Inns and then Options.

3. On the Report Options dialog, increment the number that appears in the Rows in report header. Note that the minimum number of headers in the report is 13.

4. Then on the Switchboard Summary, Transformer Sizing, and Template sheets of the report template, right-click an empty row above the grid and select Insert.

5. Type in the required text in the new row.

6. Repeat steps 4 and 5 the number of times for each added row. If, for example, you increment the number of rows by 3, perform steps 4 and 5 tree times.

Defining a Filter for the PDBs to Be Included in the Report

You can filter a registered report which is based on a report template. This way you can determine which PDBs (and their buses) will be included in your report. The excluded PDBs, although not shown in the report, will be fully accounted for in the overall calculation.

Make sure that the report which you are going to filter is a registered report.

1. In the Filter Manager, create a new filter.

2. Make sure that on the Add Filter dialog, you select Power Distribution Board from the Filter for list.

   
   
   In the example shown above, only the PDBs whose item tags include "LS" and "LM" will be included in the report.

3. In Smart Electrical, open the Registered Report Common Properties and select the newly defined filter from the Filter list.

   

The software will filter the PDBs when you run the report.

Sheet 1: Cover Sheet

The cover sheet is fully customizable. All the data is inserted by users.

• Document Title — typed in by users.

• Document Number —in case of a plant report, the document number is typed in by users. In case of a registered report, this is the name of the registered report in Smart Electrical (inserted into the report by Smart Electrical).

• Project Number — typed in by users.

Excel inserts these definitions on all the other subsequent sheets of the report.

Sheet 2: Notes and Hold Sheet

The notes and holds sheet is fully customizable. All the data is inserted by users. The project name and document number are taken from the Cover sheet by Excel.

Sheet 3: General Notes Sheet

The notes and holds sheet is fully customizable. All the data is inserted by users. The project name and document number are taken from the Cover sheet by Excel.

Sheet 4: Switchboard Summary Sheet

The switchboard summary sheet shows in a grid form all the PDBs for which the report was generated. Each row in the grid is one specific PDB and its properties. Note the following:

• All the values (apart from Revision) are generated and inserted by the software, either Smart Electrical or Excel.

• You can add more columns to the grid.

• The column header can be renamed.

• The units of measure cannot be changed.

• The project name and document number are inserted from the Cover sheet by Excel.

• The sequence of the switchboards in the grid is determined by the electrical hierarchy.

The Switchboard Summary grid:

Sheet 5: Transformer Sizing Sheet

The Transformer Sizing sheet shows in a grid form all the transformers that feed the selected PDBs except for the following:

• The transformers that reside inside in circuit internals.

• The transformers that feed the buses within the same PDB.

• The transformers that feed free-standing buses.

To include the transformer that feeds the highest level PDB, you need to add a virtual PDB with a bus above that transformer.

Each row in the grid is one specific transformer and its properties. Note the following:

• You can add more columns to the grid.

• You can rename the column headers.

• You cannot change the units of measure.

• The project name and document number are taken from the Cover sheet by Excel.

The Transformer Sizing grid:

To the right of the grid border, there is a transformer selection table which starts at R10C23 and ends at R10C40. This table contains catalog values of standard transformer rating. The formula in R14C11 is defined to select the first transformer with the rating greater or equal to the value that is calculated in the Design Margin cell, which has a default setting of 10% (which you can change if needed).

Sheet 6 (and all other consecutive sheets): Bus Summary Report Sheet

The report provides one sheet for each bus belonging to the PDBs for which the report is generated. The buses are sequenced according to their electrical hierarchy. All the values are calculated and inserted by Smart Electrical. The data above the grid is taken from the Cover sheet by Excel.

Note that the compensated total values depend on the user preference setting (rated or consumed). For details, see the IMPORTANT note below.

The report has the following sections:

Direct Loads

Lists all the loads connected directly to the current bus. All the values are generated and inserted into the report by Smart Electrical.

Loads Connected by Converting Equipment

Lists all the loads connected indirectly through converting equipment to the current bus.

Converting Equipment Losses

Lists all the converting equipment items for which contribute to power losses. Note that this section appears only if you have selected the Account for converting equipment power losses check box on the Reports tab of the Preferences dialog.

Circuits

Lists all the buses that are connected downstream under current bus, regardless of whether the buses are connected directly or through converting equipment. The data shown here is feeder totals.

Circuit Totals

The sum of all the loads that appear in the grid for each individual row.

Compensated Peak Load

Shows the total compensated peak total value.

Compensated Running Load

Shows the total compensated running load value.

See also All Feeder Load Summary Report for more details.

Note the following for all the sheets in the report:

• For all the operating mode values (continuous, intermittent, standby, and spare), the values in all the grids depend on your selections on the Load Summaries and Reports tab of the Preferences dialog:

  

  The settings here do not affect the Compensated Peak Load and Compensated Running Load totals.

  Also note the following:

• Do not change the text in the Name box of Excel unless you want to redefine the way the report functions.

• Do not change the formulas Formula box of Excel.

• Do not change the position of the columns that have a reference in any of the formulas.

• You can add columns on the right of the grids.

• You can rename the column headers in the grid (apart from the unit of measure headers)

• You can add any text that you need above the grid.