{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Feuil1","Résultat","Résultat ancien","Calculs","BDD"],"not_rendered":{"charts":0,"images":0,"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":"Feuil1","index":0,"n_rows":84,"n_cols":47,"rows_kept":84,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,22,null,null,null,null,null,null,null,null,null,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,4,null,null,null,null,null,null,null,null,12,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11]
[null,null,null,null,null,null,null,null,4]
[]
[null,null,null,null,null,null,null,null,null,null,null,"A","A","A","A","A","A","A","A","A","A","A",null,null,null,null,null,null,null,"B","B","B","B","B","B","B","B","B"]
[]
["eretyutyuku",null,null,null,null,null,null,18,null,null,null,7,9,5,5,6,4,null,1,null,null,null,null,null,null,null,null,null,null,8,9,2,4,8,7]
["ggdgdgdgg",null,null,null,null,null,null,null,3,null,null,null,null,null,null,null,null,49,null,null,null,null,null,null,null,null,null,null,null,null,null,null,39]
["lilljdaqfq",null,null,null,null,null,null,null,11,null,null,null,null,null,null,null,null,13,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
["xcdr"]
[null,null,null,null,null,null,null,53,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,null,4,null,2]
["ghfhjjh,,",null,null,null,null,null,null,null,8,null,null,null,null,null,null,null,null,26,null,null,null,null,null,null,null,null,null,null,null,null,null,null,29]
[null,null,null,null,null,null,null,null,7,null,null,null,null,null,null,null,null,7,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9]
[]
[null,null,null,null,2,null,null,null,null,null,null,null,null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,null,null,6,null,null,null,null,null,null,null,null,null,null,null,null,null,7]
[null,null,null,null,2,null,null,null,null,null,null,null,null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,null,null,6,null,null,null,null,null,null,null,null,null,null,null,null,null,7]
[null,null,null,null,11,null,null,null,null,null,null,null,null,null,null,11,null,null,null,null,null,null,null,null,null,null,null,null,null,13,null,null,null,null,null,null,null,null,null,null,null,null,null,16]
[null,null,5,null,6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,null,6]
[]
["C","C","C","C","C","C","C","C","C",null,null,"D","D","D","D","D","D","D","D","D",null,null,null,null,null,null,"E","E","E","E","E","E","E","E","E",null,null,null,null,"F","F","F","F","F","F","F","F"]
[]
[7,9,5,5,6,4,null,3,null,null,null,7,8,5,6,5,4,null,5,null,null,null,null,null,null,null,3,1,6,9,4,8,2,null,null,null,null,null,null,8,6,5,7,9,2,3,4]
[null,null,null,null,39,null,null,null,null,null,null,null,null,null,null,40,null,null,null,null,null,null,null,null,null,null,null,null,null,15,null,null,null,null,null,null,null,null,null,null,null,null,null,41]
[null,null,null,null,12,null,null,null,null,null,null,null,null,null,null,4,null,null,null,null,null,null,null,null,null,null,null,null,null,6,null,null,null,null,null,null,null,null,null,null,null,null,null,5]
[null,null,null,null,3,null,null,null,null,null,null,null,null,null,null,4,null,null,null,null,null,null,null,null,null,null,null,null,null,6,null,null,null,null,null,null,null,null,null,null,null,null,null,5]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,9,null,5,null,4]
[null,null,null,null,28,null,null,null,null,null,null,null,null,null,null,29,null,null,null,null,null,null,null,null,null,null,null,null,null,18,null,null,null,null,null,null,null,null,null,null,null,null,null,25]
[null,null,null,null,10,null,null,null,null,null,null,null,null,null,null,11,null,null,null,null,null,null,null,null,null,null,null,null,null,9,null,null,null,null,null,null,null,null,null,null,null,null,null,7]
[null,null,null,null,1,null,null,null,null,null,null,null,null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,null,null,9,null,null,null,null,null,null,null,null,null,null,null,null,null,7]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13,"aaaaa"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14,"bbbbbbbbbbbbb"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15,"ccccccccc"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,16,"dddddddddddd"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18,"eeeeeeeeee"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,19,"fffffffffff"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,26,"gggggggggggg"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,33,"hhhhhhhhhhhhh"]

{"sheet":"Résultat","index":1,"n_rows":5,"n_cols":7,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,13,"aaaaa"]
[null,"Nombre de chiffres collectés",8,null,null,15,"ccccccccc"]
[null,null,null,null,null,16,"dddddddddddd"]
[null,"Nombre de chiffres différents collectés",5,null,null,18,"eeeeeeeeee"]
[null,null,null,null,null,26,"gggggggggggg"]

{"sheet":"Résultat ancien","index":2,"n_rows":28,"n_cols":9,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
[null,null,"Titre de la Fiche",null,null,null,null,"= phrase sans variable"]
["Prendre 5 fiches qui correspondent au nombre de chiffres récapitulés",null,null,null,null,null,null,"Eb rouge = le nombre de chiffres différents collectés => dans la liste des 8 nombres (Feuil1 plage X77 à X84)"]
["Chiffres numéros : 13 - 15 - 16 - 18 - 26 -  -  - ",null,null,null,null,null,null,"=> les chiffres en rouge correspondent au résultats collectés dans \"Feuil1\" par ordre croissant"]
["(Noter sur chaque fiche un numéro)",null,null,null,null,null,null,"= phrase sans variable"]
["Ranger ces fiches numérotées avec 5 qsdf qfdf hjj khllm.....",null,null,null,null,null,null,"En rouge = le nombre de chiffres différents collectés => dans la liste des 8 nombres (Feuil1 plage X77 à X84)"]
["Phrase sans variable sur la ligne 6",null,null,null,null,null,null,"= phrase sans variable"]
["Chiffres numéros : 13 - 15 - 16 - 18 - 26 -  -  - ",null,null,null,null,null,null,"=> les chiffres en rouge correspondent au résultat collecté dans \"Feuil1\" par ordre croissant"]
[null,13,{"$f":"IFERROR(VLOOKUP(B8,Feuil1!X77:Y84,2,0),\"\")","v":"aaaaa"}]
[null,15,{"$f":"IFERROR(VLOOKUP(B9,Feuil1!X78:Y85,2,0),\"\")","v":"ccccccccc"},null,null,null,null,null,"=> dans la colonne, classement des nombres par ordre croissant"]
[null,16,{"$f":"IFERROR(VLOOKUP(B10,Feuil1!X79:Y86,2,0),\"\")","v":"dddddddddddd"}]
[null,18,{"$f":"IFERROR(VLOOKUP(B11,Feuil1!X80:Y87,2,0),\"\")","v":"eeeeeeeeee"}]
[null,26,{"$f":"IFERROR(VLOOKUP(B12,Feuil1!X81:Y88,2,0),\"\")","v":"gggggggggggg"}]
[null,null,{"$f":"IFERROR(VLOOKUP(B13,Feuil1!X82:Y89,2,0),\"\")","v":""}]
[null,null,{"$f":"IFERROR(VLOOKUP(B14,Feuil1!X83:Y90,2,0),\"\")","v":""}]
[null,null,{"$f":"IFERROR(VLOOKUP(B15,Feuil1!X84:Y91,2,0),\"\")","v":""}]
[null,null,{"$f":"IFERROR(VLOOKUP(B16,Feuil1!X85:Y92,2,0),\"\")","v":""}]
["Phrase sans variable sur la ligne 17",null,null,null,null,null,null,"= phrase sans variable"]
["Phrase sans variable sur la ligne 18",null,null,null,null,null,null,"= phrase sans variable"]
[]
[null,"ò"]
[null,"ò"]
[null,"= Exemple de résultat de la collecte des différents chiffres s'ils correspondent à ceux de la liste de la plage X77 à X84"]
[]
[]
["La feuille ci-dessus comprend du texte \"fixe\" entre (..) ainsi que du texte variable qui est le résultat de la sélection effectuée et doit garder cette mise en forme"]
[]
[]
[null,null,null,null,"ggggg"]

{"sheet":"Calculs","index":3,"n_rows":89,"n_cols":16,"rows_kept":89,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,42,null,12,null,null,null,null,null,null,null,12]
[null,null,null,null,null,47,null,null,null,25,null,null,null,47]
[]
[]
[]
[]
[]
[null,null,30,null,null,null,null,null,null,null,30]
[]
[]
[null,null,null,null,null,null,42,null,null,null,null,null,null,null,42]
[]
[]
[]
[]
[null,null,null,25,null,null,50,null,52,null,null,25,null,null,50]
[]
[]
[]
[]
[58,null,68,null,92,null,76,null,58,null,68,null,92,null,76]
[]
[]
[]
[null,42,null,null,null,12,null,null,null,null,null,null,12]
[null,null,null,25,null,null,null,47,null,null,25,null,null,null,47]
[]
[]
[]
[null,50]
[]
[null,null,null,null,30,null,null,null,null,null,null,30]
[]
[]
[null,76,null,null,null,null,null,null,42,null,null,null,null,null,null,42]
[17]
[]
[]
[]
[null,null,52,null,null,25,null,null,50,52,null,null,25,null,null,50]
[]
[]
[]
[]
[17,null,58,null,68,null,92,null,76,58,null,68,null,92,null,76]
[]
[]
["Liste des différents chiffres collectés si cette étape est nécessaire avant restitution du résultat dans l'onglet \"résultat"]
[22,{"$f":"IF(OR(A51=13,A51=14,A51=15,A51=16,A51=18,A51=19,A51=26,A51=33),A51,\"\")","v":""},13,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(N51=13,N51=14,N51=15,N51=16,N51=18,N51=19,N51=26,N51=33),N51,\"\")","v":""}]
[18,{"$f":"IF(OR(A52=13,A52=14,A52=15,A52=16,A52=18,A52=19,A52=26,A52=33),A52,\"\")","v":18},15]
[53,"",16]
[2,"",18]
[11,"",26]
[39,""]
[12,""]
[28,""]
[10,""]
[3,""]
[12,""]
[49,""]
[13,13]
[26,26]
[7,""]
[2,""]
[11,""]
[40,""]
[4,""]
[29,""]
[11,"",{"$f":"COUNTIF(C51:C58,\"<>\")","v":5}]
[2,""]
[11,""]
[39,""]
[11,""]
[29,""]
[9,""]
[6,""]
[13,13]
[15,15]
[6,""]
[18,18]
[9,""]
[7,""]
[16,16]
[41,""]
[5,""]
[25,""]
[7,""]

{"sheet":"BDD","index":4,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}