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

Using spreadsheet as a function...

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


Joined: 30 Apr 2006
Posts: 3

PostPosted: Sun Apr 30, 2006 12:59 am    Post subject: Using spreadsheet as a function... Reply with quote

Not sure anyone will understand this, but help will be appreciated.

I want to use my spreadsheet as a function with the effect of something like this.

Say I setup a spread sheet that takes an input in cell A5 and gives an output in cell B10 (after quite a lot of intermediate calculation across other cells).

I want to vary A5 across several values listed in cell A1 to E1, and store the result from B10 in A2 to E2.

So its something like...
Plug A1 into A5.
Get result from B10 and place it in A2.
Plug B1 into A5
Get result from B10 and place it in B2.
and so on...

Can Openoffice calc do this?
Back to top
View user's profile Send private message
9point9
Moderator
Moderator


Joined: 31 Aug 2004
Posts: 3875
Location: UK

PostPosted: Sun Apr 30, 2006 1:13 am    Post subject: Reply with quote

Yes.

In 15 put something like =(A1+1) for instance. Then enter other functions referencing that down the sheet.
_________________
Arch Linux
OOo 3.2.0

OOoSVN, change control for OOo documents:
http://sourceforge.net/projects/ooosvn/
Back to top
View user's profile Send private message Visit poster's website
sweitx
Newbie
Newbie


Joined: 30 Apr 2006
Posts: 3

PostPosted: Sun Apr 30, 2006 1:28 am    Post subject: Confused... Reply with quote

Sorry, I don't understand what you mean, could you be more specific?

Btw, the spreadsheet that does the calculation consist of around 200 cells. And that's just for 1 input and 1 output.
Back to top
View user's profile Send private message
9point9
Moderator
Moderator


Joined: 31 Aug 2004
Posts: 3875
Location: UK

PostPosted: Sun Apr 30, 2006 2:05 am    Post subject: Reply with quote

What is the function you are trying to calculate? I doubt you will need 200 cells to do that.

I would suggest you look at this to try and understand spreadsheet principles:
http://en.wikipedia.org/wiki/Spreadsheet
_________________
Arch Linux
OOo 3.2.0

OOoSVN, change control for OOo documents:
http://sourceforge.net/projects/ooosvn/
Back to top
View user's profile Send private message Visit poster's website
sweitx
Newbie
Newbie


Joined: 30 Apr 2006
Posts: 3

PostPosted: Sun Apr 30, 2006 4:15 pm    Post subject: Financial calculation... Reply with quote

I'm calculating the effect of several financial decision over variable time.
Back to top
View user's profile Send private message
noranthon
Super User
Super User


Joined: 07 Jul 2005
Posts: 3318

PostPosted: Sun Apr 30, 2006 11:05 pm    Post subject: Reply with quote

I gather that you want different calculations in different cells. That is simply a matter of entering the appropriate formula in each cell. These links may help:
http://documentation.openoffice.org./manuals/index.html
http://documentation.openoffice.org/HOW_TO/index.html
http://documentation.openoffice.org/faqs/spreadsheet/index.html
Back to top
View user's profile Send private message
carl
Super User
Super User


Joined: 21 Apr 2003
Posts: 920
Location: Germany

PostPosted: Mon May 01, 2006 4:49 am    Post subject: Reply with quote

Quote:
So its something like...
Plug A1 into A5.
Get result from B10 and place it in A2.
Plug B1 into A5
Get result from B10 and place it in B2.
and so on...



Quote:
I'm calculating the effect of several financial decision over variable time.


I would create the formula cells (all 200) so that the data entered in A1 is collected and processed using variables (like% inflation,%growth, %interest, %discount rates) which are entered in cells A3 to A6.
For the result make cell A2 = B10.

For comparison purposes you need to copy the whole thing to a new set of columns

You end up with a big sheet showing in A1 to A6 start value, end value ,% inflation,%growth, %interest, %discount rates.

and in col B1 to B6 other values for start value, end value ,% inflation,%growth, %interest, %discount rates.
_________________
carl
Using OpenOffice.org 2 on XP sp2
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