CN116776851A - Method and system for configuring energy production statistical report template - Google Patents
Method and system for configuring energy production statistical report template Download PDFInfo
- Publication number
- CN116776851A CN116776851A CN202310685782.6A CN202310685782A CN116776851A CN 116776851 A CN116776851 A CN 116776851A CN 202310685782 A CN202310685782 A CN 202310685782A CN 116776851 A CN116776851 A CN 116776851A
- Authority
- CN
- China
- Prior art keywords
- energy
- determining
- type
- model
- energy production
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
- 238000004519 manufacturing process Methods 0.000 title claims abstract description 73
- 238000000034 method Methods 0.000 title claims abstract description 29
- 238000005516 engineering process Methods 0.000 claims abstract description 45
- 238000005259 measurement Methods 0.000 claims abstract description 40
- 230000003068 static effect Effects 0.000 claims description 8
- 239000000758 substrate Substances 0.000 claims 1
- 238000013461 design Methods 0.000 abstract description 7
- 230000007547 defect Effects 0.000 abstract description 2
- 238000010586 diagram Methods 0.000 description 5
- 230000010354 integration Effects 0.000 description 3
- 230000000694 effects Effects 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 238000010248 power generation Methods 0.000 description 1
- 238000010561 standard procedure Methods 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
- 230000000007 visual effect Effects 0.000 description 1
Landscapes
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention belongs to the technical field of computers, and relates to a method and a system for configuring an energy production statistical report template, wherein the method comprises the following steps: s1, determining the time type of an energy production statistical report; s2, setting the type of a table cell based on an application program language technology, and determining an energy measurement point index according to the type of the table cell; s3, generating an energy production statistical report template according to the time type and the energy measurement point index based on the application program language technology. The system comprises a determining module, a setting module and a generating module. The method and the system effectively improve the defects of high error rate, low configuration efficiency and high learning cost in the design and configuration of the original table report template, increase the usability of the energy production statistical report template and improve the configuration efficiency of the energy production statistical report template.
Description
Technical Field
The invention belongs to the technical field of computers, and particularly relates to a method and a system for configuring an energy production statistical report template.
Background
The energy production statistical report is an important management tool in energy production management, the energy production statistical report can fully reflect the overall condition of energy production, and the problems occurring in energy production and the running condition of equipment can be analyzed through the energy production statistical report data. The manager can predict the condition of energy production for a period of time in the future through the energy production statistical report, so as to make an energy production plan. Because of the complex energy production, various energy production indexes lead to various and complex energy production statistical forms, and the arrangement of the energy production statistical forms also becomes an important work of an energy production manager. The form of the energy production statistical report is mainly a table at present, and the data form is divided into daily reports, monthly reports and annual reports.
The implementation form of the current energy statistics production report is mainly as follows: the energy production manager carries out the configuration of the report template through a report configuration tool in the energy management system, and then uploads the report template or generates the report template in the system; the report template is analyzed by an energy report program and energy index data are acquired to generate an energy production statistical report.
The existing report template configuration method mainly comprises the following two steps: the first method is to complete the configuration of the report template through a form (excel), and directly design the report template style and the required energy index code in the excel. According to the method, a report configuration tool and a report generation tool are separated, a person configuring a report template needs to know the specification of the report generation tool, and a report is configured according to a certain rule; the person configuring the report also needs to know the corresponding relation between the names of the energy index measuring points and the energy index codes, and then the corresponding energy index codes are manually configured in the report template. The manual operation is easy to cause error in energy index coding configuration, and the error rate is extremely high; in addition, the person configuring the report template needs to continuously correspond to the energy index codes in the configuration process, and the configuration efficiency is extremely low. The second is to complete the report template configuration by the template configuration tool, and the report template generation tool can combine the Html (hypertext markup language) technology and the template coding system to design and configure the template in a tolla mode. The method needs to give up the familiar excel report configuration mode by the person configuring the report, relearns the configuration method of the report tool, has higher learning cost and is difficult to popularize in the actual use process.
Disclosure of Invention
Aiming at the problems, the invention adopts the following technical scheme: a method for configuring an energy production statistical reporting template, the method comprising the steps of: s1, determining the time type of an energy production statistical report; s2, setting the type of a table cell based on an application program language technology, and determining an energy measurement point index according to the type of the table cell; s3, generating an energy production statistical report template according to the time type and the energy measurement point index based on the application program language technology.
Further, S1, determining the time type of an energy production statistical report in a table report generating template; s2, setting table cell types in the public information model based on an application program language technology, and determining an energy measuring point index according to the table cell types; s3, generating an energy production statistical report template in the public information model based on the application program language technology according to the time type and the energy measurement point index.
Further, in step S2, the table cell type is set in the public information model based on the application language technology, when the table cell type is dynamic, the measurement point selection frame is popped up, the content of the measurement point selection frame is that the public information model is called, the energy measurement point index list set by the public information model is obtained, and the energy measurement point index is determined.
Further, the calling the public information model, and the obtaining the energy measure point index list set by the public information model includes: and calling the public information model, acquiring a station and an equipment model in the public information model, determining equipment attributes according to the station and the equipment model, and determining an energy measuring point index list according to the equipment attributes.
Further, the setting of the table cell type based on the application language technology in the public information model further includes: when the form cell type is static, filling content in the form cell popup text box, and displaying the content of the form cell as the filled content after filling.
Further, the calling the public information model, obtaining a station container and an equipment model in the public information model, determining equipment attributes according to the station container and the equipment model, and determining an energy measure point index list according to the equipment attributes comprises: calling a public information model to load station list information, and obtaining a container instance list with station types as stations; returning station list information and loading a station list; selecting a station, and determining station information and station model information; acquiring a device instance list and device model information in a designated station; loading a device list, and selecting device determining device information and device model information; and selecting equipment attributes in the appointed equipment model, and loading an energy measuring point index list according to the selected equipment attributes.
In addition, the invention also designs an energy production statistical report template configuration system, which comprises a determination module, a setting module and a generation module; the determining module is used for determining the time type of the energy production statistical report; the setting module is used for setting the type of the table cell based on the application program language technology, and determining the energy measurement point index according to the type of the table cell; the generation module is used for generating an energy production statistical report template according to the time type and the energy measurement point index based on the application program language technology.
Further, the determining module is used for determining the time type of the energy production statistical report in the table report generating template; the setting module is used for setting the types of the table cells based on the application program language technology in the public information model, and determining the energy measuring point indexes according to the types of the table cells; the generation module is used for generating an energy production statistical report template according to the time type and the energy measurement point index based on the application program language technology in the public information model.
Further, the setting module is used for setting the types of the table cells based on the application program language technology in the public information model, and determining the energy measurement point indexes according to the types of the table cells; comprising the following steps: the setting module is used for setting the type of the table cell based on the application program language technology in the public information model, when the type of the table cell is dynamic, the measuring point selection frame is popped up, the content of the measuring point selection frame is that the public information model is called, the energy measuring point index list set by the public information model is obtained, and the energy measuring point index is determined.
And the setting module is further used for setting the type of the form cell based on the application program language technology in the public information model, filling the content in the pop-up text box of the form cell when the type of the form cell is static, and displaying the content as the filled content after the filling is completed.
According to the method and the system for configuring the energy production statistical report template, provided by the invention, the defects of high error rate, low configuration efficiency and high learning cost in the design and configuration of the original excel report template are effectively improved by effectively combining the VBA (Visual Basic for Applications, application language) technology of the excel (form) with the CIM (common information model) model, so that the usability of the energy production statistical report template is improved, and the configuration efficiency of the energy production statistical report template is improved.
Additional features and advantages of the invention will be set forth in the description which follows, and in part will be obvious from the description, or may be learned by practice of the invention. The objects and other advantages of the invention may be realized and attained by the structure particularly pointed out in the written description and drawings.
Drawings
In order to more clearly illustrate the embodiments of the present invention or the technical solutions of the prior art, the following description will briefly explain the drawings used in the embodiments or the description of the prior art, and it is obvious that the drawings in the following description are some embodiments of the present invention, and other drawings can be obtained according to these drawings without inventive effort for a person skilled in the art.
FIG. 1 is a flow chart of a method for configuring an energy production statistics report template;
FIG. 2 is a schematic diagram of a load station list in a method for configuring an energy production statistics template;
FIG. 3 is a schematic diagram of a loading device list in an energy production statistics template configuration method;
FIG. 4 is a schematic diagram of the names of the measuring points of the energy indexes loaded in the configuration method of the energy production statistical report template;
FIG. 5 is a schematic diagram of generating an energy production statistics template tag;
FIG. 6 is a schematic diagram of an energy production statistics template configuration system.
Detailed Description
For the purpose of making the objects, technical solutions and advantages of the embodiments of the present invention more apparent, the technical solutions in the embodiments of the present invention will be clearly and completely described below, and it is apparent that the described embodiments are some embodiments of the present invention, but not all embodiments. All other embodiments, which can be made by those skilled in the art based on the embodiments of the invention without making any inventive effort, are intended to be within the scope of the invention.
The energy production statistical report mainly refers to index data report of energy production conditions in a certain time, and the index data can effectively reflect problems in an energy production system, and has very important significance and effect on energy enterprise management and decision. The implementation principle is that the energy production report has two important elements of time type and energy index measuring point name according to the definition of the energy production statistical report.
The invention effectively combines the VBA technology of the excel with the CIM model, improves the problems of high error rate, low configuration efficiency, high learning cost and the like in the design and configuration of the original excel report template, and increases the usability of the report configuration template.
Accordingly, the present invention contemplates a method for configuring an energy production statistics template, as shown in fig. 1, comprising the steps of: s1, determining the time type of an energy production statistical report; s2, setting the type of a table cell based on an application program language technology, and determining an energy measurement point index according to the type of the table cell;
s3, generating an energy production statistical report template according to the time type and the energy measurement point index based on the application program language technology.
S1, determining the time type of an energy production statistical report in an excel report generation template; s2, setting an excel cell type in a CIM based on a VBA technology, and determining an energy measuring point index according to the excel cell type; s3, generating an energy production statistical report template based on the VBA technology in the CIM model according to the time type and the energy measurement point index.
In the step S1, the time types of the energy production statistics report mainly include daily report, monthly report and annual report, and each type of corresponding data mainly includes daily hour data, monthly day data and yearly month data. These data types may be agreed that DD stands for daily newspapers, MM stands for monthly newspapers, and YY stands for annual newspapers.
In the step S2, the generation of the energy index measurement points may be obtained by using a common information model (CIM, common Information Model). The CIM model is an abstract model that describes all of the main objects of a power enterprise, particularly those related to the operation of power. By providing a standard method of representing power system resources in terms of object classes and attributes and relationships between them, the CIM model facilitates integration of Energy Management System (EMS) applications that are developed independently by different vendors, integration between multiple independently developed complete EMS systems, and integration between an EMS system and other systems that involve different aspects of power system operation, such as power generation or distribution systems. By defining a common language (i.e., grammar and semantics) based on the CIM model, such applications or systems can be enabled by accessing common data and exchanging information independent of the internal representation of the information.
The CIM model defines equipment attributes through an equipment model, wherein the equipment attributes comprise equipment static attributes and equipment dynamic attributes, the equipment static attributes can be an inverter, an equipment brand, an equipment model, rated output power or the like, and the equipment dynamic attributes can be voltage or current of the inverter or the like.
Therefore, S2, setting an excel cell type based on the VBA technology in the CIM model, and determining the energy measurement point index according to the excel cell type specifically comprises: setting an excel cell type in the CIM based on the VBA technology, popping up a measuring point selection frame when the excel cell type is dynamic, wherein the content of the measuring point selection frame is that the CIM is called, acquiring an energy measuring point index list set by the CIM, and determining an energy measuring point index. Specifically, invoking the CIM model, and obtaining the energy measurement point index list set by the CIM model comprises the following steps: calling a CIM model, acquiring a station and an equipment model in the CIM model, determining equipment attributes according to the station and the equipment model, and determining an energy measuring point index list according to the equipment attributes; the method specifically comprises the following steps: invoking CIM model to load station list information, and obtaining a container instance list with station types as stations; returning station list information, and loading a station list (shown in fig. 2); selecting a station, and determining station information and station model information; acquiring a device instance list and device model information in a designated station, and loading the device list (shown in fig. 3); selecting equipment to determine equipment information and equipment model information; and selecting equipment attributes in the designated equipment model, and loading an energy measuring point index list (shown in fig. 4) according to the selected equipment attributes. Therefore, a configurator can complete the determination of the energy measuring point index by only selecting the name of the energy measuring point index without knowing and knowing the CIM energy measuring point index code. After the station list, the equipment list and the energy index measuring point names are loaded in sequence, clicking to determine the energy production statistical report template label is carried out, as shown in fig. 5.
Setting an excel cell type based on a VBA technology in a CIM model, filling content in an excel cell popup text box when the excel cell type is static, and displaying the content of the excel cell as the filled content after filling.
When the time type and the energy measurement point index are selected, two basic elements of the energy production statistical report form are already provided, and the VBA generates a text format with CIM codes in a CIM model library according to the time type and the energy measurement point name, for example, the text format is: the production format is as follows
Code datatype datainfo datatype; wherein the code is a CIM index code, such as a Ca01ES_ICG_ICG1_DU; CA01ES01 encodes a station container; ICG is a device type code; ICG1 encodes device instance; the DU encodes the device attributes. datetype is time type, DD, MM, YY (DD stands for daily report, MM stands for monthly report, YY stands for annual report) respectively; dateinfo is in a time format template format, such as YYYY-MM-DD or hh: MM: ss; datatype is a data type; and $ is a separator.
In addition, the invention also designs an energy production statistical report template configuration system, as shown in fig. 6, which comprises a determination module 11, a setting module 12 and a generation module 13; the determining module 11 is used for determining the time type of the energy production statistical report; the setting module 12 is configured to set a table cell type based on the VBA technology, and determine an energy measurement point index according to the table cell type; the generating module 13 is used for generating an energy production statistical report template according to the time type and the energy measurement point index based on the VBA technology.
Specifically, the determining module 11 is configured to determine a time type of the energy production statistical report in the excel report generating template; the setting module 12 is configured to set an excel cell type based on VBA technology in the CIM model, and determine an energy measurement point index according to the excel cell type; the generating module 13 is used for generating an energy production statistical report template according to the time type and the energy measurement point index based on the VBA technology in the CIM model.
Specifically, the setting module 12 is configured to set an excel cell type based on VBA technology in the CIM model, and determine an energy measurement point index according to the excel cell type, including: the setting module 12 is configured to set an excel cell type in the CIM model based on VBA technology, pop up a measurement point selection frame when the excel cell type is dynamic, and obtain an energy measurement point index list set by the CIM model for calling the CIM model to determine an energy measurement point index.
Specifically, the setting module 12 is further configured to set an excel cell type in the CIM model based on the VBA technology, and fill in content in the pop-up text box of the excel cell when the excel cell type is static, and display content of the excel cell after filling is the filled content.
Although the invention has been described in detail with reference to the foregoing embodiments, it will be understood by those of ordinary skill in the art that: the technical scheme described in the foregoing embodiments can be modified or some technical features thereof can be replaced by equivalents; such modifications and substitutions do not depart from the spirit and scope of the technical solutions of the embodiments of the present invention.
Claims (10)
1. A method for configuring an energy production statistical report template, the method comprising the steps of:
s1, determining the time type of an energy production statistical report;
s2, setting the type of a table cell based on an application program language technology, and determining an energy measurement point index according to the type of the table cell;
s3, generating an energy production statistical report template according to the time type and the energy measurement point index based on the application program language technology.
2. The method of claim 1, wherein the step of determining the position of the substrate comprises,
s1, determining the time type of an energy production statistical report in a table report generating template;
s2, setting table cell types in the public information model based on an application program language technology, and determining an energy measuring point index according to the table cell types;
s3, generating an energy production statistical report template in the public information model based on the application program language technology according to the time type and the energy measurement point index.
3. The method according to claim 2, wherein in step S2, a table cell type is set in the public information model based on an application language technology, and when the table cell type is dynamic, a measurement point selection frame is popped up, and the content of the measurement point selection frame is that the public information model is called, so as to obtain an energy measurement point index list set by the public information model, and determine an energy measurement point index.
4. The method of claim 3, wherein the invoking the common information model to obtain the list of energy measure indicators set by the common information model comprises:
and calling the public information model, acquiring a station and an equipment model in the public information model, determining equipment attributes according to the station and the equipment model, and determining an energy measuring point index list according to the equipment attributes.
5. The method of claim 2, wherein the setting of the table cell types in the common information model based on application language technology further comprises:
when the form cell type is static, filling content in the form cell popup text box, and displaying the content of the form cell as the filled content after filling.
6. The method of claim 4, wherein invoking the common information model, obtaining a site container and a device model in the common information model, determining device attributes from the site container and the device model, and determining the energy measure index list from the device attributes comprises:
calling a public information model to load station list information, and obtaining a container instance list with station types as stations;
returning station list information and loading a station list;
selecting a station, and determining station information and station model information;
acquiring a device instance list and device model information in a designated station;
loading a device list, and selecting device determining device information and device model information;
and selecting equipment attributes in the appointed equipment model, and loading an energy measuring point index list according to the selected equipment attributes.
7. The system is characterized by comprising a determining module, a setting module and a generating module;
the determining module is used for determining the time type of the energy production statistical report;
the setting module is used for setting the type of the table cell based on the application program language technology, and determining the energy measurement point index according to the type of the table cell;
the generation module is used for generating an energy production statistical report template according to the time type and the energy measurement point index based on the application program language technology.
8. The system of claim 7, wherein the system further comprises a controller configured to control the controller,
the determining module is used for determining the time type of the energy production statistical report in the table report generating template;
the setting module is used for setting the types of the table cells based on the application program language technology in the public information model, and determining the energy measuring point indexes according to the types of the table cells;
the generation module is used for generating an energy production statistical report template according to the time type and the energy measurement point index based on the application program language technology in the public information model.
9. The system of claim 7, wherein the setting module is configured to set a table cell type in the public information model based on an application language technology, and determine the energy measurement point index according to the table cell type; comprising the following steps:
the setting module is used for setting the type of the table cell based on the application program language technology in the public information model, when the type of the table cell is dynamic, the measuring point selection frame is popped up, the content of the measuring point selection frame is that the public information model is called, the energy measuring point index list set by the public information model is obtained, and the energy measuring point index is determined.
10. The system of claim 8 or 9, wherein the setting module is further configured to set a type of the form cell in the public information model based on the application language technology, and when the type of the form cell is static, fill out contents in the pop-up text box of the form cell, and display the contents of the form cell as the filled-out contents after the filling-out is completed.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202310685782.6A CN116776851A (en) | 2023-06-09 | 2023-06-09 | Method and system for configuring energy production statistical report template |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202310685782.6A CN116776851A (en) | 2023-06-09 | 2023-06-09 | Method and system for configuring energy production statistical report template |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN116776851A true CN116776851A (en) | 2023-09-19 |
Family
ID=88010774
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202310685782.6A Pending CN116776851A (en) | 2023-06-09 | 2023-06-09 | Method and system for configuring energy production statistical report template |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN116776851A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN117875285A (en) * | 2023-12-20 | 2024-04-12 | 河北先见软件科技股份有限公司 | Report generation method and device based on template, electronic equipment and storage medium |
-
2023
- 2023-06-09 CN CN202310685782.6A patent/CN116776851A/en active Pending
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN117875285A (en) * | 2023-12-20 | 2024-04-12 | 河北先见软件科技股份有限公司 | Report generation method and device based on template, electronic equipment and storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN105574652B (en) | Intelligent power distribution network planning big data management and control system and method | |
| CN103353871A (en) | Interoperation picture file checking method based on CIM/G standard | |
| CN108733532B (en) | Health degree control method and device for big data platform, medium and electronic equipment | |
| CN104600840A (en) | Intelligent dispatching and mis-operation preventing management system and method | |
| CN106570778A (en) | Big data-based data integration and line loss analysis and calculation method | |
| CN110108955A (en) | A kind of new-energy grid-connected performance automatic test analysis platform and detection method | |
| CN116776851A (en) | Method and system for configuring energy production statistical report template | |
| CN101364284A (en) | Production management system for electrical power system | |
| CN112434033B (en) | Method for collecting and displaying flexible and changeable table type data | |
| CN112580178B (en) | Graph-model bidirectional verification method and device for energy management system | |
| CN103116827A (en) | Rural power grid engineering control system | |
| CN111563700A (en) | Intelligent station relay protection calibrator for graphically controlling GOOSE state | |
| CN111026451A (en) | Parameter configuration method and configuration tool for transformer substation terminal interval | |
| CN114692875A (en) | Construction method of GIS (geographic information System) knowledge graph for fault diagnosis | |
| EP4418179A1 (en) | Microservices-architecture-based full-lifecycle management system for new-energy power generation devices | |
| Chen et al. | Research on model management method for Micro-grid | |
| CN109917776B (en) | Intelligent fault analysis method and device for wind generating set | |
| CN109614143B (en) | Development method for automatically generating fault flow chart in IETM browser | |
| CN102567066A (en) | Business system development method, business system development platform and business system development system | |
| Qi et al. | Design of distribution scada system based on open source gis | |
| CN108228688B (en) | Template generation method, system and server based on XBRL | |
| Li et al. | Design and Implementation of Production Visual Report Subsystem Based on Echarts | |
| Qin et al. | The Impact of R&D Investment and Policy Support on Intelligent Manufacturing Level: Based on the fsQCA Method | |
| CN111159993B (en) | Automatic analysis and report generation system platform for power transformation mobile operation card | |
| Mao | Construction of Intelligent Vocational Management Information System with R Programming |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination |