Skip to main content

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.

Filter by
Sorted by
Tagged with
0 votes
1 answer
37 views

Determine optimal method for choosing products based on perimeter and number of zones

We need to setup a more efficient quote system for prospective clients, but the logic is difficult to implement (I'm using VBA, but a formula or pseudocode is fine). This seems to be a combinatorial ...
Starnes Student's user avatar
2 votes
1 answer
111 views

Container Loading Problem

I'd like to optimize the loading problem in first-mile delivery that maximize the occupancy of the truck. The main question to be answered is this: with the given truck, would this list of items fit ...
overboxed's user avatar
  • 593
4 votes
1 answer
1k views

Can sensitivity analysis and limits report be done on an BILP problem?

I am not that experienced with Operations Research yet. I have become familiar with what Sensitivity Analysis and Limits Reports are in general and through the use of Excel. I know that they can only ...
Tita's user avatar
  • 205
2 votes
4 answers
505 views

How to approach this shifts problem with Excel Solver?

I am trying to find a way to solve the following problem of mine by using Solver but I get stuck right at the end of it. I have a table of 14 companies each of which want to work on a project. I will ...
Tita's user avatar
  • 205
1 vote
2 answers
132 views

Optimization of Weekly Productivity Goals

I need to find optimum weekly targets for an 8-week period for a group of employees. The end result expected is maximum of sum of percentage of times the employees met the goal in each week. I am ...
geoabram's user avatar
3 votes
1 answer
1k views

How to formulate cumulative sum of LpVariable in Pulp Python

I have a Multiple product LP optimization problem in which the product(B1,B2,D) will be received in variable quantity with respect to date column. The Optimizer should LP variable Output as Assy Out ...
SrinivasaRamanujam N's user avatar
0 votes
1 answer
320 views

It takes a long time to solve excel gurobi-opensolver - is this normal?

The problem I have made associated with OpenSolver and Gurobi takes about 50 minutes to solve, is this normal? It has approximately 365 variables with upper and lower bands, the peculiarity is that ...
ADMGYP's user avatar
  • 49
3 votes
3 answers
2k views

Python to Excel

Using DOcplex module an optimization problem is solved. There are many decision variables in the solution, for the validation of the mathematical model I want to check them. How can I write the ...
GTek's user avatar
  • 307
4 votes
1 answer
1k 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 ...
AVAS's user avatar
  • 43
6 votes
1 answer
1k 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\...
coar's user avatar
  • 133
2 votes
1 answer
393 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 ...
fpolloa's user avatar
  • 21
9 votes
2 answers
831 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 ...
rubengavidia0x's user avatar
4 votes
1 answer
576 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 ...
decision maker's user avatar
2 votes
1 answer
3k 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 ...
Jan's user avatar
  • 123
1 vote
1 answer
137 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?
O. Sd's user avatar
  • 65
2 votes
0 answers
44 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 ...
Aik Koon Wee's user avatar
2 votes
1 answer
883 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 $...
wlans's user avatar
  • 23
0 votes
1 answer
321 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 ...
Eddiee's user avatar
  • 533
0 votes
1 answer
147 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 ...
Alibaba123's user avatar
3 votes
1 answer
810 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 ...
Mitch's user avatar
  • 93
4 votes
1 answer
162 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 ...
Rodrigom3's user avatar
6 votes
2 answers
295 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 ...
Jack Ries's user avatar
4 votes
5 answers
2k 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 ...
Solauf's user avatar
  • 51
3 votes
1 answer
374 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 ...
jeremy909's user avatar
  • 131
3 votes
1 answer
175 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?
user avatar
3 votes
1 answer
67 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\...
Francesco Totti's user avatar
2 votes
1 answer
298 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 \\&...
Francesco Totti's user avatar