Automatic amount calculation method and system for construction work amount

Abstract

The invention discloses an automatic amount calculation method and system for construction work amount. The method comprises the following steps: acquiring primitives under different component types; adjusting the volumes of the primitives under different component types to obtain adjusted primitive volumes; summarizing and summing the volumes of the primitives of the same floor, the same component type and the same concrete grade; and setting the summarized data into a table, and carrying out statistics on the table to obtain a data result after statistics. According to the method, the work amount of the main body component according to the floors can be quickly and accurately generated, and effective reference and assistance are provided for construction decision making.

Description

Technical Field

[0001] The present invention relates to the field of construction quantity calculation, and in particular to an automatic quantity calculation method and system for construction engineering quantities. Background Art

[0002] The calculation of construction quantities directly affects the arrangement of construction progress and the rational allocation of resources. Accurate and rapid calculation of construction quantities helps to ensure the scientific nature of project decisions and improve the social benefits of the project. By calculating the construction quantities, we can ensure the rational allocation of resources and effectively avoid waste of resources.

[0003] At present, the calculation of construction project quantities is mainly carried out using BIM modeling software, such as Revit. Although Revit can extract project quantities through detailed lists, it can only perform separate statistics on each component type, and parameter information needs to be set each time it is counted. There is a lot of repetitive work and low efficiency, and it is impossible to provide the summary of the main component quantities of each floor required by the construction site.

[0004] Therefore, in order to solve the above problems, an automatic calculation method and system for construction project quantities is needed, which can quickly and accurately generate the project quantities of main components by floor, providing effective reference and assistance for construction decision-making. Summary of the invention

[0005] In view of this, the purpose of the present invention is to overcome the defects in the prior art and provide an automatic calculation method and system for construction project quantities, which can quickly and accurately generate the project quantities of main components by floor, providing effective reference and assistance for construction decision-making.

[0006] The automatic calculation method of construction engineering quantity of the present invention comprises:

[0007] Get the graphics elements under different component types;

[0008] Adjust the volume of the primitives under different component types to obtain the adjusted volume of the primitives;

[0009] Sum up the volumes of elements on the same floor, component type, and concrete grade;

[0010] Set the summarized data into a table, perform statistics on the table, and obtain the statistical data results.

[0011] Furthermore, the volume of the elements under different component types is adjusted, including:

[0012] Set the deduction priority, the deduction priority from high to low is: structural foundation, structural column, wall, structural frame and floor;

[0013] Two connected primitives are regarded as adjacent primitives, and the volume of the overlapping parts of the adjacent primitives is regarded as the target volume;

[0014] A corresponding primitive with a lower subtraction priority among adjacent primitives is taken as a target primitive, and a volume obtained by subtracting the target volume from the volume of the target primitive is taken as an adjusted volume of the target primitive; wherein the volume of a corresponding primitive with a higher subtraction priority among adjacent primitives remains unchanged.

[0015] Further, statistics are performed on the table, including:

[0016] Taking the floor elevation as the target column, obtaining the first data results corresponding to different floor elevations;

[0017] Using the component type in the first data result as the target column, obtaining the second data results corresponding to different component types at different floor elevations;

[0018] The concrete grade in the second data result is used as the target column to obtain the third data result corresponding to different concrete grades under different component types at different floor elevations;

[0019] The first data result, the second data result and the third data result all include the statistically analyzed primitive volumes.

[0020] Furthermore, for a special-shaped component without a component type, the floor elevation and volume of the special-shaped component are obtained according to the following method:

[0021] The special-shaped components are created by using the built-in model function of Revit, and exist in the model in the form of special-shaped blocks, and the floor elevation and volume information are obtained through geometric figures.

[0022] Furthermore, the component types include structural foundations, structural columns, walls, structural frames and floor slabs.

[0023] An automatic construction engineering quantity calculation system includes a graphic element acquisition module, a volume adjustment module and a volume calculation module;

[0024] The graphic element acquisition module is used to acquire graphic elements of different component types;

[0025] The volume adjustment module is used to adjust the volume of the primitives under different component types to obtain the adjusted primitive volumes;

[0026] The volume calculation module is used to summarize and sum the volumes of the graphics elements of the same floor, the same component type and the same concrete grade; set the summarized data in a table, perform statistics on the table, and obtain the statistical data results.

[0027] Furthermore, the volume of the elements under different component types is adjusted, including:

[0028] Set the deduction priority, the deduction priority from high to low is: structural foundation, structural column, wall, structural frame and floor;

[0029] Two connected primitives are regarded as adjacent primitives, and the volume of the overlapping parts of the adjacent primitives is regarded as the target volume;

[0030] A corresponding primitive with a lower subtraction priority among adjacent primitives is taken as a target primitive, and a volume obtained by subtracting the target volume from the volume of the target primitive is taken as an adjusted volume of the target primitive; wherein the volume of a corresponding primitive with a higher subtraction priority among adjacent primitives remains unchanged.

[0031] Further, statistics are performed on the table, including:

[0032] Taking the floor elevation as the target column, obtaining the first data results corresponding to different floor elevations;

[0033] Using the component type in the first data result as the target column, obtaining the second data results corresponding to different component types at different floor elevations;

[0034] The concrete grade in the second data result is used as the target column to obtain the third data result corresponding to different concrete grades under different component types at different floor elevations;

[0035] The first data result, the second data result and the third data result all include the statistically analyzed primitive volumes.

[0036] Furthermore, for a special-shaped component without a component type, the floor elevation and volume of the special-shaped component are obtained according to the following method:

[0037] The special-shaped components are created by using the built-in model function of Revit, and exist in the model in the form of special-shaped blocks, and the floor elevation and volume information are obtained through geometric figures.

[0038] Furthermore, the component types include structural foundations, structural columns, walls, structural frames and floor slabs.

[0039] The beneficial effects of the present invention are as follows: the automatic calculation method and system of construction engineering quantity disclosed by the present invention can count the engineering quantities of different types of components in batches at one time, avoiding the repetitive work of setting the same parameters separately when counting each component. The component engineering quantity table formed by summarizing the floors is more valuable for construction site guidance and can assist in guiding on-site material and manpower management. When the preset construction plan is changed, the changes in engineering quantities can be compared horizontally through the present invention, providing a reliable basis for decision-making during the change. BRIEF DESCRIPTION OF THE DRAWINGS

[0040] The present invention will be further described below in conjunction with the accompanying drawings and embodiments:

[0041] Figure 1 It is a flow chart of the method for calculating the quantity of the present invention;

[0042] Figure 2 It is a parameter schematic diagram of the built-in structural column model of the present invention without conventional columns;

[0043] Figure 3 It is a schematic diagram of a graphic element structure with a connection relationship of the present invention;

[0044] Figure 4 A schematic diagram of the data results of the floor elevation list of the present invention;

[0045] Figure 5 A schematic diagram of data results of a component type list of the present invention;

[0046] Figure 6 A schematic diagram of the data results of the concrete grade list of the present invention;

[0047] Figure 7 A schematic diagram of sorting data for the Revit model of the present invention;

[0048] Figure 8 It is a schematic diagram of the output calculation data results of the present invention. DETAILED DESCRIPTION

[0049] The present invention is further described below in conjunction with the accompanying drawings, as shown in the drawings:

[0050] This embodiment discloses a method for automatically calculating construction engineering quantities, comprising the following steps:

[0051] Get the graphics elements under different component types;

[0052] Adjust the volume of the primitives under different component types to obtain the adjusted primitive volume;

[0053] Sum up the volumes of elements on the same floor, component type, and concrete grade;

[0054] Set the summarized data into a table, perform statistics on the table, and obtain the statistical data results.

[0055] In this embodiment, the BIM modeling software Revit can be used to construct various component models required for construction, and all the elements covered by the input name type can be obtained by inputting the type name of the type of engineering quantity to be counted into Revit. Among them, the component type is the part type that constitutes the building information model; the element refers to all the graphic elements existing in the three-dimensional modeling software Revit, which is the basic component unit in the Revit model, and is essentially each building component. The elements with the same modeling rules and parameter information belong to the same type of element, that is, they constitute a component type, and there can be multiple elements under one component type.

[0056] The component types include structural foundations, structural columns, walls, structural frames, and floor slabs. By entering "structural column" into Revit, you can get all the elements of the "structural column" type in the Revit project.

[0057] In this embodiment, in order to ensure the accuracy of the engineering quantities of different types of components, it is necessary to adjust the volumes of the graphics elements that are connected to each other so that the adjusted volumes are more in line with the actual construction situation.

[0058] Adjust the volume of elements under different component types, including:

[0059] Set the deduction priority, the deduction priority from high to low is: structural foundation, structural column, wall, structural frame and floor;

[0060] Two connected elements are regarded as adjacent elements, and the volume of the overlapping parts of the adjacent elements is regarded as the target volume; wherein the volume of the element in the Revit model is automatically calculated, and the parameter information of the element includes length and / or width and / or height, etc. wherein, for a special-shaped component without a component type, the floor elevation and volume of the special-shaped component are obtained according to the following method:

[0061] The built-in modeling function of Revit is used to create the special-shaped components, which exist in the model as special-shaped blocks, and the floor elevation and volume information are obtained through geometric figures. Figure 2 As shown in the figure, the structural column created by "Built-in Model" has no parameters such as bottom elevation, top elevation, concrete grade, width, length, etc. Therefore, it is necessary to read the special-shaped component first, define it as a block in the script, and obtain the volume information directly through the geometry.

[0062] A corresponding primitive with a lower subtraction priority among adjacent primitives is taken as a target primitive, and a volume obtained by subtracting the target volume from the volume of the target primitive is taken as an adjusted volume of the target primitive; wherein the volume of a corresponding primitive with a higher subtraction priority among adjacent primitives remains unchanged.

[0063] like Figure 3As shown, there is a connection between the two types of elements, structural columns and structural frames, and there is an overlapping volume at the connection. According to the deduction priority, since the priority of the structural column is higher than that of the structural frame, the volume of the element under the structural column remains unchanged. To deduct the volume of the element under the structural frame, the volume of the element must be reduced by the volume of the overlapping part.

[0064] In this embodiment, in order to better perform subsequent statistical analysis on the construction project volume, the volume values ​​of the graphics elements of the same floor, the same component type, and the same concrete grade are summarized and summed in advance and stored in a dictionary format; wherein the dictionary is a container for storing data.

[0065] In this embodiment, the functions of creating, deleting worksheets, editing and merging cells provided by the Python library openpyxl can be used to create a worksheet for engineering quantity statistics, write headers and label rows, modify the cell format, and then set the summarized data to the table.

[0066] Statistics are performed on the table, including:

[0067] Take the floor elevation as the target column and get the first data results corresponding to different floor elevations. By counting the non-repeated "floor elevations", we can get Figure 4 The data results shown;

[0068] The component type in the first data result is used as the target column to obtain the second data result corresponding to different component types at different floor elevations; Figure 4 Extract a "floor elevation" from the , and then extract the "component type" of non-repeating elements of the same "floor elevation", you can get Figure 5 The data results shown;

[0069] The concrete grade in the second data result is used as the target column to obtain the third data result corresponding to different concrete grades under different component types at different floor elevations; for example, the parameter data of all structural frames within the "first floor" elevation is read, the concrete grade "C30" extracted from the parameters is written into the "Concrete Grade" column of the table, and the volume data is written into the "Volume" column of the table, and the volume of all C30 structural frames of the "first floor" can be counted, and the following is obtained: Figure 6 The data results shown;

[0070] The first data result, the second data result and the third data result all include the statistically analyzed primitive volumes.

[0071] The present invention also relates to an automatic calculation system for construction engineering quantities, the calculation system corresponds to the calculation method of the above embodiment, and can be understood as a system for implementing the above calculation method, the system includes a primitive acquisition module, a volume adjustment module and a volume calculation module;

[0072] The graphic element acquisition module is used to acquire graphic elements of different component types;

[0073] The volume adjustment module is used to adjust the volume of the primitives under different component types to obtain the adjusted primitive volumes;

[0074] The volume calculation module is used to summarize and sum the volumes of the graphics elements of the same floor, the same component type and the same concrete grade; set the summarized data in a table, perform statistics on the table, and obtain the statistical data results.

[0075] In order to better understand the quantity calculation method and system of the present invention, the automatic quantity calculation of the present invention is implemented in Revit through a script, including the following steps:

[0076] Determine the Python version of Dynamo in the current Revit, install that version of Python on your computer and install openpyxl in the named prompt so that you can use openpyxl to organize table data in Dynamo.

[0077] Check whether the Revit model has data that needs to be exported, sort out the parameter names corresponding to the data and supplement the missing data. According to the requirements of the statistical table, modify the elevation name and delete the redundant elevations. Figure 7 shown.

[0078] Use the script to read the model data and check whether the data meets the requirements of the engineering quantity statistics table. Use the "check element value" function in the script to check whether the extracted data is complete.

[0079] Select the storage path of the engineering quantity statistics table. The script will automatically organize the data organization form and cell style according to the format of the engineering quantity statistics table using the Python library openpyxl, and output the xlxs format file to the specified path. The output calculation data results are as follows: Figure 8 shown.

[0080] Finally, it should be noted that the above embodiments are only used to illustrate the technical solution of the present invention rather than to limit it. Although the present invention has been described in detail with reference to the preferred embodiments, those skilled in the art should understand that the technical solution of the present invention can be modified or replaced by equivalents without departing from the purpose and scope of the technical solution of the present invention, which should be included in the scope of the claims of the present invention.

Claims

1. A method for automatically calculating construction quantities. Features: include: Get the graphics elements under different component types; Adjust the volume of the primitives under different component types to obtain the adjusted volume of the primitives; Sum up the volumes of elements on the same floor, component type, and concrete grade; Set the summarized data into a table, perform statistics on the table, and obtain the statistical data results.

2. The automatic calculation method of construction engineering quantity according to claim 1, Features: Adjust the volume of elements under different component types, including: Set the deduction priority, the deduction priority from high to low is: structural foundation, structural column, wall, structural frame and floor; Two connected primitives are regarded as adjacent primitives, and the volume of the overlapping parts of the adjacent primitives is regarded as the target volume; A corresponding primitive with a lower subtraction priority among adjacent primitives is taken as a target primitive, and a volume obtained by subtracting the target volume from the volume of the target primitive is taken as an adjusted volume of the target primitive; wherein the volume of a corresponding primitive with a higher subtraction priority among adjacent primitives remains unchanged.

3. The automatic calculation method of construction engineering quantity according to claim 1, Features: Statistics are performed on the table, including: Taking the floor elevation as the target column, obtaining the first data results corresponding to different floor elevations; Using the component type in the first data result as the target column, obtaining the second data results corresponding to different component types at different floor elevations; The concrete grade in the second data result is used as the target column to obtain the third data result corresponding to different concrete grades under different component types at different floor elevations; The first data result, the second data result and the third data result all include the statistically analyzed primitive volumes.

4. The automatic calculation method of construction engineering quantity according to claim 1, Features: For special-shaped components without component types, the floor elevation and volume of the special-shaped components are obtained as follows: The special-shaped components are created by using the built-in model function of Revit, and exist in the model in the form of special-shaped blocks, and the floor elevation and volume information are obtained through geometric figures.

5. The automatic calculation method of construction engineering quantity according to claim 1, Features: The component types include structural foundations, structural columns, walls, structural frames, and floor slabs.

6. An automatic calculation system for construction engineering quantities, Features: It includes a graphic element acquisition module, a volume adjustment module and a volume calculation module; The graphic element acquisition module is used to acquire graphic elements of different component types; The volume adjustment module is used to adjust the volume of the primitives under different component types to obtain the adjusted primitive volumes; The volume calculation module is used to summarize and sum the volumes of the graphics elements of the same floor, the same component type and the same concrete grade; set the summarized data in a table, perform statistics on the table, and obtain the statistical data results.

7. The automatic calculation system for construction engineering quantities according to claim 6, Features: Adjust the volume of elements under different component types, including: Set the deduction priority, the deduction priority from high to low is: structural foundation, structural column, wall, structural frame and floor; Two connected primitives are regarded as adjacent primitives, and the volume of the overlapping parts of the adjacent primitives is regarded as the target volume; A corresponding primitive with a lower subtraction priority among adjacent primitives is taken as a target primitive, and a volume obtained by subtracting the target volume from the volume of the target primitive is taken as an adjusted volume of the target primitive; wherein the volume of a corresponding primitive with a higher subtraction priority among adjacent primitives remains unchanged.

8. The automatic calculation system for construction engineering quantities according to claim 6, Features: Perform statistics on the table, including: Taking the floor elevation as the target column, obtaining the first data results corresponding to different floor elevations; Using the component type in the first data result as the target column, obtaining the second data results corresponding to different component types at different floor elevations; The concrete grade in the second data result is used as the target column to obtain the third data result corresponding to different concrete grades under different component types at different floor elevations; The first data result, the second data result and the third data result all include the statistically analyzed primitive volumes.

9. The automatic calculation system for construction engineering quantities according to claim 6, Features: For special-shaped components without component types, the floor elevation and volume of the special-shaped components are obtained as follows: The special-shaped components are created by using the built-in model function of Revit, and exist in the model in the form of special-shaped blocks, and the floor elevation and volume information are obtained through geometric figures.

10. The automatic calculation system for construction engineering quantities according to claim 6, Features: The component types include structural foundations, structural columns, walls, structural frames, and floor slabs.

Images