{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["main","setColor","src","マスタ","srcCalc","timeCharts","colorPivot","超勤","コスト","日報"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":1,"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":32,"n_cols":11,"rows_kept":32,"cut":false,"hidden":false,"merged":[[7,2,7,3],[12,6,12,8],[31,8,31,11]]}
[]
[]
[]
[]
[]
[null,null,"１．計測データの取込"]
[null,null,"　ろじたんWebからダウンロードした計測データ（CSV）を取込みします。"]
[null,null,"　取込csv名："]
[]
[null,null,"２．設定"]
[null,null,"　２－１．カラー設定",null,null,null,null,null,null,null,"未設定"]
[null,null,"　　タイムチャート出力時の作業名のカラーを設定します。未設定の場合は「カラー設定」ボタンを"]
[null,null,"　　押し、任意のカラーを選択して下さい。",null,null,null,"※設定済の場合はリセットされます。"]
[null,null,"　　"]
[null,null,"　２－２．期間選択"]
[null,null,"　　集計する期間を選択して下さい。"]
[null,null,null,"開始日：",null,"         ～","終了日："]
[]
[null,null,"３．一括レポート出力"]
[null,null,"　「一括レポート」ボタンを押すと、主要なレポートが別ファイルで出力されます。"]
[null,null,"　 ※ファイル名が重複する場合は上書きされます。ご注意ください。"]
[]
[null,null,"４．個別レポート出力"]
[null,null,"　以下のメニューから見たい項目を選択してレポート出力ボタンを押して下さい。"]
[null,null,"　個別レポートがツール内に作成されます。"]
[]
[]
[null,null,"５．データクリア"]
[null,null,"　各種データの初期化を行います。「データ」ボタンで計測データの初期化, "]
[null,null,"　「カラー」ボタンでカラー設定の初期化を行います。"]
[]
[null,null,null,null,null,null,null,null,"開発元：(株)日通総合研究所"]

{"sheet":"setColor","index":1,"n_rows":2,"n_cols":5,"rows_kept":2,"cut":false,"hidden":false,"merged":[[0,0,0,4]]}
["ボタン色設定"]
["作業レベル1","作業レベル2","作業レベル3","作業名","色設定"]

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

{"sheet":"マスタ","index":3,"n_rows":24,"n_cols":6,"rows_kept":24,"cut":false,"hidden":true,"merged":[]}
["開始日","終了日","レポート","レポートNo","レポート選択No","施設名"]
[{"$f":"main!E17","v":"00:00:00"},{"$f":"main!H17","v":"00:00:00"},"(L01-1) スタッフ別タイムチャート",1,1,"すべて"]
[null,null,"(L02-1) 施設別/日別作業時間構成",2]
[null,null,"(L03-1) 作業別構成比率",3]
[null,null,"(L04-1) 作業詳細別時間構成",4]
[null,null,"(L05-1) 曜日別時間構成",5]
[null,null,"(L05-2) 曜日別時間構成（施設別）",6]
[null,null,"(L05-3) 曜日別時間構成（作業名）",23,"v2.08追加"]
[null,null,"(L06-1) 時間帯別作業推移（累計）",7]
[null,null,"(L06-2) 時間帯別作業推移（平均）",19,"v2.08追加"]
[null,null,"(L06-3) 時間帯別作業推移（作業名_累計）",20,"v2.08追加"]
[null,null,"(L06-4) 時間帯別作業推移（作業名_平均）",21,"v2.08追加"]
[null,null,"(L07-1) 作業区分別時間構成",22,"v2.08追加"]
[null,null,"(L08-1) スタッフ区分別時間構成",8]
[null,null,"(L09-1) スタッフ別時間構成",9]
[null,null,"(L10-1) 作業従事比率",10]
[null,null,"(L11-1) 超勤集計",11]
[null,null,"(L12-1) 作業別概算コスト",12]
[null,null,"(L13-1) 多能工化率集計",13]
[null,null,"(L14-1) 作業別歩数比率",14]
[null,null,"(L15-1) 作業別分あたり歩数",15]
[null,null,"(L16-1) ピック作業分あたり歩数",16]
[null,null,"(L17-1) 作業日報作成",17]
[null,null,"(L18-1) 個人別シフト集計",18]

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

{"sheet":"timeCharts","index":5,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"colorPivot","index":6,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"超勤","index":7,"n_rows":4,"n_cols":5,"rows_kept":4,"cut":false,"hidden":true,"merged":[[1,1,1,2]]}
["■超勤集計"]
[null,"基本勤務時間",null,9]
[]
[null,"スタッフID","スタッフ名","作業グループ名","超勤計（時）"]

{"sheet":"コスト","index":8,"n_rows":7,"n_cols":8,"rows_kept":7,"cut":false,"hidden":true,"merged":[[3,1,3,2],[2,1,2,2]]}
["■作業別概算コスト"]
[]
[null,"スタッフ区分",null,"正社員","契約","パート","請負等","派遣"]
[null,"作業単価",null,3000,2000,1500,1500,1200]
[]
[]
[null,"施設名","作業名"]

{"sheet":"日報","index":9,"n_rows":10,"n_cols":8,"rows_kept":10,"cut":false,"hidden":true,"merged":[[1,1,1,8],[9,6,9,8],[5,2,5,3],[4,2,4,3],[3,2,3,3],[7,2,7,3]]}
[null,null,null,null,null,null,null,"作成日："]
[null,"　作　業　日　報"]
[]
[null,"日付"]
[null,"スタッフID"]
[null,"氏名"]
[]
[null,"総労働時間",null,null,"※休憩含む"]
[]
[null,"開始時刻","終了時刻","時間(分)","施設名","作業名","摘要"]