2012 Archives by date, by thread · List index

# [libreoffice-users] Generic formulas or inverse scenarii

```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
```

### Context

• [libreoffice-users] Generic formulas or inverse scenarii · Ninj