{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["年度考勤表"],"not_rendered":{"defined_names":2},"read":"whole","date_system":"1900"}

{"sheet":"年度考勤表","index":0,"n_rows":140,"n_cols":12,"rows_kept":140,"merged":[[0,1,1,11],[2,6,2,7],[2,8,2,9],[5,1,5,11],[39,1,39,11],[73,1,73,11],[107,1,107,11]]}
[null,"员工考勤表"]
[]
[null,"员工姓名：",null,"电子邮件：",null,null,"年初至今总计："]
[null,"经理：",null,"电话：",null,null,"正常工作时数：",{"$f":"SUM(C16,C27,C38,C50,C61,C72,C84,C95,C106,C118,C129,C140)","v":0},"加班时数：",{"$f":"SUM(F16,F27,F38,F50,F61,F72,F84,F95,F106,F118,F129,F140)","v":0},"总计：",{"$f":"SUM(H4:J4)","v":0}]
[]
[null,"1 月、2 月、3 月     员工考勤卡：每日、每周、每月、每年"]
[null,"1 月","第 1 周","加班","第 2 周","加班 ","第 3 周","加班  ","第 4 周","加班   ","第 5 周","加班    "]
[null,"星期一"]
[null,"星期二"]
[null,"星期三"]
[null,"星期四"]
[null,"星期五"]
[null,"星期六"]
[null,"星期日"]
[null,"每周总时数",{"$f":"SUBTOTAL(109,_1_月[第 1 周])","v":0},{"$f":"SUBTOTAL(109,_1_月[加班])","v":0},{"$f":"SUBTOTAL(109,_1_月[第 2 周])","v":0},{"$f":"SUBTOTAL(109,_1_月[[加班 ]])","v":0},{"$f":"SUBTOTAL(109,_1_月[第 3 周])","v":0},{"$f":"SUBTOTAL(109,_1_月[[加班  ]])","v":0},{"$f":"SUBTOTAL(109,_1_月[第 4 周])","v":0},{"$f":"SUBTOTAL(109,_1_月[[加班   ]])","v":0},{"$f":"SUBTOTAL(109,_1_月[第 5 周])","v":0},{"$f":"SUBTOTAL(109,_1_月[[加班    ]])","v":0}]
[null,"1 月总计：正常工作时数",{"$f":"SUM(_1_月[[#Totals],[第 1 周]],_1_月[[#Totals],[第 2 周]],_1_月[[#Totals],[第 3 周]],_1_月[[#Totals],[第 4 周]],_1_月[[#Totals],[第 5 周]])","v":0},"1 月总计：加班",null,{"$f":"SUM(_1_月[[#Totals],[加班]],_1_月[[#Totals],[加班 ]],_1_月[[#Totals],[加班  ]],_1_月[[#Totals],[加班   ]],_1_月[[#Totals],[加班    ]])","v":0}]
[]
[null,"2 月","第 1 周","加班","第 2 周","加班 ","第 3 周","加班  ","第 4 周","加班   ","第 5 周","加班    "]
[null,"星期一"]
[null,"星期二"]
[null,"星期三"]
[null,"星期四"]
[null,"星期五"]
[null,"星期六"]
[null,"星期日"]
[null,"每周总时数",{"$f":"SUBTOTAL(109,_2_月[第 1 周])","v":0},{"$f":"SUBTOTAL(109,_2_月[加班])","v":0},{"$f":"SUBTOTAL(109,_2_月[第 2 周])","v":0},{"$f":"SUBTOTAL(109,_2_月[[加班 ]])","v":0},{"$f":"SUBTOTAL(109,_2_月[第 3 周])","v":0},{"$f":"SUBTOTAL(109,_2_月[[加班  ]])","v":0},{"$f":"SUBTOTAL(109,_2_月[第 4 周])","v":0},{"$f":"SUBTOTAL(109,_2_月[[加班   ]])","v":0},{"$f":"SUBTOTAL(109,_2_月[第 5 周])","v":0},{"$f":"SUBTOTAL(109,_2_月[[加班    ]])","v":0}]
[null,"2 月总计：正常工作时数",{"$f":"SUM(_2_月[[#Totals],[第 1 周]],_2_月[[#Totals],[第 2 周]],_2_月[[#Totals],[第 3 周]],_2_月[[#Totals],[第 4 周]],_2_月[[#Totals],[第 5 周]])","v":0},"2 月总计：加班",null,{"$f":"SUM(_2_月[[#Totals],[加班]],_2_月[[#Totals],[加班 ]],_2_月[[#Totals],[加班  ]],_2_月[[#Totals],[加班   ]],_2_月[[#Totals],[加班    ]])","v":0}]
[]
[null,"3 月","第 1 周","加班","第 2 周","加班 ","第 3 周","加班  ","第 4 周","加班   ","第 5 周","加班    "]
[null,"星期一"]
[null,"星期二"]
[null,"星期三"]
[null,"星期四"]
[null,"星期五"]
[null,"星期六"]
[null,"星期日"]
[null,"每周总时数",{"$f":"SUBTOTAL(109,_3_月[第 1 周])","v":0},{"$f":"SUBTOTAL(109,_3_月[加班])","v":0},{"$f":"SUBTOTAL(109,_3_月[第 2 周])","v":0},{"$f":"SUBTOTAL(109,_3_月[[加班 ]])","v":0},{"$f":"SUBTOTAL(109,_3_月[第 3 周])","v":0},{"$f":"SUBTOTAL(109,_3_月[[加班  ]])","v":0},{"$f":"SUBTOTAL(109,_3_月[第 4 周])","v":0},{"$f":"SUBTOTAL(109,_3_月[[加班   ]])","v":0},{"$f":"SUBTOTAL(109,_3_月[第 5 周])","v":0},{"$f":"SUBTOTAL(109,_3_月[[加班    ]])","v":0}]
[null,"3 月总计：正常工作时数",{"$f":"SUM(_3_月[[#Totals],[第 1 周]],_3_月[[#Totals],[第 2 周]],_3_月[[#Totals],[第 3 周]],_3_月[[#Totals],[第 4 周]],_3_月[[#Totals],[第 5 周]])","v":0},"3 月总计：加班",null,{"$f":"SUM(_3_月[[#Totals],[加班]],_3_月[[#Totals],[加班 ]],_3_月[[#Totals],[加班  ]],_3_月[[#Totals],[加班   ]],_3_月[[#Totals],[加班    ]])","v":0}]
[]
[null,"4 月、5 月、6 月     员工考勤卡：每日、每周、每月、每年"]
[null,"4 月","第 1 周","加班","第 2 周","加班 ","第 3 周","加班  ","第 4 周","加班   ","第 5 周","加班    "]
[null,"星期一"]
[null,"星期二"]
[null,"星期三"]
[null,"星期四"]
[null,"星期五"]
[null,"星期六"]
[null,"星期日"]
[null,"每周总时数",{"$f":"SUBTOTAL(109,_4_月[第 1 周])","v":0},{"$f":"SUBTOTAL(109,_4_月[加班])","v":0},{"$f":"SUBTOTAL(109,_4_月[第 2 周])","v":0},{"$f":"SUBTOTAL(109,_4_月[[加班 ]])","v":0},{"$f":"SUBTOTAL(109,_4_月[第 3 周])","v":0},{"$f":"SUBTOTAL(109,_4_月[[加班  ]])","v":0},{"$f":"SUBTOTAL(109,_4_月[第 4 周])","v":0},{"$f":"SUBTOTAL(109,_4_月[[加班   ]])","v":0},{"$f":"SUBTOTAL(109,_4_月[第 5 周])","v":0},{"$f":"SUBTOTAL(109,_4_月[[加班    ]])","v":0}]
[null,"4 月总计：正常工作时数",{"$f":"SUM(_4_月[[#Totals],[第 1 周]],_4_月[[#Totals],[第 2 周]],_4_月[[#Totals],[第 3 周]],_4_月[[#Totals],[第 4 周]],_4_月[[#Totals],[第 5 周]])","v":0},"4 月总计：加班",null,{"$f":"SUM(_4_月[[#Totals],[加班]],_4_月[[#Totals],[加班 ]],_4_月[[#Totals],[加班  ]],_4_月[[#Totals],[加班   ]],_4_月[[#Totals],[加班    ]])","v":0}]
[]
[null,"5 月","第 1 周","加班","第 2 周","加班 ","第 3 周","加班  ","第 4 周","加班   ","第 5 周","加班    "]
[null,"星期一"]
[null,"星期二"]
[null,"星期三"]
[null,"星期四"]
[null,"星期五"]
[null,"星期六"]
[null,"星期日"]
[null,"每周总时数",{"$f":"SUBTOTAL(109,_5_月[第 1 周])","v":0},{"$f":"SUBTOTAL(109,_5_月[加班])","v":0},{"$f":"SUBTOTAL(109,_5_月[第 2 周])","v":0},{"$f":"SUBTOTAL(109,_5_月[[加班 ]])","v":0},{"$f":"SUBTOTAL(109,_5_月[第 3 周])","v":0},{"$f":"SUBTOTAL(109,_5_月[[加班  ]])","v":0},{"$f":"SUBTOTAL(109,_5_月[第 4 周])","v":0},{"$f":"SUBTOTAL(109,_5_月[[加班   ]])","v":0},{"$f":"SUBTOTAL(109,_5_月[第 5 周])","v":0},{"$f":"SUBTOTAL(109,_5_月[[加班    ]])","v":0}]
[null,"5 月总计：正常工作时数",{"$f":"SUM(_5_月[[#Totals],[第 1 周]],_5_月[[#Totals],[第 2 周]],_5_月[[#Totals],[第 3 周]],_5_月[[#Totals],[第 4 周]],_5_月[[#Totals],[第 5 周]])","v":0},"5 月总计：加班",null,{"$f":"SUM(_5_月[[#Totals],[加班]],_5_月[[#Totals],[加班 ]],_5_月[[#Totals],[加班  ]],_5_月[[#Totals],[加班   ]],_5_月[[#Totals],[加班    ]])","v":0}]
[]
[null,"6 月","第 1 周","加班","第 2 周","加班 ","第 3 周","加班  ","第 4 周","加班   ","第 5 周","加班    "]
[null,"星期一"]
[null,"星期二"]
[null,"星期三"]
[null,"星期四"]
[null,"星期五"]
[null,"星期六"]
[null,"星期日"]
[null,"每周总时数",{"$f":"SUBTOTAL(109,_6_月[第 1 周])","v":0},{"$f":"SUBTOTAL(109,_6_月[加班])","v":0},{"$f":"SUBTOTAL(109,_6_月[第 2 周])","v":0},{"$f":"SUBTOTAL(109,_6_月[[加班 ]])","v":0},{"$f":"SUBTOTAL(109,_6_月[第 3 周])","v":0},{"$f":"SUBTOTAL(109,_6_月[[加班  ]])","v":0},{"$f":"SUBTOTAL(109,_6_月[第 4 周])","v":0},{"$f":"SUBTOTAL(109,_6_月[[加班   ]])","v":0},{"$f":"SUBTOTAL(109,_6_月[第 5 周])","v":0},{"$f":"SUBTOTAL(109,_6_月[[加班    ]])","v":0}]
[null,"6 月总计：正常工作时数",{"$f":"SUM(_6_月[[#Totals],[第 1 周]],_6_月[[#Totals],[第 2 周]],_6_月[[#Totals],[第 3 周]],_6_月[[#Totals],[第 4 周]],_6_月[[#Totals],[第 5 周]])","v":0},"6 月总计：加班",null,{"$f":"SUM(_6_月[[#Totals],[加班]],_6_月[[#Totals],[加班 ]],_6_月[[#Totals],[加班  ]],_6_月[[#Totals],[加班   ]],_6_月[[#Totals],[加班    ]])","v":0}]
[]
[null,"7 月、8 月、9 月     员工考勤卡：每日、每周、每月、每年"]
[null,"7 月","第 1 周","加班","第 2 周","加班 ","第 3 周","加班  ","第 4 周","加班   ","第 5 周","加班    "]
[null,"星期一"]
[null,"星期二"]
[null,"星期三"]
[null,"星期四"]
[null,"星期五"]
[null,"星期六"]
[null,"星期日"]
[null,"每周总时数",{"$f":"SUBTOTAL(109,_7_月[第 1 周])","v":0},{"$f":"SUBTOTAL(109,_7_月[加班])","v":0},{"$f":"SUBTOTAL(109,_7_月[第 2 周])","v":0},{"$f":"SUBTOTAL(109,_7_月[[加班 ]])","v":0},{"$f":"SUBTOTAL(109,_7_月[第 3 周])","v":0},{"$f":"SUBTOTAL(109,_7_月[[加班  ]])","v":0},{"$f":"SUBTOTAL(109,_7_月[第 4 周])","v":0},{"$f":"SUBTOTAL(109,_7_月[[加班   ]])","v":0},{"$f":"SUBTOTAL(109,_7_月[第 5 周])","v":0},{"$f":"SUBTOTAL(109,_7_月[[加班    ]])","v":0}]
[null,"7 月总计：正常工作时数",{"$f":"SUM(_7_月[[#Totals],[第 1 周]],_7_月[[#Totals],[第 2 周]],_7_月[[#Totals],[第 3 周]],_7_月[[#Totals],[第 4 周]],_7_月[[#Totals],[第 5 周]])","v":0},"7 月总计：加班",null,{"$f":"SUM(_7_月[[#Totals],[加班]],_7_月[[#Totals],[加班 ]],_7_月[[#Totals],[加班  ]],_7_月[[#Totals],[加班   ]],_7_月[[#Totals],[加班    ]])","v":0}]
[]
[null,"8 月","第 1 周","加班","第 2 周","加班 ","第 3 周","加班  ","第 4 周","加班   ","第 5 周","加班    "]
[null,"星期一"]
[null,"星期二"]
[null,"星期三"]
[null,"星期四"]
[null,"星期五"]
[null,"星期六"]
[null,"星期日"]
[null,"每周总时数",{"$f":"SUBTOTAL(109,_8_月[第 1 周])","v":0},{"$f":"SUBTOTAL(109,_8_月[加班])","v":0},{"$f":"SUBTOTAL(109,_8_月[第 2 周])","v":0},{"$f":"SUBTOTAL(109,_8_月[[加班 ]])","v":0},{"$f":"SUBTOTAL(109,_8_月[第 3 周])","v":0},{"$f":"SUBTOTAL(109,_8_月[[加班  ]])","v":0},{"$f":"SUBTOTAL(109,_8_月[第 4 周])","v":0},{"$f":"SUBTOTAL(109,_8_月[[加班   ]])","v":0},{"$f":"SUBTOTAL(109,_8_月[第 5 周])","v":0},{"$f":"SUBTOTAL(109,_8_月[[加班    ]])","v":0}]
[null,"8 月总计：正常工作时数",{"$f":"SUM(_8_月[[#Totals],[第 1 周]],_8_月[[#Totals],[第 2 周]],_8_月[[#Totals],[第 3 周]],_8_月[[#Totals],[第 4 周]],_8_月[[#Totals],[第 5 周]])","v":0},"8 月总计：加班",null,{"$f":"SUM(_8_月[[#Totals],[加班]],_8_月[[#Totals],[加班 ]],_8_月[[#Totals],[加班  ]],_8_月[[#Totals],[加班   ]],_8_月[[#Totals],[加班    ]])","v":0}]
[]
[null,"9 月","第 1 周","加班","第 2 周","加班 ","第 3 周","加班  ","第 4 周","加班   ","第 5 周","加班    "]
[null,"星期一"]
[null,"星期二"]
[null,"星期三"]
[null,"星期四"]
[null,"星期五"]
[null,"星期六"]
[null,"星期日"]
[null,"每周总时数",{"$f":"SUBTOTAL(109,_9_月[第 1 周])","v":0},{"$f":"SUBTOTAL(109,_9_月[加班])","v":0},{"$f":"SUBTOTAL(109,_9_月[第 2 周])","v":0},{"$f":"SUBTOTAL(109,_9_月[[加班 ]])","v":0},{"$f":"SUBTOTAL(109,_9_月[第 3 周])","v":0},{"$f":"SUBTOTAL(109,_9_月[[加班  ]])","v":0},{"$f":"SUBTOTAL(109,_9_月[第 4 周])","v":0},{"$f":"SUBTOTAL(109,_9_月[[加班   ]])","v":0},{"$f":"SUBTOTAL(109,_9_月[第 5 周])","v":0},{"$f":"SUBTOTAL(109,_9_月[[加班    ]])","v":0}]
[null,"9 月总计：正常工作时数",{"$f":"SUM(_9_月[[#Totals],[第 1 周]],_9_月[[#Totals],[第 2 周]],_9_月[[#Totals],[第 3 周]],_9_月[[#Totals],[第 4 周]],_9_月[[#Totals],[第 5 周]])","v":0},"9 月总计：加班",null,{"$f":"SUM(_9_月[[#Totals],[加班]],_9_月[[#Totals],[加班 ]],_9_月[[#Totals],[加班  ]],_9_月[[#Totals],[加班   ]],_9_月[[#Totals],[加班    ]])","v":0}]
[]
[null,"10 月、11 月、12 月     员工考勤卡：每日、每周、每月、每年"]
[null,"10 月","第 1 周","加班","第 2 周","加班 ","第 3 周","加班  ","第 4 周","加班   ","第 5 周","加班    "]
[null,"星期一"]
[null,"星期二"]
[null,"星期三"]
[null,"星期四"]
[null,"星期五"]
[null,"星期六"]
[null,"星期日"]
[null,"每周总时数",{"$f":"SUBTOTAL(109,_10_月[第 1 周])","v":0},{"$f":"SUBTOTAL(109,_10_月[加班])","v":0},{"$f":"SUBTOTAL(109,_10_月[第 2 周])","v":0},{"$f":"SUBTOTAL(109,_10_月[[加班 ]])","v":0},{"$f":"SUBTOTAL(109,_10_月[第 3 周])","v":0},{"$f":"SUBTOTAL(109,_10_月[[加班  ]])","v":0},{"$f":"SUBTOTAL(109,_10_月[第 4 周])","v":0},{"$f":"SUBTOTAL(109,_10_月[[加班   ]])","v":0},{"$f":"SUBTOTAL(109,_10_月[第 5 周])","v":0},{"$f":"SUBTOTAL(109,_10_月[[加班    ]])","v":0}]
[null,"10 月总计：正常工作时数",{"$f":"SUM(_10_月[[#Totals],[第 1 周]],_10_月[[#Totals],[第 2 周]],_10_月[[#Totals],[第 3 周]],_10_月[[#Totals],[第 4 周]],_10_月[[#Totals],[第 5 周]])","v":0},"10 月总计：加班",null,{"$f":"SUM(_10_月[[#Totals],[加班]],_10_月[[#Totals],[加班 ]],_10_月[[#Totals],[加班  ]],_10_月[[#Totals],[加班   ]],_10_月[[#Totals],[加班    ]])","v":0}]
[]
[null,"11 月","第 1 周","加班","第 2 周","加班 ","第 3 周","加班  ","第 4 周","加班   ","第 5 周","加班    "]
[null,"星期一"]
[null,"星期二"]
[null,"星期三"]
[null,"星期四"]
[null,"星期五"]
[null,"星期六"]
[null,"星期日"]
[null,"每周总时数",{"$f":"SUBTOTAL(109,_11_月[第 1 周])","v":0},{"$f":"SUBTOTAL(109,_11_月[加班])","v":0},{"$f":"SUBTOTAL(109,_11_月[第 2 周])","v":0},{"$f":"SUBTOTAL(109,_11_月[[加班 ]])","v":0},{"$f":"SUBTOTAL(109,_11_月[第 3 周])","v":0},{"$f":"SUBTOTAL(109,_11_月[[加班  ]])","v":0},{"$f":"SUBTOTAL(109,_11_月[第 4 周])","v":0},{"$f":"SUBTOTAL(109,_11_月[[加班   ]])","v":0},{"$f":"SUBTOTAL(109,_11_月[第 5 周])","v":0},{"$f":"SUBTOTAL(109,_11_月[[加班    ]])","v":0}]
[null,"11 月总计：正常工作时数",{"$f":"SUM(_11_月[[#Totals],[第 1 周]],_11_月[[#Totals],[第 2 周]],_11_月[[#Totals],[第 3 周]],_11_月[[#Totals],[第 4 周]],_11_月[[#Totals],[第 5 周]])","v":0},"11 月总计：加班",null,{"$f":"SUM(_11_月[[#Totals],[加班]],_11_月[[#Totals],[加班 ]],_11_月[[#Totals],[加班  ]],_11_月[[#Totals],[加班   ]],_11_月[[#Totals],[加班    ]])","v":0}]
[]
[null,"12 月","第 1 周","加班","第 2 周","加班 ","第 3 周","加班  ","第 4 周","加班   ","第 5 周","加班    "]
[null,"星期一"]
[null,"星期二"]
[null,"星期三"]
[null,"星期四"]
[null,"星期五"]
[null,"星期六"]
[null,"星期日"]
[null,"每周总时数",{"$f":"SUBTOTAL(109,_12_月[第 1 周])","v":0},{"$f":"SUBTOTAL(109,_12_月[加班])","v":0},{"$f":"SUBTOTAL(105,_12_月[第 2 周])","v":0},{"$f":"SUBTOTAL(109,_12_月[[加班 ]])","v":0},{"$f":"SUBTOTAL(109,_12_月[第 3 周])","v":0},{"$f":"SUBTOTAL(109,_12_月[[加班  ]])","v":0},{"$f":"SUBTOTAL(109,_12_月[第 4 周])","v":0},{"$f":"SUBTOTAL(109,_12_月[[加班   ]])","v":0},{"$f":"SUBTOTAL(109,_12_月[第 5 周])","v":0},{"$f":"SUBTOTAL(109,_12_月[[加班    ]])","v":0}]
[null,"12 月总计：正常工作时数",{"$f":"SUM(_12_月[[#Totals],[第 1 周]],_12_月[[#Totals],[第 2 周]],_12_月[[#Totals],[第 3 周]],_12_月[[#Totals],[第 4 周]],_12_月[[#Totals],[第 5 周]])","v":0},"12 月总计：加班",null,{"$f":"SUM(_12_月[[#Totals],[加班]],_12_月[[#Totals],[加班 ]],_12_月[[#Totals],[加班  ]],_12_月[[#Totals],[加班   ]],_12_月[[#Totals],[加班    ]])","v":0}]