solver

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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