Challenge #52: Solving the Knapsack Problem

[Ladarthure]

my solution, struggled with optimization tool, but nice to use

[danicahui]

Spoiler

Perhaps not the quickest solution, but ended up building a macro that selects the optimal combination of boxes 


and tested it against every possible combination of 1, 2, 3 or 4 boxes

[FlorianC]

This is a perfect use-case for the optimisation tool!

Spoiler

WorkflowMacro

[JethroChen]

Spoiler

[JoePC]

Solution Attached

[A2H]

Spoiler

[greggrimmer1]

Spoiler

Solved using the optimization tool - batched to run for multiple item count constraints.

[Qiu]

Difficult...

[AkimasaKajitani]

My solution.

I made 3 version.

1.Using Optimization tool

2.Using Iterative Macro

3.Using Location Optimizer Macro

I used the Location Optimizer macro for the first time at this challenge.

There was not much information, but the challenge gave me a clue to use.

Spoiler

[mikeprice17]

Don't know a lot about optimization but my simple solution worked for this case but I don't think it would with larger more complex cases.