Visual generation method and system for electric power cost analysis report

Abstract

The invention provides a visual generation method and system for an electric power cost analysis report, and the method comprises the steps: obtaining to-be-analyzed data and a to-be-analyzed project, and generating corresponding result data according to the to-be-analyzed data and the to-be-analyzed project; performing data configuration on the result data, and binding a format field for each operation control to obtain a corresponding data configuration file; performing file analysis on the data configuration file according to a field father-child level to generate corresponding chart data; and constructing a visual interface, and carrying out data integration on the chart data and the visual interface to form a corresponding data analysis report. According to the method, the processes of data acquisition, data analysis, chart generation and final report are unified and simplified, and direct application and generation in cost software can be realized.

Description

Technical Field

[0001] The present invention relates to the technical field of data processing, and in particular to a method and system for visually generating an electricity cost analysis report. Background Art

[0002] "Electricity cost analysis report" usually involves the cost assessment, budget planning, investment return analysis and other aspects of the power project. It involves a lot of data analysis and chart presentation.

[0003] Generally, the analysis report is prepared by the staff who extracts data from the power cost-related software, enters it into Excel, performs corresponding statistical analysis, and outputs tables and charts. It is difficult and error-prone to extract data from the software and then convert it into the corresponding Excel data. In addition, the generation process of the tables and charts in the report requires a lot of manpower. Summary of the invention

[0004] Based on this, the purpose of the present invention is to provide a method and system for visually generating an electricity cost analysis report to address the deficiencies in the above-mentioned technology.

[0005] The present invention proposes a method for visually generating an electricity cost analysis report, comprising: Acquire the data to be analyzed and the project to be analyzed, and generate corresponding achievement data according to the data to be analyzed and the project to be analyzed; Performing data configuration on the achievement data, binding a format field to each operation control to obtain a corresponding data configuration file; Parsing the data configuration file according to the parent-child level of the fields to generate corresponding chart data; Construct a visualization interface, and integrate the chart data with the visualization interface to form a corresponding data analysis report.

[0006] Furthermore, the steps of obtaining the data to be analyzed and the project to be analyzed, and generating corresponding achievement data according to the data to be analyzed and the project to be analyzed include: Constructing a description language for engineering cost calculation, and using the description language for engineering cost calculation to generate corresponding data to be analyzed; Performing data conversion on the data to be analyzed based on a preset data conversion requirement to obtain first data containing BCL syntax; The first data is compressed, and the compressed data is summarized to form a corresponding data list.

[0007] Furthermore, the step of configuring the achievement data and binding a format field to each operation control to obtain a corresponding data configuration file includes: Performing data configuration on the achievement data based on a preset file configuration format to obtain corresponding configuration content; A format field is bound to each operation control, and the value of each operation space is matched with the mapping key of the corresponding format field to generate a corresponding data configuration file.

[0008] Furthermore, the step of parsing the data configuration file according to the field parent-child level to generate corresponding chart data includes: Classifying the data configuration file into corresponding parsers according to field parent-child levels, so as to split the data configuration file into multiple categories of generation parameters; Chart generation is performed according to the multiple types of generation parameters and a preset generation engine to obtain corresponding chart data.

[0009] The present invention also provides a visual generation system for an electricity cost analysis report, comprising: A data analysis module, used to obtain the data to be analyzed and the project to be analyzed, and generate corresponding achievement data according to the data to be analyzed and the project to be analyzed; A data configuration module is used to configure the achievement data and bind a format field to each operation control to obtain a corresponding data configuration file; A file parsing module, used to parse the data configuration file according to the field parent-child level to generate corresponding chart data; The data integration module is used to construct a visualization interface and integrate the chart data with the visualization interface to form a corresponding data analysis report.

[0010] Furthermore, the data analysis module includes: A data generation unit, used to construct a description language for engineering cost calculation, and to generate corresponding data to be analyzed using the description language for engineering cost calculation; A data conversion unit, configured to perform data conversion on the data to be analyzed based on a preset data conversion requirement to obtain first data containing BCL syntax; The data compression unit is used to compress the first data and summarize the compressed data to form a corresponding data list.

[0011] Furthermore, the data configuration module includes: A data configuration unit, used to perform data configuration on the achievement data based on a preset file configuration format to obtain corresponding configuration content; The file generating unit is used to bind a format field to each operation control, and to match the value of each operation space with the mapping key of the corresponding format field to generate a corresponding data configuration file.

[0012] Furthermore, the file parsing module includes: A file parsing unit, used for classifying the data configuration file into corresponding parsers according to the parent and child levels of fields, so as to split the data configuration file into multiple categories of generation parameters; The chart generating unit is used to generate a chart according to the multiple types of generating parameters and a preset generating engine to obtain corresponding chart data.

[0013] The present invention also provides a readable storage medium on which a computer program is stored, and when the program is executed by a processor, the method for visually generating the above-mentioned electricity cost analysis report is implemented.

[0014] The present invention also proposes a computer, comprising a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein the processor implements the above-mentioned method for visually generating an electricity cost analysis report when executing the computer program.

[0015] The visual generation method and system of the electricity cost analysis report in the present invention generates result data for the data to be analyzed and the project to be analyzed, uses the result data to perform data configuration to obtain the corresponding configuration file, parses the data configuration file according to the field parent-child level, generates a data analysis report with the parsed chart data, unifies and simplifies the process of acquiring data, analyzing data, generating charts and final reports, and realizes that it can be directly applied and generated in the cost software, greatly reducing the user's workload of generating analysis reports, and providing visual data extraction and data display configuration for the electricity cost software, so that the user can efficiently and quickly output the corresponding electricity cost analysis report. BRIEF DESCRIPTION OF THE DRAWINGS

[0016] Figure 1 It is a flow chart of a method for visually generating a power cost analysis report in a first embodiment of the present invention; Figure 2 for Figure 1 Detailed flow chart of step S101; Figure 3 for Figure 1 Detailed flow chart of step S102; Figure 4 A schematic diagram of the actual interface effect of the Xml configuration in the first embodiment of the present invention; Figure 5 for Figure 1 Detailed flow chart of step S103; Figure 6 It is a partial schematic diagram of the contents of the chart in the first embodiment of the present invention; Figure 7It is another partial schematic diagram of the contents of the chart in the first embodiment of the present invention; Figure 8 A schematic diagram of configuring report content in the first embodiment of the present invention; Fig. 9 It is a structural block diagram of a system for visually generating a power cost analysis report in a second embodiment of the present invention; Fig.10 FIG. 4 is a structural block diagram of a computer in a third embodiment of the present invention.

[0017] The following specific implementation manner will further illustrate the present invention in conjunction with the above-mentioned drawings. DETAILED DESCRIPTION

[0018] In order to facilitate the understanding of the present invention, the present invention will be described more fully below with reference to the relevant drawings. Several embodiments of the present invention are given in the drawings. However, the present invention can be implemented in many different forms and is not limited to the embodiments described herein. On the contrary, the purpose of providing these embodiments is to make the disclosure of the present invention more thorough and comprehensive.

[0019] Unless otherwise defined, all technical and scientific terms used herein have the same meaning as those commonly understood by those skilled in the art to which the present invention belongs. The terms used herein in the specification of the present invention are only for the purpose of describing specific embodiments and are not intended to limit the present invention. The term "and / or" used herein includes any and all combinations of one or more of the related listed items.

[0020] Embodiment 1 [Peng Zhu 1] See also Figure 1 , which shows a visualization method for generating an electricity cost analysis report in a first embodiment of the present invention, and the method specifically includes steps S101 to S105: S101, obtaining data to be analyzed and a project to be analyzed, and generating corresponding achievement data according to the data to be analyzed and the project to be analyzed; For further information, see Figure 2 , the step S101 specifically includes steps S1011 to S1013: S1011, constructing a description language for engineering cost calculation, and using the description language for engineering cost calculation to generate corresponding data to be analyzed; S1012, performing data conversion on the data to be analyzed based on a preset data conversion requirement to obtain first data containing BCL syntax; S1013: compress the first data, and aggregate the compressed data to form a corresponding data list.

[0021] During the specific implementation, the data to be analyzed is configured in the cost analysis software, and the project to be analyzed is selected to generate the corresponding result data; Specifically, a construction cost calculation description language BCL is constructed, and the corresponding construction data (i.e., data to be analyzed) is generated using the construction cost calculation description language BCL. The construction data obtained above is converted into the corresponding BCL syntax according to the preset data requirements, for example: BEGIN: Capacity of each group ${ ?max(filter high voltage reactor(),"consumption",?#{ ->Consumption.type == "equipment" && in (Consumption.name, "reactor") && (Consumption.unit == "group" || Consumption.unit == "set") : consumption.kvar; }); }.

[0022] Furthermore, the variable data corresponding to each project is generated into a file and compressed in the corresponding project, and the corresponding contents of all projects are summarized into a data table.

[0023] S102, configuring the achievement data, binding a format field to each operation control to obtain a corresponding data configuration file; For further information, see Figure 3 , the step S102 specifically includes steps S1021~S1022: S1021, performing data configuration on the achievement data based on a preset file configuration format to obtain corresponding configuration content; S1022, binding a format field to each operation control, and matching the value of each operation space with the mapping key of the corresponding format field to generate a corresponding data configuration file.

[0024] In the specific implementation, the corresponding table or chart json configuration is generated through visual configuration, specifically: 1) Visualize and configure chart properties By configuring XML, you can define the configuration content supported by the table or chart. The XML configuration format and the actual interface effect are as follows Figure 4 As shown; Among them, xml field parsing: Item.Name: The name of the current configuration item, used for visual display on the interface; Item.Widget: The widget type of the current configuration item, which determines the result value after modification; Item.list: Current configuration item. If the widget is a combo box, you can use this field to configure its drop-down content. Item.key: the json item corresponding to the current field; 2) Generate json configuration In each of the above operation controls, a json field (including the parent node, separated by ".") will be bound in the background, that is, item.key. At the same time, the control will also provide a default value. After the user edits, the control value will correspond to the json key and generate the corresponding json file. For example, if there is a drop-down box with item.key as "type", after the user selects "Grid" as the drop-down value, a json segment of "type":"Grid" will be generated. The same is true for other fields.

[0025] Finally, the final Json file will be generated according to the configuration. The format of the json file is as follows: { "type":"Grid", "gridstyle": { "style":"Change color every other line", "themecolor":"rgba(100,137,210,255)" , "backgroundcolor":"rgba(255, 255, 255, 255)", "changePage": { "visiable":true, "position":"lower right", "backgroundcolor":"rgba(255,255,255,255) " } }, "gridProp":{ "column": ["Province", "City", "Product Name", "Quantity", "Cost", "Gross Profit", "Sales"], "dataBar":{ "column": ["quantity", "cost", "gross profit", "sales"], "color":"rgb(77,191,128)" , "negativecolor":"rgb(230,82,81) "}, "conditions":{ "City":[ ] , "province":[ { "backgroundcolor":"", "color":"", "condition":"[Province]="Jilin Province"", "iconIndex":0, "order":0 } ] } } }; S103, parsing the data configuration file according to the field parent-child level to generate corresponding chart data; For further information, see Figure 5 , the step S103 specifically includes steps S1031~S1032: S1031, classifying the data configuration file into corresponding parsers according to the field parent-child level, so as to split the data configuration file into multiple types of generation parameters; S1032: Generate a chart according to the multiple types of generation parameters and a preset generation engine to obtain corresponding chart data.

[0026] In the specific implementation, parse the json configuration and generate a chart, such as Figure 6 to Figure 7 As shown, in this embodiment, the corresponding chart is generated by parsing the json configuration, and the specific process is as follows: 1. Json configuration: the json configuration file described in the above steps; 2. Json parser: The json file will be classified into the corresponding parser according to the parent-child relationship of the fields. Charts and tables will split the content into multiple categories of generation parameters according to their functions. The specific classification is as follows: Charts: data filtering parameters, animation parameters, coordinate system parameters, legend parameters, series data parameters, theme parameters, title parameters, grid line parameters, prompt parameters, option parameters, and operation interaction parameters; Table: header parameters, data parameters, data filtering parameters, theme parameters, style parameters, operation interaction parameters Chart generation engine: The chart is generated through the generation engine using the corresponding parameter information generated from the json configuration.

[0027] The specific generation logic uses Qt to draw the controls and complete the corresponding chart content as required.

[0028] S104, constructing a visualization interface, and integrating the chart data with the visualization interface to form a corresponding data analysis report.

[0029] In the specific implementation, a visual interface is provided. It supports users to drag text and the chart configured in the second step to lay out the content. The interface effect is as follows Figure 8 As shown, it supports inserting tables and rich text.

[0030] Export the Word document to form the final report, parse the above charts and rich text into images and formatted text content, and use Aspose.Words component to convert the content into the corresponding Word document to complete the conversion.

[0031] In summary, the visual generation method of the electricity cost analysis report in the above-mentioned embodiment of the present invention generates result data for the data to be analyzed and the project to be analyzed, uses the result data to perform data configuration to obtain the corresponding configuration file, parses the data configuration file according to the field parent-child level, generates a data analysis report with the parsed chart data, unifies and simplifies the process of acquiring data, analyzing data, generating charts and final reports, and realizes that it can be directly applied and generated in the cost software, which greatly reduces the user's workload of generating analysis reports, and provides visual data extraction and data display configuration for the electricity cost software, so that users can efficiently and quickly output the corresponding electricity cost analysis report.

[0032] Embodiment 2 Another aspect of the present invention is to provide a visualization generation system for power cost analysis report. Fig. 9 , which is a visualization generation system of an electricity cost analysis report in a second embodiment of the present invention, and the system includes: The data analysis module 11 is used to obtain the data to be analyzed and the project to be analyzed, and generate corresponding achievement data according to the data to be analyzed and the project to be analyzed; Furthermore, the data analysis module 11 includes: A data generation unit, used to construct a description language for engineering cost calculation, and to generate corresponding data to be analyzed using the description language for engineering cost calculation; A data conversion unit, configured to perform data conversion on the data to be analyzed based on a preset data conversion requirement to obtain first data containing BCL syntax; The data compression unit is used to compress the first data and summarize the compressed data to form a corresponding data list.

[0033] The data configuration module 12 is used to configure the achievement data and bind a format field to each operation control to obtain a corresponding data configuration file; Furthermore, the data configuration module 12 includes: A data configuration unit, used to perform data configuration on the achievement data based on a preset file configuration format to obtain corresponding configuration content; The file generating unit is used to bind a format field to each operation control, and to match the value of each operation space with the mapping key of the corresponding format field to generate a corresponding data configuration file.

[0034] A file parsing module 13, used to parse the data configuration file according to the field parent-child level to generate corresponding chart data; Furthermore, the file parsing module 13 includes: A file parsing unit, used for classifying the data configuration file into corresponding parsers according to the parent and child levels of fields, so as to split the data configuration file into multiple categories of generation parameters; The chart generating unit is used to generate a chart according to the multiple types of generating parameters and a preset generating engine to obtain corresponding chart data.

[0035] The data integration module 14 is used to construct a visualization interface and integrate the chart data with the visualization interface to form a corresponding data analysis report.

[0036] The functions or operation steps implemented when the above modules and units are executed are generally the same as those in the above method embodiments, and will not be repeated here.

[0037] The visual generation system of the electricity cost analysis report provided in the embodiment of the present invention has the same implementation principle and technical effects as those in the aforementioned method embodiment. For the sake of brief description, for matters not mentioned in the system embodiment, reference may be made to the corresponding contents in the aforementioned method embodiment.

[0038] Embodiment 3 The present invention also provides a computer, see Fig.10 , shown is a computer in the third embodiment of the present invention, including a memory 10, a processor 20, and a computer program 30 stored in the memory 10 and executable on the processor 20. When the processor 20 executes the computer program 30, the above-mentioned method for visually generating an electricity cost analysis report is implemented.

[0039] The memory 10 includes at least one type of readable storage medium, which includes a flash memory, a hard disk, a multimedia card, a card-type memory (e.g., an SD or DX memory, etc.), a magnetic memory, a magnetic disk, an optical disk, etc. In some embodiments, the memory 10 may be an internal storage unit of a computer, such as a hard disk of the computer. In other embodiments, the memory 10 may also be an external storage device, such as a plug-in hard disk, a smart memory card (Smart Media Card, SMC), a secure digital (Secure Digital, SD) card, a flash card, etc. Further, the memory 10 may also include both an internal storage unit of the computer and an external storage device. The memory 10 may be used not only to store application software and various types of data installed in the computer, but also to temporarily store data that has been output or is to be output.

[0040] Among them, in some embodiments, the processor 20 can be an electronic control unit (Electronic Control Unit, abbreviated as ECU, also known as a vehicle computer), a central processing unit (Central Processing Unit, CPU), a controller, a microcontroller, a microprocessor or other data processing chip, used to run the program code stored in the memory 10 or process data, such as executing access restriction programs, etc.

[0041] It should be pointed out that Fig.10 The structure shown does not constitute a limitation on the computer. In other embodiments, the computer may include fewer or more components than shown in the figure, or combine certain components, or arrange the components differently.

[0042] The embodiment of the present invention further provides a readable storage medium having a computer program stored thereon, and when the program is executed by a processor, the method for visually generating an electricity cost analysis report as described above is implemented.

[0043] Those skilled in the art will appreciate that the logic and / or steps represented in the flowchart or otherwise described herein, for example, may be considered as an ordered list of executable instructions for implementing logical functions, and may be specifically implemented in any computer-readable medium for use by an instruction execution system, device or apparatus (such as a computer-based system, a system including a processor, or other system that can fetch instructions from an instruction execution system, device or apparatus and execute instructions), or in conjunction with such instruction execution systems, devices or apparatuses. For purposes of this specification, "computer-readable medium" may be any device that can contain, store, communicate, propagate or transmit a program for use by an instruction execution system, device or apparatus, or in conjunction with such instruction execution systems, devices or apparatuses.

[0044] More specific examples of computer-readable media (a non-exhaustive list) include the following: an electrical connection with one or more wires (electronic device), a portable computer disk case (magnetic device), a random access memory (RAM), a read-only memory (ROM), an erasable and programmable read-only memory (EPROM or flash memory), an optical fiber device, and a portable compact disk read-only memory (CDROM). In addition, the computer-readable medium may even be a paper or other suitable medium on which the program is printed, since the program may be obtained electronically, for example, by optically scanning the paper or other medium, followed by editing, deciphering or, if necessary, processing in another suitable manner, and then stored in a computer memory.

[0045] It should be understood that the various parts of the present invention can be implemented by hardware, software, firmware or a combination thereof. In the above-mentioned embodiments, multiple steps or methods can be implemented by software or firmware stored in a memory and executed by a suitable instruction execution system. For example, if implemented by hardware, as in another embodiment, it can be implemented by any one of the following technologies known in the art or a combination thereof: a discrete logic circuit having a logic gate circuit for implementing a logic function for a data signal, a dedicated integrated circuit having a suitable combination of logic gate circuits, a programmable gate array (PGA), a field programmable gate array (FPGA), etc.

[0046] The technical features of the above-described embodiments may be arbitrarily combined. To make the description concise, not all possible combinations of the technical features in the above-described embodiments are described. However, as long as there is no contradiction in the combination of these technical features, they should be considered to be within the scope of this specification.

[0047] The above-mentioned embodiments only express several implementation methods of the present application, and the descriptions thereof are relatively specific and detailed, but they cannot be understood as limiting the scope of the invention patent. It should be pointed out that, for a person of ordinary skill in the art, several variations and improvements can be made without departing from the concept of the present application, and these all belong to the protection scope of the present application. Therefore, the protection scope of the patent of the present application shall be subject to the attached claims.

Claims

1. A method for visually generating an electricity cost analysis report, characterized in that: include: Acquire the data to be analyzed and the project to be analyzed, and generate corresponding achievement data according to the data to be analyzed and the project to be analyzed; Performing data configuration on the achievement data, binding a format field to each operation control to obtain a corresponding data configuration file; Parsing the data configuration file according to the parent and child levels of the fields to generate corresponding chart data; Construct a visualization interface, and integrate the chart data with the visualization interface to form a corresponding data analysis report.

2. The method for visually generating an electricity cost analysis report according to claim 1, characterized in that: The steps of obtaining the data to be analyzed and the project to be analyzed, and generating corresponding achievement data according to the data to be analyzed and the project to be analyzed include: Constructing a description language for engineering cost calculation, and using the description language for engineering cost calculation to generate corresponding data to be analyzed; Performing data conversion on the data to be analyzed based on a preset data conversion requirement to obtain first data containing BCL syntax; The first data is compressed, and the compressed data is summarized to form a corresponding data list.

3. The method for visually generating an electricity cost analysis report according to claim 1, characterized in that: The steps of configuring the achievement data and binding a format field to each operation control to obtain a corresponding data configuration file include: Performing data configuration on the achievement data based on a preset file configuration format to obtain corresponding configuration content; A format field is bound to each operation control, and the value of each operation space is matched with the mapping key of the corresponding format field to generate a corresponding data configuration file.

4. The method for visually generating an electricity cost analysis report according to claim 1, characterized in that: The step of parsing the data configuration file according to the field parent-child level to generate corresponding chart data includes: Classifying the data configuration file into corresponding parsers according to field parent-child levels, so as to split the data configuration file into multiple categories of generation parameters; Chart generation is performed according to the multiple types of generation parameters and a preset generation engine to obtain corresponding chart data.

5. A visual generation system for power cost analysis report, characterized in that: include: A data analysis module, used to obtain the data to be analyzed and the project to be analyzed, and generate corresponding achievement data according to the data to be analyzed and the project to be analyzed; A data configuration module is used to configure the achievement data and bind a format field to each operation control to obtain a corresponding data configuration file; A file parsing module, used to parse the data configuration file according to the field parent-child level to generate corresponding chart data; The data integration module is used to construct a visualization interface and integrate the chart data with the visualization interface to form a corresponding data analysis report.

6. The visual generation system of the power cost analysis report according to claim 5, characterized in that: The data analysis module includes: A data generation unit, used to construct a description language for engineering cost calculation, and to generate corresponding data to be analyzed using the description language for engineering cost calculation; A data conversion unit, configured to perform data conversion on the data to be analyzed based on a preset data conversion requirement to obtain first data containing BCL syntax; The data compression unit is used to compress the first data and summarize the compressed data to form a corresponding data list.

7. The visual generation system of the power cost analysis report according to claim 5, characterized in that: The data configuration module includes: A data configuration unit, used to perform data configuration on the achievement data based on a preset file configuration format to obtain corresponding configuration content; The file generating unit is used to bind a format field to each operation control, and to match the value of each operation space with the mapping key of the corresponding format field to generate a corresponding data configuration file.

8. The visual generation system of the power cost analysis report according to claim 5, characterized in that: The file parsing module includes: A file parsing unit, used for classifying the data configuration file into corresponding parsers according to the parent and child levels of fields, so as to split the data configuration file into multiple categories of generation parameters; The chart generating unit is used to generate a chart according to the multiple types of generating parameters and a preset generating engine to obtain corresponding chart data.

9. A readable storage medium having a computer program stored thereon, characterized in that: When the program is executed by a processor, the method for visually generating an electricity cost analysis report as described in any one of claims 1 to 5 is implemented.

10. A computer comprising a memory, a processor, and a computer program stored in the memory and executable on the processor, characterized in that: When the processor executes the computer program, the method for visually generating an electricity cost analysis report as described in any one of claims 1 to 5 is implemented.

Images