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 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 millimeters 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 top most level of the pile.

Another update I did was to convert the result from “String.Remove” node to number using “String.ToNumber” node in order for me to convert the unit as well from millimeters to meters. As you may already know, the information provided by “String.Remove” node are considered as string and this is the reason why I need to convert it to 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, here is the script.

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 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 sleepless night.

@Silvia Taurer @Rui Gavina

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

Few photos 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 to register 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 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

 

BILT EUR 2018 Laboratory Session 2.2: Structural Data Mining Using Revit-Dynamo-Power BI Workflow

In less than a month will begin the BILT EUR 2018 which will be held at GR – Ljubljana Exhibition and Convention Centre, Ljubljana, Slovenia from October 11-13.

In my previous BILT appearances this year, BILT Asia 2018 and BILT ANZ 2018, my presentation focused on live demonstration; explaining how the workflow works from start to finish. Fortunately, I did not experience any technical issues and the live demonstration went very well.

This time, on my last appearance this year at BILT community as speaker, I made a change in the way I’ll deliver my topic. Why not come to my laboratory session? I want you all to experience, right there and then, how this workflow works. It’s pretty simple and it is open to any level. If you happen to be an expert and would like to comment or provide additional information in improving the workflow, I am more than happy and will appreciate it much if you could come to me after the laboratory session to have a little knowledge sharing session. We will all learn from each other. Please don’t come to me on the third day as I’ll not be around. I have to fly back to London on Saturday morning and so unfortunate to miss the after event big party, but that’s fine.

For more details on how to purchase a ticket, please visit BILT EUR 2018 website.

By the way, you can avail of 10%  discount off the 3 Day Delegate rate (excluding accommodation) by clicking https://www.eiseverywhere.com/ereg/newreg.php?eventid=294058&discountcode=ALLSCAN12

Code to use will be ALLSCAN12

So, here is my session:

And here’s the agenda for the session:

First, I’ll demonstrate the process of preparing the data you need using Revit schedules. I bet this part is the easiest one for all of you. Nothing is so much exciting about this.

Next, since Power BI works smoothly with Microsoft Excel, We’ll use Excel to store our data mined information from Revit.

After that, we’ll create a simple Dynamo graph to automate the process of sending the information from Revit to spreadsheet. Thus, eradicating potential human error caused by copy and pasting or manual typing.

And finally, we’ll bring the data to life using Power BI. You’ll all learn a basic understanding on how to build your Power BI project.

I hope to see you all in my session.

Once again, here are the details:

Date: Friday, October 12, 2018

Laboratory Session: 2.2

Presentation Topic: Structural Data Mining Using Revit-Dynamo-Power BI Workflow

Presentation Time: 11:00am – 12:15pm

Duration: 75 Minute laboratory session (including question time)

Categories/ Level: Structure, Data Management, Autodesk Revit | All Levels

I am very excited now to deliver the presentation with you and if in case you’ve found the presentation to be helpful, why not share my blog across social networks?

If you weren’t able to attend the BILT Conference, you can get a copy of the tutorial that I spent time writing by visiting the link below:

Revit-Dynamo-Power BI Workflow ebook

For the complete BILT EUR 2018 program, please visit: http://www.rtcevents.com/bilt/eur18/schedule/

Cheers,

Allan Cantos, EngTech MICE

BSc. Civil Engineering / Principal Structural Technician

Revit-Dynamo-Power BI Guide eBook on sale!

Click the image below to get your copy.

Any issues, errors or corrections, please give me a shout and I’ll sort it out quickly.

Happy reading and doing the exercises .

I trust you’ll find the tutorial helpful.

Best regards,

Allan Cantos EngTech MICE

BSc Civil Engineering / Principal Structural Technician

 

 

Engineering BILT just for you

Hi. If you’re not following the news at BILT Community, allow me to share with you the news released today for those who will be joining us at BILT EUR 2018 this coming October 11-13 to be held at Ljubljana, Slovenia; and undecided yet of which sessions to pick. This will help you decide which session that best suit your discipline.

Grab your ticket now if you haven’t purchased one yet.

Please click the link below for further reading.

Engineering BILT just for you

I hope to see you at BILT EUR.

Cheers,

Allan Cantos, EngTech MICE

BILT ANZ 2018 Speaker Feedback

Hello everyone,

I trust you are all doing well.

Allow me to share with you some feedback I received from attendees of my session at BILT ANZ 2018 held in Royal International Convention Centre, Brisbane Australia on the 25th of May 2018.

Statistics for your references
Of 96 sessions (presented by 81 speakers)

12 – received an excellent

81 – received a good,

3 – received an average

0 – poor

0 – not rated.

Average Speaker Score: 2.42 | Average Material Score: 2.43

Session number: 2.5

Topic: Structural Data Mining using Revit-Dynamo-PowerBI Workflow

How would you rate this speaker (*Average Speaker Score): 2.36

How do you rate the quality of the speaker materials (*Average Class Material Score): 2.63

Number of responses: 7 (I’ve got 13 delegates who attended my session from 24 delegates who registered for the session and only 7 gave their feedback).

A selection of comments:

  • Well presented and structured presentation
  • Very knowledgeable with the topic
  • Well defined notes. Will make it easy to understand when I get back to the office.*Attendees rated speakers as follows:
    3 = Excellent, 2 = Good, 1 = Average, 0 = Poor

If you happened to be one of the attendees in my session, your feedback is highly appreciated and thank you for your support. I hope you learned something new in attending my session.

Have a wonderful day.

Cheers,

Allan Cantos EngTech MICE

Session 2.5: Structural Data Mining Using Revit-Dynamo-Power BI Workflow

After 21 hours of long travel (7 hours from LHR-AUH and 14 hours from AUH-BNE), my wife and I finally arrived at Brisbane airport.

Tomorrow will begin the BILT ANZ 2018 which is expected to break the past BILT ANZ attendance. My understanding is, the current attendance already reached 490 and still counting.

If you are looking for a session where you are interested in transforming your Revit data to life, please come to my session and I’ll have a live demonstration of the workflow.

Here is my agenda for the session:

First, I’ll demonstrate the process of preparing the data you need using Revit schedules. I bet this part is the easiest one for all of you. Nothing is so much exciting about this.

Next, since Power BI works smoothly with Microsoft Excel, I’ll use Excel to store our data mined information from Revit.

After that, I’ll create a simple Dynamo graph to automate the process of sending the information from Revit to spreadsheet. Thus, eradicating potential human error caused by copy and pasting or manual typing.

And finally, I’ll bring the data to life using Power BI. You’ll all learn a basic understanding on how to build your Power BI project.

I hope to see you all in my session.

Once again, here are the details:

Date: Friday, 25 May 2018

Session: 2.5

Presentation Topic: Structural Data Mining Using Revit-Dynamo-Power BI Workflow

Presentation Time: 5:00pm – 6:15pm

Duration: 75 Minute Presentation (including question time)

Categories/ Level: Structure, Data Management, Autodesk Revit | All Levels

For the complete program, please visit: http://www.rtcevents.com/bilt/anz18/schedule/

Cheers,

Allan Cantos

Proudly Speaking at BILT ANZ 2018

In four weeks time until BILT ANZ 2018 to be held at Royal International Convention Centre, on 24th – 26th of May 2018, I’ll create another milestone in my career that I’ll never forget.

Similarly with Singapore, coming to Australia will be me my first time. Visa, airfare and hotel accommodation are now sorted.

Date: Friday, 25 May 2018
Session: 2.5
Presentation Topic: Structural Data Mining Using Revit-Dynamo-Powerbi Workflow
Presentation Time: 5:00pm – 6:15pm
Duration: 75 Minute Presentation (including question time)
Categories/ Level: Structure, Data Management, Autodesk Revit | All Levels

Regards,

Allan

BILT Asia 2018 Speaker Feedback

Hello everyone,

Happy sunny and warm Friday, if you are living in the UK.

Allow me to share with you some feedback I received from attendees of my session at BILT Asia 2018 held in Marina Bay Sands, Singapore on the 7th of April 2018.

Session number: 3.1

Topic: Structural Data Mining using Revit-Dynamo-PowerBI Workflow

How would you rate this speaker (*Average Speaker Score): 2.69

How do you rate the quality of the speaker materials (*Average Class Material Score): 2.50

Number of responses: 16

A selection of comments:

  • Well presented and structured presentation.
  • Suggest you have some or all of the schedules prepared for when you present in Australia. You can touch on the important things such as the blank line causes null.
  • Great explanations. Very clear.
  • Could have helped to just breeze through the scheduling part and focus more on Dynamo and Power BI as most of us would have been familiar. But great effort. Super detailed.
  • Obviously knowledgeable. A little slow moving, but good teaching.
  • Great topic. I wanted more Power BI, less Dynamo.
  • The handout is useful and easy to understand.

    *Attendees rated speakers as follows:
    3 = Excellent, 2 = Good, 1 = Average, 0 = Poor

If you happened to be one of the attendees in my session, your feedback will be highly appreciated and thank you for your support. I hope you learned something new which you can apply in your own discipline.

Have a wonderful day.

Cheers,