Power distribution project commission data processing method and system, electronic equipment and medium

Abstract

The invention discloses a power distribution project commission data processing method and system, electronic equipment and a storage medium, and the method comprises the steps: obtaining a project cost commission table data set, processing the project cost commission table data set according to a preset summary table template, and obtaining target summary data; checking the target summarized data according to the project cost commission table data, and determining a checking result; if the verification is passed, outputting the target summarized data as a data processing result; and if the verification is not passed, the project cost commission table data set is obtained again for data processing. Summarizing and counting the acquired project cost commission table data based on a preset summarizing template to generate target summarized data, so that the data processing efficiency is improved; the target summarized data is verified, the target summarized data passing the verification are output, the data not passing the verification are processed again, and the accuracy of the data processing result is improved; the embodiment of the invention can be widely applied to the technical field of data processing.

Description

Technical Field

[0001] The present invention relates to the technical field of data processing, and particularly to a method, a system, an electronic device and a storage medium for processing commission data of a power distribution project. Background Art

[0002] Power design companies set corresponding performance commissions for designers and employees participating in grid projects, which can effectively improve the work enthusiasm and creativity of designers and employees; however, due to the large number of grid projects in power design companies and the large number of designers involved, the commission data to be statistically processed is huge and messy. Manual statistical summary processing consumes a lot of time and energy, with low processing efficiency and low accuracy of processing results. Summary of the Invention

[0003] The main purpose of the embodiments of the present invention is to provide a method, a system, an electronic device and a storage medium for processing commission data of a power distribution project, which can improve the processing efficiency and the accuracy of processing results.

[0004] To achieve the above object, on the one hand, an embodiment of the present invention provides a method for processing commission data of a power distribution project, the method comprising:

[0005] Obtain a data set of project cost commission tables, and process according to the data set of project cost commission tables and a preset summary table template to determine target summary data; wherein, the data set of project cost commission tables includes project cost commission tables of several projects;

[0006] Verify according to the target summary data and the data set of project cost commission tables to determine a verification result;

[0007] If the verification result is verification passed, use the target summary data as the data processing result;

[0008] If the verification result is verification failed, return to execute the step of obtaining the data set of project cost commission tables until the verification result is verification passed.

[0009] In some embodiments, the processing according to the data set of project cost commission tables and a preset summary table template to determine target summary data specifically includes:

[0010] Analyze the data set of project cost commission tables, extract a data set of designer information, and match the data set of designer information with a preset data set of participating personnel information to determine a matching result;

[0011] If the matching result is consistent, fill in the project cost commission table data corresponding to the designer information with consistent matching into the preset summary table template to determine the target summary data.

[0012] In some embodiments, verifying the target summary data against the project cost commission table dataset to determine a verification result specifically includes:

[0013] Summing the project cost commission table dataset to determine a first data; summing the target summary data to obtain a second data; and comparing the difference between the first data and the second data to determine a comparison result;

[0014] If the comparison result is of a first type, determine that the verification result of the target summary data is verification passed;

[0015] If the comparison result is of a second type, determine that the verification result of the target summary data is verification failed.

[0016] In some embodiments, the method further includes:

[0017] If the comparison result is of a second type, mark the first data and the second data according to a preset color and generate a first prompt message.

[0018] In some embodiments, the project cost commission table is determined according to the following method:

[0019] Obtain power grid project data, calculate according to a preset commission relationship and the power grid project data to determine project commission data; wherein, the project commission data includes total project commission data and project designer commission data;

[0020] Process the power grid project data, the project commission data and a preset cost commission filling form template to obtain the project cost commission table.

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

[0022] Obtain a path information set, access according to the path information set to determine a number of the project cost commission tables; wherein, the path information set includes computer path information for storing the project cost commission tables;

[0023] Analyze the project cost commission tables to determine participant information, compare the participant information with a participant information set to determine a comparison result;

[0024] Summarize a number of the project cost commission tables according to the comparison result to determine the project cost commission table dataset.

[0025] In some embodiments, summarizing a number of the project cost commission tables according to the comparison result to determine the project cost commission table dataset specifically includes:

[0026] If the comparison result is that the information is consistent, summarize the project cost commission table corresponding to the participant information to determine the project cost commission table data set;

[0027] If the comparison result is that the information is inconsistent, generate a second prompt message according to the project cost commission table corresponding to the participant information.

[0028] To achieve the above object, another aspect of the embodiments of the present invention provides a distribution project commission data processing system, the system includes:

[0029] A first module, configured to obtain project cost commission table data, process the project cost commission table data with a preset summary table template to determine target summary data;

[0030] A second module, configured to verify the target summary data and the project cost commission table data to determine a verification result;

[0031] A third module, configured to use the target summary data as a data processing result if the verification result is passed;

[0032] If the verification result is not passed, return to execute the obtaining of the project cost commission table data until the verification result is passed.

[0033] To achieve the above object, another aspect of the embodiments of the present application provides an electronic device, the electronic device includes a memory and a processor, the memory stores a computer program, and when the processor executes the computer program, the foregoing method is implemented.

[0034] To achieve the above object, another aspect of the embodiments of the present application provides a computer-readable storage medium, the computer-readable storage medium stores a computer program, and when the computer program is executed by a processor, the foregoing method is implemented.

[0035] Implementing the embodiments of the present invention includes the following beneficial effects: This embodiment provides a method, system, electronic device, and storage medium for processing commission data of a power distribution project. The solution obtains a dataset of project expense commission tables, processes the obtained dataset of project expense commission tables according to a preset summary table template to obtain target summary data; then verifies the generated target summary data based on the obtained project expense commission table data to determine the verification result; determines whether to output the data processing result based on the verification result. If the target summary data passes the verification, the target summary data is output as the data processing result; if the target summary data fails the verification, the dataset of project expense commission tables is obtained again for data processing. Summarize and statistically analyze the obtained project expense commission table data based on a preset summary template to generate target summary data, reducing manual data screening and statistical summarization, and improving data processing efficiency; verify the generated target summary data, output the target summary data that passes the verification, and reprocess the data that fails the verification, improving the accuracy of the data processing result and the data processing efficiency. Description of the Drawings

[0036] Figure 1 is the overall structural schematic diagram of an implementation tool for a method of processing commission data of a power distribution project provided by an embodiment of the present invention;

[0037] Figure 2 is the step flow schematic diagram of a method of processing commission data of a power distribution project provided by an embodiment of the present invention;

[0038] Figure 3 is the step flow schematic diagram of determining target summary data in a method of processing commission data of a power distribution project provided by an embodiment of the present invention;

[0039] Figure 4 is the step flow schematic diagram of determining the verification result in a method of processing commission data of a power distribution project provided by an embodiment of the present invention;

[0040] Figure 5 is the step flow schematic diagram of determining a project expense commission table in a method of processing commission data of a power distribution project provided by an embodiment of the present invention;

[0041] Figure 6 is the step flow schematic diagram of another method of obtaining a dataset of project expense commission tables in a method of processing commission data of a power distribution project provided by an embodiment of the present invention;

[0042] Figure 7 is the step flow schematic diagram of summarizing to obtain a dataset of project expense commission tables in a method of processing commission data of a power distribution project provided by an embodiment of the present invention;

[0043] Figure 8It is a schematic diagram of the step flow of a specific embodiment provided by an embodiment of the present invention;

[0044] Figure 9 It is a schematic diagram of the display interface of a statistical tool in a specific embodiment provided by an embodiment of the present invention;

[0045] Figure 10 It is a schematic diagram of the structure of a distribution project commission data processing system provided by an embodiment of the present invention;

[0046] Figure 11 It is a schematic diagram of the hardware structure of an electronic device provided by an embodiment of the present invention. Specific Embodiments

[0047] The present invention will be further described in detail below with reference to the accompanying drawings and specific embodiments. For the step numbers in the following embodiments, they are only set for the convenience of explanation and illustration, and no limitation is imposed on the order between the steps. The execution order of each step in the embodiments can be adaptively adjusted according to the understanding of those skilled in the art.

[0048] In the following description, reference is made to "some embodiments", which describe a subset of all possible embodiments. However, it can be understood that "some embodiments" can be the same subset or different subsets of all possible embodiments, and can be combined with each other without conflict.

[0049] In the following description, the terms "first / second / third" are only used to distinguish similar objects and do not represent a specific order for the objects. It can be understood that "first / second / third" can be interchanged with a specific order or sequence when allowed, so that the embodiments of the present invention described here can be implemented in an order other than that illustrated or described here.

[0050] Unless otherwise defined, all technical and scientific terms used in the embodiments of the present invention have the same meaning as commonly understood by those skilled in the technical field to which the present invention belongs. The terms used in the embodiments of the present invention are only for the purpose of describing the embodiments of the present invention and are not intended to limit the present invention.

[0051] Figure 1 It is a schematic diagram of the structure of a performance commission output value statistical tool developed based on the Visual Basic macro language, including a data acquisition and statistics function module and a data verification function module, and is used to implement a distribution project commission data processing method provided by an embodiment of the present invention; the user can drive the statistical tool to implement corresponding functions by clicking on the corresponding function modules; the statistical tool can also automatically read the commission data for statistical summary and verify the summary data, and output the verified data summary result.

[0052] Figure 2It is an alternative flowchart of a method for processing commission data of a power distribution project provided by an embodiment of the present invention. Figure 2 The method in

[0053] Step S201: Obtain a dataset of project cost commission tables, process it according to the dataset of project cost commission tables and a preset summary table template, and determine the target summary data. Among them, the dataset of project cost commission tables includes project cost commission tables of several projects.

[0054] Step S202: Verify according to the target summary data and the dataset of project cost commission tables to determine the verification result.

[0055] Step S203: If the verification result is passed, use the target summary data as the data processing result.

[0056] Step S204: If the verification result is not passed, return to execute the step of obtaining the dataset of project cost commission tables until the verification result is passed.

[0057] Steps S201 to S204 shown in the embodiment of the present invention obtain the data to be statistically summarized through a statistical tool, compile a dataset of cost commission tables for all design work of power distribution network projects, then extract the data related to power distribution network projects from the obtained data table set according to the preset summary table template in the tool, fill it into the corresponding positions in the preset template, and calculate the commission data of the project and the respective performance commissions of the design personnel participating in the project according to the preset commission system, and fill it into the corresponding positions in the preset template to obtain the target summary data; after summarizing the obtained dataset of cost commission tables to obtain the target summary data, the statistical tool verifies the target summary data based on the obtained cost commission table data to determine whether there are errors in the summarization and statistics of the data; the statistical tool outputs the target summary data without errors as the data processing result, and the performance assessment personnel or corresponding technical personnel distribute the commissions according to the data processing result output by the statistical tool; if the statistical tool finds errors in the target summary data through verification, the statistical tool re-obtains the cost commission table data for sorting, summarizing statistics, and compiling summary data until the compiled summary data is verified without errors and output as the data processing result.

[0058] Please refer to Figure 3 In some embodiments, step S201 may include, but is not limited to, steps S301 to S302:

[0059] Step S301: Analyze the dataset of project cost commission tables, extract the dataset of designer information, and match the designer information set with the preset participant information set to determine the matching result.

[0060] In step S302, if the matching result is a match, fill the data of the project cost commission table corresponding to the matching designer information into a preset summary table template to determine the target summary data.

[0061] In step S301 of some embodiments, after the statistical tool obtains the project cost commission table data set of the distribution network project, it analyzes the project cost commission table data set, extracts the personal information of the participants therein, such as names; and matches the extracted personal information of the participants with the personal information of the preset design and production personnel in the statistical tool to determine whether the obtained project cost commission table data set is accurate, reduce misreporting and missing reporting, and thus improve the accuracy of subsequent summary data compilation.

[0062] In step S302 of some embodiments, the statistical tool determines the participant information in the project cost commission table data set that is consistent with the preset design and production personnel through matching, extracts the corresponding project cost commission table data, and fills it into the corresponding position in the preset summary table template to obtain the target summary data.

[0063] Please refer to Figure 4 , in some embodiments, step S202 may include but is not limited to steps S401 to S403:

[0064] In step S401, sum the project cost commission table data set to determine the first data; sum the target summary data to obtain the second data; and perform a difference comparison based on the first data and the second data to determine the comparison result.

[0065] In step S402, if the comparison result is of the first type, determine that the verification result of the target summary data is verification passed.

[0066] In step S403, if the comparison result is of the second type, determine that the verification result of the target summary data is verification failed.

[0067] In step S401 of some embodiments, after the statistical tool compiles the project cost commission table data set according to the preset summary table template to obtain the target summary data; it statistically sums the project commission data in the obtained project cost commission table data set to obtain the sum value of the project cost commission, and fills the sum value into the set position for verification; at the same time, the statistical tool statistically sums the project commission data in the target summary data obtained by data compilation to obtain the sum value of the summary data, and also fills the sum value into the set position; the statistical tool performs a difference comparison based on the two sum values to determine whether the compiled summary data is missing or compiled incorrectly.

[0068] In step S402 of some embodiments, if the difference comparison result is of the first type, which is set to zero in this embodiment, the statistical tool determines that the compiled summary data is accurate, marks the corresponding verification result of the summary data as verification passed, and the statistical tool can output it as the data processing result.

[0069] In step S403 of some embodiments, if the difference comparison result is of the second type, which is set to non - zero in this embodiment, the statistical tool determines that there is an error in the currently compiled summary data, and it is necessary to reorganize the data and perform statistical summarization to compile a summary data table; in this embodiment, when the statistical tool determines that the difference comparison result is non - zero, it marks the two summation values filled in the set position in red and generates a corresponding prompt message to remind the performance appraisal personnel to re - perform data statistical summarization.

[0070] Please refer to Figure 5 , in some embodiments, a project cost commission table is generated through steps S501 to S502:

[0071] Step S501, obtain power grid project data, calculate according to the preset commission relationship and power grid project data to determine project commission data; among them, the project commission data includes the total project commission data and the commission data of project designers;

[0072] Step S502, process according to the power grid project data, project commission data and the preset cost commission filling form template to obtain the project cost commission table.

[0073] In step S501 of some embodiments, the statistical tool can obtain the data of the already filled project cost commission table for subsequent statistical summarization and compile a summary data table; it can also receive the original project data of the distribution network, and compile the received original project data according to the preset power grid project cost commission filling form template in the statistical tool to obtain the project cost commission filling form data; among them, the power grid project cost commission filling form template is made in combination with the design company according to the characteristics of the power grid project survey and design fees; the statistical tool calculates according to the received original project data and the preset enterprise commission system to determine the project commission data of each power grid project, including the total commission data corresponding to each project and the commission data of each designer participating in the project.

[0074] In step S502 of some embodiments, the statistical tool analyzes the received original project data, extracts project information, project commission ratio information, and the design output value information allocated to the designers participating in the project, and fills the extracted information and the calculated commission data into the corresponding positions in the preset power grid project cost commission filling form template to obtain the project cost commission table.

[0075] Please refer to Figure 6, in some embodiments, a method for processing commission data of a power distribution project provided by an embodiment of the present invention may further include, but is not limited to, steps S601 to S603:

[0076] Step S601, obtain a path information set, access according to the path information set, and determine a number of project expense commission tables; wherein, the path information set includes computer path information for storing project expense commission tables;

[0077] Step S602, analyze the project expense commission tables, determine the information of the participants, compare the information of the participants with the set of participant information, and determine the comparison result;

[0078] Step S603, summarize a number of project expense commission tables according to the comparison result, and determine a project expense commission table data set.

[0079] In step S601 of some embodiments, a file data path acquisition plug-in is also set in the statistical tool. The statistical tool automatically acquires the project expense commission table data set at the corresponding position through this plug-in and automatically performs subsequent data statistics and summarization processing; the performance appraisal personnel only need to place the project expense commission tables of each project collected in the same folder and input the path of this folder to the statistical tool, and the data statistics and summarization can be automatically completed, simplifying the data processing process and improving the efficiency of data processing.

[0080] In step S602 of some embodiments, the statistical tool accesses the corresponding folder according to the input path information, obtains the project expense commission table data in the folder, analyzes the obtained project expense commission table data, extracts the information of the project participants, and matches the extracted information item by item with all the preset participants in the statistical tool to determine whether the project expense commission table data is accurate, reducing misreporting and missing reporting, and thus improving the accuracy of the subsequent compiled summary data.

[0081] In step S603 of some embodiments, the obtained project expense commission table data is sorted and summarized accordingly according to the matching result to obtain a project expense commission table data set, which is stored in a folder so that the statistical tool can access the folder according to the path information to obtain the sorted project expense commission table data set.

[0082] Please refer to Figure 7 , in some embodiments, step S603 may include, but is not limited to, steps S701 to S702:

[0083] Step S701, if the comparison result is that the information is consistent, summarize the project expense commission tables corresponding to the participant information, and determine a project expense commission table data set;

[0084] Step S702: If the comparison result shows inconsistent information, generate a second prompt message according to the project cost commission table corresponding to the participant information.

[0085] In step S701 of some embodiments, if the participant information in the current project cost commission table matches the information of all participating designers in the statistical tool, the project cost commission tables that match are sorted and summarized uniformly to obtain a project cost commission table data set for subsequent statistical summary and data compilation.

[0086] In step S702 of some embodiments, if the participant information in the current project cost commission table does not match the information of all participating designers in the statistical tool, the statistical tool can determine that the data of the current project cost commission table is incorrect. The statistical tool generates a corresponding prompt message according to the data of the current project cost commission table to remind the performance appraisal personnel and check the current project cost commission table.

[0087] Next, combined with specific application examples, the solution of the embodiment of the present invention will be introduced and described in detail:

[0088] Please refer to Figure 8 , and execute a method for processing distribution project commission data provided by the embodiment of the present invention according to the content shown in Figure 8 . Combine the characteristics of the grid project survey and design fees to compile a template for filling in the grid project cost commission form by the design company. The template includes project information, project commission ratio information, and the design output value information allocated to the designers participating in the project. According to the company's commission system, the total commission data of the project and the commission data of the designers participating in the project can be calculated; then, compile a statistical summary table and tool for the performance commission output value of project participants, including a path input module for the location of the project cost commission form of a specific project in the computer, a Tianxi module for the project cost information of a specific project, and a commission data filling module for project participants. Enter the name information of all design and production personnel of the enterprise through the commission data filling module for project participants; collect all project cost commission tables of the enterprise and organize the collected project cost commission table data. Check whether the name information of the participants in the project cost commission table data is consistent with the name of the design and production personnel in the statistical summary table of the performance commission output value of project participants. Collect and organize the project cost commission tables that are consistent and summarize them into a unified folder on the computer; set up a file data path acquisition plug-in, place the plug-in in the folder where the project cost commission tables are summarized, and run the plug-in through double-click operation to obtain the computer path information of all project cost commission forms of the enterprise; based on the computer path information, input the project cost commission table data in the folder into the statistical tool, such as Figure 9As shown in the figure; the statistical tool matches the name information of the designers in the project cost commission filling form item by item with the name information of the participants in the commission data filling module in the project participant performance commission output value statistical summary form, reads the commission data in the project cost commission filling form with consistent matching, and records it in the project participant performance commission output value statistical summary form to obtain the summary form data; the statistical tool starts the data verification function to verify the obtained summary form data, calculates the sum values of the commission data of each project in the cost commission filling form and the project participant performance commission output value statistical summary form respectively, and fills them in the set positions, and compares the sum values filled in the set positions; if the difference comparison result is zero, the generated summary form data is accurate; if the difference comparison result is non-zero, the generated summary form data is incorrect, the sum value in the set position is given red for prompt, and the project engineering design quantity information form is reorganized, the project cost commission form data is reorganized, and statistical summary and data verification are performed; after all project data in the project participant performance commission output value statistical summary form are verified to be correct, the statistical tool outputs the final statistical result to complete the commission data statistics work.

[0089] Implementing the embodiments of the present invention includes the following beneficial effects: The embodiments of the present invention provide a method, system, electronic device and storage medium for processing commission data of a power distribution project. The solution obtains a dataset of project cost commission forms, processes the obtained dataset of project cost commission forms according to a preset summary form template to obtain target summary data; then verifies the generated target summary data according to the obtained project cost commission form data to determine the verification result; based on the verification result, determines whether to output the data processing result. If the target summary data passes the verification, the target summary data is output as the data processing result; if the target summary data fails the verification, the dataset of project cost commission forms is obtained again for data processing. Based on the preset summary template, the obtained project cost commission form data is summarized and statistically analyzed to generate target summary data, reducing manual data screening and statistical summarization, and improving data processing efficiency; verifying the generated target summary data, outputting the target summary data that passes the verification, and reprocessing the data that fails the verification, improving the accuracy of the data processing result and the data processing efficiency.

[0090] As Figure 10 shown in the figure, the embodiments of the present invention also provide a system for processing commission data of a power distribution project, including:

[0091] The first module is used to obtain the project cost commission form data, and process it according to the project cost commission form data and a preset summary form template to determine the target summary data;

[0092] The second module is used to verify the target summary data and the project cost commission form data to determine the verification result;

[0093] A third module, configured to use the target summary data as the data processing result if the verification result is verification passed;

[0094] If the verification result is verification failed, return to execute the obtaining of the project cost commission table data until the verification result is verification passed.

[0095] It can be seen that the content in the above method embodiments is applicable to the system embodiments of the present application. The functions specifically implemented in the system embodiments of the present application are the same as those in the above method embodiments, and the beneficial effects achieved are also the same as those in the above method embodiments.

[0096] An embodiment of the present application further provides an electronic device, which includes a memory and a processor. The memory stores a computer program, and when the processor executes the computer program, it implements the above-mentioned method for processing distribution project commission data. The electronic device can be any intelligent terminal including a tablet computer, a vehicle-mounted computer, etc.

[0097] It can be understood that the content in the above method embodiments is applicable to the device embodiments of the present application. The functions specifically implemented in the device embodiments of the present application are the same as those in the above method embodiments, and the beneficial effects achieved are also the same as those in the above method embodiments.

[0098] Please refer to Figure 11 , Figure 11 which shows the hardware structure of an electronic device in another embodiment. The electronic device includes:

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

[0100] A memory 1102, which 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), etc. The memory 1102 can store an operating system and other application programs. When implementing the technical solutions provided by the embodiments of this specification through software or firmware, the relevant program codes are stored in the memory 1102, and the processor 1101 is called to execute a method for processing distribution project commission data in an embodiment of the present application;

[0101] An input / output interface 1103 for implementing information input and output;

[0102] A communication interface 1104 for implementing communication interaction between this device and other devices, which can achieve communication through wired means (such as USB, network cable, etc.) or wireless means (such as mobile network, WIFI, Bluetooth, etc.);

[0103] A bus 1105 for transmitting information between various components of the device (such as the processor 1101, the memory 1102, the input / output interface 1103, and the communication interface 1104);

[0104] Among them, the processor 1101, the memory 1102, the input / output interface 1103, and the communication interface 1104 achieve communication connections with each other inside the device through the bus 1105.

[0105] Among them, the memory, as a non-transitory computer-readable storage medium, can be used to store non-transitory software programs and non-transitory computer-executable programs. The memory can include high-speed random access memory, and can also include non-transitory memory, such as at least one magnetic disk storage device, a flash memory device, or other non-transitory solid-state storage devices. In some embodiments, the memory optionally includes a remote memory remotely set relative to the processor, and these remote memories can be connected to the processor through a network. Examples of the above networks include but are not limited to the Internet, an enterprise intranet, a local area network, a mobile communication network, and combinations thereof.

[0106] In addition, an embodiment of the present application also discloses a computer program product or a computer program, and the computer program product or the computer program is stored in a computer-readable storage medium. The processor of the 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 executes the above method. Similarly, the content in the above method embodiments is applicable to this storage medium embodiment, and the functions specifically implemented by this storage medium embodiment are the same as those in the above method embodiments, and the beneficial effects achieved are also the same as those achieved by the above method embodiments.

[0107] An embodiment of the present application also provides a computer-readable storage medium, and the computer-readable storage medium stores a computer program, and when the computer program is executed by a processor, it implements the above-mentioned method for processing distribution project commission data.

[0108] It can be understood that the content in the above method embodiments is applicable to this storage medium embodiment, and the functions specifically implemented by this storage medium embodiment are the same as those in the above method embodiments, and the beneficial effects achieved are also the same as those achieved by the above method embodiments.

[0109] It will be understood that all or some of the steps and systems disclosed in the above methods may be implemented as software, firmware, hardware and appropriate combinations thereof. Some or all of the physical components may be implemented as software executed by a processor, such as a central processing unit, a digital signal processor or a microprocessor, or implemented as hardware, or implemented as an integrated circuit, such as an application specific integrated circuit. Such software may be distributed on a computer-readable medium, which may include a computer storage medium (or non-transitory medium) and a communication medium (or transitory medium). As is well known to those of ordinary skill in the art, the term computer storage medium includes volatile and non-volatile, removable and non-removable media implemented in any method or technology for storing information such as computer-readable instructions, data structures, program modules or other data. Computer storage media includes but is not limited to RAM, ROM, EEPROM, flash memory or other memory technologies, CD-ROM, digital versatile disk (DVD) or other optical disk storage, magnetic cassettes, tapes, magnetic disk storage or other magnetic storage devices, or any other medium that can be used to store the desired information and can be accessed by a computer. In addition, as is well known to those of ordinary skill in the art, communication media typically contains computer-readable instructions, data structures, program modules or other data in a modulated data signal such as a carrier wave or other transmission mechanism, and may include any information delivery medium.

[0110] The above is a specific description of the preferred embodiments of the present invention, but the present invention is not limited to the described embodiments. Those skilled in the art can make various equivalent deformations or substitutions without departing from the spirit of the present invention, and these equivalent deformations or substitutions are all included within the scope defined by the claims of this application.

Claims

1. A method for processing commission data of a power distribution project, characterized in that: The method comprises: Acquire a project cost commission table data set, and process the project cost commission table data set and a preset summary table template to determine target summary data; wherein the project cost commission table data set includes project cost commission tables of several projects; Verify the target summary data and the project cost commission table data set to determine the verification result; If the verification result is that the verification passes, the target summary data is used as the data processing result; If the verification result is that the verification fails, return to execute the acquisition of the project cost commission table data set until the verification result is that the verification passes.

2. The method according to claim 1, characterized in that The process of processing the project cost commission table data set and the preset summary table template to determine the target summary data specifically includes: Analyze the project cost commission table data set, extract the designer information data set, and match the designer information set with the preset participant information set to determine the matching result; If the matching result is a consistent match, the project cost commission table data corresponding to the designer information that matches the consistent match is filled into the preset summary table template to determine the target summary data.

3. The method according to claim 1, characterized in that The step of verifying the target summary data with the project cost commission table data set to determine the verification result specifically includes: Summing the project cost commission table data set to determine first data; summing the target summary data to obtain second data; and performing a difference comparison based on the first data and the second data to determine a comparison result; If the comparison result is of the first type, determining that the verification result of the target summary data is verification passed; If the comparison result is of the second type, it is determined that the verification result of the target summary data is verification failure.

4. The method according to claim 3, characterized in that The method further comprises: If the comparison result is of the second type, the first data and the second data are marked according to a preset color, and a first prompt message is generated.

5. The method according to claim 1, characterized in that The project fee commission table is determined according to the following method: Obtaining power grid project data, and performing calculations based on a preset commission relationship and the power grid project data to determine project commission data; wherein the project commission data includes total project commission data and project designer commission data; The project fee commission table is obtained by processing the power grid project data, the project commission data and a preset fee commission form template.

6. The method according to claim 1, characterized in that The method further comprises: Acquire a path information set, perform access according to the path information set, and determine a plurality of the project cost commission tables; wherein the path information set includes computer path information storing the project cost commission tables; Analyze the project fee commission table to determine the participant information, compare the participant information with the participant information set, and determine the comparison result; A plurality of the project cost commission tables are summarized according to the comparison result to determine the project cost commission table data set.

7. The method according to claim 6, characterized in that The step of aggregating the plurality of project fee commission tables according to the comparison result to determine the project fee commission table data set specifically includes: If the comparison result is that the information is consistent, the project fee commission table corresponding to the participant information is summarized to determine the project fee commission table data set; If the comparison result is that the information is inconsistent, a second prompt message is generated according to the project cost commission table corresponding to the participant information.

8. A power distribution project commission data processing system, characterized in that: include: The first module is used to obtain project cost commission table data, process the project cost commission table data and a preset summary table template to determine target summary data; The second module is used to verify the target summary data and the project cost commission table data to determine the verification result; The third module is used for taking the target summary data as the data processing result if the verification result is verification passed; If the verification result is that the verification fails, return to execute the acquisition of project cost commission table data until the verification result is that the verification passes.

9. An electronic device, characterized in that: include: at least one processor; at least one memory for storing at least one program; When the at least one program is executed by the at least one processor, the at least one processor implements the method according to any one of claims 1 to 7.

10. A computer-readable storage medium storing a program executable by a processor, characterized in that: The processor-executable program is used to perform the method according to any one of claims 1 to 7 when executed by the processor.

Images