{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["成績表","解答入力","使い方","CA"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":12,"n_cols":14,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,0,1,9],[1,10,2,12],[1,13,2,13],[11,0,11,1],[11,2,11,3],[7,0,8,3],[3,1,4,2],[9,0,10,1],[9,2,10,3],[3,13,4,13],[2,0,2,3],[2,4,2,6],[2,7,2,9],[3,8,4,8],[3,5,4,5],[3,11,4,11]]}
[]
["得点区分別得点　Scores by Scoring Section",null,null,null,null,null,null,null,null,null,"総合得点\nTotal Score",null,null,"合格評価"]
["言語知識（文字・語彙・文法）\nLanguage Knowledge (Vocabulary / Grammar)",null,null,null,"読解\nReading",null,null,"聴解\nListening"]
[null,{"$f":"ROUNDDOWN(SUM(解答入力!P5:P29)/54*60, 0) - MOD(ROUNDDOWN(SUM(解答入力!P5:P29)/54*60, 0), 5)","v":0},null,null,null,{"$f":"ROUNDDOWN(SUM(解答入力!P32:P44)/21*60, 0) - MOD(ROUNDDOWN(SUM(解答入力!P32:P44)/21*60, 0), 5)","v":0},null,null,{"$f":"ROUNDDOWN(SUM(解答入力!P49:P61)/33*60, 0) - MOD(ROUNDDOWN(SUM(解答入力!P49:P61)/33*60, 0), 5)","v":0},null,null,{"$f":"B4+F4+I4","v":0},null,{"$f":"IF(L4/180<=0.4, \"～40%\", IF(L4/180>=0.8, \"80%～\", TEXT((ROUNDUP(L4/180*10-0.5,0)*10)/100,\"0%\")))","v":"～40%"}]
[null,null,null,"/60",null,null,"/60",null,null,"/60",null,null,"/180"]
[]
[]
["参考情報\nReference Information",null,null,null,null,null,"※N2の合格点は90点です。"]
[null,null,null,null,null,null,"※区分ごとの基準点（N2：言語知識19点、読解19点、聴解19点）を下回ると、合格点を超えていても不合格になります。"]
["文字・語彙\nVocabulary",null,"文法\nGrammar",null,null,null,"※本模試の採点および合格基準はアスク出版独自のもので、実際の試験とは異なります。"]
[]
[{"$f":"IF(SUM(解答入力!P5:P20)/32>=0.67, \"A\", IF(SUM(解答入力!P5:P20)/32>=0.34, \"B\", \"C\"))","v":"C"},null,{"$f":"IF(SUM(解答入力!P23:P29)/22>=0.67, \"A\", IF(SUM(解答入力!P23:P29)/22>=0.34, \"B\", \"C\"))","v":"C"}]

{"sheet":"解答入力","index":1,"n_rows":61,"n_cols":17,"rows_kept":61,"cut":false,"hidden":false,"merged":[[58,0,60,0],[20,0,22,0],[23,0,25,0],[26,0,28,0],[29,0,31,0],[32,0,34,0],[35,0,37,0],[38,0,40,0],[46,0,48,0],[49,0,51,0],[52,0,54,0],[55,0,57,0],[41,0,43,0],[17,0,19,0],[2,0,4,0],[5,0,7,0],[8,0,10,0],[11,0,13,0],[14,0,16,0]]}
["これ一冊N2模擬試験"]
["言語知識（文字・語彙・文法）・読解"]
["問題１","問題番号",1,2,3,4,5]
[null,"解答番号"]
[null,"正誤判定",null,null,null,null,null,null,null,null,null,null,null,null,"正答数：",{"$f":"COUNTIF(C5:N5, \"〇\")","v":0},"／5問"]
["問題２","問題番号",6,7,8,9,10]
[null,"解答番号"]
[null,"正誤判定",null,null,null,null,null,null,null,null,null,null,null,null,"正答数：",{"$f":"COUNTIF(C8:N8, \"〇\")","v":0},"／5問"]
["問題３","問題番号",11,12,13,14,15]
[null,"解答番号"]
[null,"正誤判定",null,null,null,null,null,null,null,null,null,null,null,null,"正答数：",{"$f":"COUNTIF(C11:N11, \"〇\")","v":0},"／5問"]
["問題４","問題番号",16,17,18,19,20,21,22]
[null,"解答番号"]
[null,"正誤判定",null,null,null,null,null,null,null,null,null,null,null,null,"正答数：",{"$f":"COUNTIF(C14:N14, \"〇\")","v":0},"／7問"]
["問題５","問題番号",23,24,25,26,27]
[null,"解答番号"]
[null,"正誤判定",null,null,null,null,null,null,null,null,null,null,null,null,"正答数：",{"$f":"COUNTIF(C17:N17, \"〇\")","v":0},"／5問"]
["問題６","問題番号",28,29,30,31,32]
[null,"解答番号"]
[null,"正誤判定",null,null,null,null,null,null,null,null,null,null,null,null,"正答数：",{"$f":"COUNTIF(C20:N20, \"〇\")","v":0},"／5問"]
["問題７","問題番号",33,34,35,36,37,38,39,40,41,42,43,44]
[null,"解答番号"]
[null,"正誤判定",null,null,null,null,null,null,null,null,null,null,null,null,"正答数：",{"$f":"COUNTIF(C23:N23, \"〇\")","v":0},"／12問"]
["問題８","問題番号",45,46,47,48,49]
[null,"解答番号"]
[null,"正誤判定",null,null,null,null,null,null,null,null,null,null,null,null,"正答数：",{"$f":"COUNTIF(C26:N26, \"〇\")","v":0},"／5問"]
["問題９","問題番号",50,51,52,53,54]
[null,"解答番号"]
[null,"正誤判定",null,null,null,null,null,null,null,null,null,null,null,null,"正答数：",{"$f":"COUNTIF(C29:N29, \"〇\")","v":0},"／5問"]
["問題10","問題番号",55,56,57,58,59]
[null,"解答番号"]
[null,"正誤判定",null,null,null,null,null,null,null,null,null,null,null,null,"正答数：",{"$f":"COUNTIF(C32:N32, \"〇\")","v":0},"／5問"]
["問題11","問題番号",60,61,62,63,64,65,66,67,68]
[null,"解答番号"]
[null,"正誤判定",null,null,null,null,null,null,null,null,null,null,null,null,"正答数：",{"$f":"COUNTIF(C35:N35, \"〇\")","v":0},"／9問"]
["問題12","問題番号",69,70]
[null,"解答番号"]
[null,"正誤判定",null,null,null,null,null,null,null,null,null,null,null,null,"正答数：",{"$f":"COUNTIF(C38:N38, \"〇\")","v":0},"／2問"]
["問題13","問題番号",71,72,73]
[null,"解答番号"]
[null,"正誤判定",null,null,null,null,null,null,null,null,null,null,null,null,"正答数：",{"$f":"COUNTIF(C41:N41, \"〇\")","v":0},"／3問"]
["問題14","問題番号",74,75]
[null,"解答番号"]
[null,"正誤判定",null,null,null,null,null,null,null,null,null,null,null,null,"正答数：",{"$f":"COUNTIF(C44:N44, \"〇\")","v":0},"／2問"]
[]
["聴解"]
["問題１","問題番号",1,2,3,4,5]
[null,"解答番号"]
[null,"正誤判定",null,null,null,null,null,null,null,null,null,null,null,null,"正答数：",{"$f":"COUNTIF(C49:N49, \"〇\")","v":0},"／5問"]
["問題２","問題番号",1,2,3,4,5,6]
[null,"解答番号"]
[null,"正誤判定",null,null,null,null,null,null,null,null,null,null,null,null,"正答数：",{"$f":"COUNTIF(C52:N52, \"〇\")","v":0},"／6問"]
["問題３","問題番号",1,2,3,4,5]
[null,"解答番号"]
[null,"正誤判定",null,null,null,null,null,null,null,null,null,null,null,null,"正答数：",{"$f":"COUNTIF(C55:N55, \"〇\")","v":0},"／5問"]
["問題４","問題番号",1,2,3,4,5,6,7,8,9,10,11,12]
[null,"解答番号"]
[null,"正誤判定",null,null,null,null,null,null,null,null,null,null,null,null,"正答数：",{"$f":"COUNTIF(C58:N58, \"〇\")","v":0},"／12問"]
["問題５","問題番号",1,2,"3(1)","3(2)"]
[null,"解答番号"]
[null,"正誤判定",null,null,null,null,null,null,null,null,null,null,null,null,"正答数：",{"$f":"COUNTIF(C61:N61, \"〇\")","v":0},"／4問"]

{"sheet":"使い方","index":2,"n_rows":34,"n_cols":1,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
["使い方"]
["1.　「解答入力」シートの「解答番号」の行（色のついた行）に、自分の解答番号を入力する"]
["2.　解答番号の入力がすべて終わったら、一番上の「採点する」ボタンを押す"]
["3.　「採点する」ボタンを押したら、問題ごとの正誤判定がされるとともに、「成績表」シートに点数が出る"]
["4.　「採点クリア」ボタンを押すと、正誤判定がすべてクリアされる"]
["5.　「解答クリア」ボタンを押すと、入力した解答がすべてクリアされる"]
[]
["注意事項"]
["本模試の採点および合格基準はアスク出版独自のもので、実際の試験とは異なります。"]
[]
["本ファイルはマクロを使用しています。"]
["Webからダウンロードした直後は、セキュリティの関係でマクロが無効になっている場合があります。"]
["正しく動作しない場合は、以下の手順をお試しください。"]
["1.　一度Excelを閉じて、このファイルを右クリック"]
["2.　「プロパティ」を開く"]
["3.　「全般」タブの一番下にある「ブロックの解除（許可する）」にチェックを入れて、「適用」→「OK」"]
["4.　再度ファイルを開き、上部に表示される「コンテンツの有効化」をクリック"]
[]
["How to Use"]
["1. On the \"解答入力\" sheet, enter your answer numbers in the \"Answer Number\" rows (the colored rows)."]
["2. Once you’ve finished entering all your answers, click the \"採点する\" button at the top."]
["3. After clicking the \"採点する\" button, each answer will be marked as correct or incorrect, and your total score will appear on the \"成績表\" sheet."]
["4. To clear all the grading results, click the \"採点クリア\" button."]
["5. To clear all entered answers, click the \"解答クリア\" button."]
[]
["Important Notice"]
["The scoring and passing criteria of this mock exam are set independently by ASK publishing and differ from those of the actual exam."]
[]
["This file contains macros."]
["If macros are disabled after downloading, please follow these steps:"]
["1. Close Excel, then right-click the file"]
["2. Select \"Properties\""]
["3. In the \"General\" tab, check the box labeled \"Unblock\" (near the bottom), then click \"Apply\" and \"OK\""]
["4. Reopen the file and click \"Enable Content\" if prompted"]

{"sheet":"CA","index":3,"n_rows":61,"n_cols":14,"rows_kept":61,"cut":false,"hidden":true,"merged":[]}
[]
["言語知識（文字・語彙・文法）・読解"]
["問題１","問題番号",1,2,3,4,5]
[null,"解答番号",2,4,2,1,4]
[null,"正誤判定"]
["問題２","問題番号",6,7,8,9,10]
[null,"解答番号",1,2,2,3,2]
[null,"正誤判定"]
["問題３","問題番号",11,12,13,14,15]
[null,"解答番号",1,4,3,1,3]
[null,"正誤判定"]
["問題４","問題番号",16,17,18,19,20,21,22]
[null,"解答番号",2,3,3,3,1,1,1]
[null,"正誤判定"]
["問題５","問題番号",23,24,25,26,27]
[null,"解答番号",4,1,3,2,1]
[null,"正誤判定"]
["問題６","問題番号",28,29,30,31,32]
[null,"解答番号",1,2,1,1,2]
[null,"正誤判定"]
["問題７","問題番号",33,34,35,36,37,38,39,40,41,42,43,44]
[null,"解答番号",2,2,4,1,4,2,2,4,1,2,1,2]
[null,"正誤判定"]
["問題８","問題番号",45,46,47,48,49]
[null,"解答番号",1,4,3,3,3]
[null,"正誤判定"]
["問題９","問題番号",50,51,52,53,54]
[null,"解答番号",2,4,4,1,1]
[null,"正誤判定"]
["問題10","問題番号",55,56,57,58,59]
[null,"解答番号",4,4,3,3,1]
[null,"正誤判定"]
["問題11","問題番号",60,61,62,63,64,65,66,67,68]
[null,"解答番号",4,4,2,3,2,1,4,1,3]
[null,"正誤判定"]
["問題12","問題番号",69,70]
[null,"解答番号",2,4]
[null,"正誤判定"]
["問題13","問題番号",71,72,73]
[null,"解答番号",4,1,2]
[null,"正誤判定"]
["問題14","問題番号",74,75]
[null,"解答番号",2,4]
[null,"正誤判定"]
[]
["聴解"]
["問題１","問題番号",1,2,3,4,5]
[null,"解答番号",3,4,4,4,3]
[null,"正誤判定"]
["問題２","問題番号",1,2,3,4,5,6]
[null,"解答番号",1,3,2,1,4,2]
[null,"正誤判定"]
["問題３","問題番号",1,2,3,4,5]
[null,"解答番号",1,2,3,1,4]
[null,"正誤判定"]
["問題４","問題番号",1,2,3,4,5,6,7,8,9,10,11,12]
[null,"解答番号",1,1,2,3,1,1,3,2,3,1,2,2]
[null,"正誤判定"]
["問題５","問題番号",1,2,"3(1)","3(2)"]
[null,"解答番号",3,2,1,2]
[null,"正誤判定"]