Building Information Modelling Newly Released Standards

Hi there. I hope you are all well.

I am sure you are all aware that there are newly released standards to replace BS1192:2007 and PAS 1192-2:2013. I should have written this article when the new standard was released, but I was so busy with lots of things and couldn’t find a time to sit, think and write something for my blog.

Effective 16th of January this year, the British Standards (BS) 1192:2007 and Publicly Available Specifications (PAS) 1192-2:2013 will be withdrawn and to be superseded by BS EN ISO 19650.

BS EN ISO 19650-1:¬†Organization and digitization of information about buildings and civil engineering works, including building information modelling — Information management using building information modelling: Concepts and principles.

BS EN ISO 19650-2: Organization and digitization of information about buildings and civil engineering works, including building information modelling — Information management using building information modelling: Delivery phase of the assets.

For more information and how to get a copy of the other available standards used for Building Information Modelling (BIM), please visit https://bim-level2.org/en/standards/

I don’t have a copy of these standards yet and therefore I could not provide you with any further information about its content.

Have a great day.

Cheers.

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.

How to Share Power BI Reports with Secure Code

Hello there, it’s Allan from Allscan12.

It’s been a while since I wrote my last post. I was just too busy these days. Anyway, I wanted to write a tutorial on how you can publish your Power BI reports with the secure code. However, instead of doing my own screen capture and explanation with the process, I will refer you to another website which explains well in detail how it could be done.

This is only available in Power BI Pro version.

Please visit Reza Rad blog post HERE.

Happy reading and learning.

Cheers