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

Exporting Pile Coordinate from Survey Point instead of Project Base Point

How are you doing guys? I trust you enjoyed the summer we experienced in the past days, if you live in the UK. I believe the heatwave is now over according to the news. If you live in different parts of the world, I trust you are well.

In my previous posts about numbering piles using Dynamo without programming knowledge (links provided below), I tried to assign a unique pile number for my piles using Dynamo where I extracted the X and Y coordinates of each pile then export the values to spreadsheet (discussed in Part 1). And in Part 2, because I can’t work out how to sort in X-coordinate and Y-coordinate simultaneously in ascending order, I decided to sort the coordinates in Excel instead to an order that I wanted before assigning a unique pile number. After that, with the help of Dynamo, I pushed back to Revit the pile number value to the assigned Pile parameter.

Here are the links for the 2 parts to refresh you of the process.

Part 1: http://allscan12.com/index.php/2017/09/29/numbering-piles-using-dynamo-part-1-no-programming-knowledge-required/

Part 2: http://allscan12.com/index.php/2017/10/07/numbering-piles-using-dynamo-part-2-no-programming-knowledge-required/

For a challenge, I received a message from one of my blog readers asking me if it is possible to read the coordinates from Survey Point rather than Project Base Point. With his permission, see image below. Hmmmn, how will I do that. I need to do a bit of research here.

Thank you Kieran, by the way, for purchasing a copy of my Revit-Dynamo-Power BI Guidebook and I hope you’ll find it useful. Any question, give me a shout and I’m happy to help.

For some of you who would like to see the live demonstration, please come to my Laboratory Class at BiLT Eur 2018. For more details on how to purchase a ticket, please visit BILT EUR 2018 website.

By the way, from today you can avail of 10%  discount off the 3 Day Delegate rate (excluding accommodation) by clicking on the image below: Code to use will be ALLSCAN12

Anyway, back to our topic, you can achieve this using a third-party Revit plugin called “Excitech Tools”.

And here is the sample information you’ll get by hitting that “Coordinate Schedule” button on your “Excitech Tools” Revit plugin for pile P001 (this is the pile that we will be looking at as an example).

You’ll be provided with coordinates based on Project base Point and Survey Point.

To clearly understand where these values came from, see image below.

And the “Element.GetLocation” node in Dynamo will give you the coordinates relative to the Project Base Point.

In the absence of the third-party Revit plugins, such as the “Excitech Tools” Revit plugin, I will aim to publish the northing and easting coordinates of my piles based on the “Survey Point”. Take note, Survey Point not Project Base Point.

While looking for potential solution to my problem, I came across a discussion in Dynamobim.com Forum about the same issue.

Here is the link to the discussion: https://forum.dynamobim.com/t/getting-coordinates-from-project-base-point-or-from-survey-point/7499

Somehow it gave me an idea of how I’ll achieve my goal, however, the information I’ve got from the forum wasn’t enough to solve the issue.

So, I ended up doing more research and I came across a YouTube video from Mr. David Flynn of Designtech (www.designtech.io).

See the video here: https://www.youtube.com/watch?time_continue=72&v=aIvv1oKDgeQ

Mr. David Flynn is so generous to share the script and the dataset he used in the video for us to download for free and for us to give it a try. So I downloaded the Dynamo script and had a look at it.

Here is what the Dynamo script looks like from Mr. David Flynn of Designtech:

Base on this, I came up with something to achieve my goal; to be able for Dynamo to provide me the pile coordinates from Survey Point instead of Project Base Point. I found some nodes that I needed to make my script work.

Here is my script looks like:

The script, which I named “COORDINATES EXPORTER” in Data-Shapes UI, was set up in a way that you can export to spreadsheet the coordinates from either Survey Point or Project Base Point (depending on the user input). Thanks to Data-Shapes Dynamo package for the UI that I used in this script.

To know more other stuff from Data-Shapes, please visit the website at https://data-shapes.net/.

And here is what you’ll see from Dynamo Player.

Hit play button from the Dynamo Player or hit Run if you are at the Dynamo interface, you’ll be prompted to select from the drop-down list what coordinates type you would like to reference the output coordinates.

First is to select which reference you would like your coordinates to be taken/exported.

And next, you will be able to specify the number of decimal places for the output values.

To give you the idea of the results, please see images below.

With the Survey Point selected under coordinates type:

With the Project Base Point selected under coordinates type:

I have to revisit my script because I specifically asked to have my results to 3 decimal places but when it is zero, it’s not showing up, i.e. I’m expecting a result to be 9100.000 but the actual result gave me only 9100 (without decimal points).

Now to complicate things, let me add some rotation angle to True North, say 110 degrees.

And by applying a rotation Angle to True North, the Survey Point rotates relative to the Project Base Point if it is “clipped”.

You’ll notice that the location of the new Survey Point has shifted and because of that, we have a new coordinate of pile P001 as shown above.

I’ll run the Dynamo script and the “Excitech Tools” Revit plugin just to compare the results. Results are shown below.

And with the Project Base Point selected under coordinates type:

Looks like my script did not take into account the rotation angle to true north because I’ve got different results to what the “Excitech Tools” Revit plugin gave me.

To clearly understand where those “Excitech Tools” Revit plugins results came from, please see images below.

From Project Base Point:

From the new location of Survey Point:

By the way, if you want to keep the Project Base Point Coordinate at (N=2 and E=2), you can re-position your Survey Point anywhere if you wish but make sure to “unclipped” it first (this should be the agreed shared coordinates for all disciplines).

If you want to give this a try, here is the link where you can download this script:

Some of the nodes can be combined using code block, however, to easily understand what is the node doing/required, I tried my best to use the proper node instead. Any issues with the script, improvements, correction, etc. please let me know.

Enjoy!

Cheers,

Allan Cantos

Placing a view to a current sheet using Dynamo

Today, I decided to write my step-by-step procedure on on how to add a certain view on the current sheet using Dynamo. This Dynamo script must also be available to Dynamo Player with a minimum input from the user.

Assuming here is my sheet:

And the view that I would like to add to this sheet is a “WORK IN PROGRESS” stamp that I created as a legend. It should look like the one below.

For this demonstration, let’s keep this view as a “Legend” because I want to point out that whenever you are in this situation, you can’t copy the views under “Legend” from one sheet to another specially if you are aiming to have that view at the same spot to various sheets.

Here is what you’ll get if you select that view (WORK IN PROGRESS) and hit CTRL-C:

You are not allowed to copy a Legend view but there is work around to place it manually and have it exactly at the same position as to the other sheets, however, it will be a bit laborious task. Because of this, I decided to create a Dynamo script to automate this process, so let’s begin building the script.

Here is the first part of my script:

Here is the “Views” node where I specify from the drop down list the view that I would like to add to the sheet.

Next, I’ll specify where on the sheet I would like the “WORK IN PROGRESS” view to appear and here are the nodes that I used:

And finally, here is my set of nodes to place the view on a sheet:

Now, it is time to connect those wires and you should have something like this:

Save the Dynamo Script and name it appropriately. I’ll call mine as “Placing View on Sheet”.

Next, open your Dynamo Player and search for this script.

And here is the little video demonstration of how the scripts works on Dynamo Player:

Here is the link if you want to give it a try: Placing View on Sheet

Have a great day!

Cheers,

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,