{"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":1,"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":10,"n_cols":14,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["التاريخ","العميل","نوع السند","رقم السند","مدين","دائن",null,"ملاحظة","التكرار",null,null,null,"خالد","رصيد بداية المدة"]
["2018-05-17","خالد","رصيد بداية المدة",1,70,0,null,"دفعة",{"$f":"COUNTIF(Sheet2!$D$1:$D$9999,Sheet1!$D2)","v":2},null,null,null,"محمد","سند قبض"]
["2018-05-17","محمد","رصيد بداية المدة",null,30,0,null,"دفعة",{"$f":"COUNTIF(Sheet2!$D$1:$D$9999,Sheet1!$D3)","v":0},null,null,null,"احمد","فاتورة"]
["2018-05-17","خالد","رصيد بداية المدة",null,70,0,null,"دفعة",{"$f":"COUNTIF(Sheet2!$D$1:$D$9999,Sheet1!$D4)","v":0}]
["2018-05-17","خالد","رصيد بداية المدة",null,70,0,null,"دفعة",{"$f":"COUNTIF(Sheet2!$D$1:$D$9999,Sheet1!$D5)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"COUNTIF(Sheet2!$D$1:$D$9999,Sheet1!$D6)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"COUNTIF(Sheet2!$D$1:$D$9999,Sheet1!$D7)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"COUNTIF(Sheet2!$D$1:$D$9999,Sheet1!$D8)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"COUNTIF(Sheet2!$D$1:$D$9999,Sheet1!$D9)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"COUNTIF(Sheet2!$D$1:$D$9999,Sheet1!$D10)","v":0}]

{"sheet":"Sheet2","index":1,"n_rows":9,"n_cols":8,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["التاريخ","العميل","نوع السند","رقم المستند","مدين","دائن","الرصيد","ملاحظة"]
["2018-05-17","خالد","رصيد بداية المدة",1,0,70,-70,"دفعة"]
["2018-05-17","محمد","رصيد بداية المدة",2,0,30,-30,"دفعة"]
["2018-05-17","خالد","رصيد بداية المدة",3,0,70,-140,"دفعة"]
["2018-05-17","خالد","رصيد بداية المدة",4,0,70,-210,"دفعة"]
["2018-05-17","خالد","رصيد بداية المدة",1,70,0,-140,"دفعة"]
["2018-05-17","محمد","رصيد بداية المدة",2,30,0,0,"دفعة"]
["2018-05-17","خالد","رصيد بداية المدة",3,70,0,-70,"دفعة"]
["2018-05-17","خالد","رصيد بداية المدة",4,70,0,0,"دفعة"]

{"sheet":"Sheet3","index":2,"n_rows":14,"n_cols":10,"rows_kept":14,"cut":false,"hidden":false,"merged":[[2,2,3,2],[2,3,3,5]]}
[]
[]
[null,null,"اسم العميل","خالد",null,null,null,null,"تاريخ البداية ",{"$f":"IF(K3<>\"\",K3,TODAY()-DAY(EOMONTH(TODAY(),0)))","v":{"$error":"#NAME?"}}]
[null,null,null,null,null,null,null,null,"تاريخ النهاية",{"$f":"IF(K4<>\"\",K4,TODAY())","v":"2018-05-25"}]
[]
[]
[]
[null,null,"التاريخ","العميل","نوع السند","رقم المستند","مدين","دائن","الرصيد","ملاحظة"]
[null,null,"2018-05-17","خالد","رصيد بداية المدة",1,0,70,-70,"دفعة"]
[null,null,"2018-05-17","خالد","رصيد بداية المدة",3,0,70,-140,"دفعة"]
[null,null,"2018-05-17","خالد","رصيد بداية المدة",4,0,70,-210,"دفعة"]
[null,null,"2018-05-17","خالد","رصيد بداية المدة",1,70,0,-140,"دفعة"]
[null,null,"2018-05-17","خالد","رصيد بداية المدة",3,70,0,-70,"دفعة"]
[null,null,"2018-05-17","خالد","رصيد بداية المدة",4,70,0,0,"دفعة"]