BIM (Building Information Modeling)-based engineering quantity calculation method and system as well as list generation method and system

By using SQL query and summary calculation in BIM component engineering scale, the target engineering quantity is quickly matched and calculated, and the problems of low efficiency and applicability of engineering quantity calculation in the existing technology are solved, and more efficient engineering quantity calculation is achieved .

CN118916374AInactive Publication Date: 2024-11-08GUANGZHOU QINGJU DIGITAL TECH CO LTD
View PDF 4 Cites 0 Cited by

Patent Information

Application Number
CN202410949256.0
Authority / Receiving Office
CN · China
Patent Type
Applications(China)
Current Assignee / Owner
Filing Date
2024-07-16
Publication Date
2024-11-08
Estimated Expiration
Not applicable · inactive patent

AI Technical Summary

Technical Problem

The existing BIM-based engineering quantity calculation method has problems of low computing efficiency and low applicability, especially when the engineering quantity calculation requirements of different construction projects are different, it requires manual adjustment and modification, which increases the difficulty and time cost of calculation.

Method used

By confirming the component name to be calculated in the component engineering table, its corresponding classification conditions and project quantity names, using SQL query and summary calculations, quickly obtain and match the corresponding classification conditions and project quantity, and achieving the calculation of the target project quantity.

Benefits of technology

It improves the efficiency and applicability of engineering quantity calculation, reduces the need for manual adjustment, simplifies the calculation process, and reduces time costs.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure CN118916374A_ABST
    Figure CN118916374A_ABST
Patent Text Reader

Abstract

The invention discloses a BIM-based engineering quantity calculation method and system, and a list generation method and system. The method comprises the following steps: confirming a to-be-calculated component name in a component engineering quantity table, and a to-be-calculated classification condition name and a to-be-calculated engineering quantity name corresponding to the to-be-calculated component name; wherein the component engineering quantity table is used for recording engineering quantities corresponding to different components; respectively querying a to-be-calculated classification condition and a to-be-calculated project amount corresponding to the to-be-calculated classification condition name and the to-be-calculated project amount name in the component project amount table through an SQL (Structured Query Language); and summarizing and calculating the to-be-calculated engineering quantity to obtain a target engineering quantity corresponding to the to-be-calculated component. According to the invention, the efficiency and applicability of bill of quantity calculation can be improved.
Need to check novelty before this filing date? Find Prior Art

Description

Technical Field

[0001] The present application relates to the field of digital engineering cost, and in particular to a method for calculating engineering quantities, a method for generating a list of items and a system based on BIM. Background Art

[0002] BIM (Building Information Modeling) is a complete information model that can integrate engineering information, processes and resources at different stages of the project life cycle into one model for easy use by project participants.

[0003] With the promotion and application of BIM building models, BIM building models have been widely used in the construction cost industry to calculate construction quantities. At present, the BIM model needs to set up the mapping relationship between each component and the corresponding list, and then summarize the quantity corresponding to each list through software. The relationship between components and lists in the bill of quantities is one-to-many, so the workload of setting the mapping relationship is large. In addition, when calculating the quantities of different construction projects through BIM building models, the pricing rules are often not completely consistent, resulting in a lot of manual adjustments and modifications before calculation to adapt to the quantity calculation requirements of different construction projects, thereby increasing the difficulty of calculation and time cost.

[0004] Application Contents

[0005] The present application provides a BIM-based engineering quantity calculation method, a list generation method and a system to improve the efficiency and applicability of engineering quantity list calculation.

[0006] In a first aspect, the present application provides a method for calculating engineering quantities based on BIM, comprising:

[0007] Confirm the name of the component to be calculated in the component engineering quantity table, as well as the name of the classification condition to be calculated and the name of the engineering quantity to be calculated corresponding to the name of the component to be calculated; wherein the component engineering quantity table is used to record the engineering quantities corresponding to different components;

[0008] Using SQL, respectively query the classification conditions to be calculated and the engineering quantities to be calculated corresponding to the classification condition names to be calculated and the engineering quantities to be calculated in the component engineering quantity table;

[0009] By summarizing and calculating the engineering quantities to be calculated, the target engineering quantities corresponding to the components to be calculated are obtained.

[0010] The embodiment of the present application first confirms the name of the component to be calculated and the name of the classification condition to be calculated and the name of the engineering quantity to be calculated corresponding to the name of the component to be calculated, and matches the classification condition to be calculated and the engineering quantity to be calculated by the name of the classification condition to be calculated and the name of the engineering quantity to be calculated. It can quickly obtain the classification condition to be calculated and the engineering quantity to be calculated that match the component to be calculated, which is convenient for subsequent calculation of the target engineering quantity; by summarizing and calculating the engineering quantities to be calculated, the target engineering quantity corresponding to the component to be calculated can be quickly calculated, thereby improving the efficiency and applicability of engineering quantity calculation.

[0011] Furthermore, before confirming the name of the component to be calculated in the component engineering quantity table, the method further includes:

[0012] Obtain several initial component quantities through the BIM model;

[0013] Traversing the initial component engineering quantity table, extracting the initial component name, the initial classification condition name and the initial engineering quantity name as the header of the component engineering quantity table, and removing duplicate items of the initial classification condition name and the initial engineering quantity name;

[0014] The initial component engineering quantity table is traversed again, and the component engineering quantity table is filled with data corresponding to the initial component name, the initial classification condition name and the initial engineering quantity name to obtain the component engineering quantity table.

[0015] In this way, by using the three fields of component name, classification condition name and quantity name of several initial component quantity tables as table headers and filling the corresponding content in the table, table aggregation can be achieved and invalid information can be filtered out.

[0016] Further, the SQL is used to query the classification conditions to be calculated and the engineering quantities to be calculated corresponding to the classification condition names to be calculated and the engineering quantities to be calculated in the component engineering quantities table, specifically:

[0017] Filter out the classification condition names to be calculated containing keywords in the component engineering quantity table through SQL to obtain classification condition records to be calculated; wherein the classification condition records to be calculated include a number of engineering quantities to be calculated;

[0018] And query the engineering quantity to be calculated corresponding to the name of the engineering quantity to be calculated in the classification condition record to be calculated through SQL.

[0019] In this way, the classification conditions to be calculated that meet the conditions are screened out according to the keywords through SQL, and the classification conditions to be calculated are screened again to obtain the engineering quantities to be calculated.

[0020] In a second aspect, the present invention further provides a method for generating a bill of quantities, comprising:

[0021] Confirming the components in the bill of quantities and the components to be calculated in the component bill of quantities; wherein the components to be calculated correspond to the components;

[0022] Using SQL to query the engineering quantity records corresponding to the components to be calculated in the component engineering quantity table, wherein the engineering quantity records include a number of components to be calculated, a number of classification conditions to be calculated, and a number of engineering quantities to be calculated;

[0023] According to a BIM-based engineering quantity calculation method described in the present application, the target engineering quantity of the component to be calculated in the component engineering quantity table is calculated;

[0024] The engineering quantity record and the target engineering quantity are imported into the engineering quantity list to obtain a target engineering quantity list including the component calculation results.

[0025] This embodiment can quickly obtain the quantity records related to the components to be calculated by first confirming the components in the bill of quantities table and the components to be calculated in the component quantity table, and respectively querying the quantity records corresponding to the components to be calculated in the component quantity table through SQL; and can quickly calculate the target quantity corresponding to the components to be calculated by summarizing and calculating the quantities to be calculated; and importing the quantity records and the target quantity into the bill of quantities table to obtain the target bill of quantities containing the calculation results of the components, which can help users quickly understand the quantity of each component in different component quantity tables and facilitate data verification and data traceability.

[0026] Furthermore, after importing the components to be calculated and the target engineering quantities into the engineering quantity bill table to obtain the target engineering quantity bill, the method further includes:

[0027] Obtaining the name of the initial engineering quantity table corresponding to the component to be calculated;

[0028] Obtaining, in the initial worksheet name, a row number corresponding to the classification condition to be calculated corresponding to the component to be calculated and a column number corresponding to the engineering quantity to be calculated corresponding to the component to be calculated;

[0029] The name of the initial engineering quantity table, the row number corresponding to the classification condition to be calculated and the column number corresponding to the engineering quantity to be calculated are combined into a link formula, and the formula is assigned to the cell corresponding to the target engineering quantity in the target engineering quantity list.

[0030] In this way, by linking the cell address to the target bill of quantities, users can directly see the data source of the target quantity, which facilitates data traceability.

[0031] In a third aspect, the present application provides a BIM-based engineering quantity calculation system, comprising: an acquisition module, a matching module and a first calculation module;

[0032] The acquisition module is used to confirm the name of the component to be calculated in the component engineering quantity table, and the name of the classification condition to be calculated and the name of the engineering quantity to be calculated corresponding to the name of the component to be calculated; wherein the component engineering quantity table is used to record the engineering quantities corresponding to different components;

[0033] The matching module is used to query the classification conditions to be calculated and the engineering quantities to be calculated corresponding to the classification condition names to be calculated and the engineering quantities to be calculated respectively in the component engineering quantity table through SQL;

[0034] The first calculation module is used to obtain the target engineering quantity corresponding to the component to be calculated by summarizing and calculating the engineering quantities to be calculated.

[0035] The embodiment of the present application first confirms the name of the component to be calculated and the name of the classification condition to be calculated and the name of the engineering quantity to be calculated corresponding to the name of the component to be calculated, and matches the classification condition to be calculated and the engineering quantity to be calculated by the name of the classification condition to be calculated and the name of the engineering quantity to be calculated. It can quickly obtain the classification condition to be calculated and the engineering quantity to be calculated that match the component to be calculated, which is convenient for subsequent calculation of the target engineering quantity; by summarizing and calculating the engineering quantities to be calculated, the target engineering quantity corresponding to the component to be calculated can be quickly calculated, thereby improving the efficiency and applicability of engineering quantity calculation.

[0036] Furthermore, the BIM-based engineering quantity calculation system also includes: a summary module;

[0037] The summarizing module includes: a first acquiring unit, a first extracting unit and a summarizing unit;

[0038] The first acquisition unit is used to acquire a plurality of initial component quantity tables through the BIM model;

[0039] The first extraction unit is used to traverse the initial component engineering quantity table, extract the initial component name, the initial classification condition name and the initial engineering quantity name as the header of the component engineering quantity table, and remove duplicate items of the initial classification condition name and the initial engineering quantity name;

[0040] The summarizing unit is used to traverse the initial component engineering quantity table again, fill the component engineering quantity table with data corresponding to the initial component name, the initial classification condition name and the initial engineering quantity name, and obtain the component engineering quantity table.

[0041] Further, the matching module includes: a screening unit and a query unit;

[0042] The screening unit is used to screen out the classification condition names to be calculated containing keywords in the component engineering quantity table through SQL to obtain classification condition records to be calculated; wherein the classification condition records to be calculated include a plurality of engineering quantities to be calculated;

[0043] The query unit is used to query the engineering quantity to be calculated corresponding to the name of the engineering quantity to be calculated in the classification condition record to be calculated through SQL.

[0044] In a fourth aspect, the present application further provides a BIM-based bill of quantities generation system, characterized in that it also includes: a confirmation module, a query module, a second calculation module and an import module;

[0045] The confirmation module is used to confirm the components in the bill of quantities and the components to be calculated in the component bill of quantities; wherein the components to be calculated correspond to the components;

[0046] The query module is used to query the engineering quantity records corresponding to the components to be calculated in the component engineering quantity table through SQL, wherein the engineering quantity records include a number of components to be calculated, a number of classification conditions to be calculated, and a number of engineering quantities to be calculated;

[0047] The second calculation module is used to calculate the target quantity of the component to be calculated in the component quantity table according to a BIM-based quantity calculation method described in the present application;

[0048] The import module is used to import the engineering quantity record and the target engineering quantity into the engineering quantity list to obtain a target engineering quantity list including the component calculation results.

[0049] This embodiment can quickly obtain the quantity records related to the components to be calculated by first confirming the components in the bill of quantities table and the components to be calculated in the component quantity table, and respectively querying the quantity records corresponding to the components to be calculated in the component quantity table through SQL; and can quickly calculate the target quantity corresponding to the components to be calculated by summarizing and calculating the quantities to be calculated; and importing the quantity records and the target quantity into the bill of quantities table to obtain the target bill of quantities containing the calculation results of the components, which can help users quickly understand the quantity of each component in different component quantity tables and facilitate data verification and data traceability.

[0050] Furthermore, the BIM-based bill of quantities generation system also includes: a link module;

[0051] The link module includes: a third acquisition unit, a fourth acquisition unit and a link unit;

[0052] The third acquisition unit is used to acquire the name of the initial engineering quantity table corresponding to the component to be calculated;

[0053] The fourth acquisition unit is used to acquire, in the initial worksheet name, a row number corresponding to the classification condition to be calculated corresponding to the component to be calculated and a column number corresponding to the engineering quantity to be calculated corresponding to the component to be calculated;

[0054] The link unit is used to combine the name of the initial engineering quantity table, the row number corresponding to the classification condition to be calculated and the column number corresponding to the engineering quantity to be calculated into a link formula, and assign it to the cell corresponding to the target engineering quantity in the target engineering quantity list. BRIEF DESCRIPTION OF THE DRAWINGS

[0055] In order to more clearly illustrate the technical solution of the present invention, the drawings required for use in the implementation mode will be briefly introduced below. Obviously, the drawings described below are only some implementation modes of the present invention. For ordinary technicians in this field, other drawings can be obtained based on these drawings without paying creative work.

[0056] Figure 1 It is a flow chart of an embodiment of a method for calculating engineering quantities based on BIM provided by the present application;

[0057] Figure 2 is a schematic diagram of the beam component list provided in this application;

[0058] Figure 3 It is a flowchart of an embodiment of a method for generating a bill of quantities based on BIM provided by the present application;

[0059] Figure 4 is a schematic diagram of the bill of quantities provided in this application;

[0060] Figure 5 It is a flowchart of another embodiment of a method for generating a bill of quantities based on BIM provided by the present application;

[0061] Figure 6 It is a structural schematic diagram of an embodiment of a BIM-based engineering quantity calculation system provided by the present application;

[0062] Figure 7 It is a structural schematic diagram of an embodiment of a BIM-based bill of quantities generation system provided by the present application. DETAILED DESCRIPTION

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

[0064] It should be understood that the step numbers used in this article are only for the convenience of description and are not intended to limit the order in which the steps are executed.

[0065] It should be understood that the terms used in the present specification are only for the purpose of describing specific embodiments and are not intended to limit the present invention. As used in the present specification and the appended claims, the singular forms "a", "an" and "the" are intended to include plural forms unless the context clearly indicates otherwise.

[0066] The terms “include” and “comprising” indicate the presence of described features, integers, steps, operations, elements and / or components, but do not exclude the presence or addition of one or more other features, integers, steps, operations, elements, components and / or combinations thereof.

[0067] The term "and / or" means and includes any and all possible combinations of one or more of the associated listed items.

[0068] A very important task in the preparation of the bill of quantities is the calculation of the bill quantities. With the promotion and application of the BIM building model, the BIM building model has been widely used in the engineering cost industry to calculate the construction quantities. When calculating the quantities of different construction projects through the BIM building model, the pricing rules are often not completely consistent, resulting in a large amount of manual adjustment and modification work before the calculation to adapt to the quantity calculation requirements of different construction projects. Therefore, the existing method of calculating the quantity through BIM has the problems of low calculation efficiency and low applicability.

[0069] Embodiment 1

[0070] Please refer to Figure 1 , Figure 1 This is a flow chart of an embodiment of a method for calculating engineering quantities based on BIM provided by the present application, including steps S10 to S30:

[0071] Step S10, confirming the name of the component to be calculated in the component engineering quantity table, and the name of the classification condition to be calculated and the name of the engineering quantity to be calculated corresponding to the name of the component to be calculated; wherein the component engineering quantity table is used to record the engineering quantities corresponding to different components;

[0072] It should be noted that the component quantity table is an important part of the calculation process of the engineering project. It is composed of several component tables. Each component table consists of two parts: several classification condition names and several quantity names. The component names can be beams, columns, doors and windows, etc., the classification condition names can be floors, names and concrete strength grades, etc., and the quantity names can be volume, area, perimeter, height and width, etc.

[0073] Before confirming the names of the components to be calculated in the component quantity table, it is necessary to obtain several initial component quantity tables through the BIM model; traverse the initial component quantity tables, extract the initial component names, initial classification condition names and initial quantity names as the table headers of the component quantity tables, and remove duplicate items of the initial classification condition names and the initial quantity names; traverse the initial component quantity table again, fill the component quantity table with data corresponding to the initial component names, the initial classification condition names and the initial quantity names, and obtain the component quantity table.

[0074] It should be noted that the initial component quantity table can be exported through the BIM model. The user sets the classification condition name and quantity name to be exported on the corresponding BIM model, and then exports several initial component quantity tables. The BIM model for exporting the initial component quantity table is not the focus of this application, and this embodiment does not limit this.

[0075] It can be understood that, by using the initial component name, initial classification condition name and initial quantity name of the initial component quantity table as the table header index, traversing several initial component quantity tables through a computer program, finding the components, classification conditions and quantities corresponding to the initial component name, initial classification condition name and initial quantity name, and filling them into the component quantity table, the summary of several initial quantity tables is completed. Exemplarily, assuming that the name of the initial component to be calculated is beam, the name of the initial classification condition is floor, and the name of the initial quantity is volume, beam, floor and volume are used as table headers and indexed, and information such as floor: foundation layer and first floor, volume: 9.4865, 2.7825 and 6.9134 can be searched in the initial component quantity table, and filled into the corresponding position in the component quantity table, and the summary of the initial quantity table can be completed.

[0076] In this way, by using the three fields of component name, classification condition name and quantity name of several initial component quantity tables as table headers and filling the corresponding content in the table, table aggregation can be achieved and invalid information can be filtered out.

[0077] Step S20, respectively searching the to-be-calculated classification conditions and the to-be-calculated engineering quantities corresponding to the to-be-calculated classification condition names and the to-be-calculated engineering quantities names in the component engineering quantity table through SQL;

[0078] Specifically, the name of the to-be-calculated classification condition containing a keyword is filtered out in the component quantity table through SQL to obtain a record of the to-be-calculated classification condition, wherein the record of the to-be-calculated classification condition includes a number of the quantities to be calculated; and the quantity to be calculated corresponding to the name of the quantity to be calculated is queried in the record of the to-be-calculated classification condition through SQL.

[0079] It is understandable that it is also possible to directly query the classification conditions to be calculated and the quantities to be calculated corresponding to the names of the classification conditions to be calculated and the names of the quantities to be calculated in the component quantity table through SQL. For example, assuming that the name of the component to be calculated is a beam, and the name of the classification condition to be calculated is a floor, through SQL statements such as "select the classification condition to be calculated = 'floor' from the component quantity summary table where the name of the component to be calculated = 'beam'", the information corresponding to the floors of the beam components containing several quantities to be calculated can be obtained; assuming that the name of the quantity to be calculated is volume, through SQL statements such as "select the name of the quantity to be calculated = 'volume' from the component quantity summary table where the name of the component to be calculated = 'beam'", the volume corresponding to the beam component can be obtained.

[0080] In this way, the classification conditions to be calculated that meet the conditions are screened out according to the keywords through SQL, and the classification conditions to be calculated are screened again to obtain the engineering quantities to be calculated.

[0081] Step S30, obtaining the target engineering quantity corresponding to the component to be calculated by summarizing and calculating the engineering quantities to be calculated.

[0082] It should be noted that the target quantity is the actual quantity of the component to be calculated. For example, assuming that the name of the component to be calculated is beam, the name of the classification condition to be calculated is floor, and the name of the quantity to be calculated is volume, the classification condition to be calculated corresponding to the floor and volume is queried through SQL: foundation layer, and the quantities to be calculated are: 9.4865 square meters, 2.7825 square meters and 6.9134 square meters. By summarizing the quantities to be calculated, the target quantity is 19.1824 square meters. For another example, assuming that the name of the component to be calculated is beam, the name of the classification condition to be calculated is floor, and the name of the quantity to be calculated is section width, the classification condition to be calculated corresponding to the floor and section width is queried through SQL: foundation layer, and the quantities to be calculated are: 0.6 meters, 0.6 meters and 0.6 meters. By summarizing the quantities to be calculated, the target quantity is 1.8 meters. The schematic diagram of the beam component list is shown as follows. Figure 2 shown.

[0083] The embodiment of the present application first confirms the name of the component to be calculated and the name of the classification condition to be calculated and the name of the engineering quantity to be calculated corresponding to the name of the component to be calculated, and matches the classification condition to be calculated and the engineering quantity to be calculated by the name of the classification condition to be calculated and the name of the engineering quantity to be calculated. It can quickly obtain the classification condition to be calculated and the engineering quantity to be calculated that match the component to be calculated, which is convenient for subsequent calculation of the target engineering quantity; by summarizing and calculating the engineering quantities to be calculated, the target engineering quantity corresponding to the component to be calculated can be quickly calculated, thereby improving the efficiency and applicability of engineering quantity calculation.

[0084] Embodiment 2

[0085] Please refer to Figure 3 , Figure 3 It is a flowchart of an embodiment of a method for generating a bill of quantities based on BIM provided by the present application, including steps S21 to S24:

[0086] Step S21, confirming the components in the bill of quantities and the components to be calculated in the component bill of quantities; wherein the components to be calculated correspond to the components;

[0087] It should be noted that the bill of quantities is an important basis for pricing construction projects and is composed of project code, project name, project characteristics, measurement units, project quantities and prices.

[0088] It should be noted that the user sets the items to be exported on the corresponding pricing software, such as project number, project characteristics and comprehensive unit price, etc., to export the initial bill of quantities and obtain the initial bill of quantities table; set preset fields, extract the preset fields as the table header by traversing the initial bill of quantities of the bill of quantities, and use the preset fields as indexes to traverse the initial bill of quantities through a computer program to find the content corresponding to the preset fields and fill them into the bill of quantities, set keywords, and use a computer program to remove the quantity records containing keywords in the bill of quantities to clean and structure the initial bill of quantities. Exemplarily, the project code, project name, project characteristics, unit and quantity are set as the table header, and the corresponding contents of the project code, project name, project characteristics, unit and quantity are identified in the initial bill of quantities, and the corresponding contents are filled into the corresponding positions in the bill of quantities table, such as 10101001032, leveling site and other information, and keywords are set, such as empty characters, units, subtotals and totals, etc. Keywords, and the quantity records containing keywords in the bill of quantities are removed by a computer program, so that the cleaning and structuring of the initial bill of quantities can be completed. The schematic diagram of the bill of quantities is shown as follows Figure 4 shown.

[0089] Step S22, querying the engineering quantity records corresponding to the components to be calculated in the component engineering quantity table through SQL, wherein the engineering quantity records include a number of components to be calculated, a number of classification conditions to be calculated, and a number of engineering quantities to be calculated;

[0090] It can be understood that, taking the component to be calculated as an index, traversing the component quantity table through SQL, extracting several classification conditions and several quantities corresponding to the component to be calculated, and summarizing the component to be calculated, the quantity record corresponding to the component to be calculated is obtained. For example, assuming that the name of the initial component to be calculated is a beam, by traversing the component quantity table through SQL, the classification conditions corresponding to the beam can be obtained: floor, name and concrete strength grade, as well as the specific values ​​involved in the volume, area, perimeter, height and width of the quantity corresponding to the beam.

[0091] Step S23, calculating the target quantity of the component to be calculated in the component quantity table according to the BIM-based quantity calculation method described in the first embodiment;

[0092] It should be noted that this step has been described in detail in the first embodiment above, so it will not be repeated here.

[0093] Step S24, importing the engineering quantity record and the target engineering quantity into the engineering quantity list to obtain a target engineering quantity list including the component calculation results.

[0094] Specifically, the components to be calculated and the corresponding records of the components to be calculated are identified in the bill of quantities, and the quantity records are automatically imported into the bill of quantities as children of the records of the components to be calculated, and the target quantities are imported into the bill of quantities as the target quantities corresponding to the components to be calculated.

[0095] It should be noted that when importing the target quantity and the quantity records into the bill of quantities, you can choose to import only the target quantity, import all quantity records, import one quantity record, or import selected quantity records, and the specific imported content can be further screened by a computer program.

[0096] After the components to be calculated and the target quantities are imported into the bill of quantities table to obtain the target bill of quantities, the method further includes: obtaining an initial table of quantities name corresponding to the components to be calculated; obtaining in the initial worksheet name the row number corresponding to the classification condition to be calculated corresponding to the components to be calculated and the column number corresponding to the quantity to be calculated corresponding to the components to be calculated; combining the initial table of quantities name, the row number corresponding to the classification condition to be calculated and the column number corresponding to the quantity to be calculated into a link formula, and assigning the formula to the cell corresponding to the target quantity in the target bill of quantities.

[0097] In this way, by linking the cell address to the target bill of quantities, users can directly see the data source of the target quantity, which facilitates data traceability.

[0098] This embodiment can quickly obtain the quantity records related to the components to be calculated by first confirming the components in the bill of quantities table and the components to be calculated in the component quantity table, and respectively querying the quantity records corresponding to the components to be calculated in the component quantity table through SQL; and can quickly calculate the target quantity corresponding to the components to be calculated by summarizing and calculating the quantities to be calculated; and importing the quantity records and the target quantity into the bill of quantities table to obtain the target bill of quantities containing the calculation results of the components, which can help users quickly understand the quantity of each component in different component quantity tables and facilitate data verification and data traceability.

[0099] Embodiment 3

[0100] For easier understanding, please refer to Figure 5 , Figure 5It is a flowchart of another embodiment of a method for generating a bill of quantities based on BIM provided by the present application;

[0101] First, several component quantity tables are exported through the BIM model; by traversing the component quantity tables, the initial component name, initial classification condition name and initial quantity name are extracted as the table header of the component quantity table, and the initial component quantity table is traversed again to fill the component quantity table with data corresponding to the initial component name, the initial classification condition name and the initial quantity name to realize the summary of component quantities; the component name, classification condition name and quantity name in the component quantity table are screened to obtain quantity records, and a BIM-based quantity calculation method described in Example 1 of the present application is used to summarize and calculate the quantities to obtain the target quantities; and the quantity records and the target quantities are imported into the bill of quantities table to obtain a target bill of quantities containing the component calculation results.

[0102] It should be noted that a BI M quantity enhancement platform can be developed for the BI M-based bill of quantities generation method, and the specific form of the BI M quantity enhancement platform can be a web page, a desktop application, or a plug-in. By importing several component quantity tables into the BI M quantity enhancement platform, table aggregation, quantity calculation, and other processing can be directly performed to generate a target bill of quantities containing target quantities, and the target bill of quantities can be exported from the BI M quantity enhancement platform according to preset content.

[0103] Embodiment 4

[0104] Please refer to Figure 6 , Figure 6 It is a structural schematic diagram of an embodiment of a BIM-based engineering quantity calculation system provided by the present application, comprising: an acquisition module 11, a matching module 12 and a first calculation module 13;

[0105] The acquisition module 11 is used to confirm the name of the component to be calculated in the component engineering quantity table, and the name of the classification condition to be calculated and the name of the engineering quantity to be calculated corresponding to the name of the component to be calculated; wherein the component engineering quantity table is used to record the engineering quantities corresponding to different components;

[0106] It should be noted that the component quantity table is an important part of the calculation process of the engineering project. It is composed of several component tables. Each component table consists of two parts: several classification condition names and several quantity names. The component names can be beams, columns, doors and windows, etc., the classification condition names can be floors, names and concrete strength grades, etc., and the quantity names can be volume, area, perimeter, height and width, etc.

[0107] Furthermore, the engineering quantity calculation system based on BI M also includes a summary module;

[0108] The summarizing module includes: a first acquiring unit, a first extracting unit and a summarizing unit;

[0109] The first acquisition unit is used to acquire a plurality of initial component engineering quantity tables through the BIM model;

[0110] The first extraction unit is used to traverse the initial component engineering quantity table, extract the initial component name, the initial classification condition name and the initial engineering quantity name as the header of the component engineering quantity table, and remove duplicate items of the initial classification condition name and the initial engineering quantity name;

[0111] The summarizing unit is used to traverse the initial component engineering quantity table again, fill the component engineering quantity table with data corresponding to the initial component name, the initial classification condition name and the initial engineering quantity name, and obtain the component engineering quantity table.

[0112] It should be noted that the initial component engineering quantity table can be exported through the BIM model. The user sets the classification condition name and engineering quantity name to be exported on the corresponding BIM model to export several initial component engineering quantity tables. The BIM model for exporting the initial component engineering quantity table is not the focus of this application, and this embodiment does not limit this.

[0113] It can be understood that, by using the initial component name, initial classification condition name and initial quantity name of the initial component quantity table as the table header index, traversing several initial component quantity tables through a computer program, finding the components, classification conditions and quantities corresponding to the initial component name, initial classification condition name and initial quantity name, and filling them into the component quantity table, the summary of several initial quantity tables is completed. Exemplarily, assuming that the name of the initial component to be calculated is beam, the name of the initial classification condition is floor, and the name of the initial quantity is volume, beam, floor and volume are used as table headers and indexed, and information such as floor: foundation layer and first floor, volume: 9.4865, 2.7825 and 6.9134 can be searched in the initial component quantity table, and filled into the corresponding position in the component quantity table, and the summary of the initial quantity table can be completed.

[0114] In this way, by using the three fields of component name, classification condition name and quantity name of several initial component quantity tables as table headers and filling the corresponding content in the table, table aggregation can be achieved and invalid information can be filtered out.

[0115] The matching module 12 is used to query the to-be-calculated classification conditions and the to-be-calculated engineering quantities corresponding to the to-be-calculated classification condition names and the to-be-calculated engineering quantities names in the component engineering quantity table through SQL;

[0116] Specifically, the matching module includes: a screening unit and a query unit;

[0117] The screening unit is used to screen out the classification condition names to be calculated containing keywords in the component engineering quantity table through SQL to obtain classification condition records to be calculated; wherein the classification condition records to be calculated include a plurality of engineering quantities to be calculated;

[0118] The query unit is used to query the engineering quantity to be calculated corresponding to the name of the engineering quantity to be calculated in the classification condition record to be calculated through SQL.

[0119] It is understandable that it is also possible to directly query the classification conditions to be calculated and the quantities to be calculated corresponding to the names of the classification conditions to be calculated and the names of the quantities to be calculated in the component quantity table through SQL. For example, assuming that the name of the component to be calculated is a beam, and the name of the classification condition to be calculated is a floor, through SQL statements such as "select the classification condition to be calculated = 'floor' from the component quantity summary table where the name of the component to be calculated = 'beam'", the information corresponding to the floors of the beam components containing several quantities to be calculated can be obtained; assuming that the name of the quantity to be calculated is volume, through SQL statements such as "select the name of the quantity to be calculated = 'volume' from the component quantity summary table where the name of the component to be calculated = 'beam'", the volume corresponding to the beam component can be obtained.

[0120] In this way, the classification conditions to be calculated that meet the conditions are screened out according to the keywords through SQL, and the classification conditions to be calculated are screened again to obtain the engineering quantities to be calculated.

[0121] The first calculation module 13 is used to obtain the target engineering quantity corresponding to the component to be calculated by summarizing and calculating the engineering quantities to be calculated.

[0122] It should be noted that the target quantity is the actual quantity of the component to be calculated. For example, assuming that the name of the component to be calculated is beam, the name of the classification condition to be calculated is floor, and the name of the quantity to be calculated is volume, the classification condition to be calculated corresponding to the floor and volume is queried through SQL: foundation layer, and the quantities to be calculated are: 9.4865 square meters, 2.7825 square meters and 6.9134 square meters. By summarizing the quantities to be calculated, the target quantity is 19.1824 square meters. For another example, assuming that the name of the component to be calculated is beam, the name of the classification condition to be calculated is floor, and the name of the quantity to be calculated is section width, the classification condition to be calculated corresponding to the floor and section width is queried through SQL: foundation layer, and the quantities to be calculated are: 0.6 meters, 0.6 meters and 0.6 meters. By summarizing the quantities to be calculated, the target quantity is 1.8 meters. The schematic diagram of the beam component list is shown as follows. Figure 2 shown.

[0123] The embodiment of the present application first confirms the name of the component to be calculated and the name of the classification condition to be calculated and the name of the engineering quantity to be calculated corresponding to the name of the component to be calculated, and matches the classification condition to be calculated and the engineering quantity to be calculated by the name of the classification condition to be calculated and the name of the engineering quantity to be calculated. It can quickly obtain the classification condition to be calculated and the engineering quantity to be calculated that match the component to be calculated, which is convenient for subsequent calculation of the target engineering quantity; by summarizing and calculating the engineering quantities to be calculated, the target engineering quantity corresponding to the component to be calculated can be quickly calculated, thereby improving the efficiency and applicability of engineering quantity calculation.

[0124] Embodiment 5

[0125] Please refer to Figure 7 , Figure 7 It is a structural schematic diagram of an embodiment of a BIM-based bill of quantities generation system provided by the present application, comprising: a confirmation module 21, a query module 22, a second calculation module 23 and an import module 24;

[0126] The confirmation module 21 is used to confirm the components in the bill of quantities and the components to be calculated in the component bill of quantities; wherein the components to be calculated correspond to the components;

[0127] It should be noted that the bill of quantities is an important basis for pricing construction projects and is composed of project code, project name, project characteristics, measurement units, project quantities and prices.

[0128] It should be noted that the user sets the items to be exported on the corresponding pricing software, such as project number, project characteristics and comprehensive unit price, etc., to export the initial bill of quantities and obtain the initial bill of quantities table; set preset fields, extract the preset fields as the table header by traversing the initial bill of quantities of the bill of quantities, and use the preset fields as indexes to traverse the initial bill of quantities through a computer program to find the content corresponding to the preset fields and fill them into the bill of quantities, set keywords, and use a computer program to remove the quantity records containing keywords in the bill of quantities to clean and structure the initial bill of quantities. Exemplarily, the project code, project name, project characteristics, unit and quantity are set as the table header, and the corresponding contents of the project code, project name, project characteristics, unit and quantity are identified in the initial bill of quantities, and the corresponding contents are filled into the corresponding positions in the bill of quantities table, such as 10101001032, leveling site and other information, and keywords are set, such as empty characters, units, subtotals and totals, etc. Keywords, and the quantity records containing keywords in the bill of quantities are removed by a computer program, so that the cleaning and structuring of the initial bill of quantities can be completed. The schematic diagram of the bill of quantities is shown as follows Figure 4 shown.

[0129] The query module 22 is used to query the engineering quantity records corresponding to the components to be calculated in the component engineering quantity table through SQL, wherein the engineering quantity records include a number of components to be calculated, a number of classification conditions to be calculated and a number of engineering quantities to be calculated;

[0130] It can be understood that, taking the component to be calculated as an index, traversing the component quantity table through SQL, extracting several classification conditions and several quantities corresponding to the component to be calculated, and summarizing the component to be calculated, the quantity record corresponding to the component to be calculated is obtained. For example, assuming that the name of the initial component to be calculated is a beam, by traversing the component quantity table through SQL, the classification conditions corresponding to the beam can be obtained: floor, name and concrete strength grade, as well as the specific values ​​involved in the volume, area, perimeter, height and width of the quantity corresponding to the beam.

[0131] The second calculation module 23 is used to calculate the target engineering quantity of the component to be calculated in the component engineering quantity table according to the engineering quantity calculation method based on BIM described in the first embodiment;

[0132] It should be noted that this step has been described in detail in the first embodiment above, so it will not be repeated here.

[0133] The import module 24 is used to import the engineering quantity record and the target engineering quantity into the engineering quantity list to obtain a target engineering quantity list including the component calculation results.

[0134] Specifically, the components to be calculated and the corresponding records of the components to be calculated are identified in the bill of quantities, and the quantity records are automatically imported into the bill of quantities as children of the records of the components to be calculated, and the target quantities are imported into the bill of quantities as the target quantities corresponding to the components to be calculated.

[0135] It should be noted that when importing the target quantity and the quantity records into the bill of quantities, you can choose to import only the target quantity, import all quantity records, import one quantity record, or import selected quantity records, and the specific imported content can be further screened by a computer program.

[0136] Furthermore, the BIM-based bill of quantities generation system further includes: a link module; the link module includes: a third acquisition unit, a fourth acquisition unit and a link unit;

[0137] The third acquisition unit is used to acquire the name of the initial engineering quantity table corresponding to the component to be calculated;

[0138] The fourth acquisition unit is used to acquire, in the initial worksheet name, a row number corresponding to the classification condition to be calculated corresponding to the component to be calculated and a column number corresponding to the engineering quantity to be calculated corresponding to the component to be calculated;

[0139] The link unit is used to combine the name of the initial engineering quantity table, the row number corresponding to the classification condition to be calculated and the column number corresponding to the engineering quantity to be calculated into a link formula, and assign it to the cell corresponding to the target engineering quantity in the target engineering quantity list.

[0140] In this way, by linking the cell address to the target bill of quantities, users can directly see the data source of the target quantity, which facilitates data traceability.

[0141] This embodiment can quickly obtain the quantity records related to the components to be calculated by first confirming the components in the bill of quantities table and the components to be calculated in the component quantity table, and respectively querying the quantity records corresponding to the components to be calculated in the component quantity table through SQL; and can quickly calculate the target quantity corresponding to the components to be calculated by summarizing and calculating the quantities to be calculated; and importing the quantity records and the target quantity into the bill of quantities table to obtain the target bill of quantities containing the calculation results of the components, which can help users quickly understand the quantity of each component in different component quantity tables and facilitate data verification and data traceability.

[0142] The specific embodiments described above further describe the purpose, technical solutions and beneficial effects of the present application in detail. It should be understood that the above description is only a specific embodiment of the present application and is not intended to limit the scope of protection of the present application. It is particularly pointed out that for those skilled in the art, any modification, equivalent replacement, improvement, etc. made within the spirit and principle of the present application should be included in the scope of protection of the present application.

Claims

1. A method for calculating engineering quantities based on BIM, It is characterized in that include: Confirm the name of the component to be calculated in the component engineering quantity table, as well as the name of the classification condition to be calculated and the name of the engineering quantity to be calculated corresponding to the name of the component to be calculated; wherein the component engineering quantity table is used to record the engineering quantities corresponding to different components; Using SQL, respectively query the classification conditions to be calculated and the engineering quantities to be calculated corresponding to the classification condition names to be calculated and the engineering quantities to be calculated in the component engineering quantity table; By summarizing and calculating the engineering quantities to be calculated, the target engineering quantities corresponding to the components to be calculated are obtained.

2. According to the BIM-based engineering quantity calculation method according to claim 1, It is characterized in that Before confirming the name of the component to be calculated in the component quantity table, it also includes: Obtain several initial component quantities through the BIM model; Traversing the initial component engineering quantity table, extracting the initial component name, the initial classification condition name and the initial engineering quantity name as the header of the component engineering quantity table, and removing duplicate items of the initial classification condition name and the initial engineering quantity name; The initial component engineering quantity table is traversed again, and the component engineering quantity table is filled with data corresponding to the initial component name, the initial classification condition name and the initial engineering quantity name to obtain the component engineering quantity table.

3. According to the BIM-based engineering quantity calculation method of claim 1, It is characterized in that The method of using SQL to query the component engineering quantity table for the classification conditions to be calculated and the engineering quantities to be calculated corresponding to the classification condition names to be calculated and the engineering quantities to be calculated is specifically as follows: Filter out the classification condition names to be calculated containing keywords in the component engineering quantity table through SQL to obtain classification condition records to be calculated; wherein the classification condition records to be calculated include a number of engineering quantities to be calculated; And query the engineering quantity to be calculated corresponding to the name of the engineering quantity to be calculated in the classification condition record to be calculated through SQL.

4. A method for generating bill of quantities based on BIM, It is characterized in that include: Confirming the components in the bill of quantities and the components to be calculated in the component bill of quantities; wherein the components to be calculated correspond to the components; Using SQL to query the engineering quantity records corresponding to the components to be calculated in the component engineering quantity table, wherein the engineering quantity records include a number of components to be calculated, a number of classification conditions to be calculated, and a number of engineering quantities to be calculated; According to the BIM-based engineering quantity calculation method according to any one of claims 1 to 3, the target engineering quantity of the component to be calculated in the component engineering quantity table is calculated; The engineering quantity record and the target engineering quantity are imported into the engineering quantity list to obtain a target engineering quantity list including the component calculation results.

5. According to the BIM-based bill of quantities generation method of claim 4, It is characterized in that After importing the components to be calculated and the target engineering quantity into the engineering quantity bill table to obtain the target engineering quantity bill, the method further includes: Obtaining the name of the initial engineering quantity table corresponding to the component to be calculated; Obtaining, in the initial worksheet name, a row number corresponding to the classification condition to be calculated corresponding to the component to be calculated and a column number corresponding to the engineering quantity to be calculated corresponding to the component to be calculated; The name of the initial engineering quantity table, the row number corresponding to the classification condition to be calculated and the column number corresponding to the engineering quantity to be calculated are combined into a link formula, and the formula is assigned to the cell corresponding to the target engineering quantity in the target engineering quantity list.

6. A BIM-based engineering quantity calculation system, It is characterized in that include: An acquisition module, a matching module and a first calculation module; The acquisition module is used to confirm the name of the component to be calculated in the component engineering quantity table, and the name of the classification condition to be calculated and the name of the engineering quantity to be calculated corresponding to the name of the component to be calculated; wherein the component engineering quantity table is used to record the engineering quantities corresponding to different components; The matching module is used to query the classification conditions to be calculated and the engineering quantities to be calculated corresponding to the classification condition names to be calculated and the engineering quantities to be calculated respectively in the component engineering quantity table through SQL; The first calculation module is used to obtain the target engineering quantity corresponding to the component to be calculated by summarizing and calculating the engineering quantities to be calculated.

7. The BIM-based engineering quantity calculation system according to claim 6, It is characterized in that Also includes: Summary module; The summarizing module includes: a first acquiring unit, a first extracting unit and a summarizing unit; The first acquisition unit is used to acquire a plurality of initial component quantity tables through the BIM model; The first extraction unit is used to traverse the initial component engineering quantity table, extract the initial component name, the initial classification condition name and the initial engineering quantity name as the header of the component engineering quantity table, and remove duplicate items of the initial classification condition name and the initial engineering quantity name; The summarizing unit is used to traverse the initial component engineering quantity table again, fill the component engineering quantity table with data corresponding to the initial component name, the initial classification condition name and the initial engineering quantity name, and obtain the component engineering quantity table.

8. The BIM-based engineering quantity calculation system according to claim 6, It is characterized in that The matching module includes: a screening unit and a query unit; The screening unit is used to screen out the classification condition names to be calculated containing keywords in the component engineering quantity table through SQL to obtain classification condition records to be calculated; wherein the classification condition records to be calculated include a plurality of engineering quantities to be calculated; The query unit is used to query the engineering quantity to be calculated corresponding to the name of the engineering quantity to be calculated in the classification condition record to be calculated through SQL.

9. A BIM-based bill of quantities generation system, It is characterized in that Also includes: A confirmation module, a query module, a second calculation module and an import module; The confirmation module is used to confirm the components in the bill of quantities and the components to be calculated in the component bill of quantities; wherein the components to be calculated correspond to the components; The query module is used to query the engineering quantity records corresponding to the components to be calculated in the component engineering quantity table through SQL, wherein the engineering quantity records include a number of components to be calculated, a number of classification conditions to be calculated, and a number of engineering quantities to be calculated; The second calculation module is used to calculate the target quantity of the component to be calculated in the component quantity table according to the BIM-based quantity calculation method according to any one of claims 1 to 3; The import module is used to import the engineering quantity record and the target engineering quantity into the engineering quantity list to obtain a target engineering quantity list including the component calculation results.

10. The BIM-based bill of quantities generation system according to claim 9, It is characterized in that Also includes: Link module; The link module includes: a third acquisition unit, a fourth acquisition unit and a link unit; The third acquisition unit is used to acquire the name of the initial engineering quantity table corresponding to the component to be calculated; The fourth acquisition unit is used to acquire, in the initial worksheet name, a row number corresponding to the classification condition to be calculated corresponding to the component to be calculated and a column number corresponding to the engineering quantity to be calculated corresponding to the component to be calculated; The link unit is used to combine the name of the initial engineering quantity table, the row number corresponding to the classification condition to be calculated and the column number corresponding to the engineering quantity to be calculated into a link formula, and assign it to the cell corresponding to the target engineering quantity in the target engineering quantity list.

Citation Information

Patent Citations

  • Model engineering quantity statistical method based on BIM technology

    CN113722790A

  • Full-professional amount calculation and pricing system and method based on BIM (Building Information Modeling) technology

    CN114329751A

  • BIM (Building Information Modeling) model-based method and system for quickly creating bill of quantity

    CN114511203A

  • BIM-based engineering quantity calculation method and device, equipment and storage medium

    CN116894288A