Questions tagged [excel]
The excel tag has no usage guidance.
12
questions
0
votes
0answers
36 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
132 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
55 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 ...
1
vote
1answer
100 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 ...
4
votes
1answer
129 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
75 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
206 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
759 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 ...
4
votes
1answer
172 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
100 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
57 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
239 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
\\&...