{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Création","Etiquettes","données formulaires"],"not_rendered":{"charts":0,"images":6,"macros":1,"external_links":0,"defined_names":14,"comments":1,"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":"Création","index":0,"n_rows":32,"n_cols":14,"rows_kept":32,"cut":false,"hidden":false,"merged":[[17,12,17,13],[17,10,17,11],[17,0,17,1],[17,2,17,3],[0,2,0,3],[0,0,0,1],[0,5,0,6],[0,7,0,8],[17,5,17,6],[17,7,17,8],[0,10,0,11],[0,12,0,13]]}
["Etiquette numéro 1",null,1,null,null,"Etiquette numéro 2",null,2,null,null,"Etiquette numéro 3",null,3]
[]
["Type d'étiquette","Grande",{"$f":"IF(B3=\"Grande\",1,IF(B3=\"Petite\",2,3))","v":1},{"$f":"IF(C3=1,\"Grande\",IF(C3=2,\"Petite\",\"-\"))","v":"Grande"},null,"Type d'étiquette",null,{"$f":"IF(G3=\"Grande\",1,IF(G3=\"Petite\",2,3))","v":3},{"$f":"IF(H3=1,\"Grande\",IF(H3=2,\"Petite\",\"-\"))","v":"-"},null,"Type d'étiquette","Grande",{"$f":"IF(L3=\"Grande\",1,IF(L3=\"Petite\",2,3))","v":1},{"$f":"IF(M3=1,\"Grande\",IF(M3=2,\"Petite\",\"-\"))","v":"Grande"}]
[]
["Nom de l'enrteprise","SE",null,null,null,"Nom de l'enrteprise",null,null,null,null,"Nom de l'enrteprise","E20"]
[]
["Concerne",null,null,null,null,"Concerne",null,null,null,null,"Concerne"]
[]
["Catégorie",null,null,null,null,"Catégorie",null,null,null,null,"Catégorie"]
[]
["Année",null,null,null,null,"Année",null,null,null,null,"Année"]
[]
["Nombre de classeur",null,null,null,null,"Nombre de classeur",null,null,null,null,"Nombre de classeur"]
[]
["Classeur N°",null,null,null,null,"Classeur N°",null,null,null,null,"Classeur N°"]
[]
[]
["Etiquette numéro 4",null,4,null,null,"Etiquette numéro 5",null,5,null,null,"Etiquette numéro 6",null,6]
[]
["Type d'étiquette","Petite",{"$f":"IF(B20=\"Grande\",1,IF(B20=\"Petite\",2,3))","v":2},{"$f":"IF(C20=1,\"Grande\",IF(C20=2,\"Petite\",\"-\"))","v":"Petite"},null,"Type d'étiquette","Petite",{"$f":"IF(G20=\"Grande\",1,IF(G20=\"Petite\",2,3))","v":2},{"$f":"IF(H20=1,\"Grande\",IF(H20=2,\"Petite\",\"-\"))","v":"Petite"},null,"Type d'étiquette",null,{"$f":"IF(L20=\"Grande\",1,IF(L20=\"Petite\",2,3))","v":3},{"$f":"IF(M20=1,\"Grande\",IF(M20=2,\"Petite\",\"-\"))","v":"-"}]
[]
["Nom de l'enrteprise","E20",null,null,null,"Nom de l'enrteprise","SE",null,null,null,"Nom de l'enrteprise"]
[]
["Concerne",null,null,null,null,"Concerne",null,null,null,null,"Concerne"]
[]
["Catégorie",null,null,null,null,"Catégorie",null,null,null,null,"Catégorie"]
[]
["Année",null,null,null,null,"Année",null,null,null,null,"Année"]
[]
["Nombre de classeur",null,null,null,null,"Nombre de classeur",null,null,null,null,"Nombre de classeur"]
[]
["Classeur N°",null,null,null,null,"Classeur N°",null,null,null,null,"Classeur N°"]

{"sheet":"Etiquettes","index":1,"n_rows":66,"n_cols":110,"rows_kept":66,"cut":false,"hidden":false,"merged":[[6,17,12,30],[13,49,30,62],[6,49,12,62],[32,48,32,63],[33,48,34,60],[25,109,30,128],[13,33,30,46],[6,33,12,46],[64,53,64,61],[65,53,66,58],[65,59,66,61],[6,81,12,94],[13,81,30,94],[13,65,30,78],[6,65,12,78],[37,53,38,61],[39,53,39,61],[40,54,62,60],[33,80,34,92],[33,93,34,95],[32,80,32,95],[32,64,32,79],[33,64,34,76],[33,77,34,79],[65,33,66,38],[65,39,66,41],[37,43,38,51],[39,43,39,51],[40,44,62,50],[64,43,64,51],[65,43,66,48],[65,49,66,51],[37,33,38,41],[39,33,39,41],[40,34,62,40],[64,33,64,41],[2,80,4,95],[2,0,4,15],[2,16,4,31],[2,32,4,47],[2,48,4,63],[2,64,4,79],[6,1,12,14],[37,2,38,10],[39,2,39,10],[40,3,62,9],[33,0,34,12],[33,13,34,15],[32,0,32,15],[37,12,38,20],[39,12,39,20],[33,16,34,28],[32,16,32,31],[37,22,38,30],[39,22,39,30],[40,23,62,29],[40,13,62,19],[13,17,30,30],[62,109,67,128],[64,2,64,10],[65,2,66,7],[65,8,66,10],[13,1,30,14],[64,12,64,20],[65,12,66,17],[65,18,66,20],[33,61,34,63],[33,29,34,31],[32,32,32,47],[33,32,34,44],[33,45,34,47],[64,22,64,30],[65,22,66,27],[65,28,66,30]]}
[]
[]
[{"$f":"IF(AND(Création!C3=1,Création!D3=\"Grande\"),Création!B5,\" \")","v":"SE"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(Création!H3=1,Création!I3=\"Grande\"),Création!G5,\" \")","v":" "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(Création!M3=1,Création!N3=\"Grande\"),Création!L5,\" \")","v":"E20"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(Création!C20=1,Création!D20=\"Grande\"),Création!B22,\" \")","v":" "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(Création!H20=1,Création!I20=\"Grande\"),Création!G22,\" \")","v":" "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(Création!M20=1,Création!N20=\"Grande\"),Création!L22,\" \")","v":" "}]
[]
[]
[]
[null,{"$f":"IF(A3=\" \",\" \",HLOOKUP(Etiquettes!A3,Création!B5:B13,3,1))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Q3=\" \",\" \",HLOOKUP(Q3,Création!G5:G15,3,1))","v":" "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AG3=\" \",\" \",HLOOKUP(AG3,Création!L5:L15,3,1))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AW3=\" \",\" \",HLOOKUP(AW3,Création!B22:B32,3,1))","v":" "},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,{"$f":"IF(CC3=\" \",\" \",HLOOKUP(CC3,Création!L22:L32,3,1))","v":" "}]
[]
[]
[]
[]
[]
[]
[null,{"$f":"IF(A3=\" \",\" \",HLOOKUP(A3,Création!B5:B13,5,1))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Q3=\" \",\" \",HLOOKUP(Q3,Création!G5:G15,5,1))","v":" "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AG3=\" \",\" \",HLOOKUP(AG3,Création!L5:L15,5,1))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AW3=\" \",\" \",HLOOKUP(AW3,Création!B22:B32,5,1))","v":" "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(BM3=\" \",\" \",HLOOKUP(BM3,Création!G22:G32,5,1))","v":" "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(CC3=\" \",\" \",HLOOKUP(CC3,Création!L22:L32,5,1))","v":" "}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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,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,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,"Cliquer sur l'image pour imprimer les GRANDES étiquettes"]
[]
[]
[]
[]
[]
[]
[{"$f":"IF(A3=\" \",\" \",VLOOKUP(A3,'données formulaires'!B3:C27,2,0))","v":"SE"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Q3=\" \",\" \",VLOOKUP(Q3,'données formulaires'!B3:C27,2,0))","v":" "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AG3=\" \",\" \",VLOOKUP(AG3,'données formulaires'!B3:C27,2,0))","v":"E2"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AW3=\" \",\" \",VLOOKUP(AW3,'données formulaires'!B3:C27,2,0))","v":" "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(BM3=\" \",\" \",VLOOKUP(BM3,'données formulaires'!B3:C27,2,0))","v":" "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(CC3=\" \",\" \",VLOOKUP(CC3,'données formulaires'!B3:C27,2,0))","v":" "}]
[{"$f":"IF(A3=\" \",\" \",HLOOKUP(A3,Création!B5:B13,7,1))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(A3=\" \",\" \",CONCATENATE(HLOOKUP(A3,Création!B5:B15,11,1),\"/\",HLOOKUP(A3,Création!B5:B15,9,1)))","v":"/"},null,null,{"$f":"IF(Q3=\" \",\" \",HLOOKUP(Q3,Création!G5:G15,7,1))","v":" "},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Q3=\" \",\" \",CONCATENATE(HLOOKUP(Q3,Création!G5:G15,11,1),\"/\",HLOOKUP(Q3,Création!G5:G15,9,1)))","v":" "},null,null,{"$f":"IF(AG3=\" \",\" \",HLOOKUP(AG3,Création!L5:L15,7,1))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AG3=\" \",\" \",CONCATENATE(HLOOKUP(AG3,Création!L5:L15,11,1),\"/\",HLOOKUP(AG3,Création!L5:L15,9,1)))","v":"/"},null,null,{"$f":"IF(AW3=\" \",\" \",HLOOKUP(AW3,Création!B22:B32,7,1))","v":" "},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AW3=\" \",\" \",CONCATENATE(HLOOKUP(AW3,Création!B22:B32,11,1),\"/\",HLOOKUP(AW3,Création!B22:B32,9,1)))","v":" "},null,null,{"$f":"IF(BM3=\" \",\" \",HLOOKUP(BM3,Création!G22:G32,7,1))","v":" "},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(BM3=\" \",\" \",CONCATENATE(HLOOKUP(BM3,Création!G22:G32,11,1),\"/\",HLOOKUP(BM3,Création!G22:G32,9,1)))","v":" "},null,null,{"$f":"IF(CC3=\" \",\" \",HLOOKUP(CC3,Création!L22:L32,7,1))","v":" "},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(CC3=\" \",\" \",CONCATENATE(HLOOKUP(CC3,Création!L22:L32,11,1),\"/\",HLOOKUP(CC3,Création!L22:L32,9,1)))","v":" "}]
[]
[]
[]
[null,null,{"$f":"IF(AND(Création!C3=2,Création!D3=\"Petite\"),Création!B5,\" \")","v":" "},null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(Création!H3=2,Création!I3=\"Petite\"),Création!G5,\" \")","v":" "},null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(Création!M3=2,Création!N3=\"Petite\"),Création!L5,\" \")","v":" "},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(Création!C20=2,Création!D20=\"Petite\"),Création!B22,\" \")","v":"E20"},null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(Création!H20=2,Création!I20=\"Petite\"),Création!G22,\" \")","v":"SE"},null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(Création!M20=2,Création!N20=\"Petite\"),Création!L22,\" \")","v":" "}]
[]
[null,null,{"$f":"IF(C38=\" \",\" \",HLOOKUP(Etiquettes!C38,Création!B5:B13,3,1))","v":" "},null,null,null,null,null,null,null,null,null,{"$f":"IF(M38=\" \",\" \",HLOOKUP(Etiquettes!M38,Création!G5:G13,3,1))","v":" "},null,null,null,null,null,null,null,null,null,{"$f":"IF(W38=\" \",\" \",HLOOKUP(Etiquettes!W38,Création!L5:L13,3,1))","v":" "},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AH38=\" \",\" \",HLOOKUP(Etiquettes!AH38,Création!B22:B32,3,1))","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(AR38=\" \",\" \",HLOOKUP(Etiquettes!AR38,Création!G22:G32,3,1))","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(BB38=\" \",\" \",HLOOKUP(Etiquettes!BB38,Création!L22:L32,3,1))","v":" "}]
[null,null,null,{"$f":"IF(C38=\" \",\" \",HLOOKUP(Etiquettes!C38,Création!B5:B13,5,1))","v":" "},null,null,null,null,null,null,null,null,null,{"$f":"IF(M38=\" \",\" \",HLOOKUP(Etiquettes!M38,Création!G5:G13,5,1))","v":" "},null,null,null,null,null,null,null,null,null,{"$f":"IF(W38=\" \",\" \",HLOOKUP(Etiquettes!W38,Création!L5:L13,5,1))","v":" "},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AH38=\" \",\" \",HLOOKUP(Etiquettes!AH38,Création!B22:B32,5,1))","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(AR38=\" \",\" \",HLOOKUP(Etiquettes!AR38,Création!G22:G32,5,1))","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(BB38=\" \",\" \",HLOOKUP(Etiquettes!BB38,Création!L22:L32,5,1))","v":" "}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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,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,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,"Cliquer sur l'image pour imprimer les PETITES étiquettes"]
[]
[null,null,{"$f":"IF(C38=\" \",\" \",VLOOKUP(C38,'données formulaires'!B3:C28,2,0))","v":" "},null,null,null,null,null,null,null,null,null,{"$f":"IF(M38=\" \",\" \",VLOOKUP(M38,'données formulaires'!B3:C27,2,0))","v":" "},null,null,null,null,null,null,null,null,null,{"$f":"IF(W38=\" \",\" \",VLOOKUP(W38,'données formulaires'!B3:C27,2,0))","v":" "},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AH38=\" \",\" \",VLOOKUP(AH38,'données formulaires'!B3:C27,2,0))","v":"E2"},null,null,null,null,null,null,null,null,null,{"$f":"IF(AR38=\" \",\" \",VLOOKUP(AR38,'données formulaires'!B3:C27,2,0))","v":"SE"},null,null,null,null,null,null,null,null,null,{"$f":"IF(BB38=\" \",\" \",VLOOKUP(BB38,'données formulaires'!B3:C27,2,0))","v":" "}]
[null,null,{"$f":"IF(C38=\" \",\" \",HLOOKUP(C38,Création!B5:B13,7,1))","v":" "},null,null,null,null,null,{"$f":"IF(C38=\" \",\" \",CONCATENATE(HLOOKUP(C38,Création!B5:B15,11,1),\"/\",HLOOKUP(C38,Création!B5:B15,9,1)))","v":" "},null,null,null,{"$f":"IF(M38=\" \",\" \",HLOOKUP(M38,Création!G5:G15,7,1))","v":" "},null,null,null,null,null,{"$f":"IF(M38=\" \",\" \",CONCATENATE(HLOOKUP(M38,Création!G5:G15,11,1),\"/\",HLOOKUP(M38,Création!G5:G15,9,1)))","v":" "},null,null,null,{"$f":"IF(W38=\" \",\" \",HLOOKUP(W38,Création!L5:L15,7,1))","v":" "},null,null,null,null,null,{"$f":"IF(W38=\" \",\" \",CONCATENATE(HLOOKUP(W38,Création!L5:L15,11,1),\"/\",HLOOKUP(W38,Création!L5:L15,9,1)))","v":" "},null,null,null,null,{"$f":"IF(AH38=\" \",\" \",HLOOKUP(AH38,Création!B22:B32,7,1))","v":0},null,null,null,null,null,{"$f":"IF(AH38=\" \",\" \",CONCATENATE(HLOOKUP(AH38,Création!B22:B32,11,1),\"/\",HLOOKUP(AH38,Création!B22:B32,9,1)))","v":"/"},null,null,null,{"$f":"IF(AR38=\" \",\" \",HLOOKUP(AR38,Création!G22:G32,7,1))","v":0},null,null,null,null,null,{"$f":"IF(AR38=\" \",\" \",CONCATENATE(HLOOKUP(AR38,Création!G22:G32,11,1),\"/\",HLOOKUP(AR38,Création!G22:G32,9,1)))","v":"/"},null,null,null,{"$f":"IF(BB38=\" \",\" \",HLOOKUP(BB38,Création!L22:L32,7,1))","v":" "},null,null,null,null,null,{"$f":"IF(BB38=\" \",\" \",CONCATENATE(HLOOKUP(BB38,Création!L22:L32,11,1),\"/\",HLOOKUP(BB38,Création!L22:L32,9,1)))","v":" "}]

{"sheet":"données formulaires","index":2,"n_rows":44,"n_cols":10,"rows_kept":44,"cut":false,"hidden":false,"merged":[[51,33,51,41],[51,43,51,51],[51,53,51,61],[52,2,52,10],[52,12,52,20],[52,22,52,30],[52,33,52,41],[52,43,52,51],[52,53,52,61],[51,22,51,30],[49,33,49,41],[49,43,49,51],[49,53,49,61],[50,2,50,10],[50,33,50,41],[50,43,50,51],[50,53,50,61],[49,12,50,20],[49,22,50,30],[65,7,66,7],[65,8,66,8],[49,2,49,10],[51,2,51,10],[51,12,51,20],[41,9,42,24],[43,9,43,24],[2,18,3,18],[2,19,3,19],[2,20,3,20],[35,9,35,24],[37,9,38,17],[39,9,39,17],[2,21,3,21],[2,22,3,22],[2,23,3,23],[2,16,3,16],[2,24,3,24],[2,25,3,25],[33,25,34,25],[2,26,3,26],[33,26,34,26],[33,9,34,24],[2,17,3,17],[29,9,30,17],[31,9,31,17],[2,27,3,27],[33,27,34,27],[2,28,3,28],[33,28,34,28],[2,29,3,29],[33,29,34,29],[2,30,3,30],[33,30,34,30],[2,31,3,31],[33,31,34,31],[2,32,3,32],[33,32,34,32],[2,33,3,33],[33,33,34,33],[2,34,3,34],[33,34,34,34],[2,35,3,35],[33,35,34,35]]}
[]
["Type d'etitquette","Entreprise","Initiale","Couleur"]
["Grande","SE","SE"]
["Petite","E20","E2"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"-"]
[]
[]
[null,null,null,"-"]
[]
[]
[null,null,null,"-"]
[]
[]
[null,"Personnel","-"]
[]
[null,null,null,null,null,null,null,null,null,"RR"]
[]
[null,null,null,null,null,null,null,null,null,"privé"]
[]
[null,null,null,null,null,null,null,null,null,"RR"]
[]
[null,null,null,null,null,null,null,null,null,"Parc immobilier"]
[]
[null,null,null,null,null,null,null,null,null,"Groupe RR"]
[]
[null,null,null,null,null,null,null,null,null,"Banques"]
[]
[null,null,null,null,null,null,null,null,null,"E2O innovations SA"]
[]
[null,null,null,null,null,null,null,null,null,"Permanent"]