{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["説明","11月"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":39,"n_cols":45,"rows_kept":39,"cut":false,"hidden":false,"merged":[[38,9,38,10],[34,9,34,10],[35,9,35,10],[36,9,36,10],[37,9,37,10],[21,1,21,10],[1,2,1,8],[14,1,14,10],[15,1,15,10],[16,1,16,10],[17,1,18,10],[19,1,20,10],[33,2,33,8],[26,1,27,10],[22,1,22,10],[23,1,23,10],[28,1,29,10],[30,1,31,10],[33,9,33,10]]}
[]
[null,"アルファベット","勤務時間",null,null,null,null,null,null,"最低人員数","最大人員数",null,null,"10月",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31]
[null,"A",7,":",0,"～",16,":",0,2,2,null,1]
[null,"B",7,":",30,"～",16,":",30,1,1,null,2]
[null,"C",8,":",0,"～",17,":",0,1,1,null,3]
[null,"D",8,":",30,"～",17,":",30,2,2,null,4]
[null,"E",8,":",45,"～",17,":",45,1,2,null,5]
[null,"F",9,":",0,"～",18,":",0,1,2,null,6]
[null,"G",10,":",0,"～",19,":",0,2,2,null,7]
[null,null,null,null,null,null,null,null,null,null,null,null,8]
[null,null,null,null,null,null,null,null,null,null,null,null,9]
[null,null,null,null,null,null,null,null,null,null,null,null,10]
[null,null,null,null,null,null,null,null,null,null,null,null,11]
[null,"＜使い方・説明＞",null,null,null,null,null,null,null,null,null,null,12]
[null,"①画面下にある「＋」マーク（新しいシート）をクリック。",null,null,null,null,null,null,null,null,null,null,13]
[null,"②画面上にある「表示」→「マクロ」→「マクロの表示」と、順番にクリック。",null,null,null,null,null,null,null,null,null,null,14]
[null,"③「シフト表生成」を選択して、実行をクリック。→入力を求められるので、そのまま入力。",null,null,null,null,null,null,null,null,null,null,15]
[null,"※もし、誤った文字や値を入力してエラーになった際は、一度「終了」をクリックして、\n    再度、②を行なって下さい。"]
[]
[null,"④シフト表内に休みや研修等、通常のシフトとは異なる場合に、「休」や「研」などの文字や\n　記号をシフト表内に入力して下さい。"]
[]
[null,"⑤「更新」ボタンをクリック。→微調整して完成！！"]
[null,"※保存する際は、必ず「Excelマクロ有効ブック」を選択して保存して下さい。"]
[null,"※注意！！休園日・行事日のセルの色については、「更新」するまでは変更しないで下さい。"]
[]
[null,"＜応用編＞",null,null,null,null,null,null,null,null,null,null,null,"固定・変則勤務者"]
[null,"※シフトの自動割り当ては、各アルファベットが番号付きの職員全員を対象に、全て均等に近い形\n　で割り当てられるので、固定勤務者や変則勤務者とは分けて作成するようにします。"]
[]
[null,"例）コピー元のシートに、あらかじめ固定勤務者や変則勤務者の勤務時間表やシフト表を作成\n　　します。⑤まで作成した後で、コピーして貼り付けます。"]
[]
[null,"　　もし、通常勤務者のシフト表内に入れる場合は、該当する勤務者のセルを「切り取り」→\n　　「切り取ったセルの挿入」で組み入れるようにして下さい。"]
[]
[]
[null,"固定・変則勤務者","勤務時間",null,null,null,null,null,null,"該当者"]
[null,"H",9,":",0,"～",17,":",0]
[null,"I",8,":",30,"～",16,":",30]
[null,"J",8,":",15,"～",17,":",15]
[null,"K",9,":",0,"～",16,":",0]
[null,"L",9,":",0,"～",13,":",30]

{"sheet":"11月","index":1,"n_rows":17,"n_cols":44,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,2,1,8]]}
[]
[null,"アルファベット","勤務時間",null,null,null,null,null,null,"最低人員数","最大人員数",null,null,"11月",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30]
[null,"A",7,":",0,"～",16,":",0,2,2,null,1]
[null,"B",7,":",30,"～",16,":",30,1,1,null,2]
[null,"C",8,":",0,"～",17,":",0,1,1,null,3]
[null,"D",8,":",30,"～",17,":",30,2,2,null,4]
[null,"E",8,":",45,"～",17,":",45,1,2,null,5]
[null,"F",9,":",0,"～",18,":",0,1,2,null,6]
[null,"G",9,":",0,"～",19,":",0,2,2,null,7]
[null,null,null,null,null,null,null,null,null,null,null,null,8]
[null,null,null,null,null,null,null,null,null,null,null,null,9]
[null,null,null,null,null,null,null,null,null,null,null,null,10]
[null,null,null,null,null,null,null,null,null,null,null,null,11]
[null,null,null,null,null,null,null,null,null,null,null,null,12]
[null,null,null,null,null,null,null,null,null,null,null,null,13]
[null,null,null,null,null,null,null,null,null,null,null,null,14]
[null,null,null,null,null,null,null,null,null,null,null,null,15]