{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Stock","Entrees","Sorties","Compte magasin","Sheet3"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"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":"Stock","index":0,"n_rows":22,"n_cols":23,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"اسم المخزن","الكود","تاريخ نهاية صنف","اكبر قيمة","اصغر قيمة","التاريخ الاحتياطي"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"magasin",101,{"$f":"IF($R$2=\"\",\"\",IFERROR(SMALL(IF(($A$4:$A$2000=$S$2)*($E$4:$E$2000=$R$2),$I$4:$I$2000),1),\"\"))","v":"2024-01-01"},{"$f":"IF($R$2=\"\",\"\",IFERROR(SMALL(IF(($A$4:$A$2000=$S$2)*($E$4:$E$2000=$R$2),$D$4:$D$2000),2),\"\"))","v":23},{"$f":"MIN(IF($A4:$A200=$S2,IF($E4:$E200=$R2,IF($I4:$I200=$T2,$D4:$D200,\"\"))))","v":0},{"$f":"IF($R$2=\"\",\"\",IFERROR(LARGE(IF(($A$4:$A$2000=$S$2)*($E$4:$E$2000=$R$2),$I$4:$I$2000),1),\"\"))","v":"2024-05-01"}]
["كود","صنف","سعر","كمية المخزون","اسم المخزن","مخزون الشراء","مخزون البيع","حد المخزون","تاريخ نهاية صنف"]
[100,"Produit",50,149,"magasin1",null,null,10,"2024-05-01"]
[100,"Produit",50,11,"magasin1",null,null,10,"2024-01-01"]
[100,"Produit",50,25,"magasin2",null,null,10,"2024-01-01"]
[100,"Produit",50,23,"magasin3",null,null,10,"2024-01-01"]
[101,"Produit1",70,0,"magasin",null,null,10,"2024-01-01"]
[101,"Produit1",70,13,"magasin1",null,null,10,"2024-01-01"]
[101,"Produit1",70,51,"magasin2",null,null,10,"2024-01-01"]
[102,"Produit2",85,84,"magasin3",null,null,10,"2024-01-01"]
[102,"Produit2",85,39,"magasin",null,null,10,"2024-01-01"]
[102,"Produit2",85,9,"magasin1",null,null,10,"2024-01-01"]
[103,"Produit3",90,50,"magasin2",null,null,10,"2024-01-01"]
[103,"Produit3",90,83,"magasin3",null,null,10,"2024-01-01"]
[104,"Produit4",90,65,"magasin3",null,null,10,"2024-01-01"]
[101,"Produit1",70,23,"magasin",null,null,10,"2024-05-01"]
[102,"Produit2",85,19,"magasin",null,null,10,"2024-05-01"]
[103,"Produit3",90,50,"magasin3",null,null,10,"2024-05-01"]
[100,"Produit",50,11,"magasin",null,null,10,"2024-01-01"]
[100,"Produit",50,20,"magasin4",null,null,10,"2024-05-01"]
[100,"Produit",50,5,"magasin4",null,null,10,"2024-01-01"]

{"sheet":"Entrees","index":1,"n_rows":1,"n_cols":8,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["تاريخ","كود صنف","اسم صنف","نوع الفاتورة","كمية","من مخزن","تاريخ الصنف","الى مخزن"]

{"sheet":"Sorties","index":2,"n_rows":18,"n_cols":8,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
["تاريخ","كود صنف","اسم صنف","نوع الفاتورة","كمية","من مخزن","تاريخ الصنف","الى مخزن"]
["23/05/2024",100,"Produit","Sortie",10,"magasin","2024-01-05"]
["23/05/2024",100,"Produit","Sortie",135,"magasin","2024-01-05"]
["23/05/2024",100,"Produit","Sortie",1,"magasin1","2024-01-01"]
["23/05/2024",100,"Produit","Sortie",1,"magasin4","2024-01-01"]
["23/05/2024",100,"Produit","Sortie",10,"magasin","2024-01-05"]
["23/05/2024",100,"Produit","Sortie",130,"magasin","2024-01-05"]
["23/05/2024",100,"Produit","Sortie",5,"magasin","2024-01-05"]
["23/05/2024",100,"Produit","Sortie",10,"magasin","2024-01-05"]
["23/05/2024",100,"Produit","Sortie",135,"magasin","2024-01-05"]
["23/05/2024",100,"Produit","Sortie",4,"magasin1","2024-01-01"]
["23/05/2024",100,"Produit","Sortie",4,"magasin4","2024-01-01"]
["23/05/2024",100,"Produit","Sortie",1,"magasin4","2024-01-01"]
["23/05/2024",100,"Produit","Sortie",10,"magasin","2024-01-05"]
["23/05/2024",100,"Produit","Sortie",134,"magasin","2024-01-05"]
["23/05/2024",100,"Produit","Sortie",10,"magasin","2024-01-05"]
["23/05/2024",100,"Produit","Sortie",134,"magasin","2024-01-05"]
["23/05/2024",100,"Produit","Sortie",1,"magasin","2024-01-05"]

{"sheet":"Compte magasin","index":3,"n_rows":6,"n_cols":11,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
[null,"Nom du magasin",null,null,null,null,null,null,null,null,"Type de facture"]
[null,"magasin",null,null,null,null,null,null,null,null,"Entrée"]
[null,"magasin1",null,null,null,null,null,null,null,null,"Sortie"]
[null,"magasin2"]
[null,"magasin3"]
[null,"magasin4"]

{"sheet":"Sheet3","index":4,"n_rows":13,"n_cols":6,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,0,1,4],[8,0,8,4]]}
[]
["Voir l'image présentée précédemment"]
["cod","Produit","prix","Quantité en stock","Du magasin"]
[100,"Produit",50,100,"magasin",1]
[100,"Produit",70,10,"magasin",2]
[100,"Produit",70,0,"magasin",3]
[100,"Produit",70,0,"magasin2",4]
[]
["Voir l'image présentée après"]
["cod","Produit","prix","Quantité en stock","Du magasin"]
[100,"Produit",50,100,"magasin",1]
[100,"Produit",70,10,"magasin",2]
[100,"Produit",70,0,"magasin2",4]