{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["ACCUEIL","Clients","Produits","Mouvement","Add","Fournisseur","Facture","Sheet1","Data","Sheet2"],"not_rendered":{"charts":0,"images":2,"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":"ACCUEIL","index":0,"n_rows":24,"n_cols":12,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,"CAISSE ET STOCK"]
[]
[]
[]
[]
[]
[]
[]
[null,"ALARME"]
["Rayon","Produit","Stock"]
[]
[]
[null,null,null,null,null,null,null,null,null,"CB","CHEQUE","LIQUIDE"]
[null,null,null,null,null,null,null,null,{"$f":"TODAY()","v":"2024-04-07"},{"$f":"SUMIFS(Mouvement[Montant],Mouvement[Paiement],$J$13,Mouvement[Date],I14)","v":0},{"$f":"SUMIFS(Mouvement[Montant],Mouvement[Paiement],$K$13,Mouvement[Date],I14)","v":0},{"$f":"SUMIFS(Mouvement[Montant],Mouvement[Paiement],$L$13,Mouvement[Date],I14)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"IF(WEEKDAY(I14-1,2)<7,I14-1,I14-2)","v":"2024-04-06"},{"$f":"SUMIFS(Mouvement[Montant],Mouvement[Paiement],$J$13,Mouvement[Date],I15)","v":0},{"$f":"SUMIFS(Mouvement[Montant],Mouvement[Paiement],$K$13,Mouvement[Date],I15)","v":0},{"$f":"SUMIFS(Mouvement[Montant],Mouvement[Paiement],$L$13,Mouvement[Date],I15)","v":0}]
[null,null,null,null,null,null,null,null,"2024-04-05",{"$f":"SUMIFS(Mouvement[Montant],Mouvement[Paiement],$J$13,Mouvement[Date],I16)","v":0},{"$f":"SUMIFS(Mouvement[Montant],Mouvement[Paiement],$K$13,Mouvement[Date],I16)","v":0},{"$f":"SUMIFS(Mouvement[Montant],Mouvement[Paiement],$L$13,Mouvement[Date],I16)","v":0}]
[null,null,null,null,null,null,null,null,"2024-04-04",{"$f":"SUMIFS(Mouvement[Montant],Mouvement[Paiement],$J$13,Mouvement[Date],I17)","v":0},{"$f":"SUMIFS(Mouvement[Montant],Mouvement[Paiement],$K$13,Mouvement[Date],I17)","v":0},{"$f":"SUMIFS(Mouvement[Montant],Mouvement[Paiement],$L$13,Mouvement[Date],I17)","v":0}]
[null,null,null,null,null,null,null,null,"2024-04-03",{"$f":"SUMIFS(Mouvement[Montant],Mouvement[Paiement],$J$13,Mouvement[Date],I18)","v":0},{"$f":"SUMIFS(Mouvement[Montant],Mouvement[Paiement],$K$13,Mouvement[Date],I18)","v":0},{"$f":"SUMIFS(Mouvement[Montant],Mouvement[Paiement],$L$13,Mouvement[Date],I18)","v":0}]
[null,null,null,null,null,null,null,null,"2024-04-02",{"$f":"SUMIFS(Mouvement[Montant],Mouvement[Paiement],$J$13,Mouvement[Date],I19)","v":0},{"$f":"SUMIFS(Mouvement[Montant],Mouvement[Paiement],$K$13,Mouvement[Date],I19)","v":0},{"$f":"SUMIFS(Mouvement[Montant],Mouvement[Paiement],$L$13,Mouvement[Date],I19)","v":0}]
[null,null,null,null,null,null,null,null,"2024-04-01",{"$f":"SUMIFS(Mouvement[Montant],Mouvement[Paiement],$J$13,Mouvement[Date],I20)","v":0},{"$f":"SUMIFS(Mouvement[Montant],Mouvement[Paiement],$K$13,Mouvement[Date],I20)","v":0},{"$f":"SUMIFS(Mouvement[Montant],Mouvement[Paiement],$L$13,Mouvement[Date],I20)","v":0}]
[null,null,null,null,null,null,null,null,"2024-03-30",{"$f":"SUMIFS(Mouvement[Montant],Mouvement[Paiement],$J$13,Mouvement[Date],I21)","v":0},{"$f":"SUMIFS(Mouvement[Montant],Mouvement[Paiement],$K$13,Mouvement[Date],I21)","v":0},{"$f":"SUMIFS(Mouvement[Montant],Mouvement[Paiement],$L$13,Mouvement[Date],I21)","v":0}]
[null,null,null,null,null,null,null,null,"2024-03-29",{"$f":"SUMIFS(Mouvement[Montant],Mouvement[Paiement],$J$13,Mouvement[Date],I22)","v":0},{"$f":"SUMIFS(Mouvement[Montant],Mouvement[Paiement],$K$13,Mouvement[Date],I22)","v":0},{"$f":"SUMIFS(Mouvement[Montant],Mouvement[Paiement],$L$13,Mouvement[Date],I22)","v":0}]
[null,null,null,null,null,null,null,null,"2024-03-28",{"$f":"SUMIFS(Mouvement[Montant],Mouvement[Paiement],$J$13,Mouvement[Date],I23)","v":0},{"$f":"SUMIFS(Mouvement[Montant],Mouvement[Paiement],$K$13,Mouvement[Date],I23)","v":0},{"$f":"SUMIFS(Mouvement[Montant],Mouvement[Paiement],$L$13,Mouvement[Date],I23)","v":0}]
[null,null,null,null,null,null,null,null,"2024-03-27",{"$f":"SUMIFS(Mouvement[Montant],Mouvement[Paiement],$J$13,Mouvement[Date],I24)","v":0},{"$f":"SUMIFS(Mouvement[Montant],Mouvement[Paiement],$K$13,Mouvement[Date],I24)","v":0},{"$f":"SUMIFS(Mouvement[Montant],Mouvement[Paiement],$L$13,Mouvement[Date],I24)","v":0}]

{"sheet":"Clients","index":1,"n_rows":9,"n_cols":10,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["ID","Nom","Prénom","Rue","Ville","CodePostal","Tph","Portable","Email","Remarques"]
[1,"Client1","Prénom1","rue1","ville1",38001,411111111,611111111,"mail1@free.fr","note1"]
[2,"Client2","Prénom2","rue2","ville2",38002,422222222,622222222,"mail2@free.fr","note2"]
[4,"Client4","Prénom4","rue4","ville4",38004,444444444,644444444,"mail4@free.fr","note4"]
[6,"Client5","Prénom5","rue5","ville5",38005,455555555,655555555,"mail5@free.fr","note5"]
[7,"Client6","Prénom6","rue6","ville6",38006,466666666,666666666,"mail6@free.fr","note6"]
[8,"Client7","Prénom7","rue7","ville7",38007,477777777,677777777,"mail7@free.fr","note7"]
[9,"Client8","Prénom8","rue8","ville8",38008,488888888,688888888,"mail8@free.fr","note8"]
[10,"Client9","Prénom9","rue9","ville9",38009,499999999,699999999,"mail9@free.fr","note9"]

{"sheet":"Produits","index":2,"n_rows":18,"n_cols":14,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
["ID","Rayon","Produit","Stock","Prix d'achat","TVA","Marge","Prix de vente","Fournisseur","Stock mini","magasin",null,null,"Rayon"]
[1,"Epicerie sucrée","Produit1",10,12.45,19.600000000000001,5.5,15.709161,"fournisseur1",2,"Aa",null,null,"Bio et écologique"]
[2,"Epicerie sucrée","Produit2",22,15.45,19.600000000000001,5.5,19.489999999999998,"fournisseur2","3","Bb",null,null,"Boissons"]
[3,"Tabac","Winston Xspere Fresh",120,7.75,19.600000000000001,5.5,9.7787950000000006,"winston",10,"Aa",null,null,"Bonbon"]
[4,"Bonbon","Haribo",5,21.45,19.600000000000001,5.5,27.07,"fournisseur4",2,"Bb",null,null,"Chocolat"]
[5,"Epicerie salée","Produit5",20,24.45,19.600000000000001,5.5,30.850521000000001,"fournisseur5",5,"Aa",null,null,"Crèmerie, yaourts, œufs"]
[6,"Chocolat","Poulain",20,27.45,19.600000000000001,5.5,34.64,"fournisseur6",3,"Bb",null,null,"Entretien et maison"]
[8,"Tabac","Malboro rouge",50,8.34,19.600000000000001,5.5,10.5232452,"Malboro",10,"Aa",null,null,"Epicerie salée"]
[9,"Bio et écologique","Confiture",10,7.25,19.600000000000001,5.5,9.1479049999999997,"fournisseur4",2,"Bb",null,null,"Epicerie sucrée"]
[10,"Boissons","Bières",450,9.75,19.600000000000001,5.5,12.302355,"fournisseur5",100,"Aa",null,null,"essai"]
[11,"Crèmerie, yaourts, œufs","yaourt",100,2.68,19.600000000000001,5.5,3.3815704000000002,"fournisseur6",20,"Bb",null,null,"Fruits et légumes"]
[12,"Entretien et maison","savon noir",20,2.85,19.600000000000001,5.5,3.5960730000000001,"fournisseur7",2,"Aa",null,null,"Hygiène, beauté et bébé"]
[13,"Fruits et légumes","pomme",50,0.9,19.600000000000001,5.5,1.135602,"fournisseur8",10,"Bb",null,null,"Produits frais"]
[14,"Hygiène, beauté et bébé","creme anti ride",10,3.25,19.600000000000001,5.5,4.1007850000000001,"fournisseur4",2,"Aa",null,null,"Surgelés"]
[15,"Produits frais","œufs",80,4.78,19.600000000000001,5.5,6.0313084000000003,"fournisseur5",10,"Bb",null,null,"Tabac"]
[16,"Surgelés","epinard",6,6.25,19.600000000000001,5.5,7.89,"fournisseur6",1,"Aa",null,null,""]
[17,"Boissons","Pastis",14,11.85,19.600000000000001,5.5,14.952093,"Ricard",5,"Bb"]
[18,"Epicerie salée","Pate",20,9.75,19.600000000000001,5.5,12.302355,"fournisseur4",5,"Bb"]

{"sheet":"Mouvement","index":3,"n_rows":11,"n_cols":10,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["Rayon","Désignation","Entrée","Sortie","Date","Stock","Source","Paiement","Montant","Tayp Fatora"]
["Surgelés","epinard",null,4,"2021-11-26",5,"Vente Client3","LIQUIDE",31.56]
["Surgelés","epinard",5,0,"2021-11-26",6,"produit"]
["Boissons","Bières",null,50,"2021-11-27",450,"Vente Client2","CB",615]
["Boissons","Pastis",null,1,"2021-11-27",24,"Vente Client4","LIQUIDE",14.95]
["Bonbon","Haribo",10,0,"2021-11-27",10,"produit"]
["Bonbon","Haribo",null,5,"2024-03-31",5,"Vente Client1","نقدى",135.35]
["Epicerie sucrée","Produit1",2,null,"2024-04-01",12,"Vente Client1","نقدى",31.42,"Entrée"]
["Epicerie sucrée","Produit1",null,2,"2024-04-01",10,"Vente Client1","نقدى",31.42,"Sortie"]
["Boissons","Pastis",null,5,"2024-04-04",19,"Vente Client1","نقدى",74.75,"Sortie"]
["Boissons","Pastis",null,5,"2024-04-04",14,"Vente Client1","نقدى",74.75,"Sortie"]

{"sheet":"Add","index":4,"n_rows":9,"n_cols":10,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Rayon","Désignation","Entrée","Sortie","Date","Stock","Source","Paiement","Montant","Tayp Fatora"]
["Surgelés","epinard",null,4,"2021-11-26",5,"Vente Client3","LIQUIDE",31.56]
["Surgelés","epinard",5,0,"2021-11-26",6,"produit"]
["Boissons","Bières",null,50,"2021-11-27",450,"Vente Client2","CB",615]
["Boissons","Pastis",null,1,"2021-11-27",24,"Vente Client4","LIQUIDE",14.95]
["Bonbon","Haribo",10,0,"2021-11-27",10,"produit"]
["Bonbon","Haribo",null,5,"2024-03-31",5,"Vente Client1","نقدى",135.35]
["Epicerie sucrée","Produit1",2,null,"2024-04-01",12,"Vente Client1","نقدى",31.42,"Entrée"]
["Epicerie sucrée","Produit1",null,2,"2024-04-01",10,"Vente Client1","نقدى",31.42,"Sortie"]

{"sheet":"Fournisseur","index":5,"n_rows":11,"n_cols":10,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["ID","Entreprise","contact","Rue","Ville","Code postal","Téléphone","Portable","Mail","Fax"]
[1,"fournisseur1","contact1","rue1","ville1",75001,101010101,601010101,"mail1@gmail.fr",101010111]
[2,"fournisseur2","contact2","rue2","ville2",75001,102020202,602020202,"mail2@gmail.fr",101010112]
[4,"fournisseur4","contact4","rue4","ville4",75001,104040404,604040404,"mail3@gmail.fr",101010114]
[5,"fournisseur5","contact5","rue5","ville5",75001,105050505,605050505,"mail4@gmail.fr",101010115]
[6,"fournisseur6","contact6","rue6","ville6",75001,106060606,606060606,"mail5@gmail.fr",101010116]
[7,"fournisseur7","contact7","rue7","ville7",75001,107070707,607070707,"mail6@gmail.fr",101010117]
[8,"fournisseur8","contact8","rue8","ville8",75001,108080808,608080808,"mail7@gmail.fr",101010118]
[8,"winston","fume","rue fume","fume ville",38099,899999999,699999999,"mail@fume.fr",899999990]
[10,"Malboro"]
[10,"Ricard","picole","sans soif","tombale",38888,488888888,788888888,"picole@sanssoif.fr",488888889]

{"sheet":"Facture","index":6,"n_rows":48,"n_cols":12,"rows_kept":48,"cut":false,"hidden":false,"merged":[]}
["Entreprise",null,null,null,"CLIENT",null,null,null,null,null,null,32]
["Adresse",null,null,null,"Nom:","Client1"]
["cp","Ville",null,null,"Prénom:","Prénom1"]
[null,null,null,null,"Adresse:","rue1"]
[null,null,null,null,"Code postal:","ville1"]
[null,null,null,null,"Ville:",38001]
[]
["Facture N°:","2024-0032",null,"Date:","2024-04-04"]
[]
["Rayon","Article","quantité","prix de vente","TVA","    HT","   TTC"]
["Boissons","Pastis",5,74.75,14.95,{"$f":"IF(D11<>\"\",D11*100/(100+E11)*C11,\"\")","v":325.14136581122222},{"$f":"IF(D11*C11>0,D11*C11,\"\")","v":373.75}]
[null,null,null,null,null,{"$f":"IF(D12<>\"\",D12*100/(100+E12)*C12,\"\")","v":""},{"$f":"IF(D12*C12>0,D12*C12,\"\")","v":""}]
[null,null,null,null,null,"",""]
[null,null,null,null,null,"",""]
[null,null,null,null,null,"",""]
[null,null,null,null,null,"",""]
[null,null,null,null,null,"",""]
[null,null,null,null,null,"",""]
[null,null,null,null,null,"",""]
[null,null,null,null,null,"",""]
[null,null,null,null,null,"",""]
[null,null,null,null,null,"",""]
[null,null,null,null,null,"",""]
[null,null,null,null,null,"",""]
[null,null,null,null,null,"",""]
[null,null,null,null,null,"",""]
[null,null,null,null,null,"",""]
[null,null,null,null,null,"",""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,"Remise:",1,"%"]
[null,null,null,null,null,"Total:",{"$f":"SUM(G11:G46)-(SUM(G11:G46)*G47/100)","v":370.01249999999999}]

{"sheet":"Sheet1","index":7,"n_rows":7,"n_cols":5,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["نوع الحركة",null,"ID","Nom","mandob"]
["رصيد اول مدة",null,1,"Aa","Aa1"]
["صرف",null,2,"Bb","Bb1"]
["مشتراوات"]
["مبيعات"]
["مرتجعات"]
["صادر"]

{"sheet":"Data","index":8,"n_rows":42,"n_cols":11,"rows_kept":42,"cut":false,"hidden":false,"merged":[]}
["كود المندوب","اسم المندوب",null,"كود المندوب","كود العميل","اسم العميل",null,null,null,"مسلسل","نوع الحركة"]
[9,"متوقفات",null,11,"حسن احمد","انتاج تام سنيوريتا",null,null,null,1,"رصيد اول مدة"]
[10,"ادارة",null,11,"حسن احمد","انتاج تام اسوان",null,null,null,1,"صرف"]
[11,"حسن احمد",null,11,"حسن احمد","انتاج تام الاقصر",null,null,null,1,"مشتراوات"]
[12,"مبارك احمد",null,11,"حسن احمد","انتاج تام قنا",null,null,null,1,"مبيعات"]
[13,"عصام انور",null,11,"حسن احمد","انتاج تام ادفو",null,null,null,1,"مرتجعات"]
[14,"احمد الدندراوى",null,11,"حسن احمد","البهنساوى",null,null,null,2,"صرف"]
[15,"عبدالرحمن احمد",null,11,"حسن احمد","اخر ساعة - الشئون",null,null,null,2,"مشتراوات"]
[16,"حسن احمد حسن",null,11,"حسن احمد","الفردوس - المساكن",null,null,null,2,"مبيعات"]
[17,"اخرى 5",null,11,"حسن احمد","ابراهيم يونس - الحصواية",null,null,null,2,"مرتجعات"]
[null,null,null,11,"حسن احمد","محمود صدقى - ال البيت",null,null,null,3,"مشتراوات"]
[null,null,null,11,"حسن احمد","الاندلس - الشئون",null,null,null,3,"مبيعات"]
[null,null,null,9,"متوقفات","حمادة عبدالرحيم",null,null,null,4,"مشتراوات"]
[null,null,null,9,"متوقفات","محمد ابوالحسن",null,null,null,4,"مبيعات"]
[null,null,null,11,"حسن احمد","بسام الجرجاوى - المحروسة"]
[null,null,null,9,"متوقفات","عرفات سلامة"]
[null,null,null,11,"حسن احمد","الراوى - الشئون"]
[null,null,null,11,"حسن احمد","على محسن - الشئون"]
[null,null,null,11,"حسن احمد","مبارك للتجارة - المساكن"]
[null,null,null,11,"حسن احمد","ابوعلاء للتجارة والتوزيع- الحصواية"]
[null,null,null,11,"حسن احمد","عطيتو - الشئون"]
[null,null,null,11,"حسن احمد","البهنساوى 2"]
[null,null,null,11,"حسن احمد","ابوفراج - الحصواية"]
[null,null,null,11,"حسن احمد","اسلام مش - الحصواية"]
[null,null,null,11,"حسن احمد","ابراهيم خلف الله - الحصواية"]
[null,null,null,11,"حسن احمد","محمود الحسانى"]
[null,null,null,12,"سيد احمد عارف","الصفا - الشئون س"]
[null,null,null,12,"سيد احمد عارف","محمد جمعة - الشئون"]
[null,null,null,12,"سيد احمد عارف","سعد الترامسة"]
[null,null,null,11,"حسن احمد","الطحان - حصواية"]
[null,null,null,12,"سيد احمد عارف","عطيتو - حوض عشر سيد"]
[null,null,null,11,"حسن احمد","حمدى الجبلاوى"]
[null,null,null,11,"حسن احمد","شعبان الجبلاوى"]
[null,null,null,12,"سيد احمد عارف","حمدى لجبلاو 2 سيد"]
[null,null,null,12,"سيد احمد عارف","صافى سمير- قفط"]
[null,null,null,12,"سيد احمد عارف","ابوخالد - قفط سيد"]
[null,null,null,11,"حسن احمد","محمود الكحلاوى - فرشوط"]
[null,null,null,9,"متوقفات","عبالناصر الصعيدى - فرشوط"]
[null,null,null,11,"حسن احمد","حسن احمد"]
[null,null,null,12,"سيد احمد عارف","سيد احمد عارف"]
[null,null,null,13,"عصام انور","ابراهيم انور"]
[null,null,null,14,"احمد الدندراوى","ابوبكر حسين حسن"]

{"sheet":"Sheet2","index":9,"n_rows":10,"n_cols":6,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["اسم المندوب","كود المندوب",null,"كود المندوب","كود العميل","اسم العميل"]
["متوقفات",9]
["ادارة",10]
["حسن احمد",11]
["سيد احمد عارف",12]
["ابراهيم انور",13]
["اخرى 2",14]
["اخرى 3",15]
["اخرى 4",16]
["اخرى 5",17]