CableMatic Plus User Guide For Electrical Designer June 9, 2014 1
TABLE OF CONTENTS 1.0 Abstract 2.0 Operational Overview 2.1 Catalogs and Rules 2.2 Cable Data 2.2 Raceway Matrix 2.3 Cable Routing Rules 2.4 Batch Cable Routing 2.5 Routing Individual Cables and Route Problem Diagnosis 2.6 Data Entry and Reporting Using Wintab 3.0 Project Login and The Main Menu 3.1 When making a new project 3.2 When logging in to an existing project 3.3 Deleting a Project From List 3.4 Open DB Exclusive 3.5 The Main Menu 4.0 Administrative Functions 4.1 Scope of Administrative Functions 4.
9.4 Drop- Outs 9.5 Air Ways 10.0 Cable Data 11.0 Wire Terminations 11.1 Cable Terminations and Jumpers Input Form 11.2 CableTerminations Spreadsheet 12.0 Logistical Checks 12.1 Report A1 - Missing Critical Cable Type 12.2 Report A2 - Missing or Invalid Cable Type in Cable Data 12.3 Report A3 - Missing or Invalid Routing Data in Cable Data 12.4 Report A4 - Missing or Invalid Routing Data in Raceway data 12.5 Report A5 – Raceway Connection Warnings 12.6 Report A6 – Parallel Raceways Not Size Locked 13.
1.0 Abstract Cable routing plus the planning/tracking of cable installations are the fundamental functions of CableMatic Plus. The Design Function Using spreadsheet methods, the cable designer prepares a list of cables and includes the cable type, origin/destination equipment and service level restrictions.
2.0 Operational Overview 2.1 Catalogs and Rules When starting a new project, use the latest CableMatic Plus database template that is provided by the developer. After the new project is started, set up the project data as described in the Administration Functions section of this guide. Pay special attention to: • Conductor Sizes • Cable Type Catalog data • Raceway Types Data • Raceway Catalog Data • Raceway Service Level Data There are important relationships for this data that must be carefully maintained.
• • • • • • found in the document ‘NECRules.xls’ which will be provided by GSN Technologies, LLC upon request. When raceway utilization checking is in effect, a cable with a utilization code may not use a raceway that does not match that code. When conduit work package checking is in effect, a conduit with a work package will not be used unless cable and conduit’s work package are the same.
3.0 Project Log-In and the Main Menu Log-In Form 3.1 When making a new project or if you need to register an exsiting project, use the program MakeNewProject (use the button to Make or Register a Project) 1. Enter the project number and Project Name. The project number must be the same as the number in the database name. The project name is used to help identify the project because numbers are often difficult to remember. 2. Enter the model path for the project. 3. Enter the Employee ID.
5. You may manually change the employeeId. This ID is used to identify your Wintab spreadsheet file (ex: c:\CMP-ProjectId-Jerry.tbl). 6. The password is not required unless you require administrative privileges. 7. Press Open Project . 3.3 Deleting a Project From List: 1. Use the program MakeNewProject to remove the project from your list. It will not actually delete the project. 3.4 Open DB Exclusive 1.
4.0 Administrative Functions 4.1 Scope of Administrative Functions The administrator is responsible for maintaining project data that includes catalogs, cable segregation, design control rules, cable segregation rules and cable wire color data. In addition, the administrator should be making the releases. 4.
4.2.2 Making a Release and Effect on The Construction Database This function applies only when the Live Database on the Project Data form is unchecked. Internal releases for design usually use the letter codes A, B, C, etc. When making the first internal release, press the command to clear the last released database and then set the current open revision to ‘A’. Then press ‘Issue’. The issued database will have the same name as your current database and will have the suffix ‘A’.
database and will have the suffix ‘0’. When making the next issue, make sure that your revision rules data is correct and then press the issue command. Cable and raceway revision letters are assigned by comparing the current database with the last issued database. You do have the ability to reset the last issued database but this should not be done without considering the ramifications to the field. Send the released database to the field.
4.3. Live Database and the consequences for Construction When the Live Database is checked, Design and Construction share the Designer’s database. Both disciplines cannot change the other’s data. The concept f Last Snap Shot database (see above) is the same as Last Released Database. Raceways are handled the same way as before and cables will have their revision advanced by 1 every time, a designer changes significant data.
• 4.4.2 Voltage Classes Voltage Classes are restricted to: <=2KV POWER, >2KV POWER, ANY MIXTURE and CONTR/SIGNAL. 4.5 Service Levels and Cable Segregation Rules Raceway service levels and cable segregation codes are limited to two characters. Input a comma delimited list of cable segregation codes that may be used for each service level. When you enter raceway data, the raceway service level must be on of the values you input to this table.
appropriate value. You will find corresponding data in Cable Types where you will enter the number of current carrying conductors. 4.6 Raceway Types and Cable Segregation Rules Raceway types must begin with the words ‘COND’ or ‘TRAY SOLID’, ‘TRAY VENTED’, ‘TRAY WIREWAY’ or ’TRAY LADDER’. Other types include ‘DROP OUT’, ‘AIR WAY’ or ‘GUIDE CONDUIT’ which have special meaning to CableMatic. When inputting ‘TRAY something’ include the height and material eg: TRAY SOLID 6G, TRAY VENTED 4G, etc.
4.7 Cable Type Catalog Data Cable type data is critical of tray and conduit sizing. The cable OD is always used for tray sizing. The override cable area is only used for conduits. Since separate ground conductors are not run in tray but are run in conduit, you should input an override cable area when the ‘Ground Conductor’ value is ‘Y” (meaning a separate ground is included with the cable). Please note that number of conductors are for one cable jacket.
4.8 Raceway Catalog Data This data is crucial for tray and conduit sizing. The raceway catalog number is either input to each raceway or CableMatic Plus will calculate it. CableMatic chooses the smallest size that matches the raceway type that is input for the raceway. The description (if entered) will be reported on the Tray and Conduit reports. Our TrayMatic program uses this data for generating conduit cross sections.
4.9 Design Control / Revision Rules When an issue is made that succeeds a previous issue, CableMatic compares the previous issue with the current issue. Only the fields that are indicated in this data will be compared. If the data is different or the component is new, the component will acquire the revision of the current open revision. In addition, CableMatic records what fields changed for each component.
4.10 Cable Wire Colors This data facilitates the data preparation for cable wire terminations. The Chart Name indicated here is also input for each cable type. Be sure to use the SEQ NO to order the data. To make changes when the chart name already exists: 1) Import the data for the chart 2) Save the Wintab table (in case you make errors in the following process) 3) Delete the chart data.
5.0 Plant System Descriptions Wintab will store descriptions for the plant systems. Plant system code is input for cables and equipment and reports can be selected and sorted by this data. 6.0 Start-Up System Descriptions Wintab will store descriptions for the start-up systems. Start-Up system code is input for cables and equipment and reports can be selected and sorted by this data. Date required is input in the format of YY-MM-DD.
7.0 Work Package Descriptions Wintab will store descriptions for the work packages. Work package is input for cables and conduits and reports can be selected and sorted by this data. Once the first release database is delivered to construction, the field should maintain work package data. If this is not the case, please have the field remove all work package data in their corresponding table of their database.
8.0 Equipment Data Equipment descriptions are important data that helps in the construction activity. Data such as Bldg, Area, Sub Area Xloc, Yloc, Zloc should probably be generated from other applications. Xloc, Yloc and Zloc are intended to support the automated generation of conduits from equipment to tray. The data source field can be used to record where data came from.
9.0 Electrical Raceway Input When TrayMatic is not being used, data is input using a spreadsheet. This form lists the data entries that appears in the spreadsheet. The same data is used for all type of raceways.
9.1 Trays A tray is an electrical raceway that has at a minimum service level, raceway type, length and from and to nodes. The From Offset field should be left blank. When the size lock is not ‘Y’ , CableMatic will size the tray and select the raceway catalog number according to NEC rules. The user may change the raceway catalog number but that value should be consistent with the raceway type. To ensure that the data is consistent, select a value using the F3 key pull down.
value should be consistent with the raceway type. To ensure that the data is consistent, select a value using the F3 key pull down. When From and/or To Dwg Reference numbers are not entered, they will be retrieved from the related reference drawing numbers of the connecting equipment. If no drawing is retrieved connecting trays are used. When From and/or To Location are not entered, the From and To Point is used if it has meaning. For example, connecting equipment, man holes, stub ups and trays.
The NEC RULE OVERRIDE will override the related conductor size of the cable type to be used for Tray fill calculations.
11.0 Wire Terminations The purpose for preparing wire termination data is to offer the field a cable termination installation ticket that records the wire connections. If this data is not prepared, the a cable termination installation ticket can still be printed but the wire numbers and terminal numbers will be blank. At the very least, the designer/administrator should input the Cable Wire Colors and the chart name for each cable type. There are two methods for preparing wire termination data.
11.2 Cable Terminations Spreadsheet In th example below, data was pasted from Excel, however the number/color fields were empty in the Excel spreadsheet. When the Save Cable terminations button is pressed, any missing number/color is retrieved from The Cable Wire Colors table and Seq No is automatically input by CableMatic. There are some special methods for recording JUMPERs and NOTEs. Below are instructions which are displayed when you select the Wintab menu command - Help/For Current Table.
12.0 Logistical Checks It is very important to check data before attempting to route cables. The reports in this section are designed to identify errors, inconsistencies and missing critical data. ggh 12.
12.3 Report A3 - Missing or Invalid Routing Data in Cable Data This report will only check cables that are routed in raceway or have a route note.
12.5 Report A5 – Raceway Connection Warnings This report identifies nodes that share the connections of trays (not conduits) that have different service levels. The service level is shown after the ‘\’ next to the tray tag. In addition, it will indicate when the node type has an inconsistent amount of connected trays. Node types are indicated in the suffix of the node. Tray node types are E= End, T= Tee and X=Cross 12.
13.0 Batch Routing When the main menu command for Batch Routing is selected,a variety of options will be displayed. Only unlocked cables will be affected. If you choose to route by segregation code, you will be asked to supply a list of codes separated by commas (eg: 1,2,2S). If you want to route specific cables, you will be asked to supply the name of the text file containing the list and so you should prepare this file (use extension .txt) before you choose to use the list of cables.
13.4 Resize/Set Fill for Raceway When Finished CM+ will automatically size trays and conduits that are not ‘size locked’. In order to perform this function quickly, CM+ resizes raceway when: 1) Requested by the user. 2) After Batch Routing (if option is checked). 3) When making a tray or conduit design report (as opted) 4) When making an issue. Raceway fill is always maintained automatically during the routing process or when a cable is deleted.
14.0 Single Automatic and Manual Cable Routes CM+ provides the ability to route one cable at a time so that it is easier to diagnose problems with data. Use the Cable Data Form for this purpose. You may also use that form change cable and equipment data. 14.1 Cable Data Form The pull downs in the cable form work the same way as the pull downs in Wintab.
14.2 Commited Vias Tab Use this tab to review and existing cable route. In some cases you will want to change an existing cable route using manual input of raceway tags. You can press the button Copy Committed Vias to Design Vias and then choose the Design Vias tab. Note in the example shown, the cable enter tray TIA110 in the middle of the tray and exits tray TIA108 10 feet after it enters that tray from tray TAI110. CM+ maintains the tray fill at all points along the tray.
14.3 Design Vias Tab Use this tab to input an entire route or partial route. Edit functions are provided using the right click of the mouse. Input the raceways in the order that the cable will route. If a raceway or group of raceways are not included, CM+ will attempt to find the missing raceways. After editing the route, press Update Design Vias and then the Route button. When using the Design Vias data you must select that option in the routing form (see next paragraph).
14.4 Routing With Design Vias You do not have to enter all the raceways in the route, however please enter the raceways in the correct routing sequence. CM+ will attempt to insert any missing raceways. Errors such as incompatible service level or raceway not found will be displayed and you will be given an option to commit the cable as is. It is possible that if make an error in sequencing the raceways, CM+ may fix it. 14.5 Routing Options Here is an example where a cable rout exists for a cable.
route, CM+ will offer to lock the route. The check options are self explanatory and provide for diagnostic capability. For example, if you uncheck Tray Fill a route may be found but VM+ will indicate what raceways rays are overloaded. Utilization and work package rule checking can also be disabled. The Allocate Duct Bank conduits option is used when you want CM+ to route through conduits in a Duct Bank. If this is not opted, the CM+ will route through the Duct Bank without assigning conduits.
15.
C5) This will correct the cable route lengths that may be incorrect based upon the changes in raceway length. This is automatic when an issue is made C6) This function will refresh the EST_LEN field for each cable where the EST_LEN was not input by a user and the From/To (or ASSOC Equip) locations are available. Lengths are calculated as 1.3 times the Delta XYZ length between cable ends plus the Additional Len in Project Data.
16.0 Reporting Select one of the report types and different constraints, options and sorts will be presented. The New, Revised and Deleted reports (when checked) are provided as additional lists to the report that is requested. The Sort by feature provides choices for each main field in the report. The default sort is by the component tag and if that is the sort you want, the other sort choices will not be available.
16.
16.3 Cable Report Request Form This cable report may be a cable schedule with the cable route or a termination report which lists the termination details for the cable.
16.
16.5 Material Report Request Form Cable conduit and tray bill of material reports list quantities for the cable, conduit and tray types and sizes used. The tray material report (D43) is a basic report displaying tray length by tray type. The Tray Len and Fittings report (D44) will offer ‘DbQuery’ type of filter and will include fittings. This report uses data that is created by TrayMatic and this data will be created in the TrayMatic database when required.
17.0 Advanced Tools AT1) Cable termination data can be imported from a project’s CM+ database AT2) Uses the RENAMING table to rename components (trays, cables, conduits, equipment) . Please remove data from the Renaming table after it the process is completed. AT3) Moves the entire model to a location specified by the user. AT4) For each conduit or drop out that has 'CALC' in either the LENGTH or FROM_OFFSET field, this function will attempt to compute the value(s).
