Electromechanical pipeline harbor style list engineering quantity calculation method based on Dynamo and Revit

Abstract

The invention relates to the technical field of engineering quantity statistics of building construction, in particular to an electromechanical pipeline harbor style list engineering quantity calculation method based on Dynamo and Revit. According to the technical scheme, Revit software of a Dynamo platform can be loaded, codes can be compiled, statistics can be run and reports can be generated, the Dynamo platform is loaded in a'management 'module of the Revit software, engineering quantity statistical codes can be compiled based on Dynamo, Hong Kong style engineering quantity calculation formats can be matched, engineering quantity statistical data of components can be run and generated according to calculation rules of all the components, the engineering quantity statistical data can be written into a table through an arithmetic unit, and the report can be generated. And generating a summarized project quantity CSV file, and perfecting the project quantity statistical file. According to the method, Dynamo is introduced to carry out engineering quantity statistics, a rigorous and targeted Revit component filtering rule is added, a user-defined engineering quantity calculation rule is achieved, component screening and statistics are achieved, the flexibility is higher, and component screening requirements under multiple logics are easily met.

Description

Technical Field

[0001] The invention relates to the technical field of engineering quantity statistics of construction projects, and in particular to a method for calculating engineering quantity of a port-type list of electromechanical pipelines based on Dynamo and Revit. Background Art

[0002] Dynamo is a visual programming software launched by Autodesk. It uses a "visual programming language" and can achieve functions comparable to traditional Revit secondary development. It has a low learning cost and can be designed by using built-in node packages even if you don't know how to program. It is currently widely used abroad. Therefore, it is a very simple way to use Dynamo to design some practical and efficient functions.

[0003] With the popularization of digital technologies such as BIM, the existing engineering quantity statistics are roughly divided into the following four methods: traditional manual quantity calculation, secondary mold calculation, Revit detailed table calculation, and secondary development of quantity calculation plug-ins. The traditional manual quantity calculation method directly measures the length, width and other information of the components in Revit / CAD, and then calculates the quantity using the rules in the engineering quantity list pricing specification. This method has large errors and low efficiency; the secondary mold calculation method is to use the existing Revit model and import the model into the cost platform to perform engineering quantity statistics. Because the platform is not common, the import will cause model loss due to recognition errors, and model inspection and secondary mold calculation are required. This method has a large amount of engineering, low accuracy, and cannot meet the needs of rapid changes in the plan; the Revit detailed table calculation method is to use the Revit built-in detailed table function to filter out the component information that meets the conditions and extract the engineering quantity information corresponding to the component. This method has less filtering judgment logic, has limitations, does not support the application of expressions, and cannot meet the needs of component filtering under complex logic; in addition, the secondary development of quantity calculation plug-ins takes a long time to develop through RevitAPI, has high costs, and has a high technical threshold, which is not easy for construction engineers to master and implement.

[0004] In view of the above, we propose a method for calculating the quantity of mechanical and electrical pipeline port-type bill of materials based on Dynamo and Revit. Summary of the invention

[0005] The purpose of the present invention is to provide a method for calculating the quantity of mechanical and electrical pipeline port-type bill of materials based on Dynamo and Revit to solve the problems raised in the above-mentioned background technology.

[0006] To achieve the above object, the present invention provides the following technical solution: loading the Revit software of the Dynamo platform, compiling codes, running statistics and generating reports, including the following steps:

[0007] S1. Open Revit software: load Dynamo platform in the "Management" module of Revit software;

[0008] S2. Code preparation: According to the calculation rules of each component, the engineering quantity statistics code is prepared based on Dynamo to match the Hong Kong-style engineering quantity calculation format;

[0009] S3, operation statistics: operation generates engineering quantity statistics of components and writes them into the table through the operator;

[0010] S4. Generate report: Generate a CSV file of the summarized engineering quantities and improve the engineering quantity statistics file.

[0011] Preferably, S2 includes:

[0012] S21, determining the calculation rules of each component;

[0013] S22. Use Dynamo nodes including Python Script, Code Block and Data ExportCSV to compile the engineering quantity statistics code;

[0014] S23. Obtain all components that need to be counted in the project;

[0015] S24. Compile the field sorting according to the port-style engineering quantity statistics format, including system type, family type, family name, size, reference elevation, quantity, component ID, length, area and volume.

[0016] Preferably, S3 includes: the statistical object of the component is attribute information, including system type, family type, family name, size, reference elevation, quantity, component ID, length, area and volume, and is written into a CSV table.

[0017] Preferably, S1-S3 generates a DYN file in Dynamo, and the program instructions of running the DYN file using Dynamo Player can execute the method according to any one of claims 1 to 3.

[0018] Compared with the prior art, the present invention has the following beneficial effects:

[0019] (1) The present invention introduces Dynamo for engineering quantity statistics, adds strict and targeted Revit component filtering rules, realizes customized engineering quantity calculation rules and component screening and statistics, has greater flexibility, and can easily meet the component screening needs under multiple logics.

[0020] (2) The present invention is more accurate and efficient than traditional manual quantity calculation; it has less workload than secondary mold calculation, avoiding data loss caused by cross-platform operations; it is more accurate than Revit detail table quantity calculation method, reducing the screening and processing of exported data; it has a lower threshold and is simple and easy to operate than the secondary development quantity calculation plug-in method; it effectively improves work efficiency, has the characteristics of being small and flexible, simple to operate, clear interface, convenient and fast, and quick to respond. BRIEF DESCRIPTION OF THE DRAWINGS

[0021] Figure 1 It is a schematic diagram of the system structure of the present invention. DETAILED DESCRIPTION

[0022] The following will be combined with the drawings in the embodiments of the present invention to clearly and completely describe the technical solutions in the embodiments of the present invention. Obviously, the described embodiments are only part of the embodiments of the present invention, not all of the embodiments. Based on the embodiments of the present invention, all other embodiments obtained by ordinary technicians in this field without creative work are within the scope of protection of the present invention.

[0023] See also Figure 1 The present invention provides a technical solution: including Revit software that can load the Dynamo platform, compile codes, run statistics and generate reports, including the following steps:

[0024] S1. Open Revit software: load Dynamo platform in the "Management" module of Revit software;

[0025] S2. Code preparation: According to the calculation rules of each component, the engineering quantity statistics code is prepared based on Dynamo to match the Hong Kong-style engineering quantity calculation format;

[0026] S3, operation statistics: operation generates engineering quantity statistics of components and writes them into the table through the operator;

[0027] S4. Generate report: Generate a CSV file of the summarized engineering quantities and improve the engineering quantity statistics file.

[0028] Further, the S2 includes:

[0029] S21, determining the calculation rules of each component;

[0030] S22. Use Dynamo nodes including Python Script, Code Block and Data ExportCSV to compile the engineering quantity statistics code;

[0031] S23. Obtain all components that need to be counted in the project;

[0032] S24. Compile the field sorting according to the port-style engineering quantity statistics format, including system type, family type, family name, size, reference elevation, quantity, component ID, length, area and volume.

[0033] Further, the S3 includes: the statistical object of the component is attribute information, including system type, family type, family name, size, reference elevation, quantity, component ID, length, area and volume, and is written into a CSV table,

[0034] Furthermore, S1-S3 generates a DYN file in Dynamo, and the program instructions of the DYN file are executed by using Dynamo Player to execute the above method.

[0035] Specifically, during the operation, first ensure the installation of Revit and Dynamo software, then open Revit software, and load the Dynamo platform in the "Management" module of Revit software, then use Dynamo nodes, such as PythonScript, Code Block, etc., to define the calculation rules of each component, and then use Dynamo nodes to obtain all the mechanical and electrical pipeline component information that needs to be counted in the project, and sort and format the data according to the Hong Kong-style engineering quantity statistics format, and finally use the Data ExportCSV node to export the data as a CSV file. When the Dynamo program is running, click the Run button in the Dynamo interface to execute the written code, where Dynamo will automatically extract the component information and generate a CSV file. The results can be viewed in the Dynamo interface, or the CSV file can be opened in software such as Excel for viewing. By introducing Dynamo for engineering quantity statistics, strict and targeted Revit component filtering rules are added to realize customized engineering quantity calculation rules and component screening and statistics, which are more flexible and can easily meet the component screening needs under multiple logics.

[0036] It should be noted that, in this article, relational terms such as first and second, etc. are only used to distinguish one entity or operation from another entity or operation, and do not necessarily require or imply any such actual relationship or order between these entities or operations. Moreover, the terms "include", "comprise" or any other variants thereof are intended to cover non-exclusive inclusion, so that a process, method, article or device including a series of elements includes not only those elements, but also other elements not explicitly listed, or also includes elements inherent to such process, method, article or device.

[0037] Although embodiments of the present invention have been shown and described, it will be appreciated by those skilled in the art that various changes, modifications, substitutions and variations may be made to the embodiments without departing from the principles and spirit of the present invention, and that the scope of the present invention is defined by the appended claims and their equivalents.

Claims

1. A method for calculating the quantity of mechanical and electrical pipeline port-type bill of materials based on Dynamo and Revit, comprising: loading Revit software on the Dynamo platform, compiling codes, running statistics and generating reports, characterized in that The following steps are involved: S1. Open Revit software: load Dynamo platform in the "Management" module of Revit software; S2. Code compilation: According to the calculation rules of each component, the engineering quantity statistics code is compiled based on Dynamo to match the Hong Kong-style engineering quantity calculation format; S3, operation statistics: Run to generate engineering quantity statistics of components and write them into the table through the operator; S4. Generate report: Generate a CSV file of the summarized engineering quantities and improve the engineering quantity statistics file.

2. According to claim 1, a method for calculating the quantity of mechanical and electrical pipeline port-type bill of materials based on Dynamo and Revit, characterized in that: The S2 includes: S21, determining the calculation rules of each component; S22. Use Dynamo nodes including Python Script, Code Block and Data ExportCSV to compile the engineering quantity statistics code; S23, obtain all components that need to be counted in the project; S24. Compile the field sorting according to the port-style engineering quantity statistics format, including system type, family type, family name, size, reference elevation, quantity, component ID, length, area and volume.

3. The method for calculating the quantity of mechanical and electrical pipeline port-type bill of materials based on Dynamo and Revit according to claim 1 is characterized by: The S3 includes: the statistical object of the component is attribute information, including system type, family type, family name, size, reference elevation, quantity, component ID, length, area and volume, and is written into a CSV table.

4. The method for calculating the quantity of mechanical and electrical pipeline port-type bill of materials based on Dynamo and Revit according to claim 1 is characterized by: S1-S3 generates a DYN file in Dynamo, and uses Dynamo Player to run the DYN file. The program instructions can execute the method described in any one of claims 1 to 3.

Images