solver

Hello, I'm trying to assign the solver function to a command button in VBA but it says there is an error. My solver code is like this (I used record macro) Sub solver() SolverOk SetCell:="$B$35", MaxMinVal:=1, ValueOf:=0, ByChange:="$B$25:$H$31", _ Engine:=2, EngineDesc:="Simplex...

The following post will be long and I'll probably make a fool of myself explaining the rut I'm stuck in, but bear with me. It's based on analytical chemistry calculations, if that's worth anything. I have a mathematically solvable system of equations, but it relies on multiple variables that...

Hello! I want to create this model in Excel to find the optimal solution with 2 constraints (Labor Hours and Material Available pr. week), below you will see the description and the solution in AMPL. For my own learning in other courses, I wish to make this in Excel using Solver. "Packing can...

Hi everyone, pretty new to this so excuse my ignorance. I cannot get my loop to run for this solver function. When I put in individual references like "$AF$14" then it'll run that line, but it will not repeat when I define I and attempt to put it in a loop. It does not give me an error, the...

Hello everybody, For the quiz questions, I tried using the circular method, but got a numeric, period or comma error? So I tried using the solver to find the same solution I got, but when I entered it in the answer box, he always said incorrectly. Any help would be highly appreciated and...

Hello, I have a macro that runs Solver in Excel, it currently uses two different ranges as the variable cells. See the code below. SolverOk SetCell:="$D$27", MaxMinVal:=2, ValueOf:=0, ByChange:= _ "$C$17:$C$23,$C$7:$I$11", Engine:=1, EngineDesc:="GRG Nonlinear" SolverOptions...

Dear All, I am not an expert of VBA at all, therefore, I'll try to be as clear as I can. I am trying to create a code to automatically run a Solver across several columns. I managed to create a basic code that does the job, but that means that I have to copy and paste the code for all the rows...

Hello my fellow Excellers! I have a practical issue which appears simple at first but reveals itself being tricky (at least for me) , the problem is the following : In my Solver Model there are several variables which can range from let's say 1000 to 100000+ and are sold by multiples of 100s...

Hi all, I have the following problem: I have created an Excel file which is supposed to minimize a cost function under certain constraints using the solver. (The solver is controlled via VBA and calulates the correct result, no problem.) BUT if I then want to accept the solver solution and...

Hi, I am trying to reconcile our PayPal account. Unfortunately Paypal deposits funds not at the end of each day but when funds are released from your credit card or bank this can mean funds for one transaction arrive 5 days later and others 30 days later. Every few days I get a large deposit...

Hi Guys I am using solver to identify from multiply amounts which add up to a specific number. I would like to make the "By change " to a dynamic range that will work no matter how many values are entered . I've been trying this for now 3 weeks and would appreciate someone helping me with the...

Hi, I would like to combine two actions into a Macro, one as a Solver, the other to link Solver object cell (Sheet9, G39) to a cell in another worksheet (Sheet1, E82) as sometimes it's just a manual input. The Solver code and the linking cell code work independently fine but for some reason...

Hello everybody I will purchase a quantity of apples during the year, and 3 sellers made me their offers (quantity of apples and price per apple). Those offers are in sheets Seller 1, 2 and 3. So I need to determine what is the best combination among those offers, purchasing at the lowest...

Hey everyone! I am stuck at this simple (I believe it is simple *sighs*) solver problem... Basically I have a total amount of money in a contract which is cell F23 ($37,257,548.96) and I am trying to redistribute some quantities but maintaining the final TOTAL AMOUNT constant. So I created...

Hi, I'm struggling with the Excel Solver option. I have a table, and want to have fixed constraints for the sum of each row; e.g. $D$15:$D$20 = 200. However, Excel solves this putting 200 into each cell of that row. What is going wrong here? (I'm solving for min. cost, each row cell is...

I need a way to distribute inventory in cases as per requirement at stores fron warehouse Let say there are 3 store a, b and c. a requires 5, b requires 8, c requires 7 So overall req is 20 At warehouse only 15 is available So how should i divide propotionately. The output requiremtn should be...

Greetings! Im trying to run a solver loop that will loop through and optimize for the highest return possible on a yearly basis. See image. What I want to do is use the previous years returns across the 7 asset classes shown to optimize the weights invested the following year in the hopes that...

Hi. I need some help on this solver problem. I am trying to understand how many hours I need to run my machines to meet my demand per month per run mode. Below are the TONS per month required along with the product name: Sales Part Number Jan Feb Mar Apr May Jun Jul Aug Sep...

hi I need to solve this formula using Solver and vba. Pi = Ni^k (power k) Applied to this example: 1.51 3.69 5.30 (in columns D2, E2, F2 respectively) Where Ni represents (1/1.51), (1/3.69),(1/ 5.30), individually . There are 2 competitors, n. N = Sum of the 3 Ni(s) k is derived as: Log n...

Hi, I am struggling with quite a complex problem in which I think I may be able to solve or at least partially solve using the Excel solver tool. I am trying to set up a design of experiments analysis in which I have a number of parameters at two levels. I have one specific objective which I...