CN112037083B - Power plant production data reporting system - Google Patents
Power plant production data reporting system Download PDFInfo
- Publication number
- CN112037083B CN112037083B CN202010680114.0A CN202010680114A CN112037083B CN 112037083 B CN112037083 B CN 112037083B CN 202010680114 A CN202010680114 A CN 202010680114A CN 112037083 B CN112037083 B CN 112037083B
- Authority
- CN
- China
- Prior art keywords
- index
- module
- report
- sub
- data
- 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.)
- Active
Links
- 238000004519 manufacturing process Methods 0.000 title claims abstract description 44
- 238000004364 calculation method Methods 0.000 claims abstract description 67
- 238000012545 processing Methods 0.000 claims abstract description 20
- 238000006243 chemical reaction Methods 0.000 claims description 37
- 238000002156 mixing Methods 0.000 claims description 31
- 239000000446 fuel Substances 0.000 claims description 26
- 238000000034 method Methods 0.000 claims description 19
- 238000004458 analytical method Methods 0.000 claims description 15
- 239000003245 coal Substances 0.000 claims description 15
- 230000002159 abnormal effect Effects 0.000 claims description 12
- 238000012423 maintenance Methods 0.000 claims description 12
- 230000008569 process Effects 0.000 claims description 12
- 238000012360 testing method Methods 0.000 claims description 12
- 230000004048 modification Effects 0.000 claims description 11
- 238000012986 modification Methods 0.000 claims description 11
- 238000012544 monitoring process Methods 0.000 claims description 9
- 238000009825 accumulation Methods 0.000 claims description 7
- 230000008859 change Effects 0.000 claims description 4
- 230000000007 visual effect Effects 0.000 claims description 4
- 230000005856 abnormality Effects 0.000 claims description 3
- 238000001514 detection method Methods 0.000 claims description 3
- 230000007613 environmental effect Effects 0.000 claims description 3
- XLYOFNOQVPJJNP-UHFFFAOYSA-N water Substances O XLYOFNOQVPJJNP-UHFFFAOYSA-N 0.000 claims description 3
- 238000013500 data storage Methods 0.000 claims 2
- 238000012935 Averaging Methods 0.000 claims 1
- 238000012795 verification Methods 0.000 abstract 1
- 230000002354 daily effect Effects 0.000 description 25
- 238000005259 measurement Methods 0.000 description 8
- 238000005070 sampling Methods 0.000 description 3
- 230000001276 controlling effect Effects 0.000 description 2
- 230000007547 defect Effects 0.000 description 2
- 238000010248 power generation Methods 0.000 description 2
- 230000001360 synchronised effect Effects 0.000 description 2
- 230000009286 beneficial effect Effects 0.000 description 1
- 230000001186 cumulative effect Effects 0.000 description 1
- 125000004122 cyclic group Chemical group 0.000 description 1
- 230000007812 deficiency Effects 0.000 description 1
- 238000006477 desulfuration reaction Methods 0.000 description 1
- 230000023556 desulfurization Effects 0.000 description 1
- 238000010586 diagram Methods 0.000 description 1
- 230000003203 everyday effect Effects 0.000 description 1
- 230000009467 reduction Effects 0.000 description 1
- 230000001105 regulatory effect Effects 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q50/00—Information and communication technology [ICT] specially adapted for implementation of business processes of specific business sectors, e.g. utilities or tourism
- G06Q50/06—Energy or water supply
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2458—Special types of queries, e.g. statistical queries, fuzzy queries or distributed queries
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2458—Special types of queries, e.g. statistical queries, fuzzy queries or distributed queries
- G06F16/2462—Approximate or statistical queries
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/174—Form filling; Merging
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/177—Editing, e.g. inserting or deleting of tables; using ruled lines
- G06F40/18—Editing, e.g. inserting or deleting of tables; using ruled lines of spreadsheets
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y04—INFORMATION OR COMMUNICATION TECHNOLOGIES HAVING AN IMPACT ON OTHER TECHNOLOGY AREAS
- Y04S—SYSTEMS INTEGRATING TECHNOLOGIES RELATED TO POWER NETWORK OPERATION, COMMUNICATION OR INFORMATION TECHNOLOGIES FOR IMPROVING THE ELECTRICAL POWER GENERATION, TRANSMISSION, DISTRIBUTION, MANAGEMENT OR USAGE, i.e. SMART GRIDS
- Y04S10/00—Systems supporting electrical power generation, transmission or distribution
- Y04S10/50—Systems or methods supporting the power network operation or management, involving a certain degree of interaction with the load-side end user applications
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Computational Linguistics (AREA)
- Health & Medical Sciences (AREA)
- General Engineering & Computer Science (AREA)
- Probability & Statistics with Applications (AREA)
- Business, Economics & Management (AREA)
- General Health & Medical Sciences (AREA)
- Databases & Information Systems (AREA)
- Data Mining & Analysis (AREA)
- Software Systems (AREA)
- Mathematical Physics (AREA)
- Fuzzy Systems (AREA)
- Economics (AREA)
- Artificial Intelligence (AREA)
- Audiology, Speech & Language Pathology (AREA)
- Public Health (AREA)
- Human Resources & Organizations (AREA)
- Water Supply & Treatment (AREA)
- General Business, Economics & Management (AREA)
- Marketing (AREA)
- Tourism & Hospitality (AREA)
- Strategic Management (AREA)
- Primary Health Care (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The application discloses a power plant production data reporting system, which comprises an index setting module, an index input module, a data acquisition module, a data processing module and a report query module, wherein the index setting module is used for adding an index formula in a self-defining manner and setting an index calculation mode; the index input module is used for inputting an index value; the data acquisition module is used for acquiring index values according to the index formula added by the index setting module; the data processing module is used for calculating and generating report data according to the index value acquired by the data acquisition module and the index formula added by the index setting module; and the report query module is used for generating a report according to the report data generated by the data processing module so as to be queried by a user. The data in the business system is automatically collected, summarized and calculated, and is combined with manual reporting, so that one-time reporting and repeated multiplexing and automatic verification are realized, labor is saved, efficiency is improved, and autonomous inquiry and export are realized for the report needing to be issued and checked.
Description
Technical Field
The invention belongs to the technical field of power plant production data processing, and relates to a power plant production data reporting system.
Background
The existing power plant business system and management and control system have the defects that statistics analysis is completed manually, a great deal of effort is consumed by management staff, the automation level is low, although staff of each department are organized and configured according to groups, the informatization level is low, the working efficiency is low, and the staff deficiency phenomenon is common.
Disclosure of Invention
In order to solve the defects in the prior art, the application provides a power plant production data reporting system, which is used for automatically collecting, summarizing and calculating production and operation data in a business system, realizing one-time reporting and repeated multiplexing by combining manual reporting, automatically checking, saving labor, improving efficiency, and realizing autonomous inquiry and export for reports needing to be issued and checked.
In order to achieve the above object, the present application adopts the following technical scheme:
the utility model provides a power plant production data reporting system, includes index setting module, index entry module, data acquisition module, data processing module and report query module, its characterized in that:
the index setting module is used for adding an index formula in a self-defined mode and setting an index calculation mode;
the index input module is used for inputting an index value;
the data acquisition module is used for acquiring index values according to the index formula added by the index setting module;
the data processing module is used for calculating and generating report data according to the index value acquired by the data acquisition module and the index formula added by the index setting module;
and the report query module is used for generating a report according to the report data generated by the data processing module so as to be queried by a user.
The invention further comprises the following preferable schemes:
preferably, in the index setting module, the index formula is composed of index groups, index codes, index types and index calculation formulas, and indicates index calculation modes of different index groups, index codes and index types;
the index group comprises a machine furnace, environmental protection, electric and water dissolving;
the index types are divided into accumulation numbers, shifts, days, months and years;
the index calculation formula comprises a product index real-time taking formula, a class index real-time taking formula, a day index real-time taking formula, a class index table code conversion formula, a day index class index conversion formula, a month index day index conversion formula and a reference index calculation formula, and is respectively used for realizing product index real-time taking, class index real-time taking, day index real-time taking, class index table code conversion, day index class index conversion, month index conversion, year index month index conversion and reference index calculation;
the real-time counting formula contains index counting measuring points which are divided into summation type real-time counting measuring points and average type real-time counting measuring points.
Preferably, in the index recording module, fuel data, a fixed value and internet power are recorded in sequence, the recorded data are all stored in a relational database, and the relational database stores complete index information, including an index ID, an index name, an index code, an index type, an index grouping, an index calculation formula, generation time, modification time, a current period value and a previous period value;
the index recording module comprises a fuel data synchronization sub-module, a fixed value recording sub-module, an internet power recording sub-module and an index filling module;
the fuel data synchronization sub-module is used for synchronizing the fuel data in the fuel intermediate library to the relational library so as to realize automatic input of the fuel data;
the fixed value recording submodule is used for adding fixed data in the normal running period of the unit into a fixed value, and recording the condition which accords with the running condition of the unit into a relational library;
the online electric quantity recording submodule is used for recording the online electric quantity of the province, and is provided with a recalculation submodule used for controlling the intelligent report system to recalculate report data of a specified date;
the index filling module is used for assisting in modifying the input index value.
Preferably, the index information recorded in the index filling module includes a shift index and a day index.
Preferably, in the data acquisition module, real-time or historical production data, namely measurement point values, are acquired from a production database according to an index calculation formula in an index formula, and the stored index values recorded by the index reporting module are acquired from a relational database.
Preferably, in the data acquisition module, when real-time or historical production data is acquired from a production database, multi-process acquisition is adopted;
when the index values recorded by the index filling module are collected from the relational library, the collection tasks are reasonably distributed to each micro-service for collection by using load balancing.
Preferably, the data processing module independently calculates each index by adopting multiple processes, ensures that other indexes are not influenced due to the problem of a certain index, calculates to obtain report data, stores the calculated index data in a relational database, and the report query module fetches and displays the report data from the relational database.
Preferably, the report inquiry module comprises a daily report sub-module, a monthly report sub-module, a yearly report sub-module and a department report sub-module,
the daily report sub-module, the monthly report sub-module, the annual report sub-module and the department report sub-module are respectively provided with corresponding report templates for automatically generating daily, monthly, annual and department reports of each day according to report data generated by the data processing module for users to inquire;
the department report submodule is used for automatically generating each department report, wherein the department report comprises a class report, an economic index competition report and a real-time report.
Preferably, in the report query module, the report template is divided into a moist dry report and an excel table;
the report is configured by a structured query language;
and configuring a fetch formula in the excel table, and fetching by using the fetch formula.
Preferably, the intelligent report system further comprises a report tool module, wherein the report tool module is used for providing a report editing tool to realize report maintenance and self definition;
the report tool module comprises an index tracking sub-module, an index analysis sub-module, an index replacement sub-module, an index eliminating sub-module, a designated index trial operation sub-module, a designated index recalculation sub-module, an error log sub-module, an index comparison analysis sub-module, a measuring point maintenance sub-module, a measuring point detection sub-module, a recalculation strategy sub-module, an economic index competition report modification sub-module, a coal blending and burning sub-module, an Excel uploading sub-module and an Excel editing sub-module;
the index tracking sub-module is used for displaying the relation among the indexes in a visual mode, correlating with the index values, and tracking and positioning abnormal indexes through the indexes when the index values are abnormal;
the index analysis submodule is used for freely selecting index codes and dates and automatically generating an excel table corresponding to the index codes and dates to show the index value of the selected index on the selected date, and if the fluctuation range of the index value exceeds the fluctuation range, the index value changes in color or shows the change trend of the index in a graphical mode;
the index replacement sub-module is used for correcting the abnormal index value, and when the production database has a problem, the acquired data do not accord with the normal data, and a correct value is given to replace the abnormal index value to participate in calculation;
the index eliminating sub-module is used for eliminating index data in the shutdown period;
the specified index test operation sub-module is used for performing test operation on the specified index to check whether the index formula is correct or not after the index formula is added by the index setting module, and the test operation result is not input into the relation library;
the specified index recalculation sub-module is used for recalculating the specified index after modifying some source data;
the error log sub-module is used for monitoring the whole process in the recalculation process, recording the problem index of index calculation failure into an error log, and analyzing error reasons or recalculating error indexes according to the error log;
the index comparison analysis submodule is used for freely selecting time and fluctuation range, comparing and analyzing the data of the selected time, and summarizing and displaying indexes with difference values exceeding the fluctuation range;
the measuring point maintenance submodule is used for adding measuring points in an index formula to be maintained;
the measuring point monitoring sub-module is used for monitoring the measuring points added in the measuring point maintenance sub-module in real time and pushing alarm information when abnormality occurs;
the recalculation strategy sub-module is used for cascading recalculation of indexes related to the modified indexes by adding the recalculation strategy after the indexes are modified;
the economic index competition report form modification submodule is used for eliminating the economic index influenced by start-up and stop or artificially adjusting the economic index influenced by start-up and stop into a correct economic index;
the coal blending and blending sub-module is used for adding coal types and test values thereof according to actual conditions, customizing blending and blending strategies, and automatically combining into various blending and blending results to form a blending and blending scheme so as to intelligently guide actual production;
the Excel uploading sub-module is used for customizing an Excel template and uploading the Excel template to the intelligent reporting system to form a reporting template;
the Excel editing sub-module is used for editing the custom Excel template, configuring a numerical formula and forming a report.
The beneficial effect that this application reached:
1. according to the method, various reports are automatically generated according to the self-defined addition index formula by utilizing the real-time/historical production process data stored in the production database, so that the user production statistical requirements are met;
2. according to actual needs, the report is published in various modes through a report display module, such as Excel publication, web publication and the like, wherein when Excel publication is carried out, the report required by users to be published through various templates selected by users is supported, and the Web automatically publishes some conventional report data;
3. besides providing production process data, historical data query, statistics and report making, the method can query the start and stop of the unit through a real-time report under a department report, count the running time of the unit, the running time of the coal mill, the running time of the induced draft fan and the running state of the induced draft fan in real time, and query, statistics and analysis on main equipment and state information of the unit.
4. According to the method and the device, through the index analysis submodule, the historical trend graphs of all data in the report list can be rapidly inquired, and operation staff can conveniently analyze various index data.
Drawings
FIG. 1 is a schematic diagram of a power plant production data reporting system.
Detailed Description
The present application is further described below with reference to the accompanying drawings. The following examples are only for more clearly illustrating the technical solutions of the present invention and are not intended to limit the scope of protection of the present application.
As shown in fig. 1, the power plant production data reporting system comprises an index setting module, an index input module, a data acquisition module, a data processing module and a report query module;
the index setting module is used for adding an index formula in a self-defined mode and setting an index calculation mode;
in the embodiment of the application, the index formula consists of index groups, index codes, index types and index calculation formulas, and indicates index calculation modes of different index groups, index codes and index types;
the index grouping and the index coding can be freely set by a user, for example:
the index grouping comprises a machine furnace, environmental protection, electric and water dissolving and the like;
the index code consists of Arabic numerals and comprises items, units and specific code information;
the method comprises the following steps: the first number in the index code determines which unit the index belongs to in several stages, the second number determines which unit the index belongs to, and the last four or more digits represent the specific code;
for example, a power plant has four units, wherein one-two units belong to a first-period project, three-four units belong to a second-period project, an index 230001,2 indicates the second period, 3 indicates the 3-unit, and 0001 is a specific code.
The index types are divided into accumulation numbers, shifts, days, months and years;
the index calculation formula comprises a product index real-time taking formula, a class index real-time taking formula, a day index real-time taking formula, a class index table code conversion formula, a day index class index conversion formula, a month index day index conversion formula and a reference index calculation formula, and is respectively used for realizing product index real-time taking, class index real-time taking, day index real-time taking, class index table code conversion, day index class index conversion, month index conversion, year index month index conversion and reference index calculation;
the product index is only used as a calculation process index, and the class index is generally used as an economic competition index.
The real-time counting formula contains index counting measuring points which are divided into summation type real-time counting measuring points and average type real-time counting measuring points.
In the embodiment of the application, the sum type real-time sampling measurement point index is defined to be a product index,
the product index formula corresponds to the product index real-time sampling,
the shift index calculation formula corresponds to shift index table code conversion,
the daily index calculation formula corresponds to daily index table code conversion,
the month index calculation formula corresponds to the conversion of month index daily index,
the annual index calculation formula corresponds to annual index month index conversion,
the real-time sampling measurement point index of the average class is defined without defining a product index,
the class index calculation formula corresponds to the class index real-time fetch,
the daily index calculation formula corresponds to the daily index real-time number,
the month index calculation formula corresponds to the conversion of month index daily index,
the annual index calculation formula corresponds to annual index month index conversion;
the table code conversion type formulas are accumulated by taking the corresponding product index as the bottom, and the index conversion type formulas are accumulated or averaged by taking the corresponding sub-level index as the bottom.
For example, for an index whose index code is 230001, the product index calculation formula defined is: the product index is obtained in real time ("measuring point, @ DATETIME"), and the defined class index calculation formula is as follows: the shift index table code conversion ("230001") defines the daily index calculation formula: daily index table code conversion ("230001"), the defined month index calculation formula is: month index daily index conversion ("230001, SUM"), the annual index calculation formula defined by it is: year index month index conversion ("230001, sum");
the index code is 230437 index, and the defined class index calculation formula is: the real-time taking of the class index (measuring point, @ DATETIME, @ SHIFTSYSTEMID, @ SHIFTID, AVG'), the daily index calculation formula defined is: the date index is obtained in real time ("measuring point, @ DATETIME, @ DATETIME, AVG"), and a defined month index calculation formula is as follows: month index daily index conversion ("230437, avg"), the annual index calculation formula defined by it is: year index and month index conversion ('230437, AVG')
Referencing class index formulas can only be peer referenced, for example: class index reference class index-class index ("241326") -class index ("240190"), day index reference class index-day index ("200866")/day index ("200412") -100.
The index input module is used for inputting an index value;
and the index recording module records fuel data, a fixed value and internet surfing electric quantity in sequence, and the recorded data are stored in the relational database.
The relation library stores complete index information, including index ID, index name, index code, index type, index grouping, index calculation formula, generation time, modification time, current period value and previous period value.
The relational database, i.e. relational database, for example uses the oracle database.
The index recording module comprises a fuel data synchronization sub-module, a fixed value recording sub-module, an internet power recording sub-module and an index filling module;
the fuel data synchronization sub-module is used for synchronizing the fuel data in the fuel intermediate library to the relational library so as to realize automatic input of the fuel data;
the fixed value recording submodule is used for adding fixed data in the normal running period of the unit into a fixed value, and recording the condition which accords with the running condition of the unit into a relational library;
for example, the third machine is operated, and the fourth machine is stopped; stopping the third machine and running the fourth machine;
the online electric quantity input submodule is used for inputting the online electric quantity of the province network, and because the online electric quantity is the last input data, the online electric quantity input submodule is provided with a recalculation submodule used for controlling the intelligent report system to recalculate report data of a specified date;
the index filling module is used for carrying out auxiliary modification and input of index values in the index filling module when special conditions, such as numerical change of a fuel intermediate warehouse, occur.
In general, the index is recorded without being performed in an index filling module, wherein the first step of recording the index is to record fuel data, the second step is to record a fixed value, and the third step is to record the network electric quantity. And after the network power is input, clicking to generate a report.
The fuel data, the internet power and the fixed value are all recorded indexes, and the fuel data synchronous submodule, the fixed value recording submodule and the internet power recording submodule greatly reduce the workload of a user and can record all recorded indexes only by a few points under normal conditions. When special conditions occur, such as changing the numerical value of the fuel intermediate warehouse, the input value needs to be manually modified in the index filling module.
The index input needs to be filled with more data, including fuel data and the internet power. The fuel data synchronization submodule reduces the workload of a user, and the direct selection time is needed to be synchronized from the fuel intermediate library. The online electric quantity input submodule has less filling data, is convenient for users to fill, comprises a recalculation button, records the selected recalculation date of the online electric quantity, and can call a calculation engine to recalculate a report by dot recalculation on the day before defaulting.
The index information input by the index reporting module is divided into a class index and a daily index.
The data acquisition module is used for acquiring index data according to the index formula added by the index setting module, namely acquiring real-time or historical production data, namely measuring point values, from the production database according to index grouping, index coding and index types in the index formula, and acquiring the index values recorded by the index recording module stored in the relation library;
the production data comprise the temperature, pressure, electric quantity and the like of the unit.
For example, the index code is 230001, the daily index calculation formula is daily index table code conversion ("230001"), the data acquisition module acquires the index group, index code, index type and index calculation formula of the index, searches the product index of the index according to the index calculation formula, and the product index calculation formula is the product index real-time number of measurement points ("measurement points, @ DATETIME"), and performs the number calculation according to the measurement points in the product index calculation formula.
The index code is 230190, the daily index calculation formula is daily index class index conversion ('230190, SUM'), the data acquisition module acquires the index group, index code, index type and index calculation formula of the index, searches the class index of the index according to the index calculation formula, the class index is the input index, and the index is input to the relation library if the calculation formula is not available.
When real-time or historical production data is acquired from a production database, the acquisition speed is increased by adopting multi-process acquisition;
when the index values recorded by the index filling module stored in the relation library are collected, the collection tasks are reasonably distributed to each micro service for collection by using load balancing, so that the pressure of the service is reduced, and the collection speed is improved.
The data processing module is used for calculating and generating report data according to the index value acquired by the data acquisition module and the index formula added by the index setting module; specific:
the data processing module independently calculates each index by adopting multiple processes, so that other indexes are not influenced due to the fact that a certain index is problematic, and the calculated index value is written into the relation library.
The data processing module independently calculates each index by adopting multiple processes, ensures that other indexes are not influenced due to the problem of a certain index, calculates to obtain report data, stores the calculated index data in a relational database, and the report query module fetches and displays the report data from the relational database.
The report query module is used for generating a report according to the report data generated by the data processing module, so that a user can query the report, and the user can freely select a report template to query the report of each day in the past, and the report query module is specific:
the report inquiry module comprises a daily report sub-module, a month report sub-module, a year report sub-module and a department report sub-module, wherein the daily report sub-module, the month report sub-module, the year report sub-module and the department report sub-module are respectively provided with corresponding report templates for automatically generating daily, month, year and department reports of each day according to report data generated by the data processing module for inquiry of users; the visual display of the report is realized, the scheduling according to the needs is realized, the report specificity of the final display is high, the report generation is fully automatic, and the working pressure of regulatory personnel is reduced.
The indexes of the work, day, month and year have a corresponding record every day, and the corresponding report forms are changed in the same way as the report form display data of each day, so that the past report forms can be checked through a time selection frame.
The product index is only used as a calculation process index, the readability is poor, the product index is not displayed generally, the class index is generally used as an economic competition index, the class index is generally only provided with one or more reports, and the product index is generally not displayed as an independent report module.
The department report submodule is used for automatically generating each department report, wherein the department report comprises a class report, an economic index competition report and a real-time report.
The economic index is a competition index among various values of the power plant and comprises the generated energy, the load rate and the exhaust gas temperature;
the economic index competition report refers to a report with various values for competition comparison, such as five values of A, B, D and E, each value corresponds to a respective class index, and the economic index competition report is formed by calculation and summarization.
The real-time report is a real-time calculation type report, certain class indexes and certain daily indexes are counted in real time, and the general counted indexes are set operation hour indexes, coal mill operation hour indexes and fan operation hour indexes. The report is generally only one or a few, so that the report is used by which department without a separate dividing module.
The report template is divided into a moist dry report and an excel form;
the report is configured by a structured query language, such as writing sql at rpx for fetching;
the excel table is provided with a fetch formula, and the fetch formula is used for fetching; the configured report template is used for being called by a report query module.
The fetch formula is used to fetch, for example $func (a, b, c, d), where $func () is in a fixed format, a represents the pointer encoding, b, c, d in combination uniquely determines the pointer.
b takes an integer value which can be 1-4, takes 1 to represent a shift, takes 2 to represent a shift, takes 3 to represent a night shift and takes 4 to represent a non-shift index; c takes integer value which can be 1-3, takes 1 to represent daily index, takes 2 to represent month index and takes 3 to represent class index; d is an integer value which can be 1-7, 1 is taken to represent annual accumulation, 2 is taken to represent cyclic ratio, 3 is taken to represent class-to-class ratio, 4 is taken to represent common index, 5 is taken to represent contemporaneous accumulation, 6 is taken to represent annual accumulation average, and 7 is taken to represent contemporaneous annual accumulation average; if d is not 4 then c may be optionally one from 1 to 3 and b may be optionally one from 1 to 4.
Taking the generating capacity 230001 of machine number 3 as an example:
the $ func (230001,4,1,4) represents a daily index of the power generation amount of the No. 3 machine;
the $ func (230001,1,3,4) represents the white shift power generation of machine number 3;
the $ func (230001,4,3,1) represents annual cumulative power production of machine number 3.
The intelligent report system also comprises a report tool module, wherein the report tool module is used for providing a report editing tool to realize report maintenance and self definition, and is specific to the report tool module:
the report tool module comprises an index tracking sub-module, an index analysis sub-module, an index replacement sub-module, an index eliminating sub-module, a designated index trial operation sub-module, a designated index recalculation sub-module, an error log sub-module, an index comparison analysis sub-module, a measuring point maintenance sub-module, a measuring point detection sub-module, a recalculation strategy sub-module, an economic index competition report modification sub-module, a coal blending and burning sub-module, an Excel uploading sub-module and an Excel editing sub-module;
the index tracking sub-module is used for displaying the relation among indexes in a visual mode through a recursion algorithm and correlating with the index values, and when the index values are abnormal, the abnormal indexes can be accurately positioned through index tracking, so that production can be accurately guided, labor force of field personnel is reduced, and personnel reduction and synergy are realized;
the index analysis submodule is used for freely selecting index codes and dates and automatically generating an excel table corresponding to the index codes and dates to show the index value of the selected index on the selected date, and if the fluctuation range of the index value exceeds the fluctuation range, the index value changes in color or shows the change trend of the index in a graphical mode;
the index replacement sub-module is used for correcting the abnormal index value, and when the production database has a problem, the acquired data do not accord with the normal data, and a correct value is given to replace the abnormal index value to participate in calculation;
the index eliminating sub-module is used for eliminating index data in the shutdown period without participating in operation due to a large gap between indexes in the shutdown period and normal indexes, so that no problem exists in the shutdown data or startup data;
the specified index test operation sub-module is used for performing test operation on the specified index to check whether the index formula is correct or not after the index formula is added by the index setting module, and the test operation result is not written into the relation library;
the specified index recalculation sub-module is used for recalculating the specified index after modifying some source data, so that full calculation is avoided, the index calculation amount is reduced, and the calculation time is saved; for example, the index 230953, i.e. the 3A desulfurization, if the calculation formula of the index is modified, it needs to be recalculated; if the index is replaced by an index replacement sub-module, recalculation is also required.
The error log sub-module is used for monitoring the whole process in the recalculation process, recording the problem index of index calculation failure into an error log, and analyzing error reasons or recalculating error indexes according to the error log;
the index comparison analysis submodule is used for freely selecting time, such as 2020-05-14 and fluctuation range, comparing and analyzing the data of 2020-05-14 and 2020-05-13, and summarizing and displaying indexes with difference exceeding the fluctuation range;
the measuring point maintenance submodule is used for adding measuring points in an index formula to be maintained;
the measuring point monitoring sub-module is used for monitoring the measuring points added in the measuring point maintenance sub-module in real time and pushing alarm information when abnormality occurs; for example, the measurement point value does not update for a long time, and the measurement point value fluctuates greatly.
The recalculation strategy sub-module is used for adding the recalculation strategy after the index replacement sub-module or the index filling sub-module modifies the index, and cascading the recalculation of the index related to the modified index, so that the workload of operators is reduced, and the self-consistency and consistency of the report are ensured;
the economic index competition report form modification submodule is used for eliminating the economic index influenced by start-up and stop or artificially adjusting the economic index influenced by start-up and stop into a normal economic index;
the economic index is a competition index among various values of the power plant, and comprises the generated energy, the load rate, the exhaust gas temperature and the like.
Under the influence of start-up and shut-down, the temperature and pressure economic indexes have larger fluctuation, and have the public compliance when participating in the competition of the economic indexes, and a normal value can be abandoned or replaced at the moment.
The coal blending and blending sub-module is used for adding coal types and test values thereof according to actual conditions, customizing blending and blending strategies, and automatically combining into various blending and blending results to form a blending and blending scheme so as to intelligently guide actual production;
the blending coal blending and burning submodule is a tool for guiding production, a user selects coal types and proportions, the selected coal types are analyzed, the blending and burning result is calculated, and when the selected coal types are more than three, the blending and burning result is formed by arranging and combining. The result is not stored, nor called the calculation engine, and is a special sub-module in the report tool.
The Excel uploading sub-module is used for customizing an Excel template and uploading the Excel template to the intelligent reporting system to form a reporting template;
the Excel editing sub-module is used for editing the custom Excel template, configuring a numerical formula and forming a report.
While the applicant has described and illustrated the embodiments of the present invention in detail with reference to the drawings, it should be understood by those skilled in the art that the above embodiments are only preferred embodiments of the present invention, and the detailed description is only for the purpose of helping the reader to better understand the spirit of the present invention, and not to limit the scope of the present invention, but any improvements or modifications based on the spirit of the present invention should fall within the scope of the present invention.
Claims (8)
1. The utility model provides a power plant production data reporting system, includes index setting module, index entry module, data acquisition module, data processing module and report query module, its characterized in that:
the index setting module is used for adding an index formula in a self-defined mode and setting an index calculation mode;
the index input module is used for inputting an index value;
the data acquisition module is used for acquiring index values according to the index formula added by the index setting module;
the data processing module is used for calculating and generating report data according to the index value acquired by the data acquisition module and the index formula added by the index setting module;
the report query module is used for generating a report according to the report data generated by the data processing module so as to be queried by a user;
in the index setting module, an index formula consists of index groups, index codes, index types and index calculation formulas, and indicates index calculation modes of different index groups, index codes and index types;
the index group comprises a machine furnace, environmental protection, electric and water dissolving;
the index types are divided into accumulation numbers, shifts, days, months and years;
the index calculation formula comprises a product index real-time taking formula, a class index real-time taking formula, a day index real-time taking formula, a class index table code conversion formula, a day index class index conversion formula, a month index day index conversion formula and a reference index calculation formula, and is respectively used for realizing product index real-time taking, class index real-time taking, day index real-time taking, class index table code conversion, day index class index conversion, month index conversion, year index month index conversion and reference index calculation;
the real-time counting formula comprises index counting measuring points which are divided into summation type real-time counting measuring points and averaging type real-time counting measuring points;
the system comprises an index input module, a relation library, a data storage module and a data storage module, wherein the index input module sequentially inputs fuel data, a fixed value and internet power, the input data are all stored in the relation library, and the relation library stores complete index information which comprises an index ID, an index name, an index code, an index type, an index grouping, an index calculation formula, generation time, modification time, a current period value and a previous period value;
the index recording module comprises a fuel data synchronization sub-module, a fixed value recording sub-module, an internet power recording sub-module and an index filling module;
the fuel data synchronization sub-module is used for synchronizing the fuel data in the fuel intermediate library to the relational library so as to realize automatic input of the fuel data;
the fixed value recording submodule is used for adding fixed data in the normal running period of the unit into a fixed value, and recording the condition which accords with the running condition of the unit into a relational library;
the online electric quantity recording submodule is used for recording the online electric quantity of the province, and is provided with a recalculation submodule used for controlling the intelligent report system to recalculate report data of a specified date;
the index filling module is used for assisting in modifying the input index value;
the intelligent report system also comprises a report tool module, wherein the report tool module is used for providing a report editing tool and realizing report maintenance and self definition;
the report tool module comprises an index tracking sub-module, an index analysis sub-module, an index replacement sub-module, an index eliminating sub-module, a designated index trial operation sub-module, a designated index recalculation sub-module, an error log sub-module, an index comparison analysis sub-module, a measuring point maintenance sub-module, a measuring point detection sub-module, a recalculation strategy sub-module, an economic index competition report modification sub-module, a coal blending and burning sub-module, an Excel uploading sub-module and an Excel editing sub-module.
2. A plant production data reporting system as in claim 1, wherein:
the index information input in the index filling module comprises a class index and a daily index.
3. A plant production data reporting system as in claim 1, wherein:
and in the data acquisition module, real-time or historical production data, namely measuring point values, are acquired from a production database according to an index calculation formula in an index formula, and the stored index values recorded by the index reporting module are acquired from a relational database.
4. A plant production data reporting system as in claim 3, wherein:
in the data acquisition module, when real-time or historical production data is acquired from a production database, multi-process acquisition is adopted;
when the index values recorded by the index filling module are collected from the relational library, the collection tasks are reasonably distributed to each micro-service for collection by using load balancing.
5. A plant production data reporting system as in claim 1, wherein:
the data processing module independently calculates each index by adopting multiple processes to obtain report data, meanwhile, the calculated index data is stored in a relational database, and the report query module obtains numbers from the relational database and displays the numbers.
6. A plant production data reporting system as in claim 1, wherein:
the report inquiry module comprises a daily report sub-module, a monthly report sub-module, a annual report sub-module and a department report sub-module,
the daily report sub-module, the monthly report sub-module, the annual report sub-module and the department report sub-module are respectively provided with corresponding report templates for automatically generating daily, monthly, annual and department reports of each day according to report data generated by the data processing module for users to inquire;
the department report submodule is used for automatically generating each department report, wherein the department report comprises a class report, an economic index competition report and a real-time report.
7. A plant production data reporting system as in claim 1, wherein:
in the report query module, the report template is divided into a wet and dry report and an excel form;
the report is configured by a structured query language;
and configuring a fetch formula in the excel table, and fetching by using the fetch formula.
8. A plant production data reporting system as in claim 1, wherein:
the index tracking sub-module is used for displaying the relation among the indexes in a visual mode, correlating with the index values, and tracking and positioning abnormal indexes through the indexes when the index values are abnormal;
the index analysis submodule is used for freely selecting index codes and dates and automatically generating an excel table corresponding to the index codes and dates to show the index value of the selected index on the selected date, and if the fluctuation range of the index value exceeds the fluctuation range, the index value changes in color or shows the change trend of the index in a graphical mode;
the index replacement sub-module is used for correcting the abnormal index value, and when the production database has a problem, the acquired data do not accord with the normal data, and a correct value is given to replace the abnormal index value to participate in calculation;
the index eliminating sub-module is used for eliminating index data in the shutdown period;
the specified index test operation sub-module is used for performing test operation on the specified index to check whether the index formula is correct or not after the index formula is added by the index setting module, and the test operation result is not input into the relation library;
the specified index recalculation sub-module is used for recalculating the specified index after modifying some source data;
the error log sub-module is used for monitoring the whole process in the recalculation process, recording the problem index of index calculation failure into an error log, and analyzing error reasons or recalculating error indexes according to the error log;
the index comparison analysis submodule is used for freely selecting time and fluctuation range, comparing and analyzing the data of the selected time, and summarizing and displaying indexes with difference values exceeding the fluctuation range;
the measuring point maintenance submodule is used for adding measuring points in an index formula to be maintained;
the measuring point monitoring sub-module is used for monitoring the measuring points added in the measuring point maintenance sub-module in real time and pushing alarm information when abnormality occurs;
the recalculation strategy sub-module is used for cascading recalculation of indexes related to the modified indexes by adding the recalculation strategy after the indexes are modified;
the economic index competition report form modification submodule is used for eliminating the economic index influenced by start-up and stop or artificially adjusting the economic index influenced by start-up and stop into a correct economic index;
the coal blending and blending sub-module is used for adding coal types and test values thereof according to actual conditions, customizing blending and blending strategies, and automatically combining into various blending and blending results to form a blending and blending scheme so as to intelligently guide actual production;
the Excel uploading sub-module is used for customizing an Excel template and uploading the Excel template to the intelligent reporting system to form a reporting template;
the Excel editing sub-module is used for editing the custom Excel template, configuring a numerical formula and forming a report.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010680114.0A CN112037083B (en) | 2020-07-15 | 2020-07-15 | Power plant production data reporting system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010680114.0A CN112037083B (en) | 2020-07-15 | 2020-07-15 | Power plant production data reporting system |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN112037083A CN112037083A (en) | 2020-12-04 |
| CN112037083B true CN112037083B (en) | 2024-02-23 |
Family
ID=73579142
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202010680114.0A Active CN112037083B (en) | 2020-07-15 | 2020-07-15 | Power plant production data reporting system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN112037083B (en) |
Families Citing this family (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112668939B (en) * | 2021-01-18 | 2024-07-16 | 大连海事大学 | Automatic enterprise performance evaluation method and system based on ExcelVBA technology |
| CN112862314A (en) * | 2021-02-08 | 2021-05-28 | 国能信控互联技术有限公司 | Thermal power plant production and operation environment index reporting management system |
| CN113255307A (en) * | 2021-06-15 | 2021-08-13 | 国能信控互联技术有限公司 | Intelligent reporting method and system for power system |
| CN114037397A (en) * | 2021-09-24 | 2022-02-11 | 华能汕头海门发电有限责任公司 | Power plant production report generating and sending system |
| CN114049036A (en) * | 2021-11-24 | 2022-02-15 | 广东电网有限责任公司 | Data computing platform, method, device and storage medium |
Citations (12)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2007076625A1 (en) * | 2005-12-30 | 2007-07-12 | Mingde Yin | Intelligent data processing system and method for managing performance |
| CN101739454A (en) * | 2009-12-29 | 2010-06-16 | 用友软件股份有限公司 | Data processing system |
| CN101944082A (en) * | 2010-09-10 | 2011-01-12 | 中国恩菲工程技术有限公司 | Excel-like report processing method |
| CN102750654A (en) * | 2011-04-20 | 2012-10-24 | 中国南方电网有限责任公司 | Power dispatching information disclosure platform for large power grid |
| CN102800028A (en) * | 2012-06-19 | 2012-11-28 | 山西太钢不锈钢股份有限公司 | Energy quality management system of WEB-based distributed multilevel software system |
| CN103606045A (en) * | 2013-11-20 | 2014-02-26 | 国家电网公司 | Report form generation method and report form system |
| CN104156801A (en) * | 2014-07-17 | 2014-11-19 | 国网山东省电力公司 | Benchmarking data processing system and data processing method for municipal company teams |
| CN104573977A (en) * | 2015-01-24 | 2015-04-29 | 武钢集团昆明钢铁股份有限公司 | Quality data management system and method |
| CN104574217A (en) * | 2015-01-22 | 2015-04-29 | 国家电网公司 | Intelligent power distribution network online risk assessment method |
| CN106156948A (en) * | 2016-06-29 | 2016-11-23 | 阜阳华润电力有限公司 | Coal-fired power plant's fuel management system |
| CN109034445A (en) * | 2018-06-08 | 2018-12-18 | 广东红海湾发电有限公司 | A kind of market-oriented electric power management system and method |
| WO2019233047A1 (en) * | 2018-06-07 | 2019-12-12 | 国电南瑞科技股份有限公司 | Power grid dispatching-based operation and maintenance method |
Family Cites Families (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20040225521A1 (en) * | 2003-01-24 | 2004-11-11 | Jose Acosta | Database system and method for managing labor costs against indicators |
-
2020
- 2020-07-15 CN CN202010680114.0A patent/CN112037083B/en active Active
Patent Citations (12)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2007076625A1 (en) * | 2005-12-30 | 2007-07-12 | Mingde Yin | Intelligent data processing system and method for managing performance |
| CN101739454A (en) * | 2009-12-29 | 2010-06-16 | 用友软件股份有限公司 | Data processing system |
| CN101944082A (en) * | 2010-09-10 | 2011-01-12 | 中国恩菲工程技术有限公司 | Excel-like report processing method |
| CN102750654A (en) * | 2011-04-20 | 2012-10-24 | 中国南方电网有限责任公司 | Power dispatching information disclosure platform for large power grid |
| CN102800028A (en) * | 2012-06-19 | 2012-11-28 | 山西太钢不锈钢股份有限公司 | Energy quality management system of WEB-based distributed multilevel software system |
| CN103606045A (en) * | 2013-11-20 | 2014-02-26 | 国家电网公司 | Report form generation method and report form system |
| CN104156801A (en) * | 2014-07-17 | 2014-11-19 | 国网山东省电力公司 | Benchmarking data processing system and data processing method for municipal company teams |
| CN104574217A (en) * | 2015-01-22 | 2015-04-29 | 国家电网公司 | Intelligent power distribution network online risk assessment method |
| CN104573977A (en) * | 2015-01-24 | 2015-04-29 | 武钢集团昆明钢铁股份有限公司 | Quality data management system and method |
| CN106156948A (en) * | 2016-06-29 | 2016-11-23 | 阜阳华润电力有限公司 | Coal-fired power plant's fuel management system |
| WO2019233047A1 (en) * | 2018-06-07 | 2019-12-12 | 国电南瑞科技股份有限公司 | Power grid dispatching-based operation and maintenance method |
| CN109034445A (en) * | 2018-06-08 | 2018-12-18 | 广东红海湾发电有限公司 | A kind of market-oriented electric power management system and method |
Non-Patent Citations (9)
| Title |
|---|
| Economic evaluation of power system dispatch with hesitant fuzzy uncertain linguistic information;Liu Dunnan，等;JOURNAL OF INTELLIGENT & FUZZY SYSTEMS;第37卷(第2期);1761–1768 * |
| Wu Yunna，等.Optimal Site Selection of Tidal Power Plants Using a Novel Method: A Case in China.2016,第10卷(第9期),1-26. * |
| 基于B/S架构的自主生成报表引擎系统设计与实现;戚平;何俊博;;电子设计工程(第08期);78-82 * |
| 基于SIS的实时考核报表系统的开发与应用;赵玉良;吴文祥;李郁;;热力发电(第11期);77-80 * |
| 基于数据集成平台的医院智能报表系统的构建;莫远明;王毅;林琳;张武军;;现代医院(第04期);108-111 * |
| 开放式发电企业经济指标系统分析和架构;王锋;;电力信息化(第02期);64-67 * |
| 燃煤电厂智慧管控系统(IMS)研发与应用;李巍，等;《科技成果登记表》;1-3 * |
| 电力生产信息统计报表生成器的设计与实现;石光亮, 王拓, 弋长青, 张根周;电力系统自动化(第21期);86-88 * |
| 陈德新.《发电厂计算机监控》.黄河水利出版社,2007,192-194. * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN112037083A (en) | 2020-12-04 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN112037083B (en) | Power plant production data reporting system | |
| CN111191878A (en) | Abnormal analysis based station area and electric energy meter state evaluation method and system | |
| CN113760625B (en) | Evaluation method and monitoring system for model predictive controller performance | |
| CN102375449A (en) | Database optimized storage and query method based on industrial control field | |
| CN115689177A (en) | Machine learning-based intelligent scheduling strategy method for transformer maintenance plan | |
| CN115017214B (en) | Hydropower station auxiliary equipment operation state analysis early warning method, device and storage medium | |
| CN112862314A (en) | Thermal power plant production and operation environment index reporting management system | |
| CN111813057A (en) | Energy management system of cement production plant | |
| CN113255307A (en) | Intelligent reporting method and system for power system | |
| CN118100449B (en) | Micro-grid configuration management system based on data center platform | |
| CN114036206A (en) | Multi-energy information management system based on time sequence database | |
| CN112446608A (en) | OEE and Andon safety lamp management system and working method thereof | |
| CN110633916A (en) | Energy efficiency control system for coal mine enterprise | |
| CN111141950A (en) | Method for judging and repairing time-sharing code abnormality of electric meter of metering automation system | |
| CN115271390A (en) | Carbon neutralization system based on industrial park | |
| CN118261562A (en) | Intelligent operation system and method based on large hydropower station equipment analysis | |
| CN114330770A (en) | Method, device and system for acquiring equipment status report | |
| CN116431701A (en) | Comprehensive power plant production data analysis and statistics system | |
| CN118096061A (en) | Power grid load acquisition management and control platform | |
| CN116385210B (en) | Power supply energy consumption monitoring system based on Internet of things | |
| CN107045548B (en) | System and method for calculating wind power energy utilization rate | |
| CN115951172A (en) | Method, device and equipment for positioning metering point of abnormal unbalanced electric quantity of bus | |
| CN114897394A (en) | Power consumption monitoring system and method | |
| CN108154281A (en) | Natural gas purification plant energy consumption evaluation method and device | |
| CN113989002A (en) | Construction project financial data management and control method and system |
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 | ||
| CB02 | Change of applicant information | ||
| CB02 | Change of applicant information |
Address after: Room 618 and 619, Floor 6, Building 301, Guodian New Energy Institute, No. 9, Yingcai North 2nd Street, Future Science and Technology City, Changping District, Beijing 102211 Applicant after: Guoneng xinkong Internet Technology Co.,Ltd. Address before: Building 1, yard 16, West Fourth Ring Middle Road, Haidian District, Beijing 100039 Applicant before: BEIJING HUADIAN TIANREN ELECTRIC POWER CONTROL TECHNOLOGY Co.,Ltd. |
|
| GR01 | Patent grant | ||
| GR01 | Patent grant |