Accurate aluminum discharge data fusion method for electrolytic cell and application of accurate aluminum discharge data fusion method

Abstract

The invention belongs to the technical field of electrolytic aluminum, and particularly relates to an electrolytic cell accurate aluminum discharge data fusion method and application, an electrolytic cell accurate aluminum discharge control system and a server connected with the electrolytic cell accurate aluminum discharge control system are included, and the server is connected with a multi-dimensional data analysis system. The data fusion method comprises the following steps: step 1, setting uploading time and a cyclic variable i on a server; 2, a server Timer control is triggered, and when the time reaches the set uploading time, the server imports data collected by the electrolytic precise aluminum discharging control system into a multi-dimensional data analysis system; step 3, the uploading operation is finished, after the next uploading time is up, the Timer control is triggered, and the latest collected data is uploaded to the multi-dimensional data analysis system; and 4, repeating the step 3. According to the method, the electrolysis production can be predicted and guided in a multi-dimensional manner. The optimal working mode is provided for staff, heat balance is well managed and controlled, occurrence of disease grooves is reduced, and the purposes of saving energy and reducing maintenance cost are achieved.

Description

TECHNICAL FIELD

[0001] The application belongs to the technical field of electrolytic aluminum, and particularly relates to a method for fusing precise aluminum tapping data of an electrolytic cell and application thereof. BACKGROUND

[0002] In the production of electrolytic aluminum, precise control of the aluminum tapping process of a single electrolytic cell is crucial, which is directly related to the stable operation of the electrolytic cell, product quality and production efficiency. In the existing aluminum tapping production management, the aluminum tapping operation relies on the visual reading of the weight of the aluminum package on the LED screen by the operator, and the aluminum tapping amount is controlled by adjusting the air valve. After the aluminum tapping is completed, the aluminum tapping amount of a single electrolytic cell is calculated and manually recorded, and finally manually input into an Excel report. Since the entire aluminum tapping measurement process is completely controlled by manual operation, the aluminum tapping precision is affected by manual operation, the precision error is large, and the aluminum tapping data is prone to distortion, which has a great adverse effect on the judgment of the operating state of the electrolytic cell by the operator and brings adverse effects on the balanced and stable production of the aluminum electrolytic cell. In the prior art, the electrolytic site client is connected with the precise aluminum tapping control system server, the planned aluminum tapping amount of a single electrolytic cell can be issued through the electrolytic site client, and the actual aluminum tapping amount is automatically controlled and regulated by the controller, and the single-cell aluminum tapping deviation can be controlled within ±30 kg. After the aluminum tapping link is completed, the electrolytic precise aluminum tapping control system stores the related aluminum tapping information of each electrolytic single cell in the server database in real time. The management personnel query and analyze the data through the Excel report of the electrolytic precise aluminum tapping control system to guide the electrolytic production. However, this method is relatively single, and cannot analyze, guide and control the production site in multiple dimensions. This leads to problems such as poor control of the thermal balance of the electrolytic cell, high frequency of sick cell conditions, and low labor efficiency of the electrolytic site. Therefore, it is very necessary to design a method for fusing precise aluminum tapping data of an electrolytic cell and application thereof. SUMMARY

[0003] The purpose of the present application is to design a method for fusing precise aluminum tapping data of an electrolytic cell and application thereof, automatically transmit the aluminum tapping data of a single electrolytic cell to a multi-dimensional data analysis system, analyze and guide the multi-dimensional data of the electrolytic cell in the multi-dimensional data analysis system, and achieve the purpose of controlling the thermal balance of the electrolytic cell, reducing the occurrence of sick cell conditions, and improving the labor efficiency of the electrolytic site. To achieve the above purpose, the present application adopts the following technical solutions:

[0004] A method for fusing precise aluminum tapping data of an electrolytic cell, comprising an electrolytic precise aluminum tapping control system and a server connected therewith, the server being connected with a multi-dimensional data analysis system, and the data fusion method comprising the following steps:

[0005] Step one, setting the upload time and the loop variable i on the server;

[0006] Step two, trigger the Timer control in the server VB program, when the time reaches the set upload time, the server running program will import the data collected by the electrolytic precise aluminum tapping control system into the multidimensional data analysis system;

[0007] Step three, when the data of each single cell collected by the electrolytic precise aluminum tapping control system is uploaded into the multidimensional data analysis system, the upload operation is completed, and the Timer control is triggered when the next upload time arrives, the latest data collected by the electrolytic precise aluminum tapping control system is uploaded into the multidimensional data analysis system;

[0008] Step four, repeat step three.

[0009] Preferably, the multidimensional data analysis system is a Dassie multidimensional data analysis system.

[0010] Preferably, the background database of the electrolytic precise aluminum tapping control system and the multidimensional data analysis system is connected through the ADO control in the VB program of the server.

[0011] Preferably, the data collected by the electrolytic precise aluminum tapping control system is the aluminum tapping data of each electrolytic cell, and the loop variable i is the number of electrolytic cells.

[0012] Preferably, in step two, the server uploads the aluminum tapping data of each electrolytic cell to the multidimensional data analysis system in turn, and the value of the loop variable i is increased by one each time the aluminum tapping data of an electrolytic cell is uploaded. When the value of the loop variable i is greater than the set value (i.e. the actual number of electrolytic cells tapping aluminum on the same day), the upload operation is completed, and the next upload time is waited for.

[0013] Preferably, it also includes manual data import, which updates the aluminum tapping data of the corresponding electrolytic cell after selecting it on the server.

[0014] The application also includes an application of the electrolytic cell precise aluminum tapping data fusion method to the electrolytic cell aluminum tapping control.

[0015] Preferably, it includes a crown block, an aluminum tapping ladle, a crown block scale and an electrolytic cell, the aluminum tapping ladle is connected with the crown block through the crown block scale, the crown block, the crown block scale and the aluminum tapping ladle are connected with the electrolytic precise aluminum tapping control system, and the electrolytic precise aluminum tapping control system is used for controlling the aluminum tapping operation of the electrolytic cell and collecting the aluminum tapping data, and transmitting the aluminum tapping data to the server.

[0016] Preferably, the electrolytic precise aluminum tapping control system includes an information acquisition module, a communication module and a control module, the crown block scale is connected with the information acquisition module, the information acquisition module is connected with the control module through the communication module, the control module is connected with the server and the crown block, and the server is also connected with a work area host computer.

[0017] Preferably, the communication module is a wireless communication module.

[0018] The working principle of this invention is as follows: By connecting the electrolytic precision aluminum extraction control system and the multidimensional data analysis system via a network, and using database programming, the aluminum extraction data of each cell in the electrolytic precision aluminum extraction system is automatically transmitted to the background database of the Dassie multidimensional analysis system (which also includes parameters such as alumina feed rate, aluminum fluoride addition rate, electrolysis process parameters, and trace element content in primary aluminum and electrolyte). Then, through the analysis tools in the Dassie analysis system, multi-parameter dimensions are used to predict and guide electrolysis production. This provides employees with optimal working methods, thereby improving the electrolytic cell production process, controlling heat balance, and reducing the occurrence of cell failures, achieving the goals of energy saving, consumption reduction, and lower maintenance costs.

[0019] Compared with the prior art, the beneficial effects of the present invention are: it can automatically transmit the aluminum output data of a single electrolytic cell to a multidimensional data analysis system. Managers can log in to the multidimensional data analysis system, use the analysis tools in the system, and use the multidimensional data of the electrolytic cells in the multidimensional data analysis system for analysis and guidance. This can provide employees with the best working methods, thereby improving the electrolytic cell production process, controlling the heat balance, reducing the occurrence of defective cells, improving the labor efficiency of the electrolysis area, and achieving the purpose of energy saving, consumption reduction, and maintenance cost reduction. Attached Figure Description

[0020] The present invention will be further described below with reference to the accompanying drawings and embodiments.

[0021] Figure 1 This is a flowchart of a method for precise aluminum extraction data fusion from an electrolytic cell according to Embodiment 1 of the present invention;

[0022] Figure 2 This is a production flow diagram illustrating the application of precise aluminum output data melting in an electrolytic cell in Embodiment 2 of the present invention. Detailed Implementation

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

[0024] Example 1

[0025] like Figure 1 As shown, this embodiment proposes a method for data fusion of precise aluminum extraction from an electrolytic cell, including a precise aluminum extraction control system for electrolysis and a server connected thereto. The server is connected to a multidimensional data analysis system, which is the Dassie multidimensional data analysis system. The background databases of the precise aluminum extraction control system for electrolysis and the multidimensional data analysis system are connected through an ADO control in the VB program of the server.

[0026] The method of data fusion comprises the following steps:

[0027] Step one, setting uploading time and cycle variable i on the server; the data collected by the precise aluminum tapping control system of electrolysis is tapping data of each electrolytic cell, and the cycle variable i is the number of electrolytic cells actually tapping aluminum;

[0028] Step two, triggering the Timer control in the VB program of the server, when the time reaches the set uploading time, the program running on the server imports the data collected by the precise aluminum tapping control system of electrolysis into the multidimensional data analysis system;

[0029] Step three, when the tapping data of each single cell collected by the precise aluminum tapping control system of electrolysis is all uploaded into the multidimensional data analysis system, the uploading operation ends, and the Timer control triggers to upload the latest data collected by the precise aluminum tapping control system of electrolysis into the multidimensional data analysis system when the next uploading time arrives;

[0030] Step four, repeating step three.

[0031] In step two, the server uploads the tapping data of each electrolytic cell into the multidimensional data analysis system one by one, and the value of the cycle variable i is increased by one each time the tapping data of an electrolytic cell is uploaded, and when the value of the cycle variable i is greater than the set value (i.e. the number of electrolytic cells actually tapping aluminum on the same day), the uploading operation ends and waits for the arrival of the next uploading time.

[0032] It also includes manual data import, which updates the tapping data of the corresponding electrolytic cell after selecting it on the server.

[0033] Specifically, an import program is written on the server, the uploading time and the cycle variable i are set, the ADO component in VB language is referenced, and the databases of the two systems are connected. When the import program runs, it is divided into automatic running and manual import.

[0034] Under normal circumstances, the "automatic import" button in the import program is clicked, and the Timer control in the VB program is triggered at the same time. When the server time triggers the set uploading time, the import program uses the SQL language select statement to select the required data in the precise aluminum tapping control system, and uses the insert or update statement to insert or update the tapping data meeting the requirements into the database table of the Dassie multidimensional data analysis system. The for loop statement is used to import the tapping data of each electrolytic cell extracted from the precise aluminum tapping control system into the Dassie multidimensional data analysis system one by one. When the number of records to be uploaded is greater than the number of extracted tapping data (i.e. greater than the number of electrolytic cells actually tapping aluminum), the loop is exited, and the Timer control time trigger of the next day is waited.

[0035] In abnormal situations, such as due to communication problems or human modification and updates to the aluminum tapping control system's tapping data, the aluminum tapping data in the precision aluminum tapping control system can be selectively imported into the Dassie multidimensional data analysis system for updates by clicking the "Manual Import" button in the import program.

[0036] This invention can automatically select aluminum output data from the database of a precise aluminum output control system, trigger an upload time, and transmit and store it in the database of the Dassie multidimensional data analysis system. Based on the time on the server, it determines whether to extract, insert, or update data, thus forming a self-controlled analysis system.

[0037] Example 2

[0038] like Figure 2 As shown in the figure, this embodiment proposes an application of precise aluminum output data fusion in electrolytic cells, applying the above-mentioned method of precise aluminum output data fusion in electrolytic cells to the aluminum output control of electrolytic cells.

[0039] It includes an overhead crane, an aluminum tapping ladle, an overhead crane scale, and an electrolytic cell. The aluminum tapping ladle is connected to the overhead crane via the overhead crane scale. The overhead crane, the overhead crane scale, and the aluminum tapping ladle are all connected to an electrolytic precision aluminum tapping control system. The electrolytic precision aluminum tapping control system is used to control the aluminum tapping operation of the electrolytic cell and collect aluminum tapping data, and transmit the aluminum tapping data to a server.

[0040] The electrolytic precision aluminum extraction control system includes an information acquisition module, a communication module, and a control module. The overhead crane scale is connected to the information acquisition module, which in turn is connected to the control module via the communication module. The control module is connected to a server and the overhead crane. The server is also connected to a work area host computer, which is connected to the server's intranet. The communication module is a wireless communication module.

[0041] In practical applications, the control module receives the planned output for each electrolytic cell from the host computer in the work area. The control module then controls the overhead crane, aluminum tapping ladle, and crane scale to perform aluminum tapping operations on the corresponding electrolytic cells. The information acquisition module reads the aluminum output data (aluminum output quantity) of the electrolytic cell in real time. During the aluminum tapping process, the control module's automatic control algorithm automatically adjusts the actual aluminum output of each electrolytic cell, ensuring that the aluminum output deviation of a single cell is within ±30KG. After the aluminum tapping process is completed, the aluminum output data of the electrolytic cells is stored in real time in the database of the electrolytic precision aluminum tapping control system server.

[0042] An import program is written on the server, setting the upload time and a loop variable i. The loop variable i represents the actual number and number of aluminum electrolytic cells (electrolytic cell 1, electrolytic cell 2, electrolytic cell 3... electrolytic cell i). It uses the ADO component in VB to connect to the databases of the two systems. The import program runs in two parts: automatic execution and manual import.

[0043] Normally, click the "automatic import" button in the import program, and trigger the Timer control in the VB program at the same time. When the server time triggers the set upload time, the import program uses the SQL language select statement to select the required data in the aluminum tapping control system, and inserts or updates the aluminum tapping data that meets the requirements into the database table of the Dassie multidimensional data analysis system through the insert or update statement. Use the for loop statement to import the aluminum tapping data of each electrolytic cell extracted from the precise aluminum tapping control system into the Dassie multidimensional data analysis system one by one. After the number of records to be uploaded is greater than the number of aluminum tapping data extracted (that is, greater than the number of electrolytic cells), the loop is exited, and the Timer control time trigger of the next day is waited.

[0044] In abnormal cases, such as communication problems or manual modification and update of aluminum tapping data in the precise aluminum tapping control system, the "manual import" button of the import program can be clicked to selectively import the aluminum tapping data in the precise aluminum tapping control system into the Dassie multidimensional data analysis system for updating.

[0045] The embodiment forms an electrolytic precise aluminum tapping control system according to real-time data such as the single electrolytic cell aluminum tapping plan amount, the actual tapping amount, and the cell number. Important data in the electrolytic precise aluminum tapping control system is automatically imported into the Dassie multidimensional data analysis system through the server by database programming (the Dassie multidimensional analysis system also contains parameters such as the alumina feeding amount, the aluminum fluoride adding amount, the electrolytic process parameters, and the trace element content in the primary aluminum and electrolyte in the electrolytic process. The above parameters can be manually imported parameters, or can be collected by other information collection devices and then automatically imported. This is not described in detail as prior art), combined with other electrolytic cell parameters in the Dassie multidimensional data analysis system, the system tool is used to analyze the electrolytic cell aluminum tapping data in multiple dimensions, and then the electrolytic cell thermal balance is well controlled, the occurrence of sick cell is reduced, and the labor efficiency of the electrolytic area is improved.

[0046] The technical solution of the present application is not limited to the above specific embodiments, and any technical modification made according to the technical solution of the present application falls within the protection scope of the present application.

Claims

1. A method for data fusion of precise aluminum extraction from an electrolytic cell, comprising a precise aluminum extraction control system for electrolysis and a server connected thereto, characterized in that, The server is connected to a multidimensional data analysis system, and the data fusion method includes the following steps: Step 1: Set the upload time and loop variable i on the server; Step 2: Trigger the Timer control in the server VB program. When the set upload time is reached, the program running on the server will import the data collected by the electrolytic precision aluminum extraction control system into the multidimensional data analysis system. Step 3: Once all the data collected by the electrolytic precision aluminum extraction control system has been uploaded to the multidimensional data analysis system, the upload operation is complete. After the next upload time arrives, the Timer control will be triggered to upload the latest data collected by the electrolytic precision aluminum extraction control system to the multidimensional data analysis system. Step four, repeat step three.

2. The method for precise aluminum extraction data fusion from an electrolytic cell according to claim 1, characterized in that: The multidimensional data analysis system is the Dassie multidimensional data analysis system.

3. The method for precise aluminum extraction data fusion from an electrolytic cell according to claim 1 or 2, characterized in that: The backend database of the electrolytic precision aluminum extraction control system and the multidimensional data analysis system is connected through the ADO control in the VB program of the server.

4. The method for precise aluminum extraction data fusion from an electrolytic cell according to claim 1, characterized in that: The data collected by the electrolytic precision aluminum extraction control system are the aluminum extraction data of each electrolytic cell, and the loop variable i is the actual number of electrolytic cells that extract aluminum.

5. The method for precise aluminum extraction data fusion from an electrolytic cell according to claim 4, characterized in that: In step two, the server sequentially uploads the aluminum output data of each electrolytic cell to the multidimensional data analysis system. For each electrolytic cell's aluminum output data uploaded, the value of the loop variable i is incremented by one. When the value of the loop variable i is greater than the set value (i.e., the actual number of electrolytic cells that produced aluminum that day), the upload operation ends and waits for the next upload time to arrive.

6. The method for precise aluminum extraction data fusion from an electrolytic cell according to claim 4, characterized in that: It also includes manually importing data, updating the aluminum output data of the corresponding electrolytic cell after selecting it on the server.

7. An application of precise aluminum extraction data fusion from an electrolytic cell, characterized in that: The method for precise aluminum extraction data fusion of an electrolytic cell, as described in any one of claims 1 to 6, is applied to the aluminum extraction control of an electrolytic cell.

8. The application of precise aluminum extraction data fusion from an electrolytic cell according to claim 7, characterized in that: It includes an overhead crane, an aluminum tapping ladle, an overhead crane scale, and an electrolytic cell. The aluminum tapping ladle is connected to the overhead crane via the overhead crane scale. The overhead crane, the overhead crane scale, and the aluminum tapping ladle are all connected to an electrolytic precision aluminum tapping control system. The electrolytic precision aluminum tapping control system is used to control the aluminum tapping operation of the electrolytic cell and collect aluminum tapping data, and transmit the aluminum tapping data to a server.

9. The application of precise aluminum extraction data fusion from an electrolytic cell according to claim 8, characterized in that: The electrolytic precision aluminum extraction control system includes an information acquisition module, a communication module, and a control module. The overhead crane scale is connected to the information acquisition module, the information acquisition module is connected to the control module through the communication module, the control module is connected to the server and the overhead crane, and the server is also connected to the work area host computer.

10. The application of precise aluminum extraction data fusion from an electrolytic cell according to claim 9, characterized in that: The communication module is a wireless communication module.

Images