First time here? Check out the FAQ!
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?
answered 2013-03-06 14:14:24 +0200ROSt52
@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.
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!
Asked: 2012-06-17 18:05:26 +0200
Seen: 298 times
Last updated: Mar 06