{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["MENU","temp","設問別選択割合","レポート作成グループ設定","(選択式)","(選択式・複)","(11段階評価)","(プルダウン)","(記述式)","(数字入力)"],"not_rendered":{"charts":4,"images":7,"macros":1,"external_links":0,"defined_names":7,"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":"MENU","index":0,"n_rows":21,"n_cols":24,"rows_kept":21,"cut":false,"hidden":false,"merged":[[7,19,7,22],[9,8,9,18],[0,3,0,22],[2,3,2,18],[3,19,3,22],[4,3,4,7],[4,8,4,18],[4,19,4,22],[8,8,8,18],[17,0,17,32],[3,3,3,15],[10,23,10,29],[1,3,1,18],[10,3,10,15],[11,3,11,18],[12,3,12,15],[10,19,10,22],[11,19,11,22],[12,19,12,22],[5,2,9,2],[5,3,5,18],[5,19,5,22],[6,8,6,18],[6,19,6,22],[7,8,7,18]]}
[null,null,null,"独自に設定する調査　推移閲覧化作成ツール【MENU】",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ver.1.1"]
[null,null,null,"【ツール説明】\n　このツールは、「独自に設定する調査」の結果推移を調査グループごとに\n　確認できる簡易的なレポートを作成するためのツールです。\n　設問別選択割合csvを使用します。手順に従って操作ください。\n　【推奨環境：Windows11、Excel2016以降（64ビット）】\n【ツールが動作しない場合】\n　電子署名されたマクロツールを実行可能にする設定で、ツール実行が可能になります。\n　設定方法は　こちら　よりご確認ください。"]
[null,null,null,"■操作手順\nまず、管理画面より「設問別選択割合csv」をダウンロードして任意のフォルダへ格納します。\n　①「調査」 ＞「調査一覧」＞「終了」または「期間中」から該当の調査 を開く\n　②結果を確認したい調査グループを指定し、レポート画面を表示\n　③右上の「エクスポート」ボタン ＞出力するレポート種類を選択にて「設問別選択割合」を選択\n　④「決定」ボタン ＞「設問別選択割合csv」をダウンロード\n以下の手順1～手順6まで順番に実行してください。",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"実行時間",null,null,null,"ファイルパス"]
[null,null,"手順１","初期化\nこのツールファイルの不要なデータを削除し、初期化します。"]
[null,null,"手順２","調査名入力　⇒\n本資料のタイトルに使用する調査名を青枠内に手入力します。"]
[null,null,"手順３","推移を確認したい回次を古いものから順に指定してください。（最大４回分・半角数字）\n(5回分のうち２、3、4、5回を比較する場合、一番目＝2、二番目＝3、三番目＝4、四番目＝5の順)"]
[null,null,null,"一番目の回次　⇒"]
[null,null,null,"二番目の回次　⇒"]
[null,null,null,"三番目の回次　⇒"]
[null,null,null,"四番目の回次　⇒"]
[null,null,"手順４","設問別選択割合CSVインポート\nあらかじめ管理画面からダウンロードした「設問別選択割合csv」をインポートします。"]
[null,null,"手順５","出力前の設定\n必要に応じて①②の設定を行ってください。\n　　①「レポート作成グループ設定シート」にて出力対象を設定\n　　　　「レポート作成グループ設定」シートT列にて、調査結果推移を作成する調査グループを指定してください。\n　　　　初期設定は全調査グループが作成の対象となります。\n\n　　②「設問別選択割合」シートにて複数回答可とした設問文の設定\n　　　　複数回答可として調査した設問がありましたら、「設問別選択割合」シートR列の対象となる設問文すべてに\n　　　　（複数可）の文言を追加してください。\n"]
[null,null,"手順６","調査結果推移生成およびファイル出力\n「結果生成＆ファイル出力」ボタンを押下し、別ファイルで保存します。\n完成したファイルはこのツールが格納されている同フォルダに保存されます。\nデータ数によってはお時間がかかる場合がありますので、余裕をもって操作ください。"]
[]
[]
[]
[]
["　　【完成イメージ】"]
[null,"※一問一答の場合のグラフは積み上げグラフとなります。（選択式、11段階式、プルダウン式）"]
[null,"※選択式・複数回答可とした場合のグラフは折れ線グラフとなります。"]
[null,"※記述式、数字入力式の回答についてはグラフ表示はございません。"]

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

{"sheet":"設問別選択割合","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"レポート作成グループ設定","index":3,"n_rows":5,"n_cols":22,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["レポート作成対象調査グループ",null,null,null,null,null,null,null,null,null,"レポート作成対象調査グループ"]
["階層コード","調査グループID","第1階層","第2階層","第3階層","第4階層","第5階層","第6階層","集計人数",null,"階層コード","調査グループID","調査グループ名",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,"レポート作成が不要な調査グループの「出力対象（T列）」を"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"「1」⇒「空欄」に変更してください"]

{"sheet":"(選択式)","index":4,"n_rows":18,"n_cols":20,"rows_kept":18,"cut":false,"hidden":true,"merged":[[3,2,3,12],[4,2,4,12],[5,2,5,12]]}
[]
[null,"調査名"]
[null,"調査グループID"]
[null,"調査グループ名"]
[null,"設問番号"]
[null,"設問文"]
[null,"調査期間"]
[]
[]
[]
[null,"◆回答率",null,null,null,null,null,null,null,null,null,null,null,null,null,"設問毎：回答人数（未回答者含まない）記述式と数字入力のみ参照"]
[null,null,{"$f":"IF(C7=\"\",\"\",C7)","v":""},{"$f":"IF(C8=\"\",\"\",C8)","v":""},{"$f":"IF(C9=\"\",\"\",C9)","v":""},{"$f":"IF(C10=\"\",\"\",C10)","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"C12","v":""},{"$f":"D12","v":""},{"$f":"E12","v":""},""]
[null,"対象者",null,null,null,null,null,null,null,null,null,null,null,null,null,"設問毎：回答人数"]
[null,"回答者"]
[null,"回答率"]
[]
[null,"◆選択肢別回答人数（人）"]
[null,null,{"$f":"IF(C7=\"\",\"\",C7)","v":""},{"$f":"IF(C8=\"\",\"\",C8)","v":""},{"$f":"IF(C9=\"\",\"\",C9)","v":""},{"$f":"IF(C10=\"\",\"\",C10)","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"C18","v":""},{"$f":"D18","v":""},"",""]

{"sheet":"(選択式・複)","index":5,"n_rows":18,"n_cols":20,"rows_kept":18,"cut":false,"hidden":true,"merged":[[3,2,3,12],[4,2,4,12],[5,2,5,12]]}
[]
[null,"調査名"]
[null,"調査グループID"]
[null,"調査グループ名"]
[null,"設問番号"]
[null,"設問文"]
[null,"調査期間"]
[]
[]
[]
[null,"◆回答率",null,null,null,null,null,null,null,null,null,null,null,null,null,"設問毎：回答人数（未回答者含まない）記述式と数字入力のみ参照"]
[null,null,{"$f":"IF(C7=\"\",\"\",C7)","v":""},{"$f":"IF(C8=\"\",\"\",C8)","v":""},{"$f":"IF(C9=\"\",\"\",C9)","v":""},{"$f":"IF(C10=\"\",\"\",C10)","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"C12","v":""},{"$f":"D12","v":""},"",""]
[null,"対象者",null,null,null,null,null,null,null,null,null,null,null,null,null,"設問毎：回答人数"]
[null,"回答者"]
[null,"回答率"]
[]
[null,"◆選択肢別回答人数（人）"]
[null,null,{"$f":"IF(C7=\"\",\"\",C7)","v":""},{"$f":"IF(C8=\"\",\"\",C8)","v":""},{"$f":"IF(C9=\"\",\"\",C9)","v":""},{"$f":"IF(C10=\"\",\"\",C10)","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"C18","v":""},{"$f":"D18","v":""},"",""]

{"sheet":"(11段階評価)","index":6,"n_rows":18,"n_cols":20,"rows_kept":18,"cut":false,"hidden":true,"merged":[[3,2,3,12],[4,2,4,12],[5,2,5,12]]}
[]
[null,"調査名"]
[null,"調査グループID"]
[null,"調査グループ名"]
[null,"設問番号"]
[null,"設問文"]
[null,"調査期間"]
[]
[]
[]
[null,"◆回答率",null,null,null,null,null,null,null,null,null,null,null,null,null,"設問毎：回答人数（未回答者含まない）記述式と数字入力のみ参照"]
[null,null,{"$f":"IF(C7=\"\",\"\",C7)","v":""},{"$f":"IF(C8=\"\",\"\",C8)","v":""},{"$f":"IF(C9=\"\",\"\",C9)","v":""},{"$f":"IF(C10=\"\",\"\",C10)","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"C12","v":""},{"$f":"D12","v":""},"",""]
[null,"対象者",null,null,null,null,null,null,null,null,null,null,null,null,null,"設問毎：回答人数"]
[null,"回答者"]
[null,"回答率"]
[]
[null,"◆選択肢別回答人数（人）"]
[null,null,{"$f":"IF(C7=\"\",\"\",C7)","v":""},{"$f":"IF(C8=\"\",\"\",C8)","v":""},{"$f":"IF(C9=\"\",\"\",C9)","v":""},{"$f":"IF(C10=\"\",\"\",C10)","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"C18","v":""},{"$f":"D18","v":""},"",""]

{"sheet":"(プルダウン)","index":7,"n_rows":18,"n_cols":20,"rows_kept":18,"cut":false,"hidden":true,"merged":[[3,2,3,12],[4,2,4,12],[5,2,5,12]]}
[]
[null,"調査名"]
[null,"調査グループID"]
[null,"調査グループ名"]
[null,"設問番号"]
[null,"設問文"]
[null,"調査期間"]
[]
[]
[]
[null,"◆回答率",null,null,null,null,null,null,null,null,null,null,null,null,null,"設問毎：回答人数（未回答者含まない）記述式と数字入力のみ参照"]
[null,null,{"$f":"IF(C7=\"\",\"\",C7)","v":""},{"$f":"IF(C8=\"\",\"\",C8)","v":""},{"$f":"IF(C9=\"\",\"\",C9)","v":""},{"$f":"IF(C10=\"\",\"\",C10)","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"C12","v":""},{"$f":"D12","v":""},"",""]
[null,"対象者",null,null,null,null,null,null,null,null,null,null,null,null,null,"設問毎：回答人数"]
[null,"回答者"]
[null,"回答率"]
[]
[null,"◆選択肢別回答人数（人）"]
[null,null,{"$f":"IF(C7=\"\",\"\",C7)","v":""},{"$f":"IF(C8=\"\",\"\",C8)","v":""},{"$f":"IF(C9=\"\",\"\",C9)","v":""},{"$f":"IF(C10=\"\",\"\",C10)","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"C18","v":""},{"$f":"D18","v":""},"",""]

{"sheet":"(記述式)","index":8,"n_rows":20,"n_cols":20,"rows_kept":20,"cut":false,"hidden":true,"merged":[[3,2,3,12],[4,2,4,12],[5,2,5,12]]}
[]
[null,"調査名"]
[null,"調査グループID"]
[null,"調査グループ名"]
[null,"設問番号"]
[null,"設問文"]
[null,"調査期間"]
[]
[]
[]
[null,"◆回答率",null,null,null,null,null,null,null,null,null,null,null,null,null,"設問毎：回答人数（未回答者含まない）記述式と数字入力のみ参照"]
[null,null,{"$f":"IF(C7=\"\",\"\",C7)","v":""},{"$f":"IF(C8=\"\",\"\",C8)","v":""},{"$f":"IF(C9=\"\",\"\",C9)","v":""},{"$f":"IF(C10=\"\",\"\",C10)","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"C12","v":""},{"$f":"D12","v":""},"",""]
[null,"対象者",null,null,null,null,null,null,null,null,null,null,null,null,null,"設問毎：回答人数"]
[null,"回答者"]
[null,"回答率"]
[]
[null,"◆設問ごと回答人数（人）"]
[null,null,{"$f":"IF(C7=\"\",\"\",C7)","v":""},{"$f":"IF(C8=\"\",\"\",C8)","v":""},{"$f":"IF(C9=\"\",\"\",C9)","v":""},{"$f":"IF(C10=\"\",\"\",C10)","v":""}]
[null,"回答者",{"$f":"IF(Q13=\"\",\"\",Q13)","v":""},{"$f":"IF(R13=\"\",\"\",R13)","v":""},{"$f":"IF(S13=\"\",\"\",S13)","v":""},{"$f":"IF(T13=\"\",\"\",T13)","v":""}]
[null,"記述式設問の回答は管理画面上でご確認ください。"]

{"sheet":"(数字入力)","index":9,"n_rows":20,"n_cols":20,"rows_kept":20,"cut":false,"hidden":true,"merged":[[3,2,3,12],[4,2,4,12],[5,2,5,12]]}
[]
[null,"調査名"]
[null,"調査グループID"]
[null,"調査グループ名"]
[null,"設問番号"]
[null,"設問文"]
[null,"調査期間"]
[]
[]
[]
[null,"◆回答率",null,null,null,null,null,null,null,null,null,null,null,null,null,"設問毎：回答人数（未回答者含まない）記述式と数字入力のみ参照"]
[null,null,{"$f":"IF(C7=\"\",\"\",C7)","v":""},{"$f":"IF(C8=\"\",\"\",C8)","v":""},{"$f":"IF(C9=\"\",\"\",C9)","v":""},{"$f":"IF(C10=\"\",\"\",C10)","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"C12","v":""},{"$f":"D12","v":""},"",""]
[null,"対象者",null,null,null,null,null,null,null,null,null,null,null,null,null,"設問毎：回答人数"]
[null,"回答者"]
[null,"回答率"]
[]
[null,"◆設問ごと回答人数（人）"]
[null,null,{"$f":"IF(C7=\"\",\"\",C7)","v":""},{"$f":"IF(C8=\"\",\"\",C8)","v":""},{"$f":"IF(C9=\"\",\"\",C9)","v":""},{"$f":"IF(C10=\"\",\"\",C10)","v":""}]
[null,"回答者",{"$f":"IF(Q13=\"\",\"\",Q13)","v":""},{"$f":"IF(R13=\"\",\"\",R13)","v":""},"",""]
[null,"数字入力設問の回答は管理画面上でご確認ください。"]