In this video, learn how to export large amounts of data to Microsoft Excel, where it can be updated and then imported back into the project.
- [Instructor] One of the most powerful features…of Plant 3D is that we can export the data…into an Excel spreadsheet…and make the edits externally.…Once complete, we just simply import the spreadsheet…and have the revised data pushed into the drawings.…I'm going to demonstrate this by exporting…an equipment list, adding some data…and then reimporting the data…into the Plant 3D drawing.…Let's go ahead and open 07_05_DATA.…Now, we're going to look in Data Manager…and we're going to look through into our current drawing…and we're going to just filter for pumps.…
Now, you should see three centripetal pumps here.…Now, what I'm going to do is I'm going to export this,…I'm going to add some information such as the manufacturer,…another couple little pieces of information…we can add in and when we import this back in…it should batch update that manufacturer field…inside Data Manager and also inside each piece of equipment.…The way we do this is we filter…through what we want to see…and then up here, up just above the Data Manager window,…
Author
Updated
11/12/2018Released
9/14/2017- Setting up the Plant 3D workspace
- Using on-screen tools
- Working with Plant 3D files
- Creating a new model
- Importing an existing Plant 3D file into a project
- Locating missing drawing files
- Creating a structural grid
- Working with the structural steel component
- Creating equipment
- Basic pipe routing
- Moving and copying data
- Locating components using Data Manager
- Linking P&ID line information to your 3D model
- Orthographic drawings
- Isometric drawings
Skill Level Beginner
Duration
Views
Related Courses
-
AutoCAD P&ID Essential Training: User
with Irene Radcliffe3h 36m Intermediate -
AutoCAD P&ID Essential Training: Administrator
with Irene Radcliffe3h 35m Intermediate -
AutoCAD 2018 Essential Training
with Shaun Bryant9h 51m Beginner
-
Introduction
-
Welcome50s
-
-
1. Getting Started
-
Opening a Plant 3D model2m 30s
-
Using on-screen tools3m 17s
-
2. Working with Plant 3D Files
-
2019 release bug1m 20s
-
Renaming drawing files2m 42s
-
-
3. Structural Steel
-
Structural steel overview3m 42s
-
Creating a structural grid3m 41s
-
Placing structural beams6m 52s
-
Editing structural beams6m 52s
-
Placing ladders3m 5s
-
Placing railings2m 35s
-
Placing footings1m 18s
-
-
4. Equipment
-
Equipment overview2m 31s
-
Creating equipment4m 50s
-
Adding equipment trim3m 8s
-
Equipment templates3m 38s
-
-
5. Piping
-
Piping overview6m 25s
-
Basic pipe routing7m 59s
-
Route pipe from equipment8m 51s
-
Adding branches8m 9s
-
Adding valves12m 35s
-
Adding instrumentation3m 46s
-
Pipe supports5m 21s
-
Sloped piping2m 59s
-
Insulated piping3m 42s
-
-
6. Modify and Reuse Piping
-
Hiding and isolating parts2m 35s
-
Assign new line numbers5m 45s
-
Connecting to xrefs4m 31s
-
Custom Parts Builder6m 46s
-
7. Data Manager
-
Data Manager overview5m 1s
-
Modifying tag data3m 34s
-
Using Data Manager filters2m 48s
-
-
8. P&ID
-
P&ID overview3m 48s
-
-
9. Orthographic Drawings
-
Orthographic overview2m 36s
-
Create adjacent views5m 21s
-
Bill of Materials5m 27s
-
-
10. Isometric Drawings
-
Isometric overview5m 26s
-
Touring the interface4m 18s
-
Reference dimensions5m 36s
-
Lock and issue a line5m 11s
-
PCF to isometric2m 59s
-
-
11. Project Tools
-
Validation settings5m 35s
-
Exporting to AutoCAD4m 6s
-
-
12. Report Creator
-
Report Creator overview7m 45s
-
-
Conclusion
-
Next steps45s
-
- 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.
CancelTake 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.
Share this video
Embed this video
Video: Importing and exporting project data to Excel spreadsheets