by Pat Murnen, SME/Technical Writer, Autodesk Manufacturing
This page is dedicated to providing you with tips and tricks for AutoCAD Electrical. Look here for tips on working in the wiki.
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 to include it 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.
{flowplayer('http://wikihelp.autodesk.com/@api/de.../=setupuda.flv', 635, 503)}}
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.
The Din Rail is generated based on data held in a Microsoft Excel spreadsheet called WDDINRL.XLS. Each row in the main worksheet, DIN_RAIL, represents a rail type. The Manufacturer, Catalog, and Description fields are used to create the drop-down list on the dialog box. In addition, each rail type has a corresponding worksheet named to match the catalog number. This worksheet defines some parameters based on the number of slots calculated from the rail length.
Click here to find out more about the spreadsheet used by the Din Rail generator.
Post-process the report with a custom lisp function before saving the report to a file or inserting as a table onto your drawing.
Click here to download example user post files for various reports.