Transformer substation protection information check report automatic generation method, system, equipment and medium

Abstract

The invention relates to the technical field of power system automation, and discloses a transformer substation protection information check report automatic generation method, system, equipment and medium, and the method comprises the steps: obtaining a fault recording file of a protection device, analyzing a fault report file, extracting protection motion information, generating a complete protection configuration matrix table based on a transformer substation configuration file, and storing the complete protection configuration matrix table. By analyzing pressing plate control words in a constant value list, identifying the on-off state of each protection function, marking the input protection in a table, intelligently matching the fault recording fluctuation condition in the acceptance period with a protection configuration matrix, automatically identifying the executed, non-executed and abnormally executed protection items, and adopting a natural language processing technology, the protection function of the protection function is automatically identified. And converting the technical data into text description conforming to industry specifications, and finally generating a formatted check report containing a complete protection configuration table. The completeness and accuracy of protection information checking are ensured, and the problem of low efficiency of a traditional manual checking mode is fundamentally solved.

Description

Technical Field

[0001] This invention relates to the field of power system automation technology, and in particular to a method, system, equipment and medium for automatically generating substation protection information verification reports. Background Technology

[0002] Substation protection information systems are critical facilities for ensuring the safe and stable operation of the power grid. Before a substation is put into operation, all configured protection functions need to be comprehensively tested and verified to ensure that the protection devices can operate correctly in the event of a power grid fault.

[0003] Currently, the verification of substation protection information mainly relies on manual methods. Technicians need to manually collect various protection-related data from scattered systems. This data comes from diverse sources and is presented in various formats, posing significant challenges to data processing. After obtaining the data, technicians manually compile protection function lists and configuration tables according to relevant industry standards, filling in test results item by item. A complete verification report often takes several hours to complete. This process is not only time-consuming but also prone to human error, leading to omissions or misclassifications of protection functions. Furthermore, due to differences in naming conventions and descriptions among different manufacturers' protection devices, the identification and correlation matching of action events largely depend on the experience of technicians, making it difficult to guarantee accuracy and consistency.

[0004] Therefore, the existing substation protection information verification process lacks standardization, and the results are significantly influenced by human factors. The lack of systematic and comprehensive functional management not only increases operation and maintenance costs but also may create safety hazards due to incomplete verification. Therefore, the power industry urgently needs a technical solution that can effectively address these problems to improve the efficiency and quality of substation protection information verification and ensure the safe and reliable operation of the power grid. Summary of the Invention

[0005] In view of the aforementioned existing problems, the present invention is proposed.

[0006] Therefore, the present invention provides a method, system, equipment and medium for automatically generating substation protection information verification reports, which solves the problems of complex data processing, manual verification process, low report generation efficiency and insufficient standardization in the prior art.

[0007] To solve the above-mentioned technical problems, the present invention provides the following technical solution: In a first aspect, the present invention provides a method for automatically generating substation protection information verification reports, comprising: A network connection is established by connecting to the station control layer switch via a network cable. The protection device is accessed using the manufacturing message specification protocol to obtain fault recording files, substation configuration files, and setting sheet files, and an index is created and stored according to the device name and timestamp. The substation configuration file is parsed to identify the type of protection device, and a complete configuration matrix table containing all protection functions that should be configured is generated according to power industry standards. Extract the soft control word and function control word from the setting sheet file, establish a binary bit mapping relationship, comprehensively determine the activation / deactivation status of each protection and mark it in the complete configuration matrix table; Parse the Extensible Markup Language structure of the fault recording file to extract the protection action sequence; The name matching is performed using an edit distance algorithm and a thesaurus. The protection action sequence is then matched with the test items in the complete configuration matrix table through phase comparison and time logic verification. The results of the association matching test are automatically populated into the complete configuration matrix table, abnormal issues are identified and marked, test coverage is calculated, and a list of untested items is generated. The test results are analyzed from multiple dimensions. Natural language processing technology is used to convert the analyzed technical data into standardized text descriptions and generate standardized verification reports.

[0008] As a preferred embodiment of the automatic generation method for substation protection information verification reports described in this invention, the acquisition of fault recording files, substation configuration files, and setting sheet files includes: The file service function access protection device uses the manufacturing message specification protocol to access the file directory of the protection device, and uses a multi-threaded parallel download method to obtain all fault recording files within a specified time period. The fault recording files include fault record header files, format configuration files and sampling data files. Obtain the substation configuration file containing information on all intelligent electronic device nodes and logic devices within the substation from the substation automation system, and export the setting sheet file containing setting parameters and control word settings from the protection device.

[0009] As a preferred embodiment of the automatic generation method for substation protection information verification reports according to the present invention, the generation of a complete configuration matrix table containing all protection functions to be configured includes: The intelligent electronic device nodes and logical device information of the substation configuration file are analyzed to identify the type of protection device and its corresponding bay. Based on the protection configuration specifications of the power industry standards, a standard protection function list is generated for each bay, resulting in a complete configuration matrix table containing the serial number, protection function name, protection type, phase, pressure plate status, control word, setting parameters, activation / deactivation status, test results, action time, last test time, number of tests, and remarks.

[0010] As a preferred embodiment of the automatic generation method for substation protection information verification reports described in this invention, the step of comprehensively judging the activation / deactivation status of each protection and marking it in the complete configuration matrix table includes: Read the set value file and extract the soft pressure plate control word and function control word by keyword matching; Establish a mapping relationship between the pressure plate name and binary bits; The soft pressure plate control word is a binary number, with each bit corresponding to the enabled / disabled state of a protection function. When a bit is 1, it indicates that the function soft pressure plate is enabled, and when it is 0, it indicates that the function soft pressure plate is disabled. The function control word determines whether the protection function is enabled. Even if the soft pressure plate is enabled, if the function control word is 0, the protection will not operate. The final activation / deactivation status of each protection is determined by comprehensive evaluation. When both the soft pressure plate control word and the function control word are 1, the status is marked as activated. When either the soft pressure plate control word or the function control word is 0, the status is marked as "exited". When the protection function is not present in the device, the status is marked as not configured.

[0011] As a preferred embodiment of the automatic generation method for substation protection information verification reports described in this invention, the extraction of the protection action sequence includes: Starting from the root node of the fault report, traverse the fault report to extract the fault start time and fault duration; Extract all protection action events from the trip information node sequence. Each action event includes a time offset, action element name, action phase, and action status attribute. Extract fault electrical parameters from fault information nodes, including fault phase selection results, fault location values, voltage and current amplitudes and phase angles of each phase, zero-sequence current and negative-sequence current; All extracted protection action events are arranged in chronological order to form a protection action sequence.

[0012] As a preferred embodiment of the automatic generation method for substation protection information verification reports according to the present invention, the step of associating and matching the protection action sequence with the test items of the complete configuration matrix table includes: The names of the action elements recorded in the protection action sequence are compared with the names of the protection functions in the complete configuration matrix table. The similarity is calculated using the edit distance algorithm, and a predefined thesaurus is called to normalize the naming differences of equipment from different manufacturers. The action phase information recorded in the protection action sequence is compared with the phase field of the specific test item in the complete configuration matrix table to realize the association between the action event and the corresponding phase test item; Based on the chronological order of events in the protection action sequence, the logical correctness of the protection action sequence is verified, and the rationality of the action timing is judged according to the type of protection function.

[0013] As a preferred embodiment of the automatic generation method for substation protection information verification reports according to the present invention, the generation of standardized verification reports includes: Check whether all protection functions marked as enabled in the complete configuration matrix table have corresponding test records, analyze the distribution of test execution times for various protection functions, and identify and record test blind spots in the system. The actual action values ​​recorded in the protection action sequence are compared with the corresponding protection setting parameters in the complete configuration matrix table to verify the degree of conformity, and the deviation rate between the measured value and the setting value is calculated. Based on the time information recorded in the protection action sequence, verify whether the action time coordination relationship between the main protection and the backup protection meets the preset logical requirements; Using natural language processing technology, the technical data and conclusions obtained from the analysis are converted into text descriptions that conform to industry standards. The complete configuration matrix table, analysis conclusions and standardized text descriptions are integrated to automatically generate a standardized verification report.

[0014] Secondly, the present invention provides an automatic generation system for substation protection information verification reports, comprising: The file extraction module is used to establish a network connection by connecting to the station control layer switch via a network cable, access the protection device using the manufacturing message specification protocol, obtain fault recording files, substation configuration files and setting sheet files, and store them in an index according to device name and timestamp. The first parsing module is used to parse the substation configuration file, identify the type of protection device, and generate a complete configuration matrix table containing all protection functions that should be configured according to power industry standards. The second parsing module is used to extract the soft pressure plate control word and function control word of the setting sheet file, establish a binary bit mapping relationship, comprehensively judge the activation / deactivation status of each protection and mark it in the complete configuration matrix table; The third parsing module is used to parse the Extensible Markup Language structure of the fault recording file and extract the protection action sequence. The matching test module is used to perform name matching using an edit distance algorithm and a thesaurus, and to perform association matching tests between the protection action sequence and the test items in the complete configuration matrix table through phase comparison and time logic verification. The test result analysis module is used to automatically populate the results of the associated matching test into the complete configuration matrix table, identify and mark abnormal issues, calculate test coverage, and generate a list of untested items. The report generation module is used to analyze test results from multiple dimensions. It uses natural language processing technology to convert the analyzed technical data into standardized text descriptions and generate standardized verification reports.

[0015] Thirdly, the present invention provides an electronic device, including a memory and a processor; the memory is used to store computer-executable instructions, and the processor executes the computer-executable instructions to implement the steps of an automatic generation method for a substation protection information verification report.

[0016] Fourthly, the present invention provides a computer-readable storage medium storing computer-executable instructions, which, when executed by a processor, implement the steps of an automatic generation method for a substation protection information verification report.

[0017] Compared with existing technologies, the beneficial effects of this invention are as follows: By automatically generating a complete configuration table containing all protection functions, this invention clearly distinguishes between protection states that are engaged, disengaged, and unconfigured, fundamentally improving the completeness and clarity of protection information management. It also reduces human error and omissions, resulting in higher accuracy and reliability of substation protection information verification, and improving the efficiency and standardization of the entire smart substation acceptance process. Furthermore, this invention utilizes multi-source data fusion technology to intelligently associate and automatically match heterogeneous data such as fault recording files, substation configuration files, and setting sheet files, achieving full automation of the protection information verification process. This reduces the traditional manual verification time from several hours to minutes, significantly improving substation acceptance efficiency while ensuring the standardization and normalization of reports. Attached Figure Description

[0018] To more clearly illustrate the technical solutions of the embodiments of the present invention, the drawings used in the following description of the embodiments will be briefly introduced. Obviously, the drawings described below are only some embodiments of the present invention. For those skilled in the art, other drawings can be obtained based on these drawings without creative effort.

[0019] Figure 1 This is a schematic diagram of the overall process logic of an automatic generation method for substation protection information verification reports provided in one embodiment of the present invention. Detailed Implementation

[0020] To make the above-mentioned objects, features, and advantages of the present invention more apparent and understandable, specific embodiments of the present invention will be described in detail below with reference to the accompanying drawings. Obviously, the described embodiments are only a part of the embodiments of the present invention, and not all of them. Based on the embodiments of the present invention, all other embodiments obtained by those skilled in the art without creative effort should fall within the protection scope of the present invention.

[0021] Example 1, referring to Figure 1 As one embodiment of the present invention, a method for automatically generating substation protection information verification reports is provided, such as... Figure 1 The specific steps shown are as follows: S100: Establishes a network connection by connecting to the station control layer switch via network cable, accesses the protection device using the manufacturing message specification protocol, obtains fault recording files, substation configuration files and setting sheet files, and stores them in an index according to device name and timestamp; S200: Parses substation configuration files, identifies protection device types, and generates a complete configuration matrix table containing all protection functions that should be configured, based on power industry standards; S300: Extract the soft pressure plate control word and function control word from the setting sheet file, establish a binary bit mapping relationship, comprehensively judge the activation / deactivation status of each protection and mark it in the complete configuration matrix table; S400: Parses the Extensible Markup Language structure of fault recording files and extracts protection action sequences; S500: It uses edit distance algorithm and thesaurus for name matching, and performs correlation matching test between protection action sequence and test items in complete configuration matrix table through phase comparison and time logic verification; S600: Automatically populates the results of associated matching tests into the complete configuration matrix table, identifies and marks abnormal issues, calculates test coverage, and generates a list of untested items; S700: Analyzes test results from multiple dimensions, uses natural language processing technology to convert the analyzed technical data into standardized text descriptions, and generates standardized verification reports.

[0022] It should be noted that, to address the problems of complex data processing, reliance on manual verification, low report generation efficiency, and insufficient standardization in existing technologies, steps S100-S700 automatically generate a complete configuration table containing all protection functions, clearly distinguishing between protections that are in operation, deactivated, and unconfigured. This fundamentally improves the completeness and clarity of protection information management, reduces human error and omissions, and enhances the accuracy and reliability of substation protection information verification, thereby improving the efficiency and standardization of the entire smart substation acceptance process. This invention utilizes multi-source data fusion technology to intelligently associate and automatically match heterogeneous data such as fault recording files, substation configuration files, and setting sheet files, achieving full automation of the protection information verification process. This reduces the traditional manual verification time from several hours to minutes, significantly improving substation acceptance efficiency while ensuring the standardization and normalization of reports.

[0023] In this embodiment of the invention, step S100 establishes a network connection through a network cable access station control layer switch, uses the manufacturing message specification protocol to access the protection device, obtains fault recording files, substation configuration files, and setting sheet files, and establishes an index storage according to device name and timestamp, including the following sub-steps A1~A3: In A1: Establish a network connection by connecting to the station control layer switch via a network cable; Specifically, the connection is established by connecting to the core switch of the station control layer via a 45 network cable through the registration jack, using the TCP / IP protocol (Transmission Control Protocol / Internet Protocol), setting the target IP address to 12.100.100.21, port number 102 to be the IEC 61850 MMS standard port, connection timeout to 30 seconds, maximum retries to 3, and receive buffer size to 64KB. A three-way handshake is first performed to establish the transport layer connection, followed by MMS (Manufacturing Message Specification) protocol negotiation, including negotiation of the maximum service data unit size and allocation of the call identifier, and finally, identity authentication and authorization verification.

[0024] In A2: The manufacturing message specification protocol is used to access the protection device and obtain fault recording files, substation configuration files, and setting sheet files; detailed steps include: The file service function of the protection device is accessed using the manufacturing message specification protocol, and all fault recording files within a specified time period are obtained using a multi-threaded parallel download method. The fault recording files include fault record header files, format configuration files, and sampling data files. Obtain the substation configuration file containing information on all intelligent electronic device nodes and logic devices within the substation from the substation automation system, and export the setting sheet file containing setting parameters and control word settings from the protection device.

[0025] It should be noted that the file service function of the protection device, which uses the manufacturing message specification protocol, accesses the file directory of the protection device, calls the GetFileDirectory service to obtain the file list under the transient data exchange general format directory, and discovers the fault waveform records within a specified time period. Each set of waveform records contains a fault record header file (XML format fault report, average size 28KB), a format configuration file (text format channel configuration, average size 5KB), and a sampling data file (binary format sampling data, average size 86KB).

[0026] In A3: The acquired files are indexed by device name and timestamp, and stored in the local database.

[0027] It should be noted that step S100 above achieves automatic collection and unified management of multi-source protection data through standardized network access and protocol communication. By directly accessing the protection device file directory using the manufacturing message specification protocol, the integrity and real-time nature of data acquisition are ensured. Furthermore, by establishing an index storage mechanism based on device name and timestamp, the management challenges of heterogeneous data sources are effectively solved, significantly improving the efficiency and accuracy of data preparation.

[0028] In this embodiment of the invention, the above step S200, which parses the substation configuration file, identifies the type of protection device, and generates a complete configuration matrix table containing all protection functions that should be configured according to power industry standards, includes the following sub-steps B1 and B2: In B1: Parse the substation configuration file and identify the type of protection device; Specifically, the DOM (Document Object Model) parser is used to read the substation configuration file and locate the target electronic device node. The device name is identified by parsing the target electronic device node's name attribute, such as "WXH803A2_L2202A", and the device model is identified by the type attribute, such as "WXH-803A2-DG-N". Under the target electronic device node, logical devices are traversed to find the protection logical device with the instance attribute "PROT". The configured protection function is identified by analyzing the lnClass attribute of its logical nodes, where PDIF represents differential protection, PDIS represents distance protection, PTOC represents overcurrent protection, and RREC represents reclosing function.

[0029] In B2: Generate a complete configuration matrix table containing all protection functions that should be configured, based on power industry standards; detailed steps include: Parse the intelligent electronic device nodes and logical device information in the substation configuration file to identify the type of protection device and its corresponding bay; Based on the protection configuration specifications of the power industry standards, a standard protection function list is generated for each bay, resulting in a complete configuration matrix table containing the serial number, protection function name, protection type, phase, pressure plate status, control word, setting parameters, activation / deactivation status, test results, action time, last test time, number of tests, and remarks.

[0030] In this embodiment of the invention, a standard protection function list is generated for the line bay according to DL / T 860.74 (power industry standard 860.74) and the "220kV line protection configuration guide". The longitudinal protection category includes longitudinal differential protection and longitudinal distance protection. Each configuration requires phase-by-phase testing of the main channel and the backup channel, totaling 6 test items. The distance protection category includes grounding distance and phase-to-phase distance, each in sections I, II, and III. Grounding is expanded according to three phases A, B, and C, and phase-to-phase distance is expanded according to AB, BC, and CA, totaling 18 test items. The zero-sequence protection category includes sections I, II, III, and IV, totaling 4 test items. The overcurrent protection category includes sections I and II, expanded according to three phases, totaling 6 test items. The reclosing function includes single-phase, three-phase, and comprehensive reclosing, totaling 5 test items. The auxiliary protection includes three-phase inconsistency and PT (voltage transformer) disconnection protection, etc., totaling 9 test items, generating a configuration matrix of 48 rows × 12 columns.

[0031] It should be noted that the above step S200 standardizes and organizes the protection functions according to power industry standards, ensuring the integrity and standard compliance of the configuration matrix. This completely changes the traditional method of manually compiling tables and eliminates the omission and classification errors of protection function items from the source.

[0032] In this embodiment of the invention, step S300, which involves extracting the soft-plate control word and function control word from the setting sheet file, establishing a binary bit mapping relationship, comprehensively judging the activation / deactivation status of each protection, and marking it in the complete configuration matrix table, includes the following sub-steps C1~C3: In C1: Read the setting sheet file and extract the soft pressure plate control word and function control word by keyword matching; Specifically, regular expressions are used to match key fields such as soft pressure plate control words and function control words, and the corresponding hexadecimal or binary values ​​are extracted. For text format value sheets, a row scanning method is used, and for table format value sheets, a cell traversal method is used to ensure accurate acquisition of all control word information.

[0033] In C2: Establish the mapping relationship between the pressure plate name and binary bits; Specifically, keyword matching locates the soft-panel control field. The value of soft-panel control word 1 is 0x1F7D, which is 0001111101111101 in 16-bit binary. Each bit corresponds to a specific protection function: Bit 0 corresponds to the longitudinal differential protection soft-panel, Bit 1 corresponds to fiber optic channel one, Bit 2 corresponds to fiber optic channel two, Bit 3 corresponds to distance protection, Bit 4 corresponds to zero-sequence overcurrent protection, Bit 5 corresponds to overcurrent protection, Bit 6 corresponds to reclosing function, Bit 7 corresponds to single-phase reclosing mode, and Bit 8 corresponds to three-phase reclosing mode.

[0034] Specifically, the soft control word is a binary number, with each bit corresponding to the enabled / disabled state of a protection function. When a bit is 1, it means that the soft control word is enabled, and when it is 0, it means that the soft control word is disabled. The function control word determines whether the protection function is enabled. Even if the soft control word is enabled, the protection will not operate if the function control word is 0.

[0035] In C3: The activation / deactivation status of each protection is comprehensively determined and marked in the complete configuration matrix table; Specifically, when both the soft pressure plate control word and the function control word are 1, the protection function is determined to be in the enabled state. It is displayed in bold font and marked in green in the configuration table, indicating that the protection needs to be tested.

[0036] Specifically, when either the soft pressure plate control word or the function control word is 0, the protection function is determined to be in an off state and is displayed in gray font in the configuration table, indicating that the protection does not need to be tested but needs to be reflected in the report.

[0037] Specifically, when the protection function is not present in the device, the status is marked as not configured and displayed in italics. The statistical results are used to form a report on the distribution of the enabled / disabled status.

[0038] It should be noted that step S300 above establishes a binary mapping relationship between the soft pressure plate control word and the function control word by deeply analyzing the setting file, realizing intelligent judgment and automatic labeling of the protection activation / deactivation status, solving the problem of easy error in traditional manual interpretation, and ensuring the accuracy and consistency of status recognition.

[0039] In this embodiment of the invention, step S400, which involves parsing the Extensible Markup Language structure of the fault recording file and extracting the protection action sequence, includes the following sub-steps D1 to D3: In D1: Use the parser to read the fault record header file, traverse from the root node of the fault report, and extract the fault start time and fault duration; Specifically, the FaultStartTime node value is extracted to obtain the precise time of the fault occurrence, such as "2024-06-03 16:38:48:623", and the FaultKeepingTime node value is extracted to obtain the fault duration, such as "108ms". This time information is used for subsequent action timing analysis.

[0040] In D2: Extract all protection action events from the trip information node sequence. Each action event contains time offset, action element name, action phase and action status attributes. Arrange all action events in chronological order to form a complete protection action sequence table. In D3: Fault electrical parameters are extracted from the fault information node, including fault phase selection results, fault distance value (unit: km), fault current amplitude and phase angle of each phase (e.g., phase A 1.991∠275°A), voltage amplitude and phase angle of each phase, zero-sequence current, negative-sequence current, etc. These parameters are used to verify the correctness of the protection action and calculate the accuracy of the action.

[0041] It should be noted that step S400 above achieves accurate extraction of the protection action sequence by parsing the fault recording file. This step can completely obtain key information such as fault time, action event sequence, and electrical parameters, establish a standardized action data acquisition process, and provide complete and standardized data support for intelligent matching analysis.

[0042] In this embodiment of the invention, step S500 uses an edit distance algorithm and a thesaurus for name matching, and performs association matching tests between the protection action sequence and the test items in the complete configuration matrix table through phase comparison and time logic verification, including the following sub-steps E1~E3: In E1: The names of the action elements recorded in the protection action sequence are compared with the names of the protection functions in the complete configuration matrix table. The similarity is calculated using the edit distance algorithm, and a predefined thesaurus is called to normalize the naming differences of equipment from different manufacturers. Specifically, a name matching algorithm is executed to compare the action names in the waveform recording, such as "grounding distance I-stage action", with the protection function names in the complete configuration matrix table. The Levenshtein distance editing algorithm is used to calculate the string similarity, with a similarity threshold set at 75%. A predefined thesaurus is called to handle naming differences between different manufacturers. For example, "grounding distance" is equivalent to "grounding impedance", "zero-sequence overcurrent" is equivalent to "zero-sequence current", and "I-stage" is equivalent to "Zone1". The matching accuracy is improved through thesaurus conversion.

[0043] It should be noted that the predefined thesaurus is a terminology mapping set specifically designed for the power system protection field to address the inconsistency in naming the same protection function among different equipment manufacturers. It stores, in structured data form, professional terms with the same function but different expressions and their corresponding relationships. During name matching, aliases in the input text are automatically unified to standard names through query and replacement, thereby eliminating ambiguity caused by manufacturer differences and significantly improving the accuracy and reliability of intelligent matching between protection action elements and configuration items.

[0044] In E2: The action phase information recorded in the protection action sequence is compared with the phase field of the specific test item in the complete configuration matrix table to realize the association between the action event and the corresponding phase test item; For example, if "phase A" in the waveform is matched with the "grounding distance segment I - phase A" test item, then for three-phase operation, the three test items A, B, and C are matched simultaneously, and for phase-to-phase fault, the corresponding phase-to-phase combination is matched.

[0045] In E3: Based on the time sequence of events in the protection action sequence, verify the logical correctness of the protection action timing, and judge the rationality of the action timing according to the type of protection function; Specifically, the reasonableness of the action time is judged according to the protection type. Instantaneous action protection requires less than 50ms, and delayed protection needs to be within ±10% of the setting time. The action sequence logic is verified to ensure that the protection start-up precedes the protection action and the protection action precedes the circuit breaker tripping. The main and backup coordination relationship is verified to ensure that the backup protection action time is at least 300ms later than the main protection.

[0046] It should be noted that step S500 above achieves intelligent association between protection actions and configuration items through an edit distance algorithm and a thesaurus. The innovative triple matching mechanism effectively solves the matching problem caused by naming differences between devices from different manufacturers, ensuring the accuracy and reliability of the association between action events and test items.

[0047] In this embodiment of the invention, step S600, which automatically fills the complete configuration matrix table with the results of the association matching test, identifies and marks abnormal issues, calculates test coverage, and generates a list of untested items, includes: Specifically, after a successful match, the results of the association matching test are automatically populated into the complete configuration matrix table.

[0048] For example, after a successful match, the corresponding row in the configuration table is automatically filled with the test result as "correct action", the actual action time is filled in as "35ms", the test timestamp is recorded as "2024-06-03 16:38:48", the number of tests is automatically incremented, and supplementary information such as "action normal, distance measured 8.66km" is filled in the remarks column. A green background is used to mark the test as passed.

[0049] Specifically, protection systems that have been put into operation but for which no action record has been found are marked "Pending Test" and given a yellow warning; protection systems that should have operated but did not are marked "Refusal to Operate" and given a red warning; protection systems whose action time deviation exceeds ±10% of the set value are marked "Abnormal Action Time"; and protection systems that should not have operated but did are marked "False Operation".

[0050] Specifically, the test coverage rate is calculated as the number of tested and implemented protection items divided by the total number of implemented protection items multiplied by 100%. Based on the calculated test coverage rate, a list of untested items and supplementary test recommendations are generated.

[0051] It should be noted that the above step S600 can automatically mark abnormal situations such as failure to operate and accidental operation, and calculate test coverage to generate a list of untested items, which greatly improves the refinement and completeness of test management and provides a clear direction for improvement in subsequent testing work.

[0052] In this embodiment of the invention, step S700 analyzes the test results from multiple dimensions, uses natural language processing technology to convert the analyzed technical data into standardized text descriptions, and generates a standardized verification report, including: Specifically, the test results are analyzed from three dimensions: completeness, correctness, and cooperation, including: Check whether all protection functions marked as enabled in the complete configuration matrix table have corresponding test records, analyze the distribution of test execution times for various protection functions, and identify and record test blind spots in the system. The actual action values ​​recorded in the protection action sequence are compared with the corresponding protection setting parameters in the complete configuration matrix table to verify the degree of conformity, and the deviation rate between the measured value and the setting value is calculated. Based on the time information recorded in the protection action sequence, verify whether the action time coordination relationship between the main protection and the backup protection meets the preset logical requirements.

[0053] It should be noted that the preset logical requirements refer to the time coordination rules and logical judgment criteria pre-set based on power industry standards and relay protection principles to ensure the correct operation of power system protection devices. The preset logical requirements clearly define the necessary timing relationship between primary and backup protection. For example, primary protection should take precedence over backup protection, and the backup protection must be activated only after a preset time interval following a failure or activation of the primary protection. Furthermore, the protection activation signal must precede the protection action signal, and the protection action signal must precede the circuit breaker trip signal to ensure the strict sequentiality of the fault clearing logic.

[0054] Specifically, natural language processing technology is used to convert the analyzed technical data and conclusions into textual descriptions that conform to industry standards. This integrates complete configuration matrix tables, analysis conclusions, and standardized textual descriptions to automatically generate standardized verification reports. Standardized reports are output in formats such as Word (Microsoft Word), PDF (Portable Document Format), and Excel (Microsoft Spreadsheet).

[0055] It should be noted that step S700 above conducts a comprehensive analysis from three dimensions: completeness, accuracy, and compatibility, automatically converting technical data into text descriptions that conform to industry standards, ensuring the professionalism and standardization of the report content, and significantly improving the efficiency and quality of report preparation.

[0056] Example 2: This example provides an automatic generation system for substation protection information verification reports, including: The file extraction module is used to establish a network connection by connecting to the station control layer switch via a network cable, access the protection device using the manufacturing message specification protocol, obtain fault recording files, substation configuration files and setting sheet files, and store them in an index according to device name and timestamp. The first parsing module is used to parse the substation configuration file, identify the type of protection device, and generate a complete configuration matrix table containing all protection functions that should be configured according to power industry standards. The second parsing module is used to extract the soft pressure plate control word and function control word from the setting sheet file, establish a binary bit mapping relationship, comprehensively judge the activation / deactivation status of each protection and mark it in the complete configuration matrix table; The third parsing module is used to parse the Extensible Markup Language structure of the fault recording file and extract the protection action sequence. The matching test module is used to perform name matching using the edit distance algorithm and the thesaurus, and to perform association matching tests between the protection action sequence and the test items in the complete configuration matrix table through phase comparison and time logic verification. The test result analysis module is used to automatically populate the results of associated matching tests into the complete configuration matrix table, identify and mark abnormal issues, calculate test coverage, and generate a list of untested items. The report generation module is used to analyze test results from multiple dimensions. It uses natural language processing technology to convert the analyzed technical data into standardized text descriptions and generate standardized verification reports.

[0057] It should be noted that the technical solution of the automatic generation system for substation protection information verification reports is based on the same concept as the technical solution of the automatic generation method for substation protection information verification reports described above. For details not described in detail in the technical solution of the automatic generation system for substation protection information verification reports described above, please refer to the description of the technical solution of the automatic generation method for substation protection information verification reports described above.

[0058] The above-mentioned unit modules can be embedded in the processor of the electronic device in hardware form or independent of it, or they can be stored in the memory of the electronic device in software form, so that the processor can call and execute the corresponding operations of the above modules.

[0059] This embodiment also provides an electronic device, which includes a processor, a memory, a communication interface, a display screen, and an input device connected via a system bus. The processor provides computing and control capabilities. The memory includes a non-volatile storage medium and internal memory. The non-volatile storage medium stores an operating system and computer programs. The internal memory provides an environment for the operation of the operating system and computer programs in the non-volatile storage medium. The communication interface communicates with an external terminal. When the computer program is executed by the processor, it implements a method for automatically generating substation protection information verification reports. The display screen can be a liquid crystal display (LCD) or an e-ink display. The input device can be a touch layer covering the display screen, buttons, a trackball, or a touchpad mounted on the device's casing, or an external keyboard, touchpad, or mouse.

[0060] This embodiment also provides a computer-readable storage medium having a computer program stored thereon, which, when executed by a processor, implements the method proposed in the above embodiments.

[0061] The storage medium proposed in this embodiment belongs to the same inventive concept as the method proposed in the above embodiments. Technical details not described in detail in this embodiment can be found in the above embodiments, and this embodiment has the same beneficial effects as the above embodiments.

[0062] Based on the above description of the implementation methods, those skilled in the art can clearly understand that the present invention can be implemented using software and necessary general-purpose hardware, and of course, it can also be implemented using hardware, but in many cases the former is a better implementation method. Based on this understanding, the technical solution of the present invention, or the part that contributes to the prior art, can be embodied in the form of a software product. This computer software product can be stored in a computer-readable storage medium, such as a computer floppy disk, read-only memory, random access memory, flash memory, hard disk, or optical disk, and includes several instructions to cause an electronic device (which may be a personal computer, server, or network device, etc.) to execute the method of the embodiments of the present invention.

[0063] It should be noted that the above embodiments are only used to illustrate the technical solutions of the present invention and are not intended to limit it. Although the present invention has been described in detail with reference to preferred embodiments, those skilled in the art should understand that modifications or equivalent substitutions can be made to the technical solutions of the present invention without departing from the spirit and scope of the technical solutions of the present invention, and all such modifications or substitutions should be covered within the scope of the present invention.

Claims

1. A method for automatically generating substation protection information verification reports, characterized in that, include: A network connection is established by connecting to the station control layer switch via a network cable. The protection device is accessed using the manufacturing message specification protocol to obtain fault recording files, substation configuration files, and setting sheet files, and an index is created and stored according to the device name and timestamp. The substation configuration file is parsed to identify the type of protection device, and a complete configuration matrix table containing all protection functions that should be configured is generated according to power industry standards. Extract the soft control word and function control word from the setting sheet file, establish a binary bit mapping relationship, comprehensively determine the activation / deactivation status of each protection and mark it in the complete configuration matrix table; Parse the Extensible Markup Language structure of the fault recording file to extract the protection action sequence; The name matching is performed using an edit distance algorithm and a thesaurus. The protection action sequence is then matched with the test items in the complete configuration matrix table through phase comparison and time logic verification. The results of the association matching test are automatically populated into the complete configuration matrix table, abnormal issues are identified and marked, test coverage is calculated, and a list of untested items is generated. The test results are analyzed from multiple dimensions. Natural language processing technology is used to convert the analyzed technical data into standardized text descriptions and generate standardized verification reports.

2. The method for automatically generating substation protection information verification reports as described in claim 1, characterized in that, The acquisition of fault recording files, substation configuration files, and setting sheet files includes: The file service function access protection device uses the manufacturing message specification protocol to access the file directory of the protection device, and uses a multi-threaded parallel download method to obtain all fault recording files within a specified time period. The fault recording files include fault record header files, format configuration files and sampling data files. Obtain the substation configuration file containing information on all intelligent electronic device nodes and logic devices within the substation from the substation automation system, and export the setting sheet file containing setting parameters and control word settings from the protection device.

3. The method for automatically generating substation protection information verification reports as described in claim 2, characterized in that, The generation of a complete configuration matrix table containing all the protection features that should be configured includes: The intelligent electronic device nodes and logical device information of the substation configuration file are analyzed to identify the type of protection device and its corresponding bay. Based on the protection configuration specifications of the power industry standards, a standard protection function list is generated for each bay, resulting in a complete configuration matrix table containing the serial number, protection function name, protection type, phase, pressure plate status, control word, setting parameters, activation / deactivation status, test results, action time, last test time, number of tests, and remarks.

4. The method for automatically generating substation protection information verification reports as described in claim 3, characterized in that, The comprehensive determination of the activation / deactivation status of each protection and the marking of it in the complete configuration matrix table includes: Read the set value file and extract the soft pressure plate control word and function control word by keyword matching; Establish a mapping relationship between the pressure plate name and binary bits; The soft pressure plate control word is a binary number, with each bit corresponding to the enabled / disabled state of a protection function. When a bit is 1, it indicates that the function soft pressure plate is enabled, and when it is 0, it indicates that the function soft pressure plate is disabled. The function control word determines whether the protection function is enabled. Even if the soft pressure plate is enabled, if the function control word is 0, the protection will not operate. The final activation / deactivation status of each protection is determined by comprehensive evaluation. When both the soft pressure plate control word and the function control word are 1, the status is marked as activated. When either the soft pressure plate control word or the function control word is 0, the status is marked as "exited". When the protection function is not present in the device, the status is marked as not configured.

5. The method for automatically generating substation protection information verification reports as described in claim 4, characterized in that, The extraction protection action sequence includes: Starting from the root node of the fault report, traverse the fault report to extract the fault start time and fault duration; Extract all protection action events from the trip information node sequence. Each action event includes a time offset, action element name, action phase, and action status attribute. Extract fault electrical parameters from fault information nodes, including fault phase selection results, fault location values, voltage and current amplitudes and phase angles of each phase, zero-sequence current and negative-sequence current; All extracted protection action events are arranged in chronological order to form a protection action sequence.

6. The method for automatically generating substation protection information verification reports as described in claim 5, characterized in that, The step of associating and matching the protection action sequence with the test items in the complete configuration matrix table includes: The names of the action elements recorded in the protection action sequence are compared with the names of the protection functions in the complete configuration matrix table. The similarity is calculated using the edit distance algorithm, and a predefined thesaurus is called to normalize the naming differences of equipment from different manufacturers. The action phase information recorded in the protection action sequence is compared with the phase field of the specific test item in the complete configuration matrix table to realize the association between the action event and the corresponding phase test item; Based on the chronological order of events in the protection action sequence, the logical correctness of the protection action sequence is verified, and the rationality of the action timing is judged according to the type of protection function.

7. The method for automatically generating substation protection information verification reports as described in claim 6, characterized in that, The generation of the standardized verification report includes: Check whether all protection functions marked as enabled in the complete configuration matrix table have corresponding test records, analyze the distribution of test execution times for various protection functions, and identify and record test blind spots in the system. The actual action values ​​recorded in the protection action sequence are compared with the corresponding protection setting parameters in the complete configuration matrix table to verify the degree of conformity, and the deviation rate between the measured value and the setting value is calculated. Based on the time information recorded in the protection action sequence, verify whether the action time coordination relationship between the main protection and the backup protection meets the preset logical requirements; Using natural language processing technology, the technical data and conclusions obtained from the analysis are converted into text descriptions that conform to industry standards. The complete configuration matrix table, analysis conclusions and standardized text descriptions are integrated to automatically generate a standardized verification report.

8. A substation protection information verification report automatic generation system, using the substation protection information verification report automatic generation method as described in any one of claims 1 to 7, characterized in that, include: The file extraction module is used to establish a network connection by connecting to the station control layer switch via a network cable, access the protection device using the manufacturing message specification protocol, obtain fault recording files, substation configuration files and setting sheet files, and store them in an index according to device name and timestamp. The first parsing module is used to parse the substation configuration file, identify the type of protection device, and generate a complete configuration matrix table containing all protection functions that should be configured according to power industry standards. The second parsing module is used to extract the soft pressure plate control word and function control word of the setting sheet file, establish a binary bit mapping relationship, comprehensively judge the activation / deactivation status of each protection and mark it in the complete configuration matrix table; The third parsing module is used to parse the Extensible Markup Language structure of the fault recording file and extract the protection action sequence. The matching test module is used to perform name matching using an edit distance algorithm and a thesaurus, and to perform association matching tests between the protection action sequence and the test items in the complete configuration matrix table through phase comparison and time logic verification. The test result analysis module is used to automatically populate the results of the associated matching test into the complete configuration matrix table, identify and mark abnormal issues, calculate test coverage, and generate a list of untested items. The report generation module is used to analyze test results from multiple dimensions. It uses natural language processing technology to convert the analyzed technical data into standardized text descriptions and generate standardized verification reports.

9. An electronic device comprising a memory and a processor, characterized in that: The memory is used to store computer-executable instructions, and when the processor executes the computer-executable instructions, it implements the steps of the automatic generation method for substation protection information verification report as described in any one of claims 1 to 7.

10. A computer-readable storage medium having computer-executable instructions stored thereon, characterized in that: When the computer-executable instructions are executed by the processor, they implement the steps of the automatic generation method for substation protection information verification reports as described in any one of claims 1 to 7.

Images