How To Use Google Sheets Solver
You can also find us by searching for opensolver in the google sheets add on store.
How to use google sheets solver. Click on go to google sheets. Open an excel file from gmail email. You can solve linear programming and mixed integer programming problems with the simplex lp solver nonlinear optimization. Open a new sheet from google sheet. You can install the opensolver add on by clicking on the chrome web store link below and then clicking on the free button.
And when you find it install it. Click on file upload. Select a template or click blank option. Click go to google drive. On google sheets the solver is one of the add ons.
Once the add on is installed you can find opensolver in the add ons menu inside the spreadsheet. Click on open with google sheet. In order to load the solver we need to go to add ons click on get add ons type solver in the search box. Open an excel file from google drive.