How can I perform what-if / sensitivity analysis on my problem in Calc?

English
, ,
#1

I am trying to do a sensitivity analysis. That’s why I set up a simplified model, where two input factors (unit prices of two products) are used throughout a profit calculation. In the end of the project calculation, the total profit of the whole sales process is displayed.

Now, as I want to find out how my total profit changes, whenever my purchasing price changes by 0.5, I’d like it to be displayed in a table (see attached file). I have tried to work with the scenario editor, but I cannot set up any column or row variables. I have done this many times in MS Excel in more complex setups, so I’d like to find a way to automatically have the values displayed, just like in Excel’s What-if-analysis. As I want to work with more complex models, I do not want to manually edit each cell of the data table.

Did I miss something or does anybody know a way how to achieve this?

file download

Sensitivity Analysis in LibreOffice Calc's Solver
#2

Why do you upload file on www.sendspace.com? Why not here, at ask.libreoffice.org/upfiles? (I’ve seen enough ads on the site sendspace.com, invitations to download programs that not necessary , but your file was not received.)

#3

@JohnSUN: ask.libreoffice.org/upfiles: page not found…

#4

I tried to upload the file on this site, but it did not work out and just returned error messages. Sorry for the inconvenience, I will try again.

#5

Perhaps the problem with uploading a file similar to this question - Meta: upload images

#6

@ShenMuLong – Are you still trying to find an Answer to your Question?

#7

@ShenMuLong - you can make what-if scenarios with 2 variables. For details look into the help file of Calc Index / what if operations.

If this doesn’t solve your problems I would need the mathematical formulas you use and then find out how it can be done in Calc.

Basically you should be able to all in Calc what you could do in Excel.

#8

“What-if” scenarios are covered under chapter 9 on Data Analysis in the Calc v4.1 User Guide (and have been since v3.3 of this guide).

#9

Impressum (Legal Info) | Datenschutzerklärung (Privacy Policy)   Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.