]> git.sesse.net Git - ultimatescore/blob - carousel.js
Make the roster scripts executable.
[ultimatescore] / carousel.js
1 'use strict';
2
3 function addheading(carousel, colspan, content)
4 {
5         let thead = document.createElement("thead");
6         let tr = document.createElement("tr");
7         let th = document.createElement("th");
8         th.innerHTML = content;
9         th.setAttribute("colspan", colspan);
10         tr.appendChild(th);
11         thead.appendChild(tr);
12         carousel.appendChild(thead);
13 };
14 function addtd(tr, className, content) {
15         let td = document.createElement("td");
16         td.appendChild(document.createTextNode(content));
17         td.className = className;
18         tr.appendChild(td);
19 };
20 function addth(tr, className, content) {
21         let th = document.createElement("th");
22         th.appendChild(document.createTextNode(content));
23         th.className = className;
24         tr.appendChild(th);
25 };
26
27 function subrank_partitions(games, parts, start_rank, tiebreakers) {
28         let result = [];
29         for (let i = 0; i < parts.length; ++i) {
30                 let part = rank(games, parts[i], start_rank, tiebreakers);
31                 for (let j = 0; j < part.length; ++j) {
32                         result.push(part[j]);
33                 }
34                 start_rank += part.length;
35         }
36         return result;
37 };
38
39 function partition(teams, compare)
40 {
41         teams.sort(compare);
42
43         let parts = [];
44         let curr_part = [teams[0]];
45         for (let i = 1; i < teams.length; ++i) {
46                 if (compare(teams[i], curr_part[0]) != 0) {
47                         parts.push(curr_part);
48                         curr_part = [];
49                 }
50                 curr_part.push(teams[i]);
51         }
52         if (curr_part.length != 0) {
53                 parts.push(curr_part);
54         }
55         return parts;
56 };
57
58 function explain_tiebreaker(parts, rule_name)
59 {
60         let result = [];
61         for (let i = 0; i < parts.length; ++i) {
62                 result.push(parts[i].map(function(x) { return x.shortname; }).join("/"));
63         }
64         return result.join(" > ") + " (" + rule_name + ")";
65 }
66
67 function make_teams_to_idx(teams)
68 {
69         let teams_to_idx = [];
70         for (let i = 0; i < teams.length; i++) {
71                 teams_to_idx[teams[i].name] = i;
72                 teams_to_idx[teams[i].mediumname] = i;
73                 teams_to_idx[teams[i].shortname] = i;
74         }
75         return teams_to_idx;
76 }
77
78 function partition_by_beat(teams, fill_beatmatrix)
79 {
80         // Head-to-head score by way of components. First construct the beat matrix.
81         let n = teams.length;
82         let beat = new Array(n);
83         let teams_to_idx = make_teams_to_idx(teams);
84         for (let i = 0; i < n; i++) {
85                 beat[i] = new Array(n);
86                 for (let j = 0; j < n; j++) {
87                         beat[i][j] = 0;
88                 }
89         }
90         fill_beatmatrix(beat, teams_to_idx);
91         // Floyd-Warshall for transitive closure.
92         for (let k = 0; k < n; ++k) {
93                 for (let i = 0; i < n; ++i) {
94                         for (let j = 0; j < n; ++j) {
95                                 if (beat[i][k] && beat[k][j]) {
96                                         beat[i][j] = 1;
97                                 }
98                         }
99                 }
100         }
101
102         // See if we can find any team that is comparable to all others.
103         for (let pivot_idx = 0; pivot_idx < n; pivot_idx++) {
104                 let incomparable = false;
105                 for (let i = 0; i < n; ++i) {
106                         if (i != pivot_idx && beat[pivot_idx][i] == 0 && beat[i][pivot_idx] == 0) {
107                                 incomparable = true;
108                                 break;
109                         }
110                 }
111                 if (!incomparable) {
112                         // Split the teams into three partitions:
113                         let better_than_pivot = [], equal = [], worse_than_pivot = [];
114                         for (let i = 0; i < n; ++i) {
115                                 let we_beat = (beat[pivot_idx][i] == 1);
116                                 let they_beat = (beat[i][pivot_idx] == 1);
117                                 if ((i == pivot_idx) || (we_beat && they_beat)) {
118                                         equal.push(teams[i]);
119                                 } else if (we_beat && !they_beat) {
120                                         worse_than_pivot.push(teams[i]);
121                                 } else if (they_beat && !we_beat) {
122                                         better_than_pivot.push(teams[i]);
123                                 } else {
124                                         console.log("this shouldn't happen");
125                                 }
126                         } 
127                         let result = [];
128                         if (better_than_pivot.length > 0) {
129                                 result = partition_by_beat(better_than_pivot, fill_beatmatrix);
130                         }
131                         result.push(equal);  // Obviously can't be partitioned further.
132                         if (worse_than_pivot.length > 0) {
133                                 result = result.concat(partition_by_beat(worse_than_pivot, fill_beatmatrix));
134                         }
135                         return result;
136                 }
137         }
138
139         // No usable pivot was found, so the graph is inherently
140         // disconnected, and we cannot partition it.
141         return [teams];
142 }
143
144 // Takes in an array, gives every element a rank starting with 1, and returns.
145 function rank(games, teams, start_rank, tiebreakers) {
146         if (teams.length <= 1) {
147                 // Only one team, so trivial.
148                 teams[0].rank = start_rank;
149                 return teams;
150         }
151
152         // Rule #0: Partition the teams by score.
153         let score_parts = partition(teams, function(a, b) { return b.pts - a.pts });
154         if (score_parts.length > 1) {
155                 return subrank_partitions(games, score_parts, start_rank, tiebreakers);
156         }
157
158         // Rule #1: Head-to-head wins.
159         let num_relevant_games = 0;
160         let beat_parts = partition_by_beat(teams, function(beat, teams_to_idx) {
161                 for (let i = 0; i < games.length; ++i) {
162                         let idx1 = teams_to_idx[games[i].name1];
163                         let idx2 = teams_to_idx[games[i].name2];
164                         if (idx1 !== undefined && idx2 !== undefined) {
165                                 if (games[i].score1 > games[i].score2) {
166                                         beat[idx1][idx2] = 1;
167                                         ++num_relevant_games;
168                                 } else if (games[i].score1 < games[i].score2) {
169                                         beat[idx2][idx1] = 1;
170                                         ++num_relevant_games;
171                                 }
172                         }
173                 }
174         });
175         if (beat_parts.length > 1) {
176                 tiebreakers.push(explain_tiebreaker(beat_parts, 'head-to-head'));
177                 return subrank_partitions(games, beat_parts, start_rank, tiebreakers);
178         }
179
180         // Rule #2: Number of games played (fewer is better).
181         // Actually the rule says “fewest losses”, but fewer games is equivalent
182         // as long as teams have the same amount of points and ties don't exist.
183         let nplayed_parts = partition(teams, function(a, b) { return a.nplayed - b.nplayed });
184         if (nplayed_parts.length > 1) {
185                 tiebreakers.push(explain_tiebreaker(nplayed_parts, 'fewer losses'));
186                 return subrank_partitions(games, nplayed_parts, start_rank, tiebreakers);
187         }
188
189         // Rule #3: Head-to-head goal difference (if all have played).
190         let teams_to_idx = make_teams_to_idx(teams);
191         if (num_relevant_games >= teams.length * (teams.length - 1) / 2) {
192                 for (let i = 0; i < teams.length; i++) {
193                         teams[i].h2h_gd = 0;
194                         teams[i].h2h_goals = 0;
195                 }
196                 for (let i = 0; i < games.length; ++i) {
197                         let idx1 = teams_to_idx[games[i].name1];
198                         let idx2 = teams_to_idx[games[i].name2];
199                         if (idx1 !== undefined && idx2 !== undefined &&
200                             !isNaN(games[i].score1) && !isNaN(games[i].score2)) {
201                                 teams[idx1].h2h_gd += games[i].score1;
202                                 teams[idx1].h2h_gd -= games[i].score2;
203                                 teams[idx2].h2h_gd += games[i].score2;
204                                 teams[idx2].h2h_gd -= games[i].score1;
205
206                                 teams[idx1].h2h_goals += games[i].score1;
207                                 teams[idx2].h2h_goals += games[i].score2;
208                         }
209                 }
210                 let h2h_gd_parts = partition(teams, function(a, b) { return b.h2h_gd - a.h2h_gd });
211                 if (h2h_gd_parts.length > 1) {
212                         tiebreakers.push(explain_tiebreaker(h2h_gd_parts, 'head-to-head goal difference'));
213                         return subrank_partitions(games, h2h_gd_parts, start_rank, tiebreakers);
214                 }
215         }
216
217         // Rule #4: Goal difference against common opponents.
218         var results = {};
219         for (let i = 0; i < games.length; ++i) {
220                 if (results[games[i].name1] === undefined) {
221                         results[games[i].name1] = {};
222                 }
223                 if (results[games[i].name2] === undefined) {
224                         results[games[i].name2] = {};
225                 }
226                 results[games[i].name1][games[i].name2] = [ games[i].score1, games[i].score2 ];
227                 results[games[i].name2][games[i].name1] = [ games[i].score2, games[i].score1 ];
228         }
229         let gd_parts = partition_by_beat(teams, function(beat, teams_to_idx) {
230                 for (const team_i of Object.keys(teams_to_idx)) {
231                         let i = teams_to_idx[team_i];
232                         for (const team_j of Object.keys(teams_to_idx)) {
233                                 let j = teams_to_idx[team_j];
234                                 let results_i = results[team_i], results_j = results[team_j];
235                                 let gd_i = 0, gd_j = 0;
236
237                                 // See if the two teams have both played a third team k.
238                                 for (let k in results_i) {
239                                         if (!results_i.hasOwnProperty(k)) continue;
240                                         if (results_j !== undefined && results_j[k] !== undefined) {
241                                                 gd_i += results_i[k][0] - results_i[k][1];
242                                                 gd_j += results_j[k][0] - results_j[k][1];
243                                         }
244                                 }
245
246                                 if (gd_i > gd_j) {
247                                         beat[i][j] = 1;
248                                 } else if (gd_i < gd_j) {
249                                         beat[j][i] = 1;
250                                 }
251                         }
252                 }
253         });
254         if (gd_parts.length > 1) {
255                 tiebreakers.push(explain_tiebreaker(gd_parts, 'goal difference versus common opponents'));
256                 return subrank_partitions(games, gd_parts, start_rank, tiebreakers);
257         }
258
259         // Rule #5: Head-to-head scored goals (if all have played).
260         if (num_relevant_games >= teams.length * (teams.length - 1) / 2) {
261                 let h2h_goals_parts = partition(teams, function(a, b) { return b.h2h_goals - a.h2h_goals });
262                 if (h2h_goals_parts.length > 1) {
263                         tiebreakers.push(explain_tiebreaker(h2h_goals_parts, 'head-to-head scored goals'));
264                         return subrank_partitions(games, h2h_goals_parts, start_rank, tiebreakers);
265                 }
266         }
267
268         // Rule #6: Goals scored against common opponents.
269         let goals_parts = partition_by_beat(teams, function(beat, teams_to_idx) {
270                 for (const team_i of Object.keys(teams_to_idx)) {
271                         let i = teams_to_idx[team_i];
272                         for (const team_j of Object.keys(teams_to_idx)) {
273                                 let j = teams_to_idx[team_j];
274                                 let results_i = results[team_i], results_j = results[team_j];
275                                 let goals_i = 0, goals_j = 0;
276
277                                 // See if the two teams have both played a third team k.
278                                 for (let k in results_i) {
279                                         if (!results_i.hasOwnProperty(k)) continue;
280                                         if (results_j !== undefined && results_j[k] !== undefined) {
281                                                 goals_i += results_i[k][0];
282                                                 goals_j += results_j[k][0];
283                                         }
284                                 }
285
286                                 if (goals_i > goals_j) {
287                                         beat[i][j] = 1;
288                                 } else if (goals_i < goals_j) {
289                                         beat[j][i] = 1;
290                                 }
291                         }
292                 }
293         });
294         if (goals_parts.length > 1) {
295                 tiebreakers.push(explain_tiebreaker(goals_parts, 'goals scored against common opponents'));
296                 return subrank_partitions(games, goals_parts, start_rank, tiebreakers);
297         }
298
299         // OK, it's a tie. Give them all the same rank.
300         let result = [];
301         for (let i = 0; i < teams.length; ++i) {
302                 result.push(teams[i]);
303                 result[i].rank = start_rank;
304         }
305         return result; 
306 }; 
307
308 function parse_teams_from_spreadsheet(response) {
309         let teams = [];
310         for (let i = 2; response.values[i].length >= 1; ++i) {
311                 teams.push({
312                         "name": response.values[i][0],
313                         "mediumname": response.values[i][1],
314                         "shortname": response.values[i][2],
315                         "tags": response.values[i][3],
316                         "nplayed": 0,
317                         "gd": 0,
318                         "pts": 0,
319                         "goals": 0
320                 });
321         }
322         return teams;
323 };
324
325 function parse_games_from_spreadsheet(response, group_name, include_unplayed) {
326         let games = [];
327         let i;
328         for (i = 0; i < response.values.length; ++i) {
329                 if (response.values[i][0] === 'Results') {
330                         i += 2;
331                         break;
332                 }
333         }
334
335         for ( ; response.values[i] !== undefined && response.values[i].length >= 1; ++i) {
336                 if ((response.values[i][2] && response.values[i][3]) || include_unplayed) {
337                         let real_group_name = response.values[i][9];
338                         if (real_group_name === undefined) {
339                                 real_group_name = group_name;
340                         }
341                         games.push({
342                                 "name1": response.values[i][0],
343                                 "name2": response.values[i][1],
344                                 "score1": parseInt(response.values[i][2]),
345                                 "score2": parseInt(response.values[i][3]),
346                                 "streamday": response.values[i][7],
347                                 "streamtime": response.values[i][8],
348                                 "group_name": real_group_name
349                         });
350                 }
351         }
352         return games;
353 };
354
355 function apply_games_to_teams(games, teams)
356 {
357         let teams_to_idx = make_teams_to_idx(teams);
358         for (let i = 0; i < games.length; ++i) {
359                 let idx1 = teams_to_idx[games[i].name1];
360                 let idx2 = teams_to_idx[games[i].name2];
361                 if (games[i].score1 === undefined || games[i].score2 === undefined ||
362                     isNaN(games[i].score1) || isNaN(games[i].score2) ||
363                     idx1 === undefined || idx2 === undefined ||
364                     games[i].score1 == games[i].score2) {
365                         continue;
366                 }
367                 ++teams[idx1].nplayed;
368                 ++teams[idx2].nplayed;
369                 teams[idx1].goals += games[i].score1;
370                 teams[idx2].goals += games[i].score2;
371                 teams[idx1].gd += games[i].score1;
372                 teams[idx2].gd += games[i].score2;
373                 teams[idx1].gd -= games[i].score2;
374                 teams[idx2].gd -= games[i].score1;
375                 if (games[i].score1 > games[i].score2) {
376                         teams[idx1].pts += 2;
377                 } else {
378                         teams[idx2].pts += 2;
379                 }
380         }
381 }
382
383 function display_group_parsed(teams, games, group_name)
384 {
385         document.getElementById('entire-bug').style.display = 'none';
386
387         apply_games_to_teams(games, teams);
388         let tiebreakers = [];
389         teams = rank(games, teams, 1, tiebreakers);
390
391         let carousel = document.getElementById('carousel');
392         clear_carousel(carousel);
393
394         addheading(carousel, 5, "Current standings, " + ultimateconfig['tournament_title'] + "<br />" + group_name);
395         let tr = document.createElement("tr");
396         tr.className = "subfooter";
397         addth(tr, "rank", "");
398         addth(tr, "team", "");
399         addth(tr, "nplayed", "P");
400         addth(tr, "gd", "GD");
401         addth(tr, "pts", "Pts");
402         carousel.appendChild(tr);
403
404         let row_num = 2;
405         for (let i = 0; i < teams.length; ++i) {
406                 let tr = document.createElement("tr");
407
408                 addth(tr, "rank", teams[i].rank);
409                 addtd(tr, "team", teams[i].name);
410                 addtd(tr, "nplayed", teams[i].nplayed);
411                 addtd(tr, "gd", teams[i].gd.toString().replace(/-/, '−'));
412                 addtd(tr, "pts", teams[i].pts);
413
414                 carousel.appendChild(tr);
415         }
416
417         if (tiebreakers.length > 0) {
418                 let tie_tr = document.createElement("tr");
419                 tie_tr.className = "footer";
420                 let td = document.createElement("td");
421                 td.appendChild(document.createTextNode("Tiebreaks applied: " + tiebreakers.join(', ')));
422                 td.setAttribute("colspan", "5");
423                 tie_tr.appendChild(td);
424                 carousel.appendChild(tie_tr);
425         }
426
427         let footer_tr = document.createElement("tr");
428         footer_tr.className = "footer";
429         let td = document.createElement("td");
430         td.appendChild(document.createTextNode(ultimateconfig['tournament_footer']));
431         td.setAttribute("colspan", "5");
432         footer_tr.appendChild(td);
433         carousel.appendChild(footer_tr);
434
435         fade_in_rows(carousel);
436
437         carousel.style.display = 'table';
438 };
439
440 function fade_in_rows(table)
441 {
442         let trs = table.getElementsByTagName("tr");
443         for (let i = 1; i < trs.length; ++i) {  // The header already has its own fade-in.
444                 if (trs[i].className === "footer") {
445                         trs[i].style = "-webkit-animation: fade-in 1.0s ease; -webkit-animation-delay: " + (0.25 * i) + "s; -webkit-animation-fill-mode: both;";
446                 } else {
447                         trs[i].style = "-webkit-animation: fade-in 2.0s ease; -webkit-animation-delay: " + (0.25 * i) + "s; -webkit-animation-fill-mode: both;";
448                 }
449         }
450 };
451
452 function fade_out_rows(table)
453 {
454         let trs = table.getElementsByTagName("tr");
455         for (let i = 0; i < trs.length; ++i) {
456                 if (trs[i].className === "footer") {
457                         trs[i].style = "-webkit-animation: fade-out 1.0s ease; -webkit-animation-delay: " + (0.125 * i) + "s; -webkit-animation-fill-mode: both;";
458                 } else {
459                         trs[i].style = "-webkit-animation: fade-out 1.0s ease; -webkit-animation-delay: " + (0.125 * i) + "s; -webkit-animation-fill-mode: both;";
460                 }
461         }
462 };
463
464 function clear_carousel(table)
465 {
466         while (table.childNodes.length > 0) {
467                 table.removeChild(table.firstChild);
468         }
469 };
470
471 // Stream schedule
472 let max_list_len = 7;
473
474 function display_stream_schedule(response, group_name) {
475         let teams = parse_teams_from_spreadsheet(response);
476         let games = parse_games_from_spreadsheet(response, group_name, true);
477         display_stream_schedule_parsed(teams, games, 0);
478 };
479
480 function sort_game_list(games) {
481         games = games.filter(function(game) { return game.streamtime !== undefined && game.streamtime.match(/[0-9]+:[0-9]+/) != null; });
482         games.sort(function(a, b) {
483                 if (a.streamday !== b.streamday) {
484                         return a.streamday - b.streamday;
485                 }
486
487                 let m1 = a.streamtime.match(/([0-9]+):([0-9]+)/);
488                 let m2 = b.streamtime.match(/([0-9]+):([0-9]+)/);
489                 return (m1[1] * 60 + m1[2]) - (m2[1] * 60 + m2[2]);
490         });
491         return games;
492 }
493
494 function find_game_start_idx(games) {
495         // Pick out a reasonable place to start the list. We'll show the last
496         // completed match and start from there.
497         let start_idx = games.length - 1;
498         for (let i = 0; i < games.length; ++i) {
499                 if (isNaN(games[i].score1) || isNaN(games[i].score2) &&
500                     games[i].score1 === games[i].score2) {
501                         start_idx = i;
502                         break;
503                 }
504         }
505         if (start_idx > 0) start_idx--;
506         if (games.length >= max_list_len) {
507                 start_idx = Math.min(start_idx, games.length - max_list_len);
508         }
509         return start_idx;
510 }
511
512 function find_num_pages(games) {
513         games = sort_game_list(games);
514         let start_idx = find_game_start_idx(games);
515         return Math.ceil((games.length - start_idx) / max_list_len);
516 }
517
518 function display_stream_schedule_parsed(teams, games, page) {
519         document.getElementById('entire-bug').style.display = 'none';
520
521         games = sort_game_list(games);
522         let start_idx = find_game_start_idx(games);
523
524         start_idx += page * max_list_len;
525         if (start_idx >= games.length) {
526                 // Error.
527                 return;
528         }
529
530         let days = ["Sunday", "Monday", "Tuesday", "Wednesday", "Thursday", "Friday", "Saturday", "Sunday"];
531         let shortdays = ["Sun", "Mon", "Tue", "Wed", "Thu", "Fri", "Sat", "Sun"];
532         let today = days[(new Date).getDay()];
533
534         let covered_days = [];
535         let row_num = 0;
536         for (let i = start_idx; i < games.length && row_num++ < max_list_len; ++i) {
537                 if (i == start_idx || games[i].streamday != games[i - 1].streamday) {
538                         covered_days.push(days[games[i].streamday]);
539                 }
540         }
541         
542         let carousel = document.getElementById('carousel');
543         clear_carousel(carousel);
544         addheading(carousel, 3, "Stream schedule, " + ultimateconfig['tournament_title'] + "<br />" + covered_days.join('/') + " (all times CET)");
545
546         let teams_to_idx = make_teams_to_idx(teams);
547         row_num = 0;
548         for (let i = start_idx; i < games.length && row_num < max_list_len; ++i) {
549                 let tr = document.createElement("tr");
550
551                 let name1 = teams[teams_to_idx[games[i].name1]].mediumname;
552                 let name2 = teams[teams_to_idx[games[i].name2]].mediumname;
553
554                 addtd(tr, "matchup", name1 + "–" + name2);
555                 addtd(tr, "group", games[i].group_name);
556
557                 if (!isNaN(games[i].score1) && !isNaN(games[i].score2) &&
558                     games[i].score1 !== games[i].score2) {
559                         addtd(tr, "streamtime", games[i].score1 + "–" + games[i].score2);
560                 } else {
561                         let streamtime = games[i].streamtime;
562                         let streamday = days[games[i].streamday];
563                         if (streamday !== today) {
564                                 streamtime = shortdays[games[i].streamday] + " " + streamtime;
565                         }
566                         addth(tr, "streamtime", streamtime);
567                 }
568
569                 row_num++;
570                 carousel.appendChild(tr);
571         }
572
573         fade_in_rows(carousel);
574
575         carousel.style.display = 'table';
576 };
577
578 function get_group(group_name, cb)
579 {
580         let req = new XMLHttpRequest();
581         req.onload = function(e) {
582                 cb(JSON.parse(req.responseText), group_name);
583         };
584         req.open('GET', 'https://sheets.googleapis.com/v4/spreadsheets/' + ultimateconfig['score_sheet_id'] + '/values/\'' + group_name + '\'!A1:J50?key=' + ultimateconfig['api_key']);
585         req.send();
586 }
587
588 function showgroup(group_name)
589 {
590         get_group(group_name, function(response, group_name) {
591                 let teams = parse_teams_from_spreadsheet(response);
592                 let games = parse_games_from_spreadsheet(response, group_name, false);
593                 display_group_parsed(teams, games, group_name);
594         });
595         publish_group_rank(group_name);  // Update the spreadsheet in the background.
596 }
597
598
599 function showgroup_from_state()
600 {
601         showgroup(state['group_name']);
602 }
603
604 let carousel_timeout = null;
605
606 function hidetable()
607 {
608         fade_out_rows(document.getElementById('carousel'));
609 };
610
611 function showschedule(page)
612 {
613         let teams = [];
614         let games = [];
615         let num_left = 3;
616
617         let cb = function(response, group_name) {
618                 teams = teams.concat(parse_teams_from_spreadsheet(response));
619                 games = games.concat(parse_games_from_spreadsheet(response, group_name, true));
620                 if (--num_left == 0) {
621                         display_stream_schedule_parsed(teams, games, 0);
622                 }
623         };
624
625         get_group('Group A', cb);
626         get_group('Group B', cb);
627         get_group('Playoffs', cb);
628 };
629
630 function do_series(series)
631 {
632         do_series_internal(series, 0);
633 };
634
635 function do_series_internal(series, idx)
636 {
637         (series[idx][1])();
638         if (idx + 1 < series.length) {
639                 carousel_timeout = setTimeout(function() { do_series_internal(series, idx + 1); }, series[idx][0]);
640         }
641 };
642
643 function showcarousel()
644 {
645         let teams_per_group = [];
646         let games_per_group = [];
647         let combined_teams = [];
648         let combined_games = [];
649         let num_left = 3;
650
651         let cb = function(response, group_name) {
652                 let teams = parse_teams_from_spreadsheet(response);
653                 let games = parse_games_from_spreadsheet(response, group_name, true);
654                 teams_per_group[group_name] = teams;
655                 games_per_group[group_name] = games;
656
657                 combined_teams = combined_teams.concat(teams);
658                 combined_games = combined_games.concat(games);
659                 if (--num_left == 0) {
660                         let series = [
661                                 [ 13000, function() { display_group_parsed(teams_per_group['Group A'], games_per_group['Group A'], 'Group A'); } ],
662                                 [ 2000, function() { hidetable(); } ],
663                                 [ 13000, function() { display_group_parsed(teams_per_group['Group B'], games_per_group['Group B'], 'Group B'); } ],
664                                 [ 2000, function() { hidetable(); } ]
665                         ];
666                         let num_pages = find_num_pages(combined_games);
667                         for (let page = 0; page < num_pages; ++page) {
668                                 series.push([ 13000, function() { display_stream_schedule_parsed(combined_teams, combined_games, page); } ]);
669                                 series.push([ 2000, function() { hidetable(); } ]);
670                         }
671
672                         do_series(series);
673                 }
674         };
675
676         get_group('Group A', cb);
677         get_group('Group B', cb);
678         get_group('Playoffs', cb);
679 };
680
681 function stopcarousel()
682 {
683         if (carousel_timeout !== null) {
684                 hidetable();
685                 clearTimeout(carousel_timeout);
686                 carousel_timeout = null;
687         }
688 };
689
690 function hidescorebug()
691 {
692         document.getElementById('entire-bug').style.display = 'none';
693 }
694
695 function showscorebug()
696 {
697         document.getElementById('entire-bug').style.display = null;
698 }
699
700 function showmatch2()
701 {
702         let css = "-webkit-animation: fade-in 1.0s ease; -webkit-animation-fill-mode: both;";
703         document.getElementById('scorebug2').style = css;
704         document.getElementById('clockbug2').style = css;
705 }
706
707 function hidematch2()
708 {
709         let css = "-webkit-animation: fade-out 1.0s ease; -webkit-animation-fill-mode: both;";
710         document.getElementById('scorebug2').style = css;
711         document.getElementById('clockbug2').style = css;
712 }