Verification method and system for single project cost of production technical improvement project, and medium

Abstract

The invention relates to a method and system for verifying the cost of a single project of a production technical improvement project and a medium, and the method comprises the following steps: obtaining a cost file of the single project of the production technical improvement project, and carrying out the deviation correction; related cost indexes are extracted based on the cost file after deviation correction; obtaining a cost fine item of each stage in the cost file of the single project of the production technical improvement project; based on the related cost indexes, calculating the cost fees of each stage to obtain the cost fees of each stage and the total cost fees; and comparing the construction cost and the total construction cost of each stage with the construction cost and the total construction cost of each stage in a construction cost file to obtain a comparison result, and verifying the construction cost and the total construction cost of each stage in the construction cost file according to the comparison result to complete a verification process. Compared with the prior art, the method has the advantages of automatic verification, high accuracy and the like.

Description

Technical Field

[0001] The present invention relates to the technical field of production technology transformation projects, and in particular to a method, system and medium for verifying the cost of a single project of a production technology transformation project. Background Art

[0002] In recent years, investment and construction in production technology transformation projects have grown rapidly, with the number of projects and investment scale increasing. This has led to a more stringent internal and external environment for project investment and construction compliance, placing higher demands on the cost management of production technology transformation projects. Furthermore, the management of production technology transformation projects is characterized by short, flat, and fast timelines, placing high demands on the review cycle. Therefore, how to effectively improve the efficiency and quality of reviews and manage project investments in compliance with laws and regulations is a key challenge in the cost review of production technology transformation projects.

[0003] The review of construction costs in cost documents also faces the above problems. Therefore, there is an urgent need for an automated review method to verify the construction costs to improve the efficiency and quality of the cost review. Summary of the Invention

[0004] The purpose of the present invention is to provide a method, system and medium for calibrating the construction cost of a single project of a production technology transformation project in an automated manner.

[0005] The purpose of the present invention can be achieved by the following technical solutions:

[0006] A method for verifying the cost of a single project in a production technology transformation project comprises the following steps:

[0007] Obtain cost documents for a single project of a production technology transformation project and correct any deviations;

[0008] Extract relevant cost indicators based on the cost documents after deviation correction;

[0009] Obtain the detailed cost items for each stage in the cost document of the single project of the production technology transformation project;

[0010] Calculate the construction cost details of each stage based on the relevant cost indicators to obtain the construction cost of each stage and the total construction cost;

[0011] The construction cost and total construction cost of each stage are compared with the construction cost and total construction cost of each stage in the construction cost document to obtain a comparison result, and the construction cost and total construction cost of each stage in the construction cost document are verified based on the comparison result to complete the verification process.

[0012] Furthermore, the deviation correction step includes:

[0013] Performing deviation detection on the cost document using a rule-based deviation detection method to obtain a deviation detection result of the cost document;

[0014] Based on the deviation detection result of the cost document, the deviation is corrected by adopting the Yeo-Johnson transformation method and the external data comparison method to obtain a corrected cost document as the deviation-corrected cost document.

[0015] Furthermore, the step of detecting the deviation includes:

[0016] Setting standard rules, including the definition domain, data type, attribute value range, value length range, expected value range and dependencies between attributes for each attribute in the cost document;

[0017] Based on the standard rules, the cost document is scanned and deviations are detected as deviation detection results of the cost document.

[0018] Furthermore, the step of obtaining the corrected cost document includes:

[0019] Based on the deviation detection result of the cost document, a Yeo-Johnson transformation method is used to transform the cost document to obtain a transformed cost document;

[0020] Acquiring external data, wherein the external data is a historical cost file;

[0021] The transformed cost document is compared and verified with the external data, and further correction is performed based on the comparison and verification results to obtain a corrected cost document.

[0022] Furthermore, the transformation process of the Yeo-Johnson transformation method is expressed as:

[0023] (1) When y>0 and y is a continuous variable:

[0024] When λ=0, we have:

[0025] Y=ln(y+1)

[0026] When λ≠0, we have:

[0027]

[0028] (2) When y<0 and y is a continuous variable:

[0029] When λ=0, we have:

[0030] Y=-ln(y+1)

[0031] When λ≠0, we have:

[0032]

[0033] Where λ is the transformation parameter, y is the original data sample, and Y is the transformed data sample.

[0034] Furthermore, the step of extracting relevant cost indicators includes:

[0035] Based on the deviation-corrected cost file, a Gaussian filter algorithm is used to perform denoising processing to obtain a denoised cost file;

[0036] Based on the denoised cost document, the OCR recognition method is used to identify the text data and extract relevant cost indicators.

[0037] Furthermore, the stages include estimation, budgeting, budgeting, and closing stages.

[0038] Furthermore, the construction cost details include construction project costs, installation project fees, overhead communication line fees, distribution building demolition, cable building demolition, installation and demolition fees, cable installation and demolition, overhead line demolition, communication line demolition, installation residue cleaning, equipment purchase fees and remaining costs.

[0039] The present invention also provides a system for verifying the cost of a single project in a production technology transformation project, comprising:

[0040] Document acquisition and deviation correction module: used to obtain the cost documents of a single project of a production technology transformation project and perform deviation correction;

[0041] Index extraction module: used to extract relevant cost indicators based on the cost file after deviation correction;

[0042] Cost item acquisition module: used to obtain the cost item details of each stage in the cost document of a single project of the production technology transformation project;

[0043] Cost calculation module: used to calculate the cost details of each stage based on the relevant cost indicators to obtain the cost of each stage and the total cost;

[0044] Comparison and verification module: used to compare the construction cost and total construction cost of each stage with the construction cost and total construction cost of each stage in the construction cost document, obtain comparison results, and verify the construction cost and total construction cost of each stage in the construction cost document according to the comparison results to complete the verification process.

[0045] The present invention also provides a computer-readable storage medium, comprising one or more programs for execution by one or more processors of an electronic device, wherein the one or more programs include instructions for executing the method for verifying the cost of a single project of a production technology transformation project as described above.

[0046] Compared with the prior art, the present invention has the following beneficial effects:

[0047] (1) The present invention corrects deviations in the cost documents of a single project of a production technology transformation project to detect and correct deviations, and extracts relevant cost indicators. The cost of each stage and the total cost are calculated in combination with the cost details of each stage in the cost document. Finally, by comparing with the costs in the cost document, inconsistent costs can be compared, thereby completing the verification of the cost. The present invention does not require human participation and completes the verification of the cost through an automated processing method.

[0048] (2) In the deviation correction process of the present invention, a rule-based deviation detection method is used for deviation detection, which can find deviation results that do not conform to standard rules, and the Yeo-Johnson transformation method is used to transform the data, which improves the normality of the data and reduces heteroscedasticity, and external data is used for verification to ensure the accuracy of the data.

[0049] (3) The present invention can be adapted to the cost verification of each stage and multiple stages of a single project in a production technology transformation project, and is also adapted to various types of cost documents. BRIEF DESCRIPTION OF THE DRAWINGS

[0050] Figure 1 Schematic diagram of the method of the present invention. DETAILED DESCRIPTION

[0051] The present invention is described in detail below with reference to the accompanying drawings and specific embodiments. This embodiment is implemented based on the technical solution of the present invention, and provides a detailed implementation method and specific operation process, but the protection scope of the present invention is not limited to the following embodiments.

[0052] Example 1

[0053] This embodiment provides a method for verifying the cost of a single project in a production technology transformation project. Figure 1 As shown, the method includes the following steps:

[0054] Step 1: Obtain the cost documents, correct deviations and extract relevant cost indicators.

[0055] To support the application of single engineering cost indicators in the review of production technology transformation projects, it is necessary to first parse the relevant content and extract information from the cost documents submitted by the user, including feasibility study estimates and preliminary design budget reports. The extracted indicator data for different stages, such as estimation, budget, budget, and closing, is then compared and analyzed to support the review process. This is mainly achieved by using data preprocessing and key information extraction technologies.

[0056] 1.1 Deviation Correction

[0057] The first is deviation detection. Existing knowledge about the nature of the data can be used to identify noise, outliers, and unusual values that require investigation. This knowledge, or "data about the data," is called metadata.

[0058] First, standard rules are established, including the domain, data type, value range, length range, expected range, and dependencies between attributes for each attribute in the cost document. The domain and data type, acceptable values, and length range of each attribute are then examined. All values are checked to see if they fall within the expected range and if there are known dependencies between attributes. Data trends are identified and anomalies are detected. For example, values that are more than two standard deviations away from the mean of a given attribute may be flagged as potential outliers. Data are primarily inspected for uniqueness, continuity, and null value rules. Inconsistencies are corrected manually.

[0059] The second step is to correct the deviations. Once deviations are found, this embodiment defines and uses a series of transformations to correct them. This study mainly uses a combination of Yeo-Johnson transformation and external data comparison.

[0060] The Yeo-Johnson transform is a generalized power transform method, considered a generalization of the Box-Cox transform in the real domain. It can significantly improve data normality and reduce heteroskedasticity. The transformation function has only one parameter, λ. Different λs correspond to different transformation methods. Maximum likelihood estimation can be used to solve for the value of λ. The formula is as follows:

[0061] (1) When y>0 and y is a continuous variable:

[0062] When λ=0, we have:

[0063] Y=ln(y+1)

[0064] When λ≠0, we have:

[0065]

[0066] (2) When y<0 and y is a continuous variable:

[0067] When λ=0, we have:

[0068] Y=-ln(y+1)

[0069] When λ≠0, we have:

[0070]

[0071] Where λ is the transformation parameter, y is the original data sample, and Y is the transformed data sample.

[0072] External data comparison mainly combines data from reliable sources to cross-verify the cleaned and corrected data to ensure the accuracy of relevant data. External data sources mainly include data from different settlements of production technical transformation projects of different voltage levels collected over the years.

[0073] 1.2 Extraction of relevant cost indicators

[0074] For the cost file after deviation correction, the Gaussian filter algorithm is used to perform denoising to obtain the denoised cost file;

[0075] Based on the denoised cost document, the OCR recognition method is used to identify the text data and extract relevant cost indicators.

[0076] Gaussian filtering is a linear smoothing filter that smooths and reduces noise by convolving an image with a two-dimensional Gaussian function. The core concept of Gaussian filtering is to use a weighted average approach, where the new value of each pixel in the image is the weighted sum of the values of its neighbors. The weights are determined by a Gaussian distribution, meaning that pixels closer to the center have a larger weight, and pixels farther away have a smaller weight.

[0077] Features: Preserve edge information: Compared with simple mean filtering, Gaussian filtering can effectively remove noise while better preserving the edge information of the image.

[0078] Parameter adjustment: The degree of smoothing can be controlled by adjusting the size and standard deviation of the Gaussian kernel to adapt to different noise conditions.

[0079] Application scenarios: Suitable for processing random noise such as salt and pepper noise and Gaussian noise.

[0080] It has a good protective effect on the fine structures in the image (such as strokes of text).

[0081] Step 2: Calculate the construction cost, compare them, and then verify the cost based on the comparison results.

[0082] a. Dimensional analysis

[0083] The reading dimension of the cost of this project cost for the production technology transformation project is mainly based on the fee settings and engineering costs in the cost document, including calculable and readable items and the total amount of engineering cost. The detailed items for comparison will be displayed in the project, and the various costs obtained after calculating the cost document will be used to compare the data of different stages, including cost documents (detailed items), review costs (costs included therein), feasibility study costs (search and comparison of costs included therein), and comparison functions provided to each stage. During the preliminary review (including formal review), the detailed items of the cost document and the total engineering cost data can be compared to detect whether there are deviations. The comparison can also be displayed during the closing so that the review experts can make timely adjustments and modifications.

[0084] The following are the major cost items in the cost of production technical transformation projects that can be obtained through calculation formulas: construction project costs, installation project fees, overhead communication line fees, distribution building demolition, cable building demolition, installation and demolition fees, cable installation and demolition, overhead line demolition, communication line demolition, installation residue cleaning, equipment purchase costs, and other costs.

[0085] b. Calculation of construction cost

[0086] Table 1 Cost calculation table

[0087]

[0088]

[0089]

[0090]

[0091]

[0092] Through the research and sorting of the cost data items, calculation methods (rates) of the above production technology transformation projects, combined with the project type data, the data comparison process of the engineering budget was preliminarily confirmed. First, the project data was obtained and classified into the corresponding database. The corresponding detailed data was obtained through the retrieval of the cost documents. Then, the corresponding detailed data (only part of the data is supported) and the total cost data of the cost documents were obtained through the simple algorithm supported by the system. The project will have multiple stages and different file generation, such as review opinions, feasibility studies, preliminary designs, etc., so it is necessary to compare the corresponding calculated cost data items with the cost data items in the review opinions and feasibility studies and preliminary designs, so as to obtain different cost data comparison situations, so as to make timely adjustments and support during the review.

[0093] (3) Comparison of construction costs at each stage

[0094] The above research has obtained the calculation formulas and detailed data for the detailed cost data of production technical transformation. Through the existing basic data structure, we have sorted out the project review cost data of each stage that needs to be compared, as well as the review opinions, feasibility studies and other documents generated at each stage, and compared the cost data to help the review experts verify the cost data, make timely adjustments, and feedback problems.

[0095] a. Cost data comparison stage

[0096] In the whole review process, it is necessary to compare the cost document data. Through the analysis and understanding of the whole review process, this study adds cost data comparison from the two processes of pre-review and closing. When the reviewers conduct pre-review and closing, they can compare the cost data and make detailed comparisons to obtain the comparison of various expenses.

[0097] The comparison data in the review stage are (the latest version of the project cost data is read for both the pre-review and closing): construction project costs, installation project charges, overhead communication line charges, distribution building demolition, cable building demolition, installation and demolition charges, cable installation and demolition, overhead line demolition, communication line demolition, installation residue cleaning, equipment purchase costs, other costs (special costs are not compared, only calculable cost items are calculated), and total project costs.

[0098] The above is a comparison of data from the preliminary review and closing stages. Cost data can be compared directly on the system page. If there is a problem with the cost verification, the problem item will be prompted and warned, which will facilitate verification by review professionals and personnel, reducing manual verification work.

[0099] b. Document cost comparison type

[0100] The above is a comparison of cost data at each stage. This study also needs to compare the documents in each review process, such as the feasibility study report during the preliminary review and the review opinions on the results after closing. There will be some cost data. It is also necessary to conduct multi-party comparison and search for errors through the cost data calculated by the system and the data in the cost documents (both use the latest version).

[0101] For example:

[0102] Project feasibility study documents:

[0103] Verification data is (preliminary review). The feasibility study document contains the total project cost, construction cost, installation cost, equipment purchase cost, and other costs. The original data in the cost document is extracted for verification. The function is to compare the original cost of the cost document with the cost of the feasibility study document. Among them, the construction cost, installation cost, and equipment purchase cost can be verified and calculated using the cost document data extracted by the system to form comparative data, which is displayed as the feasibility study cost compared with the original cost and the system-calculated cost.

[0104] Project review comments:

[0105] Verification data is (closing), reading the review comments for total project investment, dynamic and static investment costs (reading the system's pre- and post-review project investment costs), construction costs, installation costs, equipment costs, demolition costs (read from other files), and dynamic and static investment (reading the total investment in the project closing cost document) from the construction cost table 3. Read these costs and automatically compare them with the system's calculated costs in the partial cost document.

[0106] Example 2

[0107] This embodiment provides a system for verifying the cost of a single project in a production technology transformation project, the system comprising:

[0108] Document acquisition and deviation correction module: used to obtain the cost documents of a single project of a production technology transformation project and perform deviation correction;

[0109] Index extraction module: used to extract relevant cost indicators based on the cost file after deviation correction;

[0110] Cost item acquisition module: used to obtain the cost item details of each stage in the cost document of a single project of the production technology transformation project;

[0111] Cost calculation module: used to calculate the cost details of each stage based on the relevant cost indicators to obtain the cost of each stage and the total cost;

[0112] Comparison and verification module: used to compare the construction cost and total construction cost of each stage with the construction cost and total construction cost of each stage in the construction cost document, obtain comparison results, and verify the construction cost and total construction cost of each stage in the construction cost document according to the comparison results to complete the verification process.

[0113] The rest is the same as in Example 1.

[0114] If the above functions are implemented in the form of software functional units and sold or used as independent products, they can be stored in a computer-readable storage medium. Based on this understanding, the technical solution of the present invention, or the part that contributes to the prior art, or the part of the technical solution, can be embodied in the form of a software product. The computer software product is stored in a storage medium and includes several instructions for enabling a computer device (which can be a personal computer, server, or network device, etc.) to execute all or part of the steps of the method described in each embodiment of the present invention. The aforementioned storage medium includes: various media that can store program codes, such as a USB flash drive, a mobile hard disk, a read-only memory (ROM), a random access memory (RAM), a magnetic disk, or an optical disk.

[0115] It will be understood by those skilled in the art that the embodiments of the present invention may be provided as methods, systems, or computer program products. Therefore, the present invention may take the form of a complete hardware embodiment, a complete software embodiment, or an embodiment combining software and hardware. Furthermore, the present invention may take the form of a computer program product implemented on one or more computer-usable storage media (including but not limited to disk storage, CD-ROM, optical storage, etc.) containing computer-usable program code. The solutions in the embodiments of the present invention may be implemented in various computer languages, for example, the object-oriented programming language Java and the interpreted scripting language JavaScript.

[0116] The present invention is described with reference to flowcharts and / or block diagrams of methods, devices (systems), and computer program products according to embodiments of the present invention. It should be understood that each process and / or block in the flowcharts and / or block diagrams, as well as combinations of processes and / or blocks in the flowcharts and / or block diagrams, can be implemented by computer program instructions. These computer program instructions can be provided to a processor of a general-purpose computer, a special-purpose computer, an embedded processor, or other programmable data processing device to produce a machine, so that the instructions executed by the processor of the computer or other programmable data processing device generate instructions for implementing the processes in the flowcharts and / or block diagrams. Figure 1 a process or multiple processes and / or boxes Figure 1 A device that provides the functions specified in a block or multiple blocks.

[0117] These computer program instructions may also be stored in a computer readable memory that can direct a computer or other programmable data processing device to work in a specific manner, so that the instructions stored in the computer readable memory produce an article of manufacture comprising an instruction device, which implements the process Figure 1 a process or multiple processes and / or boxes Figure 1 The function specified in one or more boxes.

[0118] These computer program instructions can also be loaded onto a computer or other programmable data processing device so that a series of operational steps are executed on the computer or other programmable device to produce a computer-implemented process, thereby providing the instructions executed on the computer or other programmable device for implementing the process. Figure 1 a process or multiple processes and / or boxes Figure 1 A step that specifies a function in one or more boxes.

[0119] Although the preferred embodiments of the present invention have been described, those skilled in the art may make additional changes and modifications to these embodiments once they have learned the basic creative concept. Therefore, the appended claims are intended to be interpreted as including the preferred embodiments and all changes and modifications that fall within the scope of the present invention.

[0120] Obviously, those skilled in the art may make various changes and modifications to the present invention without departing from the spirit and scope of the present invention. Thus, if such changes and modifications fall within the scope of the claims and their equivalents, the present invention is intended to include such changes and modifications.

Claims

1. A method for verifying the cost of a single project in a production technology transformation project, characterized in that: The following steps are involved: Obtain cost documents for a single project of a production technology transformation project and correct any deviations; Extract relevant cost indicators based on the cost documents after deviation correction; Obtain the detailed cost items for each stage in the cost document of the single project of the production technology transformation project; Calculate the construction cost details of each stage based on the relevant cost indicators to obtain the construction cost of each stage and the total construction cost; The construction cost and total construction cost of each stage are compared with the construction cost and total construction cost of each stage in the construction cost document to obtain a comparison result, and the construction cost and total construction cost of each stage in the construction cost document are verified based on the comparison result to complete the verification process.

2. The method for verifying the cost of a single project of a production technology transformation project according to claim 1, characterized in that: The steps of deviation correction include: Performing deviation detection on the cost document using a rule-based deviation detection method to obtain a deviation detection result of the cost document; Based on the deviation detection result of the cost document, the deviation is corrected by adopting the Yeo-Johnson transformation method and the external data comparison method to obtain a corrected cost document as the deviation-corrected cost document.

3. The method for verifying the cost of a single project of a production technology transformation project according to claim 2, characterized in that: The step of deviation detection includes: Setting standard rules, including the definition domain, data type, attribute value range, value length range, expected value range and dependencies between attributes for each attribute in the cost document; Based on the standard rules, the cost document is scanned and deviations are detected as deviation detection results of the cost document.

4. The method for verifying the cost of a single project of a production technology transformation project according to claim 2, characterized in that: The steps of obtaining the corrected cost document include: Based on the deviation detection result of the cost document, a Yeo-Johnson transformation method is used to transform the cost document to obtain a transformed cost document; Acquiring external data, wherein the external data is a historical cost file; The transformed cost document is compared and verified with the external data, and further correction is performed based on the comparison and verification results to obtain a corrected cost document.

5. The method for verifying the cost of a single project of a production technology transformation project according to claim 4, characterized in that: The transformation process of the Yeo-Johnson transformation method is expressed as: (1) When y>0 and y is a continuous variable: When λ=0, we have: Y=ln(y+1) When λ≠0, we have: (2) When y<0 and y is a continuous variable: When λ=0, we have: Y=-ln(y+1) When λ≠0, we have: Where λ is the transformation parameter, y is the original data sample, and Y is the transformed data sample.

6. The method for verifying the cost of a single project of a production technology transformation project according to claim 1, characterized in that: The steps of extracting relevant cost indicators include: Based on the deviation-corrected cost file, a Gaussian filter algorithm is used to perform denoising processing to obtain a denoised cost file; Based on the denoised cost document, the OCR recognition method is used to identify the text data and extract relevant cost indicators.

7. The method for verifying the cost of a single project of a production technology transformation project according to claim 1, characterized in that: The stages include estimation, budgeting, budgeting and closing.

8. The method for verifying the cost of a single project of a production technology transformation project according to claim 1, characterized in that: The detailed cost items include construction project costs, installation project fees, overhead communication line fees, distribution building demolition, cable building demolition, installation and demolition fees, cable installation and demolition, overhead line demolition, communication line demolition, installation residue cleaning, equipment purchase costs and remaining costs.

9. A verification system for the cost of a single project in a production technology transformation project, characterized in that: include: Document acquisition and deviation correction module: used to obtain the cost documents of a single project of a production technology transformation project and perform deviation correction; Index extraction module: used to extract relevant cost indicators based on the cost file after deviation correction; Cost item acquisition module: used to obtain the cost item details of each stage in the cost document of a single project of the production technology transformation project; Cost calculation module: used to calculate the cost details of each stage based on the relevant cost indicators to obtain the cost of each stage and the total cost; Comparison and verification module: used to compare the construction cost and total construction cost of each stage with the construction cost and total construction cost of each stage in the construction cost document, obtain comparison results, and verify the construction cost and total construction cost of each stage in the construction cost document according to the comparison results to complete the verification process.

10. A computer-readable storage medium, characterized in that It includes one or more programs for execution by one or more processors of an electronic device, and the one or more programs include instructions for executing the verification method of the single engineering cost of a production technical transformation project as described in any one of claims 1-8.

Images