An Excel-based embodied carbon calculation method and terminal

Abstract

The present invention provides an Excel-based embodied carbon calculation method and terminal, comprising the following steps: obtaining embodied carbon calculation rules; obtaining a data list and target data for embodied carbon, converting the target data into a table structure based on the embodied carbon data list, and generating basic parameters based on the table structure; defining a calculation function and an operation address of the calculation function in an Excel table based on the embodied carbon calculation rules and the basic parameters; creating a link address, calling the calculation function and the operation address based on the link address, and obtaining the embodied carbon calculation results. This calculation method allows even managers who are not familiar with the principles of the embodied carbon calculation method to quickly perform calculations through the preset basic parameters and the operation relationships contained in the calculation function, which helps to bring practical and effective convenience to regional embodied carbon calculation work and greatly improves the work efficiency of users.

Description

Technical Field

[0001] The present invention relates to the field of environmental protection technology, and in particular to an Excel-based embodied carbon calculation method and terminal. Background Art

[0002] Against the backdrop of the dual carbon goals, how to implement carbon peak action in a planned and phased manner has become a hot topic of concern. Consequently, the scientific accounting of carbon emissions and the equitable regional allocation of carbon emission rights have become crucial for addressing global climate change and building an ecologically civilized society. Current provincial carbon emission accounting focuses on a "production-side" carbon accounting standard, whereby production sites bear full responsibility for carbon emissions from product production. This ignores the objective reality of illogical allocation of local production carbon emission responsibilities due to external demand. Therefore, it is necessary to clarify the scale and flow of embodied carbon in interprovincial trade. This has important theoretical implications for rationally planning China's carbon peak action and can also provide a reference for decision-making on carbon responsibility demarcation and allocation, thus possessing significant practical significance.

[0003] Numerous studies have used the Multi-Region Input-Output (MRIO) model to provide methodological support for calculating interregional embodied carbon. These include using Asian international input-output tables to calculate indirect carbon transfer patterns in bilateral trade (Su, 2014), using environmental input-output analysis to analyze the impact of South-South trade on global CO2 emissions from a bilateral trade perspective (Meng et al., 2018), exploring carbon transfer across China's eight major regions (Zhang et al., 2014), and analyzing the structural characteristics of interprovincial trade carbon transfer networks (Yan Min, 2022). Among them, Peng Shuijun et al. (2015) used data from the World Input-Output Table to calculate China's production- and consumption-side carbon emissions and found that China's production-side carbon emissions were significantly higher than its consumption-side carbon emissions. Furthermore, Wang Yubao and He Yupeng (2021) used China's multi-regional input-output data and the MRIO model to make a more scientific accounting of carbon emissions from the production and consumption sides. The research results showed that there were significant differences in carbon emissions on the production and consumption sides among provinces in China in 2015. The embodied carbon transferred in and out of intermediate products and final demand was the main reason for provincial carbon transfer.

[0004] Existing research primarily utilizes MATLAB, R, Python, and EViews for data processing. For example, Gao Bo (2022) employed the MRIO model and Matlab software to estimate and decompose net carbon transfer levels across Chinese provinces and cities. Pan An (2017) constructed an environmental input-output model and used WIOD data to calculate the embodied carbon in China's agricultural imports and exports. The embodied carbon in foreign trade and related carbon reduction indicators in this study were also calculated using Matlab software. Yu Jinyan (2022) used Python software to identify the geospatial coupling of the carbon footprint of express delivery boxes from the perspectives of spatial decomposition and embodied carbon transfer. However, due to the large volume of carbon emission inventory data and the need for machine processing when calculating embodied carbon using a multi-regional input-output approach, the learning curve is high for managers unfamiliar with the principles of the calculation method. Furthermore, the processing of complex data involves nested calculation formulas, which can easily lead to errors and significant deviations in the results. Therefore, in practice, this approach lacks sufficient convenience for decision-makers. Summary of the Invention

[0005] The technical problem to be solved by the present invention is to provide an Excel-based embodied carbon calculation method and terminal, which directly locks the embodied carbon data calculation process into its original data input system, simplifies the current embodied carbon data calculation method, and improves the embodied carbon data calculation efficiency.

[0006] In order to solve the above technical problems, the technical solution adopted by the present invention is:

[0007] An Excel-based method for calculating embodied carbon includes the following steps:

[0008] Obtaining the measurement rules for embodied carbon;

[0009] Obtaining a data list of embodied carbon and target data, converting the target data into a table structure according to the data list of embodied carbon, and generating basic parameters based on the table structure;

[0010] Defining a calculation function and a calculation address of the calculation function in an Excel sheet according to the embodied carbon calculation rules and the basic parameters;

[0011] A link address is created, and the calculation function and the operation address are called according to the link address to obtain the calculation result of the embodied carbon.

[0012] In order to solve the above technical problems, another technical solution adopted by the present invention is:

[0013] An Excel-based embodied carbon calculation terminal includes a memory, a processor, and a computer program stored in the memory and running on the processor. When the processor executes the computer program, the following steps are implemented:

[0014] Obtaining the measurement rules for embodied carbon;

[0015] Obtaining a data list of embodied carbon and target data, converting the target data into a table structure according to the data list of embodied carbon, and generating basic parameters based on the table structure;

[0016] Defining a calculation function and a calculation address of the calculation function in an Excel sheet according to the embodied carbon calculation rules and the basic parameters;

[0017] A link address is created, and the calculation function and the operation address are called according to the link address to obtain the calculation result of the embodied carbon.

[0018] The beneficial effects of the present invention are: the target data are summarized and organized through the embodied carbon measurement rules, and the data that was originally of a large order of magnitude is simplified to form corresponding basic parameters, without the need for manual data organization and measurement, thus reducing the measurement steps; in the later process of the measurement function, the basic parameters are directly called for calculation to achieve quick calculation of the embodied carbon on the production side and consumption side of the target data. This measurement method allows even managers who are not familiar with the principles of the embodied carbon measurement method to quickly perform calculations through the preset basic parameters and the operational relationships contained in the measurement function, which helps to bring practical and effective convenience to the regional embodied carbon calculation work and greatly improves the work efficiency of users. BRIEF DESCRIPTION OF THE DRAWINGS

[0019] Figure 1 A flowchart of the steps of an Excel-based embodied carbon calculation method provided in an embodiment of the present invention;

[0020] Figure 2 A flowchart of an Excel-based embodied carbon calculation method provided in an embodiment of the present invention;

[0021] Figure 3 A schematic diagram of the interface of the system operation guidance module provided in an embodiment of the present invention;

[0022] Figure 4 A schematic diagram of a multi-region input-output model provided by an embodiment of the present invention;

[0023] Figure 5 A flowchart of an Excel-based method for calculating embodied carbon provided in an embodiment of the present invention;

[0024] Figures 6 and 7A specific application scenario of an Excel-based embodied carbon calculation method provided in an embodiment of the present invention;

[0025] Figure 8 A schematic diagram of the structure of an Excel-based embodied carbon calculation terminal provided in an embodiment of the present invention;

[0026] Description of labels:

[0027] 1. An Excel-based embodied carbon measurement terminal; 2. Memory; 3. Processor. DETAILED DESCRIPTION

[0028] To illustrate the technical content, achieved objectives and effects of the present invention in detail, the following description is given in conjunction with the embodiments and accompanying drawings.

[0029] Please refer to Figure 1 , an embodiment of the present invention provides a method for calculating embodied carbon based on an Excel table, comprising the steps of:

[0030] Obtaining the measurement rules for embodied carbon;

[0031] Obtaining a data list of embodied carbon and target data, converting the target data into a table structure according to the data list of embodied carbon, and generating basic parameters based on the table structure;

[0032] Defining a calculation function and a calculation address of the calculation function in an Excel sheet according to the embodied carbon calculation rules and the basic parameters;

[0033] A link address is created, and the calculation function and the operation address are called according to the link address to obtain the calculation result of the embodied carbon.

[0034] From the above description, it can be seen that the beneficial effects of the present invention are: the target data are summarized and organized through the embodied carbon measurement rules, and the data that is originally of a large order of magnitude is simplified to form corresponding basic parameters, without the need for manual data organization and measurement, thus reducing the measurement steps; in the later process of calculating the function, the basic parameters are directly called for calculation to achieve quick calculation of the embodied carbon on the production side and consumption side of the target data. This measurement method allows even managers who are not familiar with the principles of the embodied carbon measurement method to quickly perform calculations through the preset basic parameters and the operational relationships contained in the calculation function, which helps to bring practical and effective convenience to the regional embodied carbon calculation work and greatly improves the work efficiency of users.

[0035] Furthermore, the embodied carbon calculation rules include production-side carbon calculation rules and consumption-side carbon calculation rules;

[0036] The calculation rules for obtaining embodied carbon include:

[0037] Obtain the production-side carbon measurement rules and the consumption-side carbon measurement rules respectively;

[0038] Construct the production-side carbon emission function according to the production-side carbon measurement rules:

[0039] Production-side carbon emissions = regional demand carbon emissions + carbon emissions caused by outflow of intermediate products + carbon emissions caused by outflow of final products + embodied carbon in exports;

[0040] According to the consumption-side carbon measurement rules, the consumption-side carbon emission function is constructed:

[0041] Consumption-side carbon emissions = regional carbon emissions + carbon emissions caused by the inflow of intermediate products + carbon emissions caused by the inflow of final products + carbon embodied in imports.

[0042] As can be seen from the above description, based on the principle of embodied carbon measurement, data is organized and defined in advance, and operational relationships between the data are created. In the subsequent calculation process, even managers who are unfamiliar with the measurement principles can directly call functions through clear operational rules to achieve rapid measurement, thereby improving the efficiency of the measurement work and reducing labor costs.

[0043] Furthermore, the data inventory of embodied carbon includes a multi-region input-output model, an energy inventory, and a carbon emission inventory;

[0044] The step of obtaining a data list of embodied carbon and target data, converting the target data into a table structure according to the data list of embodied carbon, and generating basic parameters based on the table structure includes:

[0045] Obtain a data list of embodied carbon and preset the cell addresses corresponding to different data lists based on an Excel table;

[0046] Acquiring target data, creating a first operation rule between the target data according to the embodied carbon measurement rule, and presetting a plurality of basic parameter functions based on the first operation rule;

[0047] Classifying the target data according to the data list and storing the data in the cell addresses of the corresponding data list, and generating a multi-region input-output table, an energy data table, and a carbon emission data table respectively;

[0048] An address function for constructing a basic parameter is constructed by calling the cell address corresponding to the target data based on the basic parameter function;

[0049] The target data in the corresponding table structure is obtained according to the address function and calculated to obtain basic parameters.

[0050] From the above description, it can be seen that based on the embodied carbon measurement rules, regional input-output analysis generally draws on the characteristics of the interdependence of economic activities from equilibrium theory. Therefore, based on the regional input-output table model, the mathematical form of algebraic simultaneous equations is used to describe this interdependent relationship, thereby simplifying the data relationship and intuitively obtaining some basic parameters, which is convenient for subsequent data research and analysis and observation data; in addition, the calculation process of embodied carbon also involves data from other data lists, so the amount of data involved in the measurement process is very large. The present invention is based on the query and calculation functions of Excel tables to simplify the data into different basic parameters, thereby improving the measurement efficiency, and the calculation method is simple and fast.

[0051] Furthermore, the calculation function defined according to the embodied carbon calculation rules and the basic parameters and the calculation address of the calculation function in the Excel table include:

[0052] creating a second operational relationship between the basic parameters according to the embodied carbon calculation rule, constructing a calculation function based on the second operational relationship, and defining the calculation functions respectively;

[0053] The calculation address of the measurement function is defined based on an Excel table.

[0054] From the above description, it can be seen that the present invention normalizes the calculation method of target data and gathers similar data to form multiple basic parameters. In the measurement function, batch calculation of similar target data can be achieved only by creating the operation relationship between the basic parameters, which greatly reduces the data level of the calculation process and effectively improves the measurement efficiency. At the same time, the operation address of the measurement function is defined, and the modularization of the measurement method is realized based on the Excel table.

[0055] Furthermore, the creating of the link address, calling the calculation function and the operation address according to the link address, and obtaining the embodied carbon calculation result includes:

[0056] Create a link address, call the operation address according to the link address to obtain the corresponding target data, calculate the target data according to the measurement function, generate a measurement result, and return the measurement result through the link address.

[0057] From the above description, it can be seen that the measurement method includes a function definition module and a calculation operation module. The function call program based on the Excel table creates a link address, and the integration of various modules of the measurement method is realized through the link address.

[0058] Please refer to Figure 8Another embodiment of the present invention provides an Excel-based embodied carbon calculation terminal, comprising a memory, a processor, and a computer program stored in the memory and running on the processor. When the processor executes the computer program, the following steps are implemented:

[0059] Obtaining the measurement rules for embodied carbon;

[0060] Obtaining a data list of embodied carbon and target data, converting the target data into a table structure according to the data list of embodied carbon, and generating basic parameters based on the table structure;

[0061] Defining a calculation function and a calculation address of the calculation function in an Excel sheet according to the embodied carbon calculation rules and the basic parameters;

[0062] A link address is created, and the calculation function and the operation address are called according to the link address to obtain the calculation result of the embodied carbon.

[0063] From the above description, it can be seen that the beneficial effects of the present invention are: the target data are summarized and organized through the embodied carbon measurement rules, and the data that is originally of a large order of magnitude is simplified to form corresponding basic parameters, without the need for manual data organization and measurement, thus reducing the measurement steps; in the later process of calculating the function, the basic parameters are directly called for calculation to achieve quick calculation of the embodied carbon on the production side and consumption side of the target data. This measurement method allows even managers who are not familiar with the principles of the embodied carbon measurement method to quickly perform calculations through the preset basic parameters and the operational relationships contained in the calculation function, which helps to bring practical and effective convenience to the regional embodied carbon calculation work and greatly improves the work efficiency of users.

[0064] Furthermore, the embodied carbon calculation rules include production-side carbon calculation rules and consumption-side carbon calculation rules;

[0065] The calculation rules for obtaining embodied carbon include:

[0066] Obtain the production-side carbon measurement rules and the consumption-side carbon measurement rules respectively;

[0067] Construct the production-side carbon emission function according to the production-side carbon measurement rules:

[0068] Production-side carbon emissions = regional demand carbon emissions + carbon emissions caused by outflow of intermediate products + carbon emissions caused by outflow of final products + embodied carbon in exports;

[0069] According to the consumption-side carbon measurement rules, the consumption-side carbon emission function is constructed:

[0070] Consumption-side carbon emissions = regional carbon emissions + carbon emissions caused by the inflow of intermediate products + carbon emissions caused by the inflow of final products + carbon embodied in imports.

[0071] As can be seen from the above description, based on the principle of embodied carbon measurement, data is organized and defined in advance, and operational relationships between the data are created. In the subsequent calculation process, even managers who are unfamiliar with the measurement principles can directly call functions through clear operational rules to achieve rapid measurement, thereby improving the efficiency of the measurement work and reducing labor costs.

[0072] Furthermore, the data inventory of embodied carbon includes a multi-region input-output model, an energy inventory, and a carbon emission inventory;

[0073] The step of obtaining a data list of embodied carbon and target data, converting the target data into a table structure according to the data list of embodied carbon, and generating basic parameters based on the table structure includes:

[0074] Obtain a data list of embodied carbon and preset the cell addresses corresponding to different data lists based on an Excel table;

[0075] Acquiring target data, creating a first operation rule between the target data according to the embodied carbon measurement rule, and presetting a plurality of basic parameter functions based on the first operation rule;

[0076] Classifying the target data according to the data list and storing the data in the cell addresses of the corresponding data list, and generating a multi-region input-output table, an energy data table, and a carbon emission data table respectively;

[0077] An address function for constructing a basic parameter is constructed by calling the cell address corresponding to the target data based on the basic parameter function;

[0078] The target data in the corresponding table structure is obtained according to the address function and calculated to obtain basic parameters.

[0079] From the above description, it can be seen that based on the embodied carbon measurement rules, regional input-output analysis generally draws on the characteristics of the interdependence of economic activities from equilibrium theory. Therefore, based on the regional input-output table model, the mathematical form of algebraic simultaneous equations is used to describe this interdependent relationship, thereby simplifying the data relationship and intuitively obtaining some basic parameters, which is convenient for subsequent data research and analysis and observation data; in addition, the calculation process of embodied carbon also involves data from other data lists, so the amount of data involved in the measurement process is very large. The present invention is based on the query and calculation functions of Excel tables to simplify the data into different basic parameters, thereby improving the measurement efficiency, and the calculation method is simple and fast.

[0080] Furthermore, the calculation function defined according to the embodied carbon calculation rules and the basic parameters and the calculation address of the calculation function in the Excel table include:

[0081] creating a second operational relationship between the basic parameters according to the embodied carbon calculation rule, constructing a calculation function based on the second operational relationship, and defining the calculation functions respectively;

[0082] The calculation address of the measurement function is defined based on an Excel table.

[0083] From the above description, it can be seen that the present invention normalizes the calculation method of target data and gathers similar data to form multiple basic parameters. In the measurement function, batch calculation of similar target data can be achieved only by creating the operation relationship between the basic parameters, which greatly reduces the data level of the calculation process and effectively improves the measurement efficiency. At the same time, the operation address of the measurement function is defined, and the modularization of the measurement method is realized based on the Excel table.

[0084] Furthermore, the creating of the link address, calling the calculation function and the operation address according to the link address, and obtaining the embodied carbon calculation result includes:

[0085] Create a link address, call the operation address according to the link address to obtain the corresponding target data, calculate the target data according to the measurement function, generate a measurement result, and return the measurement result through the link address.

[0086] From the above description, it can be seen that the measurement method includes a function definition module and a calculation operation module. The function call program based on the Excel table creates a link address, and the integration of various modules of the measurement method is realized through the link address.

[0087] An Excel-based embodied carbon calculation method and terminal can be applied to the rapid calculation of embodied carbon measurement data. The method automatically nests calculation formulas in the embodied carbon measurement process based on the Excel table, thereby improving the accuracy of the calculation results. The following is an illustration of a specific embodiment:

[0088] Please refer to Figure 1 , embodiment 1 of the present invention is:

[0089] An Excel-based method for calculating embodied carbon includes the following steps:

[0090] S1. Obtain the calculation rules for embodied carbon.

[0091] Specifically, the embodied carbon calculation rules include production-side carbon calculation rules and consumption-side carbon calculation rules;

[0092] Said S1 comprises:

[0093] S11. Obtain the production-side carbon measurement rules and the consumption-side carbon measurement rules respectively;

[0094] S12. Construct a production-side carbon emission function according to the production-side carbon measurement rules:

[0095] Production-side carbon emissions = regional demand carbon emissions + carbon emissions caused by outflow of intermediate products + carbon emissions caused by outflow of final products + embodied carbon in exports;

[0096] S13. Construct a consumption-side carbon emission function according to the consumption-side carbon measurement rule:

[0097] Consumption-side carbon emissions = regional carbon emissions + carbon emissions caused by the inflow of intermediate products + carbon emissions caused by the inflow of final products + carbon embodied in imports.

[0098] It should be noted that the embodied carbon calculation rules, namely the calculation principles and related formulas, are used by those skilled in the art to pre-organize, summarize, and calculate the relevant calculation formulas, thereby constructing a corresponding calculation function. This function can then automatically and accurately calculate the embodied carbon content for technicians unfamiliar with the principles, eliminating the need for them to spend excessive time learning relevant knowledge and reducing labor costs.

[0099] S2. Obtain a data list of embodied carbon and target data, convert the target data into a table structure according to the data list of embodied carbon, and generate basic parameters based on the table structure.

[0100] Specifically, the data inventory of embodied carbon includes a multi-region input-output model, an energy inventory, and a carbon emission inventory;

[0101] The S2 includes:

[0102] S21. Obtain a data list of embodied carbon, and preset cell addresses corresponding to different data lists based on an Excel table;

[0103] S22. Acquire target data, create a first operation rule between the target data according to the embodied carbon measurement rule, and preset multiple basic parameter functions based on the first operation rule;

[0104] S23. Classify the target data according to the data list and store them in the cell addresses of the corresponding data list, and generate a multi-region input-output table, an energy data table, and a carbon emission data table respectively;

[0105] S24, constructing an address function of basic parameters by calling the cell address corresponding to the target data based on the basic parameter function;

[0106] S25. Obtain the target data in the corresponding table structure according to the address function and perform calculation to obtain basic parameters.

[0107] It should be noted that the data list is the type of data required for embodied carbon calculation; the multi-regional input-output model is the framework of the multi-regional input-output table. The target data is the original regional data for embodied carbon calculation. The multi-regional input-output table, energy data table, and carbon emissions data table constitute the table structure. The present invention stores the target data in the cell address of the corresponding data list to generate the corresponding table structure. By establishing an address function based on the table structure, data classification and calculation can be automatically performed during the data input process, thereby improving work efficiency.

[0108] S3. Define a calculation function and an operation address of the calculation function in an Excel table according to the calculation rules of the embodied carbon and the basic parameters.

[0109] Specifically, the S3 includes:

[0110] S31. Creating a second operational relationship between the basic parameters according to the embodied carbon calculation rule, constructing a calculation function based on the second operational relationship, and defining the calculation functions respectively;

[0111] S32. Define the calculation address of the measurement function based on an Excel table.

[0112] It should be noted that in step S2, the calculation of basic parameters is implemented based on the data structure of the Excel table, thereby realizing the first level of formula nesting in the embodied carbon calculation step; after obtaining the basic parameters, the calculation function between the basic parameters is established again, thereby realizing the second level of formula nesting in the embodied carbon calculation step.

[0113] S4. Create a link address, call the calculation function and the operation address according to the link address, and obtain the calculation result of the embodied carbon.

[0114] Specifically, the S4 includes:

[0115] S41. Create a link address, call the operation address according to the link address to obtain the corresponding target data, calculate the target data according to the measurement function, generate a measurement result, and return the measurement result through the link address.

[0116] In this embodiment, the step S1 further includes:

[0117] S5. Construct a system module based on an Excel table, wherein the system module includes an operation guidance module, a basic parameter input module, a calculation module, and a result output module.

[0118] The operational guidance module is used by system users to query the operational process and step S4. It includes system operational instructions, regional and industry code descriptions, and notes on relevant calculation content. System users access the operational guidance module by reading the pre-set embodied carbon calculation system file. Within this module, users can navigate to other modules and their corresponding interfaces by clicking pre-set links within the interface.

[0119] The basic parameter input module is used to implement the steps S21 and S23; in an optional embodiment, the data form of the basic parameters is a matrix,

[0120] The calculation module is used to implement the steps S22, S24 and S25; the acquisition of basic parameters is implemented in the calculation module.

[0121] The result output module is used to implement step S3; that is, presetting the calculation function and operation address according to the embodied carbon calculation rules to automatically calculate the embodied carbon data.

[0122] Please refer to Figures 2 to 4 , the second embodiment of the present invention is:

[0123] A specific implementation of an Excel spreadsheet-based embodied carbon calculation method in Excel;

[0124] S1. Construct a system module based on an Excel table, wherein the system module includes an operation guidance module, a basic parameter input module, a calculation module, and a result output module.

[0125] In this embodiment, the operation guidance module includes "operation steps, number descriptions, and related content prompts." The operation steps include "locking the target area, entering original data, and querying calculation results." The operation steps display the key steps of the system operation to the system user in the form of notes and related links. Users can click on the relevant links to perform corresponding quick operations. The number descriptions mainly define the number of provinces and industries. The related content prompts show the specific variable operation implementation process of the system, and the prompts allow data calibration of related variables.

[0126] The basic parameters include Xrs, Yrs, EX, IM, A, L, Lrr and a; among them, Xrs represents the intermediate products input by region r to region s; Yrs represents the final products input by region r to region s; EX represents the exports of region r; IM represents the imports from foreign countries to region r; A represents the amount of intermediate inputs of the consumption department required for the unit output of department j (that is, the direct consumption coefficient matrix defined in the multi-regional input-output model); L represents the complete consumption relationship of the production activities of each region (that is, the Leontief inverse matrix defined in the multi-regional input-output model); Lrr represents the complete consumption relationship of the production activities of region r (that is, the Leontief inverse matrix of region r defined in the multi-regional input-output model); a represents a diagonal matrix with the carbon dioxide emissions of the total unit output of each production department in the province as elements.

[0127] The result output module includes a calculation function for the embodied carbon on the production side and a calculation function for the embodied carbon on the consumption side.

[0128] S2. Obtain production-side carbon calculation rules and consumption-side carbon calculation rules respectively; construct a production-side carbon emission function according to the production-side carbon calculation rules, and construct a consumption-side carbon emission function according to the consumption-side carbon calculation rules.

[0129] In this embodiment, ① Provincial production-side carbon emissions calculation rules:

[0130] Defining CI r is a diagonal matrix whose elements are the CO2 emissions per unit of total output of each production sector in province r, and its elements are the ratios of direct carbon emissions to total output in province r. The column vector of production-side carbon emissions in province r is:

[0131]

[0132] In formula (1), They represent carbon emissions caused by the outflow of intermediate products and carbon emissions caused by the outflow of final products; CI r L rr Y rr represents domestic carbon emissions; CI r L rr EX r In summary, the carbon emission function of the production side of province r is:

[0133]

[0134] ② Provincial consumption-side carbon emissions calculation rules:

[0135] Provincial consumption-side carbon emissions are the carbon emissions caused by the total demand in province r. The formula can be expressed as:

[0136]

[0137] In formula (3), Y r It represents the total demand of province r, including intermediate products and final products produced within and outside the province to meet the final demand of province r, as well as the demand for foreign countries imported through international trade.

[0138] The expression of carbon emission on the consumption side of province r is:

[0139]

[0140] Among them, CI r Y rr The direct carbon emissions within the province that meet the final demand of the province r refer to the direct carbon emissions produced within the province and used to meet the final demand of the province. represent carbon emissions caused by the inflow of intermediate products and carbon emissions caused by the inflow of final products; CI r L rr IM r represents the embodied carbon in imports. In summary, the consumption-side carbon emission function of province r is:

[0141]

[0142] S3. Implement the following steps in the basic parameter input module:

[0143] S31. Obtain target data and a list of embodied carbon data: Determine the inter-regional embodied carbon data that needs to be measured and download the original data from relevant websites.

[0144] In this embodiment, the basic parameter input module sets a plurality of different matrix tables divided by color blocks based on the data structure of the Excel table, and the matrix table of each color block is the cell address of a basic parameter.

[0145] The multi-region input-output model is specifically as follows:

[0146]

[0147] In formula (6), r and s represent regions, i and j represent departments; m and n represent the total number of regions and departments, respectively; represents the intermediate input of sector i in region r to sector j in region s; represents the final product of sector i in region r that is input to region s; represents the export portion of sector i in region r; Used to adjust the balance between the department's total output and total input.

[0148] Formula (6) means that the total output of sector i in region r is used as the sum of the intermediate products, final products and imports of all sectors in other regions. It can be expressed in matrix form as:

[0149]

[0150] In formula (7), X r represents the total output column vector of each department in region r; the block matrix A represents the overall production system, and the submatrix A rr A represents the mutual demand between production departments in region r, rs represents the direct consumption coefficient matrix of region r on the intermediate product input of region s; the Y matrix represents the final demand of each region, Y rs The column vector representing the products produced in region r to meet the final demand in region s; EX r A column vector representing product exports of region r.

[0151] S32. Preset cell addresses corresponding to different data lists based on an Excel table, classify the target data according to the data lists, and store the data in the cell addresses corresponding to the data lists, thereby generating a multi-region input-output table, an energy data table, and a carbon emission data table respectively:

[0152] Reference Figure 4 Taking the multi-region input-output table as an example, fill in the data in the color-block marked areas of the table based on the downloaded target data. Specifically, enter the intermediate product data (X) in the matrix at cell address "E5:AIX934", the initial input product data (V) in the matrix at cell address "E937:AIX940", the final product raw data (Y) in the matrix at cell address "AIZ5:AOX934", the import input data (IM) in cell address "E935:AIX935", and the export usage data (EX) in cell address "AOY5:AOY934". This completes the construction of the multi-region input-output table.

[0153] S33. Create a first operation rule between the target data according to the embodied carbon measurement rule, and preset multiple basic parameter functions based on the first operation rule; call the cell address corresponding to the target data based on the basic parameter function to construct an address function of the basic parameter; obtain the target data in the corresponding table structure according to the address function to perform calculation and obtain basic parameters.

[0154] Specifically, "Xrs" represents the intermediate product input by region r to region s, and its address function is [= basic parameter input module! AI5], where the local intermediate product input matrix is ​​a zero matrix, and the final address function of the Xrs column vector is [= SUM (AI5: AIX5)];

[0155] "Yrs" represents the final product of region r's input to region s, and its address function is [= basic parameter input module! AIZ5], where the local final product input matrix is ​​a zero matrix, and the final address function of the Yrs column vector is [= SUM(E5:FC5)];

[0156] "Yrr" represents the final product of local production inputs in region r, and its address function is [=SUM(basic parameter input module!AIZ5:AJD5)];

[0157] "EX" indicates the exit of region r, and its address function is [= basic parameter input module! AOY5];

[0158] "IM" represents foreign imports to region r. This process requires calling the TRANSPOSE(array) function to transpose the row vector. Its address function is [= basic parameter input module! TRANSPOSE(E935:AIX935)];

[0159] “A” represents the direct consumption coefficient matrix, specifically the amount of intermediate input from department i required to produce unit output from department j. Its address function is [= basic parameter input module! E5 / basic parameter input module! $E$942]

[0160] "L" represents the inverse Leontief matrix, which specifically represents the complete consumption relationship of production activities in each region (L = (IA) - 1). This process requires calling the MINVERSE(array) function to invert the matrix. At the same time, according to the principle of the Leontief calculation formula, it is necessary to create an identity matrix for auxiliary calculation. Therefore, the address function of the L interface is [MINVERSE(I!-calculation module-A!)];

[0161] "Lrr" represents the inverse Leontief matrix for region r, represented by the diagonal matrix of the inverse Leontief matrix L. Given that the calculation results using the diagonal matrix of the industry-level inverse Leontief matrix differ significantly from existing research results, the calculation here uses the diagonal matrix of the provincial-level inverse Leontief matrix. When system users calculate carbon emission coefficients, they must calibrate the data based on their specific circumstances.

[0162] "CI" stands for carbon emission coefficient, specifically a diagonal matrix whose elements are the CO2 emissions per unit of output for each production sector in region r. Given that the basic data on direct carbon emissions by industry in each province calculated by the CEADs research team may not match the data from the China Multi-Region Industry Input-Output Table (MRIO), for example, if the output of a particular industry in a province is zero but the carbon emissions data is not zero, or if the industry-specific carbon emission coefficient calculated from these two sets of data deviates significantly from the actual situation, the average direct carbon emission coefficient for each province is used for calculation. When system users calculate carbon emission coefficients, they must calibrate the data based on their specific circumstances.

[0163] S4. Implement the following steps in the result output module: create a second operation relationship between the basic parameters according to the embodied carbon measurement rules, construct a measurement function based on the second operation relationship, and define the measurement function and the operation address of the measurement function respectively.

[0164] Specifically, in the structural composition of embodied carbon on the production side, the second operational relationship for local carbon emissions is [='calculation module-CI'! E4*'calculation module-Lrr'! E4*'calculation module-Yrr'! D2], the second operational relationship for carbon emissions caused by the outflow of intermediate products is [='calculation module-CI'! E4*'calculation module-Lrr'! E4*'calculation module-Xrs'! AIY5], the second operational relationship for embodied carbon in final demand is [='calculation module-CI'! E4*'calculation module-Lrr'! E4*'calculation module-Yrs'! FD5], and the second operational relationship for embodied carbon in exports is [='calculation module-CI'! E4*'calculation module-Lrr'! E4*'calculation module-EX'! E3]. The second operational relationship for production-side carbon emissions by region and sector is [=SUM(D2:G2)], and the calculation function for overall provincial production-side carbon emissions is [=SUM(H2:H31)].

[0165] In the structural composition of embodied carbon on the consumption side, the second operational relationship for local carbon emissions is [='calculation module-CI'! E4*'calculation module-Lrr'! E4*'calculation module-Yrr'! D2]; the second operational relationship for carbon emissions due to the inflow of intermediate products is [='calculation module-MP'! DCQ4]; the second operational relationship for carbon emissions due to the inflow of final products is [='calculation module-FP'! DH4]; the second operational relationship for embodied carbon in exports is [='calculation module-CI'! E4*'calculation module-Lrr'! E4*'calculation module-IM'! E3]; the second operational relationship for production-side carbon emissions by region and sector is [=SUM(D2:G2)]; and the calculation function for overall provincial production-side carbon emissions is [=SUM(H2:H31)].

[0166] S5. Call the result output module through the link address of the running guidance module to return the measurement result.

[0167] Specifically, click the CEproduce link to query the calculated results of production-side carbon emissions, and click the CEconduct link to query the calculated results of consumption-side carbon emissions. The CEproduce link includes local carbon emissions, carbon emissions caused by the outflow of intermediate products, the embodied carbon in final demand, the embodied carbon in exports, production-side carbon emissions by region and sector, and the overall production-side carbon emissions of the province, and a visual bar chart of provincial production-side carbon emissions can be seen on this basis. The CEconduct link includes local carbon emissions, carbon emissions caused by the inflow of intermediate products, carbon emissions caused by the inflow of final products, the embodied carbon in imports, consumption-side carbon emissions by region and sector, and the overall consumption-side carbon emissions of the province, and a visual bar chart of provincial consumption-side carbon emissions can be seen on this basis.

[0168] Please refer to Figures 5 to 7 , the third embodiment of the present invention is:

[0169] An Excel-based embodied carbon calculation method is applied in real-world scenarios;

[0170] Based on China's multi-regional input-output data, energy inventory data and carbon emission data in 2017, first call the basic parameter input module in the system operation guide interface to fill the original data into the corresponding color blocks, and then call the calculation result output interface in the system operation guide interface to display the calculation results.

[0171] It should be noted that replacing the original data of this method with the regional embodied carbon calculations of other specified years, other designated regions and industries can also achieve the embodied carbon measurement of the target region and target year.

[0172] First, data description:

[0173] Based on the principle of regional embodied carbon calculation, the basic parameters involved in the embodied carbon calculation function of this embodiment are described as follows:

[0174] (1) The intermediate product matrix X represents the intermediate input of sector i in region r to sector j in region s;

[0175] (2) Final product matrix Y, which represents the final products provided by department i in region r to department j in region s;

[0176] (3) Export EX, which represents the export of sector i in region r;

[0177] (4) Imports IM, which represents the imports of foreign sector i to sector j in region r;

[0178] (5) The direct consumption coefficient matrix A represents the amount of intermediate input from department i that is consumed by the unit output of department j. The calculation formula is:

[0179] (6) The Leontief inverse matrix L represents the complete consumption relationship of production activities in region r. The calculation formula is L = (IA) -1 ;

[0180] (7) Carbon emission coefficient vector, a diagonal matrix with the total CO2 emissions per unit output of each production sector in province r as its elements, whose elements ic r is the ratio of direct carbon emissions to total output of province r.

[0181] Considering the availability of data and the validity of inter-regional carbon emission accounting data, the original data of this embodiment is calculated using the 2017 China Multi-Region Input-Output Table, the 2017 Energy Inventory, and the 2017 Carbon Emission Inventory.

[0182] Second, specific steps:

[0183] S1. In the system operation guide module, call the basic parameter input module and input the original data of the 2017 China Multi-Region Input-Output Table into the corresponding color block by copying and pasting. Figure 6 As shown in the figure, different color blocks represent the basic parameters of different matrices. Specifically, the purple block shows the intermediate product data of 31 provinces and 30 industries (X matrix), the yellow block shows the final product data of 31 provinces and 30 industries (Y matrix), the blue block shows the export data of 31 provinces and 30 industries (EX column vector), the gray block shows the import data of 31 provinces and 30 industries (IM row vector), and the orange block shows the value-added data of 31 provinces and 30 industries (V matrix).

[0184] S2. Call the result output module through the link address in the system operation guidance module to return the measurement result, such as Figures 6 and 7 shown.

[0185] Please refer to Figure 8 , the fourth embodiment of the present invention is:

[0186] An Excel-based embodied carbon calculation terminal 1 includes a memory 2, a processor 3, and a computer program stored in the memory 2 and running on the processor 3. When the processor 3 executes the computer program, each step in Examples 1 to 3 is implemented.

[0187] In summary, the present invention provides an Excel-based embodied carbon calculation method and terminal, which summarizes and organizes target data through embodied carbon calculation rules, and simplifies the original large-scale data into corresponding basic parameters, eliminating the need for manual data organization and calculation, thereby reducing the calculation steps; in the later stage of the calculation function, the basic parameters are directly called for calculation to achieve quick calculation of the embodied carbon on the production and consumption sides of the target data. The calculation formula nesting and calculation in the embodied carbon calculation process are automatically realized based on the data structure of the Excel table. This calculation method allows even managers who are not familiar with the principles of the embodied carbon calculation method to quickly realize the calculation work through the preset basic parameters and the operational relationships contained in the calculation function, and the accuracy of the calculation results is high, which helps to bring practical and effective convenience to the regional embodied carbon calculation work and greatly improves the work efficiency of users.

[0188] The above descriptions are merely embodiments of the present invention and are not intended to limit the patent scope of the present invention. Any equivalent transformations made using the contents of the present invention's description and drawings, or directly or indirectly applied in related technical fields, are also included in the patent protection scope of the present invention.

Claims

1. A method for calculating embodied carbon based on an Excel table, characterized in that: Including steps: Obtaining the measurement rules for embodied carbon; Obtaining a data list of embodied carbon and target data, converting the target data into a table structure according to the data list of embodied carbon, and generating basic parameters based on the table structure; Defining a calculation function and a calculation address of the calculation function in an Excel sheet according to the embodied carbon calculation rules and the basic parameters; Creating a link address, calling the calculation function and the operation address according to the link address, and obtaining the embodied carbon calculation result; The embodied carbon calculation rules include production-side carbon calculation rules and consumption-side carbon calculation rules; The calculation rules for obtaining embodied carbon include: Obtain the production-side carbon measurement rules and the consumption-side carbon measurement rules respectively; Construct the production-side carbon emission function according to the production-side carbon measurement rules: Production-side carbon emissions = regional demand carbon emissions + carbon emissions caused by outflow of intermediate products + carbon emissions caused by outflow of final products + embodied carbon in exports; According to the consumption-side carbon measurement rules, the consumption-side carbon emission function is constructed: Consumption-side carbon emissions = regional carbon emissions + carbon emissions caused by the inflow of intermediate products + carbon emissions caused by the inflow of final products + carbon embodied in imports; The data inventory of embodied carbon includes a multi-region input-output model, an energy inventory, and a carbon emissions inventory; The step of obtaining a data list of embodied carbon and target data, converting the target data into a table structure according to the data list of embodied carbon, and generating basic parameters based on the table structure includes: Obtain a data list of embodied carbon and preset the cell addresses corresponding to different data lists based on an Excel table; Acquiring target data, creating a first operation rule between the target data according to the embodied carbon measurement rule, and presetting a plurality of basic parameter functions based on the first operation rule; Classifying the target data according to the data list and storing the data in the cell addresses of the corresponding data list, and generating a multi-region input-output table, an energy data table, and a carbon emission data table respectively; An address function for constructing a basic parameter is constructed by calling the cell address corresponding to the target data based on the basic parameter function; Obtain the target data in the corresponding table structure according to the address function and perform calculation to obtain basic parameters; The calculation function defined according to the embodied carbon calculation rules and the basic parameters and the calculation address of the calculation function in the Excel table include: creating a second operational relationship between the basic parameters according to the embodied carbon calculation rule, constructing a calculation function based on the second operational relationship, and defining the calculation functions respectively; The calculation address of the measurement function is defined based on an Excel table.

2. The method for calculating embodied carbon based on an Excel table according to claim 1, characterized in that: The creating of the link address, calling the calculation function and the operation address according to the link address, and obtaining the embodied carbon calculation result includes: Create a link address, call the operation address according to the link address to obtain the corresponding target data, calculate the target data according to the measurement function, generate a measurement result, and return the measurement result through the link address.

3. An Excel-based embodied carbon calculation terminal, comprising a memory, a processor, and a computer program stored in the memory and running on the processor, characterized in that: When the processor executes the computer program, the following steps are implemented: Obtaining the measurement rules for embodied carbon; Obtaining a data list of embodied carbon and target data, converting the target data into a table structure according to the data list of embodied carbon, and generating basic parameters based on the table structure; Defining a calculation function and a calculation address of the calculation function in an Excel sheet according to the embodied carbon calculation rules and the basic parameters; Creating a link address, calling the calculation function and the operation address according to the link address, and obtaining the embodied carbon calculation result; The embodied carbon calculation rules include production-side carbon calculation rules and consumption-side carbon calculation rules; The calculation rules for obtaining embodied carbon include: Obtain the production-side carbon measurement rules and the consumption-side carbon measurement rules respectively; Construct the production-side carbon emission function according to the production-side carbon measurement rules: Production-side carbon emissions = regional demand carbon emissions + carbon emissions caused by outflow of intermediate products + carbon emissions caused by outflow of final products + embodied carbon in exports; According to the consumption-side carbon measurement rules, the consumption-side carbon emission function is constructed: Consumption-side carbon emissions = regional carbon emissions + carbon emissions caused by the inflow of intermediate products + carbon emissions caused by the inflow of final products + carbon embodied in imports; The data inventory of embodied carbon includes a multi-region input-output model, an energy inventory, and a carbon emissions inventory; The step of obtaining a data list of embodied carbon and target data, converting the target data into a table structure according to the data list of embodied carbon, and generating basic parameters based on the table structure includes: Obtain a data list of embodied carbon and preset the cell addresses corresponding to different data lists based on an Excel table; Acquiring target data, creating a first operation rule between the target data according to the embodied carbon measurement rule, and presetting a plurality of basic parameter functions based on the first operation rule; Classifying the target data according to the data list and storing the data in the cell addresses of the corresponding data list, and generating a multi-region input-output table, an energy data table, and a carbon emission data table respectively; An address function for constructing a basic parameter is constructed by calling the cell address corresponding to the target data based on the basic parameter function; Obtain the target data in the corresponding table structure according to the address function and perform calculation to obtain basic parameters; The calculation function defined according to the embodied carbon calculation rules and the basic parameters and the calculation address of the calculation function in the Excel table include: creating a second operational relationship between the basic parameters according to the embodied carbon calculation rule, constructing a calculation function based on the second operational relationship, and defining the calculation functions respectively; The calculation address of the measurement function is defined based on an Excel table.

4. The Excel-based embodied carbon calculation terminal according to claim 3, characterized in that: The creating of the link address, calling the calculation function and the operation address according to the link address, and obtaining the embodied carbon calculation result includes: Create a link address, call the operation address according to the link address to obtain the corresponding target data, calculate the target data according to the measurement function, generate a measurement result, and return the measurement result through the link address.

Images