{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["実行","OUTPUT"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":1,"defined_names":3,"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":10,"n_cols":9,"rows_kept":10,"cut":false,"hidden":false,"merged":[[2,2,2,9],[5,3,5,8],[1,1,1,8]]}
[null,null,null,null,null,null,null,null,"ver2.0"]
[null,"アドバンテッジ pdCa 調査グループ別数値推移一覧化ツール"]
[null,null,"このツールはアドバンテッジpdCa「調査グループ別数値推移csv」を用いて因子ごとの数値の一覧を作成します。\n\n当ツール対象調査\nアドバンテッジ pdCa 対象調査：組み合わせ調査、エンゲージメント調査、メンタルヘルス調査、メンタルタフネス度調査、\nハラスメント調査、プレゼンティーイズム調査、生活習慣調査\n\n動作環境\nWindows11、Excel2016以降（64ビット）\n\n準備するファイル\nアドバンテッジpdCa：調査グループ別数値推移のCSVファイル\n　  ▶ダウンロード方法\n　　　①「調査」 ＞「調査一覧」＞「終了」または「期間中」から該当の調査 を開く\n　　  ②右上の「エクスポート」ボタン ＞出力するレポート種類を選択にて「調査グループ別にエクスポート」を選択\n　　  ③「決定」ボタン ＞「調査グループ別数値推移csv」をダウンロード\n　　　  ※一部ご契約プランの企業様に限りますが、調査グループ×属性でファイル出力可能です。\nツールが動作しない場合\n電子署名されたマクロツールを実行可能にする設定で、ツール実行が可能になります。設定方法は　こちら　よりご確認ください。"]
[null,"◆STEP 1　　CSVファイル選択"]
[]
[]
[]
[null,"◆STEP 2　　調査グループ別数値推移一覧出力"]
[]
[null,null,null,"出力開始をクリックして、保存先フォルダを指定してください。"]

{"sheet":"OUTPUT","index":1,"n_rows":37,"n_cols":140,"rows_kept":37,"cut":false,"hidden":true,"merged":[[2,9,2,14]]}
["出力項目設定用"]
[]
[null,null,null,null,null,null,null,null,null,"大項目設定用\nこの行は折り返しなし、罫線なし\n",null,null,null,null,null,"組織活性化の課題","組織活性化の課題","いきいき度の課題","いきいき度の課題","オンボーディングの課題","オンボーディングの課題","オンボーディングの課題","オンボーディングの課題","オンボーディングの課題","オンボーディングの課題","オンボーディングの課題","オンボーディングの課題","オンボーディングの課題","ハラスメント防止の課題","ハラスメント防止の課題","ハラスメント防止の課題","偏差値調査のサマリ","偏差値調査のサマリ","偏差値調査のサマリ","偏差値調査のサマリ","偏差値調査のサマリ","エンゲージメント調査","エンゲージメント調査","エンゲージメント調査","エンゲージメント調査","エンゲージメント調査","エンゲージメント調査","エンゲージメント調査","エンゲージメント調査","エンゲージメント調査","エンゲージメント調査","エンゲージメント調査","エンゲージメント調査","エンゲージメント調査","エンゲージメント調査","エンゲージメント調査","エンゲージメント調査","エンゲージメント調査","エンゲージメント調査","エンゲージメント調査","エンゲージメント調査","エンゲージメント調査","エンゲージメント調査","エンゲージメント調査","エンゲージメント調査","エンゲージメント調査","エンゲージメント調査","エンゲージメント調査","メンタルタフネス度","メンタルタフネス度","メンタルタフネス度","メンタルタフネス度","メンタルタフネス度","メンタルタフネス度","メンタルタフネス度","メンタルタフネス度","メンタルタフネス度","メンタルタフネス度","メンタルタフネス度","メンタルヘルス","メンタルヘルス","メンタルヘルス","メンタルヘルス","メンタルヘルス","メンタルヘルス","メンタルヘルス","メンタルヘルス","メンタルヘルス","メンタルヘルス","メンタルヘルス","メンタルヘルス","メンタルヘルス","メンタルヘルス","メンタルヘルス","メンタルヘルス","メンタルヘルス","メンタルヘルス","メンタルヘルス","メンタルヘルス","メンタルヘルス","メンタルヘルス","メンタルヘルス","メンタリティマネジメント","メンタリティマネジメント","メンタリティマネジメント","メンタリティマネジメント","メンタリティマネジメント","メンタリティマネジメント","ハラスメント","ハラスメント","ハラスメント","ハラスメント","ハラスメント","ハラスメント","ハラスメント","ハラスメント","ハラスメント","ハラスメント","ハラスメント","ハラスメント","ハラスメント","ハラスメント","健康と仕事のパフォーマンスに関する調査","生産性に関する調査","生活習慣調査","生活習慣調査","生活習慣調査","生活習慣調査","生活習慣調査","生活習慣調査","生活習慣調査","生活習慣調査","生活習慣調査","生活習慣調査","生活習慣調査","生活習慣調査","生活習慣調査","生活習慣調査","⇒悪化/改善のカウント対象外","⇒悪化/改善のカウント対象外","⇒悪化/改善のカウント対象外","⇒悪化/改善のカウント対象外","⇒悪化/改善のカウント対象外","⇒悪化/改善のカウント対象外","⇒悪化/改善のカウント対象外"]
[]
["6-7行目が出力対象　項目名が変更された場合は7行目を修正"]
[]
["(固定）","(固定）","(固定）","(固定）","(固定）","(固定）","(固定）","(固定）","(固定）","(固定）","(固定）","(固定）","(固定）","(固定）","(固定）","組織活性化の課題",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,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,"⇒悪化/改善のカウント対象外"]
["階層コード","調査グループID","調査グループ名:第一階層","調査グループ名:第二階層","調査グループ名:第三階層","調査グループ名:第四階層","調査グループ名:第五階層","調査グループ名:第六階層","属性","回次","回答期間開始日","回答期間終了日","対象人数","回答人数","回答率（％）","組織の生産性","組織の活性度への貢献度「低」占有率","いきいき度","へとへと占有率","職場のコミュニケーション/ワークエンゲージメント40未満占有率","職場のコミュニケーション/ワークエンゲージメント40以上60未満占有率","職場のコミュニケーション/ワークエンゲージメント60以上占有率","職場のコミュニケーション/エンプロイーエンゲージメント40未満占有率","職場のコミュニケーション/エンプロイーエンゲージメント40以上60未満占有率","職場のコミュニケーション/エンプロイーエンゲージメント60以上占有率","職場のコミュニケーション/ストレス反応40未満占有率","職場のコミュニケーション/ストレス反応40以上60未満占有率","職場のコミュニケーション/ストレス反応60以上占有率","上司からのハラスメント発生有無","上司とのコミュニケーション関連偏差値40未満項目数","上司とのコミュニケーション関連低値割合25%以上項目数","偏差値40未満因子数","低値割合25.0%以上因子数","偏差値3pt以上下降因子数","偏差値60以上因子数","偏差値3pt以上上昇因子数","エンゲージメント/ワークエンゲージメント（★） （偏差値）","エンゲージメント/エンプロイーエンゲージメント（★） （偏差値）","エンゲージメント/会社との適合感 （偏差値）","エンゲージメント/仕事の見通し （偏差値）","エンゲージメント/仕事への自信 （偏差値）","エンゲージメント/強みの発揮 （偏差値）","エンゲージメント/働きがい （偏差値）","エンゲージメント/対処できる思考 （偏差値）","エンゲージメント/前向きに考え直す行動 （偏差値）","エンゲージメント/問題解決行動 （偏差値）","エンゲージメント/気分転換行動 （偏差値）","エンゲージメント/相談行動 （偏差値）","エンゲージメント/出来事を重く受け止める傾向 （偏差値）","エンゲージメント/あきらめ行動 （偏差値）","エンゲージメント/感情的行動 （偏差値）","エンゲージメント/企業理念・ビジョンへの共感 （偏差値）","エンゲージメント/経営層との信頼関係 （偏差値）","エンゲージメント/仕事の裁量 （偏差値）","エンゲージメント/役割・責任の理解 （偏差値）","エンゲージメント/評価の納得感 （偏差値）","エンゲージメント/目標と役割の指示 （偏差値）","エンゲージメント/仕事に対するフィードバック （偏差値）","エンゲージメント/上司の誠実な態度 （偏差値）","エンゲージメント/職場の人間関係 （偏差値）","エンゲージメント/上司への信頼 （偏差値）","エンゲージメント/同僚への信頼 （偏差値）","エンゲージメント/心理的安全性 （偏差値）","メンタルタフネス度/仕事への自信 （偏差値）","メンタルタフネス度/強みの発揮 （偏差値）","メンタルタフネス度/働きがい （偏差値）","メンタルタフネス度/対処できる思考 （偏差値）","メンタルタフネス度/前向きに考え直す行動 （偏差値）","メンタルタフネス度/問題解決行動 （偏差値）","メンタルタフネス度/気分転換行動 （偏差値）","メンタルタフネス度/相談行動 （偏差値）","メンタルタフネス度/出来事を重く受け止める傾向 （偏差値）","メンタルタフネス度/あきらめ行動 （偏差値）","メンタルタフネス度/感情的行動 （偏差値）","メンタルヘルス/ストレス反応（★） （偏差値）","メンタルヘルス/仕事の量 （偏差値）","メンタルヘルス/仕事の難しさ （偏差値）","メンタルヘルス/身体的負担 （偏差値）","メンタルヘルス/仕事の裁量 （偏差値）","メンタルヘルス/役割・責任の理解 （偏差値）","メンタルヘルス/評価の納得感 （偏差値）","メンタルヘルス/上司の業務配慮 （偏差値）","メンタルヘルス/上司の誠実な態度 （偏差値）","メンタルヘルス/職場の人間関係 （偏差値）","メンタルヘルス/職場の安全性・快適性 （偏差値）","メンタルヘルス/プライベートの問題 （偏差値）","メンタルヘルス/仕事への自信 （偏差値）","メンタルヘルス/強みの発揮 （偏差値）","メンタルヘルス/働きがい （偏差値）","メンタルヘルス/対処できる思考 （偏差値）","メンタルヘルス/前向きに考え直す行動 （偏差値）","メンタルヘルス/問題解決行動 （偏差値）","メンタルヘルス/気分転換行動 （偏差値）","メンタルヘルス/相談行動 （偏差値）","メンタルヘルス/出来事を重く受け止める傾向 （偏差値）","メンタルヘルス/あきらめ行動 （偏差値）","メンタルヘルス/感情的行動 （偏差値）","メンタリティマネジメント/ストレス反応（★） （偏差値）","メンタリティマネジメント/ワークエンゲージメント（★） （偏差値）","メンタリティマネジメント/エンプロイーエンゲージメント（★） （偏差値）","メンタリティマネジメント/ストレス原因 （偏差値）","メンタリティマネジメント/会社や仕事における環境・状況 （偏差値）","メンタリティマネジメント/メンタルタフネス度 （偏差値）","ハラスメント有項目数","0.1％以上悪化項目数","0.1％以上改善項目数","ハラスメント/上司から嫌がらせ","ハラスメント/上司から人格否定","ハラスメント/同僚から嫌がらせ","ハラスメント/同僚から人格否定","ハラスメント/職場で性的な嫌がらせ","ハラスメント/職場で性的に不快な言動","ハラスメント/取引先から嫌がらせ","ハラスメント/取引先から人格否定","ハラスメント/他の人が上司から嫌がらせ","ハラスメント/他の人が同僚から嫌がらせ","ハラスメント/他の人が取引先から嫌がらせ","健康と仕事のパフォーマンスに関する調査（損失割合）","生産性に関する調査（損失割合）","生活習慣/前回より4%以上悪化項目数","生活習慣/前回より4%以上改善項目数","生活習慣/喫煙習慣","生活習慣/20歳からの体重変化","生活習慣/30分以上の運動習慣","生活習慣/歩行又は身体活動","生活習慣/歩行速度","生活習慣/咀嚼","生活習慣/食べ方（早食い等）","生活習慣/食べ方（就寝前）","生活習慣/食べ方（間食）","生活習慣/朝食習慣","生活習慣/飲酒習慣","生活習慣/睡眠の質","生活習慣/服薬（血圧） ※課題対象外","生活習慣/服薬（血糖） ※課題対象外","生活習慣/服薬（脂質） ※課題対象外","生活習慣/既往歴（脳血管） ※課題対象外","生活習慣/既往歴（心血管） ※課題対象外","生活習慣/既往歴（腎不全・人工透析） ※課題対象外","生活習慣/貧血 ※課題対象外"]
[]
["書式設定"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"書式",null,"0.0",null,"0.0","0.0","0.0","0.0","0.0","0.0","0.0","0.0","0.0","0.0",null,"0","0","0","0","0","0","0","0.0","0.0","0.0","0.0","0.0","0.0","0.0","0.0","0.0","0.0","0.0","0.0","0.0","0.0","0.0","0.0","0.0","0.0","0.0","0.0","0.0","0.0","0.0","0.0","0.0","0.0","0.0","0.0","0.0","0.0","0.0","0.0","0.0","0.0","0.0","0.0","0.0","0.0","0.0","0.0","0.0","0.0","0.0","0.0","0.0","0.0","0.0","0.0","0.0","0.0","0.0","0.0","0.0","0.0","0.0","0.0","0.0","0.0","0.0","0.0","0.0","0.0","0.0","0.0","0.0","0.0","0.0","0","0","0","0.0","0.0","0.0","0.0","0.0","0.0","0.0","0.0","0.0","0.0","0.0","0.0","0.0","0","0","0.0","0.0","0.0","0.0","0.0","0.0","0.0","0.0","0.0","0.0","0.0","0.0","0.0","0.0","0.0","0.0","0.0","0.0","0.0"]
[null,null,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,null,null,"課題/組織の生産性","値（以上/未満）","いきいき度","値（以上/未満）","値（以上/未満）","なし","なし","値（以上/未満）","なし","なし","値（以上/未満）","なし","なし","上司からのハラスメント/発生有無","値（以上/未満）","値（以上/未満）","値（以上/未満）","値（以上/未満）","値（以上/未満）","なし","なし","値（5段階）","値（5段階）","値（5段階）","値（5段階）","値（5段階）","値（5段階）","値（5段階）","値（5段階）","値（5段階）","値（5段階）","値（5段階）","値（5段階）","値（5段階）","値（5段階）","値（5段階）","値（5段階）","値（5段階）","値（5段階）","値（5段階）","値（5段階）","値（5段階）","値（5段階）","値（5段階）","値（5段階）","値（5段階）","値（5段階）","値（5段階）","値（5段階）","値（5段階）","値（5段階）","値（5段階）","値（5段階）","値（5段階）","値（5段階）","値（5段階）","値（5段階）","値（5段階）","値（5段階）","値（5段階）","値（5段階）","値（5段階）","値（5段階）","値（5段階）","値（5段階）","値（5段階）","値（5段階）","値（5段階）","値（5段階）","値（5段階）","値（5段階）","値（5段階）","値（5段階）","値（5段階）","値（5段階）","値（5段階）","値（5段階）","値（5段階）","値（5段階）","値（5段階）","値（5段階）","値（5段階）","値（5段階）","値（5段階）","値（5段階）","値（5段階）","値（5段階）","値（5段階）","値（以上/未満）","値（以上/未満）","なし","なし","なし","なし","なし","なし","なし","なし","なし","なし","なし","なし","値（4段階）","値（4段階）","値（以上/未満）","なし","なし","なし","なし","なし","なし","なし","なし","なし","なし","なし","なし","なし","なし","なし","なし","なし","なし","なし","なし"]
["パターン№","パターン名",null,null,"列","動作内容",null,null,null,null,null,null,null,null,null,"髙",25,"いきいき",25,25,null,null,25,null,null,25,null,null,"有",1,1,1,1,1,null,null,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,1,1,null,null,null,null,null,null,null,null,null,null,null,null,40,40,1]
["パターン１","なし",null,null,"-","何もしない",null,null,null,null,null,null,null,null,null,"中（for仕事）",25,"マイペース",25,25,null,null,25,null,null,25,null,null,"無",1,1,1,1,1,null,null,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,1,1,null,null,null,null,null,null,null,null,null,null,null,null,30,30,1]
["パターン２","課題/組織の生産性",null,null,"P","4項目指定",null,null,null,null,null,null,null,null,null,"中（for組織）",null,"燃えつき",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,40,40,40,40,40,40,40,40,40,40,40,40,40,40,40,40,40,40,40,40,40,40,40,40,40,40,40,40,40,40,40,40,40,40,40,40,40,40,40,40,40,40,40,40,40,40,40,40,40,40,40,40,40,40,40,40,40,40,40,40,40,40,40,40,40,40,40,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20,20]
["パターン３","いきいき度",null,null,"R","4項目指定",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,35,35,35,35,35,35,35,35,35,35,35,35,35,35,35,35,35,35,35,35,35,35,35,35,35,35,35,35,35,35,35,35,35,35,35,35,35,35,35,35,35,35,35,35,35,35,35,35,35,35,35,35,35,35,35,35,35,35,35,35,35,35,35,35,35,35,35,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20,20]
["パターン４","上司からのハラスメント/発生有無",null,null,"AC","2項目指定",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,35,35,35,35,35,35,35,35,35,35,35,35,35,35,35,35,35,35,35,35,35,35,35,35,35,35,35,35,35,35,35,35,35,35,35,35,35,35,35,35,35,35,35,35,35,35,35,35,35,35,35,35,35,35,35,35,35,35,35,35,35,35,35,35,35,35,35]
["パターン５","値（以上/未満）",null,null,"-","11行目の値以上、12行目の値未満"]
["パターン６","値（5段階）",null,null,"-","11行目の値以上、12行目の値以上と順に16行目まで指定"]
["パターン７","値（4段階）",null,null,"-","11行目の値以上、12行目の値以上と順に16行目まで指定"]
[]
[]
[]
[]
["前回とのGAP指定"]
[]
["　25行目に下のパターン名をセット　　　※パターンが増える場合はツールの修正が必要",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,4,null,4,4,null,4,4,null,4,4,null,4,"▲無⇒有",1,1,1,1,null,1,null,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,1,null,null,0.1,0.1,0.1,0.1,0.1,0.1,0.1,0.1,0.1,0.1,0.1,3,3,null,null,4,4,4,4,4,4,4,4,4,4,4,4]
["パターン１","なし",null,null,"-","何もしない",null,null,null,null,null,null,null,null,null,null,-4,null,-4,-4,null,-4,-4,null,-4,-4,null,-4,"▼有⇒無",-1,-1,-1,-1,null,-1,null,-3,-3,-3,-3,-3,-3,-3,-3,-3,-3,-3,-3,-3,-3,-3,-3,-3,-3,-3,-3,-3,-3,-3,-3,-3,-3,-3,-3,-3,-3,-3,-3,-3,-3,-3,-3,-3,-3,-3,-3,-3,-3,-3,-3,-3,-3,-3,-3,-3,-3,-3,-3,-3,-3,-3,-3,-3,-3,-3,-3,-3,-3,-3,-3,-3,-3,-3,-1,null,null,-0.1,-0.1,-0.1,-0.1,-0.1,-0.1,-0.1,-0.1,-0.1,-0.1,-0.1,-3,-3,null,null,-4,-4,-4,-4,-4,-4,-4,-4,-4,-4,-4,-4]
["パターン２","上司からのハラスメント/発生有無",null,null,"AC","▲無⇒有、▼有⇒無でそれぞれフォント色指定",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,"-","11行目の値以上▲、12行目の値以下▼、フォント色変更"]
[]
[]
["凡例"]