Power distribution network infrastructure project posting progress and field construction progress coupling degree evaluation method and system

Abstract

The invention relates to a power distribution network infrastructure project entry progress and field construction progress coupling degree evaluation method and system, and the method comprises the following steps: S100: obtaining monthly entry progress data of a power distribution network infrastructure project from an ERP system, and obtaining monthly actual construction progress data of the power distribution network infrastructure project from a project management platform; s200, cleaning the acquired data, extracting feature data, calculating the entry progress and the field construction progress of the power distribution network infrastructure project by adopting a coupling degree calculation method, further calculating the deviation between the entry progress and the field construction progress of the power distribution network infrastructure project, and calculating the entry progress and the field construction progress of the power distribution network infrastructure project; calculating the coupling degree of the entry progress and the field construction progress of the power distribution network infrastructure project; and S300, evaluating the coupling degree of the entry progress of the power distribution network infrastructure project and the on-site construction progress, and performing early warning on the project with low coupling degree. According to the method and the system, the coupling degree of the power distribution network infrastructure project entry progress and the field construction progress can be quickly and accurately predicted, the universality is high, and the application range is wide.

Description

Technical Field

[0001] The present invention relates to a method and system for evaluating the coupling degree between the accounting progress and the on-site construction progress of a power distribution network infrastructure project. Background Art

[0002] In 2022, State Grid Corporation of China clarified that the company's newly started projects in 2023 will be counted using the financial expenditure method, and the continued projects will continue to be counted using the visual progress method. After the change, investment completion and settlement are "serial relationships" and directly related. The financial expenditure method is used for investment completion statistics, and the statistical basis is cost accounting. The amount of project investment completed is obtained by adding up the cost accounting amounts, which is closely related to the settlement of project progress payments, and the settlement of project progress payments needs to be coupled with the visual progress of the project site. At present, there is a lack of an evaluation method for the coupling degree between the accounting progress and the on-site construction progress of distribution network infrastructure projects. Therefore, it is necessary to design an evaluation method for the coupling degree between the accounting progress and the on-site construction progress of distribution network infrastructure projects to predict the coupling degree between the accounting progress and the on-site construction progress. Summary of the invention

[0003] The purpose of the present invention is to provide a method and system for evaluating the coupling degree between the accounting progress and the on-site construction progress of a distribution network infrastructure project. The method and system are conducive to quickly and accurately predicting the coupling degree between the accounting progress and the on-site construction progress of a distribution network infrastructure project, and have strong universality and a wide range of applications.

[0004] In order to achieve the above object, the technical solution adopted by the present invention is: a method for evaluating the coupling degree between the accounting progress and the on-site construction progress of a distribution network infrastructure project, comprising the following steps:

[0005] S100: Obtain monthly accounting progress data of distribution network infrastructure projects from the ERP system, and obtain monthly actual construction progress data of distribution network infrastructure projects from the project management platform;

[0006] S200: After cleaning the acquired data, feature data is extracted, and then a coupling degree calculation method is used to calculate the progress of the distribution network infrastructure project and the progress of the on-site construction, and then the deviation between the progress of the distribution network infrastructure project and the progress of the on-site construction is calculated, thereby calculating the coupling degree between the progress of the distribution network infrastructure project and the progress of the on-site construction;

[0007] S300: Evaluate the coupling degree between the payment progress and on-site construction progress of distribution network infrastructure projects, and issue early warnings for projects with low coupling.

[0008] Furthermore, in step S100, the monthly progress data of the distribution network infrastructure project mainly includes the monthly amount of money received and time node data information, and the monthly actual construction progress data of the distribution network infrastructure project mainly includes the monthly project completion ratio and completion time node data information.

[0009] Furthermore, step S200 specifically includes the following steps:

[0010] S210: Clean the monthly account progress data and monthly actual construction progress data of the distribution network infrastructure projects, including data deduplication, filling missing values, processing abnormal values ​​and converting data formats, so as to improve the accuracy and reliability of the data;

[0011] S220: extracting characteristic data from the cleaned data, including the amount of money entered, the time of entry, the construction progress, and the time of reporting the construction progress;

[0012] S230: Calculate the progress of distribution network infrastructure project account entry, distribution network infrastructure project account entry progress = ∑ monthly account entry progress;

[0013] S240: Calculate the on-site construction progress of the distribution network infrastructure project, where the on-site construction progress of the distribution network infrastructure project = ∑ actual construction progress per month;

[0014] S250: Calculate the accumulated account progress and on-site construction progress up to the current month through steps S230-S240, and then calculate the monthly deviation, where the monthly deviation = the accumulated on-site construction progress up to the current month - the accumulated account progress up to the current month;

[0015] S260: Calculate coupling deviation, coupling deviation = ∑ monthly deviation 2 ;

[0016] Calculate the coupling degree,

[0017] Furthermore, in step S300, an early warning mechanism is established. When the coupling degree of the project is lower than a predetermined threshold, an early warning is automatically triggered, and the project that triggered the early warning is simultaneously sent to the terminal device of the front-line manager to ensure that all relevant parties understand the progress of the project and continuously monitor the accounting progress and on-site construction progress of the early warning project.

[0018] The present invention also provides a system for evaluating the coupling degree between the accounting progress and the on-site construction progress of a distribution network infrastructure project for implementing the above method, comprising:

[0019] The data acquisition module is used to obtain the monthly accounting progress data of the distribution network infrastructure project from the ERP system and the monthly actual construction progress data of the distribution network infrastructure project from the project management platform;

[0020] The data processing module is used to clean the acquired data and then extract feature data;

[0021] The coupling degree calculation module is used to calculate the progress of the distribution network infrastructure project and the progress of the on-site construction, and then calculate the deviation between the progress of the distribution network infrastructure project and the progress of the on-site construction, so as to calculate the coupling degree between the progress of the distribution network infrastructure project and the progress of the on-site construction;

[0022] The evaluation output module is used to evaluate the coupling degree between the accounting progress and on-site construction progress of distribution network infrastructure projects, and to issue early warnings for projects with low coupling.

[0023] Compared with the prior art, the present invention has the following beneficial effects: the present invention provides a method and system for evaluating the coupling degree between the accounting progress and on-site construction progress of distribution network infrastructure projects. The method can evaluate the accounting progress and on-site construction progress of distribution network infrastructure projects, and then calculate the deviation between the accounting progress and on-site construction progress of distribution network infrastructure projects, so as to conveniently and accurately measure the coupling degree between the accounting progress and engineering progress of distribution network infrastructure projects, and provide support for improving the investment completion degree of distribution network infrastructure projects. BRIEF DESCRIPTION OF THE DRAWINGS

[0024] Figure 1 is a flow chart of a method implementation of an embodiment of the present invention;

[0025] Figure 2 is a flowchart of the implementation of step S200 in an embodiment of the present invention;

[0026] Figure 3 It is a system block diagram of an embodiment of the present invention. DETAILED DESCRIPTION

[0027] The present invention will be further described below in conjunction with the accompanying drawings and embodiments.

[0028] It should be noted that the following detailed descriptions are exemplary and are intended to provide further explanation of the present application. Unless otherwise specified, all technical and scientific terms used herein have the same meanings as those commonly understood by those skilled in the art to which the present application belongs.

[0029] It should be noted that the terms used herein are only for describing specific embodiments and are not intended to limit the exemplary embodiments according to the present application. As used herein, unless the context clearly indicates otherwise, the singular form is also intended to include the plural form. In addition, it should be understood that when the terms "comprise" and / or "include" are used in this specification, it indicates the presence of features, steps, operations, devices, components and / or combinations thereof.

[0030] like Figure 1 As shown, this embodiment provides a method for evaluating the coupling degree between the accounting progress and the on-site construction progress of a distribution network infrastructure project, including the following steps:

[0031] S100: Obtain data such as the monthly progress of distribution network infrastructure projects from the ERP system, and obtain data such as the monthly actual construction progress of distribution network infrastructure projects from the project management platform.

[0032] The monthly progress data of distribution network infrastructure projects mainly refers to data information such as monthly revenue amounts and time nodes.

[0033] The actual monthly construction progress data of distribution network infrastructure projects mainly refers to data information such as the monthly project completion ratio and completion time nodes.

[0034] S200: After cleaning the acquired data, feature data is extracted, and then a coupling degree calculation method is used to calculate the progress of the distribution network infrastructure project and the progress of the on-site construction, and then the deviation between the progress of the distribution network infrastructure project and the progress of the on-site construction is calculated, thereby calculating the coupling degree between the progress of the distribution network infrastructure project and the progress of the on-site construction.

[0035] like Figure 2 As shown, step S200 specifically includes the following steps:

[0036] S210: Data cleaning: Clean the monthly progress data of the distribution network infrastructure projects and the monthly actual construction progress data, including data deduplication, filling in missing values, processing outliers and converting data formats, so as to improve the accuracy and reliability of the data.

[0037] S220: Feature data extraction: Extract feature data from the cleaned data, including the amount of money entered, time of entry, construction progress, and time of reporting the construction progress, but not limited to these.

[0038] S230: Calculate the progress of distribution network infrastructure project payment, distribution network infrastructure project payment progress = ∑ monthly payment progress.

[0039] S240: Calculate the on-site construction progress of the distribution network infrastructure project, where the on-site construction progress of the distribution network infrastructure project = ∑ actual monthly construction progress.

[0040] S250: Calculate the accumulated progress of the current month and the progress of the on-site construction through steps S230-S240, and then calculate the monthly deviation, where the monthly deviation = the accumulated progress of the on-site construction through the current month - the accumulated progress of the current month.

[0041] S260: Calculate coupling deviation, coupling deviation = ∑ monthly deviation 2 ;

[0042] Calculate the coupling degree,

[0043] S300: Evaluate the coupling degree between the payment progress and on-site construction progress of distribution network infrastructure projects, and issue early warnings for projects with low coupling.

[0044] Specifically, an early warning mechanism is established. When the coupling degree of a project is lower than a predetermined threshold, an early warning is automatically triggered, and the project that triggered the early warning is sent to the terminal devices of front-line managers at the same time to ensure that all relevant parties are aware of the progress of the project and continuously monitor the accounting progress and on-site construction progress of the early warning project.

[0045] like Figure 3 As shown, this embodiment also provides a system for evaluating the coupling degree between the accounting progress and the on-site construction progress of a distribution network infrastructure project for implementing the above method, including: a data acquisition module, a data processing module, a coupling degree calculation module and an evaluation output module.

[0046] The data acquisition module is used to obtain the monthly accounting progress data of the distribution network infrastructure project from the ERP system, and to obtain the monthly actual construction progress data of the distribution network infrastructure project from the project management platform.

[0047] The data processing module is used to clean the acquired data and then extract feature data.

[0048] The coupling degree calculation module is used to calculate the distribution network infrastructure project accounting progress and on-site construction progress, and then calculate the distribution network infrastructure project accounting progress and on-site construction progress deviation, thereby calculating the distribution network infrastructure project accounting progress and on-site construction progress coupling degree.

[0049] The evaluation output module is used to evaluate the coupling degree between the progress of distribution network infrastructure projects and the progress of on-site construction, and to issue early warnings for projects with low coupling degrees.

[0050] Those skilled in the art will appreciate that the embodiments of the present application may be provided as methods, systems, or computer program products. Therefore, the present application may adopt the form of a complete hardware embodiment, a complete software embodiment, or an embodiment in combination with software and hardware. Moreover, the present application may adopt the form of a computer program product implemented in one or more computer-usable storage media (including but not limited to disk storage, CD-ROM, optical storage, etc.) that include computer-usable program code.

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

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

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

[0054] The above is only a preferred embodiment of the present invention, and does not limit the present invention in other forms. Any technician familiar with the profession may use the above disclosed technical content to change or modify it into an equivalent embodiment with equivalent changes. However, any simple modification, equivalent change and modification made to the above embodiment according to the technical essence of the present invention without departing from the technical solution of the present invention still belongs to the protection scope of the technical solution of the present invention.

Claims

1. A method for evaluating the coupling degree between the accounting progress and on-site construction progress of a distribution network infrastructure project, characterized in that: The following steps are involved: S100: Obtain monthly accounting progress data of distribution network infrastructure projects from the ERP system, and obtain monthly actual construction progress data of distribution network infrastructure projects from the project management platform; S200: After cleaning the acquired data, feature data is extracted, and then a coupling degree calculation method is used to calculate the progress of the distribution network infrastructure project and the progress of the on-site construction, and then the deviation between the progress of the distribution network infrastructure project and the progress of the on-site construction is calculated, thereby calculating the coupling degree between the progress of the distribution network infrastructure project and the progress of the on-site construction; S300: Evaluate the coupling degree between the payment progress and on-site construction progress of distribution network infrastructure projects, and issue early warnings for projects with low coupling.

2. The method for evaluating the coupling degree between the accounting progress and the on-site construction progress of a distribution network infrastructure project according to claim 1 is characterized in that: In step S100, the monthly progress data of the distribution network infrastructure project mainly includes the monthly amount of money received and time node data information, and the monthly actual construction progress data of the distribution network infrastructure project mainly includes the monthly project completion ratio and completion time node data information.

3. The method for evaluating the coupling degree between the accounting progress and the on-site construction progress of a distribution network infrastructure project according to claim 1 is characterized in that: Step S200 specifically includes the following steps: S210: Clean the monthly account progress data and monthly actual construction progress data of the distribution network infrastructure projects, including data deduplication, filling missing values, processing abnormal values ​​and converting data formats, so as to improve the accuracy and reliability of the data; S220: extracting characteristic data from the cleaned data, including the amount of money entered, the time of entry, the construction progress, and the time of reporting the construction progress; S230: Calculate the progress of distribution network infrastructure project account entry, distribution network infrastructure project account entry progress = ∑ monthly account entry progress; S240: Calculate the on-site construction progress of the distribution network infrastructure project, where the on-site construction progress of the distribution network infrastructure project = ∑ actual construction progress per month; S250: Calculate the accumulated account progress and on-site construction progress up to the current month through steps S230-S240, and then calculate the monthly deviation, where the monthly deviation = the accumulated on-site construction progress up to the current month - the accumulated account progress up to the current month; S260: Calculate coupling deviation, coupling deviation = ∑ monthly deviation 2 ; Calculate the coupling degree, 4. The method for evaluating the coupling degree between the accounting progress and the on-site construction progress of a distribution network infrastructure project according to claim 1 is characterized in that: In step S300, an early warning mechanism is established. When the coupling degree of the project is lower than the predetermined threshold, an early warning is automatically triggered, and the project that triggered the early warning is sent to the terminal device of the front-line manager at the same time to ensure that all relevant parties understand the progress of the project and continuously monitor the accounting progress and on-site construction progress of the early warning project.

5. A system for evaluating the coupling degree between the accounting progress and the on-site construction progress of a distribution network infrastructure project for implementing the method according to any one of claims 1 to 4, characterized in that: include: The data acquisition module is used to obtain the monthly accounting progress data of the distribution network infrastructure project from the ERP system and the monthly actual construction progress data of the distribution network infrastructure project from the project management platform; The data processing module is used to clean the acquired data and then extract feature data; The coupling degree calculation module is used to calculate the progress of the distribution network infrastructure project and the progress of the on-site construction, and then calculate the deviation between the progress of the distribution network infrastructure project and the progress of the on-site construction, so as to calculate the coupling degree between the progress of the distribution network infrastructure project and the progress of the on-site construction; The evaluation output module is used to evaluate the coupling degree between the accounting progress and on-site construction progress of distribution network infrastructure projects, and to issue early warnings for projects with low coupling.

Images