30:T481,showTable = (csv) => { const teams = getTeams(csv); const playedMatches = getPlayedMatches(csv); const tableData = getTableData(teams, playedMatches); return html` ${tableData .map( (row) => `` ) .join("")}

Position	Équipe	Points	Jou.	Gag.	Per.	F./P.	3-0	3-1	3-2	2-3	1-3	0-3	Set.P	Set.C	Coeff.S	Pts.P	Pts.C	Coeff.P
${row.position}	${row.team}	${row.championshipPoints}	${row.played}	${row.won}	${row.lost}	${row.walkover}	${row.s30}	${row.s31}	${row.s32}	${row.s23}	${row.s13}	${row.s03}	${row.setsP}	${row.setsC}	${fc(row.setsCoeff)}	${row.pointsP}	${row.pointsC}	${fc(row.pointsCoeff)}

`; }31:T471,updateTableData = (row, result) => { const coeff = (a, b) => (b === 0 ? Infinity : a / b); const newRow = { ...row, championshipPoints: row.championshipPoints + result.sets.championshipPoints, played: row.played + 1, won: row.won + (result.sets.winner ? 1 : 0), lost: row.lost + (result.sets.winner ? 0 : 1), walkover: row.walkover + (result.sets.walkover ? 1 : 0), s30: row.s30 + (result.sets.id === '3-0' ? 1 : 0), s31: row.s31 + (result.sets.id === '3-1' ? 1 : 0), s32: row.s32 + (result.sets.id === '3-2' ? 1 : 0), s23: row.s23 + (result.sets.id === '2-3' ? 1 : 0), s13: row.s13 + (result.sets.id === '1-3' ? 1 : 0), s03: row.s03 + (result.sets.id === '0-3' ? 1 : 0), setsP: row.setsP + result.sets.setsPro, setsC: row.setsC + result.sets.setsCon, pointsP: row.pointsP + result.score.reduce((acc, set) => acc + set.pointsPro, 0), pointsC: row.pointsC + result.score.reduce((acc, set) => acc + set.pointsCon, 0) }; return { ...newRow, setsCoeff: coeff(newRow.setsP, newRow.setsC), pointsCoeff: coeff(newRow.pointsP, newRow.pointsC) }; }32:T430,playedMatchesByTeam = { const updateMatches = (teamId, match, previous) => { return [ ...previous, { ...match[teamId], match: { id: match.id, day: match.day, datetime: match.datetime, referee: match.referee, atHome: match.homeTeam === teamId }, cumulative: { championshipPoints: match[teamId].sets.championshipPoints + (previous.length > 0 ? previous[previous.length - 1].cumulative.championshipPoints : 0) } } ]; }; const byTeam = new Map([...teams.values()].map(t => [t.id, []])); // ensure matches are listed in order of "day" const matches = [...playedMatches].sort((a, b) => a.day - b.day); for (const match of matches) { byTeam.set( match.homeTeam, updateMatches(match.homeTeam, match, byTeam.get(match.homeTeam)) ); byTeam.set( match.awayTeam, updateMatches(match.awayTeam, match, byTeam.get(match.awayTeam)) ); } return byTeam; }33:T68f,parseSets = (c, teamA, teamB) => { const results = { "3-0": { id: "3-0", championshipPoints: 3, setsPro: 3, setsCon: 0, winner: true, walkover: false }, "3-1": { id: "3-1", championshipPoints: 3, setsPro: 3, setsCon: 1, winner: true, walkover: false }, "3-2": { id: "3-2", championshipPoints: 2, setsPro: 3, setsCon: 2, winner: true, walkover: false }, "2-3": { id: "2-3", championshipPoints: 1, setsPro: 2, setsCon: 3, winner: false, walkover: false }, "1-3": { id: "1-3", championshipPoints: 0, setsPro: 1, setsCon: 3, winner: false, walkover: false }, "0-3": { id: "0-3", championshipPoints: 0, setsPro: 0, setsCon: 3, winner: false, walkover: false }, "F.": { id: "F.", championshipPoints: -3, setsPro: 0, setsCon: 3, winner: false, walkover: true }, "P.": { id: "P.", championshipPoints: -3, setsPro: 0, setsCon: 3, winner: false, walkover: true } }; const parse = { " 3/F": ["3-0", "F."], " 3/P": ["3-0", "P."], " 3/0": ["3-0", "0-3"], " 3/1": ["3-1", "1-3"], " 3/2": ["3-2", "2-3"], " 2/3": ["2-3", "3-2"], " 1/3": ["1-3", "3-1"], " 0/3": ["0-3", "3-0"], " F/3": ["F.", "3-0"], " P/3": ["P.", "3-0"] }; if (!(c in parse)) throw Error(c); return { [teamA]: { ...results[parse[c][0]], teamId: teamA }, [teamB]: { ...results[parse[c][1]], teamId: teamB } }; }34:[{"id":"7351d21381abee7cdf989ef9cc21956fff2a97770714ca44f2e488eb583e37f20472f889523f9fca552eaca958bd312f041c1b6147075ba130112dc3bb7d12d3","href":"https://static.observableusercontent.com/files/7351d21381abee7cdf989ef9cc21956fff2a97770714ca44f2e488eb583e37f20472f889523f9fca552eaca958bd312f041c1b6147075ba130112dc3bb7d12d3","name":"RMBA.csv","type":"text/csv","lastModified":1580655949559.475,"size":19816}] 2e:{"title":"Télécharger les données de la FFVB","cells":[{"id":0,"value":"md`# Télécharger les données de la FFVB\n\nFonctions pour accéder aux classements des championnats de volley-ball en France (FFVB).`","pinned":false,"hidden":false,"mode":"ojs"},{"id":331,"value":"viewof team = select({\n options: [...teams.values()].map(t => ({ label: t.name, value: t.id })),\n value: '0357988'\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":349,"value":"chartSets = () =>\n vl\n .markBar()\n .data(sets)\n .title(`Tous les sets de ${teams.get(team).name}`)\n .encode(\n vl\n .x()\n .fieldQ('x')\n .title('Tous les sets de la saison')\n .axis({\n values: d3.range(0, 100, 1)\n }),\n vl\n .y()\n .fieldQ('y')\n .title('Difference de points')\n )\n .height(400)\n .render()","pinned":false,"hidden":false,"mode":"ojs"},{"id":343,"value":"sets = playedMatchesByTeam\n .get(team)\n .map(t => t.score.map(set => set.difference))\n .reduce((a, c) => a.concat(c), [])\n .map((v, i) => ({ x: i + 1, y: v }))","pinned":false,"hidden":false,"mode":"ojs"},{"id":267,"value":"chartChampionshipPoints = () =>\n vl\n .markLine()\n .data(championshipPointsByTeam)\n .title('Évolution des points par journée')\n .encode(\n vl\n .x()\n .fieldQ('day')\n .title('Journée')\n .axis({\n values: d3.range(0, 100, 1)\n }),\n vl\n .y()\n .fieldQ('points')\n .title('Points'),\n vl\n .color()\n .fieldN('teamName')\n .sort({ field: \"points\", order: \"descending\", op: \"max\" })\n .title('Équipe')\n )\n .height(400)\n .render()","pinned":false,"hidden":false,"mode":"ojs"},{"id":428,"value":"showTable(await csvFromFFVB(\"LIBR\", \"RMB\", \"2019/2020\"))","pinned":true,"hidden":false,"mode":"ojs"},{"id":462,"value":"csv2 = await csvFromFFVB(\"LIBR\", \"RMC\", \"2021/2022\")","pinned":true,"hidden":false,"mode":"ojs"},{"id":457,"value":"showTable(csv2)","pinned":true,"hidden":false,"mode":"ojs"},{"id":187,"value":"$30","pinned":false,"hidden":false,"mode":"ojs"},{"id":247,"value":"fc = coeff => coeff.toFixed(3)","pinned":true,"hidden":false,"mode":"ojs"},{"id":431,"value":"tableData = getTableData(teams, playedMatches)","pinned":true,"hidden":false,"mode":"ojs"},{"id":193,"value":"getTableData = (teams, playedMatches) => {\n const table = new Map(\n [...teams.entries()].map(([i, t]) => [\n i,\n {\n position: 1,\n team: t.name,\n championshipPoints: 0,\n played: 0,\n won: 0,\n lost: 0,\n walkover: 0,\n s30: 0,\n s31: 0,\n s32: 0,\n s23: 0,\n s13: 0,\n s03: 0,\n setsP: 0,\n setsC: 0,\n setsCoeff: 1,\n pointsP: 0,\n pointsC: 0,\n pointsCoeff: 1\n }\n ])\n );\n for (const match of playedMatches) {\n table.set(\n match.homeTeam,\n updateTableData(table.get(match.homeTeam), match[match.homeTeam])\n );\n table.set(\n match.awayTeam,\n updateTableData(table.get(match.awayTeam), match[match.awayTeam])\n );\n }\n return [...table.values()]\n .sort((a, b) => b.championshipPoints - a.championshipPoints)\n .map((row, i) => ({ ...row, position: i + 1 }));\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":202,"value":"$31","pinned":false,"hidden":false,"mode":"ojs"},{"id":235,"value":"updateTableData(\n {\n position: 1,\n team: 'toto',\n championshipPoints: 0,\n played: 0,\n won: 0,\n lost: 0,\n walkover: 0,\n s30: 0,\n s31: 0,\n s32: 0,\n s23: 0,\n s13: 0,\n s03: 0,\n setsP: 0,\n setsC: 0,\n setsCoeff: 1,\n pointsP: 0,\n pointsC: 0,\n pointsCoeff: 1\n },\n playedMatches[0][playedMatches[0].homeTeam]\n)","pinned":false,"hidden":false,"mode":"ojs"},{"id":189,"value":"teams = getTeams(csv)","pinned":false,"hidden":false,"mode":"ojs"},{"id":435,"value":"getTeams = (csv) =>\n new Map(csv.map((m) => [m.EQA_no, { id: m.EQA_no, name: m.EQA_nom }]))","pinned":false,"hidden":false,"mode":"ojs"},{"id":166,"value":"playedMatches = getPlayedMatches(csv)","pinned":false,"hidden":false,"mode":"ojs"},{"id":441,"value":"getPlayedMatches = (csv) => csv.filter((o) => o.Set).map(parseMatch)","pinned":false,"hidden":false,"mode":"ojs"},{"id":261,"value":"championshipPointsByTeam = {\n return [...playedMatchesByTeam.values()]\n .map(t =>\n t.map(o => ({\n day: o.match.day,\n teamName: o.team.name,\n points: o.cumulative.championshipPoints\n }))\n )\n .reduce((acc, cur) => acc.concat(cur), []);\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":256,"value":"$32","pinned":false,"hidden":false,"mode":"ojs"},{"id":85,"value":"parseScore = (s, teamA, teamB) => {\n const sets = s.split(',').map(set => set.split('-').map(pts => +pts));\n const toResult = n => (set, i) => ({\n setId: i + 1,\n pointsPro: set[n],\n pointsCon: set[1 - n],\n winner: set[n] > set[1 - n],\n difference: set[n] - set[1 - n]\n });\n return {\n [teamA]: sets.map(toResult(0)),\n [teamB]: sets.map(toResult(1))\n };\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":88,"value":"parseScore(\"25-23,25-17,20-25,26-24\", '0351474', '0224485')","pinned":false,"hidden":false,"mode":"ojs"},{"id":78,"value":"$33","pinned":false,"hidden":false,"mode":"ojs"},{"id":122,"value":"parseSets(\" 3/1\", '0351474', '0224485')","pinned":false,"hidden":false,"mode":"ojs"},{"id":56,"value":"parseMatch = o => {\n const teamA = { id: o.EQA_no, name: o.EQA_nom };\n const teamB = { id: o.EQB_no, name: o.EQB_nom };\n const sets = parseSets(o.Set, teamA.id, teamB.id);\n const score = parseScore(o.Score, teamA.id, teamB.id);\n\n const base = {\n id: o.Match,\n day: +o.Jo,\n datetime: new Date(`${o.Date}T${o.Heure}:00`),\n referee: o.Arb1,\n homeTeam: teamA.id,\n awayTeam: teamB.id,\n winner: Object.values(sets).find(team => team.winner === true)['teamId'],\n [teamA.id]: { team: teamA, sets: sets[teamA.id], score: score[teamA.id] },\n [teamB.id]: { team: teamB, sets: sets[teamB.id], score: score[teamB.id] }\n };\n\n return base;\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":54,"value":"parseMatch(csv[0])","pinned":false,"hidden":false,"mode":"ojs"},{"id":452,"value":"csvFromFFVB(\"LIBR\", \"RMC\", \"2021/2022\")","pinned":false,"hidden":false,"mode":"ojs"},{"id":420,"value":"csvFromFFVB(\"LIBR\", \"RMB\", \"2019/2020\")","pinned":false,"hidden":false,"mode":"ojs"},{"id":375,"value":"csvFromFFVB = (code, pool, season = \"2019/2020\") =>\n fetch(\n proxy + \"http://www.ffvbbeach.org/ffvbapp/resu/vbspo_calendrier_export.php\",\n {\n headers: {\n \"Content-Type\": \"application/x-www-form-urlencoded\"\n },\n body: `cal_saison=${season}&cal_codent=${code}&cal_codpoule=${pool}&typ_edition=E&type=RES&rech_equipe=&x=11&y=9`,\n method: \"POST\"\n }\n )\n .then((res) => res.arrayBuffer())\n .then((arrayBuffer) => new TextDecoder(\"iso-8859-1\").decode(arrayBuffer))\n .then((text) => d3.dsvFormat(\";\").parse(text))","pinned":false,"hidden":false,"mode":"ojs"},{"id":2,"value":"csv = d3.csvParse(await FileAttachment(\"RMBA.csv\").text())","pinned":false,"hidden":false,"mode":"ojs"},{"id":412,"value":"proxy = \"https://severo-observablehq.fly.dev/\"","pinned":false,"hidden":false,"mode":"ojs"},{"id":383,"value":"pool = 'RMB'","pinned":false,"hidden":false,"mode":"ojs"},{"id":15,"value":"d3 = require('d3')","pinned":false,"hidden":false,"mode":"ojs"},{"id":262,"value":"import { vl } from '@vega/vega-lite-api'","pinned":false,"hidden":false,"mode":"ojs"},{"id":325,"value":"import { select } from \"@jashkenas/inputs\"","pinned":false,"hidden":false,"mode":"ojs"}],"files":"$W34","stdlib":"1","titling":"auto"}