{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["勤怠表","祝日リスト"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":2,"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":46,"n_cols":5,"rows_kept":46,"cut":false,"hidden":false,"merged":[[4,4,5,4],[41,1,42,1],[41,3,42,3],[3,2,3,4],[0,0,2,4],[3,0,3,1],[6,2,8,2],[6,3,8,3],[6,4,8,4],[6,0,8,0],[6,1,8,1],[4,0,5,1],[4,2,5,2],[4,3,5,3]]}
["勤怠表"]
[]
[]
["名前"]
[2016,null,"年",1,"月"]
[]
["日",null,"出社","退社","実務時間"]
[]
[]
[{"$f":"IF(COUNT(A5,D5)<2,\"\",DATE(A5,D5,1))","v":"2016-01-01"},{"$f":"IF(ISERROR(MATCH(A10,祝日,0)),\"\",INDEX(祝日名,MATCH(A10,祝日,0)))","v":"元日"},null,null,{"$f":"IF(OR(C10=\"\",D10=\"\"),\"\",D10-C10-$D$46)","v":""}]
[{"$f":"IF(A10=\"\",\"\",IF(DAY(A10+1)=1,\"\",A10+1))","v":"2016-01-02"},"",null,null,{"$f":"IF(OR(C11=\"\",D11=\"\"),\"\",D11-C11-$D$46)","v":""}]
[{"$f":"IF(A11=\"\",\"\",IF(DAY(A11+1)=1,\"\",A11+1))","v":"2016-01-03"},"",null,null,""]
["2016-01-04","",null,null,""]
["2016-01-05","",null,null,""]
["2016-01-06","",null,null,""]
["2016-01-07","",null,null,""]
["2016-01-08","",null,null,""]
["2016-01-09","",null,null,""]
["2016-01-10","",null,null,""]
["2016-01-11","成人の日",null,null,""]
["2016-01-12","",null,null,""]
["2016-01-13","",null,null,""]
["2016-01-14","",null,null,""]
["2016-01-15","",null,null,""]
["2016-01-16","",null,null,""]
["2016-01-17","",null,null,""]
["2016-01-18","",null,null,""]
["2016-01-19","",null,null,""]
["2016-01-20","",null,null,""]
["2016-01-21","",null,null,""]
["2016-01-22","",null,null,""]
["2016-01-23","",null,null,""]
["2016-01-24","",null,null,""]
["2016-01-25","",null,null,""]
["2016-01-26","",null,null,""]
["2016-01-27","",null,null,""]
[{"$f":"IF(A36=\"\",\"\",IF(DAY(A36+1)=1,\"\",A36+1))","v":"2016-01-28"},"",null,null,""]
["2016-01-29","",null,null,""]
[{"$f":"IF(A38=\"\",\"\",IF(DAY(A38+1)=1,\"\",A38+1))","v":"2016-01-30"},"",null,null,""]
["2016-01-31","",null,null,""]
[]
["勤務日数",null,"実務時間"]
[]
[]
[null,null,null,"休憩"]
[null,null,null,"01:00:00"]

{"sheet":"祝日リスト","index":1,"n_rows":18,"n_cols":2,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
["2016年祝日表"]
["2016-01-01","元日"]
["2016-01-11","成人の日"]
["2016-02-11","建国記念の日"]
["2016-03-20","春分の日"]
["2016-03-21","振替休日"]
["2016-04-29","昭和の日"]
["2016-05-03","憲法記念日"]
["2016-05-04","みどりの日"]
["2016-05-05","こどもの日"]
["2016-07-18","海の日"]
["2016-08-11","山の日"]
["2016-09-19","敬老の日"]
["2016-09-22","秋分の日"]
["2016-10-10","体育の日"]
["2016-11-03","文化の日"]
["2016-11-23","勤労感謝の日"]
["2016-12-23","天皇誕生日"]