Forum Discussion
Telles65
Feb 26, 2020Copper Contributor
Optimization Problem with Fixed Discreet Variables
Hello! My problem is relatively simple, but I can't find a way to make it. I have 14 parts of type A and 14 parts of type B and their weights. I need to group they in 7 sets containing 2 of each (e...
JKPieterse
Feb 26, 2020Silver Contributor
Telles65 See attached. Next time, please upload an Excel file rather than a screen-shot.
- Telles65Feb 26, 2020Copper Contributor
Thank you for the attempt!
On the file you've sent the sets have the biggest possible StdDev of the totals.
I would like to be able to combine to find the smallest possible StdDev.
I've also tried to use the Solver, did not work because I need it to iterate using fixed specific values of the table.
The file is attached this time!
Regards,
- JKPieterseFeb 26, 2020Silver ContributorIs set A always smaller than set B? If so your second table is likely to be the best solution.
- Telles65Mar 01, 2020Copper Contributor
JKPieterse No, not always.
I'm still stuck with this...