CN114372449A - Automatic generation tool, method, equipment and medium for telecontrol information table of transformer substation - Google Patents

Automatic generation tool, method, equipment and medium for telecontrol information table of transformer substation Download PDF

Info

Publication number
CN114372449A
CN114372449A CN202210028441.7A CN202210028441A CN114372449A CN 114372449 A CN114372449 A CN 114372449A CN 202210028441 A CN202210028441 A CN 202210028441A CN 114372449 A CN114372449 A CN 114372449A
Authority
CN
China
Prior art keywords
signal
template
target
information table
description
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
Application number
CN202210028441.7A
Other languages
Chinese (zh)
Inventor
彭修亚
姚若昊
车磊
彭飞进
吴越
彭程
曹志辉
李伟业
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Guangdong Power Grid Co Ltd
Foshan Power Supply Bureau of Guangdong Power Grid Corp
Original Assignee
Guangdong Power Grid Co Ltd
Foshan Power Supply Bureau of Guangdong Power Grid Corp
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by Guangdong Power Grid Co Ltd, Foshan Power Supply Bureau of Guangdong Power Grid Corp filed Critical Guangdong Power Grid Co Ltd
Priority to CN202210028441.7A priority Critical patent/CN114372449A/en
Publication of CN114372449A publication Critical patent/CN114372449A/en
Pending legal-status Critical Current

Links

Images

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F40/00Handling natural language data
    • G06F40/10Text processing
    • G06F40/166Editing, e.g. inserting or deleting
    • G06F40/186Templates
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/30Information retrieval; Database structures therefor; File system structures therefor of unstructured textual data
    • G06F16/33Querying
    • G06F16/3331Query processing
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F40/00Handling natural language data
    • G06F40/10Text processing
    • G06F40/166Editing, e.g. inserting or deleting
    • G06F40/177Editing, e.g. inserting or deleting of tables; using ruled lines
    • G06F40/18Editing, e.g. inserting or deleting of tables; using ruled lines of spreadsheets
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06QINFORMATION 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/00Administration; Management
    • G06Q10/10Office automation; Time management
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06QINFORMATION 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/00Information and communication technology [ICT] specially adapted for implementation of business processes of specific business sectors, e.g. utilities or tourism
    • G06Q50/06Energy or water supply

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Business, Economics & Management (AREA)
  • Physics & Mathematics (AREA)
  • General Physics & Mathematics (AREA)
  • Health & Medical Sciences (AREA)
  • Economics (AREA)
  • Strategic Management (AREA)
  • Computational Linguistics (AREA)
  • General Health & Medical Sciences (AREA)
  • General Engineering & Computer Science (AREA)
  • Human Resources & Organizations (AREA)
  • Entrepreneurship & Innovation (AREA)
  • Tourism & Hospitality (AREA)
  • Audiology, Speech & Language Pathology (AREA)
  • Artificial Intelligence (AREA)
  • Marketing (AREA)
  • General Business, Economics & Management (AREA)
  • Data Mining & Analysis (AREA)
  • Quality & Reliability (AREA)
  • Operations Research (AREA)
  • Databases & Information Systems (AREA)
  • Public Health (AREA)
  • Water Supply & Treatment (AREA)
  • Primary Health Care (AREA)
  • Remote Monitoring And Control Of Power-Distribution Networks (AREA)

Abstract

The application discloses instrument, method, equipment and medium are generated automatically to transformer substation telemechanical information table, and the instrument includes: the query and insertion unit is used for querying a corresponding signal template in a template database according to a target interval type in target information input by a user and inserting the signal template corresponding to the target interval type into an initial table, wherein the template database is used for storing signal templates corresponding to all preset interval types of the transformer substation; the verification unit is used for reading the signal description of each row in the initial table after the signal template is inserted and verifying each signal description; the generation unit is used for configuring the acquisition point numbers for the signal descriptions and generating the telecontrol information table after the verification is passed, so that the technical problems that in the prior art, the telecontrol information table is generated by manually using EXCEL editing, the speed is low, the efficiency is low, and the signal name editing error and the signal editing omission are easy to occur are solved.

Description

Automatic generation tool, method, equipment and medium for telecontrol information table of transformer substation
Technical Field
The application relates to the technical field of transformer substations, in particular to a tool, a method, equipment and a medium for automatically generating a telecontrol information table of a transformer substation.
Background
The energy management system is a general name of hardware and software for power monitoring and control, can monitor telemetering signals such as current, voltage and power of a transformer substation and remote signaling signals such as switch state protection signals in real time through information acquired by a telecontrol device in the transformer substation, and can issue remote control commands to equipment such as a transformer and a capacitor, so that a power grid is monitored, and the completeness and stability of the operation of the power grid are ensured.
And the energy management system monitors the power grid according to a telecontrol information table generated by the three remote signals. When a new transformer substation and signals thereof need to be accessed into the energy management system for remote monitoring, a telecontrol information table of the newly added signals needs to be edited. At present, telecontrol information tables are edited by using EXCEL manually, and the problems of low speed, low efficiency, error editing of signal names and missing editing of signals are easy to occur.
Disclosure of Invention
The application provides a substation telecontrol information table automatic generation tool, a substation telecontrol information table automatic generation method, equipment and a substation telecontrol information table automatic generation medium, which are used for solving the technical problems that in the prior art, a telecontrol information table is generated by manually using EXCEL editing, the speed is low, the efficiency is low, and signal name editing errors and signal editing omission easily occur.
In view of this, the first aspect of the present application provides an automatic generation tool for a substation telecontrol information table, including:
the query and insertion unit is used for querying a corresponding signal template in a template database according to a target interval type in target information input by a user and inserting the signal template corresponding to the target interval type into an initial table, wherein the template database is used for storing signal templates corresponding to all preset interval types of the transformer substation;
the verification unit is used for reading the signal description of each row in the initial table after the signal template is inserted and verifying each signal description;
and the generating unit is used for configuring an acquisition point number for each signal description after the verification is passed, and generating a telecontrol information table.
Optionally, the target information further includes an interval number, and the query and insertion unit is specifically configured to:
inquiring a corresponding signal template in a template database according to a target interval type in target information input by a user;
and inserting a signal template of the interval number corresponding to the target interval type into the initial table.
Optionally, the target information further includes a device number and a scheduling number, and the query and insertion unit is further configured to:
and inserting the equipment number and the scheduling label into corresponding positions in an initial table after a signal template is inserted according to the target interval type.
Optionally, the verification unit is specifically configured to:
reading the signal description of each row in the initial table after the signal template is inserted;
when the signal description is identified to contain the target keyword, searching whether the signal description contains attribute information corresponding to the target keyword or not;
and checking whether the information in the remote signaling signal, the remote measuring signal and the remote control signal in the initial table after the signal template is inserted corresponds to each other according to the signal description.
The second aspect of the present application provides a method for automatically generating a substation telecontrol information table, which is applied to any one of the tools for automatically generating a substation telecontrol information table in the first aspect, and the method includes:
inquiring a corresponding signal template in a template database according to a target interval type in target information input by a user, and inserting the signal template corresponding to the target interval type into an initial table, wherein the template database is used for storing signal templates corresponding to all preset interval types of the transformer substation;
reading the signal description of each row in the initial table after the signal template is inserted, and verifying each signal description;
and after the verification is passed, configuring an acquisition point number for each signal description to generate a telecontrol information table.
Optionally, the target information further includes an interval number, and the inserting the signal template corresponding to the target interval type in the initial table includes:
and inserting a signal template of the interval number corresponding to the target interval type into the initial table.
Optionally, the target information further includes a device number and a scheduling number, and the method further includes:
and inserting the equipment number and the scheduling label into corresponding positions in an initial table after a signal template is inserted according to the target interval type.
Optionally, the verification process described by the signal is as follows:
when the signal description is identified to contain the target keyword, searching whether the signal description contains attribute information corresponding to the target keyword or not;
and checking whether the information in the remote signaling signal, the remote measuring signal and the remote control signal in the initial table after the signal template is inserted corresponds to each other according to the signal description.
The second aspect of the application provides automatic generation equipment for a telecontrol information table of a transformer substation, which comprises a processor and a memory;
the memory is used for storing program codes and transmitting the program codes to the processor;
the processor is used for executing the automatic generation method of the substation telecontrol information table of any one of the second aspects according to the instructions in the program codes.
A third aspect of the present application provides a computer-readable storage medium for storing program code, which when executed by a processor implements the automatic substation telecontrol information table generating method according to any one of the second aspects.
According to the technical scheme, the method has the following advantages:
the application provides a telemechanical information table automatic generation instrument of transformer substation includes: the query and insertion unit is used for querying a corresponding signal template in a template database according to a target interval type in target information input by a user and inserting the signal template corresponding to the target interval type into an initial table, wherein the template database is used for storing signal templates corresponding to all preset interval types of the transformer substation; the verification unit is used for reading the signal description of each row in the initial table after the signal template is inserted and verifying each signal description; and the generating unit is used for configuring acquisition point numbers for the signal descriptions and generating a telecontrol information table after the verification is passed.
The utility model provides an automatic generation tool of transformer substation telemechanical information table, store the signal template that all interval types of the transformer substation that the configuration was good in advance correspond in the template database, when needing to generate telemechanical information table, the user only needs to select to input the target information, the telemechanical information table automatic generation tool inquires corresponding signal template in the template database according to the target interval type in the target information, and insert the signal template that the target interval type corresponds in the initial form, thereby can avoid the situation that the list builder causes the content of the information table to make mistakes because of business unskilled or misoperation, in order to guarantee the accuracy of the telemechanical information table that generates, check the signal description of each row in the initial form after inserting the signal template, automatically generate the telemechanical information table through the tool, speed and efficiency are improved, the telemechanical information table is generated through manual use EXCEL to the prior art, the method has the technical problems of low speed, low efficiency, easy error editing of signal names and missed editing of signals.
Drawings
In order to more clearly illustrate the embodiments of the present application or the technical solutions in the prior art, the drawings needed to be used in the description of the embodiments or the prior art will be briefly introduced below, and it is obvious that the drawings in the following description are only some embodiments of the present application, and it is obvious for those skilled in the art that other drawings can be obtained according to the drawings without inventive exercise.
Fig. 1 is a schematic structural diagram of an automatic generation tool for a substation telecontrol information table provided in an embodiment of the present application;
fig. 2 is a schematic flow chart of a method for automatically generating a substation telecontrol information table according to an embodiment of the present application.
Detailed Description
In order to make the technical solutions of the present application better understood, the technical solutions in the embodiments of the present application will be clearly and completely described below with reference to the drawings in the embodiments of the present application, and it is obvious that the described embodiments are only a part of the embodiments of the present application, and not all of the embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present application.
For convenience of understanding, referring to fig. 1, an embodiment of the present application provides an automatic generation tool for a substation telecontrol information table, including:
the query and insertion unit is used for querying a corresponding signal template in a template database according to a target interval type in target information input by a user and inserting the signal template corresponding to the target interval type into an initial table, wherein the template database is used for storing signal templates corresponding to all preset interval types of the transformer substation;
the verification unit is used for reading the signal description of each row in the initial table after the signal template is inserted and verifying each signal description;
and the generating unit is used for configuring acquisition point numbers for the signal descriptions and generating a telecontrol information table after the verification is passed.
In order to quickly generate the telecontrol information table through the substation telecontrol information table automatic generation tool under the condition of ensuring the correctness, when the telecontrol information table is generated, the tool takes signals which all types of electric intervals should contain as signal templates and solidifies the signals into a template database, a user does not need to pay attention to which signals each electric interval should contain, only needs to determine the number of each type of interval and input the corresponding number, and the telecontrol information table automatic generation tool automatically generates the telecontrol information table according to the signal templates. When a signal template is constructed, the automatic generation tool of the substation telecontrol information table correspondingly compares a design signal (namely a signal actually possessed by a substation site) with a template signal, marks signals which are not needed in the template and do not accord with the site actually, and finally stores the constructed signal template into a template database. The template signals are signals which are required to be transmitted to a master station from a transformer substation in the specification, the signals are firstly solidified to be used as initial signal templates, the design signals and the template signals are not completely consistent, and some signals required by the specification are not actually available on the site. Specifically, the electric power design institute provides a design signal table, and after a tool is introduced, a program searches design signals with the same description in the design signal table for each template signal according to the signal description; and marking the template signals which cannot be searched (the substation site is not considered to have the signals), and finally deleting the marked signals to obtain the signal template for the next use.
When the telecontrol information table needs to be generated, a user can select the interval type in the telecontrol information table automatic generation tool, and when the user does not input the interval number, the default interval number is 1. After the automatic generation tool of the telecontrol information table obtains the target information input by the user, the query and insertion unit queries the corresponding signal template in the template database according to the target interval type in the target information input by the user and inserts the signal template corresponding to the target interval type into the newly-built blank initial table.
It is understood that, when the target information input by the user includes the number of intervals, the query and insertion unit inserts the signal template corresponding to the number of intervals of the target interval type into the initial table.
Further, the user may also input the device number and the scheduling number for each type of interval, and at this time, the query and insertion unit is further configured to:
and inserting the equipment number and the scheduling label into corresponding positions in the initial table after the signal template is inserted according to the target interval type.
The positions of the equipment numbers and the scheduling numbers are reserved by using symbols x in the signal template, and when the equipment numbers and the scheduling numbers of various types of intervals are input by a user, the symbols x are replaced by the equipment numbers and the scheduling numbers of the corresponding types of intervals by the inquiring and inserting unit.
After inserting the corresponding information, the verification unit reads the signal description of each row in the initial table after inserting the signal template, and performs normative verification on each signal description. Specifically, the verification unit reads the signal description of each row in the initial table after the signal template is inserted; when the signal description is identified to contain the target keyword, searching whether the signal description contains attribute information corresponding to the target keyword or not; and checking whether the information in the remote signaling signal, the remote measuring signal and the remote control signal in the initial table after the signal template is inserted corresponds to each other according to the signal description.
When the signal description is identified to contain the target keyword, the checking unit searches whether the signal description contains the attribute information corresponding to the target keyword, for example, if the signal description contains the target keyword 'line', the checking unit further searches whether the signal description contains the voltage level '10 kV', '110 kV', and the like; if the signal description is recognized to contain the target keyword "neutral point location", the signal description is further searched for whether the numbers "11000", "12000", "13000", etc. are contained therein.
The remote signaling meter, the remote sensing meter and the remote control meter are generated through the query and insertion unit, the telemechanical information meter comprises the remote signaling meter, the remote sensing meter and the remote control meter, and which remote signaling remote sensing remote control is determined in the signal template in one electrical interval. The verification unit further verifies whether the information in the remote signaling signal, the remote measuring signal and the remote control signal in the initial table after the signal template is inserted corresponds to each other, specifically, the verification unit reads the description of all switches in the remote signaling table, searches whether the remote signaling table contains related measurement or not according to the serial numbers of the switches, and searches whether the remote control table contains related remote control information or not, for example, 10kV switch intervals, the contained measurement comprises active power, reactive power and three-phase current, and the 110kV line comprises remote control of a remote control line switch and remote control of disconnecting links at two sides of the switch; reading descriptions of all buses in the telemetry meter, searching whether the telemetry meter contains related measurement according to the bus descriptions, wherein the measurement of the buses comprises A phase voltage, B phase voltage, C phase voltage, AB line voltage, BC line voltage and CA line power supply; and reading descriptions of all transformers in the remote signaling table, searching whether the related measurements (such as oil temperature, winding temperature and gears included in the measurement of the 110kV main transformer interval) are included in the remote sensing table or not according to the descriptions of the transformers, and searching whether the related gear adjustment remote control information is included in the remote control table or not.
When the signal description is identified to contain the target keyword, further searching attribute information corresponding to the target keyword contained in the signal description; and when the information in the remote signaling signal, the remote measuring signal and the remote control signal in the initial table after the signal template is inserted is verified to correspond according to the signal description, the verification unit outputs that the verification is passed. And the generating unit adds the acquisition point number to each signal description in sequence after each signal description passes the verification, so as to generate a telecontrol information table, and the generated telecontrol information table can be exported to a specified file.
The automatic generation tool for the substation telecontrol information table provided by the embodiment of the application stores signal templates corresponding to all interval types of a preconfigured substation in a template database, when the telecontrol information table needs to be generated, a user only needs to select and input target information, the automatic generation tool for the telecontrol information table inquires a corresponding signal template in the template database according to the target interval type in the target information, and inserts the signal template corresponding to the target interval type into an initial table, so that the situation that the content of the information table is wrong due to unskilled business or misoperation of a staff for compiling the table can be avoided, in order to ensure the accuracy of the generated telecontrol information table, signal description of each row in the initial table after the signal template is inserted is checked, the telecontrol information table is automatically generated through the tool, the speed and the efficiency are improved, and the telecontrol information table generated by manually using EXCEL in the prior art is improved, the method has the technical problems of low speed, low efficiency, easy error editing of signal names and missed editing of signals.
The above is an embodiment of the automatic generation tool for the substation telecontrol information table provided by the present application, and the following is an embodiment of the automatic generation method for the substation telecontrol information table provided by the present application.
Referring to fig. 2, a method for automatically generating a substation telecontrol information table provided in an embodiment of the present application is applied to a substation telecontrol information table automatic generation tool in the foregoing method embodiment, and the method includes:
step 101, inquiring a corresponding signal template in a template database according to a target interval type in target information input by a user, and inserting the signal template corresponding to the target interval type into an initial table, wherein the template database is used for storing signal templates corresponding to all preset interval types of the transformer substation.
In order to quickly generate the telecontrol information table through the substation telecontrol information table automatic generation tool under the condition of ensuring the correctness, when the telecontrol information table is generated, signals which all types of electric intervals should contain are solidified into a template database as signal templates, a user does not need to pay attention to which signals each electric interval should contain, only needs to determine the quantity of each type of interval and input the corresponding number, and the telecontrol information table automatic generation tool automatically generates the telecontrol information table according to the signal templates. When a signal template is constructed, the automatic generation tool of the telecontrol information table of the transformer substation correspondingly compares a design signal with a template signal, marks signals which are not needed in the template and do not accord with the actual site, and finally stores the constructed signal template into a template database.
When the telecontrol information table needs to be generated, a user can select the interval type in the telecontrol information table automatic generation tool, and when the user does not input the interval number, the default interval number is 1. After the telecontrol information table automatic generation tool acquires the target information input by the user, a corresponding signal template is inquired in a template database according to the target interval type in the target information input by the user, and the signal template corresponding to the target interval type is inserted into the newly-built blank initial table.
It is understood that, when the target information input by the user includes the number of intervals, the query and insertion unit inserts the signal template corresponding to the number of intervals of the target interval type into the initial table.
Further, the user can also input the device number and the scheduling number of each type of interval, and at this time, the telecontrol information table automatic generation tool inserts the device number and the scheduling number into the corresponding position in the initial table after the signal template is inserted according to the target interval type.
The signal template reserves the positions of the equipment numbers and the scheduling numbers by using the symbols x, and when the equipment numbers and the scheduling numbers of various types of intervals are input by a user, the symbols x are replaced by the equipment numbers and the scheduling numbers of the corresponding types of intervals by the automatic telecontrol information table generating tool.
And 102, reading the signal description of each row in the initial table after the signal template is inserted, and checking each signal description.
After inserting corresponding information, the telecontrol information table automatic generation tool automatically reads the signal description of each row in the initial table after inserting the signal template, and carries out normative verification on each signal description. Specifically, reading the signal description of each row in the initial table after inserting the signal template; when the signal description is identified to contain the target keyword, searching whether the signal description contains attribute information corresponding to the target keyword or not; and checking whether the information in the remote signaling signal, the remote measuring signal and the remote control signal in the initial table after the signal template is inserted corresponds to each other according to the signal description.
When recognizing that the signal description contains the target keyword, the automatic telecontrol information table generation tool searches whether the signal description contains attribute information corresponding to the target keyword, for example, if recognizing that the signal description contains the target keyword 'line', further searches whether the signal description contains the voltage level '10 kV', '110 kV', and the like; if the signal description is recognized to contain the target keyword "neutral point location", the signal description is further searched for whether the numbers "11000", "12000", "13000", etc. are contained therein.
The telemechanical information table automatic generation tool further checks whether the information in the remote signaling signal, the remote measuring signal and the remote control signal in the initial table after the signal template is inserted corresponds to each other, specifically, a check unit reads the description of all switches in the telemechanical table, searches whether the telemechanical table contains related measurement or not according to the serial numbers of the switches, and searches whether the remote control table contains related remote control information or not; reading the description of all buses in the telemetry table, and searching whether the telemetry table contains related measurement or not according to the bus description; and reading descriptions of all transformers in the remote signaling table, searching whether the related measurement is contained in the remote sensing table or not according to the transformer descriptions, and searching whether the related gear adjustment remote control information is contained in the remote control table or not.
And 103, configuring acquisition point numbers for the signal descriptions after the verification is passed, and generating a telecontrol information table.
When the signal description is identified to contain the target keyword, further searching attribute information corresponding to the target keyword contained in the signal description; and when the information in the remote signaling signal, the remote measuring signal and the remote control signal in the initial table after the signal template is inserted is verified according to the signal description, the verification is judged to be passed. After each signal description passes verification, adding a collection point number to each signal description in sequence to further generate a telecontrol information table, wherein the generated telecontrol information table can be exported to a designated file.
According to the embodiment of the application, the part which has file specifications and relates to personnel experience in the process of compiling the telecontrol information table is solidified by using the database technology and the software technology, the condition that the contents of the information table are wrong due to unskilled business or misoperation of a compiler is avoided, the telecontrol information table meeting the specification requirement is generated by the automatic generation tool of the telecontrol information table of the transformer substation, the EXCEL is not required to be edited manually, time-consuming operations such as copying and pasting are omitted, and the editing efficiency of the telecontrol information table is greatly improved.
The embodiment of the application also provides automatic generation equipment for the telecontrol information table of the transformer substation, which comprises a processor and a memory;
the memory is used for storing the program codes and transmitting the program codes to the processor;
the processor is used for executing the automatic substation telecontrol information table generation method in the method embodiment according to the instructions in the program codes.
The embodiment of the present application further provides a computer-readable storage medium, where the computer-readable storage medium is used for storing program codes, and when the program codes are executed by a processor, the method for automatically generating a substation telecontrol information table in the foregoing method embodiment is implemented.
The terms "first," "second," "third," "fourth," and the like in the description of the application and the above-described figures, if any, are used for distinguishing between similar elements and not necessarily for describing a particular sequential or chronological order. It is to be understood that the data so used is interchangeable under appropriate circumstances such that the embodiments of the application described herein are, for example, capable of operation in sequences other than those illustrated or otherwise described herein. Furthermore, the terms "comprises," "comprising," and "having," and any variations thereof, are intended to cover a non-exclusive inclusion, such that a process, method, system, article, or apparatus that comprises a list of steps or elements is not necessarily limited to those steps or elements expressly listed, but may include other steps or elements not expressly listed or inherent to such process, method, article, or apparatus.
It should be understood that in the present application, "at least one" means one or more, "a plurality" means two or more. "and/or" for describing an association relationship of associated objects, indicating that there may be three relationships, e.g., "a and/or B" may indicate: only A, only B and both A and B are present, wherein A and B may be singular or plural. The character "/" generally indicates that the former and latter associated objects are in an "or" relationship. "at least one of the following" or similar expressions refer to any combination of these items, including any combination of single item(s) or plural items. For example, at least one (one) of a, b, or c, may represent: a, b, c, "a and b", "a and c", "b and c", or "a and b and c", wherein a, b, c may be single or plural.
In the several embodiments provided in the present application, it should be understood that the disclosed apparatus and method may be implemented in other ways. For example, the above-described apparatus embodiments are merely illustrative, and for example, the division of the units is only one logical division, and other divisions may be realized in practice, for example, a plurality of units or components may be combined or integrated into another system, or some features may be omitted, or not executed. In addition, the shown or discussed mutual coupling or direct coupling or communication connection may be an indirect coupling or communication connection through some interfaces, devices or units, and may be in an electrical, mechanical or other form.
The units described as separate parts may or may not be physically separate, and parts displayed as units may or may not be physical units, may be located in one place, or may be distributed on a plurality of network units. Some or all of the units can be selected according to actual needs to achieve the purpose of the solution of the embodiment.
In addition, functional units in the embodiments of the present application may be integrated into one processing unit, or each unit may exist alone physically, or two or more units are integrated into one unit. The integrated unit can be realized in a form of hardware, and can also be realized in a form of a software functional unit.
The integrated unit, if implemented in the form of a software functional unit and sold or used as a stand-alone product, may be stored in a computer readable storage medium. Based on such understanding, the technical solution of the present application may be substantially implemented or contributed to by the prior art, or all or part of the technical solution may be embodied in a software product, which is stored in a storage medium and includes instructions for executing all or part of the steps of the method described in the embodiments of the present application through a computer device (which may be a personal computer, a server, or a network device). And the aforementioned storage medium includes: a U-disk, a removable hard disk, a Read-Only Memory (ROM), a Random Access Memory (RAM), a magnetic disk or an optical disk, and other various media capable of storing program codes.
The above embodiments are only used for illustrating the technical solutions of the present application, and not for limiting the same; although the present application has been described in detail with reference to the foregoing embodiments, it should be understood by those of ordinary skill in the art that: the technical solutions described in the foregoing embodiments may still be modified, or some technical features may be equivalently replaced; and such modifications or substitutions do not depart from the spirit and scope of the corresponding technical solutions in the embodiments of the present application.

Claims (10)

1. The utility model provides a telemechanical information table automatic generation instrument of transformer substation which characterized in that includes:
the query and insertion unit is used for querying a corresponding signal template in a template database according to a target interval type in target information input by a user and inserting the signal template corresponding to the target interval type into an initial table, wherein the template database is used for storing signal templates corresponding to all preset interval types of the transformer substation;
the verification unit is used for reading the signal description of each row in the initial table after the signal template is inserted and verifying each signal description;
and the generating unit is used for configuring an acquisition point number for each signal description after the verification is passed, and generating a telecontrol information table.
2. The automatic substation telecontrol information table generation tool of claim 1, wherein the target information further includes a number of intervals, and the query and insertion unit is specifically configured to:
inquiring a corresponding signal template in a template database according to a target interval type in target information input by a user;
and inserting a signal template of the interval number corresponding to the target interval type into the initial table.
3. The automatic substation telecontrol information table generation tool of claim 1, wherein the target information further comprises a device number and a dispatch number, the query and insertion unit is further configured to:
and inserting the equipment number and the scheduling label into corresponding positions in an initial table after a signal template is inserted according to the target interval type.
4. The automatic generation tool for the substation telecontrol information table according to claim 1, wherein the verification unit is specifically configured to:
reading the signal description of each row in the initial table after the signal template is inserted;
when the signal description is identified to contain the target keyword, searching whether the signal description contains attribute information corresponding to the target keyword or not;
and checking whether the information in the remote signaling signal, the remote measuring signal and the remote control signal in the initial table after the signal template is inserted corresponds to each other according to the signal description.
5. A method for automatically generating a substation telecontrol information table, which is applied to the substation telecontrol information table automatic generation tool of any one of claims 1-4, and comprises the following steps:
inquiring a corresponding signal template in a template database according to a target interval type in target information input by a user, and inserting the signal template corresponding to the target interval type into an initial table, wherein the template database is used for storing signal templates corresponding to all preset interval types of the transformer substation;
reading the signal description of each row in the initial table after the signal template is inserted, and verifying each signal description;
and after the verification is passed, configuring an acquisition point number for each signal description to generate a telecontrol information table.
6. The automatic generation method of the substation telecontrol information table according to claim 5, wherein the target information further includes a number of intervals, and the inserting of the signal template corresponding to the target interval type into the initial table includes:
and inserting a signal template of the interval number corresponding to the target interval type into the initial table.
7. The automatic generation method of the substation telecontrol information table according to claim 5, characterized in that the target information further includes a device number and a scheduling number, the method further comprising:
and inserting the equipment number and the scheduling label into corresponding positions in an initial table after a signal template is inserted according to the target interval type.
8. The automatic generation method of the substation telecontrol information table according to claim 5, characterized in that the verification process of the signal description is as follows:
when the signal description is identified to contain the target keyword, searching whether the signal description contains attribute information corresponding to the target keyword or not;
and checking whether the information in the remote signaling signal, the remote measuring signal and the remote control signal in the initial table after the signal template is inserted corresponds to each other according to the signal description.
9. The automatic generation equipment for the telecontrol information table of the transformer substation is characterized by comprising a processor and a memory;
the memory is used for storing program codes and transmitting the program codes to the processor;
the processor is used for executing the automatic substation telecontrol information table generating method of any one of claims 5-8 according to instructions in the program code.
10. A computer-readable storage medium for storing program code, which when executed by a processor implements the method for automatically generating a substation telecontrol information table according to any of claims 5-8.
CN202210028441.7A 2022-01-11 2022-01-11 Automatic generation tool, method, equipment and medium for telecontrol information table of transformer substation Pending CN114372449A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202210028441.7A CN114372449A (en) 2022-01-11 2022-01-11 Automatic generation tool, method, equipment and medium for telecontrol information table of transformer substation

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202210028441.7A CN114372449A (en) 2022-01-11 2022-01-11 Automatic generation tool, method, equipment and medium for telecontrol information table of transformer substation

Publications (1)

Publication Number Publication Date
CN114372449A true CN114372449A (en) 2022-04-19

Family

ID=81144166

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202210028441.7A Pending CN114372449A (en) 2022-01-11 2022-01-11 Automatic generation tool, method, equipment and medium for telecontrol information table of transformer substation

Country Status (1)

Country Link
CN (1) CN114372449A (en)

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN115146606A (en) * 2022-08-02 2022-10-04 上海三力信息科技有限公司 Method, system, equipment and storage medium for creating and managing enrollment information

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN115146606A (en) * 2022-08-02 2022-10-04 上海三力信息科技有限公司 Method, system, equipment and storage medium for creating and managing enrollment information

Similar Documents

Publication Publication Date Title
CN107317399B (en) Visual automatic point aligning method for intelligent transformer substation
CN107292003A (en) A kind of automatic generating method of electric network station wiring diagram
CN107272615B (en) A kind of substation model processing method for deploying integral system
CN104123271B (en) Intelligent substation secondary design system based on Excel
CN112039197A (en) Automatic mapping method of distribution room topological graph and computer readable storage medium
CN113283096B (en) Method for acquiring distribution network line account data and analyzing abnormal data and related device
CN105447247A (en) Method and system for checking regulation and control information
CN105976262B (en) A kind of electric network model version sharing method based on plant stand granularity
CN112100992B (en) Substation site table generation and checking method
CN112580178B (en) Graph-model bidirectional verification method and device for energy management system
CN108573342A (en) State evaluating method, device, computer equipment and the storage medium of power equipment
CN110046391A (en) Transforming plant primary wiring diagram automatic generation method based on monitoring information table
CN105264446B (en) For the instrument and method being connected with surveillance and monitoring and control arrangement
CN107944659B (en) Method and device for automatically generating plant station monitoring system report
CN114372449A (en) Automatic generation tool, method, equipment and medium for telecontrol information table of transformer substation
CN105913337B (en) A kind of PSASP data model translation is the method for RSCAD data model
CN106202814B (en) The mapping method of automatic safety device acquisition data and EMS system primary equipment model
CN108564261A (en) Method, apparatus and computer equipment are determined based on the power information of work ticket
CN109617025B (en) Automatic generation method and device for main wiring diagram of in-place protection management unit
CN110489729B (en) Automatic conversion method and system for D5000-matpower grid multi-disaster coupling cascading failure model
CN110795837B (en) Automatic distribution network ticket application one-time mode repeating operation method based on topological linkage
CN111884337A (en) Method for carrying out configuration management on switching parameters of power distribution network
CN111507078A (en) Test report control method and system
CN110956283B (en) Method and system for matching SCD file with soft pressing plate
CN109741594B (en) Configuration method and device for equipment data acquisition

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