{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["العملاء"],"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":4,"n_cols":57,"rows_kept":4,"cut":false,"hidden":false,"merged":[[0,18,1,18],[1,11,1,13],[0,19,1,19],[0,14,1,14],[0,16,1,16],[0,15,1,15],[0,17,1,17]]}
["التاريخ","اسم العميل","كود العميل","عنوان العميل",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,"ميعاد القسط 01","ميعاد القسط 02","ميعاد القسط 03","ميعاد القسط 04","ميعاد القسط 05","ميعاد القسط 06","ميعاد القسط 07","ميعاد القسط 08","ميعاد القسط 09","ميعاد القسط 10","ميعاد القسط 11","ميعاد القسط 12","ميعاد القسط 13","ميعاد القسط 14","ميعاد القسط 15","ميعاد القسط 16","ميعاد القسط 17","ميعاد القسط 18","ميعاد القسط 19","ميعاد القسط 20","ميعاد القسط 21","ميعاد القسط 22","ميعاد القسط 23","ميعاد القسط 24","ميعاد القسط 25","ميعاد القسط 26","ميعاد القسط 27","ميعاد القسط 28","ميعاد القسط 29","ميعاد القسط 30","ميعاد القسط 31","ميعاد القسط 32","ميعاد القسط 33","ميعاد القسط 34","ميعاد القسط 35","ميعاد القسط 36"]
["2018-10-08","محمد محمود",1,"القاهرة",null,123456,"روزمة ورق",50,50,{"$f":"SUM(I3*H3)","v":2500},null,2700,500,{"$f":"SUM(L3-M3)","v":2200},150,{"$f":"INT(N3/O3)","v":14},{"$f":"N3-O3*P3","v":100},0,{"$f":"COUNTIF(U3:BD3,\">\"&T3)*O3-(COUNTIF(U3:BD3,\">\"&T3)-P3)*(O3-Q3)-COUNTBLANK(U3:BD3)*O3","v":2100},"2018-10-08",{"$f":"IF(COUNT($T3:T3)>ROUNDUP($Q3/$O3,0)+$P3,0,EDATE(EDATE($T3,1)+$R3,COLUMN()-22))","v":"2018-10-08"},{"$f":"IF(COUNT($T3:U3)>ROUNDUP($Q3/$O3,0)+$P3,0,EDATE(EDATE($T3,1)+$R3,COLUMN()-22))","v":"2018-11-08"},{"$f":"IF(COUNT($T3:V3)>ROUNDUP($Q3/$O3,0)+$P3,0,EDATE(EDATE($T3,1)+$R3,COLUMN()-22))","v":"2018-12-08"},{"$f":"IF(COUNT($T3:W3)>ROUNDUP($Q3/$O3,0)+$P3,0,EDATE(EDATE($T3,1)+$R3,COLUMN()-22))","v":"2019-01-08"},{"$f":"IF(COUNT($T3:X3)>ROUNDUP($Q3/$O3,0)+$P3,0,EDATE(EDATE($T3,1)+$R3,COLUMN()-22))","v":"2019-02-08"},{"$f":"IF(COUNT($T3:Y3)>ROUNDUP($Q3/$O3,0)+$P3,0,EDATE(EDATE($T3,1)+$R3,COLUMN()-22))","v":"2019-03-08"},{"$f":"IF(COUNT($T3:Z3)>ROUNDUP($Q3/$O3,0)+$P3,0,EDATE(EDATE($T3,1)+$R3,COLUMN()-22))","v":"2019-04-08"},{"$f":"IF(COUNT($T3:AA3)>ROUNDUP($Q3/$O3,0)+$P3,0,EDATE(EDATE($T3,1)+$R3,COLUMN()-22))","v":"2019-05-08"},{"$f":"IF(COUNT($T3:AB3)>ROUNDUP($Q3/$O3,0)+$P3,0,EDATE(EDATE($T3,1)+$R3,COLUMN()-22))","v":"2019-06-08"},{"$f":"IF(COUNT($T3:AC3)>ROUNDUP($Q3/$O3,0)+$P3,0,EDATE(EDATE($T3,1)+$R3,COLUMN()-22))","v":"2019-07-08"},{"$f":"IF(COUNT($T3:AD3)>ROUNDUP($Q3/$O3,0)+$P3,0,EDATE(EDATE($T3,1)+$R3,COLUMN()-22))","v":"2019-08-08"},{"$f":"IF(COUNT($T3:AE3)>ROUNDUP($Q3/$O3,0)+$P3,0,EDATE(EDATE($T3,1)+$R3,COLUMN()-22))","v":"2019-09-08"},{"$f":"IF(COUNT($T3:AF3)>ROUNDUP($Q3/$O3,0)+$P3,0,EDATE(EDATE($T3,1)+$R3,COLUMN()-22))","v":"2019-10-08"},{"$f":"IF(COUNT($T3:AG3)>ROUNDUP($Q3/$O3,0)+$P3,0,EDATE(EDATE($T3,1)+$R3,COLUMN()-22))","v":"2019-11-08"},{"$f":"IF(COUNT($T3:AH3)>ROUNDUP($Q3/$O3,0)+$P3,0,EDATE(EDATE($T3,1)+$R3,COLUMN()-22))","v":"2019-12-08"},{"$f":"IF(COUNT($T3:AI3)>ROUNDUP($Q3/$O3,0)+$P3,0,EDATE(EDATE($T3,1)+$R3,COLUMN()-22))","v":"00:00:00"},{"$f":"IF(COUNT($T3:AJ3)>ROUNDUP($Q3/$O3,0)+$P3,0,EDATE(EDATE($T3,1)+$R3,COLUMN()-22))","v":"00:00:00"},{"$f":"IF(COUNT($T3:AK3)>ROUNDUP($Q3/$O3,0)+$P3,0,EDATE(EDATE($T3,1)+$R3,COLUMN()-22))","v":"00:00:00"},{"$f":"IF(COUNT($T3:AL3)>ROUNDUP($Q3/$O3,0)+$P3,0,EDATE(EDATE($T3,1)+$R3,COLUMN()-22))","v":"00:00:00"},{"$f":"IF(COUNT($T3:AM3)>ROUNDUP($Q3/$O3,0)+$P3,0,EDATE(EDATE($T3,1)+$R3,COLUMN()-22))","v":"00:00:00"},{"$f":"IF(COUNT($T3:AN3)>ROUNDUP($Q3/$O3,0)+$P3,0,EDATE(EDATE($T3,1)+$R3,COLUMN()-22))","v":"00:00:00"},{"$f":"IF(COUNT($T3:AO3)>ROUNDUP($Q3/$O3,0)+$P3,0,EDATE(EDATE($T3,1)+$R3,COLUMN()-22))","v":"00:00:00"},{"$f":"IF(COUNT($T3:AP3)>ROUNDUP($Q3/$O3,0)+$P3,0,EDATE(EDATE($T3,1)+$R3,COLUMN()-22))","v":"00:00:00"},{"$f":"IF(COUNT($T3:AQ3)>ROUNDUP($Q3/$O3,0)+$P3,0,EDATE(EDATE($T3,1)+$R3,COLUMN()-22))","v":"00:00:00"},{"$f":"IF(COUNT($T3:AR3)>ROUNDUP($Q3/$O3,0)+$P3,0,EDATE(EDATE($T3,1)+$R3,COLUMN()-22))","v":"00:00:00"},{"$f":"IF(COUNT($T3:AS3)>ROUNDUP($Q3/$O3,0)+$P3,0,EDATE(EDATE($T3,1)+$R3,COLUMN()-22))","v":"00:00:00"},{"$f":"IF(COUNT($T3:AT3)>ROUNDUP($Q3/$O3,0)+$P3,0,EDATE(EDATE($T3,1)+$R3,COLUMN()-22))","v":"00:00:00"},{"$f":"IF(COUNT($T3:AU3)>ROUNDUP($Q3/$O3,0)+$P3,0,EDATE(EDATE($T3,1)+$R3,COLUMN()-22))","v":"00:00:00"},{"$f":"IF(COUNT($T3:AV3)>ROUNDUP($Q3/$O3,0)+$P3,0,EDATE(EDATE($T3,1)+$R3,COLUMN()-22))","v":"00:00:00"},{"$f":"IF(COUNT($T3:AW3)>ROUNDUP($Q3/$O3,0)+$P3,0,EDATE(EDATE($T3,1)+$R3,COLUMN()-22))","v":"00:00:00"},{"$f":"IF(COUNT($T3:AX3)>ROUNDUP($Q3/$O3,0)+$P3,0,EDATE(EDATE($T3,1)+$R3,COLUMN()-22))","v":"00:00:00"},{"$f":"IF(COUNT($T3:AY3)>ROUNDUP($Q3/$O3,0)+$P3,0,EDATE(EDATE($T3,1)+$R3,COLUMN()-22))","v":"00:00:00"},{"$f":"IF(COUNT($T3:AZ3)>ROUNDUP($Q3/$O3,0)+$P3,0,EDATE(EDATE($T3,1)+$R3,COLUMN()-22))","v":"00:00:00"},{"$f":"IF(COUNT($T3:BA3)>ROUNDUP($Q3/$O3,0)+$P3,0,EDATE(EDATE($T3,1)+$R3,COLUMN()-22))","v":"00:00:00"},{"$f":"IF(COUNT($T3:BB3)>ROUNDUP($Q3/$O3,0)+$P3,0,EDATE(EDATE($T3,1)+$R3,COLUMN()-22))","v":"00:00:00"},{"$f":"IF(COUNT($T3:BC3)>ROUNDUP($Q3/$O3,0)+$P3,0,EDATE(EDATE($T3,1)+$R3,COLUMN()-22))","v":"00:00:00"}]
["2018-10-09","حسن محمود",2,"الاسكندرية",null,123567,"كراسات",100,30,{"$f":"SUM(I4*H4)","v":3000},null,3200,500,{"$f":"SUM(L4-M4)","v":2700},200,{"$f":"INT(N4/O4)","v":13},{"$f":"N4-O4*P4","v":100},0,{"$f":"COUNTIF(U4:BD4,\">\"&T4)*O4-(COUNTIF(U4:BD4,\">\"&T4)-P4)*(O4-Q4)-COUNTBLANK(U4:BD4)*O4","v":2600},"2018-11-09",{"$f":"IF(COUNT($T4:T4)>ROUNDUP($Q4/$O4,0)+$P4,0,EDATE(EDATE($T4,1)+$R4,COLUMN()-22))","v":"2018-11-09"},{"$f":"IF(COUNT($T4:U4)>ROUNDUP($Q4/$O4,0)+$P4,0,EDATE(EDATE($T4,1)+$R4,COLUMN()-22))","v":"2018-12-09"},{"$f":"IF(COUNT($T4:V4)>ROUNDUP($Q4/$O4,0)+$P4,0,EDATE(EDATE($T4,1)+$R4,COLUMN()-22))","v":"2019-01-09"},{"$f":"IF(COUNT($T4:W4)>ROUNDUP($Q4/$O4,0)+$P4,0,EDATE(EDATE($T4,1)+$R4,COLUMN()-22))","v":"2019-02-09"},{"$f":"IF(COUNT($T4:X4)>ROUNDUP($Q4/$O4,0)+$P4,0,EDATE(EDATE($T4,1)+$R4,COLUMN()-22))","v":"2019-03-09"},{"$f":"IF(COUNT($T4:Y4)>ROUNDUP($Q4/$O4,0)+$P4,0,EDATE(EDATE($T4,1)+$R4,COLUMN()-22))","v":"2019-04-09"},{"$f":"IF(COUNT($T4:Z4)>ROUNDUP($Q4/$O4,0)+$P4,0,EDATE(EDATE($T4,1)+$R4,COLUMN()-22))","v":"2019-05-09"},{"$f":"IF(COUNT($T4:AA4)>ROUNDUP($Q4/$O4,0)+$P4,0,EDATE(EDATE($T4,1)+$R4,COLUMN()-22))","v":"2019-06-09"},{"$f":"IF(COUNT($T4:AB4)>ROUNDUP($Q4/$O4,0)+$P4,0,EDATE(EDATE($T4,1)+$R4,COLUMN()-22))","v":"2019-07-09"},{"$f":"IF(COUNT($T4:AC4)>ROUNDUP($Q4/$O4,0)+$P4,0,EDATE(EDATE($T4,1)+$R4,COLUMN()-22))","v":"2019-08-09"},{"$f":"IF(COUNT($T4:AD4)>ROUNDUP($Q4/$O4,0)+$P4,0,EDATE(EDATE($T4,1)+$R4,COLUMN()-22))","v":"2019-09-09"},{"$f":"IF(COUNT($T4:AE4)>ROUNDUP($Q4/$O4,0)+$P4,0,EDATE(EDATE($T4,1)+$R4,COLUMN()-22))","v":"2019-10-09"},{"$f":"IF(COUNT($T4:AF4)>ROUNDUP($Q4/$O4,0)+$P4,0,EDATE(EDATE($T4,1)+$R4,COLUMN()-22))","v":"2019-11-09"},{"$f":"IF(COUNT($T4:AG4)>ROUNDUP($Q4/$O4,0)+$P4,0,EDATE(EDATE($T4,1)+$R4,COLUMN()-22))","v":"2019-12-09"},{"$f":"IF(COUNT($T4:AH4)>ROUNDUP($Q4/$O4,0)+$P4,0,EDATE(EDATE($T4,1)+$R4,COLUMN()-22))","v":"00:00:00"},{"$f":"IF(COUNT($T4:AI4)>ROUNDUP($Q4/$O4,0)+$P4,0,EDATE(EDATE($T4,1)+$R4,COLUMN()-22))","v":"00:00:00"},{"$f":"IF(COUNT($T4:AJ4)>ROUNDUP($Q4/$O4,0)+$P4,0,EDATE(EDATE($T4,1)+$R4,COLUMN()-22))","v":"00:00:00"},{"$f":"IF(COUNT($T4:AK4)>ROUNDUP($Q4/$O4,0)+$P4,0,EDATE(EDATE($T4,1)+$R4,COLUMN()-22))","v":"00:00:00"},{"$f":"IF(COUNT($T4:AL4)>ROUNDUP($Q4/$O4,0)+$P4,0,EDATE(EDATE($T4,1)+$R4,COLUMN()-22))","v":"00:00:00"},{"$f":"IF(COUNT($T4:AM4)>ROUNDUP($Q4/$O4,0)+$P4,0,EDATE(EDATE($T4,1)+$R4,COLUMN()-22))","v":"00:00:00"},{"$f":"IF(COUNT($T4:AN4)>ROUNDUP($Q4/$O4,0)+$P4,0,EDATE(EDATE($T4,1)+$R4,COLUMN()-22))","v":"00:00:00"},{"$f":"IF(COUNT($T4:AO4)>ROUNDUP($Q4/$O4,0)+$P4,0,EDATE(EDATE($T4,1)+$R4,COLUMN()-22))","v":"00:00:00"},{"$f":"IF(COUNT($T4:AP4)>ROUNDUP($Q4/$O4,0)+$P4,0,EDATE(EDATE($T4,1)+$R4,COLUMN()-22))","v":"00:00:00"},{"$f":"IF(COUNT($T4:AQ4)>ROUNDUP($Q4/$O4,0)+$P4,0,EDATE(EDATE($T4,1)+$R4,COLUMN()-22))","v":"00:00:00"},{"$f":"IF(COUNT($T4:AR4)>ROUNDUP($Q4/$O4,0)+$P4,0,EDATE(EDATE($T4,1)+$R4,COLUMN()-22))","v":"00:00:00"},{"$f":"IF(COUNT($T4:AS4)>ROUNDUP($Q4/$O4,0)+$P4,0,EDATE(EDATE($T4,1)+$R4,COLUMN()-22))","v":"00:00:00"},{"$f":"IF(COUNT($T4:AT4)>ROUNDUP($Q4/$O4,0)+$P4,0,EDATE(EDATE($T4,1)+$R4,COLUMN()-22))","v":"00:00:00"},{"$f":"IF(COUNT($T4:AU4)>ROUNDUP($Q4/$O4,0)+$P4,0,EDATE(EDATE($T4,1)+$R4,COLUMN()-22))","v":"00:00:00"},{"$f":"IF(COUNT($T4:AV4)>ROUNDUP($Q4/$O4,0)+$P4,0,EDATE(EDATE($T4,1)+$R4,COLUMN()-22))","v":"00:00:00"},{"$f":"IF(COUNT($T4:AW4)>ROUNDUP($Q4/$O4,0)+$P4,0,EDATE(EDATE($T4,1)+$R4,COLUMN()-22))","v":"00:00:00"},{"$f":"IF(COUNT($T4:AX4)>ROUNDUP($Q4/$O4,0)+$P4,0,EDATE(EDATE($T4,1)+$R4,COLUMN()-22))","v":"00:00:00"},{"$f":"IF(COUNT($T4:AY4)>ROUNDUP($Q4/$O4,0)+$P4,0,EDATE(EDATE($T4,1)+$R4,COLUMN()-22))","v":"00:00:00"},{"$f":"IF(COUNT($T4:AZ4)>ROUNDUP($Q4/$O4,0)+$P4,0,EDATE(EDATE($T4,1)+$R4,COLUMN()-22))","v":"00:00:00"},{"$f":"IF(COUNT($T4:BA4)>ROUNDUP($Q4/$O4,0)+$P4,0,EDATE(EDATE($T4,1)+$R4,COLUMN()-22))","v":"00:00:00"},{"$f":"IF(COUNT($T4:BB4)>ROUNDUP($Q4/$O4,0)+$P4,0,EDATE(EDATE($T4,1)+$R4,COLUMN()-22))","v":"00:00:00"},{"$f":"IF(COUNT($T4:BC4)>ROUNDUP($Q4/$O4,0)+$P4,0,EDATE(EDATE($T4,1)+$R4,COLUMN()-22))","v":"00:00:00"}]