{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["周时数记录"],"not_rendered":{"defined_names":7},"read":"whole","date_system":"1900"}

{"sheet":"周时数记录","index":0,"n_rows":21,"n_cols":8,"rows_kept":21,"merged":[[0,1,0,7],[2,2,2,3],[2,6,2,7],[3,2,3,3],[3,6,3,7],[4,2,4,3],[17,3,17,6],[18,3,18,6],[19,3,19,6],[20,3,20,6]]}
[null,"周时数记录"]
[null,"公司名称"]
[null,"员工：",{"$nulls":3},"员工电话："]
[null,"经理：",{"$nulls":3},"员工电子邮件："]
[null,"周结束日期",{"$f":"TODAY()","v":"2017-09-12"}]
[]
[null,"日期","日期2","正常工作时数","加班时数","病假","休假","总计"]
[null,{"$f":"IFERROR(TEXT(考勤表[[#This Row],[日期2]],\"aaaa\"), \"\")","v":"星期三"},{"$f":"IFERROR(IF($C$5=0,\"\",$C$5-6), \"\")","v":"2017-09-06"},{"$nulls":4},{"$f":"IFERROR(SUM(D8:G8), \"\")","v":{"v":0,"d":"0.00"}}]
[null,{"$f":"IFERROR(TEXT(考勤表[[#This Row],[日期2]],\"aaaa\"), \"\")","v":"星期四"},{"$f":"IFERROR(IF($C$5=0,\"\",$C$5-5), \"\")","v":"2017-09-07"},{"$nulls":4},{"$f":"IFERROR(SUM(D9:G9), \"\")","v":{"v":0,"d":"0.00"}}]
[null,{"$f":"IFERROR(TEXT(考勤表[[#This Row],[日期2]],\"aaaa\"), \"\")","v":"星期五"},{"$f":"IFERROR(IF($C$5=0,\"\",$C$5-4), \"\")","v":"2017-09-08"},{"$nulls":4},{"$f":"IFERROR(SUM(D10:G10), \"\")","v":{"v":0,"d":"0.00"}}]
[null,{"$f":"IFERROR(TEXT(考勤表[[#This Row],[日期2]],\"aaaa\"), \"\")","v":"星期六"},{"$f":"IFERROR(IF($C$5=0,\"\",$C$5-3), \"\")","v":"2017-09-09"},{"$nulls":4},{"$f":"IFERROR(SUM(D11:G11), \"\")","v":{"v":0,"d":"0.00"}}]
[null,{"$f":"IFERROR(TEXT(考勤表[[#This Row],[日期2]],\"aaaa\"), \"\")","v":"星期日"},{"$f":"IFERROR(IF($C$5=0,\"\",$C$5-2), \"\")","v":"2017-09-10"},{"$nulls":4},{"$f":"IFERROR(SUM(D12:G12), \"\")","v":{"v":0,"d":"0.00"}}]
[null,{"$f":"IFERROR(TEXT(考勤表[[#This Row],[日期2]],\"aaaa\"), \"\")","v":"星期一"},{"$f":"IFERROR(IF($C$5=0,\"\",$C$5-1), \"\")","v":"2017-09-11"},{"$nulls":4},{"$f":"IFERROR(SUM(D13:G13), \"\")","v":{"v":0,"d":"0.00"}}]
[null,{"$f":"IFERROR(TEXT(考勤表[[#This Row],[日期2]],\"aaaa\"), \"\")","v":"星期二"},{"$f":"IFERROR(IF($C$5=0,\"\",$C$5), \"\")","v":"2017-09-12"},{"$nulls":4},{"v":0,"d":"0.00"}]
[null,null,"总工时",{"$f":"IFERROR(SUM(D8:D14), \"\")","v":{"v":0,"d":"0.00"}},{"$f":"IFERROR(SUM(E8:E14), \"\")","v":{"v":0,"d":"0.00"}},{"$f":"IFERROR(SUM(F8:F14), \"\")","v":{"v":0,"d":"0.00"}},{"$f":"IFERROR(SUM(G8:G14), \"\")","v":{"v":0,"d":"0.00"}},{"$f":"IFERROR(SUM(H8:H14), \"\")","v":{"v":0,"d":"0.00"}}]
[null,null,"计时工资"]
[null,null,"工资总额",{"$f":"IFERROR(D15*D16, \"\")","v":{"v":0,"d":"¥0"}},{"$f":"IFERROR(E15*E16, \"\")","v":{"v":0,"d":"¥0"}},{"$f":"IFERROR(F15*F16, \"\")","v":{"v":0,"d":"¥0"}},{"$f":"IFERROR(G15*G16, \"\")","v":{"v":0,"d":"¥0"}},{"$f":"IFERROR(SUM(D17:G17), \"\")","v":{"v":0,"d":"¥0"}}]
[]
[{"$nulls":3},"员工签名",{"$nulls":3},"日期"]
[]
[{"$nulls":3},"经理签名",{"$nulls":3},"日期"]