Excel Pivot Tables for BIM QC

As you may recall, in our previous posts we talked about Information as key word on BIM processes and projects. Although loading this data might be the funniest part, at a certain point we will find ourselves diving into a deep ocean of information which need to be sorted and checked to accomplish quality standards.

Keeping our own model clean and organized may not be so difficult if we have a few years working in BIM procedures, but when we work with several collaborators and model authors in the same project we should follow some metodologies to check all this information together and make sure that it is coherent and consistent. Today’s recomendation are the interesting Pivot Tables


Avoiding an endless description regarding benefits of ensuring the quality of the information within our BIM models, today we will focus in one way to perform this task.

To make it interesting, I’ll use our add-in to extract a .CSV from a Federated Navisworks file.

*For downloading it click here

*For the related post click here

Now that we have all the info located in our Excel File, lets get it started…

By clicking in Insert > Pivot Table you will get this:

There you will be able to select all the fields you want in your spreadsheet, as well as filters and calculated values. At this point you will be allowed to create as much tables you need by defining different criterias and crossing the information according to different purposes.

As follows, some samples of Pivot Table that I propose for QC

* Naming Convention

How are we naming elements inside the model? Are they accomplishing the BIM Plan? AreTheyUsingCamelCase? UPPER CASE LETTERS? $ῥeçῙfῙc ŞƴmbӨls#_-?

* Workset Criteria

Are the right elements in the right worksets, according criteria defined by the BIM Plan?

* Material Loaded (“blank filter”)

Do our doors have the material loaded? I’ve specified here to show only the blank field on material Name, so we’ll see only those with no material loaded.

* Reference Levels

Are our foundations referenced to the correct level?

As you can see, we can set differen types of tables according the information we want to check.

Why I choose Pivot Tables?

  • Avoid Revit schedules limitations.
  • Dynamic, fast and easy to modify.
  • Component and System Families in the same Spreadsheet.
  • Refresh data in one click.
  • Get IDs of wrong elements.
  • Show totals, counts and percents.
  • Duplicate and change data source.
  • Expand and collapse data groups.
  • Predefined design styles.

Are you already creating your own table? Please share!

Leave a Reply

Your email address will not be published. Required fields are marked *