{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["ITEMS","Shortfalls","PURCHASES","SELES","suppliers","customers","BouncePURCHASES","BounceSeles","Reset PURCHASES"],"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":"ITEMS","index":0,"n_rows":7,"n_cols":15,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["اسم الصنف",100,"نوع الصنف","الكمية","الشركة","المورد","سعر الجملة","اقل سعر بيع","سعر البيع","ملاحظة",null,null,null,{"$f":"IFERROR(MATCH(O1,A:A,0),)","v":4},"last"]
["بطاحة",101,"كوري",70,"كوري","محل",200,220,250,80,null,null,null,{"$f":"IFERROR(MATCH(O2,A:A,0),)","v":2},"بطاحة"]
["sssss",102,"nnnnn",6,"kkkk","محل",120,160,200,15]
["last",103,"kor",4,"kera","محل",20,22,25,5]
[]
[]
[null,null," "]

{"sheet":"Shortfalls","index":1,"n_rows":7,"n_cols":15,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["اسم الصنف","كود الصنف","نوع الصنف","الكمية","الشركة","المورد","سعر الشراء",null,null,null,null,null,null,{"$f":"IFERROR(MATCH(O1,A:A,0),)","v":0},"last"]
["بطاحة",101,"كوري",70,"كوري","محل",200]
["sssss",102,"nnnnn",8,"kkkk","محل",120]
[]
[]
[]
[null,null," "]

{"sheet":"PURCHASES","index":2,"n_rows":3,"n_cols":17,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
[22000,"تاريخ الفاتورة","اليوم","اسم الصنف","كود الصنف","النوع","الكمية","الشركة","المورد","سعر الشراء","اقل سعر بيع","سعر البيع","المدفوع","المتبقي","الوقت",{"$f":"IFERROR(MATCH(Q1,D:D,0),)","v":3},"بطاحة"]
[22001,"2022-06-09","الخميس","sssss",102,"nnnnn",9,"kkkk","محل",100,130,150,1800,100,"03:25:09"]
[22001,"2022-06-09","الخميس","بطاحة",101,"كوري",5,"كوري","محل",200,220,250,1800,100,"03:25:09"]

{"sheet":"SELES","index":3,"n_rows":7,"n_cols":13,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[32000,"تاريخ الفاتورة","اليوم","العميل","الخصم","المدفوع","المتبقي","الإجمالي","الصنف","كود الصنف","النوع","الكمية","السعر"]
[32001,"2022-06-12","الأحد","محل","0",1250,"0",1250,"بطاحة",101,"كوري",5,250]
[32002,"2022-06-12","الأحد","محل","0",1250,"0",1250,"بطاحة",101,"كوري",5,250]
[32003,"2022-06-12","الأحد","محل","0",1250,"0",1250,"بطاحة",101,"كوري",5,250]
[32004,"2022-06-12","الأحد","محل","0",1000,"0",1000,"sssss",102,"nnnnn",5,200]
[32005,"2022-06-12","الأحد","محل","0",200,"0",200,"sssss",102,"nnnnn",1,200]
[null,null,null,null,null,null,null,null,"last",103,"kor",2,25]

{"sheet":"suppliers","index":4,"n_rows":3,"n_cols":11,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["اسم المورد","بيان الترحيل","المدفوع له","المتبقي له","التاريخ","اليوم","التوقيت",{"$f":"IFERROR(MATCH(I1,A:A,0),)","v":0},"اشرف","رقم الهاتف","اسم المورد"]
["محل","مشتريات",1800,100,"2022-06-09","الخميس","03:25:09",{"$f":"IFERROR(MATCH(I2,K:K,0),)","v":2},"محل","01000000","محل"]
["محل","مرتجع","7900","0","2022-06-10","الجمعة","20:44:55",null,null,"02","اشرف"]

{"sheet":"customers","index":5,"n_rows":8,"n_cols":11,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["اسم العميل","بيان الترحيل","المدفوع","المتبقي","التاريخ","اليوم","التوقيت",{"$f":"IFERROR(MATCH(I1,A:A,0),)","v":4},"اشرف","رقم الهاتف","اسم العميل"]
["محل",null,10000,5000,null,null,null,{"$f":"IFERROR(MATCH(I2,K:K,0),)","v":2},"محل","01000000","محل"]
["محل","دفع العميل","1000","4000","2022-06-10","الجمعة","13:58:08",null,null,"01095090320","اشرف"]
["اشرف","عميل جديد","0","0","2022-10-06","الجمعة","14:28:25"]
["محل","دفع العميل","1000","3000","2022-06-10","الجمعة","16:09:01"]
["محل","تبديل بفرق","100","-300","2022-06-11","السبت","15:27:20"]
["محل","مرتجع","400","400","2022-06-12","الأحد","00:46:45"]
["محل","مرتجع","1000","1000","2022-06-12","الأحد","00:51:42"]

{"sheet":"BouncePURCHASES","index":6,"n_rows":2,"n_cols":13,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
[40000,"تاريخ الارجاع","اليوم","اسم الصنف","كود الصنف","النوع","الكمية","الشركة","المورد","سعر الشراء","الوقت","الحالة","راجع"]
[40001,"2022-06-10","الجمعة","بطاحة",101,"كوري",40,"كوري","محل",200,"20:44:55","راجع","تبديل"]

{"sheet":"BounceSeles","index":7,"n_rows":3,"n_cols":17,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
[60000,"تاريخ الارجاع","اليوم","اسم الصنف","كود الصنف","النوع","الكمية","الشركة","العميل","سعر البيع","فرق التبديل","مديونية المحل","المدفوع","المتبقي","الوقت","الحالة","راجع"]
[60001,"2022-06-12","الأحد","sssss",102,"nnnnn",5,"kkkk","محل",200,0,1000,1000,0,"00:51:42","راجع","تبديل بفرق"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"تبديل"]

{"sheet":"Reset PURCHASES","index":8,"n_rows":42,"n_cols":10,"rows_kept":42,"cut":false,"hidden":false,"merged":[[39,6,39,9],[40,6,40,9],[41,6,41,9],[39,1,39,5],[40,1,40,5],[41,1,41,5]]}
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,22002,"رقم الفاتورة"]
[null,null,null,null,null,null,null,null,"محل","اسم المورد"]
[null,null,null,null,null,null,null,null,"2022-06-06","تاريخ الفاتورة"]
[null,"المتبقي","المدفوع","اجمال السعر","السعر","الكمية","النوع","الكود","اسم المنتج","م"]
[null,100,500,600,200,3,"khhj",102,"hgfhj"]
[null,null,null,null,null,null,null,null,"صصص"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,600,null,null,null,null,"اجمالي السعر"]
[null,500,null,null,null,null,"اجمالي المدفوع"]
[null,100,null,null,null,null,"اجمالي المتبقي"]