We cannot turn the addins into formulae, which is what all the other solvers need. So no, only Nomad will work, sorry. Andrew

Thanks for your response.
I used OpenSolver Advanced with NOMAD and I verified that the combination can be used in spreadsheets that require other addins. Unfortunately, its performance was only effective in problems with few variables as indicated by the solvers guide.
Is there any way to do the same with COIN-OR? It would be a great news!

For most solvers, OpenSolver builds a model from the spreadsheet to give the solver, and so cannot interact with other addins during solving. However, the NOMAD solver just does a brute-force grid search and recalculates the sheet for each trial solution. This means addins can be used with NOMAD. Let us know if this works for you. Andrew

Thanks for your queries. We have no servers of our own, but instead use optimisation servers that are provided publicly or as a commercial service, or run on your own machine. Each of these solvers is detailed in the “Choose a Solver” dialog window. Two examples are:

The GNU Linear Programming Kit (GLPK) is a software package intended for solving large-scale linear programming (LP), mixed integer programming (MIP), and other related problems. GLPK is free software and licensed under the GNU General Public License 3. OpenSolver uses glpk.js, a Javascript port of GLPK by Henri Gourvest. This solver runs on your machine rather than an external server, and so is likely to be a faster option.

The NEOS (Network-Enabled Optimization System) Server is a free Internet-based service for solving optimization problems. Models sent to NEOS often have to wait in a queue before they are solved, depending on the current load on NEOS. For this reason, other solvers are usually faster. Submitting a model to NEOS results in it becoming publicly available. Use of NEOS is subject to the NEOS Terms and Conditions.

The default solver is provided by Google, and runs as a web service under their terms and conditions.

We send the mathematical equations that define your model to the server; your spreadsheet is not sent.

Hope this helps,

Andrew

Questions:
1. If OpenSolver sends my info to your servers, then what exactly gets sent? The entire spreadsheet? Only those cells specified in the controls? My own GAS scripts?
2. Do you retain/log any cell data that is sent?

Thank you very much for your quick response!

The spreadsheet is not uploaded. The equations that make up the objective function and constraints are uploaded along with the cell names. It would be very hard to reverse the intent of a model from this. Andrew