When using Excel solver there are options to terminate optimisation after a max number of subproblems, or a set period of time without improvement in the objective function output. Presumably, if using the latter, running the optimisation on a system with greater computing power, a greater number of sub-problems will be tested before timing out and therefore the possibility of a "more optimal" solution exists.
This got me wondering if there was a way of automatically recording the number of subproblems for each optimisation run. I could then use stats based on this data to set a max sub problem limit as an alternative to time without improvement - that way if i run the model on a less powerful system, i can be sure that i am going to get similar results (there is no point in setting the max subproblem limit to say 10, if the optimal solution is found after 300 sub problems on average).
The question is, does anybody know how to automatically record the number of subproblems for each model run? I run my model on a loop via a macro.
Many thanks in advance.