{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Consolidé","Factures Réalisées","Facturation"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":1,"defined_names":1,"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":"Consolidé","index":0,"n_rows":38,"n_cols":52,"rows_kept":38,"cut":false,"hidden":false,"merged":[[35,5,36,6],[37,5,37,6],[37,8,37,10],[8,41,8,43],[8,45,8,47],[17,5,17,6],[17,8,17,9],[19,8,19,9],[21,8,21,9],[20,5,20,6],[19,5,19,6],[21,5,21,6],[19,20,19,21],[21,20,21,21],[17,11,17,12],[17,14,17,15],[34,1,34,3],[34,5,34,6],[34,8,34,10],[1,1,1,3],[1,49,1,51],[1,25,1,27],[1,29,1,31],[1,33,1,35],[1,37,1,39],[1,41,1,43],[1,45,1,47],[1,21,1,23],[1,5,1,7],[1,9,1,11],[1,13,1,15],[1,17,1,19],[8,49,8,51],[16,1,16,3],[16,5,16,9],[16,17,16,21],[13,1,14,21],[8,21,8,23],[8,25,8,27],[8,29,8,31],[8,33,8,35],[8,37,8,39],[8,1,8,3],[8,5,8,7],[8,9,8,11],[8,13,8,15],[16,11,16,15],[8,17,8,19],[17,17,17,18],[17,20,17,21],[19,17,19,18],[21,17,21,18],[19,11,19,12],[21,11,21,12],[19,14,19,15],[21,14,21,15],[25,1,26,21],[28,1,28,3],[28,5,28,6],[29,5,29,6],[31,5,31,6],[28,8,28,13]]}
[]
[]
[null,"CA Global","Marge WOW","Marge SJTC",null,"CA Global","Marge WOW","Marge SJTC",null,"CA Global","Marge WOW","Marge SJTC",null,"CA Global","Marge WOW","Marge SJTC",null,"CA Global","Marge WOW","Marge SJTC",null,"CA Global","Marge WOW","Marge SJTC",null,"CA Global","Marge WOW","Marge SJTC",null,"CA Global","Marge WOW","Marge SJTC",null,"CA Global","Marge WOW","Marge SJTC",null,"CA Global","Marge WOW","Marge SJTC",null,"CA Global","Marge WOW","Marge SJTC",null,"CA Global","Marge WOW","Marge SJTC",null,"CA Global","Marge WOW","Marge SJTC"]
[]
["Free-Lance",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,{"$f":"AT5+AP5+AL5+AH5+AD5+Z5+V5+R5+N5+J5+F5+B5","v":0},{"$f":"AU5+AQ5+AM5+AI5+AE5+AA5+W5+S5+O5+K5+G5+C5","v":0},{"$f":"AV5+AR5+AN5+AJ5+AF5+AB5+X5+T5+P5+L5+H5+D5","v":0}]
[]
["Recrutement",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,{"$f":"AT7+AP7+AL7+AH7+AD7+Z7+V7+R7+N7+J7+F7+B7","v":0},{"$f":"AU7+AQ7+AM7+AI7+AE7+AA7+W7+S7+O7+K7+G7+C7","v":0},{"$f":"AV7+AR7+AN7+AJ7+AF7+AB7+X7+T7+P7+L7+H7+D7","v":0}]
[]
["Previsionnel"]
[null,"Hono Global","Marge WOW","Marge SJTC",null,"Hono Global","Marge WOW","Marge SJTC",null,"Hono Global","Marge WOW","Marge SJTC",null,"Hono Global","Marge WOW","Marge SJTC",null,"Hono Global","Marge WOW","Marge SJTC",null,"Hono Global","Marge WOW","Marge SJTC",null,"Hono Global","Marge WOW","Marge SJTC",null,"Hono Global","Marge WOW","Marge SJTC",null,"Hono Global","Marge WOW","Marge SJTC",null,"Hono Global","Marge WOW","Marge SJTC",null,"Hono Global","Marge WOW","Marge SJTC",null,"Hono Global","Marge WOW","Marge SJTC",null,"Hono Global","Marge WOW","Marge SJTC"]
[]
["Free-Lance",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,{"$f":"AT12+AP12+AL12+AH12+AD12+Z12+V12+R12+N12+J12+F12+B12","v":0},{"$f":"AU12+AQ12+AM12+AI12+AE12+AA12+W12+S12+O12+K12+G12+C12","v":0},{"$f":"AV12+AR12+AN12+AJ12+AF12+AB12+X12+T12+P12+L12+H12+D12","v":0}]
[]
[null,"Recapitulatif Exercice "]
[]
[]
[null,"Prévisionnel /an",null,null,null,"Facturé/Payé WOW",null,null,null,null,null,"Facturé/en Attente WOW",null,null,null,null,null,"En cous Non Facturé WOW"]
[null,"CA Global","Marge WOW","Marge SJTC",null,"CA Global ",null,null,"Marge SJTC Facturé",null,null,"CA Global ",null,null,"Marge SJTC Facturé en Att",null,null,"CA Global ",null,null,"Marge SJTC Non Facturé"]
[]
["Free-Lance",{"$f":"AX12","v":0},{"$f":"AY12","v":0},{"$f":"AZ12","v":0}]
[null,null,null,null,null,"Hono Global"]
["Recrutement"]
[]
[]
[]
[null,"Synthese Fin d'exercice Free-Lance"]
[]
[]
[null,"Prévisionnel /an",null,null,null,"Taux Accord Part SJTC",null,null,"Taux Variables"]
[null,"CA Global","Marge WOW","Marge SJTC",null,"Taux Facturation annuelle",null,null,"0/15K€","15/30K€","30/60K€","60/90K€","90/120K€",">120K€"]
[]
[null,{"$f":"AX12","v":0},{"$f":"AY12","v":0},{"$f":"AZ12","v":0},null,60,null,null,59,62,65,67,69,71]
[]
[]
[null,null,null,null,null,"Actualisation selon Taux Variables",null,null,"Solde après Taux Variables"]
[null,"CA Global",null,"Marge SJTC"]
[]
[null,{"$f":"F20","v":0},null,{"$f":"I20","v":0}]

{"sheet":"Factures Réalisées","index":1,"n_rows":3,"n_cols":7,"rows_kept":3,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[]
[null,"N° Facture","Date de facturation","Client","Payée","Date de paiement","Montant"]

{"sheet":"Facturation","index":2,"n_rows":39,"n_cols":11,"rows_kept":39,"cut":false,"hidden":false,"merged":[[38,1,38,8],[2,2,2,4],[2,8,2,10],[4,1,9,4],[4,8,9,10],[10,5,10,7],[12,2,12,3],[12,4,12,5],[12,6,12,7]]}
[]
[]
[null,null,"Fac 2108001 WOW"]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,{"$f":"TODAY()","v":"2021-09-21"}]
[]
[null,"Date debut de contrat","Nom",null,"Prénom",null,"Facturation du .. au...",null,"Libéllé",null,"Montant "]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,{"$f":"IF(E22=\"\",\"\",LOOKUP(E22,'[1]Fichier Freelance'!A10:A129,'[1]Fichier Freelance'!B10:B66))","v":""}]
[null,null,null,null,null,{"$f":"IF(E23=\"\",\"\",LOOKUP(E23,'[1]Fichier Freelance'!A11:A130,'[1]Fichier Freelance'!B11:B67))","v":""}]
[null,null,null,null,null,{"$f":"IF(E24=\"\",\"\",LOOKUP(E24,'[1]Fichier Freelance'!A12:A131,'[1]Fichier Freelance'!B12:B68))","v":""}]
[null,null,null,null,null,{"$f":"IF(E25=\"\",\"\",LOOKUP(E25,'[1]Fichier Freelance'!A13:A132,'[1]Fichier Freelance'!B13:B69))","v":""}]
[null,null,null,null,null,{"$f":"IF(E26=\"\",\"\",LOOKUP(E26,'[1]Fichier Freelance'!A14:A133,'[1]Fichier Freelance'!B14:B70))","v":""}]
[null,null,null,null,null,{"$f":"IF(E27=\"\",\"\",LOOKUP(E27,'[1]Fichier Freelance'!A16:A135,'[1]Fichier Freelance'!B16:B72))","v":""}]
[null,null,null,null,null,{"$f":"IF(E28=\"\",\"\",LOOKUP(E28,'[1]Fichier Freelance'!A17:A136,'[1]Fichier Freelance'!B17:B73))","v":""}]
[null,null,null,null,null,{"$f":"IF(E29=\"\",\"\",LOOKUP(E29,'[1]Fichier Freelance'!A18:A137,'[1]Fichier Freelance'!B18:B74))","v":""}]
[null,null,null,null,null,{"$f":"IF(E30=\"\",\"\",LOOKUP(E30,'[1]Fichier Freelance'!A19:A138,'[1]Fichier Freelance'!B19:B75))","v":""}]
[null,null,null,null,null,{"$f":"IF(E31=\"\",\"\",LOOKUP(E31,'[1]Fichier Freelance'!A20:A139,'[1]Fichier Freelance'!B20:B76))","v":""}]
[null,null,null,null,null,{"$f":"IF(E32=\"\",\"\",LOOKUP(E32,'[1]Fichier Freelance'!A21:A140,'[1]Fichier Freelance'!B21:B77))","v":""}]
[null,null,null,null,null,{"$f":"IF(E33=\"\",\"\",LOOKUP(E33,'[1]Fichier Freelance'!A22:A141,'[1]Fichier Freelance'!B22:B78))","v":""}]
[null,null,null,null,null,{"$f":"IF(E34=\"\",\"\",LOOKUP(E34,'[1]Fichier Freelance'!A23:A142,'[1]Fichier Freelance'!B23:B79))","v":""}]
[null,null,null,null,null,{"$f":"IF(E35=\"\",\"\",LOOKUP(E35,'[1]Fichier Freelance'!A24:A143,'[1]Fichier Freelance'!B24:B80))","v":""}]
[null,null,null,null,null,{"$f":"IF(E36=\"\",\"\",LOOKUP(E36,'[1]Fichier Freelance'!A25:A144,'[1]Fichier Freelance'!B25:B81))","v":""}]
[null,null,null,null,null,{"$f":"IF(E37=\"\",\"\",LOOKUP(E37,'[1]Fichier Freelance'!A29:A148,'[1]Fichier Freelance'!B29:B85))","v":""}]
[null,null,null,null,null,null,null,null,null,"Total",{"$f":"K16+K17","v":0}]
[null," TVA non applicable - article 293 B du CGI"]