{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["ITEMS","Shortfalls","PURCHASES","SELES","suppliers","login","customers","BouncePURCHASES","BounceSeles","Credits","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":2},"بطاحة"]
["بطاحة",101,"كوري",57,"كوري","محل",200,220,250,80,null,null,null,{"$f":"IFERROR(MATCH(O2,A:A,0),)","v":3},"sssss"]
["sssss",102,"nnnnn",10,"kkkk","محل",120,160,200,15]
["last",103,"kor",0,"kera","محل",20,22,25,5]
[]
[]
[null,null," "]

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

{"sheet":"PURCHASES","index":2,"n_rows":4,"n_cols":17,"rows_kept":4,"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"]
[22002,"2022-06-13","الإثنين","بطاحة",101,"كوري",20,"كوري","محل",200,220,250,4000,0,"23:57:51"]

{"sheet":"SELES","index":3,"n_rows":10,"n_cols":14,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[32000,"تاريخ الفاتورة","اليوم","العميل","الخصم","المدفوع","المتبقي","الإجمالي","الصنف","كود الصنف","النوع","الكمية","السعر","الوقت"]
[32001,"2022-06-15","الأربعاء","محل","0",1250,"0",1250,"بطاحة",101,"كوري",5,250,"23:45:22"]
[32002,"2022-06-15","الأربعاء","محل","0",1250,"0",1250,"بطاحة",101,"كوري",5,250,"23:45:43"]
[32003,"2022-06-15","الأربعاء","محل","0",1000,"0",1000,"sssss",102,"nnnnn",5,200,"23:47:34"]
[32004,"2022-06-15","الأربعاء","محل","0",1000,"0",1000,"sssss",102,"nnnnn",5,200,"23:48:09"]
[32005,"2022-06-15","الأربعاء","محل","0",125,"0",125,"last",103,"kor",5,25,"23:48:33"]
[32006,"2022-06-15","الأربعاء","محل","0",null,"1250",1250,"بطاحة",101,"كوري",5,250,"23:48:48"]
[32007,"2022-06-15","الأربعاء","محل","0",2375,"0",2375,"بطاحة",101,"كوري",5,250,"23:52:16"]
[32007,"2022-06-15","الأربعاء","محل","0",2375,"0",2375,"sssss",102,"nnnnn",5,200,"23:52:16"]
[32007,"2022-06-15","الأربعاء","محل","0",2375,"0",2375,"last",103,"kor",5,25,"23:52:16"]

{"sheet":"suppliers","index":4,"n_rows":9,"n_cols":11,"rows_kept":9,"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","اشرف"]
["محل","المشتريات",4000,0,"2022-06-13","الإثنين","23:57:51"]
["محل","مشتريات","1250","0","2022-06-16","الخميس","23:45:22"]
["محل","مشتريات","0","0","2022-06-16","الخميس","23:45:22"]
["محل","مشتريات","1000","0","2022-06-17","الجمعة","23:45:22"]
["محل","مشتريات","1","0","2022-06-18","السبت","23:45:22"]
["محل","مرتجع",0,"0","2022-06-17","الجمعة","22:52:18"]

{"sheet":"login","index":5,"n_rows":2,"n_cols":8,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["اسم المستخدم","كلمة المرور",null,null,null,null,"اسم المستخدم","كلمة المرور"]
["admin","admin",null,null,null,null,"admin","admin"]

{"sheet":"customers","index":6,"n_rows":20,"n_cols":11,"rows_kept":20,"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"]
["محل","مبيعات","1250","0","2022-06-16","الخميس","23:45:22"]
["محل","مبيعات","1250","0","2022-06-16","الخميس","23:45:43"]
["محل","مبيعات","1000","0","2022-06-16","الخميس","23:47:34"]
["محل","مبيعات","1000","0","2022-06-16","الخميس","23:48:09"]
["محل","مبيعات","125","0","2022-06-16","الخميس","23:48:33"]
["محل","مبيعات","0","1250","2022-06-16","الخميس","23:48:48"]
["محل","مبيعات","2375","0","2022-06-16","الخميس","23:52:16"]
["محل","مبيعات",6500,"0","2022-06-17","الجمعة","23:52:16"]
["محل","مبيعات",2,"0","2022-06-18","السبت","23:52:16"]
["محل","تبديل بفرق",0,0,"2022-06-17","الجمعة","23:56:39"]
[]
[null,null,null,null,null,"s"]

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

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

{"sheet":"Credits","index":9,"n_rows":6,"n_cols":20,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["قيمة الصرف","صرف من","اسم المستلم","قيمة إيداع","خـــــزنــــة","اسم المودع","ترحيل من الدرج","التاريخ","اليوم","الوقت",null,null,null,null,null,null,null,null,"الخزنة","الدرج"]
[50,"درج","اشرف",0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,1599,5752]
[50,"خزنة","اشرف",0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,"المضاف","التاريخ"]
[0,0,0,0,1000,"خـــــزنــــة",null,null,null,null,null,null,null,null,null,null,null,null,1600,"2022-06-18"]
[0,0,0,0,0,0,500,"2022-06-17","الجمعة","23:50:15"]
[0,0,0,0,0,0,500,"2022-06-17","الجمعة","23:51:29"]

{"sheet":"Reset PURCHASES","index":10,"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,"اجمالي المتبقي"]