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

{"sheet":"每周时间记录","index":0,"n_rows":25,"n_cols":9,"rows_kept":25,"merged":[[2,1,2,6],[2,7,2,8],[3,7,3,8],[4,7,4,8],[5,3,5,4],[5,7,5,8],[6,3,6,4],[6,7,6,8],[7,3,7,4],[7,7,7,8],[21,1,21,6],[21,7,21,8],[22,1,22,6],[22,7,22,8],[23,1,23,6],[23,7,23,8],[24,1,24,6],[24,7,24,8]]}
[]
[]
[null,"每周时间记录"]
[null,"MODERN DESIGN CO."]
[]
[null,"员工:",null,"Miguel Reyes",null,null,"员工电话：","(805) 555-0123"]
[null,"经理:",null,"Jyeshta Davgar",null,null,"员工电子邮件：","miguel@example.com"]
[{"$nulls":6},"周结束日期：",{"$f":"TODAY()","v":"2023-03-24"}]
[]
[null,"天"," ","日期","正常工作时数","加班时数","病假","休假","总计"]
[null,{"$f":"IFERROR(TEXT(考勤记录[[#This Row],[日期]],\"aaaa\"), \"\")","v":"星期六"},null,{"$f":"IFERROR(IF($H$8=0,\"\",$H$8-6), \"\")","v":"2023-03-18"},{"$nulls":4},{"$f":"IFERROR(SUM(E11:H11), \"\")","v":{"v":0,"d":"0.00"}}]
[null,{"$f":"IFERROR(TEXT(考勤记录[[#This Row],[日期]],\"aaaa\"), \"\")","v":"星期日"},null,{"$f":"IFERROR(IF($H$8=0,\"\",$H$8-5), \"\")","v":"2023-03-19"},{"$nulls":4},{"$f":"IFERROR(SUM(E12:H12), \"\")","v":{"v":0,"d":"0.00"}}]
[null,{"$f":"IFERROR(TEXT(考勤记录[[#This Row],[日期]],\"aaaa\"), \"\")","v":"星期一"},null,{"$f":"IFERROR(IF($H$8=0,\"\",$H$8-4), \"\")","v":"2023-03-20"},{"$nulls":4},{"$f":"IFERROR(SUM(E13:H13), \"\")","v":{"v":0,"d":"0.00"}}]
[null,{"$f":"IFERROR(TEXT(考勤记录[[#This Row],[日期]],\"aaaa\"), \"\")","v":"星期二"},null,{"$f":"IFERROR(IF($H$8=0,\"\",$H$8-3), \"\")","v":"2023-03-21"},{"$nulls":4},{"$f":"IFERROR(SUM(E14:H14), \"\")","v":{"v":0,"d":"0.00"}}]
[null,{"$f":"IFERROR(TEXT(考勤记录[[#This Row],[日期]],\"aaaa\"), \"\")","v":"星期三"},null,{"$f":"IFERROR(IF($H$8=0,\"\",$H$8-2), \"\")","v":"2023-03-22"},{"$nulls":4},{"$f":"IFERROR(SUM(E15:H15), \"\")","v":{"v":0,"d":"0.00"}}]
[null,{"$f":"IFERROR(TEXT(考勤记录[[#This Row],[日期]],\"aaaa\"), \"\")","v":"星期四"},null,{"$f":"IFERROR(IF($H$8=0,\"\",$H$8-1), \"\")","v":"2023-03-23"},{"$nulls":4},{"$f":"IFERROR(SUM(E16:H16), \"\")","v":{"v":0,"d":"0.00"}}]
[null,{"$f":"IFERROR(TEXT(考勤记录[[#This Row],[日期]],\"aaaa\"), \"\")","v":"星期五"},null,{"$f":"IFERROR(IF($H$8=0,\"\",$H$8), \"\")","v":"2023-03-24"},{"$nulls":4},{"v":0,"d":"0.00"}]
[{"$nulls":3},"总工时",{"$f":"IFERROR(SUM(考勤记录[正常工作时数]), \"\")","v":{"v":0,"d":"0.00"}},{"$f":"IFERROR(SUM(考勤记录[加班时数]), \"\")","v":{"v":0,"d":"0.00"}},{"$f":"IFERROR(SUM(考勤记录[病假]), \"\")","v":{"v":0,"d":"0.00"}},{"$f":"IFERROR(SUM(考勤记录[休假]), \"\")","v":{"v":0,"d":"0.00"}},{"$f":"IFERROR(SUM(考勤记录[总计]), \"\")","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"时薪"]
[{"$nulls":3},"工资总额",{"$f":"IFERROR(E18*E19, \"\")","v":{"v":0,"d":"¥0.00"}},{"$f":"IFERROR(F18*F19, \"\")","v":{"v":0,"d":"¥0.00"}},{"v":0,"d":"¥0.00"},{"v":0,"d":"¥0.00"},{"v":0,"d":"¥0.00"}]
[]
[]
[null,"员工签名",{"$nulls":5},"日期"]
[]
[null,"经理签名",{"$nulls":5},"日期"]