Home

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

%3CLINGO-SUB%20id%3D%22lingo-sub-896602%22%20slang%3D%22en-US%22%3EExcel%20solver%20varying%20in%20time%20to%20solve%20-%20sometimes%20slow%20and%20sometimes%20fast%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-896602%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20trying%20to%20use%20solver%20in%20an%20optimization%20issue.%20I%20have%20several%20sheets%20with%20cross-referencing%20and%20I%20am%20trying%20to%20solve%20by%20adjusting%20104%20variables.%20Most%20often%2C%20it%20is%20very%20slow%20using%20approximately%205%20seconds%20to%20go%20through%20one%20subproblem.%20A%20few%20times%20I%20have%20experienced%20it%20being%20much%20faster%20completing%20around%20100%20subproblems%20each%20second.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20anyone%20shed%20some%20light%20on%20why%20it%20varies%20so%20much%20considering%20how%20long%20it%20takes%20Solver%20to%20solve%20the%20issue%3F%20It%20went%20through%20around%2012%20000%20subproblems%20when%20it%20was%20fast.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThere%20are%204%20constraints.%20I%20have%20uploadet%20the%20exact%20file%20I%20am%20using.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-896602%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESolver%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
TobbenDK
New 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.

Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Edge insider Dev bypasses IE mode website list
HotCakeX in Enterprise on
4 Replies