{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["TimeCard","TBL_TIMECARD","TemplAttendance","EmploymentRule"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":8,"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":"TimeCard","index":0,"n_rows":2,"n_cols":2,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
[]
[null,"勤務表出力サンプル"]

{"sheet":"TBL_TIMECARD","index":1,"n_rows":71,"n_cols":6,"rows_kept":71,"cut":false,"hidden":false,"merged":[]}
["社員ID","名前","日付","出勤時刻","退勤時刻","備考"]
["S0000","片山 七菜","2022-10-03","08:55:15.190","17:30:00","正社員"]
["S0001","鷹野 鈴","2022-10-03","08:51:10.931","19:35:00","正社員"]
["S0002","森元 智也","2022-10-03","08:43:10.690","17:32:00","正社員"]
["P0000","松田 佐和","2022-10-04","08:56:51.344","14:01:00","パートさん"]
["S0000","片山 七菜","2022-10-04","08:57:50.032","18:40:00"]
["S0001","鷹野 鈴","2022-10-04","08:37:16.001","18:50:00"]
["S0002","森元 智也","2022-10-04","08:43:43.289","19:25:00"]
["S0000","片山 七菜","2022-10-05","08:21:31.711","19:45:00"]
["S0001","鷹野 鈴","2022-10-05","08:47:02.534","20:08:00"]
["S0002","森元 智也","2022-10-05","08:46:52.513","17:03:00","歯医者の為、早退"]
["P0000","松田 佐和","2022-10-05","12:45:00","17:35:00"]
["S0000","片山 七菜","2022-10-06","12:30:00","17:32:00","私用により、遅刻"]
["S0001","鷹野 鈴","2022-10-06","08:52:38.529","17:35:00"]
["S0002","森元 智也","2022-10-06","09:42:00","20:11:00"]
["S0000","片山 七菜","2022-10-07","08:31:52.055","18:55:00"]
["S0001","鷹野 鈴","2022-10-07","08:58:54.837","19:20:00"]
["S0002","森元 智也","2022-10-07","08:25:29.214","18:04:00"]
["S0000","片山 七菜","2022-10-10","08:32:48.994","18:35:00"]
["S0001","鷹野 鈴","2022-10-10","08:46:33.525","21:39:00"]
["S0002","森元 智也","2022-10-10","08:53:13.938","19:33:00"]
["S0000","片山 七菜","2022-10-11","08:20:52.272","19:21:00"]
["S0001","鷹野 鈴","2022-10-11","08:53:41.422","19:28:00"]
["S0002","森元 智也","2022-10-11","08:36:02.374","19:37:00"]
["P0000","松田 佐和","2022-10-11","08:57:00.773","12:20:00"]
["S0000","片山 七菜","2022-10-12","08:29:31.074","17:53:00"]
["S0001","鷹野 鈴","2022-10-12","10:15:00","18:32:00","通院で遅刻"]
["S0002","森元 智也","2022-10-12","08:36:50.774","17:33:00"]
["P0000","松田 佐和","2022-10-12","12:45:00","17:35:00"]
["S0000","片山 七菜","2022-10-13","08:48:22.346","19:29:00"]
["S0001","鷹野 鈴","2022-10-13","08:21:40.783","18:03:00"]
["S0002","森元 智也","2022-10-13","08:57:44.922","21:18:00"]
["S0000","片山 七菜","2022-10-14","08:38:25.257","19:24:00"]
["S0001","鷹野 鈴","2022-10-14","08:27:45.204","19:32:00"]
["S0002","森元 智也","2022-10-14","08:54:51.758","18:06:00"]
["S0000","片山 七菜","2022-10-17","08:58:17.413","19:11:00"]
["S0001","鷹野 鈴","2022-10-17","08:42:56.744","23:41:00"]
["S0002","森元 智也","2022-10-17","08:40:23.814","18:20:00"]
["S0000","片山 七菜","2022-10-18","08:40:25.411","20:16:00"]
["S0001","鷹野 鈴","2022-10-18","08:45:14.206","19:40:00"]
["S0002","森元 智也","2022-10-18","08:45:20.291","19:21:00"]
["P0000","松田 佐和","2022-10-18","08:59:14.401","12:03:00"]
["S0000","片山 七菜","2022-10-19","08:30:09.150","19:29:00"]
["S0001","鷹野 鈴","2022-10-19","08:20:07.993","18:18:00"]
["S0002","森元 智也","2022-10-19","08:22:14.890","21:00:00"]
["P0000","松田 佐和","2022-10-19","12:55:00","17:33:00"]
["S0000","片山 七菜","2022-10-20","08:29:57.684","18:05:00"]
["S0001","鷹野 鈴","2022-10-20","08:36:22.818","17:53:00"]
["S0002","森元 智也","2022-10-20","08:26:29.506","19:00:00"]
["S0000","片山 七菜","2022-10-21","08:20:30.215","21:22:00"]
["S0001","鷹野 鈴","2022-10-21","08:55:19.221","18:28:00"]
["S0002","森元 智也","2022-10-21","08:56:23.852","19:29:00"]
["S0000","片山 七菜","2022-10-24","08:38:38.810","18:34:00"]
["S0001","鷹野 鈴","2022-10-24","08:44:43.348","18:42:00"]
["S0002","森元 智也","2022-10-24","08:57:06.597","19:44:00"]
["S0000","片山 七菜","2022-10-25","08:39:59.830","19:32:00"]
["S0001","鷹野 鈴","2022-10-25","08:30:54.423","17:30:00"]
["S0002","森元 智也","2022-10-25","08:45:00","17:50:00"]
["P0000","松田 佐和","2022-10-25","09:01:00","12:04:00"]
["S0000","片山 七菜","2022-10-26","08:45:00","17:36:00"]
["S0001","鷹野 鈴","2022-10-26","08:40:18.977","17:54:00"]
["S0002","森元 智也","2022-10-26","08:54:27.619","18:29:00"]
["P0000","松田 佐和","2022-10-26","12:50:00","17:30:00"]
["S0000","片山 七菜","2022-10-27","08:20:50.136","19:23:00"]
["S0001","鷹野 鈴","2022-10-27","08:40:18.977","19:45:00"]
["S0002","森元 智也","2022-10-27","08:40:33.891","19:28:00"]
["S0000","片山 七菜","2022-10-28","08:54:50.018","20:03:00"]
["S0001","鷹野 鈴","2022-10-28","08:48:18.450","18:05:00"]
["S0002","森元 智也","2022-10-28","08:49:34.285","18:10:00"]
["S0001","鷹野 鈴","2022-11-02","08:48:18.450","18:02:00"]
["S0002","森元 智也","2022-11-10","07:45:00","17:34:00"]

{"sheet":"TemplAttendance","index":2,"n_rows":26,"n_cols":42,"rows_kept":26,"cut":false,"hidden":false,"merged":[[20,19,20,21],[20,22,20,24],[20,25,20,27],[20,28,20,30],[20,31,20,33],[25,2,25,33],[26,2,28,33],[22,19,22,21],[22,22,22,24],[22,25,22,27],[22,28,22,30],[22,31,22,33],[21,19,21,21],[21,22,21,24],[21,25,21,27],[21,28,21,30],[21,31,21,33],[23,2,23,4],[23,5,23,7],[23,8,23,10],[23,11,23,13],[23,14,23,16],[22,2,22,4],[22,5,22,7],[19,19,19,21],[19,22,19,24],[19,25,19,27],[19,28,19,30],[19,31,19,33],[18,19,18,21],[18,22,18,24],[18,25,18,27],[18,28,18,30],[18,31,18,33],[17,19,17,21],[17,22,17,24],[17,25,17,27],[17,28,17,30],[17,31,17,33],[16,19,16,21],[16,22,16,24],[16,25,16,27],[16,28,16,30],[16,31,16,33],[15,19,15,21],[15,22,15,24],[15,25,15,27],[15,28,15,30],[15,31,15,33],[14,19,14,21],[14,22,14,24],[14,25,14,27],[14,28,14,30],[14,31,14,33],[13,19,13,21],[13,22,13,24],[13,25,13,27],[13,28,13,30],[13,31,13,33],[12,19,12,21],[12,22,12,24],[12,25,12,27],[12,28,12,30],[12,31,12,33],[11,19,11,21],[11,22,11,24],[11,25,11,27],[11,28,11,30],[11,31,11,33],[10,19,10,21],[10,22,10,24],[10,25,10,27],[10,28,10,30],[10,31,10,33],[22,8,22,10],[22,11,22,13],[22,14,22,16],[21,2,21,4],[21,5,21,7],[21,8,21,10],[21,11,21,13],[21,14,21,16],[20,2,20,4],[20,5,20,7],[20,8,20,10],[20,11,20,13],[20,14,20,16],[19,2,19,4],[19,5,19,7],[19,8,19,10],[19,11,19,13],[19,14,19,16],[18,2,18,4],[18,5,18,7],[18,8,18,10],[18,11,18,13],[18,14,18,16],[17,2,17,4],[17,5,17,7],[17,8,17,10],[17,11,17,13],[17,14,17,16],[16,2,16,4],[16,5,16,7],[16,8,16,10],[16,11,16,13],[16,14,16,16],[15,2,15,4],[15,5,15,7],[15,8,15,10],[15,11,15,13],[15,14,15,16],[14,2,14,4],[14,5,14,7],[14,8,14,10],[14,11,14,13],[14,14,14,16],[13,2,13,4],[13,5,13,7],[13,8,13,10],[13,11,13,13],[13,14,13,16],[12,2,12,4],[12,5,12,7],[12,8,12,10],[12,11,12,13],[12,14,12,16],[11,2,11,4],[11,5,11,7],[11,8,11,10],[11,11,11,13],[11,14,11,16],[7,31,7,33],[8,2,8,4],[8,5,8,7],[8,8,8,10],[8,11,8,13],[8,14,8,16],[9,2,9,4],[9,5,9,7],[9,8,9,10],[9,11,9,13],[9,14,9,16],[10,2,10,4],[10,5,10,7],[10,8,10,10],[7,14,7,16],[7,2,7,4],[7,5,7,7],[8,31,8,33],[9,19,9,21],[7,8,7,10],[7,11,7,13],[1,24,1,26],[2,24,2,26],[1,27,1,34],[2,27,2,34],[3,24,4,26],[3,27,4,34],[10,11,10,13],[10,14,10,16],[9,22,9,24],[9,25,9,27],[9,28,9,30],[9,31,9,33],[7,19,7,21],[7,22,7,24],[7,25,7,27],[7,28,7,30],[8,19,8,21],[8,22,8,24],[8,25,8,27],[8,28,8,30],[3,15,4,20],[1,15,2,20]]}
["え"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"会社名 : "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"所属 : ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"・シートに保護を掛けています。"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"勤務表",null,null,null,null,null,null,null,null,"氏名 : ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"・このシートを非表示設定にして、ユーザに不用意に変更させないようにしてもOKではないでしょうか。"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"・土日の色づけは、条件付き書式を設定しています。プログラムではありません。"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"・日付には数式を設定してあり、1日の箇所に日付を設定すると自動で表示されます。"]
[]
[null,null,"日付",null,null,"開始",null,null,"終了",null,null,"勤務時間",null,null,"備考",null,null,null,null,"日付",null,null,"開始",null,null,"終了",null,null,"勤務時間",null,null,"備考"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(DAY_TOP=\"\",\"\",C24+1)","v":""}]
[null,null,{"$f":"IF(DAY_TOP=\"\",\"\",C9+1)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(DAY_TOP=\"\",\"\",T9+1)","v":""}]
[null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,""]
[]
[null,null,"特記事項 : "]

{"sheet":"EmploymentRule","index":3,"n_rows":6,"n_cols":5,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["項目","値","備考",null,"・このシートを非表示設定にして、ユーザに不用意に変更させないようにしてもOKではないでしょうか。"]
["定時開始","09:00:00"]
["定時終了","17:30:00"]
["休憩開始","12:00:00"]
["休憩終了","13:00:00"]
["繰上(下)げ分単位",15,"時間の端数の繰上げ繰り下げ Ex. 出勤 8:32 → 8:45、 退勤 17:43 → 17:30"]