A construction construction engineering quantity calculation method, device, equipment and storage medium

Abstract

This invention discloses a method, apparatus, equipment, and storage medium for calculating construction quantities. The method includes: collecting current construction data and constructing a three-dimensional building information model (BIM) based on the current construction data; obtaining quantity calculation rules and determining quantity information based on the BIM using the quantity calculation rules; processing abnormal data in the quantity information to generate quantity data; obtaining bill of quantities matching rules and generating a bill of quantities based on the quantity data using the bill of quantities matching rules; and obtaining database storage rules and storing the bill of quantities using the database storage rules to generate the construction quantities. This method avoids errors in quantity calculation caused by errors in the three-dimensional BIM data, thereby reducing rework frequency, improving construction quality, and increasing the efficiency of construction projects.

Description

Technical Field

[0001] This invention relates to the field of construction engineering technology, specifically to a method, apparatus, equipment, and storage medium for calculating the quantity of construction engineering work. Background Technology

[0002] As engineering construction becomes more complex, traditional engineering quantity calculations are costing more and more manpower and financial resources, and manual calculation of engineering quantities is inefficient.

[0003] Currently, some quantity calculation software exists that can assist in summarizing quantities. However, using a single software is not conducive to comprehensive applications involving multiple disciplines and departments, and it also hinders the maintenance of building information data. Furthermore, in the actual process of quantity calculation, there are still problems in the systematic management of quantities for complex projects, such as anomalies in quantity data, the inability of other disciplines and departments to obtain quantity information in a timely manner, and the inability to share quantity information across the entire project in a timely manner. Summary of the Invention

[0004] Therefore, the technical problem to be solved by the present invention is to overcome the defects of abnormal engineering quantities and the inability to share engineering quantity data in the existing engineering quantity calculation process, thereby providing a method, device, equipment and storage medium for calculating construction engineering quantities.

[0005] This invention provides a method for calculating the quantity of construction work, including:

[0006] Collect current construction data and construct a three-dimensional building information model based on the current construction data;

[0007] Obtain the engineering quantity calculation rules, and determine the engineering quantity information based on the three-dimensional building information model using the engineering quantity calculation rules;

[0008] The project quantity information is processed for abnormal data to generate project quantity data;

[0009] Obtain the bill of quantities matching rules, and generate a bill of quantities based on the quantity data using the bill of quantities matching rules;

[0010] Obtain the database storage rules, and use the database storage rules to store the bill of quantities to generate the construction quantities.

[0011] This invention provides a method for calculating construction quantities. By processing abnormal data in the quantity information, it avoids errors in the calculation of quantities caused by data errors in the three-dimensional building information model, thereby reducing the frequency of rework and improving construction quality. Furthermore, it utilizes database storage rules to store the quantity list, generating construction quantities. The use of database storage rules enables the sharing of quantity data, improving the collaborative capabilities of construction projects and increasing construction efficiency.

[0012] Optionally, the quantity information includes:

[0013] Quota quantities, subbase quantities, and formwork quantities.

[0014] Optionally, the step of performing abnormal data processing on the quantity information to generate quantity data includes:

[0015] The engineering quantity information is standardized to generate project engineering data;

[0016] The project engineering data is deleting outliers to generate the engineering quantity data.

[0017] Optionally, the process of standardizing the quantity information to generate project engineering data is described below; wherein the calculation formula for the project engineering data is as follows:

[0018]

[0019] In the above formula, y i Represents project engineering data, x i This represents the quantity information of project i before standardization, x j This represents the quantity information of project j before standardization, and n represents the total number of projects.

[0020] Optionally, the step of deleting outliers from the project engineering data to generate the engineering quantity data includes:

[0021] The project engineering data is divided to generate a test set of engineering quantity data and a training dataset of engineering quantity samples; wherein, the test set of engineering quantity data has project labels, while the training dataset of engineering quantity samples does not have project labels;

[0022] The Euclidean distance is determined based on the engineering quantity data test set and the engineering quantity sample training dataset.

[0023] The project engineering data is sorted from smallest to largest based on the Euclidean distance, and a preset number of project engineering data are selected based on the sorting results.

[0024] Obtain the project tags corresponding to the preset number of project engineering data, sort the number of project tags, and take the project engineering data corresponding to the project tag with the largest number as the engineering data.

[0025] Optionally, it also includes:

[0026] Obtain the engineering quantity calculation requirements, compare the construction engineering quantity with the engineering quantity calculation requirements, and update the three-dimensional building information model based on the comparison results.

[0027] Optionally, comparing the construction quantities with the calculated quantity requirements and updating the three-dimensional building information model based on the comparison results includes:

[0028] The quantity and size of engineering components in the construction engineering quantity are extracted. The quantity of engineering components is compared with a preset quantity, and the size of engineering components is compared with a preset size. When the error between the quantity of engineering components and the preset quantity does not meet the first preset range, and the error between the size of engineering components and the preset size does not meet the second preset range, the three-dimensional building information model is updated using the construction engineering quantity.

[0029] In a second aspect of this application, a device for calculating the quantity of construction work is also proposed, comprising:

[0030] The construction module is used to collect current construction data and build a three-dimensional building information model based on the current construction data.

[0031] The determination module is used to obtain the engineering quantity calculation rules and determine the engineering quantity information based on the three-dimensional building information model and the engineering quantity calculation rules.

[0032] The processing module is used to process abnormal data in the engineering quantity information and generate engineering quantity data;

[0033] The generation module is used to obtain the bill of quantities matching rules and generate a bill of quantities based on the quantity data and the bill of quantities matching rules.

[0034] The storage module is used to obtain database storage rules, store the bill of quantities using the database storage rules, and generate construction quantities.

[0035] Optionally, the quantity information in the determination module includes: quota quantity, subbase quantity, and formwork quantity.

[0036] Optionally, the processing module includes:

[0037] The standardization processing submodule is used to standardize the engineering quantity information and generate project engineering data;

[0038] The deletion submodule is used to delete outliers from the project engineering data and generate the engineering quantity data.

[0039] Optionally, in the standardization processing submodule, the calculation formula for the project engineering data is as follows:

[0040]

[0041] In the above formula, y i Represents project engineering data, x i This represents the quantity information of project i before standardization, x j This represents the quantity information of project j before standardization, and n represents the total number of projects.

[0042] Optionally, the deletion submodule includes:

[0043] A partitioning unit is used to partition the project engineering data to generate a test set of engineering quantity data and a training dataset of engineering quantity samples; wherein, the test set of engineering quantity data has project labels, and the training dataset of engineering quantity samples does not have project labels;

[0044] A determining unit is used to determine the Euclidean distance based on the engineering quantity data test set and the engineering quantity sample training dataset;

[0045] The sorting unit is used to sort the project engineering data from smallest to largest based on the Euclidean distance, and select a preset number of project engineering data based on the sorting result.

[0046] The selection unit is used to obtain the project tags corresponding to the preset number of project engineering data, sort the number of project tags, and select the project engineering data corresponding to the project tag with the largest number as the engineering data.

[0047] Optionally, it also includes:

[0048] The comparison module is used to obtain the engineering quantity calculation requirements, compare the construction engineering quantity with the engineering quantity calculation requirements, and update the three-dimensional building information model based on the comparison results.

[0049] Optionally, the comparison module is further configured to extract the quantity and size of engineering components in the construction engineering quantity, compare the quantity of engineering components with a preset quantity, and compare the size of engineering components with a preset size. When the error between the quantity of engineering components and the preset quantity does not meet a first preset range, and the error between the size of engineering components and the preset size does not meet a second preset range, the three-dimensional building information model will be updated using the construction engineering quantity.

[0050] In a third aspect of this application, a computer device is also provided, comprising a processor and a memory, wherein the memory is used to store a computer program, the computer program including a program, and the processor is configured to invoke the computer program to perform the method described in the first aspect.

[0051] In a fourth aspect of this application, embodiments of the present invention provide a computer-readable storage medium storing a computer program that is executed by a processor to implement the method of the first aspect described above. Attached Figure Description

[0052] To more clearly illustrate the specific embodiments of the present invention or the technical solutions in the prior art, the drawings used in the description of the specific embodiments or the prior art will be briefly introduced below. Obviously, the drawings described below are some embodiments of the present invention. For those skilled in the art, other drawings can be obtained from these drawings without creative effort.

[0053] Figure 1 This is a flowchart of a method for calculating the quantity of construction work in Embodiment 1 of the present invention;

[0054] Figure 2 This is a flowchart of step S103 in Embodiment 1 of the present invention;

[0055] Figure 3 This is a flowchart of step S1032 in Embodiment 1 of the present invention;

[0056] Figure 4 This is a schematic diagram of the KNN outlier detection and removal algorithm in Embodiment 1 of the present invention;

[0057] Figure 5 This is a schematic diagram of a construction quantity calculation device according to Embodiment 2 of the present invention;

[0058] Figure 6 This is a schematic diagram of a specific example of the processing module 53 in Embodiment 2 of the present invention;

[0059] Figure 7This is a block diagram illustrating the principle of deleting submodule 532 in Embodiment 2 of the present invention. Detailed Implementation

[0060] The technical solution of the present invention will now be clearly and completely described with reference to the accompanying drawings. Obviously, the described embodiments are only some, not all, of the 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 are within the scope of protection of the present invention.

[0061] In the description of this invention, it should be noted that the terms "center," "upper," "lower," "left," "right," "vertical," "horizontal," "inner," and "outer," etc., indicate the orientation or positional relationship based on the orientation or positional relationship shown in the accompanying drawings. They are used only for the convenience of describing the invention and for simplifying the description, and do not indicate or imply that the device or element referred to must have a specific orientation, or be constructed and operated in a specific orientation. Therefore, they should not be construed as limitations on the invention. Furthermore, the terms "first," "second," and "third" are used for descriptive purposes only and should not be construed as indicating or implying relative importance.

[0062] Furthermore, the technical features involved in the different embodiments of the present invention described below can be combined with each other as long as they do not conflict with each other.

[0063] Example 1

[0064] This embodiment provides a method for calculating the quantity of construction work, such as... Figure 1 As shown, it includes:

[0065] S101. Collect current construction data and construct a three-dimensional building information model based on the current construction data.

[0066] Specifically, before constructing a 3D Building Information Model (BIM), corresponding creation rules must be pre-defined: First, the object relationships between the architectural, structural, and mechanical / electrical models of the current construction project need to be determined. This is done with model integrity as a prerequisite, minimizing the creation of overlapping models between the architectural and structural domains to improve the accuracy of quantities. Second, during model construction, the overlapping relationships between different models need to be considered; for example, floor slabs cannot penetrate wall structures. This ensures that the parameters presented in the model are more reasonable, facilitating subsequent quantity surveying. This standard can be achieved through the BIM (Building Information Modeling) platform within TGPMS (Three Gorges Project Management System, a globally leading project management information platform tailored to China's national conditions, possessing powerful functions beneficial to project management, such as file export, project data preprocessing, project calculation, and database functions, with excellent interfaces between different functions, enabling multi-functional and multi-platform joint applications). In the application of Building Information Modeling (BIM) 3D visualization, the rationality of the model is checked by pre-defined rules and manual assistance. By creating a BIM model, on the one hand, engineering quantity data can be extracted quickly, and on the other hand, engineering components can be created by accessing the 3D and quantity key BIM information from the subsequent database to check whether the extraction of engineering quantity information is accurate and reasonable, thereby improving the efficiency of engineering quantity information verification.

[0067] S102. Obtain the engineering quantity calculation rules. Based on the three-dimensional building information model, use the engineering quantity calculation rules to determine the engineering quantity information (including quota engineering quantity, subbase engineering quantity and formwork engineering quantity).

[0068] There are three types of engineering quantity calculation rules, which can respectively obtain the quota engineering quantity, the subbase engineering quantity, and the formwork engineering quantity data. The quota engineering quantity is the engineering quantity data obtained according to the pre-defined engineering quantity calculation rules; the subbase engineering quantity refers to the engineering quantity of the structural layer below the base layer in the building; and the formwork engineering quantity refers to the engineering quantity of the structural system composed of concrete and supporting formwork.

[0069] Furthermore, the TGPMS platform can be used to obtain quantity information from the 3D building information model using different rules for different quantities of work. The TGPMS platform embeds Revit (a series of software built for building information models, which can help architects design, build and maintain buildings with better quality and higher energy efficiency) and Glodon applications. Under the control of the TGPMS platform, quantity data in the 3D building information model can be extracted according to three rules. In the quantity calculation submodule of the TGPMS platform, the advantages of Revit and Glodon applications in statistical analysis of different quantities of work are fully utilized. This embedded approach accelerates the efficiency and accuracy of quantity information extraction.

[0070] S103. Perform abnormal data processing on the engineering quantity information to generate engineering quantity data.

[0071] Specifically, the construction of a 3D building information model is based on the visualization of the current construction data (i.e., building information feature parameters). Inevitably, some unreasonable settings will be generated in the input parameters, such as an abnormal input of a certain parameter. However, the computer will not detect the abnormality of this part. Therefore, it is unreasonable to directly use the engineering quantity data exported from such models for subsequent engineering quantity calculations. Therefore, abnormal data processing is required. This can be achieved by secondary development of Revit software and writing code in C#.

[0072] S104. Obtain the bill of quantities matching rules, and generate a bill of quantities based on the quantity data using the bill of quantities matching rules.

[0073] Specifically, the bill of quantities can be exported using the export plugin in the TGPMS platform. The exported file format is Excel, containing two worksheets: the bill of quantities quota location and the bill of quantities quota component calculation sheet. The matching rules for the bill of quantities quota location and the bill of quantities quota component calculation sheet can be set in advance. The former is used to statistically analyze the model-based quantity data, while the latter is used to present the correspondence and quantity relationship between the engineering model components and subsequent models. The bill of quantities quota location calculation sheet can represent the content of the bill of quantities, and the data information in the bill of quantities quota component calculation sheet can be used for the 3D visualization of engineering components, achieving the unification of data information and 3D graphics.

[0074] S105. Obtain the database storage rules, and use the database storage rules to store the bill of quantities to generate the construction quantities.

[0075] Specifically, the engineering quantity data exported from the TGPMS platform is stored in the corresponding database. The database mainly consists of two parts: the method summary analysis (also known as the engineering part summary analysis) and the construction summary analysis. The database storage rules corresponding to the method summary analysis and the construction summary analysis generate the construction engineering quantities. Within the database, managers and construction personnel from different professions and departments can log in to the TGPMS platform and enter the corresponding database to query and use the engineering quantities, realizing the real-time sharing of engineering quantity information across departments and improving construction efficiency and quality.

[0076] Furthermore, the TGPMS database not only enables real-time cross-departmental sharing of quantity information, but also facilitates efficient maintenance of this information. When construction workers and quantity correction personnel discover abnormal calculation values ​​after verifying the quantity information, they need to modify the quantity summary table. Given that construction plans may change according to actual conditions, the corresponding quantity information will also change. If this changed information is not updated in a timely manner, it will lead to inaccuracies in subsequent construction plans and budgets. The TGPMS database provides a quantity information maintenance function, allowing the corrected quantity information obtained from the calculation module to be imported into the database module via the export module, thus achieving real-time updates and maintenance of the information.

[0077] Furthermore, the database can also realize the three-dimensional visualization function of engineering component information: after the key parameters (three-dimensional and quantity information) in the component information of the database are transferred to the BIM model for visualization, the corresponding three-dimensional model of the engineering construction is drawn. The accuracy and rationality of the engineering quantity information can be detected from the three-dimensional graphics. At the same time, the parameters can be changed in the three-dimensional model to form a new engineering model, thereby generating new engineering quantity information.

[0078] The aforementioned method for calculating construction quantities avoids errors in quantity calculations caused by data errors in the 3D building information model by processing abnormal data in the quantity information, thereby reducing rework frequency and improving construction quality. Furthermore, it utilizes database storage rules to store the quantity list, generating construction quantities and enabling data sharing, thus improving project collaboration and efficiency. Finally, from the perspective of more efficient, accurate, and convenient collaborative quantity calculation between engineering and commercial calculations, the excellent platform compatibility and powerful integration functions of TGPMS enhance the diversity, comprehensiveness, synchronous coordination, and intelligence of the 3D building information model.

[0079] Preferably, such as Figure 2 As shown, step S103 involves abnormal data processing of the quantity information to generate quantity data, including:

[0080] S1031. Standardize the engineering quantity information to generate project engineering data.

[0081] Specifically, the maximum-minimum algorithm is used to standardize the engineering quantity information to unify the units of measurement, reduce the computational workload, and facilitate subsequent outlier detection. The calculation formula for the project engineering data is as follows:

[0082]

[0083] In the above formula, y i This represents project engineering data (i.e., standardized engineering quantity information), x i This represents the quantity information of project i before standardization, x j This represents the quantity information of project j before standardization, and n represents the total number of projects.

[0084] For example, partial engineering quantity information is selected. Table 1 shows partial engineering quantity information before and after standardization.

[0085] Table 1

[0086]

[0087] S1032. Delete outliers from the project engineering data to generate the engineering quantity data.

[0088] Specifically, the KNN (K-Nearest Neighbor) clustering algorithm is used for outlier detection and removal. KNN clustering can effectively filter out outliers within similar datasets, thus effectively detecting abnormal outliers. KNN is a non-parametric statistical method used for classification and regression. It is suitable for processing both numerical and nominal data samples and has advantages such as high accuracy and no data input assumptions. It demonstrates excellent performance in detecting and removing outliers from engineering quantity data.

[0089] For example, the engineering quantity data generated after deleting outliers is shown in Table 2.

[0090] Table 2

[0091] Serial Number project unit Engineering quantity data 1 Excavation <![CDATA[100m 3 (cubic meters) 51.341 2 Leveling the site <![CDATA[100m 2 (square meters) 124.62 3 Excavation <![CDATA[100m 3 ]]> 62.512 4 Excavation <![CDATA[100m 3 ]]> 78.624 5 Pipe trench earthwork m (meter) 52.799 6 Pipe trench earthwork m 42.799 7 Excavation of foundation earthwork <![CDATA[100m 3 ]]> 26.2 8 trench earthwork m 72.542 9 trench earthwork m 62.799 10 Pipe trench earthwork m 50.432 11 Excavation of foundation earthwork <![CDATA[100m 3 ]]> 16.34 12 Excavation of foundation earthwork <![CDATA[100m 3 ]]> 19.24 13 Excavation of foundation earthwork <![CDATA[100m 3 ]]> 25.41 14 Excavation of foundation earthwork <![CDATA[100m 3 ]]> 30.52 15 Leveling the site <![CDATA[100m 2 ]]> 134.48 16 Leveling the site <![CDATA[100m 2 ]]> 158.19 17 Leveling the site <![CDATA[100m 2 ]]> 122.512 18 Leveling the site <![CDATA[100m 2 ]]> 16.2 19 Excavation <![CDATA[100m 3 ]]> 88.58 20 Excavation <![CDATA[100m 3 ]]> 64.756

[0092] After the above-mentioned standardization of the quantity information, the KNN clustering algorithm is used to detect and remove outlier quantities. This can greatly reduce the errors in quantity calculation caused by incorrect construction models, thereby reducing rework frequency and improving construction quality.

[0093] Preferably, such as Figure 3 As shown, step S1032 involves deleting outliers from the project engineering data to generate the engineering quantity data, including:

[0094] S10321. Divide the project engineering data to generate an engineering quantity data test set and an engineering quantity sample training dataset; wherein, the engineering quantity data test set has project labels, and the engineering quantity sample training dataset does not have project labels.

[0095] S10322. Determine the Euclidean distance based on the engineering quantity data test set and the engineering quantity sample training dataset.

[0096] Specifically, the n-dimensional sample set of engineering quantity data (x1, x2, ..., x3) in the engineering quantity sample training dataset. ... x n ) and the n-dimensional test set of engineering quantity data (y1, y2, ) and the engineering quantity data in the engineering quantity data test set. ... y n The Euclidean distance D(x,y) between them is:

[0097]

[0098] Where 1≤i≤n.

[0099] S10323. Sort the project engineering data from smallest to largest based on the Euclidean distance, and select a preset number of project engineering data based on the sorting results.

[0100] Specifically, all the calculated Euclidean distances are sorted in ascending order, with smaller Euclidean distances indicating greater similarity.

[0101] S10324. Obtain the project tags corresponding to the preset number of project engineering data, sort the number of project tags, and take the project engineering data corresponding to the project tag with the largest number as the engineering data.

[0102] Specifically, such as Figure 4 As shown, the project labels corresponding to the first L (generally less than or equal to 20) engineering project sample data are selected, and the classification label that appears most frequently is used as the classification of the engineering data. By comparing the classification results of the KNN algorithm, the detection and removal of outliers are realized.

[0103] Preferably, it further includes:

[0104] S106. Obtain the engineering quantity calculation requirements, compare the construction engineering quantity with the engineering quantity calculation requirements, and update the three-dimensional building information model based on the comparison results.

[0105] Specifically, the quantity and size of engineering components in the construction engineering quantity are extracted, the quantity of engineering components is compared with a preset quantity, and the size of engineering components is compared with a preset size. When the error between the quantity of engineering components and the preset quantity does not meet the first preset range, and the error between the size of engineering components and the preset size does not meet the second preset range (e.g., within 5%), the three-dimensional building information model will be updated using the construction engineering quantity.

[0106] Furthermore, it is determined whether the requirements for calculating the quantity of work (current construction) are met. If they are met, the 3D building information model is visualized; if not, the 3D building information model is updated using the construction quantity.

[0107] Example 2

[0108] This embodiment provides a device for calculating the quantity of construction work, such as... Figure 5 As shown, it includes:

[0109] The construction module 51 is used to collect current construction data and construct a three-dimensional building information model based on the current construction data.

[0110] Specifically, before constructing a 3D Building Information Model (BIM), corresponding creation rules must be pre-defined: First, the object relationships between the architectural, structural, and mechanical / electrical models of the current construction project need to be determined. This is done with model integrity as a prerequisite, minimizing the creation of overlapping models between the architectural and structural domains to improve the accuracy of quantities. Second, during model construction, the overlapping relationships between different models need to be considered; for example, floor slabs cannot penetrate wall structures. This ensures that the parameters presented in the model are more reasonable, facilitating subsequent quantity surveying. This standard can be achieved through the BIM (Building Information Modeling) platform within TGPMS (Three Gorges Project Management System, a globally leading project management information platform tailored to China's national conditions, possessing powerful functions beneficial to project management, such as file export, project data preprocessing, project calculation, and database functions, with excellent interfaces between different functions, enabling multi-functional and multi-platform joint applications). In the application of Building Information Modeling (BIM) 3D visualization, the rationality of the model is checked by pre-defined rules and manual assistance. By creating a BIM model, on the one hand, engineering quantity data can be extracted quickly, and on the other hand, engineering components can be created by accessing the 3D and quantity key BIM information from the subsequent database to check whether the extraction of engineering quantity information is accurate and reasonable, thereby improving the efficiency of engineering quantity information verification.

[0111] The determination module 52 is used to obtain the engineering quantity calculation rules and, based on the three-dimensional building information model, determine the engineering quantity information (including quota engineering quantity, subbase engineering quantity and formwork engineering quantity) using the engineering quantity calculation rules.

[0112] There are three types of engineering quantity calculation rules, which can respectively obtain the quota engineering quantity, the subbase engineering quantity, and the formwork engineering quantity data. The quota engineering quantity is the engineering quantity data obtained according to the pre-defined engineering quantity calculation rules; the subbase engineering quantity refers to the engineering quantity of the structural layer below the base layer in the building; and the formwork engineering quantity refers to the engineering quantity of the structural system composed of concrete and supporting formwork.

[0113] Furthermore, the TGPMS platform can be used to obtain quantity information from the 3D building information model using different rules for different quantities of work. The TGPMS platform embeds Revit (a series of software built for building information models, which can help architects design, build and maintain buildings with better quality and higher energy efficiency) and Glodon applications. Under the control of the TGPMS platform, quantity data in the 3D building information model can be extracted according to three rules. In the quantity calculation submodule of the TGPMS platform, the advantages of Revit and Glodon applications in statistical analysis of different quantities of work are fully utilized. This embedded approach accelerates the efficiency and accuracy of quantity information extraction.

[0114] The processing module 53 is used to process the abnormal data of the engineering quantity information and generate engineering quantity data.

[0115] Specifically, the construction of a 3D building information model is based on the visualization of the current construction data (i.e., building information feature parameters). Inevitably, some unreasonable settings will be generated in the input parameters, such as an abnormal input of a certain parameter. However, the computer will not detect the abnormality of this part. Therefore, it is unreasonable to directly use the engineering quantity data exported from such models for subsequent engineering quantity calculations. Therefore, abnormal data processing is required. This can be achieved by secondary development of Revit software and writing code in C#.

[0116] The generation module 54 is used to obtain the bill of quantities matching rules and generate a bill of quantities based on the quantity data using the bill of quantities matching rules.

[0117] Specifically, the bill of quantities can be exported using the export plugin in the TGPMS platform. The exported file format is Excel, containing two worksheets: the bill of quantities quota location and the bill of quantities quota component calculation sheet. The matching rules for the bill of quantities quota location and the bill of quantities quota component calculation sheet can be set in advance. The former is used to statistically analyze the model-based quantity data, while the latter is used to present the correspondence and quantity relationship between the engineering model components and subsequent models. The bill of quantities quota location calculation sheet can represent the content of the bill of quantities, and the data information in the bill of quantities quota component calculation sheet can be used for the 3D visualization of engineering components, achieving the unification of data information and 3D graphics.

[0118] Storage module 55 is used to obtain database storage rules, store the bill of quantities using the database storage rules, and generate construction quantities.

[0119] Specifically, the engineering quantity data exported from the TGPMS platform is stored in the corresponding database. The database mainly consists of two parts: the method summary analysis (also known as the engineering part summary analysis) and the construction summary analysis. The database storage rules corresponding to the method summary analysis and the construction summary analysis generate the construction engineering quantities. Within the database, managers and construction personnel from different professions and departments can log in to the TGPMS platform and enter the corresponding database to query and use the engineering quantities, realizing the real-time sharing of engineering quantity information across departments and improving construction efficiency and quality.

[0120] Furthermore, the TGPMS database not only enables real-time cross-departmental sharing of quantity information, but also facilitates efficient maintenance of this information. When construction workers and quantity correction personnel discover abnormal calculation values ​​after verifying the quantity information, they need to modify the quantity summary table. Given that construction plans may change according to actual conditions, the corresponding quantity information will also change. If this changed information is not updated in a timely manner, it will lead to inaccuracies in subsequent construction plans and budgets. The TGPMS database provides a quantity information maintenance function, allowing the corrected quantity information obtained from the calculation module to be imported into the database module via the export module, thus achieving real-time updates and maintenance of the information.

[0121] Furthermore, the database can also realize the three-dimensional visualization function of engineering component information: after the key parameters (three-dimensional and quantity information) in the component information of the database are transferred to the BIM model for visualization, the corresponding three-dimensional model of the engineering construction is drawn. The accuracy and rationality of the engineering quantity information can be detected from the three-dimensional graphics. At the same time, the parameters can be changed in the three-dimensional model to form a new engineering model, thereby generating new engineering quantity information.

[0122] The aforementioned construction quantity calculation device avoids errors in quantity calculation caused by data errors in the three-dimensional building information model by processing abnormal data of the quantity information, thereby reducing the frequency of rework and improving construction quality. Furthermore, it uses database storage rules to store the quantity list, generating construction quantities. The use of database storage rules enables the sharing of quantity data, improving the collaborative ability of construction projects and increasing the efficiency of construction projects.

[0123] Preferably, such as Figure 6 As shown, the above-mentioned processing module 53 includes:

[0124] The standardization processing submodule 531 is used to standardize the engineering quantity information and generate project engineering data.

[0125] Specifically, the maximum-minimum algorithm is used to standardize the engineering quantity information to unify the units of measurement, reduce the computational workload, and facilitate subsequent outlier detection. The calculation formula for the project engineering data is as follows:

[0126]

[0127] In the above formula, y i This represents project engineering data (i.e., standardized engineering quantity information), x i This represents the quantity information of project i before standardization, x j This represents the quantity information of project j before standardization, and n represents the total number of projects.

[0128] The deletion submodule 532 is used to delete outliers from the project engineering data and generate the engineering quantity data.

[0129] Specifically, the KNN (K-Nearest Neighbor) clustering algorithm is used for outlier detection and removal. KNN clustering can effectively filter out outliers within similar datasets, thus effectively detecting abnormal outliers. KNN is a non-parametric statistical method used for classification and regression. It is suitable for processing both numerical and nominal data samples and has advantages such as high accuracy and no data input assumptions. It demonstrates excellent performance in detecting and removing outliers from engineering quantity data.

[0130] Preferably, such as Figure 7 As shown, the above-mentioned deletion submodule 532 includes:

[0131] The partitioning unit 5321 is used to partition the project engineering data to generate a test set of engineering quantity data and a training dataset of engineering quantity samples; wherein, the test set of engineering quantity data has project labels, and the training dataset of engineering quantity samples does not have project labels.

[0132] The determining unit 5322 is used to determine the Euclidean distance based on the engineering quantity data test set and the engineering quantity sample training dataset.

[0133] Specifically, the n-dimensional sample set of engineering quantity data (x1, x2, ..., x3) in the engineering quantity sample training dataset. ... x n ) and the n-dimensional test set of engineering quantity data (y1, y2, ) and the engineering quantity data in the engineering quantity data test set. ... y n The Euclidean distance D(x,y) between them is:

[0134]

[0135] Where 1≤i≤n.

[0136] The sorting unit 5323 is used to sort the project engineering data from smallest to largest based on the Euclidean distance, and select a preset number of project engineering data based on the sorting result.

[0137] Specifically, all the calculated Euclidean distances are sorted in ascending order, with smaller Euclidean distances indicating greater similarity.

[0138] The selection unit 5324 is used to obtain the project tags corresponding to the preset number of project engineering data, sort the number of project tags, and select the project engineering data corresponding to the project tag with the largest number as the engineering data.

[0139] Specifically, the project labels corresponding to the top L (generally less than or equal to 20) engineering project sample data are selected, and the classification label that appears most frequently is used as the classification of the engineering data. By comparing the classification results of the KNN algorithm, the detection and removal of outliers are realized.

[0140] Preferably, it further includes:

[0141] The comparison module 56 is used to obtain the engineering quantity calculation requirements, compare the construction engineering quantity with the engineering quantity calculation requirements, and update the three-dimensional building information model based on the comparison results.

[0142] Specifically, the quantity and size of engineering components in the construction engineering quantity are extracted, the quantity of engineering components is compared with a preset quantity, and the size of engineering components is compared with a preset size. When the error between the quantity of engineering components and the preset quantity does not meet the first preset range, and the error between the size of engineering components and the preset size does not meet the second preset range (e.g., within 5%), the three-dimensional building information model will be updated using the construction engineering quantity.

[0143] Furthermore, it is determined whether the requirements for calculating the quantity of work (current construction) are met. If they are met, the 3D building information model is visualized; if not, the 3D building information model is updated using the construction quantity.

[0144] Example 3

[0145] This embodiment provides a computer device, including a memory and a processor. The processor is used to read instructions stored in the memory to execute a method for calculating construction quantities in any of the above method embodiments.

[0146] Those skilled in the art will understand that embodiments of the present invention can be provided as methods, systems, or computer program products. Therefore, the present invention can take the form of a completely hardware embodiment, a completely software embodiment, or an embodiment combining software and hardware aspects. Furthermore, the present invention can take the form of a computer program product embodied on one or more computer-usable storage media (including, but not limited to, disk storage, CD-ROM, optical storage, etc.) containing computer-usable program code.

[0147] This invention is described with reference to flowchart illustrations and / or block diagrams of methods, apparatus (systems), and computer program products according to embodiments of the invention. It will be understood that each block of the flowchart illustrations and / or block diagrams, and combinations of blocks in the flowchart illustrations and / or block diagrams, can be implemented by computer program instructions. These computer program instructions can be provided to a processor of a general-purpose computer, special-purpose computer, embedded processor, or other programmable data processing apparatus to produce a machine, such that the instructions, which execute via the processor of the computer or other programmable data processing apparatus, generate instructions for implementing the flowchart illustrations and / or block diagrams. Figure 1 One or more processes and / or boxes Figure 1 A device that provides the functions specified in one or more boxes.

[0148] These computer program instructions may also be stored in a computer-readable storage medium that can direct a computer or other programmable data processing device to function in a particular manner, such that the instructions stored in the computer-readable storage medium produce an article of manufacture including instruction means, which are implemented in a process Figure 1 One or more processes and / or boxes Figure 1 The function specified in one or more boxes.

[0149] These computer program instructions may also be loaded onto a computer or other programmable data processing equipment to cause a series of operational steps to be performed on the computer or other programmable equipment to produce a computer-implemented process, thereby providing instructions that execute on the computer or other programmable equipment for implementing the process. Figure 1 One or more processes and / or boxes Figure 1 The steps of the function specified in one or more boxes.

[0150] Example 4

[0151] This embodiment provides a computer-readable storage medium storing computer-executable instructions that can execute a method for calculating construction quantities in any of the above-described method embodiments. The storage medium may be a magnetic disk, optical disk, read-only memory (ROM), random access memory (RAM), flash memory, hard disk drive (HDD), or solid-state drive (SSD), etc.; the storage medium may also include combinations of the above types of memory.

[0152] Obviously, the above embodiments are merely illustrative examples for clear explanation and are not intended to limit the implementation. Those skilled in the art will recognize that other variations or modifications can be made based on the above description. It is neither necessary nor possible to exhaustively list all possible implementations here. However, obvious variations or modifications derived therefrom are still within the scope of protection of this invention.

Claims

1. A method for calculating the quantity of construction work, characterized in that, include: Collect current construction data and construct a three-dimensional building information model based on the current construction data; Obtain the engineering quantity calculation rules, and determine the engineering quantity information based on the three-dimensional building information model using the engineering quantity calculation rules; The project quantity information is processed for abnormal data to generate project quantity data; Obtain the bill of quantities matching rules, and generate a bill of quantities based on the quantity data using the matching rules. The bill of quantities is exported using an export plugin in the TGPMS platform. The exported file is an Excel file containing two worksheets: a bill of quantities quota section and a bill of quantities quota component calculation sheet. The bill of quantities quota section and the bill of quantities quota component calculation sheet have pre-set matching rules. The bill of quantities quota section is used to statistically analyze model-based quantity data, while the bill of quantities quota component calculation sheet presents the correspondence and quantity relationships between the engineering model components and subsequent models. The bill of quantities quota section calculation sheet represents the content of the bill of quantities, and the data information in the bill of quantities quota component calculation sheet is used for the 3D visualization of engineering components, achieving a unity between data information and 3D graphics. The system obtains database storage rules and uses these rules to store the bill of quantities, generating construction quantities. The quantity data exported from the TGPMS platform is stored in the corresponding database, which consists of two main parts: a method summary analysis and a construction summary analysis. The database storage rules corresponding to the method summary analysis and construction summary analysis generate the construction quantities. Within the database, managers and construction personnel from different specialties and departments can log into the TGPMS platform and access the corresponding database to query and use the quantities.

2. The method for calculating the quantity of construction work according to claim 1, characterized in that, The quantity information includes: Quota quantities, subbase quantities, and formwork quantities.

3. The method for calculating the quantity of construction work according to claim 1, characterized in that, The process of processing abnormal data in the quantity information to generate quantity data includes: The engineering quantity information is standardized to generate project engineering data; The project engineering data is deleting outliers to generate the engineering quantity data.

4. The method for calculating the quantity of construction work according to claim 3, characterized in that, The process of standardizing the quantity information generates project engineering data; wherein the calculation formula for the project engineering data is as follows: In the above formula, Represents project engineering data. Indicates engineering project Engineering quantity information before standardization processing Indicates engineering project Engineering quantity information before standardization processing This indicates the total number of engineering projects.

5. The method for calculating the quantity of construction work according to claim 3, characterized in that, The process of deleting outliers from the project engineering data to generate the engineering quantity data includes: The project engineering data is divided to generate a test set of engineering quantity data and a training dataset of engineering quantity samples; wherein, the test set of engineering quantity data has project labels, while the training dataset of engineering quantity samples does not have project labels; The Euclidean distance is determined based on the engineering quantity data test set and the engineering quantity sample training dataset. The project engineering data is sorted from smallest to largest based on the Euclidean distance, and a preset number of project engineering data are selected based on the sorting results. Obtain the project tags corresponding to the preset number of project engineering data, sort the number of project tags, and take the project engineering data corresponding to the project tag with the largest number as the engineering data.

6. The method for calculating the quantity of construction work according to claim 1, characterized in that, Also includes: Obtain the engineering quantity calculation requirements, compare the construction engineering quantity with the engineering quantity calculation requirements, and update the three-dimensional building information model based on the comparison results.

7. The method for calculating the quantity of construction work according to claim 6, characterized in that, The step of comparing the construction quantity with the calculated quantity requirement, and updating the three-dimensional building information model based on the comparison result, includes: The quantity and size of engineering components in the construction engineering quantity are extracted. The quantity of engineering components is compared with a preset quantity, and the size of engineering components is compared with a preset size. When the error between the quantity of engineering components and the preset quantity does not meet the first preset range, and the error between the size of engineering components and the preset size does not meet the second preset range, the three-dimensional building information model is updated using the construction engineering quantity.

8. A device for calculating the quantity of construction work, characterized in that, include: The construction module is used to collect current construction data and build a three-dimensional building information model based on the current construction data. The determination module is used to obtain the engineering quantity calculation rules and determine the engineering quantity information based on the three-dimensional building information model and the engineering quantity calculation rules. The processing module is used to process abnormal data in the engineering quantity information and generate engineering quantity data; The generation module is used to obtain the bill of quantities matching rules and generate a bill of quantities based on the quantity data using the matching rules. Specifically, the bill of quantities is exported using an export plugin in the TGPMS platform. The exported file is an Excel file containing two worksheets: a bill of quantities quota section and a bill of quantities quota component calculation sheet. The bill of quantities quota section and the bill of quantities quota component calculation sheet have pre-set matching rules. The bill of quantities quota section is used to statistically analyze model-based quantity data, while the bill of quantities quota component calculation sheet presents the correspondence and quantity relationships between the engineering model components and subsequent models. The bill of quantities quota section calculation sheet represents the content of the bill of quantities, and the data information in the bill of quantities quota component calculation sheet is used for the 3D visualization of engineering components, achieving a unity between data information and 3D graphics. The storage module is used to obtain database storage rules and store the bill of quantities using these rules to generate construction quantities. The quantity data exported from the TGPMS platform is stored in the corresponding database, which mainly consists of two parts: a method summary analysis and a construction summary analysis. The database storage rules corresponding to the method summary analysis and construction summary analysis generate the construction quantities. Within the database, managers and construction personnel from different specialties and departments can log into the TGPMS platform and access the corresponding database to query and use the quantities.

9. A computer device, characterized in that, It includes a processor and a memory, wherein the memory is used to store a computer program, and the processor is configured to invoke the computer program to perform the steps of the method as described in any one of claims 1-7.

10. A computer-readable storage medium storing computer instructions thereon, characterized in that, When the computer instructions are executed by the processor, they implement the steps of the method as described in any one of claims 1-7.

Images