solver add-in

I have a button that runs the following macro. The macro's purpose is to determine the additional value needed to provide 102% coverage over the value of another element. This macro relies on the Solver Add-In to optimize and is accurate (when it runs). The issue is that sometimes the macro...

I've just learned about Solver add-in today. This will be awesome if I can get it to work! Sadly I haven't yet. I want to find which numbers out of a list add up to a total I'm looking for. So I might have a total of 5 and I want to know which numbers out of the list 1,2,3 add up to that, and...

Hi, I have a problem with the solver function. I am trying to use VBA to loop a solver function from J through Q, and cannot figure it out... This is the formula that is making this table possible: SolverOk SetCell:="$J$14", MaxMinVal:=1, ValueOf:=0, ByChange:="$J$6:$J$12", _...

Excel Solver question: The University of Western Football Team has hired a dietician from a big name American school to develop a nutritious lunch menu for the team. After consulting with Canada’s Food Guide and other sources, the dietician has determined that each lunch serving should have...

Firstly I want to thank everyone who uses this site, it has helped me get where I am today, this is the first time I have come across a problem I haven't been able to find a solution for. I have written a macro that is essentially solving for the intersection between a line and a high order...

I have looked through a number of other related questions, but I haven't been able to really figure out how to create the macro I need. I am very new to VBA, basically ran into an issue that I can't solve without a macro and need to learn it now. Unfortunately I am on a deadline to try and get...

<tbody> Maximum 29 Min Max Value Best Combination Value 13 14 10 14-15 50 14 15 50 14-15 50 15 16 20 Total 100 16 17 25 </tbody> I have a problem that I think Excel Solver can help me with, but I'm not certain. What I want to do is determine the best...

I thought it would be fun to make a linear program for fantasy football. Background information: You pick 9 players; 2 quarterbacks, 2 running backs, 3 wide receivers, 1 tight end, and 1 flex (running back, wide receiver, or tight end). Each player has an associated cost. You're capped...

I currently have a script set up to run the solver to minimize an output value from 2 inputs. The sheet is formated with the inputs in columns A and B. Each row has the data for 1 end value that I am trying to optimize. Currently I can highlight the entire column of values I want to optimize and...

Hello,</SPAN></SPAN> I have a problem with a pop up on Excel 2007.</SPAN></SPAN> When I send the command from another software (SAS) to save my Excel file, it asks me “Do you want to save the changes you made to…”.</SPAN></SPAN> Well, yes I do, but I find quite annoying that you pop the...