{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["i","AdvFilter VBA Preview","AdvFilter VBA"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":6,"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":"i","index":0,"n_rows":14,"n_cols":13,"rows_kept":14,"cut":false,"hidden":false,"merged":[[12,0,12,14],[13,0,13,14],[15,0,15,14],[16,0,16,14],[17,0,17,14],[0,0,0,14],[5,0,5,14],[10,0,10,14],[11,0,11,14],[14,0,14,14],[1,0,3,14],[4,0,4,14],[7,0,9,2],[7,4,9,6],[7,8,9,10],[7,12,9,14],[6,0,6,14]]}
[]
["إتعلم أونلاين"]
[]
[]
["تم تحميل هذا الملف من موقع \"إتعلم أونلاين\""]
[]
["يمكنك متابعتنا عبر :"]
["Website",null,null,null,"YouTube",null,null,null,"Twitter",null,null,null,"Facebook"]
[]
[]
[]
[]
["روابط اخرى مفيدة."]
["دليل موضوعات إتعلم أونلاين"]

{"sheet":"AdvFilter VBA Preview","index":1,"n_rows":33,"n_cols":14,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
[]
[null,{"$f":"B5","v":"Date"},{"$f":"C5","v":"Branch"},"Product","Category","Quantity","Sales"]
[]
[]
[null,"Date","Branch","Product","Category","Quantity","Sales",null,"Date","Branch","Product","Category","Quantity","Sales"]
[null,"2015-01-01","Zagazig","HTC One - (32GB) - 4G","Smartphones",4,14400]
[null,"2015-01-01","Zagazig","HTC One - (32GB) - 4G","Smartphones",4,14400]
[null,"2015-01-02","Aswan","Samsung Galaxy Note3 (32GB) - 3G","Smartphones",2,7920]
[null,"2015-01-02","Aswan","Samsung Galaxy Note3 (32GB) - 3G","Smartphones",2,7920]
[null,"2015-01-03","Zagazig","HTC One - (32GB) - 4G","Smartphones",4,14400]
[null,"2015-01-03","Alex","iPhone 5C (32GB)","Smartphones",2,8460]
[null,"2015-01-03","Zagazig","HTC One - (32GB) - 4G","Smartphones",4,14400]
[null,"2015-01-03","Alex","iPhone 5C (32GB)","Smartphones",2,8460]
[null,"2015-01-04","Cairo","iPhone 5S (32GB)","Smartphones",2,10980]
[null,"2015-01-04","Cairo","iPhone 5S (32GB)","Smartphones",2,10980]
[null,"2015-01-08","Minia","Samsung Galaxy Note 10.1","Tablets",4,15480]
[null,"2015-01-08","Minia","Samsung Galaxy S4 (16GB) - 4G","Smartphones",1,3240]
[null,"2015-01-08","Minia","Samsung Galaxy Note 10.1","Tablets",4,15480]
[null,"2015-01-08","Cairo","Samsung Galaxy S4 (16GB) - 4G","Smartphones",1,3240]
[null,"2015-01-12","Cairo","Samsung Galaxy S3 (16GB) - 3G","Smartphones",4,9360]
[null,"2015-01-12","Cairo","Samsung Galaxy S3 (16GB) - 3G","Smartphones",4,9360]
[null,"2015-01-14","Zagazig","iPhone 5C (32GB)","Smartphones",2,8460]
[null,"2015-01-14","Zagazig","iPhone 5C (32GB)","Smartphones",2,8460]
[null,"2015-01-15","Portsaied","iPhone 5C (32GB)","Smartphones",4,16920]
[null,"2015-01-15","Aswan","iPhone 5S (64GB)","Smartphones",2,12420]
[null,"2015-01-15","Portsaied","iPhone 5C (32GB)","Smartphones",4,16920]
[null,"2015-01-15","Cairo","iPhone 5S (64GB)","Smartphones",2,12420]
[null,"2015-01-16","Cairo","Samsung Galaxy S3 (16GB) - 3G","Smartphones",1,2340]
[null,"2015-01-16","Portsaied","HTC One - (32GB) - 4G","Smartphones",2,7200]
[null,"2015-01-16","Cairo","Samsung Galaxy S3 (16GB) - 3G","Smartphones",1,2340]
[null,"2015-01-17","Zagazig","Samsung Galaxy S4 (16GB) - 4G","Smartphones",1,3240]
[null,"2015-01-18","Ismailia","Samsung Galaxy S4  (16GB) - 3G","Smartphones",4,12600]
[null,"2015-01-18","Cairo","Sony Xperia Z","Tablets",3,12690]

{"sheet":"AdvFilter VBA","index":2,"n_rows":44,"n_cols":14,"rows_kept":44,"cut":false,"hidden":false,"merged":[]}
[]
[null,{"$f":"B5","v":"Date"},{"$f":"C5","v":"Branch"},"Product","Category","Quantity","Sales"]
[null,{"$f":"IF(B1=\"\",\">1\",\">=\"&TEXT(B1,\"m/d/yy\"))","v":">1"}]
[]
[null,"Date","Branch","Product","Category","Quantity","Sales",null,"Date","Branch","Product","Category","Quantity","Sales"]
[null,"2015-01-01","Zagazig","HTC One - (32GB) - 4G","Smartphones",4,14400,null,"2015-01-01","Zagazig","HTC One - (32GB) - 4G","Smartphones",4,14400]
[null,"2015-01-01","Zagazig","HTC One - (32GB) - 4G","Smartphones",4,14400,null,"2015-01-01","Zagazig","HTC One - (32GB) - 4G","Smartphones",4,14400]
[null,"2015-01-02","Aswan","Samsung Galaxy Note3 (32GB) - 3G","Smartphones",2,7920,null,"2015-01-02","Aswan","Samsung Galaxy Note3 (32GB) - 3G","Smartphones",2,7920]
[null,"2015-01-02","Aswan","Samsung Galaxy Note3 (32GB) - 3G","Smartphones",2,7920,null,"2015-01-02","Aswan","Samsung Galaxy Note3 (32GB) - 3G","Smartphones",2,7920]
[null,"2015-01-03","Zagazig","HTC One - (32GB) - 4G","Smartphones",4,14400,null,"2015-01-03","Zagazig","HTC One - (32GB) - 4G","Smartphones",4,14400]
[null,"2015-01-03","Alex","iPhone 5C (32GB)","Smartphones",2,8460,null,"2015-01-03","Alex","iPhone 5C (32GB)","Smartphones",2,8460]
[null,"2015-01-03","Zagazig","HTC One - (32GB) - 4G","Smartphones",4,14400,null,"2015-01-03","Zagazig","HTC One - (32GB) - 4G","Smartphones",4,14400]
[null,"2015-01-03","Alex","iPhone 5C (32GB)","Smartphones",2,8460,null,"2015-01-03","Alex","iPhone 5C (32GB)","Smartphones",2,8460]
[null,"2015-01-04","Cairo","iPhone 5S (32GB)","Smartphones",2,10980,null,"2015-01-04","Cairo","iPhone 5S (32GB)","Smartphones",2,10980]
[null,"2015-01-04","Cairo","iPhone 5S (32GB)","Smartphones",2,10980,null,"2015-01-04","Cairo","iPhone 5S (32GB)","Smartphones",2,10980]
[null,"2015-01-08","Minia","Samsung Galaxy Note 10.1","Tablets",4,15480,null,"2015-01-08","Minia","Samsung Galaxy Note 10.1","Tablets",4,15480]
[null,"2015-01-08","Minia","Samsung Galaxy S4 (16GB) - 4G","Smartphones",1,3240,null,"2015-01-08","Minia","Samsung Galaxy S4 (16GB) - 4G","Smartphones",1,3240]
[null,"2015-01-08","Dubai","Samsung Galaxy Note 10.1","Tablets",4,15480,null,"2015-01-08","Dubai","Samsung Galaxy Note 10.1","Tablets",4,15480]
[null,"2015-01-08","Dubai","Samsung Galaxy S4 (16GB) - 4G","Smartphones",1,3240,null,"2015-01-08","Dubai","Samsung Galaxy S4 (16GB) - 4G","Smartphones",1,3240]
[null,"2015-01-12","Dubai","Samsung Galaxy S3 (16GB) - 3G","Smartphones",4,9360,null,"2015-01-12","Dubai","Samsung Galaxy S3 (16GB) - 3G","Smartphones",4,9360]
[null,"2015-01-12","Dubai","Samsung Galaxy S3 (16GB) - 3G","Smartphones",4,9360,null,"2015-01-12","Dubai","Samsung Galaxy S3 (16GB) - 3G","Smartphones",4,9360]
[null,"2015-01-14","Dubai","iPhone 5C (32GB)","Smartphones",2,8460,null,"2015-01-14","Dubai","iPhone 5C (32GB)","Smartphones",2,8460]
[null,"2015-01-14","Dubai","iPhone 5C (32GB)","Smartphones",2,8460,null,"2015-01-14","Dubai","iPhone 5C (32GB)","Smartphones",2,8460]
[null,"2015-01-15","Dubai","iPhone 5C (32GB)","Smartphones",4,16920,null,"2015-01-15","Dubai","iPhone 5C (32GB)","Smartphones",4,16920]
[null,"2015-01-15","Cairo","iPhone 5S (64GB)","Smartphones",2,12420,null,"2015-01-15","Cairo","iPhone 5S (64GB)","Smartphones",2,12420]
[null,"2015-01-15","Cairo","iPhone 5C (32GB)","Smartphones",4,16920,null,"2015-01-15","Cairo","iPhone 5C (32GB)","Smartphones",4,16920]
[null,"2015-01-15","Cairo","iPhone 5S (64GB)","Smartphones",2,12420,null,"2015-01-15","Cairo","iPhone 5S (64GB)","Smartphones",2,12420]
[null,"2015-01-16","Cairo","Samsung Galaxy S3 (16GB) - 3G","Smartphones",1,2340,null,"2015-01-16","Cairo","Samsung Galaxy S3 (16GB) - 3G","Smartphones",1,2340]
[null,"2015-01-16","Dubai","HTC One - (32GB) - 4G","Smartphones",2,7200,null,"2015-01-16","Dubai","HTC One - (32GB) - 4G","Smartphones",2,7200]
[null,"2015-01-16","Dubai","Samsung Galaxy S3 (16GB) - 3G","Smartphones",1,2340,null,"2015-01-16","Dubai","Samsung Galaxy S3 (16GB) - 3G","Smartphones",1,2340]
[null,"2015-01-17","Dubai","Samsung Galaxy S4 (16GB) - 4G","Smartphones",1,3240,null,"2015-01-17","Dubai","Samsung Galaxy S4 (16GB) - 4G","Smartphones",1,3240]
[null,"2015-01-18","Dubai","Samsung Galaxy S4  (16GB) - 3G","Smartphones",4,12600,null,"2015-01-18","Dubai","Samsung Galaxy S4  (16GB) - 3G","Smartphones",4,12600]
[null,"2015-01-18","Dubai","Sony Xperia Z","Tablets",3,12690,null,"2015-01-18","Dubai","Sony Xperia Z","Tablets",3,12690]
[null,"2017-01-01","Minia","Samsung Galaxy Note 10.1","Tablets",4,15480,null,"2017-01-01","Minia","Samsung Galaxy Note 10.1","Tablets",4,15480]
[null,"2017-01-01","Minia","Samsung Galaxy S4 (16GB) - 4G","Smartphones",1,3240,null,"2017-01-01","Minia","Samsung Galaxy S4 (16GB) - 4G","Smartphones",1,3240]
[null,"2017-01-01","Dubai","Samsung Galaxy Note 10.1","Tablets",4,15480,null,"2017-01-01","Dubai","Samsung Galaxy Note 10.1","Tablets",4,15480]
[null,"2017-01-01","Dubai","Samsung Galaxy S4 (16GB) - 4G","Smartphones",1,3240,null,"2017-01-01","Dubai","Samsung Galaxy S4 (16GB) - 4G","Smartphones",1,3240]
[null,"2017-01-01","Dubai","Samsung Galaxy S3 (16GB) - 3G","Smartphones",4,9360,null,"2017-01-01","Dubai","Samsung Galaxy S3 (16GB) - 3G","Smartphones",4,9360]
[null,"2017-01-01","Dubai","Samsung Galaxy S3 (16GB) - 3G","Smartphones",4,9360,null,"2017-01-01","Dubai","Samsung Galaxy S3 (16GB) - 3G","Smartphones",4,9360]
[null,"2017-01-01","Dubai","iPhone 5C (32GB)","Smartphones",2,8460,null,"2017-01-01","Dubai","iPhone 5C (32GB)","Smartphones",2,8460]
[null,"2017-01-01","Dubai","iPhone 5C (32GB)","Smartphones",2,8460,null,"2017-01-01","Dubai","iPhone 5C (32GB)","Smartphones",2,8460]
[null,"2017-01-01","Dubai","iPhone 5C (32GB)","Smartphones",4,16920,null,"2017-01-01","Dubai","iPhone 5C (32GB)","Smartphones",4,16920]
[null,"2017-01-01","Cairo","iPhone 5S (64GB)","Smartphones",2,12420,null,"2017-01-01","Cairo","iPhone 5S (64GB)","Smartphones",2,12420]
[null,"2017-01-01","Cairo","iPhone 5C (32GB)","Smartphones",4,16920,null,"2017-01-01","Cairo","iPhone 5C (32GB)","Smartphones",4,16920]