I have a spreadsheet that i use solver in for getting the optimal lineup with projections. It gives me the optimal lineup and works fine. BUT, is there a way to make it give me more than one optimal lineup??? I've seen other people do it on their spreadsheets but they all cost money.... and im on a budget haha.. if anyone can help i would greatly appreciate it... thanks!
Solver only ever gives one answer. The Evolutionary engine will try multiple starting points to to to avoid local extrema, but you still only get one answer.
You might be able to write some code and use different constraints for each of several runs.
Entia non sunt multiplicanda sine necessitate
Ohhh oka so maybe that is what their doing.... changing the constraints around to give diff answer... got it... i think i know what i have to do now... thanks.
You're welcome.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks