Challenge #52: Solving the Knapsack Problem

[Thableaus]

Challenge #52, done.

Spoiler

Ok, I developed a Batch Macro with R code using gtools library and combinations function. Very good exercise on how to mix different functionalities that Alteryx provides us. 
The good thing about this is that I'll probably use this solution in some use cases. 

Cheers,

[TimothyManning]

Spoiler

I found this one very difficult and didn't know where to start for a long time. I used @NicoleJohnson's app as inspiration and used a lot of her ideas for the first part of the macro, then finished it myself. I wanted to be able to put in a list of numbers (of boxes) and then it runs through them all and finds the right combination. It won't work if it goes above 9 at the moment, but I couldn't think of a good way to get all combinations of the numbers of boxes if one of the numbers is 10 or more.

Anyway, I learned a lot in the process so I'm glad I persevered!







Outside the batch macro



Inside of the batch macro

[Greg_Murray]

solution attached

[Cosmin_S]

I used Location Optimizer macro, like other solutions around here. 

Thank you. 

[hanykowska]

Spoiler

Did mine with nested macros...

Batch macro to get results for various limits of items/boxes:

Iterative Macro to update the boxes list (probably unnecessary)

[Hannah_Lissaman]

My solution 🙂

[TonyA]

Went the optimization tool route. Without @JoeM 's one hour video in the Alteryx Academy I never would have figured this out. Thanks Joe! I took Gene's note about creating a different version of the output to heart and came up with this:

Spoiler

[RWvanLeeuwen]

@SeanAdamssolution enabled me to finish this at last.

Spoiler

and the macro:

Spoiler

[T_Willins]

I finished my solution then looked at the other solutions.  Being a finance person, I went to similar logic as @kat that $/kg gives a valid sort order.  From there the rest of the solution was pretty easy with a quick batch macro for the second part.

Spoiler

Spoiler