A method for batch monitoring and automatically judging three-phase three-wire incorrect wiring

Abstract

The present invention belongs to the technical field of electric energy metering, and discloses a method for batch monitoring and automatic judgment of three-phase three-wire incorrect wiring, characterized in that the method comprises the following steps performed in sequence: the step of acquiring data and generating a phasor diagram; the step of generating a voltage phasor diagram; the step of generating a current phasor diagram; the step of determining the voltage phase sequence; the step of determining the current phase sequence and polarity; and the step of comprehensively completing the judgment of the incorrect wiring form of the electric energy metering device. In this application, with the help of EXCEL tools, batch monitoring and automatic judgment of three-phase three-wire incorrect wiring are realized. This application mainly has the following beneficial technical effects: higher work efficiency, less personnel usage, lower cost, more accurate and faster judgment results, and more fair and just electric energy metering.

Description

Technical Field

[0001] The invention belongs to the technical field of electric energy metering, and in particular relates to a method for batch monitoring and automatically determining three-phase three-wire incorrect wiring. Background Art

[0002] There are generally three ways to check and judge whether the wiring of the electric energy metering device connected through the mutual inductor is correct after installation and commissioning. The first is to use the electric energy meter calibrator to conduct actual measurement on site, directly display the phasor diagram, and give the judgment result of whether the wiring is correct; the second is to use the phase volt-ampere meter to measure the voltage, current, phase angle and other data on site, and then judge whether the wiring is correct by drawing the phasor diagram; the third is to generate the phasor diagram using the internal data of the smart electric energy meter; Invention patent: Method for generating wiring phasor diagram using the internal data of the smart electric energy meter, patent application number 201310636752.2, application publication number: CN103675449A, disclosed name: Method for generating wiring phasor diagram using the internal data of the smart electric energy meter, which is from the smart electric energy meter Extract effective information from powerful internal data information, use computer software to directly generate the phasor diagram of the metering circuit wiring of the energy meter, and replace the on-site calibrator to check whether there is a wrong wiring in the metering device; it saves the on-site wiring, and the data is directly read from the infrared or RS485 communication port of the energy meter, and can also be read remotely in the power consumption information collection system, realizing online monitoring of the metering device, saving the trouble of going to the site manually, and has achieved good results in practical applications; go to the site through the infrared, 485 communication interface of the energy meter or the power user's power consumption information collection system to remotely read its internal data, analyze and calculate one by one, generate a phasor diagram, and then judge the result of the wrong wiring. The first and second methods require on-site and wiring measurement, which is time-consuming and laborious; although the third method can save many troubles such as going to the site or on-site wiring, the calculation process is relatively cumbersome, and the phasor diagram needs to be analyzed and calculated one by one before it can be generated, and it is only applicable to the judgment of wrong wiring of three-phase four-wire energy metering devices. It is limited by the monitoring and processing of batch data, and the scope of application and work efficiency are still insufficient.

[0003] The construction of the power user electricity consumption information collection system (hereinafter referred to as the collection system) has laid the foundation for the application of power user electricity consumption data. The collection system is a system that collects, processes and monitors the power user's electricity consumption information in real time. It can realize the functions of automatic collection of electricity consumption information, abnormal measurement monitoring, power quality monitoring, and power consumption analysis. It consists of smart energy meters, collection terminals, communication channels, and system master stations. At present, in addition to the functions of energy metering and event recording, smart energy meters also have the function of measuring electrical parameters. They can correctly measure the voltage phase sequence, voltage, current, phase angle and other data connected to them. Some of the data can be automatically collected by the collection system, such as the electric energy, power, voltage, current, etc. measured by the smart energy meter of the special transformer user; at the same time, the above data can also be obtained through the collection system in the form of a single collection terminal call or batch inspection.

[0004] Whether the voltage phase sequence, voltage, current and phase angle data measured by the smart energy meter are normal is directly related to whether the wiring of the dedicated transformer user's energy metering device is correct or faulty. Therefore, how to use these data to quickly and accurately determine whether the energy metering device is wired incorrectly or faulty is a technical problem that needs to be solved urgently in the industry. To this end, the applicant of this application has conducted research and formed this application: a method for batch monitoring and automatic judgment of three-phase three-wire incorrect wiring, providing energy metering personnel and auditors with a tool to monitor whether the energy metering device is operating normally, so as to improve the efficiency of energy metering device operation and maintenance and anti-electricity theft. Summary of the invention

[0005] The technical problem to be solved by the present invention is to obtain data through batch inspection based on the power consumption information collection system of power users, and utilize the inherent logical relationship between the data and the functions of Excel office software such as chart generation, reference search, logical judgment and automatic calculation to automatically generate phasor diagrams, automatically judge incorrect wiring, automatically calculate the power factor angle of the load, and automatically calculate the correction coefficient value, and at the same time present the judgment results such as the incorrect wiring phase angle expression and the correction coefficient expression.

[0006] The present invention adopts the following technical solutions to solve the above technical problems:

[0007] 1. Obtain data and generate phasor diagram

[0008] (1) In the acquisition system, the voltage (U12, U32), current (I1, I3), phase angle of the electric energy metering device are obtained through batch inspection. Phase sequence (positive or negative) and other "source data". Based on the "source data", the EXCEL function is used to automatically extract useful data to form a "data source table" in a fixed format. The "data source table" contains "address code, terminal name, acquisition object, phase angle Phase sequence (positive or negative phase sequence), current (I1, I3), voltage (U12, U32)" and other fields.

[0009] (2) Use the chart function of EXCEL office software to generate phasor diagrams.

[0010] 2. Determine the voltage phase sequence

[0011] (1) The voltage phase sequence provided by the acquisition system is only a positive phase sequence or a reverse phase sequence, and the specific form of the voltage phase sequence is not given. For example, the positive phase sequence has three forms: abc, bca, and cab, and the reverse phase sequence has three forms: acb, cba, and bac.

[0012] (2) Make "voltage phase sequence and phase angle Relationship table", where the phase angle Need to use the phase angle of the survey data Calculated.

[0013] (3) Based on three conditions The positive (reverse) phase sequence determines the specific form of the voltage phase sequence.

[0014] 3. Determine the current phase sequence and polarity

[0015] (1) Make "current phase sequence, polarity and phase angle Voltage phase sequence relationship table".

[0016] (2) Based on three conditions The voltage phase sequence determines the current phase sequence and polarity.

[0017] 4. Derive the phase angle expression and correction coefficient expression, calculate the power factor angle and correction coefficient K value of the load, and make a relationship table between the voltage phase sequence, current phase sequence and polarity and the phase angle and correction coefficient K expression.

[0018] (1) Derive the phase angle expression and correction coefficient expression. There are 48 types of three-phase three-wire electric energy metering device wiring forms. Each wiring form has its own specific phasor diagram. The phase angle expression is obtained, and the corresponding correction coefficient K expression is derived accordingly.

[0019] (2) Based on the results obtained in 2, 3 and 4(1), prepare a table of the relationship between the voltage phase sequence, current phase sequence and polarity, phase angle and correction factor K.

[0020] (3) Calculate the load power factor angle and correction factor K value. According to the phase angle in the data source table The value and 4(1) Phase angle expression, calculate the power factor angle of A and C phase loads Will Substituting the value into the correction coefficient K expression in 4(1) can obtain the correction coefficient K value.

[0021] 5. Establish the relationship between the judgment result and the expression. Based on the relationship table between the voltage phase sequence, current phase sequence and polarity and the phase angle and correction coefficient K expressions obtained in 4(2), use the EXCEL logical judgment functions IF and AND to implement multiple conditions (i.e., voltage phase sequence, current phase sequence and polarity) to judge the corresponding results (i.e., phase angle expression, correction coefficient K expression), thus realizing the association between conditions and results.

[0022] 6. Centrally display the phasor diagram and judgment results. Use the EXCEL list box control to control the change of each record data by selecting the collection object in the data source table, and use the EXCEL search reference function OFFSET and COLUMN to establish the relationship between the phasor diagram, judgment results and data source table, realize the dynamic display of the phasor diagram and judgment results, and form the wrong wiring judgment operation interface of the three-phase three-wire electric energy metering device.

[0023] The present application mainly has the following beneficial technical effects: higher work efficiency, less personnel usage, lower costs, more accurate and faster determination results, and fairer and more just electricity metering. BRIEF DESCRIPTION OF THE DRAWINGS

[0024] The present invention is further described below in conjunction with the accompanying drawings.

[0025] Figure 1 It is the wiring schematic diagram of the three-phase three-wire electric energy metering device.

[0026] Figure 2 This is a screenshot of the "operation interface" for judging incorrect wiring of a three-phase three-wire electric energy metering device.

[0027] Figure 3 This is a screenshot of the "operation interface" for judging incorrect wiring of the three-phase three-wire electric energy metering device in Case 1.

[0028] Figure 4 This is a screenshot of the "operation interface" for judging incorrect wiring of the three-phase three-wire electric energy metering device in Case 2.

[0029] Figure 5 A flowchart of a method of the present application.

[0030] Figure 6 A flowchart of another method of the present application.

[0031] Figure 1This is the wiring schematic diagram of a three-phase three-wire energy meter. The three-phase three-wire energy meter consists of two components (respectively called the first component and the second component), each of which consists of a voltage loop and a current loop; the two voltage transformers adopt the V / v connection method, that is, after the two voltage transformers are combined according to the diagram, the three terminals of the primary winding are connected to the three-phase A, B, and C of the high-voltage line, and the three voltage terminals a, b, and c of the secondary winding are connected to the three-phase three-wire energy meter to output voltage phasors. The two current transformers (phase A and phase C) adopt the two-phase four-wire connection method. Their primary windings are connected in series with phase A and phase C of the high-voltage line respectively. Pass the current loop of the first and second components of the three-phase three-wire energy meter. Figure 1 "S1, S2" are the connection terminals of the secondary winding of the current transformer.

[0032] Figure 1 The "*" in the figure indicates the same polarity end of the primary and secondary windings of the voltage and current transformer and the voltage and current loop of the electric energy meter. For example, for the A-phase voltage transformer, when the primary winding voltage phasor When the direction of the secondary winding voltage is from the same polarity end "*" to the other end, The direction should also be from the same polarity end "*" to the other end; For example, for the A-phase current transformer, when the primary current phasor When the secondary current flows into the same polarity end "*" of the primary winding, its secondary current phasor It flows out from the same polarity end "*" (i.e. S1 terminal) of the secondary winding.

[0033] To facilitate explanation, the electrical parameters of the high-voltage line, transformer, and energy meter involved in the energy metering device are distinguished by different phasor symbols. For example, the line voltage phasor of the high-voltage line (or the primary winding of the voltage transformer) is represented by Indicates that the line current phasor (or the primary current of the current transformer) is expressed as Indicates; the secondary line voltage phasor of the voltage transformer is expressed as Indicates that the current phasor flowing out of the secondary terminal S1 of the current transformer is expressed as Indicates; the voltage phasor of the first and second element voltage circuits of the energy meter is expressed as The current phasor flowing into the first and second components of the energy meter is expressed by Indicates; the phase angle between the voltage phasor and the current phasor of the first element of the energy meter is expressed as The phase angle between the voltage phasor and the current phasor of the second element of the energy meter is expressed as The phase angle of the voltage phasor between the first and second components of the electric energy meter is expressed as The phase angle of the current phasor between the first and second components of the electric energy meter is expressed as express.

[0034] When the voltage and current connected to the energy meter are consistent with the voltage and current output by the transformer (such as voltage phasor Current phasor ), the electric energy metering device is correctly wired and can measure correctly, otherwise the wiring is wrong and cannot measure correctly. This is also the basis for judging whether the wiring of the electric energy metering device is correct.

[0035] Figure 2 This is a screenshot of the "operation interface" for judging incorrect wiring of a three-phase three-wire electric energy metering device, and its content consists of four modules.

[0036] Module one is the basic information of electricity users (communication address code, terminal name, collection object) and basic data (phase angle, phase sequence, current, voltage, etc.).

[0037] Module 2 is a list box, which contains the collection object information. You can select the collection object by clicking the mouse.

[0038] Module 3 is the phasor diagram, which can visually present the voltage and current phasors and their phase relationship of the energy meter, which is helpful for the staff to compare and judge whether the wiring is wrong. "Phasor" is a method used to represent sinusoidal alternating current, similar to vectors in physics, with magnitude and direction. Its magnitude is equal to the effective value of sinusoidal alternating current, and its direction is represented by the initial phase of sinusoidal alternating current.

[0039] Module 4 is the judgment result, in which "load nature" is divided into inductive load and capacitive load. For the same set of basic data, different load natures will result in different judgment results.

[0040] "Phase sequence 123" refers to the three voltage terminals of the three-phase three-wire energy meter (such as Figure 1 As shown), corresponding to the secondary voltage terminals "abc" of the voltage transformer.

[0041] "Current Wiring " refers to the current connected to the first and second components of the energy meter, and the secondary current of the current transformer correspond.

[0042] "Phase Angle ” refers to the phase difference between the voltage and current connected to the first and second components of the energy meter (that is, the phase difference in the phasor diagram and and The angle between Can be used with or The expression of is called the "phase angle expression", such as Figure 2 middle here They are the power factor angles of the A and C phase loads of the electricity user respectively.

[0043] is the calculated power factor angle of the A and C phase loads of the electricity user The value of (or )may be It may also be This is related to the judgment result of the "phase angle expression".

[0044] The "correction coefficient K value" is a value used for the calculation of electricity compensation when the electric energy metering device is wired incorrectly. It is defined as the amount of electricity (or power) when the electric energy metering device is correctly wired divided by the amount of electricity (or power) when it is incorrectly wired. The K value can have positive or negative values ​​due to different incorrect wiring methods.

[0045] "Correction coefficient K expression" and power factor angle of incorrect wiring form and load It is related to the calculation of the correction factor K value. It can be derived by using the phasor diagram and the determined incorrect wiring method through power calculation formula and trigonometric function formula analysis (see Table 7 Relationship between voltage phase sequence, current phase sequence and phase angle, and correction factor K expression).

[0046] Below Figure 2 The content of "Module 4" is explained using the data in as an example.

[0047] The same set of data generally has three judgment results, because the nature of the load is different or the power factor angle is different. Different ranges will result in different judgment results.

[0048] exist Figure 2 In "Module 4", when the load is inductive The "phase sequence 123" is determined to be "cba", which means that the voltage terminal 1 of the energy meter is connected to the secondary voltage terminal c of the voltage transformer, 2 is connected to b, and 3 is connected to a, that is, the energy meter is connected to the voltage phase.

[0049] Determine "current wiring "IcIa" means the current phasor connected to the first element of the energy meter is the secondary current phasor of the C phase current transformer The current phasor connected by the second element is the secondary current phasor of the A-phase current transformer

[0050] Determine the phase angle "for Indicates the phase angle (See Table 6 for the relationship between current phase sequence, polarity, phase angle, and voltage phase sequence).

[0051] middle, means The phase angle expression (may be Maybe Determined by the judgment result), means The phase angle expression (may be Maybe Determined by the judgment result), such as Figure 2 In the basic data phase angle The result of the phase angle expression is: Then calculate Another example Figure 3 In the basic data phase angle The result of the phase angle expression is: Then calculate

[0052] The "correction factor K value" is based on the assumption that the three-phase circuit is balanced and The result calculated based on the "correction coefficient K expression" is only used as a reference when replenishing electricity.

[0053] Similarly, when the load is capacitive Or when the load is inductive There are different judgment results.

[0054] The specific use method and precautions of the present invention are as follows (with Figure 2 For example):

[0055] (1) Scope of application of this method: ( The correctness of the judgment result is limited to the 48 wiring forms of the three-phase three-wire electric energy metering device. In addition, the judgment result will be wrong in other wiring forms or faults (such as voltage loss in one phase, ac phase current loop series connection, etc.) and serious imbalance of three-phase load. However, the correct judgment result can be obtained by combining the abnormal conditions of voltage, current data and phasor diagram.

[0056] (2) After automatically generating or manually adding data in the established format in the "Data Source Table" (the worksheet name is "TQ3-3") (as shown in Table 4), click "Collection Object" in the "List Box" (Module 2) in the "Operation Interface" (the worksheet name is "Operation Interface 3-3"). Figure 2The "Basic Information and Basic Data" (Module 1) and "Phasor Diagram" (Module 3) will change automatically, and the judgment of incorrect wiring results of the electric energy metering device (Module 4) will be completed simultaneously.

[0057] (3) For the same set of data, there are three possible judgment results, depending on the nature of the load (inductive or capacitive) and the power factor angle. Generally speaking, if one of the three judgment results has a correction coefficient K value of 1, it can be determined that the wiring is correct, but there are exceptions (such as Figure 4 Case 2) requires a comprehensive consideration of basic data and phasor diagram; if the correction coefficient K value in the three judgment results is not equal to 1, the possibility of wiring error is the greatest.

[0058] (4) is the value of the load power factor angle of phase A or phase C obtained by calculation, which is consistent with the value in the "Phase Angle Expression" or Corresponding. Figure 2 The phase angle expression is: but like Figure 3 The phase angle expression is: but

[0059] (5) The correction factor K is when the three-phase circuit is balanced and The calculation result is only used as a reference when replenishing electricity.

[0060] The method of the present invention is described below with reference to examples.

[0061] Figure 3 Case 1: Three-phase three-wire energy metering device incorrect wiring judgment "operation interface" screenshot

[0062] Case 1: In the collection system, after batch inspection and extraction of useful data, the basic information and basic data of the user "** Real Estate Co., Ltd." are obtained as shown in Table 1.

[0063] Table 1 Basic information and basic data of ** Real Estate Co., Ltd.

[0064]

[0065] like Figure 3 In the "Operation Interface 3-3" worksheet of the three-phase three-wire electric energy metering device wrong wiring judgment, select the collection object "000255****" in the list box to get the judgment result: the phase sequence is cba, and the current wiring is (That is, the wiring of the first element of the energy meter is The wiring of the second element is ), the phase angle expression The correction coefficient K value is ∞, indicating that the electric energy meter does not measure. Based on this, we checked on site and found that the wiring of the user's electric energy meter was consistent with the judgment result.

[0066] Figure 4 Case 2: Three-phase three-wire energy metering device incorrect wiring judgment "operation interface" screenshot

[0067] Case 2: In the collection system, after batch inspection and extraction of useful data, the basic information and basic data of the user "** Real Estate Co., Ltd." are obtained as shown in Table 2.

[0068] Table 2 Basic information and basic data of ** Real Estate Development Co., Ltd.

[0069]

[0070] like Figure 4 In the "Operation Interface 3-3" worksheet of the three-phase three-wire electric energy metering device wrong wiring judgment, select the collection object "001000174*****" in the list box to get the judgment result: the phase sequence is abc, and the current wiring is (That is, the wiring of the first element of the energy meter is The wiring of the second element is ), the calculated correction coefficient K value is 1, and the judgment result is that the metering wiring is correct. But in fact, this judgment result is wrong. Combining the patrol data and the phasor diagram, it is found that the current values ​​of the first and second components are I1=I3=0.16A, and the generated phasor diagram is abnormal. The directions are opposite, which means that the current loops of the first and second components of the energy meter are connected in series with the secondary windings of the A and C phase current transformers to form a loop, that is, the current input terminal of one component of the energy meter is connected to the current output terminal of another component by mistake, which leads to this phenomenon. Based on this, the on-site inspection found that the user's energy meter wiring was consistent with the judgment result, which is also an unexpected gain in the application of the invention. DETAILED DESCRIPTION

[0071] 1. Obtain data and generate phasor diagram

[0072] (1) Obtaining data

[0073] The data required to generate the three-phase three-wire connection phase diagram are: voltage U12, U32, current I1, I3, phase angle Voltage phase sequence.

[0074] After batch testing the "voltage data block", "current data block", "phase angle data block" and "electric meter operation status word 7" data items in the acquisition system, download and obtain the "source data" table, whose file name is "export.csv", as shown in Table 3. Store the file in the "electric energy metering device incorrect wiring judgment" folder.

[0075] Table 3 "Source data" table

[0076]

[0077] In the "Test Results" of Table 3, for the three-phase three-wire electric energy metering device, the A-phase voltage is the first element voltage U12 of the electric energy meter, and the C-phase voltage is the second element voltage U32 of the electric energy meter; the A-phase current is the first element current I1 of the electric energy meter, and the C-phase current is the second element current I3 of the electric energy meter; the A-phase phase angle is the voltage phasor of the first element of the electric energy meter With current phasor The phase angle The phase angle of phase C is the voltage phasor of the second element of the energy meter With current phasor The phase angle The reverse phase sequence of voltage without fault is the positive phase sequence, and the reverse phase sequence of voltage with fault is the reverse phase sequence.

[0078] Create a new EXCEL file "Three-phase three-wire incorrect wiring judgment tool" in the "Electric energy metering device incorrect wiring judgment" folder, name three worksheets: data extraction worksheet TQ, format conversion worksheet GS, data source worksheet TQ3-3, and use the source data file export.csv as the basis to convert the source data table (Table 3) format into the data source table (Table 4) format by using EXCEL functions through character extraction, format conversion and data separation, so as to form a fixed format three-phase three-wire "data source table" (in Figure 2 The worksheet name in is "TQ3-3")

[0079] Table 4 Three-phase three-wire "Data Source Table" (Worksheet name is "TQ3-3")

[0080]

[0081] (2) Generate phasor diagram

[0082] Create a new worksheet named "Operation Interface 3-3" in the "Three-phase Three-wire Wrong Wiring Judgment Tool" EXCEL file, and use the EXCEL office software chart function to generate a phasor diagram in this worksheet. As a reference, the voltage phasor is Current phasor Draw it out.

[0083] Generate a voltage phasor diagram. That is, draw the voltage phasor The voltage phasor Voltage phasor In the power system, the three-phase voltage is generally symmetrical, that is, equal in magnitude and 120° out of phase. The method for generating the voltage phasor diagram is: As the reference, the phase angle Assume that voltage U1=U2=U3=1, then voltage U12=U32=1.732. If the voltage is positive phase sequence, due to the voltage phasor Leading voltage phasor The phase angle is 120°, then the phase angle Due to voltage phasor Leading voltage phasor The phase angle is 240°, then the phase angle Due to voltage phasor The voltage phasor can be obtained by drawing a phasor diagram or calculating Leading voltage phasor The phase angle is 330°, so the phase angle Due to voltage phasor The voltage phasor can be obtained by drawing a phasor diagram or calculating Leading voltage phasor The phase angle is 270°, so the phase angle The coordinate values ​​of each voltage phasor are calculated from this; for example, when the voltage is in positive phase sequence, due to the phase angle Then the voltage phasor The coordinate values ​​of the starting point are X0=0, Y0=0, and the coordinate values ​​of the end point are

[0084] If the voltage is in reverse phase sequence, the voltage phasor Leading voltage phasor The phase angle is 240°. Due to voltage phasor Leading voltage phasor The phase angle is 120°, then the phase angle Due to voltage phasor The voltage phasor can be obtained by drawing a phasor diagram or calculating Leading voltage phasor The phase angle is 30°, so the phase angle Due to voltage phasor The voltage phasor can be obtained by drawing a phasor diagram or calculating Leading voltage phasor The phase angle is 90°, so the phase angle The coordinate values ​​of each voltage phase are calculated from this; for example, when the voltage phase sequence is reverse phase sequence, due to the phase angle Then the voltage phasor The coordinate values ​​of the starting point are X0=0, Y0=0, and the coordinate values ​​of the end point are

[0085] Generates a current phasor diagram. Draws current phasors The phase angle in the data source table needs to be used The method of generating the current phasor diagram is as follows: As the reference, the phase angle Assume that current I1=I3=0.6, if the voltage is positive phase sequence, Figure 4 In the phasor diagram shown, due to the phase angle but Right now Similarly, due to the phase angle but Right now From this, the current phasors are calculated The coordinate value of The phase angle Current phasor The coordinate values ​​of the starting point are X0=0, Y0=0, and the coordinate values ​​of the end point are

[0086] Similarly, if the voltage is in reverse phase sequence, Figure 2 In the phasor diagram shown, due to the phase angle but Right now or Similarly, due to the phase angle but Right now From this, the current phasors are calculated The coordinate value of

[0087] 2. Determine the voltage phase sequence

[0088] (1) The voltage phase sequence provided by the acquisition system is only a positive phase sequence or a reverse phase sequence. There are three types of positive phase sequences, namely abc, bca, and cab; there are also three types of reverse phase sequences, namely acb, cba, and bac. As to which one it is, further judgment and confirmation is required.

[0089] (2) Prepare a “voltage phase sequence and phase angle relationship table” as shown in Table 5.

[0090] Table 5 Voltage phase sequence and phase angle relationship table

[0091]

[0092] In Table 5, the phase angle The positive (reverse) phase sequence is directly derived from the data source table (such as Table 4), and the phase angle It is necessary to use the phase angle in Table 4 Data calculation to obtain the phase angle The calculation results have four values, namely 60°, 120°, 240°, and 300°. Phase Angle Calculation method: When the voltage phase sequence is positive, first calculate If the value of The phase angle like The phase angle When the voltage phase sequence is reverse phase sequence, first calculate If the value of The phase angle like The phase angle The calculated phase angle If the value is approximately equal to 60°, 120°, 240° or 300°, use the EXCEL logical judgment function IF to convert it into a fixed value of 60°, 120°, 240° or 300°;

[0093] (3) Three conditions [i.e., phase angle Phase Angle Positive (reverse) phase sequence] Constant voltage phase sequence

[0094] According to the voltage phase sequence and phase angle relationship table (such as Table 5), the phase angle in the data source table (Table 4) is known value, voltage phase sequence (positive or negative) and the phase angle calculated in step 2 (2) The specific form of the voltage phase sequence can be determined by the value of

[0095] For example, suppose the data source table is phase angle The voltage phase sequence is positive, and the phase angle is calculated. Then the specific form of the voltage phase sequence can be determined as cab (as shown in Table 5), that is, the voltage phase quantity connected to the first element of the energy meter is the voltage phasor of the voltage transformer Voltage phasor connected to the second element of the energy meter is the voltage phasor of the voltage transformer As shown in Table 5. For another example, suppose the phase angle in the data source table is The voltage phase sequence is reverse phase sequence, and the phase angle is calculated The specific form of the voltage phase sequence can be determined as acb (as shown in Table 5), that is, the voltage phase quantity connected to the first element of the energy meter is the voltage phasor of the voltage transformer Voltage phasor connected to the second element of the energy meter is the voltage phasor of the voltage transformer

[0096] 3. Determine the current phase sequence and polarity

[0097] (1) Prepare a “current phase sequence and polarity and phase angle, voltage phase sequence relationship table” as shown in Table 6.

[0098] Table 6 Relationship between current phase sequence and polarity and phase angle, voltage phase sequence

[0099]

[0100] As shown in Table 6, the current phase sequence and polarity refer to Corresponding “±” indicates the secondary current of the current transformer or The current flowing into the energy meter or If the directions are not consistent, it is usually called the reverse polarity of the current transformer. or There is a "-" sign in front; the phase angle refers to The voltage phase sequence refers to its shape, such as "abc, bca..." and so on.

[0101] (2) Three conditions (i.e. phase angle Phase Angle Voltage phase sequence) Constant current phase sequence and polarity

[0102] According to the current phase sequence, polarity and phase angle Voltage phase sequence relationship table (such as Table 6), the phase angle in the known data source table (Table 4) value, the phase angle calculated in step 2 (2) The value of and step 2

[0103] (3) By determining the specific form of the voltage phase sequence, the current phase sequence and polarity can be determined.

[0104] In the example of step 2(3), assume that the phase angle in the data source table is The voltage phase sequence is positive, and the phase angle is calculated. After determining that the voltage phase sequence is cab, the phase angle Phase Angle Voltage phase sequence cab three conditions can confirm the current phase sequence and polarity (as shown in Table 6), that is, the current flowing into the first element of the energy meter is the c-phase current of the current transformer Current flowing into the second element of the energy meter is the phase a current of the current transformer That is, the polarity of phase a current is reversed.

[0105] After the second step completes the determination of the voltage phase sequence and the third step completes the determination of the current phase sequence and polarity, the determination of the incorrect wiring form of the electric energy metering device is completed, thereby knowing where the wiring of the electric energy metering device is wrong.

[0106] 4. Derive the phase angle expression and correction coefficient expression, and calculate the power factor angle and correction coefficient K value of the load:

[0107] (1) Derive the phase angle expression and correction coefficient expression. Make a relationship table between the voltage phase sequence, current phase sequence and polarity and the phase angle and correction coefficient K expression (Table 7). The correction coefficient K is equal to the amount of electricity (or power P) when the electric energy meter is correctly connected divided by the amount of electricity (or power P′) when the electric energy meter is incorrectly connected, that is, K = P / P′, where the power when the connection is correct is Power in case of incorrect wiring

[0108] Table 7 Relationship between voltage phase sequence, current phase sequence and polarity and phase angle, correction coefficient K expression

[0109]

[0110] There are 48 types of wiring for three-phase three-wire energy metering devices. Each wiring type corresponds to a specific phase angle. For example, if the voltage phase sequence is determined to be abc according to step 2, and the current phase sequence and polarity are determined to be The corresponding phase angle expression is (As shown in Table 7). Assume that the three-phase circuit is symmetrical, that is, Uab=Ucb=U, Ia=Ic=I, Correction coefficient (As shown in Table 7), the power when the wiring is correct Power in case of incorrect wiring

[0111] (2) Calculate the power factor angle of the load.

[0112] The power factor angle of the load Calculation method: According to the phase angle in the data source table (Table 4) Value and the value obtained in step 4 (1) The phase angle expression can be used to calculate the power factor angle of the A and C phase loads. For example, suppose the data source table is phase angle The voltage is in positive phase sequence, and the phase angle is calculated Then the voltage phase sequence is determined to be cab, and the current phase sequence and polarity are The phase angle expression is Phase Angle (not listed in Table 7), calculate the power factor angle

[0113] (3) Calculate the correction factor K value. The correction factor K value is calculated by the power factor angle (Calculation time ) and the value calculated by the correction coefficient expression (as shown in Table 7). The calculation method of the correction coefficient K value: The corresponding correction coefficient K expression in step 4 (2) is (not listed in Table 7), take Correction coefficient

[0114] Due to the power factor angle of the user load changes with the load, and and The calculated correction coefficient K is not necessarily equal, so the calculated correction coefficient K is not a fixed value. The calculation of the correction coefficient K in this method is based on the symmetry of the three-phase circuit and takes ( may be It may also be ) is only used as a reference when replenishing electricity. See Figure 2 Related instructions)

[0115] 5. Establish the correlation between the wrong wiring judgment results in steps 2 and 3 and the phase angle and correction coefficient K expressions in step 4

[0116] According to the relationship table of voltage phase sequence, current phase sequence and polarity, phase angle and correction coefficient K expression (as shown in Table 7), after completing the determination of voltage phase sequence in step 2 and the determination of current phase sequence and polarity in step 3, the corresponding phase angle expression and correction coefficient K expression are obtained by using the EXCEL logic judgment function IF and AND to implement multi-condition judgment. The conditions are voltage phase sequence, current phase sequence and polarity. For example, if the voltage phase sequence is determined to be abc according to step 2, and the current phase sequence and polarity are determined to be Then the corresponding phase angle expression is The correction coefficient K is expressed as (As shown in Table 7), the judgment method is: if cell J5 in the EXCEL worksheet = "abc", Then in cell N5 Available Similarly, in cell P5

[0117] Available

[0118] 6. Centralized dynamic display of phasor diagrams and judgment results

[0119] Phase angle in the data source table (the worksheet name is "TQ3-3") There is a direct correlation with the generated phasor diagram and the results of the judgment in sequence (voltage phase sequence, current phase sequence and polarity, phase angle expression, correction coefficient K expression, correction coefficient K value). Use the EXCEL list box control to control the change of each record data by selecting the collection object in the data source table, and use EXCEL to find the reference function OFFSET and COLUMN to establish the correlation between the phasor diagram, the judgment result and the data source table, so as to realize the dynamic display of the phasor diagram and the judgment result, and form the wrong wiring judgment operation interface of the three-phase three-wire electric energy metering device (the worksheet name is operation interface 3-3) (such as Figure 2 ), its content consists of four modules.

[0120] Module one is the basic information of electricity users (communication address code, terminal name, collection object) and basic data (phase angle, phase sequence, current, voltage, etc.).

[0121] Module 2 is a list box, which contains the collection object information. You can select the collection object by clicking the mouse.

[0122] Module three is the phasor diagram, which can visually present the voltage and current phasors connected to the electric energy meter and their phase relationship, helping staff to compare and determine whether the wiring is wrong.

[0123] Module four is to determine the results and display the phase angle expression, correction factor K expression, power factor angle and correction factor K value.

[0124] In the operation interface, select the acquisition object in the list box, the phasor diagram will be automatically generated, and the judgment result will be automatically presented. You can get the result in seconds with just one click.

[0125] Please see Figures 1 to 6 , and referring to Tables 1 to 7, the present application is summarized as follows.

[0126] A method for batch monitoring and automatically determining three-phase three-wire incorrect wiring, characterized in that the method comprises the following steps performed in sequence:

[0127] Step 10, obtain data: first, in the power user power consumption information collection system (hereinafter referred to as the collection system), obtain the source data measured by the electric energy meter through batch inspection. The source data refers to the data directly downloaded after batch inspection of the four data items "voltage data block, current data block, phase angle data block and meter operation status word" in the collection system. The file name is export.csv. Each collection object in the source data contains at least the following data: A phase voltage, B phase voltage, C phase voltage, A phase current, B phase current, C phase current, A phase phase angle, B phase phase angle, C phase angle, voltage reverse phase sequence fault or no fault, address code, terminal Name, collection object, and store the file in the "Electric Energy Metering Device Wrong Wiring Judgment" folder, and create a new "Three-phase Three-wire Wrong Wiring Judgment Tool" EXCEL file in the folder; then use the source data file export.csv as the basis, use EXCEL to extract useful data into the "Three-phase Three-wire Wrong Wiring Judgment Tool" EXCEL file, which contains data extraction worksheet TQ, format conversion worksheet GS, and data source worksheet TQ3-3. Each collection object in the data source worksheet TQ3-3 corresponds to a data record, which contains the following fields: address code, terminal name, collection object, phase angle Phase sequence, current (I1, I3), voltage (U12, U32), the voltage U12 refers to the voltage of the first element voltage circuit of the energy meter, that is, the A phase voltage in the source data, referred to as the first element voltage of the energy meter, the voltage U32 refers to the voltage of the second element voltage circuit of the energy meter, that is, the C phase voltage in the source data, referred to as the second element voltage of the energy meter, the Refers to the voltage phasor of the first element of the energy meter, refers to the voltage phasor of the second element of the energy meter, the current I1 refers to the incoming line current flowing into the current loop of the first element of the energy meter, that is, the A phase current in the source data, the current I3 refers to the incoming line current flowing into the current loop of the second element of the energy meter, that is, the C phase current in the source data, and the phase angle Refers to the voltage phasor of the first element of the energy meter With current phasor The phase angle is the phase angle of phase A in the source data. Refers to the voltage phasor of the second element of the energy meter With current phasor The phase angle is the phase angle of phase C in the source data. The phase sequence refers to the voltage phase sequence of the three voltage terminals 1, 2, and 3 of the electric energy meter from left to right. If the voltage phase sequence in the data source table is a positive phase sequence, it means that there is no fault in the reverse phase sequence of the voltage in the source data. If the voltage phase sequence in the data source table is a reverse phase sequence, it means that there is a fault in the reverse phase sequence of the voltage in the source data.

[0128] Use the character extraction function MID to extract useful characters from the source data export.csv file to the data extraction worksheet TQ. The method is: if the cell G2 in the source data export.csv = "A phase voltage: 100.4V, B phase voltage: 000.0V, C phase voltage: 100.6V, line", enter in cell H3 in the data extraction worksheet TQ

[0129] =IFERROR(VALUE(MID(export.csv!$G2,FIND("@",SUBSTITUTE(export.csv!$G2,":","@",1))+2,5)),""), cell H3 = 100.4, and each collection object still has four data records; use OFFSET and ROW functions to convert the data extraction worksheet TQ format to the format conversion worksheet GS format, so that each collection object has only one data record. The method is: in the data extraction worksheet TQ, if cell H3 = 100.4V, enter =OFFSET(TQ!$H$3,4*(ROW(TQ!H1)-1),,) in cell L3 in the format conversion worksheet GS to get cell L3 = 100.4V; in the data extraction worksheet TQ, if cell H4 = 0.783A, enter in cell H3 in the format conversion worksheet GS

[0130] =OFFSET(TQ!$H$4,4*(ROW(TQ!E1)-1),,) to get cell H3=0.783A, so the data in cells H3 and H4 of the data extraction worksheet TQ can be moved to cells L3 and H3 of the format conversion worksheet GS to realize the conversion of four data record formats into one data record format; there are three-phase three-wire and three-phase four-wire energy meter data in the format conversion worksheet GS, and the INDEX and SMALL functions are needed to separate the three-phase three-wire and three-phase four-wire data in the format conversion worksheet GS. The method is: because the voltage of the three-phase three-wire energy meter is about 100V, and the voltage of the three-phase four-wire energy meter is about 220V, if the voltage values ​​of the cells in the format conversion worksheet GS are L3=230.6, L4=232.5, L5=100.5, enter in cell J4 in the data source worksheet TQ3-3

[0131] =IFERROR(INDEX(GS!L:L,SMALL(IF(NOT((GS!$L$3:$L$1000>120)+(GS!$L$3:$L$1000="")+(GS!$H$3:$H$1000=0)),ROW(GS!$3:$1000)),ROW(GS!L1))),""), we can get cell J4=100.5, where the data in column L in the format conversion worksheet GS is the value of voltage U12 (or U1), and the data in column H is the value of current I1. The meaning of the listed function statement is: if the data in column L is less than 120 and is not empty, and the data in column H is not equal to zero, then return the row number that meets the conditions, then use the SMALL function to retrieve and fill the data, and use INDEX to locate the position of the corresponding data in column L. In this way, the three-phase three-wire electric energy meter data can be extracted separately and stored in the data source worksheet TQ3-3;

[0132] Step 11, generate phasor diagram: create a new worksheet named "Operation Interface 3-3" in the "Three-phase Three-wire Wrong Wiring Judgment Tool" EXCEL file, and use the EXCEL office software chart function to generate a phasor diagram in this worksheet. The phasor is a method used to represent sinusoidal alternating current, similar to a vector in physics, with size and direction. Its size is equal to the effective value of sinusoidal alternating current, and its direction is represented by the initial phase of sinusoidal alternating current. The phasor diagram is a voltage phasor in the vertical upward direction. As a reference, the phasor is drawn in a rectangular coordinate diagram. The phasor diagram can intuitively present the voltage phasor connected to the energy meter. Current phasor And its phase relationship Used by staff to compare and judge whether the wiring is wrong;

[0133] Step 111: Generate a voltage phasor diagram, wherein the voltage phasor diagram includes the voltage phasors of the first and second components of the electric energy meter. And the voltage phasor The voltage phasor Voltage phasor In the power system, the three-phase voltage is generally symmetrical, that is, equal in magnitude and 120° out of phase. The method for generating the voltage phasor diagram is: As the reference, the phase angle Assume that voltage U1=U2=U3=1, then voltage U12=U32=1.732. If the voltage is positive phase sequence, due to the voltage phasor Leading voltage phasor The phase angle is 120°, then the phase angle Due to voltage phasor Leading voltage phasor The phase angle is 240°, then the phase angle Due to voltage phasor The voltage phasor can be obtained by drawing a phasor diagram or calculating Leading voltage phasor The phase angle is 330°, so the phase angle Due to voltage phasor The voltage phasor can be obtained by drawing a phasor diagram or calculating Leading voltage phasor The phase angle is 270°, so the phase angle The coordinate values ​​of each voltage phasor are calculated accordingly;

[0134] For example, when the voltage is in positive phase sequence, due to the phase angle Then the voltage phasor The coordinate values ​​of the starting point are X0=0, Y0=0, and the coordinate values ​​of the end point are

[0135] If the voltage is in reverse phase sequence, the voltage phasor Leading voltage phasor The phase angle is 240°. Due to voltage phasor Leading voltage phasor The phase angle is 120°, then the phase angle Due to voltage phasor The voltage phasor can be obtained by drawing a phasor diagram or calculating Leading voltage phasor The phase angle is 30°, so the phase angle Due to voltage phasor The voltage phasor can be obtained by drawing a phasor diagram or calculating Leading voltage phasor The phase angle is 90°, so the phase angle The coordinate values ​​of each voltage phasor are calculated accordingly;

[0136] For example, when the voltage phase sequence is reverse phase sequence, due to the phase angle Then the voltage phasor The coordinate values ​​of the starting point are X0=0, Y0=0, and the coordinate values ​​of the end point are

[0137] Step 112, generate a current phasor diagram, the current phasor includes The phase angle in the data source table needs to be used The method of generating the current phasor diagram is as follows: As the reference, the phase angle Assume that current I1 = I3 = 0.6. If the voltage is in positive phase sequence, in the phasor diagram, according to the calculation result of step 111, the phase angle Voltage phasor Leading voltage phasor The phase angle is 330° or the voltage phasor Leading voltage phasor The phase angle is 30°, that is, relative to the current phasor In terms of The phase angle Similarly, according to the calculation results of step 111, due to the phase angle Voltage phasor Leading voltage phasor The phase angle is 270° or the voltage phasor Leading voltage phasor The phase angle is 90°, that is, relative to the current phasor In terms of The phase angle From this, the current phasors are calculated The coordinate value of

[0138] For example, if the data source table contains the phase angle The phase angle Phase Angle Current phasor The coordinate values ​​of the starting point are X0=0, Y0=0, and the coordinate values ​​of the end point are

[0139] Similarly, if the voltage is in reverse phase sequence, in the phasor diagram, according to the calculation result of step 111, the phase angle Voltage phasor Leading voltage phasor The phase angle is 30°, that is, relative to the current phasor In terms of The phase angle or Similarly, according to the calculation results of step 111, due to the phase angle Voltage phasor Leading voltage phasor The phase angle is 90°, that is, relative to the current phasor In terms of The phase angle From this, the current phasors are calculated The coordinate value of

[0140] Step 12: Determine the voltage phase sequence:

[0141] (1) The voltage phase sequence in the data source table is only the positive phase sequence or the reverse phase sequence. The positive phase sequence has three forms: abc, bca, and cab, and the reverse phase sequence has three forms: acb, cba, and bac. The voltage phase sequence refers to the correspondence between the three voltage terminals 1, 2, and 3 from left to right of the three-phase three-wire electric energy meter and the three voltage terminals Ua, Ub, and Uc introduced by the voltage transformer;

[0142] (2) Prepare a voltage phase sequence and phase angle relationship table, where the phase angle refers to The phase angle Need to use the phase angle in the data source table Calculate the phase angle There are four values: 60°, 120°, 240°, and 300°. The calculation method is: when the voltage phase sequence is positive, first calculate If the value of The phase angle like The phase angle When the voltage phase sequence is reverse phase sequence, first calculate If the value of The phase angle like The phase angle The calculated phase angle If the value is approximately equal to 60°, 120°, 240° or 300°, the EXCEL logical judgment function IF is used to convert it into a fixed value of 60°, 120°, 240° or 300°. The method is as follows: Design the calculated phase angle The value is in cell K3, enter it in cell J3

[0143] “=IF($K$3<90,60,IF(AND($K$3>90,$K$3<180),120,IF(AND($K$3>180,$K$3<270),240,IF($K$3>270,300))))”, get the phase angle in cell J3 The fixed value of

[0144] (3) Based on three conditions The positive (reverse) phase sequence determines the specific form of the voltage phase sequence. The judgment method is: according to the voltage phase sequence and phase angle relationship table, the phase angle in the known data source table value, voltage phase sequence (positive or negative) and the phase angle calculated in step 12 (2) The value of determines the specific form of the voltage phase sequence;

[0145] For example, suppose the data source table is phase angle The voltage phase sequence is positive, and the phase angle is calculated. Then the specific form of the voltage phase sequence can be determined as cab, that is, the voltage phase quantity connected to the first element of the energy meter is the voltage phasor of the secondary output of the voltage transformer Voltage phasor connected to the second element of the energy meter is the voltage phasor of the secondary output of the voltage transformer For example, assuming the phase angle in the data source table is The voltage phase sequence is reverse phase sequence, and the phase angle is calculated The specific form of the voltage phase sequence can be determined as acb, that is, the voltage phase quantity connected to the first element of the energy meter is the voltage phasor of the secondary output of the voltage transformer Voltage phasor connected to the second element of the energy meter is the voltage phasor of the secondary output of the voltage transformer

[0146] Step 13: Determine the current phase sequence and polarity:

[0147] (1) Produce current phase sequence, polarity and phase angle Voltage phase sequence relationship table, the current phase sequence refers to the secondary current phase of the current transformer The order of connecting the first and second components of the electric energy meter current loop, that is, the current phasor The current polarity refers to the secondary current phasor of the current transformer. or The phase of the current flowing into the energy meter or Whether the directions are consistent. If not, it is usually called the reverse polarity of the current transformer.

[0148] For example, if there is and Correspondingly, it represents the current phasor flowing into the first element of the energy meter That is, the c-phase current phasor of the current transformer Right now and The direction is opposite; the current phasor flowing into the second element of the energy meter That is, the a-phase current phasor of the current transformer The voltage phase sequence refers to the specific form of the voltage phase sequence;

[0149] (2) Based on three conditions The voltage phase sequence determines the current phase sequence and polarity. The determination method is: according to the current phase sequence and polarity and phase angle Voltage phase sequence relationship table, with known phase angle in the data source table value, the phase angle calculated in step 12 (2) The current phase sequence and polarity are determined based on the value of and the specific form of the voltage phase sequence determined in step 12 (3);

[0150] For example, in step 12 (3), suppose the phase angle in the data source table is The voltage phase sequence is positive, and the phase angle is calculated. After determining that the voltage phase sequence is cab, the phase angle Voltage phase sequence cab three conditions can confirm the current phase sequence and polarity That is, the current phasor flowing into the first element of the energy meter is the c-phase current phasor of the current transformer The current phasor flowing into the second element of the energy meter is the current phasor of phase a of the current transformer That is, the polarity of phase a current is reversed;

[0151] Step 20 completes the judgment. Step 12 completes the judgment of the voltage phase sequence. Step 13 completes the judgment of the current phase sequence and polarity. This completes the judgment of the incorrect wiring form of the electric energy metering device. This allows you to know where the wiring of the electric energy metering device is wrong.

[0152] In this application, an example of a method for extracting the number "00100018600879" in the source data table acquisition object "Measurement point 3: Measurement 00100018600879" (cell E2) using MID and other functions is as follows:

[0153] IFERROR(MID($E2,FIND("@",SUBSTITUTE($E2,":","@",1))+3,20),""), extracting other data is similar, but the position and length are different, etc.

[0154] A method for batch monitoring and automatically determining three-phase three-wire incorrect wiring, characterized in that the method comprises the following steps performed in sequence:

[0155] Step 10, obtain data: first, in the power user power consumption information collection system (hereinafter referred to as the collection system), obtain the source data measured by the electric energy meter through batch inspection. The source data refers to the data directly downloaded after batch inspection of the four data items "voltage data block, current data block, phase angle data block and meter operation status word" in the collection system. The file name is export.csv. Each collection object in the source data contains at least the following data: A phase voltage, B phase voltage, C phase voltage, A phase current, B phase current, C phase current, A phase phase angle, B phase phase angle, C phase angle, voltage reverse phase sequence fault or no fault, address code, terminal Name, collection object, and store the file in the "Electric Energy Metering Device Wrong Wiring Judgment" folder, and create a new "Three-phase Three-wire Wrong Wiring Judgment Tool" EXCEL file in the folder; then use the source data file export.csv as the basis, use EXCEL to extract useful data into the "Three-phase Three-wire Wrong Wiring Judgment Tool" EXCEL file, which contains data extraction worksheet TQ, format conversion worksheet GS, and data source worksheet TQ3-3. Each collection object in the data source worksheet TQ3-3 corresponds to a data record, which contains the following fields: address code, terminal name, collection object, phase angle Phase sequence, current (I1, I3), voltage (U12, U32), the voltage U12 refers to the voltage of the first element voltage circuit of the energy meter, that is, the A phase voltage in the source data, referred to as the first element voltage of the energy meter, the voltage U32 refers to the voltage of the second element voltage circuit of the energy meter, that is, the C phase voltage in the source data, referred to as the second element voltage of the energy meter, the Refers to the voltage phasor of the first element of the energy meter, refers to the voltage phasor of the second element of the energy meter, the current I1 refers to the incoming line current flowing into the current loop of the first element of the energy meter, that is, the A phase current in the source data, the current I3 refers to the incoming line current flowing into the current loop of the second element of the energy meter, that is, the C phase current in the source data, and the phase angle Refers to the voltage phasor of the first element of the energy meter With current phasor The phase angle is the phase angle of phase A in the source data. Refers to the voltage phasor of the second element of the energy meter With current phasor The phase angle is the phase angle of phase C in the source data. The phase sequence refers to the voltage phase sequence of the three voltage terminals 1, 2, and 3 of the electric energy meter from left to right. If the voltage phase sequence in the data source table is a positive phase sequence, it means that there is no fault in the reverse phase sequence of the voltage in the source data. If the voltage phase sequence in the data source table is a reverse phase sequence, it means that there is a fault in the reverse phase sequence of the voltage in the source data.

[0156] Use the character extraction function MID to extract useful characters from the source data export.csv file to the data extraction worksheet TQ. The method is: if the cell G2 in the source data export.csv = "A phase voltage: 100.4V, B phase voltage: 000.0V, C phase voltage: 100.6V, line", enter in cell H3 in the data extraction worksheet TQ

[0157] =IFERROR(VALUE(MID(export.csv!$G2,FIND("@",SUBSTITUTE(export.csv!$G2,":","@",1))+2,5)),""), cell H3 = 100.4, and each collection object still has four data records; use OFFSET and ROW functions to convert the data extraction worksheet TQ format to the format conversion worksheet GS format, so that each collection object has only one data record. The method is: in the data extraction worksheet TQ, if cell H3 = 100.4V, enter =OFFSET(TQ!$H$3,4*(ROW(TQ!H1)-1),,) in cell L3 in the format conversion worksheet GS to get cell L3 = 100.4V; in the data extraction worksheet TQ, if cell H4 = 0.783A, enter in cell H3 in the format conversion worksheet GS

[0158] =OFFSET(TQ!$H$4,4*(ROW(TQ!E1)-1),,) to get H3=0.783A, so the data in cells H3 and H4 of the data extraction worksheet TQ can be moved to cells L3 and H3 of the format conversion worksheet GS to realize the conversion of four data record formats into one data record format; there are three-phase three-wire and three-phase four-wire energy meter data in the format conversion worksheet GS, and the INDEX and SMALL functions are needed to separate the three-phase three-wire and three-phase four-wire data in the format conversion worksheet GS. The method is: because the voltage of the three-phase three-wire energy meter is about 100V, and the voltage of the three-phase four-wire energy meter is about 220V, if the voltage value of the cell in the format conversion worksheet GS is L3=230.6, L4=232.5, L5=100.5, enter in cell J4 in the data source worksheet TQ3-3

[0159] =IFERROR(INDEX(GS!L:L,SMALL(IF(NOT((GS!$L$3:$L$1000>120)+(GS!$L$3:$L$1000="")+(GS!$H$3:$H$1000=0)),ROW(GS!$3:$1000)),ROW(GS!L1))),""), we can get cell J4=100.5, where the data in column L in the format conversion worksheet GS is the value of voltage U12 (or U1), and the data in column H is the value of current I1. The meaning of the listed function statement is: if the data in column L is less than 120 and is not empty, and the data in column H is not equal to zero, then return the row number that meets the conditions, then use the SMALL function to retrieve and fill the data, and use INDEX to locate the position of the corresponding data in column L. In this way, the three-phase three-wire electric energy meter data can be extracted separately and stored in the data source worksheet TQ3-3;

[0160] Step 11, generate phasor diagram: create a new worksheet named "Operation Interface 3-3" in the "Three-phase Three-wire Wrong Wiring Judgment Tool" EXCEL file, and use the EXCEL office software chart function to generate a phasor diagram in this worksheet. The phasor is a method used to represent sinusoidal alternating current, similar to a vector in physics, with size and direction. Its size is equal to the effective value of sinusoidal alternating current, and its direction is represented by the initial phase of sinusoidal alternating current. The phasor diagram is a voltage phasor in the vertical upward direction. As a reference, the phasor is drawn in a rectangular coordinate diagram. The phasor diagram can intuitively present the voltage phasor connected to the energy meter. Current phasor And its phase relationship Used by staff to compare and judge whether the wiring is wrong;

[0161] Step 111: Generate a voltage phasor diagram, wherein the voltage phasor diagram includes the voltage phasors of the first and second components of the electric energy meter. And the voltage phasor The voltage phasor Voltage phasor In the power system, the three-phase voltage is generally symmetrical, that is, equal in magnitude and 120° out of phase. The method for generating the voltage phasor diagram is: As the reference, the phase angle Assume that voltage U1=U2=U3=1, then voltage U12=U32=1.732. If the voltage is positive phase sequence, due to the voltage phasor Leading voltage phasor The phase angle is 120°, then the phase angle Due to voltage phasor Leading voltage phasor The phase angle is 240°, then the phase angle Due to voltage phasor The voltage phasor can be obtained by drawing a phasor diagram or calculating Leading voltage phasor The phase angle is 330°, so the phase angle Due to voltage phasor The voltage phasor can be obtained by drawing a phasor diagram or calculating Leading voltage phasor The phase angle is 270°, so the phase angle The coordinate values ​​of each voltage phasor are calculated accordingly;

[0162] For example, when the voltage is in positive phase sequence, due to the phase angle Then the voltage phasor The coordinate values ​​of the starting point are X0=0, Y0=0, and the coordinate values ​​of the end point are

[0163] If the voltage is in reverse phase sequence, the voltage phasor Leading voltage phasor The phase angle is 240°, then the phase angle Due to voltage phasor Leading voltage phasor The phase angle is 120°, then the phase angle Due to voltage phasor The voltage phasor can be obtained by drawing a phasor diagram or calculating Leading voltage phasor The phase angle is 30°, so the phase angle Due to voltage phasor The voltage phasor can be obtained by drawing a phasor diagram or calculating Leading voltage phasor The phase angle is 90°, so the phase angle The coordinate values ​​of each voltage phasor are calculated accordingly;

[0164] For example, when the voltage phase sequence is reverse phase sequence, due to the phase angle Then the voltage phasor The coordinate values ​​of the starting point are X0=0, Y0=0, and the coordinate values ​​of the end point are

[0165] Step 112, generate a current phasor diagram, the current phasor includes The phase angle in the data source table needs to be used The method of generating the current phasor diagram is as follows: As the reference, the phase angle Assume that current I1 = I3 = 0.6. If the voltage is in positive phase sequence, in the phasor diagram, according to the calculation result of step 111, the phase angle Voltage phasor Leading voltage phasor The phase angle is 330° or the voltage phasor Leading voltage phasor The phase angle is 30°, that is, relative to the current phasor In terms of The phase angle Similarly, according to the calculation results of step 111, due to the phase angle Voltage phasor Leading voltage phasor The phase angle is 270° or the voltage phasor Leading voltage phasor The phase angle is 90°, that is, relative to the current phasor In terms of The phase angle From this, the current phasors are calculated The coordinate value of

[0166] For example, if the data source table contains the phase angle The phase angle Phase Angle Current phasor The coordinate values ​​of the starting point are X0=0, Y0=0, and the coordinate values ​​of the end point are

[0167] Similarly, if the voltage is in reverse phase sequence, in the phasor diagram, according to the calculation result of step 111, the phase angle Voltage phasor Leading voltage phasor The phase angle is 30°, that is, relative to the current phasor In terms of Then the phase angle or Similarly, according to the calculation results of step 111, due to the phase angle Voltage phasor Leading voltage phasor The phase angle is 90°, that is, relative to the current phasor In terms of The phase angle From this, the current phasors are calculated The coordinate value of

[0168] Step 12: Determine the voltage phase sequence:

[0169] (1) The voltage phase sequence in the data source table is only the positive phase sequence or the reverse phase sequence. The positive phase sequence has three forms: abc, bca, and cab, and the reverse phase sequence has three forms: acb, cba, and bac. The voltage phase sequence refers to the correspondence between the three voltage terminals 1, 2, and 3 from left to right of the three-phase three-wire electric energy meter and the three voltage terminals Ua, Ub, and Uc introduced by the voltage transformer;

[0170] (2) Prepare a voltage phase sequence and phase angle relationship table, where the phase angle refers to The phase angle Need to use the phase angle in the data source table Calculate the phase angle There are four values: 60°, 120°, 240°, and 300°. The calculation method is: when the voltage phase sequence is positive, first calculate If the value of The phase angle like The phase angle When the voltage phase sequence is reverse phase sequence, first calculate If the value of The phase angle like The phase angle

[0171] The calculated phase angle If the value is approximately equal to 60°, 120°, 240° or 300°, the EXCEL logical judgment function IF is used to convert it into a fixed value of 60°, 120°, 240° or 300°. The method is as follows: Design the calculated phase angle The value is in cell K3. Enter "=IF($K$3<90,60,IF(AND($K$3>90,$K$3<180),120,IF(AND($K$3>180,$K$3<270),240,IF($K$3>270,300))))" in cell J3. The fixed value of

[0172] (3) Based on three conditions The positive (reverse) phase sequence determines the specific form of the voltage phase sequence. The judgment method is: according to the voltage phase sequence and phase angle relationship table, the known data source table value, voltage phase sequence (positive or negative) and the value calculated in step 12 (2) The value of determines the specific form of the voltage phase sequence;

[0173] For example, suppose the data source table is phase angle The voltage phase sequence is positive, and the phase angle is calculated. Then the specific form of the voltage phase sequence can be determined as cab, that is, the voltage phase quantity connected to the first element of the energy meter is the voltage phasor of the voltage transformer Voltage phasor connected to the second element of the energy meter is the voltage phasor of the voltage transformer For example, assuming the phase angle in the data source table is The voltage phase sequence is reverse phase sequence, and the phase angle is calculated The specific form of the voltage phase sequence can be determined as acb, that is, the voltage phase quantity connected to the first element of the energy meter is the voltage phasor of the voltage transformer Voltage phasor connected to the second element of the energy meter is the voltage phasor of the voltage transformer

[0174] Step 13: Determine the current phase sequence and polarity:

[0175] (1) Produce current phase sequence, polarity and phase angle Voltage phase sequence relationship table, the current phase sequence refers to the secondary current phase of the current transformer The order of connecting the first and second components of the electric energy meter current loop, that is, the current phasor The current polarity refers to the secondary current phasor of the current transformer. or The phase of the current flowing into the energy meter or Whether the directions are consistent. If not, it is usually called the reverse polarity of the current transformer.

[0176] For example, if there is and Correspondingly, it represents the current phasor flowing into the first element of the energy meter That is, the c-phase current phasor of the current transformer Right now and The direction is opposite; the current phasor flowing into the second element of the energy meter That is, the a-phase current phasor of the current transformer The voltage phase sequence refers to the specific form of the voltage phase sequence;

[0177] (2) Based on three conditions The voltage phase sequence determines the current phase sequence and polarity. The determination method is: according to the current phase sequence and polarity and phase angle Voltage phase sequence relationship table, with known phase angle in the data source table value, the phase angle calculated in step 12 (2) The current phase sequence and polarity are determined based on the value of and the specific form of the voltage phase sequence determined in step 12 (3);

[0178] For example, in step 12 (3), suppose the phase angle in the data source table is The voltage phase sequence is positive, and the phase angle is calculated. After determining that the voltage phase sequence is cab, the phase angle Voltage phase sequence cab three conditions can confirm the current phase sequence and polarity That is, the current phasor flowing into the first element of the energy meter is the c-phase current phasor of the current transformer The current phasor flowing into the second element of the energy meter is the current phasor of phase a of the current transformer That is, the polarity of phase a current is reversed;

[0179] Step 14: Derive the phase angle expression and correction coefficient expression, and calculate the power factor angle and correction coefficient K value of the load:

[0180] Step 141, derive the phase angle expression and correction coefficient expression, and make a relationship table between the voltage phase sequence, current phase sequence and polarity and the phase angle and correction coefficient K expression. The phase angle expression is a function of the power factor angle. The phase angle is expressed as The correction factor K expression is used to compensate for the power and contains the power factor angle. The correction coefficient K is equal to the amount of electricity (or power P) when the electric energy meter is correctly connected divided by the amount of electricity (or power P') when it is incorrectly connected, that is, K = P / P', where the power when the connection is correct is Power in case of incorrect wiring

[0181] There are 48 types of wiring for three-phase three-wire energy metering devices. Each wiring type corresponds to a specific phase angle. For example, if the voltage phase sequence is determined to be abc according to step 12, and the current phase sequence and polarity are determined to be The corresponding phase angle expression is Assume that the three-phase circuit is symmetrical, that is, Uab=Ucb=U, Ia=Ic=I, Correction coefficient The power when correctly wired Power in case of incorrect wiring

[0182] Step 142, calculate the power factor angle of the load. In the relationship table of voltage phase sequence, current phase sequence and polarity, phase angle, and correction coefficient K, the power factor angle of the load refers to the power factor angle of the A and C phase loads. They are included in the phase angle expression The power factor angle of the load Calculation method: According to the phase angle in the data source table Value and the value obtained in step 13 (2) The phase angle expression can be used to calculate the power factor angle of the A and C phase loads. For example, suppose the data source table is phase angle The voltage is in positive phase sequence, and the phase angle is calculated Then the voltage phase sequence is determined to be cab, and the current phase sequence and polarity are The phase angle expression is Phase Angle Calculating the power factor angle

[0183] Step 143, calculate the correction factor K value, the correction factor K value is calculated by the power factor angle (Calculation time ) and the value calculated by the correction coefficient expression, the calculation method of the correction coefficient K value is: the corresponding correction coefficient K expression in step 141 is Pick Correction coefficient

[0184] Due to the power factor angle of the user load changes with the load, and and are not necessarily equal, so the calculated correction coefficient K value is not a fixed value. The calculation of the correction coefficient K value in this method is based on the symmetry of the three-phase circuit and takes ( may be It may also be ) is only used as a reference when replenishing electricity;

[0185] Step 15: Establish the relationship between the judgment result and the expression, establish the correlation between the judgment result of the wrong wiring in step 12 and step 13 and the phase angle and correction coefficient K expression in step 14. According to the relationship table of voltage phase sequence, current phase sequence and polarity and phase angle and correction coefficient K expression, after completing the judgment of voltage phase sequence in step 12 and the judgment of current phase sequence and polarity in step 13, use EXCEL logical judgment function IF and AND to realize multi-condition judgment to obtain the corresponding phase angle expression and correction coefficient K expression. The conditions are voltage phase sequence, current phase sequence and polarity. For example, if the voltage phase sequence is abc according to step 12 and the current phase sequence and polarity are abc according to step 13, Then the corresponding phase angle expression is The correction coefficient K is expressed as The judgment method is:

[0186] Step 16: Focus on displaying the phasor diagram and the judgment results

[0187] Phase angle in the data source table There is a direct correlation with the generated phasor diagram and the results of the judgment in sequence; the judgment result is related to: voltage phase sequence, current phase sequence and polarity, phase angle expression, correction coefficient K expression, correction coefficient K value; use the EXCEL list box control to control the change of each record data by selecting the collection object in the data source table, use EXCEL to find the reference function OFFSET, COLUMN to establish the correlation between the phasor diagram, the judgment result and the data source table, realize the dynamic display of the phasor diagram and the judgment result, and form a three-phase three-wire electric energy metering device wrong wiring judgment operation interface, whose content consists of four modules:

[0188] Module 1 includes: communication address code, terminal name, basic information of the electricity user of the collection object and basic data including: phase angle, phase sequence, current and voltage;

[0189] Module 2 is a list box, which contains the information of the collection object. You can click the mouse to select the collection object.

[0190] Module three is the phasor diagram, which can visually present the voltage and current phasors and their phase relationship of the energy meter, which helps the staff to compare and judge whether the wiring is wrong;

[0191] Module 4 is to determine the results and display the phase angle expression, correction factor K expression, power factor angle and correction factor K value;

[0192] In the operation interface, select the acquisition object in the list box, the phasor diagram will be automatically generated, and the judgment result will be automatically presented. You can get the result in seconds with just one click.

[0193] Step 20, complete the judgment.

[0194] The present application mainly has the following beneficial technical benefits: 1. From the perspective of time, the work efficiency can be improved by more than 99%. According to calculations, it takes about 1.5 hours for one person to inspect 100 special transformer electric energy metering devices using the present invention, of which it takes about 1 hour to inspect the data in the acquisition system, and the conversion of the source data table into the data source table can be completed instantly and automatically. It takes about 0.5 hours to draw conclusions by manually viewing the phasor diagram and viewing the judgment results. It takes 20 working days for manual (at least 3 people, including 1 driver) to use the electric energy meter field calibrator to inspect 100 special transformer electric energy metering devices on site (calculated based on completing 5 households per day), and it takes 160 hours in total based on 8 hours of work per day, including the journey, handling work tickets, taking on-site safety measures, wiring operations, etc. The comparison of the two situations can improve the work efficiency by (160-1.5) / 160×100%=99.06%. Second, reduce the number of people and increase efficiency, greatly saving labor costs. According to the on-site inspection of 1,200 special transformers of electric energy metering devices completed by 3 people (including 2 staff members and 1 driver) in one year, if there are 4,800 electric energy metering devices in a certain city, 12 people are required (including 8 staff members and 4 drivers); if the patrol inspection of the special transformer electric energy metering device by the present invention is completed by only 3 people (at least 2 staff members and 1 driver are required to complete the on-site work, and their work tasks include patrol inspection, on-site inspection to correct wrong wiring, and follow-up electricity and other post-work), at least 9 people can be saved. Third, the judgment result is accurate. The present invention was used for testing and verification, and it was determined that there were 4 suspected electric energy metering devices with wiring errors. After on-site verification, it was basically consistent with the judgment result. The main problem is that the judgment result of unconventional wrong wiring (outside of 48 types of three-phase three-wire wiring, such as loss of voltage in a phase, ac phase current series connection, etc.) is inconsistent with the actual wiring on site. For the problem of unconventional wrong wiring, the voltage, current values ​​and phasor diagram abnormal phenomena in the data source table can be combined for comprehensive judgment, and the correct judgment result can also be obtained. 4. Maintain the legitimate rights and interests of both power suppliers and users, and ensure fair and just power metering. Wiring errors can cause the power metering device to over- or under-count the amount of electricity, which can easily lead to power supply and power user disputes. Quickly and accurately check and determine wiring errors or faults in the power metering device, eliminate the faults in a timely manner, and make up for the electricity, which is conducive to maintaining the legitimate rights and interests of both power suppliers and users. It can be foreseen that after the promotion and application of the present invention, its benefits will be further manifested.

[0195] The above embodiments are only preferred technical solutions of the present application and should not be regarded as limitations of the present application. The protection scope of the present application shall be the technical solutions recorded in the claims, including equivalent replacement solutions of the technical features in the technical solutions recorded in the claims. That is, equivalent replacement improvements within this scope are also within the protection scope of the present application.

Claims

1. A method for batch monitoring and automatically determining three-phase three-wire incorrect wiring, characterized in that The method comprises the following steps performed in sequence: Step 10, obtain data: first, in the power user power consumption information collection system, obtain the source data measured by the electric energy meter through batch inspection. The source data refers to the data directly downloaded after batch inspection of the four data items "voltage data block, current data block, phase angle data block and meter operation status word" in the collection system. The file name is export.csv. Each collection object in the source data contains at least the following data: A phase voltage, B phase voltage, C phase voltage, A phase current, B phase current, C phase current, A phase phase angle, B phase phase angle, C phase angle, voltage reverse phase sequence fault or no fault, address code, terminal name, collection The collection object is saved in the folder "Energy metering device wrong wiring judgment", and a new "Three-phase three-wire wrong wiring judgment tool" EXCEL file is created in the folder; then, based on the source data file export.csv, EXCEL is used to extract useful data into the "Three-phase three-wire wrong wiring judgment tool" EXCEL file, which contains the data extraction worksheet TQ, the format conversion worksheet GS, and the data source worksheet TQ3-3. Each collection object in the data source worksheet TQ3-3 corresponds to a data record, which contains the following fields: address code, terminal name, collection object, phase angle Phase Angle Phase sequence, current I1, I3, voltage U12, U32, the voltage U12 refers to the voltage of the first element voltage circuit of the energy meter, that is, the A phase voltage in the source data, referred to as the first element voltage of the energy meter, the voltage U32 refers to the voltage of the second element voltage circuit of the energy meter, that is, the C phase voltage in the source data, referred to as the second element voltage of the energy meter, the Refers to the voltage phasor of the first element of the energy meter, refers to the voltage phasor of the second element of the energy meter, the current I1 refers to the incoming line current flowing into the current loop of the first element of the energy meter, that is, the A phase current in the source data, the current I3 refers to the incoming line current flowing into the current loop of the second element of the energy meter, that is, the C phase current in the source data, and the phase angle Refers to the voltage phasor of the first element of the energy meter With current phasor The phase angle is the phase angle of phase A in the source data. Refers to the voltage phasor of the second element of the energy meter With current phasor The phase angle is the phase angle of phase C in the source data. The phase sequence refers to the voltage phase sequence of the three voltage terminals 1, 2, and 3 of the electric energy meter from left to right. If the voltage phase sequence in the data source table is a positive phase sequence, it means that there is no fault in the reverse phase sequence of the voltage in the source data. If the voltage phase sequence in the data source table is a reverse phase sequence, it means that there is a fault in the reverse phase sequence of the voltage in the source data. Use the character extraction function MID to extract useful characters from the source data export.csv file to the data extraction worksheet TQ. The method is: enter =IFERROR(VALUE(MID(export.csv!$G2,FIND("@",SUBSTITUTE(export.csv!$G2,":","@",1))+2,5)),"") in cell H3 of the data extraction worksheet TQ. Each collection object still has four data records; use OFFSET and ROW functions to convert the data extraction worksheet TQ format to the format conversion worksheet. Format the table GS so that each collection object has only one data record. The method is: enter =OFFSET(TQ!$H$3,4*(ROW(TQ!H1)-1),,) in cell L3 of the format conversion worksheet GS, enter =OFFSET(TQ!$H$4,4*(ROW(TQ!E1)-1),,) in cell H3 of the format conversion worksheet GS, move the data in cells H3 and H4 of the data extraction worksheet TQ to cells L3 and H3 of the format conversion worksheet GS respectively, and convert the four data record formats into one data record format; in the table There are three-phase three-wire and three-phase four-wire energy meter data in the format conversion worksheet GS. You also need to use INDEX and SMALL functions to separate the three-phase three-wire and three-phase four-wire data in the format conversion worksheet GS. The method is: in the data source worksheet TQ3-3, cell J4 enter =IFERROR(INDEX(GS!L:L,SMALL(IF(NOT((GS!$L$3:$L$1000>120)+(GS!$L$3:$L$1000="")+(GS!$H$3:$H$1000=0)),ROW(GS!$3:$1000) ),ROW(GS!L1))),""), where the data in column L in the format conversion worksheet GS is the value of voltage U12, which refers to the voltage of the first element of the three-phase three-wire electric energy meter. The data in column H in the format conversion worksheet GS is the value of current I1. The meaning of the listed function statement is: if the data in column L is less than 120 and is not empty, and the data in column H is not equal to zero, then the row number that meets the conditions is returned, and then the SMALL function is used to retrieve and fill the data, and INDEX is used to locate the position of the corresponding data in column L. In this way, the data of the three-phase three-wire electric energy meter can be extracted separately and stored in the data source worksheet TQ3-3; Step 11, generate phasor diagram: create a new worksheet named "Operation Interface 3-3" in the "Three-phase Three-wire Wrong Wiring Judgment Tool" EXCEL file, and use the chart function of EXCEL office software to generate a phasor diagram in this worksheet. The phasor is a method used to represent sinusoidal alternating current, similar to a vector in physics, with size and direction. Its size is equal to the effective value of sinusoidal alternating current, and its direction is represented by the initial phase of sinusoidal alternating current. The phasor diagram is a voltage phasor in the vertical upward direction. As a reference, the phasor is drawn in a rectangular coordinate diagram. The phasor diagram can intuitively present the voltage phasor connected to the energy meter. Current phasor And its phase relationship Used by staff to compare and judge whether the wiring is wrong; Step 111: Generate a voltage phasor diagram, wherein the voltage phasor diagram includes the voltage phasors of the first and second components of the electric energy meter. And the voltage phasor The voltage phasor Voltage phasor In the power system, the three-phase voltage is generally symmetrical, that is, equal in magnitude and 120° out of phase. The method for generating the voltage phasor diagram is: As the reference, the phase angle Assume that voltage U1=U2=U3=1, then voltage U12=U32=1.

732. If the voltage is positive phase sequence, due to the voltage phasor Leading voltage phasor The phase angle is 120°, then the phase angle Due to voltage phasor Leading voltage phasor The phase angle is 240°, then the phase angle Due to voltage phasor The voltage phasor can be obtained by drawing a phasor diagram or calculating Leading voltage phasor The phase angle is 330°, so the phase angle Due to voltage phasor The voltage phasor can be obtained by drawing a phasor diagram or calculating Leading voltage phasor The phase angle is 270°, so the phase angle The coordinate values ​​of each voltage phasor are calculated accordingly; If the voltage is in reverse phase sequence, the voltage phasor Leading voltage phasor The phase angle is 240°, then the phase angle Due to voltage phasor Leading voltage phasor The phase angle is 120°, then the phase angle Due to voltage phasor The voltage phasor can be obtained by drawing a phasor diagram or calculating Leading voltage phasor The phase angle is 30°, so the phase angle Due to voltage phasor The voltage phasor can be obtained by drawing a phasor diagram or calculating Leading voltage phasor The phase angle is 90°, so the phase angle The coordinate values ​​of each voltage phasor are calculated accordingly; Step 112, generate a current phasor diagram, the current phasor includes The phase angle in the data source table needs to be used The method of generating the current phasor diagram is as follows: As the reference, the phase angle Assume that current I1 = I3 = 0.

6. If the voltage is in positive phase sequence, in the phasor diagram, according to the calculation result of step 111, the phase angle Voltage phasor Leading voltage phasor The phase angle is 330° or the voltage phasor Leading voltage phasor The phase angle is 30°, that is, relative to the current phasor In terms of The phase angle Similarly, according to the calculation results of step 111, due to the phase angle Voltage phasor Leading voltage phasor The phase angle is 270° or the voltage phasor Leading voltage phasor The phase angle is 90°, that is, relative to the current phasor In terms of The phase angle From this, the current phasors are calculated The coordinate value of Similarly, if the voltage is in reverse phase sequence, in the phasor diagram, according to the calculation result of step 111, the phase angle Voltage phasor Leading voltage phasor The phase angle is 30°, that is, relative to the current phasor In terms of The phase angle or Similarly, according to the calculation results of step 111, due to the phase angle Voltage phasor Leading voltage phasor The phase angle is 90°, that is, relative to the current phasor In terms of The phase angle From this, the current phasors are calculated The coordinate value of Step 12: Determine the voltage phase sequence: (1) The voltage phase sequence in the data source table is only the positive phase sequence or the reverse phase sequence. The positive phase sequence has three forms: abc, bca, and cab, and the reverse phase sequence has three forms: acb, cba, and bac. The voltage phase sequence refers to the correspondence between the three voltage terminals 1, 2, and 3 from left to right of the three-phase three-wire electric energy meter and the three voltage terminals Ua, Ub, and Uc introduced by the voltage transformer; (2) Prepare a voltage phase sequence and phase angle relationship table, where the phase angle refers to The phase angle Need to use the phase angle in the data source table Calculate the phase angle There are four values: 60°, 120°, 240°, and 300°. The calculation method is: when the voltage phase sequence is positive, first calculate If the value of The phase angle like The phase angle When the voltage phase sequence is reverse phase sequence, first calculate If the value of The phase angle like The phase angle The calculated phase angle If the value is approximately equal to 60°, 120°, 240° or 300°, the EXCEL logic judgment function IF is used to convert it to a fixed value of 60°, 120°, 240° or 300°. The method is as follows: If the calculated phase angle The value is in cell K3. Enter "=IF($K$3<90,60,IF(AND($K$3>90,$K$3<180),120,IF(AND($K$3>180,$K$3<270),240,IF($K$3>270,300))))" in cell J3. Then you can get the phase angle in cell J3. The fixed value of (3) Based on three conditions The specific form of the voltage phase sequence is determined by the positive or negative phase sequence. The judgment method is: according to the voltage phase sequence and phase angle relationship table, the phase angle in the data source table is known value, voltage phase sequence and phase angle calculated in step 12 (2) The value of determines the specific form of the voltage phase sequence; Step 13: Determine the current phase sequence and polarity: (1) Produce current phase sequence, polarity and phase angle Voltage phase sequence relationship table, the current phase sequence refers to the secondary current of the current transformer The order of connecting the first and second components of the electric energy meter current loop is related to the current The corresponding relationship; the current polarity refers to the secondary current of the current transformer or The current flowing into the energy meter or Whether the directions are consistent. If not, it is usually called the reverse polarity of the current transformer. (2) Based on three conditions The voltage phase sequence determines the current phase sequence and polarity. The judgment method is: according to the current phase sequence, polarity and phase angle Voltage phase sequence relationship table, with known phase angle in the data source table value, the phase angle calculated in step 12 (2) The current phase sequence and polarity are determined based on the value of and the specific form of the voltage phase sequence determined in step 12 (3); Step 20 completes the judgment. Step 12 completes the judgment of the voltage phase sequence. Step 13 completes the judgment of the current phase sequence and polarity. This completes the judgment of the incorrect wiring form of the electric energy metering device. This allows you to know where the wiring of the electric energy metering device is wrong.

2. A method for batch monitoring and automatically determining three-phase three-wire incorrect wiring, characterized in that The method comprises the following steps performed in sequence: Step 10, obtain data: first, in the power user power consumption information collection system, obtain the source data measured by the electric energy meter through batch inspection. The source data refers to the data directly downloaded after batch inspection of the four data items "voltage data block, current data block, phase angle data block and meter operation status word" in the collection system. The file name is export.csv. Each collection object in the source data contains at least the following data: A phase voltage, B phase voltage, C phase voltage, A phase current, B phase current, C phase current, A phase phase angle, B phase phase angle, C phase angle, voltage reverse phase sequence fault or no fault, address code, terminal name, collection The collection object is saved in the folder "Energy metering device wrong wiring judgment", and a new "Three-phase three-wire wrong wiring judgment tool" EXCEL file is created in the folder; then, based on the source data file export.csv, EXCEL is used to extract useful data into the "Three-phase three-wire wrong wiring judgment tool" EXCEL file, which contains the data extraction worksheet TQ, the format conversion worksheet GS, and the data source worksheet TQ3-3. Each collection object in the data source worksheet TQ3-3 corresponds to a data record, which contains the following fields: address code, terminal name, collection object, phase angle Phase Angle Phase sequence, current I1, I3, voltage U12, U32, the voltage U12 refers to the voltage of the first element voltage circuit of the energy meter, that is, the A phase voltage in the source data, referred to as the first element voltage of the energy meter, the voltage U32 refers to the voltage of the second element voltage circuit of the energy meter, that is, the C phase voltage in the source data, referred to as the second element voltage of the energy meter, the Refers to the voltage phasor of the first element of the energy meter, refers to the voltage phasor of the second element of the energy meter, the current I1 refers to the incoming line current flowing into the current loop of the first element of the energy meter, that is, the A phase current in the source data, the current I3 refers to the incoming line current flowing into the current loop of the second element of the energy meter, that is, the C phase current in the source data, and the phase angle Refers to the voltage phasor of the first element of the energy meter With current phasor The phase angle is the phase angle of phase A in the source data. Refers to the voltage phasor of the second element of the energy meter With current phasor The phase angle is the phase angle of phase C in the source data. The phase sequence refers to the voltage phase sequence of the three voltage terminals 1, 2, and 3 of the electric energy meter from left to right. If the voltage phase sequence in the data source table is a positive phase sequence, it means that there is no fault in the reverse phase sequence of the voltage in the source data. If the voltage phase sequence in the data source table is a reverse phase sequence, it means that there is a fault in the reverse phase sequence of the voltage in the source data. Use the character extraction function MID to extract useful characters from the source data export.csv file to the data extraction worksheet TQ. The method is: enter =IFERROR(VALUE(MID(export.csv!$G2,FIND("@",SUBSTITUTE(export.csv!$G2,":","@",1))+2,5)),"") in cell H3 of the data extraction worksheet TQ. Each collection object still has four data records; use OFFSET and ROW functions to convert the data extraction worksheet TQ format to format Convert the worksheet GS format so that each collection object has only one data record. The method is: enter =OFFSET(TQ!$H$3,4*(ROW(TQ!H1)-1),,) in cell L3 of the format conversion worksheet GS, enter =OFFSET(TQ!$H$4,4*(ROW(TQ!E1)-1),,) in cell H3 of the format conversion worksheet GS, move the data in cells H3 and H4 of the data extraction worksheet TQ to cells L3 and H3 of the format conversion worksheet GS, and convert the four data record formats into one data record format. Formula; There are three-phase three-wire and three-phase four-wire energy meter data in the format conversion worksheet GS. It is also necessary to use INDEX and SMALL functions to separate the three-phase three-wire and three-phase four-wire data in the format conversion worksheet GS. The method is: in the data source worksheet TQ3-3, cell J4 enter =IFERROR(INDEX(GS!L:L,SMALL(IF(NOT((GS!$L$3:$L$1000>120)+(GS!$L$3:$L$1000="")+(GS!$H$3:$H$1000=0)),ROW(GS!$3 :$1000)),ROW(GS!L1))),""), where the data in column L in the format conversion worksheet GS is the value of voltage U12, which refers to the voltage of the first element of the three-phase three-wire electric energy meter, and the data in column H is the value of current I1. The meaning of the listed function statement is: if the data in column L is less than 120 and is not empty, and the data in column H is not equal to zero, then the row number that meets the conditions is returned, and then the SMALL function is used to retrieve and fill the data, and INDEX is used to locate the position of the corresponding data in column L. In this way, the data of the three-phase three-wire electric energy meter can be extracted separately and stored in the data source worksheet TQ3-3; Step 11, generate phasor diagram: create a new worksheet named "Operation Interface 3-3" in the "Three-phase Three-wire Wrong Wiring Judgment Tool" EXCEL file, and use the chart function of EXCEL office software to generate a phasor diagram in this worksheet. The phasor is a method used to represent sinusoidal alternating current, similar to a vector in physics, with size and direction. Its size is equal to the effective value of sinusoidal alternating current, and its direction is represented by the initial phase of sinusoidal alternating current. The phasor diagram is a voltage phasor in the vertical upward direction. As a reference, the phasor is drawn in a rectangular coordinate diagram. The phasor diagram can intuitively present the voltage phasor connected to the energy meter. Current phasor And its phase relationship Used by staff to compare and judge whether the wiring is wrong; Step 111: Generate a voltage phasor diagram, wherein the voltage phasor diagram includes the voltage phasors of the first and second components of the electric energy meter. And the voltage phasor The voltage phasor Voltage phasor In the power system, the three-phase voltage is generally symmetrical, that is, equal in magnitude and 120° out of phase. The method for generating the voltage phasor diagram is: As the reference, the phase angle Assume that voltage U1=U2=U3=1, then line voltage U12=U32=1.

732. If the voltage is positive phase sequence, due to the voltage phasor Leading voltage phasor The phase angle is 120°, then the phase angle Due to voltage phasor Leading voltage phasor The phase angle is 240°, then the phase angle Due to voltage phasor The voltage phasor can be obtained by drawing a phasor diagram or calculating Leading voltage phasor The phase angle is 330°, so the phase angle Due to voltage phasor The voltage phasor can be obtained by drawing a phasor diagram or calculating Leading voltage phasor The phase angle is 270°, so the phase angle The coordinate values ​​of each voltage phasor are calculated accordingly; If the voltage is in reverse phase sequence, the voltage phasor Leading voltage phasor The phase angle is 240°, then the phase angle Due to voltage phasor Leading voltage phasor The phase angle is 120°, then the phase angle Due to voltage phasor The voltage phasor can be obtained by drawing a phasor diagram or calculating Leading voltage phasor The phase angle is 30°, so the phase angle Due to voltage phasor The voltage phasor can be obtained by drawing a phasor diagram or calculating Leading voltage phasor The phase angle is 90°, so the phase angle The coordinate values ​​of each voltage phasor are calculated accordingly; Step 112, generate a current phasor diagram, the current phasor includes The phase angle in the data source table needs to be used The method of generating the current phasor diagram is as follows: As the reference, the phase angle Assume that current I1 = I3 = 0.

6. If the voltage is in positive phase sequence, in the phasor diagram, according to the calculation result of step 111, the phase angle Voltage phasor Leading voltage phasor The phase angle is 330° or the voltage phasor Leading voltage phasor The phase angle is 30°, that is, relative to the current phasor In terms of The phase angle Similarly, according to the calculation results of step 111, due to the phase angle Voltage phasor Leading voltage phasor The phase angle is 270° or the voltage phasor Leading voltage phasor The phase angle is 90°, that is, relative to the current phasor In terms of The phase angle From this, the current phasors are calculated The coordinate value of Similarly, if the voltage is in reverse phase sequence, in the phasor diagram, according to the calculation result of step 111, the phase angle Voltage phasor Leading voltage phasor The phase angle is 30°, that is, relative to the current phasor In terms of The phase angle or Similarly, according to the calculation results of step 111, due to the phase angle Voltage phasor Leading voltage phasor The phase angle is 90°, that is, relative to the current phasor In terms of The phase angle From this, the current phasors are calculated The coordinate value of Step 12: Determine the voltage phase sequence: (1) The voltage phase sequence in the data source table is only the positive phase sequence or the reverse phase sequence. The positive phase sequence has three forms: abc, bca, and cab, and the reverse phase sequence has three forms: acb, cba, and bac. The voltage phase sequence refers to the correspondence between the three voltage terminals 1, 2, and 3 from left to right of the three-phase three-wire electric energy meter and the three voltage terminals Ua, Ub, and Uc introduced by the voltage transformer; (2) Prepare a voltage phase sequence and phase angle relationship table, where the phase angle refers to The phase angle Need to use the phase angle in the data source table Calculate the phase angle There are four values: 60°, 120°, 240°, and 300°. The calculation method is: when the voltage phase sequence is positive, first calculate If the value of The phase angle like The phase angle When the voltage phase sequence is reverse phase sequence, first calculate If the value of The phase angle like The phase angle The calculated phase angle If the value is approximately equal to 60°, 120°, 240° or 300°, the EXCEL logic judgment function IF is used to convert it to a fixed value of 60°, 120°, 240° or 300°. The method is as follows: If the calculated phase angle The value is in cell K3. Enter "=IF($K$3<90,60,IF(AND($K$3>90,$K$3<180),120,IF(AND($K$3>180,$K$3<270),240,IF($K$3>270,300))))" in cell J3. Then you can get the phase angle in cell J3. The fixed value of (3) Based on three conditions The specific form of the voltage phase sequence is determined by the positive or negative phase sequence. The judgment method is: according to the voltage phase sequence and phase angle relationship table, the phase angle in the data source table is known value, voltage phase sequence and phase angle calculated in step 12 (2) The value of determines the specific form of the voltage phase sequence; Step 13: Determine the current phase sequence and polarity: (1) Produce current phase sequence, polarity and phase angle Voltage phase sequence relationship table, the current phase sequence refers to the secondary current of the current transformer The order of connecting the first and second components of the electric energy meter current loop is related to the current The corresponding relationship; the current polarity refers to the secondary current of the current transformer or The current flowing into the energy meter or Whether the directions are consistent. If not, it is usually called the reverse polarity of the current transformer. (2) Based on three conditions The voltage phase sequence determines the current phase sequence and polarity. The judgment method is: according to the current phase sequence, polarity and phase angle Voltage phase sequence relationship table, with known phase angle in the data source table value, the phase angle calculated in step 12 (2) The current phase sequence and polarity are determined based on the value of and the specific form of the voltage phase sequence determined in step 12 (3); Step 14: Derive the phase angle expression and correction coefficient expression, and calculate the power factor angle and correction coefficient K value of the load: Step 141, derive the phase angle expression and correction coefficient expression, wherein the phase angle expression is a power factor angle The phase angle is expressed as in is the power factor angle of the A-phase load, that is, the A-phase voltage phasor of the load Phase A current phasor leading the load The phase angle, is the power factor angle of the C-phase load, that is, the C-phase voltage phasor of the load Phase C current phasor leading the load The correction factor K expression refers to the phase angle used to compensate for the power and contains the power factor angle The correction coefficient K is equal to the amount of electricity or power P when the electric energy meter is correctly connected divided by the amount of electricity or power P' when it is incorrectly connected, that is, K = P / P', where the power when the connection is correct is Power in case of incorrect wiring There are 48 types of wiring for three-phase three-wire electric energy metering devices. Each wiring type, i.e., the determination results obtained in steps 12 and 13, has its own specific phasor diagram. In the phasor diagram, the corresponding The phase angle expression is then used to make a relationship table between the voltage phase sequence, current phase sequence and polarity and the phase angle and correction coefficient K expression; Step 142, calculate the power factor angle of the load. In the relationship table of voltage phase sequence, current phase sequence and polarity, phase angle, and correction coefficient K, the power factor angle of the load refers to the power factor angle of the A and C phase loads. They are included in the phase angle expression The power factor angle of the load Calculation method: According to the phase angle in the data source table Value and the value obtained in step 141 The phase angle expression can be used to calculate the power factor angle of the A and C phase loads. Step 143, calculate the correction factor K value, the correction factor K value is the power factor angle Right now The correction coefficient K value is calculated by: Substituting the value into the correction coefficient K expression derived in step 141, we can find and Not necessarily equal, but generally not much different. Value The power factor angle in the phase angle expression may be It may also be Due to the power factor angle of the user load changes with the load, and and They are not necessarily equal, so the calculated correction coefficient K is not a fixed value and is only used as a reference when making up for the electricity consumption. Step 15: Establish the relationship between the judgment result and the expression, establish the correlation between the wrong wiring judgment result of step 12 and step 13 and the phase angle and correction coefficient K expression of step 14, according to the relationship table of voltage phase sequence, current phase sequence and polarity and phase angle, correction coefficient K expression, after completing the judgment of voltage phase sequence in step 12 and the judgment of current phase sequence and polarity in step 13, use EXCEL logical judgment function IF and AND to realize multi-condition judgment to obtain the corresponding phase angle expression and correction coefficient K expression, the conditions are voltage phase sequence, current phase sequence and polarity; Step 16: Focus on displaying the phasor diagram and determination results, and the phase angle in the data source table There is a direct correlation with the generated phasor diagram and the results of the judgment in sequence; the judgment result is related to: voltage phase sequence, current phase sequence and polarity, phase angle expression, correction coefficient K expression, correction coefficient K value; in the "Operation Interface 3-3" worksheet in the "Three-phase Three-wire Wrong Wiring Judgment Tool" EXCEL file, the EXCEL list box control is used to control the change of each record data by selecting the collection object in the data source table, and the EXCEL search reference function OFFSET and COLUMN are used to establish the correlation between the phasor diagram, the judgment result and the data source table, so as to realize the dynamic display of the phasor diagram and the judgment result, and form the three-phase three-wire electric energy metering device wrong wiring judgment operation interface, whose content consists of four modules: Module 1 includes: communication address code, terminal name, basic information of the electricity user of the collection object and basic data including: phase angle, phase sequence, current and voltage; Module 2 is a list box, which contains the information of the collection object. You can click the mouse to select the collection object. Module three is the phasor diagram, which can visually present the voltage and current phasors and their phase relationship of the energy meter, which helps the staff to compare and judge whether the wiring is wrong; Module 4 is to determine the results and display the phase angle expression, correction factor K expression, power factor angle and correction factor K value; In the operation interface, select the acquisition object in the list box, and the phasor diagram will be automatically generated, and the judgment result will be automatically presented; Step 20, complete the judgment.

Images