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
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies