Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
SOLVER does not iterate / work
I am using SOLVER for the first time and it appears that it is not iterating.
The initial objective and "change" values do not change at all after running SOLVER. My objective is to minimize the difference^2 between two columns of data by optimizing one cell which contains a "cut" value. - The first column of data contains fixed integer values of 0 and 1 for 10,000 cases. - The second column of data contains decimal values between 0 and 1 for 10,000 cases. - A third column is calculated based on a cut value ("change" value) where values in the second column = cut are set to 1 and values < cut are set to 0. - The objective/target is to minimize the sum of the differences between the 1st and 3rd column squared. Can anyone help? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Getting Goal Seek or Solver to work | Excel Discussion (Misc queries) | |||
Premium Solver does not work with Vista | Excel Worksheet Functions | |||
I need to install the solver add-in but my setup CD doesn't work. | Setting up and Configuration of Excel | |||
Solver does not work from Macros | Setting up and Configuration of Excel | |||
How do I get Solver to work | Excel Discussion (Misc queries) |