Cool OpenSolver Applications – OpenSolver for Excel

I recently received a nice email from Andrew Trapp, Assistant Professor, School of Business, Worcester Polytechnic Institute. Andrew has been using OpenSolver and SolverStudio in his student projects. He writes:

I’m writing to first of all thank you for the excellent software tools that you make, OpenSolver and SolverStudio, that I have been using and featuring for 4 years now in my optimization courses. They have also been used in a number of “senior design” projects that I have advised (specifically, OpenSolver in conjunction with VBA…)

Andrew’s OpenSolver projects look very interesting, and show how OpenSolver can be used in practical applications. The reports are available online, as follows:

Improving Changeover Efficiency in Opticap® XL Encapsulation Process

Finding Improving Solutions that Control Disruption to Binary Optimization Problems

Improving the Scheduling of Operating Rooms at UMass Memorial Medical Center

Optimizing Client Scheduling and Improving Client Distribution of Fundación Paraguaya

I hope these are useful.

Andrew