DamGame

	A	B	C	D	E	F	G	H	I	J	K	L
1	2	Water inflow	# Turbines	Water level (yards)	Water height	Height to overflow (yards)	till Overflow	Power produced (kW)	POWER PRODUCTION		Crest height	INSTRUCTIONS
2	1	6	8	198	198 yards	2	2 yards	1584			200	To setup the game:
3	2	8	4	178	178 yards	22	22 yards	712			200	The sheet is in view only mode for security reasons. To play the game:
4	3	10	6	200	200 yards	0	0 yards	1200			200	1. Go on file/download/MicrosoftExcel
5	4	12	6	200	200 yards	0	0 yards	1200		overflow!!	200	2. Open a new blank google sheet
6	5	15	4	200	200 yards	0	0 yards	800		overflow!!	200	3. On that blank sheet go on File/Import and then click on the upload tab
7	6	12	7	200	200 yards	0	0 yards	1400		overflow!!	200	4. Upload your downloaded xlsx.
8	7	4	10	200	200 yards	0	0 yards	2000		overflow!!	200	5. Right click on the "Demo" tab and click on "Protect Sheet"
9	8	4	10	140	140 yards	60	60 yards	1400			200	6. Make sure the right sheet is select in the right hand side tab that opens up.
10	9	4	10	80	80 yards	120	120 yards	800			200	7. Click on Except certin cells and select C2:C11
11	10	4	7	20	20 yards	180	180 yards	140			200	8. Click on "Set Permission" and provide access to yourself.
12	SUM	79	72	1616		384		11236	Total: 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		https://docs.google.com/presentation/d/1Cq5_BJo2kMUSthPJ3VGsEoM0wmQHBVa_wmOmUFeB4uk/edit#slide=id.g2007796fe6f_0_5
38		https://docs.google.com/document/d/1ZZ2gYA2Zli_BjFPKAQEJcFnf07pdJ49KMz5A926Vw9k/edit
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