{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["説明","見本","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":23,"n_cols":2,"rows_kept":23,"cut":false,"hidden":false,"merged":[[11,1,11,10],[19,1,20,10],[22,1,23,10],[3,1,3,10],[4,1,4,10],[5,1,5,10],[6,1,7,10],[8,1,9,10],[10,1,10,10]]}
[]
[]
[null,"＜使い方・説明＞"]
[null,"①画面下にある「＋」マーク（新しいシート）をクリック。"]
[null,"②画面上にある「表示」→「マクロ」→「マクロの表示」と、順番にクリック。"]
[null,"③「職員配置スケジュール表」を選択して、実行をクリック。→入力を求められるので、そのまま入力。"]
[null,"※もし、誤った文字や値を入力してエラーになった際は、一度「終了」をクリックして、\n    再度、②を行なって下さい。"]
[]
[null,"④「勤務時間」に各アルファベットに対応する時間を、選択入力。「職員配置スケジュール表」にも、\n　アルファベットと職員名を入力。"]
[]
[null,"⑤「作成」ボタンをクリックすると、各アルファベットに対応した時間の帯が表示されて完成!!"]
[null,"※保存する際は、必ず「Excelマクロ有効ブック」を選択して保存して下さい。"]
[]
[]
[]
[]
[]
[]
[null,"＜応用編＞"]
[null,"※帯の色は、コード内のRGBの値を変更することで、変更することができます。または、一度作成した\n　後で、Excel内において通常の手順（帯を選択して色の変更）で変更することができます。"]
[]
[]
[null,"※帯の途中から色を変えたり、セルを結合して文字入力をしたりすることで、指定された職員が違う\n　場所に移動するなどの表現も可能です。"]

{"sheet":"見本","index":1,"n_rows":17,"n_cols":38,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,21,1,22],[1,2,1,8],[1,13,1,14],[1,15,1,16],[1,17,1,18],[1,19,1,20],[1,35,1,36],[1,37,1,38],[1,23,1,24],[1,25,1,26],[1,27,1,28],[1,29,1,30],[1,31,1,32],[1,33,1,34]]}
[]
[null,"アルファベット","勤務時間",null,null,null,null,null,null,null,"番号","アルファベット","職員名","07:00:00",null,"08:00:00",null,"09:00:00",null,"10:00:00",null,"11:00:00",null,"12:00:00",null,"13:00:00",null,"14:00:00",null,"15:00:00",null,"16:00:00",null,"17:00:00",null,"18:00:00",null,"19:00:00"]
[null,"A",7,":",0,"～",16,":",0,null,1,"A"]
[null,"B",7,":",30,"～",16,":",30,null,2,"A"]
[null,"C",8,":",0,"～",17,":",0,null,3,"B"]
[null,"D",8,":",30,"～",17,":",30,null,4,"B"]
[null,"E",9,":",0,"～",18,":",0,null,5,"C"]
[null,"F",10,":",0,"～",19,":",0,null,6,"C"]
[null,null,null,null,null,null,null,null,null,null,7,"C"]
[null,null,null,null,null,null,null,null,null,null,8,"C"]
[null,null,null,null,null,null,null,null,null,null,9,"D"]
[null,null,null,null,null,null,null,null,null,null,10,"D"]
[null,null,null,null,null,null,null,null,null,null,11,"D"]
[null,null,null,null,null,null,null,null,null,null,12,"E"]
[null,null,null,null,null,null,null,null,null,null,13,"E"]
[null,null,null,null,null,null,null,null,null,null,14,"F"]
[null,null,null,null,null,null,null,null,null,null,15,"F"]

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