{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["使い方・説明","11月","Sheet1"],"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":18,"n_cols":2,"rows_kept":18,"cut":false,"hidden":false,"merged":[[6,1,6,16],[0,0,0,16],[2,0,2,16],[3,1,3,16],[4,1,4,16],[5,1,5,16],[15,1,15,16],[16,1,16,16],[17,1,17,16],[7,1,7,16],[8,1,8,16],[10,0,10,16],[11,1,11,16],[12,1,12,16],[14,0,14,16]]}
["シフト表作成ツール　使い方・説明"]
[]
["< 使い方・説明 >"]
["①","画面下「表示」→「マクロ」→「新しいシート」をクリック。"]
["②","画面上「表示」→「マクロ」→「マクロの表示」と順にクリック。"]
["③","「シフト表生成」を選択→実行をクリック→入力を求められるので入力。"]
[null,"※誤入力でエラーの際は「終了」をクリックし、②から再実行。"]
["④","休みや研修等は「休」「研」などをシフト表に直接入力。"]
["⑤","「更新」ボタンをクリック→微調整して完成!!"]
[]
["【 重要 】"]
[null,"※保存時は必ず「Excelマクロ有効ブック」を選択。"]
[null,"※休園日・行事日のセルの色は「更新」するまで変更しない。"]
[]
["< 応用編 >"]
["※","シフト自動割り当ては各パターンが均等に割り当てられます。"]
[null,"コピー元シートに固定・変則勤務者情報を作成→③後にコピー&貼付け。"]
[null,"通常勤務者表に組入れる場合は「切り取り」→「切取セルの挿入」。"]

{"sheet":"11月","index":1,"n_rows":32,"n_cols":44,"rows_kept":32,"cut":false,"hidden":false,"merged":[[1,2,1,8],[17,2,17,8]]}
[null,null,null,null,null,null,null,null,null,null,null,null,"11月"]
[null,"アルファベット","勤務時間",null,null,null,null,null,null,"最低人員数","最大人員数",null,"職員番号","職員名",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",null,":",null,"～",null,":",null,2,2,null,1]
[null,"B",null,":",null,"～",null,":",null,2,8,null,2]
[null,"C",null,":",null,"～",null,":",null,1,9,null,3]
[null,"D",null,":",null,"～",null,":",null,2,2,null,4]
[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,6]
[null,null,null,null,null,null,null,null,null,null,null,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,"H",null,":",null,"～",null,":"]
[null,"I",null,":",null,"～",null,":"]
[null,"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,"職員番号","職員名",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,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,null,null,null,null,null,null,null,null,null,null,4]
[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,6]
[null,null,null,null,null,null,null,null,null,null,null,null,7]
[null,null,null,null,null,null,null,null,null,null,null,null,8]

{"sheet":"Sheet1","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}