{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["两周一次的考勤表"],"not_rendered":{"defined_names":7},"read":"whole","date_system":"1900"}

{"sheet":"两周一次的考勤表","index":0,"n_rows":28,"n_cols":8,"rows_kept":28,"merged":[[0,1,0,5],[1,1,1,5],[1,6,1,7],[2,1,2,2],[2,3,2,4],[2,6,2,7],[3,1,3,2],[3,3,3,4],[4,1,4,2],[4,3,4,4],[25,1,25,4],[26,1,26,4],[27,1,27,4]]}
[null,"公司名称"]
[null,"省/市/自治区，街道地址，地址 2，邮政编码",{"$nulls":4},"每周时间工作表（含休假）"]
[null,"员工：",{"$nulls":3},"员工电话："]
[null,"员工电子邮件：",{"$nulls":3},"付薪周期开始日期：",null,{"$f":"TODAY()","v":"2022-05-30"}]
[null,"经理：",{"$nulls":3},"付薪周期结束日期：",null,{"$f":"IF($H$4=\"\",\"\",$H$4+13)","v":"2022-06-12"}]
[]
[null,"星期","日期","正常工作时数","加班小时数","病假","休假","汇总"]
[null,{"$f":"IFERROR(TEXT(考勤记录[[#This Row],[日期]],\"aaaa\"), \"\")","v":"星期一"},{"$f":"H4","v":"2022-05-30"},{"v":8,"d":"8.00"},{"$nulls":3},{"$f":"IFERROR(SUM(D8:G8), \"\")","v":{"v":8,"d":"8.00"}}]
[null,{"$f":"IFERROR(TEXT(考勤记录[[#This Row],[日期]],\"aaaa\"), \"\")","v":"星期二"},{"$f":"IF($H$4=\"\",\"\",$H$4+1)","v":"2022-05-31"},{"v":8,"d":"8.00"},{"v":2,"d":"2.00"},null,null,{"$f":"IFERROR(SUM(D9:G9), \"\")","v":{"v":10,"d":"10.00"}}]
[null,{"$f":"IFERROR(TEXT(考勤记录[[#This Row],[日期]],\"aaaa\"), \"\")","v":"星期三"},{"$f":"IF($H$4=\"\",\"\",$H$4+2)","v":"2022-06-01"},null,null,{"v":8,"d":"8.00"},null,{"v":8,"d":"8.00"}]
[null,{"$f":"IFERROR(TEXT(考勤记录[[#This Row],[日期]],\"aaaa\"), \"\")","v":"星期四"},{"$f":"IF($H$4=\"\",\"\",$H$4+3)","v":"2022-06-02"},{"$nulls":3},{"v":8,"d":"8.00"},{"v":8,"d":"8.00"}]
[null,{"$f":"IFERROR(TEXT(考勤记录[[#This Row],[日期]],\"aaaa\"), \"\")","v":"星期五"},{"$f":"IF($H$4=\"\",\"\",$H$4+4)","v":"2022-06-03"},{"$nulls":4},0]
[null,{"$f":"IFERROR(TEXT(考勤记录[[#This Row],[日期]],\"aaaa\"), \"\")","v":"星期六"},{"$f":"IF($H$4=\"\",\"\",$H$4+5)","v":"2022-06-04"},{"$nulls":4},0]
[null,{"$f":"IFERROR(TEXT(考勤记录[[#This Row],[日期]],\"aaaa\"), \"\")","v":"星期日"},{"$f":"IF($H$4=\"\",\"\",$H$4+6)","v":"2022-06-05"},{"$nulls":4},0]
[null,{"$f":"IFERROR(TEXT(考勤记录[[#This Row],[日期]],\"aaaa\"), \"\")","v":"星期一"},{"$f":"IF($H$4=\"\",\"\",$H$4+7)","v":"2022-06-06"},{"$nulls":4},0]
[null,{"$f":"IFERROR(TEXT(考勤记录[[#This Row],[日期]],\"aaaa\"), \"\")","v":"星期二"},{"$f":"IF($H$4=\"\",\"\",$H$4+8)","v":"2022-06-07"},{"$nulls":4},0]
[null,{"$f":"IFERROR(TEXT(考勤记录[[#This Row],[日期]],\"aaaa\"), \"\")","v":"星期三"},{"$f":"IF($H$4=\"\",\"\",$H$4+9)","v":"2022-06-08"},{"$nulls":4},0]
[null,{"$f":"IFERROR(TEXT(考勤记录[[#This Row],[日期]],\"aaaa\"), \"\")","v":"星期四"},{"$f":"IF($H$4=\"\",\"\",$H$4+10)","v":"2022-06-09"},{"$nulls":4},0]
[null,{"$f":"IFERROR(TEXT(考勤记录[[#This Row],[日期]],\"aaaa\"), \"\")","v":"星期五"},{"$f":"IF($H$4=\"\",\"\",$H$4+11)","v":"2022-06-10"},{"$nulls":4},0]
[null,{"$f":"IFERROR(TEXT(考勤记录[[#This Row],[日期]],\"aaaa\"), \"\")","v":"星期六"},{"$f":"IF($H$4=\"\",\"\",$H$4+12)","v":"2022-06-11"},{"$nulls":4},0]
[null,{"$f":"IFERROR(TEXT(考勤记录[[#This Row],[日期]],\"aaaa\"), \"\")","v":"星期日"},{"$f":"IF($H$4=\"\",\"\",$H$4+13)","v":"2022-06-12"},{"$nulls":4},0]
[null,null,"汇总",{"$f":"SUBTOTAL(109,考勤记录[正常工作时数])","v":{"v":16,"d":"16.00"}},{"$f":"SUBTOTAL(109,考勤记录[加班小时数])","v":{"v":2,"d":"2.00"}},{"$f":"SUBTOTAL(109,考勤记录[病假])","v":{"v":8,"d":"8.00"}},{"$f":"SUBTOTAL(109,考勤记录[休假])","v":{"v":8,"d":"8.00"}},{"$f":"SUBTOTAL(109,考勤记录[汇总])","v":{"v":34,"d":"34.00"}}]
[null,null,"计时工资",{"v":10,"d":"¥10.00"},{"v":15,"d":"¥15.00"},{"v":10,"d":"¥10.00"},{"v":10,"d":"¥10.00"}]
[null,null,"工资总额",{"$f":"IFERROR(SUM(D23*考勤记录[[#Totals],[正常工作时数]]), \"\")","v":{"v":160,"d":"¥160.00"}},{"$f":"IFERROR(SUM(E23*考勤记录[[#Totals],[加班小时数]]), \"\")","v":{"v":30,"d":"¥30.00"}},{"$f":"IFERROR(SUM(F23*考勤记录[[#Totals],[病假]]), \"\")","v":{"v":80,"d":"¥80.00"}},{"$f":"IFERROR(SUM(G23*考勤记录[[#Totals],[休假]]), \"\")","v":{"v":80,"d":"¥80.00"}},{"$f":"IFERROR(SUM(D24:G24), \"\")","v":{"v":350,"d":"¥350.00"}}]
[]
[null,"员工签名",{"$nulls":4},"日期"]
[]
[null,"经理签名",{"$nulls":4},"日期"]