{"text_format":"1","workbook":"xlsx","n_sheets":62,"sheets":["Sommaire","Introduction","Introduction_corrigé","Bdd1_consignes","Bdd1","Bdd1_corrigé","Tranches","Tranches_corrigé","Tri1","Tri1_corrigé","Tri2","Tri2_corrigé","Filtre1","Filtre1_corrigé","Filtre1 (2)","Filtre1 (2)_corrigé","Filtre2","Filtre2_corrigé","Filtre3","Filtre3_corrigé","Filtre4","Filtre4_corrigé","Filtre5","Filtre5_corrigé","FiltresElabDonnées","FiltreElab1","FiltreElab1_corrigé","FiltreElab2","FiltreElab2_corrigé","FiltreElab3","FiltreElab3_corrigé","FiltreElab4","FiltreElab4_corrigé","FiltreElab5","FiltreElab5_corrigé","FiltreElab6","FiltreElab6_corrigé","Fonctions classiques","Fonctions classiques_corrigé","Sous-Totaux1","Sous-Totaux1_corrigé","Sous-Totaux2","Sous-Totaux2_corrigé","Sous-Totaux3","Sous-Totaux3_corrigé","Sous-Totaux4 (Fonctions)","Sous-Totaux4 (Fcts)_corrigé","Fcts classiques - Tableaux","Fcts classiques-Tbl_corrigé","TCD_données","TCD1","TCD1_corrigé","TCD2","TCD2_corrigé","TCD3","TCD3_corrigé","TCD4","TCD4_corrigé","TCD5","TCD5_corrigé","TCD6","TCD6_corrigé"],"not_rendered":{"charts":1,"images":2,"macros":1,"external_links":0,"defined_names":46,"comments":0,"pivot_tables":6},"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":38,"n_cols":5,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Introduction, révision"]
[null,"Références absolues, rechercheV","Introduction"]
[]
[null,"Liste de données, création","Application",null,"Ci-contre, vous pouvez utiliser les liens hypertextes de façon à atteindre une application selon le thème précisé en colonne B."]
[null,null,"Divers",null,"Sur chaque feuille est présenté l'exercice à réaliser. Un bouton 'Help' permet d'afficher la feuille contenant le corrigé."]
[null,null,null,null,"Avant de commencer, masquer tous les corrigés en utilisant le bouton de la barre d'outils 'Employés'"]
[null,"Trier les données","Tri1"]
[null,null,"Tri2"]
[]
[null,"Filtres automatiques","Filtre1"]
[null,null,"Filtre1 (2)"]
[null,null,"Filtre2"]
[null,null,"Filtre3"]
[null,null,"Filtre4"]
[null,null,"Filtre5"]
[]
[null,"Filtres élaborés","FiltreElab1"]
[null,null,"FiltreElab2"]
[null,null,"FiltreElab3"]
[null,null,"FiltreElab4"]
[null,null,"FiltreElab5"]
[null,null,"FiltreElab6"]
[]
[null,"Fonctions classiques","Fonctions classiques"]
[null,null,"Fonctions classiques avec tableau de données"]
[]
[null,"Sous-totaux","Sous-totaux1"]
[null,null,"Sous-totaux2"]
[null,null,"Sous-totaux3"]
[null,null,"Sous-totaux4"]
[]
[null,"Tableaux croisés dynamiques","TCD1"]
[null,null,"TCD2"]
[null,null,"TCD3"]
[null,null,"TCD4"]
[null,null,"TCD5"]
[null,null,"TCD6"]

{"sheet":"Introduction","index":1,"n_rows":47,"n_cols":18,"rows_kept":47,"cut":false,"hidden":false,"merged":[]}
["Titre","Référence de l'auteur","Prix","Prix avec réduction","Nom de l'auteur","Prénom de l'auteur",null,null,null,null,null,null,"Retour sommaire",null,null,"Titre","Prix","Prix avec réduction"]
["Cartes sur table",13,10,null,null,null,null,"1) Calculez le prix avec réduction (= prix - taux * prix ). Utilisez le taux se trouvant dans la cellule ci-dessous",null,null,null,null,null,null,null,"Cartes sur table",10]
["Drame en trois actes",13,12,null,null,null,null,"2) Recommencez la même chose en utilisant la \"propagation\" des formules (CF Colonne P)",null,null,null,null,null,null,null,"Drame en trois actes",12]
["Contes",2,12,null,null,null,null,"3) Recommencez la même chose en utilisant les tableaux de données (CF ci-dessous)",null,null,null,null,null,null,null,"Contes",12]
["Dix petits nègres",13,15,null,null,null,null,null,null,null,null,null,null,null,null,"Dix petits nègres",15]
["Café turc",5,12,null,null,null,null,"Taux : ",0.1,null,null,null,null,null,null,"Café turc",12]
["Poétique",4,18,null,null,null,null,null,null,null,null,null,null,null,null,"Poétique",18]
["La Main froide",12,12,null,null,null,null,"2) A partir de la liste ci-dessous, complétez les noms et prénoms des auteurs",null,null,null,null,null,null,null,"La Main froide",12]
["Cinq petits cochons",13,12,null,null,null,null,"2Bis) Recommencez la même chose en utilisant les tableaux de données  (CF ci-dessous)",null,null,null,null,null,null,null,"Cinq petits cochons",12]
["Conan Lord",12,17,null,null,null,null,null,null,null,null,null,null,null,null,"Conan Lord",17]
["La mort l'aime chaud",11,12,null,null,null,null,null,"Id_Auteur","Nom","Prénom",null,null,null,null,"La mort l'aime chaud",12]
["Le Spleen de Paris",8,15,null,null,null,null,null,1,"Alain-Fournier","",null,null,null,null,"Le Spleen de Paris",15]
["La Case de l'oncle Tom",9,10,null,null,null,null,null,2,"Andersen","Hans Christian",null,null,null,null,"La Case de l'oncle Tom",10]
["Jeux de glaces",13,15,null,null,null,null,null,4,"Aristote","",null,null,null,null,"Jeux de glaces",15]
["Rhétorique",4,18,null,null,null,null,null,5,"Arjouni","Jakob",null,null,null,null,"Rhétorique",18]
["L'étameur des morts",6,12,null,null,null,null,null,6,"Arnaud","Georges J.",null,null,null,null,"L'étameur des morts",12]
["A.B.C. contre Poirot",13,12,null,null,null,null,null,7,"Balzac (de)","Honoré",null,null,null,null,"A.B.C. contre Poirot",12]
["le mystérieux Mr Quinn",13,15,null,null,null,null,null,8,"Baudelaire","Charles",null,null,null,null,"le mystérieux Mr Quinn",15]
["L'heure zéro",13,15,null,null,null,null,null,9,"Beecher-Stowe","Harriet",null,null,null,null,"L'heure zéro",15]
["La Fille de la nuit",12,10,null,null,null,null,null,10,"Boccace","Giovanni",null,null,null,null,"La Fille de la nuit",10]
[null,null,null,null,null,null,null,null,11,"Box","Edgar"]
[null,null,null,null,null,null,null,null,12,"Brussolo","Serge"]
[null,null,null,null,null,null,null,null,13,"Christie","Agatha"]
[]
[]
[]
[]
["Titre","Référence de l'auteur","Prix","Prix avec réduction","Nom de l'auteur","Prénom de l'auteur",null,"3) Recommencez la même chose en utilisant les tableaux de données"]
["Cartes sur table",13,10]
["Drame en trois actes",13,12]
["Contes",2,12,null,null,null,null,"Taux : ",0.1]
["Dix petits nègres",13,15]
["Café turc",5,12,null,null,null,null,"2Bis) Recommencez la même chose en utilisant les tableaux de données"]
["Poétique",4,18]
["La Main froide",12,12,null,null,null,null,null,"Id_Auteur","Nom","Prénom"]
["Cinq petits cochons",13,12,null,null,null,null,null,1,"Alain-Fournier",""]
["Conan Lord",12,17,null,null,null,null,null,2,"Andersen","Hans Christian"]
["La mort l'aime chaud",11,12,null,null,null,null,null,4,"Aristote",""]
["Le Spleen de Paris",8,15,null,null,null,null,null,5,"Arjouni","Jakob"]
["La Case de l'oncle Tom",9,10,null,null,null,null,null,6,"Arnaud","Georges J."]
["Jeux de glaces",13,15,null,null,null,null,null,7,"Balzac (de)","Honoré"]
["Rhétorique",4,18,null,null,null,null,null,8,"Baudelaire","Charles"]
["L'étameur des morts",6,12,null,null,null,null,null,9,"Beecher-Stowe","Harriet"]
["A.B.C. contre Poirot",13,12,null,null,null,null,null,10,"Boccace","Giovanni"]
["le mystérieux Mr Quinn",13,15,null,null,null,null,null,11,"Box","Edgar"]
["L'heure zéro",13,15,null,null,null,null,null,12,"Brussolo","Serge"]
["La Fille de la nuit",12,10,null,null,null,null,null,13,"Christie","Agatha"]

{"sheet":"Introduction_corrigé","index":2,"n_rows":47,"n_cols":18,"rows_kept":47,"cut":false,"hidden":true,"merged":[]}
["Titre","Référence de l'auteur","Prix","Prix avec réduction","Nom de l'auteur","Prénom de l'auteur",null,null,null,null,null,null,null,null,null,"Titre","Prix","Prix avec Réduction"]
["Cartes sur table",13,10,{"$f":"C2-$I$6*C2","v":9},{"$f":"VLOOKUP(B2,$I$12:$K$23,2)","v":"Christie"},{"$f":"_xlfn.XLOOKUP(B2,$I$12:$I$23,$J$12:$J$23,,0)","v":"Christie"},null,"1) Calculez le prix avec réduction (= prix - taux * prix ). Utilisez le taux se trouvant dans la cellule ci-dessous",null,null,null,null,null,null,null,"Cartes sur table",10,{"$f":"Q2:Q20-$I$6*Q2:Q20","v":9}]
["Drame en trois actes",13,12,10.8,{"$f":"VLOOKUP(B3,$I$12:$K$23,2)","v":"Christie"},"Christie",null,"2) Recommencez la même chose en utilisant la \"propagation\" des formules (CF Colonne P)",null,null,null,null,null,null,null,"Drame en trois actes",12,10.8]
["Contes",2,12,10.8,"Andersen","Andersen",null,"3) Recommencez la même chose en utilisant les tableaux de données",null,null,null,null,null,null,null,"Contes",12,10.8]
["Dix petits nègres",13,15,13.5,"Christie","Christie",null,null,null,null,null,null,null,null,null,"Dix petits nègres",15,13.5]
["Café turc",5,12,10.8,"Arjouni","Arjouni",null,"Taux : ",0.1,null,null,null,null,null,null,"Café turc",12,10.8]
["Poétique",4,18,16.2,"Aristote","Aristote",null,null,null,null,null,null,null,null,null,"Poétique",18,16.2]
["La Main froide",12,12,10.8,"Brussolo","Brussolo",null,"2) A partir de la liste ci-dessous, complétez les noms et prénoms des auteurs",null,null,null,null,null,null,null,"La Main froide",12,10.8]
["Cinq petits cochons",13,12,10.8,"Christie","Christie",null,"2Bis) Dans les colonnes 'Nom 2' et 'Prénom 2',recommencez la même chose en utilisant les tableaux de données",null,null,null,null,null,null,null,"Cinq petits cochons",12,10.8]
["Conan Lord",12,17,15.3,"Brussolo","Brussolo",null,null,null,null,null,null,null,null,null,"Conan Lord",17,15.3]
["La mort l'aime chaud",11,12,10.8,"Box","Box",null,null,"Id_Auteur","Nom","Prénom",null,null,null,null,"La mort l'aime chaud",12,10.8]
["Le Spleen de Paris",8,15,13.5,"Baudelaire","Baudelaire",null,null,1,"Alain-Fournier","",null,null,null,null,"Le Spleen de Paris",15,13.5]
["La Case de l'oncle Tom",9,10,9,"Beecher-Stowe","Beecher-Stowe",null,null,2,"Andersen","Hans Christian",null,null,null,null,"La Case de l'oncle Tom",10,9]
["Jeux de glaces",13,15,13.5,"Christie","Christie",null,null,4,"Aristote","",null,null,null,null,"Jeux de glaces",15,13.5]
["Rhétorique",4,18,16.2,"Aristote","Aristote",null,null,5,"Arjouni","Jakob",null,null,null,null,"Rhétorique",18,16.2]
["L'étameur des morts",6,12,10.8,"Arnaud","Arnaud",null,null,6,"Arnaud","Georges J.",null,null,null,null,"L'étameur des morts",12,10.8]
["A.B.C. contre Poirot",13,12,10.8,"Christie","Christie",null,null,7,"Balzac (de)","Honoré",null,null,null,null,"A.B.C. contre Poirot",12,10.8]
["le mystérieux Mr Quinn",13,15,13.5,"Christie","Christie",null,null,8,"Baudelaire","Charles",null,null,null,null,"le mystérieux Mr Quinn",15,13.5]
["L'heure zéro",13,15,13.5,"Christie","Christie",null,null,9,"Beecher-Stowe","Harriet",null,null,null,null,"L'heure zéro",15,13.5]
["La Fille de la nuit",12,10,9,"Brussolo","Brussolo",null,null,10,"Boccace","Giovanni",null,null,null,null,"La Fille de la nuit",10,9]
[null,null,null,null,null,null,null,null,11,"Box","Edgar",null,null,null,null,"Test",25]
[null,null,null,null,null,null,null,null,12,"Brussolo","Serge"]
[null,null,null,null,null,null,null,null,13,"Christie","Agatha"]
[]
[]
[]
[]
["Titre","Référence de l'auteur","Prix","Prix avec réduction","Nom de l'auteur","Prénom de l'auteur",null,"3) Recommencez la même chose en utilisant les tableaux de données"]
["Cartes sur table",13,10,{"$f":"Tableau3[[#This Row],[Prix]]-Tableau4[Colonne1]*Tableau3[[#This Row],[Prix]]","v":9},{"$f":"VLOOKUP(Tableau3[[#This Row],[Référence de l''auteur]],Tableau5[],2,FALSE)","v":"Christie"},{"$f":"_xlfn.XLOOKUP(Tableau3[[#This Row],[Référence de l''auteur]],Tableau5[Id_Auteur],Tableau5[Prénom],,0)","v":"Agatha"}]
["Drame en trois actes",13,12,{"$f":"Tableau3[[#This Row],[Prix]]-Tableau4[Colonne1]*Tableau3[[#This Row],[Prix]]","v":10.8},{"$f":"VLOOKUP(Tableau3[[#This Row],[Référence de l''auteur]],Tableau5[],2,FALSE)","v":"Christie"},{"$f":"_xlfn.XLOOKUP(Tableau3[[#This Row],[Référence de l''auteur]],Tableau5[Id_Auteur],Tableau5[Prénom],,0)","v":"Agatha"},null,null,"Colonne1"]
["Contes",2,12,{"$f":"Tableau3[[#This Row],[Prix]]-Tableau4[Colonne1]*Tableau3[[#This Row],[Prix]]","v":10.8},{"$f":"VLOOKUP(Tableau3[[#This Row],[Référence de l''auteur]],Tableau5[],2,FALSE)","v":"Andersen"},{"$f":"_xlfn.XLOOKUP(Tableau3[[#This Row],[Référence de l''auteur]],Tableau5[Id_Auteur],Tableau5[Prénom],,0)","v":"Hans Christian"},null,"Taux : ",0.1]
["Dix petits nègres",13,15,{"$f":"Tableau3[[#This Row],[Prix]]-Tableau4[Colonne1]*Tableau3[[#This Row],[Prix]]","v":13.5},{"$f":"VLOOKUP(Tableau3[[#This Row],[Référence de l''auteur]],Tableau5[],2,FALSE)","v":"Christie"},{"$f":"_xlfn.XLOOKUP(Tableau3[[#This Row],[Référence de l''auteur]],Tableau5[Id_Auteur],Tableau5[Prénom],,0)","v":"Agatha"}]
["Café turc",5,12,{"$f":"Tableau3[[#This Row],[Prix]]-Tableau4[Colonne1]*Tableau3[[#This Row],[Prix]]","v":10.8},{"$f":"VLOOKUP(Tableau3[[#This Row],[Référence de l''auteur]],Tableau5[],2,FALSE)","v":"Arjouni"},{"$f":"_xlfn.XLOOKUP(Tableau3[[#This Row],[Référence de l''auteur]],Tableau5[Id_Auteur],Tableau5[Prénom],,0)","v":"Jakob"},null,"2Bis) Recommencez la même chose en utilisant les tableaux de données"]
["Poétique",4,18,{"$f":"Tableau3[[#This Row],[Prix]]-Tableau4[Colonne1]*Tableau3[[#This Row],[Prix]]","v":16.2},{"$f":"VLOOKUP(Tableau3[[#This Row],[Référence de l''auteur]],Tableau5[],2,FALSE)","v":"Aristote"},{"$f":"_xlfn.XLOOKUP(Tableau3[[#This Row],[Référence de l''auteur]],Tableau5[Id_Auteur],Tableau5[Prénom],,0)","v":""}]
["La Main froide",12,12,{"$f":"Tableau3[[#This Row],[Prix]]-Tableau4[Colonne1]*Tableau3[[#This Row],[Prix]]","v":10.8},{"$f":"VLOOKUP(Tableau3[[#This Row],[Référence de l''auteur]],Tableau5[],2,FALSE)","v":"Brussolo"},{"$f":"_xlfn.XLOOKUP(Tableau3[[#This Row],[Référence de l''auteur]],Tableau5[Id_Auteur],Tableau5[Prénom],,0)","v":"Serge"},null,null,"Id_Auteur","Nom","Prénom"]
["Cinq petits cochons",13,12,{"$f":"Tableau3[[#This Row],[Prix]]-Tableau4[Colonne1]*Tableau3[[#This Row],[Prix]]","v":10.8},{"$f":"VLOOKUP(Tableau3[[#This Row],[Référence de l''auteur]],Tableau5[],2,FALSE)","v":"Christie"},{"$f":"_xlfn.XLOOKUP(Tableau3[[#This Row],[Référence de l''auteur]],Tableau5[Id_Auteur],Tableau5[Prénom],,0)","v":"Agatha"},null,null,1,"Alain-Fournier",""]
["Conan Lord",12,17,{"$f":"Tableau3[[#This Row],[Prix]]-Tableau4[Colonne1]*Tableau3[[#This Row],[Prix]]","v":15.3},{"$f":"VLOOKUP(Tableau3[[#This Row],[Référence de l''auteur]],Tableau5[],2,FALSE)","v":"Brussolo"},{"$f":"_xlfn.XLOOKUP(Tableau3[[#This Row],[Référence de l''auteur]],Tableau5[Id_Auteur],Tableau5[Prénom],,0)","v":"Serge"},null,null,2,"Andersen","Hans Christian"]
["La mort l'aime chaud",11,12,{"$f":"Tableau3[[#This Row],[Prix]]-Tableau4[Colonne1]*Tableau3[[#This Row],[Prix]]","v":10.8},{"$f":"VLOOKUP(Tableau3[[#This Row],[Référence de l''auteur]],Tableau5[],2,FALSE)","v":"Box"},{"$f":"_xlfn.XLOOKUP(Tableau3[[#This Row],[Référence de l''auteur]],Tableau5[Id_Auteur],Tableau5[Prénom],,0)","v":"Edgar"},null,null,4,"Aristote",""]
["Le Spleen de Paris",8,15,{"$f":"Tableau3[[#This Row],[Prix]]-Tableau4[Colonne1]*Tableau3[[#This Row],[Prix]]","v":13.5},{"$f":"VLOOKUP(Tableau3[[#This Row],[Référence de l''auteur]],Tableau5[],2,FALSE)","v":"Baudelaire"},{"$f":"_xlfn.XLOOKUP(Tableau3[[#This Row],[Référence de l''auteur]],Tableau5[Id_Auteur],Tableau5[Prénom],,0)","v":"Charles"},null,null,5,"Arjouni","Jakob"]
["La Case de l'oncle Tom",9,10,{"$f":"Tableau3[[#This Row],[Prix]]-Tableau4[Colonne1]*Tableau3[[#This Row],[Prix]]","v":9},{"$f":"VLOOKUP(Tableau3[[#This Row],[Référence de l''auteur]],Tableau5[],2,FALSE)","v":"Beecher-Stowe"},{"$f":"_xlfn.XLOOKUP(Tableau3[[#This Row],[Référence de l''auteur]],Tableau5[Id_Auteur],Tableau5[Prénom],,0)","v":"Harriet"},null,null,6,"Arnaud","Georges J."]
["Jeux de glaces",13,15,{"$f":"Tableau3[[#This Row],[Prix]]-Tableau4[Colonne1]*Tableau3[[#This Row],[Prix]]","v":13.5},{"$f":"VLOOKUP(Tableau3[[#This Row],[Référence de l''auteur]],Tableau5[],2,FALSE)","v":"Christie"},{"$f":"_xlfn.XLOOKUP(Tableau3[[#This Row],[Référence de l''auteur]],Tableau5[Id_Auteur],Tableau5[Prénom],,0)","v":"Agatha"},null,null,7,"Balzac (de)","Honoré"]
["Rhétorique",4,18,{"$f":"Tableau3[[#This Row],[Prix]]-Tableau4[Colonne1]*Tableau3[[#This Row],[Prix]]","v":16.2},{"$f":"VLOOKUP(Tableau3[[#This Row],[Référence de l''auteur]],Tableau5[],2,FALSE)","v":"Aristote"},{"$f":"_xlfn.XLOOKUP(Tableau3[[#This Row],[Référence de l''auteur]],Tableau5[Id_Auteur],Tableau5[Prénom],,0)","v":""},null,null,8,"Baudelaire","Charles"]
["L'étameur des morts",6,12,{"$f":"Tableau3[[#This Row],[Prix]]-Tableau4[Colonne1]*Tableau3[[#This Row],[Prix]]","v":10.8},{"$f":"VLOOKUP(Tableau3[[#This Row],[Référence de l''auteur]],Tableau5[],2,FALSE)","v":"Arnaud"},{"$f":"_xlfn.XLOOKUP(Tableau3[[#This Row],[Référence de l''auteur]],Tableau5[Id_Auteur],Tableau5[Prénom],,0)","v":"Georges J."},null,null,9,"Beecher-Stowe","Harriet"]
["A.B.C. contre Poirot",13,12,{"$f":"Tableau3[[#This Row],[Prix]]-Tableau4[Colonne1]*Tableau3[[#This Row],[Prix]]","v":10.8},{"$f":"VLOOKUP(Tableau3[[#This Row],[Référence de l''auteur]],Tableau5[],2,FALSE)","v":"Christie"},{"$f":"_xlfn.XLOOKUP(Tableau3[[#This Row],[Référence de l''auteur]],Tableau5[Id_Auteur],Tableau5[Prénom],,0)","v":"Agatha"},null,null,10,"Boccace","Giovanni"]
["le mystérieux Mr Quinn",13,15,{"$f":"Tableau3[[#This Row],[Prix]]-Tableau4[Colonne1]*Tableau3[[#This Row],[Prix]]","v":13.5},{"$f":"VLOOKUP(Tableau3[[#This Row],[Référence de l''auteur]],Tableau5[],2,FALSE)","v":"Christie"},{"$f":"_xlfn.XLOOKUP(Tableau3[[#This Row],[Référence de l''auteur]],Tableau5[Id_Auteur],Tableau5[Prénom],,0)","v":"Agatha"},null,null,11,"Box","Edgar"]
["L'heure zéro",13,15,{"$f":"Tableau3[[#This Row],[Prix]]-Tableau4[Colonne1]*Tableau3[[#This Row],[Prix]]","v":13.5},{"$f":"VLOOKUP(Tableau3[[#This Row],[Référence de l''auteur]],Tableau5[],2,FALSE)","v":"Christie"},{"$f":"_xlfn.XLOOKUP(Tableau3[[#This Row],[Référence de l''auteur]],Tableau5[Id_Auteur],Tableau5[Prénom],,0)","v":"Agatha"},null,null,12,"Brussolo","Serge"]
["La Fille de la nuit",12,10,{"$f":"Tableau3[[#This Row],[Prix]]-Tableau4[Colonne1]*Tableau3[[#This Row],[Prix]]","v":9},{"$f":"VLOOKUP(Tableau3[[#This Row],[Référence de l''auteur]],Tableau5[],2,FALSE)","v":"Brussolo"},{"$f":"_xlfn.XLOOKUP(Tableau3[[#This Row],[Référence de l''auteur]],Tableau5[Id_Auteur],Tableau5[Prénom],,0)","v":"Serge"},null,null,13,"Christie","Agatha"]

{"sheet":"Bdd1_consignes","index":3,"n_rows":57,"n_cols":13,"rows_kept":57,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,"Retour sommaire"]
[]
[null,"1) Utilisez des listes afin d'obliger l'utilisateur à choisir un des éléments prévus ci-dessous de façon à compléter la colonnes des services"]
[]
[null,"NB1 : ceci a déjà été réalisé pour la colonne 'Etat civil'"]
[]
[null,"NB2 : les éléments des listes sont les suivants. Services 1 sera utilisé pour les éléments de la colonne J (Services 1) et 'Services 2' pour les éléments de la colonne J (Services 2). Services 3 est utilisé dans le corrigé"]
[]
[null,null,"Etat civil",null,"Services 1",null,"Services 2",null,"Services 3",null,"NB :","1- Créez un tableau des services"]
[null,null,"Marié(e)",null,"Secrétariat",null,"Secrétariat",null,"Secrétariat",null,null,"2- Nommez la plage (G10:G13) qui reprend les services "]
[null,null,"Célibataire",null,"Direction",null,"Direction",null,"Direction",null,null,"3- Indiquez le nom de la plage nommée en tant que source de la liste"]
[null,null,"Divorcé(e)",null,"Personnel",null,"Personnel",null,"Personnel"]
[null,null,null,null,"Informatique",null,"Informatique",null,"Informatique"]
[null,null,null,null,null,null,null,null,"RH"]
[]
[]
[null,"2) Utilisez le tableau suivant de façon à obtenir la ville qui correspond au code postal de la personne"]
[null,"Le premier tableau sera utilisé pour une 'Recherche' classique, le second pour une recherche dans un tableau de données, le 3ème est utilisé pour le corrigé"]
[]
[]
[null,null,"CP","Ville",null,"CP","Ville",null,"CP","Ville"]
[null,null,1030,"Schaerbeek",null,1030,"Schaerbeek",null,1030,"Schaerbeek"]
[null,null,1000,"Bruxelles",null,1000,"Bruxelles",null,1000,"Bruxelles"]
[null,null,1070,"Anderlecht",null,1070,"Anderlecht",null,1070,"Anderlecht"]
[null,null,1050,"Ixelles",null,1050,"Ixelles",null,1050,"Ixelles"]
[null,null,1060,"Saint-Gilles",null,1060,"Saint-Gilles",null,1060,"Saint-Gilles"]
[null,null,1040,"Etterbeek",null,1040,"Etterbeek",null,1040,"Etterbeek"]
[]
[null,"3) Calculez les âges des employés"]
[]
[null,"4) Calculez la tranche d'ancienneté en fonction de l'âge"]
[]
[null,"NB : les tranches sont calculées selon ceci"]
[]
[null,null,"Age","Tranches"]
[null,null,"<25",0]
[null,null,">=25 et <35",1]
[null,null,">=35 et <45",2]
[null,null,">=45 et <55",3]
[null,null,">=55",4]
[]
[]
[null,"5) Calculez le salaire : salaire minimum + 5% * tranche * salaire minimum"]
[]
[null,"NB : Le salaire minimum est obtenu selon ce tableau en utilisant une recherche dans un tableau de données avec RechercheX"]
[null,"NB2 : Le second tableau est utilisé dans le corrigé"]
[]
[]
[null,null,"Services","Salaire minimum",null,null,"Services","Salaire minimum"]
[null,null,"Direction",2500,null,null,"Direction",2500]
[null,null,"Informatique",1900,null,null,"Informatique",1900]
[null,null,"Secrétariat",1700,null,null,"Secrétariat",1700]
[null,null,"Personnel",1600,null,null,"Personnel",1600]
[null,null,"RH",2600,null,null,"RH",2600]
[]
[]
[null,"6) Enlevez l'erreur des lignes pour lesquelles aucun service n'est encore choisi"]

{"sheet":"Bdd1","index":4,"n_rows":27,"n_cols":17,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
["Nom","Prénom","Sexe","Etat civil","CP","Ville 1","Ville 2","Date de naissance","Age","Tranches","Services 1","Services 2","Salaires Min","Salaires",null,null,"Retour sommaire"]
["Bistrot","Alonso","m","Marié(e)",1030,null,null,"1966-01-17"]
["Bijoba","Jo","m","Marié(e)",1000,null,null,"1980-03-15"]
["Covert","Harry","m","Divorcé(e)",1000,null,null,"1942-02-10"]
["Culaire","Laury","m","Marié(e)",1030,null,null,"1965-05-05"]
["Deuf","John","m","Célibataire",1070,null,null,"1963-09-08"]
["Foupasune","Jean","m","Célibataire",1070,null,null,"1975-08-07"]
["Lairbon","Oussama","m","Marié(e)",1030,null,null,"1983-02-08"]
["Menvussa","Gérard","m","Célibataire",1050,null,null,"1970-12-04"]
["Lalalalalalala","Starsky","m","Célibataire",1060,null,null,"1955-07-08"]
["Lalalalalalala","Hutch","m","Divorcé(e)",1050,null,null,"1952-10-07"]
["Cléssoulaporte","Djamila","f","Marié(e)",1050,null,null,"1959-09-07"]
["Noux","Marion","f","Divorcé(e)",1050,null,null,"1978-12-30"]
["Ouzi","Jacques","m","Célibataire",1000,null,null,"1969-02-28"]
["Stiké","Sophie","f","Divorcé(e)",1070,null,null,"1959-04-04"]
["Tare","Guy","m","Divorcé(e)",1070,null,null,"1960-08-07"]
["Vaisselle","Aude","f","Marié(e)",1070,null,null,"1966-06-06"]
["Zetofrais","Mélanie","f",null,1070,null,null,"1978-11-25"]
["Touille","Sasha","m",null,1070,null,null,"1982-10-30"]
["Proviste","Alain","m",null,1030,null,null,"1959-09-09"]
["Peulaporte","Firmin","m",null,1040,null,null,"1965-07-01"]
["Unetitlaine","Jérémy","m",null,1030,null,null,"1983-06-09"]
[]
[]
[]
["NB1 : les consignes sont précisées sur la feuille précédente."]
["NB2 : Les calculs seront réalisés après avoir créé un tableau de données (Sélection .. Mettre sous forme de tableau)"]

{"sheet":"Bdd1_corrigé","index":5,"n_rows":22,"n_cols":14,"rows_kept":22,"cut":false,"hidden":true,"merged":[]}
["Nom","Prénom","Sexe","Etat civil","CP","Ville 1","Ville 2","Date de naissance","Age","Tranches","Services","Services 3","Salaires Min","Salaires"]
["Bistrot","Alonso","m","Marié(e)",1030,{"$f":"VLOOKUP(Tableau8[[#This Row],[CP]],Bdd1_consignes!$C$22:$D$27,2,FALSE)","v":"Schaerbeek"},{"$f":"VLOOKUP(Tableau8[[#This Row],[CP]],Tableau10[],2,FALSE)","v":"Schaerbeek"},"1966-01-17",{"$f":"DATEDIF(Tableau8[[#This Row],[Date de naissance]],TODAY(),\"y\")","v":57},{"$f":"IF(Tableau8[[#This Row],[Age]]<25,0,IF(Tableau8[[#This Row],[Age]]<35,1,IF(Tableau8[[#This Row],[Age]]<45,2,IF(Tableau8[[#This Row],[Age]]<55,3,4))))","v":4},"Informatique","Informatique",{"$f":"_xlfn.XLOOKUP(Tableau8[[#This Row],[Services]],Tableau7[Services],Tableau7[Salaire minimum],\"\",0)","v":1900},{"$f":"IF(Tableau8[[#This Row],[Salaires Min]]=\"\",\"\",Tableau8[[#This Row],[Salaires Min]]+5%*Tableau8[[#This Row],[Tranches]]*Tableau8[[#This Row],[Salaires Min]])","v":2280}]
["Bijoba","Jo","m","Marié(e)",1000,{"$f":"VLOOKUP(Tableau8[[#This Row],[CP]],Bdd1_consignes!$C$22:$D$27,2,FALSE)","v":"Bruxelles"},{"$f":"VLOOKUP(Tableau8[[#This Row],[CP]],Tableau10[],2,FALSE)","v":"Bruxelles"},"1980-03-15",{"$f":"DATEDIF(Tableau8[[#This Row],[Date de naissance]],TODAY(),\"y\")","v":43},{"$f":"IF(Tableau8[[#This Row],[Age]]<25,0,IF(Tableau8[[#This Row],[Age]]<35,1,IF(Tableau8[[#This Row],[Age]]<45,2,IF(Tableau8[[#This Row],[Age]]<55,3,4))))","v":2},"Direction","Direction",{"$f":"_xlfn.XLOOKUP(Tableau8[[#This Row],[Services]],Tableau7[Services],Tableau7[Salaire minimum],\"\",0)","v":2500},{"$f":"IF(Tableau8[[#This Row],[Salaires Min]]=\"\",\"\",Tableau8[[#This Row],[Salaires Min]]+5%*Tableau8[[#This Row],[Tranches]]*Tableau8[[#This Row],[Salaires Min]])","v":2750}]
["Covert","Harry","m","Divorcé(e)",1000,{"$f":"VLOOKUP(Tableau8[[#This Row],[CP]],Bdd1_consignes!$C$22:$D$27,2,FALSE)","v":"Bruxelles"},{"$f":"VLOOKUP(Tableau8[[#This Row],[CP]],Tableau10[],2,FALSE)","v":"Bruxelles"},"1942-02-10",{"$f":"DATEDIF(Tableau8[[#This Row],[Date de naissance]],TODAY(),\"y\")","v":81},{"$f":"IF(Tableau8[[#This Row],[Age]]<25,0,IF(Tableau8[[#This Row],[Age]]<35,1,IF(Tableau8[[#This Row],[Age]]<45,2,IF(Tableau8[[#This Row],[Age]]<55,3,4))))","v":4},"Personnel","Personnel",{"$f":"_xlfn.XLOOKUP(Tableau8[[#This Row],[Services]],Tableau7[Services],Tableau7[Salaire minimum],\"\",0)","v":1600},{"$f":"IF(Tableau8[[#This Row],[Salaires Min]]=\"\",\"\",Tableau8[[#This Row],[Salaires Min]]+5%*Tableau8[[#This Row],[Tranches]]*Tableau8[[#This Row],[Salaires Min]])","v":1920}]
["Culaire","Laury","m","Marié(e)",1030,{"$f":"VLOOKUP(Tableau8[[#This Row],[CP]],Bdd1_consignes!$C$22:$D$27,2,FALSE)","v":"Schaerbeek"},{"$f":"VLOOKUP(Tableau8[[#This Row],[CP]],Tableau10[],2,FALSE)","v":"Schaerbeek"},"1965-05-05",{"$f":"DATEDIF(Tableau8[[#This Row],[Date de naissance]],TODAY(),\"y\")","v":58},{"$f":"IF(Tableau8[[#This Row],[Age]]<25,0,IF(Tableau8[[#This Row],[Age]]<35,1,IF(Tableau8[[#This Row],[Age]]<45,2,IF(Tableau8[[#This Row],[Age]]<55,3,4))))","v":4},"Personnel","Personnel",{"$f":"_xlfn.XLOOKUP(Tableau8[[#This Row],[Services]],Tableau7[Services],Tableau7[Salaire minimum],\"\",0)","v":1600},{"$f":"IF(Tableau8[[#This Row],[Salaires Min]]=\"\",\"\",Tableau8[[#This Row],[Salaires Min]]+5%*Tableau8[[#This Row],[Tranches]]*Tableau8[[#This Row],[Salaires Min]])","v":1920}]
["Deuf","John","m","Célibataire",1070,{"$f":"VLOOKUP(Tableau8[[#This Row],[CP]],Bdd1_consignes!$C$22:$D$27,2,FALSE)","v":"Anderlecht"},{"$f":"VLOOKUP(Tableau8[[#This Row],[CP]],Tableau10[],2,FALSE)","v":"Anderlecht"},"1963-09-08",{"$f":"DATEDIF(Tableau8[[#This Row],[Date de naissance]],TODAY(),\"y\")","v":60},{"$f":"IF(Tableau8[[#This Row],[Age]]<25,0,IF(Tableau8[[#This Row],[Age]]<35,1,IF(Tableau8[[#This Row],[Age]]<45,2,IF(Tableau8[[#This Row],[Age]]<55,3,4))))","v":4},"Informatique","Informatique",{"$f":"_xlfn.XLOOKUP(Tableau8[[#This Row],[Services]],Tableau7[Services],Tableau7[Salaire minimum],\"\",0)","v":1900},{"$f":"IF(Tableau8[[#This Row],[Salaires Min]]=\"\",\"\",Tableau8[[#This Row],[Salaires Min]]+5%*Tableau8[[#This Row],[Tranches]]*Tableau8[[#This Row],[Salaires Min]])","v":2280}]
["Foupasune","Jean","m","Célibataire",1070,{"$f":"VLOOKUP(Tableau8[[#This Row],[CP]],Bdd1_consignes!$C$22:$D$27,2,FALSE)","v":"Anderlecht"},{"$f":"VLOOKUP(Tableau8[[#This Row],[CP]],Tableau10[],2,FALSE)","v":"Anderlecht"},"1975-08-07",{"$f":"DATEDIF(Tableau8[[#This Row],[Date de naissance]],TODAY(),\"y\")","v":48},{"$f":"IF(Tableau8[[#This Row],[Age]]<25,0,IF(Tableau8[[#This Row],[Age]]<35,1,IF(Tableau8[[#This Row],[Age]]<45,2,IF(Tableau8[[#This Row],[Age]]<55,3,4))))","v":3},"Personnel","Personnel",{"$f":"_xlfn.XLOOKUP(Tableau8[[#This Row],[Services]],Tableau7[Services],Tableau7[Salaire minimum],\"\",0)","v":1600},{"$f":"IF(Tableau8[[#This Row],[Salaires Min]]=\"\",\"\",Tableau8[[#This Row],[Salaires Min]]+5%*Tableau8[[#This Row],[Tranches]]*Tableau8[[#This Row],[Salaires Min]])","v":1840}]
["Lairbon","Oussama","m","Marié(e)",1030,{"$f":"VLOOKUP(Tableau8[[#This Row],[CP]],Bdd1_consignes!$C$22:$D$27,2,FALSE)","v":"Schaerbeek"},{"$f":"VLOOKUP(Tableau8[[#This Row],[CP]],Tableau10[],2,FALSE)","v":"Schaerbeek"},"1983-02-08",{"$f":"DATEDIF(Tableau8[[#This Row],[Date de naissance]],TODAY(),\"y\")","v":40},{"$f":"IF(Tableau8[[#This Row],[Age]]<25,0,IF(Tableau8[[#This Row],[Age]]<35,1,IF(Tableau8[[#This Row],[Age]]<45,2,IF(Tableau8[[#This Row],[Age]]<55,3,4))))","v":2},"Personnel","Personnel",{"$f":"_xlfn.XLOOKUP(Tableau8[[#This Row],[Services]],Tableau7[Services],Tableau7[Salaire minimum],\"\",0)","v":1600},{"$f":"IF(Tableau8[[#This Row],[Salaires Min]]=\"\",\"\",Tableau8[[#This Row],[Salaires Min]]+5%*Tableau8[[#This Row],[Tranches]]*Tableau8[[#This Row],[Salaires Min]])","v":1760}]
["Menvussa","Gérard","m","Célibataire",1050,{"$f":"VLOOKUP(Tableau8[[#This Row],[CP]],Bdd1_consignes!$C$22:$D$27,2,FALSE)","v":"Ixelles"},{"$f":"VLOOKUP(Tableau8[[#This Row],[CP]],Tableau10[],2,FALSE)","v":"Ixelles"},"1970-12-04",{"$f":"DATEDIF(Tableau8[[#This Row],[Date de naissance]],TODAY(),\"y\")","v":52},{"$f":"IF(Tableau8[[#This Row],[Age]]<25,0,IF(Tableau8[[#This Row],[Age]]<35,1,IF(Tableau8[[#This Row],[Age]]<45,2,IF(Tableau8[[#This Row],[Age]]<55,3,4))))","v":3},"Informatique","Informatique",{"$f":"_xlfn.XLOOKUP(Tableau8[[#This Row],[Services]],Tableau7[Services],Tableau7[Salaire minimum],\"\",0)","v":1900},{"$f":"IF(Tableau8[[#This Row],[Salaires Min]]=\"\",\"\",Tableau8[[#This Row],[Salaires Min]]+5%*Tableau8[[#This Row],[Tranches]]*Tableau8[[#This Row],[Salaires Min]])","v":2185}]
["Lalalalalalala","Starsky","m","Célibataire",1060,{"$f":"VLOOKUP(Tableau8[[#This Row],[CP]],Bdd1_consignes!$C$22:$D$27,2,FALSE)","v":"Saint-Gilles"},{"$f":"VLOOKUP(Tableau8[[#This Row],[CP]],Tableau10[],2,FALSE)","v":"Saint-Gilles"},"1955-07-08",{"$f":"DATEDIF(Tableau8[[#This Row],[Date de naissance]],TODAY(),\"y\")","v":68},{"$f":"IF(Tableau8[[#This Row],[Age]]<25,0,IF(Tableau8[[#This Row],[Age]]<35,1,IF(Tableau8[[#This Row],[Age]]<45,2,IF(Tableau8[[#This Row],[Age]]<55,3,4))))","v":4},"Personnel","Personnel",{"$f":"_xlfn.XLOOKUP(Tableau8[[#This Row],[Services]],Tableau7[Services],Tableau7[Salaire minimum],\"\",0)","v":1600},{"$f":"IF(Tableau8[[#This Row],[Salaires Min]]=\"\",\"\",Tableau8[[#This Row],[Salaires Min]]+5%*Tableau8[[#This Row],[Tranches]]*Tableau8[[#This Row],[Salaires Min]])","v":1920}]
["Lalalalalalala","Hutch","m","Divorcé(e)",1050,{"$f":"VLOOKUP(Tableau8[[#This Row],[CP]],Bdd1_consignes!$C$22:$D$27,2,FALSE)","v":"Ixelles"},{"$f":"VLOOKUP(Tableau8[[#This Row],[CP]],Tableau10[],2,FALSE)","v":"Ixelles"},"1952-10-07",{"$f":"DATEDIF(Tableau8[[#This Row],[Date de naissance]],TODAY(),\"y\")","v":71},{"$f":"IF(Tableau8[[#This Row],[Age]]<25,0,IF(Tableau8[[#This Row],[Age]]<35,1,IF(Tableau8[[#This Row],[Age]]<45,2,IF(Tableau8[[#This Row],[Age]]<55,3,4))))","v":4},"Direction","Direction",{"$f":"_xlfn.XLOOKUP(Tableau8[[#This Row],[Services]],Tableau7[Services],Tableau7[Salaire minimum],\"\",0)","v":2500},{"$f":"IF(Tableau8[[#This Row],[Salaires Min]]=\"\",\"\",Tableau8[[#This Row],[Salaires Min]]+5%*Tableau8[[#This Row],[Tranches]]*Tableau8[[#This Row],[Salaires Min]])","v":3000}]
["Cléssoulaporte","Djamila","f","Marié(e)",1050,{"$f":"VLOOKUP(Tableau8[[#This Row],[CP]],Bdd1_consignes!$C$22:$D$27,2,FALSE)","v":"Ixelles"},{"$f":"VLOOKUP(Tableau8[[#This Row],[CP]],Tableau10[],2,FALSE)","v":"Ixelles"},"1959-09-07",{"$f":"DATEDIF(Tableau8[[#This Row],[Date de naissance]],TODAY(),\"y\")","v":64},{"$f":"IF(Tableau8[[#This Row],[Age]]<25,0,IF(Tableau8[[#This Row],[Age]]<35,1,IF(Tableau8[[#This Row],[Age]]<45,2,IF(Tableau8[[#This Row],[Age]]<55,3,4))))","v":4},null,null,{"$f":"_xlfn.XLOOKUP(Tableau8[[#This Row],[Services]],Tableau7[Services],Tableau7[Salaire minimum],\"\",0)","v":""},{"$f":"IF(Tableau8[[#This Row],[Salaires Min]]=\"\",\"\",Tableau8[[#This Row],[Salaires Min]]+5%*Tableau8[[#This Row],[Tranches]]*Tableau8[[#This Row],[Salaires Min]])","v":""}]
["Noux","Marion","f","Divorcé(e)",1050,{"$f":"VLOOKUP(Tableau8[[#This Row],[CP]],Bdd1_consignes!$C$22:$D$27,2,FALSE)","v":"Ixelles"},{"$f":"VLOOKUP(Tableau8[[#This Row],[CP]],Tableau10[],2,FALSE)","v":"Ixelles"},"1978-12-30",{"$f":"DATEDIF(Tableau8[[#This Row],[Date de naissance]],TODAY(),\"y\")","v":44},{"$f":"IF(Tableau8[[#This Row],[Age]]<25,0,IF(Tableau8[[#This Row],[Age]]<35,1,IF(Tableau8[[#This Row],[Age]]<45,2,IF(Tableau8[[#This Row],[Age]]<55,3,4))))","v":2},null,null,{"$f":"_xlfn.XLOOKUP(Tableau8[[#This Row],[Services]],Tableau7[Services],Tableau7[Salaire minimum],\"\",0)","v":""},{"$f":"IF(Tableau8[[#This Row],[Salaires Min]]=\"\",\"\",Tableau8[[#This Row],[Salaires Min]]+5%*Tableau8[[#This Row],[Tranches]]*Tableau8[[#This Row],[Salaires Min]])","v":""}]
["Ouzi","Jacques","m","Célibataire",1000,{"$f":"VLOOKUP(Tableau8[[#This Row],[CP]],Bdd1_consignes!$C$22:$D$27,2,FALSE)","v":"Bruxelles"},{"$f":"VLOOKUP(Tableau8[[#This Row],[CP]],Tableau10[],2,FALSE)","v":"Bruxelles"},"1969-02-28",{"$f":"DATEDIF(Tableau8[[#This Row],[Date de naissance]],TODAY(),\"y\")","v":54},{"$f":"IF(Tableau8[[#This Row],[Age]]<25,0,IF(Tableau8[[#This Row],[Age]]<35,1,IF(Tableau8[[#This Row],[Age]]<45,2,IF(Tableau8[[#This Row],[Age]]<55,3,4))))","v":3},null,null,{"$f":"_xlfn.XLOOKUP(Tableau8[[#This Row],[Services]],Tableau7[Services],Tableau7[Salaire minimum],\"\",0)","v":""},{"$f":"IF(Tableau8[[#This Row],[Salaires Min]]=\"\",\"\",Tableau8[[#This Row],[Salaires Min]]+5%*Tableau8[[#This Row],[Tranches]]*Tableau8[[#This Row],[Salaires Min]])","v":""}]
["Stiké","Sophie","f","Divorcé(e)",1070,{"$f":"VLOOKUP(Tableau8[[#This Row],[CP]],Bdd1_consignes!$C$22:$D$27,2,FALSE)","v":"Anderlecht"},{"$f":"VLOOKUP(Tableau8[[#This Row],[CP]],Tableau10[],2,FALSE)","v":"Anderlecht"},"1959-04-04",{"$f":"DATEDIF(Tableau8[[#This Row],[Date de naissance]],TODAY(),\"y\")","v":64},{"$f":"IF(Tableau8[[#This Row],[Age]]<25,0,IF(Tableau8[[#This Row],[Age]]<35,1,IF(Tableau8[[#This Row],[Age]]<45,2,IF(Tableau8[[#This Row],[Age]]<55,3,4))))","v":4},null,null,{"$f":"_xlfn.XLOOKUP(Tableau8[[#This Row],[Services]],Tableau7[Services],Tableau7[Salaire minimum],\"\",0)","v":""},{"$f":"IF(Tableau8[[#This Row],[Salaires Min]]=\"\",\"\",Tableau8[[#This Row],[Salaires Min]]+5%*Tableau8[[#This Row],[Tranches]]*Tableau8[[#This Row],[Salaires Min]])","v":""}]
["Tare","Guy","m","Divorcé(e)",1070,{"$f":"VLOOKUP(Tableau8[[#This Row],[CP]],Bdd1_consignes!$C$22:$D$27,2,FALSE)","v":"Anderlecht"},{"$f":"VLOOKUP(Tableau8[[#This Row],[CP]],Tableau10[],2,FALSE)","v":"Anderlecht"},"1960-08-07",{"$f":"DATEDIF(Tableau8[[#This Row],[Date de naissance]],TODAY(),\"y\")","v":63},{"$f":"IF(Tableau8[[#This Row],[Age]]<25,0,IF(Tableau8[[#This Row],[Age]]<35,1,IF(Tableau8[[#This Row],[Age]]<45,2,IF(Tableau8[[#This Row],[Age]]<55,3,4))))","v":4},null,null,{"$f":"_xlfn.XLOOKUP(Tableau8[[#This Row],[Services]],Tableau7[Services],Tableau7[Salaire minimum],\"\",0)","v":""},{"$f":"IF(Tableau8[[#This Row],[Salaires Min]]=\"\",\"\",Tableau8[[#This Row],[Salaires Min]]+5%*Tableau8[[#This Row],[Tranches]]*Tableau8[[#This Row],[Salaires Min]])","v":""}]
["Vaisselle","Aude","f","Marié(e)",1070,{"$f":"VLOOKUP(Tableau8[[#This Row],[CP]],Bdd1_consignes!$C$22:$D$27,2,FALSE)","v":"Anderlecht"},{"$f":"VLOOKUP(Tableau8[[#This Row],[CP]],Tableau10[],2,FALSE)","v":"Anderlecht"},"1966-06-06",{"$f":"DATEDIF(Tableau8[[#This Row],[Date de naissance]],TODAY(),\"y\")","v":57},{"$f":"IF(Tableau8[[#This Row],[Age]]<25,0,IF(Tableau8[[#This Row],[Age]]<35,1,IF(Tableau8[[#This Row],[Age]]<45,2,IF(Tableau8[[#This Row],[Age]]<55,3,4))))","v":4},null,null,{"$f":"_xlfn.XLOOKUP(Tableau8[[#This Row],[Services]],Tableau7[Services],Tableau7[Salaire minimum],\"\",0)","v":""},{"$f":"IF(Tableau8[[#This Row],[Salaires Min]]=\"\",\"\",Tableau8[[#This Row],[Salaires Min]]+5%*Tableau8[[#This Row],[Tranches]]*Tableau8[[#This Row],[Salaires Min]])","v":""}]
["Zetofrais","Mélanie","f","Célibataire",1070,{"$f":"VLOOKUP(Tableau8[[#This Row],[CP]],Bdd1_consignes!$C$22:$D$27,2,FALSE)","v":"Anderlecht"},{"$f":"VLOOKUP(Tableau8[[#This Row],[CP]],Tableau10[],2,FALSE)","v":"Anderlecht"},"1978-11-25",{"$f":"DATEDIF(Tableau8[[#This Row],[Date de naissance]],TODAY(),\"y\")","v":44},{"$f":"IF(Tableau8[[#This Row],[Age]]<25,0,IF(Tableau8[[#This Row],[Age]]<35,1,IF(Tableau8[[#This Row],[Age]]<45,2,IF(Tableau8[[#This Row],[Age]]<55,3,4))))","v":2},null,null,{"$f":"_xlfn.XLOOKUP(Tableau8[[#This Row],[Services]],Tableau7[Services],Tableau7[Salaire minimum],\"\",0)","v":""},{"$f":"IF(Tableau8[[#This Row],[Salaires Min]]=\"\",\"\",Tableau8[[#This Row],[Salaires Min]]+5%*Tableau8[[#This Row],[Tranches]]*Tableau8[[#This Row],[Salaires Min]])","v":""}]
["Touille","Sasha","m","Célibataire",1070,{"$f":"VLOOKUP(Tableau8[[#This Row],[CP]],Bdd1_consignes!$C$22:$D$27,2,FALSE)","v":"Anderlecht"},{"$f":"VLOOKUP(Tableau8[[#This Row],[CP]],Tableau10[],2,FALSE)","v":"Anderlecht"},"1982-10-30",{"$f":"DATEDIF(Tableau8[[#This Row],[Date de naissance]],TODAY(),\"y\")","v":40},{"$f":"IF(Tableau8[[#This Row],[Age]]<25,0,IF(Tableau8[[#This Row],[Age]]<35,1,IF(Tableau8[[#This Row],[Age]]<45,2,IF(Tableau8[[#This Row],[Age]]<55,3,4))))","v":2},null,null,{"$f":"_xlfn.XLOOKUP(Tableau8[[#This Row],[Services]],Tableau7[Services],Tableau7[Salaire minimum],\"\",0)","v":""},{"$f":"IF(Tableau8[[#This Row],[Salaires Min]]=\"\",\"\",Tableau8[[#This Row],[Salaires Min]]+5%*Tableau8[[#This Row],[Tranches]]*Tableau8[[#This Row],[Salaires Min]])","v":""}]
["Proviste","Alain","m","Marié(e)",1030,{"$f":"VLOOKUP(Tableau8[[#This Row],[CP]],Bdd1_consignes!$C$22:$D$27,2,FALSE)","v":"Schaerbeek"},{"$f":"VLOOKUP(Tableau8[[#This Row],[CP]],Tableau10[],2,FALSE)","v":"Schaerbeek"},"1959-09-09",{"$f":"DATEDIF(Tableau8[[#This Row],[Date de naissance]],TODAY(),\"y\")","v":64},{"$f":"IF(Tableau8[[#This Row],[Age]]<25,0,IF(Tableau8[[#This Row],[Age]]<35,1,IF(Tableau8[[#This Row],[Age]]<45,2,IF(Tableau8[[#This Row],[Age]]<55,3,4))))","v":4},null,null,{"$f":"_xlfn.XLOOKUP(Tableau8[[#This Row],[Services]],Tableau7[Services],Tableau7[Salaire minimum],\"\",0)","v":""},{"$f":"IF(Tableau8[[#This Row],[Salaires Min]]=\"\",\"\",Tableau8[[#This Row],[Salaires Min]]+5%*Tableau8[[#This Row],[Tranches]]*Tableau8[[#This Row],[Salaires Min]])","v":""}]
["Peulaporte","Firmin","m","Divorcé(e)",1040,{"$f":"VLOOKUP(Tableau8[[#This Row],[CP]],Bdd1_consignes!$C$22:$D$27,2,FALSE)","v":"Etterbeek"},{"$f":"VLOOKUP(Tableau8[[#This Row],[CP]],Tableau10[],2,FALSE)","v":"Etterbeek"},"1965-07-01",{"$f":"DATEDIF(Tableau8[[#This Row],[Date de naissance]],TODAY(),\"y\")","v":58},{"$f":"IF(Tableau8[[#This Row],[Age]]<25,0,IF(Tableau8[[#This Row],[Age]]<35,1,IF(Tableau8[[#This Row],[Age]]<45,2,IF(Tableau8[[#This Row],[Age]]<55,3,4))))","v":4},null,null,{"$f":"_xlfn.XLOOKUP(Tableau8[[#This Row],[Services]],Tableau7[Services],Tableau7[Salaire minimum],\"\",0)","v":""},{"$f":"IF(Tableau8[[#This Row],[Salaires Min]]=\"\",\"\",Tableau8[[#This Row],[Salaires Min]]+5%*Tableau8[[#This Row],[Tranches]]*Tableau8[[#This Row],[Salaires Min]])","v":""}]
["Unetitlaine","Jérémy","m","Marié(e)",1030,{"$f":"VLOOKUP(Tableau8[[#This Row],[CP]],Bdd1_consignes!$C$22:$D$27,2,FALSE)","v":"Schaerbeek"},{"$f":"VLOOKUP(Tableau8[[#This Row],[CP]],Tableau10[],2,FALSE)","v":"Schaerbeek"},"1983-06-09",{"$f":"DATEDIF(Tableau8[[#This Row],[Date de naissance]],TODAY(),\"y\")","v":40},{"$f":"IF(Tableau8[[#This Row],[Age]]<25,0,IF(Tableau8[[#This Row],[Age]]<35,1,IF(Tableau8[[#This Row],[Age]]<45,2,IF(Tableau8[[#This Row],[Age]]<55,3,4))))","v":2},null,null,{"$f":"_xlfn.XLOOKUP(Tableau8[[#This Row],[Services]],Tableau7[Services],Tableau7[Salaire minimum],\"\",0)","v":""},{"$f":"IF(Tableau8[[#This Row],[Salaires Min]]=\"\",\"\",Tableau8[[#This Row],[Salaires Min]]+5%*Tableau8[[#This Row],[Tranches]]*Tableau8[[#This Row],[Salaires Min]])","v":""}]

{"sheet":"Tranches","index":6,"n_rows":29,"n_cols":15,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,"Retour sommaire"]
[]
[null,"Lors de l'utilisation des 'SI' imbriqués, nous ne disposons que de 8 'SI'. Si les tranches été différentes (cf. ci-dessous), le problème n'aurait pas pu être résolu avec des 'SI' "]
[null,"Ce genre de problème peut être solutionné par l'utilisation d'une 'RechercheV' (RechercheX) par valeur proche."]
[]
[null,"Méthode \"classique\"",null,null,null,null,null,null,null,null,"Avec des tableaux de données"]
[]
[null,"Ages",null,"Tranches",null,"Age","Tranches\n(RechercheV)\n(VLookUp)","Tranches\n(RechercheX)\n(XLookUp)",null,null,null,"Tranches",null,"Age","Tranches\n(RechercheX)\n(XLookUp)"]
[null,"<25",0,0,null,42,null,null,null,null,0,0,null,42]
[null,">=25 et <30",25,1,null,28,null,null,null,null,25,1,null,28]
[null,">=30 et <35",30,2,null,66,null,null,null,null,30,2,null,66]
[null,">=35 et <40",35,3,null,42,null,null,null,null,35,3,null,42]
[null,">=40 et <45",40,4,null,44,null,null,null,null,40,4,null,44]
[null,">=45 et <50",45,5,null,32,null,null,null,null,45,5,null,32]
[null,">=50 et <55",50,6,null,25,null,null,null,null,50,6,null,25]
[null,">=55 et <60",55,7,null,37,null,null,null,null,55,7,null,37]
[null,">=60 et <65",60,8,null,52,null,null,null,null,60,8,null,52]
[null,">=65 et <70",65,9,null,55,null,null,null,null,65,9,null,55]
[null,">=70",70,10,null,48,null,null,null,null,70,10,null,48]
[null,null,null,null,null,29,null,null,null,null,null,null,null,29]
[null,null,null,null,null,39,null,null,null,null,null,null,null,39]
[null,null,null,null,null,49,null,null,null,null,null,null,null,49]
[null,null,null,null,null,47,null,null,null,null,null,null,null,47]
[null,null,null,null,null,41,null,null,null,null,null,null,null,41]
[null,null,null,null,null,29,null,null,null,null,null,null,null,29]
[null,null,null,null,null,25,null,null,null,null,null,null,null,25]
[null,null,null,null,null,48,null,null,null,null,null,null,null,48]
[null,null,null,null,null,42,null,null,null,null,null,null,null,42]
[null,null,null,null,null,24,null,null,null,null,null,null,null,24]

{"sheet":"Tranches_corrigé","index":7,"n_rows":28,"n_cols":15,"rows_kept":28,"cut":false,"hidden":true,"merged":[]}
[]
[]
[null,"Lors de l'utilisation des 'SI' imbriqués, nous ne disposons que de 8 'SI'. Si les tranches été différentes (cf. ci-dessous), le problème n'aurait pas pu être résolu avec des 'SI' "]
[null,"Ce genre de problème peut être solutionné par l'utilisation d'une 'RechercheV' par valeur proche."]
[null,null,null,null,null,null,null,null,null,null,"Avec les tableaux de données"]
[]
[null,"Ages",null,"Tranches",null,"Age","Tranches\n(RechercheV)\n(VLookUp)","Tranches\n(RechercheV)\n(XLookUp)",null,null,"Age","Tranches",null,"Age","Tranches\n(RechercheV)\n(XLookUp)"]
[null,"<25",0,0,null,42,{"$f":"VLOOKUP(F8,$C$8:$D$18,2,TRUE)","v":4},{"$f":"_xlfn.XLOOKUP(F8,$C$8:$C$18,$D$8:$D$18,,-1)","v":4},null,null,0,0,null,42,{"$f":"_xlfn.XLOOKUP(Tableau12[[#This Row],[Age]],Tableau13[Age],Tableau13[Tranches],,-1)","v":4}]
[null,">=25 et <30",25,1,null,28,1,1,null,null,25,1,null,28,{"$f":"_xlfn.XLOOKUP(Tableau12[[#This Row],[Age]],Tableau13[Age],Tableau13[Tranches],,-1)","v":1}]
[null,">=30 et <35",30,2,null,66,9,9,null,null,30,2,null,66,{"$f":"_xlfn.XLOOKUP(Tableau12[[#This Row],[Age]],Tableau13[Age],Tableau13[Tranches],,-1)","v":9}]
[null,">=35 et <40",35,3,null,42,4,4,null,null,35,3,null,42,{"$f":"_xlfn.XLOOKUP(Tableau12[[#This Row],[Age]],Tableau13[Age],Tableau13[Tranches],,-1)","v":4}]
[null,">=40 et <45",40,4,null,44,4,4,null,null,40,4,null,44,{"$f":"_xlfn.XLOOKUP(Tableau12[[#This Row],[Age]],Tableau13[Age],Tableau13[Tranches],,-1)","v":4}]
[null,">=45 et <50",45,5,null,32,2,2,null,null,45,5,null,32,{"$f":"_xlfn.XLOOKUP(Tableau12[[#This Row],[Age]],Tableau13[Age],Tableau13[Tranches],,-1)","v":2}]
[null,">=50 et <55",50,6,null,25,1,1,null,null,50,6,null,25,{"$f":"_xlfn.XLOOKUP(Tableau12[[#This Row],[Age]],Tableau13[Age],Tableau13[Tranches],,-1)","v":1}]
[null,">=55 et <60",55,7,null,37,3,3,null,null,55,7,null,37,{"$f":"_xlfn.XLOOKUP(Tableau12[[#This Row],[Age]],Tableau13[Age],Tableau13[Tranches],,-1)","v":3}]
[null,">=60 et <65",60,8,null,52,6,6,null,null,60,8,null,52,{"$f":"_xlfn.XLOOKUP(Tableau12[[#This Row],[Age]],Tableau13[Age],Tableau13[Tranches],,-1)","v":6}]
[null,">=65 et <70",65,9,null,55,7,7,null,null,65,9,null,55,{"$f":"_xlfn.XLOOKUP(Tableau12[[#This Row],[Age]],Tableau13[Age],Tableau13[Tranches],,-1)","v":7}]
[null,">=70",70,10,null,48,5,5,null,null,70,10,null,48,{"$f":"_xlfn.XLOOKUP(Tableau12[[#This Row],[Age]],Tableau13[Age],Tableau13[Tranches],,-1)","v":5}]
[null,null,null,null,null,29,1,1,null,null,null,null,null,29,{"$f":"_xlfn.XLOOKUP(Tableau12[[#This Row],[Age]],Tableau13[Age],Tableau13[Tranches],,-1)","v":1}]
[null,null,null,null,null,39,3,3,null,null,null,null,null,39,{"$f":"_xlfn.XLOOKUP(Tableau12[[#This Row],[Age]],Tableau13[Age],Tableau13[Tranches],,-1)","v":3}]
[null,null,null,null,null,49,5,5,null,null,null,null,null,49,{"$f":"_xlfn.XLOOKUP(Tableau12[[#This Row],[Age]],Tableau13[Age],Tableau13[Tranches],,-1)","v":5}]
[null,null,null,null,null,47,5,5,null,null,null,null,null,47,{"$f":"_xlfn.XLOOKUP(Tableau12[[#This Row],[Age]],Tableau13[Age],Tableau13[Tranches],,-1)","v":5}]
[null,null,null,null,null,41,4,4,null,null,null,null,null,41,{"$f":"_xlfn.XLOOKUP(Tableau12[[#This Row],[Age]],Tableau13[Age],Tableau13[Tranches],,-1)","v":4}]
[null,null,null,null,null,29,1,1,null,null,null,null,null,29,{"$f":"_xlfn.XLOOKUP(Tableau12[[#This Row],[Age]],Tableau13[Age],Tableau13[Tranches],,-1)","v":1}]
[null,null,null,null,null,25,1,1,null,null,null,null,null,25,{"$f":"_xlfn.XLOOKUP(Tableau12[[#This Row],[Age]],Tableau13[Age],Tableau13[Tranches],,-1)","v":1}]
[null,null,null,null,null,48,5,5,null,null,null,null,null,48,{"$f":"_xlfn.XLOOKUP(Tableau12[[#This Row],[Age]],Tableau13[Age],Tableau13[Tranches],,-1)","v":5}]
[null,null,null,null,null,42,4,4,null,null,null,null,null,42,{"$f":"_xlfn.XLOOKUP(Tableau12[[#This Row],[Age]],Tableau13[Age],Tableau13[Tranches],,-1)","v":4}]
[null,null,null,null,null,24,0,0,null,null,null,null,null,24,{"$f":"_xlfn.XLOOKUP(Tableau12[[#This Row],[Age]],Tableau13[Age],Tableau13[Tranches],,-1)","v":0}]

{"sheet":"Tri1","index":8,"n_rows":27,"n_cols":13,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
["Tri des données",null,null,null,null,null,null,null,null,null,null,null,"Retour sommaire"]
[]
["Trier les données par ordre alphabétique sur le nom"]
["Réaliser ce tri utilisant un tableau de données"]
[]
["Nom","Prénom","Sexe","Etat civil","Date de naissance","Age","Tranches","Services","Salaires Minimum","Salaires"]
["Bistrot","Alonso","m","Marié(e)","1966-01-17",{"$f":"DATEDIF(E7,TODAY(),\"y\")","v":57},{"$f":"IF(F7<25,0,IF(F7<35,1,IF(F7<45,2,IF(F7<55,3,4))))","v":4},"Informatique",{"$f":"VLOOKUP(H7,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},{"$f":"I7+5%*G7*I7","v":2280}]
["Bijoba","Jo","m","Marié(e)","1980-03-15",{"$f":"DATEDIF(E8,TODAY(),\"y\")","v":43},{"$f":"IF(F8<25,0,IF(F8<35,1,IF(F8<45,2,IF(F8<55,3,4))))","v":2},"Direction",{"$f":"VLOOKUP(H8,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":2500},{"$f":"I8+5%*G8*I8","v":2750}]
["Covert","Harry","m","Divorcé(e)","1942-02-10",81,4,"Personnel",{"$f":"VLOOKUP(H9,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1920]
["Culaire","Laury","m","Marié(e)","1965-05-05",58,4,"Personnel",{"$f":"VLOOKUP(H10,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1920]
["Deuf","John","m","Célibataire","1963-09-08",60,4,"Informatique",{"$f":"VLOOKUP(H11,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},2280]
["Foupasune","Jean","m","Célibataire","1975-08-07",48,3,"Personnel",{"$f":"VLOOKUP(H12,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1840]
["Lairbon","Oussama","m","Marié(e)","1983-02-08",40,2,"Personnel",{"$f":"VLOOKUP(H13,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1760]
["Menvussa","Gérard","m","Célibataire","1970-12-04",52,3,"Informatique",{"$f":"VLOOKUP(H14,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},2185]
["Lalalalalalala","Starsky","m","Célibataire","1955-07-08",68,4,"Personnel",{"$f":"VLOOKUP(H15,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1920]
["Lalalalalalala","Hutch","m","Divorcé(e)","1952-10-07",71,4,"Direction",{"$f":"VLOOKUP(H16,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":2500},3000]
["Cléssoulaporte","Djamila","f","Marié(e)","1959-09-07",64,4,"Personnel",{"$f":"VLOOKUP(H17,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1920]
["Noux","Marion","f","Divorcé(e)","1978-12-30",44,2,"Secrétariat",{"$f":"VLOOKUP(H18,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1700},1870]
["Ouzi","Jacques","m","Célibataire","1969-02-28",54,3,"Personnel",{"$f":"VLOOKUP(H19,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1840]
["Stiké","Sophie","f","Divorcé(e)","1959-04-04",64,4,"Secrétariat",{"$f":"VLOOKUP(H20,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1700},2040]
["Tare","Guy","m","Divorcé(e)","1960-08-07",63,4,"Informatique",{"$f":"VLOOKUP(H21,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},2280]
["Vaisselle","Aude","f","Marié(e)","1966-06-06",57,4,"Secrétariat",{"$f":"VLOOKUP(H22,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1700},2040]
["Zetofrais","Mélanie","f","Célibataire","1978-11-25",44,2,"Direction",{"$f":"VLOOKUP(H23,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":2500},2750]
["Touille","Sasha","m","Célibataire","1982-10-30",40,2,"Personnel",{"$f":"VLOOKUP(H24,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1760]
["Proviste","Alain","m","Marié(e)","1959-09-09",64,4,"Personnel",{"$f":"VLOOKUP(H25,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1920]
["Peulaporte","Firmin","m","Divorcé(e)","1965-07-01",58,4,"Informatique",{"$f":"VLOOKUP(H26,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},2280]
["Unetitlaine","Jérémy","m","Marié(e)","1983-06-09",40,2,"Informatique",{"$f":"VLOOKUP(H27,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},2090]

{"sheet":"Tri1_corrigé","index":9,"n_rows":27,"n_cols":13,"rows_kept":27,"cut":false,"hidden":true,"merged":[]}
["Tri des données",null,null,null,null,null,null,null,null,null,null,null,"Retour sommaire"]
[]
["Trier les données par ordre alphabétique sur le nom"]
["Réaliser ce tri utilisant un tableau de données"]
[]
["Nom","Prénom","Sexe","Etat civil","Date de naissance","Age","Tranches","Services","Salaires Minimum","Salaires"]
["Bijoba","Jo","m","Marié(e)","1980-03-15",{"$f":"DATEDIF(E7,TODAY(),\"y\")","v":43},{"$f":"IF(F7<25,0,IF(F7<35,1,IF(F7<45,2,IF(F7<55,3,4))))","v":2},"Direction",{"$f":"VLOOKUP(H7,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":2500},{"$f":"I7+5%*G7*I7","v":2750}]
["Bistrot","Alonso","m","Marié(e)","1966-01-17",57,4,"Informatique",{"$f":"VLOOKUP(H8,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},2280]
["Cléssoulaporte","Djamila","f","Marié(e)","1959-09-07",64,4,"Personnel",{"$f":"VLOOKUP(H9,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1920]
["Covert","Harry","m","Divorcé(e)","1942-02-10",81,4,"Personnel",{"$f":"VLOOKUP(H10,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1920]
["Culaire","Laury","m","Marié(e)","1965-05-05",58,4,"Personnel",{"$f":"VLOOKUP(H11,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1920]
["Deuf","John","m","Célibataire","1963-09-08",60,4,"Informatique",{"$f":"VLOOKUP(H12,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},2280]
["Foupasune","Jean","m","Célibataire","1975-08-07",48,3,"Personnel",{"$f":"VLOOKUP(H13,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1840]
["Lairbon","Oussama","m","Marié(e)","1983-02-08",40,2,"Personnel",{"$f":"VLOOKUP(H14,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1760]
["Lalalalalalala","Starsky","m","Célibataire","1955-07-08",68,4,"Personnel",{"$f":"VLOOKUP(H15,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1920]
["Lalalalalalala","Hutch","m","Divorcé(e)","1952-10-07",71,4,"Direction",{"$f":"VLOOKUP(H16,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":2500},3000]
["Menvussa","Gérard","m","Célibataire","1970-12-04",52,3,"Informatique",{"$f":"VLOOKUP(H17,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},2185]
["Noux","Marion","f","Divorcé(e)","1978-12-30",44,2,"Secrétariat",{"$f":"VLOOKUP(H18,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1700},1870]
["Ouzi","Jacques","m","Célibataire","1969-02-28",54,3,"Personnel",{"$f":"VLOOKUP(H19,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1840]
["Peulaporte","Firmin","m","Divorcé(e)","1965-07-01",58,4,"Informatique",{"$f":"VLOOKUP(H20,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},2280]
["Proviste","Alain","m","Marié(e)","1959-09-09",64,4,"Personnel",{"$f":"VLOOKUP(H21,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1920]
["Stiké","Sophie","f","Divorcé(e)","1959-04-04",64,4,"Secrétariat",{"$f":"VLOOKUP(H22,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1700},2040]
["Tare","Guy","m","Divorcé(e)","1960-08-07",63,4,"Informatique",{"$f":"VLOOKUP(H23,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},2280]
["Touille","Sasha","m","Célibataire","1982-10-30",40,2,"Personnel",{"$f":"VLOOKUP(H24,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1760]
["Unetitlaine","Jérémy","m","Marié(e)","1983-06-09",40,2,"Informatique",{"$f":"VLOOKUP(H25,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},2090]
["Vaisselle","Aude","f","Marié(e)","1966-06-06",57,4,"Secrétariat",{"$f":"VLOOKUP(H26,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1700},2040]
["Zetofrais","Mélanie","f","Célibataire","1978-11-25",44,2,"Direction",{"$f":"VLOOKUP(H27,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":2500},2750]

{"sheet":"Tri2","index":10,"n_rows":27,"n_cols":13,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
["Tri des données",null,null,null,null,null,null,null,null,null,null,null,"Retour sommaire"]
[]
["Organisez les données en tableau de données et triez-les par ordre alphabétique sur le service puis sur le nom"]
["Lorsque c'est fait, réaliser la même opération en utilisant un tableau de données"]
[]
["Nom","Prénom","Sexe","Etat civil","Date de naissance","Age","Tranches","Services","Salaires Minimum","Salaires"]
["Bijoba","Jo","m","Marié(e)","1980-03-15",{"$f":"DATEDIF(E7,TODAY(),\"y\")","v":43},{"$f":"IF(F7<25,0,IF(F7<35,1,IF(F7<45,2,IF(F7<55,3,4))))","v":2},"Direction",{"$f":"VLOOKUP(H7,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":2500},{"$f":"I7+5%*G7*I7","v":2750},null,"=> 'Ruban Données .. Trier'"]
["Lalalalalalala","Hutch","m","Divorcé(e)","1952-10-07",71,4,"Direction",{"$f":"VLOOKUP(H8,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":2500},3000]
["Zetofrais","Mélanie","f","Célibataire","1978-11-25",44,2,"Direction",{"$f":"VLOOKUP(H9,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":2500},2750]
["Bistrot","Alonso","m","Marié(e)","1966-01-17",57,4,"Informatique",{"$f":"VLOOKUP(H10,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},2280]
["Deuf","John","m","Célibataire","1963-09-08",60,4,"Informatique",{"$f":"VLOOKUP(H11,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},2280]
["Menvussa","Gérard","m","Célibataire","1970-12-04",52,3,"Informatique",{"$f":"VLOOKUP(H12,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},2185]
["Peulaporte","Firmin","m","Divorcé(e)","1965-07-01",58,4,"Informatique",{"$f":"VLOOKUP(H13,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},2280]
["Tare","Guy","m","Divorcé(e)","1960-08-07",63,4,"Informatique",{"$f":"VLOOKUP(H14,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},2280]
["Unetitlaine","Jérémy","m","Marié(e)","1983-06-09",40,2,"Informatique",{"$f":"VLOOKUP(H15,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},2090]
["Cléssoulaporte","Djamila","f","Marié(e)","1959-09-07",64,4,"Personnel",{"$f":"VLOOKUP(H16,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1920]
["Covert","Harry","m","Divorcé(e)","1942-02-10",81,4,"Personnel",{"$f":"VLOOKUP(H17,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1920]
["Culaire","Laury","m","Marié(e)","1965-05-05",58,4,"Personnel",{"$f":"VLOOKUP(H18,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1920]
["Foupasune","Jean","m","Célibataire","1975-08-07",48,3,"Personnel",{"$f":"VLOOKUP(H19,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1840]
["Lairbon","Oussama","m","Marié(e)","1983-02-08",40,2,"Personnel",{"$f":"VLOOKUP(H20,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1760]
["Lalalalalalala","Starsky","m","Célibataire","1955-07-08",68,4,"Personnel",{"$f":"VLOOKUP(H21,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1920]
["Ouzi","Jacques","m","Célibataire","1969-02-28",54,3,"Personnel",{"$f":"VLOOKUP(H22,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1840]
["Proviste","Alain","m","Marié(e)","1959-09-09",64,4,"Personnel",{"$f":"VLOOKUP(H23,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1920]
["Touille","Sasha","m","Célibataire","1982-10-30",40,2,"Personnel",{"$f":"VLOOKUP(H24,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1760]
["Noux","Marion","f","Divorcé(e)","1978-12-30",44,2,"Secrétariat",{"$f":"VLOOKUP(H25,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1700},1870]
["Stiké","Sophie","f","Divorcé(e)","1959-04-04",64,4,"Secrétariat",{"$f":"VLOOKUP(H26,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1700},2040]
["Vaisselle","Aude","f","Marié(e)","1966-06-06",57,4,"Secrétariat",{"$f":"VLOOKUP(H27,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1700},2040]

{"sheet":"Tri2_corrigé","index":11,"n_rows":27,"n_cols":13,"rows_kept":27,"cut":false,"hidden":true,"merged":[]}
["Tri des données",null,null,null,null,null,null,null,null,null,null,null,"Retour sommaire"]
[]
["Trier les données par ordre alphabétique sur le service puis sur le nom"]
["Lorsque c'est fait, réaliser la même opération en utilisant un tableau de données"]
[]
["Nom","Prénom","Sexe","Etat civil","Date de naissance","Age","Tranches","Services","Salaires Minimum","Salaires"]
["Bijoba","Jo","m","Marié(e)","1980-03-15",{"$f":"DATEDIF(E7,TODAY(),\"y\")","v":43},{"$f":"IF(F7<25,0,IF(F7<35,1,IF(F7<45,2,IF(F7<55,3,4))))","v":2},"Direction",{"$f":"VLOOKUP(H7,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":2500},{"$f":"I7+5%*G7*I7","v":2750},null,"=> 'Données .. Trier'"]
["Lalalalalalala","Hutch","m","Divorcé(e)","1952-10-07",71,4,"Direction",{"$f":"VLOOKUP(H8,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":2500},3000]
["Zetofrais","Mélanie","f","Célibataire","1978-11-25",44,2,"Direction",{"$f":"VLOOKUP(H9,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":2500},2750]
["Bistrot","Alonso","m","Marié(e)","1966-01-17",57,4,"Informatique",{"$f":"VLOOKUP(H10,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},2280]
["Deuf","John","m","Célibataire","1963-09-08",60,4,"Informatique",{"$f":"VLOOKUP(H11,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},2280]
["Menvussa","Gérard","m","Célibataire","1970-12-04",52,3,"Informatique",{"$f":"VLOOKUP(H12,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},2185]
["Peulaporte","Firmin","m","Divorcé(e)","1965-07-01",58,4,"Informatique",{"$f":"VLOOKUP(H13,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},2280]
["Tare","Guy","m","Divorcé(e)","1960-08-07",63,4,"Informatique",{"$f":"VLOOKUP(H14,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},2280]
["Unetitlaine","Jérémy","m","Marié(e)","1983-06-09",40,2,"Informatique",{"$f":"VLOOKUP(H15,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},2090]
["Cléssoulaporte","Djamila","f","Marié(e)","1959-09-07",64,4,"Personnel",{"$f":"VLOOKUP(H16,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1920]
["Covert","Harry","m","Divorcé(e)","1942-02-10",81,4,"Personnel",{"$f":"VLOOKUP(H17,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1920]
["Culaire","Laury","m","Marié(e)","1965-05-05",58,4,"Personnel",{"$f":"VLOOKUP(H18,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1920]
["Foupasune","Jean","m","Célibataire","1975-08-07",48,3,"Personnel",{"$f":"VLOOKUP(H19,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1840]
["Lairbon","Oussama","m","Marié(e)","1983-02-08",40,2,"Personnel",{"$f":"VLOOKUP(H20,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1760]
["Lalalalalalala","Starsky","m","Célibataire","1955-07-08",68,4,"Personnel",{"$f":"VLOOKUP(H21,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1920]
["Ouzi","Jacques","m","Célibataire","1969-02-28",54,3,"Personnel",{"$f":"VLOOKUP(H22,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1840]
["Proviste","Alain","m","Marié(e)","1959-09-09",64,4,"Personnel",{"$f":"VLOOKUP(H23,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1920]
["Touille","Sasha","m","Célibataire","1982-10-30",40,2,"Personnel",{"$f":"VLOOKUP(H24,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1760]
["Noux","Marion","f","Divorcé(e)","1978-12-30",44,2,"Secrétariat",{"$f":"VLOOKUP(H25,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1700},1870]
["Stiké","Sophie","f","Divorcé(e)","1959-04-04",64,4,"Secrétariat",{"$f":"VLOOKUP(H26,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1700},2040]
["Vaisselle","Aude","f","Marié(e)","1966-06-06",57,4,"Secrétariat",{"$f":"VLOOKUP(H27,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1700},2040]

{"sheet":"Filtre1","index":12,"n_rows":33,"n_cols":13,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
["Filtres automatiques",null,null,null,null,null,null,null,null,null,null,null,"Retour sommaire"]
[]
["Affichez les employés dont le nom commence par un 'p'"]
[]
[]
["Nom","Prénom","Sexe","Etat civil","Date de naissance","Age","Tranches","Services","Salaires Minimum","Salaires"]
["Bistrot","Alonso","m","Marié(e)","1966-01-17",{"$f":"DATEDIF(E7,TODAY(),\"y\")","v":57},{"$f":"IF(F7<25,0,IF(F7<35,1,IF(F7<45,2,IF(F7<55,3,4))))","v":4},"Informatique",{"$f":"VLOOKUP(H7,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},{"$f":"I7+5%*G7*I7","v":2280}]
["Bijoba","Jo","m","Marié(e)","1980-03-15",{"$f":"DATEDIF(E8,TODAY(),\"y\")","v":43},{"$f":"IF(F8<25,0,IF(F8<35,1,IF(F8<45,2,IF(F8<55,3,4))))","v":2},"Direction",{"$f":"VLOOKUP(H8,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":2500},{"$f":"I8+5%*G8*I8","v":2750}]
["Covert","Harry","m","Divorcé(e)","1942-02-10",81,4,"Personnel",{"$f":"VLOOKUP(H9,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1920]
["Culaire","Laury","m","Marié(e)","1965-05-05",58,4,"Personnel",{"$f":"VLOOKUP(H10,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1920]
["Deuf","John","m","Célibataire","1963-09-08",60,4,"Informatique",{"$f":"VLOOKUP(H11,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},2280]
["Foupasune","Jean","m","Célibataire","1975-08-07",48,3,"Personnel",{"$f":"VLOOKUP(H12,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1840]
["Lairbon","Oussama","m","Marié(e)","1983-02-08",40,2,"Personnel",{"$f":"VLOOKUP(H13,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1760]
["Menvussa","Gérard","m","Célibataire","1970-12-04",52,3,"Informatique",{"$f":"VLOOKUP(H14,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},2185]
["Lalalalalalala","Starsky","m","Célibataire","1955-07-08",68,4,"Personnel",{"$f":"VLOOKUP(H15,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1920]
["Lalalalalalala","Hutch","m","Divorcé(e)","1952-10-07",71,4,"Direction",{"$f":"VLOOKUP(H16,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":2500},3000]
["Cléssoulaporte","Djamila","f","Marié(e)","1959-09-07",64,4,"Personnel",{"$f":"VLOOKUP(H17,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1920]
["Noux","Marion","f","Divorcé(e)","1978-12-30",44,2,"Secrétariat",{"$f":"VLOOKUP(H18,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1700},1870]
["Ouzi","Jacques","m","Célibataire","1969-02-28",54,3,"Personnel",{"$f":"VLOOKUP(H19,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1840]
["Stiké","Sophie","f","Divorcé(e)","1959-04-04",64,4,"Secrétariat",{"$f":"VLOOKUP(H20,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1700},2040]
["Tare","Guy","m","Divorcé(e)","1960-08-07",63,4,"Informatique",{"$f":"VLOOKUP(H21,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},2280]
["Vaisselle","Aude","f","Marié(e)","1966-06-06",57,4,"Secrétariat",{"$f":"VLOOKUP(H22,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1700},2040]
["Zetofrais","Mélanie","f","Célibataire","1978-11-25",44,2,"Direction",{"$f":"VLOOKUP(H23,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":2500},2750]
["Touille","Sasha","m","Célibataire","1982-10-30",40,2,"Personnel",{"$f":"VLOOKUP(H24,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1760]
["Proviste","Alain","m","Marié(e)","1959-09-09",64,4,"Personnel",{"$f":"VLOOKUP(H25,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1920]
["Peulaporte","Firmin","m","Divorcé(e)","1965-07-01",58,4,"Informatique",{"$f":"VLOOKUP(H26,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},2280]
["Unetitlaine","Jérémy","m","Marié(e)","1983-06-09",40,2,"Informatique",{"$f":"VLOOKUP(H27,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},2090]
[]
[]
[]
[]
["NB : Lorsque c'est fait ajouter 2 personnes à la la liste de données, Yvon Parici et Sara Lenti, tous les 2 célibataires et nés le 2/8/75 et le 6/8/88"]
["=> Les validations de données de la colonne 'Etat civil' ne \"suivent\" pas, les formules de calculs non plus"]

{"sheet":"Filtre1_corrigé","index":13,"n_rows":33,"n_cols":10,"rows_kept":33,"cut":false,"hidden":true,"merged":[]}
["Filtres automatiques"]
[]
["Affichez les employés dont le nom commence par un 'p'"]
[]
[]
["Nom","Prénom","Sexe","Etat civil","Date de naissance","Age","Tranches","Services","Salaires Minimum","Salaires"]
["Bistrot","Alonso","m","Marié(e)",24124,{"$f":"DATEDIF(E7,TODAY(),\"y\")","v":57},{"$f":"IF(F7<25,0,IF(F7<35,1,IF(F7<45,2,IF(F7<55,3,4))))","v":4},"Informatique",{"$f":"VLOOKUP(H7,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},{"$f":"I7+5%*G7*I7","v":2280}]
["Bijoba","Jo","m","Marié(e)",29295,43,2,"Direction",{"$f":"VLOOKUP(H8,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":2500},2750]
["Covert","Harry","m","Divorcé(e)",15382,81,4,"Personnel",{"$f":"VLOOKUP(H9,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1920]
["Culaire","Laury","m","Marié(e)",23867,58,4,"Personnel",{"$f":"VLOOKUP(H10,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1920]
["Deuf","John","m","Célibataire",23262,60,4,"Informatique",{"$f":"VLOOKUP(H11,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},2280]
["Foupasune","Jean","m","Célibataire",27613,48,3,"Personnel",{"$f":"VLOOKUP(H12,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1840]
["Lairbon","Oussama","m","Marié(e)",30355,40,2,"Personnel",{"$f":"VLOOKUP(H13,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1760]
["Menvussa","Gérard","m","Célibataire",25906,52,3,"Informatique",{"$f":"VLOOKUP(H14,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},2185]
["Lalalalalalala","Starsky","m","Célibataire",20278,68,4,"Personnel",{"$f":"VLOOKUP(H15,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1920]
["Lalalalalalala","Hutch","m","Divorcé(e)",19274,71,4,"Direction",{"$f":"VLOOKUP(H16,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":2500},3000]
["Cléssoulaporte","Djamila","f","Marié(e)",21800,64,4,"Personnel",{"$f":"VLOOKUP(H17,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1920]
["Noux","Marion","f","Divorcé(e)",28854,44,2,"Secrétariat",{"$f":"VLOOKUP(H18,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1700},1870]
["Ouzi","Jacques","m","Célibataire",25262,54,3,"Personnel",{"$f":"VLOOKUP(H19,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1840]
["Stiké","Sophie","f","Divorcé(e)",21644,64,4,"Secrétariat",{"$f":"VLOOKUP(H20,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1700},2040]
["Tare","Guy","m","Divorcé(e)",22135,63,4,"Informatique",{"$f":"VLOOKUP(H21,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},2280]
["Vaisselle","Aude","f","Marié(e)",24264,57,4,"Secrétariat",{"$f":"VLOOKUP(H22,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1700},2040]
["Zetofrais","Mélanie","f","Célibataire",28819,44,2,"Direction",{"$f":"VLOOKUP(H23,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":2500},2750]
["Touille","Sasha","m","Célibataire",30254,40,2,"Personnel",{"$f":"VLOOKUP(H24,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1760]
["Proviste","Alain","m","Marié(e)","1959-09-09",64,4,"Personnel",{"$f":"VLOOKUP(H25,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1920]
["Peulaporte","Firmin","m","Divorcé(e)","1965-07-01",58,4,"Informatique",{"$f":"VLOOKUP(H26,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},2280]
["Unetitlaine","Jérémy","m","Marié(e)",30476,40,2,"Informatique",{"$f":"VLOOKUP(H27,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},2090]
["Parici","Yvon","m",null,"1975-08-02"]
["Lenti","Sara","f",null,"1988-08-06"]
[]
["NB : Lorsque c'est fait ajouter 2 personnes à la la liste de données, Yvon Parici et Sara Lenti, tous les 2 célibataires et nés le 2/8/75 et le 6/8/88"]
["=> Il suffit de réappliquer le filtre pour actualiser l'affichage"]
["=> Les validations de données de la colonne 'Etat civil' ne \"suivent\" pas, les formules de calculs non plus"]

{"sheet":"Filtre1 (2)","index":14,"n_rows":37,"n_cols":14,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
["Filtres automatiques",null,null,null,null,null,null,null,null,null,null,null,"Retour sommaire"]
[]
["Transformez la plage de données ci-dessous en 1 tableau de données et recommencez les manipulations de la feuille précédente"]
["A l'aide des filtres automatiques, afficher les employés dont le nom commence par un 'p'"]
[]
["Nom","Prénom","Sexe","Etat civil","Date de naissance","Age","Tranches","Services","Salaires Minimum","Salaires",null,null,null,"Services"]
["Bistrot","Alonso","m","Marié(e)","1966-01-17",{"$f":"DATEDIF(E7,TODAY(),\"y\")","v":57},{"$f":"IF(F7<25,0,IF(F7<35,1,IF(F7<45,2,IF(F7<55,3,4))))","v":4},"Informatique",{"$f":"VLOOKUP(H7,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},{"$f":"I7+5%*G7*I7","v":2280}]
["Bijoba","Jo","m","Marié(e)","1980-03-15",{"$f":"DATEDIF(E8,TODAY(),\"y\")","v":43},{"$f":"IF(F8<25,0,IF(F8<35,1,IF(F8<45,2,IF(F8<55,3,4))))","v":2},"Direction",{"$f":"VLOOKUP(H8,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":2500},{"$f":"I8+5%*G8*I8","v":2750}]
["Covert","Harry","m","Divorcé(e)","1942-02-10",81,4,"Personnel",{"$f":"VLOOKUP(H9,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1920]
["Culaire","Laury","m","Marié(e)","1965-05-05",58,4,"Personnel",{"$f":"VLOOKUP(H10,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1920]
["Deuf","John","m","Célibataire","1963-09-08",60,4,"Informatique",{"$f":"VLOOKUP(H11,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},2280]
["Foupasune","Jean","m","Célibataire","1975-08-07",48,3,"Personnel",{"$f":"VLOOKUP(H12,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1840]
["Lairbon","Oussama","m","Marié(e)","1983-02-08",40,2,"Personnel",{"$f":"VLOOKUP(H13,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1760]
["Menvussa","Gérard","m","Célibataire","1970-12-04",52,3,"Informatique",{"$f":"VLOOKUP(H14,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},2185]
["Lalalalalalala","Starsky","m","Célibataire","1955-07-08",68,4,"Personnel",{"$f":"VLOOKUP(H15,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1920]
["Lalalalalalala","Hutch","m","Divorcé(e)","1952-10-07",71,4,"Direction",{"$f":"VLOOKUP(H16,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":2500},3000]
["Cléssoulaporte","Djamila","f","Marié(e)","1959-09-07",64,4,"Personnel",{"$f":"VLOOKUP(H17,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1920]
["Noux","Marion","f","Divorcé(e)","1978-12-30",44,2,"Secrétariat",{"$f":"VLOOKUP(H18,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1700},1870]
["Ouzi","Jacques","m","Célibataire","1969-02-28",54,3,"Personnel",{"$f":"VLOOKUP(H19,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1840]
["Stiké","Sophie","f","Divorcé(e)","1959-04-04",64,4,"Secrétariat",{"$f":"VLOOKUP(H20,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1700},2040]
["Tare","Guy","m","Divorcé(e)","1960-08-07",63,4,"Informatique",{"$f":"VLOOKUP(H21,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},2280]
["Vaisselle","Aude","f","Marié(e)","1966-06-06",57,4,"Secrétariat",{"$f":"VLOOKUP(H22,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1700},2040]
["Zetofrais","Mélanie","f","Célibataire","1978-11-25",44,2,"Direction",{"$f":"VLOOKUP(H23,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":2500},2750]
["Touille","Sasha","m","Célibataire","1982-10-30",40,2,"Personnel",{"$f":"VLOOKUP(H24,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1760]
["Proviste","Alain","m","Marié(e)","1959-09-09",64,4,"Personnel",{"$f":"VLOOKUP(H25,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1920]
["Peulaporte","Firmin","m","Divorcé(e)","1965-07-01",58,4,"Informatique",{"$f":"VLOOKUP(H26,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},2280]
["Unetitlaine","Jérémy","m","Marié(e)","1983-06-09",40,2,"Informatique",{"$f":"VLOOKUP(H27,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},2090]
[]
[]
[]
["NB : Lorsque c'est fait ajouter 2 personnes à la la liste de données, Yvon Parici et Sara Lenti, tous les 2 célibataires et nés le 2/8/75 et le 6/8/88"]
["=> Les validations de données de la colonne 'Etat civil' et les formules se propagent aux nouvelles lignes"]
[]
["NB2 : En colonne N, faites une extraction de chaque service et utilisez le résultat en tant que source de la liste des services (colonne H). "]
["Ajoutez la mention RH en tant que 5ème service"]
["=> La source de la liste ne s'adapte pas, il faut la redéfinir ou utiliser une colonne complète "]
["Solution => Utiliser une zone nommée dans un tableau de données"]

{"sheet":"Filtre1 (2)_corrigé","index":15,"n_rows":37,"n_cols":14,"rows_kept":37,"cut":false,"hidden":true,"merged":[]}
["Filtres automatiques",null,null,null,null,null,null,null,null,null,null,null,"Retour sommaire"]
[]
["Transformez la plage de données ci-dessous en 1 tableau de données et récommencez les manipulations de la feuille précédente"]
["A l'aide des filtres automatiques, afficher les employés dont le nom commence par un 'p'"]
[]
["Nom","Prénom","Sexe","Etat civil","Date de naissance","Age","Tranches","Services","Salaires Minimum","Salaires",null,null,null,"Services"]
["Bistrot","Alonso","m","Marié(e)","1966-01-17",{"$f":"DATEDIF(E7,TODAY(),\"y\")","v":57},{"$f":"IF(F7<25,0,IF(F7<35,1,IF(F7<45,2,IF(F7<55,3,4))))","v":4},"Informatique",{"$f":"VLOOKUP(H7,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},{"$f":"I7+5%*G7*I7","v":2280},null,null,null,"Informatique"]
["Bijoba","Jo","m","Marié(e)","1980-03-15",{"$f":"DATEDIF(E8,TODAY(),\"y\")","v":43},{"$f":"IF(F8<25,0,IF(F8<35,1,IF(F8<45,2,IF(F8<55,3,4))))","v":2},"Direction",{"$f":"VLOOKUP(H8,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":2500},{"$f":"I8+5%*G8*I8","v":2750},null,null,null,"Direction"]
["Covert","Harry","m","Divorcé(e)","1942-02-10",81,4,"Personnel",{"$f":"VLOOKUP(H9,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1920,null,null,null,"Personnel"]
["Culaire","Laury","m","Marié(e)","1965-05-05",58,4,"Personnel",{"$f":"VLOOKUP(H10,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1920,null,null,null,"Secrétariat"]
["Deuf","John","m","Célibataire","1963-09-08",60,4,"Informatique",{"$f":"VLOOKUP(H11,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},2280,null,null,null,"RH"]
["Foupasune","Jean","m","Célibataire","1975-08-07",48,3,"Personnel",{"$f":"VLOOKUP(H12,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1840,null,null,null,"Entretien"]
["Lairbon","Oussama","m","Marié(e)","1983-02-08",40,2,"Personnel",{"$f":"VLOOKUP(H13,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1760]
["Menvussa","Gérard","m","Célibataire","1970-12-04",52,3,"Informatique",{"$f":"VLOOKUP(H14,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},2185]
["Lalalalalalala","Starsky","m","Célibataire","1955-07-08",68,4,"Personnel",{"$f":"VLOOKUP(H15,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1920]
["Lalalalalalala","Hutch","m","Divorcé(e)","1952-10-07",71,4,"Direction",{"$f":"VLOOKUP(H16,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":2500},3000]
["Cléssoulaporte","Djamila","f","Marié(e)","1959-09-07",64,4,"Personnel",{"$f":"VLOOKUP(H17,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1920]
["Noux","Marion","f","Divorcé(e)","1978-12-30",44,2,"Secrétariat",{"$f":"VLOOKUP(H18,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1700},1870]
["Ouzi","Jacques","m","Célibataire","1969-02-28",54,3,"Personnel",{"$f":"VLOOKUP(H19,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1840]
["Stiké","Sophie","f","Divorcé(e)","1959-04-04",64,4,"Secrétariat",{"$f":"VLOOKUP(H20,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1700},2040]
["Tare","Guy","m","Divorcé(e)","1960-08-07",63,4,"Informatique",{"$f":"VLOOKUP(H21,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},2280]
["Vaisselle","Aude","f","Marié(e)","1966-06-06",57,4,"Secrétariat",{"$f":"VLOOKUP(H22,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1700},2040]
["Zetofrais","Mélanie","f","Célibataire","1978-11-25",44,2,"Direction",{"$f":"VLOOKUP(H23,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":2500},2750]
["Touille","Sasha","m","Célibataire","1982-10-30",40,2,"Personnel",{"$f":"VLOOKUP(H24,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1760]
["Proviste","Alain","m","Marié(e)","1959-09-09",64,4,"Personnel",{"$f":"VLOOKUP(H25,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1920]
["Peulaporte","Firmin","m","Divorcé(e)","1965-07-01",58,4,"Informatique",{"$f":"VLOOKUP(H26,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},2280]
["Unetitlaine","Jérémy","m","Marié(e)","1983-06-09",40,2,"Informatique",{"$f":"VLOOKUP(H27,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},2090]
["Parici","Yvon","m","Célibataire","1975-08-02",{"$f":"DATEDIF(E28,TODAY(),\"y\")","v":48},{"$f":"IF(F28<25,0,IF(F28<35,1,IF(F28<45,2,IF(F28<55,3,4))))","v":3},"Personnel",{"$f":"VLOOKUP(H28,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},{"$f":"I28+5%*G28*I28","v":1840}]
["Lenti","Sara","f","Célibataire","1988-08-06",{"$f":"DATEDIF(E29,TODAY(),\"y\")","v":35},{"$f":"IF(F29<25,0,IF(F29<35,1,IF(F29<45,2,IF(F29<55,3,4))))","v":2},"Personnel",{"$f":"VLOOKUP(H29,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},{"$f":"I29+5%*G29*I29","v":1760}]
[]
["NB : Lorsque c'est fait ajouter 2 personnes à la la liste de données, Yvon Parici et Sara Lenti, tous les 2 célibataires et nés le 2/8/75 et le 6/8/88"]
["=> Les validations de données de la colonne 'Etat civil' et les formules se propagent aux nouvelles lignes"]
[]
["NB2 : En colonne N, faites une extraction de chaque service et utilisez le résultat en tant que source de la liste des services (colonne H). "]
["Ajoutez la mention RH en tant que 5ème service"]
["=> La source de la liste ne s'adapte pas, il faut la redéfinir ou utiliser une colonne complète "]
["Solution => Utiliser une zone nommée dans un tableau de données"]

{"sheet":"Filtre2","index":16,"n_rows":27,"n_cols":13,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
["Filtres automatiques",null,null,null,null,null,null,null,null,null,null,null,"Retour sommaire"]
[]
["Organisez les données en tableau et affichez les employés du secrétariat et de la direction"]
[]
[]
["Nom","Prénom","Sexe","Etat civil","Date de naissance","Age","Tranches","Services","Salaires Minimum","Salaires"]
["Bistrot","Alonso","m","Marié(e)","1966-01-17",{"$f":"DATEDIF(E7,TODAY(),\"y\")","v":57},{"$f":"IF(F7<25,0,IF(F7<35,1,IF(F7<45,2,IF(F7<55,3,4))))","v":4},"Informatique",{"$f":"VLOOKUP(H7,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},{"$f":"I7+5%*G7*I7","v":2280}]
["Bijoba","Jo","m","Marié(e)","1980-03-15",{"$f":"DATEDIF(E8,TODAY(),\"y\")","v":43},{"$f":"IF(F8<25,0,IF(F8<35,1,IF(F8<45,2,IF(F8<55,3,4))))","v":2},"Direction",{"$f":"VLOOKUP(H8,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":2500},{"$f":"I8+5%*G8*I8","v":2750}]
["Covert","Harry","m","Divorcé(e)","1942-02-10",81,4,"Personnel",{"$f":"VLOOKUP(H9,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1920]
["Culaire","Laury","m","Marié(e)","1965-05-05",58,4,"Personnel",{"$f":"VLOOKUP(H10,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1920]
["Deuf","John","m","Célibataire","1963-09-08",60,4,"Informatique",{"$f":"VLOOKUP(H11,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},2280]
["Foupasune","Jean","m","Célibataire","1975-08-07",48,3,"Personnel",{"$f":"VLOOKUP(H12,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1840]
["Lairbon","Oussama","m","Marié(e)","1983-02-08",40,2,"Personnel",{"$f":"VLOOKUP(H13,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1760]
["Menvussa","Gérard","m","Célibataire","1970-12-04",52,3,"Informatique",{"$f":"VLOOKUP(H14,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},2185]
["Lalalalalalala","Starsky","m","Célibataire","1955-07-08",68,4,"Personnel",{"$f":"VLOOKUP(H15,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1920]
["Lalalalalalala","Hutch","m","Divorcé(e)","1952-10-07",71,4,"Direction",{"$f":"VLOOKUP(H16,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":2500},3000]
["Cléssoulaporte","Djamila","f","Marié(e)","1959-09-07",64,4,"Personnel",{"$f":"VLOOKUP(H17,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1920]
["Noux","Marion","f","Divorcé(e)","1978-12-30",44,2,"Secrétariat",{"$f":"VLOOKUP(H18,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1700},1870]
["Ouzi","Jacques","m","Célibataire","1969-02-28",54,3,"Personnel",{"$f":"VLOOKUP(H19,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1840]
["Stiké","Sophie","f","Divorcé(e)","1959-04-04",64,4,"Secrétariat",{"$f":"VLOOKUP(H20,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1700},2040]
["Tare","Guy","m","Divorcé(e)","1960-08-07",63,4,"Informatique",{"$f":"VLOOKUP(H21,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},2280]
["Vaisselle","Aude","f","Marié(e)","1966-06-06",57,4,"Secrétariat",{"$f":"VLOOKUP(H22,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1700},2040]
["Zetofrais","Mélanie","f","Célibataire","1978-11-25",44,2,"Direction",{"$f":"VLOOKUP(H23,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":2500},2750]
["Touille","Sasha","m","Célibataire","1982-10-30",40,2,"Personnel",{"$f":"VLOOKUP(H24,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1760]
["Proviste","Alain","m","Marié(e)","1959-09-09",64,4,"Personnel",{"$f":"VLOOKUP(H25,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1920]
["Peulaporte","Firmin","m","Divorcé(e)","1965-07-01",58,4,"Informatique",{"$f":"VLOOKUP(H26,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},2280]
["Unetitlaine","Jérémy","m","Marié(e)","1983-06-09",40,2,"Informatique",{"$f":"VLOOKUP(H27,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},2090]

{"sheet":"Filtre2_corrigé","index":17,"n_rows":27,"n_cols":10,"rows_kept":27,"cut":false,"hidden":true,"merged":[]}
["Filtres automatiques"]
[]
["Organisez les données en tableau et affichez les employés du secrétariat et de la direction"]
[]
[]
["Nom","Prénom","Sexe","Etat civil","Date de naissance","Age","Tranches","Services","Salaires Minimum","Salaires"]
["Bistrot","Alonso","m","Marié(e)","1966-01-17",{"$f":"DATEDIF(E7,TODAY(),\"y\")","v":57},{"$f":"IF(F7<25,0,IF(F7<35,1,IF(F7<45,2,IF(F7<55,3,4))))","v":4},"Informatique",{"$f":"VLOOKUP(H7,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},{"$f":"I7+5%*G7*I7","v":2280}]
["Bijoba","Jo","m","Marié(e)","1980-03-15",43,2,"Direction",{"$f":"VLOOKUP(H8,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":2500},2750]
["Covert","Harry","m","Divorcé(e)","1942-02-10",81,4,"Personnel",{"$f":"VLOOKUP(H9,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1920]
["Culaire","Laury","m","Marié(e)","1965-05-05",58,4,"Personnel",{"$f":"VLOOKUP(H10,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1920]
["Deuf","John","m","Célibataire","1963-09-08",60,4,"Informatique",{"$f":"VLOOKUP(H11,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},2280]
["Foupasune","Jean","m","Célibataire","1975-08-07",48,3,"Personnel",{"$f":"VLOOKUP(H12,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1840]
["Lairbon","Oussama","m","Marié(e)","1983-02-08",40,2,"Personnel",{"$f":"VLOOKUP(H13,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1760]
["Menvussa","Gérard","m","Célibataire","1970-12-04",52,3,"Informatique",{"$f":"VLOOKUP(H14,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},2185]
["Lalalalalalala","Starsky","m","Célibataire","1955-07-08",68,4,"Personnel",{"$f":"VLOOKUP(H15,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1920]
["Lalalalalalala","Hutch","m","Divorcé(e)","1952-10-07",71,4,"Direction",{"$f":"VLOOKUP(H16,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":2500},3000]
["Cléssoulaporte","Djamila","f","Marié(e)","1959-09-07",64,4,"Personnel",{"$f":"VLOOKUP(H17,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1920]
["Noux","Marion","f","Divorcé(e)","1978-12-30",44,2,"Secrétariat",{"$f":"VLOOKUP(H18,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1700},1870]
["Ouzi","Jacques","m","Célibataire","1969-02-28",54,3,"Personnel",{"$f":"VLOOKUP(H19,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1840]
["Stiké","Sophie","f","Divorcé(e)","1959-04-04",64,4,"Secrétariat",{"$f":"VLOOKUP(H20,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1700},2040]
["Tare","Guy","m","Divorcé(e)","1960-08-07",63,4,"Informatique",{"$f":"VLOOKUP(H21,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},2280]
["Vaisselle","Aude","f","Marié(e)","1966-06-06",57,4,"Secrétariat",{"$f":"VLOOKUP(H22,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1700},2040]
["Zetofrais","Mélanie","f","Célibataire","1978-11-25",44,2,"Direction",{"$f":"VLOOKUP(H23,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":2500},2750]
["Touille","Sasha","m","Célibataire","1982-10-30",40,2,"Personnel",{"$f":"VLOOKUP(H24,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1760]
["Proviste","Alain","m","Marié(e)","1959-09-09",64,4,"Personnel",{"$f":"VLOOKUP(H25,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1920]
["Peulaporte","Firmin","m","Divorcé(e)","1965-07-01",58,4,"Informatique",{"$f":"VLOOKUP(H26,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},2280]
["Unetitlaine","Jérémy","m","Marié(e)","1983-06-09",40,2,"Informatique",{"$f":"VLOOKUP(H27,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},2090]

{"sheet":"Filtre3","index":18,"n_rows":27,"n_cols":13,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
["Filtres automatiques",null,null,null,null,null,null,null,null,null,null,null,"Retour sommaire"]
[]
["Organisez les données en tableau et affichez les employés nés entre 1965 et 1975"]
[]
[]
["Nom","Prénom","Sexe","Etat civil","Date de naissance","Age","Tranches","Services","Salaires Minimum","Salaires"]
["Bistrot","Alonso","m","Marié(e)","1966-01-17",{"$f":"DATEDIF(E7,TODAY(),\"y\")","v":57},{"$f":"IF(F7<25,0,IF(F7<35,1,IF(F7<45,2,IF(F7<55,3,4))))","v":4},"Informatique",{"$f":"VLOOKUP(H7,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},{"$f":"I7+5%*G7*I7","v":2280}]
["Bijoba","Jo","m","Marié(e)","1980-03-15",43,2,"Direction",{"$f":"VLOOKUP(H8,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":2500},2750]
["Covert","Harry","m","Divorcé(e)","1942-02-10",81,4,"Personnel",{"$f":"VLOOKUP(H9,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1920]
["Culaire","Laury","m","Marié(e)","1965-05-05",58,4,"Personnel",{"$f":"VLOOKUP(H10,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1920]
["Deuf","John","m","Célibataire","1963-09-08",60,4,"Informatique",{"$f":"VLOOKUP(H11,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},2280]
["Foupasune","Jean","m","Célibataire","1975-08-07",48,3,"Personnel",{"$f":"VLOOKUP(H12,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1840]
["Lairbon","Oussama","m","Marié(e)","1983-02-08",40,2,"Personnel",{"$f":"VLOOKUP(H13,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1760]
["Menvussa","Gérard","m","Célibataire","1970-12-04",52,3,"Informatique",{"$f":"VLOOKUP(H14,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},2185]
["Lalalalalalala","Starsky","m","Célibataire","1955-07-08",68,4,"Personnel",{"$f":"VLOOKUP(H15,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1920]
["Lalalalalalala","Hutch","m","Divorcé(e)","1952-10-07",71,4,"Direction",{"$f":"VLOOKUP(H16,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":2500},3000]
["Cléssoulaporte","Djamila","f","Marié(e)","1959-09-07",64,4,"Personnel",{"$f":"VLOOKUP(H17,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1920]
["Noux","Marion","f","Divorcé(e)","1978-12-30",44,2,"Secrétariat",{"$f":"VLOOKUP(H18,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1700},1870]
["Ouzi","Jacques","m","Célibataire","1969-02-28",54,3,"Personnel",{"$f":"VLOOKUP(H19,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1840]
["Stiké","Sophie","f","Divorcé(e)","1959-04-04",64,4,"Secrétariat",{"$f":"VLOOKUP(H20,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1700},2040]
["Tare","Guy","m","Divorcé(e)","1960-08-07",63,4,"Informatique",{"$f":"VLOOKUP(H21,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},2280]
["Vaisselle","Aude","f","Marié(e)","1966-06-06",57,4,"Secrétariat",{"$f":"VLOOKUP(H22,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1700},2040]
["Zetofrais","Mélanie","f","Célibataire","1978-11-25",44,2,"Direction",{"$f":"VLOOKUP(H23,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":2500},2750]
["Touille","Sasha","m","Célibataire","1982-10-30",40,2,"Personnel",{"$f":"VLOOKUP(H24,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1760]
["Proviste","Alain","m","Marié(e)","1959-09-09",64,4,"Personnel",{"$f":"VLOOKUP(H25,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1920]
["Peulaporte","Firmin","m","Divorcé(e)","1965-07-01",58,4,"Informatique",{"$f":"VLOOKUP(H26,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},2280]
["Unetitlaine","Jérémy","m","Marié(e)","1983-06-09",40,2,"Informatique",{"$f":"VLOOKUP(H27,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},2090]

{"sheet":"Filtre3_corrigé","index":19,"n_rows":27,"n_cols":10,"rows_kept":27,"cut":false,"hidden":true,"merged":[]}
["Filtres automatiques"]
[]
["Organisez les données en tableau et affichez les employés nés entre 1965 et 1975"]
[]
[]
["Nom","Prénom","Sexe","Etat civil","Date de naissance","Age","Tranches","Services","Salaires Minimum","Salaires"]
["Bistrot","Alonso","m","Marié(e)","1966-01-17",{"$f":"DATEDIF(E7,TODAY(),\"y\")","v":57},{"$f":"IF(F7<25,0,IF(F7<35,1,IF(F7<45,2,IF(F7<55,3,4))))","v":4},"Informatique",{"$f":"VLOOKUP(H7,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},{"$f":"I7+5%*G7*I7","v":2280}]
["Bijoba","Jo","m","Marié(e)","1980-03-15",43,2,"Direction",{"$f":"VLOOKUP(H8,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":2500},2750]
["Covert","Harry","m","Divorcé(e)","1942-02-10",81,4,"Personnel",{"$f":"VLOOKUP(H9,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1920]
["Culaire","Laury","m","Marié(e)","1965-05-05",58,4,"Personnel",{"$f":"VLOOKUP(H10,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1920]
["Deuf","John","m","Célibataire","1963-09-08",60,4,"Informatique",{"$f":"VLOOKUP(H11,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},2280]
["Foupasune","Jean","m","Célibataire","1975-08-07",48,3,"Personnel",{"$f":"VLOOKUP(H12,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1840]
["Lairbon","Oussama","m","Marié(e)","1983-02-08",40,2,"Personnel",{"$f":"VLOOKUP(H13,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1760]
["Menvussa","Gérard","m","Célibataire","1970-12-04",52,3,"Informatique",{"$f":"VLOOKUP(H14,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},2185]
["Lalalalalalala","Starsky","m","Célibataire","1955-07-08",68,4,"Personnel",{"$f":"VLOOKUP(H15,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1920]
["Lalalalalalala","Hutch","m","Divorcé(e)","1952-10-07",71,4,"Direction",{"$f":"VLOOKUP(H16,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":2500},3000]
["Cléssoulaporte","Djamila","f","Marié(e)","1959-09-07",64,4,"Personnel",{"$f":"VLOOKUP(H17,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1920]
["Noux","Marion","f","Divorcé(e)","1978-12-30",44,2,"Secrétariat",{"$f":"VLOOKUP(H18,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1700},1870]
["Ouzi","Jacques","m","Célibataire","1969-02-28",54,3,"Personnel",{"$f":"VLOOKUP(H19,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1840]
["Stiké","Sophie","f","Divorcé(e)","1959-04-04",64,4,"Secrétariat",{"$f":"VLOOKUP(H20,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1700},2040]
["Tare","Guy","m","Divorcé(e)","1960-08-07",63,4,"Informatique",{"$f":"VLOOKUP(H21,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},2280]
["Vaisselle","Aude","f","Marié(e)","1966-06-06",57,4,"Secrétariat",{"$f":"VLOOKUP(H22,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1700},2040]
["Zetofrais","Mélanie","f","Célibataire","1978-11-25",44,2,"Direction",{"$f":"VLOOKUP(H23,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":2500},2750]
["Touille","Sasha","m","Célibataire","1982-10-30",40,2,"Personnel",{"$f":"VLOOKUP(H24,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1760]
["Proviste","Alain","m","Marié(e)","1959-09-09",64,4,"Personnel",{"$f":"VLOOKUP(H25,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1920]
["Peulaporte","Firmin","m","Divorcé(e)","1965-07-01",58,4,"Informatique",{"$f":"VLOOKUP(H26,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},2280]
["Unetitlaine","Jérémy","m","Marié(e)","1983-06-09",40,2,"Informatique",{"$f":"VLOOKUP(H27,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},2090]

{"sheet":"Filtre4","index":20,"n_rows":27,"n_cols":13,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
["Filtres automatiques",null,null,null,null,null,null,null,null,null,null,null,"Retour sommaire"]
[]
["Organisez les données en tableau et affichez les employés de l'informatique et de la direction nés entre 1965 et 1975"]
[]
[]
["Nom","Prénom","Sexe","Etat civil","Date de naissance","Age","Tranches","Services","Salaires Minimum","Salaires"]
["Bistrot","Alonso","m","Marié(e)","1966-01-17",{"$f":"DATEDIF(E7,TODAY(),\"y\")","v":57},{"$f":"IF(F7<25,0,IF(F7<35,1,IF(F7<45,2,IF(F7<55,3,4))))","v":4},"Informatique",{"$f":"VLOOKUP(H7,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},{"$f":"I7+5%*G7*I7","v":2280}]
["Bijoba","Jo","m","Marié(e)","1980-03-15",43,2,"Direction",{"$f":"VLOOKUP(H8,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":2500},2750]
["Covert","Harry","m","Divorcé(e)","1942-02-10",81,4,"Personnel",{"$f":"VLOOKUP(H9,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1920]
["Culaire","Laury","m","Marié(e)","1965-05-05",58,4,"Personnel",{"$f":"VLOOKUP(H10,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1920]
["Deuf","John","m","Célibataire","1963-09-08",60,4,"Informatique",{"$f":"VLOOKUP(H11,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},2280]
["Foupasune","Jean","m","Célibataire","1975-08-07",48,3,"Personnel",{"$f":"VLOOKUP(H12,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1840]
["Lairbon","Oussama","m","Marié(e)","1983-02-08",40,2,"Personnel",{"$f":"VLOOKUP(H13,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1760]
["Menvussa","Gérard","m","Célibataire","1970-12-04",52,3,"Informatique",{"$f":"VLOOKUP(H14,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},2185]
["Lalalalalalala","Starsky","m","Célibataire","1955-07-08",68,4,"Personnel",{"$f":"VLOOKUP(H15,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1920]
["Lalalalalalala","Hutch","m","Divorcé(e)","1952-10-07",71,4,"Direction",{"$f":"VLOOKUP(H16,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":2500},3000]
["Cléssoulaporte","Djamila","f","Marié(e)","1959-09-07",64,4,"Personnel",{"$f":"VLOOKUP(H17,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1920]
["Noux","Marion","f","Divorcé(e)","1978-12-30",44,2,"Secrétariat",{"$f":"VLOOKUP(H18,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1700},1870]
["Ouzi","Jacques","m","Célibataire","1969-02-28",54,3,"Personnel",{"$f":"VLOOKUP(H19,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1840]
["Stiké","Sophie","f","Divorcé(e)","1959-04-04",64,4,"Secrétariat",{"$f":"VLOOKUP(H20,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1700},2040]
["Tare","Guy","m","Divorcé(e)","1960-08-07",63,4,"Informatique",{"$f":"VLOOKUP(H21,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},2280]
["Vaisselle","Aude","f","Marié(e)","1966-06-06",57,4,"Secrétariat",{"$f":"VLOOKUP(H22,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1700},2040]
["Zetofrais","Mélanie","f","Célibataire","1978-11-25",44,2,"Direction",{"$f":"VLOOKUP(H23,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":2500},2750]
["Touille","Sasha","m","Célibataire","1982-10-30",40,2,"Personnel",{"$f":"VLOOKUP(H24,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1760]
["Proviste","Alain","m","Marié(e)","1959-09-09",64,4,"Personnel",{"$f":"VLOOKUP(H25,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1920]
["Peulaporte","Firmin","m","Divorcé(e)","1965-07-01",58,4,"Informatique",{"$f":"VLOOKUP(H26,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},2280]
["Unetitlaine","Jérémy","m","Marié(e)","1983-06-09",40,2,"Informatique",{"$f":"VLOOKUP(H27,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},2090]

{"sheet":"Filtre4_corrigé","index":21,"n_rows":27,"n_cols":10,"rows_kept":27,"cut":false,"hidden":true,"merged":[]}
["Filtres automatiques"]
[]
["Organisez les données en tableau et affichez les employés de l'informatique et de la direction nés entre 1965 et 1975"]
[]
[]
["Nom","Prénom","Sexe","Etat civil","Date de naissance","Age","Tranches","Services","Salaires Minimum","Salaires"]
["Bistrot","Alonso","m","Marié(e)","1966-01-17",{"$f":"DATEDIF(E7,TODAY(),\"y\")","v":57},{"$f":"IF(F7<25,0,IF(F7<35,1,IF(F7<45,2,IF(F7<55,3,4))))","v":4},"Informatique",{"$f":"VLOOKUP(H7,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},{"$f":"I7+5%*G7*I7","v":2280}]
["Bijoba","Jo","m","Marié(e)","1980-03-15",43,2,"Direction",{"$f":"VLOOKUP(H8,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":2500},2750]
["Covert","Harry","m","Divorcé(e)","1942-02-10",81,4,"Personnel",{"$f":"VLOOKUP(H9,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1920]
["Culaire","Laury","m","Marié(e)","1965-05-05",58,4,"Personnel",{"$f":"VLOOKUP(H10,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1920]
["Deuf","John","m","Célibataire","1963-09-08",60,4,"Informatique",{"$f":"VLOOKUP(H11,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},2280]
["Foupasune","Jean","m","Célibataire","1975-08-07",48,3,"Personnel",{"$f":"VLOOKUP(H12,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1840]
["Lairbon","Oussama","m","Marié(e)","1983-02-08",40,2,"Personnel",{"$f":"VLOOKUP(H13,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1760]
["Menvussa","Gérard","m","Célibataire","1970-12-04",52,3,"Informatique",{"$f":"VLOOKUP(H14,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},2185]
["Lalalalalalala","Starsky","m","Célibataire","1955-07-08",68,4,"Personnel",{"$f":"VLOOKUP(H15,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1920]
["Lalalalalalala","Hutch","m","Divorcé(e)","1952-10-07",71,4,"Direction",{"$f":"VLOOKUP(H16,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":2500},3000]
["Cléssoulaporte","Djamila","f","Marié(e)","1959-09-07",64,4,"Personnel",{"$f":"VLOOKUP(H17,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1920]
["Noux","Marion","f","Divorcé(e)","1978-12-30",44,2,"Secrétariat",{"$f":"VLOOKUP(H18,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1700},1870]
["Ouzi","Jacques","m","Célibataire","1969-02-28",54,3,"Personnel",{"$f":"VLOOKUP(H19,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1840]
["Stiké","Sophie","f","Divorcé(e)","1959-04-04",64,4,"Secrétariat",{"$f":"VLOOKUP(H20,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1700},2040]
["Tare","Guy","m","Divorcé(e)","1960-08-07",63,4,"Informatique",{"$f":"VLOOKUP(H21,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},2280]
["Vaisselle","Aude","f","Marié(e)","1966-06-06",57,4,"Secrétariat",{"$f":"VLOOKUP(H22,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1700},2040]
["Zetofrais","Mélanie","f","Célibataire","1978-11-25",44,2,"Direction",{"$f":"VLOOKUP(H23,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":2500},2750]
["Touille","Sasha","m","Célibataire","1982-10-30",40,2,"Personnel",{"$f":"VLOOKUP(H24,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1760]
["Proviste","Alain","m","Marié(e)","1959-09-09",64,4,"Personnel",{"$f":"VLOOKUP(H25,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1920]
["Peulaporte","Firmin","m","Divorcé(e)","1965-07-01",58,4,"Informatique",{"$f":"VLOOKUP(H26,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},2280]
["Unetitlaine","Jérémy","m","Marié(e)","1983-06-09",40,2,"Informatique",{"$f":"VLOOKUP(H27,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},2090]

{"sheet":"Filtre5","index":22,"n_rows":27,"n_cols":13,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
["Filtres automatiques",null,null,null,null,null,null,null,null,null,null,null,"Retour sommaire"]
[]
["Organisez les données en tableau et utilisez les segments pour afficher les employés de l'informatique et de la direction nés entre 1965 et 1975"]
[]
[]
["Nom","Prénom","Sexe","Etat civil","Date de naissance","Age","Tranches","Services","Salaires Minimum","Salaires"]
["Bistrot","Alonso","m","Marié(e)","1966-01-17",{"$f":"DATEDIF(E7,TODAY(),\"y\")","v":57},{"$f":"IF(F7<25,0,IF(F7<35,1,IF(F7<45,2,IF(F7<55,3,4))))","v":4},"Informatique",{"$f":"VLOOKUP(H7,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},{"$f":"I7+5%*G7*I7","v":2280}]
["Bijoba","Jo","m","Marié(e)","1980-03-15",43,2,"Direction",{"$f":"VLOOKUP(H8,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":2500},2750]
["Covert","Harry","m","Divorcé(e)","1942-02-10",81,4,"Personnel",{"$f":"VLOOKUP(H9,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1920]
["Culaire","Laury","m","Marié(e)","1965-05-05",58,4,"Personnel",{"$f":"VLOOKUP(H10,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1920]
["Deuf","John","m","Célibataire","1963-09-08",60,4,"Informatique",{"$f":"VLOOKUP(H11,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},2280]
["Foupasune","Jean","m","Célibataire","1975-08-07",48,3,"Personnel",{"$f":"VLOOKUP(H12,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1840]
["Lairbon","Oussama","m","Marié(e)","1983-02-08",40,2,"Personnel",{"$f":"VLOOKUP(H13,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1760]
["Menvussa","Gérard","m","Célibataire","1970-12-04",52,3,"Informatique",{"$f":"VLOOKUP(H14,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},2185]
["Lalalalalalala","Starsky","m","Célibataire","1955-07-08",68,4,"Personnel",{"$f":"VLOOKUP(H15,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1920]
["Lalalalalalala","Hutch","m","Divorcé(e)","1952-10-07",71,4,"Direction",{"$f":"VLOOKUP(H16,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":2500},3000]
["Cléssoulaporte","Djamila","f","Marié(e)","1959-09-07",64,4,"Personnel",{"$f":"VLOOKUP(H17,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1920]
["Noux","Marion","f","Divorcé(e)","1978-12-30",44,2,"Secrétariat",{"$f":"VLOOKUP(H18,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1700},1870]
["Ouzi","Jacques","m","Célibataire","1969-02-28",54,3,"Personnel",{"$f":"VLOOKUP(H19,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1840]
["Stiké","Sophie","f","Divorcé(e)","1959-04-04",64,4,"Secrétariat",{"$f":"VLOOKUP(H20,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1700},2040]
["Tare","Guy","m","Divorcé(e)","1960-08-07",63,4,"Informatique",{"$f":"VLOOKUP(H21,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},2280]
["Vaisselle","Aude","f","Marié(e)","1966-06-06",57,4,"Secrétariat",{"$f":"VLOOKUP(H22,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1700},2040]
["Zetofrais","Mélanie","f","Célibataire","1978-11-25",44,2,"Direction",{"$f":"VLOOKUP(H23,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":2500},2750]
["Touille","Sasha","m","Célibataire","1982-10-30",40,2,"Personnel",{"$f":"VLOOKUP(H24,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1760]
["Proviste","Alain","m","Marié(e)","1959-09-09",64,4,"Personnel",{"$f":"VLOOKUP(H25,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1920]
["Peulaporte","Firmin","m","Divorcé(e)","1965-07-01",58,4,"Informatique",{"$f":"VLOOKUP(H26,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},2280]
["Unetitlaine","Jérémy","m","Marié(e)","1983-06-09",40,2,"Informatique",{"$f":"VLOOKUP(H27,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},2090]

{"sheet":"Filtre5_corrigé","index":23,"n_rows":27,"n_cols":13,"rows_kept":27,"cut":false,"hidden":true,"merged":[]}
["Filtres automatiques",null,null,null,null,null,null,null,null,null,null,null,"Retour sommaire"]
[]
["Organisez les données en tableau et utilisez les segments pour afficher les employés de l'informatique et de la direction nés entre 1965 et 1975"]
[]
[]
["Nom","Prénom","Sexe","Etat civil","Date de naissance","Age","Tranches","Services","Salaires Minimum","Salaires"]
["Bistrot","Alonso","m","Marié(e)","1966-01-17",{"$f":"DATEDIF(E7,TODAY(),\"y\")","v":57},{"$f":"IF(F7<25,0,IF(F7<35,1,IF(F7<45,2,IF(F7<55,3,4))))","v":4},"Informatique",{"$f":"VLOOKUP(H7,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},{"$f":"I7+5%*G7*I7","v":2280}]
["Bijoba","Jo","m","Marié(e)","1980-03-15",43,2,"Direction",{"$f":"VLOOKUP(H8,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":2500},2750]
["Covert","Harry","m","Divorcé(e)","1942-02-10",81,4,"Personnel",{"$f":"VLOOKUP(H9,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1920]
["Culaire","Laury","m","Marié(e)","1965-05-05",58,4,"Personnel",{"$f":"VLOOKUP(H10,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1920]
["Deuf","John","m","Célibataire","1963-09-08",60,4,"Informatique",{"$f":"VLOOKUP(H11,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},2280]
["Foupasune","Jean","m","Célibataire","1975-08-07",48,3,"Personnel",{"$f":"VLOOKUP(H12,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1840]
["Lairbon","Oussama","m","Marié(e)","1983-02-08",40,2,"Personnel",{"$f":"VLOOKUP(H13,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1760]
["Menvussa","Gérard","m","Célibataire","1970-12-04",52,3,"Informatique",{"$f":"VLOOKUP(H14,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},2185]
["Lalalalalalala","Starsky","m","Célibataire","1955-07-08",68,4,"Personnel",{"$f":"VLOOKUP(H15,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1920]
["Lalalalalalala","Hutch","m","Divorcé(e)","1952-10-07",71,4,"Direction",{"$f":"VLOOKUP(H16,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":2500},3000]
["Cléssoulaporte","Djamila","f","Marié(e)","1959-09-07",64,4,"Personnel",{"$f":"VLOOKUP(H17,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1920]
["Noux","Marion","f","Divorcé(e)","1978-12-30",44,2,"Secrétariat",{"$f":"VLOOKUP(H18,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1700},1870]
["Ouzi","Jacques","m","Célibataire","1969-02-28",54,3,"Personnel",{"$f":"VLOOKUP(H19,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1840]
["Stiké","Sophie","f","Divorcé(e)","1959-04-04",64,4,"Secrétariat",{"$f":"VLOOKUP(H20,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1700},2040]
["Tare","Guy","m","Divorcé(e)","1960-08-07",63,4,"Informatique",{"$f":"VLOOKUP(H21,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},2280]
["Vaisselle","Aude","f","Marié(e)","1966-06-06",57,4,"Secrétariat",{"$f":"VLOOKUP(H22,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1700},2040]
["Zetofrais","Mélanie","f","Célibataire","1978-11-25",44,2,"Direction",{"$f":"VLOOKUP(H23,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":2500},2750]
["Touille","Sasha","m","Célibataire","1982-10-30",40,2,"Personnel",{"$f":"VLOOKUP(H24,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1760]
["Proviste","Alain","m","Marié(e)","1959-09-09",64,4,"Personnel",{"$f":"VLOOKUP(H25,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1920]
["Peulaporte","Firmin","m","Divorcé(e)","1965-07-01",58,4,"Informatique",{"$f":"VLOOKUP(H26,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},2280]
["Unetitlaine","Jérémy","m","Marié(e)","1983-06-09",40,2,"Informatique",{"$f":"VLOOKUP(H27,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},2090]

{"sheet":"FiltresElabDonnées","index":24,"n_rows":28,"n_cols":10,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
["Bdd à filtrer par un filtre élaboré"]
[]
["Les filtres élaborés permettent à l'utilisateur de filtrer vers un autre emplacement (autre feuille par exemple)."]
["Les données à utiliser sont les suivantes. Consignes, critères et résultats se trouveront sur les feuilles qui suivent."]
[]
["Nom","Prénom","Sexe","Etat civil","Date de naissance","Age","Tranches","Services","Salaires Minimum","Salaires"]
["Bistrot","Alonso","m","Marié(e)","1966-01-17",{"$f":"DATEDIF(E7,TODAY(),\"y\")","v":57},{"$f":"IF(F7<25,0,IF(F7<35,1,IF(F7<45,2,IF(F7<55,3,4))))","v":4},"Informatique",{"$f":"VLOOKUP(H7,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},{"$f":"I7+5%*G7*I7","v":2280}]
["Bijoba","Jo","m","Marié(e)","1980-03-15",43,2,"Direction",{"$f":"VLOOKUP(H8,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":2500},2750]
["Covert","Harry","m","Divorcé(e)","1942-02-10",81,4,"Personnel",{"$f":"VLOOKUP(H9,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1920]
["Culaire","Laury","m","Marié(e)","1965-05-05",58,4,"Personnel",{"$f":"VLOOKUP(H10,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1920]
["Deuf","John","m","Célibataire","1963-09-08",60,4,"Informatique",{"$f":"VLOOKUP(H11,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},2280]
["Foupasune","Jean","m","Célibataire","1975-08-07",48,3,"Personnel",{"$f":"VLOOKUP(H12,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1840]
["Lairbon","Oussama","m","Marié(e)","1983-02-08",40,2,"Personnel",{"$f":"VLOOKUP(H13,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1760]
["Menvussa","Gérard","m","Célibataire","1970-12-04",52,3,"Informatique",{"$f":"VLOOKUP(H14,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},2185]
["Lalalalalalala","Starsky","m","Célibataire","1955-07-08",68,4,"Personnel",{"$f":"VLOOKUP(H15,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1920]
["Lalalalalalala","Hutch","m","Divorcé(e)","1952-10-07",71,4,"Direction",{"$f":"VLOOKUP(H16,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":2500},3000]
["Cléssoulaporte","Djamila","f","Marié(e)","1959-09-07",64,4,"Personnel",{"$f":"VLOOKUP(H17,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1920]
["Noux","Marion","f","Divorcé(e)","1978-12-30",44,2,"Secrétariat",{"$f":"VLOOKUP(H18,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1700},1870]
["Ouzi","Jacques","m","Célibataire","1969-02-28",54,3,"Personnel",{"$f":"VLOOKUP(H19,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1840]
["Stiké","Sophie","f","Divorcé(e)","1959-04-04",64,4,"Secrétariat",{"$f":"VLOOKUP(H20,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1700},2040]
["Tare","Guy","m","Divorcé(e)","1960-08-07",63,4,"Informatique",{"$f":"VLOOKUP(H21,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},2280]
["Vaisselle","Aude","f","Marié(e)","1966-06-06",57,4,"Secrétariat",{"$f":"VLOOKUP(H22,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1700},2040]
["Zetofrais","Mélanie","f","Célibataire","1978-11-25",44,2,"Direction",{"$f":"VLOOKUP(H23,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":2500},2750]
["Touille","Sasha","m","Célibataire","1982-10-30",40,2,"Personnel",{"$f":"VLOOKUP(H24,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1760]
["Proviste","Alain","m","Marié(e)","1959-09-09",64,4,"Personnel",{"$f":"VLOOKUP(H25,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1920]
["Peulaporte","Firmin","m","Divorcé(e)","1965-07-01",58,4,"Informatique",{"$f":"VLOOKUP(H26,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},2280]
["Unetitlaine","Jérémy","m","Marié(e)","1983-06-09",40,2,"Informatique",{"$f":"VLOOKUP(H27,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},2090]
["Ouzi","Jacques","m","Célibataire","1969-02-28",54,3,"Personnel",{"$f":"VLOOKUP(H28,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},{"$f":"I28+5%*G28*I28","v":1840}]

{"sheet":"FiltreElab1","index":25,"n_rows":3,"n_cols":13,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,"Retour sommaire"]
[]
["A l'aide des filtres avancés, afficher les employés dont le nom commence par un 'p'"]

{"sheet":"FiltreElab1_corrigé","index":26,"n_rows":12,"n_cols":11,"rows_kept":12,"cut":false,"hidden":true,"merged":[]}
[]
[]
["A l'aide des filtres avancés, afficher les employés dont le nom commence par un 'p'"]
[]
[]
[null,"Nom"]
[null,"p"]
[]
[]
[null,"Nom","Prénom","Sexe","Etat civil","Date de naissance","Age","Tranches","Services","Salaires Minimum","Salaires"]
[null,"Proviste","Alain","m","Marié(e)","1959-09-09",64,4,"Personnel",1600,1920]
[null,"Peulaporte","Firmin","m","Divorcé(e)","1965-07-01",58,4,"Informatique",1900,2280]

{"sheet":"FiltreElab2","index":27,"n_rows":3,"n_cols":13,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,"Retour sommaire"]
[]
["A l'aide des filtres avancés, afficher les nom, prénom et service des employés du secrétariat et de la direction"]

{"sheet":"FiltreElab2_corrigé","index":28,"n_rows":16,"n_cols":4,"rows_kept":16,"cut":false,"hidden":true,"merged":[]}
[]
[]
["A l'aide des filtres avancés, afficher les nom, prénom et service des employés du secrétariat et de la direction"]
[]
[null,"Services"]
[null,"Secrétariat"]
[null,"Direction"]
[]
[]
[null,"Nom","Prénom","Services"]
[null,"Bijoba","Jo","Direction"]
[null,"Lalalalalalala","Hutch","Direction"]
[null,"Noux","Marion","Secrétariat"]
[null,"Stiké","Sophie","Secrétariat"]
[null,"Vaisselle","Aude","Secrétariat"]
[null,"Zetofrais","Mélanie","Direction"]

{"sheet":"FiltreElab3","index":29,"n_rows":3,"n_cols":13,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,"Retour sommaire"]
[]
["A l'aide des filtres avancés, afficher les employés nés entre 1965 et 1975"]

{"sheet":"FiltreElab3_corrigé","index":30,"n_rows":19,"n_cols":11,"rows_kept":19,"cut":false,"hidden":true,"merged":[]}
[]
[]
["A l'aide des filtres avancés, afficher les employés nés entre 1965 et 1975"]
[]
[]
[]
[null,"Date de naissance","Date de naissance"]
[null,">=1/1/1965","<1/1/1976"]
[]
[]
[null,"Nom","Prénom","Sexe","Etat civil","Date de naissance","Age","Tranches","Services","Salaires Minimum","Salaires"]
[null,"Bistrot","Alonso","m","Marié(e)","1966-01-17",57,4,"Informatique",1900,2280]
[null,"Culaire","Laury","m","Marié(e)","1965-05-05",58,4,"Personnel",1600,1920]
[null,"Foupasune","Jean","m","Célibataire","1975-08-07",48,3,"Personnel",1600,1840]
[null,"Menvussa","Gérard","m","Célibataire","1970-12-04",52,3,"Informatique",1900,2185]
[null,"Ouzi","Jacques","m","Célibataire","1969-02-28",54,3,"Personnel",1600,1840]
[null,"Vaisselle","Aude","f","Marié(e)","1966-06-06",57,4,"Secrétariat",1700,2040]
[null,"Peulaporte","Firmin","m","Divorcé(e)","1965-07-01",58,4,"Informatique",1900,2280]
[null,"Ouzi","Jacques","m","Célibataire","1969-02-28",54,3,"Personnel",1600,1840]

{"sheet":"FiltreElab4","index":31,"n_rows":3,"n_cols":13,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,"Retour sommaire"]
[]
["A l'aide des filtres avancés, afficher les employés de l'informatique et de la direction nés entre 1965 et 1975"]

{"sheet":"FiltreElab4_corrigé","index":32,"n_rows":14,"n_cols":11,"rows_kept":14,"cut":false,"hidden":true,"merged":[]}
[]
[]
["A l'aide des filtres avancés, afficher les employés de l'informatique et de la direction nés entre 1965 et 1975"]
[]
[]
[null,"Date de naissance","Date de naissance","Services"]
[null,">=1/1/1965","<1/1/1976","informatique"]
[null,">=1/1/1965","<1/1/1976","direction"]
[]
[]
[null,"Nom","Prénom","Sexe","Etat civil","Date de naissance","Age","Tranches","Services","Salaires Minimum","Salaires"]
[null,"Bistrot","Alonso","m","Marié(e)","1966-01-17",57,4,"Informatique",1900,2280]
[null,"Menvussa","Gérard","m","Célibataire","1970-12-04",52,3,"Informatique",1900,2185]
[null,"Peulaporte","Firmin","m","Divorcé(e)","1965-07-01",58,4,"Informatique",1900,2280]

{"sheet":"FiltreElab5","index":33,"n_rows":3,"n_cols":13,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,"Retour sommaire"]
[]
["A l'aide des filtres avancés, faites une extraction des données sans recopier les doublons"]

{"sheet":"FiltreElab5_corrigé","index":34,"n_rows":27,"n_cols":10,"rows_kept":27,"cut":false,"hidden":true,"merged":[]}
[]
[]
["A l'aide des filtres élaborés, faites une extraction des données sans recopier les doublons"]
[]
[]
["Nom","Prénom","Sexe","Etat civil","Date de naissance","Age","Tranches","Services","Salaires Minimum","Salaires"]
["Bistrot","Alonso","m","Marié(e)","1966-01-17",42,2,"Informatique",1900,2090]
["Bijoba","Jo","m","Marié(e)","1980-03-15",28,1,"Direction",2500,2625]
["Covert","Harry","m","Divorcé(e)","1942-02-10",66,4,"Personnel",1600,1920]
["Culaire","Laury","m","Marié(e)","1965-05-05",42,2,"Personnel",1600,1760]
["Deuf","John","m","Célibataire","1963-09-08",44,2,"Informatique",1900,2090]
["Foupasune","Jean","m","Célibataire","1975-08-07",32,1,"Personnel",1600,1680]
["Lairbon","Oussama","m","Marié(e)","1983-02-08",25,1,"Personnel",1600,1680]
["Menvussa","Gérard","m","Célibataire","1970-12-04",37,2,"Informatique",1900,2090]
["Lalalalalalala","Starsky","m","Célibataire","1955-07-08",52,3,"Personnel",1600,1840]
["Lalalalalalala","Hutch","m","Divorcé(e)","1952-10-07",55,4,"Direction",2500,3000]
["Cléssoulaporte","Djamila","f","Marié(e)","1959-09-07",48,3,"Personnel",1600,1840]
["Noux","Marion","f","Divorcé(e)","1978-12-30",29,1,"Secrétariat",1700,1785]
["Ouzi","Jacques","m","Célibataire","1969-02-28",39,2,"Personnel",1600,1760]
["Stiké","Sophie","f","Divorcé(e)","1959-04-04",49,3,"Secrétariat",1700,1955]
["Tare","Guy","m","Divorcé(e)","1960-08-07",47,3,"Informatique",1900,2185]
["Vaisselle","Aude","f","Marié(e)","1966-06-06",41,2,"Secrétariat",1700,1870]
["Zetofrais","Mélanie","f","Célibataire","1978-11-25",29,1,"Direction",2500,2625]
["Touille","Sasha","m","Célibataire","1982-10-30",25,1,"Personnel",1600,1680]
["Proviste","Alain","m","Marié(e)","1959-09-09",48,3,"Personnel",1600,1840]
["Peulaporte","Firmin","m","Divorcé(e)","1965-07-01",42,2,"Informatique",1900,2090]
["Unetitlaine","Jérémy","m","Marié(e)","1983-06-09",24,0,"Informatique",1900,1900]

{"sheet":"FiltreElab6","index":35,"n_rows":3,"n_cols":13,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,"Retour sommaire"]
[]
["A l'aide des filtres avancés, afficher les employés dont l'âge est supérieur à la moyenne des âges"]

{"sheet":"FiltreElab6_corrigé","index":36,"n_rows":21,"n_cols":11,"rows_kept":21,"cut":false,"hidden":true,"merged":[]}
[]
[]
["A l'aide des filtres avancés, afficher les employés dont l'âge est supérieur à la moyenne des âges"]
[]
[null,"Condition"]
[null,{"$f":"FiltresElabDonnées!F7>AVERAGE(Tableau25[Age])","v":true}]
[]
[]
[null,"Nom","Prénom","Sexe","Etat civil","Date de naissance","Age","Tranches","Services","Salaires Minimum","Salaires"]
[null,"Bistrot","Alonso","m","Marié(e)","1966-01-17",57,4,"Informatique",1900,2280]
[null,"Covert","Harry","m","Divorcé(e)","1942-02-10",81,4,"Personnel",1600,1920]
[null,"Culaire","Laury","m","Marié(e)","1965-05-05",58,4,"Personnel",1600,1920]
[null,"Deuf","John","m","Célibataire","1963-09-08",60,4,"Informatique",1900,2280]
[null,"Lalalalalalala","Starsky","m","Célibataire","1955-07-08",68,4,"Personnel",1600,1920]
[null,"Lalalalalalala","Hutch","m","Divorcé(e)","1952-10-07",71,4,"Direction",2500,3000]
[null,"Cléssoulaporte","Djamila","f","Marié(e)","1959-09-07",64,4,"Personnel",1600,1920]
[null,"Stiké","Sophie","f","Divorcé(e)","1959-04-04",64,4,"Secrétariat",1700,2040]
[null,"Tare","Guy","m","Divorcé(e)","1960-08-07",63,4,"Informatique",1900,2280]
[null,"Vaisselle","Aude","f","Marié(e)","1966-06-06",57,4,"Secrétariat",1700,2040]
[null,"Proviste","Alain","m","Marié(e)","1959-09-09",64,4,"Personnel",1600,1920]
[null,"Peulaporte","Firmin","m","Divorcé(e)","1965-07-01",58,4,"Informatique",1900,2280]

{"sheet":"Fonctions classiques","index":37,"n_rows":28,"n_cols":15,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
["Utilisation des fonctions classiques",null,null,null,null,null,null,null,null,null,null,null,"Retour sommaire"]
[]
["Utilisez les fonctions classiques de façon à afficher le nombre d'employés par service."]
["Utilisez les fonctions classiques de façon à afficher le nombre d'employés et la moyenne des âges par sexe et par état civil."]
[]
["Nom","Prénom","Sexe","Etat civil","Date de naissance","Age","Tranches","Services","Salaires Minimum","Salaires"]
["Bistrot","Alonso","m","Marié(e)","1966-01-17",{"$f":"DATEDIF(E7,TODAY(),\"y\")","v":57},{"$f":"IF(F7<25,0,IF(F7<35,1,IF(F7<45,2,IF(F7<55,3,4))))","v":4},"Informatique",{"$f":"VLOOKUP(H7,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},{"$f":"I7+5%*G7*I7","v":2280},null,null,"Nombre d'employés par service"]
["Bijoba","Jo","m","Marié(e)","1980-03-15",43,2,"Direction",{"$f":"VLOOKUP(H8,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":2500},2750]
["Covert","Harry","m","Divorcé(e)","1942-02-10",81,4,"Personnel",{"$f":"VLOOKUP(H9,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1920,null,null,"Direction"]
["Culaire","Laury","m","Marié(e)","1965-05-05",58,4,"Personnel",{"$f":"VLOOKUP(H10,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1920,null,null,"Informatique"]
["Deuf","John","m","Célibataire","1963-09-08",60,4,"Informatique",{"$f":"VLOOKUP(H11,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},2280,null,null,"Personnel"]
["Foupasune","Jean","m","Célibataire","1975-08-07",48,3,"Personnel",{"$f":"VLOOKUP(H12,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1840,null,null,"Secrétariat"]
["Lairbon","Oussama","m","Marié(e)","1983-02-08",40,2,"Personnel",{"$f":"VLOOKUP(H13,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1760]
["Menvussa","Gérard","m","Célibataire","1970-12-04",52,3,"Informatique",{"$f":"VLOOKUP(H14,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},2185,null,null,"Nombre d'employés par sexe et état civil"]
["Lalalalalalala","Starsky","m","Célibataire","1955-07-08",68,4,"Personnel",{"$f":"VLOOKUP(H15,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1920]
["Lalalalalalala","Hutch","m","Divorcé(e)","1952-10-07",71,4,"Direction",{"$f":"VLOOKUP(H16,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":2500},3000,null,null,null,"f","m"]
["Cléssoulaporte","Djamila","f","Marié(e)","1959-09-07",64,4,"Personnel",{"$f":"VLOOKUP(H17,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1920,null,null,"Célibataire"]
["Noux","Marion","f","Divorcé(e)","1978-12-30",44,2,"Secrétariat",{"$f":"VLOOKUP(H18,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1700},1870,null,null,"Divorcé(e)"]
["Ouzi","Jacques","m","Célibataire","1969-02-28",54,3,"Personnel",{"$f":"VLOOKUP(H19,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1840,null,null,"Marié(e)"]
["Stiké","Sophie","f","Divorcé(e)","1959-04-04",64,4,"Secrétariat",{"$f":"VLOOKUP(H20,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1700},2040]
["Tare","Guy","m","Divorcé(e)","1960-08-07",63,4,"Informatique",{"$f":"VLOOKUP(H21,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},2280,null,null,"Salaire moyen par sexe et état civil"]
["Vaisselle","Aude","f","Marié(e)","1966-06-06",57,4,"Secrétariat",{"$f":"VLOOKUP(H22,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1700},2040]
["Zetofrais","Mélanie","f","Célibataire","1978-11-25",44,2,"Direction",{"$f":"VLOOKUP(H23,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":2500},2750,null,null,null,"f","m"]
["Touille","Sasha","m","Célibataire","1982-10-30",40,2,"Personnel",{"$f":"VLOOKUP(H24,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1760,null,null,"Célibataire"]
["Proviste","Alain","m","Marié(e)","1959-09-09",64,4,"Personnel",{"$f":"VLOOKUP(H25,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1920,null,null,"Divorcé(e)"]
["Peulaporte","Firmin","m","Divorcé(e)","1965-07-01",58,4,"Informatique",{"$f":"VLOOKUP(H26,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},2280,null,null,"Marié(e)"]
["Unetitlaine","Jérémy","m","Marié(e)","1983-06-09",40,2,"Informatique",{"$f":"VLOOKUP(H27,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},2090]
["Ouzi","Jacques","m","Célibataire","1969-02-28",54,3,"Personnel",{"$f":"VLOOKUP(H28,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1840]

{"sheet":"Fonctions classiques_corrigé","index":38,"n_rows":28,"n_cols":15,"rows_kept":28,"cut":false,"hidden":true,"merged":[]}
["Utilisation des fonctions classiques",null,null,null,null,null,null,null,null,null,null,null,"Retour sommaire"]
[]
["Utilisez les fonctions classiques de façon à afficher le nombre d'employés par service."]
["Utilisez les fonctions classiques de façon à afficher le nombre d'employés et la moyenne des âges par sexe et par état civil."]
[]
["Nom","Prénom","Sexe","Etat civil","Date de naissance","Age","Tranches","Services","Salaires Minimum","Salaires"]
["Bistrot","Alonso","m","Marié(e)","1966-01-17",{"$f":"DATEDIF(E7,TODAY(),\"y\")","v":57},{"$f":"IF(F7<25,0,IF(F7<35,1,IF(F7<45,2,IF(F7<55,3,4))))","v":4},"Informatique",{"$f":"VLOOKUP(H7,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},{"$f":"I7+5%*G7*I7","v":2280},null,null,"Nombre d'employés par service"]
["Bijoba","Jo","m","Marié(e)","1980-03-15",43,2,"Direction",{"$f":"VLOOKUP(H8,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":2500},2750]
["Covert","Harry","m","Divorcé(e)","1942-02-10",81,4,"Personnel",{"$f":"VLOOKUP(H9,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1920,null,null,"Direction",{"$f":"COUNTIF($H$7:$H$28,M9)","v":3}]
["Culaire","Laury","m","Marié(e)","1965-05-05",58,4,"Personnel",{"$f":"VLOOKUP(H10,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1920,null,null,"Informatique",{"$f":"COUNTIF($H$7:$H$28,M10)","v":6}]
["Deuf","John","m","Célibataire","1963-09-08",60,4,"Informatique",{"$f":"VLOOKUP(H11,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},2280,null,null,"Personnel",{"$f":"COUNTIF($H$7:$H$28,M11)","v":10}]
["Foupasune","Jean","m","Célibataire","1975-08-07",48,3,"Personnel",{"$f":"VLOOKUP(H12,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1840,null,null,"Secrétariat",{"$f":"COUNTIF($H$7:$H$28,M12)","v":3}]
["Lairbon","Oussama","m","Marié(e)","1983-02-08",40,2,"Personnel",{"$f":"VLOOKUP(H13,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1760]
["Menvussa","Gérard","m","Célibataire","1970-12-04",52,3,"Informatique",{"$f":"VLOOKUP(H14,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},2185,null,null,"Nombre d'employés par sexe et état civil"]
["Lalalalalalala","Starsky","m","Célibataire","1955-07-08",68,4,"Personnel",{"$f":"VLOOKUP(H15,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1920]
["Lalalalalalala","Hutch","m","Divorcé(e)","1952-10-07",71,4,"Direction",{"$f":"VLOOKUP(H16,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":2500},3000,null,null,null,"f","m"]
["Cléssoulaporte","Djamila","f","Marié(e)","1959-09-07",64,4,"Personnel",{"$f":"VLOOKUP(H17,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1920,null,null,"Célibataire",{"$f":"COUNTIFS($C$7:$C$28,N$16,$D$7:$D$28,$M17)","v":1},7]
["Noux","Marion","f","Divorcé(e)","1978-12-30",44,2,"Secrétariat",{"$f":"VLOOKUP(H18,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1700},1870,null,null,"Divorcé(e)",2,4]
["Ouzi","Jacques","m","Célibataire","1969-02-28",54,3,"Personnel",{"$f":"VLOOKUP(H19,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1840,null,null,"Marié(e)",2,6]
["Stiké","Sophie","f","Divorcé(e)","1959-04-04",64,4,"Secrétariat",{"$f":"VLOOKUP(H20,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1700},2040]
["Tare","Guy","m","Divorcé(e)","1960-08-07",63,4,"Informatique",{"$f":"VLOOKUP(H21,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},2280,null,null,"Salaire moyen par sexe et état civil"]
["Vaisselle","Aude","f","Marié(e)","1966-06-06",57,4,"Secrétariat",{"$f":"VLOOKUP(H22,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1700},2040]
["Zetofrais","Mélanie","f","Célibataire","1978-11-25",44,2,"Direction",{"$f":"VLOOKUP(H23,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":2500},2750,null,null,null,"f","m"]
["Touille","Sasha","m","Célibataire","1982-10-30",40,2,"Personnel",{"$f":"VLOOKUP(H24,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1760,null,null,"Célibataire",{"$f":"AVERAGEIFS($J$7:$J$28,$C$7:$C$28,N$23,$D$7:$D$28,$M24)","v":2750},{"$f":"AVERAGEIFS($J$7:$J$28,$C$7:$C$28,O$23,$D$7:$D$28,$M24)","v":1952.1428571428571}]
["Proviste","Alain","m","Marié(e)","1959-09-09",64,4,"Personnel",{"$f":"VLOOKUP(H25,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1920,null,null,"Divorcé(e)",{"$f":"AVERAGEIFS($J$7:$J$28,$C$7:$C$28,N$23,$D$7:$D$28,$M25)","v":1955},2370]
["Peulaporte","Firmin","m","Divorcé(e)","1965-07-01",58,4,"Informatique",{"$f":"VLOOKUP(H26,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},2280,null,null,"Marié(e)",1980,2120]
["Unetitlaine","Jérémy","m","Marié(e)","1983-06-09",40,2,"Informatique",{"$f":"VLOOKUP(H27,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},2090]
["Ouzi","Jacques","m","Célibataire","1969-02-28",54,3,"Personnel",{"$f":"VLOOKUP(H28,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1840]

{"sheet":"Sous-Totaux1","index":39,"n_rows":28,"n_cols":13,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
["Sous-Totaux",null,null,null,null,null,null,null,null,null,null,null,"Retour sommaire"]
[]
["Utilisez les sous-totaux de façon à afficher le nombre d'employés par service."]
[]
[]
["Nom","Prénom","Sexe","Etat civil","Date de naissance","Age","Tranches","Services","Salaires Minimum","Salaires"]
["Bijoba","Jo","m","Marié(e)","1980-03-15",{"$f":"DATEDIF(E7,TODAY(),\"y\")","v":43},{"$f":"IF(F7<25,0,IF(F7<35,1,IF(F7<45,2,IF(F7<55,3,4))))","v":2},"Direction",{"$f":"VLOOKUP(H7,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":2500},{"$f":"I7+5%*G7*I7","v":2750}]
["Bistrot","Alonso","m","Marié(e)","1966-01-17",57,4,"Informatique",{"$f":"VLOOKUP(H8,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},2280]
["Cléssoulaporte","Djamila","f","Marié(e)","1959-09-07",64,4,"Personnel",{"$f":"VLOOKUP(H9,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1920]
["Covert","Harry","m","Divorcé(e)","1942-02-10",81,4,"Personnel",{"$f":"VLOOKUP(H10,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1920]
["Culaire","Laury","m","Marié(e)","1965-05-05",58,4,"Personnel",{"$f":"VLOOKUP(H11,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1920]
["Deuf","John","m","Célibataire","1963-09-08",60,4,"Informatique",{"$f":"VLOOKUP(H12,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},2280]
["Foupasune","Jean","m","Célibataire","1975-08-07",48,3,"Personnel",{"$f":"VLOOKUP(H13,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1840]
["Lairbon","Oussama","m","Marié(e)","1983-02-08",40,2,"Personnel",{"$f":"VLOOKUP(H14,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1760]
["Lalalalalalala","Hutch","m","Divorcé(e)","1952-10-07",71,4,"Direction",{"$f":"VLOOKUP(H15,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":2500},3000]
["Lalalalalalala","Starsky","m","Célibataire","1955-07-08",68,4,"Personnel",{"$f":"VLOOKUP(H16,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1920]
["Menvussa","Gérard","m","Célibataire","1970-12-04",52,3,"Informatique",{"$f":"VLOOKUP(H17,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},2185]
["Noux","Marion","f","Divorcé(e)","1978-12-30",44,2,"Secrétariat",{"$f":"VLOOKUP(H18,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1700},1870]
["Ouzi","Jacques","m","Célibataire","1969-02-28",54,3,"Personnel",{"$f":"VLOOKUP(H19,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1840]
["Ouzi","Jacques","m","Célibataire","1969-02-28",54,3,"Personnel",{"$f":"VLOOKUP(H20,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1840]
["Peulaporte","Firmin","m","Divorcé(e)","1965-07-01",58,4,"Informatique",{"$f":"VLOOKUP(H21,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},2280]
["Proviste","Alain","m","Marié(e)","1959-09-09",64,4,"Personnel",{"$f":"VLOOKUP(H22,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1920]
["Stiké","Sophie","f","Divorcé(e)","1959-04-04",64,4,"Secrétariat",{"$f":"VLOOKUP(H23,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1700},2040]
["Tare","Guy","m","Divorcé(e)","1960-08-07",63,4,"Informatique",{"$f":"VLOOKUP(H24,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},2280]
["Touille","Sasha","m","Célibataire","1982-10-30",40,2,"Personnel",{"$f":"VLOOKUP(H25,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1760]
["Unetitlaine","Jérémy","m","Marié(e)","1983-06-09",40,2,"Informatique",{"$f":"VLOOKUP(H26,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},2090]
["Vaisselle","Aude","f","Marié(e)","1966-06-06",57,4,"Secrétariat",{"$f":"VLOOKUP(H27,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1700},2040]
["Zetofrais","Mélanie","f","Célibataire","1978-11-25",44,2,"Direction",{"$f":"VLOOKUP(H28,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":2500},2750]

{"sheet":"Sous-Totaux1_corrigé","index":40,"n_rows":33,"n_cols":10,"rows_kept":33,"cut":false,"hidden":true,"merged":[]}
["Sous-Totaux"]
[]
["Utilisez les sous-totaux de façon à afficher le nombre d'employés par service."]
[]
[]
["Nom","Prénom","Sexe","Etat civil","Date de naissance","Age","Tranches","Services","Salaires Minimum","Salaires"]
["Bijoba","Jo","m","Marié(e)","1980-03-15",{"$f":"DATEDIF(E7,TODAY(),\"y\")","v":43},{"$f":"IF(F7<25,0,IF(F7<35,1,IF(F7<45,2,IF(F7<55,3,4))))","v":2},"Direction",{"$f":"VLOOKUP(H7,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":2500},{"$f":"I7+5%*G7*I7","v":2750}]
["Lalalalalalala","Hutch","m","Divorcé(e)","1952-10-07",{"$f":"DATEDIF(E8,TODAY(),\"y\")","v":71},{"$f":"IF(F8<25,0,IF(F8<35,1,IF(F8<45,2,IF(F8<55,3,4))))","v":4},"Direction",{"$f":"VLOOKUP(H8,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":2500},{"$f":"I8+5%*G8*I8","v":3000}]
["Zetofrais","Mélanie","f","Célibataire","1978-11-25",{"$f":"DATEDIF(E9,TODAY(),\"y\")","v":44},{"$f":"IF(F9<25,0,IF(F9<35,1,IF(F9<45,2,IF(F9<55,3,4))))","v":2},"Direction",{"$f":"VLOOKUP(H9,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":2500},{"$f":"I9+5%*G9*I9","v":2750}]
[{"$f":"SUBTOTAL(3,A7:A9)","v":3},null,null,null,null,null,null,"Nombre Direction"]
["Bistrot","Alonso","m","Marié(e)","1966-01-17",{"$f":"DATEDIF(E11,TODAY(),\"y\")","v":57},{"$f":"IF(F11<25,0,IF(F11<35,1,IF(F11<45,2,IF(F11<55,3,4))))","v":4},"Informatique",{"$f":"VLOOKUP(H11,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},{"$f":"I11+5%*G11*I11","v":2280}]
["Deuf","John","m","Célibataire","1963-09-08",60,4,"Informatique",{"$f":"VLOOKUP(H12,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},2280]
["Menvussa","Gérard","m","Célibataire","1970-12-04",52,3,"Informatique",{"$f":"VLOOKUP(H13,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},2185]
["Peulaporte","Firmin","m","Divorcé(e)","1965-07-01",58,4,"Informatique",{"$f":"VLOOKUP(H14,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},2280]
["Tare","Guy","m","Divorcé(e)","1960-08-07",63,4,"Informatique",{"$f":"VLOOKUP(H15,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},2280]
["Unetitlaine","Jérémy","m","Marié(e)","1983-06-09",40,2,"Informatique",{"$f":"VLOOKUP(H16,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},2090]
[{"$f":"SUBTOTAL(3,A11:A16)","v":6},null,null,null,null,null,null,"Nombre Informatique"]
["Cléssoulaporte","Djamila","f","Marié(e)","1959-09-07",{"$f":"DATEDIF(E18,TODAY(),\"y\")","v":64},{"$f":"IF(F18<25,0,IF(F18<35,1,IF(F18<45,2,IF(F18<55,3,4))))","v":4},"Personnel",{"$f":"VLOOKUP(H18,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},{"$f":"I18+5%*G18*I18","v":1920}]
["Covert","Harry","m","Divorcé(e)","1942-02-10",81,4,"Personnel",{"$f":"VLOOKUP(H19,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1920]
["Culaire","Laury","m","Marié(e)","1965-05-05",58,4,"Personnel",{"$f":"VLOOKUP(H20,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1920]
["Foupasune","Jean","m","Célibataire","1975-08-07",48,3,"Personnel",{"$f":"VLOOKUP(H21,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1840]
["Lairbon","Oussama","m","Marié(e)","1983-02-08",40,2,"Personnel",{"$f":"VLOOKUP(H22,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1760]
["Lalalalalalala","Starsky","m","Célibataire","1955-07-08",68,4,"Personnel",{"$f":"VLOOKUP(H23,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1920]
["Ouzi","Jacques","m","Célibataire","1969-02-28",54,3,"Personnel",{"$f":"VLOOKUP(H24,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1840]
["Ouzi","Jacques","m","Célibataire","1969-02-28",54,3,"Personnel",{"$f":"VLOOKUP(H25,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1840]
["Proviste","Alain","m","Marié(e)","1959-09-09",64,4,"Personnel",{"$f":"VLOOKUP(H26,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1920]
["Touille","Sasha","m","Célibataire","1982-10-30",40,2,"Personnel",{"$f":"VLOOKUP(H27,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1760]
[{"$f":"SUBTOTAL(3,A18:A27)","v":10},null,null,null,null,null,null,"Nombre Personnel"]
["Noux","Marion","f","Divorcé(e)","1978-12-30",{"$f":"DATEDIF(E29,TODAY(),\"y\")","v":44},{"$f":"IF(F29<25,0,IF(F29<35,1,IF(F29<45,2,IF(F29<55,3,4))))","v":2},"Secrétariat",{"$f":"VLOOKUP(H29,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1700},{"$f":"I29+5%*G29*I29","v":1870}]
["Stiké","Sophie","f","Divorcé(e)","1959-04-04",{"$f":"DATEDIF(E30,TODAY(),\"y\")","v":64},{"$f":"IF(F30<25,0,IF(F30<35,1,IF(F30<45,2,IF(F30<55,3,4))))","v":4},"Secrétariat",{"$f":"VLOOKUP(H30,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1700},{"$f":"I30+5%*G30*I30","v":2040}]
["Vaisselle","Aude","f","Marié(e)","1966-06-06",{"$f":"DATEDIF(E31,TODAY(),\"y\")","v":57},{"$f":"IF(F31<25,0,IF(F31<35,1,IF(F31<45,2,IF(F31<55,3,4))))","v":4},"Secrétariat",{"$f":"VLOOKUP(H31,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1700},{"$f":"I31+5%*G31*I31","v":2040}]
[{"$f":"SUBTOTAL(3,A29:A31)","v":3},null,null,null,null,null,null,"Nombre Secrétariat"]
[{"$f":"SUBTOTAL(3,A7:A31)","v":22},null,null,null,null,null,null,"Nbval"]

{"sheet":"Sous-Totaux2","index":41,"n_rows":28,"n_cols":13,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
["Sous-Totaux",null,null,null,null,null,null,null,null,null,null,null,"Retour sommaire"]
[]
["Utilisez les sous-totaux de façon à afficher le salaire moyen par service et par sexe."]
[]
[]
["Nom","Prénom","Sexe","Etat civil","Date de naissance","Age","Tranches","Services","Salaires Minimum","Salaires"]
["Bistrot","Alonso","m","Marié(e)","1966-01-17",{"$f":"DATEDIF(E7,TODAY(),\"y\")","v":57},{"$f":"IF(F7<25,0,IF(F7<35,1,IF(F7<45,2,IF(F7<55,3,4))))","v":4},"Informatique",{"$f":"VLOOKUP(H7,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},{"$f":"I7+5%*G7*I7","v":2280}]
["Bijoba","Jo","m","Marié(e)","1980-03-15",43,2,"Direction",{"$f":"VLOOKUP(H8,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":2500},2750]
["Covert","Harry","m","Divorcé(e)","1942-02-10",81,4,"Personnel",{"$f":"VLOOKUP(H9,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1920]
["Culaire","Laury","m","Marié(e)","1965-05-05",58,4,"Personnel",{"$f":"VLOOKUP(H10,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1920]
["Deuf","John","m","Célibataire","1963-09-08",60,4,"Informatique",{"$f":"VLOOKUP(H11,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},2280]
["Foupasune","Jean","m","Célibataire","1975-08-07",48,3,"Personnel",{"$f":"VLOOKUP(H12,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1840]
["Lairbon","Oussama","m","Marié(e)","1983-02-08",40,2,"Personnel",{"$f":"VLOOKUP(H13,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1760]
["Menvussa","Gérard","m","Célibataire","1970-12-04",52,3,"Informatique",{"$f":"VLOOKUP(H14,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},2185]
["Lalalalalalala","Starsky","m","Célibataire","1955-07-08",68,4,"Personnel",{"$f":"VLOOKUP(H15,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1920]
["Lalalalalalala","Hutch","m","Divorcé(e)","1952-10-07",71,4,"Direction",{"$f":"VLOOKUP(H16,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":2500},3000]
["Cléssoulaporte","Djamila","f","Marié(e)","1959-09-07",64,4,"Personnel",{"$f":"VLOOKUP(H17,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1920]
["Noux","Marion","f","Divorcé(e)","1978-12-30",44,2,"Secrétariat",{"$f":"VLOOKUP(H18,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1700},1870]
["Ouzi","Jacques","m","Célibataire","1969-02-28",54,3,"Personnel",{"$f":"VLOOKUP(H19,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1840]
["Stiké","Sophie","f","Divorcé(e)","1959-04-04",64,4,"Secrétariat",{"$f":"VLOOKUP(H20,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1700},2040]
["Tare","Guy","m","Divorcé(e)","1960-08-07",63,4,"Informatique",{"$f":"VLOOKUP(H21,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},2280]
["Vaisselle","Aude","f","Marié(e)","1966-06-06",57,4,"Secrétariat",{"$f":"VLOOKUP(H22,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1700},2040]
["Zetofrais","Mélanie","f","Célibataire","1978-11-25",44,2,"Direction",{"$f":"VLOOKUP(H23,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":2500},2750]
["Touille","Sasha","m","Célibataire","1982-10-30",40,2,"Personnel",{"$f":"VLOOKUP(H24,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1760]
["Proviste","Alain","m","Marié(e)","1959-09-09",64,4,"Personnel",{"$f":"VLOOKUP(H25,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1920]
["Peulaporte","Firmin","m","Divorcé(e)","1965-07-01",58,4,"Informatique",{"$f":"VLOOKUP(H26,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},2280]
["Unetitlaine","Jérémy","m","Marié(e)","1983-06-09",40,2,"Informatique",{"$f":"VLOOKUP(H27,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},2090]
["Ouzi","Jacques","m","Célibataire","1969-02-28",54,3,"Personnel",{"$f":"VLOOKUP(H28,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1840]

{"sheet":"Sous-Totaux2_corrigé","index":42,"n_rows":39,"n_cols":10,"rows_kept":39,"cut":false,"hidden":true,"merged":[]}
["Sous-Totaux"]
[]
["Utilisez les sous-totaux de façon à afficher le salaire moyen par service et par sexe."]
[]
[]
["Nom","Prénom","Sexe","Etat civil","Date de naissance","Age","Tranches","Services","Salaires Minimum","Salaires"]
["Zetofrais","Mélanie","f","Célibataire","1978-11-25",{"$f":"DATEDIF(E7,TODAY(),\"y\")","v":44},{"$f":"IF(F7<25,0,IF(F7<35,1,IF(F7<45,2,IF(F7<55,3,4))))","v":2},"Direction",{"$f":"VLOOKUP(H7,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":2500},{"$f":"I7+5%*G7*I7","v":2750}]
[null,null,"Moyenne f",null,null,null,null,null,null,{"$f":"SUBTOTAL(1,J7:J7)","v":2750}]
["Bijoba","Jo","m","Marié(e)","1980-03-15",{"$f":"DATEDIF(E9,TODAY(),\"y\")","v":43},{"$f":"IF(F9<25,0,IF(F9<35,1,IF(F9<45,2,IF(F9<55,3,4))))","v":2},"Direction",{"$f":"VLOOKUP(H9,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":2500},{"$f":"I9+5%*G9*I9","v":2750}]
["Lalalalalalala","Hutch","m","Divorcé(e)","1952-10-07",{"$f":"DATEDIF(E10,TODAY(),\"y\")","v":71},{"$f":"IF(F10<25,0,IF(F10<35,1,IF(F10<45,2,IF(F10<55,3,4))))","v":4},"Direction",{"$f":"VLOOKUP(H10,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":2500},{"$f":"I10+5%*G10*I10","v":3000}]
[null,null,"Moyenne m",null,null,null,null,null,null,{"$f":"SUBTOTAL(1,J9:J10)","v":2875}]
[null,null,null,null,null,null,null,"Moyenne Direction",null,{"$f":"SUBTOTAL(1,J7:J10)","v":2833.3333333333335}]
["Bistrot","Alonso","m","Marié(e)","1966-01-17",{"$f":"DATEDIF(E13,TODAY(),\"y\")","v":57},{"$f":"IF(F13<25,0,IF(F13<35,1,IF(F13<45,2,IF(F13<55,3,4))))","v":4},"Informatique",{"$f":"VLOOKUP(H13,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},{"$f":"I13+5%*G13*I13","v":2280}]
["Deuf","John","m","Célibataire","1963-09-08",60,4,"Informatique",{"$f":"VLOOKUP(H14,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},2280]
["Menvussa","Gérard","m","Célibataire","1970-12-04",52,3,"Informatique",{"$f":"VLOOKUP(H15,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},2185]
["Tare","Guy","m","Divorcé(e)","1960-08-07",63,4,"Informatique",{"$f":"VLOOKUP(H16,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},2280]
["Peulaporte","Firmin","m","Divorcé(e)","1965-07-01",58,4,"Informatique",{"$f":"VLOOKUP(H17,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},2280]
["Unetitlaine","Jérémy","m","Marié(e)","1983-06-09",40,2,"Informatique",{"$f":"VLOOKUP(H18,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},2090]
[null,null,null,null,null,null,null,"Moyenne Informatique",null,{"$f":"SUBTOTAL(1,J13:J18)","v":2232.5}]
[null,null,"Moyenne m",null,null,null,null,null,null,{"$f":"SUBTOTAL(1,J13:J18)","v":2232.5}]
["Cléssoulaporte","Djamila","f","Marié(e)","1959-09-07",{"$f":"DATEDIF(E21,TODAY(),\"y\")","v":64},{"$f":"IF(F21<25,0,IF(F21<35,1,IF(F21<45,2,IF(F21<55,3,4))))","v":4},"Personnel",{"$f":"VLOOKUP(H21,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},{"$f":"I21+5%*G21*I21","v":1920}]
[null,null,"Moyenne f",null,null,null,null,null,null,{"$f":"SUBTOTAL(1,J21:J21)","v":1920}]
["Covert","Harry","m","Divorcé(e)","1942-02-10",{"$f":"DATEDIF(E23,TODAY(),\"y\")","v":81},{"$f":"IF(F23<25,0,IF(F23<35,1,IF(F23<45,2,IF(F23<55,3,4))))","v":4},"Personnel",{"$f":"VLOOKUP(H23,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},{"$f":"I23+5%*G23*I23","v":1920}]
["Culaire","Laury","m","Marié(e)","1965-05-05",58,4,"Personnel",{"$f":"VLOOKUP(H24,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1920]
["Foupasune","Jean","m","Célibataire","1975-08-07",48,3,"Personnel",{"$f":"VLOOKUP(H25,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1840]
["Lairbon","Oussama","m","Marié(e)","1983-02-08",40,2,"Personnel",{"$f":"VLOOKUP(H26,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1760]
["Lalalalalalala","Starsky","m","Célibataire","1955-07-08",68,4,"Personnel",{"$f":"VLOOKUP(H27,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1920]
["Ouzi","Jacques","m","Célibataire","1969-02-28",54,3,"Personnel",{"$f":"VLOOKUP(H28,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1840]
["Touille","Sasha","m","Célibataire","1982-10-30",40,2,"Personnel",{"$f":"VLOOKUP(H29,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1760]
["Proviste","Alain","m","Marié(e)","1959-09-09",64,4,"Personnel",{"$f":"VLOOKUP(H30,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1920]
["Ouzi","Jacques","m","Célibataire","1969-02-28",54,3,"Personnel",{"$f":"VLOOKUP(H31,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1840]
[null,null,null,null,null,null,null,"Moyenne Personnel",null,{"$f":"SUBTOTAL(1,J21:J31)","v":1864}]
[null,null,"Moyenne m",null,null,null,null,null,null,{"$f":"SUBTOTAL(1,J23:J31)","v":1857.7777777777778}]
["Noux","Marion","f","Divorcé(e)","1978-12-30",{"$f":"DATEDIF(E34,TODAY(),\"y\")","v":44},{"$f":"IF(F34<25,0,IF(F34<35,1,IF(F34<45,2,IF(F34<55,3,4))))","v":2},"Secrétariat",{"$f":"VLOOKUP(H34,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1700},{"$f":"I34+5%*G34*I34","v":1870}]
["Stiké","Sophie","f","Divorcé(e)","1959-04-04",{"$f":"DATEDIF(E35,TODAY(),\"y\")","v":64},{"$f":"IF(F35<25,0,IF(F35<35,1,IF(F35<45,2,IF(F35<55,3,4))))","v":4},"Secrétariat",{"$f":"VLOOKUP(H35,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1700},{"$f":"I35+5%*G35*I35","v":2040}]
["Vaisselle","Aude","f","Marié(e)","1966-06-06",{"$f":"DATEDIF(E36,TODAY(),\"y\")","v":57},{"$f":"IF(F36<25,0,IF(F36<35,1,IF(F36<45,2,IF(F36<55,3,4))))","v":4},"Secrétariat",{"$f":"VLOOKUP(H36,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1700},{"$f":"I36+5%*G36*I36","v":2040}]
[null,null,null,null,null,null,null,"Moyenne Secrétariat",null,{"$f":"SUBTOTAL(1,J34:J36)","v":1983.3333333333333}]
[null,null,"Moyenne f",null,null,null,null,null,null,{"$f":"SUBTOTAL(1,J34:J36)","v":1983.3333333333333}]
[null,null,null,null,null,null,null,"Moyenne",null,{"$f":"SUBTOTAL(1,J7:J36)","v":2112.9545454545455}]

{"sheet":"Sous-Totaux3","index":43,"n_rows":28,"n_cols":13,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
["Sous-Totaux",null,null,null,null,null,null,null,null,null,null,null,"Retour sommaire"]
[]
["Utilisez les sous-totaux de façon à afficher le nombre d'employés et la moyenne des âges par sexe et par état civil."]
[]
[]
["Nom","Prénom","Sexe","Etat civil","Date de naissance","Age","Tranches","Services","Salaires Minimum","Salaires"]
["Bistrot","Alonso","m","Marié(e)","1966-01-17",{"$f":"DATEDIF(E7,TODAY(),\"y\")","v":57},{"$f":"IF(F7<25,0,IF(F7<35,1,IF(F7<45,2,IF(F7<55,3,4))))","v":4},"Informatique",{"$f":"VLOOKUP(H7,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},{"$f":"I7+5%*G7*I7","v":2280}]
["Bijoba","Jo","m","Marié(e)","1980-03-15",43,2,"Direction",{"$f":"VLOOKUP(H8,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":2500},2750]
["Covert","Harry","m","Divorcé(e)","1942-02-10",81,4,"Personnel",{"$f":"VLOOKUP(H9,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1920]
["Culaire","Laury","m","Marié(e)","1965-05-05",58,4,"Personnel",{"$f":"VLOOKUP(H10,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1920]
["Deuf","John","m","Célibataire","1963-09-08",60,4,"Informatique",{"$f":"VLOOKUP(H11,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},2280]
["Foupasune","Jean","m","Célibataire","1975-08-07",48,3,"Personnel",{"$f":"VLOOKUP(H12,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1840]
["Lairbon","Oussama","m","Marié(e)","1983-02-08",40,2,"Personnel",{"$f":"VLOOKUP(H13,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1760]
["Menvussa","Gérard","m","Célibataire","1970-12-04",52,3,"Informatique",{"$f":"VLOOKUP(H14,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},2185]
["Lalalalalalala","Starsky","m","Célibataire","1955-07-08",68,4,"Personnel",{"$f":"VLOOKUP(H15,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1920]
["Lalalalalalala","Hutch","m","Divorcé(e)","1952-10-07",71,4,"Direction",{"$f":"VLOOKUP(H16,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":2500},3000]
["Cléssoulaporte","Djamila","f","Marié(e)","1959-09-07",64,4,"Personnel",{"$f":"VLOOKUP(H17,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1920]
["Noux","Marion","f","Divorcé(e)","1978-12-30",44,2,"Secrétariat",{"$f":"VLOOKUP(H18,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1700},1870]
["Ouzi","Jacques","m","Célibataire","1969-02-28",54,3,"Personnel",{"$f":"VLOOKUP(H19,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1840]
["Stiké","Sophie","f","Divorcé(e)","1959-04-04",64,4,"Secrétariat",{"$f":"VLOOKUP(H20,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1700},2040]
["Tare","Guy","m","Divorcé(e)","1960-08-07",63,4,"Informatique",{"$f":"VLOOKUP(H21,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},2280]
["Vaisselle","Aude","f","Marié(e)","1966-06-06",57,4,"Secrétariat",{"$f":"VLOOKUP(H22,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1700},2040]
["Zetofrais","Mélanie","f","Célibataire","1978-11-25",44,2,"Direction",{"$f":"VLOOKUP(H23,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":2500},2750]
["Touille","Sasha","m","Célibataire","1982-10-30",40,2,"Personnel",{"$f":"VLOOKUP(H24,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1760]
["Proviste","Alain","m","Marié(e)","1959-09-09",64,4,"Personnel",{"$f":"VLOOKUP(H25,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1920]
["Peulaporte","Firmin","m","Divorcé(e)","1965-07-01",58,4,"Informatique",{"$f":"VLOOKUP(H26,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},2280]
["Unetitlaine","Jérémy","m","Marié(e)","1983-06-09",40,2,"Informatique",{"$f":"VLOOKUP(H27,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},2090]
["Ouzi","Jacques","m","Célibataire","1969-02-28",54,3,"Personnel",{"$f":"VLOOKUP(H28,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1840]

{"sheet":"Sous-Totaux3_corrigé","index":44,"n_rows":49,"n_cols":10,"rows_kept":49,"cut":false,"hidden":true,"merged":[]}
["Sous-Totaux"]
[]
["Utilisez les sous-totaux de façon à afficher le nombre d'employés et la moyenne des âges par sexe et par état civil."]
[]
[]
["Nom","Prénom","Sexe","Etat civil","Date de naissance","Age","Tranches","Services","Salaires Minimum","Salaires"]
["Zetofrais","Mélanie","f","Célibataire","1978-11-25",{"$f":"DATEDIF(E7,TODAY(),\"y\")","v":44},{"$f":"IF(F7<25,0,IF(F7<35,1,IF(F7<45,2,IF(F7<55,3,4))))","v":2},"Direction",{"$f":"VLOOKUP(H7,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":2500},{"$f":"I7+5%*G7*I7","v":2750}]
[{"$f":"SUBTOTAL(3,A7:A7)","v":1},null,null,"Nombre Célibataire"]
[null,null,null,"Moyenne Célibataire",null,{"$f":"SUBTOTAL(1,F7:F7)","v":44}]
["Noux","Marion","f","Divorcé(e)","1978-12-30",{"$f":"DATEDIF(E10,TODAY(),\"y\")","v":44},{"$f":"IF(F10<25,0,IF(F10<35,1,IF(F10<45,2,IF(F10<55,3,4))))","v":2},"Secrétariat",{"$f":"VLOOKUP(H10,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1700},{"$f":"I10+5%*G10*I10","v":1870}]
["Stiké","Sophie","f","Divorcé(e)","1959-04-04",{"$f":"DATEDIF(E11,TODAY(),\"y\")","v":64},{"$f":"IF(F11<25,0,IF(F11<35,1,IF(F11<45,2,IF(F11<55,3,4))))","v":4},"Secrétariat",{"$f":"VLOOKUP(H11,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1700},{"$f":"I11+5%*G11*I11","v":2040}]
[{"$f":"SUBTOTAL(3,A10:A11)","v":2},null,null,"Nombre Divorcé(e)"]
[null,null,null,"Moyenne Divorcé(e)",null,{"$f":"SUBTOTAL(1,F10:F11)","v":54}]
["Cléssoulaporte","Djamila","f","Marié(e)","1959-09-07",{"$f":"DATEDIF(E14,TODAY(),\"y\")","v":64},{"$f":"IF(F14<25,0,IF(F14<35,1,IF(F14<45,2,IF(F14<55,3,4))))","v":4},"Personnel",{"$f":"VLOOKUP(H14,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},{"$f":"I14+5%*G14*I14","v":1920}]
["Vaisselle","Aude","f","Marié(e)","1966-06-06",{"$f":"DATEDIF(E15,TODAY(),\"y\")","v":57},{"$f":"IF(F15<25,0,IF(F15<35,1,IF(F15<45,2,IF(F15<55,3,4))))","v":4},"Secrétariat",{"$f":"VLOOKUP(H15,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1700},{"$f":"I15+5%*G15*I15","v":2040}]
[{"$f":"SUBTOTAL(3,A14:A15)","v":2},null,null,"Nombre Marié(e)"]
[null,null,null,"Moyenne Marié(e)",null,{"$f":"SUBTOTAL(1,F14:F15)","v":60.5}]
[null,null,"Moyenne f",null,null,{"$f":"SUBTOTAL(1,F7:F15)","v":54.6}]
[{"$f":"SUBTOTAL(3,A7:A15)","v":5},null,"Nombre f"]
["Deuf","John","m","Célibataire","1963-09-08",{"$f":"DATEDIF(E20,TODAY(),\"y\")","v":60},{"$f":"IF(F20<25,0,IF(F20<35,1,IF(F20<45,2,IF(F20<55,3,4))))","v":4},"Informatique",{"$f":"VLOOKUP(H20,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},{"$f":"I20+5%*G20*I20","v":2280}]
["Foupasune","Jean","m","Célibataire","1975-08-07",48,3,"Personnel",{"$f":"VLOOKUP(H21,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1840]
["Menvussa","Gérard","m","Célibataire","1970-12-04",52,3,"Informatique",{"$f":"VLOOKUP(H22,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},2185]
["Lalalalalalala","Starsky","m","Célibataire","1955-07-08",68,4,"Personnel",{"$f":"VLOOKUP(H23,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1920]
["Ouzi","Jacques","m","Célibataire","1969-02-28",54,3,"Personnel",{"$f":"VLOOKUP(H24,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1840]
["Touille","Sasha","m","Célibataire","1982-10-30",40,2,"Personnel",{"$f":"VLOOKUP(H25,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1760]
["Ouzi","Jacques","m","Célibataire","1969-02-28",54,3,"Personnel",{"$f":"VLOOKUP(H26,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1840]
[{"$f":"SUBTOTAL(3,A20:A26)","v":7},null,null,"Nombre Célibataire"]
[null,null,null,"Moyenne Célibataire",null,{"$f":"SUBTOTAL(1,F20:F26)","v":53.714285714285715}]
["Covert","Harry","m","Divorcé(e)","1942-02-10",{"$f":"DATEDIF(E29,TODAY(),\"y\")","v":81},{"$f":"IF(F29<25,0,IF(F29<35,1,IF(F29<45,2,IF(F29<55,3,4))))","v":4},"Personnel",{"$f":"VLOOKUP(H29,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},{"$f":"I29+5%*G29*I29","v":1920}]
["Lalalalalalala","Hutch","m","Divorcé(e)","1952-10-07",{"$f":"DATEDIF(E30,TODAY(),\"y\")","v":71},{"$f":"IF(F30<25,0,IF(F30<35,1,IF(F30<45,2,IF(F30<55,3,4))))","v":4},"Direction",{"$f":"VLOOKUP(H30,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":2500},{"$f":"I30+5%*G30*I30","v":3000}]
["Tare","Guy","m","Divorcé(e)","1960-08-07",{"$f":"DATEDIF(E31,TODAY(),\"y\")","v":63},{"$f":"IF(F31<25,0,IF(F31<35,1,IF(F31<45,2,IF(F31<55,3,4))))","v":4},"Informatique",{"$f":"VLOOKUP(H31,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},{"$f":"I31+5%*G31*I31","v":2280}]
["Peulaporte","Firmin","m","Divorcé(e)","1965-07-01",{"$f":"DATEDIF(E32,TODAY(),\"y\")","v":58},{"$f":"IF(F32<25,0,IF(F32<35,1,IF(F32<45,2,IF(F32<55,3,4))))","v":4},"Informatique",{"$f":"VLOOKUP(H32,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},{"$f":"I32+5%*G32*I32","v":2280}]
[{"$f":"SUBTOTAL(3,A29:A32)","v":4},null,null,"Nombre Divorcé(e)"]
[null,null,null,"Moyenne Divorcé(e)",null,{"$f":"SUBTOTAL(1,F29:F32)","v":68.25}]
["Bistrot","Alonso","m","Marié(e)","1966-01-17",{"$f":"DATEDIF(E35,TODAY(),\"y\")","v":57},{"$f":"IF(F35<25,0,IF(F35<35,1,IF(F35<45,2,IF(F35<55,3,4))))","v":4},"Informatique",{"$f":"VLOOKUP(H35,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},{"$f":"I35+5%*G35*I35","v":2280}]
["Bijoba","Jo","m","Marié(e)","1980-03-15",43,2,"Direction",{"$f":"VLOOKUP(H36,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":2500},2750]
["Culaire","Laury","m","Marié(e)","1965-05-05",58,4,"Personnel",{"$f":"VLOOKUP(H37,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1920]
["Lairbon","Oussama","m","Marié(e)","1983-02-08",40,2,"Personnel",{"$f":"VLOOKUP(H38,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1760]
["Proviste","Alain","m","Marié(e)","1959-09-09",64,4,"Personnel",{"$f":"VLOOKUP(H39,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1920]
["Unetitlaine","Jérémy","m","Marié(e)","1983-06-09",40,2,"Informatique",{"$f":"VLOOKUP(H40,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},2090]
[{"$f":"SUBTOTAL(3,A35:A40)","v":6},null,null,"Nombre Marié(e)"]
[null,null,null,"Moyenne Marié(e)",null,{"$f":"SUBTOTAL(1,F35:F40)","v":50.333333333333336}]
[null,null,"Moyenne m",null,null,{"$f":"SUBTOTAL(1,F20:F40)","v":55.941176470588232}]
[{"$f":"SUBTOTAL(3,A20:A40)","v":17},null,"Nombre m"]
[null,null,null,"Nbval"]
[null,null,"Moyenne",null,null,{"$f":"SUBTOTAL(1,F7:F40)","v":55.636363636363633}]
[null,null,null,"Moyenne Nbval",null,{"$f":"SUBTOTAL(1,F45:F45)","v":{"$error":"#DIV/0!"}}]
[{"$f":"SUBTOTAL(3,A7:A40)","v":22},null,"Nbval"]
[null,null,null,"Moyenne",null,{"$f":"SUBTOTAL(1,F7:F45)","v":55.636363636363633}]

{"sheet":"Sous-Totaux4 (Fonctions)","index":45,"n_rows":34,"n_cols":13,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
["Sous-Totaux",null,null,null,null,null,null,null,null,null,null,null,"Retour sommaire"]
[]
["Utilisez la fonction sous-total de façon à afficher le nombre d'employés et la moyenne des âges des hommes célibataires"]
[]
[]
[null,"Avec les fonctions classiques :",null,null,"Avec nbval et moyenne + filtres :",null,null,"Avec la fonction sous-total + filtres :"]
[]
[null,"Nombre :",null,null,"Nombre :",null,null,"Nombre :"]
[null,"Âge moyen :",null,null,"Âge moyen :",null,null,"Âge moyen :"]
[]
[]
["Nom","Prénom","Sexe","Etat civil","Date de naissance","Age","Tranches","Services","Salaires Minimum","Salaires"]
["Bistrot","Alonso","m","Marié(e)","1966-01-17",{"$f":"DATEDIF(E13,TODAY(),\"y\")","v":57},{"$f":"IF(F13<25,0,IF(F13<35,1,IF(F13<45,2,IF(F13<55,3,4))))","v":4},"Informatique",{"$f":"VLOOKUP(H13,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},{"$f":"I13+5%*G13*I13","v":2280}]
["Bijoba","Jo","m","Marié(e)","1980-03-15",43,2,"Direction",{"$f":"VLOOKUP(H14,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":2500},2750]
["Covert","Harry","m","Divorcé(e)","1942-02-10",81,4,"Personnel",{"$f":"VLOOKUP(H15,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1920]
["Culaire","Laury","m","Marié(e)","1965-05-05",58,4,"Personnel",{"$f":"VLOOKUP(H16,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1920]
["Deuf","John","m","Célibataire","1963-09-08",60,4,"Informatique",{"$f":"VLOOKUP(H17,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},2280]
["Foupasune","Jean","m","Célibataire","1975-08-07",48,3,"Personnel",{"$f":"VLOOKUP(H18,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1840]
["Lairbon","Oussama","m","Marié(e)","1983-02-08",40,2,"Personnel",{"$f":"VLOOKUP(H19,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1760]
["Menvussa","Gérard","m","Célibataire","1970-12-04",52,3,"Informatique",{"$f":"VLOOKUP(H20,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},2185]
["Lalalalalalala","Starsky","m","Célibataire","1955-07-08",68,4,"Personnel",{"$f":"VLOOKUP(H21,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1920]
["Lalalalalalala","Hutch","m","Divorcé(e)","1952-10-07",71,4,"Direction",{"$f":"VLOOKUP(H22,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":2500},3000]
["Cléssoulaporte","Djamila","f","Marié(e)","1959-09-07",64,4,"Personnel",{"$f":"VLOOKUP(H23,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1920]
["Noux","Marion","f","Divorcé(e)","1978-12-30",44,2,"Secrétariat",{"$f":"VLOOKUP(H24,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1700},1870]
["Ouzi","Jacques","m","Célibataire","1969-02-28",54,3,"Personnel",{"$f":"VLOOKUP(H25,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1840]
["Stiké","Sophie","f","Divorcé(e)","1959-04-04",64,4,"Secrétariat",{"$f":"VLOOKUP(H26,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1700},2040]
["Tare","Guy","m","Divorcé(e)","1960-08-07",63,4,"Informatique",{"$f":"VLOOKUP(H27,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},2280]
["Vaisselle","Aude","f","Marié(e)","1966-06-06",57,4,"Secrétariat",{"$f":"VLOOKUP(H28,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1700},2040]
["Zetofrais","Mélanie","f","Célibataire","1978-11-25",44,2,"Direction",{"$f":"VLOOKUP(H29,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":2500},2750]
["Touille","Sasha","m","Célibataire","1982-10-30",40,2,"Personnel",{"$f":"VLOOKUP(H30,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1760]
["Proviste","Alain","m","Marié(e)","1959-09-09",64,4,"Personnel",{"$f":"VLOOKUP(H31,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1920]
["Peulaporte","Firmin","m","Divorcé(e)","1965-07-01",58,4,"Informatique",{"$f":"VLOOKUP(H32,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},2280]
["Unetitlaine","Jérémy","m","Marié(e)","1983-06-09",40,2,"Informatique",{"$f":"VLOOKUP(H33,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},2090]
["Ouzi","Jacques","m","Célibataire","1969-02-28",54,3,"Personnel",{"$f":"VLOOKUP(H34,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1840]

{"sheet":"Sous-Totaux4 (Fcts)_corrigé","index":46,"n_rows":36,"n_cols":13,"rows_kept":36,"cut":false,"hidden":true,"merged":[]}
["Sous-Totaux",null,null,null,null,null,null,null,null,null,null,null,"Retour sommaire"]
[]
["Utilisez la fonction sous-total de façon à afficher le nombre d'employés et la moyenne des âges des hommes célibataires"]
[]
[null,"NB.SI.ENS / COUNTIFS",null,null,"NBVAL / COUNTA",null,null,"SOUS.TOTAL / SUBTOTAL"]
[null,"MOYENNE.SI.ENS / AVERAGEIFS",null,null,"MOYENNE / AVERAGE"]
[]
[null,"Avec les fonctions classiques :",null,null,"Avec nbval et moyenne + filtres :",null,null,"Avec la fonction sous-total + filtres :"]
[]
[null,"Nombre :",{"$f":"COUNTIFS(Tableau27[Sexe],\"m\",Tableau27[Etat civil],\"Célibataire\")","v":7},null,"Nombre :",{"$f":"COUNTA(Tableau27[Sexe])","v":22},null,"Nombre :",{"$f":"SUBTOTAL(3,Tableau27[Sexe])","v":7}]
[null,"Âge moyen :",{"$f":"AVERAGEIFS(Tableau27[Age],Tableau27[Sexe],\"m\",Tableau27[Etat civil],\"célibataire\")","v":53.714285714285715},null,"Âge moyen :",{"$f":"AVERAGE(Tableau27[Age])","v":55.636363636363633},null,"Âge moyen :",{"$f":"SUBTOTAL(1,Tableau27[Age])","v":53.714285714285715}]
[]
[]
["Nom","Prénom","Sexe","Etat civil","Date de naissance","Age","Tranches","Services","Salaires Minimum","Salaires"]
["Bistrot","Alonso","m","Marié(e)","1966-01-17",{"$f":"DATEDIF(E15,TODAY(),\"y\")","v":57},{"$f":"IF(F15<25,0,IF(F15<35,1,IF(F15<45,2,IF(F15<55,3,4))))","v":4},"Informatique",{"$f":"VLOOKUP(H15,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},{"$f":"I15+5%*G15*I15","v":2280}]
["Bijoba","Jo","m","Marié(e)","1980-03-15",43,2,"Direction",{"$f":"VLOOKUP(H16,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":2500},2750]
["Covert","Harry","m","Divorcé(e)","1942-02-10",81,4,"Personnel",{"$f":"VLOOKUP(H17,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1920]
["Culaire","Laury","m","Marié(e)","1965-05-05",58,4,"Personnel",{"$f":"VLOOKUP(H18,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1920]
["Deuf","John","m","Célibataire","1963-09-08",60,4,"Informatique",{"$f":"VLOOKUP(H19,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},2280]
["Foupasune","Jean","m","Célibataire","1975-08-07",48,3,"Personnel",{"$f":"VLOOKUP(H20,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1840]
["Lairbon","Oussama","m","Marié(e)","1983-02-08",40,2,"Personnel",{"$f":"VLOOKUP(H21,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1760]
["Menvussa","Gérard","m","Célibataire","1970-12-04",52,3,"Informatique",{"$f":"VLOOKUP(H22,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},2185]
["Lalalalalalala","Starsky","m","Célibataire","1955-07-08",68,4,"Personnel",{"$f":"VLOOKUP(H23,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1920]
["Lalalalalalala","Hutch","m","Divorcé(e)","1952-10-07",71,4,"Direction",{"$f":"VLOOKUP(H24,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":2500},3000]
["Cléssoulaporte","Djamila","f","Marié(e)","1959-09-07",64,4,"Personnel",{"$f":"VLOOKUP(H25,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1920]
["Noux","Marion","f","Divorcé(e)","1978-12-30",44,2,"Secrétariat",{"$f":"VLOOKUP(H26,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1700},1870]
["Ouzi","Jacques","m","Célibataire","1969-02-28",54,3,"Personnel",{"$f":"VLOOKUP(H27,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1840]
["Stiké","Sophie","f","Divorcé(e)","1959-04-04",64,4,"Secrétariat",{"$f":"VLOOKUP(H28,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1700},2040]
["Tare","Guy","m","Divorcé(e)","1960-08-07",63,4,"Informatique",{"$f":"VLOOKUP(H29,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},2280]
["Vaisselle","Aude","f","Marié(e)","1966-06-06",57,4,"Secrétariat",{"$f":"VLOOKUP(H30,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1700},2040]
["Zetofrais","Mélanie","f","Célibataire","1978-11-25",44,2,"Direction",{"$f":"VLOOKUP(H31,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":2500},2750]
["Touille","Sasha","m","Célibataire","1982-10-30",40,2,"Personnel",{"$f":"VLOOKUP(H32,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1760]
["Proviste","Alain","m","Marié(e)","1959-09-09",64,4,"Personnel",{"$f":"VLOOKUP(H33,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1920]
["Peulaporte","Firmin","m","Divorcé(e)","1965-07-01",58,4,"Informatique",{"$f":"VLOOKUP(H34,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},2280]
["Unetitlaine","Jérémy","m","Marié(e)","1983-06-09",40,2,"Informatique",{"$f":"VLOOKUP(H35,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},2090]
["Ouzi","Jacques","m","Célibataire","1969-02-28",54,3,"Personnel",{"$f":"VLOOKUP(H36,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1840]

{"sheet":"Fcts classiques - Tableaux","index":47,"n_rows":29,"n_cols":15,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
["Utilisation des fonctions classiques",null,null,null,null,null,null,null,null,null,null,null,"Retour sommaire"]
[]
["En utilisant les tableaux de données."]
["Utilisez les fonctions classiques de façon à afficher le nombre d'employés par service."]
["Utilisez les fonctions classiques de façon à afficher le nombre d'employés et la moyenne des âges par sexe et par état civil."]
[]
["Nom","Prénom","Sexe","Etat civil","Date de naissance","Age","Tranches","Services","Salaires Minimum","Salaires"]
["Bistrot","Alonso","m","Marié(e)","1966-01-17",{"$f":"DATEDIF(E8,TODAY(),\"y\")","v":57},{"$f":"IF(F8<25,0,IF(F8<35,1,IF(F8<45,2,IF(F8<55,3,4))))","v":4},"Informatique",{"$f":"VLOOKUP(H8,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},{"$f":"I8+5%*G8*I8","v":2280},null,null,"Nombre d'employés par service"]
["Bijoba","Jo","m","Marié(e)","1980-03-15",43,2,"Direction",{"$f":"VLOOKUP(H9,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":2500},2750]
["Covert","Harry","m","Divorcé(e)","1942-02-10",81,4,"Personnel",{"$f":"VLOOKUP(H10,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1920,null,null,"Direction"]
["Culaire","Laury","m","Marié(e)","1965-05-05",58,4,"Personnel",{"$f":"VLOOKUP(H11,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1920,null,null,"Informatique"]
["Deuf","John","m","Célibataire","1963-09-08",60,4,"Informatique",{"$f":"VLOOKUP(H12,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},2280,null,null,"Personnel"]
["Foupasune","Jean","m","Célibataire","1975-08-07",48,3,"Personnel",{"$f":"VLOOKUP(H13,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1840,null,null,"Secrétariat"]
["Lairbon","Oussama","m","Marié(e)","1983-02-08",40,2,"Personnel",{"$f":"VLOOKUP(H14,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1760]
["Menvussa","Gérard","m","Célibataire","1970-12-04",52,3,"Informatique",{"$f":"VLOOKUP(H15,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},2185,null,null,"Nombre d'employés par sexe et état civil"]
["Lalalalalalala","Starsky","m","Célibataire","1955-07-08",68,4,"Personnel",{"$f":"VLOOKUP(H16,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1920]
["Lalalalalalala","Hutch","m","Divorcé(e)","1952-10-07",71,4,"Direction",{"$f":"VLOOKUP(H17,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":2500},3000,null,null,null,"f","m"]
["Cléssoulaporte","Djamila","f","Marié(e)","1959-09-07",64,4,"Personnel",{"$f":"VLOOKUP(H18,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1920,null,null,"Célibataire"]
["Noux","Marion","f","Divorcé(e)","1978-12-30",44,2,"Secrétariat",{"$f":"VLOOKUP(H19,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1700},1870,null,null,"Divorcé(e)"]
["Ouzi","Jacques","m","Célibataire","1969-02-28",54,3,"Personnel",{"$f":"VLOOKUP(H20,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1840,null,null,"Marié(e)"]
["Stiké","Sophie","f","Divorcé(e)","1959-04-04",64,4,"Secrétariat",{"$f":"VLOOKUP(H21,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1700},2040]
["Tare","Guy","m","Divorcé(e)","1960-08-07",63,4,"Informatique",{"$f":"VLOOKUP(H22,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},2280,null,null,"Salaire moyen par sexe et état civil"]
["Vaisselle","Aude","f","Marié(e)","1966-06-06",57,4,"Secrétariat",{"$f":"VLOOKUP(H23,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1700},2040]
["Zetofrais","Mélanie","f","Célibataire","1978-11-25",44,2,"Direction",{"$f":"VLOOKUP(H24,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":2500},2750,null,null,null,"f","m"]
["Touille","Sasha","m","Célibataire","1982-10-30",40,2,"Personnel",{"$f":"VLOOKUP(H25,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1760,null,null,"Célibataire"]
["Proviste","Alain","m","Marié(e)","1959-09-09",64,4,"Personnel",{"$f":"VLOOKUP(H26,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1920,null,null,"Divorcé(e)"]
["Peulaporte","Firmin","m","Divorcé(e)","1965-07-01",58,4,"Informatique",{"$f":"VLOOKUP(H27,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},2280,null,null,"Marié(e)"]
["Unetitlaine","Jérémy","m","Marié(e)","1983-06-09",40,2,"Informatique",{"$f":"VLOOKUP(H28,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},2090]
["Ouzi","Jacques","m","Célibataire","1969-02-28",54,3,"Personnel",{"$f":"VLOOKUP(H29,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1840]

{"sheet":"Fcts classiques-Tbl_corrigé","index":48,"n_rows":29,"n_cols":15,"rows_kept":29,"cut":false,"hidden":true,"merged":[]}
["Utilisation des fonctions classiques",null,null,null,null,null,null,null,null,null,null,null,"Retour sommaire"]
[]
["En utilisant les tableaux de données"]
["Utilisez les fonctions classiques de façon à afficher le nombre d'employés par service."]
["Utilisez les fonctions classiques de façon à afficher le nombre d'employés et la moyenne des âges par sexe et par état civil."]
[]
["Nom","Prénom","Sexe","Etat civil","Date de naissance","Age","Tranches","Services","Salaires Minimum","Salaires"]
["Bistrot","Alonso","m","Marié(e)","1966-01-17",{"$f":"DATEDIF(E8,TODAY(),\"y\")","v":57},{"$f":"IF(F8<25,0,IF(F8<35,1,IF(F8<45,2,IF(F8<55,3,4))))","v":4},"Informatique",{"$f":"VLOOKUP(H8,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},{"$f":"I8+5%*G8*I8","v":2280},null,null,"Nombre d'employés par service"]
["Bijoba","Jo","m","Marié(e)","1980-03-15",43,2,"Direction",{"$f":"VLOOKUP(H9,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":2500},2750]
["Covert","Harry","m","Divorcé(e)","1942-02-10",81,4,"Personnel",{"$f":"VLOOKUP(H10,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1920,null,null,"Service","Colonne1"]
["Culaire","Laury","m","Marié(e)","1965-05-05",58,4,"Personnel",{"$f":"VLOOKUP(H11,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1920,null,null,"Direction",{"$f":"COUNTIF(Tableau16[Services],Tableau24[Service])","v":3}]
["Deuf","John","m","Célibataire","1963-09-08",60,4,"Informatique",{"$f":"VLOOKUP(H12,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},2280,null,null,"Informatique",6]
["Foupasune","Jean","m","Célibataire","1975-08-07",48,3,"Personnel",{"$f":"VLOOKUP(H13,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1840,null,null,"Personnel",10]
["Lairbon","Oussama","m","Marié(e)","1983-02-08",40,2,"Personnel",{"$f":"VLOOKUP(H14,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1760,null,null,"Secrétariat",3]
["Menvussa","Gérard","m","Célibataire","1970-12-04",52,3,"Informatique",{"$f":"VLOOKUP(H15,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},2185]
["Lalalalalalala","Starsky","m","Célibataire","1955-07-08",68,4,"Personnel",{"$f":"VLOOKUP(H16,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1920,null,null,"Nombre d'employés par sexe et état civil"]
["Lalalalalalala","Hutch","m","Divorcé(e)","1952-10-07",71,4,"Direction",{"$f":"VLOOKUP(H17,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":2500},3000]
["Cléssoulaporte","Djamila","f","Marié(e)","1959-09-07",64,4,"Personnel",{"$f":"VLOOKUP(H18,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1920,null,null,"EC","f","m"]
["Noux","Marion","f","Divorcé(e)","1978-12-30",44,2,"Secrétariat",{"$f":"VLOOKUP(H19,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1700},1870,null,null,"Célibataire",{"$f":"COUNTIFS(Tableau16[Sexe],N18:O18,Tableau16[Etat civil],Tableau22[EC])","v":1},7]
["Ouzi","Jacques","m","Célibataire","1969-02-28",54,3,"Personnel",{"$f":"VLOOKUP(H20,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1840,null,null,"Divorcé(e)",2,4]
["Stiké","Sophie","f","Divorcé(e)","1959-04-04",64,4,"Secrétariat",{"$f":"VLOOKUP(H21,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1700},2040,null,null,"Marié(e)",2,6]
["Tare","Guy","m","Divorcé(e)","1960-08-07",63,4,"Informatique",{"$f":"VLOOKUP(H22,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},2280]
["Vaisselle","Aude","f","Marié(e)","1966-06-06",57,4,"Secrétariat",{"$f":"VLOOKUP(H23,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1700},2040]
["Zetofrais","Mélanie","f","Célibataire","1978-11-25",44,2,"Direction",{"$f":"VLOOKUP(H24,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":2500},2750,null,null,"Salaire moyen par sexe et état civil"]
["Touille","Sasha","m","Célibataire","1982-10-30",40,2,"Personnel",{"$f":"VLOOKUP(H25,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1760]
["Proviste","Alain","m","Marié(e)","1959-09-09",64,4,"Personnel",{"$f":"VLOOKUP(H26,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1920,null,null,"EC","f","m"]
["Peulaporte","Firmin","m","Divorcé(e)","1965-07-01",58,4,"Informatique",{"$f":"VLOOKUP(H27,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},2280,null,null,"Célibataire",{"$f":"AVERAGEIFS(Tableau16[Salaires],Tableau16[Etat civil],Tableau23[EC],Tableau16[Sexe],N26:O26)","v":2750},1952.1428571428571]
["Unetitlaine","Jérémy","m","Marié(e)","1983-06-09",40,2,"Informatique",{"$f":"VLOOKUP(H28,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},2090,null,null,"Divorcé(e)",1955,2370]
["Ouzi","Jacques","m","Célibataire","1969-02-28",54,3,"Personnel",{"$f":"VLOOKUP(H29,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1840,null,null,"Marié(e)",1980,2120]

{"sheet":"TCD_données","index":49,"n_rows":28,"n_cols":10,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
["Tableaux croisés dynamiques"]
[]
["A partir des données ci-dessous, construisez des tableaux croisés dynamiques tels que ceux décrits sur les feuilles suivantes"]
[]
[]
["Nom","Prénom","Sexe","Etat civil","Date de naissance","Age","Tranches","Services","Salaires Minimum","Salaires"]
["Bistrot","Alonso","m","Marié(e)","1966-01-17",{"$f":"DATEDIF(E7,TODAY(),\"y\")","v":57},{"$f":"IF(F7<25,0,IF(F7<35,1,IF(F7<45,2,IF(F7<55,3,4))))","v":4},"Informatique",{"$f":"VLOOKUP(H7,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},{"$f":"I7+5%*G7*I7","v":2280}]
["Bijoba","Jo","m","Marié(e)","1980-03-15",43,2,"Direction",{"$f":"VLOOKUP(H8,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":2500},2750]
["Covert","Harry","m","Divorcé(e)","1942-02-10",81,4,"Personnel",{"$f":"VLOOKUP(H9,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1920]
["Culaire","Laury","m","Marié(e)","1965-05-05",58,4,"Personnel",{"$f":"VLOOKUP(H10,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1920]
["Deuf","John","m","Célibataire","1963-09-08",60,4,"Informatique",{"$f":"VLOOKUP(H11,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},2280]
["Foupasune","Jean","m","Célibataire","1975-08-07",48,3,"Personnel",{"$f":"VLOOKUP(H12,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1840]
["Lairbon","Oussama","m","Marié(e)","1983-02-08",40,2,"Personnel",{"$f":"VLOOKUP(H13,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1760]
["Menvussa","Gérard","m","Célibataire","1970-12-04",52,3,"Informatique",{"$f":"VLOOKUP(H14,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},2185]
["Lalalalalalala","Starsky","m","Célibataire","1955-07-08",68,4,"Personnel",{"$f":"VLOOKUP(H15,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1920]
["Lalalalalalala","Hutch","m","Divorcé(e)","1952-10-07",71,4,"Direction",{"$f":"VLOOKUP(H16,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":2500},3000]
["Cléssoulaporte","Djamila","f","Marié(e)","1959-09-07",64,4,"Personnel",{"$f":"VLOOKUP(H17,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1920]
["Noux","Marion","f","Divorcé(e)","1978-12-30",44,2,"Secrétariat",{"$f":"VLOOKUP(H18,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1700},1870]
["Ouzi","Jacques","m","Célibataire","1969-02-28",54,3,"Personnel",{"$f":"VLOOKUP(H19,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1840]
["Stiké","Sophie","f","Divorcé(e)","1959-04-04",64,4,"Secrétariat",{"$f":"VLOOKUP(H20,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1700},2040]
["Tare","Guy","m","Divorcé(e)","1960-08-07",63,4,"Informatique",{"$f":"VLOOKUP(H21,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},2280]
["Vaisselle","Aude","f","Marié(e)","1966-06-06",57,4,"Secrétariat",{"$f":"VLOOKUP(H22,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1700},2040]
["Zetofrais","Mélanie","f","Célibataire","1978-11-25",44,2,"Direction",{"$f":"VLOOKUP(H23,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":2500},2750]
["Touille","Sasha","m","Célibataire","1982-10-30",40,2,"Personnel",{"$f":"VLOOKUP(H24,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1760]
["Proviste","Alain","m","Marié(e)","1959-09-09",64,4,"Personnel",{"$f":"VLOOKUP(H25,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1920]
["Peulaporte","Firmin","m","Divorcé(e)","1965-07-01",58,4,"Informatique",{"$f":"VLOOKUP(H26,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},2280]
["Unetitlaine","Jérémy","m","Marié(e)","1983-06-09",40,2,"Informatique",{"$f":"VLOOKUP(H27,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1900},2090]
["Ouzi","Jacques","m","Célibataire","1969-02-28",54,3,"Personnel",{"$f":"VLOOKUP(H28,Bdd1_consignes!$C$50:$D$54,2,FALSE)","v":1600},1840]

{"sheet":"TCD1","index":50,"n_rows":3,"n_cols":13,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,"Retour sommaire"]
[]
["Utilisez les tableaux croisés dynamiques de façon à afficher le nombre d'employés par service."]

{"sheet":"TCD1_corrigé","index":51,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":true,"merged":[]}
[]
[]
["Utilisez les tableaux croisés dynamiques de façon à afficher le nombre d'employés par service."]
[]
[]
[]
[]
[null,"Nombre de Nom"]
[null,"Services","Total"]
[null,"Direction",3]
[null,"Informatique",6]
[null,"Personnel",10]
[null,"Secrétariat",3]
[null,"Total général",22]

{"sheet":"TCD2","index":52,"n_rows":3,"n_cols":13,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,"Retour sommaire"]
[]
["Utilisez les tableaux croisés dynamiques de façon à afficher le salaire moyen par service et par sexe."]

{"sheet":"TCD2_corrigé","index":53,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":true,"merged":[]}
[]
[]
["Utilisez les tableaux croisés dynamiques de façon à afficher le salaire moyen par service et par sexe."]
[]
[]
[]
[null,"Moyenne de Salaires","Sexe"]
[null,"Services","f","m","Total général"]
[null,"Direction",2750,2875,2833.3333333333335]
[null,"Informatique",null,2200.8333333333335,2200.8333333333335]
[null,"Personnel",1920,1840,1848]
[null,"Secrétariat",1955,null,1955]
[null,"Total général",2107,2089.1176470588234,2093.181818181818]

{"sheet":"TCD3","index":54,"n_rows":3,"n_cols":13,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,"Retour sommaire"]
[]
["Utilisez les tableaux croisés dynamiqes de façon à afficher le nombre d'employés et la moyenne des âges par sexe et par état civil."]

{"sheet":"TCD3_corrigé","index":55,"n_rows":14,"n_cols":6,"rows_kept":14,"cut":false,"hidden":true,"merged":[]}
[]
[]
["Utilisez les tableaux croisés dynamiqes de façon à afficher le nombre d'employés et la moyenne des âges par sexe et par état civil."]
[]
[]
[]
[]
[null,null,"Sexe","Données"]
[null,null,"f",null,"m"]
[null,"Etat civil","Nombre","Moyenne des Ages","Nombre","Moyenne des Ages"]
[null,"Célibataire",1,40,7,49.857142857142854]
[null,"Divorcé(e)",2,50,4,64.25]
[null,"Marié(e)",2,56.5,6,46.333333333333336]
[null,"Total général",5,50.6,17,52]

{"sheet":"TCD4","index":56,"n_rows":3,"n_cols":13,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,"Retour sommaire"]
[]
["Utilisez les tableaux croisés dynamiques de façon à afficher le nombre d'employés ayant un salaire compris entre 1600 et 1800, entre 1800 et 2000 et ainsi de suite jusque 3000."]

{"sheet":"TCD4_corrigé","index":57,"n_rows":16,"n_cols":3,"rows_kept":16,"cut":false,"hidden":true,"merged":[]}
[]
[]
["Utilisez les tableaux croisés dynamiques de façon à afficher le nombre d'employés ayant un salaire compris entre 1600 et 1800, entre 1800 et 2000 et ainsi de suite jusque 3000."]
[]
[]
[]
[]
[null,"Nombre de Nom"]
[null,"Salaires","Total"]
[null,"1600-1799",3]
[null,"1800-1999",9]
[null,"2000-2199",5]
[null,"2200-2399",2]
[null,"2600-2799",2]
[null,"2800-3000",1]
[null,"Total général",22]

{"sheet":"TCD5","index":58,"n_rows":4,"n_cols":13,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,"Retour sommaire"]
[]
["Afin d'établir un budget 'anniversaire', la société souhaite savoir quel est le nombre de personnes nées par mois."]
["Etablir un TCD fournissant ces renseignements."]

{"sheet":"TCD5_corrigé","index":59,"n_rows":22,"n_cols":3,"rows_kept":22,"cut":false,"hidden":true,"merged":[]}
[]
[]
["Afin d'établir un budget 'anniversaire', la société souhaite savoir quel est le nombre de personnes nées par mois."]
["Etablir un TCD fournissant ces renseignements."]
[]
[]
[]
[null,"Nombre de Nom"]
[null,"Date de naissance","Total"]
[null,"janv",1]
[null,"févr",4]
[null,"mars",1]
[null,"avr",1]
[null,"mai",1]
[null,"juin",2]
[null,"juil",2]
[null,"août",2]
[null,"sept",3]
[null,"oct",2]
[null,"nov",1]
[null,"déc",2]
[null,"Total général",22]

{"sheet":"TCD6","index":60,"n_rows":4,"n_cols":13,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,"Retour sommaire"]
[]
["Créez un TCD donnant le pourcentage de femmes et d'hommes par service."]
["A partir de ça, créez un graphique croisé dynamique représentant ce pourcentage en 'histogramme'."]

{"sheet":"TCD6_corrigé","index":61,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":true,"merged":[]}
[]
[]
["Créez un TCD donnant le pourcentage de femmes et d'hommes par service."]
["A partir de ça, créez un graphique croisé dynamique représentant ce pourcentage en 'histogramme'."]
[]
[]
[]
[null,"Nombre de Nom","Sexe"]
[null,"Services","f","m"]
[null,"Direction",0.33333333333333331,0.66666666666666663]
[null,"Informatique",0,1]
[null,"Personnel",0.1,0.9]
[null,"Secrétariat",1,0]
[null,"Total général",0.22727272727272727,0.77272727272727271]