| View previous topic :: View next topic |
| Author |
Message |
foxy
Power User
Joined: 10 Mar 2005
Posts: 82
|
 Posted: Mon Jul 30, 2007 12:35 am Post subject: Sensitivity analysis |
 |
|
Is it possible to do sensitivity analysis in Ooo Calc the same way as in Excel where I usually use Data > Table function. (See here what I mean http://jldexcel.blogspot.com/2006/05/data-analysis-with-ms-excel.html). I cannot find the equivalent of this function in Calc.
_________________
Using Ooo 2.2 on Ubuntu Feisty |
|
| Back to top |
|
 |
multi-lingual_ooo
OOo Advocate
Joined: 06 Nov 2004
Posts: 458
|
|
| Back to top |
|
|
RickRandom
Super User
Joined: 27 Jan 2006
Posts: 1082
Location: UK
|
| Posted: Tue Jul 31, 2007 3:01 pm Post subject: |
|
|
Perhaps I'm too set in my ways, but if I had to do the example shown in the link, I'd just create the formula in one cell and copy and paste it into the other cells. I've just done it and it took 3 minutes, including setting up the table layout. I guess the automatic Excel way would save some time, but there is always the risk that an automatic method does something different to what you want automatically....
As an Excel user at work, I have to admit I've never used the Data Table feature, perhaps I've got a bit of a phobia about the Data menu, as it's a bit too close to a Database  |
|
| Back to top |
|
|
foxy
Power User
Joined: 10 Mar 2005
Posts: 82
|
| Posted: Tue Jul 31, 2007 10:24 pm Post subject: |
|
|
OK, I have found it, it is possible to do with Data -> Multiple Operations. Worked very well for me. Cheers anyway for your responses.
_________________
Using Ooo 2.2 on Ubuntu Feisty |
|
| Back to top |
|
|
|
