CN111666741A - Automatic generation method of scheduling comprehensive report - Google Patents
Automatic generation method of scheduling comprehensive report Download PDFInfo
- Publication number
- CN111666741A CN111666741A CN202010443975.7A CN202010443975A CN111666741A CN 111666741 A CN111666741 A CN 111666741A CN 202010443975 A CN202010443975 A CN 202010443975A CN 111666741 A CN111666741 A CN 111666741A
- Authority
- CN
- China
- Prior art keywords
- report
- data
- format
- alarm
- generating
- 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
- 238000000034 method Methods 0.000 title claims abstract description 32
- 238000012216 screening Methods 0.000 claims abstract description 15
- 230000002354 daily effect Effects 0.000 claims description 25
- 230000003203 everyday effect Effects 0.000 claims description 5
- 238000006073 displacement reaction Methods 0.000 claims description 4
- 238000012544 monitoring process Methods 0.000 claims description 4
- 230000008569 process Effects 0.000 claims description 4
- 238000010586 diagram Methods 0.000 description 7
- 238000012423 maintenance Methods 0.000 description 6
- 238000005429 filling process Methods 0.000 description 3
- 230000009286 beneficial effect Effects 0.000 description 2
- 230000008859 change Effects 0.000 description 2
- 230000011664 signaling Effects 0.000 description 2
- 230000009471 action Effects 0.000 description 1
- 238000007405 data analysis Methods 0.000 description 1
- 238000011161 development Methods 0.000 description 1
- 238000007726 management method Methods 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 238000012545 processing Methods 0.000 description 1
- 230000001105 regulatory effect Effects 0.000 description 1
- 238000013515 script Methods 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/177—Editing, e.g. inserting or deleting of tables; using ruled lines
- G06F40/18—Editing, e.g. inserting or deleting of tables; using ruled lines of spreadsheets
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/80—Information retrieval; Database structures therefor; File system structures therefor of semi-structured data, e.g. markup language structured data such as SGML, XML or HTML
- G06F16/83—Querying
- G06F16/838—Presentation of query results
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
-
- H—ELECTRICITY
- H04—ELECTRIC COMMUNICATION TECHNIQUE
- H04L—TRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION
- H04L67/00—Network arrangements or protocols for supporting network services or applications
- H04L67/01—Protocols
- H04L67/06—Protocols specially adapted for file transfer, e.g. file transfer protocol [FTP]
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- Health & Medical Sciences (AREA)
- Artificial Intelligence (AREA)
- Audiology, Speech & Language Pathology (AREA)
- Computational Linguistics (AREA)
- General Health & Medical Sciences (AREA)
- Databases & Information Systems (AREA)
- Data Mining & Analysis (AREA)
- Signal Processing (AREA)
- Computer Networks & Wireless Communication (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention provides a method for automatically generating a scheduling comprehensive report, which comprises the following steps of S1, acquiring data from different systems by using a data interface, and recording the data type and the data source according to the data interface type; step S2, data screening is carried out on the obtained data, the data are screened according to the report form format, and the content needing to be displayed is selected; step S3, generating a report format table according to the screened data and the specified format; and step S4, automatically uploading the generated report to a server and downloading a backup at the terminal generating the format report. The invention improves the operation efficiency and reliability of the power grid, improves the working efficiency of personnel and reduces the safety risk.
Description
Technical Field
The invention relates to the technical field of power system automation, in particular to an automatic generation method of a scheduling comprehensive report.
Background
With the continuous development of the intelligent operation of the power grid, the range of data analysis and application is wider and wider, so that a user can conveniently and timely know the relevant conditions of the power grid operation and find the problems existing in the power grid operation, the decision and the adjustment of the power grid are made, and the requirement on the automatic processing capacity of the power grid data is higher.
The dispatching automation comprehensive report comprises daily reports and monthly reports, the contents relate to operation information of all system modules of a whole power network and different types of alarm information, when filling reports, an OCS (online charging system), an OMS (operation management system) and other systems need to be respectively logged in manually, required data are inquired in different modules or interfaces, the inquired data are manually input into a report file in a standard format, the data sources are complex and changeable, the problems of complex flow, difficulty in positioning, time consumption, labor consumption and the like exist in a manual report input mode, and safety risks of missing reports, wrong reports and the like inevitably exist in the manual report filling process.
Disclosure of Invention
The technical problem to be solved by the embodiment of the invention is to provide an automatic generation method of a scheduling comprehensive report, and solve the technical problems of poor operation efficiency and reliability of a power grid, low working efficiency of personnel and high safety risk.
One aspect of the present invention provides a method for automatically generating a scheduling comprehensive report, including:
step S1, acquiring data from different systems by using data interfaces, and recording data types and data sources according to the data interface types;
step S2, data screening is carried out on the obtained data, the data are screened according to the report form format, and the content needing to be displayed is selected;
step S3, generating a report format table according to the screened data and the specified format;
and step S4, automatically uploading the generated report to a server and downloading a backup at the terminal generating the format report.
Further, in step S1, the type of the recorded data according to the type of the data interface and the data source are specifically that the related data of the daily report and the monthly report are acquired from the alarm system and the operation system, and the data related to the distribution network or the video monitoring is acquired from a system other than the alarm system and the operation system.
Further, in step S2, the specific steps of screening data according to the report format and selecting the content to be displayed include extracting fault trip and station voltage loss alarm information from the corresponding alarm table in the database of the alarm system, screening information in the alarm signal according to the station name, the equipment name, the voltage class and the category of the displacement time to which the alarm signal belongs, and determining whether reclosing is successful after the switch is tripped.
Further, in step S2, the screening data according to the report format and selecting the content to be displayed specifically includes extracting the operation information of the relevant system or device and the operation indexes of the different modules from the operation system, screening according to the monthly report format, and selecting the content to be displayed at the front end of the system.
Further, in step S3, the specific process of generating the report format from the filtered data according to the specified format is to generate a report according to a template of a daily report or a monthly report, and the report file automatically generated by the system can be downloaded to the terminal and edited by using an office tool, and reported to the system for parsing and importing.
Further, the specified format of the format report is an xls format.
Further, the specific data of the format report is that the daily report contains system operation conditions and important alarm conditions; the monthly report contains the running indexes of all modules, the system running risk issue and the master station work execution condition.
Further, the timing logic is set in the process of generating the report format according to the specified format, the daily report automatically generates all report information in the last time period at a certain time every day, and the monthly report automatically generates the report information of the last month at a certain time 1 every month.
Further, in step S4, after the format report is generated, the system copies the report to a designated directory in the web server of the alarm system, and downloads the backup on the terminal, after the format report is downloaded, the system deletes the report file on the web server every day, and the backup file is stored in the report generating machine.
In summary, the embodiment of the invention has the following beneficial effects:
the automatic generation method of the dispatching comprehensive report provided by the invention can automatically establish a report generation tool, does not need to install a device and maintain the device, and can greatly reduce the investment and maintenance cost.
The method and the device realize automatic statistics and report generation on the alarm records of the power grid running state and major events in the system, change the condition that the alarm needs to be inquired manually at present and then the report content is input in a manual filling mode according to the inquired alarm result, solve the problems of complicated information collection and easy error in the manual filling process, reduce the maintenance workload and avoid errors in maintenance.
The comprehensive report model can be updated in time according to the format requirement of the comprehensive report, when the format requirement is changed, the filled contents are automatically re-associated, the extracted contents are updated in different modules and systems, the template filling is automatically updated in time, and the alarm notification is given, so that the practicability of the comprehensive report system is improved.
Drawings
In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings used in the description of the embodiments or the prior art will be briefly introduced below, and it is obvious that the drawings in the following description are only some embodiments of the present invention, and it is within the scope of the present invention for those skilled in the art to obtain other drawings based on the drawings without inventive exercise.
Fig. 1 is a schematic main flow diagram of an automatic scheduling comprehensive report generation method provided by the present invention.
Fig. 2 is a logic diagram of an embodiment of the method for automatically generating a scheduling comprehensive report according to the present invention.
Fig. 3 is a diagram of trip remote signaling deflection information of a fault according to an embodiment of the method for automatically generating a scheduling comprehensive report.
Fig. 4 is an optimized completion data chart of an embodiment of the method for automatically generating a scheduling comprehensive report according to the present invention.
Fig. 5 is a schematic diagram of important warning of a daily report file in an embodiment of the method for automatically generating a scheduling comprehensive report according to the present invention.
Fig. 6 is a schematic diagram of important alarms of a log file statistics page in an embodiment of the method for automatically generating a scheduling comprehensive report according to the present invention.
Fig. 7 is a schematic diagram of important alarms on a detailed page of a log file according to an embodiment of the method for automatically generating a scheduling comprehensive report.
Detailed Description
In order to make the objects, technical solutions and advantages of the present invention more apparent, the present invention will be described in further detail with reference to the accompanying drawings.
Fig. 1 and fig. 2 are schematic diagrams illustrating an embodiment of an automatic scheduling comprehensive report generation method according to the present invention. In this embodiment, the method comprises the steps of:
step S1, acquiring data from different systems by using data interfaces, and recording data types and data sources according to the data interface types;
in a specific embodiment, the recorded data type and data source according to the data interface type are specifically that related data of a daily report and a monthly report are acquired from an alarm system and an operation system, and data related to a distribution network or video monitoring is acquired from a system other than the alarm system and the operation system; the data sources of the comprehensive daily report and the monthly report are complex, wherein the main information of the daily report and the monthly report is from an alarm system and an operation system, and part of data also relates to a regional system such as a distribution network and video monitoring; different systems need to develop different data interfaces, the sources of partial data in the report are fuzzy, and corresponding logic judgment needs to be added.
Step S2, data screening is carried out on the obtained data, the data are screened according to the report form format, and the content needing to be displayed is selected;
in a specific embodiment, fault tripping and station voltage loss warning information is extracted from a corresponding warning table in a database of the warning system, information in warning signals is screened according to the types of the names, equipment names, voltage levels and displacement time of the stations, and whether reclosing is successful or not after a switch trips is judged; and extracting operation information of related systems or equipment and operation indexes of different modules from the operation system, screening according to a monthly report format, selecting contents to be displayed at the front end of the system, and intelligently selecting the contents to be displayed.
Step S3, generating a report format table according to the screened data and the specified format;
in a specific embodiment, a report is generated according to a template of a daily report or a monthly report, a report file automatically generated by the system can be downloaded to a terminal and edited by using office tools, and particularly, the report file automatically generated by a program can be edited by using office software such as office software after being downloaded to a windows computer, and can be analyzed and imported after being reported to the system;
the specific requirements of the specified format of the report format table are as follows: the specified format of the format report is an xls format, and the format report and the generated log are downloaded to a windows office computer and then can be opened and edited; the generated report file is consistent with the template, the daily report comprises 3 sheet pages of system operation condition, important alarm condition and the like, the monthly report comprises 26 sheet pages of module operation indexes, system operation risk issue, master station work ticket execution condition and the like, the content in each sheet page is complete, the format is neat, and the page is concise and attractive; setting a timing logic in a report file generating program, automatically generating report information (with configurable time) from the xx time of yesterday to the xx time of this day by a daily report at the xx time of each day, and automatically generating the report information of the last month by a monthly report at the xx time of 1 day each month.
Step S4, automatically uploading the generated report to a server and downloading and backing up the report at the terminal generating the format report;
in a specific embodiment, after the format report is generated, the system copies the format report to a specified directory in a web server of the alarm system, and simultaneously downloads a backup on a terminal for auditing and reporting; after the format report is downloaded, the system deletes the report file on the web server regularly every day, and the backup file is stored on the report generating machine.
In a specific embodiment of the invention, as shown in fig. 2, it is assumed that a 1# main transformer of a B-site plant station in 1 month and 1 day of 2020 fails, a 1101 switch of the 1# main transformer, a 301 switch of the 1# main transformer and a 101 switch of the 1# main transformer trip, and the trip start time is 11:34 in 1 month and 1 day of 2020, and a plurality of accident trip signals are generated after an accident occurs.
Determining a data source, wherein the fault trip telecommand deflection information mainly comes from an alarm system, and an alarm query interface of the alarm system needs to be called to acquire the fault trip telecommand deflection information occurring in 1 month and 1 day in 2020;
step two, data screening, namely screening fault tripping deflection information in a time period from 1 month and 1 day 8:00 in 2020 to 1 month and 2 days in 2020 and 8:00 in a three-area database of the alarm system through an alarm query interface according to the daily reporting time; the fault trip displacement information includes a switch name, a switch ID and an action time, as shown in fig. 3; extracting the station, the regulating range and the voltage grade of the trip switch according to the switch ID, as shown in FIG. 4; and whether reclosing is successful after the switch trips is judged.
And step three, generating a report, and exporting the file name of the daily report file in an excel format according to the format requirement of an important alarm sheet in the daily report template file, namely 'automatic daily report reporting-A area-2020 1 month and 1 day and xlsx' and a daily report log file 'automatic daily report log-A area-2020 1 month and 1 day and xlsx'. The trip remote signaling deflection of the fault in the important alarm sheet page of the daily report file is exported according to a template, as shown in fig. 5, and the daily report log records statistical data and detailed information of the overall export information, as shown in fig. 6 and 7.
And step four, report downloading and uploading, wherein a service program deployed on the web server sends the generated daily report file and the generated log file to a three-area file server, scripts for automatically downloading the files are added in a windows planning task of a four-area office computer, and then the daily report file and the log file on the file server are automatically downloaded to a specified directory and deleted under the condition that the network security protection requirement is not violated.
In summary, the embodiment of the invention has the following beneficial effects:
the automatic generation method of the dispatching comprehensive report provided by the invention can automatically establish a report generation tool, does not need to install a device and maintain the device, and can greatly reduce the investment and maintenance cost.
The method and the device realize automatic statistics and report generation on the alarm records of the power grid running state and major events in the system, change the condition that the alarm needs to be inquired manually at present and then the report content is input in a manual filling mode according to the inquired alarm result, solve the problems of complicated information collection and easy error in the manual filling process, reduce the maintenance workload and avoid errors in maintenance.
The comprehensive report model can be updated in time according to the format requirement of the comprehensive report, when the format requirement is changed, the filled contents are automatically re-associated, the extracted contents are updated in different modules and systems, the template filling is automatically updated in time, and the alarm notification is given, so that the practicability of the comprehensive report system is improved.
While the invention has been described in connection with what is presently considered to be the most practical and preferred embodiment, it is to be understood that the invention is not to be limited to the disclosed embodiment, but on the contrary, is intended to cover various modifications and equivalent arrangements included within the spirit and scope of the appended claims.
Claims (9)
1. A method for automatically generating a scheduling comprehensive report is characterized by comprising the following steps:
step S1, acquiring data from different systems by using data interfaces, and recording data types and data sources according to the data interface types;
step S2, data screening is carried out on the obtained data, the data are screened according to the report form format, and the content needing to be displayed is selected;
step S3, generating a report format table according to the screened data and the specified format;
and step S4, automatically uploading the generated report to a server and downloading a backup at the terminal generating the format report.
2. The method as claimed in claim 1, wherein in step S1, the data type and data source of the record according to the data interface type are obtained from alarm system and operation system, and the data related to distribution network or video monitoring is obtained from system other than alarm system and operation system.
3. The method according to claim 2, wherein in step S2, the screening data according to the report format, and the selecting of the content to be displayed specifically comprises extracting fault trip and station voltage loss alarm information from the corresponding alarm table in the database of the alarm system, screening information in the alarm signal according to the station name, the equipment name, the voltage class and the category of the displacement time to which the alarm signal belongs, and judging whether reclosing is successful after the switch is tripped.
4. The method according to claim 3, wherein in step S2, the screening data according to the report format, and the selecting of the content to be displayed specifically comprises extracting operation information of related systems or devices and operation indexes of different modules from the operation system, screening according to the monthly report format, and selecting the content to be displayed at the front end of the system.
5. The method according to claim 4, wherein in step S3, the specific process of generating the report format from the filtered data according to the specified format is that the report is generated according to the template of daily report or monthly report, the report file automatically generated by the system can be downloaded to the terminal for editing by using office tools, and the report file can be analyzed and imported by reporting to the system.
6. The method of claim 5, wherein the specified format of the format report is an xls format.
7. The method according to claim 6, wherein the specific data of the format report is that the daily report contains system operation condition and important alarm condition; the monthly report contains the running indexes of all modules, the system running risk issue and the master station work execution condition.
8. The method according to claim 7, wherein the timing logic is set in the process of generating the report format according to the designated format, the daily report automatically generates all report information in the last time period at a certain time every day, and the monthly report automatically generates the report information in the last month at a certain time 1 day every month.
9. The method according to claim 1, wherein in step S4, after the format report is generated, the system copies the report to a designated directory in a web server of the alarm system, and downloads the backup from the terminal, after the format report is downloaded, the system deletes the report files on the web server regularly every day, and the backup files are stored in the report generating machine.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010443975.7A CN111666741A (en) | 2020-05-22 | 2020-05-22 | Automatic generation method of scheduling comprehensive report |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010443975.7A CN111666741A (en) | 2020-05-22 | 2020-05-22 | Automatic generation method of scheduling comprehensive report |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN111666741A true CN111666741A (en) | 2020-09-15 |
Family
ID=72384377
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202010443975.7A Pending CN111666741A (en) | 2020-05-22 | 2020-05-22 | Automatic generation method of scheduling comprehensive report |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111666741A (en) |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112651701A (en) * | 2020-10-20 | 2021-04-13 | 国网重庆市电力公司市北供电分公司 | Automatic processing method for D5000 system data |
| CN113687895A (en) * | 2021-08-18 | 2021-11-23 | 广东电网有限责任公司 | Method and device for displaying equipment information |
| CN113687895B (en) * | 2021-08-18 | 2024-06-07 | 广东电网有限责任公司 | Display method and device for equipment information |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JP2005190197A (en) * | 2003-12-25 | 2005-07-14 | Chugoku Electric Power Co Inc:The | Power feed record management method and apparatus |
| CN102013056A (en) * | 2010-12-14 | 2011-04-13 | 广东雅达电子股份有限公司 | Configurable power report management system and operating method thereof |
| CN110738330A (en) * | 2019-09-10 | 2020-01-31 | 国网浙江省电力有限公司金华供电公司 | intelligent report generation method based on scheduling prefecture-county integrated control system |
-
2020
- 2020-05-22 CN CN202010443975.7A patent/CN111666741A/en active Pending
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JP2005190197A (en) * | 2003-12-25 | 2005-07-14 | Chugoku Electric Power Co Inc:The | Power feed record management method and apparatus |
| CN102013056A (en) * | 2010-12-14 | 2011-04-13 | 广东雅达电子股份有限公司 | Configurable power report management system and operating method thereof |
| CN110738330A (en) * | 2019-09-10 | 2020-01-31 | 国网浙江省电力有限公司金华供电公司 | intelligent report generation method based on scheduling prefecture-county integrated control system |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112651701A (en) * | 2020-10-20 | 2021-04-13 | 国网重庆市电力公司市北供电分公司 | Automatic processing method for D5000 system data |
| CN113687895A (en) * | 2021-08-18 | 2021-11-23 | 广东电网有限责任公司 | Method and device for displaying equipment information |
| CN113687895B (en) * | 2021-08-18 | 2024-06-07 | 广东电网有限责任公司 | Display method and device for equipment information |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN106557991B (en) | Voltage monitoring data platform | |
| CN104600840A (en) | Intelligent dispatching and mis-operation preventing management system and method | |
| CN110336375B (en) | Processing method and system for power grid monitoring alarm information | |
| CN103679554B (en) | Power grid accident separating brake aided analysis method | |
| CN106815373B (en) | Distribution network first-aid repair big data display method and system based on BI analysis | |
| CN104463712A (en) | Intelligent distribution network fault information statistical analysis system | |
| CN106504115A (en) | Water power production real-time information processing system and method based on mass data | |
| CN111934274A (en) | Intelligent substation protection constant value intelligent downloading method | |
| CN110598975B (en) | Typical wiring diagnosis and analysis method for distribution network line | |
| CN103325019A (en) | Event-driven power grid fault information judgment method | |
| CN113642299A (en) | One-key generation method based on power grid statistical form | |
| CN111913933B (en) | Power grid historical data management method and system based on unified support platform | |
| CN111913943A (en) | Data acquisition and processing method and system suitable for automatic factory scheduling | |
| CN111666741A (en) | Automatic generation method of scheduling comprehensive report | |
| CN111291546A (en) | Transformer substation equipment monitoring information table carding method based on version difference checking | |
| CN110930264A (en) | Regional power grid tripping information management and control system | |
| CN113570474A (en) | Monitoring system for power grid event response | |
| CN112446619A (en) | Power distribution network emergency repair processing method and device | |
| CN112102107A (en) | Method, device and equipment for generating report of power supply system | |
| CN114694420B (en) | Civil aviation weather forecast making and publishing system and method capable of intelligently correcting errors | |
| CN113852199B (en) | Multi-dimensional power distribution automation inspection system | |
| CN110727427A (en) | Intelligent safety checking method for dispatching automation master station model | |
| CN113449266B (en) | Closed loop power supply statistical method based on hand-in-hand line | |
| CN117196253A (en) | Intelligent power dispatching system and dispatching method | |
| Zhida et al. | Practical research on on-line monitoring and control function module of relay protection in smart substation |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20200915 |
|
| RJ01 | Rejection of invention patent application after publication |