SolverStudio for Excel

SolverStudio AMBER Project

Andrew Mason — Tue, 29 Jun 2021 08:44:11 +0000

SolverStudio has been used by the EU-funded AMBER project to build a waterway optimisation system. To quote the project:

Welcome to AMBER River Infrastructure Planning (RIP) Tool. The model is designed to find the best combination of river infrastructure modification, mitigation, and removal actions in order to optimise trade-offs between:1) river connectivity2) project implementation cost3) hydropower generation and4) water storage capacity.The model allows a user to input baseline barrier data, barrier mitigation project data, and modify optimisation model settings.

You can download this at https://amber.international/software/

Good overview of optimisation software

Andrew Mason — Fri, 06 Oct 2017 04:23:13 +0000

There’s a great overview of software available for optimisation in Optima (volume 103, 2017), the Mathematical Optimization Society Newsletter. This includes a good tutorial for PuLP, written by its developer (and optimisation guru/consultant) Stu Mitchell.

SolverStudio at Julia/Jump Conference

Andrew Mason — Thu, 13 Jul 2017 03:58:44 +0000

Our PhD student, and JuMP coder extraordinaire, Oscar Dowson, presented on SolverStudio, Julia and JuMP at the JuliaOpt/JuMP Developers conference, June 12-16, 2017, at the Sloan School of Business, Massachusetts Institute of Technology. Watch Oscar’s presentation on YouTube.

Optimization for Pokemon Go!

Andrew Mason — Wed, 23 Nov 2016 21:46:32 +0000

Lovely article by Victor Zverovich on Pokemon Go attack optimisation using Python. Good luck with capturing those gymns… Andrew

SolverStudio for Puzzle Solving

Andrew Mason — Sat, 28 May 2016 08:10:42 +0000

There’s a nice article “IP in the i” by Martin J. Chlond in “INFORMS Transactions on Education 16(1), pp. 39–41” about using SolverStudio to solve the new Wijuko and ABC Logic puzzles, including a SolverStudio impleme ntation.

SolverStudio 0.09.03 (20160520) released

Andrew Mason — Fri, 20 May 2016 00:05:34 +0000

We have released SolverStudio_00_09_03_00 20160520. This includes:

Fixes for NEOS to avoid connection aborted errors (caused by NEOS getting tougher, and us having been pinging their server too frequently).
Update of CMPL to v1.1, which gives substantial speed improvements. (Thanks, Mike, for this.) This improves support for Mike’s CMPL/SolverStudio textbook.
Update to GLPK/GMPL 4.6

SolverStudio_00_09_03_00 20160520.zip (104493 downloads )

Analytics Textbook using SolverStudio

Andrew Mason — Fri, 13 May 2016 03:12:10 +0000

If you speak German, you may be interested in the recently published book:

Mike Steglich, Dieter Feige und Peter Klaus: Logistik-Entscheidungen: Modellbasierte Entscheidungsunterstützung in der Logistik mit LogisticsLab, 2. aktualisierte und komplett überarbeitete Auflage, De Gruyter, Berlin und Boston 2016.

This covers using SolverStudio and the CMPL modelling language. Mike Steglich has done a great job of adding CMPL support to SolverStudio; it is great to have SolverStudio as a core part of his new book.

For more information, including CMPL examples, see the Logistics Lab.

AMPL+Gurobi Webinar

Andrew Mason — Wed, 11 May 2016 02:44:52 +0000

Check out this webinar on 20 May on using AMPL with the Gurobi solver. Looks very interesting. Andrew

Quick patch for NEOS Incompatibility

Andrew — Wed, 27 Apr 2016 03:24:23 +0000

You may find that SolverStudio (v 0.09.02 or earlier) is not working with NEOS. NEOS have recently tweaked their systems, and so you need to edit RunGAMSNEOS.py or RunAMPLNEOS.py and change all lines with “time.sleep(1)” into “time.sleep(5)”. This will be fixed in the next release. Andrew

Supporting OR in Developing Countries

Andrew — Mon, 18 Apr 2016 01:37:09 +0000

SolverStudio is pleased to be part of the IFORS initiative to support operations research activities in developing countries, where access to specialist commercial software is often prohibited by licensing costs. For more on this initiative, see the IFORS Developing Countries OR Resources Website.