I have a macro that runs and pulls a bunch of data out of access based on
certain criteria. It works fine. Then I go into manually run the solver. I am
maximizing a value and wanting to keep a set of 24 weights, when summed up,
equal to one. Also, the maximum of any of these weights cannot be 2. The
problem is solver just sets all of my weights to the same number. Is there a
way around this? Thanks

Put in a two formulas
=Sum(A1:A24)
=Max(A1:A24)

(as examples)

then put in constraints to limit the values for those formulas (cells that
contain the formulas).

--
Regards,
Tom Ogilvy


"Need Help Fast!" wrote:

I have a macro that runs and pulls a bunch of data out of access based on
certain criteria. It works fine. Then I go into manually run the solver. I am
maximizing a value and wanting to keep a set of 24 weights, when summed up,
equal to one. Also, the maximum of any of these weights cannot be 2. The
problem is solver just sets all of my weights to the same number. Is there a
way around this? Thanks

Sorry, that's what I did, and it doesn't work. Thanks

"Tom Ogilvy" wrote:

Put in a two formulas
=Sum(A1:A24)
=Max(A1:A24)

(as examples)

then put in constraints to limit the values for those formulas (cells that
contain the formulas).

--
Regards,
Tom Ogilvy


"Need Help Fast!" wrote:

I have a macro that runs and pulls a bunch of data out of access based on
certain criteria. It works fine. Then I go into manually run the solver. I am
maximizing a value and wanting to keep a set of 24 weights, when summed up,
equal to one. Also, the maximum of any of these weights cannot be 2. The
problem is solver just sets all of my weights to the same number. Is there a
way around this? Thanks