solver

  1. M

    VBA Solver FormulaText

    Is there any way to call a variable from VBA as the input for FormulaText in SolverAdd? Sub () intX=5 SolverAdd CellRef:=Range("A1"),Relation:=1, FormulaText:=intX End Sub
  2. R

    Name Conflicts with Existing Module, project or objec library Error

    Greetings - I recently wrote a macro invoking solver. I added a reference to Solver in VBA and it works fine on my machine. I emailed my excel file to a colleague and directed him to add the reference to the Solver in the VB developer and he keeps getting the above error. The code works...
  3. D

    VBA Solver - Multiple ranges of variables and constraints

    Hello All, I am using VBA in order to automatize my Solver on multiple problems. I want to run the solver taking only the range of parameters, constraints and decision variables for which the value is non-zero. And I want to related to theses ranges created in the solver. Here is part of my...
  4. G

    Finding combination of numbers that net to zero

    I have a list with about 16k lines. I need to find smaller amounts of data than the whole set that will net to zero. I've looked at solver and even goal seek but neither seems to fit my needs. Solver i think would work great if it worked on more than a few hundred lines of data, but I have...
  5. M

    count without countif

    I have a range of cells with numbers them 1,1,1,2,3,1,3,3,1,1,1, Its a long story but is there a way of counting the number of 3's without using countif - preferably with some way using simple sum formulas. I'm am using this for a 'solver' problem and solver doesn't like countif. thanks
  6. James_Latimer

    Solver - Application.Calculation

    Excel 2016 / Win 10 Hello Excellers, I appreciate that i am opening myself up for mockery here, however... is there a way to disable application.calculation when running solver? The reason i ask is that i have a sheet in a workbook that is calculating optimum vials to use based on cost. All...
  7. B

    Running Solver on Multiple Rows of Data

    Hi Everyone, I am working on a problem to update pricing throughout a database of about 800 parts. After looking around online, I think Solver is the best way to approach this problem, but I couldn't find any VBA code to execute this. Here are the rules (also illustrated below) Primary Logic...
  8. S

    Solver Optimization Help

    Hi, I'm working on a project relating to times that cars leave for a hub route. The cars are carrying ordered products from one store to the other within the route. I have data with the current times the cars leave, 6 times per day, and I have data of what time were ordered by the individual...
  9. P

    Solver - Maximise 2 variables

    Hi All Is it possible to maximise 2 variables using solver? Basically i have a sales organisation, i want to get the optimum product mix to maximise both Sales per unit sold & Profit per unit sold. Some products have high revenue but would loose money and vice versa. It is also subject to...
  10. E

    Rrandomly selecting a sum of three separate columns in VBA for a set of particular totals

    Hello, I need to randomly pick individual and repeated entries from an array that has 3 separate integers via VB script, whose sum must equal separate particular values. I've worked a bit with VBA in Excel before, but this is stumping me. :confused: I have seen examples with how to use...
  11. S

    VBA - Multiple solvers - Same workbook different sheet

    Hello. I have a workbook that contains several sheets. I'm trying to make two solvers run on separate sheets, solver 2 is dependant on solver 1. Solver 1 works as it should but I can't get solver 2 to run by itself, I have inserted a button for solver 2 to work but I would like to run it...
  12. B

    macro solver based on selected row

    I have a specific solver that I need run, and all the information is organized per row. However, my data set is large and I don't need solver run for all rows. What I would like is to input a value into a cell (BB4), then have the macro search Column E for matching value. Once the row with the...
  13. R

    Looping VBA with Solver Question

    Novice question... I am trying to loop Solver through a specified array of worksheets in a workbook twice. With a Copy&paste values routine in between. Currently the routines will work if run separately but to combine them I believe I need to make the entire sub option explicit because I start...
  14. J

    Excel Solver Optimize Sums of Non-Linear Values Problem

    The picture below shows a simple example of the problem I'm facing. I'd like to maximize a cell that is the sum of other cells that are not linear. In the spreadsheet, I have Z scores for categories I and II (I hardcoded in a mean of 30 and stdev of 15 for category I and 40 and 10 for category...
  15. B

    Unique question about running solver multiple times

    I have a spreadsheet for playing daily fantasy basketball; in this spreadsheet, I have the players' names, salaries, and projected fantasy points. I have set up solver to find the optimal lineup each night (highest projected fantasy point total) that fits in the constraints I have set. However...
  16. D

    Excel/Google Sheets Solver Difficulty

    I am trying to figure out which elements of a set of numbers (amounts) total to a target value. I am creating a google sheet to keep track of what my roommates pay me, where I receive both full and partial payments of bills from my roommates but documentation indicating what bills are being...
  17. T

    Solver with Data Validation "List"

    Is it possible to have solver solve subject to the constraint of using a data validation list? Better explanation is that I have used the data validation 'list' function for cells B1:B9, of which a value can be picked from a source input into cells A1:A4. I would like to be able to solve for...
  18. G

    Checking Solver Add in Conditions using VBA

    Hi there, I need to check some conditions applied to a sheet using Solver Addin. I recorded the action when adding them : SolverOk SetCell:="$B$13", MaxMinVal:=1, ValueOf:=0, ByChange:="$B$11:$D$11", _ Engine:=1, EngineDesc:="GRG Nonlinear" SolverAdd CellRef:="$B$11"...
  19. P

    How to use Excel Solver with lookups?

    Is there a way to use the solver with the data shown below? I want to have the Solver Table (Columns F-I) pull the data (Columns A-D) with the following constraints. 1) Maximize the sum of the profit (Column H), 2) Keep the sum of the Lbs <= 300 (Column I), 3) Each type must include two...
  20. L

    Five axis solver Formula or VBA okay

    A1:A5 = No. of Veh., Speed, Circuit in Miles, Interval (min or sec), M/P Hour. The variables in B1:B5. So a typical "what-if" would be something like the Interval must be 1 minute, the Circuit Miles is 120... what would be the other values to meet the 1 min/120 miles set requirements. Other...

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