Automatic statistical calculation method, device and storage medium for highway tunnel engineering quantity

Abstract

An automatic statistical calculation method for highway tunnel engineering quantities disclosed by the present invention includes obtaining all lining section types of the corresponding tunnel according to the BIM parametric design results of the highway tunnel, calculating the meterage engineering quantities of each lining section type; outputting the corresponding meterage engineering quantity tables according to the meterage engineering quantities of each lining section type; determining the lining section types of different segments along the tunnel according to the tunnel usage requirements, surrounding rock grades, engineering geology, etc.; obtaining the engineering quantity set of the linear project according to the meterage engineering quantities of different lining section types along the tunnel; obtaining all nodes of the entire tunnel and calculating the engineering quantities of each node; obtaining the engineering quantity set of the node project according to the engineering quantities of all nodes; and obtaining the engineering quantity set of the entire tunnel according to the engineering quantity set of the linear project and the engineering quantity set of the node project. The present invention can improve the accuracy and efficiency of engineering quantity statistics and calculation, and reduce unnecessary manual repetitive labor.

Description

Technical Field

[0001] The present invention belongs to the field of highway tunnel design methods, and particularly relates to a method for automatically calculating and statistics of highway tunnel engineering quantities based on BIM parametric design, a computer device, and a storage medium. Background Art

[0002] There are mainly two types of tunnel engineering quantity statistics: one is the linear meter engineering quantity statistics, such as the engineering quantity of the lining section type, etc.; the other is the node engineering quantity, such as the engineering quantity of the tunnel entrance, the engineering quantity of the plug wall, etc. The forms of the tunnel design lining section types are diverse, and the statistics methods of the engineering quantities also vary. Different lining section types require different statistics methods to be designed, and generally, designers need to manually complete the calculation by designing different calculation methods for different lining section types. The statistics of the engineering quantities of the tunnel entrance nodes, such as the statistics of backfilling and excavation quantities, have always been a difficult point for designers. Generally, designers complete it by using a simplified estimation method, and the calculation accuracy is relatively low.

[0003] For example, in a Chinese patent document with the application publication number CN110046364A and the name of a method for calculating engineering quantities based on BIM technology, it calculates the engineering quantities of components based on the BIM three-dimensional model, and then obtains the engineering quantities of the entire project. This method needs to repeat editing formulas for different projects, is not easy to reuse and share, and the model belongs to the node project, and it is impossible to automatically generate an engineering quantity table of the design object, and it is not easy to be used for the linear meter engineering quantity statistics of linear projects. Summary of the Invention

[0004] The purpose of the present invention is to provide a method, device, and storage medium for automatically calculating and statistics of highway tunnel engineering quantities to solve the problems in the prior art that it is impossible to automatically generate an engineering quantity table, the calculation efficiency of the linear meter engineering quantity statistics of linear projects is low, and the calculation accuracy of the node engineering quantity statistics is low.

[0005] The present invention solves the above technical problems through the following technical solutions: A method for automatically calculating and statistics of highway tunnel engineering quantities includes the following steps:

[0006] Obtain all the lining section types of the corresponding tunnel according to the BIM parametric design results of the highway tunnel;

[0007] Calculate the linear meter engineering quantity of each of the lining section types, and the linear meter engineering quantity of each of the lining section types includes the linear meter engineering quantities of multiple engineering quantity attributes;

[0008] Generate a corresponding linear meter engineering quantity table with one key according to the linear meter engineering quantity of each of the lining section types;

[0009] Determine the lining section types of different sections along the tunnel according to the tunnel usage requirements, surrounding rock grades, engineering geology, etc.;

[0010] Obtain the engineering quantity set of all linear projects based on the per-meter engineering quantity of the lining section types in different segments along the tunnel;

[0011] Obtain all the nodes of the entire tunnel, and calculate the engineering quantities corresponding to the nodes. The engineering quantity of each node includes the engineering quantities of multiple engineering quantity attributes;

[0012] Generate the corresponding node engineering quantity table with one key according to the engineering quantity of the nodes;

[0013] Obtain the engineering quantity set of all node projects based on the engineering quantities of all nodes;

[0014] Obtain the engineering quantity set of the entire tunnel based on the engineering quantity sets of all the linear projects and all the node projects.

[0015] Furthermore, the specific calculation process of the per-meter engineering quantity of each lining section type is as follows:

[0016] Take each lining section type as the design object, and split the design object into multiple sub-objects;

[0017] Establish a parametric model for each sub-object in the form of a database table structure and define the engineering quantity calculation strategy for each sub-object;

[0018] Read the parametric model and engineering quantity calculation strategy of each sub-object, and perform parsing and calculation on them to obtain the per-meter engineering quantity of different engineering quantity attributes of each sub-object;

[0019] Obtain the per-meter engineering quantity of different engineering quantity attributes of the design object from the set of per-meter engineering quantities of different engineering quantity attributes of all sub-objects of the design object, that is, obtain the per-meter engineering quantity of different engineering quantity attributes of each lining section type.

[0020] Furthermore, the specific calculation process of the engineering quantity of each node is as follows:

[0021] Take each node as the design object, and split the design object into multiple sub-objects;

[0022] Establish a parametric model for each sub-object in the form of a database table structure and define the engineering quantity calculation strategy for each sub-object;

[0023] Read the parametric model and engineering quantity calculation strategy of each sub-object, and perform parsing and calculation on them to obtain the engineering quantities of different engineering quantity attributes of each sub-object;

[0024] Obtain the engineering quantities of different engineering quantity attributes of the design object from the set of engineering quantities of different engineering quantity attributes of all sub-objects of the design object, that is, obtain the engineering quantities of different engineering quantity attributes of each node.

[0025] Further, the parameter attributes of each of the sub-objects include: policy number, belonging object type ID, reference name, attribute display name, attribute display order, attribute unit, attribute description, calculation formula, calculation sequence;

[0026] The engineering quantity attributes of the engineering quantity calculation strategy of each of the sub-objects include: policy number, item number, belonging object type ID, first-level name, second-level name, third-level name, material type, default value of material name, unit, whether it is a linear meter attribute, filling line number, default value, remarks, calculation formula, calculation sequence, reference name.

[0027] Further, the specific implementation process of the parsing calculation is as follows:

[0028] Read the parametric model of the sub-object from the database, and extract the design parameters, geometric quantities, and custom variables of the sub-object;

[0029] Substitute the design parameters, geometric parameters, and custom variables of the sub-object into the calculation formula of its engineering quantity calculation strategy, and the engineering quantities of different engineering quantity attributes of the sub-object can be obtained.

[0030] Further, for each of the sub-objects, multiple engineering quantity calculation strategies are supported to meet the engineering quantity statistics requirements of different design stages and design precisions.

[0031] Further, the expression of the engineering quantity set of all linear projects is:

[0032] G A ={G A,1 ,G A,2 ,…,G A,i ,…,G A,N}

[0033]

[0034] A is the total engineering quantity of all linear projects, that is, the set of different engineering quantity attributes of all linear projects; G A,i is the cumulative value of the linear meter engineering quantities of the i-th engineering quantity attribute of all linear projects; N is the number of engineering quantity attributes in the linear project; g i,j is the linear meter engineering quantity of the i-th engineering quantity attribute in the j-th linear project (or lining section type), M is the number of linear projects, and l j is the length of the j-th linear project.

[0035] Furthermore, the statistical calculation method further includes: outputting and displaying a project quantity table according to the project quantity set of the entire tunnel. The project quantity table includes a data index part and a data body part. The data index part is used to display the specific positions of the project quantity data of each design object, and the data body part is used to display the specific project quantities of each design object.

[0036] The present invention also provides a computer device, including: a memory for storing a computer program; a processor for implementing the steps of the above-mentioned automatic statistical calculation method for highway tunnel project quantities when executing the computer program.

[0037] The present invention also provides a computer storage medium, on which a computer program is stored. When the computer program is executed by a processor, the steps of the above-mentioned automatic statistical calculation method for highway tunnel project quantities are implemented.

[0038] Beneficial Effects

[0039] Compared with the prior art, the advantages of the present invention are as follows:

[0040] The automatic statistical calculation method, device and storage medium for highway tunnel project quantities provided by the present invention perform three-dimensional modeling through BIM parametric design and then conduct project quantity statistical calculations, significantly improving the accuracy and efficiency of project quantity statistical calculations; in addition, the methods of project quantity statistics are different in different design stages and design accuracies. By establishing different statistical calculation strategies, the requirements for project quantity statistics in different stages are met;

[0041] Combining BIM parametric design with the automatic statistical calculation method for project quantities, parameterizing and digitizing the experience of designers by means of informatization, and reusing it with the support of the design system, conforming to the requirements of design adjustments, supporting flexible variable and formula configuration, and reducing unnecessary manual repetitive labor. BRIEF DESCRIPTION OF THE DRAWINGS

[0042] In order to more clearly illustrate the technical solutions of the present invention, the drawings required for description in the embodiments will be briefly introduced below. Obviously, the drawings in the following description are only one embodiment of the present invention. For those of ordinary skill in the art, other drawings can be obtained based on these drawings without creative efforts.

[0043] Figure 1 is the overall flowchart of the parametric design of the highway tunnel in the embodiment of the present invention;

[0044] Figure 2 is the flowchart of project quantity calculation and summary in the embodiment of the present invention;

[0045] Figure 3It is the formula definition interface in the embodiment of the present invention;

[0046] Figure 4 It is the strategy definition interface in the embodiment of the present invention;

[0047] Figure 5 It is the parsing process of the calculation strategy for a single object in the embodiment of the present invention;

[0048] Figure 6 It is the parsing and calculation process of the calculation formula in the embodiment of the present invention;

[0049] Figure 7 It is the sample drawing of the linear meter bill of quantities in the embodiment of the present invention;

[0050] Figure 8 It is the sample drawing of the node bill of quantities in the embodiment of the present invention;

[0051] Figure 9 It is the output format of the tunnel engineering quantity table in the embodiment of the present invention;

[0052] Figure 10 It is the excavation model and the portal model of the portal in the embodiment of the present invention; wherein, Figure a is the excavation model of the portal, and Figure b is the portal model;

[0053] Figure 11 It is the sample drawing of the engineering quantity summary output table (partial data rows are hidden) in the embodiment of the present invention. Detailed implementation manners

[0054] Next, in combination with the accompanying drawings in the embodiments of the present invention, the technical solutions in the present invention will be clearly and completely described. Obviously, the described embodiments are only a part of the embodiments of the present invention, rather than all of the embodiments. Based on the embodiments in the present invention, all other embodiments obtained by those of ordinary skill in the art without making creative efforts belong to the scope of protection of the present invention.

[0055] Next, the technical solutions of the present application will be described in detail with specific embodiments. The following several specific embodiments can be combined with each other, and the same or similar concepts or processes may not be repeated in some embodiments.

[0056] Embodiment 1

[0057] A method for automatically calculating and statistically analyzing the engineering quantities of a highway tunnel provided in this embodiment includes the statistical calculation of the engineering quantities of linear projects (i.e., the statistical calculation of the engineering quantities of lining section types) and the statistical calculation of the engineering quantities of nodes, as Figure 1 and 2 shown. The process of statistically calculating the engineering quantities of linear projects is as follows:

[0058] Step 1: Obtain all the lining section types of the corresponding tunnel according to the BIM parametric design results of the highway tunnel.

[0059] Create a BIM parametric design project for the highway tunnel on the basis of the already completed tunnel route design. Create lining section types under different geological conditions along the tunnel according to the requirements of the BIM parametric design results of the highway tunnel. Mainly according to the road grade, tunnel length, geological conditions, specifications and design requirements, etc., prepare the lining section types to be used. That is, the lining section types in Step 1 are several lining section types to be used. Which several lining section types are specifically used in the highway tunnel project will be determined in Step 4.

[0060] Step 2: Calculate the meterage engineering quantity of each lining section type. The specific calculation process includes:

[0061] Step 2.1: Take each lining section type as the design object and split the design object into multiple sub-objects.

[0062] The tunnel engineering quantity statistics calculation consists of the engineering quantity calculations of multiple design objects. The multiple design objects include the meterage engineering quantity and node engineering quantity of each lining section type. A single design object can contain multiple sub-objects. For example, a tunnel lining section type includes multiple parts such as bolts, primary lining, inverted arch, and arch wall. In this embodiment, the engineering quantity of an object refers to the engineering quantity of different engineering quantity attributes of the object.

[0063] Due to insufficient design depth or difficult graphic expression, some design objects have no graphics. Such objects are called virtual design objects or simply virtual objects, such as the reinforcement of the secondary lining of the tunnel during preliminary design. The present invention can count the geometric modeling objects that have been modeled, and can also count the virtual objects without geometric modeling, so as to meet different design depth requirements and formulate different statistical calculation strategies.

[0064] Before parametric design, split a design object into multiple sub-objects. For different projects or schemes, there is no need to re-edit the parametric models and engineering quantity calculation strategies of the sub-objects, or only need to modify some attributes of the sub-objects, which greatly improves the reusability and sharing of each sub-object. Then, use geometric and engineering relationships to combine each sub-object, which greatly improves the parametric design efficiency and thus improves the statistical calculation efficiency.

[0065] Step 2.2: Establish the parametric model of each sub-object in the form of a database table structure and define the engineering quantity calculation strategy of each sub-object.

[0066] The parameter attributes of each sub-object and the project quantity attributes of the engineering calculation strategy are the core of the project quantity calculation of a single sub-object. Their attributes can be defined in the database table structure and directly participate in the statistical calculation of the project quantity. The parameter attribute values of the sub-object are derived from the design parameters, geometric figures, and attached information of the sub-object. A parametric model of each sub-object is constructed in the form of a database table structure, such as the parameter attribute table structure of the sub-object shown in Table 1.

[0067] Table 1 Parameter Attribute Table Structure of Sub-Object

[0068]

[0069] The design parameters and geometric quantities are fixed by parametric design and geometric modeling. They are defined in Table 1 for the convenience of display and formula configuration. Custom variables must be strictly defined here.

[0070] PRO Strategy Number: The calculation strategy number associated with the attribute, an integer value, numbered starting from 3, with the first 2 reserved;

[0071] TYPE_ID Belonging Object Type ID: Represents different types of object types, an integer value. For example, 300101 represents the type of open cut tunnel lining, and 300201 represents the type of hidden tunnel lining;

[0072] ATTR_SYMBOL Reference Name: The symbolic expression of the object name, a string, the keyword for formula parsing, and it needs to be unique;

[0073] ATTR_TYPE Attribute Value Type: Distinguishes the type of attribute value, an integer value, with three types: 0 - design parameter, 1 - geometric quantity, 2 - custom variable;

[0074] SHOW_IDX Attribute Display Order: An integer value representing the default order when displayed in a table or tree;

[0075] ATTR_UNIT Attribute Unit: The measurement unit of the attribute, such as m, kg, etc.;

[0076] ATTR_DESC Attribute Description: The description of the attribute, a supplementary explanation of the attribute;

[0077] FORMULA Calculation Formula for Custom Attribute: A parsable calculation string composed of relevant ATTR_SYMBOL, numbers, custom functions, mathematical symbols, parentheses, etc.;

[0078] CPT_IDX Calculation Order: The order in which the formula or single value is added to the calculation;

[0079] DEFAULT_VAL Default Value: The default value of the attribute.

[0080] Exemplarily, examples of the policy number and the object type ID to which it belongs are shown in Table 2, and examples of the attribute value type and the attribute display order are shown in Table 3.

[0081] Table 2 Policy Number and Object Type ID to which it Belongs

[0082]

[0083] Table 3 Attribute Value Type and Attribute Display Order (Continued from Table 2, corresponding to the serial numbers in Table 2)

[0084]

[0085] As shown in Table 1, the parameter attributes of the sub-object have 11 fields, and it should be noted that:

[0086] 1) The attribute value type of field 5 is divided into three types: design parameter, geometric quantity, and custom variable; the design parameter and geometric quantity are extracted from the design of the sub-object (for example, extracted from the 3D model of the sub-object), and the custom variable is obtained by formula calculation or user input;

[0087] 2) The custom variable calculated by formula must set the calculation formula and appropriate calculation order, that is, fields 9 and 10;

[0088] 3) The "reference name" of field 3 adopts a unified naming specification, and all parameter attributes of the sub-object can be designed through the edit box shown in Figure 3 The naming method of design parameter type attributes is generally: [object name].[sub-object name].parameter.[attribute name], where "[[" and "]]" are the start and end symbols of the reference, not actual characters, and each field name is connected by "."; the naming method of geometric quantity type attributes is generally: [object name].[sub-object name].[geometric attribute name], where the "geometric attribute name" generally includes length, area, volume, surface area, etc.; the general naming method of custom variable attributes is: [object name].[sub-object name].[variable name].

[0089] The engineering quantity calculation strategy represents the engineering quantity calculation process of a sub-object, which consists of two parts: intermediate custom variables and engineering quantity attributes. The intermediate custom variables are the input variables for the engineering quantity calculation. For example, reinforcement ratio, soil-rock ratio, moisture content, etc. can be used as intermediate custom variables for calculation. The engineering quantity attributes of each sub-object are defined in the form of a database table structure, as shown in Table 4 for the engineering quantity attributes of the sub-object.

[0090] Table 4 Database Table Structure of the Engineering Quantity Attributes of the Engineering Calculation Strategy of the Sub-Object

[0091]

[0092] The difference between the engineering quantity attribute and the parameter attribute is that the engineering quantity attribute finally generates an engineering quantity list with one key, while the parameter attribute is not the direct output content of the engineering quantity list.

[0093] PRO strategy number: The calculation strategy number associated with the attribute, an integer value, numbered starting from 3, with the first 2 reserved;

[0094] ID item number: The number corresponding to an engineering quantity attribute;

[0095] TYPE_ID object type ID to which it belongs: Defined in the same way as Table 1;

[0096] INAME1 first-level name: Generally the name of the design object;

[0097] INAME2 second-level name: Generally the name of the part of the design object;

[0098] INAME3 third-level name: Generally the name of the material;

[0099] IKIND material type, such as concrete, steel;

[0100] IKIND_VAL default value of the material name: Such as C20 concrete, C30 concrete, HPB300 steel, HRB400 steel;

[0101] IUNIT unit: The measurement unit of the attribute, such as m, kg, etc.;

[0102] IS_PM whether it is a linear meter attribute: 1 means it is a linear meter attribute, 0 means it is not a linear meter attribute;

[0103] ROW_IDX filling row number: The display order when configuring the engineering quantity attribute;

[0104] IVALUE default value: The default value of the engineering quantity attribute;

[0105] INOTE remarks: Supplementary explanations of the engineering quantity attribute;

[0106] FORMULA calculation formula: The calculation formula of the engineering quantity attribute, with the same composition as the FORMULA attribute in Table 1;

[0107] CPT_IDX calculation order: The calculation order of the engineering quantity;

[0108] ISYMBOL reference name: The reference name, the name when being referenced in subsequent calculations.

[0109] Exemplarily, examples of engineering quantity attributes are shown in Tables 5 and 6, and Figure 4 as shown.

[0110] Table 5 Strategy number, first-level name, second-level name, and third-level name

[0111]

[0112] Table 6 Units, Whether it is the property of linear meters, etc. (Continued from Table 5, corresponding to the serial number in Table 5)

[0113]

[0114]

[0115] As shown in Table 4, there are 16 fields in the project quantity attribute. Among them, it should be noted that:

[0116] 1) The project quantity attribute has a three-level naming: the first-level name is the object name, the second-level name is the sub-part name of the object, and the third-level name is the material name. The third-level name can be empty and is represented by "-".

[0117] 2) Similar to the custom variables in Table 1, for the project quantity attributes calculated using formulas, the calculation formula and appropriate calculation order must be set, namely fields 14 and 15;

[0118] 3) If the project quantity attribute defines a reference name, it can be referenced in subsequent calculations, namely field 16.

[0119] If the parametric model and the project quantity calculation strategy of a certain sub-object have been constructed and defined in other tunnel projects or other lining section types, they can be directly reused or shared without having to construct the parametric model and the project quantity calculation strategy of this sub-object again. Exemplarily, the parametric model of the arch wall (sub-object) of a certain lining section type (design object) has been constructed and the project quantity calculation strategy of the arch wall has been defined. When another lining section type also includes an arch wall, when constructing the parametric model and defining the project quantity calculation strategy, the parametric model and the project quantity calculation strategy of the arch wall of the previous lining section type can be directly reused. Similarly, for different tunnel projects, the parametric models and project quantity calculation strategies of existing sub-objects in previous tunnel projects can be reused and shared, greatly improving the efficiency and achieving one-time configuration for multiple uses and one-person configuration for multiple-person uses.

[0120] Automation of the project quantity calculation process is achieved by constructing a parametric model and defining a project quantity calculation strategy, realizing seamless connection with parametric modeling and improving the efficiency of the entire forward design.

[0121] It should be noted that a set of engineering quantity calculation strategies can be repeatedly applied to multiple instances of similar objects. For the engineering quantities of the same type of object, due to different geometric structures, their statistical calculation methods are also different. For the same type of object, multiple sets of engineering quantity calculation strategies can be defined according to specific situations. For specific objects and specific situations, individual parameters and calculation strategies can be fine-tuned. For example, when calculating the grouting volume of advanced support, formation porosity, permeability coefficient, etc. need to be adjusted; when calculating excavation, the soil-rock ratio needs to be adjusted. Even the calculation formula of a specific design instance can be adjusted on the basis of the default strategy to facilitate the selection of appropriate engineering quantity calculation strategies for engineering quantity calculation. For example, for the lining of the open cut tunnel section, engineering quantity calculation strategies can be defined respectively for the cases with and without a bias pressure wall.

[0122] Define different engineering quantity calculation strategies according to the design depth to adapt to the fineness of engineering quantity calculation in different periods, and be able to meet the requirements of engineering quantity statistics in different design stages and different design precisions. The parametric model and calculation strategy in the engineering quantity calculation process are separated from the design process, and the configuration of the engineering quantity calculation strategy is completed by experienced engineering designers, realizing a professional and reasonable division of labor in development and configuration.

[0123] Construct the parametric model and define the engineering quantity calculation strategy in the form of a database table structure, which is convenient for reuse and sharing, and digitizes design experience.

[0124] Step 2.3: Read the parametric model and engineering quantity calculation strategy of each sub-object, and perform parsing and calculation on them to obtain the linear meter engineering quantity of different engineering quantity attributes of each sub-object, such as Figure 5 shown.

[0125] Read the parametric model of the sub-object from the database, extract the design parameters, geometric quantities and custom variables of the sub-object, and substitute the design parameters, geometric parameters and custom variables of the sub-object into the calculation formula of its engineering quantity calculation strategy, then the linear meter engineering quantity of different engineering quantity attributes of the sub-object can be obtained.

[0126] The calculation formula is an essential part of the parameter attributes and engineering quantity attributes of the sub-object. The calculation formula consists of the reference name of the attribute, mathematical symbols, and numerical values. The usage form of the reference variable is: @(reference name), which is cited in the calculation formula. As Figure 6 shown, the parsing and calculation process of a calculation formula is as follows:

[0127] Step 2.3.1: Obtain the calculation formula and the reference attributes in this calculation formula;

[0128] Step 2.3.2: Extract the reference attribute value from the cache according to the reference name, and replace the corresponding characters in the calculation formula with this reference attribute value;

[0129] Step 2.3.3: Calculate the specific value of the calculation formula and store the specific value in the cache in the form of "<key, value>", where "key" is the reference name of the property being calculated this time and "value" is the calculation result.

[0130] It should be added that in Step 2.3.3, basic mathematical functions such as trigonometric functions and power exponents can be parsed and calculated; function extension is also supported, such as functions for calculating the weight based on the known diameter of steel bars. The parsing and calculation of the calculation formula support extended calculation functions. For complex and fixed calculations in engineering, it is too difficult to implement with basic functions, which may lead to too many custom variables. Extended calculation functions can improve the calculation ability and facilitate users to edit the calculation formula.

[0131] Exemplarily, the parsing and calculation process of the calculation formula:

[0132] (1) After completing the parametric design of the sub-object, extract the relevant properties of the sub-object as shown in Table 7:

[0133] Table 7 Relevant properties of the sub-object

[0134]

[0135]

[0136] Store the above numerical values in the cache in the form of <key, value>, where key is the reference name and value is the value, and calculate or set the properties of custom variables; the cache content at this time is:

[0137] {"<Building limit.parameter.W>", 7, "<Building limit.parameter.WJ>", 0, "<Building limit.parameter.LL>", 0.5, "<Building limit.parameter.LR>", 0.5, "<Pavement.T1 layer.area>", 2.72, "<Pavement.T2 layer.area>", 1.44, "<Pavement.T3 layer.area>", 1.2}

[0138] (2) Calculate the custom variables as shown in Table 8:

[0139] Table 8 Calculation of custom variables

[0140] Citation Name Display Name Attribute Type Value Formula Data Source CP. Roadway Width Roadway Width 2 8 Calculation CP. Roadway Type Roadway Type 2 1 Setting

[0141] Description of the calculation process:

[0142] ①Extract the formula for the road surface width "@(Building Limit.Parameter.W)+@(Building Limit.Parameter.LL)+@(Building Limit.Parameter.LR)+@(Building Limit.Parameter.WJ)", replace it with "7 + 0.5 + 0.5 + 0" according to the reference name, calculate the value 8.0, and add <"CP.Road Surface Width", 8.0> to the cache.

[0143] ②The set road surface type is 1, and add <"CP.Road Surface Type", 1> to the cache

[0144] (3) Calculate the engineering quantity results one by one in the same process as the calculation of the road surface width, as shown in Table 9:

[0145] Table 9 Calculation Results of Engineering Quantities

[0146]

[0147] Step 2.4: Obtain the linear meter engineering quantity of the design object from the set of linear meter engineering quantities of different engineering quantity attributes of all sub-objects of the design object, that is, obtain the linear meter engineering quantity of each lining section type.

[0148] Accumulate the linear meter engineering quantities of the same engineering quantity attribute of all sub-objects of a certain design object to obtain the linear meter engineering quantities of different engineering quantity attributes of the design object. Exemplarily, the lining section type includes multiple parts such as bolts, primary lining, invert, and arch wall. Accumulate the linear meter engineering quantities of a certain engineering quantity attribute of bolts, primary lining, invert, arch wall, etc. to obtain the linear meter engineering quantity of this engineering quantity attribute of the corresponding lining section type, and then obtain the linear meter engineering quantities of different engineering quantity attributes of each lining section type. The numbers of the same engineering quantity attribute of different objects are the same. Accumulate the linear meter engineering quantities of the engineering quantity attributes with the same number of different sub-objects to obtain the linear meter engineering quantities of different engineering quantity attributes of the design object.

[0149] Step 3: Generate the corresponding linear meter engineering quantity table for each lining section type with one key.

[0150] After the engineering quantity calculation of each sub-object is completed, the output of its engineering quantity table can be realized. The specific form of the engineering quantity table is as Figure 7As shown, the top of the table is the title, which generally includes the object name (the object name corresponds to the first-level name in Table 2). The table has 6 columns. The first 3 columns are item columns, with 1 column each for unit, quantity, and remarks. The first column of the table is the second-level name of the engineering quantity attribute, and rows can be merged when the characters are the same; the second column is the material type, and if the character is "-", it can be merged with the next column; the third column is the material name, which can be default data or user input. All materials are from the material standard library and consist of the material name and material specifications; the fourth column of the table is the unit, corresponding to the data in "IUNIT" in Table 2; the fifth column is the value; the sixth column is the remarks, and when the second-level names are the same, the adjacent row contents are the same and are merged downward. The one-key output configuration of the engineering quantity table includes the table name and table number, and the corresponding row configuration includes the design object type number, engineering quantity item number, row number, etc. After the program reads the configuration, it generates the table content data according to the rules and the engineering quantity data of the design object instance. After the user selects the position to be added on the drawing, the corresponding engineering quantity table can be automatically generated on the drawing. Through configuration, the linear meter engineering quantity table or node engineering quantity table can be automatically output in one key to the drawing. Generally, one linear engineering design object can be configured to output one or more linear meter engineering quantity tables, and one node engineering design object can be configured with one or more node engineering quantity tables.

[0151] Step 4: Determine the lining section types of different sections along the tunnel according to the tunnel usage requirements, surrounding rock grades, engineering geology, etc.

[0152] Import the tunnel structure file to determine the position of the tunnel on the route, or directly set the position of the tunnel on the route. Complete the design of the tunnel standard section according to the usage requirements, surrounding rock grades, engineering geology, etc., and determine the lining section types of different sections along the tunnel.

[0153] Step 5: Obtain the engineering quantity set of all linear projects based on the linear meter engineering quantities of the lining section types of different sections along the tunnel. The specific calculation formula is:

[0154] G A ={G A,1 ,G A,2 ,…,G A,i ,…,G A,N}

[0155]

[0156] Among them, G A is the total engineering quantity of all linear projects, that is, the set of different engineering quantity attributes of all linear projects; G A,i is the cumulative value of the linear meter engineering quantities of the i-th engineering quantity attribute of all linear projects; N is the number of engineering quantity attributes in the linear project; g i,jis the linear meter quantity of the i-th engineering quantity attribute in the j-th linear project, M is the number of linear projects, and l j is the total length of the j-th linear project.

[0157] The naming rules for objects, their attributes, and engineering quantities are simple, clear, and convenient to use. They are calculated and stored by object, support the output of their engineering quantity tables, and finally summarize the engineering quantity data. The entire design and calculation process is clear and organized, and it is convenient to use. Combining the design of parametric models and engineering quantity calculation strategies with engineering quantity calculation greatly improves the calculation efficiency.

[0158] The process of calculating the engineering quantity of nodes is as follows:

[0159] Step 6: Obtain all the nodes of the entire tunnel and calculate the engineering quantity of each node.

[0160] Tunnel nodes include portal openings, retaining walls, etc. The specific calculation process for the engineering quantity of each node is as follows:

[0161] Step 6.1: Take each node as the design object and split the design object into multiple sub-objects.

[0162] For example, portal nodes include excavation, filling, end walls, nameplates, coping stones, drainage ditches, intercepting ditches, etc.

[0163] Step 6.2: Establish a parametric model for each sub-object in the form of a database table structure and define the engineering quantity calculation strategy for each sub-object.

[0164] The parametric attributes of each sub-object and the engineering quantity attributes of the engineering calculation strategy are the core of the engineering quantity calculation for different engineering attributes of a single sub-object. Their attributes can be defined in the database table structure and directly participate in the statistical calculation of their engineering quantities. The values of the parametric attributes of the sub-object are derived from the design parameters, geometric shapes, and attached information of the sub-object. A parametric model for each sub-object is constructed in the form of a database table structure, such as the parametric attribute table structure of the sub-object shown in Table 1.

[0165] The engineering quantity calculation strategy represents the engineering quantity calculation process of a sub-object, which consists of two parts: intermediate custom variables and engineering quantity attributes. The intermediate custom variables are the input variables for the engineering quantity calculation. The engineering quantity attributes of each sub-object are defined in the form of a database table structure, such as the engineering quantity attributes of the sub-object shown in Table 4.

[0166] Step 6.3: Read the parametric model and engineering quantity calculation strategy of each sub-object, and perform parsing and calculation on them to obtain the engineering quantities of different engineering quantity attributes of each sub-object.

[0167] Read the parametric model of the sub-object from the database, extract the design parameters, geometric quantities, and custom variables of the sub-object, and substitute the design parameters, geometric parameters, and custom variables of the sub-object into the calculation formula of its engineering quantity calculation strategy, then the engineering quantities of different engineering quantity attributes of the sub-object can be obtained.

[0168] The calculation formula is an essential part of the parameter attributes and engineering quantity attributes of the sub-object. The calculation formula consists of the reference name of the attribute, mathematical symbols, and numerical values. The usage form of the reference variable is: @([reference name]), where "[", "]" are not actual constituent characters and are used in the calculation formula. The parsing and calculation process of a calculation formula is as follows:

[0169] Step 6.3.1: Obtain the calculation formula and the reference attributes in the calculation formula;

[0170] Step 6.3.2: Extract the reference attribute value from the cache according to the reference name, and replace the corresponding characters in the calculation formula with the reference attribute value;

[0171] Step 6.3.3: Calculate the specific value of the calculation formula, and store the specific value in the cache in the form of "<key,value>", where "key" is the reference name of the attribute calculated this time, and "value" is the calculation result.

[0172] Step 6.4: Obtain the engineering quantity of the design object from the combination of the engineering quantities of different engineering quantity attributes of all sub-objects of the design object, that is, obtain the engineering quantity of each node.

[0173] The engineering quantities of the same engineering quantity attribute of all nodes of the design object are accumulated to obtain the engineering quantities of different engineering quantity attributes of the design object. For example, the hole nodes include excavation, filling, end wall, nameplate, coping stone, drainage ditch, intercepting ditch, etc. The engineering quantities of a certain engineering quantity attribute of excavation, filling, end wall, nameplate, coping stone, drainage ditch, intercepting ditch, etc. are accumulated to obtain the engineering quantity of this engineering quantity attribute of the hole node, and then the engineering quantities of different engineering quantity attributes of each node are obtained. According to the engineering quantities of different engineering quantity attributes of each node, the engineering quantity table of the corresponding node can be generated with one key, as Figure 8 shown. The specific generation process is the same as step 3. Figure 8 Among them, the engineering quantity of the earthwork (engineering quantity attribute) of the excavation (node) is 988.47m 3 .

[0174] Step 7: Obtain the engineering quantity set of all node projects according to the engineering quantities of all nodes. The specific calculation expression is:

[0175] G B ={G B,1 ,G B,2 ,…,G B,i,…,G B,S}

[0176]

[0177] Among them, G B is the set of quantities of work for all node projects, that is, the set of different quantity-of-work attributes of all node projects; G B,i is the cumulative value of the quantities of work of the i-th quantity-of-work attribute of all node projects; S is the number of quantity-of-work attributes in the node project; r i,j is the quantity of work of the i-th quantity-of-work attribute in the j-th node project, and T is the number of node projects.

[0178] Step 8: Obtain the set of quantities of work of the entire tunnel based on the set of quantities of work of all linear projects and the set of quantities of work of all node projects.

[0179] Step 9: Generate and display a bill of quantities automatically based on the set of quantities of work of the entire tunnel. The bill of quantities includes a data index part and a data body part. The data index part is used to display the specific locations of the quantity-of-work data of each design object, such as determining information such as the starting and ending row numbers where the quantity-of-work data of different types of design objects are stored. The data body part is used to display the specific quantities of work of each design object. The data body part is divided into three parts: a list of quantity-of-work attributes, quantity-of-work data of object instances, and statistics of the data, as Figure 8 shown. Using a unified quantity-of-work output format can facilitate the classification, aggregation, and statistics of quantity-of-work data, and the quantity-of-work data can be reprocessed as needed.

[0180] A method for automatically calculating and statistics of the quantities of work of a highway tunnel disclosed in the present invention includes obtaining all the lining section types of the corresponding tunnel according to the BIM parametric design results of the highway tunnel, calculating the per-meter quantities of work of each lining section type; outputting the corresponding per-meter quantity-of-work table according to the per-meter quantities of work of each lining section type; determining the lining section types of different sections along the tunnel according to the tunnel usage requirements, surrounding rock grades, engineering geology, etc.; obtaining the set of quantities of work of linear projects according to the per-meter quantities of work of different lining section types along the tunnel; obtaining all the nodes of the entire tunnel and calculating the quantities of work of each node; obtaining the set of quantities of work of node projects according to the quantities of work of all nodes; obtaining the set of quantities of work of the entire tunnel according to the set of quantities of work of linear projects and the set of quantities of work of node projects. The present invention can improve the accuracy and efficiency of quantity-of-work statistics and calculation, and reduce unnecessary manual repetitive labor.

[0181] Example 2

[0182] 1. Calculation of the per-meter quantity of work of the S-IVa type lining of a certain tunnel

[0183] ① Definition of quantity-of-work attributes of design objects (partial)

[0184] Table 10 Calculation Configuration Table of Quantity per Meter of S-IVa Type Lining for a Certain Tunnel (Partial)

[0185]

[0186] ② Result Output

[0187] During the process of designing this object, according to the parameters, geometric variables, and custom variables of the design object, its engineering quantity is automatically calculated according to Table 10, and then according to the configuration of its engineering quantity table, its engineering quantity table is automatically generated, and the result is as Figure 7 shown

[0188] 2. Calculation of Engineering Quantity for the Nodal Points of a Certain Tunnel Entrance

[0189] ① Definition of Engineering Quantity Attributes for the Design Object (Partial)

[0190] Table 11 Engineering Quantity Configuration Table for the Nodal Points of a Certain Tunnel Entrance (Partial)

[0191]

[0192] ② Result Output

[0193] During the process of designing this object, according to the parameters of the design object, its excavation model and 3D model are constructed, as Figure 10 ; the geometric variables of its model are obtained and combined with the custom variables, and its nodal point engineering quantity is automatically calculated according to Table 11; finally, according to the configuration of its engineering quantity table, its engineering quantity table is automatically generated, and the result is as Figure 8 shown

[0194] 3. Summary of Engineering Quantities for a Tunnel in a Certain Project

[0195] The total engineering quantity table for a tunnel includes two parts: the quantity per meter of engineering quantity (i.e., the engineering quantity of linear engineering) and the nodal point engineering quantity (i.e., the engineering quantity of nodal engineering), and its output format is as Figure 9 shown. Among them, the calculation of the quantity per meter of engineering quantity is as described in Step 2 of Example 1. The main linear engineering includes tunnel lining, pavement engineering, advanced support, etc. When summarizing and outputting, it is necessary to output the attribute values of the quantity per meter of each project and the length per meter at the same time. The lengths per meter of the same lining section are merged and output; among them, the calculation of the nodal point engineering quantity is as described in Step 6 of Example 1. The main nodal engineering includes tunnel entrances, plug walls, etc. When summarizing and outputting the nodal engineering, it is only necessary to output the attribute quantity values of each project for each node Figure 11It is a summary table of the engineering quantities of a tunnel in a certain project, which is output in segments for three types of design objects; there are two portals, and there are 14 node engineering quantity attributes automatically calculated and statistically (some rows are hidden); there are 2 segments of the open tunnel with the same lining type, totaling 10 m, and there are 47 linear meter engineering quantity attributes automatically calculated and statistically (some rows are hidden); there were originally 7 segments in the closed tunnel section, which are merged into 5 categories, totaling 660 m, and there are 75 linear meter engineering quantity attributes automatically calculated and statistically (some rows are hidden). Users can organize the output results into the final printed table using Excel formulas or VBA programs according to their needs.

[0196] The specific embodiments disclosed above are only for the present invention, but the protection scope of the present invention is not limited thereto. Any person skilled in the art within the technical scope disclosed by the present invention can easily think of changes or variations, which should be covered within the protection scope of the present invention.

Claims

1. An automatic statistical calculation method for highway tunnel engineering quantities, characterized in that Including the following steps: Obtain all the lining section types of the corresponding tunnel according to the BIM parametric design results of the highway tunnel; Calculate the per-meter engineering quantity of each of the lining section types, and the per-meter engineering quantity of each of the lining section types includes the per-meter engineering quantities of multiple engineering quantity attributes; Generate the corresponding per-meter engineering quantity table with one key according to the per-meter engineering quantity of each of the lining section types; Determine the lining section types of different sections along the tunnel; Obtain the engineering quantity set of all linear projects according to the per-meter engineering quantities of the lining section types of different sections along the tunnel; Obtain all the nodes of the whole tunnel and calculate the engineering quantities corresponding to the nodes. The engineering quantity of each node includes the engineering quantities of multiple engineering quantity attributes; Generate the corresponding node engineering quantity table with one key according to the engineering quantities of the nodes; Obtain the engineering quantity set of all node projects according to the engineering quantities of all the nodes; Obtain the engineering quantity set of the whole tunnel according to the engineering quantity sets of all the linear projects and all the node projects; Among them, the specific calculation process of the per-meter engineering quantity of each of the lining section types is as follows: Take each lining section type as the design object and split the design object into multiple sub-objects; Establish the parametric model of each sub-object in the form of a database table structure and define the engineering quantity calculation strategy of each sub-object; Read the parametric model and the engineering quantity calculation strategy of each of the sub-objects, and perform parsing and calculation on them to obtain the per-meter engineering quantities of different engineering quantity attributes of each sub-object; Obtain the per-meter engineering quantities of different engineering quantity attributes of the design object from the set of the per-meter engineering quantities of different engineering quantity attributes of all the sub-objects of the design object, that is, obtain the per-meter engineering quantities of different engineering quantity attributes of each lining section type; Among them, the specific calculation process of the engineering quantity of each of the nodes is as follows: Take each node as the design object and split the design object into multiple sub-objects; Establish the parametric model of each sub-object in the form of a database table structure and define the engineering quantity calculation strategy of each sub-object; Read the parametric model and the engineering quantity calculation strategy of each of the sub-objects, and perform parsing and calculation on them to obtain the engineering quantities of different engineering quantity attributes of each sub-object; Obtain the engineering quantities of different engineering quantity attributes of the design object from the set of the engineering quantities of different engineering quantity attributes of all the sub-objects of the design object, that is, obtain the engineering quantities of different engineering quantity attributes of each node.

2. The automatic statistical calculation method for highway tunnel engineering quantities according to claim 1, wherein, The parameter attributes of each of the sub-objects include: strategy number, belonging object type ID, reference name, attribute display name, attribute display order, attribute unit, attribute description, calculation formula, calculation order; The engineering quantity attributes of the engineering quantity calculation strategy of each of the sub-objects include: strategy number, item number, belonging object type ID, first-level name, second-level name, third-level name, material type, default material name, unit, whether it is a per-meter attribute, filling line number, default value, remarks, calculation formula, calculation order, reference name; 3. The automatic statistical calculation method for highway tunnel engineering quantity as described in claim 1, wherein The specific implementation process of the parsing and calculation is as follows: Read the parametric model of the sub-object from the database and extract the design parameters, geometric quantities and custom variables of the sub-object; Substitute the design parameters, geometric parameters, and custom variables of the sub-object into the calculation formula of its engineering quantity calculation strategy, and the engineering quantities of different engineering quantity attributes of the sub-object can be obtained.

4. The automatic statistical calculation method for highway tunnel engineering quantity as described in claim 1, wherein, For each of the sub-objects, configure multiple engineering quantity calculation strategies to meet the engineering quantity statistics requirements in different design stages and design precisions.

5. The automatic statistical calculation method for highway tunnel engineering quantity according to claim 1, characterized in that, The expression of the engineering quantity set of all linear projects is: G A = {G A,1 , G A,2 , …, G A,i , …, G A,N} Among them, G A is the total engineering quantity of all linear projects; G A,i is the cumulative value of the linear meter engineering quantity of the i-th engineering quantity attribute of all linear projects; N is the number of engineering quantity attributes in the linear project; g i,j is the linear meter engineering quantity of the i-th engineering quantity attribute in the j-th linear project, M is the number of linear projects, l j is the length of the j-th linear project.

6. The automatic statistical calculation method for highway tunnel engineering quantity according to claim 1, characterized in that, It also includes: Output and display an engineering quantity table according to the engineering quantity set of the entire tunnel. The engineering quantity table includes a data index part and a data body part. The data index part is used to display the specific positions of the engineering quantity data of each design object, and the data body part is used to display the specific engineering quantities of each design object.

7. A computer device, characterized in that, It includes: A memory for storing computer programs; A processor for implementing the steps of the automatic statistical calculation method for highway tunnel engineering quantities as described in any one of claims 1 to 6 when executing the computer program.

8. A computer storage medium, characterized in that: A computer program is stored on the computer storage medium, and when the computer program is executed by the processor, the steps of the automatic statistical calculation method for highway tunnel engineering quantities as described in any one of claims 1 to 6 are implemented.

Images