Solver - Dual analysis
Posted: Sun Oct 24, 2010 4:55 am
Hi all,
Although I know how to use Calc's solver, and I saw some related extensios (EuroSolver, for instance), there's still something that I do not know how to do... an I was very ashamed to confess that to a coleague who know how to do it using Excel...
When someone uses Excel's solver for maximizing a linear problem, the program produces a repport in which a lot on information is shown. It is sometimes called the "dual-analysis", the "post-optimial analysis", or even the "sensitivity analysis". It gives information on how can vary the restriction values in a way sucha that the optimal solution remains optimal, and things like this.
If someone knows how to do this using OpenOffice (or any other free-software) I would be very hapy to know!
Thanks!
JC
Although I know how to use Calc's solver, and I saw some related extensios (EuroSolver, for instance), there's still something that I do not know how to do... an I was very ashamed to confess that to a coleague who know how to do it using Excel...
When someone uses Excel's solver for maximizing a linear problem, the program produces a repport in which a lot on information is shown. It is sometimes called the "dual-analysis", the "post-optimial analysis", or even the "sensitivity analysis". It gives information on how can vary the restriction values in a way sucha that the optimal solution remains optimal, and things like this.
If someone knows how to do this using OpenOffice (or any other free-software) I would be very hapy to know!
Thanks!
JC