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

{"sheet":"周考勤表","index":0,"n_rows":25,"n_cols":11,"rows_kept":25,"merged":[[0,1,0,10],[2,2,2,7],[3,2,3,7],[4,2,4,7],[5,2,5,7],[6,2,6,7],[7,2,7,7],[8,2,8,7],[21,5,21,9],[23,5,23,9]]}
[null,"周考勤表"]
[null,"公司名称"]
[null,"街道地址：",{"$nulls":7},"周结束日期："]
[null,"地址 2："]
[null,"地址 3：",{"$nulls":7},"员工："]
[null,"省/市/自治区，市/县 邮政编码：",{"$nulls":7},"经理："]
[null,"电话：",{"$nulls":7},"员工电话："]
[null,"传真：",{"$nulls":7},"员工电子邮件："]
[null,"电子邮件：",{"$nulls":7},"税务 ID 号："]
[]
[null,"日期","上班","下班","上班 ","下班 ","正常工时","加班时数","病假时数","休假时数","总计"]
[null,"星期一","08:00:00","11:00:00","12:00:00","18:00:00",{"$f":"IFERROR(IF((((D12-C12)+(F12-E12))*24)>8,8,((D12-C12)+(F12-E12))*24), \"\")","v":{"v":8,"d":"8.00"}},{"$f":"IFERROR(IF(((D12-C12)+(F12-E12))*24>8,((D12-C12)+(F12-E12))*24-8,0), \"\")","v":{"v":1,"d":"1.00"}},null,null,{"$f":"IFERROR(SUM(G12:J12), \"\")","v":{"v":9,"d":"9.00"}}]
[null,"星期二",{"$nulls":4},{"$f":"IFERROR(IF((((D13-C13)+(F13-E13))*24)>8,8,((D13-C13)+(F13-E13))*24), \"\")","v":{"v":0,"d":"0.00"}},{"$f":"IFERROR(IF(((D13-C13)+(F13-E13))*24>8,((D13-C13)+(F13-E13))*24-8,0), \"\")","v":{"v":0,"d":"0.00"}},null,null,{"v":0,"d":"0.00"}]
[null,"星期三",{"$nulls":4},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"}]
[null,"星期四",{"$nulls":4},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"}]
[null,"星期五",{"$nulls":4},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"}]
[null,"星期六",{"$nulls":4},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"}]
[null,"星期日",{"$nulls":4},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"}]
[{"$nulls":5},"总工时",{"$f":"SUM(G12:G18)","v":{"v":8,"d":"8.00"}},{"$f":"SUM(H12:H18)","v":{"v":1,"d":"1.00"}},{"$f":"SUM(I12:I18)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(J12:J18)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(考勤表[总计])","v":{"v":9,"d":"9.00"}}]
[{"$nulls":5},"每小时工资率",{"v":200,"d":"¥200.00"},{"v":300,"d":"¥300.00"}]
[{"$nulls":5},"工资总额",{"$f":"G19*G20","v":{"v":1600,"d":"¥1,600.00"}},{"$f":"H19*H20","v":{"v":300,"d":"¥300.00"}},{"$f":"I19*I20","v":{"v":0,"d":"¥0.00"}},{"$f":"J19*J20","v":{"v":0,"d":"¥0.00"}},{"$f":"SUM(G21:J21)","v":{"v":1900,"d":"¥1,900.00"}}]
[]
[{"$nulls":5},"员工签名",{"$nulls":4},"日期"]
[]
[{"$nulls":5},"经理签名",{"$nulls":4},"日期"]