ABCDEFGHIJKLMNOPQRSTUVWXYZAAABAC
1
2Water inflow# TurbinesWater level (yards)Water heightHeight to overflow (yards)till OverflowPower produced (kW)POWER PRODUCTIONCrest height
INSTRUCTIONS
2
168198198 yards22 yards1584200
To setup the game:
3
284178178 yards2222 yards712200
The sheet is in view only mode for security reasons. To play the game:
4
3106200200 yards00 yards1200200
5
4126200200 yards00 yards1200overflow!!200
2. Open a new blank google sheet
6
5154200200 yards00 yards800overflow!!200
3. On that blank sheet go on File/Import and then click on the upload tab
7
6127200200 yards00 yards1400overflow!!200
8
7410200200 yards00 yards2000overflow!!200
5. Right click on the "Demo" tab and click on "Protect Sheet"
9
8410140140 yards6060 yards1400200
6. Make sure the right sheet is select in the right hand side tab that opens up.
10
94108080 yards120120 yards800200
7. Click on Except certin cells and select C2:C11
11
10472020 yards180180 yards140200
12
SUM7972161638411236Total: 11236 GWh
9. Right click on the "Demo" tab at the bottom and duplicate as many times as there are student groups
13
14
To play the game
15
You as a teacher can set the water inflow in column B to simulate a scenario (e.g., the default numbers simulate a flood). Students must then choose the number of turbines to run at teach time period in column C in order to maximize their power production in column I while minimizing overflow in column J. The water height and margin till overflow are given in columns E and F and graphically in the graph.
16
17
18
19
20
21
22
23
24
Water inflows can either be set in advance, or sequentially where each time step the teacher sets the inflow and students chose the turbines with or without knowledge of future inflows. Playing and contrasting the different versions of the game can teach students about hydropower production, multiobjective optimization and or the value of forecast information, amongst others.
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
Slides
45
Docs
46
47
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