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.