External Cable Sizing Catalogue
- Last UpdatedJul 25, 2025
- 4 minute read
Cable sizing templates must be added to the External Cable Sizing Catalogue.
To open the External Cable Sizing Catalogue, click Select in the Grids and Schedules section of the Home tab. Select External Cable Sizing under the Catalogue heading from the list of grids that is then displayed. The External Cable Sizing Catalogue grid is then displayed:
Refer to Working with the Data Grid for further information on the grid controls including selecting a record, and sorting and filtering the grid data.
External Cable Sizing Catalogue - List Tool Options
The following options are located on the List Tools - External Cable Sizing Catalogue tab:
|
Records Section |
|
|
Refresh |
These common options are also located on the Home tab. Refer to the Common Functionality User Guide for further information. |
|
New |
|
|
Edit |
|
|
Delete |
|
|
Actions Section |
|
|
Open |
Used to open a template in the External Cable Sizing Design window, which is used to map Electrical fields to cells in the template. Refer to Map Database Fields to Cable Sizing Template Cells for further information. |
|
Open in Excel |
Used to open a template in Excel. Refer to Open Templates in Excel in this topic for further information. |
|
Revisions |
Used to view a list of all templates and their revisions. Refer to Template Revisions in this topic for further information. |
|
Printing Section |
|
|
Number of Copies |
Used to select the number of copies of templates required for printing. Refer to Print Templates in this topic for details. |
|
Print Forms |
Used to print selected templates. Refer to Print Templates for details. |
Add New Templates
To add a new template to the catalogue:
-
Click New in the Records section of the Home tab to display the Template Information window:
-
Enter the name and description of the template in the fields provided.
-
Click the button in the File Name field to browse for and select the template. Its file name is then displayed in the field. The template can be viewed in Excel by clicking the Open button.
-
Enter the number of columns and rows in the Spreadsheet Layout fields.
-
The Current Revision field is automatically completed and will be blank for new templates.
-
Click OK to add the template to the catalogue.
-
When templates are added to the catalogue they are automatically placed in the cable sizing folder defined for the project (entered in the Ext CS Template folder field of the Project Data window - this folder also contains a sample template).
Edit Templates
To edit a catalogue template, select it in the grid and then click Edit in the Records section of the Home tab to display the Template Information window:
Edit the details as described in Add New Templates.
Delete Templates
To delete a catalogue template, select it in the grid and then click Delete in the Records section of the Home tab.
If the template has been associated with equipment, it cannot be deleted. A message is displayed to inform the user of this.
Otherwise, the following window is displayed:
|
Delete from List Only |
Delete the template record from the catalogue (does not delete the actual Excel template file - if it exists). |
|
Delete Cable Sizing Template File Only |
Deletes the Excel template file (does not delete the template record in the catalogue). |
|
Delete from List and Template File |
Delete both the template file AND remove the record from catalogue. |
Click Delete to continue or Cancel to exit.
Open Templates in Excel
To view and edit a template in Excel, click on it and Open in Excel in the Records section of the Home tab.
Templates can also be opened in Excel by clicking Open in the Template Information window.
Template Revisions
When first added to the catalogue, a template will have no revision. Templates are automatically assigned new revisions whenever it is edited and saved in the External Cable Sizing Design window.
To view a list of all revisions of all templates in the catalogue, click Revisions in the Actions section of the List Tools - External Cable Sizing Catalogue tab. The Revisions window is displayed:
To view the revisions for a single template, click on the + icon next to its listing.
To view revisions for all reports, click Show All Revs.
Print Templates
To print a template or template, select them in the catalogue grid.
Enter the number of each selected template to be printed in the Number of Copies field in the Printing section of the List Tools - External Cable Sizing Catalogue tab, then click Print Forms.