2 addheading = function(carousel, colspan, content)
4 var thead = document.createElement("thead");
5 var tr = document.createElement("tr");
6 var th = document.createElement("th");
7 th.innerHTML = content;
8 th.setAttribute("colspan", colspan);
10 thead.appendChild(tr);
11 carousel.appendChild(thead);
13 addtd = function(tr, className, content) {
14 var td = document.createElement("td");
15 td.appendChild(document.createTextNode(content));
16 td.className = className;
19 addth = function(tr, className, content) {
20 var th = document.createElement("th");
21 th.appendChild(document.createTextNode(content));
22 th.className = className;
26 subrank_partitions = function(games, parts, start_rank, tiebreakers) {
28 for (var i = 0; i < parts.length; ++i) {
29 var part = rank(games, parts[i], start_rank, tiebreakers);
30 for (var j = 0; j < part.length; ++j) {
33 start_rank += part.length;
38 partition = function(teams, compare)
43 var curr_part = [teams[0]];
44 for (var i = 1; i < teams.length; ++i) {
45 if (compare(teams[i], curr_part[0]) != 0) {
46 parts.push(curr_part);
49 curr_part.push(teams[i]);
51 if (curr_part.length != 0) {
52 parts.push(curr_part);
57 explain_tiebreaker = function(parts, rule_name)
60 for (var i = 0; i < parts.length; ++i) {
61 result.push(parts[i].map(function(x) { return x.shortname; }).join("/"));
63 return result.join(" > ") + " (" + rule_name + ")";
66 make_teams_to_idx = function(teams)
68 var teams_to_idx = [];
69 for (var i = 0; i < teams.length; i++) {
70 teams_to_idx[teams[i].name] = i;
75 partition_by_beat = function(games, teams)
77 // Head-to-head score by way of components. First construct the beat matrix.
79 var beat = new Array(n);
80 var teams_to_idx = make_teams_to_idx(teams);
81 for (var i = 0; i < n; i++) {
82 beat[i] = new Array(n);
83 for (var j = 0; j < n; j++) {
87 for (i = 0; i < games.length; ++i) {
88 var idx1 = teams_to_idx[games[i].name1];
89 var idx2 = teams_to_idx[games[i].name2];
90 if (idx1 !== undefined && idx2 !== undefined) {
91 if (games[i].score1 > games[i].score2) {
94 if (games[i].score1 < games[i].score2) {
99 // Floyd-Warshall for transitive closure.
100 for (var k = 0; k < n; ++k) {
101 for (var i = 0; i < n; ++i) {
102 for (var j = 0; j < n; ++j) {
103 if (beat[i][k] && beat[k][j]) {
110 // See if we can find any team that is comparable to all others.
111 for (var pivot_idx = 0; pivot_idx < n; pivot_idx++) {
112 var incomparable = false;
113 for (var i = 0; i < n; ++i) {
114 if (i != pivot_idx && beat[pivot_idx][i] == 0 && beat[i][pivot_idx] == 0) {
120 // Split the teams into three partitions:
121 var better_than_pivot = [], equal = [], worse_than_pivot = [];
122 for (var i = 0; i < n; ++i) {
123 var we_beat = (beat[pivot_idx][i] == 1);
124 var they_beat = (beat[i][pivot_idx] == 1);
125 if ((i == pivot_idx) || (we_beat && they_beat)) {
126 equal.push(teams[i]);
127 } else if (we_beat && !they_beat) {
128 worse_than_pivot.push(teams[i]);
129 } else if (they_beat && !we_beat) {
130 better_than_pivot.push(teams[i]);
132 console.log("this shouldn't happen");
136 if (better_than_pivot.length > 0) {
137 result = partition_by_beat(games, better_than_pivot);
139 result.push(equal); // Obviously can't be partitioned further.
140 if (worse_than_pivot.length > 0) {
141 result = result.concat(partition_by_beat(games, worse_than_pivot));
147 // No usable pivot was found, so the graph is inherently
148 // disconnected, and we cannot partition it.
152 // Takes in an array, gives every element a rank starting with 1, and returns.
153 rank = function(games, teams, start_rank, tiebreakers) {
154 if (teams.length <= 1) {
155 // Only one team, so trivial.
156 teams[0].rank = start_rank;
160 // Rule #0: Partition the teams by score.
161 var score_parts = partition(teams, function(a, b) { return b.pts - a.pts });
162 if (score_parts.length > 1) {
163 return subrank_partitions(games, score_parts, start_rank, tiebreakers);
166 // Rule #1: Head-to-head wins.
167 var beat_parts = partition_by_beat(games, teams);
168 if (beat_parts.length > 1) {
169 tiebreakers.push(explain_tiebreaker(beat_parts, 'head-to-head'));
170 return subrank_partitions(games, beat_parts, start_rank, tiebreakers);
173 // Rule #2: Number of games played (fewer is better).
174 // Actually the rule says “fewest losses”, but fewer games is equivalent
175 // as long as teams have the same amount of points and ties don't exist.
176 var nplayed_parts = partition(teams, function(a, b) { return a.nplayed - b.nplayed });
177 if (nplayed_parts.length > 1) {
178 tiebreakers.push(explain_tiebreaker(nplayed_parts, 'fewer losses'));
179 return subrank_partitions(games, nplayed_parts, start_rank, tiebreakers);
182 // Rule #3: Head-to-head goal difference.
183 var teams_to_idx = make_teams_to_idx(teams);
184 for (var i = 0; i < teams.length; i++) {
186 teams[i].h2h_goals = 0;
188 for (i = 0; i < games.length; ++i) {
189 var idx1 = teams_to_idx[games[i].name1];
190 var idx2 = teams_to_idx[games[i].name2];
191 if (idx1 !== undefined && idx2 !== undefined) {
192 teams[idx1].h2h_gd += games[i].score1;
193 teams[idx1].h2h_gd -= games[i].score2;
194 teams[idx2].h2h_gd += games[i].score2;
195 teams[idx2].h2h_gd -= games[i].score1;
197 teams[idx1].h2h_goals += games[i].score1;
198 teams[idx2].h2h_goals += games[i].score2;
201 var h2h_gd_parts = partition(teams, function(a, b) { return b.h2h_gd - a.h2h_gd });
202 if (h2h_gd_parts.length > 1) {
203 tiebreakers.push(explain_tiebreaker(h2h_gd_parts, 'head-to-head goal difference'));
204 return subrank_partitions(games, h2h_gd_parts, start_rank, tiebreakers);
207 // Rule #4: Global goal difference. (Well, not strictly, but good enough.)
208 var gd_parts = partition(teams, function(a, b) { return b.gd - a.gd });
209 if (gd_parts.length > 1) {
210 tiebreakers.push(explain_tiebreaker(gd_parts, 'overall goal difference'));
211 return subrank_partitions(games, gd_parts, start_rank, tiebreakers);
214 // Rule #5: Head-to-head scored goals.
215 var h2h_goals_parts = partition(teams, function(a, b) { return b.h2h_goals - a.h2h_goals });
216 if (h2h_goals_parts.length > 1) {
217 tiebreakers.push(explain_tiebreaker(h2h_goals_parts, 'head-to-head scored goals'));
218 return subrank_partitions(games, h2h_goals_parts, start_rank, tiebreakers);
221 // Rule #6: Overall scored goals. (Same caveat as #4.)
222 var goals_parts = partition(teams, function(a, b) { return b.goals - a.goals });
223 if (goals_parts.length > 1) {
224 tiebreakers.push(explain_tiebreaker(goals_parts, 'scored goals'));
225 return subrank_partitions(games, goals_parts, start_rank, tiebreakers);
228 // OK, it's a tie. Give them all the same rank.
230 for (var i = 0; i < teams.length; ++i) {
231 result.push(teams[i]);
232 result[i].rank = start_rank;
237 parse_teams_from_spreadsheet = function(response) {
239 for (var i = 2; response.values[i].length >= 1; ++i) {
241 "name": response.values[i][0],
242 "mediumname": response.values[i][1],
243 "shortname": response.values[i][2],
253 parse_games_from_spreadsheet = function(response, include_unplayed) {
255 for (var i = 12; response.values[i] !== undefined && response.values[i].length >= 1; ++i) {
256 if ((response.values[i][2] && response.values[i][3]) || include_unplayed) {
258 "name1": response.values[i][0],
259 "name2": response.values[i][1],
260 "score1": parseInt(response.values[i][2]),
261 "score2": parseInt(response.values[i][3]),
262 "streamtime": response.values[i][7]
269 var req = new XMLHttpRequest();
270 req.onload = function(e) {
271 var response = JSON.parse(req.responseText);
272 var teams = parse_teams_from_spreadsheet(response);
273 var games = parse_games_from_spreadsheet(response, false);
275 var teams_to_idx = make_teams_to_idx(teams);
276 for (i = 0; i < games.length; ++i) {
277 var idx1 = teams_to_idx[games[i].name1];
278 var idx2 = teams_to_idx[games[i].name2];
279 if (games[i].score1 === undefined || games[i].score2 === undefined ||
280 idx1 === undefined || idx2 === undefined ||
281 games[i].score1 == games[i].score2) {
284 ++teams[idx1].nplayed;
285 ++teams[idx2].nplayed;
286 teams[idx1].goals += games[i].score1;
287 teams[idx2].goals += games[i].score2;
288 teams[idx1].gd += games[i].score1;
289 teams[idx2].gd += games[i].score2;
290 teams[idx1].gd -= games[i].score2;
291 teams[idx2].gd -= games[i].score1;
292 if (games[i].score1 > games[i].score2) {
293 teams[idx1].pts += 2;
295 teams[idx2].pts += 2;
300 teams = rank(games, teams, 1, tiebreakers);
302 var carousel = document.getElementById('carousel');
304 addheading(carousel, 5, "Current standings, TrønDisk 2017<br />Group A");
305 var tr = document.createElement("tr");
306 tr.className = "subfooter";
307 addth(tr, "rank", "");
308 addth(tr, "team", "");
309 addth(tr, "nplayed", "P");
310 addth(tr, "gd", "GD");
311 addth(tr, "pts", "Pts");
312 carousel.appendChild(tr);
315 for (i = 0; i < teams.length; ++i) {
316 var tr = document.createElement("tr");
318 addth(tr, "rank", teams[i].rank);
319 addtd(tr, "team", teams[i].name);
320 addtd(tr, "nplayed", teams[i].nplayed);
321 addtd(tr, "gd", teams[i].gd.toString().replace(/-/, '−'));
322 addtd(tr, "pts", teams[i].pts);
324 tr.style = "-webkit-animation: fade-in 1.0s ease; -webkit-animation-delay: " + 0.25 * (row_num++) + "s; -webkit-animation-fill-mode: both;";
325 carousel.appendChild(tr);
328 if (tiebreakers.length > 0) {
329 var tie_tr = document.createElement("tr");
330 tie_tr.className = "footer";
331 tie_tr.style = "-webkit-animation: fade-in 2.0s ease; -webkit-animation-delay: " + 0.25 * (row_num++) + "s; -webkit-animation-fill-mode: both;";
332 var td = document.createElement("td");
333 td.appendChild(document.createTextNode("Tiebreaks applied: " + tiebreakers.join(', ')));
334 td.setAttribute("colspan", "5");
335 tie_tr.appendChild(td);
336 carousel.appendChild(tie_tr);
339 var footer_tr = document.createElement("tr");
340 footer_tr.className = "footer";
341 footer_tr.style = "-webkit-animation: fade-in 2.0s ease; -webkit-animation-delay: " + 0.25 * (row_num++) + "s; -webkit-animation-fill-mode: both;";
342 var td = document.createElement("td");
343 td.appendChild(document.createTextNode("www.trondheimfrisbeeklubb.no | #trøndisk"));
344 td.setAttribute("colspan", "5");
345 footer_tr.appendChild(td);
346 carousel.appendChild(footer_tr);
348 carousel.style.display = 'table';
350 req.open('GET', 'https://sheets.googleapis.com/v4/spreadsheets/1CwRHQtpokVMGTPJu2FYYG-6rnG7OfISIcEHwBfXh-Y4/values/A1:H25?key=AIzaSyAuP9yQn8g0bSay6r_RpGtpFeIbwprH1TU');
356 var req2 = new XMLHttpRequest();
357 req2.onload = function(e) {
358 var response = JSON.parse(req.responseText);
359 var teams = parse_teams_from_spreadsheet(response);
360 var teams_to_idx = make_teams_to_idx(teams);
361 var games = parse_games_from_spreadsheet(response, true);
362 games = games.filter(function(game) { return game.streamtime !== undefined && game.streamtime.match(/[0-9]+:[0-9]+/) != null; });
363 games.sort(function(a, b) {
364 var m1 = a.streamtime.match(/([0-9]+):([0-9]+)/);
365 var m2 = b.streamtime.match(/([0-9]+):([0-9]+)/);
366 return (m1[1] * 60 + m1[2]) - (m2[1] * 60 + m2[2]);
369 // Pick out a reasonable place to start the list. We'll show the last
370 // completed match and start from there.
371 var max_list_len = 7;
372 var start_idx = games.length - 1;
373 for (var i = 0; i < games.length; ++i) {
374 if (isNaN(games[i].score1) || isNaN(games[i].score2) &&
375 games[i].score1 === games[i].score2) {
380 if (start_idx > 0) start_idx--;
381 if (games.length >= max_list_len) {
382 start_idx = Math.min(start_idx, games.length - max_list_len);
385 var carousel = document.getElementById('carousel');
386 addheading(carousel, 3, "Stream schedule, TrønDisk 2017<br />Saturday");
389 for (i = start_idx; i < games.length && row_num < max_list_len; ++i) {
390 var tr = document.createElement("tr");
392 var name1 = teams[teams_to_idx[games[i].name1]].mediumname;
393 var name2 = teams[teams_to_idx[games[i].name2]].mediumname;
395 addtd(tr, "matchup", name1 + "–" + name2);
396 addtd(tr, "group", "Group A");
398 if (!isNaN(games[i].score1) && !isNaN(games[i].score2) &&
399 games[i].score1 !== games[i].score2) {
400 addtd(tr, "streamtime", games[i].score1 + "–" + games[i].score2);
402 addth(tr, "streamtime", games[i].streamtime);
405 tr.style = "-webkit-animation: fade-in 1.0s ease; -webkit-animation-delay: " + 0.25 * (row_num++) + "s; -webkit-animation-fill-mode: both;";
406 carousel.appendChild(tr);
409 req2.open('GET', 'https://sheets.googleapis.com/v4/spreadsheets/1CwRHQtpokVMGTPJu2FYYG-6rnG7OfISIcEHwBfXh-Y4/values/A1:H25?key=AIzaSyAuP9yQn8g0bSay6r_RpGtpFeIbwprH1TU');