{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["WksAdressageDeCellules","WksTest","WksFonctionsTextes","WksDatesEtHeures","WksCodeAvecEtoiles"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":6,"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":"WksAdressageDeCellules","index":0,"n_rows":15,"n_cols":3,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["Trouver l'adresse de la 2ème ligne de la colonne 153 de la feuille \"WksTest\" de quelques manières différentes"]
[]
[{"$f":"ADDRESS(2,153,4,0,\"WksTest\")","v":"WksTest!L(2)C(153)"},"=ADRESSE(2;153;4;0;\"WksTest\")","le 4ème argumment à \"0\" donne l'adresse sous forme \"L1C1\""]
[{"$f":"ADDRESS(2,153,4,1,\"WksTest\")","v":"WksTest!EW2"},"=ADRESSE(2;153;4;1;\"WksTest\")","le 4ème argumment à \"1\" donne l'adresse sous forme \"A1\""]
[{"$f":"ADDRESS(2,153,4,1,\"WksTest\")","v":"WksTest!EW2"},"=ADRESSE(2;153;4;1;\"WksTest\")","Le 3ème argument \"pilote\" les signes \"$\""]
[{"$f":"ADDRESS(2,153,3,1,\"WksTest\")","v":"WksTest!$EW2"},"=ADRESSE(2;153;3;1;\"WksTest\")","Le 3ème argument \"pilote\" les signes \"$\""]
[{"$f":"ADDRESS(2,153,2,1,\"WksTest\")","v":"WksTest!EW$2"},"=ADRESSE(2;153;2;1;\"WksTest\")","Le 3ème argument \"pilote\" les signes \"$\""]
[{"$f":"ADDRESS(2,153,1,1,\"WksTest\")","v":"WksTest!$EW$2"},"=ADRESSE(2;153;1;1;\"WksTest\")","Le 3ème argument \"pilote\" les signes \"$\""]
["Indiquer le numéro d'ordre d'une colonne (dans ce cas ci, la dernière colonne)"]
[]
[{"$f":"COLUMN(XFD56232)","v":16384},"=COLONNE(XFD56236)"]
[]
["Indiquer le numéro d'ordre d'une ligne (dans ce cas ci, la dernière ligne)"]
[]
[{"$f":"ROW(A1048572)","v":1048572},"=LIGNE(A1048576)"]

{"sheet":"WksTest","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"WksFonctionsTextes","index":2,"n_rows":258,"n_cols":14,"rows_kept":258,"cut":false,"hidden":false,"merged":[]}
["Quelques Fonctions Texte",null,null,"Les codes ASCII"]
["Remarque : Le texte de la cellule \"A3\" commence et se termine par 2 espaces"]
["  jEAn-lOUiS  ",{"$f":"UPPER(A3)","v":"  JEAN-LOUIS  "},"=MAJUSCULE(A3) - Attention à la remarque (*)",0,{"$f":"CHAR(D3)","v":{"$error":"#VALUE!"}},"=CAR(D3)",null,"CHERCHE"]
[null,{"$f":"LOWER(A3)","v":"  jean-louis  "},"=MINUSCULE(A3) - Attention à la remarque (*)",1,{"$f":"CHAR(D4)","v":"\u0001"},null,null,"AZERTY",{"$f":"SEARCH(\"t\",H4)","v":5},"=CHERCHE(\"t\";H3)","Le \"t\" est en 3ème position en \"H3\""]
[null,{"$f":"PROPER(A3)","v":"  Jean-Louis  "},"=NOMPROPRE(A3) - Attention à la remarque (*)",2,"\u0002",null,null,"AZERTY",{"$f":"SEARCH(\"t\",H5,2)","v":5},"=CHERCHE(\"t\";H4;3)","???? Ne fonctionne pas, pourquoi ?"]
[null,null,null,3,"\u0003",null,null,"Un site intéressant"]
[null,{"$f":"LEFT(A3,4)","v":"  jE"},"=GAUCHE(A3;4) - Attention à la remarque (*)",4,"\u0004",null,null,"CNUM"]
[null,{"$f":"RIGHT(A3,5)","v":"UiS  "},"=DROITE(A3;5) - Attention à la remarque (*)",5,"\u0005",null,null,"53",{"$f":"VALUE(H8)","v":53},"=CNUM(H7)","La cellule \"H7\" étant précédée d'une apostrophe, le contenu est considéré comme du texte"]
[null,{"$f":"MID(A3,5,4)","v":"An-l"},"=STXT(A3;5;4) - Attention à la remarque (*)",6,"\u0006","=CAR(D9)",null,153,{"$f":"VALUE(H9)","v":153},"=CNUM(H8)"]
[null,null,null,7,"\u0007",null,null,"16:48:00",{"$f":"VALUE(H10)","v":0.70000000000000007},"=CNUM(H9)"]
[null,{"$f":"LEN(A3)","v":14},"=NBCAR(A3)",8,"\b",null,null,{"$f":"VALUE(\"16:48:00\")-VALUE(\"12:00:00\")","v":"04:48:00"},{"$f":"VALUE(\"16:48:00\")-VALUE(\"12:00:00\")","v":0.20000000000000007},"=CNUM(\"16:48:00\")-CNUM(\"12:00:00\")"]
[null,null,null,9,"\t",null,null,"CNUM"]
[null,{"$f":"TRIM(A3)","v":"jEAn-lOUiS"},"=SUPPRESPACE(A3)",10,"\n","=CAR(D13)",null,"AZERTY",{"$f":"CODE(H13)","v":65},"=CODE(H13)","Code Ascii du premier caractère de \"H13\""]
[null,{"$f":"LEN(B13)","v":10},"=NBCAR(B13)",11,"\u000b",null,null,"CONCAT"]
[null,{"$f":"TRIM(PROPER(A3))","v":"Jean-Louis"},"=SUPPRESPACE(NOMPROPRE(A3))",12,"\f",null,null,"Erika",{"$f":"_xlfn.CONCAT(H15,\" et Daniel\")","v":"Erika et Daniel"},"=CONCAT(H15;\" et Daniel\")"]
[null,{"$f":"FIND(\"-\",B15)","v":5},"=TROUVE(\"-\";B15)",13,"\r",null,null,"Daniel",{"$f":"_xlfn.CONCAT(H15,\" et \",H16)","v":"Erika et Daniel"},"=CONCAT(H15;\" et \";H16)"]
[null,{"$f":"LEFT(B15,LEFT(FIND(\"-\",B15,1)-1))","v":"Jean"},"=GAUCHE(B15;GAUCHE(TROUVE(\"-\";B15;1)-1))",14,"\u000e",null,null,"DEVISE"]
[null,null,null,15,"\u000f","=CAR(D18)",null,20276.437017600001,{"$f":"DOLLAR(H18,3)","v":"20 276,437 €"},"=DEVISE(H18;2)","Traduit la valeur en un texte dont l'\"ARRONDI\" est visuel, préférez l'exemple plus bas pour obtenit un arrondi réel"]
["(*)Remarque : Les espaces avt ou/et après le contenu sont toujours présents",null,null,16,"\u0010",null,null,null,null,null,"\"I18\" est aligné à gauche; donc considéré comme du texte"]
[null,null,null,17,"\u0011",null,null,null,{"$f":"DOLLAR(ROUND(I18,3),3)","v":"20 276,437 €"},"=DEVISE(ARRONDI(I18;2))"]
[null,null,null,18,"\u0012",null,null,"EPURAGE : Supprime les caractères non imprimables"]
[null,null,null,19,"\u0013",null,null,{"$f":"CHAR(9)&\"Rapport mensuel\"&CHAR(10)","v":"\tRapport mensuel\n"},{"$f":"CHAR(9)&\"Rapport mensuel\"&CHAR(10)","v":"\tRapport mensuel\n"},"=CAR(9)&\"Rapport mensuel\"&CAR(10)"]
[null,null,null,20,"\u0014",null,null,{"$f":"CHAR(9)","v":"\t"},"=CAR(9)","Caractère non imprimable"]
[null,null,null,21,"\u0015",null,null,"Rapport mensuel",null,"Simple texte"]
[null,null,null,22,"\u0016",null,null,{"$f":"CHAR(10)","v":"\n"},"=CAR(10)","Caractère non imprimable"]
[null,null,null,23,"\u0017",null,null,{"$f":"H23&H24&H25","v":"\tRapport mensuel\n"},"=H23&H24&H25","Texte \"entouré\" de caractères non imprimables"]
[null,null,null,24,"\u0018",null,null,{"$f":"LEN(H26)","v":17},"=NBCAR(H26)","Nombre de caractères du texte \"entouré\" de caractères non imprimables"]
[null,null,null,25,"\u0019",null,null,{"$f":"CLEAN(H26)","v":"Rapport mensuel"},"=EPURAGE(H26)","Épurage du précédent "]
[null,null,null,26,"\u001a",null,null,{"$f":"LEN(H28)","v":15},"=NBCAR(H28)","Nombre de caractères du texte épuré"]
[null,null,null,27,"\u001b",null,null,"Exact"]
[null,null,null,28,"\u001c",null,null,"AZERTY"]
[null,null,null,29,"\u001d",null,null,"AZERTY",{"$f":"EXACT(H31,H32)","v":true},"=EXACT(H31;H32)"]
[null,null,null,30,"\u001e",null,null,"azerty",{"$f":"EXACT(H31,H33)","v":false},"=EXACT(H31;H33)","Exact est sensible au respect de la casse"]
[null,null,null,31,"\u001f",null,null,"AZERTY ",{"$f":"EXACT(H31,H34)","v":false},"=EXACT(H31;H34)","Un espace exédentaire est après le texte \"AZERTY\""]
[null,null,null,32," ",null,null,null,{"$f":"EXACT(H31,TRIM(H34))","v":true},"=EXACT(H31;SUPPRESPACE(H34))","Bel exemple ! :-)"]
[null,null,null,33,"!",null,null,"JOINDRE.TEXTE"]
[null,null,null,34,"\"",null,null,"Il",null,"fera","beau",null,"demain"]
[null,null,null,35,"#",null,null,null,{"$f":"_xlfn.TEXTJOIN(\" \",TRUE,H37:M37)","v":"Il fera beau demain"},"=JOINDRE.TEXTE(\" \";VRAI;H37:M37)","Premier argument, le séparateur souhaité, deuxième argument à \"VRAI\" ignore les cellules vides"]
[null,null,null,36,"$",null,null,null,{"$f":"LEN(I38)","v":19},"=NBCAR(I38)","Nombre de caractères de ce qui précède"]
[null,null,null,37,"%",null,null,null,{"$f":"_xlfn.TEXTJOIN(\" \",FALSE,H37:M37)","v":"Il  fera beau  demain"},"=JOINDRE.TEXTE(\" \";FAUX;H37:M37)","Premier argument, le séparateur souhaité, deuxième argument à \"FAUX\" fait qu'il y a ajout d'un espace par cellule vide"]
[null,null,null,38,"&",null,null,null,{"$f":"LEN(I40)","v":21},"=NBCAR(I40)","Nombre de caractères de ce qui précède"]
[null,null,null,39,"'",null,null,"Janvier","Février","Mars"]
[null,null,null,40,"(",null,null,null,{"$f":"\"Le 1er trimestre est composé des mois de \"&_xlfn.TEXTJOIN(\", \",TRUE,H42:J42)","v":"Le 1er trimestre est composé des mois de Janvier, Février, Mars"}]
[null,null,null,41,")",null,null,null,"=\"Le 1er trimestre est composé des mois de \"&JOINDRE.TEXTE(\", \";VRAI;H42:J42)"]
[null,null,null,42,"*",null,null,"REMPLACER"]
[null,null,null,43,"+",null,null,"AZERTY",{"$f":"REPLACE(H46,1,2,\"QW\")","v":"QWERTY"},"=REMPLACER(H45;1;2;\"QW\")"]
[null,null,null,44,",",null,null,"AZERTY",{"$f":"REPLACE(H47,1,5,\"123\")","v":"123Y"},"=REMPLACER(H46;1;5;\"123\")"]
[null,null,null,45,"-",null,null,"RPT"]
[null,null,null,46,".",null,null,"0123456789",{"$f":"REPT(H49,4)","v":"0123456789012345678901234567890123456789"}]
[null,null,null,47,"/",null,null,null,null,"=REPT(H49;4)","Répéter le texte de \"H49\" 4 fois"]
[null,null,null,48,"0",null,null,"SUBSTITUE"]
[null,null,null,49,"1",null,null,"Consultez le document de CADACOM",null,"Ici"]
[null,null,null,50,"2",null,null,"T"]
[null,null,null,51,"3",null,null,14,{"$f":"T(H54)","v":""},"=T(H54)","Renvoie une chaîne vide car \"H54\" n'est pas un texte"]
[null,null,null,52,"4",null,null,"2017-11-24","","=T(H55)"]
[null,null,null,53,"5",null,null,"AZERTY","AZERTY","=T(H56)"]
[null,null,null,54,"6",null,null,"TEXTE"]
[null,null,null,55,"7",null,null,1048576,{"$f":"TEXT(H58,\"# ##0,00 €\")","v":"1 048 576,00 €"},"=TEXTE(H58;\"# ##0,00 €\")","Remarque : le résultat est en format texte.  Si un calcul est nécessaire, faites-le sur la cellule originale"]
[null,null,null,56,"8",null,null,{"$f":"TODAY()","v":"2022-10-29"},{"$f":"TEXT(H59,\"jjj J MMM AA\")","v":"sam 29 oct 22"},"=TEXTE(H59;\"jjj J MMM AA\")"]
[null,null,null,57,"9",null,null,123456,{"$f":"TEXT(H60,\"##0° 00' 00''\")","v":"12° 34' 56''"},"=TEXTE(H60;\"##0° 00' 00''\")"]
[null,null,null,58,":",null,null,{"$f":"NOW()","v":"2022-10-29T15:01:05.760"},{"$f":"TEXT(H61,\"HH:MM\")","v":"15:01"},"=TEXTE(H61;\"HH:MM\")"]
[null,null,null,59,";",null,null,null,{"$f":"TEXT(H61,\"H\"&CHAR(34)&CHAR(32)&CHAR(104)&CHAR(32)&CHAR(34)&\"mm\")","v":"15 h 01"},"=TEXTE(H61;\"H\"&CAR(34)&CAR(32)&CAR(104)&CAR(32)&CAR(34)&\"mm\")"]
[null,null,null,60,"<",null,null,"TROUVE (Sensible au respect de la casse)"]
[null,null,null,61,"=",null,null,"Myriam Mignon",{"$f":"FIND(\"M\",H$64)","v":1},"=TROUVE(\"M\";H$64)","Position du premier \"M\" majuscule"]
[null,null,null,62,">",null,null,null,{"$f":"FIND(\"m\",H$64)","v":6},"=TROUVE(\"m\";H$64)","Position du premier \"M\" minuscule"]
[null,null,null,63,"?",null,null,null,{"$f":"FIND(\"M\",H$64,3)","v":8},"=TROUVE(\"M\";H$64;3)","Problème avec le 3ème argument (devrait me répondre \"5\")"]
[null,null,null,64,"@",null,null,"UNICAR"]
[null,null,null,65,{"$f":"CHAR(D68)","v":"A"},null,null,66,{"$f":"_xlfn.UNICHAR(H68)","v":"B"},"=UNICAR(H68)"]
[null,null,null,66,"B",null,null,"UNICODE"]
[null,null,null,67,"C",null,null,"B",{"$f":"_xlfn.UNICODE(H70)","v":66},"=UNICODE(H70)"]
[null,null,null,68,"D",null,null,"VALEURNOMBRE"]
[null,null,null,69,"E",null,null,"123456,123",{"$f":"_xlfn.NUMBERVALUE(H72,\".\",\" \")","v":123456.12300000001}," =VALEURNOMBRE(H72;\".\";\" \")"]
[null,null,null,70,"F",null,null,"TEXTE.AVANT"]
[null,null,null,71,"G",null,null,"Albert EINSTEIN",{"$f":"_xlfn.TEXTBEFORE(H74,\" \")","v":"Albert"}," =TEXTE.AVANT(H74;\" \")"]
[null,null,null,72,"H",null,null,"TEXTE.APRES"]
[null,null,null,73,"I",null,null,"Albert EINSTEIN",{"$f":"_xlfn.TEXTAFTER(H76,\" \")","v":"EINSTEIN"}," =TEXTE.APRES(H76;\" \")"]
[null,null,null,74,"J",null,null,"TEXTE.APRES"]
[null,null,null,75,"K",null,null,"Il est l'heure de sortir le chien",null," =FRACTIONNER.TEXTE(H78;\" \")"]
[null,null,null,76,"L",null,null,{"$f":"_xlfn.TEXTSPLIT(H78,\" \")","v":"Il"},"est","l'heure","de","sortir","le","chien"]
[null,null,null,77,"M"]
[null,null,null,78,"N"]
[null,null,null,79,"O"]
[null,null,null,80,"P"]
[null,null,null,81,"Q"]
[null,null,null,82,"R"]
[null,null,null,83,"S"]
[null,null,null,84,"T"]
[null,null,null,85,"U"]
[null,null,null,86,"V"]
[null,null,null,87,"W"]
[null,null,null,88,"X"]
[null,null,null,89,"Y"]
[null,null,null,90,"Z"]
[null,null,null,91,"["]
[null,null,null,92,"\\"]
[null,null,null,93,"]"]
[null,null,null,94,"^"]
[null,null,null,95,"_"]
[null,null,null,96,"`"]
[null,null,null,97,"a"]
[null,null,null,98,"b"]
[null,null,null,99,"c"]
[null,null,null,100,"d"]
[null,null,null,101,"e"]
[null,null,null,102,"f"]
[null,null,null,103,"g"]
[null,null,null,104,"h"]
[null,null,null,105,"i"]
[null,null,null,106,"j"]
[null,null,null,107,"k"]
[null,null,null,108,"l"]
[null,null,null,109,"m"]
[null,null,null,110,"n"]
[null,null,null,111,"o"]
[null,null,null,112,"p"]
[null,null,null,113,"q"]
[null,null,null,114,"r"]
[null,null,null,115,"s"]
[null,null,null,116,"t"]
[null,null,null,117,"u"]
[null,null,null,118,"v"]
[null,null,null,119,"w"]
[null,null,null,120,"x"]
[null,null,null,121,"y"]
[null,null,null,122,"z"]
[null,null,null,123,"{"]
[null,null,null,124,"|"]
[null,null,null,125,"}"]
[null,null,null,126,"~"]
[null,null,null,127,"\u007f"]
[null,null,null,128,"€"]
[null,null,null,129,{"$f":"CHAR(D132)","v":"\u0081"}]
[null,null,null,130,"‚"]
[null,null,null,131,"ƒ"]
[null,null,null,132,"„"]
[null,null,null,133,"…"]
[null,null,null,134,"†"]
[null,null,null,135,"‡"]
[null,null,null,136,"ˆ"]
[null,null,null,137,"‰"]
[null,null,null,138,"Š"]
[null,null,null,139,"‹"]
[null,null,null,140,"Œ"]
[null,null,null,141,"\u008d"]
[null,null,null,142,"Ž"]
[null,null,null,143,"\u008f"]
[null,null,null,144,"\u0090"]
[null,null,null,145,"‘"]
[null,null,null,146,"’"]
[null,null,null,147,"“"]
[null,null,null,148,"”"]
[null,null,null,149,"•"]
[null,null,null,150,"–"]
[null,null,null,151,"—"]
[null,null,null,152,"˜"]
[null,null,null,153,"™"]
[null,null,null,154,"š"]
[null,null,null,155,"›"]
[null,null,null,156,"œ"]
[null,null,null,157,"\u009d"]
[null,null,null,158,"ž"]
[null,null,null,159,"Ÿ"]
[null,null,null,160," "]
[null,null,null,161,"¡"]
[null,null,null,162,"¢"]
[null,null,null,163,"£"]
[null,null,null,164,"¤"]
[null,null,null,165,"¥"]
[null,null,null,166,"¦"]
[null,null,null,167,"§"]
[null,null,null,168,"¨"]
[null,null,null,169,"©"]
[null,null,null,170,"ª"]
[null,null,null,171,"«"]
[null,null,null,172,"¬"]
[null,null,null,173,"­"]
[null,null,null,174,"®"]
[null,null,null,175,"¯"]
[null,null,null,176,"°"]
[null,null,null,177,"±"]
[null,null,null,178,"²"]
[null,null,null,179,"³"]
[null,null,null,180,"´"]
[null,null,null,181,"µ"]
[null,null,null,182,"¶"]
[null,null,null,183,"·"]
[null,null,null,184,"¸"]
[null,null,null,185,"¹"]
[null,null,null,186,"º"]
[null,null,null,187,"»"]
[null,null,null,188,"¼"]
[null,null,null,189,"½"]
[null,null,null,190,"¾"]
[null,null,null,191,"¿"]
[null,null,null,192,"À"]
[null,null,null,193,{"$f":"CHAR(D196)","v":"Á"}]
[null,null,null,194,"Â"]
[null,null,null,195,"Ã"]
[null,null,null,196,"Ä"]
[null,null,null,197,"Å"]
[null,null,null,198,"Æ"]
[null,null,null,199,"Ç"]
[null,null,null,200,"È"]
[null,null,null,201,"É"]
[null,null,null,202,"Ê"]
[null,null,null,203,"Ë"]
[null,null,null,204,"Ì"]
[null,null,null,205,"Í"]
[null,null,null,206,"Î"]
[null,null,null,207,"Ï"]
[null,null,null,208,"Ð"]
[null,null,null,209,"Ñ"]
[null,null,null,210,"Ò"]
[null,null,null,211,"Ó"]
[null,null,null,212,"Ô"]
[null,null,null,213,"Õ"]
[null,null,null,214,"Ö"]
[null,null,null,215,"×"]
[null,null,null,216,"Ø"]
[null,null,null,217,"Ù"]
[null,null,null,218,"Ú"]
[null,null,null,219,"Û"]
[null,null,null,220,"Ü"]
[null,null,null,221,"Ý"]
[null,null,null,222,"Þ"]
[null,null,null,223,"ß"]
[null,null,null,224,"à"]
[null,null,null,225,"á"]
[null,null,null,226,"â"]
[null,null,null,227,"ã"]
[null,null,null,228,"ä"]
[null,null,null,229,"å"]
[null,null,null,230,"æ"]
[null,null,null,231,"ç"]
[null,null,null,232,"è"]
[null,null,null,233,"é"]
[null,null,null,234,"ê"]
[null,null,null,235,"ë"]
[null,null,null,236,"ì"]
[null,null,null,237,"í"]
[null,null,null,238,"î"]
[null,null,null,239,"ï"]
[null,null,null,240,"ð"]
[null,null,null,241,"ñ"]
[null,null,null,242,"ò"]
[null,null,null,243,"ó"]
[null,null,null,244,"ô"]
[null,null,null,245,"õ"]
[null,null,null,246,"ö"]
[null,null,null,247,"÷"]
[null,null,null,248,"ø"]
[null,null,null,249,"ù"]
[null,null,null,250,"ú"]
[null,null,null,251,"û"]
[null,null,null,252,"ü"]
[null,null,null,253,"ý"]
[null,null,null,254,"þ"]
[null,null,null,255,"ÿ"]

{"sheet":"WksDatesEtHeures","index":3,"n_rows":178,"n_cols":3,"rows_kept":178,"cut":false,"hidden":false,"merged":[[77,1,77,2],[78,1,78,2],[165,0,165,1]]}
["Date en général"]
[]
["Résultat","Formule","Description"]
[{"$f":"TODAY()","v":"2022-10-29"},"=AUJOURDHUI()"]
[{"$f":"DAY(A4)","v":29},"=JOUR(A4)"]
[{"$f":"MONTH(A4)","v":10},"=MOIS(A4)"]
[{"$f":"YEAR(A4)","v":2022},"=ANNEE(A4)"]
[{"$f":"DATE(A7,A6,A5)","v":"2022-10-29"},"=DATE(A7;A6;A5)","Construction d'une date"]
[]
["Heure en général"]
[]
["Résultat","Formule","Description"]
[{"$f":"NOW()","v":44863.625761111114},"=MAINTENANT()"]
[{"$f":"HOUR(A13)","v":15},"=HEURE(A13)"]
[{"$f":"MINUTE(A13)","v":1},"=MINUTE(A13)"]
[{"$f":"SECOND(A13)","v":6},"=SECONDE(A13)"]
[{"$f":"TIME(A14,A15,A16)","v":"15:01:06"},"=TEMPS(A14;A15;A16)","Construction d'un moment"]
[]
["AUJOURDHUI"]
[null,{"$f":"TODAY()","v":"2022-10-29"},"=AUJOURDHUI()"]
["MAINTENANT"]
[null,{"$f":"NOW()","v":"2022-10-29T15:01:05.760"},"=MAINTENANT()"]
["DATEVAL"]
["Remarque"]
["la fonction DATEVAL ne fonctionne que si l'argument est un texte,qui plus est contentant de \"-\" ou des \"/\" comme séparateur"]
[]
["Réalisation"]
[]
["Données","Formule"]
[{"$f":"DAY(TODAY())","v":29},"=JOUR(AUJOURDHUI())"]
[{"$f":"MONTH(TODAY())","v":10},"=MOIS(AUJOURDHUI())"]
[{"$f":"YEAR(TODAY())","v":2022},"=ANNEE(AUJOURDHUI())"]
["5-JUIL","5-JUIL"]
["22-08/11","22-08/11"]
[]
["Résultat","Formule","Description"]
[{"$f":"DATEVALUE(A34)","v":"2011-08-22"},"=DATEVAL(A36)"]
[{"$f":"DATEVALUE(A33)","v":"2022-07-05"},"=DATEVAL(A35)"]
[{"$f":"DATEVALUE(A30 & \"/\" & A31 & \"/\" & A32)","v":"2022-10-29"},"=DATEVAL(A32 & \"/\" & A33 & \"/\" & A34)"]
[]
["FIN.MOIS"]
[]
["Résultat","Formule","Description"]
[{"$f":"TODAY()","v":"2022-10-29"},"=AUJOURDHUI()"]
[{"$f":"EOMONTH(A44,4)","v":"2023-02-28"},"=FIN.MOIS(A35;4)","Date de fin de mois 4 mois plus tard"]
[]
["FRACTION.ANNEE (Source : aide en ligne de Microsoft®)"]
["Base"]
[]
["Base","Comptage des jours"]
["0 ou omis","30/360 US (NASD)"]
[1,"Réel/réel"]
[2,"Réel/360"]
[3,"Réel/365"]
[4,"30/360 européen"]
[]
["Réalisation"]
[]
["Données","Description"]
["2012-01-01","Date de début"]
["2012-07-30","Date de fin"]
[]
["Résultat","Formule","Description"]
[{"$f":"YEARFRAC(A60,A61)","v":0.5805555555555556},"=FRACTION.ANNEE(A45;A46)","Fraction de l’année comprise entre le 01/01/2012 et le 30/07/12, en omettant l’argument base."]
[{"$f":"YEARFRAC(A60,A61,1)","v":0.57650273224043713},"=FRACTION.ANNEE(A45;A46;1)","Fraction entre ces mêmes dates, en utilisant l’argument base Réel/Réel. 2012 étant une année bissextile, elle est dotée d’une base de 366 jours."]
[{"$f":"YEARFRAC(A60,A61,3)","v":0.57808219178082187},"=FRACTION.ANNEE(A45;A46;3)","Fraction entre ces mêmes dates, en utilisant l’argument base Réel/365. Utilise une base de 365 jours."]
[]
["JOURS"]
[]
["Date","Formule","Description"]
["1952-11-24"]
[{"$f":"TODAY()","v":"2022-10-29"},null,"=AUJOURDHUI()"]
[null,{"$f":"_xlfn.DAYS(A72,A71)","v":25541},"=JOURS(A60;A59)"]
[]
["JOURS360 (Source : aide en ligne de Microsoft®)"]
[]
["Méthode","Mode de calcul"]
["FAUX ou omis","Méthode États-Unis (NASD). Si la date de début est le dernier jour du mois, la date de début devient le 30 du même mois. Si la date de fin est le dernier jour du mois et que la date de début est avant le 30 du mois, la date de fin devient le 1er du mois suivant ; sinon, la date de fin devient le 30 du même mois."]
[true,"Méthode européenne. Les dates de début et de fin correspondant au 31 du mois deviennent le 30 du même mois."]
[]
["Dates"]
["2017-01-01"]
["2017-01-30"]
["2017-02-01"]
["2017-12-31"]
[]
["Résultat","Formule","Description"]
[{"$f":"DAYS360(A82,A84)","v":30},"=JOURS360(A70;A72)","Nombre de jours entre le 30-01-11 et le 01-02-11 sur la base d’une année de 360 jours."]
[{"$f":"DAYS360(A82,A85)","v":360},"=JOURS360(A70;A73)","Nombre de jours entre le 01-01-17 et le 31-12-17 sur la base d’une année de 360 jours."]
[{"$f":"DAYS360(A82,A84)","v":30},"=JOURS360(A70;A72)","Nombre de jours entre le 01-01-17 et le 01-02-17 sur la base d’une année de 360 jours."]
[]
["MOIS.DECALER"]
[]
["Résultat","Formule","Description"]
[{"$f":"TODAY()","v":"2022-10-29"},"=AUJOURDHUI()"]
[{"$f":"EDATE(A95,5)","v":"2023-03-29"},"=MOIS.DECALER(A84;5)","Même jour, 5 mois + tard"]
[{"$f":"EDATE(A95,-5)","v":"2022-05-29"},"=MOIS.DECALER(A85;-5)","Même jour, 5 mois dans le passé"]
[]
["NB.JOURS.OUVRES"]
[]
["Données","Description"]
["2017-01-01","Date de début de période"]
["2017-12-31","Date de fin de période"]
["2017-01-01","Jour de l'an"]
["2017-04-17","Lundi de Pâques"]
["2017-05-01","Fête du travail"]
["2017-05-25","Ascension"]
["2017-06-05","lundi de la Pentecôte"]
["2017-07-21","Fête nationale belge"]
["2017-08-15","Assomption"]
["2017-11-01","Toussaint"]
["2017-11-11","Armistice"]
["2017-12-25","Noël"]
[]
["Résultat","Formule","Description"]
[{"$f":"NETWORKDAYS(A102,A103,A104:A113)","v":252},"=NB.JOURS.OUVRES(A102;A103;A104:A113)","Nombre de jours ouvrés tenant compte des jours fériés et des weekends"]
[]
["NO.SEMAINE"]
[]
["Résultat","Formule","Description"]
[{"$f":"TODAY()","v":"2022-10-29"},"=AUJOURDHUI()"]
[{"$f":"WEEKNUM(A$121,1)","v":44},"=NO.SEMAINE(A$121;1)","La semaine commence le dimanche (compatible Office® 2003) - Système 1"]
[{"$f":"WEEKNUM(A$121,2)","v":44},"=NO.SEMAINE(A$121;2)","La semaine commence le lundi (compatible Office® 2003) - Système 1"]
[{"$f":"WEEKNUM(A$121,11)","v":44},"=NO.SEMAINE(A$121;11)","La semaine commence le dimanche  - Système 1 - ???"]
[{"$f":"WEEKNUM(A$121,15)","v":44},"=NO.SEMAINE(A$121;15)","La semaine commence le vendredi  - Système 1 - ???"]
[{"$f":"WEEKNUM(A$121,17)","v":44},"=NO.SEMAINE(A$121;17)","La semaine commence le dimanche  - Système 1 - ???"]
[{"$f":"WEEKNUM(A$121,21)","v":43},"=NO.SEMAINE(A$121;21)","La semaine commence le dimanche  - Système 2 - ???"]
[]
["NO.SEMAINE.ISO"]
[]
["Résultat","Formule","Description"]
[{"$f":"TODAY()","v":"2022-10-29"},"=AUJOURDHUI()"]
[{"$f":"_xlfn.ISOWEEKNUM(A132)","v":43},"=NO.SEMAINE.ISO(A132)","Numéro de semaine ISO (Semaine 1 = la première semaine avec au moins quatre jours dans la même année civile)"]
[]
["Remarque"]
["Source de la définition de la semaine ISO :",null,"WIKIPÉDIA"]
[]
["SERIE.JOUR.OUVRE"]
[]
["Remarque 1"]
["Le but de cette fonction est de déterminer une date de fin de chantier nécessitant \"X\" jours de travail."]
["Cette explication est basée sur l'année 2017 et ses jours fériés"]
["Le résultat ne sera parfaitement correct que si la date d'échéance est inférieure ou égal au 31 déc 2017"]
[]
["Réalisation"]
[]
["Données","Description"]
[{"$f":"DATE(2017,MONTH(TODAY()),DAY(TODAY()))","v":"2017-10-29"},"Date de début"]
[46,"Nombre de jours restant pour terminer le travail"]
["2017-01-01","Jour de l'an"]
["2017-04-17","Lundi de Pâques"]
["2017-05-01","Fête du travail"]
["2017-05-25","Ascension"]
["2017-06-05","lundi de la Pentecôte"]
["2017-07-21","Fête nationale belge"]
["2017-08-15","Assomption"]
["2017-11-01","Toussaint"]
["2017-11-11","Armistice"]
["2017-12-25","Noël"]
[]
["Résultat","Formule","Description"]
[{"$f":"WORKDAY(A148,A149,A150:A159)","v":"2018-01-03"},"=SERIE.JOUR.OUVRE(A148;A149;A150:A159)",{"$f":"\"Date de fin de chantier commencant le \"&TEXT(A148,\"jjj J MMM AA\")&\" et nécessitant \"&A149&\" jours ouvrés\"","v":"Date de fin de chantier commencant le dim 29 oct 17 et nécessitant 46 jours ouvrés"}]
[]
["Remarque 2"]
[]
[{"$f":"\"À remarquer la formule de description montrant l'utilité d'une fonction texte afin d'éviter d'avoir la date sous la forme : \"&A148","v":"À remarquer la formule de description montrant l'utilité d'une fonction texte afin d'éviter d'avoir la date sous la forme : 43037"},null,"=\"À remarquer la formule de description montrant l'utilité d'une fonction texte afin d'éviter d'avoir la date sous la forme : \"&A148"]
["Soit : =\"Date de fin de chantier commencant le \"&TEXTE(A148;\"jjj J MMM AA\")&\" et nécessitant \"&A149&\" jours ouvrés\""]
[]
["TEMPSVAL"]
[]
["Donnée","Formule","Description"]
[{"$f":"TEXT(NOW(),\"hh:mm\")","v":"15:01"},"=TEXTE(MAINTENANT();\"hh:mm\")","Pour que la fonction TEMPSVAL fonctionne, il faut que son argurment soit sous forme de texte"]
[]
[]
["Résultat","Formule","Description"]
[{"$f":"TIMEVALUE(\"2:24\")","v":9.9999999999999992E-2},"=TEMPSVAL(\"2:24\")","Partie décimale d’un jour avec uniquement l’heure spécifiée."]
[{"$f":"TIMEVALUE(\"22-Aoû-2011 06:35\")","v":0.27430555555474712},"=TEMPSVAL(\"22-Aoû-2011 06:35\")","Partie décimale d’un jour avec la date et l’heure spécifiées."]
[{"$f":"TIMEVALUE(A172)","v":0.62569444444444444},"=TEMPSVAL(A172)","Partie décimale de la fonction MAINTENANT transformée en texte"]

{"sheet":"WksCodeAvecEtoiles","index":4,"n_rows":21,"n_cols":8,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["azertyuiopqsdfg",{"$f":"IFERROR(LEFT(A1,3)&VLOOKUP(LEN(A1)-3,MesEtoiles,2,0),\"4 caractères minimum, svp !\")","v":"aze************"},null,null,null,"Nombre","Etoiles"]
[{"$f":"LEN(A1)","v":15},{"$f":"LEN(B1)","v":15},"=NBCAR(B1)",null,null,1,{"$f":"IF(ROW(G2)=2,\"*\",G1&\"*\")","v":"*"},"=SI(LIGNE(G2)=2;\"*\";G1&\"*\")"]
[null,null,null,null,null,2,"**"]
[null,null,null,null,null,3,"***"]
[null,null,null,null,null,4,"****"]
[null,null,null,null,null,5,"*****"]
[null,null,null,null,null,6,"******"]
[null,null,null,null,null,7,"*******"]
[null,null,null,null,null,8,"********"]
[null,null,null,null,null,9,"*********"]
[null,null,null,null,null,10,"**********"]
[null,null,null,null,null,11,"***********"]
[null,null,null,null,null,12,"************"]
[null,null,null,null,null,13,"*************"]
[null,null,null,null,null,14,"**************"]
[null,null,null,null,null,15,"***************"]
[null,null,null,null,null,16,"****************"]
[]
["=SIERREUR(GAUCHE(A1;3)&RECHERCHEV(NBCAR(A1)-3;MesEtoiles;2;0);\"4 caractères minimum, svp !\")"]
[]
["A la demande d'un participant : d'un code en A1, obtenir les 3 premiers caractères suivis d'autant d'étoiles pour correspondre à la longueur du code"]