{"text_format":"1","workbook":"xlsx","n_sheets":24,"sheets":["Sommaire","Question1","Question1_Solution","Question2","Question2_Solution","Les familles du net","Reconstruire liste des familles","Compter par TCD","Compter par Power Query","Question3","Question4","Question5","Question6","Question7","Question7_Solution","GroupeA","GroupeB","GroupeC","DatasGroupées1","DatasGroupées1_Solution","DatasGroupées2","DatasGroupées2_Solution","Tableau de bord","Tableau de bord_Solution"],"not_rendered":{"charts":2,"images":5,"macros":1,"external_links":0,"defined_names":10,"comments":0,"pivot_tables":3},"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":"Sommaire","index":0,"n_rows":31,"n_cols":4,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
[]
["Exercices sur la fonction SI, les filtres avancés, les tableaux de bord et une introduction à Power Query"]
[]
[]
[]
[]
[null,"La fonction SI :","Question1","Un exercice pour l'échauffement (exo1) et un autre pour les experts"]
[]
[null,null,"Question2","Un petit 3ème pour la route J"]
[]
[null,"Les filtres avancés :","Question3","Filtre avancé avec 1 critère"]
[]
[null,null,"Question4","Filtre avancé avec 2 critères"]
[]
[null,null,"Question5","Filtre avancé avec 2 critères"]
[]
[null,null,"Question6","Filtre avancé avec plusieurs critères sur plusieurs champs (colonnes)"]
[]
[null,null,"Question7","Filtre avancé avec l'utilisation de fonction dans le critère"]
[]
[null,"Les combinaisons de données :","DatasGroupées1","Utilisation des fonctions pour regrouper les données de plusieurs tableaux en un seul"]
[]
[null,null,"DatasGroupées2","Une petite intro à Power Query pour combiner les données de plusieurs tableaux"]
[]
[null,"Création d'un tableau de bord :","Tableau de bord","Un tableau de bord nous permet d'évaluer rapidement les données dont on dispose"]
[]
[null,"Et …","Reconstruire liste","Une petite intro à l'utilisation de Power Query pour reconstruire un tableau de données mal conçu"]
[]
[null,null,"Compter par TCD","Effectuer des regroupements sur le tableau 'reconstruit' en utilisant un TCD"]
[]
[null,null,"Compter par Power Query","Effectuer des regroupements sur le tableau 'reconstruit' en utilisant Power Query"]

{"sheet":"Question1","index":1,"n_rows":31,"n_cols":13,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,"Retour Sommaire"]
["Exo1 :","Dans la colonne 'Gros montant' écrire \"OUI\" si le montant dû est >= 1000€, \"NON\" dans le cas contraire"]
[]
["Exo2:","Aidez monsieur Raquerunmax Yvon, le contrôleur des impôts, à établir ses lettres de rappel en calculant pour lui les frais de retard à payer selon ceci :"]
[null,"- Pas de frais administratifs pour les gens qui ont payé ni pour les gens dont la date limite n'est pas encore atteinte"]
[null,"- Des frais administratifs de 15 € pour les gens qui ont moins de 15 jours de retard"]
[null,"- Des frais de 50 € pour les gens qui ont 15 jours de retard ou plus"]
[]
[]
["Prénom du\ncontribuable","Nom du\ncontribuable","Ville","Montant\nà payer","Gros montant","Date limite\nde payement","A payé","Montant des frais de retard"]
["Elvire","Auvertcestpasbon","Namur",980,null,"2025-01-27","oui"]
["Itiative","Namuralanagecestdifficile","Namur",500,null,"2025-01-12","oui"]
["Yves","Egète","Bruxelles",300,null,"2025-01-12","non"]
["Thibault","Chmonfils ","Bruxelles",1500,null,"2024-12-18","non"]
["Thierry","Chmonfils ","Bruxelles",1254,null,"2025-01-25","non"]
["Mélusine","Enfaillite","Bruxelles",630,null,"2025-01-02","oui"]
["Agathe","Depower","Bruxelles",600,null,"2024-12-25","non"]
["Ken","Bowie","Bruxelles",600,null,"2024-12-28","non"]
["Alain","Di","Bruxelles",500,null,"2024-12-17","non"]
["Sylva","Froid","Bruxelles",500,null,"2024-12-20","non"]
["Aude","Froid","Bruxelles",240,null,"2025-01-18","non"]
["Anne","Froid","Anvers",1050,null,"2025-01-06","non"]
["Marc","Froid","Anvers",1050,null,"2025-01-06","non"]
["Laura","Froid","Anvers",120,null,"2025-01-26","non"]
["Douglas","Alavanilleplease","Anvers",400,null,"2025-02-12","non"]
["Voczcek","Enbois","Anvers",200,null,"2025-02-14","non"]
["Agathe","Deblouze","Namur",1400,null,"2024-12-21","non"]
["Steve","Euxdugateauyenadanslefrigo ","Anvers",120,null,"2025-02-10","non"]
["Marc","Heurindélébil ","Anvers",250,null,"2024-12-18","oui"]
["Willy","Tredelè","Anvers",300,null,"2025-01-06","non"]
["Roger","Soif","Bruxelles",580,null,"2025-01-27","non"]

{"sheet":"Question1_Solution","index":2,"n_rows":31,"n_cols":13,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,"Retour Sommaire"]
["Exo1 :","Dans la colonne 'Gros montant' écrire \"OUI\" si le montant dû est >= 1000€, \"NON\" dans le cas contraire"]
[]
["Exo2:","Aidez monsieur Raquerunmax Yvon, le contrôleur des impôts, à établir ses lettres de rappel en calculant pour lui les frais de retard à payer selon ceci :"]
[null,"- Pas de frais administratifs pour les gens qui ont payé ni pour les gens dont la date limite n'est pas encore atteinte"]
[null,"- Des frais administratifs de 15 € pour les gens qui ont moins de 15 jours de retard"]
[null,"- Des frais de 50 € pour les gens qui ont 15 jours de retard ou plus"]
[]
[]
["Prénom du\ncontribuable","Nom du\ncontribuable","Ville","Montant\nà payer","Gros montant","Date limite\nde payement","A payé","Montant des frais de retard"]
["Elvire","Auvertcestpasbon","Namur",980,{"$f":"IF(D11>=1000,\"OUI\",\"NON\")","v":"NON"},{"$f":"Question1!F11","v":"2025-01-27"},"oui",{"$f":"_xlfn.IFS(OR(G11=\"OUI\",F11>=TODAY()),0,TODAY()-F11<15,20,TODAY()-F11>=15,50)","v":0}]
["Ferdinand","Namuralanagecestdifficile","Namur",500,{"$f":"IF(D12>=1000,\"OUI\",\"NON\")","v":"NON"},{"$f":"Question1!F12","v":"2025-01-12"},"oui",{"$f":"_xlfn.IFS(OR(G12=\"OUI\",F12>=TODAY()),0,TODAY()-F12<15,20,TODAY()-F12>=15,50)","v":0},null,"SI 'Montant à payer' >= 1000"]
["Yves","Egète","Bruxelles",300,"NON",{"$f":"Question1!F13","v":"2025-01-12"},"non",{"$f":"_xlfn.IFS(OR(G13=\"OUI\",F13>=TODAY()),0,TODAY()-F13<15,20,TODAY()-F13>=15,50)","v":20},null,"ALORS \"OUI"]
["Thibault","Chmonfils ","Bruxelles",1500,"OUI",{"$f":"Question1!F14","v":"2024-12-18"},"non",{"$f":"_xlfn.IFS(OR(G14=\"OUI\",F14>=TODAY()),0,TODAY()-F14<15,20,TODAY()-F14>=15,50)","v":50},null,"SINON \"NON\""]
["Thierry","Chmonfils ","Bruxelles",1254,"OUI",{"$f":"Question1!F15","v":"2025-01-25"},"non",{"$f":"_xlfn.IFS(OR(G15=\"OUI\",F15>=TODAY()),0,TODAY()-F15<15,20,TODAY()-F15>=15,50)","v":0}]
["Mélusine","Enfaillite","Bruxelles",630,"NON",{"$f":"Question1!F16","v":"2025-01-02"},"oui",{"$f":"_xlfn.IFS(OR(G16=\"OUI\",F16>=TODAY()),0,TODAY()-F16<15,20,TODAY()-F16>=15,50)","v":0}]
["Agathe","Depower","Bruxelles",600,"NON",{"$f":"Question1!F17","v":"2024-12-25"},"non",{"$f":"_xlfn.IFS(OR(G17=\"OUI\",F17>=TODAY()),0,TODAY()-F17<15,20,TODAY()-F17>=15,50)","v":50},null,"Si 'A payé' = \"OUI\" OU 'Date limite' > AUJOURDHUI() ALORS 0"]
["Ken","Bowie","Bruxelles",600,"NON",{"$f":"Question1!F18","v":"2024-12-28"},"non",{"$f":"_xlfn.IFS(OR(G18=\"OUI\",F18>=TODAY()),0,TODAY()-F18<15,20,TODAY()-F18>=15,50)","v":50},null,"Si AUJOURDHUI() - 'Date limite'  < 15 ALORS 20"]
["Alain","Di","Bruxelles",500,"NON",{"$f":"Question1!F19","v":"2024-12-17"},"non",{"$f":"_xlfn.IFS(OR(G19=\"OUI\",F19>=TODAY()),0,TODAY()-F19<15,20,TODAY()-F19>=15,50)","v":50},null,"Si AUJOURDHUI() - 'Date limite' >= 15 ALORS 50"]
["Sylva","Froid","Bruxelles",500,"NON",{"$f":"Question1!F20","v":"2024-12-20"},"non",{"$f":"_xlfn.IFS(OR(G20=\"OUI\",F20>=TODAY()),0,TODAY()-F20<15,20,TODAY()-F20>=15,50)","v":50}]
["Aude","Froid","Bruxelles",240,"NON",{"$f":"Question1!F21","v":"2025-01-18"},"non",{"$f":"_xlfn.IFS(OR(G21=\"OUI\",F21>=TODAY()),0,TODAY()-F21<15,20,TODAY()-F21>=15,50)","v":0}]
["Anne","Froid","Anvers",1050,"OUI",{"$f":"Question1!F22","v":"2025-01-06"},"non",{"$f":"_xlfn.IFS(OR(G22=\"OUI\",F22>=TODAY()),0,TODAY()-F22<15,20,TODAY()-F22>=15,50)","v":20}]
["Marc","Froid","Anvers",1050,"OUI",{"$f":"Question1!F23","v":"2025-01-06"},"non",{"$f":"_xlfn.IFS(OR(G23=\"OUI\",F23>=TODAY()),0,TODAY()-F23<15,20,TODAY()-F23>=15,50)","v":20}]
["Laura","Froid","Anvers",120,"NON",{"$f":"Question1!F24","v":"2025-01-26"},"non",{"$f":"_xlfn.IFS(OR(G24=\"OUI\",F24>=TODAY()),0,TODAY()-F24<15,20,TODAY()-F24>=15,50)","v":0}]
["Douglas","Alavanilleplease","Anvers",400,"NON",{"$f":"Question1!F25","v":"2025-02-12"},"non",{"$f":"_xlfn.IFS(OR(G25=\"OUI\",F25>=TODAY()),0,TODAY()-F25<15,20,TODAY()-F25>=15,50)","v":0}]
["Voczcek","Enbois","Anvers",200,"NON",{"$f":"Question1!F26","v":"2025-02-14"},"non",{"$f":"_xlfn.IFS(OR(G26=\"OUI\",F26>=TODAY()),0,TODAY()-F26<15,20,TODAY()-F26>=15,50)","v":0}]
["Agathe","Deblouze","Namur",1400,"OUI",{"$f":"Question1!F27","v":"2024-12-21"},"non",{"$f":"_xlfn.IFS(OR(G27=\"OUI\",F27>=TODAY()),0,TODAY()-F27<15,20,TODAY()-F27>=15,50)","v":50}]
["Steve","Euxdugateauyenadanslefrigo ","Anvers",120,"NON",{"$f":"Question1!F28","v":"2025-02-10"},"non",{"$f":"_xlfn.IFS(OR(G28=\"OUI\",F28>=TODAY()),0,TODAY()-F28<15,20,TODAY()-F28>=15,50)","v":0}]
["Marc","Heurindélébil ","Anvers",250,"NON",{"$f":"Question1!F29","v":"2024-12-18"},"oui",{"$f":"_xlfn.IFS(OR(G29=\"OUI\",F29>=TODAY()),0,TODAY()-F29<15,20,TODAY()-F29>=15,50)","v":0}]
["Willy","Tredelè","Anvers",300,"NON",{"$f":"Question1!F30","v":"2025-01-06"},"non",{"$f":"_xlfn.IFS(OR(G30=\"OUI\",F30>=TODAY()),0,TODAY()-F30<15,20,TODAY()-F30>=15,50)","v":20}]
["Roger","Soif","Bruxelles",580,"NON",{"$f":"Question1!F31","v":"2025-01-27"},"non",{"$f":"_xlfn.IFS(OR(G31=\"OUI\",F31>=TODAY()),0,TODAY()-F31<15,20,TODAY()-F31>=15,50)","v":0}]

{"sheet":"Question2","index":3,"n_rows":31,"n_cols":13,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,"Retour Sommaire"]
["Voici le nombre d'enfants de certaines familles bien connues du net. Calculez les allocations familiales que chaque famille va recevoir selon ceci :"]
["NB: il suffit d'une famille classique où le père est salarié et le revenu brut du ménage est > 2.131,19 €"]
["     - 83,40 € pour le premier."]
["     - 154,33 € pour le 2è enfant"]
["     - 230,42 € pour les autres enfants à partir du 3è"]
[]
[]
[]
[null,"Familles","Nombre\nd'enfants","Allocations\nà recevoir"]
[null,"Enfant",2]
[null,"Térieur",2]
[null,"Lalalalala",2]
[null,"Hole",4]
[null,"Froid",5]
[null,"Chmonfils",2]
[null,"Estcassée",2]
[null,"Aihunbutte",2]
[null,"Danslefrigo",3]
[null,"Dikulizer",2]
[null,"Durine",2]
[null,"Itiative",3]
[null,"Izrich",2]
[null,"Jyraipas",4]
[null,"Mental",2]
[null,"Mieux",2]
[null,"Nains",3]
[null,"Pachaire",3]
[null,"Pourien",3]
[null,"Tuation",4]
[null,"Form",2]

{"sheet":"Question2_Solution","index":4,"n_rows":31,"n_cols":13,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,"Retour Sommaire"]
["Voici le nombre d'enfants de certaines familles bien connues du net. Calculez les allocations familiales que chaque famille va recevoir selon ceci :"]
["NB: il suffit d'une famille classique où le père est salarié et le revenu brut du ménage est > 2.131,19 €"]
["     - 83,40 € pour le premier."]
["     - 154,33 € pour le 2è enfant"]
["     - 230,42 € pour les autres enfants à partir du 3è"]
[]
[]
[]
[null,"Familles","Nombre\nd'enfants","Allocations\nà recevoir"]
[null,"Enfant",2,{"$f":"_xlfn.IFS(C11=1,83.4,C11=2,83.4+154.33,C11>2,83.4+154.33+(C11-2)*230.42)","v":237.73000000000002},null,null,"Si Nbre d'enfants = 1 ALORS 83,40"]
[null,"Térieur",2,{"$f":"_xlfn.IFS(C12=1,83.4,C12=2,83.4+154.33,C12>2,83.4+154.33+(C12-2)*230.42)","v":237.73000000000002},null,null,"SI Nbre d'enfants = 2 ALORS 83,40 + 154,33"]
[null,"Lalalalala",2,{"$f":"_xlfn.IFS(C13=1,83.4,C13=2,83.4+154.33,C13>2,83.4+154.33+(C13-2)*230.42)","v":237.73000000000002},null,null,"Si Nbre d'enfants > 2 ALORS 83,40 + 154,33 + (Nbre d'enfants - 2) * 230,42"]
[null,"Hole",4,{"$f":"_xlfn.IFS(C14=1,83.4,C14=2,83.4+154.33,C14>2,83.4+154.33+(C14-2)*230.42)","v":698.56999999999994}]
[null,"Froid",5,{"$f":"_xlfn.IFS(C15=1,83.4,C15=2,83.4+154.33,C15>2,83.4+154.33+(C15-2)*230.42)","v":928.99}]
[null,"Chmonfils",2,{"$f":"_xlfn.IFS(C16=1,83.4,C16=2,83.4+154.33,C16>2,83.4+154.33+(C16-2)*230.42)","v":237.73000000000002}]
[null,"Estcassée",2,{"$f":"_xlfn.IFS(C17=1,83.4,C17=2,83.4+154.33,C17>2,83.4+154.33+(C17-2)*230.42)","v":237.73000000000002}]
[null,"Aihunbutte",2,{"$f":"_xlfn.IFS(C18=1,83.4,C18=2,83.4+154.33,C18>2,83.4+154.33+(C18-2)*230.42)","v":237.73000000000002}]
[null,"Danslefrigo",3,{"$f":"_xlfn.IFS(C19=1,83.4,C19=2,83.4+154.33,C19>2,83.4+154.33+(C19-2)*230.42)","v":468.15}]
[null,"Dikulizer",2,{"$f":"_xlfn.IFS(C20=1,83.4,C20=2,83.4+154.33,C20>2,83.4+154.33+(C20-2)*230.42)","v":237.73000000000002}]
[null,"Durine",2,{"$f":"_xlfn.IFS(C21=1,83.4,C21=2,83.4+154.33,C21>2,83.4+154.33+(C21-2)*230.42)","v":237.73000000000002}]
[null,"Itiative",3,{"$f":"_xlfn.IFS(C22=1,83.4,C22=2,83.4+154.33,C22>2,83.4+154.33+(C22-2)*230.42)","v":468.15}]
[null,"Izrich",2,{"$f":"_xlfn.IFS(C23=1,83.4,C23=2,83.4+154.33,C23>2,83.4+154.33+(C23-2)*230.42)","v":237.73000000000002}]
[null,"Jyraipas",4,{"$f":"_xlfn.IFS(C24=1,83.4,C24=2,83.4+154.33,C24>2,83.4+154.33+(C24-2)*230.42)","v":698.56999999999994}]
[null,"Mental",2,{"$f":"_xlfn.IFS(C25=1,83.4,C25=2,83.4+154.33,C25>2,83.4+154.33+(C25-2)*230.42)","v":237.73000000000002}]
[null,"Mieux",2,{"$f":"_xlfn.IFS(C26=1,83.4,C26=2,83.4+154.33,C26>2,83.4+154.33+(C26-2)*230.42)","v":237.73000000000002}]
[null,"Nains",3,{"$f":"_xlfn.IFS(C27=1,83.4,C27=2,83.4+154.33,C27>2,83.4+154.33+(C27-2)*230.42)","v":468.15}]
[null,"Pachaire",3,{"$f":"_xlfn.IFS(C28=1,83.4,C28=2,83.4+154.33,C28>2,83.4+154.33+(C28-2)*230.42)","v":468.15}]
[null,"Pourien",3,{"$f":"_xlfn.IFS(C29=1,83.4,C29=2,83.4+154.33,C29>2,83.4+154.33+(C29-2)*230.42)","v":468.15}]
[null,"Tuation",4,{"$f":"_xlfn.IFS(C30=1,83.4,C30=2,83.4+154.33,C30>2,83.4+154.33+(C30-2)*230.42)","v":698.56999999999994}]
[null,"Form",2,{"$f":"_xlfn.IFS(C31=1,83.4,C31=2,83.4+154.33,C31>2,83.4+154.33+(C31-2)*230.42)","v":237.73000000000002}]

{"sheet":"Les familles du net","index":5,"n_rows":31,"n_cols":13,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Retour Sommaire"]
[null,"Nom","Prénoms","Nombre d'enfants"]
[null,"Enfant","Hélène et Ludivine",2]
[null,"Térieur","Alain, Alex",2]
[null,"Lalalalala","Strasky et Hutch",2]
[null,"Hole","Jenny, Diane, Beth, Nicole",4,null,"Exercice : Ajouter la famille Cale dont les enfants se prénomment Anna, Lise et Mehdi"]
[null,"Froid","Sylva, Aude, Anne, Mark, Laura",5]
[null,"Chmonfils","Thibault et Thierry",2]
[null,"Estcassée","Sarah, Kate",2]
[null,"Aihunbutte","Yvon, Marc",2]
[null,"Danslefrigo","Ella, Djamilah, Charlotte",3]
[null,"Dikulizer","Elle, Valérie",2]
[null,"Durine","Anna, Lise",2]
[null,"Itiative","Samson, Marielle, Adeline",3]
[null,"Izrich","Maïté, Laure",2]
[null,"Jyraipas","Frédéric, François, Chantal, Olympia",4]
[null,"Mental","Ted et Bill",2]
[null,"Mieux","Jeff, Edmond",2]
[null,"Nains","Blanche, Neige et Lucette",3]
[null,"Pachaire","Yvan, Sam, Otto",3]
[null,"Pourien","Yvon, Pol et Mickey",3]
[null,"Tuation","Elle, Anna, Lise, Lacie",4]
[null,"Form","Hans, Hubert",2]
[null,"Monlatin","Jean et Pierre",2]
[null,"Tretou","Jean, Régis",2]
[null,"Leschoses","Lazarre et Fabien",2]
[null,"Lesdentverte","Samantha, Laurent",2]
[null,"Ule","Thierry, Dick",2]

{"sheet":"Reconstruire liste des familles","index":6,"n_rows":67,"n_cols":13,"rows_kept":67,"cut":false,"hidden":false,"merged":[]}
["Nom","Valeur",null,null,null,null,null,null,null,null,null,null,"Retour Sommaire"]
["Enfant","Hélène"]
["Enfant","Ludivine"]
["Térieur","Alain"]
["Térieur","Alex"]
["Lalalalala","Strasky"]
["Lalalalala","Hutch",null,null,"À partir du tableau 'Les familles du net', reconstruisez le tableau de façon à avoir un seul enfant par ligne"]
["Hole","Jenny"]
["Hole","Diane",null,null,"La colonne du nombre d'enfants est une colonne de synthèse et peut être obtenue d'autres façons :"]
["Hole","Beth"]
["Hole","Nicole",null,null,"=> Via un TCD, via des fonctions classiques ou via la fonctionnalité de regroupement de Power Query"]
["Froid","Sylva"]
["Froid","Aude"]
["Froid","Anne"]
["Froid","Mark"]
["Froid","Laura"]
["Chmonfils","Thibault"]
["Chmonfils","Thierry"]
["Estcassée","Sarah"]
["Estcassée","Kate"]
["Aihunbutte","Yvon"]
["Aihunbutte","Marc"]
["Danslefrigo","Ella"]
["Danslefrigo","Djamilah"]
["Danslefrigo","Charlotte"]
["Dikulizer","Elle"]
["Dikulizer","Valérie"]
["Durine","Anna"]
["Durine","Lise"]
["Itiative","Samson"]
["Itiative","Marielle"]
["Itiative","Adeline"]
["Izrich","Maïté"]
["Izrich","Laure"]
["Jyraipas","Frédéric"]
["Jyraipas","François"]
["Jyraipas","Chantal"]
["Jyraipas","Olympia"]
["Mental","Ted"]
["Mental","Bill"]
["Mieux","Jeff"]
["Mieux","Edmond"]
["Nains","Blanche"]
["Nains","Neige"]
["Nains","Lucette"]
["Pachaire","Yvan"]
["Pachaire","Sam"]
["Pachaire","Otto"]
["Pourien","Yvon"]
["Pourien","Pol"]
["Pourien","Mickey"]
["Tuation","Elle"]
["Tuation","Anna"]
["Tuation","Lise"]
["Tuation","Lacie"]
["Form","Hans"]
["Form","Hubert"]
["Monlatin","Jean"]
["Monlatin","Pierre"]
["Tretou","Jean"]
["Tretou","Régis"]
["Leschoses","Lazarre"]
["Leschoses","Fabien"]
["Lesdentverte","Samantha"]
["Lesdentverte","Laurent"]
["Ule","Thierry"]
["Ule","Dick"]

{"sheet":"Compter par TCD","index":7,"n_rows":35,"n_cols":13,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,"Retour Sommaire"]
[]
[]
[]
[]
[]
[null,"Nombre de Valeur"]
[null,"Nom","Total"]
[null,"Aihunbutte",2,null,null,null,null,null,"À partir du tableau 'reconstruit', utilisez un TCD afin d'obtenir le nombre d'enfants par famille"]
[null,"Chmonfils",2,null,null,null,null,null,"Créer ensuite une macro qui permet d'actualiser le TCD"]
[null,"Danslefrigo",3]
[null,"Dikulizer",2]
[null,"Durine",2]
[null,"Enfant",2]
[null,"Estcassée",2]
[null,"Form",2]
[null,"Froid",5]
[null,"Hole",4]
[null,"Itiative",3]
[null,"Izrich",2]
[null,"Jyraipas",4]
[null,"Lalalalala",2]
[null,"Leschoses",2]
[null,"Lesdentverte",2]
[null,"Mental",2]
[null,"Mieux",2]
[null,"Monlatin",2]
[null,"Nains",3]
[null,"Pachaire",3]
[null,"Pourien",3]
[null,"Térieur",2]
[null,"Tretou",2]
[null,"Tuation",4]
[null,"Ule",2]
[null,"Total général",66]

{"sheet":"Compter par Power Query","index":8,"n_rows":27,"n_cols":12,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
["Nom","Nombre","Alloc",null,null,null,null,null,null,null,null,"Retour Sommaire"]
["Aihunbutte",2,{"$f":"_xlfn.IFS(B2=1,83.4,B2=2,83.4+154.33,B2>2,83.4+154.33+(B2-2)*230.42)","v":237.73000000000002}]
["Chmonfils",2,{"$f":"_xlfn.IFS(B3=1,83.4,B3=2,83.4+154.33,B3>2,83.4+154.33+(B3-2)*230.42)","v":237.73000000000002}]
["Danslefrigo",3,{"$f":"_xlfn.IFS(B4=1,83.4,B4=2,83.4+154.33,B4>2,83.4+154.33+(B4-2)*230.42)","v":468.15}]
["Dikulizer",2,{"$f":"_xlfn.IFS(B5=1,83.4,B5=2,83.4+154.33,B5>2,83.4+154.33+(B5-2)*230.42)","v":237.73000000000002}]
["Durine",2,{"$f":"_xlfn.IFS(B6=1,83.4,B6=2,83.4+154.33,B6>2,83.4+154.33+(B6-2)*230.42)","v":237.73000000000002}]
["Enfant",2,{"$f":"_xlfn.IFS(B7=1,83.4,B7=2,83.4+154.33,B7>2,83.4+154.33+(B7-2)*230.42)","v":237.73000000000002}]
["Estcassée",2,{"$f":"_xlfn.IFS(B8=1,83.4,B8=2,83.4+154.33,B8>2,83.4+154.33+(B8-2)*230.42)","v":237.73000000000002}]
["Form",2,{"$f":"_xlfn.IFS(B9=1,83.4,B9=2,83.4+154.33,B9>2,83.4+154.33+(B9-2)*230.42)","v":237.73000000000002},null,null,null,null,"À partir du tableau 'reconstruit', utilisez Power Query afin d'obtenir le nombre d'enfants par famille"]
["Froid",5,{"$f":"_xlfn.IFS(B10=1,83.4,B10=2,83.4+154.33,B10>2,83.4+154.33+(B10-2)*230.42)","v":928.99},null,null,null,null,"Ajoutez ensuite une colonne avec le calcul des allocations (CF Question2)"]
["Hole",4,{"$f":"_xlfn.IFS(B11=1,83.4,B11=2,83.4+154.33,B11>2,83.4+154.33+(B11-2)*230.42)","v":698.56999999999994}]
["Itiative",3,{"$f":"_xlfn.IFS(B12=1,83.4,B12=2,83.4+154.33,B12>2,83.4+154.33+(B12-2)*230.42)","v":468.15}]
["Izrich",2,{"$f":"_xlfn.IFS(B13=1,83.4,B13=2,83.4+154.33,B13>2,83.4+154.33+(B13-2)*230.42)","v":237.73000000000002}]
["Jyraipas",4,{"$f":"_xlfn.IFS(B14=1,83.4,B14=2,83.4+154.33,B14>2,83.4+154.33+(B14-2)*230.42)","v":698.56999999999994}]
["Lalalalala",2,{"$f":"_xlfn.IFS(B15=1,83.4,B15=2,83.4+154.33,B15>2,83.4+154.33+(B15-2)*230.42)","v":237.73000000000002}]
["Leschoses",2,{"$f":"_xlfn.IFS(B16=1,83.4,B16=2,83.4+154.33,B16>2,83.4+154.33+(B16-2)*230.42)","v":237.73000000000002}]
["Lesdentverte",2,{"$f":"_xlfn.IFS(B17=1,83.4,B17=2,83.4+154.33,B17>2,83.4+154.33+(B17-2)*230.42)","v":237.73000000000002}]
["Mental",2,{"$f":"_xlfn.IFS(B18=1,83.4,B18=2,83.4+154.33,B18>2,83.4+154.33+(B18-2)*230.42)","v":237.73000000000002}]
["Mieux",2,{"$f":"_xlfn.IFS(B19=1,83.4,B19=2,83.4+154.33,B19>2,83.4+154.33+(B19-2)*230.42)","v":237.73000000000002}]
["Monlatin",2,{"$f":"_xlfn.IFS(B20=1,83.4,B20=2,83.4+154.33,B20>2,83.4+154.33+(B20-2)*230.42)","v":237.73000000000002}]
["Nains",3,{"$f":"_xlfn.IFS(B21=1,83.4,B21=2,83.4+154.33,B21>2,83.4+154.33+(B21-2)*230.42)","v":468.15}]
["Pachaire",3,{"$f":"_xlfn.IFS(B22=1,83.4,B22=2,83.4+154.33,B22>2,83.4+154.33+(B22-2)*230.42)","v":468.15}]
["Pourien",3,{"$f":"_xlfn.IFS(B23=1,83.4,B23=2,83.4+154.33,B23>2,83.4+154.33+(B23-2)*230.42)","v":468.15}]
["Tretou",2,{"$f":"_xlfn.IFS(B24=1,83.4,B24=2,83.4+154.33,B24>2,83.4+154.33+(B24-2)*230.42)","v":237.73000000000002}]
["Tuation",4,{"$f":"_xlfn.IFS(B25=1,83.4,B25=2,83.4+154.33,B25>2,83.4+154.33+(B25-2)*230.42)","v":698.56999999999994}]
["Térieur",2,{"$f":"_xlfn.IFS(B26=1,83.4,B26=2,83.4+154.33,B26>2,83.4+154.33+(B26-2)*230.42)","v":237.73000000000002}]
["Ule",2,{"$f":"_xlfn.IFS(B27=1,83.4,B27=2,83.4+154.33,B27>2,83.4+154.33+(B27-2)*230.42)","v":237.73000000000002}]

{"sheet":"Question3","index":9,"n_rows":9,"n_cols":12,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["A partir de la feuille \"Les familles du net\", affichez les prénoms des enfants dont le nom est choisi via la liste des noms",null,null,null,null,null,null,null,null,null,null,"Retour Sommaire"]
[]
[]
[null,"Nom"]
[null,"Estcassée"]
[]
[]
[]
[null,"Prénom"]

{"sheet":"Question4","index":10,"n_rows":1,"n_cols":13,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["A partir de la feuille 'Question1', affichez les lignes qui correspondent aux gens de Bruxelles et de Namur",null,null,null,null,null,null,null,null,null,null,null,"Retour Sommaire"]

{"sheet":"Question5","index":11,"n_rows":1,"n_cols":13,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["A partir de 'Question1', affichez les noms des familles et prénoms des gens dont le montant dû est compris entre 500€ et 999€",null,null,null,null,null,null,null,null,null,null,null,"Retour Sommaire"]

{"sheet":"Question6","index":12,"n_rows":1,"n_cols":13,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["A partir de la feuille 'Question1', affichez les lignes qui correspondent aux gens de Bruxelles et de Namur et dont le montant dû est compris entre 500€ et 999€",null,null,null,null,null,null,null,null,null,null,null,"Retour Sommaire"]

{"sheet":"Question7","index":13,"n_rows":1,"n_cols":13,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["A partir de la feuille 'Question1', affichez les lignes qui correspondent aux gens qui n'ont pas encore payé et dont la date limite de payement est dépassée",null,null,null,null,null,null,null,null,null,null,null,"Retour Sommaire"]

{"sheet":"Question7_Solution","index":14,"n_rows":20,"n_cols":13,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
["A partir de la feuille 'Question1', affichez les lignes qui correspondent aux gens qui n'ont pas encore payé et dont la date limite de payement est dépassée",null,null,null,null,null,null,null,null,null,null,null,"Retour Sommaire"]
[]
[null,null,null,"A payé","Date limite\nde payement",null,"A payé","Date limite\nde payement"]
[null,null,null,"NON",{"$f":"\">\" & TODAY()","v":">45672"},null,"NON",{"$f":"\">\" & TEXT(TODAY(),\"jj/mm/aaaa\")","v":">15/01/2025"}]
[]
[]
[null,null,null,"=\">\" & AUJOURDHUI() Ou =\">\" & TEXTE(AUJOURDHUI();\"jj/mm/aaaa\") "]
[]
[]
[]
[]
[null,"Prénom du\ncontribuable","Nom du\ncontribuable","Ville","Montant\nà payer","Gros montant","Date limite\nde payement","A payé","Montant des frais de retard"]
[null,"Yves","Egète","Bruxelles",300,null,"2024-11-09","non"]
[null,"Thibault","Chmonfils ","Bruxelles",1500,null,"2024-11-05","non"]
[null,"Sylva","Froid","Bruxelles",500,null,"2024-11-14","non"]
[null,"Aude","Froid","Bruxelles",240,null,"2024-11-23","non"]
[null,"Marc","Froid","Anvers",1050,null,"2024-11-16","non"]
[null,"Voczcek","Enbois","Anvers",200,null,"2024-11-30","non"]
[null,"Steve","Euxdugateauyenadanslefrigo ","Anvers",120,null,"2024-11-08","non"]
[null,"Roger","Soif","Bruxelles",580,null,"2024-11-17","non"]

{"sheet":"GroupeA","index":15,"n_rows":16,"n_cols":13,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["Nom","Prénom","Date de naissance","Salaire","Groupe","Sexe",null,null,null,null,null,null,"Retour Sommaire"]
["Enfant","Hélène","1991-07-24",1641,{"$f":"\"A\"","v":"A"},"f"]
["Enfant","Ludivine","1998-01-23",2146,"A","f"]
["Térieur","Alain","2001-09-01",2441,"A","m"]
["Térieur","Alex","1999-06-26",2378,"A","m"]
["Lalalalala","Strasky","2001-03-01",1698,"A","m"]
["Lalalalala","Hutch","1995-08-04",3079,"A","m"]
["Hole","Jenny","1990-10-21",1689,"A","f"]
["Hole","Diane","1992-03-31",2364,"A","f"]
["Hole","Beth","1996-09-01",1992,"A","f"]
["Hole","Nicole","1995-04-13",1773,"A","f"]
["Froid","Sylva","1994-05-28",1523,"A","f"]
["Froid","Aude","1999-06-15",2223,"A","f"]
["Froid","Anne","1992-08-28",2713,"A","f"]
["Froid","Mark","2001-04-11",2311,"A","m"]
["Froid","Laura","2003-09-13",1848,"A","f"]

{"sheet":"GroupeB","index":16,"n_rows":19,"n_cols":13,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["Nom","Prénom","Date de naissance","Salaire","Groupe","Sexe",null,null,null,null,null,null,"Retour Sommaire"]
["Chmonfils","Thibault","1995-01-24",2148,{"$f":"\"B\"","v":"B"},"m"]
["Chmonfils","Thierry","1995-12-09",2335,"B","m"]
["Estcassée","Sarah","2002-10-31",1884,"B","f"]
["Estcassée","Kate","1990-09-22",2255,"B","f"]
["Aihunbutte","Yvon","2004-04-27",2456,"B","m"]
["Aihunbutte","Marc","1995-09-05",2263,"B","m"]
["Danslefrigo","Ella","1997-08-17",3446,"B","f"]
["Danslefrigo","Djamilah","1994-10-11",2298,"B","f"]
["Danslefrigo","Charlotte","1994-10-21",3383,"B","f"]
["Dikulizer","Elle","1995-02-23",1947,"B","f"]
["Dikulizer","Valérie","1990-02-11",2176,"B","f"]
["Durine","Anna","1997-02-10",2646,"B","f"]
["Durine","Lise","2000-06-05",2467,"B","f"]
["Itiative","Samson","1997-03-20",2113,"B","m"]
["Itiative","Marielle","1994-10-23",2836,"B","f"]
["Itiative","Adeline","2002-08-19",2252,"B","f"]
["Izrich","Maïté","1994-09-13",1860,"B","f"]
["Izrich","Laure","1990-02-19",2533,"B","f"]

{"sheet":"GroupeC","index":17,"n_rows":34,"n_cols":13,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
["Nom","Prénom","Date de naissance","Salaire","Groupe","Sexe",null,null,null,null,null,null,"Retour Sommaire"]
["Jyraipas","Frédéric","2002-11-14",1883,{"$f":"\"C\"","v":"C"},"m"]
["Jyraipas","François","1993-11-06",3055,"C","m"]
["Jyraipas","Chantal","2003-03-12",2815,"C","f"]
["Jyraipas","Olympia","1995-06-15",2171,"C","f"]
["Mental","Ted","1998-10-05",1548,"C","m"]
["Mental","Bill","1995-12-16",1962,"C","m"]
["Mieux","Jeff","1991-05-22",1977,"C","m"]
["Mieux","Edmond","1990-05-14",2135,"C","m"]
["Nains","Blanche","1996-02-16",2391,"C","f"]
["Nains","Neige","2000-10-25",2739,"C","f"]
["Nains","Lucette","2003-11-06",2069,"C","f"]
["Pachaire","Yvan","1995-06-21",1842,"C","m"]
["Pachaire","Sam","2001-11-22",2581,"C","m"]
["Pachaire","Otto","1994-06-16",1657,"C","m"]
["Pourien","Yvon","1994-03-03",3310,"C","m"]
["Pourien","Pol","1992-04-20",3225,"C","m"]
["Pourien","Mickey","1994-12-24",2699,"C","m"]
["Tuation","Elle","2001-03-22",1610,"C","f"]
["Tuation","Anna","1993-07-30",2803,"C","f"]
["Tuation","Lise","2003-07-31",2303,"C","f"]
["Tuation","Lacie","2001-11-27",2152,"C","f"]
["Form","Hans","2004-09-10",1833,"C","m"]
["Form","Hubert","1994-02-17",2698,"C","m"]
["Monlatin","Jean","1997-12-08",2274,"C","m"]
["Monlatin","Pierre","2001-10-10",1913,"C","m"]
["Tretou","Jean","1993-05-25",2557,"C","m"]
["Tretou","Régis","1995-09-08",1560,"C","m"]
["Leschoses","Lazarre","1990-03-31",3043,"C","m"]
["Leschoses","Fabien","1997-06-15",3075,"C","m"]
["Lesdentverte","Samantha","2003-04-22",1715,"C","f"]
["Lesdentverte","Laurent","2001-10-29",2093,"C","m"]
["Ule","Thierry","1994-05-14",2417,"C","m"]
["Ule","Dick","2002-07-11",2962,"C","m"]

{"sheet":"DatasGroupées1","index":18,"n_rows":1,"n_cols":13,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,"Retour Sommaire"]

{"sheet":"DatasGroupées1_Solution","index":19,"n_rows":67,"n_cols":13,"rows_kept":67,"cut":false,"hidden":false,"merged":[]}
["Nom","Prénom","Date de naissance","Salaire","Groupe","Sexe",null,null,null,null,null,null,"Retour Sommaire"]
[{"$f":"_xlfn.VSTACK(GroupeA[],GroupeB[],GroupeC[])","v":"Enfant"},"Hélène","1991-07-24",1641,"A","f"]
["Enfant","Ludivine","1998-01-23",2146,"A","f"]
["Térieur","Alain","2001-09-01",2441,"A","m"]
["Térieur","Alex","1999-06-26",2378,"A","m"]
["Lalalalala","Strasky","2001-03-01",1698,"A","m",null,"NB1 : si des lignes ou des colonnes sont ajoutées, le tableau final sera actualisé"]
["Lalalalala","Hutch","1995-08-04",3079,"A","m",null,"NB2 : la formule est une formule \"propagée\" => pas beaucoup de possibilité de réorganisation"]
["Hole","Jenny","1990-10-21",1689,"A","f"]
["Hole","Diane","1992-03-31",2364,"A","f"]
["Hole","Beth","1996-09-01",1992,"A","f"]
["Hole","Nicole","1995-04-13",1773,"A","f"]
["Froid","Sylva","1994-05-28",1523,"A","f"]
["Froid","Aude","1999-06-15",2223,"A","f"]
["Froid","Anne","1992-08-28",2713,"A","f"]
["Froid","Mark","2001-04-11",2311,"A","m"]
["Froid","Laura","2003-09-13",1848,"A","f"]
["Chmonfils","Thibault","1995-01-24",2148,"B","m"]
["Chmonfils","Thierry","1995-12-09",2335,"B","m"]
["Estcassée","Sarah","2002-10-31",1884,"B","f"]
["Estcassée","Kate","1990-09-22",2255,"B","f"]
["Aihunbutte","Yvon","2004-04-27",2456,"B","m"]
["Aihunbutte","Marc","1995-09-05",2263,"B","m"]
["Danslefrigo","Ella","1997-08-17",3446,"B","f"]
["Danslefrigo","Djamilah","1994-10-11",2298,"B","f"]
["Danslefrigo","Charlotte","1994-10-21",3383,"B","f"]
["Dikulizer","Elle","1995-02-23",1947,"B","f"]
["Dikulizer","Valérie","1990-02-11",2176,"B","f"]
["Durine","Anna","1997-02-10",2646,"B","f"]
["Durine","Lise","2000-06-05",2467,"B","f"]
["Itiative","Samson","1997-03-20",2113,"B","m"]
["Itiative","Marielle","1994-10-23",2836,"B","f"]
["Itiative","Adeline","2002-08-19",2252,"B","f"]
["Izrich","Maïté","1994-09-13",1860,"B","f"]
["Izrich","Laure","1990-02-19",2533,"B","f"]
["Jyraipas","Frédéric","2002-11-14",1883,"C","m"]
["Jyraipas","François","1993-11-06",3055,"C","m"]
["Jyraipas","Chantal","2003-03-12",2815,"C","f"]
["Jyraipas","Olympia","1995-06-15",2171,"C","f"]
["Mental","Ted","1998-10-05",1548,"C","m"]
["Mental","Bill","1995-12-16",1962,"C","m"]
["Mieux","Jeff","1991-05-22",1977,"C","m"]
["Mieux","Edmond","1990-05-14",2135,"C","m"]
["Nains","Blanche","1996-02-16",2391,"C","f"]
["Nains","Neige","2000-10-25",2739,"C","f"]
["Nains","Lucette","2003-11-06",2069,"C","f"]
["Pachaire","Yvan","1995-06-21",1842,"C","m"]
["Pachaire","Sam","2001-11-22",2581,"C","m"]
["Pachaire","Otto","1994-06-16",1657,"C","m"]
["Pourien","Yvon","1994-03-03",3310,"C","m"]
["Pourien","Pol","1992-04-20",3225,"C","m"]
["Pourien","Mickey","1994-12-24",2699,"C","m"]
["Tuation","Elle","2001-03-22",1610,"C","f"]
["Tuation","Anna","1993-07-30",2803,"C","f"]
["Tuation","Lise","2003-07-31",2303,"C","f"]
["Tuation","Lacie","2001-11-27",2152,"C","f"]
["Form","Hans","2004-09-10",1833,"C","m"]
["Form","Hubert","1994-02-17",2698,"C","m"]
["Monlatin","Jean","1997-12-08",2274,"C","m"]
["Monlatin","Pierre","2001-10-10",1913,"C","m"]
["Tretou","Jean","1993-05-25",2557,"C","m"]
["Tretou","Régis","1995-09-08",1560,"C","m"]
["Leschoses","Lazarre","1990-03-31",3043,"C","m"]
["Leschoses","Fabien","1997-06-15",3075,"C","m"]
["Lesdentverte","Samantha","2003-04-22",1715,"C","f"]
["Lesdentverte","Laurent","2001-10-29",2093,"C","m"]
["Ule","Thierry","1994-05-14",2417,"C","m"]
["Ule","Dick","2002-07-11",2962,"C","m"]

{"sheet":"DatasGroupées2","index":20,"n_rows":33,"n_cols":13,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,"Retour Sommaire"]
[]
[null,null,null,null,null,"1- Étape 1 : Recupérer les données des 3 tableaux dans une query (Power Query)"]
[]
[null,null,null,null,null,null,"Se placer dans le tableau ('GroupeA') "]
[null,null,null,null,null,null,"Données .. À partir de tableau ou d'une plage"]
[]
[null,null,null,null,null,"2- Étape 2 : Créer une connexion par tableau via l'interface de Power Query"]
[]
[null,null,null,null,null,null,"Fermer et charger .. Fermer et charger dans :"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"3- Étape 3 : Créer la requête qui permet de combiner les 3 autres requêtes (via l'éditeur Power Query) et charger cette requête sur la feuille"]
[]
[null,null,null,null,null,null,"Ajouter des requêtes comme étant nouvelles :"]

{"sheet":"DatasGroupées2_Solution","index":21,"n_rows":67,"n_cols":16,"rows_kept":67,"cut":false,"hidden":false,"merged":[]}
["Nom","Prénom","Date de naissance","Salaire","Groupe","Sexe",null,null,null,null,null,null,null,null,null,"Retour Sommaire"]
["Enfant","Hélène","1991-07-24",1641,"A","f"]
["Enfant","Ludivine","1998-01-23",2146,"A","f",null,null,"1- Étape 1 : Recupérer les données des 3 tableaux dans une query (Power Query)"]
["Térieur","Alain","2001-09-01",2441,"A","m"]
["Térieur","Alex","1999-06-26",2378,"A","m",null,null,null,"Se placer dans le tableau ('GroupeA') "]
["Lalalalala","Strasky","2001-03-01",1698,"A","m",null,null,null,"Données .. À partir de tableau ou d'une plage"]
["Lalalalala","Hutch","1995-08-04",3079,"A","m"]
["Hole","Jenny","1990-10-21",1689,"A","f",null,null,"2- Étape 2 : Créer une connexion par tableau via l'interface de Power Query"]
["Hole","Diane","1992-03-31",2364,"A","f"]
["Hole","Beth","1996-09-01",1992,"A","f",null,null,null,"Fermer et charger .. Fermer et charger dans :"]
["Hole","Nicole","1995-04-13",1773,"A","f"]
["Froid","Sylva","1994-05-28",1523,"A","f"]
["Froid","Aude","1999-06-15",2223,"A","f"]
["Froid","Anne","1992-08-28",2713,"A","f"]
["Froid","Mark","2001-04-11",2311,"A","m"]
["Froid","Laura","2003-09-13",1848,"A","f"]
["Chmonfils","Thibault","1995-01-24",2148,"B","m"]
["Chmonfils","Thierry","1995-12-09",2335,"B","m"]
["Estcassée","Sarah","2002-10-31",1884,"B","f"]
["Estcassée","Kate","1990-09-22",2255,"B","f"]
["Aihunbutte","Yvon","2004-04-27",2456,"B","m"]
["Aihunbutte","Marc","1995-09-05",2263,"B","m"]
["Danslefrigo","Ella","1997-08-17",3446,"B","f"]
["Danslefrigo","Djamilah","1994-10-11",2298,"B","f"]
["Danslefrigo","Charlotte","1994-10-21",3383,"B","f"]
["Dikulizer","Elle","1995-02-23",1947,"B","f"]
["Dikulizer","Valérie","1990-02-11",2176,"B","f"]
["Durine","Anna","1997-02-10",2646,"B","f"]
["Durine","Lise","2000-06-05",2467,"B","f"]
["Itiative","Samson","1997-03-20",2113,"B","m"]
["Itiative","Marielle","1994-10-23",2836,"B","f",null,null,"3- Étape 3 : Créer la requête qui permet de combiner les 3 autres requêtes (via l'éditeur Power Query) et charger cette requête sur la feuille"]
["Itiative","Adeline","2002-08-19",2252,"B","f"]
["Izrich","Maïté","1994-09-13",1860,"B","f",null,null,null,"Ajouter des requêtes comme étant nouvelles :"]
["Izrich","Laure","1990-02-19",2533,"B","f"]
["Jyraipas","Frédéric","2002-11-14",1883,"C","m"]
["Jyraipas","François","1993-11-06",3055,"C","m"]
["Jyraipas","Chantal","2003-03-12",2815,"C","f"]
["Jyraipas","Olympia","1995-06-15",2171,"C","f"]
["Mental","Ted","1998-10-05",1548,"C","m"]
["Mental","Bill","1995-12-16",1962,"C","m"]
["Mieux","Jeff","1991-05-22",1977,"C","m"]
["Mieux","Edmond","1990-05-14",2135,"C","m"]
["Nains","Blanche","1996-02-16",2391,"C","f"]
["Nains","Neige","2000-10-25",2739,"C","f"]
["Nains","Lucette","2003-11-06",2069,"C","f"]
["Pachaire","Yvan","1995-06-21",1842,"C","m"]
["Pachaire","Sam","2001-11-22",2581,"C","m"]
["Pachaire","Otto","1994-06-16",1657,"C","m"]
["Pourien","Yvon","1994-03-03",3310,"C","m"]
["Pourien","Pol","1992-04-20",3225,"C","m"]
["Pourien","Mickey","1994-12-24",2699,"C","m"]
["Tuation","Elle","2001-03-22",1610,"C","f"]
["Tuation","Anna","1993-07-30",2803,"C","f"]
["Tuation","Lise","2003-07-31",2303,"C","f"]
["Tuation","Lacie","2001-11-27",2152,"C","f"]
["Form","Hans","2004-09-10",1833,"C","m"]
["Form","Hubert","1994-02-17",2698,"C","m"]
["Monlatin","Jean","1997-12-08",2274,"C","m"]
["Monlatin","Pierre","2001-10-10",1913,"C","m"]
["Tretou","Jean","1993-05-25",2557,"C","m"]
["Tretou","Régis","1995-09-08",1560,"C","m"]
["Leschoses","Lazarre","1990-03-31",3043,"C","m"]
["Leschoses","Fabien","1997-06-15",3075,"C","m"]
["Lesdentverte","Samantha","2003-04-22",1715,"C","f"]
["Lesdentverte","Laurent","2001-10-29",2093,"C","m"]
["Ule","Thierry","1994-05-14",2417,"C","m"]
["Ule","Dick","2002-07-11",2962,"C","m"]

{"sheet":"Tableau de bord","index":22,"n_rows":67,"n_cols":16,"rows_kept":67,"cut":false,"hidden":false,"merged":[]}
["Nom","Prénom","Date de naissance","Salaire","Groupe","Sexe",null,null,null,null,null,null,null,null,null,"Retour Sommaire"]
["Enfant","Hélène","1991-07-24",1641,"A","f"]
["Enfant","Ludivine","1998-01-23",2146,"A","f"]
["Térieur","Alain","2001-09-01",2441,"A","m",null,"1- À partir des données ci-contre, créez 2 TCD :",null,null,"TCD 1 : Nombre de personnes par année de naissance"]
["Térieur","Alex","1999-06-26",2378,"A","m",null,null,null,null,"TCD 2 : Nombre de personnes par sexe"]
["Lalalalala","Strasky","2001-03-01",1698,"A","m"]
["Lalalalala","Hutch","1995-08-04",3079,"A","m",null,"2- Créez des graphiques représentés comme ceux de la solution"]
["Hole","Jenny","1990-10-21",1689,"A","f"]
["Hole","Diane","1992-03-31",2364,"A","f",null,"3- Utilisez les segments de façon à afficher les données qui correspondent à des choix de groupes et d'années de naissance (CF Solution)"]
["Hole","Beth","1996-09-01",1992,"A","f"]
["Hole","Nicole","1995-04-13",1773,"A","f"]
["Froid","Sylva","1994-05-28",1523,"A","f"]
["Froid","Aude","1999-06-15",2223,"A","f"]
["Froid","Anne","1992-08-28",2713,"A","f"]
["Froid","Mark","2001-04-11",2311,"A","m"]
["Froid","Laura","2003-09-13",1848,"A","f"]
["Chmonfils","Thibault","1995-01-24",2148,"B","m"]
["Chmonfils","Thierry","1995-12-09",2335,"B","m"]
["Estcassée","Sarah","2002-10-31",1884,"B","f"]
["Estcassée","Kate","1990-09-22",2255,"B","f"]
["Aihunbutte","Yvon","2004-04-27",2456,"B","m"]
["Aihunbutte","Marc","1995-09-05",2263,"B","m"]
["Danslefrigo","Ella","1997-08-17",3446,"B","f"]
["Danslefrigo","Djamilah","1994-10-11",2298,"B","f"]
["Danslefrigo","Charlotte","1994-10-21",3383,"B","f"]
["Dikulizer","Elle","1995-02-23",1947,"B","f"]
["Dikulizer","Valérie","1990-02-11",2176,"B","f"]
["Durine","Anna","1997-02-10",2646,"B","f"]
["Durine","Lise","2000-06-05",2467,"B","f"]
["Itiative","Samson","1997-03-20",2113,"B","m"]
["Itiative","Marielle","1994-10-23",2836,"B","f"]
["Itiative","Adeline","2002-08-19",2252,"B","f"]
["Izrich","Maïté","1994-09-13",1860,"B","f"]
["Izrich","Laure","1990-02-19",2533,"B","f"]
["Jyraipas","Frédéric","2002-11-14",1883,"C","m"]
["Jyraipas","François","1993-11-06",3055,"C","m"]
["Jyraipas","Chantal","2003-03-12",2815,"C","f"]
["Jyraipas","Olympia","1995-06-15",2171,"C","f"]
["Mental","Ted","1998-10-05",1548,"C","m"]
["Mental","Bill","1995-12-16",1962,"C","m"]
["Mieux","Jeff","1991-05-22",1977,"C","m"]
["Mieux","Edmond","1990-05-14",2135,"C","m"]
["Nains","Blanche","1996-02-16",2391,"C","f"]
["Nains","Neige","2000-10-25",2739,"C","f"]
["Nains","Lucette","2003-11-06",2069,"C","f"]
["Pachaire","Yvan","1995-06-21",1842,"C","m"]
["Pachaire","Sam","2001-11-22",2581,"C","m"]
["Pachaire","Otto","1994-06-16",1657,"C","m"]
["Pourien","Yvon","1994-03-03",3310,"C","m"]
["Pourien","Pol","1992-04-20",3225,"C","m"]
["Pourien","Mickey","1994-12-24",2699,"C","m"]
["Tuation","Elle","2001-03-22",1610,"C","f"]
["Tuation","Anna","1993-07-30",2803,"C","f"]
["Tuation","Lise","2003-07-31",2303,"C","f"]
["Tuation","Lacie","2001-11-27",2152,"C","f"]
["Form","Hans","2004-09-10",1833,"C","m"]
["Form","Hubert","1994-02-17",2698,"C","m"]
["Monlatin","Jean","1997-12-08",2274,"C","m"]
["Monlatin","Pierre","2001-10-10",1913,"C","m"]
["Tretou","Jean","1993-05-25",2557,"C","m"]
["Tretou","Régis","1995-09-08",1560,"C","m"]
["Leschoses","Lazarre","1990-03-31",3043,"C","m"]
["Leschoses","Fabien","1997-06-15",3075,"C","m"]
["Lesdentverte","Samantha","2003-04-22",1715,"C","f"]
["Lesdentverte","Laurent","2001-10-29",2093,"C","m"]
["Ule","Thierry","1994-05-14",2417,"C","m"]
["Ule","Dick","2002-07-11",2962,"C","m"]

{"sheet":"Tableau de bord_Solution","index":23,"n_rows":67,"n_cols":16,"rows_kept":67,"cut":false,"hidden":false,"merged":[]}
["Nom","Prénom","Date de naissance","Salaire","Groupe","Sexe",null,null,null,null,null,null,null,null,null,"Retour Sommaire"]
["Enfant","Hélène","1991-07-24",1641,"A","f"]
["Enfant","Ludivine","1998-01-23",2146,"A","f",null,"1- À partir des données ci-contre, créez 2 TCD :",null,null,"TCD 1 : Nombre de personnes par année de naissance"]
["Térieur","Alain","2001-09-01",2441,"A","m",null,null,null,null,"TCD 2 : Nombre de personnes par sexe"]
["Térieur","Alex","1999-06-26",2378,"A","m"]
["Lalalalala","Strasky","2001-03-01",1698,"A","m",null,"2- Créez des graphiques représentés comme ceux de la solution"]
["Lalalalala","Hutch","1995-08-04",3079,"A","m"]
["Hole","Jenny","1990-10-21",1689,"A","f",null,"3- Utilisez les segments de façon à afficher les données qui correspondent à des choix de groupes et d'années de naissance (CF Solution)"]
["Hole","Diane","1992-03-31",2364,"A","f"]
["Hole","Beth","1996-09-01",1992,"A","f"]
["Hole","Nicole","1995-04-13",1773,"A","f"]
["Froid","Sylva","1994-05-28",1523,"A","f"]
["Froid","Aude","1999-06-15",2223,"A","f"]
["Froid","Anne","1992-08-28",2713,"A","f"]
["Froid","Mark","2001-04-11",2311,"A","m"]
["Froid","Laura","2003-09-13",1848,"A","f"]
["Chmonfils","Thibault","1995-01-24",2148,"B","m"]
["Chmonfils","Thierry","1995-12-09",2335,"B","m"]
["Estcassée","Sarah","2002-10-31",1884,"B","f"]
["Estcassée","Kate","1990-09-22",2255,"B","f"]
["Aihunbutte","Yvon","2004-04-27",2456,"B","m"]
["Aihunbutte","Marc","1995-09-05",2263,"B","m"]
["Danslefrigo","Ella","1997-08-17",3446,"B","f"]
["Danslefrigo","Djamilah","1994-10-11",2298,"B","f"]
["Danslefrigo","Charlotte","1994-10-21",3383,"B","f"]
["Dikulizer","Elle","1995-02-23",1947,"B","f"]
["Dikulizer","Valérie","1990-02-11",2176,"B","f"]
["Durine","Anna","1997-02-10",2646,"B","f"]
["Durine","Lise","2000-06-05",2467,"B","f"]
["Itiative","Samson","1997-03-20",2113,"B","m"]
["Itiative","Marielle","1994-10-23",2836,"B","f"]
["Itiative","Adeline","2002-08-19",2252,"B","f"]
["Izrich","Maïté","1994-09-13",1860,"B","f"]
["Izrich","Laure","1990-02-19",2533,"B","f"]
["Jyraipas","Frédéric","2002-11-14",1883,"C","m"]
["Jyraipas","François","1993-11-06",3055,"C","m"]
["Jyraipas","Chantal","2003-03-12",2815,"C","f"]
["Jyraipas","Olympia","1995-06-15",2171,"C","f"]
["Mental","Ted","1998-10-05",1548,"C","m"]
["Mental","Bill","1995-12-16",1962,"C","m"]
["Mieux","Jeff","1991-05-22",1977,"C","m"]
["Mieux","Edmond","1990-05-14",2135,"C","m"]
["Nains","Blanche","1996-02-16",2391,"C","f"]
["Nains","Neige","2000-10-25",2739,"C","f"]
["Nains","Lucette","2003-11-06",2069,"C","f"]
["Pachaire","Yvan","1995-06-21",1842,"C","m"]
["Pachaire","Sam","2001-11-22",2581,"C","m"]
["Pachaire","Otto","1994-06-16",1657,"C","m"]
["Pourien","Yvon","1994-03-03",3310,"C","m"]
["Pourien","Pol","1992-04-20",3225,"C","m",null,null,"Années de naissance","Nombre de personnes",null,"Sexes","Nombre par sexe"]
["Pourien","Mickey","1994-12-24",2699,"C","m",null,null,"1990",2,null,"f",10]
["Tuation","Elle","2001-03-22",1610,"C","f",null,null,"1991",1,null,"m",23]
["Tuation","Anna","1993-07-30",2803,"C","f",null,null,"1992",1,null,"Total général",33]
["Tuation","Lise","2003-07-31",2303,"C","f",null,null,"1993",3]
["Tuation","Lacie","2001-11-27",2152,"C","f",null,null,"1994",5]
["Form","Hans","2004-09-10",1833,"C","m",null,null,"1995",4]
["Form","Hubert","1994-02-17",2698,"C","m",null,null,"1996",1]
["Monlatin","Jean","1997-12-08",2274,"C","m",null,null,"1997",2]
["Monlatin","Pierre","2001-10-10",1913,"C","m",null,null,"1998",1]
["Tretou","Jean","1993-05-25",2557,"C","m",null,null,"2000",1]
["Tretou","Régis","1995-09-08",1560,"C","m",null,null,"2001",5]
["Leschoses","Lazarre","1990-03-31",3043,"C","m",null,null,"2002",2]
["Leschoses","Fabien","1997-06-15",3075,"C","m",null,null,"2003",4]
["Lesdentverte","Samantha","2003-04-22",1715,"C","f",null,null,"2004",1]
["Lesdentverte","Laurent","2001-10-29",2093,"C","m",null,null,"Total général",33]
["Ule","Thierry","1994-05-14",2417,"C","m"]
["Ule","Dick","2002-07-11",2962,"C","m"]