Have a question?
Message sent Close
4.35 out of 5
4.35
32 reviews on Udemy

DY01: Learn to use Dynamo BIM with Spreadsheets

A Beginner's Course to Getting Started Using Dynamo with Spreadsheets
Instructor:
KIT To
167 students enrolled
English [Auto]
Understand the key concepts of Dynamo and Visual Scripting
Visual Scripting Vs Traditional Scripting
Understand how to navigate and use Dynamo
Be able to develop your own Dynamo and Spreadsheet Scripts
Manage errors in relation to your Dynamo and Spreadsheet Scripts

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!

Introduction

1
About Me
2
What's Required?
3
What is Visual Scripting and Dynamo

Basics of Dynamo

1
Opening Dynamo
2
Dynamo Interface
3
Auto Vs Manual Execution
4
Data Types
5
Nodes
6
Dynamo Settings
7
Packages

Exercise 1 - Creating a Write Excel Script

1
Initial Setup
2
Creating the Dynamo Script
3
Transposing
4
Adding Headings

Exercise 2 - Creating a Read Excel Script

1
Set Up and Creating the Dynamo Script
2
Removing Decimal Places

Exercise 3 - Creating a Write csv file

1
Creating the Dynamo Script

Exercise 4 - Creating a Read csv file

1
Set Up
2
Set the Parameters

Sample 1 - Sheet Creation

1
Title Block Set Up
2
Creating the Dynamo Script

Sample 2 - Many to Many Spreadsheet

1
Multiple Schedules into Multiple Sheets
2
Multiple Schedules into Multiple Spreadsheets
3
Fixing the Date Export Issue

Sample 3 - Extracting Topo Points from Revit

1
Writing the Extracting Topo Points Dynamo Script
You can view and review the lecture materials indefinitely, like an on-demand channel.
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don't have an internet connection, some instructors also let their students download course lectures. That's up to the instructor though, so make sure you get on their good side!
4.4
4.4 out of 5
32 Ratings

Detailed Rating

Stars 5
13
Stars 4
7
Stars 3
12
Stars 2
0
Stars 1
0
a73bc72e91cc49101cdddabc8cb22bb3

Includes

3 hours on-demand video
Certificate of Completion

About

AulaGEO is a Ge-engineering specialized academy.

Social Network

Udemy Black Friday Sale! Top Courses From $9.99