{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Technique","Facturation"],"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":12,"n_cols":15,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
["Contact","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"]
[null,"Mme","Florence","Laforge",null,"En cours","Française",null,"Paris","2016-10-01",null,"CST 2 ans","2016-08-01",{"$f":"IF(ISBLANK($M3),\"\",$M3+VLOOKUP($L3,#REF!,2,FALSE))","v":{"$error":"#REF!"}},"Avec épouse"]
[null,"M.","Thibault","DEMADE",null,"En cours","Française",null,null,null,null,"CST 5 ans","2016-07-01",{"$f":"IF(ISBLANK($M4),\"\",$M4+VLOOKUP($L4,#REF!,2,FALSE))","v":{"$error":"#REF!"}}]
[null,"M.","Ryan","BEVENOT",null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK($M5),\"\",$M5+VLOOKUP($L5,#REF!,2,FALSE))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK($M6),\"\",$M6+VLOOKUP($L6,#REF!,2,FALSE))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK($M7),\"\",$M7+VLOOKUP($L7,#REF!,2,FALSE))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK($M8),\"\",$M8+VLOOKUP($L8,#REF!,2,FALSE))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK($M9),\"\",$M9+VLOOKUP($L9,#REF!,2,FALSE))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK($M10),\"\",$M10+VLOOKUP($L10,#REF!,2,FALSE))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK($M11),\"\",$M11+VLOOKUP($L11,#REF!,2,FALSE))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK($M12),\"\",$M12+VLOOKUP($L12,#REF!,2,FALSE))","v":""}]

{"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,#REF!,2,FALSE),\"\")","v":""},null,null,null,{"$f":"IFERROR(IF(I3<>\"Traduction\",VLOOKUP(I3,#REF!,2,FALSE),VLOOKUP(K3,#REF!,2,FALSE)),)","v":0}]
[null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(E4,#REF!,2,FALSE),\"\")","v":""},null,null,null,{"$f":"IFERROR(IF(I4<>\"Traduction\",VLOOKUP(I4,#REF!,2,FALSE),VLOOKUP(K4,#REF!,2,FALSE)),)","v":0}]
[null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(E5,#REF!,2,FALSE),\"\")","v":""},null,null,null,{"$f":"IFERROR(IF(I5<>\"Traduction\",VLOOKUP(I5,#REF!,2,FALSE),VLOOKUP(K5,#REF!,2,FALSE)),)","v":0}]
[null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(E6,#REF!,2,FALSE),\"\")","v":""},null,null,null,{"$f":"IFERROR(IF(I6<>\"Traduction\",VLOOKUP(I6,#REF!,2,FALSE),VLOOKUP(K6,#REF!,2,FALSE)),)","v":0}]
[null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(E7,#REF!,2,FALSE),\"\")","v":""},null,null,null,{"$f":"IFERROR(IF(I7<>\"Traduction\",VLOOKUP(I7,#REF!,2,FALSE),VLOOKUP(K7,#REF!,2,FALSE)),)","v":0}]
[null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(E8,#REF!,2,FALSE),\"\")","v":""},null,null,null,{"$f":"IFERROR(IF(I8<>\"Traduction\",VLOOKUP(I8,#REF!,2,FALSE),VLOOKUP(K8,#REF!,2,FALSE)),)","v":0}]
[null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(E9,#REF!,2,FALSE),\"\")","v":""},null,null,null,{"$f":"IFERROR(IF(I9<>\"Traduction\",VLOOKUP(I9,#REF!,2,FALSE),VLOOKUP(K9,#REF!,2,FALSE)),)","v":0}]
[null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(E10,#REF!,2,FALSE),\"\")","v":""},null,null,null,{"$f":"IFERROR(IF(I10<>\"Traduction\",VLOOKUP(I10,#REF!,2,FALSE),VLOOKUP(K10,#REF!,2,FALSE)),)","v":0}]
[null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(E11,#REF!,2,FALSE),\"\")","v":""}]
[null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(E12,#REF!,2,FALSE),\"\")","v":""}]
[null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(E13,#REF!,2,FALSE),\"\")","v":""}]
[null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(E14,#REF!,2,FALSE),\"\")","v":""}]
[null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(E15,#REF!,2,FALSE),\"\")","v":""}]
[null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(E16,#REF!,2,FALSE),\"\")","v":""}]
[null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(E17,#REF!,2,FALSE),\"\")","v":""}]
[null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(E18,#REF!,2,FALSE),\"\")","v":""}]