solver

Hi everyone, i have a dataset containing funds, their monthly returns and cashflows. It's a long data structure, so i have multiple rows for each fund. Then i have to solve an Equation with solver for each fund. I want to calculate an internal rate of return using the formla...

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...