A power operation and maintenance supervision method and device

Abstract

The present disclosure relates to the technical field of electric power, and provides an electric power operation and maintenance supervision method and device, the method comprising: obtaining operation and maintenance work data related to operation and maintenance quality in electric power work through an RPA robot; analyzing the operation and maintenance work data according to preset supervision rules to obtain an analysis result, wherein the supervision rules comprise checking rules and calculation rules; and outputting the analysis result through the RPA robot. The present disclosure can realize all-round, full-process and full-automatic precise analysis of operation and maintenance quality based on RPA, realize intelligent management of operation and maintenance quality, reduce labor costs through office automation, reduce the burden of power grid grassroots staff, and improve the efficiency and accuracy of the supervision process; at the same time, errors in manual operation, such as data export errors and analysis and judgment errors, can be avoided, and the accuracy of operation and maintenance quality supervision is improved.

Description

TECHNICAL FIELD

[0001] The present disclosure relates to the technical field of electric power, in particular to an electric power operation and maintenance supervision method and device. BACKGROUND

[0002] In the power supply bureau work, in order to effectively supervise the operation and maintenance quality of the basic work, and promote the improvement of the operation and maintenance quality of the basic work, it is necessary to analyze the index parameters related to the operation and maintenance quality, such as the number of work carried out, the work qualified rate, the work standardization rate, the rationality of personnel configuration and the like, to judge whether it meets the requirements, and further present the results on the operation and maintenance quality supervision system to all employees. At present, the above process mainly relies on manual data export, analysis, judgment and result presentation, which has the problems of low efficiency, easy to make mistakes, lack of timeliness and the like. Some employees use VBA macro code in Excel for data analysis, which simplifies the manual data analysis part, but still needs manual data export from the system, manual analysis result uploading to the system platform, and the automation degree is still low, which cannot timely supervise the operation and maintenance quality in the power grid work, and the above method needs to consume a lot of time and energy of the employees, and the employees may make mistakes in the analysis process, such as missing judgment rules, wrong execution of screening conditions, missing problem work orders and the like, which affects the operation and maintenance quality supervision effect. In addition, when the relevant employees leave the post, the work order may not be effectively and timely supervised. SUMMARY

[0003] The purpose of the embodiments of the present disclosure is to provide an electric power operation and maintenance supervision method and device, so as to at least solve the technical problems of low automation degree of electric power operation and maintenance quality supervision, not timely operation and maintenance quality supervision and poor operation and maintenance quality supervision effect in the prior art.

[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, the embodiments of the present disclosure provide an electric power operation and maintenance supervision method, comprising:

[0006] acquiring operation and maintenance work data related to the operation and maintenance quality in the electric power work through an RPA robot;

[0007] analyzing the operation and maintenance work data according to a preset supervision rule to obtain an analysis result, wherein the supervision rule comprises a checking rule and a calculation rule;

[0008] outputting the analysis result through the RPA robot.

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

[0010] The RPA robot extracts the corresponding operation and maintenance work data from the operation and maintenance quality related webpage according to preset screening conditions and / or a preset data extraction method.

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

[0012] The RPA robot obtains the webpage frame name to which the function button to be clicked belongs in the webpage according to the element name by executing a preset JS function, wherein the function button is determined according to the screening conditions and / or the data extraction method;

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

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

[0015] The RPA robot locates the webpage frame in which the title text is located after traversing related elements in the webpage according to a preset title text by executing a preset JS function;

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

[0017] In some embodiments, the verification rules include at least one of a time logic verification, a character verification, a time length verification, a term verification, a basic logic verification, and a work standard verification rule,

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

[0019] The character verification rule is used to verify the work ticket filling execution that does not conform to the character specification;

[0020] The time length verification rule is used to verify the work ticket filling execution that does not conform to the time length requirement;

[0021] The term verification rule is used to verify the work ticket filling execution that does not conform to the term requirement;

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

[0023] The work standard verification rule is used to verify the work ticket filling execution that does not conform to the work standard of the power company.

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

[0025] The data calculation rule is used to analyze whether the calculated numerical value is abnormal;

[0026] The quantity statistical rule is used to count the number of work tickets meeting the preset standard and determine whether the number of work tickets is abnormal.

[0027] In some embodiments, the operation and maintenance work data is analyzed according to the preset supervision rules to obtain an analysis result, 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 rules or the calculation rules in an Excel template;

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

[0030] The RPA robot sequentially executes a VBA macro 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, the RPA robot outputs the analysis result, including: visualizing the analysis result;

[0033] The visualization includes:

[0034] A new display worksheet is created in Excel by writing a VBA macro language;

[0035] The RPA robot executes the VBA macro language of the Excel to display the analysis result in Excel.

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

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

[0038] In a second aspect, the embodiments of the present disclosure provide an electric power operation and maintenance supervision device, including:

[0039] The acquisition module is configured to acquire operation and maintenance work data related to operation and maintenance quality in power work by an RPA robot.

[0040] The analysis module is configured to analyze the operation and maintenance work data according to preset supervision rules to obtain an analysis result, wherein the supervision rules include checking rules and calculation rules.

[0041] The output module is configured to output the analysis result by the RPA robot.

[0042] In a third aspect, the embodiments of the present disclosure provide an electronic device, which at least includes a memory and a processor, the memory has a computer program stored thereon, and the processor implements the power operation and maintenance supervision method described above when executing the computer program stored on the memory.

[0043] In a fourth aspect, the embodiments of the present disclosure provide a computer readable storage medium, which has a computer program stored thereon, and the computer program is executed by a processor to implement the power operation and maintenance supervision method described above.

[0044] The power operation and maintenance supervision method and device provided by the embodiments of the present disclosure can acquire operation and maintenance work data related to operation and maintenance quality in power work by an RPA robot, analyze the operation and maintenance work data according to preset supervision rules to obtain an analysis result, and output the analysis result by the RPA robot. The operation and maintenance quality can be analyzed in a full range, a full process and a full automatic precision based on RPA, the intelligent management of the operation and maintenance quality can be realized, the human cost can be reduced through office automation, the burden of the power grid grassroots staff can be reduced, and the efficiency and accuracy of the supervision process can be improved. At the same time, errors in manual operation, such as data export errors and analysis and judgment errors, can be avoided, and the accuracy of the operation and maintenance quality supervision can be improved. BRIEF DESCRIPTION OF DRAWINGS

[0045] In order to more clearly illustrate the technical solutions in the embodiments of the present disclosure or the prior art, the following will briefly introduce the drawings needed to be used in the embodiments or the prior art description. Obviously, the drawings in the following description are only some embodiments described in the present disclosure, and for those skilled in the art, other drawings can also be obtained without creative labor based on these drawings.

[0046] Figure 1 The flowchart of the power operation and maintenance supervision method of the embodiments of the present disclosure;

[0047] Figure 2 The structural schematic diagram of the power operation and maintenance supervision device of the embodiments of the present disclosure. DETAILED DESCRIPTION

[0048] The various schemes and features of the present disclosure are described herein with reference to the accompanying drawings.

[0049] It is to be understood that various modifications can be made to the embodiments described herein. Thus, the description should not be considered as limiting, but merely as an example of the presently preferred embodiments. Other modifications would be obvious to one skilled in the art and can be made without departing from the spirit and scope of the present disclosure.

[0050] The accompanying drawings, which are incorporated in and constitute a part of this specification, illustrate embodiments of the present disclosure and, together with the general description of the 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 and appended claims, taken in conjunction with the accompanying drawings.

[0052] It should also be understood that, although the present disclosure has been described with reference to certain specific examples, various modifications thereof will be readily apparent to those skilled in the art and can be made without departing from the spirit and scope of the disclosure, as described by the claims.

[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, in which:

[0054] Specific embodiments of the present disclosure are described hereinafter, with reference to the drawings; however, it will be understood that the claimed embodiments are merely examples of the present disclosure, which can be embodied in various forms. Well-known and / or redundant functions and structures are not described in detail to avoid obscuring the present disclosure unnecessarily. Therefore, specific structural and functional details disclosed herein are not intended to limit the claimed embodiments, but merely as a basis for the claims and a representative basis for teaching one skilled in the art to variously employ the present disclosure in virtually any appropriate detailed structure.

[0055] The present specification can use the phrases "in one embodiment," "in another embodiment," "in yet another embodiment," or "in at least one embodiment," which can refer to one or more of the same or different embodiments of the present disclosure.

[0056] At present, power supply enterprises formulate management specifications for employees, and use work tickets, operation tickets, work plan sheets, etc. to arrange and control the work plan and work process in a certain way. However, in order to realize timely feedback and warning of on-site work specifications, personnel still need to continuously (such as monthly) count the non-standard work tickets, operation tickets, and work plan sheets of the station employees, and summarize them into analysis tables or notify the person in charge of the non-standard work tickets, operation tickets, and work plan sheets.

[0057] Existing technologies primarily rely on employees manually downloading, analyzing, and notifying relevant personnel of work tickets, operation tickets, and work plans. This method consumes a significant amount of employee time and energy daily, and can lead to errors during analysis, such as missing rules, incorrectly executing filtering conditions, and missing problematic work tickets. Furthermore, some existing RPA solutions for other scenarios suffer from limitations such as inaccurate web page click recognition and superficial data analysis (e.g., an inability to visualize analysis results).

[0058] Example 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 embodiment of the present disclosure provides a power operation and maintenance monitoring method, comprising:

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

[0061] Robotic Process Automation (RPA) is a technology that uses software robots to automate repetitive tasks. It simulates human operations on computers, such as data entry, data processing, and file transfers. It automates routine, repetitive tasks like manual operations, data entry, and data processing, significantly improving work efficiency and accuracy.

[0062] In this step, a Robotic Process Automation (RPA) robot can be pre-built on the server. This RPA robot automatically retrieves operational data related to the quality of power plant operations. Specifically, the RPA robot automatically logs into the RPA system and accesses the relevant webpage (also known as a page). For example, the RPA robot can automatically enter the operator's account and password, pass verification, and log into the RPA system page. It can then select the functional modules on the system page and navigate to the corresponding page, where it automatically retrieves operational data related to quality.

[0063] Operation and maintenance work data refers to the work data generated by maintenance personnel during power grid operation and maintenance, including work tickets, operation tickets, and work plans. This data can be entered manually into the RPA system by maintenance personnel during their work, or automatically by RPA robots. When power operations and maintenance monitoring is required, supervisors can automatically access this data through RPA robots, as described above.

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

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

[0066] The preset screening condition includes work date, work location, work team, work completion, etc. The preset data export method can include a specific data export method, such as exporting to a network disk, a U disk, or an email, etc. The data export method can also include an export format, such as exporting as an Excel table, exporting in a picture, video, file, etc. format; the data export method can also include an export mode, such as exporting all or part of the operation and maintenance work data, and the specific data export method is determined according to actual conditions, which is not specifically limited by the present disclosure.

[0067] S102: Analyzing the operation and maintenance work data according to a preset supervision rule to obtain an analysis result, wherein the supervision rule includes a verification rule and a calculation rule.

[0068] The verification rule refers to a rule index that can directly judge the operation and maintenance work data to obtain a conclusion. The verification rule includes at least one of a time logic verification, a text verification, a time length verification, a term verification, a basic logic verification, and a work standard verification rule.

[0069] The time logic verification rule is used to verify the work ticket filling and execution that does not conform to the time logic, such as "incorrect start time" which 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 rule is used to verify the work ticket filling and execution that does not conform to the text specification, such as "non-standard language" which means that "signboard" is incorrectly written as "signboard", or "station transformer" is incorrectly written as "station transformer", or "grounding transformer" is incorrectly written as "grounding transformer", etc.

[0071] The time length verification rule is used to verify the work ticket filling and execution that does not conform to the time length requirement, such as "abnormal equipment operation time" which means that the single operation time is less than 15 seconds.

[0072] The term verification rule is used to verify the work ticket filling and execution that does not conform to the term requirement, such as "incorrect switch operation" which means that in a single operation that does not contain "knife switch", it contains "pull out" and "switch" operations at the same time.

[0073] The basic logic verification rule is used to verify the work ticket filling and execution that does not conform to the basic logic, such as "zero work number" which means that the work estimated number field is filled with "0".

[0074] The work standard checking rule is used to check the filling and execution of work tickets that do not meet the work standards of the power company, for example, "same person holding multiple tickets at the same time" refers to the same person holding two or more work tickets at the same time; "incomplete construction operation file" refers to the work ticket of an external unit that has been archived and "whether there is a construction plan" is false.

[0075] The computational rule refers to a rule index that needs to be obtained by calculating the operation and maintenance work data, including data calculation rules, quantity statistics rules, etc.

[0076] The data calculation rule is used to analyze whether the calculated value is abnormal, for example, the computational rule "abnormal duration of switching type operation" refers to the difference between the actual end time and the actual start time of the switching type work being less than a preset time interval threshold (for example, ten minutes).

[0077] The quantity statistics rule is used to count the number of work tickets that meet the preset standard and determine whether the number of work tickets is abnormal, for example, the quantity statistics rule "number of operation items in the fatigue prone period" refers to the total number of operation items in the fatigue prone period (0 o'clock to 6 o'clock).

[0078] It can be understood that in this embodiment, the work ticket is taken as an example to illustrate each checking rule and computational rule, and the above rules are also applicable to other types of operation and maintenance work data such as operation tickets, work plan sheets, etc.

[0079] The RPA robot can analyze and process the data in the work ticket, operation ticket, work plan sheet, etc., to obtain operation and maintenance quality index parameters such as the number of work carried out, the work qualification rate, the work specification rate, and the rationality of personnel allocation, and then determine whether the operation and maintenance quality index parameters meet the preset operation and maintenance quality requirements according to the above supervision rules to obtain the analysis result.

[0080] In this embodiment, the management rules corresponding to the current work ticket, operation ticket, work plan sheet, etc. can be logically summarized based on the company's regulations to obtain more comprehensive and effective supervision rules, thereby realizing all-around accurate operation and maintenance quality supervision.

[0081] S103: output the analysis result by the RPA robot.

[0082] RPA robots can aggregate the analysis results corresponding to different supervision rules and output these aggregated results to the RPA system page. Alternatively, they can generate corresponding operation and maintenance quality evaluation results based on the individual analysis results and output them to the RPA system page. This allows for quantitative control over work plans and processes in power operations, enabling operational quality monitoring of power operations. For example, non-standard work tickets, operation tickets, and work plans can be used to notify the responsible person, who can then provide training to the operation and maintenance staff to prevent recurrence of these issues.

[0083] The power operation and maintenance monitoring method provided by 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 the power grid, 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 understood that in this embodiment, the supervision rules are divided into two categories: verification rules and calculation rules, based on whether the operation and maintenance work data needs to be calculated and processed. 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 based on 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, from the web page, a name of a web page frame to which a function button to be clicked belongs based on an element name, wherein the function button is determined based on the screening condition and / or 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 a target function button.

[0088] The existing RPA solution may have inaccurate webpage click recognition, which cannot obtain accurate operation and maintenance data. In this step, JS related function functions can be introduced to improve the success rate and accuracy of RPA robots by executing JS related function functions to parse the webpage framework structure, thereby improving the reliability of the automatic monitoring process.

[0089] In the process of performing the export operation, the RPA robot can use the "execute JS" function function in the "browser" module under the RPA "software automation" module to obtain the webpage framework name to which the function button to be clicked belongs according to the class attribute of the element in the page, and then locate the function button under the framework according to the obtained webpage framework name. The function button located according to the webpage framework name is determined as the target function button that needs to be clicked finally, which effectively avoids the problem that the RPA robot cannot accurately recognize the button after the framework changes due to webpage updates.

[0090] Among them, the class attribute of the element is used to specify the class name (classname) of the page element. In specific implementation, the webpage framework name to which the function button to be clicked belongs can also be obtained according to the name (name) attribute, title (title) attribute, etc. of the element.

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

[0092] S301: The RPA robot locates the webpage framework where the title text is located by executing the preset JS function function and traversing the related elements in the webpage according to the preset title text.

[0093] S302: The RPA robot locates the function button under the webpage framework according to the webpage framework name of the webpage framework, and obtains the target function button.

[0094] When the above steps S201 and S202 are not available, the "execute JS" function function can be used to locate the webpage framework where the title is located and return the corresponding webpage framework name according to the preset title text in the page after traversing the related elements, and then locate the related function button under the webpage framework according to the obtained webpage framework name to obtain the target function button, thereby effectively solving the problem that the RPA robot cannot accurately recognize the button after the framework changes due to webpage updates.

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

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

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

[0098] S1023: The RPA robot sequentially executes the VBA macro to perform rule checking 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 existing work tickets, operation tickets, and work plan sheets of the power grid are summarized as check rules and calculation rules, and corresponding VBA functions for judging whether the work tickets, operation tickets, and work plan sheets are compliant are prepared. Further, the VBA macro language is used to realize automatic analysis of the operation and maintenance quality index parameters to obtain the analysis result, and then the analysis result is stored in a preset area of a preset worksheet.

[0101] The VBA code has certain convenience and stability, and the RPA has good interaction ability. The two together realize the automation of the whole process of operation and maintenance work data export and analysis, save a lot of manpower cost, and significantly improve the operation and maintenance supervision efficiency. 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 the lag and errors in manual operation.

[0102] In some embodiments, in step S10, the RPA robot outputs the analysis result, including:

[0103] The analysis result is visually displayed.

[0104] The visual display includes:

[0105] S401: A new display worksheet is created in Excel by writing a VBA macro language;

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

[0107] For the analysis result corresponding to each supervision rule, a new display worksheet can be created in Excel by writing VBA macro language, and the calculation result is displayed in it, for example, a chart is created using the "Charts" collection and the "Chart Object" object; then, the RPA robot executes the VBA macro language of Excel to display the analysis result in Excel, so as to display the analysis result on the system page of the RPA system. The analysis result can be fully, timely and intuitively displayed, which is convenient for the supervision personnel or operation and maintenance staff to check, and improves the operation and maintenance quality supervision effect and efficiency.

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

[0109] S104: uploading the analysis result to a data sharing system platform and displaying 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. It includes inputting the account and password, passing the verification and logging in, and selecting the function modules of the webpage in turn to jump to the corresponding page. Then, the analysis result report corresponding to the above analysis result or the operation and maintenance quality evaluation report generated according to the analysis result is uploaded to the data sharing system platform page, realizing the sharing of the analysis result, and facilitating the subsequent monitoring and processing according to the analysis result. For example, each operation and maintenance staff can obtain the non-standard work ticket evaluation result through the notification announcement page, so that the relevant operation and maintenance staff can correct it in time, so as to provide a standard work ticket in the future.

[0111] The data sharing system platform can be the RPA system platform described above, that is, the RPA system platform can be the power work site platform, or it can be a remote platform.

[0112] In this embodiment, based on the RPA robot, a series of processes such as export of operation and maintenance work data, execution of Excel VBA code for data analysis, analysis result output, uploading of analysis result to data sharing system platform, etc. are realized, so as to realize the whole process automatic supervision and feedback of operation and maintenance quality, and realize the whole process automation and intelligentization of operation and maintenance quality.

[0113] The power operation supervision method can logically summarize the management rules of existing work tickets, operation tickets, work plan sheets and the like based on company regulations, and based on an RPA system, improve the click success rate by analyzing the webpage architecture in combination with JS functions, and export and analyze the operation work data in combination with VBA macro codes, so as to realize automatic operation quality supervision based on supervision rules; meanwhile, the multi-dimensional analysis results can be automatically presented to the RPA system page, realizing daily supervision of the operation quality of the power enterprise, so as to help the station to control the work quality of the month and promote the improvement of the operation quality of the grassroots.

[0114] Embodiment Two

[0115] Figure 2 A structural schematic diagram of a power operation supervision device is shown, as Figure 2 shown, the power operation supervision device comprises:

[0116] The acquisition module 10 is configured to acquire operation work data related to operation quality in power work by an RPA robot;

[0117] The analysis module 20 is configured to analyze the operation work data according to a preset supervision rule to obtain an analysis result, wherein the supervision rule comprises a checking rule and a calculation rule;

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

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

[0120] The RPA robot exports corresponding operation work data from the webpage related to the operation quality according to a preset screening condition and / or a preset data export method.

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

[0122] The RPA robot acquires the webpage framework name to which the function button to be clicked belongs in the webpage according to the element name by executing a preset JS function, 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 webpage framework according to the webpage framework name to obtain a target function button.

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

[0125] The RPA robot executes a preset JS function to traverse 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 tickets that do not conform to time logic;

[0129] The text verification rules are used to verify the execution of work tickets that do 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 tickets that do not meet the terminology requirements;

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

[0133] The work standard verification rule is used to verify the filling and 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 quantitative statistical rules.

[0135] The data calculation rules are used to analyze whether the calculated values ​​are abnormal;

[0136] The quantity counting rule is used to count the number of work tickets that meet the preset standards and to 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 validation rules or the calculation rules, a VBA function is written to save the standard validation data corresponding to the validation 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 sequentially executes the VBA macro 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 result.

[0143] The visual display includes:

[0144] A new display worksheet is created in Excel by writing a VBA macro language.

[0145] The RPA robot executes the VBA macro language of the Excel to display the analysis result in the Excel.

[0146] In some embodiments, the method further comprises an uploading module configured to:

[0147] The analysis result is uploaded to a data sharing system platform and displayed through a sharing system page of the data sharing system platform, the sharing system page including an operation and maintenance quality management page and / or a notification announcement page.

[0148] The power operation and maintenance supervision device provided by the embodiments of the present disclosure corresponds to the power operation and maintenance supervision method described above, and any optional items in the power operation and maintenance supervision method embodiments are also applicable to the embodiments of the power operation and maintenance supervision device, which will not be described here.

[0149] Embodiment three

[0150] The embodiments of the present disclosure also provide an electronic device, which at least includes a memory and a processor, the memory has a computer program stored thereon, and the processor implements the power operation and maintenance supervision method described above when executing the computer program stored on the memory.

[0151] In some embodiments, the processor executing the computer program can 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), and the like. More specifically, the processor can be a complex instruction set computing (CISC) microprocessor, a reduced instruction set computing (RISC) microprocessor, a very long instruction word (VLIW) microprocessor, a processor operating other instruction sets, or a processor operating a combination of instruction sets. The processor can 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), and the like.

[0152] The memory can be 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 memory or other forms of flash storage, cache, register, static memory, compact disc read-only memory (CD-ROM), digital versatile disc (DVD) or other optical memory, magnetic cassettes or other magnetic storage devices, or any other possible non-transitory medium that can be used to store information or instructions that can be accessed by a computing device, etc.

[0153] The electronic device of the embodiments of the present disclosure can include, but is not limited to, fixed terminal devices such as servers, desktop computers, digital TVs, etc., and mobile terminal devices such as in-vehicle devices (e.g., head-up display devices), handheld devices (e.g., mobile phones, tablet computers, etc.), wearable devices (e.g., smart watches, smart bands, etc.), etc.

[0154] Embodiment Four

[0155] The embodiments of the present disclosure also provide a computer readable storage medium, which stores a computer program. The computer program is executed by a processor to implement the power operation and maintenance monitoring method described above.

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

[0157] The computer program of the embodiments of the present disclosure can be organized into one or more computer executable components or modules. Any number and combination of such components or modules can be used to implement aspects of the present disclosure. For example, aspects of the present disclosure are not limited to the specific computer executable instructions or specific components or modules illustrated in the figures and described herein. Other embodiments can include different computer executable instructions or components that have more or less functionality than that described herein.

[0158] The above description is merely that of the preferred embodiments of the present disclosure and a description of the technical principles of the present disclosure. It should be understood by those skilled in the art that the disclosed scope of the present disclosure is not limited to the technical solutions with the specific combinations of the above technical features, and should also cover other technical solutions formed by the combinations of the above technical features or their equivalent features without departing from the concept of the above disclosure. For example, the technical solutions formed by the mutual replacement of the above features and the technical features with similar functions disclosed in the present disclosure (but not limited to) without departing from the concept of the above disclosure.

Claims

1. A power operation and maintenance supervision method, characterized in that, The method comprises the following steps: obtaining operation and maintenance work data related to operation and maintenance quality in power work by an RPA robot, wherein the RPA robot determines a web frame or a web frame name of the web frame corresponding to the operation and maintenance work data from the operation and maintenance quality related webpage by executing a preset JS function function, and the RPA robot locates a function button under the web frame according to the web frame name to obtain a target function button to export the operation and maintenance work data from the webpage; analyzing the operation and maintenance work data according to a preset supervision rule to obtain an analysis result, wherein the supervision rule comprises a verification rule and a calculation rule; outputting the analysis result by the RPA robot; wherein analyzing the operation and maintenance work data according to a preset supervision rule to obtain an analysis result comprises: saving standard verification data corresponding to the verification rule or the calculation rule in an Excel template by compiling a VBA function according to each of the verification rule or the calculation rule; the RPA robot imports the operation and maintenance work data into the Excel template; the RPA robot sequentially executes a VBA macro 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.

2. The method of claim 1, wherein, Obtaining operation and maintenance work data related to operation and maintenance quality by an RPA robot comprises: the RPA robot exports corresponding operation and maintenance work data from the operation and maintenance quality related webpage according to a preset filtering condition and / or a preset data export method.

3. The method of claim 2, wherein, the RPA robot exports corresponding operation and maintenance work data from the operation and maintenance quality related webpage according to a preset filtering condition and / or a preset data export method, comprising: the RPA robot acquires a web frame name of a function button to be clicked in the webpage according to an element name by executing a preset JS function function, wherein the function button is determined according to the filtering condition and / or the data export method; the RPA robot locates the function button under the web frame according to the web frame name to obtain a target function button.

4. The method of claim 2, wherein, the RPA robot exports corresponding operation and maintenance work data from the operation and maintenance quality related webpage according to a preset filtering condition and / or a preset data export method, comprising: the RPA robot locates a web frame where a title text is located in the webpage by executing a preset JS function function after traversing related elements in the webpage according to the preset title text; the RPA robot locates a function button under the web frame according to a web frame name of the web frame to obtain a target function button.

5. The method of claim 1, wherein, The verification rule comprises at least one of a time logic verification, a text verification, a time length verification, a term verification, a basic logic verification, and a work standard verification rule, the time logic verification rule is used to verify the work ticket filling execution that does not conform to the time logic; the text verification rule is used to verify the work ticket filling execution that does not conform to the text specification; the time length verification rule is used to verify the work ticket filling execution that does not conform to the time length requirement; The term checking rule is used to check the filling and execution of the work ticket that does not meet the term requirements; The basic logic checking rule is used to check the filling and execution of the work ticket that does not meet the basic logic; The work standard checking rule is used to check the filling and execution of the work ticket that does not meet the work standard of the power company.

6. The method of claim 1, wherein, The calculation rule includes at least one of data calculation and quantity statistical rule, The data calculation rule is used to analyze whether the calculated value is abnormal; The quantity statistical rule is used to count the number of work tickets that meet the preset standard and determine whether the number of work tickets is abnormal.

7. The method of claim 1, wherein, The analysis result is output by the RPA robot, including visualizing the analysis result; The visualization includes: A new display worksheet is created in Excel by writing VBA macro language; The RPA robot executes the VBA macro language of Excel to display the analysis result in Excel.

8. The method of claim 1, wherein, The method further includes: The analysis result is uploaded to a data sharing system platform and displayed through a sharing system page of the data sharing system platform, and the sharing system page includes an operation and maintenance quality management page and / or a notification announcement page.

9. A power operation and maintenance monitoring device, characterized in that, It includes: An acquisition module is configured to acquire operation and maintenance work data related to operation and maintenance quality in power operation through an RPA robot, wherein the RPA robot determines a web framework or a web framework name of the web framework corresponding to the operation and maintenance work data from a web page related to the operation and maintenance quality by executing a preset JS function function, and the RPA robot locates a target function button under the web framework according to the web framework name to export the operation and maintenance work data from the web page; An analysis module is configured to analyze the operation and maintenance work data according to a preset supervision rule to obtain an analysis result, wherein the supervision rule includes a checking rule and a calculation rule; An output module is configured to output the analysis result through the RPA robot; The analysis module is further configured to: According to each of the checking rule or the calculation rule, a VBA function is written to save the standard checking data corresponding to the checking 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 VBA macro to perform rule checking on the operation and maintenance work data in sequence to obtain the analysis result; The RPA robot stores the analysis result in a preset area of a preset worksheet.

Images