Tell me more ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.
up vote 3 down vote favorite
2

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
1  
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
1  
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

1 Answer

up vote 0 down vote

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

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.