I wonder if Calc can help in my case:
I'm writing a financial forecast for my company. We sell 3 kinds of
But they all use the same scheme when it comes to computing fees and
So i made one (big) table with all the computation process and the
(it has to be shown to financers). The product variables are isolated
top of the sheet.
Then i used scenarii on my variables (there are only 4 variables to
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
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
the forecast table. The problem is scenarii are not the answer,
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
So, is there a way to mix the scenario behaviour with dynamic tables
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
results (in place). Then a 5th sheet could easily summarize all that.
first sheet would not have any result, since without the data of the
sheets, it's only formulas.
I hope i was clear. Not easy to explain that, but i'm sure you see my
and maybe someone has another, magical, solution.
Of course i could copy 3 times the whole sheet (data + computation),
means much more maintenance, since i'm changing often details in the
(i should do changes three times always). And what about same case
Thank you for reaching this line of text :)