{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Produits","Mouvement","Fournisseur","Facture","Clients","ACCUEIL","Data","Sheet1"],"not_rendered":{"charts":0,"images":2,"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":"Produits","index":0,"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",6,12.45,19.600000000000001,5.5,15.709161,"fournisseur1",2,"Magasin",null,null,"Bio et écologique"]
[2,"Epicerie sucrée","Produit2",9,15.45,19.600000000000001,5.5,19.489999999999998,"fournisseur2","3","Magasin1",null,null,"Boissons"]
[3,"Tabac","Produit1",120,7.75,19.600000000000001,5.5,9.7787950000000006,"winston",10,"Magasin",null,null,"Bonbon"]
[4,"Bonbon","Haribo",8,21.45,19.600000000000001,5.5,27.07,"fournisseur4",2,"Magasin1",null,null,"Chocolat"]
[5,"Epicerie salée","Produit5",20,24.45,19.600000000000001,5.5,30.850521000000001,"fournisseur5",5,"Magasin",null,null,"Crèmerie, yaourts, œufs"]
[6,"Chocolat","Poulain",20,27.45,19.600000000000001,5.5,34.64,"fournisseur6",3,"Magasin1",null,null,"Entretien et maison"]
[8,"Tabac","Malboro rouge",50,8.34,19.600000000000001,5.5,10.5232452,"Malboro",10,"Magasin",null,null,"Epicerie salée"]
[9,"Bio et écologique","Confiture",6,7.25,19.600000000000001,5.5,9.1479049999999997,"fournisseur4",2,"Magasin1",null,null,"Epicerie sucrée"]
[10,"Boissons","Bières",445,9.75,19.600000000000001,5.5,12.302355,"fournisseur5",100,"Magasin",null,null,"essai"]
[11,"Crèmerie, yaourts, œufs","yaourt",100,2.68,19.600000000000001,5.5,3.3815704000000002,"fournisseur6",20,"Magasin1",null,null,"Fruits et légumes"]
[12,"Entretien et maison","savon noir",20,2.85,19.600000000000001,5.5,3.5960730000000001,"fournisseur7",2,"Magasin",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,"Magasin1",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,"Magasin",null,null,"Surgelés"]
[15,"Produits frais","œufs",80,4.78,19.600000000000001,5.5,6.0313084000000003,"fournisseur5",10,"Magasin1",null,null,"Tabac"]
[16,"Surgelés","Produit1",6,6.25,19.600000000000001,5.5,7.89,"fournisseur6",1,"Magasin",null,null,""]
[17,"Boissons","Pastis",19,11.85,19.600000000000001,5.5,14.952093,"Ricard",5,"Magasin1"]
[18,"Epicerie salée","Pate",16,9.75,19.600000000000001,5.5,12.302355,"fournisseur4",5,"Magasin"]

{"sheet":"Mouvement","index":1,"n_rows":19,"n_cols":10,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["Rayon","Désignation","Entrée","Sortie","Date","Stock","Source","Paiement","Montant","Magasin"]
["Surgelés","epinard",null,4,"2021-11-26",5,"Vente Client3","LIQUIDE",31.56,"Magasin"]
["Surgelés","epinard",5,0,"2021-11-26",6,"produit",null,null,"Magasin1"]
["Boissons","Bières",null,50,"2021-11-27",450,"Vente Client2","CB",615,"Magasin"]
["Boissons","Pastis",null,1,"2021-11-27",24,"Vente Client4","LIQUIDE",14.95,"Magasin1"]
["Bonbon","Haribo",10,0,"2021-11-27",10,"produit",null,null,"Magasin"]
["Epicerie sucrée","Produit1",null,1,"2024-02-27",9,"Vente Client1",null,null,"Magasin1"]
["Epicerie sucrée","Produit2",null,3,"2024-02-27",9,"Vente Client1",null,null,"Magasin"]
["Epicerie sucrée","Produit1",null,1,"2024-02-27",8,"Vente Client1",null,null,"Magasin1"]
["Epicerie sucrée","Produit1",null,1,"2024-02-27",7,"Vente Client1",null,null,"Magasin"]
["Epicerie sucrée","Produit1",null,1,"2024-02-27",6,"Vente Client1",null,null,"Magasin1"]
["Boissons","Pastis",null,2,"2024-02-27",22,"Vente Client2",null,29.9,"Magasin"]
["Boissons","Pastis",null,2,"2024-02-27",20,"Vente Client2",null,null,"Magasin1"]
["Boissons","Pastis",null,1,"2024-02-27",19,"Vente Client2",null,null,"Magasin"]
["Bio et écologique","Confiture",null,2,"2024-02-28",8,"Vente Client1",null,18.3,"Magasin1"]
["Bio et écologique","Confiture",null,2,"2024-02-28",6,"Vente Client1",null,18.3,"Magasin"]
["Boissons","Bières",null,5,"2024-02-28",445,"Vente Client1",null,61.5,"Magasin1"]
["Bonbon","Haribo",null,2,"2024-03-04",8,"Vente Client2",null,54.14,"Magasin"]
["Epicerie salée","Pate",null,4,"2024-03-23",16,"Vente Client1",null,49.2,"Magasin"]

{"sheet":"Fournisseur","index":2,"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":3,"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,65]
["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-0065",null,"Date:","2024-03-23"]
[]
["Rayon","Article","quantité","prix de vente","TVA","    HT","   TTC"]
["Epicerie salée","Pate",5,61.5,12.3,{"$f":"IF(D11<>\"\",D11*100/(100+E11)*C11,\"\")","v":273.82012466607301},{"$f":"IF(D11*C11>0,D11*C11,\"\")","v":307.5}]
[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:",5,"%"]
[null,null,null,null,null,"Total:",{"$f":"SUM(G11:G46)-(SUM(G11:G46)*G47/100)","v":292.125}]

{"sheet":"Clients","index":4,"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":"ACCUEIL","index":5,"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-03-23"},{"$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-03-22"},{"$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-03-21",{"$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-03-20",{"$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-03-19",{"$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-03-18",{"$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-03-16",{"$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-15",{"$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-14",{"$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-13",{"$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-12",{"$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":"Data","index":6,"n_rows":14,"n_cols":2,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["مسلسل","نوع الحركة"]
[1,"رصيد اول مدة"]
[1,"صرف"]
[1,"مشتراوات"]
[1,"مبيعات"]
[1,"مرتجعات"]
[2,"صرف"]
[2,"مشتراوات"]
[2,"مبيعات"]
[2,"مرتجعات"]
[3,"مشتراوات"]
[3,"مبيعات"]
[4,"مشتراوات"]
[4,"مبيعات"]

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