Figure 1 – Model in Dynamo
In order for the geometry modeled in Dynamo to be transferred to an Excel table, a necessary step is to prepare an appropriate custom node.
Figure 2 - Dynamo Custom node
Its task is to convert geometric data of linear elements so that they can be presented in Excel using the same syntax as the tables generated by Advance Design. By properly combining these data and exporting them to Excel, the result is a table with linear element data.
Figure 3 - Table exported automatically from Dynamo
Once exported, you just need to import the table in Advance Design, using the interactive (Data Grid) tables. To do this, model in Advance Design the same number of linear elements as you have in the Dynamo structure, and then use the function to import data from Excel to interactive tables.
Figure 4 - Data grid structure
As a result, in Advance Design, we will get a model generated in Dynamo.
Figure 5 - Advance Design model after import
After the model is completed with further data, such as loads, FEM calculations can be performed
Figure 7 Self-Weight Diagram
In conclusion, here is another application for the Data Grid of Advance Design. One that will help us ease the modeling process and gain time by using an open-source piece of software like Dynamo Sandbox.
Special thanks to Konrad Ociepka (Polish Graitec department) for the idea and preparation of the example.
BIM software for FEM structural analysis
Productivity add-on for Revit® bursting with tools for Architectural, Structural and MEP Designers
Productivity add-on for Advance Steel - practical tools for everyday needs
BIM software for structural steel engineering, detailing and fabrication
