Methods and Systems for Rapid Quantity Statistics

Abstract

The application discloses an engineering quantity rapid statistics method and system, and the method comprises the following steps: setting a parameter configuration database and a model mapping rule library in advance; reading the parameter configuration database to complete parameter setting when engineering quantity statistics is performed; completing floor mapping and attribute mapping according to the model mapping rule library, and automatically completing model mapping to convert Revit components into software recognizable components; establishing the association between components in a BIM model and entries in a list to complete list hanging; calculating engineering quantity according to the list to obtain model component engineering quantity; and outputting a report according to the calculation result. According to the application, the engineering quantity statistics efficiency and accuracy can be improved.

Description

Technical Field

[0001] This invention relates to the field of information processing technology, specifically to a method and system for rapid statistical analysis of engineering quantities. Background Technology

[0002] The quantity of work is the physical quantity of a project, expressed in physical or natural units of measurement for the number of each item or sub-item of the project and its components.

[0003] Revit is a professional Building Information Modeling (BIM) software that helps architects and engineers design and manage projects more efficiently. Its model optimization function helps users quickly and accurately calculate quantities, saving time and effort. Completing quantity calculations using the Revit platform offers the following advantages:

[0004] 1. Calculation rules can be used to calculate quota quantities and bill of quantities, thus overcoming the limitation that Revit's native function only provides physical quantities.

[0005] 2. For construction companies, the bill of quantities allows them to directly locate the corresponding components in the model, clearly showing the components' attributes and spatial positions. Compared to project features described in text, this provides a more direct display of information, attributes, and methods, which is more conducive to pricing.

[0006] 3. The bill of quantities output by the Revit platform can correspond one-to-one with the components in the model and is linked to the component quantities, so that it can be truly traced and consulted. Furthermore, due to the role of detailed design in the production of 3D models, the possibility of changes is greatly reduced. Therefore, the work of verifying the quantities between the two parties will be greatly reduced in the future.

[0007] However, existing methods for calculating quantities based on the Revit platform also have some drawbacks. For example, they are resource-intensive, often consuming significant amounts of computer resources during Revit calculations. When calculating large models, the system may even display a "Insufficient memory, Revit must be closed" message. Furthermore, the calculation process requires substantial manual intervention, such as parameter settings and model mapping. These processes must be manually configured by the software operator, demanding high levels of expertise from the operator and being inefficient and prone to errors. Summary of the Invention

[0008] This invention provides a method and system for rapid quantity calculation in engineering projects, which improves calculation efficiency and ensures the accuracy of calculation results.

[0009] Therefore, the present invention provides the following technical solution:

[0010] A method for rapid quantity surveying of engineering work, the method comprising:

[0011] Pre-configure the database and model mapping rule base with pre-set parameters;

[0012] When performing engineering quantity statistics, the parameter configuration database is read to complete the parameter settings;

[0013] The floor mapping and attribute mapping are completed according to the model mapping rule base, and the model mapping is completed automatically, converting Revit components into components that the software can recognize.

[0014] Establish the association between components in the BIM model and items in the bill of quantities, and complete the bill of quantities linking;

[0015] The quantities of the model components are calculated based on the aforementioned list.

[0016] Output a report based on the calculation results.

[0017] Optionally, the parameter configuration database includes a list library and / or a quota library; the list library includes one or more list entries, and each list condition includes any one or more of the following information: quantity calculation rules and quantity output content.

[0018] Optionally, the model mapping rule base includes: the correspondence between the building elevation of components in the BIM model and the floor in the quantity calculation, and the mapping relationship between the name and attributes of components in the BIM model and the name and attributes of components in the quantity calculation.

[0019] Optionally, establishing the association between components in the BIM model and items in the bill of quantities includes:

[0020] Retrieve keywords for component names in the BIM model;

[0021] The association between components in the BIM model and items in the bill of quantities is established based on the keywords.

[0022] Optionally, the method further includes setting corresponding quantity calculation formulas and quantity merging conditions in the list.

[0023] Optionally, the method further includes: generating a model mapping result report after completing the model mapping.

[0024] Optionally, the step of outputting a report based on the calculation results includes:

[0025] When no inventory list is attached, output a report on the physical quantity information;

[0026] When attaching a list, output the list information table.

[0027] Optionally, the physical quantity information report includes any one or more of the following: physical quantity summary report, physical quantity floor summary report, and physical quantity detail report; the list information table includes any one or more of the following: list summary report, list floor summary report, and list detail report.

[0028] Optionally, the physical quantity information report and the list information table may be in any one or more of the following formats: EXCEL, XML, PDF.

[0029] A rapid quantity surveying system for engineering projects, the system comprising:

[0030] The configuration module is used to pre-configure the parameter configuration database and model mapping rule library;

[0031] The setting module is used to read the parameter configuration database to complete the parameter setting when performing engineering quantity statistics;

[0032] The mapping module is used to complete floor mapping and attribute mapping according to the model mapping rule library, and automatically complete model mapping, converting Revit components into software-recognizable components;

[0033] The linking module is used to establish the association between components in the BIM model and items in the bill of quantities, thus completing the linking of the bill of quantities.

[0034] The calculation module is used to calculate the quantities of the project based on the bill of quantities to obtain the quantities of the model components.

[0035] The report output module is used to output reports based on the calculation results.

[0036] A computer-readable storage medium having a computer program stored thereon, the computer program being executed by a processor to perform the steps of the rapid quantity calculation method.

[0037] The present invention provides a method and system for rapid quantity surveying, which pre-configures a parameter configuration database and a model mapping rule library. During quantity surveying, the system automatically sets parameters by reading the parameter configuration database; automatically maps floors and attributes according to the model mapping rule library, converting Revit components into software-recognizable components; establishes associations between components in the BIM model and items in the bill of quantities, completing the bill of quantities linking; calculates quantities based on the bill of quantities to obtain the quantities of model components; and outputs reports based on the calculation results. Using this invention, the efficiency and accuracy of Revit-based quantity surveying can be greatly improved. Attached Figure Description

[0038] To more clearly illustrate the technical solutions in the embodiments of the present invention or the prior art, the accompanying drawings used in the embodiments will be briefly described below. Obviously, the drawings described below are merely some embodiments of the present invention, and those skilled in the art can obtain other drawings based on these drawings without any creative effort.

[0039] Figure 1 This is a flowchart of a method for rapid quantity calculation of engineering work provided by an embodiment of the present invention;

[0040] Figure 2 This is a schematic diagram of a rapid quantity statistics system for engineering projects provided in an embodiment of the present invention. Detailed Implementation

[0041] The specific embodiments of the present invention will be described in detail below with reference to the accompanying drawings. It should be understood that the specific embodiments described herein are for illustration and explanation only and are not intended to limit the present invention.

[0042] To enable those skilled in the art to better understand the present invention, the technical solutions of the present invention will be clearly and completely described below with reference to the accompanying drawings of the embodiments of the present invention. Obviously, the described embodiments are only some embodiments of the present invention, and not all embodiments. Based on the embodiments of the present invention, all other embodiments obtained by those skilled in the art without creative effort should fall within the scope of protection of the present invention.

[0043] When calculating quantities based on a Revit software model, no modifications are made to the model file. The method involves creating a quantity calculation database file in the same directory as the Revit file, where all quantity calculation-related data is stored. This file includes information such as: project settings data (selected bill of quantities library, bill of quantities calculation rules, default output settings, etc.), attribute mapping data, floor mapping data, model mapping data, and component quantity calculation attribute data. Quantity calculation data is also stored in this database file.

[0044] The following is a brief explanation of the existing process for calculating quantities based on the Revit platform.

[0045] After obtaining the BIM model, open it using Revit quantity takeoff software, and then perform the following main operations:

[0046] (1) Project settings mainly include the following functions: Project list selection, which aims to determine the calculation rules (mainly including deduction rules), output content of project quantities, list items and other information of the components to be calculated. After the calculation rules are set, they will be stored in the database file (bima) automatically generated by the software to ensure that all software settings remain unchanged when the project file is opened again.

[0047] (2) Model mapping: converting Revit components into components that the software needs to calculate.

[0048] Matching materials and structural types based on names: When a match is not achieved based on family name, family name modification or adjustment of conversion rule settings can be performed to improve the default matching success rate. Corresponding to family and family type names in the Revit model with quantity takeoff components: During design modeling, different designers may name the families and family types of the model components differently, such as "Rectangle-Column-500x500" or "KZ-500x500". This requires matching and mapping the family type names in the BIM model with the names of the quantity takeoff components, mapping the BIM model with family type names such as "Rectangle-Column-500x500" or "KZ-500x500" to the quantity takeoff model of "Column" or "Frame Column" in the quantity takeoff software that can calculate the quantity of the project according to rules.

[0049] (3) List linking, that is, linking the list to the component to realize the association between the BIM model component and the list item, and setting the corresponding quantity calculation formula and quantity merging conditions in the list (after the quantity is calculated, the list item features are formed). In this way, when calculating the quantity, the quantity calculation formula and quantity merging conditions in the associated list can be used to calculate the quantity result, and the quantity calculation result is filled into the quantity calculation formula of the list, and the list merging conditions are filled into the list item features.

[0050] (4) Summarize and calculate, and output the engineering quantity (bill quantity, physical quantity) of the model components. You can also export the bill of quantities for sub-items or other engineering quantity tables.

[0051] The above-mentioned engineering setup and model mapping process all require manual operation by software operators. The bill of quantities linking is also mainly done by software operators manually linking the bill of quantities or importing the bill of quantities into the bill of quantities linking interface. This is not only time-consuming and inefficient, but also prone to errors.

[0052] To address this, the present invention provides a method and system for rapid quantity surveying, which includes a pre-set parameter configuration database and a model mapping rule base; during quantity surveying, the parameter configuration database is read to automatically complete parameter settings; floor mapping and attribute mapping are automatically completed according to the model mapping rule base, converting Revit components into software-recognizable components; the association between components in the BIM model and items in the bill of quantities is established, completing the bill of quantities linking; the quantity of work is calculated according to the bill of quantities to obtain the quantity of model components; and a report is output based on the calculation results.

[0053] The present invention is based on the secondary development of the Revit platform. It directly utilizes the Revit design model and, according to the relevant construction project pricing quota rules, directly completes the engineering quantity calculation and analysis on the Revit platform, and quickly outputs the calculation results, which can be directly used by pricing software.

[0054] like Figure 1 The diagram shown is a flowchart of a method for rapid quantity calculation of engineering work provided by an embodiment of the present invention, which includes the following steps:

[0055] Step 101: Configure the database and model mapping rule library by setting parameters in advance.

[0056] The parameter configuration database includes, but is not limited to, a bill of quantities library and / or a quota library. The quota library is a database containing standards for the labor, materials and machinery consumption required for various building components and their corresponding costs. The bill of quantities library includes one or more bill of quantities entries, and each bill of quantities condition includes any one or more of the following information: engineering quantity calculation rules and engineering quantity output content.

[0057] Furthermore, corresponding quantity calculation formulas and quantity merging conditions can be set in the list.

[0058] The model mapping rule base includes, but is not limited to: the correspondence between the building elevation of components in the BIM model and the floor in the engineering quantity calculation, and the mapping relationship between the name and attributes of components in the BIM model and the name and attributes of components in the engineering quantity calculation.

[0059] Step 102: When performing engineering quantity statistics, read the parameter configuration database to complete the parameter settings.

[0060] Unlike existing technologies, in this embodiment of the invention, the parameter settings can be completed by the Revit software reading the parameter configuration database, without the need for manual settings by the software operator.

[0061] Step 103: Complete floor mapping and attribute mapping according to the model mapping rule base, automatically complete model mapping, and convert Revit components into software-recognizable components.

[0062] Similarly, in this embodiment of the invention, Revit software can complete floor mapping and attribute mapping according to the model mapping rule base. For example, it can automatically read the building elevation of model components. Furthermore, it can also support manual adjustment of the read data.

[0063] In the process of calculating quantities, fixed attributes are used, such as "concrete strength grade". In this embodiment of the invention, modeling specifications can be established in advance during the design and modeling process, standardizing the naming of components and attribute items. The software pre-maps and matches the attributes in the database, and the software operator can directly call them without manual configuration.

[0064] The existing operational approach of BIM quantity takeoff software is to convert Revit components into components that the software can recognize. During design modeling, different designers may use different names for the families and family types of the model components, such as "Rectangle-Column-500x500" or "KZ-500x500". Therefore, it is necessary to match and map these family type names in the BIM model with the component names in the quantity takeoff software. This involves mapping the BIM model with family type names like "Rectangle-Column-500x500" or "KZ-500x500" to a "Column" or "Frame Column" quantity takeoff model in the software that can calculate quantities according to rules. In the current Revit-based quantity takeoff process, software operators need to manually adjust the component mapping classifications during model mapping to improve the matching success rate.

[0065] In this invention, the component naming standard in the modeling standard can be used as a basis to pre-configure a rule base, establish the association between component names and component keywords, and store them in a database. This way, during model mapping, the model mapping process can be completed automatically without manual adjustments by software operators.

[0066] Furthermore, to ensure the accuracy of model mapping, a model mapping result report can be generated after the model mapping is completed.

[0067] Furthermore, the report content can be located and reverse-checked, which better ensures the accuracy of the model mapping.

[0068] It is evident that, from a model perspective, by standardizing the names of model components, components can be located quickly and accurately using their names; from a software perspective, this can improve the accuracy of model mapping, shorten software operation time, and increase work efficiency.

[0069] Step 104: Establish the association between components in the BIM model and items in the bill of quantities, and complete the bill of quantities linking.

[0070] Specifically, obtain the keywords of the component names in the BIM model; establish the association between the components in the BIM model and the items in the list based on the keywords.

[0071] The aforementioned list linking refers to the association between BIM model components and list items. Furthermore, corresponding quantity calculation formulas and quantity merging conditions can be set in the list (after quantity calculation, list item features are formed). In this way, when calculating quantities, the quantity calculation formulas and quantity merging conditions in the associated list can be used to calculate the quantity results, and the quantity calculation results can be filled into the quantity calculation formulas in the list, while the list merging conditions can be filled into the list item features.

[0072] In existing technologies, the main methods for linking lists are manually setting up the list or importing the list into the list linking interface. These methods are time-consuming and inefficient.

[0073] In this invention, the list is automatically linked by reading the component name keywords (the component naming has been standardized through modeling before modeling). After the automatic linking is completed, only a quick check and correction are needed, which reduces the difficulty of operation, saves working time, and improves work efficiency.

[0074] Step 105: Calculate the quantities of the project based on the list to obtain the quantities of the model components.

[0075] For example, calculations may include, but are not limited to, the following: merging engineering calculation data; summarizing and calculating the quantities of project model components based on bill of quantities templates, calculation rules, bill of quantities libraries, etc. Specific calculations can be determined according to actual needs, and this embodiment of the invention does not limit them.

[0076] Step 106: Output a report based on the calculation results.

[0077] When no inventory list is attached, output a physical quantity information report. The physical quantity information report may include, but is not limited to, any one or more of the following: physical quantity summary report, physical quantity floor summary report, physical quantity detail report, etc.

[0078] When attaching a list, output a list information table. The list information table may include, but is not limited to, any one or more of the following: a list summary table, a list floor summary table, a list detail table, etc.

[0079] The physical quantity information report and the list information table can be in any one or more of the following formats: EXCEL, XML, PDF.

[0080] Depending on the actual needs, you can also choose to export, print, or save the corresponding report.

[0081] The method for rapid quantity calculation provided by this invention configures the database and model mapping rule base by pre-setting parameters; when performing quantity calculation, it can automatically complete parameter setting, floor mapping, attribute mapping, and model mapping; and efficiently complete operations such as bill of quantities attachment, which can greatly improve the efficiency and accuracy of Revit-based quantity calculation.

[0082] Accordingly, the present invention also provides a rapid quantity calculation system for engineering projects, such as... Figure 2 The diagram shown is a structural schematic of the system.

[0083] The rapid quantity surveying system 200 includes the following modules:

[0084] Configuration module 201 is used to pre-set parameters for the configuration database and model mapping rule base;

[0085] The setting module 202 is used to read the parameter configuration database to complete the parameter setting when performing engineering quantity statistics;

[0086] The mapping module 203 is used to complete floor mapping and attribute mapping according to the model mapping rule library, and automatically complete model mapping to convert Revit components into software-recognizable components;

[0087] The attachment module 204 is used to establish the association between components in the BIM model and items in the bill of quantities, and to complete the attachment of the bill of quantities.

[0088] Calculation module 205 is used to calculate the quantities of the project based on the bill of quantities to obtain the quantities of the model components.

[0089] The report output module 206 is used to output reports based on the calculation results.

[0090] The rapid quantity calculation system provided by this invention converts a BIM model into a quantity calculation model through model mapping settings. By reading the three-dimensional information of the BIM model and combining it with quantity calculation rules, it calculates the quantities of work, including volume, template area, length, surface area, and projected area. Using this invention, the efficiency and accuracy of quantity calculation based on Revit can be greatly improved.

[0091] The specific implementation methods of the above modules can be found in the descriptions in the previous embodiments of the present invention, and will not be repeated here.

[0092] It should be noted that, for the sake of simplicity, the foregoing method embodiments are all described as a series of actions. However, those skilled in the art should understand that the present invention is not limited to the described order of actions, because according to the present invention, some steps can be performed in other orders or simultaneously. Furthermore, those skilled in the art should also understand that the embodiments described in the specification are preferred embodiments, and the actions and modules involved are not necessarily essential to the present invention.

[0093] In the above embodiments, the descriptions of each embodiment have different focuses. For parts not described in detail in a certain embodiment, please refer to the relevant descriptions in other embodiments.

[0094] In the several embodiments provided by this invention, it should be understood that the disclosed system can be implemented in other ways.

[0095] The present invention also provides a storage medium, which is a computer-readable storage medium storing a computer program thereon, the computer program being executable when it runs. Figure 1 The method shown may include some or all of the steps. The storage medium may include read-only memory (ROM), random access memory (RAM), magnetic disk or optical disk, etc. The storage medium may also include non-volatile memory or non-transitory memory, etc.

[0096] The above embodiments can be implemented, in whole or in part, by software, hardware, firmware, or any other combination thereof. When implemented using software, the above embodiments can be implemented, in whole or in part, as a computer program product. The computer program product includes one or more computer instructions or computer programs. When the computer instructions or computer program are loaded or executed on a computer, all or part of the processes or functions described in the embodiments of this application are generated. The computer can be a general-purpose computer, a special-purpose computer, a computer network, or other programmable system. The computer instructions can be stored in a computer-readable storage medium or transmitted from one computer-readable storage medium to another. For example, the computer instructions can be transmitted from one website, computer, server, or data provider to another website, computer, server, or data provider via wired or wireless means.

[0097] The embodiments of the present invention have been described in detail above. Specific implementation methods have been used to illustrate the present invention. The descriptions of the embodiments above are only for the purpose of helping to understand the methods and systems of the present invention, and are merely some, not all, embodiments of the present invention. Based on the embodiments of the present invention, all other embodiments obtained by those skilled in the art without creative effort should fall within the scope of protection of the present invention, and the content of this specification should not be construed as a limitation of the present 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 quickly counting quantities, characterized by, The method comprises: pre-setting a parameter configuration database and a model mapping rule library; reading the parameter configuration database to complete parameter setting when performing quantity statistics; completing floor mapping and attribute mapping according to the model mapping rule library, and automatically completing model mapping to convert Revit components into components recognizable by software; establishing the association between components in the BIM model and items in the list to complete list linking; calculating the quantity according to the list to obtain the model component quantity; outputting a report according to the calculation result; the parameter configuration database comprises a list library and / or a quota library; the list library comprises one or more list items, and each list item comprises any one or more of the following information: quantity calculation rules, quantity output content; the model mapping rule library comprises the correspondence between the building elevation of the component in the BIM model and the floor in the quantity calculation, and the mapping relationship between the name and attribute of the component in the BIM model and the name and attribute of the component in the quantity calculation.

2. The method of quickly counting quantities according to claim 1, wherein, The method further comprises: setting corresponding quantity calculation formulas and quantity merging conditions in the list. The method further comprises:

3. The method of quickly counting quantities according to claim 2, wherein, generating a model mapping result report after completing model mapping. The method further comprises:

4. The method of quickly counting quantities according to claim 1, wherein, outputting a physical quantity information report when the list is not linked; and outputting a list information table when the list is linked.

6. The rapid quantity calculation method according to claim 5, characterized in that:

5. The method of quickly counting quantities according to claim 1, wherein, the physical quantity information report comprises any one or more of the following: a physical quantity summary report, a physical quantity floor summary table, and a physical quantity detail table; and the list information table comprises any one or more of the following: a list summary table, a list floor summary table, and a list detail table. The format of the physical quantity information report and the list information table is any one or more of the following: EXCEL, XML, and PDF. The system comprises: a configuration module configured to pre-set a parameter configuration database and a model mapping rule library; a setting module configured to read the parameter configuration database to complete parameter setting when performing quantity statistics; a mapping module configured to complete floor mapping and attribute mapping according to the model mapping rule library, and automatically complete model mapping to convert Revit components into components recognizable by software; 7. The method of quickly counting quantities according to claim 5, wherein, a linking module configured to establish the association between components in the BIM model and items in the list to complete list linking; 8. A system for the quick statistical method of quantities according to any one of claims 1-7, characterized in that, a calculation module configured to calculate the quantity according to the list to obtain the model component quantity; a report output module configured to output a report according to the calculation result. The computer program is executed by a processor to perform the steps of the rapid quantity calculation method according to any one of claims 1 to 7. ​ ​ ​ ​ 9. A computer readable storage medium having stored thereon a computer program, characterized in that, ​

Images