View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
BHatMJ BHatMJ is offline
external usenet poster
 
Posts: 26
Default 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?