Electric power spot market clearing result analysis report template design method, system and device and storage medium

Abstract

The invention discloses an electric power spot market clearing result analysis report template design method, system and device, and a storage medium, and relates to the technical field of electric power spot market data processing, and the method comprises the steps: selecting indexes according to electric power spot market supervision requirements and business demands, and forming a list; designing a template file and placeholder mapping table based on the index list; processing and analyzing the data to obtain a cleaned data set and an index calculation result; filling the result into the template to obtain a semi-finished product report; converting into a standardized report and outputting visualization; according to the method, the problems of subjectivity and hysteresis of traditional manual index selection are solved, so that the same template can adapt to the requirements of different market scenes, and the template reuse rate is greatly improved; the reliability of analysis of the clearing result of the electric power spot market is ensured, so that electricity price calculation is optimized, the market fairness is enhanced, and the operation risk is reduced.

Description

Technical Field

[0001] The present invention relates to the technical field of power spot market data processing, and in particular to a power spot market clearing result analysis report template design method, system, device and storage medium. Background Art

[0002] The emergence of the electricity spot market aims to address challenges such as imbalanced electricity supply and demand and price fluctuations. Through market mechanisms, it aims to regulate supply and demand, optimize resource allocation, rationalize pricing, enhance market transparency and competitiveness, and promote the development of the power industry. However, the complexity and uncertainty of electricity supply and demand often lead to abnormalities in the market, such as supply disruptions, sudden demand fluctuations, and equipment failures. These conditions seriously impact the normal operation of the market and the balance between supply and demand, and even threaten the stability and security of the power system.

[0003] Currently, processing electricity spot market clearing results primarily relies on dispatchers. Dispatchers must confirm information via phone calls and perform manual calculations based on dispersed data sources. This approach has significant drawbacks: First, the cumbersome process of phone calls and manual calculations leads to delayed responses, making it difficult to respond to unexpected situations. Second, the dispersed data sources make information coordination difficult, prone to inconsistent or incomplete information, and ultimately lead to low resource utilization and inefficient processing of market clearing results. Summary of the Invention

[0004] In view of the above-mentioned problems, the present invention is proposed.

[0005] Therefore, the technical problem solved by the present invention is: to solve the problem that abnormal situations caused by complex and uncertain supply and demand in the electricity market reform affect market operation and supply and demand balance, and the current manual processing method has problems such as response delay, and to design a clearing result analysis report template to quickly generate reports, improve supervision efficiency and ensure stable market supply and demand balance.

[0006] In order to solve the above technical problems, the present invention provides the following technical solutions:

[0007] In a first aspect, an embodiment of the present invention provides a method for designing a template for an electricity spot market clearing result analysis report, comprising:

[0008] Based on the regulatory requirements and business needs of the electricity spot market, select indicators that reflect the market operation status and form an indicator list;

[0009] Design template files and placeholder mapping tables based on the indicator list;

[0010] Based on the indicator list and placeholder mapping table, the data to be processed is processed and analyzed to obtain the cleaned data set and indicator calculation results;

[0011] Fill the indicator calculation results into the template file to obtain a semi-finished report;

[0012] Convert semi-finished reports into standardized reports, and output and visualize standardized reports.

[0013] As a preferred solution for the design of a template for the analysis report on the clearing results of the electricity spot market, the following are the solutions:

[0014] The indicators selected to reflect the market operation status form an indicator list including:

[0015] Based on the regulatory requirements and business needs of the electricity spot market, indicators reflecting the market operation status are selected, including market efficiency indicators, system security indicators and market structure indicators; the indicator list includes indicator names, calculation formulas and data sources.

[0016] As a preferred solution for the design of a template for the analysis report on the clearing results of the electricity spot market, the following are the solutions:

[0017] The aforementioned selection of indicators reflecting the market operation status, forming an indicator list, also includes:

[0018] Natural language processing technology is used to automatically identify key indicators of the electricity spot clearing market. Specifically, by analyzing historical files and business requirements documents, high-frequency words and related indicators are automatically extracted.

[0019] The beneficial effects of this preferred technical solution are: using natural language processing technology to automatically identify key indicators of the electricity spot clearing market, extracting high-frequency words and related indicators by analyzing historical files and business requirements documents, and being able to quickly and accurately mine key indicators from large amounts of text information, thereby improving the efficiency and accuracy of indicator selection and reducing the workload and errors of manual screening.

[0020] As a preferred solution for the design of a template for the analysis report on the clearing results of the electricity spot market, the following are the solutions:

[0021] The indicator list-based design template file and placeholder mapping table include:

[0022] Based on the indicator list and business areas, the report is divided into multiple chapters, and a market-chapter type mapping relationship table is established to define the chapters that need to be included in different types of markets. The chapters are organized in a tree structure that supports multi-level nesting.

[0023] As a preferred solution for the design of a template for the analysis report on the clearing results of the electricity spot market, the following are the solutions:

[0024] The indicator list-based design template file and placeholder mapping table also include:

[0025] Design template files and insert placeholders into them for dynamic filling of data, charts and text;

[0026] Design placeholder mappings based on the indicator data in the indicator list to fill in data for various scenarios; the placeholders include data placeholders, chart placeholders, and text placeholders.

[0027] The beneficial effects of this preferred technical solution are: inserting data, charts and text placeholders into the template file, and designing placeholder mappings based on indicator data to fill in data for various scenarios, thereby realizing dynamic filling of report content, improving the flexibility and adaptability of report generation, and being able to meet the needs of different data and scenarios.

[0028] As a preferred solution for the design of a template for the analysis report on the clearing results of the electricity spot market, the following are the solutions:

[0029] The data to be processed is processed and analyzed to obtain a cleaned data set and indicator calculation results, including:

[0030] Extract raw data from the database according to template placeholder requirements;

[0031] The extracted raw data is cleaned, indicators are calculated based on the indicator list, and structured data is generated.

[0032] As a preferred solution for the design of a template for the analysis report on the clearing results of the electricity spot market, the following are the solutions:

[0033] The indicator calculation results are filled into the template file to obtain a semi-finished report including:

[0034] Read the template file, locate all placeholders, and fill the structured data calculated by the indicator into the corresponding positions according to the placeholder indicator mapping table. When there is no corresponding fill value, use the default value for filling.

[0035] The beneficial effects of this preferred technical solution are: reading the template file to locate the placeholder, filling in the structured data according to the mapping table, and using the default value when there is no filled value, thereby ensuring the integrity and continuity of the report content, avoiding incomplete reports due to missing data, and improving the automation and reliability of report generation.

[0036] In a second aspect, an embodiment of the present invention provides a system for designing a template for an analysis report on a power spot market clearing result, including:

[0037] The indicator list construction module is used to select indicators that reflect the market operation status according to the regulatory requirements and business needs of the electricity spot market and form an indicator list;

[0038] Template file design module, used to design template files and placeholder mapping tables based on the indicator list;

[0039] The data processing and analysis module is used to process and analyze the data to be processed based on the indicator list and placeholder mapping table to obtain the cleaned data set and indicator calculation results;

[0040] A semi-finished product report generation module is used to fill the indicator calculation results into the template file to obtain a semi-finished product report;

[0041] The report output module is used to convert semi-finished product reports into standardized reports, and output and visualize the standardized reports.

[0042] In a third aspect, an embodiment of the present invention provides an electronic device, including:

[0043] memory and processor;

[0044] The memory is used to store computer-executable instructions, and the processor is used to execute the computer-executable instructions. When the one or more programs are executed by the one or more processors, the one or more processors implement the method for designing a template for an analysis report on electricity spot market clearing results as described in any embodiment of the present invention.

[0045] In a fourth aspect, an embodiment of the present invention provides a computer-readable storage medium storing computer-executable instructions, which, when executed by a processor, implement the method for designing a template for an analysis report on electricity spot market clearing results.

[0046] Beneficial effects of the present invention: The present invention automatically parses historical files and business requirement documents through NLP technology, establishes a dynamic indicator library, and solves the subjectivity and lag problems of traditional manual selection of indicators; at the same time, the innovative placeholder mapping relationship design and template adaptive mechanism enable the same template to adapt to the needs of different market scenarios, greatly improving the template reuse rate; in addition, the application of abnormal error data self-repair algorithm, integration of power system topology knowledge graph, and identification of measurement anomalies, so that data processing technology ensures the reliability of power spot market clearing result analysis by improving data integrity and accuracy, thereby optimizing electricity price calculation, enhancing market fairness and reducing operational risks. BRIEF DESCRIPTION OF THE DRAWINGS

[0047] In order to more clearly illustrate the technical solutions of the embodiments of the present invention, the following briefly introduces the drawings required for use in the description of the embodiments. Obviously, the drawings described below are only some embodiments of the present invention. For ordinary technicians in this field, other drawings can be obtained based on these drawings without paying any creative labor.

[0048] Figure 1 It is an overall flow chart of the method for designing a template for analyzing the results of the electricity spot market clearing according to the present invention. DETAILED DESCRIPTION

[0049] To make the above-mentioned objects, features, and advantages of the present invention more clearly understood, the following detailed description of the specific embodiments of the present invention is given in conjunction with the accompanying drawings. It is obvious that the described embodiments are only part of the embodiments of the present invention, not all of them. Based on the embodiments of the present invention, all other embodiments obtained by ordinary persons in this field without creative work should fall within the scope of protection of the present invention.

[0050] Example 1, with reference to Figure 1 , which is the first embodiment of the present invention, provides a method for designing a template for an analysis report on a power spot market clearing result, including:

[0051] S1: Based on the regulatory requirements and business needs of the electricity spot market, select indicators that reflect the market operation status and form an indicator list;

[0052] S2: Based on the indicator list, design the template file and placeholder mapping table;

[0053] S3: Based on the indicator list and placeholder mapping table, the data to be processed is processed and analyzed to obtain the cleaned data set and indicator calculation results;

[0054] S4: Fill the indicator calculation results into the template file to obtain a semi-finished report;

[0055] S5: Convert semi-finished product reports into standardized reports, and output and visualize the standardized reports.

[0056] It should be noted that through steps S1-S5, this embodiment automatically generates anomaly analysis reports using a preset template, enabling standardized information collection and planning, rapid response to market changes, and generation of preset standard analysis reports. Based on the pre-defined clearing result report template and associated abnormality judgment logic, the system rapidly generates corresponding clearing result reports, facilitating timely access to information such as the description of the clearing results and the scope of impact, enabling market management agencies to promptly implement measures such as adjusting supply plans and dispatching equipment to ensure normal market operation and a balanced supply and demand of electricity.

[0057] Example 2, reference Figure 1 Table 1 is an embodiment of the present invention, which provides a method for designing a template for an analysis report on a power spot market clearing result based on the previous embodiment, including:

[0058] In this embodiment, the indicators reflecting the market operation status are selected in the above step S1 to form an indicator list including:

[0059] Based on the regulatory requirements and business needs of the electricity spot market, select indicators that reflect the market operation status, including:

[0060] Market efficiency indicators: supply-demand ratio, spot bidding space, and clearing price;

[0061] System safety indicators: system load, system imbalance;

[0062] Market structure indicators: market concentration;

[0063] Create an indicator list (such as JSON or database table structure) including indicator name, calculation formula, and data source.

[0064] For example, the indicator list may be as shown in Table 1:

[0065] Table 1 Example of indicator list

[0066]

[0067]

[0068] It should be noted that in this step, NLP technology is used to automatically identify key indicators of the electricity spot clearing market. By analyzing historical files and business requirements documents, high-frequency words and related indicators are automatically extracted. At the same time, a dynamic weight system for electricity spot clearing market indicators is established to automatically adjust the importance of indicators according to the market development stage and regulatory focus. In addition, an indicator association network diagram is designed to visually display the mutual influence relationship between each indicator, providing an indicator tree reference for further analysis of the electricity spot market clearing results.

[0069] In another possible implementation, other indicators with different focuses can be selected to form a list. For example, considering the environmental factors of the market, the proportion of clean energy (the proportion of renewable energy power generation in total power generation), carbon emission intensity (carbon emissions corresponding to unit power generation), etc. are selected as new indicators. The data source can be statistical data from the energy monitoring system and the environmental protection department. The calculation formulas can be: Clean energy proportion = renewable energy power generation / total power generation; Carbon emission intensity = total carbon emissions / total power generation. Similarly, the detailed information of these indicators is recorded in the database table structure to form a new indicator list.

[0070] In this embodiment, in the above step S2, based on the indicator list, designing the template file and the placeholder mapping table includes:

[0071] The report is divided into multiple chapters based on the indicator list and business areas. A market-chapter type mapping relationship table is established to define the chapters that need to be included in different electricity spot market types (day-ahead / real-time), such as "New Energy" and "Power Flow Analysis". At the same time, a tree structure is used to organize chapters, supporting multi-level nesting. For example, under "New Energy", sub-chapters such as "Photovoltaic" and "Wind Power" can be seen.

[0072] Insert placeholders into the template to dynamically populate data and charts. For example, the data placeholder ${data.power} is used to fill numerical data, the chart placeholder {{chart.priceTrend}} is used to insert a visual chart, and the text placeholder #{text.summary} is used to dynamically generate analytical text. Placeholder-level display conditions are supported: ${showDetail? data.detail:""}, and placeholder pipeline processing is implemented: ${data.volume|numberFormat}.

[0073] It should be noted that an adaptive template engine was developed in this step, which can automatically adjust the template structure according to different electricity spot clearing market types (day-ahead, real-time); in addition, a placeholder mapping was designed based on the number of indicators in S1 to fill in the data of various scenarios.

[0074] In another possible implementation, for the design of template files, templates of different styles can be designed for power markets of different sizes (large, medium, and small). Templates for large markets can focus more on comprehensiveness and professionalism, including more analytical dimensions and detailed data; templates for medium-sized markets can simplify some content and highlight key indicators; templates for small markets can be more concise and clear. In terms of placeholder design, some special placeholders can be added, such as voice prompt placeholders, which are used to provide corresponding prompts when the report is presented in voice form. At the same time, placeholder mappings are designed according to the characteristics of markets of different sizes. For example, small markets may pay more attention to some basic indicators, and placeholder mappings are more inclined to fill in the data of these indicators.

[0075] In this embodiment, the data to be processed in step S3 is processed and analyzed to obtain a cleaned data set and indicator calculation results including:

[0076] Extract raw data from databases (such as clearing result database and market transaction database) according to template placeholder requirements;

[0077] Data cleaning is performed on raw data, including: processing missing values ​​(such as multimodal interpolation and context-aware filling), outliers (such as IQR outlier removal), and format conversion (such as type inference, nested structure analysis, and unit unification);

[0078] Calculate indicators based on the indicator list and generate structured data.

[0079] For example, the template file in S2 is applied to the day-ahead market new energy forecast output ${data.da.power|default}, and the system extracts the original data from the database (usually the day-ahead market data time points are 96 points, such as [31.19,30.41,29.69,28.99,28.25,27.6,26.96,26.35,25.13,23.94,22.8,21.7,19.96,18.34,16.89,15.51,15.3,15.11,14.95,14.86,15.36,15.97,16.6,17.33,17 .04,16.81,16.58,16.37,16.83,17.35,17.96,18.61,18.3,18.05,17.84,17.66,16.24,15.01,13.92,12.88,1 1.35,9.93,8.62,7.5,6.47,5.63,4.95,null,4.33,4.27,4.23,4.21,4.13,4.11,4.14,4.17,4.18,4.2,4.21,4 .31,4.39,4.54,4.7,4.87,4.59,4.37,4.2,4.11,4.19,4.28,4.39,4.52,4.91,5.41,6.08,7.01,7.84,8.79,9.92,11.21,12.33,13.67,15.15,16.8,18.29,19.88,21.49,23.2,24.29,25.46,26.64,27.89,28.53,29.19,29. 94,30.68]); then perform data cleaning. If the data value at the 48th time point is missing and is null, then multi-mode interpolation (mean, median, minimum, maximum, prediction model, and other strategies) can be used to supplement the data value at the 48th time point. For example, the mean interpolation strategy will fill it with 14.414. Because the original data unit of the new energy output forecast in the market today is megawatts, and the template file needs to display the unit of 10,000 kilowatts, the unit unification in the format conversion can be used for calculation and conversion. Finally, structured data is generated based on the calculation results.

[0080] It should be noted that the abnormal data self-repair algorithm developed in this step can identify and correct common data quality problems. At the same time, the indicator calculation pipeline is designed to support distributed parallel computing of complex indicators.

[0081] In this embodiment, in step S4, the indicator calculation results are filled into the template file to obtain a semi-finished report including:

[0082] Read the template file, locate all placeholders, and fill the structured data calculated by the indicator into the corresponding positions according to the placeholder indicator mapping table. It also supports placeholder inheritance and overwriting, allowing child chapters to rewrite the placeholder performance of the parent chapter, and obtain a semi-finished report containing original data and chart placeholders.

[0083] For example, the template file and related placeholders generated in S2 are read, and combined with the cleaned data set in S3, according to the corresponding relationship, such as the predicted output of new energy in the market ${data.da.power|default} and the structured data data.da.power, the relevant "values": [12.45, 15.67, 18.23] are matched for filling and display. If there is no corresponding filling value, "default": [10, 10, 10] will be used for default filling.

[0084] In another possible implementation, differentiated filling can be performed based on different user roles. For market regulators, the focus is on indicators reflecting market fairness and stability; for power company managers, the focus is on indicators related to the company's economic benefits. During the filling process, dynamic judgment logic can be added. For example, when a certain indicator exceeds a certain threshold, it is highlighted with a special color or style to more intuitively focus on important information. Furthermore, for data that requires comparison, comparison charts can be automatically generated for filling.

[0085] In this embodiment, converting the semi-finished product report into a standardized report in step S5 includes:

[0086] Convert the templates in the semi-finished report into formats such as PDF and HTML to ensure cross-platform compatibility; call visualization tools (such as Matplotlib and ECharts) to replace the placeholders with the final chart to obtain a standardized report file (such as PDF).

[0087] It should be noted that in this step, a placeholder intelligent matching algorithm is established to automatically identify the best data display format (table / chart / text).

[0088] In this embodiment, outputting and visualizing the standardized report in step S5 includes:

[0089] Reports are returned via a web interface or API, supporting dynamic interactions (such as filtering time ranges) and highlighting anomalies in the report.

[0090] For example, semi-finished reports are converted into standardized reports using an intelligent layout engine (automatically adjusting pagination according to content density (PDF) or responsive layout (HTML)) and combined with dynamic font optimization (automatically switching to compatible fonts when detecting mixed mathematical formulas / Chinese characters); visual intelligent rendering uses natural language generation technology to automatically write analysis conclusions and recommendations, and develops interactive visualization components to support report users in customizing data views.

[0091] It should be noted that in this step, natural language generation technology is used to automatically write analysis conclusions and recommendations, develop interactive visualization components, and support report users to customize data views.

[0092] Example 3. The above is a schematic scheme of the method for designing a template for an analysis report on the results of clearing the electricity spot market. It should be noted that the technical scheme of the system for designing a template for an analysis report on the results of clearing the electricity spot market and the technical scheme of the method for designing a template for an analysis report on the results of clearing the electricity spot market are based on the same concept. For details not described in detail in the technical scheme of the system for designing a template for an analysis report on the results of clearing the electricity spot market, please refer to the description of the technical scheme of the method for designing a template for an analysis report on the results of clearing the electricity spot market.

[0093] This embodiment also provides a system for designing a template for an analysis report on a power spot market clearing result, including:

[0094] The indicator list construction module is used to select indicators that reflect the market operation status according to the regulatory requirements and business needs of the electricity spot market and form an indicator list;

[0095] Template file design module, used to design template files and placeholder mapping tables based on the indicator list;

[0096] The data processing and analysis module is used to process and analyze the data to be processed based on the indicator list and placeholder mapping table to obtain the cleaned data set and indicator calculation results;

[0097] A semi-finished product report generation module is used to fill the indicator calculation results into the template file to obtain a semi-finished product report;

[0098] The report output module is used to convert semi-finished product reports into standardized reports, and output and visualize the standardized reports.

[0099] This embodiment further provides an electronic device applicable to the case of a method for designing a template for an analysis report on clearing results of a power spot market, including:

[0100] Memory and processor; the memory is used to store computer-executable instructions, and the processor is used to execute computer-executable instructions to implement the electricity spot market clearing result analysis report template design method proposed in the above embodiment.

[0101] This embodiment also provides a storage medium having a computer program stored thereon, which, when executed by a processor, implements the method for designing a template for an analysis report on electricity spot market clearing results as proposed in the above embodiment.

[0102] The storage medium proposed in this embodiment and the electricity spot market clearing result analysis report template design method proposed in the above embodiment belong to the same inventive concept. The technical details not described in detail in this embodiment can be referred to the above embodiment, and this embodiment has the same beneficial effects as the above embodiment.

[0103] It should be noted that the above embodiments are only used to illustrate the technical solutions of the present invention and are not intended to limit the present invention. 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 may be modified or replaced by equivalents without departing from the spirit and scope of the technical solutions of the present invention, which should all be included in the scope of the claims of the present invention.

Claims

1. A method for designing a template for an analysis report on the results of clearing the electricity spot market, characterized in that: include: Based on the regulatory requirements and business needs of the electricity spot market, select indicators that reflect the market operation status and form an indicator list; Design template files and placeholder mapping tables based on the indicator list; Based on the indicator list and placeholder mapping table, the data to be processed is processed and analyzed to obtain the cleaned data set and indicator calculation results; Fill the indicator calculation results into the template file to obtain a semi-finished report; Convert semi-finished reports into standardized reports, and output and visualize standardized reports.

2. The method for designing a template for an analysis report on the clearing results of the electricity spot market according to claim 1, wherein: The indicators selected to reflect the market operation status form an indicator list including: Based on the regulatory requirements and business needs of the electricity spot market, indicators reflecting the market operation status are selected, including market efficiency indicators, system security indicators and market structure indicators; the indicator list includes indicator names, calculation formulas and data sources.

3. The method for designing a template for an analysis report on the clearing results of the electricity spot market according to claim 2, wherein: The aforementioned selection of indicators reflecting the market operation status, forming an indicator list, also includes: Natural language processing technology is used to automatically identify key indicators of the electricity spot clearing market. Specifically, by analyzing historical files and business requirements documents, high-frequency words and related indicators are automatically extracted.

4. The method for designing a template for an analysis report on the clearing results of the electricity spot market according to claim 3, wherein: The indicator list-based design template file and placeholder mapping table include: Based on the indicator list and business areas, the report is divided into multiple chapters, and a market-chapter type mapping relationship table is established to define the chapters that need to be included in different types of markets. The chapters are organized in a tree structure that supports multi-level nesting.

5. The method for designing a template for an analysis report on the results of clearing the electricity spot market according to claim 4, wherein: The indicator list-based design template file and placeholder mapping table also include: Design template files and insert placeholders into them for dynamic filling of data, charts and text; Design placeholder mappings based on the indicator data in the indicator list to fill in data for various scenarios; the placeholders include data placeholders, chart placeholders, and text placeholders.

6. The method for designing a template for an analysis report on the clearing results of the electricity spot market according to claim 5, wherein: The data to be processed is processed and analyzed to obtain a cleaned data set and indicator calculation results, including: Extract raw data from the database according to template placeholder requirements; The extracted raw data is cleaned, indicators are calculated based on the indicator list, and structured data is generated.

7. The method for designing a template for an analysis report on the clearing results of the electricity spot market according to claim 6, wherein: The indicator calculation results are filled into the template file to obtain a semi-finished report including: Read the template file, locate all placeholders, and fill the structured data calculated by the indicator into the corresponding positions according to the placeholder indicator mapping table. When there is no corresponding fill value, use the default value for filling.

8. A system for designing a template for an analysis report on a clearing result of a power spot market, applying the method according to any one of claims 1 to 7, characterized in that: include: The indicator list construction module is used to select indicators that reflect the market operation status according to the regulatory requirements and business needs of the electricity spot market and form an indicator list; Template file design module, used to design template files and placeholder mapping tables based on the indicator list; The data processing and analysis module is used to process and analyze the data to be processed based on the indicator list and placeholder mapping table to obtain the cleaned data set and indicator calculation results; A semi-finished product report generation module is used to fill the indicator calculation results into the template file to obtain a semi-finished product report; The report output module is used to convert semi-finished product reports into standardized reports, and output and visualize the standardized reports.

9. An electronic device comprising: memory and processor; The memory is used to store computer-executable instructions, and the processor is used to execute the computer-executable instructions. When the computer-executable instructions are executed by the processor, the steps of the method according to any one of claims 1 to 7 are implemented.

10. A computer-readable storage medium storing computer-executable instructions, wherein the computer-executable instructions are capable of implementing the steps of the method according to any one of claims 1 to 7 when executed by a processor.

Images