Hi,

I recently created a model that was too large for Excels stock Solver plug-in, and so I was looking into upgrades for this such as OpenSolver, SolverStudio, and also the official upgrade Analytical Solver provided by the creators of the original Solver. The only solver and engine that worked to provide a global solution were Analytical Solver with the OptQuest engine. However, I don't want to spend 5k for this year and 2.5k every year after to optimize my model. Anyone know if there are free alternative engines that work as well as OptQuest? The model is nonsmooth by the way.

I've tried NOMAD with OpenSolver, which provided a decent answer which wasn't the global solution though.
Also ran BONMIN, but receiving an error for referencing out of the sheet, although Andrew (creator of OpenSolver) said that OpenSolver is not compatible with the new table referencing so I might try to edit my model and re-run BONMIN, which I've heard good things about.
Didn't get anywhere with Solver Studio since it requires Python, and I would've had to name ranges and do other tedious things

Thank you