solver

  1. A

    Looping the Solver function using Macros

    Sub Macro1() ' ' Macro1 Macro ' ' SolverOk SetCell:="$BD$8", MaxMinVal:=3, ValueOf:=0, ByChange:="$AJ$8", Engine _ :=1, EngineDesc:="GRG Nonlinear""" SolverOk SetCell:="$BD$8", MaxMinVal:=3, ValueOf:=0, ByChange:="$AJ$8", Engine _ :=1, EngineDesc:="GRG Nonlinear"""...
  2. H

    How to link a third party solver to Excel

    I am trying to use LP_Solver in excel. I am having an issue trying to connected it. I am very new to excel so I am finding this very difficult. I have tried following this website LP Solve link to Excel but it not working.
  3. A

    Using solver to determine the selling price and quantity to sell in order to achieve a target amount

    Hello guys, Am trying to solve a task I was issued by a client yesterday. Am basically trying to solve for what is the best selling price for each unit and how much quantity can one sell in order to reach the target amount that was set. Am not coming from an economics background but an amateur...
  4. B

    Excel Solver | Need help resolving a constrained optimization problem

    Hi, I am quite new here so I am not exactly sure how everything works. I just wanted to know if anyone could help me with Solver? -Given some information, I need to construct a spreadsheet and use Solver to resolve a constrained optimization problem (may be simple for some but it is my first...
  5. K

    Randomization Based Off a Set of Rules

    Hi everyone, I have a rather tricky problem to solve. For each row in my table (for each person) - refer to screenshot named "My Table", I would like excel to randomly generate a 9 digit number (in Column N) but based on a certain set of rules. Here is how I currently generate them 1 by 1...
  6. K

    Randomization Based Off a Set of Rules

    Hi everyone, I have a rather tricky problem to solve. For each row in my table (for each person) - refer to screenshot named "My Table", I would like excel to randomly generate a 9 digit number (in Column N) but based on a certain set of rules. Here is how I currently generate them 1 by 1...
  7. M

    Excel Solver | Why does Simplex LP not work on this model?

    Hi community, first of all, I hope I post this under the right category and that there is someone who has experience with the excel solver function. Attached, you can find: (a) an assignment we have to do for a course in university (b) my solution, which should theoretically work (also checked...
  8. A

    copy previous value of variable cell to another cell location in same spreadsheet

    Hello All, Based upon resources found on the internet (various forums, websites, communities) I did able to create one excel solver macro which automates the solver calculations. Each solver calculation involves setting target cell to zero by changing variable cell. both are single cell...
  9. S

    Assign Solver to a Command Button in VBA

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

    Multiple equations and multiple variables

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

    Small optimization task in Excel (Solution in AMPL )

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

    VBA Solver Runs but Won't Change Cells

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

    Practice a quiz but I couldn't!

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

    Dynamic variable cells in Solver VBA macro

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

    VBA Loop for Solver

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

    Solver, iterate on value multiples

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

    Excel solver limits report destroys sheet from which it is generated

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

    How To Find All Combinations That Equal A Given Sum

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

    SOLVER VBA making range dynamic

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

    VBA Excel Solver

    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...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

We've detected that you are using an adblocker.

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.
Go back
Top