![]() You can install the OpenSolver Add-on by clicking on the Chrome Web Store link below and then clicking on the “Free” button. As of April 2016 we now provide some redundancy in solver choice by supporting using GLPK via glpk.js to solve problems inside your browser, and using Cbc on the NEOS Server to solve problems in the cloud. We use the excellent, open source solvers Glop (for LP) and SCIP (for MIP) to solve the problems. ![]() With the OpenSolver Add-on you can solve both linear and mixed-integer programs from within Google Sheets with no additional setup required. OpenSolver has also made it to Google Sheets, letting you solve your optimisation problems with OpenSolver from anywhere! PS: We are a volunteer project, so this would be a good time to step up if you have JaveScript/Google skills… We hope to have someone look at the code in the next few months. Andrew 21 June 2021Īvoid Spaces in Sheet Names: We have had a report that OpenSOlver for Google Sheets has problems if the sheet names have spaces in them. We would welcome volunteers who could assist with this. Unfortunately, we don’t currently have a timeline for this issue being fixed. OpenSolver for Google Sheets Not Working for Some Users: Google have changed something in their code which has broken OpenSolver for Google Sheets for some users (who cannot interact with the OpeSolver panel).
0 Comments
Leave a Reply. |