Journals →  Tsvetnye Metally →  2018 →  #2 →  Back

ArticleName Analysis of metallurgical production in Excel at “Karabashmed” enterprise
DOI 10.17580/tsm.2018.02.03
ArticleAuthor Korol Yu. A., Zubov P. V.

JSC “Russian Copper Company”, Ekaterinburg, Russia:

Yu. A. Korol, Vice-President


JSC “Karabashmed”, Karabash, Russia:
P. V. Zubov, Deputy Head of Production Department, e-mail:


The copper-smelting enterprise “Karabashmed” developed and implemented a program for preparing manufacturing statements and their analysis. This program is based on Microsoft Excel. We developed an algorithm for the sequence of data entering, the order in which they are entered, and authenticity check. The program contains analytical balance files, including up to 2 million formulas with background processing for revealing mistakes when compiling balance files. At the same time, the authorized operator is able to analyse and correct these files. In order to achieve maximum reliability of the resultant data, we simultaneously carry out balance compiling and analytical accounting with ten components: copper, zinc, lead, gold, silver, palladium, iron, sulfur, silicon dioxide and calcium oxide. This enables us to obtain analytical information about these components both separately and in combination. If the new tasks appear, a user with basic skills in working with table editors can improve the designed software without the programmer’s assistance. The data for analysis are introduced in 5 to 15 minutes. The general report about 24-hour work of enterprise is formed in an hour after the set start time (that is 9 a. m. for Karabashmed). The monthly balance and review is formed in 2 or 3 hours after receiving the data about average monthly analysis and removal of residuals of raw materials, half-finished products and finished products. The designed program may be applied at any metallurgical enterprise that has limits regarding raw materials acceptance, smelting, converting, gas-purifying, obtaining sulfuric acid, processing of repetition materials, receipt and dispatching of finished products after minimal adaptation concerning terminology and names of raw materials, half-finished products and wares.

keywords Metallurgical shop, sulphuric acid shop, blister copper, concentrate, dressing, Excel, production balance, file, formula, program, analysis of production accounting

1. J. Luckhoff, J. Apfel, J. Buttler. The concept of complete automation for electric steelmaking shops. Chernye Metally. 2017. No. 9. pp. 21–24.
2. U. Schneppe. Technological and digital networks for management of hot rolling mill in Hagen. Chernye Metally. 2017. No. 9. pp. 53–57.
3. Tao F., Zhang L., Laili Y. Configurable intelligent optimization algorithm: design and practice in manufacturing. Berlin : Springer, 2014. 364 p.
4. Wang J. S., Zhang L., Gao X. W., Sun S. F. Intelligent control method of rotary kiln process based on image processing technology: a survey. 29 Chinese Conference (CCC). 2010. pp. 2930–2935.
5. Salikhov M. Z., Salikhov Z. G. Intelligent system for automatic control of powerful rotating furnaces, designed for sintering of free-flowing metallurgical materials using associative knowledge bases. Tsvetnye Metally. 2017. No. 7. pp. 90–96.
6. Industrial Automation and Control Solutions from Honeywell. Honeywell. Available at:
7. Petukhov M. Yu., Zakiev A. R., Borodin P. E., Artemev S. B. Process automation for material balance agreement at oil-processing enterprise — Production Balance. Avtomatizatsiya v promyshlennosti. 2014. No. 8. pp. 22–28.
8. Somov V. E., Lisitsyn N. V., Kuzichkin N. V. Inprovement of factory accounting system at oil-processing enterprise. Neftepererabotka i neftekhimiya. 2009. No. 2. pp. 3–9.
9. Yeates G. The mining industry disrupted. AusIMM Bulletin. Available at:
10. Savitskiy V. S. Results of complex introduction of ERP-system IT-Enterprise n JSC “Ukrainskiy grafit”. IX International scientific and practical conference “IT — Business — Metal”. Moscow, 19–21 June 2007.
11. Material balancing system I-DRMS. Industrial automation “Indasoft”. Available at:
12. Material balances of enterprise. Production management. Available at :

Language of full-text russian
Full content Buy