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!

    Cheers,

    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:

    Cheers,

    Allan Cantos EngTech MICE

    BSc Civil Engineering / Principal Structural Technician

    Structural Data Mining Using Revit-Dynamo-Power BI Workflow BILT Europe 2018 Class – SOLD OUT!

    Hello BILT Europe 2018 delegates (also applies to those who are visiting my website), I hope you are now ready for a 3-days of fun, networking and learning at BILT Europe 2018 which will begin tomorrow and to be held at GR – Ljubljana Exhibition and Convention Centre. Too many topics to choose from and I bet, you’ll experience having a hard time to choose which one to take if, in the same time slot, you have 2 or 3 topics that you find interesting.

    If you happened to be one of those who would like to attend my class on Friday, 12th of October, but unable to do so, because you missed registering early, please don’t despair. You’ll still have the chance to get a copy of the class manual in more detailed than what’s provided on the conference by visiting HERE.

    This 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 website. Your support is very much appreciated. Thank you in advance.

    Enjoy your BILT Europe visit.

    Cheers.

    Allan Cantos EngTech MICE

    BSc. Civil Engineer / Principal Structural Technician

     

    Positive SSL