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)?

  • 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

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


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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