{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Main","Modul","1","2","3","4","5"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":84,"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":"Main","index":0,"n_rows":27,"n_cols":12,"rows_kept":27,"cut":false,"hidden":false,"merged":[[7,5,9,5],[7,0,9,0],[7,1,9,1],[7,2,9,2],[7,3,9,3],[7,4,9,4],[7,6,9,6],[7,7,9,7],[7,8,7,10],[7,11,9,11],[8,8,9,8],[8,9,8,10]]}
[]
[]
[]
[]
[]
[]
[]
["م","رقم السند قبض صرف فاتورة","رقم الكود","الحركة","التاريخ","الاسم","الاسم 2","بيان","الحركـــــة",null,null,"رصيد"]
[null,null,null,null,null,null,null,null,"قبض","صرف"]
[null,null,null,null,null,null,null,null,null,1,2]
[]
[1,1,1,"صرف","2020-09-01","محمد 1","خالد 1","صرف",0,100,0,{"$f":"IF(AND(I12=\"\",J12=\"\"),\"\",L11+I12-J12-K12)","v":-100}]
[2,7,2,"قبض","2020-09-02","محمد 2","خالد 2","قبض",500,0,0,{"$f":"IF(AND(I13=\"\",J13=\"\"),\"\",L12+I13-J13-K13)","v":400}]
[3,9,3,"صرف","2020-09-03","محمد 3","خالد 3","صرف",0,0,200,200]
[4,12,1,"قبض","2020-09-04","محمد 4","خالد 4","قبض",500,0,0,700]
[5,6,1,"صرف","2020-09-05","محمد 5","خالد 5","صرف",0,100,0,600]
[6,5,3,"صرف","2020-09-06","محمد 6","خالد 6","صرف",0,100,0,500]
[7,14,4,"صرف","2020-09-07","محمد 7","خالد 7","صرف",0,0,100,400]
[8,2,2,"قبض","2020-09-08","محمد 8","خالد 8","قبض",500,0,500,{"$f":"IF(AND(I19=\"\",J19=\"\"),\"\",L18+I19-J19-K19)","v":400}]
[9,3,5,"قبض","2020-09-09","محمد 9","خالد 9","قبض",500,0,700,200]
[9,3,5,"قبض","2020-09-10","محمد 10","خالد 10","قبض",500,0,700,{"$f":"IF(AND(I21=\"\",J21=\"\"),\"\",L20+I21-J21-K21)","v":0}]
[9,3,5,"قبض","2020-09-11","محمد 11","خالد 11","قبض",500,0,700,-200]
[9,3,5,"قبض","2020-09-12","محمد 12","خالد 12","قبض",500,0,700,-400]
[9,3,3,"قبض","2020-09-13","محمد 13","خالد 13","قبض",500,0,700,-600]
[9,3,3,"قبض","2020-09-14","محمد 14","خالد 14","قبض",500,0,700,-800]
[9,3,4,"قبض","2020-09-15","محمد 15","خالد 15","قبض",500,0,700,-1000]
[9,3,4,"قبض","2020-09-16","محمد 16","خالد 16","قبض",500,0,700,-1200]

{"sheet":"Modul","index":1,"n_rows":20,"n_cols":12,"rows_kept":20,"cut":false,"hidden":true,"merged":[[7,6,9,6],[7,7,9,7],[7,8,7,10],[7,11,9,11],[8,8,9,8],[8,9,8,10],[7,5,9,5],[7,0,9,0],[7,1,9,1],[7,2,9,2],[7,3,9,3],[7,4,9,4]]}
[]
[]
[]
[]
[]
[]
[]
["م","رقم السند قبض صرف فاتورة","رقم الكود","الحركة","التاريخ","الاسم","الاسم 2","بيان","الحركـــــة",null,null,"رصيد"]
[null,null,null,null,null,null,null,null,"قبض","صرف"]
[null,null,null,null,null,null,null,null,null,1,2]
[]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(I12=\"\",J12=\"\"),\"\",L11+I12-J12-K12)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(I13=\"\",J13=\"\"),\"\",L12+I13-J13-K13)","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,{"$f":"IF(AND(I19=\"\",J19=\"\"),\"\",L18+I19-J19-K19)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,""]

{"sheet":"1","index":2,"n_rows":15,"n_cols":11,"rows_kept":15,"cut":false,"hidden":false,"merged":[[7,6,9,6],[7,7,9,7],[7,8,7,10],[8,8,9,8],[8,9,8,10],[7,0,9,0],[7,1,9,1],[7,2,9,2],[7,3,9,3],[7,4,9,4],[7,5,9,5]]}
[]
[]
[]
[]
[]
[]
[]
["م","رقم السند قبض صرف فاتورة","رقم الكود","الحركة","التاريخ","الاسم","الاسم 2","بيان","الحركـــــة"]
[null,null,null,null,null,null,null,null,"قبض","صرف"]
[null,null,null,null,null,null,null,null,null,1,2]
[]
[1,1,1,"صرف","2020-09-01","محمد 1","خالد 1","صرف",0,100,0]
[2,12,1,"قبض","2020-09-04","محمد 4","خالد 4","قبض",500,0,0]
[3,6,1,"صرف","2020-09-05","محمد 5","خالد 5","صرف",0,100,0]
[4,null,null,null,null,null,null,null,null,null,0]

{"sheet":"2","index":3,"n_rows":14,"n_cols":11,"rows_kept":14,"cut":false,"hidden":false,"merged":[[7,6,9,6],[7,7,9,7],[7,8,7,10],[8,8,9,8],[8,9,8,10],[7,0,9,0],[7,1,9,1],[7,2,9,2],[7,3,9,3],[7,4,9,4],[7,5,9,5]]}
[]
[]
[]
[]
[]
[]
[]
["م","رقم السند قبض صرف فاتورة","رقم الكود","الحركة","التاريخ","الاسم","الاسم 2","بيان","الحركـــــة"]
[null,null,null,null,null,null,null,null,"قبض","صرف"]
[null,null,null,null,null,null,null,null,null,1,2]
[]
[1,7,2,"قبض","2020-09-02","محمد 2","خالد 2","قبض",500,0,0]
[2,2,2,"قبض","2020-09-08","محمد 8","خالد 8","قبض",500,0,500]
[3,null,null,null,null,null,null,null,null,null,500]

{"sheet":"3","index":4,"n_rows":15,"n_cols":11,"rows_kept":15,"cut":false,"hidden":false,"merged":[[7,6,9,6],[7,7,9,7],[7,8,7,10],[8,8,9,8],[8,9,8,10],[7,0,9,0],[7,1,9,1],[7,2,9,2],[7,3,9,3],[7,4,9,4],[7,5,9,5]]}
[]
[]
[]
[]
[]
[]
[]
["م","رقم السند قبض صرف فاتورة","رقم الكود","الحركة","التاريخ","الاسم","الاسم 2","بيان","الحركـــــة"]
[null,null,null,null,null,null,null,null,"قبض","صرف"]
[null,null,null,null,null,null,null,null,null,1,2]
[]
[1,9,3,"صرف","2020-09-03","محمد 3","خالد 3","صرف",0,0,200]
[2,5,3,"صرف","2020-09-06","محمد 6","خالد 6","صرف",0,100,0]
[3,3,3,"قبض","2020-09-13","محمد 13","خالد 13","قبض",500,0,700]
[4,3,3,"قبض","2020-09-14","محمد 14","خالد 14","قبض",500,0,700]

{"sheet":"4","index":5,"n_rows":14,"n_cols":11,"rows_kept":14,"cut":false,"hidden":false,"merged":[[7,6,9,6],[7,7,9,7],[7,8,7,10],[8,8,9,8],[8,9,8,10],[7,0,9,0],[7,1,9,1],[7,2,9,2],[7,3,9,3],[7,4,9,4],[7,5,9,5]]}
[]
[]
[]
[]
[]
[]
[]
["م","رقم السند قبض صرف فاتورة","رقم الكود","الحركة","التاريخ","الاسم","الاسم 2","بيان","الحركـــــة"]
[null,null,null,null,null,null,null,null,"قبض","صرف"]
[null,null,null,null,null,null,null,null,null,1,2]
[]
[1,14,4,"صرف","2020-09-07","محمد 7","خالد 7","صرف",0,0,100]
[2,3,4,"قبض","2020-09-15","محمد 15","خالد 15","قبض",500,0,700]
[3,3,4,"قبض","2020-09-16","محمد 16","خالد 16","قبض",500,0,700]

{"sheet":"5","index":6,"n_rows":15,"n_cols":11,"rows_kept":15,"cut":false,"hidden":false,"merged":[[7,6,9,6],[7,7,9,7],[7,8,7,10],[8,8,9,8],[8,9,8,10],[7,0,9,0],[7,1,9,1],[7,2,9,2],[7,3,9,3],[7,4,9,4],[7,5,9,5]]}
[]
[]
[]
[]
[]
[]
[]
["م","رقم السند قبض صرف فاتورة","رقم الكود","الحركة","التاريخ","الاسم","الاسم 2","بيان","الحركـــــة"]
[null,null,null,null,null,null,null,null,"قبض","صرف"]
[null,null,null,null,null,null,null,null,null,1,2]
[]
[1,3,5,"قبض","2020-09-09","محمد 9","خالد 9","قبض",500,0,700]
[2,3,5,"قبض","2020-09-10","محمد 10","خالد 10","قبض",500,0,700]
[3,3,5,"قبض","2020-09-11","محمد 11","خالد 11","قبض",500,0,700]
[4,3,5,"قبض","2020-09-12","محمد 12","خالد 12","قبض",500,0,700]