Operation load statistical method and system for pickling rolling unit

Abstract

The invention discloses an operation load statistical method for an acid rolling unit. The method comprises the following steps: S1, analyzing an operation resume log; and S2, processing the operation resume log and counting operation load data. The invention further discloses an operation load statistics system of the pickling rolling unit. According to the method, the problems that the operation of the whole-line operation table cannot be subjected to statistical analysis and the operation and management cannot be optimized in the prior art are solved.

Description

Technical Field

[0001] The invention relates to a statistical technology of a pickling mill, and more specifically to an operating load statistical method and system of a pickling mill. Background Art

[0002] The pickling mill is mainly used to process hot-rolled steel coils. The pickling mill will perform welding, pickling, rolling and other operations on the strip. The operating load in the production process will directly affect the load status of the equipment, and thus have an important impact on the entire production process. Therefore, it is very important to conduct statistics on the operating load of the pickling mill, which can be used to understand the load status of the production equipment, discover and solve problems, and thus improve production efficiency.

[0003] However, the current statistical technology for the operating load of the acid rolling unit is not mature, which makes it impossible to conduct statistical analysis on the operations of the operating stations of the entire line and to optimize the operations and management. Summary of the invention

[0004] In view of the defects existing in the prior art, the purpose of the present invention is to provide an operating load statistics method and system for a pickling mill, so as to solve the problem that it is impossible to conduct statistical analysis on the operation of the operating stations of the entire line and to optimize the operation and management.

[0005] To achieve the above object, the present invention adopts the following technical solution:

[0006] A first aspect of the present invention provides a method for calculating the operating load of a pickling mill, comprising the following steps:

[0007] S1. Analyze the operation history log;

[0008] S2. Process the operation history log and calculate operation load data.

[0009] Preferably, the step S1 of parsing the operation history log specifically includes the following steps:

[0010] S101, obtaining all the history files in the operation history file directory of the pickling mill;

[0011] S102, traversing and obtaining the unprocessed history files;

[0012] S103, renaming the resume file currently being processed and adding a suffix ".processing";

[0013] S104, reading the content of the resume file being processed, reading one line each time;

[0014] S105, extracting log time, log type, and log content from the current line;

[0015] S106, judging whether there is a number of 8 to 15 digits in the log content by using a regular expression, if not, proceeding to step S17, if yes, intercepting the number of 8 to 15 digits as the steel coil number by using a regular expression;

[0016] S107, split the log type into strings using “-” to obtain an operation type and an operation code;

[0017] S108, determining whether the operation type is "0", if so, obtaining the operation station number through a regular expression, if not, obtaining the screen number, button number and input box number through a regular expression;

[0018] S109, reading the operation configuration table, and searching the operation configuration table according to the operation type to obtain the unit area to which the operation belongs;

[0019] S110, insert the data obtained by the above analysis into the log record table log_records, and determine whether all rows have been processed. If so, proceed to step S112, if not, return to step S104;

[0020] S112, changing the suffix of the processed history files to ".processing", and determining whether all the history files have been processed, if so, proceeding to step S113, if not, returning to step S102;

[0021] S113, the analysis of the operation history log is completed.

[0022] Preferably, in step S102, the unprocessed history file is obtained every 30 seconds through the log analysis processing program.

[0023] Preferably, in step S105, the log time is intercepted by intercepting 19 characters starting from the 6th digit;

[0024] To extract the log type, eight characters are extracted starting from the 28th character.

[0025] The log content is intercepted from the 35th bit to the end of the line.

[0026] Preferably, the step S2 of processing the operation history log and calculating the operation load data specifically includes the following steps:

[0027] S201, query of operation load details;

[0028] S202, operation load analysis;

[0029] S203, operation load summary;

[0030] S204. Operation load comparison.

[0031] Preferably, the load detail query operation in step S201 specifically includes:

[0032] The operation load details are filtered in the log record table log_records according to the selected query filtering condition.

[0033] Preferably, the query screening conditions include operation area, operation time, and operation content.

[0034] Preferably, the operation load analysis in step S202 specifically includes:

[0035] According to the selected time range, the operation records within the time range are first filtered out in the log record table log_records, and then the data in the four areas are grouped according to the operation code and the number of operations is counted, and the top 10 operation data with the largest number of operations are taken out, and the operation load analysis data is displayed in the form of a chart.

[0036] Preferably, the step S203 of operating load summary specifically includes:

[0037] The data of the past year is queried in the log record table log_records, and the operation load is grouped and summarized by month and displayed on the page in the form of a chart.

[0038] Preferably, the load comparison operation in step S204 specifically includes:

[0039] According to the selected time range, the operation records within the time range are firstly filtered out in the log record table log_records, and then the operation times of each team are counted by team group to form the operation load comparison between the teams, which is displayed on the page in the form of a chart.

[0040] A second aspect of the present invention provides an operating load statistics system for a pickling mill, comprising:

[0041] An operation history log analysis and processing module is used to parse the operation history log;

[0042] An operation load statistics module, used to process the operation history log and generate statistics of operation load data;

[0043] The operating load statistics system of the pickling mill group realizes the operating load statistics method of the pickling mill group.

[0044] The present invention provides an operation load statistics method and system for a pickling mill group. The method and system perform statistical analysis on the operation table numbers and buttons, operation computers, operation screen names and numbers, the usage frequency and usage time periods of the entire line, form relevant statistical reports according to work groups and time, analyze the operation habits of each team member, and count the operation frequency of each operation, so as to filter out unnecessary operation behaviors and put forward relevant suggestions, thereby optimizing the operation and management process. BRIEF DESCRIPTION OF THE DRAWINGS

[0045] Figure 1 It is a schematic diagram of the process of parsing the operation history log in step S1 of the operation load statistics method of the present invention;

[0046] Figure 2 It is a flow chart of processing the operation history log and calculating the operation load data in step S2 of the operation load statistics method of the present invention;

[0047] Figure 3 It is a schematic diagram of the operation history log;

[0048] Figure 4 It is a schematic diagram showing the results of the operation load analysis in step S202 of the operation load statistics method of the present invention;

[0049] Figure 5 It is a schematic diagram showing the result of operation load comparison in step S204 in the operation load statistics method of the present invention. DETAILED DESCRIPTION

[0050] In order to better understand the above technical solution of the present invention, the technical solution of the present invention is further described below in conjunction with the accompanying drawings and embodiments.

[0051] The present invention provides a method for calculating the operating load of a pickling mill, comprising the following steps:

[0052] S1. Analyze the operation history log, specifically including the following steps:

[0053] S101. The production line server will write all the operation and alarm records of the production line into a text file in real time, with one operation record per line, and obtain all the operation history files in the operation history file directory of the pickling mill;

[0054] S102, the log analysis processing program runs once every 30 seconds, obtains all unprocessed files in the operation history directory, and traverses to obtain unprocessed history files;

[0055] S103, renaming the resume file currently being processed and adding the suffix ".processing";

[0056] S104, reading the content of the resume file being processed, reading one line each time;

[0057] S105, intercept the log time, log type, and log content from the current line; intercept the log time by intercepting 19 characters starting from the 6th position; intercept the log type by intercepting 8 characters starting from the 28th position; intercept the log content by intercepting from the 35th position to the end of the line, such as Figure 3 As shown;

[0058] S106, judging whether there is a number of 8 to 15 digits in the log content by using a regular expression, if not, proceeding to step S17, if yes, intercepting the number of 8 to 15 digits as the coil number by using a regular expression;

[0059] S107, split the log type into strings using "-" to obtain the operation type and operation code;

[0060] S108, determine whether the operation type is "0", if so, obtain the operation station number through a regular expression, if not, obtain the screen number, button number and input box number through a regular expression;

[0061] S109, reading the operation configuration table, and searching the operation configuration table according to the operation type to obtain the unit area to which the operation belongs;

[0062] S110, insert the data obtained by the above analysis into the log record table log_records, and determine whether all rows have been processed. If so, proceed to step S112, if not, return to step S104;

[0063] S112, changing the suffix of the processed resume file to ".processing", and determining whether all resume files have been processed, if so, proceeding to step S113, if not, returning to step S102;

[0064] S113. When all files in the history directory are processed, the parsing of the operation history log is completed.

[0065] S2. Processing the operation history log and calculating the operation load data, specifically including the following steps:

[0066] S201, operation load details query: the operation history log analysis and processing module processes the history log to obtain the log record table log_records, and the operation load details are filtered in this table according to the query conditions selected on the page. The filterable conditions include operation area, operation time, and operation content;

[0067] S202, operation load analysis: according to the selected time range, first filter out the operation records within the time range in the log record table log_records, then group the data in the four areas by operation code and count the number of operations, take out the top 10 operation data with the largest number of operations, and display the operation load analysis data in the form of a chart;

[0068] S203, operation load summary: query the data of the past year in the log record table log_records, summarize the operation load by month, and display it on the page in the form of a chart;

[0069] S204, operation load comparison: according to the selected time range, first filter out the operation records within the time range in the log record table log_records, then count the number of operations of each team by team group, form an operation load comparison between teams, and display it on the page in the form of a chart.

[0070] The present invention also provides an operating load statistics system for a pickling mill, comprising:

[0071] An operation history log analysis and processing module is used to parse the operation history log;

[0072] Operation load statistics module, used to process operation history logs and generate statistics of operation load data;

[0073] The operating load statistics method of the acid rolling mill group of the present invention is realized by the operating load statistics system of the acid rolling mill group of the present invention.

[0074] Those skilled in the art should recognize that the above embodiments are only used to illustrate the present invention, and are not intended to limit the present invention. As long as they are within the spirit of the present invention, any changes or modifications to the above embodiments will fall within the scope of the claims of the present invention.

Claims

1. A method for calculating the operating load of a pickling mill, characterized in that: The following steps are involved: S1. Analyze the operation history log; S2. Process the operation history log and calculate operation load data.

2. The method for calculating the operating load of a pickling mill according to claim 1, characterized in that: The step S1 of parsing the operation history log specifically includes the following steps: S101, obtaining all the history files in the operation history file directory of the pickling mill; S102, traversing and obtaining the unprocessed history files; S103, renaming the resume file currently being processed and adding a suffix ".processing"; S104, reading the content of the resume file being processed, reading one line each time; S105, extracting log time, log type, and log content from the current line; S106, judging whether there is a number of 8 to 15 digits in the log content by using a regular expression, if not, proceeding to step S17, if yes, intercepting the number of 8 to 15 digits as the steel coil number by using a regular expression; S107, split the log type into strings using "-" to obtain an operation type and an operation code; S108, determining whether the operation type is "0", if so, obtaining the operation station number through a regular expression, if not, obtaining the screen number, button number and input box number through a regular expression; S109, reading the operation configuration table, and searching the operation configuration table according to the operation type to obtain the unit area to which the operation belongs; S110, insert the data obtained by the above analysis into the log record table log_records, and determine whether all rows have been processed. If so, proceed to step S112, if not, return to step S104; S112, changing the suffix of the processed history file to ".processing", and determining whether all the history files have been processed, if so, proceeding to step S113, if not, returning to step S102; S113, the analysis of the operation history log is completed.

3. The method for calculating the operating load of a pickling mill according to claim 2, characterized in that: In the step S102, the unprocessed history file is obtained every 30 seconds through the log analysis processing program.

4. The method for calculating the operating load of a pickling mill according to claim 2, characterized in that: In the step S105, the log time is intercepted by intercepting 19 characters starting from the 6th digit; To extract the log type, eight characters are extracted starting from the 28th character. The log content is intercepted from the 35th bit to the end of the line.

5. The method for calculating the operating load of a pickling mill according to claim 2, characterized in that: The step S2 of processing the operation history log and calculating the operation load data specifically includes the following steps: S201, query of operation load details; S202, operation load analysis; S203, operation load summary; S204. Operation load comparison.

6. The method for calculating the operating load of a pickling mill according to claim 5, characterized in that: The step S201 of querying the load details specifically includes: The operation load details are filtered in the log record table log_records according to the selected query filtering condition.

7. The method for calculating the operating load of a pickling mill according to claim 6, characterized in that: The query screening conditions include operation area, operation time, and operation content.

8. The method for calculating the operating load of a pickling mill according to claim 6, characterized in that: The operation load analysis in step S202 specifically includes: According to the selected time range, the operation records within the time range are first filtered out in the log record table log_records, and then the data in the four areas are grouped according to the operation code and the number of operations is counted, and the top 10 operation data with the largest number of operations are taken out, and the operation load analysis data is displayed in the form of a chart.

9. The method for calculating the operating load of a pickling mill according to claim 8, characterized in that: The step S203 of operating load summary specifically includes: The data of the past year is queried in the log record table log_records, and the operation load is grouped and summarized by month and displayed on the page in the form of a chart.

10. The method for calculating the operating load of a pickling mill according to claim 9, characterized in that: The load comparison operation in step S204 specifically includes: According to the selected time range, the operation records within the time range are firstly filtered out in the log record table log_records, and then the operation times of each team are counted by team group to form the operation load comparison between the teams, which is displayed on the page in the form of a chart.

11. An operating load statistics system for a pickling mill, characterized in that: include: An operation history log analysis and processing module is used to parse the operation history log; An operation load statistics module, used to process the operation history log and generate statistics of operation load data; The operating load statistics system of the pickling mill group implements the operating load statistics method of the pickling mill group as claimed in any one of claims 1-10.

Images