(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.