CN112989451B - Point table automatic generation method based on secondary system digital software - Google Patents
Point table automatic generation method based on secondary system digital software Download PDFInfo
- Publication number
- CN112989451B CN112989451B CN202110371908.3A CN202110371908A CN112989451B CN 112989451 B CN112989451 B CN 112989451B CN 202110371908 A CN202110371908 A CN 202110371908A CN 112989451 B CN112989451 B CN 112989451B
- Authority
- CN
- China
- Prior art keywords
- point table
- signal
- information point
- information
- interval
- 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
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F30/00—Computer-aided design [CAD]
- G06F30/10—Geometric CAD
- G06F30/12—Geometric CAD characterised by design entry means specially adapted for CAD, e.g. graphical user interfaces [GUI] specially adapted for CAD
-
- 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/24—Querying
- G06F16/245—Query processing
- G06F16/2457—Query processing with adaptation to user needs
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F18/00—Pattern recognition
- G06F18/20—Analysing
- G06F18/24—Classification techniques
- G06F18/241—Classification techniques relating to the classification model, e.g. parametric or non-parametric approaches
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06V—IMAGE OR VIDEO RECOGNITION OR UNDERSTANDING
- G06V30/00—Character recognition; Recognising digital ink; Document-oriented image-based pattern recognition
- G06V30/40—Document-oriented image-based pattern recognition
- G06V30/42—Document-oriented image-based pattern recognition based on the type of document
- G06V30/422—Technical drawings; Geographical maps
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Computer Vision & Pattern Recognition (AREA)
- Geometry (AREA)
- Data Mining & Analysis (AREA)
- General Engineering & Computer Science (AREA)
- Evolutionary Computation (AREA)
- Artificial Intelligence (AREA)
- Human Computer Interaction (AREA)
- Computational Mathematics (AREA)
- Bioinformatics & Cheminformatics (AREA)
- Multimedia (AREA)
- Architecture (AREA)
- Bioinformatics & Computational Biology (AREA)
- Evolutionary Biology (AREA)
- Life Sciences & Earth Sciences (AREA)
- Mathematical Analysis (AREA)
- Mathematical Optimization (AREA)
- Pure & Applied Mathematics (AREA)
- Computer Hardware Design (AREA)
- Computational Linguistics (AREA)
- Databases & Information Systems (AREA)
- Emergency Protection Circuit Devices (AREA)
Abstract
The invention has proposed a point table automatic generation method based on the digitized software of secondary system, utilize the digitized software of secondary system to set up the apparatus of the converting station and soft message database of the protective device at first, then classify and label the signal, and record the label into CAD drawing as the loop number, after the drawing is finished, can withdraw signal and label information in CAD drawing through the digitized software, record the information point table automatically according to certain form, and realize the automatic form filling of the signal classification column in the information point table according to the signal label, finish the information point table of the signal part of hard contact and record; in addition, the protection device type is directly used as an index, and the protection soft message information is obtained from a soft message database which is established in advance and is recorded into an information point table, so that the information point table recording of partial signals of the soft message is completed; and finally, formatting according to a format required by a regulation and control end, exporting an information point table which can be directly used by a regulation and control system, and finishing automatic generation of the information point table.
Description
Technical Field
The invention relates to a data processing method in secondary system digital software, in particular to a point table automatic generation method based on the secondary system digital software.
Background
The secondary system digital software mainly adopts commercial secondary system digital software based on an AutoCAD platform in engineering practice, and is different from common AutoCAD software in that specific information in a CAD drawing can be extracted through recognizable icons or character blocks, and the secondary system digital software is provided with a database, and can be used for developing various application functions by processing data, such as transformer substation secondary system auxiliary design software provided by Shanghai Xin electric company.
The transformer substation information point table in the existing secondary system digital software is a table covering remote signaling, remote control and remote regulation information in a transformer substation, and is usually edited according to a fixed format, wherein the format is determined by an SCADA software function module in a regulation and control system. The information point table is an important information link for uploading the real-time information of the transformer substation to the regulation and control system, is a data base of the regulation and control SCADA system, and has important significance for the construction of the transformer substation. However, in the prior art, because the designer and the equipment are main providers of the point table data, and the point table data are difficult to be uniformly butted on the data, the transformer substation information point table is usually finished by a drawing to be designed, and then a designer manually extracts required information data from a CAD drawing, manually fills the required information data into a specified point table, and the whole process depends on manual work to finish compiling. The information points of the transformer substation are thousands of and huge, particularly for a large 500kV transformer substation, the number of the information points can be tens of thousands, the large information amount completely depends on manual compilation, the working efficiency is low, the error probability is high, and the subsequent information point-to-point debugging work is very unfavorable.
Disclosure of Invention
The invention aims to provide the automatic point table generating method based on the secondary system digital software, which avoids a large amount of work, improves the design efficiency and accuracy, and is convenient and quick to operate according to the defects of the prior art.
The purpose of the invention is realized by the following ways:
the point table automatic generation method based on the secondary system digital software is characterized by comprising the following steps:
1) in a new project of secondary system digital software based on an AutoCAD platform, equipment configuration at different intervals in the project is completed, and interval information is extracted, wherein the interval information comprises an interval name, and the name and the model of secondary equipment configured at the corresponding interval;
2) the method comprises the steps that the types of protection devices in secondary equipment are used as indexes, a soft message information point table library of all protection devices with different types is established, the soft message information point table library comprises soft message signal names and soft message signal classifications, and soft message signal classification marks comprise abnormal signals and fault signals;
3) selecting one of the intervals n, and letting n = 1;
4) the remote signaling signals in interval n are classified and identified as follows: dividing the remote signaling signals into three categories of displacement, abnormity and fault, wherein the displacement type signal is marked as BWm, the abnormity type signal is marked as YCm, and the fault type signal is marked as GZm, wherein m =01, 02, 03, …;
5) drawing a signal principle design drawing by using secondary system digital software, inputting remote signaling signal contents, and inputting the classification identification in the step 2) as a loop number;
6) extracting the name of the interval n, the type of the remote signaling signal, the identification of the remote signaling signal and the loop number information from a database of the digital design software of the secondary system; automatically writing the extracted information into an information point table in an excel file format according to the format required by the information point table;
7) automatically classifying the signals in the information point list according to the remote signaling signal identification, wherein the identification with BW corresponds to deflection, the identification with YC corresponds to abnormality, and the identification with GZ corresponds to failure, so as to finish the input of the hard contact part information point list;
8) obtaining the model of the protection device configured at the interval n, searching the corresponding soft message signal classification from the protection device soft report library, obtaining the corresponding soft message and inputting an information point table, and completing the information point table input of the soft message part; thus completing the automatic entry of all the information point tables at the interval n;
9) judging whether all the interval information is recorded completely, if so, entering the step 10), and if not, enabling n = n +1 and returning to the step 4);
10) and processing all the information point tables after the input, and deriving the information point tables which can be directly used for the input of the regulation and control end.
In summary, the invention provides a method for automatically generating a dot table based on secondary system digital software, and compared with the prior art, the method has the following main advantages:
1. the automatic generation of the information point table based on the secondary system digital software is realized, the process of manually extracting the signal information in the drawing again to compile the point table after the CAD drawing design is finished is avoided, and the design efficiency is greatly improved;
2. the information point table not only needs to input signal names, but also needs to classify signals, the manual signal classification workload is large, and errors are easy to occur.
3. Aiming at the soft message information only related to the model, the soft message database is established and the automatic input information point table is directly extracted, so that the method is convenient and quick, and the soft messages of the devices with the same model can be repeatedly used in different engineering information point tables.
Drawings
Fig. 1 is a schematic flow chart of a method for automatically generating a point table based on secondary system digital software according to the present invention.
The present invention will be further described with reference to the following examples.
Detailed Description
The best embodiment is as follows:
referring to fig. 1, the method for automatically generating a point table based on the secondary system digital software comprises the following steps:
1) the method comprises the steps of utilizing secondary system digitizing software (which is different from common AutoCAD software in that specific information in CAD drawings can be extracted through recognizable icons or character blocks and a database of the software is provided, such as euphotic software) based on an AutoCAD platform to build a project and complete equipment configuration of different intervals, including the interval name, the name and the model of secondary equipment of corresponding interval configuration, and the like.
2) The model of the protection device is used as an index, and a soft message information point table library of different types of protection devices is established, wherein the soft message information point table library comprises soft message signal names and classifications (the classification comprises two types: an anomaly or fault).
3) Selecting an interval n of a certain type (line, bus coupler, main transformer and bus equipment), and enabling n = 1;
4) and classifying and identifying the remote signaling related to the interval n. Signals are classified into three categories, namely displacement type signals are marked as BWm (m =01, 02, 03, …), abnormal type signals are marked as YCm (m =01, 02, 03, …), and fault type signals are marked as GZm (m =01, 02, 03, …).
5) Drawing a signal principle design drawing by using secondary system digital software, recording signal contents, and recording the classification identification in the step 2) as a loop number.
6) And extracting the name, the signal content and the signal identification (namely the loop number) information of the interval n from a database of the digital design software of the secondary system.
7) And automatically writing the extracted information into the information point table in the excel file format according to the format required by the information point table.
8) And automatically classifying the signals in the information point list according to the signal identification, wherein the BW identification corresponds to deflection, the YC identification corresponds to abnormality, and the GZ identification corresponds to failure, so that the entry of the hard contact part information point list is completed.
9) And acquiring the model of the interval protection device configured at the interval n.
10) And searching the corresponding model from the protection device soft report library, acquiring the corresponding soft message, and inputting the information point table to complete the information point table input of the soft message part.
11) And (4) judging whether all the information at all intervals is recorded, if so, entering the next step, otherwise, enabling n = n +1, and returning to the step (4).
12) And formatting the completed information point table and exporting the formatted information point table to be directly used for the regulation and control end to input the information point table.
The invention has proposed a point table automatic generation method based on the digitized software of secondary system, utilize the digitized software of secondary system to set up the apparatus of the converting station and soft message database of the protective device at first, then classify and label the signal, and record the label into CAD drawing as the loop number, after the drawing is finished, can withdraw signal and label information in CAD drawing through the digitized software, record the information point table automatically according to certain form, and realize the automatic form filling of the signal classification column in the information point table according to the signal label, finish the information point table of the signal part of hard contact and record; in addition, the protection device type is directly used as an index, and the protection soft message information is obtained from a soft message database which is established in advance and is recorded into an information point table, so that the information point table recording of partial signals of the soft message is completed; and finally, formatting according to a format required by a regulation and control end, exporting an information point table which can be directly used by a regulation and control system, and finishing automatic generation of the information point table.
The parts of the invention not described are the same as the prior art.
Claims (1)
1. The automatic point table generating method based on the secondary system digital software is characterized by comprising the following steps of:
1) in a new project of secondary system digital software based on an AutoCAD platform, equipment configuration at different intervals in the project is completed, and interval information is extracted, wherein the interval information comprises an interval name, and the name and the model of secondary equipment configured at the corresponding interval;
2) the method comprises the steps that the types of protection devices in secondary equipment are used as indexes, a soft message information point table library of all protection devices with different types is established, the soft message information point table library comprises soft message signal names and soft message signal classifications, and soft message signal classification marks comprise abnormal signals and fault signals;
3) selecting one of the intervals n, and letting n = 1;
4) the remote signaling signals in interval n are classified and identified as follows: dividing the remote signaling signals into three categories of displacement, abnormity and fault, wherein the displacement type signal is marked as BWm, the abnormity type signal is marked as YCm, and the fault type signal is marked as GZm, wherein m =01, 02, 03, …;
5) drawing a signal principle design drawing by using secondary system digital software, inputting remote signaling signal content, and inputting the soft message signal classification identification in the step 2) as a loop number;
6) extracting the name of the interval n, the type of the remote signaling signal, the identification of the remote signaling signal and the loop number information from a database of the digital design software of the secondary system; automatically writing the extracted name of the interval n, the type of the remote signaling signal, the identification of the remote signaling signal and the loop number information into an information point table in an excel file format according to the format required by the information point table;
7) automatically classifying the signals in the information point list according to the remote signaling signal identification, wherein the identification with BW corresponds to deflection, the identification with YC corresponds to abnormality, and the identification with GZ corresponds to failure, so as to finish the input of the hard contact part information point list;
8) obtaining the model of the protection device configured at the interval n, searching the corresponding soft message signal classification from the protection device soft report library, obtaining the corresponding soft message and inputting an information point table, and completing the information point table input of the soft message part; thus completing the automatic entry of all the information point tables at the interval n;
9) judging whether all the interval information is recorded completely, if so, entering the step 10), and if not, enabling n = n +1 and returning to the step 4);
10) and processing all the information point tables which are recorded and finished, and deriving the information point tables which can be directly recorded by a regulation and control end.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110371908.3A CN112989451B (en) | 2021-04-07 | 2021-04-07 | Point table automatic generation method based on secondary system digital software |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110371908.3A CN112989451B (en) | 2021-04-07 | 2021-04-07 | Point table automatic generation method based on secondary system digital software |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN112989451A CN112989451A (en) | 2021-06-18 |
| CN112989451B true CN112989451B (en) | 2022-05-24 |
Family
ID=76339351
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202110371908.3A Active CN112989451B (en) | 2021-04-07 | 2021-04-07 | Point table automatic generation method based on secondary system digital software |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN112989451B (en) |
Families Citing this family (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN114915639B (en) * | 2022-05-06 | 2024-04-05 | 华润新能源(阜新)风能有限公司 | Method, device, electronic equipment and medium for analyzing message of power dedicated scheduling channel |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US5625798A (en) * | 1994-02-24 | 1997-04-29 | Knc, Inc. | Method and system extracting attribute information corresponding to components included in a computer aided design system drawing such as a process and instrumentation diagram |
| US6516326B1 (en) * | 2000-10-30 | 2003-02-04 | Stone And Webster Consultants, Inc. | System and method for integrating electrical power grid and related data from various proprietary raw data formats into a single maintainable electrically connected database |
| CN104318027A (en) * | 2014-10-29 | 2015-01-28 | 国家电网公司 | Information table template based closed-loop automatic interaction model information table design method |
| CN105427041A (en) * | 2015-11-18 | 2016-03-23 | 国网山西省电力公司 | Standardized maintenance method for reconstruction and extension information point table of running substation |
-
2021
- 2021-04-07 CN CN202110371908.3A patent/CN112989451B/en active Active
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US5625798A (en) * | 1994-02-24 | 1997-04-29 | Knc, Inc. | Method and system extracting attribute information corresponding to components included in a computer aided design system drawing such as a process and instrumentation diagram |
| US6516326B1 (en) * | 2000-10-30 | 2003-02-04 | Stone And Webster Consultants, Inc. | System and method for integrating electrical power grid and related data from various proprietary raw data formats into a single maintainable electrically connected database |
| CN104318027A (en) * | 2014-10-29 | 2015-01-28 | 国家电网公司 | Information table template based closed-loop automatic interaction model information table design method |
| CN105427041A (en) * | 2015-11-18 | 2016-03-23 | 国网山西省电力公司 | Standardized maintenance method for reconstruction and extension information point table of running substation |
Non-Patent Citations (5)
| Title |
|---|
| 一种基于模板的配电终端信息点表自动生成方案;韦戈山 等;《电子技术与软件工程》;20200102(第24期);全文 * |
| 一种智能变电站设备监控信息点表自动配置方法的研究与实现;贺延峰 等;《自动化应用》;20191125(第11期);全文 * |
| 仿真主站在智能变电站二次系统调试中的应用;王磊等;《电力科学与工程》;20170828(第08期);全文 * |
| 基于CSGC3000的配电自动化点表导入软件优化;陈国茜 等;《湖南电力》;20171025;全文 * |
| 基于设备信息一体化的监控信息点表管理;范杰等;《价值工程》;20170128(第03期);全文 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN112989451A (en) | 2021-06-18 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN101118515B (en) | Automatically testing method and apparatus for list | |
| CN102331967B (en) | Method for managing chip verification test cases | |
| CN109359950B (en) | Method for overall process control of power grid monitoring information | |
| CN107844466B (en) | System and method for automatically generating fault recording file analysis model | |
| CN107292769B (en) | Substation reconstruction and extension configuration consistency comparison and verification method based on RCD | |
| CN112287648B (en) | Substation monitoring system data point table generation and synchronization method based on SCD | |
| CN102436523A (en) | Method for automatically mapping digital substation interval wiring diagram | |
| CN114221312B (en) | Power distribution network protection rapid setting and checking method based on topological relation | |
| EP4095676A1 (en) | Safe interlocking data conversion method for formal verification and translator | |
| CN112989451B (en) | Point table automatic generation method based on secondary system digital software | |
| CN105528736A (en) | Interval figure automatic generation method based on intelligent layout arrangement | |
| CN106383734A (en) | Method for extracting detailed design from codes | |
| CN103913672A (en) | Satellite low-frequency interface automatic testing system | |
| CN111510355A (en) | Automatic sequence test system and method for CAN communication of whole vehicle | |
| CN114936442B (en) | System and method for accurately positioning power distribution network equipment and forming topological graph | |
| CN117614115A (en) | Substation debugging and acceptance checking system and method based on artificial intelligence | |
| CN110674623A (en) | Reading system and method for modeled embedded part positioning information | |
| CN113239016B (en) | Database design assistance apparatus and method | |
| CN116341047A (en) | Simulation system for bridge planning design | |
| CN109639520B (en) | Computer-aided test method for network communication of reactor protection system | |
| CN111274355A (en) | Lucene-based main plant station remote signaling signal automatic comparison method | |
| CN113377952A (en) | Automatic generation method for filing number of electronic file for quality test of water conservancy and hydropower engineering | |
| CN113050925A (en) | Intelligent contract repairing method and device for block chain | |
| CN112838675A (en) | Intelligent substation telecontrol alarm information acceptance system and method | |
| Kong et al. | The visualization technology of the UHVDC control and protection system based on deep learning |
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 |