{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["メニュー","問題登録","ひな形","CSV定義","改版履歴"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":1,"comments":4,"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":74,"n_cols":18,"rows_kept":74,"cut":false,"hidden":false,"merged":[[11,2,11,3],[2,2,2,6],[1,15,1,17],[2,12,2,17],[22,4,22,5]]}
[]
[null,null,null,null,null,null,"V3.3"]
[null,null,"コラボプラザ　Ｗｅｂ試験システム　問題登録　メニュー"]
[null,null,null,null,null,null,null,null,null,null,null,"当問題登録EXCELツールの設定"]
[null,null,null,null,null,null,null,null,null,null,null,null,"下記コンスタント値は、S1000_iniで、設定している",null,null,null,"PG側","設定ｱﾗｰﾑ"]
["１．問題登録操作手順",null,null,null,null,null,null,null,null,null,null,null,"問題データ ホルダ名","csv",null,null,"N6",{"$f":"IF(CHAR(64+CELL(\"col\",N6))&ROW(N6) <> Q6,\"変更要\",\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,"ファイル名","cpws_mondai_csv_",null,null,"N7",""]
[null,null,null,null,null,null,null,null,null,null,null,null,"ファイル名表示セルアドレス","E25",null,null,"N8",""]
[null,"１－１．問題登録（このEXCELシート操作）",null,null,null,null,null,null,null,null,null,null,"実行日時セルアドレス","E23",null,null,"N9",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N10",""]
[null,null,null,null,null,null,null,null,null,null,null,null,"問題明細行MAX",5000,"明細行までしかLoopさせない",null,"N11",""]
[null,null,"（１）問題登録／修正",null,null,null,null,null,null,null,null,null,"合計件数セルアドレス","F17",null,null,"N12",""]
[null,null,null,null,null,null,null,null,null,null,null,null,"エラー数セルアドレス","G17",null,null,"N13",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N14",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N15"]
[null,null,"（２）問題NO採番",null,null,"問題数",null,null,null,null,null,null,"#START#行",3,null,null,"N16"]
[null,null,null,null,null,2,null,null,null,null,null,null,"ひな形行(Copy元)","6:20",null,null,"N17"]
[null,null,null,null,null,null,null,null,null,null,null,null,"ひな形copy行数",{"$f":"ひな形!B21","v":15},null,null,"N18"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N19"]
[null,null,"（３）問題ＣＳＶ出力",null,null,null,null,null,null,null,null,null,null,null,null,null,"N20"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N21"]
[]
[null,null,null,"CSV出力処理日時","2021-12-29T16:43:07",null,null,null,null,null,null,"問題形式",1,"n択"]
[null,null,null,null,null,null,null,null,null,null,null,null,2,"Yes/No"]
[null,null,null,"ファイル名","cpws_mondai_csv_20211229164307.csv",null,null,null,null,null,null,null,3,"複数選択"]
[null,null,null,null,null,null,null,null,null,null,null,null,4,"穴埋め（V3未ｻﾎﾟｰﾄ）"]
[null,null,null,null,null,null,null,null,null,null,null,null,5,"記述式"]
[]
[null,"１－２．Ｗｅｂ試験システム　管理画面　での操作"]
[]
[]
[null,null,"問題ＣＳＶファイルを、システムに取り込む。"]
[]
[]
[]
[]
["２．当EXCELシート説明"]
[]
[null,"No","シート名","シート説明"]
[null,1,"メニュー","問題登録メニュー＆EXCELブック概要説明"]
[null,2,"問題登録","問題登録用シート"]
[null,3,"ひな形","１問題ひな形・入力サンプル　等"]
[null,4,"CSV定義","CSV出力レコード定義"]
[null,null,null,null,null,null,null,null,"疑"]
[]
["３．問題登録についての手順説明"]
[]
[null,"３－１．「問題登録」シートへの問題登録"]
[null,null,"☑ 新規登録時は、「問題登録」シートの全問題をクリアする。"]
[null,null,"☑ 「ひな形」シートにある問題ひな形を、問題数分追加することもできる。"]
[null,null,"　　（「問題登録」シートの#END#行に「問題追加」ボタンにて）"]
[null,null,"☑ 問題登録シート全体に対して「カテゴリー名」を付ける。（４行目）"]
[]
[null,"３－２．メニューから、「問題No採番」ボタンをクリックし、実行"]
[]
[null,"３－３．「問題登録」シートへの登録内容のチェック"]
[null,null,"☑ 問題文の文章表現は適切か"]
[null,null,"☑ 正解の指定ミスがないか"]
[]
[null,"３－４．メニューから、「ＣＳＶ出力」ボタンをクリックし、ＣＳＶファイル作成"]
[null,null,null,null,"（CSVは、UTF-8形式）"]
[null,"３－５．Ｗｅｂ試験システム管理画面での操作"]
[]
[null,null,"（１）カテゴリーの新規登録"]
[]
[null,null,"　　「問題登録」シートに入力したカテゴリー名を、システムに新規登録"]
[]
[null,null,"（２）ＣＳＶファイルを、「問題一括登録」"]
[]
[]
["４．その他（注意事項等）"]
[]
[null,"・現バージョンは、問題形式：穴埋め について、サポートできておりません。"]
[null,"（穴埋め方式を利用する場合は、管理画面の問題登録から行ってください）"]

{"sheet":"問題登録","index":1,"n_rows":155,"n_cols":5,"rows_kept":155,"cut":false,"hidden":false,"merged":[[3,0,3,1]]}
["コラボプラザ　Ｗｅｂ試験システム　問題登録シート"]
[]
[]
["カテゴリー名",null,"検定本 第1章"]
["No","項目名","内容","形式\n正解","備考"]
[1,"$タイトル","酵素ファスティングって何？",1,{"$f":"VLOOKUP(D6,メニュー!M$23:N$27,2,FALSE)","v":"n択"}]
[null,"$問題文","体内では約何％のエネルギーが消化に使われているのか、正しいものを一つ選びなさい。"]
[null,"$選択1","約10％"]
[null,"$選択2","約30%"]
[null,"$選択3","約50%"]
[null,"$選択4","約80%",1]
[null,"$選択5","winter"]
[null,"$識別1","エネルギー"]
[null,"$識別2","消化"]
[null,"$識別3"]
[null,"$識別4"]
[null,"$識別5"]
[null,"$事前"]
[null,"$解説"]
[null,"$備考"]
[2,"$タイトル","酵素ファスティングって何？",2,{"$f":"VLOOKUP(D21,メニュー!M$23:N$27,2,FALSE)","v":"Yes/No"}]
[null,"$問題文","酵素ファスティングは、食事の代わりにどのような方法で行うのか、正しいものを一つ選びなさい。"]
[null,"$選択1","水のみの摂取"]
[null,"$選択2","野菜ジュースと塩のみの摂取"]
[null,"$選択3","酵素ドリンクと水のみの摂取",1]
[null,"$選択4","全く何も身体に入れない"]
[null,"$識別1","酵素ファスティング"]
[null,"$識別2","代わり"]
[null,"$識別3"]
[null,"$識別4"]
[null,"$識別5"]
[null,"$事前"]
[null,"$解説"]
[null,"$備考"]
[null,"$タイトル","酵素ファスティングって何？",1,{"$f":"VLOOKUP(D35,メニュー!M$23:N$27,2,FALSE)","v":"n択"}]
[null,"$問題文","酵素ファスティングの魅力として正しいものを一つ選びなさい。"]
[null,"$選択1","身体に必要な栄養素がなくても、酵素ファスティングが実施できる"]
[null,"$選択2","体内の傷ついた細胞をメンテナンスすることができる",1]
[null,"$選択3","消化器官を働かせ、体内酵素を分泌させることができる"]
[null,"$選択4","病気の予防のみに効果が期待できる健康法である"]
[null,"$選択5"]
[null,"$識別1","酵素ファスティング"]
[null,"$識別2","魅力"]
[null,"$識別3"]
[null,"$識別4"]
[null,"$識別5"]
[null,"$事前"]
[null,"$解説"]
[null,"$備考"]
[null,"$タイトル","酵素ファスティングって何？",1,{"$f":"VLOOKUP(D50,メニュー!M$23:N$27,2,FALSE)","v":"n択"}]
[null,"$問題文","酵素について正しい文章を一つ選びなさい。"]
[null,"$選択1","体内酵素には消化吸収に関わる「代謝酵素」がある"]
[null,"$選択2","体内酵素は年齢とともに分泌が盛んに行われる"]
[null,"$選択3","どんな食品の調理方法であっても、代謝酵素が不足する心配はない"]
[null,"$選択4","人間の生命活動になくてはならないものは「酵素」である",1]
[null,"$選択5"]
[null,"$識別1","酵素"]
[null,"$識別2","体内酵素"]
[null,"$識別3","代謝酵素"]
[null,"$識別4"]
[null,"$識別5"]
[null,"$事前"]
[null,"$解説"]
[null,"$備考"]
[null,"$タイトル","酵素ファスティングって何？",1,{"$f":"VLOOKUP(D65,メニュー!M$23:N$27,2,FALSE)","v":"n択"}]
[null,"$問題文","酵素ファスティングの目的として正しい文章を一つ選びなさい。"]
[null,"$選択1","体内で毒素が蓄積しても身体の機能は正常に働き続ける"]
[null,"$選択2","毒素の蓄積と肌トラブルとの関連は考えられていない"]
[null,"$選択3","毒素の蓄積は栄養素の吸収率と深い関りがある",1]
[null,"$選択4","運動をしっかり行っていれば体内に毒素が蓄積することはない"]
[null,"$選択5"]
[null,"$識別1","毒素"]
[null,"$識別2","蓄積"]
[null,"$識別3"]
[null,"$識別4"]
[null,"$識別5"]
[null,"$事前"]
[null,"$解説"]
[null,"$備考"]
[null,"$タイトル","酵素ファスティングって何？",1,{"$f":"VLOOKUP(D80,メニュー!M$23:N$27,2,FALSE)","v":"n択"}]
[null,"$問題文","酵素ファスティングで得られる効果の一つについて正しい文章を一つ選びなさい。"]
[null,"$選択1","白血球が正常化し、免疫力を高めることを「血液浄化」と呼ぶ"]
[null,"$選択2","コレステロール値が下がり、血液がサラサラになることを「肺の浄化」と呼ぶ"]
[null,"$選択3","脂肪に溜まった毒素を取り除くことを「肝臓の浄化」と呼ぶ"]
[null,"$選択4","脳の毒素を浄化し思考がスッキリすることを「思考能力の向上」と呼ぶ",1]
[null,"$選択5"]
[null,"$識別1","酵素ファスティング"]
[null,"$識別2","効果"]
[null,"$識別3"]
[null,"$識別4"]
[null,"$識別5"]
[null,"$事前"]
[null,"$解説"]
[null,"$備考"]
[null,"$タイトル","酵素ファスティングって何？",1,{"$f":"VLOOKUP(D95,メニュー!M$23:N$27,2,FALSE)","v":"n択"}]
[null,"$問題文","酵素ファスティングに向いていない方について正しい文章を一つ選びなさい。"]
[null,"$選択1","体質改善を目指す糖尿病患者",1]
[null,"$選択2","食べすぎが気になる40代男性"]
[null,"$選択3","ストレスが多くイライラしがちな30代男性"]
[null,"$選択4","最近便秘気味の20代女性"]
[null,"$選択5"]
[null,"$識別1","酵素ファスティング"]
[null,"$識別2","向いていない方"]
[null,"$識別3"]
[null,"$識別4"]
[null,"$識別5"]
[null,"$事前"]
[null,"$解説"]
[null,"$備考"]
[null,"$タイトル","酵素ファスティングって何？",1,{"$f":"VLOOKUP(D110,メニュー!M$23:N$27,2,FALSE)","v":"n択"}]
[null,"$問題文","ファスティングを始めて２～３日経つと、脂肪細胞からどのようなホルモンが分泌されるのか、正しいものを一つ選びなさい。"]
[null,"$選択1","インスリン"]
[null,"$選択2","バソプレシン"]
[null,"$選択3","アディポネクチン",1]
[null,"$選択4","ノルアドレナリン"]
[null,"$選択5"]
[null,"$識別1","脂肪細胞"]
[null,"$識別2","ホルモン"]
[null,"$識別3"]
[null,"$識別4"]
[null,"$識別5"]
[null,"$事前"]
[null,"$解説"]
[null,"$備考"]
[null,"$タイトル","酵素ファスティングって何？",1,{"$f":"VLOOKUP(D125,メニュー!M$23:N$27,2,FALSE)","v":"n択"}]
[null,"$問題文","有害物質は、体内のどの部分に溜まりやすくなるのか、正しいものを一つ選びなさい。"]
[null,"$選択1","髪の毛"]
[null,"$選択2","脂肪細胞",1]
[null,"$選択3","眼球"]
[null,"$選択4","手足の指"]
[null,"$選択5"]
[null,"$識別1","有害物質"]
[null,"$識別2","溜まりやすく"]
[null,"$識別3"]
[null,"$識別4"]
[null,"$識別5"]
[null,"$事前"]
[null,"$解説"]
[null,"$備考"]
[null,"$タイトル","酵素ファスティングって何？",1,{"$f":"VLOOKUP(D140,メニュー!M$23:N$27,2,FALSE)","v":"n択"}]
[null,"$問題文","ファスティングによりもたらされる５大デトックス効果について、誤っているものを一つ選びなさい。"]
[null,"$選択1","脂肪の中の有害物質が血中に排出される"]
[null,"$選択2","肝臓の機能が向上し、解毒力を高める"]
[null,"$選択3","余分な水分が失われ身体が軽くなる",1]
[null,"$選択4","代謝酵素の働きを高め、身体の浄化、修復を行う"]
[null,"$選択5"]
[null,"$識別1","5大デトックス効果"]
[null,"$識別2","ファスティング"]
[null,"$識別3"]
[null,"$識別4"]
[null,"$識別5"]
[null,"$事前"]
[null,"$解説"]
[null,"$備考"]
["#END#",null,{"$f":"IF(D155>メニュー!N11,\"エラー：作成行数オーバー\",\"\")","v":""},{"$f":"ROW()","v":155}]

{"sheet":"ひな形","index":2,"n_rows":102,"n_cols":5,"rows_kept":102,"cut":false,"hidden":false,"merged":[[0,0,0,1],[90,2,90,4],[91,2,91,4],[92,2,92,4],[3,0,3,1],[85,2,85,4],[86,2,86,4],[87,2,87,4],[88,2,88,4],[89,2,89,4]]}
["メニューへ戻る"]
["１．ひな形",null,"（下記を行コピーして、問題登録シートに張り付ける）"]
[]
["カテゴリー名"]
["No","項目名","内容","形式\n正解","備考"]
[null,"$タイトル",null,1,{"$f":"VLOOKUP(D6,メニュー!M$23:N$27,2,FALSE)","v":"n択"}]
[null,"$問題文"]
[null,"$選択1"]
[null,"$選択2"]
[null,"$選択3"]
[null,"$選択4"]
[null,"$選択5"]
[null,"$識別1"]
[null,"$識別2"]
[null,"$識別3"]
[null,"$識別4"]
[null,"$識別5"]
[null,"$事前"]
[null,"$解説"]
[null,"$備考"]
[null,{"$f":"ROW()-ROW(B6)","v":15}]
["下記は、サンプル問題データです。"]
[1,"$タイトル","季節の英語問題",1,{"$f":"VLOOKUP(D23,メニュー!M$23:N$27,2,FALSE)","v":"n択"}]
[null,"$問題文","下記の英単語の中で、季節を表していないものはどれか。\n正解を１つ選んでください。"]
[null,"$選択1","spring"]
[null,"$選択2","summer"]
[null,"$選択3","Sunday",1]
[null,"$選択4","Autumn"]
[null,"$選択5","winter"]
[null,"$識別1","季節"]
[null,"$識別2","英語"]
[null,"$識別3"]
[null,"$識別4"]
[null,"$識別5"]
[null,"$事前"]
[null,"$解説"]
[null,"$備考"]
[2,"$タイトル","季節の英語問題",2,{"$f":"VLOOKUP(D38,メニュー!M$23:N$27,2,FALSE)","v":"Yes/No"}]
[null,"$問題文","「夏」は、英語で、「summer」です。〇か×か。",1]
[null,"$選択1"]
[null,"$選択2"]
[null,"$選択3"]
[null,"$選択4"]
[null,"$選択5"]
[null,"$識別1","季節"]
[null,"$識別2","英語"]
[null,"$識別3"]
[null,"$識別4"]
[null,"$識別5"]
[null,"$事前"]
[null,"$解説"]
[null,"$備考"]
[3,"$タイトル","季節の英語問題",3,{"$f":"VLOOKUP(D53,メニュー!M$23:N$27,2,FALSE)","v":"複数選択"}]
[null,"$問題文","下記の英単語の中で、季節を表しているものはどれか。\n正解をすべて選んでください。"]
[null,"$選択1","spring",1]
[null,"$選択2","summer",1]
[null,"$選択3","Sunday"]
[null,"$選択4","Autumn",1]
[null,"$選択5","winter",1]
[null,"$識別1","季節"]
[null,"$識別2","英語"]
[null,"$識別3"]
[null,"$識別4"]
[null,"$識別5"]
[null,"$事前"]
[null,"$解説"]
[null,"$備考"]
[4,"$タイトル","記述式で正解解答あり",5,{"$f":"VLOOKUP(D68,メニュー!M$23:N$27,2,FALSE)","v":"記述式"}]
[null,"$問題文","カタカナの「アイウエオ」ひらがなで書くとどうなるか"]
[null,"$選択1","あいうえお"]
[null,"$選択2"]
[null,"$選択3"]
[null,"$選択4"]
[null,"$選択5"]
[null,"$識別1","記述式"]
[null,"$識別2"]
[null,"$識別3"]
[null,"$識別4"]
[null,"$識別5"]
[null,"$事前"]
[null,"$解説"]
[null,"$備考"]
[]
["２．項目説明"]
["No","項目名","項目の説明"]
[1,"カテゴリー名","１つの問題登録シート全問のカテゴリー名称。\n問題ＣＳＶからの一括登録時、指定のカテゴリー名の配下に全問が登録される"]
[2,"No","入力不要。「問題No採番」ボタンで、自動で番号が表示される"]
[3,"$タイトル","問題のタイトル。問題修正時の一覧画面に表示される。設問画面には表示されない。\nタイトル欄未入力の場合は、問題文の先頭３０文字が自動でＣＳＶにセットされる"]
[4,"$問題文","設問画面に表示される。複数行入力可。"]
[5,"$選択1～5","ｎ択・複数選択のときの選択候補。長文でも可"]
[6,"$識別1～5","問題を識別するためのキーワード。０～５つ"]
[7,"$事前","事前学習画面に表示される。複数行入力可。"]
[8,"$解説","解説画面に表示される。複数行入力可。"]
[9,"形式","（$タイトル行部分）問題形式を、左記の英字１文字で入力",{"$f":"メニュー!M23","v":1},{"$f":"メニュー!N23","v":"n択"}]
[null,null,null,{"$f":"メニュー!M24","v":2},{"$f":"メニュー!N24","v":"Yes/No"}]
[null,null,null,{"$f":"メニュー!M25","v":3},{"$f":"メニュー!N25","v":"複数選択"}]
[null,null,null,{"$f":"メニュー!M26","v":4},{"$f":"メニュー!N26","v":"穴埋め（V3未ｻﾎﾟｰﾄ）"}]
[null,null,null,{"$f":"メニュー!M27","v":5},{"$f":"メニュー!N27","v":"記述式"}]
[10,"正解","ｎ択・複数選択のときの選択候補に対して、正解部分に 1 を入力する","（半角数字）"]
[null,null,"Yes/Noのときは、$問題文の行に、y n を入力する"]
[11,"画像ファイル名（V3未サポート）"]
[null,null,"項目に対応した画像ファイル名。\nV3では、画像ファイルの自動取り込みは行わない。（備考欄でしかない）"]

{"sheet":"CSV定義","index":3,"n_rows":21,"n_cols":26,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["メニューへ戻る"]
[]
["（１）ヘッダ・レコード"]
[]
["開始セル","データ区分","問題数","カテゴリー名","EXCELファイル名"]
["B6","s",{"$f":"メニュー!$F$17","v":2},{"$f":"問題登録!C4","v":"検定本 第1章"},{"$f":"MID(CELL(\"filename\"),FIND(\"[\",CELL(\"filename\"))+1,FIND(\"]\",CELL(\"filename\"))-FIND(\"[\",CELL(\"filename\"))-1)","v":{"$error":"#N/A"}}]
[{"$f":"IF(CHAR(64+CELL(\"col\",B6))&ROW(B6) <> A6,\"変更要\",\"\")","v":""}]
[]
[]
["（２）問題レコード",null,"項目数",{"$f":"COLUMN(Z13)-COLUMN(B13)+1","v":25},"←「データ区分」～「END」列までの項目数"]
[null,null,"問題登録シート行番号",21,null,"o_col+→",5,null,null,null,null,10,null,null,null,null,15,16,17]
["開始セル","データ区分","問題形式","タイトル","問題文","正解","選択1","選択2","選択3","選択4","選択5","識別1","識別2","識別3","識別4","識別5","事前","解説","備考","画像_問題文","画像_選択1","画像_選択2","画像_選択3","画像_選択4","画像_選択5","end"]
["B13",2,2,"季節の英語問題　Ⅱ②","「夏」は、英語で、「summer」です。\n特殊：！”＃＄％＆’（）＝～\n〇か×か。",1,null,null,null,null,null,"季節","英語"]
[{"$f":"IF(CHAR(64+CELL(\"col\",B13))&ROW(B13) <> A13,\"変更要\",\"\")","v":""}]
[null,"出力中レコードNo"]
[]
["（３）エンド・レコード"]
[]
["開始セル","データ区分","問題数"]
["B20","e",{"$f":"メニュー!$F$17","v":2}]
[{"$f":"IF(CHAR(64+CELL(\"col\",B20))&ROW(B20) <> A20,\"変更要\",\"\")","v":""}]

{"sheet":"改版履歴","index":4,"n_rows":8,"n_cols":3,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["cpws_試験問題一括登録シート　改版履歴"]
[]
[]
["2021-06-06","V3.2","問題サンプルデータの変更"]
[null,null,"問題登録ｓ－ト「問題追加」ボタン不具合修正"]
["2021-11-30","V3.3","CSV出力ファイルの文字コード変更 S-JIS⇒UTF-8"]
[]
["2022-09-01","V3.3.1","穴埋め方式は未適用　コメント追記"]