{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Sheet1","Sheet2"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":4,"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":"Sheet1","index":0,"n_rows":43,"n_cols":31,"rows_kept":43,"cut":false,"hidden":false,"merged":[]}
[5]
[2022,null,null,{"$f":"TEXT(D3,\"[$-0809]ddd\")","v":"Sun"},{"$f":"TEXT(E3,\"[$-0809]ddd\")","v":"Mon"},"Tue","Wed","Thu","Sun","Mon","Tue","Wed","Thu","Sun","Mon","Tue","Wed","Thu","Sun","Mon","Tue","Wed","Thu","Sun","Mon","Tue"]
["الكود","اسم الطالب","الصف",{"$f":"IF(WORKDAY.INTL(DATE($A$2,$A$1,COLUMNS(A1))-1,COLUMN(A1),7,$AE$4:$AE$43)>EOMONTH(DATE($A$2,$A$1,COLUMNS(A1)),0),\"\",WORKDAY.INTL(DATE($A$2,$A$1,COLUMNS(A1))-1,COLUMN(A1),7,$AE$4:$AE$43))","v":"2022-05-01"},{"$f":"IF(WORKDAY.INTL(DATE($A$2,$A$1,COLUMNS(B1))-1,COLUMN(B1),7,$AE$4:$AE$43)>EOMONTH(DATE($A$2,$A$1,COLUMNS(B1)),0),\"\",WORKDAY.INTL(DATE($A$2,$A$1,COLUMNS(B1))-1,COLUMN(B1),7,$AE$4:$AE$43))","v":"2022-05-02"},{"$f":"IF(WORKDAY.INTL(DATE($A$2,$A$1,COLUMNS(C1))-1,COLUMN(C1),7,$AE$4:$AE$43)>EOMONTH(DATE($A$2,$A$1,COLUMNS(C1)),0),\"\",WORKDAY.INTL(DATE($A$2,$A$1,COLUMNS(C1))-1,COLUMN(C1),7,$AE$4:$AE$43))","v":"2022-05-03"},{"$f":"IF(WORKDAY.INTL(DATE($A$2,$A$1,COLUMNS(D1))-1,COLUMN(D1),7,$AE$4:$AE$43)>EOMONTH(DATE($A$2,$A$1,COLUMNS(D1)),0),\"\",WORKDAY.INTL(DATE($A$2,$A$1,COLUMNS(D1))-1,COLUMN(D1),7,$AE$4:$AE$43))","v":"2022-05-04"},{"$f":"IF(WORKDAY.INTL(DATE($A$2,$A$1,COLUMNS(E1))-1,COLUMN(E1),7,$AE$4:$AE$43)>EOMONTH(DATE($A$2,$A$1,COLUMNS(E1)),0),\"\",WORKDAY.INTL(DATE($A$2,$A$1,COLUMNS(E1))-1,COLUMN(E1),7,$AE$4:$AE$43))","v":"2022-05-05"},{"$f":"IF(WORKDAY.INTL(DATE($A$2,$A$1,COLUMNS(F1))-1,COLUMN(F1),7,$AE$4:$AE$43)>EOMONTH(DATE($A$2,$A$1,COLUMNS(F1)),0),\"\",WORKDAY.INTL(DATE($A$2,$A$1,COLUMNS(F1))-1,COLUMN(F1),7,$AE$4:$AE$43))","v":"2022-05-08"},{"$f":"IF(WORKDAY.INTL(DATE($A$2,$A$1,COLUMNS(G1))-1,COLUMN(G1),7,$AE$4:$AE$43)>EOMONTH(DATE($A$2,$A$1,COLUMNS(G1)),0),\"\",WORKDAY.INTL(DATE($A$2,$A$1,COLUMNS(G1))-1,COLUMN(G1),7,$AE$4:$AE$43))","v":"2022-05-09"},{"$f":"IF(WORKDAY.INTL(DATE($A$2,$A$1,COLUMNS(H1))-1,COLUMN(H1),7,$AE$4:$AE$43)>EOMONTH(DATE($A$2,$A$1,COLUMNS(H1)),0),\"\",WORKDAY.INTL(DATE($A$2,$A$1,COLUMNS(H1))-1,COLUMN(H1),7,$AE$4:$AE$43))","v":"2022-05-10"},{"$f":"IF(WORKDAY.INTL(DATE($A$2,$A$1,COLUMNS(I1))-1,COLUMN(I1),7,$AE$4:$AE$43)>EOMONTH(DATE($A$2,$A$1,COLUMNS(I1)),0),\"\",WORKDAY.INTL(DATE($A$2,$A$1,COLUMNS(I1))-1,COLUMN(I1),7,$AE$4:$AE$43))","v":"2022-05-11"},{"$f":"IF(WORKDAY.INTL(DATE($A$2,$A$1,COLUMNS(J1))-1,COLUMN(J1),7,$AE$4:$AE$43)>EOMONTH(DATE($A$2,$A$1,COLUMNS(J1)),0),\"\",WORKDAY.INTL(DATE($A$2,$A$1,COLUMNS(J1))-1,COLUMN(J1),7,$AE$4:$AE$43))","v":"2022-05-12"},{"$f":"IF(WORKDAY.INTL(DATE($A$2,$A$1,COLUMNS(K1))-1,COLUMN(K1),7,$AE$4:$AE$43)>EOMONTH(DATE($A$2,$A$1,COLUMNS(K1)),0),\"\",WORKDAY.INTL(DATE($A$2,$A$1,COLUMNS(K1))-1,COLUMN(K1),7,$AE$4:$AE$43))","v":"2022-05-15"},{"$f":"IF(WORKDAY.INTL(DATE($A$2,$A$1,COLUMNS(L1))-1,COLUMN(L1),7,$AE$4:$AE$43)>EOMONTH(DATE($A$2,$A$1,COLUMNS(L1)),0),\"\",WORKDAY.INTL(DATE($A$2,$A$1,COLUMNS(L1))-1,COLUMN(L1),7,$AE$4:$AE$43))","v":"2022-05-16"},{"$f":"IF(WORKDAY.INTL(DATE($A$2,$A$1,COLUMNS(M1))-1,COLUMN(M1),7,$AE$4:$AE$43)>EOMONTH(DATE($A$2,$A$1,COLUMNS(M1)),0),\"\",WORKDAY.INTL(DATE($A$2,$A$1,COLUMNS(M1))-1,COLUMN(M1),7,$AE$4:$AE$43))","v":"2022-05-17"},{"$f":"IF(WORKDAY.INTL(DATE($A$2,$A$1,COLUMNS(N1))-1,COLUMN(N1),7,$AE$4:$AE$43)>EOMONTH(DATE($A$2,$A$1,COLUMNS(N1)),0),\"\",WORKDAY.INTL(DATE($A$2,$A$1,COLUMNS(N1))-1,COLUMN(N1),7,$AE$4:$AE$43))","v":"2022-05-18"},{"$f":"IF(WORKDAY.INTL(DATE($A$2,$A$1,COLUMNS(O1))-1,COLUMN(O1),7,$AE$4:$AE$43)>EOMONTH(DATE($A$2,$A$1,COLUMNS(O1)),0),\"\",WORKDAY.INTL(DATE($A$2,$A$1,COLUMNS(O1))-1,COLUMN(O1),7,$AE$4:$AE$43))","v":"2022-05-19"},{"$f":"IF(WORKDAY.INTL(DATE($A$2,$A$1,COLUMNS(P1))-1,COLUMN(P1),7,$AE$4:$AE$43)>EOMONTH(DATE($A$2,$A$1,COLUMNS(P1)),0),\"\",WORKDAY.INTL(DATE($A$2,$A$1,COLUMNS(P1))-1,COLUMN(P1),7,$AE$4:$AE$43))","v":"2022-05-22"},{"$f":"IF(WORKDAY.INTL(DATE($A$2,$A$1,COLUMNS(Q1))-1,COLUMN(Q1),7,$AE$4:$AE$43)>EOMONTH(DATE($A$2,$A$1,COLUMNS(Q1)),0),\"\",WORKDAY.INTL(DATE($A$2,$A$1,COLUMNS(Q1))-1,COLUMN(Q1),7,$AE$4:$AE$43))","v":"2022-05-23"},{"$f":"IF(WORKDAY.INTL(DATE($A$2,$A$1,COLUMNS(R1))-1,COLUMN(R1),7,$AE$4:$AE$43)>EOMONTH(DATE($A$2,$A$1,COLUMNS(R1)),0),\"\",WORKDAY.INTL(DATE($A$2,$A$1,COLUMNS(R1))-1,COLUMN(R1),7,$AE$4:$AE$43))","v":"2022-05-24"},{"$f":"IF(WORKDAY.INTL(DATE($A$2,$A$1,COLUMNS(S1))-1,COLUMN(S1),7,$AE$4:$AE$43)>EOMONTH(DATE($A$2,$A$1,COLUMNS(S1)),0),\"\",WORKDAY.INTL(DATE($A$2,$A$1,COLUMNS(S1))-1,COLUMN(S1),7,$AE$4:$AE$43))","v":"2022-05-25"},{"$f":"IF(WORKDAY.INTL(DATE($A$2,$A$1,COLUMNS(T1))-1,COLUMN(T1),7,$AE$4:$AE$43)>EOMONTH(DATE($A$2,$A$1,COLUMNS(T1)),0),\"\",WORKDAY.INTL(DATE($A$2,$A$1,COLUMNS(T1))-1,COLUMN(T1),7,$AE$4:$AE$43))","v":"2022-05-26"},{"$f":"IF(WORKDAY.INTL(DATE($A$2,$A$1,COLUMNS(U1))-1,COLUMN(U1),7,$AE$4:$AE$43)>EOMONTH(DATE($A$2,$A$1,COLUMNS(U1)),0),\"\",WORKDAY.INTL(DATE($A$2,$A$1,COLUMNS(U1))-1,COLUMN(U1),7,$AE$4:$AE$43))","v":"2022-05-29"},{"$f":"IF(WORKDAY.INTL(DATE($A$2,$A$1,COLUMNS(V1))-1,COLUMN(V1),7,$AE$4:$AE$43)>EOMONTH(DATE($A$2,$A$1,COLUMNS(V1)),0),\"\",WORKDAY.INTL(DATE($A$2,$A$1,COLUMNS(V1))-1,COLUMN(V1),7,$AE$4:$AE$43))","v":"2022-05-30"},{"$f":"IF(WORKDAY.INTL(DATE($A$2,$A$1,COLUMNS(W1))-1,COLUMN(W1),7,$AE$4:$AE$43)>EOMONTH(DATE($A$2,$A$1,COLUMNS(W1)),0),\"\",WORKDAY.INTL(DATE($A$2,$A$1,COLUMNS(W1))-1,COLUMN(W1),7,$AE$4:$AE$43))","v":"2022-05-31"},"عدد الغياب",null,null,null,"الإجازات"]
[1,"محمد1","10\\1","غ",null,"غ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"غ",null,null,{"$f":"COUNTIF(D4:Z4,\"غ\")","v":3},null,null,null,"2022-08-01"]
[2,"محمد2","10\\2",null,null,null,null,null,null,null,null,null,null,null,"غ",null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(D5:Z5,\"غ\")","v":1},null,null,null,"2022-08-02"]
[3,"محمد3","10\\3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,"2022-08-03"]
[4,"محمد4","10\\4",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,"2022-08-04"]
[5,"محمد5","10\\5",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,"2022-08-07"]
[6,"محمد6","10\\6",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,"2022-08-08"]
[7,"محمد7","10\\7",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,"2022-08-09"]
[8,"محمد8","10\\1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,"2022-08-10"]
[9,"محمد9","10\\2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,"2022-08-11"]
[10,"محمد10","10\\3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,"2022-11-20"]
[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,"2022-11-21"]
[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,"2022-11-22"]
[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,"2022-11-23"]
[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,"2022-11-24"]
[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,"2022-11-27"]
[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,"2022-11-28"]
[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,"2022-11-29"]
[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,"2022-11-30"]
[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,"2022-12-01"]
[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,"2022-12-04"]
[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,"2022-12-05"]
[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,"2022-12-06"]
[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,"2022-12-07"]
[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,"2022-12-08"]
[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,"2022-12-11"]
[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,"2022-12-12"]
[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,"2022-12-13"]
[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,"2022-12-14"]
[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,"2022-12-15"]
[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,"2022-12-18"]
[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,"2022-12-19"]
[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,"2022-12-20"]
[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,"2022-12-21"]
[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,"2022-12-22"]
[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,"2022-02-08"]
[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,"2023-03-12"]
[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,"2023-03-13"]
[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,"2023-03-14"]
[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,"2023-03-15"]
[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,"2023-03-16"]

{"sheet":"Sheet2","index":1,"n_rows":5,"n_cols":18,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["الكود","الاسم","القسم","التاريخ","نوع الإجازة",null,null,null,null,null,null,null,null,null,2,{"$f":"SMALL(IF(OFFSET(Date_1,Sheet2!$O$1,0)<>\"\",COLUMN(Date_1)),Sheet2!$O$2)-3","v":12},{"$f":"INDEX(Date_1,,$P$1)","v":44697},{"$f":"INDEX(OFFSET(Date_1,O1,0),,$P$1)","v":"غ"}]
[1,"محمد1","10\\1","2022-05-01","غ",null,null,null,null,null,null,null,null,null,1]
[1,"محمد1","10\\1","2022-05-03","غ"]
[1,"محمد1","10\\1","2022-05-29","غ"]
[2,"محمد2","10\\2","2022-05-16","غ"]