[Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register]

Author Message
sweitx
Newbie

Joined: 30 Apr 2006
Posts: 3

 Posted: Sun Apr 30, 2006 12:59 am    Post subject: Using spreadsheet as a function... 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?
9point9
Moderator

Joined: 31 Aug 2004
Posts: 3875
Location: UK

 Posted: Sun Apr 30, 2006 1:13 am    Post subject: 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/
sweitx
Newbie

Joined: 30 Apr 2006
Posts: 3

 Posted: Sun Apr 30, 2006 1:28 am    Post subject: Confused... 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.
9point9
Moderator

Joined: 31 Aug 2004
Posts: 3875
Location: UK

 Posted: Sun Apr 30, 2006 2:05 am    Post subject: 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/
sweitx
Newbie

Joined: 30 Apr 2006
Posts: 3

 Posted: Sun Apr 30, 2006 4:15 pm    Post subject: Financial calculation... I'm calculating the effect of several financial decision over variable time.
noranthon
Super User

Joined: 07 Jul 2005
Posts: 3318

 Posted: Sun Apr 30, 2006 11:05 pm    Post subject: 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
carl
Super User

Joined: 21 Apr 2003
Posts: 920
Location: Germany

Posted: Mon May 01, 2006 4:49 am    Post subject:

 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
 Display posts from previous: All Posts1 Day7 Days2 Weeks1 Month3 Months6 Months1 Year Oldest FirstNewest First
 All times are GMT - 8 Hours Page 1 of 1

 Jump to: Select a forum OpenOffice.org Forums----------------Setup and TroubleshootingOpenOffice.org WriterOpenOffice.org CalcOpenOffice.org ImpressOpenOffice.org DrawOpenOffice.org MathOpenOffice.org BaseOpenOffice.org Macros and APIOpenOffice.org Code Snippets Community Forums----------------General DiscussionSite Feedback
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