{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Sheet1","Sheet2","Sheet3"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"Sheet1","index":0,"n_rows":45,"n_cols":5,"rows_kept":45,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
["رقم العميل","الاسماء","التاريخ","نوع العملية","الواجب"]
[100,"محمود علي","2019-12-12","A",5000]
[{"$f":"IF(B7=\"\",\"\",IF(COUNTIF($B$6:B7,B7)=1,MAX($A$6:A6)+1,INDEX($A$5:A6,MATCH(B7,$B$5:B6,0))))","v":101},"ابو المجد","2019-12-16","B",3000]
[{"$f":"IF(B8=\"\",\"\",IF(COUNTIF($B$6:B8,B8)=1,MAX($A$6:A7)+1,INDEX($A$5:A7,MATCH(B8,$B$5:B7,0))))","v":100},"محمود علي","2019-12-20","AB",2000]
[{"$f":"IF(B9=\"\",\"\",IF(COUNTIF($B$6:B9,B9)=1,MAX($A$6:A8)+1,INDEX($A$5:A8,MATCH(B9,$B$5:B8,0))))","v":102},"جمال","2019-12-20","V",400]
[{"$f":"IF(B10=\"\",\"\",IF(COUNTIF($B$6:B10,B10)=1,MAX($A$6:A9)+1,INDEX($A$5:A9,MATCH(B10,$B$5:B9,0))))","v":100},"محمود علي","2019-12-28","C",3450]
[{"$f":"IF(B11=\"\",\"\",IF(COUNTIF($B$6:B11,B11)=1,MAX($A$6:A10)+1,INDEX($A$5:A10,MATCH(B11,$B$5:B10,0))))","v":103},"منصور","2019-12-29","A",6000]
[{"$f":"IF(B12=\"\",\"\",IF(COUNTIF($B$6:B12,B12)=1,MAX($A$6:A11)+1,INDEX($A$5:A11,MATCH(B12,$B$5:B11,0))))","v":104},"احمد","2020-01-01","M",1200]
[{"$f":"IF(B13=\"\",\"\",IF(COUNTIF($B$6:B13,B13)=1,MAX($A$6:A12)+1,INDEX($A$5:A12,MATCH(B13,$B$5:B12,0))))","v":100},"محمود علي","2020-01-01","AB",2546]
[{"$f":"IF(B14=\"\",\"\",IF(COUNTIF($B$6:B14,B14)=1,MAX($A$6:A13)+1,INDEX($A$5:A13,MATCH(B14,$B$5:B13,0))))","v":101},"ابو المجد","2020-01-01","AB",2587]
[{"$f":"IF(B15=\"\",\"\",IF(COUNTIF($B$6:B15,B15)=1,MAX($A$6:A14)+1,INDEX($A$5:A14,MATCH(B15,$B$5:B14,0))))","v":100},"محمود علي","2020-01-01","C",1000]
[{"$f":"IF(B16=\"\",\"\",IF(COUNTIF($B$6:B16,B16)=1,MAX($A$6:A15)+1,INDEX($A$5:A15,MATCH(B16,$B$5:B15,0))))","v":102},"جمال","2020-01-01","D",900]
[{"$f":"IF(B17=\"\",\"\",IF(COUNTIF($B$6:B17,B17)=1,MAX($A$6:A16)+1,INDEX($A$5:A16,MATCH(B17,$B$5:B16,0))))","v":104},"احمد","2020-01-01","M",2500]
[{"$f":"IF(B18=\"\",\"\",IF(COUNTIF($B$6:B18,B18)=1,MAX($A$6:A17)+1,INDEX($A$5:A17,MATCH(B18,$B$5:B17,0))))","v":103},"منصور","2020-01-01","A",1500]
[{"$f":"IF(B19=\"\",\"\",IF(COUNTIF($B$6:B19,B19)=1,MAX($A$6:A18)+1,INDEX($A$5:A18,MATCH(B19,$B$5:B18,0))))","v":104},"احمد","2020-01-01","B",364]
[{"$f":"IF(B20=\"\",\"\",IF(COUNTIF($B$6:B20,B20)=1,MAX($A$6:A19)+1,INDEX($A$5:A19,MATCH(B20,$B$5:B19,0))))","v":100},"محمود علي","2020-01-01","C",2587]
[{"$f":"IF(B21=\"\",\"\",IF(COUNTIF($B$6:B21,B21)=1,MAX($A$6:A20)+1,INDEX($A$5:A20,MATCH(B21,$B$5:B20,0))))","v":101},"ابو المجد","2020-01-01","AB",2000]
[{"$f":"IF(B22=\"\",\"\",IF(COUNTIF($B$6:B22,B22)=1,MAX($A$6:A21)+1,INDEX($A$5:A21,MATCH(B22,$B$5:B21,0))))","v":100},"محمود علي","2020-05-01","C",2300]
[{"$f":"IF(B23=\"\",\"\",IF(COUNTIF($B$6:B23,B23)=1,MAX($A$6:A22)+1,INDEX($A$5:A22,MATCH(B23,$B$5:B22,0))))","v":102},"جمال","2020-01-01","V",654]
[{"$f":"IF(B24=\"\",\"\",IF(COUNTIF($B$6:B24,B24)=1,MAX($A$6:A23)+1,INDEX($A$5:A23,MATCH(B24,$B$5:B23,0))))","v":104},"احمد","2020-01-01","A",850]
[{"$f":"IF(B25=\"\",\"\",IF(COUNTIF($B$6:B25,B25)=1,MAX($A$6:A24)+1,INDEX($A$5:A24,MATCH(B25,$B$5:B24,0))))","v":""}]
[{"$f":"IF(B26=\"\",\"\",IF(COUNTIF($B$6:B26,B26)=1,MAX($A$6:A25)+1,INDEX($A$5:A25,MATCH(B26,$B$5:B25,0))))","v":""}]
[{"$f":"IF(B27=\"\",\"\",IF(COUNTIF($B$6:B27,B27)=1,MAX($A$6:A26)+1,INDEX($A$5:A26,MATCH(B27,$B$5:B26,0))))","v":""}]
[{"$f":"IF(B28=\"\",\"\",IF(COUNTIF($B$6:B28,B28)=1,MAX($A$6:A27)+1,INDEX($A$5:A27,MATCH(B28,$B$5:B27,0))))","v":""}]
[{"$f":"IF(B29=\"\",\"\",IF(COUNTIF($B$6:B29,B29)=1,MAX($A$6:A28)+1,INDEX($A$5:A28,MATCH(B29,$B$5:B28,0))))","v":""}]
[{"$f":"IF(B30=\"\",\"\",IF(COUNTIF($B$6:B30,B30)=1,MAX($A$6:A29)+1,INDEX($A$5:A29,MATCH(B30,$B$5:B29,0))))","v":""}]
[{"$f":"IF(B31=\"\",\"\",IF(COUNTIF($B$6:B31,B31)=1,MAX($A$6:A30)+1,INDEX($A$5:A30,MATCH(B31,$B$5:B30,0))))","v":""}]
[{"$f":"IF(B32=\"\",\"\",IF(COUNTIF($B$6:B32,B32)=1,MAX($A$6:A31)+1,INDEX($A$5:A31,MATCH(B32,$B$5:B31,0))))","v":""}]
[{"$f":"IF(B33=\"\",\"\",IF(COUNTIF($B$6:B33,B33)=1,MAX($A$6:A32)+1,INDEX($A$5:A32,MATCH(B33,$B$5:B32,0))))","v":""}]
[{"$f":"IF(B34=\"\",\"\",IF(COUNTIF($B$6:B34,B34)=1,MAX($A$6:A33)+1,INDEX($A$5:A33,MATCH(B34,$B$5:B33,0))))","v":""}]
[{"$f":"IF(B35=\"\",\"\",IF(COUNTIF($B$6:B35,B35)=1,MAX($A$6:A34)+1,INDEX($A$5:A34,MATCH(B35,$B$5:B34,0))))","v":""}]
[{"$f":"IF(B36=\"\",\"\",IF(COUNTIF($B$6:B36,B36)=1,MAX($A$6:A35)+1,INDEX($A$5:A35,MATCH(B36,$B$5:B35,0))))","v":""}]
[{"$f":"IF(B37=\"\",\"\",IF(COUNTIF($B$6:B37,B37)=1,MAX($A$6:A36)+1,INDEX($A$5:A36,MATCH(B37,$B$5:B36,0))))","v":""}]
[{"$f":"IF(B38=\"\",\"\",IF(COUNTIF($B$6:B38,B38)=1,MAX($A$6:A37)+1,INDEX($A$5:A37,MATCH(B38,$B$5:B37,0))))","v":""}]
[{"$f":"IF(B39=\"\",\"\",IF(COUNTIF($B$6:B39,B39)=1,MAX($A$6:A38)+1,INDEX($A$5:A38,MATCH(B39,$B$5:B38,0))))","v":""}]
[{"$f":"IF(B40=\"\",\"\",IF(COUNTIF($B$6:B40,B40)=1,MAX($A$6:A39)+1,INDEX($A$5:A39,MATCH(B40,$B$5:B39,0))))","v":""}]
[{"$f":"IF(B41=\"\",\"\",IF(COUNTIF($B$6:B41,B41)=1,MAX($A$6:A40)+1,INDEX($A$5:A40,MATCH(B41,$B$5:B40,0))))","v":""}]
[{"$f":"IF(B42=\"\",\"\",IF(COUNTIF($B$6:B42,B42)=1,MAX($A$6:A41)+1,INDEX($A$5:A41,MATCH(B42,$B$5:B41,0))))","v":""}]
[{"$f":"IF(B43=\"\",\"\",IF(COUNTIF($B$6:B43,B43)=1,MAX($A$6:A42)+1,INDEX($A$5:A42,MATCH(B43,$B$5:B42,0))))","v":""}]
[{"$f":"IF(B44=\"\",\"\",IF(COUNTIF($B$6:B44,B44)=1,MAX($A$6:A43)+1,INDEX($A$5:A43,MATCH(B44,$B$5:B43,0))))","v":""}]
[{"$f":"IF(B45=\"\",\"\",IF(COUNTIF($B$6:B45,B45)=1,MAX($A$6:A44)+1,INDEX($A$5:A44,MATCH(B45,$B$5:B44,0))))","v":""}]

{"sheet":"Sheet2","index":1,"n_rows":13,"n_cols":10,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,"بحث برقم العميل","التاريخ من","التاريخ الى"]
[null,null,null,null,null,null,null,101,"2019-12-12","2020-01-01"]
[]
[]
["التاريخ","نوع العملية","الواجب"]
["16/12/2019","B",3000]
["20/12/2019","V",400]
["29/12/2019","A",6000]
["2020-01-01","AB",2587]
["2020-01-01","D",900]
["2020-01-01","A",1500]
["2020-01-01","AB",2000]
["2020-01-01","V",654]

{"sheet":"Sheet3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}