Quote Originally Posted by EasymodeX View Post
I have no idea what binary integer programming with excel's solver is; that sounds awesome. Please do send me a copy.
It's basically a type of optimization problem where the variables are binary valued, everything is linear, and there are certain constraints that need to be met (like high enough accuracy, and only 1 piece of equipment per slot).

Here's the spreadsheet: https://mega.co.nz/#!ecUDSDZB!LBH82A...bJ5BvC98sq6Z18

The solver can be accessed from Data -> Solver. From there you can see that our goal is to maximize the total weight by changing the selection cells for the items, subject to the above constraints, and as well constrained so that the variables are binary. After that, make sure the solving method is set to "Simplex LP", hit solve, and it will find the best solution.