Revit-Dynamo-Power BI Guide V.2 Released

Hey guys, I made an update with my Revit-Dynamo-Power BI Guide ebook.

If you are one of those who purchased this ebook, you should have received an email with the revised one attached or a separate link where you can download the up-to-date version for FREE.

I would like to thank you for the support. My website will keep on running for as long as there is someone like you who would be willing to spend a small amount to support me in funding my online library. It will be your online library too.

Your support is very much appreciated.

For some of you who haven’t get a copy yet, here are the two links for you to choose from, where you can purchase a copy, depending on your payment option.

Using PayPal:

Revit-Dynamo-Power BI Guide ebook (PayPal)

Using Credit/Debit Card:

Revit-Dynamo-Power BI Guide ebook (Credit/Debit Card)

Have a great day.


Allan Cantos EngTech MICE

BSc. Civil Engineering / Principal Structural Technician

Pile Cut-off Level using Dynamo

If you are following my post, previously, I looked at exporting the pile coordinates either from Survey Point or Project Base Point and explained in details where the results are coming from with the help of diagrams. If you missed that section, you better go back to that article first before continue reading this one.

Here is the link for that article: Exporting Pile Coordinate from Survey Point instead of Project Base Point

Today, I want to give an update to my Dynamo script; to include in my final output the “Pile cut-off level” values for each individual piles on my project.

Here is the project that I’ll be looking at:


And I want to have the same result using the revised Dynamo script to one shown below.

Here is what the script looks like before from Exporting Pile Coordinate from Survey Point instead of Project Base Point:

And here is it now after the upgrade:

And the result when I “Run” the script and the comparison to Excitech Tools:

The first update I did was to extract the z-coordinates (Point.z node) and add 75mm (check this value with your structural engineer) for the “Embedment Length”, then round-up the result before converting the units from millimetres to meters. One thing that you need to make sure is that your pile is attached to the bottom of your pile cap. The 75mm embedment length calculation begins at the topmost level of the pile.

Another update I did was to convert the result from the “String.Remove” node to a number using the “String.ToNumber” node in order for me to convert the unit as well from millimetres to meters. As you may already know, the information provided by the “String.Remove” node is considered as a string and this is the reason why I need to convert it to a number first in order for the “Divide” node to work.

And finally, add a new item, item4, from List.Create node to include the pile cut-off level.

Now I am ready to assign this values to my Northing, Easting, and Pile Cut-off Level project parameters using my separate Dynamo script.

You can use this workflow if you don’t have Excitech Tools installed on your machine as part of your Revit Add-ins.

If you want to give it a try, please fill up a few details below and you will receive the download link.

I welcome your comments, questions, corrections and additional information relating to this article. If you know a better way, please leave your comment, by all means, let me know. Thanks.

Have a great day!


Allan Cantos EngTech MICE

BSc. Civil Engineering / Principal Structural Technician


My BILT Europe 2018 visit has now come to an end

Thank you BILT Europe for the opportunity to be part of the speakers family. My third time presenting my topic this year about Revit-Dynamo-Power BI Workflow but this time, in a class/laboratory setting (with some update and added automation).

Thank you, @Cameron Brennan, for sorting out all the necessary files and software needed for my session.

The Fun Fair gathering last night was really enjoyable, and I had a sleepless night.

@Silvia Taurer @Rui Gavina

#datamining #revit #builteurope #bilt #rtc #bim #enjoyment #dynamo

Few photos were taken when I got the opportunity to go out around the area of Grajska tirna vzpenjača – Castle Funicular:


Allan Cantos EngTech MICE

BSc Civil Engineering / Principal Structural Technician