Jan 16 2018 04:20 PM
ISSUE:
In the Solver (Data Analysis add-on) isn't clear which of methods is uses: Simplex or dual Simplex method (in the add-on provider described, that uses both methods - look below).
In the offisial provider page (EXCEL SOLVER - ALGORITHMS AND METHODS USED) - described, that using both methods, citate:
The Microsoft Office Excel Solver tool uses several algorithms to find optimal solutions.
...
The Simplex LP Solving Method for linear programming uses the Simplex and dual Simplex method with bounds on the variables, and problems with integer constraints use the branch and bound method, as implemented by John Watson and Daniel Fylstra, Frontline Systems, Inc.
...
- but how can I choose concrete method (or know whith is using)?
LP Simplex and dual Simplex method choose
precondition:
Add solver: Load the Solver Add-in in Excel
Calculate: Define and solve a problem by using Solver / Example of a Solver evaluation
To repoduce:
Actually:
choosing only LP Simplex
Expectation:
choose LP Simplex + method type { Simplex, dual Simplex }
Sep 20 2019 08:30 PM