CN107944659B - Method and device for automatically generating plant station monitoring system report - Google Patents
Method and device for automatically generating plant station monitoring system report Download PDFInfo
- Publication number
- CN107944659B CN107944659B CN201711002790.7A CN201711002790A CN107944659B CN 107944659 B CN107944659 B CN 107944659B CN 201711002790 A CN201711002790 A CN 201711002790A CN 107944659 B CN107944659 B CN 107944659B
- Authority
- CN
- China
- Prior art keywords
- report
- measuring points
- remote
- points
- devices
- 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.)
- Active
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/06—Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
- G06Q10/063—Operations research, analysis or management
- G06Q10/0631—Resource planning, allocation, distributing or scheduling for enterprises or organisations
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/22—Indexing; Data structures therefor; Storage structures
- G06F16/2282—Tablespace storage structures; Management thereof
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/284—Relational databases
- G06F16/285—Clustering or classification
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q50/00—Systems or methods specially adapted for specific business sectors, e.g. utilities or tourism
- G06Q50/06—Electricity, gas or water supply
Abstract
The invention relates to a method and a device for automatically generating a plant station monitoring system report, which are characterized in that devices are classified and stored under different types according to different voltage grades, measuring points matched with the devices are found out in a database, measuring point information is stored in a corresponding device container, and then the report of the devices or the report of the devices under the corresponding voltage grade is generated according to the selected device type or the voltage grade of the devices, so that the automatic generation of the report is realized, the working efficiency of report generation is improved, and the problems of low report creating efficiency and overlarge workload of a substation report system are solved.
Description
Technical Field
The invention belongs to the field of automation of power system substations, and particularly relates to a method and a device for automatically generating a plant monitoring system report.
Background
With the development of society, power networks play more and more important roles in industrial production and resident life, and monitoring and recording of various parameters of power grids are important parts of daily operation and maintenance of substations. The report system is an important component of the transformer substation monitoring system and is responsible for automatically recording the operation parameters of equipment such as each line, a transformer, a capacitor, a reactor, a substation transformer and the like in the transformer substation. The data content recorded by the report file should be complete and accurate, and the actual requirements of the operation and regulation and control service of the power grid are met.
Taking a telemetering daily report form in the line report form as an example, the line telemetering daily report form generally includes 24-hour period values, maximum value moments, minimum values, minimum value moments and average values of three-phase currents, active power, reactive power, power factors and other measuring points of the current line measuring and controlling device. When an engineer designs a report manually, firstly, an empty daily report needs to be generated, and then data binding is carried out on the cells. When data is bound, measuring points such as A-phase current, B-phase current, C-phase current, active power P, reactive power Q, power factor COS and the like in the current line measuring and controlling device need to be selected from a database, and then statistical attributes of the measuring points, such as segment values, current values, maximum value moments, minimum values, minimum value moments, average values and the like, are selected. When selecting the measuring points from the database, engineers are required to search the measuring points one by one, and the efficiency is very low.
The types of reports for a typical substation typically include daily reports, weekly reports, ten-day reports, monthly reports, quarterly reports, and yearly reports. Each report type generally comprises a line report, a main transformer report, a bus coupler report, a capacitor report, a reactor report, a station transformer report and the like. The reports are generated one by one manually by engineers, sometimes the reports need to be modified and adjusted for many times in engineering application to meet the requirements of users, and the report design efficiency is low.
Disclosure of Invention
The invention aims to provide a method and a device for automatically generating a plant station monitoring system report, which are used for solving the problems of inaccurate measuring point selection and low report design efficiency in manual report design.
In order to solve the technical problem, the invention provides an automatic generation method of a plant monitoring system report, which comprises the following solutions:
the first method scheme comprises the following steps:
1) the method comprises the steps of obtaining type fields, description fields and voltage grades of intervals to which devices belong in a database of a plant station monitoring system, classifying the devices according to different types according to the type fields of the devices, storing the devices into device containers of corresponding types, wherein the stored content comprises the description fields and the voltage grade attributes of the devices, and then classifying and storing the devices according to different voltage grades under different types; the device container is a storage area for storing corresponding data;
2) traversing a plant monitoring system database according to the types of the measuring points matched by the device, associating the measuring points found in the plant monitoring system database with the device matched with the measuring points, and storing the information of the measuring points into a device container associated with the measuring points;
3) automatically generating a report of the corresponding device type according to the selected device type; or automatically generating a report of the corresponding device under the corresponding voltage grade according to the selected device type and the voltage grade of the device.
And in a second method scheme, on the basis of the first method scheme, before generating the report in the step 3), a step of selecting a report type is further included, wherein the report type at least comprises one of a daily report, a weekly report, a ten-day report, a monthly report, a quarterly report and a yearly report, and the report of each device under the corresponding report type is automatically generated according to the selected report type, or the report of each device under the corresponding voltage level under the corresponding report type is automatically generated.
In a third method scheme, on the basis of the first method scheme, the types of the devices in the step 1) comprise a circuit device, a main transformer device, a bus device, a capacitor device and a reactor device, and device containers corresponding to the types are respectively a circuit device container, a main transformer device container, a bus device container, a capacitor device container and a reactor device container.
Based on the first, second and third method schemes, respectively, the measuring points in the step 2) comprise remote measuring points and remote signaling measuring points, and when a report is generated in the step 3), the report of the remote measuring points and the report of the remote signaling measuring points are correspondingly generated according to the statistical attributes of the remote measuring points or the remote signaling measuring points; the statistical attributes of the remote measuring points at least comprise one of the current value, the maximum value moment, the minimum value moment and the average value of the segment values, and the statistical attributes of the remote measuring points at least comprise one of the current value, the deflection times, the input time, the cutting times and the cutting time of the segment values.
A seventh method scheme, wherein on the basis of the sixth method scheme, the telemetering measurement points of the line device and the main transformer device comprise current, phase voltage, line voltage, active power, reactive power and power factor; the telemetering measuring point of the bus coupler only comprises current; the remote measuring points of the bus device comprise current and line voltage; the telemetering points of the capacitor device comprise current, line voltage and reactive power; the telemetering points of the reactor device comprise current, line voltage and active power.
And on the basis of the sixth method scheme, remote signaling measuring points of the circuit device, the main transformer device, the bus coupler device, the capacitor device and the reactor device at least comprise one of a circuit breaker, an isolation disconnecting link and a grounding disconnecting link.
In order to solve the technical problem, the invention also provides an automatic generation device for the plant monitoring system report, which comprises the following solutions:
the first device comprises a processor for executing instructions for implementing the following steps:
1) the method comprises the steps of obtaining type fields, description fields and voltage grades of intervals to which devices belong in a database of a plant station monitoring system, classifying the devices according to different types according to the type fields of the devices, storing the devices into device containers of corresponding types, wherein the stored content comprises the description fields and the voltage grade attributes of the devices, and then classifying and storing the devices according to different voltage grades under different types; the device container is a storage area for storing corresponding data;
2) traversing a plant monitoring system database according to the types of the measuring points matched by the device, associating the measuring points found in the plant monitoring system database with the device matched with the measuring points, and storing the information of the measuring points into a device container associated with the measuring points;
3) automatically generating a report of the corresponding device type according to the selected device type; or automatically generating a report of the corresponding device under the corresponding voltage grade according to the selected device type and the voltage grade of the device.
And in a second device scheme, on the basis of the first device scheme, before generating the report in the step 3), a step of selecting a report type is further included, wherein the report type at least comprises one of a daily report, a weekly report, a ten-day report, a monthly report, a quarterly report and a yearly report, and the report of each device under the corresponding report type is automatically generated according to the selected report type, or the report of each device under the corresponding voltage level under the corresponding report type is automatically generated.
And (3) according to a third device scheme, on the basis of the first device scheme, the types of the devices in the step 1) comprise a circuit device, a main transformer device, a bus coupler device, a bus device, a capacitor device and a reactor device, and device containers corresponding to the types are respectively a circuit device container, a main transformer device container, a bus coupler device container, a bus device container, a capacitor device container and a reactor device container.
The device comprises a device scheme IV, a device scheme V and a device scheme IV, wherein on the basis of the device scheme I, the device scheme II and the device scheme III, the measuring points in the step 2) comprise remote measuring points and remote signaling points, and when a report is generated in the step 3), the report of the remote measuring points and the report of the remote signaling points are correspondingly generated according to the statistical attributes of the remote measuring points or the remote signaling points; the statistical attributes of the remote measuring points at least comprise one of the current value, the maximum value moment, the minimum value moment and the average value of the segment values, and the statistical attributes of the remote measuring points at least comprise one of the current value, the deflection times, the input time, the cutting times and the cutting time of the segment values.
On the basis of the sixth device scheme, the telemetering measurement points of the line device and the main transformer device comprise current, phase voltage, line voltage, active power, reactive power and power factor; the telemetering measuring point of the bus coupler only comprises current; the remote measuring points of the bus device comprise current and line voltage; the telemetering points of the capacitor device comprise current, line voltage and reactive power; the telemetering points of the reactor device comprise current, line voltage and active power.
And on the basis of the sixth device scheme, remote signaling measuring points of the circuit device, the main transformer device, the bus coupler device, the capacitor device and the reactor device at least comprise one of a circuit breaker, an isolation disconnecting link and a grounding disconnecting link.
The invention has the beneficial effects that:
the invention stores each device in different types according to different voltage grades, searches out the measuring points matched with the device in the database, stores the measuring point information into the corresponding device container, and generates the report of the device or the report of the device in the corresponding voltage grade according to the selected device type or the voltage grade of the device, thereby realizing the automatic generation of the report and improving the working efficiency of the report generation.
Furthermore, the types of the generated reports are divided into daily reports, weekly reports, ten-day reports, monthly reports, quarterly reports and annual reports according to the time periods, and users can select the reports in the corresponding time periods according to requirements, so that statistical analysis can be conveniently performed on the information of the device types in different time ranges.
Further, the types of the device are at least divided into a line device, a main transformer device, a bus coupler device, a bus device, a capacitor device and a reactor device, device containers corresponding to the types are respectively a line device container, a main transformer device container, a bus coupler device container, a bus device container, a capacitor device container and a reactor device container, namely, the types are divided according to the specific device, the devices of different types are stored in the corresponding device containers and are respectively stored, and the devices are convenient to search in time.
Drawings
FIG. 1 is a flowchart of a report generation method according to an embodiment of the present invention;
FIG. 2 is a configuration diagram of the "type" field of the interval to which the device that needs to generate reports belongs;
FIG. 3 is a field configuration diagram of the 'detailed type' of the remote measuring point for generating report in the device needing generating report;
FIG. 4 is a field configuration diagram of the remote signaling point for generating reports in the device needing to generate reports;
FIG. 5 is a classified storage diagram of total station measurement and control devices;
fig. 6 is a flowchart for automatically generating a daily report of a total station line device;
FIG. 7 is a diagram of a report generation result file tree.
Detailed Description
The technical solution in the embodiments of the present invention will be clearly and completely described below with reference to the accompanying drawings in the embodiments of the present invention. All other embodiments, which can be obtained by a person skilled in the art without any inventive step based on the embodiments of the present invention, are within the scope of the present invention.
The first embodiment is as follows:
the invention discloses an automatic generation method of a factory station monitoring system report, which comprises the following steps:
classifying the devices according to different types according to the type fields, the description fields and the voltage levels of intervals to which the devices belong in a database of the plant monitoring system and according to the numerical values of the fields of the devices, storing the devices into device containers of corresponding types, wherein the stored contents comprise the description fields and the voltage level attributes of the devices, and then classifying and storing the devices according to different voltage levels under different types, wherein the device containers are storage areas for storing corresponding data.
Traversing the plant monitoring system database according to the types of the measuring points matched by the device, associating the measuring points found in the plant monitoring system database with the device matched with the measuring points, and storing the information of the measuring points into a device container associated with the measuring points. And automatically generating a report of the corresponding device type according to the selected device type, or automatically generating a report of the corresponding device under the corresponding voltage level according to the selected device type and the voltage level of the device.
The invention can realize automatic generation of the report, and an engineer can generate report files of all equipment in the total station by only configuring the types of the intervals and the related measuring points in the database and selecting the request for generating the report according to the requirements and carrying out a plurality of steps of operation. The report generation method greatly shortens the time of an engineer designing the report and improves the working efficiency.
Before generating the report, the method also comprises a step of selecting a report type, wherein the report type at least comprises one of a daily report, a weekly report, a ten-day report, a monthly report, a quarterly report and a yearly report, and the report of each device under the corresponding report type is automatically generated according to the selected report type or the report of each device under the corresponding voltage grade under the corresponding report type is automatically generated. The user can select the report forms in the corresponding time periods according to the requirements, and the statistical analysis of the device type information in different time ranges is facilitated.
The invention also provides an automatic generation device of the plant station monitoring system report, which comprises a processor and is used for executing the instructions for realizing the following steps:
1) classifying the devices according to different types according to the type fields, the description fields and the voltage levels of the intervals to which the devices belong in a database of the plant monitoring system and the type fields of the devices, storing the devices into device containers of corresponding types, wherein the stored content comprises the description fields and the voltage level attributes of the devices, and then classifying and storing the devices according to different voltage levels in different types;
2) traversing a plant monitoring system database according to the types of the measuring points matched by the device, associating the measuring points found in the plant monitoring system database with the device matched with the measuring points, and storing the information of the measuring points into a device container associated with the measuring points;
3) automatically generating a report of the corresponding device type according to the selected device type; or automatically generating a report of the corresponding device under the corresponding voltage grade according to the selected device type and the voltage grade of the device.
The automatic generation device of the factory station monitoring system report is a computer solution based on the method flow, namely a software framework, and can be applied to a computer, and the device is a processing process corresponding to the method flow. The above-described method will not be described in detail since it is sufficiently clear and complete.
Example two:
the substation related to the embodiment is composed as follows:
voltage class: 220kV, 110kV and 10 kV;
the main transformer measurement and control device: measuring and controlling the high-voltage side of a No. 1 main transformer, the medium-voltage side of the No. 1 main transformer, the low-voltage side of the No. 1 main transformer, the high-voltage side of a No. 2 main transformer, the medium-voltage side of the No. 2 main transformer and the low-voltage side of the No. 2 main transformer;
220kV measurement and control device: the method comprises the following steps of 220kV line 1 measurement and control, 220kV line 2 measurement and control, 220kV bus coupler measurement and control and 220kV bus measurement and control;
110kV measurement and control device: the system comprises a 110kV line 1 measurement and control unit, a 110kV line 2 measurement and control unit, a 110kV line 3 measurement and control unit, a 110kV line 4 measurement and control unit, a 110kV bus coupler measurement and control unit and a 110kV bus measurement and control unit;
10kV measurement and control device: the measurement and control are carried out on a 10kV line 1, a 10kV line 2, a 10kV line 3, a 10kV line 4, a 10kV capacitor and a 10kV reactor.
Taking the generation of reports of all measurement and control devices in the total station as an example, a general flow of the report generation method is shown in fig. 1, and referring to fig. 1, the report generation method provided by the embodiment of the present invention may include the following steps:
The "type" field of the interval to which the line device belongs is configured as a "line interval", the "type" field of the interval to which the master device belongs is configured as a "master interval", the "type" field of the interval to which the bus device belongs is configured as a "bus interval", the "type" field of the interval to which the capacitor device belongs is configured as a "capacitor interval", the "type" field of the interval to which the reactor device belongs is configured as a "reactor interval", and the "type" field of the interval to which the station-use.
The "detail type" field for the point at which the report is generated should also be configured as is practical. The "detail type" field of the telemetry station is configured as follows: the "detailed type" field at measuring point Ia (Ib/Ic) should be configured as "a-phase current (B-phase current/C-phase current)", the "detailed type" field at measuring point Uab (Ubc/Uca) should be configured as "AB-phase voltage (BC-phase voltage/CA-phase voltage)", the "detailed type" field at measuring point P should be configured as "active power", the "detailed type" field at measuring point Q should be configured as "reactive power", and the "detailed type" field at measuring point COS should be configured as "power factor". The "detail type" field of the telemetry point is configured as follows: the 'detailed type' field of the measuring point circuit breaker is configured to be 'circuit breaker', the 'detailed type' field of the measuring point isolation switch is configured to be 'isolation switch', and the 'detailed type' field of the measuring point grounding switch is configured to be 'grounding switch'.
The "type" attribute configuration of the total station interval is shown in fig. 2. The attribute configuration of the 'detailed type' of the relevant measuring point of the device is configured according to the actual situation. The configuration of the relevant remote measuring and remote signalling measuring points of the measuring and controlling device of the 220kV line 1 is shown in the attached figures 3 and 4. The configuration method of other measurement and control devices is the same as that of the measurement and control device of the 220kV line 1.
And 2, forming a report type list by the report types needing to be generated. In this embodiment, the selected report types are daily report, weekly report, ten-day report, monthly report, quarterly report, and yearly report, and these report types may be selected singly or in multiple ways.
And 3, forming a device list by the devices needing to generate the report, wherein the device list refers to the selected protection and measurement and control devices of the transformer substation for generating the report, and the device list comprises a line device, a main transformer device, a bus coupler device, a capacitor device, an electric reactor device, a station transformer device and the like. In this embodiment, the device list is classified and composed as shown in fig. 5.
And 4, designing different statistical attribute options according to different report types, namely the remote measurement report and the remote signaling report, wherein the statistical attribute options comprise the statistical attributes of the remote measurement report and the statistical attributes of the remote signaling report. In this embodiment, the statistical attribute option of the telemetry report selects "segment value, current value", "maximum value time", "minimum value time", and "average value". The statistical attribute option of the remote signaling report selects a segment value, a current value, a deflection frequency, an input time, an excision frequency and an excision time. The segment value is a value obtained by dividing a time period (one day, one month, one year, etc.) into a plurality of segments and displaying the value of a certain remote measuring (remote signaling) point in the segments in a report. Often, a day is divided into 24 hours, a month is divided into 30 (or 28, 31) days, and a year is divided into 12 months. Current value refers to the telemetry (telemetry) value at the beginning of the time of the segment.
And 5, designing different target matching measuring points according to different types of the devices, wherein the target matching measuring points comprise target matching measuring points of the remote measurement report and target matching measuring points of the remote communication report.
The target matching measuring points of the remote measurement report are as follows: target matching measuring points of the line and main transformer telemetering report comprise currents (Ia, Ib and Ic), phase voltages (Ua, Ub and Uc), line voltages (Uab, Ubc and Uca), active power P, reactive power Q, a power factor COS and the like; target matching measuring points of the bus coupler telemetering report generally only have current (Ia, Ib and Ic); target matching measuring points of the bus device telemetering report comprise currents (Ia, Ib and Ic), line voltages (Uab, Ubc and Uca) and the like; target matching measuring points of the capacitor device remote measuring report comprise currents (Ia, Ib and Ic), line voltages (Uab, Ubc and Uca), reactive power Q and the like; target matching measuring points of the reactor device remote measuring report comprise currents (Ia, Ib and Ic), line voltages (Uab, Ubc and Uca), active power P and the like; the target matching measuring points of the station variable device remote measuring report comprise current (Ia, Ib and Ic), line voltage (Uab, Ubc and Uca), active power P and the like.
The target matching measuring points of the remote signaling report are as follows: target matching measuring points of remote signaling reports of all devices (except bus devices) comprise measuring points of a circuit breaker, an isolation disconnecting link, a grounding disconnecting link, a handcart and the like. The bus plant typically does not generate a telemetry report.
For example, the target matching measuring points of the remote signaling reports of the main transformer device, the 220kV line device, the 220kV bus coupler device, the 110kV line device and the 110kV bus coupler device are as follows: the circuit breaker, the isolation disconnecting link and the grounding disconnecting link; the target matching measuring points of the remote signaling reports of the 10kV line device, the capacitor device and the reactor device are as follows: the handcart, the isolation disconnecting link and the grounding disconnecting link; the bus plant typically does not generate a telemetry report.
And 6, selecting different report generation methods according to different types of devices. The generation method of the report of the line device, the capacitor device and the reactor device selects to generate the report according to the voltage grade or the device type, the generation method of the report of the main transformer device selects to generate the report according to the main transformer number or the device type, and the generation method of the report of the bus connector device selects to put the bus connectors of all the voltage grades together to generate the report or generates the report according to the device type. The generating method of the bus device report forms selects that bus devices of all voltage levels are put together to generate the report forms or generate the report forms according to the device types.
And 7, automatically creating a total-station report according to the selected report type list, the selected device list, the selected statistical attribute options, the selected target matching measuring points and the selected report generating method. Taking the automatic generation of the daily report of the line device as an example, the specific creation process is as follows, referring to fig. 6.
(1) And sorting and storing the selected device list. The classification process is as follows:
a) reading a plant monitoring database, acquiring a 'type' field, a 'description' field and a voltage grade of an interval to which a selected device belongs, classifying the selected device according to the numerical value of the 'type' field, and storing the device and the 'description' and voltage grade attributes to which the device belongs in a classified manner into a line device container, a main transformer device container, a bus connection device container, a bus device container, a capacitor device container, a reactor device container, a station transformer device container and the like. The interval may have a variety of attributes, which are represented by fields. The "type" field of an interval is a description of the interval type, and the "description" field of an interval is a description of an interval. For example, the type field of the number 1 main transformer interval is the main transformer interval, the numerical value of the field is the character string main transformer interval, the type field of the 220kV line interval is the line interval, the numerical value of the field is the character string line interval, the type field of the 220kV bus interval is the bus interval, the numerical value of the field is the character string bus interval, and so on.
b) And according to the container category, the storage is subdivided, and the storage is subdivided according to the voltage class or the main transformer number. When the storage is subdivided according to the voltage grades: the line device container, the capacitor device container, the reactor device container, and the station transformer container are classified according to the voltage class to which the devices in the containers belong, and stored.
When the storage is subdivided according to the main transformer serial number: for a main transformer device container, subdividing a main transformer device according to a description field of devices in the container, and putting devices of each main transformer number together; the main transformer devices with different main transformer numbers are stored in a classified mode.
(2) And searching actual measuring points corresponding to the target matching measuring points matching all the devices. The process of finding the matching measuring point is as follows:
a) target match points (as designed) for a single device are obtained.
b) And searching actual measuring points corresponding to the matched target matching measuring points in a plant station monitoring database according to the target matching measuring points. The search process is as follows:
b1) and searching a plant station monitoring database, and acquiring all remote measuring (remote signaling) measuring points belonging to the device.
b2) Traversing the remote measuring (remote signaling) measuring points of the device, comparing the detailed type fields of the target matching measuring points and the traversed measuring points, finding the measuring points if the comparison results are consistent, and terminating traversal. The comparison rule is as follows:
the current Ia of the target matching measuring point corresponds to the A-phase current of the detailed field value of the actual measuring point (similarly to the current Ib and Ic of the target matching measuring point);
the target matching measuring point 'phase voltage Ua' corresponds to a 'detailed type' field value 'A phase voltage' (the target matching measuring point 'phase voltage Ub' and the 'phase voltage Uc' are similar to the above) of an actual measuring point;
the target matching measuring point 'phase voltage Uab' corresponds to the 'detailed type' field value 'AB phase voltage' (the target matching measuring point 'phase voltage Ubc' and the 'phase voltage Uca') of the actual measuring point;
the target matching measuring point 'active power P' corresponds to the 'detailed type' field value 'active power' of the actual measuring point;
the target matching measuring point 'reactive power Q' corresponds to the 'detailed type' field value 'reactive power' of the actual measuring point;
the target matching station "power factor COS" corresponds to the "detailed type" field value "power factor" of the actual station.
b3) And circularly traversing until all the actual measuring points corresponding to the target matching measuring points are found. And associating the searched measuring point meeting the conditions with the device and storing the measuring point into a container where the device is located.
c) And circularly traversing until the actual measuring points corresponding to the target matching measuring points of all the devices are found and stored.
(3) According to the selected report generation method, generating the total-station report in a circulating mode, wherein the process is as follows:
and determining the selected report type, wherein the selected report type can be one or more of a daily report, a weekly report, a ten-day report, a monthly report, a quarterly report and a yearly report, and taking the selected daily report as an example to generate a line report, a main transformer report, a bus coupler report, a bus bar report, a capacitor report, a reactor report and a station transformer report.
When generating the line report, the report can be generated according to the voltage grade or the type of the device. When a report is generated according to the voltage level, reading all devices under a certain voltage level in a container for storing the line device, and generating a line device remote measurement and remote signaling daily report of the voltage level according to actual measuring points associated with the devices and selected statistical attribute options. By repeating the steps, the line device telemetering and remote signaling daily reports of other voltage grades can be generated. When the report is generated according to the device type, reading a line device in a container for storing the line device, and generating a remote measurement and remote signaling daily report of the line device according to the actual measuring point associated with the line device and the selected statistical attribute option. By repeating the steps, a report of the telemetry and the telemetry of other line devices can be generated.
When the main transformer report is generated, the report can be generated according to the main transformer number or the type of the device. When the report is generated according to the main transformer number, the devices with the same number are read in a container for storing the main transformer devices, and the remote measurement and remote signaling daily report of the numbered main transformer devices is generated according to the actual measuring points associated with each device and the selected statistical attribute options. And repeating the steps to generate remote measurement and remote signaling daily reports of other numbering main transformers. When the report is generated according to the device type, a main transformer device is read in a container for storing the main transformer device, and a remote measurement and remote signaling daily report of the main transformer device is generated according to actual measuring points associated with the device and selected statistical attribute options. And repeating the steps to generate remote measurement and remote signaling daily reports of other main transformers.
When generating the bus-tie report, the bus-tie devices of all voltage levels are put together to generate the report, or the report is generated according to the device types. When the bus coupler devices of all voltage levels are placed together to generate a report, all the bus coupler devices are read in a container for storing the bus coupler devices, and a remote measurement and remote signaling daily report of the total station bus coupler device is generated according to actual measuring points associated with the devices and selected statistical attribute options. When the report is generated according to the device type, reading one bus coupler device in a container for storing the bus coupler device, and generating a remote measurement and remote signaling daily report of the bus coupler device according to the actual measuring point associated with the device and the selected statistical attribute option. Repeating the steps can generate remote measuring and remote signaling daily reports of other bus-coupled devices.
The generating method of the bus report is the same as that of the bus-coupled report, and the generating methods of the capacitor report, the reactor report and the station variable report are respectively the same as those of the line report.
When other report types are selected, such as monthly report or annual report, the above is repeated correspondingly
And (4) obtaining the content of the step (3).
The other devices and report types are created similarly, and the generated result is shown in fig. 7.
The invention automatically queries the database according to the report type, device, measuring point type, measuring point statistical attribute and other conditions selected by the user, searches for the measuring points matched with the relevant report to be generated, and quickly generates the daily report of the whole substation by applying the industrial report plug-in. The embodiment of the invention realizes the rapid automatic generation of the report forms, reduces the workload of the report form generation, and has wide engineering application value.
Claims (14)
1. A plant station monitoring system report automatic generation method is characterized by comprising the following steps:
1) the method comprises the steps of obtaining type fields, description fields and voltage grades of intervals to which protection and measurement and control devices belong in a database of a plant station monitoring system, classifying the devices according to different types according to the type fields of the devices, storing the devices into device containers of corresponding types, wherein the stored contents comprise the description fields and the voltage grade attributes of the devices, and then classifying and storing the devices according to different voltage grades under different types; the device container is a storage area for storing corresponding data;
2) traversing a plant monitoring system database according to the types of the measuring points matched by the device, associating the measuring points found in the plant monitoring system database with the device matched with the measuring points, and storing the information of the measuring points into a device container associated with the measuring points;
3) automatically generating a report of the corresponding device type according to the selected device type; or automatically generating a report of the corresponding device under the corresponding voltage grade according to the selected device type and the voltage grade of the device.
2. The method for automatically generating reports of a plant monitoring system according to claim 1, further comprising a step of selecting a report type before generating the report in step 3), wherein the report type at least comprises one of a daily report, a weekly report, a ten-day report, a monthly report, a quarterly report and a yearly report, and the reports of the devices corresponding to the report type are automatically generated according to the selected report type, or the reports of the devices corresponding to the report type at the corresponding voltage levels are automatically generated.
3. The method for automatically generating the plant monitoring system report according to claim 1, wherein the types of the devices in the step 1) comprise a line device, a main transformer device, a bus coupler device, a bus device, a capacitor device and a reactor device, and the device containers corresponding to the types are a line device container, a main transformer device container, a bus coupler device container, a bus device container, a capacitor device container and a reactor device container respectively.
4. The method for automatically generating the plant monitoring system report according to the claim 1 or 2, characterized in that the measuring points in the step 2) comprise remote measuring points and remote signaling points, and when the report is generated in the step 3), the report of the remote measuring points and the report of the remote signaling points are correspondingly generated according to the statistical attributes of the remote measuring points or the remote signaling points; the statistical attributes of the remote measuring points at least comprise one of the current value, the maximum value moment, the minimum value moment and the average value of the segment values, and the statistical attributes of the remote measuring points at least comprise one of the current value, the deflection times, the input time, the cutting times and the cutting time of the segment values.
5. The method for automatically generating the plant station monitoring system report according to claim 3, wherein the measuring points in the step 2) comprise remote measuring points and remote signaling points, and when the report is generated in the step 3), the report of the remote measuring points and the report of the remote signaling points are correspondingly generated according to the statistical attributes of the remote measuring points or the remote signaling points; the statistical attributes of the remote measuring points at least comprise one of the current value, the maximum value moment, the minimum value moment and the average value of the segment values, and the statistical attributes of the remote measuring points at least comprise one of the current value, the deflection times, the input time, the cutting times and the cutting time of the segment values.
6. The method according to claim 5, wherein the remote measurement points of the line device and the main transformer device comprise current, phase voltage, line voltage, active power, reactive power and power factor; the telemetering measuring point of the bus coupler only comprises current; the remote measuring points of the bus device comprise current and line voltage; the telemetering points of the capacitor device comprise current, line voltage and reactive power; the telemetering points of the reactor device comprise current, line voltage and active power.
7. The method for automatically generating the plant monitoring system report according to claim 5, wherein the remote signaling points of the line device, the main transformer device, the bus coupler device, the capacitor device and the reactor device at least comprise one of a circuit breaker, an isolation switch and a grounding switch.
8. An automatic generation device for factory station monitoring system report forms is characterized by comprising a processor and a report generation module, wherein the processor is used for executing instructions for realizing the following steps:
1) the method comprises the steps of obtaining type fields, description fields and voltage grades of intervals to which protection and measurement and control devices belong in a database of a plant station monitoring system, classifying the devices according to different types according to the type fields of the devices, storing the devices into device containers of corresponding types, wherein the stored contents comprise the description fields and the voltage grade attributes of the devices, and then classifying and storing the devices according to different voltage grades under different types; the device container is a storage area for storing corresponding data;
2) traversing a plant monitoring system database according to the types of the measuring points matched by the device, associating the measuring points found in the plant monitoring system database with the device matched with the measuring points, and storing the information of the measuring points into a device container associated with the measuring points;
3) automatically generating a report of the corresponding device type according to the selected device type; or automatically generating a report of the corresponding device under the corresponding voltage grade according to the selected device type and the voltage grade of the device.
9. The plant monitoring system report automatic generation device according to claim 8, further comprising a step of selecting a report type before generating the report in step 3), wherein the report type at least comprises one of a daily report, a weekly report, a ten-day report, a monthly report, a quarterly report, and a yearly report, and the report of each device under the corresponding report type is automatically generated according to the selected report type, or the report of each device under the corresponding voltage class is automatically generated according to the selected report type.
10. The plant monitoring system report automatic generation device according to claim 8, wherein the types of the devices in step 1) include a line device, a main transformer device, a bus coupler device, a bus device, a capacitor device and a reactor device, and the device containers corresponding to the types are a line device container, a main transformer device container, a bus coupler device container, a bus device container, a capacitor device container and a reactor device container, respectively.
11. The plant monitoring system report automatic generation device according to claim 8 or 9, characterized in that the measuring points in step 2) comprise remote measuring points and remote signaling points, and when generating a report in step 3), a report of the remote measuring points and a report of the remote signaling points are correspondingly generated according to statistical attributes of the remote measuring points or the remote signaling points; the statistical attributes of the remote measuring points at least comprise one of the current value, the maximum value moment, the minimum value moment and the average value of the segment values, and the statistical attributes of the remote measuring points at least comprise one of the current value, the deflection times, the input time, the cutting times and the cutting time of the segment values.
12. The plant monitoring system report automatic generation device according to claim 10, wherein the measuring points in step 2) comprise remote measuring points and remote signaling points, and when the report is generated in step 3), the report of the remote measuring points and the report of the remote signaling points are also generated correspondingly according to the statistical attributes of the remote measuring points or the remote signaling points; the statistical attributes of the remote measuring points at least comprise one of the current value, the maximum value moment, the minimum value moment and the average value of the segment values, and the statistical attributes of the remote measuring points at least comprise one of the current value, the deflection times, the input time, the cutting times and the cutting time of the segment values.
13. The plant monitoring system report automatic generation device of claim 12, wherein the telemetry stations of the line devices and the main transformer devices comprise current, phase voltage, line voltage, active power, reactive power and power factor; the telemetering measuring point of the bus coupler only comprises current; the remote measuring points of the bus device comprise current and line voltage; the telemetering points of the capacitor device comprise current, line voltage and reactive power; the telemetering points of the reactor device comprise current, line voltage and active power.
14. The plant monitoring system report automatic generation device of claim 12, wherein the remote signaling points of the line device, the main transformer device, the bus coupler device, the capacitor device and the reactor device each comprise at least one of a circuit breaker, an isolation switch and a grounding switch.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201711002790.7A CN107944659B (en) | 2017-10-24 | 2017-10-24 | Method and device for automatically generating plant station monitoring system report |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201711002790.7A CN107944659B (en) | 2017-10-24 | 2017-10-24 | Method and device for automatically generating plant station monitoring system report |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN107944659A CN107944659A (en) | 2018-04-20 |
| CN107944659B true CN107944659B (en) | 2020-11-17 |
Family
ID=61936454
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201711002790.7A Active CN107944659B (en) | 2017-10-24 | 2017-10-24 | Method and device for automatically generating plant station monitoring system report |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN107944659B (en) |
Families Citing this family (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110096503B (en) * | 2019-03-22 | 2023-04-18 | 重庆长安汽车股份有限公司 | Analysis method and system for white vehicle body three-coordinate measuring point data |
| CN110727427A (en) * | 2019-10-14 | 2020-01-24 | 国网江苏省电力有限公司镇江供电分公司 | Intelligent safety checking method for dispatching automation master station model |
| CN112445796B (en) * | 2020-11-02 | 2024-03-01 | 许继集团有限公司 | New energy station report generation method |
| CN112799736B (en) * | 2021-01-19 | 2024-01-12 | 南京隆远电气技术有限公司 | Dynamic binding loading method for electrical primary graph mode identification |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104808615A (en) * | 2015-03-03 | 2015-07-29 | 国家电网公司 | Method of automatically generating power device monitoring information table |
| CN106451764A (en) * | 2016-08-31 | 2017-02-22 | 杭州申昊科技股份有限公司 | Transformer station monitoring method |
| CN106570784A (en) * | 2016-11-04 | 2017-04-19 | 广东电网有限责任公司电力科学研究院 | Integrated model for voltage monitoring |
Family Cites Families (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20140070004A1 (en) * | 2012-09-11 | 2014-03-13 | Carttronics, Llc | System and method for inventory counting control |
-
2017
- 2017-10-24 CN CN201711002790.7A patent/CN107944659B/en active Active
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104808615A (en) * | 2015-03-03 | 2015-07-29 | 国家电网公司 | Method of automatically generating power device monitoring information table |
| CN106451764A (en) * | 2016-08-31 | 2017-02-22 | 杭州申昊科技股份有限公司 | Transformer station monitoring method |
| CN106570784A (en) * | 2016-11-04 | 2017-04-19 | 广东电网有限责任公司电力科学研究院 | Integrated model for voltage monitoring |
Non-Patent Citations (2)
| Title |
|---|
| 变电站自动化监控系统的设计;刘会宾;《中国优秀硕士学位论文 工程科技II辑》;20120315(第3期);C042-395 * |
| 电网调度自动化系统中报表自动生成和打印程序的设计和实现;朱建华;《计算机工程与设计》;19921027(第5期);56-61 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN107944659A (en) | 2018-04-20 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN110795921B (en) | Automatic generation and verification method for monitoring information of intelligent substation equipment | |
| CN107944659B (en) | Method and device for automatically generating plant station monitoring system report | |
| WO2023115842A1 (en) | Data-driven offline and online integrated simulation system and method for power distribution network | |
| CN102522819A (en) | Record wave pattern modeling method for fault record device of intelligent transformer substation | |
| CN111159365B (en) | Implementation method, system and storage medium of scheduling model ontology intelligent question-answering system | |
| CN111160868A (en) | Unified distribution network frame topology construction method based on graph fusion technology | |
| CN110852023B (en) | Automatic generation method and device for primary main wiring diagram of intelligent substation | |
| CN109408960B (en) | Method and system for automatically generating intelligent transformer substation main wiring diagram based on SCD | |
| CN110046391A (en) | Transforming plant primary wiring diagram automatic generation method based on monitoring information table | |
| CN110825834B (en) | Method, system and readable storage medium for matching distribution transformer association of metering automation terminal data and GIS (gas insulated switchgear) | |
| CN111340327A (en) | Main and auxiliary integrated load analysis platform and implementation method thereof | |
| CN112288303A (en) | Method and device for determining line loss rate | |
| CN108037343A (en) | A kind of voltage monitoring Management System Data deepens analysis method | |
| CN103887792B (en) | A kind of low-voltage distribution network modeling method containing distributed power source | |
| CN105528671A (en) | Power grid multidimensional sensing and safety assessment system and method on the basis of big data | |
| CN105938506A (en) | Graph visualization system for power grid power flow analysis | |
| CN111241488B (en) | Distribution network protection fixed value setting system based on full information data flow | |
| CN102856896A (en) | On-line analytical method for direct-current transmission loss | |
| CN108490282B (en) | Method and system for presetting alarm test data of intelligent substation | |
| CN106202814B (en) | The mapping method of automatic safety device acquisition data and EMS system primary equipment model | |
| CN105914732A (en) | High-voltage power grid theoretical line loss evaluation system | |
| CN105719199A (en) | Method for information detection of high voltage transmission network line losses based on power flow method | |
| CN104767281B (en) | A kind of high voltage distribution network topological Simplification method | |
| Wang et al. | A new load survey method and its application in component based load modeling | |
| CN114049082A (en) | Power grid technical improvement overhaul cost data structuring method |
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 | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |