{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["نوفمبر 2020"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":1,"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":"نوفمبر 2020","index":0,"n_rows":9,"n_cols":8,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["التاريخ من","التاريخ الى","الاسم","اجمالى المبلغ","اجمالى الديون",null,"اجمالى المبلغ","اجمالى الديون"]
["2020-11-15","2020-11-16","الازهرى",{"$f":"SUMIFS(D5:D10,C5:C10,\"=\"&C2,B5:B10,\"<=\"&B2,B5:B10,\">=\"&A2)","v":1000},{"$f":"SUMIFS(E5:E10,C5:C10,\"=\"&C2,B5:B10,\"<=\"&B2,B5:B10,\">=\"&A2)","v":500},null,{"$f":"SUMPRODUCT(--(B5:B10<=B2),--(B5:B10>=A2),--(C5:C10=C2),D5:D10)","v":1000},{"$f":"SUMPRODUCT(--(B5:B10<=B2),--(B5:B10>=A2),--(C5:C10=C2),E5:E10)","v":500}]
[]
["مسلسل","التاريخ","الكلية","المبلغ","اجمالى الديون"]
[1,"2020-11-15","مصطفى محمود",500,2000,null,null,"المطلوب جمع المبلغ وجمع الديون بناء على التاريخ من ال والاسم مع الشكر"]
[2,"2020-11-16","مصطفى محمود",100,117539]
[3,"2020-11-16","مصطفى حسين",6000,8000]
[4,"2020-11-16","احمد رمزى",5000,4000]
[5,"2020-11-16","الازهرى",1000,500]