Pat Murnen's AutoCAD Electrical page

User-Defined Attributes and Export to Spreadsheet

The intended purpose of the User-Defined Attributes is to add report fields to the standard reports. But, the Export to Spreadsheet feature also uses the User-Defined Attributes in some cases. Say you have added a STORES attribute to your schematic components to hold some company-specific information and you want it included in the exported Components spreadsheet. Add it to the User-Defined Attributes list and it is automatically added to the Components export next time you Export to Spreadsheet.

1. Set up the User-Defined Attributes

2. Export to Spreadsheet

TIP: Add the User-Defined Attribute names to the wd_xls_all_template.xlt worksheets to include these fields with the General export option. The default location for the spreadsheet template is C:\Program Files\Autodesk\Acade {version}\Support.

Din Rail Spreadsheet

The DIN_RAIL worksheet of the wddinrl.xls file defines each din rail.
 

A few special fields for non-standard din rail.

In addition to the DIN_RAIL worksheet, you can define a worksheet specific to a particular din rail type to define mounting hole/bracket placement. The worksheet name must match the CAT value for the din rail on the DIN_RAIL worksheet.

The specific CAT worksheet has a SLOTQTY column and as many ORG_LIST column saas necessary to define the hole/mounting bracket placement.

SLOTQTY - Start at 1 and go to the maximum number of slots per din rail piece, that is the number of slots if the din rail is at its maximum length.

ORG_LIST - Defines which slot to place the hole/mounting bracket.