CN102081664A - Method for processing information data in automatic system of transformer substation - Google Patents
Method for processing information data in automatic system of transformer substation Download PDFInfo
- Publication number
- CN102081664A CN102081664A CN2011100226625A CN201110022662A CN102081664A CN 102081664 A CN102081664 A CN 102081664A CN 2011100226625 A CN2011100226625 A CN 2011100226625A CN 201110022662 A CN201110022662 A CN 201110022662A CN 102081664 A CN102081664 A CN 102081664A
- Authority
- CN
- China
- Prior art keywords
- data
- def
- ini
- automation system
- electric substation
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Images
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
Technical field
The present invention relates to the power automatic system field, mainly be meant a kind of " four is distant " information data disposal route in electric substation automation system.
Background technology
Electric substation automation system has another name called SCADA (Supervisory Control And DataAcquisition) system, promptly is " DAM control " system.Be that secondary device (comprising control, signal, measurement, protection, aut.eq., telemechanical etc.) with transformer station utilizes computer technology, modern communication technology; by function combinations and optimal design, realize a kind of comprehensive automated system that transformer station is monitored automatically, measures, controls and adjusts.Also adopt the robotization new technology in a large number in China's upgrading urban and rural power grids and in building, thereby improved the modernization level of power grid construction greatly, strengthened the possibility of power transmission and distribution and dispatching of power netwoks, reduced the total cost of transformer substation construction, this has become undisputable fact.
Because system's needed data communication amount of when operation is bigger, mainly be to " four is distant " information data acquisition process, send control etc." four is distant " information data is the master data in the SCADA system, is to come according to field erected telemechanical apparatus, needs typing manually then in the import system, and data volume is huge and make mistakes easily.According to the transformer station of a 110KV, its " four is distant " data probably have thousands of, and the attribute of some association probably has about 10, then has data input quantity up to ten thousand.Corresponding large-scale substation or those some table data wherein of concentrator station are huge especially.
So-called " four is distant " is the abbreviation to " remote measurement, remote signalling, remote control, remote regulating " technology; " remote measurement " is meant the systems technology of utilizing an electronic technology distant place to measure analog quantitys such as centralized displaying such as electric current, voltage, power, pressure, temperature; " remote signalling " is meant the duty of remote monitoring electric switch and equipment, plant equipment and working order state etc.; " remote control " is meant the duties such as deciliter start-stop of distant place control or protection electrical equipment, and " remote regulating " is meant that a distant place is set and the adjustment apparatus operating parameters of controlling, canonical parameter etc." four is distant " function is to be realized by telecontrol system terminal RTU in electric system, and " four is distant " data also are " some table " data.
In the prior art, processing for " some table " data, the manual typing of many employings is txt file, excel file, perhaps in the text of extended formatting, the SCADA system reads the data in the corresponding format file then, and will " some table " data importing and be kept in the real-time data base so that handle during system's operation.The defective of known technology is: in (1) " some table " data typing process, data volume is huge and make mistakes easily, easy-to-search not after makeing mistakes.(2) after " some table " data importing SCADA system, when increasing or revise data, usually need logging data again in the file of corresponding format, and then importing SCADA system, " some table " data in the storehouse are poor with " some table " data interaction of storing in the file in real time in the numerous and diverse and system of operating process, cause the work of repetition, at the bottom of the efficient.
Summary of the invention
The purpose of this invention is to provide the information data disposal route in a kind of electric substation automation system, with solve make mistakes easily, make mistakes in " some table " information data typing process after not easy-to-search, operating process numerous and diverse, manually be entered into " some table " data in the file with " some table " problem that data interaction is poor, the data efficiency of inputting is low in the real-time storehouse.
For achieving the above object, technical scheme of the present invention is: the information data disposal route in a kind of electric substation automation system, it 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.
As specializing, in above-mentioned steps (1), same type data of the same type RTU device of typing among the sheet in the excel file.
As specializing, in above-mentioned steps (1), in a sheet, data line is represented the attribute information of a point.
As improvement, 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.
As improvement, in above-mentioned steps (3), in electric substation automation system, be provided with the module that the data of the data of ini form and def form transform mutually.
As specializing, in above-mentioned steps (4), when starting, electric substation automation system loads the data of def form, deposit real-time data base in, use when moving to make system.
As specializing, 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.
Compared with prior art, adopt method of the present invention, and excel as development platform, utilize its powerful editting function and carry out the function expansion, the typing process of " some table " data is simplified greatly, and improved standardization, the accuracy of data, improved efficient, saved human cost.Especially solved the huge problem that is difficult to the efficiently and accurately processing of some table data in large-scale substation or the concentrator station, simplified the mode of operation of magnanimity " four is distant " information data, improved efficient, increase the accuracy of " four is distant " information data in the SCADA system, saved human cost greatly.
Description of drawings
Fig. 1 is a workflow diagram of the present invention.
Embodiment
Below in conjunction with the drawings and specific embodiments the present invention is further elaborated.
Information data disposal route in a kind of electric substation automation system of the present invention, in described power station automation system, the course of work of this method is as follows:
Some table data in the on-the-spot telemechanical apparatus are entered in the excel file, can manual typing point table data.And same type data of the same type RTU device of typing among the sheet in the excel file.For example with among sheet of remote signalling data typing, among the same sheet of telemetry typing.And in a sheet, data line is represented the attribute information of a point.For example as telemetry station, its attribute information comprises information such as " period, roll-call, point enable, side-play amount, flat type, the codomain upper bound, codomain next time, low alarm limit, high alarm setting ".
The present invention as development platform, utilizes grand technology with the excel instrument of Microsoft, carries out the function expansion on its original powerful editing and processing function.Previous step is input to deposit data that the data of excel save as the ini form in rapid at disk, in native system, is provided with bug check mechanism, carry out data standard, accuracy testing.
In electric substation automation system, be provided with the module that the data of the data of ini form and def form transform mutually, therefore input transforms order and can directly transform form mutually in CMD, and the data that are about to the ini form are converted to the deposit data of def form in disk.
Electric substation automation system reads the data of def form from disk when starting, load as real time data, uses for system's operation.In the SCADA system 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, leaves in the disk.At last, 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.
Adopt method of the present invention, and excel as development platform, utilize its powerful editting function and carry out function expansion, the typing process of " some table " data is simplified greatly, and improved standardization, the accuracy of data, improved efficient, saved human cost.Especially solved the huge problem that is difficult to the efficiently and accurately processing of some table data in large-scale substation or the concentrator station, simplified the mode of operation of magnanimity " four is distant " information data, improved efficient, increase the accuracy of " four is distant " information data in the SCADA system, saved human cost greatly.
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.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2011100226625A CN102081664A (en) | 2011-01-20 | 2011-01-20 | Method for processing information data in automatic system of transformer substation |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2011100226625A CN102081664A (en) | 2011-01-20 | 2011-01-20 | Method for processing information data in automatic system of transformer substation |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN102081664A true CN102081664A (en) | 2011-06-01 |
Family
ID=44087625
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN2011100226625A Pending CN102081664A (en) | 2011-01-20 | 2011-01-20 | Method for processing information data in automatic system of transformer substation |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN102081664A (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111831382A (en) * | 2020-07-20 | 2020-10-27 | 杭州品茗安控信息技术股份有限公司 | Data entry method, device, equipment and medium for engineering cost software |
| CN112579589A (en) * | 2019-09-27 | 2021-03-30 | 钉钉控股（开曼）有限公司 | Information importing method and device |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20040205656A1 (en) * | 2002-01-30 | 2004-10-14 | Benefitnation | Document rules data structure and method of document publication therefrom |
| CN1838111A (en) * | 2006-02-14 | 2006-09-27 | 北京北大方正电子有限公司 | Method for editing file and recording modification mark |
| CN101520728A (en) * | 2008-02-25 | 2009-09-02 | 北京书生国际信息技术有限公司 | Method for processing document meeting document library standard by third-party software |
| CN101567065A (en) * | 2009-05-26 | 2009-10-28 | 杭州世导科技有限公司 | Cross-platform online file editing system and method thereof |
-
2011
- 2011-01-20 CN CN2011100226625A patent/CN102081664A/en active Pending
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20040205656A1 (en) * | 2002-01-30 | 2004-10-14 | Benefitnation | Document rules data structure and method of document publication therefrom |
| CN1838111A (en) * | 2006-02-14 | 2006-09-27 | 北京北大方正电子有限公司 | Method for editing file and recording modification mark |
| CN101520728A (en) * | 2008-02-25 | 2009-09-02 | 北京书生国际信息技术有限公司 | Method for processing document meeting document library standard by third-party software |
| CN101567065A (en) * | 2009-05-26 | 2009-10-28 | 杭州世导科技有限公司 | Cross-platform online file editing system and method thereof |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112579589A (en) * | 2019-09-27 | 2021-03-30 | 钉钉控股（开曼）有限公司 | Information importing method and device |
| CN112579589B (en) * | 2019-09-27 | 2024-02-27 | 钉钉控股（开曼）有限公司 | Information importing method and device |
| CN111831382A (en) * | 2020-07-20 | 2020-10-27 | 杭州品茗安控信息技术股份有限公司 | Data entry method, device, equipment and medium for engineering cost software |
| CN111831382B (en) * | 2020-07-20 | 2022-07-08 | 杭州品茗安控信息技术股份有限公司 | Data entry method, device, equipment and medium for engineering cost software |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN101923126B (en) | Automatic closed loop test method | |
| CN107317399B (en) | Visual automatic point aligning method for intelligent transformer substation | |
| CN102998562B (en) | Power quality monitoring system based on International Electrotechnical Commission (IEC) 61850 communication protocol | |
| CN102043719B (en) | Method for testing IEC61850 configuration description file | |
| CN103683511A (en) | Method and system for processing fault of integrated monitoring platform based on power distribution network | |
| CN103838921A (en) | PSCAD-EMTDC simulation model automatic generation method | |
| CN103151840A (en) | Communication method and device of IEC (international electrotechnical commission) 61850 system and non-IEC 61850 system | |
| CN112398079A (en) | Intelligent relay protection constant value modification and checking system and method | |
| CN103700024A (en) | Automatic importing method of provincial and prefectural integrated telecontrol information based on D5000 system | |
| CN103308808A (en) | System and method for testing secondary device of intelligent substation automatically | |
| CN103323686A (en) | Smart power grid power quality analyzer | |
| CN111668938B (en) | Method for realizing analog remote control of electric power measurement and control device | |
| CN111275210B (en) | Method and device for sharing account information of auxiliary equipment of transformer substation | |
| CN102081664A (en) | Method for processing information data in automatic system of transformer substation | |
| CN109374994A (en) | A kind of detection system suitable for protective relaying device | |
| CN110955808A (en) | Method for matching and associating four remote monitoring information of main plant station | |
| CN109685682A (en) | The method of regulator control system inspection operation ticket is intelligently generated based on relational database | |
| CN202524168U (en) | Power quality data monitoring device | |
| CN109656589A (en) | A kind of secondary equipment of intelligent converting station software harnesses method and system | |
| CN110992671B (en) | Ammeter address forwarding method, device and system and electronic equipment | |
| CN104199663A (en) | Comprehensive automated information table automatic generating method and system | |
| CN111596647B (en) | Efficient and intelligent test system and method for wind turbine generator | |
| CN104181489A (en) | Calibration system for substation alternating-current sampling and measuring device | |
| CN112670942A (en) | Distribution network system relay protection setting calculation and data management system | |
| CN109687984B (en) | Configuration system and configuration method of wind power SCADA system |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20110601 |
|
| RJ01 | Rejection of invention patent application after publication |