{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["TDM","RechercheX-1","RechercheX-2","MiseEnFormeCond-1","MiseEnFormeCond-2","MiseEnFormeCond-3","MiseEnFormeCond-3-Sol"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"TDM","index":0,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[null,null,"Feuilles du classeur :","Objectifs :"]
[]
[null,{"$f":"MesFeuilles","v":"TDM"},{"$f":"IF(MID(CELL(\"nomfichier\"),FIND(\"]\",CELL(\"nomfichier\"))+1,LEN(CELL(\"nomfichier\"))-FIND(\"]\",CELL(\"nomfichier\")))=B8,\"\",B8)","v":""},null,{"$f":"IF(C8=\"\",\"\",HYPERLINK(\"#'\"&B8&\"'!A1\",\"Atteindre \"&B8))","v":""}]
[null,"RechercheX-1",{"$f":"IF(MID(CELL(\"nomfichier\"),FIND(\"]\",CELL(\"nomfichier\"))+1,LEN(CELL(\"nomfichier\"))-FIND(\"]\",CELL(\"nomfichier\")))=B9,\"\",B9)","v":"RechercheX-1"},"Un premier exercice sur l'utilisation de RechercheX : recherche par valeur proche",{"$f":"IF(C9=\"\",\"\",HYPERLINK(\"#'\"&B9&\"'!A1\",\"Atteindre \"&B9))","v":"Atteindre RechercheX-1"}]
[null,"RechercheX-2",{"$f":"IF(MID(CELL(\"nomfichier\"),FIND(\"]\",CELL(\"nomfichier\"))+1,LEN(CELL(\"nomfichier\"))-FIND(\"]\",CELL(\"nomfichier\")))=B10,\"\",B10)","v":"RechercheX-2"},"Un second exercice sur l'utilisation de RechercheX : recherche dans un tableau, par ligne et pas colonne","Atteindre RechercheX-2"]
[null,"MiseEnFormeCond-1",{"$f":"IF(MID(CELL(\"nomfichier\"),FIND(\"]\",CELL(\"nomfichier\"))+1,LEN(CELL(\"nomfichier\"))-FIND(\"]\",CELL(\"nomfichier\")))=B11,\"\",B11)","v":"MiseEnFormeCond-1"},"Mise en forme conditionnelle, 'Exercice1' : mettre en surbrillance les valeurs les plus petites et les plus grandes ligne par ligne","Atteindre MiseEnFormeCond-1"]
[null,"MiseEnFormeCond-2",{"$f":"IF(MID(CELL(\"nomfichier\"),FIND(\"]\",CELL(\"nomfichier\"))+1,LEN(CELL(\"nomfichier\"))-FIND(\"]\",CELL(\"nomfichier\")))=B12,\"\",B12)","v":"MiseEnFormeCond-2"},"Mise en forme conditionnelle, 'Exercice2' : mettre en surbrillance le prénom de la/les personne(s) la/les plus âgée(s)","Atteindre MiseEnFormeCond-2"]
[null,"MiseEnFormeCond-3",{"$f":"IF(MID(CELL(\"nomfichier\"),FIND(\"]\",CELL(\"nomfichier\"))+1,LEN(CELL(\"nomfichier\"))-FIND(\"]\",CELL(\"nomfichier\")))=B13,\"\",B13)","v":"MiseEnFormeCond-3"},"Mise en forme conditionnelle, 'Exercice3' : mettre en surbrillance les jours du weekend et les jours fériés","Atteindre MiseEnFormeCond-3"]
[null,"MiseEnFormeCond-3-Sol",{"$f":"IF(MID(CELL(\"nomfichier\"),FIND(\"]\",CELL(\"nomfichier\"))+1,LEN(CELL(\"nomfichier\"))-FIND(\"]\",CELL(\"nomfichier\")))=B14,\"\",B14)","v":"MiseEnFormeCond-3-Sol"},"Solution de l'exercice 3","Atteindre MiseEnFormeCond-3-Sol"]

{"sheet":"RechercheX-1","index":1,"n_rows":19,"n_cols":15,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RETOUR"]
["Voici les règles permettant de classifier les terrains :"]
[]
[null,"- Si la superficie est comprise en 0 et 99 ares, le code 'terrain' est \"A\""]
[null,"- Si la superficie est comprise en 100 et 149 ares, le code 'terrain' est \"B\""]
[null,"- Si la superficie est comprise en 150 et 249 ares, le code 'terrain' est \"C\""]
[null,"- Si la superficie est comprise en 250 et 299 ares, le code 'terrain' est \"D\""]
[null,"- Si la superficie est comprise en 300 ares et plus, le code 'terrain' est \"E\""]
[]
[]
[null,null,"1- Construire le tableau dans lequel s'effectue la recherche",null,null,null,null,"2- Effectuer une recherche par valeur proche (mode correspondance = 1)"]
[]
[null,null,"0-99",0,"A",null,null,"Superficie","Code"]
[null,null,"100-149",100,"B",null,null,120,{"$f":"_xlfn.XLOOKUP(H14,$D$13:$D$17,$E$13:$E$17,,-1)","v":"B"}]
[null,null,"150-249",150,"C",null,null,251,"D"]
[null,null,"250-299",250,"D",null,null,500,"E"]
[null,null,"300- …",300,"E",null,null,56,"A"]
[null,null,null,null,null,null,null,120,"B"]
[null,null,null,null,null,null,null,230,"C"]

{"sheet":"RechercheX-2","index":2,"n_rows":27,"n_cols":15,"rows_kept":27,"cut":false,"hidden":false,"merged":[[2,9,2,15]]}
[null,null,null,null,null,null,null,null,null,"J'ai trouvé l'inspiration ici, merci Thomas !",null,null,null,null,"RETOUR"]
["Selon le tableau ci-dessous (renvoi d'une valeur par kms parcourus et mois)"]
["=> Obtenir la valeur qui correpsond à l'encodage d'un nombre de km et d'un mois bien précis. ",null,null,null,null,null,null,null,null,"Excel : RECHERCHEX à 2 critères, oubliez RECHERCHEV ! - YouTube"]
["=> Par exemple, 'Février', 23 donne comme résultat 8"]
[]
[]
[null,"Tableau initial",null,null,null,null,null,null,"Tableau \"reconstruit\" pour une recherhce efficace sur le nombre de km"]
[]
[null,null,"km","janvier","février","mars",null,null,"km","janvier","février","mars"]
[null,1,9,1,2,3,null,"0-9",0,1,2,3]
[null,10,19,4,5,6,null,"10-19",10,4,5,6]
[null,19,29,7,8,9,null,"20-29",20,7,8,9]
[null,28,39,10,11,12,null,"30-39",30,10,11,12]
[null,37,49,13,14,15,null,"40-49",40,13,14,15]
[null,46,59,16,17,18,null,"50-59",50,16,17,18]
[null,55,69,19,20,21,null,"60-…",60,19,20,21]
[]
[null,null,null,null,null,null,null,null,"km","mois"]
[null,null,null,null,null,null,null,null,22,"février"]
[]
[null,null,null,null,null,null,null,null,"NB : La ligne suivante (résultat intermédiaire peut-être masquée OU nous pouvons récupérer la formule dans la formule finale"]
[]
[null,null,null,null,null,null,null,null,null,"Prix pour les 3 mois (selon le kilométrage) :",{"$f":"_xlfn.XLOOKUP(I19,I10:I16,J10:L16,,-1)","v":7},8,9]
[]
[null,null,null,null,null,null,null,null,null,"Prix pour le mois choisi (en utilisant le résultat intermédiaire) :",{"$f":"_xlfn.XLOOKUP(J19,J9:L9,_xlfn.ANCHORARRAY(K23),,0)","v":8}]
[]
[null,null,null,null,null,null,null,null,null,"Prix pour le mois choisi (en recopiant la formule du résultat intermédiaire) :",{"$f":"_xlfn.XLOOKUP(J19,J9:L9,_xlfn.XLOOKUP(I19,I10:I16,J10:L16,,-1),,0)","v":8}]

{"sheet":"MiseEnFormeCond-1","index":3,"n_rows":12,"n_cols":15,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RETOUR"]
["Faire apparaître ligne par ligne la valeur la plus petite en bleu et la plus grande en rouge"]
[]
[]
[]
[null,"Ligne1",45,80,20]
[null,"Ligne2",10,25,69]
[null,"Ligne3",48,59,100]
[null,"Ligne4",12,45,2]
[null,"Ligne5",4,58,100]
[]
[null,"Via 'Mise en forme conditionnelle .. Gérer les règles' :"]

{"sheet":"MiseEnFormeCond-2","index":4,"n_rows":17,"n_cols":15,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RETOUR"]
["Faire apparaître en rouge la ligne de la personne la plus âgée"]
[]
[]
[null,"NB : Fonction qui permet de calculer l'âge => DATEDIF ( date1 ; date2 ; \"y\" )"]
[]
[null,null,"Prénoms","Date de  naissance","Âge"]
[null,null,"Bruno","1980-07-07",{"$f":"DATEDIF(D8,TODAY(),\"y\")","v":44},null,"Ici, les lignes en rouge sont celles pour lequel l'âge est le MAX"]
[null,null,"Stéphanie","1994-05-05",{"$f":"DATEDIF(D9,TODAY(),\"y\")","v":30}]
[null,null,"Vincent","1990-07-07",34]
[null,null,"Carole-Anne","1996-07-04",28]
[null,null,"Anna","1990-08-08",34]
[null,null,"Éric","1992-09-01",32]
[null,null,"Christophe","1980-09-07",44]
[]
[]
[null,"NB : Si nous souhaitons faire apparaître uniquement une ligne en rouge (Bruno) nous devions utilisez le minimum sur la valeur de la date de naissance"]

{"sheet":"MiseEnFormeCond-3","index":5,"n_rows":55,"n_cols":12,"rows_kept":55,"cut":false,"hidden":false,"merged":[]}
["Jours du weekend et jours fériés en grisés",null,"2024-11-09",null,null,null,"Liste des fériés :",null,null,null,null,"RETOUR"]
["Placer une bordure au début et à la fin du weekend",null,"2024-11-10",null,null,null,"2024-08-15"]
[null,null,"2024-11-11",null,null,null,"2024-11-11"]
["JOURSEM",null,"2024-11-12",null,null,null,"2024-12-25"]
["RECHERCHEX",null,"2024-11-13",null,null,null,"2025-01-01"]
[null,null,"2024-11-14"]
[null,null,"2024-11-15"]
[null,null,"2024-11-16"]
[null,null,"2024-11-17"]
[null,null,"2024-11-18"]
[null,null,"2024-11-19"]
[null,null,"2024-11-20"]
[null,null,"2024-11-21"]
[null,null,"2024-11-22"]
[null,null,"2024-11-23"]
[null,null,"2024-11-24"]
[null,null,"2024-11-25"]
[null,null,"2024-11-26"]
[null,null,"2024-11-27"]
[null,null,"2024-11-28"]
[null,null,"2024-11-29"]
[null,null,"2024-11-30"]
[null,null,"2024-12-01"]
[null,null,"2024-12-02"]
[null,null,"2024-12-03"]
[null,null,"2024-12-04"]
[null,null,"2024-12-05"]
[null,null,"2024-12-06"]
[null,null,"2024-12-07"]
[null,null,"2024-12-08"]
[null,null,"2024-12-09"]
[null,null,"2024-12-10"]
[null,null,"2024-12-11"]
[null,null,"2024-12-12"]
[null,null,"2024-12-13"]
[null,null,"2024-12-14"]
[null,null,"2024-12-15"]
[null,null,"2024-12-16"]
[null,null,"2024-12-17"]
[null,null,"2024-12-18"]
[null,null,"2024-12-19"]
[null,null,"2024-12-20"]
[null,null,"2024-12-21"]
[null,null,"2024-12-22"]
[null,null,"2024-12-23"]
[null,null,"2024-12-24"]
[null,null,"2024-12-25"]
[null,null,"2024-12-26"]
[null,null,"2024-12-27"]
[null,null,"2024-12-28"]
[null,null,"2024-12-29"]
[null,null,"2024-12-30"]
[null,null,"2024-12-31"]
[null,null,"2025-01-01"]
[null,null,"2025-01-02"]

{"sheet":"MiseEnFormeCond-3-Sol","index":6,"n_rows":55,"n_cols":12,"rows_kept":55,"cut":false,"hidden":false,"merged":[]}
["Jours du weekend et jours fériés en grisés",null,"2024-11-09",null,null,null,"Liste des fériés :",null,null,null,null,"RETOUR"]
["Placer une bordure au début et à la fin du weekend",null,"2024-11-10",null,null,null,"2024-08-15"]
[null,null,"2024-11-11",null,null,null,"2024-11-11"]
["JOURSEM",null,"2024-11-12",null,null,null,"2024-12-25"]
["RECHERCHEX",null,"2024-11-13",null,null,null,"2025-01-01"]
[null,null,"2024-11-14"]
[null,null,"2024-11-15"]
[null,null,"2024-11-16"]
[null,null,"2024-11-17"]
[null,null,"2024-11-18"]
[null,null,"2024-11-19"]
[null,null,"2024-11-20"]
[null,null,"2024-11-21"]
[null,null,"2024-11-22"]
[null,null,"2024-11-23"]
[null,null,"2024-11-24"]
[null,null,"2024-11-25"]
[null,null,"2024-11-26"]
[null,null,"2024-11-27"]
[null,null,"2024-11-28"]
[null,null,"2024-11-29"]
[null,null,"2024-11-30"]
[null,null,"2024-12-01"]
[null,null,"2024-12-02"]
[null,null,"2024-12-03"]
[null,null,"2024-12-04"]
[null,null,"2024-12-05"]
[null,null,"2024-12-06"]
[null,null,"2024-12-07"]
[null,null,"2024-12-08"]
[null,null,"2024-12-09"]
[null,null,"2024-12-10"]
[null,null,"2024-12-11"]
[null,null,"2024-12-12"]
[null,null,"2024-12-13"]
[null,null,"2024-12-14"]
[null,null,"2024-12-15"]
[null,null,"2024-12-16"]
[null,null,"2024-12-17"]
[null,null,"2024-12-18"]
[null,null,"2024-12-19"]
[null,null,"2024-12-20"]
[null,null,"2024-12-21"]
[null,null,"2024-12-22"]
[null,null,"2024-12-23"]
[null,null,"2024-12-24"]
[null,null,"2024-12-25"]
[null,null,"2024-12-26"]
[null,null,"2024-12-27"]
[null,null,"2024-12-28"]
[null,null,"2024-12-29"]
[null,null,"2024-12-30"]
[null,null,"2024-12-31"]
[null,null,"2025-01-01"]
[null,null,"2025-01-02"]