how to make a sensitivity report in calc? similar to the sensitivity report that excel does automatically after the solution in the solver.
This is about LibreOffice, people don’t necessarily have Excel or the latest version of Excel. Please explain what a sensitivity report does.
Maybe you had better post a sample xlsx, you can add .ods extension after the.xlsx so it can be uploaded here.
Download the practice workbook.
Open with LibreOffice, save as *.ods and reload.
1 Like
Curious. Using the sample spreadsheet, sheet OneVariable, in the Do it Yourself area,
If I select R5:R16, click Data > Multiple Operations (Excel Data Table equivalent) and fill out using the wizard then nothing happens, just empty cells.
If I type =MULTIPLE.OPERATIONS($R$4,$O$6,$Q5) and drag down it works
Page 348, Multiple Operations, of Calc Guide 7.5 shows how to do it.