{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["使い方","シフト表作成","印刷用","使用例"],"not_rendered":{"charts":0,"images":6,"macros":1,"external_links":0,"defined_names":3,"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":37,"n_cols":2,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
["使い方（「使用例」シートをご参照ください。）"]
["設定"]
["・シフトパターン（A～Jの最大10パターン）ごとの始業・終業時刻と休憩時間を設定します。"]
["・勤務シフト表を作成する期間（1カ月）の開始日を設定します。"]
["・時間帯表の開始時刻を設定します。シフトパターンのうち最も早い始業時刻以下の時刻で設定してください。"]
[]
["時間帯別勤務人数の集計"]
["・各従業員の勤務日にシフトパターン（A～J）を入力します。"]
["・「集計」ボタンを押すと、時間帯（15分単位）ごとの配置人数が集計されますので、配置人数に問題がないか確認してください。"]
["・1人の従業員が同じ時間帯に重複して配置されている場合は、シフトと時間帯別人数が赤字で表示されます。"]
["　（例：A（22:00～30:00（翌6時））の翌日にB（5:00～13:00）のシフトが入力されている場合、5:00～6:00の配置人数が正しく集計されません。）"]
[]
["シフト表の印刷"]
["・「印刷用シートに出力」ボタンを押すと、作成した勤務シフト表を「印刷用」シートに出力します。適宜加工して掲示用や配付用としてご利用ください。"]
[]
["注意事項"]
["・シート保護などは行っておりません。必要に応じて加工してご利用ください。（加工後を含め当ツールの再配布や公開は禁止します。）"]
["・当ツールの利用により発生したトラブル・損失・損害については、一切責任を負いません。ご利用にあたっては自己責任でお願いします。"]
[]
["作成・配付"]
["社会保険労務士事務所しのはら労働コンサルタント"]
["社会保険労務士　篠原宏治"]
["〒168-0062　東京都杉並区方南1-2-10-1F"]
["TEL","03-6300-4323"]
["FAX","03-6300-4324"]
["メール","mail@shlc.jp"]
["事務所HP","https://www.shlc.jp/"]
["社労士Tools","https://tool.shlc.jp/"]
[]
["元労働基準監督官による労務相談とエクセル業務効率化に強い社労士事務所です。"]
["労務相談、社会保険・労働保険手続き、給与計算のご依頼を随時受け付けております。"]
["エクセルファイル、エクセルマクロの作成・加工も承ります。"]
["お気軽にお問い合わせください。"]
[]
["改訂履歴"]
["ver1.00","公開"]
["ver1.01","一部の曜日が誤って表示されていたものを修正"]

{"sheet":"シフト表作成","index":1,"n_rows":118,"n_cols":48,"rows_kept":118,"cut":false,"hidden":false,"merged":[[19,0,20,2],[19,3,20,5],[32,42,33,45],[32,41,33,41],[21,0,22,2],[23,0,24,2],[21,3,22,5],[23,3,24,5],[26,40,27,40],[13,0,13,1],[16,0,16,2],[17,0,17,2],[117,7,120,7],[14,0,14,2],[97,7,100,7],[101,7,104,7],[105,7,108,7],[109,7,112,7],[113,7,116,7],[77,7,80,7],[81,7,84,7],[85,7,88,7],[89,7,92,7],[93,7,96,7],[57,7,60,7],[61,7,64,7],[65,7,68,7],[69,7,72,7],[73,7,76,7],[37,7,40,7],[41,7,44,7],[45,7,48,7],[49,7,52,7],[53,7,56,7],[1,47,2,47],[25,7,28,7],[29,7,32,7],[33,7,36,7],[1,39,2,39],[29,40,30,40],[29,41,30,41],[32,40,33,40],[26,41,27,41],[26,42,27,45],[29,42,30,45]]}
["シフトパターン",null,null,null,null,null,null,"シフト表"]
["パターン","始業時刻","終業時刻","休憩開始","休憩終了","実働",null,"日付",{"$f":"A15","v":"2022-04-01"},{"$f":"IF(DAY(I2+1)=DAY($I$2),\"\",I2+1)","v":"2022-04-02"},"2022-04-03","2022-04-04","2022-04-05","2022-04-06","2022-04-07","2022-04-08","2022-04-09","2022-04-10","2022-04-11","2022-04-12","2022-04-13","2022-04-14","2022-04-15","2022-04-16","2022-04-17","2022-04-18","2022-04-19","2022-04-20","2022-04-21","2022-04-22","2022-04-23","2022-04-24","2022-04-25","2022-04-26","2022-04-27","2022-04-28",{"$f":"IF(AJ2=\"\",\"\",IF(DAY(AJ2+1)=DAY($I$2),\"\",AJ2+1))","v":"2022-04-29"},{"$f":"IF(AK2=\"\",\"\",IF(DAY(AK2+1)=DAY($I$2),\"\",AK2+1))","v":"2022-04-30"},{"$f":"IF(AL2=\"\",\"\",IF(DAY(AL2+1)=DAY($I$2),\"\",AL2+1))","v":""},"実働\n時間数","勤務日数",null,null,null,null,null,"未入力","日数合計"]
["A",null,null,null,null,{"$f":"MAX(0,C3-B3-(E3-D3))","v":0},null,"氏名",{"$f":"I2","v":44652},{"$f":"J2","v":44653},44654,44655,44656,44657,44658,44659,44660,44661,44662,44663,44664,44665,{"$f":"W2","v":44666},44667,44668,44669,44670,44671,44672,44673,44674,44675,44676,44677,44678,44679,44680,44681,"",null,"A～J",null,null,null,null,null,"空白"]
["B",null,null,null,null,{"$f":"MAX(0,C4-B4-(E4-D4))","v":0},null,null,null,null,null,null,null,null,null,null,null,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($H4=\"\",\"\",COUNTIF($I4:$AM4,AP$3))","v":""},{"$f":"IF($H4=\"\",\"\",COUNTIF($I4:$AM4,AQ$3))","v":""},"","","",{"$f":"IF(H4=\"\",\"\",COUNTBLANK(I4:AM4)-COUNTBLANK($I$2:$AM$2))","v":""},24.5]
["C",null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,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(H5=\"\",\"\",COUNTBLANK(I5:AM5)-COUNTBLANK($I$2:$AM$2))","v":""},{"$f":"IF(H5=\"\",\"\",SUM(AO5:AU5))","v":""}]
["D",null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,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($H6=\"\",\"\",COUNTIF($I6:$AM6,AP$3))","v":""},"","","","","",""]
["E",null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,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($H7=\"\",\"\",COUNTIF($I7:$AM7,AP$3))","v":""},"","","","","",""]
["F",null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","",""]
["G",null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","",""]
["H",null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","",""]
["I",null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","",""]
["J",null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","",""]
["期間開始日",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","",""]
["2022-04-01",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","",""]
["時間帯表開始時刻",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","",""]
[5,null,null,"（0～23で入力）",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","",""]
[null,null,null,"シフト表をクリアします。",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","",""]
[null,null,null,"勤務時間数や時間帯別人数を集計します。",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","",""]
[null,null,null,"印刷用シートに出力します。",null,null,null,"日別人数",null,null,null,null,null,null,null,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":"SUM(AN4:AN23)","v":0},{"$f":"SUM(AO4:AO23)","v":0},{"$f":"SUM(AP4:AP23)","v":0},0,0,0,0,0,24.5]
[null,null,null,null,null,null,null,"時間帯別人数"]
[null,null,null,null,null,null,null,{"$f":"A18","v":5}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"MOD(H26+1,24)","v":6},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"計算式設定済みのセル（修正不可）"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"MOD(H30+1,24)","v":7}]
[]
[]
[]
[null,null,null,null,null,null,null,{"$f":"MOD(H34+1,24)","v":8}]
[]
[]
[]
[null,null,null,null,null,null,null,{"$f":"MOD(H38+1,24)","v":9}]
[]
[]
[]
[null,null,null,null,null,null,null,{"$f":"MOD(H42+1,24)","v":10}]
[]
[]
[]
[null,null,null,null,null,null,null,{"$f":"MOD(H46+1,24)","v":11}]
[]
[]
[]
[null,null,null,null,null,null,null,{"$f":"MOD(H50+1,24)","v":12}]
[]
[]
[]
[null,null,null,null,null,null,null,{"$f":"MOD(H54+1,24)","v":13}]
[]
[]
[]
[null,null,null,null,null,null,null,{"$f":"MOD(H58+1,24)","v":14}]
[]
[]
[]
[null,null,null,null,null,null,null,{"$f":"MOD(H62+1,24)","v":15}]
[]
[]
[]
[null,null,null,null,null,null,null,{"$f":"MOD(H66+1,24)","v":16}]
[]
[]
[]
[null,null,null,null,null,null,null,{"$f":"MOD(H70+1,24)","v":17}]
[]
[]
[]
[null,null,null,null,null,null,null,{"$f":"MOD(H74+1,24)","v":18}]
[]
[]
[]
[null,null,null,null,null,null,null,{"$f":"MOD(H78+1,24)","v":19}]
[]
[]
[]
[null,null,null,null,null,null,null,{"$f":"MOD(H82+1,24)","v":20}]
[]
[]
[]
[null,null,null,null,null,null,null,{"$f":"MOD(H86+1,24)","v":21}]
[]
[]
[]
[null,null,null,null,null,null,null,{"$f":"MOD(H90+1,24)","v":22}]
[]
[]
[]
[null,null,null,null,null,null,null,{"$f":"MOD(H94+1,24)","v":23}]
[]
[]
[]
[null,null,null,null,null,null,null,{"$f":"MOD(H98+1,24)","v":0}]
[]
[]
[]
[null,null,null,null,null,null,null,{"$f":"MOD(H102+1,24)","v":1}]
[]
[]
[]
[null,null,null,null,null,null,null,{"$f":"MOD(H106+1,24)","v":2}]
[]
[]
[]
[null,null,null,null,null,null,null,{"$f":"MOD(H110+1,24)","v":3}]
[]
[]
[]
[null,null,null,null,null,null,null,{"$f":"MOD(H114+1,24)","v":4}]

{"sheet":"印刷用","index":2,"n_rows":38,"n_cols":41,"rows_kept":38,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,6,1,9],[2,32,3,32],[2,40,3,40]]}
["勤務シフト表"]
["期間：",null,null,null,null,"~"]
["日付","2022-04-01","2022-04-02","2022-04-03","2022-04-04","2022-04-05","2022-04-06","2022-04-07","2022-04-08","2022-04-09","2022-04-10","2022-04-11","2022-04-12","2022-04-13","2022-04-14","2022-04-15","2022-04-16","2022-04-17","2022-04-18","2022-04-19","2022-04-20","2022-04-21","2022-04-22","2022-04-23","2022-04-24","2022-04-25","2022-04-26","2022-04-27","2022-04-28","2022-04-29","2022-04-30",null,"実働\n時間数","勤務日数",null,null,null,null,null,"未入力","日数合計"]
["氏名",44652,44669,44654,44655,44656,44657,44658,44659,44660,44661,44662,44663,44664,44665,44666,44667,44668,44669,44670,44671,44672,44673,44674,44675,44676,44677,44678,44679,44680,44681,null,null,"A～J",null,null,null,null,null,"空白"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["日別人数"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"シフトパターン"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"パターン","始業時刻","終業時刻","休憩開始","休憩終了","時間数"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"A"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"B"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"C"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"D"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"E"]
[null,null,null,null,null,null,null,null,null,null,null,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"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"G"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"H"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"I"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"J"]

{"sheet":"使用例","index":3,"n_rows":118,"n_cols":48,"rows_kept":118,"cut":false,"hidden":false,"merged":[[109,7,112,7],[113,7,116,7],[117,7,120,7],[32,41,33,41],[85,7,88,7],[89,7,92,7],[93,7,96,7],[97,7,100,7],[101,7,104,7],[105,7,108,7],[61,7,64,7],[65,7,68,7],[69,7,72,7],[73,7,76,7],[77,7,80,7],[81,7,84,7],[57,7,60,7],[26,41,27,41],[26,42,27,45],[29,7,32,7],[29,40,30,40],[29,41,30,41],[29,42,30,45],[32,40,33,40],[32,42,33,45],[33,7,36,7],[26,40,27,40],[37,7,40,7],[41,7,44,7],[45,7,48,7],[49,7,52,7],[53,7,56,7],[25,7,28,7],[19,0,20,2],[19,3,20,5],[21,0,22,2],[21,3,22,5],[23,0,24,2],[23,3,24,5],[17,0,17,2],[1,39,2,39],[1,47,2,47],[13,0,13,1],[14,0,14,2],[16,0,16,2]]}
["シフトパターン",null,null,null,null,null,null,"シフト表"]
["パターン","始業時刻","終業時刻","休憩開始","休憩終了","実働",null,"日付",{"$f":"A15","v":"2022-07-15"},{"$f":"IF(DAY(I2+1)=DAY($I$2),\"\",I2+1)","v":"2022-07-16"},"2022-07-17","2022-07-18","2022-07-19","2022-07-20","2022-07-21","2022-07-22","2022-07-23","2022-07-24","2022-07-25","2022-07-26","2022-07-27","2022-07-28","2022-07-29","2022-07-30","2022-07-31","2022-08-01","2022-08-02","2022-08-03","2022-08-04","2022-08-05","2022-08-06","2022-08-07","2022-08-08","2022-08-09","2022-08-10","2022-08-11",{"$f":"IF(AJ2=\"\",\"\",IF(DAY(AJ2+1)=DAY($I$2),\"\",AJ2+1))","v":"2022-08-12"},{"$f":"IF(AK2=\"\",\"\",IF(DAY(AK2+1)=DAY($I$2),\"\",AK2+1))","v":"2022-08-13"},{"$f":"IF(AL2=\"\",\"\",IF(DAY(AL2+1)=DAY($I$2),\"\",AL2+1))","v":"2022-08-14"},"実働\n時間数","勤務日数","休日","有給",null,null,null,"未入力","日数合計"]
["A",0.33333333333333331,0.70833333333333337,0.5,0.54166666666666663,{"$f":"MAX(0,C3-B3-(E3-D3))","v":0.33333333333333343},null,"氏名",{"$f":"I2","v":44757},44669,{"$f":"K2","v":44759},44760,44761,44762,44763,44764,44765,44766,44767,44768,44769,44770,44771,44772,44773,44774,44775,44776,44777,44778,44779,44780,44781,44782,44783,44784,44785,44786,44787,null,"A～J","休","有",null,null,null,"空白"]
["B",0.33333333333333331,0.54166666666666663,null,null,{"$f":"MAX(0,C4-B4-(E4-D4))","v":0.20833333333333331},null,"山田","A","A","A","A","A","休","休","A","A","有","A","A","休","休","A","A","A","A","A","休","休","A","有","A","A","A","休","休","A","A","A",6.9999999999999982,21,{"$f":"IF($H4=\"\",\"\",COUNTIF($I4:$AM4,AP$3))","v":8},2,0,0,0,{"$f":"IF(H4=\"\",\"\",COUNTBLANK(I4:AM4)-COUNTBLANK($I$2:$AM$2))","v":0},{"$f":"IF(H4=\"\",\"\",SUM(AO4:AU4))","v":31}]
["C",0.5,0.70833333333333337,null,null,0.20833333333333337,null,"高橋","A","A","休","休","A","A","A","A","A","休","休","A","A","A","有","A","休","休","A","A","A","A","A","休","休","A","A","A","A","A","休",6.9999999999999982,21,9,1,0,0,0,{"$f":"IF(H5=\"\",\"\",COUNTBLANK(I5:AM5)-COUNTBLANK($I$2:$AM$2))","v":0},31]
["D",0.41666666666666669,0.625,0.54166666666666663,0.61458333333333337,0.13541666666666657,null,"田中",null,null,"B","B",null,"B","B",null,null,null,null,null,"B","B","B",null,"C",null,null,"B","B",null,null,"C","C",null,"B","B",null,null,null,2.916666666666667,14,{"$f":"IF($H6=\"\",\"\",COUNTIF($I6:$AM6,AP$3))","v":0},0,0,0,0,17,31]
["E",0.91666666666666663,1.1666666666666667,0.95833333333333337,1,0.20833333333333348,null,"太田",null,null,null,"C",null,null,null,null,null,"C",null,null,null,null,"C",null,null,"B",null,null,null,null,"B",null,null,"C",null,null,null,"C",null,1.4583333333333335,7,{"$f":"IF($H7=\"\",\"\",COUNTIF($I7:$AM7,AP$3))","v":0},0,0,0,0,24,31]
["F",null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","",""]
["G",null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","",""]
["H",null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","",""]
["I",null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","",""]
["J",null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","",""]
["期間開始日",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","",""]
["2022-07-15",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","",""]
["時間帯表開始時刻",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","",""]
[5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","",""]
[null,null,null,"シフト表をクリアします。",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","",""]
[null,null,null,"勤務時間数や時間帯別人数を集計します。",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","",""]
[null,null,null,"印刷用シートに出力します。",null,null,null,"日別人数",2,2,2,3,2,2,2,2,2,1,1,2,2,2,3,2,2,2,2,2,2,2,2,2,2,3,2,2,2,3,1,{"$f":"SUM(AN4:AN23)","v":18.374999999999996},{"$f":"SUM(AO4:AO23)","v":63},{"$f":"SUM(AP4:AP23)","v":17},3,0,0,0,41,124]
[null,null,null,null,null,null,null,"時間帯別人数"]
[null,null,null,null,null,null,null,{"$f":"A18","v":5}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"MOD(H26+1,24)","v":6},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"計算式設定済みのセル（修正不可）"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"MOD(H30+1,24)","v":7}]
[]
[]
[]
[null,null,null,null,null,null,null,{"$f":"MOD(H34+1,24)","v":8},2,2,2,2,2,2,2,2,2,null,1,2,2,2,2,2,1,2,2,2,2,2,2,1,1,2,2,2,2,2,1]
[null,null,null,null,null,null,null,null,2,2,2,2,2,2,2,2,2,null,1,2,2,2,2,2,1,2,2,2,2,2,2,1,1,2,2,2,2,2,1]
[null,null,null,null,null,null,null,null,2,2,2,2,2,2,2,2,2,null,1,2,2,2,2,2,1,2,2,2,2,2,2,1,1,2,2,2,2,2,1]
[null,null,null,null,null,null,null,null,2,2,2,2,2,2,2,2,2,null,1,2,2,2,2,2,1,2,2,2,2,2,2,1,1,2,2,2,2,2,1]
[null,null,null,null,null,null,null,{"$f":"MOD(H38+1,24)","v":9},2,2,2,2,2,2,2,2,2,null,1,2,2,2,2,2,1,2,2,2,2,2,2,1,1,2,2,2,2,2,1]
[null,null,null,null,null,null,null,null,2,2,2,2,2,2,2,2,2,null,1,2,2,2,2,2,1,2,2,2,2,2,2,1,1,2,2,2,2,2,1]
[null,null,null,null,null,null,null,null,2,2,2,2,2,2,2,2,2,null,1,2,2,2,2,2,1,2,2,2,2,2,2,1,1,2,2,2,2,2,1]
[null,null,null,null,null,null,null,null,2,2,2,2,2,2,2,2,2,null,1,2,2,2,2,2,1,2,2,2,2,2,2,1,1,2,2,2,2,2,1]
[null,null,null,null,null,null,null,{"$f":"MOD(H42+1,24)","v":10},2,2,2,2,2,2,2,2,2,null,1,2,2,2,2,2,1,2,2,2,2,2,2,1,1,2,2,2,2,2,1]
[null,null,null,null,null,null,null,null,2,2,2,2,2,2,2,2,2,null,1,2,2,2,2,2,1,2,2,2,2,2,2,1,1,2,2,2,2,2,1]
[null,null,null,null,null,null,null,null,2,2,2,2,2,2,2,2,2,null,1,2,2,2,2,2,1,2,2,2,2,2,2,1,1,2,2,2,2,2,1]
[null,null,null,null,null,null,null,null,2,2,2,2,2,2,2,2,2,null,1,2,2,2,2,2,1,2,2,2,2,2,2,1,1,2,2,2,2,2,1]
[null,null,null,null,null,null,null,{"$f":"MOD(H46+1,24)","v":11},2,2,2,2,2,2,2,2,2,null,1,2,2,2,2,2,1,2,2,2,2,2,2,1,1,2,2,2,2,2,1]
[null,null,null,null,null,null,null,null,2,2,2,2,2,2,2,2,2,null,1,2,2,2,2,2,1,2,2,2,2,2,2,1,1,2,2,2,2,2,1]
[null,null,null,null,null,null,null,null,2,2,2,2,2,2,2,2,2,null,1,2,2,2,2,2,1,2,2,2,2,2,2,1,1,2,2,2,2,2,1]
[null,null,null,null,null,null,null,null,2,2,2,2,2,2,2,2,2,null,1,2,2,2,2,2,1,2,2,2,2,2,2,1,1,2,2,2,2,2,1]
[null,null,null,null,null,null,null,{"$f":"MOD(H50+1,24)","v":12},2,2,2,3,2,2,2,2,2,1,1,2,2,2,3,2,2,2,2,2,2,2,2,2,2,3,2,2,2,3,1]
[null,null,null,null,null,null,null,null,2,2,2,3,2,2,2,2,2,1,1,2,2,2,3,2,2,2,2,2,2,2,2,2,2,3,2,2,2,3,1]
[null,null,null,null,null,null,null,null,2,2,2,3,2,2,2,2,2,1,1,2,2,2,3,2,2,2,2,2,2,2,2,2,2,3,2,2,2,3,1]
[null,null,null,null,null,null,null,null,2,2,2,3,2,2,2,2,2,1,1,2,2,2,3,2,2,2,2,2,2,2,2,2,2,3,2,2,2,3,1]
[null,null,null,null,null,null,null,{"$f":"MOD(H54+1,24)","v":13},2,2,1,2,2,1,1,2,2,1,1,2,1,1,2,2,2,1,2,1,1,2,1,2,2,3,1,1,2,3,1]
[null,null,null,null,null,null,null,null,2,2,1,2,2,1,1,2,2,1,1,2,1,1,2,2,2,1,2,1,1,2,1,2,2,3,1,1,2,3,1]
[null,null,null,null,null,null,null,null,2,2,1,2,2,1,1,2,2,1,1,2,1,1,2,2,2,1,2,1,1,2,1,2,2,3,1,1,2,3,1]
[null,null,null,null,null,null,null,null,2,2,1,2,2,1,1,2,2,1,1,2,1,1,2,2,2,1,2,1,1,2,1,2,2,3,1,1,2,3,1]
[null,null,null,null,null,null,null,{"$f":"MOD(H58+1,24)","v":14},2,2,1,2,2,1,1,2,2,1,1,2,1,1,2,2,2,1,2,1,1,2,1,2,2,3,1,1,2,3,1]
[null,null,null,null,null,null,null,null,2,2,1,2,2,1,1,2,2,1,1,2,1,1,2,2,2,1,2,1,1,2,1,2,2,3,1,1,2,3,1]
[null,null,null,null,null,null,null,null,2,2,1,2,2,1,1,2,2,1,1,2,1,1,2,2,2,1,2,1,1,2,1,2,2,3,1,1,2,3,1]
[null,null,null,null,null,null,null,null,2,2,1,2,2,1,1,2,2,1,1,2,1,1,2,2,2,1,2,1,1,2,1,2,2,3,1,1,2,3,1]
[null,null,null,null,null,null,null,{"$f":"MOD(H62+1,24)","v":15},2,2,1,2,2,1,1,2,2,1,1,2,1,1,2,2,2,1,2,1,1,2,1,2,2,3,1,1,2,3,1]
[null,null,null,null,null,null,null,null,2,2,1,2,2,1,1,2,2,1,1,2,1,1,2,2,2,1,2,1,1,2,1,2,2,3,1,1,2,3,1]
[null,null,null,null,null,null,null,null,2,2,1,2,2,1,1,2,2,1,1,2,1,1,2,2,2,1,2,1,1,2,1,2,2,3,1,1,2,3,1]
[null,null,null,null,null,null,null,null,2,2,1,2,2,1,1,2,2,1,1,2,1,1,2,2,2,1,2,1,1,2,1,2,2,3,1,1,2,3,1]
[null,null,null,null,null,null,null,{"$f":"MOD(H66+1,24)","v":16},2,2,1,2,2,1,1,2,2,1,1,2,1,1,2,2,2,1,2,1,1,2,1,2,2,3,1,1,2,3,1]
[null,null,null,null,null,null,null,null,2,2,1,2,2,1,1,2,2,1,1,2,1,1,2,2,2,1,2,1,1,2,1,2,2,3,1,1,2,3,1]
[null,null,null,null,null,null,null,null,2,2,1,2,2,1,1,2,2,1,1,2,1,1,2,2,2,1,2,1,1,2,1,2,2,3,1,1,2,3,1]
[null,null,null,null,null,null,null,null,2,2,1,2,2,1,1,2,2,1,1,2,1,1,2,2,2,1,2,1,1,2,1,2,2,3,1,1,2,3,1]
[null,null,null,null,null,null,null,{"$f":"MOD(H70+1,24)","v":17}]
[]
[]
[]
[null,null,null,null,null,null,null,{"$f":"MOD(H74+1,24)","v":18}]
[]
[]
[]
[null,null,null,null,null,null,null,{"$f":"MOD(H78+1,24)","v":19}]
[]
[]
[]
[null,null,null,null,null,null,null,{"$f":"MOD(H82+1,24)","v":20}]
[]
[]
[]
[null,null,null,null,null,null,null,{"$f":"MOD(H86+1,24)","v":21}]
[]
[]
[]
[null,null,null,null,null,null,null,{"$f":"MOD(H90+1,24)","v":22}]
[]
[]
[]
[null,null,null,null,null,null,null,{"$f":"MOD(H94+1,24)","v":23}]
[]
[]
[]
[null,null,null,null,null,null,null,{"$f":"MOD(H98+1,24)","v":0}]
[]
[]
[]
[null,null,null,null,null,null,null,{"$f":"MOD(H102+1,24)","v":1}]
[]
[]
[]
[null,null,null,null,null,null,null,{"$f":"MOD(H106+1,24)","v":2}]
[]
[]
[]
[null,null,null,null,null,null,null,{"$f":"MOD(H110+1,24)","v":3}]
[]
[]
[]
[null,null,null,null,null,null,null,{"$f":"MOD(H114+1,24)","v":4}]