OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

Sensitivity analysis

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc
View previous topic :: View next topic  
Author Message
foxy
Power User
Power User


Joined: 10 Mar 2005
Posts: 82

PostPosted: Mon Jul 30, 2007 12:35 am    Post subject: Sensitivity analysis Reply with quote

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
View user's profile Send private message
multi-lingual_ooo
OOo Advocate
OOo Advocate


Joined: 06 Nov 2004
Posts: 458

PostPosted: Tue Jul 31, 2007 1:55 pm    Post subject: Re: Sensitivity analysis Reply with quote

foxy wrote:
Is it possible to do sensitivity analysis in Ooo Calc the same way as in Excel where I usually use Data > Table function.


I don't think so. OTOH, when I used Excel (way back in the dim and distant past) I constructed a page to show that data. I still do that with OOo.

xan

jonathon
_________________
One of the following might contain more details:

http://oooauthors.org/en/members/tutorials/multilingualooo/
http://esnips.com/web/OOoRelatedThings/
http://esnips.com/web/GraphologyTools
Back to top
View user's profile Send private message Send e-mail
RickRandom
Super User
Super User


Joined: 27 Jan 2006
Posts: 1082
Location: UK

PostPosted: Tue Jul 31, 2007 3:01 pm    Post subject: Reply with quote

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 Wink
Back to top
View user's profile Send private message
foxy
Power User
Power User


Joined: 10 Mar 2005
Posts: 82

PostPosted: Tue Jul 31, 2007 10:24 pm    Post subject: Reply with quote

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
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group