CN113327097A

CN113327097A - Analysis drawing method and device

Info

Publication number: CN113327097A
Application number: CN202110649818.6A
Authority: CN
Inventors: 莫介铜; 邓啟东; 徐振洪; 戴航; 梁笑桦
Original assignee: Guangdong Power Grid Co Ltd; Foshan Power Supply Bureau of Guangdong Power Grid Corp
Current assignee: Guangdong Power Grid Co Ltd; Foshan Power Supply Bureau of Guangdong Power Grid Corp
Priority date: 2021-06-10
Filing date: 2021-06-10
Publication date: 2021-08-31
Anticipated expiration: 2041-06-10
Also published as: CN113327097B

Abstract

The invention discloses an analysis drawing method and a device, wherein the method comprises the following steps: positioning a terminal corresponding to the metering point table code information according to the acquired metering point table code information and a robot flow automation technology, screening the meter reading data in the terminal to obtain screened meter reading data, analyzing and calculating the screened meter reading data to obtain an analysis calculation result, and drawing to obtain a hexagonal graph by combining the robot flow automation technology based on the analysis calculation result. The invention reads data through the robot process automation technology, and carries out calculation analysis and drawing, thereby liberating more human resources and improving the business production efficiency.

Description

Analysis drawing method and device

Technical Field

The invention relates to the field of data analysis and drawing, in particular to an analysis and drawing method and device.

Background

At present, the robot process automation technology has a great variety in various social fields due to a series of characteristics of high efficiency, high accuracy, low cost, safe data and the like. In the industries of various fields, a large number of repetitive works exist, the works have a fixed rule, and are circulated by manpower repeatedly every day, and the robot can replace a person to automatically complete the repetitive works through a robot flow automation technology, so that more human resources are released. For example, in the financial industry, a cash reconciliation robot, a tax declaration robot and the like are realized through a robot flow automation technology; in the field of manufacturing industry, robots for automatically generating bill of materials, robots for automatically tracking logistics information and the like exist; in the education industry, a score input robot, an attendance management robot and the like exist.

In the prior art, measurement teams and groups need to inquire the table code information (including current and voltage, active power, reactive power and the like) of a large number of measurement points in a measurement automatic system every month, and also need to inquire data for analysis, judge included angles, currents, wiring, phase sequences and the like, and finally draw a hexagonal graph.

Therefore, in order to ensure the automatic and efficient operation of the drawing, and solve the technical problem that the data cannot be analyzed and drawn by the system at present, it is necessary to construct an analysis drawing method.

Disclosure of Invention

The invention provides an analysis drawing method and device, which solve the technical problem that data cannot be analyzed and drawn through a system at present.

In a first aspect, the present invention provides an analysis plotting method, comprising:

positioning a terminal corresponding to the metering point table code information according to the acquired metering point table code information and a robot process automation technology;

screening the meter reading data in the terminal to obtain screened meter reading data;

analyzing and calculating the screened meter reading data to obtain an analysis calculation result;

and drawing to obtain a hexagonal graph based on the analysis calculation result and by combining the robot process automation technology.

Optionally, before positioning to the terminal corresponding to the metering point table code information according to the acquired metering point table code information and the robot process automation technology, the method further includes:

and presetting the query period, the file position and the threshold parameter of the metering point table code information.

Optionally, positioning a terminal corresponding to the metering point table code information according to the metering point table code information includes:

logging in a metering automation system by utilizing a robot process automation technology, and acquiring metering point table code information of the metering automation system;

obtaining terminal information corresponding to the metering point table code information according to the incidence relation existing in the metering automation system;

and positioning the terminal corresponding to the metering point table code information based on the terminal information corresponding to the metering point table code information by combining the robot process automation technology.

Optionally, the step of screening the meter reading data in the terminal to obtain the screened meter reading data includes:

acquiring meter reading data in the terminal, and constructing the meter reading data into a data table;

and screening out target data from the data table to obtain screened meter reading data.

Optionally, analyzing and calculating the screened meter reading data to obtain an analysis calculation result, including:

performing current analysis on the screened meter reading data to obtain a current analysis result;

based on different voltage conditions, carrying out wiring analysis on the screened meter reading data to obtain a wiring analysis result;

and compiling the current analysis result and the wiring analysis result to obtain an analysis calculation result.

In a second aspect, the present invention provides an analysis plotting apparatus comprising:

the positioning module is used for positioning a terminal corresponding to the metering point table code information according to the acquired metering point table code information and a robot process automation technology;

the screening module is used for screening the meter reading data in the terminal to obtain the screened meter reading data;

the analysis module is used for analyzing and calculating the screened meter reading data to obtain an analysis calculation result;

and the drawing module is used for drawing to obtain a hexagonal drawing by combining the robot process automation technology based on the analysis and calculation result.

Optionally, the apparatus further comprises:

and the presetting module is used for presetting the query period, the file position and the threshold parameter of the metering point table code information.

Optionally, the positioning module comprises:

the acquisition submodule is used for logging in a metering automatic system by utilizing a robot process automation technology and acquiring metering point table code information of the metering automatic system;

the correlation submodule is used for obtaining terminal information corresponding to the metering point table code information according to the correlation existing in the metering automation system;

and the positioning sub-module is used for positioning the terminal corresponding to the metering point table code information based on the terminal information corresponding to the metering point table code information by combining the robot process automation technology.

Optionally, the screening module comprises:

the construction submodule is used for acquiring meter reading data in the terminal and constructing the meter reading data into a data table;

and the screening submodule is used for screening target data from the data table to obtain screened meter reading data.

Optionally, the analysis module comprises:

the current submodule is used for carrying out current analysis on the screened meter reading data to obtain a current analysis result;

the wiring submodule is used for carrying out wiring analysis on the screened meter reading data based on different voltage conditions to obtain a wiring analysis result;

and the compiling submodule is used for compiling the current analysis result and the wiring analysis result to obtain an analysis calculation result.

According to the technical scheme, the invention has the following advantages: the invention provides an analysis and drawing method, which comprises the steps of positioning a terminal corresponding to metering point table code information according to the acquired metering point table code information and a robot flow automation technology, screening meter reading data in the terminal to obtain screened meter reading data, analyzing and calculating the screened meter reading data to obtain an analysis and calculation result, drawing a hexagonal graph based on the analysis and calculation result and combining the robot flow automation technology, reading the data through the robot flow automation technology, calculating, analyzing and drawing.

Drawings

In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings used in the description of the embodiments or the prior art will be briefly described below, and it is obvious that the drawings in the following description are only some embodiments of the present invention, and for those skilled in the art, other drawings can be obtained according to these drawings without inventive exercise.

FIG. 1 is a flowchart illustrating a first embodiment of an analysis plotting method according to the present invention;

FIG. 2 is a flowchart illustrating a second embodiment of an analysis plotting method according to the present invention;

fig. 3 is a block diagram of an embodiment of an analysis plotting apparatus according to the present invention.

Detailed Description

The embodiment of the invention provides an analysis and drawing method and device, which are used for solving the technical problem that data cannot be analyzed and drawn through a system at present.

In order to make the objects, features and advantages of the present invention more obvious and understandable, the technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the accompanying drawings in the embodiments of the present invention, and it is obvious that the embodiments described below are only a part of the embodiments of the present invention, and not all of the embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.

In a first embodiment, referring to fig. 1, fig. 1 is a flowchart of a first embodiment of an analysis drawing method according to the present invention, including:

step S101, positioning a terminal corresponding to the metering point table code information according to the acquired metering point table code information and a robot process automation technology;

it should be noted that the robot process automation technology is configured to simulate human interaction in a software system, thereby allowing a business process to be performed. The robot process automation software robot recognizes data on the application program interface and manipulates the application program like a human. The robot process automation software interacts with other systems according to rules and performs various repetitive tasks as needed. It does better than humans. The robot flow automation software robot can not sleep and make mistakes, and the cost is much lower than that of staff. The robotic process automation software enables an organization to automate with less capital and in less time than other traditional software solutions. The robot process automation software enables enterprises to become larger and better by improving operation and business predictability, and meanwhile, the competitiveness of the enterprises is improved in a battle manner.

Step S102, screening the meter reading data in the terminal to obtain the screened meter reading data;

step S103, analyzing and calculating the screened meter reading data to obtain an analyzing and calculating result;

and step S104, drawing to obtain a hexagonal chart based on the analysis calculation result and by combining the robot process automation technology.

According to the analysis and drawing method provided by the embodiment of the invention, the terminal corresponding to the metering point table code information is positioned according to the acquired metering point table code information and the robot flow automation technology, the meter reading data in the terminal are screened to obtain screened meter reading data, the screened meter reading data are analyzed and calculated to obtain an analysis and calculation result, a hexagonal graph is drawn by combining the robot flow automation technology based on the analysis and calculation result, the data are read by the robot flow automation technology, and the method for calculating, analyzing and drawing is adopted, so that the technical problem that the data cannot be analyzed and drawn by a system at present is solved, more human resources are liberated, and the service production efficiency is improved.

In a second embodiment, referring to fig. 2, fig. 2 is a flowchart of a method for analyzing and plotting according to the present invention, including:

step S201, logging in a metering automation system by utilizing a robot process automation technology, and acquiring metering point table code information of the metering automation system;

in an optional embodiment, before logging in a metering automation system and acquiring metering point code information of the metering automation system by using a robot process automation technology, the method further includes:

In the embodiment of the invention, the query period, the file position and the threshold parameter of the metering point table code information are preset, so that the step of acquiring the metering point table code information is more convenient, and then the metering automation system is logged in by utilizing a robot process automation technology and the metering point table code information of the metering automation system is acquired.

Step S202, obtaining terminal information corresponding to the metering point table code information according to the incidence relation existing in the metering automation system;

in the embodiment of the invention, the terminal information corresponding to the metering point table code information is obtained according to the incidence relation existing in the metering automation system.

In the specific implementation, logging in a metering automation system, wherein a mouse click command and a keyboard input command packaged by UIBOT are required to realize the input of an account password; in addition, because the verification code displayed by the webpage needs to be input during logging, a plug-in for converting image identification into characters written by Python is also used, and the plug-in is mainly used for positioning and intercepting the verification code picture and calling ocr technology of open source software tesseract to convert the picture identification into characters. Finally, the function of capturing errors and restarting the login process is written in botscript language carried by the UIBOT, so that login failure is avoided when accidents (such as network delay and browser running) occur.

Reading all the metering point numbers needing to be inquired through an EXCEL reading area command of UIBOT, then expanding an inquiry interface, inputting one by one for inquiry, and obtaining terminal information corresponding to the metering point table code information.

Step S203, positioning a terminal corresponding to the metering point table code information based on the terminal information corresponding to the metering point table code information by combining the robot process automation technology;

in the embodiment of the invention, the terminal corresponding to the metering point table code information is positioned according to the inquired terminal information corresponding to the metering point table code information.

In the specific implementation, it is necessary to determine whether the measurement point is a dual-meter dual-terminal or a single-meter single-terminal in the positioning process, and if the measurement point is a dual-meter dual-terminal, it is further determined whether the positioned terminal is a main terminal, if the measurement point is a dual-meter dual-terminal, the next process query is performed, and if the measurement point is not a single-meter dual-terminal, the other terminal is returned to be positioned. The process uses Js language to obtain the query location result, and determines the situation by analyzing the number of terminals and the number of the measuring points in the query result.

Step S204, acquiring meter reading data in the terminal, and constructing the meter reading data into a data table;

in the embodiment of the invention, the downloaded meter reading data in the corresponding terminal is constructed into a data table.

In the concrete implementation, a mouse click command is used for entering a meter reading data interface, an element setting command sets a query time period and queries, finally a mouse click command is used for clicking a lead-out button to realize lead-out, due to the problems of network and system delay and large lead-out data volume, the downloading speed is generally slow, and therefore a waiting function needs to be written in a botscript language to wait for the completion of table downloading. And reading the downloaded file contents through a UIBOT read area command, and constructing a data table by using a data table command.

S205, screening target data from the data table to obtain screened meter reading data;

the target data is data at the time when the active power is maximum, and includes voltage, current, voltage phase angle, current phase angle, active power, reactive power, active total, reactive total, and the like of the three phases.

In the embodiment of the invention, the target data is screened from the data table to obtain the screened meter reading data.

In a specific implementation, data at the moment when the active power is maximum are screened from a constructed data table, and the data at the moment (the voltage, the current, the voltage phase angle, the current phase angle, the active power, the reactive power, the active total, the reactive total and the like of the ABC three phases) are recorded and temporarily stored in an array of a flow.

Step S206, performing current analysis on the screened meter reading data to obtain a current analysis result;

in the embodiment of the invention, the current judgment is carried out on the screened meter reading data, whether the current is normally output is judged, and a current judgment result is obtained.

In a specific implementation, the voltage and current of three phases are Ua, Ub, Uc, Ia, Ib, Ic, respectively.

If Ia, Ib and Ic are smaller than limit _ current (current threshold), the current is smaller than the set threshold in the column output of the current judgment, and otherwise, the current is left empty.

Step S207, based on different voltage conditions, carrying out wiring analysis on the screened meter reading data to obtain a wiring analysis result;

in the embodiment of the invention, based on different voltage conditions, the screened meter reading data is subjected to wiring judgment, whether the current is normally output is judged, and a wiring judgment result is obtained.

In a specific implementation, if Ua and Uc are both less than 150V, and Ub is 0V. And the high meter, three-phase three-wire is output in the wire connection judgment column. "high meter, three-phase three-wire" is divided into two cases,

1) the first case of "high count, three phase three wire":

if the voltage phase angle Cphase is larger than 290 degrees and smaller than 310 degrees, the 'positive phase sequence' is output in the 'phase sequence judgment' column.

The included angle between Ia and Ua is-30 degrees of a voltage phase angle (A phase);

the included angle between Ic and Uc is-270 degrees as the voltage phase angle (C phase);

note that: if Ia and Ua form an angle of 270 degrees, the angle needs to be corrected.

An included angle between Ia and Ua (after correction) — 360 degrees (before correction), and the included angle between Ia and Ua is between-90 and 270.

And filling the calculated data into the corresponding column.

And (4) judging an included angle: if the following conditions are simultaneously satisfied:

1. an angle between Ia and Ua is ═ limit _ angle (angle threshold) and an angle between Ia and Ua is ≦ limit _ angle (angle threshold);

2. an angle between Ic and Uc is ═ limit _ angle (angle threshold) and an angle between Ic and Uc is ≦ limit _ angle (angle threshold);

the included angle judgment is 'included angle normal', otherwise 'abnormal'.

2) Second case of "high count, three phase three wire":

if the voltage phase angle Cphase is greater than 50 degrees and less than 70 degrees, the phase sequence judgment column of annex 1: outputs the reverse phase sequence.

Angle between Ia and Ua is 360 deg. -voltage phase angle (a phase) -30 deg

Angle between Ic and Uc is 90 degrees-voltage phase angle (phase C)

If Ia and Ua are larger than 270 degrees, Ia and Ua are both larger than-360 degrees, and Ia and Ua are both larger than-90 to 270 degrees.

1. an included angle between Ia and Ua is more than or equal to a limit _ angle (an angle threshold), and the included angle between Ia and Ua is less than or equal to the limit _ angle (the angle threshold);

2. the included angle between Ic and Uc is more than or equal to limit _ angle (angle threshold) and the included angle between Ic and Uc is less than or equal to limit _ angle (angle threshold);

the included angle judgment is 'included angle normal', otherwise 'abnormal'.

And finally, temporarily storing the analysis result in the EXCEL.

Step S208, compiling the current analysis result and the wiring analysis result to obtain an analysis calculation result;

step S209, based on the analysis and calculation result, drawing to obtain a hexagonal chart by combining the robot process automation technology;

in the embodiment of the invention, based on the analysis and calculation result, the robot flow automation technology is combined, and drawing is performed according to a preset rule to obtain a hexagonal graph;

in a specific implementation, a hexagonal graph is drawn according to an analysis calculation result, if a metering point is a three-phase three-line, the drawing rule is (Ua, Ub, Uc, Ia, Ib, and Ic are voltages and currents of ABC three phases respectively, and Ucb is an included angle between Ub and Uc):

1, the included angle of Ua Ub Uc is 120 degrees;

the included angle between Ua and Ucb is 90 degrees; the included angle between the Uab and the U is 30 degrees;

taking the included angle between Ia and Ia calculated in the previous step;

4, the included angle between Uc and Ic is the 'included angle between Ic and Uc' calculated in the previous step;

5. the clockwise rotation angle is positive and the counterclockwise rotation angle is negative.

If the metering point is a three-phase four-wire, the drawing rule is as follows:

1. the included angle of Ua Ub Uc is 120 degrees;

2. the included angle between the Ua and the Ia is the 'included angle between the Ia and the Ua' calculated in the previous step;

3. the included angle between Ub and Ib is the 'included angle between Ib and Ub' calculated in the previous step;

4. the included angle between Uc and Ic is the "included angle between Ic and Uc" calculated in the previous step;

According to the rule, a graphics plug-in is written in a turtle library of Python, the plug-in comprises two functions, one function is a three-phase three-line hexagonal diagram, the other function is a three-phase four-line hexagonal diagram, the situation of a metering point is judged through UIBOT, and then the function corresponding to the graphics plug-in is called to draw and store.

And summarizing and storing the metering point table code information, the screened meter reading data, the analysis and calculation result and the hexagonal graph, storing the results in an excel table, and naming the results by 'remote detection + date and time'.

Referring to fig. 3, fig. 3 is a block diagram of an analysis plotting apparatus according to an embodiment of the present invention, including:

the positioning module 301 is configured to position a terminal corresponding to the metering point table code information according to the acquired metering point table code information and a robot process automation technology;

the screening module 302 is configured to screen the meter reading data in the terminal to obtain screened meter reading data;

the analysis module 303 is configured to perform analysis and calculation on the screened meter reading data to obtain an analysis and calculation result;

and the drawing module 304 is used for drawing a hexagonal graph based on the analysis and calculation result and by combining the robot process automation technology.

In an optional embodiment, the apparatus further comprises:

In an alternative embodiment, the positioning module 301 comprises:

In an alternative embodiment, the filtering module 302 includes:

In an alternative embodiment, the analysis module 303 includes:

It is clear to those skilled in the art that, for convenience and brevity of description, the specific working processes of the above-described systems, apparatuses and units may refer to the corresponding processes in the foregoing method embodiments, and are not described herein again.

In the embodiments provided in the present application, it should be understood that the method and apparatus disclosed in the present invention can be implemented in other ways. For example, the above-described apparatus embodiments are merely illustrative, and for example, the division of the units is only one logical division, and other divisions may be realized in practice, for example, a plurality of units or components may be combined or integrated into another system, or some features may be omitted, or not executed. In addition, the shown or discussed mutual coupling or direct coupling or communication connection may be an indirect coupling or communication connection through some interfaces, devices or units, and may be in an electrical, mechanical or other form.

The units described as separate parts may or may not be physically separate, and parts displayed as units may or may not be physical units, may be located in one place, or may be distributed on a plurality of network units. Some or all of the units can be selected according to actual needs to achieve the purpose of the solution of the embodiment.

In addition, functional units in the embodiments of the present invention may be integrated into one processing unit, or each unit may exist alone physically, or two or more units are integrated into one unit. The integrated unit can be realized in a form of hardware, and can also be realized in a form of a software functional unit.

The integrated unit, if implemented in the form of a software functional unit and sold or used as a stand-alone product, may be stored in a computer readable storage medium. Based on such understanding, the technical solution of the present invention may be embodied in the form of a software product, which is stored in a readable storage medium and includes several instructions for causing a computer device (which may be a personal computer, a server, or a network device) to execute all or part of the steps of the method according to the embodiments of the present invention. And the aforementioned readable storage medium includes: a U-disk, a removable hard disk, a Read-Only Memory (ROM), a Random Access Memory (RAM), a magnetic disk or an optical disk, and other various media capable of storing program codes.

The above-mentioned embodiments are only used for illustrating the technical solutions of the present invention, and not for limiting the same; although the present invention has been described in detail with reference to the foregoing embodiments, it will be understood by those of ordinary skill in the art that: the technical solutions described in the foregoing embodiments may still be modified, or some technical features may be equivalently replaced; and such modifications or substitutions do not depart from the spirit and scope of the corresponding technical solutions of the embodiments of the present invention.

Claims

1. An analytical mapping method, comprising:

2. The analysis and drawing method according to claim 1, wherein positioning to a terminal corresponding to the metering point code information according to the acquired metering point code information and a robot process automation technology further comprises:

3. The analysis and mapping method according to claim 1, wherein the positioning to the terminal corresponding to the meter point code information according to the meter point code information comprises:

4. The analytical mapping method according to claim 1, wherein the step of screening the meter reading data in the terminal to obtain the screened meter reading data comprises:

5. The analytical mapping method according to any one of claims 1 to 4, wherein the step of performing analytical calculation on the screened meter reading data to obtain an analytical calculation result comprises:

6. An analysis plotting apparatus comprising:

7. The analytical mapping device according to claim 6, wherein said device further comprises:

8. The analytical mapping device according to claim 6, wherein said positioning module comprises:

9. The analytical mapping device according to claim 6, wherein the screening module comprises:

10. The analytical mapping device according to any of claims 6-9, wherein said analysis module comprises: