CN108920718B - Template system for field processing of power transformer winding direct-current resistance test data, implementation method and operation method - Google Patents
Template system for field processing of power transformer winding direct-current resistance test data, implementation method and operation method Download PDFInfo
- Publication number
- CN108920718B CN108920718B CN201810845876.4A CN201810845876A CN108920718B CN 108920718 B CN108920718 B CN 108920718B CN 201810845876 A CN201810845876 A CN 201810845876A CN 108920718 B CN108920718 B CN 108920718B
- Authority
- CN
- China
- Prior art keywords
- module
- test data
- test
- judgment
- phase winding
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
Images
Classifications
-
- G—PHYSICS
- G01—MEASURING; TESTING
- G01R—MEASURING ELECTRIC VARIABLES; MEASURING MAGNETIC VARIABLES
- G01R27/00—Arrangements for measuring resistance, reactance, impedance, or electric characteristics derived therefrom
- G01R27/02—Measuring real or complex resistance, reactance, impedance, or other two-pole characteristics derived therefrom, e.g. time constant
-
- G—PHYSICS
- G01—MEASURING; TESTING
- G01K—MEASURING TEMPERATURE; MEASURING QUANTITY OF HEAT; THERMALLY-SENSITIVE ELEMENTS NOT OTHERWISE PROVIDED FOR
- G01K13/00—Thermometers specially adapted for specific purposes
Landscapes
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Testing Of Short-Circuits, Discontinuities, Leakage, Or Incorrect Line Connections (AREA)
Abstract
A template system for field processing of power transformer winding direct current resistance test data is configured on a mobile terminal and comprises an input module, an importing module and a data processing module, wherein the input module is used for obtaining input current test data; the calculation module is used for obtaining the test data and the historical test data and calculating according to a calculation formula to obtain a calculation result; the display module is used for obtaining and displaying the test data, the historical test data and the calculation result; the storage module is used for obtaining the test data and the calculation result and storing the test data and the calculation result into a database; and the report generating module is used for generating a test report according to the test report template and outputting the test report. The template system can carry out on-site calculation, storage and report generation on the test data on the mobile terminal, thereby greatly simplifying the on-site work of testers.
Description
Technical Field
The invention relates to the field of preventive tests of power equipment, in particular to a template system for field processing of test data, an implementation method and an operation method.
Background
At present, when a preventive test is performed on a power transformer, a tester needs to write test data by hand while using a comparison scheme field wiring debugging device, perform related data conversion, and judge whether the test data is qualified or not by looking over rules and historical data, and often stop a test project to spend a large amount of time for calculation and judgment, and then perform the next project after the completion. After the test is finished, a large number of test reports need to be compiled, testers manually edit tables through computers by means of hands, data are input, the labor amount is large, errors are prone to occurring, in addition, test report templates are not uniform, and report styles compiled by different workers and different periods are different. After the test report is finished, the test report file is only subjected to filing treatment, and database storage work on specific test data of the report is lacked, so that on one hand, the data safety is poor, and on the other hand, historical data of the test cannot be conveniently inquired and retrieved.
Disclosure of Invention
An object of the present invention is to provide a method and apparatus for on-site calculation, storage and report generation of test data of dc resistance of power transformer winding, so as to solve at least one of the above problems. According to one aspect of the invention, a template system for field processing of power transformer winding direct current resistance test data is provided, the template system is configured on a mobile terminal and comprises
The input module is used for obtaining input test data, and the test data comprises the oil temperature of a power transformer winding and the test data of a direct-current resistor of a three-phase winding;
the importing module is used for importing historical test data from a database, wherein the historical test data are test data of the oil temperature and the direct-current resistance of the three-phase winding obtained in the last test;
the calculation module is used for obtaining the test data and the historical test data and calculating according to the test data and the historical test data and a calculation formula to obtain a calculation result; the calculation result comprises an average value of three-phase winding direct-current resistances respectively corresponding to the current test and the historical test, an unbalance rate among the three-phase winding direct-current resistances, a three-phase winding direct-current resistance when the oil temperature is converted to 20 ℃, and a deviation rate of the same position between the three-phase winding direct-current resistance of the current test and the three-phase winding direct-current resistance of the historical test;
the display module is used for obtaining and displaying the test data, the historical test data and the calculation result;
the storage module is used for obtaining the test data and the calculation result and storing the test data and the calculation result into a database;
and the report generation module is used for obtaining the test data and the calculation result, generating a test report according to the test report template and outputting the test report.
The template system can be used for carrying out on-site calculation, storage and report generation on the direct current resistance test data of the power transformer winding on the mobile terminal, and greatly simplifies the on-site work of testers.
In some embodiments, the testing device further comprises a comparison and judgment module, configured to obtain a calculation result, and according to a comparison and judgment rule, judge whether an imbalance between the dc resistances of the three-phase windings and a deviation rate of the same portion between the dc resistance of the three-phase winding tested this time and the dc resistance of the three-phase winding tested historically meet requirements, if the imbalance meets the requirements, determine that the three-phase winding is qualified, and if the imbalance does not meet the requirements, determine that the three-phase winding is not qualified; the display module is also used for obtaining and displaying the judgment result.
Therefore, the judgment result of whether the test is qualified or not can be automatically output, and the workload of testers is further reduced.
In some embodiments, the input module is further used for obtaining the input transformer type and the wiring mode of the three-phase winding of the transformer;
the comparison and judgment module is also used for calling a comparison and judgment rule corresponding to the type of the tested transformer and the wiring mode of the three-phase winding according to the type of the transformer after obtaining the calculation result, judging whether the unbalance rate between the direct-current resistances of the three-phase winding and the deviation rate of the same part between the direct-current resistance of the three-phase winding tested at this time and the direct-current resistance of the three-phase winding tested historically meet the requirements or not, if the unbalance rate and the deviation rate meet the requirements, outputting a qualified judgment, and if the unbalance rate and the deviation rate do not meet the requirements, outputting an unqua.
Therefore, the comparison and judgment rules can be correspondingly selected according to the type of the transformer and the wiring mode of the three-phase winding, so that the judgment process is more automatic.
In some embodiments, the input module is implemented by Excel;
the database is a MySQL database, and the import module is realized by configuring an Excel plug-in of MySQL;
the calculation formula is configured in a calculation module through Excel VBA, and the calculation module is realized through Excel;
the comparison judgment rule is configured in a comparison judgment module through an Excel VBA, and the comparison judgment module is realized through the Excel;
the display module is realized through Excel;
the storage module is realized by configuring an Excel plug-in of MySQL.
The test report template is configured in the report generation module through Excel VBA, and the test report template is realized through Excel.
Therefore, the field processing of the test data can be conveniently carried out on the mobile terminal supporting the windows system.
The invention also provides a method for realizing the template system, which comprises the following steps of configuring on a mobile terminal,
configuring a data processing template in an Excel file, wherein the data processing template comprises an input module, an import module, a calculation module, a display module, a storage module and a report generation module;
the input module is configured to obtain input test data of this time;
configuring a related calculation formula for the input module, the import module and the display module in the calculation module through the Excel VBA;
configuring an Excel plug-in of MySQL in a data processing template, communicating the data processing template with a MySQL database through a database plug-in, leading in historical experimental data through the plug-in by an import module, and storing the experimental data and the calculation result into the MySQL database through the plug-in by a storage module;
configuring a display module to obtain and display the test data, the historical test data and the calculation result;
configuring a test report template in a report generating module through Excel VBA, configuring the report generating module to obtain the current test data and a calculation result, generating a test report according to the test report template, and outputting the test report.
Therefore, on-site calculation, storage and report generation can be carried out on the direct current resistance test data of the power transformer winding on the mobile terminal, and the on-site work of testers is greatly simplified.
In some embodiments, the method further comprises the following steps of configuring a comparison judgment rule in a comparison judgment module through Excel VBA, configuring the comparison judgment module to obtain the imbalance rate between the direct current resistances of the three-phase windings and the calculation result of the deviation rate of the same part between the direct current resistance of the three-phase winding tested at this time and the direct current resistance of the three-phase winding tested in the history, judging whether the calculated result meets the requirement or not according to the comparison judgment rule, if the calculated result meets the requirement, judging the calculated result to be qualified, and if the calculated result does not meet the requirement, judging the calculated result to be unqualified; the display module is configured to obtain and display the judgment result.
Therefore, the judgment result of whether the test is qualified or not can be automatically output, and the workload of testers is further reduced.
In some embodiments, further comprising the step of,
the input module is also configured to obtain the input type of the transformer and the wiring mode of the three-phase winding of the transformer;
the comparison judgment rules configured in the comparison judgment module comprise comparison judgment rules corresponding to the type of the tested transformer and the wiring mode of the three-phase winding; the comparison and judgment module is configured to call a comparison and judgment rule according to the type of the transformer and the wiring mode, judge whether the imbalance rate between the direct-current resistances of the three-phase windings and the deviation rate of the same part between the direct-current resistance of the three-phase windings tested at this time and the direct-current resistance of the three-phase windings tested in the history meet the requirements, judge that the three-phase winding is qualified if the imbalance rate meets the requirements, and judge that the three-phase winding is unqualified if the imbalance rate does; the display module is configured to obtain and display the judgment result.
Therefore, the comparison and judgment rules can be correspondingly selected according to the type of the transformer and the wiring mode of the three-phase winding, so that the judgment process is more automatic.
The invention also provides an operation method of the template system, which comprises the following steps of configuring on a mobile terminal,
inputting the test data in the input module;
searching and importing historical test data in a MySQL database by using an Excel plug-in of MySQL;
the display module displays the test data, the historical test data and the calculation result;
storing the test data and the calculation result into a MySQL database by using an Excel plug-in of MySQL;
and the report generation module generates a test report according to the test data and the calculation result and the test report template and outputs the test report.
In some embodiments, the method comprises the following steps: and the display module displays a judgment result, the judgment result is made according to whether the unbalance rate between the direct current resistances of the three-phase windings and the deviation rate of the same part between the direct current resistance of the three-phase windings tested at this time and the direct current resistance of the three-phase windings tested in the history, if the unbalance rate meets the requirement, the judgment result is qualified, and if the unbalance rate does not meet the requirement, the judgment result is unqualified.
Therefore, the judgment result of whether the test is qualified or not can be automatically output, and the workload of testers is further reduced.
In some embodiments, when the test data is input, the type of the transformer is selected to be a transformer above 1.6MVA or a transformer below 1.6MVA, and the connection mode of the three-phase winding of the transformer is selected to be star connection or delta connection;
and the display module displays a judgment result, wherein the judgment result is obtained by calling a comparison judgment rule configured in the calculation module through the Excel VBA according to the type and the wiring mode of the transformer, and the comparison judgment rule corresponds to the type of the tested transformer and the wiring mode of the three-phase winding.
Therefore, the comparison and judgment rules can be correspondingly selected according to the type of the transformer and the wiring mode of the three-phase winding, so that the judgment process is more automatic.
Drawings
FIG. 1 is a schematic diagram of a template system according to an embodiment of the present invention.
Detailed Description
The present invention will be described in further detail with reference to the accompanying drawings.
Fig. 1 schematically shows a template system for field processing of power transformer winding dc resistance test data according to an embodiment of the present invention. As shown in the figure, the template system of the invention is configured on a mobile terminal and comprises an input module, an import module, a calculation module, a display module, a storage module and a report generation module.
The input module is used for obtaining the input test data, the type of the transformer and the wiring mode of the three-phase winding of the transformer. The test data comprises the oil temperature of the power transformer winding and the test data of the direct-current resistance of the three-phase winding. The transformer type is 1.6MVA or above transformer or 1.6MVA or below transformer, and the connection mode is star connection or triangular connection. The input module is implemented by Excel.
The importing module is used for importing historical test data from a database, wherein the historical test data are test data of the oil temperature and the direct-current resistance of the three-phase winding obtained in the last test. The database is a MySQL database, and the import module is realized by configuring an Excel plug-in of MySQL.
The calculation module is used for obtaining the test data and the historical test data, and calculating according to the test data and the historical test data and a calculation formula to obtain a calculation result; the calculation result comprises the average value of the direct current resistances of the three-phase windings, the unbalance rate of the direct current resistances of the three-phase windings, the direct current resistance of the three-phase windings when the oil temperature is converted to 20 ℃, and the deviation rate of the same position between the direct current resistance of the three-phase windings and the direct current resistance of the three-phase windings in the historical test, which correspond to the current test and the historical test respectively. The calculation formula is configured in a calculation module through Excel VBA, and the calculation module is realized through Excel.
And the comparison judgment module is used for obtaining a calculation result, calling a comparison judgment rule for a star-connection type transformer above 1.6MVA or a triangle-connection type transformer above 1.6MVA or a comparison judgment rule for star-connection type transformers below 1.6MVA or a comparison judgment rule for triangle-connection type transformers below 1.6MVA according to the type of the transformer, judging whether the unbalance rate between the direct current resistances of the three-phase windings and the deviation rate of the same part between the direct current resistance of the three-phase winding tested at this time and the direct current resistance of the three-phase winding tested in the history test meet requirements or not, outputting qualified judgment if the unbalance rates meet the requirements, and outputting unqualified judgment if the unbalance rates do not meet the requirements. The comparison and judgment rule is configured in a comparison and judgment module through Excel VBA, and the comparison and judgment module is realized through Excel.
The display module is used for obtaining and displaying the test data, the historical test data, the calculation result and the judgment result. The display module is realized by Excel.
The storage module is used for obtaining the test data and the calculation result and storing the test data and the calculation result into a database. The storage module is realized by configuring an Excel plug-in of MySQL.
The report generation module is used for obtaining the test data and the calculation result, generating a test report according to the test report template, and outputting the test report. The test report template is configured in the report generation module through Excel VBA, and the test report template is realized through Excel.
The invention also provides an implementation method of the template system, which comprises the following steps:
s1: the method comprises the steps of configuring a data processing template in an Excel file, wherein the data processing template comprises an input module, an import module, a calculation module, a display module, a storage module and a report generation module.
S2: the input module is configured to obtain the input test data, the type of the transformer and the connection mode of the three-phase winding of the transformer (not shown in the figure).
Specifically, as shown in the figure, the input module is configured to input the experimental data of this time, including the test time of this time and the oil temperature t of this time10In this embodiment, a delta connection mode is taken as an example, and the dc resistance of the three-phase winding is specifically a line resistance Ra-b、Rb-c、Rc-a。
S3: the method comprises the steps of configuring an Excel plug-in of MySQL in a data processing template, communicating the data processing template with a MySQL database through a database plug-in, and configuring an import module to import historical experimental data through the plug-in.
The MySQL database is specially provided with a data operation plug-in for Excel, and can conveniently import, export and edit data. The plug-in is installed in the Excel, a menu item appears in a data menu of the Excel, and when the user clicks the menu for the first time, the user name, the password, the database name and the like for accessing the MySQL database need to be set, and then the data in the database can be read and operated at any time. Historical data of the test can be inquired and retrieved at any time through the plug-in, so that data sharing of personnel at all levels is facilitated, and the safety of the data can be ensured.
Specifically, as shown in the figure, the import module is configured to import historical test data, which is substantially the same as the current test data and includes the last test time and the last oil temperature t20Three-phase winding direct current resistance R of last testa-b、Rb-c、Rc-a。
S4: configuring a related calculation formula for the input module, the import module and the display module in the calculation module through the Excel VBA to obtain the following calculation results:
average value avr (R) of direct current resistance of three-phase windinga-b，Rb-c，Rc-a)＝(Ra-b+Rb-c+Rc-a)/3；
Imbalance ratio between direct-current resistances of three-phase windings is (max (R)a-b，Rb-c，Rc-a)-min(Ra-b，Rb-c，Rc-a))/avr(Ra-b，Rb-c，Rc-a)*100％；
Converting the direct current resistance of the three-phase winding into 20 ℃ oil temperature according to the following formula: r2＝R1((T+t2)/(T+t1) Wherein R) is1Is the oil temperature t1Three-phase winding direct-current resistance measured at (oil temperature not 20 ℃), R2For conversion to three-phase winding DC resistance at oil temperature of 20 deg.C, t2At 20 deg.C, T is a constant for calculation, 235 for copper wire and 225 for aluminum wire. Since the resistance of the dc resistor is greatly affected by the temperature, it must be converted to the same temperature (generally to20 ℃ C.) is the standard.
S5: the storage module is configured to store the test data and the calculation result into the MySQL database through the plug-in.
S6: the method comprises the steps of configuring a comparison judgment rule in a comparison judgment module through Excel VBA, configuring the comparison judgment module to obtain an imbalance rate between direct current resistances of three-phase windings and a calculation result of a deviation rate of the same part between the direct current resistance of the three-phase winding tested at this time and the direct current resistance of the three-phase winding tested in a history mode, calling the comparison judgment rule according to the type of a transformer and a wiring mode, judging whether the imbalance rate and the deviation rate meet requirements, judging the imbalance rate and the deviation rate to be qualified if the imbalance rate and the deviation rate meet the requirements, and judging the imbalance rate to be unqualified if the.
The comparison judgment rule configured in the comparison judgment module comprises the following steps: the comparison judgment rule is used for a star connection type transformer with more than 1.6MVA or a triangle connection type transformer with more than 1.6MVA, or is used for a star connection type transformer with 1.6MVA and below or a triangle connection type transformer with 1.6MVA and below.
The specific rule is as follows: the transformer is more than 1.6MVA, the unbalance rate of the star-connection type transformer is less than 2%, and the unbalance rate of the triangle-connection type transformer is less than 1%; 1.6MVA and below, the unbalance rate of star-connected transformer should be below 4%, and the unbalance rate of delta-connected transformer should be below 2%. Compared with the value measured at the same position, the variation (namely the deviation ratio of the same position between the direct current resistance of the three-phase winding tested at this time and the direct current resistance of the three-phase winding tested in the history) of the three-phase winding testing device is less than 2%.
S7: the display module is configured to obtain and display the test data, the historical test data, the calculation result and the judgment result.
S8: configuring a test report template in a report generating module through Excel VBA, configuring the report generating module to obtain the current test data and a calculation result, generating a test report according to the test report template, and outputting the test report.
The invention also provides an operation method of the template system, which comprises the following steps:
s10: the test data of this time, which are shown in table 1 below, as well as the type of the transformer and the wiring manner of the three-phase winding of the transformer (not shown in the table) are input into the input module.
TABLE 1
| The time of this test | 20170304 |
| This oil temperature t10(℃) | 42.0 |
| Ra-b(mΩ) | 1.409 |
| Rb-c(mΩ) | 1.401 |
| Rc-a(mΩ) | 1.405 |
S20: and searching and importing historical test data in a MySQL database by using an Excel plug-in of MySQL, wherein the historical test data is shown in a table 2.
TABLE 2
S30: the display module displays the current test data, the historical test data, the calculation result and the judgment result (not shown in the table), as shown in tables 3 and 4.
TABLE 3
TABLE 4
The judgment result is obtained by calling a comparison judgment rule configured in a computing module through Excel VBA according to the type and the wiring mode of the transformer. The judgment result is made according to the unbalance rate among the direct-current resistances of the three-phase windings and whether the deviation rate of the same part between the direct-current resistance of the three-phase winding tested at this time and the direct-current resistance of the three-phase winding tested in the history meets the requirement, if the deviation rate meets the requirement, the judgment result is qualified, and if the deviation rate does not meet the requirement, the judgment result is unqualified.
For example, according to the data in the above table, if the measured transformer is a transformer with a voltage of 1.6MVA or more, and the connection mode is triangular connection, the following comparison and determination rules should be adopted: the unbalance rate of the transformer with the size of more than 1.6MVA and the transformer with the triangular wiring type is less than 1 percent, and the unbalance rate obtained in the test is 0.57 percent and meets the rule. Compared with the value measured at the same position, the variation (namely the deviation ratio of the same position between the direct current resistance of the three-phase winding tested at this time and the direct current resistance of the three-phase winding tested in the history) is less than 2%, and the deviation ratio (according to the absolute value) obtained in the test is more than 14%, which is not in accordance with the rule. Therefore, the judgment result output by the test is unqualified.
S40: and storing the test data and the calculation result into a MySQL database by using an Excel plug-in of MySQL. When needed, the historical data of the test can be inquired at any time, and convenience and safety are improved.
S50: the report generation module generates a test report according to the test report template according to the current test data and the calculation result, and outputs the test report, as shown in table 5 below.
TABLE 5
In other embodiments, the comparison and judgment module can be omitted, and the display module displays the comparison and judgment rule, so that the tester can judge whether the product is qualified or not by himself; the template system can also be realized by adopting other software except Excel, and the database can adopt a database except MySQL.
What has been described above are merely some embodiments of the present invention. It will be apparent to those skilled in the art that various changes and modifications can be made, or combinations of the above-described embodiments can be made without departing from the spirit of the invention, and the scope of the invention is to be determined by the appended claims.
Claims (8)
1. The utility model provides a template system that is used for experimental data field processing of power transformer winding direct current resistance which characterized in that: the template system is configured on a mobile terminal and comprises
The input module is used for obtaining input test data, and the test data comprises the oil temperature of a power transformer winding and the test data of a direct-current resistor of a three-phase winding;
the importing module is used for importing historical test data from a database, wherein the historical test data are test data of the oil temperature and the direct-current resistance of the three-phase winding obtained in the last test;
the calculation module is used for obtaining the test data and the historical test data and calculating according to the test data and the historical test data and a calculation formula to obtain a calculation result; the calculation result comprises an average value of three-phase winding direct-current resistances respectively corresponding to the current test and the historical test, an unbalance rate among the three-phase winding direct-current resistances, a three-phase winding direct-current resistance when the oil temperature is converted to 20 ℃, and a deviation rate of the same position between the three-phase winding direct-current resistance of the current test and the three-phase winding direct-current resistance of the historical test;
the display module is used for obtaining and displaying the test data, the historical test data and the calculation result;
the storage module is used for obtaining the test data and the calculation result and storing the test data and the calculation result into a database;
the report generation module is used for obtaining the test data and the calculation result, generating a test report according to the test report template and outputting the test report;
the comparison and judgment module is used for obtaining a calculation result and judging whether the imbalance rate between the direct current resistances of the three-phase windings and the deviation rate of the same part between the direct current resistance of the three-phase windings tested at this time and the direct current resistance of the three-phase windings tested in the history are in accordance with the comparison and judgment rules, if the imbalance rate is in accordance with the requirement, the three-phase windings are judged to be qualified, and if the imbalance rate is not in accordance with the requirement, the three-phase windings are judged to be; the display module is also used for obtaining and displaying the judgment result;
the input module is realized through Excel;
the database is a MySQL database, and the import module is realized by configuring an Excel plug-in of MySQL;
the calculation formula is configured in a calculation module through Excel VBA, and the calculation module is realized through Excel;
the comparison judgment rule is configured in a comparison judgment module through an Excel VBA, and the comparison judgment module is realized through the Excel;
the display module is realized through Excel;
the storage module is realized by configuring an Excel plug-in of MySQL;
the test report template is configured in the report generation module through Excel VBA, and the test report template is realized through Excel.
2. The template system for field processing of power transformer winding direct current resistance test data according to claim 1, characterized in that:
the input module is also used for obtaining the input type of the transformer and the wiring mode of the three-phase winding of the transformer;
and the comparison and judgment module is also used for calling a comparison and judgment rule corresponding to the type of the tested transformer and the wiring mode of the three-phase winding according to the type of the transformer after obtaining the calculation result, judging whether the unbalance rate between the direct-current resistances of the three-phase winding and the deviation rate of the same part between the direct-current resistance of the three-phase winding tested at this time and the direct-current resistance of the three-phase winding tested historically meet the requirements, outputting qualified judgment if the unbalance rate and the deviation rate meet the requirements, and outputting unqualified judgment if the unbalance rate and the deviation rate do not meet the requirements.
3. The template system implementation method of claim 1, characterized in that: comprising the steps of configuring on a mobile terminal,
configuring a data processing template in an Excel file, wherein the data processing template comprises an input module, an import module, a calculation module, a display module, a storage module and a report generation module;
the input module is configured to obtain input test data of this time;
configuring a related calculation formula for the input module, the import module and the display module in the calculation module through the Excel VBA;
configuring an Excel plug-in of MySQL in the data processing template, communicating the data processing template with a MySQL database through the database plug-in, leading in historical experimental data through the plug-in by the leading-in module, and storing the experimental data and the calculation result into the MySQL database through the plug-in by the storage module;
configuring the display module to obtain and display the test data, the historical test data and the calculation result;
and configuring a test report template in the report generation module through the Excel VBA, wherein the report generation module is configured to obtain the test data and the calculation result, generate a test report according to the test report template, and output the test report.
4. The template system implementation method of claim 3, wherein: the method comprises the following steps that a comparison judgment rule is configured in a comparison judgment module through Excel VBA, the comparison judgment module is configured to obtain the unbalance rate between the direct current resistances of the three-phase windings and the calculation result of the deviation rate of the same part between the direct current resistance of the three-phase winding tested at this time and the direct current resistance of the three-phase winding tested in the history, whether the calculated result meets the requirement or not is judged according to the comparison judgment rule, if the calculated result meets the requirement, the calculated result is judged to be qualified, and if the calculated result does not meet the requirement, the calculated result is judged to be unqualifie; the display module is configured to obtain and display the judgment result.
5. The template system implementation method of claim 4, wherein: the method also comprises the following steps of,
the input module is also configured to obtain the input type of the transformer and the wiring mode of the three-phase winding of the transformer;
the comparison judgment rules configured in the comparison judgment module comprise comparison judgment rules corresponding to the type of the tested transformer and the wiring mode of the three-phase winding; the comparison and judgment module is configured to call a comparison and judgment rule according to the type of the transformer and the wiring mode, judge whether the imbalance rate between the direct-current resistances of the three-phase windings and the deviation rate of the same part between the direct-current resistance of the three-phase windings tested at this time and the direct-current resistance of the three-phase windings tested in the history meet the requirements, judge that the three-phase winding is qualified if the imbalance rate meets the requirements, and judge that the three-phase winding is unqualified if the imbalance rate does not; the display module is configured to obtain and display the judgment result.
6. The method of operation of the template system of claim 1, wherein: comprising the steps of configuring on a mobile terminal,
inputting the test data in the input module;
searching and importing historical test data in a MySQL database by using an Excel plug-in of MySQL;
the display module displays the test data, the historical test data and the calculation result;
storing the test data and the calculation result into a MySQL database by using an Excel plug-in of MySQL;
and the report generation module generates a test report according to the test data and the calculation result and the test report template and outputs the test report.
7. The method of operation of a template system according to claim 6, wherein: the method comprises the following steps: and the display module displays a judgment result, the judgment result is made according to whether the unbalance rate between the direct current resistances of the three-phase windings and the deviation rate of the same part between the direct current resistance of the three-phase windings tested at this time and the direct current resistance of the three-phase windings tested in the history, if the unbalance rate meets the requirement, the judgment result is qualified, and if the unbalance rate does not meet the requirement, the judgment result is unqualified.
8. The method of operation of a template system according to claim 7, wherein: the method comprises the following steps:
when the test data is input, selecting a transformer with the type of more than 1.6MVA or less than 1.6MVA, and selecting the connection mode of the three-phase winding of the transformer as star connection or triangular connection;
and the display module displays a judgment result, wherein the judgment result is obtained by calling a comparison judgment rule configured in the calculation module through the Excel VBA according to the type and the wiring mode of the transformer, and the comparison judgment rule corresponds to the type of the tested transformer and the wiring mode of the three-phase winding.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810845876.4A CN108920718B (en) | 2018-07-27 | 2018-07-27 | Template system for field processing of power transformer winding direct-current resistance test data, implementation method and operation method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810845876.4A CN108920718B (en) | 2018-07-27 | 2018-07-27 | Template system for field processing of power transformer winding direct-current resistance test data, implementation method and operation method |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN108920718A CN108920718A (en) | 2018-11-30 |
| CN108920718B true CN108920718B (en) | 2021-04-09 |
Family
ID=64418731
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201810845876.4A Active CN108920718B (en) | 2018-07-27 | 2018-07-27 | Template system for field processing of power transformer winding direct-current resistance test data, implementation method and operation method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN108920718B (en) |
Families Citing this family (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110543197B (en) * | 2018-12-05 | 2021-04-02 | 中车长春轨道客车股份有限公司 | Method and device for controlling operation of train main transformer |
| CN110908356A (en) * | 2019-10-11 | 2020-03-24 | 成都飞机工业（集团）有限责任公司 | Flight control test data rapid fault positioning method |
| CN111044827A (en) * | 2019-12-30 | 2020-04-21 | 山东泰开高压开关有限公司 | Intelligent evaluation method for multi-tap current transformer |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103778575A (en) * | 2014-03-04 | 2014-05-07 | 国网浙江宁波市鄞州区供电公司 | Transformer state evaluation method and system |
| CN104123468A (en) * | 2014-07-25 | 2014-10-29 | 华北电力大学（保定） | Distribution transformer state assessment method based on kernel state quantity set |
| CN104569724A (en) * | 2015-01-06 | 2015-04-29 | 国家电网公司 | Transformer short-circuit fault comprehensive diagnosis method |
| CN104965140A (en) * | 2015-06-30 | 2015-10-07 | 国网山东省电力公司电力科学研究院 | Transformer field test mobile terminal and test data processing method |
Family Cites Families (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105319480B (en) * | 2014-07-21 | 2019-11-12 | 南京中兴新软件有限责任公司 | Line diagnosis method and device |
-
2018
- 2018-07-27 CN CN201810845876.4A patent/CN108920718B/en active Active
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103778575A (en) * | 2014-03-04 | 2014-05-07 | 国网浙江宁波市鄞州区供电公司 | Transformer state evaluation method and system |
| CN104123468A (en) * | 2014-07-25 | 2014-10-29 | 华北电力大学（保定） | Distribution transformer state assessment method based on kernel state quantity set |
| CN104569724A (en) * | 2015-01-06 | 2015-04-29 | 国家电网公司 | Transformer short-circuit fault comprehensive diagnosis method |
| CN104965140A (en) * | 2015-06-30 | 2015-10-07 | 国网山东省电力公司电力科学研究院 | Transformer field test mobile terminal and test data processing method |
Also Published As
| Publication number | Publication date |
|---|---|
| CN108920718A (en) | 2018-11-30 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN108920718B (en) | Template system for field processing of power transformer winding direct-current resistance test data, implementation method and operation method | |
| CN101118269A (en) | Wire connection analyse device for electric power protective circuit | |
| WO2016074429A1 (en) | Test method, controller, and test system | |
| JP2017062170A (en) | Rotary machine diagnostic system | |
| CN104698428A (en) | Multi-electric-energy-meter automated testing method | |
| CN107102287A (en) | Electric energy meter field calibration method | |
| CN115598530B (en) | Method and device for evaluating no-load characteristics of generator, electronic equipment and storage medium | |
| CN106054117B (en) | A kind of palm metering fault error analysis instrument | |
| CN116643167A (en) | Method and system for measuring grounding fault of stator bar of generator | |
| CN106526305A (en) | Phasor analyzer used for judging wiring correctness of three-phase secondary circuit | |
| CN103308795B (en) | Main transformer protective device test method and portable arithmetic facility | |
| CN109507463A (en) | Electric quantity compensating device and method | |
| Cecchi et al. | Modeling approach for transmission lines in the presence of non-fundamental frequencies | |
| CN110658405B (en) | Air conditioner line loss detection method and device, air conditioner and storage medium | |
| CN109031181B (en) | CT performance calibration instrument and CT performance calibration method adopting same | |
| CN108196211A (en) | A kind of number table automatic verification system | |
| CN116931450A (en) | Method and system for providing a simulation model of a rotary electric machine | |
| CN106980087B (en) | Variable frequency control machine, and test system and method of variable frequency motor | |
| Jansen | A future user interface for the Fluke Power Quality Analyzer: the deisng of job assistance features and touch screen functionality for power factur analysis | |
| Lyamets et al. | Description of 6–35 kV lines in recognition of earth fault in a distribution network | |
| CN109521298B (en) | Current imbalance three-dimensional fault analysis method based on time sequence | |
| CN117491719A (en) | Secondary alternating current loop detection method, device, equipment, medium and program product | |
| US11754641B2 (en) | Transformer test system and method | |
| Moon et al. | Development of a new on-line synchronous generator simulator using personal computer for excitation system studies | |
| CN115932696A (en) | Voltage transformer error calculation method and system |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant | ||
| TR01 | Transfer of patent right |
Effective date of registration: 20230109 Address after: Room 1217, No. 858, Lianhua Avenue West, Donghuan Street, Panyu District, Guangzhou, Guangdong 510000 Patentee after: INSPECTION AND TEST BRANCH OF SOUTHERN POWER GRID PEAKING FM POWER GENERATION Co.,Ltd. Patentee after: CHINA ELECTRONIC PRODUCT RELIABILITY AND ENVIRONMENTAL TESTING Research Institute (THE FIFTH ELECTRONIC Research Institute OF MIIT)(CEPREI LABORATORY)) Address before: 511400 No. 201, 301, 401, 501, No. 8 workshop, Tian'an headquarters center, No. 555, North Panyu Avenue, Donghuan street, Panyu District, Guangzhou City, Guangdong Province Patentee before: INSPECTION AND TEST BRANCH OF SOUTHERN POWER GRID PEAKING FM POWER GENERATION Co.,Ltd. |
|
| TR01 | Transfer of patent right |