CN102081664A - Method for processing information data in automatic system of transformer substation - Google Patents

Abstract

The invention discloses a method for processing information data in an automatic system of a transformer substation, comprising the following steps of: inputting point table data in an on-site telemechanical apparatus into an excel file; saving data input to the excel file to be in an ini format and storing the data in a disc; converting the data with the ini format into data with a def format and storing in the disc; reading the data with the def format from the disc when a system is started up, and loading the data as real-time data; in the operating process of the system, modifying the real-time data on line in real-time library tool software, and saving the modified real-time data with the def format; converting the data with the def format into data with the ini format, and then opening the data with the ini format in the excel file for checking and modifying. The method has the advantages of greatly simplifying the inputting process of point table data in the automatic system of the transformer substation, improving the standardability and the accuracy of data, increasing the efficiency and saving the labor cost.

Description

A method for processing information and data in a substation automation system

technical field

The invention relates to the field of electric power automation systems, and mainly refers to a "four-remote" information data processing method in a substation automation system. the

Background technique

Substation automation system, also known as SCADA (Supervisory Control And Data Acquisition) system, is a "data acquisition and monitoring control" system. It is to realize the automatic monitoring, measurement, control and adjustment of the substation by using computer technology and modern communication technology to realize the automatic monitoring, measurement, control and adjustment of the substation's secondary equipment (including control, signal, measurement, protection, automatic device, telecontrol, etc.) through function combination and optimized design. A comprehensive automation system. In the transformation and construction of urban and rural power grids in my country, a large number of new automation technologies have been adopted, which has greatly improved the modernization level of power grid construction, enhanced the possibility of power transmission and distribution and grid dispatching, and reduced the total cost of substation construction. This has become an indisputable fact. the

Due to the relatively large amount of data communication required when the system is running, it is mainly the collection, processing, and transmission control of the "four remote" information data. The "four remote" information data is the basic data in the SCADA system, which is based on the telecontrol device installed on site. It needs to be entered manually and then imported into the system. The data volume is huge and error-prone. According to a 110KV substation, there may be thousands of "four remote" data, and there are about 10 attributes associated with a point, and there will be tens of thousands of data inputs. For large substations or centralized control stations, the point table data is even greater. the

The so-called "four remotes" is the abbreviation of "telemetry, remote signaling, remote control, remote adjustment" technology, "telemetry" refers to the system technology that uses electronic technology to measure and display analog quantities such as current, voltage, power, pressure, temperature, etc. "Remote signaling" refers to the remote monitoring of electrical switches and equipment, the working status and operation status of mechanical equipment, etc., "remote control" refers to remote control or protection of electrical equipment, such as the opening and closing of the working status, "remote adjustment" is Refers to remotely setting and adjusting the working parameters and standard parameters of the controlled equipment. In the power system, the function of "four remotes" is realized by the terminal RTU of the telecontrol system, and the data of "four remotes" is also called "point table" data. the

In the prior art, for the processing of "point table" data, it is mostly manually entered as a txt file, an excel file, or a text file in other formats, and then the SCADA system reads the data in the corresponding format file and converts the "point table "The data is imported and saved in the real-time database for processing when the system is running. The defects of the known technology are: (1) in the "point table" data entry process, the amount of data is huge and error-prone, and it is difficult to find after making a mistake. (2) After the "point table" data is imported into the SCADA system, when adding or modifying data, it is often necessary to re-enter the data into the file of the corresponding format, and then import it into the SCADA system. The operation process is complicated, and the " The "point table" data has poor interaction with the "point table" data stored in the file, resulting in repeated work and low efficiency. the

Contents of the invention

The purpose of the present invention is to provide a method for processing information data in a substation automation system, so as to solve the problem of "point table" that is easy to make mistakes during the entry process of "point table" information data, difficult to find after making an error, complicated operation process, and manually entered into a file. "The data has poor interaction with the "point table" data in the real-time database, and the data entry efficiency is low. the

In order to achieve the above object, the technical solution of the present invention is: a kind of information data processing method in substation automation system, it comprises the steps:

(1) Enter the point table data in the field telecontrol device into the excel file;

(2) Save the data entered in excel as data in ini format and store it on the disk;

(3) Convert the data in the ini format to the data in the def format and store it in the disk;

(4) When the substation automation system starts, read the data in def format from the disk, and load it as real-time data for system operation;

(5) During the operation of the system, the real-time data is modified online in the real-time library tool software, and the modified real-time data is saved in def format;

(6) Convert the def format data into ini format data, and then use excel to open the ini format data for viewing and modification. the

As a concrete example, in the above step (1), enter the same type of data of the same type of RTU device in a sheet in the excel file. the

As a concrete example, in the above step (1), in a sheet, a row of data represents the attribute information of a point. the

As an improvement, in the above step (2), when the data in the excel is saved as ini format data, an error checking mechanism is provided to check the standardization and accuracy of the data. the

As an improvement, in the above step (3), the substation automation system is equipped with a module for mutual conversion between the data in the ini format and the data in the def format. the

As a concrete example, in the above step (4), when the substation automation system is started, the data in def format is loaded and stored in the real-time database for use when the system is running. the

As a concrete example, in the above step (5), the real-time library tool software modifies the point table data in the real-time database during system operation, and converts the modified def format data into ini format data. the

Compared with the prior art, adopting the method described in the present invention, using excel as a development platform, utilizing its powerful editing function and carrying out function expansion can greatly simplify the entry process of "point table" data, and improve the data processing efficiency. Standardization and accuracy improve efficiency and save labor costs. In particular, it solves the problem that the point table data in large substations or centralized control stations is huge and difficult to process efficiently and accurately, simplifies the operation mode of massive "four remote" information data, improves efficiency, and increases the "four remote" information data in SCADA The accuracy in the system greatly saves labor costs. the

Description of drawings

Fig. 1 is the work flowchart of the present invention. the

Detailed ways

The present invention will be further described in detail below in conjunction with the accompanying drawings and specific embodiments. the

An information data processing method in a substation automation system of the present invention, in the power station automation system, the working process of the method is as follows:

Enter the point table data in the field remote control device into the excel file, and you can manually enter the point table data. And enter the same type of data of the same type of RTU device in a sheet in the excel file. For example, enter telematics data into one sheet and telemetry data into the same sheet. In a sheet, a row of data represents the attribute information of a point. For example, telemetry point, its attribute information includes "point number, point name, point enable, offset, unit type, upper limit of value range, next value range, lower limit of alarm, upper limit of alarm" and other information. the

The invention uses Microsoft's excel tool as a development platform, utilizes macro technology, and performs functional expansion on its original powerful editing and processing functions. Save the data entered into excel in the previous step as data in ini format and store it on the disk. An error checking mechanism is set up in this system to check the standardization and accuracy of the data. the

In the substation automation system, there is a module for mutual conversion between data in ini format and data in def format. Therefore, inputting conversion commands in CMD can directly perform mutual conversion, that is, convert data in ini format to data in def format and store it on the disk. middle. the

When the substation automation system is started, the def format data is read from the disk and loaded as real-time data for system operation. During the operation of the SCADA system, the real-time data is modified online in the real-time library tool software, and the modified real-time data is saved in def format and stored in the disk. Finally, convert the def format data into ini format data, and then use excel to open the ini format data for viewing and modification. the

Adopt the method described in the present invention, and use excel as development platform, utilize its powerful editing function and carry out function expansion, can make the input process of " point table " data greatly simplify, and have improved the standardization of data, accuracy, Improve efficiency and save labor costs. In particular, it solves the problem that the point table data in large substations or centralized control stations is huge and difficult to process efficiently and accurately, simplifies the operation mode of massive "four remote" information data, improves efficiency, and increases the "four remote" information data in SCADA The accuracy in the system greatly saves labor costs. the

Claims (7)

1. the information data disposal route in the electric substation automation system is characterized in that described method comprises the steps:

(1) the some table data in the on-the-spot telemechanical apparatus is entered in the excel file;

(2) data of importing among the excel are saved as the deposit data of ini form at disk;

(3) data with the ini form are converted to the deposit data of def form in disk;

From disk, read the data of def form when (4) electric substation automation system starts, load, use for system's operation as real time data;

(5) in system's operational process, in the tool software of storehouse real time data is being carried out online modification in real time, amended real time data saves as the def form;

(6) convert the def formatted data to the ini formatted data, the data of opening the ini form with excel are checked and are revised then.

2. the information data disposal route in the electric substation automation system according to claim 1 is characterized in that, in above-mentioned steps (1), and same type data of the same type RTU device of typing among the sheet in the excel file.

3. the information data disposal route in the electric substation automation system according to claim 2 is characterized in that, in above-mentioned steps (1), in a sheet, data line is represented the attribute information of a point.

4. the information data disposal route in the electric substation automation system according to claim 1, it is characterized in that, in above-mentioned steps (2), when the data among the excel save as the ini formatted data, be provided with bug check mechanism, carry out data standard, accuracy testing.

5. the information data disposal route in the electric substation automation system according to claim 1 is characterized in that, in above-mentioned steps (3), is provided with the module that the data of the data of ini form and def form transform mutually in electric substation automation system.

6. the information data disposal route in the electric substation automation system according to claim 1, it is characterized in that, in above-mentioned steps (4), load the data of def form when electric substation automation system starts, deposit real-time data base in, use when moving to make system.

7. the information data disposal route in the electric substation automation system according to claim 6, it is characterized in that, in above-mentioned steps (5), system's real-time storehouse in service tool software is revised the some table data in the real-time data base, and amended def formatted data is converted to the ini formatted data.

Images