So when it binds to data, it imports 4 columns. We can have multiple indexes for each parameter, e.g.
You can find the example after you download and install Solver Foundation.
I am going to use an example that comes with the Solver Foundation Excel Add-in to illustrate how to develop a supply chain model that can maximize profit.
Parameters are the “inputs” of the solver.Sets are used as indexes in Parameters or Decisions.The modeling editor has 8 different sections: We are going to find out how we can define a model in the modeling editor.
The Solver Foundation has an Excel add-in so we can build optimization model within Excel, an environment that most of us are comfortable.īelow is how the Solver Foundation Excel add-in looks like. finance, production, supply chain, human resources… etc. We can use it to develop optimization model in many areas, e.g. Solver Foundation is a pure, managed code runtime for mathematical programming, modeling, and optimization.