I’m very pleased to see that the pioneers who played such a pivotal role in creating COIN-OR and all the great software that makes OpenSolver & SolverStudio possible have been awarded the INFORMS 2014 Impact Prize. Well done to Brenda Dietrich, JP Fasano, John Forrest, Lou Hafer, Brady Hunsaker, Laszlo Ladanyi, Robin Lougee, Ted Ralphs, and Matthew Saltzman for all their hard work over the years. They will receive their award at the INFORMS conference Award Ceremony this Sunday.

Associate Professor Ted Ralphs is organising a COIN-OR workshop:
https://sites.google.com/site/2015icsconference/home/coin-fest
at the Informs Computing Society (ICS) conference in January:
https://www.informs.org/Blogs/E-News-Blog/ICS-2015-Conference

Ted will be demo’ing both OpenSolver and SolverStudio at this event, and also giving an overview of all the other tools COIN-OR makes available.

Two of my students, Michael and Oscar, have developed a SolverStudio model for allocating students into student groups. This model is now being used successfully by one of our large professional development courses to manage a classs of 570+ students. The model forms student groups that are balanced in factors such as engineering discipline, gender, and grade point average. This tool also creates nice PDF outputs, thanks to Python’s powerful libraries. You can find their model on Github.

This is a great example of how a model can be quickly developed and implemented without requiring the end user to learn new skills beyond their existing Excel expertise.

Well done, Oscar and Michael, for taking the initiative to develop, test and implement this.

Andrew

We have just been working on an implementation in which our data items are defined by named ranges that use formulae, so they expand as the data set expands. When they shrink, they leave old data behind on the sheet. To clear this old data, you can use code such as:

xlDown = -4121
# print ActiveSheet.Range(ActiveSheet.Range(“test”),ActiveSheet.Range(“test”).End(xlDown)).Address()
ActiveSheet.Range(ActiveSheet.Range(“test”),ActiveSheet.Range(“test”).End(xlDown)).Clear()

One of our OpenSolver users recently worked with modelling guru Stu Mitchell to move his model from OpenSolver to SolverStudio. The OpenSolver model originally took 4 hours to solve. After simplifying the spreadsheet, this reduced to 2 hours. But, Stu then created a SolverStudio version that solved the same problem in just 20 seconds. To quote our user: The conversion to SolverStudio has been an excellent improvement.

If you have a complicated spreadsheet, then you may also find that SolverStudio  gives much better solve times than a traditional OpenSolver model. Furthermore, the latest SolverStudio release includes ready-to-run models for many common problem formulations, which helps make using SolverStudio even easier. Give it a go, and let us know how you get on.

Andrew

Interesting article at Butler Analytics on prescriptive analytics, including an overview of some solver tools including SolverStudio.

It was an interesting experience testing the latest SolverStudio 0.6.0 release. We discovered several independent bugs in CBC 2.8.8 on Windows which means (1) CBC often finds incorrect solutions when used with AMPL, and (2) it reports the wrong objective function value for these; thanks for Victor Zverovich from AMPL and John Forrest from COIN-OR for working with us to fix these ready for the next CBC release. We also found a bug in Pyomo’s output formatting that John Sirola is working on; we suggest for now you do not put comma’s in the values of indices. Finally, we think the output from NEOS has changed the way it is formatted; we have put in a work around while Ziliang Guo from NEOS looks into this. Who would have thought it would be such a busy week! Andrew

Informs Transactions on Education has just published a special issue in honour of Paul Jenson who developed some excellent Excel tools for teaching operations research and management science. This special issue includes an article on SolverStudio that might be helpful for new users. Cheers, Andrew