solver

  1. A

    Solver Optimization Tool

    Hello, I have used solver to optimize the sum of numbers given certain constraints, however I am now trying to optimize the product of numbers given certain constraints. When finding the optimal sum I can use a binary list to select the combination of item to sumproduct together to find the...
  2. M

    Solver not finding solution

    I am newbie to solver and trying to solve what I think would be a very simple problem but solver is cant find a solution and I can't figure out what I am doing wrong. There is clearly a soltiom which I included in the mini sheet. Here are my solver constraints. I have tried everything I...
  3. M

    Solver could not find a feasible solution when solution exists

    I have 2 sets of simultaneous equations to solve using solver. When I try to get values of X and Y it says that there is no feasible solution when actual values of X and Y exist. Can someone help me use solver to find the values? I may have done something wrong. 2 Equations: 10^12 = x^2 * Y 2...
  4. P

    Solver Macro on Multiple Sheets

    I am trying to run a macro calling the Solver functions on multiple sheets. The Solver area works on a single sheet, but returns the error message on the 5 worksheets I am attempting to calculate. Any advice is most welcome. Also, running this macro switched calculation mode to Manual. I have...
  5. W

    Using goal seek within VBA

    The VBA code I have written uses goal seek within the code but it's returning values that are vastly different than if I run a manual goal seek for each sheet. I have pasted the code below and can attach the reference files upon request. Sub UpdateAndSolver() Dim count, lastrow, datenum...
  6. M

    64 bits (PtrSafe & longPtr) update for Levenberg Marquardt algorithm LMA or damped least-squares.

    I am trying to make a 32 bit code work into a 64 bit pc under this link, some of my files ... , there is a zip file named LeastSquareFitting.zip, Follow instructions and unzip file in your directory, then i saved as xlsb the existing minimizeLeastSquare workbook, I did some research, and the...
  7. D

    solver, execute data in one row

    hello, i have this one page simulating labor cost, net salary to the month, average net salary to the year, and etc. depending on gross salary for each employee. it is a useful page both for the employees and employer as it shows all deductions, taxes and etc. for every month. Don't need to...
  8. Y

    How to make the model to solve with solver?

    I am trying to solve following question with solver, however I can’t figure out how to build the model. Any help is appreciated. I have 8 camions and each camion’s capacity is How8 ton. I want to transport 2500 tons of wheat from point A to 3 silos. Silos capacity and required travel time are...
  9. J

    Automating Solver Objective Selection

    Hi, I'm working on a script to automate using Solver. One of the scripts I'm working on is this: Private Sub SolverSolver() Dim ws1 As Worksheet Dim lRow As Long Dim cell As Range Set ws1 = Worksheets("Sheet1") ws1.Activate lRow = ws1.Cells(Rows.Count, 1).End(xlUp).Row...
  10. J

    VBA Add Solver constraints based on criteria

    Hi, I'm building a tool to change salaried employees hours to equal 70. I now have a way to add in a formula that adds a total hour count to be manipulated automatically, but I'm stuck on adding solver constraints automatically. Here is the code I've been working on. It doesn't work - the If...
  11. N

    Question about shortest path problem using solvers

    I am trying to figure out the shortest path of going from location 1 to 10. The path should start with location 1 and end with location 10 and go through each intermediate site (location 2-9) exactly once. I have tried different ways (eg. Net flow etc...) to solve the problem but in vain. I...
  12. 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"""...
  13. 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.
  14. 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...
  15. 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...
  16. 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...
  17. 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...
  18. 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...
  19. 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...
  20. 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...

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
Back
Top