.png){kind=icon}
.png){kind=icon}
Return
Excel-HSL: An Excel-based harmony search language for easy optimization problem solving
.png){kind=icon}
PRE
AI
DOI：10.1016/j.softx.2026.102679.png)
.png){kind=icon}
Original request for help.png){kind=icon}
Share.png){kind=icon}
Save
Abstract
En 中文
This paper presents Excel-HSL, an Excel-based solver that allows users to apply the Harmony Search (HS) algorithm without writing code. By combining an intuitive text-based modeling syntax with Excel's built-in Evaluate function, Excel-HSL streamlines the formulation and execution of optimization problems. Benchmark tests on four engineering design problems demonstrate that Excel-HSL achieves accuracy comparable to Python implementations of GA, PSO, and HS. The software lowers the programming barrier and overcomes the usability limitations of Excel's traditional Solver, providing an accessible optimization platform for students, researchers, and engineers.
Keywords:
Optimization
Harmony search algorithm
MS Excel VBA
Domain-specific language