{"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"]