Weekly Challenges
Solve the challenge, share your solution and summit the ranks of our Community!Also available in | Français | Português | Español | 日本語
IDEAS WANTED
Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEA
My solution is based on an iterative macro for n_items > 1 case. Open to suggestion on how to improve the flow!
Spoiler
Main Flow
Detail of the macro used
Main FlowDetail of the macro used
A little bit late to the party, but I got it! Took a bit of time.
Spoiler
That was fun - probably could have done it faster but still taking some time getting to grips with the optimization tool.
Approach was to get the desired result for the initial problem 1 box allowed. Then wrap in an iterative macro for more and more items allowed.
Things that weighed me down was setting the UB correctly to stop the model picking two of the boxes that did not exist and realizing I needed a count field to apply a restriction of total items allowed.
Approach was to get the desired result for the initial problem 1 box allowed. Then wrap in an iterative macro for more and more items allowed.
Things that weighed me down was setting the UB correctly to stop the model picking two of the boxes that did not exist and realizing I needed a count field to apply a restriction of total items allowed.
