Using data from excel to colour code Revit model

Hi, I am new to speckle and trying to workout if the following exercise can be done using Speckle.

It is possible to take data from an excel file and use it to colour code a 3D model from Revit and push the colour coded model into Power BI?

I have a project where we are tracking the off site manufacturing process of a building element and would like to know if speckle can be used to update the 3D model by colour coding the building element based on the status/hold point as it goes through the process of fabrication to installation on site.

Thank you

I’m thinking of two main ways to achieve this, please not that I haven’t tried them and maybe @gokermu can help with a small proof of concept :slight_smile:

  • Send from Revit to PowerBI and from Excel to PowerBI and associate the elements by their ID, you should then be able to color them in PowerBI by your field
  • Send from Excel to Revit to set a parameter on each element with a value you want to color by, then Send from Revit to speckle and load the model in PowerBI. This way, you can also color your model in the Speckle Viewer by the same property.
1 Like

Hi @teocomi thank you so much for the response. If there is a proof of concept that has been done before that would be great.

How would the colouring of the model work in the speckle viewer? Are you able to provide any more detail?

Thank you

1 Like