2011
Table Of Contents
- Contents
- AutoCAD Electrical What's New
- Overview of AutoCAD Electrical Help
- Join the Customer Involvement Program
- What's New in AutoCAD Electrical 2011
- What's New in Previous Releases
- What's New in 2008 Release
- What's New in 2009 Release
- What's New in 2010 Release
- Ribbon Interface
- Migration
- Project Management
- Overview of projects
- Use recently opened projects
- Work with projects
- Create a project
- Add a new drawing to the current project
- Add existing drawings to the current project
- Copy a project
- Group drawings within a project
- Change the order of drawings in the project
- Remove a drawing from the active project
- Assign a description to each drawing
- Preview a drawing
- Pick a different project
- About collaborative design
- Create a drawing
- Change drawing display options
- Overview of project-related files
- Overview of the project file format
- Archive a project
- Delete a project
- Work with Multiple Clients
- Drawing List Report
- IEC tag mode update
- Task list
- Overview of projects
- Drawing and Project Properties
- Symbol Libraries
- Determine symbol block names
- Library Symbol Naming Conventions
- Overview of symbol naming conventions
- Cable Marker Symbols
- Components - General
- Component Location Mark Symbols
- Configuration and Ladder Master Line Reference Symbols
- Connector Symbols
- Hydraulic Symbols
- Inline Wire Marker Symbols
- One-line Symbols
- P&ID Symbols
- Panel Layout Footprint Symbols
- Parametric Twisted Pair Symbols
- PLC I/O Parametric Build Symbols
- Plug/Jack Connector Pin Symbols
- Splice Symbols
- Source/Destination Wire Signal Arrow Symbols
- Stand-alone PLC I/O Point Symbols
- Standalone Terminal Symbols
- User-defined Symbols
- Wire Dot Symbols
- Wire Number Symbols
- Overview of symbol naming conventions
- Split a tag name into two pieces
- Use multiple symbol libraries
- Overview of one-line symbols
- Overview of Hydraulic and P&ID symbols
- Attribute Requirements
- Schematic attributes
- Overview of schematic attributes
- Schematic parent and child components
- One-line
- Wire connection/terminal pin number pairs
- Schematic connector parametric build symbols
- Schematic terminal symbols
- Special Multiple Connection Sequence Terminal symbol
- Source/Destination wire signal symbols
- Stand-alone Source/Destination cross-reference symbols
- In-line wire labels or wire numbers
- PLC single I/O point symbols
- Splice symbols
- Parametric Twisted Pair symbols
- Overview of parent and stand-alone component attributes (TAG1)
- Overview of child component attributes (TAG2)
- Overview of schematic attributes
- Panel attributes
- Attributes for other symbol categories
- Copy attributes
- Schematic attributes
- Managing Library Symbols
- Symbol Builder
- Symbol Preview Guide
- JIC Symbols
- IEC Symbols
- Push Buttons
- Selector Switches
- Breakers, Disconnects
- Fuses, Transformers, Reactors
- Relays, Contacts
- Time Delay Relays
- Motor Control
- Pilot Lights
- PLC I/O
- Terminals, Connectors
- Limit Switches
- Pressure and Temperature Switches
- Proximity Switches
- Miscellaneous Switches
- Solenoids
- Instrumentation and Sensors
- Qualifying Symbols
- Miscellaneous
- One-Line Components
- PLC
- Generate PLC layout modules
- Insert PLC modules
- Overview of the PLC database file
- Single, Stand-alone I/O Points
- Work with PLC styles
- Create PLC I/O Drawings from Spreadsheets
- Circuits
- Component Tools
- Insert schematic components
- Insert or edit child components
- Insert a copy of a component
- Insert from catalog lists
- The schematic lookup file
- Insert from equipment lists
- Insert from panel lists
- Manipulate Components
- Swap contact states
- Component Cross-References
- Insert dashed link lines
- Follow signals
- Show signal paths
- Overview of DIN Rails
- Overview of user data records
- Wire Jumpers
- Component Attribute Tools
- Edit attribute values
- Force attributes to layers
- Manipulate component text
- Manipulate terminal text
- Move description values
- Move attributes
- Hide attributes
- Show attributes
- Rotate attributes
- Change attribute justification
- Change attribute text style
- Change attribute text size
- Rename an attribute
- Add attributes to blocks
- Set tags to fixed
- Retag components
- Change to multi-line text
- Add location codes
- Update child codes
- Location Mark Symbols
- Location box
- Modify library symbols
- Wire/Wire Number Tools
- Overview of wires
- Use wire layers
- Change wire types
- Insert wires
- Insert multiple wires
- Interconnect components
- Trim wires
- Stretch wires
- Bend wires at right angles
- Overview of wire color/gauge labels
- Insert in-line wire markers
- Cable Markers
- Wire Gaps
- Ladder Tools
- Wire Numbers
- Signal Arrows
- Wire Sequencing
- Terminal Tools
- Point-to-Point Wiring Tools
- Project-Wide Tools
- Icon Menus
- BOM and Catalogs
- Reports
- Generate reports
- Schematic Reports
- Generate schematic reports
- Bill of Materials reports
- Component report
- Wire From/To report
- Component Wire List report
- Connector Plug report
- PLC I/O Address and Description report
- PLC I/O Component Connection report
- PLC Modules Used So Far report
- Terminal Numbers report
- Terminal Plan report
- Connector Summary report
- Connector Details report
- Cable Summary report
- Cable From/To report
- Wire Label report
- Generate a schematic report
- Generate schematic reports
- Panel Reports
- Overview of format files
- Run automatic reports
- Export/Import spreadsheet data
- Create user-defined attributes
- Export to Autodesk Inventor Professional
- Panel Layout
- Overview of panel layouts
- Overview of footprint attributes/Xdata
- Panel drawing configuration and defaults
- Relationship between schematic drawings and panel layouts
- Footprint/Terminal Insertion
- Insert panel footprints from a schematic list
- Insert panel footprints using vendor menus
- Insert panel footprints using icon menu
- Insert panel footprints manually
- Insert panel footprints from a catalog list
- Insert footprints from an equipment list
- Insert a copy of a panel footprint
- Use panel templates and assemblies
- Footprint/Terminal Edit
- Layout Wire Connection Annotation
- Lookup Files
- Item Numbers/Balloons
- Nameplates
- Panel Leveling/Sequencing Tools
- Conduit Tools
- Conversion Tools
- Miscellaneous Tools
- Tutorials
- Introduction
- Projects
- Title Block
- Wiring
- Schematic components
- Wire layers
- Circuits
- Surf
- Block swap
- PLC
- Schematic terminals
- Wire numbers
- Panel layout
- Generating reports
- Connector diagrams
- P&ID and Hydraulic diagrams
- Symbol Builder
- Migration of AutoCAD Data
- Interoperability: Inventor and AutoCAD Electrical
- Introduction
- Introduction (continued)
- Part 1: 2D to 3D
- Rename component tags
- Export to XML
- Set the project
- Open the dataset
- Add harness segments
- Add harness segments (continued)
- Import the AutoCAD Electrical data
- Issues
- Assign missing RefDes
- Finish the Import
- Route the wires into the harness segments
- Part 2: 3D to 2D
- Create wires
- Create Wires (continued)
- Route wires
- Export to XML
- Import the Inventor data
- Summary
- Advanced Productivity
- Set up peer-to-peer component relationships
- Create automated pin assignments
- Set up AutoCAD Electrical for multiple users
- Show source and destination markers on cable wires
- Use the PLC Database File Editor
- Customize Circuit Builder
- Circuit Builder overview
- Circuit Builder spreadsheet
- Circuit Builder drawing templates
- Circuit Builder database
- Add a new circuit
- Circuit Builder - How to
- Overview
- Add a multiple catalog option
- Assign different attribute values on a multi-pole insert
- Assign attribute values using AutoLISP
- Conditionally trim or remove a wire segment
- Conditional component insertion
- Control the multi-pole insertion direction
- Control the bus wire spacing
- Define the wire type
- Define the wire type as no wire numbering
- Format the numeric tag of the motor symbol in a wire number
- Format the numeric tag of the motor symbol into other component tags
- Link a child contact to the parent
- Map motor parameters to the motor symbol attributes
- Override the default tag format
- Override the default wire number format
- Predefine attribute values
- Predefine attribute values using annotation presets
- Predefine a wire number
- Set circuit element defaults
- Set up component auto-sizing
- Stretch and connect wiring from a nested template
- Overview
- Build your own symbols
- Add your own symbols, circuits, and commands to the icon menu
- Configure projects for various drawing standards
- Use Autodesk Vault with AutoCAD Electrical
- AutoCAD Electrical Command
- Index
NOTE This new format becomes the default the next time you extract a BOM
report.
The BOM data in the Report Generator dialog box is reformatted and
displayed.
6 Scroll down the report to verify that the component tags column is
removed.
7 Insert the new version of the BOM table into the drawing.
Exporting Bill of Material report to spreadsheet
You can move your BOM to a spreadsheet, database, or any other application
that can read data in a comma-delimited or Microsoft
®
Access
®
format.
Export the BOM to an Excel
®
spreadsheet
1 In the Report Generator dialog box, click Save to File.
2 In the Save Report to File dialog box, select Excel spreadsheet format (.xls)
and click OK.
3 In the Select file for report dialog box, enter an output file name or click
OK to accept the default name BOM.xls. Click Save.
4 In the Optional Script File dialog box, click Close - No Script.
5 In Excel, click File ➤ Open.
6 Browse to the location where you saved the spreadsheet. The default is
C:\Documents and Settings\{username}\My Documents or
C:\Users\{username}\My Documents on a Windows Vista or Windows 7
installation. Select the spreadsheet.
7 Click Open.
Your BOM data displays in spreadsheet format. You can slide the column
borders to expose the full column of text for each field. The first six columns
Exporting Bill of Material report to spreadsheet | 1873