You are currently reviewing an older revision of this page.
When a cable list is imported into Bentley Raceway and Cable Management (BRCM), a cable Type or a lookup code can be specified for each cable on the source spreadsheet. Typically, lookup codes are only used for power cables and cable types are specified for other cables such as control cables, but this is no restriction in the software.
When a lookup code is specified for a cable instead of a Type, the software can select the appropriate cable Type by using a lookup table. The selection is based on the Load and Length values assigned to the cable and is initiated by the user with the Cable Sizing tool. The Load values are specified in the cable list spreadsheet that is imported or in Cable Manager. The Length value is generally determined by the cable routing feature of the software. This document describes how to import a cable sizing lookup table from a spreadsheet.The example used in this document references the following files in the "\Detail Design\Documents" subfolder of the sample BRCM_EU_EN project.
The example will be to import a cable sizing lookup table for the "LV-400V-3_PE-VD15.Motors" lookup code.Open the CableList.xls file in Excel. Note that "LV-400V-3_PE-VD15.Motors" is specified as the lookup code for several cables:
After the cable list is imported, the lookup codes will appear in Cable Manger as values for Cable Code:
Open the CableSizing.xls file. Note that the first worksheet is labeled "LV-400V-3+PE-VD15-Motors":
The name of the worksheet is not critical, but it indicates that the worksheet contains the lookup table for the "LV-400V-3_PE-VD15.Motors" lookup code seen in the CableList.xls file or in the value for Cable Code for the cable in Cable Manager.
Open IMPORT_CableSizing.xml. This file will be specified when importing the lookup table. Note that the "Sheet" tag has a value of "1" for "number", indicating that the first worksheet of whatever spreadsheet is imported will be used.
Repeat the above process to import tables for other cable lookup codes. Modify the sheet number specified in IMPORT_CableSizing.xml to import from the appropriate worksheet of the spreadsheet.
SELECTsupport TechNotes and FAQs
Bentley Technical Support KnowledgeBase
Bentley LEARN Server
Bentley's Technical Support Group requests that you please submit any comments you have on this Wiki article to the "Comments" area below. THANK YOU!