From the course: AutoCAD Electrical Essential Training
Unlock the full course today
Join today to access over 22,400 courses taught by industry experts or purchase this course individually.
Update a project from a spreadsheet
From the course: AutoCAD Electrical Essential Training
Update a project from a spreadsheet
- We're starting this particular video with Microsoft Excel. And you can see I've got the DEMO02.XLS file open. There it is, the name's at the top of the screen. And this is the xls file that we exported out in the previous video. Remember we did it from drawing demo02.dwg, and it was purely component data. Now I'm going to make some changes to the exported spreadsheet and then import those changes back into the drawing via the spreadsheet. So let's go down to the bottom of the spreadsheet and you'll see some motors there. There's a conveyor motor, a hydraulic motor and an indexing motor. We're going to change these values here. So we've got MOT208, MOT212 and MOT216. I'm going to change those, here, like so. So this is going to become 550, this one'll become 600 and this one'll become 650 like that. So we're just changing those values there. Go back up to the top of the spreadsheet, click on that top left cell there and then save it like so. So I've made those changes in the…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.