One of the most common features that is attracting architects, engineers, and construction professionals to learn Dynamo is its ability to import various types of non-BIM information formats into the BIM authoring environment. In this video, see how to point Dynamo to an Excel file, read a table consisting of numerical and text data, and gain a basic understanding of how tabular data is structured as nested lists in Dynamo.
- [Instructor] One of Dynamo's most attractive features…to Revit users is its ability to import information…from outside of the BIM environment into a Revit project.…One of these formats, and possibly one…of the most common ways that architects, engineers,…and contractors share information outside of drawings,…is by sharing Excel files, which is information…that's organized in a tabular form, or in rows and columns.…In this video, we'll import the data…from an Excel spreadsheet into Dynamo.…Now, before we do anything in Dynamo, let's take a look…at the spreadsheet that we'll be importing.…
When we open it up, we can see that it has information…about several different types of retail shelving.…One column is a number, or an identifier…of each shelf type, then there's a description…of each shelf type's intended use,…either Shirts, Pants, Footwear, or Accessories.…And then we have the width and the height dimensions…of the shelf type in inches, as well as the number…of shelves that each type should have.…So why are we interested in bringing…
- Placing and connecting Dynamo nodes
- Working with data types and math functions
- Creating number lists and text strings
- Writing data to an Excel spreadsheet
- Filtering and sorting data
- Creating points, curves, surfaces, and solids
- Analyzing geometry
- Linking a Dynamo-driven SAT to Revit
- Placing Revit families with Dynamo
- Creating Revit views and sheets with Dynamo
Skill Level Beginner
Exercise files1m 21s
1. Getting to Know Dynamo
What is Dynamo?6m 9s
2. Working with Data
3. Constructing and Analyzing Geometry
Next steps2m 29s
- 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.