{"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":89,"n_cols":20,"rows_kept":89,"cut":false,"hidden":false,"merged":[[6,0,6,1],[6,3,6,5],[6,8,6,10],[6,11,6,15],[7,0,7,1],[7,3,7,5],[7,8,7,10],[7,11,7,15],[0,0,0,15],[1,1,1,2],[4,0,4,4],[4,5,4,9],[5,0,5,4],[5,5,5,9],[10,0,10,1],[10,3,10,5],[10,8,10,10],[10,11,10,15],[11,0,11,1],[11,3,11,5],[11,8,11,10],[11,11,11,15],[8,0,8,1],[8,3,8,5],[8,8,8,10],[8,11,8,15],[9,0,9,1],[9,3,9,5],[9,8,9,10],[9,11,9,15],[14,0,14,1],[14,3,14,5],[14,8,14,10],[14,11,14,15],[15,0,15,1],[15,3,15,5],[15,8,15,10],[15,11,15,15],[12,0,12,1],[12,3,12,5],[12,8,12,10],[12,11,12,15],[13,0,13,1],[13,3,13,5],[13,8,13,10],[13,11,13,15],[18,0,18,1],[18,3,18,5],[18,8,18,10],[18,11,18,15],[19,0,19,1],[19,3,19,5],[19,8,19,10],[19,11,19,15],[16,0,16,1],[16,3,16,5],[16,8,16,10],[16,11,16,15],[17,0,17,1],[17,3,17,5],[17,8,17,10],[17,11,17,15],[22,0,22,1],[22,3,22,5],[22,8,22,10],[22,11,22,15],[23,0,23,1],[23,3,23,5],[23,8,23,10],[23,11,23,15],[20,0,20,1],[20,3,20,5],[20,8,20,10],[20,11,20,15],[21,0,21,1],[21,3,21,5],[21,8,21,10],[21,11,21,15],[26,0,26,1],[26,3,26,5],[26,8,26,10],[26,11,26,15],[27,0,27,1],[27,3,27,5],[27,8,27,10],[27,11,27,15],[24,0,24,1],[24,3,24,5],[24,8,24,10],[24,11,24,15],[25,0,25,1],[25,3,25,5],[25,8,25,10],[25,11,25,15],[30,0,30,1],[30,3,30,5],[30,8,30,10],[30,11,30,15],[31,0,31,1],[31,3,31,5],[31,8,31,10],[31,11,31,15],[28,0,28,1],[28,3,28,5],[28,8,28,10],[28,11,28,15],[29,0,29,1],[29,3,29,5],[29,8,29,10],[29,11,29,15],[34,0,34,1],[34,3,34,5],[34,8,34,10],[34,11,34,15],[35,0,35,1],[35,3,35,5],[35,8,35,10],[35,11,35,15],[32,0,32,1],[32,3,32,5],[32,8,32,10],[32,11,32,15],[33,0,33,1],[33,3,33,5],[33,8,33,10],[33,11,33,15],[38,0,38,15],[39,0,39,15],[40,0,40,15],[41,0,41,15],[42,0,42,15],[43,0,43,15],[36,0,36,1],[36,3,36,5],[36,8,36,10],[36,11,36,15],[37,0,37,1],[37,3,37,5],[37,8,37,10],[37,11,37,15],[49,0,49,1],[49,4,49,6],[49,11,49,13],[50,0,50,1],[50,4,50,6],[50,11,50,13],[44,0,44,15],[47,0,47,1],[47,4,47,6],[47,11,47,13],[48,0,48,1],[48,4,48,6],[48,11,48,13],[53,0,53,1],[53,4,53,6],[53,11,53,13],[54,0,54,1],[54,4,54,6],[54,11,54,13],[51,0,51,1],[51,4,51,6],[51,11,51,13],[52,0,52,1],[52,4,52,6],[52,11,52,13],[57,0,57,1],[57,4,57,6],[57,11,57,13],[58,0,58,1],[58,4,58,6],[58,11,58,13],[55,0,55,1],[55,4,55,6],[55,11,55,13],[56,0,56,1],[56,4,56,6],[56,11,56,13],[61,0,61,1],[61,4,61,6],[61,11,61,13],[62,0,62,1],[62,4,62,6],[62,11,62,13],[59,0,59,1],[59,4,59,6],[59,11,59,13],[60,0,60,1],[60,4,60,6],[60,11,60,13],[65,0,65,1],[65,4,65,6],[65,11,65,13],[66,0,66,1],[66,4,66,6],[66,11,66,13],[63,0,63,1],[63,4,63,6],[63,11,63,13],[64,0,64,1],[64,4,64,6],[64,11,64,13],[69,0,69,1],[69,4,69,6],[69,11,69,13],[70,0,70,1],[70,4,70,6],[70,11,70,13],[67,0,67,1],[67,4,67,6],[67,11,67,13],[68,0,68,1],[68,4,68,6],[68,11,68,13],[73,0,73,1],[73,4,73,6],[73,11,73,13],[74,0,74,1],[74,4,74,6],[74,11,74,13],[71,0,71,1],[71,4,71,6],[71,11,71,13],[72,0,72,1],[72,4,72,6],[72,11,72,13],[77,0,77,1],[77,4,77,6],[77,11,77,13],[78,0,78,1],[78,4,78,6],[78,11,78,13],[75,0,75,1],[75,4,75,6],[75,11,75,13],[76,0,76,1],[76,4,76,6],[76,11,76,13],[81,0,81,1],[81,4,81,6],[81,11,81,13],[82,0,82,1],[82,4,82,6],[82,11,82,13],[79,0,79,1],[79,4,79,6],[79,11,79,13],[80,0,80,1],[80,4,80,6],[80,11,80,13],[85,0,85,1],[85,4,85,6],[85,11,85,13],[86,0,86,1],[86,4,86,6],[86,11,86,13],[83,0,83,1],[83,4,83,6],[83,11,83,13],[84,0,84,1],[84,4,84,6],[84,11,84,13],[92,0,92,1],[93,0,93,1],[94,0,94,1],[95,0,95,1],[96,0,96,1],[97,0,97,1],[87,0,87,1],[87,4,87,6],[87,11,87,13],[89,0,89,1],[90,0,90,1],[91,0,91,1],[110,0,110,1],[111,0,111,1],[104,0,104,1],[105,0,105,1],[106,0,106,1],[107,0,107,1],[108,0,108,1],[109,0,109,1],[98,0,98,1],[99,0,99,1],[100,0,100,1],[101,0,101,1],[102,0,102,1],[103,0,103,1]]}
[{"$f":"_xlfn.CONCAT(\"勤務簿\")","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,"・b2に年、c3に月、e3に日を入力すると、t7に指定された日からの年月日として保存する。"]
[null,"（始業時刻・終業時刻・休憩時刻を入力してください）",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"・ただし、b2又はc3又はe3が未入力の場合、t7には何も設定されない。"]
["社員番号",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"・t7が指定されると、t8にその月の最後の日が設定される。"]
["氏名"]
["日",null,"曜","始業時刻",null,null,"終業時刻","休憩時刻","実働時間",null,null,"備考",null,null,null,null,null,null,"月初",{"$f":"IF(B2<>\"\",IF(C3<>\"\",IF(E3<>\"\",DATE(B2,C3,E3),\"\"),\"\"),\"\")","v":""}]
[{"$f":"T7","v":""},null,{"$f":"IF($T$7=\"\",\"\",CHOOSE(WEEKDAY($A8),\"日\",\"月\",\"火\",\"水\",\"木\",\"金\",\"土\"))","v":""},null,null,null,null,null,{"$f":"IF(COUNTIFS($G8,\"<>\",$D8,\"<>\",$H8,\"<>\"),$G8-$D8-$H8,\"\")","v":""},null,null,null,null,null,null,null,{"$f":"IF($A8=\"\",\"\",IF(CHOOSE(WEEKDAY($A8),0,1,1,1,1,1,0),IF(COUNTIF($H$49:$H$88,$A8),\"休日\",\"出\"),IF(COUNTIF($O$49:$O$88,$A8),\"出\",\"休日\")))","v":""},null,"月末",{"$f":"IF($T$7<>\"\",DATE(YEAR($T$7),MONTH($T$7)+1,DAY($T$7)-1),\"\")","v":""}]
[{"$f":"IF($T$7=\"\",\"\",$T$7+1)","v":""},null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,""]
[{"$f":"IF($T$7=\"\",\"\",$T$7+2)","v":""},null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,"",null,"・t7を元にA列の日付とその日付に該当する曜日をc列に表示する。"]
[{"$f":"IF($T$7=\"\",\"\",$T$7+3)","v":""},null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,"",null,"・A列は、t7が設定されていない場合は何も表示されない。"]
[{"$f":"IF($T$7=\"\",\"\",$T$7+4)","v":""},null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,"",null,"・A列は、＋１することで翌日を求める。"]
[{"$f":"IF($T$7=\"\",\"\",$T$7+5)","v":""},null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,"",null,"・c列は、A列が設定されていない場合は何も表示されない。"]
[{"$f":"IF($T$7=\"\",\"\",$T$7+6)","v":""},null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,"",null,"・２９日、３０日、３１日は表示されない場合があるので、A列の値がt8より大きな場合は表示させないことで対応する。"]
[{"$f":"IF($T$7=\"\",\"\",$T$7+7)","v":""},null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,""]
[{"$f":"IF($T$7=\"\",\"\",$T$7+8)","v":""},null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,"",null,"・その年の休日（祝祭日や行事等）設定を作る。h列に日付として保存する。"]
[{"$f":"IF($T$7=\"\",\"\",$T$7+9)","v":""},null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,"",null,"・その年の平日（臨時出勤日や行事等）設定を作る。O列に日付として保存する。"]
[{"$f":"IF($T$7=\"\",\"\",$T$7+10)","v":""},null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,"",null,"・平日設定に該当せず、休日設定に該当する日を休日とする。"]
[{"$f":"IF($T$7=\"\",\"\",$T$7+11)","v":""},null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,"",null,"・平日設定に該当せず、土曜、日曜を休日とする。"]
[{"$f":"IF($T$7=\"\",\"\",$T$7+12)","v":""},null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,"",null,"・q列に”出”、”休日”を表示することで判断をする。"]
[{"$f":"IF($T$7=\"\",\"\",$T$7+13)","v":""},null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,"",null,"・条件付き書式によりR列が”休日”の場合、休日色とする。"]
[{"$f":"IF($T$7=\"\",\"\",$T$7+14)","v":""},null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,""]
[{"$f":"IF($T$7=\"\",\"\",$T$7+15)","v":""},null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,"",null,"・『始業時刻』、『終業時刻』、『休憩時刻』に時刻以外の数字や文字が入力されないように入力規則を設定する。"]
[{"$f":"IF($T$7=\"\",\"\",$T$7+16)","v":""},null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,""]
[{"$f":"IF($T$7=\"\",\"\",$T$7+17)","v":""},null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,""]
[{"$f":"IF($T$7=\"\",\"\",$T$7+18)","v":""},null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,""]
[{"$f":"IF($T$7=\"\",\"\",$T$7+19)","v":""},null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,""]
[{"$f":"IF($T$7=\"\",\"\",$T$7+20)","v":""},null,"",null,null,null,null,null,{"$f":"IF(COUNTIFS($G28,\"<>\",$D28,\"<>\",$H28,\"<>\"),$G28-$D28-$H28,\"\")","v":""},null,null,null,null,null,null,null,""]
[{"$f":"IF($T$7=\"\",\"\",$T$7+21)","v":""},null,"",null,null,null,null,null,{"$f":"IF(COUNTIFS($G29,\"<>\",$D29,\"<>\",$H29,\"<>\"),$G29-$D29-$H29,\"\")","v":""},null,null,null,null,null,null,null,""]
[{"$f":"IF($T$7=\"\",\"\",$T$7+22)","v":""},null,"",null,null,null,null,null,{"$f":"IF(COUNTIFS($G30,\"<>\",$D30,\"<>\",$H30,\"<>\"),$G30-$D30-$H30,\"\")","v":""},null,null,null,null,null,null,null,""]
[{"$f":"IF($T$7=\"\",\"\",$T$7+23)","v":""},null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,""]
[{"$f":"IF($T$7=\"\",\"\",$T$7+24)","v":""},null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,""]
[{"$f":"IF($T$7=\"\",\"\",$T$7+25)","v":""},null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,""]
[{"$f":"IF($T$7=\"\",\"\",$T$7+26)","v":""},null,"",null,null,null,null,null,{"$f":"IF(COUNTIFS($G34,\"<>\",$D34,\"<>\",$H34,\"<>\"),$G34-$D34-$H34,\"\")","v":""},null,null,null,null,null,null,null,""]
[{"$f":"IF($T$7=\"\",\"\",$T$7+27)","v":""},null,"",null,null,null,null,null,{"$f":"IF(COUNTIFS($G35,\"<>\",$D35,\"<>\",$H35,\"<>\"),$G35-$D35-$H35,\"\")","v":""},null,null,null,null,null,null,null,""]
[{"$f":"IF($T$7=\"\",\"\",IF($T$7+28>$T$8,\"\",$T$7+28))","v":""},null,{"$f":"IF($T$7=\"\",\"\",IF($A36=\"\",\"\",CHOOSE(WEEKDAY($A36),\"日\",\"月\",\"火\",\"水\",\"木\",\"金\",\"土\")))","v":""},null,null,null,null,null,{"$f":"IF(COUNTIFS($G36,\"<>\",$D36,\"<>\",$H36,\"<>\"),$G36-$D36-$H36,\"\")","v":""},null,null,null,null,null,null,null,""]
[{"$f":"IF($T$7=\"\",\"\",IF($T$7+29>$T$8,\"\",$T$7+29))","v":""},null,{"$f":"IF($T$7=\"\",\"\",IF($A37=\"\",\"\",CHOOSE(WEEKDAY($A37),\"日\",\"月\",\"火\",\"水\",\"木\",\"金\",\"土\")))","v":""},null,null,null,null,null,"",null,null,null,null,null,null,null,""]
[{"$f":"IF($T$7=\"\",\"\",IF($T$7+30>$T$8,\"\",$T$7+30))","v":""},null,{"$f":"IF($T$7=\"\",\"\",IF($A38=\"\",\"\",CHOOSE(WEEKDAY($A38),\"日\",\"月\",\"火\",\"水\",\"木\",\"金\",\"土\")))","v":""},null,null,null,null,null,"",null,null,null,null,null,null,null,""]
[]
["備考"]
[]
[]
[]
[]
[]
[]
["休日設定（最大４０個指定可能）",null,null,null,null,null,null,null,"平日設定（最大４０個指定可能）"]
["No",null,"月","日","内容",null,null,null,"No","月","日","内容"]
[1,null,1,1,"元日",null,null,{"$f":"IF($C49=\"\",\"\",IF($D49=\"\",\"\",DATE($B$2,$C49,$D49)))","v":"1900-01-01"},1,1,18,"土曜出勤",null,null,{"$f":"IF($J49=\"\",\"\",IF($K49=\"\",\"\",DATE($B$2,$J49,$K49)))","v":"1900-01-18"}]
[2,null,1,13,"成人の日",null,null,"1900-01-13",2,2,15,"土曜出勤",null,null,"1900-02-15"]
[3,null,2,11,"建国記念の日",null,null,"1900-02-11",3,2,29,"土曜出勤",null,null,60]
[4,null,2,23,"天皇誕生日",null,null,"1900-02-23",4,5,2,"土曜出勤",null,null,"1900-05-02"]
[5,null,3,20,"春分の日",null,null,"1900-03-20",5,5,9,"土曜出勤",null,null,"1900-05-09"]
[6,null,4,29,"昭和の日",null,null,"1900-04-29",6,null,null,"土曜出勤",null,null,""]
[7,null,5,3,"憲法記念日",null,null,"1900-05-03",7,9,26,"土曜出勤",null,null,"1900-09-26"]
[8,null,5,4,"みどりの日",null,null,"1900-05-04",8,11,7,"土曜出勤",null,null,"1900-11-07"]
[9,null,5,5,"こどもの日",null,null,"1900-05-05",9,11,28,"土曜出勤",null,null,"1900-11-28"]
[10,null,7,23,"海の日",null,null,"1900-07-23",10,null,null,"土曜出勤",null,null,""]
[11,null,8,10,"山の日",null,null,"1900-08-10",11,null,null,"土曜出勤",null,null,""]
[12,null,9,21,"敬老の日",null,null,"1900-09-21",12,null,null,"土曜出勤",null,null,""]
[13,null,9,22,"秋分の日",null,null,"1900-09-22",13,null,null,null,null,null,""]
[14,null,7,24,"スポーツの日",null,null,"1900-07-24",14,null,null,"地域貢献",null,null,""]
[15,null,11,3,"文化の日",null,null,"1900-11-03",15,null,null,"地域貢献",null,null,""]
[16,null,11,23,"勤労感謝の日",null,null,"1900-11-23",16,null,null,"地域貢献",null,null,""]
[17,null,null,null,null,null,null,"",17,null,null,null,null,null,""]
[18,null,8,13,"夏季1",null,null,"1900-08-13",18,null,null,null,null,null,""]
[19,null,8,14,"夏季2",null,null,"1900-08-14",19,null,null,null,null,null,""]
[20,null,8,15,"夏季3",null,null,"1900-08-15",20,null,null,null,null,null,""]
[21,null,null,null,null,null,null,"",21,null,null,null,null,null,""]
[22,null,12,28,"年末年始1",null,null,"1900-12-28",22,null,null,null,null,null,""]
[23,null,12,29,"年末年始2",null,null,"1900-12-29",23,null,null,null,null,null,""]
[24,null,12,30,"年末年始3",null,null,"1900-12-30",24,null,null,null,null,null,""]
[25,null,12,31,"年末年始4",null,null,"1900-12-31",25,null,null,null,null,null,""]
[26,null,1,2,"年末年始5",null,null,"1900-01-02",26,null,null,null,null,null,""]
[27,null,1,3,"年末年始6",null,null,"1900-01-03",27,null,null,null,null,null,""]
[28,null,null,null,null,null,null,"",28,null,null,null,null,null,""]
[29,null,null,null,"創立記念日",null,null,"",29,null,null,null,null,null,""]
[30,null,null,null,null,null,null,"",30,null,null,null,null,null,""]
[31,null,2,24,"振替休日",null,null,"1900-02-24",31,null,null,null,null,null,""]
[32,null,5,6,"振替休日",null,null,"1900-05-06",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,"（月と日が設定されていない場合は使用不可とする"]