Meer 2, 2 2 gold badges 18 18 silver badges 28 28 bronze badges. Check version of. Net environment — gabba. Wich dll of Microsoft. SolverFoundation you already added? Add a comment. Active Oldest Votes. Improve this answer. Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password. Post as a guest Name. Email Required, but never shown. The Overflow Blog. Podcast Helping communities build their own LTE networks. Functionality is a constraint for the optimization, you cannot sacrifice basic functionality to speed it up.
Technologies that are used in the application they can decrease or increase performance, but impact functionality as well are decisions, and maximizing of performance is our goal. The combination of input parameters, constraints, decisions, and goals represent the model.
Constraints and goals are defined by functions. Constraint function has to return true or false; goal function has to return numeric value to optimize. In the mathematical world, functions have different types. For our optimization task it is important to know if the function is linear or non linear, this affects the accuracy and speed of optimization as different algorithms are used.
Linear function is a function that can be drawn on a graph with a straight line. In C it looks like:. Microsoft Solver Foundation is. NET tool for modeling, optimization, and simulation that you can download from official Microsoft website.
It has four editions:. Express and Standard versions have some limitations for number of processor cores, number of parameters and so on , you can read more about this there. In my experience, it is much faster to build and test your model in Excel and then code it with C and VB. Before we start I will add a fly in the ointment — Solver Foundation is not a panacea.
It is good enough for typical tasks that can be solved with standard algorithms. Farms are delivering raw cow milk to the plant where it is getting processed and sorted in a three storage tanks:.
Every type of milk has different cost and the company is trying to sell cheaper milk as much as possible. Also, the plant has two tanks with additives — Heavy cream and Skim. Every customer creates an order for some quantity of milk with specific quality that are defined in maximum-minimum limits for each quality argument: Density , Fat , and SNF.
We assume that the company does not have production planning and starts order handling when the truck arrives at the plant. The cost of milk in each tank configured in MES system. The goal of MES system is to calculate the dosage of each component to meet requirements of product quality and ordered quantity by using as much as possible cheaper components. When milk is dosed and mixed into truck tank quality parameters are calculating as a weighted average of attribute values based on loaded quantity from each tank.
For the keyed parameters you have to define unique structure — set. Set keeps a list of keys for your parameters that can be shared but only with parameters that have the same keys. For example, the quantity of product and cost of the component in the tank the key is the same — tank name, so set can be shared between those parameters.
In Excel I have the following structure:. The domain is the type of indexer. By the way — you can also use indexes in constraints and goals of your model an example if you want to make a special calculation on even values. To setup binding for keyed parameter, you have to select the type of the indexer set and a column for the key values. Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password.
Post as a guest Name. Email Required, but never shown. The Overflow Blog. Podcast Helping communities build their own LTE networks. Podcast Making Agile work for data science. Featured on Meta. New post summary designs on greatest hits now, everywhere else eventually. Related Hot Network Questions. Question feed.
0コメント