CN105243188B - A kind of intelligent substation monitoring information amount auto-screening method - Google Patents
A kind of intelligent substation monitoring information amount auto-screening method Download PDFInfo
- Publication number
- CN105243188B CN105243188B CN201510584076.8A CN201510584076A CN105243188B CN 105243188 B CN105243188 B CN 105243188B CN 201510584076 A CN201510584076 A CN 201510584076A CN 105243188 B CN105243188 B CN 105243188B
- Authority
- CN
- China
- Prior art keywords
- row
- keyword
- information
- contact point
- group
- 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
Classifications
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02E—REDUCTION OF GREENHOUSE GAS [GHG] EMISSIONS, RELATED TO ENERGY GENERATION, TRANSMISSION OR DISTRIBUTION
- Y02E60/00—Enabling technologies; Technologies with a potential or indirect contribution to GHG emissions mitigation
Landscapes
- Remote Monitoring And Control Of Power-Distribution Networks (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention discloses a kind of intelligent substation monitoring information amount auto-screening methods, this method is used to extract the monitoring information being required from virtual terminator table and control signal circuit CAD diagram and be integrated into an excel table, consequently facilitating grasping monitored substation operation situation.
Description
Technical field
The present invention relates to intelligent substation monitoring information treatment technology more particularly to a kind of intelligent substation monitoring information amounts
Auto-screening method.
Background technology
Develop with technology with the popularization of intelligent substation, State Grid Corporation of China creates substation and is all made of whole station Information Number
Word, networking intelligent substation.In intelligent substation design, because intelligent, digitlization and networking need, except conventional
Outside equipment, equipment needed for a large amount of intelligence (being required to double set configurations, network divides A, B net) is increased, increases smart machine in this way
Information and duplicate system retrofit facility information, the information content that need to be acquired growth more double than conventional substation.
Monitoring information table is needed comprising the virtual terminator information and the hard contact of device contacted between each network of intelligent substation
Signal.It is carried out in two steps currently, designing unit completes monitoring information table needs：First, to empty end derived from VisualSCD softwares
Sublist is screened, and usually manually to be screened from nearly ten thousand row informations amount virtual terminator table, selects desired signal information, and according to new
Call format form the Microsoft Excel that meets the requirements, wherein virtual terminator table is exported from VisualSCD softwares, format xls
Or xlsx, the virtual terminator table is divided into " playing point device " table area and " end device " table area, in described two tables
Contain " virtual terminator number " row, " virtual terminator definition " row and " title " row in lattice region, the VisualSCD softwares are to obtain intelligence
The intelligent Substation System Integrated design software of energy supervisory control of substation information, second is that being looked for from the control signal circuit CAD diagram
It is copied to hard contact information in the EXCEL information tables screened, the two, which merges, generates required complete monitoring information table, should
Method is screened by hand entirely, occupies the plenty of time, and data-handling efficiency is very low, while being obtained data and being easy error, and it is accurate to be unfavorable for
Monitoring and the monitored substation operation situation of grasp.
Invention content
The technical problem to be solved by the present invention is to accurately obtain monitoring information table, monitoring information table is obtained at present and takes craft
The method of screening, and this method is screened by hand entirely, occupies the plenty of time, data-handling efficiency is very low, while obtaining data and being easy
Error is unfavorable for accurately monitoring and grasping the substation operation situation that is monitored.
In order to solve problem above, the present invention provides a kind of intelligent substation monitoring information amount auto-screening method, packets
Include following steps：
Step 1: obtaining the first source file, first source file is the virtual terminator table；
Step 2: according to " title " column information of " end device " table area, first group key of the setting for screening
First group of keyword is only saved in one-dimensional comprising the keyword about ground residing for end device by word in first group of keyword
In array keyword (n), n is the first group of keyword number preserved, and when n is equal to zero, report an error prompt, no to then follow the steps
Three；
Step 3: according to " virtual terminator definition " column information in " rise point device " table area, setting for screening the
Two groups of keywords only include the information key defined about virtual terminator in second group of keyword, second group of keyword are protected
It is stored in one-dimension array Kw (m), m is the second group of keyword number preserved, and m is equal to n；When m is equal to zero, report an error prompt；Work as m
When not equal to zero, two-dimensional array H (b) is defined, assignment H (b) is { (keyword (1), Kw (1)), (keyword (2), Kw
(2)) ... (keyword (n), Kw (m)) }, wherein b is integer, and n≤b≤1 executes step 4；
Step 4: initialization b=1；
Step 5: reading the row information of the first source file line by line since the first row, wherein row information refers in every row
All data, when the row information of certain a line meets the keyword in two-dimensional array variable H (b), then the row " terminal is set
It is standby " in " virtual terminator definition " row in table area, leaves out " open into " character, later merge the data after the row rub-out character
Into " title " row in row " end device " table area, the filter information of the row is saved in First ray variable,
Wherein filter information includes：In " virtual terminator definition " row, " playing point device " table area in " playing point device " table area
" title " row in " end device " table area after " virtual terminator number " row and merging；
Step 6: b=b+1 executes step 5 if b is less than or equal to n；Otherwise, step 7 is executed；
Step 7: according to first group of keyword, extraction and first group of keyword pair from the control signal circuit CAD diagram
The hard contact point signal answered, and the CAD form documents of hard contact point signal are established, the CAD form documents output of hard contact point signal is turned
Turn to the excel form documents of hard contact point signal；
Step 8: using the excel form documents of hard contact point signal as the second source file, to the excel of hard contact point signal
Form document is read line by line, and row information is saved in the second sequence variables；
Step 9: the row information that First ray variable and the second sequence variables store is imported into an excel table one by one
In lattice and the excel tables are exported, which is required monitoring information table, for analyzing and grasping monitored change
The operating condition in power station.
Further, in step 9, the row information that First ray variable and the second sequence variables store is imported into one by one
In one excel table and the excel tables are exported, check whether the row information in the second sequence variables includes " spare p " word
Symbol, if including, increase p row tables after the row information, p represents spare line number.It takes this step, is in order in table
In leave spare row, in the case where there is a small amount of new information to occur, can be filled into spare row by artificial screening.
Further, in the step 2, first group of keyword includes 2 or more keywords.Pass through multiple keywords
Retrieval, improves the efficiency of data processing.
Further, in the step 7, according to multiple keywords in first group of keyword, from control signal circuit
Hard contact point signal corresponding from different keywords respectively is extracted in CAD diagram, and establishes the CAD tables of multiple hard contact point signals respectively
File respectively converts the output of the CAD form documents of hard contact point signal to the excel form documents of hard contact point signal；Step 8:
Using the excel form documents of multiple hard contact point signals as the second source file, to the excel form documents of multiple hard contact point signals
It reads line by line, and row information is saved in the second sequence variables.By multiple keyword retrievals, the effect of data processing is improved
Rate.
Compared with prior art, the beneficial effects of the invention are as follows：This method can be from virtual terminator table and control signal circuit
The monitoring information being required is extracted in CAD diagram and is integrated into an excel table, it is quick accurately to obtain monitoring information table,
Monitored substation operation situation is easily and accurately grasped, while realizing automatic data processing, improves data processing effect
Rate.
Description of the drawings
Existing virtual terminator table in Fig. 1 present invention.
The flow chart of Fig. 2 present invention.
Specific implementation mode
In conjunction with attached drawing, embodiments of the present invention are specifically described.
A kind of intelligent substation monitoring information amount auto-screening method, this method are used to return from virtual terminator table and control signal
The monitoring information being required is extracted in the CAD diagram of road and is integrated into an excel table, consequently facilitating grasping monitored power transformation
It stands operating condition, if Fig. 1, the virtual terminator table are exported from VisualSCD softwares, format is xls or xlsx, the virtual terminator
Table is divided into " playing point device " table area and " end device " table area, and " " empty end is contained in described two table areas
Son number " row, " virtual terminator definition " row and " title " row, wherein the VisualSCD softwares are to obtain intelligent substation monitoring letter
The intelligent Substation System Integrated design software of breath, this method comprises the following steps：
Step 1: obtaining the first source file, first source file is the virtual terminator table；
Step 2: according to " title " column information of " end device " table area, first group key of the setting for screening
Word, only comprising the keyword about ground residing for end device in first group of keyword, for example, " peace town ", first group of keyword
It is saved in one-dimension array keyword (n), n is the first group of keyword number preserved, and when n is equal to zero, report an error prompt, no
Then follow the steps three；
Step 3: according to " virtual terminator definition " column information in " rise point device " table area, setting for screening the
Two groups of keywords, only include the information key that is defined about virtual terminator in second group of keyword, such as " point remote signalling or
Second group of keyword is saved in one-dimension array Kw (m) by DI ", and m is the second group of keyword number preserved, and m is equal to n；Work as m
When equal to zero, report an error prompt；When m is not equal to zero, two-dimensional array H (b) is defined, assignment H (b) is { (keyword (1), Kw
(1)), (keyword (2), Kw (2)) ... (keyword (n), Kw (m)) }, wherein b is integer, and n≤b≤1 executes step 4；
Step 4: initialization b=1；
Step 5: reading the row information of the first source file line by line since the first row, wherein row information refers in every row
All data, when the row information of certain a line meets the keyword in two-dimensional array variable H (b), then the row " terminal is set
It is standby " in " virtual terminator definition " row in table area, leaves out " open into " character, later merge the data after the row rub-out character
Into " title " row in row " end device " table area, merging said herein refers to will be before the data of two row in same a line
After be placed in same row, the filter information of the row is saved in First ray variable, wherein filter information includes：" starting point is set
It is standby " " virtual terminator definition " row in table area, " virtual terminator number " row in " playing point device " table area and after merging
" title " row in " end device " table area；
Step 6: b=b+1 executes step 5 if b is less than or equal to n；Otherwise, step 7 is executed；
Step 7: according to first group of keyword, extraction and first group of keyword pair from the control signal circuit CAD diagram
The hard contact point signal answered, and the CAD form documents of hard contact point signal are established, the CAD form documents output of hard contact point signal is turned
Turn to the excel form documents of hard contact point signal；
Step 8: using the excel form documents of hard contact point signal as the second source file, to the excel of hard contact point signal
Form document is read line by line, and row information is saved in the second sequence variables；
Step 9: the row information that First ray variable and the second sequence variables store is imported into an excel table one by one
In lattice and the excel tables are exported, which is required monitoring information table, for analyzing and grasping monitored change
The operating condition in power station.
In order to leave spare row in the table, in the case where there is a small amount of new information to occur, can be filled out by artificial screening
It is charged in spare row, the step 9, the row information that First ray variable and the second sequence variables store is imported into one one by one
The excel tables are opened in excel tables and are exported, check whether the row information in the second sequence variables includes " spare p " character,
If including increasing p row tables after the row information, p represents spare line number, such as " spare 3 " character, if including this
Character then increases by 3 row tables after the row information.
In order to improve the efficiency of processing data, in the step 2, first group of keyword includes 2 or more keys
Word, such as " towns Jiao Shan He An " are extracted according to multiple keywords in first group of keyword from control signal circuit CAD diagram
Hard contact point signal corresponding from different keywords respectively, and the CAD form documents of multiple hard contact point signals are established respectively, it will connect firmly
The CAD form documents output of point signal is converted into the excel form documents of hard contact point signal；Step 8: multiple hard contacts are believed
Number excel form documents as the second source file, the excel form documents of multiple hard contact point signals are read line by line, and will
Row information is saved in the second sequence variables.
Claims (4)
1. a kind of intelligent substation monitoring information amount auto-screening method, this method is used for from virtual terminator table and control signal circuit
The monitoring information being required is extracted in CAD diagram and is integrated into an excel table, consequently facilitating grasping monitored substation
Operating condition, the virtual terminator table are exported from VisualSCD softwares, and format is xls or xlsx, and the virtual terminator table is divided into
" playing point device " table area and " end device " table area, contain " virtual terminator number " in described two table areas
Row, " virtual terminator definition " row and " title " row, wherein the VisualSCD softwares are to obtain intelligent substation monitoring information
Intelligent Substation System Integrated design software, which is characterized in that include the following steps：
Step 1: obtaining the first source file, first source file is the virtual terminator table；
Step 2: according to " title " column information of " end device " table area, first group keyword of the setting for screening,
Only include the keyword about ground residing for end device in first group of keyword, first group of keyword is saved in one-dimension array
In keyword (n), n is the first group of keyword number preserved, and when n is equal to zero, report an error prompt, otherwise executes step 3；
Step 3: according to " virtual terminator definition " column information in " playing point device " table area, setting is used for second group of screening
Keyword only includes the information key defined about virtual terminator in second group of keyword, second group of keyword is saved in
In one-dimension array Kw (m), m is the second group of keyword number preserved, and m is equal to n；When m is equal to zero, report an error prompt；As m etc.
When zero, two-dimensional array H (b) is defined, assignment H (b) is { (keyword (1), Kw (1)), (keyword (2), Kw (2)) ...
(keyword (n), Kw (m)) }, wherein b is integer, and n≤b≤1 executes step 4；
Step 4: initialization b=1；
Step 5: reading the row information of the first source file line by line since the first row, wherein row information refers to all in every row
Data, when the row information of certain a line meets the keyword in two-dimensional array variable H (b), then in " end device " table of the row
In " virtual terminator definition " row in lattice region, leaves out " open into " character, the data after the row rub-out character are merged into this later
In " title " row in row " end device " table area, the filter information of the row is saved in First ray variable, wherein
Filter information includes：" the empty end in " virtual terminator definition " row, " playing point device " table area in " playing point device " table area
" title " row in " end device " table area after son number " row and merging；
Step 6: b=b+1 executes step 5 if b is less than or equal to n；Otherwise, step 7 is executed；
Step 7: according to first group of keyword, extracted from the control signal circuit CAD diagram corresponding with first group of keyword
Hard contact point signal, and the CAD form documents of hard contact point signal are established, it converts the CAD form documents output of hard contact point signal to
The excel form documents of hard contact point signal；
Step 8: using the excel form documents of hard contact point signal as the second source file, to the excel tables of hard contact point signal
File is read line by line, and row information is saved in the second sequence variables；
Step 9: the row information that First ray variable and the second sequence variables store is imported into one by one in an excel table
And the excel tables are exported, which is required monitoring information table, for analyzing and grasping monitored substation
Operating condition.
2. a kind of intelligent substation monitoring information amount auto-screening method as described in claim 1, which is characterized in that step 9
In, the row information that First ray variable and the second sequence variables store is imported into an excel table and exported one by one should
Excel tables check whether the row information in the second sequence variables includes " spare p " character, if including, in the row information
Increase p row tables afterwards, p represents spare line number.
3. a kind of intelligent substation monitoring information amount auto-screening method as described in claim 1 or 2, which is characterized in that
In the step 2, first group of keyword includes 2 or more keywords.
4. a kind of intelligent substation monitoring information amount auto-screening method as claimed in claim 3, which is characterized in that step
Seven, according to multiple keywords in first group of keyword, extracted from the control signal circuit CAD diagram respectively from different keys
The corresponding hard contact point signal of word, and the CAD form documents of multiple hard contact point signals are established respectively, respectively by hard contact point signal
CAD form documents export the excel form documents for being converted into hard contact point signal；Step 8: by the excel of multiple hard contact point signals
Form document reads the excel form documents of multiple hard contact point signals, and row information is preserved line by line as the second source file
Into the second sequence variables.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510584076.8A CN105243188B (en) | 2015-09-14 | 2015-09-14 | A kind of intelligent substation monitoring information amount auto-screening method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510584076.8A CN105243188B (en) | 2015-09-14 | 2015-09-14 | A kind of intelligent substation monitoring information amount auto-screening method |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN105243188A CN105243188A (en) | 2016-01-13 |
| CN105243188B true CN105243188B (en) | 2018-09-14 |
Family
ID=55040836
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201510584076.8A Active CN105243188B (en) | 2015-09-14 | 2015-09-14 | A kind of intelligent substation monitoring information amount auto-screening method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN105243188B (en) |
Families Citing this family (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108073678B (en) * | 2017-11-06 | 2020-08-28 | 广东广业开元科技有限公司 | Document analysis processing method, system and device applied to big data analysis |
| CN111159980B (en) * | 2019-12-30 | 2023-11-17 | 潍柴动力股份有限公司 | Data conversion method and device |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103761395A (en) * | 2014-01-24 | 2014-04-30 | 福建省电力勘测设计院 | Method for generating dynamic report of virtual terminal of intelligent substation |
| CN103761681A (en) * | 2014-01-17 | 2014-04-30 | 国网四川省电力公司电力科学研究院 | Intelligent comparison method of SCD and Excel virtual terminal table of intelligent substation |
| CN104361189A (en) * | 2014-12-03 | 2015-02-18 | 国网四川省电力公司经济技术研究院 | Method for quickly generating virtual terminal Excel table by SCD (Security Coding Device) |
-
2015
- 2015-09-14 CN CN201510584076.8A patent/CN105243188B/en active Active
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103761681A (en) * | 2014-01-17 | 2014-04-30 | 国网四川省电力公司电力科学研究院 | Intelligent comparison method of SCD and Excel virtual terminal table of intelligent substation |
| CN103761395A (en) * | 2014-01-24 | 2014-04-30 | 福建省电力勘测设计院 | Method for generating dynamic report of virtual terminal of intelligent substation |
| CN104361189A (en) * | 2014-12-03 | 2015-02-18 | 国网四川省电力公司经济技术研究院 | Method for quickly generating virtual terminal Excel table by SCD (Security Coding Device) |
Non-Patent Citations (2)
| Title |
|---|
| 变电站智能化改造关键技术研究与实施;邵剑峰;《中国优秀硕士学位论文全文数据库 工程科技Ⅱ辑（月刊）》;20130715;第2013年卷(第07期);第C042-72页 * |
| 智能变电站SCD智能比对软件的设计与实现;郑永康等;《四川电力技术》;20141031;第37卷(第5期);第36-41/58页 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN105243188A (en) | 2016-01-13 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN103218355B (en) | A kind of method and apparatus generating label for user | |
| CN103593371B (en) | Recommend the method and apparatus of search keyword | |
| CN109005145A (en) | A kind of malice URL detection system and its method extracted based on automated characterization | |
| CN108874921A (en) | Extract method, apparatus, terminal device and the storage medium of text feature word | |
| CN102867049B (en) | Chinese PINYIN quick word segmentation method based on word search tree | |
| CN102637172B (en) | Webpage blocking marking method and system | |
| CN101477563A (en) | Short text clustering method and system, and its data processing device | |
| CN103955539B (en) | Method and device for obtaining control field demarcation point in binary protocol data | |
| CN104535905A (en) | Partial discharge diagnosis method based on naive bayesian classification | |
| CN102148805A (en) | Feature matching method and device | |
| CN105243188B (en) | A kind of intelligent substation monitoring information amount auto-screening method | |
| CN104182465A (en) | Network-based big data processing method | |
| CN103631769A (en) | Method and device for judging consistency between file content and title | |
| CN107038457A (en) | A kind of telemetry compression batch processing method based on principal component signal to noise ratio | |
| CN111310845A (en) | Substation equipment identification method, device and equipment | |
| CN110221960A (en) | Generate method and device, the computer equipment, storage medium of test case | |
| CN103186621B (en) | A kind of catalogue generates method and apparatus | |
| CN112307318B (en) | Content publishing method, system and device | |
| CN111476375A (en) | Method and device for determining recognition model, electronic equipment and storage medium | |
| CN101930362A (en) | Method for integrating TTCN language and data description language | |
| CN103336761B (en) | Matching algorithm is filtered in the interference divided based on dynamic with semantic weighting | |
| CN104111931A (en) | Protocol automatic identification method and construction method of classifier used in protocol automatic identification | |
| CN107025329A (en) | The empty loop automatic connection method of intelligent substation | |
| CN111431821A (en) | Method for rapidly detecting and identifying specific information in network large flow | |
| CN108833156B (en) | Evaluation method and system for simulation performance index of power communication network |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant | ||
| CP02 | Change in the address of a patent holder | ||
| CP02 | Change in the address of a patent holder |
Address after: 210036 No. 10 Dujiang Road, Gulou District, Nanjing City, Jiangsu Province Patentee after: Jiangsu Keneng Electric Engineering Consultation Co., Ltd. Address before: 210036 No. 10 Dujiang Road, Gulou District, Nanjing City, Jiangsu Province Patentee before: Jiangsu Keneng Electric Engineering Consultation Co., Ltd. |