GSN Technologies, LLC

1. GSN Technologies, LLC Custom Tray Fittings

2. SETTING UP… This process will assist you in setting up for the use of Custom Tray Fittings.

3. The Blocks Directory • All blocks that are being used in the program will be stored in a local directory. The user can choose to either: 1) Create a directory 2) Choose an existing directory • Once a directory location is decided upon, navigate to the area labeled ‘AutoCAD Blocks Directory’ on the TrayMatic Project Data Form. • Click ‘Browse for Blocks directory’ and select the location decided on.

4. Adding a Service Level • From the same ‘Project Data’ form, locate the ‘Service Level/Layer’ spreadsheet at the bottom of the page. • Navigate to ‘Edit > Insert Row’. This will add a row to the spreadsheet. • Now, add the information pertaining to your new ‘Service Level’ and click ‘OK’. This is highlighted with a yellow border on the right. Custom Fitting Example:

5. The Electrical Blocks Drop Down. Populating the list of selectable blocks to be used during design.

6. Drop Down Options • On the Tail-End tab of TrayMatic, towards the bottom of the form, there is a drop down style box. • By clicking the arrow on the right side of the box, a list of possible selections for that particular dropdown will appear. This functionality is depicted on the right. Continued on next slide…

7. All Worksheets For TM • TrayMatic decides which items will appear in drop down list by reading the database table called, “ELEC_BLOCKS”. • The user is able to enter items into this table by navigating to ‘File > Project Set Up > All Worksheets For TM’ from TrayMatic’s main menu. • Selecting this option will open GSN’s ‘DBView’ program.

8. Inside DBView Once DBView opens, navigate to ‘Tables > Elec Blocks’; as shown above. Now, enter the pertinent data in their respective fields; as illustrated above.

9. Finally… • Highlight any rows where data was entered and navigate to ‘Database > Update’; as depicted in the picture. • This will store all information into the database; which means the blocks are now selectable from the ‘Blocks’ drop down box.

10. DESIGN The following slides will illustrate the method to use blocks to perform tray routing.

11. Drawing the cable tray centerlines. **Note: Cable tray centerlines should always be drawn to the bottom of the tray (BOT). Click the video to start it.

12. The buttons the user must click are highlighted in yellow throughout the video. **Note – Double-clicking the ‘Rx’, ‘Ry’, and ‘Rz’ buttons toward the bottom of the TrayMatic form will rotate the block respectively. Adding J-Boxes to Fitting Locations Connect tray from the endpoint of the center line to the midpoint of the fitting block and be sure to set your ‘W,D,H’ to .01 in the Tail End Menu. This hides the boxes from being shown on the drawing. Click the video to start it.

13. Connecting Tray Segments Draw tray segments from fitting to fitting. Click the video to start it.

14. Connecting trays with ‘Airways’ for cable routing. Airways will be drawn as shown in the video or from end point of tray segment to end point of tray segment. This will allow for cable to be routed through the tray design. When finished, name your tray by whatever method desired and delete the centerlines created at the beginning of the process. Click the video to start it.

15. Retrieving Custom Fittings After Custom Tray Fittings Are created and saved to the database, they can be retrieved at any time using standard GSN Techniques.

16. Retrieving Custom Tray Fittings The above process will retrieve any boxes that are considered ‘Tray Fittings’. Double click the ‘N’ in the box to the right of the ‘TRAY_FITT’ retrieval code (changing it to ‘Y’) and select ‘Retrieve From TM DB’ (Highlighted in yellow)

17. Add the blocks related to the J-Boxes retrieved Once J-Boxes have been retrieved, navigate to ‘Tools > Electrical Boxes > AutoCAD Blocks > Retrieve All AutoCAD Blocks for Boxes in Dwg’ as demonstrated in the picture above.

18. Bill of Materials The following slides will illustrate the differences in the processes required to produce a Bill of Materials based on custom tray fittings in the drawing.

19. Creating the Bill of Materials Navigate as shown above for a Standard Tray and Fittings BOM Navigate as shown above for a Custom Tray Fittings BOM

20. Bill of Materials Output An example of the Bill of Materials created.

21. FINISHED! If all of the steps in this outline were followed, you now have a tray system designed with custom tray fittings, cable routing functionality, and an accurate Bill of Materials. For additional questions or comments, please contact the GSN Office at (678) 831-0725.Thank you.