Pile foundation parameterization dynamic adjustment method based on Revit and Dynamo

Abstract

The invention discloses a pile foundation parameterization dynamic adjustment method based on Revit and Dynamo, comprising the following steps: step 1, establishing a pile foundation model in Revit software, the pile foundation model comprising a plurality of model elements; and 2, batch parameterization adjustment is conducted on all the pile foundations in the Revit software on the basis of a Dynamo software program. The invention relates to the technical field of buildings and civil engineering, and can solve the technical problems in the prior art.

Description

Technical Field

[0001] This invention relates to the field of architecture and civil engineering technology, and in particular to a method for parametric dynamic adjustment of pile foundations based on Revit and Dynamo. Background Technology

[0002] In the field of architecture and civil engineering, Revit software, as a mainstream building information modeling software, is widely used for structural component modeling and information management. As an important foundation component, the parameters of pile foundations (especially pile length) often need to be adjusted multiple times based on geological survey reports and load changes.

[0003] Currently, the common method for modifying pile lengths is manual. This involves selecting each pile component in the Revit model and manually changing parameters such as pile length in the properties panel. When dealing with a large number of piles, this method is extremely inefficient, prone to errors, and makes it difficult to ensure consistency between the model and design data. The traditional method of modifying pile lengths for each individual component has significant shortcomings when dealing with a large number of pile components.

[0004] While Revit software supports parametric components, allowing for parameter adjustments to individual components, it lacks efficient native tools for batch, externally data-driven dynamic parameter driving and updating of components such as pile foundations. Batch modifications rely on plugins or cumbersome API programming, which is quite difficult.

[0005] Existing methods for modifying pile lengths using Revit software have limitations: 1. It cannot respond quickly and accurately to frequent changes in pile foundation design parameters, resulting in a long design iteration cycle.

[0006] 2. Manual modification is prone to oversights, resulting in mismatches between component pile numbers and pile lengths, which is time-consuming, labor-intensive, and difficult to adapt to the needs of complex projects.

[0007] 3. There is a lack of a convenient and visual process to connect the BIM model with external data (such as Excel files), resulting in poor information transmission.

[0008] Therefore, there is a need to provide a parameterized dynamic adjustment method for pile foundations based on Revit and Dynamo, which can solve the above-mentioned technical problems existing in the prior art. Summary of the Invention

[0009] The purpose of this invention is to provide a method for the parameterized dynamic adjustment of pile foundations based on Revit and Dynamo, which can solve the above-mentioned technical problems existing in the prior art.

[0010] This invention is implemented as follows: A method for parametric dynamic adjustment of pile foundations based on Revit and Dynamo includes the following steps: Step 1: Create a pile foundation model in Revit software. The pile foundation model includes multiple model elements. Step 2: Perform batch parametric adjustments on each pile foundation in Revit software based on the Dynamo software program.

[0011] In step 1, each model element in the pile foundation model created in Revit software contains a parameter for unique identification.

[0012] The parameter used for unique identification is either "station number" or "component ID".

[0013] Step 2 includes the following sub-steps: Step 21: Select model elements and extract the component IDs of the corresponding pile foundations; Step 22: Read the parameters of the selected model element; Step 23: Perform batch parameter adjustments and data interaction for the selected model elements using an Excel file; Step 24: Using the Element.SetParameterByName node in the Dynamo software, combined with the "station number" parameter name input from the Code Block and the parameter after structural processing, set the new parameter value into the parameter of the corresponding model element.

[0014] In step 21, one or more model elements are selected through the Select Model Elements node in the Dynamo software, and a list of selected model elements is output. The component IDs of the pile foundations corresponding to the selected model elements are extracted through the Element.Id node in the Dynamo software, and the list of verification IDs is viewed through the Watch node in the Dynamo software.

[0015] In step 22, the "station number" parameter value of the selected model element is read by combining the "station number" parameter name input by the Element.GetParameterValueByName node of the Dynamo software with the "station number" parameter name input by the Code Block node of the Dynamo software.

[0016] Step 23 includes the following sub-steps: Step 231: Data Export: Using the Data.ExportExcel node in the Dynamo software, export the parameters of the selected model elements to an Excel file, and set table parameters in the Excel file to control the export location of the model element parameters; after the data is exported, fill in the parameters of the model elements. Step 232: Data Import: Select the Excel file with the newly added parameter data through the File Path node in Dynamo software. After converting the Excel file into a file object through File.FromPath in Dynamo software, write it back to Revit software through the Data.ImportExcel node in Dynamo software. Then, perform structural processing on the imported parameter data through the List.RestOfItems node and List.Transpose node in Dynamo software.

[0017] Compared with the prior art, the present invention has the following advantages: 1. This invention combines Revit and Dynamo to transform tedious manual, one-by-one modifications into automated batch processing, greatly shortening parameter adjustment time. It is especially suitable for large projects with a large number of pile foundations, significantly improving efficiency. It also forms a complete and traceable process of "export-processing-import (write-back)," with a closed-loop and controllable process, facilitating data verification and version management. The design process is more standardized, improving the accuracy and application value of Revit models in the basic design stage, and providing reliable data support and decision-making basis for the entire process of subsequent drawing, quantity calculation, and construction handover.

[0018] 2. This invention allows users to modify external data tables (Excel files) to drive changes in various parameters (not limited to pile length) of model elements in Revit software, enabling scalable parametric adjustments. It has good versatility, requires no complex code writing, and is easy and intuitive to operate, lowering the technical threshold. Furthermore, by accurately matching the external data table with the model elements through both pile number and component ID information, it ensures that the components of the model elements correspond one-to-one with the pile length, avoiding omissions and errors in manual operation, ensuring the consistency between the pile foundation model and the design data, and achieving extremely high accuracy. Attached Figure Description

[0019] Figure 1 This is a schematic diagram of the Dynamo plugin for the pile foundation parametric dynamic adjustment method based on Revit and Dynamo of this invention; Figure 2 This is an example diagram of the Excel table parameters supplemented in the pile foundation parameterized dynamic adjustment method based on Revit and Dynamo of this invention; Figure 3 This is the adjusted pile foundation model diagram of the pile foundation parameterized dynamic adjustment method based on Revit and Dynamo of this invention. Detailed Implementation

[0020] The present invention will be further described below with reference to the accompanying drawings and specific embodiments.

[0021] Please see the appendix Figure 1 A method for parametric dynamic adjustment of pile foundations based on Revit and Dynamo includes the following steps: Step 1: Create a pile foundation model in Revit software. The pile foundation model includes multiple model elements.

[0022] In step 1, each model element in the pile foundation model created in Revit software contains a parameter that can be used for unique identification, such as "station number" or "component ID".

[0023] Preferably, the Revit software version used is Revit 2020, but other versions of Revit software can also be selected according to actual application needs.

[0024] The parameters of each model element may include the pile number, component ID, pile length, pile diameter, etc., and the parameters of the pile foundation can be configured according to actual needs.

[0025] Step 2: Perform batch parametric adjustments on each pile foundation in Revit software based on the Dynamo software program.

[0026] Preferably, the Dynamo software version used is Dynamo 2.1.

[0027] Step 2 includes the following sub-steps: Step 21: Select model elements and extract the component IDs of the corresponding pile foundations.

[0028] In step 21, one or more model elements are selected through the Select Model Elements node in the Dynamo software, and a list of selected model elements is output. The component IDs of the pile foundations corresponding to the selected model elements are extracted through the Element.Id node in the Dynamo software, and the list of verification IDs is viewed through the Watch node in the Dynamo software.

[0029] Step 22: Read the parameters of the selected model element.

[0030] In step 22, the "station number" parameter value of the selected model element is read by combining the "station number" parameter name input by the Element.GetParameterValueByName node of the Dynamo software with the "station number" parameter name input by the Code Block node of the Dynamo software.

[0031] Step 23: Perform batch parameter adjustments and data interaction for the selected model elements using an Excel file.

[0032] Please see the appendix Figure 2 Step 23 includes the following sub-steps: Step 231: Data Export: Using the Data.ExportExcel node in the Dynamo software, export the parameters of the selected model elements to an Excel file. Set the starting row, column, and other table parameters in the Excel file to control the export location of the model element parameters. After data export, fill in the parameters of the model elements (including but not limited to pile length) (including modification, supplementation, and other processing operations).

[0033] Step 232: Data Import: Select the Excel file with the newly added parameter data through the File Path node in Dynamo software. After converting the Excel file into a file object through File.FromPath in Dynamo software, write it back to Revit software through the Data.ImportExcel node in Dynamo software. Then, perform structural processing on the imported parameter data through the List.RestOfItems node and List.Transpose node in Dynamo software.

[0034] Using Dynamo software to perform structural processing of parametric data is a common parametric processing method in this field, enabling the structured parametric data to be applied to the parameter configuration of Revit software. The structural processing process will not be described in detail here.

[0035] The Dynamo software and external data tables (Excel files) provide a non-programming, visual means of parameter adjustment, which can be flexibly adapted to different project needs, reducing the technical threshold while improving the convenience and scenario adaptability of pile foundation parameter adjustment.

[0036] Step 24: Using the Element.SetParameterByName node in Dynamo software, combined with the "station number" parameter name entered in the Code Block and the parameters after structural processing, set the new parameter values ​​(i.e., the parameters processed in Step 231, such as pile length) into the parameters of the corresponding model elements. The pile foundation model after parameter adjustment is shown in the attached figure. Figure 3 As shown.

[0037] Step 2 involves building a visual programming workflow using Dynamo software, establishing an information channel between the Revit model and external data tables, enabling efficient, batch, and precise adjustment of pile foundation parameters (especially pile length), significantly improving the efficiency and accuracy of pile foundation information management; at the same time, through a two-way association mechanism between model elements and external data tables (such as Excel files), it ensures real-time dynamic synchronization between model parameters and design data sources, achieving consistent data management.

[0038] This invention constructs a closed-loop workflow for dynamic adjustment of pile foundation parameters based on Revit and Dynamo, connecting the Revti pile foundation model (BIM model) with external data tables (Excel files). It realizes automated data interaction and parameter control of "model element selection → parameter reading → Excel file data export / processing / import → model element parameter write-back", and achieves non-programming batch parameterization drive.

[0039] The above are merely preferred embodiments of the present invention and are not intended to limit the scope of protection of the invention. Therefore, any modifications, equivalent substitutions, improvements, etc., made within the spirit and principles of the present invention should be included within the scope of protection of the present invention.

Claims

1. A method for parametric dynamic adjustment of pile foundations based on Revit and Dynamo, characterized by: Includes the following steps: Step 1: Create a pile foundation model in Revit software. The pile foundation model includes multiple model elements. Step 2: Perform batch parametric adjustments on each pile foundation in Revit software based on the Dynamo software program.

2. The method for parametric dynamic adjustment of pile foundations based on Revit and Dynamo according to claim 1, characterized in that: In step 1, each model element in the pile foundation model created in Revit software contains a parameter for unique identification.

3. The method for parametric dynamic adjustment of pile foundations based on Revit and Dynamo according to claim 2, characterized in that: The parameter used for unique identification is either "station number" or "component ID".

4. The method for parametric dynamic adjustment of pile foundations based on Revit and Dynamo according to claim 1, characterized in that: Step 2 includes the following sub-steps: Step 21: Select model elements and extract the component IDs of the corresponding pile foundations; Step 22: Read the parameters of the selected model element; Step 23: Perform batch parameter adjustments and data interaction for the selected model elements using an Excel file; Step 24: Using the Element.SetParameterByName node in the Dynamo software, combined with the "station number" parameter name input from the Code Block and the parameters after structural processing, set the new parameter values ​​into the parameters of the corresponding model elements.

5. The method for parametric dynamic adjustment of pile foundations based on Revit and Dynamo according to claim 4, characterized in that: In step 21, one or more model elements are selected through the Select Model Elements node in the Dynamo software, and a list of selected model elements is output. The component IDs of the pile foundations corresponding to the selected model elements are extracted through the Element.Id node in the Dynamo software, and the list of verification IDs is viewed through the Watch node in the Dynamo software.

6. The method for parametric dynamic adjustment of pile foundations based on Revit and Dynamo according to claim 4, characterized in that: In step 22, the "station number" parameter value of the selected model element is read by combining the "station number" parameter name input by the Element.GetParameterValueByName node of the Dynamo software with the "station number" parameter name input by the Code Block node of the Dynamo software.

7. The method for parametric dynamic adjustment of pile foundations based on Revit and Dynamo according to claim 4, characterized in that: Step 23 includes the following sub-steps: Step 231: Data Export: Using the Data.ExportExcel node in the Dynamo software, export the parameters of the selected model elements to an Excel file, and set table parameters in the Excel file to control the export location of the model element parameters; After the data is exported, the parameters of the model elements are filled in. Step 232: Data Import: Select the Excel file with the newly added parameter data through the File Path node in Dynamo software. After converting the Excel file into a file object through File.FromPath in Dynamo software, write it back to Revit software through the Data.ImportExcel node in Dynamo software. Then, perform structural processing on the imported parameter data through the List.RestOfItems node and List.Transpose node in Dynamo software.

Images