{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Year_month","vacance","قائمة الموظفين","أنواع الإجازات","عطلات الشركة"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":9,"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":"Year_month","index":0,"n_rows":19,"n_cols":34,"rows_kept":19,"cut":false,"hidden":false,"merged":[[17,13,17,15],[17,18,17,20],[17,23,17,25],[17,28,17,30],[17,33,17,35],[18,13,18,15],[18,18,18,20],[18,23,18,25],[18,28,18,30],[18,33,18,35],[15,13,15,15],[15,18,15,20],[15,23,15,25],[15,28,15,30],[15,33,15,35],[16,13,16,15],[16,18,16,20],[16,23,16,25],[16,28,16,30],[16,33,16,35],[12,33,12,35],[13,2,13,4],[13,7,13,10],[13,13,13,15],[13,18,13,20],[13,23,13,25],[13,28,13,30],[13,33,13,35],[12,2,12,4],[12,7,12,10],[12,13,12,15],[12,18,12,20],[12,23,12,25],[12,28,12,30],[10,23,10,25],[10,28,10,30],[10,33,10,35],[11,2,11,4],[11,7,11,10],[11,13,11,15],[11,18,11,20],[11,23,11,25],[11,28,11,30],[11,33,11,35],[10,18,10,20],[1,2,1,6],[2,4,2,6],[10,2,10,4],[10,7,10,10],[10,13,10,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,"حدد موظفاً:","الموظف 1",null,null,null,null,"Day1","Day2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"الأحد"]
[null,"أدخل الشهر و السنة:","Year",2018,1,null,null,null,null,null,null,null,null,{"$f":"$C$2","v":"الموظف 1"},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,"2018-01-01","2018-01-02","2018-01-03","2018-01-04","2018-01-05","2018-01-06","2018-01-07","2018-01-08","2018-01-09","2018-01-10","2018-01-11","2018-01-12","2018-01-13","2018-01-14","2018-01-15","2018-01-16","2018-01-17","2018-01-18","2018-01-19","2018-01-20","2018-01-21","2018-01-22","2018-01-23","2018-01-24","2018-01-25","2018-01-26","2018-01-27","2018-01-28","2018-01-29","2018-01-30","2018-01-31"]
[null,null,{"$f":"IFERROR(INDEX(vacance!$E$4:$E$26,SMALL(IF(vacance!$C$4:$C$26=C$7,IF(vacance!$B$4:$B$26=$C$2,ROW($C$4:$C$26)-ROW($C$4)+1)),ROWS($A$1:A1))),\"\")","v":""},{"$f":"IFERROR(INDEX(vacance!$E$4:$E$26,SMALL(IF(vacance!$C$4:$C$26=D$7,IF(vacance!$B$4:$B$26=$C$2,ROW($C$4:$C$26)-ROW($C$4)+1)),ROWS($A$1:B1))),\"\")","v":""},{"$f":"IFERROR(INDEX(vacance!$E$4:$E$26,SMALL(IF(vacance!$C$4:$C$26=E$7,IF(vacance!$B$4:$B$26=$C$2,ROW($C$4:$C$26)-ROW($C$4)+1)),ROWS($A$1:C1))),\"\")","v":"إجازة مرضية"},{"$f":"IFERROR(INDEX(vacance!$E$4:$E$26,SMALL(IF(vacance!$C$4:$C$26=F$7,IF(vacance!$B$4:$B$26=$C$2,ROW($C$4:$C$26)-ROW($C$4)+1)),ROWS($A$1:D1))),\"\")","v":""},{"$f":"IFERROR(INDEX(vacance!$E$4:$E$26,SMALL(IF(vacance!$C$4:$C$26=G$7,IF(vacance!$B$4:$B$26=$C$2,ROW($C$4:$C$26)-ROW($C$4)+1)),ROWS($A$1:E1))),\"\")","v":""},{"$f":"IFERROR(INDEX(vacance!$E$4:$E$26,SMALL(IF(vacance!$C$4:$C$26=H$7,IF(vacance!$B$4:$B$26=$C$2,ROW($C$4:$C$26)-ROW($C$4)+1)),ROWS($A$1:F1))),\"\")","v":""},{"$f":"IFERROR(INDEX(vacance!$E$4:$E$26,SMALL(IF(vacance!$C$4:$C$26=I$7,IF(vacance!$B$4:$B$26=$C$2,ROW($C$4:$C$26)-ROW($C$4)+1)),ROWS($A$1:G1))),\"\")","v":""},{"$f":"IFERROR(INDEX(vacance!$E$4:$E$26,SMALL(IF(vacance!$C$4:$C$26=J$7,IF(vacance!$B$4:$B$26=$C$2,ROW($C$4:$C$26)-ROW($C$4)+1)),ROWS($A$1:H1))),\"\")","v":""},{"$f":"IFERROR(INDEX(vacance!$E$4:$E$26,SMALL(IF(vacance!$C$4:$C$26=K$7,IF(vacance!$B$4:$B$26=$C$2,ROW($C$4:$C$26)-ROW($C$4)+1)),ROWS($A$1:I1))),\"\")","v":""},{"$f":"IFERROR(INDEX(vacance!$E$4:$E$26,SMALL(IF(vacance!$C$4:$C$26=L$7,IF(vacance!$B$4:$B$26=$C$2,ROW($C$4:$C$26)-ROW($C$4)+1)),ROWS($A$1:J1))),\"\")","v":""},{"$f":"IFERROR(INDEX(vacance!$E$4:$E$26,SMALL(IF(vacance!$C$4:$C$26=M$7,IF(vacance!$B$4:$B$26=$C$2,ROW($C$4:$C$26)-ROW($C$4)+1)),ROWS($A$1:K1))),\"\")","v":""},{"$f":"IFERROR(INDEX(vacance!$E$4:$E$26,SMALL(IF(vacance!$C$4:$C$26=N$7,IF(vacance!$B$4:$B$26=$C$2,ROW($C$4:$C$26)-ROW($C$4)+1)),ROWS($A$1:L1))),\"\")","v":""},{"$f":"IFERROR(INDEX(vacance!$E$4:$E$26,SMALL(IF(vacance!$C$4:$C$26=O$7,IF(vacance!$B$4:$B$26=$C$2,ROW($C$4:$C$26)-ROW($C$4)+1)),ROWS($A$1:M1))),\"\")","v":""},{"$f":"IFERROR(INDEX(vacance!$E$4:$E$26,SMALL(IF(vacance!$C$4:$C$26=P$7,IF(vacance!$B$4:$B$26=$C$2,ROW($C$4:$C$26)-ROW($C$4)+1)),ROWS($A$1:N1))),\"\")","v":""},{"$f":"IFERROR(INDEX(vacance!$E$4:$E$26,SMALL(IF(vacance!$C$4:$C$26=Q$7,IF(vacance!$B$4:$B$26=$C$2,ROW($C$4:$C$26)-ROW($C$4)+1)),ROWS($A$1:O1))),\"\")","v":""},{"$f":"IFERROR(INDEX(vacance!$E$4:$E$26,SMALL(IF(vacance!$C$4:$C$26=R$7,IF(vacance!$B$4:$B$26=$C$2,ROW($C$4:$C$26)-ROW($C$4)+1)),ROWS($A$1:P1))),\"\")","v":""},{"$f":"IFERROR(INDEX(vacance!$E$4:$E$26,SMALL(IF(vacance!$C$4:$C$26=S$7,IF(vacance!$B$4:$B$26=$C$2,ROW($C$4:$C$26)-ROW($C$4)+1)),ROWS($A$1:Q1))),\"\")","v":""},{"$f":"IFERROR(INDEX(vacance!$E$4:$E$26,SMALL(IF(vacance!$C$4:$C$26=T$7,IF(vacance!$B$4:$B$26=$C$2,ROW($C$4:$C$26)-ROW($C$4)+1)),ROWS($A$1:R1))),\"\")","v":""},{"$f":"IFERROR(INDEX(vacance!$E$4:$E$26,SMALL(IF(vacance!$C$4:$C$26=U$7,IF(vacance!$B$4:$B$26=$C$2,ROW($C$4:$C$26)-ROW($C$4)+1)),ROWS($A$1:S1))),\"\")","v":""},{"$f":"IFERROR(INDEX(vacance!$E$4:$E$26,SMALL(IF(vacance!$C$4:$C$26=V$7,IF(vacance!$B$4:$B$26=$C$2,ROW($C$4:$C$26)-ROW($C$4)+1)),ROWS($A$1:T1))),\"\")","v":""},{"$f":"IFERROR(INDEX(vacance!$E$4:$E$26,SMALL(IF(vacance!$C$4:$C$26=W$7,IF(vacance!$B$4:$B$26=$C$2,ROW($C$4:$C$26)-ROW($C$4)+1)),ROWS($A$1:U1))),\"\")","v":""},{"$f":"IFERROR(INDEX(vacance!$E$4:$E$26,SMALL(IF(vacance!$C$4:$C$26=X$7,IF(vacance!$B$4:$B$26=$C$2,ROW($C$4:$C$26)-ROW($C$4)+1)),ROWS($A$1:V1))),\"\")","v":""},{"$f":"IFERROR(INDEX(vacance!$E$4:$E$26,SMALL(IF(vacance!$C$4:$C$26=Y$7,IF(vacance!$B$4:$B$26=$C$2,ROW($C$4:$C$26)-ROW($C$4)+1)),ROWS($A$1:W1))),\"\")","v":""},{"$f":"IFERROR(INDEX(vacance!$E$4:$E$26,SMALL(IF(vacance!$C$4:$C$26=Z$7,IF(vacance!$B$4:$B$26=$C$2,ROW($C$4:$C$26)-ROW($C$4)+1)),ROWS($A$1:X1))),\"\")","v":""},{"$f":"IFERROR(INDEX(vacance!$E$4:$E$26,SMALL(IF(vacance!$C$4:$C$26=AA$7,IF(vacance!$B$4:$B$26=$C$2,ROW($C$4:$C$26)-ROW($C$4)+1)),ROWS($A$1:Y1))),\"\")","v":""},{"$f":"IFERROR(INDEX(vacance!$E$4:$E$26,SMALL(IF(vacance!$C$4:$C$26=AB$7,IF(vacance!$B$4:$B$26=$C$2,ROW($C$4:$C$26)-ROW($C$4)+1)),ROWS($A$1:Z1))),\"\")","v":""},{"$f":"IFERROR(INDEX(vacance!$E$4:$E$26,SMALL(IF(vacance!$C$4:$C$26=AC$7,IF(vacance!$B$4:$B$26=$C$2,ROW($C$4:$C$26)-ROW($C$4)+1)),ROWS($A$1:AA1))),\"\")","v":""},{"$f":"IFERROR(INDEX(vacance!$E$4:$E$26,SMALL(IF(vacance!$C$4:$C$26=AD$7,IF(vacance!$B$4:$B$26=$C$2,ROW($C$4:$C$26)-ROW($C$4)+1)),ROWS($A$1:AB1))),\"\")","v":""},{"$f":"IFERROR(INDEX(vacance!$E$4:$E$26,SMALL(IF(vacance!$C$4:$C$26=AE$7,IF(vacance!$B$4:$B$26=$C$2,ROW($C$4:$C$26)-ROW($C$4)+1)),ROWS($A$1:AC1))),\"\")","v":""},{"$f":"IFERROR(INDEX(vacance!$E$4:$E$26,SMALL(IF(vacance!$C$4:$C$26=AF$7,IF(vacance!$B$4:$B$26=$C$2,ROW($C$4:$C$26)-ROW($C$4)+1)),ROWS($A$1:AD1))),\"\")","v":""},{"$f":"IFERROR(INDEX(vacance!$E$4:$E$26,SMALL(IF(vacance!$C$4:$C$26=AG$7,IF(vacance!$B$4:$B$26=$C$2,ROW($C$4:$C$26)-ROW($C$4)+1)),ROWS($A$1:AE1))),\"\")","v":"حداد"}]
[]
[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,{"$f":"NETWORKDAYS(DATE(Calendar_Year,1,1),EDATE(DATE(Calendar_Year,1,1),12)-1)","v":{"$error":"#NAME?"}},null,null,null,null,null,{"$f":"SUMIFS(vacance!$F$4:$F$26,vacance!$B$4:$B$26,valSelEmployee,vacance!$C$4:$C$26,\">=\"&DATE(Calendar_Year,1,1),vacance!$D$4:$D$26,\"<\"&DATE(Calendar_Year+1,1,1),vacance!$E$4:$E$26,'أنواع الإجازات'!B4)","v":0},null,null,null,null,{"$f":"SUMIFS(vacance!$F$4:$F$26,vacance!$B$4:$B$26,valSelEmployee,vacance!$C$4:$C$26,\">=\"&DATE(Calendar_Year,1,1),vacance!$D$4:$D$26,\"<\"&DATE(Calendar_Year+1,1,1),vacance!$E$4:$E$26,'أنواع الإجازات'!B5)","v":0},null,null,null,null,{"$f":"SUMIFS(vacance!$F$4:$F$26,vacance!$B$4:$B$26,valSelEmployee,vacance!$C$4:$C$26,\">=\"&DATE(Calendar_Year,1,1),vacance!$D$4:$D$26,\"<\"&DATE(Calendar_Year+1,1,1),vacance!$E$4:$E$26,'أنواع الإجازات'!B6)","v":0},null,null,null,null,{"$f":"SUMIFS(vacance!$F$4:$F$26,vacance!$B$4:$B$26,valSelEmployee,vacance!$C$4:$C$26,\">=\"&DATE(Calendar_Year,1,1),vacance!$D$4:$D$26,\"<\"&DATE(Calendar_Year+1,1,1),vacance!$E$4:$E$26,'أنواع الإجازات'!B7)","v":0},null,null,null,null,{"$f":"SUMIFS(vacance!$B$4:$B$26,vacance!$C$4:$C$26,valSelEmployee,vacance!$D$4:$D$26,\">=\"&DATE(Calendar_Year,1,1),vacance!$E$4:$E$26,\"<\"&DATE(Calendar_Year+1,1,1),vacance!$F$4:$F$26,'أنواع الإجازات'!G7)","v":0}]
[null,null,{"$f":"SUMIFS(vacance!$F$4:$F$26,vacance!$B$4:$B$26,valSelEmployee,vacance!$C$4:$C$26,\">=\"&DATE(Calendar_Year-1,1,1),vacance!$D$4:$D$26,\"<\"&DATE(Calendar_Year,1,1))","v":0},null,null,null,null,{"$f":"NETWORKDAYS(DATE(Calendar_Year-1,1,1),EDATE(DATE(Calendar_Year-1,1,1),12)-1)","v":{"$error":"#NAME?"}},null,null,null,null,null,{"$f":"SUMIFS(vacance!$F$4:$F$26,vacance!$B$4:$B$26,valSelEmployee,vacance!$C$4:$C$26,\">=\"&DATE(Calendar_Year-1,1,1),vacance!$D$4:$D$26,\"<\"&DATE(Calendar_Year,1,1),vacance!$E$4:$E$26,'أنواع الإجازات'!B4)","v":0},null,null,null,null,{"$f":"SUMIFS(vacance!$F$4:$F$26,vacance!$B$4:$B$26,valSelEmployee,vacance!$C$4:$C$26,\">=\"&DATE(Calendar_Year-1,1,1),vacance!$D$4:$D$26,\"<\"&DATE(Calendar_Year,1,1),vacance!$E$4:$E$26,'أنواع الإجازات'!B5)","v":0},null,null,null,null,{"$f":"SUMIFS(vacance!$F$4:$F$26,vacance!$B$4:$B$26,valSelEmployee,vacance!$C$4:$C$26,\">=\"&DATE(Calendar_Year-1,1,1),vacance!$D$4:$D$26,\"<\"&DATE(Calendar_Year,1,1),vacance!$E$4:$E$26,'أنواع الإجازات'!B6)","v":0},null,null,null,null,{"$f":"SUMIFS(vacance!$F$4:$F$26,vacance!$B$4:$B$26,valSelEmployee,vacance!$C$4:$C$26,\">=\"&DATE(Calendar_Year-1,1,1),vacance!$D$4:$D$26,\"<\"&DATE(Calendar_Year,1,1),vacance!$E$4:$E$26,'أنواع الإجازات'!B7)","v":0},null,null,null,null,{"$f":"SUMIFS(vacance!$B$4:$B$26,vacance!$C$4:$C$26,valSelEmployee,vacance!$D$4:$D$26,\">=\"&DATE(Calendar_Year-1,1,1),vacance!$E$4:$E$26,\"<\"&DATE(Calendar_Year,1,1),vacance!$F$4:$F$26,'أنواع الإجازات'!G7)","v":0}]
[null,null,{"$f":"IFERROR(IF(C13<>0,IF(C12>=C13,\"زيادة \", \"أقل \")&TEXT(C12/C13-1,\"0%;0%\"),\"زيادة 100%\"),\"\")","v":"زيادة 100%"},null,null,null,null,{"$f":"IFERROR(IF(H13<>0,IF(H12>=H13,\"زيادة \", \"أقل \")&TEXT(H12/H13-1,\"0%;0%\"),\"زيادة 100%\"),\"\")","v":""},null,null,null,null,null,{"$f":"IFERROR(IF(N13<>0,IF(N12>=N13,\"زيادة \", \"أقل \")&TEXT(N12/N13-1,\"0%;0%\"),\"زيادة 100%\"),\"\")","v":"زيادة 100%"},null,null,null,null,{"$f":"IFERROR(IF(S13<>0,IF(S12>=S13,\"زيادة \", \"أقل \")&TEXT(S12/S13-1,\"0%;0%\"),\"زيادة 100%\"),\"\")","v":"زيادة 100%"},null,null,null,null,{"$f":"IFERROR(IF(X13<>0,IF(X12>=X13,\"زيادة \", \"أقل \")&TEXT(X12/X13-1,\"0%;0%\"),\"زيادة 100%\"),\"\")","v":"زيادة 100%"},null,null,null,null,{"$f":"IFERROR(IF(AC13<>0,IF(AC12>=AC13,\"زيادة \", \"أقل \")&TEXT(AC12/AC13-1,\"0%;0%\"),\"زيادة 100%\"),\"\")","v":"زيادة 100%"},null,null,null,null,{"$f":"IFERROR(IF(AH13<>0,IF(AH12>=AH13,\"زيادة \", \"أقل \")&TEXT(AH12/AH13-1,\"0%;0%\"),\"زيادة 100%\"),\"\")","v":"زيادة 100%"}]
[]
[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,{"$f":"SUMIFS(vacance!$F$4:$F$26,vacance!$B$4:$B$26,valSelEmployee,vacance!$C$4:$C$26,\">=\"&DATE(Calendar_Year,1,1),vacance!$D$4:$D$26,\"<\"&DATE(Calendar_Year+1,1,1),vacance!$E$4:$E$26,'أنواع الإجازات'!B8)","v":0},null,null,null,null,{"$f":"SUMIFS(vacance!$F$4:$F$26,vacance!$B$4:$B$26,valSelEmployee,vacance!$C$4:$C$26,\">=\"&DATE(Calendar_Year,1,1),vacance!$D$4:$D$26,\"<\"&DATE(Calendar_Year+1,1,1),vacance!$E$4:$E$26,'أنواع الإجازات'!B9)","v":0},null,null,null,null,{"$f":"SUMIFS(vacance!$F$4:$F$26,vacance!$B$4:$B$26,valSelEmployee,vacance!$C$4:$C$26,\">=\"&DATE(Calendar_Year,1,1),vacance!$D$4:$D$26,\"<\"&DATE(Calendar_Year+1,1,1),vacance!$E$4:$E$26,'أنواع الإجازات'!B10)","v":0},null,null,null,null,{"$f":"SUMIFS(vacance!$F$4:$F$26,vacance!$B$4:$B$26,valSelEmployee,vacance!$C$4:$C$26,\">=\"&DATE(Calendar_Year,1,1),vacance!$D$4:$D$26,\"<\"&DATE(Calendar_Year+1,1,1),vacance!$E$4:$E$26,'أنواع الإجازات'!B11)","v":0},null,null,null,null,{"$f":"SUMIFS(vacance!$B$4:$B$26,vacance!$C$4:$C$26,valSelEmployee,vacance!$D$4:$D$26,\">=\"&DATE(Calendar_Year,1,1),vacance!$E$4:$E$26,\"<\"&DATE(Calendar_Year+1,1,1),vacance!$F$4:$F$26,'أنواع الإجازات'!G11)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMIFS(vacance!$F$4:$F$26,vacance!$B$4:$B$26,valSelEmployee,vacance!$C$4:$C$26,\">=\"&DATE(Calendar_Year-1,1,1),vacance!$D$4:$D$26,\"<\"&DATE(Calendar_Year,1,1),vacance!$E$4:$E$26,'أنواع الإجازات'!B8)","v":0},null,null,null,null,{"$f":"SUMIFS(vacance!$F$4:$F$26,vacance!$B$4:$B$26,valSelEmployee,vacance!$C$4:$C$26,\">=\"&DATE(Calendar_Year-1,1,1),vacance!$D$4:$D$26,\"<\"&DATE(Calendar_Year,1,1),vacance!$E$4:$E$26,'أنواع الإجازات'!B9)","v":0},null,null,null,null,{"$f":"SUMIFS(vacance!$F$4:$F$26,vacance!$B$4:$B$26,valSelEmployee,vacance!$C$4:$C$26,\">=\"&DATE(Calendar_Year-1,1,1),vacance!$D$4:$D$26,\"<\"&DATE(Calendar_Year,1,1),vacance!$E$4:$E$26,'أنواع الإجازات'!B10)","v":0},null,null,null,null,{"$f":"SUMIFS(vacance!$F$4:$F$26,vacance!$B$4:$B$26,valSelEmployee,vacance!$C$4:$C$26,\">=\"&DATE(Calendar_Year-1,1,1),vacance!$D$4:$D$26,\"<\"&DATE(Calendar_Year,1,1),vacance!$E$4:$E$26,'أنواع الإجازات'!B11)","v":0},null,null,null,null,{"$f":"SUMIFS(vacance!$B$4:$B$26,vacance!$C$4:$C$26,valSelEmployee,vacance!$D$4:$D$26,\">=\"&DATE(Calendar_Year-1,1,1),vacance!$E$4:$E$26,\"<\"&DATE(Calendar_Year,1,1),vacance!$F$4:$F$26,'أنواع الإجازات'!G11)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(N18<>0,IF(N17>=N18,\"زيادة \", \"أقل \")&TEXT(N17/N18-1,\"0%;0%\"),\"زيادة 100%\"),\"\")","v":"زيادة 100%"},null,null,null,null,{"$f":"IFERROR(IF(S18<>0,IF(S17>=S18,\"زيادة \", \"أقل \")&TEXT(S17/S18-1,\"0%;0%\"),\"زيادة 100%\"),\"\")","v":"زيادة 100%"},null,null,null,null,{"$f":"IFERROR(IF(X18<>0,IF(X17>=X18,\"زيادة \", \"أقل \")&TEXT(X17/X18-1,\"0%;0%\"),\"زيادة 100%\"),\"\")","v":"زيادة 100%"},null,null,null,null,{"$f":"IFERROR(IF(AC18<>0,IF(AC17>=AC18,\"زيادة \", \"أقل \")&TEXT(AC17/AC18-1,\"0%;0%\"),\"زيادة 100%\"),\"\")","v":"زيادة 100%"},null,null,null,null,{"$f":"IFERROR(IF(AH18<>0,IF(AH17>=AH18,\"زيادة \", \"أقل \")&TEXT(AH17/AH18-1,\"0%;0%\"),\"زيادة 100%\"),\"\")","v":"زيادة 100%"}]

{"sheet":"vacance","index":1,"n_rows":26,"n_cols":6,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
[null,"متعقب إجازات الموظفين"]
[]
[null,"اسم الموظف","تاريخ البداية","تاريخ النهاية","نوع الإجازة","الأيام"]
[null,"الموظف 1",{"$f":"DATE(YEAR(TODAY()),1,3)","v":"2018-01-03"},{"$f":"DATE(YEAR(TODAY()),1,3)","v":"2018-01-03"},"إجازة مرضية",{"$f":"NETWORKDAYS(vacance!$C4,vacance!$D4,lstHolidays)","v":1}]
[null,"الموظف 2",{"$f":"DATE(YEAR(TODAY()),1,17)","v":"2018-01-17"},{"$f":"DATE(YEAR(TODAY()),1,18)","v":"2018-01-18"},"استئذان",{"$f":"NETWORKDAYS(vacance!$C5,vacance!$D5,lstHolidays)","v":2}]
[null,"الموظف 3",{"$f":"DATE(YEAR(TODAY()),1,18 )","v":"2018-01-18"},{"$f":"DATE(YEAR(TODAY()),1,21)","v":"2018-01-21"},"أخرى",{"$f":"NETWORKDAYS(vacance!$C6,vacance!$D6,lstHolidays)","v":2}]
[null,"الموظف 5",{"$f":"DATE(YEAR(TODAY())-1,12,10 )","v":"2017-12-10"},{"$f":"DATE(YEAR(TODAY())-1,12,16)","v":"2017-12-16"},"حداد",{"$f":"NETWORKDAYS(vacance!$C7,vacance!$D7,lstHolidays)","v":5}]
[null,"الموظف 4",{"$f":"DATE(YEAR(TODAY())-1,12,1  )","v":"2017-12-01"},{"$f":"DATE(YEAR(TODAY())-1,12,2)","v":"2017-12-02"},"إجازة مرضية",{"$f":"NETWORKDAYS(vacance!$C8,vacance!$D8,lstHolidays)","v":1}]
[null,"الموظف 1",{"$f":"DATE(YEAR(TODAY())-1,11,14  )","v":"2017-11-14"},{"$f":"DATE(YEAR(TODAY())-1,11,18)","v":"2017-11-18"},"العطلة",{"$f":"NETWORKDAYS(vacance!$C9,vacance!$D9,lstHolidays)","v":4}]
[null,"الموظف 4",{"$f":"DATE(YEAR(TODAY()),1,31 )","v":"2018-01-31"},{"$f":"DATE(YEAR(TODAY()),2,4)","v":"2018-02-04"},"إجازة مرضية",{"$f":"NETWORKDAYS(vacance!$C10,vacance!$D10,lstHolidays)","v":3}]
[null,"الموظف 4",{"$f":"DATE(YEAR(TODAY())-1,12,1  )","v":"2017-12-01"},{"$f":"DATE(YEAR(TODAY())-1,12,6)","v":"2017-12-06"},"أخرى",{"$f":"NETWORKDAYS(vacance!$C11,vacance!$D11,lstHolidays)","v":4}]
[null,"الموظف 4",{"$f":"DATE(YEAR(TODAY())-1,12,10  )","v":"2017-12-10"},{"$f":"DATE(YEAR(TODAY())-1,12,16)","v":"2017-12-16"},"أخرى",{"$f":"NETWORKDAYS(vacance!$C12,vacance!$D12,lstHolidays)","v":5}]
[null,"الموظف 2",{"$f":"DATE(YEAR(TODAY()),1,13 )","v":"2018-01-13"},{"$f":"DATE(YEAR(TODAY()),1,15)","v":"2018-01-15"},"غياب",{"$f":"NETWORKDAYS(vacance!$C13,vacance!$D13,lstHolidays)","v":1}]
[null,"الموظف 5",{"$f":"DATE(YEAR(TODAY()),1,15 )","v":"2018-01-15"},{"$f":"DATE(YEAR(TODAY()),1,20)","v":"2018-01-20"},"إجازة مرضية",{"$f":"NETWORKDAYS(vacance!$C14,vacance!$D14,lstHolidays)","v":5}]
[null,"الموظف 2",{"$f":"DATE(YEAR(TODAY()),6,13 )","v":"2018-06-13"},{"$f":"DATE(YEAR(TODAY()),6,15)","v":"2018-06-15"},"تبديل",{"$f":"NETWORKDAYS(vacance!$C15,vacance!$D15,lstHolidays)","v":3}]
[null,"الموظف 5",{"$f":"DATE(YEAR(TODAY()),1,27 )","v":"2018-01-27"},{"$f":"DATE(YEAR(TODAY()),2,3)","v":"2018-02-03"},"حداد",{"$f":"NETWORKDAYS(vacance!$C16,vacance!$D16,lstHolidays)","v":5}]
[null,"الموظف 3",{"$f":"DATE(YEAR(TODAY()),1,17 )","v":"2018-01-17"},{"$f":"DATE(YEAR(TODAY()),1,18)","v":"2018-01-18"},"العطلة",{"$f":"NETWORKDAYS(vacance!$C17,vacance!$D17,lstHolidays)","v":2}]
[null,"الموظف 3",{"$f":"DATE(YEAR(TODAY())-1,12,12 )","v":"2017-12-12"},{"$f":"DATE(YEAR(TODAY())-1,12,17)","v":"2017-12-17"},"حداد",{"$f":"NETWORKDAYS(vacance!$C18,vacance!$D18,lstHolidays)","v":4}]
[null,"الموظف 1",{"$f":"DATE(YEAR(TODAY())-1,12,21  )","v":"2017-12-21"},{"$f":"DATE(YEAR(TODAY())-1,12,22)","v":"2017-12-22"},"أخرى",{"$f":"NETWORKDAYS(vacance!$C19,vacance!$D19,lstHolidays)","v":2}]
[null,"الموظف 1",{"$f":"DATE(YEAR(TODAY())-1,12,14  )","v":"2017-12-14"},{"$f":"DATE(YEAR(TODAY())-1,12,16)","v":"2017-12-16"},"العطلة",{"$f":"NETWORKDAYS(vacance!$C20,vacance!$D20,lstHolidays)","v":2}]
[null,"الموظف 2",{"$f":"DATE(YEAR(TODAY())-1,11,29  )","v":"2017-11-29"},{"$f":"DATE(YEAR(TODAY())-1,12,6)","v":"2017-12-06"},"استثناء",{"$f":"NETWORKDAYS(vacance!$C21,vacance!$D21,lstHolidays)","v":6}]
[null,"الموظف 5",{"$f":"DATE(YEAR(TODAY())-1,12,3  )","v":"2017-12-03"},{"$f":"DATE(YEAR(TODAY())-1,12,7)","v":"2017-12-07"},"العطلة",{"$f":"NETWORKDAYS(vacance!$C22,vacance!$D22,lstHolidays)","v":4}]
[null,"الموظف 1",{"$f":"DATE(YEAR(TODAY()),1,31 )","v":"2018-01-31"},{"$f":"DATE(YEAR(TODAY()),2,2)","v":"2018-02-02"},"حداد",{"$f":"NETWORKDAYS(vacance!$C23,vacance!$D23,lstHolidays)","v":3}]
[null,"الموظف 1",{"$f":"DATE(YEAR(TODAY())-1,11,24 )","v":"2017-11-24"},{"$f":"DATE(YEAR(TODAY())-1,11,29)","v":"2017-11-29"},"إجازة مرضية",{"$f":"NETWORKDAYS(vacance!$C24,vacance!$D24,lstHolidays)","v":4}]
[null,"الموظف 2",{"$f":"DATE(YEAR(TODAY()),12,5 )","v":"2018-12-05"},{"$f":"DATE(YEAR(TODAY()),12,9)","v":"2018-12-09"},"العطلة",{"$f":"NETWORKDAYS(vacance!$C25,vacance!$D25,lstHolidays)","v":3}]
[null,"الموظف 5",{"$f":"DATE(YEAR(TODAY()),4,11 )","v":"2018-04-11"},{"$f":"DATE(YEAR(TODAY()),4,19)","v":"2018-04-19"},"العطلة",{"$f":"NETWORKDAYS(vacance!$C26,vacance!$D26,lstHolidays)","v":7}]

{"sheet":"قائمة الموظفين","index":2,"n_rows":8,"n_cols":2,"rows_kept":8,"cut":false,"hidden":true,"merged":[]}
[null,"قائمة الموظفين"]
[]
[null,"أسماء الموظفين"]
[null,"الموظف 1"]
[null,"الموظف 2"]
[null,"الموظف 3"]
[null,"الموظف 4"]
[null,"الموظف 5"]

{"sheet":"أنواع الإجازات","index":3,"n_rows":13,"n_cols":2,"rows_kept":13,"cut":false,"hidden":true,"merged":[]}
[null,"أنواع الإجازات"]
[]
[null,"قائمة أنواع الإجازات"]
[null,"إجازة مرضية"]
[null,"إجازة عادية"]
[null,"حداد"]
[null,"غياب"]
[null,"تأخير"]
[null,"استئذان"]
[null,"مرافق"]
[null,"استثناء"]
[null,"طارئة"]
[null,"تبديل"]

{"sheet":"عطلات الشركة","index":4,"n_rows":7,"n_cols":3,"rows_kept":7,"cut":false,"hidden":true,"merged":[]}
[null,"عطلات الشركة"]
[]
[null,"عطلات الشركة","الوصف"]
[null,{"$f":"DATE(YEAR(TODAY()),11,24)","v":"2018-11-24"},"عيد الفطر"]
[null,{"$f":"DATE(YEAR(TODAY()),11,25)","v":"2018-11-25"},"عيد الفطر"]
[null,{"$f":"DATE(YEAR(TODAY()),12,24)","v":"2018-12-24"},"عيد الأضحى"]
[null,{"$f":"DATE(YEAR(TODAY()),12,25)","v":"2018-12-25"},"عيد الأضحى"]