Isle of Ted Climate Change fishing spreadsheet v2.xlsx

	B	C	D	E	F	G
1
2	FISH POPULATION CALCULATION (PER TURN)				SEE NOTE FOR COLUMN F
3	Turn	Fish Population	Rate of Return	Number of Boats	Total Fish Caught	Final Population
4	1	200	2.0		0	200
5	2	230	2.3		0	230
6	3	265	2.6		0	265
7	4	304	3.0		0	304
8	5	350	3.5		0	350
9	6	402	4.0		0	402
10	7	463	4.6		0	463
11	8	532	5.3		0	532
12	9	612	6.1		0	612
13	10	704	7.0		0	704
14
15
16
17					COLUMN F NOTE
18					Please note that the “Total Fish Caught” column (column F) includes an equation that multiplies the Number of Boats by Rate of Return and THEN multiplies this total by an extra 1.25. This extra bump is pedagogical: within the time constraints of approximately 10 rounds of gameplay, the 1.25x bump ensures that the consequences of overfishing are noticed by Round 5. Teachers can adjust the equation to suit their pedagogical needs (making the consequences more or less dramatic), but without the 1.25x bump, it takes too many rounds for overfishing to result in less than 1 fish per boat (which reduces the pedagogical value).
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36	FISHING RATE OF RETURN CALCULATION (PER TURN)
37	Turn	1 Boat	2 Boats	3 Boats	4 Boats
38	1	2	4	6	8
39	2	2	5	7	9
40	3	3	5	8	11
41	4	3	6	9	12
42	5	3	7	10	14
43	6	4	8	12	16
44	7	5	9	14	19
45	8	5	11	16	21
46	9	6	12	18	24
47	10	7	14	21	28
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100