{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["出勤簿"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":73,"n_cols":22,"rows_kept":73,"cut":false,"hidden":false,"merged":[[70,3,70,5],[70,11,70,13],[71,3,71,5],[71,11,71,13],[67,3,67,5],[67,11,67,13],[68,3,68,5],[68,11,68,13],[69,3,69,5],[69,11,69,13],[64,3,64,5],[64,11,64,13],[65,3,65,5],[65,11,65,13],[66,3,66,5],[66,11,66,13],[61,3,61,5],[61,11,61,13],[62,3,62,5],[62,11,62,13],[63,3,63,5],[63,11,63,13],[58,3,58,5],[58,11,58,13],[59,3,59,5],[59,11,59,13],[60,3,60,5],[60,11,60,13],[55,3,55,5],[55,11,55,13],[56,3,56,5],[56,11,56,13],[57,3,57,5],[57,11,57,13],[52,3,52,5],[52,11,52,13],[53,3,53,5],[53,11,53,13],[54,3,54,5],[54,11,54,13],[49,3,49,5],[49,11,49,13],[50,3,50,5],[50,11,50,13],[51,3,51,5],[51,11,51,13],[46,3,46,5],[46,11,46,13],[47,3,47,5],[47,11,47,13],[48,3,48,5],[48,11,48,13],[43,3,43,5],[43,11,43,13],[44,3,44,5],[44,11,44,13],[45,3,45,5],[45,11,45,13],[40,3,40,5],[40,11,40,13],[41,3,41,5],[41,11,41,13],[42,3,42,5],[42,11,42,13],[37,3,37,5],[37,11,37,13],[38,3,38,5],[38,11,38,13],[39,3,39,5],[39,11,39,13],[34,3,34,5],[34,11,34,13],[35,3,35,5],[35,11,35,13],[36,3,36,5],[36,11,36,13],[31,3,31,5],[31,11,31,13],[31,16,31,17],[32,3,32,5],[32,11,32,13],[33,3,33,5],[33,11,33,13],[25,0,26,11],[25,12,26,12],[25,13,26,13],[25,14,25,15],[25,16,26,16],[25,17,26,17],[26,14,26,15],[23,14,23,15],[23,16,24,16],[23,17,24,17],[24,2,24,3],[24,8,24,9],[24,14,24,15],[23,7,24,7],[23,8,23,9],[23,10,24,10],[23,11,24,11],[23,12,24,12],[23,13,24,13],[23,0,24,0],[23,1,24,1],[23,2,23,3],[23,4,24,4],[23,5,24,5],[23,6,24,6],[21,14,21,15],[21,16,22,16],[21,17,22,17],[22,2,22,3],[22,8,22,9],[22,14,22,15],[21,7,22,7],[21,8,21,9],[21,10,22,10],[21,11,22,11],[21,12,22,12],[21,13,22,13],[21,0,22,0],[21,1,22,1],[21,2,21,3],[21,4,22,4],[21,5,22,5],[21,6,22,6],[19,14,19,15],[19,16,20,16],[19,17,20,17],[20,2,20,3],[20,8,20,9],[20,14,20,15],[19,7,20,7],[19,8,19,9],[19,10,20,10],[19,11,20,11],[19,12,20,12],[19,13,20,13],[19,0,20,0],[19,1,20,1],[19,2,19,3],[19,4,20,4],[19,5,20,5],[19,6,20,6],[17,14,17,15],[17,16,18,16],[17,17,18,17],[18,2,18,3],[18,8,18,9],[18,14,18,15],[17,7,18,7],[17,8,17,9],[17,10,18,10],[17,11,18,11],[17,12,18,12],[17,13,18,13],[17,0,18,0],[17,1,18,1],[17,2,17,3],[17,4,18,4],[17,5,18,5],[17,6,18,6],[15,14,15,15],[15,16,16,16],[15,17,16,17],[16,2,16,3],[16,8,16,9],[16,14,16,15],[15,7,16,7],[15,8,15,9],[15,10,16,10],[15,11,16,11],[15,12,16,12],[15,13,16,13],[15,0,16,0],[15,1,16,1],[15,2,15,3],[15,4,16,4],[15,5,16,5],[15,6,16,6],[13,14,13,15],[13,16,14,16],[13,17,14,17],[14,2,14,3],[14,8,14,9],[14,14,14,15],[13,7,14,7],[13,8,13,9],[13,10,14,10],[13,11,14,11],[13,12,14,12],[13,13,14,13],[13,0,14,0],[13,1,14,1],[13,2,13,3],[13,4,14,4],[13,5,14,5],[13,6,14,6],[11,14,11,15],[11,16,12,16],[11,17,12,17],[12,2,12,3],[12,8,12,9],[12,14,12,15],[11,7,12,7],[11,8,11,9],[11,10,12,10],[11,11,12,11],[11,12,12,12],[11,13,12,13],[11,0,12,0],[11,1,12,1],[11,2,11,3],[11,4,12,4],[11,5,12,5],[11,6,12,6],[9,14,9,15],[9,16,10,16],[9,17,10,17],[10,2,10,3],[10,8,10,9],[10,14,10,15],[9,7,10,7],[9,8,9,9],[9,10,10,10],[9,11,10,11],[9,12,10,12],[9,13,10,13],[7,14,7,15],[7,16,8,16],[7,17,8,17],[8,2,8,3],[8,8,8,9],[8,14,8,15],[7,7,8,7],[7,8,7,9],[7,10,8,10],[7,11,8,11],[7,12,8,12],[7,13,8,13],[7,2,7,3],[7,4,8,4],[7,5,8,5],[7,6,8,6],[5,7,6,7],[5,8,5,9],[5,10,6,10],[5,11,6,11],[5,12,6,12],[5,13,6,13],[9,0,10,0],[9,1,10,1],[9,2,9,3],[9,4,10,4],[9,5,10,5],[9,6,10,6],[7,0,8,0],[7,1,8,1],[5,0,6,0],[5,1,6,1],[5,2,5,3],[5,4,6,4],[5,5,6,5],[5,6,6,6],[3,14,3,15],[3,16,4,16],[3,17,4,17],[4,2,4,3],[4,8,4,9],[4,14,4,15],[3,7,4,7],[3,8,3,9],[3,10,4,10],[3,11,4,11],[3,12,4,12],[3,13,4,13],[5,14,5,15],[5,16,6,16],[5,17,6,17],[6,2,6,3],[6,8,6,9],[6,14,6,15],[0,7,0,10],[2,8,2,9],[2,10,2,11],[2,14,2,16],[3,0,4,0],[3,1,4,1],[3,2,3,3],[3,4,4,4],[3,5,4,5],[3,6,4,6]]}
[null,null,null,null,null,null,null,"出勤簿",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($I$2<>\"\",IF($K$2<>\"\",DATE($I$2,$K$2,1),\"\"),\"\")","v":""},{"$f":"IF($U$1<>\"\",DATE(YEAR(U1),MONTH(U1)+1,DAY(U1)-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,"・I2に年、K2に月を入力すると、U1に指定された日からの年月日として保存する。"]
[{"$f":"$U$1","v":""},{"$f":"IF($A6=\"\",\"\",CHOOSE(WEEKDAY($A6),\"日\",\"月\",\"火\",\"水\",\"木\",\"金\",\"土\"))","v":""},null,null,{"$f":"IF(COUNTIFS($C6,\"<>\",$C7,\"<>\"),$C7-$C6,\"\")","v":""},null,{"$f":"IF($U$1=\"\",\"\",$U$1+10)","v":""},{"$f":"IF($G6=\"\",\"\",CHOOSE(WEEKDAY($G6),\"日\",\"月\",\"火\",\"水\",\"木\",\"金\",\"土\"))","v":""},null,null,{"$f":"IF(COUNTIFS($I6,\"<>\",$I7,\"<>\"),$I7-$I6,\"\")","v":""},null,{"$f":"IF($U$1=\"\",\"\",$U$1+20)","v":""},{"$f":"IF($M6=\"\",\"\",CHOOSE(WEEKDAY($M6),\"日\",\"月\",\"火\",\"水\",\"木\",\"金\",\"土\"))","v":""},null,null,{"$f":"IF(COUNTIFS($O6,\"<>\",$O7,\"<>\"),$O7-$O6,\"\")","v":""},null,null,null,"・ただし、I2又はK2が未入力の場合、U1には何も設定されない。"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"・U1が指定されると、V1にその月の最後の日が設定される。"]
[{"$f":"IF($U$1=\"\",\"\",$U$1+1)","v":""},{"$f":"IF($A8=\"\",\"\",CHOOSE(WEEKDAY($A8),\"日\",\"月\",\"火\",\"水\",\"木\",\"金\",\"土\"))","v":""},null,null,{"$f":"IF(COUNTIFS($C8,\"<>\",$C9,\"<>\"),$C9-$C8,\"\")","v":""},null,{"$f":"IF($U$1=\"\",\"\",$U$1+11)","v":""},{"$f":"IF($G8=\"\",\"\",CHOOSE(WEEKDAY($G8),\"日\",\"月\",\"火\",\"水\",\"木\",\"金\",\"土\"))","v":""},null,null,{"$f":"IF(COUNTIFS($I8,\"<>\",$I9,\"<>\"),$I9-$I8,\"\")","v":""},null,{"$f":"IF($U$1=\"\",\"\",$U$1+21)","v":""},{"$f":"IF($M8=\"\",\"\",CHOOSE(WEEKDAY($M8),\"日\",\"月\",\"火\",\"水\",\"木\",\"金\",\"土\"))","v":""},null,null,{"$f":"IF(COUNTIFS($O8,\"<>\",$O9,\"<>\"),$O9-$O8,\"\")","v":""}]
[]
[{"$f":"IF($U$1=\"\",\"\",$U$1+2)","v":""},{"$f":"IF($A10=\"\",\"\",CHOOSE(WEEKDAY($A10),\"日\",\"月\",\"火\",\"水\",\"木\",\"金\",\"土\"))","v":""},null,null,{"$f":"IF(COUNTIFS($C10,\"<>\",$C11,\"<>\"),$C11-$C10,\"\")","v":""},null,{"$f":"IF($U$1=\"\",\"\",$U$1+12)","v":""},{"$f":"IF($G10=\"\",\"\",CHOOSE(WEEKDAY($G10),\"日\",\"月\",\"火\",\"水\",\"木\",\"金\",\"土\"))","v":""},null,null,{"$f":"IF(COUNTIFS($I10,\"<>\",$I11,\"<>\"),$I11-$I10,\"\")","v":""},null,{"$f":"IF($U$1=\"\",\"\",$U$1+22)","v":""},{"$f":"IF($M10=\"\",\"\",CHOOSE(WEEKDAY($M10),\"日\",\"月\",\"火\",\"水\",\"木\",\"金\",\"土\"))","v":""},null,null,{"$f":"IF(COUNTIFS($O10,\"<>\",$O11,\"<>\"),$O11-$O10,\"\")","v":""},null,null,null,"・U1を元にA列の日付とその日付に該当する曜日をB列に表示する。"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"・U1を元にG列の日付とその日付に該当する曜日をH列に表示する。"]
[{"$f":"IF($U$1=\"\",\"\",$U$1+3)","v":""},{"$f":"IF($A12=\"\",\"\",CHOOSE(WEEKDAY($A12),\"日\",\"月\",\"火\",\"水\",\"木\",\"金\",\"土\"))","v":""},null,null,{"$f":"IF(COUNTIFS($C12,\"<>\",$C13,\"<>\"),$C13-$C12,\"\")","v":""},null,{"$f":"IF($U$1=\"\",\"\",$U$1+13)","v":""},{"$f":"IF($G12=\"\",\"\",CHOOSE(WEEKDAY($G12),\"日\",\"月\",\"火\",\"水\",\"木\",\"金\",\"土\"))","v":""},null,null,{"$f":"IF(COUNTIFS($I12,\"<>\",$I13,\"<>\"),$I13-$I12,\"\")","v":""},null,{"$f":"IF($U$1=\"\",\"\",$U$1+23)","v":""},{"$f":"IF($M12=\"\",\"\",CHOOSE(WEEKDAY($M12),\"日\",\"月\",\"火\",\"水\",\"木\",\"金\",\"土\"))","v":""},null,null,{"$f":"IF(COUNTIFS($O12,\"<>\",$O13,\"<>\"),$O13-$O12,\"\")","v":""},null,null,null,"・U1を元にM列の日付とその日付に該当する曜日をN列に表示する。"]
[]
[{"$f":"IF($U$1=\"\",\"\",$U$1+4)","v":""},{"$f":"IF($A14=\"\",\"\",CHOOSE(WEEKDAY($A14),\"日\",\"月\",\"火\",\"水\",\"木\",\"金\",\"土\"))","v":""},null,null,{"$f":"IF(COUNTIFS($C14,\"<>\",$C15,\"<>\"),$C15-$C14,\"\")","v":""},null,{"$f":"IF($U$1=\"\",\"\",$U$1+14)","v":""},{"$f":"IF($G14=\"\",\"\",CHOOSE(WEEKDAY($G14),\"日\",\"月\",\"火\",\"水\",\"木\",\"金\",\"土\"))","v":""},null,null,{"$f":"IF(COUNTIFS($I14,\"<>\",$I15,\"<>\"),$I15-$I14,\"\")","v":""},null,{"$f":"IF($U$1=\"\",\"\",$U$1+24)","v":""},{"$f":"IF($M14=\"\",\"\",CHOOSE(WEEKDAY($M14),\"日\",\"月\",\"火\",\"水\",\"木\",\"金\",\"土\"))","v":""},null,null,{"$f":"IF(COUNTIFS($O14,\"<>\",$O15,\"<>\"),$O15-$O14,\"\")","v":""},null,null,null,"・２９日、３０日、３１日は表示されない場合があるので、A1の値がU1より大きな場合は表示させないことで対応する。"]
[]
[{"$f":"IF($U$1=\"\",\"\",$U$1+5)","v":""},{"$f":"IF($A16=\"\",\"\",CHOOSE(WEEKDAY($A16),\"日\",\"月\",\"火\",\"水\",\"木\",\"金\",\"土\"))","v":""},null,null,{"$f":"IF(COUNTIFS($C16,\"<>\",$C17,\"<>\"),$C17-$C16,\"\")","v":""},null,{"$f":"IF($U$1=\"\",\"\",$U$1+15)","v":""},{"$f":"IF($G16=\"\",\"\",CHOOSE(WEEKDAY($G16),\"日\",\"月\",\"火\",\"水\",\"木\",\"金\",\"土\"))","v":""},null,null,{"$f":"IF(COUNTIFS($I16,\"<>\",$I17,\"<>\"),$I17-$I16,\"\")","v":""},null,{"$f":"IF($U$1=\"\",\"\",$U$1+25)","v":""},{"$f":"IF($M16=\"\",\"\",CHOOSE(WEEKDAY($M16),\"日\",\"月\",\"火\",\"水\",\"木\",\"金\",\"土\"))","v":""},null,null,{"$f":"IF(COUNTIFS($O16,\"<>\",$O17,\"<>\"),$O17-$O16,\"\")","v":""},null,null,null,"・その年の休日（祝祭日や行事等）設定を作る。L列に日付として保存する。"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"・その年の平日（臨時出勤日や行事等）設定を作る。O列に日付として保存する。"]
[{"$f":"IF($U$1=\"\",\"\",$U$1+6)","v":""},{"$f":"IF($A18=\"\",\"\",CHOOSE(WEEKDAY($A18),\"日\",\"月\",\"火\",\"水\",\"木\",\"金\",\"土\"))","v":""},null,null,{"$f":"IF(COUNTIFS($C18,\"<>\",$C19,\"<>\"),$C19-$C18,\"\")","v":""},null,{"$f":"IF($U$1=\"\",\"\",$U$1+16)","v":""},{"$f":"IF($G18=\"\",\"\",CHOOSE(WEEKDAY($G18),\"日\",\"月\",\"火\",\"水\",\"木\",\"金\",\"土\"))","v":""},null,null,{"$f":"IF(COUNTIFS($I18,\"<>\",$I19,\"<>\"),$I19-$I18,\"\")","v":""},null,{"$f":"IF($U$1=\"\",\"\",$U$1+26)","v":""},{"$f":"IF($M18=\"\",\"\",CHOOSE(WEEKDAY($M18),\"日\",\"月\",\"火\",\"水\",\"木\",\"金\",\"土\"))","v":""},null,null,{"$f":"IF(COUNTIFS($O18,\"<>\",$O19,\"<>\"),$O19-$O18,\"\")","v":""},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($U$1=\"\",\"\",$U$1+7)","v":""},{"$f":"IF($A20=\"\",\"\",CHOOSE(WEEKDAY($A20),\"日\",\"月\",\"火\",\"水\",\"木\",\"金\",\"土\"))","v":""},null,null,{"$f":"IF(COUNTIFS($C20,\"<>\",$C21,\"<>\"),$C21-$C20,\"\")","v":""},null,{"$f":"IF($U$1=\"\",\"\",$U$1+17)","v":""},{"$f":"IF($G20=\"\",\"\",CHOOSE(WEEKDAY($G20),\"日\",\"月\",\"火\",\"水\",\"木\",\"金\",\"土\"))","v":""},null,null,{"$f":"IF(COUNTIFS($I20,\"<>\",$I21,\"<>\"),$I21-$I20,\"\")","v":""},null,{"$f":"IF($U$1=\"\",\"\",$U$1+27)","v":""},{"$f":"IF($M20=\"\",\"\",CHOOSE(WEEKDAY($M20),\"日\",\"月\",\"火\",\"水\",\"木\",\"金\",\"土\"))","v":""},null,null,{"$f":"IF(COUNTIFS($O20,\"<>\",$O21,\"<>\"),$O21-$O20,\"\")","v":""},null,null,null,"・R列に”出”、”休日”を表示することで判断をする。"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"・条件付き書式によりR列が”休日”の場合、休日色とする。"]
[{"$f":"IF($U$1=\"\",\"\",$U$1+8)","v":""},{"$f":"IF($A22=\"\",\"\",CHOOSE(WEEKDAY($A22),\"日\",\"月\",\"火\",\"水\",\"木\",\"金\",\"土\"))","v":""},null,null,{"$f":"IF(COUNTIFS($C22,\"<>\",$C23,\"<>\"),$C23-$C22,\"\")","v":""},null,{"$f":"IF($U$1=\"\",\"\",$U$1+18)","v":""},{"$f":"IF($G22=\"\",\"\",CHOOSE(WEEKDAY($G22),\"日\",\"月\",\"火\",\"水\",\"木\",\"金\",\"土\"))","v":""},null,null,{"$f":"IF(COUNTIFS($I22,\"<>\",$I23,\"<>\"),$I23-$I22,\"\")","v":""},null,{"$f":"IF($U$1<>\"\",IF($U$1+28>$V$1,\"\",IF($U$1=\"\",\"\",$U$1+28)),\"\")","v":""},{"$f":"IF($M22=\"\",\"\",CHOOSE(WEEKDAY($M22),\"日\",\"月\",\"火\",\"水\",\"木\",\"金\",\"土\"))","v":""},null,null,{"$f":"IF(COUNTIFS($O22,\"<>\",$O23,\"<>\"),$O23-$O22,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"『始業時刻』と『終業時刻』に時刻以外の数字や文字が入力されないように入力規則を設定する。"]
[{"$f":"IF($U$1=\"\",\"\",$U$1+9)","v":""},{"$f":"IF($A24=\"\",\"\",CHOOSE(WEEKDAY($A24),\"日\",\"月\",\"火\",\"水\",\"木\",\"金\",\"土\"))","v":""},null,null,{"$f":"IF(COUNTIFS($C24,\"<>\",$C25,\"<>\"),$C25-$C24,\"\")","v":""},null,{"$f":"IF($U$1=\"\",\"\",$U$1+19)","v":""},{"$f":"IF($G24=\"\",\"\",CHOOSE(WEEKDAY($G24),\"日\",\"月\",\"火\",\"水\",\"木\",\"金\",\"土\"))","v":""},null,null,{"$f":"IF(COUNTIFS($I24,\"<>\",$I25,\"<>\"),$I25-$I24,\"\")","v":""},null,{"$f":"IF($U$1<>\"\",IF($U$1+29>$V$1,\"\",IF($U$1=\"\",\"\",$U$1+29)),\"\")","v":""},{"$f":"IF($M24=\"\",\"\",CHOOSE(WEEKDAY($M24),\"日\",\"月\",\"火\",\"水\",\"木\",\"金\",\"土\"))","v":""},null,null,{"$f":"IF(COUNTIFS($O24,\"<>\",$O25,\"<>\"),$O25-$O24,\"\")","v":""}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($U$1<>\"\",IF($U$1+30>$V$1,\"\",IF($U$1=\"\",\"\",$U$1+30)),\"\")","v":""},{"$f":"IF($M26=\"\",\"\",CHOOSE(WEEKDAY($M26),\"日\",\"月\",\"火\",\"水\",\"木\",\"金\",\"土\"))","v":""},null,null,{"$f":"IF(COUNTIFS($O26,\"<>\",$O27,\"<>\"),$O27-$O26,\"\")","v":""}]
[]
[]
[]
[]
["休日設定（最大４０個指定可能）",null,null,null,null,null,null,null,"平日設定（最大４０個指定可能）"]
["No","月","日","内容",null,null,null,null,"No","月","日","内容",null,null,null,null,"休日"]
[1,1,1,"元日",null,null,{"$f":"IF($B33=\"\",\"\",IF($C33=\"\",\"\",DATE($I$2,$B33,$C33)))","v":"1900-01-01"},null,1,1,18,"土曜出勤",null,null,{"$f":"IF($J33=\"\",\"\",IF($K33=\"\",\"\",DATE($I$2,$J33,$K33)))","v":"1900-01-18"},null,1,{"$f":"IF($A6=\"\",\"\",IF(CHOOSE(WEEKDAY($A6),0,1,1,1,1,1,0),IF(COUNTIF($G$33:$G$72,$A6),\"休日\",\"出\"),IF(COUNTIF($O$33:$O$72,$A6),\"出\",\"休日\")))","v":""}]
[2,1,13,"成人の日",null,null,"1900-01-13",null,2,2,15,"土曜出勤",null,null,"1900-02-15",null,2,{"$f":"IF($A8=\"\",\"\",IF(CHOOSE(WEEKDAY($A8),0,1,1,1,1,1,0),IF(COUNTIF($G$33:$G$72,$A8),\"休日\",\"出\"),IF(COUNTIF($O$33:$O$72,$A8),\"出\",\"休日\")))","v":""}]
[3,2,11,"建国記念の日",null,null,"1900-02-11",null,3,2,29,"土曜出勤",null,null,60,null,3,{"$f":"IF($A10=\"\",\"\",IF(CHOOSE(WEEKDAY($A10),0,1,1,1,1,1,0),IF(COUNTIF($G$33:$G$72,$A10),\"休日\",\"出\"),IF(COUNTIF($O$33:$O$72,$A10),\"出\",\"休日\")))","v":""}]
[4,2,23,"天皇誕生日",null,null,"1900-02-23",null,4,5,2,"土曜出勤",null,null,"1900-05-02",null,4,{"$f":"IF($A12=\"\",\"\",IF(CHOOSE(WEEKDAY($A12),0,1,1,1,1,1,0),IF(COUNTIF($G$33:$G$72,$A12),\"休日\",\"出\"),IF(COUNTIF($O$33:$O$72,$A12),\"出\",\"休日\")))","v":""}]
[5,3,20,"春分の日",null,null,"1900-03-20",null,5,5,9,"土曜出勤",null,null,"1900-05-09",null,5,{"$f":"IF($A14=\"\",\"\",IF(CHOOSE(WEEKDAY($A14),0,1,1,1,1,1,0),IF(COUNTIF($G$33:$G$72,$A14),\"休日\",\"出\"),IF(COUNTIF($O$33:$O$72,$A14),\"出\",\"休日\")))","v":""}]
[6,4,29,"昭和の日",null,null,"1900-04-29",null,6,null,null,"土曜出勤",null,null,"",null,6,{"$f":"IF($A16=\"\",\"\",IF(CHOOSE(WEEKDAY($A16),0,1,1,1,1,1,0),IF(COUNTIF($G$33:$G$72,$A16),\"休日\",\"出\"),IF(COUNTIF($O$33:$O$72,$A16),\"出\",\"休日\")))","v":""}]
[7,5,3,"憲法記念日",null,null,"1900-05-03",null,7,9,26,"土曜出勤",null,null,"1900-09-26",null,7,{"$f":"IF($A18=\"\",\"\",IF(CHOOSE(WEEKDAY($A18),0,1,1,1,1,1,0),IF(COUNTIF($G$33:$G$72,$A18),\"休日\",\"出\"),IF(COUNTIF($O$33:$O$72,$A18),\"出\",\"休日\")))","v":""}]
[8,5,4,"みどりの日",null,null,"1900-05-04",null,8,11,7,"土曜出勤",null,null,"1900-11-07",null,8,{"$f":"IF($A20=\"\",\"\",IF(CHOOSE(WEEKDAY($A20),0,1,1,1,1,1,0),IF(COUNTIF($G$33:$G$72,$A20),\"休日\",\"出\"),IF(COUNTIF($O$33:$O$72,$A20),\"出\",\"休日\")))","v":""}]
[9,5,5,"こどもの日",null,null,"1900-05-05",null,9,11,28,"土曜出勤",null,null,"1900-11-28",null,9,{"$f":"IF($A22=\"\",\"\",IF(CHOOSE(WEEKDAY($A22),0,1,1,1,1,1,0),IF(COUNTIF($G$33:$G$72,$A22),\"休日\",\"出\"),IF(COUNTIF($O$33:$O$72,$A22),\"出\",\"休日\")))","v":""}]
[10,7,23,"海の日",null,null,"1900-07-23",null,10,null,null,"土曜出勤",null,null,"",null,10,{"$f":"IF($A24=\"\",\"\",IF(CHOOSE(WEEKDAY($A24),0,1,1,1,1,1,0),IF(COUNTIF($G$33:$G$72,$A24),\"休日\",\"出\"),IF(COUNTIF($O$33:$O$72,$A24),\"出\",\"休日\")))","v":""}]
[11,8,10,"山の日",null,null,"1900-08-10",null,11,null,null,"土曜出勤",null,null,"",null,11,{"$f":"IF($G6=\"\",\"\",IF(CHOOSE(WEEKDAY($G6),0,1,1,1,1,1,0),IF(COUNTIF($G$33:$G$72,$G6),\"休日\",\"出\"),IF(COUNTIF($O$33:$O$72,$G6),\"出\",\"休日\")))","v":""}]
[12,9,21,"敬老の日",null,null,"1900-09-21",null,12,null,null,"土曜出勤",null,null,"",null,12,{"$f":"IF($G8=\"\",\"\",IF(CHOOSE(WEEKDAY($G8),0,1,1,1,1,1,0),IF(COUNTIF($G$33:$G$72,$G8),\"休日\",\"出\"),IF(COUNTIF($O$33:$O$72,$G8),\"出\",\"休日\")))","v":""}]
[13,9,22,"秋分の日",null,null,"1900-09-22",null,13,null,null,null,null,null,"",null,13,{"$f":"IF($G10=\"\",\"\",IF(CHOOSE(WEEKDAY($G10),0,1,1,1,1,1,0),IF(COUNTIF($G$33:$G$72,$G10),\"休日\",\"出\"),IF(COUNTIF($O$33:$O$72,$G10),\"出\",\"休日\")))","v":""}]
[14,7,24,"スポーツの日",null,null,"1900-07-24",null,14,null,null,"地域貢献",null,null,"",null,14,{"$f":"IF($G12=\"\",\"\",IF(CHOOSE(WEEKDAY($G12),0,1,1,1,1,1,0),IF(COUNTIF($G$33:$G$72,$G12),\"休日\",\"出\"),IF(COUNTIF($O$33:$O$72,$G12),\"出\",\"休日\")))","v":""}]
[15,11,3,"文化の日",null,null,"1900-11-03",null,15,null,null,"地域貢献",null,null,"",null,15,{"$f":"IF($G14=\"\",\"\",IF(CHOOSE(WEEKDAY($G14),0,1,1,1,1,1,0),IF(COUNTIF($G$33:$G$72,$G14),\"休日\",\"出\"),IF(COUNTIF($O$33:$O$72,$G14),\"出\",\"休日\")))","v":""}]
[16,11,23,"勤労感謝の日",null,null,"1900-11-23",null,16,null,null,"地域貢献",null,null,"",null,16,{"$f":"IF($G16=\"\",\"\",IF(CHOOSE(WEEKDAY($G16),0,1,1,1,1,1,0),IF(COUNTIF($G$33:$G$72,$G16),\"休日\",\"出\"),IF(COUNTIF($O$33:$O$72,$G16),\"出\",\"休日\")))","v":""}]
[17,null,null,null,null,null,"",null,17,null,null,null,null,null,"",null,17,{"$f":"IF($G18=\"\",\"\",IF(CHOOSE(WEEKDAY($G18),0,1,1,1,1,1,0),IF(COUNTIF($G$33:$G$72,$G18),\"休日\",\"出\"),IF(COUNTIF($O$33:$O$72,$G18),\"出\",\"休日\")))","v":""}]
[18,8,13,"夏季1",null,null,"1900-08-13",null,18,null,null,null,null,null,"",null,18,{"$f":"IF($G20=\"\",\"\",IF(CHOOSE(WEEKDAY($G20),0,1,1,1,1,1,0),IF(COUNTIF($G$33:$G$72,$G20),\"休日\",\"出\"),IF(COUNTIF($O$33:$O$72,$G20),\"出\",\"休日\")))","v":""}]
[19,8,14,"夏季2",null,null,"1900-08-14",null,19,null,null,null,null,null,"",null,19,{"$f":"IF($G22=\"\",\"\",IF(CHOOSE(WEEKDAY($G22),0,1,1,1,1,1,0),IF(COUNTIF($G$33:$G$72,$G22),\"休日\",\"出\"),IF(COUNTIF($O$33:$O$72,$G22),\"出\",\"休日\")))","v":""}]
[20,8,15,"夏季3",null,null,"1900-08-15",null,20,null,null,null,null,null,"",null,20,{"$f":"IF($G24=\"\",\"\",IF(CHOOSE(WEEKDAY($G24),0,1,1,1,1,1,0),IF(COUNTIF($G$33:$G$72,$G24),\"休日\",\"出\"),IF(COUNTIF($O$33:$O$72,$G24),\"出\",\"休日\")))","v":""}]
[21,null,null,null,null,null,"",null,21,null,null,null,null,null,"",null,21,{"$f":"IF($M6=\"\",\"\",IF(CHOOSE(WEEKDAY($M6),0,1,1,1,1,1,0),IF(COUNTIF($G$33:$G$72,$M6),\"休日\",\"出\"),IF(COUNTIF($O$33:$O$72,$M6),\"出\",\"休日\")))","v":""}]
[22,12,28,"年末年始1",null,null,"1900-12-28",null,22,null,null,null,null,null,"",null,22,{"$f":"IF($M8=\"\",\"\",IF(CHOOSE(WEEKDAY($M8),0,1,1,1,1,1,0),IF(COUNTIF($G$33:$G$72,$M8),\"休日\",\"出\"),IF(COUNTIF($O$33:$O$72,$M8),\"出\",\"休日\")))","v":""}]
[23,12,29,"年末年始2",null,null,"1900-12-29",null,23,null,null,null,null,null,"",null,23,{"$f":"IF($M10=\"\",\"\",IF(CHOOSE(WEEKDAY($M10),0,1,1,1,1,1,0),IF(COUNTIF($G$33:$G$72,$M10),\"休日\",\"出\"),IF(COUNTIF($O$33:$O$72,$M10),\"出\",\"休日\")))","v":""}]
[24,12,30,"年末年始3",null,null,"1900-12-30",null,24,null,null,null,null,null,"",null,24,{"$f":"IF($M12=\"\",\"\",IF(CHOOSE(WEEKDAY($M12),0,1,1,1,1,1,0),IF(COUNTIF($G$33:$G$72,$M12),\"休日\",\"出\"),IF(COUNTIF($O$33:$O$72,$M12),\"出\",\"休日\")))","v":""}]
[25,12,31,"年末年始4",null,null,"1900-12-31",null,25,null,null,null,null,null,"",null,25,{"$f":"IF($M14=\"\",\"\",IF(CHOOSE(WEEKDAY($M14),0,1,1,1,1,1,0),IF(COUNTIF($G$33:$G$72,$M14),\"休日\",\"出\"),IF(COUNTIF($O$33:$O$72,$M14),\"出\",\"休日\")))","v":""}]
[26,1,2,"年末年始5",null,null,"1900-01-02",null,26,null,null,null,null,null,"",null,26,{"$f":"IF($M16=\"\",\"\",IF(CHOOSE(WEEKDAY($M16),0,1,1,1,1,1,0),IF(COUNTIF($G$33:$G$72,$M16),\"休日\",\"出\"),IF(COUNTIF($O$33:$O$72,$M16),\"出\",\"休日\")))","v":""}]
[27,1,3,"年末年始6",null,null,"1900-01-03",null,27,null,null,null,null,null,"",null,27,{"$f":"IF($M18=\"\",\"\",IF(CHOOSE(WEEKDAY($M18),0,1,1,1,1,1,0),IF(COUNTIF($G$33:$G$72,$M18),\"休日\",\"出\"),IF(COUNTIF($O$33:$O$72,$M18),\"出\",\"休日\")))","v":""}]
[28,null,null,null,null,null,"",null,28,null,null,null,null,null,"",null,28,{"$f":"IF($M20=\"\",\"\",IF(CHOOSE(WEEKDAY($M20),0,1,1,1,1,1,0),IF(COUNTIF($G$33:$G$72,$M20),\"休日\",\"出\"),IF(COUNTIF($O$33:$O$72,$M20),\"出\",\"休日\")))","v":""}]
[29,null,null,"創立記念日",null,null,"",null,29,null,null,null,null,null,"",null,29,{"$f":"IF($M22=\"\",\"\",IF(CHOOSE(WEEKDAY($M22),0,1,1,1,1,1,0),IF(COUNTIF($G$33:$G$72,$M22),\"休日\",\"出\"),IF(COUNTIF($O$33:$O$72,$M22),\"出\",\"休日\")))","v":""}]
[30,null,null,null,null,null,"",null,30,null,null,null,null,null,"",null,30,{"$f":"IF($M24=\"\",\"\",IF(CHOOSE(WEEKDAY($M24),0,1,1,1,1,1,0),IF(COUNTIF($G$33:$G$72,$M24),\"休日\",\"出\"),IF(COUNTIF($O$33:$O$72,$M24),\"出\",\"休日\")))","v":""}]
[31,2,24,"振替休日",null,null,"1900-02-24",null,31,null,null,null,null,null,"",null,31,{"$f":"IF($M26=\"\",\"\",IF(CHOOSE(WEEKDAY($M26),0,1,1,1,1,1,0),IF(COUNTIF($G$33:$G$72,$M26),\"休日\",\"出\"),IF(COUNTIF($O$33:$O$72,$M26),\"出\",\"休日\")))","v":""}]
[32,5,6,"振替休日",null,null,"1900-05-06",null,32,null,null,null,null,null,""]
[33,null,null,"振替休日",null,null,"",null,33,null,null,null,null,null,""]
[34,null,null,"振替休日",null,null,"",null,34,null,null,null,null,null,""]
[35,null,null,null,null,null,"",null,35,null,null,null,null,null,""]
[36,null,null,"ボランティア休暇",null,null,"",null,36,null,null,null,null,null,""]
[37,null,null,"ボランティア休暇",null,null,"",null,37,null,null,null,null,null,""]
[38,null,null,"ボランティア休暇",null,null,"",null,38,null,null,null,null,null,""]
[39,null,null,null,null,null,"",null,39,null,null,null,null,null,""]
[40,null,null,null,null,null,"",null,40,null,null,null,null,null,""]
["（月と日が設定されていない場合は使用不可とする",null,null,null,null,null,null,null,"（月と日が設定されていない場合は使用不可とする"]