{"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,4],[1,6,1,7],[1,9,1,10],[1,12,1,13],[1,15,1,16],[3,2,3,32]]}
[null,"員工缺勤排程"]
[null,"缺勤類型輸入鍵","V","休假",null,"P","事假",null,"S","病假",null,null,"自訂 1",null,null,"自訂 2"]
[{"$nulls":33},"輸入年份："]
[null,"一月","缺勤日期",{"$nulls":30},2019]
[null,null,{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,1,1),1),\"aaa\")","v":"週二"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,1,2),1),\"aaa\")","v":"週三"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,1,3),1),\"aaa\")","v":"週四"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,1,4),1),\"aaa\")","v":"週五"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,1,5),1),\"aaa\")","v":"週六"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,1,6),1),\"aaa\")","v":"週日"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,1,7),1),\"aaa\")","v":"週一"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,1,8),1),\"aaa\")","v":"週二"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,1,9),1),\"aaa\")","v":"週三"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,1,10),1),\"aaa\")","v":"週四"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,1,11),1),\"aaa\")","v":"週五"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,1,12),1),\"aaa\")","v":"週六"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,1,13),1),\"aaa\")","v":"週日"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,1,14),1),\"aaa\")","v":"週一"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,1,15),1),\"aaa\")","v":"週二"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,1,16),1),\"aaa\")","v":"週三"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,1,17),1),\"aaa\")","v":"週四"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,1,18),1),\"aaa\")","v":"週五"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,1,19),1),\"aaa\")","v":"週六"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,1,20),1),\"aaa\")","v":"週日"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,1,21),1),\"aaa\")","v":"週一"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,1,22),1),\"aaa\")","v":"週二"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,1,23),1),\"aaa\")","v":"週三"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,1,24),1),\"aaa\")","v":"週四"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,1,25),1),\"aaa\")","v":"週五"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,1,26),1),\"aaa\")","v":"週六"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,1,27),1),\"aaa\")","v":"週日"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,1,28),1),\"aaa\")","v":"週一"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,1,29),1),\"aaa\")","v":"週二"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,1,30),1),\"aaa\")","v":"週三"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,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,"V","V","V","V",{"$nulls":6},"V",{"$nulls":18},{"$f":"COUNTA(一月!$C7:$AG7)","v":5}]
[null,"員工 2",{"$nulls":4},"S","S",{"$nulls":4},"P",{"$nulls":8},"S",{"$nulls":4},"V","V","V",{"$nulls":4},{"$f":"COUNTA(一月!$C8:$AG8)","v":7}]
[null,"員工 3",null,null,"P",{"$nulls":10},"S",{"$nulls":14},"S",null,null,{"$f":"COUNTA(一月!$C9:$AG9)","v":3}]
[null,"員工 4",{"$nulls":6},"P",{"$nulls":11},"V","V","V",{"$nulls":10},{"$f":"COUNTA(一月!$C10:$AG10)","v":4}]
[null,"員工 5",{"$nulls":3},"S","V","V",{"$nulls":10},"S",{"$nulls":6},"S",{"$nulls":6},"V",{"$f":"COUNTA(一月!$C11:$AG11)","v":6}]
[null,{"$f":"月份名稱&\"汇总\"","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,4],[1,6,1,7],[1,9,1,10],[1,12,1,13],[1,15,1,16],[3,2,3,32]]}
[null,{"$f":"員工_缺勤_標題","v":"員工缺勤排程"}]
[null,"缺勤類型輸入鍵","V","休假",null,"P","事假",null,"S","病假",null,null,"自訂 1",null,null,"自訂 2"]
[]
[null,"二月","缺勤日期",{"$nulls":30},{"$f":"行事曆年份","v":2019}]
[null,null,{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,2,1),1),\"aaa\")","v":"週五"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,2,2),1),\"aaa\")","v":"週六"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,2,3),1),\"aaa\")","v":"週日"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,2,4),1),\"aaa\")","v":"週一"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,2,5),1),\"aaa\")","v":"週二"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,2,6),1),\"aaa\")","v":"週三"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,2,7),1),\"aaa\")","v":"週四"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,2,8),1),\"aaa\")","v":"週五"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,2,9),1),\"aaa\")","v":"週六"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,2,10),1),\"aaa\")","v":"週日"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,2,11),1),\"aaa\")","v":"週一"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,2,12),1),\"aaa\")","v":"週二"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,2,13),1),\"aaa\")","v":"週三"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,2,14),1),\"aaa\")","v":"週四"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,2,15),1),\"aaa\")","v":"週五"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,2,16),1),\"aaa\")","v":"週六"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,2,17),1),\"aaa\")","v":"週日"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,2,18),1),\"aaa\")","v":"週一"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,2,19),1),\"aaa\")","v":"週二"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,2,20),1),\"aaa\")","v":"週三"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,2,21),1),\"aaa\")","v":"週四"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,2,22),1),\"aaa\")","v":"週五"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,2,23),1),\"aaa\")","v":"週六"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,2,24),1),\"aaa\")","v":"週日"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,2,25),1),\"aaa\")","v":"週一"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,2,26),1),\"aaa\")","v":"週二"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,2,27),1),\"aaa\")","v":"週三"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,2,28),1),\"aaa\")","v":"週四"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,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,"V","V","V","V",{"$nulls":6},"V",{"$nulls":18},{"$f":"COUNTA(二月[[#This Row],[1]:[29]])","v":5}]
[null,"員工 2",{"$nulls":4},"S","S",{"$nulls":4},"P",{"$nulls":8},"S",{"$nulls":4},"V","V","V",{"$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,"S",{"$nulls":10},"S",{"$nulls":3},"P",{"$nulls":9},"S",{"$nulls":3},{"$f":"COUNTA(二月[[#This Row],[1]:[29]])","v":4}]
[null,"員工 5",{"$nulls":7},"V","V","V","V",{"$nulls":12},"S",{"$nulls":7},{"$f":"COUNTA(二月[[#This Row],[1]:[29]])","v":5}]
[null,{"$f":"月份名稱&\"汇总\"","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,4],[1,6,1,7],[1,9,1,10],[1,12,1,13],[1,15,1,16],[3,2,3,32]]}
[null,{"$f":"員工_缺勤_標題","v":"員工缺勤排程"}]
[null,"缺勤類型輸入鍵","V","休假",null,"P","事假",null,"S","病假",null,null,"自訂 1",null,null,"自訂 2"]
[]
[null,"三月","缺勤日期",{"$nulls":30},{"$f":"行事曆年份","v":2019}]
[null,null,{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,3,1),1),\"aaa\")","v":"週五"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,3,2),1),\"aaa\")","v":"週六"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,3,3),1),\"aaa\")","v":"週日"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,3,4),1),\"aaa\")","v":"週一"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,3,5),1),\"aaa\")","v":"週二"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,3,6),1),\"aaa\")","v":"週三"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,3,7),1),\"aaa\")","v":"週四"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,3,8),1),\"aaa\")","v":"週五"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,3,9),1),\"aaa\")","v":"週六"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,3,10),1),\"aaa\")","v":"週日"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,3,11),1),\"aaa\")","v":"週一"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,3,12),1),\"aaa\")","v":"週二"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,3,13),1),\"aaa\")","v":"週三"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,3,14),1),\"aaa\")","v":"週四"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,3,15),1),\"aaa\")","v":"週五"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,3,16),1),\"aaa\")","v":"週六"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,3,17),1),\"aaa\")","v":"週日"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,3,18),1),\"aaa\")","v":"週一"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,3,19),1),\"aaa\")","v":"週二"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,3,20),1),\"aaa\")","v":"週三"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,3,21),1),\"aaa\")","v":"週四"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,3,22),1),\"aaa\")","v":"週五"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,3,23),1),\"aaa\")","v":"週六"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,3,24),1),\"aaa\")","v":"週日"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,3,25),1),\"aaa\")","v":"週一"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,3,26),1),\"aaa\")","v":"週二"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,3,27),1),\"aaa\")","v":"週三"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,3,28),1),\"aaa\")","v":"週四"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,3,29),1),\"aaa\")","v":"週五"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,3,30),1),\"aaa\")","v":"週六"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,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":"月份名稱&\"汇总\"","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,4],[1,6,1,7],[1,9,1,10],[1,12,1,13],[1,15,1,16],[3,2,3,32]]}
[null,{"$f":"員工_缺勤_標題","v":"員工缺勤排程"}]
[null,"缺勤類型輸入鍵","V","休假",null,"P","事假",null,"S","病假",null,null,"自訂 1",null,null,"自訂 2"]
[]
[null,"四月","缺勤日期",{"$nulls":30},{"$f":"行事曆年份","v":2019}]
[null,null,{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,4,1),1),\"aaa\")","v":"週一"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,4,2),1),\"aaa\")","v":"週二"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,4,3),1),\"aaa\")","v":"週三"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,4,4),1),\"aaa\")","v":"週四"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,4,5),1),\"aaa\")","v":"週五"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,4,6),1),\"aaa\")","v":"週六"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,4,7),1),\"aaa\")","v":"週日"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,4,8),1),\"aaa\")","v":"週一"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,4,9),1),\"aaa\")","v":"週二"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,4,10),1),\"aaa\")","v":"週三"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,4,11),1),\"aaa\")","v":"週四"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,4,12),1),\"aaa\")","v":"週五"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,4,13),1),\"aaa\")","v":"週六"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,4,14),1),\"aaa\")","v":"週日"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,4,15),1),\"aaa\")","v":"週一"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,4,16),1),\"aaa\")","v":"週二"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,4,17),1),\"aaa\")","v":"週三"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,4,18),1),\"aaa\")","v":"週四"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,4,19),1),\"aaa\")","v":"週五"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,4,20),1),\"aaa\")","v":"週六"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,4,21),1),\"aaa\")","v":"週日"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,4,22),1),\"aaa\")","v":"週一"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,4,23),1),\"aaa\")","v":"週二"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,4,24),1),\"aaa\")","v":"週三"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,4,25),1),\"aaa\")","v":"週四"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,4,26),1),\"aaa\")","v":"週五"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,4,27),1),\"aaa\")","v":"週六"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,4,28),1),\"aaa\")","v":"週日"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,4,29),1),\"aaa\")","v":"週一"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,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":"月份名稱&\"汇总\"","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,4],[1,6,1,7],[1,9,1,10],[1,12,1,13],[1,15,1,16],[3,2,3,32]]}
[null,{"$f":"員工_缺勤_標題","v":"員工缺勤排程"}]
[null,"缺勤類型輸入鍵","V","休假",null,"P","事假",null,"S","病假",null,null,"自訂 1",null,null,"自訂 2"]
[]
[null,"五月","缺勤日期",{"$nulls":30},{"$f":"行事曆年份","v":2019}]
[null,null,{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,5,1),1),\"aaa\")","v":"週三"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,5,2),1),\"aaa\")","v":"週四"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,5,3),1),\"aaa\")","v":"週五"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,5,4),1),\"aaa\")","v":"週六"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,5,5),1),\"aaa\")","v":"週日"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,5,6),1),\"aaa\")","v":"週一"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,5,7),1),\"aaa\")","v":"週二"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,5,8),1),\"aaa\")","v":"週三"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,5,9),1),\"aaa\")","v":"週四"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,5,10),1),\"aaa\")","v":"週五"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,5,11),1),\"aaa\")","v":"週六"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,5,12),1),\"aaa\")","v":"週日"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,5,13),1),\"aaa\")","v":"週一"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,5,14),1),\"aaa\")","v":"週二"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,5,15),1),\"aaa\")","v":"週三"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,5,16),1),\"aaa\")","v":"週四"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,5,17),1),\"aaa\")","v":"週五"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,5,18),1),\"aaa\")","v":"週六"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,5,19),1),\"aaa\")","v":"週日"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,5,20),1),\"aaa\")","v":"週一"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,5,21),1),\"aaa\")","v":"週二"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,5,22),1),\"aaa\")","v":"週三"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,5,23),1),\"aaa\")","v":"週四"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,5,24),1),\"aaa\")","v":"週五"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,5,25),1),\"aaa\")","v":"週六"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,5,26),1),\"aaa\")","v":"週日"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,5,27),1),\"aaa\")","v":"週一"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,5,28),1),\"aaa\")","v":"週二"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,5,29),1),\"aaa\")","v":"週三"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,5,30),1),\"aaa\")","v":"週四"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,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":"月份名稱&\"汇总\"","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,4],[1,6,1,7],[1,9,1,10],[1,12,1,13],[1,15,1,16],[3,2,3,32]]}
[null,{"$f":"員工_缺勤_標題","v":"員工缺勤排程"}]
[null,"缺勤類型輸入鍵","V","休假",null,"P","事假",null,"S","病假",null,null,"自訂 1",null,null,"自訂 2"]
[]
[null,"六月","缺勤日期",{"$nulls":30},{"$f":"行事曆年份","v":2019}]
[null,null,{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,6,1),1),\"aaa\")","v":"週六"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,6,2),1),\"aaa\")","v":"週日"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,6,3),1),\"aaa\")","v":"週一"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,6,4),1),\"aaa\")","v":"週二"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,6,5),1),\"aaa\")","v":"週三"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,6,6),1),\"aaa\")","v":"週四"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,6,7),1),\"aaa\")","v":"週五"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,6,8),1),\"aaa\")","v":"週六"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,6,9),1),\"aaa\")","v":"週日"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,6,10),1),\"aaa\")","v":"週一"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,6,11),1),\"aaa\")","v":"週二"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,6,12),1),\"aaa\")","v":"週三"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,6,13),1),\"aaa\")","v":"週四"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,6,14),1),\"aaa\")","v":"週五"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,6,15),1),\"aaa\")","v":"週六"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,6,16),1),\"aaa\")","v":"週日"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,6,17),1),\"aaa\")","v":"週一"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,6,18),1),\"aaa\")","v":"週二"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,6,19),1),\"aaa\")","v":"週三"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,6,20),1),\"aaa\")","v":"週四"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,6,21),1),\"aaa\")","v":"週五"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,6,22),1),\"aaa\")","v":"週六"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,6,23),1),\"aaa\")","v":"週日"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,6,24),1),\"aaa\")","v":"週一"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,6,25),1),\"aaa\")","v":"週二"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,6,26),1),\"aaa\")","v":"週三"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,6,27),1),\"aaa\")","v":"週四"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,6,28),1),\"aaa\")","v":"週五"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,6,29),1),\"aaa\")","v":"週六"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,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":"月份名稱&\"汇总\"","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,4],[1,6,1,7],[1,9,1,10],[1,12,1,13],[1,15,1,16],[3,2,3,32]]}
[null,{"$f":"員工_缺勤_標題","v":"員工缺勤排程"}]
[null,"缺勤類型輸入鍵","V","休假",null,"P","事假",null,"S","病假",null,null,"自訂 1",null,null,"自訂 2"]
[]
[null,"七月","缺勤日期",{"$nulls":30},{"$f":"行事曆年份","v":2019}]
[null,null,{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,7,1),1),\"aaa\")","v":"週一"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,7,2),1),\"aaa\")","v":"週二"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,7,3),1),\"aaa\")","v":"週三"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,7,4),1),\"aaa\")","v":"週四"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,7,5),1),\"aaa\")","v":"週五"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,7,6),1),\"aaa\")","v":"週六"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,7,7),1),\"aaa\")","v":"週日"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,7,8),1),\"aaa\")","v":"週一"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,7,9),1),\"aaa\")","v":"週二"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,7,10),1),\"aaa\")","v":"週三"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,7,11),1),\"aaa\")","v":"週四"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,7,12),1),\"aaa\")","v":"週五"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,7,13),1),\"aaa\")","v":"週六"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,7,14),1),\"aaa\")","v":"週日"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,7,15),1),\"aaa\")","v":"週一"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,7,16),1),\"aaa\")","v":"週二"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,7,17),1),\"aaa\")","v":"週三"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,7,18),1),\"aaa\")","v":"週四"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,7,19),1),\"aaa\")","v":"週五"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,7,20),1),\"aaa\")","v":"週六"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,7,21),1),\"aaa\")","v":"週日"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,7,22),1),\"aaa\")","v":"週一"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,7,23),1),\"aaa\")","v":"週二"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,7,24),1),\"aaa\")","v":"週三"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,7,25),1),\"aaa\")","v":"週四"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,7,26),1),\"aaa\")","v":"週五"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,7,27),1),\"aaa\")","v":"週六"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,7,28),1),\"aaa\")","v":"週日"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,7,29),1),\"aaa\")","v":"週一"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,7,30),1),\"aaa\")","v":"週二"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,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":"月份名稱&\"汇总\"","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,4],[1,6,1,7],[1,9,1,10],[1,12,1,13],[1,15,1,16],[3,2,3,32]]}
[null,{"$f":"員工_缺勤_標題","v":"員工缺勤排程"}]
[null,"缺勤類型輸入鍵","V","休假",null,"P","事假",null,"S","病假",null,null,"自訂 1",null,null,"自訂 2"]
[]
[null,"八月","缺勤日期",{"$nulls":30},{"$f":"行事曆年份","v":2019}]
[null,null,{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,8,1),1),\"aaa\")","v":"週四"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,8,2),1),\"aaa\")","v":"週五"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,8,3),1),\"aaa\")","v":"週六"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,8,4),1),\"aaa\")","v":"週日"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,8,5),1),\"aaa\")","v":"週一"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,8,6),1),\"aaa\")","v":"週二"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,8,7),1),\"aaa\")","v":"週三"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,8,8),1),\"aaa\")","v":"週四"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,8,9),1),\"aaa\")","v":"週五"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,8,10),1),\"aaa\")","v":"週六"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,8,11),1),\"aaa\")","v":"週日"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,8,12),1),\"aaa\")","v":"週一"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,8,13),1),\"aaa\")","v":"週二"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,8,14),1),\"aaa\")","v":"週三"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,8,15),1),\"aaa\")","v":"週四"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,8,16),1),\"aaa\")","v":"週五"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,8,17),1),\"aaa\")","v":"週六"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,8,18),1),\"aaa\")","v":"週日"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,8,19),1),\"aaa\")","v":"週一"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,8,20),1),\"aaa\")","v":"週二"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,8,21),1),\"aaa\")","v":"週三"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,8,22),1),\"aaa\")","v":"週四"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,8,23),1),\"aaa\")","v":"週五"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,8,24),1),\"aaa\")","v":"週六"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,8,25),1),\"aaa\")","v":"週日"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,8,26),1),\"aaa\")","v":"週一"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,8,27),1),\"aaa\")","v":"週二"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,8,28),1),\"aaa\")","v":"週三"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,8,29),1),\"aaa\")","v":"週四"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,8,30),1),\"aaa\")","v":"週五"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,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":"月份名稱&\"汇总\"","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,4],[1,6,1,7],[1,9,1,10],[1,12,1,13],[1,15,1,16],[3,2,3,32]]}
[null,{"$f":"員工_缺勤_標題","v":"員工缺勤排程"}]
[null,"缺勤類型輸入鍵","V","休假",null,"P","事假",null,"S","病假",null,null,"自訂 1",null,null,"自訂 2"]
[]
[null,"九月","缺勤日期",{"$nulls":30},{"$f":"行事曆年份","v":2019}]
[null,null,{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,9,1),1),\"aaa\")","v":"週日"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,9,2),1),\"aaa\")","v":"週一"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,9,3),1),\"aaa\")","v":"週二"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,9,4),1),\"aaa\")","v":"週三"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,9,5),1),\"aaa\")","v":"週四"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,9,6),1),\"aaa\")","v":"週五"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,9,7),1),\"aaa\")","v":"週六"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,9,8),1),\"aaa\")","v":"週日"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,9,9),1),\"aaa\")","v":"週一"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,9,10),1),\"aaa\")","v":"週二"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,9,11),1),\"aaa\")","v":"週三"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,9,12),1),\"aaa\")","v":"週四"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,9,13),1),\"aaa\")","v":"週五"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,9,14),1),\"aaa\")","v":"週六"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,9,15),1),\"aaa\")","v":"週日"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,9,16),1),\"aaa\")","v":"週一"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,9,17),1),\"aaa\")","v":"週二"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,9,18),1),\"aaa\")","v":"週三"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,9,19),1),\"aaa\")","v":"週四"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,9,20),1),\"aaa\")","v":"週五"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,9,21),1),\"aaa\")","v":"週六"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,9,22),1),\"aaa\")","v":"週日"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,9,23),1),\"aaa\")","v":"週一"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,9,24),1),\"aaa\")","v":"週二"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,9,25),1),\"aaa\")","v":"週三"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,9,26),1),\"aaa\")","v":"週四"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,9,27),1),\"aaa\")","v":"週五"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,9,28),1),\"aaa\")","v":"週六"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,9,29),1),\"aaa\")","v":"週日"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,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":"月份名稱&\"汇总\"","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,4],[1,6,1,7],[1,9,1,10],[1,12,1,13],[1,15,1,16],[3,2,3,32]]}
[null,{"$f":"員工_缺勤_標題","v":"員工缺勤排程"}]
[null,"缺勤類型輸入鍵","V","休假",null,"P","事假",null,"S","病假",null,null,"自訂 1",null,null,"自訂 2"]
[]
[null,"十月","缺勤日期",{"$nulls":30},{"$f":"行事曆年份","v":2019}]
[null,null,{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,10,1),1),\"aaa\")","v":"週二"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,10,2),1),\"aaa\")","v":"週三"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,10,3),1),\"aaa\")","v":"週四"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,10,4),1),\"aaa\")","v":"週五"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,10,5),1),\"aaa\")","v":"週六"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,10,6),1),\"aaa\")","v":"週日"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,10,7),1),\"aaa\")","v":"週一"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,10,8),1),\"aaa\")","v":"週二"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,10,9),1),\"aaa\")","v":"週三"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,10,10),1),\"aaa\")","v":"週四"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,10,11),1),\"aaa\")","v":"週五"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,10,12),1),\"aaa\")","v":"週六"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,10,13),1),\"aaa\")","v":"週日"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,10,14),1),\"aaa\")","v":"週一"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,10,15),1),\"aaa\")","v":"週二"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,10,16),1),\"aaa\")","v":"週三"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,10,17),1),\"aaa\")","v":"週四"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,10,18),1),\"aaa\")","v":"週五"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,10,19),1),\"aaa\")","v":"週六"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,10,20),1),\"aaa\")","v":"週日"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,10,21),1),\"aaa\")","v":"週一"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,10,22),1),\"aaa\")","v":"週二"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,10,23),1),\"aaa\")","v":"週三"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,10,24),1),\"aaa\")","v":"週四"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,10,25),1),\"aaa\")","v":"週五"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,10,26),1),\"aaa\")","v":"週六"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,10,27),1),\"aaa\")","v":"週日"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,10,28),1),\"aaa\")","v":"週一"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,10,29),1),\"aaa\")","v":"週二"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,10,30),1),\"aaa\")","v":"週三"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,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":"月份名稱&\"汇总\"","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,4],[1,6,1,7],[1,9,1,10],[1,12,1,13],[1,15,1,16],[3,2,3,32]]}
[null,{"$f":"員工_缺勤_標題","v":"員工缺勤排程"}]
[null,"缺勤類型輸入鍵","V","休假",null,"P","事假",null,"S","病假",null,null,"自訂 1",null,null,"自訂 2"]
[]
[null,"十一月","缺勤日期",{"$nulls":30},{"$f":"行事曆年份","v":2019}]
[null,null,{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,11,1),1),\"aaa\")","v":"週五"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,11,2),1),\"aaa\")","v":"週六"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,11,3),1),\"aaa\")","v":"週日"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,11,4),1),\"aaa\")","v":"週一"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,11,5),1),\"aaa\")","v":"週二"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,11,6),1),\"aaa\")","v":"週三"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,11,7),1),\"aaa\")","v":"週四"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,11,8),1),\"aaa\")","v":"週五"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,11,9),1),\"aaa\")","v":"週六"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,11,10),1),\"aaa\")","v":"週日"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,11,11),1),\"aaa\")","v":"週一"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,11,12),1),\"aaa\")","v":"週二"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,11,13),1),\"aaa\")","v":"週三"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,11,14),1),\"aaa\")","v":"週四"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,11,15),1),\"aaa\")","v":"週五"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,11,16),1),\"aaa\")","v":"週六"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,11,17),1),\"aaa\")","v":"週日"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,11,18),1),\"aaa\")","v":"週一"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,11,19),1),\"aaa\")","v":"週二"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,11,20),1),\"aaa\")","v":"週三"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,11,21),1),\"aaa\")","v":"週四"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,11,22),1),\"aaa\")","v":"週五"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,11,23),1),\"aaa\")","v":"週六"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,11,24),1),\"aaa\")","v":"週日"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,11,25),1),\"aaa\")","v":"週一"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,11,26),1),\"aaa\")","v":"週二"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,11,27),1),\"aaa\")","v":"週三"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,11,28),1),\"aaa\")","v":"週四"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,11,29),1),\"aaa\")","v":"週五"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,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":"月份名稱&\"汇总\"","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,4],[1,6,1,7],[1,9,1,10],[1,12,1,13],[1,15,1,16],[3,2,3,32]]}
[null,{"$f":"員工_缺勤_標題","v":"員工缺勤排程"}]
[null,"缺勤類型輸入鍵","V","休假",null,"P","事假",null,"S","病假",null,null,"自訂 1",null,null,"自訂 2"]
[]
[null,"十二月","缺勤日期",{"$nulls":30},{"$f":"行事曆年份","v":2019}]
[null,null,{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,12,1),1),\"aaa\")","v":"週日"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,12,2),1),\"aaa\")","v":"週一"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,12,3),1),\"aaa\")","v":"週二"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,12,4),1),\"aaa\")","v":"週三"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,12,5),1),\"aaa\")","v":"週四"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,12,6),1),\"aaa\")","v":"週五"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,12,7),1),\"aaa\")","v":"週六"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,12,8),1),\"aaa\")","v":"週日"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,12,9),1),\"aaa\")","v":"週一"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,12,10),1),\"aaa\")","v":"週二"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,12,11),1),\"aaa\")","v":"週三"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,12,12),1),\"aaa\")","v":"週四"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,12,13),1),\"aaa\")","v":"週五"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,12,14),1),\"aaa\")","v":"週六"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,12,15),1),\"aaa\")","v":"週日"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,12,16),1),\"aaa\")","v":"週一"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,12,17),1),\"aaa\")","v":"週二"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,12,18),1),\"aaa\")","v":"週三"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,12,19),1),\"aaa\")","v":"週四"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,12,20),1),\"aaa\")","v":"週五"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,12,21),1),\"aaa\")","v":"週六"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,12,22),1),\"aaa\")","v":"週日"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,12,23),1),\"aaa\")","v":"週一"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,12,24),1),\"aaa\")","v":"週二"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,12,25),1),\"aaa\")","v":"週三"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,12,26),1),\"aaa\")","v":"週四"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,12,27),1),\"aaa\")","v":"週五"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,12,28),1),\"aaa\")","v":"週六"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,12,29),1),\"aaa\")","v":"週日"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,12,30),1),\"aaa\")","v":"週一"},{"$f":"TEXT(WEEKDAY(DATE(行事曆年份,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":"月份名稱&\"汇总\"","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"]