25:["$","title",null,{"children":"Estimations de chances de médailles en vue des JO de Tokyo : Étude de l' Equitation | antoinehnz | Observable"}] 4b:[{"id":"8989117c13cf3be8830f1cb979c89a9646e39ba4888b2eef73372641dc7693c6fdf40cc8f6b598ed23e2069dede6713f67375f1322481fcb241525da3051fbea","href":"https://static.observableusercontent.com/files/8989117c13cf3be8830f1cb979c89a9646e39ba4888b2eef73372641dc7693c6fdf40cc8f6b598ed23e2069dede6713f67375f1322481fcb241525da3051fbea","name":"Capture d’écran 2021-05-24 à 17.44.28.png","type":"image/png","lastModified":1621871081458.265,"size":65281}] 47:{"id":"3c7ab2d01393f9ac","slug":"etude_equitation","title":"Estimations de chances de médailles en vue des JO de Tokyo : Étude de l' Equitation","thumbnail":"832bcbfa4a8252162b152f4e77869480ed291191dc1180b536e8140997a2722c","access_level":"public","create_time":"$D2021-05-24T07:30:05.744Z","update_time":"$D2021-05-25T08:46:18.704Z","view_time":null,"first_public_time":"$D2021-05-24T07:32:15.429Z","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":417,"publish_version":417,"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":"6293ff835bd2e814","login":"emmameyer","name":"meyer emma","avatar_url":"https://avatars-next.observableusercontent.com/0779b6f5ecbf7549ff1dbebd5222b657a6b80685f8452f817fe3eed1827d5d82","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":0,"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 de l' Equitation","cells":[{"id":0,"value":"md`# Estimations de chances de médailles en vue des JO de Tokyo : Étude de ${Article} ${Choix_Sport}`","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é.

Dans cette partie, nous avons essayé de séléctionner parmi les différents athlètes qualifiés ou en voie de se qualifier les favoris français.
\nEncore une fois, nous avons dû faire un choix parmi les disciplines, et donc parmi les athlètes à analyser.\n

\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":"FileAttachment(\"Capture d’écran 2021-05-24 à 17.44.28.png\").image()\n","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`*La France a une chance de gagné une médaille au concours complet par équipe mais pas au saut d'obstacle par équipe *\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 = \"Equitation\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":275,"value":"Article = \"l'\"","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":"$W4b","stdlib":"1"}} 24:null