{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["基本情報","成績","統一","高校一覧"],"not_rendered":{"charts":2,"defined_names":3,"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"基本情報","index":0,"n_rows":10,"n_cols":3,"rows_kept":10}
["相原可奈",1,"女子"]
["井上由美",2,"女子"]
["上田晶子",3,"女子"]
["江藤里美",4,"女子"]
["小山博美",5,"女子"]
["加藤孝之",1,"男子"]
["木島智彦",2,"男子"]
["工藤優貴",3,"男子"]
["小林賢治",4,"男子"]
["桜井康彦",5,"男子"]

{"sheet":"成績","index":1,"n_rows":20,"n_cols":10,"rows_kept":20,"merged":[[1,1,1,2],[2,1,2,2],[4,1,4,2],[4,4,4,5],[5,1,5,2],[5,4,5,5]]}
[]
[null,"名前",null,"性別","番号","テスト","判定","統一","点数","公立"]
[{"$nulls":3},{"$f":"IF(B3=\"\",\"\",VLOOKUP(B3,基本情報!A:C,3,0))","v":""},{"$f":"IF(B3=\"\",\"\",VLOOKUP(B3,基本情報!A:C,2,0))","v":""},"統一","偏差値","全県","偏差値","私立"]
[]
[null,"公立高校",null,"基準","私立高校",null,"基準"]
[{"$nulls":3},{"$f":"IF(B6=\"\",\"\",VLOOKUP(B6,高校一覧!A2:B39,2,0))","v":""},null,null,{"$f":"IF(E6=\"\",\"\",VLOOKUP(E6,高校一覧!D2:E37,2,0))","v":""},null,{"$f":"IF(I5=\"公立\",D6,IF(I5=\"私立\",G6,100))","v":100}]
[]
[null,"回数","国語","数学","社会","理科","英語","３科計","５科計"]
[null,1,{"$f":"IF($B$3=\"\",0,VLOOKUP(C$8,INDIRECT($F$3&\"!$\"&IF($G$3=\"点数\",\"B\",\"M\")&9*$B9-7&\":$\"&IF($G$3=\"点数\",\"K\",\"V\")&9*$B9-1),$E$3+IF($D$3=\"女子\",1,6),0))","v":0},{"$f":"IF($B$3=\"\",0,VLOOKUP(D$8,INDIRECT($F$3&\"!$\"&IF($G$3=\"点数\",\"B\",\"M\")&9*$B9-7&\":$\"&IF($G$3=\"点数\",\"K\",\"V\")&9*$B9-1),$E$3+IF($D$3=\"女子\",1,6),0))","v":0},0,0,0,0,0]
[null,2,{"$f":"IF($B$3=\"\",0,VLOOKUP(C$8,INDIRECT($F$3&\"!$\"&IF($G$3=\"点数\",\"B\",\"M\")&9*$B10-7&\":$\"&IF($G$3=\"点数\",\"K\",\"V\")&9*$B10-1),$E$3+IF($D$3=\"女子\",1,6),0))","v":0},0,0,0,0,0,0]
[null,3,0,0,0,0,0,0,0]
[null,4,0,0,0,0,0,0,0]
[null,5,0,0,0,0,0,0,0]
[null,6,0,0,0,0,0,0,0]
[null,7,0,0,0,0,0,0,0]
[null,8,0,0,0,0,0,0,0]
[null,9,0,0,0,0,0,0,0]
[null,10,0,0,0,0,0,0,0]
[]
[null,"AVG",{"$f":"AVERAGE(C15:C17)","v":{"v":0,"d":"0.0"}},{"$f":"AVERAGE(D15:D17)","v":{"v":0,"d":"0.0"}},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"}]

{"sheet":"統一","index":2,"n_rows":90,"n_cols":22,"rows_kept":90}
[]
[1,"国語",51,85,42,59,null,47,45,35,26,null,"国語",45,63,41,40,46,43,42,37,32]
[null,"数学",40,56,44,null,null,69,38,62,38,null,"数学",44,52,46,56,47,58,44,55,44]
[null,"社会",26,72,44,null,null,64,30,72,20,null,"社会",36,59,45,59,53,55,38,59,33]
[null,"理科",32,58,69,null,null,67,12,63,15,null,"理科",39,52,58,64,43,57,29,55,30]
[null,"英語",32,86,30,null,null,51,46,42,25,null,"英語",40,63,39,50,52,48,46,44,37]
[null,"３科計",{"$f":"C2+C3+C6","v":123},227,116,59,0,167,129,139,89,null,"３科計",42,61,41,49,48,50,43,45,36]
[null,"５科計",{"$f":"SUM(C2:C6)","v":181},357,229,59,0,298,171,{"$f":"SUM(J2:J6)","v":274},124,null,"５科計",40,59,45,54,48,53,39,50,33]
[null,"順位",{"$f":"RANK(C8,$C$8:$K$8,0)","v":5},1,4,8,9,2,6,3,7,null,"順位",{"$f":"RANK(N8,$N$8:$V$8,0)","v":7},1,6,2,5,3,8,4,9]
[]
[{"$f":"A2+1","v":2},"国語",41,58,47,null,null,50,48,53,36,null,"国語",43,54,47,42,49,49,47,51,40]
[null,"数学",26,64,52,null,null,62,50,68,41,null,"数学",38,57,51,52,49,56,50,59,45]
[null,"社会",48,74,48,null,null,66,38,78,31,null,"社会",47,60,47,62,45,56,42,62,38]
[null,"理科",43,82,64,null,null,71,48,71,34,null,"理科",42,61,52,55,48,55,44,55,37]
[null,"英語",49,78,28,null,null,69,45,66,21,null,"英語",47,60,37,56,44,56,45,54,34]
[null,"３科計",{"$f":"C11+C12+C15","v":116},200,127,0,0,181,143,{"$f":"J11+J12+J15","v":187},98,null,"３科計",42,58,44,51,47,54,47,55,38]
[null,"５科計",{"$f":"SUM(C11:C15)","v":207},356,239,0,0,318,229,{"$f":"SUM(J11:J15)","v":336},163,null,"５科計",42,60,46,55,47,55,45,57,37]
[null,"順位",{"$f":"RANK(C17,$C17:$K17,0)","v":6},1,4,8,8,3,5,2,7,null,"順位",{"$f":"RANK(N17,$N$17:$V$17,0)","v":8},1,6,3,5,3,7,2,9]
[]
[{"$f":"A11+1","v":3},"国語",61,71,53,null,null,45,65,55,36,null,"国語",54,60,50,49,45,45,57,51,39]
[null,"数学",26,51,39,null,null,49,35,43,30,null,"数学",42,54,48,56,45,53,46,50,44]
[null,"社会",26,60,42,null,null,62,46,84,30,null,"社会",39,56,47,56,46,57,49,67,41]
[null,"理科",42,69,61,null,null,55,48,60,24,null,"理科",45,57,54,55,49,51,48,53,37]
[null,"英語",34,58,26,null,null,35,42,43,17,null,"英語",46,56,42,56,49,46,49,50,39]
[null,"３科計",{"$f":"C20+C21+C24","v":121},180,118,0,0,129,142,{"$f":"J20+J21+J24","v":141},83,null,"３科計",46,57,46,54,46,48,50,50,39]
[null,"５科計",{"$f":"SUM(C20:C24)","v":189},309,221,0,0,246,236,{"$f":"SUM(J20:J24)","v":285},137,null,"５科計",44,58,48,55,47,51,49,55,38]
[null,"順位",{"$f":"RANK(C26,$C26:$K26,0)","v":6},1,5,8,8,3,4,2,7,null,"順位",{"$f":"RANK(N26,$N$26:$V$26,0)","v":8},1,6,2,7,4,5,2,9]
[]
[{"$f":"A20+1","v":4},"国語",65,62,63,61,51,48,47,53,41,null,"国語",52,51,51,50,44,42,42,45,38]
[null,"数学",44,55,34,40,50,50,38,49,43,null,"数学",49,54,44,47,52,52,46,51,48]
[null,"社会",41,66,43,50,29,79,36,77,31,null,"社会",44,56,45,48,38,62,41,61,39]
[null,"理科",35,73,68,64,64,69,46,84,43,null,"理科",38,57,55,53,53,55,44,63,42]
[null,"英語",34,79,22,57,49,62,50,62,35,null,"英語",44,64,39,54,51,56,51,56,45]
[null,"３科計",{"$f":"C29+C30+C33","v":143},196,119,158,150,160,135,{"$f":"J29+J30+J33","v":164},119,null,"３科計",48,58,43,51,49,51,46,52,43]
[null,"５科計",{"$f":"SUM(C29:C33)","v":219},335,230,272,243,308,217,{"$f":"SUM(J29:J33)","v":325},193,null,"５科計",45,58,46,51,47,55,44,56,42]
[null,"順位",{"$f":"RANK(C35,$C35:$K35,0)","v":7},1,6,4,5,3,8,2,9,null,"順位",{"$f":"RANK(N35,$N35:$V35,0)","v":7},1,6,4,5,3,8,2,9]
[]
[{"$f":"A29+1","v":5},"国語",54,72,54,57,60,60,64,49,42,null,"国語",45,56,45,47,49,49,51,42,38]
[null,"数学",37,64,40,47,49,52,46,57,40,null,"数学",45,57,46,49,50,52,49,54,46]
[null,"社会",50,75,51,60,44,65,53,72,38,null,"社会",46,59,47,51,43,54,48,57,40]
[null,"理科",54,69,46,59,54,77,40,69,36,null,"理科",49,56,45,51,49,60,43,56,51]
[null,"英語",42,66,27,49,35,38,49,29,21,null,"英語",49,59,42,52,45,47,52,43,39]
[null,"３科計",{"$f":"C38+C39+C42","v":133},202,121,153,144,150,159,{"$f":"J38+J39+J42","v":135},103,null,"３科計",46,59,44,50,48,49,51,46,40]
[null,"５科計",{"$f":"SUM(C38:C42)","v":237},346,218,272,242,292,252,{"$f":"SUM(J38:J42)","v":276},177,null,"５科計",47,58,44,50,47,53,48,51,40]
[null,"順位",{"$f":"RANK(C44,$C44:$K44,0)","v":7},1,8,4,6,2,5,3,9,null,"順位",{"$f":"RANK(N44,$N44:$V44,0)","v":6},1,8,4,6,2,5,3,9]
[]
[{"$f":"A38+1","v":6},"国語",63,68,48,55,57,39,49,52,28,null,"国語",53,56,45,49,50,40,46,47,34]
[null,"数学",38,69,49,65,51,64,55,54,44,null,"数学",43,59,49,57,50,56,52,51,46]
[null,"社会",44,68,43,62,32,72,49,76,17,null,"社会",46,57,45,54,40,59,48,60,33]
[null,"理科",50,74,68,72,68,84,44,82,32,null,"理科",44,58,54,57,54,64,40,63,33]
[null,"英語",39,82,24,50,37,50,55,56,29,null,"英語",45,64,38,50,44,50,52,53,41]
[null,"３科計",{"$f":"C47+C48+C51","v":140},219,121,170,145,153,159,{"$f":"J47+J48+J51","v":162},101,null,"３科計",47,61,43,52,48,49,50,51,39]
[null,"５科計",{"$f":"SUM(C47:C51)","v":234},361,232,304,245,309,252,{"$f":"SUM(J47:J51)","v":320},150,null,"５科計",46,60,45,54,47,54,48,55,36]
[null,"順位",{"$f":"RANK(C53,$C53:$K53,0)","v":7},1,8,4,6,3,5,2,9,null,"順位",{"$f":"RANK(N53,$N53:$V53,0)","v":7},{"$f":"RANK(O53,$N53:$V53,0)","v":1},8,3,6,3,5,2,9]
[]
[{"$f":"A47+1","v":7},"国語",65,81,61,76,60,69,70,66,29,null,"国語",51,60,49,58,49,54,54,52,31]
[null,"数学",30,60,43,62,59,63,53,70,34,null,"数学",41,55,47,56,55,57,52,60,43]
[null,"社会",40,66,43,51,34,52,37,74,11,null,"社会",46,59,47,51,43,52,44,63,31]
[null,"理科",46,80,66,74,68,76,62,88,52,null,"理科",38,57,49,54,50,55,47,62,41]
[null,"英語",38,86,30,68,39,44,48,43,26,null,"英語",45,66,41,58,45,47,49,47,39]
[null,"３科計",{"$f":"C56+C57+C60","v":133},227,134,206,158,176,171,{"$f":"J56+J57+J60","v":179},89,null,"３科計",45,62,45,58,49,53,52,53,37]
[null,"５科計",{"$f":"SUM(C56:C60)","v":219},373,243,331,260,304,270,{"$f":"SUM(J56:J60)","v":341},152,null,"５科計",43,61,46,56,48,53,49,57,36]
[null,"順位",{"$f":"RANK(C62,$C62:$K62,0)","v":8},1,7,3,6,4,5,2,9,null,"順位",{"$f":"RANK(N62,$N62:$V62,0)","v":8},{"$f":"RANK(O62,$N62:$V62,0)","v":1},7,3,6,4,5,2,9]
[]
[{"$f":"A56+1","v":8},"国語",34,86,50,64,67,56,59,56,38,null,"国語",32,69,44,53,55,48,50,48,35]
[null,"数学",26,68,34,71,75,66,56,52,38,null,"数学",40,58,43,60,61,57,53,51,45]
[null,"社会",43,73,43,62,38,66,39,85,17,null,"社会",45,60,45,54,43,56,43,66,32]
[null,"理科",44,82,62,72,64,82,64,80,46,null,"理科",34,59,46,53,47,59,47,58,36]
[null,"英語",33,77,16,57,40,44,47,54,26,null,"英語",44,62,36,54,47,48,50,52,41]
[null,"３科計",{"$f":"C65+C66+C69","v":93},231,100,192,182,166,162,{"$f":"J65+J66+J69","v":162},102,null,"３科計",38,64,40,56,55,52,51,51,40]
[null,"５科計",{"$f":"SUM(C65:C69)","v":180},386,205,326,284,314,265,{"$f":"SUM(J65:J69)","v":327},165,null,"５科計",38,63,41,56,51,54,48,56,37]
[null,"順位",{"$f":"RANK(C71,$C71:$K71,0)","v":8},1,7,3,5,4,6,2,9,null,"順位",{"$f":"RANK(N71,$N71:$V71,0)","v":8},{"$f":"RANK(O71,$N71:$V71,0)","v":1},7,2,5,4,6,2,9]
[]
[{"$f":"A65+1","v":9},"国語",75,74,47,58,54,61,63,63,38,null,"国語",57,56,38,46,43,48,49,49,33]
[null,"数学",24,68,38,34,41,57,39,48,21,null,"数学",42,61,48,47,50,56,49,53,41]
[null,"社会",30,69,46,61,33,67,45,80,16,null,"社会",38,56,45,53,39,56,45,62,31]
[null,"理科",38,84,56,52,48,88,62,72,34,null,"理科",36,60,45,43,41,62,48,53,34]
[null,"英語",34,75,28,49,38,42,33,46,18,null,"英語",45,64,42,52,47,49,44,51,37]
[null,"３科計",{"$f":"C74+C75+C78","v":133},217,113,141,133,160,135,{"$f":"J74+J75+J78","v":157},77,null,"３科計",47,62,43,48,47,51,47,51,36]
[null,"５科計",{"$f":"SUM(C74:C78)","v":201},370,215,254,214,315,242,{"$f":"SUM(J74:J78)","v":309},127,null,"５科計",42,61,43,48,43,55,47,54,34]
[null,"順位",{"$f":"RANK(C80,$C80:$K80,0)","v":8},1,6,4,7,2,5,3,9,null,"順位",{"$f":"RANK(N80,$N80:$V80,0)","v":8},{"$f":"RANK(O80,$N80:$V80,0)","v":1},6,4,6,2,5,3,9]
[]
[{"$f":"A74+1","v":10},"国語",54,80,48,null,null,51,57,67,51,null,"国語",49,67,44,48,42,47,51,58,47]
[null,"数学",12,72,31,null,null,69,45,60,29,null,"数学",37,64,45,51,54,63,52,58,44]
[null,"社会",40,76,44,null,null,68,54,83,28,null,"社会",42,60,44,66,57,56,49,63,36]
[null,"理科",30,78,56,null,null,68,52,78,28,null,"理科",33,58,47,58,56,53,45,58,32]
[null,"英語",40,86,27,null,null,63,50,70,25,null,"英語",46,64,41,52,43,55,50,58,40]
[null,"３科計",{"$f":"C83+C84+C87","v":106},238,106,0,0,183,152,{"$f":"J83+J84+J87","v":197},105,null,"３科計",43,66,43,51,46,56,51,59,42]
[null,"５科計",{"$f":"SUM(C83:C87)","v":176},392,206,0,0,319,258,{"$f":"SUM(J83:J87)","v":358},161,null,"５科計",40,64,43,56,51,56,49,60,38]
[null,"順位",{"$f":"RANK(C89,$C89:$K89,0)","v":6},1,5,8,8,3,4,2,7,null,"順位",{"$f":"RANK(N89,$N89:$V89,0)","v":8},1,7,3,5,3,6,2,9]

{"sheet":"高校一覧","index":3,"n_rows":39,"n_cols":5,"rows_kept":39}
["公立高校","基準偏差値",null,"私立高校","基準偏差値"]
["安中総合",42,null,"育英（進学・推薦）",47]
["群馬工専（環境都市）",64,null,"育英（進学・併願）",52]
["群馬工専（機械）",66,null,"育英（体育）",45]
["群馬工専（電子情報）",66,null,"育英（特A）",65]
["群馬工専（電子メディア）",66,null,"育英（特B）",61]
["群馬工専（物質）",65,null,"育英（特C)",55]
["下仁田",37,null,"育英（特D)",52]
["高経大附（芸術・音楽）",54,null,"育英（保育・推薦）",43]
["高経大附（芸術・美術）",52,null,"育英（保育・併願）",47]
["高経大附（体育）",49,null,"商大（国際・推薦）",44]
["高経大附（普通・女子）",59,null,"商大（国際・併願）",48]
["高経大附（普通・男子）",57,null,"商大（情報・推薦）",42]
["高崎",68,null,"商大（情報・併願）",46]
["高崎北",59,null,"商大（進学・女子・推薦）",44]
["高崎工（機械）",51,null,"商大（進学・女子・併願）",48]
["高崎工（建築）",52,null,"商大（進学・男子・推薦）",45]
["高崎工（工業化学）",47,null,"商大（進学・男子・併願)",51]
["高崎工（情報技術）",55,null,"商大（特A）",65]
["高崎工（電気）",52,null,"商大（特B)",60]
["高崎工（土木）",47,null,"商大（特C)",56]
["高崎女",67,null,"商大（特D-F)",46]
["高崎商（女子）",52,null,"健大（特A)",60]
["高崎商（男子）",49,null,"健大（特B)",58]
["高崎東",54,null,"健大（特C)",55]
["富岡",55,null,"健大（特D)",51]
["富岡実業（園芸科学）",40,null,"健大（特E)",47]
["富岡実業（食品科学）",43,null,"健大（特F)",44]
["富岡実業（生物生産）",39,null,"健大（特G)",39]
["富岡実業（電子機械）",44,null,"健大（特S）",63]
["富岡東",51,null,"健大（特進・推薦）",50]
["榛名",37,null,"健大（特進・併願）",54]
["藤岡北",40,null,"健大（普通・併願）",47]
["藤岡工",43,null,"農二（推薦）",53]
["藤岡中央（数理）",47,null,"農二（特A）",66]
["藤岡中央（文理）",44,null,"農二（特B）",61]
["松井田",36,null,"農二（併願）",61]
["万場",34]
["吉井",46]