{"text_format":"1","workbook":"xlsx","n_sheets":23,"sheets":["TDM","Question1","Question1_Solution","Question2","Question2_Solution","Les familles du net","Les familles du net_Solution","Reconstruire familles","Reconstruire familles_Solution","Compter par TCD","Compter par TCD_Solution","Compter par Power Query","Compter par Power Query_Solutio","Question3","Question3_Solution","Question4","Question4_Solution","Question5","Question5_Solution","Question6","Question6_Solution","Question7","Question7_Solution"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":14,"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":"TDM","index":0,"n_rows":42,"n_cols":10,"rows_kept":42,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,"Question 1","Calculs de frais de retard"]
[]
[null,null,"=> Utilisation de la fonction SI.CONDITIONS"]
[]
[null,"Question 2","Calculs des montants d'allocation familiale",null,null,null,null,null,"NB :","Il faut afficher les corrigés pour pouvoir utiliser les liens sur les feuilles de correction"]
[]
[null,null,"=> Utilisation de la fonction SI.CONDITIONS"]
[]
[null,"Reconstruire familles","Reconstruire un tableau mal \"organisé\" de façon à le rendre exploitable pour divers traitement (opérations de synthèse, TCD) "]
[]
[null,null,"=> Utilisation de Power Query : remplacement de valeurs, dépivotage de colonnes"]
[]
[null,"Compter par TCD","Obtenir le nombre d'enfant à partir du tableau réorganisé"]
[]
[null,null,"=> Création d'un TCD à partir d'une source 'Power Query' - Introduction à la création de macros"]
[]
[null,"Compter par Power Query","Création d'une requête 'Power Query' à partir d'une autre requête"]
[]
[null,null,"=> Utilisation de Power Query : duplication/référençage à une requête, regroupement et opérations de synthèse"]
[]
[null,"Question 3","Filtre les données selon certains critères"]
[]
[null,null,"=> Utilisation des filtres avancés - Utilisation des listes par validation de données - Introduction à la création de macros"]
[]
[null,"Question 4","Filtre les données selon certains critères"]
[]
[null,null,"=> Utilisation des filtres avancés - Critères multiples"]
[]
[null,"Question 5","Filtre les données selon certains critères"]
[]
[null,null,"=> Utilisation des filtres avancés - Critères multiples"]
[]
[null,"Question 6","Filtre les données selon certains critères"]
[]
[null,null,"=> Utilisation des filtres avancés - Critères multiples"]
[]
[null,"Question 7","Filtre les données selon certains critères"]
[]
[null,null,"=> Utilisation des filtres avancés - Critères multiples"]

{"sheet":"Question1","index":1,"n_rows":29,"n_cols":11,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
["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,null,null,null,null,null,null,null,null,"Retour TDM"]
["- Pas de frais adminisratifs pour les gens qui ont payé ni pour les gens dont la date limite n'est pas encore atteinte"]
["- Des frais administratifs de 15 € pour les gens qui ont moins de 15 jours de retard"]
["- Des frais de 50 € pour les gens qui ont 15 jours de retard ou plus"]
[]
[]
[]
["Nom du\ncontribuable","Prénom du\ncontribuable","Montant\nà payer","Date limite\nde payement","A payé","Montant des frais de retard"]
["Auvertcestpasbon","Elvire",980,"2024-03-31","oui"]
["Namuralanagecestdifficile","Ferdinand",500,"2024-03-24","oui"]
["Egète","Yves",300,"2024-04-12","non"]
["Chmonfils ","Thibault",1500,"2024-03-24","non"]
["Chmonfils ","Thierry",1254,"2024-04-27","non"]
["Enfaillite","Mélusine",630,"2024-04-10","oui",null,null,"Vers Question 4"]
["Depower","Agathe",600,"2024-04-15","non",null,null,"Vers Question 6"]
["Bowie","Ken",600,"2024-03-21","non",null,null,"Vers Question 7"]
["Di","Alain",500,"2024-05-05","non"]
["Froid","Sylva",500,"2024-04-18","non"]
["Froid","Aude",240,"2024-05-16","non"]
["Froid","Anne",1050,"2024-05-08","non"]
["Froid","Marc",1050,"2024-03-29","non"]
["Froid","Laura",120,"2024-05-07","non"]
["Alavanilleplease","Douglas",400,"2024-04-28","non"]
["Enbois","Voczcek",200,"2024-05-04","non"]
["Deblouze","Agathe",1400,"2024-04-16","non"]
["Euxdugateauyenadanslefrigo ","Steve",120,"2024-04-18","non"]
["Heurindélébil ","Marc",250,"2024-05-14","oui"]
["Tredelè","Willy",300,"2024-04-07","non"]
["Soif","Roger",580,"2024-03-26","non"]

{"sheet":"Question1_Solution","index":2,"n_rows":29,"n_cols":11,"rows_kept":29,"cut":false,"hidden":true,"merged":[]}
["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,null,null,null,null,null,null,null,null,"Retour TDM"]
["- Pas de frais adminisratifs pour les gens qui ont payé ni pour les gens dont la date limite n'est pas encore atteinte"]
["- Des frais administratifs de 15 € pour les gens qui ont moins de 15 jours de retard"]
["- Des frais de 50 € pour les gens qui ont 15 jours de retard ou plus"]
[]
[]
[]
["Nom du\ncontribuable","Prénom du\ncontribuable","Montant\nà payer","Date limite\nde payement","A payé","Montant des frais de retard"]
["Auvertcestpasbon","Elvire",980,{"$f":"Question1!D9","v":"2024-03-31"},"oui",{"$f":"_xlfn.IFS(OR(E9=\"OUI\",D9>=TODAY()),0,TODAY()-D9<15,20,TODAY()-D9>=15,50)","v":0},null,"Si 'A payé' = \"OUI\" OU 'Date limite' > AUJOURDHUI() ALORS 0"]
["Namuralanagecestdifficile","Ferdinand",500,{"$f":"Question1!D10","v":"2024-03-24"},"oui",{"$f":"_xlfn.IFS(OR(E10=\"OUI\",D10>=TODAY()),0,TODAY()-D10<15,20,TODAY()-D10>=15,50)","v":0},null,"Si AUJOURDHUI() - 'Date limite'  < 15 ALORS 20"]
["Egète","Yves",300,{"$f":"Question1!D11","v":"2024-04-12"},"non",{"$f":"_xlfn.IFS(OR(E11=\"OUI\",D11>=TODAY()),0,TODAY()-D11<15,20,TODAY()-D11>=15,50)","v":20},null,"Si AUJOURDHUI() - 'Date limite' >= 15 ALORS 50"]
["Chmonfils ","Thibault",1500,{"$f":"Question1!D12","v":"2024-03-24"},"non",{"$f":"_xlfn.IFS(OR(E12=\"OUI\",D12>=TODAY()),0,TODAY()-D12<15,20,TODAY()-D12>=15,50)","v":50}]
["Chmonfils ","Thierry",1254,{"$f":"Question1!D13","v":"2024-04-27"},"non",{"$f":"_xlfn.IFS(OR(E13=\"OUI\",D13>=TODAY()),0,TODAY()-D13<15,20,TODAY()-D13>=15,50)","v":0}]
["Enfaillite","Mélusine",630,{"$f":"Question1!D14","v":"2024-04-10"},"oui",{"$f":"_xlfn.IFS(OR(E14=\"OUI\",D14>=TODAY()),0,TODAY()-D14<15,20,TODAY()-D14>=15,50)","v":0},null,"Vers Question 4"]
["Depower","Agathe",600,{"$f":"Question1!D15","v":"2024-04-15"},"non",{"$f":"_xlfn.IFS(OR(E15=\"OUI\",D15>=TODAY()),0,TODAY()-D15<15,20,TODAY()-D15>=15,50)","v":20},null,"Vers Question 6"]
["Bowie","Ken",600,{"$f":"Question1!D16","v":"2024-03-21"},"non",{"$f":"_xlfn.IFS(OR(E16=\"OUI\",D16>=TODAY()),0,TODAY()-D16<15,20,TODAY()-D16>=15,50)","v":50},null,"Vers Question 7"]
["Di","Alain",500,{"$f":"Question1!D17","v":"2024-05-05"},"non",{"$f":"_xlfn.IFS(OR(E17=\"OUI\",D17>=TODAY()),0,TODAY()-D17<15,20,TODAY()-D17>=15,50)","v":0}]
["Froid","Sylva",500,{"$f":"Question1!D18","v":"2024-04-18"},"non",{"$f":"_xlfn.IFS(OR(E18=\"OUI\",D18>=TODAY()),0,TODAY()-D18<15,20,TODAY()-D18>=15,50)","v":0}]
["Froid","Aude",240,{"$f":"Question1!D19","v":"2024-05-16"},"non",{"$f":"_xlfn.IFS(OR(E19=\"OUI\",D19>=TODAY()),0,TODAY()-D19<15,20,TODAY()-D19>=15,50)","v":0}]
["Froid","Anne",1050,{"$f":"Question1!D20","v":"2024-05-08"},"non",{"$f":"_xlfn.IFS(OR(E20=\"OUI\",D20>=TODAY()),0,TODAY()-D20<15,20,TODAY()-D20>=15,50)","v":0}]
["Froid","Marc",1050,{"$f":"Question1!D21","v":"2024-03-29"},"non",{"$f":"_xlfn.IFS(OR(E21=\"OUI\",D21>=TODAY()),0,TODAY()-D21<15,20,TODAY()-D21>=15,50)","v":50}]
["Froid","Laura",120,{"$f":"Question1!D22","v":"2024-05-07"},"non",{"$f":"_xlfn.IFS(OR(E22=\"OUI\",D22>=TODAY()),0,TODAY()-D22<15,20,TODAY()-D22>=15,50)","v":0}]
["Alavanilleplease","Douglas",400,{"$f":"Question1!D23","v":"2024-04-28"},"non",{"$f":"_xlfn.IFS(OR(E23=\"OUI\",D23>=TODAY()),0,TODAY()-D23<15,20,TODAY()-D23>=15,50)","v":0}]
["Enbois","Voczcek",200,{"$f":"Question1!D24","v":"2024-05-04"},"non",{"$f":"_xlfn.IFS(OR(E24=\"OUI\",D24>=TODAY()),0,TODAY()-D24<15,20,TODAY()-D24>=15,50)","v":0}]
["Deblouze","Agathe",1400,{"$f":"Question1!D25","v":"2024-04-16"},"non",{"$f":"_xlfn.IFS(OR(E25=\"OUI\",D25>=TODAY()),0,TODAY()-D25<15,20,TODAY()-D25>=15,50)","v":20}]
["Euxdugateauyenadanslefrigo ","Steve",120,{"$f":"Question1!D26","v":"2024-04-18"},"non",{"$f":"_xlfn.IFS(OR(E26=\"OUI\",D26>=TODAY()),0,TODAY()-D26<15,20,TODAY()-D26>=15,50)","v":0}]
["Heurindélébil ","Marc",250,{"$f":"Question1!D27","v":"2024-05-14"},"oui",{"$f":"_xlfn.IFS(OR(E27=\"OUI\",D27>=TODAY()),0,TODAY()-D27<15,20,TODAY()-D27>=15,50)","v":0}]
["Tredelè","Willy",300,{"$f":"Question1!D28","v":"2024-04-07"},"non",{"$f":"_xlfn.IFS(OR(E28=\"OUI\",D28>=TODAY()),0,TODAY()-D28<15,20,TODAY()-D28>=15,50)","v":20}]
["Soif","Roger",580,{"$f":"Question1!D29","v":"2024-03-26"},"non",{"$f":"_xlfn.IFS(OR(E29=\"OUI\",D29>=TODAY()),0,TODAY()-D29<15,20,TODAY()-D29>=15,50)","v":50}]

{"sheet":"Question2","index":3,"n_rows":29,"n_cols":11,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
["Voici le nombre d'enfants de certaines familles bien connues du net. Calculez les allocations familiales que chaque famille va recevoir selon ceci :",null,null,null,null,null,null,null,null,null,"Retour TDM"]
["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":29,"n_cols":11,"rows_kept":29,"cut":false,"hidden":true,"merged":[]}
["Voici le nombre d'enfants de certaines familles bien connues du net. Calculez les allocations familiales que chaque famille va recevoir selon ceci :",null,null,null,null,null,null,null,null,null,"Retour TDM"]
["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(C9=1,83.4,C9=2,83.4+154.33,C9>2,83.4+154.33+(C9-2)*230.42)","v":237.73000000000002},null,null,"Si Nbre d'enfants = 1 ALORS 83,40"]
[null,"Térieur",2,{"$f":"_xlfn.IFS(C10=1,83.4,C10=2,83.4+154.33,C10>2,83.4+154.33+(C10-2)*230.42)","v":237.73000000000002},null,null,"SI Nbre d'enfants = 2 ALORS 83,40 + 154,33"]
[null,"Lalalalala",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 > 2 ALORS 83,40 + 154,33 + (Nbre d'enfants - 2) * 230,42"]
[null,"Hole",4,{"$f":"_xlfn.IFS(C12=1,83.4,C12=2,83.4+154.33,C12>2,83.4+154.33+(C12-2)*230.42)","v":698.56999999999994}]
[null,"Froid",5,{"$f":"_xlfn.IFS(C13=1,83.4,C13=2,83.4+154.33,C13>2,83.4+154.33+(C13-2)*230.42)","v":928.99}]
[null,"Chmonfils",2,{"$f":"_xlfn.IFS(C14=1,83.4,C14=2,83.4+154.33,C14>2,83.4+154.33+(C14-2)*230.42)","v":237.73000000000002}]
[null,"Estcassée",2,{"$f":"_xlfn.IFS(C15=1,83.4,C15=2,83.4+154.33,C15>2,83.4+154.33+(C15-2)*230.42)","v":237.73000000000002}]
[null,"Aihunbutte",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,"Danslefrigo",3,{"$f":"_xlfn.IFS(C17=1,83.4,C17=2,83.4+154.33,C17>2,83.4+154.33+(C17-2)*230.42)","v":468.15}]
[null,"Dikulizer",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,"Durine",2,{"$f":"_xlfn.IFS(C19=1,83.4,C19=2,83.4+154.33,C19>2,83.4+154.33+(C19-2)*230.42)","v":237.73000000000002}]
[null,"Itiative",3,{"$f":"_xlfn.IFS(C20=1,83.4,C20=2,83.4+154.33,C20>2,83.4+154.33+(C20-2)*230.42)","v":468.15}]
[null,"Izrich",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,"Jyraipas",4,{"$f":"_xlfn.IFS(C22=1,83.4,C22=2,83.4+154.33,C22>2,83.4+154.33+(C22-2)*230.42)","v":698.56999999999994}]
[null,"Mental",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,"Mieux",2,{"$f":"_xlfn.IFS(C24=1,83.4,C24=2,83.4+154.33,C24>2,83.4+154.33+(C24-2)*230.42)","v":237.73000000000002}]
[null,"Nains",3,{"$f":"_xlfn.IFS(C25=1,83.4,C25=2,83.4+154.33,C25>2,83.4+154.33+(C25-2)*230.42)","v":468.15}]
[null,"Pachaire",3,{"$f":"_xlfn.IFS(C26=1,83.4,C26=2,83.4+154.33,C26>2,83.4+154.33+(C26-2)*230.42)","v":468.15}]
[null,"Pourien",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,"Tuation",4,{"$f":"_xlfn.IFS(C28=1,83.4,C28=2,83.4+154.33,C28>2,83.4+154.33+(C28-2)*230.42)","v":698.56999999999994}]
[null,"Form",2,{"$f":"_xlfn.IFS(C29=1,83.4,C29=2,83.4+154.33,C29>2,83.4+154.33+(C29-2)*230.42)","v":237.73000000000002}]

{"sheet":"Les familles du net","index":5,"n_rows":28,"n_cols":10,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,"Retour TDM"]
[null,"Nom","Prénoms","Nombre"]
[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":"Les familles du net_Solution","index":6,"n_rows":29,"n_cols":10,"rows_kept":29,"cut":false,"hidden":true,"merged":[]}
[null,null,null,null,null,null,null,null,null,"Retour TDM"]
[null,"Nom","Prénoms","Nombre"]
[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]
[null,"Cale","Anna, Lise, Mehdi",3]

{"sheet":"Reconstruire familles","index":7,"n_rows":9,"n_cols":10,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,"Retour vers Question 3",null,null,null,"Retour TDM"]
[]
[]
[]
[]
[]
[null,null,null,null,null,"À partir de la feuille 'Les familles du net', reconstruire le tableau de façon :"]
[null,null,null,null,null,"- à ne plus avoir la colonne avec le nombre d'enfants"]
[null,null,null,null,null,"- à n'avoir qu'un seul prénom par ligne"]

{"sheet":"Reconstruire familles_Solution","index":8,"n_rows":70,"n_cols":10,"rows_kept":70,"cut":false,"hidden":true,"merged":[]}
["Nom","Prénom",null,null,null,"Retour vers Question 3",null,null,null,"Retour TDM"]
["Aihunbutte","Yvon"]
["Aihunbutte","Marc"]
["Cale","Mehdi"]
["Cale","Lise"]
["Cale","Anna"]
["Chmonfils","Thibault",null,null,null,"À partir de la feuille 'Les familles du net_Solution', reconstruire le tableau de façon :"]
["Chmonfils","Thierry",null,null,null,"- à ne plus avoir la colonne avec le nombre d'enfants"]
["Danslefrigo","Djamilah",null,null,null,"- à n'avoir qu'un seul prénom par ligne"]
["Danslefrigo","Charlotte"]
["Danslefrigo","Ella"]
["Dikulizer","Elle"]
["Dikulizer","Valérie"]
["Durine","Anna"]
["Durine","Lise"]
["Enfant","Hélène"]
["Enfant","Ludivine"]
["Estcassée","Kate"]
["Estcassée","Sarah"]
["Form","Hans"]
["Form","Hubert"]
["Froid","Laura"]
["Froid","Sylva"]
["Froid","Mark"]
["Froid","Anne"]
["Froid","Aude"]
["Hole","Jenny"]
["Hole","Nicole"]
["Hole","Beth"]
["Hole","Diane"]
["Itiative","Adeline"]
["Itiative","Samson"]
["Itiative","Marielle"]
["Izrich","Laure"]
["Izrich","Maïté"]
["Jyraipas","Olympia"]
["Jyraipas","François"]
["Jyraipas","Frédéric"]
["Jyraipas","Chantal"]
["Lalalalala","Hutch"]
["Lalalalala","Strasky"]
["Leschoses","Fabien"]
["Leschoses","Lazarre"]
["Lesdentverte","Samantha"]
["Lesdentverte","Laurent"]
["Mental","Ted"]
["Mental","Bill"]
["Mieux","Jeff"]
["Mieux","Edmond"]
["Monlatin","Pierre"]
["Monlatin","Jean"]
["Nains","Blanche"]
["Nains","Lucette"]
["Nains","Neige"]
["Pachaire","Otto"]
["Pachaire","Sam"]
["Pachaire","Yvan"]
["Pourien","Yvon"]
["Pourien","Mickey"]
["Pourien","Pol"]
["Tretou","Régis"]
["Tretou","Jean"]
["Tuation","Lise"]
["Tuation","Elle"]
["Tuation","Lacie"]
["Tuation","Anna"]
["Térieur","Alex"]
["Térieur","Alain"]
["Ule","Dick"]
["Ule","Thierry"]

{"sheet":"Compter par TCD","index":9,"n_rows":12,"n_cols":10,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,"Retour TDM"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"À partir de la feuille 'Reconstruire familles_Solution', créer un TCD permettant :"]
[null,null,null,null,null,null,null,"- d'obtenir le nombre d'enfants par famille"]
[]
[null,null,null,null,null,null,null,"Créer une macro qui permet d'actualiser le TCD, de définir une largeur de 8"]
[null,null,null,null,null,null,null,"à la colonne C et qui met les titres du TCD en gras, centré, souligné"]

{"sheet":"Compter par TCD_Solution","index":10,"n_rows":36,"n_cols":10,"rows_kept":36,"cut":false,"hidden":true,"merged":[]}
[null,null,null,null,null,null,null,null,null,"Retour TDM"]
[]
[]
[]
[]
[]
[null,"Nombre de Prénom"]
[null,"Nom","Total",null,null,null,null,"À partir de la feuille 'Reconstruire familles_Solution', créer un TCD permettant :"]
[null,"Aihunbutte",2,null,null,null,null,"- d'obtenir le nombre d'enfants par famille"]
[null,"Cale",3]
[null,"Chmonfils",2,null,null,null,null,"Créer une macro qui permet d'actualiser le TCD, de définir une largeur de 8"]
[null,"Danslefrigo",3,null,null,null,null,"à la colonne C et qui met les titres du TCD en gras, centré, souligné"]
[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",69]

{"sheet":"Compter par Power Query","index":11,"n_rows":11,"n_cols":10,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,"Retour vers Question 5",null,null,null,"Retour TDM"]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"À partir de la feuille 'Reconstruire familles', créer une requête permettant :"]
[null,null,null,null,null,null,null,"- d'obtenir le nombre d'enfants par famille"]
[null,null,null,null,null,null,null,"- ajouter une colonne dans laquelle sera calculé le montant des allocations par famille"]

{"sheet":"Compter par Power Query_Solutio","index":12,"n_rows":28,"n_cols":10,"rows_kept":28,"cut":false,"hidden":true,"merged":[]}
["Nom","Nombre",null,null,null,"Retour vers Question 5",null,null,null,"Retour TDM"]
["Aihunbutte",2]
["Cale",3]
["Chmonfils",2]
["Danslefrigo",3]
["Dikulizer",2]
["Durine",2]
["Enfant",2,null,null,null,null,null,"À partir de la feuille 'Reconstruire familles_Solution', créer une requête permettant :"]
["Estcassée",2,null,null,null,null,null,"- d'obtenir le nombre d'enfants par famille"]
["Form",2,null,null,null,null,null,"- ajouter une colonne dans laquelle sera calculé le montant des allocations par famille"]
["Froid",5]
["Hole",4]
["Itiative",3]
["Izrich",2]
["Jyraipas",4]
["Lalalalala",2]
["Leschoses",2]
["Lesdentverte",2]
["Mental",2]
["Mieux",2]
["Monlatin",2]
["Nains",3]
["Pachaire",3]
["Pourien",3]
["Tretou",2]
["Tuation",4]
["Térieur",2]
["Ule",2]

{"sheet":"Question3","index":13,"n_rows":12,"n_cols":13,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,"Retour TDM"]
["A partir de la feuille \"Reconstruire familles\", affichez les prénoms des enfants dont le nom est choisi via la liste des noms"]
["La liste est issue de la feuille les familles du net. Faites en sorte qu'elle s'adapte à l'ajout de personnes"]
["Lorsque nous changeons de nom, le résultat ne s'actualise pas => Créez une macro 'Actualiser' qui permet d'actualiser le résultat"]
[]
[]
[null,"Nom"]
[null,"Estcassée",null,null,null,"Vers la feuille"]
[]
[]
[]
[null,"Prénom"]

{"sheet":"Question3_Solution","index":14,"n_rows":15,"n_cols":13,"rows_kept":15,"cut":false,"hidden":true,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,"Retour TDM"]
["A partir de la feuille \"Reconstruire familles_Solution\", affichez les prénoms des enfants dont le nom est choisi via la liste des noms"]
["La liste est issue de la feuille les familles du net. Faites en sorte qu'elle s'adapte à l'ajout de personnes"]
["Lorsque nous changeons de nom, le résultat ne s'actualise pas => Créez une macro 'Actualiser' qui permet d'actualiser le résultat"]
[]
[]
[null,"Nom"]
[null,"Itiative",null,null,null,"Vers la feuille"]
[]
[]
[]
[null,"Prénom"]
[null,"Adeline"]
[null,"Samson"]
[null,"Marielle"]

{"sheet":"Question4","index":15,"n_rows":7,"n_cols":13,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,"Retour TDM"]
["A partir de la feuille 'Question1', affichez les lignes qui correspondent aux gens qui ont déjà payé"]
[]
[]
[]
[]
[null,null,null,null,null,"Vers la feuille"]

{"sheet":"Question4_Solution","index":16,"n_rows":17,"n_cols":13,"rows_kept":17,"cut":false,"hidden":true,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,"Retour TDM"]
["A partir de la feuille 'Question1_Solution', affichez les lignes qui correspondent aux gens qui ont déjà payé"]
[]
[]
[]
[null,"A payé"]
[null,"OUI",null,null,null,"Vers la feuille"]
[]
[]
[]
[]
[]
[null,"Nom du\ncontribuable","Prénom du\ncontribuable"]
[null,"Auvertcestpasbon","Elvire"]
[null,"Namuralanagecestdifficile","Ferdinand"]
[null,"Enfaillite","Mélusine"]
[null,"Heurindélébil ","Marc"]

{"sheet":"Question5","index":17,"n_rows":7,"n_cols":13,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,"Retour TDM"]
["A partir de 'Compter par Power Query', affichez les noms des familles qui comptent 3 enfants ou plus"]
[]
[]
[]
[]
[null,null,null,null,null,"Vers la feuille"]

{"sheet":"Question5_Solution","index":18,"n_rows":23,"n_cols":13,"rows_kept":23,"cut":false,"hidden":true,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,"Retour TDM"]
["A partir de 'Compter par Power Query_Solution', affichez les noms des familles qui comptent 3 enfants ou plus"]
[]
[]
[]
[]
[null,"Nombre",null,null,null,"Vers la feuille"]
[null,">=3"]
[]
[]
[]
[]
[null,"Nom","Nombre"]
[null,"Cale",3]
[null,"Danslefrigo",3]
[null,"Froid",5]
[null,"Hole",4]
[null,"Itiative",3]
[null,"Jyraipas",4]
[null,"Nains",3]
[null,"Pachaire",3]
[null,"Pourien",3]
[null,"Tuation",4]

{"sheet":"Question6","index":19,"n_rows":7,"n_cols":13,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,"Retour TDM"]
["A partir de la feuille 'Question1', affichez les lignes qui correspondent aux gens dont la date limite de payement est dépassée, mais n'a pas encore atteint les 15 jours de retard."]
[]
[]
[]
[]
[null,null,null,null,null,"Vers la feuille"]

{"sheet":"Question6_Solution","index":20,"n_rows":18,"n_cols":13,"rows_kept":18,"cut":false,"hidden":true,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,"Retour TDM"]
["A partir de la feuille 'Question1_Solution', affichez les lignes qui correspondent aux gens dont la date limite de payement est dépassée, mais n'a pas encore atteint les 15 jours de retard."]
[]
[]
[]
[]
[null,"Date limite\nde payement","Date limite\nde payement",null,null,"Vers la feuille"]
[null,{"$f":"\">\"&TEXT(TODAY(),\"jj/mm/aaaa\")","v":">17/04/2024"},{"$f":"\"<\"&TEXT(TODAY()+15,\"jj/mm/aaaa\")","v":"<02/05/2024"}]
[]
[]
[]
[]
[]
[null,"Nom du\ncontribuable","Prénom du\ncontribuable","Montant\nà payer","Date limite\nde payement","A payé","Montant des frais de retard"]
[null,"Froid","Aude",240,"2023-12-17","non",0]
[null,"Froid","Anne",1050,"2023-12-14","non",0]
[null,"Deblouze","Agathe",1400,"2023-12-21","non",0]
[null,"Tredelè","Willy",300,"2023-12-21","non",0]

{"sheet":"Question7","index":21,"n_rows":7,"n_cols":10,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["A partir de la feuille 'Question1_Solution', affichez les lignes qui correspondent aux gens",null,null,null,null,null,null,null,null,"Retour TDM"]
["des familles 'Chmonfils' et 'Froid' qui n'ont pas encore payé et dont la date limite de payement est dépassée."]
[]
[]
[]
[]
[null,null,null,null,null,"Vers la feuille"]

{"sheet":"Question7_Solution","index":22,"n_rows":18,"n_cols":10,"rows_kept":18,"cut":false,"hidden":true,"merged":[]}
["A partir de la feuille 'Question1_Solution', affichez les lignes qui correspondent aux gens",null,null,null,null,null,null,null,null,"Retour TDM"]
["des familles 'Chmonfils' et 'Froid' qui n'ont pas encore payé et dont la date limite de payement est dépassée."]
[]
[]
[]
[]
[null,"Nom du\ncontribuable","A payé","Date limite\nde payement",null,"Vers la feuille"]
[null,"Chmonfils ","NON",{"$f":"\">\"&TEXT(TODAY(),\"jj/mm/aaaa\")","v":">17/04/2024"}]
[null,"Froid","NON",{"$f":"\">\"&TEXT(TODAY(),\"jj/mm/aaaa\")","v":">17/04/2024"}]
[]
[]
[]
[]
[null,"Nom du\ncontribuable","Prénom du\ncontribuable","Montant\nà payer","Date limite\nde payement","A payé","Montant des frais de retard"]
[null,"Froid","Sylva",500,"2023-12-29","non",0]
[null,"Froid","Aude",240,"2023-12-17","non",0]
[null,"Froid","Anne",1050,"2023-12-14","non",0]
[null,"Froid","Laura",120,"2024-01-09","non",0]