25:["$","title",null,{"children":"Estimations de chances de médailles en vue des JO de Tokyo : Étude du Cyclisme | antoinehnz | Observable"}] 4b:[{"id":"088d31ab435012a28e4ca3a384acd2b7b79ad0130a26686520ac3b97943d044c2f5aaafce74e45cc9694eb8a6e7964265a1a07d9b9bb52248e461b8d09504ba8","href":"https://static.observableusercontent.com/files/088d31ab435012a28e4ca3a384acd2b7b79ad0130a26686520ac3b97943d044c2f5aaafce74e45cc9694eb8a6e7964265a1a07d9b9bb52248e461b8d09504ba8","name":"CourseLigne.PNG","type":"image/png","lastModified":1617807150758.581,"size":22939},{"id":"ad96c2f2af9c62d59b104c4766d863dc015944b68224e3d6a2582239e46fc7c306acaf52516326f5833444b94148d08f71fb30155753106139e577f0a643bbf9","href":"https://static.observableusercontent.com/files/ad96c2f2af9c62d59b104c4766d863dc015944b68224e3d6a2582239e46fc7c306acaf52516326f5833444b94148d08f71fb30155753106139e577f0a643bbf9","name":"VTT.PNG","type":"image/png","lastModified":1617806668795.102,"size":31376},{"id":"8ac6069595612890cdd201853213344639a0e69f9bb4ed13f1768bf6acce3de604f5aeb80d840485b64642fab886be11443e2bbdac1d5ffd01cb18b9628741c4","href":"https://static.observableusercontent.com/files/8ac6069595612890cdd201853213344639a0e69f9bb4ed13f1768bf6acce3de604f5aeb80d840485b64642fab886be11443e2bbdac1d5ffd01cb18b9628741c4","name":"Americaine + omnium.png","type":"image/png","lastModified":1617811174149.229,"size":31593}] 47:{"id":"98f2b58e0f9d72ed","slug":"rapport_cyclisme","title":"Estimations de chances de médailles en vue des JO de Tokyo : Étude du Cyclisme","thumbnail":"3e26efd19b7bea725d8f312b4ca227495ff454ea56fde5b7a0d05ccc7cfb1d4e","access_level":"public","create_time":"$D2021-04-07T14:33:27.484Z","update_time":"$D2021-05-28T12:54:15.645Z","view_time":null,"first_public_time":"$D2021-04-07T15:38:45.703Z","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":491,"publish_version":491,"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":"4af7e25d44b0c0a2","login":"cleolarminay","name":"","avatar_url":"https://avatars-next.observableusercontent.com/c38b04657650ba7e448715e86499aa5e43be8b217da0476d7a09f23e76704558","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 du Cyclisme","cells":[{"id":0,"value":"md`# Estimations de chances de médailles en vue des JO de Tokyo : Étude du ${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\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 la natation.
\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é.

`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":113,"value":"vegalite({\"$schema\": \"https://vega.github.io/schema/vega-lite/v4.json\",\n \"data\": {values: data_gdoc3},\n \"mark\": {\"type\" : \"rect\"},\n \"encoding\": {\n \"y\" : {\"field\": \"Discipline\" , \"type\": \"nominal\", sort: false, \"title\" : Choix_Sport},\n \"x\": {\"field\" : \"Score\", \"type\": \"quantitative\", \"title\" : \"Confiance (entre 0 et 1)\",\"sort\" : false,\"scale\": {\"domain\": [0,1]}},\n \"color\": {\"field\" : \"Score\", \"type\" : \"quantitative\",\"scale\": {\"scheme\": \"redyellowgreen\",\"domain\": [0,1]},\"title\" : \"Confiance\"},\n \"config\": {\n \"axis\": {\"grid\": true, \"tickBand\": \"extent\",\"axis\": {\"format\": \"%\"},}\n },\n \"tooltip\": {\"field\": \"Score\", \"type\": \"quantitative\"}},\n \"transform\": [{\"filter\" : {\"and\": [{\"field\" : \"Sport\", \"equal\" : Choix_Sport}, {\"field\" : \"Date\", \"equal\" : DateEstimation}]}}]\n \n \n })","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":37,"value":"md` ---\n## Nos favoris en ${Choix_Sport} pour les JO`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":167,"value":"md`

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

\nLes favoris ont été choisis selon le classement à la dernière coupe du monde complète : celle de 2019.\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":378,"value":"FileAttachment(\"VTT.PNG\").image()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":357,"value":"md`\n* Concernant le **VTT Femme** : Ceci présage de très bons résultats pour la française Pauline Ferrand Prévot qui semble survoler sa catégorie.\n* Concernant le **VTT Homme** : Ceci montre que le français Jordan Sarrou est bon mais les aléas des Jeux Olympiques peuvent le priver de sa médaille. Ses chances de médailles sont évaluées à 0,25 sachant que d’autres français sont bons (voire très bons) dans cette discipline et peuvent se révéler aux Jeux Olympiques.\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":420,"value":"md`### Pour la course en ligne`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":443,"value":"md`

\nOn étudie pour chaque année les résultats du championnat du monde. De plus on s'intéresse au **tour de lombardie** et à la course de **San Sebastian**. Ces deux courses majeurs ont été choisis pour leur profil, comparable à celui de l'épreuve de cette année à Tokyo\n

\n**Julian Alaphilippe** semble dominer ce genre d'épreuve, surtout avec un profil tel celui de la course des JO de cette année. **Thibault Pinot** pour sa part a un score moins élevé à cause de son physique moins approprié pour ce genre de course, ainsi que par ses mauvaises performances récentes.\n

\nOn étudie pour chaque année les résultats du championnat du monde et le classement en coupe du monde.\n

Pour la **course à l'américaine** : La France, représenté par le tandem **Benjamin Thomas et Vincent Grondin**, semble un peu courte pour avoir une médaille cet été. Toutefois les résultats sont en progression.

\n*

Pour **l'omnium** : là **Benjamin Thomas** semble bien seul. Fort de sa victoire au championnat du monde et de sa 2e place au classement général, il fera figure de grand favori face au coureur néerlandais.

\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 = \"Cyclisme\"","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":"$W4b","stdlib":"1"}} 24:null