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.
17
questions
2
votes
1answer
69 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 ...
8
votes
2answers
612 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 ...
4
votes
1answer
94 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 ...
2
votes
1answer
119 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 ...
1
vote
1answer
57 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?
2
votes
0answers
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 ...
2
votes
1answer
223 views
If-Then-Else modeling in MILP using the Big M method
I have trouble finding a solution to the following problem. I have a decision variable $x$. If the value of $x$ is between 0 and a constant $A$, then the binary variable $y_1$ must be equal to 1. If $...
0
votes
1answer
108 views
GAMS export to excel in a loop
I am looking for a way to write data from several iterations during a loop process into my excel.
How can i change the location it is written to during every loop iteration?
those 2 lines would keep ...
0
votes
1answer
111 views
Help with excel solver
Need help with the following exercise. I am unable to work out the objective function.
After months of closure due to Covid-19, a food court is preparing to
re-open for business. However, safe ...
3
votes
1answer
218 views
Why is the Lagrange Multiplier not equal the Shadow Price (Excel solver, Matlab linprog, Gurobi)?
I have a LP with equality and inequality constraints.
When solving the LP with the excel-solver (GRG Nonlinear) the sensitivity report returns the lagrange multiplier for all constraints.
When solving ...
4
votes
1answer
82 views
How would you linearize this scheduling problem? Or how would you solve this? It is variation of a set coverage problem for OpenSolver
So, it's been about 15 years since I took my OR class in college. I'm not versed in any programming language besides a little bit of VBA.
A client of mine is looking to solve the following problem. I ...
6
votes
2answers
222 views
How can I maximize the sum of norm.dist values using solver?
EDIT #2 5/17/2020: I re-phrased my question once more. My original question is still at the end. Thanks for the feedback.
I want to know if it's possible to maximize the sum of cumulative ...
4
votes
4answers
954 views
Job shop scheduling advice
I changed jobs recently to a manufacturing firm. Job shop scheduling is made 100% manually and intuitively in Excel. Very time consuming and they have no idea if the schedule made is something close ...
3
votes
1answer
196 views
Problem solving a linear program using Excel
The exercise is as follows:
ACI has decided to put an order for golf shoes twice every year and
expects to receive one shipment of $960$ pallets of shoes by the
beginning of January and another ...
3
votes
1answer
111 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?
3
votes
1answer
60 views
Iterative calculus with Excel - N° 2
In continuation with the previous post, I propose you another problem.
I have this model:
\begin{align}\min&\quad F\\\text{s.t.}&\quad
F-(1150x_{B_{1}}+1000x_{B_{2}}+1350x_{B_{3}}-S_{1})=430\...
3
votes
1answer
248 views
Iterative calculus with Excel
I have this model:
\begin{align}\max&\quad\small{(0.2(1.07)^{-1}+0.2(1.07)^{-2}+0.9(1.07)^{-3})x_A+0.4(1.07)^{-1}+0.5(1.07)^{-2}+0.3(1.07)^{-3})x_B}\\&\quad 0.2x_{A}+0.4x_{B}\geq300\,000
\\&...