{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["كشف حساب عميل","ALL","Repport"],"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":"كشف حساب عميل","index":0,"n_rows":511,"n_cols":7,"rows_kept":511,"cut":false,"hidden":true,"merged":[[8,6,8,7],[9,6,9,7],[10,6,10,7],[509,0,509,1],[510,0,510,1],[7,6,7,7],[1,0,1,5],[2,0,2,1],[3,0,3,1],[5,6,5,7],[6,6,6,7]]}
[]
["كشف حساب"]
["اسم العميل",null,"كتابة اسم العميل هنا",null,"من تاريخ","2021-01-01"]
["اجمالي الدين",null,{"$f":"G7","v":0},null,"الي تاريخ",{"$f":"NOW()","v":"2021-05-14T00:57:44.720"}]
["مسلسل","تاريخ الاصدار","البيــــــــــان","مديـــن","دائـــن","الرصيد"]
[{"$f":"IF(B6=\"\",\"\",ROW()-5)","v":""},null,null,null,null,{"$f":"D6-E6","v":0},"اجمالي الدين"]
["",null,null,null,null,{"$f":"F6+D7-E7","v":0},{"$f":"G9-G11","v":0}]
["",null,null,null,null,{"$f":"F7+D8-E8","v":0},"اجمالي الفواتير"]
["",null,null,null,null,0,{"$f":"SUM(D6:D509)","v":0}]
["",null,null,null,null,0,"اجمالي التنزيلات"]
["",null,null,null,null,0,{"$f":"SUM(E6:E509)","v":0}]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
[{"$f":"IF(B70=\"\",\"\",ROW()-5)","v":""},null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,{"$f":"F71+D72-E72","v":0}]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
[{"$f":"IF(B134=\"\",\"\",ROW()-5)","v":""},null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,{"$f":"F135+D136-E136","v":0}]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
[{"$f":"IF(B198=\"\",\"\",ROW()-5)","v":""},null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,{"$f":"F199+D200-E200","v":0}]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
[{"$f":"IF(B262=\"\",\"\",ROW()-5)","v":""},null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,{"$f":"F263+D264-E264","v":0}]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
[{"$f":"IF(B326=\"\",\"\",ROW()-5)","v":""},null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,{"$f":"F327+D328-E328","v":0}]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
[{"$f":"IF(B390=\"\",\"\",ROW()-5)","v":""},null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,{"$f":"F391+D392-E392","v":0}]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
[{"$f":"IF(B454=\"\",\"\",ROW()-5)","v":""},null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,{"$f":"F455+D456-E456","v":0}]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["",null,null,null,null,0]
["مديــــــــن",null,null,null,null,0]
[{"$f":"G7","v":0},null,null,null,null,0]

{"sheet":"ALL","index":1,"n_rows":8,"n_cols":5,"rows_kept":8,"cut":false,"hidden":false,"merged":[[0,0,0,4]]}
["اعدادات كشف الحساب"]
["تاريخ الاصدار","اسم العميل","البيــــــــــان","مديـــن","دائـــن"]
["2021-03-25T21:16:37","حسن","فاتورة قم 365",500,0]
["2021-03-25T21:16:36.740","jamil","فاتورة قم 160",222,150]
["2021-03-25T21:16:36.740","حسن","فاتورة قم 161",777,0]
["2021-03-26","سيد","فاتورة قم 500",1,1]
["2021-05-01","حسن","فاتورة قم 501",100,70]
["2021-03-21","jamil","فاتورة قم 140",750,400]

{"sheet":"Repport","index":2,"n_rows":9,"n_cols":6,"rows_kept":9,"cut":false,"hidden":false,"merged":[[10,6,10,7],[11,6,11,7],[12,6,12,7],[9,6,9,7],[1,0,1,5],[2,0,2,1],[3,0,3,1],[7,6,7,7]]}
[]
["كشف حساب"]
["اسم العميل",null,"jamil",null,"من تاريخ","2021-01-01"]
["اجمالي الدين",null,{"$f":"SUM($D$8:$D$511)-SUM($E$8:$E$511)","v":422},null,"الي تاريخ",{"$f":"NOW()","v":"2021-05-14T00:57:44.720"}]
["تاريخ الاصدار","اسم العميل","البيــــــــــان","مديـــن","دائـــن","الرصيد"]
[]
[]
["2021-03-25T21:16:36.740","jamil","فاتورة قم 160",222,150]
["2021-03-21","jamil","فاتورة قم 140",750,400]