Excel solver varying in time to solve - sometimes slow and sometimes fast

Copper Contributor

Hello, 

 

I am trying to use solver in an optimization issue. I have several sheets with cross-referencing and I am trying to solve by adjusting 104 variables. Most often, it is very slow using approximately 5 seconds to go through one subproblem. A few times I have experienced it being much faster completing around 100 subproblems each second. 

 

Can anyone shed some light on why it varies so much considering how long it takes Solver to solve the issue? It went through around 12 000 subproblems when it was fast.

 

There are 4 constraints. I have uploadet the exact file I am using.

0 Replies