Electric power operation and maintenance monitoring method and device

Through the combination of RPA robot and VBA macro language, all-round, full-process and fully automatic analysis of power operation and maintenance quality is achieved, and the problems of low automation level and untimely monitoring of operation and maintenance quality in the existing technology are solved, and the supervision efficiency is improved and accuracy.

CN119006219AActive Publication Date: 2024-11-22FOSHAN POWER SUPPLY BUREAU GUANGDONG POWER GRID

Patent Information

Application Number
CN202411459331.1
Authority / Receiving Office
CN · China
Patent Type
Applications(China)
Current Assignee / Owner
Filing Date
2024-10-18
Publication Date
2024-11-22
Estimated Expiration
2044-10-18

AI Technical Summary

Technical Problem

In the prior art, the degree of automation of power operation and maintenance quality monitoring is low and untimely, resulting in poor operation and maintenance quality monitoring effect, and manual operation is prone to errors, affecting efficiency and accuracy.

Method used

Use RPA robots to obtain operation and maintenance work data, analyze and output analysis results based on preset supervision rules, and combine VBA macro language to achieve all-round, full-process, and fully automatic operation and maintenance quality supervision, reduce labor costs and improve supervision efficiency and accuracy sex.

Benefits of technology

It realizes intelligent management of operation and maintenance quality, reduces errors in manual operations, improves the efficiency and accuracy of the supervision process, and ensures timely and accurate feedback on operation and maintenance quality.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure CN119006219A_ABST
    Figure CN119006219A_ABST
Patent Text Reader

Abstract

The invention relates to the technical field of electric power, and provides an electric power operation and maintenance monitoring method and device, and the method comprises the steps: obtaining operation and maintenance work data related to the operation and maintenance quality in electric power work through an RPA robot; the operation and maintenance work data are analyzed according to preset supervision rules, an analysis result is obtained, and the supervision rules comprise a verification rule and a calculation rule; and outputting the analysis result through the RPA robot. Omnibearing, full-process and full-automatic accurate analysis of the operation and maintenance quality can be realized based on RPA, intelligent management of the operation and maintenance quality is realized, the labor cost is reduced through office automation, the burden of power grid basic level workers is reduced, and the efficiency and accuracy of the monitoring process are improved; meanwhile, errors such as data export errors and analysis and judgment errors in manual operation can be avoided, and the operation and maintenance quality monitoring accuracy is improved.
Need to check novelty before this filing date? Find Prior Art

Description

Technical Field

[0001] The present disclosure relates to the field of electric power technology, and in particular to an electric power operation and maintenance monitoring method and device. Background Art

[0002] In the work of the power supply bureau, in order to effectively monitor the operation and maintenance quality of grassroots work and promote the improvement of grassroots operation and maintenance quality, it is necessary to analyze the indicator parameters related to operation and maintenance quality, such as the number of work carried out, the qualified rate of work, the standard rate of work, the rationality of personnel allocation, etc., to determine whether they meet the requirements, and further present the results to all employees on the operation and maintenance quality monitoring system. At present, the above process mainly relies on manual data export, analysis, judgment and result presentation, which has problems such as low efficiency, easy errors and lack of timeliness. Some employees use VBA macro code in Excel for data analysis. Although it simplifies the manual data analysis part, it is still necessary to manually export data from the system and manually upload the analysis results to the system platform. The degree of automation is still low, and it is impossible to timely monitor the operation and maintenance quality of the power grid work. In addition, the above method requires a lot of time and energy of employees, and employees may make mistakes during the analysis process, such as missing rules, incorrectly executing screening conditions, missing problem work orders, etc., which affects the effect of operation and maintenance quality monitoring. In addition, when relevant employees leave their posts, there may be situations where work orders cannot be effectively and timely supervised. Summary of the invention

[0003] The purpose of the embodiments of the present disclosure is to provide a method and device for monitoring power operation and maintenance, so as to at least solve the technical problems existing in the prior art of low automation level of power operation and maintenance quality monitoring, untimely operation and maintenance quality monitoring, and poor operation and maintenance quality monitoring effect.

[0004] In order to solve the above technical problems, the embodiments of the present disclosure adopt the following technical solutions:

[0005] In a first aspect, an embodiment of the present disclosure provides a method for monitoring power operation and maintenance, including:

[0006] Use RPA robots to obtain operation and maintenance data related to the operation and maintenance quality of power work;

[0007] Analyze the operation and maintenance work data according to preset supervision rules to obtain analysis results, wherein the supervision rules include verification rules and calculation rules;

[0008] The analysis result is outputted by the RPA robot.

[0009] In some embodiments, the operation and maintenance work data related to the operation and maintenance quality is obtained through the RPA robot, including:

[0010] The RPA robot exports corresponding operation and maintenance work data from the web page related to the operation and maintenance quality according to preset screening conditions and / or preset data export methods.

[0011] In some embodiments, the RPA robot exports corresponding operation and maintenance work data from the webpage related to the operation and maintenance quality according to a preset screening condition and / or a preset data export method, including:

[0012] The RPA robot executes a preset JS function to obtain the webpage frame name to which the function button to be clicked belongs according to the element name in the webpage, wherein the function button is determined according to the screening condition and / or the data export method;

[0013] The RPA robot locates the function button under the web page frame according to the web page frame name to obtain the target function button.

[0014] In some embodiments, the RPA robot exports corresponding operation and maintenance work data from the webpage related to the operation and maintenance quality according to a preset screening condition and / or a preset data export method, including:

[0015] The RPA robot executes a preset JS function, traverses relevant elements in the web page according to the preset title text, and locates the web page frame where the title text is located;

[0016] The RPA robot locates the function button under the web page frame according to the web page frame name of the web page frame to obtain the target function button.

[0017] In some embodiments, the validation rules include at least one of time logic validation, text validation, duration validation, terminology validation, basic logic validation, and work standard validation rules.

[0018] The time logic verification rule is used to verify the execution of work ticket filling that does not conform to the time logic;

[0019] The text verification rules are used to verify the execution of work ticket filling that does not conform to text specifications;

[0020] The duration verification rule is used to verify the execution of work tickets that do not meet the duration requirements;

[0021] The terminology verification rules are used to verify the execution of work ticket filling that does not meet the terminology requirements;

[0022] The basic logic verification rules are used to verify the execution of work ticket filling that does not conform to the basic logic;

[0023] The work standard verification rules are used to verify the execution of work tickets that do not meet the work standards of the power company.

[0024] In some embodiments, the computational rules include at least one of data calculation and quantity statistics rules.

[0025] The data calculation rule is used to analyze whether the calculated value has an abnormality;

[0026] The quantity counting rule is used to count the number of work tickets that meet the preset standard and determine whether there is an abnormality in the number of work tickets.

[0027] In some embodiments, the operation and maintenance work data is analyzed according to preset supervision rules to obtain analysis results, including:

[0028] According to each of the verification rules or the calculation rules, a VBA function is written to save the standard verification data corresponding to the verification rule or the calculation rule in an Excel template;

[0029] The RPA robot imports the operation and maintenance work data into the Excel template;

[0030] The RPA robot executes the VBA macro in sequence to perform rule verification on the operation and maintenance work data to obtain the analysis result;

[0031] The RPA robot stores the analysis result in a preset area of ​​a preset worksheet.

[0032] In some embodiments, outputting the analysis result by the RPA robot includes: visually displaying the analysis result;

[0033] The visual display includes:

[0034] Create a new presentation worksheet in Excel by writing VBA macro language;

[0035] The RPA robot executes the VBA macro language of Excel and displays the analysis results in Excel.

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

[0037] The analysis results are uploaded to the data sharing system platform and displayed through the shared system page of the data sharing system platform, wherein the shared system page includes an operation and maintenance quality management page and / or a notification announcement page.

[0038] In a second aspect, an embodiment of the present disclosure provides a power operation and maintenance monitoring device, including:

[0039] An acquisition module, configured to acquire operation and maintenance work data related to the operation and maintenance quality in power work through an RPA robot;

[0040] An analysis module is configured to analyze the operation and maintenance work data according to preset supervision rules to obtain analysis results, wherein the supervision rules include verification rules and calculation rules;

[0041] An output module is configured to output the analysis result through the RPA robot.

[0042] In a third aspect, an embodiment of the present disclosure provides an electronic device, comprising at least a memory and a processor, wherein the memory stores a computer program, and the processor implements the above-mentioned power operation and maintenance monitoring method when executing the computer program on the memory.

[0043] In a fourth aspect, an embodiment of the present disclosure provides a computer-readable storage medium having a computer program stored thereon, and when the computer program is executed by a processor, the above-mentioned power operation and maintenance monitoring method is implemented.

[0044] An electric power operation and maintenance monitoring method and device provided by the embodiments of the present disclosure obtains operation and maintenance work data related to the operation and maintenance quality in electric power work through an RPA robot; analyzes the operation and maintenance work data according to preset supervision rules to obtain analysis results; and outputs the analysis results through the RPA robot. Based on RPA, an all-round, full-process, and fully automatic accurate analysis of the operation and maintenance quality can be achieved, and intelligent management of the operation and maintenance quality can be achieved. Through office automation, labor costs can be reduced, the burden on grassroots staff of the power grid can be reduced, and the efficiency and accuracy of the monitoring process can be improved. At the same time, errors in manual operations, such as data export errors and analysis and judgment errors, can be avoided, thereby improving the accuracy of operation and maintenance quality monitoring. BRIEF DESCRIPTION OF THE DRAWINGS

[0045] In order to more clearly illustrate the embodiments of the present disclosure or the technical solutions in the prior art, the drawings required for use in the embodiments or the description of the prior art will be briefly introduced below. Obviously, the drawings described below are only some embodiments recorded in the present disclosure. For ordinary technicians in this field, other drawings can be obtained based on these drawings without paying creative labor.

[0046] Figure 1 A flowchart of a power operation and maintenance monitoring method according to an embodiment of the present disclosure;

[0047] Figure 2 Schematic diagram of the structure of the power operation and maintenance monitoring device according to an embodiment of the present disclosure. DETAILED DESCRIPTION

[0048] Various aspects and features of the present disclosure are described herein with reference to the drawings.

[0049] It should be understood that various modifications may be made to the embodiments of the present application. Therefore, the above description should not be considered as limiting, but only as an example of an embodiment. Other modifications within the scope and spirit of the present disclosure will occur to those skilled in the art.

[0050] The accompanying drawings, which are incorporated in and constitute a part of the specification, illustrate embodiments of the present disclosure and, together with the general description of the present disclosure given above and the detailed description of the embodiments given below, serve to explain the principles of the present disclosure.

[0051] These and other characteristics of the present disclosure will become apparent from the following description of a preferred form of embodiment given as a non-limiting example, with reference to the attached drawings.

[0052] It should also be understood that, although the present disclosure has been described with reference to some specific examples, those skilled in the art will be able to realize many other equivalent forms of the present disclosure that have the features described in the claims and are therefore within the scope of protection defined thereby.

[0053] The above and other aspects, features and advantages of the present disclosure will become more apparent from the following detailed description when taken in conjunction with the accompanying drawings.

[0054] Specific embodiments of the present disclosure are described hereinafter with reference to the accompanying drawings; however, it should be understood that the embodiments claimed are merely examples of the present disclosure, which may be implemented in a variety of ways. Well-known and / or repeated functions and structures are not described in detail to avoid obscuring the present disclosure with unnecessary or redundant details. Therefore, the specific structural and functional details claimed herein are not intended to be limiting, but merely serve as a basis and representative basis for the claims to teach those skilled in the art to use the present disclosure in a variety of ways with substantially any suitable detailed structure.

[0055] This specification may use the phrases "in one embodiment," "in another embodiment," "in a further embodiment," or "in other embodiments," all of which may refer to one or more of the same or different embodiments according to the present disclosure.

[0056] At present, power supply enterprises have formulated management norms for employees, and use work tickets, operation tickets, work plan sheets, etc. to carry out certain quantitative control over the arrangement of work plans and work processes. However, in order to achieve timely feedback and notification warnings on the standardization of on-site work, personnel are still required to continuously (e.g., monthly) count the irregularities of work tickets, operation tickets, and work plan sheets of the employees at the shifts and stations, summarize them into analysis tables, or notify the person in charge of irregular work tickets, operation tickets, and work plan sheets.

[0057] In the existing technology, employees are mainly required to manually download, analyze and notify relevant personnel of work tickets, operation tickets and work plans. This method consumes a lot of employees' time and energy every day, and employees may make mistakes during the analysis process, such as missing rules, incorrectly executing screening conditions, and missing problem work orders. In addition, some existing RPA solutions for other scenarios have shortcomings such as inaccurate web page click recognition and superficial data analysis (such as the inability to visualize analysis results).

[0058] Embodiment 1

[0059] Figure 1 A flow chart of the power operation and maintenance monitoring method according to an embodiment of the present disclosure is shown. Figure 1 As shown, an electric power operation and maintenance monitoring method provided by an embodiment of the present disclosure includes:

[0060] S101: Obtain operation and maintenance work data related to the operation and maintenance quality of power work through RPA robots.

[0061] Robotic Process Automation (RPA) is a technology that uses software robots to automatically perform repetitive tasks. It can simulate human operations on computers, such as data input, data processing, file transfer, etc., and automate routine repetitive tasks such as manual operations, data input and data processing, greatly improving work efficiency and accuracy.

[0062] In this step, an RPA robot for robotic process automation can be pre-built in the server, and the operation and maintenance work data related to the operation and maintenance quality in the power work can be automatically obtained through the RPA robot. Specifically, the RPA robot automatically logs in to the RPA system and enters the relevant web page (also known as page). For example, the RPA robot can automatically enter the account and password of the operation and maintenance staff, pass the verification and log in to the RPA system page, select the function modules in the system page in turn to jump to the corresponding page, and automatically obtain the operation and maintenance work data related to the operation and maintenance quality from the corresponding page.

[0063] Among them, the operation and maintenance work data refers to the work data of the operation and maintenance staff when they operate and maintain the power grid, including work tickets, operation tickets, work plans, etc. The operation and maintenance work data can be manually entered into the RPA system by the operation and maintenance staff during work, or automatically entered into the RPA system through the RPA robot. When power operation and maintenance monitoring is required, the monitoring personnel can automatically obtain the operation and maintenance work data through the RPA robot as described above.

[0064] In some embodiments, in step S101, obtaining operation and maintenance work data related to operation and maintenance quality in power work through an RPA robot includes:

[0065] S1011: The RPA robot exports corresponding operation and maintenance work data from the web page related to the operation and maintenance quality according to preset screening conditions and / or a preset data export method.

[0066] Among them, the preset screening conditions include working date, working location, working group, work completion status, etc. The preset data export method may include a specific data export method, such as exporting to a network disk, a USB flash drive, or an email, etc.; the data export method may also include an export format, for example, exporting to an Excel table, exporting in the format of a picture, video, file, etc.; the data export method may also include an export method, such as exporting all or part of the operation and maintenance work data. The specific data export method is determined according to the actual situation and is not specifically limited in this disclosure.

[0067] S102: Analyze the operation and maintenance work data according to preset supervision rules to obtain analysis results, wherein the supervision rules include verification rules and calculation rules.

[0068] Verification rules refer to rule indicators that can directly judge and obtain conclusions on operation and maintenance work data. The verification rules include at least one of time logic verification, text verification, duration verification, terminology verification, basic logic verification, and work standard verification rules.

[0069] Among them, the time logic verification rules are used to verify the execution of work ticket filling that does not conform to the time logic. For example, "incorrect start time" means that the start time is less than the planned start time, or the start time is greater than or equal to the planned end time, or the start time is greater than the actual start time.

[0070] The text verification rules are used to verify the execution of work ticket filling that does not comply with text standards. For example, "non-standard terminology" means that "signboard" is mistakenly written as "signboard", or "station transformer" is mistakenly written as "station transformer", or "grounding transformer" is mistakenly written as "grounding transformer", etc.

[0071] The duration verification rule is used to verify the execution of work tickets that do not meet the duration requirements. For example, "abnormal equipment operation time" means that the time for a single operation is less than 15 seconds.

[0072] The terminology verification rules are used to verify the execution of work ticket filling that does not meet the terminology requirements. For example, "incorrect switch operation" means that in a single operation that does not contain a "knife switch", operations such as "pull open" and "switch" are also included.

[0073] The basic logic verification rules are used to verify the execution of work ticket filling that does not conform to the basic logic. For example, "zero number of workers" means that the estimated number of workers column is filled in with "0".

[0074] The work standard verification rules are used to verify the filling and execution of work tickets that do not meet the work standards of the power company. For example, "the same person holding a ticket at the same time" means that the same person holds two or more work tickets at any one time; "incomplete construction work documents" refers to work tickets from external units that have been archived and the "Is there a construction plan?" is marked as "no".

[0075] Computational rules refer to rule indicators that require calculations on operation and maintenance work data and then judgment to obtain conclusions, including data calculation rules, quantitative statistical rules, etc.

[0076] Data calculation rules are used to analyze whether there are any anomalies in the calculated values. For example, the calculation rule "abnormal duration of switching jobs" means that the difference between the actual end time and the actual start time of the switching job is less than the preset time interval threshold (for example, ten minutes).

[0077] The quantity counting rule is used to count the number of work tickets that meet the preset standards and determine whether there are any abnormalities in the number of work tickets. For example, the quantity counting rule "number of operation items during fatigue-prone time periods" refers to the total number of operation items during fatigue-prone time periods (0:00 to 6:00).

[0078] It can be understood that in this embodiment, various verification rules and calculation rules are explained by taking the work ticket as an example, and the above rules are also applicable to other types of operation and maintenance work data such as operation tickets and work plans.

[0079] RPA robots can analyze and process data in work tickets, operation tickets, work plans, etc. to obtain operation and maintenance quality indicator parameters such as the number of work performed, work qualification rate, work standardization rate, and rationality of personnel allocation. Then, based on the above-mentioned supervision rules, it can determine whether the operation and maintenance quality indicator parameters meet the preset operation and maintenance quality requirements to obtain analysis results.

[0080] In this embodiment, the management rules corresponding to the current work tickets, operation tickets, work plans, etc. can be logically summarized based on company regulations to obtain more comprehensive and effective supervision rules, thereby achieving all-round and accurate operation and maintenance quality monitoring.

[0081] S103: Outputting the analysis result through the RPA robot.

[0082] The RPA robot can summarize the analysis results corresponding to different supervision rules and output the summarized analysis results to the RPA system page, or can generate corresponding operation and maintenance quality evaluation results based on each analysis result and output them to the RPA system page, so as to quantitatively control the work plan arrangement and work process in the power work and realize the operation and maintenance quality supervision of the power work. For example, the corresponding person in charge can be notified based on the non-standard work tickets, operation tickets, and work plan sheets, and the person in charge can train the operation and maintenance staff to avoid the recurrence of non-standard work tickets, operation tickets, and work plan sheets.

[0083] The power operation and maintenance monitoring method provided in the embodiment of the present disclosure obtains operation and maintenance work data related to the operation and maintenance quality in power work through an RPA robot; analyzes the operation and maintenance work data according to preset supervision rules to obtain analysis results; and outputs the analysis results through the RPA robot. Based on RPA, it is possible to achieve all-round, full-process, and fully automatic and accurate analysis of operation and maintenance quality, realize intelligent management of operation and maintenance quality, reduce labor costs through office automation, reduce the burden on grassroots staff of power grids, and improve the efficiency and accuracy of the monitoring process. At the same time, it can avoid errors in manual operations, such as data export errors, analysis and judgment errors, etc., and improve the accuracy of operation and maintenance quality monitoring.

[0084] It is understandable that in this embodiment, the supervision rules are divided into two categories, verification rules and calculation rules, according to whether the operation and maintenance work data needs to be calculated and processed, and multiple categories of verification rules and calculation rules are set to obtain comprehensive and accurate supervision rules. In specific implementations, other categories of verification rules and calculation rules can also be set, or the supervision rules can be divided into other categories of rules according to other classification standards. The specific classification standards and specific classification categories of the supervision rules are not specifically limited in this disclosure.

[0085] Optionally, step S1011 specifically includes:

[0086] S201: The RPA robot executes a preset JS function to obtain, in the web page, a web page frame name to which a function button to be clicked belongs according to an element name, wherein the function button is determined according to the screening condition and / or the data export method;

[0087] S202: The RPA robot locates the function button under the web page frame according to the web page frame name to obtain the target function button.

[0088] Existing RPA solutions may have inaccurate web page click recognition, resulting in the inability to obtain accurate operation and maintenance work data. In this step, JS-related functions can be introduced to parse the web page framework structure by executing JS-related functions to improve the execution success rate and accuracy of the RPA robot, thereby improving the reliability of the automated monitoring process.

[0089] During the export process, the RPA robot can use the "Execute JS" function in the "Browser" module under the RPA "Software Automation" module to obtain the web page frame name to which the function button to be clicked belongs based on the class attribute of the element in the page. Then, the function button under the frame is located according to the obtained web page frame name, and the function button located according to the web page frame name is determined as the target function button that needs to be clicked in the end. This effectively avoids the problem that the RPA robot cannot accurately identify the button after the frame changes due to the web page update.

[0090] The class attribute of the element is used to specify the class name (classname) of the page element. In specific implementation, the name of the webpage frame to which the function button to be clicked belongs can also be obtained based on the name attribute and title attribute of the element.

[0091] Optionally, in some other embodiments, step S1011 specifically includes:

[0092] S301: The RPA robot executes a preset JS function to locate the web page frame where the title text is located after traversing relevant elements in the web page according to the preset title text;

[0093] S302: The RPA robot locates the function button under the web page frame according to the web page frame name of the web page frame to obtain the target function button.

[0094] When the above steps S201 and S202 are not available, the "Execute JS" function can be used to locate the web page frame where the title is located after traversing the relevant elements in the page according to the preset title text and return the corresponding web page frame name. Then, the relevant function buttons under the web page frame are located according to the obtained web page frame name to obtain the target function button, which effectively solves the problem that the RPA robot cannot accurately identify the button after the frame changes due to web page update.

[0095] In some embodiments, step S102, analyzing the operation and maintenance work data according to a preset supervision rule to obtain an analysis result includes:

[0096] S1021: According to each of the verification rules or the calculation rules, a VBA function is written to save the standard verification data corresponding to the verification rule or the calculation rule in an Excel template;

[0097] S1022: The RPA robot imports the operation and maintenance work data into the Excel template;

[0098] S1023: The RPA robot executes VBA macros in sequence to perform rule verification on the operation and maintenance work data to obtain the analysis result;

[0099] S1024: The RPA robot stores the analysis result in a preset area of ​​a preset worksheet.

[0100] In this embodiment, the management rules of the current work tickets, operation tickets, and work plan sheets of the power grid are summarized as verification rules and calculation rules, and corresponding VBA functions are compiled to determine whether the work tickets, operation tickets, and work plan sheets are compliant. The VBA macro language is further used to realize automatic analysis of the operation and maintenance quality indicator parameters to obtain the analysis results, and then the analysis results are stored in the preset area of ​​the preset worksheet.

[0101] VBA code is convenient and stable, and RPA has good interactive capabilities. Together, they realize the automation of the entire process of data export and analysis for operation and maintenance work, saving a lot of labor costs and significantly improving the efficiency of operation and maintenance monitoring. At the same time, compared with manual analysis, the combination of RPA and VBA for data analysis can improve the timeliness of data analysis and the accuracy of analysis results, and avoid lags and errors in manual operations.

[0102] In some embodiments, in step S10, outputting the analysis result by the RPA robot includes:

[0103] The analysis results are displayed visually.

[0104] The visual display includes:

[0105] S401: Create a new presentation worksheet in Excel by writing VBA macro language;

[0106] S402: The RPA robot executes the VBA macro language of Excel and displays the analysis result in Excel.

[0107] For the analysis results corresponding to each supervision rule, you can create a new presentation worksheet in Excel by writing VBA macro language, and display the calculation results in it. For example, use the "Charts" collection and the "Chart Object" object to create a chart; then, use the RPA robot to execute Excel's VBA macro language to display the analysis results in Excel, so that the analysis results can be displayed on the system page of the RPA system. The analysis results can be displayed comprehensively, timely and intuitively, which is convenient for supervisors or operation and maintenance staff to view, thereby improving the effectiveness and efficiency of operation and maintenance quality supervision.

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

[0109] S104: Upload the analysis result to the data sharing system platform, and display it through a sharing system page of the data sharing system platform, wherein the sharing system page includes an operation and maintenance quality management page and / or a notification announcement page.

[0110] In this step, the RPA robot can automatically log in to the data sharing system platform and enter the relevant page. This includes entering the account password, passing the verification and logging in, and selecting the functional modules of the web page in turn to jump to the corresponding page. Then, the analysis result report corresponding to the above analysis results or the operation and maintenance quality evaluation report generated according to the analysis results is uploaded to the data sharing system platform page to realize the sharing of the analysis results, which is convenient for subsequent supervision and processing according to the analysis results. For example, each operation and maintenance staff can obtain the evaluation results of non-standard work tickets through the notification announcement page, which is convenient for the relevant operation and maintenance staff to make corrections in time so as to provide standardized work tickets in the future.

[0111] The data sharing system platform can be the platform of the above-mentioned RPA system, that is, the RPA system platform can be an on-site platform for power work or a remote platform.

[0112] In this embodiment, a series of processes such as exporting operation and maintenance work data, executing Excel VBA code for data analysis, outputting analysis results, and uploading analysis results to the data sharing system platform are implemented based on the RPA robot, thereby realizing full-process automatic monitoring and feedback of operation and maintenance quality, and realizing full-process automation and intelligence of operation and maintenance quality.

[0113] The above-mentioned power operation and maintenance monitoring method can logically summarize the management rules of current work tickets, operation tickets, work plans, etc. based on company regulations, and based on the RPA system, combine JS function analysis web page architecture to improve click success rate and combine VBA macro code to export and analyze operation and maintenance work data, so as to realize automated operation and maintenance quality monitoring based on supervision rules; at the same time, the multi-dimensional analysis results can be automatically presented to the RPA system page to realize daily monitoring of the operation and maintenance quality of power enterprises, thereby helping the work stations to control the work quality of the month and promote the improvement of grassroots operation and maintenance quality.

[0114] Embodiment 2

[0115] Figure 2 The structure diagram of the power operation and maintenance monitoring device according to the embodiment of the present disclosure is shown as follows: Figure 2 As shown, the embodiment of the present disclosure provides a power operation and maintenance monitoring device, including:

[0116] An acquisition module 10 is configured to acquire operation and maintenance work data related to the operation and maintenance quality in power work through an RPA robot;

[0117] The analysis module 20 is configured to analyze the operation and maintenance work data according to preset supervision rules to obtain analysis results, wherein the supervision rules include verification rules and calculation rules;

[0118] The output module 30 is configured to output the analysis result through the RPA robot.

[0119] In some embodiments, the acquisition module 10 is further configured to:

[0120] The RPA robot exports corresponding operation and maintenance work data from the web page related to the operation and maintenance quality according to preset screening conditions and / or preset data export methods.

[0121] In some embodiments, the acquisition module 10 is further configured to:

[0122] The RPA robot executes a preset JS function to obtain the webpage frame name to which the function button to be clicked belongs according to the element name in the webpage, wherein the function button is determined according to the screening condition and / or the data export method;

[0123] The RPA robot locates the function button under the web page frame according to the web page frame name to obtain the target function button.

[0124] In some embodiments, the acquisition module 10 is further configured to:

[0125] The RPA robot executes a preset JS function, traverses relevant elements in the web page according to the preset title text, and locates the web page frame where the title text is located;

[0126] The RPA robot locates the function button under the web page frame according to the web page frame name of the web page frame to obtain the target function button.

[0127] In some embodiments, the validation rules include at least one of time logic validation, text validation, duration validation, terminology validation, basic logic validation, and work standard validation rules.

[0128] The time logic verification rule is used to verify the execution of work ticket filling that does not conform to the time logic;

[0129] The text verification rules are used to verify the execution of work ticket filling that does not conform to text specifications;

[0130] The duration verification rule is used to verify the execution of work tickets that do not meet the duration requirements;

[0131] The terminology verification rules are used to verify the execution of work ticket filling that does not meet the terminology requirements;

[0132] The basic logic verification rules are used to verify the execution of work ticket filling that does not conform to the basic logic;

[0133] The work standard verification rules are used to verify the execution of work tickets that do not meet the work standards of the power company.

[0134] In some embodiments, the computational rules include at least one of data calculation and quantity statistics rules.

[0135] The data calculation rule is used to analyze whether the calculated value has an abnormality;

[0136] The quantity counting rule is used to count the number of work tickets that meet the preset standard and determine whether there is an abnormality in the number of work tickets.

[0137] In some embodiments, the analysis module 20 is further configured to:

[0138] According to each of the verification rules or the calculation rules, a VBA function is written to save the standard verification data corresponding to the verification rule or the calculation rule in an Excel template;

[0139] The RPA robot imports the operation and maintenance work data into the Excel template;

[0140] The RPA robot executes the VBA macro in sequence to perform rule verification on the operation and maintenance work data to obtain the analysis result;

[0141] The RPA robot stores the analysis result in a preset area of ​​a preset worksheet.

[0142] In some embodiments, the output module 30 is further configured to: visually display the analysis results;

[0143] The visual display includes:

[0144] Create a new presentation worksheet in Excel by writing VBA macro language;

[0145] The RPA robot executes the VBA macro language of Excel and displays the analysis results in Excel.

[0146] In some embodiments, an upload module is further included, configured to:

[0147] The analysis results are uploaded to the data sharing system platform and displayed through the shared system page of the data sharing system platform, wherein the shared system page includes an operation and maintenance quality management page and / or a notification announcement page.

[0148] The electric power operation and maintenance monitoring device provided in the embodiment of the present disclosure corresponds to the electric power operation and maintenance monitoring method in the above-mentioned embodiment. Any optional items in the embodiment of the electric power operation and maintenance monitoring method are also applicable to the embodiment of the electric power operation and maintenance monitoring device, which will not be repeated here.

[0149] Embodiment 3

[0150] An embodiment of the present disclosure also provides an electronic device, comprising at least a memory and a processor, wherein the memory stores a computer program, and the processor implements the above-mentioned power operation and maintenance monitoring method when executing the computer program on the memory.

[0151] In some embodiments, the processor executing the computer program may be a processing device including one or more general-purpose processing devices, such as a microprocessor, a central processing unit (CPU), a graphics processing unit (GPU), etc. More specifically, the processor may be a complex instruction set computing (CISC) microprocessor, a reduced instruction set computing (RISC) microprocessor, a very long instruction word (VLIW) microprocessor, a processor running other instruction sets, or a processor running a combination of instruction sets. The processor may also be one or more special-purpose processing devices, such as an application-specific integrated circuit (ASIC), a field programmable gate array (FPGA), a digital signal processor (DSP), a system on a chip (SoC), etc.

[0152] The memory may be a read-only memory (ROM), random access memory (RAM), phase-change random access memory (PRAM), static random access memory (SRAM), dynamic random access memory (DRAM), electrically erasable programmable read-only memory (EEPROM), other types of random access memory (RAM), flash disks or other forms of flash memory, cache, registers, static memory, compact disk read-only memory (CD-ROM), digital versatile disks (DVD) or other optical storage, cassettes or other magnetic storage devices, or any other possible non-transitory medium used to store information or instructions that can be accessed by a computer device.

[0153] The electronic devices of the embodiments of the present disclosure may include but are not limited to fixed terminal devices such as servers, desktop computers, digital TVs, etc., and mobile terminal devices such as vehicle-mounted devices (such as head-up display devices), handheld devices (such as mobile phones, tablet computers, etc.), and wearable devices (such as smart watches, smart bracelets, etc.).

[0154] Embodiment 4

[0155] The embodiment of the present disclosure further provides a computer-readable storage medium, wherein the computer-readable medium stores a computer program, and when the computer program is executed by a processor, the above-mentioned power operation and maintenance monitoring method is implemented.

[0156] The computer-readable storage medium of the embodiments of the present disclosure may adopt any combination of one or more computer-readable media. The computer-readable medium may be a computer-readable signal medium or a computer-readable storage medium. The computer-readable storage medium may be, for example, but not limited to, an electrical, magnetic, optical, electromagnetic, infrared, or semiconductor system, device or device, or any combination of the above. In the embodiments of the present disclosure, the computer-readable storage medium may be any tangible medium containing or storing a program, which may be used by or in combination with an instruction execution system, device or device, for example, the above-mentioned memory.

[0157] The computer programs of the embodiments of the present disclosure may be organized into one or more computer executable components or modules. Any number and combination of such components or modules may be used to implement the various aspects of the present disclosure. For example, the various aspects of the present disclosure are not limited to the specific computer executable instructions or specific components or modules shown in the drawings and described herein. Other embodiments may include different computer executable instructions or components with more or less functions than those shown and described herein.

[0158] The above description is only a preferred embodiment of the present disclosure and an explanation of the technical principles used. Those skilled in the art should understand that the scope of disclosure involved in the present disclosure is not limited to the technical solutions formed by a specific combination of the above technical features, but should also cover other technical solutions formed by any combination of the above technical features or their equivalent features without departing from the above disclosed concept. For example, the above features are replaced with the technical features with similar functions disclosed in the present disclosure (but not limited to) by each other to form a technical solution.

Claims

1. A method for monitoring power operation and maintenance, characterized in that: include: Obtaining operation and maintenance work data related to the operation and maintenance quality in the power work through an RPA robot, wherein the RPA robot determines the webpage frame or the webpage frame name of the webpage frame corresponding to the operation and maintenance work data from the webpage related to the operation and maintenance quality by executing a preset JS function, and the RPA robot locates the function button under the webpage frame according to the webpage frame name, obtains the target function button, and exports the operation and maintenance work data from the webpage; Analyze the operation and maintenance work data according to preset supervision rules to obtain analysis results, wherein the supervision rules include verification rules and calculation rules; The analysis result is outputted by the RPA robot.

2. The method according to claim 1, characterized in that Use RPA robots to obtain operation and maintenance work data related to operation and maintenance quality, including: The RPA robot exports corresponding operation and maintenance work data from the web page related to the operation and maintenance quality according to preset screening conditions and / or preset data export methods.

3. The method according to claim 2, characterized in that The RPA robot exports corresponding operation and maintenance work data from the webpage related to the operation and maintenance quality according to a preset screening condition and / or a preset data export method, including: The RPA robot executes a preset JS function to obtain the webpage frame name to which the function button to be clicked belongs according to the element name in the webpage, wherein the function button is determined according to the screening condition and / or the data export method; The RPA robot locates the function button under the web page frame according to the web page frame name to obtain the target function button.

4. The method according to claim 2, characterized in that: The RPA robot exports corresponding operation and maintenance work data from the webpage related to the operation and maintenance quality according to a preset screening condition and / or a preset data export method, including: The RPA robot executes a preset JS function, traverses relevant elements in the web page according to the preset title text, and locates the web page frame where the title text is located; The RPA robot locates the function button under the web page frame according to the web page frame name of the web page frame to obtain the target function button.

5. The method according to claim 1, characterized in that The verification rules include at least one of time logic verification, text verification, duration verification, terminology verification, basic logic verification, and work standard verification rules. The time logic verification rule is used to verify the execution of work ticket filling that does not conform to the time logic; The text verification rules are used to verify the execution of work ticket filling that does not conform to text specifications; The duration verification rule is used to verify the execution of work tickets that do not meet the duration requirements; The terminology verification rules are used to verify the execution of work ticket filling that does not meet the terminology requirements; The basic logic verification rules are used to verify the execution of work ticket filling that does not conform to the basic logic; The work standard verification rules are used to verify the execution of work tickets that do not meet the work standards of the power company.

6. The method according to claim 1, characterized in that The computational rules include at least one of data calculation and quantity statistics rules. The data calculation rule is used to analyze whether the calculated value has an abnormality; The quantity counting rule is used to count the number of work tickets that meet the preset standard and determine whether there is an abnormality in the number of work tickets.

7. The method according to claim 2, characterized in that The operation and maintenance work data is analyzed according to the preset supervision rules to obtain analysis results, including: According to each of the verification rules or the calculation rules, a VBA function is written to save the standard verification data corresponding to the verification rule or the calculation rule in an Excel template; The RPA robot imports the operation and maintenance work data into the Excel template; The RPA robot executes the VBA macro in sequence to perform rule verification on the operation and maintenance work data to obtain the analysis result; The RPA robot stores the analysis result in a preset area of ​​a preset worksheet.

8. The method according to claim 1, characterized in that Outputting the analysis result through the RPA robot includes: visually displaying the analysis result; The visual display includes: Create a new presentation worksheet in Excel by writing VBA macro language; The RPA robot executes the VBA macro language of Excel and displays the analysis results in Excel.

9. The method according to claim 1, characterized in that: The method further comprises: The analysis results are uploaded to the data sharing system platform and displayed through the shared system page of the data sharing system platform, wherein the shared system page includes an operation and maintenance quality management page and / or a notification announcement page.

10. A power operation and maintenance monitoring device, characterized in that: include: an acquisition module, configured to acquire operation and maintenance work data related to the operation and maintenance quality in the power work through an RPA robot, wherein the RPA robot determines a webpage frame or a webpage frame name of a webpage frame corresponding to the operation and maintenance work data from the webpage related to the operation and maintenance quality by executing a preset JS function, and the RPA robot locates a function button under the webpage frame according to the webpage frame name, obtains a target function button, and exports the operation and maintenance work data from the webpage; An analysis module is configured to analyze the operation and maintenance work data according to preset supervision rules to obtain analysis results, wherein the supervision rules include verification rules and calculation rules; An output module is configured to output the analysis result through the RPA robot.

Citation Information

Patent Citations

  • SQL data generation method and device

    CN108959508A

  • Interface element positioning method, electronic equipment and storage medium

    CN114816401A

  • Method and device for recording control in window, medium and equipment

    CN115509665A

  • Visual RPA table operation recording and automatic execution method and system

    CN115983221A

  • Data verification method and device, computer equipment and storage medium

    CN116737708A

Cited By

  • Security risk dynamic monitoring and early warning system based on two-ticket data of smart power plant

    CN120108160A