{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["基本シート","利用方法"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":9,"comments":1,"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":39,"n_cols":8,"rows_kept":39,"cut":false,"hidden":false,"merged":[[2,2,2,3],[4,2,4,3],[4,0,4,1],[2,0,2,1],[0,0,0,2],[0,3,0,4]]}
["〇年〇月",null,null,"勤怠管理表"]
[]
["給与計算対象期間初日",null,"2017-03-31"]
[]
["1日の所定労働時間数",null,"08:00:00"]
[]
["年月日","曜日","出勤時間","退勤時間","休憩時間","労働時間数","残業時間数","遅早時間数"]
[{"$f":"C3","v":"2017-03-31"},{"$f":"TEXT(A8,\"aaa\")","v":"木"},null,null,null,{"$f":"D8-C8-E8","v":0},{"$f":"MAX(D8-C8-E8-$C$5,0)","v":0},{"$f":"IF(OR(C8=\"\",D8=\"\",所定労働時間-F8<0,所定労働時間=F8),\"\",IF(F8<=所定労働時間,所定労働時間-F8))","v":""}]
[{"$f":"A8+1","v":"2017-04-01"},{"$f":"TEXT(A9,\"aaa\")","v":"金"},null,null,null,{"$f":"D9-C9-E9","v":0},{"$f":"MAX(D9-C9-E9-$C$5,0)","v":0},{"$f":"IF(OR(C9=\"\",D9=\"\",所定労働時間-F9<0,所定労働時間=F9),\"\",IF(F9<=所定労働時間,所定労働時間-F9))","v":""}]
[{"$f":"A9+1","v":"2017-04-02"},"土",null,null,null,{"$f":"D10-C10-E10","v":0},{"$f":"MAX(D10-C10-E10-$C$5,0)","v":0},""]
["2017-04-03","日",null,null,null,{"$f":"D11-C11-E11","v":0},{"$f":"MAX(D11-C11-E11-$C$5,0)","v":0},""]
["2017-04-04","月",null,null,null,0,0,""]
["2017-04-05","火",null,null,null,0,0,""]
["2017-04-06","水",null,null,null,0,0,""]
["2017-04-07","木",null,null,null,0,0,""]
["2017-04-08","金",null,null,null,0,0,""]
["2017-04-09","土",null,null,null,0,0,""]
[{"$f":"A17+1","v":"2017-04-10"},"日",null,null,null,0,0,""]
[{"$f":"A18+1","v":"2017-04-11"},"月",null,null,null,0,null,""]
["2017-04-12","火",null,null,null,0,0,""]
["2017-04-13","水",null,null,null,0,0,""]
["2017-04-14","木",null,null,null,0,0,""]
["2017-04-15","金",null,null,null,0,0,""]
["2017-04-16","土",null,null,null,0,0,""]
["2017-04-17","日",null,null,null,0,0,""]
["2017-04-18","月",null,null,null,0,0,""]
["2017-04-19","火",null,null,null,0,0,""]
["2017-04-20","水",null,null,null,0,0,""]
["2017-04-21","木",null,null,null,0,0,""]
["2017-04-22","金",null,null,null,0,0,""]
["2017-04-23","土",null,null,null,0,0,""]
[{"$f":"A31+1","v":"2017-04-24"},"日",null,null,null,0,0,""]
["2017-04-25","月",null,null,null,0,0,""]
[{"$f":"A33+1","v":"2017-04-26"},"火",null,null,null,0,0,""]
[{"$f":"A34+1","v":"2017-04-27"},"水",null,null,null,0,0,""]
[{"$f":"IF(DAY(A35+1)<10,\"\",A35+1)","v":"2017-04-28"},"木",null,null,null,0,0,""]
[{"$f":"IF(DAY(A36+1)<10,\"\",A36+1)","v":"2017-04-29"},"金",null,null,null,0,0,""]
[{"$f":"IF(DAY(A37+1)<10,\"\",A37+1)","v":""},{"$f":"TEXT(A38,\"aaa\")","v":""},null,null,null,{"$f":"D38-C38-E38","v":0},0,""]
[null,null,null,null,"合計",{"$f":"SUM(F8:F38)","v":0},{"$f":"SUM(G8:G38)","v":0},{"$f":"SUM(H8:H38)","v":0}]

{"sheet":"利用方法","index":1,"n_rows":39,"n_cols":8,"rows_kept":39,"cut":false,"hidden":false,"merged":[[0,0,0,7],[2,0,2,1],[2,2,2,3],[4,0,4,1],[4,2,4,3]]}
["〇年〇月　出勤簿（入力例）"]
[]
["給与計算対象期間初日",null,"2017-03-31"]
[]
["1日の所定労働時間数",null,"08:00:00"]
[]
["年月日","曜日","出勤時間","退勤時間","休憩時間","労働時間数","残業時間数","遅早時間数"]
[{"$f":"C3","v":"2017-03-31"},{"$f":"TEXT(A8,\"aaa\")","v":"木"},"08:00:00","17:00:00","01:00:00",{"$f":"D8-C8-E8","v":0.33333333333333337},{"$f":"MAX(D8-C8-E8-$C$5,0)","v":5.5511151231257827E-17},{"$f":"IF(OR(C8=\"\",D8=\"\",所定労働時間-F8<0,所定労働時間=F8),\"\",IF(F8<=所定労働時間,所定労働時間-F8))","v":""}]
[{"$f":"A8+1","v":"2017-04-01"},{"$f":"TEXT(A9,\"aaa\")","v":"金"},"08:00:00","18:30:00","01:00:00",{"$f":"D9-C9-E9","v":0.39583333333333337},{"$f":"MAX(D9-C9-E9-$C$5,0)","v":6.2500000000000056E-2},{"$f":"IF(OR(C9=\"\",D9=\"\",所定労働時間-F9<0,所定労働時間=F9),\"\",IF(F9<=所定労働時間,所定労働時間-F9))","v":""}]
[{"$f":"A9+1","v":"2017-04-02"},"土","08:00:00","12:00:00","00:00:00",{"$f":"D10-C10-E10","v":0.16666666666666669},{"$f":"MAX(D10-C10-E10-$C$5,0)","v":0},0.16666666666666663]
["2017-04-03","日",null,null,null,{"$f":"D11-C11-E11","v":0},{"$f":"MAX(D11-C11-E11-$C$5,0)","v":0},""]
["2017-04-04","月",null,null,null,0,0,""]
["2017-04-05","火",null,null,null,0,0,""]
["2017-04-06","水",null,null,null,0,0,""]
["2017-04-07","木",null,null,null,0,0,""]
["2017-04-08","金",null,null,null,0,0,""]
["2017-04-09","土",null,null,null,0,0,""]
[{"$f":"A17+1","v":"2017-04-10"},"日",null,null,null,0,0,""]
[{"$f":"A18+1","v":"2017-04-11"},"月",null,null,null,0,null,""]
["2017-04-12","火",null,null,null,0,0,""]
["2017-04-13","水",null,null,null,0,0,""]
["2017-04-14","木",null,null,null,0,0,""]
["2017-04-15","金",null,null,null,0,0,""]
["2017-04-16","土",null,null,null,0,0,""]
["2017-04-17","日",null,null,null,0,0,""]
["2017-04-18","月",null,null,null,0,0,""]
["2017-04-19","火",null,null,null,0,0,""]
["2017-04-20","水",null,null,null,0,0,""]
["2017-04-21","木",null,null,null,0,0,""]
["2017-04-22","金",null,null,null,0,0,""]
["2017-04-23","土",null,null,null,0,0,""]
[{"$f":"A31+1","v":"2017-04-24"},"日",null,null,null,0,0,""]
["2017-04-25","月",null,null,null,0,0,""]
[{"$f":"A33+1","v":"2017-04-26"},"火",null,null,null,0,0,""]
[{"$f":"A34+1","v":"2017-04-27"},"水",null,null,null,0,0,""]
[{"$f":"IF(DAY(A35+1)<10,\"\",A35+1)","v":"2017-04-28"},"木",null,null,null,0,0,""]
[{"$f":"IF(DAY(A36+1)<10,\"\",A36+1)","v":"2017-04-29"},"金",null,null,null,0,0,""]
[{"$f":"IF(DAY(A37+1)<10,\"\",A37+1)","v":""},"",null,null,null,{"$f":"D38-C38-E38","v":0},0,""]
[null,null,null,null,"合計",{"$f":"SUM(F8:F38)","v":0.89583333333333348},{"$f":"SUM(G8:G38)","v":6.2500000000000111E-2},{"$f":"SUM(H8:H38)","v":0.16666666666666663}]