{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Achat","Detail","By_date"],"not_rendered":{"charts":0,"images":0,"macros":1,"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":"Achat","index":0,"n_rows":9,"n_cols":5,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["رقم بطاقة السكن","الاسم","مبلغ الشراء","التاريخ","التسديد"]
[635,"بدران",100,"2019-01-01",100]
[684,"رشيد",50,"2019-01-01",50]
[320,"Officena",270,"2019-01-23",100]
[635,"بدران",10,"2019-01-02",10]
[684,"رشيد",15,"2019-01-02",10]
[635,"بدران",70,"2019-01-03",50]
[360,"حماد",10,"2019-01-03",10]
[500,"Officena",150,"2019-01-25",100]

{"sheet":"Detail","index":1,"n_rows":118,"n_cols":9,"rows_kept":118,"cut":false,"hidden":false,"merged":[]}
["رقم بطاقة السكن","الاسم","مبلغ الشراء","التاريخ","التسديد","المتبقي بذمة الزبون"]
[635,"بدران",100,"2019-01-01",100,{"$f":"IF(NOT(ISNUMBER(C2)),\"\",SUM(C2,-E2))","v":0},null,null," =IF(NOT(ISNUMBER(C2)),\"\",SUM(C2,-E2))"]
[635,"بدران",10,"2019-01-02",10,0]
[635,"بدران",70,"2019-01-03",50,20]
["Sum",null,{"$f":"SUM(C2:C4)","v":180},null,{"$f":"SUM(E2:E4)","v":160},{"$f":"SUM(F2:F4)","v":20}]
["رقم بطاقة السكن","الاسم","مبلغ الشراء","التاريخ","التسديد",""]
[684,"رشيد",50,"2019-01-01",50,0]
[684,"رشيد",15,"2019-01-02",10,5]
["Sum",null,{"$f":"SUM(C7:C8)","v":65},null,{"$f":"SUM(E7:E8)","v":60},{"$f":"SUM(F7:F8)","v":5}]
["رقم بطاقة السكن","الاسم","مبلغ الشراء","التاريخ","التسديد",""]
[320,"Officena",270,"2019-01-23",100,170]
[500,"Officena",150,"2019-01-25",100,50]
["Sum",null,{"$f":"SUM(C11:C12)","v":420},null,{"$f":"SUM(E11:E12)","v":200},{"$f":"SUM(F11:F12)","v":220}]
["رقم بطاقة السكن","الاسم","مبلغ الشراء","التاريخ","التسديد",""]
[360,"حماد",10,"2019-01-03",10,0]
["Sum",null,{"$f":"SUM(C15:C15)","v":10},null,{"$f":"SUM(E15:E15)","v":10},{"$f":"SUM(F15:F15)","v":0}]
[null,null,null,null,null,{"$f":"IF(NOT(ISNUMBER(C17)),\"\",SUM(C17,-E17))","v":""}]
[null,null,null,null,null,{"$f":"SUM(F17:F17)","v":0}]
[null,null,null,null,null,{"$f":"IF(NOT(ISNUMBER(C19)),\"\",SUM(C19,-E19))","v":""}]
[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,"",{"$f":"SUM(G23:G24)","v":0},{"$f":"SUM(H23:H24)","v":0}]
[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,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,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,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,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,""]
[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,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,{"$f":"IF(NOT(ISNUMBER(C67)),\"\",SUM(C67,-E67))","v":""}]
[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,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,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,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,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,""]
[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,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,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,""]

{"sheet":"By_date","index":2,"n_rows":6,"n_cols":2,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["مجموع مبلغ الشراء حسب التاريخ","التاريخ"]
[150,"2019-01-01"]
[270,"2019-01-23"]
[25,"2019-01-02"]
[80,"2019-01-03"]
[150,"2019-01-25"]