{"text_format":"3","workbook":"xlsx","n_sheets":13,"sheets":["يناير","فبراير","مارس","أبريل","مايو","يونيو","يوليو","أغسطس","سبتمبر","أكتوبر","نوفمبر","ديسمبر","أسماء الموظفين"],"not_rendered":{"defined_names":50},"read":"whole","date_system":"1900"}

{"sheet":"يناير","index":0,"n_rows":12,"n_cols":34,"rows_kept":12,"merged":[[1,3,1,5],[1,7,1,9],[1,11,1,12],[1,14,1,16],[1,18,1,20],[3,2,3,32]]}
[null,"جدول غياب الموظفين"]
[null,"مفتاح نوع الغياب","ع","العطلة",null,null,"ش","أسباب شخصية",null,null,"م","مرضي",null,null,"مخصص 1",{"$nulls":3},"مخصص 2"]
[{"$nulls":33},"أدخل السنة:"]
[null,"يناير","تواريخ الغياب",{"$nulls":30},2019]
[null,null,{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,1,1),1),\"aaa\")","v":"الثلاثاء"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,1,2),1),\"aaa\")","v":"الأربعاء"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,1,3),1),\"aaa\")","v":"الخميس"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,1,4),1),\"aaa\")","v":"الجمعة"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,1,5),1),\"aaa\")","v":"السبت"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,1,6),1),\"aaa\")","v":"الأحد"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,1,7),1),\"aaa\")","v":"الإثنين"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,1,8),1),\"aaa\")","v":"الثلاثاء"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,1,9),1),\"aaa\")","v":"الأربعاء"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,1,10),1),\"aaa\")","v":"الخميس"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,1,11),1),\"aaa\")","v":"الجمعة"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,1,12),1),\"aaa\")","v":"السبت"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,1,13),1),\"aaa\")","v":"الأحد"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,1,14),1),\"aaa\")","v":"الإثنين"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,1,15),1),\"aaa\")","v":"الثلاثاء"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,1,16),1),\"aaa\")","v":"الأربعاء"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,1,17),1),\"aaa\")","v":"الخميس"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,1,18),1),\"aaa\")","v":"الجمعة"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,1,19),1),\"aaa\")","v":"السبت"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,1,20),1),\"aaa\")","v":"الأحد"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,1,21),1),\"aaa\")","v":"الإثنين"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,1,22),1),\"aaa\")","v":"الثلاثاء"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,1,23),1),\"aaa\")","v":"الأربعاء"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,1,24),1),\"aaa\")","v":"الخميس"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,1,25),1),\"aaa\")","v":"الجمعة"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,1,26),1),\"aaa\")","v":"السبت"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,1,27),1),\"aaa\")","v":"الأحد"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,1,28),1),\"aaa\")","v":"الإثنين"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,1,29),1),\"aaa\")","v":"الثلاثاء"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,1,30),1),\"aaa\")","v":"الأربعاء"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,1,31),1),\"aaa\")","v":"الخميس"}]
[null,"اسم الموظف","1","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","27","28","29","30","31","إجمالي الأيام"]
[null,"الموظف 1",null,null,"ع","ع","ع","ع",{"$nulls":6},"ع",{"$nulls":18},{"$f":"COUNTA(يناير!$C7:$AG7)","v":5}]
[null,"الموظف 2",{"$nulls":4},"م","م",{"$nulls":4},"ش",{"$nulls":8},"م",{"$nulls":4},"ع","ع","ع",{"$nulls":4},{"$f":"COUNTA(يناير!$C8:$AG8)","v":7}]
[null,"الموظف 3",null,null,"ش",{"$nulls":10},"م",{"$nulls":14},"م",null,null,{"$f":"COUNTA(يناير!$C9:$AG9)","v":3}]
[null,"الموظف 4",{"$nulls":6},"ش",{"$nulls":11},"ع","ع","ع",{"$nulls":10},{"$f":"COUNTA(يناير!$C10:$AG10)","v":4}]
[null,"الموظف 5",{"$nulls":3},"م","ع","ع",{"$nulls":10},"م",{"$nulls":6},"م",{"$nulls":6},"ع",{"$f":"COUNTA(يناير!$C11:$AG11)","v":6}]
[null,{"$f":"\"إجمالي شهر \"&MonthName","v":"إجمالي شهر يناير"},{"$f":"SUBTOTAL(103,يناير!$C$7:$C$11)","v":0},{"$f":"SUBTOTAL(103,يناير!$D$7:$D$11)","v":0},{"$f":"SUBTOTAL(103,يناير!$E$7:$E$11)","v":2},{"$f":"SUBTOTAL(103,يناير!$F$7:$F$11)","v":2},{"$f":"SUBTOTAL(103,يناير!$G$7:$G$11)","v":3},{"$f":"SUBTOTAL(103,يناير!$H$7:$H$11)","v":3},{"$f":"SUBTOTAL(103,يناير!$I$7:$I$11)","v":1},{"$f":"SUBTOTAL(103,يناير!$J$7:$J$11)","v":0},{"$f":"SUBTOTAL(103,يناير!$K$7:$K$11)","v":0},{"$f":"SUBTOTAL(103,يناير!$L$7:$L$11)","v":0},{"$f":"SUBTOTAL(103,يناير!$M$7:$M$11)","v":1},{"$f":"SUBTOTAL(103,يناير!$N$7:$N$11)","v":0},{"$f":"SUBTOTAL(103,يناير!$O$7:$O$11)","v":1},{"$f":"SUBTOTAL(103,يناير!$P$7:$P$11)","v":1},{"$f":"SUBTOTAL(103,يناير!$Q$7:$Q$11)","v":0},{"$f":"SUBTOTAL(103,يناير!$R$7:$R$11)","v":0},{"$f":"SUBTOTAL(103,يناير!$S$7:$S$11)","v":1},{"$f":"SUBTOTAL(103,يناير!$T$7:$T$11)","v":0},{"$f":"SUBTOTAL(103,يناير!$U$7:$U$11)","v":1},{"$f":"SUBTOTAL(103,يناير!$V$7:$V$11)","v":2},{"$f":"SUBTOTAL(103,يناير!$W$7:$W$11)","v":1},{"$f":"SUBTOTAL(103,يناير!$X$7:$X$11)","v":0},{"$f":"SUBTOTAL(103,يناير!$Y$7:$Y$11)","v":0},{"$f":"SUBTOTAL(103,يناير!$Z$7:$Z$11)","v":1},{"$f":"SUBTOTAL(103,يناير!$AA$7:$AA$11)","v":1},{"$f":"SUBTOTAL(103,يناير!$AB$7:$AB$11)","v":1},{"$f":"SUBTOTAL(103,يناير!$AC$7:$AC$11)","v":1},{"$f":"SUBTOTAL(103,يناير!$AD$7:$AD$11)","v":0},{"$f":"SUBTOTAL(103,يناير!$AE$7:$AE$11)","v":1},{"$f":"SUBTOTAL(103,يناير!$AF$7:$AF$11)","v":0},{"$f":"SUBTOTAL(103,يناير!$AG$7:$AG$11)","v":1},{"$f":"SUBTOTAL(109,يناير[إجمالي الأيام])","v":25}]

{"sheet":"فبراير","index":1,"n_rows":12,"n_cols":34,"rows_kept":12,"merged":[[1,3,1,5],[1,7,1,9],[1,11,1,12],[1,14,1,16],[1,18,1,20],[3,2,3,32]]}
[null,{"$f":"Employee_Absence_Title","v":"جدول غياب الموظفين"}]
[null,"مفتاح نوع الغياب","ع","العطلة",null,null,"ش","أسباب شخصية",null,null,"م","مرضي",null,null,"مخصص 1",{"$nulls":3},"مخصص 2"]
[]
[null,"فبراير","تواريخ الغياب",{"$nulls":30},{"$f":"CalendarYear","v":2019}]
[null,null,{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,2,1),1),\"aaa\")","v":"الجمعة"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,2,2),1),\"aaa\")","v":"السبت"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,2,3),1),\"aaa\")","v":"الأحد"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,2,4),1),\"aaa\")","v":"الإثنين"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,2,5),1),\"aaa\")","v":"الثلاثاء"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,2,6),1),\"aaa\")","v":"الأربعاء"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,2,7),1),\"aaa\")","v":"الخميس"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,2,8),1),\"aaa\")","v":"الجمعة"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,2,9),1),\"aaa\")","v":"السبت"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,2,10),1),\"aaa\")","v":"الأحد"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,2,11),1),\"aaa\")","v":"الإثنين"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,2,12),1),\"aaa\")","v":"الثلاثاء"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,2,13),1),\"aaa\")","v":"الأربعاء"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,2,14),1),\"aaa\")","v":"الخميس"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,2,15),1),\"aaa\")","v":"الجمعة"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,2,16),1),\"aaa\")","v":"السبت"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,2,17),1),\"aaa\")","v":"الأحد"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,2,18),1),\"aaa\")","v":"الإثنين"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,2,19),1),\"aaa\")","v":"الثلاثاء"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,2,20),1),\"aaa\")","v":"الأربعاء"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,2,21),1),\"aaa\")","v":"الخميس"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,2,22),1),\"aaa\")","v":"الجمعة"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,2,23),1),\"aaa\")","v":"السبت"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,2,24),1),\"aaa\")","v":"الأحد"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,2,25),1),\"aaa\")","v":"الإثنين"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,2,26),1),\"aaa\")","v":"الثلاثاء"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,2,27),1),\"aaa\")","v":"الأربعاء"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,2,28),1),\"aaa\")","v":"الخميس"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,2,29),1),\"aaa\")","v":"الجمعة"}]
[null,"اسم الموظف","1","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","27","28","29"," ","  ","إجمالي الأيام"]
[null,"الموظف 1",null,null,"ع","ع","ع","ع",{"$nulls":6},"ع",{"$nulls":18},{"$f":"COUNTA(فبراير[[#This Row],[1]:[29]])","v":5}]
[null,"الموظف 2",{"$nulls":4},"م","م",{"$nulls":4},"ش",{"$nulls":8},"م",{"$nulls":4},"ع","ع","ع",{"$nulls":4},{"$f":"COUNTA(فبراير[[#This Row],[1]:[29]])","v":7}]
[null,"الموظف 3",{"$nulls":31},{"$f":"COUNTA(فبراير[[#This Row],[1]:[29]])","v":0}]
[null,"الموظف 4",null,null,"م",{"$nulls":10},"م",{"$nulls":3},"ش",{"$nulls":9},"م",{"$nulls":3},{"$f":"COUNTA(فبراير[[#This Row],[1]:[29]])","v":4}]
[null,"الموظف 5",{"$nulls":7},"ع","ع","ع","ع",{"$nulls":12},"م",{"$nulls":7},{"$f":"COUNTA(فبراير[[#This Row],[1]:[29]])","v":5}]
[null,{"$f":"\"إجمالي شهر \"&MonthName","v":"إجمالي شهر فبراير"},{"$f":"SUBTOTAL(103,فبراير[1])","v":0},{"$f":"SUBTOTAL(103,فبراير[2])","v":0},{"$f":"SUBTOTAL(103,فبراير[3])","v":2},{"$f":"SUBTOTAL(103,فبراير[4])","v":1},{"$f":"SUBTOTAL(103,فبراير[5])","v":2},{"$f":"SUBTOTAL(103,فبراير[6])","v":2},{"$f":"SUBTOTAL(103,فبراير[7])","v":0},{"$f":"SUBTOTAL(103,فبراير[8])","v":1},{"$f":"SUBTOTAL(103,فبراير[9])","v":1},{"$f":"SUBTOTAL(103,فبراير[10])","v":1},{"$f":"SUBTOTAL(103,فبراير[11])","v":2},{"$f":"SUBTOTAL(103,فبراير[12])","v":0},{"$f":"SUBTOTAL(103,فبراير[13])","v":1},{"$f":"SUBTOTAL(103,فبراير[14])","v":1},{"$f":"SUBTOTAL(103,فبراير[15])","v":0},{"$f":"SUBTOTAL(103,فبراير[16])","v":0},{"$f":"SUBTOTAL(103,فبراير[17])","v":0},{"$f":"SUBTOTAL(103,فبراير[18])","v":1},{"$f":"SUBTOTAL(103,فبراير[19])","v":0},{"$f":"SUBTOTAL(103,فبراير[20])","v":1},{"$f":"SUBTOTAL(103,فبراير[21])","v":0},{"$f":"SUBTOTAL(103,فبراير[22])","v":0},{"$f":"SUBTOTAL(103,فبراير[23])","v":0},{"$f":"SUBTOTAL(103,فبراير[24])","v":1},{"$f":"SUBTOTAL(103,فبراير[25])","v":1},{"$f":"SUBTOTAL(103,فبراير[26])","v":1},{"$f":"SUBTOTAL(103,فبراير[27])","v":1},{"$f":"SUBTOTAL(103,فبراير[28])","v":1},{"$f":"SUBTOTAL(103,فبراير[29])","v":0},null,null,{"$f":"SUBTOTAL(109,فبراير[إجمالي الأيام])","v":21}]

{"sheet":"مارس","index":2,"n_rows":12,"n_cols":34,"rows_kept":12,"merged":[[1,3,1,5],[1,7,1,9],[1,11,1,12],[1,14,1,16],[1,18,1,20],[3,2,3,32]]}
[null,{"$f":"Employee_Absence_Title","v":"جدول غياب الموظفين"}]
[null,"مفتاح نوع الغياب","ع","العطلة",null,null,"ش","أسباب شخصية",null,null,"م","مرضي",null,null,"مخصص 1",{"$nulls":3},"مخصص 2"]
[]
[null,"مارس","تواريخ الغياب",{"$nulls":30},{"$f":"CalendarYear","v":2019}]
[null,null,{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,3,1),1),\"aaa\")","v":"الجمعة"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,3,2),1),\"aaa\")","v":"السبت"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,3,3),1),\"aaa\")","v":"الأحد"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,3,4),1),\"aaa\")","v":"الإثنين"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,3,5),1),\"aaa\")","v":"الثلاثاء"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,3,6),1),\"aaa\")","v":"الأربعاء"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,3,7),1),\"aaa\")","v":"الخميس"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,3,8),1),\"aaa\")","v":"الجمعة"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,3,9),1),\"aaa\")","v":"السبت"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,3,10),1),\"aaa\")","v":"الأحد"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,3,11),1),\"aaa\")","v":"الإثنين"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,3,12),1),\"aaa\")","v":"الثلاثاء"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,3,13),1),\"aaa\")","v":"الأربعاء"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,3,14),1),\"aaa\")","v":"الخميس"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,3,15),1),\"aaa\")","v":"الجمعة"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,3,16),1),\"aaa\")","v":"السبت"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,3,17),1),\"aaa\")","v":"الأحد"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,3,18),1),\"aaa\")","v":"الإثنين"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,3,19),1),\"aaa\")","v":"الثلاثاء"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,3,20),1),\"aaa\")","v":"الأربعاء"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,3,21),1),\"aaa\")","v":"الخميس"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,3,22),1),\"aaa\")","v":"الجمعة"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,3,23),1),\"aaa\")","v":"السبت"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,3,24),1),\"aaa\")","v":"الأحد"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,3,25),1),\"aaa\")","v":"الإثنين"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,3,26),1),\"aaa\")","v":"الثلاثاء"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,3,27),1),\"aaa\")","v":"الأربعاء"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,3,28),1),\"aaa\")","v":"الخميس"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,3,29),1),\"aaa\")","v":"الجمعة"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,3,30),1),\"aaa\")","v":"السبت"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,3,31),1),\"aaa\")","v":"الأحد"}]
[null,"اسم الموظف","1","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","27","28","29","30","31","إجمالي الأيام"]
[null,"الموظف 1",{"$nulls":31},{"$f":"COUNTA(مارس[[#This Row],[1]:[31]])","v":0}]
[null,"الموظف 2",{"$nulls":31},{"$f":"COUNTA(مارس[[#This Row],[1]:[31]])","v":0}]
[null,"الموظف 3",{"$nulls":31},{"$f":"COUNTA(مارس[[#This Row],[1]:[31]])","v":0}]
[null,"الموظف 4",{"$nulls":31},{"$f":"COUNTA(مارس[[#This Row],[1]:[31]])","v":0}]
[null,"الموظف 5",{"$nulls":31},{"$f":"COUNTA(مارس[[#This Row],[1]:[31]])","v":0}]
[null,{"$f":"\"إجمالي شهر \"&MonthName","v":"إجمالي شهر مارس"},{"$f":"SUBTOTAL(103,مارس[1])","v":0},{"$f":"SUBTOTAL(103,مارس[2])","v":0},{"$f":"SUBTOTAL(103,مارس[3])","v":0},{"$f":"SUBTOTAL(103,مارس[4])","v":0},{"$f":"SUBTOTAL(103,مارس[5])","v":0},{"$f":"SUBTOTAL(103,مارس[6])","v":0},{"$f":"SUBTOTAL(103,مارس[7])","v":0},{"$f":"SUBTOTAL(103,مارس[8])","v":0},{"$f":"SUBTOTAL(103,مارس[9])","v":0},{"$f":"SUBTOTAL(103,مارس[10])","v":0},{"$f":"SUBTOTAL(103,مارس[11])","v":0},{"$f":"SUBTOTAL(103,مارس[12])","v":0},{"$f":"SUBTOTAL(103,مارس[13])","v":0},{"$f":"SUBTOTAL(103,مارس[14])","v":0},{"$f":"SUBTOTAL(103,مارس[15])","v":0},{"$f":"SUBTOTAL(103,مارس[16])","v":0},{"$f":"SUBTOTAL(103,مارس[17])","v":0},{"$f":"SUBTOTAL(103,مارس[18])","v":0},{"$f":"SUBTOTAL(103,مارس[19])","v":0},{"$f":"SUBTOTAL(103,مارس[20])","v":0},{"$f":"SUBTOTAL(103,مارس[21])","v":0},{"$f":"SUBTOTAL(103,مارس[22])","v":0},{"$f":"SUBTOTAL(103,مارس[23])","v":0},{"$f":"SUBTOTAL(103,مارس[24])","v":0},{"$f":"SUBTOTAL(103,مارس[25])","v":0},{"$f":"SUBTOTAL(103,مارس[26])","v":0},{"$f":"SUBTOTAL(103,مارس[27])","v":0},{"$f":"SUBTOTAL(103,مارس[28])","v":0},{"$f":"SUBTOTAL(103,مارس[29])","v":0},{"$f":"SUBTOTAL(103,مارس[30])","v":0},{"$f":"SUBTOTAL(103,مارس[31])","v":0},{"$f":"SUBTOTAL(109,مارس[إجمالي الأيام])","v":0}]

{"sheet":"أبريل","index":3,"n_rows":12,"n_cols":34,"rows_kept":12,"merged":[[1,3,1,5],[1,7,1,9],[1,11,1,12],[1,14,1,16],[1,18,1,20],[3,2,3,32]]}
[null,{"$f":"Employee_Absence_Title","v":"جدول غياب الموظفين"}]
[null,"مفتاح نوع الغياب","ع","العطلة",null,null,"ش","أسباب شخصية",null,null,"م","مرضي",null,null,"مخصص 1",{"$nulls":3},"مخصص 2"]
[]
[null,"أبريل","تواريخ الغياب",{"$nulls":30},{"$f":"CalendarYear","v":2019}]
[null,null,{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,4,1),1),\"aaa\")","v":"الإثنين"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,4,2),1),\"aaa\")","v":"الثلاثاء"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,4,3),1),\"aaa\")","v":"الأربعاء"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,4,4),1),\"aaa\")","v":"الخميس"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,4,5),1),\"aaa\")","v":"الجمعة"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,4,6),1),\"aaa\")","v":"السبت"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,4,7),1),\"aaa\")","v":"الأحد"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,4,8),1),\"aaa\")","v":"الإثنين"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,4,9),1),\"aaa\")","v":"الثلاثاء"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,4,10),1),\"aaa\")","v":"الأربعاء"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,4,11),1),\"aaa\")","v":"الخميس"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,4,12),1),\"aaa\")","v":"الجمعة"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,4,13),1),\"aaa\")","v":"السبت"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,4,14),1),\"aaa\")","v":"الأحد"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,4,15),1),\"aaa\")","v":"الإثنين"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,4,16),1),\"aaa\")","v":"الثلاثاء"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,4,17),1),\"aaa\")","v":"الأربعاء"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,4,18),1),\"aaa\")","v":"الخميس"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,4,19),1),\"aaa\")","v":"الجمعة"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,4,20),1),\"aaa\")","v":"السبت"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,4,21),1),\"aaa\")","v":"الأحد"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,4,22),1),\"aaa\")","v":"الإثنين"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,4,23),1),\"aaa\")","v":"الثلاثاء"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,4,24),1),\"aaa\")","v":"الأربعاء"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,4,25),1),\"aaa\")","v":"الخميس"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,4,26),1),\"aaa\")","v":"الجمعة"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,4,27),1),\"aaa\")","v":"السبت"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,4,28),1),\"aaa\")","v":"الأحد"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,4,29),1),\"aaa\")","v":"الإثنين"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,4,30),1),\"aaa\")","v":"الثلاثاء"}]
[null,"اسم الموظف","1","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","27","28","29","30"," ","إجمالي الأيام"]
[null,"الموظف 1",{"$nulls":31},{"$f":"COUNTA(أبريل[[#This Row],[1]:[30]])","v":0}]
[null,"الموظف 2",{"$nulls":31},{"$f":"COUNTA(أبريل[[#This Row],[1]:[30]])","v":0}]
[null,"الموظف 3",{"$nulls":31},{"$f":"COUNTA(أبريل[[#This Row],[1]:[30]])","v":0}]
[null,"الموظف 4",{"$nulls":31},{"$f":"COUNTA(أبريل[[#This Row],[1]:[30]])","v":0}]
[null,"الموظف 5",{"$nulls":31},{"$f":"COUNTA(أبريل[[#This Row],[1]:[30]])","v":0}]
[null,{"$f":"\"إجمالي شهر \"&MonthName","v":"إجمالي شهر أبريل"},{"$f":"SUBTOTAL(103,أبريل[1])","v":0},{"$f":"SUBTOTAL(103,أبريل[2])","v":0},{"$f":"SUBTOTAL(103,أبريل[3])","v":0},{"$f":"SUBTOTAL(103,أبريل[4])","v":0},{"$f":"SUBTOTAL(103,أبريل[5])","v":0},{"$f":"SUBTOTAL(103,أبريل[6])","v":0},{"$f":"SUBTOTAL(103,أبريل[7])","v":0},{"$f":"SUBTOTAL(103,أبريل[8])","v":0},{"$f":"SUBTOTAL(103,أبريل[9])","v":0},{"$f":"SUBTOTAL(103,أبريل[10])","v":0},{"$f":"SUBTOTAL(103,أبريل[11])","v":0},{"$f":"SUBTOTAL(103,أبريل[12])","v":0},{"$f":"SUBTOTAL(103,أبريل[13])","v":0},{"$f":"SUBTOTAL(103,أبريل[14])","v":0},{"$f":"SUBTOTAL(103,أبريل[15])","v":0},{"$f":"SUBTOTAL(103,أبريل[16])","v":0},{"$f":"SUBTOTAL(103,أبريل[17])","v":0},{"$f":"SUBTOTAL(103,أبريل[18])","v":0},{"$f":"SUBTOTAL(103,أبريل[19])","v":0},{"$f":"SUBTOTAL(103,أبريل[20])","v":0},{"$f":"SUBTOTAL(103,أبريل[21])","v":0},{"$f":"SUBTOTAL(103,أبريل[22])","v":0},{"$f":"SUBTOTAL(103,أبريل[23])","v":0},{"$f":"SUBTOTAL(103,أبريل[24])","v":0},{"$f":"SUBTOTAL(103,أبريل[25])","v":0},{"$f":"SUBTOTAL(103,أبريل[26])","v":0},{"$f":"SUBTOTAL(103,أبريل[27])","v":0},{"$f":"SUBTOTAL(103,أبريل[28])","v":0},{"$f":"SUBTOTAL(103,أبريل[29])","v":0},{"$f":"SUBTOTAL(103,أبريل[30])","v":0},{"$f":"SUBTOTAL(103,أبريل[30])","v":0},{"$f":"SUBTOTAL(109,أبريل[إجمالي الأيام])","v":0}]

{"sheet":"مايو","index":4,"n_rows":12,"n_cols":34,"rows_kept":12,"merged":[[1,3,1,5],[1,7,1,9],[1,11,1,12],[1,14,1,16],[1,18,1,20],[3,2,3,32]]}
[null,{"$f":"Employee_Absence_Title","v":"جدول غياب الموظفين"}]
[null,"مفتاح نوع الغياب","ع","العطلة",null,null,"ش","أسباب شخصية",null,null,"م","مرضي",null,null,"مخصص 1",{"$nulls":3},"مخصص 2"]
[]
[null,"مايو","تواريخ الغياب",{"$nulls":30},{"$f":"CalendarYear","v":2019}]
[null,null,{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,5,1),1),\"aaa\")","v":"الأربعاء"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,5,2),1),\"aaa\")","v":"الخميس"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,5,3),1),\"aaa\")","v":"الجمعة"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,5,4),1),\"aaa\")","v":"السبت"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,5,5),1),\"aaa\")","v":"الأحد"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,5,6),1),\"aaa\")","v":"الإثنين"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,5,7),1),\"aaa\")","v":"الثلاثاء"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,5,8),1),\"aaa\")","v":"الأربعاء"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,5,9),1),\"aaa\")","v":"الخميس"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,5,10),1),\"aaa\")","v":"الجمعة"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,5,11),1),\"aaa\")","v":"السبت"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,5,12),1),\"aaa\")","v":"الأحد"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,5,13),1),\"aaa\")","v":"الإثنين"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,5,14),1),\"aaa\")","v":"الثلاثاء"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,5,15),1),\"aaa\")","v":"الأربعاء"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,5,16),1),\"aaa\")","v":"الخميس"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,5,17),1),\"aaa\")","v":"الجمعة"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,5,18),1),\"aaa\")","v":"السبت"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,5,19),1),\"aaa\")","v":"الأحد"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,5,20),1),\"aaa\")","v":"الإثنين"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,5,21),1),\"aaa\")","v":"الثلاثاء"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,5,22),1),\"aaa\")","v":"الأربعاء"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,5,23),1),\"aaa\")","v":"الخميس"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,5,24),1),\"aaa\")","v":"الجمعة"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,5,25),1),\"aaa\")","v":"السبت"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,5,26),1),\"aaa\")","v":"الأحد"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,5,27),1),\"aaa\")","v":"الإثنين"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,5,28),1),\"aaa\")","v":"الثلاثاء"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,5,29),1),\"aaa\")","v":"الأربعاء"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,5,30),1),\"aaa\")","v":"الخميس"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,5,31),1),\"aaa\")","v":"الجمعة"}]
[null,"اسم الموظف","1","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","27","28","29","30","31","إجمالي الأيام"]
[null,"الموظف 1",{"$nulls":31},{"$f":"COUNTA(مايو[[#This Row],[1]:[31]])","v":0}]
[null,"الموظف 2",{"$nulls":31},{"$f":"COUNTA(مايو[[#This Row],[1]:[31]])","v":0}]
[null,"الموظف 3",{"$nulls":31},{"$f":"COUNTA(مايو[[#This Row],[1]:[31]])","v":0}]
[null,"الموظف 4",{"$nulls":31},{"$f":"COUNTA(مايو[[#This Row],[1]:[31]])","v":0}]
[null,"الموظف 5",{"$nulls":31},{"$f":"COUNTA(مايو[[#This Row],[1]:[31]])","v":0}]
[null,{"$f":"\"إجمالي شهر \"&MonthName","v":"إجمالي شهر مايو"},{"$f":"SUBTOTAL(103,مايو[1])","v":0},{"$f":"SUBTOTAL(103,مايو[2])","v":0},{"$f":"SUBTOTAL(103,مايو[3])","v":0},{"$f":"SUBTOTAL(103,مايو[4])","v":0},{"$f":"SUBTOTAL(103,مايو[5])","v":0},{"$f":"SUBTOTAL(103,مايو[6])","v":0},{"$f":"SUBTOTAL(103,مايو[7])","v":0},{"$f":"SUBTOTAL(103,مايو[8])","v":0},{"$f":"SUBTOTAL(103,مايو[9])","v":0},{"$f":"SUBTOTAL(103,مايو[10])","v":0},{"$f":"SUBTOTAL(103,مايو[11])","v":0},{"$f":"SUBTOTAL(103,مايو[12])","v":0},{"$f":"SUBTOTAL(103,مايو[13])","v":0},{"$f":"SUBTOTAL(103,مايو[14])","v":0},{"$f":"SUBTOTAL(103,مايو[15])","v":0},{"$f":"SUBTOTAL(103,مايو[16])","v":0},{"$f":"SUBTOTAL(103,مايو[17])","v":0},{"$f":"SUBTOTAL(103,مايو[18])","v":0},{"$f":"SUBTOTAL(103,مايو[19])","v":0},{"$f":"SUBTOTAL(103,مايو[20])","v":0},{"$f":"SUBTOTAL(103,مايو[21])","v":0},{"$f":"SUBTOTAL(103,مايو[22])","v":0},{"$f":"SUBTOTAL(103,مايو[23])","v":0},{"$f":"SUBTOTAL(103,مايو[24])","v":0},{"$f":"SUBTOTAL(103,مايو[25])","v":0},{"$f":"SUBTOTAL(103,مايو[26])","v":0},{"$f":"SUBTOTAL(103,مايو[27])","v":0},{"$f":"SUBTOTAL(103,مايو[28])","v":0},{"$f":"SUBTOTAL(103,مايو[29])","v":0},{"$f":"SUBTOTAL(103,مايو[30])","v":0},{"$f":"SUBTOTAL(103,مايو[31])","v":0},{"$f":"SUBTOTAL(109,مايو[إجمالي الأيام])","v":0}]

{"sheet":"يونيو","index":5,"n_rows":12,"n_cols":34,"rows_kept":12,"merged":[[1,3,1,5],[1,7,1,9],[1,11,1,12],[1,14,1,16],[1,18,1,20],[3,2,3,32]]}
[null,{"$f":"Employee_Absence_Title","v":"جدول غياب الموظفين"}]
[null,"مفتاح نوع الغياب","ع","العطلة",null,null,"ش","أسباب شخصية",null,null,"م","مرضي",null,null,"مخصص 1",{"$nulls":3},"مخصص 2"]
[]
[null,"يونيو","تواريخ الغياب",{"$nulls":30},{"$f":"CalendarYear","v":2019}]
[null,null,{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,6,1),1),\"aaa\")","v":"السبت"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,6,2),1),\"aaa\")","v":"الأحد"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,6,3),1),\"aaa\")","v":"الإثنين"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,6,4),1),\"aaa\")","v":"الثلاثاء"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,6,5),1),\"aaa\")","v":"الأربعاء"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,6,6),1),\"aaa\")","v":"الخميس"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,6,7),1),\"aaa\")","v":"الجمعة"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,6,8),1),\"aaa\")","v":"السبت"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,6,9),1),\"aaa\")","v":"الأحد"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,6,10),1),\"aaa\")","v":"الإثنين"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,6,11),1),\"aaa\")","v":"الثلاثاء"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,6,12),1),\"aaa\")","v":"الأربعاء"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,6,13),1),\"aaa\")","v":"الخميس"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,6,14),1),\"aaa\")","v":"الجمعة"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,6,15),1),\"aaa\")","v":"السبت"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,6,16),1),\"aaa\")","v":"الأحد"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,6,17),1),\"aaa\")","v":"الإثنين"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,6,18),1),\"aaa\")","v":"الثلاثاء"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,6,19),1),\"aaa\")","v":"الأربعاء"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,6,20),1),\"aaa\")","v":"الخميس"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,6,21),1),\"aaa\")","v":"الجمعة"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,6,22),1),\"aaa\")","v":"السبت"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,6,23),1),\"aaa\")","v":"الأحد"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,6,24),1),\"aaa\")","v":"الإثنين"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,6,25),1),\"aaa\")","v":"الثلاثاء"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,6,26),1),\"aaa\")","v":"الأربعاء"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,6,27),1),\"aaa\")","v":"الخميس"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,6,28),1),\"aaa\")","v":"الجمعة"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,6,29),1),\"aaa\")","v":"السبت"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,6,30),1),\"aaa\")","v":"الأحد"}]
[null,"اسم الموظف","1","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","27","28","29","30"," ","إجمالي الأيام"]
[null,"الموظف 1",{"$nulls":31},{"$f":"COUNTA(يونيو[[#This Row],[1]:[30]])","v":0}]
[null,"الموظف 2",{"$nulls":31},{"$f":"COUNTA(يونيو[[#This Row],[1]:[30]])","v":0}]
[null,"الموظف 3",{"$nulls":31},{"$f":"COUNTA(يونيو[[#This Row],[1]:[30]])","v":0}]
[null,"الموظف 4",{"$nulls":31},{"$f":"COUNTA(يونيو[[#This Row],[1]:[30]])","v":0}]
[null,"الموظف 5",{"$nulls":31},{"$f":"COUNTA(يونيو[[#This Row],[1]:[30]])","v":0}]
[null,{"$f":"\"إجمالي شهر \"&MonthName","v":"إجمالي شهر يونيو"},{"$f":"SUBTOTAL(103,يونيو[1])","v":0},{"$f":"SUBTOTAL(103,يونيو[2])","v":0},{"$f":"SUBTOTAL(103,يونيو[3])","v":0},{"$f":"SUBTOTAL(103,يونيو[4])","v":0},{"$f":"SUBTOTAL(103,يونيو[5])","v":0},{"$f":"SUBTOTAL(103,يونيو[6])","v":0},{"$f":"SUBTOTAL(103,يونيو[7])","v":0},{"$f":"SUBTOTAL(103,يونيو[8])","v":0},{"$f":"SUBTOTAL(103,يونيو[9])","v":0},{"$f":"SUBTOTAL(103,يونيو[10])","v":0},{"$f":"SUBTOTAL(103,يونيو[11])","v":0},{"$f":"SUBTOTAL(103,يونيو[12])","v":0},{"$f":"SUBTOTAL(103,يونيو[13])","v":0},{"$f":"SUBTOTAL(103,يونيو[14])","v":0},{"$f":"SUBTOTAL(103,يونيو[15])","v":0},{"$f":"SUBTOTAL(103,يونيو[16])","v":0},{"$f":"SUBTOTAL(103,يونيو[17])","v":0},{"$f":"SUBTOTAL(103,يونيو[18])","v":0},{"$f":"SUBTOTAL(103,يونيو[19])","v":0},{"$f":"SUBTOTAL(103,يونيو[20])","v":0},{"$f":"SUBTOTAL(103,يونيو[21])","v":0},{"$f":"SUBTOTAL(103,يونيو[22])","v":0},{"$f":"SUBTOTAL(103,يونيو[23])","v":0},{"$f":"SUBTOTAL(103,يونيو[24])","v":0},{"$f":"SUBTOTAL(103,يونيو[25])","v":0},{"$f":"SUBTOTAL(103,يونيو[26])","v":0},{"$f":"SUBTOTAL(103,يونيو[27])","v":0},{"$f":"SUBTOTAL(103,يونيو[28])","v":0},{"$f":"SUBTOTAL(103,يونيو[29])","v":0},{"$f":"SUBTOTAL(103,يونيو[30])","v":0},{"$f":"SUBTOTAL(103,يونيو[[ ]])","v":0},{"$f":"SUBTOTAL(109,يونيو[إجمالي الأيام])","v":0}]

{"sheet":"يوليو","index":6,"n_rows":12,"n_cols":34,"rows_kept":12,"merged":[[1,3,1,5],[1,7,1,9],[1,11,1,12],[1,14,1,16],[1,18,1,20],[3,2,3,32]]}
[null,{"$f":"Employee_Absence_Title","v":"جدول غياب الموظفين"}]
[null,"مفتاح نوع الغياب","ع","العطلة",null,null,"ش","أسباب شخصية",null,null,"م","مرضي",null,null,"مخصص 1",{"$nulls":3},"مخصص 2"]
[]
[null,"يوليو","تواريخ الغياب",{"$nulls":30},{"$f":"CalendarYear","v":2019}]
[null,null,{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,7,1),1),\"aaa\")","v":"الإثنين"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,7,2),1),\"aaa\")","v":"الثلاثاء"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,7,3),1),\"aaa\")","v":"الأربعاء"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,7,4),1),\"aaa\")","v":"الخميس"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,7,5),1),\"aaa\")","v":"الجمعة"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,7,6),1),\"aaa\")","v":"السبت"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,7,7),1),\"aaa\")","v":"الأحد"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,7,8),1),\"aaa\")","v":"الإثنين"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,7,9),1),\"aaa\")","v":"الثلاثاء"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,7,10),1),\"aaa\")","v":"الأربعاء"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,7,11),1),\"aaa\")","v":"الخميس"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,7,12),1),\"aaa\")","v":"الجمعة"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,7,13),1),\"aaa\")","v":"السبت"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,7,14),1),\"aaa\")","v":"الأحد"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,7,15),1),\"aaa\")","v":"الإثنين"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,7,16),1),\"aaa\")","v":"الثلاثاء"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,7,17),1),\"aaa\")","v":"الأربعاء"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,7,18),1),\"aaa\")","v":"الخميس"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,7,19),1),\"aaa\")","v":"الجمعة"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,7,20),1),\"aaa\")","v":"السبت"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,7,21),1),\"aaa\")","v":"الأحد"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,7,22),1),\"aaa\")","v":"الإثنين"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,7,23),1),\"aaa\")","v":"الثلاثاء"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,7,24),1),\"aaa\")","v":"الأربعاء"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,7,25),1),\"aaa\")","v":"الخميس"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,7,26),1),\"aaa\")","v":"الجمعة"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,7,27),1),\"aaa\")","v":"السبت"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,7,28),1),\"aaa\")","v":"الأحد"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,7,29),1),\"aaa\")","v":"الإثنين"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,7,30),1),\"aaa\")","v":"الثلاثاء"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,7,31),1),\"aaa\")","v":"الأربعاء"}]
[null,"اسم الموظف","1","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","27","28","29","30","31","إجمالي الأيام"]
[null,"الموظف 1",{"$nulls":31},{"$f":"COUNTA(يوليو[[#This Row],[1]:[31]])","v":0}]
[null,"الموظف 2",{"$nulls":31},{"$f":"COUNTA(يوليو[[#This Row],[1]:[31]])","v":0}]
[null,"الموظف 3",{"$nulls":31},{"$f":"COUNTA(يوليو[[#This Row],[1]:[31]])","v":0}]
[null,"الموظف 4",{"$nulls":31},{"$f":"COUNTA(يوليو[[#This Row],[1]:[31]])","v":0}]
[null,"الموظف 5",{"$nulls":31},{"$f":"COUNTA(يوليو[[#This Row],[1]:[31]])","v":0}]
[null,{"$f":"\"إجمالي شهر \"&MonthName","v":"إجمالي شهر يوليو"},{"$f":"SUBTOTAL(103,يوليو[1])","v":0},{"$f":"SUBTOTAL(103,يوليو[2])","v":0},{"$f":"SUBTOTAL(103,يوليو[3])","v":0},{"$f":"SUBTOTAL(103,يوليو[4])","v":0},{"$f":"SUBTOTAL(103,يوليو[5])","v":0},{"$f":"SUBTOTAL(103,يوليو[6])","v":0},{"$f":"SUBTOTAL(103,يوليو[7])","v":0},{"$f":"SUBTOTAL(103,يوليو[8])","v":0},{"$f":"SUBTOTAL(103,يوليو[9])","v":0},{"$f":"SUBTOTAL(103,يوليو[10])","v":0},{"$f":"SUBTOTAL(103,يوليو[11])","v":0},{"$f":"SUBTOTAL(103,يوليو[12])","v":0},{"$f":"SUBTOTAL(103,يوليو[13])","v":0},{"$f":"SUBTOTAL(103,يوليو[14])","v":0},{"$f":"SUBTOTAL(103,يوليو[15])","v":0},{"$f":"SUBTOTAL(103,يوليو[16])","v":0},{"$f":"SUBTOTAL(103,يوليو[17])","v":0},{"$f":"SUBTOTAL(103,يوليو[18])","v":0},{"$f":"SUBTOTAL(103,يوليو[19])","v":0},{"$f":"SUBTOTAL(103,يوليو[20])","v":0},{"$f":"SUBTOTAL(103,يوليو[21])","v":0},{"$f":"SUBTOTAL(103,يوليو[22])","v":0},{"$f":"SUBTOTAL(103,يوليو[23])","v":0},{"$f":"SUBTOTAL(103,يوليو[24])","v":0},{"$f":"SUBTOTAL(103,يوليو[25])","v":0},{"$f":"SUBTOTAL(103,يوليو[26])","v":0},{"$f":"SUBTOTAL(103,يوليو[27])","v":0},{"$f":"SUBTOTAL(103,يوليو[28])","v":0},{"$f":"SUBTOTAL(103,يوليو[29])","v":0},{"$f":"SUBTOTAL(103,يوليو[30])","v":0},{"$f":"SUBTOTAL(103,يوليو[31])","v":0},{"$f":"SUBTOTAL(109,يوليو[إجمالي الأيام])","v":0}]

{"sheet":"أغسطس","index":7,"n_rows":12,"n_cols":34,"rows_kept":12,"merged":[[1,3,1,5],[1,7,1,9],[1,11,1,12],[1,14,1,16],[1,18,1,20],[3,2,3,32]]}
[null,{"$f":"Employee_Absence_Title","v":"جدول غياب الموظفين"}]
[null,"مفتاح نوع الغياب","ع","العطلة",null,null,"ش","أسباب شخصية",null,null,"م","مرضي",null,null,"مخصص 1",{"$nulls":3},"مخصص 2"]
[]
[null,"أغسطس","تواريخ الغياب",{"$nulls":30},{"$f":"CalendarYear","v":2019}]
[null,null,{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,8,1),1),\"aaa\")","v":"الخميس"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,8,2),1),\"aaa\")","v":"الجمعة"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,8,3),1),\"aaa\")","v":"السبت"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,8,4),1),\"aaa\")","v":"الأحد"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,8,5),1),\"aaa\")","v":"الإثنين"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,8,6),1),\"aaa\")","v":"الثلاثاء"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,8,7),1),\"aaa\")","v":"الأربعاء"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,8,8),1),\"aaa\")","v":"الخميس"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,8,9),1),\"aaa\")","v":"الجمعة"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,8,10),1),\"aaa\")","v":"السبت"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,8,11),1),\"aaa\")","v":"الأحد"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,8,12),1),\"aaa\")","v":"الإثنين"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,8,13),1),\"aaa\")","v":"الثلاثاء"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,8,14),1),\"aaa\")","v":"الأربعاء"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,8,15),1),\"aaa\")","v":"الخميس"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,8,16),1),\"aaa\")","v":"الجمعة"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,8,17),1),\"aaa\")","v":"السبت"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,8,18),1),\"aaa\")","v":"الأحد"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,8,19),1),\"aaa\")","v":"الإثنين"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,8,20),1),\"aaa\")","v":"الثلاثاء"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,8,21),1),\"aaa\")","v":"الأربعاء"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,8,22),1),\"aaa\")","v":"الخميس"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,8,23),1),\"aaa\")","v":"الجمعة"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,8,24),1),\"aaa\")","v":"السبت"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,8,25),1),\"aaa\")","v":"الأحد"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,8,26),1),\"aaa\")","v":"الإثنين"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,8,27),1),\"aaa\")","v":"الثلاثاء"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,8,28),1),\"aaa\")","v":"الأربعاء"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,8,29),1),\"aaa\")","v":"الخميس"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,8,30),1),\"aaa\")","v":"الجمعة"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,8,31),1),\"aaa\")","v":"السبت"}]
[null,"اسم الموظف","1","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","27","28","29","30","31","إجمالي الأيام"]
[null,"الموظف 1",{"$nulls":31},{"$f":"COUNTA(أغسطس[[#This Row],[1]:[31]])","v":0}]
[null,"الموظف 2",{"$nulls":31},{"$f":"COUNTA(أغسطس[[#This Row],[1]:[31]])","v":0}]
[null,"الموظف 3",{"$nulls":31},{"$f":"COUNTA(أغسطس[[#This Row],[1]:[31]])","v":0}]
[null,"الموظف 4",{"$nulls":31},{"$f":"COUNTA(أغسطس[[#This Row],[1]:[31]])","v":0}]
[null,"الموظف 5",{"$nulls":31},{"$f":"COUNTA(أغسطس[[#This Row],[1]:[31]])","v":0}]
[null,{"$f":"\"إجمالي شهر \"&MonthName","v":"إجمالي شهر أغسطس"},{"$f":"SUBTOTAL(103,أغسطس[1])","v":0},{"$f":"SUBTOTAL(103,أغسطس[2])","v":0},{"$f":"SUBTOTAL(103,أغسطس[3])","v":0},{"$f":"SUBTOTAL(103,أغسطس[4])","v":0},{"$f":"SUBTOTAL(103,أغسطس[5])","v":0},{"$f":"SUBTOTAL(103,أغسطس[6])","v":0},{"$f":"SUBTOTAL(103,أغسطس[7])","v":0},{"$f":"SUBTOTAL(103,أغسطس[8])","v":0},{"$f":"SUBTOTAL(103,أغسطس[9])","v":0},{"$f":"SUBTOTAL(103,أغسطس[10])","v":0},{"$f":"SUBTOTAL(103,أغسطس[11])","v":0},{"$f":"SUBTOTAL(103,أغسطس[12])","v":0},{"$f":"SUBTOTAL(103,أغسطس[13])","v":0},{"$f":"SUBTOTAL(103,أغسطس[14])","v":0},{"$f":"SUBTOTAL(103,أغسطس[15])","v":0},{"$f":"SUBTOTAL(103,أغسطس[16])","v":0},{"$f":"SUBTOTAL(103,أغسطس[17])","v":0},{"$f":"SUBTOTAL(103,أغسطس[18])","v":0},{"$f":"SUBTOTAL(103,أغسطس[19])","v":0},{"$f":"SUBTOTAL(103,أغسطس[20])","v":0},{"$f":"SUBTOTAL(103,أغسطس[21])","v":0},{"$f":"SUBTOTAL(103,أغسطس[22])","v":0},{"$f":"SUBTOTAL(103,أغسطس[23])","v":0},{"$f":"SUBTOTAL(103,أغسطس[24])","v":0},{"$f":"SUBTOTAL(103,أغسطس[25])","v":0},{"$f":"SUBTOTAL(103,أغسطس[26])","v":0},{"$f":"SUBTOTAL(103,أغسطس[27])","v":0},{"$f":"SUBTOTAL(103,أغسطس[28])","v":0},{"$f":"SUBTOTAL(103,أغسطس[29])","v":0},{"$f":"SUBTOTAL(103,أغسطس[30])","v":0},{"$f":"SUBTOTAL(103,أغسطس[31])","v":0},{"$f":"SUBTOTAL(109,أغسطس[إجمالي الأيام])","v":0}]

{"sheet":"سبتمبر","index":8,"n_rows":12,"n_cols":34,"rows_kept":12,"merged":[[1,3,1,5],[1,7,1,9],[1,11,1,12],[1,14,1,16],[1,18,1,20],[3,2,3,32]]}
[null,{"$f":"Employee_Absence_Title","v":"جدول غياب الموظفين"}]
[null,"مفتاح نوع الغياب","ع","العطلة",null,null,"ش","أسباب شخصية",null,null,"م","مرضي",null,null,"مخصص 1",{"$nulls":3},"مخصص 2"]
[]
[null,"سبتمبر","تواريخ الغياب",{"$nulls":30},{"$f":"CalendarYear","v":2019}]
[null,null,{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,9,1),1),\"aaa\")","v":"الأحد"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,9,2),1),\"aaa\")","v":"الإثنين"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,9,3),1),\"aaa\")","v":"الثلاثاء"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,9,4),1),\"aaa\")","v":"الأربعاء"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,9,5),1),\"aaa\")","v":"الخميس"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,9,6),1),\"aaa\")","v":"الجمعة"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,9,7),1),\"aaa\")","v":"السبت"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,9,8),1),\"aaa\")","v":"الأحد"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,9,9),1),\"aaa\")","v":"الإثنين"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,9,10),1),\"aaa\")","v":"الثلاثاء"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,9,11),1),\"aaa\")","v":"الأربعاء"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,9,12),1),\"aaa\")","v":"الخميس"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,9,13),1),\"aaa\")","v":"الجمعة"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,9,14),1),\"aaa\")","v":"السبت"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,9,15),1),\"aaa\")","v":"الأحد"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,9,16),1),\"aaa\")","v":"الإثنين"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,9,17),1),\"aaa\")","v":"الثلاثاء"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,9,18),1),\"aaa\")","v":"الأربعاء"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,9,19),1),\"aaa\")","v":"الخميس"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,9,20),1),\"aaa\")","v":"الجمعة"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,9,21),1),\"aaa\")","v":"السبت"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,9,22),1),\"aaa\")","v":"الأحد"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,9,23),1),\"aaa\")","v":"الإثنين"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,9,24),1),\"aaa\")","v":"الثلاثاء"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,9,25),1),\"aaa\")","v":"الأربعاء"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,9,26),1),\"aaa\")","v":"الخميس"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,9,27),1),\"aaa\")","v":"الجمعة"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,9,28),1),\"aaa\")","v":"السبت"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,9,29),1),\"aaa\")","v":"الأحد"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,9,30),1),\"aaa\")","v":"الإثنين"}]
[null,"اسم الموظف","1","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","27","28","29","30"," ","إجمالي الأيام"]
[null,"الموظف 1",{"$nulls":31},{"$f":"COUNTA(سبتمبر[[#This Row],[1]:[30]])","v":0}]
[null,"الموظف 2",{"$nulls":31},{"$f":"COUNTA(سبتمبر[[#This Row],[1]:[30]])","v":0}]
[null,"الموظف 3",{"$nulls":31},{"$f":"COUNTA(سبتمبر[[#This Row],[1]:[30]])","v":0}]
[null,"الموظف 4",{"$nulls":31},{"$f":"COUNTA(سبتمبر[[#This Row],[1]:[30]])","v":0}]
[null,"الموظف 5",{"$nulls":31},{"$f":"COUNTA(سبتمبر[[#This Row],[1]:[30]])","v":0}]
[null,{"$f":"\"إجمالي شهر \"&MonthName","v":"إجمالي شهر سبتمبر"},{"$f":"SUBTOTAL(103,سبتمبر[1])","v":0},{"$f":"SUBTOTAL(103,سبتمبر[2])","v":0},{"$f":"SUBTOTAL(103,سبتمبر[3])","v":0},{"$f":"SUBTOTAL(103,سبتمبر[4])","v":0},{"$f":"SUBTOTAL(103,سبتمبر[5])","v":0},{"$f":"SUBTOTAL(103,سبتمبر[6])","v":0},{"$f":"SUBTOTAL(103,سبتمبر[7])","v":0},{"$f":"SUBTOTAL(103,سبتمبر[8])","v":0},{"$f":"SUBTOTAL(103,سبتمبر[9])","v":0},{"$f":"SUBTOTAL(103,سبتمبر[10])","v":0},{"$f":"SUBTOTAL(103,سبتمبر[11])","v":0},{"$f":"SUBTOTAL(103,سبتمبر[12])","v":0},{"$f":"SUBTOTAL(103,سبتمبر[13])","v":0},{"$f":"SUBTOTAL(103,سبتمبر[14])","v":0},{"$f":"SUBTOTAL(103,سبتمبر[15])","v":0},{"$f":"SUBTOTAL(103,سبتمبر[16])","v":0},{"$f":"SUBTOTAL(103,سبتمبر[17])","v":0},{"$f":"SUBTOTAL(103,سبتمبر[18])","v":0},{"$f":"SUBTOTAL(103,سبتمبر[19])","v":0},{"$f":"SUBTOTAL(103,سبتمبر[20])","v":0},{"$f":"SUBTOTAL(103,سبتمبر[21])","v":0},{"$f":"SUBTOTAL(103,سبتمبر[22])","v":0},{"$f":"SUBTOTAL(103,سبتمبر[23])","v":0},{"$f":"SUBTOTAL(103,سبتمبر[24])","v":0},{"$f":"SUBTOTAL(103,سبتمبر[25])","v":0},{"$f":"SUBTOTAL(103,سبتمبر[26])","v":0},{"$f":"SUBTOTAL(103,سبتمبر[27])","v":0},{"$f":"SUBTOTAL(103,سبتمبر[28])","v":0},{"$f":"SUBTOTAL(103,سبتمبر[29])","v":0},{"$f":"SUBTOTAL(103,سبتمبر[30])","v":0},{"$f":"SUBTOTAL(103,سبتمبر[[ ]])","v":0},{"$f":"SUBTOTAL(109,سبتمبر[إجمالي الأيام])","v":0}]

{"sheet":"أكتوبر","index":9,"n_rows":12,"n_cols":34,"rows_kept":12,"merged":[[1,3,1,5],[1,7,1,9],[1,11,1,12],[1,14,1,16],[1,18,1,20],[3,2,3,32]]}
[null,{"$f":"Employee_Absence_Title","v":"جدول غياب الموظفين"}]
[null,"مفتاح نوع الغياب","ع","العطلة",null,null,"ش","أسباب شخصية",null,null,"م","مرضي",null,null,"مخصص 1",{"$nulls":3},"مخصص 2"]
[]
[null,"أكتوبر","تواريخ الغياب",{"$nulls":30},{"$f":"CalendarYear","v":2019}]
[null,null,{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,10,1),1),\"aaa\")","v":"الثلاثاء"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,10,2),1),\"aaa\")","v":"الأربعاء"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,10,3),1),\"aaa\")","v":"الخميس"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,10,4),1),\"aaa\")","v":"الجمعة"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,10,5),1),\"aaa\")","v":"السبت"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,10,6),1),\"aaa\")","v":"الأحد"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,10,7),1),\"aaa\")","v":"الإثنين"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,10,8),1),\"aaa\")","v":"الثلاثاء"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,10,9),1),\"aaa\")","v":"الأربعاء"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,10,10),1),\"aaa\")","v":"الخميس"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,10,11),1),\"aaa\")","v":"الجمعة"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,10,12),1),\"aaa\")","v":"السبت"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,10,13),1),\"aaa\")","v":"الأحد"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,10,14),1),\"aaa\")","v":"الإثنين"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,10,15),1),\"aaa\")","v":"الثلاثاء"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,10,16),1),\"aaa\")","v":"الأربعاء"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,10,17),1),\"aaa\")","v":"الخميس"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,10,18),1),\"aaa\")","v":"الجمعة"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,10,19),1),\"aaa\")","v":"السبت"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,10,20),1),\"aaa\")","v":"الأحد"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,10,21),1),\"aaa\")","v":"الإثنين"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,10,22),1),\"aaa\")","v":"الثلاثاء"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,10,23),1),\"aaa\")","v":"الأربعاء"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,10,24),1),\"aaa\")","v":"الخميس"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,10,25),1),\"aaa\")","v":"الجمعة"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,10,26),1),\"aaa\")","v":"السبت"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,10,27),1),\"aaa\")","v":"الأحد"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,10,28),1),\"aaa\")","v":"الإثنين"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,10,29),1),\"aaa\")","v":"الثلاثاء"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,10,30),1),\"aaa\")","v":"الأربعاء"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,10,31),1),\"aaa\")","v":"الخميس"}]
[null,"اسم الموظف","1","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","27","28","29","30","31","إجمالي الأيام"]
[null,"الموظف 1",{"$nulls":31},{"$f":"COUNTA(أكتوبر[[#This Row],[1]:[31]])","v":0}]
[null,"الموظف 2",{"$nulls":31},{"$f":"COUNTA(أكتوبر[[#This Row],[1]:[31]])","v":0}]
[null,"الموظف 3",{"$nulls":31},{"$f":"COUNTA(أكتوبر[[#This Row],[1]:[31]])","v":0}]
[null,"الموظف 4",{"$nulls":31},{"$f":"COUNTA(أكتوبر[[#This Row],[1]:[31]])","v":0}]
[null,"الموظف 5",{"$nulls":31},{"$f":"COUNTA(أكتوبر[[#This Row],[1]:[31]])","v":0}]
[null,{"$f":"\"إجمالي شهر \"&MonthName","v":"إجمالي شهر أكتوبر"},{"$f":"SUBTOTAL(103,أكتوبر[1])","v":0},{"$f":"SUBTOTAL(103,أكتوبر[2])","v":0},{"$f":"SUBTOTAL(103,أكتوبر[3])","v":0},{"$f":"SUBTOTAL(103,أكتوبر[4])","v":0},{"$f":"SUBTOTAL(103,أكتوبر[5])","v":0},{"$f":"SUBTOTAL(103,أكتوبر[6])","v":0},{"$f":"SUBTOTAL(103,أكتوبر[7])","v":0},{"$f":"SUBTOTAL(103,أكتوبر[8])","v":0},{"$f":"SUBTOTAL(103,أكتوبر[9])","v":0},{"$f":"SUBTOTAL(103,أكتوبر[10])","v":0},{"$f":"SUBTOTAL(103,أكتوبر[11])","v":0},{"$f":"SUBTOTAL(103,أكتوبر[12])","v":0},{"$f":"SUBTOTAL(103,أكتوبر[13])","v":0},{"$f":"SUBTOTAL(103,أكتوبر[14])","v":0},{"$f":"SUBTOTAL(103,أكتوبر[15])","v":0},{"$f":"SUBTOTAL(103,أكتوبر[16])","v":0},{"$f":"SUBTOTAL(103,أكتوبر[17])","v":0},{"$f":"SUBTOTAL(103,أكتوبر[18])","v":0},{"$f":"SUBTOTAL(103,أكتوبر[19])","v":0},{"$f":"SUBTOTAL(103,أكتوبر[20])","v":0},{"$f":"SUBTOTAL(103,أكتوبر[21])","v":0},{"$f":"SUBTOTAL(103,أكتوبر[22])","v":0},{"$f":"SUBTOTAL(103,أكتوبر[23])","v":0},{"$f":"SUBTOTAL(103,أكتوبر[24])","v":0},{"$f":"SUBTOTAL(103,أكتوبر[25])","v":0},{"$f":"SUBTOTAL(103,أكتوبر[26])","v":0},{"$f":"SUBTOTAL(103,أكتوبر[27])","v":0},{"$f":"SUBTOTAL(103,أكتوبر[28])","v":0},{"$f":"SUBTOTAL(103,أكتوبر[29])","v":0},{"$f":"SUBTOTAL(103,أكتوبر[30])","v":0},{"$f":"SUBTOTAL(103,أكتوبر[31])","v":0},{"$f":"SUBTOTAL(109,أكتوبر[إجمالي الأيام])","v":0}]

{"sheet":"نوفمبر","index":10,"n_rows":12,"n_cols":34,"rows_kept":12,"merged":[[1,3,1,5],[1,7,1,9],[1,11,1,12],[1,14,1,16],[1,18,1,20],[3,2,3,32]]}
[null,{"$f":"Employee_Absence_Title","v":"جدول غياب الموظفين"}]
[null,"مفتاح نوع الغياب","ع","العطلة",null,null,"ش","أسباب شخصية",null,null,"م","مرضي",null,null,"مخصص 1",{"$nulls":3},"مخصص 2"]
[]
[null,"نوفمبر","تواريخ الغياب",{"$nulls":30},{"$f":"CalendarYear","v":2019}]
[null,null,{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,11,1),1),\"aaa\")","v":"الجمعة"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,11,2),1),\"aaa\")","v":"السبت"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,11,3),1),\"aaa\")","v":"الأحد"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,11,4),1),\"aaa\")","v":"الإثنين"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,11,5),1),\"aaa\")","v":"الثلاثاء"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,11,6),1),\"aaa\")","v":"الأربعاء"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,11,7),1),\"aaa\")","v":"الخميس"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,11,8),1),\"aaa\")","v":"الجمعة"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,11,9),1),\"aaa\")","v":"السبت"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,11,10),1),\"aaa\")","v":"الأحد"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,11,11),1),\"aaa\")","v":"الإثنين"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,11,12),1),\"aaa\")","v":"الثلاثاء"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,11,13),1),\"aaa\")","v":"الأربعاء"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,11,14),1),\"aaa\")","v":"الخميس"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,11,15),1),\"aaa\")","v":"الجمعة"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,11,16),1),\"aaa\")","v":"السبت"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,11,17),1),\"aaa\")","v":"الأحد"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,11,18),1),\"aaa\")","v":"الإثنين"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,11,19),1),\"aaa\")","v":"الثلاثاء"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,11,20),1),\"aaa\")","v":"الأربعاء"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,11,21),1),\"aaa\")","v":"الخميس"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,11,22),1),\"aaa\")","v":"الجمعة"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,11,23),1),\"aaa\")","v":"السبت"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,11,24),1),\"aaa\")","v":"الأحد"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,11,25),1),\"aaa\")","v":"الإثنين"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,11,26),1),\"aaa\")","v":"الثلاثاء"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,11,27),1),\"aaa\")","v":"الأربعاء"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,11,28),1),\"aaa\")","v":"الخميس"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,11,29),1),\"aaa\")","v":"الجمعة"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,11,30),1),\"aaa\")","v":"السبت"}]
[null,"اسم الموظف","1","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","27","28","29","30"," ","إجمالي الأيام"]
[null,"الموظف 1",{"$nulls":31},{"$f":"COUNTA(نوفمبر[[#This Row],[1]:[30]])","v":0}]
[null,"الموظف 2",{"$nulls":31},{"$f":"COUNTA(نوفمبر[[#This Row],[1]:[30]])","v":0}]
[null,"الموظف 3",{"$nulls":31},{"$f":"COUNTA(نوفمبر[[#This Row],[1]:[30]])","v":0}]
[null,"الموظف 4",{"$nulls":31},{"$f":"COUNTA(نوفمبر[[#This Row],[1]:[30]])","v":0}]
[null,"الموظف 5",{"$nulls":31},{"$f":"COUNTA(نوفمبر[[#This Row],[1]:[30]])","v":0}]
[null,{"$f":"\"إجمالي شهر \"&MonthName","v":"إجمالي شهر نوفمبر"},{"$f":"SUBTOTAL(103,نوفمبر[1])","v":0},{"$f":"SUBTOTAL(103,نوفمبر[2])","v":0},{"$f":"SUBTOTAL(103,نوفمبر[3])","v":0},{"$f":"SUBTOTAL(103,نوفمبر[4])","v":0},{"$f":"SUBTOTAL(103,نوفمبر[5])","v":0},{"$f":"SUBTOTAL(103,نوفمبر[6])","v":0},{"$f":"SUBTOTAL(103,نوفمبر[7])","v":0},{"$f":"SUBTOTAL(103,نوفمبر[8])","v":0},{"$f":"SUBTOTAL(103,نوفمبر[9])","v":0},{"$f":"SUBTOTAL(103,نوفمبر[10])","v":0},{"$f":"SUBTOTAL(103,نوفمبر[11])","v":0},{"$f":"SUBTOTAL(103,نوفمبر[12])","v":0},{"$f":"SUBTOTAL(103,نوفمبر[13])","v":0},{"$f":"SUBTOTAL(103,نوفمبر[14])","v":0},{"$f":"SUBTOTAL(103,نوفمبر[15])","v":0},{"$f":"SUBTOTAL(103,نوفمبر[16])","v":0},{"$f":"SUBTOTAL(103,نوفمبر[17])","v":0},{"$f":"SUBTOTAL(103,نوفمبر[18])","v":0},{"$f":"SUBTOTAL(103,نوفمبر[19])","v":0},{"$f":"SUBTOTAL(103,نوفمبر[20])","v":0},{"$f":"SUBTOTAL(103,نوفمبر[21])","v":0},{"$f":"SUBTOTAL(103,نوفمبر[22])","v":0},{"$f":"SUBTOTAL(103,نوفمبر[23])","v":0},{"$f":"SUBTOTAL(103,نوفمبر[24])","v":0},{"$f":"SUBTOTAL(103,نوفمبر[25])","v":0},{"$f":"SUBTOTAL(103,نوفمبر[26])","v":0},{"$f":"SUBTOTAL(103,نوفمبر[27])","v":0},{"$f":"SUBTOTAL(103,نوفمبر[28])","v":0},{"$f":"SUBTOTAL(103,نوفمبر[29])","v":0},{"$f":"SUBTOTAL(103,نوفمبر[30])","v":0},{"$f":"SUBTOTAL(103,نوفمبر[[ ]])","v":0},{"$f":"SUBTOTAL(109,نوفمبر[إجمالي الأيام])","v":0}]

{"sheet":"ديسمبر","index":11,"n_rows":12,"n_cols":34,"rows_kept":12,"merged":[[1,3,1,5],[1,7,1,9],[1,11,1,12],[1,14,1,16],[1,18,1,20],[3,2,3,32]]}
[null,{"$f":"Employee_Absence_Title","v":"جدول غياب الموظفين"}]
[null,"مفتاح نوع الغياب","ع","العطلة",null,null,"ش","أسباب شخصية",null,null,"م","مرضي",null,null,"مخصص 1",{"$nulls":3},"مخصص 2"]
[]
[null,"ديسمبر","تواريخ الغياب",{"$nulls":30},{"$f":"CalendarYear","v":2019}]
[null,null,{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,12,1),1),\"aaa\")","v":"الأحد"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,12,2),1),\"aaa\")","v":"الإثنين"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,12,3),1),\"aaa\")","v":"الثلاثاء"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,12,4),1),\"aaa\")","v":"الأربعاء"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,12,5),1),\"aaa\")","v":"الخميس"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,12,6),1),\"aaa\")","v":"الجمعة"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,12,7),1),\"aaa\")","v":"السبت"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,12,8),1),\"aaa\")","v":"الأحد"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,12,9),1),\"aaa\")","v":"الإثنين"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,12,10),1),\"aaa\")","v":"الثلاثاء"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,12,11),1),\"aaa\")","v":"الأربعاء"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,12,12),1),\"aaa\")","v":"الخميس"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,12,13),1),\"aaa\")","v":"الجمعة"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,12,14),1),\"aaa\")","v":"السبت"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,12,15),1),\"aaa\")","v":"الأحد"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,12,16),1),\"aaa\")","v":"الإثنين"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,12,17),1),\"aaa\")","v":"الثلاثاء"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,12,18),1),\"aaa\")","v":"الأربعاء"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,12,19),1),\"aaa\")","v":"الخميس"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,12,20),1),\"aaa\")","v":"الجمعة"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,12,21),1),\"aaa\")","v":"السبت"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,12,22),1),\"aaa\")","v":"الأحد"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,12,23),1),\"aaa\")","v":"الإثنين"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,12,24),1),\"aaa\")","v":"الثلاثاء"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,12,25),1),\"aaa\")","v":"الأربعاء"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,12,26),1),\"aaa\")","v":"الخميس"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,12,27),1),\"aaa\")","v":"الجمعة"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,12,28),1),\"aaa\")","v":"السبت"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,12,29),1),\"aaa\")","v":"الأحد"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,12,30),1),\"aaa\")","v":"الإثنين"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,12,31),1),\"aaa\")","v":"الثلاثاء"}]
[null,"اسم الموظف","1","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","27","28","29","30","31","إجمالي الأيام"]
[null,"الموظف 1",{"$nulls":31},{"$f":"COUNTA(ديسمبر[[#This Row],[1]:[31]])","v":0}]
[null,"الموظف 2",{"$nulls":31},{"$f":"COUNTA(ديسمبر[[#This Row],[1]:[31]])","v":0}]
[null,"الموظف 3",{"$nulls":31},{"$f":"COUNTA(ديسمبر[[#This Row],[1]:[31]])","v":0}]
[null,"الموظف 4",{"$nulls":31},{"$f":"COUNTA(ديسمبر[[#This Row],[1]:[31]])","v":0}]
[null,"الموظف 5",{"$nulls":31},{"$f":"COUNTA(ديسمبر[[#This Row],[1]:[31]])","v":0}]
[null,{"$f":"\"إجمالي شهر \"&MonthName","v":"إجمالي شهر ديسمبر"},{"$f":"SUBTOTAL(103,ديسمبر[1])","v":0},{"$f":"SUBTOTAL(103,ديسمبر[2])","v":0},{"$f":"SUBTOTAL(103,ديسمبر[3])","v":0},{"$f":"SUBTOTAL(103,ديسمبر[4])","v":0},{"$f":"SUBTOTAL(103,ديسمبر[5])","v":0},{"$f":"SUBTOTAL(103,ديسمبر[6])","v":0},{"$f":"SUBTOTAL(103,ديسمبر[7])","v":0},{"$f":"SUBTOTAL(103,ديسمبر[8])","v":0},{"$f":"SUBTOTAL(103,ديسمبر[9])","v":0},{"$f":"SUBTOTAL(103,ديسمبر[10])","v":0},{"$f":"SUBTOTAL(103,ديسمبر[11])","v":0},{"$f":"SUBTOTAL(103,ديسمبر[12])","v":0},{"$f":"SUBTOTAL(103,ديسمبر[13])","v":0},{"$f":"SUBTOTAL(103,ديسمبر[14])","v":0},{"$f":"SUBTOTAL(103,ديسمبر[15])","v":0},{"$f":"SUBTOTAL(103,ديسمبر[16])","v":0},{"$f":"SUBTOTAL(103,ديسمبر[17])","v":0},{"$f":"SUBTOTAL(103,ديسمبر[18])","v":0},{"$f":"SUBTOTAL(103,ديسمبر[19])","v":0},{"$f":"SUBTOTAL(103,ديسمبر[20])","v":0},{"$f":"SUBTOTAL(103,ديسمبر[21])","v":0},{"$f":"SUBTOTAL(103,ديسمبر[22])","v":0},{"$f":"SUBTOTAL(103,ديسمبر[23])","v":0},{"$f":"SUBTOTAL(103,ديسمبر[24])","v":0},{"$f":"SUBTOTAL(103,ديسمبر[25])","v":0},{"$f":"SUBTOTAL(103,ديسمبر[26])","v":0},{"$f":"SUBTOTAL(103,ديسمبر[27])","v":0},{"$f":"SUBTOTAL(103,ديسمبر[28])","v":0},{"$f":"SUBTOTAL(103,ديسمبر[29])","v":0},{"$f":"SUBTOTAL(103,ديسمبر[30])","v":0},{"$f":"SUBTOTAL(103,ديسمبر[31])","v":0},{"$f":"SUBTOTAL(109,ديسمبر[إجمالي الأيام])","v":0}]

{"sheet":"أسماء الموظفين","index":12,"n_rows":8,"n_cols":2,"rows_kept":8}
[null,"أسماء الموظفين"]
[]
[null,"أسماء الموظفين"]
[null,"الموظف 1"]
[null,"الموظف 2"]
[null,"الموظف 3"]
[null,"الموظف 4"]
[null,"الموظف 5"]