2d:null 2e:["$","title",null,{"children":"2019 Spirit Ranking | Wolfgang Maehr | Observable"}] 33:T104e,result = { /* temporary data structure like: * countries = { * ARG: {: [, , …]}, * AUS: {: [, , …]}, * AUT: {: [, , …]} * } */ var countries = {}; /* temporary data structure like: * countries = { * ARG: {Name: "Argentina", Events: 3, Teams: 12, Rules: 2, Fouls: 2, Fair: 2, Pos: 2, Comm: 2, Total: 2}, * AUS: {Name: "Australia", Events: 3, Teams: 12, Rules: 2, Fouls: 2, Fair: 2, Pos: 2, Comm: 2, Total: 2}, * AUT: {Name: "Austria", Events: 3, Teams: 12, Rules: 2, Fouls: 2, Fair: 2, Pos: 2, Comm: 2, Total: 2}, * } */ var result = {}; var resultTable = [["Code", "Country", "Events", "Teams", "Rules", "Fouls", "Fair", "Pos", "Comm", "Total"]]; // group by countries for (var i = 0; i < teams.length; i++) { if (countries[teams[i].Country] == undefined) { // country does not exist countries[teams[i]["Country"]] = {}; result[teams[i]["Country"]] = {Code: teams[i]["Country"], Name: countryMapping[teams[i]["Country"]]["Name"], Events: 0, Teams: 0}; } if (countries[teams[i].Country][teams[i].Event] == undefined) { // country » event does not exist countries[teams[i].Country][teams[i].Event] = []; result[teams[i].Country]["Events"]++; } countries[teams[i].Country][teams[i].Event].push(teams[i]); result[teams[i].Country]["Teams"]++; } //calculate averages per tournament first for (let [country, events] of Object.entries(countries)) { for (let [event, rows] of Object.entries(events)) { if (rows.length > 1) { var average = {"R: Rules": 0, "R: Fouls": 0, "R: Fair": 0, "R: Pos": 0, "R: Comm": 0}; for (var i = 0; i < rows.length; i++) { average["R: Rules"] += parseFloat(rows[i]["R: Rules"]); average["R: Fouls"] += parseFloat(rows[i]["R: Fouls"]); average["R: Fair"] += parseFloat(rows[i]["R: Fair"]); average["R: Pos"] += parseFloat(rows[i]["R: Pos"]); average["R: Comm"] += parseFloat(rows[i]["R: Comm"]); } average["R: Rules"] = average["R: Rules"]/rows.length; average["R: Fouls"] = average["R: Fouls"]/rows.length; average["R: Fair"] = average["R: Fair"]/rows.length; average["R: Pos"] = average["R: Pos"]/rows.length; average["R: Comm"] = average["R: Comm"]/rows.length; rows.push(average); } } } // calculate the country averages for (let [country, events] of Object.entries(countries)) { var countryAverage = {"Rules": 0, "Fouls": 0, "Fair": 0, "Pos": 0, "Comm": 0}; for (let [event, rows] of Object.entries(events)) { countryAverage["Rules"] += parseFloat(rows[rows.length-1]["R: Rules"]); countryAverage["Fouls"] += parseFloat(rows[rows.length-1]["R: Fouls"]); countryAverage["Fair"] += parseFloat(rows[rows.length-1]["R: Fair"]); countryAverage["Pos"] += parseFloat(rows[rows.length-1]["R: Pos"]); countryAverage["Comm"] += parseFloat(rows[rows.length-1]["R: Comm"]); } result[country]["Rules"] = Math.round(countryAverage["Rules"]/Object.entries(events).length * 100)/100; result[country]["Fouls"] = Math.round(countryAverage["Fouls"]/Object.entries(events).length * 100)/100; result[country]["Fair"] = Math.round(countryAverage["Fair"]/Object.entries(events).length * 100)/100; result[country]["Pos"] = Math.round(countryAverage["Pos"]/Object.entries(events).length * 100)/100; result[country]["Comm"] = Math.round(countryAverage["Comm"]/Object.entries(events).length * 100)/100; result[country]["Total"] = Math.round((result[country]["Rules"] + result[country]["Fouls"] + result[country]["Fair"] + result[country]["Pos"] + result[country]["Comm"]) * 100)/100; } // convert to table Object.keys(result).sort().forEach(function(country) { resultTable.push([country,result[country]["Name"],result[country]["Events"],result[country]["Teams"],result[country]["Rules"],result[country]["Fouls"],result[country]["Fair"],result[country]["Pos"],result[country]["Comm"],result[country]["Total"]]); }); return resultTable; }34:[] 31:{"id":"0d68b0e90d504f6b","slug":"2018-spirit-ranking","title":"2019 Spirit Ranking","thumbnail":"107a4c2824321a9a81795f88d0df90d0e25d882a16de66c4cd2285325dfab89e","access_level":"public","create_time":"$D2019-10-28T17:25:20.899Z","update_time":"$D2026-04-03T00:14:45.031Z","view_time":null,"first_public_time":"$D2019-10-30T08:14:21.592Z","has_unpublished_edits":null,"fork":{"id":"00ad0d3e00361b99","slug":"2018-wmucc-spirit-scores","title":"2018 WMUCC Spirit Scores","owner":{"id":"d77e44d4351a24a4","login":"njyo","name":"Wolfgang Maehr"}},"stars":0,"starred":false,"owner":{"type":"team","id":"d77e44d4351a24a4","login":"njyo","name":"Wolfgang Maehr","avatar_url":"https://avatars-next.observableusercontent.com/5ceede5ac925e657e6e1d0e4b96574d43f1a698867dc5b0c0bb30eb5660b7dcc","tier":"starter_2024"},"version":783,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"10c93fd584ec23ef","login":"njyo","name":"Wolfgang Maehr","avatar_url":"https://avatars-next.observableusercontent.com/5ceede5ac925e657e6e1d0e4b96574d43f1a698867dc5b0c0bb30eb5660b7dcc","tier":null}],"members":[{"type":"individual","id":"10c93fd584ec23ef","login":"njyo","name":"Wolfgang Maehr","avatar_url":"https://avatars-next.observableusercontent.com/5ceede5ac925e657e6e1d0e4b96574d43f1a698867dc5b0c0bb30eb5660b7dcc","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":1,"collection":null,"type":"notebook","body":{"title":"2019 Spirit Ranking","cells":[{"id":0,"value":"md`\n# ${year} Spirit Ranking\n\nThis workbook calculates the ${year} Spirit Ranking based on [WFDF tournament SOTG data](https://github.com/njyo/sotg-data) and allows the download of the resulting CSV below as \\`result\\`.\n\n## Configuration`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":641,"value":"// load the calculation config\nconfig = {\n var config = { // FIXME: Load dynamically from GitHub\n 2022: [\n\t\t\"2017-AOUGCC\", \"2017-AAUCC\", \"2017-WCBU\",\n\t\t\"2018-EUCF\",\n\t\t\"2019-PAUCC\", \"2019-AOUGC\", \"2019-WU24UC\", \"2019-AAUGC\", \"2019-AOBUC\", \"2019-EBUC\",\n\t\t\"2022-WMUCC\", \"2022-TWG\", \"2022-WUCC\", \"2022-WJUC\"\n\t],\n\t2019: [\n\t\t\"2016-WUGC\",\n\t\t\"2017-AOUGCC\", \"2017-PAUCC\", \"2017-AAUCC\", \"2017-WCBU\",\n\t\t\"2018-WUJC\", \"2018-EUCF\", \"2018-WUCC\", \"2018-WMUCC\",\n\t\t\"2019-PAUCC\", \"2019-AOUGC\", \"2019-WU24UC\", \"2019-AAUGC\", \"2019-AOBUC\", \"2019-EBUC\"\n\t],\n\t2018: [\n\t\t\"2015-AOUC\",\n\t\t\"2016-WUGC\",\n\t\t\"2017-AOUGCC\", \"2017-PAUCC\", \"2017-AAUCC\", \"2017-WCBU\",\n\t\t\"2018-WUJC\", \"2018-WU24UC\", \"2018-EUCF\", \"2018-WUCC\", \"2018-WMUCC\"\n\t]\n };\n return config;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":630,"value":"viewof year = html``","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":295,"value":"md`\n## Computation\n### Importing libraries…`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":6,"value":"d3 = require(\"d3@5\");","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":533,"value":"vegalite = require('@observablehq/vega-lite');","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":312,"value":"md`### Loading data…`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":92,"value":"teams = {\n var allTeams = (await d3.csv(\"https://cors-anywhere.herokuapp.com/https://codeberg.org/sotg/score-data/raw/branch/master/data/Event-Results.csv\"));\n var teams = [];\n console.log(allTeams);\n for (var i = 0; i < allTeams.length; i++) {\n if (config[year].includes(allTeams[i][\"Event\"])) {\n teams.push(allTeams[i]);\n if (allTeams[i][\"Year\"] == \"2022\") {\n console.log(allTeams[i][\"Event\"]);\n }\n }\n }\n return teams;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":688,"value":"countryMapping = {\n var countries = (await d3.csv(\"https://cors-anywhere.herokuapp.com/https://codeberg.org/sotg/score-data/raw/branch/master/schema/Enum-Countries.csv\"));\n var countryMapping = {};\n for (var i = 0; i < countries.length; i++) {\n countryMapping[countries[i][\"Code\"]] = countries[i];\n }\n return countryMapping;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":652,"value":"// initialise the calculation config drop-down\n{\n setTimeout(function(){\n var elSelect = document.getElementById(\"config\");\n while (elSelect.firstChild) {\n elSelect.removeChild(elSelect.firstChild);\n }\n // add options\n var elOption;\n for (let [year, events] of Object.entries(config)) {\n elOption = document.createElement(\"option\");\n elOption.innerText = year;\n elSelect.append(elOption);\n }\n elSelect.focus();\n return md`Year selector initialised.`;\n }, 100);\n return md`Initialising…`;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":495,"value":"md`### Compiling data…`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":540,"value":"$33","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W34","stdlib":"1","titling":"auto"}} 32:"$31:body"