{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Data","تنبية بالاقساط","بحث عن التنبيه","شاشة التنبيه","1-1-2019","Sheet4"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":2,"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":"Data","index":0,"n_rows":11,"n_cols":29,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["كود العميل","اسم العميل","رقم التليفون","قيمه القسط","عدد الاقساط","القسط ال 1","الحالة 1","القسط ال2","الحالة 2","القسط ال 3","الحالة 3","القسط ال 4","الحالة 4","القسط ال 5","الحالة 5","القسط ال 6","الحالة 6","القسط ال 7","الحالة 7","القسط ال 8","الحالة 8","القسط ال 9","الحالة 9","القسط ال 10","الحالة 10","القسط ال 11","الحاله 11","القسط ال 12","الحاله ال 12"]
[1,"احمد عثمان حسن ",1142900862,200,10,"2019-02-03",{"$f":"IF('1-1-2019'!U2<>\"\",TODAY(),\"\")","v":"2020-04-03"},{"$f":"IF(F2=\"\",\"\",IF(COUNT($F2:F2),EDATE(EDATE(F2,1),0)))","v":"2019-03-03"},{"$f":"IF('1-1-2019'!V2<>\"\",TODAY(),\"\")","v":"2020-04-03"},{"$f":"IF(H2=\"\",\"\",IF(COUNT($F2:H2),EDATE(EDATE(H2,1),0)))","v":"2019-04-03"},{"$f":"IF('1-1-2019'!W2<>\"\",TODAY(),\"\")","v":"2020-04-03"},{"$f":"IF(J2=\"\",\"\",IF(COUNT($F2:J2),EDATE(EDATE(J2,1),0)))","v":"2019-05-03"},{"$f":"IF('1-1-2019'!X2<>\"\",TODAY(),\"\")","v":"2020-04-03"},{"$f":"IF(L2=\"\",\"\",IF(COUNT($F2:L2),EDATE(EDATE(L2,1),0)))","v":"2019-06-03"},{"$f":"IF('1-1-2019'!Y2<>\"\",TODAY(),\"\")","v":"2020-04-03"},{"$f":"IF(N2=\"\",\"\",IF(COUNT($F2:N2),EDATE(EDATE(N2,1),0)))","v":"2019-07-03"},{"$f":"IF('1-1-2019'!Z2<>\"\",TODAY(),\"\")","v":"2020-04-03"},{"$f":"IF(P2=\"\",\"\",IF(COUNT($F2:P2),EDATE(EDATE(P2,1),0)))","v":"2019-08-03"},{"$f":"IF('1-1-2019'!AA2<>\"\",TODAY(),\"\")","v":"2020-04-03"},{"$f":"IF(R2=\"\",\"\",IF(COUNT($F2:R2),EDATE(EDATE(R2,1),0)))","v":"2019-09-03"},{"$f":"IF('1-1-2019'!AB2<>\"\",TODAY(),\"\")","v":"2020-04-03"},{"$f":"IF(T2=\"\",\"\",IF(COUNT($F2:T2),EDATE(EDATE(T2,1),0)))","v":"2019-10-03"},{"$f":"IF('1-1-2019'!AC2<>\"\",TODAY(),\"\")","v":""},{"$f":"IF(V2=\"\",\"\",IF(COUNT($F2:V2),EDATE(EDATE(V2,1),0)))","v":"2019-11-03"},{"$f":"IF('1-1-2019'!AD2<>\"\",TODAY(),\"\")","v":""},{"$f":"IF(X2=\"\",\"\",IF(COUNT($F2:X2),EDATE(EDATE(X2,1),0)))","v":"2019-12-03"},{"$f":"IF('1-1-2019'!AE2<>\"\",TODAY(),\"\")","v":""},{"$f":"IF(Z2=\"\",\"\",IF(COUNT($F2:Z2),EDATE(EDATE(Z2,1),0)))","v":"2020-01-03"},{"$f":"IF('1-1-2019'!AF2<>\"\",TODAY(),\"\")","v":""}]
[2,"احمد عثمان حسن 2",1002130296,200,10,"2019-09-16",{"$f":"IF('1-1-2019'!U3<>\"\",TODAY(),\"\")","v":"2020-04-03"},{"$f":"IF(F3=\"\",\"\",IF(COUNT($F3:F3),EDATE(EDATE(F3,1),0)))","v":"2019-10-16"},{"$f":"IF('1-1-2019'!V3<>\"\",TODAY(),\"\")","v":""},{"$f":"IF(H3=\"\",\"\",IF(COUNT($F3:H3),EDATE(EDATE(H3,1),0)))","v":"2019-11-16"},{"$f":"IF('1-1-2019'!W3<>\"\",TODAY(),\"\")","v":""},{"$f":"IF(J3=\"\",\"\",IF(COUNT($F3:J3),EDATE(EDATE(J3,1),0)))","v":"2019-12-16"},{"$f":"IF('1-1-2019'!X3<>\"\",TODAY(),\"\")","v":""},{"$f":"IF(L3=\"\",\"\",IF(COUNT($F3:L3),EDATE(EDATE(L3,1),0)))","v":"2020-01-16"},{"$f":"IF('1-1-2019'!Y3<>\"\",TODAY(),\"\")","v":""},{"$f":"IF(N3=\"\",\"\",IF(COUNT($F3:N3),EDATE(EDATE(N3,1),0)))","v":"2020-02-16"},{"$f":"IF('1-1-2019'!Z3<>\"\",TODAY(),\"\")","v":""},{"$f":"IF(P3=\"\",\"\",IF(COUNT($F3:P3),EDATE(EDATE(P3,1),0)))","v":"2020-03-16"},{"$f":"IF('1-1-2019'!AA3<>\"\",TODAY(),\"\")","v":""},{"$f":"IF(R3=\"\",\"\",IF(COUNT($F3:R3),EDATE(EDATE(R3,1),0)))","v":"2020-04-16"},{"$f":"IF('1-1-2019'!AB3<>\"\",TODAY(),\"\")","v":""},{"$f":"IF(T3=\"\",\"\",IF(COUNT($F3:T3),EDATE(EDATE(T3,1),0)))","v":"2020-05-16"},{"$f":"IF('1-1-2019'!AC3<>\"\",TODAY(),\"\")","v":""},{"$f":"IF(V3=\"\",\"\",IF(COUNT($F3:V3),EDATE(EDATE(V3,1),0)))","v":"2020-06-16"},{"$f":"IF('1-1-2019'!AD3<>\"\",TODAY(),\"\")","v":""},{"$f":"IF(X3=\"\",\"\",IF(COUNT($F3:X3),EDATE(EDATE(X3,1),0)))","v":"2020-07-16"},{"$f":"IF('1-1-2019'!AE3<>\"\",TODAY(),\"\")","v":""},{"$f":"IF(Z3=\"\",\"\",IF(COUNT($F3:Z3),EDATE(EDATE(Z3,1),0)))","v":"2020-08-16"},{"$f":"IF('1-1-2019'!AF3<>\"\",TODAY(),\"\")","v":""}]
[3,"محمود فتحي حسن علي ",1062556099,200,10,"2019-02-04",{"$f":"IF('1-1-2019'!U4<>\"\",TODAY(),\"\")","v":"2020-04-03"},{"$f":"IF(F4=\"\",\"\",IF(COUNT($F4:F4),EDATE(EDATE(F4,1),0)))","v":"2019-03-04"},{"$f":"IF('1-1-2019'!V4<>\"\",TODAY(),\"\")","v":"2020-04-03"},{"$f":"IF(H4=\"\",\"\",IF(COUNT($F4:H4),EDATE(EDATE(H4,1),0)))","v":"2019-04-04"},{"$f":"IF('1-1-2019'!W4<>\"\",TODAY(),\"\")","v":"2020-04-03"},{"$f":"IF(J4=\"\",\"\",IF(COUNT($F4:J4),EDATE(EDATE(J4,1),0)))","v":"2019-05-04"},{"$f":"IF('1-1-2019'!X4<>\"\",TODAY(),\"\")","v":"2020-04-03"},{"$f":"IF(L4=\"\",\"\",IF(COUNT($F4:L4),EDATE(EDATE(L4,1),0)))","v":"2019-06-04"},{"$f":"IF('1-1-2019'!Y4<>\"\",TODAY(),\"\")","v":"2020-04-03"},{"$f":"IF(N4=\"\",\"\",IF(COUNT($F4:N4),EDATE(EDATE(N4,1),0)))","v":"2019-07-04"},{"$f":"IF('1-1-2019'!Z4<>\"\",TODAY(),\"\")","v":"2020-04-03"},{"$f":"IF(P4=\"\",\"\",IF(COUNT($F4:P4),EDATE(EDATE(P4,1),0)))","v":"2019-08-04"},{"$f":"IF('1-1-2019'!AA4<>\"\",TODAY(),\"\")","v":"2020-04-03"},{"$f":"IF(R4=\"\",\"\",IF(COUNT($F4:R4),EDATE(EDATE(R4,1),0)))","v":"2019-09-04"},{"$f":"IF('1-1-2019'!AB4<>\"\",TODAY(),\"\")","v":""},{"$f":"IF(T4=\"\",\"\",IF(COUNT($F4:T4),EDATE(EDATE(T4,1),0)))","v":"2019-10-04"},{"$f":"IF('1-1-2019'!AC4<>\"\",TODAY(),\"\")","v":""},{"$f":"IF(V4=\"\",\"\",IF(COUNT($F4:V4),EDATE(EDATE(V4,1),0)))","v":"2019-11-04"},{"$f":"IF('1-1-2019'!AD4<>\"\",TODAY(),\"\")","v":""},{"$f":"IF(X4=\"\",\"\",IF(COUNT($F4:X4),EDATE(EDATE(X4,1),0)))","v":"2019-12-04"},{"$f":"IF('1-1-2019'!AE4<>\"\",TODAY(),\"\")","v":""},{"$f":"IF(Z4=\"\",\"\",IF(COUNT($F4:Z4),EDATE(EDATE(Z4,1),0)))","v":"2020-01-04"},{"$f":"IF('1-1-2019'!AF4<>\"\",TODAY(),\"\")","v":""}]
[4,"محمود فتحي حسن علي 2",1062556099,200,10,"2019-06-04",{"$f":"IF('1-1-2019'!U5<>\"\",TODAY(),\"\")","v":"2020-04-03"},{"$f":"IF(F5=\"\",\"\",IF(COUNT($F5:F5),EDATE(EDATE(F5,1),0)))","v":"2019-07-04"},{"$f":"IF('1-1-2019'!V5<>\"\",TODAY(),\"\")","v":"2020-04-03"},{"$f":"IF(H5=\"\",\"\",IF(COUNT($F5:H5),EDATE(EDATE(H5,1),0)))","v":"2019-08-04"},{"$f":"IF('1-1-2019'!W5<>\"\",TODAY(),\"\")","v":"2020-04-03"},{"$f":"IF(J5=\"\",\"\",IF(COUNT($F5:J5),EDATE(EDATE(J5,1),0)))","v":"2019-09-04"},{"$f":"IF('1-1-2019'!X5<>\"\",TODAY(),\"\")","v":"2020-04-03"},{"$f":"IF(L5=\"\",\"\",IF(COUNT($F5:L5),EDATE(EDATE(L5,1),0)))","v":"2019-10-04"},{"$f":"IF('1-1-2019'!Y5<>\"\",TODAY(),\"\")","v":""},{"$f":"IF(N5=\"\",\"\",IF(COUNT($F5:N5),EDATE(EDATE(N5,1),0)))","v":"2019-11-04"},{"$f":"IF('1-1-2019'!Z5<>\"\",TODAY(),\"\")","v":""},{"$f":"IF(P5=\"\",\"\",IF(COUNT($F5:P5),EDATE(EDATE(P5,1),0)))","v":"2019-12-04"},{"$f":"IF('1-1-2019'!AA5<>\"\",TODAY(),\"\")","v":""},{"$f":"IF(R5=\"\",\"\",IF(COUNT($F5:R5),EDATE(EDATE(R5,1),0)))","v":"2020-01-04"},{"$f":"IF('1-1-2019'!AB5<>\"\",TODAY(),\"\")","v":""},{"$f":"IF(T5=\"\",\"\",IF(COUNT($F5:T5),EDATE(EDATE(T5,1),0)))","v":"2020-02-04"},{"$f":"IF('1-1-2019'!AC5<>\"\",TODAY(),\"\")","v":""},{"$f":"IF(V5=\"\",\"\",IF(COUNT($F5:V5),EDATE(EDATE(V5,1),0)))","v":"2020-03-04"},{"$f":"IF('1-1-2019'!AD5<>\"\",TODAY(),\"\")","v":""},{"$f":"IF(X5=\"\",\"\",IF(COUNT($F5:X5),EDATE(EDATE(X5,1),0)))","v":"2020-04-04"},{"$f":"IF('1-1-2019'!AE5<>\"\",TODAY(),\"\")","v":""},{"$f":"IF(Z5=\"\",\"\",IF(COUNT($F5:Z5),EDATE(EDATE(Z5,1),0)))","v":"2020-05-04"},{"$f":"IF('1-1-2019'!AF5<>\"\",TODAY(),\"\")","v":""}]
[5,"محمود فتحي حسن علي 3",null,200,10,"2019-10-05",{"$f":"IF('1-1-2019'!U6<>\"\",TODAY(),\"\")","v":"2020-04-03"},{"$f":"IF(F6=\"\",\"\",IF(COUNT($F6:F6),EDATE(EDATE(F6,1),0)))","v":"2019-11-05"},{"$f":"IF('1-1-2019'!V6<>\"\",TODAY(),\"\")","v":"2020-04-03"},{"$f":"IF(H6=\"\",\"\",IF(COUNT($F6:H6),EDATE(EDATE(H6,1),0)))","v":"2019-12-05"},{"$f":"IF('1-1-2019'!W6<>\"\",TODAY(),\"\")","v":""},{"$f":"IF(J6=\"\",\"\",IF(COUNT($F6:J6),EDATE(EDATE(J6,1),0)))","v":"2020-01-05"},{"$f":"IF('1-1-2019'!X6<>\"\",TODAY(),\"\")","v":""},{"$f":"IF(L6=\"\",\"\",IF(COUNT($F6:L6),EDATE(EDATE(L6,1),0)))","v":"2020-02-05"},{"$f":"IF('1-1-2019'!Y6<>\"\",TODAY(),\"\")","v":""},{"$f":"IF(N6=\"\",\"\",IF(COUNT($F6:N6),EDATE(EDATE(N6,1),0)))","v":"2020-03-05"},{"$f":"IF('1-1-2019'!Z6<>\"\",TODAY(),\"\")","v":""},{"$f":"IF(P6=\"\",\"\",IF(COUNT($F6:P6),EDATE(EDATE(P6,1),0)))","v":"2020-04-05"},{"$f":"IF('1-1-2019'!AA6<>\"\",TODAY(),\"\")","v":""},{"$f":"IF(R6=\"\",\"\",IF(COUNT($F6:R6),EDATE(EDATE(R6,1),0)))","v":"2020-05-05"},{"$f":"IF('1-1-2019'!AB6<>\"\",TODAY(),\"\")","v":""},{"$f":"IF(T6=\"\",\"\",IF(COUNT($F6:T6),EDATE(EDATE(T6,1),0)))","v":"2020-06-05"},{"$f":"IF('1-1-2019'!AC6<>\"\",TODAY(),\"\")","v":""},{"$f":"IF(V6=\"\",\"\",IF(COUNT($F6:V6),EDATE(EDATE(V6,1),0)))","v":"2020-07-05"},{"$f":"IF('1-1-2019'!AD6<>\"\",TODAY(),\"\")","v":""},{"$f":"IF(X6=\"\",\"\",IF(COUNT($F6:X6),EDATE(EDATE(X6,1),0)))","v":"2020-08-05"},{"$f":"IF('1-1-2019'!AE6<>\"\",TODAY(),\"\")","v":""},{"$f":"IF(Z6=\"\",\"\",IF(COUNT($F6:Z6),EDATE(EDATE(Z6,1),0)))","v":"2020-09-05"},{"$f":"IF('1-1-2019'!AF6<>\"\",TODAY(),\"\")","v":""}]
[6,"ربيع سيد مستعمل  ",null,200,10,"2019-09-16",{"$f":"IF('1-1-2019'!U7<>\"\",TODAY(),\"\")","v":"2020-04-03"},{"$f":"IF(F7=\"\",\"\",IF(COUNT($F7:F7),EDATE(EDATE(F7,1),0)))","v":"2019-10-16"},{"$f":"IF('1-1-2019'!V7<>\"\",TODAY(),\"\")","v":"2020-04-03"},{"$f":"IF(H7=\"\",\"\",IF(COUNT($F7:H7),EDATE(EDATE(H7,1),0)))","v":"2019-11-16"},{"$f":"IF('1-1-2019'!W7<>\"\",TODAY(),\"\")","v":"2020-04-03"},{"$f":"IF(J7=\"\",\"\",IF(COUNT($F7:J7),EDATE(EDATE(J7,1),0)))","v":"2019-12-16"},{"$f":"IF('1-1-2019'!X7<>\"\",TODAY(),\"\")","v":"2020-04-03"},{"$f":"IF(L7=\"\",\"\",IF(COUNT($F7:L7),EDATE(EDATE(L7,1),0)))","v":"2020-01-16"},{"$f":"IF('1-1-2019'!Y7<>\"\",TODAY(),\"\")","v":"2020-04-03"},{"$f":"IF(N7=\"\",\"\",IF(COUNT($F7:N7),EDATE(EDATE(N7,1),0)))","v":"2020-02-16"},{"$f":"IF('1-1-2019'!Z7<>\"\",TODAY(),\"\")","v":""},{"$f":"IF(P7=\"\",\"\",IF(COUNT($F7:P7),EDATE(EDATE(P7,1),0)))","v":"2020-03-16"},{"$f":"IF('1-1-2019'!AA7<>\"\",TODAY(),\"\")","v":""},{"$f":"IF(R7=\"\",\"\",IF(COUNT($F7:R7),EDATE(EDATE(R7,1),0)))","v":"2020-04-16"},{"$f":"IF('1-1-2019'!AB7<>\"\",TODAY(),\"\")","v":""},{"$f":"IF(T7=\"\",\"\",IF(COUNT($F7:T7),EDATE(EDATE(T7,1),0)))","v":"2020-05-16"},{"$f":"IF('1-1-2019'!AC7<>\"\",TODAY(),\"\")","v":""},{"$f":"IF(V7=\"\",\"\",IF(COUNT($F7:V7),EDATE(EDATE(V7,1),0)))","v":"2020-06-16"},{"$f":"IF('1-1-2019'!AD7<>\"\",TODAY(),\"\")","v":""},{"$f":"IF(X7=\"\",\"\",IF(COUNT($F7:X7),EDATE(EDATE(X7,1),0)))","v":"2020-07-16"},{"$f":"IF('1-1-2019'!AE7<>\"\",TODAY(),\"\")","v":""},{"$f":"IF(Z7=\"\",\"\",IF(COUNT($F7:Z7),EDATE(EDATE(Z7,1),0)))","v":"2020-08-16"},{"$f":"IF('1-1-2019'!AF7<>\"\",TODAY(),\"\")","v":""}]
[7,"ربيع سيد  / صبري",null,200,10,"2019-09-19",{"$f":"IF('1-1-2019'!U8<>\"\",TODAY(),\"\")","v":"2020-04-03"},{"$f":"IF(F8=\"\",\"\",IF(COUNT($F8:F8),EDATE(EDATE(F8,1),0)))","v":"2019-10-19"},{"$f":"IF('1-1-2019'!V8<>\"\",TODAY(),\"\")","v":"2020-04-03"},{"$f":"IF(H8=\"\",\"\",IF(COUNT($F8:H8),EDATE(EDATE(H8,1),0)))","v":"2019-11-19"},{"$f":"IF('1-1-2019'!W8<>\"\",TODAY(),\"\")","v":"2020-04-03"},{"$f":"IF(J8=\"\",\"\",IF(COUNT($F8:J8),EDATE(EDATE(J8,1),0)))","v":"2019-12-19"},{"$f":"IF('1-1-2019'!X8<>\"\",TODAY(),\"\")","v":"2020-04-03"},{"$f":"IF(L8=\"\",\"\",IF(COUNT($F8:L8),EDATE(EDATE(L8,1),0)))","v":"2020-01-19"},{"$f":"IF('1-1-2019'!Y8<>\"\",TODAY(),\"\")","v":""},{"$f":"IF(N8=\"\",\"\",IF(COUNT($F8:N8),EDATE(EDATE(N8,1),0)))","v":"2020-02-19"},{"$f":"IF('1-1-2019'!Z8<>\"\",TODAY(),\"\")","v":""},{"$f":"IF(P8=\"\",\"\",IF(COUNT($F8:P8),EDATE(EDATE(P8,1),0)))","v":"2020-03-19"},{"$f":"IF('1-1-2019'!AA8<>\"\",TODAY(),\"\")","v":""},{"$f":"IF(R8=\"\",\"\",IF(COUNT($F8:R8),EDATE(EDATE(R8,1),0)))","v":"2020-04-19"},{"$f":"IF('1-1-2019'!AB8<>\"\",TODAY(),\"\")","v":""},{"$f":"IF(T8=\"\",\"\",IF(COUNT($F8:T8),EDATE(EDATE(T8,1),0)))","v":"2020-05-19"},{"$f":"IF('1-1-2019'!AC8<>\"\",TODAY(),\"\")","v":""},{"$f":"IF(V8=\"\",\"\",IF(COUNT($F8:V8),EDATE(EDATE(V8,1),0)))","v":"2020-06-19"},{"$f":"IF('1-1-2019'!AD8<>\"\",TODAY(),\"\")","v":""},{"$f":"IF(X8=\"\",\"\",IF(COUNT($F8:X8),EDATE(EDATE(X8,1),0)))","v":"2020-07-19"},{"$f":"IF('1-1-2019'!AE8<>\"\",TODAY(),\"\")","v":""},{"$f":"IF(Z8=\"\",\"\",IF(COUNT($F8:Z8),EDATE(EDATE(Z8,1),0)))","v":"2020-08-19"},{"$f":"IF('1-1-2019'!AF8<>\"\",TODAY(),\"\")","v":""}]
[8,"محمد عبد الحميد عبد النظور / عز عبد الحميد ",1066971345,200,10,"2019-02-05",{"$f":"IF('1-1-2019'!U9<>\"\",TODAY(),\"\")","v":"2020-04-03"},{"$f":"IF(F9=\"\",\"\",IF(COUNT($F9:F9),EDATE(EDATE(F9,1),0)))","v":"2019-03-05"},{"$f":"IF('1-1-2019'!V9<>\"\",TODAY(),\"\")","v":"2020-04-03"},{"$f":"IF(H9=\"\",\"\",IF(COUNT($F9:H9),EDATE(EDATE(H9,1),0)))","v":"2019-04-05"},{"$f":"IF('1-1-2019'!W9<>\"\",TODAY(),\"\")","v":"2020-04-03"},{"$f":"IF(J9=\"\",\"\",IF(COUNT($F9:J9),EDATE(EDATE(J9,1),0)))","v":"2019-05-05"},{"$f":"IF('1-1-2019'!X9<>\"\",TODAY(),\"\")","v":"2020-04-03"},{"$f":"IF(L9=\"\",\"\",IF(COUNT($F9:L9),EDATE(EDATE(L9,1),0)))","v":"2019-06-05"},{"$f":"IF('1-1-2019'!Y9<>\"\",TODAY(),\"\")","v":"2020-04-03"},{"$f":"IF(N9=\"\",\"\",IF(COUNT($F9:N9),EDATE(EDATE(N9,1),0)))","v":"2019-07-05"},{"$f":"IF('1-1-2019'!Z9<>\"\",TODAY(),\"\")","v":"2020-04-03"},{"$f":"IF(P9=\"\",\"\",IF(COUNT($F9:P9),EDATE(EDATE(P9,1),0)))","v":"2019-08-05"},{"$f":"IF('1-1-2019'!AA9<>\"\",TODAY(),\"\")","v":"2020-04-03"},{"$f":"IF(R9=\"\",\"\",IF(COUNT($F9:R9),EDATE(EDATE(R9,1),0)))","v":"2019-09-05"},{"$f":"IF('1-1-2019'!AB9<>\"\",TODAY(),\"\")","v":"2020-04-03"},{"$f":"IF(T9=\"\",\"\",IF(COUNT($F9:T9),EDATE(EDATE(T9,1),0)))","v":"2019-10-05"},{"$f":"IF('1-1-2019'!AC9<>\"\",TODAY(),\"\")","v":"2020-04-03"},{"$f":"IF(V9=\"\",\"\",IF(COUNT($F9:V9),EDATE(EDATE(V9,1),0)))","v":"2019-11-05"},{"$f":"IF('1-1-2019'!AD9<>\"\",TODAY(),\"\")","v":""},{"$f":"IF(X9=\"\",\"\",IF(COUNT($F9:X9),EDATE(EDATE(X9,1),0)))","v":"2019-12-05"},{"$f":"IF('1-1-2019'!AE9<>\"\",TODAY(),\"\")","v":""},{"$f":"IF(Z9=\"\",\"\",IF(COUNT($F9:Z9),EDATE(EDATE(Z9,1),0)))","v":"2020-01-05"},{"$f":"IF('1-1-2019'!AF9<>\"\",TODAY(),\"\")","v":""}]
[9,"فاطمه عبد المعز ",null,200,10,"2019-02-05",{"$f":"IF('1-1-2019'!U10<>\"\",TODAY(),\"\")","v":"2020-04-03"},{"$f":"IF(F10=\"\",\"\",IF(COUNT($F10:F10),EDATE(EDATE(F10,1),0)))","v":"2019-03-05"},{"$f":"IF('1-1-2019'!V10<>\"\",TODAY(),\"\")","v":"2020-04-03"},{"$f":"IF(H10=\"\",\"\",IF(COUNT($F10:H10),EDATE(EDATE(H10,1),0)))","v":"2019-04-05"},{"$f":"IF('1-1-2019'!W10<>\"\",TODAY(),\"\")","v":"2020-04-03"},{"$f":"IF(J10=\"\",\"\",IF(COUNT($F10:J10),EDATE(EDATE(J10,1),0)))","v":"2019-05-05"},{"$f":"IF('1-1-2019'!X10<>\"\",TODAY(),\"\")","v":""},{"$f":"IF(L10=\"\",\"\",IF(COUNT($F10:L10),EDATE(EDATE(L10,1),0)))","v":"2019-06-05"},{"$f":"IF('1-1-2019'!Y10<>\"\",TODAY(),\"\")","v":""},{"$f":"IF(N10=\"\",\"\",IF(COUNT($F10:N10),EDATE(EDATE(N10,1),0)))","v":"2019-07-05"},{"$f":"IF('1-1-2019'!Z10<>\"\",TODAY(),\"\")","v":""},{"$f":"IF(P10=\"\",\"\",IF(COUNT($F10:P10),EDATE(EDATE(P10,1),0)))","v":"2019-08-05"},{"$f":"IF('1-1-2019'!AA10<>\"\",TODAY(),\"\")","v":""},{"$f":"IF(R10=\"\",\"\",IF(COUNT($F10:R10),EDATE(EDATE(R10,1),0)))","v":"2019-09-05"},{"$f":"IF('1-1-2019'!AB10<>\"\",TODAY(),\"\")","v":""},{"$f":"IF(T10=\"\",\"\",IF(COUNT($F10:T10),EDATE(EDATE(T10,1),0)))","v":"2019-10-05"},{"$f":"IF('1-1-2019'!AC10<>\"\",TODAY(),\"\")","v":""},{"$f":"IF(V10=\"\",\"\",IF(COUNT($F10:V10),EDATE(EDATE(V10,1),0)))","v":"2019-11-05"},{"$f":"IF('1-1-2019'!AD10<>\"\",TODAY(),\"\")","v":""},{"$f":"IF(X10=\"\",\"\",IF(COUNT($F10:X10),EDATE(EDATE(X10,1),0)))","v":"2019-12-05"},{"$f":"IF('1-1-2019'!AE10<>\"\",TODAY(),\"\")","v":""},{"$f":"IF(Z10=\"\",\"\",IF(COUNT($F10:Z10),EDATE(EDATE(Z10,1),0)))","v":"2020-01-05"},{"$f":"IF('1-1-2019'!AF10<>\"\",TODAY(),\"\")","v":""}]
[10,"مروان سعد تبع عبيد ","تبع عبيد",200,10,"2019-02-05",{"$f":"IF('1-1-2019'!U11<>\"\",TODAY(),\"\")","v":"2020-04-03"},{"$f":"IF(F11=\"\",\"\",IF(COUNT($F11:F11),EDATE(EDATE(F11,1),0)))","v":"2019-03-05"},{"$f":"IF('1-1-2019'!V11<>\"\",TODAY(),\"\")","v":"2020-04-03"},{"$f":"IF(H11=\"\",\"\",IF(COUNT($F11:H11),EDATE(EDATE(H11,1),0)))","v":"2019-04-05"},{"$f":"IF('1-1-2019'!W11<>\"\",TODAY(),\"\")","v":"2020-04-03"},{"$f":"IF(J11=\"\",\"\",IF(COUNT($F11:J11),EDATE(EDATE(J11,1),0)))","v":"2019-05-05"},{"$f":"IF('1-1-2019'!X11<>\"\",TODAY(),\"\")","v":"2020-04-03"},{"$f":"IF(L11=\"\",\"\",IF(COUNT($F11:L11),EDATE(EDATE(L11,1),0)))","v":"2019-06-05"},{"$f":"IF('1-1-2019'!Y11<>\"\",TODAY(),\"\")","v":"2020-04-03"},{"$f":"IF(N11=\"\",\"\",IF(COUNT($F11:N11),EDATE(EDATE(N11,1),0)))","v":"2019-07-05"},{"$f":"IF('1-1-2019'!Z11<>\"\",TODAY(),\"\")","v":"2020-04-03"},{"$f":"IF(P11=\"\",\"\",IF(COUNT($F11:P11),EDATE(EDATE(P11,1),0)))","v":"2019-08-05"},{"$f":"IF('1-1-2019'!AA11<>\"\",TODAY(),\"\")","v":""},{"$f":"IF(R11=\"\",\"\",IF(COUNT($F11:R11),EDATE(EDATE(R11,1),0)))","v":"2019-09-05"},{"$f":"IF('1-1-2019'!AB11<>\"\",TODAY(),\"\")","v":""},{"$f":"IF(T11=\"\",\"\",IF(COUNT($F11:T11),EDATE(EDATE(T11,1),0)))","v":"2019-10-05"},{"$f":"IF('1-1-2019'!AC11<>\"\",TODAY(),\"\")","v":""},{"$f":"IF(V11=\"\",\"\",IF(COUNT($F11:V11),EDATE(EDATE(V11,1),0)))","v":"2019-11-05"},{"$f":"IF('1-1-2019'!AD11<>\"\",TODAY(),\"\")","v":""},{"$f":"IF(X11=\"\",\"\",IF(COUNT($F11:X11),EDATE(EDATE(X11,1),0)))","v":"2019-12-05"},{"$f":"IF('1-1-2019'!AE11<>\"\",TODAY(),\"\")","v":""},{"$f":"IF(Z11=\"\",\"\",IF(COUNT($F11:Z11),EDATE(EDATE(Z11,1),0)))","v":"2020-01-05"},{"$f":"IF('1-1-2019'!AF11<>\"\",TODAY(),\"\")","v":""}]

{"sheet":"تنبية بالاقساط","index":1,"n_rows":11,"n_cols":32,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["كود العميل","اسم العميل","رقم التليفون","قيمة القسط","عدد الاقساط","تنبيه القسط ال1  ","تنبيه القسط ال2","تنبيه القسط ال3","تنبيه القسط ال4","تنبيه القسط ال5","تنبيه القسط ال6","تنبيه القسط ال7","تنبيه القسط ال8","تنبيه القسط ال9","تنبيه القسط ال10","تنبيه القسط ال 11","تنبيه القسط ال 12"]
[1,{"$f":"IFERROR(VLOOKUP(A2,Data!A:E,2,0),\"\")","v":"احمد عثمان حسن "},{"$f":"IFERROR(VLOOKUP(B2,Data!B:F,2,0),\"\")","v":1142900862},{"$f":"IFERROR(VLOOKUP(C2,Data!C:G,2,0),\"\")","v":200},{"$f":"IFERROR(VLOOKUP(D2,Data!D:H,2,0),\"\")","v":10},{"$f":"IF(Data!F2=\"\",\"\",IF(Data!F2>TODAY(),\" باقى\"&\"\"&Data!F2-TODAY()&\" \"&\"يوم \",IF(Data!G2=\"\",\"تاخير\"&\" \"&TODAY()-Data!F2,\"\")))","v":""},{"$f":"IF(Data!F2=\"\",\"\",IF(Data!H2>TODAY(),\" باقى\"&\"\"&Data!H2-TODAY()&\" \"&\"يوم \",IF(Data!I2=\"\",\"تاخير\"&\" \"&TODAY()-Data!H2,\"\")))","v":""},{"$f":"IF(Data!H2=\"\",\"\",IF(Data!J2>TODAY(),\" باقى\"&\"\"&Data!J2-TODAY()&\" \"&\"يوم \",IF(Data!K2=\"\",\"تاخير\"&\" \"&TODAY()-Data!J2,\"\")))","v":""},{"$f":"IF(Data!J2=\"\",\"\",IF(Data!L2>TODAY(),\" باقى\"&\"\"&Data!L2-TODAY()&\" \"&\"يوم \",IF(Data!M2=\"\",\"تاخير\"&\" \"&TODAY()-Data!L2,\"\")))","v":""},{"$f":"IF(Data!L2=\"\",\"\",IF(Data!N2>TODAY(),\" باقى\"&\"\"&Data!N2-TODAY()&\" \"&\"يوم \",IF(Data!O2=\"\",\"تاخير\"&\" \"&TODAY()-Data!N2,\"\")))","v":""},{"$f":"IF(Data!N2=\"\",\"\",IF(Data!P2>TODAY(),\" باقى\"&\"\"&Data!P2-TODAY()&\" \"&\"يوم \",IF(Data!Q2=\"\",\"تاخير\"&\" \"&TODAY()-Data!P2,\"\")))","v":""},{"$f":"IF(Data!P2=\"\",\"\",IF(Data!R2>TODAY(),\" باقى\"&\"\"&Data!R2-TODAY()&\" \"&\"يوم \",IF(Data!S2=\"\",\"تاخير\"&\" \"&TODAY()-Data!R2,\"\")))","v":""},{"$f":"IF(Data!R2=\"\",\"\",IF(Data!T2>TODAY(),\" باقى\"&\"\"&Data!T2-TODAY()&\" \"&\"يوم \",IF(Data!U2=\"\",\"تاخير\"&\" \"&TODAY()-Data!T2,\"\")))","v":""},{"$f":"IF(Data!T2=\"\",\"\",IF(Data!V2>TODAY(),\" باقى\"&\"\"&Data!V2-TODAY()&\" \"&\"يوم \",IF(Data!W2=\"\",\"تاخير\"&\" \"&TODAY()-Data!V2,\"\")))","v":"تاخير 183"},{"$f":"IF(Data!V2=\"\",\"\",IF(Data!X2>TODAY(),\" باقى\"&\"\"&Data!X2-TODAY()&\" \"&\"يوم \",IF(Data!Y2=\"\",\"تاخير\"&\" \"&TODAY()-Data!X2,\"\")))","v":"تاخير 152"},{"$f":"IF(Data!X2=\"\",\"\",IF(Data!Z2>TODAY(),\" باقى\"&\"\"&Data!Z2-TODAY()&\" \"&\"يوم \",IF(Data!AA2=\"\",\"تاخير\"&\" \"&TODAY()-Data!Z2,\"\")))","v":"تاخير 122"},{"$f":"IF(Data!Z2=\"\",\"\",IF(Data!AB2>TODAY(),\" باقى\"&\"\"&Data!AB2-TODAY()&\" \"&\"يوم \",IF(Data!AC2=\"\",\"تاخير\"&\" \"&TODAY()-Data!AB2,\"\")))","v":"تاخير 91"},null,{"$f":"IF(Data!S2=\"\",\"\",IF(Data!U2>TODAY(),\" باقى\"&\"\"&Data!U2-TODAY()&\" \"&\"يوم \",IF(Data!V2=\"\",\"تاخير\"&\" \"&TODAY()-Data!U2,\"\")))","v":""},null,{"$f":"IF(Data!U2=\"\",\"\",IF(Data!W2>TODAY(),\" باقى\"&\"\"&Data!W2-TODAY()&\" \"&\"يوم \",IF(Data!X2=\"\",\"تاخير\"&\" \"&TODAY()-Data!W2,\"\")))","v":{"$error":"#VALUE!"}},null,{"$f":"IF(Data!W2=\"\",\"\",IF(Data!Y2>TODAY(),\" باقى\"&\"\"&Data!Y2-TODAY()&\" \"&\"يوم \",IF(Data!Z2=\"\",\"تاخير\"&\" \"&TODAY()-Data!Y2,\"\")))","v":""},null,{"$f":"IF(Data!Y2=\"\",\"\",IF(Data!AA2>TODAY(),\" باقى\"&\"\"&Data!AA2-TODAY()&\" \"&\"يوم \",IF(Data!AB2=\"\",\"تاخير\"&\" \"&TODAY()-Data!AA2,\"\")))","v":""},{"$f":"IF(Data!Z2=\"\",\"\",IF(Data!AB2>TODAY(),\" باقى\"&\"\"&Data!AB2-TODAY()&\" \"&\"يوم \",IF(Data!AC2=\"\",\"تاخير\"&\" \"&TODAY()-Data!AB2,\"\")))","v":"تاخير 91"},{"$f":"IF(Data!AA2=\"\",\"\",IF(Data!AC2>TODAY(),\" باقى\"&\"\"&Data!AC2-TODAY()&\" \"&\"يوم \",IF(Data!AD2=\"\",\"تاخير\"&\" \"&TODAY()-Data!AC2,\"\")))","v":""},{"$f":"IF(Data!AB2=\"\",\"\",IF(Data!AD2>TODAY(),\" باقى\"&\"\"&Data!AD2-TODAY()&\" \"&\"يوم \",IF(Data!AE2=\"\",\"تاخير\"&\" \"&TODAY()-Data!AD2,\"\")))","v":"تاخير 43924"},{"$f":"IF(Data!AC2=\"\",\"\",IF(Data!AE2>TODAY(),\" باقى\"&\"\"&Data!AE2-TODAY()&\" \"&\"يوم \",IF(Data!AF2=\"\",\"تاخير\"&\" \"&TODAY()-Data!AE2,\"\")))","v":""},{"$f":"IF(Data!AD2=\"\",\"\",IF(Data!AF2>TODAY(),\" باقى\"&\"\"&Data!AF2-TODAY()&\" \"&\"يوم \",IF(Data!AG2=\"\",\"تاخير\"&\" \"&TODAY()-Data!AF2,\"\")))","v":""},{"$f":"IF(Data!AE2=\"\",\"\",IF(Data!AG2>TODAY(),\" باقى\"&\"\"&Data!AG2-TODAY()&\" \"&\"يوم \",IF(Data!AH2=\"\",\"تاخير\"&\" \"&TODAY()-Data!AG2,\"\")))","v":""},{"$f":"IF(Data!AF2=\"\",\"\",IF(Data!AH2>TODAY(),\" باقى\"&\"\"&Data!AH2-TODAY()&\" \"&\"يوم \",IF(Data!AI2=\"\",\"تاخير\"&\" \"&TODAY()-Data!AH2,\"\")))","v":""}]
[2,{"$f":"IFERROR(VLOOKUP(A3,Data!A:E,2,0),\"\")","v":"احمد عثمان حسن 2"},{"$f":"IFERROR(VLOOKUP(B3,Data!B:F,2,0),\"\")","v":1002130296},{"$f":"IFERROR(VLOOKUP(C3,Data!C:G,2,0),\"\")","v":200},{"$f":"IFERROR(VLOOKUP(D3,Data!D:H,2,0),\"\")","v":10},{"$f":"IF(Data!F3=\"\",\"\",IF(Data!F3>TODAY(),\" باقى\"&\"\"&Data!F3-TODAY()&\" \"&\"يوم \",IF(Data!G3=\"\",\"تاخير\"&\" \"&TODAY()-Data!F3,\"\")))","v":""},{"$f":"IF(Data!F3=\"\",\"\",IF(Data!H3>TODAY(),\" باقى\"&\"\"&Data!H3-TODAY()&\" \"&\"يوم \",IF(Data!I3=\"\",\"تاخير\"&\" \"&TODAY()-Data!H3,\"\")))","v":"تاخير 170"},{"$f":"IF(Data!H3=\"\",\"\",IF(Data!J3>TODAY(),\" باقى\"&\"\"&Data!J3-TODAY()&\" \"&\"يوم \",IF(Data!K3=\"\",\"تاخير\"&\" \"&TODAY()-Data!J3,\"\")))","v":"تاخير 139"},{"$f":"IF(Data!J3=\"\",\"\",IF(Data!L3>TODAY(),\" باقى\"&\"\"&Data!L3-TODAY()&\" \"&\"يوم \",IF(Data!M3=\"\",\"تاخير\"&\" \"&TODAY()-Data!L3,\"\")))","v":"تاخير 109"},{"$f":"IF(Data!L3=\"\",\"\",IF(Data!N3>TODAY(),\" باقى\"&\"\"&Data!N3-TODAY()&\" \"&\"يوم \",IF(Data!O3=\"\",\"تاخير\"&\" \"&TODAY()-Data!N3,\"\")))","v":"تاخير 78"},{"$f":"IF(Data!N3=\"\",\"\",IF(Data!P3>TODAY(),\" باقى\"&\"\"&Data!P3-TODAY()&\" \"&\"يوم \",IF(Data!Q3=\"\",\"تاخير\"&\" \"&TODAY()-Data!P3,\"\")))","v":"تاخير 47"},{"$f":"IF(Data!P3=\"\",\"\",IF(Data!R3>TODAY(),\" باقى\"&\"\"&Data!R3-TODAY()&\" \"&\"يوم \",IF(Data!S3=\"\",\"تاخير\"&\" \"&TODAY()-Data!R3,\"\")))","v":"تاخير 18"},{"$f":"IF(Data!R3=\"\",\"\",IF(Data!T3>TODAY(),\" باقى\"&\"\"&Data!T3-TODAY()&\" \"&\"يوم \",IF(Data!U3=\"\",\"تاخير\"&\" \"&TODAY()-Data!T3,\"\")))","v":" باقى13 يوم "},{"$f":"IF(Data!T3=\"\",\"\",IF(Data!V3>TODAY(),\" باقى\"&\"\"&Data!V3-TODAY()&\" \"&\"يوم \",IF(Data!W3=\"\",\"تاخير\"&\" \"&TODAY()-Data!V3,\"\")))","v":" باقى43 يوم "},{"$f":"IF(Data!V3=\"\",\"\",IF(Data!X3>TODAY(),\" باقى\"&\"\"&Data!X3-TODAY()&\" \"&\"يوم \",IF(Data!Y3=\"\",\"تاخير\"&\" \"&TODAY()-Data!X3,\"\")))","v":" باقى74 يوم "},{"$f":"IF(Data!X3=\"\",\"\",IF(Data!Z3>TODAY(),\" باقى\"&\"\"&Data!Z3-TODAY()&\" \"&\"يوم \",IF(Data!AA3=\"\",\"تاخير\"&\" \"&TODAY()-Data!Z3,\"\")))","v":" باقى104 يوم "},{"$f":"IF(Data!Z3=\"\",\"\",IF(Data!AB3>TODAY(),\" باقى\"&\"\"&Data!AB3-TODAY()&\" \"&\"يوم \",IF(Data!AC3=\"\",\"تاخير\"&\" \"&TODAY()-Data!AB3,\"\")))","v":" باقى135 يوم "}]
[3,{"$f":"IFERROR(VLOOKUP(A4,Data!A:E,2,0),\"\")","v":"محمود فتحي حسن علي "},{"$f":"IFERROR(VLOOKUP(B4,Data!B:F,2,0),\"\")","v":1062556099},{"$f":"IFERROR(VLOOKUP(C4,Data!C:G,2,0),\"\")","v":200},{"$f":"IFERROR(VLOOKUP(D4,Data!D:H,2,0),\"\")","v":10},{"$f":"IF(Data!F4=\"\",\"\",IF(Data!F4>TODAY(),\" باقى\"&\"\"&Data!F4-TODAY()&\" \"&\"يوم \",IF(Data!G4=\"\",\"تاخير\"&\" \"&TODAY()-Data!F4,\"\")))","v":""},{"$f":"IF(Data!F4=\"\",\"\",IF(Data!H4>TODAY(),\" باقى\"&\"\"&Data!H4-TODAY()&\" \"&\"يوم \",IF(Data!I4=\"\",\"تاخير\"&\" \"&TODAY()-Data!H4,\"\")))","v":""},{"$f":"IF(Data!H4=\"\",\"\",IF(Data!J4>TODAY(),\" باقى\"&\"\"&Data!J4-TODAY()&\" \"&\"يوم \",IF(Data!K4=\"\",\"تاخير\"&\" \"&TODAY()-Data!J4,\"\")))","v":""},{"$f":"IF(Data!J4=\"\",\"\",IF(Data!L4>TODAY(),\" باقى\"&\"\"&Data!L4-TODAY()&\" \"&\"يوم \",IF(Data!M4=\"\",\"تاخير\"&\" \"&TODAY()-Data!L4,\"\")))","v":""},{"$f":"IF(Data!L4=\"\",\"\",IF(Data!N4>TODAY(),\" باقى\"&\"\"&Data!N4-TODAY()&\" \"&\"يوم \",IF(Data!O4=\"\",\"تاخير\"&\" \"&TODAY()-Data!N4,\"\")))","v":""},{"$f":"IF(Data!N4=\"\",\"\",IF(Data!P4>TODAY(),\" باقى\"&\"\"&Data!P4-TODAY()&\" \"&\"يوم \",IF(Data!Q4=\"\",\"تاخير\"&\" \"&TODAY()-Data!P4,\"\")))","v":""},{"$f":"IF(Data!P4=\"\",\"\",IF(Data!R4>TODAY(),\" باقى\"&\"\"&Data!R4-TODAY()&\" \"&\"يوم \",IF(Data!S4=\"\",\"تاخير\"&\" \"&TODAY()-Data!R4,\"\")))","v":""},{"$f":"IF(Data!R4=\"\",\"\",IF(Data!T4>TODAY(),\" باقى\"&\"\"&Data!T4-TODAY()&\" \"&\"يوم \",IF(Data!U4=\"\",\"تاخير\"&\" \"&TODAY()-Data!T4,\"\")))","v":"تاخير 212"},{"$f":"IF(Data!T4=\"\",\"\",IF(Data!V4>TODAY(),\" باقى\"&\"\"&Data!V4-TODAY()&\" \"&\"يوم \",IF(Data!W4=\"\",\"تاخير\"&\" \"&TODAY()-Data!V4,\"\")))","v":"تاخير 182"},{"$f":"IF(Data!V4=\"\",\"\",IF(Data!X4>TODAY(),\" باقى\"&\"\"&Data!X4-TODAY()&\" \"&\"يوم \",IF(Data!Y4=\"\",\"تاخير\"&\" \"&TODAY()-Data!X4,\"\")))","v":"تاخير 151"},{"$f":"IF(Data!X4=\"\",\"\",IF(Data!Z4>TODAY(),\" باقى\"&\"\"&Data!Z4-TODAY()&\" \"&\"يوم \",IF(Data!AA4=\"\",\"تاخير\"&\" \"&TODAY()-Data!Z4,\"\")))","v":"تاخير 121"},{"$f":"IF(Data!Z4=\"\",\"\",IF(Data!AB4>TODAY(),\" باقى\"&\"\"&Data!AB4-TODAY()&\" \"&\"يوم \",IF(Data!AC4=\"\",\"تاخير\"&\" \"&TODAY()-Data!AB4,\"\")))","v":"تاخير 90"}]
[4,{"$f":"IFERROR(VLOOKUP(A5,Data!A:E,2,0),\"\")","v":"محمود فتحي حسن علي 2"},{"$f":"IFERROR(VLOOKUP(B5,Data!B:F,2,0),\"\")","v":1062556099},{"$f":"IFERROR(VLOOKUP(C5,Data!C:G,2,0),\"\")","v":200},{"$f":"IFERROR(VLOOKUP(D5,Data!D:H,2,0),\"\")","v":10},{"$f":"IF(Data!F5=\"\",\"\",IF(Data!F5>TODAY(),\" باقى\"&\"\"&Data!F5-TODAY()&\" \"&\"يوم \",IF(Data!G5=\"\",\"تاخير\"&\" \"&TODAY()-Data!F5,\"\")))","v":""},{"$f":"IF(Data!F5=\"\",\"\",IF(Data!H5>TODAY(),\" باقى\"&\"\"&Data!H5-TODAY()&\" \"&\"يوم \",IF(Data!I5=\"\",\"تاخير\"&\" \"&TODAY()-Data!H5,\"\")))","v":""},{"$f":"IF(Data!H5=\"\",\"\",IF(Data!J5>TODAY(),\" باقى\"&\"\"&Data!J5-TODAY()&\" \"&\"يوم \",IF(Data!K5=\"\",\"تاخير\"&\" \"&TODAY()-Data!J5,\"\")))","v":""},{"$f":"IF(Data!J5=\"\",\"\",IF(Data!L5>TODAY(),\" باقى\"&\"\"&Data!L5-TODAY()&\" \"&\"يوم \",IF(Data!M5=\"\",\"تاخير\"&\" \"&TODAY()-Data!L5,\"\")))","v":""},{"$f":"IF(Data!L5=\"\",\"\",IF(Data!N5>TODAY(),\" باقى\"&\"\"&Data!N5-TODAY()&\" \"&\"يوم \",IF(Data!O5=\"\",\"تاخير\"&\" \"&TODAY()-Data!N5,\"\")))","v":"تاخير 182"},{"$f":"IF(Data!N5=\"\",\"\",IF(Data!P5>TODAY(),\" باقى\"&\"\"&Data!P5-TODAY()&\" \"&\"يوم \",IF(Data!Q5=\"\",\"تاخير\"&\" \"&TODAY()-Data!P5,\"\")))","v":"تاخير 151"},{"$f":"IF(Data!P5=\"\",\"\",IF(Data!R5>TODAY(),\" باقى\"&\"\"&Data!R5-TODAY()&\" \"&\"يوم \",IF(Data!S5=\"\",\"تاخير\"&\" \"&TODAY()-Data!R5,\"\")))","v":"تاخير 121"},{"$f":"IF(Data!R5=\"\",\"\",IF(Data!T5>TODAY(),\" باقى\"&\"\"&Data!T5-TODAY()&\" \"&\"يوم \",IF(Data!U5=\"\",\"تاخير\"&\" \"&TODAY()-Data!T5,\"\")))","v":"تاخير 90"},{"$f":"IF(Data!T5=\"\",\"\",IF(Data!V5>TODAY(),\" باقى\"&\"\"&Data!V5-TODAY()&\" \"&\"يوم \",IF(Data!W5=\"\",\"تاخير\"&\" \"&TODAY()-Data!V5,\"\")))","v":"تاخير 59"},{"$f":"IF(Data!V5=\"\",\"\",IF(Data!X5>TODAY(),\" باقى\"&\"\"&Data!X5-TODAY()&\" \"&\"يوم \",IF(Data!Y5=\"\",\"تاخير\"&\" \"&TODAY()-Data!X5,\"\")))","v":"تاخير 30"},{"$f":"IF(Data!X5=\"\",\"\",IF(Data!Z5>TODAY(),\" باقى\"&\"\"&Data!Z5-TODAY()&\" \"&\"يوم \",IF(Data!AA5=\"\",\"تاخير\"&\" \"&TODAY()-Data!Z5,\"\")))","v":" باقى1 يوم "},{"$f":"IF(Data!Z5=\"\",\"\",IF(Data!AB5>TODAY(),\" باقى\"&\"\"&Data!AB5-TODAY()&\" \"&\"يوم \",IF(Data!AC5=\"\",\"تاخير\"&\" \"&TODAY()-Data!AB5,\"\")))","v":" باقى31 يوم "}]
[5,{"$f":"IFERROR(VLOOKUP(A6,Data!A:E,2,0),\"\")","v":"محمود فتحي حسن علي 3"},{"$f":"IFERROR(VLOOKUP(B6,Data!B:F,2,0),\"\")","v":0},{"$f":"IFERROR(VLOOKUP(C6,Data!C:G,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(D6,Data!D:H,2,0),\"\")","v":""},{"$f":"IF(Data!F6=\"\",\"\",IF(Data!F6>TODAY(),\" باقى\"&\"\"&Data!F6-TODAY()&\" \"&\"يوم \",IF(Data!G6=\"\",\"تاخير\"&\" \"&TODAY()-Data!F6,\"\")))","v":""},{"$f":"IF(Data!F6=\"\",\"\",IF(Data!H6>TODAY(),\" باقى\"&\"\"&Data!H6-TODAY()&\" \"&\"يوم \",IF(Data!I6=\"\",\"تاخير\"&\" \"&TODAY()-Data!H6,\"\")))","v":""},{"$f":"IF(Data!H6=\"\",\"\",IF(Data!J6>TODAY(),\" باقى\"&\"\"&Data!J6-TODAY()&\" \"&\"يوم \",IF(Data!K6=\"\",\"تاخير\"&\" \"&TODAY()-Data!J6,\"\")))","v":"تاخير 120"},{"$f":"IF(Data!J6=\"\",\"\",IF(Data!L6>TODAY(),\" باقى\"&\"\"&Data!L6-TODAY()&\" \"&\"يوم \",IF(Data!M6=\"\",\"تاخير\"&\" \"&TODAY()-Data!L6,\"\")))","v":"تاخير 89"},{"$f":"IF(Data!L6=\"\",\"\",IF(Data!N6>TODAY(),\" باقى\"&\"\"&Data!N6-TODAY()&\" \"&\"يوم \",IF(Data!O6=\"\",\"تاخير\"&\" \"&TODAY()-Data!N6,\"\")))","v":"تاخير 58"},{"$f":"IF(Data!N6=\"\",\"\",IF(Data!P6>TODAY(),\" باقى\"&\"\"&Data!P6-TODAY()&\" \"&\"يوم \",IF(Data!Q6=\"\",\"تاخير\"&\" \"&TODAY()-Data!P6,\"\")))","v":"تاخير 29"},{"$f":"IF(Data!P6=\"\",\"\",IF(Data!R6>TODAY(),\" باقى\"&\"\"&Data!R6-TODAY()&\" \"&\"يوم \",IF(Data!S6=\"\",\"تاخير\"&\" \"&TODAY()-Data!R6,\"\")))","v":" باقى2 يوم "},{"$f":"IF(Data!R6=\"\",\"\",IF(Data!T6>TODAY(),\" باقى\"&\"\"&Data!T6-TODAY()&\" \"&\"يوم \",IF(Data!U6=\"\",\"تاخير\"&\" \"&TODAY()-Data!T6,\"\")))","v":" باقى32 يوم "},{"$f":"IF(Data!T6=\"\",\"\",IF(Data!V6>TODAY(),\" باقى\"&\"\"&Data!V6-TODAY()&\" \"&\"يوم \",IF(Data!W6=\"\",\"تاخير\"&\" \"&TODAY()-Data!V6,\"\")))","v":" باقى63 يوم "},{"$f":"IF(Data!V6=\"\",\"\",IF(Data!X6>TODAY(),\" باقى\"&\"\"&Data!X6-TODAY()&\" \"&\"يوم \",IF(Data!Y6=\"\",\"تاخير\"&\" \"&TODAY()-Data!X6,\"\")))","v":" باقى93 يوم "},{"$f":"IF(Data!X6=\"\",\"\",IF(Data!Z6>TODAY(),\" باقى\"&\"\"&Data!Z6-TODAY()&\" \"&\"يوم \",IF(Data!AA6=\"\",\"تاخير\"&\" \"&TODAY()-Data!Z6,\"\")))","v":" باقى124 يوم "},{"$f":"IF(Data!Z6=\"\",\"\",IF(Data!AB6>TODAY(),\" باقى\"&\"\"&Data!AB6-TODAY()&\" \"&\"يوم \",IF(Data!AC6=\"\",\"تاخير\"&\" \"&TODAY()-Data!AB6,\"\")))","v":" باقى155 يوم "}]
[6,{"$f":"IFERROR(VLOOKUP(A7,Data!A:E,2,0),\"\")","v":"ربيع سيد مستعمل  "},{"$f":"IFERROR(VLOOKUP(B7,Data!B:F,2,0),\"\")","v":0},{"$f":"IFERROR(VLOOKUP(C7,Data!C:G,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(D7,Data!D:H,2,0),\"\")","v":""},{"$f":"IF(Data!F7=\"\",\"\",IF(Data!F7>TODAY(),\" باقى\"&\"\"&Data!F7-TODAY()&\" \"&\"يوم \",IF(Data!G7=\"\",\"تاخير\"&\" \"&TODAY()-Data!F7,\"\")))","v":""},{"$f":"IF(Data!F7=\"\",\"\",IF(Data!H7>TODAY(),\" باقى\"&\"\"&Data!H7-TODAY()&\" \"&\"يوم \",IF(Data!I7=\"\",\"تاخير\"&\" \"&TODAY()-Data!H7,\"\")))","v":""},{"$f":"IF(Data!H7=\"\",\"\",IF(Data!J7>TODAY(),\" باقى\"&\"\"&Data!J7-TODAY()&\" \"&\"يوم \",IF(Data!K7=\"\",\"تاخير\"&\" \"&TODAY()-Data!J7,\"\")))","v":""},{"$f":"IF(Data!J7=\"\",\"\",IF(Data!L7>TODAY(),\" باقى\"&\"\"&Data!L7-TODAY()&\" \"&\"يوم \",IF(Data!M7=\"\",\"تاخير\"&\" \"&TODAY()-Data!L7,\"\")))","v":""},{"$f":"IF(Data!L7=\"\",\"\",IF(Data!N7>TODAY(),\" باقى\"&\"\"&Data!N7-TODAY()&\" \"&\"يوم \",IF(Data!O7=\"\",\"تاخير\"&\" \"&TODAY()-Data!N7,\"\")))","v":""},{"$f":"IF(Data!N7=\"\",\"\",IF(Data!P7>TODAY(),\" باقى\"&\"\"&Data!P7-TODAY()&\" \"&\"يوم \",IF(Data!Q7=\"\",\"تاخير\"&\" \"&TODAY()-Data!P7,\"\")))","v":"تاخير 47"},{"$f":"IF(Data!P7=\"\",\"\",IF(Data!R7>TODAY(),\" باقى\"&\"\"&Data!R7-TODAY()&\" \"&\"يوم \",IF(Data!S7=\"\",\"تاخير\"&\" \"&TODAY()-Data!R7,\"\")))","v":"تاخير 18"},{"$f":"IF(Data!R7=\"\",\"\",IF(Data!T7>TODAY(),\" باقى\"&\"\"&Data!T7-TODAY()&\" \"&\"يوم \",IF(Data!U7=\"\",\"تاخير\"&\" \"&TODAY()-Data!T7,\"\")))","v":" باقى13 يوم "},{"$f":"IF(Data!T7=\"\",\"\",IF(Data!V7>TODAY(),\" باقى\"&\"\"&Data!V7-TODAY()&\" \"&\"يوم \",IF(Data!W7=\"\",\"تاخير\"&\" \"&TODAY()-Data!V7,\"\")))","v":" باقى43 يوم "},{"$f":"IF(Data!V7=\"\",\"\",IF(Data!X7>TODAY(),\" باقى\"&\"\"&Data!X7-TODAY()&\" \"&\"يوم \",IF(Data!Y7=\"\",\"تاخير\"&\" \"&TODAY()-Data!X7,\"\")))","v":" باقى74 يوم "},{"$f":"IF(Data!X7=\"\",\"\",IF(Data!Z7>TODAY(),\" باقى\"&\"\"&Data!Z7-TODAY()&\" \"&\"يوم \",IF(Data!AA7=\"\",\"تاخير\"&\" \"&TODAY()-Data!Z7,\"\")))","v":" باقى104 يوم "},{"$f":"IF(Data!Z7=\"\",\"\",IF(Data!AB7>TODAY(),\" باقى\"&\"\"&Data!AB7-TODAY()&\" \"&\"يوم \",IF(Data!AC7=\"\",\"تاخير\"&\" \"&TODAY()-Data!AB7,\"\")))","v":" باقى135 يوم "}]
[7,{"$f":"IFERROR(VLOOKUP(A8,Data!A:E,2,0),\"\")","v":"ربيع سيد  / صبري"},{"$f":"IFERROR(VLOOKUP(B8,Data!B:F,2,0),\"\")","v":0},{"$f":"IFERROR(VLOOKUP(C8,Data!C:G,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(D8,Data!D:H,2,0),\"\")","v":""},{"$f":"IF(Data!F8=\"\",\"\",IF(Data!F8>TODAY(),\" باقى\"&\"\"&Data!F8-TODAY()&\" \"&\"يوم \",IF(Data!G8=\"\",\"تاخير\"&\" \"&TODAY()-Data!F8,\"\")))","v":""},{"$f":"IF(Data!F8=\"\",\"\",IF(Data!H8>TODAY(),\" باقى\"&\"\"&Data!H8-TODAY()&\" \"&\"يوم \",IF(Data!I8=\"\",\"تاخير\"&\" \"&TODAY()-Data!H8,\"\")))","v":""},{"$f":"IF(Data!H8=\"\",\"\",IF(Data!J8>TODAY(),\" باقى\"&\"\"&Data!J8-TODAY()&\" \"&\"يوم \",IF(Data!K8=\"\",\"تاخير\"&\" \"&TODAY()-Data!J8,\"\")))","v":""},{"$f":"IF(Data!J8=\"\",\"\",IF(Data!L8>TODAY(),\" باقى\"&\"\"&Data!L8-TODAY()&\" \"&\"يوم \",IF(Data!M8=\"\",\"تاخير\"&\" \"&TODAY()-Data!L8,\"\")))","v":""},{"$f":"IF(Data!L8=\"\",\"\",IF(Data!N8>TODAY(),\" باقى\"&\"\"&Data!N8-TODAY()&\" \"&\"يوم \",IF(Data!O8=\"\",\"تاخير\"&\" \"&TODAY()-Data!N8,\"\")))","v":"تاخير 75"},{"$f":"IF(Data!N8=\"\",\"\",IF(Data!P8>TODAY(),\" باقى\"&\"\"&Data!P8-TODAY()&\" \"&\"يوم \",IF(Data!Q8=\"\",\"تاخير\"&\" \"&TODAY()-Data!P8,\"\")))","v":"تاخير 44"},{"$f":"IF(Data!P8=\"\",\"\",IF(Data!R8>TODAY(),\" باقى\"&\"\"&Data!R8-TODAY()&\" \"&\"يوم \",IF(Data!S8=\"\",\"تاخير\"&\" \"&TODAY()-Data!R8,\"\")))","v":"تاخير 15"},{"$f":"IF(Data!R8=\"\",\"\",IF(Data!T8>TODAY(),\" باقى\"&\"\"&Data!T8-TODAY()&\" \"&\"يوم \",IF(Data!U8=\"\",\"تاخير\"&\" \"&TODAY()-Data!T8,\"\")))","v":" باقى16 يوم "},{"$f":"IF(Data!T8=\"\",\"\",IF(Data!V8>TODAY(),\" باقى\"&\"\"&Data!V8-TODAY()&\" \"&\"يوم \",IF(Data!W8=\"\",\"تاخير\"&\" \"&TODAY()-Data!V8,\"\")))","v":" باقى46 يوم "},{"$f":"IF(Data!V8=\"\",\"\",IF(Data!X8>TODAY(),\" باقى\"&\"\"&Data!X8-TODAY()&\" \"&\"يوم \",IF(Data!Y8=\"\",\"تاخير\"&\" \"&TODAY()-Data!X8,\"\")))","v":" باقى77 يوم "},{"$f":"IF(Data!X8=\"\",\"\",IF(Data!Z8>TODAY(),\" باقى\"&\"\"&Data!Z8-TODAY()&\" \"&\"يوم \",IF(Data!AA8=\"\",\"تاخير\"&\" \"&TODAY()-Data!Z8,\"\")))","v":" باقى107 يوم "},{"$f":"IF(Data!Z8=\"\",\"\",IF(Data!AB8>TODAY(),\" باقى\"&\"\"&Data!AB8-TODAY()&\" \"&\"يوم \",IF(Data!AC8=\"\",\"تاخير\"&\" \"&TODAY()-Data!AB8,\"\")))","v":" باقى138 يوم "}]
[8,{"$f":"IFERROR(VLOOKUP(A9,Data!A:E,2,0),\"\")","v":"محمد عبد الحميد عبد النظور / عز عبد الحميد "},{"$f":"IFERROR(VLOOKUP(B9,Data!B:F,2,0),\"\")","v":1066971345},{"$f":"IFERROR(VLOOKUP(C9,Data!C:G,2,0),\"\")","v":200},{"$f":"IFERROR(VLOOKUP(D9,Data!D:H,2,0),\"\")","v":10},{"$f":"IF(Data!F9=\"\",\"\",IF(Data!F9>TODAY(),\" باقى\"&\"\"&Data!F9-TODAY()&\" \"&\"يوم \",IF(Data!G9=\"\",\"تاخير\"&\" \"&TODAY()-Data!F9,\"\")))","v":""},{"$f":"IF(Data!F9=\"\",\"\",IF(Data!H9>TODAY(),\" باقى\"&\"\"&Data!H9-TODAY()&\" \"&\"يوم \",IF(Data!I9=\"\",\"تاخير\"&\" \"&TODAY()-Data!H9,\"\")))","v":""},{"$f":"IF(Data!H9=\"\",\"\",IF(Data!J9>TODAY(),\" باقى\"&\"\"&Data!J9-TODAY()&\" \"&\"يوم \",IF(Data!K9=\"\",\"تاخير\"&\" \"&TODAY()-Data!J9,\"\")))","v":""},{"$f":"IF(Data!J9=\"\",\"\",IF(Data!L9>TODAY(),\" باقى\"&\"\"&Data!L9-TODAY()&\" \"&\"يوم \",IF(Data!M9=\"\",\"تاخير\"&\" \"&TODAY()-Data!L9,\"\")))","v":""},{"$f":"IF(Data!L9=\"\",\"\",IF(Data!N9>TODAY(),\" باقى\"&\"\"&Data!N9-TODAY()&\" \"&\"يوم \",IF(Data!O9=\"\",\"تاخير\"&\" \"&TODAY()-Data!N9,\"\")))","v":""},{"$f":"IF(Data!N9=\"\",\"\",IF(Data!P9>TODAY(),\" باقى\"&\"\"&Data!P9-TODAY()&\" \"&\"يوم \",IF(Data!Q9=\"\",\"تاخير\"&\" \"&TODAY()-Data!P9,\"\")))","v":""},{"$f":"IF(Data!P9=\"\",\"\",IF(Data!R9>TODAY(),\" باقى\"&\"\"&Data!R9-TODAY()&\" \"&\"يوم \",IF(Data!S9=\"\",\"تاخير\"&\" \"&TODAY()-Data!R9,\"\")))","v":""},{"$f":"IF(Data!R9=\"\",\"\",IF(Data!T9>TODAY(),\" باقى\"&\"\"&Data!T9-TODAY()&\" \"&\"يوم \",IF(Data!U9=\"\",\"تاخير\"&\" \"&TODAY()-Data!T9,\"\")))","v":""},{"$f":"IF(Data!T9=\"\",\"\",IF(Data!V9>TODAY(),\" باقى\"&\"\"&Data!V9-TODAY()&\" \"&\"يوم \",IF(Data!W9=\"\",\"تاخير\"&\" \"&TODAY()-Data!V9,\"\")))","v":""},{"$f":"IF(Data!V9=\"\",\"\",IF(Data!X9>TODAY(),\" باقى\"&\"\"&Data!X9-TODAY()&\" \"&\"يوم \",IF(Data!Y9=\"\",\"تاخير\"&\" \"&TODAY()-Data!X9,\"\")))","v":"تاخير 150"},{"$f":"IF(Data!X9=\"\",\"\",IF(Data!Z9>TODAY(),\" باقى\"&\"\"&Data!Z9-TODAY()&\" \"&\"يوم \",IF(Data!AA9=\"\",\"تاخير\"&\" \"&TODAY()-Data!Z9,\"\")))","v":"تاخير 120"},{"$f":"IF(Data!Z9=\"\",\"\",IF(Data!AB9>TODAY(),\" باقى\"&\"\"&Data!AB9-TODAY()&\" \"&\"يوم \",IF(Data!AC9=\"\",\"تاخير\"&\" \"&TODAY()-Data!AB9,\"\")))","v":"تاخير 89"}]
[9,{"$f":"IFERROR(VLOOKUP(A10,Data!A:E,2,0),\"\")","v":"فاطمه عبد المعز "},{"$f":"IFERROR(VLOOKUP(B10,Data!B:F,2,0),\"\")","v":0},{"$f":"IFERROR(VLOOKUP(C10,Data!C:G,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(D10,Data!D:H,2,0),\"\")","v":""},{"$f":"IF(Data!F10=\"\",\"\",IF(Data!F10>TODAY(),\" باقى\"&\"\"&Data!F10-TODAY()&\" \"&\"يوم \",IF(Data!G10=\"\",\"تاخير\"&\" \"&TODAY()-Data!F10,\"\")))","v":""},{"$f":"IF(Data!F10=\"\",\"\",IF(Data!H10>TODAY(),\" باقى\"&\"\"&Data!H10-TODAY()&\" \"&\"يوم \",IF(Data!I10=\"\",\"تاخير\"&\" \"&TODAY()-Data!H10,\"\")))","v":""},{"$f":"IF(Data!H10=\"\",\"\",IF(Data!J10>TODAY(),\" باقى\"&\"\"&Data!J10-TODAY()&\" \"&\"يوم \",IF(Data!K10=\"\",\"تاخير\"&\" \"&TODAY()-Data!J10,\"\")))","v":""},{"$f":"IF(Data!J10=\"\",\"\",IF(Data!L10>TODAY(),\" باقى\"&\"\"&Data!L10-TODAY()&\" \"&\"يوم \",IF(Data!M10=\"\",\"تاخير\"&\" \"&TODAY()-Data!L10,\"\")))","v":"تاخير 334"},{"$f":"IF(Data!L10=\"\",\"\",IF(Data!N10>TODAY(),\" باقى\"&\"\"&Data!N10-TODAY()&\" \"&\"يوم \",IF(Data!O10=\"\",\"تاخير\"&\" \"&TODAY()-Data!N10,\"\")))","v":"تاخير 303"},{"$f":"IF(Data!N10=\"\",\"\",IF(Data!P10>TODAY(),\" باقى\"&\"\"&Data!P10-TODAY()&\" \"&\"يوم \",IF(Data!Q10=\"\",\"تاخير\"&\" \"&TODAY()-Data!P10,\"\")))","v":"تاخير 273"},{"$f":"IF(Data!P10=\"\",\"\",IF(Data!R10>TODAY(),\" باقى\"&\"\"&Data!R10-TODAY()&\" \"&\"يوم \",IF(Data!S10=\"\",\"تاخير\"&\" \"&TODAY()-Data!R10,\"\")))","v":"تاخير 242"},{"$f":"IF(Data!R10=\"\",\"\",IF(Data!T10>TODAY(),\" باقى\"&\"\"&Data!T10-TODAY()&\" \"&\"يوم \",IF(Data!U10=\"\",\"تاخير\"&\" \"&TODAY()-Data!T10,\"\")))","v":"تاخير 211"},{"$f":"IF(Data!T10=\"\",\"\",IF(Data!V10>TODAY(),\" باقى\"&\"\"&Data!V10-TODAY()&\" \"&\"يوم \",IF(Data!W10=\"\",\"تاخير\"&\" \"&TODAY()-Data!V10,\"\")))","v":"تاخير 181"},{"$f":"IF(Data!V10=\"\",\"\",IF(Data!X10>TODAY(),\" باقى\"&\"\"&Data!X10-TODAY()&\" \"&\"يوم \",IF(Data!Y10=\"\",\"تاخير\"&\" \"&TODAY()-Data!X10,\"\")))","v":"تاخير 150"},{"$f":"IF(Data!X10=\"\",\"\",IF(Data!Z10>TODAY(),\" باقى\"&\"\"&Data!Z10-TODAY()&\" \"&\"يوم \",IF(Data!AA10=\"\",\"تاخير\"&\" \"&TODAY()-Data!Z10,\"\")))","v":"تاخير 120"},{"$f":"IF(Data!Z10=\"\",\"\",IF(Data!AB10>TODAY(),\" باقى\"&\"\"&Data!AB10-TODAY()&\" \"&\"يوم \",IF(Data!AC10=\"\",\"تاخير\"&\" \"&TODAY()-Data!AB10,\"\")))","v":"تاخير 89"}]
[10,{"$f":"IFERROR(VLOOKUP(A11,Data!A:E,2,0),\"\")","v":"مروان سعد تبع عبيد "},{"$f":"IFERROR(VLOOKUP(B11,Data!B:F,2,0),\"\")","v":"تبع عبيد"},{"$f":"IFERROR(VLOOKUP(C11,Data!C:G,2,0),\"\")","v":200},{"$f":"IFERROR(VLOOKUP(D11,Data!D:H,2,0),\"\")","v":10},{"$f":"IF(Data!F11=\"\",\"\",IF(Data!F11>TODAY(),\" باقى\"&\"\"&Data!F11-TODAY()&\" \"&\"يوم \",IF(Data!G11=\"\",\"تاخير\"&\" \"&TODAY()-Data!F11,\"\")))","v":""},{"$f":"IF(Data!F11=\"\",\"\",IF(Data!H11>TODAY(),\" باقى\"&\"\"&Data!H11-TODAY()&\" \"&\"يوم \",IF(Data!I11=\"\",\"تاخير\"&\" \"&TODAY()-Data!H11,\"\")))","v":""},{"$f":"IF(Data!H11=\"\",\"\",IF(Data!J11>TODAY(),\" باقى\"&\"\"&Data!J11-TODAY()&\" \"&\"يوم \",IF(Data!K11=\"\",\"تاخير\"&\" \"&TODAY()-Data!J11,\"\")))","v":""},{"$f":"IF(Data!J11=\"\",\"\",IF(Data!L11>TODAY(),\" باقى\"&\"\"&Data!L11-TODAY()&\" \"&\"يوم \",IF(Data!M11=\"\",\"تاخير\"&\" \"&TODAY()-Data!L11,\"\")))","v":""},{"$f":"IF(Data!L11=\"\",\"\",IF(Data!N11>TODAY(),\" باقى\"&\"\"&Data!N11-TODAY()&\" \"&\"يوم \",IF(Data!O11=\"\",\"تاخير\"&\" \"&TODAY()-Data!N11,\"\")))","v":""},{"$f":"IF(Data!N11=\"\",\"\",IF(Data!P11>TODAY(),\" باقى\"&\"\"&Data!P11-TODAY()&\" \"&\"يوم \",IF(Data!Q11=\"\",\"تاخير\"&\" \"&TODAY()-Data!P11,\"\")))","v":""},{"$f":"IF(Data!P11=\"\",\"\",IF(Data!R11>TODAY(),\" باقى\"&\"\"&Data!R11-TODAY()&\" \"&\"يوم \",IF(Data!S11=\"\",\"تاخير\"&\" \"&TODAY()-Data!R11,\"\")))","v":"تاخير 242"},{"$f":"IF(Data!R11=\"\",\"\",IF(Data!T11>TODAY(),\" باقى\"&\"\"&Data!T11-TODAY()&\" \"&\"يوم \",IF(Data!U11=\"\",\"تاخير\"&\" \"&TODAY()-Data!T11,\"\")))","v":"تاخير 211"},{"$f":"IF(Data!T11=\"\",\"\",IF(Data!V11>TODAY(),\" باقى\"&\"\"&Data!V11-TODAY()&\" \"&\"يوم \",IF(Data!W11=\"\",\"تاخير\"&\" \"&TODAY()-Data!V11,\"\")))","v":"تاخير 181"},{"$f":"IF(Data!V11=\"\",\"\",IF(Data!X11>TODAY(),\" باقى\"&\"\"&Data!X11-TODAY()&\" \"&\"يوم \",IF(Data!Y11=\"\",\"تاخير\"&\" \"&TODAY()-Data!X11,\"\")))","v":"تاخير 150"},{"$f":"IF(Data!X11=\"\",\"\",IF(Data!Z11>TODAY(),\" باقى\"&\"\"&Data!Z11-TODAY()&\" \"&\"يوم \",IF(Data!AA11=\"\",\"تاخير\"&\" \"&TODAY()-Data!Z11,\"\")))","v":"تاخير 120"},{"$f":"IF(Data!Z11=\"\",\"\",IF(Data!AB11>TODAY(),\" باقى\"&\"\"&Data!AB11-TODAY()&\" \"&\"يوم \",IF(Data!AC11=\"\",\"تاخير\"&\" \"&TODAY()-Data!AB11,\"\")))","v":"تاخير 89"}]

{"sheet":"بحث عن التنبيه","index":2,"n_rows":13,"n_cols":17,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["كود العميل","اسم العميل","رقم التليفون","قيمة القسط","عدد الاقساط","تنبيه القسط ال1  ","تنبيه القسط ال2","تنبيه القسط ال3","تنبيه القسط ال4","تنبيه القسط ال5","تنبيه القسط ال6","تنبيه القسط ال7","تنبيه القسط ال8","تنبيه القسط ال9","تنبيه القسط ال10","تنبيه القسط ال11","تنبيه القسط ال12"]
[50,{"$f":"VLOOKUP(A2,'تنبية بالاقساط'!A:O,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(B2,'تنبية بالاقساط'!B:O,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C2,'تنبية بالاقساط'!C:P,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(D2,'تنبية بالاقساط'!D:R,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(E2,'تنبية بالاقساط'!E:S,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(F2,'تنبية بالاقساط'!F:T,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(G2,'تنبية بالاقساط'!G:U,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(H2,'تنبية بالاقساط'!H:V,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(I2,'تنبية بالاقساط'!I:W,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(J2,'تنبية بالاقساط'!J:X,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(K2,'تنبية بالاقساط'!K:Y,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(L2,'تنبية بالاقساط'!L:Z,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(M2,'تنبية بالاقساط'!M:AA,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(N2,'تنبية بالاقساط'!N:AB,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(O2,'تنبية بالاقساط'!O:AC,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(P2,'تنبية بالاقساط'!P:AD,2,0)","v":{"$error":"#N/A"}}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"بمجرد اكتب كود العميل يظهر كل البيانات عن الاقساط بتاعته"]

{"sheet":"شاشة التنبيه","index":3,"n_rows":2,"n_cols":3,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
[]
[null,"تبليغي عندما يصل عدد الايام أقل من   :",30]

{"sheet":"1-1-2019","index":4,"n_rows":16,"n_cols":35,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["الواردات ","التاريخ ","بيان","البضاعة ","العدد","التاريخ ","القيمة ","متبقي قسط","قسط","بيان ","المقدم ","ك","ق","اجمالي ","نسبه","رقم التليفون ","التاريخ ","الاسم","اجمالي متبقي القسط ","المتبقي","قسط1","قسط 2","قسط 3","قسط 4","قسط 5","قسط 6","قسط 7","قسط 8","قسط 9","قسط 10","قسط 11","قسط 12","قسط 13","قسط 14","قسط 15"]
[null,"2019-01-01",null,"انفنكس هوت 6 برو ",1,"2019-01-03",2300,{"$f":"I2-K2","v":2250},{"$f":"G2+M2","v":2750},"احمد عثمان حسن علي ",500,225,450,{"$f":"L2+M2","v":675},{"$f":"(G2-K2)*0.25","v":450},"01142900862/01002130296","2019-01-03","احمد عثمان حسن ",{"$f":"H2","v":2250},{"$f":"S2-U2-V2-W2-X2-Y2-Z2-AA2-AB2-AC2-AD2-AE2-AF2-AG2-AH2-AI2","v":200},200,200,200,200,150,200,300,600]
[null,null,null,"y6",1,"2019-08-16",2300,{"$f":"I3-K3","v":2350},2800,"احمد عثمان حسن علي ",450,280,500,780,462.5,null,"2019-08-16","احمد عثمان حسن 2",{"$f":"H3","v":2350},{"$f":"S3-U3-V3-W3-X3-Y3-Z3-AA3-AB3-AC3-AD3-AE3-AF3-AG3-AH3-AI3","v":2100},250]
[null,null,null,"y 7",1,"2019-01-04",2900,{"$f":"I4-K4","v":2375},3375,"محمود فتحي حسن علي ",1000,300,475,775,475,1062556099,"2019-01-04","محمود فتحي حسن علي ",{"$f":"H4","v":2375},{"$f":"S4-U4-V4-W4-X4-Y4-Z4-AA4-AB4-AC4-AD4-AE4-AF4-AG4-AH4-AI4","v":125},250,250,250,250,250,300,700]
[null,null,null,"y9",1,"2019-05-04",4000,3950,4750,"محمود فتحي حسن علي ",800,500,750,1250,800,1062556099,"2019-05-04","محمود فتحي حسن علي 2",3950,2375,250,400,425,500]
[null,null,null,"a30",1,"2019-09-05",3400,3000,4000,"محمود فتحي حسن علي ",1000,400,600,1000,600,null,"2019-09-05","محمود فتحي حسن علي 3",3000,2150,400,450]
[null,null,null,"انفنكس مستعمل",1,"2019-08-16",1500,1875,1875,"ربيع سيد مستعمل ",0,450,375,825,375,null,"2019-08-16","ربيع سيد مستعمل  ",2000,700,100,200,200,400,400]
[null,null,null,"انفنكس سمارت 2",1,"2019-08-19",1400,1150,1650,"ربيع سيد  / صبري",500,100,250,350,225,null,"2019-08-19","ربيع سيد  / صبري",1150,0,200,200,200,400]
[null,null,null,"جراند برايم ",1,"2019-01-05",1700,1500,2000,"محمد عبد الحميد عبد النظور / عز عبد الحميد ",500,200,300,500,300,1066971345,"2019-01-05","محمد عبد الحميد عبد النظور / عز عبد الحميد ",1500,150,150,150,150,150,150,150,150,150,150]
[null,null,null,"انفنكس هوت 6 رام 1",1,"2019-01-05",1950,1825,2325,"فاطمه عبد المعز ",500,150,375,525,362.5,null,"2019-01-05","فاطمه عبد المعز ",1825,1015,180,360,270]
[null,null,null,"j 6 +",1,"2019-01-05",3200,2750,3750,"مروان سعد تبع عبيد ",1000,250,550,800,550,"تبع عبيد","2019-01-05","مروان سعد تبع عبيد ",2750,100,200,250,250,250,1200,500]
[null,null,null,"a20",1,"2019-07-15",2600,{"$f":"I12-K12","v":2500},{"$f":"G12+M12","v":3100},"عبد العزيز الخياط",600,400,500,900,500,1117560629,"2019-07-15","عبد العزيز الخياط",{"$f":"H12","v":2500},{"$f":"S12-U12-V12-W12-X12-Y12-Z12-AA12-AB12-AC12-AD12-AE12-AF12-AG12-AH12-AI12","v":1200},200,200,100,100,200,500]
[null,null,null,"a20",1,"2019-07-04",2400,2400,2900,"ابراهيم مصطفي عبد الفضيل ابراهيم / امين الشرطه",500,400,500,900,475,1003240573,"2019-07-04","ابراهيم مصطفي عبد الفضيل ابراهيم / امين الشرطه",2400,1600,400,400]
[null,null,null,"hot 7",1,"2019-07-03",2100,2000,2500,"ربيع صابر عبد الرحمن شعبان",500,270,400,670,400,1094274222,"2019-07-03","ربيع صابر عبد الرحمن شعبان",2000,800,200,200,200,200,200,200]
[null,null,null,"a10",1,"2019-07-03",2100,1800,2500,"سيد علي سيد اسماعيل",700,300,400,700,350,1021118054,"2019-07-03","سيد علي سيد اسماعيل دفع اول فسط يوم 8/27",1800,420,180,200,200,200,200,400]
[null,null,null,"hot 7",1,"2019-07-11",2100,2150,2550,"محمود شوقي احمد عبد الرحمن  شحنه ",400,270,450,720,425,null,"2019-07-11","محمود شوقي احمد عبد الرحمن  شحنه ",2150,1200,200,150,300,300]

{"sheet":"Sheet4","index":5,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}