{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Database","Purchases","sales","Sales returns","Purchase returns","SelectedData","Sheet1"],"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,"Sales transaction",null,null,null,null,null,"Invoice type"]
[null,1,"Adapter HP FOR LAPTOP",12,120,null,null,1,"tarek",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"cash",null,null,null,null,null,"sales"]
[null,2,"Battery",12,120,null,null,2,"ali",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Okay",null,null,null,null,null,"Purchases"]
[null,3,"CASE DESKTOP COUGAR GAMING MX330",12,120,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,"Sales returns"]
[null,4,"CASE DESKTOP GENESIS NPC-1125 TITAN 750",12,120,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,"Purchase returns"]
[null,5,"FLASH DISK USB 16 GB",12,120]
[null,6,"H.D 1 TB USB EXPANSION 2.5\"",12,120]
[null,7,"H.D 2 TB USB EXPANSION 2.5\"",12,120]
[null,8,"HEADSET 302 SMARTLINE",12,120]
[null,9,"HP USB-C Travel Power Adapter",12,120]
[null,10,"IMPRIMANTE CANON 4/1 LASER COLOR MF635CX",12,120]
[null,11,"IMPRIMANTE CANON IP7240",12,120]
[null,12,"IMPRIMANTE CANON LBP 3010",12,120]
[null,13,"IMPRIMANTE CANON LBP 6030",12,120]
[null,14,"IMPRIMANTE CANON PIXMA G2400",12,120]
[null,15,"IMPRIMANTE CANON PIXMA G3400",12,120]
[null,16,"IMPRIMANTE CANON PIXMA MG2540 3 IN 1",12,120]
[null,17,"IMPRIMANTE CANON PIXMA MG3640 3 IN 1",12,120]
[null,18,"IMPRIMANTE CANON PIXMA MX494 4 IN 1",12,120]
[null,19,"IMPRIMANTE HP 2630",12,120]
[null,20,"IMPRIMANTE HP GT5810",12,120]
[null,21,"IMPRIMANTE HP GT5820CI WIFI",12,120]
[null,22,"IMPRIMANTE HP M102A",12,120]
[null,23,"IMPRIMANTE HP M102W",12,120]
[null,24,"IMPRIMANTE HP M130A",12,120]
[null,25,"IMPRIMANTE HP M130FN",12,120]
[null,26,"IMPRIMANTE SAMSUNG 3 IN 1 WIFI SL-M2070W ",12,120]
[null,27,"IMPRIMANTE SAMSUNG 4 IN 1 SL-C480FW",12,120]
[null,28,"IMPRIMANTE SAMSUNG SL-M2020 20 PPM",12,120]
[null,29,"IMPRIMANTE SAMSUNG SL-M2020 20 PPM WIFI",12,120]
[null,30,"IMPRIMANTE SAMSUNG SL-M2070 20 PPM ",12,120]
[null,31,"INK CANON CL-441 C",12,120]
[null,32,"INK CANON CL-510 B",12,120]
[null,33,"INK CANON CL-511 C",12,120]
[null,34,"INK CANON CLI-451 BLACK",12,120]
[null,35,"INK CANON CLI-451 C",12,120]
[null,36,"INK CANON PG-440 BK",12,120]
[null,37,"INK CANON PG-445B",12,120]
[null,38,"INK CANON PG-446C",12,120]
[null,39,"INK CANON PGI-450 BLACK",12,120]
[null,40,"KEYBOARD + MOUSE MICROSOFT WIFI 2LF",12,120]
[null,41,"KEYBOARD USB PJT-DKB475",12,120]
[null,42,"KEYBOARD+MOUSE LENOVO USB SET 4800",12,120]
[null,43,"KEYBOARD+MOUSE WIFI PJT-DCB083",12,120]
[null,44,"KEYBOARD+MOUSE WIFI PJT-DCB087 ML",12,120]
[null,45,"M.B BOARDX BX-H110",12,120]
[null,46,"MOUSE PAD JTMP-0002",12,120]
[null,47,"NETWORK TOOL JT-NT01",12,120]
[null,48,"SAMSUNG 24\" LS24D330HSX/ZN",12,120]
[null,49,"SAMSUNG LED 19\" S19F355HNM",12,120]
[null,50,"SAMSUNG LED 22\" LS22F350FHMXZN",12,120]
[null,51,"SCANNER CANON LIDE 120",12,120]
[null,52,"screen 30 pin 15.6",12,120]
[null,53,"screen 30 pin HD SLIM 15.6",12,120]
[null,54,"SSD 240 GB",12,120]
[null,55,"SSD 480 GB",12,120]
[null,56,"UPS TECHFINE 1500VA",12,120]
[null,57,"UPS TECHFINE 2000VA",12,120]
[null,58,"UPS TECHFINE 850VA",12,120]
[null,59,"VEDIO PROJECTEUR OPTOMA S341-3500",12,120]
[null,60,"VGA BORAD-X GT730 4GB DDR3",12,120]

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

{"sheet":"sales","index":2,"n_rows":19,"n_cols":19,"rows_kept":19,"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=\"\",\"\",Purchases!S5+'Sales returns'!S5-sales!S5-'Purchase returns'!S5)","v":-4},"Adapter HP FOR LAPTOP"]
[]
[]
[null,"Invoice code","Invoice type","date","the supplier","Sales transaction","cod","item name","Quantity","Price ","Total","Total"]
[null,1,"sales","2012-10-01","tarek","cash",null,"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,"sales","2019-10-02","tarek","Okay",null,"CASE DESKTOP GENESIS NPC-1125 TITAN 750",5,2000,10000]
[null,1,"sales","2022-09-29","tarek","cash",null,"Adapter HP FOR LAPTOP",5,2000,10000]
[null,1,"sales","2022-10-04","tarek","Okay",null,"H.D 1 TB USB EXPANSION 2.5\"",10,5,20000]
[null,1,"sales","2022-10-05","tarek","cash",null,"H.D 2 TB USB EXPANSION 2.5\"",5,2000,10000]
[null,1,"sales","2022-10-06","tarek","Okay",null,"HEADSET 302 SMARTLINE",5,3,15]
[null,1,"sales","2022-10-07","tarek","cash",null,"HP USB-C Travel Power Adapter",5,-1994,9970]
[null,1,"sales","2022-10-08","tarek","Okay",null,"IMPRIMANTE CANON 4/1 LASER COLOR MF635CX",5,-3991,19955]
[null,1,"sales","2022-10-09","tarek","cash",null,"IMPRIMANTE CANON IP7240",5,-5988,29940]
[null,1,"sales","2022-10-10","tarek","Okay",null,"IMPRIMANTE CANON LBP 3010",5,-7985,39925]
[null,1,"sales","2023-10-03","tarek","cash",null,"FLASH DISK USB 16 GB",5,3,15]
[null,1,"sales","2024-09-28","tarek","Okay",null,"Adapter HP FOR LAPTOP",10,5,20000]
[null,1,"sales","2025-09-30","tarek","Okay",null,"Battery",5,3,15]
[]
[null,1,null,null,null,null,null,null,7,null,7,null,null,null,null,0]

{"sheet":"Sales returns","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":"sales!S1","v":"Adapter HP FOR LAPTOP"}]
[]
[]
[null,"Invoice code","Invoice type","date","the supplier","Sales transaction","cod","item name","Quantity","Price ","Notes ","Total"]
[null,1,"Sales returns","2022-05-03","tarek","cash",null,"Adapter HP FOR LAPTOP",1,5,"20000",null,null,null,null,null,null,null,{"$f":"SUMIF($H$5:$H$999,$S$1,$I$5:$I$999)","v":1}]
[null,1,"Sales returns","2022-05-05","tarek3","cash",null,"Battery",5,3,"15"]
[null,1,"Sales returns","2022-05-06","tarek4","cash",null,"CASE DESKTOP COUGAR GAMING MX330",5,667.33333333333303,"20000"]
[null,1,"Sales returns","2022-05-07","tarek5","cash",null,"CASE DESKTOP GENESIS NPC-1125 TITAN 750",5,666.33333333333303,"10000"]
[null,1,"Sales returns","2022-05-08","tarek6","cash",null,"FLASH DISK USB 16 GB",5,665.33333333333303,"15"]
[null,1,"Sales returns","2022-05-09","tarek7","cash",null,"H.D 1 TB USB EXPANSION 2.5\"",5,664.33333333333303,"20000"]
[null,1,"Sales returns","2022-05-10","tarek8","cash",null,"H.D 2 TB USB EXPANSION 2.5\"",5,663.33333333333303,"10000"]
[null,1,"Sales returns","2022-05-11","tarek9","cash",null,"HEADSET 302 SMARTLINE",5,662.33333333333303,"15"]
[null,1,"Sales returns","2022-05-12","tarek10","cash",null,"HP USB-C Travel Power Adapter",5,661.33333333333303,"20000"]
[null,1,"Sales returns","2022-05-13","tarek11","cash",null,"IMPRIMANTE CANON 4/1 LASER COLOR MF635CX",5,660.33333333333303,"10000"]
[null,1,"Sales returns","2022-05-14","tarek12","cash",null,"IMPRIMANTE CANON IP7240",5,659.33333333333303,"15"]
[null,1,"Sales returns","2022-05-15","tarek13","cash",null,"IMPRIMANTE CANON LBP 3010",5,658.33333333333303,"20000"]

{"sheet":"Purchase returns","index":4,"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":"sales!S1","v":"Adapter HP FOR LAPTOP"}]
[]
[]
[null,"Invoice code","Invoice type","date","the supplier","Sales transaction","cod","item name","Quantity","Price ","Notes ","Total"]
[null,1,"Purchase returns","2021-01-23","tarek","cash",null,"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,"Purchase returns","2022-01-18","tarek","cash",null,"Battery",5,3,"15"]
[null,1,"Purchase returns","2022-01-19","tarek","cash",null,"CASE DESKTOP COUGAR GAMING MX330",10,5,"20000"]
[null,1,"Purchase returns","2022-01-20","tarek","cash",null,"CASE DESKTOP GENESIS NPC-1125 TITAN 750",5,2000,"10000"]
[null,1,"Purchase returns","2022-01-22","tarek","cash",null,"H.D 1 TB USB EXPANSION 2.5\"",10,5,"20000"]
[null,1,"Purchase returns","2022-01-23","tarek","cash",null,"H.D 2 TB USB EXPANSION 2.5\"",5,2000,"10000"]
[null,1,"Purchase returns","2022-01-24","tarek","cash",null,"HEADSET 302 SMARTLINE",5,3,"15"]
[null,1,"Purchase returns","2022-01-26","tarek","cash",null,"IMPRIMANTE CANON 4/1 LASER COLOR MF635CX",-0.83333333333333204,-3991]
[null,1,"Purchase returns","2022-01-27","tarek","cash",null,"IMPRIMANTE CANON IP7240",-3.3333333333333299,-5988]
[null,1,"Purchase returns","2022-01-28","tarek","cash",null,"IMPRIMANTE CANON LBP 3010",-5.8333333333333304,-7985]
[null,1,"Purchase returns","2022-01-29","tarek","cash",null,"Adapter HP FOR LAPTOP",10,5,"20000"]
[null,1,"Purchase returns","2022-03-21","tarek","cash",null,"FLASH DISK USB 16 GB",5,3,"15"]
[null,1,"Purchase returns","2022-12-17","tarek","cash",null,"Adapter HP FOR LAPTOP",5,2000,"10000"]

{"sheet":"SelectedData","index":5,"n_rows":13,"n_cols":19,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,"Invoice code","Invoice type","date","the supplier","item name","Quantity","Total"]
[null,null,null,null,null,null,null,null,null,null,null,1,"Purchases","tarek","cash","Adapter HP FOR LAPTOP",20,{"$f":"SUMPRODUCT(($M$2:M2=\"Purchases\")-($M$2:M2=\"sales\")+($M$2:M2=\"Sales returns\")+($M$2:M2=\"Purchase returns\")*Q2:Q2)","v":1},{"$f":"Q2","v":20}]
[null,null,null,null,null,null,null,null,null,null,null,1,"Purchases","tarek","cash","Adapter HP FOR LAPTOP",5,{"$f":"SUMPRODUCT(($M$2:M3=\"Purchases\")-($M$2:M3=\"sales\")+($M$2:M3=\"Sales returns\")+($M$2:M3=\"Purchase returns\")*Q3:Q3)","v":2},{"$f":"S2+Q3","v":25}]
[null,null,null,null,null,null,null,null,null,null,null,1,"sales","tarek","cash","Adapter HP FOR LAPTOP",5,{"$f":"SUMPRODUCT(($M$2:M4=\"Purchases\")-($M$2:M4=\"sales\")+($M$2:M4=\"Sales returns\")+($M$2:M4=\"Purchase returns\")*Q4:Q4)","v":1},{"$f":"S3-Q4","v":20}]
[null,null,null,null,null,null,null,null,null,null,null,1,"Sales returns","tarek","cash","Adapter HP FOR LAPTOP",1,{"$f":"SUMPRODUCT(($M$2:M5=\"Purchases\")-($M$2:M5=\"sales\")+($M$2:M5=\"Sales returns\")+($M$2:M5=\"Purchase returns\")*Q5:Q5)","v":2},{"$f":"S4+Q5","v":21}]
[null,null,null,null,null,null,null,null,null,null,null,1,"Purchase returns","tarek","cash","Adapter HP FOR LAPTOP",10,{"$f":"SUMPRODUCT(($M$2:M6=\"Purchases\")-($M$2:M6=\"sales\")+($M$2:M6=\"Sales returns\")+($M$2:M6=\"Purchase returns\")*Q6:Q6)","v":12},{"$f":"S5+Q6","v":31}]
[null,null,null,null,null,null,null,null,null,null,null,1,"Purchase returns","tarek","cash","Adapter HP FOR LAPTOP",5,{"$f":"SUMPRODUCT(($M$2:M7=\"Purchases\")-($M$2:M7=\"sales\")+($M$2:M7=\"Sales returns\")+($M$2:M7=\"Purchase returns\")*Q7:Q7)","v":12},{"$f":"S6+Q7","v":36}]
[null,null,null,null,null,null,null,null,null,null,null,1,"Purchases","tarek","cash","Adapter HP FOR LAPTOP",1,{"$f":"SUMPRODUCT(($M$2:M8=\"Purchases\")-($M$2:M8=\"sales\")+($M$2:M8=\"Sales returns\")+($M$2:M8=\"Purchase returns\")*Q8:Q8)","v":5},{"$f":"S7+Q8","v":37}]
[null,null,null,null,null,null,null,null,null,null,null,1,"Purchases","tarek","cash","Adapter HP FOR LAPTOP",3,{"$f":"SUMPRODUCT(($M$2:M9=\"Purchases\")-($M$2:M9=\"sales\")+($M$2:M9=\"Sales returns\")+($M$2:M9=\"Purchase returns\")*Q9:Q9)","v":10},{"$f":"S8+Q9","v":40}]
[null,null,null,null,null,null,null,null,null,null,null,1,"sales","tarek","cash","Adapter HP FOR LAPTOP",5,{"$f":"SUMPRODUCT(($M$2:M10=\"Purchases\")-($M$2:M10=\"sales\")+($M$2:M10=\"Sales returns\")+($M$2:M10=\"Purchase returns\")*Q10:Q10)","v":13},{"$f":"S9-Q10","v":35}]
[null,null,null,null,null,null,null,null,null,null,null,1,"Sales returns","tarek","cash","Adapter HP FOR LAPTOP",1,{"$f":"SUMPRODUCT(($M$2:M11=\"Purchases\")-($M$2:M11=\"sales\")+($M$2:M11=\"Sales returns\")+($M$2:M11=\"Purchase returns\")*Q11:Q11)","v":6},{"$f":"S10+Q11","v":36}]
[null,null,null,null,null,null,null,null,null,null,null,1,"Purchase returns","tarek","cash","Adapter HP FOR LAPTOP",10,{"$f":"SUMPRODUCT(($M$2:M12=\"Purchases\")-($M$2:M12=\"sales\")+($M$2:M12=\"Sales returns\")+($M$2:M12=\"Purchase returns\")*Q12:Q12)","v":34},{"$f":"S11+Q12","v":46}]
[null,null,null,null,null,null,null,null,null,null,null,1,"Purchase returns","tarek","cash","Adapter HP FOR LAPTOP",5,{"$f":"SUMPRODUCT(($M$2:M13=\"Purchases\")-($M$2:M13=\"sales\")+($M$2:M13=\"Sales returns\")+($M$2:M13=\"Purchase returns\")*Q13:Q13)","v":24},{"$f":"S12+Q13","v":51}]

{"sheet":"Sheet1","index":6,"n_rows":63,"n_cols":18,"rows_kept":63,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,8,9,10,11,12,13,14,15]
[null,null,null,null,null,null,null,"رقم الصنف","اسم الصنف","الوحدة","سعر الوحدة","الصنف","الوارد","الصادر","الرصيد"]
[null,null,null,null,null,null,null,1,"Adapter HP FOR LAPTOP",12,120,"Adapter HP FOR LAPTOP 1",{"$f":"SUMIF(sales!D:D,I3,sales!I:I)","v":0},{"$f":"SUMIF('Sales returns'!D:D,I3,'Sales returns'!I:I)","v":0},{"$f":"M3-N3","v":0},"I","الكمية","F"]
[null,null,null,null,null,null,null,2,"Battery",12,120,null,{"$f":"SUMIF(sales!D:D,I4,sales!I:I)","v":0},{"$f":"SUMIF('Sales returns'!D:D,I4,'Sales returns'!I:I)","v":0},{"$f":"M4-N4","v":0},"D","كود الصنف","C"]
[null,null,null,null,null,null,null,3,"CASE DESKTOP COUGAR GAMING MX330",12,120,null,null,null,null,null,"كود البحث","I"]
[null,null,null,null,null,null,null,4,"CASE DESKTOP GENESIS NPC-1125 TITAN 750",12,120]
[null,null,null,null,null,null,null,5,"FLASH DISK USB 16 GB",12,120]
[null,null,null,null,null,null,null,6,"H.D 1 TB USB EXPANSION 2.5\"",12,120]
[null,null,null,null,null,null,null,7,"H.D 2 TB USB EXPANSION 2.5\"",12,120]
[null,null,null,null,null,null,null,8,"HEADSET 302 SMARTLINE",12,120]
[null,null,null,null,null,null,null,9,"HP USB-C Travel Power Adapter",12,120]
[null,null,null,null,null,null,null,10,"IMPRIMANTE CANON 4/1 LASER COLOR MF635CX",12,120]
[null,null,null,null,null,null,null,11,"IMPRIMANTE CANON IP7240",12,120]
[null,null,null,null,null,null,null,12,"IMPRIMANTE CANON LBP 3010",12,120]
[null,null,null,null,null,null,null,13,"IMPRIMANTE CANON LBP 6030",12,120]
[null,null,null,null,null,null,null,14,"IMPRIMANTE CANON PIXMA G2400",12,120]
[null,null,null,null,null,null,null,15,"IMPRIMANTE CANON PIXMA G3400",12,120]
[null,null,null,null,null,null,null,16,"IMPRIMANTE CANON PIXMA MG2540 3 IN 1",12,120]
[null,null,null,null,null,null,null,17,"IMPRIMANTE CANON PIXMA MG3640 3 IN 1",12,120]
[null,null,null,null,null,null,null,18,"IMPRIMANTE CANON PIXMA MX494 4 IN 1",12,120]
[null,null,null,null,null,null,null,19,"IMPRIMANTE HP 2630",12,120]
[null,null,null,null,null,null,null,20,"IMPRIMANTE HP GT5810",12,120]
[null,null,null,null,null,null,null,21,"IMPRIMANTE HP GT5820CI WIFI",12,120]
[null,null,null,null,null,null,null,22,"IMPRIMANTE HP M102A",12,120]
[null,null,null,null,null,null,null,23,"IMPRIMANTE HP M102W",12,120]
[null,null,null,null,null,null,null,24,"IMPRIMANTE HP M130A",12,120]
[null,null,null,null,null,null,null,25,"IMPRIMANTE HP M130FN",12,120]
[null,null,null,null,null,null,null,26,"IMPRIMANTE SAMSUNG 3 IN 1 WIFI SL-M2070W ",12,120]
[null,null,null,null,null,null,null,27,"IMPRIMANTE SAMSUNG 4 IN 1 SL-C480FW",12,120]
[null,null,null,null,null,null,null,28,"IMPRIMANTE SAMSUNG SL-M2020 20 PPM",12,120]
[null,null,null,null,null,null,null,29,"IMPRIMANTE SAMSUNG SL-M2020 20 PPM WIFI",12,120]
[null,null,null,null,null,null,null,30,"IMPRIMANTE SAMSUNG SL-M2070 20 PPM ",12,120]
[null,null,null,null,null,null,null,31,"INK CANON CL-441 C",12,120]
[null,null,null,null,null,null,null,32,"INK CANON CL-510 B",12,120]
[null,null,null,null,null,null,null,33,"INK CANON CL-511 C",12,120]
[null,null,null,null,null,null,null,34,"INK CANON CLI-451 BLACK",12,120]
[null,null,null,null,null,null,null,35,"INK CANON CLI-451 C",12,120]
[null,null,null,null,null,null,null,36,"INK CANON PG-440 BK",12,120]
[null,null,null,null,null,null,null,37,"INK CANON PG-445B",12,120]
[null,null,null,null,null,null,null,38,"INK CANON PG-446C",12,120]
[null,null,null,null,null,null,null,39,"INK CANON PGI-450 BLACK",12,120]
[null,null,null,null,null,null,null,40,"KEYBOARD + MOUSE MICROSOFT WIFI 2LF",12,120]
[null,null,null,null,null,null,null,41,"KEYBOARD USB PJT-DKB475",12,120]
[null,null,null,null,null,null,null,42,"KEYBOARD+MOUSE LENOVO USB SET 4800",12,120]
[null,null,null,null,null,null,null,43,"KEYBOARD+MOUSE WIFI PJT-DCB083",12,120]
[null,null,null,null,null,null,null,44,"KEYBOARD+MOUSE WIFI PJT-DCB087 ML",12,120]
[null,null,null,null,null,null,null,45,"M.B BOARDX BX-H110",12,120]
[null,null,null,null,null,null,null,46,"MOUSE PAD JTMP-0002",12,120]
[null,null,null,null,null,null,null,47,"NETWORK TOOL JT-NT01",12,120]
[null,null,null,null,null,null,null,48,"SAMSUNG 24\" LS24D330HSX/ZN",12,120]
[null,null,null,null,null,null,null,49,"SAMSUNG LED 19\" S19F355HNM",12,120]
[null,null,null,null,null,null,null,50,"SAMSUNG LED 22\" LS22F350FHMXZN",12,120]
[null,null,null,null,null,null,null,51,"SCANNER CANON LIDE 120",12,120]
[null,null,null,null,null,null,null,52,"screen 30 pin 15.6",12,120]
[null,null,null,null,null,null,null,53,"screen 30 pin HD SLIM 15.6",12,120]
[null,null,null,null,null,null,null,54,"SSD 240 GB",12,120]
[null,null,null,null,null,null,null,55,"SSD 480 GB",12,120]
[null,null,null,null,null,null,null,56,"UPS TECHFINE 1500VA",12,120]
[null,null,null,null,null,null,null,57,"UPS TECHFINE 2000VA",12,120]
[null,null,null,null,null,null,null,58,"UPS TECHFINE 850VA",12,120]
[null,null,null,null,null,null,null,59,"VEDIO PROJECTEUR OPTOMA S341-3500",12,120]
[null,null,null,null,null,null,null,60,"VGA BORAD-X GT730 4GB DDR3",12,120]
[null,null,null,null,null,null,null,62,"KJJJ","RHJRT",null,"KJJJ 62"]