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

ShenMuLong
21 ● 4

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

delete close flag offensive retag edit

Comments

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

JohnSUN ( 2012-06-17 19:51:09 +0200 )edit

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

tohuwawohu ( 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 ( 2012-06-18 14:35:27 +0200 )edit

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

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

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

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

1 Answer

Sort by » oldest newest most voted

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

ROSt52

2114 ● 1 ● 33 ● 39

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

link delete flag offensive edit

Resources

Donate

LibreOffice is made available by volunteers around the globe, backed by a charitable Foundation. Please support our efforts: Your donation helps us to deliver a better product!

Question tools

Stats

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

Seen: 298 times

Last updated: Mar 06

what-if / sensitivity analysis problem