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

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?

edit retag reopen merge delete

### Closed for the following reason the question is answered, right answer was accepted by Alex Kemp close date 2016-02-28 20:28:17.705510

( 2012-06-17 19:51:09 +0200 )edit
( 2012-06-18 06:55:14 +0200 )edit

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.

( 2012-06-18 14:35:27 +0200 )edit
1

( 2012-06-18 16:56:40 +0200 )edit

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

( 2013-03-06 09:54:56 +0200 )edit

Sort by » oldest newest most voted

@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.

more

"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).

more