Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Is there any good Open Source spreadsheet program that has a solver for linear programs (either included or via an extension) that does a proper sensitivity analysis (shadow prices etc)? It seems like OpenOffice and LibreOffice both don't offer the feature (and do not save the solver's metadata to the spreadsheet file which is quite annoying) and Gnumeric apparently has dropped its support for different reports including the sensitivity analysis.

Are there any good options left (I'd like to propose such a tool to my students as an alternative to Excel)?

share|improve this question
Are you set on a spreadsheet solution or would you consider suggesting R, we used it as undergrads in Biology with success. And it appears to be gaining traction over SAS – Tyler Feb 11 '11 at 5:48
Personally, I wouldn't mind using R, GLPK, CPLEX or any other more professional tool. However, some of my (business) students might get scared of anything that goes beyond a normal spreadsheet program :( – Gerald Senarclens de Grancy Feb 13 '11 at 15:18

I'm fairly certain that google docs can solve linear programs. Not so sure about the sensitivity analysis.

share|improve this answer
Thanks for the hint, but Google docs doesn't offer a sensitivity analysis. – Gerald Senarclens de Grancy Mar 26 '11 at 9:49

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .