{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Source_sheet","حركةالنقدية","Target_sheet"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":10,"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":"Source_sheet","index":0,"n_rows":25,"n_cols":15,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[null,"التاريخ","اسم المورد","رقم المستند","الصنف","الكمية","السعر","القيمة",null,null,null,null,"الموردين",null,"الصنف"]
[null,"2018-01-22","جمال",3333,"rn",300,1,300,null,{"$f":"AND(Target_sheet!$D$2=Source_sheet!E2,Target_sheet!$C$2<=Source_sheet!B2,Target_sheet!$C$3>Source_sheet!B2)","v":false},null,null,"محمد",null,"or"]
[null,"2017-11-05","على",3333,"rn",200,1,200,null,{"$f":"AND(E3=Target_sheet!$E$2,B3>=Target_sheet!$C$2,B3<=Target_sheet!$C$3)","v":false},null,null,"سيد",null,"mt"]
[null,"2017-11-08","علاء",4444,"mt",150,1,150,null,{"$f":"AND(E4=Target_sheet!$E$2,B4>=Target_sheet!$C$2,B4<=Target_sheet!$C$3)","v":true},null,null,"جمال",null,"kh"]
[null,"2017-11-09","وليد",4455,"kh",180,1,180,null,{"$f":"AND(E5=Target_sheet!$E$2,B5>=Target_sheet!$C$2,B5<=Target_sheet!$C$3)","v":false},null,null,"وائل",null,"rn"]
[null,"2017-12-26","جمال",4455,"or",250,1,250,null,{"$f":"AND(E6=Target_sheet!$E$2,B6>=Target_sheet!$C$2,B6<=Target_sheet!$C$3)","v":false},null,null,"وليد"]
[null,"2018-01-02","سيد",6633,"or",175,1,175,null,{"$f":"AND(E7=Target_sheet!$E$2,B7>=Target_sheet!$C$2,B7<=Target_sheet!$C$3)","v":false}]
[null,"2018-02-05","محمد",6633,"or",100,1,100,null,{"$f":"AND(E8=Target_sheet!$E$2,B8>=Target_sheet!$C$2,B8<=Target_sheet!$C$3)","v":false}]
[null,"2017-12-05","على",3333,"rn",300,1,300,null,{"$f":"AND(E9=Target_sheet!$E$2,B9>=Target_sheet!$C$2,B9<=Target_sheet!$C$3)","v":false}]
[null,"2017-11-04","على",3333,"rn",200,1,200,null,{"$f":"AND(E10=Target_sheet!$E$2,B10>=Target_sheet!$C$2,B10<=Target_sheet!$C$3)","v":false}]
[null,"2017-11-24","علاء",4444,"mt",150,1,150,null,{"$f":"AND(E11=Target_sheet!$E$2,B11>=Target_sheet!$C$2,B11<=Target_sheet!$C$3)","v":true}]
[null,"2017-11-22","وليد",4455,"kh",180,1,180,null,{"$f":"AND(E12=Target_sheet!$E$2,B12>=Target_sheet!$C$2,B12<=Target_sheet!$C$3)","v":false}]
[null,"2017-12-12","جمال",4455,"kh",250,1,250,null,{"$f":"AND(E13=Target_sheet!$E$2,B13>=Target_sheet!$C$2,B13<=Target_sheet!$C$3)","v":false}]
[null,"2017-12-23","سيد",6633,"or",175,1,175,null,{"$f":"AND(E14=Target_sheet!$E$2,B14>=Target_sheet!$C$2,B14<=Target_sheet!$C$3)","v":false}]
[null,"2017-12-02","محمد",6633,"or",100,1,100,null,{"$f":"AND(E15=Target_sheet!$E$2,B15>=Target_sheet!$C$2,B15<=Target_sheet!$C$3)","v":false}]
[null,"2018-01-16","على",3333,"rn",200,1,200,null,{"$f":"AND(E16=Target_sheet!$E$2,B16>=Target_sheet!$C$2,B16<=Target_sheet!$C$3)","v":false}]
[null,"2017-12-20","علاء",4444,"mt",150,1,150]
[null,"2018-01-11","وليد",4455,"kh",180,1,180]
[null,"2017-12-30","جمال",4455,"kh",250,1,250]
[null,"2017-12-14","سيد",6633,"or",175,1,175]
[null,"2017-10-29","محمد",6633,"or",100,1,100]
[null,"2018-01-27","على",3333,"rn",300,1,300]
[null,"2017-11-08","على",3333,"rn",200,1,200]
[null,"2017-11-14","علاء",4444,"mt",150,1,150]
[null,"2017-12-30","وليد",4455,"kh",180,1,180]

{"sheet":"حركةالنقدية","index":1,"n_rows":3,"n_cols":5,"rows_kept":3,"cut":false,"hidden":true,"merged":[]}
[null,"التاريخ","اسم المورد","المبلغ المسدد","رقم الايصال"]
[null,"22/5/2017","جمال",5000,445566]
[null,"23/5/2017","سيد",4000,7788]

{"sheet":"Target_sheet","index":2,"n_rows":4,"n_cols":13,"rows_kept":4,"cut":false,"hidden":false,"merged":[[0,1,0,2]]}
[null,"التاريخ",null,"اسم المورد","الصنف"]
[null,"من تاريخ","2017-10-29","محمد","mt",null,null,null,null,null,null,"التاريخ","التاريخ"]
[null,"الى تاريخ","2018-02-05","اجمالى الكمية",{"$f":"SUM(F:F)","v":0},null,null,null,null,null,null,{"$f":"IF(ISNUMBER($C$2),CONCATENATE(\">=\",$C$2),\"\")","v":">=43037"},{"$f":"IF(ISNUMBER($C$3),CONCATENATE(\"<=\",$C$3),IF(ISNUMBER($C$2),CONCATENATE(\"<=\",$C$2),\"\"))","v":"<=43136"}]
[null,null,null,"اجمالى القيمة",{"$f":"SUM(H:H)","v":0}]