First post, apologies if this is somewhere else on the forum, I searched for "Excel" and "Solver" with no returns.

Simply, can someone send me an example of how to use Excel Solver to min/max equipment? I'm looking for the best protection with a given restriction of weight and poise. In the past when I've used excel solver, there was a variable to modify that affected the outcome; usually a quantity of something. But in this example is no quantity, just discrete packages. It seems to truly min/max you would need to have all the possible combinations worked out, and then find what is the best protection based on Weight/Poise restrictions. There is no "Linear" approach.

However, I have seen threads elsewhere that people have done this, so I'm very curious as to how.

Thanks in advance!

Simply, can someone send me an example of how to use Excel Solver to min/max equipment? I'm looking for the best protection with a given restriction of weight and poise. In the past when I've used excel solver, there was a variable to modify that affected the outcome; usually a quantity of something. But in this example is no quantity, just discrete packages. It seems to truly min/max you would need to have all the possible combinations worked out, and then find what is the best protection based on Weight/Poise restrictions. There is no "Linear" approach.

However, I have seen threads elsewhere that people have done this, so I'm very curious as to how.

Thanks in advance!