Coke data management method based on VBA technology and data perspective table

Abstract

The invention discloses a coke data management method based on a VBA technology and a data perspective table. The coke data management method comprises the following steps: exporting quasi primary coke data and quasi secondary coke data from a database according to a preset time interval; copying data obtained by querying the quasi first-level coke data and the quasi second-level coke data according to the quality indexes to two workbooks, namely a coke quality change trend summary table and an outsourcing coke data perspective table; setting a perspective table format, unifying a date and a supplier name, calculating a qualified rate, and updating the coke quality change trend summary table and the data perspective table once every time quasi first-grade coke data and quasi second-grade coke data are updated; and integrating the VBA statements in the above steps into a window interface, and automatically updating the queried data to a coke quality change trend summary table and an outsourcing coke data perspective table by clicking a command button. According to the data management method, the working efficiency is improved, and meanwhile, the data accuracy is ensured.

Description

technical field [0001] This application relates to a coke data management method based on VBA technology and data pivot table. Background technique [0002] At present, coke, one of the raw materials required for blast furnace production, is generally produced by coke ovens. Due to the limited daily production of self-produced coke, it is necessary to supplement purchased coke to meet the production practice. There are dozens of suppliers of purchased coke, and the quality fluctuates greatly. Quality fluctuation will affect the fluctuation of blast furnace conditions. In order to ensure stable ironmaking production, it is necessary to monitor and manage the quality indicators of purchased coke in multiple directions. The parameters of quality indicators of purchased coke are required every week, such as: strength after reaction, coke powder, moisture, etc. Calculate the average value and pass rate. At present, most of the ledgers for outsourced coke data management rely on ...

AI Technical Summary

Problems solved by technology

[0003] Due to the inconsistency of the data format exported from the quality network, manual identification and verification of the data is error-prone and cannot be simply copied and pasted. It is necessary to repeatedly check the indicators and corresponding parameters. The amount of operation is large, the cycle is frequent, time-consuming and labor-intensive, and it is difficult to form effective data. management method

Images