A highway engineering cost preparation method and device, an electronic device, and a storage medium

Abstract

The present application provides a highway engineering cost preparation method, device, electronic equipment and storage medium, by obtaining the to-be-processed engineering quantity table, obtaining the to-be-processed information based on the to-be-processed engineering quantity table, wherein the to-be-processed information includes current project key information and current construction method information, determining the current quota information from the preset quota retrieval library based on the current project key information and the current construction method information, determining the current group price scheme from the preset group price scheme library based on the current quota information, selecting the current project section from the preset project section library based on the current project key information, and generating the original data table that can be imported into the cost software based on the current group price scheme and the current project section. The original data table that can be imported into the cost software can be quickly generated without manually establishing the corresponding relationship between the quantity table and the budget book, thereby improving the accuracy and efficiency of the engineering cost budget book preparation and improving the rationality of the group price scheme.

Description

Technical Field

[0001] This invention relates to the field of highway engineering cost estimation technology, and in particular to a method, apparatus, electronic device and storage medium for highway engineering cost estimation. Background Technology

[0002] In recent years, highway projects have seen an explosive growth, characterized by a large number of projects, long routes, numerous structures, and tight schedules.

[0003] Currently, highway engineering project cost estimation methods typically rely on human-computer interaction, resulting in low efficiency and high human resource investment. For example, the Tongwang Engineering Cost Management Software has a quantity collection function, requiring cost estimators to manually apply quota pricing and import the quantity table into the software. Then, cost estimators fill in the quantities in the budget. In other words, the Tongwang Engineering Cost Management Software requires cost estimators to manually establish the correspondence between the quantity table and the budget. When items in the quantity table need to be changed, cost estimators must re-establish the correspondence between the quantity table and the budget, severely limiting efficiency and applicability.

[0004] How to quickly and intelligently compile highway engineering cost estimates is an important issue that the industry urgently needs to address. Summary of the Invention

[0005] This invention provides a method, apparatus, and electronic device for compiling highway engineering costs, which addresses the shortcomings of existing technologies in quickly and intelligently compiling engineering costs, thereby enabling rapid and intelligent compilation of highway engineering costs.

[0006] This invention provides a method for compiling highway engineering cost estimates, the method comprising:

[0007] Get the list of pending projects;

[0008] Based on the table of the number of projects to be processed, information to be processed is obtained, wherein the information to be processed includes key information of the current project and information of the current construction method;

[0009] Based on the current project key information and the current construction method information, the current quota information is determined from the preset quota retrieval database;

[0010] Based on the current quota information, the current pricing scheme is determined from the preset pricing scheme library;

[0011] Based on the key information of the current project, select the current project section from the preset project section library;

[0012] Based on the current pricing scheme and the current project section, a raw data table that can be imported into cost estimation software is generated.

[0013] Optionally, the information to be processed may also include current parameter information and / or a list of current measures;

[0014] The step of determining the current quota information from a preset quota retrieval database based on the current project key information and the current construction method information includes:

[0015] Based on the current project key information, the current construction method information, and the current parameter information, determine the current quota information from a preset quota retrieval database; and / or,

[0016] Based on the current project key information, the current construction method information, and the current measures list, the current quota information is determined from the preset quota retrieval database.

[0017] Optionally, the preset pricing scheme library includes quota quantity extraction schemes and itemized project pricing schemes, wherein the preset pricing scheme library includes the correspondence between itemized project pricing schemes and quota quantity extraction schemes.

[0018] The step of determining the current pricing scheme from a preset pricing scheme library based on the current quota information includes:

[0019] Based on the current quota information and the preset pricing scheme library, determine the current sub-item pricing scheme;

[0020] If the quantity of work corresponding to the current sub-item pricing scheme does not meet the preset quantity conditions, the current quota quantity extraction scheme is determined based on the current sub-item pricing scheme and the preset pricing scheme library.

[0021] Based on the current pricing scheme for the sub-item project and the current quota quantity extraction scheme, the current pricing scheme is determined.

[0022] Optionally, after the step of determining the current sub-item project pricing scheme based on the current quota information and the preset pricing scheme library, the method further includes:

[0023] If the quantity of work corresponding to the current sub-item pricing scheme meets the preset quantity conditions, the current sub-item pricing scheme shall be used as the current pricing scheme.

[0024] Optionally, the preset pricing scheme library includes the correspondence between sub-schemes and quota engineering quantity information;

[0025] The step of determining the current quota quantity extraction scheme based on the current sub-item project pricing scheme and the preset pricing scheme library includes:

[0026] The sub-scheme that does not have a corresponding quantity of work in the current sub-item pricing scheme is selected as the current sub-scheme.

[0027] Based on the current sub-scheme and the preset pricing scheme library, the current quota quantity information corresponding to the current sub-scheme is determined as the current quota quantity extraction scheme.

[0028] Optionally, the step of obtaining the information to be processed based on the quantity table of projects to be processed includes:

[0029] Identify the row headers and list headers of the quantity table of the projects to be processed;

[0030] Based on a pre-defined header keyword library, determine the key information for the current project;

[0031] Based on a pre-set construction method library, the current construction method information is determined.

[0032] Optionally, before the step of determining the current quota information from a preset quota retrieval database based on the current project key information and the current construction method information, the method further includes:

[0033] Based on the key information of standard items, the list of standard measures, the information of standard construction methods, and the keywords of standard parameters in the standard quantity table, quota retrieval keywords are generated;

[0034] Based on the pre-acquired adjustment information of quota items, determine the quota adjustment information;

[0035] The quota retrieval database is generated based on the quota retrieval keywords and the quota adjustment information.

[0036] The present invention also provides a highway engineering cost estimation device, the device comprising:

[0037] The first acquisition module is used to acquire a table of the number of projects to be processed.

[0038] The second acquisition module is used to acquire information to be processed based on the quantity table of projects to be processed, wherein the information to be processed includes key information of the current project and information of the current construction method;

[0039] The first determining module is used to determine the current quota information from a preset quota retrieval library based on the current project key information and the current construction method information;

[0040] The second determining module is used to determine the current pricing scheme from a preset pricing scheme library based on the current quota information.

[0041] The selection module is used to select the current project section from a preset project section library based on the key information of the current project;

[0042] The first generation module is used to generate an original data table that can be imported into cost estimation software based on the current pricing scheme and the current project section.

[0043] The present invention also provides an electronic device, including a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein the processor executes the program to implement the steps of any of the above-described methods for compiling highway engineering costs.

[0044] The present invention also provides a non-transitory computer-readable storage medium having a computer program stored thereon, which, when executed by a processor, implements the steps of the highway engineering cost estimation method described above.

[0045] The present invention also provides a computer program product, including a computer program that, when executed by a processor, implements the steps of any of the above-described methods for compiling highway engineering cost estimates.

[0046] This invention provides a method, apparatus, electronic device, and storage medium for compiling highway engineering cost estimates. The method involves acquiring a quantity table of works to be processed, obtaining information to be processed based on this table, including key information about the current project and current construction methods. Based on this information, the method determines current quota information from a pre-set quota retrieval library, then determines a current pricing scheme from a pre-set pricing scheme library, and finally selects a current project section from a pre-set project section library based on the key information. Finally, based on the current pricing scheme and the current project section, a raw data table that can be imported into cost estimation software is generated. This method allows for the rapid generation of raw data tables that can be imported into cost estimation software without manually establishing the correspondence between the quantity table and the budget, thereby improving the accuracy and efficiency of engineering cost budget preparation and enhancing the rationality of the pricing scheme. Attached Figure Description

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

[0048] Figure 1 This is one of the flowcharts illustrating the highway engineering cost estimation method provided by the present invention;

[0049] Figure 2 This is a schematic diagram of the original data table provided by the present invention;

[0050] Figure 3This is the second flowchart illustrating the highway engineering cost estimation method provided by the present invention;

[0051] Figure 4 This is a schematic diagram of the structure of the highway engineering cost estimation device provided by the present invention;

[0052] Figure 5 This is a schematic diagram of the structure of the electronic device provided by the present invention. Detailed Implementation

[0053] To make the objectives, technical solutions, and advantages of this invention clearer, the technical solutions of this invention will be clearly and completely described below with reference to the accompanying drawings. Obviously, the described embodiments are only some, not all, of the embodiments of this invention. All other embodiments obtained by those skilled in the art based on the embodiments of this invention without creative effort are within the scope of protection of this invention.

[0054] To enable rapid and intelligent compilation of highway engineering cost estimates, this invention provides a method, apparatus, electronic device, non-transitory computer-readable storage medium, and computer program product for compiling highway engineering cost estimates. The following is a detailed description... Figure 1 This invention describes a method for compiling highway engineering cost estimates.

[0055] like Figure 1 As shown, this invention discloses a method for compiling highway engineering cost estimates, the method comprising:

[0056] S101, Obtain the table of the number of projects to be processed.

[0057] When a user needs to obtain the project cost, such as the cost of earthwork, pavement, conventional bridges and culverts, or mountain tunnels for a highway project, they can input the corresponding quantity table into the software installed on the electronic device. The electronic device can then retrieve the quantity table to be processed. For example, a user can input the quantity table into the China Communications Construction Company's intelligent cost estimation system installed on the electronic device, and the device will then retrieve the quantity table to be processed.

[0058] S102, Obtain the information to be processed based on the quantity table of projects to be processed.

[0059] After obtaining the quantity list of projects to be processed, the quantity list can be identified to obtain the information to be processed, which includes key information of the current project and information of the current construction method.

[0060] The key information for the current project can be the header information of the quantity table of works to be processed. For example, for bridge and culvert projects, the key information for the current project could be the superstructure, precast T-beams, etc. The current construction method information can be the construction method corresponding to the items included in the quantity table of works to be processed. For example, the construction method corresponding to the excavation of earthen steps in roadbed engineering is: excavator.

[0061] S103, Based on the current project key information and the current construction method information, determine the current quota information from the preset quota retrieval library.

[0062] After obtaining the information to be processed, namely the key information of the current project and the current construction method, the current quota information can be determined from a preset quota retrieval database based on the key information of the current project and the current construction method. The preset quota retrieval database stores multiple quota information entries, which can consist of a number, construction method information, key project information, etc.

[0063] In one implementation, the number corresponding to the current quota information can be determined from a preset quota retrieval library based on the current project key information and the current construction method information. For example, if the current project key information is a precast T-beam and the current construction method information is non-pumped concrete, the number corresponding to the current quota information can be determined as 4-7-14-1 from the preset quota retrieval library based on the precast T-beam and non-pumped concrete, and thus the current quota information 4-7-14-1 precast T-beam non-pumped concrete can be obtained.

[0064] S104. Based on the current quota information, determine the current pricing scheme from the preset pricing scheme library.

[0065] Since the preset pricing scheme library stores quota information and the corresponding relationship between pricing schemes, after determining the current quota information, the current pricing scheme can be determined from the preset pricing scheme library based on the current quota information.

[0066] The pricing scheme can specify the logical relationship between the quota information and the standard quota information, which is independent of the quantity table. The current standard quota information is determined based on the information in the quantity table of the project to be processed. The pricing scheme includes the scheme and corresponding project quantity that are not recorded in the quantity table of the project to be processed but are required in the actual construction process.

[0067] S105, Based on the key information of the current project, select the current project section from the preset project section library.

[0068] After obtaining the key information of the current project, a current project section can be selected from a preset project section library. This library stores the correspondence between key project information and project sections. Project sections can standardize pricing schemes, and the current project section can standardize the current pricing scheme.

[0069] In one implementation, the key information of the current project may include the project type. For example, the key information of the current project may be pavement engineering, roadbed engineering, or bridge and culvert engineering, which is reasonable. Then, the corresponding current project section can be selected based on the key information of the current project. For example, the pavement standard project section can be selected as the current project section based on pavement engineering.

[0070] For example, a standard pavement item section can be shown in Table 1 below. Table 1 is for illustrative purposes only and does not represent a complete list of standard pavement item sections.

[0071] Table 1

[0072]

[0073]

[0074] The current project section includes the item code, purpose code, section code, sub-item code, and the name and unit of the item, sub-item, section, sub-item, or quota.

[0075] S106. Based on the current pricing scheme and the current project section, generate an original data table that can be imported into the cost estimation software.

[0076] After determining the current pricing scheme and the current project section, a raw data table that can be imported into cost estimation software can be generated based on the current pricing scheme and the current project section. As one implementation method, the detailed information of the projects included in the current pricing scheme can be correlated with the content included in the project section to generate a raw data table that can be imported into cost estimation software. For example, the raw data table can be as follows: Figure 2 As shown, Figure 2 This is only an illustrative raw data table and is not a complete raw data table.

[0077] In one implementation, the generated raw data table can be directly imported into the cost estimation software to generate the project budget, without the need to manually establish the correspondence between the quantity table and the budget, thereby improving the accuracy and efficiency of the engineering cost budget preparation and the rationality of the pricing scheme.

[0078] As one embodiment of the present invention, the above-mentioned information to be processed may further include at least one of the following: current parameter information and current measure list.

[0079] The above-mentioned step of determining the current quota information from a preset quota retrieval database based on the current project key information and the current construction method information may include:

[0080] Because different quantity tables contain different information, and the quantity tables contain a large number of items, there are three ways to obtain the information to be processed based on the quantity table of the project to be processed:

[0081] The first method is to determine the current quota information from a preset quota retrieval database based on the current project's key information, current construction method information, and current parameter information.

[0082] In one implementation, the current parameter information can be determined based on a preset project parameter library, which may include information such as self-built concrete mixing plants, commercial concrete, the number of concrete mixing plants, the road distance of the mixing plants, the transport distance of the precast yard, the ton-kilometer freight cost for exceeding the transport distance, altitude, construction period, and beam fabrication cycle.

[0083] As one implementation method, a preset project parameter library stores parameter information codes. In this way, the current parameter information obtained based on the quantity table of projects to be processed can be the parameter information code corresponding to the parameter information, which can speed up the determination of the current parameter information.

[0084] For example, a preset project parameter library can be shown in Table 2 below. Note that Table 2 is only illustrative and does not represent a complete preset project parameter library.

[0085] Table 2

[0086] Serial Number name unit code name value Remark 1 Ton-kilometer freight Yuan / tkm dglyf 0.5 Market Inquiry 2 earthwork density t / m3 tfmd 1.4 Budget quota … … … … … … n Main storyline is long km zxc 1.11

[0087] The second method is to determine the current quota information from a pre-set quota retrieval database based on the current project's key information, current construction method information, and current measures list.

[0088] The third method is to determine the current quota information from a preset quota retrieval database based on the current project's key information, current construction method information, current measure list, and current parameter information.

[0089] As can be seen, this invention can determine the current quota information according to the engineering quantity table, thereby improving the accuracy and efficiency of determining the current quota information. This facilitates the generation of original data tables that can be imported into cost estimation software.

[0090] As one embodiment of the present invention, the aforementioned preset pricing scheme library may include quota quantity extraction schemes and itemized project pricing schemes. The preset pricing scheme library includes the correspondence between itemized project pricing schemes and quota quantity extraction schemes.

[0091] The steps described above for determining the current pricing scheme from a preset pricing scheme library based on the current quota information may include:

[0092] Based on the current quota information and the preset pricing scheme library, the pricing scheme for the current sub-item project is determined.

[0093] After obtaining the current quota information, the pricing scheme for the sub-item project corresponding to the current quota information can be determined from the preset pricing scheme library based on the current quota information as the current sub-item project pricing scheme.

[0094] For example, if the current quota information includes precast beams, the current sub-item pricing scheme can be selected from the preset pricing scheme library. This current sub-item pricing scheme represents the process required to construct the precast beams, specifically: 1. Precasting; 2. Removal from the pit; 3. Transportation; 4. Installation; 5. Concrete mixing; 6. Concrete transportation; 7. Precast platform; 8. Beam moving equipment; 9. Bridge erection equipment. In other words, the current sub-item pricing scheme includes schemes not recorded in the quantity table of pending works but required during actual construction.

[0095] After determining the current itemized project pricing scheme, it can be determined whether each sub-scheme in the current itemized project pricing scheme has a corresponding quantity of work. The quantity of work corresponding to the sub-scheme can be the current quantity of work included in the information to be processed based on the quantity table of work to be processed.

[0096] If the quantity of work corresponding to the current sub-item pricing scheme does not meet the preset quantity conditions, the current quota quantity extraction scheme can be determined based on the current sub-item pricing scheme and the preset pricing scheme library.

[0097] The preset quantity conditions can be set according to the actual project. The preset quantity can be that each sub-scheme has a corresponding quantity, or that the number of sub-schemes with corresponding quantities exceeds the preset value (e.g., the number of sub-schemes with corresponding quantities exceeds 90% of the total). Alternatively, it can be that all preset sub-schemes have corresponding quantities. All of these are reasonable and not specifically limited here.

[0098] After determining the current pricing scheme for the sub-item project and the current quota quantity extraction scheme, the current pricing scheme can be determined based on the current pricing scheme for the sub-item project and the current quota quantity extraction scheme.

[0099] If the quantity of work corresponding to the current itemized project pricing scheme meets the preset quantity conditions, that is, if the current quantity of work obtained based on the quantity table of work to be processed meets the preset quantity conditions, the current quota quantity extraction scheme can be used instead of obtaining the current itemized project pricing scheme.

[0100] As can be seen, the present invention can obtain a more accurate current pricing scheme by adopting different methods according to different situations of the current project quantity obtained from the project quantity table, thereby facilitating the generation of original data tables that can be imported into cost estimation software.

[0101] As one embodiment of the present invention, the above-mentioned preset pricing scheme library may include the correspondence between sub-schemes and quota engineering quantity information.

[0102] The steps for determining the current quota quantity extraction scheme based on the current itemized project pricing scheme and the preset pricing scheme library may include:

[0103] If the quantity of work corresponding to the current sub-item pricing scheme does not meet the preset quantity conditions, that is, if the sub-scheme in the current sub-item pricing scheme lacks a quantity of work, it can be determined that there is no sub-scheme with a corresponding quantity of work in the current sub-item pricing scheme, and this sub-scheme is taken as the current sub-scheme.

[0104] In one implementation, the current sub-scheme can be determined based on preset engineering quantity conditions. For example, if the preset engineering quantity condition is that the number of sub-schemes with corresponding engineering quantities is greater than a preset value, some sub-schemes can be selected as the current sub-scheme to ensure that the number of sub-schemes with engineering quantities is a preset value. Alternatively, if the preset engineering quantity condition is that all preset sub-schemes have corresponding engineering quantities, preset sub-schemes without corresponding engineering quantities can be selected as the current sub-scheme. Both of these approaches are reasonable.

[0105] Based on the current sub-scheme and the preset pricing scheme library, the current quota quantity information corresponding to the current sub-scheme is determined as the current quota quantity extraction scheme.

[0106] After determining the current sub-scheme, the current quota quantity information corresponding to the current sub-scheme can be determined from the preset pricing scheme library based on the current sub-scheme, thereby obtaining the current quota quantity extraction scheme.

[0107] As one embodiment of the present invention, the above-mentioned step of obtaining the information to be processed based on the quantity table of projects to be processed may include:

[0108] Identify the row headers and list headers of the quantity table of the project to be processed.

[0109] After obtaining the quantity table of the project to be processed, the row headers and list headers of the quantity table can be identified, thereby obtaining the information corresponding to the row headers and list headers of the quantity table.

[0110] In one implementation, the information corresponding to the list header can be read from top to bottom, or from bottom to top, based on the list of quantities of projects to be processed. Both are reasonable. Furthermore, the information corresponding to the row header can be read from left to right, or from right to left. This is also reasonable.

[0111] For example, based on a bridge engineering quantity table, the information corresponding to the table header can be read from top to bottom to obtain the superstructure, precast T-beams, and precast components. Alternatively, the information corresponding to the row header can be read from left to right to obtain the concrete (material), C50 (grade), and m... 3 (Unit), 120 (current project quantity) and steel reinforcement (material), HPB300 (model), kg (unit), 1200 (current project quantity).

[0112] Based on a pre-defined header keyword library, the key information for the current project is determined.

[0113] After obtaining the information corresponding to the row headers and the column headers, the key information of the current project can be determined based on a preset header keyword library. This preset header keyword library includes preset key project information.

[0114] In one implementation, it can be determined whether the corresponding information is stored in the preset header keyword library based on the information corresponding to the row header and the list header. If it exists, the information corresponding to the row header and the list header is determined to be the key information of the current project.

[0115] If some of the identified row header and column header information is not found in the preset header keyword library, it can be determined whether this information is key project information. If it is key project information, it is added to the preset header keyword library. If it is not key project information, it is discarded.

[0116] In one implementation, a preset header keyword library stores key information chains. Therefore, the information corresponding to the row header and the information corresponding to the list header can be linked together to form the current key information chain. This allows us to determine whether the preset header keywords store a key information chain corresponding to the current key information chain, thereby identifying the key information of the current project.

[0117] Based on a pre-set construction method library, the current construction method information is determined.

[0118] Based on a preset construction method library, it can determine whether the information obtained from the quantity table of the project to be processed has a corresponding construction method in the preset construction method library. If it does, the current construction method information can be determined. The preset construction method library stores preset construction methods and machinery model selections. The preset construction method library is determined based on design documents and construction organization plans. For example, the construction method library may include the selection of pumped concrete, non-pumped concrete, mixing machines that can achieve different functions, different models of concrete mixer trucks, single guide beam bridge erection machines, double guide beam bridge erection machines, rail flatcar transportation, freight truck transportation, gantry crane loading, crane loading, etc.

[0119] In one implementation, a preset construction method library stores search keywords corresponding to the construction methods. In this way, the current construction method information obtained based on the quantity table of projects to be processed can be the search keywords corresponding to the construction methods, which can speed up the determination of the current construction method information.

[0120] For example, a preset construction method library may be shown in Table 3 below. Table 3 is only illustrative and does not represent a complete preset construction method library.

[0121] Table 3

[0122]

[0123]

[0124] As one embodiment of the present invention, such as Figure 3 As shown, prior to the step of determining the current quota information from a preset quota retrieval database based on the current project key information and the current construction method information, the above method may further include:

[0125] S301 generates quota retrieval keywords based on key information of standard projects, standard measure lists, standard construction method information, and standard parameter keywords from the standard quantity table. The standard quantity table can be designed based on preset requirements. For example, it can be designed based on the cost preparation depth requirements of the newly compiled and supporting budget quotas of 2018, standardizing and fixing the units, names, summary locations, and formats in the standard quantity table. Alternatively, the standard quantity table can include requirements for the depth of budget preparation, project experience, units, names, summary locations, formats, and measure quantity lists.

[0126] Each cell in the standard quantity table can be expanded, specifically through a drop-down menu, allowing the standard quantity table to contain three-dimensional data. This improves the applicability of the standard quantity table to various types of engineering projects without increasing its length. Furthermore, the standard quantity table includes key information on standard projects, a list of standard measures, information on standard construction methods, and keywords for standard parameters. The list of standard measures helps avoid the need for repeated supplementation of quantities due to insufficient depth in quantity estimation.

[0127] S302, Based on the pre-acquired adjustment information of quota items, determine the quota adjustment information.

[0128] In order to improve the accuracy of compiling highway engineering cost estimates, adjustment information of quota items can be obtained, that is, all quota adjustment information corresponding to quota items can be obtained, and then, based on the obtained adjustment information of quota items, quota adjustment information can be determined.

[0129] In some cases, because the quota names obtained in actual work may not correspond one-to-one with the quota search keywords, there may be situations where a quota name does not have a corresponding quota, and other quotas need to be borrowed. In such cases, the quota name can be broken down into several keywords, each keyword translated into a commonly used term, and the information corresponding to the borrowed quota situation can be stored in the quota adjustment information. In other words, the quota adjustment information includes information corresponding to the borrowed quota situation. The quota adjustment information can also include information on changes in labor, materials, and machinery, codes, consumption quantities, etc.

[0130] S303, Generate the quota retrieval database based on the quota retrieval keywords and the quota adjustment information.

[0131] After obtaining the quota search keywords and quota adjustment information, a quota search database can be generated based on these keywords and information. This allows for the determination of the current quota information based on the information to be processed.

[0132] In one implementation, a quota adjustment formula can be generated based on the quota adjustment information, and this formula can cover all quota adjustment information. This allows for the subsequent determination of the current quota adjustment information based on the information to be processed.

[0133] In another implementation, quota adjustment status can be determined based on quota search keywords, and then the corresponding quota adjustment item can be determined based on the quota adjustment status. A quota adjustment statement corresponding to this process can be generated, thereby creating a quota adjustment statement library. This allows for subsequent determination of the current quota adjustment status based on the information to be processed.

[0134] As one implementation method, the current quota adjustment status can be stored in relation to its corresponding quota adjustment items. After the current pricing scheme is determined, the current quota adjustment information is stored in the current pricing scheme so that a raw data table that can be imported into the cost estimation software can be generated later.

[0135] As one embodiment of the present invention, the quantity table of the project to be processed can be a standard quantity table. When the quantity table of the project to be processed is a standard quantity table, the accuracy of generating the original data table that can be imported into the cost estimation software can be further improved.

[0136] As one embodiment of the present invention, the quantity table of works to be processed may include newly added items, that is, the quantity table of works to be processed includes information corresponding to non-standard quantity tables. When the quantity table of works to be processed is a non-standard quantity table, the quantity table of works to be processed can be compared with the standard quantity table to form an inspection report, thereby reminding the cost estimator to maintain it according to actual needs.

[0137] For example, after obtaining the quantity table A for the work to be processed, the corresponding information to be processed can be obtained from the information corresponding to the standard quantity table included in the quantity table A, thereby obtaining the corresponding current pricing scheme. For the information corresponding to the non-standard quantity table included in the quantity table A for the work to be processed, i.e., the information of newly added items, the information corresponding to the newly added items can be compared with the standard quantity table to generate an inspection report. Furthermore, prompts such as "Please manually supplement the quantity and quota" or "The entered quantity exceeds the original value range, please manually supplement the sub-item / quota quantity" can be displayed in the corresponding remarks position, allowing cost estimators to maintain the work as needed.

[0138] As one embodiment of the present invention, through manual input at regular or irregular intervals, electronic equipment can periodically or irregularly acquire new processes, new materials, and corresponding quotas, thereby enabling real-time updates to the quota retrieval library, construction method library, etc., so that the original data table that can be imported into cost estimation software can be generated more quickly and accurately based on the updated information.

[0139] As one embodiment of the present invention, when the quantity depth of the quantity list to be processed does not meet the requirements of the quota pricing, it can be determined from the bill of quantities whether the quantity list to be processed includes the quantity list of pile foundations, prestressed concrete, underwater bridge measures, cast-in-place beam measures, post-tensioned precast beam plane base, pre-tensioned hollow slab tensioning platform, pier type statistics, and other measures. This improves the accuracy of the project budget calculated based on the original data tables, while ensuring that the quantities corresponding to the bill of quantities are consistent with those in the quantity list to be processed. If the quantities corresponding to the bill of quantities are inconsistent with those in the quantity list to be processed, an early warning can be issued by displaying error messages, allowing cost estimators to make corrections and avoid errors. As one embodiment, detailed information about unclosed project names can be displayed as an early warning, allowing cost estimators to understand the specific situation. For example, an early warning message could be displayed stating, "Unclosed substructure pier types: 1. The main quantity list for the entire bridge does not have quantities related to hollow piers, but 7. The pier type statistics table includes hollow piers."

[0140] As one embodiment of the present invention, after generating the original data table that can be imported into the cost estimation software, it can intelligently check whether the quotas and quantities included in the original quantity table are reasonable. If they are not reasonable, the original data table will display messages corresponding to the quotas and quantities that need to be adjusted by the cost estimator, so that the cost estimator can adjust the original data table. For example, it can display messages such as "Please check if the quota quantities are repeated" or "This quota needs to be manually adjusted" to provide a prompt.

[0141] As one embodiment of the present invention, the original data table can be adjusted based on actual needs by receiving corresponding instructions. For example, ready-mixed concrete can be selected according to different project conditions. Another example is replacing low-grade cement with high-grade cement, i.e., replacing 325 cement with 425 cement, or 425 cement with 525 cement. After generating the original data table that can be imported into cost estimation software, it can be detected whether the original data table contains empty rows or columns. If empty rows or columns are detected, they can be deleted or hidden, thereby reducing the length of the original data table. As another embodiment of the present invention, after receiving the instruction to input multiple schemes for the construction method parameter table, construction method information and parameter information can be obtained for subsequent generation of the original data table. The instruction to input multiple schemes for the construction method parameter table can be triggered by the user entering information in the interface of the China Communications Construction Company's intelligent cost estimation system. It can also be triggered by the user importing a pre-edited Excel spreadsheet into the China Communications Construction Company's intelligent cost estimation system; both are reasonable.

[0142] The highway engineering cost estimation device provided by the present invention is described below. The highway engineering cost estimation device described below and the highway engineering cost estimation method described above can be referred to in correspondence.

[0143] like Figure 4 As shown, this invention discloses a highway engineering cost estimation device, the device comprising:

[0144] The first acquisition module 410 is used to acquire the quantity table of projects to be processed.

[0145] The second acquisition module 420 is used to acquire information to be processed based on the quantity table of projects to be processed, wherein the information to be processed includes key information of the current project and information of the current construction method.

[0146] The first determining module 430 is used to determine the current quota information from a preset quota retrieval library based on the current project key information and the current construction method information.

[0147] The second determining module 440 is used to determine the current pricing scheme from a preset pricing scheme library based on the current quota information.

[0148] The selection module 450 is used to select the current project section from the preset project section library based on the current project key information.

[0149] The first generation module 460 is used to generate an original data table that can be imported into cost estimation software based on the current pricing scheme and the current project section.

[0150] As one embodiment of the present invention, the above-mentioned information to be processed may also include current parameter information and / or a list of current measures.

[0151] The aforementioned first determining module 430 may include:

[0152] The first determining unit is configured to determine current quota information from a preset quota retrieval database based on the current project key information, the current construction method information, and the current parameter information; and / or,

[0153] Based on the current project key information, the current construction method information, and the current measures list, the current quota information is determined from the preset quota retrieval database.

[0154] As one embodiment of the present invention, the above-mentioned preset pricing scheme library includes quota engineering quantity extraction scheme and itemized engineering pricing scheme.

[0155] The preset pricing scheme library includes the correspondence between the pricing schemes for sub-items and the quota quantity extraction schemes.

[0156] The second determining module 440 mentioned above may include:

[0157] The second determining unit is used to determine the current sub-item project pricing scheme based on the current quota information and the preset pricing scheme library;

[0158] The third determining unit is used to determine the current quota quantity extraction scheme based on the current sub-item pricing scheme and the preset pricing scheme library when the quantity of work corresponding to the current sub-item pricing scheme does not meet the preset quantity of work conditions.

[0159] The fourth determining unit is used to determine the current pricing scheme based on the current sub-item pricing scheme and the current quota quantity extraction scheme.

[0160] As one embodiment of the present invention, the above-mentioned apparatus may further include:

[0161] The third determining module is used, after the step of determining the current sub-item project pricing scheme based on the current quota information and the preset pricing scheme library, to take the current sub-item project pricing scheme as the current pricing scheme if the quantity of work corresponding to the current sub-item project pricing scheme meets the preset quantity of work conditions.

[0162] As one embodiment of the present invention, the above-mentioned preset pricing scheme library includes the correspondence between sub-schemes and quota engineering quantity information.

[0163] The aforementioned third determining unit may include:

[0164] The first determining sub-unit is used to determine the sub-scheme that does not have a corresponding quantity of work in the current sub-item pricing scheme, and then uses it as the current sub-scheme.

[0165] The second determining subunit is used to determine the current quota quantity information corresponding to the current sub-scheme based on the current sub-scheme and the preset pricing scheme library, and use it as the current quota quantity extraction scheme.

[0166] As one embodiment of the present invention, the second acquisition module 420 may include:

[0167] The identification unit is used to identify the row headers and list headers of the quantity table of the project to be processed.

[0168] The fifth determination unit is used to determine the key information of the current project based on a preset header keyword library.

[0169] The sixth determining unit is used to determine the current construction method information based on a preset construction method library.

[0170] As one embodiment of the present invention, the above-mentioned apparatus may further include:

[0171] The second generation module is used to generate quota retrieval keywords based on the standard project key information, standard measure list, standard construction method information and standard parameter keywords of the standard quantity table before the step of determining the current quota information from the preset quota retrieval library based on the current project key information and the current construction method information.

[0172] The fourth determination module is used to determine the quota adjustment information based on the pre-acquired quota item adjustment information.

[0173] The third generation module is used to generate the quota retrieval database based on the quota retrieval keywords and the quota adjustment information.

[0174] Figure 5 An example is a schematic diagram of the physical structure of an electronic device, such as... Figure 5 As shown, the electronic device may include a processor 510, a communications interface 520, a memory 530, and a communication bus 540. The processor 510, communications interface 520, and memory 530 communicate with each other via the communication bus 540. The processor 510 can call logical instructions stored in the memory 530 to execute the highway engineering cost estimation methods provided by the aforementioned methods.

[0175] Furthermore, the logical instructions in the aforementioned memory 530 can be implemented as software functional units and, when sold or used as independent products, can be stored in a computer-readable storage medium. Based on this understanding, the technical solution of the present invention, essentially, or the part that contributes to the prior art, or a part of the technical solution, can be embodied in the form of a software product. This computer software product is stored in a storage medium and includes several instructions to cause a computer device (which may be a personal computer, server, or network device, etc.) to execute all or part of the steps of the methods described in the various embodiments of the present invention. The aforementioned storage medium includes various media capable of storing program code, such as USB flash drives, portable hard drives, read-only memory (ROM), random access memory (RAM), magnetic disks, or optical disks.

[0176] On the other hand, the present invention also provides a computer program product, which includes a computer program that can be stored on a non-transitory computer-readable storage medium. When the computer program is executed by a processor, the computer is able to execute the highway engineering cost estimation method provided by the above methods.

[0177] In another aspect, the present invention also provides a non-transitory computer-readable storage medium having a computer program stored thereon, which, when executed by a processor, is implemented to perform the highway engineering cost estimation method provided by the above methods.

[0178] The device embodiments described above are merely illustrative. The units described as separate components may or may not be physically separate. The components shown as units may or may not be physical units; that is, they may be located in one place or distributed across multiple network units. Some or all of the modules can be selected to achieve the purpose of this embodiment according to actual needs. Those skilled in the art can understand and implement this without any creative effort.

[0179] Through the above description of the embodiments, those skilled in the art can clearly understand that each embodiment can be implemented by means of software plus necessary general-purpose hardware platforms, and of course, it can also be implemented by hardware. Based on this understanding, the above technical solutions, in essence or the part that contributes to the prior art, can be embodied in the form of a software product. This computer software product can be stored in a computer-readable storage medium, such as ROM / RAM, magnetic disk, optical disk, etc., and includes several instructions to cause a computer device (which may be a personal computer, server, or network device, etc.) to execute the methods described in the various embodiments or some parts of the embodiments.

[0180] Finally, it should be noted that the above embodiments are only used to illustrate the technical solutions of the present invention, and not to limit them; although the present invention has been described in detail with reference to the foregoing embodiments, those skilled in the art should understand that modifications can still be made to the technical solutions described in the foregoing embodiments, or equivalent substitutions can be made to some of the technical features; and these modifications or substitutions do not cause the essence of the corresponding technical solutions to deviate from the spirit and scope of the technical solutions of the embodiments of the present invention.

Claims

1. A method for compiling highway engineering cost estimates, characterized in that, The method includes: Get the list of pending projects; Based on the table of pending projects, information to be processed is obtained, wherein the information to be processed includes key information of the current project and information of the current construction method. The step of obtaining the information to be processed includes: Identify the row header and list header of the quantity table of the project to be processed. The list header supports reading order from top to bottom or bottom to top, and the row header supports reading order from left to right or right to left. The information corresponding to the row header and the information corresponding to the column header are linked together to form a key information chain. Using the key information chain, the key information of the current project is determined based on the preset column header keyword library. Based on a pre-set construction method library, determine the current construction method information; Based on the current project key information and the current construction method information, the current quota information is determined from the preset quota retrieval database; Based on the current quota information, the current pricing scheme is determined from the preset pricing scheme library; Based on the key information of the current project, select the current project section from the preset project section library; Based on the current pricing scheme and the current project section, a raw data table that can be imported into cost estimation software is generated.

2. The method according to claim 1, characterized in that, The information to be processed also includes current parameter information and / or a list of current measures; The step of determining the current quota information from a preset quota retrieval database based on the current project key information and the current construction method information includes: Based on the current project key information, the current construction method information, and the current parameter information, the current quota information is determined from the preset quota retrieval library; And / or, Based on the current project key information, the current construction method information, and the current measures list, the current quota information is determined from the preset quota retrieval database.

3. The method according to claim 1, characterized in that, The preset pricing scheme library includes quota quantity extraction schemes and itemized project pricing schemes, wherein the preset pricing scheme library includes the correspondence between itemized project pricing schemes and quota quantity extraction schemes. The step of determining the current pricing scheme from a preset pricing scheme library based on the current quota information includes: Based on the current quota information and the preset pricing scheme library, determine the current sub-item pricing scheme; If the quantity of work corresponding to the current sub-item pricing scheme does not meet the preset quantity conditions, the current quota quantity extraction scheme is determined based on the current sub-item pricing scheme and the preset pricing scheme library. Based on the current pricing scheme for the sub-item project and the current quota quantity extraction scheme, the current pricing scheme is determined.

4. The method according to claim 3, characterized in that, After the step of determining the current sub-item project pricing scheme based on the current quota information and the preset pricing scheme library, the method further includes: If the quantity of work corresponding to the current sub-item pricing scheme meets the preset quantity conditions, the current sub-item pricing scheme shall be used as the current pricing scheme.

5. The method according to claim 3, characterized in that, The preset pricing scheme library includes the correspondence between sub-schemes and quota engineering quantity information; The step of determining the current quota quantity extraction scheme based on the current sub-item project pricing scheme and the preset pricing scheme library includes: The sub-scheme that does not have a corresponding quantity of work in the current sub-item pricing scheme is selected as the current sub-scheme. Based on the current sub-scheme and the preset pricing scheme library, the current quota quantity information corresponding to the current sub-scheme is determined as the current quota quantity extraction scheme.

6. The method according to any one of claims 1-5, characterized in that, Before the step of determining the current quota information from a preset quota retrieval database based on the current project key information and the current construction method information, the method further includes: Based on the key information of standard items, the list of standard measures, the information of standard construction methods, and the keywords of standard parameters in the standard quantity table, quota retrieval keywords are generated; Based on the pre-acquired adjustment information of quota items, determine the quota adjustment information; The quota retrieval database is generated based on the quota retrieval keywords and the quota adjustment information.

7. A highway engineering cost estimation device, characterized in that, The device includes: The first acquisition module is used to acquire a table of the number of projects to be processed. The second acquisition module is used to acquire pending information based on the pending project quantity table, wherein the pending information includes key information of the current project and information of the current construction method, and the step of acquiring the pending information includes: Identify the row header and list header of the quantity table of the project to be processed. The list header supports reading order from top to bottom or bottom to top, and the row header supports reading order from left to right or right to left. The information corresponding to the row header and the information corresponding to the column header are linked together to form a key information chain. Using the key information chain, the key information of the current project is determined based on the preset column header keyword library. Based on a pre-set construction method library, determine the current construction method information; The first determining module is used to determine the current quota information from a preset quota retrieval library based on the current project key information and the current construction method information; The second determining module is used to determine the current pricing scheme from a preset pricing scheme library based on the current quota information. The selection module is used to select the current project section from a preset project section library based on the key information of the current project; The first generation module is used to generate an original data table that can be imported into cost estimation software based on the current pricing scheme and the current project section.

8. An electronic device comprising a memory, a processor, and a computer program stored in the memory and executable on the processor, characterized in that, When the processor executes the program, it implements the steps of the highway engineering cost estimation method as described in any one of claims 1 to 6.

9. A non-transitory computer-readable storage medium having a computer program stored thereon, characterized in that, When the computer program is executed by the processor, it implements the steps of the highway engineering cost estimation method as described in any one of claims 1 to 6.

Images