Re: [libreoffice-users] Generic formulas or inverse scenarii

Hi :)
I have attached a simplistic and rather horrible example.  The mailing list wont get the attachment 
but Ninj should.  A lot of finesse is possible!  For example, getting rid of the 0's.
Regards from
Tom :)

--- On Wed, 14/3/12, Ninj <ninj@informance.info> wrote:

From: Ninj <ninj@informance.info>
Subject: Re: [libreoffice-users] Generic formulas or inverse scenarii
To: users@global.libreoffice.org
Date: Wednesday, 14 March, 2012, 22:49

In fact, i thought of possible solution after i submitted this question. Is 
there a way to link cells between sheets in a way that they are "virtually 
the same"? Changing B4 in a sheet would change also B4 in other sheets where 
B4 is linked.

Because my problem is not more complicated than that finally: "i have three 
sheets almost identical except for the 4 first cells, how do i avoid 
maintening the three ones when i need to change a cell that is the same in all 
three sheets?"

Then i thought of some kind of link. But i don't know...

Thank you!

Ninj

Le 14/03/2012 22:55, Ninj a écrit :
> Hi,
>
> I wonder if Calc can help in my case:
>
> I'm writing a financial forecast for my company. We sell 3 kinds of products.
> But they all use the same scheme when it comes to computing fees and incomes.
> So i made one (big) table with all the computation process and the comments
> (it has to be shown to financers). The product variables are isolated at the
> top of the sheet.
>
> Then i used scenarii on my variables (there are only 4 variables to define a
> product). It's fine: i can switch scenario and i see all the matching
> forecasted results on the computation table.
>
> But now, i want a new spreadsheet summarizing our activity: we sell the 3 kind
> of products, so i make a table with three lines, one by product. Rows are for
> years (5 in my forecast). And of course, i would like this table to be
> dynamic, and change with whatever variable i change in scenarii or formula in
> the forecast table. The problem is scenarii are not the answer, because they
> are by definition volatile: when you switch scenarii, all the data,
> everywhere, gets adapted. Even naming a scenario and using its name when
> refering to a cell doesn't work, because cells out of the scenario's frame are
> considered empty.
>
> So, is there a way to mix the scenario behaviour with dynamic tables mixing
> data from all scenarii?
>
> I thought of generic formulas: i could make only one sheet with all
> computation, then 3 other sheets with only the variable data of each of the 3
> products, and use the first same sheet formula in the 3 next ones to get my
> results (in place). Then a 5th sheet could easily summarize all that. The
> first sheet would not have any result, since without the data of the 3 other
> sheets, it's only formulas.
>
> I hope i was clear. Not easy to explain that, but i'm sure you see my problem,
> and maybe someone has another, magical, solution.
>
> Of course i could copy 3 times the whole sheet (data + computation), but that
> means much more maintenance, since i'm changing often details in the formulas
> (i should do changes three times always). And what about same case but with
> 10+ products?
>
> Thank you for reaching this line of text :)
>
> Best regards,
>
> Ninj

-- 
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted


-- 
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted