In this lesson, export your spec to Microsoft Excel in order to make some edits, and then import it back into your spec to apply the changes to your spec.
- [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 data.…So the full spec data export is what we want to have here.…
- Using part filters
- Modifying parts
- Adding new parts to a catalog
- Using the Spec Editor
- Creating a new spec
- Adding components to a spec
- Editing parts
- Using Part Use Priority
- Editing specs in Excel
- Setting up and modifying a branch table
- Testing components and branch tables
Skill Level Beginner
Q: This course was updated on 11/16/2018. What changed?
A: The following topic was updated: locating the specs and catalogs within the project folders.
AutoCAD P&ID Essential Training: Administratorwith Irene Radcliffe3h 35m Intermediate
AutoCAD P&ID Essential Training: Userwith Irene Radcliffe3h 36m Intermediate
AutoCAD Plant 3D Essential Training: Adminwith Irene Radcliffe5h 21m Intermediate
1. Getting Started
4. Branch Tables
Next steps1m 8s
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.