Dynamo and excel-based cross-software complex model accurate modeling method

Abstract

The invention relates to the field of model design, in particular to a dynamo and excel-based cross-software complex model accurate modeling method. The invention discloses a dynamo and excel-based cross-software complex model accurate modeling method. The method is characterized by being implemented according to the following steps in sequence: S1, understanding geometric feature extraction; s2, using a parameterized design tool; s3, carrying out data linkage and parametric modeling; s4, performing data interaction and batch creation; s5, performing three-dimensional visualization on the BIM data based on visual programming software; s6, model conversion and generation; and S7, carrying out cross-software model display based on a visual programming technology. The method is accurate in modeling.

Description

Technical Field

[0001] The present invention relates to the field of model design, and in particular to a cross-software complex model precision modeling method based on Dynamo and Excel. Background Art

[0002] The advancement of BIM technology has led to the emergence of many softwares, each with its own characteristics. Although they greatly facilitate users, they also bring challenges to model compatibility. Engineers often face the problem of model incompatibility, which is usually manifested in the incompatibility of software models developed by different companies, the incompatibility of different software models under the same company, and the incompatibility of new and old versions of the same software. This not only leads to repeated modeling and mapping, but also increases the workload and reduces efficiency. It also makes the software users bear a greater economic burden due to upgrades.

[0003] In order to solve the model compatibility problem, technicians usually use third-party software to convert the format, or rely on the software's own import and export functions, or downgrade the model through third-party compilation software. However, these methods often cause new model compatibility problems, such as loss of details, the model becomes an uneditable block, or the underlying logic of the model does not match the new software, causing systemic confusion. Or unpredictable errors may occur due to model downgrade. Summary of the invention

[0004] In order to overcome the defects of the prior art and provide a design method for accurate modeling, the present invention discloses an accurate modeling method for complex models across software based on Dynamo and Excel.

[0005] The present invention achieves the purpose of the invention through the following technical solutions: A cross-software complex model precision modeling method based on Dynamo and Excel, characterized by: implementing the following steps in sequence: S1. Understanding geometric feature extraction: Geometric feature extraction is the process of identifying the areas where the pixel value function in the image changes rapidly. This can be achieved through the extreme value areas of the first-order derivative. These areas usually represent the edges of objects and are important components of geometric features. In the traditional construction industry, these geometric eigenvalues ​​are clear. For example, for an arc, its eigenvalues ​​can be ① starting point, end point, center point; ② center point, starting point, sweep radius, vector; ③ tangent curve 1, tangent curve 2, radius; for a surface, its eigenvalues ​​can be ① multiple curves; ② curves (multiple), path curves (multiple); ③ closed curves; for a cube, its eigenvalues ​​can be ① low point, high point; ② coordinate system, length, width, height; ③ center point, length, width, height; When modeling, it is a crucial step to select an appropriate method to extract the geometric features of the model and obtain the final shape of the model through lofting, sweeping and Boolean operations; S2. Use parametric design tools: Using Dynamo and Grasshopper are two popular visual programming tools that allow users to build algorithms by dragging and dropping nodes to achieve parametric design; these tools can be used with professional BIM software such as Revit or Rhino to achieve rapid modeling and design optimization; S3. Data linkage and parametric modeling: Use Dynamo and Grasshopper to link data, drive data for parametric modeling, and interact with Revit or Rhino; for example, use Dynamo to drive data sources to directly create axis grids in Revit, or use Grasshopper to drive parametric data for construction design and volume consideration, so that engineers can find a more suitable shape; S4, data interaction and batch creation: Use Dynamo and Grasshopper to transfer data between external data sources (such as Excel) and Revit or Rhino attribute information, add the non-geometric information of the table to the instance attributes of the Revit element, or transfer it in the opposite direction, that is, transfer the Revit or Rhino attribute information to the external data source; in addition, Dynamo's batch creation method greatly improves efficiency and reduces the complexity and tediousness of special-shaped modeling or adding / exporting data; S5. 3D visualization of BIM data based on visual programming software: Using visual programming technology, BIM data can be loaded and visualized in different software environments. Through data analysis, format conversion, geometric reconstruction and three-dimensional expression, BIM data can be integrated and displayed with different software, providing important technical support for engineering design. S6. Model conversion and generation: Including geometric data conversion and attribute information conversion; using Dynamo or Grasshopper to convert geometric feature data into a solid model and assign corresponding attributes, and then abstract and filter the redundant information in the basic data to retain useful BIM information; S7. Cross-software model display based on visual programming technology: Visual programming software is used to realize the visualization display of BIM data in different software environments, and geometric feature information, building attributes and other data are stored in Excel. The visual programming software and BIM software are connected through their respective interactive technologies. By retrieving data in the visual programming software and adjusting nodes or program statements, different BIM software are driven to generate entity models and assign corresponding attributes. Finally, high-precision BIM models are obtained in different software, and related engineering construction activities are carried out according to the advantages of different software.

[0006] The cross-software complex model precision modeling method based on Dynamo and Excel is characterized by: In step S1, For complex geometric bodies, it can be realized through ① lofting, ② lofting along the path, ③ sweeping, and ④ sweeping along the path; For more complex geometries, extract the simple geometries that make them up and obtain them through Boolean operations.

[0007] The present invention has the following beneficial effects: By extracting the mathematical features of the geometric body of the structure, using Dynamo and Excel, a cross-software rapid modeling method is invented. The present invention relies on visual programming technology (such as Grasshopper for Rhino, Dynamo for Revit, etc.), extracts the mathematical features of the model geometry, and combines the actual engineering to parameterize the data, and then quickly generates accurate models in different software.

[0008] Through the application of the present invention, the problem of accurate modeling of complex models across software has been successfully solved. The existing technology relies on the functions of the software itself, and it is difficult to meet the demand for smooth conversion of models in different software. This technology extracts mathematical information of complex geometric bodies and is driven by visual programming software built into or supported by the software. It can quickly generate suitable high-precision models in different target software, expands the scope of model application, improves modeling work efficiency, and breaks down software compatibility barriers. BRIEF DESCRIPTION OF THE DRAWINGS

[0009] Figure 1 It is a schematic diagram of the process of the present invention, Figure 2 is the basic data table of the present invention, Figure 3 It is the program statement and node of the visual programming software Dynamo in the present invention, Figure 4 It is the full data model of the visual programming software Dynamo in the present invention, Figure 5It is the processed model of the visual programming software Dynamo in the present invention, Figure 6 It is the forrevit program statement and node of the visual programming software dynamo in the present invention, Figure 7 It is a model generated in Revit by the visual programming software Dynamo in the present invention. Figure 8 It is the forcivil3D program statement and node of the visual programming software Dynamo in the present invention, Fig. 9 It is a model in civil3D by using the visual programming software dynamo in the present invention. DETAILED DESCRIPTION

[0010] The present invention is further described below by means of specific examples. Example

[0011] A cross-software complex modeling method based on Dynamo and Excel, taking the special-shaped tower as an example, Figures 1 to 9 As shown, follow the steps below: S1. Understanding geometric feature extraction: Geometric feature extraction is the process of identifying the areas where the pixel value function in the image changes rapidly. This can be achieved through the extreme value areas of the first-order derivative. These areas usually represent the edges of objects and are important components of geometric features. In the traditional construction industry, these geometric eigenvalues ​​are clear. For example, for an arc, its eigenvalues ​​can be ① starting point, end point, center point; ② center point, starting point, sweep radius, vector; ③ tangent curve 1, tangent curve 2, radius; for a surface, its eigenvalues ​​can be ① multiple curves; ② curves (multiple), path curves (multiple); ③ closed curves; for a cube, its eigenvalues ​​can be ① low point, high point; ② coordinate system, length, width, height; ③ center point, length, width, height; For complex geometric bodies, it can be realized through ① lofting, ② lofting along the path, ③ sweeping, and ④ sweeping along the path; For more complex geometries, extract the simple geometries in its composition and obtain them through Boolean operations; When modeling, it is a crucial step to select an appropriate method to extract the geometric features of the model and obtain the final shape of the model through lofting, sweeping and Boolean operations; S2. Use parametric design tools: Using Dynamo and Grasshopper are two popular visual programming tools that allow users to build algorithms by dragging and dropping nodes to achieve parametric design; these tools can be used with professional BIM software such as Revit or Rhino to achieve rapid modeling and design optimization; S3. Data linkage and parametric modeling: Use Dynamo and Grasshopper to link data, drive data for parametric modeling, and interact with Revit or Rhino; for example, use Dynamo to drive data sources to directly create axis grids in Revit, or use Grasshopper to drive parametric data for construction design and volume consideration, so that engineers can find a more suitable shape; S4, data interaction and batch creation: Use Dynamo and Grasshopper to transfer data between external data sources (such as Excel) and Revit or Rhino attribute information, add the non-geometric information of the table to the instance attributes of the Revit element, or transfer it in the opposite direction, that is, transfer the Revit or Rhino attribute information to the external data source; in addition, Dynamo's batch creation method greatly improves efficiency and reduces the complexity and tediousness of special-shaped modeling or adding / exporting data; S5. 3D visualization of BIM data based on visual programming software: Using visual programming technology, BIM data can be loaded and visualized in different software environments. Through data analysis, format conversion, geometric reconstruction and three-dimensional expression, BIM data can be integrated and displayed with different software, providing important technical support for engineering design. S6. Model conversion and generation: Including geometric data conversion and attribute information conversion; using Dynamo or Grasshopper to convert geometric feature data into a solid model and assign corresponding attributes, and then abstract and filter the redundant information in the basic data to retain useful BIM information; S7. Cross-software model display based on visual programming technology: Visual programming software is used to realize the visualization display of BIM data in different software environments, and geometric feature information, building attributes and other data are stored in Excel. The visual programming software and BIM software are connected through their respective interactive technologies. By retrieving data in the visual programming software and adjusting nodes or program statements, different BIM software are driven to generate entity models and assign corresponding attributes. Finally, high-precision BIM models are obtained in different software, and related engineering construction activities are carried out according to the advantages of different software.

Claims

1. A cross-software complex model precision modeling method based on Dynamo and Excel, characterized by: Follow the steps below to implement: S1. Understanding geometric feature extraction: Geometric feature extraction is achieved through the extreme value areas of the first-order derivative, which represent the edges of objects; S2. Use parametric design tools: Use Dynamo and Grasshopper to build algorithms by dragging and dropping nodes to achieve parametric design; S3. Data linkage and parametric modeling: Use Dynamo and Grasshopper to interact with data, drive data for parametric modeling, and interact with Revit or Rhino; S4, data interaction and batch creation: Use Dynamo and Grasshopper to transfer data from external data sources to Revit or Rhino attribute information, add non-geometric information of the table to the instance properties of Revit elements, or vice versa, that is, transfer Revit or Rhino attribute information to external data sources; S5. 3D visualization of BIM data based on visual programming software: Use visual programming technology to load and visualize BIM data in different software environments; realize the integration and display of BIM data and different software through data analysis, format conversion, geometric reconstruction and three-dimensional expression; S6. Model conversion and generation: Including geometric data conversion and attribute information conversion; using Dynamo or Grasshopper to convert geometric feature data into a solid model and assign corresponding attributes, and then abstract and filter the redundant information in the basic data to retain useful BIM information; S7. Cross-software model display based on visual programming technology: Visual programming software is used to realize the visualization display of BIM data in different software environments, and geometric feature information and building attribute data are stored in Excel. The visual programming software and BIM software are connected through their respective interactive technologies. By retrieving data in the visual programming software and adjusting nodes or program statements, different BIM software are driven to generate entity models and assign corresponding attributes. Finally, high-precision BIM models are obtained in different software, and related engineering construction activities are carried out according to the advantages of different software.

2. The cross-software complex model precision modeling method based on Dynamo and Excel as claimed in claim 1 is characterized by: Its characteristics are: In step S1, For complex geometric bodies, it can be realized through ① lofting, ② lofting along the path, ③ sweeping, and ④ sweeping along the path; For more complex geometries, extract the simple geometries that make them up and obtain them through Boolean operations.

Images