CN112037083A - Production data reporting system for power plant - Google Patents

Production data reporting system for power plant Download PDF

Info

Publication number
CN112037083A
CN112037083A CN202010680114.0A CN202010680114A CN112037083A CN 112037083 A CN112037083 A CN 112037083A CN 202010680114 A CN202010680114 A CN 202010680114A CN 112037083 A CN112037083 A CN 112037083A
Authority
CN
China
Prior art keywords
index
module
report
data
sub
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.)
Granted
Application number
CN202010680114.0A
Other languages
Chinese (zh)
Other versions
CN112037083B (en
Inventor
高彦超
冯志刚
赵嘉伟
邵长军
张令
忽述彧
杨超
祝敬伟
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Beijing Huadian Tianren Power Controlling Technology Co Ltd
Original Assignee
Beijing Huadian Tianren Power Controlling Technology Co Ltd
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by Beijing Huadian Tianren Power Controlling Technology Co Ltd filed Critical Beijing Huadian Tianren Power Controlling Technology Co Ltd
Priority to CN202010680114.0A priority Critical patent/CN112037083B/en
Publication of CN112037083A publication Critical patent/CN112037083A/en
Application granted granted Critical
Publication of CN112037083B publication Critical patent/CN112037083B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Images

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06QINFORMATION 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/00Information and communication technology [ICT] specially adapted for implementation of business processes of specific business sectors, e.g. utilities or tourism
    • G06Q50/06Energy or water supply
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/24Querying
    • G06F16/245Query processing
    • G06F16/2458Special types of queries, e.g. statistical queries, fuzzy queries or distributed queries
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/24Querying
    • G06F16/245Query processing
    • G06F16/2458Special types of queries, e.g. statistical queries, fuzzy queries or distributed queries
    • G06F16/2462Approximate or statistical queries
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F40/00Handling natural language data
    • G06F40/10Text processing
    • G06F40/166Editing, e.g. inserting or deleting
    • G06F40/174Form filling; Merging
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F40/00Handling natural language data
    • G06F40/10Text processing
    • G06F40/166Editing, e.g. inserting or deleting
    • G06F40/177Editing, e.g. inserting or deleting of tables; using ruled lines
    • G06F40/18Editing, e.g. inserting or deleting of tables; using ruled lines of spreadsheets
    • YGENERAL 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
    • Y04INFORMATION OR COMMUNICATION TECHNOLOGIES HAVING AN IMPACT ON OTHER TECHNOLOGY AREAS
    • Y04SSYSTEMS 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/00Systems supporting electrical power generation, transmission or distribution
    • Y04S10/50Systems 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 production data reporting system for a power plant, which comprises an index setting module, an index inputting module, a data acquisition module, a data processing module and a report inquiring module, wherein the index setting module is used for self-defining addition of an index formula 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 values acquired by the data acquisition module and the index formula added by the index setting module; and the report inquiry module is used for generating a report according to the report data generated by the data processing module for the user to inquire. The data in the service system is automatically collected, summarized and calculated, and combined with manual filling, one-time filling and repeated multiplexing and automatic verification are realized, so that the labor is saved, the efficiency is improved, and the report needing to be published and examined is automatically inquired and exported.

Description

Production data reporting system for power plant
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 mostly complete statistical analysis in a manual mode in a report form, consume a great deal of energy of management personnel, have low automation level, and even though personnel of each department are compiled and configured according to a group, the informatization level is not high, the working efficiency is low, and the phenomenon of personnel shortage is common.
Disclosure of Invention
In order to solve the defects in the prior art, the production data reporting system for the power plant is provided, production and operation data in a service system are automatically collected, collected and calculated, manual filling is combined, one-time filling and repeated reuse and automatic verification are realized, labor is saved, efficiency is improved, and independent query and export are realized for reports needing to be published and examined.
In order to achieve the above objective, the following technical solutions are adopted in the present application:
the utility model provides a power plant's production data reporting system, includes that the index sets up module, index input module, data acquisition module, data processing module and report form query module, its characterized in that:
the index setting module is used for self-defining an index adding formula and setting an index calculating 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 values acquired by the data acquisition module and the index formula added by the index setting module;
and the report inquiry module is used for generating a report according to the report data generated by the data processing module for the user to inquire.
The invention further comprises the following preferred embodiments:
preferably, in the index setting module, the index formula consists of index groups, index codes, index types and index calculation formulas and represents index calculation modes of different index groups, index codes and index types;
the index groups comprise machine furnace, environmental protection, electricity and chemical water;
the index types are the indexes of the number of products, class, day, month and year;
the index calculation formula comprises a real-time product index taking formula, a real-time shift index taking formula, a real-time daily index taking formula, a shift index table code conversion formula, a daily index shift index conversion formula, a daily index conversion formula, a monthly index conversion formula and a quoting index calculation formula, and is respectively used for realizing the real-time product index taking, the real-time shift index taking, the real-time daily index taking, the shift index table code conversion, the daily index shift index conversion, the monthly index conversion and the quoting index calculation;
the real-time data acquisition formula comprises index data acquisition measuring points which are divided into summation real-time data acquisition measuring points and averaging real-time data acquisition measuring points.
Preferably, in the index entry module, fuel data, a fixed value and internet electricity quantity are sequentially entered, the entered 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 group, an index calculation formula, generation time, modification time, a current value and a previous value;
the index input module comprises a fuel data synchronization submodule, a fixed value input submodule, an online electric quantity input submodule and an index reporting module;
the fuel data synchronization submodule is used for synchronizing the fuel data in the fuel intermediate library to the relational library so as to realize the automatic input of the fuel data;
the fixed value recording submodule is used for adding fixed and unchangeable data in the normal operation period of the unit into a fixed value and recording the data into the relational database according with the operation condition of the unit;
the online electric quantity recording submodule is used for recording the provincial online electric quantity, and is provided with a recalculating submodule for controlling the intelligent reporting system to recalculate the reporting data on the specified date;
and the index filling module is used for assisting in modifying the input index value.
Preferably, the index information entered in the index filling module includes a class index and a day index.
Preferably, in the data acquisition module, according to an index calculation formula in the index formula, real-time or historical production data, i.e., a measurement point value, is acquired from a production database, and an index value recorded by the index filling module stored in the data acquisition module is acquired from a relational database.
Preferably, in the data acquisition module, multi-process acquisition is adopted when acquiring real-time or historical production data from a production database;
when the stored index values recorded by the index filling module are collected from the relational database, the collection tasks are reasonably distributed to the micro-services for collection by utilizing load balance.
Preferably, the data processing module adopts a multi-process independent calculation for each index, so as to ensure that other indexes are not affected due to the problem of a certain index, report data is obtained through calculation, the obtained index data is stored in the relational database, and the report query module takes out data from the relational database for display.
Preferably, the report query module comprises a daily report sub-module, a monthly report sub-module, an 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 all provided with corresponding report templates and used for automatically generating daily, monthly, annual and department reports for each day according to the report data generated by the data processing module for the user to inquire;
and the department report submodule is used for automatically generating reports of all departments, and the reports of the departments comprise 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 report and an excel form;
the drying report is configured by a structured query language;
and configuring a data acquisition formula in the excel table, and performing data acquisition by using the data acquisition formula.
Preferably, the intelligent reporting system further comprises a reporting tool module, wherein the reporting tool module is used for providing a reporting 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 removing sub-module, an appointed index commissioning sub-module, an appointed index re-calculation 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 re-calculation strategy sub-module, an economic index competition report modification sub-module, a coal blending combustion sub-module, an Excel uploading sub-module and an Excel editing sub-module;
the index tracking sub-module is used for displaying the relation between the indexes in a visual mode, associating the relation 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 the dates to display the index values of the selected indexes on the selected dates, and setting the fluctuation range of the index values, wherein if the fluctuation range is exceeded, the color of the index values is changed, or the change trend of the indexes is displayed in a graphical mode;
the index replacement submodule is used for correcting an abnormal index value, and when a production database has a problem, the acquired data is inconsistent with normal data, and a correct value is given to replace the abnormal index value to participate in calculation;
the index removing submodule is used for removing index data in a shutdown period;
the designated index trial operation operator module is used for performing trial operation on the designated index to check whether the index formula is correct or not after the index formula is added to the index setting module, and the trial operation result is not recorded into the relational database;
the designated index recalculating submodule is used for recalculating the designated index after some source data are modified;
the error log submodule is used for monitoring in the whole process in the recalculation process, recording the problem indexes of which the index calculation fails into the error log, and analyzing error reasons or recalculating the error indexes according to the error log;
the index comparison and analysis submodule is used for freely selecting time and a fluctuation range, comparing and analyzing data of the selected time, and summarizing and displaying indexes of which the difference values exceed 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 submodule is used for monitoring measuring points added in the measuring point maintenance submodule in real time and pushing alarm information when abnormality occurs;
the recalculation strategy submodule is used for performing cascade recalculation on indexes related to the modified indexes by adding a recalculation strategy after the indexes are modified;
the economic index competition report modification submodule is used for eliminating economic indexes influenced by starting and stopping or manually adjusting the economic indexes influenced by starting and stopping to correct economic indexes;
the coal blending and blending submodule is used for adding coal types and test values thereof according to actual conditions, customizing a blending strategy, automatically combining various blending and blending results to form a blending and blending scheme and intelligently guiding actual production;
the Excel uploading sub-module is used for self-defining an Excel template and uploading the Excel template to an intelligent reporting system to form a reporting template;
the Excel editing submodule is used for editing the user-defined Excel template, configuring a data access formula and forming a report.
The beneficial effect that this application reached:
1. the method and the system automatically generate various reports according to a user-defined addition index formula by utilizing real-time/historical production process data stored in a production database, and meet the production statistical requirements of users;
2. according to actual needs, the report of the application is published in various ways through a report display module, such as Excel publishing, Web publishing and the like, wherein when the Excel is published, the user-defined various templates are supported to be selected to publish the report required by the user, and Web automatically publishes some conventional report data;
3. the method and the device can inquire the start and stop of the unit, 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 through a real-time report under a department report, and inquire, count and analyze main equipment and state information of the unit besides providing production process data and historical data for inquiring, counting and making the report.
4. According to the method and the device, through the index analysis submodule, historical trend graphs of all data in the report can be rapidly inquired, and operating personnel can analyze all index data conveniently.
Drawings
FIG. 1 is a schematic diagram of a plant production data reporting system according to the present application.
Detailed Description
The present application is further described below with reference to the accompanying drawings. The following examples are only for illustrating the technical solutions of the present invention more clearly, and the protection scope of the present application is not limited thereby.
As shown in fig. 1, the power plant production data reporting system of the present application includes an index setting module, an index entry module, a data acquisition module, a data processing module, and a report query module;
the index setting module is used for self-defining an index adding formula and setting an index calculating mode;
in the embodiment of the application, the index formula consists of index groups, index codes, index types and index calculation formulas and represents index calculation modes of different index groups, index codes and index types;
the index grouping and index coding can be freely set by users, for example:
the index groups comprise machine furnace, environmental protection, electricity, water and the like;
the index code consists of Arabic numerals and comprises project, unit and specific code information;
can be as follows: the first number in the index code determines the unit to which the index belongs, the second number determines the unit to which the index belongs, and the last four or more digits represent specific codes;
for example, the power plant has four units, wherein one unit belongs to the first-stage project, three units belong to the second-stage project, indexes 230001 and 2 represent the second stage, 3 represents the unit No. 3, and 0001 is a specific code.
The index types are the indexes of the number of products, class, day, month and year;
the index calculation formula comprises a real-time product index taking formula, a real-time shift index taking formula, a real-time daily index taking formula, a shift index table code conversion formula, a daily index shift index conversion formula, a daily index conversion formula, a monthly index conversion formula and a quoting index calculation formula, and is respectively used for realizing the real-time product index taking, the real-time shift index taking, the real-time daily index taking, the shift index table code conversion, the daily index shift index conversion, the monthly index conversion and the quoting index calculation;
the number index is only used as a calculation process index, and the class index is generally used as an economic competition index.
The real-time data acquisition formula comprises index data acquisition measuring points which are divided into summation real-time data acquisition measuring points and averaging real-time data acquisition measuring points.
In the embodiment of the application, the sum-like real-time measuring point index needs to define a product index,
the formula of the product index is corresponding to the real-time access of the product index,
the class index calculation formula is corresponding to the code conversion of the class index table,
the daily index calculation formula is corresponding to the conversion of the daily index table code,
the monthly index calculation formula is converted into monthly index daily index,
the annual index calculation formula corresponds to the conversion of the annual index monthly index,
the indexes of the real-time measuring points of the specified averaging type do not need to define the integral indexes,
the class index calculation formula corresponds to real-time number taking of the class index,
the daily index calculation formula corresponds to the real-time data acquisition of the daily index,
the monthly index calculation formula is converted into monthly index daily index,
the annual index calculation formula corresponds to the conversion of the annual index monthly index;
the table code conversion formula is accumulated by taking the corresponding product index as the bottom, and the index conversion formula is accumulated or averaged by taking the corresponding sublevel index as the bottom.
For example, for the index coded as 230001, the product index calculation formula defined by the index is: the product index real-time counts ("measure points, @ datatime"), its defined class index calculation formula is: the shift index table code conversion ("230001") defines a daily index calculation formula as: the daily index table code conversion ("230001") defines a monthly index calculation formula as: the monthly index daily index conversion ("230001, SUM") defines the formula for calculating the annual index as: year index monthly index conversion ("230001, SUM");
the index is coded as 230437 index, and the defined shift index calculation formula is as follows: the class index real-time data acquisition ("measure point, @ DATETIME, @ SHIFTSYSTEMID, @ shift tid, AVG"), its daily index calculation formula of definition is: the daily index is taken in real time ("measure point, @ DATETIME, AVG"), and the monthly index calculation formula defined by the method is as follows: the conversion of the monthly index daily index ("230437, AVG") defines the formula for calculating the annual index as: year index monthly index conversion ("230437, AVG")
The reference class index formula can be referenced only by siblings, for example: the class index references a class index-class index ("241326"). spot index ("240190"), and the day index references a class index-day index ("200866")/day index ("200412"). 100.
The index input module is used for inputting an index value;
the fuel data, the fixed value and the internet surfing electric quantity are sequentially recorded in the index recording module, and the recorded data are stored in the relational database.
The relational database stores complete index information, including index ID, index name, index code, index type, index grouping, index calculation formula, generation time, modification time, current value and last value.
The relational database, i.e. the relational database, is for example used as oracle database.
The index input module comprises a fuel data synchronization submodule, a fixed value input submodule, an online electric quantity input submodule and an index reporting module;
the fuel data synchronization submodule is used for synchronizing the fuel data in the fuel intermediate library to the relational library so as to realize the automatic input of the fuel data;
the fixed value recording submodule is used for adding fixed and unchangeable data in the normal operation period of the unit into a fixed value and recording the data into the relational database according with the operation condition of the unit;
for example, the third machine is operated, and the fourth machine is stopped; the third machine is stopped, and the fourth machine is operated;
the online electric quantity recording submodule is used for recording the provincial online electric quantity, and is provided with a recalculating submodule for controlling the intelligent reporting system to recalculate the reporting data of the specified date, because the online electric quantity is the last recorded data;
and the index filling module is used for carrying out auxiliary modification and entry of the index value in the index filling module when special conditions occur, such as the change of the numerical value of the fuel intermediate library.
In general, the index entry does not need to be performed in the index filling module, the first step of entry of the index is entry of fuel data, the second step is entry of a fixed value, and the third step is entry of the online electric quantity. And clicking to generate a report after the internet surfing electric quantity is input.
The fuel data, the internet surfing electric quantity and the fixed value are input indexes, the workload of a user is greatly reduced by the fuel data synchronization submodule, the fixed value input submodule and the internet surfing electric quantity input submodule, and all input indexes can be input completely only a few times under normal conditions. When special conditions occur, such as the change of the numerical value of the fuel intermediate library, the index is required to be added into the index filling module to manually modify the recorded value.
The index entry needs to be filled with more data, including fuel data and internet power. The fuel data synchronization submodule reduces the workload of a user and directly selects time to synchronize from the fuel intermediate library. The online electric quantity recording submodule has less filled data and is convenient for a user to fill, the submodule comprises a recalculation button, the recalculation date is selected after the online electric quantity is recorded, and a calculation engine can be called to recalculate a report form by defaulting the recalculation on the previous day.
The index information input by the index filling module is divided into class indexes and day indexes.
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 a point measurement value, from the production database according to index grouping, index coding and index types in the index formula, and acquiring the stored index value recorded by the index recording module from the relational database;
the production data includes temperature, pressure, power, etc. 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 obtains the index grouping, index code, index type and index calculation formula of the index, searches the product index of the index according to the index calculation formula, the product index calculation formula is product index real-time counting (' measuring point ' @ DATETIME '), and counting is carried out according to the measuring point in the product index calculation formula.
The index code is 230190 index, the daily index calculation formula is daily index class index conversion ('230190, SUM'), the data acquisition module obtains the index grouping, index code, index type and index calculation formula of the index, the class index of the index is searched according to the index calculation formula, the class index is recorded index, no calculation formula exists, and the data acquisition module acquires the index value recorded by the index filling module in the relational database.
When real-time or historical production data are collected from the production database, multi-process collection is adopted, so that the collection speed is increased;
when the stored index values recorded by the index filling module are collected from the relational database, the collection tasks are reasonably distributed to each micro-service for collection by utilizing load balance, the pressure of the service is reduced, and the collection speed is increased.
The data processing module is used for calculating and generating report data according to the index values acquired by the data acquisition module and the index formula added by the index setting module; specifically, the method comprises the following steps:
the data processing module adopts multiple processes to independently calculate each index, so that other indexes are not influenced by the problem of one index, and the calculated index value is written into the relational database.
The data processing module adopts multiple processes to independently calculate each index, ensures that other indexes cannot be influenced by the problem of a certain index, calculates to obtain report data, stores the calculated index data in the relational database, and the report query module fetches and displays the data from the relational database.
The report query module is used for generating reports according to the report data generated by the data processing module for the user to query, and the user can freely select the report template to query the reports of the past day, specifically:
the report query module comprises a daily report submodule, a monthly report submodule, an annual report submodule and a department report submodule, wherein the daily report submodule, the monthly report submodule, the annual report submodule and the department report submodule are all provided with corresponding report templates and are used for automatically generating daily, monthly, annual and department reports for each day according to report data generated by the data processing module for a user to query; the visual display of the report is realized, the scheduling according to needs is realized, the finally displayed report is high in specificity, the report is generated fully automatically, and the working pressure of regulation and control personnel is reduced.
The indexes of class, day, month and year have a corresponding record every day, the corresponding report forms have the same change of the display data of the report forms every day, and the past report forms can be checked through the time selection box.
The number index is only used as a calculation process index, the readability is poor, the number index is not displayed generally, the class index is generally used as an economic competition index, the class index is generally only one or a plurality of reports, and the class index is not displayed as an independent report module generally.
And the department report submodule is used for automatically generating reports of all departments, and the reports of the departments comprise a class report, an economic index competition report and a real-time report.
The economic indexes are competition indexes among all values of the power plant and comprise generated energy, load rate and exhaust gas temperature;
the economic index competition report is a report in which all values are used for competition evaluation, for example, five values of the E, P, M, T and E are respectively corresponding to the shift indexes, and the economic index competition report is calculated and summarized.
The real-time report is a real-time calculation type report, some class indexes and some day indexes are counted in real time, and the general statistical indexes are a unit operation hour type index, a coal mill operation hour type index and a fan operation hour type index. The report is generally only one or a plurality of reports, so that the department is hung under the department without a separate division module.
The report template is divided into a moistening report and an excel form;
the run-dry report is configured in a structured query language, such as sql written at rpx;
a data acquisition formula is configured in the excel table, and data acquisition is carried out by using the data acquisition formula; the configured report template is used for being called and used by the report query module.
The access formula is accessed by using an access formula, for example, $ func (a, b, c, d), wherein $ func () is in a fixed format, a represents an index code, and b, c, d are combined to uniquely determine the index.
b, taking an integer value which can be 1-4, taking 1 to represent white shift, taking 2 to represent middle shift, taking 3 to represent night shift, and taking 4 to represent non-shift index; c, taking an integer value which can be 1-3, taking 1 to represent a daily index, taking 2 to represent a monthly index, and taking 3 to represent a shift index; d is an integer value which can be 1-7, 1 is taken to represent annual accumulation, 2 is taken to represent ring 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 can be optionally selected from 1-3 and b can be optionally selected from 1-4.
Taking the power generation capacity 230001 of the No. 3 engine as an example:
the $ func (230001,4,1,4) represents the daily index of the generated energy of the No. 3 engine;
the $ func (230001,1,3,4) represents the white shift generating capacity of the No. 3 machine;
and $ func (230001,4,3,1) represents the annual accumulated power generation of the No. 3 engine.
The intelligent report system further 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, and is specific:
the report tool module comprises an index tracking sub-module, an index analysis sub-module, an index replacement sub-module, an index removing sub-module, an appointed index commissioning sub-module, an appointed index re-calculation 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 re-calculation strategy sub-module, an economic index competition report modification sub-module, a coal blending combustion sub-module, an Excel uploading sub-module and an Excel editing sub-module;
the index tracking submodule is used for displaying the relation between indexes in a visual mode through a recursive algorithm and associating the relation with the index values, and when the index values are abnormal, the abnormal indexes are accurately positioned through index tracking, so that the production can be accurately guided, the labor force of field personnel is reduced, and the personnel reduction and the efficiency improvement 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 the dates to display the index values of the selected indexes on the selected dates, and setting the fluctuation range of the index values, wherein if the fluctuation range is exceeded, the color of the index values is changed, or the change trend of the indexes is displayed in a graphical mode;
the index replacement submodule is used for correcting an abnormal index value, and when a production database has a problem, the acquired data is inconsistent with normal data, and a correct value is given to replace the abnormal index value to participate in calculation;
the index removing submodule is used for removing the index data in the shutdown period to ensure that the index data does not participate in operation and no matter whether the data is started or stopped;
the designated index trial operation operator module is used for performing trial operation on the designated index to check whether the index formula is correct or not after the index formula is added to the index setting module, and the trial operation result is not written into the relational database;
the designated index recalculating sub-module is used for recalculating the designated index after modifying some source data, so that the full calculation is avoided, the index calculation amount is reduced, and the calculation time is saved; for example, the index 230953, namely 3A desulfurization change, if the calculation formula of the index is modified, recalculation is needed; recalculation is also required if the index is replaced by the index replacement submodule.
The error log submodule is used for monitoring in the whole process in the recalculation process, recording the problem indexes of which the index calculation fails into the error log, and analyzing error reasons or recalculating the error indexes according to the error log;
the index comparison analysis sub-module is used for freely selecting time, such as 2020-05-14, and a fluctuation range, comparing and analyzing data of 2020-05-14 and 2020-05-13, 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 submodule is used for monitoring measuring points added in the measuring point maintenance submodule in real time and pushing alarm information when abnormality occurs; for example, the measuring point values are not updated for a long time, and the measuring point values fluctuate greatly.
The recalculation strategy submodule is used for carrying out cascade recalculation on indexes related to the modification indexes by adding a recalculation strategy after the indexes are modified by the index replacement submodule or the index filling submodule, so that the workload of operating personnel is reduced, and the self-consistency and consistency of the report are ensured;
the economic index competition report modification submodule is used for rejecting economic indexes influenced by starting and stopping or manually adjusting the economic indexes influenced by starting and stopping to normal economic indexes;
the economic indexes are competition indexes among all values of the power plant and comprise generated energy, load rate, exhaust gas temperature and the like.
Under the influence of starting and stopping, the temperature and pressure economic indexes have large fluctuation, the participation in economic index competition is subject to misappropriation, and a normal value can be abandoned or replaced at the moment.
The coal blending and blending submodule is used for adding coal types and test values thereof according to actual conditions, customizing a blending strategy, automatically combining various blending and blending results to form a blending and blending scheme and intelligently guiding actual production;
the blending coal blending combustion submodule is a tool for guiding production, a user selects coal types, selects a mixture ratio, analyzes the selected coal types and calculates a blending combustion result, and the selected coal types are arranged and combined to form various blending combustion results when more than three coal types are selected. The result is not stored, and a calculation engine is not called, and the result is a characteristic sub-module in the report tool.
The Excel uploading sub-module is used for self-defining an Excel template and uploading the Excel template to an intelligent reporting system to form a reporting template;
the Excel editing submodule is used for editing the user-defined Excel template, configuring a data access formula and forming a report.
The present applicant has described and illustrated embodiments of the present invention in detail with reference to the accompanying drawings, but it should be understood by those skilled in the art that the above embodiments are merely 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 for limiting the scope of the present invention, and on the contrary, any improvement or modification made based on the spirit of the present invention should fall within the scope of the present invention.

Claims (10)

1. The utility model provides a power plant's production data reporting system, includes that the index sets up module, index input module, data acquisition module, data processing module and report form query module, its characterized in that:
the index setting module is used for self-defining an index adding formula and setting an index calculating 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 values acquired by the data acquisition module and the index formula added by the index setting module;
and the report inquiry module is used for generating a report according to the report data generated by the data processing module for the user to inquire.
2. A power plant production data reporting system as in claim 1 wherein:
in the index setting module, an index formula consists of index groups, index codes, index types and index calculation formulas and represents index calculation modes of different index groups, index codes and index types;
the index groups comprise machine furnace, environmental protection, electricity and chemical water;
the index types are the indexes of the number of products, class, day, month and year;
the index calculation formula comprises a real-time product index taking formula, a real-time shift index taking formula, a real-time daily index taking formula, a shift index table code conversion formula, a daily index shift index conversion formula, a daily index conversion formula, a monthly index conversion formula and a quoting index calculation formula, and is respectively used for realizing the real-time product index taking, the real-time shift index taking, the real-time daily index taking, the shift index table code conversion, the daily index shift index conversion, the monthly index conversion and the quoting index calculation;
the real-time data acquisition formula comprises index data acquisition measuring points which are divided into summation real-time data acquisition measuring points and averaging real-time data acquisition measuring points.
3. A power plant production data reporting system as in claim 1 wherein:
the fuel data, the fixed value and the internet surfing electric quantity are sequentially recorded in the index recording module, the recorded data are stored in a relational database, and the relational database stores complete index information which comprises an index ID, an index name, an index code, an index type, an index group, an index calculation formula, generation time, modification time, a current value and a previous value;
the index input module comprises a fuel data synchronization submodule, a fixed value input submodule, an online electric quantity input submodule and an index reporting module;
the fuel data synchronization submodule is used for synchronizing the fuel data in the fuel intermediate library to the relational library so as to realize the automatic input of the fuel data;
the fixed value recording submodule is used for adding fixed and unchangeable data in the normal operation period of the unit into a fixed value and recording the data into the relational database according with the operation condition of the unit;
the online electric quantity recording submodule is used for recording the provincial online electric quantity, and is provided with a recalculating submodule for controlling the intelligent reporting system to recalculate the reporting data on the specified date;
and the index filling module is used for assisting in modifying the input index value.
4. A power plant production data reporting system as in claim 3 wherein:
the index information input in the index filling module comprises class indexes and day indexes.
5. A power plant production data reporting system as in claim 1 wherein:
in the data acquisition module, real-time or historical production data, namely point measurement values, are acquired from a production database according to an index calculation formula in an index formula, and the stored index values of the index filling module are acquired from a relational database.
6. A power plant production data reporting system as in claim 5 wherein:
in the data acquisition module, multi-process acquisition is adopted when acquiring real-time or historical production data from a production database;
when the stored index values recorded by the index filling module are collected from the relational database, the collection tasks are reasonably distributed to the micro-services for collection by utilizing load balance.
7. A power plant production data reporting system as in claim 1 wherein:
the data processing module adopts multi-process independent calculation of each index to obtain report data, the calculated index data are stored in the relational database, and the report query module takes the number from the relational database for display.
8. A power plant production data reporting system as in claim 1 wherein:
the report query module comprises a daily report sub-module, a monthly report sub-module, an 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 all provided with corresponding report templates and used for automatically generating daily, monthly, annual and department reports for each day according to the report data generated by the data processing module for the user to inquire;
and the department report submodule is used for automatically generating reports of all departments, and the reports of the departments comprise a class report, an economic index competition report and a real-time report.
9. A power plant production data reporting system as in claim 1 wherein:
in the report query module, the report template is divided into a moistening report and an excel form;
the drying report is configured by a structured query language;
and configuring a data acquisition formula in the excel table, and performing data acquisition by using the data acquisition formula.
10. A power plant production data reporting system as in claim 1 wherein:
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;
the report tool module comprises an index tracking sub-module, an index analysis sub-module, an index replacement sub-module, an index removing sub-module, an appointed index commissioning sub-module, an appointed index re-calculation 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 re-calculation strategy sub-module, an economic index competition report modification sub-module, a coal blending combustion sub-module, an Excel uploading sub-module and an Excel editing sub-module;
the index tracking sub-module is used for displaying the relation between the indexes in a visual mode, associating the relation 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 the dates to display the index values of the selected indexes on the selected dates, and setting the fluctuation range of the index values, wherein if the fluctuation range is exceeded, the color of the index values is changed, or the change trend of the indexes is displayed in a graphical mode;
the index replacement submodule is used for correcting an abnormal index value, and when a production database has a problem, the acquired data is inconsistent with normal data, and a correct value is given to replace the abnormal index value to participate in calculation;
the index removing submodule is used for removing index data in a shutdown period;
the designated index trial operation operator module is used for performing trial operation on the designated index to check whether the index formula is correct or not after the index formula is added to the index setting module, and the trial operation result is not recorded into the relational database;
the designated index recalculating submodule is used for recalculating the designated index after some source data are modified;
the error log submodule is used for monitoring in the whole process in the recalculation process, recording the problem indexes of which the index calculation fails into the error log, and analyzing error reasons or recalculating the error indexes according to the error log;
the index comparison and analysis submodule is used for freely selecting time and a fluctuation range, comparing and analyzing data of the selected time, and summarizing and displaying indexes of which the difference values exceed 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 submodule is used for monitoring measuring points added in the measuring point maintenance submodule in real time and pushing alarm information when abnormality occurs;
the recalculation strategy submodule is used for performing cascade recalculation on indexes related to the modified indexes by adding a recalculation strategy after the indexes are modified;
the economic index competition report modification submodule is used for eliminating economic indexes influenced by starting and stopping or manually adjusting the economic indexes influenced by starting and stopping to correct economic indexes;
the coal blending and blending submodule is used for adding coal types and test values thereof according to actual conditions, customizing a blending strategy, automatically combining various blending and blending results to form a blending and blending scheme and intelligently guiding actual production;
the Excel uploading sub-module is used for self-defining an Excel template and uploading the Excel template to an intelligent reporting system to form a reporting template;
the Excel editing submodule is used for editing the user-defined Excel template, configuring a data access formula and forming a report.
CN202010680114.0A 2020-07-15 2020-07-15 Power plant production data reporting system Active CN112037083B (en)

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 true CN112037083A (en) 2020-12-04
CN112037083B 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)

Cited By (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
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
CN114049036A (en) * 2021-11-24 2022-02-15 广东电网有限责任公司 Data computing platform, method, device and storage medium

Citations (13)

* Cited by examiner, † Cited by third party
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
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

Patent Citations (13)

* Cited by examiner, † Cited by third party
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
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 (8)

* Cited by examiner, † Cited by third party
Title
LIU DUNNAN,等: "Economic evaluation of power system dispatch with hesitant fuzzy uncertain linguistic information", JOURNAL OF INTELLIGENT & FUZZY SYSTEMS, vol. 37, no. 2, pages 1761 *
WU YUNNA,等: "Optimal Site Selection of Tidal Power Plants Using a Novel Method: A Case in China", vol. 10, no. 9, pages 192 - 194 *
戚平;何俊博;: "基于B/S架构的自主生成报表引擎系统设计与实现", 电子设计工程, no. 08, pages 78 - 82 *
李巍,等: "燃煤电厂智慧管控系统(IMS)研发与应用", 《科技成果登记表》, pages 1 - 3 *
王锋;: "开放式发电企业经济指标系统分析和架构", 电力信息化, no. 02, pages 64 - 67 *
石光亮, 王拓, 弋长青, 张根周: "电力生产信息统计报表生成器的设计与实现", 电力系统自动化, no. 21, pages 86 - 88 *
莫远明;王毅;林琳;张武军;: "基于数据集成平台的医院智能报表系统的构建", 现代医院, no. 04, pages 108 - 111 *
赵玉良;吴文祥;李郁;: "基于SIS的实时考核报表系统的开发与应用", 热力发电, no. 11, pages 77 - 79 *

Cited By (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
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
CN114049036A (en) * 2021-11-24 2022-02-15 广东电网有限责任公司 Data computing platform, method, device and storage medium

Also Published As

Publication number Publication date
CN112037083B (en) 2024-02-23

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
CN109461093A (en) Electric quantity measuring system Accuracy Evaluation and station service energy consumption analysis system
CN113822547B (en) Comprehensive information platform system for refined demand side management and management method
CN111539604A (en) Enterprise rework and production recovery index measuring and monitoring method based on electric power data
CN102375449A (en) Database optimized storage and query method based on industrial control field
CN110633916A (en) Energy efficiency control system for coal mine enterprise
CN111650901A (en) Intelligent unattended factory system for cement production line
CN113760625B (en) Evaluation method and monitoring system for model predictive controller performance
CN115689177A (en) Machine learning-based intelligent scheduling strategy method for transformer maintenance plan
CN113010595A (en) Electric power energy data analysis and monitoring method and system
CN112446608A (en) OEE and Andon safety lamp management system and working method thereof
CN116431701A (en) Comprehensive power plant production data analysis and statistics system
CN111813057A (en) Energy management system of cement production plant
CN112417373A (en) Computing method and device for energy balance of chemical enterprises
CN115017214B (en) Hydropower station auxiliary equipment operation state analysis early warning method, device and storage medium
CN107045548B (en) System and method for calculating wind power energy utilization rate
CN112862314A (en) Thermal power plant production and operation environment index reporting management system
CN114897394A (en) Power consumption monitoring system and method
CN110738423B (en) Comprehensive efficiency evaluation method for rolling and connecting equipment
CN113255307A (en) Intelligent reporting method and system for power system
CN114330770A (en) Method, device and system for acquiring equipment status report
CN116227740B (en) Energy analysis management cloud platform based on blockchain
CN117784742B (en) Fault diagnosis method of fatty acid biological feed production monitoring system
CN113627628B (en) Method for online calculating repeated overhaul times of same fan based on working ticket

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