Example Models

This page provides a number of examples of SolverStudio being used to solve interesting problems. Please let us know if we can list your SolverStudio solution here, and, even better, share it with other users.

Two of our Engineering Science students, Michael and Oscar, have developed a SolverStudio model for forming student groups in one of their large classes. This model can balance the groups across a wide range of factors, and produces a series of graphs to visualise the solution. Their spreadsheet model is available at https://github.com/odow/group-allocator

Marilize van Buisbegen from the University of Pretoria has written a report “A Volunteer Rostering Problem: Scheduling of moderators to provide optimal coverage in an on-line chess website” on using SolverStudio with PuLP to scehdule volunteers to support an on-line chess web-site.


11 thoughts on “Example Models

  1. I need to start somewhere but all the language options are confusing. Currently developing an excel spreadsheet with various constraints such as found in a rolling mill (time, yield, speed, weight, lengths, inventory, product,tons, etc) to aid in optimising the throughput in tons. LP seems to be the easier option but
    where do I start as a recommendation? Excel solver ad in seems to be expensive for a learner of LP. Regards,


  2. Hello,

    I am thoroughly enjoying your work on this. It’s very helpful. Forgive me if I missed it, but is there an example implementing the transshipment problem but also assuming multiple commodities (for example, the steel problem but with additional commodities sharing the same capacity constraints).


  3. Hello, In order to use a variable with 3 indexes or more; how should I create the table and connect it with the parameter tables?

    • You use row and column labels (one of which is a tuple of two values); please look at the examples, eg Python Examples, to see how this works. Andrew

  4. Hi,
    I want to be able to use this tool in my big model, to do a simple optimization.
    I want to minimize a cell in excel, which is a sum of a lot of cells that are results of a sumproduct between some variables X and some constanst variables Z.
    The variables X are the only things I want to change, in order to minimize my target cell.
    And I have some constrains that X has to be between 0 and 1, and some varaibles in X has to be 0.

    I don’t know which example to follow in order to fulfill this.

    Any help would be appreciated

    • You have a linear programme; try using that example sheet to build your model. Hope this helps, Andrew Mason. PS: We can direct you to commercial support if you need help with your model.

  5. Hello Mr. Mason, excellent tool.

    Could you give me a simple example (template) of using the Solverstudio with GAMS?

    Thanks for you attention

    • Thanks for your post. The “GAMS(NEOS) Examples.xlsx” file is what you want; you can open it using the “SolverStudio : SolverStudio Examples” sequence on the Excel Data ribbon. I hope this is what you are seeking. Andrew

Leave a Reply

Your email address will not be published. Required fields are marked *