{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["اجمالي","محمد ايهاب","محمد ايمن","احمد ناصر","محمد محسن","Sheet2"],"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":7,"n_cols":11,"rows_kept":7,"cut":false,"hidden":false,"merged":[[6,1,6,3]]}
[]
[null,"#","رقم العقد","اسم العميل","قيمة العقد","عدد الاقساط المسددة","قيمة الاقساط المسددة","عدد الاقساط الغير مسددة","قيمة الاقساط الغير مسددة",null,"اضغط الزر اسفله و ستشاهد النتيجة بنفسك"]
[null,1,2,"محمد ايهاب"]
[null,2,3,"محمد ايمن"]
[null,3,5,"احمد ناصر"]
[null,4,6,"محمد محسن"]
[null,"الإجمالي",null,null,{"$f":"SUM(E3:E6)","v":0},{"$f":"SUM(F3:F6)","v":0},0,0,0]

{"sheet":"محمد ايهاب","index":1,"n_rows":41,"n_cols":10,"rows_kept":41,"cut":false,"hidden":false,"merged":[[1,1,1,2],[4,1,4,9],[37,7,37,8],[38,7,38,8]]}
[]
[null,null,null,{"$f":"SMALL(IF($B$14:$B$100=\"عدد الأقساط المسددة :\",ROW($B$14:$B$100)),ROW(A1))","v":{"$error":"#VALUE!"}},null,null,null,null,null,{"$f":"OFFSET($C$14,SMALL(IF($B$14:$B$100=\"عدد الأقساط المسددة :\",ROW($B$14:$B$100)),ROW(A1))-14,0)","v":{"$error":"#VALUE!"}}]
[]
[]
[null,"كشف حساب عميل"]
[]
[null,"إسم العميل :","محمد ايهاب",null,null,null,null,null,"قيمة العقد",50400]
[null,"رقم العميل :",50002,null,null,null,null,null,"قيمة القسط :",2100]
[null,"رقم العقد :",2,null,null,null,null,null,"عدد الأقساط :",{"$f":"J7/J8","v":24}]
[null,"تاريخ العقد :","2019-08-21"]
[]
[]
[null,"رقم القسط","تاريخ الإستحقاق","تاريح السداد","عدد الأيام المتأخرة","المبلغ المدفوع","المبلغ المتبقي","حالة السداد","حالة القسط","البنك"]
[null,1,"2019-09-27","2019-09-27",{"$f":"IF(D14<=C14,0,D14-C14)","v":0},2100,{"$f":"$J$7-F14","v":48300},"منتظم","مدفوع"]
[null,2,"2019-10-27","2019-10-27",0,2100,{"$f":"G14-F15","v":46200},"منتظم","مدفوع"]
[null,3,"2019-11-27","2019-11-27",0,2100,{"$f":"G15-F16","v":44100},"منتظم","مدفوع"]
[null,4,"2019-12-27","2019-12-27",0,2100,42000,"منتظم","مدفوع"]
[null,5,"2020-01-27","2020-01-27",0,2100,39900,"منتظم","مدفوع"]
[null,6,"2020-02-27","2020-02-27",0,2100,37800,"منتظم","مدفوع"]
[null,7,"2020-03-27","2020-03-27",0,2100,35700,"منتظم","مدفوع"]
[null,8,"2020-04-27","2020-04-27",0,2100,33600,"منتظم","مدفوع"]
[null,9,"2020-05-27","2020-05-27",0,2100,31500,"منتظم","مدفوع"]
[null,10,"2020-06-27","2020-06-27",0,2100,29400,"منتظم","مدفوع"]
[null,11,"2020-07-27","2020-07-27",0,2100,27300,"منتظم","مدفوع"]
[null,12,"2020-08-27","2020-08-27",0,2100,25200,"منتظم","مدفوع"]
[null,13,"2020-09-27","2020-08-27",0,2100,23100,"منتظم","مدفوع"]
[null,14,"2020-10-27","2020-08-27",0,600,22500,"غير مسدد","مدفوع جزئي"]
[null,15,"2020-11-27",null,0,null,22500,"غير مسدد",{"$f":"IF(C28<=TODAY(),\"مستحق\",\"\")","v":"مستحق"}]
[null,16,"2020-12-27",null,0,null,22500,"غير مسدد","مستحق"]
[null,17,"2021-01-27",null,0,null,22500,"غير مسدد","مستحق"]
[null,18,"2021-02-27",null,0,null,22500,"غير مسدد","مستحق"]
[null,19,"2021-03-27",null,0,null,22500,"غير مسدد","مستحق"]
[null,20,"2021-04-27",null,0,null,22500,"غير مسدد","مستحق"]
[null,21,"2021-05-27",null,0,null,22500,"غير مسدد","مستحق"]
[null,22,"2021-06-27",null,0,null,22500,"غير مسدد","مستحق"]
[null,23,"2021-07-27",null,0,null,22500,"غير مسدد","مستحق"]
[null,24,"2021-08-27",null,0,null,22500,"غير مسدد","مستحق"]
[null,"عدد الأقساط المسددة :",{"$f":"COUNTIF(F14:F37,2100)","v":13},null,null,null,null,"عدد الأقساط الغير مسددة :",null,{"$f":"COUNTIF(H14:H37,\"غير مسدد\")","v":11}]
[null,"قيمة الأقساط المسددة :",{"$f":"SUM(F14:F37)","v":27900},null,null,null,null,"قيمة الأقساط الغير مسددة :",null,{"$f":"J8*J38","v":23100}]
[]
[null,null,null,null,{"$f":"COUNTA(B14:B38)","v":25}]

{"sheet":"محمد ايمن","index":2,"n_rows":39,"n_cols":10,"rows_kept":39,"cut":false,"hidden":false,"merged":[[38,7,38,8],[4,1,4,9],[1,1,1,2],[37,7,37,8]]}
[]
[]
[]
[]
[null,"كشف حساب عميل"]
[]
[null,"إسم العميل :","محمد ايمن",null,null,null,null,null,"قيمة لعقد",12000]
[null,"رقم العميل :",50003,null,null,null,null,null,"قيمة القسط :",500]
[null,"رقم العقد :",3,null,null,null,null,null,"عدد الأقساط :"]
[null,"تاريخ العقد :","2021-04-22"]
[]
[]
[null,"رقم القسط","تاريخ الإستحقاق","تاريح السداد","عدد الأيام المتأخرة","المبلغ المدفوع","المبلغ المتبقي","حالة السداد","حالة القسط","البنك"]
[null,1,"2021-05-27","2021-06-01",{"$f":"IF(D14<=C14,0,D14-C14)","v":5},500,{"$f":"$J$7-F14","v":11500}," متاخر","مدفوع","الراجحي"]
[null,2,"2021-06-27","2021-07-01",{"$f":"IF(D15<=C15,0,D15-C15)","v":4},500,{"$f":"G14-F15","v":11000}," متاخر","مدفوع","الراجحي"]
[null,3,"2021-07-27","2021-08-01",{"$f":"IF(D16<=C16,0,D16-C16)","v":5},500,{"$f":"G15-F16","v":10500}," متاخر","مدفوع","الراجحي"]
[null,4,"2021-08-27","2021-09-01",{"$f":"IF(D17<=C17,0,D17-C17)","v":5},500,10000," متاخر","مدفوع","الراجحي"]
[null,5,"2021-09-27","2021-09-30",{"$f":"IF(D18<=C18,0,D18-C18)","v":3},500,9500," متاخر","مدفوع","الراجحي"]
[null,6,"2021-10-27","2021-11-01",{"$f":"IF(D19<=C19,0,D19-C19)","v":5},500,9000," متاخر","مدفوع","الراجحي"]
[null,7,"2021-11-27",null,0,null,9000,null,{"$f":"IF(C20<=TODAY(),\"مستحق\",\"\")","v":"مستحق"}]
[null,8,"2021-12-27",null,0,null,9000,null,"مستحق"]
[null,9,"2022-01-27",null,0,null,9000,null,""]
[null,10,"2022-02-27",null,0,null,9000,null,""]
[null,11,"2022-03-27",null,0]
[null,12,"2022-04-27",null,0]
[null,13,"2022-05-27",null,0]
[null,14,"2022-06-27",null,0]
[null,15,"2022-07-27",null,0]
[null,16,"2022-08-27",null,0]
[null,17,"2022-09-27",null,0]
[null,18,"2022-10-27",null,0]
[null,19,"2022-11-27",null,0]
[null,20,"2022-12-27",null,0]
[null,21,"2023-01-27",null,0]
[null,22,"2023-02-27",null,0,null,null,null,""]
[null,23,"2023-03-27",null,0]
[null,24,"2023-04-27",null,0,null,null,null,""]
[null,"عدد الأقساط المسددة :",{"$f":"COUNT(F14:F37)","v":6},null,null,null,null,"عدد الأقساط الغير مسددة :",null,{"$f":"COUNTIF(H14:H37,\"غير مسدد\")","v":0}]
[null,"قيمة الأقساط المسددة :",{"$f":"SUM(F14:F37)","v":3000},null,null,null,null,"قيمة الأقساط الغير مسددة :",null,{"$f":"J8*J38","v":0}]

{"sheet":"احمد ناصر","index":3,"n_rows":25,"n_cols":10,"rows_kept":25,"cut":false,"hidden":false,"merged":[[1,1,1,2],[4,1,4,9],[19,7,19,8],[20,7,20,8]]}
[]
[]
[]
[]
[null,"كشف حساب عميل"]
[]
[null,"إسم العميل :","احمد ناصر",null,null,null,null,null,"قيمة العقد",6300]
[null,"رقم العميل :",50005,null,null,null,null,null,"قيمة القسط :",1050]
[null,"رقم العقد :",5,null,null,null,null,null,"عدد الأقساط :",{"$f":"J7/J8","v":6}]
[null,"تاريخ العقد :","2019-10-21"]
[]
[]
[null,"رقم القسط","تاريخ الإستحقاق","تاريح السداد","عدد الأيام المتأخرة","المبلغ المدفوع","المبلغ المتبقي","حالة السداد","حالة القسط","البنك"]
[null,1,"2019-11-27","2019-12-01",{"$f":"IF(D14<=C14,0,D14-C14)","v":4},1050,{"$f":"$J$7-F14","v":5250}," متاخر","مدفوع","الراجحي"]
[null,2,"2019-12-27","2020-01-18",22,1050,{"$f":"G14-F15","v":4200}," متاخر","مدفوع","الراجحي"]
[null,3,"2020-01-27","2020-02-23",27,1050,{"$f":"G15-F16","v":3150}," متاخر","مدفوع","الراجحي"]
[null,4,"2020-02-27","2020-06-05",99,1050,2100," متاخر","مدفوع","الراجحي"]
[null,5,"2020-03-27","2020-10-04",191,950,1150,"غير مسدد","مدفوع جزئي","الراجحي"]
[null,6,"2020-04-27",null,0,null,1150,"غير مسدد",{"$f":"IF(C19<=TODAY(),\"مستحق\",\"\")","v":"مستحق"}]
[null,"عدد الأقساط المسددة :",{"$f":"COUNTIF(F14:F19,1050)","v":4},null,null,null,null,"عدد الأقساط الغير مسددة :",null,{"$f":"COUNTIF(H14:H19,\"غير مسدد\")","v":2}]
[null,"قيمة الأقساط المسددة :",{"$f":"SUM(F14:F19)","v":5150},null,null,null,null,"قيمة الأقساط الغير مسددة :",null,{"$f":"J8*J20","v":2100}]
[]
[]
[]
[null,null,null,null,null,{"$f":"OFFSET($C$14,SMALL(IF($B$14:$B$100=\"عدد الأقساط المسددة :\",ROW($B$14:$B$100)),ROW(A1))-14,0)","v":4}]

{"sheet":"محمد محسن","index":4,"n_rows":39,"n_cols":10,"rows_kept":39,"cut":false,"hidden":false,"merged":[[1,1,1,2],[4,1,4,9],[37,7,37,8],[38,7,38,8]]}
[]
[null,null,null,null,null,null,null,null,{"$f":"OFFSET($C$14,SMALL(IF($B$14:$B$100=\"عدد الأقساط المسددة :\",ROW($B$14:$B$100)),ROW(A1))-14,0)","v":18}]
[]
[]
[null,"كشف حساب عميل"]
[]
[null,"إسم العميل :","محمد محسن",null,null,null,null,null,"قيمة العقد",56984]
[null,"رقم العميل :",50006,null,null,null,null,null,"قيمة القسط :",2041]
[null,"رقم العقد :",6,null,null,null,null,null,"عدد الأقساط :",{"$f":"(J7-J10)/J8","v":24}]
[null,"تاريخ العقد :","2019-11-12",null,null,null,null,null,"دفعة مقدمة :",8000]
[]
[]
[null,"رقم القسط","تاريخ الإستحقاق","تاريح السداد","عدد الأيام المتأخرة","المبلغ المدفوع","المبلغ المتبقي","حالة السداد","حالة القسط","البنك"]
[null,1,"2019-12-27","2019-12-27",{"$f":"IF(D14<=C14,0,D14-C14)","v":0},2041,{"$f":"$J$7-8000-F14","v":46943},"منتظم","مدفوع","الراجحي"]
[null,2,"2020-01-27","2020-01-28",1,{"$f":"7+2034","v":2041},{"$f":"G14-F15","v":44902}," متاخر","مدفوع","الراجحي"]
[null,3,"2020-02-27","2020-03-10",12,{"$f":"14+2027","v":2041},{"$f":"G15-F16","v":42861}," متاخر","مدفوع","الراجحي"]
[null,4,"2020-03-27","2020-03-26",0,{"$f":"28+2013","v":2041},40820,"مبكر","مدفوع","الراجحي"]
[null,5,"2020-04-27","2020-04-26",0,{"$f":"35+1600+406","v":2041},38779,"مبكر","مدفوع","الراجحي"]
[null,6,"2020-05-27","2020-05-19",0,{"$f":"1642+399","v":2041},36738,"مبكر","مدفوع","الراجحي"]
[null,7,"2020-06-27","2020-07-14",17,{"$f":"1649+392","v":2041},34697," متاخر","مدفوع","الراجحي"]
[null,8,"2020-07-27","2020-09-28",63,{"$f":"1656+385","v":2041},32656," متاخر","مدفوع","الراجحي"]
[null,9,"2020-08-27","2020-11-04",69,{"$f":"1663+378","v":2041},30615," متاخر","مدفوع","الراجحي"]
[null,10,"2020-09-27","2020-12-24",88,{"$f":"1670+371","v":2041},28574," متاخر","مدفوع","الراجحي"]
[null,11,"2020-10-27","2021-02-25",121,{"$f":"1677+364","v":2041},26533," متاخر","مدفوع","الراجحي"]
[null,12,"2020-11-27","2021-04-03",127,2041,24492," متاخر","مدفوع","الراجحي"]
[null,13,"2020-12-27","2021-06-14",169,{"$f":"95+1946","v":2041},22451," متاخر","مدفوع","الراجحي"]
[null,14,"2021-01-27","2021-11-06",283,{"$f":"102+1342+597","v":2041},20410," متاخر","مدفوع","الراجحي"]
[null,15,"2021-02-27","2021-11-06",252,2041,18369," متاخر","مدفوع","الراجحي"]
[null,16,"2021-03-27","2021-11-06",224,2041,16328," متاخر","مدفوع","الراجحي"]
[null,17,"2021-04-27","2021-11-06",193,2041,14287," متاخر","مدفوع","الراجحي"]
[null,18,"2021-05-27","2021-11-06",163,2041,12246," متاخر","مدفوع","الراجحي"]
[null,19,"2021-06-27","2021-11-06",132,1939,10307,"غير مسدد","مدفوع جزئي","الراجحي"]
[null,20,"2021-07-27",null,0,null,10307,"غير مسدد",{"$f":"IF(C33<=TODAY(),\"مستحق\",\"\")","v":"مستحق"}]
[null,21,"2021-08-27",null,0,null,10307,"غير مسدد","مستحق"]
[null,22,"2021-09-27",null,0,null,10307,"غير مسدد","مستحق"]
[null,23,"2021-10-27",null,0,null,10307,"غير مسدد","مستحق"]
[null,24,"2021-11-27",null,0,null,10307,null,"مستحق"]
[null,"عدد الأقساط المسددة :",{"$f":"COUNTIF(F14:F37,2041)","v":18},null,null,null,null,"عدد الأقساط الغير مسددة :",null,{"$f":"COUNTIF(H14:H37,\"غير مسدد\")","v":5}]
[null,"قيمة الأقساط المسددة :",{"$f":"SUM(F14:F37)","v":38677},null,null,null,null,"قيمة الأقساط الغير مسددة :",null,{"$f":"J8*J38","v":10205}]

{"sheet":"Sheet2","index":5,"n_rows":4,"n_cols":2,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["مدفوع","مبكر"]
["غير مدفوع"," متاخر"]
["مدفوع جزئي","غير مسدد"]
[null,"منتظم"]