Re: recurrences and scenarios (?) [how to question]

[Jeff Abrahamson <jeff purple com>]

On Thu, Sep 14, 2006 at 01:50:05PM -0400, Morten Welinder wrote:
>   [19 lines, 48 words, 347 characters]  Top characters: 1\natol.n
>
> In this simple case there is nothing that keeps you from just making
> a list:
>
> A1=1, B1=1              # parameters
> C1=O1                     # result
> H1=A1                     # calculations
> I1=B1
> J1=H1+I1
> K1=I1+J1
> ...
> O1=M1+N1
>
> A2=1, B2=3
> C2...O2 as above
>
> etc.
>
> If you have something more elaborate, have a look at
> Edit->Fill->Tabulate.

It looks like I then need one list (table) for each scenario.  (In
this example, I'd make a new Fibonacci sequence column in the table
for each scenario.)  This is what I did, but it feels cumbersome.  I
hide the big table on a second page of the spreadsheet so I at least
don't have to look at it all the time.  But, for example, if I want to
add a new scenario on page one, I have to add a new column to the
table on page 2.

-- 
 Jeff

 Jeff Abrahamson  <http://jeff.purple.com/>          +1 215/837-2287
 GPG fingerprint: 1A1A BA95 D082 A558 A276  63C6 16BF 8C4C 0D1D AE4B