For questions about using the Solver add-in for Microsoft Excel. Also include the general tag [microsoft-excel] or the tag for your specific version of Excel if your question is likely only relevant to that specific version.
Questions tagged [solver]
24 questions
3
votes
2 answers
Where is the Solver add-in in Microsoft Excel 2007?
I am looking for Solver in Microsoft Excel 2007 but cannot find it. How can I find it?
Tim
- 17,743
3
votes
2 answers
Excel Solver: define constraint to be zero OR greater than
I'm creating a model to optimize purchase orders.
The amount to be ordered must be greater than 500 or equal to zero.
How do I define such a constraint in Solver?
I tried a binary constraint and I also tried several different formulas but nothing…
2
votes
1 answer
Using Excel Solver where a negative relationship exists
I'm trying to produce an optimiser for a client, and they have several possible outcomes.
Let's call the outcomes "Motorbikes" and "Cars".
The client is interested in how their advertising mix affects sales. But it is clear from the data that the…
Simon Hayward
- 121
- 5
1
vote
1 answer
Can Excel Solver solve this Knapsack-like optimization?
I’m buying some food, and want the most calories I can get for my money.
I have a budget of $12.00. There are 3 food groups, and I need to pick 2 items from each of those groups. There is also a Dessert group- I have to pick one dessert item. That’s…
Hairgami_Master
- 145
1
vote
0 answers
Excel Solver: Solving matrix values to match row/column sum according to reference
I've been trying to program Excel Solver to fill the values of a matrix so that the sum of rows and columns match preestablished values. See image:
Excel Problem
I understand this problem has infinite solutions that's why I want to constraint the…
fpolloa
- 11
1
vote
0 answers
1
vote
2 answers
OpenSolver and Excel's Solver gives different optimal solutions
I noticed that OpenSolver and Solver tend to give different solutions. For example, in the example file provided by this website, OpenSolver gives an answer of X=0 and Y=60, whereas Solver's is X=10 and Y=45. Any idea why is this so? Which one…
will
- 121
1
vote
1 answer
Is there a way to temporarily stop Excel from recalculating certain cells?
I have a rather complex spreadsheet, with several hundred computationally intensive formulas (indirect(), sumproduct() and so on). I would like to add some optimization for one of the rows of this spreadsheet.
The optimization is a fairly trivial…
Maxim
- 11
1
vote
1 answer
Add multiple constraints on Excel Solver
In excel solver,i need a variable to either be zero or lie between 50% of max to 100%. i.e it should not lie between 0 to 50% but can be zero. how to add a constraint like this?
Namrata Chhabra
- 11
- 1
- 2
1
vote
1 answer
Missing AllDifferent constraint in Excel 2007
I am trying to use the solver in Excel 2007 but I did not find "alldifferent" constraint in it, e.g:
example
I can see "integer" "binary" but there is no "alldifferent".
Can someone help me find it? Thanks!
Nick Liu
- 11
0
votes
1 answer
Can't set integer constraint on certain cell
I have a production programming exercise that I'm supposed to solve by using the Excel solver. However, I am not able to set an integer constraint on a certain cell that I need to be integer only.
I attached a minimal example to this post, the…
RikuXan
- 336
0
votes
2 answers
Trying to Use Solver with Different Constraints
I want to give instruction to an Excel to give me a sum of certain amount by changing only Quantities. In the pictures, let say I want to get the sum of 250 (cell H16) by changing cells G5:G15. I can do that by using Solver, but I also need to…
0
votes
1 answer
What is the maths behind the Solver function in Excel?
I am currently using the Solver function in Excel to approximate 2 sin functions. The results are pretty good, however I want to understand how it exactly it works. I'd greatly appreciate any sources I can read from as well. Thanks in advance!
Ben10
- 23
0
votes
0 answers
Excel Solver Not Finding a Feasible Solution and Goal Seek Not Solving Entirely
I am creating a weekly payment schedule to pay off a loan, and I am using Solver to determine the weekly payment I should make to pay off the loan by a certain date where the payment amount remains the same (e.g. the cell below is equal to the cell…
Phil
- 1
0
votes
1 answer
Portfolio Theory: Excel Solver does not work as intended
Around 4-5 years ago I have already tried myself with the portfolio theory and was successfully. You can find this Excel here. Now I wanted to do the whole thing with other ETFs, but unfortunately I get from the Excel solver always directly said…
Jan
- 103