ResearchGate let me know today that OpenSolver is being used to help allocate mental health personnel in the US Navy.
Most of our OpenSolver users choose the standard integer programming solver, CBC (which is the default option). COIN-OR, the non-profit who support and develop CBC, have just announced a new support forum for CBC users. (This is a beta test of the new GitHub discussion forums being developed.) This is the best place for advanced users to take technical questions, such as queries about CBC parameters (which OpenSolver supports). Andrew
12 Feb 2020: It was raised to us that OpenSolver for GoogleSheets is still unaccessible to new users. We are now able to replicate this bug. From our tests, new user accounts are able to install OpenSolver for Google Sheets as an Add-on from Chrome Web Store. However, the “Sign in with Google is temporarily disabled for this app” screen will still show up when trying to open the sidebar from the ribbon. We are very sorry for the inconvenience and we have contacted Google regarding this issue. We need to wait for Google’s response on this, therefore we are unsure of when this problem will be fixed.
Original post: Changes made by Google mean that OpenSolver for Googlesheets is currently not working for new users who want to add it to their Googlesheets. (Apparently the first 100 users each month can sign in, but then further sign ins are blocked by Google.) We are working on fixing this, But we don’t know how long it will take, sorry. We suggest you use OpenSolver for Excel until we get it working properly for Googlesheets.
Sorry for the inconvenience.
Google has a nice article here, that includes a recommendation to use OpenSolver. Enjoy!
We justc ame across an interesting article using OpenSolver to help develop optimal policies for conservation.
Commonalities in stream connectivity restoration alternatives: an attempt to simplify barrier removal optimization
OpenSolver reached another download milestone this month. If my car had reached 300,000 on the dial, I’d be looking at getting a new one. Fortunately, OpenSolver gets better with age.
Thank to all our users for their support.
There’s a great overview of software available for optimisation in Optima (volume 103, 2017), the Mathematical Optimization Society Newsletter.
Today the download odometer rolled past another milestone:
Thanks to all our users and our development team (and most recently Jack Dunn) for supporting OpenSolver for the last 6 years. None of this would have been possible without the solvers from COIN-OR; thanks to John Forrest and Ted Ralphs for the many years of CBC development, without which the OpenSolver project would never have started.
This blog by Derek Nelson shows how he built an OpenSolver model for fantasy football that worked well for him. “My optimizer was created using Excel with the Open Solver add-in. This worked for me and the results were good. Namely, I had the highest projected points for my teams at the start of the season in both leagues I played in (the best you can hope for in the draft, in my opinion), and I ended the season by winning one league and placing second in the other.”
Derek has now gone on to create a cloud-based version of this. This work is an interesting optimisation-based project.
As this video shows, yes, OpenSolver can solve Sudoku…
A nice article here by Jangho Lee, Seoul National University, on a Statistical Approach for Clustering Member of Congress in South Korea. Jangho used Python, Excel and Gephi for visualizing.
Image from http://jangholee.org/?p=57
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:
OpenSolver and COIN-OR are 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.