{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Data","Inv","Day"],"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":"Data","index":0,"n_rows":11,"n_cols":14,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[17]
[null,null,null,null,null,null,null,null,null,null,null,"مخزن"]
[null,"الأصناف",null,null,null,null,null,null,"التصنيف",null,null,"عمود1","الفئة","اسم العميل"]
[null,"صنف 1",null,null,null,null,null,null,"صيدلية",null,null,{"$f":"IF(OR($L$2<>\"\",$L$2<>0),IF(OR($L3=0,$L3=\"\"),\"\",VLOOK2ALL($L$2,الجدول1[الفئة],2,ROW(A1))),\"\")","v":"CUST4"},"مركز","CUST1"]
[null,"صنف 2",null,null,null,null,null,null,"مخزن",null,null,{"$f":"IF(OR($L$2<>\"\",$L$2<>0),IF(OR($L4=0,$L4=\"\"),\"\",VLOOK2ALL($L$2,الجدول1[الفئة],2,ROW(A2))),\"\")","v":"CUST5"},"صيدلية","CUST2"]
[null,"صنف 3",null,null,null,null,null,null,"مركز",null,null,{"$f":"IF(OR($L$2<>\"\",$L$2<>0),IF(OR($L5=0,$L5=\"\"),\"\",VLOOK2ALL($L$2,الجدول1[الفئة],2,ROW(A3))),\"\")","v":"CUST7"},"مركز","CUST3"]
[null,"صنف 4",null,null,null,null,null,null,null,null,null,{"$f":"IF(OR($L$2<>\"\",$L$2<>0),IF(OR($L6=0,$L6=\"\"),\"\",VLOOK2ALL($L$2,الجدول1[الفئة],2,ROW(A4))),\"\")","v":0},"مخزن","CUST4"]
[null,"صنف 5",null,null,null,null,null,null,null,null,null,{"$f":"IF(OR($L$2<>\"\",$L$2<>0),IF(OR($L7=0,$L7=\"\"),\"\",VLOOK2ALL($L$2,الجدول1[الفئة],2,ROW(A5))),\"\")","v":""},"مخزن","CUST5"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR($L$2<>\"\",$L$2<>0),IF(OR($L8=0,$L8=\"\"),\"\",VLOOK2ALL($L$2,الجدول1[الفئة],2,ROW(A6))),\"\")","v":""},"صيدلية","CUST6"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR($L$2<>\"\",$L$2<>0),IF(OR($L9=0,$L9=\"\"),\"\",VLOOK2ALL($L$2,الجدول1[الفئة],2,ROW(A7))),\"\")","v":""},"مخزن","CUST7"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR($L$2<>\"\",$L$2<>0),IF(OR($L10=0,$L10=\"\"),\"\",VLOOK2ALL($L$2,الجدول1[الفئة],2,ROW(A8))),\"\")","v":""},"مركز","CUST8"]

{"sheet":"Inv","index":1,"n_rows":14,"n_cols":7,"rows_kept":14,"cut":false,"hidden":false,"merged":[[4,1,4,3],[3,1,3,3]]}
[]
[null,null,"رقم الفاتورة"]
[null,null,16]
["تاريخ الفاتورة","2020-02-12"]
["اسم العميل","مخزن CUST5"]
[]
["م","الصنف","الكمية","السعر","اج قبل الخصم","الخصم","الاجمالى"]
[1,"صنف 4",20,20,400,0,400]
[2,"صنف 5",100,200,20000,0,20000]
[]
[]
[null,null,null,null,null,20400]
[]
[null,null,null,"فقط عشرون ألفاً وأربعمائة جنيه مصريا لاغير"]

{"sheet":"Day","index":2,"n_rows":14,"n_cols":10,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[]
["التاريخ","رقم الفاتورة","التصنيف","اسم العميل","صنف 1","صنف 2","صنف 3","صنف 4","صنف 5","الاجمالى"]
["2020-02-12",11,"مخزن","CUST7"]
["2020-02-12",11,"مخزن","CUST5","صنف 3",null,null,null,null,500]
["2020-02-12",12,"مخزن","CUST5","صنف 4",null,null,null,null,1400]
["2020-02-12",13,"مخزن","CUST5","صنف 1",null,null,null,null,2000]
["2020-02-12",14,"مخزن","CUST7","صنف 3",null,null,null,null,400]
["2020-02-12",15,"مخزن","CUST5","صنف 2",null,null,null,null,625]
["2020-02-12",16,"مخزن","CUST5","صنف 5",null,null,null,null,20400]
[]
[]
[]
[]
[null," المطلوب عند ترحيل الفاتورة يتم ترحيل كمية الصنف 1 من الفورم اسفل الصنف 1 في الشيت DAY و كمية الصنف 2 في الفورم او الليست بوكس الى الصنف 2 في الشيت DAY وهكذا"]