Questions tagged [excel]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
2
votes
1answer
115 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
48 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
96 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
98 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
71 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
202 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
3answers
645 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
150 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
98 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
56 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
237 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 \\&...