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

Hi. Just a guess of course. Are you using IF() functions to make this
decision? If so, Solver "usually" will not work if you use these types
of functions.
Don't know exactly how you are set up to offer any suggestions.
= == = =
Dana DeLouis



BHatMJ wrote:
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?