SolverStudio, OpenSolver and Bioinformatics

Came across the following quote inĀ Briefings in Bioinformatics. “Interestingly, Microsoft Excel (, the commonly used spreadsheet package for storing metabolic models, has all the necessary components to create and analyse FBA models including well-designed form-based interface, plotting and drawing facilities, in-built optimization solvers and scripting language for automating tasks (i.e. MACROS). It should be noticed that Excel-based FBA application may face technical challenges in handling large-size models due to the limitation in its in-built optimization solver. However, this issue can be appropriately resolved by using relevant software technologies such as OpenSolver (, an open-source optimization solver for Excel that runs on advanced COIN-OR CBC optimization engine ( and SolverStudio (, a software framework that can integrate Excel with other open sources as well as commercial solvers, e.g. GLPK (, COIN CLP (, CPLEX and GUROBI (” Is this an area we OR types need to be looking at more seriously?

On another matter, thanks, Bob, for mentioning SolverStudio in your AMPL talk at Informs.

Leave a Reply




You can use these HTML tags

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code class="" title="" data-url=""> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong> <pre class="" title="" data-url=""> <span class="" title="" data-url="">