Date: prev next · Thread: first prev next last
2012 Archives by date, by thread · List index


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,


For unsubscribe instructions e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.