The solver in LO Calc should be able to provide a sensitivity report after solving the model. This has been requested multiple times in our forums: https://ask.libreoffice.org/t/how-to-make-a-sensitivity-report-in-calc/88556 https://ask.libreoffice.org/t/sensitivity-analysis-in-libreoffice-calcs-solver/41078 https://ask.libreoffice.org/t/how-can-i-perform-what-if-sensitivity-analysis-on-my-problem-in-calc/1055 https://ask.libreoffice.org/t/como-fazer-um-relatorio-de-sensibilidade-no-libreoffice-calc/88015 (this one is the pt-BR forum) https://forum.openoffice.org/en/forum/viewtopic.php?f=9&t=35245 Note that both linear engines that we offer (coinmp and lpsolve) are capable of performing sensitivity analysis: https://lpsolve.sourceforge.net/5.5/sensitivity.htm https://jckantor.github.io/ND-Pyomo-Cookbook/notebooks/02.02-Production-Model-Sensitivity-Analysis.html
Let's set to NEW
WIP patch is here: https://gerrit.libreoffice.org/c/core/+/173642
Created attachment 196740 [details] Sample model for testing To test the patch with this file, simple open it and then: 1) Tools - Solver (the model will already be saved) 2) Click Options 3) Make sure "LibreOffice Linear Solver" is selected 4) Check "Generate sensitivity report" 5) Click OK and then Solve 6) After the solution was found, click Keep Result The sensitivity report will be generated in a new sheet called "Model_Sensitivity"
Rafael Lima committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/2f1dcf01d713f786ed1bfdc2ba3b6c9e06fb8ecf tdf#157519 Implement Sensitivity Report in LpSolve solver It will be available in 25.2.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.