Complete price calculation method and device based on cost achievement file

Abstract

The invention discloses a cost achievement file-based price sum calculation method and device. The method comprises the following steps: acquiring a cost achievement file, wherein the cost achievement file comprises any one or more of a budget table, a budget table or a bill of quantity; importing the cost achievement file into a hierarchical database to form a price database and an engineering quantity list database which have an association relationship; according to a search column in the bill of quantity database, matching a corresponding contrast column in the price database; and assigning the price in the contrast column to the assignment column corresponding to the search column to obtain the combined price of the search column. According to the technical scheme, the construction cost achievement file is imported into the hierarchical database, the incidence relation between the price database and the project quantity list database is established, and the efficiency and accuracy of project cost calculation can be remarkably improved.

Description

Technical Field

[0001] This invention relates to the field of engineering management, and in particular to a method and apparatus for calculating total cost based on cost outcome documents. Background Technology

[0002] In construction projects, the preparation of cost estimates is a crucial step in project pricing. Cost estimates include preliminary estimates, budgets, and bills of quantities with prices. Preliminary estimates are typically based on the preliminary design of the project, providing a rough calculation of the total investment and its components. Budgets, based on construction drawings, predict and calculate project investment before construction begins. Bills of quantities with prices are used during the bidding or contract pricing stage, employing the bill of quantities and market prices to price the transaction. Cost estimates are usually in tabular form, following a basic structure of "item-quantity-unit price-total price." However, due to the large number of the smallest units constituting a project, cost estimates can have hundreds, thousands, or even more rows, leading to low preparation efficiency. Currently, there are two main methods for preparing cost estimates: one is to use spreadsheet software such as Excel directly, which, while intuitive, is inefficient. Even using Excel's lookup functions (such as VLOOKUP) to improve efficiency has limitations in handling similar mixed Chinese and English strings, efficient data extraction, and parallel lookups across multiple columns. Secondly, commercial cost estimation software is used. This software typically includes built-in budget quotas, bill of quantities libraries, and market price links for easy price lookup. However, these software programs still have limitations, such as the need to manually create each item in the bill of quantities and the inability to automatically generate full-cost market prices, thus restricting further improvements in efficiency. Currently, there is a lack of efficient and accurate cost estimation methods specifically designed for these project types. Therefore, how to properly address these issues has become a pressing issue for the industry. Summary of the Invention

[0003] This invention provides a method and apparatus for calculating total cost based on cost outcome documents. By importing cost outcome documents into a hierarchical database, a relationship is established between a price database and a bill of quantities database, which can significantly improve the efficiency and accuracy of engineering cost calculation.

[0004] According to a first aspect of the present invention, a method for calculating a total price based on a cost estimate document is provided, the method comprising: Obtain cost estimates documents, which include one or more of the following: a preliminary estimate, a budget, or a bill of quantities. The cost estimate documents are imported into a hierarchical database to form a price database and a bill of quantities database with related relationships. Based on the column search in the bill of quantities database, the corresponding matching column is found in the price database; The price in the comparison column is assigned to the corresponding assignment column of the lookup column to obtain the sum price of the lookup column.

[0005] In one embodiment, it also includes: The data columns in the bill of quantities database are categorized into retrieval and assignment categories; Align the retrieval data columns in the bill of quantities database with the column types in the price database.

[0006] In one embodiment, the step of searching for a column in the bill of quantities database and matching it with a corresponding reference column in the price database includes: The similarity between the search column and the comparison column is calculated using a preset similarity algorithm, which includes any one or more of Jaccard similarity, Levenshtein distance, Dice coefficient, cosine similarity, and similarity normalization. When the similarity is greater than the preset matching threshold, it is confirmed that the search column has a corresponding matching column in the price database.

[0007] In one embodiment, it also includes: Error detection is performed on the sum of the values ​​in the lookup column; The test results are compared with a preset reasonable price range, and data that does not conform to the preset reasonable price range is marked or an error report is generated.

[0008] In one embodiment, it includes: Regularly monitor newly generated cost estimates documents; The newly generated cost estimate documents are identified and imported, the bill of quantities database is adjusted based on the updated data, and the updated price data is re-stored into the price database.

[0009] In one embodiment, it also includes: The entire bill of quantities database is traversed, and the prices in the lookup columns are assigned to the corresponding assignment columns of the lookup columns one by one, thus forming a complete bill of quantities with prices.

[0010] According to a second aspect of the present invention, an apparatus for calculating a total price based on a cost estimate document is provided, comprising: The acquisition module is used to acquire cost result documents, which include one or more of the following: a preliminary estimate, a budget, or a bill of quantities. The import module is used to import the cost results files into the hierarchical database to form a price database and a bill of quantities database with related relationships. The matching module is used to search for columns in the bill of quantities database and match the corresponding reference columns in the price database. The assignment module is used to assign the price in the comparison column to the assignment column corresponding to the lookup column, so as to obtain the sum price of the lookup column.

[0011] In one embodiment, the acquisition module, the import module, the matching module, and the assignment module are controlled to execute any of the above-described methods for calculating the total cost based on the cost outcome document.

[0012] According to a third aspect of the present invention, an electronic device is provided, comprising: a communication interface, a processor, and a memory; The memory is used to store program instructions, which, when executed by the processor that is connected to the memory via the communication interface, implement any of the above-described methods for calculating the total cost based on the cost outcome document.

[0013] According to a fourth aspect of the present invention, a computer-readable storage medium is provided, on which computer program instructions are stored, which, when executed by a computer (e.g., a processor in the computer), implement any of the above-described methods for calculating the total cost based on cost outcome documents.

[0014] In summary, this invention provides a method and apparatus for calculating total cost based on cost outcome documents. The method includes: acquiring cost outcome documents, which include one or more of a preliminary estimate, a budget, or a bill of quantities; importing the cost outcome documents into a hierarchical database to form a price database and a bill of quantities database with an association; matching a corresponding reference column in the price database according to a lookup column in the bill of quantities database; and assigning the price in the reference column to the assignment column corresponding to the lookup column to obtain the total cost of the lookup column. The technical solution of this application significantly improves the efficiency and accuracy of engineering cost calculation by importing cost outcome documents into a hierarchical database and establishing an association between the price database and the bill of quantities database. Furthermore, the accuracy of price data is ensured by matching the lookup column and reference column using a preset similarity algorithm. Simultaneously, the method includes error detection of the total cost and comparison of reasonable price ranges, further improving data reliability. Regular monitoring and updating of the cost outcome documents ensures the timeliness and accuracy of the database.

[0015] Other features and advantages of the invention will be set forth in the description which follows, and will be apparent in part from the description, or may be learned by practicing the invention. The objects and other advantages of the invention may be realized and obtained by means of the structures particularly pointed out in the written description and drawings.

[0016] The technical solution of the present invention will be further described in detail below with reference to the accompanying drawings and embodiments. Attached Figure Description

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

[0018] Figure 1 A flowchart of a method for calculating the total price based on cost outcome documents, provided as an embodiment of the present invention; Figure 2 A schematic diagram showing the column contents read from the preliminary estimate table of a method for calculating the total price based on cost results documents, provided as an embodiment of the present invention; Figure 3 A schematic diagram of the columns read from a construction project budget table, provided as an embodiment of the present invention, for a method of calculating total cost based on cost results documents; Figure 4 A schematic diagram of the columns read from other cost estimates in a cost estimate table provided for an embodiment of the present invention, based on a cost outcome document for calculating the total price. Figure 5 A schematic diagram of a hierarchical database for a method of calculating total cost based on cost outcome documents, provided as an embodiment of the present invention; Figure 6 A schematic diagram of a two-dimensional storage matrix for storing data in an embodiment of the present invention, which is a method for calculating the total price based on cost results documents; Figure 7 A schematic diagram illustrating the import of data into a two-dimensional storage matrix from a hierarchical database for a method of calculating total cost based on cost outcome documents, provided as an embodiment of the present invention; Figure 8 A schematic diagram of a price data file for a method of calculating the total price based on cost results documents, provided as an embodiment of the present invention; Figure 9 A schematic diagram illustrating the identification of column contents in a price data file for a method of calculating the total price based on a cost outcome document, provided as an embodiment of the present invention; Figure 10A schematic diagram illustrating the setting of a two-dimensional storage matrix for a method of calculating the total price based on cost outcome documents, provided as an embodiment of the present invention; Figure 11 A schematic diagram of a bill of quantities format without price, provided for an embodiment of the present invention, for a method of calculating total price based on cost results documents; Figure 12 A schematic diagram of a specific bill of quantities without price, illustrating a method for calculating the total price based on cost outcome documents, provided as an embodiment of the present invention; Figure 13 A schematic diagram of a specific bill of quantities without price, illustrating yet another method for calculating total price based on cost outcome documents, provided as an embodiment of the present invention; Figure 14 A schematic diagram of an equipment and installation engineering budget table provided for an embodiment of the present invention, which is a method for calculating the total price based on cost results documents; Figure 15 A schematic diagram illustrating the specification of a retrieval column for an imported bill of quantities without prices, provided as an embodiment of the present invention, for a method of calculating the total price based on cost results documents; Figure 16 A schematic diagram illustrating the specification of a retrieval column for an imported bill of quantities without prices, provided as an embodiment of the present invention, for a method of calculating the total price based on cost results documents; Figure 17 A schematic diagram of a storage matrix and a bill of quantities without prices for a method of calculating total price based on cost results documents, provided for embodiments of the present invention; Figure 18 A schematic diagram illustrating the generation of a bill of quantities with prices based on a cost estimate document, provided as an embodiment of the present invention; Figure 19 A schematic diagram illustrating the formation of a bill of quantities with prices, based on another method for calculating the total price using cost outcome documents, as provided in an embodiment of the present invention. Figure 20 A schematic diagram illustrating the formation of a bill of quantities with prices, based on another method for calculating the total price using cost outcome documents, as provided in an embodiment of the present invention. Figure 21 A structural diagram of a cost calculation device based on cost outcome documents is provided for an embodiment of the present invention; Figure 22 This is a structural diagram of an electronic device provided as an embodiment of the present invention. Detailed Implementation

[0019] The features and exemplary embodiments of various aspects of this application will be described in detail below. To make the objectives, technical solutions, and advantages of this application clearer, the application will be further described in detail below with reference to the accompanying drawings and specific embodiments. It should be understood that the specific embodiments described herein are only intended to explain this application and not to limit it. For those skilled in the art, this application can be implemented without some of these specific details. The following description of the embodiments is merely to provide a better understanding of this application by illustrating examples.

[0020] It should be noted that, in this document, relational terms such as "first" and "second" are used merely to distinguish one entity or operation from another, and do not necessarily require or imply any such actual relationship or order between these entities or operations. Furthermore, the terms "comprising," "including," or any other variations thereof are intended to cover non-exclusive inclusion, such that a process, method, article, or apparatus that comprises a list of elements includes not only those elements but also other elements not expressly listed, or elements inherent to such a process, method, article, or apparatus. Without further limitations, an element defined by the phrase "comprising..." does not exclude the presence of additional identical elements in the process, method, article, or apparatus that includes said element.

[0021] like Figure 1 As shown, the present invention provides a method for calculating the total price based on cost outcome documents. This method includes: In step S11, cost result documents are obtained, which include one or more of the following: preliminary estimate, budget, or bill of quantities. In step S12, the cost result file is imported into a hierarchical database to form a price database and a bill of quantities database with related relationships. In step S13, the corresponding matching column is found in the price database based on the column searched in the bill of quantities database; In step S14, the price in the comparison column is assigned to the assignment column corresponding to the lookup column to obtain the sum price of the lookup column.

[0022] In one embodiment, the method for calculating total price based on cost estimates documents aims to address the inefficiencies and inaccuracies caused by the large volume and diverse formats of traditional cost estimate document preparation. By acquiring cost estimate documents, which can be any one or more of a preliminary estimate, budget, or bill of quantities, the method can handle cost estimate documents from different sources and formats, extracting valid data from various documents. The acquired cost estimate documents are imported into a hierarchical database, where the data is parsed and classified according to predetermined rules, forming a price database and a bill of quantities database with interrelationships. The price database primarily stores price information for various projects, while the bill of quantities database stores descriptive information such as project name, quantity, and unit. The two databases interact through a certain association mechanism, providing data support for subsequent price matching and calculation.

[0023] In the bill of quantities database, lookup columns are set for each item or data row. These lookup columns typically include key information such as item name, item characteristics, and unit of measurement. Based on these lookup columns, corresponding reference columns are searched in the price database. Item names and descriptions in cost documents often have inconsistent formats, imprecise vocabulary, or spelling errors, making direct matching difficult to guarantee accuracy. Pre-defined similarity algorithms, such as Jaccard similarity, Levenshtein distance, Dice coefficient, cosine similarity, and similarity normalization algorithms, are used. These algorithms calculate similarity by comparing the text content of the lookup columns with the corresponding reference columns in the price database. When the similarity exceeds a preset matching threshold, a valid correspondence is confirmed. After a successful match, the price data of the corresponding reference column in the price database is assigned to the corresponding assignment column in the bill of quantities database, ultimately yielding the total price for each item. This automates data matching and assignment, improving the efficiency and accuracy of price calculation. Furthermore, the data columns in the bill of quantities database are categorized into retrieval and assignment categories. By categorizing and organizing data columns, consistency between the searched data (such as project name and project characteristics) and the column types stored in the price database is ensured during subsequent matching, thereby reducing the risk of errors in data matching. Intelligent algorithms enhance the robustness of fuzzy text matching, enabling accurate matching and price calculation even with different formats or slightly different descriptions. After the initial data import, newly generated cost outcome files are monitored periodically. Upon detection of new files, data identification and import operations are performed. Updated data not only adjusts existing data in the bill of quantities database but also re-stores the latest price data in the price database, ensuring the entire system's data remains up-to-date. This allows the system to adapt to constantly changing market prices and project requirements, guaranteeing the real-time nature and accuracy of price calculations. By traversing all search columns and assigning values ​​one by one, a complete bill of quantities with price information is generated, providing a reliable data foundation for project cost decisions.

[0024] The system accepts cost estimates documents in various formats and can extract and parse the data within them. Since different engineering projects may have diverse cost estimate document formats—for example, some projects use the basic format of "item-quantity-unit price-total price," while others may differ due to different compilation standards—the data parsing module needs high compatibility and adaptability. The parsed data is stored separately in a price database and a bill of quantities database according to predefined rules; this hierarchical storage ensures a clear data structure. The lookup column in the bill of quantities database typically contains basic project description information, which may vary in wording or expression due to different data entry methods. A preset similarity algorithm is used to compare the lookup column with the corresponding column in the price database. The similarity algorithm is not a single comparison method but a combination of multiple algorithms. For example, Jaccard similarity can be used to measure the similarity between sets, Levenshtein distance is used to calculate the edit distance between strings, and Dice coefficient and cosine similarity can measure text similarity from a statistical perspective. By setting reasonable matching thresholds, the system can automatically identify and confirm that the lookup column has a corresponding counterpart column in the price database, ensuring matching accuracy and avoiding erroneous assignments due to simple matching. After a successful match, the price data from the counterpart column is assigned to the corresponding assignment column in the lookup column, completing the price calculation. Considering the potential for abnormal data or errors in engineering projects, the technical solution also includes an error detection module. This module compares the calculated total price with a preset reasonable price range, marking results outside the reasonable range or generating error reports. This error detection mechanism not only promptly detects anomalies in the data but also provides a reference for subsequent manual review, further improving the robustness and reliability of the overall system. During project implementation, cost outcome documents are continuously updated, and the generation of new documents indicates potential changes in market prices or project details. By periodically monitoring newly generated cost outcome documents and automatically identifying, importing, and matching their data, dynamic updates to the bill of quantities and price databases are achieved. The updated data reflects market dynamics in a timely manner, providing real-time reference for engineering costs and ensuring the timeliness and accuracy of the calculation results. Meanwhile, by iterating through and assigning values ​​to all lookup columns, a complete and up-to-date bill of quantities with prices can be generated.

[0025] By automatically acquiring and parsing cost estimates documents, the system achieves compatibility and processing of multiple data formats. A hierarchical database is used for structured data storage, and the establishment of a link between the price database and the bill of quantities database provides a solid foundation for data matching. A preset similarity algorithm is used for intelligent matching of text data, overcoming the limitations of traditional search methods when handling mixed Chinese and English text and fuzzy matching. Error detection and dynamic update mechanisms ensure the accuracy and real-time nature of the calculation results, reducing the risk of errors caused by manual intervention. This not only improves the efficiency of cost estimate preparation but also achieves a high degree of automation and intelligence in all aspects, including data processing, matching and assignment, error correction, and dynamic updates.

[0026] The technical solution in this embodiment can be briefly described as follows: (1) Store the price data into a hierarchical database according to predetermined rules for use in subsequent steps; (2) Import the bill of quantities without prices and link it to the price database according to specific rules; (3) Specify the lookup column, unit column, and value assignment column for bill of quantities that does not include price; (4) The system identifies the specified search column row by row, and compares the identification results with the corresponding columns in the price database item by item and calculates the similarity. If the similarity meets the preset requirements, the corresponding price data is assigned to the corresponding assignment column in the bill of quantities, thereby generating a complete bill of quantities with price.

[0027] The above method will be explained in detail below: (1) Store price data into a hierarchical database according to predetermined rules. The existing cost estimates documents are imported into the system described in this invention. Through preset rules or formats, the price data in the cost estimates documents is stored in a hierarchical database. Cost estimates documents are generally price table documents compiled according to specific compilation regulations or pricing specifications. Although the compilation regulations used in different engineering projects or industries may differ, resulting in slight variations in document formats, their basic form follows the structure of "Project Name—Quantity—Unit Price—Total Price". For example, for professional engineering cost estimates documents related to equipment procurement and installation, such as the "Equipment and Installation Engineering Budget Table," the document format adopts the above basic form, as shown in Table 1 below.

[0028] Table 1

[0029] For professional cost estimates in the field of construction engineering, such as "Construction Engineering Budget Table", the file format can be set as Table 2, as shown below.

[0030] Table 2

[0031] For professional cost estimates that involve other expenses, such as the "Other Expenses Estimate Table", the document format can be set as Table 3, as shown below: Table 3

[0032] A complete cost estimate document is based on the above-mentioned document format, supplemented with detailed data information such as the name and price of each project. In this invention's system, when reading the cost estimate document, the system primarily extracts the columns containing the project name, unit of measurement, and unit price. More relevant columns can also be read as needed. The target data is the names of various projects and their corresponding unit prices. Taking the three types of preliminary estimate tables mentioned above as examples, the column contents read by the system are shown in the appendix. Figure 2 As shown.

[0033] Taking the "Equipment and Installation Engineering Budget Sheet" as an example, for the content related to equipment and installation engineering in the cost results document, the column information read by the system of the present invention includes: project name, project characteristics, unit of measurement, equipment purchase cost, installation cost, and equipment material cost.

[0034] In this invention, the project name, project characteristics, and unit of measurement are collectively referred to as "Dimension 1," serving as descriptive and identifying information. Equipment purchase cost, installation cost, and equipment material cost constitute "Dimension 2," serving as price data. The content corresponding to "Dimension 1" and "Dimension 2" is automatically identified and retrieved by the system of this invention. Considering that in practical applications, the project name and project characteristics are often combined into a single field uniformly represented as the project name, in the subsequent description of the method of this invention, for equipment-related cost estimates, the system will parse based on the following information: project name, unit of measurement, equipment purchase cost, installation cost, and equipment material cost.

[0035] Meanwhile, taking the "Construction Project Budget Sheet" as an example, for the content related to construction projects in the cost estimate document, such as... Figure 3 As shown, the column information read by the system of the present invention includes: 7. Project name; 8. Project characteristics; 9. Unit of measurement; 10. Comprehensive unit price.

[0036] In this system, the project name, project characteristics, and unit of measurement are combined and defined as "Dimension 1" as identifying data; while the comprehensive unit price is defined as "Dimension 2" as price data. The system automatically identifies and reads the data corresponding to "Dimension 1" and "Dimension 2". Considering that in practical applications, the project name and project characteristics are usually combined into a single field representing the project name, the following information will be used to parse the relevant cost documents for construction projects in the subsequent description of the method: 7. Project Name; 9. Unit of Measurement; 10. Comprehensive Unit Price.

[0037] Taking the "Other Expenses Estimate Table" as an example, the content related to other expenses in the cost final document is as follows: Figure 4 As shown, the column information read by the system includes: 11. Project name; 12. Unit of measurement; 13. Calculation base or unit price.

[0038] In this system, the project name and unit of measurement are defined as "Dimension 1" (identifiable data), while the calculation base or unit price is defined as "Dimension 2" (price data). The system automatically identifies and reads the data corresponding to "Dimension 1" and "Dimension 2" (the identification and reading methods are not within the scope of this invention). Subsequently, the system stores the identified "Dimension 1" and "Dimension 2" data into a hierarchical database.

[0039] A "hierarchical database" refers to a three-dimensional data matrix constructed based on specific filtering criteria. This data matrix consists of multiple layers of two-dimensional storage matrices, as shown in the attached figure. Figure 5 As shown. Each two-dimensional storage matrix corresponds to a set of explicit identification conditions. Under these conditions, the data read by the system is stored in the corresponding two-dimensional matrix. For example, when a two-dimensional storage matrix is ​​used to store engineering price data such as equipment purchase cost and construction cost, its specific identification conditions usually include the project location, construction time, project type, terrain, project scale, price type (such as different pricing levels or types like feasibility study, preliminary design, or contract price), and project design characteristics. Specifically, the identification conditions of a certain layer of two-dimensional storage matrix can be represented as (i1, j1, k1, ..., n1), where i1 can be "Baicheng City, Jilin Province", j1 is "Third Quarter of 2024", k1 is "Onshore Wind Power", l1 is "Plains", m1 is "100MW", o1 is "Feasibility Study", p1 is "Hub Height 160m", q1 is "Overhead Collection Line", etc. This setting indicates that the engineering price data stored in the two-dimensional storage matrix corresponds to an onshore wind power project located in Baicheng City, Jilin Province, planned to start construction in the third quarter of 2024, situated in a plain, with an installed capacity of 100MW, a hub height of 160m, and overhead power collection lines, and its price data has reached the feasibility study level.

[0040] Appendix Figure 6This demonstrates the data storage format in a single two-dimensional storage matrix. The matrix's columns are divided into two categories: retrieval columns and data columns. Each retrieval column must contain at least one column, representing the name, identifier, or multi-condition characteristics of the stored data; each data column must contain at least one column, primarily storing the corresponding data values. For example, if the retrieval columns are defined as: Category 1 (i=1) "Project Name", Category 1 (i=2) "Project Characteristics", and Category 1 (i=3) "Unit"; and the data columns are defined as: Category 2 (i=1) "Equipment Purchase Cost", Category 2 (i=2) "Installation Cost", and Category 2 (i=3) "Equipment Material Cost", then the generated storage matrix format is shown in the attached figure. Figure 6 As shown.

[0041] As attached Figure 7 As shown, the first row contains the names of each column, and data of different types is stored sequentially starting from the second row. In a practical system, when importing price data files into the system and storing them in a hierarchical database, it is necessary to first align the content types of each column in the two-dimensional storage matrix with the column types in the price data file, and then write the data to be stored into the corresponding columns one by one. For the appendix... Figure 8 The price data file in the file, its column contents are identified as appendices. Figure 9 .

[0042] According to the appendix Figure 9 The display shows that Type 1 (i=1) is "Project Name", Type 1 (i=2) is "Project Characteristics", and Type 1 (i=3) is "Unit of Measurement"; while Type 2 (i=1) is "Equipment Purchase Cost", Type 2 (i=2) is "Installation Cost", and Type 2 (i=3) is "Equipment Material Cost". This step completes the definition of the content types and their order in the price data file. The definition of the above column content types and order is performed after the price data file is imported into the system. Regardless of the actual format of the price data file, it is only necessary to select and define the content of each column in the file according to the aforementioned classification method of Type 1 (retrieval class) and Type 2 (data class). To ensure that the selected data can be accurately stored in the two-dimensional storage matrix, the two-dimensional storage matrix must be aligned accordingly, that is, the type (i.e., Type 1 retrieval class and Type 2 data class) and their order in the matrix must be consistent with the type and order defined in the price data file. For example, with the attached... Figure 9 The corresponding two-dimensional storage matrix can be set as an appendix. Figure 10 .

[0043] The initial empty two-dimensional storage matrix is ​​configured with 6 columns. The content types and order of these 6 columns from left to right are consistent with the column types and order defined in the price data file: Category 1 (i=1) is "Project Name," Category 1 (i=2) is "Project Characteristics," Category 1 (i=3) is "Unit of Measurement," Category 2 (i=1) is "Equipment Purchase Cost," Category 2 (i=2) is "Installation Cost," and Category 2 (i=3) is "Materials Cost." In this way, the 6 columns of data identified and read by the system from the price data file will be stored in the two-dimensional storage matrix in an orderly manner according to the pre-defined type definitions and order.

[0044] It is worth noting that for price data files, in addition to selecting and setting the content type and sorting order of the columns to be read, the system can also be set to read data row by row starting from a specified row. Furthermore, the two-dimensional storage matrix can be configured with headers to include labels such as "Item Name" and "Item Characteristics," or it can be left unconfigured, as the system has already pre-defined the content type and sorting order of each column.

[0045] (2) Import the bill of quantities without price A bill of quantities is an important document in engineering projects, used to describe and quantify the scope of work, materials, labor, and costs. It is typically used during the bidding, contract signing, and construction management stages, and serves as a crucial basis for project cost control, schedule management, and settlement. The main objective of this invention is to enable rapid value assignment to bills of quantities that do not include prices; that is, to quickly add data-related information to a bill of quantities that already contains retrieval data but lacks specific data content, according to specific rules.

[0046] The format of a bill of quantities may vary slightly depending on the type of project, but it generally follows the basic structure of "Project Name—Project Characteristics—Unit of Measurement—Quantity" or "Project Name—Project Characteristics—Unit of Measurement—Quantity—Unit Price—Total Price". The format of a bill of quantities without price is shown in the attached figure. Figure 11 As shown, this fully reflects the practical application needs of the bill of quantities in project cost management.

[0047] The basic form of the list is a row-column matrix, and its storage format is similar to that of a single two-dimensional storage matrix. The list should at least contain retrieval data (i.e., Category 1), and may also contain both retrieval and data data (i.e., Category 1 and Category 2), and even data from other categories. Specifically, Category 1 refers to character data with at least one column, used to represent the name, identifier, or multi-condition characteristics corresponding to the price data; while Category 2 refers to numeric data with at least one column, used to represent the price value. When a price variety has multiple price categories, there are multiple numeric data columns. For example, if Category 1 (i=1) is defined as "Item Name", Category 1 (i=2) as "Item Characteristics", and Category 1 (i=3) as "Unit of Measurement", while other columns contain "Serial Number", "Quantity", etc., the following list format can be obtained as shown in the appendix. Figure 12 As shown.

[0048] For example, if Category 1 (i=1) is defined as "Item Name", Category 1 (i=2) as "Item Characteristics", Category 1 (i=3) as "Unit of Measurement", and Category 2 (i=1) as "Unit Price", while other columns include "Serial Number", "Quantity", and "Total Price", then the following list format example is attached. Figure 13 As shown.

[0049] For example, if Category 1 (i=1) is defined as "Project Name", Category 1 (i=2) as "Project Characteristics", and Category 1 (i=3) as "Unit of Measurement", and Category 2 (i=1) is defined as "Unit Price - Equipment Purchase Cost", Category 2 (i=2) as "Unit Price - Installation Cost", and Category 2 (i=3) as "Unit Price - Equipment Material Cost", while other columns include "Serial Number", "Project Code", "Quantity", "Unit Price - Subtotal", "Total Price - Equipment Purchase Cost", "Total Price - Installation Cost", "Total Price - Equipment Material Cost", "Total Price = Subtotal", and "Total Price", then the following bill of quantities example is obtained as shown in the attached figure. Figure 14 As shown.

[0050] (3) Specify the search column and assignment column for the bill of quantities excluding price. Specify the retrieval and assignment columns in the imported bill of quantities (excluding prices), where the retrieval column corresponds to Category 1 and the assignment column corresponds to Category 2. Prior to this, the definitions of Category 1 and Category 2 in the two-dimensional storage matrix must be completed. The selected Category 1 and Category 2 columns in the specified bill of quantities (excluding prices) should be a subset of the corresponding column definitions in the two-dimensional storage matrix. (Appendix) Figure 15 A diagram illustrating the specification of search columns for an imported bill of quantities that does not include price: Appendix Figure 16The labels in the table are explained as follows: 1—indicates a bill of quantities excluding price; 2—indicates a selected column in the bill of quantities, ready for definition; 3—indicates a category definition for the selected column; 4—indicates selection within the category 1 range defined in the two-dimensional storage matrix; 5—indicates selection within the category 2 range defined in the two-dimensional storage matrix.

[0051] The definition of Category 1 in the bill of quantities serves the following purpose: the system retrieves data in the bill of quantities that are used as the retrieval category (Category 1) item by item, and compares them one by one with the corresponding sub-category 1 content in the two-dimensional storage matrix; if the content of the two meets the preset similarity requirements, then the Category 2 data associated with the corresponding sub-category 1 in the two-dimensional storage matrix is ​​assigned to the corresponding position in the bill of quantities.

[0052] The definition of Category 2 in the bill of quantities is mainly used to specify the column location for storing data. See the attached example. Figure 17 .

[0053] Appendix Figure 17 The labels shown are explained as follows: 1. Storage matrix; 2. Bill of quantities without price.

[0054] In this example, the storage matrix is ​​predefined as follows: Category 1 (i=1) is "Project Name", Category 1 (i=2) is "Project Characteristics", and Category 1 (i=3) is "Unit of Measurement"; Category 2 (i=1) is "Equipment Purchase Cost", Category 2 (i=2) is "Installation Cost", and Category 2 (i=3) is "Materials Cost". Simultaneously, the imported bill of quantities without prices has also been defined accordingly. Its Category 1 and Category 2 definitions are completely consistent with those in the storage matrix, where Category 1 includes "Project Name", "Project Characteristics", and "Unit of Measurement", while Category 2 includes "Equipment Purchase Cost", "Installation Cost", and "Materials Cost". (The text in the dashed box can be optionally shown or hidden.) It should be noted that in practical applications, the definitions of Category 1 and Category 2 in the bill of quantities without prices should be subsets of the corresponding definitions in the storage matrix.

[0055] (4) Assign values ​​according to the rules The system identifies each row of the specified search columns in the bill of quantities and compares the identification results with the corresponding columns in the price database according to predetermined rules, calculating the similarity. For corresponding columns that meet the preset similarity conditions, the system assigns their corresponding price data to the corresponding columns in the bill of quantities, thereby generating a complete bill of quantities with prices. An implementation example is attached. Figure 18 Appendix Figure 19 and attached Figure 20 As shown. Label explanation: 1, storage matrix; 2, bill of quantities excluding price.

[0056] Starting with the first item in Category 1 (i=1) "Item Name" of the bill of quantities, the system sequentially retrieves each item in the list and searches for data with high similarity in the corresponding Category 1 column of the two-dimensional storage matrix. The similarity score can be preset before the assignment operation, and the calculation method can be a combination of one or more methods such as Jaccard similarity, Levenshtein distance, Dice coefficient, cosine similarity, and similarity normalization. For example, in this embodiment, a successful match is considered achieved when the similarity of "Item Name" exceeds 70%, and the similarity of "Item Features" and "Unit of Measurement" both exceed 70%; otherwise, the item is skipped, and the next item is processed.

[0057] Taking the first item in the list, "Public Measurement and Control Panel," as an example, the system first identifies "Public Measurement and Control Panel" in the list and searches sequentially in Category 1 column of the two-dimensional storage matrix. During this process, the first row, "220kV Line and Busbar Measurement and Control Panel," and the second row, "Main Transformer Measurement and Control Panel," did not meet the 70% matching requirement. When the system found the third row, "Public Measurement and Control Panel," its matching degree with the "Public Measurement and Control Panel" in the list reached over 70%. Then, the system sequentially compared the "Item Features" of Category 1 (i=2) corresponding to this item. The "Item Feature" in the list is "ZZZ," while the corresponding row in the two-dimensional storage matrix has "ZZZX." The similarity exceeded 70%. Subsequently, the system continued to compare the "Unit of Measurement" of Category 1 (i=3). The unit in the list is "Surface," and its matching degree with the corresponding "Surface" in the two-dimensional storage matrix also exceeded 70%, thus confirming a successful match.

[0058] After a successful match, the system assigns values ​​to the Category 2 data corresponding to the item in the two-dimensional storage matrix. Specifically, it assigns the value "70000" from Category 2 (i=1) "Equipment Purchase Cost" to the corresponding Category 2 (i=1) position in the bill of quantities; assigns "2500" from Category 2 (i=2) "Installation Cost" to the corresponding Category 2 (i=2) position; and assigns "0" from Category 2 (i=3) "Equipment Material Cost" to the corresponding Category 2 (i=3) position. The system uses the same matching and assignment strategy for the remaining items in the bill of quantities until the entire bill of quantities is generated with price data.

[0059] The technical solution in this embodiment significantly improves the efficiency and accuracy of engineering cost calculation by importing cost outcome documents into a hierarchical database and establishing a relationship between the price database and the bill of quantities database. It effectively solves the problem of low efficiency when compiling cost outcome documents line by line using traditional spreadsheet software such as Excel. Furthermore, it ensures the accuracy of price data by matching search and comparison columns using a preset similarity algorithm. It overcomes the shortcomings of using search functions such as VLOOKUP in Excel to compile cost outcome documents, including the inability of its fuzzy search logic to achieve high accuracy in capturing mixed Chinese and English strings, the inability to conveniently extract data from multidimensional databases, and the inability to perform parallel searches on multiple columns. It eliminates the limitations of existing commercial cost estimation software, such as the need to compile bill of quantities items line by line, resulting in limited compilation efficiency and the inability to automatically generate full-cost market prices, thus significantly improving the overall efficiency of budget preparation. Simultaneously, the method includes error detection of total prices and comparison of reasonable price ranges, further improving data reliability. Regular monitoring and updating of cost outcome documents ensures the timeliness and accuracy of the database.

[0060] In one embodiment, Figure 21 This is a block diagram illustrating a cost calculation device based on cost outcome documents, according to an exemplary embodiment. Figure 21 As shown, the device for calculating the total price based on the cost results document includes an acquisition module 211, an import module 212, a matching module 213, and an assignment module 214.

[0061] The acquisition module 211 is used to acquire cost result documents, which include one or more of the following: a preliminary estimate, a budget, or a bill of quantities. The import module 212 is used to import the cost result file into the hierarchical database to form a price database and a bill of quantities database with related relationships. The matching module 213 is used to search for columns in the bill of quantities database and match the corresponding columns in the price database. The assignment module 214 is used to assign the price in the comparison column to the assignment column corresponding to the lookup column, so as to obtain the sum price of the lookup column.

[0062] The acquisition module 211, import module 212, matching module 213, and assignment module 214 included in the block diagram of the device for calculating the total price based on the cost results document are controlled to execute the method for calculating the total price based on the cost results document described in any of the above embodiments.

[0063] like Figure 22 As shown, the present invention provides an electronic device 2200, which includes: a communication interface, a processor 2201, and a memory 2202; The memory 2202 stores program instructions. When the program instructions are executed by the processor 2201, which is connected to the memory 2202 via the communication interface, the program instructions obtain cost estimate documents, which include one or more of the following: a preliminary estimate table, a budget table, or a bill of quantities. The cost estimate documents are then imported into a hierarchical database to form a price database and a bill of quantities database with related relationships. Based on the search column in the bill of quantities database, a corresponding comparison column is matched in the price database. The price in the comparison column is assigned to the assignment column corresponding to the search column to obtain the total price of the search column.

[0064] This invention provides a computer-readable storage medium storing computer program instructions. When the computer program instructions are executed by a processor, a cost estimate document is obtained, which includes one or more of a preliminary estimate, a budget, or a bill of quantities. The cost estimate document is then imported into a hierarchical database to form a price database and a bill of quantities database with related relationships. Based on a lookup column in the bill of quantities database, a corresponding reference column is matched in the price database. The price in the reference column is assigned to the assignment column corresponding to the lookup column to obtain the total price of the lookup column.

[0065] It should be understood that the specific features, operations, and details described above regarding the method of the present invention can also be similarly applied to the apparatus and system of the present invention, or vice versa. Furthermore, each step of the method of the present invention described above can be performed by a corresponding component or unit of the apparatus or system of the present invention.

[0066] It should be understood that the various modules / units of the device of the present invention can be implemented wholly or partially through software, hardware, firmware, or a combination thereof. Each module / unit can be embedded in the processor of a computer device in hardware or firmware form or independent of the processor, or it can be stored in the memory of a computer device in software form for the processor to call to execute the operation of each module / unit. Each module / unit can be implemented as an independent component or module, or two or more modules / units can be implemented as a single component or module.

[0067] In one embodiment, a computer device is provided, including a memory and a processor. The memory stores computer instructions executable by the processor, which, when executed by the processor, instruct the processor to perform steps of the methods of embodiments of the present invention. The computer device can be broadly categorized as a server, terminal, or any other electronic device with the necessary computing and / or processing capabilities. In one embodiment, the computer device may include a processor, memory, network interface, communication interface, etc., connected via a system bus. The processor of the computer device can be used to provide the necessary computing, processing, and / or control capabilities. The memory of the computer device may include a non-volatile storage medium and internal memory. The non-volatile storage medium may store an operating system, computer programs, etc. The internal memory can provide an environment for the operation of the operating system and computer programs in the non-volatile storage medium. The network interface and communication interface of the computer device can be used to connect and communicate with external devices via a network. When the computer program is executed by the processor, it performs the steps of the methods of the present invention.

[0068] This invention can be implemented as a computer-readable storage medium storing a computer program thereon, which, when executed by a processor, causes the steps of the methods of embodiments of the invention to be performed. In one embodiment, the computer program is distributed across multiple network-coupled computer devices or processors, such that the computer program is stored, accessed, and executed in a distributed manner by one or more computer devices or processors. A single method step / operation, or two or more method steps / operations, may be executed by a single computer device or processor or by two or more computer devices or processors. One or more method steps / operations may be executed by one or more computer devices or processors, and one or more other method steps / operations may be executed by one or more other computer devices or processors. One or more computer devices or processors may execute a single method step / operation, or execute two or more method steps / operations.

[0069] It will be understood by those skilled in the art that the method steps of the present invention can be performed by a computer program instructing related hardware such as computer devices or processors. The computer program can be stored in a non-transitory computer-readable storage medium, and its execution causes the steps of the present invention to be performed. Depending on the context, any references to memory, storage, database, or other media herein may include non-volatile and / or volatile memory. Examples of non-volatile memory include read-only memory (ROM), programmable ROM (PROM), electrically programmable ROM (EPROM), electrically erasable programmable ROM (EPROM), flash memory, magnetic tape, floppy disk, magneto-optical data storage devices, optical data storage devices, hard disks, solid-state drives, etc. Examples of volatile memory include random access memory (RAM), external cache memory, etc.

[0070] The technical features described above can be combined arbitrarily. Although not all possible combinations of these technical features are described, any combination of these technical features should be considered to be covered by this specification, provided that such combination does not contain contradictions.

[0071] 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 or all of the technical features; and these modifications or substitutions do not cause the essence of the corresponding technical solutions to deviate from the scope of the technical solutions of the embodiments of the present invention.

Claims

1. A method for calculating the total price based on cost estimate documents, characterized in that, include: Obtain cost estimates documents, which include one or more of the following: a preliminary estimate, a budget, or a bill of quantities. The cost estimate documents are imported into a hierarchical database to form a price database and a bill of quantities database with related relationships. Based on the column search in the bill of quantities database, the corresponding matching column is found in the price database; The price in the comparison column is assigned to the corresponding assignment column of the lookup column to obtain the sum price of the lookup column.

2. The method for calculating the total price based on cost outcome documents as described in claim 1, characterized in that, Also includes: The data columns in the bill of quantities database are categorized into retrieval and assignment categories; Align the retrieval data columns in the bill of quantities database with the column types in the price database.

3. The method for calculating the total price based on cost outcome documents as described in claim 1, characterized in that, The step of searching for a column in the bill of quantities database and matching it with the corresponding column in the price database includes: The similarity between the search column and the reference column is calculated using a preset similarity algorithm. The preset similarity algorithm includes: obtaining cost estimate documents, which may include one or more of a preliminary estimate table, a budget table, or a bill of quantities; importing the cost estimate documents into a hierarchical database to form a price database and a bill of quantities database with related relationships; matching the corresponding reference column in the price database based on the search column in the bill of quantities database; and assigning the prices in the reference columns to the corresponding assignment columns of the search columns to obtain one or more of the following: price similarity, Levenshtein distance, Dice coefficient, cosine similarity, and similarity normalization of the search column. When the similarity is greater than the preset matching threshold, it is confirmed that the search column has a corresponding matching column in the price database.

4. The method for calculating the total price based on cost outcome documents as described in claim 3, characterized in that, Also includes: Error detection is performed on the sum of the values ​​in the lookup column; The test results are compared with a preset reasonable price range, and data that does not conform to the preset reasonable price range is marked or an error report is generated.

5. The method for calculating the total price based on cost outcome documents as described in claim 1, characterized in that, include: Regularly monitor newly generated cost estimates documents; The newly generated cost estimate documents are identified and imported, the bill of quantities database is adjusted based on the updated data, and the updated price data is re-stored into the price database.

6. The method for calculating the total price based on cost outcome documents as described in claim 1, characterized in that, Also includes: The entire bill of quantities database is traversed, and the prices in the lookup columns are assigned to the corresponding assignment columns of the lookup columns one by one, thus forming a complete bill of quantities with prices.

7. A device for calculating the total price based on cost estimate documents, characterized in that, include: The acquisition module is used to acquire cost result documents, which include one or more of the following: a preliminary estimate, a budget, or a bill of quantities. The import module is used to import the cost results files into the hierarchical database to form a price database and a bill of quantities database with related relationships. The matching module is used to search for columns in the bill of quantities database and match the corresponding reference columns in the price database. The assignment module is used to assign the price in the comparison column to the assignment column corresponding to the lookup column, so as to obtain the sum price of the lookup column.

8. The cost calculation device based on cost outcome documents as described in claim 7, characterized in that: The acquisition module, the import module, the matching module, and the assignment module are controlled to execute the cost calculation method based on the cost result document as described in any one of claims 1-6.

9. An electronic device, characterized in that, include: Communication interface, processor, memory; The memory is used to store program instructions, which, when executed by the processor that is communicatively connected to the memory via the communication interface, cause the electronic device to implement the cost calculation method based on the cost outcome document as described in any one of claims 1 to 6.

10. A computer-readable storage medium having program instructions stored thereon, characterized in that, When the program instructions are executed by a computer, the computer implements the cost calculation method based on cost outcome documents as described in any one of claims 1 to 6.

Images