A method and system for calculating electric power carbon emission flow T-type power supply topology

Abstract

The present invention discloses a method and system for calculating the T-type power supply topology of electric power carbon emission flow, comprising: obtaining original data, performing data integration on the data nodes of the data file of the original data, storing the integrated data in a data warehouse, comparing the integrated data, completing power modification of the T-type power supply field of the high and low voltage substations, solving the scenario of T-type power supply of two 220KV substations, greatly reducing the loop problem in the carbon flow calculation, and effectively filling in the line data of some lines with zero power at the starting and ending points. The loop problem in the power network is solved, and the power grid management functions such as carbon flow calculation are restored to normal, avoiding the occurrence of program dead loops, and improving the accuracy and efficiency of power grid scheduling.

Description

Technical Field

[0001] The present invention belongs to the technical field of power systems, and in particular relates to a method and system for calculating a T-type power supply topology for power carbon emission flow. Background Art

[0002] A T-type power supply station (T-station) has been discovered in power grid structures. This structure involves connecting two high-voltage substations with a base voltage greater than or equal to 230°C and radiating power downward to a low-voltage substation with a base voltage less than or equal to 66°C. This scenario, where two high-voltage substations simultaneously supply power to the low-voltage substation through the T-station, is unreasonable in real-world power networks. This violates conventional power transmission logic and challenges the hierarchical and clear design principles of traditional power networks. This poses a series of technical and management challenges, particularly when calculating carbon flows (linking electricity production with the carbon footprint of emissions). More accurate models are needed to simulate energy losses and carbon emissions along different paths. This can lead to increased errors in traditional power flow calculation methods.

[0003] In power grid layouts, user substations may have multiple transformers connected to transmission stations in different directions (such as left / right T stations), serving as entry and exit points for these transmission stations. In this case, if the power generated by photovoltaic or other distributed energy resources at a user substation is used for power network scheduling, this power may be injected into the grid through different paths, further increasing the uncertainty of power flow paths and leading to an increase in loops in the power network. Traditional power flow calculation methods for this scenario will consider all possible power flow paths in the carbon flow calculation due to the increase in loops in the power network. This can lead to a sharp increase in computational complexity and even cause the program to enter an infinite loop in some cases.

[0004] 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.

[0005] Carbon flow calculation in power system mainly refers to the process of quantitative analysis of carbon emissions generated during the operation of 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 system flow calculation. Flow calculation is a method of analyzing the steady-state operation of power system, which 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 flow calculation, thus focusing not only on the flow of electric energy but also on the flow of carbon emissions. Through such calculation, power system operators and planners can obtain detailed information on the distribution of carbon emissions in the system, which is very important for implementing emission reduction measures, optimizing grid operation and supporting policy formulation. Related literature on carbon flow calculation includes: A 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);

[0006] 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). Summary of the Invention

[0007] The purpose of the present invention is to solve the problem in the prior art where two high-voltage substations, i.e., substations with a reference voltage value greater than or equal to 230, simultaneously supply power to a T station, i.e., a high-voltage substation T-type power supply scenario. However, since two high-voltage substations will not simultaneously supply power to a T station in reality, this scenario is contrary to the real physical scenario and does not conform to common sense, which will lead to huge errors in carbon flow calculations. At the same time, the prior art also has a scenario in which a low-voltage substation, i.e., a substation with a reference voltage value less than or equal to 66, simultaneously supplies power to multiple users through a T station, resulting in unreasonable load power distribution, i.e., a low-voltage substation T-type power supply scenario. Load distribution will affect carbon flow calculations, reducing the accuracy of carbon flow calculations.

[0008] In order to solve the above problems, the present invention provides a method for calculating the carbon emission flow of a T-type power supply topology, comprising the following steps:

[0009] S1: Get raw data;

[0010] 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.

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

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

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

[0014] S2: Raw data integration;

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

[0016] 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.

[0017] 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;

[0018] 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;

[0019] 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;

[0020] 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;

[0021] S2-2: Data integration;

[0022] S2-2-1: Create a new raw data integration table TableG, recording 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 fields;

[0023] 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.

[0024] S3: T-type power supply scenario for high-voltage substation;

[0025] S3-1: In Table A, the set of substation unique identifier field values ​​for all data records with a reference voltage field value greater than or equal to 230 is denoted as set RA = {RA1, RA2, RA3...};

[0026] In TableG, all the terminal station name field values ​​with the word "T station" as a suffix and the starting station unique identifier field value belong to the set RA, denoted as set R = {R1, R2, R3...}. The power supply of each T station in R complies with the T-type power supply scenario of the high-voltage substation;

[0027] S3-2: Group the set R by the terminal station name field. In each group, compare the starting power field values ​​of the two data records within the group. Select the incoming data record with the smallest starting power, denoted as Rsmall, and the incoming data record with the largest starting power, denoted as Rbig.

[0028] S3-3: Add the starting power field value of Rbig to the starting power field value of Rsmall, modify the end power field value of Rbig to the opposite of its own starting power field value, and modify the starting power field value and the end power field value of Rsmall to 0;

[0029] Through the processing of step S3, there is only one line between the two high-voltage substations, namely the substation with a reference voltage value greater than or equal to 230 and the T station, with a data record with non-zero power at both ends, which is valid data. Only this valid data is used in the calculation process of carbon emission flow, which is close to the actual power supply capacity;

[0030] S4: T-type power supply scenario for low-voltage substation;

[0031] S4-1: In Table A, the set of substation unique identifier field values ​​for all data records where the base voltage field value of the substation is less than or equal to 66, denoted as M = {M1, M2, M3...};

[0032] In Table G, all data records that meet one of the following conditions, denoted as set Z = {Z1, Z2, Z3...}, are considered to be in a low-voltage substation T-type power supply scenario. The specific conditions are as follows:

[0033] T1: When the value of the starting station unique identifier field belongs to the set M, the end station name field also contains: Left_T station or Right_T station;

[0034] T2: When the end station unique identifier field value belongs to the set M, and the start station name field contains: Left_T Station or Right_T Station;

[0035] The set of data records that only meet the T1 condition is recorded as set ZT1={Z1(T1),Z2(T1),Z3(T1)...};

[0036] The set of data records that only meet the T2 condition is recorded as set ZT2={Z1(T2),Z2(T2),Z3(T2)...};

[0037] S4-2: Substation splitting process;

[0038] Add the suffix _1 to the starting station unique identifier field value and the starting station name field value of each data record in the set ZT1, and add the suffix _2 to the ending station unique identifier field value and the ending station name field value of each data record in the set ZT2;

[0039] S4-3: Load data distribution and balancing;

[0040] In Table C, the load name field value of each data record consists of the plant name / load number plus the suffix "load". The load number consists of three digits, of which the first digit can only be 1 or 2, and the following two digits are arbitrary.

[0041] For each data record in the set ZT1, first remove the last two suffixes _1 from the starting station unique identification field value of the Zi(T1) (i∈N+) data record and compare it with the substation unique identifier of each data record in TableC. If the two are the same, put the same data record in TableC into the set ZE1, group all data records in the set ZE1 according to the first digit of the load number in the load name field value, and calculate the total value of all load power field values ​​in each group. The total load of the group whose first digit of the load number is 1 is recorded as P1. Therefore, the load amount that can be allocated to the substation of the Zi(T1) data record is P1, that is, the starting end power field value of the Zi(T1) data record is modified to P1.

[0042] For each data record in set ZT2, first remove the last two digits of the suffix _2 from the starting station unique identifier field value of the Zi(T2) data record and compare it with the substation unique identifier of each data record in TableC. If the two are the same, put the same data record in TableC into set ZE2, group all data records in set ZE2 according to the first digit of the load number in the load name field value, i.e., starting with 1 or 2, and calculate the total value of all load power field values ​​in each group; the total load of the group whose first digit of the load number is 2 is recorded as P2, so the load amount that the substation of the Zi(T2) (i∈N+) data record can be allocated is P2, that is, the terminal power field value of the Zi(T2) data record is modified to P2;

[0043] When performing load balancing within the power grid, the load is distributed according to the above, that is, the starting power field value of the Zi(T1) data record is modified to P1, and the ending power field value of the Zi(T2) data record is modified to P2, to ensure that the load demand is as close as possible to its actual power supply capacity.

[0044] A T-type power supply topology calculation system for electric power carbon emission flow, comprising: a data acquisition module, a data integration module, and a comparison module;

[0045] M1: Get the original data;

[0046] 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;

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

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

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

[0050] M2: raw data integration;

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

[0052] 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.

[0053] 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;

[0054] 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;

[0055] 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;

[0056] 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.

[0057] M2-2: Data integration;

[0058] 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;

[0059] M2-2-2: The data integration module obtains all data records of a certain date from TableD, and inserts them into TableG in sequence. The starting station unique identification field value in the newly inserted data of TableG is compared with the unique identifier field value of the substation in TableA one by one. If the two are the same, the starting station name field value of the TableG data is modified to the substation name field value of TableA. The end station unique identification field value in the newly inserted data of TableG is compared with the unique identifier field value of the substation in TableA one by one. If the two are the same, the end station name field value of the TableG data is modified to the substation name field value of TableA. The starting station unique identification field value in the newly inserted data of TableG is compared with the unique identifier field value of the substation in TableA. If the two are the same, the end station name field value in the TableG data is modified to the substation name field value of TableA. Compare the identification field 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 identification 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 identification 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 identification 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.

[0060] M3: T-type power supply scenario for high-voltage substation;

[0061] M3-1: In Table A, the set of substation unique identifier field values ​​for all data records with a reference voltage field value greater than or equal to 230, denoted as set RA = {RA1, RA2, RA3...};

[0062] In TableG, all the terminal station name field values ​​with the word "T station" as a suffix and the starting station unique identifier field value belong to the set RA, denoted as set R = {R1, R2, R3...}. The power supply of each T station in R complies with the T-type power supply scenario of the high-voltage substation;

[0063] M3-2: The set R is grouped according to the terminal station name field. In each group, the comparison module compares the starting power field values ​​of the two data records within the group. The incoming data record with the smallest starting power is selected, denoted as Rsmall, and the incoming data record with the largest starting power is selected, denoted as Rbig.

[0064] M3-3: Add the starting power field value of Rbig to the starting power field value of Rsmall, modify the ending power field value of Rbig to the opposite of its own starting power field value, and modify the starting power field value and ending power field value of Rsmall to 0;

[0065] M4: Low voltage substation T-type power supply scenario;

[0066] M4-1: In Table A, the set of substation unique identifier field values ​​for all data records where the base voltage field value of the substation is less than or equal to 66, denoted as M = {M1, M2, M3...};

[0067] In Table G, all data records that meet one of the following conditions, denoted as set Z = {Z1, Z2, Z3...}, are considered to be in a low-voltage substation T-type power supply scenario. The specific conditions are as follows:

[0068] T1: When the value of the starting station unique identifier field belongs to the set M, the end station name field also contains: Left_T station or Right_T station;

[0069] T2: When the end station unique identifier field value belongs to the set M, and the start station name field contains: Left_T Station or Right_T Station;

[0070] The set of data records that only meet the T1 condition is recorded as set ZT1={Z1(T1),Z2(T1),Z3(T1)...};

[0071] The set of data records that only meet the T2 condition is recorded as set ZT2={Z1(T2),Z2(T2),Z3(T2)...};

[0072] M4-2: Substation splitting process;

[0073] Add the suffix _1 to the starting station unique identifier field value and the starting station name field value of each data record in the set ZT1, and add the suffix _2 to the ending station unique identifier field value and the ending station name field value of each data record in the set ZT2;

[0074] M4-3: Load data distribution and balancing;

[0075] In Table C, the load name field value of each data record consists of the plant name / load number plus the suffix "load". The load number consists of three digits, of which the first digit can only be 1 or 2, and the following two digits are arbitrary.

[0076] The comparison module compares each data record in the set ZT1 in turn, first removing the last two suffixes _1 from the starting station unique identification field value of the Zi(T1) (i∈N+) data record and comparing it with the substation unique identifier of each data record in TableC. If the two are the same, the same data record in TableC is put into the set ZE1, and all data records in the set ZE1 are grouped according to the first digit of the load number in the load name field value, and the total value of all load power field values ​​in each group is calculated. The total load of the group whose first digit of the load number is 1 is recorded as P1, so the load amount that the substation of the Zi(T1) data record can be allocated is P1;

[0077] The comparison module compares each data record in the set ZT2 in turn, first removing the last two digits of the suffix _2 from the starting station unique identification field value of the Zi(T2) data record and comparing it with the substation unique identifier of each data record in TableC. If the two are the same, the same data record in TableC is put into the set ZE2, and all data records in the set ZE2 are grouped according to the first digit of the load number in the load name field value, i.e., starting with 1 or 2, and the total value of all load power field values ​​in each group is calculated; the total load of the group whose first digit of the load number is 2 is recorded as P2, so the load amount that the substation of the Zi(T2) (i∈N+) data record can be allocated is P2.

[0078] The present invention has the beneficial effects of comparing the power values ​​of the substation's starting end, modifying the starting end power field value of the end with the highest starting end power plus the starting end power field value of the end with the lowest starting end power to the inverse of the original starting end power field value, and modifying the starting end power field value and the ending end power field value of the end with the lowest starting end power to 0. This solves the problem of two high-voltage substations (i.e., substations with a reference voltage value greater than or equal to 230) simultaneously supplying power to a single T-station in the original data, thereby reducing errors in carbon flow calculation. Furthermore, by comparing the starting station unique identification field value with the substation unique identification field value of each data record in Table G, grouping by the first digit of the load number in the load name field value, and calculating the total value of the power field values ​​of all loads in each group, the total load of the group with the first digit of the load number being 1 is recorded as P1, and the starting end power field value of the data record is modified to P1. This solves the load distribution problem in the original data when a low-voltage substation (i.e., a substation with a reference voltage value less than or equal to 66) simultaneously supplies power to multiple users through the T-station. This allows the carbon flow calculation process to consider the impact of load on the calculation results, thereby improving the accuracy of carbon flow calculation. BRIEF DESCRIPTION OF THE DRAWINGS

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

[0080] The specific process of the present invention is described below with reference to the accompanying drawings:

[0081] S1: Get raw data;

[0082] From the scheduling D5000 system, export the file in the format of D5000_20240701_000001.CIME offline;

[0083] The content of the CIME file includes static archive data section, topology information data section, and operating power data section;

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

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

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

[0087] S2: Raw data integration;

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

[0089] 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.

[0090] 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;

[0091] 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;

[0092] 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;

[0093] 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;

[0094] S2-2: Data integration;

[0095] 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;

[0096] 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.

[0097] S3: T-type power supply scenario for high-voltage substation;

[0098] S3-1: In Table A, the set of substation unique identifier field values ​​for all data records with a reference voltage field value greater than or equal to 230 is denoted as set RA = {RA1, RA2, RA3...};

[0099] In TableG, all the terminal station name field values ​​with the word "T station" as a suffix and the starting station unique identifier field value belong to the set RA, denoted as set R = {R1, R2, R3...}. The power supply of each T station in R complies with the T-type power supply scenario of the high-voltage substation;

[0100] S3-2: Group the set R by the terminal station name field. In each group, compare the starting power field values ​​of the two data records within the group. Select the incoming data record with the smallest starting power, denoted as Rsmall, and the incoming data record with the largest starting power, denoted as Rbig.

[0101] S3-3: Add the starting power field value of Rbig to the starting power field value of Rsmall, modify the end power field value of Rbig to the opposite of its own starting power field value, and modify the starting power field value and the end power field value of Rsmall to 0;

[0102] Through the processing of step S3, there is only one line between the two high-voltage substations, namely the substation with a reference voltage value greater than or equal to 230 and the T station, with a data record with non-zero power at both ends, which is valid data. Only this valid data is used in the calculation process of carbon emission flow, which is close to the actual power supply capacity;

[0103] S4: T-type power supply scenario for low-voltage substation;

[0104] S4-1: In Table A, the set of substation unique identifier field values ​​for all data records where the base voltage field value of the substation is less than or equal to 66, denoted as M = {M1, M2, M3...};

[0105] In Table G, all data records that meet one of the following conditions, denoted as set Z = {Z1, Z2, Z3...}, are considered to be in a low-voltage substation T-type power supply scenario. The specific conditions are as follows:

[0106] T1: When the value of the starting station unique identifier field belongs to the set M, the end station name field also contains: Left_T station or Right_T station;

[0107] T2: When the end station unique identifier field value belongs to the set M, and the start station name field contains: Left_T Station or Right_T Station;

[0108] The set of data records that only meet the T1 condition is recorded as set ZT1={Z1(T1),Z2(T1),Z3(T1)...};

[0109] The set of data records that only meet the T2 condition is recorded as set ZT2={Z1(T2),Z2(T2),Z3(T2)...};

[0110] S4-2: Substation splitting process;

[0111] Add the suffix _1 to the starting station unique identifier field value and the starting station name field value of each data record in the set ZT1, and add the suffix _2 to the ending station unique identifier field value and the ending station name field value of each data record in the set ZT2;

[0112] S4-3: Load data distribution and balancing;

[0113] In Table C, the load name field value of each data record consists of the plant name / load number plus the suffix "load". The load number consists of three digits, of which the first digit can only be 1 or 2, and the following two digits are arbitrary.

[0114] For each data record in the set ZT1, first remove the last two suffixes _1 from the starting station unique identification field value of the Zi(T1) (i∈N+) data record and compare it with the substation unique identifier of each data record in TableC. If the two are the same, put the same data record in TableC into the set ZE1, group all data records in the set ZE1 according to the first digit of the load number in the load name field value, and calculate the total value of all load power field values ​​in each group. The total load of the group whose first digit of the load number is 1 is recorded as P1. Therefore, the load amount that can be allocated to the substation of the Zi(T1) data record is P1, that is, the starting end power field value of the Zi(T1) data record is modified to P1.

[0115] For each data record in set ZT2, first remove the last two digits of the suffix _2 from the starting station unique identifier field value of the Zi(T2) data record and compare it with the substation unique identifier of each data record in TableC. If the two are the same, put the same data record in TableC into set ZE2, group all data records in set ZE2 according to the first digit of the load number in the load name field value, i.e., starting with 1 or 2, and calculate the total value of all load power field values ​​in each group; the total load of the group whose first digit of the load number is 2 is recorded as P2, so the load amount that the substation of the Zi(T2) (i∈N+) data record can be allocated is P2, that is, the terminal power field value of the Zi(T2) data record is modified to P2;

[0116] When performing load balancing within the power grid, the load is distributed according to the above, that is, the starting power field value of the Zi(T1) data record is modified to P1, and the ending power field value of the Zi(T2) data record is modified to P2, to ensure that the load demand is as close as possible to its actual power supply capacity.

[0117] The present invention is used specifically and calculated based on the data of July 1, 2024 in Dalian City, Liaoning Province. Through actual verification, the present invention calculates and obtains: the starting end power modification value of Shuangxi Station in the T-type power supply scenario of the high-voltage substation composed of two high-voltage substations (Wanbao New Station and Shuangxi Station) and one low-voltage substation (Gangdian Station) is 5.885522, and the incoming power modification values ​​of the two low-voltage substations split from Chengnan Station in the T-type power supply scenario of the low-voltage substation where the low-voltage substation (Chengnan Station) is located are 9.325 and 11.097 respectively. The power of the high-voltage substation obtained from the existing original data is 5.552367, and the incoming power of the low-voltage substation is always 0. After modifying the substation power value obtained by the present invention, the problem of high and low voltages in the circuit is solved, the circuit is restored to the actual power supply scenario, an accurate circuit power value is obtained, and the accuracy of the carbon flow calculation is improved.

[0118] 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 T-type power supply topology of electric power carbon emission flow, 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 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 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: T-type power supply scenario for high-voltage substation; S3-1: In Table A, the set of substation unique identifier field values ​​for all data records with a reference voltage field value greater than or equal to 230 is denoted as set RA = {RA1, RA2, RA3...}; In TableG, all the terminal station name field values ​​with the word "T station" as a suffix and the starting station unique identifier field value belong to the set RA, denoted as set R = {R1, R2, R3...}. The power supply of each T station in R complies with the T-type power supply scenario of the high-voltage substation; S3-2: Group the set R by the terminal station name field. In each group, compare the starting power field values ​​of the two data records within the group. Select the incoming data record with the smallest starting power, denoted as Rsmall, and the incoming data record with the largest starting power, denoted as Rbig. S3-3: Add the starting power field value of Rbig to the starting power field value of Rsmall, modify the end power field value of Rbig to the opposite of its own starting power field value, and modify the starting power field value and the end power field value of Rsmall to 0; Through the processing of step S3, there is only one line between the two high-voltage substations, namely the substation with a reference voltage value greater than or equal to 230 and the T station, with a data record with non-zero power at both ends, which is valid data. Only this valid data is used in the calculation process of carbon emission flow, which is close to the actual power supply capacity; S4: T-type power supply scenario for low-voltage substation; S4-1: In Table A, the set of substation unique identifier field values ​​for all data records where the base voltage field value of the substation is less than or equal to 66, denoted as M = {M1, M2, M3...}; In Table G, all data records that meet one of the following conditions, denoted as set Z = {Z1, Z2, Z3...}, are considered to be in a low-voltage substation T-type power supply scenario. The specific conditions are as follows: T1: When the value of the starting station unique identifier field belongs to the set M, the end station name field also contains: Left_T station or Right_T station; T2: When the end station unique identifier field value belongs to the set M, and the start station name field contains: Left_T Station or Right_T Station; The set of data records that only meet the T1 condition is recorded as set ZT1={Z1(T1),Z2(T1),Z3(T1)...}; The set of data records that only meet the T2 condition is recorded as set ZT2={Z1(T2),Z2(T2),Z3(T2)...}; S4-2: Substation splitting process; Add the suffix _1 to the starting station unique identifier field value and the starting station name field value of each data record in the set ZT1, and add the suffix _2 to the ending station unique identifier field value and the ending station name field value of each data record in the set ZT2; S4-3: Load data distribution and balancing; In Table C, the load name field value of each data record consists of the plant name / load number plus the suffix "load". The load number consists of three digits, of which the first digit can only be 1 or 2, and the following two digits are arbitrary. For each data record in the set ZT1, first remove the last two suffixes _1 from the starting station unique identification field value of the Zi(T1) (i∈N+) data record and compare it with the substation unique identifier of each data record in TableC. If the two are the same, put the same data record in TableC into the set ZE1, group all data records in the set ZE1 according to the first digit of the load number in the load name field value, and calculate the total value of all load power field values ​​in each group. The total load of the group whose first digit of the load number is 1 is recorded as P1. Therefore, the load amount that can be allocated to the substation of the Zi(T1) data record is P1, that is, the starting end power field value of the Zi(T1) data record is modified to P1. For each data record in set ZT2, first remove the last two digits of the suffix _2 from the starting station unique identifier field value of the Zi(T2) data record and compare it with the substation unique identifier of each data record in TableC. If the two are the same, put the same data record in TableC into set ZE2, group all data records in set ZE2 according to the first digit of the load number in the load name field value, i.e., starting with 1 or 2, and calculate the total value of all load power field values ​​in each group; the total load of the group whose first digit of the load number is 2 is recorded as P2, so the load amount that the substation of the Zi(T2) (i∈N+) data record can be allocated is P2, that is, the terminal power field value of the Zi(T2) data record is modified to P2; When performing load balancing within the power grid, the load is distributed according to the above, that is, the starting power field value of the Zi(T1) data record is modified to P1, and the ending power field value of the Zi(T2) data record is modified to P2, to ensure that the load demand is as close as possible to its actual power supply capacity.

2. A T-type power supply topology calculation system for electric power carbon emission flow, 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: The data integration module obtains all data records of a certain date from TableD, and inserts them into TableG in sequence. The starting station unique identification field value in the newly inserted data of TableG is compared with the unique identifier field value of the substation in TableA one by one. If the two are the same, the starting station name field value of the TableG data is modified to the substation name field value of TableA. The end station unique identification field value in the newly inserted data of TableG is compared with the unique identifier field value of the substation in TableA one by one. If the two are the same, the end station name field value of the TableG data is modified to the substation name field value of TableA. The starting station unique identification field value in the newly inserted data of TableG is compared with the unique identifier field value of the substation in TableA. If the two are the same, the end station name field value in the TableG data is modified to the substation name field value of TableA. Compare the identification field 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 identification 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 identification 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 identification 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: T-type power supply scenario for high-voltage substation; M3-1: In Table A, the set of substation unique identifier field values ​​for all data records with a reference voltage field value greater than or equal to 230, denoted as set RA = {RA1, RA2, RA3...}; In TableG, all the terminal station name field values ​​with the word "T station" as a suffix and the starting station unique identifier field value belong to the set RA, denoted as set R = {R1, R2, R3...}. The power supply of each T station in R complies with the T-type power supply scenario of the high-voltage substation; M3-2: The set R is grouped according to the terminal station name field. In each group, the comparison module compares the starting power field values ​​of the two data records within the group. The incoming data record with the smallest starting power is selected, denoted as Rsmall, and the incoming data record with the largest starting power is selected, denoted as Rbig. M3-3: Add the starting power field value of Rbig to the starting power field value of Rsmall, modify the ending power field value of Rbig to the opposite of its own starting power field value, and modify the starting power field value and ending power field value of Rsmall to 0; M4: Low voltage substation T-type power supply scenario; M4-1: In Table A, the set of substation unique identifier field values ​​for all data records where the base voltage field value of the substation is less than or equal to 66, denoted as M = {M1, M2, M3...}; In Table G, all data records that meet one of the following conditions, denoted as set Z = {Z1, Z2, Z3...}, are considered to be in a low-voltage substation T-type power supply scenario. The specific conditions are as follows: T1: When the value of the starting station unique identifier field belongs to the set M, the end station name field also contains: Left_T station or Right_T station; T2: When the end station unique identifier field value belongs to the set M, and the start station name field contains: Left_T Station or Right_T Station; The set of data records that only meet the T1 condition is recorded as set ZT1={Z1(T1),Z2(T1),Z3(T1)...}; The set of data records that only meet the T2 condition is recorded as set ZT2={Z1(T2),Z2(T2),Z3(T2)...}; M4-2: Substation splitting process; Add the suffix _1 to the starting station unique identifier field value and the starting station name field value of each data record in the set ZT1, and add the suffix _2 to the ending station unique identifier field value and the ending station name field value of each data record in the set ZT2; M4-3: Load data distribution and balancing; In Table C, the load name field value of each data record consists of the plant name / load number plus the suffix "load". The load number consists of three digits, of which the first digit can only be 1 or 2, and the following two digits are arbitrary. The comparison module compares each data record in the set ZT1 in turn, first removing the last two suffixes _1 from the starting station unique identification field value of the Zi(T1) (i∈N+) data record and comparing it with the substation unique identifier of each data record in TableC. If the two are the same, the same data record in TableC is put into the set ZE1, and all data records in the set ZE1 are grouped according to the first digit of the load number in the load name field value, and the total value of all load power field values ​​in each group is calculated. The total load of the group whose first digit of the load number is 1 is recorded as P1, so the load amount that the substation of the Zi(T1) data record can be allocated is P1; The comparison module compares each data record in the set ZT2 in turn, first removing the last two digits of the suffix _2 from the starting station unique identification field value of the Zi(T2) data record and comparing it with the substation unique identifier of each data record in TableC. If the two are the same, the same data record in TableC is put into the set ZE2, and all data records in the set ZE2 are grouped according to the first digit of the load number in the load name field value, i.e., starting with 1 or 2, and the total value of all load power field values ​​in each group is calculated; the total load of the group whose first digit of the load number is 2 is recorded as P2, so the load amount that the substation of the Zi(T2) (i∈N+) data record can be allocated is P2.

Images