{"text_format":"1","workbook":"xlsx","n_sheets":17,"sheets":["À faire","CP_Villes","Intervenants","Intervenants_Solution","Interventions","Interventions_Solution","Interventions_complète","Interventions_complète_Solution","Interventions-JDE","Interventions-WTR","Interventions-GME","EXO-01","EXO-01_Solution","EXO-02","EXO-02_Solution","EXO-03","EXO-03_Solution"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":4,"comments":0,"pivot_tables":1},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"À faire","index":0,"n_rows":22,"n_cols":4,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,"Sur la feuille :","Réalisez ceci :"]
[]
[null,"1-","CP_Villes","- Récupérez les valeurs uniques des intervention d'un intervenant (par exemple à partir de la feuille 'Interventions JDE'). "]
[null,null,null,"=> Créez alors une liste dont le contenu sera la liste de ces valeurs uniques"]
[]
[null,"2-","Interventions-GME","- Faire en sorte que le CP de l'intervention soit choisi via une liste proposant tous les codes postaux"]
[null,null,null,"- Transformer la plage en un tableau de données"]
[null,null,null,"- Récupérer le nom du praticien dans une nouvelle colonne (3 dernières lettres du nom de la feuille)"]
[]
[null,"3-","Interventions","Via Power Query, récupérer les données des 3 praticiens et assemblez-les sur la feuille 'Interventions'"]
[]
[null,"4-","Intervenants","Ajoutez un code à chaque intervenant, celui-ci se compose da la première lettre du prénom et des 2 premières lettres du nom"]
[]
[null,"5-","Interventions_complète","Via Power Query, créez une requête qui permet d'ajouter à la liste des interventions la commune, le nom et le prénom du praticien du praticien"]
[]
[null,"6-","EXO-01","Récupération de données et nettoyage via Power Query"]
[]
[null,"7-","EXO-02","Combinaison de requête via Power Query"]
[]
[null,"8-","EXO-03","Relation entre 'queries' pour créé un TCD"]

{"sheet":"CP_Villes","index":1,"n_rows":20,"n_cols":15,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
["Colonne1","Colonne2",null,null,null,null,null,null,null,null,null,null,null,null,"Retour"]
[1070,"Anderlecht",null,"- Récupérez les valeurs uniques des intervention d'un intervenant (par exemple à partir de la feuille 'Interventions JDE'). "]
[1160,"Auderghem",null,"=> Créez alors une liste dont le contenu sera la liste de ces valeurs uniques"]
[1082,"Berchem-Sainte-Agathe"]
[1000,"Ville de Bruxelles"]
[1040,"Etterbeek",null,null,null,"Interventions"]
[1140,"Evere",null,null,null,{"$f":"_xlfn._xlws.SORT(_xlfn.UNIQUE(JDE[Type]))","v":"Administration"}]
[1190,"Forest",null,null,null,"Consultation centre"]
[1083,"Ganshoren",null,null,null,"Consultation domicile"]
[1050,"Ixelles",null,null,null,"Intervention d'urgence"]
[1090,"Jette",null,null,null,0]
[1081,"Koekelberg"]
[1080,"Molenbeek-Saint-Jean"]
[1060,"Saint-Gilles",null,"- Récupérez les valeurs uniques des intervention d'un intervenant (par exemple à partir de la feuille 'Interventions-GME'). "]
[1210,"Saint-Josse-ten-Noode",null,"=> Créez alors une liste dont le contenu sera la liste de ces valeurs uniques (sur les feuilles 'Interventions-GME')"]
[1030,"Schaerbeek"]
[1180,"Uccle"]
[1170,"Watermael-Boitsfort",null,null,null,"Interventions"]
[1200,"Woluwe-Saint-Lambert"]
[1150,"Woluwe-Saint-Pierre"]

{"sheet":"Intervenants","index":2,"n_rows":24,"n_cols":13,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
["Nom","Prénom","Code",null,null,null,null,null,null,null,null,null,"Retour"]
["Tredelè","Willy"]
["Foupasune","Jean"]
["Bistrot","Alonso",null,null,"Ajoutez un code à chaque intervenant, celui-ci se compose da la première lettre du prénom et des 2 premières lettres du nom"]
["Bijoba","Jo",null,null,"Le code sera en majuscule"]
["Covert","Harry",null,null,"Créez une 'Query' qui reprend les données de ce tableau. Ne créez que la connexion lors du chargement."]
["Culaire","Laury"]
["Deuf","John"]
["Foupasune","Jean"]
["Lairbon","Oussama"]
["Menvussa","Gérard"]
["Lalalalalalala","Starsky"]
["Lalalalalalala","Hutch"]
["Cléssoulaporte","Djamila"]
["Noux","Marion"]
["Ouzi","Jacques"]
["Stiké","Sophie"]
["Tare","Guy"]
["Vaisselle","Aude"]
["Zetofrais","Mélanie"]
["Touille","Sasha"]
["Proviste","Alain"]
["Peulaporte","Firmin"]
["Unetitlaine","Jérémy"]

{"sheet":"Intervenants_Solution","index":3,"n_rows":24,"n_cols":13,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
["Nom","Prénom","Code_Solution",null,null,null,null,null,null,null,null,null,"Retour"]
["Tredelè","Willy",{"$f":"LEFT(B2,1)&UPPER(LEFT(A2,2))","v":"WTR"}]
["Foupasune","Jean",{"$f":"LEFT(B3,1)&UPPER(LEFT(A3,2))","v":"JFO"}]
["Bistrot","Alonso","ABI",null,"Ajoutez un code à chaque intervenant, celui-ci se compose da la première lettre du prénom et des 2 premières lettres du nom"]
["Bijoba","Jo","JBI",null,"Le code sera en majuscule"]
["Covert","Harry","HCO",null,"Créez une 'Query' qui reprend les données de ce tableau sans doublons. Ne créez que la connexion lors du chargement."]
["Culaire","Laury","LCU"]
["Deuf","John","JDE"]
["Foupasune","Jean","JFO"]
["Lairbon","Oussama","OLA"]
["Menvussa","Gérard","GME"]
["Lalalalalalala","Starsky","SLA"]
["Lalalalalalala","Hutch","HLA"]
["Cléssoulaporte","Djamila","DCL"]
["Noux","Marion","MNO"]
["Ouzi","Jacques","JOU"]
["Stiké","Sophie","SST"]
["Tare","Guy","GTA"]
["Vaisselle","Aude","AVA"]
["Zetofrais","Mélanie","MZE"]
["Touille","Sasha","STO"]
["Proviste","Alain","APR"]
["Peulaporte","Firmin","FPE"]
["Unetitlaine","Jérémy","JUN"]

{"sheet":"Interventions","index":4,"n_rows":3,"n_cols":15,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Retour"]
["Via Power Query, récupérer les données des 3 praticiens et assemblez-les sur la feuille 'Interventions'"]
["Chargez les données sur cette feuille"]

{"sheet":"Interventions_Solution","index":5,"n_rows":48,"n_cols":13,"rows_kept":48,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,"Retour"]
["Via Power Query, récupérer les données des 3 praticiens et assemblez-les sur la feuille 'Interventions'"]
["Chargez les données sur cette feuille"]
[]
[]
["Date","Type","Commune","Praticien"]
["2024-01-06","Consultation domicile",1000,"JDE"]
["2024-01-06","Consultation centre",1050,"JDE"]
["2024-01-06","Consultation centre",1050,"JDE"]
["2024-01-06","Consultation centre",1050,"JDE"]
["2024-01-06","Consultation domicile",1060,"JDE"]
["2024-01-06","Intervention d'urgence",1060,"JDE"]
["2024-02-07","Intervention d'urgence",1060,"JDE"]
["2024-02-08","Intervention d'urgence",1060,"JDE"]
["2024-02-09","Consultation domicile",1060,"JDE"]
["2024-02-10","Consultation domicile",1060,"JDE"]
["2024-02-11","Consultation domicile",1060,"JDE"]
["2024-04-15","Administration",1150,"JDE"]
["2024-06-18","Administration",1200,"JDE"]
["2024-03-05","Administration",1200,"JDE"]
["2024-03-06","Consultation domicile",1200,"JDE"]
["2024-03-07","Administration",1050,"JDE"]
["2024-03-08","Intervention d'urgence",1050,"JDE"]
["2024-03-09","Intervention d'urgence",1050,"JDE"]
["2024-05-05","Intervention d'urgence",1060,"JDE"]
["2024-08-10","Administration",1000,"JDE"]
["2024-08-05","Consultation domicile",1000,"JDE"]
["2024-06-16","Consultation domicile",1080,"JDE"]
["2024-06-16","Administration",1000,"JDE"]
["2024-06-16",null,null,"JDE"]
["2024-01-06","Consultation domicile",1000,"WTR"]
["2024-01-06","Consultation centre",1050,"WTR"]
["2024-01-06","Consultation centre",1050,"WTR"]
["2024-01-06","Consultation centre",1050,"WTR"]
["2024-01-06","Consultation domicile",1060,"WTR"]
["2024-01-06","Intervention d'urgence",1060,"WTR"]
["2024-02-07","Intervention d'urgence",1060,"WTR"]
["2024-02-08","Intervention d'urgence",1060,"WTR"]
["2024-02-09","Consultation domicile",1060,"WTR"]
["2024-02-10","Consultation domicile",1060,"WTR"]
["2024-02-11","Consultation domicile",1060,"WTR"]
["2024-04-15","Administration",1150,"WTR"]
["2024-06-18","Administration",1200,"WTR"]
["2024-03-05","Administration",1200,"WTR"]
["2024-03-06","Consultation domicile",1200,"WTR"]
["2024-03-07","Administration",1050,"WTR"]
["2024-03-08","Intervention d'urgence",1050,"WTR"]
["2024-03-09","Intervention d'urgence",1050,"WTR"]

{"sheet":"Interventions_complète","index":6,"n_rows":3,"n_cols":15,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Retour"]
["Via Power Query, créez une requête qui permet d'ajouter à la liste des interventions le nom et le prénom du praticien du praticien"]
["Chargez les données ci-dessous"]

{"sheet":"Interventions_complète_Solution","index":7,"n_rows":49,"n_cols":15,"rows_kept":49,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Retour"]
["Via Power Query, créez une requête qui permet d'ajouter à la liste des interventions le nom et le prénom du praticien du praticien"]
["Chargez les données ci-dessous"]
[]
[]
[]
["Date","Type","Commune","Praticien","Nom","Prénom"]
["2024-01-06","Consultation domicile",1000,"JDE","Deuf","John"]
["2024-01-06","Consultation centre",1050,"JDE","Deuf","John"]
["2024-01-06","Consultation centre",1050,"JDE","Deuf","John"]
["2024-01-06","Consultation centre",1050,"JDE","Deuf","John"]
["2024-01-06","Consultation domicile",1060,"JDE","Deuf","John"]
["2024-01-06","Intervention d'urgence",1060,"JDE","Deuf","John"]
["2024-02-07","Intervention d'urgence",1060,"JDE","Deuf","John"]
["2024-02-08","Intervention d'urgence",1060,"JDE","Deuf","John"]
["2024-02-09","Consultation domicile",1060,"JDE","Deuf","John"]
["2024-02-10","Consultation domicile",1060,"JDE","Deuf","John"]
["2024-02-11","Consultation domicile",1060,"JDE","Deuf","John"]
["2024-04-15","Administration",1150,"JDE","Deuf","John"]
["2024-06-18","Administration",1200,"JDE","Deuf","John"]
["2024-03-05","Administration",1200,"JDE","Deuf","John"]
["2024-03-06","Consultation domicile",1200,"JDE","Deuf","John"]
["2024-03-07","Administration",1050,"JDE","Deuf","John"]
["2024-03-08","Intervention d'urgence",1050,"JDE","Deuf","John"]
["2024-03-09","Intervention d'urgence",1050,"JDE","Deuf","John"]
["2024-05-05","Intervention d'urgence",1060,"JDE","Deuf","John"]
["2024-08-10","Administration",1000,"JDE","Deuf","John"]
["2024-08-05","Consultation domicile",1000,"JDE","Deuf","John"]
["2024-06-16","Consultation domicile",1080,"JDE","Deuf","John"]
["2024-06-16","Administration",1000,"JDE","Deuf","John"]
["2024-06-16",null,null,"JDE","Deuf","John"]
["2024-01-06","Consultation domicile",1000,"WTR","Tredelè","Willy"]
["2024-01-06","Consultation centre",1050,"WTR","Tredelè","Willy"]
["2024-01-06","Consultation centre",1050,"WTR","Tredelè","Willy"]
["2024-01-06","Consultation centre",1050,"WTR","Tredelè","Willy"]
["2024-01-06","Consultation domicile",1060,"WTR","Tredelè","Willy"]
["2024-01-06","Intervention d'urgence",1060,"WTR","Tredelè","Willy"]
["2024-02-07","Intervention d'urgence",1060,"WTR","Tredelè","Willy"]
["2024-02-08","Intervention d'urgence",1060,"WTR","Tredelè","Willy"]
["2024-02-09","Consultation domicile",1060,"WTR","Tredelè","Willy"]
["2024-02-10","Consultation domicile",1060,"WTR","Tredelè","Willy"]
["2024-02-11","Consultation domicile",1060,"WTR","Tredelè","Willy"]
["2024-04-15","Administration",1150,"WTR","Tredelè","Willy"]
["2024-06-18","Administration",1200,"WTR","Tredelè","Willy"]
["2024-03-05","Administration",1200,"WTR","Tredelè","Willy"]
["2024-03-06","Consultation domicile",1200,"WTR","Tredelè","Willy"]
["2024-03-07","Administration",1050,"WTR","Tredelè","Willy"]
["2024-03-08","Intervention d'urgence",1050,"WTR","Tredelè","Willy"]
["2024-03-09","Intervention d'urgence",1050,"WTR","Tredelè","Willy"]

{"sheet":"Interventions-JDE","index":8,"n_rows":27,"n_cols":15,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
["Date","Type","Commune","Praticien","Praticien par fonction",null,null,null,null,null,null,null,null,null,"Retour"]
["2024-01-06","Consultation domicile",1000,"JDE",{"$f":"RIGHT(CELL(\"nomfichier\"),3)","v":"ire"}]
["2024-01-06","Consultation centre",1050,"JDE",{"$f":"RIGHT(CELL(\"nomfichier\"),3)","v":"ire"}]
["2024-01-06","Consultation centre",1050,"JDE",{"$f":"RIGHT(CELL(\"nomfichier\"),3)","v":"ire"}]
["2024-01-06","Consultation centre",1050,"JDE",{"$f":"RIGHT(CELL(\"nomfichier\"),3)","v":"ire"},"NB :","Il est possible de récupérer le nom de la feuille (qui reprend le code de l'intervenant) en utilisant la fonction 'Cellule'"]
["2024-01-06","Consultation domicile",1060,"JDE",{"$f":"RIGHT(CELL(\"nomfichier\"),3)","v":"ire"},null,"Le problème est qu'elle reprend le nom de la dernière feuille sur laquelle on se trouve et affiche le nom dune mauvaise feuille si nous n'actualisons pas"]
["2024-01-06","Intervention d'urgence",1060,"JDE",{"$f":"RIGHT(CELL(\"nomfichier\"),3)","v":"ire"},null,"La macro créée ici, disponible via le bouton ci-dessus permet de récupérer le nom de la feuille par formule et de le \"figer\" en copiant-collant les valeurs dans la colonne 'Praticien'"]
["2024-02-07","Intervention d'urgence",1060,"JDE",{"$f":"RIGHT(CELL(\"nomfichier\"),3)","v":"ire"}]
["2024-02-08","Intervention d'urgence",1060,"JDE",{"$f":"RIGHT(CELL(\"nomfichier\"),3)","v":"ire"},"NomFichier :",{"$f":"CELL(\"nomfichier\")","v":"https://d.docs.live.net/e5c19e8ea449bfdd/Nouveau site/Fichiers Declick/Bruxelles Formation/12. Power Query - TCD - Tableaux de bord/[TDB-Exercice02.xlsm]À faire"}]
["2024-02-09","Consultation domicile",1060,"JDE",{"$f":"RIGHT(CELL(\"nomfichier\"),3)","v":"ire"},"Position \"]\" :",{"$f":"FIND(\"]\",G9)","v":153}]
["2024-02-10","Consultation domicile",1060,"JDE",{"$f":"RIGHT(CELL(\"nomfichier\"),3)","v":"ire"},"Nom de la feuille :",{"$f":"RIGHT(G9,LEN(G9)-G10)","v":"À faire"}]
["2024-02-11","Consultation domicile",1060,"JDE",{"$f":"RIGHT(CELL(\"nomfichier\"),3)","v":"ire"}]
["2024-04-15","Administration",1150,"JDE",{"$f":"RIGHT(CELL(\"nomfichier\"),3)","v":"ire"},"NB :","Ici, nous devions uniquement reprendre les 3 derniers caractères du nom du fichier"]
["2024-06-18","Administration",1200,"JDE",{"$f":"RIGHT(CELL(\"nomfichier\"),3)","v":"ire"},null,"Mais, d'une façon plus générale, la formule ci-dessus vous permet d'obtenir le nom de la feuille"]
["2024-03-05","Administration",1200,"JDE",{"$f":"RIGHT(CELL(\"nomfichier\"),3)","v":"ire"}]
["2024-03-06","Consultation domicile",1200,"JDE",{"$f":"RIGHT(CELL(\"nomfichier\"),3)","v":"ire"},null,"NB: Un problème de la fonction 'Cellule' est qu'elle va remplacer le nom de la feuille là où elle est utilisée à chaque changement de feuille (et le reprendre sur chaque feuille)"]
["2024-03-07","Administration",1050,"JDE",{"$f":"RIGHT(CELL(\"nomfichier\"),3)","v":"ire"}]
["2024-03-08","Intervention d'urgence",1050,"JDE",{"$f":"RIGHT(CELL(\"nomfichier\"),3)","v":"ire"},null,"=> Après calcul, il faut récupérer le résultat du calcul (et donc le nom du praticien) copiant et collant la valeur"]
["2024-03-09","Intervention d'urgence",1050,"JDE",{"$f":"RIGHT(CELL(\"nomfichier\"),3)","v":"ire"}]
["2024-05-05","Intervention d'urgence",1060,"JDE",{"$f":"RIGHT(CELL(\"nomfichier\"),3)","v":"ire"},null,"=> Ceci peut se faire automatiquement par une macro créée par l'enregistreur de macro"]
["2024-08-10","Administration",1000,"JDE",{"$f":"RIGHT(CELL(\"nomfichier\"),3)","v":"ire"}]
["2024-08-05","Consultation domicile",1000,"JDE",{"$f":"RIGHT(CELL(\"nomfichier\"),3)","v":"ire"},null,"=> Les étapes de la macro :"]
["2024-06-16","Consultation domicile",1080,"JDE",{"$f":"RIGHT(CELL(\"nomfichier\"),3)","v":"ire"}]
["2024-06-16","Administration",1000,"JDE",{"$f":"RIGHT(CELL(\"nomfichier\"),3)","v":"ire"},null,null,"Effacer le contenu de lu champ 'praticien'"]
["2024-06-16",null,null,"JDE",{"$f":"RIGHT(CELL(\"nomfichier\"),3)","v":"ire"},null,null,"En ligne 2 du tableau, dans le champ 'Praticien', extraire les 3 derniers caractères de 'NomFichier'"]
[null,null,null,null,null,null,null,"Copier le champ 'Praticien'"]
[null,null,null,null,null,null,null,"Coller les valeurs"]

{"sheet":"Interventions-WTR","index":9,"n_rows":19,"n_cols":15,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["Date","Type","Commune","Praticien","Praticien par fonction",null,null,null,null,null,null,null,null,null,"Retour"]
["2024-01-06","Consultation domicile",1000,"WTR",{"$f":"RIGHT(CELL(\"nomfichier\"),3)","v":"ire"}]
["2024-01-06","Consultation centre",1050,"WTR",{"$f":"RIGHT(CELL(\"nomfichier\"),3)","v":"ire"}]
["2024-01-06","Consultation centre",1050,"WTR",{"$f":"RIGHT(CELL(\"nomfichier\"),3)","v":"ire"}]
["2024-01-06","Consultation centre",1050,"WTR",{"$f":"RIGHT(CELL(\"nomfichier\"),3)","v":"ire"}]
["2024-01-06","Consultation domicile",1060,"WTR",{"$f":"RIGHT(CELL(\"nomfichier\"),3)","v":"ire"}]
["2024-01-06","Intervention d'urgence",1060,"WTR",{"$f":"RIGHT(CELL(\"nomfichier\"),3)","v":"ire"}]
["2024-02-07","Intervention d'urgence",1060,"WTR",{"$f":"RIGHT(CELL(\"nomfichier\"),3)","v":"ire"}]
["2024-02-08","Intervention d'urgence",1060,"WTR",{"$f":"RIGHT(CELL(\"nomfichier\"),3)","v":"ire"}]
["2024-02-09","Consultation domicile",1060,"WTR",{"$f":"RIGHT(CELL(\"nomfichier\"),3)","v":"ire"}]
["2024-02-10","Consultation domicile",1060,"WTR",{"$f":"RIGHT(CELL(\"nomfichier\"),3)","v":"ire"}]
["2024-02-11","Consultation domicile",1060,"WTR",{"$f":"RIGHT(CELL(\"nomfichier\"),3)","v":"ire"}]
["2024-04-15","Administration",1150,"WTR",{"$f":"RIGHT(CELL(\"nomfichier\"),3)","v":"ire"}]
["2024-06-18","Administration",1200,"WTR",{"$f":"RIGHT(CELL(\"nomfichier\"),3)","v":"ire"}]
["2024-03-05","Administration",1200,"WTR",{"$f":"RIGHT(CELL(\"nomfichier\"),3)","v":"ire"}]
["2024-03-06","Consultation domicile",1200,"WTR",{"$f":"RIGHT(CELL(\"nomfichier\"),3)","v":"ire"}]
["2024-03-07","Administration",1050,"WTR",{"$f":"RIGHT(CELL(\"nomfichier\"),3)","v":"ire"}]
["2024-03-08","Intervention d'urgence",1050,"WTR",{"$f":"RIGHT(CELL(\"nomfichier\"),3)","v":"ire"}]
["2024-03-09","Intervention d'urgence",1050,"WTR",{"$f":"RIGHT(CELL(\"nomfichier\"),3)","v":"ire"}]

{"sheet":"Interventions-GME","index":10,"n_rows":15,"n_cols":13,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["Date","Type","Commune","Praticien",null,null,null,null,null,null,null,null,"Retour"]
["2024-01-06","Intervention d'urgence",1060,"GME"]
["2024-02-07","Intervention d'urgence",1060,"GME"]
["2024-02-08","Intervention d'urgence",1060,"GME",null,"- Faire en sorte que le CP de l'intervention soit choisi via une liste proposant tous les codes postaux"]
["2024-02-09","Consultation domicile",1060,"GME",null,"- Transformer la plage en un tableau de données"]
["2024-02-10","Consultation domicile",1060,"GME",null,"- Récupérer le nom du praticien dans une nouvelle colonne (3 dernières lettres du nom de la feuille)"]
["2024-02-11","Consultation domicile",1060,"GME"]
["2024-04-15","Administration",1150,"GME"]
["2024-03-05","Administration",1200,"GME"]
["2024-03-06","Consultation domicile",1200,"GME"]
["2024-03-07","Administration",1050,"GME"]
["2024-03-08","Intervention d'urgence",1050,"GME"]
["2024-01-06","Consultation centre",1050,"GME"]
["2024-01-06","Consultation domicile",1060,"GME"]
["2024-01-06","Intervention d'urgence",1060,"GME"]

{"sheet":"EXO-01","index":11,"n_rows":6,"n_cols":13,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["À partir de ce site :","https://fr.wikipedia.org/wiki/Liste_des_communes_de_la_r%C3%A9gion_de_Bruxelles-Capitale",null,null,null,null,null,null,null,null,null,null,"Retour"]
["Transformez les données de façon à ne garder que les colonnes telles que celles-ci-dessous "]
["Nettoyer la colonne 'Population' et renommez-la"]
["Via Power Query, ajoutez une colonne où vous calculez la densité (population/km²), arrondies à 2 décimales"]
["Chargez le résultat sur la feuille EXO-01"]
["Ajoutez à la fin une colonne CP qui sera complétée en utilisant la liste CP_Villes"]

{"sheet":"EXO-01_Solution","index":12,"n_rows":27,"n_cols":13,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
["À partir de ce site :","https://fr.wikipedia.org/wiki/Liste_des_communes_de_la_r%C3%A9gion_de_Bruxelles-Capitale",null,null,null,null,null,null,null,null,null,null,"Retour"]
["Transformez les données de façon à ne garder que les colonnes telles que celles-ci-dessous "]
["Nettoyer la colonne 'Population' et renommez-la"]
["Via Power Query, ajoutez une colonne où vous calculez la densité (population/km²), arrondies à 2 décimales"]
["Chargez le résultat sur la feuille EXO-01"]
["Ajoutez à la fin une colonne CP qui sera complétée en utilisant la liste CP_Villes"]
[]
["Nom français","Nom néerlandais","Superficie (km2)","Population (2019)","Densité","CP"]
["Anderlecht","Anderlecht",17.739999999999998,118920,6703.49,{"$f":"_xlfn.XLOOKUP(Solution_EXO_01[[#This Row],[Nom français]],CP_Villes!B2:B20,CP_Villes!A2:A20)","v":1070}]
["Auderghem","Oudergem",9.0299999999999994,33970,3761.9,{"$f":"_xlfn.XLOOKUP(Solution_EXO_01[[#This Row],[Nom français]],CP_Villes!B3:B21,CP_Villes!A3:A21)","v":1160}]
["Berchem-Sainte-Agathe","Sint-Agatha-Berchem",2.95,25195,8540.68,{"$f":"_xlfn.XLOOKUP(Solution_EXO_01[[#This Row],[Nom français]],CP_Villes!B4:B22,CP_Villes!A4:A22)","v":1082}]
["Ville de Bruxelles","Brussel (stad)",32.61,179797,5513.55,{"$f":"_xlfn.XLOOKUP(Solution_EXO_01[[#This Row],[Nom français]],CP_Villes!B5:B23,CP_Villes!A5:A23)","v":1000}]
["Etterbeek","Etterbeek",3.15,48008,15240.63,{"$f":"_xlfn.XLOOKUP(Solution_EXO_01[[#This Row],[Nom français]],CP_Villes!B6:B24,CP_Villes!A6:A24)","v":1040}]
["Evere","Evere",5.0199999999999996,41588,8284.4599999999991,{"$f":"_xlfn.XLOOKUP(Solution_EXO_01[[#This Row],[Nom français]],CP_Villes!B7:B25,CP_Villes!A7:A25)","v":1140}]
["Forest","Vorst",6.25,55925,8948,{"$f":"_xlfn.XLOOKUP(Solution_EXO_01[[#This Row],[Nom français]],CP_Villes!B8:B26,CP_Villes!A8:A26)","v":1190}]
["Ganshoren","Ganshoren",2.64,24817,9400.3799999999992,{"$f":"_xlfn.XLOOKUP(Solution_EXO_01[[#This Row],[Nom français]],CP_Villes!B9:B27,CP_Villes!A9:A27)","v":1083}]
["Ixelles","Elsene",6.34,86675,13671.14,{"$f":"_xlfn.XLOOKUP(Solution_EXO_01[[#This Row],[Nom français]],CP_Villes!B10:B28,CP_Villes!A10:A28)","v":1050}]
["Jette","Jette",5.04,52417,10400.200000000001,{"$f":"_xlfn.XLOOKUP(Solution_EXO_01[[#This Row],[Nom français]],CP_Villes!B11:B29,CP_Villes!A11:A29)","v":1090}]
["Koekelberg","Koekelberg",1.17,21961,18770.09,{"$f":"_xlfn.XLOOKUP(Solution_EXO_01[[#This Row],[Nom français]],CP_Villes!B12:B30,CP_Villes!A12:A30)","v":1081}]
["Molenbeek-Saint-Jean","Sint-Jans-Molenbeek",5.89,96501,16383.87,{"$f":"_xlfn.XLOOKUP(Solution_EXO_01[[#This Row],[Nom français]],CP_Villes!B13:B31,CP_Villes!A13:A31)","v":1080}]
["Saint-Gilles","Sint-Gillis",2.52,49715,19728.169999999998,{"$f":"_xlfn.XLOOKUP(Solution_EXO_01[[#This Row],[Nom français]],CP_Villes!B14:B32,CP_Villes!A14:A32)","v":1060}]
["Saint-Josse-ten-Noode","Sint-Joost-ten-Node",1.1399999999999999,27087,23760.53,{"$f":"_xlfn.XLOOKUP(Solution_EXO_01[[#This Row],[Nom français]],CP_Villes!B15:B33,CP_Villes!A15:A33)","v":1210}]
["Schaerbeek","Schaarbeek",8.14,131547,16160.57,{"$f":"_xlfn.XLOOKUP(Solution_EXO_01[[#This Row],[Nom français]],CP_Villes!B16:B34,CP_Villes!A16:A34)","v":1030}]
["Uccle","Ukkel",22.91,82742,3611.61,{"$f":"_xlfn.XLOOKUP(Solution_EXO_01[[#This Row],[Nom français]],CP_Villes!B17:B35,CP_Villes!A17:A35)","v":1180}]
["Watermael-Boitsfort","Watermaal-Bosvoorde",12.93,25172,1946.79,{"$f":"_xlfn.XLOOKUP(Solution_EXO_01[[#This Row],[Nom français]],CP_Villes!B18:B36,CP_Villes!A18:A36)","v":1170}]
["Woluwe-Saint-Lambert","Sint-Lambrechts-Woluwe",7.22,56496,7824.93,{"$f":"_xlfn.XLOOKUP(Solution_EXO_01[[#This Row],[Nom français]],CP_Villes!B19:B37,CP_Villes!A19:A37)","v":1200}]
["Woluwe-Saint-Pierre","Sint-Pieters-Woluwe",8.85,41789,4721.92,{"$f":"_xlfn.XLOOKUP(Solution_EXO_01[[#This Row],[Nom français]],CP_Villes!B20:B38,CP_Villes!A20:A38)","v":1150}]

{"sheet":"EXO-02","index":13,"n_rows":5,"n_cols":14,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Retour"]
["Dupliquez la 'query' EXO-01 en EXO-02"]
["En combinant les requêtes, faites en sorte que le CP de chaque ville soit récupéré de la liste CP_Villes"]
["NB : Une 'query' de type connexion uniquement a été créée"]
["Récupérez les données sur la feuille EXO-02"]

{"sheet":"EXO-02_Solution","index":14,"n_rows":28,"n_cols":14,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Retour"]
["Dupliquez la 'query' EXO-01 en EXO-02"]
["En combinant les requêtes, faites en sorte que le CP de chaque ville soit récupéré de la liste CP_Villes"]
["NB : Une 'query' CP_Villes de type connexion uniquement existe"]
["Recupérez les données sur la feuille EXO-02"]
[]
[]
[]
["Nom français","Nom néerlandais","CP","Superficie (km2)","Population (2019)","Densité"]
["Anderlecht","Anderlecht",1070,17.739999999999998,118920,6703.49]
["Auderghem","Oudergem",1160,9.0299999999999994,33970,3761.9]
["Berchem-Sainte-Agathe","Sint-Agatha-Berchem",1082,2.95,25195,8540.68]
["Ville de Bruxelles","Brussel (stad)",1000,32.61,179797,5513.55]
["Etterbeek","Etterbeek",1040,3.15,48008,15240.63]
["Evere","Evere",1140,5.0199999999999996,41588,8284.4599999999991]
["Forest","Vorst",1190,6.25,55925,8948]
["Ganshoren","Ganshoren",1083,2.64,24817,9400.3799999999992]
["Ixelles","Elsene",1050,6.34,86675,13671.14]
["Jette","Jette",1090,5.04,52417,10400.200000000001]
["Koekelberg","Koekelberg",1081,1.17,21961,18770.09]
["Molenbeek-Saint-Jean","Sint-Jans-Molenbeek",1080,5.89,96501,16383.87]
["Saint-Gilles","Sint-Gillis",1060,2.52,49715,19728.169999999998]
["Saint-Josse-ten-Noode","Sint-Joost-ten-Node",1210,1.1399999999999999,27087,23760.53]
["Schaerbeek","Schaarbeek",1030,8.14,131547,16160.57]
["Uccle","Ukkel",1180,22.91,82742,3611.61]
["Watermael-Boitsfort","Watermaal-Bosvoorde",1170,12.93,25172,1946.79]
["Woluwe-Saint-Lambert","Sint-Lambrechts-Woluwe",1200,7.22,56496,7824.93]
["Woluwe-Saint-Pierre","Sint-Pieters-Woluwe",1150,8.85,41789,4721.92]

{"sheet":"EXO-03","index":15,"n_rows":3,"n_cols":14,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Retour"]
["Utilisez les données de la feuille 'Interventions' et les données de 'CP_Villes de façon à créer un TCD"]
["donnant le nombre d'interventions par Commune. Ici la relation entre le CP et la commune est faite en construisant le TCD"]

{"sheet":"EXO-03_Solution","index":16,"n_rows":23,"n_cols":14,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Retour"]
["Utilisez les données de la feuille 'Interventions' et les données de 'CP_Villes de façon à créer un TCD"]
["donnant le nombre d'interventions par Commune. Ici la relation entre le CP et la commune est faite en construisant le TCD"]
["Ajoutez le nom du praticien en regroupement 'colonne'"]
[]
[]
[]
[]
[]
[]
[]
[null,"Nombre d'intervention","Praticien"]
[null,"Communes","Deuf","Tredelè","Total général"]
[null,"Ixelles",6,6,12]
[null,"Molenbeek-Saint-Jean",1,null,1]
[null,"Saint-Gilles",8,7,15]
[null,"Ville de Bruxelles",4,1,5]
[null,"Woluwe-Saint-Lambert",3,3,6]
[null,"Woluwe-Saint-Pierre",1,1,2]
[null,"(vide)",1,null,1]
[null,"Total général",24,18,42]
[]
["NB :","Les relations peuvent être visualisées via le bouton 'Relations' du ruban contextuel des TCD"]