Hello everyone,
We are pleased to announce a new release of OpenSolver for Google Sheets. This fixes bugs in the GLPK solver and NEOS-Cbc solver options which made them unavailable. These engines should now be working and available.
Errors which stopped the GLPK solver from running were related to local variables in scriptlets not being defined before Html template objects ‘glpkWorkerJs’ and ‘glpkRunnerJs’ were evaluated and ran these scriptlets. Errors such as “ReferenceError: gmplModel not defined” should now go away since local copies of these variables are initialised inside these scriptlets.
As of January 8, 2021, NEOS requires that an email address be submitted with every job. The NEOS-Cbc bug was related to this – originally we did not include a user email address in the xml file sent to the NEOS server.
Since NEOS now requires that each job contain an email address, we include the user’s email address in the xml file. This email address is only sent to NEOS when the model is being solved and only if the user selects NEOS-Cbc as the solver engine.
We have updated our privacy policy and information about OpenSolver for Google Sheets to reflect these changes.
As always, we welcome your feedback. Please comment below if it works ok, or if you encounter issues, or if you have any questions regarding the new release. Thanks!
Opensolver for Google Sheets will allow me to open the sidebar but will not allow me to choose which sheet to work in. There is no way to fill in the data to run the solver.
Have you checked the videos which show how to use OpenSolver for Google Sheets? See https://opensolver.org/opensolver-for-google-sheets/