{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["雙週工時表"],"not_rendered":{"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"雙週工時表","index":0,"n_rows":35,"n_cols":7,"rows_kept":35,"merged":[[0,0,0,6],[1,0,1,4],[6,0,6,1],[6,2,6,3],[6,5,6,6],[7,0,7,1],[7,2,7,3],[7,4,7,5],[8,0,8,1],[8,2,8,3],[8,4,8,5],[33,0,33,1],[34,0,34,1]]}
["公司名稱"]
["[街道地址] [地址 2] [縣市、州省，郵遞區號]",{"$nulls":5},"每週工時表 (含休息時段)"]
[]
[]
[]
[]
["員工:",{"$nulls":3},"員工電話:"]
["員工電子郵件:",{"$nulls":3},"付款期間自:",null,"2006-01-01"]
["主管:",{"$nulls":3},"至:",null,{"$f":"IF($G$8=\"\",\"\",$G$8+13)","v":"2006-01-14"}]
[]
[]
["天","日期","工作時數","加班時數","病假","休假","合計"]
["星期一",{"$f":"G8","v":"2006-01-01"},{"v":8,"d":"8.00"},{"$nulls":3},{"$f":"IF(SUM(C13:F13)>24,\"您輸入的時數超過 24 小時。\",SUM(C13:F13))","v":{"v":8,"d":"8.00"}}]
["星期二",{"$f":"IF($G$8=\"\",\"\",$G$8+1)","v":"2006-01-02"},{"v":8,"d":"8.00"},{"v":2,"d":"2.00"},null,null,{"v":10,"d":"10.00"}]
["星期三",{"$f":"IF($G$8=\"\",\"\",$G$8+2)","v":"2006-01-03"},null,null,{"v":8,"d":"8.00"},null,{"v":8,"d":"8.00"}]
["星期四",{"$f":"IF($G$8=\"\",\"\",$G$8+3)","v":"2006-01-04"},{"$nulls":3},{"v":8,"d":"8.00"},{"v":8,"d":"8.00"}]
["星期五",{"$f":"IF($G$8=\"\",\"\",$G$8+4)","v":"2006-01-05"},{"$nulls":4},{"v":0,"d":"0.00"}]
["星期六",{"$f":"IF($G$8=\"\",\"\",$G$8+5)","v":"2006-01-06"},{"$nulls":4},{"v":0,"d":"0.00"}]
["星期日",{"$f":"IF($G$8=\"\",\"\",$G$8+6)","v":"2006-01-07"},{"$nulls":4},{"v":0,"d":"0.00"}]
["星期一",{"$f":"IF($G$8=\"\",\"\",$G$8+7)","v":"2006-01-08"},{"$nulls":4},{"v":0,"d":"0.00"}]
["星期二",{"$f":"IF($G$8=\"\",\"\",$G$8+8)","v":"2006-01-09"},{"$nulls":4},{"v":0,"d":"0.00"}]
["星期三",{"$f":"IF($G$8=\"\",\"\",$G$8+9)","v":"2006-01-10"},{"$nulls":4},{"v":0,"d":"0.00"}]
["星期四",{"$f":"IF($G$8=\"\",\"\",$G$8+10)","v":"2006-01-11"},{"$nulls":4},{"v":0,"d":"0.00"}]
["星期五",{"$f":"IF($G$8=\"\",\"\",$G$8+11)","v":"2006-01-12"},{"$nulls":4},{"v":0,"d":"0.00"}]
["星期六",{"$f":"IF($G$8=\"\",\"\",$G$8+12)","v":"2006-01-13"},{"$nulls":4},{"v":0,"d":"0.00"}]
["星期日",{"$f":"IF($G$8=\"\",\"\",$G$8+13)","v":"2006-01-14"},{"$nulls":4},{"v":0,"d":"0.00"}]
[null,"合計",{"$f":"SUBTOTAL(109,表格1[工作時數])","v":{"v":16,"d":"16.00"}},{"$f":"SUBTOTAL(109,表格1[加班時數])","v":{"v":2,"d":"2.00"}},{"$f":"SUBTOTAL(109,表格1[病假])","v":{"v":8,"d":"8.00"}},{"$f":"SUBTOTAL(109,表格1[休假])","v":{"v":8,"d":"8.00"}},{"$f":"SUBTOTAL(109,表格1[合計])","v":{"v":34,"d":"34.00"}}]
[null,"時薪",{"v":100,"d":"100.00"},{"v":150,"d":"150.00"},{"v":100,"d":"100.00"},{"v":100,"d":"100.00"}]
[null,"總付款金額",{"$f":"SUM(C28*表格1[[#Totals],[工作時數]])","v":{"v":1600,"d":"$1,600.00"}},{"$f":"SUM(D28*表格1[[#Totals],[加班時數]])","v":{"v":300,"d":"$300.00"}},{"$f":"SUM(E28*表格1[[#Totals],[病假]])","v":{"v":800,"d":"$800.00"}},{"$f":"SUM(F28*表格1[[#Totals],[休假]])","v":{"v":800,"d":"$800.00"}},{"$f":"SUM(C29:F29)","v":{"v":3500,"d":"$3,500.00"}}]
[]
[]
[]
[]
["員工簽名",{"$nulls":4},"日期"]
["主管簽名",{"$nulls":4},"日期"]