DY01: Learn to use Dynamo BIM with Spreadsheets
Training
Online
Description
-
Type
Training
-
Methodology
Online
-
Class hours
3h
-
Start date
Different dates available
"This course will let you utilise Dynamo in Revit with spreadsheet file formats such as excel and csv’s for customisation and analysis. We will look at the basic functionalities of using Dynamo to give you some background on the fundamentals of Dynamo before building upon this knowledge.It is important to understand the data that is being used in Dynamo, Revit and excel as this will determine how a Dynamo script is set up. No doubt, as a Dynamo scriptwriter you will encounter errors that would require amendments to the script so it is essential to understand the data you are managing.All this data that you will extracting is perfect for further data analytics.The course will run through 4 exercises to explain the connections between Revit and Excel, and also 3 samples that build on the learnings of the exercises.Target Audience -Professionals in the AEC industry -Data administrators -Non-Programmers -People who want to start using Dynamo for data extraction and transactions Happy Learning!"
Facilities
Location
Start date
Start date
About this course
"Understand the key concepts of Dynamo and Visual ScriptingVisual Scripting Vs Traditional ScriptingUnderstand how to navigate and use DynamoBe able to develop your own Dynamo and Spreadsheet ScriptsManage errors in relation to your Dynamo and Spreadsheet Scripts"
You do not need to be a Programmer to learn Dynamo, you will be interested in how Dynamo works and how you wish to work with Spreadsheets.
"Windows 7 or Windows 10Revit (Ideally 2018) and Dynamo 2.0.0 InstalledMicrosoft Excel InstalledExperience with or have an Understanding to how Revit Works"
"-100% online -Access to the course for life -30 days warranty money back -Available from desktop or mobile app -Can begin and finish the course any time -Can repeat the course any times"
Reviews
This centre's achievements
All courses are up to date
The average rating is higher than 3.7
More than 50 reviews in the last 12 months
This centre has featured on Emagister for 3 years
Subjects
- Excel
- Revit
- Building
- Architecture
- Dynamo
- Spreadsheets
- Script
- VISUAL SCRIPTING
- Traditional scripting
- Analysis
- Dynamo script
- Script Writing
- Data
- Data administration
- AEC
- AEC Industry
- Data Extraction
- CSV
- CSV file
- Sheet creation
Course programme
About Me
What's Required?
What is Visual Scripting and Dynamo
Basics of Dynamo
Opening Dynamo
Dynamo Interface
Auto Vs Manual Execution
Data Types
Nodes
Dynamo Settings
Packages
Exercise 1 - Creating a Write Excel Script
Initial Setup
Creating the Dynamo Script
Transposing
Adding Headings
Exercise 2 - Creating a Read Excel Script
Set Up and Creating the Dynamo Script
Removing Decimal Places
Exercise 3 - Creating a Write csv file
Creating the Dynamo Script
Exercise 4 - Creating a Read csv file
Set Up
Set the Parameters
Sample 1 - Sheet Creation
Title Block Set Up
Creating the Dynamo Script
Sample 2 - Many to Many Spreadsheet
Multiple Schedules into Multiple Sheets
Multiple Schedules into Multiple Spreadsheets
Fixing the Date Export Issue
Sample 3 - Extracting Topo Points from Revit
Writing the Extracting Topo Points Dynamo Script"
DY01: Learn to use Dynamo BIM with Spreadsheets