Nate Holt's Blog

August 17, 2010

Tutorial – Using Excel with AutoCAD Electrical (Part 4 – Wire numbers)

Filed under: Electrical, Tutorials — nateholt @ 8:55 am

(Part 4 – Editing wire number assignments from Excel and then pushing the edits back into the project drawing set)

This is the 4th installment of the Excel / AutoCAD Electrical tutorial. The first three were:

  • Part 1 – Copy existing project drawing set, export “To Spreadsheet”, edit in Excel, update drawings “From Spreadsheet”
  • Part 2 – Ability to not only push edited attribute values from Excel to the drawing set, but do “block swap” as well
  • Part 3 – Enhancing the editing capabilities by adding your own custom attribute columns to an existing Excel sheet and having these work with the “From Spreadsheet” update tool

Part 4 – Wire number edits from Excel

We have the same ability to edit wire number assignments from the WNUM sheet of our Excel spreadsheet. Extract the spreadsheet as outlined in Part 1 above. Then go to the WNUM sheet…

Here we show a very small portion of one of the schematic drawings used in tutorial “Part 1″. There’s a 3-phase motor shown with the old wire number assignments and then how they show up in the “WNUM” sheet of our Excel file.

We just edit the wire number values right here in the Excel sheet. For example, we change 207B to 208-T1 and 208B to 208-T2.

When finished with our editing, we run the update “From Spreadsheet” (as outlined in tutorial Part #1) across our project drawing set and…

… the new wire numbers push out to the drawings.

If some of the existing wire numbers were “in-line” type, the gap in the wire will auto-adjust to correctly accommodate the new wire number text length.

Right from Excel you can re-assign wire numbers one-at-a-time, do global find/replace, or even create some macros to automate some wire numbering functions. Pretty cool.

Recommendation… after your edits to the WNUM sheet and you select AutoCAD Electrical’s update “From Spreadsheet” tool, consider setting the “Fixed” wire number toggle shown here:

 

Note: this Excel wire numbering update is not native to AutoCAD, but it is built into AutoCAD Electrical.

2 Comments »

  1. […] Tutorial – Using Excel with AutoCAD Electrical (Part 4 – Wire numbers) […]

    Pingback by Tutorial – Automation of PLC I/O Drawings – AutoCAD Electrical « AutoCAD Electrical Etcetera — September 1, 2010 @ 3:37 pm

  2. […] sounds to your too-quiet AutoLisp utility Updating drawings from scratch database edits Tutorial – Using Excel with AutoCAD Electrical (Part 4 – Wire numbers) Tutorial – Using Excel with AutoCAD Electrical (Part 3) Tutorial – Using Excel with AutoCAD […]

    Pingback by Index of AutoCAD Electrical Utilities – April 2006 through August 2010 « AutoCAD Electrical Etcetera — September 1, 2010 @ 3:49 pm


RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

The Shocking Blue Green Theme. Blog at WordPress.com.

Follow

Get every new post delivered to your Inbox.

Join 38 other followers

%d bloggers like this: