Ask Your Question

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

asked 2012-06-17 18:05:26 +0200

ShenMuLong gravatar image

updated 2014-07-04 20:36:23 +0200

bencomp gravatar image

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

edit retag flag offensive 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


Why do you upload file on Why not here, at (I've seen enough ads on the site, invitations to download programs that not necessary , but your file was not received.)

JohnSUN gravatar imageJohnSUN ( 2012-06-17 19:51:09 +0200 )edit
tohuwawohu gravatar imagetohuwawohu ( 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.

ShenMuLong gravatar imageShenMuLong ( 2012-06-18 14:35:27 +0200 )edit

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

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

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

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

2 Answers

Sort by » oldest newest most voted

answered 2013-03-06 14:14:24 +0200

ROSt52 gravatar image

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

edit flag offensive delete link more

answered 2014-07-05 02:48:53 +0200

oweng gravatar image

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

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2012-06-17 18:05:26 +0200

Seen: 4,998 times

Last updated: Jul 05 '14