{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["MODOP","N°factures","FACTURATION JANVIER 2019","MODELE"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"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":"MODOP","index":0,"n_rows":15,"n_cols":1,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[]
[]
["N°factures"]
["Inscrire le n° de facture de départ dans la cellule A1 de la feuille \"N°factures\""]
[]
["FACTURES"]
["Garder une feuille de facture (comme \"Modèle\")"]
["Renommer cette feuille avec le n° de facture de départ (ex: 2019-71)"]
[]
["Cliquer sur le bouton \"Nouvelle facture\""]
["Taper le nombre de facture souhaité (ex:50) => création automatique de 51 factures"]
[]
["Pour créer de nouvelles factures, il faut TOUJOURS se positionner sur la dernière facture créée"]
[]
["La feuille \"FACTURATION\" est un récapitulatif des factures créées et s'alimente automatique. Elle a une capacité de 70 factures, revenir vers nous si besoin d'augmenter le nombres de factures"]

{"sheet":"N°factures","index":1,"n_rows":70,"n_cols":2,"rows_kept":70,"cut":false,"hidden":false,"merged":[]}
[null,"2019-01"]
[1,{"$f":"LEFT($B$1,LEN($B$1)-LEN(VALUE(LEFT($B$1,2))+A2))&VALUE(RIGHT($B$1,2))+A2","v":"2019-2"}]
[2,{"$f":"LEFT($B$1,LEN($B$1)-LEN(VALUE(LEFT($B$1,2))+A3))&VALUE(RIGHT($B$1,2))+A3","v":"2019-3"}]
[3,"2019-4"]
[4,"2019-5"]
[5,"2019-6"]
[6,"2019-7"]
[7,"2019-8"]
[8,"2019-9"]
[9,"2019-10"]
[10,"2019-11"]
[11,"2019-12"]
[12,"2019-13"]
[13,"2019-14"]
[14,"2019-15"]
[15,"2019-16"]
[16,"2019-17"]
[17,"2019-18"]
[18,"2019-19"]
[19,"2019-20"]
[20,"2019-21"]
[21,"2019-22"]
[22,"2019-23"]
[23,"2019-24"]
[24,"2019-25"]
[25,"2019-26"]
[26,"2019-27"]
[27,"2019-28"]
[28,"2019-29"]
[29,"2019-30"]
[30,"2019-31"]
[31,"2019-32"]
[32,"2019-33"]
[33,"2019-34"]
[34,"2019-35"]
[35,"2019-36"]
[36,"2019-37"]
[37,"2019-38"]
[38,"2019-39"]
[39,"2019-40"]
[40,"2019-41"]
[41,"2019-42"]
[42,"2019-43"]
[43,"2019-44"]
[44,"2019-45"]
[45,"2019-46"]
[46,"2019-47"]
[47,"2019-48"]
[48,"2019-49"]
[49,"2019-50"]
[50,"2019-51"]
[51,"2019-52"]
[52,"2019-53"]
[53,"2019-54"]
[54,"2019-55"]
[55,"2019-56"]
[56,"2019-57"]
[57,"2019-58"]
[58,"2019-59"]
[59,"2019-60"]
[60,"2019-61"]
[61,"2019-62"]
[62,"2019-63"]
[63,"2019-64"]
[64,"2019-65"]
[65,"2019-66"]
[66,{"$f":"LEFT($B$1,LEN($B$1)-LEN(VALUE(LEFT($B$1,2))+A67))&VALUE(RIGHT($B$1,2))+A67","v":"2019-67"}]
[67,"2019-68"]
[68,"2019-69"]
[69,"2019-70"]

{"sheet":"FACTURATION JANVIER 2019","index":2,"n_rows":78,"n_cols":14,"rows_kept":78,"cut":false,"hidden":false,"merged":[[1,10,1,12],[1,2,2,5]]}
[]
[null,null,"SYNTHESE DE LA FACTURATION MENSUELLE - ",null,null,null,null,null,null,null,"Facturation TTC totale du mois"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L9:L78)","v":{"$error":"#REF!"}}]
[]
[]
["Dates des factures","N° des factures","Nom des clients","Libellés des factures","Montants HT (Prestations 5%)","Montants TVA (Prestations 5%)","Montants HT (Prestations 13%)","Montants TVA (Prestations 13%)","Montants HT (Ventes 16%)","Montants TVA (Prestation 16%)","Débours / Divers","Montant total TTC","Modes de règlement","Dates de règlement"]
[{"$f":"IF($B9=0,\"\",INDIRECT(\"'\"&$B9&\"'!B$15\"))","v":{"$error":"#REF!"}},{"$f":"N°factures!B1","v":"2019-01"},{"$f":"IF($B9=0,\"\",INDIRECT(\"'\"&$B9&\"'!F$16\"))","v":{"$error":"#REF!"}},{"$f":"IF(INDIRECT(\"'\"&$B9&\"'!E$27\")>0,\"Saut MOZ / \",\"\")&IF(INDIRECT(\"'\"&$B9&\"'!E$28\")>0,\"Saut BOR / \",\"\")&IF(INDIRECT(\"'\"&$B9&\"'!E$29\")>0,\" VIDEO / \",\"\")&IF(INDIRECT(\"'\"&$B9&\"'!E$30\")>0,\" DIV / \",\"\")&IF(INDIRECT(\"'\"&$B9&\"'!E$31\")>0,\" ACCESS / \",\"\")&IF(INDIRECT(\"'\"&$B9&\"'!E$33\")>0,\" DEB\",\"\")","v":{"$error":"#REF!"}},{"$f":"IF($B9=0,\"\",INDIRECT(\"'\"&$B9&\"'!H$38\"))","v":{"$error":"#REF!"}},{"$f":"IF(E9=\"\",\"\",+E9*0.05)","v":{"$error":"#REF!"}},{"$f":"IF($B9=0,\"\",INDIRECT(\"'\"&$B9&\"'!H$39\"))","v":{"$error":"#REF!"}},{"$f":"IF(G9=\"\",\"\",+G9*0.13)","v":{"$error":"#REF!"}},{"$f":"IF($B9=0,\"\",INDIRECT(\"'\"&$B9&\"'!H$40\"))","v":{"$error":"#REF!"}},{"$f":"IF(I9=\"\",\"\",I9*0.16)","v":{"$error":"#REF!"}},{"$f":"IF($B9=0,\"\",INDIRECT(\"'\"&$B9&\"'!H$41\"))","v":{"$error":"#REF!"}},{"$f":"IF(B9=0,\"\",(E9+F9+G9+H9+I9+J9+K9))","v":{"$error":"#REF!"}},{"$f":"IF($B9=0,\"\",INDIRECT(\"'\"&$B9&\"'!B$46\"))","v":{"$error":"#REF!"}},{"$f":"IF($B9=0,\"\",INDIRECT(\"'\"&$B9&\"'!B$47\"))","v":{"$error":"#REF!"}}]
[{"$f":"IF($B10=0,\"\",INDIRECT(\"'\"&$B10&\"'!B$15\"))","v":{"$error":"#REF!"}},{"$f":"N°factures!B2","v":"2019-2"},{"$f":"IF($B10=0,\"\",INDIRECT(\"'\"&$B10&\"'!F$16\"))","v":{"$error":"#REF!"}},{"$f":"IF(INDIRECT(\"'\"&$B10&\"'!E$27\")>0,\"Saut MOZ / \",\"\")&IF(INDIRECT(\"'\"&$B10&\"'!E$28\")>0,\"Saut BOR / \",\"\")&IF(INDIRECT(\"'\"&$B10&\"'!E$29\")>0,\" VIDEO / \",\"\")&IF(INDIRECT(\"'\"&$B10&\"'!E$30\")>0,\" DIV / \",\"\")&IF(INDIRECT(\"'\"&$B10&\"'!E$31\")>0,\" ACCESS / \",\"\")&IF(INDIRECT(\"'\"&$B10&\"'!E$33\")>0,\" DEB\",\"\")","v":{"$error":"#REF!"}},{"$f":"IF($B10=0,\"\",INDIRECT(\"'\"&$B10&\"'!H$38\"))","v":{"$error":"#REF!"}},{"$f":"IF(E10=\"\",\"\",+E10*0.05)","v":{"$error":"#REF!"}},{"$f":"IF($B10=0,\"\",INDIRECT(\"'\"&$B10&\"'!H$39\"))","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"IF($B10=0,\"\",INDIRECT(\"'\"&$B10&\"'!H$40\"))","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"IF($B10=0,\"\",INDIRECT(\"'\"&$B10&\"'!H$41\"))","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"IF($B10=0,\"\",INDIRECT(\"'\"&$B10&\"'!B$46\"))","v":{"$error":"#REF!"}},{"$f":"IF($B10=0,\"\",INDIRECT(\"'\"&$B10&\"'!B$47\"))","v":{"$error":"#REF!"}}]
[{"$f":"IF($B11=0,\"\",INDIRECT(\"'\"&$B11&\"'!B$15\"))","v":{"$error":"#REF!"}},{"$f":"N°factures!B3","v":"2019-3"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$error":"#REF!"},{"$f":"N°factures!B4","v":"2019-4"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$error":"#REF!"},{"$f":"N°factures!B5","v":"2019-5"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$error":"#REF!"},{"$f":"N°factures!B6","v":"2019-6"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$error":"#REF!"},{"$f":"N°factures!B7","v":"2019-7"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$error":"#REF!"},{"$f":"N°factures!B8","v":"2019-8"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$error":"#REF!"},{"$f":"N°factures!B9","v":"2019-9"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$error":"#REF!"},{"$f":"N°factures!B10","v":"2019-10"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$error":"#REF!"},{"$f":"N°factures!B11","v":"2019-11"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$error":"#REF!"},{"$f":"N°factures!B12","v":"2019-12"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$error":"#REF!"},{"$f":"N°factures!B13","v":"2019-13"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$error":"#REF!"},{"$f":"N°factures!B14","v":"2019-14"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$error":"#REF!"},{"$f":"N°factures!B15","v":"2019-15"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$error":"#REF!"},{"$f":"N°factures!B16","v":"2019-16"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$error":"#REF!"},{"$f":"N°factures!B17","v":"2019-17"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$error":"#REF!"},{"$f":"N°factures!B18","v":"2019-18"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$error":"#REF!"},{"$f":"N°factures!B19","v":"2019-19"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$error":"#REF!"},{"$f":"N°factures!B20","v":"2019-20"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$error":"#REF!"},{"$f":"N°factures!B21","v":"2019-21"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$error":"#REF!"},{"$f":"N°factures!B22","v":"2019-22"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$error":"#REF!"},{"$f":"N°factures!B23","v":"2019-23"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$error":"#REF!"},{"$f":"N°factures!B24","v":"2019-24"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$error":"#REF!"},{"$f":"N°factures!B25","v":"2019-25"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$error":"#REF!"},{"$f":"N°factures!B26","v":"2019-26"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$error":"#REF!"},{"$f":"N°factures!B27","v":"2019-27"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$error":"#REF!"},{"$f":"N°factures!B28","v":"2019-28"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$error":"#REF!"},{"$f":"N°factures!B29","v":"2019-29"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$error":"#REF!"},{"$f":"N°factures!B30","v":"2019-30"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$error":"#REF!"},{"$f":"N°factures!B31","v":"2019-31"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$error":"#REF!"},{"$f":"N°factures!B32","v":"2019-32"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$error":"#REF!"},{"$f":"N°factures!B33","v":"2019-33"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$error":"#REF!"},{"$f":"N°factures!B34","v":"2019-34"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$error":"#REF!"},{"$f":"N°factures!B35","v":"2019-35"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$error":"#REF!"},{"$f":"N°factures!B36","v":"2019-36"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$error":"#REF!"},{"$f":"N°factures!B37","v":"2019-37"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$error":"#REF!"},{"$f":"N°factures!B38","v":"2019-38"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$error":"#REF!"},{"$f":"N°factures!B39","v":"2019-39"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$error":"#REF!"},{"$f":"N°factures!B40","v":"2019-40"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$error":"#REF!"},{"$f":"N°factures!B41","v":"2019-41"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$error":"#REF!"},{"$f":"N°factures!B42","v":"2019-42"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$error":"#REF!"},{"$f":"N°factures!B43","v":"2019-43"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$error":"#REF!"},{"$f":"N°factures!B44","v":"2019-44"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$error":"#REF!"},{"$f":"N°factures!B45","v":"2019-45"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$error":"#REF!"},{"$f":"N°factures!B46","v":"2019-46"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$error":"#REF!"},{"$f":"N°factures!B47","v":"2019-47"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$error":"#REF!"},{"$f":"N°factures!B48","v":"2019-48"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$error":"#REF!"},{"$f":"N°factures!B49","v":"2019-49"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$error":"#REF!"},{"$f":"N°factures!B50","v":"2019-50"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$error":"#REF!"},{"$f":"N°factures!B51","v":"2019-51"},{"$f":"IF($B59=0,0,INDIRECT(\"'\"&$B59&\"'!F$16\"))","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(E59=\"\",\"\",+E59*0.05)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"IF(G59=\"\",\"\",+G59*0.13)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"IF(I59=\"\",\"\",I59*0.16)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"IF(B59=0,\"\",(E59+F59+G59+H59+I59+J59+K59))","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$error":"#REF!"},{"$f":"N°factures!B52","v":"2019-52"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(E60=\"\",\"\",+E60*0.05)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"IF(G60=\"\",\"\",+G60*0.13)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"IF(I60=\"\",\"\",I60*0.16)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"IF(B60=0,\"\",(E60+F60+G60+H60+I60+J60+K60))","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$error":"#REF!"},{"$f":"N°factures!B53","v":"2019-53"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$error":"#REF!"},{"$f":"N°factures!B54","v":"2019-54"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$error":"#REF!"},{"$f":"N°factures!B55","v":"2019-55"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$error":"#REF!"},{"$f":"N°factures!B56","v":"2019-56"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$error":"#REF!"},{"$f":"N°factures!B57","v":"2019-57"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$error":"#REF!"},{"$f":"N°factures!B58","v":"2019-58"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$error":"#REF!"},{"$f":"N°factures!B59","v":"2019-59"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$error":"#REF!"},{"$f":"N°factures!B60","v":"2019-60"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$error":"#REF!"},{"$f":"N°factures!B61","v":"2019-61"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$error":"#REF!"},{"$f":"N°factures!B62","v":"2019-62"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$error":"#REF!"},{"$f":"N°factures!B63","v":"2019-63"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(E71=\"\",\"\",+E71*0.05)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"IF(G71=\"\",\"\",+G71*0.13)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"IF(I71=\"\",\"\",I71*0.16)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"IF(B71=0,\"\",(E71+F71+G71+H71+I71+J71+K71))","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$error":"#REF!"},{"$f":"N°factures!B64","v":"2019-64"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$error":"#REF!"},{"$f":"N°factures!B65","v":"2019-65"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$error":"#REF!"},{"$f":"N°factures!B66","v":"2019-66"},{"$error":"#REF!"},{"$f":"IF(INDIRECT(\"'\"&$B74&\"'!E$27\")>0,\"Saut MOZ / \",\"\")&IF(INDIRECT(\"'\"&$B74&\"'!E$28\")>0,\"Saut BOR / \",\"\")&IF(INDIRECT(\"'\"&$B74&\"'!E$29\")>0,\" VIDEO / \",\"\")&IF(INDIRECT(\"'\"&$B74&\"'!E$30\")>0,\" DIV / \",\"\")&IF(INDIRECT(\"'\"&$B74&\"'!E$31\")>0,\" ACCESS / \",\"\")&IF(INDIRECT(\"'\"&$B74&\"'!E$33\")>0,\" DEB\",\"\")","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$error":"#REF!"},{"$f":"N°factures!B67","v":"2019-67"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$error":"#REF!"},{"$f":"N°factures!B68","v":"2019-68"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(E76=\"\",\"\",+E76*0.05)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"IF(G76=\"\",\"\",+G76*0.13)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"IF(I76=\"\",\"\",I76*0.16)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"IF(B76=0,\"\",(E76+F76+G76+H76+I76+J76+K76))","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$error":"#REF!"},{"$f":"N°factures!B69","v":"2019-69"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(E77=\"\",\"\",+E77*0.05)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"IF(G77=\"\",\"\",+G77*0.13)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"IF(I77=\"\",\"\",I77*0.16)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"IF(B77=0,\"\",(E77+F77+G77+H77+I77+J77+K77))","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$error":"#REF!"},{"$f":"N°factures!B70","v":"2019-70"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]

{"sheet":"MODELE","index":3,"n_rows":52,"n_cols":10,"rows_kept":52,"cut":false,"hidden":false,"merged":[[54,0,54,3],[55,0,55,3],[40,5,40,6],[41,5,41,6],[42,5,42,6],[43,5,43,6],[44,5,44,6],[52,0,52,3],[39,5,39,6],[23,8,25,8],[23,9,25,9],[26,0,26,3],[27,0,27,3],[32,0,32,3],[33,0,33,3],[23,7,25,7],[35,7,35,8],[36,0,36,3],[37,0,37,3],[37,5,37,6],[38,5,38,6],[3,0,3,3],[23,0,25,3],[23,4,25,4],[23,5,25,5],[23,6,25,6]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["DATE"]
["N° DE FACTURE",{"$f":"MID(CELL(\"nomfichier\",A1),FIND(\"]\",CELL(\"nomfichier\",A1))+1,LEN(CELL(\"nomfichier\",A1))-FIND(\"]\",CELL(\"nomfichier\",A1)))","v":"MODELE"}]
[null,null,null,null,null,null,null,null," "]
[]
[]
[]
[]
[]
[]
["DESIGNATION ",null,null,null,"P.U.  TTC","P.U.  H.T.","QUANTITE","H.T.","TVA","TVA"]
[]
[]
["Saut en parachute tandem Moorea ",null,null,null,null,{"$f":"E27/(1+J27)","v":0},null,{"$f":"F27*G27","v":0},{"$f":"H27*J27","v":0},0.05]
["Saut en parachute tandem Bora ",null,null,null,null,{"$f":"E28/(1+J28)","v":0},null,{"$f":"F28*G28","v":0},{"$f":"H28*J28","v":0},0.05]
["Option video et photos incluse",null,null,null,null,0,null,0,0,0.05]
["Prestations diverses ",null,null,null,null,0,null,0,0,0.13]
["Ventes d'accessoires (tee-shirts..)",null,null,null,null,{"$f":"E31/1.16","v":0},null,0,0,0.16]
[]
["Débours non soumis à TVA",null,null,null,null,null,null,{"$f":"E33","v":0},null,0]
[]
[null,null,null,null,null,null,null,{"$f":"SUM(H27:H34)","v":0},{"$f":"SUM(I27:I34)","v":0}]
[null,null,null,null,null,null,null,{"$f":"+H35+I35","v":0}]
[null,null,null,null,null,null,null," "]
[null,null,null,null,null,"H.T. soumis à 5%",null,{"$f":"SUM(H27:H29)","v":0}]
[null,null,null,null,null,"H.T. soumis à 13%",null,{"$f":"H30","v":0}]
[null,null,null,null,null,"H.T. soumis à 16%",null,{"$f":"H31","v":0}]
[null,null,null,null,null,"H.T. non soumis",null,{"$f":"H33","v":0}]
[null,null,null,null,null,"TVA 5,00%",null,{"$f":"SUM(I27:I29)","v":0}]
[null,null,null,null,null,"TVA 13,00%",null,{"$f":"I30","v":0}]
[null,null,null,null,null,"TVA 16,00%",null,{"$f":"I31","v":0}]
[null,null,null,null,null,"TOTAL T.T.C.",null,{"$f":"H38+H39+H40+H41+H42+H43+H44","v":0}]
["PAIEMENT : "]
["Date de règlement :"]
[]
[]
[]
[]
[" "]