25:["$","title",null,{"children":"Estimations de chances de médailles en vue des JO de Tokyo : Étude du Volleyball | antoinehnz | Observable"}] 4c:[] 48:{"id":"364ad25bbd0151c0","slug":"volley","title":"Estimations de chances de médailles en vue des JO de Tokyo : Étude du Volleyball","thumbnail":"59546d1e23df6c4b3cec1d52f659a968d5bc801f2fecf47b1ae60ae05ebda526","access_level":"public","create_time":"$D2021-05-26T15:22:17.474Z","update_time":"$D2021-05-26T15:25:28.717Z","view_time":null,"first_public_time":"$D2021-05-26T15:24:09.146Z","has_unpublished_edits":null,"fork":{"id":"a4c1fa750ff68d17","slug":"modelevierge","title":"MODELE VIERGE","owner":{"id":"28c93ca135bc4b52","login":"antoinehnz","name":""}},"stars":0,"starred":false,"owner":{"type":"team","id":"28c93ca135bc4b52","login":"antoinehnz","name":"","avatar_url":"https://avatars-next.observableusercontent.com/38f53652d662ff38cf8f3312c897b4a1826f20df3401f2ecd6dee15b03d9dbd9","tier":"starter_2024","bio":"","followed_by_you":false,"follows_you":false},"version":424,"publish_version":424,"role":null,"authored":false,"authors":[{"type":"individual","id":"fd2bfb99bf56c2e5","login":"antoinehnz","name":"","avatar_url":"https://avatars-next.observableusercontent.com/38f53652d662ff38cf8f3312c897b4a1826f20df3401f2ecd6dee15b03d9dbd9","tier":null,"bio":"","followed_by_you":false,"follows_you":false}],"members":[{"type":"individual","id":"fd2bfb99bf56c2e5","login":"antoinehnz","name":"","avatar_url":"https://avatars-next.observableusercontent.com/38f53652d662ff38cf8f3312c897b4a1826f20df3401f2ecd6dee15b03d9dbd9","tier":null,"role":"editor"},{"type":"individual","id":"10ffeec721bda047","login":"theoalgd","name":"theo algoud","avatar_url":"https://avatars-next.observableusercontent.com/1266a8817bbdd470d3907c778de0840e23f196f40698bd44d6e083c1dacf93a5","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":1,"collection":{"id":"395c810906b95fd8","slug":"pe-77-etude-des-jo-2021","title":"[PE 77] Étude des JO 2021","owner":{"id":"28c93ca135bc4b52","login":"antoinehnz","name":""}},"type":"notebook","body":{"titling":"auto","title":"Estimations de chances de médailles en vue des JO de Tokyo : Étude du Volleyball","cells":[{"id":0,"value":"md`# Estimations de chances de médailles en vue des JO de Tokyo : Étude du Volleyball`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":7,"value":"md`

\nNous présentons ici le travail d'un groupe d'étudiants de l'Ecole Centrale de Lyon, en ce qui concerne ${Article} ${Choix_Sport}, pour les Jeux Olympiques de 2021. Nous avons cherché à analyser les dernières performances des différents athlètes, français et internationnaux, dans différentes disciplines, afin d'estimer le nombre de médailles françaises aux Jeux. Voici ci-dessous notre analyse pour ${Article} ${Choix_Sport}.\n

\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":19,"value":"md` ---\n## Tour d'horizon de nos estimations de chances de médaille pour toutes les disciplines des JO de Tokyo`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":46,"value":"vegalite({\n \"data\": {values: data_gdoc1},\n \"layer\": [ {\n \"mark\": {\"type\" : \"bar\", \"color\" : \"#D9DDDC\"},\n \"encoding\": {\n \"x\": {\"field\": \"Sport\" , \"type\": \"nominal\"},\n \"y\": {aggregate: \"count\", field: \"*\", type: \"quantitative\",\"title\" : \"Médailles possibles\"}}},\n {\n \"mark\": {\"type\" : \"bar\", \"color\" : \"#4d4f4f\"},\n \"encoding\": {\n \"x\": {\"field\": \"Sport\" , \"type\": \"nominal\"},\n \"y\": {\"field\": 'Evaluation au'.concat(' ', DateEstimation) ,\"type\": \"quantitative\", \"aggregate\": \"sum\",\"title\" : \"Estimation\"},\n \"color\": {\n \"condition\": {test: {\"field\" : \"Sport\", \"equal\" : Choix_Sport}, value: \"#4C78A8\" },\n value: \"#4d4f4f\"}\n } }]\n },\n \"invalidation\",\n \"visibility\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":65,"value":"md`\nSur ce graphe on trouve :
\n* **Le total de podiums dans le sport**
\n* Notre estimation pour la France dans le sports (autre que ${Article} ${Choix_Sport})
\n* Notre estimation pour la France en ${Choix_Sport} \n

\n\n**À Noter** : Pour chaque discipline, on a établit une chance de podium entre 0 et 1. Ici on représente la somme de ces notes. Il faut donc voir cette valeur comme une valeur basse.
\nNotre estimation la plus haute est la suivante : ** ${Nmax} podiums** pour la France \n\nSi vous souhaitez voir nos autres estimations, notamment dans les autres sports, je vous invite à visiter [cette page](https://next.observablehq.com/@antoinehnz/visualisation-des-donnees-de-jo)

On cherche ici à représenter en détail nos estimations dans les différentes disciplines qui composent ${Article} ${Choix_Sport}.
\nFaute de temps, nous nous sommes concentré que sur certaines disciplines, nous obligeant à faire un choix, et donc laissant possiblement certaines disciplines importantes de côté.

\nAfin d'arriver à ces conclusions nous avons appliqué notre méthode d'analyse de donnée. Vous pouvez retrouver le détail de cette méthode sur [cette page](https://observablehq.com/@antoinehnz/presentation-de-notre-methode-danalyse-de-donnees)
\n\n

\nOn compare ainsi les résultats des favoris de toute nationalité en ${Choix_Sport}. Ceux-ci ont été choisi selon les résultats des derniers évènements majeurs
\nVoici le détail de l'application : \n

`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":378,"value":"md`*Mettez votre tableau ici*`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":339,"value":"md`Sur ce tableau on trouve :
\n* La colonne score qui donne le score brut obtenu par la formule
\n* La colonne pourcentage qui donne la part de l’athlète considéré dans le score cumulé.
\n* La colonne classement qui donne le classement alors établie avec la méthode
\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":352,"value":"md`### Conclusion`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":357,"value":"md`*votre conclusion sur le sport*\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":368,"value":"md` ---`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":43,"value":"md` ---\n## Détails Techniques`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":272,"value":"md`### Paramètres clés`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":221,"value":"Choix_Sport = \"Volletball/beach volley\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":275,"value":"Article = \"le\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":297,"value":"DateEstimation = '05/05/2021'","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":280,"value":"md` ---`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":238,"value":"Nmax ={ return db.exec(`\n SELECT COUNT(*) FROM data_gdoc1\n WHERE Sport = \"${Choix_Sport}\" AND\n NOT([Evaluation au ${DateEstimation}] = \"0\")`)[0][\"COUNT(*)\"]\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":48,"value":"url_gdoc = \"https://docs.google.com/spreadsheets/d/e/2PACX-1vS3_DKGAgsO369BBU_4xtoYg1dEJWDd2u2rWOtNFQVAwoPE_xlXKTxbw3w92TMYN-N9ItyJHcRDiFSG/pub?gid=960746373&single=true&output=tsv\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":305,"value":"url_gdoc3 = \"https://docs.google.com/spreadsheets/d/e/2PACX-1vS3_DKGAgsO369BBU_4xtoYg1dEJWDd2u2rWOtNFQVAwoPE_xlXKTxbw3w92TMYN-N9ItyJHcRDiFSG/pub?gid=143365772&single=true&output=tsv\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":115,"value":"url_gdoc4 = \"https://docs.google.com/spreadsheets/d/e/2PACX-1vS3_DKGAgsO369BBU_4xtoYg1dEJWDd2u2rWOtNFQVAwoPE_xlXKTxbw3w92TMYN-N9ItyJHcRDiFSG/pub?gid=4095632&single=true&output=tsv\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":51,"value":"data_gdoc1 = {\n let names = [];\n const spreadsheet = await d3\n .tsv(url_gdoc)\n .then(data => data.forEach(d => names.push(d)));\n return names;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":309,"value":"data_gdoc3 = {\n let names = [];\n const spreadsheet = await d3\n .tsv(url_gdoc3)\n .then(data => data.forEach(d => names.push(d)));\n return names;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":118,"value":"data_gdoc4 = {\n let names = [];\n const spreadsheet = await d3\n .tsv(url_gdoc4)\n .then(data => data.forEach(d => names.push(d)));\n return names;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":54,"value":"d3 = require(\"d3@5\", \"d3-sankey@0.12\", \"d3-array@^2.2\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":178,"value":"alasql = require(\"alasql\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":181,"value":"db = {\n let db = new alasql.Database();\n db.exec('CREATE TABLE data_gdoc1');\n db.tables.data_gdoc1.data = data_gdoc1;\n return db\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":184,"value":"chart_data2 = {\n let sql = `\n SELECT Athletes,Discipline, [Evaluation au ${DateEstimation}] AS Confiance\n FROM data_gdoc1 \n WHERE Sport = \"${Choix_Sport}\" AND [Evaluation au ${DateEstimation}] > 0\n ORDER BY [Evaluation au ${DateEstimation}] DESC`\n \n\n return db.exec(sql)\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":193,"value":"import {table} from \"@tmcw/tables/2\"//import {table} from \"@tmcw/tables@444\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":56,"value":"vegalite = require(\"@observablehq/vega-lite@0.2\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":60,"value":"colorVega = \"#4C78A8\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W4c","stdlib":"1"}} 24:null