Challenge #52: Solving the Knapsack Problem

[Wouter]

For my solution I've used the Optimization Tool:

Spoiler

[danrh]

Will only work to 9 boxes ... hmm ....

[JoBen]

Cheers!

[kelly_gilbert]

This was a good opportunity to learn how to configure inputs for the Optimization tool. It was tricky to get the inputs set up just right!

Spoiler

 Main workflow:



Batch macro:


 

[yajing_wang]

feel the solution is not accurate as it only works for the data set provided. It does not consider the dollar/kg. In some situation, it is better to pick up the one with less dollar but much less kg box.

[yajing_wang]

This one take me really long time, but find out the my best and easiest way to solve this issue, I am happy! Did not consider the situation that it may better to take 2 smaller kg box than 1 heavy box....

Workflow:

Spoiler

Spoiler:
Use the idea of batch macro and process by group which make it is easier for Iteration macro and suitable for more than one case.

Macro:

Spoiler

Spoiler:

[Kenda]

Spoiler

So I didn't think this one was hard, I just made it really tedious. And it only works for 5 boxes. But it's done.

[jbranaum]

My Solution.

[jssandom]

Tough one!

[pasccout]

Here is my solution...