Steel plant management statistics intelligent data processing system and method

Abstract

The invention discloses a steel plant management statistics intelligent data processing system and method. Comprising a converter original report module, a refining furnace original report module, a refining furnace production report module, a steelmaking production report module and a steelmaking three-shift report module. And each module is respectively provided with functions of data display, query, export and report updating. According to the invention, by integrating the related data in the production process of the steel plant and intensively displaying various types of data in different pages, unified management of the data is realized. Meanwhile, convenient data entry, modification and deletion operation and efficient query and export functions are achieved, the time and labor cost of data management are greatly saved, and the data management efficiency is improved.

Description

Technical Field

[0001] This invention relates to the field of steel production data management technology, and in particular to an intelligent data processing system and method for steel plant management statistics. Background Technology

[0002] In the steelmaking production process, various types of data require management and statistics. Accurately tracking the consumption of various materials in converters, refining furnaces, and continuous casting processes, as well as the consumption of various gases, water, and electricity during steel plant operation, is crucial for adjusting production rhythm, improving product quality, and reducing production costs. However, traditional methods of managing and statistically analyzing steelmaking production data have many problems. For example, the data collection process is complex and cumbersome, prone to human error; data records are scattered, making efficient querying and analysis difficult; and the lack of an efficient data entry mechanism leads to untimely data updates, failing to provide accurate basis for production decisions. With the continuous expansion of steelmaking production scale and the increasing number of production processes, these problems become increasingly apparent, urgently requiring a new technological solution to address the challenges of managing and statistically analyzing steel plant data. Summary of the Invention

[0003] To overcome the above-mentioned shortcomings, the present invention aims to provide an intelligent data processing system and method for steel plant management and statistics, so as to achieve efficient management, accurate statistics and convenient operation of relevant data of steel plant, and improve the informatization level and production efficiency of steel production.

[0004] To achieve the above objectives, the present invention provides an intelligent data processing system for steel plant management and statistics, which includes at least a converter raw report module. The converter original report module includes a data display unit, a query unit, an export unit, and a report update unit. The data display unit is used to display detailed data received by the converter, including date, shift, furnace number, steel grade, length, molten iron, and scrap steel information; The query unit is used to retrieve data that meets the selected criteria, such as time, furnace number, steel type, converter number, and work group. The export unit is used to export all data displayed on the page retrieved according to the selected date and save it locally, making it convenient for users to perform data backup, offline analysis and data sharing; The update report cell is used to recalculate and update all data in the original converter table for the selected date.

[0005] Furthermore, it also includes the refining furnace raw report module: The refining furnace original report module includes a data display unit, a query unit, and an export unit; The data display unit is used to display detailed data received by the refining furnace, including date, shift, furnace number, steel type, length, lime, and refining lime information; The query unit is used to retrieve data that meets the selected criteria, such as date, furnace number, shift, and steel type. The export unit is used to export all data displayed on the page retrieved according to the selected date and save it locally, making it convenient for users to perform data backup, offline analysis, and data sharing.

[0006] Furthermore, it also includes a refining furnace production report module: The refining furnace production report module includes: a data display unit, a query unit, an export unit, and a report update unit. The data display unit is used to display detailed data of the refining furnace statistics, including date, shift, furnace number, steel grade, length, lime, and refining lime information; The query unit is used to retrieve data that meets the selected criteria, such as date, furnace number, shift, and steel type. The export unit is used to fill out a form according to the set requirements and save it locally, which facilitates data backup, offline analysis and data sharing for users; The report update function is used to recalculate and update all data in the refining furnace production report for the selected date.

[0007] Furthermore, it also includes a steelmaking production report module: the steelmaking production report module is divided into "converter section", "continuous casting section" and "other information section without steel grades".

[0008] Furthermore, the converter section is equipped with a data display unit, a query unit, an export unit, and an update report unit; The data display unit is used to display detailed statistics on converters, including date, furnace number, steel grade, number of steelmaking furnaces, amount of molten iron, scrap steel, steel production, and information on lime. The query unit is used to retrieve data that meets the selected criteria, such as report type, date, furnace number, and steel grade. The export unit is used to fill out a form according to the set requirements and save it locally, which facilitates data backup, offline analysis and data sharing for users; The report update function is used to recalculate and update all data for the converter section based on the selected date.

[0009] Furthermore, the continuous casting section is equipped with a data display unit, a query unit, an export unit, and an update report unit; The data display unit is used to display detailed data on continuous casting statistics, including information such as date, casting machine number, steel grade, number of steel pulling furnaces, molten iron, scrap steel, molten steel consumption, and number of billets. The query unit is used to retrieve data that meets the selected conditions based on the selected report type, date, and casting machine number. The export unit is used to fill out a form according to the set requirements and save it locally, which facilitates data backup, offline analysis and data sharing for users; The update report cell is used to recalculate and update all data for the continuous casting section under the selected date.

[0010] Furthermore, the other steel grade information section includes a data display unit, a query unit, an export unit, and an update report unit; The data display unit is used to display detailed statistics on blast furnace, electricity consumption, gas consumption, and water consumption, including information on date, blast furnace feed, refining electricity consumption, compressed air volume, argon volume, nitrogen consumption, oxygen consumption, and coal gas volume. The query unit is used to retrieve data that meets the set conditions based on the report type and date options; The export unit is used to fill out a form according to the set requirements and save it locally, which facilitates data backup, offline analysis and data sharing for users; The update report unit is used to recalculate and update all data in other steel grade information sections for the selected date, based on the selected date.

[0011] Furthermore, it also includes: the steelmaking shift three report module has a data display unit, a query unit, an export unit, and a report update unit; The data display unit is used to display detailed statistics of the refining furnace, including information such as date, furnace number, shift, number of furnaces, billet output, casting output, average furnace output, and amount of molten iron fed into the furnace. The query unit is used to retrieve data that meets the set conditions based on the report type, date, and shift options; The export unit is used to fill out a form according to the set requirements and save it locally, which facilitates data backup, offline analysis and data sharing for users; The update report unit is used to recalculate and update all data in the steelmaking shift 3 report for the selected date.

[0012] To achieve the above objectives, the present invention provides an intelligent data processing method for steel plant management and statistics. The method is implemented based on the aforementioned intelligent data processing system for steel plant management and statistics, and includes the following steps: Data update steps: In the converter original report module and the refining furnace original report module, data is automatically added based on changes in converter and refining furnace information in the database; in the refining furnace production report, steelmaking production report, and steelmaking shift report modules, the previous day's data is statistically analyzed and updated at 5:00 AM every day based on the relevant results already in the database; manual updates can also be performed through the update report function on each interface, and the system will automatically update the data according to the selected date, store it in the database, and display it on the page; Data query and filtering steps: Based on the user's query needs, the required query conditions are set in each module. According to the selected conditions, the system retrieves data that meets the conditions from the database and displays it. Data export and backup steps: When users need to save or share the queried data, the query results are exported to a specified local path in a specific format to achieve data backup and offline analysis, making it convenient for users to further process and study the data.

[0013] The present invention has the following advantages: 1. Improved Data Management Efficiency: This invention integrates relevant data from the steel plant's production process and centrally displays various types of data on different pages, achieving unified data management. Simultaneously, convenient data entry, modification, and deletion operations, along with efficient query and export functions, significantly save time and manpower costs in data management, thereby improving data management efficiency.

[0014] 2. Enhance data accuracy: The system provides a variety of data operation methods, such as the "update report" function on various interfaces, which avoids inconsistencies and erroneous records in statistical data when the database is not updated in a timely manner, thereby improving data quality and providing a reliable basis for production decisions.

[0015] 3. Optimized Production Decision Support: Rich data visualization and flexible query functions enable production managers to quickly obtain the necessary data and understand the production situation in a timely manner. Through data analysis and mining, problems and potential patterns in the production process can be identified, providing strong support for optimizing production processes and adjusting production plans, thereby improving the overall efficiency and quality of steel production and reducing production costs. Attached Figure Description

[0016] Figure 1 This is a schematic diagram of the original report for the converter.

[0017] Figure 2 This is a schematic diagram of the original report for the refining furnace.

[0018] Figure 3 This is a schematic diagram of the production report for the refining furnace.

[0019] Figure 4This is a schematic diagram of the converter section of a steelmaking production report.

[0020] Figure 5 This is a schematic diagram of the continuous casting section of a steelmaking production report.

[0021] Figure 6 This is a schematic diagram of the section in the steelmaking production report that does not include information on other steel grades.

[0022] Figure 7 This is a schematic diagram of the report for the third shift of steelmaking. Detailed Implementation

[0023] The embodiments of the present invention will now be described in detail with reference to the accompanying drawings.

[0024] In the description of this invention, it should be understood that the terms "center", "upper", "lower", "front", "rear", "left", "right", "vertical", "horizontal", "top", "bottom", "inner", "outer", etc., indicate the orientation or positional relationship based on the orientation or positional relationship shown in the accompanying drawings. They are only for the convenience of describing this invention and simplifying the description, and do not indicate or imply that the device or element referred to must have a specific orientation, or be constructed and operated in a specific orientation. Therefore, they should not be construed as limitations on this invention.

[0025] The terms "first" and "second" are used for descriptive purposes only and should not be construed as indicating or implying relative importance or implicitly specifying the number of technical features indicated. Thus, a feature defined as "first" or "second" may explicitly or implicitly include one or more of that feature. In the description of this invention, unless otherwise stated, "a plurality of" means two or more.

[0026] In the description of this invention, it should be noted that, unless otherwise explicitly specified and limited, the terms "installation," "connection," and "joining" should be interpreted broadly. For example, they can refer to a fixed connection, a detachable connection, or an integral connection; they can refer to a direct connection or an indirect connection through an intermediate medium; and they can refer to the internal communication between two components. Those skilled in the art can understand the specific meaning of the above terms in this invention based on the specific circumstances.

[0027] The intelligent data processing system for steel plant management and statistics of the present invention includes a converter original report module, a refining furnace original report module, a refining furnace production report module, a steelmaking production report module, and a steelmaking shift report module.

[0028] The converter raw report module includes "Data Display," "Query," "Export," and "Update Report" functions. The Data Display unit shows detailed data received by the converter, including date, work group, furnace number, steel grade, length, molten iron, and scrap steel. The Query function allows users to select time, furnace number, steel grade, converter number, and work group as options, and click the "Search" button to retrieve data matching those criteria. The Export function allows users to export all data displayed on the page retrieved for the selected date and save it locally for data backup, offline analysis, and data sharing. The Update Report function allows users to select a date and click the "Update Report" button to recalculate and update all data in the converter raw report for that date.

[0029] The refining furnace raw report module includes "Data Display," "Query," and "Export" functions. The Data Display unit shows detailed data received by the refining furnace, including date, shift, furnace number, steel grade, length, lime, and refined lime. The Query function allows users to select date, furnace number, shift, and steel grade options, and click the "Search" button to retrieve data matching those criteria. The Export function allows users to export all data displayed on the page retrieved for the selected date and save it locally for data backup, offline analysis, and data sharing.

[0030] The refining furnace production report module includes "Data Display," "Query," "Export," and "Update Report" functions. The Data Display unit shows detailed statistics from the refining furnace, including date, shift, furnace number, steel grade, length, lime, and refined lime. The Query function allows users to select date, furnace number, shift, and steel grade options, and click the "Search" button to retrieve data matching those criteria. The Export function allows users to fill out a form according to predefined requirements and save it locally for data backup, offline analysis, and data sharing. The Update Report function allows users to select a date and click the "Update Report" button to recalculate and update all data in the refining furnace production report for that date.

[0031] Steelmaking production report module: There are separate pages for "Converter Section", "Continuous Casting Section", and "Other Information Sections without Steel Grades".

[0032] The converter section's pages are divided into "Data Display," "Query," "Export," and "Update Report" functions. The Data Display unit shows detailed converter statistics, including date, furnace number, steel grade, number of steelmaking furnaces, iron output, scrap steel, steel production, and lime content. The Query function allows users to select report type, date, furnace number, and steel grade options, and click the "Search" button to retrieve data matching those criteria. The Export function allows users to click the "Export" button, and the system will fill out a form according to pre-defined requirements and save it locally for data backup, offline analysis, and data sharing. The Update Report function allows users to select a date and click the "Update Report" button, and the system will recalculate and update all converter data for that date.

[0033] The continuous casting section's pages are divided into "Data Display," "Query," "Export," and "Update Report" functions. The Data Display unit shows detailed statistics on continuous casting, including date, casting machine number, steel grade, number of steelmaking furnaces, molten iron, scrap steel, steel consumption, and number of billets. The Query function allows users to set report type, date, and casting machine number options. Users can select these criteria and click the "Search" button to retrieve data that meets those conditions. The Export function allows users to click the "Export" button, and the system will fill out a form according to pre-defined requirements and save it locally for data backup, offline analysis, and data sharing. The Update Report function allows users to select a date and click the "Update Report" button, and the system will recalculate and update all data for the selected date's continuous casting section.

[0034] The other sections of the information page for steel grades without specific grades have "Data Display," "Query," "Export," and "Update Report" functions. The Data Display section shows detailed statistics on blast furnace, electricity consumption, gas consumption, and water consumption, including date, blast furnace feed rate, refining electricity consumption, compressed air volume, argon volume, nitrogen consumption, oxygen consumption, and coal gas volume. The Query function allows users to set report type and date options; clicking the "Search" button retrieves data that meets the criteria. The Export function allows users to fill out a form according to predefined requirements and save it locally for data backup, offline analysis, and data sharing. The Update Report function allows users to select a date and click the "Update Report" button to recalculate and update all data in the other steel grade-free information section for that date.

[0035] The Steelmaking Shift 3 Report Module includes "Data Display," "Query," "Export," and "Update Report" functions. The Data Display unit shows detailed statistics from the refining furnace, including date, furnace number, shift, number of furnaces, billet output, casting output, average furnace output, and molten iron input. The Query function allows users to select report type, date, and shift options, and click the "Search" button to retrieve data that meets those criteria. The Export function allows users to fill out a form according to predefined requirements and save it locally for data backup, offline analysis, and data sharing. The Update Report function allows users to select a date and click the "Update Report" button to recalculate and update all data in the Steelmaking Shift 3 reports for that date.

[0036] 2. Data Processing Method: Based on the above system architecture, the steel plant-level data management and statistical method of the present invention includes the following steps: Data Updates: The converter and refining furnace original report modules will automatically update data based on changes in converter and refining furnace information in the database. The refining furnace production report, steelmaking production report, and steelmaking shift report will be updated daily at 5:00 AM based on existing results in the database, summarizing and updating the previous day's data. Manual updates are also possible through the report update function on each interface; the system will automatically update data according to the selected date, store it in the database, and display it on the page.

[0037] Data Query and Filtering: Based on user query needs, specific query conditions are set on each subpage. The system retrieves matching data from the database and displays it on the page. The query results quickly and accurately present the information users need, improving data retrieval efficiency.

[0038] Data Export and Backup: When users need to save or share the queried data, they can click the "Export" button on the page. The system will export the query results in a specific format (such as Excel, CSV, etc.) to a specified local path, enabling data backup and offline analysis, which facilitates further processing and research of the data by users.

[0039] Example Data update example: When missing or incorrect data is found in the original converter report, the operator clicks the "Update Report" button. The system then fills in the missing or incorrect data based on the data in the database.

[0040] Data Query Example: Production managers want to query the lime consumption data for each heat of steel in a refining furnace on March 18, 2025, shift C, using 30MnSi steel. On the "Refining Furnace Original Report" page, the manager selects the production date "2025-3-18" in the [Date] field, selects "Shift C" in the shift selection box, enters "30MnSi" in the steel grade selection box, and clicks the [Search] button. The system quickly displays the data matching the criteria on the page, including detailed information such as converter number, lime, and refined lime, facilitating viewing and analysis by the manager.

[0041] Data Export Example: The quality control department needs to perform offline analysis of the steelmaking production report data as of March 20, 2025, to assess the impact of adding molten iron and scrap steel on the steel yield. On the "Steelmaking Production Report" page, staff select "2025-3-20" as the date, click the "Search" button to retrieve the data, and then click the "Export" button. The system will export the query results in Excel format to a specified local folder, allowing staff to perform in-depth analysis and processing of the data offline.

[0042] The present invention has been described in detail above with reference to the accompanying drawings. However, the present invention is not limited to the embodiments described above. Within the scope of knowledge possessed by those skilled in the art, various changes can be made without departing from the spirit of the present invention. Many other changes and modifications made without departing from the concept and scope of the present invention should be considered within the scope of protection of the present invention.

[0043] In the description of this specification, specific features, structures, materials, or characteristics may be combined in any suitable manner in one or more embodiments or examples.

[0044] The above description is merely a specific embodiment of the present invention, but the scope of protection of the present invention is not limited thereto. Any variations or substitutions that can be easily conceived by those skilled in the art within the technical scope disclosed in the present invention should be included within the scope of protection of the present invention. Therefore, the scope of protection of the present invention should be determined by the scope of the claims.

Claims

1. The intelligent data processing system for steel plant management and statistics of the present invention is characterized in that, At least include the converter raw report module; The converter original report module includes a data display unit, a query unit, an export unit, and a report update unit. The data display unit is used to display detailed data received by the converter, including date, shift, furnace number, steel grade, length, molten iron, and scrap steel information; The query unit is used to retrieve data that meets the selected criteria, such as time, furnace number, steel type, converter number, and work group. The export unit is used to export all data displayed on the page retrieved according to the selected date and save it locally, making it convenient for users to perform data backup, offline analysis and data sharing; The update report cell is used to recalculate and update all data in the original converter table for the selected date.

2. The intelligent data processing system for steel plant management and statistics as described in claim 1, characterized in that, It also includes the refining furnace raw report module: The refining furnace original report module includes a data display unit, a query unit, and an export unit; The data display unit is used to display detailed data received by the refining furnace, including date, shift, furnace number, steel type, length, lime, and refining lime information; The query unit is used to retrieve data that meets the selected criteria, such as date, furnace number, shift, and steel type. The export unit is used to export all data displayed on the page retrieved according to the selected date and save it locally, making it convenient for users to perform data backup, offline analysis, and data sharing.

3. The intelligent data processing system for steel plant management and statistics as described in claim 1, characterized in that, It also includes a refining furnace production report module: The refining furnace production report module includes: a data display unit, a query unit, an export unit, and a report update unit. The data display unit is used to display detailed data of the refining furnace statistics, including date, shift, furnace number, steel grade, length, lime, and refining lime information; The query unit is used to retrieve data that meets the selected criteria, such as date, furnace number, shift, and steel type. The export unit is used to fill out a form according to the set requirements and save it locally, which facilitates data backup, offline analysis and data sharing for users; The report update function is used to recalculate and update all data in the refining furnace production report for the selected date.

4. The intelligent data processing system for steel plant management and statistics as described in claim 1, characterized in that, It also includes a steelmaking production report module: the steelmaking production report module is divided into "converter section", "continuous casting section" and "other sections without steel grade information".

5. The intelligent data processing system for steel plant management and statistics as described in claim 4, characterized in that, The converter section is equipped with a data display unit, a query unit, an export unit, and an update report unit; The data display unit is used to display detailed statistics on converters, including date, furnace number, steel grade, number of steelmaking furnaces, amount of molten iron, scrap steel, steel production, and information on lime. The query unit is used to retrieve data that meets the selected criteria, such as report type, date, furnace number, and steel grade. The export unit is used to fill out a form according to the set requirements and save it locally, which facilitates data backup, offline analysis and data sharing for users; The report update function is used to recalculate and update all data for the converter section based on the selected date.

6. The intelligent data processing system for steel plant management and statistics as described in claim 4, characterized in that, The continuous casting section is equipped with a data display unit, a query unit, an export unit, and an update report unit; The data display unit is used to display detailed data on continuous casting statistics, including information such as date, casting machine number, steel grade, number of steel pulling furnaces, molten iron, scrap steel, molten steel consumption, and number of billets. The query unit is used to retrieve data that meets the selected conditions based on the selected report type, date, and casting machine number. The export unit is used to fill out a form according to the set requirements and save it locally, which facilitates data backup, offline analysis and data sharing for users; The update report cell is used to recalculate and update all data for the continuous casting section under the selected date.

7. The intelligent data processing system for steel plant management and statistics as described in claim 4, characterized in that, The other sections without steel grade information include a data display unit, a query unit, an export unit, and an update report unit; The data display unit is used to display detailed statistics on blast furnace, electricity consumption, gas consumption, and water consumption, including information on date, blast furnace feed, refining electricity consumption, compressed air volume, argon volume, nitrogen consumption, oxygen consumption, and coal gas volume. The query unit is used to retrieve data that meets the set conditions based on the report type and date options; The export unit is used to fill out a form according to the set requirements and save it locally, which facilitates data backup, offline analysis and data sharing for users; The update report unit is used to recalculate and update all data in other steel grade information sections for the selected date, based on the selected date.

8. The intelligent data processing system for steel plant management and statistics as described in claim 1, characterized in that, Also includes: The report module for the third shift of steelmaking includes a data display unit, a query unit, an export unit, and a report update unit; The data display unit is used to display detailed statistics of the refining furnace, including information such as date, furnace number, shift, number of furnaces, billet output, casting output, average furnace output, and amount of molten iron fed into the furnace. The query unit is used to retrieve data that meets the set conditions based on the report type, date, and shift options; The export unit is used to fill out a form according to the set requirements and save it locally, which facilitates data backup, offline analysis and data sharing for users; The update report unit is used to recalculate and update all data in the steelmaking shift 3 report for the selected date.

9. A method for intelligent data processing in steel plant management and statistics, wherein the method is implemented based on the intelligent data processing system for steel plant management and statistics as described in claim 1, characterized in that, The method includes the following steps: Data update steps: In the converter original report module and the refining furnace original report module, data is automatically added based on changes in converter and refining furnace information in the database; in the refining furnace production report, steelmaking production report, and steelmaking shift report modules, the previous day's data is statistically analyzed and updated at 5:00 AM every day based on the relevant results already in the database; manual updates can also be performed through the update report function on each interface, and the system will automatically update the data according to the selected date, store it in the database, and display it on the page; Data query and filtering steps: Based on the user's query needs, the required query conditions are set in each module. According to the selected conditions, the system retrieves data that meets the conditions from the database and displays it. Data export and backup steps: When users need to save or share the queried data, the query results are exported to a specified local path in a specific format to achieve data backup and offline analysis, making it convenient for users to further process and study the data.

Images