Solver - Dual analysis

Discuss the spreadsheet application
Post Reply
Jotace
Posts: 1
Joined: Sun Oct 24, 2010 4:47 am

Solver - Dual analysis

Post by Jotace »

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
JC
OpenOffice 3.2 on Ubuntu 10.04
User avatar
Villeroy
Volunteer
Posts: 31346
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Solver - Dual analysis

Post by Villeroy »

Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Post Reply