Method for accumulating and taking effect parameter thresholds of different glass specifications of float glass
By defining glass specification naming rules and judgment basis in the float glass production process, and using database and mqtt messages to realize real-time monitoring and automatic switching of parameter thresholds, the problem of threshold monitoring and effectiveness of different glass specification parameters is solved, and the automation and reliability of the production process is improved.
Patent Information
- Application Number
- CN202210366514.3
- Authority / Receiving Office
- CN · China
- Patent Type
- Patents(China)
- Current Assignee / Owner
- Filing Date
- 2022-04-08
- Publication Date
- 2025-06-17
- Estimated Expiration
- 2042-04-08
AI Technical Summary
In the production process of float glass, how to realize real-time monitoring and automatic switching of thresholds of various parameters of different glass specifications to ensure the timely effectiveness of parameters during the production process and avoid quality failure and economic losses.
By defining the glass specification naming rules and judgment basis, using the timely query database to obtain real-time plate width and plate thickness signals, judge the glass specification switching, and send an mqtt message. Create a table that stores parameter thresholds, calculate and update each parameter threshold, and realize timely effectiveness and automatic switching of parameter thresholds.
Real-time monitoring of inverter parameters under various glass specifications of float glass is realized, ensuring the timely effectiveness of parameter thresholds, improving the automation and reliability of the production process, and avoiding production abnormalities and economic losses.
Smart Images

Figure CN114817247B_ABST
Abstract
Description
Technical Field
[0001] The invention relates to the technical field of industrial float glass, in particular to a method for accumulating and validating threshold values of parameters of different glass specifications of float glass. Background Art
[0002] The edge drawing machine is one of the main equipments in the tin bath section of the float glass production line. It plays an important role in throttling, thinning, accumulating thickness and controlling the direction of the glass plate. Its principle is to rely on the edge drawing wheel at the front end of the edge drawing machine to pull the glass ribbon with a certain viscosity floating on the tin bath liquid surface forward. The thickness of the glass ribbon can be controlled and the width of the glass ribbon can be stabilized by adjusting the linear speed of the edge drawing wheel, the horizontal swing angle of the edge drawing wheel, the plane inclination angle, etc. The edge drawing machine motor is controlled by a frequency converter. In addition to meeting the basic speed regulation function, the biggest advantage lies in the control accuracy and reliability, reducing the thickness difference of the glass and improving the product quality.
[0003] Float glass production is a continuous production process. Once an abnormality occurs during the production process and is not discovered in time, the quality of the produced glass may not meet the standards and be scrapped, resulting in economic losses due to production suspension, and may even lead to production accidents. In the normal production process, the frequency, speed, current, power, etc. adjusted by the inverter are different for different glass specifications and models. Generally, the above parameters fluctuate within a certain range. The inverter parameters can reflect the production status to a certain extent, so it is of great significance to monitor the inverter parameters. However, in the actual production process, there are many glass specifications and models. After producing a certain glass specification, it may be immediately switched to another glass specification. How to automatically switch to the parameter threshold monitoring system of a certain glass specification, how to automatically accumulate the parameter thresholds of each glass specification in real time, and how to make the accumulated thresholds take effect in time are the current problems. Summary of the invention
[0004] The purpose of the present invention is to solve the problems in the prior art and to propose a method for accumulating and taking effect threshold values of parameters of different glass specifications of float glass, which can achieve the purpose of real-time monitoring of inverter parameters under various glass specifications of float glass.
[0005] To achieve the above object, the present invention proposes a method for accumulating and taking effect threshold values of parameters of different glass specifications of float glass, comprising the following steps:
[0006] S1. Define the naming rules for glass specifications and the basis for judging the replacement of glass specifications;
[0007] S2. Accumulation and effectiveness of threshold values of parameters for different glass specifications:
[0008] S21: Obtain the plate width and plate thickness signals of each production line collected in real time by querying the database at regular intervals, and determine whether the glass specification has been switched according to the judgment basis for glass specification replacement. If it has been switched, send an MQTT message, and at the same time store the relevant information of the glass into the glass_species_warning table in the database;
[0009] S22: Create a table warn_rules in the database to store the information of each parameter threshold;
[0010] S23: Query the database table glass_species_warning at regular intervals, obtain the glass specification information of the last two for each production line, and select the relevant data of the frequency converter for a period of time backward to determine whether to calculate the thresholds of each parameter. After meeting the calculation requirements, calculate and update the thresholds of each parameter;
[0011] S24: After accumulating the thresholds of each parameter for each glass specification, it is necessary to determine whether the accumulated glass specification thresholds take effect in a timely manner, otherwise false alarms may occur;
[0012] S3. Automatic switching of different glass specifications stage: S21 mentioned sending an MQTT message and subscribing to the relevant topic. When the glass specification changes, according to the MQTT message sent in step S21 received, the glass specification is processed into a format that meets the glass specification naming rule, and compared with the glass specification information of the same production line in the warn_rules table. If the glass specification exists in the warn_rules table, the thresholds of each parameter of this glass specification take effect, that is, enable = 1; otherwise, the thresholds of each parameter under all glass specifications of this production line become invalid, that is, enable = 0.
[0013] Preferably, step S1 specifically includes the following steps:
[0014] S11: Define the glass specification naming rule: Usually, the glass specification consists of the glass thickness (plate thickness) and the glass width (plate width). Define the glass specification model format as: plate thickness / plate width; where the tens and units digits of the plate width are set to zero (for example: plate thickness 2.5, plate width 3533, then the glass specification is: 2.5 / 3500);
[0015] S12: Define the judgment basis for glass specification replacement:
[0016] a) The plate thickness has changed;
[0017] b) The first two digits of the numerical values of the front and rear plate widths are inconsistent (for example: the first two digits of 3411 and 3350 are different);
[0018] If any one of the above conditions is met, it can be determined that the glass specification has been switched. If none of them are met, it is not determined that the glass specification has been switched.
[0019] Preferably, in step S23, the relevant data of the frequency converter includes speed, frequency, current, and power data. Considering that it is meaningless to calculate the thresholds of each parameter during a fault, determining whether to calculate the thresholds of each parameter is based on the condition that the current change value of the frequency converter is within 5A, and the calculated thresholds of each parameter are stored in the database table warn_rules.
[0020] Preferably, in step S23, after determining that the thresholds of each parameter can be calculated, the calculation rules of the thresholds of each parameter are as follows:
[0021] Speed: Calculate the 95th percentile of the speed, denoted as a1. Then the upper limit of the speed is: a1 + b1, and the lower limit is a1 - b1;
[0022] Frequency: Calculate the 95th percentile of the frequency, denoted as a2. Then the upper limit of the speed is: a2 + b2, and the lower limit is a2 - b2;
[0023] Current: Calculate the 95th percentile a3 and the 5th percentile a4 of the current. Then the upper limit of the current is: a3 * b3, and the lower limit of the current is a4 * b4;
[0024] Power: Calculate the 100th percentile of the power, denoted as a5. If a5 < 1, then the upper limit of the power is: 1 + a5. If a5 >= 1, then the upper limit of the power is: a5 * b5;
[0025] Among them, b1, b2, b3, b4, and b5 are determined based on the analysis of the accumulated data.
[0026] Preferably, in step S23, considering that for the same glass specification, the set frequency of the frequency converter may fluctuate within a small range, a threshold automatic update mechanism is introduced: after determining that the glass specification has been switched, select the speed, frequency, current, and power data for a period of time backward, calculate the thresholds, and first determine whether the conditions for calculating the thresholds of each parameter are met. If they are met, compare them with the thresholds of the same glass specification before and update the thresholds.
[0027] Preferably, in step S23, after introducing the threshold automatic update mechanism and determining that the thresholds of each parameter can be calculated, the calculation rules of the thresholds of each parameter are as follows:
[0028] Rotation speed: Calculate the 95th percentile of the rotation speed, denoted as a6. Then the upper limit of the rotation speed is: a6 + b6, and the lower limit is a6 - b6. If the upper limit of the rotation speed is higher than the previous upper limit of the rotation speed, overwrite the calculated upper limit of the rotation speed with the previous one; otherwise, do not overwrite. If the lower limit of the rotation speed is lower than the previous lower limit of the rotation speed, overwrite the calculated lower limit of the rotation speed with the previous one; otherwise, do not overwrite.
[0029] Frequency: Calculate the 95th percentile of the frequency, denoted as a7. Then the upper limit of the rotation speed is: a7 + b7, and the lower limit is a7 - b7. If the upper limit of the frequency is higher than the previous upper limit of the frequency, overwrite the calculated upper limit of the frequency with the previous one; otherwise, do not overwrite. If the lower limit of the frequency is lower than the previous lower limit of the frequency, overwrite the calculated lower limit of the frequency with the previous one; otherwise, do not overwrite.
[0030] Current: Calculate the 95th percentile a8 and the 5th percentile a9 of the current. Then the upper limit of the current is: a8 * b8, and the lower limit of the current is a9 * b9. If the upper limit of the current is higher than the previous upper limit of the current, overwrite the calculated upper limit of the current with the previous one; otherwise, do not overwrite. If the lower limit of the current is lower than the previous lower limit of the current, overwrite the calculated lower limit of the current with the previous one; otherwise, do not overwrite.
[0031] Power: Calculate the 100th percentile of the power, denoted as a10. If a10 < 1, then the upper limit of the power is: 1 + a10. If a10 >= 1, then the upper limit of the power is: a10 * b10. If the upper limit of the power is higher than the previous upper limit of the power, overwrite the calculated upper limit of the power with the previous one; otherwise, do not overwrite.
[0032] Among them, b6, b7, b8, b9, and b10 are determined based on the accumulated data analysis.
[0033] Preferably, the steps for judging the glass specification change in step S21 are as follows:
[0034] S21.1 Create a table glass_species to record the relevant information of the latest glass on each production line. This table includes fields: date_time (timestamp), device_code (production line), thickness_cur_val (plate thickness), grosswidth_cur_val (plate width);
[0035] S21.2 Regularly query the database for information such as the plate thickness and plate width of each production line and process it: If the plate thickness remains unchanged, the plate width becomes: plate width / / 100 * 100;
[0036] S21.3 Compare whether the glass specifications are the same: Query the glass_species table. After processing the plate thickness and plate width in the table in the same way as in S21.2, compare them with the plate width and plate thickness in S21.2. If the plate thicknesses are not equal or the plate widths are not equal, then the glass specifications of the two are different; otherwise, the glass specifications of the two are the same.
[0037] Preferably, in step S24, the judgment rule for whether the accumulated glass specification threshold takes effect in a timely manner is as follows:
[0038] For the last glass specification information, query whether there is a record with enable being 1 among the records in the warn_rules table with the same production line, the same position, and non-empty glass specifications. If there is, set enable to 0; if not, query the glass_species_warning table again; if within the range from the end_date (the termination time of querying the glass_species_warning table during step S23) to the current time now_date in the glass_species_warning table, there is such a production line and the glass specification of the last record has changed, then set enable to 0; otherwise, set enable to 1;
[0039] For the penultimate glass specification information, query the glass_species_warning table again. If within the range from the end_date (the termination time of querying the glass_species_warning table during step S23) to the current time now_date in the glass_species_warning table, there is such a production line and the glass specification of the last record is the same as this glass specification, then set enable to 1; otherwise, set enable to 0;
[0040] Preferably, in step S23, regularly query the database table glass_species_warning. The query frequency is once every hour, and the query time range is 1 hour. The termination time end_date of the query time is stored in the database table glass_species_end_date, and the start time is start_date = end_date - 1; after each query ends, add 1 to end_date and update it into the table glass_species_end_date.
[0041] Preferably, after obtaining the glass specification information of the last two for each production line in step S23, select the speed, frequency, current, and power data of the frequency converter within the range of 1 to 2 hours after the end_date (the termination time of step S23). It is relatively accurate to calculate the threshold after waiting for 1 hour for stability after the glass specification change.
[0042] Preferably, in step S22, warn_rules includes the following fields: id (primary key), rule_type (rule type, including two types: RT1001 and RT1002), rule_desc (rule description, RT1001 represents upper and lower limits, RT1002 represents a single value, i.e., the upper limit), pt_id (parameter point id), device_code (production line code), tag_code (point code, corresponding one-to-one with pt_id), lower_limit (lower threshold), upper_limit (upper threshold), lower_result (description for exceeding the upper limit), upper_result (description for being lower than the lower limit), specifications (glass specification model), data_type (data type corresponding to the point, such as current, rotation speed, etc.), enable (threshold effectiveness flag bit, 1 represents effective, 0 represents ineffective).
[0043] Preferably, in step S21, the plate width and plate thickness signals of each production line are updated every 5 minutes, and the frequency of regularly querying the database is set to once per minute.
[0044] Preferably, the mqtt message format in step S21 is as follows: The message is a list, which contains the timestamp date_time, production line device_code, plate thickness thickness_cur_val, plate width grosswidth_cur_val, etc. For example: [{"date_time":"2021-09-08 11:20:00","device_code":"WHLD900-136","thickness_cur_val":10.0,"grosswidth_cur_val":4900}].
[0045] Preferably, the calculation rules for each parameter threshold in step S23 mainly target the situation of initially accumulating a certain glass specification in the warn_rules table. Taking the parameter current as an example, after calculating the upper and lower limits of the current within the above-mentioned 1 hour in S23, the relevant information is stored in the warn_rules table, where id is the snowflake id, rule_type is "RT1001", rule_desc is "upper and lower limits", pt_id is the point id corresponding to the current, device_code is the production line code, tag_code is the point code of the current, lower_limit is the current lower limit, upper_limit is the current upper limit, lower_result is "below the current lower limit", upper_result is "above the current upper limit", specifications is the current glass specification model "thickness / width", data_type is "current", and enable is 0 or 1, with 1 representing effective.
[0046] Advantages of the present invention:
[0047] Based on the collected glass specification information and signals such as the rotation speed, frequency, current, and power of the frequency converter, the present invention realizes the real-time accumulation of each parameter threshold for different glass specifications of float glass and the timely effectiveness of the accumulated thresholds, achieving the purpose of automatically switching to monitor each parameter under a certain glass specification, so as to ensure that production anomalies can be detected in a timely manner and notified to on-site workers.
[0048] The features and advantages of the present invention will be described in detail through embodiments in conjunction with the drawings. Description of the drawings
[0049] Figure 1 is a flowchart of a method for accumulating and validating each parameter threshold for different glass specifications of float glass according to the present invention;
[0050] Figure 2 is a flowchart of the process of automatically switching glass specifications in the present invention. Detailed implementation manners
[0051] To facilitate understanding of the technical solution of the present invention, the following takes the frequency converter signals and glass specification information collected by the gateway installed on the float glass of a certain factory as an example for detailed description.
[0052] The gateway collects the frequency converter signals corresponding to the main drive motor of the float line of a certain factory and the glass specification information. The acquisition frequency of the frequency converter signals is one set of data every 10S, and the acquisition frequency of the glass specification information is one set of data every 5 minutes.
[0053] The entire implementation process of the present invention is divided into two parts: 1. The accumulation and effectiveness part of the parameter thresholds for different glass specifications; 2. The part of automatically switching the glass specifications.
[0054] 1. Refer to Figure 1 , and the specific process of the accumulation and effectiveness part of the parameter thresholds for different glass specifications is as follows:
[0055] Step 1.1: Create a table warn_rules in the database to store the information of each parameter threshold.
[0056] Step 1.2: By querying the database regularly, obtain the signals of the plate width and plate thickness of each production line collected in real time, and judge whether the glass specification has been switched according to the judgment basis for glass specification replacement. If it has been switched, store the information such as the timestamp, production line, plate thickness, and plate width into the glass_species_warning table in the database.
[0057] Step 1.3: Regularly query the database table glass_species_warning to obtain the last two glass specification information of each production line. Select the speed, frequency, current, and power data of the frequency converter for a period of time backward, and calculate whether the change value of the current satisfies not being greater than 5A. If it satisfies, the threshold calculation of each parameter can be carried out. The calculation rules of each parameter threshold are as follows:
[0058] Speed
[0059] Calculate the 95th percentile of the speed, denoted as a1. Then the upper limit of the speed is: a1 + b1, and the lower limit is a1 - b1 (b1 is determined according to the accumulated data analysis, and 30 is selected here).
[0060] Frequency
[0061] Calculate the 95th percentile of the frequency, denoted as a2. Then the upper limit of the speed is: a2 + b2, and the lower limit is a2 - b2 (b2 is determined according to the accumulated data analysis, and 2 is selected here).
[0062] Current
[0063] Calculate the 95th percentile a3 and the 5th percentile a4 of the current. Then the upper limit of the current is: a3 * b3, and the lower limit of the current is a4 * b4 (b3 and b4 are determined according to the accumulated data analysis, and 1.2 and 0.8 are selected here respectively).
[0064] Power
[0065] Calculate the percentile of power, denoted as a5. If a5 < 1, the power upper limit is: 1 + a5. If a5 >= 1, the power upper limit is: a5 * b5 (b5 is determined after analyzing the accumulated data, and here 1.3 is selected).
[0066] Store the calculated parameter thresholds in the database table warn_rules.
[0067] Step 1.4: Considering that for the same glass specification, the set frequency of the frequency converter may fluctuate within a small range, a threshold automatic update mechanism is introduced:
[0068] After judging the glass specification switch, select the rotational speed, frequency, current, and power data for a period of time backward, and judge whether the change value of the current satisfies not being greater than 5A. If it is satisfied, the thresholds of each parameter can be calculated, compared with the thresholds of the same glass specification before, and the thresholds are updated:
[0069] 1. Rotational speed
[0070] Calculate the 95th percentile of the rotational speed, denoted as a6. Then the rotational speed upper limit is: a6 + b6, and the lower limit is a6 - b6 (here b6 remains the same as before, taking 30). If the rotational speed upper limit is higher than the previous rotational speed upper limit, cover the calculated rotational speed upper limit with the previous one, otherwise do not cover; if the rotational speed lower limit is lower than the previous rotational speed lower limit, cover the calculated rotational speed lower limit with the previous one, otherwise do not cover.
[0071] 2. Frequency
[0072] Calculate the 95th percentile of the frequency, denoted as a7. Then the rotational speed upper limit is: a7 + b7, and the lower limit is a7 - b7 (here b7 remains the same as before, taking 2). If the frequency upper limit is higher than the previous frequency upper limit, cover the calculated frequency upper limit with the previous one, otherwise do not cover; if the frequency lower limit is lower than the previous frequency lower limit, cover the calculated frequency lower limit with the previous one, otherwise do not cover.
[0073] 3. Current
[0074] Calculate the 95th percentile a8 and the 5th percentile a9 of the current. Then the current upper limit is: a8 * b8, and the current lower limit is a9 * b9 (b8 and b9 remain the same as before, here 1.2 and 0.8 are selected respectively). If the current upper limit is higher than the previous current upper limit, cover the calculated current upper limit with the previous one, otherwise do not cover; if the current lower limit is lower than the previous current lower limit, cover the calculated current lower limit with the previous one, otherwise do not cover.
[0075] 4. Power
[0076] Calculate the percentile of power, denoted as a10. If a10 < 1, the power upper limit is: 1 + a10. If a10 >= 1, the power upper limit is: a10 * b10 (b10 remains the same as before, here we choose 1.3). If the calculated power upper limit is higher than the previous power upper limit, overwrite the previous power upper limit with the calculated one; otherwise, do not overwrite.
[0077] Step 1.5: After accumulating the parameter thresholds for each glass specification, it is necessary to determine whether the accumulated glass specification thresholds take effect in a timely manner, otherwise false alarms may occur. The judgment rules are as follows:
[0078] For the last glass specification information, query the warn_rules table to check if there is a record with enable = 1 among the records of the same production line, the same position, and non-empty glass specification. If so, set enable to 0; if not, query the glass_species_warning table again. If during Step 1.4 or Step 1.5, within the range from the end_date (the termination time of querying the glass_species_warning table) to the current time now_date, there is such a production line in the table and the glass specification of the last record has changed, then set enable to 0; otherwise, set enable to 1.
[0079] For the penultimate glass specification information, query the glass_species_warning table again. If during Step 1.4 or Step 1.5, within the range from the end_date (the termination time of querying the glass_species_warning table) to the current time now_date, there is such a production line in the table and the glass specification of the last record is the same as this glass specification, then set enable to 1; otherwise, set enable to 0.
[0080] II. Refer to Figure 2 for the specific process of automatically switching glass specifications:
[0081] Step 2.1: By regularly querying the database, obtain the plate width and plate thickness signals of each production line collected in real time. According to the judgment basis for glass specification replacement, determine whether the glass specification has been switched. If it has been switched, send an mqtt message, and the mqtt contains information such as timestamp, production line, plate thickness, and plate width.
[0082] Step 2.2: As mentioned in Step 2.1, an MQTT message is sent and relevant topics are subscribed to. After receiving the MQTT message, the glass specifications are processed into the format of "plate thickness / plate width" and compared with the glass specification information of the same production line in the warn_rules table. If the glass specifications exist in the warn_rules table, the parameter thresholds for these glass specifications become effective, i.e., enable = 1. Otherwise, the parameter thresholds for all glass specifications of this production line become ineffective, i.e., enable = 0.
[0083] The above embodiments are illustrative of the present invention and not restrictive thereof. Any solution obtained by simply transforming the present invention falls within the protection scope of the present invention.
Claims
1. A method for accumulating and validating parameter thresholds of different glass specifications in float glass, characterized in that: It includes the following steps: S1. Define the naming rules for glass specifications and the judgment basis for glass specification replacement; S2. The accumulation and effective stage of parameter thresholds for different glass specifications: S21: Obtain the plate width and plate thickness signals of each production line collected in real time, and judge whether the glass specification has been switched according to the judgment basis for glass specification replacement. If it is switched, an mqtt message is sent, and the relevant information of the glass is stored in the glass_species_warning table in the database; S22: Create a table warn_rules in the database to store the information of each parameter threshold; S23: Regularly query the database table glass_species_warning, obtain the glass specification information of the last two for each production line, and select the relevant data of the frequency converter for a period of time backward, judge whether to calculate the thresholds of each parameter, and after meeting the calculation requirements, calculate and update the thresholds of each parameter; S24: Judge whether the accumulated glass specification thresholds take effect in time after accumulating the thresholds of each parameter for each glass specification; S3. Automatic switching of different glass specifications stage: After the glass specification is changed, according to the mqtt message sent in step S21 received, the glass specification is processed into a format that meets the glass specification naming rules, and compared with the glass specification information of the same production line in the warn_rules table. If the glass specification exists in the warn_rules table, the thresholds of each parameter of the glass specification take effect, that is, enable = 1; otherwise, the thresholds of each parameter under all glass specifications of the production line become invalid, that is, enable = 0; In step S23, the relevant data of the frequency converter includes speed, frequency, current, and power data, and it is judged whether to calculate the thresholds of each parameter. Taking the current change value of the frequency converter within 5A as the prerequisite for calculating the thresholds of each parameter, and store the calculated thresholds of each parameter in the database table warn_rules; In step S23, after judging that the thresholds of each parameter can be calculated, the calculation rules of the thresholds of each parameter are as follows: Speed: Calculate the 95th percentile of the speed, denoted as a1, then the upper limit of the speed is: a1 + b1, and the lower limit is a1 - b1; Frequency: Calculate the 95th percentile of the frequency, denoted as a2, then the upper limit of the speed is: a2 + b2, and the lower limit is a2 - b2; Current: Calculate the 95th percentile a3 and the 5th percentile a4 of the current, then the upper limit of the current is: a3 * b3, and the lower limit of the current is a4 * b4; Power: Calculate the 100th percentile of the power, denoted as a5. If a5 < 1, the upper limit of the power is: 1 + a5. If a5 >= 1, the upper limit of the power is: a5 * b5; Among them, b1, b2, b3, b4, and b5 are determined after analyzing the accumulated data; In step S23, a threshold automatic update mechanism is introduced: after determining the glass specification switch, select the rotational speed, frequency, current, and power data for a period of time backward, calculate the threshold. First, also determine whether the conditions for calculating the thresholds of each parameter are met. If they are met, compare with the thresholds of the same glass specification before and update the thresholds.
2. The method for accumulating and validating parameter thresholds of different glass specifications in float glass according to claim 1, characterized in that: Step S1 specifically includes the following steps: S11: Define the naming rule for glass specifications: Define the glass specification model format as: thickness / width; S12: Define the judgment basis for glass specification replacement: a) The thickness has changed; b) The first two digits of the numerical values of the front and rear widths are inconsistent; If any one of the above is satisfied, it can be determined that the glass specification has been switched. If none of them are satisfied, it is not determined that the glass specification has been switched.
3. The method for accumulating and validating parameter thresholds of different glass specifications in float glass according to claim 1, characterized in that: In step S23, a threshold automatic update mechanism is introduced. After determining that the thresholds of each parameter can be calculated, the calculation rules for the thresholds of each parameter are as follows: Rotational speed: Calculate the 95th percentile of the rotational speed, denoted as a6. Then the upper limit of the rotational speed is: a6 + b6, and the lower limit is a6 - b6; if the upper limit of the rotational speed is higher than the previous upper limit of the rotational speed, cover the calculated upper limit of the rotational speed with the previous one, otherwise do not cover; if the lower limit of the rotational speed is lower than the previous lower limit of the rotational speed, cover the calculated lower limit of the rotational speed with the previous one, otherwise do not cover; Frequency: Calculate the 95th percentile of the frequency, denoted as a7. Then the upper limit of the rotational speed is: a7 + b7, and the lower limit is a7 - b7; if the upper limit of the frequency is higher than the previous upper limit of the frequency, cover the calculated upper limit of the frequency with the previous one, otherwise do not cover; if the lower limit of the frequency is lower than the previous lower limit of the frequency, cover the calculated lower limit of the frequency with the previous one, otherwise do not cover; Current: Calculate the 95th percentile a8 and the 5th percentile a9 of the current. Then the upper limit of the current is: a8 * b8, and the lower limit of the current is a9 * b9; If the upper limit of the current is higher than the previous upper limit of the current, cover the calculated upper limit of the current with the previous one, otherwise do not cover; if the lower limit of the current is lower than the previous lower limit of the current, cover the calculated lower limit of the current with the previous one, otherwise do not cover; Power: Calculate the 100th percentile of the power, denoted as a10. If a10 < 1, the upper limit of the power is: 1 + a10. If a10 >= 1, the upper limit of the power is: a10 * b10; if the upper limit of the power is higher than the previous upper limit of the power, cover the calculated upper limit of the power with the previous one, otherwise do not cover; Among them, b6, b7, b8, b9, and b10 are determined based on the analysis of the accumulated data.
4. The method for accumulating and validating parameter thresholds of different glass specifications in float glass according to claim 1, characterized in that: The steps for determining the glass specification change in step S21 are as follows: S21.1 Create a table glass_species to record the relevant information of the latest glass on each production line. This table includes fields: date_time, device_code, thickness_cur_val, grosswidth_cur_val; S21.2 Query the database regularly for the plate thickness and width messages of each production line and process them: the plate thickness remains unchanged, and the plate width becomes: plate width / / 100 * 100; S21.3 Compare whether the glass specifications are the same: Query the glass_species table. After processing the plate thickness and width in the table in the same way as in S21.2, compare them with the plate width and thickness in S21.
2. If the plate thicknesses are not equal or the plate widths are not equal, then the glass specifications of the two are different; otherwise, the glass specifications of the two are the same.
5. A method for accumulating and taking effect of parameter thresholds for different glass specifications of float glass according to claim 1, characterized in that: In step S24, the judgment rule for whether the accumulated glass specification threshold takes effect in a timely manner is: For the last piece of glass specification information, query whether there is a record with enable being 1 in the warn_rules table for the same production line, the same position, and non-empty glass specifications. If there is, set enable to 0; if not, query the glass_species_warning table again; if within the range from the end_date of querying the glass_species_warning table during step S23 to the current time now_date, there is such a production line in the table and the glass specification of the last record has changed, then set enable to 0; otherwise, set enable to 1; For the penultimate piece of glass specification information, query the glass_species_warning table again. If within the range from the end_date of querying the glass_species_warning table during step S23 to the current time now_date, there is such a production line in the table and the glass specification of the last record is the same as this glass specification, then set enable to 1; otherwise, set enable to 0.
6. A method for accumulating and taking effect of parameter thresholds for different glass specifications of float glass according to claim 1, characterized in that: In step S23, query the database table glass_species_warning regularly. The query frequency is once every hour, and the query time range is 1 hour. The end time end_date of the query time is stored in the database table glass_species_end_date, and the start time is start_date = end_date - 1; after each query ends, add 1 to end_date and update it into the table glass_species_end_date.
7. A method for accumulating and taking effect of parameter thresholds for different glass specifications of float glass according to claim 1, characterized in that: After obtaining the last two pieces of glass specification information for each production line in step S23, select the speed, frequency, current, and power data of the frequency converter within the range of 1 to 2 hours after the end_date of step S23, and judge that after the glass specification changes, wait for 1 hour to stabilize before calculating the threshold.
Citation Information
Patent Citations
Edge roller one-key plate changing method and device for float glass production
CN110342791A