CN114936544A

CN114936544A - Data processing method and device, electronic equipment and storage medium

Info

Publication number: CN114936544A
Application number: CN202210683846.4A
Authority: CN
Inventors: 林伟文; 高勇华; 李启奕; 骆光; 刘小华; 陈文宇; 李国君; 龙登强; 郑力嘉; 邱春霞; 陈芳; 朱颂仪; 许振良; 卢国新; 林东锐; 张曼林; 李有鹏; 赵明曦; 刘梦冉; 谢泽坤
Original assignee: Guangdong Power Grid Co Ltd; Huizhou Power Supply Bureau of Guangdong Power Grid Co Ltd
Current assignee: Guangdong Power Grid Co Ltd; Huizhou Power Supply Bureau of Guangdong Power Grid Co Ltd
Priority date: 2022-06-16
Filing date: 2022-06-16
Publication date: 2022-08-23

Abstract

The invention discloses a data processing method, a data processing device, electronic equipment and a storage medium. The method comprises the following steps: acquiring a checking task list and a power data list related to the checking task list; correspondingly filling the inspection task list and the to-be-used electric power data of the to-be-compared electric meter identification matched with the corresponding target electric meter identification into a preset table template to generate a to-be-used table, and determining a target electric power value corresponding to each to-be-filled cell in the to-be-used table; and generating a target spreadsheet based on each target electric meter identification and the target power value in the at least one cell to be filled corresponding to each target electric meter identification. The problem of among the prior art because manual entry, artifical calculation electric power value lead to data processing efficiency low, the accuracy is poor, the result is solved, realize improving data processing efficiency and accuracy, reach the effect that improves electric power data acquisition's efficiency and accuracy.

Description

Data processing method and device, electronic equipment and storage medium

Technical Field

The present invention relates to the field of computer processing technologies, and in particular, to a data processing method and apparatus, an electronic device, and a storage medium.

Background

At present, most enterprises can use electric energy meter remote monitoring system to carry out on-line monitoring and inspection to the electric energy meter, can be with the electric power data manual input to monitored control system who surveys from electric energy meter self, through with electric energy meter electric quantity and burden accuse terminal electric quantity contrast, reachs remote inspection error, can be effective, in time discover whether the on-the-spot electric energy meter goes wrong ageing or wiring mistake scheduling problem based on remote inspection error.

However, the electric energy meter has a large inspection amount, and the method relying on manual single-family inspection, manual entry and manual calculation brings huge workload to workers, and the efficiency of data processing is extremely low. Meanwhile, the problems of wrong recording and missing recording are easily caused by manual single-user input, and the corresponding test result of the electric energy meter is not accurate.

Disclosure of Invention

The invention provides a data processing method, a data processing device, electronic equipment and a storage medium, which are used for improving the data processing efficiency and accuracy and achieving the technical effect of improving the efficiency and accuracy of electric power data acquisition.

According to an aspect of the present invention, there is provided a data processing method, the method including:

acquiring a checking task list and a power data list associated with the checking task list; the inspection task list comprises a plurality of target electric meter identifications and at least one to-be-determined power parameter; the electric power data list comprises a plurality of electric meter identifications to be compared and electric power data to be used corresponding to the electric meter identifications to be compared;

correspondingly filling the inspection task list and the to-be-used electric power data of the to-be-compared electric meter identification matched with the corresponding target electric meter identification into a preset table template to generate a to-be-used table, and determining a target electric power value corresponding to each to-be-filled cell in the to-be-used table; the row data of the cells to be filled correspond to the current target ammeter identification, and the column data of the cells to be filled correspond to the current power parameter to be determined;

when an objective function corresponding to a cell to be filled in the table to be used is received, determining a target power value corresponding to the cell to be filled;

and generating a target spreadsheet based on each target electric meter identification and the target power value in the at least one cell to be filled corresponding to each target electric meter identification.

According to another aspect of the present invention, there is provided a data processing apparatus comprising:

the system comprises a list acquisition module, a list acquisition module and a power data list, wherein the list acquisition module is used for acquiring a checking task list and a power data list related to the checking task list; the inspection task list comprises a plurality of target electric meter identifications and at least one to-be-determined electric power parameter; the electric power data list comprises a plurality of electric meter identifications to be compared and electric power data to be used corresponding to the electric meter identifications to be compared;

the to-be-used table generating module is used for correspondingly filling the inspection task list and the to-be-used power data of the to-be-compared ammeter identification matched with the corresponding target ammeter identification into a preset table template to generate a to-be-used table so as to determine a target power value of each to-be-determined power parameter in the to-be-used table;

the target power value determining module is used for determining a target power value corresponding to a cell to be filled when a target function corresponding to the cell to be filled in the table to be used is received; the row data of the cells to be filled correspond to the current target ammeter identification, and the column data of the cells to be filled correspond to the current power parameter to be determined;

and the target spreadsheet generation module is used for generating a target spreadsheet based on each target electric meter identification and the target power value in the at least one cell to be filled corresponding to each target electric meter identification.

According to another aspect of the present invention, there is provided an electronic apparatus including:

at least one processor; and

a memory communicatively coupled to the at least one processor; wherein, the first and the second end of the pipe are connected with each other,

the memory stores a computer program executable by the at least one processor, the computer program being executable by the at least one processor to enable the at least one processor to perform the data processing method according to any of the embodiments of the invention.

According to another aspect of the present invention, there is provided a computer-readable storage medium storing computer instructions for causing a processor to implement a data processing method according to any one of the embodiments of the present invention when the computer instructions are executed.

According to the technical scheme of the embodiment of the invention, the inspection task list and the electric power data list associated with the inspection task list are obtained; correspondingly filling the inspection task list and the to-be-used power data of the to-be-compared ammeter identification matched with the corresponding target ammeter identification into a preset form template to generate a to-be-used form, and determining a target power value corresponding to each to-be-filled cell in the to-be-used form; when receiving a target function corresponding to a cell to be filled in a table to be used, determining a target power value corresponding to the cell to be filled; the target electronic form is generated based on each target electric meter identification and the target electric power value in at least one cell to be filled corresponding to each target electric meter identification, the problems of low data processing efficiency and poor accuracy caused by manual entry and manual calculation of the electric power value in the prior art are solved, the to-be-used form is generated by importing the inspection task list and the electric power data list associated with the inspection task list into a preset form template, the target electric power value corresponding to each cell to be filled is determined in the to-be-used form through a set function, the data processing efficiency and accuracy are greatly improved, and the target electronic form is generated based on each target electric meter identification and the target electric power value in at least one cell to be filled corresponding to each target electric meter identification so as to import the target electronic form into the system, the automatic data input is realized, and the technical effects of improving the efficiency and accuracy of electric power data acquisition are achieved.

It should be understood that the statements in this section are not intended to identify key or critical features of the embodiments of the present invention, nor are they intended to limit the scope of the invention. Other features of the present invention will become apparent from the following description.

Drawings

In order to more clearly illustrate the technical solutions in the embodiments of the present invention, the drawings needed to be used in the description of the embodiments will be briefly introduced below, and it is obvious that the drawings in the following description are only some embodiments of the present invention, and it is obvious for those skilled in the art to obtain other drawings based on these drawings without creative efforts.

Fig. 1 is a flowchart of a data processing method according to an embodiment of the present invention;

FIG. 2 is a schematic diagram of a table to be used according to an embodiment of the present invention;

FIG. 3 is a schematic diagram of a target spreadsheet provided according to an embodiment of the present invention;

FIG. 4 is a schematic diagram of a target spreadsheet provided in accordance with an embodiment of the present invention;

FIG. 5 is a schematic diagram of a target spreadsheet provided in accordance with an embodiment of the present invention;

fig. 6 is a schematic diagram of a data processing method according to a second embodiment of the present invention;

fig. 7 is a schematic structural diagram of a data processing apparatus according to a third embodiment of the present invention;

fig. 8 is a schematic structural diagram of an electronic device implementing the data processing method according to the embodiment of the present invention.

Detailed Description

In order to make those skilled in the art better understand the technical solutions of the present invention, the technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments 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.

It should be noted that the terms "first," "second," and the like in the description and claims of the present invention and in the drawings described above are used for distinguishing between similar elements and not necessarily for describing a particular sequential or chronological order. It is to be understood that the data so used is interchangeable under appropriate circumstances such that the embodiments of the invention described herein are capable of operation in sequences other than those illustrated or described herein. Moreover, the terms "comprises," "comprising," and "having," and any variations thereof, are intended to cover a non-exclusive inclusion, such that a process, method, system, article, or apparatus that comprises a list of steps or elements is not necessarily limited to those steps or elements expressly listed, but may include other steps or elements not expressly listed or inherent to such process, method, article, or apparatus.

Example one

Fig. 1 is a flowchart of a data processing method according to an embodiment of the present invention, where the embodiment is applicable to a data processing scenario, and the method may be performed by a data processing apparatus, where the data processing apparatus may be implemented in a form of hardware and/or software, and the data processing apparatus may be configured in a computing device. As shown in fig. 1, the method includes:

s110, acquiring a checking task list and a power data list related to the checking task list.

The inspection task list comprises a plurality of target electric meter identifications and at least one to-be-determined power parameter. The target electric meter identifier may be used to represent the uniqueness of the electric energy meter, for example, the user number corresponding to the electric energy meter a may be used as the electric meter identifier of the electric energy meter a, the electric meter number may also be used as the electric meter identifier of the electric energy meter a, or the metering point number corresponding to the electric energy meter a may also be used as the electric meter identifier of the electric energy meter a. The power parameter to be determined, which corresponds to the actual test requirement of the energy meter, can be understood as a test item that needs to be determined, for example, a test person, a test temperature, a power error, a three-phase current sum, and the like. The electric power data list comprises a plurality of electric meter identifications to be compared and electric power data to be used corresponding to the electric meter identifications to be compared. The power data to be used may be understood as power data associated with the electric energy meter, such as voltage, current, power, etc.

In this embodiment, an inspection task list corresponding to the preset inspection requirement may be derived in the operation and maintenance system based on the preset inspection requirement corresponding to the electric energy meter, and an electric power data list corresponding to the inspection task list may be derived from the automation system. The automatic system is used for recording the power data of the electric energy meter. The inspection task list and the power data list can be in Word format or Excel format. For example, the operation and maintenance system may derive the electric meter identifier corresponding to the electric energy meter of the user to be checked, and the corresponding item to be checked (i.e. the electric power parameter to be determined). The automatic system can derive the electric meter identification, current, voltage, wiring mode, electric quantity, active power, reactive power, power factor and the like of all the user electric energy meters. The metering point of each user electric energy meter is unique, and the metering point number can be used as the electric meter identification of the electric energy meter. The list derived from automation may be placed in a designated Users folder. The search and the subsequent data processing are convenient.

And S120, correspondingly filling the inspection task list and the to-be-used power data of the to-be-compared electric meter identification matched with the corresponding target electric meter identification into a preset table template, generating a to-be-used table, and determining a target power value corresponding to each to-be-filled cell in the to-be-used table.

For example, if the power parameter to be determined is a tester, the corresponding target power value may be a name of the tester or a work number of the tester. If the power parameter to be determined is the power error, the corresponding target power value may be a value of the power error. In practical application, the cells with the current target electric meter identifier and the current to-be-determined electric power parameter in line and row interaction can be used as the cells to be filled, so that the target electric power value corresponding to the current target electric meter identifier and the current to-be-determined electric power parameter is filled into the corresponding cells to be filled.

In this embodiment, the data in the inspection task list and the power data list may be imported into a preset table template, because the target electricity meter identifier may be the same as or different from the electricity meter identifier to be compared, and in order to ensure regularity of the data, the power data to be used of the electricity meter identifier to be compared, which is matched with the corresponding target electricity meter identifier, may be exported into the preset table template The power parameter to be determined, and then an Excel table can be generated as a table to be used, so as to process each target electric meter identification, the corresponding power parameter to be determined and the corresponding power data to be used in the table to be used, and determine the target power value corresponding to each cell to be filled.

It should be noted that, in the table to be used, corresponding metering point numbers are filled in all cells on the column where the target electricity meter identifier is located, corresponding power data are filled in all cells on the column where the power data to be used is located, data in the cells on the column where the power parameter to be determined is empty, and a corresponding power value needs to be filled in subsequent data processing.

And S130, when the objective function corresponding to the cell to be filled in the table to be used is received, determining the target power value corresponding to the cell to be filled.

In this embodiment, when the cell to be filled associated with the row where the current target electric meter identifier is located and the column where the current electric parameter to be determined is located is selected, a user may input an electric power item to be filled in to calculate the current electric parameter to be determined in a formula edit box on a table to be used, and construct an objective function, where if the current electric parameter to be determined is a three-phase voltage sum, the current target electric meter identifier is located in a third row in a first column in the table, that is, a3, the filled electric power item may be an a-phase voltage, a B-phase voltage, and a C-phase voltage in the third row, and the corresponding objective function may be an a-phase voltage 3+ B-phase voltage 3+ C-phase voltage 3. The target power value may be filled into the cell to be filled based on the target function determining the target power value at the cell to be filled where the current power parameter to be determined corresponds to the current target meter identification.

It should be noted that the power parameters to be determined include three types of power parameters, i.e., a power parameter to be extracted, a power parameter to be calculated, and a power parameter to be filled, where the power parameter to be extracted may be understood as a power parameter that can directly extract a corresponding power value in the table to be used, i.e., a target power value of the power parameter to be extracted already exists in the table to be used, such as an a-phase voltage, an a-phase current, and the like. The power parameter to be calculated may be understood as a power parameter for which a function is required to calculate the power value, that is, a target power value of the power parameter to be calculated does not exist in the table to be used, and function calculation is required, such as an electric quantity error, a voltage-current included angle, a three-phase voltage sum, and the like. The power parameter to be filled may be understood as that the respective power value may not be directly extracted in the table to be used, the user is required to edit the power parameter of the input power value, i.e. the target power value of the power parameter to be filled is not present in the table to be used, and an edit input is required, such as an inspector, inspection temperature, etc.

Optionally, if the to-be-determined power parameter includes a to-be-extracted power parameter, when receiving the target function corresponding to the to-be-filled cell in the to-be-used table, the implementation manner of determining the target power value corresponding to the to-be-filled cell may be: associating the preset search function with the cell to be filled in the column where the current power parameter to be extracted is located, so as to process the preset search function in the control to be edited corresponding to the cell to be filled, and obtaining a target function; when the determination control corresponding to the trigger target function is detected, the current power parameter to be extracted and the target power value corresponding to the cell to be filled are called from the table to be used.

The preset search function may be a longitudinal search function in Excel, such as a VLOOKUP function, a VLOOKUP (lookup _ value, table _ array, col _ index _ num, [ range _ lookup ]), and lookup _ value refers to a value to be searched, such as a numeric value, a reference, or a text string; table _ array refers to an area to be searched, such as a data table area; col _ index _ num refers to the number of columns of the returned data in the search area, such as a positive integer; range _ lookup refers to approximate/exact matches, such as FALSE (0, space or not filled (but to have ',' placeholder))/TRUE (1 or not filled (no comma placeholder)).

In this embodiment, when a certain cell to be filled in the column where the current power parameter to be extracted is located is selected, the preset lookup function may be input in the formula edit box in the table to be used, the line data corresponding to the cell to be filled is a certain target electric meter identifier, and is treated as the current target electric meter identifier, and at this time, the preset lookup function may be considered to be associated with the cell to be filled. The search items corresponding to the current target electric meter identifier and the current to-be-extracted electric power parameter may be filled into the preset search function, the filled preset search function may be used as the target function, at this time, it may be considered that the determination control corresponding to the target function is triggered, the target electric power value of the current to-be-extracted electric power parameter corresponding to the current target electric meter identifier is called from the to-be-used table, and the target electric power value is filled into the to-be-filled cell.

Illustratively, the preset search function is a VLOOKUP function, the L column a phase voltage in the table to be used is searched through VLOOKUP function matching, and the a phase voltage value can be automatically generated and filled into the corresponding cell to be filled by setting the function ═ VLOOKUP (C2, 'C: \ Users \ voltage: [ xlsxx ] excel' | $ a: $ D,2, FALSE); b phase voltage values of M columns in a table to be used are searched, a function (VLOOKUP) (C2, C: \ Users \ voltage (xlsx) excel'! $ A: $ D,3, FALSE) is set, and the B phase voltage values can be automatically generated; the method comprises the steps of searching N columns of C-phase voltages in a table to be used, setting a function (C2, 'C: \users \ [ voltage. xlsxx ] excel' | A: $ D,4, FALSE), automatically generating C-phase voltage values, and filling the C-phase voltage values into corresponding cells to be filled, wherein 'C: \users \ [ voltage. xlsxx ] excel' is an address position to be stored, and referring to FIG. 3. Correspondingly, the current values of the O column, the P column, the B phase, the Q column, the C phase, the S column, the W column, the A phase, the X column, the B phase, the Y column, the C phase, the AA column, the A phase, the AB column, the AC column, the C phase, the AE power factor and the like of the electric energy meter to be used can be automatically returned by the same VLOOKUP function setting method.

Optionally, if the to-be-determined power parameter includes a to-be-calculated power parameter, when the target function corresponding to the to-be-filled cell in the to-be-used table is received, the implementation manner of determining the target power value corresponding to the to-be-filled cell may be: associating a preset calculation function with a cell to be filled in a column where the current power parameter to be calculated is located, so as to process the preset calculation function in a control to be edited corresponding to the cell to be filled, and obtaining a target function; and when the determination control corresponding to the target function is detected to be triggered, determining a target power value corresponding to the cell to be filled based on each power item to be used in the target function.

The current power parameter to be calculated comprises a reactive power sum, an active power sum, a voltage error or a voltage-current included angle. The power to be used item corresponds to power data to be used associated with the current power parameter to be calculated, and the power data to be used corresponds to the current target electric meter identification. For example, if the current power parameter to be calculated is the sum of reactive powers and the current target meter is identified as 111, the power items to be used may be a-phase reactive power, B-phase reactive power and C-phase reactive power, and the power data to be used corresponds to 111 power data. The preset calculation function corresponds to the power parameter to be calculated, for example, if the power parameter to be calculated is the current-voltage included angle, the corresponding preset calculation function is ACOS. And if the power parameter to be calculated is the SUM of the reactive powers, the corresponding preset calculation function is SUM.

In this embodiment, when a certain cell to be filled in the column where the current power parameter to be calculated is located is selected, a preset calculation function corresponding to the current power parameter to be calculated may be input in a formula edit box in the table to be used, and the line data corresponding to the cell to be filled is a certain target electric meter identifier and is treated as the current target electric meter identifier, at this time, it may be considered that the preset calculation function is associated with the cell to be filled. Each to-be-used power item corresponding to the current target electric meter identifier and the current to-be-extracted power parameter may be filled into a preset lookup function, the filled preset lookup function may be used as a target function, at this time, it may be considered that a determination control corresponding to the target function is triggered, then, power data corresponding to each to-be-used power item is searched from a to-be-used table, a target power value is obtained through calculation, and the target power value is filled into a to-be-filled cell.

For example, in the table to be used, Z column total active power, which is equal to the SUM of three-phase active power, may be set as a function SUM (W1+ X1+ Y1), W1 may be a-phase active power, X1 may be B-phase active power, and Y1 may be C-phase active power, and a total active power value corresponding to the SUM of active power, that is, a target power value, may be automatically generated; the AD column in the table to be used totals the reactive power, which is equal to the SUM of the three-phase reactive powers, the function SUM (AA1+ AB1+ AC1) may be set, and the total reactive power value, i.e., the target power value, may be automatically generated; in the table to be used, the function of the included angle between the phase-A current and the phase-A voltage in the T column is set to be ACOS (W1/O1/L1), W1 is the value of the active power of the phase-A, O1 is the value of the current of the phase-A, L1 is the value of the phase-A voltage, and the included angle between the phase-A current and the phase-A voltage can be automatically generated; in the U column of the voltage included angle of the B-phase current in the table to be used, setting a function ACOS (X1/P1/M1), the voltage included angle value of the B-phase current can be automatically generated; in the V column C phase current voltage included angle column in the table to be used, setting a function of ACOS (Y1/Q1/N1), the C phase current voltage included angle value can be automatically generated; by a VLOOKUP function setting method, the table code of the current month 0 of the F-column electric energy meter, the table code of the last month 0 of the G-column electric energy meter, the table code of the current month 0 of the H-column terminal and the table code of the last month 0 of the I-column terminal can be automatically returned. Further, in the J columns of the electric quantity error values, the remote error values may be calculated by a table setting formula, where the setting function is (((F1-G1-H1+ I1)/(H1-I1)) × 100%), F1 is the table code at the time of the month 0 of the electric energy meter, G1 is the table code at the time of the month 0 of the electric energy meter, H1 is the table code at the time of the month 0 of the terminal, and I1 is the table code at the time of the month 0 of the terminal, and the remote error values, that is, the target electric power values may be automatically generated and filled into the corresponding cells to be filled, so as to generate the table shown in fig. 4.

Optionally, if the to-be-determined power parameter includes a to-be-filled power parameter, when the target function corresponding to the to-be-filled cell in the to-be-used table is received, the implementation manner of determining the target power value corresponding to the to-be-filled cell may be: and associating the user editing text with the cells to be filled in the column where the current power parameter to be filled is located to obtain a target editing text which is used as a target power value corresponding to the cells to be filled, and filling the target editing text into the cells in the same column when detecting that the automatic filling control of the cells in the same column associated with the cells to be filled is triggered.

In this embodiment, when a certain cell to be filled in the column where the current power parameter to be filled is located is selected, a user edit text may be input into the cell to be filled, where the line data corresponding to the cell to be filled is a certain target electric meter identifier and is processed as the current target electric meter identifier, at this time, it may be considered that the user edit text is associated with the cell to be filled, and the user edit text may be used as the current target electric meter identifier and the target power value corresponding to the current power parameter to be filled. It should be noted that when the automatic filling control triggering the cells in the same column associated with the cells to be filled is detected, the target edit text can be filled into the cells in the same column, so as to implement the function of batch input of repeated information. For example, referring to fig. 5, repeated information such as inspection personnel, inspection temperature, humidity, inspection instrument number, frequency, power direction, and the like is input into the form in batch in a Ctrl + D manner, the form is produced in batch into a large number of types of indispensable items, and the prepared form can be imported into an operation and maintenance system to complete automatic batch input.

It should be further noted that, if the power parameter to be determined is the power parameter to be extracted or the power parameter to be calculated, the automatic filling function may also be utilized, and based on the objective function of the current cell to be filled, the objective function corresponding to the cell in the same column as the current cell to be filled is automatically obtained, so as to implement fast calculation of information and improve the efficiency of data processing.

Optionally, the method further includes: when detecting that an automatic filling control triggering cells in the same column associated with the cells to be filled is triggered, determining a function to be used corresponding to the cells in the same column based on a target function of the cells to be filled; a target power value corresponding to the cells in the same column is determined based on the function to be used.

The cells in the same row and the cells to be filled are positioned in the same row.

In this embodiment, the automatic filling control may be triggered when a cell in the same column associated with the cell to be filled is selected, at this time, a function to be used corresponding to the cell in the same column may be determined based on a target function of the cell to be filled, for example, an a-phase current-voltage included angle corresponding to a target meter identifier 111 in a table to be used is set as ACOS (W1/O1/L1), W1 is an a-phase active power value of 111, O1 is an a-phase current value of 111, and L1 is an a-phase voltage value of 111, and an a-phase current-voltage included angle value of 111 may be automatically generated; in the phase-a current-voltage included angle corresponding to the target meter identifier 112 in the T column, based on the automatic filling function, the function ACOS (W2/O2/L2) used this time may be determined based on the ACOS (W1/O1/L1), W2 is the phase-a active power value of 112, O2 is the phase-a current value of 112, L2 is the phase-a voltage value of 112, and the phase-a current-voltage included angle value of 112 may be automatically generated.

And S140, generating a target spreadsheet according to each target electric meter identification and the target power value in the at least one cell to be filled corresponding to each target electric meter identification.

In this embodiment, a table formed by each target electric meter identifier and the target power value in the at least one cell to be filled corresponding to each target electric meter identifier may be used as a target electronic table, and the target electronic table may be imported into the operation and maintenance system, so as to implement an automatic data entry function, and greatly improve the efficiency of data entry.

It should be noted that, in order to facilitate the analysis and judgment of whether the user electric energy meter has a fault, when the target spreadsheet is generated based on each target electric energy meter identifier and the target power value in the at least one cell to be filled corresponding to each target electric energy meter identifier, the fault user information may be displayed differently based on the target power value information, so as to improve the detection efficiency and find out the abnormality in time.

Optionally, generating a target spreadsheet based on each target electricity meter identifier and the target power value in the at least one cell to be filled corresponding to each target electricity meter identifier includes: and generating a target spreadsheet based on each target electric meter identification and the target electric power value in at least one cell to be filled corresponding to each target electric meter identification, and displaying the target electric power value larger than a preset electric power threshold value and the corresponding target electric meter identification in the target spreadsheet in a distinguishing manner.

In this embodiment, when the target spreadsheet is generated based on each target electricity meter identifier and the target power value in the at least one cell to be filled corresponding to each target electricity meter identifier, the target power value greater than the preset power threshold may be used as the abnormal data, and the abnormal data and the corresponding target electricity meter identifier may be displayed in the target spreadsheet in a distinguishing manner, for example, the abnormal data greater than the preset power threshold may be marked with red, bold, or bold in a square, etc. in the cell by highlighting the cell rule, so that the displayed abnormal data may be further analyzed separately to determine the verification result.

According to the technical scheme of the embodiment, the inspection task list and the electric power data list related to the inspection task list are obtained; correspondingly filling the inspection task list and the to-be-used power data of the to-be-compared ammeter identification matched with the corresponding target ammeter identification into a preset form template to generate a to-be-used form, and determining a target power value corresponding to each to-be-filled cell in the to-be-used form; when receiving a target function corresponding to a cell to be filled in a table to be used, determining a target power value corresponding to the cell to be filled; the target electronic form is generated based on each target electric meter identification and the target electric power value in at least one cell to be filled corresponding to each target electric meter identification, the problems of low data processing efficiency and poor accuracy caused by manual entry and manual calculation of the electric power value in the prior art are solved, the to-be-used form is generated by importing the inspection task list and the electric power data list associated with the inspection task list into a preset form template, the target electric power value corresponding to each cell to be filled is determined in the to-be-used form through a set function, the data processing efficiency and accuracy are greatly improved, and the target electronic form is generated based on each target electric meter identification and the target electric power value in at least one cell to be filled corresponding to each target electric meter identification so as to import the target electronic form into the system, the automatic data input is realized, and the technical effects of improving the efficiency and accuracy of electric power data acquisition are achieved.

Example two

As an alternative embodiment of the above embodiment, in order to make the technical solutions of the embodiments of the present invention further clear to those skilled in the art, a specific application scenario example is given. Specifically, the following details can be referred to.

Referring to fig. 6, in the technical scheme, a table to be used can be generated by importing a required inspection task list and an electric power data list, the table to be used is set through a series of formulas and functions, inspection work indispensable items such as a current value, a voltage value, a wiring mode, an inspection error, active power, reactive power, a power factor, a current-voltage included angle, an electric quantity error and the like required by inspection are automatically produced in batches, and a target electric power value larger than a preset electric power threshold value and a corresponding target electric meter identifier can be automatically distinguished and displayed. For example, the operation and maintenance system derives the electric meter identifier corresponding to the electric energy meter of the user to be checked and the corresponding item to be checked (i.e. the electric power parameter to be determined). The metering automation system derives the electric power data lists of the electric energy meters of all Users, such as electric meter identification, current, voltage, wiring mode, electric quantity, active power, reactive power, power factor and the like, and the automatically derived lists can be put into a specified Users folder. The A-phase voltage in the L column in the table to be used can be searched through VLOOKUP function matching, the function is set to be VLOOKUP (C2, 'C: \ Users \ voltage:. xlsxx ] excel'! $ A: $ D,2, FALSE), and at the moment, the A-phase voltage value can be automatically generated and filled into the corresponding cell to be filled; b phase voltage values of M columns in a table to be used are searched, a function (C2, C: \Users \ [ voltage, xlsxx ] excel' | A: $ D,3, FALSE) is set, and the B phase voltage values can be automatically generated; the C-phase voltage values can be automatically generated and filled into the corresponding cells to be filled by searching the N columns of C-phase voltages in the table to be used, setting the function ═ VLOOKUP (C2, 'C: \users \ [ voltage: [ xlsx ] excel' | $ a: $ D,4, FALSE). Correspondingly, the electric energy meter O column A phase current value, P column B phase current value, Q column C phase current value, S column wiring mode, W column A phase active power value, X column B phase active power value, Y column C phase active power value, AA column A phase reactive power value, AB column B phase reactive power value, AC column C phase reactive power value, AE power factor value and the like in the table to be used can be automatically returned through the same VLOOKUP function setting method. The total active power is listed in column Z in the table to be used, the total active power is equal to the SUM of the three-phase active powers, a function ═ SUM (W1+ X1+ Y1) can be set, W1 can be phase a active power, X1 is phase B active power, Y1 is phase C active power, and a total active power value corresponding to the SUM of the active powers, that is, a target power value, can be automatically generated; the AD column in the table to be used totals the reactive power, which is equal to the SUM of the three-phase reactive powers, the function SUM (AA1+ AB1+ AC1) may be set, and the total reactive power value, i.e., the target power value, may be automatically generated; setting a function (ACOS (W1/O1/L1) in T columns of A-phase current-voltage included angle columns in a table to be used, wherein W1 is an A-phase active power value, O1 is an A-phase current value, and L1 is an A-phase voltage value, and the A-phase current-voltage included angle value can be automatically generated; in the U column of the voltage included angle of the B-phase current in the table to be used, setting a function ACOS (X1/P1/M1), the voltage included angle value of the B-phase current can be automatically generated; in the V column C phase current voltage included angle column in the table to be used, setting a function of ACOS (Y1/Q1/N1), the C phase current voltage included angle value can be automatically generated; by a VLOOKUP function setting method, the table code of the current month 0 of the F-column electric energy meter, the table code of the last month 0 of the G-column electric energy meter, the table code of the current month 0 of the H-column terminal and the table code of the last month 0 of the I-column terminal can be automatically returned. Further, in the J columns of the electric quantity error values, the remote error values may be calculated by using a table setting formula, where the setting function is (((F1-G1-H1+ I1)/(H1-I1)) × 100%), F1 is the table code at 0 month of the electric energy meter, G1 is the table code at 0 month of the electric energy meter, H1 is the table code at 0 month of the terminal, and I1 is the table code at 0 month of the terminal, and the remote error values, i.e., the target electric power values, may be automatically generated and filled into the corresponding cells to be filled. Repeated information such as inspection personnel, inspection temperature, humidity, inspection instrument numbers, frequency, power direction and the like can be input into the form in batches in a Ctrl + D mode, the form can be produced into various indispensable items in batches, and the prepared form can be guided into an operation and maintenance system to finish automatic batch input. The abnormal data larger than the preset power threshold value can be marked with red, bolded in font or bolded in square frame and the like in the cell by highlighting the cell rule, so that the abnormal data which are displayed in a distinguishing way can be further analyzed independently, and the inspection result can be determined. Furthermore, a target electronic form can be obtained, the target electronic form can be imported into the operation and maintenance system, the automatic data entry function is realized, the data processing and entry efficiency is greatly improved, a large amount of repeated work is reduced, and the risk of error entry and missing entry is avoided.

EXAMPLE III

Fig. 7 is a schematic structural diagram of a data processing apparatus according to a third embodiment of the present invention. As shown in fig. 7, the apparatus includes: list acquisition module 710, table to use generation module 720, target power value determination module 730, and target spreadsheet generation module 740.

The list acquiring module 710 is configured to acquire a checking task list and a power data list associated with the checking task list; the inspection task list comprises a plurality of target electric meter identifications and at least one to-be-determined power parameter; the electric power data list comprises a plurality of electric meter identifications to be compared and electric power data to be used corresponding to the electric meter identifications to be compared; a to-be-used table generating module 720, configured to correspondingly fill the inspection task list and the to-be-used power data of the to-be-compared electric meter identifier matched with the corresponding target electric meter identifier into a preset table template, so as to generate a to-be-used table, and determine a target power value of each to-be-determined power parameter in the to-be-used table; a target power value determining module 730, configured to determine a target power value corresponding to a cell to be filled when an objective function corresponding to the cell to be filled in the table to be used is received; the row data of the cells to be filled correspond to the current target ammeter identification, and the column data of the cells to be filled correspond to the current power parameter to be determined; the target spreadsheet generation module 740 is configured to generate a target spreadsheet based on each target electricity meter identifier and the target power value in the at least one cell to be filled corresponding to each target electricity meter identifier.

According to the technical scheme of the embodiment, the inspection task list and the electric power data list related to the inspection task list are obtained; correspondingly filling the inspection task list and the to-be-used electric power data of the to-be-compared electric meter identification matched with the corresponding target electric meter identification into a preset table template to generate a to-be-used table, and determining a target electric power value corresponding to each to-be-filled cell in the to-be-used table; when receiving a target function corresponding to a cell to be filled in a table to be used, determining a target power value corresponding to the cell to be filled; the target electronic form is generated based on each target electric meter identification and the target electric power value in at least one cell to be filled corresponding to each target electric meter identification, the problems of low data processing efficiency and poor accuracy caused by manual entry and manual calculation of the electric power value in the prior art are solved, the to-be-used form is generated by importing the inspection task list and the electric power data list associated with the inspection task list into a preset form template, the target electric power value corresponding to each cell to be filled is determined in the to-be-used form through a set function, the data processing efficiency and accuracy are greatly improved, and the target electronic form is generated based on each target electric meter identification and the target electric power value in at least one cell to be filled corresponding to each target electric meter identification so as to import the target electronic form into the system, the automatic data input is realized, and the technical effects of improving the efficiency and accuracy of electric power data acquisition are achieved.

On the basis of the above device, the power parameter to be determined includes a power parameter to be extracted, and optionally, the target power value determining module 730 includes a target power value determining first unit, where the target power value determining first unit includes an objective function determining subunit and a target power value determining subunit.

The target function determining subunit is used for associating a preset search function with a cell to be filled in a column where the current power parameter to be extracted is located, so as to process the preset search function in a control to be edited corresponding to the cell to be filled, and obtain a target function;

and the target power value determining subunit is used for retrieving the current power parameter to be extracted and the target power value corresponding to the cell to be filled from the table to be used when the determination control corresponding to the target function is detected to be triggered.

Based on the above apparatus, the power parameter to be determined includes a power parameter to be calculated, and optionally, the target power value determining module 730 includes a target power value determining second unit, where the target power value determining second unit includes a target function determining second subunit and a target power value determining second subunit.

The target function determination second subunit is used for associating a preset calculation function with a cell to be filled in a column where the current power parameter to be calculated is located, so that the preset calculation function is processed in a control to be edited corresponding to the cell to be filled, and a target function is obtained;

the target power value determination second subunit is used for determining a target power value corresponding to the cell to be filled based on each power item to be used in the target function when the determination control corresponding to the target function is triggered is detected; the current power parameter to be calculated comprises the reactive power sum, the active power sum, the voltage error or the voltage-current included angle; the power to be used item corresponds to power to be used data associated with the current power parameter to be calculated, and the power to be used data corresponds to the current target electric meter identification.

Based on the above apparatus, the power parameter to be determined includes a power parameter to be filled, and optionally, the target power value determining module 730 includes a third target power value determining unit, where the third target power value determining unit includes a third target function determining subunit and a third target power value determining subunit.

And the target power value determination third subunit is used for associating the user editing text with the cell to be filled in the column of the current power parameter to be filled to obtain a target editing text which is used as the target power value corresponding to the cell to be filled, so that when the condition that the automatic filling control of the cell in the same column associated with the cell to be filled is triggered is detected, the target editing text is filled in the cell in the same column.

On the basis of the above device, optionally, the target power value determining module 730 includes an automatic filling unit, wherein the automatic filling unit includes a function-to-be-used determining subunit and a target power value determining fourth subunit.

The to-be-used function determining subunit is used for determining a to-be-used function corresponding to the cells in the same column based on the target function of the cells to be filled when detecting that the automatic filling control of the cells in the same column associated with the cells to be filled is triggered;

a target power value determination fourth subunit for determining a target power value corresponding to the column-wise cell based on the to-be-used function.

On the basis of the above device, optionally, the target spreadsheet generation module 740 includes a target power value display unit.

And the target power value display unit is used for generating a target spreadsheet based on each target electric meter identification and the target power value in at least one cell to be filled corresponding to each target electric meter identification, and displaying the target power value larger than a preset power threshold value and the corresponding target electric meter identification in the target spreadsheet in a distinguishing way.

The data processing device provided by the embodiment of the invention can execute the data processing method provided by any embodiment of the invention, and has corresponding functional modules and beneficial effects of the execution method.

EXAMPLE five

Fig. 8 is a schematic structural diagram of an electronic device implementing the data processing method according to the embodiment of the present invention. Electronic devices are intended to represent various forms of digital computers, such as laptops, desktops, workstations, personal digital assistants, servers, blade servers, mainframes, and other appropriate computers. The electronic device may also represent various forms of mobile devices, such as personal digital assistants, cellular phones, smart phones, wearable devices (e.g., helmets, glasses, watches, etc.), and other similar computing devices. The components shown herein, their connections and relationships, and their functions, are meant to be exemplary only, and are not meant to limit implementations of the inventions described and/or claimed herein.

As shown in fig. 8, the electronic device 10 includes at least one processor 11, and a memory communicatively connected to the at least one processor 11, such as a Read Only Memory (ROM)12, a Random Access Memory (RAM)13, and the like, wherein the memory stores a computer program executable by the at least one processor, and the processor 11 may perform various appropriate actions and processes according to the computer program stored in the Read Only Memory (ROM)12 or the computer program loaded from the storage unit 18 into the Random Access Memory (RAM) 13. In the RAM 13, various programs and data necessary for the operation of the electronic apparatus 10 can also be stored. The processor 11, the ROM 12, and the RAM 13 are connected to each other via a bus 14. An input/output (I/O) interface 15 is also connected to bus 14.

A number of components in the electronic device 10 are connected to the I/O interface 15, including: an input unit 16 such as a keyboard, a mouse, or the like; an output unit 17 such as various types of displays, speakers, and the like; a storage unit 18 such as a magnetic disk, optical disk, or the like; and a communication unit 19 such as a network card, modem, wireless communication transceiver, etc. The communication unit 19 allows the electronic device 10 to exchange information/data with other devices via a computer network, such as the internet, and/or various telecommunication networks.

The processor 11 may be a variety of general and/or special purpose processing components having processing and computing capabilities. Some examples of processor 11 include, but are not limited to, a Central Processing Unit (CPU), a Graphics Processing Unit (GPU), various specialized Artificial Intelligence (AI) computing chips, various processors running machine learning model algorithms, a Digital Signal Processor (DSP), and any suitable processor, controller, microcontroller, or the like. The processor 11 performs the various methods and processes described above, such as data processing methods.

In some embodiments, the data processing method may be implemented as a computer program tangibly embodied in a computer-readable storage medium, such as storage unit 18. In some embodiments, part or all of the computer program may be loaded and/or installed onto the electronic device 10 via the ROM 12 and/or the communication unit 19. When the computer program is loaded into the RAM 13 and executed by the processor 11, one or more steps of the data processing method described above may be performed. Alternatively, in other embodiments, the processor 11 may be configured to perform the data processing method by any other suitable means (e.g. by means of firmware).

Various implementations of the systems and techniques described here above may be implemented in digital electronic circuitry, integrated circuitry, Field Programmable Gate Arrays (FPGAs), Application Specific Integrated Circuits (ASICs), Application Specific Standard Products (ASSPs), system on a chip (SOCs), load programmable logic devices (CPLDs), computer hardware, firmware, software, and/or combinations thereof. These various embodiments may include: implemented in one or more computer programs that are executable and/or interpretable on a programmable system including at least one programmable processor, which may be special or general purpose, receiving data and instructions from, and transmitting data and instructions to, a storage system, at least one input device, and at least one output device.

A computer program for implementing the methods of the present invention may be written in any combination of one or more programming languages. These computer programs may be provided to a processor of a general purpose computer, special purpose computer, or other programmable data processing apparatus, such that the computer programs, when executed by the processor, cause the functions/acts specified in the flowchart and/or block diagram block or blocks to be performed. A computer program can execute entirely on a machine, partly on a machine, as a stand-alone software package partly on a machine and partly on a remote machine or entirely on a remote machine or server.

In the context of the present invention, a computer-readable storage medium may be a tangible medium that can contain, or store a computer program for use by or in connection with an instruction execution system, apparatus, or device. A computer readable storage medium may include, but is not limited to, an electronic, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or any suitable combination of the foregoing. Alternatively, the computer readable storage medium may be a machine readable signal medium. More specific examples of a machine-readable storage medium would include an electrical connection based on one or more wires, a portable computer diskette, a hard disk, a Random Access Memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disc read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing.

To provide for interaction with a user, the systems and techniques described here can be implemented on an electronic device having: a display device (e.g., a CRT (cathode ray tube) or LCD (liquid crystal display) monitor) for displaying information to a user; and a keyboard and a pointing device (e.g., a mouse or a trackball) by which a user may provide input to the electronic device. Other kinds of devices may also be used to provide for interaction with a user; for example, feedback provided to the user can be any form of sensory feedback (e.g., visual feedback, auditory feedback, or tactile feedback); and input from the user may be received in any form, including acoustic, speech, or tactile input.

The systems and techniques described here can be implemented in a computing system that includes a back-end component (e.g., as a data server), or that includes a middleware component (e.g., an application server), or that includes a front-end component (e.g., a user computer having a graphical user interface or a web browser through which a user can interact with an implementation of the systems and techniques described here), or any combination of such back-end, middleware, or front-end components. The components of the system can be interconnected by any form or medium of digital data communication (e.g., a communication network). Examples of communication networks include: local Area Networks (LANs), Wide Area Networks (WANs), blockchain networks, and the Internet.

The computing system may include clients and servers. A client and server are generally remote from each other and typically interact through a communication network. The relationship of client and server arises by virtue of computer programs running on the respective computers and having a client-server relationship to each other. The server can be a cloud server, also called a cloud computing server or a cloud host, and is a host product in a cloud computing service system, so that the defects of high management difficulty and weak service expansibility in the traditional physical host and VPS service are overcome.

It should be understood that various forms of the flows shown above, reordering, adding or deleting steps, may be used. For example, the steps described in the present invention may be executed in parallel, sequentially, or in different orders, and are not limited herein as long as the desired results of the technical solution of the present invention can be achieved.

The above-described embodiments should not be construed as limiting the scope of the invention. It should be understood by those skilled in the art that various modifications, combinations, sub-combinations and substitutions may be made in accordance with design requirements and other factors. Any modification, equivalent replacement, and improvement made within the spirit and principle of the present invention should be included in the protection scope of the present invention.

Claims

1. A data processing method, comprising:

2. The method according to claim 1, wherein the power parameter to be determined comprises a power parameter to be extracted, and the determining a target power value corresponding to a cell to be filled when receiving an objective function corresponding to the cell to be filled in the table to be used comprises:

associating a preset search function with a cell to be filled in a column where a current power parameter to be extracted is located, so as to process the preset search function in a control to be edited corresponding to the cell to be filled, and obtain a target function;

when a determination control corresponding to the target function is triggered, the current power parameter to be extracted and the target power value corresponding to the cell to be filled are called from the table to be used.

3. The method according to claim 1, wherein the power parameter to be determined comprises a power parameter to be calculated, and the determining a target power value corresponding to a cell to be filled when receiving an objective function corresponding to the cell to be filled in the table to be used comprises:

associating a preset calculation function with a cell to be filled in a column where a current electric power parameter to be calculated is located, so as to process the preset calculation function in a control to be edited corresponding to the cell to be filled, and obtain a target function;

when a determination control corresponding to the target function is triggered, determining a target power value corresponding to the cell to be filled based on each power item to be used in the target function;

the current power parameter to be calculated comprises a reactive power sum, an active power sum, a voltage error or a voltage-current included angle; the power to be used item corresponds to power to be used data associated with the current power parameter to be calculated, and the power to be used data corresponds to the current target electric meter identification.

4. The method according to claim 1, wherein the power parameter to be determined comprises a power parameter to be filled, and the determining a target power value corresponding to a cell to be filled when receiving an objective function corresponding to the cell to be filled in the table to be used comprises:

associating a user editing text with a cell to be filled in a column where a current power parameter to be filled is located to obtain a target editing text which is used as a target power value corresponding to the cell to be filled, and filling the target editing text into the cell in the same column when detecting that an automatic filling control triggering the cell in the same column associated with the cell to be filled is triggered.

5. The method of claim 2 or 3, further comprising:

when detecting an automatic filling control triggering the cells in the same column associated with the cells to be filled, determining a function to be used corresponding to the cells in the same column based on a target function of the cells to be filled;

determining a target power value corresponding to the column of cells based on the function to be used.

6. The method of claim 1, wherein generating a target spreadsheet based on each target meter identification and the target power value in the at least one cell to be populated corresponding to each target meter identification comprises:

and generating a target spreadsheet based on each target ammeter identification and the target power value in at least one cell to be filled corresponding to each target ammeter identification, and displaying the target power value larger than a preset power threshold value and the corresponding target ammeter identification in the target spreadsheet in a distinguishing manner.

7. A data processing apparatus, comprising:

the system comprises a list acquisition module, a list acquisition module and a power data list, wherein the list acquisition module is used for acquiring a checking task list and a power data list related to the checking task list; the inspection task list comprises a plurality of target electric meter identifications and at least one to-be-determined power parameter; the electric power data list comprises a plurality of electric meter identifications to be compared and electric power data to be used corresponding to the electric meter identifications to be compared;

and the target spreadsheet generation module is used for generating a target spreadsheet based on each target electric meter identification and the target power value in at least one cell to be filled corresponding to each target electric meter identification.

8. The apparatus of claim 7, wherein the target spreadsheet generation module comprises:

and the target power value display unit is used for generating a target spreadsheet based on each target electric meter identification and the target power value in at least one cell to be filled corresponding to each target electric meter identification, and displaying the target power value larger than a preset power threshold value and the corresponding target electric meter identification in the target spreadsheet in a distinguishing manner.

9. An electronic device, characterized in that the electronic device comprises:

at least one processor; and

the memory stores a computer program executable by the at least one processor, the computer program being executable by the at least one processor to enable the at least one processor to perform the data processing method of any one of claims 1-6.

10. A computer-readable storage medium, characterized in that it stores computer instructions for causing a processor to implement the data processing method of any of claims 1-6 when executed.