Nate Holt's Blog

March 13, 2015

Retiring an ITEM number assignment — one approach

Filed under: Electrical — nateholt @ 9:59 am

There is a need to be able to “retire” an ITEM number assignment when an old AutoCAD Electrical project set is later upgraded. Perhaps an electrical device originally specified, installed, and operated is now part of an overall control system upgrade. It was assigned an item number and showed up in the BOM, but now is to be upgraded and replaced with something better. But the user doesn’t want the old item number to be re-used for the new device… or ever used again for anything in this project.

How to do this? One potential way is illustrated below. But is there a better way?


(update — thought a bit more about the original posting… and came up with a slightly modified approach. New screenshots below)


Now let’s say you’re ready to “re-sequence” the ITEM numbers. BUT… you don’t want the re-sequence to affect the item numbers that you’ve marked as “retired” (i.e. those pushed into the little legend table and marked as MFG “_NOT USED”. Here’s how it can be done:



Now, when user launches the Re-sequence command, the “retired” items are all grouped at the very top of the “Manufacturers to Process” list, under “_NOT USED”. Just unselect this manufacturer and all of the “Retired” item number assignments are preserved through the item number re-sequence operation.





February 23, 2015

Quick question about “Mark Menus”

Filed under: Electrical — nateholt @ 2:52 pm

I’ve been away for awhile. Looking at the incremental improvements, this “Mark Menu” thing seems pretty neat. But there is one thing about the command placement for AutoCAD Electrical that has caused a small amount of frustration. I’ve more than once ended up with “Delete Component” when I was in a hurry and expecting an Edit or a Surf. markmenu

Does anyone know if this Mark Menu concept can be customized? I’d like to move “Delete Component” down in the bottom list where I think that I can more safely pick it. What think? Thanks, Nate.

February 13, 2015

Birth pic of AutoCAD Electrical

Filed under: Electrical, Musings — nateholt @ 9:31 pm

Cleaning out an old drawer and came across this Polaroid snapshot. It was March 13, 1996 and there was a first buyer for the “N8-Wire” AutoCAD add-on. It was to an outfit in Wixom, MI that was taking a chance on this.

Scan_20150213 (2)

The shipping department packaged it up and, before shipping it out (i.e. walking it down the street to the corner mailbox), placed it next to the development system (386 10mHz) in the software development department (tiny spare bedroom) to enshrine the moment.

Soon, Cimlogic picked up the marketing (their business card is in the photo), then VIA Development, and finally it became an Autodesk product. But many of the concepts, techniques, and workflows that were birthed in the first “N8-Wire” pictured here have endured.

February 11, 2015

How Wire Sequencing data is held in WDATA table

Filed under: Electrical — nateholt @ 1:52 am

This is the second of the series on the WDATA table format and will be of interest to one or two folks, if that (link here). But the question came up recently, so here goes…

Let’s look at an example of BEFORE and then AFTER.

Here is the wire network we’ll look at for this example. It’s the hot wire 224 below that interconnects six devices. Normal from/to reporting will likely list them top to bottom, left to right.




Here is what the above network’s record looks like in this project’s database file, WDATA table, for wire 224 BEFORE it is sequenced (Project Database file is opened and viewed with a copy of Microsoft Access). It’s pretty cryptic. It has six groupings of data, one for each wire connection in wire the wire number 224 network. Note that each wire connection entry in this list carries a value of “900” in its 22nd position. This “900” value is the default AcadE uses to signify a “non-sequenced” connection.


Now we run the Sequence Wire command and force some defined wire sequence. What we now have for from/to connection sequence is illustrated below with the “Show Sequence” command.




Here is what the WDATA table’s record now looks like for wire network 224. The “900” un-sequenced flag is now replaced with an incrementing 3-digit number starting at “001”.


To see it more cleanly, here are the subentries pulled out and shown separately. Sorting on the 22nd entry yields this wire connection sequence. Note that it matches the results shown in the “Show Sequence” tool above! The From/To reporting for wire number “224” will now show this connection sequence.




February 4, 2015

N8 Consultants – reopened for business

Filed under: Electrical — nateholt @ 8:38 am

Contact info here:

Nate Holt

phone: 419-344-5536 (EST time zone)

March 3, 2011

Accessing log file of AutoCAD Electrical project-wide tag/value updates

Filed under: Electrical — nateholt @ 11:23 am

AutoCAD Electrical automatically maintains a “log” file of changes it makes during project-wide retagging and value updating.

This may be useful if for tracking what things might need to be ballooned, clouded, or marked in some way to identify specific revisions.

The log file is an ASCII text file, automatically maintained by AutoCAD Electrical in the local “User” folder maintained by AutoCAD Electrical. The file name of the log file is the same as the project name but with a “.log” extension.

The screenshot below gives an example of how this works (and a limitation). There are three drawings in this project that all have an instance of component marked with a “TAG1″ attribute value of “52-1AB”. There is a 3-line schematic component, a “power 1-line” version, and a “protection and control 1-line” version (different WD_TYPE values on each, so these appear as “Peer parents” to the 3-line schematic symbol).

In the example shown, the 3-line schematic instance of “52-1AB” was edited using AutoCAD Electrical. The tag name was changed to just 52-1 and the RATING1 attribute value changed from 1600A to 1492A. AutoCAD Electrical found and automatically updated the other two instances of 52-1AB. This update of the other two instances is automatically pushed into a “.log” file shown here.

The limitation is that AutoCAD Electrical does not “log” your edit of the original component. It only logs the changes it makes automatically as a result of your manual, original edit.

Log file name

The log file name will be the same as the active project but with a “.log” extension. The folder it is in is the local “USER” folder maintained by AutoCAD Electrical. You can see this path by typing this at the “Command:” prompt:    !GBL_wd_usr [Enter] 

Project log file –> Excel tool

Here’s a little AutoLISP utility that will find and read the active project’s “.log” file and format the data into a CSV file. You can then call up and view it in Excel.

February 28, 2011

Upcoming Webcast – Circuit Builder (Part 2)

Filed under: Electrical — nateholt @ 6:29 pm

April’s webcast will be the second in a series that started with the Introduction to Circuit Builder, presented in February.

Two main points of this webcast will explore in detail…

  • How a motor load assignment value (voltage, phase, HP/KW, RPM, motor type) entered into Circuit Builder can automatically influence the upstream breaker, fuse, and wire size assignments that Circuit Builder suggests as it completes the circuit… all per a given electrical standard.
  • How Circuit Builder can help in calculating appropriate wire conductor de-rating for factors such as ambient temperature, insulation type, conductor grouping… all per a given electrical standard.

Please check back here for exact time/date and the link to the free registration.

February 17, 2011

Tutorial – Introduction to the Circuit Builder tool (part 1) – AutoCAD Electrical

Filed under: Electrical, Tutorials — nateholt @ 1:01 am

 Introduction to the AutoCAD Electrical “Circuit Builder” tool. Excel-spreadsheet-driven, parametric build of electrical control circuits.

Autodesk’s Nathan Eliason hosted a webcast today (February 16, 2011) that was an introduction to the Circuit Builder tool built into AutoCAD Electrical. I helped put the demo together and was responsible for real-time Q & A support while Nathan was “on stage”. 

Note: this posting covers the second half of the presentation. The first part, dealing with the legacy tools Save Circuit / Insert Circuit from Icon Menu is covered in the previous posting here. Other Circuit Builder tutorials:

Circuit Builder – Switching from AWG to Metric Wire Sizes
Circuit Builder – Creating an Alternate Electrical Standards Setting
Circuit Builder – Leveraging AutoCAD’s “Group” Concept
Circuit Builder Configure Mode – Adding a “Pick from Icon Menu” Selection
Circuit Builder – Embedding Custom Calls in the Spreadsheet


Introduction to Circuit Builder

This tool was introduced in the AutoCAD Electrical 2009 timeframe. It comes preinstalled with data to build and annotate a sampling of motor control circuits and power feed circuits. It includes three-phase, single-phase, and one-line circuit representations. Each circuit is built dynamically with the following features:

  • Connects to an adjacent power bus.
  • Adds wiring between components.
  • Annotates selected components with suggested values based upon the selected load.
  • Each time a circuit is configured, it is added to a history list of circuits. This list provides for quick re-insertion at a later time.


So, let’s try it. We launch “Circuit Builder” from the Schematic tab of the AutoCAD Electrical toolbar…

… and this opening dialog appears, “Circuit Selection”. It sports a tree structure of pre-defined circuit types, both three-phase and one-line circuit representations.

We select the type of circuit we’d like to build and insert into our active drawing. Let’s pick the first circuit type listed under “3ph Motor Circuit”… the horizontal full-voltage non reversing motor circuit. Highlight and then hit the “Configure” button.

The “Circuit Selection” dialog disappears and we find a 3-phase bus attached to our cursor as shown below. We pop it into our drawing to the right of a vertical 3-phase supply bus. The horizontal bus auto-stretches to make connection to the vertical power bus.

As the 3-phase template attaches to the vertical bus, the “Circuit Configuration” dialog pops open as shown below. Here is where we can select various elements from the tree structure on the left-hand pane and make option selections for that element in the center pane and value assignments in the right-hand pane.

At any time during the configuration we can hit the button at the bottom left-hand part of the dialog to insert one or more of our options into the template circuit. We can “see” how our selections build into the circuit. If we don’t like an option we’ve picked, we can back it out and select a different option, dynamically, from this “Circuit Configuration” dialog.

Once all options are assigned and we’re satisfied with our circuit design, we hit “Done” to finish up and exit the dialog and expose our completed circuit.

How Circuit Builder Works / How you can customize Circuit Builder

Let’s spend the remainder of this tutorial by taking a brief look “under the hood” of Circuit Builder. Why? Because Circuit Builder begs you to customize it, to make it do what you need it to do at your company. So, let’s start…

Question: What drives this tree structure of circuits displayed in the opening “Circuit Selection” dialog?

Answer: An Excel spreadsheet (name displayed along top of dialog)

Here’s the first sheet of the “ace_circuit_builder.xls” Excel file. Its sheet name is ACE_CIRCS and it defines the tree structure of selectable circuit types that display in the Circuit Builder command’s opening dialog. Column “A” gives the main circuit type category and column “B” gives the individual selection options under that category.

For each selection in the tree (the combination of “A” and “B” columns), the third column in this spreadsheet sheet (below) gives the selected circuit’s drawing template “.dwg” file name.

So, when we select from the Circuit Builder opening dialog to build and insert a “Horizontal – FVNR – non-reversing 3ph Motor Circuit”, Circuit Builder is going to start by inserting circuit “ace_cb1_FVNR_H.dwg” into the active drawing at our selected pick point.

So, in it goes. And what we see here, in this beginning stage of Circuit Builder, is this…

…our circuit seems to be just a bare 3-phase bus with some X’s positioned randomly on the wires. Is this all there is?…

No. The circuit template is a framework that guides Circuit Builder as it designs your selected circuit type.

What Circuit Builder starts with for this selected 3-phase motor circuit type is the bus and a dozen or two “marker” blocks with attributes.

The marker block instances are all the same block name but with different CODE attribute values. Each marker block / CODE combination marks a specific X,Y coordinate point in this 3-phase motor circuit where some option can be applied.

Some of the key marker blocks on our inserted 3-phase bus tempalte are shown here. At each position in the bus, that marker block identifies what option or action is to take place at that point.

Let’s zoom in on the left-hand end and take a closer looks at the marker block for the main disconnect option for the circuit…

The marker block’s insertion point is the big “X” of the symbol (below). The visible CODE attribute is used to identify what the marker block is to control. Here, the CODE attribute is “Q001”. It is positioned at the point in the motor circuit where the circuit’s main disconnection means would insert.

Now, we might have a number of different possibilities for disconnect: non-fused switch, various types of circuit breakers, fuses, fused switch, or maybe no disconnection means. All of these are options, any of which we might want to assign to this part of our selected circuit’s design.

Circuit Builder will give us a shot at all of these options for position “Q001” in our template circuit. Let’s go back and take another look at the circuit builder spreadsheet.

This image below is very busy, but let’s see if we can follow…

  1. We launch Circuit Builder. It reads the ACE_CIRCS table (the upper left part of this slide) and builds a circuit selection tree structure from the first two columns.
  2. We make our selection in the tree structure, selecting the “Horizontal FVNR – non reversing” motor starter.
  3. Circuit Builder grabs the associated drawing template “.dwg” file from the 3rd column, ace_cb1_FVNR_H.dwg, and inserts it (exploded) into the active drawing at our pick point.
  4. Circuit Builder now looks at the 4th column of the selected circuit’s tree structure data and gets “3ph_H”. Circuit Builder now goes to the spreadsheet sheet of the same name, “3PH_H”. Here is where it will match up marker block codes that came in with the exploded drawing template and the available options for each.
  5. In our example we were looking at “Q001”. Finding it in the spreadsheet, we can see that there are 9 rows of data corresponding to nine different options to choose from for the circuit’s main disconnection means.

Now, as Circuit Builder processes the marker blocks, one-at-a-time, when it processes the “Q001” marker, it finds the spreadsheet identifies it as “Disconnecting means” and there are 9 rows of options.

 The entries from the spreadsheet drive what is displayed in the dialog shown below. Pretty cool.

But how does a selection in this dialog, like the “Disconnect switch and fuses (time-delay)” shown above, translate to that particular component being pushed into the drawing at the Q001 marker block’s XY location?

Here is another busy slide below, but stick with me on this.

The first column identifies the beginning of the “Q001” main disconnect data. The next 2-3 rows define the titles and options for two pop-lists that appear on the Circuit Builder dialog when dealing with this Q001 main disconnect. The 6th row carries an integer number. This is a selection index value.

 In our example here, we’ve selected the disconnect switch and fuses (time-delay). This carries an index value of 6.

We’ve also selected “No” for the “Include N.O. auxilary contact” selection. This carries an index value of 0.

The sum of these two selections is 6 (6 + 0 = 6). Circuit Builder now goes to the 7th column and looks for an entry or entries marked with a value of 6. It finds one row. The 8th column of this row contains the AutoCAD Electrical API command to insert the selected components. They pop in at the XY coordinate of the “Q001” marker block ( ! ).

This is kind of complex, but is this starting to make some sense now? The main idea is that the whole Circuit Builder concept is totally transparent and fully open. It is driven from an Excel spreadsheet file which you can expand / modify to meet your company’s specific needs.


Let’s finish our time together today by doing just that !   Let’s modify the spreadsheet to add some more choices to an existing option.

Here’s the option we want to enhance… it is for the “run” pilot light color selection for horizontal 3-phase motor circuits. Right now, as we use Circuit Builder to design a 3ph motor circuit, when we get to the control circuit’s “Light” selection, the options presented are just red and green pilot lights. Let’s say we want to add “blue” and “amber” options.

Let’s do it.

Step 1 – Open the ace_circuit_builder.xls Excel spreadsheet. Go to ACE_CIRCS sheet. Determine which sheet gives the detailed control for 3-ph horizontal motor circuits. It is sheet “3PH_H”. Select this sheet.

We flip to the 3PH_H sheet below and scroll down, looking for the “Light” entries…

Here they are. These match up with the four lights + “None” that show up in the Circuit Builder dialog when we get to the “Light” selection. We’re at the right place

Taking a closer look at the column below holding the commands that insert the light symbols… the middle argument of the command string looks like it is the light symbol’s block name.

Looks like “HLT1R” = red standard, “HLT1G” = green standard pilot light… “R”=red and “G” = green. Let’s roll the dice and assume that we can substitute “A” for amber and “B” for blue in these block names.

We can cut and paste copies of the two green pilot light rows. Insert twice. Then edit to cover “amber” and “blue” pilot lights.

(Caution: the F and G rows need to remain “text” – this may mean adding a single quote character in front of the number digit to force Excel to treat it as character string instead of a number. AutoCAD Electrical will have trouble reading the Excel spreadsheet if there is a mixture of numeric and text values in the same vertical column. All values need to be marked as “text”.)

Note: also scroll over to columns K and L and make the “A” and “B” color code changes.

Save and exit the spreadsheet.


And now, when we run Circuit Builder and get down to the “Light” option, there are our four new options! Very nice…!

February 16, 2011

Tutorial – Save Circuit / Insert Circuit from Icon Menu – AutoCAD Electrical

Filed under: Electrical, Tutorials — nateholt @ 3:17 pm

Save partial or complete schematic circuits to the AutoCAD Electrical icon menu for pick and placement at any time into the current design.

Autodesk’s Nathan Eliason hosted a webcast today (February 16, 2011) that was an introduction to the Circuit Builder tool built into AutoCAD Electrical. I helped put the demo together and was responsible for real-time Q & A support while Nathan was “on stage”.

Note: this posting is a summary of what Nathan covered in the first part of his presentation, prior to introduction of the Circuit Builder tool.

Save Circuit / Insert Circuit from Icon Menu

This is the original circuit toolset that’s been around for a very long time. And there are two versions that ultimately do the same thing, that is, allow you to save partial or complete circuits and then, at any time, pop in copies of them for re-use.

For example, on the circled part of the circuit shown above… let’s say we have designed a basic 3-phase motor control circuit with isolated control transformer and control circuit. We’ve built it up using AutoCAD Electrical, inserting wires and components. But we want to be able to quickly re-use this circuit and other circuits like this so we don’t have to create each future instance “from scratch”. Again, we’re talking about the original save/insert circuit capabilities that have been in AutoCAD Electrical for a long time…

1st method: Saving a Circuit using AutoCAD WBLOCK command

So, the first approach is to use the generic AutoCAD WBLOCK command and window the circuit or sub-circuit and save it to disk, perhaps in some folder structure you set up on a shared network drive. Maybe a folder for motor circuits, another for safety circuits, another for controllers, etc. Use WBLOCK command, select the components and wiring and an insertion point, give it a file name, and push it out to your custom “library” of circuits.

2nd method: Saving a Circuit to the Icon Menu

The second approach long supported by AutoCAD Electrical is using the “Save Circuit to Icon Menu”. You window the circuit or sub-circuit you want to save for later re-use. AutoCAD Electrical WBLOCKs out the circuit to disk, same as before… except that it gives you a bonus. It adds a convenient link to the circuit right on the schematic icon menu.

Let’s quickly walk through an example of this second approach, the “Save Circuit to Icon Menu”…

Let’s say we’re going to be inserting quite a few 3-phase motor symbols with each one attached to a 3-pole safety switch.

1. We can draw this one time.
2. Then we can save this out as a “saved circuit” to our icon menu
3. Then, any time we need this, we can select it from the normal schematic icon menu and pop it in.

Here’s  how…

1. Assume we’ve initially drawn the circuit.
2. Now ZOOM in on what is to be included in the saved circuit.
3. Then select the “Save Circuit to Icon Menu” command as shown below.

AutoCAD Electrical flips into its “Icon Menu Wizard” mode and jumps to the page dealing with saved “user circuits”.

4.  Right-click in an empty spot in the icon area of the dialog.
5.  Select “Add icon” à “New circuit…” which then pops up a “Create New Circuit” properties form for the new icon…

6. Fill in the form above. The first line is the text that you want to show up below the icon. Here we’ll just enter something like “DS and 3PH Motor”. Toggle the “Create PNG from current screen image” to capture the active drawing’s current state. This will become the actual icon graphics that show up in the button. Enter any file name in the middle and bottom edit boxes. Hit “OK”.

7.  With the icon defined, the final step is to select the components and wiring that are to be WBLOCKed out as this circuit along with the insertion base point.

That’s it. Now it’s ready for re-use…  at any time we can insert the previously saved circuit into the active drawing schematic.

We can use the Insert Wblocked Circuit command (shown in blue below) and browse to the saved circuit’s “.dwg” file, then pop it in and auto-connect to out active drawing’s wiring. Or, in our example since we used the “Save Circuit to Icon Menu” approach (shown in red below), we can pick on the new icon…

Inserting a saved circuit previously saved to an icon menu button reference

1.Select the “Insert Saved Circuit” button as shown in red below.

2.This immediately pops open the schematic icon menu and jumps to “User circuit” page.
3.Pick on the new circuit icon. Pop the circuit into position on the active drawing. There it is!
Note: If you can’t remember how to find the “Insert Saved Circuit” button on the ribbon, just select the Schematic icon menu. Pick “Miscellaneous” à “User Circuits”, and there it is… the new “DS and 3PH Motor” icon. Just pick on it at any time and pop in a copy of the saved circuit into the active drawing.
No matter which approach you use, the INSERT CIRCUIT command or the INSERT FROM ICON MENU command, the circuit pops in and…
1. Wires attempt to trim/reconnect to the drawing’s existing connections
2. Parent components attempt to re-tag appropriately
3. Child components that came in with the inserted circuit attempt to link to re-tagged parents that came in with the circuit

And there’s nothing stopping us from WBLOCKing out complete circuits, such as this 3-phase motor start/stop circuit. We can browse to the folder where we’ve WBLOCKed it or we pick it from the Icon menu if we’ve saved it with the “Save Circuit to Icon Menu” command… and pop it in. Component re-tag automatically, child contacts cross-reference, and wires re-connect.

Pretty cool… but actually there are some basic limitations… 


Which will lead to a future posting on the second, newer method. It made its appearance in ACE2009 and is called “Circuit Builder”.

The Circuit Builder tool comes preinstalled with an Excel data file to build and annotate a sampling of motor control circuits and power feed circuits. It includes three-phase, single-phase, and one-line circuit representations. Each circuit is built dynamically with the following features:

  • Connects to an adjacent power bus.
  • Adds wiring between components.
  • Annotates selected components with suggested values based upon the selected load.
  • Each time a circuit is configured, it is added to a history list of circuits. This list provides for quick re-insertion at a later time.
  • Driven from an editable Excel spreadsheet

 For the above, click on “Introduction to Circuit Builder” posted here.

Atoms-Family: tracking globals in AutoCAD Electrical

Filed under: Electrical — nateholt @ 11:03 am

No, not the 1960’s TV series… this is about a generic AutoLISP function. Use it to code-up a tool to monitor creation and modification of global variables as AutoCAD Electrical runs.

Disclaimer: this may or may not be useful information.

AutoCAD Electrical holds a lot of stuff in global variables as it does its thing. If you take a look at the source code for the Spreadsheet –> PLC I/O utility that Autodesk kindly ships with every copy of the product, you’ll notice quite a few variables with a prefix “GBL_wd_”. These are Lisp variables that hold data that is global to the overall AutoCAD Electrical application.

For example, there is the “WD_M” block that you’re probably familiar with. It has 70-80 attributes on it with key values that influence what and how things happen on the active drawing. AutoCAD Electrical reads this block and retrieves these attribute values one time and then saves the values as global variable called “GBL_wd_m”. Whenever you then ask AutoCAD Electrical to do some task on this drawing that requires it to retrieve a setting held on the WD_M block, it just grabs the value from the global variable GBL_wd_m instead of having to search the drawing for the WD_M block instance and then reading the appropriate attribute value off of it. Saves a lot of time.

There are lots of them and the names of these and lots of other stuff can be listed at any time with the simple Lisp expression (atoms-family 1) [Enter].

Here’s a tool that makes use of this atom-family call to track/monitor globals as AutoCAD Electrical runs …

Example Run

Starting up AutoCAD Electrical, we open up a drawing from the Project Manager. Then appload the above utility “GBL_TRACKER.LSP”. Type GBL_TRACKER [Enter] at the “Command:” prompt.

Now we pick an AutoCAD Electrical command, let’s say we try to SCOOT a wire. Then type GBL_TRACKER [Enter] again…

The circled global shows that the drawing’s valid wire type layer names are held in a global.

How might this be useful?

Let’s say that when we run  our SCOOT command and pick on a line that is on a layer that is not currently defined as a valid wire layer, then the SCOOT command aborts. For example, let’s say that we have drawn a cable “fan-in” and marked it with a cable marker. The “fan-in” part of the wire is on layer called “_MULTI_WIRE” which is not a valid wire layer. But we’d like to use SCOOT to adjust it.

From what our tool’s output tells us, it looks like valid wire layer names are held in a global variable. What if we try to temporarily add layer name “_MULTI_WIRE” to the global variable that holds the drawing’s valid wire layer names? Will SCOOT then “work” when we pick on a LINE that is on non-wire layer “_MULTI_WIRE” ? Let’s try it…

To add this to the global variable, we’d type or program this expression:

(setq GBL_wd_active_dwg_wiretype_cache_lst (cons "_MULTI_WIRE" GBL_wd_active_dwg_wiretype_cache_lst))

And now, when we try to SCOOT the non-wire and attached cable marker, SCOOT does not error out… but operates as if the non-wire line entity was actually a wire! Cool.

To restore normal SCOOT operation, just set the global to nil (and it will re-read the next time it is needed).

(setq GBL_wd_active_dwg_wiretype_cache_lst nil)  

UPDATE: forgot to mention this… you can view the contents of any global variable at any time. Just type the global variable name at the “Command:” prompt BUT precede the name with a ! character. For example, to display the value of the GBL_wd_m global, type this:

Command: !GBL_wd_m [enter]

February 12, 2011

Programmatically adding active dwg to active project – AutoCAD Electrical

Filed under: Electrical — nateholt @ 10:55 am

One line of Lisp code is all it takes for your custom application to add the active drawing to the current active AutoCAD Electrical project.

This question came up a couple days ago… “How can I program my custom application to take each drawing it creates and automatically add it to the current AutoCAD Electrical project?” You could do this the hard way by opening up the active project’s “.wdp” text file and add the full path to the new drawing to the end of that file.

But there’s a cleaner way that is used in the Spreadsheet –> PLC I/O utility to add each new PLC I/O drawing to the active project. This AutoCAD Electrical command is run from “full source code” mode and it is written in AutoLISP. So, maybe we can just take a look at this source code, find the right spot, and cut/paste a block of code into our custom application ( ! )

Finding the source file: wdio.lsp

Start AutoCAD Electrical. Type this at your AutoCAD command prompt:  

Command:  (findfile “wdio.lsp”)  [Enter]

It should return the full path to the PLC I/O utility’s source file. If this fails, try this one:  (c:ace_find_file “wdio.lsp” 3) [Enter]. Make backup copy of this file (just in case)

Open the “wdio.lsp” file

Use any ASCII text editor or type VLIDE [Enter] at the AutoCAD command prompt and use the built-in Visual Lisp editor.

Scroll down. The key part of the file that saves the active dwg to the current active project is excerpted below:

      (setq x (c:wd_is_cur_dwg_in_proj))
        ((> x 0)) ; this drawing is already listed in the project
        ((< x 0)) ; no project is marked as "active" ??
        ((= x 0) ; active dwg is not listed in active project, add it now.
          ; Call the normal AutoCAD Electrical "API" call for updating active drawing's title block
          ;    First sublist (of 13 elements, 1 for selected, 0 for not selected )
          ;    1st =  mapped to DWGDESC (the description under drawing "properties")
          ;    2nd = mapped to DWGSEC
          ;    3rd = mapped to DWGSUB
          ;    4th = mapped to FILENAME
          ;    5th = mapped to FILENAMEEXT
          ;    6th = mapped to FULLFILENAME
          ;    7th = mapped to DWGNAM
          ;    8th = mapped to SHEET
          ;    9th = mapped to SHEETMAX
          ;   10th =
          ;   11th = mapped to IEC_P (the drawing's IEC coding default for %P)
          ;   12th = mapped to IEC_I (the drawing's IEC coding default for %I)
          ;   13th = mapped to IEC_L (the drawing's IEC coding default for %L)
          (c:wd_tb_process_one 1 (list (list 1 1 1 1 1 1 1 1 0 0 1 1 1))) ; update title block
          (c:ace_add_dwg_to_project nil (list "" "" "" 1)) ; first "nil" = add active dwg
      ) )

The key command that pushes the active dwg into the active project is highlighted in red above. If you know that the active drawing is not in the active project, executing just this one-line AutoLISP expression should push the drawing into the project.

Note: here’s a quick test… just type at the command prompt and hit [Enter]…


Command: (c:ace_add_dwg_to_project nil (list “” “” “” 1))

Checking files for any marked in-use/read-only . . .




… and the drawing appears in the project manager of active project.



February 9, 2011

Extending AutoCAD Electrical to 4-pole Breaker/switch Dynamic Inserts (and beyond)

Filed under: Electrical — nateholt @ 11:12 am

The icon menu component insertion tool can be easily customized to extend quick pick and dynamic insertion of multi-pole devices of pole counts beyond AutoCAD Electrical’s 3-pole default.

Normally, to accommodate a circuit breaker of more than three poles, you pop in the 3-pole breaker from the stock icon menu pick and then manually add in to more single child breaker poles.

But let’s say that we routinely need to insert a 5-pole circuit breaker…

Would be nice to just hit a button…

Here’s a step-by-step sequence showing how to add a new button to the icon menu for a 5-pole circuit breaker.

Step 1 – Determine the parent and child symbol names needed to build the breaker.

Just insert a 3-pole breaker from the icon menu somewhere in space on the drawing.  Then use any block/attribute editing tool or the AutoCAD “LIST” command to get the block name of the top symbol (the parent)…

… and the block name used for the 2+ child poles.

Step 2 – Launch AutoCAD Electrical’s Icon Menu Wizard tool.

 Select “Schematic” and hit OK.

Step 3 – Drill down to the Circuit Breakers / Disconnects icon menu page. This is where we’ll add our new 5-pole CB icon.

Okay, here we are at the desired page… dealing with breakers and switches.

Fill in some data on the form for the new icon…

… the dialog below shows the standard commands available for the icon menu. Pick on the 3-pole parametric build option (even though we want 5 poles). Hit OK.

This brings us back to the previous dialog below but has filled in the “Command” edit box with command name WD_3UNIT. Here is where we trick AutoCAD Electrical to insert five poles (1 parent + 4 child symbols). Type in the parent symbol name (from step 1 above). Type in the child symbol name four times. Put a space between each symbol name as shown below.

Hit “OK” and “OK” to get all the way out of the Icon Menu Wizard tool.

Step 4 – Let’s try it! Hit the normal “Icon Menu” icon to insert components. Drill down to the Circuit Breaker page. There’s our new icon. Pick it.

Select and pop into the bus…

… and use the same icon to insert into vertical bus…

February 3, 2011

Energy-absorbing mailbox 2, Snow-plows 0

Filed under: Musings — nateholt @ 2:31 pm

It is looking like my modified mailbox may survive its second year against the county snow-plows. This is a tiny bright spot in an otherwise long and bitter Ohio winter.

Here is what the mailbox across the road looks like after the latest blast of snow. Not a pretty sight.

And here is my mailbox, still standing [so far!]. The difference may be the energy-absorbing mechanism I added to the design.

The idea is that the mass of snow-plow generated ice and snow, travelling 45-55 mph and striking the mail box assembly, causes the large gray hinged part of the mailbox to swing with the blow. This does two things: 1) As the hinged mailbox part rotates, the cross-sectional area exposed to the flying wall of snow/ice is reduced (side versus back).  Some of the trailing part of the wall of snow/ice will “miss” hitting the mailbox because the box will have partially rotated out of the way – exposing the back of the box instead of its maximum broad side. 2) The movement/acceleration of  the box as it rotates on the hinges absorbs energy along with the increasing resistance provided by the stretching spring.

The net result is that the shock of a “broadside hit” is reduced and, “rolling with the punch”, the energy is dissipated over a longer period of time. The spring auto-resets the mailbox to its normal position… ready for the next snow-plow.

So far, so good…!

UPDATE: a commenter below asked whether the a violent rotation might fling out the contents of the mailbox. I made some snide comment, but this commenter has proven to be absolutely correct!  I need to adjust the door latch to be a bit stiffer…

We had another 6-inches of snow several days ago, and the mailboxes along my road were subsequently attacked by the snow-plows. Afterwards I found various pieces of my mail frozen to the road surface, extending to about 50 feet downstream from my still-standing mailbox. One key item, what was supposed to be a tax return, is pictured below, chiseled from the road’s surface ( ! )

[05-Jan-2015 Nate Holt – it’s now 2015 and the mailbox is still standing — the design seems to have worked [so far]. The winter of 2013-2014 was brutal with record snow in our state, but the snowplows were still unable to take it down. Will see what the future holds for the remainder of this winter…]

February 1, 2011

Circuit Builder (part 1 intro) – link to recorded Webcast of 16-Feb-2011 (16-02-2011)

Filed under: Electrical, Tutorials — nateholt @ 6:08 pm

Hour-long  webcast at 11am PST, 16-Feb-2011, covering 1) save/insert complete circuits, and 2) introduction to the Circuit Builder tool that is built into AutoCAD Electrical (2009 and greater).

Here is the link to the recording of this webcast.

January 31, 2011

Circuit Builder – switching from AWG to metric wire sizes – AutoCAD Electrical

Filed under: Electrical — nateholt @ 11:27 pm

How to define an alternate “electrical standard” to force Circuit Builder to default to metric wire sizes in its calculations.

Circuit Builder’s “Wire Size Lookup” dialog is a tool that can link into an “electrical standard” and guide you as you select motor size, motor power wire sizing, and appropriate ratings of the main disconnecting means – whether some type of breaker, fusible switch, or just fuses.

It can be launch from within Circuit Builder’s “Circuit Configuration” dialog as shown here:

The dialog opens and includes a number of different de-rating factors and settings. The results of the calculations default to AWG wire sizes. But one of the settings on the dialog can toggle calculations and display of metric wire sizes.

Let’s say you have a project that needs to use metric wire sizes rather than AWG. But you’d rather not have to remember to toggle to the “MM2″ metric option every time the “Wire Size Lookup” dialog displays. You’d like it to default to metric wire sizes.

Setting up an alternate standard that defaults to metric wire sizes

Here’s how to create an alternate standard that parallels the default National Electrical Code settings for wire calculations but defaults to using metric wire sizes instead of AWG sizes. This avoids having to hit the AWG/MM2 toggle each time the dialog displays.

1. Launch the built-in Access database editing tool as shown below.

2. The Electrical Standards Database Editor dialog opens. Expand the “Default” and “NEC” tree nodes to show all table names. Find the table named “OPT_NEC”. Right click and Copy / Paste this table. Name the new copy “OPT_NEC-MM2” as shown below.

3.  Once you hit OK, the tree structure will update and add in the new “NEC-MM2” entry as shown below. Expand it to display the copied table OPT_NEC-MM2 and click on it to open. Edit the two “name” records highlighted in red. 

Here’s the key change. Edit the record marked with a CODE field value of “W_STD”. Change its DEFAULT field value from “AWG” to “MM2″. Hit “Save” and exit out of the database editor.


Open up any project. Right click on the project name in the AutoCAD Electrical Project Manager and select it.

Now run Circuit Builder and start to “Configure” a motor circuit. On the “Motor Setup” right at the front end, hit the “Select Motor” as shown below and make some motor selection. This sets in motion the queries into the select standard in the Electrical Standards Database file.

Select any motor size in dialog above and hit OK. Now cross your fingers and pop open the “Wire Size Lookup” dialog as shown below.

The dialog should display. Metric wire sizes instead of AWG sizes should now calculate and display. 

If there are other defaults you’d like to change, take a look in your new copied OPT_NEC-MM2 table and adjust.

Other Circuit Builder tutorials:

Tutorial – Introduction to the Circuit Builder Tool (Part 1)
Circuit Builder – Creating an Alternate Electrical Standards Setting
Circuit Builder – Leveraging AutoCAD’s “Group” Concept
Circuit Builder Configure Mode – Adding a “Pick from Icon Menu” Selection
Circuit Builder – Embedding Custom Calls in the Spreadsheet

January 30, 2011

Circuit Builder – Creating an alternate electrical standards setting – AutoCAD Electrical

Filed under: Electrical, Tutorials — nateholt @ 12:11 am

AutoCAD Electrical ships with Circuit Builder’s “electrical standards” for wire sizing and breaker/fuse/switch ratings set to parallel some of those outlined in the National Electrical Code. Here is how to alter the settings or create a selectable, alternate electrical standards selection.

Circuit Builder’s “Wire Size Lookup” dialog is a tool that can link into an “electrical standard” and guide you as you select motor size, motor power wire sizing, and appropriate ratings of the main disconnecting means – whether some type of breaker, fusible switch, or just fuses.

The motor power wire sizing has a number of different de-rating factors selectable from the dialog. One of them is the “Fill Correction:” selection. The motor wire ampacity is reduced in steps when there are more than three power conductors grouped in the same conduit, raceway, or cable. The de-rating steps increase with increasing ranges of grouped power conductors.

Enemy: Heat

Internally generated heat is enemy and heat is the issue here. We’re talking about the “I squared R losses”, the power that is dissipated in a wire conductor in the form of heating of the wire itself. The more current-carrying wires that are grouped together, the warmer all of the conductors will become as a group, further raising the resistance of the conductors and potentially exceeding the conductor’s insulation temperature rating.  

So, an electrical code may require that the maximum amps that a conductor can safely carry, when it is all by itself or with no more that two other conductors, needs to be de-rated to a factor of 0.8 of the original when there are between four and six conductors grouped together in a conduit, cable, or raceway. And, if the number of power conductors is seven to nine, the de-rating needs to be 0.7 of the original.

Default “FILL” table

The ranges for “FILL” de-rating are defined in a table found in Circuit Builder’s Electrical Standards database file. The default table is called “FILL” and is shown below using AutoCAD Electrical’s built-in standards database editor (you can also view it using a copy of Microsoft Access).

The default table above yields these de-rating ranges:

  • 1-3:        1.0 ( no de-rating)
  • 4-6:        0.8
  • 7-9:        0.7
  • 10-20:   0.5
  • 21-30:   0.45
  • 31-40:   0.4
  • >40:       0.35

Creating an alternate standard that has a modified FILL table

Let’s say that you have some projects that need to follow a slightly different range of conductor groupings and de-rating factors, perhaps something that is closer to the UL 508A standard. Let’s say that the  alternate fill table needs to be more like this:

  • 1-3:      1.0 (no de-rating)
  • 4-6:      0.8
  • 7-24    0.7
  • 25-42  0.6
  • >42      0.5

We could just modify the existing table, but it might be better to create an alternate “UL508A” standard in Circuit Builder’s Electrical Standards database file. Here’s how to create a second standard as part of the standards database file.

1. Launch the built-in Access database editing tool as shown below.

2. The Electrical Standards Database Editor dialog opens. Expand the “Default” and “NEC” tree nodes to show all table names. Find the table named “OPT_NEC”. Right click and Copy / Paste this table. Name the new copy “OPT_UL508A” as shown below.

3.  Once you hit OK, the tree structure will update and add in the new “UL508A” entry as shown below. Expand it to display the copied table OPT_UL508A and click on it to open. Edit the two records shown and hit “Save”.

4. Make a copy of the “FILL_NEC” table. Name it “FILL_UL508A”.


5. Open up the copied/renamed FILL_UL508A table. Edit as shown below to give the altered ranges for grouped conductor counts and de-rating correction factors to parallel what might be found in the UL 508A standard. “Save” and “Close”.



Open up any project. Right click on the project name in the AutoCAD Electrical Project Manager and select it.

Now run Circuit Builder and start to “Configure” a motor circuit. On the “Motor Setup” right at the front end, hit the “Select Motor” as shown below and make some motor selection. This sets in motion the queries into the select standard in the Electrical Standards Database file.

Select any motor size in dialog above.

Now launch the “Wire Size Lookup” dialog (shown below). This is where we find out if our test is going to be a success or a failure. Turn on the “Fill correction” option. Hit the pop-list as shown. See if the five UL 508A grouping categories show up instead of the seven that show up for the NEC selection. Make some selections and confirm that the fill correction factor to the right of the pop list tracks the UL 508A ranges correctly.

That should do it.

If there are other things that you want to adjust per this alternate standard, copy the tables from the NEC version, rename with the UL508A suffix (replace the “NEC” suffix with “UL508A”), open, edit, and save.

January 19, 2011

Importing Wire Types from a master schematic (Part 2) – AutoCAD Electrical

Filed under: Electrical — nateholt @ 11:14 am

New drawing automatic import and set-up of wire types pulled from a master schematic drawing.

This is an update of the previous posting here. Autodesk has added this as a stock feature to AutoCAD Electrical 2011 ( ! )

Let’s say you’re creating a new schematic drawing to add to an existing AutoCAD Electrical project. It is going to be similar in function to an existing drawing where you’ve set up a number of custom “wire types”. What you’d like to do is just pull all of those wire types over to your new drawing and get moving.

But, when you select the “Create/Edit Wire Type” command and the dialog below displays, you realize that you’re only getting the default “WIRES” wire type defined with this new drawing. You really want to pull in wire types that you’ve already taken the time and effort to define on the other drawings in your project.

But wait…! What is this new “Import…” button used for? Could it be…???

Yes! The mysterious new button in ACE2011 brings up a file browse dialog. Select a “master” drawing to provide wire type candidates for the new, active drawing.

Make the wire type selections and hit OK. And in they come (below)! Nice…

Again, this feature became available starting in AutoCAD Electrical 2011. For earlier versions, you can use the tool described in the earlier posting linked above.

January 2, 2011

2010 in review

Filed under: Electrical — nateholt @ 11:45 pm

The stats helper monkeys at mulled over how this blog did in 2010, and here’s a high level summary of its overall blog health:

Healthy blog!

The Blog-Health-o-Meter™ reads Wow.

Crunchy numbers

Featured image

About 3 million people visit the Taj Mahal every year. This blog was viewed about 57,000 times in 2010. If it were the Taj Mahal, it would take about 7 days for that many people to see it.

In 2010, there were 40 new posts, growing the total archive of this blog to 96 posts. There were 294 pictures uploaded, taking up a total of 39mb. That’s about 6 pictures per week.

The busiest day of the year was November 9th with 406 views. The most popular post that day was Index of AutoCAD Electrical Utilities – April 2006 through October 2010.

Where did they come from?

The top referring sites in 2010 were,,,, and

Some visitors came searching, mostly for nate holt, solar eclipse, solar eclipse from space, autocad electrical, and autocad electrical tutorial.

Attractions in 2010

These are the posts and pages that got the most views in 2010.


Index of AutoCAD Electrical Utilities – April 2006 through October 2010 July 2009


Tutorial – Automation of PLC I/O Drawings – AutoCAD Electrical February 2010


Tutorial – Basics of ‘Smart’ Panel Layout (Part 1) – AutoCAD Electrical June 2010
1 comment


PLC I/O Drawing Generator – Pre-defining wire numbers – AutoCAD Electrical November 2009


Tutorial: Basics of ‘Smart’ Panel Layout (Part 3) – AutoCAD Electrical June 2010

December 8, 2010

Tutorial – Automatic Wire Annotation from Schematic to W/D (Part 1) – AutoCAD Electrical

Filed under: Electrical, Tutorials — nateholt @ 2:48 pm

Annotation of panel wiring diagram representations with real-time schematic wire connection data.

Autodesk’s Nathan Eliason hosted a webcast earlier today that focused on AutoCAD Electrical’s ability automatically annotate panel layout or panel wiring diagram representations with real-time schematic wire connection data. I helped put the demo together and was responsible for real-time Q & A support while Nathan was “on stage”. 

Note: this posting is a summary of what Nathan covered in the first 30 minutes or so of his presentation.

A Quick Review

Let’s summarize what we saw in the first two or three panel-related tutorials back in June


Once the schematic creation phase is complete, AutoCAD Electrical extracts a list of schematic components for placement into panel layout drawings.  Users choose the panel location and a physical “footprint” representation of each device to be inserted into the layout and a “link” is automatically created between the device and its representation.  Any changes to the schematic or panel representation will update the other.  Non-schematic items like wire duct and mounting hardware can be added to the layout and automatically combined to create a “smart” panel bill-of-materials report.


Simplify panel layout drawing creation to reduce errors and ensure that all parts are placed, and drawings are automatically updated.

What do we mean by panel layout drawings being “smart”?  The layouts have a “smart” relationship with their control schematic counter-parts.

Consider this: The panel layout drawings are probably just one part of your overall electrical controls drawing package. The other very key part of the package is the electrical controls “schematic” drawings.

The electrical schematic drawings in your design define the interconnected wiring between control devices such as relays, pilot lights, switches, motor starters, I/O modules, and such. They might be drawn in a “ladder” format as shown here, or sideways ladders, or even drawn in more of a point-to-point interconnection style.

These schematics are actually quite “smart” all by themselves. With AutoCAD Electrical they can have automatically generated tag-IDs, child contact cross-referencing, automatic wire number assignments, various BOM reports, and on and on.

But, when panel layout drawings and associated schematics are combined in a single AutoCAD Electrical project, then the panel layouts get a big “Project IQ” boost from the presence of their schematics.

Item #5 is the one that is the main topic addressed in Nathan Eliason’s webcast 08-December-2010 and summarized below.

Schematic to Panel W/D Wire Connection Annotation

The panel layouts and the electrical controls schematics are tied  very closely together.  Let’s use one of the sample projects, “IECDEMO”, that installs with the product.

Here we have portions of three drawings shown below. There are two electrical schematics on the left and a small portion of a panel layout on the right.


The circled elements on the two schematics are related to the physical panel footprint symbol on the right.

Let’s use this simple example to show how the AutoCAD Electrical panel layout drawing on the right can be turned into a quick “wiring diagram”. What this wiring diagram will show is a listing, all in one place, of schematic wire connections that tie to this “-K14” motor starter.

Two things to check before we launch the wiring diagram annotation command. The first is this…

 1. Set the annotation format to include the pieces of information you want to see on your wiring diagrams.

This is set up as a project-wide default by selecting “Panel” –> “Configuration” on any drawing of the project. Here we’ve selected that we want wire number, destination component tag and pin number, and connected wire’s color/gauge layer name.

The second thing to check is the default text style and text size for the annotation. The command will default to whatever text style is set as “current” for the target panel layout drawing. Here we have text style “WD_IEC” and text height of 2.0 selected for our panel layout drawing.

 Now we’re ready to go.

Launch the “Wire Annotation” command as shown above. Select “Active drawing (all)” and hit OK.

You’ll see the annotation dialog pop up one more time. Confirm selections and hit OK.

In a few moments AutoCAD Electrical will have extracted the current state of the schematic wiring, sorted it all out, formatted it per your selection, and then pushed it out to each panel footprint symbol ( ! )


Now, the annotation comes in as an MTEXT entity located at the origin point of each footprint symbol (as shown above). You can move the MTEXT entity to a better position and it will then “hold” at that position when you re-run the command to freshen the connection data with edits made on the schematics.

Here we’ve repositioned the MTEXT annotation for the “-K14” motor starter.

Note that all the information on the portion of the schematic shown on the left-hand side of the screenshot has been automatically annotated on to the panel footprint representation… this includes the wire color/gauge layer names because we selected that option for the wire annotation format.

[Next blog posting… Part 2 – Creating and annotating separate wiring diagram layout drawings]

Other Panel-related tutorials:

Tutorial – Basics of ‘Smart’ Panel Layout (Part 1)  
Tutorial – Basics of ‘Smart’ Panel Layout (Part 2)  
Tutorial – Basics of ‘Smart’ Panel Layout (Part 3)
Tutorial – Mapping schematic components to panel layout – AutoCAD Electrical

December 6, 2010

Forcing full database rebuild – AutoCAD Electrical

Filed under: Electrical — nateholt @ 12:11 pm

This old command didn’t make it into the ribbon UI a couple releases ago. But every once in awhile I’d like access to it again to manually force a rebuild of my current project’s scratch database file.

Just type this at the AutoCAD Electrical “Command:” prompt:

Command: AEREBUILDDB [Enter]

This dialog appears. Make your selection and let it do its thing.

December 3, 2010

Command substitution example, ‘Show Sigs’ – AutoCAD Electrical

Filed under: Electrical — nateholt @ 11:37 am

Substituting  your own version of a command for one called from the stock AutoCAD Electrical ribbon UI

Here’s an example of invoking your own version of a utility from the stock AutoCAD Electrical ribbon UI without modification. The key is to give your utility the same executable command name that the ribbon calls. Then add your utility to the normal AutoCAD “Startup Suite”.

The sequence appears to be that AutoCAD loads the AutoCAD Electrical code into memory first. Then it loads the stuff you’ve defined in the Startup Suite. If one of the latter has the same executable name as the former, then the latter one wins. Your custom utility will take precedence over the same-named AutoCAD Electrical one.

“Show Sigs” example

The stock “Show Sigs” command works by zooming extents and then displaying the temp graphics to show the source/destination links. But on a crowded drawing, you may want to zoom in to get a better view. The problem is that this erases the temp graphics. If you first zoom in and then launch the command, it zooms extents and then displays the graphics. You’re  screwed. Frustrating.

But if we create our own version of this with an ability to pan/zoom around and follow the paths, then it would be so much nicer. And if we give it the same executable name as the existing command in the UI and let it appload from the AutoCAD “Startup Suite”, then our own version will execute in place of the original when picked from the UI.

So, here’s the sequence:

1. Get the existing command name that is launched from the AutoCAD Electrical UI. Run the command one time. Then pick the “up arrow” key to “repeat the last command”. You should see the command name at the command prompt. It will likely have an “AE” prefix. For this example, it is “AESHOWSIG”.

2. Create your Lisp or VB version of the utility using this as the executable’s name. In lisp, your function name line of code would be something like this:

(defun c:AESHOWSIG ( / ) …

3.  Test your utility and adjust until you get it working as desired (this is the hard part!)

4. When finished, add your utility to the “Start-up Suite”. Type APPLOAD at the “Command:” prompt to display dialog as shown below.

Browse to your executable and add it to the list of executables to automatically load at AutoCAD  start-up (and with each subsequent drawing you open in AutoCAD).

That should do it. Restart AutoCAD Electrical. Now, selecting the “Show Signals” button on the stock AutoCAD Electrical UI should now invoke the new utility ( ! ). No change to the UI is needed in this case. To go back to the original, just remove this entry from the Startup Suite list.

If you want to see how this works, download the sample utility here.

December 1, 2010

Win7 “Aero Themes” and AutoCAD 2010/2011 (??)

Filed under: Tips — nateholt @ 12:47 am

“Aero” theme selection potentially causing instability with AutoCAD 2010/2011 (??)

Win7 “Home Premium” has not been too friendly with AutoCAD 2010/2011 on my inexpensive laptop. It would go through periods of locking up every hour or so when AutoCAD was running, even when doing just the simplest tasks. Sometimes just sitting there… I would come back to the machine and it would be locked up.

A Google hit suggested that the Win7 “Aero” theme might be the culprit…

…it’s now been two “lock-up-free” days since I flipped my machine over to a generic theme!  Fingers-crossed…

October 27, 2010

AutoCAD Electrical: Change Default Catalog Lookup Filters

Filed under: Electrical — nateholt @ 7:15 pm

Here’s link to Mark Flayler’s article from the IMAGINiT Manufacturing Solutions Blog… to potentially gain some speed on the improved AcadE 2011 catalog lookup dialog.

October 26, 2010

Tutorial – Mapping schematic components to panel layout – AutoCAD Electrical

Filed under: Electrical, Tutorials — nateholt @ 7:34 am

Here is a step-by-step illustration of how AutoCAD Electrical maps schematic components and part number assignments back to the panel layouts. This just uses an example of a motor contactor to make the point. But the concept will be exactly the same as we apply it to pretty much all control schematic devices.

The example just uses the existing “WDDEMO” project that installs with AcadE. On one of the schematics we’ve gone to the “Icon menu” –> “Motor control” and popped in a motor starter symbol, tag-ID “M427”.

When we pop in the motor starter coil, the Insert/Edit dialog pops up (above). We hit the “Lookup” button to more easily make a part number assignment.

We pick a Siemens part number for a NEMA 2 contactor, hit OK, and the assignment gets pushed out to the MFG and CAT attributes (invisible) on the parent coil symbol for “M427”.

Now, later on, we’re ready to modify our panel layout to take into account our additions in the schematic. We have a blank spot shown above where we’d like to land our new NEMA 2 starter. We pick on the “Panel” –> “Schematic List” command as shown above.

After a few picks we arrive at this schematic listing shown above. This lists all of the schematic components found in our project. The left-hand column shows what is currently found in the panel layout drawings. Looks like “M427” needs to be added to the layout. We highlight our “M427” entry and hit “Insert”.

AcadE finds a footprint representation and attaches it to our cursor. We position the footprint where we want it to land and click. In it goes and get’s marked off of the “list” of schematic stuff not found in the panel layouts.

So, how did it know that this particular footprint went with our Siemens part number selection? This is set up in the “Footprint lookup” database file. A portion of the “SIEMENS” table is shown above. Our part number selection matched in the record that points at footprint block’s partial filename of “SIEMENS/MS-MOTOR STARTERS/14F-A.dwg”.

 The full path to this footprint block “.dwg” file is illustrated in the next screenshot.

This partial path is added as a suffix to the main base path for the footprint library. This is shown in the “Project Settings” dialog above.

Assuming that the target footprint is found, AcadE gets a copy of the block and auto-attaches it to our cursor. We position it and pop it in at our pick-point!

 So, what happens if we have to change the part number assignment on the schematic? Let’s try it.

 Let’s say that our load requirements for motor contactor M427 have increased. We need to bump up our part number assignment to accommodate this change. Our original part number assignment for M427 was for a NEMA 2 starter (and our panel layout drawing already shows the outline for our originally selected Siemens NEMA 2 motor starter part number 14FSH32AE).

So, back on the schematic, we right-click on M427 and select “Edit Component”. This re-displays the dialog shown above. There’s the old part number assignment. We pick “Lookup” and select a larger motor starter part number. We hit “OK” to dismiss the edit dialog.

AcadE updates the schematic symbol with the new part number assignment (on the “CAT” attribute). But it sees that there is an “M427” representation on the panel layout too.


And it auto-opens the panel drawing and changes the part number assignment to match. BUT, it also pulls out the smaller NEMA 2 footprint and pushes in a Siemens footprint for a NEMA 3 starter!

How did it know to do this?

 Back in the Siemens table of the Footprint Lookup database, the new part number selection matched on a different record which pointed at a different footprint block name. AutoCAD Electrical sensed this and auto-swapped-out the panel footprint to keep the schematic part number and the panel footprint in synch.

All this is possible to do in electrical controls design! Just a matter of making sure that there are the proper footprint representations available for the devices you’ll be using and the mapping is set up between them and the part number assignments.

October 25, 2010

AutoCAD Electrical 2011 – Review

Filed under: Electrical — nateholt @ 7:13 pm

Generally positive review… link is here.

October 19, 2010

Tutorial – Terminal Strip Editor (Part 3) – AutoCAD Electrical

Filed under: Electrical, Tutorials — nateholt @ 3:52 pm


Terminal block management: Multi-level terminal strips and the Terminal Strip Editor

Note: access part 1 of this tutorial here and part 2 here.

Autodesk’s Nathan Eliason hosted a webcast last week that focused on AutoCAD Electrical’s ability to insert, track, and manage terminal blocks / terminal strips in a project drawing set. I helped put the demo together and was responsible for real-time Q & A support while Nathan was “on stage”. 

Also thanks to Doug McAlexander for some of the images and samples.

Part 3

Note: this posting is a brief summary of what Nathan covered in the last 15 minutes of the hour-long webcast. This part deals with using the Terminal Strip Editor tool to assign groups of schematic terminals to triple-level terminal blocks on the panel layout representation.

Okay, picking up from where we left off in part 2 of the tutorial… now let’s do TB-2 for the remaining three 3-phase motors in our design.

Let’s target this piece of DIN rail to hold these terminals. And as a challenge, let’s go with triple-level terminals this time, one terminal to take care of each motor.

Launch Terminal Strip “Editor” as before but now select “TB-2” from the opening dialog.

 Then select “Catalog Code Assignment” tab. We’re ready to assign a catalog part number.

Let’s go with a triple-deck terminal, one terminal block to take care of the 3-phase wire connections for each of the three motors.

Highlight the first terminal row in the dialog list. We’re going to flip this into a triple-level terminal and run all three motor wires through this one terminal block.

Select ENTRELEC again, “MULTI-LEVEL”, and make the catalog selection shown above.

Changing this terminal to be a triple-level terminal expands this entry.

 So, all we did is select a part number that is for a triple-level terminal and the Terminal Strip Editor expands the grid to show the extra two unused terminal positions.

Wait a minute… how does the Terminal Strip Editor know that this particular Entrelec part number is supposed to be a triple-level terminal? Excellent question… this is all set up in terminal property tables in the AutoCAD Electrical catalog lookup database file (below).

Above is the entry for this Entrelec terminal. It is flagged as “3” levels deep.

Back to the demo…

Next we highlight it and the next two terminals (the other two wires for this first motor). We want to include these two wires as the 2nd and 3rd levels of the first 3-level terminal.

Select terminals 2 and 3 using the CTRL key and click the “Associate” button under the “Multi-Level” category of the menu.

Hint: The graphic at the left indicates a multilevel terminal with three levels but only one level is in use at the moment.

Next highlight the selection on the left as shown. Hit the “Associate” button. This will move the two highlighted entries in with the main 3-level terminal.

The first three single terminals are now combined into a single 3-level terminal.

Repeat the process for the other two sets of 3-terminals. Use the “Copy Catalog Number” and “Paste Catalog Number” commands to copy the first terminal’s part number assignment down to terminals 4 and 7, converting each of them to a 3-level terminal.

Selecting “Layout Preview” to check on progress, we see our three triple-level terminals now in place and the other unused terminals now shown spare.

At this point we can go back in to the Terminal Strip tab, highlight one of the spares in each group, right-click, and select “Spare” –> “Delete”.

We could convert the other spares to separator plates, end plates, of end barriers, as-needed, by clicking the “Catalog Code Assignment” tab and looking up the appropriate part numbers.

Hint: Pretty much everything in the icon menu at the bottom of the Terminal Strip Editor dialog can be accomplished from a context-driven right-click menu.  Just select a terminal and right-click to see the menu options.

There it is. The two terminal strips inserted into the panel layout and linked back to the schematics.

Now let’s do some clean-up on the TB-2. We need to add in an “End Stop” accessory at the top and the bottom of this TB-2 terminal strip. Re-launch Terminal Strip Editor and select TB-2.

Add an End Stop before the very first terminal. To do this, highlight the first terminal in the editor dialog. Then right-click on the highlighted entry and pick “Accessories” and then “Insert”.

The “terminal number” cannot be left blank for accessory items, even though this is not really a terminal. Just enter “ES” for its terminal number.

 Enter “ENTRELEC” and part number “0103 002.26” for the “End Stop” … or do “Catalog Lookup” to select the end stop accessory item.

 Exit this sub-dialog by hitting the “Insert Above” button. Follow same process to insert the second End Stop at the bottom of the terminal strip.

Selecting “Layout Preview” we see the end stop accessory items added in to our TB-2 terminal strip. Hit “Rebuild” button to cause the existing terminal strip layout to rebuild and now show the end stops added at each end of the strip.

This Entrelec triple-level terminal symbol has each pair of terminals and associated wire connection data color-coded. This suggestion came from Doug McAlexander to make it easier to visually associate each of the three wire number pairs with its color-coded terminal number.

These terminal symbols are just regular AutoCAD blocks with attributes. You can adjust as you see fit. The default root folder for footprint symbols for your project is defined in the active project.

Right-click on the project name in the AcadE “Project Manager” dialog and select “Properties…” to display the dialog shown above.

October 18, 2010

Tutorial – Terminal Strip Editor (Part 2) – AutoCAD Electrical

Filed under: Electrical, Tutorials — nateholt @ 9:32 pm

Terminal block management and the “Terminal Strip Editor” tool

Note: access part 1 of this tutorial here.

Autodesk’s Nathan Eliason hosted a webcast last week that focused on AutoCAD Electrical’s ability to insert, track, and manage terminal blocks / terminal strips in a project drawing set. I helped put the demo together and was responsible for real-time Q & A support while Nathan was “on stage”. 

Also thanks to Doug McAlexander for some of the images and samples.

Part 2

This posting is a brief summary of what Nathan covered in the third quarter of the hour-long webcast. This part deals mainly with the panel-layout end of things, using AutoCAD Electrical’s “Terminal Strip Editor” tool.

Hopefully this posting can serve as a simple overview / tutorial of this Terminal Strip Editor feature.

Using the Terminal Strip Editor tool

The first part of the tutorial ended with field terminals inserted for these five three-phase motor circuits. The first and last motor wiring go thorugh terminal strip “TB-1″ and the middle three through terminal strip “TB-2″.

Fifteen terminals added… but we have not made any part number assignments to these terminals. In the first part of the tutorial, when we added these terminals, we left the MFG/CAT attribute edit boxes blank when we popped them in.

That’s okay. In fact, it may be the preferred approach… just pop in terminals in the schematics and don’t worry about assigning part numbers. Do that later with the “Terminal Strip Editor” tool.

 Here’s how. Let’s first go to our Panel Layout drawing.

What we want to do is insert a physical representation of our “TB-1” terminal strip on to this panel layout drawing, right there near the top of that piece of DIN rail.

In the process of doing this we will actually make our catalog assignments to the terminals of “TB-1”, create a to-scale representation of the terminal strip, and then automatically update all of the schematic terminals with the catalog assignment we picked in the Terminal Strip Editor session.

Launch the “Terminal Strip Editor” as shown above.

The initial dialog lists all of the terminal strip “Tag strip” values found in the project drawing set.

 Pick on the “TB-1” entries and hit the “Edit” button.

The Terminal Strip Editor tool displays the above dialog and fills it with a list of all of the TB-1 schematic terminals found in the active project.

A key missing piece of data is the catalog assignment, highlighted in yellow here. Without this assignment, it will not be possible for Terminal Strip Editor to generate a to-scale representation of the terminal strip.  Instead the Terminal Strip Editor will resort to generic terminal symbols that it uses when no specific part number assignment has been made.

So, let’s make a catalog assignment…

First, highlight all of the terminals displayed in the window. We want to assign the same part number to all terminals in this terminal strip.

Hint: You can use the SHIFT or CONTROL keys on your keyboard, or simply left-click in the row for the first terminal block and drag the mouse cursor to the last terminal block, while keeping the left click button pressed.

Select the “Catalog Lookup” button.

This brings up the normal AutoCAD Electrical catalog lookup dialog, pointing at the TRMS terminals table.

Let’s select manufacturer “ENTRELEC”, type “FEED-THROUGH”, and rating “65AMPS”…

Pick the 0115 228.27 selection shown here…. OR…

… the type-ahead-filtering feature is a nice improvement found starting in AutoCAD Electrical 2011’s catalog lookup dialog. Just start typing the part number in the box here. The dialog will dynamically filter down to the remaining possibilities with each key-stroke.

 Note: Make sure that you’ve selected “Select All” in the MANUFACTURER, TYPE, and RATING columns.

So, at this point we’ve selected the catalog part number for the terminals. The ENTRELEC part number gets assigns to all six of the highlighted terminal rows.

Now select the “Layout Preview” tab.

Here’s what the terminal strip will look like (below). Looking good. The wiring from the motor starter overloads comes in on the left and the field wiring out to the motor safety switches exits on the right.

Hit “Insert” and place it over the top part of the DIN rail in the panel layout drawing.

Hint: You can select an angle on insert setting of 90 to insert a terminal strip horizontally.  The Terminal Strip Editor defaults to a vertical orientation so we can view the terminal text from left to right  to keep from turning our head sideways (!).

There it is (above)… “TB-1”. Six terminals, each one annotated with data pulled from the schematic.

Note: The screen-shot above shows AutoCAD Electrical 2011. But if you are running AcadE 2010 or prior, there is one anomaly in the insertion… both the wire number and terminal number attributes are visible between the two screws of each terminal footprint symbol. You can use the tool shown below to do some adjustment.

As necessary, use this “Hide Attribute” tool under the “Schematic” section of the ribbon menu to carefully hide the wire number attribute on each terminal symbol.

Switching “internal wiring” side of terminal strip with Terminal Strip Editor

Let’s say that we decide to bring the field wiring for TB-1 into the panel on the left-hand side of the enclosure. It makes sense to just move things around and put the TB-1 terminal strip on the left side of the back-plate.

But, there’s one thing we need to clean up. The terminal strip shows field wiring on the right-hand side of the terminal strip.  We really need to flip the wiring from side to side… put the internal wiring from the overloads on the right-hand side and the field wiring leaving on the left-hand side.

 Re-launch Terminal Strip Editor and go to the “Terminal Strip” tab. Follow the sequence illustrated below.

Select each entry in turn and flip the wiring as shown above. Then, when all have been swapped between left and right, take a look at the “Layout Preview”. If it looks good, hit the “Rebuild” button to push these changes out to the panel layout terminal strip representation.

Terminal Strip Editor will automatically go back to the schematics and add some data to these schematic terminal symbols to indicate the swapped internal/external wiring configuration.

There it is! That concludes part 2.

Next time we’ll insert tripe-level terminals with the Terminal Strip Editor tool to deal with the three middle motor circuits.

UPDATE: here are panel-related postings

Tutorial – Basics of ‘Smart’ Panel Layout (Part 1)  
Tutorial – Basics of ‘Smart’ Panel Layout (Part 2)  
Tutorial – Basics of ‘Smart’ Panel Layout (Part 3)
Tutorial – Mapping schematic components to panel layout
Tutorial – Automatic Wire Annotation from Schematic to W/D (Part 1)

October 16, 2010

Tutorial – Terminal Strip Management (Part 1) – AutoCAD Electrical

Filed under: Electrical, Tutorials — nateholt @ 5:31 pm

Autodesk’s Nathan Eliason hosted a webcast earlier this week that focused on AutoCAD Electrical’s ability to insert, track, and manage terminal blocks / terminal strips in a project drawing set. I helped put the demo together and was responsible for real-time Q & A support while Nathan was “on stage”. 

Also thanks to Doug McAlexander for some of the images and samples.

This posting is a brief summary of what Nathan covered in the first half of the hour-long webcast. This part deals with the “schematic” end of things… inserting and tracking terminal assignments in electrical schematics. The second part (to be posted soon), deals more with the panel layout end of things and focuses on the AutoCAD Electrical “Terminal Strip Editor” tool.

Hopefully this posting can serve as a simple overview / tutorial of this AutoCAD Electrical feature.

The above looks simple enough, right? Wire goes in. Wire comes out. Put a number on the little label between the two screws. That’s the physical part and it doesn’t look too complicated…

And above, on the electrical schematic, wire coming in, wire coming out, terminal label in the middle. Looks simple enough. How can this be complicated?

At least seven complicating factors… not to mention the sheer number of terminals that may end up in an electrical controls design.

 Let’s start at the top and look at terminal behavior and terminal numbering supported by AutoCAD Electrical. There are three different types of schematic terminal behaviors supported by AutoCAD Electrical.

Type 1 – Terminal with fixed, assigned number

Here is the first type of schematic terminal symbol… shown here as a round symbol with text. These terminal symbols can be of various shapes… but they are all just simple AutoCAD blocks with certain key attributes. More on this in a bit.


Key characteristics of this “Type 1” terminal symbol:  it carries an assigned terminal number value; it maintains the wire number through the terminal; it carries a “terminal strip” assignment; it can carry a part number assignment.

Type 2 – same as type 1 but forces wire number change through it

Here is an example of the second type of schematic terminal. Same as type 1 but this one triggers AutoCAD Electrical to generate a wire number change through it. The type 1 terminal simply maintained its attached wire number through it – wire number coming in was the same leaving. Here, for type 2, it changes

Key characteristics:  it carries an assigned terminal number value; it triggers a wire number change from one side of the terminal to the other; it carries a “terminal strip” assignment; it can carry a part number assignment.

Below is a “worst case” version of this second type of terminal. There are five wires tied to the four wire connection points carried on the terminal symbol.

Note that AutoCAD Electrical has generated four unique wire numbers. Why not five? This is because two of the wires come together at a common wire connection point on the terminal symbol. These two wires do not actually “to through” the terminal and wire the number does not change between them.

Type 3 – automatically takes on wire number that passes through it

This terminal type takes on a copy of the connected wire number as its displayed terminal number.

Key characteristics:  it automatically carries a terminal number equal to the wire number that passes through the terminal;  it maintains the wire number through the terminal (not like Type 2); it carries a “terminal strip” assignment; it can carry a part number assignment.

 Note in the example above it’s a bit cluttered. We have the wire number shown on the type 3 terminal but we also have the wire number shown on the wire itself. Is there a good way to suppress this default AutoCAD Electrical behavior regarding wire numbers tied to type 3 terminals?…


This project-wide setting (below) can be set to suppress wire number text from appearing on a wire network that has a “wire number” type terminal somewhere in it. The wire numbers on these networks are flipped to layer “WIRENO_HIDE” which is then marked “frozen”. What remain are the wire numbers shown on the wire number terminals (and any wire numbers on networks without any wire number terminals).

To enable this project-wide mode of operation, right-click on the active project in the AcadE “Project Manager” dialog and make the selection as shown above. This does not take effect until wire numbers are inserted or freshened on the project’s drawings.

 Note: this feature works on “normal” wire numbers only… it does not move “Fixed” wire numbers to the WIRENO_HIDE layer. To hide a “fixed” wire number, use the “Hide” Wire Number command or “Hide Attribute” command.

The three different behaviors of terminals (wire number, terminal number, and whether terminal breaks the wire number through it) are controlled by the terminal block name and presence or absence of certain attributes.

 The two terminal number symbols are essentially identical except for the 3rd character of the block name. If the 3rd character is a “0” then the wire number does not change through the symbol. If it is a “1” then this causes the symbol to trigger a wire number change through it.

Schematic Terminal selection – via Icon Menu pick

So how do I select my terminal type and terminal shape so I can insert these things into my schematics?

The three different terminal types are selectable in various shapes on the icon menu. Here is how to launch the icon menu from the “Schematic” section of the ribbon menu…


… and then picking on the “Terminals/Connectors” main icon brings up the page below for selection of the individual terminal symbols.


The first column above shows just “dumb” terminal representations. These are not tag-able or extractable into reports. The 2nd, 3rd, and 4th columns show terminals based upon wire number, terminal number, and terminal number that triggers a wire number change through the terminal symbol.

Demo example

Let’s try it on this schematic below.  Three 3-phase motor starter circuits are shown. For each of these motors, let’s add some square terminal symbols between the overload symbol and the left-hand side of the field disconnect switch.

Launch the schematic Icon Menu and drill down to the square terminal with terminal number in screen-shot below. Pick it and pop it in right on the upper phase wire of the first motor circuit.

The square terminal pops in and breaks and reconnects the wires. The existing wire number re-centers itself. An edit dialog pops up.

Here, enter “TB-1” for the terminal strip “Tag Strip:” name. Enter “1” as the terminal “Number:”.

 Now, to save time, hit “OK-Repeat”. This keeps us “in the command” and let’s us pop in the 2nd square terminal immediately (instead of having to reselect from the icon menu).  With each “OK-Repeat” selection, the dialog pops up with the previous selections except for the “Number:” entry. It auto-increments to the next available terminal sequential number.  After the 3rd terminal insert, exit the dialog with “OK” instead of “OK-Repeat” and the command will exit its “looping” and return to the AutoCAD “Command:” prompt.

Using Fence Insert for Incrementing terminal inserts

That was easy, but maybe a bit tedious. Let’s use a different approach to insert nine “TB-2” square terminals on the next three motor circuits.

Start the “Icon Menu” but do it from the “Multiple Insert (Icon Menu)” button shown here. Pick the square terminal from the Icon Menu, just like before…

… but you get kicked into a “Fence” crossing mode. Draw a fence crossing all nine wires of the three motor circuits below.

A square terminal pops in at the very first fence crossing point with a wire. We hit “OK” to keep this one.

The normal Insert/Edit Terminal dialog pops open. Enter “TB-2” for the terminal strip’s “Tag Strip” name and enter “1” as the very first terminal number. Hit “OK” to exit the dialog and move on to the next.


The initial terminal is now inserted at the first fence crossing point. It has the tag “TB-2” and starting at terminal “1”.

Now, for the remaining eight terminals, we can just pre-select “Keep all, don’t ask” and turn off the “Show edit dialog” option. Hit “OK” and let it rip.


And there they are!

Managing next available terminal for a given terminal strip

To finish up, let’s insert three terminals on the bottom motor. But let’s tie them to the next available terminals on “TB-1” (not “TB-2”).

Use the “Multiple Insert (Icon Menu)” like last time and select the square terminal again. Draw a fence through the bottom three wires for the last motor circuit.

 The first terminal pops in and dialog shows up. We want “TB-1” but it defaults to “TB-2” which was the last terminal strip we worked on. Flip it to “TB-1” in the lower part of the dialog.


The moment we select “TB-1”, the dialog pre-fills with appropriate information related to this terminal strip. A key piece of data is the next unused terminal number, “4”, automatically filling in to the “Number:” edit box.

 We just hit “OK” and let the three incrementing terminals pop in. So there we are… all five motor starter T-leads have the terminals popped in between the starter overload and the field safety switch.

Wait, what about catalog part number assignments ?!!

We didn’t assign catalog part numbers to the terminals… could we have?, yes. But it sometimes may make better sense to just pop them in and later, at the panel layout stage, make those assignments. This is pretty easy using the “Terminal Strip Editor” tool.

Check out Part 2 for this.


Nate Holt.

October 10, 2010

Tutorial – Using Excel with AutoCAD Electrical – (Part 5 – PLC I/O desc addr updates)

Filed under: Electrical, Tutorials — nateholt @ 7:57 pm

 (Part 5 – Updating drawing PLC I/O Description and Address text from Excel)

This is the 5th installment of the Excel / AutoCAD Electrical tutorial. The first four 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 – Editing wire number assignments from Excel and then pushing the edits back into the project drawing set

In “Part 1” we did some simple drawing updates based upon schematic component info held in the “COMP” sheet. But there are sheets for seven other categories of terminals, PLC I/O, wire numbers, and panel components.

5th Installment – Updating drawing PLC I/O Description and Address text from Excel

Repeating here what we did in part 1 of the tutorial, this is how we initiated the dump of key data categories of our active AutoCAD Electrical project out to an Excel spreadsheet.

After the dump above creates the Excel spreadsheet, we open up the PLCIODESC sheet (or SHEET1 if selected the option marked in yellow above). Here’s part of the PLCIODESC sheet (below). There is one row for each I/O point of each I/O module found in the schematic project drawing set.

We can edit the I/O address for each point or we can add in up to five lines of description text for each I/O point, right here in the spreadsheet.

Below is an example where we’ve replaced three “SPARE” I/O points with actual description assignments.

We can enter up to five lines of text for each I/O point.

Then, on the update “From Spreadsheet”, this data will find the proper I/O module (using the “handle” and the “drawing name” link as described earlier) and update the appropriate description text attributes on the I/O module.

Note: See “Step 4 – Trigger the Excel –> Drawing update” in the Part 1 of the tutorial for complete step-by-step of this “From Spreadsheet” update sequence.

September 29, 2010

Insert Circuit – Dynamically pairing of unique wire Source/Dest codes – AutoCAD Electrical

Filed under: Electrical — nateholt @ 2:11 pm

AutoCAD Electrical’s “Insert Circuit” command is powerful with auto-tagging and such… but if the inserted circuit is popped in multiple times and it carries source/destination wire connection arrow pairs, then you need to edit these codes each time to keep them unique.

Here’s an AcadE “add-on” tool distributed by Doug McAlexander that make AcadE do this automatically. The normal AutoCAD Electrical dialog pops up, as shown below… just make sure that the toggle is set as shown. Then the tool seems to do the rest… doing a project-wide check on Source/Dest codes in use and picking a next available pair for the newly inserted circuit.

Here is link to demo video of the add-in in action. Doug’s site is here.

Older Posts »

The Shocking Blue Green Theme. Blog at


Get every new post delivered to your Inbox.

Join 32 other followers