Multiple Solvers on One Worksheet

[mbshafe]

I've set up a solver model that works perfectly for one objective and two constraints. I'm looking at a group of stock funds and using historical data to suggest the optimal weightings to produce a particular return while minimizing risk. So, for my single solver, I specify:

Objective: Minimize Calculated Variance
By Changing Weightings in Variable Cells
Subject to:
Constraint 1: Weights Must Add up to 100%
Constraint 2: Target Return

I have 10 different target returns which would be based upon the same type of specifications. Is there a way to set up 10 different solvers in one worksheet?

TIA

 

[iliace]

Solver has an option to save the current model (Load/Save button). So you could save each of your 10 Solver setups, and load each one as needed.

 

[mbshafe]

Thanks...so if I want to run them all at once, would I have to use a macro?

 

[iliace]

I don't see any other way, so yes, you would have to use a macro.

Take a look here for an example: https://msdn.microsoft.com/en-us/library/office/ff192980.aspx
Full article here: https://msdn.microsoft.com/en-us/library/office/ff196600.aspx
Other useful info: Excel Solver - Using Solver from VBA | solver

 

[mbshafe]

Thank you so much!