DY01: Learn to use Dynamo BIM with Spreadsheets

Training

Online

up to £ 100

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

Online

Start date

Different dates availableEnrolment now open

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"

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

This centre's achievements

2020

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

"Introduction
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

up to £ 100