{"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":17,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["اسم الصنف",100,"نوع الصنف","الكمية","المجموعة","المورد","سعر الجملة","اقل سعر بيع","سعر البيع","ملاحظة",null,null,null,{"$f":"IFERROR(MATCH(O1,A:A,0),)","v":2},"فيرنا هاي كيو",null,"المجموعة"]
["فيرنا هاي كيو",101,"كوري",5,"تيل امامي","هوكس",160,180,200,2,null,null,null,{"$f":"IFERROR(MATCH(O2,A:A,0),)","v":0},null,null,"تيل امامي"]
["فيرنا هاي تك",102,"كوري",5,"تيل خلفي","هوكس",120,140,160,3,null,null,null,null,null,null,"تيل خلفي"]
[]
[]
[]
[null,null," "]

{"sheet":"Shortfalls","index":1,"n_rows":1,"n_cols":15,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["اسم الصنف","كود","نوع الصنف","الكمية","الشركة","المورد","السعر",null,null,null,null,null,null,{"$f":"IFERROR(MATCH(O1,A:A,0),)","v":0},"فيرنا هاي كيو"]

{"sheet":"PURCHASES","index":2,"n_rows":5,"n_cols":16,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[22000,"تاريخ الفاتورة","اليوم","اسم الصنف","كود الصنف","النوع","الكمية","المجموعة","المورد","سعر الشراء","اقل سعر بيع","سعر البيع","المدفوع","المتبقي","الوقت",{"$f":"IFERROR(MATCH(Q1,D:D,0),)","v":0}]
[22001,"20/06/2022","الإثنين","فيرنا هاي كيو",101,"كوري",5,"تيل امامي","هوكس",160,180,200,0,600,"01:49:04"]
[22001,"20/06/2022","الإثنين","فيرنا هاي تك",102,"كوري",5,"تيل خلفي","هوكس",120,140,160,0,600,"01:49:04"]
[22002,"20/06/2022","الإثنين","فيرنا هاي كيو",101,"كوري",5,"تيل امامي","هوكس",160,180,200,0,1400,"16:46:59"]
[22003,"20/06/2022","الإثنين","فيرنا هاي كيو",101,"كوري",3,"تيل امامي","هوكس",160,180,200,0,1080,"16:51:35"]

{"sheet":"SELES","index":3,"n_rows":2,"n_cols":14,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
[32000,"تاريخ الفاتورة","اليوم","العميل","الخصم","المدفوع","المتبقي","الإجمالي","الصنف","كود الصنف","النوع","الكمية","السعر","الوقت"]
[32001,"19/06/2022","الأحد","اسم العميل","0",0,"600",600,"تيل امامي فيرنا",101,"كوري",3,200,"17:43:22"]

{"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},null,"رقم الهاتف","اسم المورد"]
["هوكس","مورد جديد",0,0,"19/06/2022","الأحد","17:42:31",{"$f":"IFERROR(MATCH(I2,K:K,0),)","v":2},"هوكس","01017517168","هوكس"]
["أحمد عاطف","مورد جديد","0","0","19/06/2022","الأحد","17:42:31",null,null,"01008902206","أحمد عاطف"]
["هوكس","المشتريات",0,600,"20/06/2022","الإثنين","01:49:04"]
["محل","اضافة شراء",0,0,"2022-06-20","الإثنين","03:26:43"]
["محل ","اضافة شراء",0,0,"2022-06-20","الإثنين","03:29:15"]
["محل","اضافة شراء",0,0,"2022-06-20","الإثنين","03:30:11"]
["ببب","اضافة شراء",0,0,"2022-06-20","الإثنين","03:30:31"]
["هوكس","المشتريات","0","1080","20/06/2022","الإثنين","16:51:35"]

{"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,"ashraf","dim"]

{"sheet":"customers","index":6,"n_rows":4,"n_cols":11,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["اسم العميل","بيان الترحيل","المدفوع","المتبقي","التاريخ","اليوم","التوقيت",{"$f":"IFERROR(MATCH(I1,A:A,0),)","v":0},null,"رقم الهاتف","اسم العميل"]
["هاني سلطان","عميل جديد",0,0,"19/06/2022","الأحد","17:42:31",{"$f":"IFERROR(MATCH(I2,K:K,0),)","v":0},null,"01026358661","هاني سلطان"]
["شريف رمضان","عميل جديد",0,0,"19/06/2022","الأحد","17:42:31",null,null,"01003013694","شريف رمضان"]
["محل","اضافة بيع",0,0,"2022-06-20","الإثنين","03:51:08"]

{"sheet":"BouncePURCHASES","index":7,"n_rows":2,"n_cols":13,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
[40000,"تاريخ الارجاع","اليوم","اسم الصنف","كود الصنف","النوع","الكمية","الشركة","المورد","سعر الشراء","الوقت","الحالة","راجع"]
[null,null,null,null,null,null,null,null,null,null,null,null,"تبديل"]

{"sheet":"BounceSeles","index":8,"n_rows":3,"n_cols":17,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
[60000,"تاريخ الارجاع","اليوم","اسم الصنف","كود الصنف","النوع","الكمية","الشركة","العميل","سعر البيع","فرق التبديل","مديونية المحل","المدفوع","المتبقي","الوقت","الحالة","راجع"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"تبديل بفرق"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"تبديل"]

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

{"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,null,"رقم الفاتورة"]
[null,null,null,null,null,null,null,null,null,"اسم المورد"]
[null,null,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,"اجمالي المتبقي"]