{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Feuil4","Feuil2","Signataires","Archives signataires"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":1,"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":"Feuil4","index":0,"n_rows":9,"n_cols":14,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["code barre","code ean","dimension","plaque","nom ","telephone","reprise dimension","choix taxe","prix ttc","entrer code ean","entrer plaque"]
[{"$f":"VLOOKUP(J2,'[1]Générateur de code barres'!A2:C49,2,FALSE)","v":"3FCSRKM*dgfejg+"},{"$f":"J2","v":3528702365496},{"$f":"VLOOKUP(J2,'[1]Générateur de code barres'!A2:E49,5,FALSE)","v":"155/80TR13"},{"$f":"VLOOKUP(K2,[1]Feuil2!A1:K7,1,FALSE)","v":"1-EHB-965"},{"$f":"VLOOKUP(K2,[1]Feuil2!A1:K7,2,FALSE)","v":"ADJUST"},{"$f":"VLOOKUP(K2,[1]Feuil2!A1:K7,11,FALSE)","v":"02/655,63,00"},16,4.7699999999999996,{"$f":"(G2+(G2*0.21))+H2","v":24.13},3528702365496,"1-EHB-965"]
[null,null,null,null,null,null,null,null,null,null,null,null,15,2.86]
[null,null,null,null,null,null,null,null,null,null,null,null,16,4.7699999999999996]
[null,null,null,null,null,null,null,null,null,null,null,null,17]
[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,19]
[null,null,null,null,null,null,null,null,null,null,null,null,20]
[null,null,null,null,null,null,null,null,null,null,null,null,21]

{"sheet":"Feuil2","index":1,"n_rows":7,"n_cols":11,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["1-FQZ-GGG","AAA1","ROAD","HIVER","215/55 R16 97V",5,7,"2016-04-22","P7E",null,0]
["1-FQZ-GGG","AAA2","FULD","HIVER","195/65 R15 91T",6,4,"2018-04-04","13B",75,0]
["1-FQZ-GGG","AAA3","DUN","HIVER","195/65 R15 91T",8,6,"2017-03-20","4A",55,0]
["1-FQZ-GGG","AAA4","BL","HIVR","195/65 R15 91T",5,6,"2017-04-27","19B",null,0]
["1-FQZ-GGG","AAA5","GOOD","HIVER","245/40 R18 97V",6,6,"2017-02-21","5E",null,0]
["1-FQZ-GGG","AAA6","GOOD","HIVER","185/65 R15 88T",1,6,"2017-03-17","CO2B",null,0]
["1-FQZ-GGG","AAA7","FI","HIVER","165/70 R14 81T",3,5,"2015-04-04","P12D",null,0]

{"sheet":"Signataires","index":2,"n_rows":8,"n_cols":20,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["cc","cc","cc","cccc","cccc","ccc","ccccc","ccccc","ccc","cccc",null,null,null,null,null,null,null,"cc","xxxxxxxxxxx","ccccggg"]
["PLAQUE","NOM","PRENOM","TELEPHONE","REMARQUE","REMARQUE","certifié","Marque","Véhicule","Taille","Type","LI","SI","Runflat","Code EAN","Saison",null,null,null,"Votre prix HT EUR"]
["Aeh","E","C","EN","1b",2,"suspendu",43101,"2018-02-01","2018-02-01",null,null,null,null,null,null,null,"RETRAITE",26,"2018-02-04"]
["AEh","E","C","EN","1b",3,"suspendu","2018-01-01","2018-02-01","2018-02-01",null,null,null,null,null,null,null,"RETRAITE",27,"2018-02-05"]
["Aehh","E","C","EN","1b",4,"suspendu","2018-01-01","2018-02-01","2018-02-01",null,null,null,null,null,null,null,"RETRAITE",28,"2018-02-06"]
["hhh","E","C","EN","1b",4,"suspendu","2018-01-02","2018-02-02","2018-02-02",null,null,null,null,null,null,null,"RETRAITE",28,"2018-02-07"]
["FFJ",null,null,"EN","1b",9,"suspendu","2018-01-02","2018-02-02","2018-02-02",null,null,null,null,5400777704036,null,null,"RETRAITE",{"$f":"MID(O7,1,1)&CHAR(MID(O7,2,1)+65)&CHAR(MID(O7,3,1)+IF(ISNA(MATCH(VALUE(MID(O7,1,1)),{0;1;2;3},0)),75,65))&CHAR(MID(O7,4,1)+IF(ISNA(MATCH(VALUE(MID(O7,1,1)),{0;4;7;8},0)),75,65))&CHAR(MID(O7,5,1)+IF(ISNA(MATCH(VALUE(MID(O7,1,1)),{0;1;4;5;9},0)),75,65))&CHAR(MID(O7,6,1)+IF(ISNA(MATCH(VALUE(MID(O7,1,1)),{0;2;5;6;7},0)),75,65))&CHAR(MID(O7,7,1)+IF(ISNA(MATCH(VALUE(MID(O7,1,1)),{1;4;6;8;9},0)),75,65))&\"*\"&CHAR(MID(O7,8,1)+97)&CHAR(MID(O7,9,1)+97)&CHAR(MID(O7,10,1)+97)&CHAR(MID(O7,11,1)+97)&CHAR(MID(O7,12,1)+97)&CHAR(MID(O7,13,1)+97)&\"+\"","v":"5EKKHHR*haeadg+"}]
["DDSD",null,null,"EN","1b",11,"suspendu","2018-01-02","2018-02-02","2018-02-02",null,null,null,null,5400777704036,null,null,"RETRAITE",{"$f":"MID(O8,1,1)&CHAR(MID(O8,2,1)+65)&CHAR(MID(O8,3,1)+IF(ISNA(MATCH(VALUE(MID(O8,1,1)),{0;1;2;3},0)),75,65))&CHAR(MID(O8,4,1)+IF(ISNA(MATCH(VALUE(MID(O8,1,1)),{0;4;7;8},0)),75,65))&CHAR(MID(O8,5,1)+IF(ISNA(MATCH(VALUE(MID(O8,1,1)),{0;1;4;5;9},0)),75,65))&CHAR(MID(O8,6,1)+IF(ISNA(MATCH(VALUE(MID(O8,1,1)),{0;2;5;6;7},0)),75,65))&CHAR(MID(O8,7,1)+IF(ISNA(MATCH(VALUE(MID(O8,1,1)),{1;4;6;8;9},0)),75,65))&\"*\"&CHAR(MID(O8,8,1)+97)&CHAR(MID(O8,9,1)+97)&CHAR(MID(O8,10,1)+97)&CHAR(MID(O8,11,1)+97)&CHAR(MID(O8,12,1)+97)&CHAR(MID(O8,13,1)+97)&\"+\"","v":"5EKKHHR*haeadg+"}]

{"sheet":"Archives signataires","index":3,"n_rows":13,"n_cols":20,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["NOM ","Prénom","Atelier","règlement","licence","catégorie","certifié","Marque","Véhicule","Taille","Type","LI","SI","Runflat","Code EAN","Saison",null,null,null,"Votre prix HT EUR"]
["AD","D","M","FR","1b",1,"non","2018-01-01","2018-12-12",null,null,null,null,null,null,null,null,"RAS"]
["AC","C","M","EN","1a",1,"non","2018-01-01","2018-02-01","2018-02-01",null,null,null,null,null,null,null,"DEPART",24,"2018-02-02"]
["AF","F","C","FR","1a",1,"non","2018-01-01","2018-12-12",null,null,null,null,null,null,null,null,"RAS"]
["AA","A","C","FR","1a",1,"non","2018-01-01","2018-12-12",null,null,null,null,null,null,null,null,"RAS"]
["Ael","E","C","EN","1b",1,"non","2018-01-01","2018-02-01","2018-02-01",null,null,null,null,null,null,null,"RETRAITE",25,"2018-02-03"]
["ffff",null,null,null,null,null,"non",null,null,null,null,null,null,null,null,null,null,null,"3FCSRKT*jffbac+",3528709955102]
["gggg","E","C","EN","1b",4,"non","2018-01-03","2018-02-03","2018-02-03",null,null,null,null,null,null,null,"RETRAITE","3FCSRKM*dgfejg+",3528702365496]
["ffffffff","E","C","EN","1b",4,"non","2018-01-04","2018-02-04","2018-02-04",null,null,null,null,null,null,null,"RETRAITE","3FCSRKR*gahfjb+",3528707607591]
["uuuuu","E","C","EN","1b",4,"non","2018-01-06","2018-02-06","2018-02-06",null,null,null,null,null,null,null,"RETRAITE","5EKKBEL*bgdjfh+",5400141163957]
["ttt","E","C","EN","1b",4,"non","2018-01-05","2018-02-05","2018-02-05",null,null,null,null,null,null,null,"RETRAITE","5EKKBEL*bgdjfh+",5400141163957]
["AB","B","M","FR","1a",1,"non","2018-01-01","2018-02-01","2018-02-01",null,null,null,null,null,null,null,"DEPART","5EKKBEL*ceghci+",5400141246728]
["FF",null,null,"EN","1b",8,"non","2018-01-02","2018-02-02","2018-02-02",null,null,null,null,5600380892773,null,null,"RETRAITE","5GKKDIK*ijchhd+",5400141246728]