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

{"sheet":"两周一次的考勤表","index":0,"n_rows":30,"n_cols":8,"rows_kept":30,"merged":[[0,1,0,7],[2,2,2,3],[2,5,2,6],[3,2,3,3],[3,5,3,6],[4,2,4,3],[5,2,5,3],[5,5,5,6],[6,2,6,3],[6,5,6,6]]}
[null,"两周一次的考勤表"]
[null,"公司名称"]
[null,"街道地址：",{"$nulls":3},"付薪周期开始日期："]
[null,"地址 2：",{"$nulls":3},"付薪周期结束日期："]
[null,"省/自治区/直辖市，市/县，邮政编码："]
[null,"员工：",{"$nulls":3},"员工电话："]
[null,"经理：",{"$nulls":3},"员工电子邮件："]
[]
[null,"星期几","日期","正常工作时数","加班时数","病假","休假","总计"]
[null,"星期一",{"$f":"IFERROR(IF(H3=\"\",\"\",H3),\"\")","v":""},{"v":8,"d":"8.00"},{"$nulls":3},{"$f":"IFERROR(SUM(D10:G10), \"\")","v":{"v":8,"d":"8.00"}}]
[null,"星期二",{"$f":"IF($H$3=\"\",\"\",C10+1)","v":""},{"v":8,"d":"8.00"},{"$nulls":3},{"$f":"IFERROR(SUM(D11:G11), \"\")","v":{"v":8,"d":"8.00"}}]
[null,"星期三","",{"v":8,"d":"8.00"},{"$nulls":3},{"v":8,"d":"8.00"}]
[null,"星期四","",{"v":8,"d":"8.00"},{"v":2.5,"d":"2.50"},null,null,{"v":10.5,"d":"10.50"}]
[null,"星期五","",{"v":8,"d":"8.00"},{"v":2,"d":"2.00"},null,null,{"v":10,"d":"10.00"}]
[null,"星期六","",{"$nulls":4},{"v":0,"d":"0.00"}]
[null,"星期日","",{"$nulls":4},{"v":0,"d":"0.00"}]
[null,"星期一","",{"$nulls":3},{"v":8,"d":"8.00"},{"v":8,"d":"8.00"}]
[null,"星期二","",null,null,{"v":8,"d":"8.00"},null,{"v":8,"d":"8.00"}]
[null,"星期三","",{"v":8,"d":"8.00"},{"v":1,"d":"1.00"},null,null,{"v":9,"d":"9.00"}]
[null,"星期四","",{"v":8,"d":"8.00"},{"v":1,"d":"1.00"},null,null,{"v":9,"d":"9.00"}]
[null,"星期五","",{"v":8,"d":"8.00"},{"v":1,"d":"1.00"},null,null,{"v":9,"d":"9.00"}]
[null,"星期六","",{"$nulls":4},{"v":0,"d":"0.00"}]
[null,"星期日","",{"$nulls":4},{"v":0,"d":"0.00"}]
[null,null,"总工作时数",{"$f":"IFERROR(SUM(D10:D23), \"\")","v":{"v":64,"d":"64.00"}},{"$f":"IFERROR(SUM(E10:E23), \"\")","v":{"v":7.5,"d":"7.50"}},{"$f":"IFERROR(SUM(F10:F23), \"\")","v":{"v":8,"d":"8.00"}},{"$f":"IFERROR(SUM(G10:G23), \"\")","v":{"v":8,"d":"8.00"}},{"$f":"IFERROR(SUM(H10:H23), \"\")","v":{"v":87.5,"d":"87.50"}}]
[null,null,"时薪",{"v":10,"d":"¥10.00"},{"$f":"D25*1.5","v":{"v":15,"d":"¥15.00"}},{"$f":"D25","v":{"v":10,"d":"¥10.00"}},{"$f":"D25","v":{"v":10,"d":"¥10.00"}}]
[null,null,"工资总额",{"$f":"IFERROR(D24*D25, \"\")","v":{"v":640,"d":"¥640.00"}},{"$f":"IFERROR(E24*E25, \"\")","v":{"v":112.5,"d":"¥112.50"}},{"v":80,"d":"¥80.00"},{"v":80,"d":"¥80.00"},{"$f":"IFERROR(SUM(D26:G26), \"\")","v":{"v":912.5,"d":"¥912.50"}}]
[]
[{"$nulls":3},"员工签名"]
[]
[{"$nulls":3},"经理签名"]