G. M. Voldman, Independent Expert, Doctor of Сhemical Sciences, Moscow, Russia, e-mail: gvoldman@bk.ru

Liquid-liquid extraction is widely used in the hydrometallurgy of non-ferrous, rare and radioactive metals. The most difficult of the tasks solved using this method is the separation of elements with similar properties, in which, as a rule, it is necessary to obtain one or even both elements in pure form and with a high recovery. In most cases, this is achieved only in the complete countercurrent process, which is realized in a cascade consisting of two parts — extraction, which ensures the production of a worse extractable component (or a group of components) in a pure form in the aqueous phase (raffinate), and washing, which ensures additional extraction of a worse extractable component (or a group of components) into a raffinate or obtaining a better extractable component (or a group of components) in pure form in the organic phase (extract). However, the washing solution dilutes the original solution, which leads to a decrease in the concentrations of the components in the products. To reduce this negative effect, it is possible to reduce the volume of the washing solution by lowering the distribution coefficients of the separated components in the washing part of the cascade and again increasing them in the extraction part. This type of separation is called a full countercurrent process with decreasing distribution coefficients in the washing part. Since the organic phase from the extraction part of the cascade enters the washing part, and the aqueous phase from the washing part together with the initial solution enters the extraction one, when determining the required conditions for extraction separation (i.e., the necessary ratios of the extractant and washing solution flows to the flow of the initial solution, the number of stages extraction and washing parts of the cascade, the compositions of the products obtained – raffinate and extract), the full countercurrent cascade can be calculated only as a whole. As a result, the execution of the calculation is associated with a large amount of computation and takes a lot of time even when using modern computing means. An effective way to automate calculations is to create templates in the Excel^© spreadsheet processor environment that allow, when switching to another extraction system, not to program the calculation again, but only to enter new initial data into the corresponding cells of the template. This article is devoted to the development of such a template for a complete countercurrent process with constant but different distribution coefficients of the components in the extraction and washing parts of the cascade.

1. Zelikman А. N., Meerson G. А. Metallurgy of rare metals. Moscow : Metallurgiya, 1973. 608 p.
2. Yagodin G. А., Sinegribova О. А., Chekmarev А. М. Rare metal technology in nuclear engineering. Moscow : Atomizdat, 1974. 344 p.
3. Rare and scattered elements. Chemistry and technology. In 3 books. Edited by S. S. Korovin. Moscow : MISiS, book 1, 1996. 376 p; book 2, 1999. 461 p.; book 3, 2003. 440 p.
4. Voldman G. М., Zelikman А. N. Theory of hydrometallurgical processes. 4^th edition, revised and additional. Moscow : Intermet Inzhiniring, 2003. 464 p.
5. Gupta С. К., Krishnamurthy N. Extractive metallurgy of rare earths. Boca Raton ; London ; New York ; Washington : CRC Press, 2005. 522 p.
6. Kasikov А. G. Application of liquid extraction in new hydrometallurgical processes of copper-nickel raw materials processing at the Kola Mining and Metallurgical Company. Tsvetnye Metally. 2012. No. 7. pp. 29–35.
7. Regel-Rosocka М., Alguacil F. J. Recent trends in metals extraction. Revista de Metalurgia. 2013. Vol. 49, No. 4. pp. 292–316.
8. Wilson A. M., Bailey P. J., Tasker P. A., Turkington J. R., Grant R. A. et al. Solvent extraction: the coordination chemistry behind extractive metallurgy. Chemical society reviews. 2014. Vol. 43, No. 1. pp. 123–134.
9. Feng Xie, Ting An Zhang, Dreisinger D., Doyle F. A critical review on solvent extraction of rare earths from aqueous solutions. Mineral Engineering. 2014. Vol. 56. pp. 10–28.
10. Bukin V. I., Zimina G. V., Nikolaeva I. I., Tauk М. V. Separation of rareearth metals by liquid extraction. Tsvetnye Metally. 2015. No. 2. pp. 64–70.
11. Zimina G. V., Nikolaeva I. I., Tauk М. V., Tsygankova М. V. Extraction schemes of rare earth metals` separation. Tsvetnye Metally. 2015. No. 4. pp. 23–27.
12. Valkov А. V. Cost-effective separation of rare earth concentrates. Tsvetnye Metally. 2020. No. 2. pp. 42–49.
13. Korpusov G. V. Rare earth elements. Chemistry of long-lasting fragmentation elements. Moscow : Atomizdat, 1970. pp. 111–179.
14. Voldman G. М. Fundamentals of extraction and ion-exchange processes in hydrometallurgy. Moscow : Metallurgiya, 1982. 305 p.
15. Savelyev N. I. Balance calculations of chemical technological processes. Cheboksary : Izdatelstvo Chuvashskogo universiteta. 2014. 136 p.
16. Apanasenko V. V., Voldman G. М. Computation of material balance of technologic processes via electronic worksheet Excel. Tsvetnye Metally. 2010. No. 9. pp. 59–66.
17. Gasanov А. А., Semenov А. А., Apanasenko V. V., Yurasova О. V. Calculation of complete counter-current extraction cascade with exchange washing using Excel. Tsvetnye Metally. 2016. No. 5. pp. 44–49.
18. Voldman G. М., Apanasenko V. V. Calculation of extraction separation in full current-counter cascade with distribution constants by using Excel. Tsvetnye Metally. 2018. No. 3. pp. 57–64.