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”
Step 1: Export the Parameters of the object to Excel, including ElementID or UniqueID
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