阅读说明：本技术 一种调度综合报表自动生成方法 (Automatic generation method of scheduling comprehensive report ) 是由 武婕 张宗包 郝蛟 张夕佳 李浩然 叶振豪 李雨森 王子滔 刘岩 刘铠 于 2020-05-22 设计创作，主要内容包括：本发明提供一种调度综合报表自动生成方法,包括步骤S1,利用数据接口从不同系统中获取数据,根据数据接口类型的记录数据类型与数据来源；步骤S2,对获取到的数据进行数据筛选,根据报表格式筛选数据,选取其中需要展示的内容；步骤S3,将筛选后的数据,按照指定格式生成报格式表；步骤S4,将生成的报表自动上传到服务器并在生成格式报表的终端下载备份。本发明提高电网运行效率和可靠性,提升人员工作效率、降低安全风险。(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.)

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.

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.