{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["عميل1","عميل2","عميل3","عميل4","عميل5","اجمالي","عميل6"],"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":"عميل1","index":0,"n_rows":21,"n_cols":5,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["عميل1"]
["التاريخ","البيان","مدين","دائن","الرصيد"]
["2018-08-01","مبيعات",1000,null,{"$f":"C3-D3","v":1000}]
["2018-08-02","تسديدات",null,200,{"$f":"E3+C4-D4","v":800}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"SUM(C3:C20)","v":1000},{"$f":"SUM(D3:D20)","v":200},{"$f":"C21-D21","v":800}]

{"sheet":"عميل2","index":1,"n_rows":21,"n_cols":5,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["عميل2"]
["التاريخ","البيان","مدين","دائن","الرصيد"]
["2018-08-01","مبيعات",5600,null,{"$f":"C3-D3","v":5600}]
["2018-08-02","تسديدات",null,2000,{"$f":"E3+C4-D4","v":3600}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"SUM(C3:C20)","v":5600},{"$f":"SUM(D3:D20)","v":2000},{"$f":"C21-D21","v":3600}]

{"sheet":"عميل3","index":2,"n_rows":21,"n_cols":5,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["عميل3"]
["التاريخ","البيان","مدين","دائن","الرصيد"]
["2018-08-01","مبيعات",4600,null,{"$f":"C3-D3","v":4600}]
["2018-08-02","تسديدات",null,1900,{"$f":"E3+C4-D4","v":2700}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"SUM(C3:C20)","v":4600},{"$f":"SUM(D3:D20)","v":1900},{"$f":"C21-D21","v":2700}]

{"sheet":"عميل4","index":3,"n_rows":21,"n_cols":5,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["عميل4"]
["التاريخ","البيان","مدين","دائن","الرصيد"]
["2018-08-01","مبيعات",4654,null,{"$f":"C3-D3","v":4654}]
["2018-08-02","تسديدات",null,4100,{"$f":"E3+C4-D4","v":554}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"SUM(C3:C20)","v":4654},{"$f":"SUM(D3:D20)","v":4100},{"$f":"C21-D21","v":554}]

{"sheet":"عميل5","index":4,"n_rows":21,"n_cols":5,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["عميل5"]
["التاريخ","البيان","مدين","دائن","الرصيد"]
["2018-08-01","مبيعات",6547,null,{"$f":"C3-D3","v":6547}]
["2018-08-02","تسديدات",null,4562,{"$f":"E3+C4-D4","v":1985}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"SUM(C3:C20)","v":6547},{"$f":"SUM(D3:D20)","v":4562},{"$f":"C21-D21","v":1985}]

{"sheet":"اجمالي","index":5,"n_rows":19,"n_cols":4,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[null,"مدين","دائن","الرصيد"]
["عميل1",1000,200,800]
["عميل2",5600,2000,3600]
["عميل3",4600,1900,2700]
["عميل4",4654,4100,554]
["عميل5",6547,4562,1985]
["عميل6",100,80,20]
["الإجمالي",22501,22501,22501]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"SUM(B2:B18)","v":45002},{"$f":"SUM(C2:C18)","v":35343},{"$f":"B19-C19","v":9659}]

{"sheet":"عميل6","index":6,"n_rows":21,"n_cols":5,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["عميل6"]
["التاريخ","البيان","مدين","دائن","الرصيد"]
["2018-08-01","مبيعات",100,null,{"$f":"C3-D3","v":100}]
["2018-08-02","تسديدات",null,80,{"$f":"E3+C4-D4","v":20}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"SUM(C3:C20)","v":100},{"$f":"SUM(D3:D20)","v":80},{"$f":"C21-D21","v":20}]