A method and system for compiling power grid project cost, electronic equipment and storage medium

Abstract

The present invention discloses a method, system, device and storage medium for compiling the cost of a power grid project. The method includes: determining a cost data component library based on power grid project information, determining a project component summary table template based on the cost data component library and first preset information, matching and classifying the first engineering quantity capital raising table data based on the project component summary table template, generating project data entry table data, inspecting the generated data, and analyzing the project data entry table data that has passed the inspection to obtain the cost result of the project. Determining a summary table template based on power grid project information and first preset information, matching and classifying the data based on the summary table template to generate project data entry table data, and inspecting, analyzing and calculating the data to obtain the cost result; the embodiment of the present application can reduce the workload of manual data compilation, improve compilation efficiency, and improve the accuracy of data compilation. The present application can be widely used in the field of engineering cost technology.

Description

Technical Field

[0001] The present invention relates to the technical field of engineering cost, and in particular to a method and system for compiling power grid project cost, electronic equipment and storage medium. Background Art

[0002] Power grid companies' business scope covers a variety of locations, including cities, industrial areas, and rural areas. Therefore, the power distribution network of power grid companies is huge. When overhauling the distribution network and compiling the cost, due to the huge size of the distribution network and the large number of overhaul projects, the processing personnel have to deal with a huge amount of data when compiling the cost. The existing solution mainly relies on the processing personnel to manually compile and summarize the data, which is labor-intensive, takes up a lot of the processing personnel's time and energy, and has low cost compilation accuracy and low data compilation efficiency. Summary of the Invention

[0003] The main purpose of the embodiments of the present application is to propose a method and system for compiling the cost of a power grid project, an electronic device and a storage medium to achieve efficient and accurate cost compilation.

[0004] To achieve the above objectives, one aspect of an embodiment of the present application provides a method for compiling a power grid project cost, the method comprising:

[0005] Obtaining power grid project information, and determining a power grid project cost data component library based on the power grid project information; wherein the power grid project information includes high-voltage overhead lines, low-voltage overhead lines, high-voltage cable lines, low-voltage cable lines, cable trenches, cable conduits, jacking pipes, pole-mounted distribution transformers, and box-type transformers;

[0006] Determine a project component summary table template based on the power grid project cost data component library and first preset information; wherein the first preset information includes assembly category name, construction quota, equipment and main materials;

[0007] Acquire first engineering quantity funding table data, and determine a project data entry form based on the first engineering quantity funding table data and the project component summary table template; wherein the first engineering quantity funding table data represents the sorted engineering quantity funding table data;

[0008] The project data entry form is checked according to the data of the first engineering quantity funding table. If the check passes, the second operation is performed to obtain the cost result; otherwise, the process returns to obtain the data of the first engineering quantity funding table, and determines the project data entry form data according to the data of the first engineering quantity funding table and the project component summary table template until the check passes.

[0009] In some embodiments, determining the project data entry table data based on the first engineering quantity funding table data and the project component summary table template specifically includes:

[0010] Obtain a first instruction, extract data from the first engineering quantity provision table according to the first instruction, determine first data information, and determine second data information according to the project component summary table template; wherein the first data information includes several item names of the first engineering quantity provision table, and the second data information includes the assembly category name, construction quota, equipment, and main material name of the project component summary table template, and the first instruction represents a data summary instruction;

[0011] Matching the first data information with the second data information in sequence, and if the matching is successful, marking the engineering quantity funding table data corresponding to the first data information that matches successfully;

[0012] Obtain a second instruction, write the data marked in the first engineering quantity capital provision table data into the project component summary table template, and obtain project data entry table data; wherein, the second instruction represents a data output instruction.

[0013] In some embodiments, the checking operation on the project data entry form based on the first engineering quantity funding table data specifically includes:

[0014] Obtain a third instruction, sum the data of the first engineering quantity provision table according to the third instruction to obtain a first sum value, and sum the data of the project data entry table according to the third instruction to obtain a second sum value; wherein the third instruction represents a data verification instruction;

[0015] A difference is calculated based on the first summed value and the second summed value, and the difference is compared with a preset condition. If the difference meets the preset condition, it is determined that the test has passed and first information is generated; otherwise, it is determined that the test has failed and a first operation is performed; wherein the first information indicates that the table data is accurate.

[0016] In some embodiments, performing the first operation specifically includes:

[0017] The first sum value is marked according to a preset color, the second sum value is marked according to the preset color, and the second information is sent; wherein the second information indicates that the table data is wrong.

[0018] In some embodiments, performing the second operation to obtain a cost result specifically includes:

[0019] Acquire first data; wherein the first data represents the data entry form data of the project that has passed the inspection;

[0020] The first data is statistically analyzed by cost software to obtain cost results; wherein the cost results include project cost investment and equipment and material details.

[0021] In some embodiments, the method further comprises:

[0022] Obtaining second engineering quantity cost table data and the first preset information; wherein the first preset information includes assembly category name, construction quota, equipment, and main materials; and the second engineering quantity cost table data represents unorganized engineering quantity cost table data;

[0023] Determine third data information based on the second engineering quantity funding table data, match the third data information with the first preset information, and obtain the first engineering quantity funding table data based on the successfully matched third data information, wherein the first engineering quantity funding table data represents the sorted engineering quantity funding table data, and the third data information includes several sub-item names of the second engineering quantity funding table.

[0024] In some embodiments, the method further comprises:

[0025] In response to the data compilation request, a first interface is displayed, wherein the first interface includes a first component, a second component, and a third component;

[0026] In response to a first operation on the first component, the first component generates a first instruction;

[0027] In response to a second operation on the second component, the second component generates a second instruction;

[0028] In response to a third operation on the third component, the third component generates a third instruction.

[0029] To achieve the above objectives, another aspect of the present application provides a system for compiling power grid project costs, the system comprising:

[0030] The first module is configured to obtain power grid project information and determine a power grid project cost data component library based on the power grid project information; wherein the power grid project information includes high-voltage overhead lines, low-voltage overhead lines, high-voltage cable lines, low-voltage cable lines, cable trenches, cable conduits, jacking pipes, pole-mounted distribution transformers, and box-type transformers;

[0031] The second module is configured to determine a project component summary table template based on the power grid project cost data component library and first preset information; wherein the first preset information includes component category name, construction quota, equipment, and main materials;

[0032] A third module is configured to obtain first engineering quantity capital raising table data and determine a project data entry form based on the first engineering quantity capital raising table data and the project component summary table template; wherein the first engineering quantity capital raising table data represents the sorted engineering quantity capital raising table data;

[0033] The fourth module is used to verify the project data entry form based on the first engineering quantity funding table data. If the verification is passed, the first operation is executed to obtain the cost result; otherwise, the first operation is returned to obtain the first engineering quantity funding table data, and the project data entry form data is determined based on the first engineering quantity funding table data and the project component summary table template until the verification is passed.

[0034] To achieve the above-mentioned purpose, another aspect of an embodiment of the present application provides an electronic device, which includes a memory and a processor, wherein the memory stores a computer program, and the processor implements the above-mentioned method when executing the computer program.

[0035] To achieve the above objectives, another aspect of an embodiment of the present application provides a computer-readable storage medium, wherein the computer-readable storage medium stores a computer program, and when the computer program is executed by a processor, the method described above is implemented.

[0036] The implementation of the embodiments of the present invention includes the following beneficial effects: The present application provides a method and device for compiling the cost of a power grid project, an electronic device, and a storage medium. The scheme determines a power grid project cost data component library through power grid project information, determines a project component summary table template based on the power grid project cost data component library and first preset information, matches and classifies the first engineering quantity funding table data based on the project component summary table template, obtains project data entry table data, verifies the obtained project data entry table data, analyzes and calculates based on the verified project data entry table data, and obtains the cost result of the project. Through the power grid project information and the first preset information, a power grid project cost component library and a project component summary table template are constructed, and the obtained engineering quantity funding table data are matched, classified, and counted based on the power grid project cost component library and the project component summary table template to generate project data entry table data, thereby reducing the workload of manual data compilation and improving compilation efficiency; the generated project data entry table data are verified, and the project data entry table data that have passed the verification are analyzed to obtain the cost result of the project, thereby improving the accuracy of data compilation. BRIEF DESCRIPTION OF THE DRAWINGS

[0037] Figure 1 This is a schematic flow chart of the steps of a method for compiling a power grid project cost according to an embodiment of the present invention;

[0038] Figure 2This is a flowchart of steps for generating a project data entry form in a method for compiling a power grid project cost provided by an embodiment of the present invention;

[0039] Figure 3 This is a flowchart of steps for data collation in a method for compiling a power grid project cost provided by an embodiment of the present invention;

[0040] Figure 4 This is a flow chart of steps for checking a generated project data entry form in a method for compiling a power grid project cost provided by an embodiment of the present invention;

[0041] Figure 5 This is a flowchart of the steps for calculating the cost results in a method for compiling the cost of a power grid project provided by an embodiment of the present invention;

[0042] Figure 6 This is a flowchart of component responses in a method for compiling a power grid project cost provided by an embodiment of the present invention;

[0043] Figure 7 This is a schematic diagram of a specific embodiment of the present invention;

[0044] Figure 8 This is a structural block diagram of a power grid project cost compilation system provided by an embodiment of the present invention;

[0045] Figure 9 It is a structural block diagram of an electronic device provided by an embodiment of the present invention. DETAILED DESCRIPTION

[0046] In order to make the purpose, technical solutions and advantages of the present application clearer, the present application is further described in detail below with reference to the accompanying drawings and examples. It should be understood that the specific embodiments described herein are only used to explain the present application and are not intended to limit the present application. When the following description refers to the drawings, unless otherwise indicated, the same numbers in different drawings represent the same or similar elements. The embodiments described in the following exemplary embodiments do not represent all embodiments consistent with the embodiments of the present application. They are merely examples of devices and methods consistent with some aspects of the embodiments of the present application as detailed in the appended claims.

[0047] It will be understood that the terms "first", "second", etc. used in this application may be used herein to describe various concepts, but unless otherwise specified, these concepts are not limited by these terms. These terms are only used to distinguish one concept from another. For example, without departing from the scope of the embodiments of the present application, the first information may also be referred to as the second information, and similarly, the second information may also be referred to as the first information. Depending on the context, the words "if" and "if" as used herein may be interpreted as "at the time of" or "when" or "in response to determining".

[0048] The terms "at least one", "plurality", "each", "any", etc. used in this application include "at least one", "two" or more, "plurality" or "each", "any" or "any one", "each" or "any one" as used herein.

[0049] Unless otherwise defined, all technical and scientific terms used herein have the same meaning as commonly understood by those skilled in the art to which this application pertains. The terms used herein are for the purpose of describing the embodiments of this application only and are not intended to limit this application.

[0050] Due to the expansion of their business scope, the distribution network of power grid companies has become widely distributed. In real life, the operation range of distribution networks covers cities, industrial areas, rural areas, and other places. With the long-term operation of distribution networks and changes in their end-users, the distribution networks may experience some unsafe conditions such as high load operation or aging equipment. Therefore, power grid companies need to overhaul distribution networks that are in unsafe conditions. Overhaul projects require the compilation and summary of data such as equipment, network structure, and equipment status of existing distribution networks, and cost calculations based on this compiled and summarized data. Due to the huge volume of power grid companies' existing distribution networks, the number of distribution networks that need overhaul projects is also very large, and the amount of data that needs to be compiled, summarized, and cost calculated is very large. Existing technologies still use manual methods for data compilation, summary, and cost calculation. Relevant personnel manually collect, count, and fill in relevant data, and perform manual cost calculations. This is labor-intensive, inefficient, and easily causes fatigue to relevant personnel, further reducing data compilation efficiency and accuracy.

[0051] For example, relevant technical personnel are planning to overhaul the power distribution network in a certain area. They need to manually collect the power distribution network data in the area, including the number of power distribution equipment, the status information of each power distribution equipment, and the power distribution network structure, and then manually count, classify, and fill in the collected power distribution network data to obtain the compiled tabular data. Then, they perform cost calculations based on the compiled data to obtain the project cost results of the power distribution network in the area. The data compilation efficiency is low and the accuracy is not high.

[0052] In view of this, an embodiment of the present application provides a method and system for compiling the cost of a power grid project, an electronic device, and a medium. The scheme determines a power grid project cost data component library based on the power grid project information, determines a project component summary table template based on the power grid project cost data component library and first preset information, matches and classifies the obtained first engineering quantity funding table according to the project component summary table template, obtains project data entry form data, verifies the obtained project data entry form data, analyzes and calculates the project data entry form data that passes the verification, and obtains the cost result. Determine a project component summary table template based on the power grid project information and the first preset information, matches and classifies the obtained engineering quantity funding table according to the summary table template, obtains project data entry form data, reduces the workload of manual data compilation, and improves data compilation efficiency; verifies the obtained project data entry form data, analyzes and calculates the project data entry form data that passes the verification, and obtains the cost result, thereby improving the accuracy of data compilation and cost data.

[0053] The method for compiling the cost of a power grid project provided in the embodiment of the present application relates to the field of engineering cost technology. The method for compiling the cost of a power grid project provided in the embodiment of the present application can be applied to a terminal, can be applied to a server, or can be software running in a terminal or a server. In some embodiments, the terminal can be a smart phone, a tablet computer, a laptop computer, a desktop computer, a smart speaker, a smart watch, and a car terminal, etc., but is not limited to this; the server side can be configured as an independent physical server, or can be configured as a server cluster or distributed system composed of multiple physical servers, and can also be configured as a cloud server that provides basic cloud computing services such as cloud services, cloud databases, cloud computing, cloud functions, cloud storage, network services, cloud communications, middleware services, domain name services, security services, CDN, and big data and artificial intelligence platforms. The server can also be a node server in a blockchain network; the software can be an application that implements the method for compiling the cost of a power grid project, etc., but is not limited to the above forms.

[0054] The present application can be used in many general or special computer system environments or configurations. For example: personal computers, server computers, handheld or portable devices, tablet devices, multiprocessor systems, microprocessor-based systems, set-top boxes, programmable consumer electronics, network PCs, minicomputers, mainframe computers, distributed computing environments including any of the above systems or devices, and the like. The present application can be described in the general context of computer-executable instructions executed by a computer, such as program modules. Generally, program modules include routines, programs, objects, components, data structures, and the like that perform specific tasks or implement specific abstract data types. The present application can also be practiced in distributed computing environments in which tasks are performed by remote processing devices connected via a communication network. In a distributed computing environment, program modules can be located in local and remote computer storage media, including storage devices.

[0055] Figure 1 This is an optional flowchart of the method for compiling the cost of a power grid project provided in an embodiment of the present application. Figure 1 The method may include but is not limited to the following steps.

[0056] Step S101: Obtaining grid project information and determining a grid project cost data component library based on the grid project information; wherein the grid project information includes high-voltage overhead lines, low-voltage overhead lines, high-voltage cable lines, low-voltage cable lines, cable trenches, cable conduits, jacking pipes, pole-mounted distribution transformers, and box-type transformers;

[0057] Step S102: determining a project component summary table template based on a power grid project cost data component library and first preset information; wherein the first preset information includes component category name, construction quota, equipment, and main materials;

[0058] Step S103: obtaining first engineering quantity capital raising table data, and determining a project data entry form based on the first engineering quantity capital raising table data and a project component summary table template; wherein the first engineering quantity capital raising table data represents the sorted engineering quantity capital raising table data;

[0059] Step S104, perform a verification operation on the project data entry form according to the data of the first engineering quantity funding table. If the verification passes, execute the first operation to obtain the cost result; otherwise, return to obtain the data of the first engineering quantity funding table, and determine the project data entry form data according to the first engineering quantity funding table data and the project component summary table template until the verification passes.

[0060] In the steps S101 to S104 shown in the embodiment of the present application, by obtaining the type of lines in the distribution network and the construction lengths of different types of lines, as well as the information of the supporting facilities or distribution equipment corresponding to different lines, different categories of cost data component libraries are established based on the obtained information. The cost data component library can perform a preliminary classification of the existing distribution network information; then, for the subsequent cost data calculation, the cost of construction and maintenance of different categories of components, the equipment and main material data information to be replaced during maintenance are added according to the established cost data component library of different categories in the distribution network for project overhaul, and then a template for the assembly summary table of the overhaul project is prepared based on the added data information and the existing component library; the assembly summary table template is obtained. After the board is completed, the uncompiled data can be allocated and summarized according to the template. By matching the uncompiled data with the information in the template, and writing the data into the successfully matched items, and completing the compilation of the data, the corresponding data entry table data is obtained. The table data includes the compiled and summarized data and the cost data corresponding to the compiled and summarized data; before calculating the cost results, the obtained table data is checked to determine the accuracy of the table data. After the accuracy of the table data meets the preset requirements, the cost results are calculated; otherwise, the table data is marked and a prompt message is issued. After receiving the prompt message, the technical personnel will check the table data that does not meet the preset requirements and re-summarize and compile the data.

[0061] In step S101 of some embodiments, the project component library may be established by collecting information about the existing power distribution network or by analyzing historical data in a database of a power grid company, but the present invention is not limited thereto.

[0062] See also Figure 2 In some embodiments, step S103 may include but is not limited to steps S210 to S230:

[0063] Step S210: Obtain a first instruction, extract data from the first engineering quantity provision table according to the first instruction, determine first data information, and determine second data information according to the project component summary table template; wherein the first data information includes several sub-item names of the first engineering quantity provision table, and the second data information includes the assembly category name, construction quota, equipment, and main material name of the project component summary table template. The first instruction represents a data summary instruction;

[0064] Step S220: Match the first data information with the second data information in sequence. If the matching is successful, mark the engineering quantity provision table data corresponding to the first data information that matches successfully.

[0065] Step S230, obtaining a second instruction, writing the marked data in the first engineering quantity provision table data into the project component summary table template, and obtaining project data entry table data; wherein the second instruction represents a data output instruction.

[0066] In step S210 of some embodiments, the project assembly summary table template obtained through step S102 is used to perform statistical summary on the obtained engineering quantity provision table, which includes equipment and materials for overhauling the distribution network of the project and corresponding data; after receiving the instruction to perform data summary, the data of the engineering quantity provision table is extracted item by item for subsequent matching and entry; illustratively, the engineering quantity provision table includes data data of 1KV and below cable lines, cable ducts and box transformers, and the project assembly summary table template includes the names of various types of assemblies, construction quotas, equipment and main material data, and the data in the engineering quantity provision table is extracted according to the items of 1KV and below cable lines, cable ducts and box transformers for subsequent matching and entry.

[0067] In step S220 of some embodiments, after the data in the engineering quantity provision table is extracted item by item, the extracted items are matched item by item with all items in the project assembly summary table template until a successful match is found, and the successfully matched items in the engineering quantity provision table and the items in the project assembly summary table template are marked. Then, the next item of data in the engineering quantity provision table is extracted, and the matching operation with all items in the project assembly summary table template and the successfully matched items are marked are repeated until all data in the engineering quantity provision table are matched and marked.

[0068] In step S230 of some embodiments, after all the data in the engineering quantity provision table are matched and marked, a data output instruction is received, and the information data in the engineering quantity provision table is written into the corresponding item in the project assembly summary table template according to the marked matching result, and a project data entry form is generated according to the project assembly summary table template with the written data; in some embodiments, the obtained project data entry form can also be sent to a database for storage or print output.

[0069] The data compilation of the distribution network data is achieved by generating a project data entry form. At the same time, the project data entry form also summarizes and compiles the corresponding cost data, providing a basis for the subsequent cost result calculation.

[0070] See also Figure 3 In some embodiments, before step S210, the method for compiling the cost of a power grid project further includes steps S201 to S202:

[0071] Step S201: obtaining second engineering quantity cost table data and first preset information; wherein the first preset information includes assembly category name, construction quota, equipment, and main materials; and the second engineering quantity cost table data represents unorganized engineering quantity cost table data;

[0072] Step S202: determine third data information based on the second engineering quantity provision table data, match the third data information with the first preset information, and obtain first engineering quantity provision table data based on the successfully matched third data information, wherein the first engineering quantity provision table data represents the sorted engineering quantity provision table data, and the third data information includes several sub-item names of the second engineering quantity provision table.

[0073] In step S201 of some embodiments, original quantity data is collected and extracted from the design cost provision table. The quantity data includes component data of various categories used for design, cost data for construction, and equipment data and material data required for construction. These data correspond to the data items in the project cost data component library determined in step S101. Therefore, the collected and extracted original quantity data can be sorted according to the data items in the project cost data component library to obtain the quantity provision table for subsequent data compilation and cost calculation.

[0074] In step S202 of some embodiments, data items are extracted from the original engineering quantity data, and the extracted data items are matched with the data items of the project cost data component library in step S101 to determine whether the data items in the original engineering quantity data are consistent with the data items of the project cost data component library. The original engineering quantity data is sorted based on the data items that are determined to be consistent to obtain engineering quantity capital provision table data for subsequent data compilation and cost result calculation.

[0075] See also Figure 4 In some embodiments, step S104 may include but is not limited to steps S301 to S302:

[0076] Step S301: Obtain a third instruction, sum the data in the first engineering quantity provision table according to the third instruction to obtain a first sum value, and sum the data in the project data entry table according to the third instruction to obtain a second sum value; wherein the third instruction represents a data verification instruction;

[0077] Step S302, calculate the difference based on the first sum value and the second sum value, compare the difference with the preset condition, if the difference meets the preset condition, determine that the test is passed, and generate the first information; otherwise, determine that the test is failed, and perform the first operation; wherein, the first information represents that the table data is accurate.

[0078] In step S301 of some embodiments, after the project data entry form is generated through steps S201 to S203, the entry form needs to be checked to determine the accuracy of the data in the generated form; since the generation of the project data entry form is to summarize and compile the data of the engineering quantity funding table, the project data entry form can be checked based on the engineering quantity funding table; first, the various engineering quantity data in the engineering quantity funding table are statistically summed to obtain a sum value, and then the engineering quantity data in the generated project data entry table are statistically summed to obtain another sum value; through the two sum values, it can be determined whether the data in the generated project data entry table is accurate.

[0079] In step S302 of some embodiments, the two sum values ​​obtained in step S301 are compared by difference. If the result of the difference comparison of the two sum values ​​is 0, it means that the data in the generated project data entry form is consistent with the data in the engineering quantity capital raising table, and the data in the generated project data entry form is determined to be accurate, and subsequent cost calculation can be performed; if the result of the difference comparison of the two sum values ​​is not 0, it means that the data in the generated project data entry form is inconsistent with the data in the engineering quantity capital raising table, and the data in the generated project data entry form is determined to be wrong, and the processing personnel need to review the project data entry form with wrong data and recompile the data.

[0080] See also Figure 5 In some embodiments, step S104 may also include but is not limited to steps S303 to S304:

[0081] Step S303, obtaining first data; wherein the first data represents the data entry table data of the project that has passed the inspection;

[0082] Step S304: Perform statistical analysis on the first data using cost software to obtain cost results; wherein the cost results include project cost investment and equipment and material details.

[0083] In step S303 of some embodiments, the project data entry form corresponding to the sum value difference comparison result of 0 in step S302 is obtained, and then the project data entry form is imported into the cost calculation software, and data transmission can be performed by wired or wireless means.

[0084] In step S304 of some embodiments, after the project data entry form that has been verified to be accurate through data verification in step S303 is imported into the cost calculation software, the cost calculation software performs statistical analysis on the data in the project data entry form to calculate the cost results corresponding to the data in the entry form. Technical personnel can perform subsequent evaluations and other operations on the distribution network for the overhaul project based on the obtained cost results.

[0085] In some embodiments, step S104 further includes step S305:

[0086] Step S305 : Mark the first sum value according to a preset color, mark the second sum value according to a preset color, and send a second message; wherein the second message indicates that the table data is wrong.

[0087] In step S305 of some embodiments, after step S302, the sum value difference comparison is performed, and the project data entry form with the sum value difference comparison result of 0 is imported into the cost calculation software to calculate the cost result; for the project data entry form with the sum value difference comparison result not being 0, the project data entry form with the difference comparison result not being 0 is marked according to a preset color. At the same time, in order to facilitate the review by technical personnel, the engineering quantity provision table for inspection of the project data entry form is also marked with a preset color, and then a prompt message is sent to the technical personnel for prompting.

[0088] See also Figure 6 The power grid project cost compilation method further includes steps S401 to S404:

[0089] Step S401: In response to a data compilation request, a first interface is displayed, where the first interface includes a first component, a second component, and a third component.

[0090] Step S402: In response to a first operation on a first component, the first component generates a first instruction;

[0091] Step S403: In response to the second operation on the second component, the second component generates a second instruction;

[0092] Step S404: In response to the third operation on the third component, the third component generates a third instruction.

[0093] In step S401 of some embodiments, the technician sends a data compilation request. After receiving the data compilation request, the cost compilation system obtains the data waiting for compilation through the data interface and displays the first interface. The first interface is provided with several components corresponding to different operations. These components can be classified according to function and divided into different functional areas. The technician can operate different components according to actual application requirements, and the corresponding components respond to the technician's operation to execute the preset operation in the component.

[0094] In step S402 of some embodiments, a first operation is performed on the first component in the first section interface, the first component generates a first instruction, a data aggregation operation is performed on the acquired data, characteristic information such as the data name is extracted and matched with the prepared summary table template, and the successfully matched data is marked.

[0095] In step S403 of some embodiments, a second operation is performed on the second component in the first section interface, the second component generates a second instruction, and a data output operation is performed on the acquired data. After all the acquired data are matched and the successfully matched data are marked, the marked data is written into the summary table template, and the data is written item by item according to the matching results to generate project data entry table data.

[0096] In step S404 of some embodiments, a third operation is performed on the third component in the first section interface, the third component generates a third instruction, a data verification operation is performed on the acquired data, the generated project data entry table data is acquired, the acquired data is summed, and the total amount of data that needs to be compiled is determined. Then, the generated project data entry table data is summed again to determine the total amount of data for which data compilation is completed, and the difference between the two summation results is calculated to verify the accuracy of the data compilation results to see if there are any omissions.

[0097] The following describes the embodiments of the present invention in detail with reference to specific application examples:

[0098] Reference Figure 7 , Figure 7A schematic diagram of a method for compiling the cost of a power grid project provided in an embodiment of the present application is shown. In an embodiment of the present application, information on a power grid overhaul project is first collected, and based on the characteristics of the power grid overhaul project, a power grid overhaul project cost data component library is established, including 10kV overhead lines, 1kV and below overhead lines, 10kV cable lines, 1kV and below cable lines, cable trenches, cable pipes, jacking pipes, pole-mounted distribution transformers, and box transformers; then, the component names, construction quotas, equipment, and main material data information of each category in the component library are determined from the established power grid overhaul project cost data component library, and a project component summary table template is prepared based on the obtained component names, construction quotas, equipment, and main material data information of each category; then, the engineering project design data is collected, the collected data is sorted, and it is checked whether the names of each sub-item in the data are consistent with the component names, construction quotas, equipment, and main material data information of each category in the power grid overhaul project cost data component library, and a project quantity raising table is obtained based on the consistent data; then, the names of each sub-item in the engineering quantity raising table are matched item by item with the component names, construction quotas, equipment, and main material data information of each category in the prepared project component summary table template. , and mark the items that have been matched successfully. After all items in the engineering quantity funding table are matched, the data of the marked items are written into the project component summary table template to generate a project data entry form; after the project data entry form is generated, the accuracy of the data in the project data entry form is checked according to the data in the engineering quantity funding table, and the data in the engineering quantity funding table and the data in the project data entry form are statistically summed to obtain the second sum value of the data in the project data entry form corresponding to the first sum value of the data in the engineering quantity funding table, and the difference between the first sum value and the second sum value is compared; the project data entry form with a difference comparison result of zero is determined to be accurate, and the project data entry form is imported into the cost calculation software. The project data entry form is statistically analyzed by the cost calculation software to obtain the project cost result; the project data entry form with a difference comparison result not being 0 is determined to be a data error, and the two sum values ​​are marked in red, and a prompt message is sent to the technical personnel, and the engineering quantity funding table is re-collected and sorted to obtain a new engineering quantity funding table, and then data compilation and cost calculation are carried out.

[0099] The implementation of the embodiments of the present invention includes the following beneficial effects: The present application provides a method and device for compiling the cost of a power grid project, an electronic device and a storage medium. The scheme determines a power grid project cost data component library through power grid project information, determines a project component summary table template based on the power grid project cost data component library and first preset information, matches and classifies the first engineering quantity funding table data according to the project component summary table template, writes the matched and classified first engineering quantity funding table into the project component summary table template, generates project data entry table data, and then performs data accuracy inspection on the generated project data entry table data according to the first engineering quantity funding table, analyzes and calculates the project data entry table data that passes the inspection, and obtains the cost result of the project. Through the power grid project information and the first preset information, a power grid project cost component library and a project component summary table template are constructed. According to the power grid project cost component library and the project component summary table template, the obtained engineering quantity funding table data are matched, classified and counted to generate project data entry form data, thereby reducing the workload of manual data compilation and improving compilation efficiency; the generated project data entry form data is inspected, and based on the project data entry form data that has passed the inspection, it is analyzed to obtain the project cost result, thereby improving the accuracy of data compilation.

[0100] See also Figure 8 The present application also provides a power grid project cost compilation system that can implement the above-mentioned power grid cost compilation method. The system includes:

[0101] The first module is configured to obtain power grid project information and determine a power grid project cost data component library based on the power grid project information; wherein the power grid project information includes high-voltage overhead lines, low-voltage overhead lines, high-voltage cable lines, low-voltage cable lines, cable trenches, cable conduits, jacking pipes, pole-mounted distribution transformers, and box-type transformers;

[0102] The second module is configured to determine a project component summary table template based on the power grid project cost data component library and first preset information; wherein the first preset information includes component category name, construction quota, equipment, and main materials;

[0103] A third module is configured to obtain first engineering quantity capital raising table data and determine a project data entry form based on the first engineering quantity capital raising table data and the project component summary table template; wherein the first engineering quantity capital raising table data represents the sorted engineering quantity capital raising table data;

[0104] The fourth module is used to verify the project data entry form based on the first engineering quantity funding table data. If the verification is passed, the first operation is executed to obtain the cost result; otherwise, the first operation is returned to obtain the first engineering quantity funding table data, and the project data entry form data is determined based on the first engineering quantity funding table data and the project component summary table template until the verification is passed.

[0105] It can be understood that the contents of the above method embodiments are all applicable to the present system embodiments, the functions specifically implemented by the present system embodiments are the same as those of the above method embodiments, and the beneficial effects achieved are also the same as those achieved by the above method embodiments.

[0106] The present application also provides an electronic device comprising a memory and a processor. The memory stores a computer program, and the processor executes the computer program to implement the aforementioned method for compiling a power grid project cost. The electronic device can be any smart terminal, including a tablet computer and an in-vehicle computer.

[0107] It can be understood that the contents of the above method embodiments are applicable to the present device embodiments, the functions specifically implemented by the present device embodiments are the same as those of the above method embodiments, and the beneficial effects achieved are also the same as those achieved by the above method embodiments.

[0108] See also Figure 9 , Figure 9 The hardware structure of an electronic device according to another embodiment is shown. The electronic device includes:

[0109] The processor 901 can be implemented as a general-purpose CPU (Central Processing Unit), a microprocessor, an application-specific integrated circuit (ASIC), or one or more integrated circuits, and is used to execute relevant programs to implement the technical solutions provided in the embodiments of the present application;

[0110] The memory 902 can be implemented in the form of a read-only memory (ROM), a static storage device, a dynamic storage device, or a random access memory (RAM). The memory 902 can store an operating system and other application programs. When the technical solutions provided in the embodiments of this specification are implemented through software or firmware, the relevant program code is stored in the memory 902 and is called by the processor 901 to execute the power grid project cost compilation method of the embodiment of this application;

[0111] Input / output interface 903, used to implement information input and output;

[0112] Communication interface 904, used to implement communication interaction between this device and other devices, which can be achieved through wired means (such as USB, network cable, etc.) or wireless means (such as mobile network, WiFi, Bluetooth, etc.);

[0113] Bus 905 , which transmits information between various components of the device (e.g., processor 901 , memory 902 , input / output interface 903 , and communication interface 904 );

[0114] The processor 901 , the memory 902 , the input / output interface 903 and the communication interface 904 are connected to each other in communication within the device via a bus 905 .

[0115] In addition, the embodiments of the present application further disclose a computer program product or computer program, which is stored in a computer-readable storage medium. The processor of a computer device can read the computer program from the computer-readable storage medium, and the processor executes the computer program, so that the computer device performs the above-mentioned method. Similarly, the contents of the above-mentioned method embodiment are all applicable to the present storage medium embodiment, and the functions specifically implemented by the present storage medium embodiment are the same as those of the above-mentioned method embodiment, and the beneficial effects achieved are also the same as those achieved by the above-mentioned method embodiment.

[0116] An embodiment of the present application also provides a computer-readable storage medium, which stores a computer program. When the computer program is executed by a processor, it implements the above-mentioned method for compiling the cost of a power grid project.

[0117] It can be understood that the contents of the above method embodiments are all applicable to the present storage medium embodiment, the functions specifically implemented by the present storage medium embodiment are the same as those of the above method embodiments, and the beneficial effects achieved are also the same as those achieved by the above method embodiments.

[0118] The memory, as a non-transient computer-readable storage medium, can be used to store non-transient software programs and non-transient computer executable programs. In addition, the memory may include a high-speed random access memory and may also include a non-transient memory, such as at least one disk storage device, a flash memory device, or other non-transient solid-state storage device. In some embodiments, the memory may optionally include a memory remotely arranged relative to the processor, and these remote memories may be connected to the processor via a network. Examples of the above-mentioned network include, but are not limited to, the Internet, an intranet, a local area network, a mobile communication network, and combinations thereof.

[0119] The embodiments of the present application provide a method for compiling a power grid project cost, a power grid project cost compilation system, an electronic device, and a storage medium, which: establish a power grid project cost data component library based on power grid project information, and obtain a project component summary table template based on the power grid project cost data component library, wherein the project component summary table template includes the name of each type of component, construction quota, equipment, and main material information, collects and organizes the engineering design engineering quantity capital raising table, matches the engineering quantity capital raising table with the project component summary table template, and writes the engineering quantity capital raising table into the project component summary table template according to the matching result, generates a project data entry form, and then performs a data accuracy check on the generated project data entry form based on the engineering quantity capital raising table, and the project data that passes the accuracy check is recorded. The project data entry form is imported into the cost calculation software to calculate the cost results; a project cost data component library is established based on the power grid project information, and a project component summary table template is made based on the established project cost data component library. The data of the engineering quantity funding table is compiled based on the produced project component summary table template to generate a project data entry form, thereby reducing the workload of manual data compilation and improving the efficiency of data compilation; the generated project data entry form is tested for data accuracy based on the data of the engineering quantity funding table, the data of the project data entry form that fails the test is reorganized and compiled, and the project data entry form that passes the test is imported into the cost calculation software for statistical calculation, thereby improving the accuracy of data compilation and cost results.

[0120] The embodiments described in the embodiments of this application are intended to more clearly illustrate the technical solutions of the embodiments of this application and do not constitute a limitation on the technical solutions provided by the embodiments of this application. Those skilled in the art will appreciate that with the evolution of technology and the emergence of new application scenarios, the technical solutions provided in the embodiments of this application are also applicable to similar technical problems.

[0121] Those skilled in the art will understand that the technical solutions shown in the figures do not constitute a limitation on the embodiments of the present application, and may include more or fewer steps than shown in the figures, or a combination of certain steps, or different steps.

[0122] The device embodiments described above are merely illustrative. The units described as separate components may or may not be physically separate, i.e., they may be located in one place or distributed across multiple network units. Some or all of the modules may be selected based on actual needs to achieve the objectives of this embodiment.

[0123] Those skilled in the art will appreciate that all or some of the steps in the methods, systems, and functional modules in the devices disclosed above may be implemented as software, firmware, hardware, or appropriate combinations thereof.

[0124] The terms "first," "second," "third," "fourth," and the like in the specification and accompanying drawings of the present application are used to distinguish similar objects and are not necessarily used to describe a specific order or sequential sequence. It should be understood that the numbers used in this manner are interchangeable where appropriate so that the embodiments of the present application described herein can be implemented in an order other than those illustrated or described herein. In addition, the terms "including" and "having," as well as any variations thereof, are intended to cover non-exclusive inclusions, e.g., a process, method, system, product, or apparatus comprising a series of steps or units is not necessarily limited to those steps or units clearly listed, but may include other steps or units that are not clearly listed or that are inherent to these processes, methods, products, or apparatus.

[0125] In the several embodiments provided in this application, it should be understood that the disclosed devices and methods can be implemented in other ways. For example, the device embodiments described above are merely schematic. For example, the division of the above-mentioned units is only a logical function division. In actual implementation, there may be other division methods, such as multiple units or components can be combined or integrated into another system, or some features can be ignored or not executed. Another point is that the mutual coupling or direct coupling or communication connection shown or discussed can be through some interfaces, indirect coupling or communication connection of devices or units, which can be electrical, mechanical or other forms.

[0126] The units described above as separate components may or may not be physically separate, and the components shown as units may or may not be physical units, that is, they may be located in one place or distributed across multiple network units. Some or all of these units may be selected according to actual needs to achieve the purpose of the solution of this embodiment.

[0127] In addition, the functional units in the various embodiments of the present application may be integrated into a single processing unit, or each unit may exist physically separately, or two or more units may be integrated into a single unit. The aforementioned integrated units may be implemented in the form of hardware or software functional units.

[0128] If the integrated unit is implemented in the form of a software functional unit and sold or used as an independent product, it can be stored in a computer-readable storage medium. Based on this understanding, the technical solution of the present application, or the part that contributes to the prior art, or all or part of the technical solution can be embodied in the form of a software product, which is stored in a storage medium and includes multiple 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 methods of various embodiments of the present application. The aforementioned storage medium includes: various media that can store programs, 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.

[0129] The preferred embodiments of the present invention are described above with reference to the accompanying drawings, but are not intended to limit the scope of the present invention. Any modifications, equivalent substitutions, and improvements made by those skilled in the art without departing from the scope and essence of the present invention should be within the scope of the present invention.

Claims

1. A method for compiling the cost of a power grid project, characterized in that: The method comprises: Obtaining power grid project information, and determining a power grid project cost data component library based on the power grid project information; wherein the power grid project information includes high-voltage overhead lines, low-voltage overhead lines, high-voltage cable lines, low-voltage cable lines, cable trenches, cable conduits, jacking pipes, pole-mounted distribution transformers, and box-type transformers; Determine a project component summary table template based on the power grid project cost data component library and first preset information; wherein the first preset information includes assembly category name, construction quota, equipment and main materials; Obtaining second engineering quantity provision table data and the first preset information; wherein the first preset information includes the assembly category name, construction quota, equipment, and main materials, and the second engineering quantity provision table data represents unorganized engineering quantity provision table data; determining third data information based on the second engineering quantity provision table data, matching the third data information with the first preset information, and obtaining first engineering quantity provision table data based on the successfully matched third data information, wherein the first engineering quantity provision table data represents organized engineering quantity provision table data, and the third data information includes several sub-item names of the second engineering quantity provision table; obtaining the first engineering quantity provision table data, and determining a project data entry form based on the first engineering quantity provision table data and the project component summary table template; The project data entry form is checked according to the data of the first engineering quantity raising table. If the check passes, a second operation is performed to obtain a cost result. The second operation is performed to obtain a cost result, which specifically includes: obtaining first data; wherein the first data represents the data of the project data entry form that has passed the check; performing a statistical analysis operation on the first data through cost software to obtain a cost result; wherein the cost result includes a project cost investment and equipment and material details; otherwise, returning to the step of obtaining the first engineering quantity raising table data, and determining the project data entry form data according to the first engineering quantity raising table data and the project component summary table template, until the check passes.

2. The method according to claim 1, characterized in that The determining of the project data entry table data based on the first engineering quantity funding table data and the project component summary table template specifically includes: Obtain a first instruction, extract data from the first engineering quantity provision table according to the first instruction, determine first data information, and determine second data information according to the project component summary table template; wherein the first data information includes several item names of the first engineering quantity provision table, and the second data information includes the assembly category name, construction quota, equipment, and main material name of the project component summary table template, and the first instruction represents a data summary instruction; Matching the first data information with the second data information in sequence, and if the matching is successful, marking the first engineering quantity funding table data corresponding to the first data information that matches successfully; Obtain a second instruction, write the data marked in the first engineering quantity capital provision table data into the project component summary table template, and obtain project data entry table data; wherein, the second instruction represents a data output instruction.

3. The method according to claim 1, characterized in that The checking operation on the project data entry form according to the first engineering quantity funding table data specifically includes: Obtain a third instruction, sum the data of the first engineering quantity provision table according to the third instruction to obtain a first sum value, and sum the data of the project data entry table according to the third instruction to obtain a second sum value; wherein the third instruction represents a data verification instruction; A difference is calculated based on the first summed value and the second summed value, and the difference is compared with a preset condition. If the difference meets the preset condition, it is determined that the test has passed and first information is generated; otherwise, it is determined that the test has failed and a first operation is performed; wherein the first information indicates that the table data is accurate.

4. The method according to claim 3, characterized in that The performing of the first operation specifically includes: The first sum value is marked according to a preset color, the second sum value is marked according to the preset color, and second information is sent; wherein the second information indicates that the table data is wrong.

5. The method according to any one of claims 1 to 4, characterized in that The method further comprises: In response to the data compilation request, a first interface is displayed, wherein the first interface includes a first component, a second component, and a third component; In response to a first operation on the first component, the first component generates a first instruction; In response to a second operation on the second component, the second component generates a second instruction; In response to a third operation on the third component, the third component generates a third instruction.

6. A power grid project cost compilation system, characterized in that: The system comprises: The first module is configured to obtain power grid project information and determine a power grid project cost data component library based on the power grid project information; wherein the power grid project information includes high-voltage overhead lines, low-voltage overhead lines, high-voltage cable lines, low-voltage cable lines, cable trenches, cable conduits, jacking pipes, pole-mounted distribution transformers, and box-type transformers; The second module is configured to determine a project component summary table template based on the power grid project cost data component library and first preset information; wherein the first preset information includes component category name, construction quota, equipment, and main materials; The third module is used to obtain second engineering quantity provision table data and the first preset information; wherein the first preset information includes the assembly category name, construction quota, equipment, and main materials, and the second engineering quantity provision table data represents unorganized engineering quantity provision table data; determine third data information based on the second engineering quantity provision table data, match the third data information with the first preset information, and obtain first engineering quantity provision table data based on the successfully matched third data information, wherein the first engineering quantity provision table data represents organized engineering quantity provision table data, and the third data information includes several sub-item names of the second engineering quantity provision table; obtain the first engineering quantity provision table data, and determine the project data entry form based on the first engineering quantity provision table data and the project component summary table template; The fourth module is used to verify the project data entry form based on the first engineering quantity funding table data. If the verification is passed, the second operation is executed to obtain the cost result; the execution of the second operation to obtain the cost result specifically includes: obtaining first data; wherein, the first data represents the data of the project data entry form that has passed the verification; performing statistical analysis operations on the first data through cost software to obtain the cost result; wherein, the cost result includes the project cost investment and equipment and material details; otherwise, returning to the step of obtaining the first engineering quantity funding table data, and determining the project data entry form data based on the first engineering quantity funding table data and the project component summary table template, until the verification is passed.

7. An electronic device, characterized in that: The electronic device includes a memory and a processor, the memory stores a computer program, and the processor implements the method according to any one of claims 1 to 5 when executing the computer program.

8. A computer-readable storage medium storing a computer program, characterized in that: When the computer program is executed by a processor, it is used to perform the method according to any one of claims 1 to 5.

Images