{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Technique","Facturation","SOUS-TRAITANCE","Fichier source technique","Références clients"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"Technique","index":0,"n_rows":44,"n_cols":16,"rows_kept":44,"cut":false,"hidden":false,"merged":[]}
[]
["Contact Taj","Civilité","Nom","Prénom","Nom client","État du dossier","Nationalité","Statut immigration/prestation","Préfecture","RDV Préfecture","Récepissé date d'expiration","Type carte de séjour","Date obtention carte de séjour","Date expiration  carte de séjour","Commentaires","CTRL"]
["EDW","Mme","KKKK","LLLL","Akzo Nobel N.V. - SS - DA / NHu",null,null,"Carte bleue européenne",null,null,null,null,null,{"$f":"IF(ISBLANK($M3),\"\",$M3+VLOOKUP($L3,'Fichier source technique'!$K$2:$L$10,2,FALSE))","v":""},null,{"$f":"COUNTA($A3:$O3)","v":7}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTA($A4:$O4)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]

{"sheet":"Facturation","index":1,"n_rows":18,"n_cols":16,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[]
["AF","Civilité","Nom prénom","Prénom","Nom client","Code projet","Statut immigration/prestation","Nature de la prestation","Prestation","Montant prestation","N° demande d'achat","Adresse facturation","Référence","Contact","N° FA","Date"]
[null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(E3,'Références clients'!$A$3:$B$68,2,FALSE),\"\")","v":""},null,null,null,{"$f":"IFERROR(IF(I3<>\"Traduction\",VLOOKUP(I3,#REF!,2,FALSE),VLOOKUP(K3,'SOUS-TRAITANCE'!$F$1:$G$50,2,FALSE)),)","v":0}]
[null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(E4,'Références clients'!$A$3:$B$68,2,FALSE),\"\")","v":""},null,null,null,{"$f":"IFERROR(IF(I4<>\"Traduction\",VLOOKUP(I4,#REF!,2,FALSE),VLOOKUP(K4,'SOUS-TRAITANCE'!$F$1:$G$50,2,FALSE)),)","v":0}]
[null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(E5,'Références clients'!$A$3:$B$68,2,FALSE),\"\")","v":""},null,null,null,{"$f":"IFERROR(IF(I5<>\"Traduction\",VLOOKUP(I5,#REF!,2,FALSE),VLOOKUP(K5,'SOUS-TRAITANCE'!$F$1:$G$50,2,FALSE)),)","v":0}]
[null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(E6,'Références clients'!$A$3:$B$68,2,FALSE),\"\")","v":""},null,null,null,{"$f":"IFERROR(IF(I6<>\"Traduction\",VLOOKUP(I6,#REF!,2,FALSE),VLOOKUP(K6,'SOUS-TRAITANCE'!$F$1:$G$50,2,FALSE)),)","v":0}]
[null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(E7,'Références clients'!$A$3:$B$68,2,FALSE),\"\")","v":""},null,null,null,{"$f":"IFERROR(IF(I7<>\"Traduction\",VLOOKUP(I7,#REF!,2,FALSE),VLOOKUP(K7,'SOUS-TRAITANCE'!$F$1:$G$50,2,FALSE)),)","v":0}]
[null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(E8,'Références clients'!$A$3:$B$68,2,FALSE),\"\")","v":""},null,null,null,{"$f":"IFERROR(IF(I8<>\"Traduction\",VLOOKUP(I8,#REF!,2,FALSE),VLOOKUP(K8,'SOUS-TRAITANCE'!$F$1:$G$50,2,FALSE)),)","v":0}]
[null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(E9,'Références clients'!$A$3:$B$68,2,FALSE),\"\")","v":""},null,null,null,{"$f":"IFERROR(IF(I9<>\"Traduction\",VLOOKUP(I9,#REF!,2,FALSE),VLOOKUP(K9,'SOUS-TRAITANCE'!$F$1:$G$50,2,FALSE)),)","v":0}]
[null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(E10,'Références clients'!$A$3:$B$68,2,FALSE),\"\")","v":""},null,null,null,{"$f":"IFERROR(IF(I10<>\"Traduction\",VLOOKUP(I10,#REF!,2,FALSE),VLOOKUP(K10,'SOUS-TRAITANCE'!$F$1:$G$50,2,FALSE)),)","v":0}]
[null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(E11,'Références clients'!$A$3:$B$68,2,FALSE),\"\")","v":""}]
[null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(E12,'Références clients'!$A$3:$B$68,2,FALSE),\"\")","v":""}]
[null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(E13,'Références clients'!$A$3:$B$68,2,FALSE),\"\")","v":""}]
[null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(E14,'Références clients'!$A$3:$B$68,2,FALSE),\"\")","v":""}]
[null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(E15,'Références clients'!$A$3:$B$68,2,FALSE),\"\")","v":""}]
[null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(E16,'Références clients'!$A$3:$B$68,2,FALSE),\"\")","v":""}]
[null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(E17,'Références clients'!$A$3:$B$68,2,FALSE),\"\")","v":""}]
[null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(E18,'Références clients'!$A$3:$B$68,2,FALSE),\"\")","v":""}]

{"sheet":"SOUS-TRAITANCE","index":2,"n_rows":16,"n_cols":8,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[]
["Nom Prénom","Nom client","Code projet","Type document traduit","N°facture fournisseur","N° demande achat","Montant","Date soumission"]
[null,"Akzo Nobel N.V. - SS - DA / NHu",{"$f":"IFERROR(VLOOKUP(B3,'Références clients'!$A$3:$B$70,2,FALSE),\"-\")","v":"AKZ0010216_02"},null,null,12435,230]
[null,null,{"$f":"IFERROR(VLOOKUP(B4,'Références clients'!$A$3:$B$70,2,FALSE),\"-\")","v":"-"}]
[null,null,{"$f":"IFERROR(VLOOKUP(B5,'Références clients'!$A$3:$B$70,2,FALSE),\"-\")","v":"-"}]
[null,null,{"$f":"IFERROR(VLOOKUP(B6,'Références clients'!$A$3:$B$70,2,FALSE),\"-\")","v":"-"}]
[null,null,{"$f":"IFERROR(VLOOKUP(B7,'Références clients'!$A$3:$B$70,2,FALSE),\"-\")","v":"-"}]
[null,null,{"$f":"IFERROR(VLOOKUP(B8,'Références clients'!$A$3:$B$70,2,FALSE),\"-\")","v":"-"}]
[null,null,{"$f":"IFERROR(VLOOKUP(B9,'Références clients'!$A$3:$B$70,2,FALSE),\"-\")","v":"-"}]
[null,null,{"$f":"IFERROR(VLOOKUP(B10,'Références clients'!$A$3:$B$70,2,FALSE),\"-\")","v":"-"}]
[null,null,{"$f":"IFERROR(VLOOKUP(B11,'Références clients'!$A$3:$B$70,2,FALSE),\"-\")","v":"-"}]
[null,null,{"$f":"IFERROR(VLOOKUP(B12,'Références clients'!$A$3:$B$70,2,FALSE),\"-\")","v":"-"}]
[null,null,{"$f":"IFERROR(VLOOKUP(B13,'Références clients'!$A$3:$B$70,2,FALSE),\"-\")","v":"-"}]
[null,null,{"$f":"IFERROR(VLOOKUP(B14,'Références clients'!$A$3:$B$70,2,FALSE),\"\")","v":""}]
[null,null,{"$f":"IFERROR(VLOOKUP(B15,'Références clients'!$A$3:$B$70,2,FALSE),\"\")","v":""}]
[null,null,{"$f":"IFERROR(VLOOKUP(B16,'Références clients'!$A$3:$B$70,2,FALSE),\"\")","v":""}]

{"sheet":"Fichier source technique","index":3,"n_rows":39,"n_cols":12,"rows_kept":39,"cut":false,"hidden":false,"merged":[]}
["A facturer",null,"Contact Taj",null,"Civilité",null,"État du dossier",null,"Statut immigration / prestation",null,"Type carte de séjour","Nbre de jours"]
["X",null,"EDW",null,"M.",null,"Annulé",null,"Carte bleue européenne",null,"CST 1 an",365]
["P",null,"SKH",null,"Mme",null,"En cours",null,"Rnvt - Carte bleue européenne",null,"CST 3 ans",1095]
[null,null,"NHU",null,null,null,"Rnvlt à prévoir",null,"Carte compétence et talents",null,"CST 2 ans",{"$f":"365*2","v":730}]
[null,null,null,null,null,null,"Reparti",null,"Rnvt - Carte compétence et talents",null,"CST 5 ans",1825]
[null,null,null,null,null,null,"Terminé",null,"Changement de statut",null,"VISA 6 mois",182]
[null,null,null,null,null,null,"Terminé : a quitté la sté",null,"Conjoint CEE",null,"VISA 1 an",365]
[null,null,null,null,null,null,"Terminé : rnvlt fait par sté",null,"Rnvt - Conjoint CEE ",null,"CR 10 ans",3650]
[null,null,null,null,null,null,null,null,"SEMD < 3 mois"]
[null,null,null,null,null,null,null,null,"Prestataire UE"]
[null,null,null,null,null,null,null,null,"Rnvt - Prestataire UE"]
[null,null,null,null,null,null,null,null,"Prestataire non UE"]
[null,null,null,null,null,null,null,null,"Rnvt - Prestataire non UE "]
[null,null,null,null,null,null,null,null,"Salarié standard"]
[null,null,null,null,null,null,null,null,"Rnvt - Salarié standard"]
[null,null,null,null,null,null,null,null,"SEMS"]
[null,null,null,null,null,null,null,null,"Rnvt - SEMS"]
[null,null,null,null,null,null,null,null,"SEMD"]
[null,null,null,null,null,null,null,null,"Rnvt - SEMD"]
[null,null,null,null,null,null,null,null,"Vie privée - vie de famille"]
[null,null,null,null,null,null,null,null,"Rnvt - Vie privée - vie de famille"]
[null,null,null,null,null,null,null,null,"Visiteur"]
[null,null,null,null,null,null,null,null,"Rnvt - Visiteur "]
[null,null,null,null,null,null,null,null,"Visiteur - couple"]
[null,null,null,null,null,null,null,null,"Rnvt - Visiteur - couple"]
[null,null,null,null,null,null,null,null,"UE"]
[null,null,null,null,null,null,null,null,"UE - Rnvt"]
[null,null,null,null,null,null,null,null,"Commerçant"]
[null,null,null,null,null,null,null,null,"Rnvt - Commerçant"]
[null,null,null,null,null,null,null,null,"DCEM"]
[null,null,null,null,null,null,null,null,"Rnvt - DCEM"]
[null,null,null,null,null,null,null,null,"Visa OUT"]
[null,null,null,null,null,null,null,null,"Echange permis de conduire"]
[null,null,null,null,null,null,null,null,"Déclaration de détachement"]
[null,null,null,null,null,null,null,null,"Conseil"]
[null,null,null,null,null,null,null,null,"Assistance complémentaire"]
[null,null,null,null,null,null,null,null,"Statut exceptionel"]
[null,null,null,null,null,null,null,null,"Course Taj"]
[null,null,null,null,null,null,null,null,"Traduction"]

{"sheet":"Références clients","index":4,"n_rows":60,"n_cols":2,"rows_kept":60,"cut":false,"hidden":false,"merged":[]}
["Code client","Référence client"]
[]
["Akzo Nobel N.V. - SS - DA / NHu","AKZ0010216_02"]
["ALCOA - SS - DA / NHu","ALC0480115"]
["AMERICAN EXPRESS COMPANY - SS - DA / NHu","AME0320116_01"]
["Aon - SS - DA / NHu","AON0030115_03"]
["APPLE Inc. - SS - DA / NHu","APP0400116_02"]
["AW Europe SA - IMMI - DA / NHu","AWE0020116_01"]
["BEKAERT SA - IMMI - DA / NHu","BEK0080116_02"]
["Blue Spark Energy Inc. - IMMI - DA / NHu","BLU0520116_01"]
["CAMERON CHARLES - SS - DA / NHu","CAM1500116_01"]
["Campbell Lutyens & Co Ltd - SS - DA / NHu","CAM1890116"]
["Chanel Ltd - SS - DA / NHu","CHA5040116"]
["COCA COLA - SS - DA / NHu","COC0250114_01"]
["DATADOG INC. - IMMI - DA/NHU","DAT0460116_01"]
["Diageo Great Britain Ltd - SS - DA / NHu","DIA1170116_01"]
["Dunnhumby Ltd - SS - DA / NHu","DUN0160116_03"]
["E.ON Human Resources Int. Gmbh - SS - DA / NHu","ECO0510116_01"]
["Ecolab Inc. - SS - DA / NHu","EON0110116_01"]
["EXXONMOBIL CHEMICAL FRANCE - IMMI - DA / NHu","EXX0040115_01"]
["EXXONMOBIL CHEMICAL FRANCE - SS - DA / NHu","EXX0040115_02"]
["FMC Technologies Inc. - IMMI - DA / NHu","FMC0100116_02"]
["Hewlett Packard Inc. - SS - DA / NHu","HEW0070116_01"]
["HSBC France - SS - DA / NHu","CCF0010215"]
["HSBC FRANCE- IMMI - DA / NHu","CCF0010315"]
["Hunter Douglas N.V. - SS - DA / NHu","HUN0250116_01"]
["IMPERIAL TOBACCO GROUP - IMMI - DA / NHu","IMP0220115"]
["IMPERIAL TOBACCO Group PLC - SS - DA / NHU","IMP0750115"]
["JAB INVESTMENTS Sarl - SS - DA / NHu","JAB0070115_02"]
["JGC CORPORATION - IMMI - DA / NHu","JGC0050115"]
["JOHNSON & JOHNSON - SS - DA / NHu","JOH0150116_01"]
["Johnson Controls - SS - DA / NHu","JOH0230115_04"]
["Laureate Education, Inc. - SS - DA / NHu","LAU0410115"]
["LEVER TOUCH SRL- IMMI - DA / NHu","LEV0510116_01"]
["MARS - SS - DA / NHu","MAR3180115_01"]
["MDS AERO SUPPORT - IMMI - DA / SFi","MDS0030115_02"]
["Nike European Operations Nether. BV- SS - DA / NHu","NIK0080116_01"]
["NNR GLOBAL LOGISTICS - IMSS -  DA / NHu","NIS0030115"]
["PHILIPS N.V - IMMI - DA / NHu","KON0200116_03"]
["PHILIPS N.V - SS - DA / NHu","KON0200116_02"]
["Primetals Technologies France SAS- IMMI - DA / NHu","PRI1610216_01"]
["QIAGEN GmbH - SS - DA / NHu","QIA0010116_01"]
["RBB ECONOMICS FRANCE LLP - IMMI - DA / NHu","RBB0040216_01"]
["Reckitt Benckiser France - IMMI - DA / NHu","BEN0140116_01"]
["Rolls-Royce Int. Ltd - IMMI - DA / NHu","ROL0630116_01"]
["SANOFI AVENTIS GROUPE - SS - DA / NHu","SAN0480116_01"]
["Sealed Air Corporation - SS - DA / NHu","SEA0740116_01"]
["SHV HOLDINGS N.V - SS -  DA / SFi","SHV0040116_01"]
["SOMIC ISHIKAWA INC. - IMMI - DA / NHu","SOM0730115"]
["SONY EUROPE LTD - SS - DA / NHu","SON0590116_02"]
["Suntory France - SS - DA / NHu","SUN0850116_02"]
["TELEKOM ROMANIA - IMMI - DA / NHu","ROM0260116_01"]
["TETRA PAK - SS - DA / NHu","TET0200115_02"]
["TEXAS INSTRUMENT INC. - SS - DA / NHu","TEX0460115_04"]
["THBS Ltd - IMMI - DA / NHu","TOR0300116_01"]
["Toyota Motor Europe - IMMI - DA / NHu","TOY0050116_02"]
["UNILEVER PLC - IMMI - DA / NHu","UNI3710116_04"]
["VERMEER CANADA INC. - IMMI - DA / NHu","VER1650116"]
["Volvo Personvagnar AB - SS - DA / NHu","VOL0370116"]
["Whirlpool France SAS - SS - DA / NHu","WHI0100116_01"]