A method and system for calculating power carbon emission flow ring network topology

Abstract

The present invention discloses a method and system for calculating the topology of a power carbon emission flow ring network, including: obtaining a data file; the data file's content includes a static archive data section, a topology information data section, and an operating power data section; storing the data file in a database; integrating the stored data, and solving two loop problems by comparing the integrated data: a two-station multi-loop carbon flow route scenario and a single-loop carbon flow route scenario. This effectively avoids dead loops in the carbon flow calculation process, ensuring the stability and accuracy of the calculation process. By processing the loop, the carbon flow calculation will not encounter dead loops.

Description

Technical Field

[0001] The present invention belongs to the field of electric power, and in particular relates to a method and system for calculating the topology of an electric power carbon emission flow ring network. Background Art

[0002] In power network analysis, the direction of power flow can be used to identify closed loops consisting of multiple stations. This means that power flows originate at a station, pass through a series of stations, and ultimately return to the starting station, forming a loop. In power transmission networks, multiple stations (such as substations and power plants) are interconnected by multiple lines, allowing power to be transmitted along multiple paths. This increases the complexity of the power network and the frequency of loops.

[0003] In the power transmission network, the loop scenario is a common complex network structure. At present, with the expansion of the scale of the power transmission network, that is, the number of sites (such as substations, power plants) and lines has increased dramatically, resulting in a gradual increase in the number of multi-loop scenarios. For this scenario, the traditional carbon flow calculation method may find it difficult to fully and accurately simulate the complex interactions and influences between multiple sites, multiple lines and multiple loops in the power network. As the complexity of the power network increases, the traditional calculation model may not be able to capture all key variables and relationships, resulting in inaccurate calculation results. At the same time, the traditional carbon flow calculation method may face the challenge of a sharp increase in calculation amount, which not only increases the calculation time, but may also have an adverse impact on the real-time performance and stability of the power system.

[0004] Carbon flow calculation in power systems mainly refers to the process of quantitatively analyzing the carbon emissions generated during the production and transmission of electricity during the operation of the power system. This process involves multiple aspects of the power system, including but not limited to power generation, transmission, distribution and final power consumption. Carbon flow calculation is usually carried out on the basis of power flow calculation of the power system. Power flow calculation is a method for analyzing the steady-state operation of the power system. It can determine the voltage, phase angle and power flow of each node in the power system under given operating conditions. Carbon flow calculation introduces the factor of carbon emissions into the power flow calculation, thus focusing not only on the flow of electric energy but also on the flow of carbon emissions. Related literature on carbon flow calculation: Preliminary study on the calculation method of carbon emission flow in power system [J]. Zhou Tianrui; Kang Chongqing; Xu Qianyao; Chen Qixin. Automation of Power Systems, 2012(11); Research on optimization of carbon flow calculation in power system based on graphical model [J]. Qiu Bidan; Zheng Yiqiu; Huang Longjie; Peng Bin; Xiang Zouxiang. Big Data, 2024(10).

[0005] The smart grid dispatching and control system is an existing intelligent management system within the power grid. It includes the D5000 dispatching system, an advanced grid dispatching and management system capable of real-time monitoring and control of grid operations. This system is widely used in dispatching centers at all levels within the State Grid Corporation of China and is currently the most widely adopted grid dispatching and control system in the domestic power industry. The D5000 system utilizes a distributed architecture and consists of multiple subsystems that communicate over a network, enabling data sharing and coordination. The system can collect, process, and store large amounts of grid data, such as voltage, current, and power, in real time. The D5000 dispatching system contains various data files, some of which are stored in the CIME file format. Featuring multi-link data collection, multiple protocols, load balancing, multi-source data collection, and data forwarding, it plays a vital role in improving grid stability, reliability, cost-effectiveness, and reducing labor costs. Summary of the Invention

[0006] The purpose of the present invention is to solve the huge challenges that the existing technology may face in solving the loop problem. In modern power transmission networks, with the expansion of the scale of power transmission networks, that is, the number of sites (such as substations, power plants) and lines has increased dramatically, making loops (including multiple loops and single loops) become a common complex network structure, which may cause the carbon flow calculation process to fall into an infinite loop.

[0007] In order to solve the above problems, the present invention provides a method for calculating the topology of a power carbon emission flow ring network, comprising the following steps:

[0008] S1: Get raw data;

[0009] S1-1: The smart grid dispatching control system exports data files offline. The data file contents include: static archive data section, topology information data section, and operating power data section;

[0010] Static archive data sections include: substation archive data section, generator set archive data section, and load archive data section;

[0011] The topology information data section includes: substation connection file data section;

[0012] The operating power data section includes: the active power value data section of the unique line and substation associated with the metering point equipment;

[0013] S2: Raw data integration;

[0014] S2-1: File data is entered into the database;

[0015] Extract the data information of the substation archive data section and create a new substation archive table TableA. TableA records the data information of the substation's unique identifier, substation name, substation type, and reference voltage fields.

[0016] Extract the data information of the generator group archive data section and create a new generator group archive table TableB. TableB records the data information of the generator group's unique identifier, generator group name, voltage level, unique identifier of the substation to which it belongs, generated power and data date;

[0017] Extract the data information of the load file data section, create a new load file table TableC, and maintain the data information of the load's unique identifier, load name, substation unique identifier, load power and data date in the data table;

[0018] Extract the data information of the substation connection file data section, create a new substation connection file table TableD, and record the data information of the line's unique identifier, line name, line starting station identifier, line ending station identifier, voltage level and data date in TableD;

[0019] Extract the data information of the active power value data node of the unique line associated with the metering point device and the substation, create a new active power management table TableE for the unique line associated with the metering point device and the substation, and record the data information of the unique device identifier at one end of the line of the metering point, line name, unique identifier of the substation to which it belongs, unique identifier of the line, power and data date in the data table;

[0020] S2-2: Data integration;

[0021] S2-2-1: Create a new raw data integration table TableG, recording data date, line unique identifier, line name, starting station unique identifier, starting station name, terminal station unique identifier, terminal station name, voltage level, starting station metering point unique identifier, starting terminal power, terminal station metering point unique identifier and terminal power related fields;

[0022] S2-2-2: Get all data records of a certain date from TableD, insert them into TableG in sequence, compare the starting station unique identification field value in the newly inserted data of TableG with the substation unique identifier field value in TableA one by one, if the two are the same, modify the starting station name field value of TableG data to the substation name field value in TableA; compare the end station unique identification field value in the newly inserted data of TableG with the substation unique identifier field value in TableA one by one, if the two are the same, modify the end station name field value of TableG data to the substation name field value in TableA; modify the starting station unique identification field value in the newly inserted data of TableG Compare the segment value with the substation unique identifier field value in TableE one by one. If the two are the same, modify the starting station metering point unique identifier field value in TableG to the line end unique device identifier field value in TableE, and modify the starting end power field value in TableG to the power field value in TableE. Compare the terminal station unique identifier field value in the newly inserted data in TableG to the substation unique identifier field value in TableE one by one. If the two are the same, modify the terminal station metering point unique identifier field value in TableG to the line end unique device identifier field value in TableE, and modify the terminal power field value in TableG to the power field value in TableE.

[0023] S3: Two-station multi-loop carbon flow route scenario;

[0024] S3-1: In Table A, take any two substation name field data records, record them as RA and RB respectively, record the substation unique identifier field value of data record RA as MA, and record the substation unique identifier field value of data record RB as MB;

[0025] S3-2: In Table G, when the starting station unique identification field is MA and the end station unique identification field value is MB, or when the starting station unique identification field is MB and the end station unique identification field value is MA and the positive and negative signs of the starting and end power field values ​​are different, it is considered that a two-station multi-ring scenario has occurred, and the two-station multi-ring substation (A, B) can be obtained. In the substation (A, B), A represents the substation starting end and B represents the substation ending end.

[0026] S3-3: In Table G, when there are two records with the starting station unique identification field value of MA and the end station unique identification field value of MB, the following are as follows: one record records the starting end power P1(A, R1(A, B)) and the end end power P1(B, R1(A, B)) of R1(A, B), and the other record records the starting end power P1(A, R2(A, B)) and the end end power P1(B, R2(A, B)) of R2(A, B); when there is a record with the starting station unique identification field value of MB and the end station unique identification field value of MA, the following are as follows: one record records the starting end power P1(B, R1(B, A)) and the end end power P1(A, R1(B, A)) of R1(B, A);

[0027] S3-4: Compare the starting power values ​​of the above data records. Take the data record with the smallest starting power and perform the following processing:

[0028] S3-4-1: Assume that the starting power P1(B,R1(B,A)) of R1(B,A) is the smallest. Subtract P1(B,R1(B,A)) from the starting power of R1(A,B) and R2(A,B), and add P1(B,R1(B,A)) to the ending power.

[0029] S3-4-2: Change the starting power P1(B,R1(B,A)) and the ending power P1(A,R1(B,A)) of R1(B,A) to 0.

[0030] S3-4-3: Eliminate data records where both the starting and ending power are 0, and repeat steps S3-4-1 and S3-4-2 for the remaining data records until only one data record remains. When there is only one line between the two stations with power at both ends not equal to 0, only this data record is used in the carbon flow calculation, which prevents the carbon flow calculation from falling into an infinite loop.

[0031] S4: single-loop carbon flow route scenario;

[0032] S4-1: In Table G, the set of all line data on the loop is recorded as set RL = {RL1, RL2, RL3...};

[0033] S4-2: Perform the following processing on each line data RLi (i∈N+) in the line data information set RL:

[0034] Compare the starting power field values ​​of each line data RLi in RL one by one to find the line data record with the minimum starting power field value. The following processing is performed using RL1, which has the minimum starting power field value, as an example:

[0035] When the starting power field value of RL1 is the smallest, the starting power field value of each data record in the set RL except RL1 is subtracted from the starting power field value of RL1, and the end power field value is added to the end power field value of RL1, and then the starting power field value and the end power field value of RL1 are all modified to 0. When the line data of a single loop has a line with power of 0 at both ends, this data is not used in the carbon flow calculation process, so the single-loop carbon flow route scenario will not exist, and the carbon flow calculation will not fall into an infinite loop.

[0036] A power carbon emission flow ring network topology calculation system includes: a data acquisition module, a data integration module, and a comparison module;

[0037] M1: Get the original data;

[0038] The data acquisition module exports data files offline from the smart grid dispatching and control system. The data file contents include: static archive data section, topology information data section, and operating power data section;

[0039] Static archive data sections include: substation archive data section, generator set archive data section, and load archive data section;

[0040] The topology information data section includes: substation connection file data section;

[0041] The operating power data section includes: the active power value data section of the unique line and substation associated with the metering point equipment;

[0042] M2: raw data integration;

[0043] M2-1: File data is entered into the database;

[0044] The data integration module extracts data information from the substation archive data section and creates a new substation archive table TableA. TableA records data information of the substation's unique identifier, substation name, substation type, and reference voltage fields.

[0045] The data integration module extracts the data information of the generator set archive data section and creates a new generator set archive table TableB. TableB records the data information of the generator set's unique identifier, generator set name, voltage level, unique identifier of the substation to which it belongs, generated power and data date;

[0046] The data integration module extracts the data information of the load file data section and creates a new load file table TableC. The data table maintains the data information of the load's unique identifier, load name, substation unique identifier, load power and data date;

[0047] The data integration module extracts the data information of the substation connection file data section and creates a new substation connection file table TableD. TableD records the data information of the line's unique identifier, line name, line starting station identifier, line ending station identifier, voltage level and data date;

[0048] The data integration module extracts the data information of the active power value data node of the unique line associated with the metering point device and the substation, and creates a new active power management table Table E for the unique line associated with the metering point device and the substation. The data table records the unique device identifier of one end of the line of the metering point, the line name, the unique identifier of the substation to which it belongs, the unique identifier of the line, the power and the data date.

[0049] M2-2: Data integration;

[0050] M2-2-1: The data integration module creates a new raw data integration table TableG, which records the data date, line unique identifier, line name, starting station unique identifier, starting station name, terminal station unique identifier, terminal station name, voltage level, starting station metering point unique identifier, starting terminal power, terminal station metering point unique identifier, and terminal power related fields;

[0051] M2-2-2: Get all data records of a certain date from TableD, insert them into TableG in sequence, compare the starting station unique identification field value in the newly inserted data of TableG with the substation unique identifier field value in TableA one by one, if the two are the same, modify the starting station name field value of TableG data to the substation name field value in TableA; compare the end station unique identification field value in the newly inserted data of TableG with the substation unique identifier field value in TableA one by one, if the two are the same, modify the end station name field value of TableG data to the substation name field value in TableA; modify the starting station unique identification field value in the newly inserted data of TableG Compare the segment value with the substation unique identifier field value in TableE one by one. If the two are the same, modify the starting station metering point unique identifier field value in TableG to the line end unique device identifier field value in TableE, and modify the starting end power field value in TableG to the power field value in TableE. Compare the terminal station unique identifier field value in the newly inserted data in TableG to the substation unique identifier field value in TableE one by one. If the two are the same, modify the terminal station metering point unique identifier field value in TableG to the line end unique device identifier field value in TableE, and modify the terminal power field value in TableG to the power field value in TableE.

[0052] M3: Two-station multi-loop carbon flow route scenario;

[0053] M3-1: In Table A, the comparison module takes any two substation data records, denoted as RA and RB, and denotes the substation unique identifier field value of data record RA as MA, and the substation unique identifier field value of data record RB as MB;

[0054] M3-2: In Table G, when the starting station unique identification field is MA and the end station unique identification field value is MB, or when the starting station unique identification field value is MB and the end station unique identification field value is MA and the positive and negative signs of the starting end power field value are different from those of the end end power field value, it is considered that a two-station multi-ring scenario occurs, and the two-station multi-ring substation (A, B) can be obtained;

[0055] M3-3: In Table G, when there are two records with the starting station unique identification field value of MA and the ending station unique identification field value of MB, the following are as follows: one record records the starting end power P1(A, R1(A, B)) and the ending end power P1(B, R1(A, B)) of R1(A, B), and the other record records the starting end power P1(A, R2(A, B)) and the ending end power P1(B, R2(A, B)) of R2(A, B); when there is a record with the starting station unique identification field value of MB and the ending station unique identification field value of MA, the following are as follows: one record records the starting end power P1(B, R1(B, A)) and the ending end power P1(A, R1(B, A)) of R1(B, A);

[0056] M3-4: Compare the starting power values ​​of the three records above and take the data record with the smallest starting power for the following processing:

[0057] M3-4-1: Assume that the starting power P1(B,R1(B,A)) of R1(B,A) is the smallest. Subtract P1(B,R1(B,A)) from the starting power of R1(A,B) and R2(A,B), and add P1(B,R1(B,A)) to the ending power.

[0058] M3-4-2: Change the starting power P1(B,R1(B,A)) and the ending power P1(A,R1(B,A)) of R1(B,A) to 0;

[0059] M3-4-3: Eliminate data records where both the starting power and the ending power are 0, and repeat steps M3-4-1 and M3-4-2 for the remaining data records until only one data record remains.

[0060] M4: Single-loop carbon flow route scenario;

[0061] M4-1: In Table G, the set of all data records on the loop is recorded as set RL = {RL1, RL2, RL3...};

[0062] M4-2: Perform the following processing on each line data RLi (i∈N+) in the line data information set RL:

[0063] The comparison module compares the starting power field values ​​of each line data RLi in RL one by one to find the line data record with the minimum starting power field value. The following processing is performed using RL1, where the starting power field value is the minimum:

[0064] When the starting power field value of RL1 is the smallest, the starting power field value of each data record in the set RL except RL1 is subtracted from the starting power field value of RL1, and the end power field value is added to the end power field value of RL1, and then the starting power field value and the end power field value of RL1 are all modified to 0.

[0065] The beneficial effects of the present invention are as follows: by eliminating data records whose starting end power and end end power are both 0, and cyclically repeating steps S3-4-1 and S3-4-2 for the remaining data records until only one data record is left, when there is only one line between the two stations and the power at both ends is not 0, only this data is used in the carbon flow calculation process to solve the problem that the carbon flow calculation will not fall into an infinite loop; by subtracting the starting end power field value of RL1 from the starting end power field value of each data record other than RL1, and adding the end power field value of RL1 to the end power field value, and then modifying the starting end power field value and the end power field value of RL1 to 0, this data is not used in the carbon flow calculation process to solve the problem of the occurrence of an infinite loop phenomenon in the carbon flow calculation process due to the emergence of multi-loop scenarios and single-loop scenarios in modern power transmission networks, thereby ensuring the stable progress of the calculation process. BRIEF DESCRIPTION OF THE DRAWINGS

[0066] Figure 1 Schematic diagram of the implementation process of the present invention. DETAILED DESCRIPTION

[0067] The specific implementation process is described below with reference to the accompanying drawings:

[0068] S1: Get raw data;

[0069] S1-1: The smart grid dispatching control system exports data files offline. The data file contents include: static archive data section, topology information data section, and operating power data section;

[0070] Static archive data sections include: substation archive data section, generator set archive data section, and load archive data section;

[0071] The topology information data section includes: substation connection file data section;

[0072] The operating power data section includes: the active power value data section of the unique line and substation associated with the metering point equipment;

[0073] S2: Raw data integration;

[0074] S2-1: File data is entered into the database;

[0075] Extract the data information of the substation archive data section and create a new substation archive table TableA. TableA records the data information of the substation's unique identifier, substation name, substation type, and reference voltage fields.

[0076] Extract the data information of the generator group archive data section and create a new generator group archive table TableB. TableB records the data information of the generator group's unique identifier, generator group name, voltage level, unique identifier of the substation to which it belongs, generated power and data date;

[0077] Extract the data information of the load file data section, create a new load file table TableC, and maintain the data information of the load's unique identifier, load name, substation unique identifier, load power and data date in the data table;

[0078] Extract the data information of the substation connection file data section, create a new substation connection file table TableD, and record the data information of the line's unique identifier, line name, line starting station identifier, line ending station identifier, voltage level and data date in TableD;

[0079] Extract the data information of the active power value data node of the unique line associated with the metering point device and the substation, create a new active power management table TableE for the unique line associated with the metering point device and the substation, and record the data information of the unique device identifier at one end of the line of the metering point, line name, unique identifier of the substation to which it belongs, unique identifier of the line, power and data date in the data table;

[0080] S2-2: Data integration;

[0081] S2-2-1: Create a new raw data integration table TableG, recording data date, line unique identifier, line name, starting station unique identifier, starting station name, terminal station unique identifier, terminal station name, voltage level, starting station metering point unique identifier, starting terminal power, terminal station metering point unique identifier and terminal power related fields;

[0082] S2-2-2: Get all data records of a certain date from TableD, insert them into TableG in sequence, compare the starting station unique identification field value in the newly inserted data of TableG with the substation unique identifier field value in TableA one by one, if the two are the same, modify the starting station name field value of TableG data to the substation name field value in TableA; compare the end station unique identification field value in the newly inserted data of TableG with the substation unique identifier field value in TableA one by one, if the two are the same, modify the end station name field value of TableG data to the substation name field value in TableA; modify the starting station unique identification field value in the newly inserted data of TableG Compare the segment value with the substation unique identifier field value in TableE one by one. If the two are the same, modify the starting station metering point unique identifier field value in TableG to the line end unique device identifier field value in TableE, and modify the starting end power field value in TableG to the power field value in TableE. Compare the terminal station unique identifier field value in the newly inserted data in TableG to the substation unique identifier field value in TableE one by one. If the two are the same, modify the terminal station metering point unique identifier field value in TableG to the line end unique device identifier field value in TableE, and modify the terminal power field value in TableG to the power field value in TableE.

[0083] S3: Two-station multi-loop carbon flow route scenario;

[0084] The following example uses a two-station multi-loop carbon flow route scenario consisting of two substations, the Changre Plant and the New Materials Plant;

[0085] S3-1: First, let the Changre Plant be recorded as substation A and the New Materials Plant be recorded as substation B, so we can get a two-station multi-ring substation (A, B). The two records with substation A as the starting station and substation B as the terminal station are as follows: one record records the starting power P1(A, R1(A, B)) and the terminal power P1(B, R1(A, B)) of R1(A, B), and the other record records the starting power P1(A, R2(A, B)) and the terminal power P1(B, R2(A, B)) of R2(A, B). When the starting station is substation B and the terminal station is substation A, one record is as follows: one record records the starting power P1(B, R1(B, A)) and the terminal power P1(A, R1(B, A)) of R1(B, A);

[0086] S3-2: Compare the starting power values ​​of the above data records. Take the data record with the smallest starting power and perform the following processing:

[0087] S3-2-1: Assume that the starting power P1(B,R1(B,A)) of R1(B,A) is the smallest. Subtract P1(B,R1(B,A)) from the starting power of R1(A,B) and R2(A,B) respectively, and add P1(B,R1(B,A)) to the ending power.

[0088] S3-2-2: Change the starting power P1(B,R1(B,A)) and the ending power P1(A,R1(B,A)) of R1(B,A) to 0.

[0089] S3-2-3: Eliminate data records where both the starting power and the ending power are 0, and repeat steps S1-2-1 and S1-2-2 for the remaining data records until only one data record remains.

[0090] S4: single-loop carbon flow route scenario;

[0091] The following example uses a two-station single-loop (i.e., the simplest single-loop) carbon flow route scenario consisting of the two substations Lugang Station and Nanguanling Station as an example:

[0092] S4-1: In TableG, the set of all data records on the loop is recorded as set RL = {RL1, RL2, RL3...}.

[0093] S4-2: Perform the following processing on each line data RLi (i∈N+) in the line data information set RL:

[0094] Compare the starting power field values ​​of each line data RLi in RL one by one to find the line data record with the minimum starting power field value. The following processing is performed using RL1, which has the minimum starting power field value, as an example:

[0095] When the starting power field value of RL1 is the smallest, first, subtract the starting power field value of RL1 from the starting power field value of each data record in the set RL except RL1, and add the end power field value of RL1 to the end power field value, and then, modify the starting power field value and the end power field value of RL1 to 0.

[0096] Through specific use and calculation based on the data of Dalian City, Liaoning Province on July 1, 2024, the present invention has been verified through actual use. It is calculated that the multi-loop power modification value composed of Changre Plant and New Materials Station is 77.506004, and the single-loop power modification value composed of Lugang Station and Nanguanling Station is 70.425499. After the power value is modified, the loop electric energy is eliminated, and it is actually measured that the dead loop phenomenon in each loop disappears, the power in the circuit returns to normal, and the carbon flow emission value calculated by obtaining the power value of each loop is closer to the actual working environment value.

[0097] The above embodiments are only used to illustrate the technical solutions of the present invention rather than to limit the same. Although the present invention has been described in detail with reference to the preferred embodiments, those skilled in the art should understand that the technical solutions of the present invention can still be modified or replaced by equivalents, and these modifications or equivalent replacements cannot cause the modified technical solutions to deviate from the spirit and scope of the technical solutions of the present invention.

Claims

1. A method for calculating the topology of a power carbon emission flow ring network, characterized in that: The steps include: S1: Get raw data; S1-1: The smart grid dispatching control system exports data files offline. The data file contents include: static archive data section, topology information data section, and operating power data section; Static archive data sections include: substation archive data section, generator set archive data section, and load archive data section; The topology information data section includes: substation connection file data section; The operating power data section includes: the active power value data section of the unique line and substation associated with the metering point equipment; S2: Raw data integration; S2-1: File data is entered into the database; Extract the data information of the substation archive data section and create a new substation archive table TableA. TableA records the data information of the substation's unique identifier, substation name, substation type, and reference voltage fields. Extract the data information of the generator group archive data section and create a new generator group archive table TableB. TableB records the data information of the generator group's unique identifier, generator group name, voltage level, unique identifier of the substation to which it belongs, generated power and data date; Extract the data information of the load file data section, create a new load file table TableC, and maintain the data information of the load's unique identifier, load name, substation unique identifier, load power and data date in the data table; Extract the data information of the substation connection file data section, create a new substation connection file table TableD, and record the data information of the line's unique identifier, line name, line starting station identifier, line ending station identifier, voltage level and data date in TableD; Extract the data information of the active power value data node of the unique line associated with the metering point device and the substation, create a new active power management table TableE for the unique line associated with the metering point device and the substation, and record the data information of the unique device identifier at one end of the line of the metering point, line name, unique identifier of the substation to which it belongs, unique identifier of the line, power and data date in the data table; S2-2: Data integration; S2-2-1: Create a new raw data integration table TableG, recording data date, line unique identifier, line name, starting station unique identifier, starting station name, terminal station unique identifier, terminal station name, voltage level, starting station metering point unique identifier, starting terminal power, terminal station metering point unique identifier and terminal power related fields; S2-2-2: Get all data records of a certain date from TableD, insert them into TableG in sequence, compare the starting station unique identification field value in the newly inserted data of TableG with the substation unique identifier field value in TableA one by one, if the two are the same, modify the starting station name field value of TableG data to the substation name field value in TableA; compare the end station unique identification field value in the newly inserted data of TableG with the substation unique identifier field value in TableA one by one, if the two are the same, modify the end station name field value of TableG data to the substation name field value in TableA; modify the starting station unique identification field value in the newly inserted data of TableG Compare the segment value with the substation unique identifier field value in TableE one by one. If the two are the same, modify the starting station metering point unique identifier field value in TableG to the line end unique device identifier field value in TableE, and modify the starting end power field value in TableG to the power field value in TableE. Compare the terminal station unique identifier field value in the newly inserted data in TableG to the substation unique identifier field value in TableE one by one. If the two are the same, modify the terminal station metering point unique identifier field value in TableG to the line end unique device identifier field value in TableE, and modify the terminal power field value in TableG to the power field value in TableE. S3: Two-station multi-loop carbon flow route scenario; S3-1: In Table A, take any two substation name field data records, record them as RA and RB respectively, record the substation unique identifier field value of data record RA as MA, and record the substation unique identifier field value of data record RB as MB; S3-2: In Table G, when the starting station unique identification field is MA and the end station unique identification field value is MB, or when the starting station unique identification field is MB and the end station unique identification field value is MA and the positive and negative signs of the starting and end power field values ​​are different, it is considered that a two-station multi-ring scenario has occurred, and the two-station multi-ring substation (A, B) can be obtained. In the substation (A, B), A represents the substation starting end and B represents the substation ending end. S3-3: In Table G, when there are two records with the starting station unique identification field value of MA and the end station unique identification field value of MB, the following are as follows: one record records the starting end power P1(A, R1(A, B)) and the end end power P1(B, R1(A, B)) of R1(A, B), and the other record records the starting end power P1(A, R2(A, B)) and the end end power P1(B, R2(A, B)) of R2(A, B); when there is a record with the starting station unique identification field value of MB and the end station unique identification field value of MA, the following are as follows: one record records the starting end power P1(B, R1(B, A)) and the end end power P1(A, R1(B, A)) of R1(B, A); S3-4: Compare the starting power values ​​of the above data records, and take the data record with the smallest starting power for the following processing: S3-4-1: Assume that the starting power P1(B,R1(B,A)) of R1(B,A) is the smallest. Subtract P1(B,R1(B,A)) from the starting power of R1(A,B) and R2(A,B), and add P1(B,R1(B,A)) to the ending power. S3-4-2: Change the starting power P1(B,R1(B,A)) and the ending power P1(A,R1(B,A)) of R1(B,A) to 0. S3-4-3: Eliminate data records where both the starting and ending power are zero, and repeat steps S3-4-1 and S3-4-2 for the remaining data records until only one data record remains. If only one line between the two stations has non-zero power at both ends, only this data record is used in the carbon flow calculation to complete the creation of a single loop. S4: single-loop carbon flow route scenario; S4-1: In Table G, the set of all line data on the loop is recorded as set RL = {RL1, RL2, RL3...}; S4-2: Perform the following processing on each line data RLi (i∈N+) in the line data information set RL: Compare the starting power field values ​​of each line data RLi in RL one by one to find the line data record with the minimum starting power field value. The following processing is performed using RL1, which has the minimum starting power field value, as an example: When the starting power field value of RL1 is the smallest, the starting power field value of each data record in the set RL except RL1 is subtracted from the starting power field value of RL1, and the end power field value is added to the end power field value of RL1, and then the starting power field value and the end power field value of RL1 are all modified to 0; when the line data of a single loop has a line with power at both ends of 0, this data is excluded from the carbon flow calculation process to complete the creation of multiple loops.

2. A power carbon emission flow ring network topology calculation system, characterized in that: include: Data acquisition module, data integration module, comparison module; M1: Get the original data; The data acquisition module exports data files offline from the smart grid dispatching and control system. The data file contents include: static archive data section, topology information data section, and operating power data section; Static archive data sections include: substation archive data section, generator set archive data section, and load archive data section; The topology information data section includes: substation connection file data section; The operating power data section includes: the active power value data section of the unique line and substation associated with the metering point equipment; M2: raw data integration; M2-1: File data is entered into the database; The data integration module extracts data information from the substation archive data section and creates a new substation archive table TableA. TableA records data information of the substation's unique identifier, substation name, substation type, and reference voltage fields. The data integration module extracts the data information of the generator set archive data section and creates a new generator set archive table TableB. TableB records the data information of the generator set's unique identifier, generator set name, voltage level, unique identifier of the substation to which it belongs, generated power and data date; The data integration module extracts the data information of the load file data section and creates a new load file table TableC. The data table maintains the data information of the load's unique identifier, load name, substation unique identifier, load power and data date; The data integration module extracts the data information of the substation connection file data section and creates a new substation connection file table TableD. TableD records the data information of the line's unique identifier, line name, line starting station identifier, line ending station identifier, voltage level and data date; The data integration module extracts the data information of the active power value data node of the unique line associated with the metering point device and the substation, and creates a new active power management table Table E for the unique line associated with the metering point device and the substation. The data table records the unique device identifier of one end of the line of the metering point, the line name, the unique identifier of the substation to which it belongs, the unique identifier of the line, the power and the data date. M2-2: Data integration; M2-2-1: The data integration module creates a new raw data integration table TableG, which records the data date, line unique identifier, line name, starting station unique identifier, starting station name, terminal station unique identifier, terminal station name, voltage level, starting station metering point unique identifier, starting terminal power, terminal station metering point unique identifier, and terminal power related fields; M2-2-2: Get all data records of a certain date from TableD, insert them into TableG in sequence, compare the starting station unique identification field value in the newly inserted data of TableG with the substation unique identifier field value in TableA one by one, if the two are the same, modify the starting station name field value of TableG data to the substation name field value in TableA; compare the end station unique identification field value in the newly inserted data of TableG with the substation unique identifier field value in TableA one by one, if the two are the same, modify the end station name field value of TableG data to the substation name field value in TableA; modify the starting station unique identification field value in the newly inserted data of TableG Compare the segment value with the substation unique identifier field value in TableE one by one. If the two are the same, modify the starting station metering point unique identifier field value in TableG to the line end unique device identifier field value in TableE, and modify the starting end power field value in TableG to the power field value in TableE. Compare the terminal station unique identifier field value in the newly inserted data in TableG to the substation unique identifier field value in TableE one by one. If the two are the same, modify the terminal station metering point unique identifier field value in TableG to the line end unique device identifier field value in TableE, and modify the terminal power field value in TableG to the power field value in TableE. M3: Two-station multi-loop carbon flow route scenario; M3-1: In Table A, the comparison module takes any two substation data records, denoted as RA and RB, and denotes the substation unique identifier field value of data record RA as MA, and the substation unique identifier field value of data record RB as MB; M3-2: In Table G, when the starting station unique identification field is MA and the end station unique identification field value is MB, or when the starting station unique identification field value is MB and the end station unique identification field value is MA and the positive and negative signs of the starting end power field value are different from those of the end end power field value, it is considered that a two-station multi-ring scenario occurs, and the two-station multi-ring substation (A, B) can be obtained; M3-3: In Table G, when there are two records with the starting station unique identification field value of MA and the ending station unique identification field value of MB, the following are as follows: one record records the starting end power P1(A, R1(A, B)) and the ending end power P1(B, R1(A, B)) of R1(A, B), and the other record records the starting end power P1(A, R2(A, B)) and the ending end power P1(B, R2(A, B)) of R2(A, B); when there is a record with the starting station unique identification field value of MB and the ending station unique identification field value of MA, the following are as follows: one record records the starting end power P1(B, R1(B, A)) and the ending end power P1(A, R1(B, A)) of R1(B, A); M3-4: Compare the starting power values ​​of the three records above and take the data record with the smallest starting power for the following processing: M3-4-1: Assume that the starting power P1(B,R1(B,A)) of R1(B,A) is the smallest. Subtract P1(B,R1(B,A)) from the starting power of R1(A,B) and R2(A,B), respectively, and add P1(B,R1(B,A)) to the ending power. M3-4-2: Change the starting power P1(B,R1(B,A)) and the ending power P1(A,R1(B,A)) of R1(B,A) to 0; M3-4-3: Eliminate data records where both the starting power and the ending power are 0, and repeat steps M3-4-1 and M3-4-2 for the remaining data records until only one data record remains, completing the multi-loop creation. M4: Single-loop carbon flow route scenario; M4-1: In Table G, the set of all data records on the loop is recorded as set RL = {RL1, RL2, RL3...}; M4-2: Perform the following processing on each line data RLi (i∈N+) in the line data information set RL: The comparison module compares the starting power field values ​​of each line data RLi in RL one by one to find the line data record with the minimum starting power field value. The following processing is performed using RL1, where the starting power field value is the minimum: When the starting power field value of RL1 is the smallest, the starting power field value of each data record in the set RL except RL1 is subtracted from the starting power field value of RL1, and the end power field value is added to the end power field value of RL1, and then the starting power field value and the end power field value of RL1 are all modified to 0.

Images