Forum Discussion
Edexcel solver help
Hello, I'm working on a scheduling model in Excel using Solver and I'm encountering issues with setting up the decision variables and constraints correctly. My workbook is divided into several sheet...
Excel’s Solver does not allow you to enter noncontiguous ranges directly in the “By Changing Variable Cells” field. However, maybe you can work around it and properly set up your constraints.
Break Down the Problem – If Solver is struggling, test subsets of the constraints separately.
Instead, you should define two separate Solver models or consolidate the ranges.
Reduce Constraints – Too many constraints slow Solver. Try removing redundant ones.
If you have only integer/binary constraints, use Simplex LP.
If there are complex conditions, try GRG Nonlinear or Evolutionary.
Save a Backup – Solver changes data; always keep a copy before running.
My answers are voluntary and without guarantee!
Hope this will help you.