Loading Schedule form Spreadsheet to Revit: How do you normally do it?

Hi there, Allan here form Allscan12. I trust you are all well.

Recently, I came across one project in Revit 2017 where the technician was having the trouble of how to update/fix the loading schedule already on the Revit sheet.

Here is how the schedule looks like before updating:

Basically, it consists of a schedule and some coloured hatching done as a Legend. The update to be done is adding two more rows; LP10 and LL05.

We do have a third party plugin in the company called BIMLink from Ideate Software company where we can export the spreadsheet, update the values in Excel, and import back the values to our Revit schedules, which really works well.

Let’s take a look at one of the loading key and what are the available parameters.

For whatever reason, you have the parameters but there are no values assigned, however in the schedule, you have the complete information needed.

Normally, if we have the loading plan from the spreadsheet, we link it in AutoCAD then link this DWG to the Revit and we’re done. We have created quickly the loading schedule. However, the downside is, any time you made changes to the spreadsheet you would have to open AutoCAD and re-save it with the update, and then reload the AutoCAD linked in Revit. Sometimes you may need to rebuild the table in AutoCAD if there are lots of changes happened. Another downside is, not all know how to operate AutoCAD. They have to call someone to help/teach them how to do it if that will be their first time to do this method. This is not a great workflow but works well.

I’m intrigued by how this loading schedule was done in this project.

Clearly, upon my investigation, no values have been assigned to the parameters for the ‘Detail Item Filled Region’. So how was this schedule created?

I’ll tell you the secret.

Some of us don’t bother about other options available when creating the schedule. When you right click under ‘Project Browser/Schedules/Quantities’, and select ‘New Schedule/Quantities…’, you’ll have the option to select from the list of categories available.

Since this hatching was done using ‘Detail Items/Filled Region’, let’s create a new schedule under ‘Detail items’ category and the TRICK now is to make sure to select ‘Schedule keys‘. This trick is very useful if you have a table that you would like to add quickly to your sheets.

Then you can start adding the parameters according to the number of columns you needed.

Then followed by adding rows where you’ll be adding the information

Here is that loading plan where I’ve added two rows for LP10 and LL05.

The rest is for you the tidy up the schedule under the ‘Sorting/Grouping, ‘Formatting’ and ‘Appearance’ tab of the schedule properties.

Have you done some schedule in different method? Please share and let’s spread the knowledge.

Have a great day and have a happy weekend.

Cheers.

Dynamo Basics | Training Course by DiRoots

Hey there! I trust you are well.

If you want to learn the basics of Dynamo, DiRoots have released, 2 months ago, a training course for free. On top of that, you’ll also get a certificate for completing the course. I believe it’s worth sharing to spread the knowledge to those who are new and wants to review their knowledge in the use of Dynamo. You may pick up something new from this free course if you’re already using it, who knows?

Anyway, click on the image banner below to direct you to DiRoots Training website.

Dynamo Basics | Training Course

Enjoy and happy learning.

Cheers,

Allan Cantos EngTech MICE

BSc Civil Engineering | Principal Structural Technician

BILT EUR 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 laboratory session at BILT EUR 2018 held at Ljubljana Exhibition and Convention Centre, Ljubljana, Slovenia on the 12th of October 2018.

Statistics for your references

Of 93 sessions (presented by 85 speakers)

9 – received an excellent

70 – received a good,

9 – received an average

0 – poor

0 – not rated.

Average Speaker Score: 2.16 | Average Material Score: 1.52

Here is the link for those speakers who made it to the top 10: Top 10 from BILT Europe 2018.

A big hand of applause to all the speakers who made it to the top 10.

My Laboratory Session number: 2.2

Topic: Structural Data Mining using Revit-Dynamo-Power BI Workflow

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

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

The number of responses: 15 out of 16 attendees

A selection of comments:

  • Was speaking too fast for the accent, but very interesting topic.
  • Very good content. Just could have been a bit slower and make sure everyone is on the same page at each step.
  • Helpful, willing to explain and repeat. Created enough fail-safe points if stuck with the practical part to keep up with lessons.
  • Too much for the short time -> too fast
  • Interesting and a good deep dive into the topic. Perfect for my personal skill level.
  • A good class session, he covered it all and had the time to help out when needed
  • Quite interesting lab – but the speed was rather high. I was able to follow but only be leaving a few of the repetitive items out – maybe that would help others too to relax the timing.
  • Nicely organised content
  • Easy to follow and detailed enough to recreate everything at home again

*Attendees rated speakers as follows:

3 = Excellent, 2 = Good, 1 = Average, 0 = Poor

Considering the topic where we had to look at 3 software packages, four actually with a little bit of Microsoft Excel, for the span of 75 minutes, there are so much to discuss and I did my best to deliver the presentation at slower speed in comparison to that when I delivered this in live presentation (where delegates just watch and listen) during BILT ASIA 2018 and BILT ANZ 2018. Nevertheless, thank you for the wonderful experience of being part of the BILT Europe 2018 family.

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 laboratory session.

Have a wonderful day.

Cheers,

Allan Cantos EngTech MICE

BSc Civil Engineer / Principal Structural Technician