We have let's say 10 private planes that we use to transport customers. Each customer has their own departure and arrival airports. I am trying to see if Excel Solver can help me decide which plane to use for any of the customers based upon closeness and meeting the departure/arrival time in...
Hello Everyone.
I am currently working on a project for a class, the instructions and data set are below.
I know I can do this, albeit it manual, without using solver I am trying to use it. Can someone please provide some guidance if solver is the correct path forward or any other way.
I...
Is it possible for Solver to specify a criterion instead of a specific target value?
For example, I want the target cell to be the maximum possible, below 100, and not a specific value.
Or is there any other tool?
Hi guys, I've been using this forum for long time, but this is my first time posting ;).
Recently I got math problem to solve on job interview, which I did on paper, but problem is it was needed to be done in excel. Below is question and the way I did it on paper. Please help me solve it through...
Hi
I have a file that uses the solver function called from a reference. This works well.
The issue I see is that my users can have Solver in different locations e.g.
ForExcel 32bit program
The solver can resides in sub-dir
C:\Program Files (x86)\Microsoft...
Hi, I just watched the solver video which gives a basic introduction on how to use it and I would like some advice is solver can perform in the following scenario
Each year 25 customers are distributed between the 5 staff members based on a workload ability
Next the staff pick and equal or...
Hello!
I'm using solver for stock portfolio optimization. The solver changes weights to achieve maximum expected return. I have set the following constraints: The portfolio should consist of at least 5 stocks (out of 10) and maximum weight assigned for one stock is 30%. In this case the solver...
Hello Everybody
I'm doing the parameters estimation of a model using the Excel solver with the GNG Nonlinear method. My question is, how can I get the confidence intervals of the optimized values?
Thanks
Hi everyone
I need to run solver on about 365 rows individually, so I wrote the below code. The issue I am facing is the sheet is running ridiculously slow. It is only using 10-12% of the CPU power (only 1 core is ever used). Is there a way to optimize it to either use more cores or change the...
Hello,
I'm finding the solution to reallocate amounts in time to smooth totals. Is it possible to solve this problem with excel solver? Is there any sample with similar problem?
My data looks like this
<tbody>
Start
End
2018
2019
2020
2021
2022
Total
Project 1
2018
2020
107
107
107
321...
Hello,
I'm finding the solution to reallocate amounts in time to smooth totals. Is it possible to solve this problem with excel solver? Is there any sample with similar problem?
My data looks like this
<tbody>
Start
End
2018
2019
2020
2021
2022
Total
Project 1
2018
2020
107
107
107
321...
Hello everyone
I am new to this group as well as working on excel marcos.
I have made spread sheet where there are two equations (Q1=m1*c*dT and Q2=m2*c*dT) that needs to be balanced (Q1 =Q2) to get such a value of m1 (that utlimately L coming from m1 is same for both m1 and m2). I have made...
Hi ,
I wrote a code to run solver , unfortunately after 10 loops the results are not optimal.
This is the code :
Sub Solver()
Dim Pro As Range
Dim Dem As Range
Dim Tot_Pro As Range
Dim Start_Row As Integer
Dim End_Row As Integer
Dim i As Integer
Dim j As Integer
Application.ScreenUpdating...
Hello Experts,
All the information I can find about Solver leads to it being used to identify, from a list of numbers, those which sum to a predetermined amount.
Does anyone know if that pre determined amount, instead of being a set number, can be in the form of say plus or minus 20 of a number...
I am having trouble getting my sheet to shop the results after running my Macro.
I am using 1 of 3 CommandButtons to run 1 of 3 Macros - Scenarios (and there has to be a better way of this)
example
C9:C12 have the values to adjust
C13 is the Objective Value
H15 is the value to Match
(Button...
http://www.sansom.co.uk/reference.png
Hi
Can anyone advise me how to remove a reference? This ref is attachedto a specific workbook.
I have tried removing all references to solver in both VBA modules and throughout the workbook and I have removed the SOLVER.XLAM add-in, but the reference...
Hi,
I am reviewing a macro. There is logic that appears to use the solver, but I wasn't sure.
SolverReset
SolverOk SetCell:="$E$7", MaxMinVal:=3, ValueOf:="0", ByChange:="$D$16"
SolverOptions AssumeNonNeg:=False
SolverAdd CellRef:="$D$16", Relation:=1, FormulaText:="0.05"...
I'm taking an intro to supply chain management online and am struggling with using Excel Solver.
The class is online, so read the chapters and complete homework. Professor is very unresponsive as well.
I am struggling with how to set up my linear regression. I need to create optimum...
Hi,
I have a worksheet created whereby I want to find the best spacing and associated post type that results in minimal cost that Zex>Zex Min.
I haven't had any luck and was wondering if one of you legends could help.
I've tried running solver as per the picture below
It claims it has run...
Hi everyone,
I'm running the Solver add in, trying to find combinations of cells that sum up to a certain value. It's been running for over 20 minutes, maybe even longer. Right now it's on "Subproblem 4700" or so. And the "Trial Solutions" are going by very quickly.
Does anybody know what...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.