{"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},"統一編號："]
[]
[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":600,"d":"NT$600.00"},{"v":900,"d":"NT$900.00"}]
[{"$nulls":5},"總薪資",{"$f":"G19*G20","v":{"v":4800,"d":"NT$4,800.00"}},{"$f":"H19*H20","v":{"v":900,"d":"NT$900.00"}},{"$f":"I19*I20","v":{"v":0,"d":"NT$0.00"}},{"$f":"J19*J20","v":{"v":0,"d":"NT$0.00"}},{"$f":"SUM(G21:J21)","v":{"v":5700,"d":"NT$5,700.00"}}]
[]
[{"$nulls":5},"員工簽名",{"$nulls":4},"日期"]
[]
[{"$nulls":5},"經理簽名",{"$nulls":4},"日期"]