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 <n...@informance.info> wrote: From: Ninj <n...@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+h...@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+h...@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