{"text_format":"3","workbook":"xlsx","n_sheets":13,"sheets":["1 月","2 月","3 月","4 月","5 月","6 月","7 月","8 月","9 月","10 月","11 月","12 月","员工姓名"],"not_rendered":{"defined_names":50},"read":"whole","date_system":"1900"}

{"sheet":"1 月","index":0,"n_rows":14,"n_cols":34,"rows_kept":14,"merged":[[3,3,3,4],[3,6,3,7],[3,9,3,10],[3,12,3,13],[3,15,3,16],[5,2,5,32]]}
[null,"员工考勤时间表"]
[null,"1 月"]
[]
[null,"缺勤类型键","V","休假",null,"P","个人",null,"S","病假",null,null,"自定义 1",null,null,"自定义 2"]
[]
[null,null,"缺勤日期",{"$nulls":30},2023]
[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,"Harsimran Brar",null,null,"V","V","V","V",{"$nulls":6},"V",{"$nulls":18},{"$f":"COUNTA('1 月'!$C9:$AG9)","v":5}]
[null,"Jordan Mitchell",{"$nulls":4},"S","S",{"$nulls":4},"P",{"$nulls":8},"S",{"$nulls":4},"V","V","V",{"$nulls":4},{"$f":"COUNTA('1 月'!$C10:$AG10)","v":7}]
[null,"Asaf Karten",null,null,"P",{"$nulls":10},"S",{"$nulls":14},"S",null,null,{"$f":"COUNTA('1 月'!$C11:$AG11)","v":3}]
[null,"Vanja Jovanovic",{"$nulls":6},"P",{"$nulls":11},"V","V","V",{"$nulls":10},{"$f":"COUNTA('1 月'!$C12:$AG12)","v":4}]
[null,"Madison Butler",{"$nulls":3},"S","V","V",{"$nulls":10},"S",{"$nulls":6},"S",{"$nulls":6},"V",{"$f":"COUNTA('1 月'!$C13:$AG13)","v":6}]
[null,{"$f":"MonthName&\"汇总\"","v":"1 月汇总"},{"$f":"SUBTOTAL(103,'1 月'!$C$9:$C$13)","v":0},{"$f":"SUBTOTAL(103,'1 月'!$D$9:$D$13)","v":0},{"$f":"SUBTOTAL(103,'1 月'!$E$9:$E$13)","v":2},{"$f":"SUBTOTAL(103,'1 月'!$F$9:$F$13)","v":2},{"$f":"SUBTOTAL(103,'1 月'!$G$9:$G$13)","v":3},{"$f":"SUBTOTAL(103,'1 月'!$H$9:$H$13)","v":3},{"$f":"SUBTOTAL(103,'1 月'!$I$9:$I$13)","v":1},{"$f":"SUBTOTAL(103,'1 月'!$J$9:$J$13)","v":0},{"$f":"SUBTOTAL(103,'1 月'!$K$9:$K$13)","v":0},{"$f":"SUBTOTAL(103,'1 月'!$L$9:$L$13)","v":0},{"$f":"SUBTOTAL(103,'1 月'!$M$9:$M$13)","v":1},{"$f":"SUBTOTAL(103,'1 月'!$N$9:$N$13)","v":0},{"$f":"SUBTOTAL(103,'1 月'!$O$9:$O$13)","v":1},{"$f":"SUBTOTAL(103,'1 月'!$P$9:$P$13)","v":1},{"$f":"SUBTOTAL(103,'1 月'!$Q$9:$Q$13)","v":0},{"$f":"SUBTOTAL(103,'1 月'!$R$9:$R$13)","v":0},{"$f":"SUBTOTAL(103,'1 月'!$S$9:$S$13)","v":1},{"$f":"SUBTOTAL(103,'1 月'!$T$9:$T$13)","v":0},{"$f":"SUBTOTAL(103,'1 月'!$U$9:$U$13)","v":1},{"$f":"SUBTOTAL(103,'1 月'!$V$9:$V$13)","v":2},{"$f":"SUBTOTAL(103,'1 月'!$W$9:$W$13)","v":1},{"$f":"SUBTOTAL(103,'1 月'!$X$9:$X$13)","v":0},{"$f":"SUBTOTAL(103,'1 月'!$Y$9:$Y$13)","v":0},{"$f":"SUBTOTAL(103,'1 月'!$Z$9:$Z$13)","v":1},{"$f":"SUBTOTAL(103,'1 月'!$AA$9:$AA$13)","v":1},{"$f":"SUBTOTAL(103,'1 月'!$AB$9:$AB$13)","v":1},{"$f":"SUBTOTAL(103,'1 月'!$AC$9:$AC$13)","v":1},{"$f":"SUBTOTAL(103,'1 月'!$AD$9:$AD$13)","v":0},{"$f":"SUBTOTAL(103,'1 月'!$AE$9:$AE$13)","v":1},{"$f":"SUBTOTAL(103,'1 月'!$AF$9:$AF$13)","v":0},{"$f":"SUBTOTAL(103,'1 月'!$AG$9:$AG$13)","v":1},{"$f":"SUBTOTAL(109,_1_月[总天数])","v":25}]

{"sheet":"2 月","index":1,"n_rows":14,"n_cols":34,"rows_kept":14,"merged":[[3,3,3,4],[3,6,3,7],[3,9,3,10],[3,12,3,13],[3,15,3,16],[5,2,5,32]]}
[null,"员工考勤时间表"]
[null,"2 月"]
[]
[null,"缺勤类型键","V","休假",null,"P","个人",null,"S","病假",null,null,"自定义 1",null,null,"自定义 2"]
[]
[null,null,"缺勤日期",{"$nulls":30},{"$f":"日历年","v":2023}]
[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,"Harsimran Brar",null,null,"V","V","V","V",{"$nulls":6},"V",{"$nulls":18},5]
[null,"Jordan Mitchell",{"$nulls":4},"S","S",{"$nulls":4},"P",{"$nulls":8},"S",{"$nulls":4},"V","V","V",{"$nulls":4},7]
[null,"Asaf Karten",{"$nulls":31},0]
[null,"Vanja Jovanovic",null,null,"S",{"$nulls":10},"S",{"$nulls":3},"P",{"$nulls":9},"S",{"$nulls":3},4]
[null,"Madison Butler",{"$nulls":7},"V","V","V","V",{"$nulls":12},"S",{"$nulls":7},5]
[null,{"$f":"MonthName&\"汇总\"","v":"2 月汇总"},{"$f":"SUBTOTAL(103,_2_月[1])","v":0},{"$f":"SUBTOTAL(103,_2_月[2])","v":0},{"$f":"SUBTOTAL(103,_2_月[3])","v":2},{"$f":"SUBTOTAL(103,_2_月[4])","v":1},{"$f":"SUBTOTAL(103,_2_月[5])","v":2},{"$f":"SUBTOTAL(103,_2_月[6])","v":2},{"$f":"SUBTOTAL(103,_2_月[7])","v":0},{"$f":"SUBTOTAL(103,_2_月[8])","v":1},{"$f":"SUBTOTAL(103,_2_月[9])","v":1},{"$f":"SUBTOTAL(103,_2_月[10])","v":1},{"$f":"SUBTOTAL(103,_2_月[11])","v":2},{"$f":"SUBTOTAL(103,_2_月[12])","v":0},{"$f":"SUBTOTAL(103,_2_月[13])","v":1},{"$f":"SUBTOTAL(103,_2_月[14])","v":1},{"$f":"SUBTOTAL(103,_2_月[15])","v":0},{"$f":"SUBTOTAL(103,_2_月[16])","v":0},{"$f":"SUBTOTAL(103,_2_月[17])","v":0},{"$f":"SUBTOTAL(103,_2_月[18])","v":1},{"$f":"SUBTOTAL(103,_2_月[19])","v":0},{"$f":"SUBTOTAL(103,_2_月[20])","v":1},{"$f":"SUBTOTAL(103,_2_月[21])","v":0},{"$f":"SUBTOTAL(103,_2_月[22])","v":0},{"$f":"SUBTOTAL(103,_2_月[23])","v":0},{"$f":"SUBTOTAL(103,_2_月[24])","v":1},{"$f":"SUBTOTAL(103,_2_月[25])","v":1},{"$f":"SUBTOTAL(103,_2_月[26])","v":1},{"$f":"SUBTOTAL(103,_2_月[27])","v":1},{"$f":"SUBTOTAL(103,_2_月[28])","v":1},{"$f":"SUBTOTAL(103,_2_月[29])","v":0},null,null,{"$f":"SUBTOTAL(109,_2_月[总天数])","v":21}]

{"sheet":"3 月","index":2,"n_rows":14,"n_cols":34,"rows_kept":14,"merged":[[3,3,3,4],[3,6,3,7],[3,9,3,10],[3,12,3,13],[3,15,3,16],[5,2,5,32]]}
[null,"员工考勤时间表"]
[null,"3 月"]
[]
[null,"缺勤类型键","V","休假",null,"P","个人",null,"S","病假",null,null,"自定义 1",null,null,"自定义 2"]
[]
[null,null,"缺勤日期",{"$nulls":30},{"$f":"日历年","v":2023}]
[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,"Harsimran Brar",{"$nulls":31},0]
[null,"Jordan Mitchell",{"$nulls":31},0]
[null,"Asaf Karten",{"$nulls":31},0]
[null,"Vanja Jovanovic",{"$nulls":31},0]
[null,"Madison Butler",{"$nulls":31},0]
[null,{"$f":"MonthName&\"汇总\"","v":"3 月汇总"},{"$f":"SUBTOTAL(103,_3_月[1])","v":0},{"$f":"SUBTOTAL(103,_3_月[2])","v":0},{"$f":"SUBTOTAL(103,_3_月[3])","v":0},{"$f":"SUBTOTAL(103,_3_月[4])","v":0},{"$f":"SUBTOTAL(103,_3_月[5])","v":0},{"$f":"SUBTOTAL(103,_3_月[6])","v":0},{"$f":"SUBTOTAL(103,_3_月[7])","v":0},{"$f":"SUBTOTAL(103,_3_月[8])","v":0},{"$f":"SUBTOTAL(103,_3_月[9])","v":0},{"$f":"SUBTOTAL(103,_3_月[10])","v":0},{"$f":"SUBTOTAL(103,_3_月[11])","v":0},{"$f":"SUBTOTAL(103,_3_月[12])","v":0},{"$f":"SUBTOTAL(103,_3_月[13])","v":0},{"$f":"SUBTOTAL(103,_3_月[14])","v":0},{"$f":"SUBTOTAL(103,_3_月[15])","v":0},{"$f":"SUBTOTAL(103,_3_月[16])","v":0},{"$f":"SUBTOTAL(103,_3_月[17])","v":0},{"$f":"SUBTOTAL(103,_3_月[18])","v":0},{"$f":"SUBTOTAL(103,_3_月[19])","v":0},{"$f":"SUBTOTAL(103,_3_月[20])","v":0},{"$f":"SUBTOTAL(103,_3_月[21])","v":0},{"$f":"SUBTOTAL(103,_3_月[22])","v":0},{"$f":"SUBTOTAL(103,_3_月[23])","v":0},{"$f":"SUBTOTAL(103,_3_月[24])","v":0},{"$f":"SUBTOTAL(103,_3_月[25])","v":0},{"$f":"SUBTOTAL(103,_3_月[26])","v":0},{"$f":"SUBTOTAL(103,_3_月[27])","v":0},{"$f":"SUBTOTAL(103,_3_月[28])","v":0},{"$f":"SUBTOTAL(103,_3_月[29])","v":0},{"$f":"SUBTOTAL(109,_3_月[30])","v":0},{"$f":"SUBTOTAL(109,_3_月[31])","v":0},{"$f":"SUBTOTAL(109,_3_月[总天数])","v":0}]

{"sheet":"4 月","index":3,"n_rows":14,"n_cols":34,"rows_kept":14,"merged":[[3,3,3,4],[3,6,3,7],[3,9,3,10],[3,12,3,13],[3,15,3,16],[5,2,5,32]]}
[null,"员工考勤时间表"]
[null,"4 月"]
[]
[null,"缺勤类型键","V","休假",null,"P","个人",null,"S","病假",null,null,"自定义 1",null,null,"自定义 2"]
[]
[null,null,"缺勤日期",{"$nulls":30},{"$f":"日历年","v":2023}]
[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,"Harsimran Brar",{"$nulls":31},{"$f":"COUNTA(March5[[#This Row],[1]:[ ]])","v":0}]
[null,"Jordan Mitchell",{"$nulls":31},{"$f":"COUNTA(March5[[#This Row],[1]:[ ]])","v":0}]
[null,"Asaf Karten",{"$nulls":31},{"$f":"COUNTA(March5[[#This Row],[1]:[ ]])","v":0}]
[null,"Vanja Jovanovic",{"$nulls":31},{"$f":"COUNTA(March5[[#This Row],[1]:[ ]])","v":0}]
[null,"Madison Butler",{"$nulls":31},{"$f":"COUNTA(March5[[#This Row],[1]:[ ]])","v":0}]
[null,{"$f":"MonthName&\"汇总\"","v":"4 月汇总"},{"$f":"SUBTOTAL(103,March5[1])","v":0},{"$f":"SUBTOTAL(103,March5[2])","v":0},{"$f":"SUBTOTAL(103,March5[3])","v":0},{"$f":"SUBTOTAL(103,March5[4])","v":0},{"$f":"SUBTOTAL(103,March5[5])","v":0},{"$f":"SUBTOTAL(103,March5[6])","v":0},{"$f":"SUBTOTAL(103,March5[7])","v":0},{"$f":"SUBTOTAL(103,March5[8])","v":0},{"$f":"SUBTOTAL(103,March5[9])","v":0},{"$f":"SUBTOTAL(103,March5[10])","v":0},{"$f":"SUBTOTAL(103,March5[11])","v":0},{"$f":"SUBTOTAL(103,March5[12])","v":0},{"$f":"SUBTOTAL(103,March5[13])","v":0},{"$f":"SUBTOTAL(103,March5[14])","v":0},{"$f":"SUBTOTAL(103,March5[15])","v":0},{"$f":"SUBTOTAL(103,March5[16])","v":0},{"$f":"SUBTOTAL(103,March5[17])","v":0},{"$f":"SUBTOTAL(103,March5[18])","v":0},{"$f":"SUBTOTAL(103,March5[19])","v":0},{"$f":"SUBTOTAL(103,March5[20])","v":0},{"$f":"SUBTOTAL(103,March5[21])","v":0},{"$f":"SUBTOTAL(103,March5[22])","v":0},{"$f":"SUBTOTAL(103,March5[23])","v":0},{"$f":"SUBTOTAL(103,March5[24])","v":0},{"$f":"SUBTOTAL(103,March5[25])","v":0},{"$f":"SUBTOTAL(103,March5[26])","v":0},{"$f":"SUBTOTAL(103,March5[27])","v":0},{"$f":"SUBTOTAL(103,March5[28])","v":0},{"$f":"SUBTOTAL(103,March5[29])","v":0},{"$f":"SUBTOTAL(109,March5[30])","v":0},{"$f":"SUBTOTAL(109,March5[[ ]])","v":0},{"$f":"SUBTOTAL(109,March5[总天数])","v":0}]

{"sheet":"5 月","index":4,"n_rows":14,"n_cols":34,"rows_kept":14,"merged":[[3,3,3,4],[3,6,3,7],[3,9,3,10],[3,12,3,13],[3,15,3,16],[5,2,5,32]]}
[null,"员工考勤时间表"]
[null,"5 月"]
[]
[null,"缺勤类型键","V","休假",null,"P","个人",null,"S","病假",null,null,"自定义 1",null,null,"自定义 2"]
[]
[null,null,"缺勤日期",{"$nulls":30},{"$f":"日历年","v":2023}]
[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,"Harsimran Brar",{"$nulls":31},{"$f":"COUNTA(March58[[#This Row],[1]:[31]])","v":0}]
[null,"Jordan Mitchell",{"$nulls":31},{"$f":"COUNTA(March58[[#This Row],[1]:[31]])","v":0}]
[null,"Asaf Karten",{"$nulls":31},{"$f":"COUNTA(March58[[#This Row],[1]:[31]])","v":0}]
[null,"Vanja Jovanovic",{"$nulls":31},{"$f":"COUNTA(March58[[#This Row],[1]:[31]])","v":0}]
[null,"Madison Butler",{"$nulls":31},{"$f":"COUNTA(March58[[#This Row],[1]:[31]])","v":0}]
[null,{"$f":"MonthName&\"汇总\"","v":"缺勤类型键汇总"},{"$f":"SUBTOTAL(103,March58[1])","v":0},{"$f":"SUBTOTAL(103,March58[2])","v":0},{"$f":"SUBTOTAL(103,March58[3])","v":0},{"$f":"SUBTOTAL(103,March58[4])","v":0},{"$f":"SUBTOTAL(103,March58[5])","v":0},{"$f":"SUBTOTAL(103,March58[6])","v":0},{"$f":"SUBTOTAL(103,March58[7])","v":0},{"$f":"SUBTOTAL(103,March58[8])","v":0},{"$f":"SUBTOTAL(103,March58[9])","v":0},{"$f":"SUBTOTAL(103,March58[10])","v":0},{"$f":"SUBTOTAL(103,March58[11])","v":0},{"$f":"SUBTOTAL(103,March58[12])","v":0},{"$f":"SUBTOTAL(103,March58[13])","v":0},{"$f":"SUBTOTAL(103,March58[14])","v":0},{"$f":"SUBTOTAL(103,March58[15])","v":0},{"$f":"SUBTOTAL(103,March58[16])","v":0},{"$f":"SUBTOTAL(103,March58[17])","v":0},{"$f":"SUBTOTAL(103,March58[18])","v":0},{"$f":"SUBTOTAL(103,March58[19])","v":0},{"$f":"SUBTOTAL(103,March58[20])","v":0},{"$f":"SUBTOTAL(103,March58[21])","v":0},{"$f":"SUBTOTAL(103,March58[22])","v":0},{"$f":"SUBTOTAL(103,March58[23])","v":0},{"$f":"SUBTOTAL(103,March58[24])","v":0},{"$f":"SUBTOTAL(103,March58[25])","v":0},{"$f":"SUBTOTAL(103,March58[26])","v":0},{"$f":"SUBTOTAL(103,March58[27])","v":0},{"$f":"SUBTOTAL(103,March58[28])","v":0},{"$f":"SUBTOTAL(103,March58[29])","v":0},{"$f":"SUBTOTAL(109,March58[30])","v":0},{"$f":"SUBTOTAL(109,March58[31])","v":0},{"$f":"SUBTOTAL(109,March58[总天数])","v":0}]

{"sheet":"6 月","index":5,"n_rows":14,"n_cols":34,"rows_kept":14,"merged":[[3,3,3,4],[3,6,3,7],[3,9,3,10],[3,12,3,13],[3,15,3,16],[5,2,5,32]]}
[null,"员工考勤时间表"]
[null,"6 月"]
[]
[null,"缺勤类型键","V","休假",null,"P","个人",null,"S","病假",null,null,"自定义 1",null,null,"自定义 2"]
[]
[null,null,"缺勤日期",{"$nulls":30},{"$f":"日历年","v":2023}]
[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,"Harsimran Brar",{"$nulls":31},0]
[null,"Jordan Mitchell",{"$nulls":31},0]
[null,"Asaf Karten",{"$nulls":31},0]
[null,"Vanja Jovanovic",{"$nulls":31},0]
[null,"Madison Butler",{"$nulls":31},0]
[null,{"$f":"MonthName&\"汇总\"","v":"6 月汇总"},{"$f":"SUBTOTAL(103,_6_月[1])","v":0},{"$f":"SUBTOTAL(103,_6_月[2])","v":0},{"$f":"SUBTOTAL(103,_6_月[3])","v":0},{"$f":"SUBTOTAL(103,_6_月[4])","v":0},{"$f":"SUBTOTAL(103,_6_月[5])","v":0},{"$f":"SUBTOTAL(103,_6_月[6])","v":0},{"$f":"SUBTOTAL(103,_6_月[7])","v":0},{"$f":"SUBTOTAL(103,_6_月[8])","v":0},{"$f":"SUBTOTAL(103,_6_月[9])","v":0},{"$f":"SUBTOTAL(103,_6_月[10])","v":0},{"$f":"SUBTOTAL(103,_6_月[11])","v":0},{"$f":"SUBTOTAL(103,_6_月[12])","v":0},{"$f":"SUBTOTAL(103,_6_月[13])","v":0},{"$f":"SUBTOTAL(103,_6_月[14])","v":0},{"$f":"SUBTOTAL(103,_6_月[15])","v":0},{"$f":"SUBTOTAL(103,_6_月[16])","v":0},{"$f":"SUBTOTAL(103,_6_月[17])","v":0},{"$f":"SUBTOTAL(103,_6_月[18])","v":0},{"$f":"SUBTOTAL(103,_6_月[19])","v":0},{"$f":"SUBTOTAL(103,_6_月[20])","v":0},{"$f":"SUBTOTAL(103,_6_月[21])","v":0},{"$f":"SUBTOTAL(103,_6_月[22])","v":0},{"$f":"SUBTOTAL(103,_6_月[23])","v":0},{"$f":"SUBTOTAL(103,_6_月[24])","v":0},{"$f":"SUBTOTAL(103,_6_月[25])","v":0},{"$f":"SUBTOTAL(103,_6_月[26])","v":0},{"$f":"SUBTOTAL(103,_6_月[27])","v":0},{"$f":"SUBTOTAL(103,_6_月[28])","v":0},{"$f":"SUBTOTAL(103,_6_月[29])","v":0},{"$f":"SUBTOTAL(109,_6_月[30])","v":0},{"$f":"SUBTOTAL(109,_6_月[[ ]])","v":0},{"$f":"SUBTOTAL(109,_6_月[总天数])","v":0}]

{"sheet":"7 月","index":6,"n_rows":14,"n_cols":34,"rows_kept":14,"merged":[[3,3,3,4],[3,6,3,7],[3,9,3,10],[3,12,3,13],[3,15,3,16],[5,2,5,32]]}
[null,"员工考勤时间表"]
[null,"7 月"]
[]
[null,"缺勤类型键","V","休假",null,"P","个人",null,"S","病假",null,null,"自定义 1",null,null,"自定义 2"]
[]
[null,null,"缺勤日期",{"$nulls":30},{"$f":"日历年","v":2023}]
[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,"Harsimran Brar",{"$nulls":31},0]
[null,"Jordan Mitchell",{"$nulls":31},0]
[null,"Asaf Karten",{"$nulls":31},0]
[null,"Vanja Jovanovic",{"$nulls":31},0]
[null,"Madison Butler",{"$nulls":31},0]
[null,{"$f":"MonthName&\"汇总\"","v":"7 月汇总"},{"$f":"SUBTOTAL(103,_7_月[1])","v":0},{"$f":"SUBTOTAL(103,_7_月[2])","v":0},{"$f":"SUBTOTAL(103,_7_月[3])","v":0},{"$f":"SUBTOTAL(103,_7_月[4])","v":0},{"$f":"SUBTOTAL(103,_7_月[5])","v":0},{"$f":"SUBTOTAL(103,_7_月[6])","v":0},{"$f":"SUBTOTAL(103,_7_月[7])","v":0},{"$f":"SUBTOTAL(103,_7_月[8])","v":0},{"$f":"SUBTOTAL(103,_7_月[9])","v":0},{"$f":"SUBTOTAL(103,_7_月[10])","v":0},{"$f":"SUBTOTAL(103,_7_月[11])","v":0},{"$f":"SUBTOTAL(103,_7_月[12])","v":0},{"$f":"SUBTOTAL(103,_7_月[13])","v":0},{"$f":"SUBTOTAL(103,_7_月[14])","v":0},{"$f":"SUBTOTAL(103,_7_月[15])","v":0},{"$f":"SUBTOTAL(103,_7_月[16])","v":0},{"$f":"SUBTOTAL(103,_7_月[17])","v":0},{"$f":"SUBTOTAL(103,_7_月[18])","v":0},{"$f":"SUBTOTAL(103,_7_月[19])","v":0},{"$f":"SUBTOTAL(103,_7_月[20])","v":0},{"$f":"SUBTOTAL(103,_7_月[21])","v":0},{"$f":"SUBTOTAL(103,_7_月[22])","v":0},{"$f":"SUBTOTAL(103,_7_月[23])","v":0},{"$f":"SUBTOTAL(103,_7_月[24])","v":0},{"$f":"SUBTOTAL(103,_7_月[25])","v":0},{"$f":"SUBTOTAL(103,_7_月[26])","v":0},{"$f":"SUBTOTAL(103,_7_月[27])","v":0},{"$f":"SUBTOTAL(103,_7_月[28])","v":0},{"$f":"SUBTOTAL(103,_7_月[29])","v":0},{"$f":"SUBTOTAL(109,_7_月[30])","v":0},{"$f":"SUBTOTAL(109,_7_月[31])","v":0},{"$f":"SUBTOTAL(109,_7_月[总天数])","v":0}]

{"sheet":"8 月","index":7,"n_rows":14,"n_cols":34,"rows_kept":14,"merged":[[3,3,3,4],[3,6,3,7],[3,9,3,10],[3,12,3,13],[3,15,3,16],[5,2,5,32]]}
[null,"员工考勤时间表"]
[null,"8 月"]
[]
[null,"缺勤类型键","V","休假",null,"P","个人",null,"S","病假",null,null,"自定义 1",null,null,"自定义 2"]
[]
[null,null,"缺勤日期",{"$nulls":30},{"$f":"日历年","v":2023}]
[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,"Harsimran Brar",{"$nulls":31},0]
[null,"Jordan Mitchell",{"$nulls":31},0]
[null,"Asaf Karten",{"$nulls":31},0]
[null,"Vanja Jovanovic",{"$nulls":31},0]
[null,"Madison Butler",{"$nulls":31},0]
[null,{"$f":"MonthName&\"汇总\"","v":"8 月汇总"},{"$f":"SUBTOTAL(103,_8_月[1])","v":0},{"$f":"SUBTOTAL(103,_8_月[2])","v":0},{"$f":"SUBTOTAL(103,_8_月[3])","v":0},{"$f":"SUBTOTAL(103,_8_月[4])","v":0},{"$f":"SUBTOTAL(103,_8_月[5])","v":0},{"$f":"SUBTOTAL(103,_8_月[6])","v":0},{"$f":"SUBTOTAL(103,_8_月[7])","v":0},{"$f":"SUBTOTAL(103,_8_月[8])","v":0},{"$f":"SUBTOTAL(103,_8_月[9])","v":0},{"$f":"SUBTOTAL(103,_8_月[10])","v":0},{"$f":"SUBTOTAL(103,_8_月[11])","v":0},{"$f":"SUBTOTAL(103,_8_月[12])","v":0},{"$f":"SUBTOTAL(103,_8_月[13])","v":0},{"$f":"SUBTOTAL(103,_8_月[14])","v":0},{"$f":"SUBTOTAL(103,_8_月[15])","v":0},{"$f":"SUBTOTAL(103,_8_月[16])","v":0},{"$f":"SUBTOTAL(103,_8_月[17])","v":0},{"$f":"SUBTOTAL(103,_8_月[18])","v":0},{"$f":"SUBTOTAL(103,_8_月[19])","v":0},{"$f":"SUBTOTAL(103,_8_月[20])","v":0},{"$f":"SUBTOTAL(103,_8_月[21])","v":0},{"$f":"SUBTOTAL(103,_8_月[22])","v":0},{"$f":"SUBTOTAL(103,_8_月[23])","v":0},{"$f":"SUBTOTAL(103,_8_月[24])","v":0},{"$f":"SUBTOTAL(103,_8_月[25])","v":0},{"$f":"SUBTOTAL(103,_8_月[26])","v":0},{"$f":"SUBTOTAL(103,_8_月[27])","v":0},{"$f":"SUBTOTAL(103,_8_月[28])","v":0},{"$f":"SUBTOTAL(103,_8_月[29])","v":0},{"$f":"SUBTOTAL(109,_8_月[30])","v":0},{"$f":"SUBTOTAL(109,_8_月[31])","v":0},{"$f":"SUBTOTAL(109,_8_月[总天数])","v":0}]

{"sheet":"9 月","index":8,"n_rows":14,"n_cols":34,"rows_kept":14,"merged":[[3,3,3,4],[3,6,3,7],[3,9,3,10],[3,12,3,13],[3,15,3,16],[5,2,5,32]]}
[null,"员工考勤时间表"]
[null,"9 月"]
[]
[null,"缺勤类型键","V","休假",null,"P","个人",null,"S","病假",null,null,"自定义 1",null,null,"自定义 2"]
[]
[null,null,"缺勤日期",{"$nulls":30},{"$f":"日历年","v":2023}]
[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,"Harsimran Brar",{"$nulls":31},0]
[null,"Jordan Mitchell",{"$nulls":31},0]
[null,"Asaf Karten",{"$nulls":31},0]
[null,"Vanja Jovanovic",{"$nulls":31},0]
[null,"Madison Butler",{"$nulls":31},0]
[null,{"$f":"MonthName&\"汇总\"","v":"9 月汇总"},{"$f":"SUBTOTAL(103,_9_月[1])","v":0},{"$f":"SUBTOTAL(103,_9_月[2])","v":0},{"$f":"SUBTOTAL(103,_9_月[3])","v":0},{"$f":"SUBTOTAL(103,_9_月[4])","v":0},{"$f":"SUBTOTAL(103,_9_月[5])","v":0},{"$f":"SUBTOTAL(103,_9_月[6])","v":0},{"$f":"SUBTOTAL(103,_9_月[7])","v":0},{"$f":"SUBTOTAL(103,_9_月[8])","v":0},{"$f":"SUBTOTAL(103,_9_月[9])","v":0},{"$f":"SUBTOTAL(103,_9_月[10])","v":0},{"$f":"SUBTOTAL(103,_9_月[11])","v":0},{"$f":"SUBTOTAL(103,_9_月[12])","v":0},{"$f":"SUBTOTAL(103,_9_月[13])","v":0},{"$f":"SUBTOTAL(103,_9_月[14])","v":0},{"$f":"SUBTOTAL(103,_9_月[15])","v":0},{"$f":"SUBTOTAL(103,_9_月[16])","v":0},{"$f":"SUBTOTAL(103,_9_月[17])","v":0},{"$f":"SUBTOTAL(103,_9_月[18])","v":0},{"$f":"SUBTOTAL(103,_9_月[19])","v":0},{"$f":"SUBTOTAL(103,_9_月[20])","v":0},{"$f":"SUBTOTAL(103,_9_月[21])","v":0},{"$f":"SUBTOTAL(103,_9_月[22])","v":0},{"$f":"SUBTOTAL(103,_9_月[23])","v":0},{"$f":"SUBTOTAL(103,_9_月[24])","v":0},{"$f":"SUBTOTAL(103,_9_月[25])","v":0},{"$f":"SUBTOTAL(103,_9_月[26])","v":0},{"$f":"SUBTOTAL(103,_9_月[27])","v":0},{"$f":"SUBTOTAL(103,_9_月[28])","v":0},{"$f":"SUBTOTAL(103,_9_月[29])","v":0},{"$f":"SUBTOTAL(109,_9_月[30])","v":0},{"$f":"SUBTOTAL(109,_9_月[[ ]])","v":0},{"$f":"SUBTOTAL(109,_9_月[总天数])","v":0}]

{"sheet":"10 月","index":9,"n_rows":14,"n_cols":34,"rows_kept":14,"merged":[[3,3,3,4],[3,6,3,7],[3,9,3,10],[3,12,3,13],[3,15,3,16],[5,2,5,32]]}
[null,"员工考勤时间表"]
[null,"10 月"]
[]
[null,"缺勤类型键","V","休假",null,"P","个人",null,"S","病假",null,null,"自定义 1",null,null,"自定义 2"]
[]
[null,null,"缺勤日期",{"$nulls":30},{"$f":"日历年","v":2023}]
[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,"Harsimran Brar",{"$nulls":31},0]
[null,"Jordan Mitchell",{"$nulls":31},0]
[null,"Asaf Karten",{"$nulls":31},0]
[null,"Vanja Jovanovic",{"$nulls":31},0]
[null,"Madison Butler",{"$nulls":31},0]
[null,{"$f":"MonthName&\"汇总\"","v":"10 月汇总"},{"$f":"SUBTOTAL(103,_10_月[1])","v":0},{"$f":"SUBTOTAL(103,_10_月[2])","v":0},{"$f":"SUBTOTAL(103,_10_月[3])","v":0},{"$f":"SUBTOTAL(103,_10_月[4])","v":0},{"$f":"SUBTOTAL(103,_10_月[5])","v":0},{"$f":"SUBTOTAL(103,_10_月[6])","v":0},{"$f":"SUBTOTAL(103,_10_月[7])","v":0},{"$f":"SUBTOTAL(103,_10_月[8])","v":0},{"$f":"SUBTOTAL(103,_10_月[9])","v":0},{"$f":"SUBTOTAL(103,_10_月[10])","v":0},{"$f":"SUBTOTAL(103,_10_月[11])","v":0},{"$f":"SUBTOTAL(103,_10_月[12])","v":0},{"$f":"SUBTOTAL(103,_10_月[13])","v":0},{"$f":"SUBTOTAL(103,_10_月[14])","v":0},{"$f":"SUBTOTAL(103,_10_月[15])","v":0},{"$f":"SUBTOTAL(103,_10_月[16])","v":0},{"$f":"SUBTOTAL(103,_10_月[17])","v":0},{"$f":"SUBTOTAL(103,_10_月[18])","v":0},{"$f":"SUBTOTAL(103,_10_月[19])","v":0},{"$f":"SUBTOTAL(103,_10_月[20])","v":0},{"$f":"SUBTOTAL(103,_10_月[21])","v":0},{"$f":"SUBTOTAL(103,_10_月[22])","v":0},{"$f":"SUBTOTAL(103,_10_月[23])","v":0},{"$f":"SUBTOTAL(103,_10_月[24])","v":0},{"$f":"SUBTOTAL(103,_10_月[25])","v":0},{"$f":"SUBTOTAL(103,_10_月[26])","v":0},{"$f":"SUBTOTAL(103,_10_月[27])","v":0},{"$f":"SUBTOTAL(103,_10_月[28])","v":0},{"$f":"SUBTOTAL(103,_10_月[29])","v":0},{"$f":"SUBTOTAL(109,_10_月[30])","v":0},{"$f":"SUBTOTAL(109,_10_月[31])","v":0},{"$f":"SUBTOTAL(109,_10_月[总天数])","v":0}]

{"sheet":"11 月","index":10,"n_rows":14,"n_cols":34,"rows_kept":14,"merged":[[3,3,3,4],[3,6,3,7],[3,9,3,10],[3,12,3,13],[3,15,3,16],[5,2,5,32]]}
[null,"员工考勤时间表"]
[null,"11 月"]
[]
[null,"缺勤类型键","V","休假",null,"P","个人",null,"S","病假",null,null,"自定义 1",null,null,"自定义 2"]
[]
[null,null,"缺勤日期",{"$nulls":30},{"$f":"日历年","v":2023}]
[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,"Harsimran Brar",{"$nulls":31},0]
[null,"Jordan Mitchell",{"$nulls":31},0]
[null,"Asaf Karten",{"$nulls":31},0]
[null,"Vanja Jovanovic",{"$nulls":31},0]
[null,"Madison Butler",{"$nulls":31},0]
[null,{"$f":"MonthName&\"汇总\"","v":"11 月汇总"},{"$f":"SUBTOTAL(103,_11_月[1])","v":0},{"$f":"SUBTOTAL(103,_11_月[2])","v":0},{"$f":"SUBTOTAL(103,_11_月[3])","v":0},{"$f":"SUBTOTAL(103,_11_月[4])","v":0},{"$f":"SUBTOTAL(103,_11_月[5])","v":0},{"$f":"SUBTOTAL(103,_11_月[6])","v":0},{"$f":"SUBTOTAL(103,_11_月[7])","v":0},{"$f":"SUBTOTAL(103,_11_月[8])","v":0},{"$f":"SUBTOTAL(103,_11_月[9])","v":0},{"$f":"SUBTOTAL(103,_11_月[10])","v":0},{"$f":"SUBTOTAL(103,_11_月[11])","v":0},{"$f":"SUBTOTAL(103,_11_月[12])","v":0},{"$f":"SUBTOTAL(103,_11_月[13])","v":0},{"$f":"SUBTOTAL(103,_11_月[14])","v":0},{"$f":"SUBTOTAL(103,_11_月[15])","v":0},{"$f":"SUBTOTAL(103,_11_月[16])","v":0},{"$f":"SUBTOTAL(103,_11_月[17])","v":0},{"$f":"SUBTOTAL(103,_11_月[18])","v":0},{"$f":"SUBTOTAL(103,_11_月[19])","v":0},{"$f":"SUBTOTAL(103,_11_月[20])","v":0},{"$f":"SUBTOTAL(103,_11_月[21])","v":0},{"$f":"SUBTOTAL(103,_11_月[22])","v":0},{"$f":"SUBTOTAL(103,_11_月[23])","v":0},{"$f":"SUBTOTAL(103,_11_月[24])","v":0},{"$f":"SUBTOTAL(103,_11_月[25])","v":0},{"$f":"SUBTOTAL(103,_11_月[26])","v":0},{"$f":"SUBTOTAL(103,_11_月[27])","v":0},{"$f":"SUBTOTAL(103,_11_月[28])","v":0},{"$f":"SUBTOTAL(103,_11_月[29])","v":0},{"$f":"SUBTOTAL(109,_11_月[30])","v":0},{"$f":"SUBTOTAL(109,_11_月[[ ]])","v":0},{"$f":"SUBTOTAL(109,_11_月[总天数])","v":0}]

{"sheet":"12 月","index":11,"n_rows":14,"n_cols":34,"rows_kept":14,"merged":[[3,3,3,4],[3,6,3,7],[3,9,3,10],[3,12,3,13],[3,15,3,16],[5,2,5,32]]}
[null,"员工考勤时间表"]
[null,"12 月"]
[]
[null,"缺勤类型键","V","休假",null,"P","个人",null,"S","病假",null,null,"自定义 1",null,null,"自定义 2"]
[]
[null,null,"缺勤日期",{"$nulls":30},{"$f":"日历年","v":2023}]
[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,"Harsimran Brar",{"$nulls":31},0]
[null,"Jordan Mitchell",{"$nulls":31},0]
[null,"Asaf Karten",{"$nulls":31},0]
[null,"Vanja Jovanovic",{"$nulls":31},0]
[null,"Madison Butler",{"$nulls":31},0]
[null,{"$f":"MonthName&\"汇总\"","v":"12 月汇总"},{"$f":"SUBTOTAL(103,_12_月[1])","v":0},{"$f":"SUBTOTAL(103,_12_月[2])","v":0},{"$f":"SUBTOTAL(103,_12_月[3])","v":0},{"$f":"SUBTOTAL(103,_12_月[4])","v":0},{"$f":"SUBTOTAL(103,_12_月[5])","v":0},{"$f":"SUBTOTAL(103,_12_月[6])","v":0},{"$f":"SUBTOTAL(103,_12_月[7])","v":0},{"$f":"SUBTOTAL(103,_12_月[8])","v":0},{"$f":"SUBTOTAL(103,_12_月[9])","v":0},{"$f":"SUBTOTAL(103,_12_月[10])","v":0},{"$f":"SUBTOTAL(103,_12_月[11])","v":0},{"$f":"SUBTOTAL(103,_12_月[12])","v":0},{"$f":"SUBTOTAL(103,_12_月[13])","v":0},{"$f":"SUBTOTAL(103,_12_月[14])","v":0},{"$f":"SUBTOTAL(103,_12_月[15])","v":0},{"$f":"SUBTOTAL(103,_12_月[16])","v":0},{"$f":"SUBTOTAL(103,_12_月[17])","v":0},{"$f":"SUBTOTAL(103,_12_月[18])","v":0},{"$f":"SUBTOTAL(103,_12_月[19])","v":0},{"$f":"SUBTOTAL(103,_12_月[20])","v":0},{"$f":"SUBTOTAL(103,_12_月[21])","v":0},{"$f":"SUBTOTAL(103,_12_月[22])","v":0},{"$f":"SUBTOTAL(103,_12_月[23])","v":0},{"$f":"SUBTOTAL(103,_12_月[24])","v":0},{"$f":"SUBTOTAL(103,_12_月[25])","v":0},{"$f":"SUBTOTAL(103,_12_月[26])","v":0},{"$f":"SUBTOTAL(103,_12_月[27])","v":0},{"$f":"SUBTOTAL(103,_12_月[28])","v":0},{"$f":"SUBTOTAL(103,_12_月[29])","v":0},{"$f":"SUBTOTAL(109,_12_月[30])","v":0},{"$f":"SUBTOTAL(109,_12_月[31])","v":0},{"$f":"SUBTOTAL(109,_12_月[总天数])","v":0}]

{"sheet":"员工姓名","index":12,"n_rows":8,"n_cols":2,"rows_kept":8}
[null,"员工姓名"]
[]
[null,"员工姓名"]
[null,"Harsimran Brar"]
[null,"Jordan Mitchell"]
[null,"Asaf Karten"]
[null,"Vanja Jovanovic"]
[null,"Madison Butler"]