A bridge budget basic calculation table generation method, system, device and medium

Abstract

This invention proposes a method, system, equipment, and medium for generating a basic quantity calculation table for bridge budgets, belonging to the field of engineering cost technology. The method includes: acquiring design quantity data; constructing a structured quota database and design principles, wherein the quota database extracts features from the applicable conditions and work content of quota statistical items to form multi-feature combination retrieval tags; generating retrieval conditions based on the design quantity data and additional conditions in the design principles, automatically retrieving and matching corresponding quota statistical items from the quota database; and, based on the matched quota statistical items and combined with preset quota adjustment rules, correcting the quota coefficients or replacing content to generate a basic quantity calculation table for the budget containing information on quantity conversion, quota application, rate determination, and quota correction. This invention can achieve automatic extraction of quantities without relying on fixed templates.

Description

Technical Field

[0001] This invention belongs to the field of engineering cost technology, and in particular relates to a method, system, equipment and medium for generating a basic quantity calculation table for bridge budgets. Background Technology

[0002] The statements in this section are merely background information related to the present invention and do not necessarily constitute prior art.

[0003] In the field of highway engineering, data preprocessing for converting design quantities into budget quantities typically accounts for more than half of the entire preparation cycle during the preparation of construction drawing budgets.

[0004] In the traditional model, design and cost estimation are separated. Designers need to supplement quantities based on templates provided by cost estimators, who then manually input or extract and convert the data before generating a budget list for import into cost estimation software. This process involves multiple data transfer steps, is prone to human intervention and errors. More importantly, the traditional method requires a fixed format for the design quantity table, which cannot adapt to scenarios with frequent design changes. Furthermore, the format of the quantity table varies between different projects, requiring formula re-associations for each project, resulting in long budget preparation cycles and a large workload. Summary of the Invention

[0005] To overcome the shortcomings of the existing technology, this invention proposes a method, system, equipment, and medium for generating a basic quantity calculation table for bridge budgets. This method enables the conversion of design quantities, the application of quotas, the determination of rates, and the correction of quotas, directly generating a basic quantity calculation table for the budget. After the bill of quantities is imported into the cost estimation software, no additional quantity processing is required; only unit prices need to be applied to complete the cost calculation. This solves the problem of format differences between different projects during the construction drawing budget preparation process and shortens the budget preparation cycle.

[0006] To achieve the above objectives, one or more embodiments of the present invention provide the following technical solutions: In a first aspect, the present invention discloses a method for generating a basic quantity calculation table for bridge budgeting, comprising: Obtain design engineering quantity data, which includes component code, material code, unit of measurement, quantity and attribute information; A structured quota database and design principles are constructed. The quota database is based on highway engineering estimate quotas, budget quotas, and supporting supplementary quotas. The applicable conditions and work contents of the quota statistical items are extracted to form multi-feature combination retrieval tags. The design principles supplement the key pricing information not included in the design results. The key pricing information includes construction technology, equipment type, transportation conditions, and material specifications. Based on the component codes, material codes and attribute information in the design engineering quantity data, and combined with the additional conditions in the design principles, search conditions are generated to automatically retrieve and match the corresponding quota statistical entries from the quota database. Based on the matched quota statistics items, and combined with the preset quota adjustment rules, the quota coefficients are corrected or the content is replaced to generate a basic quantity calculation table for the budget, which includes information on quantity conversion, quota application, rate determination and quota correction.

[0007] Secondly, this invention discloses a basic quantity take-off table generation system for bridge budgets, comprising: The data acquisition module is configured to acquire design engineering quantity data, which includes component codes, material codes, units of measurement, quantities, and attribute information. The quota construction module is configured to: construct a structured quota database and design principles. The quota database is based on highway engineering estimate quotas, budget quotas, and supporting supplementary quotas. It extracts features of the applicable conditions and work content of quota statistical items to form multi-feature combination retrieval tags. The design principles supplement the key pricing information not included in the design results. The key pricing information includes construction technology, equipment type, transportation conditions, and material specifications. The mapping and association module is configured to: generate search conditions based on the component codes, material codes and attribute information in the design engineering quantity data, combined with the additional conditions in the design principles, and automatically retrieve and match the corresponding quota statistical entries from the quota database; The bill of quantities generation module is configured to: based on the matched quota statistics items, and combined with the preset quota adjustment rules, perform coefficient correction or content replacement on the quotas to generate a basic quantity calculation table for the budget, which includes information on quantity conversion, quota application, rate determination, and quota correction.

[0008] Thirdly, the present invention discloses an electronic device, including a memory and a processor, and computer instructions stored in the memory and running on the processor, wherein the computer instructions, when run by the processor, complete the steps of the above-mentioned method for generating a basic quantity take-off table for bridge budget.

[0009] Fourthly, the present invention discloses a computer-readable storage medium for storing computer instructions, which, when executed by a processor, complete the steps of the above-mentioned method for generating a basic quantity take-off table for bridge budget.

[0010] Compared with the prior art, the beneficial effects of the present invention are as follows: This invention uses material coding, component coding, and other superimposed design information conditions to form query conditions. It organizes design engineering quantity data in a coded manner, achieving automatic extraction of engineering quantities without the need for fixed templates. It is adaptable to the needs of different project applications and can accommodate different project and design change requirements, shortening the budget list preparation cycle. At the same time, it eliminates data errors and omissions in manual processes, achieving a complete match between design and cost engineering quantities. Furthermore, it can merge and statistically output small structures such as passages, overpasses, and small bridges according to statistical requirements, that is, directly outputting a basic quantity calculation table for the budget engineering quantities of more than a hundred small structures.

[0011] Advantages of additional aspects of the invention will be set forth in part in the description which follows, and in part will be obvious from the description, or may be learned by practice of the invention. Attached Figure Description

[0012] The accompanying drawings, which form part of this invention, are used to provide a further understanding of the invention. The illustrative embodiments of the invention and their descriptions are used to explain the invention and do not constitute an improper limitation of the invention.

[0013] Figure 1 This is a flowchart of the method for generating the basic quantity calculation table for bridge budget as described in Embodiment 1 of the present invention.

[0014] Figure 2 This is an example diagram of the quota database described in Embodiment 1 of the present invention. Detailed Implementation

[0015] It should be noted that the following detailed descriptions are exemplary and intended to provide further illustration of the invention. Unless otherwise specified, all technical and scientific terms used herein have the same meaning as commonly understood by one of ordinary skill in the art to which this invention pertains.

[0016] It should be noted that the terminology used herein is for the purpose of describing particular implementations only and is not intended to limit the exemplary implementations of the present invention.

[0017] Where there is no conflict, the embodiments and features in the embodiments of the present invention can be combined with each other.

[0018] Example 1 In the field of highway engineering, the construction drawing budget is one of the key deliverables formed during the construction drawing design phase. Data preprocessing accounts for more than half of the entire budget preparation process. The data preprocessing process mainly involves converting the quantities of work in the design into the quantities required for budget preparation; this is the process of generating the basic quantity calculation table for the budget. It is one of the important bases for budgeting costs and a prerequisite file for importing highway cost estimation software.

[0019] In the traditional design model, design and cost estimation belong to different disciplines. The usual practice is for designers to supplement the design quantities based on a budget quantity template prepared by cost estimators. Then, cost estimators convert this template into a basic quantity calculation table for the budget and import it into the highway cost estimation software, or manually enter the quantities directly into the software. This method involves multiple data transfer steps, significant human intervention, and is prone to errors. Furthermore, the traditional method results in a heavy workload and long processing time for cost estimators, requiring high-quality quantity data from designers and a one-time completion, making it unsuitable for frequent design changes. Moreover, existing methods using Excel to extract quantities from the design quantity table only extract and convert quantities, failing to cover data processing such as rate determination and quota adjustments. This process also requires a fixed format for the quantity table, and since quantity tables differ between projects, each project needs to re-associate formulas.

[0020] Therefore, the present invention aims to automate and standardize the conversion of design quantities into basic quantity calculation tables for budgeting, and to shorten the budget preparation cycle.

[0021] In one or more embodiments, a method for generating a basic quantity take-off table for bridge budgeting is disclosed, such as... Figure 1 As shown, it includes the following steps: Step S1: Obtain design engineering quantity data, which includes component code, material code, unit of measurement, quantity and attribute information.

[0022] In this embodiment, the attribute information includes, but is not limited to: component geometry (length, width, height, diameter), material strength grade, pile hole depth and soil classification, prestressed steel strand type and quantity, structural height, etc.

[0023] Step S2: Construct a structured quota database and design principles. The quota database is constructed based on the quota numbers defined by the highway engineering preliminary estimate quota, highway engineering budget quota, or highway engineering supplementary quota. The applicable conditions and work contents of the quota statistical items are extracted to form multi-feature combination retrieval tags. The design principles supplement the key pricing information not included in the design results. The key pricing information includes construction technology, equipment type, transportation conditions, and material specifications.

[0024] Step S2-1: Construct the hierarchy and output format of the basic quantity calculation table.

[0025] Based on the guidelines for compiling highway engineering budget estimates, a standardized template for a hierarchical budget calculation table is constructed. This template adopts a structured data organization format, fully covering all decomposition levels from the project table to the itemized table. The project table is a table that subdivides each specialty according to its function to the smallest level, while the itemized table is a table that breaks down each specialty according to its structural composition to the smallest component.

[0026] Specifically, the project table follows a hierarchical structure of "department-item-section-detail" and unfolds layer by layer. Its numbering system consists of fixed-digit number segments: department (2 digits) - item (3 digits) - section (2 digits) - subsection (2 digits) - detail (2 digits), with each level numbered sequentially starting from the number "1" until the final level. The sub-item table is further subdivided according to professional characteristics. The bridge sub-item table is mainly divided into three levels, progressively subdivided according to the bridge's structural composition, including section number, sub-item number, and sub-sub-item number.

[0027] Step S2-2: Construct quota statistics entries.

[0028] After constructing the basic quantity calculation table hierarchy, the statistical scope is clarified. In the final level, the relevant quota items of each level are sorted out and linked. The quota is compiled according to reasonable construction organization and normal construction conditions. The design engineering quantity is not just a simple "engineering quantity" number. Therefore, the quota statistical items include factors such as material production and loss, transportation conditions and distance, and specific process requirements for installation or construction.

[0029] As an example, for "drilled cast-in-place piles", the design quantities include pile length, concrete volume, and steel reinforcement weight. The budget needs to refine the design and convert it into quota statistical items. The budget quota items for "drilled cast-in-place piles" should include statistical items such as concrete volume, steel reinforcement weight, hole forming process, concrete mixing, concrete transportation, steel cage transportation, steel casing, and testing pipes. The quantities of the budget statistical items are all converted from the design quantities.

[0030] Step S2-3: Determine the output template format.

[0031] Based on highway cost estimation software, the template of the basic quantity calculation table of the budget in the software is correctly imported as the generated template format. It mainly includes fields such as hierarchy, project section number, rate number, quota code, name of project or item or section or sub-item or quota, unit of measurement, quantity, design quantity 1, design quantity 2, quota adjustment status, quota database, etc.

[0032] Step S2-4: Based on the highway engineering preliminary estimate quota, budget quota and supporting supplementary quota, construct a deeply structured quota database and design principles.

[0033] The quota database is based on existing highway engineering estimate quotas, budget quotas, and supplementary quotas. It extracts features from the applicable conditions and work content of quota statistical items to form multi-feature combination search tags. It should be understood that various quota items have pre-defined quota numbers in standard documents such as highway engineering estimate quotas, highway engineering budget quotas, and highway engineering supplementary quotas.

[0034] Specifically, the quota database systematically extracts the applicable conditions and work content of quota statistical items, mainly through efficient retrieval using multi-feature combination conditions, quickly obtaining the preliminary / budget quota number, preliminary / budget quota name, unit of measurement, rate number, and other component-specific information of the statistical items. Based on structural classification and statistical granularity, such as... Figure 2 As shown, the quota database is mainly divided into categories such as mixing and transportation, foundation construction, concrete, steel bars and steel strands, component fabrication and installation, ancillary works, road works, and others. Each category is further subdivided into quota tables for different structural parts or component types, forming a clear and comprehensive quota retrieval system.

[0035] Preferably, feature extraction involves labeling the applicable conditions and work content of each quota statistical item to filter out quota numbers that meet the requirements. The multi-feature combination retrieval tags establish an index for each quota statistical item, supporting rapid retrieval by combination of conditions such as component name or code, construction technology, equipment type, material specifications, pile diameter range, hole depth range, and soil classification.

[0036] Preferably, based on the quota content applied to bridge structures, the quota content for different bridge structures is comprehensively reviewed, and various quota component tables are determined according to certain structures and rules. A quota database is composed of multiple quota component tables, primarily used for bridges with different characteristics in projects, through which the correct quota number is obtained. The quota database is divided into multiple modules, each module corresponding to quota tables for different structural parts or component types: The mixing and transportation module includes material mixing quota tables, material transportation quota tables, etc. The basic construction module includes the cast-in-place pile hole drilling quota table, the cast-in-place pile auxiliary quota table, and the enlarged foundation quota table, etc. The concrete module includes the foundation concrete quota table, the lower concrete quota table, and the upper concrete quota table, etc. The steel reinforcement and strand module includes the quota tables for foundation and lower reinforcement, and the quota tables for upper reinforcement and strands, etc. The component fabrication and installation module includes a prefabricated component fabrication quota table and a prefabricated component installation quota table, etc. The auxiliary engineering modules include quota tables for bridge deck paving, bearings, expansion joints, and crash barriers.

[0037] This embodiment, by building a standardized quota library, enables structured storage and rapid retrieval of quota data, effectively solving the problems of inconsistent quota application rules for different cost estimators, duplicate copying of tables, and poor usability.

[0038] The design principles supplement the key pricing information not included in the design deliverables. This key pricing information includes construction techniques, equipment types, transportation conditions, and material specifications. Users (cost estimators) can make a one-time configuration based on the preliminary construction plan, and the configuration results will take effect globally during the project budget preparation process.

[0039] Conventional design deliverables focus on expressing the geometric dimensions, material properties, and spatial relationships of a project. They typically do not directly include detailed construction organization and measures information required for pricing. Design principles are established to bridge this crucial information gap. As a link between design deliverables and cost calculation, their core function is to allow users to supplement and confirm key pricing information not explicitly stated in the design deliverables based on preliminary construction plans. Design principles mainly include aspects such as mixing and transportation, foundation construction, concrete, reinforcement, installation, and demolition.

[0040] Step S3: Based on the component codes, material codes, and attribute information in the design engineering quantity data, and combined with the additional conditions in the design principles, generate search conditions, and automatically retrieve and match the corresponding quota statistical entries from the quota database.

[0041] By linking design engineering quantity data and design rules for querying, precise search conditions are formed through the interaction of the two. Design engineering quantities are organized with information such as component code, material code, unit, quantity, and attributes. Through the core information such as components, materials, and attributes in the engineering quantity data, combined with the additional conditions such as construction technology, equipment selection, and transportation distance specified in the design rules, a refined matching is driven, and the most applicable quota statistical items are automatically and efficiently retrieved and initially selected from the structured quota database.

[0042] Specifically, the component codes, material codes, basic attributes, and design principles in the design engineering quantity data are used as retrieval information. The retrieval information is then used to query tables in the quota library, and the information in the quota library is output.

[0043] As an example, taking "drilled cast-in-place piles" as an example, the quota statistics items mainly include concrete volume, steel bar weight, hole forming process, concrete mixing, concrete transportation, steel cage transportation, steel casing, and testing pipe.

[0044] The concrete volume can be obtained from the concrete-foundation concrete quota table by querying the component name, construction technology, equipment type / construction method, and pile diameter to obtain the budget quota number, budget quota name, statistical unit, rate number, benchmark quota concrete type, concrete consumption, etc. The component name and pile diameter are obtained from the design engineering quantity, and the construction technology and equipment type / construction method are obtained from the design principles. The weight of reinforcing bars is obtained from the Reinforcing Bars and Steel Strands - Foundation and Substructure Reinforcing Bar Quota Table by using the component name, processing method, connection method, and component height to obtain the budget quota number, budget quota name, statistical unit, rate number, benchmark quota HPB300 consumption, benchmark quota HRB400 consumption, etc. The component name and component height are obtained from the design engineering quantity, and the processing method and connection method are obtained from the design principles. The drilling process can be obtained from the foundation construction - cast-in-place pile drilling quota table by querying the drilling process, site type, pile diameter, hole depth, and soil classification to obtain the budget quota number, budget quota name, statistical unit, and rate number, etc. The drilling process, site type, pile diameter, hole depth, and soil classification are obtained through the design engineering quantity. Concrete mixing information, such as budget quota number, budget quota name, statistical unit, and rate number, can be obtained from the mixing and transportation - material mixing quota database by querying the mixing materials, equipment type, and production capacity. The mixing materials are obtained through the design engineering quantity, and the equipment type and production capacity are obtained through the design principles. For concrete transportation and rebar cage transportation, the budget quota number, distance-corrected budget quota, budget quota name, statistical unit, and rate number can be obtained from the mixing and transportation - material transportation quota database by querying the transportation materials, equipment type, and transportation capacity. The transportation materials are obtained through the design engineering quantity, and the equipment type and transportation capacity are obtained through the design principles. The steel casing and testing pipe are obtained from the foundation construction - cast-in-place pile auxiliary quota library table through material name, site category, water depth, etc., including budget quota number, budget quota name, statistical unit, and rate number. The material name, site category, and water depth are obtained through the design engineering quantity.

[0045] Step S4: Based on the matched quota statistics entries and combined with the preset quota adjustment rules, the quotas are adjusted by coefficient correction or content replacement to generate a basic quantity calculation table for the budget, which includes information on quantity conversion, quota application, rate determination, and quota correction. The quota correction information includes the quota adjustment status, which is defined in the format of "the last item of the quota number (i.e., the sub-item number) × correction coefficient," so that it can be used as input for subsequent cost estimation software.

[0046] The preset quota adjustment rules mainly include: concrete type adjustment, steel bar type adjustment, pile diameter adjustment, prestressed steel strand adjustment, and transportation distance adjustment.

[0047] Specifically, concrete grade adjustment involves converting and processing the price difference of the benchmark concrete material based on the concrete and mortar grades. When the design concrete grade differs from the quota benchmark grade, material substitution adjustment is performed. This process does not involve price difference processing; it only involves processing the project quantity and materials.

[0048] The steel bar type is adjusted, and the mechanical consumption and materials in the corresponding manufacturing and installation quota are adjusted according to the steel bars of different specifications. In this embodiment, the quota number is the process composition under the standard construction method. There may be two types of steel bars in the benchmark quota, and they correspond to different consumption amounts. Since the actual engineering quantity cannot be completely matched with the benchmark quota, the actual steel bars are counted item by item according to different steel bar types, and the corresponding quotas and engineering quantities are counted separately.

[0049] When adjusting the diameter of piles in the pile foundation hole, if the actual pile diameter is within the range given in the quota, the quota shall be corrected according to the specified coefficient, which is specified in the standard.

[0050] The adjustment of prestressed steel strands involves selecting and converting the corresponding quotas based on the type of steel strands (e.g., steel wire, steel strand), anchorage system, and tensioning process. This adjustment includes corrections to the number of strands, the number of holes, and the weight. The correction to the number of holes is based on a subordinate correspondence that establishes a one-to-one correspondence between the anchorage model used in the design and the rated anchorage model applied. The correction to the number of strands involves calculating the number of strands per ton of steel. Based on the difference between the actual calculated number of strands per ton and the quota standard value, the quota item is corrected using a "for every increase or decrease of one strand" approach. The correction factor is this difference. The format for the quota adjustment status is the quota number. The last item, multiplied by the correction factor, yields 8.806 strands per ton of steel strands. According to the quota, prestressed steel strands with a vertical length of 40m and 3 holes require 8.91 strands per ton. Therefore, a correction is needed. The correction quota benchmark is for each increase or decrease of 1 strand. Thus, the number of strands to be corrected is 8.806 - 8.91 = -0.104. The corrected quota number is 4-7-19-16. This quota number is matched with the quota number in the quota database based on the item to be corrected. Therefore, the quota adjustment status is: 16 × -0.104. The weight correction of the steel strands is based on the calculated number of strands per ton. The corrected weight of each steel strand is 1 ton divided by the corrected number of strands.

[0051] Furthermore, the haul distance adjustment involves calculating the increase or decrease of haul distance in the transport quota for mixed materials and components based on the actual distance between the mixing plant, prefabrication yard, and construction site. Specifically, the haul distance is determined by querying the transport equipment and mode of transport, and the budget quota for transport and the budget quota for haul distance correction are retrieved from the quota database. Simultaneously, according to the requirements of the remarks, the haul distance is corrected. Based on the difference between the actual transport distance and the budget quota for transport, combined with the haul distance step length specified in the quota (per increase or decrease in distance), the number of corrections is calculated, and adjustments are made using the quota item for "per increase or decrease in haul distance". This can be expressed as: Correction quota item number × [(actual haul distance - basic haul distance) / step length], i.e., the adjustment method is "+correction quota item number × number of times".

[0052] The quota adjustment status is a fixed field in the output template table. The modification of the quota adjustment status is output in a regularized manner, and the automatically output table realizes the automatic improvement of the quota adjustment status.

[0053] Finally, the basic quantity calculation tables of several bridges can be merged into a single summary quantity calculation table for a single bridge. The output will include all the quota numbers used for the bridges, and each quota number will contain the quantities of multiple different bridges, representing the total quantity of the multiple bridges.

[0054] As an example, taking "drilled cast-in-place piles" as an example, the main contents include the correction of concrete material quota, the correction of steel bar type quota, the correction of pile diameter quota for hole forming process, and the correction of material transportation distance quota.

[0055] Adjustment of steel reinforcement type: When the consumption of HPB300 and HRB400 corresponding to the quota number in the steel reinforcement quota library table is different from the actual steel reinforcement usage in the project, an adjustment is made. There are two main adjustment methods, as shown in Table 1. The adjustment method in this example is the processing method required by the cost estimation software.

[0056] Table 1 Example of steel reinforcement consumption

[0057] In the table above, 2001001, 2001002, and 2001003 are the codes for different types of steel bars in the quota library. Specifically, 2001001 represents HPB300 steel bars, 2001002 represents HRB400 steel bars, and 2001003 represents cold-rolled ribbed steel mesh. All of these are commonly used materials in highways and are defined in industry standards. X represents the steel bar consumption in the quota specification; "2001001 quantity X" means that the consumption of HPB300 steel bars is X. "2001002 quantity 0" means that the consumption of HRB400 steel bars is zero. "2001001 quantity 0, 2001002 quantity X; 2001002 replaced by 2001003" means that the consumption of HPB300 steel bars is zero, the consumption of HRB400 steel bars is X, and cold-rolled ribbed steel mesh is used to replace HRB400 steel bars, and the quota is re-priced.

[0058] Concrete type adjustment: When adjusting the concrete quota, the concrete quota adjustment status format is "C20-32.5-4 to C25-32.5-4". Here, "C20" represents the type of concrete, which is obtained through design principles; "C20" represents the concrete type, which is obtained through design engineering quantity data; "32.5" refers to the cement mortar strength, which is obtained through design principles; and "4" represents the crushed stone particle size, which is not adjusted by default.

[0059] Adjustment of pile diameter quota for pile foundation drilling: When the designed pile diameter is different from the pile diameter used in the quota, it shall be corrected according to the preset rules, as shown in Tables 2-3. Table 2 Pile Diameter Correction Rules

[0060] Table 3 Continued Table of Pile Diameter Correction Rules

[0061] Transportation Distance Adjustment: The transportation distance is retrieved from the design specifications based on the transportation equipment and method. The transportation budget quota and the transportation distance correction budget quota are then obtained from the quota database. According to the requirements in the remarks, the transportation distance is corrected. Specifically, the transportation quota number is retrieved from the quota database. The format of the quota adjustment status is the last item of the quota number multiplied by the correction coefficient, i.e., the number of corrections. The correction coefficient is determined by the actual transportation distance, the basic transportation distance, and the step size. The adjustment status is "+corrected quota item number × number of corrections". The quota database specifies that the first 1km of concrete transportation is the basic transportation distance, with a step size of 0.5km. Taking "8m³ mixer truck transporting concrete 4.5km" as an example, the transportation budget quota is for the first 1km, and the transportation distance correction is 0.5km. Therefore, (4.5-1) / 0.5=7. Thus, the quota adjustment status for transportation distance correction is: +27×7.

[0062] The quota adjustment proposed in this embodiment is a crucial step in ensuring that the cost calculation results accurately reflect the actual project conditions. The statistical items in highway engineering quotas are essentially consumption benchmarks compiled based on standard construction conditions, conventional material combinations, and typical processes and methods. However, in actual projects, design specifications, site conditions, construction techniques, or resource organization methods often differ from the "standard state" set by the quotas. Therefore, it is essential to make compliant and reasonable coefficient adjustments or content replacements to the relevant quotas (such as material model replacement, machinery combination changes, and process coefficient conversions) according to the specific circumstances of the project. Only then can the calculated project cost accurately reflect the actual project conditions and truly reflect its resource consumption and economic value.

[0063] This invention aims to optimize the traditional engineering cost estimation model. In the traditional process, designers must manually fill out quantity tables based on cost requirements, and cost estimators then perform tedious manual data entry and quota calculations. This process is lengthy, inefficient, and prone to errors. This technology enables direct data flow from the 3D design model to the cost estimation software, shortening the preparation cycle of the basic quantity calculation table from several days or even weeks to several hours or even real-time generation. Overall work efficiency is improved by over 60%, effectively shortening the budget preparation cycle and extending the professional design time. This not only greatly improves design collaboration and feedback efficiency but also ensures 100% consistency between quantities and design results through an automated rule engine. The bill of quantities and quota specifications are automatically matched. The generated basic quantity calculation table includes data processing for the entire process, including quantity conversion, quota application, rate determination, and quota correction. Subsequent calculations only require applying unit prices, achieving complete matching between design and cost quantities. This fundamentally eliminates errors and omissions in manual processes, achieving a double leap in efficiency and quality.

[0064] Example 2 In one or more embodiments, a basic quantity take-off table generation system for bridge budgets is disclosed, specifically including: The data acquisition module is configured to acquire design engineering quantity data, which includes component codes, material codes, units of measurement, quantities, and attribute information. The quota construction module is configured to: construct a structured quota database and design principles. The quota database is based on highway engineering estimate quotas, budget quotas, and supporting supplementary quotas. It extracts features of the applicable conditions and work content of quota statistical items to form multi-feature combination retrieval tags. The design principles supplement the key pricing information not included in the design results. The key pricing information includes construction technology, equipment type, transportation conditions, and material specifications. The mapping and association module is configured to: generate search conditions based on the component codes, material codes and attribute information in the design engineering quantity data, combined with the additional conditions in the design principles, and automatically retrieve and match the corresponding quota statistical entries from the quota database; The bill of quantities generation module is configured to: based on the matched quota statistics items, and combined with the preset quota adjustment rules, perform coefficient correction or content replacement on the quotas to generate a basic quantity calculation table for the budget, which includes information on quantity conversion, quota application, rate determination, and quota correction.

[0065] Example 3 This embodiment provides an electronic device, including a memory and a processor, as well as computer instructions stored in the memory and running on the processor. When the computer instructions are executed by the processor, they complete the steps of the above-described method for generating a basic quantity survey table for bridge budget.

[0066] Example 4 This embodiment provides a computer-readable storage medium for storing computer instructions, which, when executed by a processor, complete the steps of the above-described method for generating a basic quantity take-off table for bridge budgeting.

[0067] 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.

[0068] 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.

[0069] These computer program instructions may also be loaded onto a computer or other programmable data processing equipment, whereby a series of operational steps are performed 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.

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

[0071] The above description is merely a preferred embodiment of the present invention and is not intended to limit the invention. Various modifications and variations can be made to the present invention by those skilled in the art. Any modifications, equivalent substitutions, improvements, etc., made within the spirit and principles of the present invention should be included within the scope of protection of the present invention.

Claims

1. A method for generating a basic quantity calculation table for bridge budgeting, characterized in that, include: Obtain design engineering quantity data, which includes component code, material code, unit of measurement, quantity and attribute information; A structured quota database and design principles are constructed. The quota database is based on highway engineering estimate quotas, budget quotas, and supporting supplementary quotas. The applicable conditions and work contents of the quota statistical items are extracted to form multi-feature combination retrieval tags. The design principles supplement the key pricing information not included in the design results. The key pricing information includes construction technology, equipment type, transportation conditions, and material specifications. Based on the component codes, material codes and attribute information in the design engineering quantity data, and combined with the additional conditions in the design principles, search conditions are generated to automatically retrieve and match the corresponding quota statistical entries from the quota database. Based on the matched quota statistics items, and combined with the preset quota adjustment rules, the quota coefficients are corrected or the content is replaced to generate a basic quantity calculation table for the budget, which includes information on quantity conversion, quota application, rate determination and quota correction.

2. The method for generating a basic quantity survey table for bridge budgeting as described in claim 1, characterized in that, The basic quantity calculation table includes a project table and a sub-item table. The project table is a table that is subdivided into the smallest level according to the function of each profession. Its level includes part-item-section-detail, and its numbering system consists of a fixed number of digits. The sub-item table is a table that is broken down into the smallest component according to the structural composition within a profession. Its level includes part number, sub-item number, and sub-sub-item number. The output of the basic quantity calculation table includes the hierarchy, project section number, rate number, quota code, name of project or item or section or sub-item or quota, unit of measurement, quantity, design quantity, quota adjustment status and quota database.

3. The method for generating a basic quantity calculation table for bridge budgeting as described in claim 1, characterized in that, The quota database is based on highway engineering preliminary estimate quotas, budget quotas, and supporting supplementary quotas. It extracts features from the applicable conditions and work content of quota statistical items to form multi-feature combination search tags, including: Feature extraction involves labeling the applicable conditions and work content of each quota statistical item to filter out quota numbers that meet the requirements. The multi-feature combination retrieval tags establish an index for each quota statistical item, and the retrieval is carried out by component name or code, construction technology, equipment type, material specifications, pile diameter range, hole depth range and soil classification combination conditions.

4. The method for generating a basic quantity calculation table for bridge budgeting as described in claim 1, characterized in that, The preset quota adjustment rules include adjustments for concrete type, steel bar type, pile diameter for pile foundation drilling, prestressed steel strands, and transport distance. Specifically, the adjustments include: concrete type adjustment, which involves converting and processing price differences for the benchmark concrete material based on the concrete and mortar grades; steel bar type adjustment, which involves adjusting the mechanical consumption and materials in the corresponding manufacturing and installation quotas according to different specifications of steel bars; pile diameter adjustment, which involves correcting the quota according to the prescribed coefficient when the actual pile diameter is within the range given in the quota; prestressed steel strand adjustment, which involves selecting and converting the corresponding quotas based on the type of steel strand, anchor system, and tensioning process; and transportation distance adjustment, which involves calculating the increase or decrease in transportation distance for the mixed materials and components based on the actual distance between the mixing plant, prefabrication yard, and construction site.

5. The method for generating a basic quantity calculation table for bridge budgeting as described in claim 4, characterized in that, The adjustment of the prestressed steel strands includes the correction of the number of strands and the number of holes; Among them, the correction of the number of holes is to correct the number of holes according to the subordinate correspondence relationship, which sets a one-to-one correspondence between the anchor model used in the design and the rated anchor model applied. Correction of bundle count: Calculate the number of bundles per ton of steel, and based on the difference between the actual calculated number of bundles per ton of steel and the standard value, correct the quota item by "for every increase or decrease of 1 bundle".

6. The method for generating a basic quantity calculation table for bridge budgeting as described in claim 4, characterized in that, The aforementioned distance adjustment specifically involves querying the transportation distance based on the transportation equipment and mode, retrieving the transportation budget quota and the distance correction budget quota from the quota database, and then correcting the distance according to the requirements of the remarks. Based on the difference between the actual transportation distance and the transportation budget quota, and combined with the distance step length specified in the quota, the number of corrections is calculated, and adjustments are made using the quota item of "each increase or decrease in transportation distance", expressed as: Correction quota sub-item number × [(actual transportation distance - basic transportation distance) / step length].

7. The method for generating a basic quantity calculation table for bridge budgeting as described in claim 1, characterized in that, The basic quantity calculation tables of several bridges are merged into a single summary quantity calculation table for a single bridge. All quota numbers used for the bridges are output, and each quota number contains the quantities of multiple different bridges, representing the total quantity of the multiple bridges.

8. A system for generating a basic quantity calculation table for bridge budgeting, characterized in that, include: The data acquisition module is configured to acquire design engineering quantity data, which includes component codes, material codes, units of measurement, quantities, and attribute information. The quota construction module is configured to: construct a structured quota database and design principles. The quota database is based on highway engineering estimate quotas, budget quotas, and supporting supplementary quotas. It extracts features of the applicable conditions and work content of quota statistical items to form multi-feature combination retrieval tags. The design principles supplement the key pricing information not included in the design results. The key pricing information includes construction technology, equipment type, transportation conditions, and material specifications. The mapping and association module is configured to: generate search conditions based on the component codes, material codes and attribute information in the design engineering quantity data, combined with the additional conditions in the design principles, and automatically retrieve and match the corresponding quota statistical entries from the quota database; The bill of quantities generation module is configured to: based on the matched quota statistics items, and combined with the preset quota adjustment rules, perform coefficient correction or content replacement on the quotas to generate a basic quantity calculation table for the budget, which includes information on quantity conversion, quota application, rate determination, and quota correction.

9. An electronic device, characterized in that, The method includes a memory and a processor, as well as computer instructions stored in the memory and running on the processor, which, when executed by the processor, complete the method for generating a basic quantity take-off table for bridge budgets as described in any one of claims 1-7.

10. A computer-readable storage medium, characterized in that, Used to store computer instructions, which, when executed by a processor, complete the method for generating a basic quantity take-off table for bridge budgets as described in any one of claims 1-7.

Images