{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["main","勤務表","勤務データ","tcsv","temp","メンバー登録","param","readme"],"not_rendered":{"charts":0,"images":15,"macros":1,"external_links":0,"defined_names":2,"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":"main","index":0,"n_rows":24,"n_cols":15,"rows_kept":24,"cut":false,"hidden":false,"merged":[[4,4,4,6],[5,4,5,6]]}
["勤務表作成",null,"（勤務シフト表作成）"]
[]
["作成する月度の設定",null,null,null,null,null,null,null,"月初"]
[null,null,null,null,null,null,null,null,"曜日コード"]
["年度",2021,"選択",null,"2021年12月1日",null,null,"月初",4]
["月度",12,"選択",null,"2021年12月31日",null,null,"月末"]
[]
[null,null,null,null,"月日数",31]
["稼働日"]
[null,null,null,null,"土曜日数",4]
[null,null,null,null,"日曜日数",4]
[null,null,null,null,"休日日数",0]
[]
[null,"2021年12月度"]
[null,"日","月","火","水","木","金","土",null,null,"１ｼﾌﾄ人数",null,"シフト"]
[null,null,null,null,1,2,3,4,null,null,"2名勤務",null,"2交代"]
[null,5,6,7,8,9,10,11,null,null,"3名勤務",null,"3交代"]
[null,12,13,14,15,16,17,18,null,null,"6名勤務"]
[null,19,20,21,22,23,24,25,null,null,"ローテーション"]
[null,26,27,28,29,30,31,null,null,null,"週ごとに交代",null,"月初班","A","月曜基準で交代"]
[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,"月初班","A"]
[null,null,null,null,null,null,null,null,null,null,"ローテーション無"]
[null,null,null,null,null,null,null,null,null,null,null,null,"月初班","A"]

{"sheet":"勤務表","index":1,"n_rows":96,"n_cols":9,"rows_kept":96,"cut":false,"hidden":false,"merged":[]}
["2021年12月度",null,"3名勤務",null,"週毎に交代",null,"月初班:A",null,"作成(2021/10/14 8:25:12)"]
["日付","名前","勤務時間","特記","備考","名前","勤務時間","特記","備考"]
[null,"勤務1（早出）",null,null,null,"勤務2（遅出）"]
[null,"山田太郎",8,null,null,"吉田市太郎",6]
["2021-12-01","佐藤次郎",6,null,null,"藤原三郎",8]
[null,"北村和子",8,null,null,"北見好美",8]
[null,"山田太郎",8,null,null,"吉田市太郎",6]
["2021-12-02","佐藤次郎",6,null,null,"藤原三郎",8]
[null,"北村和子",8,null,null,"北見好美",8]
[null,"山田太郎",8,null,null,"吉田市太郎",6]
["2021-12-03","佐藤次郎",6,null,null,"藤原三郎",8]
[null,"北村和子",8,null,null,"北見好美",8]
[]
["2021-12-04"]
[]
[]
["2021-12-05"]
[]
[null,"吉田市太郎",6,null,null,"山田太郎",8]
["2021-12-06","藤原三郎",8,null,null,"佐藤次郎",6]
[null,"北見好美",8,null,null,"北村和子",8]
[null,"吉田市太郎",6,null,null,"山田太郎",8]
["2021-12-07","藤原三郎",8,null,null,"佐藤次郎",6]
[null,"北見好美",8,null,null,"北村和子",8]
[null,"吉田市太郎",6,null,null,"山田太郎",8]
["2021-12-08","藤原三郎",8,null,null,"佐藤次郎",6]
[null,"北見好美",8,null,null,"北村和子",8]
[null,"吉田市太郎",6,null,null,"山田太郎",8]
["2021-12-09","藤原三郎",8,null,null,"佐藤次郎",6]
[null,"北見好美",8,null,null,"北村和子",8]
[null,"吉田市太郎",6,null,null,"山田太郎",8]
["2021-12-10","藤原三郎",8,null,null,"佐藤次郎",6]
[null,"北見好美",8,null,null,"北村和子",8]
[]
["2021-12-11"]
[]
[]
["2021-12-12"]
[]
[null,"山田太郎",8,null,null,"吉田市太郎",6]
["2021-12-13","佐藤次郎",6,null,null,"藤原三郎",8]
[null,"北村和子",8,null,null,"北見好美",8]
[null,"山田太郎",8,null,null,"吉田市太郎",6]
["2021-12-14","佐藤次郎",6,null,null,"藤原三郎",8]
[null,"北村和子",8,null,null,"北見好美",8]
[null,"山田太郎",8,null,null,"吉田市太郎",6]
["2021-12-15","佐藤次郎",6,null,null,"藤原三郎",8]
[null,"北村和子",8,null,null,"北見好美",8]
[null,"山田太郎",8,null,null,"吉田市太郎",6]
["2021-12-16","佐藤次郎",6,null,null,"藤原三郎",8]
[null,"北村和子",8,null,null,"北見好美",8]
[null,"山田太郎",8,null,null,"吉田市太郎",6]
["2021-12-17","佐藤次郎",6,null,null,"藤原三郎",8]
[null,"北村和子",8,null,null,"北見好美",8]
[]
["2021-12-18"]
[]
[]
["2021-12-19"]
[]
[null,"吉田市太郎",6,null,null,"山田太郎",8]
["2021-12-20","藤原三郎",8,null,null,"佐藤次郎",6]
[null,"北見好美",8,null,null,"北村和子",8]
[null,"吉田市太郎",6,null,null,"山田太郎",8]
["2021-12-21","藤原三郎",8,null,null,"佐藤次郎",6]
[null,"北見好美",8,null,null,"北村和子",8]
[null,"吉田市太郎",6,null,null,"山田太郎",8]
["2021-12-22","藤原三郎",8,null,null,"佐藤次郎",6]
[null,"北見好美",8,null,null,"北村和子",8]
[null,"吉田市太郎",6,null,null,"山田太郎",8]
["2021-12-23","藤原三郎",8,null,null,"佐藤次郎",6]
[null,"北見好美",8,null,null,"北村和子",8]
[null,"吉田市太郎",6,null,null,"山田太郎",8]
["2021-12-24","藤原三郎",8,null,null,"佐藤次郎",6]
[null,"北見好美",8,null,null,"北村和子",8]
[]
["2021-12-25"]
[]
[]
["2021-12-26"]
[]
[null,"山田太郎",8,null,null,"吉田市太郎",6]
["2021-12-27","佐藤次郎",6,null,null,"藤原三郎",8]
[null,"北村和子",8,null,null,"北見好美",8]
[null,"山田太郎",8,null,null,"吉田市太郎",6]
["2021-12-28","佐藤次郎",6,null,null,"藤原三郎",8]
[null,"北村和子",8,null,null,"北見好美",8]
[null,"山田太郎",8,null,null,"吉田市太郎",6]
["2021-12-29","佐藤次郎",6,null,null,"藤原三郎",8]
[null,"北村和子",8,null,null,"北見好美",8]
[null,"山田太郎",8,null,null,"吉田市太郎",6]
["2021-12-30","佐藤次郎",6,null,null,"藤原三郎",8]
[null,"北村和子",8,null,null,"北見好美",8]
[null,"山田太郎",8,null,null,"吉田市太郎",6]
["2021-12-31","佐藤次郎",6,null,null,"藤原三郎",8]
[null,"北村和子",8,null,null,"北見好美",8]

{"sheet":"勤務データ","index":2,"n_rows":23,"n_cols":42,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
["2021年12月度",null,null,"3名勤務",null,null,"週毎に交代",null,null,null,null,"作成(2021/10/14 8:25:12)"]
[null,null,null,"基準","実績","遅刻","早退","早出","有給","欠勤","その他","2021-12-01","2021-12-02","2021-12-03","2021-12-04","2021-12-05","2021-12-06","2021-12-07","2021-12-08","2021-12-09","2021-12-10","2021-12-11","2021-12-12","2021-12-13","2021-12-14","2021-12-15","2021-12-16","2021-12-17","2021-12-18","2021-12-19","2021-12-20","2021-12-21","2021-12-22","2021-12-23","2021-12-24","2021-12-25","2021-12-26","2021-12-27","2021-12-28","2021-12-29","2021-12-30","2021-12-31"]
["コード","氏名",null,null,null,null,null,null,null,null,null,44531,44532,44533,44534,44535,44536,44537,44538,44539,44540,44541,44542,44543,44544,44545,44546,44547,44548,44549,44550,44551,44552,44553,44554,44555,44556,44557,44558,44559,44560,44561]
[1001,"山田太郎","早",null,184,null,null,null,null,null,null,8,8,8,null,null,null,null,null,null,null,null,null,8,8,8,8,8,null,null,null,null,null,null,null,null,null,8,8,8,8,8]
[null,null,"遅",null,null,null,null,null,null,null,null,null,null,null,null,null,8,8,8,8,8,null,null,null,null,null,null,null,null,null,8,8,8,8,8]
[null,null,null,null,null,0,0,0,0,0,0]
[1002,"佐藤次郎","早",null,138,null,null,null,null,null,null,6,6,6,null,null,null,null,null,null,null,null,null,6,6,6,6,6,null,null,null,null,null,null,null,null,null,6,6,6,6,6]
[null,null,"遅",null,null,null,null,null,null,null,null,null,null,null,null,null,6,6,6,6,6,null,null,null,null,null,null,null,null,null,6,6,6,6,6]
[null,null,null,null,null,0,0,0,0,0,0]
[1003,"北村和子","早",null,184,null,null,null,null,null,null,8,8,8,null,null,null,null,null,null,null,null,null,8,8,8,8,8,null,null,null,null,null,null,null,null,null,8,8,8,8,8]
[null,null,"遅",null,null,null,null,null,null,null,null,null,null,null,null,null,8,8,8,8,8,null,null,null,null,null,null,null,null,null,8,8,8,8,8]
[null,null,null,null,null,0,0,0,0,0,0]
[1004,"吉田市太郎","早",null,138,null,null,null,null,null,null,null,null,null,null,null,6,6,6,6,6,null,null,null,null,null,null,null,null,null,6,6,6,6,6]
[null,null,"遅",null,null,null,null,null,null,null,null,6,6,6,null,null,null,null,null,null,null,null,null,6,6,6,6,6,null,null,null,null,null,null,null,null,null,6,6,6,6,6]
[null,null,null,null,null,0,0,0,0,0,0]
[1005,"藤原三郎","早",null,184,null,null,null,null,null,null,null,null,null,null,null,8,8,8,8,8,null,null,null,null,null,null,null,null,null,8,8,8,8,8]
[null,null,"遅",null,null,null,null,null,null,null,null,8,8,8,null,null,null,null,null,null,null,null,null,8,8,8,8,8,null,null,null,null,null,null,null,null,null,8,8,8,8,8]
[null,null,null,null,null,0,0,0,0,0,0]
[1006,"北見好美","早",null,184,null,null,null,null,null,null,null,null,null,null,null,8,8,8,8,8,null,null,null,null,null,null,null,null,null,8,8,8,8,8]
[null,null,"遅",null,null,null,null,null,null,null,null,8,8,8,null,null,null,null,null,null,null,null,null,8,8,8,8,8,null,null,null,null,null,null,null,null,null,8,8,8,8,8]
[null,null,null,null,null,0,0,0,0,0,0]
[null,null,"早"]
[null,null,"遅"]

{"sheet":"tcsv","index":3,"n_rows":6,"n_cols":9,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
[1001,"山田太郎",184,0,0,0,0,0,0]
[1002,"佐藤次郎",138,0,0,0,0,0,0]
[1003,"北村和子",184,0,0,0,0,0,0]
[1004,"吉田市太郎",138,0,0,0,0,0,0]
[1005,"藤原三郎",184,0,0,0,0,0,0]
[1006,"北見好美",184,0,0,0,0,0,0]

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

{"sheet":"メンバー登録","index":5,"n_rows":16,"n_cols":6,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["シフトメンバー登録"]
[null,"名前","勤務時間","性別","適用","班"]
[1001,"山田太郎",8,"ｍ","hF4AEE2","A"]
[1002,"佐藤次郎",6,"ｍ","hAAF8B3","A"]
[1003,"北村和子",8,"ｆ","hF9D1A5","A"]
[1004,"吉田市太郎",6,"ｍ","hB5B1FD","Ｂ"]
[1005,"藤原三郎",8,"ｍ","hA6EAF8","Ｂ"]
[1006,"北見好美",8,"ｆ","hFBFDA9","Ｂ"]
[null,null,null,null,null,"C"]
[null,null,null,null,null,"C"]
[null,null,null,null,null,"C"]
[]
[]
[]
[]
[null,{"$f":"COUNTA(氏名)","v":6}]

{"sheet":"param","index":6,"n_rows":35,"n_cols":25,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
["年度","月度","ｲﾝﾀｰﾊﾞﾙ","班","特記",null,null,null,"2021年度","毎年更新する必要があります",null,null,"登録パス1","C:\\ESD",null,null,"CSV出力フォーマット設定"]
[2021,1,1,"A","遅刻",null,null,null,"休日設定","休日名",null,null,"登録パス2","C:\\ESD",null,null,"コード","氏名","実績","遅刻","早退","早出","有給","欠勤","その他"]
[2022,2,2,"B","早退",null,null,1,"2021-01-01","元日",null,null,"登録パス3","C:\\ESD",null,"順序",1,2,3,4,5,6,7,8,9]
[2023,3,3,"C","早出",null,null,2,"2021-01-11","成人の日"]
[2024,4,4,null,"有給",null,null,3,"2021-02-11","建国記念の日"]
[2025,5,5,null,"欠勤",null,null,4,"2021-02-23","天皇誕生日"]
[2026,6,6,null,"その他",null,null,5,"2021-03-20","春分の日",null,null,"登録ファイル名1","勤務表"]
[2027,7,7,null,null,null,null,6,"2021-04-29","昭和の日",null,null,"登録ファイル名2","勤務データ"]
[2028,8,8,null,null,null,null,7,"2021-05-03","憲法記念日",null,null,"登録ファイル名3","勤務データCSV"]
[2029,9,9,null,null,null,null,8,"2021-05-04","みどりの日"]
[2030,10,10,null,{"$f":"COUNTA(E2:E10)","v":6},null,null,9,"2021-05-05","こどもの日"]
[2031,11,null,null,null,null,null,10,"2021-07-22","海の日*"]
[2032,12,null,null,null,null,null,11,"2021-07-23","スポーツの日*"]
[2033,null,null,null,null,null,null,12,"2021-08-08","山の日*",null,null,"保存ファイルフォーマット"]
[2034,null,null,null,null,null,null,13,"2021-08-09","振り替え休日",null,null,"勤務表"]
[2035,null,null,null,null,null,null,14,"2021-09-20","敬老の日",null,null,"勤務データ"]
[2036,null,null,null,null,null,null,15,"2021-09-23","秋分の日"]
[2037,null,null,null,null,null,null,16,"2021-11-03","文化の日"]
[2038,null,null,null,null,null,null,17,"2021-11-23","勤労感謝の日"]
[2039,null,null,null,null,null,null,18]
[2040,null,null,null,null,null,null,19]
[2041,null,null,null,null,null,null,20]
[2042,null,null,null,null,null,null,21]
[2043,null,null,null,null,null,null,22]
[2044,null,null,null,null,null,null,23]
[null,null,null,null,null,null,null,24]
[null,null,null,null,null,null,null,25]
[null,null,null,null,null,null,null,26]
[null,null,null,null,null,null,null,27]
[null,null,null,null,null,null,null,null,{"$f":"COUNTA(I3:I29)","v":17}]
[null,null,null,null,null,null,null,null,"*入力方法","スラッシュ区切り"]
[null,null,null,null,null,null,null,null,"（例）2021/10/10－>2021/10/10（日）"]
[null,null,null,null,null,null,null,null,"入力","表示"]
[null,null,null,null,null,null,null,null,"総理府の休日情報"]
[null,null,null,null,null,null,null,null,"https://www8.cao.go.jp/chosei/shukujitsu/gaiyou.html"]

{"sheet":"readme","index":7,"n_rows":41,"n_cols":8,"rows_kept":41,"cut":false,"hidden":false,"merged":[]}
["勤務表作成"]
[]
["目的"]
[]
["交代勤務のローテーション表の作成"]
[]
["作成"]
[]
[]
[null,"開発環境"]
[]
[null,"os",null,"Microsoft Windows 10 Professional 1909",null,null,null,18363.108199999999]
[null,"excel",null,"microsoft excel 2019 MSO(16.0 13231.20250)64bit"]
[]
[null,"※レジストリデータの取得・設定のためにいくつかのWindows　APIを利用しています。"]
[null,"※Windows APIに関しては32ビット、64ビット環境の両方の環境で動作可能にしてあります"]
[]
["使い方"]
[]
["連番の印刷（印刷枚数は初期値と最終値で自動計算）"]
["1）","フォーマット番号（主表示）を選択する"]
["2）","バーコードの初期値と最終値を入力する",null,null,null,null,"（必要に応じて追加修正用枠内の基本コードを修正）"]
["3）","データの反映ボタンでバーコードラベルの状態を確認する"]
["4）","印刷ボタンで印刷する"]
[null,"（同じ連番セットを複数出力する場合は、印刷設定で行う）"]
[]
["固定バーコードラベルの複数枚印刷（修正印刷）"]
["1）","フォーマット番号（主表示）を選択する"]
["2）","修正印刷にチェックを入れる"]
["3）","印刷枚数を設定する",null,null,null,null,"（必要に応じて追加修正用枠内の基本コードを修正）"]
["4）","データの反映ボタンでバーコードラベルの状態を確認する"]
["5）","印刷ボタンで印刷する"]
[]
[null,"※本ツールは、専用ラベルプリンター（モノクロ）用の出力を前提としており、モニター上では黄色になる出力結果は"]
[null,"専用プリンターでは無視されます。通常のカラープリンター（インクジェット、レーザー等）に出力する場合は、目的に合わせて"]
[null,"背景色を変更する必要があります。"]
[null,"（業務用ラベルプリンタ：SATO、Brother、Toshiba等々のメーカーから出ているロール紙を使用する専用プリンター）"]
["履歴"]
["1）2020.10"]
[null,"開発環境64bit"]
[null,null,null,"(バーコードスタイル　12種類)"]