![]() ![]() This will dump about eight different categories of project data out to an Excel spreadsheet. On the dialog that pops open let’s pick the “General” category output. ![]() On the ribbon under “Import/Export Data” we select the “To Spreadsheet” tool. So we’re going to use AutoCAD Electrical’s Excel editing interface to adjust tags, wire numbers, and catalog assignments of our copied drawing set.įirst step is to dump the project drawing set’s data out to an Excel spreadsheet. But wouldn’t it be nice to just do these edits from within the comfortable environment of an Excel spreadsheet ?!! ![]() We can use some of the editing tools in AutoCAD Electrical, pick and edit. Our new project requires us to edit tags, wire numbers, and make some changes in catalog part number assignments. … but they remain a carbon-copy of the original project drawing set. Our old project and drawings are copied and renamed… You’ll need to close that drawing or drawings and start over ( ! ).ġ.6 Find/Replace to adjust the copied drawing names and hit OK. Note: is you have even one of the selected drawings open in your AutoCAD session, the Copy Project command will stop right here with an alert dialog. The old drawings remain in the old project… we’re just making copies of the “.dwg” files to move into this new project. Let’s call it “WDDEMO_LINE2”.ġ.5 Now select all drawings from old project to copy into this new project. Let’s use the tool…ġ.1 Go to the “Project” portion of the AutoCAD Electrical ribbon.ġ.2 Select “Copy” button near the left-hand end of the ribbonġ.3 Select the “Copy Active Project” buttonġ.4 Enter a unique, new name for the copied project. ** OR ** – you can just use the Copy Project tool built into AutoCAD Electrical. You can do this by hand using normal Windows file copy and file rename… Step 1 – make a copy of the existing “WDDEMO” project and its drawings Note: this Excel-editing capability has been in AutoCAD Electrical for many, many releases… it is not limited to the latest ACE 2011 release. So in our tutorial today, let’s go through the steps of how to do this. We’ll just use the demo project that ships with AutoCAD Electrical as our “existing” project that we will copy and modify using Excel. The edits to component tags, wire numbers, and catalog assignments can be eased by using Excel as an editing interface to the copied drawing set. And we’ll probably need to make a few adjustments in catalog part number assignments. Then, to finish, we need to do some re-tagging components and wire numbers to keep them unique from the original production line. This means copying it and its drawings to new names. To speed things up, we just want to re-cycle the existing AutoCAD Electrical project. This will basically be a copy of the one we designed with AutoCAD Electrical a couple years ago. Word coming down from corporate headquarters is that we need to add another production line. Let’s pretend that the economy is starting to pick back up. Re-cycling a Copied Project – Using Excel to Re-tag/Re-number/Re-assign (NOTE: 100+ other AutoCAD Electrical utilities indexed here.) It might serve as a simple overview / tutorial of this AutoCAD Electrical feature. This posting is a brief summary of what Nathan covered in the first part of the hour-long webcast – using Excel to quickly revise a copied project. I helped put the demo together and was responsible for real-time Q & A support while Nathan was “on stage”. Autodesk’s Nathan Eliason hosted a webcast earlier today that focused on AutoCAD Electrical’s ability to use Excel to edit its drawing sets. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |