{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Stock","Entrees","Sorties","Rapport de produit","Rapport de magasin","Compte magasin"],"not_rendered":{"charts":0,"images":0,"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":"Stock","index":0,"n_rows":15,"n_cols":8,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[]
[]
["cod","Produit","prix","Quantité en stock","Du magasin","Stock Entrée","Stock Sortie","Stock Mini"]
[100,"Produit",50,20,"magasin",10,10,10]
[100,"Produit",50,10,"magasin1",5,5,10]
[100,"Produit",50,20,"magasin2",20,null,10]
[100,"Produit",50,20,"magasin3",20,null,10]
[101,"Produit1",70,22,"magasin",22,null,10]
[101,"Produit1",70,21,"magasin1",21,null,10]
[101,"Produit1",70,42,"magasin2",42,null,10]
[102,"Produit2",85,85,"magasin3",85,null,10]
[102,"Produit2",85,36,"magasin",36,null,10]
[102,"Produit2",85,14,"magasin1",14,null,10]
[103,"Produit3",90,51,"magasin2",51,null,10]
[103,"Produit3",90,84,"magasin3",84,null,10]

{"sheet":"Entrees","index":1,"n_rows":4,"n_cols":11,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["Number","Data","cod","Produit","prix","Type de facture","Quantité","Total","Du magasin","Au magasin","Data time"]
[1,"2024-01-01",100,"Produit",null,"Entrée",10,null,"magasin",null,"2024-01-20"]
[2,"2024-01-02",100,"Produit",null,"Entrée",5,null,"magasin1",null,"2024-01-21"]
[3,"24/04/2024",null,null,null,"Entrée",null,null,"magasin","magasin2"]

{"sheet":"Sorties","index":2,"n_rows":3,"n_cols":11,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["Number","Data","cod","Produit","prix","Type de facture","Quantité","Total","Du magasin","Au magasin","Data time"]
[1,"2024-01-01",100,"Produit",null,"Sortie",10,null,"magasin",null,"2024-01-20"]
[2,"2024-01-02",100,"Produit",null,"Sortie",5,null,"magasin1",null,"2024-01-21"]

{"sheet":"Rapport de produit","index":3,"n_rows":8,"n_cols":10,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,0,1,9],[3,0,3,1],[3,2,3,3],[3,6,3,7],[5,0,5,1],[5,2,5,3],[5,6,5,7]]}
[]
["Rapport spécifique au Produit"]
[]
["Du Date",null,"2024-01-01",null,null,"Nom du Produit","Produit"]
[]
["Au Date",null,"2024-01-30",null,null,"Facture totale",5000]
[]
["Number","Data","cod","Produit","prix","Type de facture","Quantité","Total","Du magasin","Au magasin"]

{"sheet":"Rapport de magasin","index":4,"n_rows":8,"n_cols":10,"rows_kept":8,"cut":false,"hidden":false,"merged":[[3,0,3,1],[5,0,5,1],[1,0,1,9],[3,2,3,3],[5,2,5,3],[3,6,3,7],[5,6,5,7]]}
[]
["Rapport spécifique au magasin"]
[]
["Du Date",null,"2024-01-01",null,null,"Nom du magasin","magasin"]
[]
["Au Date",null,"2024-01-30",null,null,"Facture totale",5000]
[]
["Number","Data","cod","Produit","prix","Type de facture","Quantité","Total","Du magasin","Au magasin"]

{"sheet":"Compte magasin","index":5,"n_rows":42,"n_cols":29,"rows_kept":42,"cut":false,"hidden":false,"merged":[]}
["نوع الحركة","كود المخزن","اسم المخزن","نوع المنتج","كود المندوب","اسم المندوب",null,"كود المورد","اسم المورد",null,null,null,null,"كود الصنف","اسم المخزن","وحدة","السعر","سعر شراء","سعر الجملة","سعر كبار عملاء","سعر التجزئة",null,"نوع الفاتورة",null,"مقبوضات ومدفوعات",null,"كود العميل","اسم العميل","نوع الحركة"]
["تحويلات",10,"magasin","بسكوت",11,"ادارة",null,100,"شركة الرئيسية",null,null,null,null,100,"بسكوت 12 *12",12,115,100,108,110,113,null,"فاتورة شراء",null,"تحصيلات",null,"مخزن 1","انتاج تام سنيوريتا","Entrées"]
["اول مدة",1,"magasin1","ويفر",1,"مندوب 1",null,101,"مورد 1",null,null,null,null,101,"شكولاتة 6 * 12 ",6,120,105,112,116,117,null,"مرتجع شراء",null,"مدفوعات",null,"مخزن 1","انتاج تام اسوان","Sorties"]
[null,2,"magasin2",null,2,"مندوب 2",null,102,"مورد 2",null,null,null,null,null,null,null,null,null,null,null,null,null,"فاتورة بيع",null,null,null,"مخزن 1","انتاج تام الاقصر"]
[null,3,"magasin3",null,3,"مندوب 3",null,103,"مورد 3",null,null,null,null,null,null,null,null,null,null,null,null,null,"مرتجع بيع",null,null,null,"مخزن 1","انتاج تام قنا"]
[null,null,null,null,4,"مندوب 4",null,104,"مورد 4",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"مخزن 1","انتاج تام ادفو"]
[null,null,null,null,5,"مندوب 5",null,105,"مورد 5",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"مخزن 1","البهنساوى"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"مخزن 1","اخر ساعة - الشئون"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"مخزن 1","الفردوس - المساكن"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"مخزن 1","ابراهيم يونس - الحصواية"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"مخزن 1","محمود صدقى - ال البيت"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"مخزن 1","الاندلس - الشئون"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"مخزن رئيسى","حمادة عبدالرحيم"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"مخزن رئيسى","محمد ابوالحسن"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"مخزن 1","بسام الجرجاوى - المحروسة"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"مخزن رئيسى","عرفات سلامة"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"مخزن 1","الراوى - الشئون"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"مخزن 1","على محسن - الشئون"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"مخزن 1","مبارك للتجارة - المساكن"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"مخزن 1","ابوعلاء للتجارة والتوزيع- الحصواية"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"مخزن 1","عطيتو - الشئون"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"مخزن 1","البهنساوى 2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"مخزن 1","ابوفراج - الحصواية"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"مخزن 1","اسلام مش - الحصواية"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"مخزن 1","ابراهيم خلف الله - الحصواية"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"مخزن 1","محمود الحسانى"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"مخزن 2","الصفا - الشئون س"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"مخزن 2","محمد جمعة - الشئون"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"مخزن 3","سعد الترامسة"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"مخزن 4","الطحان - حصواية"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"مخزن 3","عطيتو - حوض عشر سيد"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"مخزن 4","حمدى الجبلاوى"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"مخزن 4","شعبان الجبلاوى"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"مخزن 3","حمدى لجبلاو 2 سيد"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"مخزن 4","صافى سمير- قفط"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"مخزن 4","ابوخالد - قفط سيد"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"مخزن 4","محمود الكحلاوى - فرشوط"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"مخزن رئيسى","عبالناصر الصعيدى - فرشوط"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"مخزن 4","حسن احمد"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"مخزن 5","سيد احمد عارف"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"مخزن 5","ابراهيم انور"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"مخزن 5","ابوبكر حسين حسن"]