30:T4a8,breakdown = { let results = get_tourney_stats(men_or_women); let team_cnt = d3.sum(results, (o) => o.teams.length); let tourney_cnt = d3.sum(results, (o) => o.n * o.teams.length); // display(html`

A total of ${team_cnt} different teams have won the ${tourney_cnt} different ${men_or_women}'s NCAA basketball tournaments. The breakdown looks like so:

`) let table = d3 .create("table") .style("margin-left", "auto") .style("margin-right", "auto"); let head = table.append("tr").style("white-space", "nowrap"); head.append("th").text("Championship Count"); head.append("th").text("Teams"); results.forEach(function (o) { let tr = table.append("tr").style("font-size", `${12 * Math.sqrt(o.n)}px`); tr.append("td").style("text-align", "center").text(`${o.n}`); tr.append("td").text(o.teams.join(", ")); }); let div = d3.create("div"); div.append( () => html`

A total of ${team_cnt} different teams have won the ${tourney_cnt} different ${men_or_women}'s NCAA basketball tournaments since ${results.year_one}. The breakdown looks like so:

` ); div.append(() => table.node()); return div.node(); return table.node(); }31:T7e6,function make_brackets() { let div = d3 .create("div") .style("width", div_width + "px") .style("height", div_height + "px") .style("position", "relative"); let svg = div .append("svg") .attr("width", div_width) .attr("height", div_height) .style("width", div_width + "px") .style("height", div_height + "px") .style("position", "absolute"); // Draw connectors on the SVG background svg .selectAll("path.link") .data(tourney_tree.links()) .join("path") .attr("class", function (d) { let label = "link"; if ( d.target.data.WTeam && d.target.data.LTeam && d.source.data.WTeam && d.source.data.LTeam && (d.target.data.WTeam.TeamID == d.source.data.WTeam.TeamID || d.target.data.WTeam.TeamID == d.source.data.LTeam.TeamID) ) { label = label + " Team" + d.target.data.WTeam.TeamID; } return label; }) .attr("stroke", "currentColor") .attr("stroke-width", 1) .attr("fill", "none") .attr("d", connector); div .selectAll("div.game") .data(tourney_tree.descendants()) .enter() .append((d) => game_container(d)); // Highlight a team's path through the tournament // on mouseenter. div .selectAll(".team") .on("mouseenter", function () { let class_label = d3.select(this).attr("class").split(" ")[2]; div .selectAll(".team." + class_label) .style("background-color", "#9999ee"); div.selectAll(".game." + class_label).style("border", "solid 3px black"); svg.selectAll(".link." + class_label).attr("stroke-width", 3); }) .on("mouseleave", function () { let class_label = d3.select(this).attr("class").split(" ")[2]; div.selectAll(".team." + class_label).style("background-color", null); div.selectAll(".game." + class_label).style("border", "solid 1px black"); svg.selectAll(".link." + class_label).attr("stroke-width", 1); }); return div.node(); }32:Taad,function game_container(game) { let top_team, bot_team; if (game.data.WTeam) { if (game.data.WTeam.pos == "top") { top_team = game.data.WTeam; } else if (game.data.WTeam.pos == "bot") { bot_team = game.data.WTeam; } } if (game.data.LTeam) { if (game.data.LTeam.pos == "top") { top_team = game.data.LTeam; } else if (game.data.LTeam.pos == "bot") { bot_team = game.data.LTeam; } } let div = d3 .create("div") .style("width", function () { if (game.data.round == 6) { return 1.4 * team_width + "px"; } else { return team_width + "px"; } }) .style("height", function () { if (game.data.round == 6) { return 1.4 * game_height + "px"; } else { return game_height + "px"; } }) .style("left", function () { if (game.data.round == 6) { return (game.x2 - 0.2 * team_width).toString() + "px"; } else { return game.x2 + "px"; } }) .style("top", function () { if (game.data.round == 6) { return (game.y2 - 0.2 * game_height).toString() + "px"; } else { return game.y2 + "px"; } }) .style("border", "solid 0.5px currentColor") .style("position", "absolute"); // Check for upsets to highlight if (game.data.WTeam && game.data.LTeam && game.data.WTeam.win) { if (game.data.WTeam.seed - game.data.LTeam.seed > 4) { div.append(() => team_container(top_team, game.data.round, "upset")); div.append(() => team_container(bot_team, game.data.round, "upset")); } else if (game.data.round == 6) { if (game.data.WTeam.pos == "top") { div.append(() => team_container(top_team, game.data.round, "champion")); div.append(() => team_container(bot_team, game.data.round, "bot_team")); } else { div.append(() => team_container(top_team, game.data.round, "top_team")); div.append(() => team_container(bot_team, game.data.round, "champion")); } } else { div.append(() => team_container(top_team, game.data.round, "top_team")); div.append(() => team_container(bot_team, game.data.round, "bot_team")); } } else { div.append(() => team_container(top_team, game.data.round, "top_team")); div.append(() => team_container(bot_team, game.data.round, "bot_team")); } // cmd-click on an unplayed game to copy a result template to update the result file div.on("click", function (evt) { if (evt.metaKey) { let result_text = `2024,,${game.data.WTeam.TeamID},WS,${game.data.LTeam.TeamID},LS,, ${game.data.WTeam.TeamName}, ${game.data.LTeam.TeamName}`; pbcopy(result_text); } }); return div.node(); }33:T5a8,// Each game_container contains two team_containers // They're displayed slightly differently depending on // round and whether they're on the top or bottom (tb). function team_container(team, round, tb) { let div = d3 .create("div") .attr("class", function (d) { let label = "team " + tb + " "; if (team && team.TeamID) { label = label + "Team" + team.TeamID; } if (round == 6) { label = label + " championship"; } return label; }) // .style("font", round < 6 ? "14px sans-serif" : "16px sans-serif"); // Round 1 games display the seed and might have a play-in to highlight. if (round == 1) { let seed_span = div.append("span").text(team.seed + " "); if (team.playin) { seed_span.style("color", "blue"); let title = "Play-in info
"; title = title + `${team.TeamName}: ${team.playin.score}
`; title = title + `${team.playin.playin_opponent_name}: ${team.playin.playin_opponent_score}`; seed_span.attr("title", title); tippy(seed_span.node()); } } // Add name and score let team_display; if (team && team.TeamNames && team.score == 0) { team_display = team.TeamNames; } else if (team) { team_display = team.TeamName; } div.append("span").text(team_display); if (team && team.score) { div.append("span").attr("class", "score").text(team.score); } return div.node(); }34:T72b,function connector(link) { if (link.target.data.round >= 2) { let x1 = link.source.x2; let y1 = link.source.y2; let x2 = link.target.x2; let y2 = link.target.y2; let xx1, yy1, xx2, yy2; let path; // We can tell whether we're linking up or down by // comparing expected seeds. let [seed1, seed2] = link.target.data.expected_seeds; // Upper links if (seed1 < seed2) { // Left half of bracket if (link.target.data.region == 'W' || link.target.data.region == 'Y') { xx1 = x1 + team_width / 2; yy1 = y1; xx2 = x2 + team_width; yy2 = y2 + game_height / 2; path = [[xx1, yy1], [xx1, yy2], [xx2, yy2]]; return d3.line()(path); } // Right half of bracket else if ( link.target.data.region == 'X' || link.target.data.region == 'Z' ) { xx1 = x1 + team_width / 2; yy1 = y1; xx2 = x2; yy2 = y2 + game_height / 2; path = [[xx1, yy1], [xx1, yy2], [xx2, yy2]]; return d3.line()(path); } } // Lower links else { // Left half of bracket if (link.target.data.region == 'W' || link.target.data.region == 'Y') { xx1 = x1 + team_width / 2; yy1 = y1 + game_height; xx2 = x2 + team_width; yy2 = y2 + game_height / 2; path = [[xx1, yy1], [xx1, yy2], [xx2, yy2]]; return d3.line()(path); } // Right half of bracket else if ( link.target.data.region == 'X' || link.target.data.region == 'Z' ) { xx1 = x1 + team_width / 2; yy1 = y1 + game_height; xx2 = x2; yy2 = y2 + game_height / 2; path = [[xx1, yy1], [xx1, yy2], [xx2, yy2]]; return d3.line()(path); } } } else { return null; } }35:T779,function horizontal_rescaler(d) { let region = d.data.region; let scaler; let s = 3; // A small amount to shift round 2 games // Upper right if (region == 'X' || region == 'WX') { if (d.data.round == 2) { scaler = d3 .scaleLinear() .domain([0, div_width]) .range([ 0.5 * div_width - 1.5 * team_width - s, div_width - team_width - s ]); } else { scaler = d3 .scaleLinear() .domain([0, div_width]) .range([0.5 * div_width - 1.5 * team_width, div_width - team_width]); } } // Upper left else if (region == 'W') { if (d.data.round == 2) { scaler = d3 .scaleLinear() .domain([0, div_width]) .range([0.5 * (div_width + team_width) + s, s]); } else { scaler = d3 .scaleLinear() .domain([0, div_width]) .range([0.5 * (div_width + team_width), 0]); } } // Lower left else if (region == 'Y' || region == 'YZ') { if (d.data.round == 2) { scaler = d3 .scaleLinear() .domain([0, div_width]) .range([0.5 * (div_width + team_width) + s, s]); } else { scaler = d3 .scaleLinear() .domain([0, div_width]) .range([0.5 * (div_width + team_width), 0]); } } // Lower right else if (region == 'Z') { if (d.data.round == 2) { scaler = d3 .scaleLinear() .domain([0, div_width]) .range([ 0.5 * div_width - 1.5 * team_width - s, div_width - team_width - s ]); } else { scaler = d3 .scaleLinear() .domain([0, div_width]) .range([0.5 * div_width - 1.5 * team_width, div_width - team_width]); } } else if (region == 'CH') scaler = d3 .scaleLinear() .domain([0, div_width]) .range([0.5 * (div_width - team_width), 0]); return scaler(d.y); }36:T477,function vertical_rescaler(d) { let region = d.data.region; // Upper left if (region == 'W') { let scaler = d3 .scaleLinear() .domain([-0.25 * div_height, 0.25 * div_height]) .range([div_height - game_height / 2, -game_height / 2]); return scaler(d.x); } // Upper right else if (region == 'X') { let scaler = d3 .scaleLinear() .domain([0, 0.5 * div_height]) .range([div_height - game_height / 2, -game_height / 2]); return scaler(d.x); } // Lower left else if (region == 'Y') { let scaler = d3 .scaleLinear() .domain([div_height * 0.5, div_height]) .range([div_height - game_height / 2, -game_height / 2]); return scaler(d.x); } // Lower right else if (region == 'Z') { let scaler = d3 .scaleLinear() .domain([div_height * 0.75, 1.25 * div_height]) .range([div_height - game_height / 2, -game_height / 2]); return scaler(d.x); } else if (region == 'WX') { return 0.4 * div_height; } else if (region == 'YZ') { return 0.6 * div_height; } else if (region == 'CH') { return 0.5 * div_height; } }37:Te64,tourney = { // Start with a basic nested JSON tree down // to the regional finals. let tourney = { region: "CH", round: 6, expected_seeds: [1, 1], children: [ { region: "WX", round: 5, expected_seeds: [1, 1], children: [ { region: "W", round: 4, expected_seeds: [1, 2] }, { region: "X", round: 4, expected_seeds: [1, 2] } ] }, { region: "YZ", round: 5, expected_seeds: [1, 1], children: [ { region: "Y", round: 4, expected_seeds: [1, 2] }, { region: "Z", round: 4, expected_seeds: [1, 2] } ] } ] }; // Now we'll just use a basic tree-traversal technique // to continue down to round 1 let stack = [ tourney.children[0].children[0], tourney.children[0].children[1], tourney.children[1].children[0], tourney.children[1].children[1] ]; while (stack.length > 0) { let node = stack.pop(); let high_seed = node.expected_seeds[0]; let new_low_seed = 2 ** (5 - node.round + 1) - high_seed + 1; let child0 = { region: node.region, expected_seeds: [high_seed, new_low_seed], round: node.round - 1 }; let low_seed = node.expected_seeds[1]; let lower_seed = 2 ** (5 - node.round + 1) - low_seed + 1; let child1 = { region: node.region, expected_seeds: [lower_seed, low_seed], round: node.round - 1 }; node.children = [child0, child1]; // If round > 2, then we'll just push both // new empty nodes to the stack. We don't yet // know whose playing in those games. if (node.round > 2) { stack.push(child0); stack.push(child1); } // If round == 2, then the children will be in round 1 // so we can look up the game result. else { Object.assign(child0, round1_info(child0)); Object.assign(child1, round1_info(child1)); } } // At this point, the tree structure of the tournament is // constructed but we need to re-traverse to get game results. stack = [tourney]; while (stack.length > 0) { let node = stack.pop(); if (node.visits == 1) { node.visits = 2; } else { node.visits = 1; } let [child0, child1] = node.children; let team0, team1; if (child0.WTeam && child0.WTeam.win) { team0 = Object.assign({}, child0.WTeam); delete team0.win; delete team0.score; team0.pos = get_pos(team0.seed, node.round, team0.slot[0]); node.WTeam = team0; // Arbitrary, for now } if (child1.WTeam && child1.WTeam.win) { team1 = Object.assign({}, child1.WTeam); delete team1.win; delete team1.score; team1.pos = get_pos(team1.seed, node.round, team1.slot[0]); node.LTeam = team1; // Arbitrary, for now } // If we have both teams, then we attempt to assess the victor if (team0 && team1) { let scores = get_scores(team0.TeamID, team1.TeamID); team0.score = scores[0]; team1.score = scores[1]; let wTeam, lTeam; if (team0.score > team1.score) { team0.win = true; node.WTeam = team0; node.LTeam = team1; } else if (team0.score < team1.score) { team1.win = true; node.WTeam = team1; node.LTeam = team0; } } if (node.visits == 1) { stack.push(node); if (node.round > 2) { stack.push(child0); stack.push(child1); } } } return tourney; }38:T968,// Look up a team based on its region and seed function get_team(region, expected_seed) { let slot, teamID, teamName, teamNames; let playin = false; if (expected_seed < 10) { slot = region + '0' + expected_seed.toString(); } else { slot = region + expected_seed.toString(); } let seed = this_years_seeds.map(d => d.Seed).indexOf(slot); if (seed > -1) { teamID = this_years_seeds[seed].TeamID; teamName = team_map.get(teamID); } // The data expresses round 1 seeds mostly just as you'd expect. // In the case of a play-in game, there's an 'a' or 'b' appended to // the two seeds you'd expect to find. Thus, if we didn't find the // seed above that means we've got a play-in game. We'll display // just the winner but include the results of the playin via a tooltip. else { let seeda = this_years_seeds.map(d => d.Seed).indexOf(slot + 'a'); let seedb = this_years_seeds.map(d => d.Seed).indexOf(slot + 'b'); if (seeda > -1) { let playin_opponentID, playin_opponent_name, playin_opponent_score, score; let teamIDa = this_years_seeds[seeda].TeamID; let teamNamea = team_map.get(teamIDa); let teamIDb = this_years_seeds[seedb].TeamID; let teamNameb = team_map.get(teamIDb); let scores = get_scores(teamIDa, teamIDb); if (scores[0] < scores[1]) { teamName = teamNameb; teamID = teamIDb; score = scores[1]; playin_opponentID = teamIDa; playin_opponent_name = teamNamea; playin_opponent_score = scores[0]; } else if (scores[0] > scores[1]) { teamName = teamNamea; teamID = teamIDa; score = scores[0]; playin_opponentID = teamIDb; playin_opponent_name = teamNameb; playin_opponent_score = scores[1]; } else { teamName = teamNamea; teamNames = teamNamea + '/' + teamNameb; score = 0; playin_opponent_name = teamNameb; playin_opponent_score = 0; playin_opponentID = teamIDb; } playin = { score: score, teamID: teamIDa, playin_opponentID: playin_opponentID, playin_opponent_name: playin_opponent_name, playin_opponent_score: playin_opponent_score }; } } return { TeamName: teamName, TeamNames: teamNames, TeamID: teamID, seed: expected_seed, slot: slot, playin: playin }; }39:T423,function get_tourney_stats(men_or_women) { let results, team_map; if (men_or_women == "Men") { results = mresults; team_map = mteam_map; } else { results = wresults; team_map = wteam_map; } let year_one = d3.min(results, (o) => o.Season); let champions = d3 .rollups( results, function (this_years_results) { let max_day = d3.max(this_years_results, (o) => o.DayNum); let championship_game = this_years_results.find( (o) => o.DayNum == max_day ); let champion = get_winner(championship_game); return team_map.get(get_winner(championship_game)); }, (o) => o.Season ) .map((a) => a[1]); champions = d3 .groups(champions, (s) => s) .map((a) => ({ team: a[0], n: a[1].length })); champions = d3 .sort( d3.rollups( champions, (a) => a, (o) => o.n ), (a) => -a[0] ) .map(([n, T]) => ({ n, teams: d3.sort(T.map((o) => o.team)) })); champions.year_one = year_one; return champions; }3a:[{"id":"2343c34f71a68388b057661e45b8c52a60cd9ba1ea937ed01cdc62012d1549bce584e779f4cad676f990896b76cde74be2b379526eb37f6865ed50f2b9958fc0","href":"https://static.observableusercontent.com/files/2343c34f71a68388b057661e45b8c52a60cd9ba1ea937ed01cdc62012d1549bce584e779f4cad676f990896b76cde74be2b379526eb37f6865ed50f2b9958fc0","name":"WTeams.csv","type":"text/csv","lastModified":1583071172111.407,"size":5955},{"id":"3a201b34bbb660b5f9d2cebb59e2375710b6ba4cd3af9c621273809fa9ac258c916540505585a31cbaa87c644656c2778bf5ad0039974f15ca0e5d24a8c10007","href":"https://static.observableusercontent.com/files/3a201b34bbb660b5f9d2cebb59e2375710b6ba4cd3af9c621273809fa9ac258c916540505585a31cbaa87c644656c2778bf5ad0039974f15ca0e5d24a8c10007","name":"MTeams.csv","type":"text/csv","lastModified":1583071172111.407,"size":9676},{"id":"e61fea2d9d3a7fbd778cf9c85e8248417a8ad835ab2e453c43db4e7779a6b300b63e57309d0d31e66bd1bc0b1edb29f594cd16d2097b50ed97cec329cff42528","href":"https://static.observableusercontent.com/files/e61fea2d9d3a7fbd778cf9c85e8248417a8ad835ab2e453c43db4e7779a6b300b63e57309d0d31e66bd1bc0b1edb29f594cd16d2097b50ed97cec329cff42528","name":"MNCAATourneySeeds@4.csv","type":"text/csv","lastModified":1710790573775.625,"size":38514},{"id":"75be59f3b2ae0c01f610baf3d7f6b4452b2d485f48a0b1f180104d686cc28671f57c03b291150306c27fb438bfe7b98f29fd65e3c743963e9ad9087d5905fb97","href":"https://static.observableusercontent.com/files/75be59f3b2ae0c01f610baf3d7f6b4452b2d485f48a0b1f180104d686cc28671f57c03b291150306c27fb438bfe7b98f29fd65e3c743963e9ad9087d5905fb97","name":"MTeams@3.csv","type":"text/csv","lastModified":1710790609974.159,"size":9984},{"id":"e1758719090dc380fc1686628930c06e66146b71f36fc746be9a20ef2eff1b0182a2c01133644533019abfcf464903a726d885733e142482aa3e9bcbc824e126","href":"https://static.observableusercontent.com/files/e1758719090dc380fc1686628930c06e66146b71f36fc746be9a20ef2eff1b0182a2c01133644533019abfcf464903a726d885733e142482aa3e9bcbc824e126","name":"WNCAATourneySeeds@4.csv","type":"text/csv","lastModified":1710790717471.038,"size":25184},{"id":"c99de88182e024338fbffb1d829fd474910e93b106e06b00f63c774558e8154fc0d42169da7219411ba8a516939585519f772c708281fc7b4f121f43e7f75340","href":"https://static.observableusercontent.com/files/c99de88182e024338fbffb1d829fd474910e93b106e06b00f63c774558e8154fc0d42169da7219411ba8a516939585519f772c708281fc7b4f121f43e7f75340","name":"WTeams@2.csv","type":"text/csv","lastModified":1710790733586.452,"size":6153},{"id":"1bb7ffc23148b87d33700fc35b71cb4870572caf6b49ca59d1c2200462eeaf9af401b848c77d42f09570c560eda845207adf02b75adf9539e8fa6f02fee01e24","href":"https://static.observableusercontent.com/files/1bb7ffc23148b87d33700fc35b71cb4870572caf6b49ca59d1c2200462eeaf9af401b848c77d42f09570c560eda845207adf02b75adf9539e8fa6f02fee01e24","name":"MNCAATourneySeeds@1.csv","type":"text/csv","lastModified":1615927781527.148,"size":35430},{"id":"46a77a2e5b0296c915959288444f78fb84bc6a33588631bfa35e4e32afa5a65c8650b4c2ea5b8a8be373a5d47b8ed8d8a2324e2164a131e9d06c672ef0766c12","href":"https://static.observableusercontent.com/files/46a77a2e5b0296c915959288444f78fb84bc6a33588631bfa35e4e32afa5a65c8650b4c2ea5b8a8be373a5d47b8ed8d8a2324e2164a131e9d06c672ef0766c12","name":"WNCAATourneySeeds@5.csv","type":"text/csv","lastModified":1742185367314.153,"size":26212},{"id":"a74430db49de52b1ddb33bbd4c986be17e9a014e23c436818f40faf49780c907eb8e632ae8d228e957a576961040d16eafd5a6cfb03e92e8f7fac006ed27b51f","href":"https://static.observableusercontent.com/files/a74430db49de52b1ddb33bbd4c986be17e9a014e23c436818f40faf49780c907eb8e632ae8d228e957a576961040d16eafd5a6cfb03e92e8f7fac006ed27b51f","name":"MNCAATourneySeeds@5.csv","type":"text/csv","lastModified":1742185398466.36,"size":39542},{"id":"abd5e04991784520d74d75a2aa44df892ab377bd41281be893bc42094ae468030cdd785cb23e1a645a72f310a447319b970e2bed38eef8330c6f0cc401491977","href":"https://static.observableusercontent.com/files/abd5e04991784520d74d75a2aa44df892ab377bd41281be893bc42094ae468030cdd785cb23e1a645a72f310a447319b970e2bed38eef8330c6f0cc401491977","name":"MNCAATourneyCompactResults@36.csv","type":"text/csv","lastModified":1742185480716.164,"size":75699},{"id":"53486308548ceb3c840a48747696c518f8a881f1f7cd0d9570be246a6631254f41661ee453109627ec56ec4f2b54caa8ff6468b3547560cc0ef0ddf50e949f19","href":"https://static.observableusercontent.com/files/53486308548ceb3c840a48747696c518f8a881f1f7cd0d9570be246a6631254f41661ee453109627ec56ec4f2b54caa8ff6468b3547560cc0ef0ddf50e949f19","name":"MTeams@4.csv","type":"text/csv","lastModified":1742185520895.354,"size":10030},{"id":"abd5e04991784520d74d75a2aa44df892ab377bd41281be893bc42094ae468030cdd785cb23e1a645a72f310a447319b970e2bed38eef8330c6f0cc401491977","href":"https://static.observableusercontent.com/files/abd5e04991784520d74d75a2aa44df892ab377bd41281be893bc42094ae468030cdd785cb23e1a645a72f310a447319b970e2bed38eef8330c6f0cc401491977","name":"MNCAATourneyCompactResults@37.csv","type":"text/csv","lastModified":1742185732675.369,"size":75699},{"id":"53486308548ceb3c840a48747696c518f8a881f1f7cd0d9570be246a6631254f41661ee453109627ec56ec4f2b54caa8ff6468b3547560cc0ef0ddf50e949f19","href":"https://static.observableusercontent.com/files/53486308548ceb3c840a48747696c518f8a881f1f7cd0d9570be246a6631254f41661ee453109627ec56ec4f2b54caa8ff6468b3547560cc0ef0ddf50e949f19","name":"MTeams@5.csv","type":"text/csv","lastModified":1742185764382.518,"size":10030},{"id":"abd5e04991784520d74d75a2aa44df892ab377bd41281be893bc42094ae468030cdd785cb23e1a645a72f310a447319b970e2bed38eef8330c6f0cc401491977","href":"https://static.observableusercontent.com/files/abd5e04991784520d74d75a2aa44df892ab377bd41281be893bc42094ae468030cdd785cb23e1a645a72f310a447319b970e2bed38eef8330c6f0cc401491977","name":"MNCAATourneyCompactResults@38.csv","type":"text/csv","lastModified":1742185833401.694,"size":75699},{"id":"011d40bc9e8fe49f6ec48378ed1e2e10d392c3e1b5915da8c19cfc56058c7b99f3e149dd62a6689eabfbdeaca74d98d871244e7ab2327a8e4712a4d5bc6ccb08","href":"https://static.observableusercontent.com/files/011d40bc9e8fe49f6ec48378ed1e2e10d392c3e1b5915da8c19cfc56058c7b99f3e149dd62a6689eabfbdeaca74d98d871244e7ab2327a8e4712a4d5bc6ccb08","name":"WNCAATourneyCompactResults@16.csv","type":"text/csv","lastModified":1742186747685.5,"size":49594},{"id":"684bc6061be17a0de1155b51fff3b7c06b6761deb168edb8e849af2aeba29b1e4ab4a3833229cc8f0e2f2102c4b3a6265ab836556b2bed87720966cd07676778","href":"https://static.observableusercontent.com/files/684bc6061be17a0de1155b51fff3b7c06b6761deb168edb8e849af2aeba29b1e4ab4a3833229cc8f0e2f2102c4b3a6265ab836556b2bed87720966cd07676778","name":"MNCAATourneyCompactResults@31.csv","type":"text/csv","lastModified":1617708311157.614,"size":69381},{"id":"5865af0f7b972f7cfe7e1bd4f0340c558f29caad5374e5bcfdaea0002858cd383ad4e91bba7a53ee0f1f1a0bcc1d5e442d598c0e8dfb5d0b72e0c2512df3dd74","href":"https://static.observableusercontent.com/files/5865af0f7b972f7cfe7e1bd4f0340c558f29caad5374e5bcfdaea0002858cd383ad4e91bba7a53ee0f1f1a0bcc1d5e442d598c0e8dfb5d0b72e0c2512df3dd74","name":"WNCAATourneyCompactResults@13.csv","type":"text/csv","lastModified":1617708392348.272,"size":43245},{"id":"34e38a92ccddaac5f5adf1108b2f11083c1ff760493b92c7ac08dcad21efdb1ca55a1034cd42c0d306878223e8cc7e5482cd022ebc62820dffdd841a2ae64cea","href":"https://static.observableusercontent.com/files/34e38a92ccddaac5f5adf1108b2f11083c1ff760493b92c7ac08dcad21efdb1ca55a1034cd42c0d306878223e8cc7e5482cd022ebc62820dffdd841a2ae64cea","name":"WNCAATourneySeeds@1.csv","type":"text/csv","lastModified":1616042179595.449,"size":22100},{"id":"6005d12613ced9280e7ef27248521459089f313b5aeb4d9f0a9001cd07f7b88f3df237f08a8707ddffd4d08e1e944fee96a6276f2a3851364fcc5f4bffde17ca","href":"https://static.observableusercontent.com/files/6005d12613ced9280e7ef27248521459089f313b5aeb4d9f0a9001cd07f7b88f3df237f08a8707ddffd4d08e1e944fee96a6276f2a3851364fcc5f4bffde17ca","name":"MyMNCAATourneySeeds@1.csv","type":"text/csv","lastModified":1647220171798.269,"size":34035},{"id":"013750972bc4b6f4fecf1d61d6f9a46bedde7bc650d7263fd2179539affc8ffeae14eb315597c6c1dfe3844392c5df57cb339d5dc81e1316d8aabb0d0a392c40","href":"https://static.observableusercontent.com/files/013750972bc4b6f4fecf1d61d6f9a46bedde7bc650d7263fd2179539affc8ffeae14eb315597c6c1dfe3844392c5df57cb339d5dc81e1316d8aabb0d0a392c40","name":"WNCAATourneySeeds@2.csv","type":"text/csv","lastModified":1647371050957.696,"size":23128},{"id":"722e5559eb91e7200bd957dbc6ccf5278e4e7925b405a2aadf891ee0e6aaf378011b309405e0d2a2e401b5d9568ac338ae82237149a8d9c407295c1220ac3598","href":"https://static.observableusercontent.com/files/722e5559eb91e7200bd957dbc6ccf5278e4e7925b405a2aadf891ee0e6aaf378011b309405e0d2a2e401b5d9568ac338ae82237149a8d9c407295c1220ac3598","name":"MNCAATourneyCompactResults@34.csv","type":"text/csv","lastModified":1664717441409.603,"size":71056},{"id":"660393ffc0fdcf3bbc3d68144ed09dfc8aec9bf600baf65fd56067399eaa674b6af7f416f50ad4f2a52bfd7f7cf00f92a702a43496b72b8cfebf923840be309e","href":"https://static.observableusercontent.com/files/660393ffc0fdcf3bbc3d68144ed09dfc8aec9bf600baf65fd56067399eaa674b6af7f416f50ad4f2a52bfd7f7cf00f92a702a43496b72b8cfebf923840be309e","name":"WNCAATourneyCompactResults@14.csv","type":"text/csv","lastModified":1664717468021.662,"size":45237},{"id":"8b36a17f82035af05927a4adf186c3a857fb0b506074810e1cddd0ea2ef45f6518c3b738fa617e1b4d2ee847ec010ca3ceab00a7c20117d61d4213347b29e558","href":"https://static.observableusercontent.com/files/8b36a17f82035af05927a4adf186c3a857fb0b506074810e1cddd0ea2ef45f6518c3b738fa617e1b4d2ee847ec010ca3ceab00a7c20117d61d4213347b29e558","name":"WNCAATourneyCompactResults@15.csv","type":"text/csv","lastModified":1678757078838.546,"size":45572},{"id":"6fd7497d8926cdc89d983b9882ea0f747d7da5ca4cd105336d24ed983a8cba4b786930fa19f6f6473218608f3d1b74aebe35962166861694bacfde1f1b92fae6","href":"https://static.observableusercontent.com/files/6fd7497d8926cdc89d983b9882ea0f747d7da5ca4cd105336d24ed983a8cba4b786930fa19f6f6473218608f3d1b74aebe35962166861694bacfde1f1b92fae6","name":"MNCAATourneyCompactResults@35.csv","type":"text/csv","lastModified":1678754658050.863,"size":71674},{"id":"b8c6d3f74e0ce56056dff10fc0c791cfb81ed7000f84e67c54637e5532c303cb41a5bf8c68df5bcff9239d53d78d9c9ecf459cd9102c979491bfb60f48918107","href":"https://static.observableusercontent.com/files/b8c6d3f74e0ce56056dff10fc0c791cfb81ed7000f84e67c54637e5532c303cb41a5bf8c68df5bcff9239d53d78d9c9ecf459cd9102c979491bfb60f48918107","name":"MTeams@2.csv","type":"text/csv","lastModified":1678754676469.312,"size":9959},{"id":"3336f0a80c618a02870d9b3212e2ab84beca5b54a43647e1eb7472f439d632cf660e42142f8458de79c89e2753da06e18bfbd32e73ce28fcbbbf6811220eb4f7","href":"https://static.observableusercontent.com/files/3336f0a80c618a02870d9b3212e2ab84beca5b54a43647e1eb7472f439d632cf660e42142f8458de79c89e2753da06e18bfbd32e73ce28fcbbbf6811220eb4f7","name":"WNCAATourneySeeds@3.csv","type":"text/csv","lastModified":1678757100509.662,"size":24156},{"id":"e76ee076f4b8572118e196543b1fec714c4ac0f765a0a4a191c8d1dd1ca6638337a8645e2f2c63d610a33e6c29320a68e11b36d2c54f4b2b9bd2e17c30e5a0ca","href":"https://static.observableusercontent.com/files/e76ee076f4b8572118e196543b1fec714c4ac0f765a0a4a191c8d1dd1ca6638337a8645e2f2c63d610a33e6c29320a68e11b36d2c54f4b2b9bd2e17c30e5a0ca","name":"WTeams@1.csv","type":"text/csv","lastModified":1678757109811.787,"size":6138},{"id":"9d29fadac9c3f62adefc3d4668ec642e533b6fe07322fa4b2f44719ea344cc6da54e9ee97a4a738d50b366fc963829b85532bef19ce73436cab875ea6e42ddb9","href":"https://static.observableusercontent.com/files/9d29fadac9c3f62adefc3d4668ec642e533b6fe07322fa4b2f44719ea344cc6da54e9ee97a4a738d50b366fc963829b85532bef19ce73436cab875ea6e42ddb9","name":"MNCAATourneySeeds@3.csv","type":"text/csv","lastModified":1678754783752.396,"size":37486},{"id":"8322e8538790a9d62ecbbee06fcb107c7ea0ed64a9b5a273b0a2e6f4859986edd27652858689305c9f0e2758c2841ea6dc65ca5039d02dc5ba7c9cf6126a4814","href":"https://static.observableusercontent.com/files/8322e8538790a9d62ecbbee06fcb107c7ea0ed64a9b5a273b0a2e6f4859986edd27652858689305c9f0e2758c2841ea6dc65ca5039d02dc5ba7c9cf6126a4814","name":"MNCAATourneySeeds@6.csv","type":"text/csv","lastModified":1773673084811.329,"size":40570},{"id":"f1a81127abb399df37af6ae111ba3c0679397039ba45a946babe5f82b09348fda1aaf1ea915a67d3b8bf6607c6f7aa428ce6ebd76fc46db6b016842ca1d9d9db","href":"https://static.observableusercontent.com/files/f1a81127abb399df37af6ae111ba3c0679397039ba45a946babe5f82b09348fda1aaf1ea915a67d3b8bf6607c6f7aa428ce6ebd76fc46db6b016842ca1d9d9db","name":"WNCAATourneySeeds@6.csv","type":"text/csv","lastModified":1773673227207.398,"size":27240},{"id":"c4e035b5b45c3582ce4bac8c7292aa95fa215b95deb4d4fa92a5eca27e5c2312d0a6a9a246bd349fed73aa6c58abcee4ad42f45805b635ef4fe95ca507eea3ab","href":"https://static.observableusercontent.com/files/c4e035b5b45c3582ce4bac8c7292aa95fa215b95deb4d4fa92a5eca27e5c2312d0a6a9a246bd349fed73aa6c58abcee4ad42f45805b635ef4fe95ca507eea3ab","name":"WTeams@3.csv","type":"text/csv","lastModified":1773673246125.386,"size":6195},{"id":"f6d7ccfd9e708eff4f5248252c25c5db3f1f708c9d5d51499f1093333b61e44984cf8be3f2c037b880bb1094dafc3116860f70145296d03d05e988045849bdcc","href":"https://static.observableusercontent.com/files/f6d7ccfd9e708eff4f5248252c25c5db3f1f708c9d5d51499f1093333b61e44984cf8be3f2c037b880bb1094dafc3116860f70145296d03d05e988045849bdcc","name":"MTeams@6.csv","type":"text/csv","lastModified":1773673109667.589,"size":10056}] 2e:{"title":"NCAA Brackets","cells":[{"id":0,"value":"md`# NCAA Brackets`","pinned":false,"hidden":false,"mode":"ojs"},{"id":1749,"value":"topmatter = md`Browse all 61 NCAA basketball tournaments featuring 64 or more teams. That's\n\n * All men's tournaments since 1985 and\n * all women's tournaments since 1998.\n\nGames that are shaded red indicate upsets (where the victor was four or more seeds lower than their opponent) and blue seed numbers indicate play-in games.\n`","pinned":false,"hidden":false,"mode":"ojs"},{"id":1771,"value":"kaggle_comment = md`All the data comes from [Kaggle's March Machine Learning Mania competition](https://www.kaggle.com/competitions/march-machine-learning-mania-2024) for the Men's and Women's basketball tournaments. If you participate in those competitions, you can visualize your submission files using [this notebook](https://observablehq.com/@mcmcclur/visualize-your-kaggle-brackets-for-march-madness).\n`","pinned":false,"hidden":false,"mode":"ojs"},{"id":678,"value":"viewof men_or_women = Inputs.radio([\"Men\", \"Women\"], {\n label: md`**Gender:**`,\n value: \"Men\"\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":684,"value":"viewof year = {\n let years;\n if (men_or_women == \"Men\") {\n years = [2026, 2025, 2024, 2023, 2022, 2021].concat(\n d3.range(1985, 2020).reverse()\n );\n } else {\n years = [2026, 2025, 2024, 2023, 2022, 2021].concat(\n d3.range(1998, 2020).reverse()\n );\n }\n return Inputs.select(years, { label: md`**Year:**`, format: Math.round });\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":1548,"value":"brackets = make_brackets()","pinned":false,"hidden":false,"mode":"ojs"},{"id":2047,"value":"$30","pinned":false,"hidden":false,"mode":"ojs"},{"id":1551,"value":"md`## Code`","pinned":false,"hidden":false,"mode":"ojs"},{"id":1595,"value":"md`This main \\`make_brackets\\` function creates a \\`div\\` element, adds an absolutely positioned \\`svg\\` element on which we draw the connectors, then adds 63 absolutely positioned \\`div\\` elements to display the games.`","pinned":false,"hidden":false,"mode":"ojs"},{"id":926,"value":"$31","pinned":true,"hidden":false,"mode":"ojs"},{"id":1598,"value":"md`### Components`","pinned":false,"hidden":false,"mode":"ojs"},{"id":1589,"value":"$32","pinned":true,"hidden":false,"mode":"ojs"},{"id":1592,"value":"$33","pinned":true,"hidden":false,"mode":"ojs"},{"id":1345,"value":"$34","pinned":true,"hidden":false,"mode":"ojs"},{"id":1608,"value":"md`### Repositioning\n\nA bit more complicated than I might have liked. \\`d3.tree\\` applied to a \\`d3.hierarchy\\` returns a lovely top-to-bottom layout. A standard trick to reorient that horizontally is to swap x and y. In the setup here, we've got to rearrange the four regions so that one half the bracket occupies the left half of the \\`div\\` while the other half occupies the right. In addition, we want the top two regions to feed into the top national semi-final and similarly for the bottom.`","pinned":false,"hidden":false,"mode":"ojs"},{"id":1197,"value":"$35","pinned":true,"hidden":false,"mode":"ojs"},{"id":1194,"value":"$36","pinned":true,"hidden":false,"mode":"ojs"},{"id":1615,"value":"md`### Contructing the tournament`","pinned":false,"hidden":false,"mode":"ojs"},{"id":1975,"value":"tourney_tree.descendants()","pinned":true,"hidden":false,"mode":"ojs"},{"id":1339,"value":"// Apply d3.hierarchy and d3.tree\n// We can define display_map below to order the seeds in\n// round 1 however we want.\ntourney_tree = {\n let tree = d3.hierarchy(tourney);\n tree.sort(function(x, y) {\n return (\n display_map.get(y.data.expected_seeds[0]) -\n display_map.get(x.data.expected_seeds[0])\n );\n });\n d3\n .tree()\n .separation((a, b) => (a.parent == b.parent ? 1 : 1.1) / a.depth)\n .size([div_height, div_width])(tree);\n\n tree.descendants().forEach(function(v) {\n v.x2 = horizontal_rescaler(v);\n v.y2 = vertical_rescaler(v);\n });\n\n return tree;\n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":1619,"value":"md`Here's where we actually construct the tournament based on the input data.`","pinned":false,"hidden":false,"mode":"ojs"},{"id":6,"value":"$37","pinned":true,"hidden":false,"mode":"ojs"},{"id":458,"value":"// Here's how I'd like the seeds to be positioned in round 1\ndisplay_map = {\n let display_order = [1, 16, 9, 8, 5, 12, 13, 4, 3, 14, 11, 6, 7, 10, 15, 2];\n let display_map = new Map();\n display_order.forEach((d, i) => display_map.set(d, i + 1));\n return display_map;\n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":1628,"value":"// The info that we need for round 1\nfunction round1_info(o) {\n let team0 = get_team(o.region, o.expected_seeds[0]);\n let team1 = get_team(o.region, o.expected_seeds[1]);\n let scores = get_scores(team0.TeamID, team1.TeamID);\n team0.score = scores[0];\n team0.pos = get_pos(team0.seed, 1);\n team1.score = scores[1];\n team1.pos = get_pos(team1.seed, 1);\n\n let wTeam, lTeam;\n if (team0.score > team1.score) {\n wTeam = team0;\n wTeam.win = true;\n lTeam = team1;\n } else if (team0.score < team1.score) {\n wTeam = team1;\n wTeam.win = true;\n lTeam = team0;\n } else {\n wTeam = team0;\n wTeam.win = false;\n lTeam = team1;\n }\n return { WTeam: wTeam, LTeam: lTeam };\n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":1740,"value":"// Get the place of a team in a game_container on either the top or bottom\n// as a function of its seed and round.\nfunction get_pos(seed, round, region) {\n let s;\n if (typeof seed == 'number') {\n s = seed;\n } else {\n s = parseInt(seed.slice(1, 3));\n }\n if (round <= 4) {\n let n;\n if (s % 2 == 1) {\n n = (s - 1) / 2;\n } else {\n n = 16 - s / 2;\n }\n let bits = n.toString(2).padStart(4, '0');\n let bit = bits[round - 1];\n if (bit == '0') {\n return 'top';\n } else {\n return 'bot';\n }\n } else {\n if ((region == 'W' || region == 'Y') && round == 5) {\n return 'top';\n } else if ((region == 'X' || region == 'Z') && round == 5) {\n return 'bot';\n } else if ((region == 'W' || region == 'X') && round == 6) {\n return 'top';\n } else if ((region == 'Z' || region == 'Y') && round == 6) {\n return 'bot';\n }\n }\n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":904,"value":"$38","pinned":true,"hidden":false,"mode":"ojs"},{"id":505,"value":"// Look up the scores\nfunction get_scores(teamID1, teamID2) {\n let result = this_years_results.filter(function(o) {\n return (\n (o.WTeamID == teamID1 && o.LTeamID == teamID2) ||\n (o.WTeamID == teamID2 && o.LTeamID == teamID1)\n );\n });\n if (result.length == 1) {\n result = result[0];\n if (result.WTeamID == teamID1) {\n return [result.WScore, result.LScore].map(d => parseInt(d));\n } else if (result.LTeamID == teamID1) {\n return [result.LScore, result.WScore].map(d => parseInt(d));\n }\n } else {\n return [0, 0];\n }\n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":1634,"value":"md`### Data\n\nThe data comes from Kaggle's March madness competitions for [men](https://www.kaggle.com/c/google-cloud-ncaa-march-madness-2020-division-1-mens-tournament) and [women](https://www.kaggle.com/c/google-cloud-ncaa-march-madness-2020-division-1-womens-tournament).\n`","pinned":false,"hidden":false,"mode":"ojs"},{"id":1640,"value":"md`#### Filtered for the selected tournament.`","pinned":false,"hidden":false,"mode":"ojs"},{"id":503,"value":"this_years_results = {\n if (men_or_women == \"Men\") {\n return mresults.filter(d => d.Season == year);\n } else {\n return wresults.filter(d => d.Season == year);\n }\n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":477,"value":"this_years_seeds = {\n if (men_or_women == \"Men\") {\n return mseeds.filter(d => d.Season == year);\n } else {\n return wseeds.filter(d => d.Season == year);\n }\n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":1643,"value":"md`#### All the raw data`","pinned":false,"hidden":false,"mode":"ojs"},{"id":695,"value":"wseeds = d3.csvParse(await FileAttachment(\"WNCAATourneySeeds@6.csv\").text())","pinned":true,"hidden":false,"mode":"ojs"},{"id":1646,"value":"md`#### Maps to easily access team name from team ID`","pinned":false,"hidden":false,"mode":"ojs"},{"id":706,"value":"team_map = {\n if (men_or_women == \"Men\") {\n return mteam_map;\n } else {\n return wteam_map;\n }\n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":701,"value":"wteam_map = {\n let wteams = d3.csvParse(await FileAttachment(\"WTeams@3.csv\").text());\n let wteam_map = new Map();\n wteams.forEach(function(team) {\n wteam_map.set(team.TeamID, team.TeamName);\n });\n return wteam_map;\n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":259,"value":"mteam_map = {\n let mteams = d3.csvParse(await FileAttachment(\"MTeams@6.csv\").text());\n let mteam_map = new Map();\n mteams.forEach(function(team) {\n mteam_map.set(team.TeamID, team.TeamName);\n });\n return mteam_map;\n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":253,"value":"mseeds = d3.csvParse(await FileAttachment(\"MNCAATourneySeeds@6.csv\").text())","pinned":true,"hidden":false,"mode":"ojs"},{"id":277,"value":"import { mresults, wresults } from \"7eee9e12156dd090\"","pinned":true,"hidden":false,"mode":"ojs"},{"id":1990,"value":"// From @mbostock/pbcopy\nfunction pbcopy(text) {\n const fake = document.body.appendChild(document.createElement(\"textarea\"));\n fake.style.position = \"absolute\";\n fake.style.left = \"-9999px\";\n fake.setAttribute(\"readonly\", \"\");\n fake.value = \"\" + text;\n fake.select();\n try {\n return document.execCommand(\"copy\");\n } catch (err) {\n return false;\n } finally {\n fake.parentNode.removeChild(fake);\n }\n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":1649,"value":"md`### Imports`","pinned":false,"hidden":false,"mode":"ojs"},{"id":1939,"value":"// Current data imported from the notebook\nimport { ncaa_results_2023 } from \"c7bca04a9bd56e41\"","pinned":true,"hidden":false,"mode":"ojs"},{"id":632,"value":"import { select, radio } from \"@jashkenas/inputs\"","pinned":true,"hidden":false,"mode":"ojs"},{"id":609,"value":"tippy = require(\"https://unpkg.com/tippy.js@2.5.4/dist/tippy.all.min.js\")","pinned":true,"hidden":false,"mode":"ojs"},{"id":1655,"value":"md`### Parameters`","pinned":false,"hidden":false,"mode":"ojs"},{"id":954,"value":"div_height = 0.85 * screen.availHeight\n// div_height = 0.625 * div_width","pinned":true,"hidden":false,"mode":"ojs"},{"id":1004,"value":"game_height = div_height / 20","pinned":true,"hidden":false,"mode":"ojs"},{"id":964,"value":"div_width = d3.min([0.96 * width, 1300])","pinned":true,"hidden":false,"mode":"ojs"},{"id":1002,"value":"team_width = 0.11 * div_width","pinned":true,"hidden":false,"mode":"ojs"},{"id":2087,"value":"1 / 9","pinned":true,"hidden":false,"mode":"ojs"},{"id":1652,"value":"styles = html`\n`","pinned":true,"hidden":false,"mode":"ojs"},{"id":2030,"value":"$39","pinned":true,"hidden":false,"mode":"ojs"},{"id":2032,"value":"function get_winner(game) {\n if (parseInt(game.WScore) > parseInt(game.LScore)) {\n return game.WTeamID;\n } else {\n return game.LTeamID;\n }\n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":2093,"value":"d3.csvFormat(mresults.filter((o) => o.Season == 2026))","pinned":true,"hidden":false,"mode":"ojs"}],"files":"$W3a","stdlib":"1","titling":"auto"}