Q'Apps - BIM Tools for Revit

BIM LINK – Synchronize data between Revit and Excel

BIM LINK – Import Value from Excel to Revit

Hi everyone, Q’Apps has been converted to Alpha BIM. Please visit our new website for more information: https://alphabimvn.com/en/

You guys are working in Structural consultant firm will know about the schedule table as below, don't you?

Above is a Beams Reinforcement Schedule of a typical structural consultant. 
Reinforcement values ​​T1, T2, T3, B1, B2, B3, S1, S2, S3 ... are parameters that are attached to the Beams.
The Structural engineer will calculate or adjust these values ​​in Excel file. How to put these values ​​into Parameters T1, T2, T3, ... of each Beam in Revit model with the fastest way, just one click?

And all of us don't want to type each value manually, don't you?

Have you ever expected data synchronization between Excel and Revit model?

Q'Apps understands your difficulties and Q’Apps has debuted a tool

BIM LINK – Synchronize data between Revit and Excel”

One of the outstanding feature of this tool is to help you solve the above problem.
You probably see more other applications of BIM Link here: https://youtu.be/B-jkBBda_zM

And now, let's see my instruction below:

On the Ribbon Add-ins Q'Apps, the location of the BIM Link button is shown below:

Step 1: Export the Parameters of the object to Excel, including ElementID or UniqueID

In this step, you need to use the Add-in Multi-Category Schedule. You can easily recognize this Add-in is located next to BIM Link. 

Interface of Add-in Multi - Category Schedule

This add-in is used to export Parameters from Revit to Excel. In this article I used to export Beam Reinforcement parameters.

The setup parameters as shown above correspond to the typical Beam Reinforcement detail below:

Above I show the typical detail for single span Beam, depending on each case that you can adjust the parameters to suit your requirements.

Afterward, let's go to Filter and Sorting

Using filter and sort by Parameter value. You can leave this item blank.

Finally, this is task Save and Load Setting

Surely, you don't want to do repetitively the action of setting the Parameter to export datas ​​to Excel? Or you switch to another computer and you don't want to do reset what you did earlier. Menu Save and Load Setting will help you solve that problem.

Finally, click Export button to export Beam data to Excel. The engineer will design or adjust the Rebar parameters T1, T2, T3, B1, B2, B3, S1, S2, S3 ... for Beams on this file. Then, you will use the BIM Link Add-in to update these design data to the Revit model.

Step 2: Import data from Excel file into Revit

This step you use the Add-in BIM Link

  • Path Excel: Select the Excel file path.
  • WorkSheet: Sheet page in the Excel file contains data need to be synchronized into Revit.
  • Header Range Parameter: The range contains the Parameter values to be synchronized into Revit. You probably enter discontinuous regions, follow the syntax I instructed in the Textbox as shown above.
    • Example: You want to synchronize the Rebar data as shown below you will type: "E1:M1″
  • First cell of range values: The first cell of the value range
    • Following the example above is cell E2
  • Link Parameter: The parameter that Revit will use to identify the correct object between Excel and Revit.
  • First cell of Link Parameter: The first value cell of Link Parameter
    • According to the Excel table above, if you select the Link Parameter as ElementID so that First cell of Link Parameter is A2

You can also visit my video tutorial at this link: https://youtu.be/Zdwi9tBuEZc

The result after running the BIM Link

Data from Excel has been synchronized into Revit

Finally, Q'Apps hopes to be a powerful support tool for your work!