Challenge #52: Solving the Knapsack Problem

[Tokimatsu]

Solved.

Spoiler

 

[phottovy]

I went with an iterative macro but I'm sure there are much better ways:

Spoiler

[clmc9601]

My solution

[robert-headington]

#52

[PangHC]

my solution.

[aiahwieder]

I have a feeling I'll be coming back to this one a few more times -- it's an interesting optimization problem that has some practical applications for my Day Job, too!

[rcarog]

Solution attached.

[Hub119]

In retrospect, could have configured this as a batch macro... but a little copy/paste never hurt anyone, right?

[apathetichell]

Fairly psyched with this solution - Analytic app for your max weight/max number of boxes preferences and optimization tool solution...

[BeginnerMindset]

I liked this challenge. I went with the Optimization Tool within a batch macro, which was fairly clean in the end and ready to be made more generic for other variations.

Spoiler

Spoiler