![]() If you have any feature requests or experience any problems while using it, please let us know either here or by using the “Report an Issue” button inside Google Sheets (you can find this in “Add-ons > OpenSolver > Help”). This means there are many new features to consider and add to the addon as it evolves over time. There are also a lot of possibilities that are created by the online aspect of Google Sheets (such as sharing sheets and multiple users on a sheet at once). OpenSolver for Google Sheets is younger and less mature than the Excel version, so does not yet have the full range of features as in the Excel version. (You might also want to try Jeffrey’s online tool for building & solving models using the MathProg modelling language.) To run these yourself, you will need to copy the files to your own Google Drive, and install OpenSolver for Google from the Sheets add-on menu. Jeffrey Kantor has kindly provided several small examples of models he developed for teaching purposes in Google Sheets using OpenSolver. This means that you can build larger models by repeatedly resuming the solve and letting it run for another 6 minutes each time. If an incomplete solve is detected, you will be asked whether you want to resume the solve or start over from scratch. If the solve is ended early because of the timelimit, we can use the saved model and pick up from where we left off. As we proceed with building the model, we regularly save our progress, and then delete the saved model once the solve is complete. To address this, we have added the ability to “resume” a solve. This means that if your model takes longer than 6 minutes to solve, the procedure will just cut out at the 6-minute mark with no feedback. One limitation of the Google Sheets platform is that there is a timelimit of 6 minutes for any script to run. Once you have selected a solver, you can build and solve the model using the “Solve Model” button, which will load the solution into the sheet when it is finished. Instead, you should select on the sheet the relevant range, and then click the appropriate “Update” button to load this range into the appropriate area of the model.īelow are some screenshots of various models defined inside the Google Sheets interface (you can click to make these larger):
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |