| A |
B |
C |
D |
E |
F |
| 1 | Fibbonacci Rabbits -- A Lesson in building formulas in Excel |
|
|
|
|
|
| 2 | |
Immature |
Mature |
Total |
|
|
| 3 | |
Rabbits |
Rabbits |
Rabbits |
|
|
| 4 | |
1 |
0 |
1 |
<--------- |
At stage 1 we have one immature female, no mature females |
| 5 | |
0 |
1 |
1 |
<--------- |
At stage 2 we have 1 mature female starting to gestate, no immature females |
| 6 | |
1 |
1 |
2 |
<--------- |
At stage 3 we can build our formulas: |
| 7 | |
1 |
2 |
3 |
|
• new immature females = previous mature females (they gave birth) |
| 8 | |
2 |
3 |
5 |
|
• new mature females = previous immature females+previous mature females |
| 9 | |
3 |
5 |
8 |
|
• COPY DOWN!!! |
| 10 | |
5 |
8 |
13 |
|
|
| 11 | |
8 |
13 |
21 |
|
FORMULAS: |
| 12 | |
13 |
21 |
34 |
|
IN B6: = C5 |
| 13 | |
21 |
34 |
55 |
|
IN C6: =B5+C5 |
| 14 | |
34 |
55 |
89 |
|
IN D6: =B6+C6 |
| 15 | |
55 |
89 |
144 |
|
|
| 16 | |
89 |
144 |
233 |
|
|
| 17 | |
144 |
233 |
377 |
|
|
| 18 | |
233 |
377 |
610 |
|
|
| 19 | |
377 |
610 |
987 |
|
|
| 20 | |
610 |
987 |
1597 |
|
|
