# Questions tagged [excel]

For questions related to the use of Excel and the Excel solver. The Excel solver is an add-in that allows the solution of linear programming problems, such as product mix problems (whether maximization or minimization), transportation problems and problems for the allocation of scarce resources. The spreadsheet is easy to use and fast to raise the model. It can obtain the reports of the optimal solution and the sensitivity analysis in a matter of seconds.

19 questions
Filter by
Sorted by
Tagged with
135 views

### Why are the final value and reduced cost 0 in excel sensitivity report for multiple variables even though there exists a unique optimal solution?

In solving a linear program (in specific a network optimization problem of the shortest path type) with the Excel solver, I noticed two things after running a sensitivity report on the solution ...
649 views

### Linear Programming: Integer and non-integer decision variables

I am looking for an answer to a question I can't quite get behind. I am given the following mathematical optimization problem: \begin{align}\min&\quad\sum_{t\in T}s_t\cdot z_t+h_t\cdot i_t+p_t\...
102 views

### 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 ...
637 views

### Softwares for Operations Research. Is Excel Outdated or Useless for the OR industry?

I am looking over for softwares recommendation in Introduction to Operations Research Hillier 11th, there are tens of options for learn and apply OR theory using software. I normally check how much ...
131 views

### Why does setting up a problem using Excel's OpenSolver slows down after 24,000 variables?

I am modeling a big linear programming problem size with about 50,000 variables using OpenSolver. Open Solver starts setting up the problem at a constant pace of about 100 variables per second, which ...
218 views

### Excel Solver is not performing as desired

I have a simple optimization problem and would like to solve it using Microsoft Solver. However, the solver does not do what it is supposed to. Briefly to the background: In the problem the gross ...
64 views

### Importing data into SCIP solver

Is it possible to import data into SCIP from Excel (and then export results to Excel)? If yes, how can I do it?
40 views

### Finding average days target for teams to achieve an overall group target using excel solver?

I have 3 teams within a group with each team working on different tasks assigned. I was given data of how each team performed in terms of the number of task completed each month and the average days ...
276 views

116 views

### Graphical illustration Excel

I have formulated a linear optimization model and solve it using the Excel Solver. How can I illustrate the slacks vs usage?