CN111044827A - Intelligent evaluation method for multi-tap current transformer - Google Patents
Intelligent evaluation method for multi-tap current transformer Download PDFInfo
- Publication number
- CN111044827A CN111044827A CN201911395968.8A CN201911395968A CN111044827A CN 111044827 A CN111044827 A CN 111044827A CN 201911395968 A CN201911395968 A CN 201911395968A CN 111044827 A CN111044827 A CN 111044827A
- Authority
- CN
- China
- Prior art keywords
- current transformer
- test
- data
- test report
- standard
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Images
Classifications
-
- G—PHYSICS
- G01—MEASURING; TESTING
- G01R—MEASURING ELECTRIC VARIABLES; MEASURING MAGNETIC VARIABLES
- G01R31/00—Arrangements for testing electric properties; Arrangements for locating electric faults; Arrangements for electrical testing characterised by what is being tested not provided for elsewhere
-
- G—PHYSICS
- G01—MEASURING; TESTING
- G01R—MEASURING ELECTRIC VARIABLES; MEASURING MAGNETIC VARIABLES
- G01R35/00—Testing or calibrating of apparatus covered by the other groups of this subclass
- G01R35/02—Testing or calibrating of apparatus covered by the other groups of this subclass of auxiliary devices, e.g. of instrument transformers according to prescribed transformation ratio, phase angle, or wattage rating
Landscapes
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Engineering & Computer Science (AREA)
- Power Engineering (AREA)
- Testing Of Short-Circuits, Discontinuities, Leakage, Or Incorrect Line Connections (AREA)
Abstract
The application discloses a multi-tap current transformer intelligent evaluation method, which comprises the following steps: creating a template workbook in a test report form, introducing the test article information into corresponding cells in the template workbook in the current transformer test report form, and testing all taps on the secondary side of the current transformer to generate a test data excel table; importing the test data in the test data excel table into corresponding cells in a template workbook in a current transformer test report form; establishing a standard data excel worksheet, confirming and calling corresponding standards in the standard data excel worksheet according to the key information, and introducing the called standards into corresponding cells in a template workbook in a current transformer test report form; and comparing the corresponding test data and the corresponding standard in the template workbook imported into the current transformer test report form to obtain an evaluation conclusion. By introducing and evaluating the excel function formula, the situations of data introduction errors and misjudgment can be avoided, the time is saved, and the efficiency is improved.
Description
Technical Field
The application relates to the technical field of power transmission and transformation, in particular to an intelligent evaluation method for a multi-tap current transformer.
Background
The current transformer converts a large current flowing through a primary side winding of the current transformer into a small current flowing through a secondary side winding according to an electromagnetic induction principle, and is used for realizing measurement or relay protection.
The multi-tap current transformer is characterized in that a plurality of taps are arranged on a secondary side winding of the current transformer, the number of turns of the secondary side winding corresponding to each tap is different, so that different transformation ratios can be obtained under the condition that the number of turns of a primary winding is not changed, and the current flowing through each tap on the secondary side is different.
In order to check whether various performances of the current transformer meet the corresponding industry standards, the current transformer needs to be tested, and test data can be used only if the test data meet the corresponding industry standards. At present, evaluation test of the current transformer can only judge whether test data is qualified or not by manually contrasting corresponding industry standards after the test, the test evaluation method depends on subjective judgment of testers, the data is easy to be copied in the data copying process, the process is complicated and time-consuming, and the condition of misjudgment is easy to occur, so that the test evaluation conclusion is not accurate.
Disclosure of Invention
In order to solve the technical problems, the following technical scheme is provided:
in a first aspect, an embodiment of the present application provides a method for intelligently evaluating a multi-tap current transformer, where the method includes: creating a template workbook in a test report form, and importing test article information into corresponding cells in the template workbook in the current transformer test report form, wherein the test article information comprises: information on the transformer substation and the current transformer nameplate; testing all taps on the secondary side of the current transformer to generate a test data excel table; importing the test data in the test data excel table into corresponding cells in a template workbook in a current transformer test report form; creating a standard data excel worksheet, confirming and calling corresponding standards in the standard data excel worksheet according to the key information, and importing the corresponding standards in the called standard data excel worksheet into corresponding cells in a template workbook in a current transformer test report form; and comparing the test data and the standard imported into the corresponding cells in the template workbook in the current transformer test report form to obtain an evaluation conclusion.
By adopting the implementation mode, the test data of all taps of the current transformer are led into the corresponding cells of the template workbook in the current transformer test report form, then the standard is called and led into the corresponding cells in the template workbook in the current transformer test report form to be compared with the test data, and when the numerical value of the test data does not accord with the standard, the cells where the test data are located change color to prompt that the test data are unqualified. The method can automatically import evaluation without manual import evaluation, reduces import time, and can not generate import data errors and misjudgment conditions by formula import evaluation.
With reference to the first aspect, in a first possible implementation manner of the first aspect, the creating a template workbook in a test report form, and importing the test article information into a corresponding cell in the template workbook in the test report form of the current transformer includes: creating a template workbook in a test report form according to a common test report template; acquiring transformer substation information and information on a current transformer nameplate; and importing the acquired transformer substation information and the information on the current transformer nameplate into corresponding cells in the created template workbook in the form of the current transformer test report.
With reference to the first aspect, in a second possible implementation manner of the first aspect, the importing the test data in the test data excel table into corresponding cells in a template workbook in a current transformer test report form includes: determining input areas of the test article information and the test data in corresponding cells in the template workbook in the current transformer test report form; and determining the position of the test data in the corresponding cell in the template workbook in the test report form of the current transformer, and importing the test data into the corresponding position to ensure that the data in the corresponding cell in the template workbook in the test report form of the current transformer is accurate.
With reference to the second possible implementation manner of the first aspect, in a third possible implementation manner of the first aspect, the importing the test data in the test data excel table into a corresponding cell in a template workbook in a current transformer test report form includes: and importing the data in the test data excel table into corresponding cells in a template workbook in a current transformer test report form through an excel formula. The test article information and various data in the corresponding cells in the template workbook in the current transformer test report form are imported through an excel formula, manual import is not needed, time is saved, and the imported data are accurate.
With reference to the first aspect, in a fourth possible implementation manner of the first aspect, the testing all taps on the secondary side of the current transformer to generate a test data excel table includes: testing all taps on the secondary side of the current transformer by using a CT tester; and exporting the test data by the CT tester and generating a test data excel table.
With reference to the first aspect, in a fifth possible implementation manner of the first aspect, the determining and calling the corresponding standard in the standard data excel worksheet according to the key information includes: determining key information according to the transformer station name and nameplate information in the test article information; and calling a standard transfer module of a corresponding module in the standard data excel worksheet by using an excel formula according to the determined key information.
With reference to the first aspect, in a sixth possible implementation manner of the first aspect, the importing the called test data into a corresponding cell in a template workbook in a current transformer test report form includes: determining a standard input area in a corresponding cell in the template workbook in the current transformer test report form; and according to the determined input area, importing the standard in the transfer module into a corresponding cell in a template workbook in a current transformer test report form through an excel formula.
By adopting the implementation mode, the used standard is determined according to the key information of the current transformer, the standard in the corresponding standard module in the standard data excel worksheet is led into the transfer module for format conversion according to the determined standard, and the converted standard is led into the corresponding cell in the template workbook in the test report form of the current transformer. The standard is directly imported through an excel formula, manual standard retrieval and search are not needed, time is saved, and imported data are accurate. The establishment of the transfer module can facilitate the standard module expansion of the standard data excel worksheet in the later period.
With reference to the fifth possible implementation manner of the first aspect, in a seventh possible implementation manner of the first aspect, the standard data excel worksheet is generated by integrating national standards, local standards and enterprise standards into one excel sheet in a modular manner. Adopt the modularized design to integrate different relevant standards together, can switch by oneself according to the production needs at any time, convenient the calling need not look for different standards according to different condition manual works when using.
With reference to the first aspect, in an eighth possible implementation manner of the first aspect, the comparing the test data and the standard imported into the corresponding cells in the template workbook in the form of the current transformer test report to obtain the evaluation conclusion includes: comparing the imported test data with the standard by using an excel formula; and prompting when the data is abnormal, and not prompting when the data is normal. The test data is directly compared with the standard through the excel formula, and a prompt is directly sent to unqualified data, so that the inaccuracy of results caused by subjective judgment of testers is avoided.
Drawings
Fig. 1 is a schematic flowchart of an intelligent evaluation method for a multi-tap current transformer according to an embodiment of the present disclosure;
FIG. 2 is a schematic diagram of a template workbook in the form of a current transformer test report provided by an embodiment of the present application;
3-4 are diagrams illustrating test data excel in a template workbook in a test report form of a current transformer to be imported according to an embodiment of the present application;
fig. 5 is a schematic diagram of a standard data excel worksheet provided in the embodiment of the present application.
Detailed Description
The present invention will be described with reference to the accompanying drawings and embodiments.
Fig. 1 is a schematic flowchart of an intelligent evaluation method for a multi-tap circuit transformer according to an embodiment of the present application, where the method includes:
s101, creating a template workbook in a test report form, and importing test article information into corresponding cells in the template workbook in a current transformer test report form, wherein the test article information comprises: information on the transformer substation and information on the current transformer nameplate.
The method comprises the steps of compiling a template workbook in a test report form according to a common test report template, importing the transformer substation information and the nameplate information of the current transformer to be evaluated, and calling corresponding data conveniently according to the test article information.
And S102, testing all taps on the secondary side of the current transformer to generate a test data excel table.
In order to obtain data of all taps on the secondary side of the current transformer, a CT tester is used for testing all taps on the secondary side of the current transformer, the CT tester is connected with all taps on the secondary side of the current transformer, and test data such as transformation ratio, order, load, direct resistance of a secondary winding, difference of ratio values, phase difference, excitation curve, error curve and the like corresponding to all taps are tested. The CT tester derives test data and generates a test data excel table, the test data of all taps generate a test data excel table correspondingly, one test data corresponds to one cell, such as the test data excel result table of one tap shown in fig. 3 and fig. 4.
And S103, importing the test data in the test data excel table into corresponding cells in the template workbook in a current transformer test report form.
In order to lead test data into the corresponding positions of the cells in the template workbook in the current transformer test report form, firstly, determining the position of each test data which needs to be led into the corresponding cell in the template workbook in the current transformer test report form; and then, importing all the test data in the test data excel table into corresponding cells in a template workbook in a current transformer test report form by utilizing an IF function formula of the excel.
And S104, creating a standard data excel worksheet, confirming and calling corresponding standards in the standard data excel worksheet according to the key information, and importing the corresponding standards in the called standard data excel worksheet into corresponding cells in a template workbook in a current transformer test report form.
In order to conveniently call national standards, local standards or enterprise standards, a standard data excel worksheet is created in the embodiment, as shown in fig. 4, a plurality of modules are arranged in the standard data excel worksheet, and each module includes a national standard module, a local standard module, an enterprise standard module and a transit module. Searching key information input in the test article information, when the searched test article information contains a local name or an enterprise name and an accuracy level, leading the standard of the corresponding accuracy level in the corresponding local standard module or enterprise standard module into a transfer module, and leading the corresponding cell in the template workbook in the form of a current transformer test report from the transfer module; and when the test article information only contains the accuracy grade, importing the standard of the corresponding accuracy grade in the national standard module into the transfer module, and importing the corresponding cell in the template workbook in the current transformer test report form from the transfer module.
In an exemplary embodiment, when the basic information in the test article information includes "jiangsu" and "0.2S accuracy level", the standard of 0.2S accuracy level of a jiangsu standard (DB 32/991 + 2007 electric energy metering device configuration specification) module in the standard data excel worksheet shown in fig. 5 is imported into the standard data excel worksheet transfer module through the IF function, and then the standard in the transfer module is imported into a corresponding cell in the template worksheet in the form of a current transformer test report through the DGET function.
And S105, comparing the test data and the standard imported into the corresponding cells in the template workbook in the current transformer test report form to obtain an evaluation conclusion.
The test data imported into the corresponding cell in the template workbook in the current transformer test report form is compared with the imported standard through the excel IF function, IF the absolute value of the test data in a certain cell is larger than the standard, the test data in the cell is considered to be unqualified, the cell is automatically subjected to color marking, and a prompt is sent out, so that a tester can clearly find abnormal data, and the evaluation effect is achieved.
It can be known from the foregoing embodiment that, in the present embodiment, an intelligent evaluation method for a multi-tap current transformer is provided, where test data and standards of all taps of the current transformer are imported into corresponding cells in a template workbook in a current transformer test report form through an excel function formula, and then the imported test data and standards are compared, so as to evaluate whether all the test data meet requirements. By introducing and evaluating the excel function formula, the situations of data introduction errors and misjudgment can be avoided, the time is saved, and the efficiency is improved.
It should be noted that, in this document, the terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, method, article, or apparatus that comprises a list of elements does not include only those elements but may include other elements not expressly listed or inherent to such process, method, article, or apparatus. Without further limitation, an element defined by the phrase "comprising an … …" does not exclude the presence of other identical elements in a process, method, article, or apparatus that comprises the element.
Of course, the above description is not limited to the above examples, and technical features that are not described in this application may be implemented by or using the prior art, and are not described herein again; the above embodiments and drawings are only for illustrating the technical solutions of the present application and not for limiting the present application, and the present application is only described in detail with reference to the preferred embodiments instead, it should be understood by those skilled in the art that changes, modifications, additions or substitutions within the spirit and scope of the present application may be made by those skilled in the art without departing from the spirit of the present application, and the scope of the claims of the present application should also be covered.
Claims (9)
1. A multi-tap current transformer intelligent evaluation method is characterized by comprising the following steps:
creating a template workbook in a test report form, and importing test article information into corresponding cells in the template workbook in the current transformer test report form, wherein the test article information comprises: information on the transformer substation and the current transformer nameplate;
testing all taps on the secondary side of the current transformer to generate a test data excel table;
importing the test data in the test data excel table into corresponding cells in a template workbook in a current transformer test report form;
creating a standard data excel worksheet, confirming and calling corresponding standards in the standard data excel worksheet according to the key information, and importing the corresponding standards in the called standard data excel worksheet into corresponding cells in a template workbook in a current transformer test report form;
and comparing the test data and the standard imported into the corresponding cells in the template workbook in the current transformer test report form to obtain an evaluation conclusion.
2. The intelligent evaluation method for the multi-tap current transformer according to claim 1, wherein the creating of the template workbook in the test report form and the importing of the test article information into the corresponding cells in the template workbook in the test report form of the current transformer comprises:
creating a template workbook in a test report form according to a common test report template;
acquiring transformer substation information and information on a current transformer nameplate;
and importing the acquired transformer substation information and the information on the current transformer nameplate into corresponding cells in the created template workbook in the form of the current transformer test report.
3. The intelligent evaluation method for the multi-tap current transformer according to claim 1, wherein the step of importing the test data in the test data excel table into the corresponding cells in the template workbook in the form of a test report of the current transformer comprises the following steps:
determining input areas of the test article information and the test data in corresponding cells in the template workbook in the current transformer test report form;
and according to the determined input area, corresponding data such as transformer substation information, nameplate information, transformation ratio in a test data excel table, order, load, direct resistance of a secondary winding, difference of ratio values, phase difference, excitation curve, error curve and the like in the test article information are led into corresponding cells in a template workbook in a current transformer test report form.
4. The intelligent evaluation method for the multi-tap current transformer according to claim 3, wherein the step of importing the test data in the test data excel table into the corresponding cells in the template workbook in the form of a test report of the current transformer comprises the following steps:
and importing the data in the test data excel table into corresponding cells in a template workbook in a current transformer test report form through an excel formula.
5. The intelligent evaluation method of a multi-tap current transformer according to claim 1, characterized in that: the step of testing all taps on the secondary side of the current transformer to generate a test data excel table comprises the following steps:
testing all taps on the secondary side of the current transformer by using a CT tester;
and exporting the test data by the CT tester and generating a test data excel table.
6. The intelligent evaluation method for the multi-tap current transformer according to claim 1, wherein the confirming and calling the corresponding standard in the standard data excel worksheet according to the key information comprises:
determining key information according to the transformer station name and nameplate information in the test article information;
and calling a standard transfer module of a corresponding module in the standard data excel worksheet by using an excel formula according to the determined key information.
7. The intelligent evaluation method for a multi-tap current transformer according to claim 1, wherein the importing the called test data into the corresponding cells in the template workbook in the form of a current transformer test report comprises:
determining a standard input area in a corresponding cell in the template workbook in the current transformer test report form;
and according to the determined input area, importing the standard in the transfer module into a corresponding cell in a template workbook in a current transformer test report form through an excel formula.
8. The intelligent evaluation method of the multi-tap current transformer according to claim 6, wherein the standard data excel worksheet is generated by integrating national standards, local standards and enterprise standards into one excel sheet in a modular manner.
9. The intelligent evaluation method for a multi-tap current transformer according to claim 1, wherein the comparing test data and criteria imported into corresponding cells in a template workbook in a current transformer test report form to draw an evaluation conclusion comprises:
comparing the imported test data with the standard by using an excel formula;
and prompting when the data is abnormal, and not prompting when the data is normal.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911395968.8A CN111044827A (en) | 2019-12-30 | 2019-12-30 | Intelligent evaluation method for multi-tap current transformer |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911395968.8A CN111044827A (en) | 2019-12-30 | 2019-12-30 | Intelligent evaluation method for multi-tap current transformer |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN111044827A true CN111044827A (en) | 2020-04-21 |
Family
ID=70241817
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201911395968.8A Pending CN111044827A (en) | 2019-12-30 | 2019-12-30 | Intelligent evaluation method for multi-tap current transformer |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111044827A (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN114137469A (en) * | 2021-11-25 | 2022-03-04 | 国网陕西省电力公司西咸新区供电公司 | Method and system for realizing intelligent calibration of multi-tap current transformer |
| CN115980654A (en) * | 2023-02-03 | 2023-04-18 | 广州市德珑电子器件有限公司 | Current transformer detection method and system |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102650984A (en) * | 2011-02-24 | 2012-08-29 | 鸿富锦精密工业（深圳）有限公司 | Test report generation system and method |
| CN105510859A (en) * | 2016-01-28 | 2016-04-20 | 云南电网有限责任公司电力科学研究院 | System and method for evaluating electronic transformer |
| CN106294956A (en) * | 2016-08-02 | 2017-01-04 | 国网黑龙江省电力有限公司齐齐哈尔供电公司 | For detecting the processing system of current transformer |
| CN108920718A (en) * | 2018-07-27 | 2018-11-30 | 南方电网调峰调频发电有限公司检修试验分公司 | For the template system of power transformer winding D. C. resistance test data in-situ processing, implementation method and operating method |
| CN109255112A (en) * | 2018-08-29 | 2019-01-22 | 中国信息通信研究院 | A kind of report automatic generation method and system |
| CN109521300A (en) * | 2018-11-29 | 2019-03-26 | 贵州电网有限责任公司 | A kind of test method of multifunctional digital tester |
-
2019
- 2019-12-30 CN CN201911395968.8A patent/CN111044827A/en active Pending
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102650984A (en) * | 2011-02-24 | 2012-08-29 | 鸿富锦精密工业（深圳）有限公司 | Test report generation system and method |
| CN105510859A (en) * | 2016-01-28 | 2016-04-20 | 云南电网有限责任公司电力科学研究院 | System and method for evaluating electronic transformer |
| CN106294956A (en) * | 2016-08-02 | 2017-01-04 | 国网黑龙江省电力有限公司齐齐哈尔供电公司 | For detecting the processing system of current transformer |
| CN108920718A (en) * | 2018-07-27 | 2018-11-30 | 南方电网调峰调频发电有限公司检修试验分公司 | For the template system of power transformer winding D. C. resistance test data in-situ processing, implementation method and operating method |
| CN109255112A (en) * | 2018-08-29 | 2019-01-22 | 中国信息通信研究院 | A kind of report automatic generation method and system |
| CN109521300A (en) * | 2018-11-29 | 2019-03-26 | 贵州电网有限责任公司 | A kind of test method of multifunctional digital tester |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN114137469A (en) * | 2021-11-25 | 2022-03-04 | 国网陕西省电力公司西咸新区供电公司 | Method and system for realizing intelligent calibration of multi-tap current transformer |
| CN115980654A (en) * | 2023-02-03 | 2023-04-18 | 广州市德珑电子器件有限公司 | Current transformer detection method and system |
| CN115980654B (en) * | 2023-02-03 | 2023-10-31 | 广州市德珑电子器件有限公司 | Current transformer detection method and system |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CA2908579C (en) | Method and device for testing a transformer | |
| CN102073029B (en) | Electronic mutual inductor test system and test method | |
| CN100432680C (en) | Forcipated mutual-inductor, forcipated ammeter and verification method of forcipated ammeter | |
| CN107677980B (en) | Integrated detection platform and method for metering performance of mutual inductor of power distribution network | |
| CN108761375B (en) | Low-power consumption program-controlled current transformer on-site calibrating device | |
| CN102012494A (en) | Transformer calibrator and calibration method thereof | |
| CN111044827A (en) | Intelligent evaluation method for multi-tap current transformer | |
| US20150356213A1 (en) | Method and system for generating electric load models | |
| CN101460856B (en) | Method for determining linear electric response of transformer, electricity generator or electric motor | |
| CN112485743A (en) | Mutual inductor deviation identification method based on PMU data | |
| Bosovic et al. | Deterministic aggregated harmonic source models for harmonic analysis of large medium voltage distribution networks | |
| CN109406877B (en) | Method and device for measuring harmonic transmission coefficient of capacitor voltage transformer | |
| CN201876538U (en) | Transformer calibrator | |
| CN103217597A (en) | Construction method of general test template of digital relay protective device | |
| CN111581941A (en) | Method for report comparison and verification of relay protection device | |
| CN105699781B (en) | A kind of transformer leakage inductance and Measuring DC Resistance | |
| CN104392398A (en) | Import and export function test system and method of power distribution automation CIM (common information model) | |
| Hempel et al. | Smart network control with coordinated PV infeed | |
| CN102866378A (en) | Voltage or current transformer on-line test device and voltage or current transformer on-line test method | |
| CN104849532A (en) | Precise current sensor | |
| Forcan et al. | Modeling of Low Voltage Transformer based on Laboratory Testing Results | |
| CN104461627A (en) | Importing method of intelligent substation testing equipment SV and GOOSE configuration parameters | |
| CN107015954A (en) | Equipment mainboard dial-up method to set up and system | |
| CN112198359A (en) | Current sampling system and method of photovoltaic module | |
| CN105279085A (en) | Rule self-defining based smart substation configuration file test system and method |
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 | ||
| RJ01 | Rejection of invention patent application after publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20200421 |