{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["الرئسيه","الاستعلام","Sheet3"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":4,"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":"الرئسيه","index":0,"n_rows":19,"n_cols":39,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["التسلسل","اسم العميل","تاريخ الشراء","مده القسط","تاريخ الانتهاء","اجمالى الثمن","قيمه القسط","المتبقى ",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31]
[{"$f":"IF(B2=\"\",\"\",(SUBTOTAL(3,$B$2:B2)))","v":1},"عهدى","2020-02-14",6,{"$f":"EOMONTH(C2,D2)","v":"2020-08-31"},2000,{"$f":"IF(F2=\"\",\"\",F2/D2)","v":333.33333333333331},{"$f":"F2-SUM(I2:AR2)","v":2000}]
[{"$f":"IF(B3=\"\",\"\",(SUBTOTAL(3,$B$2:B3)))","v":2},"عدى","2020-02-14",7,{"$f":"IF(C3=\"\",\"\",(EOMONTH(C3,D3)))","v":"2020-09-30"},5000,714.28571428571433,{"$f":"F3-SUM(I3:AR3)","v":5000}]
[{"$f":"IF(B4=\"\",\"\",(SUBTOTAL(3,$B$2:B4)))","v":3},"رويدا","2020-02-14",12,{"$f":"IF(C4=\"\",\"\",(EOMONTH(C4,D4)))","v":"2021-02-28"},20000,1666.6666666666667,20000]
[{"$f":"IF(B5=\"\",\"\",(SUBTOTAL(3,$B$2:B5)))","v":4},"حكيم","2020-02-14",6,"2020-08-31",10000,1666.6666666666667,10000]
[{"$f":"IF(B6=\"\",\"\",(SUBTOTAL(3,$B$2:B6)))","v":""},null,null,null,"",null,"",0]
[{"$f":"IF(B7=\"\",\"\",(SUBTOTAL(3,$B$2:B7)))","v":""},null,null,null,"",null,"",0]
[{"$f":"IF(B8=\"\",\"\",(SUBTOTAL(3,$B$2:B8)))","v":""},null,null,null,"",null,"",0]
[{"$f":"IF(B9=\"\",\"\",(SUBTOTAL(3,$B$2:B9)))","v":""},null,null,null,"",null,"",0]
[{"$f":"IF(B10=\"\",\"\",(SUBTOTAL(3,$B$2:B10)))","v":""},null,null,null,"",null,"",0]
[{"$f":"IF(B11=\"\",\"\",(SUBTOTAL(3,$B$2:B11)))","v":""},null,null,null,"",null,"",0]
[{"$f":"IF(B12=\"\",\"\",(SUBTOTAL(3,$B$2:B12)))","v":""},null,null,null,"",null,"",0]
[{"$f":"IF(B13=\"\",\"\",(SUBTOTAL(3,$B$2:B13)))","v":""},null,null,null,"",null,"",0]
[{"$f":"IF(B14=\"\",\"\",(SUBTOTAL(3,$B$2:B14)))","v":""},null,null,null,"",null,"",0]
[{"$f":"IF(B15=\"\",\"\",(SUBTOTAL(3,$B$2:B15)))","v":""},null,null,null,"",null,"",0]
[{"$f":"IF(B16=\"\",\"\",(SUBTOTAL(3,$B$2:B16)))","v":""},null,null,null,"",null,"",0]
[{"$f":"IF(B17=\"\",\"\",(SUBTOTAL(3,$B$2:B17)))","v":""},null,null,null,"",null,"",0]
[{"$f":"IF(B18=\"\",\"\",(SUBTOTAL(3,$B$2:B18)))","v":""},null,null,null,"",null,"",0]
[{"$f":"IF(B19=\"\",\"\",(SUBTOTAL(3,$B$2:B19)))","v":""},null,null,null,"",null,"",0]

{"sheet":"الاستعلام","index":1,"n_rows":7,"n_cols":8,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,"اجمالى المتبقى"]
[null,null,null,null,null,null,null,{"$f":"SUM(H7:H80000)","v":20000}]
["التسلسل","اسم العميل","تاريخ الشراء","مده القسط","تاريخ الانتهاء","اجمالى الثمن","قيمه القسط","المتبقى "]
[null,"رويدا"]
[]
["التسلسل","اسم العميل","تاريخ الشراء","مده القسط","تاريخ الانتهاء","اجمالى الثمن","قيمه القسط","المتبقى "]
[3,"رويدا","2020-02-14",12,"2021-02-28",20000,1666.6666666666667,20000]

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