From the course: AutoCAD Plant 3D Essential Training: Specs & Catalogs

Unlock the full course today

Join today to access over 22,400 courses taught by industry experts or purchase this course individually.

Editing your specs in Excel

Editing your specs in Excel - AutoCAD Plant 3D Tutorial

From the course: AutoCAD Plant 3D Essential Training: Specs & Catalogs

Start my 1-month free trial

Editing your specs in Excel

- [Instructor] When you have a large number of items in a spec, making manual edits using the spec editor can become a little time consuming. Depending on the type of changes you're making, we have the ability to export our spec sheet to excel, and make the changes there instead. For adding things such as commodity codes or purchasing material codes, excel is a much faster tool since you can take advantage of features such as formulas. There's a few things we have to be aware of however, and we'll discuss them in the lesson. So let's run through the process and see how this will work. So we're going to go to our exercise file, we're going to open our spec, desktop, exercise files, 02 08, and let's look at our linked in spec. And just quickly review what's in here. You can see we have some elbows, some flanges, gaskets, pipe, tees, and a couple of valves. So now I'm going to export this using the export to excel button just on the top left. Now we're going to make sure we export spec…

Contents