Integrated BIM tools, including Revit, AutoCAD, and Civil 3D
Professional CAD/CAM tools built on Inventor and AutoCAD
Work with the Dynamo player to add coordinates to piles and number piles, as well as export a schedule to Microsoft Excel.
Type:
Tutorial
Length:
6 min.
Transcript
00:04
Dynamo is a graphical programming tool that lets
00:07
you automate many tasks within rev it.
00:09
The software is installed as part of rev it and can
00:12
be located on the manage ribbon in the visual programming panel.
00:16
Dynamo player is a simple method of executing dynamo scripts within a rev project.
00:22
If no inputs are required, the user simply clicks play.
00:25
However, user inputs are displayed by clicking the edit input tool.
00:30
It is quite common to group piles within pile
00:32
caps and assign pile marks in a clockwise direction.
00:36
Dynamo will automatically number each pile using
00:39
the sequence shown in the image below.
00:42
The pining contractor will often require coordinates for each pile.
00:46
And a cut off level
00:47
dynamo would automatically compute the coordinates and the level for
00:51
each pile and add the values to shared parameters.
00:55
All of this data can then be exported to
00:57
Microsoft Excel and then provided to the pining contractor.
01:02
Let's begin by opening up the structural plan at a vote to pit
01:06
in the project browser under structural plans, double click on elevator pit.
01:14
This particular plan shows a pile in layout.
01:17
You can see here that we can see each pile in section.
01:20
Also, here we have a tag presented for each of the piles.
01:24
This is going to read the mark value.
01:27
Let's go ahead and select the pile at location. E one,
01:31
if I select this in the property's pallet under construction,
01:35
you'll note here that we have three shed parameters, East north
01:39
and cut off level. These along with the pile marks will be populated with dynamo.
01:45
Let's also open up the piling schedule
01:48
in the project browser under schedules and quantities.
01:51
Double click on piling schedule.
01:54
We'll then go ahead and close down the 3D working in view
01:58
and to see the schedule in the elevator pit plan side by side, we'll tile the view
02:03
to do this, select the view ribbon
02:05
and on the view ribbon, select tile views.
02:10
We're now ready to launch the dynamo player
02:13
to do this. Let's go ahead and select the manage ribbon
02:16
and on the manage ribbon under the visual programming panel,
02:20
you'll see that we have Dynamo
02:21
and dynamo player. In
02:23
this example, we'll select dynamo player
02:28
by default. The dynamo player will show the sample scripts.
02:32
We're now going to point dynamo player to
02:34
a folder that contains our three dynamo scripts
02:38
to do this. Go ahead and select browse to folder
02:42
in the browser folder, dialog box.
02:44
Go ahead and select the folder that contains our three dynamo scripts. M 01-07
02:50
and then click, OK.
02:53
You'll now see the three dynamo scripts presented in Dynamo player,
02:57
the dynamo scripts will be run in the order that they appear in the dynamo player.
03:02
So let's begin by running the dynamo script that's going to create our coordinates
03:07
to do this. We'll simply click run script.
03:14
You'll now notice that the script has completed and notice in the piling schedule,
03:18
we now have the eastern and northern values populated.
03:22
Let's now click into the elevator pit plan and we'll zoom out
03:26
And here we're now going to run the second script which will number the piles
03:30
once again, go ahead and click, run script
03:33
and you'll then see the piles are numbered accordingly.
03:37
Each pile is now sequentially numbered based on
03:40
the pile cap that was housing the piles.
03:42
So we can see here in the bottom left, this is pile number one
03:46
and we can see here we have a triangular pile cap.
03:48
So of course, here we have pile 23 and four,
03:51
pile five and so on throughout the project.
03:55
Of course, the pining schedule now also has the pile mark populated.
03:59
And finally,
03:60
we're now ready to run our third script to export this data out to Microsoft Excel.
04:05
However, in this example,
04:07
we need to edit the inputs of this dynamo script to point it to the Excel file
04:11
to do this. We'll select edit inputs
04:15
here.
04:16
We're going to navigate to our exercise folder and select the Microsoft XL file.
04:20
So go ahead and click browse
04:22
and in the open dialog box. Go ahead and select the file M 01-07 dot XZSX.
04:29
Let's go ahead and click open.
04:31
And then in the dynamo player, we can again run script,
04:37
you'll then see that Microsoft XL will open.
04:39
And of course, here we can see that we have the column headers, we have the pile mark,
04:44
pile diameter, the pile length east
04:46
north
04:47
and cut off level. This is now ready to be sent directly to the pining contractor.
04:52
So in summary,
04:53
we've used three dynamo scripts and a simple dynamo
04:56
player to automate some very time consuming tasks.
04:60
If we were preparing this data manually, this could have taken many hours.
05:03
But of course, we've now executed this in just a few minutes.
Video transcript
00:04
Dynamo is a graphical programming tool that lets
00:07
you automate many tasks within rev it.
00:09
The software is installed as part of rev it and can
00:12
be located on the manage ribbon in the visual programming panel.
00:16
Dynamo player is a simple method of executing dynamo scripts within a rev project.
00:22
If no inputs are required, the user simply clicks play.
00:25
However, user inputs are displayed by clicking the edit input tool.
00:30
It is quite common to group piles within pile
00:32
caps and assign pile marks in a clockwise direction.
00:36
Dynamo will automatically number each pile using
00:39
the sequence shown in the image below.
00:42
The pining contractor will often require coordinates for each pile.
00:46
And a cut off level
00:47
dynamo would automatically compute the coordinates and the level for
00:51
each pile and add the values to shared parameters.
00:55
All of this data can then be exported to
00:57
Microsoft Excel and then provided to the pining contractor.
01:02
Let's begin by opening up the structural plan at a vote to pit
01:06
in the project browser under structural plans, double click on elevator pit.
01:14
This particular plan shows a pile in layout.
01:17
You can see here that we can see each pile in section.
01:20
Also, here we have a tag presented for each of the piles.
01:24
This is going to read the mark value.
01:27
Let's go ahead and select the pile at location. E one,
01:31
if I select this in the property's pallet under construction,
01:35
you'll note here that we have three shed parameters, East north
01:39
and cut off level. These along with the pile marks will be populated with dynamo.
01:45
Let's also open up the piling schedule
01:48
in the project browser under schedules and quantities.
01:51
Double click on piling schedule.
01:54
We'll then go ahead and close down the 3D working in view
01:58
and to see the schedule in the elevator pit plan side by side, we'll tile the view
02:03
to do this, select the view ribbon
02:05
and on the view ribbon, select tile views.
02:10
We're now ready to launch the dynamo player
02:13
to do this. Let's go ahead and select the manage ribbon
02:16
and on the manage ribbon under the visual programming panel,
02:20
you'll see that we have Dynamo
02:21
and dynamo player. In
02:23
this example, we'll select dynamo player
02:28
by default. The dynamo player will show the sample scripts.
02:32
We're now going to point dynamo player to
02:34
a folder that contains our three dynamo scripts
02:38
to do this. Go ahead and select browse to folder
02:42
in the browser folder, dialog box.
02:44
Go ahead and select the folder that contains our three dynamo scripts. M 01-07
02:50
and then click, OK.
02:53
You'll now see the three dynamo scripts presented in Dynamo player,
02:57
the dynamo scripts will be run in the order that they appear in the dynamo player.
03:02
So let's begin by running the dynamo script that's going to create our coordinates
03:07
to do this. We'll simply click run script.
03:14
You'll now notice that the script has completed and notice in the piling schedule,
03:18
we now have the eastern and northern values populated.
03:22
Let's now click into the elevator pit plan and we'll zoom out
03:26
And here we're now going to run the second script which will number the piles
03:30
once again, go ahead and click, run script
03:33
and you'll then see the piles are numbered accordingly.
03:37
Each pile is now sequentially numbered based on
03:40
the pile cap that was housing the piles.
03:42
So we can see here in the bottom left, this is pile number one
03:46
and we can see here we have a triangular pile cap.
03:48
So of course, here we have pile 23 and four,
03:51
pile five and so on throughout the project.
03:55
Of course, the pining schedule now also has the pile mark populated.
03:59
And finally,
03:60
we're now ready to run our third script to export this data out to Microsoft Excel.
04:05
However, in this example,
04:07
we need to edit the inputs of this dynamo script to point it to the Excel file
04:11
to do this. We'll select edit inputs
04:15
here.
04:16
We're going to navigate to our exercise folder and select the Microsoft XL file.
04:20
So go ahead and click browse
04:22
and in the open dialog box. Go ahead and select the file M 01-07 dot XZSX.
04:29
Let's go ahead and click open.
04:31
And then in the dynamo player, we can again run script,
04:37
you'll then see that Microsoft XL will open.
04:39
And of course, here we can see that we have the column headers, we have the pile mark,
04:44
pile diameter, the pile length east
04:46
north
04:47
and cut off level. This is now ready to be sent directly to the pining contractor.
04:52
So in summary,
04:53
we've used three dynamo scripts and a simple dynamo
04:56
player to automate some very time consuming tasks.
04:60
If we were preparing this data manually, this could have taken many hours.
05:03
But of course, we've now executed this in just a few minutes.
Industry:
Role:
How to buy
Privacy | Do not sell or share my personal information | Cookie preferences | Report noncompliance | Terms of use | Legal | © 2025 Autodesk Inc. All rights reserved
Sign in for the best experience
Save your progress
Get access to courses
Receive personalized recommendations
May we collect and use your data?
Learn more about the Third Party Services we use and our Privacy Statement. May we collect and use your data to tailor your experience?
Explore the benefits of a customized experience by managing your privacy settings for this site or visit our Privacy Statement to learn more about your options.