{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Home","Clients","Facture","Suivis-Facture"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":2,"defined_names":14,"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":"Home","index":0,"n_rows":15,"n_cols":19,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["Type de Sejour","Nb Pers","Taxes","Prix",null,"Mode Paiement",null,"Mois","Années",null,"Article","Type",null,null,{"$f":"chiffrelettre(Facture!E32)","v":""},null,29,"/",19]
["Chambre Single en BB",1,9,null,null,"Espèce",null,"Janvier",2019,null,1,"Chambre Single en BB",null,null,"La Présente Facture est Arrêtée à la Somme de :",null,"Al-Hoceima le:"]
["Chambre Double en BB",2,9,null,null,"Carte Bancaire",null,"Février",2020,null,2,"Chambre Double en BB",null,null,null,null,"2019-07-12"]
["Chambre Triple en BB",3,9,null,null,"Chèque",null,"Mars",2021,null,3,"Chambre Triple en BB",null,null,null,null,"Durée de"]
["Chambre Quadrille en BB",4,9,null,null,"Virement",null,"Avril",2022,null,4,"Suite Famille en BB",null,null,null,null,{"$f":"Facture!E12-Facture!E11","v":5}]
["Chambre Single en DP",1,9,null,null,null,null,"Mai",2023,null,5,"Chambre Single en DP",null,null,null,null,"Jour(s)"]
["Chambre Double en DP",2,9,null,null,null,null,"Juillet",2025,null,6,"Chambre Double en DP",null,null,null,null,{"$f":"IFERROR(IF(ISNA(VLOOKUP(Facture!B17,tpt,2,0)),0,VLOOKUP(Facture!B17,tpt,2,0)),\"\")","v":0}]
["Chambre Triple en DP",3,9,null,null,null,null,"Août",2026,null,7,"Chambre Triple en DP",null,null,null,null,{"$f":"IFERROR(IF(ISNA(VLOOKUP(Facture!B16,tpt,2,0)),0,VLOOKUP(Facture!B16,tpt,2,0)),\"\")","v":0}]
["Chambre Quadrille en DP",4,9,null,null,null,null,"Septembre",2027,null,8,"Suite Famille en DP",null,null,null,null,{"$f":"IFERROR(IF(ISNA(VLOOKUP(Facture!B15,tpt,2,0)),0,VLOOKUP(Facture!B15,tpt,2,0)),\"\")","v":0}]
["Chambre Single en PC",1,9,null,null,null,null,"Octobre",2028,null,9,"Chambre Single en PC"]
["Chambre Double en PC",2,9,null,null,null,null,"Novembre",2029,null,10,"Chambre Double en PC"]
["Chambre Triple en PC",3,9,null,null,null,null,"Décembre",2030,null,11,"Chambre Triple en PC"]
["Chambre Quadrille en PC",4,9,null,null,null,null,null,null,null,12,"Suite Famille en PC"]
[]
["TAXE:TPT & TS",null,9]

{"sheet":"Clients","index":1,"n_rows":20,"n_cols":16,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
["Code","Nom","Adresse","ICE","Telephone","Prix1","Prix2","Prix3","Type 1","Type 2","Type 3","Qté1","Qté2","Qté3","Check in","Check out"]
[1,"BENJELLOUL","BNI DRAR",1245000123654,"06 42 86 88 74",300,750,500,"Chambre Single en BB","Chambre Triple en BB","Chambre Double en BB",2,1,1,"2019-08-06","2019-08-10"]
[2,"BERNAD","France","12311 00 00 48 16",132425918,350,500,700]
[3,"BRAHIM","MAROC","12308 00 00 48 58",123450100,500,null,null,"Chambre Double en BB","Chambre Double en BB",null,1]
[4,"BRINCOM","FES",45123541100,"06 61 45 74 00"]
[5,"DIDIER","France","12309 00 00 48 87",100475232,600,null,null,"Chambre Triple en BB",null,null,1,null,null,"2019-07-03","2019-07-09"]
[6,"FRANCOIS","France","12310 00 00 48 94",192605604,null,null,null,"Chambre Triple en BB","Chambre Double en BB",null,1]
[7,"HAYTAM","MAROC","12306 00 00 48 52",124257200,300,null,null,"Chambre Single en BB",null,null,1,null,null,"2019-07-04","2019-07-10"]
[8,"JIHAD","ASSILA",1245000124500,"06 42 58 45 12"]
[9,"JOSE MIGUEL","ESPAGNE",125445200000125,"06 32 45 10 45",330,null,null,"Chambre Single en BB"]
[10,"KAMAL","TUNISIE","12307 00 00 48 56",134759228,300,400,600,null,null,null,null,null,null,"2019-06-04","2019-06-09"]
[11,"LINDA","France","12313 00 00 48 21",161443243]
[12,"SMIRA","MAROC","12312 00 00 48 18",155487299,450,300,600,"Chambre Double en BB","Chambre Single en BB","Chambre Triple en BB",2,1,2]
[13,"STE DYAR EL MANSOUR","MEKNES",125442004566,"06 58 45 68 40"]
[14,"YAHYAOUI","OUJDA",123546687445,"06 42 86 88 99"]
[15,"YOUSSEF","ALGERIE","12314 00 00 48 88",148185203]

{"sheet":"Facture","index":2,"n_rows":36,"n_cols":14,"rows_kept":36,"cut":false,"hidden":false,"merged":[[35,1,35,3],[31,1,31,3],[7,3,7,4],[8,3,8,4],[9,3,9,4],[12,3,12,4]]}
[]
[null,null,null,""]
[]
[]
[]
[null,null,"Facture N°:",{"$f":"CONCATENATE(Home!Q1,\" \",Home!R1,\" \",Home!S1)","v":"29 / 19"}]
[null,"Code Client:",10,null,null,null,null,null,null,null,"liste déroulante"]
[null,null,{"$f":"IF(D8>\"\",\"CLIENT:\",\"\")","v":"CLIENT:"},{"$f":"IFERROR(INDEX(Tableau1[Nom],MATCH(Facture!C7,Tableau1[Code],0)),\"\")","v":"KAMAL"}]
[null,null,{"$f":"IF(D9>1,\"ICE:\",\"\")","v":"ICE:"},{"$f":"IFERROR(INDEX(Tableau1[ICE],MATCH(Facture!C7,Tableau1[Code],0)),0)","v":"12307 00 00 48 56"}]
[null,null,{"$f":"IF(D10>1,\"Telephone:\",\"\")","v":"Telephone:"},{"$f":"IFERROR(INDEX(Tableau1[Telephone],MATCH(Facture!C7,Tableau1[Code],0)),0)","v":134759228}]
[null,null,null,{"$f":"IF(E11>TODAY()-150,\"ARRIVEE:\",\"\")","v":"ARRIVEE:"},{"$f":"IFERROR(INDEX(Tableau1[Check in],MATCH(Facture!C7,Tableau1[Code],0)),0)","v":"2019-06-04"}]
[null,{"$f":"IFERROR(CONCATENATE(Home!Q4,\" \",Home!Q5,\" \",Home!Q6),\"\")","v":"Durée de 5 Jour(s)"},null,{"$f":"IF(E12>TODAY()-150,\"DEPART:\",\"\")","v":"DEPART:"},{"$f":"IFERROR(INDEX(Tableau1[Check out],MATCH(Facture!C7,Tableau1[Code],0)),0)","v":"2019-06-09"}]
[null,null,null,{"$f":"IF(C7>0,CONCATENATE(Home!Q2,TEXT(Home!Q3,\"jj mm aaaa\")),\"\")","v":"Al-Hoceima le:12 07 2019"}]
[null,"Désignation","Qté","Prix_Unit","Prix_Total",null,null,null,"dans les formule: tableau1 c'est la feuil (Clients)"]
["ici type3",{"$f":"IFERROR(INDEX(Tableau1[Type 3],MATCH(Facture!C$7,Tableau1[Code],0)),\"\")","v":0},{"$f":"IF(B15>\";\",INDEX(Tableau1[Qté3],MATCH(Facture!C$7,Tableau1[Code],0)),\"\")","v":""},{"$f":"IF(B15>\"\",INDEX(Tableau1[Prix3],MATCH(Facture!C$7,Tableau1[Code],0)),\"\")","v":""},{"$f":"IFERROR(IF(Home!Q$5<>\"\",C15*D15*Home!Q$5,C15*D15),\"\")","v":""}]
["ici type2",{"$f":"IFERROR(INDEX(Tableau1[Type 2],MATCH(Facture!C$7,Tableau1[Code],0)),\"\")","v":0},{"$f":"IF(B16>\";\",INDEX(Tableau1[Qté2],MATCH(Facture!C$7,Tableau1[Code],0)),\"\")","v":""},{"$f":"IF(B16>\"\",INDEX(Tableau1[Prix2],MATCH(Facture!C$7,Tableau1[Code],0)),\"\")","v":""},{"$f":"IFERROR(IF(Home!Q$5<>\"\",C16*D16*Home!Q$5,C16*D16),\"\")","v":""}]
["ici type1",{"$f":"IFERROR(INDEX(Tableau1[Type 1],MATCH(Facture!C$7,Tableau1[Code],0)),\"\")","v":0},{"$f":"IF(B17>\";\",INDEX(Tableau1[Qté1],MATCH(Facture!C$7,Tableau1[Code],0)),\"\")","v":""},{"$f":"IF(B17>\"\",INDEX(Tableau1[Prix1],MATCH(Facture!C$7,Tableau1[Code],0)),\"\")","v":""},{"$f":"IFERROR(IF(Home!Q$5<>\"\",C17*D17*Home!Q$5,C17*D17),\"\")","v":""}]
[null,{"$f":"IF(D11>\"\",\"TAXE:TPT.TS\",\"\")","v":"TAXE:TPT.TS"},{"$f":"IFERROR(C17*Home!Q7+C16*Home!Q8+C15*Home!Q9,\"\")","v":""},{"$f":"IF(E11>0,\"9,00\",\"\")","v":"9,00"},{"$f":"IFERROR(IF(Home!Q$5<>0,C18*D18*Home!Q$5,C18*D18),0)","v":0}]
[null,null,null,null,{"$f":"IFERROR(C19*D19,\"\")","v":0}]
[null,null,null,null,{"$f":"IFERROR(C20*D20,\"\")","v":0}]
[null,null,null,null,0,null,null,null,null,null,null,null,null,"ici seulement C*D"]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,{"$f":"IF(E32>0,CONCATENATE(Home!O2,\"\",Home!O1),\"\")","v":""},null,null,{"$f":"SUM(E15:E31)","v":0}]
[null,"Mode payement:",null,{"$f":"IF(E33>0,\"TOTAL  HT\",\"\")","v":""},{"$f":"IFERROR(E32-E18/1.1,\"\")","v":0}]
[null,null,null,{"$f":"IF(E34>0,\"TVA 10%\",\"\")","v":""},{"$f":"IFERROR(E33*10%,\"\")","v":0}]
[null,null,null,{"$f":"IF(E35>0,\"Arrièrrées\",\"\")","v":""},{"$f":"SUMIFS('Suivis-Facture'!K4:K49985,'Suivis-Facture'!A4:A49985,Facture!C7)","v":0}]
[null,null,null,null,{"$f":"IFERROR(E32+E35,\"\")","v":0}]

{"sheet":"Suivis-Facture","index":3,"n_rows":38,"n_cols":12,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Code","FACTURE ","DATE-FACT","CLIENT","TOTAL TTC","TPT+TS","TOTAL (HT)","TVA 10%","Espèce","Banque","Crédit","Status"]
[8,597,"2019-06-27","YAHYA",0,0,0,0,null,null,null,{"$f":"IF(C4&K4=\"\",\"\",IFERROR(IF(AND(K4>0,C4+30<TODAY()),\"Alerte\",IF(K4>0,\"Open\",\"Close\")),\"\"))","v":"Close"}]
[9,598,"2019-06-27","SALAHDDINE BRAND",18912,288,18650.18181818182,1865.018181818182,null,null,18912,"Open"]
[9,599,"2019-06-28","SALAHDDINE BRAND",0,null,null,null,null,null,null,"Close"]
[1,600,"2019-06-28","YAHYA",0,null,null,null,null,null,null,"Close"]
[2,27,"2019-07-08","KAMAL",6243,243,6022.090909090909,602.20909090909095,6243,null,null,"Close"]
[2,28,"2019-07-08","KAMAL",10796,396,10436,1043.6000000000001,null,null,10796,"Open"]
[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,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,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,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,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,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,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,""]