CN118195554A - Main management method and system for basic data of power grid - Google Patents
Main management method and system for basic data of power grid Download PDFInfo
- Publication number
- CN118195554A CN118195554A CN202410599426.7A CN202410599426A CN118195554A CN 118195554 A CN118195554 A CN 118195554A CN 202410599426 A CN202410599426 A CN 202410599426A CN 118195554 A CN118195554 A CN 118195554A
- Authority
- CN
- China
- Prior art keywords
- cells
- auditing
- color
- data
- statistical table
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
- 238000007726 management method Methods 0.000 title claims abstract description 9
- 238000000034 method Methods 0.000 claims abstract description 28
- 238000012545 processing Methods 0.000 claims abstract description 18
- 230000006872 improvement Effects 0.000 claims abstract description 5
- 238000012423 maintenance Methods 0.000 claims description 14
- 238000012795 verification Methods 0.000 claims description 13
- 230000008859 change Effects 0.000 claims description 7
- 238000012550 audit Methods 0.000 claims description 6
- 239000003086 colorant Substances 0.000 claims description 4
- 238000003825 pressing Methods 0.000 claims description 4
- 238000003672 processing method Methods 0.000 claims description 4
- 238000004458 analytical method Methods 0.000 claims description 3
- 230000008569 process Effects 0.000 claims description 3
- 230000009466 transformation Effects 0.000 claims description 3
- 238000012384 transportation and delivery Methods 0.000 claims description 3
- 230000014759 maintenance of location Effects 0.000 claims description 2
- 230000009286 beneficial effect Effects 0.000 abstract description 4
- 238000012937 correction Methods 0.000 description 6
- 230000007547 defect Effects 0.000 description 2
- 230000007613 environmental effect Effects 0.000 description 2
- 238000012986 modification Methods 0.000 description 2
- 230000004048 modification Effects 0.000 description 2
- 238000013500 data storage Methods 0.000 description 1
- 238000011156 evaluation Methods 0.000 description 1
Landscapes
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention relates to the technical field of data processing, in particular to a management method and system of a power grid basic data host, wherein the method comprises the steps of receiving information filled by staff aiming at a statistical table; carrying out integrity check, consistency check and accuracy check on the statistical table information to obtain a check result, when the check result shows failed cells, displaying the number of the failed cells, highlighting the first color of the failed cells, analyzing the check result, when the check result is all the passed cells, generating a highest-score passing approval report, and when the check result has failed cells, generating a failed approval report with the highest score minus the score of the number of the failed cells; and generating an improvement notification based on the corresponding auditing result of the failed approval report. The invention improves the integrity and accuracy of the data and is beneficial to the safe use of the equipment.
Description
Technical Field
The invention relates to the technical field of data processing, in particular to a management method and system for a main power grid basic data.
Background
The system is a responsibility system for the main system of the basic data of the power grid, and the core of the system is to divide the responsibility of equipment and facilities clearly and give more rights and responsibility to related personnel. The main aim of the system is to improve the operation and maintenance quality and the management level of the equipment, and promote the operation of the equipment to be safer, more economical and more reliable.
The owners of the equipment need to maintain and manage the managed equipment and facilities, and are responsible for the safety operation of the equipment, the perfection of the data accounts, the correction and closing of equipment defects (anomalies), the tracking of equipment anti-measure execution and the like. Meanwhile, the operation maintenance, state evaluation, data comparison and other works of the equipment are needed to be performed. The existing equipment data owner system has some defects, such as situations of less filling, missing filling, random input of manually input contents and the like, which often occur to staff, so that a large amount of data null values and invalid data are caused, and the safe and economical use of the equipment is affected.
Disclosure of Invention
Therefore, the invention aims to provide a management method and system for a power grid basic data host, which are used for solving the problems that the existing power grid equipment data host is frequently filled in less, leaked in, manually input content is input randomly, and the like, so that a large amount of data are empty and invalid, and the safe and economical use of equipment is affected.
Based on the above purpose, the invention provides a management method for a power grid basic data host, which comprises the following steps:
s1: receiving a login request, and generating a statistical table of public configuration change file data filled by staff, wherein the statistical table comprises names and login time of login persons;
s2: receiving information filled by staff aiming at a statistical table;
S3: carrying out integrity check, consistency check and accuracy check on the statistical table information to obtain a check result, executing S4 when the check result shows that the cells do not pass, and executing S5 when the check result is that all the cells pass;
S4: displaying the number of the cells which are not checked to pass, highlighting the first color of the cells which are not checked to pass, receiving information filled by the staff aiming at the highlighted cells of the first color again, and executing S3;
S5: the statistical table is sent to an auditing module, the auditing module is used for auditing, and the auditing result of the statistical table sent by the auditing module is received;
S6: analyzing the auditing result, when the auditing result is all passing, generating a passing approval report with the highest score, and when the auditing result has failed cells, generating a failed approval report with the highest score minus the score of the number of the failed cells;
s7: and generating an improvement notification based on the corresponding auditing result of the failed approval report.
Optionally, the public change profile data includes:
Distribution transformer equipment base files: the method comprises the steps of name, model, specification, manufacturer and delivery date of the public distribution equipment;
distribution transformer operation data: real-time operation data including voltage, current, power factor, active power, reactive power;
and (3) configuration transformer maintenance record: the information comprises the maintenance time, maintenance content and maintenance personnel of the public distribution transformer;
And (3) matching and transformation fault treatment record: including information on fault phenomena, fault reasons, processing methods and processing results of the public distribution transformer.
Optionally, the method further comprises:
Obtaining the auditing result corresponding to the report of the same staff passing the examination and approval for a plurality of times,
Obtaining the cells with the times of failed cells being more than or equal to 2 based on the checking results of multiple failed cells, and highlighting the second color of the cells corresponding to the cells with the times of failed cells being more than or equal to 2 in the generated statistical table when the login request of the staff is received again;
And when the check result is analyzed, and when the check result has a cell highlighted in the second color which does not pass, multiplying the withholding score of the cell by 2.
According to the method, the cells with the times of not passing the cells being greater than or equal to 2 are obtained based on the checking results of the plurality of times of not passing the cells, the descriptions of the cells with the times of not passing the cells being greater than or equal to 2 are data which are easy to make mistakes for the staff, in order to remind the staff, the second color highlighting of the cells corresponding to the cells with the times of not passing the cells being greater than or equal to 2 in the generated statistical table is performed, so that the cells with the times of not passing the cells being greater than or equal to 2, which are appeared by the staff, are highlighted in the second color, and the condition reflection can be formed through the only second color highlighting, so that the staff can be reminded of the filling correctness of the cells more strongly.
When the check result is analyzed, if the check result has the cell highlighted by the second color and fails, the fact that the staff still does not correctly fill in the related data under the condition of reminding is indicated, and the deduction score of the cell is multiplied by 2 at the moment, so that the deduction strength of the same error under the condition of multiple occurrences is increased, and the performance condition of the staff can be reflected better.
Optionally, the method further comprises:
When the cells highlighted in the second color pass through a plurality of audits, canceling the highlighting in the second color when the statistical table is generated again;
When the information of the display shortcut key pressing is received, the second color highlighting which appears in the history is displayed, and when the second color highlighting appears in the history for many times in the unit cell, the second colors are overlapped with each other for many times, so that the color depth of the corresponding unit cell is improved.
Optionally, the configuration operation data further includes temperature, humidity, and ratios of voltage, current, power factor, active power, reactive power to temperature and humidity, respectively;
acquiring historical average values of ratios in a plurality of temperature ranges and humidity ranges;
obtaining the temperature and humidity to be selected, and the voltage, current, power factor, active power and reactive power corresponding to the temperature and humidity to be selected, wherein the ratio of the active power and the reactive power to the temperature and the humidity to be selected is respectively;
determining a temperature range and a humidity range corresponding to the temperature and the humidity to be checked respectively, and further obtaining a historical average value corresponding to the temperature range and the humidity range;
And selecting voltage, current, power factor, active power and reactive power corresponding to the real-time ratio of the difference value of the ratio to be selected and the historical average value exceeding the threshold value, and highlighting the selected cells corresponding to the voltage, current, power factor, active power and reactive power through a third color to serve as data to be checked.
Optionally, the auditing by the auditing module includes: and checking the distribution transformer fault processing record in the statistical table through comparison with the input video information, wherein the video information comprises video information and voice information in the distribution transformer fault processing process.
Optionally, the verifying the configuration fault handling record by comparing with the input video information includes:
Extracting fault position information in a fault phenomenon;
Acquiring a stored photo of the position corresponding to the distribution transformer based on the fault position information, and extracting color features, contour features and spatial relationship features on the photo of the position corresponding to the distribution transformer;
Matching the color characteristics, the contour characteristics and the spatial relation characteristics with the picture of each frame in the video information to obtain an audit picture with similarity meeting a threshold value;
converting the voice information into text information;
and the auditing picture and the text information are used for auditing the comparison information of the configuration transformer fault processing record auditing.
Optionally, the integrity check includes: the cells that need to fill in data may not be empty, may not be nonsensical spaces or special characters, and the data retention history period may not meet the requirements.
Optionally, the accuracy check includes: the value of the data in the cell is in the range of the value range, and whether the number, the type and the width of the fields in the cell meet the requirements or not.
Based on the same invention, the invention also provides a management system of the main power grid basic data, which comprises the following steps:
A login generation module: the method comprises the steps of receiving a login request, generating a statistical table of public configuration change file data filled by staff, wherein the statistical table comprises names and login time of login persons, and receiving information filled by the staff aiming at the statistical table;
And a verification module: for S3: carrying out integrity check, consistency check and accuracy check on the statistical table information to obtain a check result, executing S4 when the check result shows that the cells which do not pass, and transmitting the statistical table to an auditing module when the check result is that all the cells pass; s4: displaying the number of the cells which are not checked to pass, highlighting the first color of the cells which are not checked to pass, receiving information filled by the staff aiming at the highlighted cells of the first color again, and executing S3;
The auditing module is used for auditing the statistical table and generating auditing results of the statistical table;
And an analysis generation module: analyzing the auditing result, when the auditing result is all passing, generating a passing approval report with the highest score, when the auditing result has failed cells, generating a failed approval report with the highest score minus the score of the number of the failed cells, and generating an rectification notice based on the auditing result corresponding to the failed approval report.
The beneficial effects are that: according to the invention, through carrying out integrity check and consistency check and accuracy check on the statistical table information filled by staff, a check result is obtained, some data which are less filled, missed filled and manually input and obviously not in accordance with the actual situation can be checked out at will, meanwhile, the first color of the unqualified cell is highlighted, the staff is reminded to modify the data of the unqualified cell until the check is completely passed, and then the data are sent to the manager for checking again, when the checking result is all passed, the highest-score passing approval report is generated, when the checking result has the unpassed cell, the highest-score non-passing approval report obtained by subtracting the score of the number of the unpassed cells is generated, and a correction notice based on the checking result corresponding to the non-passing approval report is generated, so that the integrity and the accuracy of the data are improved, and the safety use of equipment is facilitated.
Drawings
In order to more clearly illustrate the invention or the technical solutions of the prior art, the drawings which are used in the description of the embodiments or the prior art will be briefly described, it being obvious that the drawings in the description below are only of the invention and that other drawings can be obtained from them without inventive effort for a person skilled in the art.
Fig. 1 is a flowchart of a method for managing a master data of a power grid device according to an embodiment of the present invention.
Detailed Description
The present invention will be further described in detail with reference to specific embodiments in order to make the objects, technical solutions and advantages of the present invention more apparent.
It is to be noted that unless otherwise defined, technical or scientific terms used herein should be taken in a general sense as understood by one of ordinary skill in the art to which the present invention belongs. The terms "first," "second," and the like, as used herein, do not denote any order, quantity, or importance, but rather are used to distinguish one element from another. The word "comprising" or "comprises", and the like, means that elements or items preceding the word are included in the element or item listed after the word and equivalents thereof, but does not exclude other elements or items. The terms "connected" or "connected," and the like, are not limited to physical or mechanical connections, but may include electrical connections, whether direct or indirect. "upper", "lower", "left", "right", etc. are used merely to indicate relative positional relationships, which may also be changed when the absolute position of the object to be described is changed.
As shown in fig. 1, a method for managing a master of basic data of a power grid includes:
s1: receiving a login request, and generating a statistical table of public configuration change file data filled by staff, wherein the statistical table comprises names and login time of login persons;
s2: receiving information filled by staff aiming at a statistical table;
S3: carrying out integrity check, consistency check and accuracy check on the statistical table information to obtain a check result, executing S4 when the check result shows that the cells do not pass, and executing S5 when the check result is that all the cells pass;
S4: displaying the number of the cells which are not checked to pass, highlighting the first color of the cells which are not checked to pass, receiving information filled by the staff aiming at the highlighted cells of the first color again, and executing S3;
S5: the statistical table is sent to an auditing module, the auditing module is used for auditing, and the auditing result of the statistical table sent by the auditing module is received;
S6: analyzing the auditing result, when the auditing result is all passing, generating a passing approval report with the highest score, and when the auditing result has failed cells, generating a failed approval report with the highest score minus the score of the number of the failed cells;
s7: and generating an improvement notification based on the corresponding auditing result of the failed approval report.
According to the invention, through carrying out integrity check and consistency check and accuracy check on the statistical table information filled by staff, a check result is obtained, some data which are less filled, missed filled and manually input and obviously not in accordance with the actual situation can be automatically checked out, meanwhile, the first color of the unqualified cell is highlighted, the staff is reminded to modify the data of the unqualified cell until the check is completely passed, and then the data are sent to the manager for checking again, when the checking result is completely passed, the highest-score passing approval report is generated, when the checking result has the unqualified cell, the highest-score non-passing approval report obtained by subtracting the scores of the number of the non-passing cells is generated, and a correction notice based on the checking result corresponding to the non-passing approval report is generated, so that the relevant staff is informed of correction, thereby improving the integrity and accuracy of the data, and being beneficial to the safe use of equipment.
In some embodiments, the public gear scheme data includes:
Distribution transformer equipment base files: the method comprises the steps of name, model, specification, manufacturer and delivery date of the public distribution equipment;
distribution transformer operation data: real-time operation data including voltage, current, power factor, active power, reactive power;
and (3) configuration transformer maintenance record: the information comprises the maintenance time, maintenance content and maintenance personnel of the public distribution transformer;
And (3) matching and transformation fault treatment record: including information on fault phenomena, fault reasons, processing methods and processing results of the public distribution transformer.
In some embodiments, the method further comprises:
Obtaining the auditing result corresponding to the report of the same staff passing the examination and approval for a plurality of times,
Obtaining the cells with the times of failed cells being more than or equal to 2 based on the checking results of multiple failed cells, and highlighting the second color of the cells corresponding to the cells with the times of failed cells being more than or equal to 2 in the generated statistical table when the login request of the staff is received again;
And when the check result is analyzed, and when the check result has a cell highlighted in the second color which does not pass, multiplying the withholding score of the cell by 2.
In this embodiment, the number of failed cells is greater than or equal to 2 based on the result of checking failed multiple times, and the description of the failed cells with the number of failed cells greater than or equal to 2 is the data that is easy to make mistakes multiple times by the staff.
When the check result is analyzed, if the check result has the cell highlighted by the second color and fails, the fact that the staff still does not correctly fill in the related data under the condition of reminding is indicated, and the deduction score of the cell is multiplied by 2 at the moment, so that the deduction strength of the same error under the condition of multiple occurrences is increased, and the performance condition of the staff can be reflected better.
In some embodiments, the method further comprises:
When the cells highlighted in the second color pass through a plurality of audits, canceling the highlighting in the second color when the statistical table is generated again;
When the information of the display shortcut key pressing is received, the second color highlighting which appears in the history is displayed, and when the second color highlighting appears in the history for many times in the unit cell, the second colors are overlapped with each other for many times, so that the color depth of the corresponding unit cell is improved.
In this embodiment, when the cells highlighted in the second color pass through for multiple verification, it is explained to a certain extent that the worker has solved the error problem that has occurred before, and the second color highlighting is canceled when the statistics table is generated again, so that the worker is prevented from being affected after the worker has solved the error problem that has occurred before.
When a worker wants to check the data of the cell, especially the data of the cell which is frequently in error before, the worker can display the historically-occurring second color highlighting by pressing the display shortcut key, and when the cell is historically-occurring a plurality of times of second color highlighting, the second colors are overlapped with each other for a plurality of times, so that the color depth of the corresponding cell is improved, and the worker can be quickly helped to quickly find the data of the cell which is frequently in error before and is wanted to check.
In some embodiments, the configuration operation data further includes temperature, humidity, and ratios of voltage, current, power factor, active power, reactive power to temperature and humidity, respectively;
acquiring historical average values of ratios in a plurality of temperature ranges and humidity ranges;
obtaining the temperature and humidity to be selected, and the voltage, current, power factor, active power and reactive power corresponding to the temperature and humidity to be selected, wherein the ratio of the active power and the reactive power to the temperature and the humidity to be selected is respectively;
determining a temperature range and a humidity range corresponding to the temperature and the humidity to be checked respectively, and further obtaining a historical average value corresponding to the temperature range and the humidity range;
And selecting voltage, current, power factor, active power and reactive power corresponding to the real-time ratio of the difference value of the ratio to be selected and the historical average value exceeding the threshold value, and highlighting the selected cells corresponding to the voltage, current, power factor, active power and reactive power through a third color to serve as data to be checked.
When auditing personnel conduct auditing, a part of data is usually extracted for auditing, at present, in order to embody the representativeness of the data of the lottery, the data with larger fluctuation of the data in the same cell is usually selected, but some data are affected by environmental factors such as temperature and humidity, and the like, the fluctuation of the data is large, and the data is not represented by certain problems, so that the method of the lottery is not very representative, in order to further improve the representativeness, the voltage, the current, the power factor, the active power and the reactive power corresponding to the real-time ratio that the difference value between the ratio to be selected and the historical average value exceeds the threshold value are selected, and the selected cell corresponding to the voltage, the current, the power factor, the active power and the reactive power is highlighted through a third color to serve as the data to be audited, so that the environmental influence factors of temperature and humidity are eliminated, the selected data are more representative, and meanwhile, the auditing personnel observe more intuitively through highlighting the third color.
In some embodiments, the auditing by the auditing module includes: and checking the distribution transformer fault processing record in the statistical table through comparison with the input video information, wherein the video information comprises video information and voice information in the distribution transformer fault processing process.
Optionally, the verifying the configuration fault handling record by comparing with the input video information includes:
Extracting fault position information in a fault phenomenon;
Acquiring a stored photo of the position corresponding to the distribution transformer based on the fault position information, and extracting color features, contour features and spatial relationship features on the photo of the position corresponding to the distribution transformer;
Matching the color characteristics, the contour characteristics and the spatial relation characteristics with the picture of each frame in the video information to obtain an audit picture with similarity meeting a threshold value;
converting the voice information into text information;
and the auditing picture and the text information are used for auditing the comparison information of the configuration transformer fault processing record auditing.
In order to ensure the accuracy of the distribution transformer fault processing record data, a worker can be required to record video to obtain video information during fault processing, meanwhile, the video information is input into a statistics table, when the worker carries out verification, verification pictures with similarity meeting a threshold value can be obtained by comparing the fault phenomenon, fault reasons, processing methods and text information of processing results recorded in the statistics table with the video information, so that whether the text information recorded in the statistics table is accurate or not is judged, but each video point is not very high in verification efficiency, in order to improve verification efficiency, the picture and text can be directly checked through converting the voice information into the text information, a stored picture of a distribution transformer corresponding position is obtained based on the fault position information, color features, contour features and spatial relationship features on the picture of the distribution transformer corresponding position are extracted, the color features, the contour features and the spatial relationship features are matched with pictures of each frame in the video information, and verification pictures with similarity meeting the threshold value are used for verification of the comparison information of the distribution transformer fault processing record video, verification efficiency can be further improved, and verification efficiency can be further improved when the worker needs to watch the verification video again.
In some embodiments, the integrity check comprises: the cells in which data is required to be filled cannot be blank, cannot be nonsensical spaces or special characters, and the data storage history period does not meet the requirements, and the accuracy check comprises: the value of the data in the cell is in the range of the value range, and whether the number, the type and the width of the fields in the cell meet the requirements or not.
In order to further implement the invention, the invention also provides a system for managing the master of the basic data of the power grid, which comprises:
A login generation module: the method comprises the steps of receiving a login request, generating a statistical table of public configuration change file data filled by staff, wherein the statistical table comprises names and login time of login persons, and receiving information filled by the staff aiming at the statistical table;
And a verification module: for S3: carrying out integrity check, consistency check and accuracy check on the statistical table information to obtain a check result, executing S4 when the check result shows that the cells which do not pass, and transmitting the statistical table to an auditing module when the check result is that all the cells pass; s4: displaying the number of the cells which are not checked to pass, highlighting the first color of the cells which are not checked to pass, receiving information filled by the staff aiming at the highlighted cells of the first color again, and executing S3;
The auditing module is used for auditing the statistical table and generating auditing results of the statistical table;
And an analysis generation module: analyzing the auditing result, when the auditing result is all passing, generating a passing approval report with the highest score, when the auditing result has failed cells, generating a failed approval report with the highest score minus the score of the number of the failed cells, and generating an rectification notice based on the auditing result corresponding to the failed approval report.
According to the invention, through carrying out integrity check and consistency check and accuracy check on the statistical table information filled by staff, a check result is obtained, some data which are less filled, missed filled and manually input and obviously not in accordance with the actual situation can be automatically checked out, meanwhile, the first color of the unqualified cell is highlighted, the staff is reminded to modify the data of the unqualified cell until the check is completely passed, and then the data are sent to the manager for checking again, when the checking result is completely passed, the highest-score passing approval report is generated, when the checking result has the unqualified cell, the highest-score non-passing approval report obtained by subtracting the scores of the number of the non-passing cells is generated, and a correction notice based on the checking result corresponding to the non-passing approval report is generated, so that the relevant staff is informed of correction, thereby improving the integrity and accuracy of the data, and being beneficial to the safe use of equipment.
Those of ordinary skill in the art will appreciate that: the discussion of any of the embodiments above is merely exemplary and is not intended to suggest that the scope of the invention (including the claims) is limited to these examples; the technical features of the above embodiments or in the different embodiments may also be combined within the idea of the invention, the steps may be implemented in any order and there are many other variations of the different aspects of the invention as above, which are not provided in detail for the sake of brevity.
The present invention is intended to embrace all such alternatives, modifications and variances which fall within the broad scope of the appended claims. Therefore, any omission, modification, equivalent replacement, improvement, etc. of the present invention should be included in the scope of the present invention.
Claims (9)
1. A method for managing a host of basic data of a power grid, comprising:
s1: receiving a login request, and generating a statistical table of public configuration change file data filled by staff, wherein the statistical table comprises names and login time of login persons;
s2: receiving information filled by staff aiming at a statistical table;
S3: carrying out integrity check, consistency check and accuracy check on the statistical table information to obtain a check result, executing S4 when the check result shows that the cells do not pass, and executing S5 when the check result is that all the cells pass;
S4: displaying the number of the cells which are not checked to pass, highlighting the first color of the cells which are not checked to pass, receiving information filled by the staff aiming at the highlighted cells of the first color again, and executing S3;
S5: the statistical table is sent to an auditing module, the auditing module is used for auditing, and the auditing result of the statistical table sent by the auditing module is received;
S6: analyzing the auditing result, when the auditing result is all passing, generating a passing approval report with the highest score, and when the auditing result has failed cells, generating a failed approval report with the highest score minus the score of the number of the failed cells;
s7: generating an improvement notification based on the auditing result corresponding to the failed approval report;
the method further comprises the steps of:
Obtaining the auditing result corresponding to the report of the same staff passing the examination and approval for a plurality of times,
Obtaining the cells with the times of failed cells being more than or equal to 2 based on the checking results of multiple failed cells, and highlighting the second color of the cells corresponding to the cells with the times of failed cells being more than or equal to 2 in the generated statistical table when the login request of the staff is received again;
And when the check result is analyzed, and when the check result has a cell highlighted in the second color which does not pass, multiplying the withholding score of the cell by 2.
2. The method for managing network base data owners of claim 1 wherein said utility profile data includes:
Distribution transformer equipment base files: the method comprises the steps of name, model, specification, manufacturer and delivery date of the public distribution equipment;
distribution transformer operation data: real-time operation data including voltage, current, power factor, active power, reactive power;
and (3) configuration transformer maintenance record: the information comprises the maintenance time, maintenance content and maintenance personnel of the public distribution transformer;
And (3) matching and transformation fault treatment record: including information on fault phenomena, fault reasons, processing methods and processing results of the public distribution transformer.
3. A method of managing a network infrastructure data owner as claimed in claim 1, further comprising:
When the cells highlighted in the second color pass through a plurality of audits, canceling the highlighting in the second color when the statistical table is generated again;
When the information of the display shortcut key pressing is received, the second color highlighting which appears in the history is displayed, and when the second color highlighting appears in the history for many times in the unit cell, the second colors are overlapped with each other for many times, so that the color depth of the corresponding unit cell is improved.
4. The method for managing the master of the basic data of the power grid according to claim 2, wherein the distribution transformer operation data further comprises temperature, humidity, and ratios of voltage, current, power factor, active power and reactive power to the temperature and humidity respectively;
acquiring historical average values of ratios in a plurality of temperature ranges and humidity ranges;
obtaining the temperature and humidity to be selected, and the voltage, current, power factor, active power and reactive power corresponding to the temperature and humidity to be selected, wherein the ratio of the active power and the reactive power to the temperature and the humidity to be selected is respectively;
determining a temperature range and a humidity range corresponding to the temperature and the humidity to be checked respectively, and further obtaining a historical average value corresponding to the temperature range and the humidity range;
And selecting voltage, current, power factor, active power and reactive power corresponding to the real-time ratio of the difference value of the ratio to be selected and the historical average value exceeding the threshold value, and highlighting the selected cells corresponding to the voltage, current, power factor, active power and reactive power through a third color to serve as data to be checked.
5. A method of managing a network infrastructure data owner as claimed in claim 2, wherein said auditing by the auditing module comprises: and checking the distribution transformer fault processing record in the statistical table through comparison with the input video information, wherein the video information comprises video information and voice information in the distribution transformer fault processing process.
6. The method of claim 5, wherein auditing the distribution fault handling record by comparison with the inputted video information comprises:
Extracting fault position information in a fault phenomenon;
Acquiring a stored photo of the position corresponding to the distribution transformer based on the fault position information, and extracting color features, contour features and spatial relationship features on the photo of the position corresponding to the distribution transformer;
Matching the color characteristics, the contour characteristics and the spatial relation characteristics with the picture of each frame in the video information to obtain an audit picture with similarity meeting a threshold value;
converting the voice information into text information;
and the auditing picture and the text information are used for auditing the comparison information of the configuration transformer fault processing record auditing.
7. A method of managing a network infrastructure data owner as claimed in claim 1, wherein the integrity check comprises: the cells that need to fill in data may not be empty, may not be nonsensical spaces or special characters, and the data retention history period may not meet the requirements.
8. A method of managing a master of grid base data according to claim 1, wherein the accuracy check comprises: the value of the data in the cell is in the range of the value range, and whether the number, the type and the width of the fields in the cell meet the requirements or not.
9. A management system for performing a method of managing a network infrastructure data owner as claimed in any one of claims 1 to 8, comprising:
A login generation module: the method comprises the steps of receiving a login request, generating a statistical table of public configuration change file data filled by staff, wherein the statistical table comprises names and login time of login persons, and receiving information filled by the staff aiming at the statistical table;
And a verification module: for S3: carrying out integrity check, consistency check and accuracy check on the statistical table information to obtain a check result, executing S4 when the check result shows that the cells which do not pass, and transmitting the statistical table to an auditing module when the check result is that all the cells pass; s4: displaying the number of the cells which are not checked to pass, highlighting the first color of the cells which are not checked to pass, receiving information filled by the staff aiming at the highlighted cells of the first color again, and executing S3;
The auditing module is used for auditing the statistical table and generating auditing results of the statistical table;
And an analysis generation module: analyzing the auditing result, when the auditing result is all passing, generating a passing approval report with the highest score, when the auditing result has failed cells, generating a failed approval report with the highest score minus the score of the number of the failed cells, and generating an rectification notice based on the auditing result corresponding to the failed approval report.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202410599426.7A CN118195554A (en) | 2024-05-15 | 2024-05-15 | Main management method and system for basic data of power grid |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202410599426.7A CN118195554A (en) | 2024-05-15 | 2024-05-15 | Main management method and system for basic data of power grid |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN118195554A true CN118195554A (en) | 2024-06-14 |
Family
ID=91406795
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202410599426.7A Pending CN118195554A (en) | 2024-05-15 | 2024-05-15 | Main management method and system for basic data of power grid |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN118195554A (en) |
Citations (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JPH11282941A (en) * | 1998-03-27 | 1999-10-15 | Nec Corp | Cell data emphasis display method by color |
| CN103793778A (en) * | 2013-11-08 | 2014-05-14 | 远光软件股份有限公司 | Report data real-time audit method and device |
| CN109784862A (en) * | 2019-01-18 | 2019-05-21 | 云南电网有限责任公司曲靖供电局 | Power equipment management system and equipment |
| CN113033166A (en) * | 2021-03-19 | 2021-06-25 | 国家能源集团宁夏煤业有限责任公司 | Electronic report generation method and system based on PI system |
| CN115496379A (en) * | 2022-09-27 | 2022-12-20 | 广东电网有限责任公司 | Distribution network data verification application system and method |
| CN115760156A (en) * | 2022-11-15 | 2023-03-07 | 中国通信建设集团有限公司 | Intelligent individual household approval system and method based on Internet of things |
| WO2023124934A1 (en) * | 2021-12-29 | 2023-07-06 | 北京字跳网络技术有限公司 | Table data processing method and apparatus, device and medium |
| CN117077648A (en) * | 2023-09-07 | 2023-11-17 | 中国工商银行股份有限公司 | Data processing method and device, storage medium and electronic equipment |
-
2024
- 2024-05-15 CN CN202410599426.7A patent/CN118195554A/en active Pending
Patent Citations (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JPH11282941A (en) * | 1998-03-27 | 1999-10-15 | Nec Corp | Cell data emphasis display method by color |
| CN103793778A (en) * | 2013-11-08 | 2014-05-14 | 远光软件股份有限公司 | Report data real-time audit method and device |
| CN109784862A (en) * | 2019-01-18 | 2019-05-21 | 云南电网有限责任公司曲靖供电局 | Power equipment management system and equipment |
| CN113033166A (en) * | 2021-03-19 | 2021-06-25 | 国家能源集团宁夏煤业有限责任公司 | Electronic report generation method and system based on PI system |
| WO2023124934A1 (en) * | 2021-12-29 | 2023-07-06 | 北京字跳网络技术有限公司 | Table data processing method and apparatus, device and medium |
| CN115496379A (en) * | 2022-09-27 | 2022-12-20 | 广东电网有限责任公司 | Distribution network data verification application system and method |
| CN115760156A (en) * | 2022-11-15 | 2023-03-07 | 中国通信建设集团有限公司 | Intelligent individual household approval system and method based on Internet of things |
| CN117077648A (en) * | 2023-09-07 | 2023-11-17 | 中国工商银行股份有限公司 | Data processing method and device, storage medium and electronic equipment |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN107797910A (en) | A kind of evaluation method of dispatch automated system software quality | |
| CN110046722A (en) | Community's equipment maintenance method and device and system and storage medium based on OCR technique | |
| CN109460977A (en) | The management method and device of Data-report | |
| CN112668772A (en) | State development trend prediction method, device, equipment and storage medium | |
| CN115757150A (en) | Production environment testing method, device, equipment and storage medium | |
| CN111047125B (en) | Product failure analysis apparatus, method, and computer-readable storage medium | |
| CN110675048A (en) | Power data quality detection method and system | |
| CN112000862B (en) | Data processing method and device | |
| CN118195554A (en) | Main management method and system for basic data of power grid | |
| CN115471092A (en) | Food production work reporting method and device, electronic equipment and storage medium | |
| CN113256091B (en) | Enterprise safety and health risk classification and classification method | |
| CN115481116A (en) | Data quality inspection method and device | |
| CN114936796A (en) | Project evaluation method and device, electronic equipment and computer readable medium | |
| CN107168942B (en) | Automatic report generation method and device | |
| CN114037314A (en) | Information system engineering supervision project risk dynamic analysis method | |
| CN112529512A (en) | SaaS-based method and platform for improving safety inspection level of transport enterprise carrier | |
| CN102289748A (en) | Customer satisfaction and service quality comprehensive evaluation system and method for power supply company | |
| CN111695870A (en) | Project process management system | |
| CN109544353B (en) | Electronic device, method for analyzing preparation gold change based on data change factor and storage medium | |
| CN114035835B (en) | System rollback risk assessment method | |
| CN117056433A (en) | Data report management method, device, terminal equipment and storage medium | |
| CN112308608B (en) | Data processing method and device for manufacturing cost of transformer substation, electronic equipment and storage medium | |
| CN117196307A (en) | Method, device, equipment and storage medium for detecting running state of wind control model | |
| CN113672647A (en) | Planned power failure standard verification method and device | |
| CN115757146A (en) | Target detection algorithm testing method and system based on python language |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination |