{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["原資料嵌入整理","打卡原檔"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"原資料嵌入整理","index":0,"n_rows":23,"n_cols":11,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
["序號","員工編號","姓名","職務","日期","上班","下班","時數","工作時數",{"$f":"SUM(H:H)","v":158.19999999999999},"時薪調整"]
["1","A010","吳XX","客服部","2021-03-02","09:16:17","18:36:11",{"$f":"IFERROR(IF(F2>0,IF(INT((G2-F2)*1440)>0,INT((G2-F2)*1440)/60,INT(((G2-F2)*1440)+1440)/60),\"\")-1,\"資料錯誤\")","v":8.3166666666666664},"時薪",160]
["2","A010","吳XX","客服部","2021-03-03","09:16:15","18:36:14",{"$f":"IFERROR(IF(F3>0,IF(INT((G3-F3)*1440)>0,INT((G3-F3)*1440)/60,INT(((G3-F3)*1440)+1440)/60),\"\")-1,\"資料錯誤\")","v":8.3166666666666664},"薪資",{"$f":"J1*J2","v":25312}]
["3","A010","吳XX","客服部","2021-03-04","09:16:21","18:45:17",{"$f":"IFERROR(IF(F4>0,IF(INT((G4-F4)*1440)>0,INT((G4-F4)*1440)/60,INT(((G4-F4)*1440)+1440)/60),\"\")-1,\"資料錯誤\")","v":8.4666666666666668}]
["4","A010","吳XX","客服部","2021-03-05","09:16:32","18:36:19",8.3166666666666664]
["5","A010","吳XX","客服部","2021-03-08",null,"18:36:29","資料錯誤"]
["6","A010","吳XX","客服部","2021-03-09","09:16:38","18:36:29",8.3166666666666664]
["7","A010","吳XX","客服部","2021-03-10","09:25:39","18:36:11",8.1666666666666661]
["8","A010","吳XX","客服部","2021-03-11","09:16:13","18:36:19",8.3333333333333339]
["9","A010","吳XX","客服部","2021-03-12","09:16:22","18:36:12",8.3166666666666664]
["10","A010","吳XX","客服部","2021-03-15","09:16:42","18:36:12",8.3166666666666664]
["11","A010","吳XX","客服部","2021-03-16","09:16:15","18:36:17",8.3333333333333339]
["12","A010","吳XX","客服部","2021-03-17","09:16:20","18:36:12",8.3166666666666664]
["13","A010","吳XX","客服部","2021-03-18","09:16:17","18:42:01",8.4166666666666661]
["14","A010","吳XX","客服部","2021-03-19","09:16:14","18:36:16",8.3333333333333339]
["15","A010","吳XX","客服部","2021-03-22",null,"18:38:35","資料錯誤"]
["16","A010","吳XX","客服部","2021-03-23","09:16:20","18:36:17",8.3166666666666664]
["17","A010","吳XX","客服部","2021-03-24",null,"18:38:52","資料錯誤"]
["18","A010","吳XX","客服部","2021-03-25","09:16:25","18:36:22",8.3166666666666664]
["19","A010","吳XX","客服部","2021-03-26","09:16:13","18:36:44",8.3333333333333339]
["20","A010","吳XX","客服部","2021-03-29","09:16:11","18:36:13",8.3333333333333339]
["21","A010","吳XX","客服部","2021-03-30","09:16:13","18:36:12",8.3166666666666664]
["22","A010","吳XX","客服部","2021-03-31","09:16:28","18:36:10",8.3166666666666664]

{"sheet":"打卡原檔","index":1,"n_rows":50,"n_cols":10,"rows_kept":50,"cut":false,"hidden":false,"merged":[[0,0,0,10],[1,0,1,10],[2,0,2,10],[3,0,3,10],[4,0,4,10]]}
["資料類型：打卡資料"]
["匯出日期：2021/07/26"]
["匯出資料條件：起訖時間：2021/03/01～2021/03/31"]
["資料筆數：22 筆"]
[""]
["#","員工編號","姓名","部門","上下班卡時間","打卡地址","狀態","異常","來源","備註"]
["1","A010","吳XX","客服部","2021/03/02 09:16:17","2.983,120.1","正常","","GPS打卡"]
["","A010","吳XX","客服部","2021/03/02 18:36:11","2.983,120.1","正常","","GPS打卡"]
["2","A010","吳XX","客服部","2021/03/03 09:16:15","2.983,120.1","正常","","GPS打卡"]
["","A010","吳XX","客服部","2021/03/03 18:36:14","2.983,120.1","正常","","GPS打卡"]
["3","A010","吳XX","客服部","2021/03/04 09:16:21","2.983,120.1","正常","","GPS打卡"]
["","A010","吳XX","客服部","2021/03/04 18:45:17","2.983,120.1","正常","","GPS打卡"]
["4","A010","吳XX","客服部","2021/03/05 09:16:32","2.983,120.1","正常","","GPS打卡"]
["","A010","吳XX","客服部","2021/03/05 18:36:19","2.983,120.1","正常","","GPS打卡"]
["5","A010","吳XX","客服部","2021/03/08","","異常","未打卡","",""]
["","A010","吳XX","客服部","2021/03/08 18:36:29","2.983,120.1","異常","早退","GPS打卡"]
["6","A010","吳XX","客服部","2021/03/09 09:16:38","2.983,120.2","正常","","GPS打卡"]
["","A010","吳XX","客服部","2021/03/09 18:36:29","2.983,120.3","正常","","GPS打卡"]
["7","A010","吳XX","客服部","2021/03/10 09:25:39","2.983,120.4","正常","","GPS打卡"]
["","A010","吳XX","客服部","2021/03/10 18:36:11","2.983,120.5","正常","","GPS打卡"]
["8","A010","吳XX","客服部","2021/03/11 09:16:13","2.983,120.6","正常","","GPS打卡"]
["","A010","吳XX","客服部","2021/03/11 18:36:19","2.983,120.7","正常","","GPS打卡"]
["9","A010","吳XX","客服部","2021/03/12 09:16:22","2.983,120.8","正常","","GPS打卡"]
["","A010","吳XX","客服部","2021/03/12 18:36:12","2.983,120.9","正常","","GPS打卡"]
["10","A010","吳XX","客服部","2021/03/15 09:16:42","2.983,120.10","正常","","GPS打卡"]
["","A010","吳XX","客服部","2021/03/15 18:36:12","2.983,120.11","正常","","GPS打卡"]
["11","A010","吳XX","客服部","2021/03/16 09:16:15","2.983,120.12","正常","","GPS打卡"]
["","A010","吳XX","客服部","2021/03/16 18:36:17","2.983,120.13","正常","","GPS打卡"]
["12","A010","吳XX","客服部","2021/03/17 09:16:20","2.983,120.14","正常","","GPS打卡"]
["","A010","吳XX","客服部","2021/03/17 18:36:12","2.983,120.15","正常","","GPS打卡"]
["13","A010","吳XX","客服部","2021/03/18 09:16:17","2.983,120.16","正常","","GPS打卡"]
["","A010","吳XX","客服部","2021/03/18 18:42:01","2.983,120.17","正常","","GPS打卡"]
["14","A010","吳XX","客服部","2021/03/19 09:16:14","2.983,120.18","正常","","GPS打卡"]
["","A010","吳XX","客服部","2021/03/19 18:36:16","2.983,120.19","正常","","GPS打卡"]
["15","A010","吳XX","客服部","2021/03/22","","異常","未打卡","",""]
["","A010","吳XX","客服部","2021/03/22 18:38:35","2.983,120.19","異常","早退","GPS打卡"]
["16","A010","吳XX","客服部","2021/03/23 09:16:20","2.983,120.20","正常","","GPS打卡"]
["","A010","吳XX","客服部","2021/03/23 18:36:17","2.983,120.21","正常","","GPS打卡"]
["17","A010","吳XX","客服部","2021/03/24","","異常","未打卡","",""]
["","A010","吳XX","客服部","2021/03/24 18:38:52","2.983,120.21","異常","早退","GPS打卡"]
["18","A010","吳XX","客服部","2021/03/25 09:16:25","2.983,120.22","正常","","GPS打卡"]
["","A010","吳XX","客服部","2021/03/25 18:36:22","2.983,120.23","正常","","GPS打卡"]
["19","A010","吳XX","客服部","2021/03/26 09:16:13","2.983,120.24","正常","","GPS打卡"]
["","A010","吳XX","客服部","2021/03/26 18:36:44","2.983,120.25","正常","","GPS打卡",""]
["20","A010","吳XX","客服部","2021/03/29 09:16:11","2.983,120.26","正常","","GPS打卡",""]
["","A010","吳XX","客服部","2021/03/29 18:36:13","2.983,120.27","正常","","GPS打卡",""]
["21","A010","吳XX","客服部","2021/03/30 09:16:13","2.983,120.28","正常","","GPS打卡",""]
["","A010","吳XX","客服部","2021/03/30 18:36:12","2.983,120.29","正常","","GPS打卡",""]
["22","A010","吳XX","客服部","2021/03/31 09:16:28","2.983,120.30","正常","","GPS打卡",""]
["","A010","吳XX","客服部","2021/03/31 18:36:10","2.983,120.31","正常","","GPS打卡",""]