Automating specialized mineral processing calculations with an accurate and fast Excel add-in

Document Type : Technical Note

Authors

1 CEO of Novin Liner Company, Rafsanjan, Iran

2 Dept. of Mining Engineering, Faculty of Engineering, Vali-Asr University, Rafsanjan, Iran

10.22034/anm.2025.23599.1694

Abstract

Performance evaluation of processes in the mining industry—particularly in mineral processing units—relies heavily on the application of complex and often lengthy mathematical formulas and relationships. Microsoft Excel, as one of the primary tools for computation and data analysis in scientific and industrial domains, has long been widely used by engineers and researchers. Despite its diverse capabilities, Excel lacks many of the specialized formulas required in the field of mineral processing. This deficiency has compelled many professionals to spend considerable time manually writing complex formulas and combining general-purpose functions. Such practices are not only prone to computational errors and mistakes arising from unit conversions and misinterpretation of formulas, but also significantly reduce the accuracy and efficiency of specialized calculations.

Keywords

Main Subjects

References

[1]                 G. Corey. "A Brief History of Microsoft Excel." https://www.nobledesktop.com/classes-near-me/blog/history-of-microsoft-excel (accessed.
[2]                 P. Spreadsheet. "History of Microsoft Excel - With Timeline." https://spreadsheetplanet.com/excel/history/ (accessed.
[3]                 N. Charlie. "Statistics and Data Analysis with Excel, Part 1." https://www.coursera.org/learn/statistics-and-data-analysis-with-excel-part-1 (accessed.
[4]                 S. Prof. "Microsoft Excel for Scientists and Engineers." https://www.udemy.com/course/microsoft-excel-for-scientists-and-engineers/ (accessed.
[5]                 S. Shamima. "From Spreadsheet to Insight: A Complete Data Science Workflow in Excel." https://www.exceldemy.com/from-spreadsheet-to-insight-a-complete-data-science-workflow-in-excel/ (accessed.
[6]                 Q. E. B. H. W. S. L. M. M. L. M. P. Carl M. Rebman Jr, "An Industry Survey of Analytics Spreadsheet Tools Adoption: Microsoft Excel vs Google Sheets," 2023. [Online]. Available: https://files.eric.ed.gov/fulltext/EJ1409034.pdf.
[7]                 L. Giuliano De. "Master New Excel Translation Features: A Quick Guide." https://www.hubsite365.com/en-ww/crm-pages/how-to-use-the-new-translation-functions-in-excel-6cdd1383-3f64-48a7-b198-afe230838813.htm (accessed.
[8]                 E. Sean. "Microsoft Excel joins the 1 billion installs club on Android." https://www.windowscentral.com/excel-joins-1-billion-installs-club-android (accessed.
[9]                 P. Tony. "Microsoft 365 vs. Office 2024: What's the Difference?" https://www.howtogeek.com/microsoft-365-vs-office-2024-whats-the-difference/ (accessed.
[10]             C. Bianca. "The 11 Best Free Microsoft Excel Alternative Programs in 2025." https://www.techrepublic.com/article/free-alternatives-to-microsoft-excel/ (accessed.
[11]             K. Vartika. "12 Best Microsoft Excel Alternatives & Competitors for 2025." https://www.proofhub.com/articles/best-microsoft-excel-alternatives (accessed.
[12]             B. A. Wills and J. Finch, Wills' Mineral Processing Technology: An Introduction to the Practical Aspects of Ore Treatment and Mineral Recovery. Butterworth-Heinemann, 2015.
[13]             R. P. King, Modeling and Simulation of Mineral Processing Systems. Elsevier Science & Technology Books, 2001.
[14]             "Metallurgist Blog," 2025/10/16. [Online]. Available: https://www.911metallurgist.com/blog/.
[15]             C. Microsoft, "Microsoft to acquire GitHub for $7.5 billion," 2018/06/04 2018. [Online]. Available: https://news.microsoft.com/source/2018/06/04/microsoft-to-acquire-github-for-7-5-billion/.
 
Journal of Analytical and Numerical Methods in Mining Engineering
Volume 16, Issue 48 - Serial Number 48
October 2026
Pages 121-130

Files

History

  • Receive Date: 30 August 2025
  • Revise Date: 17 October 2025
  • Accept Date: 07 November 2025

Share

How to cite

Statistics