{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Database","المبيعات","مرتجع المشتريات","مرتجع المبيعات","المشتريات"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":5,"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":"Database","index":0,"n_rows":61,"n_cols":34,"rows_kept":61,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,4000,5,null,null,null,"Battery",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"حركه الفاتوره",null,null,null,null,null,"نوع الفاتوره"]
[null,null,"Adapter HP FOR LAPTOP",null,null,null,null,1,"tarek",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,"Battery",null,null,null,null,2,"ali",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,"CASE DESKTOP COUGAR GAMING MX330",null,null,"الاسم",null,3,"khalil",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,"CASE DESKTOP GENESIS NPC-1125 TITAN 750",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,"FLASH DISK USB 16 GB"]
[null,null,"H.D 1 TB USB EXPANSION 2.5\""]
[null,null,"H.D 2 TB USB EXPANSION 2.5\""]
[null,null,"HEADSET 302 SMARTLINE"]
[null,null,"HP USB-C Travel Power Adapter"]
[null,null,"IMPRIMANTE CANON 4/1 LASER COLOR MF635CX"]
[null,null,"IMPRIMANTE CANON IP7240"]
[null,null,"IMPRIMANTE CANON LBP 3010"]
[null,null,"IMPRIMANTE CANON LBP 6030"]
[null,null,"IMPRIMANTE CANON PIXMA G2400"]
[null,null,"IMPRIMANTE CANON PIXMA G3400"]
[null,null,"IMPRIMANTE CANON PIXMA MG2540 3 IN 1"]
[null,null,"IMPRIMANTE CANON PIXMA MG3640 3 IN 1"]
[null,null,"IMPRIMANTE CANON PIXMA MX494 4 IN 1"]
[null,null,"IMPRIMANTE HP 2630"]
[null,null,"IMPRIMANTE HP GT5810"]
[null,null,"IMPRIMANTE HP GT5820CI WIFI"]
[null,null,"IMPRIMANTE HP M102A"]
[null,null,"IMPRIMANTE HP M102W"]
[null,null,"IMPRIMANTE HP M130A"]
[null,null,"IMPRIMANTE HP M130FN"]
[null,null,"IMPRIMANTE SAMSUNG 3 IN 1 WIFI SL-M2070W "]
[null,null,"IMPRIMANTE SAMSUNG 4 IN 1 SL-C480FW"]
[null,null,"IMPRIMANTE SAMSUNG SL-M2020 20 PPM"]
[null,null,"IMPRIMANTE SAMSUNG SL-M2020 20 PPM WIFI"]
[null,null,"IMPRIMANTE SAMSUNG SL-M2070 20 PPM "]
[null,null,"INK CANON CL-441 C"]
[null,null,"INK CANON CL-510 B"]
[null,null,"INK CANON CL-511 C"]
[null,null,"INK CANON CLI-451 BLACK"]
[null,null,"INK CANON CLI-451 C"]
[null,null,"INK CANON PG-440 BK"]
[null,null,"INK CANON PG-445B"]
[null,null,"INK CANON PG-446C"]
[null,null,"INK CANON PGI-450 BLACK"]
[null,null,"KEYBOARD + MOUSE MICROSOFT WIFI 2LF"]
[null,null,"KEYBOARD USB PJT-DKB475"]
[null,null,"KEYBOARD+MOUSE LENOVO USB SET 4800"]
[null,null,"KEYBOARD+MOUSE WIFI PJT-DCB083"]
[null,null,"KEYBOARD+MOUSE WIFI PJT-DCB087 ML"]
[null,null,"M.B BOARDX BX-H110"]
[null,null,"MOUSE PAD JTMP-0002"]
[null,null,"NETWORK TOOL JT-NT01"]
[null,null,"SAMSUNG 24\" LS24D330HSX/ZN"]
[null,null,"SAMSUNG LED 19\" S19F355HNM"]
[null,null,"SAMSUNG LED 22\" LS22F350FHMXZN"]
[null,null,"SCANNER CANON LIDE 120"]
[null,null,"screen 30 pin 15.6"]
[null,null,"screen 30 pin HD SLIM 15.6"]
[null,null,"SSD 240 GB"]
[null,null,"SSD 480 GB"]
[null,null,"UPS TECHFINE 1500VA"]
[null,null,"UPS TECHFINE 2000VA"]
[null,null,"UPS TECHFINE 850VA"]
[null,null,"VEDIO PROJECTEUR OPTOMA S341-3500"]
[null,null,"VGA BORAD-X GT730 4GB DDR3"]

{"sheet":"المبيعات","index":1,"n_rows":17,"n_cols":19,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(S1=\"\",\"\",المشتريات!S5+'مرتجع المبيعات'!S5-المبيعات!S5-'مرتجع المشتريات'!S5)","v":5},"Adapter HP FOR LAPTOP"]
[]
[]
[null,"كود الفاتوره","نوع الفاتوره",null,"التاريخ","الاسم","حركه بيع الفاتوره","اسم الصنف","العدد","السعر","المجموع","المجموع مع TVA"]
[null,1,"المبيعات",null,"2012-10-01","tarek","كاش","CASE DESKTOP COUGAR GAMING MX330",10,5,20000,null,null,null,null,null,null,null,{"$f":"SUMIF($H$5:$H$1000,$S$1,$I$5:$I$1000)","v":15}]
[null,1,"المبيعات",null,"2019-10-02","tarek","كاش","CASE DESKTOP GENESIS NPC-1125 TITAN 750",5,2000,10000]
[null,1,"المبيعات",null,"2022-09-29","tarek","كاش","Adapter HP FOR LAPTOP",5,2000,10000]
[null,1,"المبيعات",null,"2022-10-04","tarek","كاش","H.D 1 TB USB EXPANSION 2.5\"",10,5,20000]
[null,1,"المبيعات",null,"2022-10-05","tarek","كاش","H.D 2 TB USB EXPANSION 2.5\"",5,2000,10000]
[null,1,"المبيعات",null,"2022-10-06","tarek","كاش","HEADSET 302 SMARTLINE",5,3,15]
[null,1,"المبيعات",null,"2022-10-07","tarek","كاش","HP USB-C Travel Power Adapter",5,-1994,9970]
[null,1,"المبيعات",null,"2022-10-08","tarek","كاش","IMPRIMANTE CANON 4/1 LASER COLOR MF635CX",5,-3991,19955]
[null,1,"المبيعات",null,"2022-10-09","tarek","كاش","IMPRIMANTE CANON IP7240",5,-5988,29940]
[null,1,"المبيعات",null,"2022-10-10","tarek","كاش","IMPRIMANTE CANON LBP 3010",5,-7985,39925]
[null,1,"المبيعات",null,"2023-10-03","tarek","كاش","FLASH DISK USB 16 GB",5,3,15]
[null,1,"المبيعات",null,"2024-09-28","tarek","كاش","Adapter HP FOR LAPTOP",10,5,20000]
[null,1,"المبيعات",null,"2025-09-30","tarek","كاش","Battery",5,3,15]

{"sheet":"مرتجع المشتريات","index":2,"n_rows":17,"n_cols":19,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"المبيعات!S1","v":"Adapter HP FOR LAPTOP"}]
[]
[]
[null,"كود الفاتوره","نوع الفاتوره",null,"التاريخ","الاسم","حركه بيع الفاتوره","اسم الصنف","العدد","السعر","المجموع","المجموع مع TVA"]
[null,1,"مرتجع المشتريات",null,"2021-01-23","tarek","كاش","HP USB-C Travel Power Adapter",1.6666666666666701,-1994,null,null,null,null,null,null,null,null,{"$f":"SUMIF($H$5:$H$1000,$S$1,$I$5:$I$1000)","v":15}]
[null,1,"مرتجع المشتريات",null,"2022-01-18","tarek","كاش","Battery",5,3,"15"]
[null,1,"مرتجع المشتريات",null,"2022-01-19","tarek","كاش","CASE DESKTOP COUGAR GAMING MX330",10,5,"20000"]
[null,1,"مرتجع المشتريات",null,"2022-01-20","tarek","كاش","CASE DESKTOP GENESIS NPC-1125 TITAN 750",5,2000,"10000"]
[null,1,"مرتجع المشتريات",null,"2022-01-22","tarek","كاش","H.D 1 TB USB EXPANSION 2.5\"",10,5,"20000"]
[null,1,"مرتجع المشتريات",null,"2022-01-23","tarek","كاش","H.D 2 TB USB EXPANSION 2.5\"",5,2000,"10000"]
[null,1,"مرتجع المشتريات",null,"2022-01-24","tarek","كاش","HEADSET 302 SMARTLINE",5,3,"15"]
[null,1,"مرتجع المشتريات",null,"2022-01-26","tarek","كاش","IMPRIMANTE CANON 4/1 LASER COLOR MF635CX",-0.83333333333333204,-3991]
[null,1,"مرتجع المشتريات",null,"2022-01-27","tarek","كاش","IMPRIMANTE CANON IP7240",-3.3333333333333299,-5988]
[null,1,"مرتجع المشتريات",null,"2022-01-28","tarek","كاش","IMPRIMANTE CANON LBP 3010",-5.8333333333333304,-7985]
[null,1,"مرتجع المشتريات",null,"2022-01-29","tarek","كاش","Adapter HP FOR LAPTOP",10,5,"20000"]
[null,1,"مرتجع المشتريات",null,"2022-03-21","tarek","كاش","FLASH DISK USB 16 GB",5,3,"15"]
[null,1,"مرتجع المشتريات",null,"2022-12-17","tarek","كاش","Adapter HP FOR LAPTOP",5,2000,"10000"]

{"sheet":"مرتجع المبيعات","index":3,"n_rows":16,"n_cols":19,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"المبيعات!S1","v":"Adapter HP FOR LAPTOP"}]
[]
[]
[null,"كود الفاتوره","نوع الفاتوره",null,"التاريخ","الاسم","حركه بيع الفاتوره","اسم الصنف","العدد","السعر","الملاحظات","المجموع"]
[null,1,"مرتجع المبيعات",null,"2022-05-03","tarek1","كاش","Adapter HP FOR LAPTOP",10,5,"20000",null,null,null,null,null,null,null,{"$f":"SUMIF($H$5:$H$999,$S$1,$I$5:$I$999)","v":10}]
[null,1,"مرتجع المبيعات",null,"2022-05-05","tarek3","كاش","Battery",5,3,"15"]
[null,1,"مرتجع المبيعات",null,"2022-05-06","tarek4","كاش","CASE DESKTOP COUGAR GAMING MX330",5,667.33333333333303,"20000"]
[null,1,"مرتجع المبيعات",null,"2022-05-07","tarek5","كاش","CASE DESKTOP GENESIS NPC-1125 TITAN 750",5,666.33333333333303,"10000"]
[null,1,"مرتجع المبيعات",null,"2022-05-08","tarek6","كاش","FLASH DISK USB 16 GB",5,665.33333333333303,"15"]
[null,1,"مرتجع المبيعات",null,"2022-05-09","tarek7","كاش","H.D 1 TB USB EXPANSION 2.5\"",5,664.33333333333303,"20000"]
[null,1,"مرتجع المبيعات",null,"2022-05-10","tarek8","كاش","H.D 2 TB USB EXPANSION 2.5\"",5,663.33333333333303,"10000"]
[null,1,"مرتجع المبيعات",null,"2022-05-11","tarek9","كاش","HEADSET 302 SMARTLINE",5,662.33333333333303,"15"]
[null,1,"مرتجع المبيعات",null,"2022-05-12","tarek10","كاش","HP USB-C Travel Power Adapter",5,661.33333333333303,"20000"]
[null,1,"مرتجع المبيعات",null,"2022-05-13","tarek11","كاش","IMPRIMANTE CANON 4/1 LASER COLOR MF635CX",5,660.33333333333303,"10000"]
[null,1,"مرتجع المبيعات",null,"2022-05-14","tarek12","كاش","IMPRIMANTE CANON IP7240",5,659.33333333333303,"15"]
[null,1,"مرتجع المبيعات",null,"2022-05-15","tarek13","كاش","IMPRIMANTE CANON LBP 3010",5,658.33333333333303,"20000"]

{"sheet":"المشتريات","index":4,"n_rows":60,"n_cols":19,"rows_kept":60,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"المبيعات!S1","v":"Adapter HP FOR LAPTOP"}]
[]
[]
[null,"كود الفاتوره","نوع الفاتوره",null,"التاريخ","الاسم","حركه بيع الفاتوره","اسم الصنف","العدد","السعر","الملاحظات","المجموع"]
[null,1,"المشتريات",null,"2020-01-01","tarek56","كاش","SSD 480 GB",5,1000,"10045",null,null,null,null,null,null,null,{"$f":"SUMIF($H$5:$H$1000,$S$1,$I$5:$I$1000)","v":25}]
[null,1,"المشتريات",null,"2020-02-06","tarek55","كاش","SSD 240 GB",5,1000,"10044"]
[null,1,"المشتريات",null,"2022-01-06","tarek54","كاش","screen 30 pin HD SLIM 15.6",5,1000,"10043"]
[null,1,"المشتريات",null,"2022-05-14","tarek01","كاش","Adapter HP FOR LAPTOP",20,5,"20000"]
[null,1,"المشتريات",null,"2022-05-15","tarek02","كاش","Adapter HP FOR LAPTOP",5,2000,"10000"]
[null,1,"المشتريات",null,"2022-05-16","tarek03","كاش","Battery",5,3,"15"]
[null,1,"المشتريات",null,"2022-05-17","tarek04","كاش","CASE DESKTOP COUGAR GAMING MX330",10,5,"20000"]
[null,1,"المشتريات",null,"2022-05-18","tarek05","كاش","CASE DESKTOP GENESIS NPC-1125 TITAN 750",5,2000,"10000"]
[null,1,"المشتريات",null,"2022-05-19","tarek06","كاش","FLASH DISK USB 16 GB",5,3,"15"]
[null,1,"المشتريات",null,"2022-05-20","tarek07","كاش","H.D 1 TB USB EXPANSION 2.5\"",10,5,"20000"]
[null,1,"المشتريات",null,"2022-05-21","tarek08","كاش","H.D 2 TB USB EXPANSION 2.5\"",5,2000,"10000"]
[null,1,"المشتريات",null,"2022-05-22","tarek09","كاش","HEADSET 302 SMARTLINE",5,3,"15"]
[null,2,"المشتريات",null,"2022-05-23","tarek10","كاش","HP USB-C Travel Power Adapter",10,5,"20000"]
[null,3,"المشتريات",null,"2022-05-24","tarek11","كاش","IMPRIMANTE CANON 4/1 LASER COLOR MF635CX",5,2000,"10000"]
[null,4,"المشتريات",null,"2022-05-25","tarek12","كاش","IMPRIMANTE CANON IP7240",5,1000,"10001"]
[null,5,"المشتريات",null,"2022-05-26","tarek13","كاش","IMPRIMANTE CANON LBP 3010",5,1000,"10002"]
[null,6,"المشتريات",null,"2022-05-27","tarek14","كاش","IMPRIMANTE CANON LBP 6030",5,1000,"10003"]
[null,7,"المشتريات",null,"2022-05-28","tarek15","كاش","IMPRIMANTE CANON PIXMA G2400",5,1000,"10004"]
[null,8,"المشتريات",null,"2022-05-29","tarek16","كاش","IMPRIMANTE CANON PIXMA G3400",5,1000,"10005"]
[null,9,"المشتريات",null,"2022-05-30","tarek17","كاش","IMPRIMANTE CANON PIXMA MG2540 3 IN 1",5,1000,"10006"]
[null,10,"المشتريات",null,"2022-05-31","tarek18","كاش","IMPRIMANTE CANON PIXMA MG3640 3 IN 1",5,1000,"10007"]
[null,11,"المشتريات",null,"2022-06-01","tarek19","كاش","IMPRIMANTE CANON PIXMA MX494 4 IN 1",5,1000,"10008"]
[null,12,"المشتريات",null,"2022-06-02","tarek20","كاش","IMPRIMANTE HP 2630",5,1000,"10009"]
[null,13,"المشتريات",null,"2022-06-03","tarek21","كاش","IMPRIMANTE HP GT5810",5,1000,"10010"]
[null,14,"المشتريات",null,"2022-06-04","tarek22","كاش","IMPRIMANTE HP GT5820CI WIFI",5,1000,"10011"]
[null,15,"المشتريات",null,"2022-06-05","tarek23","كاش","IMPRIMANTE HP M102A",5,1000,"10012"]
[null,16,"المشتريات",null,"2022-06-06","tarek24","كاش","IMPRIMANTE HP M102W",5,1000,"10013"]
[null,17,"المشتريات",null,"2022-06-07","tarek25","كاش","IMPRIMANTE HP M130A",5,1000,"10014"]
[null,18,"المشتريات",null,"2022-06-08","tarek26","كاش","IMPRIMANTE HP M130FN",5,1000,"10015"]
[null,19,"المشتريات",null,"2022-06-09","tarek27","كاش","IMPRIMANTE SAMSUNG 3 IN 1 WIFI SL-M2070W ",5,1000,"10016"]
[null,20,"المشتريات",null,"2022-06-10","tarek28","كاش","IMPRIMANTE SAMSUNG 4 IN 1 SL-C480FW",5,1000,"10017"]
[null,21,"المشتريات",null,"2022-06-11","tarek29","كاش","IMPRIMANTE SAMSUNG SL-M2020 20 PPM",5,1000,"10018"]
[null,22,"المشتريات",null,"2022-06-12","tarek30","كاش","IMPRIMANTE SAMSUNG SL-M2020 20 PPM WIFI",5,1000,"10019"]
[null,23,"المشتريات",null,"2022-06-13","tarek31","كاش","IMPRIMANTE SAMSUNG SL-M2070 20 PPM ",5,1000,"10020"]
[null,24,"المشتريات",null,"2022-06-14","tarek32","كاش","INK CANON CL-441 C",5,1000,"10021"]
[null,25,"المشتريات",null,"2022-06-15","tarek33","كاش","INK CANON CL-510 B",5,1000,"10022"]
[null,26,"المشتريات",null,"2022-06-16","tarek34","كاش","INK CANON CL-511 C",5,1000,"10023"]
[null,27,"المشتريات",null,"2022-06-17","tarek35","كاش","INK CANON CLI-451 BLACK",5,1000,"10024"]
[null,28,"المشتريات",null,"2022-06-18","tarek36","كاش","INK CANON CLI-451 C",5,1000,"10025"]
[null,29,"المشتريات",null,"2022-06-19","tarek37","كاش","INK CANON PG-440 BK",5,1000,"10026"]
[null,30,"المشتريات",null,"2022-06-20","tarek38","كاش","INK CANON PG-445B",5,1000,"10027"]
[null,31,"المشتريات",null,"2022-06-21","tarek39","كاش","INK CANON PG-446C",5,1000,"10028"]
[null,32,"المشتريات",null,"2022-06-22","tarek40","كاش","INK CANON PGI-450 BLACK",5,1000,"10029"]
[null,33,"المشتريات",null,"2022-06-23","tarek41","كاش","KEYBOARD + MOUSE MICROSOFT WIFI 2LF",5,1000,"10030"]
[null,34,"المشتريات",null,"2022-06-24","tarek42","كاش","KEYBOARD USB PJT-DKB475",5,1000,"10031"]
[null,35,"المشتريات",null,"2022-06-25","tarek43","كاش","KEYBOARD+MOUSE LENOVO USB SET 4800",5,1000,"10032"]
[null,36,"المشتريات",null,"2022-06-26","tarek44","كاش","KEYBOARD+MOUSE WIFI PJT-DCB083",5,1000,"10033"]
[null,37,"المشتريات",null,"2022-06-27","tarek45","كاش","KEYBOARD+MOUSE WIFI PJT-DCB087 ML",5,1000,"10034"]
[null,38,"المشتريات",null,"2022-06-28","tarek46","كاش","M.B BOARDX BX-H110",5,1000,"10035"]
[null,39,"المشتريات",null,"2022-06-29","tarek47","كاش","MOUSE PAD JTMP-0002",5,1000,"10036"]
[null,40,"المشتريات",null,"2022-06-30","tarek48","كاش","NETWORK TOOL JT-NT01",5,1000,"10037"]
[null,41,"المشتريات",null,"2022-07-01","tarek49","كاش","SAMSUNG 24\" LS24D330HSX/ZN",5,1000,"10038"]
[null,42,"المشتريات",null,"2022-07-02","tarek50","كاش","SAMSUNG LED 19\" S19F355HNM",5,1000,"10039"]
[null,43,"المشتريات",null,"2022-07-03","tarek51","كاش","SAMSUNG LED 22\" LS22F350FHMXZN",5,1000,"10040"]
[null,44,"المشتريات",null,"2022-07-04","tarek52","كاش","SCANNER CANON LIDE 120",5,1000,"10041"]
[null,45,"المشتريات",null,"2022-07-05","tarek53","كاش","screen 30 pin 15.6",5,1000,"10042"]