{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["keab","arhkeab","keabhosa","طباعة الغياب","غياب فردي"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":8,"defined_names":77,"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":"keab","index":0,"n_rows":9,"n_cols":33,"rows_kept":9,"cut":false,"hidden":false,"merged":[[2,38,3,38],[2,39,3,39],[2,40,3,40],[2,36,3,36],[1,21,1,22],[1,23,1,25],[1,37,1,40],[2,37,3,37],[2,1,3,1],[2,2,3,2],[2,3,3,3],[2,4,3,4],[1,16,1,17],[1,1,1,15]]}
[null,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,null,null,null,null,43831,43832,43833]
[null,"غياب شهر",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"mount(T2)","v":"يناير"},null,")",null,"(","لسنة",null,2020,null,null,1,"خيري الكموشي","م . مصنف","صباحية","غ","غ","غ"]
[null,"الرقم","اسم المعلم","الصفة","الفترة",{"$f":"IF(F4=\"\",\"\",INDEX({\"السبت\";\"الأحد\";\"الإثنين\";\"الثلاثاء\";\"الأربعاء\";\"الخميس\";\"الجمعة\"},WEEKDAY(F4,16)))","v":"الأربعاء"},{"$f":"IF(G4=\"\",\"\",INDEX({\"السبت\";\"الأحد\";\"الإثنين\";\"الثلاثاء\";\"الأربعاء\";\"الخميس\";\"الجمعة\"},WEEKDAY(G4,16)))","v":"الخميس"},{"$f":"IF(H4=\"\",\"\",INDEX({\"السبت\";\"الأحد\";\"الإثنين\";\"الثلاثاء\";\"الأربعاء\";\"الخميس\";\"الجمعة\"},WEEKDAY(H4,16)))","v":"الجمعة"},{"$f":"IF(I4=\"\",\"\",INDEX({\"السبت\";\"الأحد\";\"الإثنين\";\"الثلاثاء\";\"الأربعاء\";\"الخميس\";\"الجمعة\"},WEEKDAY(I4,16)))","v":"السبت"},{"$f":"IF(J4=\"\",\"\",INDEX({\"السبت\";\"الأحد\";\"الإثنين\";\"الثلاثاء\";\"الأربعاء\";\"الخميس\";\"الجمعة\"},WEEKDAY(J4,16)))","v":"الأحد"},{"$f":"IF(K4=\"\",\"\",INDEX({\"السبت\";\"الأحد\";\"الإثنين\";\"الثلاثاء\";\"الأربعاء\";\"الخميس\";\"الجمعة\"},WEEKDAY(K4,16)))","v":"الإثنين"},{"$f":"IF(L4=\"\",\"\",INDEX({\"السبت\";\"الأحد\";\"الإثنين\";\"الثلاثاء\";\"الأربعاء\";\"الخميس\";\"الجمعة\"},WEEKDAY(L4,16)))","v":"الثلاثاء"},{"$f":"IF(M4=\"\",\"\",INDEX({\"السبت\";\"الأحد\";\"الإثنين\";\"الثلاثاء\";\"الأربعاء\";\"الخميس\";\"الجمعة\"},WEEKDAY(M4,16)))","v":"الأربعاء"},{"$f":"IF(N4=\"\",\"\",INDEX({\"السبت\";\"الأحد\";\"الإثنين\";\"الثلاثاء\";\"الأربعاء\";\"الخميس\";\"الجمعة\"},WEEKDAY(N4,16)))","v":"الخميس"},{"$f":"IF(O4=\"\",\"\",INDEX({\"السبت\";\"الأحد\";\"الإثنين\";\"الثلاثاء\";\"الأربعاء\";\"الخميس\";\"الجمعة\"},WEEKDAY(O4,16)))","v":"الجمعة"},{"$f":"IF(P4=\"\",\"\",INDEX({\"السبت\";\"الأحد\";\"الإثنين\";\"الثلاثاء\";\"الأربعاء\";\"الخميس\";\"الجمعة\"},WEEKDAY(P4,16)))","v":"السبت"},{"$f":"IF(Q4=\"\",\"\",INDEX({\"السبت\";\"الأحد\";\"الإثنين\";\"الثلاثاء\";\"الأربعاء\";\"الخميس\";\"الجمعة\"},WEEKDAY(Q4,16)))","v":"الأحد"},{"$f":"IF(R4=\"\",\"\",INDEX({\"السبت\";\"الأحد\";\"الإثنين\";\"الثلاثاء\";\"الأربعاء\";\"الخميس\";\"الجمعة\"},WEEKDAY(R4,16)))","v":"الإثنين"},{"$f":"IF(S4=\"\",\"\",INDEX({\"السبت\";\"الأحد\";\"الإثنين\";\"الثلاثاء\";\"الأربعاء\";\"الخميس\";\"الجمعة\"},WEEKDAY(S4,16)))","v":"الثلاثاء"},{"$f":"IF(T4=\"\",\"\",INDEX({\"السبت\";\"الأحد\";\"الإثنين\";\"الثلاثاء\";\"الأربعاء\";\"الخميس\";\"الجمعة\"},WEEKDAY(T4,16)))","v":"الأربعاء"},{"$f":"IF(U4=\"\",\"\",INDEX({\"السبت\";\"الأحد\";\"الإثنين\";\"الثلاثاء\";\"الأربعاء\";\"الخميس\";\"الجمعة\"},WEEKDAY(U4,16)))","v":"الخميس"},{"$f":"IF(V4=\"\",\"\",INDEX({\"السبت\";\"الأحد\";\"الإثنين\";\"الثلاثاء\";\"الأربعاء\";\"الخميس\";\"الجمعة\"},WEEKDAY(V4,16)))","v":"الجمعة"},{"$f":"IF(W4=\"\",\"\",INDEX({\"السبت\";\"الأحد\";\"الإثنين\";\"الثلاثاء\";\"الأربعاء\";\"الخميس\";\"الجمعة\"},WEEKDAY(W4,16)))","v":"السبت"},{"$f":"IF(X4=\"\",\"\",INDEX({\"السبت\";\"الأحد\";\"الإثنين\";\"الثلاثاء\";\"الأربعاء\";\"الخميس\";\"الجمعة\"},WEEKDAY(X4,16)))","v":"الأحد"},{"$f":"IF(Y4=\"\",\"\",INDEX({\"السبت\";\"الأحد\";\"الإثنين\";\"الثلاثاء\";\"الأربعاء\";\"الخميس\";\"الجمعة\"},WEEKDAY(Y4,16)))","v":"الإثنين"},{"$f":"IF(Z4=\"\",\"\",INDEX({\"السبت\";\"الأحد\";\"الإثنين\";\"الثلاثاء\";\"الأربعاء\";\"الخميس\";\"الجمعة\"},WEEKDAY(Z4,16)))","v":"الثلاثاء"}]
[null,null,null,null,null,{"$f":"IF(COLUMNS($E$1:E1)>DAY(DATE($X$2,INDEX(ROW($A$1:$A$12),MATCH($Q$2,{\"يناير\";\"فبراير\";\"مارس\";\"أبريل\";\"مايو\";\"يونيو\";\"يوليو\";\"أغسطس\";\"سبتمبر\";\"أكتوبر\";\"نوفمبر\";\"ديسمبر\"},0)),COLUMNS($E$1:E1))),\"\",DATE($X$2,INDEX(ROW($A$1:$A$12),MATCH($Q$2,{\"يناير\";\"فبراير\";\"مارس\";\"أبريل\";\"مايو\";\"يونيو\";\"يوليو\";\"أغسطس\";\"سبتمبر\";\"أكتوبر\";\"نوفمبر\";\"ديسمبر\"},0)),COLUMNS($E$1:E1)))","v":"2020-01-01"},{"$f":"IF(COLUMNS($E$1:F1)>DAY(DATE($X$2,INDEX(ROW($A$1:$A$12),MATCH($Q$2,{\"يناير\";\"فبراير\";\"مارس\";\"أبريل\";\"مايو\";\"يونيو\";\"يوليو\";\"أغسطس\";\"سبتمبر\";\"أكتوبر\";\"نوفمبر\";\"ديسمبر\"},0)),COLUMNS($E$1:F1))),\"\",DATE($X$2,INDEX(ROW($A$1:$A$12),MATCH($Q$2,{\"يناير\";\"فبراير\";\"مارس\";\"أبريل\";\"مايو\";\"يونيو\";\"يوليو\";\"أغسطس\";\"سبتمبر\";\"أكتوبر\";\"نوفمبر\";\"ديسمبر\"},0)),COLUMNS($E$1:F1)))","v":"2020-01-02"},{"$f":"IF(COLUMNS($E$1:G1)>DAY(DATE($X$2,INDEX(ROW($A$1:$A$12),MATCH($Q$2,{\"يناير\";\"فبراير\";\"مارس\";\"أبريل\";\"مايو\";\"يونيو\";\"يوليو\";\"أغسطس\";\"سبتمبر\";\"أكتوبر\";\"نوفمبر\";\"ديسمبر\"},0)),COLUMNS($E$1:G1))),\"\",DATE($X$2,INDEX(ROW($A$1:$A$12),MATCH($Q$2,{\"يناير\";\"فبراير\";\"مارس\";\"أبريل\";\"مايو\";\"يونيو\";\"يوليو\";\"أغسطس\";\"سبتمبر\";\"أكتوبر\";\"نوفمبر\";\"ديسمبر\"},0)),COLUMNS($E$1:G1)))","v":"2020-01-03"},{"$f":"IF(COLUMNS($E$1:H1)>DAY(DATE($X$2,INDEX(ROW($A$1:$A$12),MATCH($Q$2,{\"يناير\";\"فبراير\";\"مارس\";\"أبريل\";\"مايو\";\"يونيو\";\"يوليو\";\"أغسطس\";\"سبتمبر\";\"أكتوبر\";\"نوفمبر\";\"ديسمبر\"},0)),COLUMNS($E$1:H1))),\"\",DATE($X$2,INDEX(ROW($A$1:$A$12),MATCH($Q$2,{\"يناير\";\"فبراير\";\"مارس\";\"أبريل\";\"مايو\";\"يونيو\";\"يوليو\";\"أغسطس\";\"سبتمبر\";\"أكتوبر\";\"نوفمبر\";\"ديسمبر\"},0)),COLUMNS($E$1:H1)))","v":"2020-01-04"},{"$f":"IF(COLUMNS($E$1:I1)>DAY(DATE($X$2,INDEX(ROW($A$1:$A$12),MATCH($Q$2,{\"يناير\";\"فبراير\";\"مارس\";\"أبريل\";\"مايو\";\"يونيو\";\"يوليو\";\"أغسطس\";\"سبتمبر\";\"أكتوبر\";\"نوفمبر\";\"ديسمبر\"},0)),COLUMNS($E$1:I1))),\"\",DATE($X$2,INDEX(ROW($A$1:$A$12),MATCH($Q$2,{\"يناير\";\"فبراير\";\"مارس\";\"أبريل\";\"مايو\";\"يونيو\";\"يوليو\";\"أغسطس\";\"سبتمبر\";\"أكتوبر\";\"نوفمبر\";\"ديسمبر\"},0)),COLUMNS($E$1:I1)))","v":"2020-01-05"},{"$f":"IF(COLUMNS($E$1:J1)>DAY(DATE($X$2,INDEX(ROW($A$1:$A$12),MATCH($Q$2,{\"يناير\";\"فبراير\";\"مارس\";\"أبريل\";\"مايو\";\"يونيو\";\"يوليو\";\"أغسطس\";\"سبتمبر\";\"أكتوبر\";\"نوفمبر\";\"ديسمبر\"},0)),COLUMNS($E$1:J1))),\"\",DATE($X$2,INDEX(ROW($A$1:$A$12),MATCH($Q$2,{\"يناير\";\"فبراير\";\"مارس\";\"أبريل\";\"مايو\";\"يونيو\";\"يوليو\";\"أغسطس\";\"سبتمبر\";\"أكتوبر\";\"نوفمبر\";\"ديسمبر\"},0)),COLUMNS($E$1:J1)))","v":"2020-01-06"},{"$f":"IF(COLUMNS($E$1:K1)>DAY(DATE($X$2,INDEX(ROW($A$1:$A$12),MATCH($Q$2,{\"يناير\";\"فبراير\";\"مارس\";\"أبريل\";\"مايو\";\"يونيو\";\"يوليو\";\"أغسطس\";\"سبتمبر\";\"أكتوبر\";\"نوفمبر\";\"ديسمبر\"},0)),COLUMNS($E$1:K1))),\"\",DATE($X$2,INDEX(ROW($A$1:$A$12),MATCH($Q$2,{\"يناير\";\"فبراير\";\"مارس\";\"أبريل\";\"مايو\";\"يونيو\";\"يوليو\";\"أغسطس\";\"سبتمبر\";\"أكتوبر\";\"نوفمبر\";\"ديسمبر\"},0)),COLUMNS($E$1:K1)))","v":"2020-01-07"},{"$f":"IF(COLUMNS($E$1:L1)>DAY(DATE($X$2,INDEX(ROW($A$1:$A$12),MATCH($Q$2,{\"يناير\";\"فبراير\";\"مارس\";\"أبريل\";\"مايو\";\"يونيو\";\"يوليو\";\"أغسطس\";\"سبتمبر\";\"أكتوبر\";\"نوفمبر\";\"ديسمبر\"},0)),COLUMNS($E$1:L1))),\"\",DATE($X$2,INDEX(ROW($A$1:$A$12),MATCH($Q$2,{\"يناير\";\"فبراير\";\"مارس\";\"أبريل\";\"مايو\";\"يونيو\";\"يوليو\";\"أغسطس\";\"سبتمبر\";\"أكتوبر\";\"نوفمبر\";\"ديسمبر\"},0)),COLUMNS($E$1:L1)))","v":"2020-01-08"},{"$f":"IF(COLUMNS($E$1:M1)>DAY(DATE($X$2,INDEX(ROW($A$1:$A$12),MATCH($Q$2,{\"يناير\";\"فبراير\";\"مارس\";\"أبريل\";\"مايو\";\"يونيو\";\"يوليو\";\"أغسطس\";\"سبتمبر\";\"أكتوبر\";\"نوفمبر\";\"ديسمبر\"},0)),COLUMNS($E$1:M1))),\"\",DATE($X$2,INDEX(ROW($A$1:$A$12),MATCH($Q$2,{\"يناير\";\"فبراير\";\"مارس\";\"أبريل\";\"مايو\";\"يونيو\";\"يوليو\";\"أغسطس\";\"سبتمبر\";\"أكتوبر\";\"نوفمبر\";\"ديسمبر\"},0)),COLUMNS($E$1:M1)))","v":"2020-01-09"},{"$f":"IF(COLUMNS($E$1:N1)>DAY(DATE($X$2,INDEX(ROW($A$1:$A$12),MATCH($Q$2,{\"يناير\";\"فبراير\";\"مارس\";\"أبريل\";\"مايو\";\"يونيو\";\"يوليو\";\"أغسطس\";\"سبتمبر\";\"أكتوبر\";\"نوفمبر\";\"ديسمبر\"},0)),COLUMNS($E$1:N1))),\"\",DATE($X$2,INDEX(ROW($A$1:$A$12),MATCH($Q$2,{\"يناير\";\"فبراير\";\"مارس\";\"أبريل\";\"مايو\";\"يونيو\";\"يوليو\";\"أغسطس\";\"سبتمبر\";\"أكتوبر\";\"نوفمبر\";\"ديسمبر\"},0)),COLUMNS($E$1:N1)))","v":"2020-01-10"},{"$f":"IF(COLUMNS($E$1:O1)>DAY(DATE($X$2,INDEX(ROW($A$1:$A$12),MATCH($Q$2,{\"يناير\";\"فبراير\";\"مارس\";\"أبريل\";\"مايو\";\"يونيو\";\"يوليو\";\"أغسطس\";\"سبتمبر\";\"أكتوبر\";\"نوفمبر\";\"ديسمبر\"},0)),COLUMNS($E$1:O1))),\"\",DATE($X$2,INDEX(ROW($A$1:$A$12),MATCH($Q$2,{\"يناير\";\"فبراير\";\"مارس\";\"أبريل\";\"مايو\";\"يونيو\";\"يوليو\";\"أغسطس\";\"سبتمبر\";\"أكتوبر\";\"نوفمبر\";\"ديسمبر\"},0)),COLUMNS($E$1:O1)))","v":"2020-01-11"},{"$f":"IF(COLUMNS($E$1:P1)>DAY(DATE($X$2,INDEX(ROW($A$1:$A$12),MATCH($Q$2,{\"يناير\";\"فبراير\";\"مارس\";\"أبريل\";\"مايو\";\"يونيو\";\"يوليو\";\"أغسطس\";\"سبتمبر\";\"أكتوبر\";\"نوفمبر\";\"ديسمبر\"},0)),COLUMNS($E$1:P1))),\"\",DATE($X$2,INDEX(ROW($A$1:$A$12),MATCH($Q$2,{\"يناير\";\"فبراير\";\"مارس\";\"أبريل\";\"مايو\";\"يونيو\";\"يوليو\";\"أغسطس\";\"سبتمبر\";\"أكتوبر\";\"نوفمبر\";\"ديسمبر\"},0)),COLUMNS($E$1:P1)))","v":"2020-01-12"},{"$f":"IF(COLUMNS($E$1:Q1)>DAY(DATE($X$2,INDEX(ROW($A$1:$A$12),MATCH($Q$2,{\"يناير\";\"فبراير\";\"مارس\";\"أبريل\";\"مايو\";\"يونيو\";\"يوليو\";\"أغسطس\";\"سبتمبر\";\"أكتوبر\";\"نوفمبر\";\"ديسمبر\"},0)),COLUMNS($E$1:Q1))),\"\",DATE($X$2,INDEX(ROW($A$1:$A$12),MATCH($Q$2,{\"يناير\";\"فبراير\";\"مارس\";\"أبريل\";\"مايو\";\"يونيو\";\"يوليو\";\"أغسطس\";\"سبتمبر\";\"أكتوبر\";\"نوفمبر\";\"ديسمبر\"},0)),COLUMNS($E$1:Q1)))","v":"2020-01-13"},{"$f":"IF(COLUMNS($E$1:R1)>DAY(DATE($X$2,INDEX(ROW($A$1:$A$12),MATCH($Q$2,{\"يناير\";\"فبراير\";\"مارس\";\"أبريل\";\"مايو\";\"يونيو\";\"يوليو\";\"أغسطس\";\"سبتمبر\";\"أكتوبر\";\"نوفمبر\";\"ديسمبر\"},0)),COLUMNS($E$1:R1))),\"\",DATE($X$2,INDEX(ROW($A$1:$A$12),MATCH($Q$2,{\"يناير\";\"فبراير\";\"مارس\";\"أبريل\";\"مايو\";\"يونيو\";\"يوليو\";\"أغسطس\";\"سبتمبر\";\"أكتوبر\";\"نوفمبر\";\"ديسمبر\"},0)),COLUMNS($E$1:R1)))","v":"2020-01-14"},{"$f":"IF(COLUMNS($E$1:S1)>DAY(DATE($X$2,INDEX(ROW($A$1:$A$12),MATCH($Q$2,{\"يناير\";\"فبراير\";\"مارس\";\"أبريل\";\"مايو\";\"يونيو\";\"يوليو\";\"أغسطس\";\"سبتمبر\";\"أكتوبر\";\"نوفمبر\";\"ديسمبر\"},0)),COLUMNS($E$1:S1))),\"\",DATE($X$2,INDEX(ROW($A$1:$A$12),MATCH($Q$2,{\"يناير\";\"فبراير\";\"مارس\";\"أبريل\";\"مايو\";\"يونيو\";\"يوليو\";\"أغسطس\";\"سبتمبر\";\"أكتوبر\";\"نوفمبر\";\"ديسمبر\"},0)),COLUMNS($E$1:S1)))","v":"2020-01-15"},{"$f":"IF(COLUMNS($E$1:T1)>DAY(DATE($X$2,INDEX(ROW($A$1:$A$12),MATCH($Q$2,{\"يناير\";\"فبراير\";\"مارس\";\"أبريل\";\"مايو\";\"يونيو\";\"يوليو\";\"أغسطس\";\"سبتمبر\";\"أكتوبر\";\"نوفمبر\";\"ديسمبر\"},0)),COLUMNS($E$1:T1))),\"\",DATE($X$2,INDEX(ROW($A$1:$A$12),MATCH($Q$2,{\"يناير\";\"فبراير\";\"مارس\";\"أبريل\";\"مايو\";\"يونيو\";\"يوليو\";\"أغسطس\";\"سبتمبر\";\"أكتوبر\";\"نوفمبر\";\"ديسمبر\"},0)),COLUMNS($E$1:T1)))","v":"2020-01-16"},{"$f":"IF(COLUMNS($E$1:U1)>DAY(DATE($X$2,INDEX(ROW($A$1:$A$12),MATCH($Q$2,{\"يناير\";\"فبراير\";\"مارس\";\"أبريل\";\"مايو\";\"يونيو\";\"يوليو\";\"أغسطس\";\"سبتمبر\";\"أكتوبر\";\"نوفمبر\";\"ديسمبر\"},0)),COLUMNS($E$1:U1))),\"\",DATE($X$2,INDEX(ROW($A$1:$A$12),MATCH($Q$2,{\"يناير\";\"فبراير\";\"مارس\";\"أبريل\";\"مايو\";\"يونيو\";\"يوليو\";\"أغسطس\";\"سبتمبر\";\"أكتوبر\";\"نوفمبر\";\"ديسمبر\"},0)),COLUMNS($E$1:U1)))","v":"2020-01-17"},{"$f":"IF(COLUMNS($E$1:V1)>DAY(DATE($X$2,INDEX(ROW($A$1:$A$12),MATCH($Q$2,{\"يناير\";\"فبراير\";\"مارس\";\"أبريل\";\"مايو\";\"يونيو\";\"يوليو\";\"أغسطس\";\"سبتمبر\";\"أكتوبر\";\"نوفمبر\";\"ديسمبر\"},0)),COLUMNS($E$1:V1))),\"\",DATE($X$2,INDEX(ROW($A$1:$A$12),MATCH($Q$2,{\"يناير\";\"فبراير\";\"مارس\";\"أبريل\";\"مايو\";\"يونيو\";\"يوليو\";\"أغسطس\";\"سبتمبر\";\"أكتوبر\";\"نوفمبر\";\"ديسمبر\"},0)),COLUMNS($E$1:V1)))","v":"2020-01-18"},{"$f":"IF(COLUMNS($E$1:W1)>DAY(DATE($X$2,INDEX(ROW($A$1:$A$12),MATCH($Q$2,{\"يناير\";\"فبراير\";\"مارس\";\"أبريل\";\"مايو\";\"يونيو\";\"يوليو\";\"أغسطس\";\"سبتمبر\";\"أكتوبر\";\"نوفمبر\";\"ديسمبر\"},0)),COLUMNS($E$1:W1))),\"\",DATE($X$2,INDEX(ROW($A$1:$A$12),MATCH($Q$2,{\"يناير\";\"فبراير\";\"مارس\";\"أبريل\";\"مايو\";\"يونيو\";\"يوليو\";\"أغسطس\";\"سبتمبر\";\"أكتوبر\";\"نوفمبر\";\"ديسمبر\"},0)),COLUMNS($E$1:W1)))","v":"2020-01-19"},{"$f":"IF(COLUMNS($E$1:X1)>DAY(DATE($X$2,INDEX(ROW($A$1:$A$12),MATCH($Q$2,{\"يناير\";\"فبراير\";\"مارس\";\"أبريل\";\"مايو\";\"يونيو\";\"يوليو\";\"أغسطس\";\"سبتمبر\";\"أكتوبر\";\"نوفمبر\";\"ديسمبر\"},0)),COLUMNS($E$1:X1))),\"\",DATE($X$2,INDEX(ROW($A$1:$A$12),MATCH($Q$2,{\"يناير\";\"فبراير\";\"مارس\";\"أبريل\";\"مايو\";\"يونيو\";\"يوليو\";\"أغسطس\";\"سبتمبر\";\"أكتوبر\";\"نوفمبر\";\"ديسمبر\"},0)),COLUMNS($E$1:X1)))","v":"2020-01-20"},{"$f":"IF(COLUMNS($E$1:Y1)>DAY(DATE($X$2,INDEX(ROW($A$1:$A$12),MATCH($Q$2,{\"يناير\";\"فبراير\";\"مارس\";\"أبريل\";\"مايو\";\"يونيو\";\"يوليو\";\"أغسطس\";\"سبتمبر\";\"أكتوبر\";\"نوفمبر\";\"ديسمبر\"},0)),COLUMNS($E$1:Y1))),\"\",DATE($X$2,INDEX(ROW($A$1:$A$12),MATCH($Q$2,{\"يناير\";\"فبراير\";\"مارس\";\"أبريل\";\"مايو\";\"يونيو\";\"يوليو\";\"أغسطس\";\"سبتمبر\";\"أكتوبر\";\"نوفمبر\";\"ديسمبر\"},0)),COLUMNS($E$1:Y1)))","v":"2020-01-21"},"1900-01-03","ابراهيم الصيد المصروب العموري","م . مصنف","صباحية","غ"]
[null,1,"خيري الكموشي","م . مصنف","صباحية","غ","غ","غ",null,"غ",null,"غ",null,"غ",null,null,null,null,null,null,null,null,null,null,null,null,4,"ابراهيم عبدالله علي الراجحي","م . مصنف","مسائية","غ","غ"]
[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,4,"خيري الكموشي",null,null,"غ","غ"]
[null,3,"ابراهيم الصيد المصروب العموري","م . مصنف","صباحية","غ",null,null,null,null,null,null,null,null,null,null,null,"غ","غ"]
[null,4,"ابراهيم عبدالله علي الراجحي","م . مصنف","مسائية","غ","غ"]
[null,4,"خيري الكموشي",null,null,"غ","غ",null,"غ"]

{"sheet":"arhkeab","index":1,"n_rows":12,"n_cols":8,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,7]]}
[]
[null,"أرشيف الغياب"]
[]
[null,"الرقم","الاسم","أيام الغايب","عدد أيام الغياب بالحروف","عدد أيام الغياب","شهر الغياب","السنة"]
[null,1,"خيري علي الكموشي","17 -14 ","يومـــــان",2,1,2018]
[null,2,"ابراهيم الصيد المصروب","29 -18 -9 -2 -1 ","خمسة أيام",5,1,2018]
[null,3,"سالم الفيتوري محمد العبدلي","17 -9 ","يومـــــان",2,1,2018]
[null,4,"خالد محمد الكموشي","25 ","يوم واحد",1,1,2018]
[null,5,"فرج محمد محمد","18 -17 -11 -10 ","أربعة أيام",4,1,2018]
[null,6,"عبداللطيف عبدالكريم ابوالعيد ميلاد","31 -18 -17 -11 ","أربعة أيام",4,1,2018]
[null,7,"محمد سالم مالك","30 -25 -24 -23 -18 -11 ","ستة أيام",6,1,2018]
[null,8,"طارق على محسن","28 -21 -18 -8 -7 ","خمسة أيام",5,1,2018]

{"sheet":"keabhosa","index":2,"n_rows":730,"n_cols":8,"rows_kept":730,"cut":false,"hidden":false,"merged":[[1,1,1,7]]}
[1303]
[null,"غيـــــاب الحصـــــص"]
[1,2,3,4,7,8,9]
[null,"الرقم","اسم المعلم","أيام الغياب",null,"شهر الغياب","السنة","العداد"]
[null,1,"خيري علي الكموشي","17 -14 ",2,11,2019,{"$f":"F5+G5*12","v":24239}]
[null,2,"ابراهيم الصيد المصروب","29 -18 -9 -2 -1 ",5,11,2019,{"$f":"F6+G6*12","v":24239}]
[null,3,"سالم الفيتوري محمد العبدلي","17 -9 ",2,11,2019,24239]
[null,4,"خالد محمد الكموشي","25 ",1,11,2019,24239]
[null,5,"فرج محمد محمد","18 -17 -11 -10 ",4,11,2019,24239]
[null,6,"عبداللطيف عبدالكريم ","31 -18 -17 -11 ",4,11,2019,24239]
[null,7,"محمد سالم مالك","30 -25 -24 -23 -18 -11 ",6,11,2019,24239]
[null,8,"طارق على محسن","28 -21 -18 -8 -7 ",5,11,2019,24239]
[null,1,"خيري علي الكموشي","17 -14 ",2,12,2019,24240]
[null,2,"ابراهيم الصيد المصروب","29 -18 -9 -2 -1 ",5,12,2019,24240]
[null,3,"سالم الفيتوري محمد العبدلي","17 -9 ",2,12,2019,24240]
[null,4,"خالد محمد الكموشي","25 ",1,12,2019,24240]
[null,5,"فرج محمد محمد","18 -17 -11 -10 ",4,12,2019,24240]
[null,6,"عبداللطيف عبدالكريم ","31 -18 -17 -11 ",4,12,2019,24240]
[null,7,"محمد سالم مالك","30 -25 -24 -23 -18 -11 ",6,12,2019,24240]
[null,8,"طارق على محسن","28 -21 -18 -8 -7 ",5,12,2019,24240]
[null,null,"خيري علي الكموشي","17 -14 ",2,1,2020,24241]
[null,null,"ابراهيم الصيد المصروب","29 -18 -9 -2 -1 ",5,1,2020,24241]
[null,null,"سالم الفيتوري محمد العبدلي","17 -9 ",2,1,2020,24241]
[null,null,"خالد محمد الكموشي","25 ",1,1,2020,24241]
[null,null,"فرج محمد محمد","18 -17 -11 -10 ",4,1,2020,24241]
[null,null,"عبداللطيف عبدالكريم ","31 -18 -17 -11 ",4,1,2020,24241]
[null,null,"محمد سالم مالك","30 -25 -24 -23 -18 -11 ",6,1,2020,24241]
[null,null,"طارق على محسن","28 -21 -18 -8 -7 ",5,1,2020,24241]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"",null,"",null,null,{"$f":"E725+F725*12","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]

{"sheet":"طباعة الغياب","index":3,"n_rows":26,"n_cols":13,"rows_kept":26,"cut":false,"hidden":false,"merged":[[25,3,25,5],[25,1,25,2],[23,6,23,7],[22,8,22,9],[23,8,23,9],[25,8,25,9],[25,6,25,7],[23,3,23,5],[22,1,22,2],[23,1,23,2],[2,1,2,9],[4,1,4,9],[3,1,3,9],[1,1,1,9],[0,1,0,9]]}
[null,"دولــــــــــــــــــــة ليبيا"]
[null,"وزارة التعلـــيم"]
[]
[null,"مدرسة: .............................."]
[null,"كشف غياب بدون مبرر للمعلمين تعيين ((   P  )) عقد ((   P   )) خلال شهر سبتمــــــبر (  11 ) لسنة 2019 ف 1441 هـ "]
[]
[null,"الرقم","الاسم بالكامل","المصرف","الفرع","رقم الحساب","رقم الهوية","ايـــــــــــــــــــــــام الغياب","أيام الغياب بالحروف","الرقم الوطني"]
[null,1,{"$f":"IFERROR(VLOOKUP($B8,keab!$B$5:$AP$250,2,0),\"\")","v":"خيري الكموشي"},null,null,null,null,{"$f":"IFERROR(VLOOKUP($B8,keab!$B$5:$AP$250,36,0),\"\")","v":0},{"$f":"IFERROR(VLOOKUP($B8,keab!$B$5:$AP$250,37,0),\"\")","v":0},null,null,null,{"$f":"COUNTA(C8:C21)-COUNTBLANK(C8:C21)","v":3}]
[null,{"$f":"B8+1","v":2},{"$f":"IFERROR(VLOOKUP($B9,keab!$B$5:$AP$250,2,0),\"\")","v":""},null,null,null,null,{"$f":"IFERROR(VLOOKUP($B9,keab!$B$5:$AP$250,36,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B9,keab!$B$5:$AP$250,37,0),\"\")","v":""}]
[null,3,{"$f":"IFERROR(VLOOKUP($B10,keab!$B$5:$AP$250,2,0),\"\")","v":"ابراهيم الصيد المصروب العموري"},null,null,null,null,{"$f":"IFERROR(VLOOKUP($B10,keab!$B$5:$AP$250,36,0),\"\")","v":0},{"$f":"IFERROR(VLOOKUP($B10,keab!$B$5:$AP$250,37,0),\"\")","v":0}]
[null,4,{"$f":"IFERROR(VLOOKUP($B11,keab!$B$5:$AP$250,2,0),\"\")","v":"ابراهيم عبدالله علي الراجحي"},null,null,null,null,{"$f":"IFERROR(VLOOKUP($B11,keab!$B$5:$AP$250,36,0),\"\")","v":0},{"$f":"IFERROR(VLOOKUP($B11,keab!$B$5:$AP$250,37,0),\"\")","v":0}]
[null,5,{"$f":"IFERROR(VLOOKUP($B12,keab!$B$5:$AP$250,2,0),\"\")","v":""},null,null,null,null,{"$f":"IFERROR(VLOOKUP($B12,keab!$B$5:$AP$250,36,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B12,keab!$B$5:$AP$250,37,0),\"\")","v":""}]
[null,6,{"$f":"IFERROR(VLOOKUP($B13,keab!$B$5:$AP$250,2,0),\"\")","v":""},null,null,null,null,{"$f":"IFERROR(VLOOKUP($B13,keab!$B$5:$AP$250,36,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B13,keab!$B$5:$AP$250,37,0),\"\")","v":""}]
[null,7,{"$f":"IFERROR(VLOOKUP($B14,keab!$B$5:$AP$250,2,0),\"\")","v":""},null,null,null,null,{"$f":"IFERROR(VLOOKUP($B14,keab!$B$5:$AP$250,36,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B14,keab!$B$5:$AP$250,37,0),\"\")","v":""}]
[null,8,{"$f":"IFERROR(VLOOKUP($B15,keab!$B$5:$AP$250,2,0),\"\")","v":""},null,null,null,null,{"$f":"IFERROR(VLOOKUP($B15,keab!$B$5:$AP$250,36,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B15,keab!$B$5:$AP$250,37,0),\"\")","v":""}]
[null,9,{"$f":"IFERROR(VLOOKUP($B16,keab!$B$5:$AP$250,2,0),\"\")","v":""},null,null,null,null,{"$f":"IFERROR(VLOOKUP($B16,keab!$B$5:$AP$250,36,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B16,keab!$B$5:$AP$250,37,0),\"\")","v":""}]
[null,10,{"$f":"IFERROR(VLOOKUP($B17,keab!$B$5:$AP$250,2,0),\"\")","v":""},null,null,null,null,{"$f":"IFERROR(VLOOKUP($B17,keab!$B$5:$AP$250,36,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B17,keab!$B$5:$AP$250,37,0),\"\")","v":""}]
[null,11,{"$f":"IFERROR(VLOOKUP($B18,keab!$B$5:$AP$250,2,0),\"\")","v":""},null,null,null,null,{"$f":"IFERROR(VLOOKUP($B18,keab!$B$5:$AP$250,36,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B18,keab!$B$5:$AP$250,37,0),\"\")","v":""}]
[null,12,{"$f":"IFERROR(VLOOKUP($B19,keab!$B$5:$AP$250,2,0),\"\")","v":""},null,null,null,null,{"$f":"IFERROR(VLOOKUP($B19,keab!$B$5:$AP$250,36,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B19,keab!$B$5:$AP$250,37,0),\"\")","v":""}]
[null,13,{"$f":"IFERROR(VLOOKUP($B20,keab!$B$5:$AP$250,2,0),\"\")","v":""},null,null,null,null,{"$f":"IFERROR(VLOOKUP($B20,keab!$B$5:$AP$250,36,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B20,keab!$B$5:$AP$250,37,0),\"\")","v":""}]
[null,14,{"$f":"IFERROR(VLOOKUP($B21,keab!$B$5:$AP$250,2,0),\"\")","v":""},null,null,null,null,{"$f":"IFERROR(VLOOKUP($B21,keab!$B$5:$AP$250,36,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B21,keab!$B$5:$AP$250,37,0),\"\")","v":""}]
[]
[null,"المكلف بتفريغ الغياب",null,null,null,null,null,null,"اعتماد مدير المدرسة"]
[null,"الاسم : خــــيري علـــي الكمـــــــوشي",null,null,null,null,null,null,"الاســــــم : ............................."]
[]
[null,"التوقيع : ........................................",null,null,null,null,null,null,"التوقيع : ..........................................."]

{"sheet":"غياب فردي","index":4,"n_rows":51,"n_cols":13,"rows_kept":51,"cut":false,"hidden":false,"merged":[[19,2,19,5],[15,10,15,11],[15,8,15,9],[17,3,17,6],[15,6,15,7],[15,2,15,4],[21,1,21,6],[21,7,21,11],[24,1,24,3],[24,4,24,5],[24,9,24,10],[50,7,50,11],[34,7,34,11],[39,1,39,4],[26,1,26,3],[26,4,26,5],[29,8,29,10],[30,8,30,10],[32,7,32,11],[37,1,37,6],[39,5,39,7],[48,7,48,11],[39,8,39,11],[41,1,41,5],[44,7,44,11],[46,7,46,11],[11,1,11,3],[8,2,8,4],[13,2,13,7],[13,10,13,11],[13,8,13,9],[8,8,8,11],[9,8,9,11]]}
[null,null,null,null,null,null,null,2,null,null,null,null,4]
[null,null,null,null,null,null,null,null,null,null,null,null,5]
[]
[]
[]
[]
[]
[]
[null,"الرقم الاشاري :","...............................",null,null,null,null,null,"            التاريخ : 4 / صفر / 1441 هـ"]
[null,null,null,null,null,null,null,null,"            المــوافق : 3 / 10 / 2019 م"]
[]
[null,"نموذج غياب شهر ",null,null,"سبتمبر","لسنة : ",2019,"م"]
[]
[null,"الاسم :",{"$f":"IFERROR(VLOOKUP($M$1,keab!$B$5:$AO$36,2,0),\"\")","v":"ابراهيم عبدالله علي الراجحي"},null,null,null,null,null,"الصفـــــــــــــــــة :"]
[]
[null,"المصرف :",null,null,null,null,null,null,"رقـم الحســــــــاب :"]
[]
[null,"مكان العمل  : "]
[]
[null,"الرقم الوطني :"]
[]
[null,"تفيدكم إدارة المدرسة بأن المذكـور أعــلاه قد تغيب خـلال الأيـام :",null,null,null,null,null,{"$f":"IFERROR(VLOOKUP($M$1,keab!$B$5:$AO$36,36,0),\"\")","v":0}]
[]
[]
[null,"تم تعبئـة النمــوذج من قبل :",null,null,"خيري علي الكموشي",null,null,null,"الصفة :","شؤون إدارية "]
[]
[null,"تاريـــخ تعبئــــة النمـــوذج :",null,null,{"$f":"TODAY()","v":"2020-01-26"}]
[]
[]
[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,"بناء على إفادة السيد مدير مدرسة : 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,null,null,null,null,".................................................................."]