Method, device and equipment for monitoring time-division phase line loss of transformer area and readable storage medium

Abstract

The application discloses a transformer area time and phase line loss monitoring method and device, computer equipment and a computer readable storage medium, relates to the field of power enterprise transformer area line loss monitoring, and realizes intuitive visual monitoring by automatically analyzing transformer area files, collecting and power information data, and presenting monitoring information in a graphical manner, accurately positioning transformer area line loss abnormal occurrence time and phase, improving transformer area line loss management level, transformer area line loss checking and management efficiency, and assisting in transformer area line loss management. The method comprises the following steps: establishing a data connection with a database; sending a query instruction to the database and executing a stored procedure in the database, the stored procedure being used for obtaining line loss analysis results of transformer area time and phase line loss data; receiving the line loss analysis results and closing the data connection with the database; based on the line loss analysis results, drawing a transformer area time and phase line loss curve diagram, and sending the line loss analysis results and the transformer area time and phase line loss curve diagram to a display terminal for display.

Description

Technical Field

[0001] This application relates to the field of power distribution area line loss monitoring technology, and in particular to a method, device, computer equipment, and computer-readable storage medium for time-phase line loss monitoring of power distribution areas. Background Technology

[0002] With the continuous development of power grid technology, most power supply is now supplied by transformers. Within the power supply range of a transformer, i.e., the distribution area, the power distribution network loses a certain amount of active power when transmitting and distributing electrical energy due to the impedance of the distribution equipment, resulting in energy waste.

[0003] Currently, technicians in related fields manage distribution networks by calculating transformer substation line losses. However, the calculated line losses for transformer substations cannot distinguish between line loss data for different time periods and different phases, thus failing to determine the time and phase of line loss anomalies, which seriously affects the efficiency of line loss management. Therefore, there is an urgent need for a time-based and phase-based line loss monitoring method for transformer substations. Summary of the Invention

[0004] In view of this, this application provides a method, device, computer equipment and computer-readable storage medium for monitoring the time-phase line loss of a transformer substation. The main purpose is to solve the problem that the currently calculated line loss of a transformer substation cannot distinguish the line loss data of different time periods and different phases, thus making it impossible to know the time and phase of the line loss anomaly, which seriously affects the efficiency of line loss management.

[0005] According to a first aspect of this application, a method for monitoring phase-by-phase line loss in a transformer substation is provided, the method comprising:

[0006] Establish a data connection with the database;

[0007] A query command is sent to the database, and a stored procedure is executed in the database. The stored procedure is used to obtain the line loss analysis results of the time-phase line loss data of the station.

[0008] Receive the line loss analysis results and close the data connection with the database;

[0009] Based on the line loss analysis results, a time-separated phase line loss curve for each station is plotted, and the line loss analysis results and the time-separated phase line loss curve for each station are sent to the display terminal for display.

[0010] Optionally, the step of executing a stored procedure in the database to obtain the line loss analysis results of the time-phase line loss data for each station includes:

[0011] Receives the target area number and time period input by the user, and identifies the area archive database;

[0012] In the transformer area archive database, extract the archive information whose transformer area number is the same as the target transformer area number as the transformer area archive information;

[0013] Identify the collection time indicated by the station area archive information, extract the specified archive information whose collection time matches the time period from the station area archive information, and obtain the collection data corresponding to the specified archive information;

[0014] The collection time of the specified archive information is differentially calculated to obtain multiple time intervals;

[0015] By aggregating the multiple time intervals, time-of-use data of the electricity meter is obtained;

[0016] Based on the time-of-use data of the electricity meter and the collected data, the line loss analysis results of the time-of-use and phase-of-use line loss data of the distribution station are determined. The line loss analysis results include the time-of-use electricity consumption of the electricity meter, the time-of-use and phase-of-use electricity consumption of the electricity meter, the time-of-use and phase-of-use electricity consumption of the distribution station, and the time-of-use and phase-of-use line loss rate of the distribution station.

[0017] Optionally, the step of determining the line loss analysis results of the substation's time-of-use line loss data based on the time-of-use data of the electricity meter and the collected data includes:

[0018] For each of the plurality of time intervals, the following processing is performed: identify the start time and end time of the current time interval, extract the first active power base code data corresponding to the start time and the second active power base code data corresponding to the end time from the collected data, calculate the difference between the second active power base code data and the first active power base code data, and use the difference as the total power consumption corresponding to the current time interval.

[0019] Calculate the total power consumption corresponding to each of the multiple time intervals to obtain multiple total power consumption values;

[0020] The total electricity consumption is correlated with the time-of-use data of the electricity meter to obtain the time-of-use electricity consumption of the electricity meter, and the time-of-use electricity consumption of the electricity meter is used as the line loss analysis result.

[0021] Optionally, the step of determining the line loss analysis results of the substation's time-of-use line loss data based on the time-of-use data of the electricity meter and the collected data includes:

[0022] Identify the number of phases of the energy meter indicated by the specified file information;

[0023] When the energy meter is a three-phase energy meter, determine the three phases corresponding to the three-phase energy meter;

[0024] For each of the multiple time intervals, identify the start and end time of the current time interval, extract the total power data and the start power data of each of the three phases at the start time from the collected data, and perform the following processing on each phase: read the time-of-use electricity of the electricity meter to obtain the total electricity corresponding to the current time interval, calculate the power integral ratio between the start power data of the phase and the total power data, and use the product of the power integral ratio and the total electricity as the target electricity corresponding to the phase in the current time interval;

[0025] The calculated target quantities of the three phases are used as the phase quantities of the current time interval;

[0026] Calculate the phase charge corresponding to each of the multiple time intervals to obtain the multiple phase charges;

[0027] The multiple phase-specific electricity values ​​are correlated with the time-of-use data of the electricity meter to obtain the time-of-use phase-specific electricity values ​​of the electricity meter, and the time-of-use phase-specific electricity values ​​of the electricity meter are used as the line loss analysis result.

[0028] Optionally, after identifying the number of phases of the energy meter indicated by the specified file information, the method further includes:

[0029] When the energy meter is a single-phase energy meter, the target phase corresponding to the single-phase energy meter is determined, the time-of-use energy of the energy meter is associated, the time-of-use phase energy of the energy meter corresponding to the single-phase energy meter is obtained, and the time-of-use phase energy of the energy meter is used as the line loss analysis result.

[0030] Optionally, the determination of the line loss analysis results based on the time-of-use data of the electricity meter and the operating data for each substation includes:

[0031] Identify the user category and meter point usage in the specified file information, and use the specified file information in which the user category matches a preset user category and the meter point usage matches a preset meter point usage as the target file information;

[0032] Based on the target data collected according to the target file information and the time-of-use data of the electricity meter, the time-of-use and phase-of-use electricity corresponding to the target file information is determined as the time-of-use and phase-of-use electricity of the substation.

[0033] In the time-phased power of the station, multiple input power quantities are extracted as power supply quantities, and multiple output power quantities are extracted as power sales quantities.

[0034] Based on the time-of-use and phase-of-use electricity of the distribution station, at least one phase corresponding to the time-of-use and phase-of-use electricity of the distribution station is determined. For each of the at least one phase, the following processing is performed: the first sum of the time-of-use electricity of the power supply under the current phase and the second sum of the time-of-use electricity of the power sales under the current phase are determined. The difference between the first sum and the second sum is calculated to obtain the time-of-use line loss of the distribution station corresponding to the current phase. The ratio of the time-of-use line loss of the distribution station to the first sum is calculated, and the ratio is used as the time-of-use line loss rate of the distribution station.

[0035] Calculate the time-specific line loss rate of each phase in the at least one phase to obtain the time-specific phase line loss rate of the station.

[0036] The time-phase power consumption of the substation and the time-phase line loss rate of the substation are used as the line loss analysis results.

[0037] According to a second aspect of this application, a time-series phase-loss monitoring device for substations is provided, the device comprising:

[0038] The connection module is used to establish a data connection with the database;

[0039] The sending module is used to send a query command to the database and execute a stored procedure in the database. The stored procedure is used to obtain the line loss analysis results of the time-phase line loss data of the station.

[0040] The acquisition module is used to receive the line loss analysis results and close the data connection with the database;

[0041] The drawing module is used to draw the time-series and phase-series line loss curves of the station based on the line loss analysis results, and send the line loss analysis results and the time-series and phase-series line loss curves of the station to the display terminal for display.

[0042] Optionally, the sending module is configured to receive the target transformer area number and time period input by the user, and identify the transformer area archive database; extract archive information with the same transformer area number as the target transformer area number from the transformer area archive database as transformer area archive information; identify the collection time indicated by the transformer area archive information, extract the specified archive information whose collection time matches the time period from the transformer area archive information, and obtain the collection data corresponding to the specified archive information; perform differential operation on the collection time of the specified archive information to obtain multiple time intervals; aggregate the multiple time intervals to obtain the time-of-use data of the electricity meter; and determine the line loss analysis result of the time-of-use phase line loss data of the transformer area based on the time-of-use data of the electricity meter and the collection data, wherein the line loss analysis result includes the time-of-use electricity consumption of the electricity meter, the time-of-use phase electricity consumption of the electricity meter, the time-of-use phase electricity consumption of the transformer area, and the time-of-use phase line loss rate of the transformer area.

[0043] Optionally, the sending module is configured to perform the following processing for each of the plurality of time intervals: identify the start and end collection times of the current time interval; extract the first active power base code data corresponding to the start collection time and the second active power base code data corresponding to the end collection time from the collected data; calculate the difference between the second active power base code data and the first active power base code data; use the difference as the total power consumption corresponding to the current time interval; calculate the total power consumption corresponding to each of the plurality of time intervals to obtain a plurality of total power consumptions; associate the plurality of total power consumptions with the time-of-use data of the electricity meter to obtain the time-of-use power consumption of the electricity meter; and use the time-of-use power consumption of the electricity meter as the line loss analysis result.

[0044] Optionally, the sending module is used to identify the number of phases of the energy meter indicated by the specified file information; when the energy meter is a three-phase energy meter, it determines the three phases corresponding to the three-phase energy meter; for each of the multiple time intervals, it identifies the start and end acquisition times of the current time interval, extracts the total power data and the start power data of each of the three phases at the start acquisition time from the acquired data, and performs the following processing on each phase: reads the time-of-use electricity of the energy meter to obtain the total electricity corresponding to the current time interval, calculates the power integral ratio between the start power data of the phase and the total power data, and uses the product of the power integral ratio and the total electricity as the target electricity corresponding to the phase in the current time interval; uses the three target electricity of the three phases as the phase electricity of the current time interval; calculates the phase electricity corresponding to each time interval in the multiple time intervals to obtain multiple phase electricity; associates the multiple phase electricity with the time-of-use data of the energy meter to obtain the time-of-use phase electricity of the energy meter, and uses the time-of-use phase electricity of the energy meter as the line loss analysis result.

[0045] Optionally, the sending module is further configured to, when the energy meter is a single-phase energy meter, determine the target phase corresponding to the single-phase energy meter, associate the time-of-use energy of the energy meter, obtain the time-of-use phase-specific energy of the energy meter corresponding to the single-phase energy meter, and use the time-of-use phase-specific energy of the energy meter as the line loss analysis result.

[0046] Optionally, the sending module is configured to identify the user category and metering point purpose in the specified file information, and to use the specified file information where the user category matches a preset user category and the metering point purpose matches a preset metering point purpose as target file information; based on the target collection data indicated by the target file information and the time-of-use data of the electricity meter, to determine the time-of-use and phase-of-use electricity corresponding to the target file information as the time-of-use and phase-of-use electricity of the substation; to extract multiple input electricity as power supply and multiple output electricity as power sales from the time-of-use and phase-of-use electricity of the substation; and to determine at least one time-of-use and phase-of-use electricity corresponding to the time-of-use and phase-of-use electricity of the substation. For each of the at least one phase, the following processing is performed: determine the first sum of the time-of-use electricity supply in the current phase and the second sum of the time-of-use electricity sales in the current phase; calculate the difference between the first sum and the second sum to obtain the time-of-use line loss of the platform corresponding to the current phase; calculate the ratio of the time-of-use line loss of the platform to the first sum, and use the ratio as the time-of-use line loss rate of the platform; calculate the time-of-use line loss rate of the platform corresponding to each of the at least one phase to obtain the time-of-use phase-specific line loss rate of the platform; and use the time-of-use phase-specific electricity supply and the time-of-use phase-specific line loss rate of the platform as the line loss analysis result.

[0047] According to a third aspect of this application, a computer device is provided, including a memory and a processor, wherein the memory stores a computer program, and the processor executes the computer program to implement the steps of the method described in any of the first aspects above.

[0048] According to a fourth aspect of this application, a computer-readable storage medium is provided, on which a computer program is stored, wherein the computer program, when executed by a processor, implements the steps of the method described in any one of the first aspects above.

[0049] By employing the above technical solution, this application provides a method, device, computer equipment, and computer-readable storage medium for monitoring time-of-use phase-by-phase line loss in transformer substations. This application first establishes a data connection with a database, then sends a query command to the database, and executes a stored procedure in the database to obtain the line loss analysis results of the time-of-use phase-by-phase line loss data for the transformer substations. Next, it receives the line loss analysis results and closes the data connection with the database. Finally, based on the line loss analysis results, it plots the time-of-use phase-by-phase line loss curves for the transformer substations and sends the line loss analysis results and the time-of-use phase-by-phase line loss curves to a display terminal for display. By automatically analyzing transformer substation archives, collecting and storing power information, and presenting the monitoring information graphically, it achieves intuitive and visual monitoring, accurately locates the time and phase of abnormal line loss in the transformer substations, improves the level of line loss management in the transformer substations, increases the efficiency of line loss verification and remediation, and assists in the remediation of line loss in the transformer substations.

[0050] The above description is only an overview of the technical solution of this application. In order to better understand the technical means of this application and to implement it in accordance with the contents of the specification, and to make the above and other objects, features and advantages of this application more obvious and understandable, the following are specific embodiments of this application. Attached Figure Description

[0051] Various other advantages and benefits will become apparent to those skilled in the art upon reading the following detailed description of preferred embodiments. The accompanying drawings are for illustrative purposes only and are not intended to limit the scope of this application. Furthermore, the same reference numerals denote the same parts throughout the drawings. In the drawings:

[0052] Figure 1 This illustration shows a flowchart of a time-sequential phase line loss monitoring method for substations provided in an embodiment of this application.

[0053] Figure 2A This illustration shows a flowchart of a time-sequential phase line loss monitoring method for substations provided in an embodiment of this application.

[0054] Figure 2B This illustration shows a flowchart of a time-sequential phase line loss monitoring method for substations provided in an embodiment of this application.

[0055] Figure 2C This paper presents a result curve diagram of a time-sequential phase line loss monitoring method for substations provided in an embodiment of this application.

[0056] Figure 2D This paper presents a result curve diagram of a time-sequential phase line loss monitoring method for substations provided in an embodiment of this application.

[0057] Figure 3 This illustration shows a schematic diagram of a time-sequential phase line loss monitoring device for substations provided in an embodiment of this application.

[0058] Figure 4 A schematic diagram of the device structure of a computer device provided in an embodiment of this application is shown. Detailed Implementation

[0059] Exemplary embodiments of the present application will now be described in more detail with reference to the accompanying drawings. While exemplary embodiments of the present application are shown in the drawings, it should be understood that the present application may be implemented in various forms and should not be limited to the embodiments set forth herein. Rather, these embodiments are provided so that this application will be thorough and complete, and will fully convey the scope of the present application to those skilled in the art.

[0060] This application provides a method for monitoring phase-by-phase line loss at different stations, such as... Figure 1 As shown, the method includes:

[0061] 101. Establish a data connection with the database.

[0062] 102. Send a query command to the database and execute a stored procedure in the database. The stored procedure is used to obtain the line loss analysis results of the time-phase line loss data of the station.

[0063] 103. Receive the line loss analysis results and close the data connection with the database.

[0064] 104. Based on the line loss analysis results, draw the time-separated phase line loss curves for each substation, and send the line loss analysis results and the time-separated phase line loss curves for each substation to the display terminal for display.

[0065] The method provided in this application first establishes a data connection with a database, then sends a query command to the database, and executes a stored procedure in the database to obtain the line loss analysis results of the time-based and phase-based line loss data of the transformer substation. Next, it receives the line loss analysis results and closes the data connection with the database. Finally, based on the line loss analysis results, it plots the time-based and phase-based line loss curves of the transformer substation and sends the line loss analysis results and the time-based and phase-based line loss curves of the transformer substation to a display terminal for display. By automatically analyzing transformer substation files, collecting and storing power information data, and presenting the monitoring information graphically, it achieves intuitive visual monitoring, accurately locates the time and phase of abnormal line loss in the transformer substation, improves the level of line loss management in the transformer substation, increases the efficiency of line loss verification and remediation, and assists in the remediation of line loss in the transformer substation.

[0066] This application provides a method for monitoring phase-by-phase line loss at different stations, such as... Figure 2A As shown, the method includes:

[0067] 201. Establish a data connection with the database.

[0068] This method is applied to a time-series phase-series line loss monitoring program for power distribution stations. Specifically, it can be a program script with monitoring functions, including web programs, SQL scripts, etc. Considering that the acquisition system will store the collected data and archive information in a database, this application first establishes a secure and reliable data connection between the monitoring program and the database, and then performs subsequent line loss analysis based on the archive information and collected information stored in the database.

[0069] 202. Send a query command to the database and execute a stored procedure in the database. The stored procedure is used to obtain the line loss analysis results of the time-phase line loss data of the station.

[0070] In this embodiment, the monitoring program sends a query command to the database to execute a stored procedure. The stored procedure refers to an SQL program and cursor loop that performs time-series and phase-series line loss data extraction and analysis for each station. Finally, the stored procedure returns the line loss analysis results for the time-series and phase-series line loss data. The specific process for obtaining the line loss analysis results is as follows:

[0071] First, the system receives the target transformer substation number and time period input by the user and identifies the transformer substation archive database. From the database, it extracts the archive information whose substation number matches the target substation number as the transformer substation archive information. Specifically, the transformer substation archive information includes, but is not limited to, the power supply company to which the substation belongs, user number, user category, metering point purpose, electricity meter barcode, and electricity meter phase information. This application does not specifically limit the category of transformer substation archive information.

[0072] Furthermore, the collection time indicated by the transformer substation archive information is identified. Specific archive information within the time frame matching the collection time is extracted from the transformer substation archive information, and the collection data corresponding to the specified archive information is obtained. For example, the electricity meter has power base code, voltage, current, and power data. By performing differential calculations on the collection time of the specified archive information, multiple time intervals are obtained. These multiple time intervals are then aggregated to obtain the electricity meter's time-of-use data. The specific process of obtaining the electricity meter's time-of-use data can be implemented based on the following formula 1:

[0073] Formula 1:

[0074] Where ΔT is the time-of-use data of the electricity meter; Δt i t represents the time interval for collecting the i-th data point; i+1 Let t be the acquisition time for the (i+1)th data point. i Let be the acquisition time of the i-th data point.

[0075] Finally, based on the time-of-use data of the electricity meter and the collected data, the line loss analysis results of the time-of-use and phase-of-use line loss data of the distribution station are determined. The line loss analysis results include the time-of-use electricity consumption of the electricity meter, the time-of-use and phase-of-use electricity consumption of the electricity meter, the time-of-use and phase-of-use electricity consumption of the distribution station, and the time-of-use and phase-of-use line loss rate of the distribution station.

[0076] First, obtain the time-of-use electricity consumption data from the electricity meter as the result of the line loss analysis.

[0077] For each of the multiple time intervals, perform the following processing for each time interval:

[0078] Identify the start and end times of the current time interval. Extract the first active power base code data corresponding to the start time and the second active power base code data corresponding to the end time from the collected data. Calculate the difference between the second and first active power base code data, and use this difference as the total electricity consumption for the current time interval. Calculate the total electricity consumption for each of the multiple time intervals to obtain multiple total electricity consumption values. Associate these multiple total electricity consumption values ​​with the time-of-use data of the electricity meter to obtain the time-of-use electricity consumption. Use the time-of-use electricity consumption as the result of line loss analysis. The specific process of obtaining the time-of-use electricity consumption can be implemented based on the following formula 2:

[0079] Formula 2:

[0080] Where W represents the time-of-use electricity consumption of the electricity meter; The energy consumption during the i-th time interval of the electricity meter; This is the base code of the energy meter at the (i+1)th data collection time, which is the second active power base code; This is the base code of the energy meter at the i-th collection time, i.e., the first active power base code data.

[0081] For example, the data collected by the electricity meter is shown in Table 1 below. The time-of-use electricity consumption is 2.24 kWh at 0 hours and 2.90 kWh at 1 hour.

[0082] Table 1. Data collected by electricity meters

[0083]

[0084] Second, the time-of-use and phase-of-use electricity meter readings are obtained as the results of line loss analysis.

[0085] First, identify the number of phases of the energy meter indicated by the specified file information. When the energy meter is a three-phase energy meter, determine the three phases corresponding to the three-phase energy meter. Then, for each time interval in multiple time intervals, identify the start and end time of the current time interval, and extract the total power data and the start power data of each of the three phases at the start time from the collected data.

[0086] Perform the following processing for each phase:

[0087] Read the time-of-use electricity from the electricity meter to obtain the total electricity consumption corresponding to the current time interval. Calculate the power integral ratio between the initial power data of each phase and the total power data. Multiply the power integral ratio by the total electricity consumption as the target electricity consumption for each phase under the current time interval.

[0088] Subsequently, the three target electrical quantities of the three phases are calculated as the phase-specific electrical quantities of the current time interval. The phase-specific electrical quantities corresponding to each time interval are calculated in multiple time intervals to obtain multiple phase-specific electrical quantities. These multiple phase-specific electrical quantities are then correlated with the time-of-use data of the electricity meter to obtain the time-of-use phase-specific electrical quantities of the electricity meter. These time-of-use phase-specific electrical quantities of the electricity meter are used as the line loss analysis result. The specific process of obtaining the time-of-use phase-specific electrical quantities of the electricity meter can be implemented based on the following formula 3:

[0089] Formula 3:

[0090] Among them, P j For three-phase energy meters at data collection time t i The power of the j-th phase; P z For three-phase energy meters at data collection time t i Total power; For three-phase energy meters at time interval Δt i The ratio of the power integral value of the j-th phase; Δt i Let i be the time interval for collecting the i-th data point; For three-phase energy meters at time interval Δt i Total power consumption; For three-phase energy meters at time interval Δt i The time-sharing energy of the j-th phase.

[0091] In addition, when the electricity meter is a single-phase electricity meter, the target phase corresponding to the single-phase electricity meter is determined. That is, based on the A, B, C phase or U, V, W phase of the single-phase electricity meter, the time-of-use electricity of the electricity meter is correlated to obtain the time-of-use phase electricity of the single-phase electricity meter. The time-of-use phase electricity of the electricity meter is used as the result of line loss analysis. The specific process of obtaining the time-of-use phase electricity of the electricity meter can be realized based on the following formula 4:

[0092] Formula 4:

[0093] Among them, W j The time-of-use electricity consumption of the j-th phase energy meter; is the total energy consumption of the j-th phase energy meter in the ith time interval; is the energy consumption of the j-th phase energy meter in the ith time interval, i.e., the time-of-use energy consumption.

[0094] Third, the time-phase power of each station is obtained as the result of line loss analysis.

[0095] Specifically, the user category and metering point purpose in the designated file information are identified, and the designated file information where the user category matches the preset user category and the metering point purpose matches the preset metering point purpose is taken as the target file information. Based on the target data collection and time-of-use data of the electricity meter indicated by the target file information, the time-of-use and phase-of-use electricity corresponding to the target file information is determined as the time-of-use and phase-of-use electricity of the substation.

[0096] Fourth, obtain the time-series phase line loss rate of each station as the line loss analysis result.

[0097] First, multiple input quantities are extracted from the time-of-use and phase-based power consumption of the distribution transformer as the power supply, and multiple output quantities are extracted as the power sales. In optional practical applications, the input quantities can include the forward power from the distribution transformer's gate meter, the power supplied to the grid by photovoltaic users, and the reverse power from ordinary users. The output quantities can include the reverse power from the distribution transformer's gate meter, the power consumed by photovoltaic users, and the forward power from ordinary users.

[0098] Subsequently, based on the time-based phase-based electricity consumption of the distribution station, at least one phase corresponding to the time-based phase-based electricity consumption of the distribution station is determined, and the following processing is performed on each of the at least one phase:

[0099] Determine the first sum of the time-of-use electricity supply under the current phase, and the second sum of the time-of-use electricity sales under the current phase. Calculate the difference between the first sum and the second sum to obtain the time-of-use line loss of the station corresponding to the current phase. Calculate the ratio of the time-of-use line loss of the station to the first sum, and use the ratio as the time-of-use line loss rate of the station.

[0100] Furthermore, the time-based line loss rate of each station corresponding to at least one phase is calculated to obtain the time-based phase-based line loss rate of the station. The specific process of obtaining the time-based phase-based line loss rate of the station can be implemented based on the following formulas 5 and 6:

[0101] Formula 5:

[0102] Among them, W in,j The time-sharing power supply of phase j in the transformer substation area; The sum of power supply for the j-th phase and the ith time interval in the transformer area; The power supply for the k-th energy meter in the j-th phase during the i-th time interval; W out,j The electricity sold during time of day for the j-th phase of the distribution area; This represents the total electricity sold in the j-th phase and ith time interval of the transformer area. Let represent the electricity sold by the j-th phase and the ith time interval of the ith meter.

[0103] By analyzing the difference between the power supply and the power sales, the time-series line loss of the distribution station can be obtained, as shown in Formula 6 below:

[0104] Formula 6:

[0105] Among them, W in,j W represents the time-of-use power supply of phase j in the transformer substation. out,j For the time-of-use electricity sales of the jth phase in the distribution area, W loss,j For the time-of-use line loss of phase j in the transformer area, r j The time-sharing line loss rate for the j-th phase of the transformer area.

[0106] Finally, the time-phase power consumption and time-phase line loss rate of the distribution station were used as the results of the line loss analysis.

[0107] 203. Receive the line loss analysis results and close the data connection with the database.

[0108] 204. Based on the line loss analysis results, draw the time-series and phase-series line loss curves for each substation, and send the line loss analysis results and the time-series and phase-series line loss curves for each substation to the display terminal for display.

[0109] In steps 203 to 204, the monitoring program receives the line loss analysis results, closes the data connection with the database, and then, based on the line loss analysis results, plots the time-based phase-based line loss curves for each distribution unit. The line loss analysis results and the time-based phase-based line loss curves for each distribution unit are then sent to the display terminal for display, achieving intuitive monitoring of the time-based phase-based line loss for each distribution unit. It should be noted that the display terminal can be a computer, mobile phone, tablet, or other smart device; this application does not specifically limit the model of the display terminal. For example, the power consumption and line loss rate corresponding to different phases can be represented by curve segments of different colors or formats using time-based phase-based line loss power curves and time-based phase-based line loss rate curves. Figure 2C and Figure 2D As shown, phase A has a high line loss rate and a large amount of power loss, which reaches its highest at 20:00. According to the time-phase line loss monitoring of the transformer substation, the abnormal line loss in the transformer substation occurs in phase A.

[0110] In summary, such as Figure 2B As shown, this application first starts the monitoring program, establishing a data connection between the program and the database. After successfully connecting to the database, a stored procedure is executed to interact with the database, analyzing the time-series and phase-series line loss data of the monitoring station to obtain the line loss analysis results. Finally, a time-series and phase-series line loss curve is plotted, and the line loss analysis data and the time-series and phase-series line loss curve are sent to the display terminal for display.

[0111] The method provided in this application first establishes a data connection with a database, then sends a query command to the database, and executes a stored procedure in the database to obtain the line loss analysis results of the time-based and phase-based line loss data of the transformer substation. Next, it receives the line loss analysis results and closes the data connection with the database. Finally, based on the line loss analysis results, it plots the time-based and phase-based line loss curves of the transformer substation and sends the line loss analysis results and the time-based and phase-based line loss curves of the transformer substation to a display terminal for display. By automatically analyzing transformer substation files, collecting and storing power information data, and presenting the monitoring information graphically, it achieves intuitive visual monitoring, accurately locates the time and phase of abnormal line loss in the transformer substation, improves the level of line loss management in the transformer substation, increases the efficiency of line loss verification and remediation, and assists in the remediation of line loss in the transformer substation.

[0112] Furthermore, as Figure 1 In a specific implementation of the method, this application provides a time-segregated phase line loss monitoring device for a station, such as... Figure 3 As shown, the device includes: a connection module 301, a sending module 302, an acquisition module 303, and a drawing module 304.

[0113] The connection module 301 is used to establish a data connection with the database;

[0114] The sending module 302 is used to send a query command to the database and execute a stored procedure in the database. The stored procedure is used to obtain the line loss analysis results of the time-phase line loss data of the station.

[0115] The acquisition module 303 is used to receive the line loss analysis results and close the data connection with the database.

[0116] The drawing module 304 is used to draw a time-separated phase line loss curve for the station based on the line loss analysis results, and send the line loss analysis results and the time-separated phase line loss curve for the station to the display terminal for display.

[0117] In a specific application scenario, the sending module 302 is used to receive the target transformer area number and time period input by the user, and identify the transformer area archive database; extract archive information with the same transformer area number as the target transformer area number from the transformer area archive database as transformer area archive information; identify the collection time indicated by the transformer area archive information, extract the specified archive information whose collection time matches the time period from the transformer area archive information, and obtain the collection data corresponding to the specified archive information; perform differential operation on the collection time of the specified archive information to obtain multiple time intervals; aggregate the multiple time intervals to obtain the time-of-use data of the electricity meter; based on the time-of-use data of the electricity meter and the collection data, determine the line loss analysis results of the time-of-use phase line loss data of the transformer area, the line loss analysis results include the time-of-use electricity consumption of the electricity meter, the time-of-use phase electricity consumption of the electricity meter, the time-of-use phase electricity consumption of the transformer area, and the time-of-use phase line loss rate of the transformer area.

[0118] In a specific application scenario, the sending module 302 is used to perform the following processing for each of the plurality of time intervals: identify the start and end collection times of the current time interval; extract the first active power base code data corresponding to the start collection time and the second active power base code data corresponding to the end collection time from the collected data; calculate the difference between the second active power base code data and the first active power base code data; use the difference as the total power consumption corresponding to the current time interval; calculate the total power consumption corresponding to each of the plurality of time intervals to obtain a plurality of total power consumption; associate the plurality of total power consumption with the time-of-use data of the electricity meter to obtain the time-of-use power consumption of the electricity meter; and use the time-of-use power consumption of the electricity meter as the line loss analysis result.

[0119] In a specific application scenario, the sending module 302 is used to identify the number of phases of the energy meter indicated by the specified file information; when the energy meter is a three-phase energy meter, it determines the three phases corresponding to the three-phase energy meter; for each of the multiple time intervals, it identifies the start and end time of the current time interval, extracts the total power data and the start power data of each of the three phases at the start time from the collected data, and performs the following processing on each phase: reads the time-of-use electricity of the energy meter to obtain the total electricity corresponding to the current time interval. Calculate the power integral ratio between the initial power data of the phase and the total power data, and use the product of the power integral ratio and the total power as the target power of the phase in the current time interval; use the three target power of the three phases as the phase power of the current time interval; calculate the phase power of each time interval in the multiple time intervals to obtain multiple phase power; associate the multiple phase power with the time-sharing data of the electricity meter to obtain the time-sharing phase power of the electricity meter, and use the time-sharing phase power of the electricity meter as the line loss analysis result.

[0120] In specific application scenarios, the sending module 302 is also used to determine the target phase corresponding to the single-phase energy meter when the energy meter is a single-phase energy meter, associate the time-of-use energy of the energy meter, obtain the time-of-use phase energy of the energy meter corresponding to the single-phase energy meter, and use the time-of-use phase energy of the energy meter as the line loss analysis result.

[0121] In specific application scenarios, the sending module 302 is used to identify the user category and metering point purpose in the specified file information, and to take the specified file information where the user category matches a preset user category and the metering point purpose matches a preset metering point purpose as the target file information; based on the target collection data indicated by the target file information and the time-of-use data of the electricity meter, to determine the time-of-use and phase-of-use electricity corresponding to the target file information as the time-of-use and phase-of-use electricity of the substation; to extract multiple input electricity as the power supply and multiple output electricity as the sales electricity from the time-of-use and phase-of-use electricity of the substation; and to determine the corresponding time-of-use and phase-of-use electricity of the substation based on the time-of-use and phase-of-use electricity of the substation. For at least one phase, the following processing is performed on each of the at least one phase: determining a first sum of the time-of-use electricity supply in the current phase and a second sum of the time-of-use electricity sales in the current phase; calculating the difference between the first sum and the second sum to obtain the time-of-use line loss of the platform corresponding to the current phase; calculating the ratio of the time-of-use line loss of the platform to the first sum and using the ratio as the time-of-use line loss rate of the platform; calculating the time-of-use line loss rate of the platform corresponding to each of the at least one phase to obtain the time-of-use phase-by-phase line loss rate of the platform; and using the time-of-use phase-by-phase electricity supply and the time-of-use phase-by-phase line loss rate of the platform as the line loss analysis result.

[0122] The device provided in this application first establishes a data connection with a database, then sends a query command to the database, and executes a stored procedure in the database to obtain the line loss analysis results of the time-based and phase-based line loss data of the transformer substations. Next, it receives the line loss analysis results and closes the data connection with the database. Finally, based on the line loss analysis results, it draws a time-based and phase-based line loss curve of the transformer substations and sends the line loss analysis results and the time-based and phase-based line loss curve of the transformer substations to a display terminal for display. By automatically analyzing transformer substation files, collecting and storing power information data, and presenting the monitoring information graphically, it achieves intuitive visual monitoring, accurately locates the time and phase of abnormal line loss in the transformer substations, improves the level of line loss management in the transformer substations, increases the efficiency of line loss verification and treatment, and assists in the treatment of line loss in the transformer substations.

[0123] It should be noted that other corresponding descriptions of the functional units involved in the time-sharing phase-separation line loss monitoring device provided in this application embodiment can be found by referring to... Figure 1 and Figures 2A to 2B The corresponding descriptions in [the document] will not be repeated here.

[0124] In an exemplary embodiment, see Figure 4The invention also provides a device comprising a communication bus, a processor, a memory, and a communication interface, and may further include input / output interfaces and a display device. The various functional units can communicate with each other via the bus. The memory stores a computer program, and the processor executes the program stored in the memory to perform the station-division time-separated phase line loss monitoring method described in the above embodiments.

[0125] A computer-readable storage medium having a computer program stored thereon, which, when executed by a processor, implements the steps of the time-sequential phase-line loss monitoring method for substations.

[0126] Through the above description of the embodiments, those skilled in the art can clearly understand that this application can be implemented in hardware or by using software plus necessary general-purpose hardware platforms. Based on this understanding, the technical solution of this application can be embodied in the form of a software product, which can be stored in a non-volatile storage medium (such as a CD-ROM, USB flash drive, external hard drive, etc.) and includes several instructions to cause a computer device (such as a personal computer, server, or network device, etc.) to execute the methods described in the various embodiments of this application.

[0127] Those skilled in the art will understand that the accompanying drawings are merely schematic diagrams of a preferred embodiment, and the modules or processes shown in the drawings are not necessarily essential for implementing this application.

[0128] Those skilled in the art will understand that the modules in the apparatus of the implementation scenario can be distributed within the apparatus of the implementation scenario as described, or they can be located in one or more apparatuses different from this implementation scenario, with corresponding changes. The modules of the above-described implementation scenario can be combined into one module, or they can be further divided into multiple sub-modules.

[0129] The serial numbers in this application are for descriptive purposes only and do not represent the superiority or inferiority of the implementation scenario.

[0130] The above disclosures are only a few specific implementation scenarios of this application. However, this application is not limited to these. Any variations that can be conceived by those skilled in the art should fall within the protection scope of this application.

Claims

1. A method for monitoring line loss of a transformer area in time and phase, applied to a program for monitoring line loss of a transformer area in time and phase, characterized in that, The method comprises: establishing a data connection with a database; sending a query instruction to the database and executing a stored procedure in the database, wherein the stored procedure refers to a SQL program and a cursor loop having functions of executing substation area time-of-use and phase line loss data extraction and analysis, the stored procedure is used to obtain a line loss analysis result of substation area time-of-use and phase line loss data, and comprises: receiving a target substation area number and a time period input by a user, and identifying a substation area archive database; in the substation area archive database, extracting archive information with the same substation area number as the target substation area number as substation area archive information; identifying a collection time indicated by the substation area archive information, extracting specified archive information in the substation area archive information that hits the time period, and obtaining collection data corresponding to the specified archive information; performing differential operation on the collection time of the specified archive information to obtain a plurality of time intervals; aggregating the plurality of time intervals to obtain time-of-use meter data; based on the time-of-use meter data and the collection data, determining a line loss analysis result of substation area time-of-use and phase line loss data, the line loss analysis result comprising time-of-use electric quantity, time-of-use and phase electric quantity, substation area time-of-use and phase electric quantity, and substation area time-of-use and phase line loss rate; receiving the line loss analysis result, and closing the data connection with the database; based on the line loss analysis result, drawing a substation area time-of-use and phase line loss curve graph, and sending the line loss analysis result and the substation area time-of-use and phase line loss curve graph to a display terminal for display.

2. The method of claim 1, wherein, The method further comprises: for each time interval in the plurality of time intervals, performing the following processing on each time interval: identifying a start collection time and an end collection time of the current time interval, extracting first active base code data corresponding to the start collection time and second active base code data corresponding to the end collection time in the collection data, and calculating a difference value between the second active base code data and the first active base code data as total electric quantity corresponding to the current time interval; calculating the total electric quantity corresponding to each time interval in the plurality of time intervals to obtain a plurality of total electric quantities; associating the plurality of total electric quantities with the time-of-use meter data to obtain the time-of-use electric quantity, and taking the time-of-use electric quantity as the line loss analysis result.

3. The method of claim 1, wherein, The method further comprises: identifying a number of phases of the electric meter indicated by the specified archive information; when the electric meter is a three-phase electric meter, determining three phase types corresponding to the three-phase electric meter; For each of the plurality of time intervals, a start collection time and an end collection time of a current time interval are identified, total power data in the collected data is extracted, start power data of each of the three phases at the start collection time is extracted, and the following processing is performed on each of the phases: reading the time-sharing electricity quantity of the electric energy meter to obtain total electricity quantity corresponding to the current time interval, calculating a power integration value ratio between the start power data of the phase and the total power data, and taking a product of the power integration value ratio and the total electricity quantity as target electricity quantity corresponding to the phase in the current time interval; taking the three target electricity quantities of the three phases calculated as phase-separated electricity quantity of the current time interval; calculating phase-separated electricity quantity corresponding to each of the plurality of time intervals to obtain a plurality of phase-separated electricity quantities; associating the plurality of phase-separated electricity quantities with the time-sharing data of the electric energy meter to obtain time-sharing phase-separated electricity quantity of the electric energy meter, and taking the time-sharing phase-separated electricity quantity of the electric energy meter as the line loss analysis result.

4. The method of claim 3, wherein, After the phase number of the electric energy meter indicated by the specified profile information is identified, the method further includes: when the electric energy meter is a single-phase electric energy meter, determining a target phase corresponding to the single-phase electric energy meter, associating the time-sharing electricity quantity of the electric energy meter to obtain the time-sharing phase-separated electricity quantity of the electric energy meter corresponding to the single-phase electric energy meter, and taking the time-sharing phase-separated electricity quantity of the electric energy meter as the line loss analysis result.

5. The method of claim 1, wherein, The line loss analysis result of the time-sharing phase-separated line loss data of the transformer area is determined based on the time-sharing data of the electric energy meter and the collected data, including: identifying a user category and a metering point use in the specified profile information, and taking the specified profile information in which the user category hits a preset user category and the metering point use hits a preset metering point use as target profile information; based on the target collection data indicated by the target profile information and the time-sharing data of the electric energy meter, determining time-sharing phase-separated electricity quantity corresponding to the target profile information as time-sharing phase-separated electricity quantity of the transformer area; extracting a plurality of input electricity quantities as power supply quantities and a plurality of output electricity quantities as sold electricity quantities from the time-sharing phase-separated electricity quantity of the transformer area; determining at least one phase corresponding to the time-sharing phase-separated electricity quantity of the transformer area according to the time-sharing phase-separated electricity quantity of the transformer area, and performing the following processing on each of the at least one phase: determining a first sum of time-sharing electricity quantity of the power supply quantity in the current phase and a second sum of time-sharing electricity quantity of the sold electricity quantity in the current phase, calculating a difference value between the first sum and the second sum to obtain transformer area time-sharing line loss corresponding to the current phase, and taking a ratio of the transformer area time-sharing line loss to the first sum as transformer area time-sharing line loss rate; calculating transformer area time-sharing line loss rate corresponding to each of the at least one phase to obtain time-sharing phase-separated line loss rate of the transformer area; taking the time-sharing phase-separated electricity quantity of the transformer area and the time-sharing phase-separated line loss rate of the transformer area as the line loss analysis result.

6. A device for monitoring line loss of a transformer area in time-division mode, characterized in that, including: a connection module configured to establish a data connection with a database; The sending module is configured to send a query instruction to the database and execute a stored procedure in the database, wherein the stored procedure refers to a SQL program and a cursor loop having functions of extracting and analyzing substation area time-sharing three-phase line loss data, and the stored procedure is configured to obtain a line loss analysis result of the substation area time-sharing three-phase line loss data, including: receiving a target substation area number and a time period input by a user, and identifying a substation area archive database; extracting, in the substation area archive database, archive information with the same substation area number as the target substation area number as substation area archive information; identifying a collection time indicated by the substation area archive information, extracting specified archive information with the collection time hitting the time period in the substation area archive information, and obtaining collection data corresponding to the specified archive information; performing differential operation on the collection time of the specified archive information to obtain a plurality of time intervals; aggregating the plurality of time intervals to obtain time-sharing electric energy meter data; and determining a line loss analysis result of the substation area time-sharing three-phase line loss data based on the time-sharing electric energy meter data and the collection data, wherein the line loss analysis result includes time-sharing electric quantity of the electric energy meter, time-sharing three-phase electric quantity of the electric energy meter, substation area time-sharing three-phase electric quantity, and substation area time-sharing three-phase line loss rate. The obtaining module is configured to receive the line loss analysis result and close a data connection between the database. The drawing module is configured to draw a substation area time-sharing three-phase line loss curve based on the line loss analysis result, and send the line loss analysis result and the substation area time-sharing three-phase line loss curve to a display terminal for display.

7. The apparatus of claim 6, wherein, The sending module is configured to receive a target substation area number and a time period input by a user, and identify a substation area archive database; extract, in the substation area archive database, archive information with the same substation area number as the target substation area number as substation area archive information; identify a collection time indicated by the substation area archive information, extract specified archive information with the collection time hitting the time period in the substation area archive information, and obtain collection data corresponding to the specified archive information; perform differential operation on the collection time of the specified archive information to obtain a plurality of time intervals; aggregate the plurality of time intervals to obtain time-sharing electric energy meter data; and determine a line loss analysis result of the substation area time-sharing three-phase line loss data based on the time-sharing electric energy meter data and the collection data, wherein the line loss analysis result includes time-sharing electric quantity of the electric energy meter, time-sharing three-phase electric quantity of the electric energy meter, substation area time-sharing three-phase electric quantity, and substation area time-sharing three-phase line loss rate. 8.A computer device, comprising a memory and a processor, wherein the memory stores a computer program, and the computer device is configured to perform the method according to any one of claims 1-7. The processor executes the computer program to implement the steps of the method in any one of claims 1 to 5.

9. A computer readable storage medium having stored thereon a computer program, characterized in that, The computer program is executed by the processor to implement the steps of the method in any one of claims 1 to 5.

Images