{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["テストデータ","成績表","科目別テスト集計","模試・実力テスト集計","定期テスト集計","連続印刷","初期設定"],"not_rendered":{"charts":12,"images":2,"macros":1,"external_links":0,"defined_names":4,"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":503,"n_cols":273,"rows_kept":503,"cut":false,"hidden":false,"merged":[[1,267,1,272],[1,203,1,214],[1,223,1,234],[1,249,1,254],[1,255,1,260],[1,261,1,266],[1,243,1,248],[1,215,1,222],[1,235,1,242],[1,183,1,194],[1,115,1,122],[1,135,1,142],[1,155,1,162],[1,175,1,182],[1,123,1,134],[1,143,1,154],[1,163,1,174],[2,51,2,62],[0,51,0,62],[0,89,0,94],[0,83,0,88],[0,69,0,74],[0,63,0,68],[1,63,1,74],[1,83,1,94],[1,75,1,82],[1,103,1,114],[1,95,1,102],[0,215,0,222],[0,235,0,242],[1,195,1,202],[0,163,0,168],[0,169,0,174],[0,195,0,202],[0,183,0,188],[0,189,0,194],[0,223,0,228],[0,229,0,234],[0,203,0,208],[0,209,0,214],[0,103,0,108],[0,109,0,114],[2,15,2,26],[0,3,0,14],[0,15,0,26],[0,27,0,38],[0,39,0,50],[2,3,2,14],[2,27,2,38],[2,39,2,50],[0,249,0,254],[0,255,0,260],[0,261,0,266],[0,267,0,272],[0,243,0,248],[0,0,0,2],[0,115,0,122],[0,135,0,142],[0,155,0,162],[0,175,0,182],[0,123,0,128],[0,129,0,134],[0,143,0,148],[0,149,0,154],[0,75,0,82],[0,95,0,102]]}
["ｶｰｿﾙ方向切り替え",null,null,{"$f":"IF(初期設定!$C2=\"\",\"\",初期設定!$C2)","v":"月例テスト"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(初期設定!$C2=\"\",\"\",初期設定!$C2)","v":"月例テスト"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(初期設定!$C2=\"\",\"\",初期設定!$C2)","v":"月例テスト"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(初期設定!$C2=\"\",\"\",初期設定!$C2)","v":"月例テスト"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(初期設定!$C2=\"\",\"\",初期設定!$C2)","v":"月例テスト"},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,"北辰テスト",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,{"$f":"IF(初期設定!$C26=\"\",\"\",初期設定!$C26)","v":"1学期中間"},null,null,null,null,null,{"$f":"IF(初期設定!$C27=\"\",\"\",初期設定!$C27)","v":"1学期期末"},null,null,null,null,null,{"$f":"IF(初期設定!$C28=\"\",\"\",初期設定!$C28)","v":"2学期中間"},null,null,null,null,null,{"$f":"IF(初期設定!$C29=\"\",\"\",初期設定!$C29)","v":"2学期期末"},null,null,null,null,null,{"$f":"IF(初期設定!$C30=\"\",\"\",初期設定!$C30)","v":"3学期期末"}]
[null,null,"実施日→","3/2","4/3","5/4","6/5","7/6","8/7","9/8","10/9","11/10","12/11",null,null,"4/8","5/8","6/8","7/8","8/8","9/8","10/8","11/8","12/8","1/8",null,null,"4/9","5/12","6/15","7/18","8/5","9/7","10/11","11/30","12/2","1/9",null,null,"4/5","5/2","6/5","7/18","8/5","9/7","10/5","11/30","12/4","1/9",null,null,"4/5","5/2","6/4","7/18","8/10","9/7","10/5","11/21","12/4","1/25",null,null,"4/10",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"5/11",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"6/13",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"7/20",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"8/25",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"9/25",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"10/21",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"11/3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"12/15"]
["ID","class","氏名",{"$f":"IF(初期設定!$C3=\"\",\"\",初期設定!$C3)","v":"英語"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(初期設定!$C4=\"\",\"\",初期設定!$C4)","v":"数学"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(初期設定!$C5=\"\",\"\",初期設定!$C5)","v":"国語"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(初期設定!$C6=\"\",\"\",初期設定!$C6)","v":"社会"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(初期設定!$C7=\"\",\"\",初期設定!$C7)","v":"理科"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(初期設定!$C9=\"\",\"\",初期設定!$C9)","v":"国語"},{"$f":"IF(BL3=\"\",\"\",MID(BL3,1,1)&\"偏\")","v":"国偏"},{"$f":"IF(初期設定!$C10=\"\",\"\",初期設定!$C10)","v":"英語"},{"$f":"IF(BN3=\"\",\"\",MID(BN3,1,1)&\"偏\")","v":"英偏"},{"$f":"IF(初期設定!$C11=\"\",\"\",初期設定!$C11)","v":"数学"},{"$f":"IF(BP3=\"\",\"\",MID(BP3,1,1)&\"偏\")","v":"数偏"},{"$f":"IF(初期設定!$C12=\"\",\"\",初期設定!$C12)","v":"社会"},{"$f":"IF(BR3=\"\",\"\",MID(BR3,1,1)&\"偏\")","v":"社偏"},{"$f":"IF(初期設定!$C13=\"\",\"\",初期設定!$C13)","v":"理科"},{"$f":"IF(BT3=\"\",\"\",MID(BT3,1,1)&\"偏\")","v":"理偏"},"３偏","５偏","志望校 公立1","判定","志望校 公立2","判定","志望校 私立1","判定","志望校 私立2","判定",{"$f":"IF(BL3=\"\",\"\",BL3)","v":"国語"},{"$f":"IF(BM3=\"\",\"\",BM3)","v":"国偏"},"英語","英偏","数学","数偏","社会","社偏","理科","理偏","３偏","５偏","志望校 公立1","判定","志望校 公立2","判定","志望校 私立1","判定","志望校 私立2","判定",{"$f":"IF(CF3=\"\",\"\",CF3)","v":"国語"},"国偏","英語","英偏","数学","数偏","社会","社偏","理科","理偏","３偏","５偏","志望校 公立1","判定","志望校 公立2","判定","志望校 私立1","判定","志望校 私立2","判定",{"$f":"IF(CZ3=\"\",\"\",CZ3)","v":"国語"},"国偏","英語","英偏","数学","数偏","社会","社偏","理科","理偏","３偏","５偏","志望校 公立1","判定","志望校 公立2","判定","志望校 私立1","判定","志望校 私立2","判定",{"$f":"IF(DT3=\"\",\"\",DT3)","v":"国語"},"国偏","英語","英偏","数学","数偏","社会","社偏","理科","理偏","３偏","５偏","志望校 公立1","判定","志望校 公立2","判定","志望校 私立1","判定","志望校 私立2","判定",{"$f":"IF(EN3=\"\",\"\",EN3)","v":"国語"},"国偏","英語","英偏","数学","数偏","社会","社偏","理科","理偏","３偏","５偏","志望校 公立1","判定","志望校 公立2","判定","志望校 私立1","判定","志望校 私立2","判定",{"$f":"IF(FH3=\"\",\"\",FH3)","v":"国語"},{"$f":"IF(FI3=\"\",\"\",FI3)","v":"国偏"},{"$f":"IF(FJ3=\"\",\"\",FJ3)","v":"英語"},{"$f":"IF(FK3=\"\",\"\",FK3)","v":"英偏"},{"$f":"IF(FL3=\"\",\"\",FL3)","v":"数学"},{"$f":"IF(FM3=\"\",\"\",FM3)","v":"数偏"},{"$f":"IF(FN3=\"\",\"\",FN3)","v":"社会"},{"$f":"IF(FO3=\"\",\"\",FO3)","v":"社偏"},{"$f":"IF(FP3=\"\",\"\",FP3)","v":"理科"},{"$f":"IF(FQ3=\"\",\"\",FQ3)","v":"理偏"},"３偏","５偏","志望校 公立1","判定","志望校 公立2","判定","志望校 私立1","判定","志望校 私立2","判定",{"$f":"IF(GB3=\"\",\"\",GB3)","v":"国語"},{"$f":"IF(GC3=\"\",\"\",GC3)","v":"国偏"},{"$f":"IF(GD3=\"\",\"\",GD3)","v":"英語"},{"$f":"IF(GE3=\"\",\"\",GE3)","v":"英偏"},{"$f":"IF(GF3=\"\",\"\",GF3)","v":"数学"},{"$f":"IF(GG3=\"\",\"\",GG3)","v":"数偏"},{"$f":"IF(GH3=\"\",\"\",GH3)","v":"社会"},{"$f":"IF(GI3=\"\",\"\",GI3)","v":"社偏"},{"$f":"IF(GJ3=\"\",\"\",GJ3)","v":"理科"},{"$f":"IF(GK3=\"\",\"\",GK3)","v":"理偏"},"３偏","５偏","志望校 公立1","判定","志望校 公立2","判定","志望校 私立1","判定","志望校 私立2","判定",{"$f":"IF(GV3=\"\",\"\",GV3)","v":"国語"},{"$f":"IF(GW3=\"\",\"\",GW3)","v":"国偏"},{"$f":"IF(GX3=\"\",\"\",GX3)","v":"英語"},{"$f":"IF(GY3=\"\",\"\",GY3)","v":"英偏"},{"$f":"IF(GZ3=\"\",\"\",GZ3)","v":"数学"},{"$f":"IF(HA3=\"\",\"\",HA3)","v":"数偏"},{"$f":"IF(HB3=\"\",\"\",HB3)","v":"社会"},{"$f":"IF(HC3=\"\",\"\",HC3)","v":"社偏"},{"$f":"IF(HD3=\"\",\"\",HD3)","v":"理科"},{"$f":"IF(HE3=\"\",\"\",HE3)","v":"理偏"},"３偏","５偏","志望校 公立1","判定","志望校 公立2","判定","志望校 私立1","判定","志望校 私立2","判定",{"$f":"IF(初期設定!$C21=\"\",\"\",初期設定!$C21)","v":"国語"},{"$f":"IF(初期設定!$C22=\"\",\"\",初期設定!$C22)","v":"英語"},{"$f":"IF(初期設定!$C23=\"\",\"\",初期設定!$C23)","v":"数学"},{"$f":"IF(初期設定!$C24=\"\",\"\",初期設定!$C24)","v":"社会"},{"$f":"IF(初期設定!$C25=\"\",\"\",初期設定!$C25)","v":"理科"},"順位",{"$f":"IJ3","v":"国語"},{"$f":"IK3","v":"英語"},{"$f":"IL3","v":"数学"},{"$f":"IM3","v":"社会"},{"$f":"IN3","v":"理科"},"順位",{"$f":"IP3","v":"国語"},{"$f":"IQ3","v":"英語"},{"$f":"IR3","v":"数学"},{"$f":"IS3","v":"社会"},{"$f":"IT3","v":"理科"},"順位",{"$f":"IV3","v":"国語"},{"$f":"IW3","v":"英語"},{"$f":"IX3","v":"数学"},{"$f":"IY3","v":"社会"},{"$f":"IZ3","v":"理科"},"順位",{"$f":"JB3","v":"国語"},{"$f":"JC3","v":"英語"},{"$f":"JD3","v":"数学"},{"$f":"JE3","v":"社会"},{"$f":"JF3","v":"理科"},"順位"]
[1,"3-1","鈴木A男",null,50,97,72,90,25,90,50,97,72,null,null,null,50,97,72,90,25,90,50,97,72,null,null,null,50,97,72,25,25,90,50,97,72,null,null,90,50,12,72,31,60,13,86,66,23,null,null,78,94,10,88,35,27,87,44,17,27,null,null,52,50,35,41,82,66,92,71,79,61,62,61,"県立千葉","E","千葉東","D","渋谷幕張","C","成田","B",81,65,21,73,67,20,77,46,22,19,54,40,"県立千葉","E","千葉東","D","渋谷幕張","C","成田","B",52,50,35,41,82,66,92,71,79,61,62,61,"県立千葉","E","千葉東","D","渋谷幕張","C","成田","B",null,null,null,null,null,null,null,null,null,null,null,null,"県立千葉","E","千葉東","D","渋谷幕張","C","成田","B",52,50,35,41,82,66,92,71,79,61,62,61,"県立千葉","E","千葉東","D","渋谷幕張","C","成田","B",83,33,94,67,46,58,35,12,54,23,23,45,"県立千葉","E","千葉東","D","渋谷幕張","C","成田","B",83,33,94,67,46,58,35,12,54,23,23,45,"県立千葉","E","千葉東","D","渋谷幕張","C","成田","B",null,null,null,null,null,null,null,null,null,null,null,null,"県立千葉","E","千葉東","D","渋谷幕張","C","成田","B",83,33,94,67,46,58,35,12,54,23,23,45,"県立千葉","E","千葉東","D","渋谷幕張","C","成田","B",36,58,41,92,88,21,53,89,90,23,89,15,36,58,41,92,88,21,53,89,90,23,89,15]
[2,"3-1","鈴木B男",11,24,94,22,25,51,55,69,76,35,null,null,86,31,75,64,93,100,47,65,34,16,null,null,48,72,99,40,75,85,95,91,67,75,null,null,10,48,82,42,93,67,70,35,69,77,null,null,24,74,37,44,56,80,64,16,42,77,null,null,60,56,92,60,65,38,57,78,16,50,45,47,"千葉東","C","千葉西","A","市川","A","千葉明徳","F",50,48,36,30,45,26,71,56,60,26,45,55,"千葉東","C","千葉西","A","市川","A","千葉明徳","F",null,null,null,null,null,null,null,null,null,null,null,null,"千葉東","C","千葉西","A","市川","A","千葉明徳","F",50,48,36,30,45,26,71,56,60,26,45,55,"千葉東","C","千葉西","A","市川","A","千葉明徳","F",null,null,null,null,null,null,null,null,null,null,null,null,"千葉東","C","千葉西","A","市川","A","千葉明徳","F",50,48,36,30,45,99,68,56,60,26,45,55,"千葉東","C","千葉西","A","市川","A","千葉明徳","F",50,48,36,30,45,26,71,56,60,26,45,55,"千葉東","C","千葉西","A","市川","A","千葉明徳","F",50,48,36,30,45,26,71,56,60,26,45,55,"千葉東","C","千葉西","A","市川","A","千葉明徳","F",50,48,36,30,45,26,71,56,60,26,45,55,"千葉東","C","千葉西","A","市川","A","千葉明徳","F",null,null,null,null,null,null,62,95,67,82,38,28,null,null,null,null,null,150,62,95,67,82,38,28]
[3,"3-1","鈴木C男",83,23,31,66,70,18,39,15,92,46,null,null,31,12,97,76,32,98,91,28,91,87,null,null,67,64,16,95,53,62,93,96,96,68,null,null,70,90,32,99,34,41,12,45,42,40,null,null,69,100,100,16,80,37,69,36,49,52,null,null,62,58,68,63,57,60,69,59,58,55,61,58,"県立千葉","E","千葉東","D","渋谷幕張","C","成田","B",60,54,72,61,80,65,53,56,83,60,61,59,"県立千葉","E","千葉東","D","渋谷幕張","C","成田","B",62,58,68,63,57,60,69,59,58,55,61,58,"県立千葉","E","千葉東","D","渋谷幕張","C","成田","B",55,54,72,61,80,65,53,56,83,60,61,59,"県立千葉","E","千葉東","D","渋谷幕張","C","成田","B",69,58,68,63,57,60,69,59,58,55,61,58,"県立千葉","E","千葉東","D","渋谷幕張","C","成田","B",88,54,72,61,80,65,53,56,83,60,61,59,"県立千葉","E","千葉東","D","渋谷幕張","C","成田","B",77,54,72,61,80,65,53,56,83,60,61,59,"県立千葉","E","千葉東","D","渋谷幕張","C","成田","B",74,54,72,61,80,65,53,56,83,60,61,59,"県立千葉","E","千葉東","D","渋谷幕張","C","成田","B",45,54,72,61,80,65,53,56,83,60,61,59,"県立千葉","E","千葉東","D","渋谷幕張","C","成田","B",93,41,23,48,53,51,42,92,88,83,51,36,93,41,23,48,53,51,42,92,88,83,51,36]
[4,"3-1","鈴木D男",40,35,20,24,82,96,49,90,45,null,null,null,51,36,71,42,62,88,83,51,60,91,null,null,97,16,91,69,36,97,25,69,32,62,null,null,23,32,56,79,53,81,66,34,35,91,null,null,50,74,66,69,65,40,14,26,98,65,null,null,58,52,77,58,49,60,46,49,78,58,43,13,"県立千葉","B","千葉西","A","成田","E","千葉経済","D",42,31,56,22,46,45,18,34,98,68,42,58,"県立千葉","B","千葉西","A","成田","E","千葉経済","D",58,52,77,58,49,60,46,49,78,58,43,13,"県立千葉","B","千葉西","A","成田","E","千葉経済","D",42,31,56,22,46,45,18,34,98,68,42,58,"県立千葉","B","千葉西","A","成田","E","千葉経済","D",58,52,77,58,49,60,46,49,78,58,43,13,"県立千葉","B","千葉西","A","成田","E","千葉経済","D",42,31,56,22,46,45,18,34,98,68,42,58,"県立千葉","B","千葉西","A","成田","E","千葉経済","D",42,31,56,22,46,45,18,34,98,68,42,58,"県立千葉","B","千葉西","A","成田","E","千葉経済","D",42,31,56,22,46,45,18,34,98,68,42,58,"県立千葉","B","千葉西","A","成田","E","千葉経済","D",42,31,56,22,46,45,18,34,98,68,42,58,"県立千葉","B","千葉西","A","成田","E","千葉経済","D",39,97,27,55,56,54,31,93,31,36,13,85,39,97,27,55,56,54,31,93,31,36,13,85]
[5,"3-1","鈴木E男",56,11,54,100,14,59,80,80,41,36,null,null,100,14,null,87,20,21,48,100,49,18,null,null,59,49,60,48,98,43,35,46,12,16,null,null,77,38,36,86,80,49,54,70,null,84,null,null,91,59,36,67,88,16,85,53,81,86,null,null,38,44,98,66,21,12,12,30,33,21,52,85,"千葉西","C","千葉南","C","成田","C","成田","C",19,40,19,35,82,47,56,45,50,47,54,36,"千葉西","C","千葉南","C","成田","C","成田","C",38,44,98,66,21,12,12,30,33,21,52,85,"千葉西","C","千葉南","C","成田","C","成田","C",19,40,19,35,82,47,56,45,50,47,54,36,"千葉西","C","千葉南","C","成田","C","成田","C",38,44,98,66,21,12,12,30,33,21,52,85,"千葉西","C","千葉南","C","成田","C","成田","C",19,40,19,35,82,47,56,45,50,47,54,36,"千葉西","C","千葉南","C","成田","C","成田","C",19,40,19,35,82,47,56,45,50,47,54,36,"千葉西","C","千葉南","C","成田","C","成田","C",19,40,19,35,82,47,56,45,50,47,54,36,"千葉西","C","千葉南","C","成田","C","成田","C",19,40,19,35,82,47,56,45,50,47,54,36,"千葉西","C","千葉南","C","成田","C","成田","C",null,47,98,96,null,21,64,88,64,97,91,45,null,47,98,96,null,21,64,88,64,97,91,45]
[6,"3-1","鈴木F男",42,21,10,85,18,98,47,69,93,83,null,null,47,82,35,90,68,34,null,22,90,24,null,null,83,75,86,22,35,21,11,32,47,44,null,null,54,39,89,18,null,56,93,36,10,28,null,null,12,14,64,53,null,33,56,69,99,23,null,null,86,66,69,42,14,51,31,42,64,61,47,45,"千葉東","F","千葉東","D","成田","B","千葉明徳","A",66,54,73,41,12,32,12,42,12,30,63,63,"千葉東","F","千葉東","D","成田","B","千葉明徳","A",86,66,69,42,14,51,31,42,64,61,47,45,"千葉東","F","千葉東","D","成田","B","千葉明徳","A",66,54,73,41,12,32,12,42,12,30,63,63,"千葉東","F","千葉東","D","成田","B","千葉明徳","A",86,66,69,42,14,51,31,42,64,61,47,45,"千葉東","F","千葉東","D","成田","B","千葉明徳","A",66,54,73,41,12,32,12,42,12,30,63,63,"千葉東","F","千葉東","D","成田","B","千葉明徳","A",66,54,73,41,12,32,12,42,12,30,63,63,"千葉東","F","千葉東","D","成田","B","千葉明徳","A",66,54,73,41,12,32,12,42,12,30,63,63,"千葉東","F","千葉東","D","成田","B","千葉明徳","A",66,54,73,41,12,32,12,42,12,30,63,63,"千葉東","F","千葉東","D","成田","B","千葉明徳","A",27,14,87,54,71,87,53,14,98,58,48,54,27,14,87,54,71,87,53,14,98,58,48,54]
[7,"3-2","鈴木G男",69,80,51,35,55,11,54,33,88,32,null,null,97,null,85,30,55,98,23,46,26,87,null,null,97,71,28,85,29,83,62,45,null,99,null,null,60,66,38,84,88,47,76,20,52,81,null,null,45,67,92,79,29,67,62,26,null,48,null,null,55,54,72,59,11,21,26,39,27,28,35,15,"県立千葉","E","千葉東","D","渋谷幕張","C","成田","B",94,48,97,45,35,41,41,68,52,52,58,44,"県立千葉","E","千葉東","D","渋谷幕張","C","成田","B",55,54,72,59,11,21,26,39,27,28,35,15,"県立千葉","E","千葉東","D","渋谷幕張","C","成田","B",94,48,97,45,35,41,41,68,52,52,58,44,"県立千葉","E","千葉東","D","渋谷幕張","C","成田","B",55,54,72,59,11,21,26,39,27,28,35,15,"県立千葉","E","千葉東","D","渋谷幕張","C","成田","B",94,48,97,45,35,41,41,68,52,52,58,44,"県立千葉","E","千葉東","D","渋谷幕張","C","成田","B",94,48,97,45,35,41,41,68,52,52,58,44,"県立千葉","E","千葉東","D","渋谷幕張","C","成田","B",94,48,97,45,35,41,41,68,52,52,58,44,"県立千葉","E","千葉東","D","渋谷幕張","C","成田","B",94,48,97,45,35,41,41,68,52,52,58,44,"県立千葉","E","千葉東","D","渋谷幕張","C","成田","B",72,38,82,47,63,110,24,62,69,36,78,24,72,38,82,47,63,110,24,62,69,36,78,24]
[8,"3-2","鈴木H男",50,23,null,32,88,13,49,98,28,26,null,null,18,84,null,17,83,70,74,74,null,37,null,null,85,59,69,45,15,19,76,19,34,81,null,null,69,100,66,45,91,75,45,12,79,34,null,null,52,14,79,89,83,25,52,92,99,48,null,null,52,50,86,55,56,70,21,57,11,56,24,43,"千葉東","C","千葉西","A","市川","A","千葉明徳","F",95,60,55,44,25,13,27,73,98,39,62,25,"千葉東","C","千葉西","A","市川","A","千葉明徳","F",52,50,86,55,56,70,21,57,11,56,24,43,"千葉東","C","千葉西","A","市川","A","千葉明徳","F",95,60,55,44,25,13,27,73,98,39,62,25,"千葉東","C","千葉西","A","市川","A","千葉明徳","F",52,50,86,55,56,70,21,57,11,56,24,43,"千葉東","C","千葉西","A","市川","A","千葉明徳","F",95,60,55,44,25,13,27,73,98,39,62,25,"千葉東","C","千葉西","A","市川","A","千葉明徳","F",95,60,55,44,25,13,27,73,98,39,62,25,"千葉東","C","千葉西","A","市川","A","千葉明徳","F",95,60,55,44,25,13,27,73,98,39,62,25,"千葉東","C","千葉西","A","市川","A","千葉明徳","F",95,60,55,44,25,13,27,73,98,39,62,25,"千葉東","C","千葉西","A","市川","A","千葉明徳","F",79,52,69,54,10,25,64,21,66,10,52,85,79,52,69,54,10,25,64,21,66,10,52,85]
[9,"3-2","鈴木I男",60,54,64,87,49,92,58,null,17,12,null,null,85,11,57,34,77,63,97,null,20,84,null,null,76,24,21,33,13,70,34,95,91,99,null,null,96,61,35,85,22,52,84,89,57,83,null,null,54,10,58,43,93,39,32,53,48,72,null,null,58,52,42,80,57,72,64,45,49,65,33,28,"県立千葉","E","千葉東","D","渋谷幕張","C","成田","B",86,20,68,63,32,64,98,57,74,31,56,44,"県立千葉","E","千葉東","D","渋谷幕張","C","成田","B",58,52,42,80,57,72,64,45,49,65,33,28,"県立千葉","E","千葉東","D","渋谷幕張","C","成田","B",86,20,68,63,32,64,98,57,74,31,56,44,"県立千葉","E","千葉東","D","渋谷幕張","C","成田","B",58,52,42,80,57,72,64,45,49,65,33,28,"県立千葉","E","千葉東","D","渋谷幕張","C","成田","B",86,20,68,63,32,64,98,57,74,31,56,44,"県立千葉","E","千葉東","D","渋谷幕張","C","成田","B",86,20,68,63,32,64,98,57,74,31,56,44,"県立千葉","E","千葉東","D","渋谷幕張","C","成田","B",86,20,68,63,32,64,98,57,74,31,56,44,"県立千葉","E","千葉東","D","渋谷幕張","C","成田","B",86,20,68,63,32,64,98,57,74,31,56,44,"県立千葉","E","千葉東","D","渋谷幕張","C","成田","B",57,93,67,null,92,41,59,79,40,69,93,34,57,93,67,null,92,41,59,79,40,69,93,34]
[10,"3-2","鈴木J男",100,80,92,27,47,28,19,73,48,26,null,null,96,53,81,20,15,56,15,66,22,44,null,null,21,44,92,71,null,40,40,29,32,31,null,null,96,48,30,null,39,19,33,53,32,22,null,null,59,50,25,46,88,53,55,53,33,25,null,null,75,60,80,55,93,81,23,28,51,23,41,45,"県立千葉","B","千葉南","B","千葉経済","S","成田","B",33,30,92,62,73,48,69,15,75,26,60,64,"県立千葉","B","千葉西","A","成田","E","渋谷幕張","D",75,60,80,55,93,81,23,28,51,23,41,45,"県立千葉","B","千葉西","A","成田","E","渋谷幕張","D",33,30,92,62,73,48,69,15,75,26,60,64,"県立千葉","B","千葉西","A","成田","E","渋谷幕張","D",75,60,80,55,93,81,23,28,51,23,41,45,"県立千葉","B","千葉西","A","成田","E","渋谷幕張","D",33,30,92,62,73,48,69,15,75,26,60,64,"県立千葉","B","千葉西","A","成田","E","渋谷幕張","D",33,30,92,62,73,48,69,15,75,26,60,64,"県立千葉","B","千葉西","A","成田","E","渋谷幕張","D",33,30,92,62,73,48,69,15,75,26,60,64,"県立千葉","B","千葉西","A","成田","E","渋谷幕張","D",33,30,92,62,73,48,69,15,75,26,60,64,"県立千葉","B","千葉西","A","成田","E","成田","B",29,82,10,39,67,32,85,93,37,33,77,75,29,82,10,39,67,32,85,93,37,33,77,75]
[11,"3-2","鈴木K男",66,90,42,65,41,65,75,33,42,64,null,null,71,null,79,37,73,67,21,49,83,37,null,null,59,58,91,32,99,28,98,97,null,92,null,null,30,10,55,38,26,80,93,45,33,56,null,null,27,49,63,null,47,41,25,53,56,84,null,null,58,52,80,65,70,30,85,68,72,35,43,50,"千葉西","C","千葉南","C","成田","C","成田","C",83,74,28,61,49,62,76,58,31,92,47,62,"千葉西","C","千葉南","C","成田","C","成田","C",58,52,80,65,70,30,85,68,72,35,43,50,"千葉西","C","千葉南","C","成田","C","成田","C",83,74,28,61,49,62,76,58,31,92,47,62,"千葉西","C","千葉南","C","成田","C","成田","C",58,52,80,65,70,30,85,68,72,35,43,50,"千葉西","C","千葉南","C","成田","C","成田","C",83,74,28,61,49,62,76,58,31,92,47,62,"千葉西","C","千葉南","C","成田","C","成田","C",83,74,28,61,49,62,76,58,31,92,47,62,"千葉西","C","千葉南","C","成田","C","成田","C",83,74,28,61,49,62,76,58,31,92,47,62,"千葉西","C","千葉南","C","成田","C","成田","C",83,74,28,61,49,62,76,58,31,92,47,62,"千葉西","C","千葉南","C","成田","C","成田","C",45,65,26,89,43,12,81,52,37,95,89,51,45,65,26,89,43,12,81,52,37,95,89,51]
[12,"3-2","鈴木L男",28,87,17,29,18,72,19,86,92,94,null,null,59,70,null,79,26,81,15,47,81,94,null,null,73,82,20,33,79,21,77,25,35,89,null,null,76,99,59,92,84,53,55,97,15,80,null,null,35,99,76,89,12,28,35,86,100,54,null,null,36,40,54,63,14,24,33,18,58,19,39,57,"千葉東","F","千葉東","D","成田","B","千葉明徳","A",24,35,48,54,48,60,57,33,52,54,41,52,"千葉東","F","千葉東","D","成田","B","千葉明徳","A",36,40,54,63,14,24,33,18,58,19,39,57,"千葉東","F","千葉東","D","成田","B","千葉明徳","A",24,35,48,54,48,60,57,33,52,54,41,52,"千葉東","F","千葉東","D","成田","B","千葉明徳","A",36,40,54,63,14,24,33,18,58,19,39,57,"千葉東","F","千葉東","D","成田","B","千葉明徳","A",24,35,48,54,48,60,57,33,52,54,41,52,"千葉東","F","千葉東","D","成田","B","千葉明徳","A",24,35,48,54,48,60,57,33,52,54,41,52,"千葉東","F","千葉東","D","成田","B","千葉明徳","A",24,35,48,54,48,60,57,33,52,54,41,52,"千葉東","F","千葉東","D","成田","B","千葉明徳","A",24,35,48,54,48,60,57,33,52,54,41,52,"千葉東","F","千葉東","D","成田","B","千葉明徳","A",59,27,29,47,91,null,93,32,16,89,24,36,59,27,29,47,91,25,93,32,16,89,24,36]
[13,"3-3","鈴木M男",55,57,18,35,64,96,73,77,71,64,null,null,11,89,81,81,100,28,40,72,39,30,null,null,57,29,35,54,22,30,87,70,90,49,null,null,69,41,36,62,10,90,78,10,80,53,null,null,63,48,82,15,16,96,33,44,53,97,null,null,24,36,92,67,79,32,30,22,18,35,18,40,"県立千葉","E","千葉東","D","渋谷幕張","C","成田","B",81,65,21,73,67,20,77,46,22,19,54,40,"県立千葉","E","千葉東","D","渋谷幕張","C","成田","B",24,36,92,67,79,32,30,22,18,35,18,40,"県立千葉","E","千葉東","D","渋谷幕張","C","成田","B",81,65,21,73,67,20,77,46,22,19,54,40,"県立千葉","E","千葉東","D","渋谷幕張","C","成田","B",24,36,92,67,79,32,30,22,18,35,18,40,"県立千葉","E","千葉東","D","渋谷幕張","C","成田","B",81,65,21,73,67,20,77,46,22,19,54,40,"県立千葉","E","千葉東","D","渋谷幕張","C","成田","B",81,65,21,73,67,20,77,46,22,19,54,40,"県立千葉","E","千葉東","D","渋谷幕張","C","成田","B",81,65,21,73,67,20,77,46,22,19,54,40,"県立千葉","E","千葉東","D","渋谷幕張","C","成田","B",81,65,21,73,67,20,77,46,22,19,54,40,"県立千葉","E","千葉東","D","渋谷幕張","C","成田","B",75,14,24,96,85,15,26,44,19,90,96,85,75,14,24,96,85,15,26,44,19,90,96,85]
[14,"3-3","鈴木N男",30,50,24,26,58,42,43,78,82,33,null,null,12,100,null,22,53,99,11,92,95,55,null,null,90,13,14,74,62,100,98,57,46,11,null,null,31,17,20,88,14,17,89,59,33,81,null,null,90,86,18,50,31,73,44,85,22,10,null,null,60,56,92,60,65,38,57,78,16,19,48,61,"千葉東","C","千葉西","A","市川","A","千葉明徳","F",83,33,94,67,46,58,35,12,54,23,23,45,"千葉東","C","千葉西","A","市川","A","千葉明徳","F",60,56,92,60,65,38,57,78,16,19,48,61,"千葉東","C","千葉西","A","市川","A","千葉明徳","F",83,33,94,67,46,58,35,12,54,23,23,45,"千葉東","C","千葉西","A","市川","A","千葉明徳","F",60,56,92,60,65,38,57,78,16,19,48,61,"千葉東","C","千葉西","A","市川","A","千葉明徳","F",83,33,94,67,46,58,35,12,54,23,23,45,"千葉東","C","千葉西","A","市川","A","千葉明徳","F",83,33,94,67,46,58,35,12,54,23,23,45,"千葉東","C","千葉西","A","市川","A","千葉明徳","F",83,33,94,67,46,58,35,12,54,23,23,45,"千葉東","C","千葉西","A","市川","A","千葉明徳","F",83,33,94,67,46,58,35,12,54,23,23,45,"千葉東","C","千葉西","A","市川","A","千葉明徳","F",29,67,21,83,49,58,41,53,94,39,60,99,29,67,21,83,49,58,41,53,94,39,60,99]
[15,"3-3","鈴木O男",19,86,68,18,44,59,94,52,19,29,null,null,68,null,30,81,28,51,43,16,43,22,null,null,29,35,86,33,49,49,24,86,null,51,null,null,48,38,43,12,39,51,15,21,25,85,null,null,59,61,91,72,17,68,12,53,null,75,null,null,40,46,38,25,80,34,30,47,41,40,62,65,"県立千葉","E","千葉東","D","渋谷幕張","C","成田","B",33,68,93,69,17,21,35,22,19,60,52,25,"県立千葉","E","千葉東","D","渋谷幕張","C","成田","B",40,46,38,25,80,34,30,47,41,40,62,65,"県立千葉","E","千葉東","D","渋谷幕張","C","成田","B",33,68,93,69,17,21,35,22,19,60,52,25,"県立千葉","E","千葉東","D","渋谷幕張","C","成田","B",40,46,38,25,80,34,30,47,41,40,62,65,"県立千葉","E","千葉東","D","渋谷幕張","C","成田","B",33,68,93,69,17,21,35,22,19,60,52,25,"県立千葉","E","千葉東","D","渋谷幕張","C","成田","B",33,68,93,69,17,21,35,22,19,60,52,25,"県立千葉","E","千葉東","D","渋谷幕張","C","成田","B",33,68,93,69,17,21,35,22,19,60,52,25,"県立千葉","E","千葉東","D","渋谷幕張","C","成田","B",33,68,93,69,17,21,35,22,19,60,52,25,"県立千葉","E","千葉東","D","渋谷幕張","C","成田","B",86,68,97,12,60,74,22,87,90,75,99,15,86,68,97,12,60,74,22,87,90,75,99,15]
[16,"3-3","鈴木P男",null,44,44,77,19,null,81,39,47,79,null,null,10,24,65,94,72,80,35,35,57,11,null,null,23,59,41,25,null,14,22,43,99,76,null,null,31,59,71,71,76,86,40,25,null,37,null,null,37,88,85,24,96,68,60,97,30,51,null,null,42,48,37,62,81,43,84,55,35,26,43,18,"県立千葉","B","千葉西","A","成田","E","千葉経済","D",82,66,26,49,57,32,87,29,29,29,50,33,"県立千葉","B","千葉西","A","成田","E","千葉経済","D",42,48,37,62,81,43,84,55,35,26,43,18,"県立千葉","B","千葉西","A","成田","E","千葉経済","D",82,66,26,49,57,32,87,29,29,29,50,33,"県立千葉","B","千葉西","A","成田","E","千葉経済","D",42,48,37,62,81,43,84,55,35,26,43,18,"県立千葉","B","千葉西","A","成田","E","千葉経済","D",82,66,26,49,57,32,87,29,29,29,50,33,"県立千葉","B","千葉西","A","成田","E","千葉経済","D",82,66,26,49,57,32,87,29,29,29,50,33,"県立千葉","B","千葉西","A","成田","E","千葉経済","D",82,66,26,49,57,32,87,29,29,29,50,33,"県立千葉","B","千葉西","A","成田","E","千葉経済","D",82,66,26,49,57,32,87,29,29,29,50,33,"県立千葉","B","千葉西","A","成田","E","千葉経済","D",15,82,67,45,80,45,43,27,20,82,46,106,15,82,67,45,80,45,43,27,20,82,46,106]
[17,"3-3","鈴木Q男",88,10,13,12,61,46,14,31,30,40,null,null,78,52,39,67,71,21,12,100,25,49,null,null,95,32,70,28,71,83,16,85,77,60,null,null,22,57,96,80,56,88,78,41,71,77,null,null,58,31,80,84,84,87,null,91,84,39,null,null,80,62,40,31,63,62,59,35,25,13,48,52,"千葉西","C","千葉南","C","成田","C","成田","C",29,31,47,39,48,56,21,53,99,86,64,38,"千葉西","C","千葉南","C","成田","C","成田","C",80,62,40,31,63,62,59,35,25,13,48,52,"千葉西","C","千葉南","C","成田","C","成田","C",29,31,47,39,48,56,21,53,99,86,64,38,"千葉西","C","千葉南","C","成田","C","成田","C",80,62,40,31,63,62,59,35,25,13,48,52,"千葉西","C","千葉南","C","成田","C","成田","C",29,31,47,39,48,56,21,53,99,86,64,38,"千葉西","C","千葉南","C","成田","C","成田","C",29,31,47,39,48,56,21,53,99,86,64,38,"千葉西","C","千葉南","C","成田","C","成田","C",29,31,47,39,48,56,21,53,99,86,64,38,"千葉西","C","千葉南","C","成田","C","成田","C",29,31,47,39,48,56,21,53,99,86,64,38,"千葉西","C","千葉南","C","成田","C","成田","C",83,52,80,90,18,54,60,51,86,57,76,25,83,52,80,90,18,54,60,51,86,57,76,25]
[18,"3-3","鈴木R男",95,12,22,19,97,83,48,76,31,66,null,null,71,36,35,83,12,84,14,51,61,76,null,null,56,42,93,55,66,49,40,97,33,86,null,null,16,34,28,99,18,24,73,90,82,76,null,null,37,29,68,63,72,57,53,92,33,45,null,null,85,65,28,67,61,76,78,58,36,12,39,62,"千葉東","F","千葉東","D","成田","B","千葉明徳","A",79,63,61,58,31,21,39,25,42,50,50,25,"千葉東","F","千葉東","D","成田","B","千葉明徳","A",85,65,28,67,61,76,78,58,36,12,39,62,"千葉東","F","千葉東","D","成田","B","千葉明徳","A",79,63,61,58,31,21,39,25,42,50,50,25,"千葉東","F","千葉東","D","成田","B","千葉明徳","A",85,65,28,67,61,76,78,58,36,12,39,62,"千葉東","F","千葉東","D","成田","B","千葉明徳","A",79,63,61,58,31,21,39,25,42,50,50,25,"千葉東","F","千葉東","D","成田","B","千葉明徳","A",79,63,61,58,31,21,39,25,42,50,50,25,"千葉東","F","千葉東","D","成田","B","千葉明徳","A",79,63,61,58,31,21,39,25,42,50,50,25,"千葉東","F","千葉東","D","成田","B","千葉明徳","A",79,63,61,58,31,21,39,25,42,50,50,25,"千葉東","F","千葉東","D","成田","B","千葉明徳","A",37,94,88,70,27,45,31,82,38,48,94,45,37,94,88,70,27,45,31,82,38,48,94,45]
[19,"3-3","鈴木S男",81,31,53,15,40,14,78,53,76,73,null,null,44,54,17,43,91,49,20,32,38,20,null,null,93,42,52,44,67,84,33,99,32,69,null,null,34,89,25,80,74,45,52,29,97,13,null,null,83,26,16,28,89,84,27,64,49,41,null,null,75,60,92,54,76,58,27,33,46,42,59,46,"県立千葉","B","千葉西","A","成田","E","千葉経済","C",84,66,81,61,68,26,83,45,49,46,38,45,"県立千葉","B","千葉西","A","成田","E","千葉経済","C",75,60,92,54,76,58,27,33,46,42,59,46,"県立千葉","B","千葉西","A","成田","E","千葉経済","C",84,66,81,61,68,26,83,45,49,46,38,45,"県立千葉","B","千葉西","A","成田","E","千葉経済","C",75,60,92,54,76,58,27,33,46,42,59,46,"県立千葉","B","千葉西","A","成田","E","千葉経済","C",84,66,81,61,68,26,83,45,49,46,38,45,"県立千葉","B","千葉西","A","成田","E","千葉経済","C",84,66,81,61,68,26,83,45,49,46,38,45,"県立千葉","B","千葉西","A","成田","E","千葉経済","C",84,66,81,61,68,26,83,45,49,46,38,45,"県立千葉","B","千葉西","A","成田","E","千葉経済","C",84,66,81,61,68,26,83,45,49,46,38,45,"県立千葉","B","千葉西","A","成田","E","千葉経済","C",80,40,36,75,90,4,74,60,23,70,97,65,80,40,36,75,90,4,74,60,23,70,97,65]
[20,"3-3","鈴木T男",30,99,79,88,71,20,60,71,89,92,null,null,11,16,86,65,75,74,77,63,49,44,null,null,51,61,18,64,33,11,62,88,86,47,null,null,83,72,37,39,27,81,78,83,40,76,null,null,32,99,16,10,46,49,93,85,86,52,null,null,75,60,41,28,45,51,23,25,45,48,45,15,"千葉西","C","千葉南","C","成田","C","成田","A",99,65,55,13,55,45,57,55,11,35,45,47,"千葉西","C","千葉南","C","成田","C","成田","A",75,60,41,28,45,51,23,25,45,48,45,15,"千葉西","C","千葉南","C","成田","C","成田","A",99,65,55,13,55,45,57,55,11,35,45,47,"千葉西","C","千葉南","C","成田","C","成田","A",75,60,41,28,45,51,23,25,45,48,45,15,"千葉西","C","千葉南","C","成田","C","成田","A",99,65,55,13,55,45,57,55,11,35,45,47,"千葉西","C","千葉南","C","成田","C","成田","A",99,65,55,13,55,45,57,55,11,35,45,47,"千葉西","C","千葉南","C","成田","C","成田","A",99,65,55,13,55,45,57,55,11,35,45,47,"千葉西","C","千葉南","C","成田","C","成田","A",99,65,55,13,55,45,57,55,11,35,45,47,"千葉西","C","千葉南","C","成田","C","渋谷幕張","C",94,29,41,79,36,null,33,42,39,58,46,28,94,29,41,79,36,24,33,42,39,58,46,28]
[21]
[22]
[23]
[24]
[25]
[26]
[27]
[28]
[29]
[30]
[31]
[32]
[33]
[34]
[35]
[36]
[37]
[38]
[39]
[40]
[41]
[42]
[43]
[44]
[45]
[46]
[47]
[48]
[49]
[50]
[51]
[52]
[53]
[54]
[55]
[56]
[57]
[58]
[59]
[60]
[61]
[62]
[63]
[64]
[65]
[66]
[67]
[68]
[69]
[70]
[71]
[72]
[73]
[74]
[75]
[76]
[77]
[78]
[79]
[80]
[81]
[82]
[83]
[84]
[85]
[86]
[87]
[88]
[89]
[90]
[91]
[92]
[93]
[94]
[95]
[96]
[97]
[98]
[99]
[100]
[101]
[102]
[103]
[104]
[105]
[106]
[107]
[108]
[109]
[110]
[111]
[112]
[113]
[114]
[115]
[116]
[117]
[118]
[119]
[120]
[121]
[122]
[123]
[124]
[125]
[126]
[127]
[128]
[129]
[130]
[131]
[132]
[133]
[134]
[135]
[136]
[137]
[138]
[139]
[140]
[141]
[142]
[143]
[144]
[145]
[146]
[147]
[148]
[149]
[150]
[151]
[152]
[153]
[154]
[155]
[156]
[157]
[158]
[159]
[160]
[161]
[162]
[163]
[164]
[165]
[166]
[167]
[168]
[169]
[170]
[171]
[172]
[173]
[174]
[175]
[176]
[177]
[178]
[179]
[180]
[181]
[182]
[183]
[184]
[185]
[186]
[187]
[188]
[189]
[190]
[191]
[192]
[193]
[194]
[195]
[196]
[197]
[198]
[199]
[200]
[201]
[202]
[203]
[204]
[205]
[206]
[207]
[208]
[209]
[210]
[211]
[212]
[213]
[214]
[215]
[216]
[217]
[218]
[219]
[220]
[221]
[222]
[223]
[224]
[225]
[226]
[227]
[228]
[229]
[230]
[231]
[232]
[233]
[234]
[235]
[236]
[237]
[238]
[239]
[240]
[241]
[242]
[243]
[244]
[245]
[246]
[247]
[248]
[249]
[250]
[251]
[252]
[253]
[254]
[255]
[256]
[257]
[258]
[259]
[260]
[261]
[262]
[263]
[264]
[265]
[266]
[267]
[268]
[269]
[270]
[271]
[272]
[273]
[274]
[275]
[276]
[277]
[278]
[279]
[280]
[281]
[282]
[283]
[284]
[285]
[286]
[287]
[288]
[289]
[290]
[291]
[292]
[293]
[294]
[295]
[296]
[297]
[298]
[299]
[300]
[301]
[302]
[303]
[304]
[305]
[306]
[307]
[308]
[309]
[310]
[311]
[312]
[313]
[314]
[315]
[316]
[317]
[318]
[319]
[320]
[321]
[322]
[323]
[324]
[325]
[326]
[327]
[328]
[329]
[330]
[331]
[332]
[333]
[334]
[335]
[336]
[337]
[338]
[339]
[340]
[341]
[342]
[343]
[344]
[345]
[346]
[347]
[348]
[349]
[350]
[351]
[352]
[353]
[354]
[355]
[356]
[357]
[358]
[359]
[360]
[361]
[362]
[363]
[364]
[365]
[366]
[367]
[368]
[369]
[370]
[371]
[372]
[373]
[374]
[375]
[376]
[377]
[378]
[379]
[380]
[381]
[382]
[383]
[384]
[385]
[386]
[387]
[388]
[389]
[390]
[391]
[392]
[393]
[394]
[395]
[396]
[397]
[398]
[399]
[400]
[401]
[402]
[403]
[404]
[405]
[406]
[407]
[408]
[409]
[410]
[411]
[412]
[413]
[414]
[415]
[416]
[417]
[418]
[419]
[420]
[421]
[422]
[423]
[424]
[425]
[426]
[427]
[428]
[429]
[430]
[431]
[432]
[433]
[434]
[435]
[436]
[437]
[438]
[439]
[440]
[441]
[442]
[443]
[444]
[445]
[446]
[447]
[448]
[449]
[450]
[451]
[452]
[453]
[454]
[455]
[456]
[457]
[458]
[459]
[460]
[461]
[462]
[463]
[464]
[465]
[466]
[467]
[468]
[469]
[470]
[471]
[472]
[473]
[474]
[475]
[476]
[477]
[478]
[479]
[480]
[481]
[482]
[483]
[484]
[485]
[486]
[487]
[488]
[489]
[490]
[491]
[492]
[493]
[494]
[495]
[496]
[497]
[498]
[499]
[500]

{"sheet":"成績表","index":1,"n_rows":67,"n_cols":22,"rows_kept":67,"cut":false,"hidden":false,"merged":[[30,1,30,3],[30,11,30,14],[60,1,60,5],[30,18,30,19],[0,18,0,19],[1,10,1,13],[37,1,38,1],[35,2,36,2],[33,1,34,1],[33,2,34,2],[37,3,37,4],[34,3,34,4],[33,3,33,4],[32,3,32,4],[36,3,36,4],[32,12,32,15],[32,17,32,20],[43,2,44,2],[43,1,44,1],[40,3,40,4],[35,3,35,4],[37,2,38,2],[41,1,42,1],[44,12,44,15],[66,1,66,2],[41,2,42,2],[35,1,36,1],[39,1,40,1],[39,2,40,2],[43,0,44,0],[61,1,61,2],[62,1,62,2],[47,0,48,0],[49,0,50,0],[63,1,63,2],[64,1,64,2],[65,1,65,2],[51,0,51,2],[43,3,43,4],[45,0,46,0],[45,3,45,4],[46,3,46,4],[45,1,46,1],[45,2,46,2],[44,3,44,4],[34,12,34,15],[35,12,35,15],[36,12,36,15],[39,3,39,4],[38,3,38,4],[42,3,42,4],[41,3,41,4],[33,0,34,0],[35,0,36,0],[37,0,38,0],[39,0,40,0],[41,0,42,0],[33,12,33,15],[37,12,37,15],[38,12,38,15],[0,20,0,23],[30,20,30,23],[1,17,1,18],[47,17,47,20],[48,17,48,20],[49,17,49,20],[50,17,50,20],[48,12,48,15],[49,12,49,15],[50,12,50,15],[47,12,47,15],[42,17,42,20],[43,17,43,20],[44,17,44,20],[45,17,45,20],[43,12,43,15],[46,17,46,20],[46,12,46,15],[45,12,45,15],[39,12,39,15],[40,12,40,15],[41,12,41,15],[42,12,42,15],[33,17,33,20],[51,4,51,6],[51,8,51,10],[51,12,51,14],[51,16,51,18],[51,20,51,22],[1,1,1,3],[2,10,2,13],[1,19,1,22],[50,3,50,4],[49,1,50,1],[49,2,50,2],[47,3,47,4],[48,3,48,4],[49,3,49,4],[47,1,48,1],[47,2,48,2],[34,17,34,20],[35,17,35,20],[36,17,36,20],[37,17,37,20],[38,17,38,20],[39,17,39,20],[40,17,40,20],[41,17,41,20]]}
[]
[null,{"$f":"IF(初期設定!$C2=\"\",\"\",初期設定!$C2)","v":"月例テスト"},null,null,null,null,"ID:",1,{"$f":"IF(VLOOKUP($H2,テストデータ!$A$4:$C503,2,FALSE)=\"\",\"\",VLOOKUP($H2,テストデータ!$A$4:$C503,2,FALSE))","v":"3-1"},"氏名",{"$f":"IF(VLOOKUP($H2,テストデータ!$A$4:$C503,3,FALSE)=\"\",\"\",VLOOKUP($H2,テストデータ!$A$4:$C503,3,FALSE))","v":"鈴木A男"},null,null,null,null,null,null,null,null,{"$f":"初期設定!B44","v":"微風進学塾"}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(初期設定!C1=\"\",\"\",初期設定!C1)","v":"20xx年度"}]
[null,{"$f":"IF(初期設定!$C3=\"\",\"\",初期設定!$C3)","v":"英語"},"1回","2回","3回","4回","5回","6回","7回","8回","9回","10回","11回","12回"]
[null,"実施日",{"$f":"IF(テストデータ!D$2=\"\",\"\",テストデータ!D$2)","v":"3/2"},{"$f":"IF(テストデータ!E$2=\"\",\"\",テストデータ!E$2)","v":"4/3"},{"$f":"IF(テストデータ!F$2=\"\",\"\",テストデータ!F$2)","v":"5/4"},{"$f":"IF(テストデータ!G$2=\"\",\"\",テストデータ!G$2)","v":"6/5"},{"$f":"IF(テストデータ!H$2=\"\",\"\",テストデータ!H$2)","v":"7/6"},{"$f":"IF(テストデータ!I$2=\"\",\"\",テストデータ!I$2)","v":"8/7"},{"$f":"IF(テストデータ!J$2=\"\",\"\",テストデータ!J$2)","v":"9/8"},{"$f":"IF(テストデータ!K$2=\"\",\"\",テストデータ!K$2)","v":"10/9"},{"$f":"IF(テストデータ!L$2=\"\",\"\",テストデータ!L$2)","v":"11/10"},{"$f":"IF(テストデータ!M$2=\"\",\"\",テストデータ!M$2)","v":"12/11"},{"$f":"IF(テストデータ!N$2=\"\",\"\",テストデータ!N$2)","v":""},{"$f":"IF(テストデータ!O$2=\"\",\"\",テストデータ!O$2)","v":""}]
[null,"得点",{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JL$503,4,FALSE)=\"\",IF(INDIRECT(ADDRESS(ROW()-1,COLUMN()))=\"\",\"\",\"欠\"),VLOOKUP($H$2,テストデータ!$A$4:$JL$503,4,FALSE))","v":"欠"},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JL$503,5,FALSE)=\"\",IF(INDIRECT(ADDRESS(ROW()-1,COLUMN()))=\"\",\"\",\"欠\"),VLOOKUP($H$2,テストデータ!$A$4:$JL$503,5,FALSE))","v":50},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JL$503,6,FALSE)=\"\",IF(INDIRECT(ADDRESS(ROW()-1,COLUMN()))=\"\",\"\",\"欠\"),VLOOKUP($H$2,テストデータ!$A$4:$JL$503,6,FALSE))","v":97},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JL$503,7,FALSE)=\"\",IF(INDIRECT(ADDRESS(ROW()-1,COLUMN()))=\"\",\"\",\"欠\"),VLOOKUP($H$2,テストデータ!$A$4:$JL$503,7,FALSE))","v":72},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JL$503,8,FALSE)=\"\",IF(INDIRECT(ADDRESS(ROW()-1,COLUMN()))=\"\",\"\",\"欠\"),VLOOKUP($H$2,テストデータ!$A$4:$JL$503,8,FALSE))","v":90},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JL$503,9,FALSE)=\"\",IF(INDIRECT(ADDRESS(ROW()-1,COLUMN()))=\"\",\"\",\"欠\"),VLOOKUP($H$2,テストデータ!$A$4:$JL$503,9,FALSE))","v":25},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JL$503,10,FALSE)=\"\",IF(INDIRECT(ADDRESS(ROW()-1,COLUMN()))=\"\",\"\",\"欠\"),VLOOKUP($H$2,テストデータ!$A$4:$JL$503,10,FALSE))","v":90},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JL$503,11,FALSE)=\"\",IF(INDIRECT(ADDRESS(ROW()-1,COLUMN()))=\"\",\"\",\"欠\"),VLOOKUP($H$2,テストデータ!$A$4:$JL$503,11,FALSE))","v":50},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JL$503,12,FALSE)=\"\",IF(INDIRECT(ADDRESS(ROW()-1,COLUMN()))=\"\",\"\",\"欠\"),VLOOKUP($H$2,テストデータ!$A$4:$JL$503,12,FALSE))","v":97},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JL$503,13,FALSE)=\"\",IF(INDIRECT(ADDRESS(ROW()-1,COLUMN()))=\"\",\"\",\"欠\"),VLOOKUP($H$2,テストデータ!$A$4:$JL$503,13,FALSE))","v":72},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JL$503,14,FALSE)=\"\",IF(INDIRECT(ADDRESS(ROW()-1,COLUMN()))=\"\",\"\",\"欠\"),VLOOKUP($H$2,テストデータ!$A$4:$JL$503,14,FALSE))","v":""},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JL$503,15,FALSE)=\"\",IF(INDIRECT(ADDRESS(ROW()-1,COLUMN()))=\"\",\"\",\"欠\"),VLOOKUP($H$2,テストデータ!$A$4:$JL$503,15,FALSE))","v":""}]
[null,"平均点",{"$f":"IF(COUNT(OFFSET(テストデータ!$D$3,1,12*0+0):OFFSET(テストデータ!$D$3,500,12*0+0))=0,NA(),AVERAGE(OFFSET(テストデータ!$D$3,1,12*0+0):OFFSET(テストデータ!$D$3,500,12*0+0)))","v":55.722222222222221},{"$f":"IF(COUNT(OFFSET(テストデータ!$D$3,1,12*0+1):OFFSET(テストデータ!$D$3,500,12*0+1))=0,NA(),AVERAGE(OFFSET(テストデータ!$D$3,1,12*0+1):OFFSET(テストデータ!$D$3,500,12*0+1)))","v":48.35},{"$f":"IF(COUNT(OFFSET(テストデータ!$D$3,1,12*0+2):OFFSET(テストデータ!$D$3,500,12*0+2))=0,NA(),AVERAGE(OFFSET(テストデータ!$D$3,1,12*0+2):OFFSET(テストデータ!$D$3,500,12*0+2)))","v":47},{"$f":"IF(COUNT(OFFSET(テストデータ!$D$3,1,12*0+3):OFFSET(テストデータ!$D$3,500,12*0+3))=0,NA(),AVERAGE(OFFSET(テストデータ!$D$3,1,12*0+3):OFFSET(テストデータ!$D$3,500,12*0+3)))","v":46.7},{"$f":"IF(COUNT(OFFSET(テストデータ!$D$3,1,12*0+4):OFFSET(テストデータ!$D$3,500,12*0+4))=0,NA(),AVERAGE(OFFSET(テストデータ!$D$3,1,12*0+4):OFFSET(テストデータ!$D$3,500,12*0+4)))","v":52.55},{"$f":"IF(COUNT(OFFSET(テストデータ!$D$3,1,12*0+5):OFFSET(テストデータ!$D$3,500,12*0+5))=0,NA(),AVERAGE(OFFSET(テストデータ!$D$3,1,12*0+5):OFFSET(テストデータ!$D$3,500,12*0+5)))","v":52},{"$f":"IF(COUNT(OFFSET(テストデータ!$D$3,1,12*0+6):OFFSET(テストデータ!$D$3,500,12*0+6))=0,NA(),AVERAGE(OFFSET(テストデータ!$D$3,1,12*0+6):OFFSET(テストデータ!$D$3,500,12*0+6)))","v":56.25},{"$f":"IF(COUNT(OFFSET(テストデータ!$D$3,1,12*0+7):OFFSET(テストデータ!$D$3,500,12*0+7))=0,NA(),AVERAGE(OFFSET(テストデータ!$D$3,1,12*0+7):OFFSET(テストデータ!$D$3,500,12*0+7)))","v":61.736842105263158},{"$f":"IF(COUNT(OFFSET(テストデータ!$D$3,1,12*0+8):OFFSET(テストデータ!$D$3,500,12*0+8))=0,NA(),AVERAGE(OFFSET(テストデータ!$D$3,1,12*0+8):OFFSET(テストデータ!$D$3,500,12*0+8)))","v":60.2},{"$f":"IF(COUNT(OFFSET(テストデータ!$D$3,1,12*0+9):OFFSET(テストデータ!$D$3,500,12*0+9))=0,NA(),AVERAGE(OFFSET(テストデータ!$D$3,1,12*0+9):OFFSET(テストデータ!$D$3,500,12*0+9)))","v":52.736842105263158},{"$f":"IF(COUNT(OFFSET(テストデータ!$D$3,1,12*0+10):OFFSET(テストデータ!$D$3,500,12*0+10))=0,NA(),AVERAGE(OFFSET(テストデータ!$D$3,1,12*0+10):OFFSET(テストデータ!$D$3,500,12*0+10)))","v":{"$error":"#N/A"}},{"$f":"IF(COUNT(OFFSET(テストデータ!$D$3,1,12*0+11):OFFSET(テストデータ!$D$3,500,12*0+11))=0,NA(),AVERAGE(OFFSET(テストデータ!$D$3,1,12*0+11):OFFSET(テストデータ!$D$3,500,12*0+11)))","v":{"$error":"#N/A"}}]
[null,"塾内順位",{"$f":"IF(OR(INDIRECT(ADDRESS(ROW()-2,COLUMN()))=\"欠\",INDIRECT(ADDRESS(ROW()-2,COLUMN()))=\"\"),\"\",RANK(INDIRECT(ADDRESS(ROW()-2,COLUMN())),OFFSET(テストデータ!D$3,1,0):OFFSET(テストデータ!D$3,500,0)))","v":""},{"$f":"IF(OR(INDIRECT(ADDRESS(ROW()-2,COLUMN()))=\"欠\",INDIRECT(ADDRESS(ROW()-2,COLUMN()))=\"\"),\"\",RANK(INDIRECT(ADDRESS(ROW()-2,COLUMN())),OFFSET(テストデータ!E$3,1,0):OFFSET(テストデータ!E$3,500,0)))","v":9},{"$f":"IF(OR(INDIRECT(ADDRESS(ROW()-2,COLUMN()))=\"欠\",INDIRECT(ADDRESS(ROW()-2,COLUMN()))=\"\"),\"\",RANK(INDIRECT(ADDRESS(ROW()-2,COLUMN())),OFFSET(テストデータ!F$3,1,0):OFFSET(テストデータ!F$3,500,0)))","v":1},{"$f":"IF(OR(INDIRECT(ADDRESS(ROW()-2,COLUMN()))=\"欠\",INDIRECT(ADDRESS(ROW()-2,COLUMN()))=\"\"),\"\",RANK(INDIRECT(ADDRESS(ROW()-2,COLUMN())),OFFSET(テストデータ!G$3,1,0):OFFSET(テストデータ!G$3,500,0)))","v":6},{"$f":"IF(OR(INDIRECT(ADDRESS(ROW()-2,COLUMN()))=\"欠\",INDIRECT(ADDRESS(ROW()-2,COLUMN()))=\"\"),\"\",RANK(INDIRECT(ADDRESS(ROW()-2,COLUMN())),OFFSET(テストデータ!H$3,1,0):OFFSET(テストデータ!H$3,500,0)))","v":2},{"$f":"IF(OR(INDIRECT(ADDRESS(ROW()-2,COLUMN()))=\"欠\",INDIRECT(ADDRESS(ROW()-2,COLUMN()))=\"\"),\"\",RANK(INDIRECT(ADDRESS(ROW()-2,COLUMN())),OFFSET(テストデータ!I$3,1,0):OFFSET(テストデータ!I$3,500,0)))","v":14},{"$f":"IF(OR(INDIRECT(ADDRESS(ROW()-2,COLUMN()))=\"欠\",INDIRECT(ADDRESS(ROW()-2,COLUMN()))=\"\"),\"\",RANK(INDIRECT(ADDRESS(ROW()-2,COLUMN())),OFFSET(テストデータ!J$3,1,0):OFFSET(テストデータ!J$3,500,0)))","v":2},{"$f":"IF(OR(INDIRECT(ADDRESS(ROW()-2,COLUMN()))=\"欠\",INDIRECT(ADDRESS(ROW()-2,COLUMN()))=\"\"),\"\",RANK(INDIRECT(ADDRESS(ROW()-2,COLUMN())),OFFSET(テストデータ!K$3,1,0):OFFSET(テストデータ!K$3,500,0)))","v":14},{"$f":"IF(OR(INDIRECT(ADDRESS(ROW()-2,COLUMN()))=\"欠\",INDIRECT(ADDRESS(ROW()-2,COLUMN()))=\"\"),\"\",RANK(INDIRECT(ADDRESS(ROW()-2,COLUMN())),OFFSET(テストデータ!L$3,1,0):OFFSET(テストデータ!L$3,500,0)))","v":1},{"$f":"IF(OR(INDIRECT(ADDRESS(ROW()-2,COLUMN()))=\"欠\",INDIRECT(ADDRESS(ROW()-2,COLUMN()))=\"\"),\"\",RANK(INDIRECT(ADDRESS(ROW()-2,COLUMN())),OFFSET(テストデータ!M$3,1,0):OFFSET(テストデータ!M$3,500,0)))","v":6},{"$f":"IF(OR(INDIRECT(ADDRESS(ROW()-2,COLUMN()))=\"欠\",INDIRECT(ADDRESS(ROW()-2,COLUMN()))=\"\"),\"\",RANK(INDIRECT(ADDRESS(ROW()-2,COLUMN())),OFFSET(テストデータ!N$3,1,0):OFFSET(テストデータ!N$3,500,0)))","v":""},{"$f":"IF(OR(INDIRECT(ADDRESS(ROW()-2,COLUMN()))=\"欠\",INDIRECT(ADDRESS(ROW()-2,COLUMN()))=\"\"),\"\",RANK(INDIRECT(ADDRESS(ROW()-2,COLUMN())),OFFSET(テストデータ!O$3,1,0):OFFSET(テストデータ!O$3,500,0)))","v":""}]
[null,{"$f":"IF(初期設定!$C4=\"\",\"\",初期設定!$C4)","v":"数学"},"1回","2回","3回","4回","5回","6回","7回","8回","9回","10回","11回","12回"]
[null,"実施日"]
[null,"得点"]
[null,"平均点"]
[null,"塾内順位"]
[null,{"$f":"IF(初期設定!$C5=\"\",\"\",初期設定!$C5)","v":"国語"},"1回","2回","3回","4回","5回","6回","7回","8回","9回","10回","11回","12回"]
[null,"実施日",{"$f":"IF(テストデータ!AB$2=\"\",\"\",テストデータ!AB$2)","v":"4/9"},{"$f":"IF(テストデータ!AC$2=\"\",\"\",テストデータ!AC$2)","v":"5/12"},{"$f":"IF(テストデータ!AD$2=\"\",\"\",テストデータ!AD$2)","v":"6/15"},{"$f":"IF(テストデータ!AE$2=\"\",\"\",テストデータ!AE$2)","v":"7/18"},{"$f":"IF(テストデータ!AF$2=\"\",\"\",テストデータ!AF$2)","v":"8/5"},{"$f":"IF(テストデータ!AG$2=\"\",\"\",テストデータ!AG$2)","v":"9/7"},{"$f":"IF(テストデータ!AH$2=\"\",\"\",テストデータ!AH$2)","v":"10/11"},{"$f":"IF(テストデータ!AI$2=\"\",\"\",テストデータ!AI$2)","v":"11/30"},{"$f":"IF(テストデータ!AJ$2=\"\",\"\",テストデータ!AJ$2)","v":"12/2"},{"$f":"IF(テストデータ!AK$2=\"\",\"\",テストデータ!AK$2)","v":"1/9"},{"$f":"IF(テストデータ!AL$2=\"\",\"\",テストデータ!AL$2)","v":""},{"$f":"IF(テストデータ!AM$2=\"\",\"\",テストデータ!AM$2)","v":""}]
[null,"得点",{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JL$503,28,FALSE)=\"\",IF(INDIRECT(ADDRESS(ROW()-1,COLUMN()))=\"\",\"\",\"欠\"),VLOOKUP($H$2,テストデータ!$A$4:$JL$503,28,FALSE))","v":"欠"},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JL$503,29,FALSE)=\"\",IF(INDIRECT(ADDRESS(ROW()-1,COLUMN()))=\"\",\"\",\"欠\"),VLOOKUP($H$2,テストデータ!$A$4:$JL$503,29,FALSE))","v":50},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JL$503,30,FALSE)=\"\",IF(INDIRECT(ADDRESS(ROW()-1,COLUMN()))=\"\",\"\",\"欠\"),VLOOKUP($H$2,テストデータ!$A$4:$JL$503,30,FALSE))","v":97},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JL$503,31,FALSE)=\"\",IF(INDIRECT(ADDRESS(ROW()-1,COLUMN()))=\"\",\"\",\"欠\"),VLOOKUP($H$2,テストデータ!$A$4:$JL$503,31,FALSE))","v":72},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JL$503,32,FALSE)=\"\",IF(INDIRECT(ADDRESS(ROW()-1,COLUMN()))=\"\",\"\",\"欠\"),VLOOKUP($H$2,テストデータ!$A$4:$JL$503,32,FALSE))","v":25},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JL$503,33,FALSE)=\"\",IF(INDIRECT(ADDRESS(ROW()-1,COLUMN()))=\"\",\"\",\"欠\"),VLOOKUP($H$2,テストデータ!$A$4:$JL$503,33,FALSE))","v":25},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JL$503,34,FALSE)=\"\",IF(INDIRECT(ADDRESS(ROW()-1,COLUMN()))=\"\",\"\",\"欠\"),VLOOKUP($H$2,テストデータ!$A$4:$JL$503,34,FALSE))","v":90},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JL$503,35,FALSE)=\"\",IF(INDIRECT(ADDRESS(ROW()-1,COLUMN()))=\"\",\"\",\"欠\"),VLOOKUP($H$2,テストデータ!$A$4:$JL$503,35,FALSE))","v":50},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JL$503,36,FALSE)=\"\",IF(INDIRECT(ADDRESS(ROW()-1,COLUMN()))=\"\",\"\",\"欠\"),VLOOKUP($H$2,テストデータ!$A$4:$JL$503,36,FALSE))","v":97},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JL$503,37,FALSE)=\"\",IF(INDIRECT(ADDRESS(ROW()-1,COLUMN()))=\"\",\"\",\"欠\"),VLOOKUP($H$2,テストデータ!$A$4:$JL$503,37,FALSE))","v":72},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JL$503,38,FALSE)=\"\",IF(INDIRECT(ADDRESS(ROW()-1,COLUMN()))=\"\",\"\",\"欠\"),VLOOKUP($H$2,テストデータ!$A$4:$JL$503,38,FALSE))","v":""},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JL$503,39,FALSE)=\"\",IF(INDIRECT(ADDRESS(ROW()-1,COLUMN()))=\"\",\"\",\"欠\"),VLOOKUP($H$2,テストデータ!$A$4:$JL$503,39,FALSE))","v":""}]
[null,"平均点",{"$f":"IF(COUNT(OFFSET(テストデータ!$D$3,1,12*2+0):OFFSET(テストデータ!$D$3,500,12*2+0))=0,NA(),AVERAGE(OFFSET(テストデータ!$D$3,1,12*2+0):OFFSET(テストデータ!$D$3,500,12*2+0)))","v":66.263157894736835},{"$f":"IF(COUNT(OFFSET(テストデータ!$D$3,1,12*2+1):OFFSET(テストデータ!$D$3,500,12*2+1))=0,NA(),AVERAGE(OFFSET(テストデータ!$D$3,1,12*2+1):OFFSET(テストデータ!$D$3,500,12*2+1)))","v":48.85},{"$f":"IF(COUNT(OFFSET(テストデータ!$D$3,1,12*2+2):OFFSET(テストデータ!$D$3,500,12*2+2))=0,NA(),AVERAGE(OFFSET(テストデータ!$D$3,1,12*2+2):OFFSET(テストデータ!$D$3,500,12*2+2)))","v":58.95},{"$f":"IF(COUNT(OFFSET(テストデータ!$D$3,1,12*2+3):OFFSET(テストデータ!$D$3,500,12*2+3))=0,NA(),AVERAGE(OFFSET(テストデータ!$D$3,1,12*2+3):OFFSET(テストデータ!$D$3,500,12*2+3)))","v":51.1},{"$f":"IF(COUNT(OFFSET(テストデータ!$D$3,1,12*2+4):OFFSET(テストデータ!$D$3,500,12*2+4))=0,NA(),AVERAGE(OFFSET(テストデータ!$D$3,1,12*2+4):OFFSET(テストデータ!$D$3,500,12*2+4)))","v":51.5},{"$f":"IF(COUNT(OFFSET(テストデータ!$D$3,1,12*2+5):OFFSET(テストデータ!$D$3,500,12*2+5))=0,NA(),AVERAGE(OFFSET(テストデータ!$D$3,1,12*2+5):OFFSET(テストデータ!$D$3,500,12*2+5)))","v":50.7},{"$f":"IF(COUNT(OFFSET(テストデータ!$D$3,1,12*2+6):OFFSET(テストデータ!$D$3,500,12*2+6))=0,NA(),AVERAGE(OFFSET(テストデータ!$D$3,1,12*2+6):OFFSET(テストデータ!$D$3,500,12*2+6)))","v":55.9},{"$f":"IF(COUNT(OFFSET(テストデータ!$D$3,1,12*2+7):OFFSET(テストデータ!$D$3,500,12*2+7))=0,NA(),AVERAGE(OFFSET(テストデータ!$D$3,1,12*2+7):OFFSET(テストデータ!$D$3,500,12*2+7)))","v":65.95},{"$f":"IF(COUNT(OFFSET(テストデータ!$D$3,1,12*2+8):OFFSET(テストデータ!$D$3,500,12*2+8))=0,NA(),AVERAGE(OFFSET(テストデータ!$D$3,1,12*2+8):OFFSET(テストデータ!$D$3,500,12*2+8)))","v":59.176470588235297},{"$f":"IF(COUNT(OFFSET(テストデータ!$D$3,1,12*2+9):OFFSET(テストデータ!$D$3,500,12*2+9))=0,NA(),AVERAGE(OFFSET(テストデータ!$D$3,1,12*2+9):OFFSET(テストデータ!$D$3,500,12*2+9)))","v":63.85},{"$f":"IF(COUNT(OFFSET(テストデータ!$D$3,1,12*2+10):OFFSET(テストデータ!$D$3,500,12*2+10))=0,NA(),AVERAGE(OFFSET(テストデータ!$D$3,1,12*2+10):OFFSET(テストデータ!$D$3,500,12*2+10)))","v":{"$error":"#N/A"}},{"$f":"IF(COUNT(OFFSET(テストデータ!$D$3,1,12*2+11):OFFSET(テストデータ!$D$3,500,12*2+11))=0,NA(),AVERAGE(OFFSET(テストデータ!$D$3,1,12*2+11):OFFSET(テストデータ!$D$3,500,12*2+11)))","v":{"$error":"#N/A"}}]
[null,"塾内順位",{"$f":"IF(OR(INDIRECT(ADDRESS(ROW()-2,COLUMN()))=\"欠\",INDIRECT(ADDRESS(ROW()-2,COLUMN()))=\"\"),\"\",RANK(INDIRECT(ADDRESS(ROW()-2,COLUMN())),OFFSET(テストデータ!AB$3,1,0):OFFSET(テストデータ!AB$3,500,0)))","v":""},{"$f":"IF(OR(INDIRECT(ADDRESS(ROW()-2,COLUMN()))=\"欠\",INDIRECT(ADDRESS(ROW()-2,COLUMN()))=\"\"),\"\",RANK(INDIRECT(ADDRESS(ROW()-2,COLUMN())),OFFSET(テストデータ!AC$3,1,0):OFFSET(テストデータ!AC$3,500,0)))","v":10},{"$f":"IF(OR(INDIRECT(ADDRESS(ROW()-2,COLUMN()))=\"欠\",INDIRECT(ADDRESS(ROW()-2,COLUMN()))=\"\"),\"\",RANK(INDIRECT(ADDRESS(ROW()-2,COLUMN())),OFFSET(テストデータ!AD$3,1,0):OFFSET(テストデータ!AD$3,500,0)))","v":2},{"$f":"IF(OR(INDIRECT(ADDRESS(ROW()-2,COLUMN()))=\"欠\",INDIRECT(ADDRESS(ROW()-2,COLUMN()))=\"\"),\"\",RANK(INDIRECT(ADDRESS(ROW()-2,COLUMN())),OFFSET(テストデータ!AE$3,1,0):OFFSET(テストデータ!AE$3,500,0)))","v":4},{"$f":"IF(OR(INDIRECT(ADDRESS(ROW()-2,COLUMN()))=\"欠\",INDIRECT(ADDRESS(ROW()-2,COLUMN()))=\"\"),\"\",RANK(INDIRECT(ADDRESS(ROW()-2,COLUMN())),OFFSET(テストデータ!AF$3,1,0):OFFSET(テストデータ!AF$3,500,0)))","v":15},{"$f":"IF(OR(INDIRECT(ADDRESS(ROW()-2,COLUMN()))=\"欠\",INDIRECT(ADDRESS(ROW()-2,COLUMN()))=\"\"),\"\",RANK(INDIRECT(ADDRESS(ROW()-2,COLUMN())),OFFSET(テストデータ!AG$3,1,0):OFFSET(テストデータ!AG$3,500,0)))","v":15},{"$f":"IF(OR(INDIRECT(ADDRESS(ROW()-2,COLUMN()))=\"欠\",INDIRECT(ADDRESS(ROW()-2,COLUMN()))=\"\"),\"\",RANK(INDIRECT(ADDRESS(ROW()-2,COLUMN())),OFFSET(テストデータ!AH$3,1,0):OFFSET(テストデータ!AH$3,500,0)))","v":5},{"$f":"IF(OR(INDIRECT(ADDRESS(ROW()-2,COLUMN()))=\"欠\",INDIRECT(ADDRESS(ROW()-2,COLUMN()))=\"\"),\"\",RANK(INDIRECT(ADDRESS(ROW()-2,COLUMN())),OFFSET(テストデータ!AI$3,1,0):OFFSET(テストデータ!AI$3,500,0)))","v":13},{"$f":"IF(OR(INDIRECT(ADDRESS(ROW()-2,COLUMN()))=\"欠\",INDIRECT(ADDRESS(ROW()-2,COLUMN()))=\"\"),\"\",RANK(INDIRECT(ADDRESS(ROW()-2,COLUMN())),OFFSET(テストデータ!AJ$3,1,0):OFFSET(テストデータ!AJ$3,500,0)))","v":2},{"$f":"IF(OR(INDIRECT(ADDRESS(ROW()-2,COLUMN()))=\"欠\",INDIRECT(ADDRESS(ROW()-2,COLUMN()))=\"\"),\"\",RANK(INDIRECT(ADDRESS(ROW()-2,COLUMN())),OFFSET(テストデータ!AK$3,1,0):OFFSET(テストデータ!AK$3,500,0)))","v":9},{"$f":"IF(OR(INDIRECT(ADDRESS(ROW()-2,COLUMN()))=\"欠\",INDIRECT(ADDRESS(ROW()-2,COLUMN()))=\"\"),\"\",RANK(INDIRECT(ADDRESS(ROW()-2,COLUMN())),OFFSET(テストデータ!AL$3,1,0):OFFSET(テストデータ!AL$3,500,0)))","v":""},{"$f":"IF(OR(INDIRECT(ADDRESS(ROW()-2,COLUMN()))=\"欠\",INDIRECT(ADDRESS(ROW()-2,COLUMN()))=\"\"),\"\",RANK(INDIRECT(ADDRESS(ROW()-2,COLUMN())),OFFSET(テストデータ!AM$3,1,0):OFFSET(テストデータ!AM$3,500,0)))","v":""}]
[null,{"$f":"IF(初期設定!$C6=\"\",\"\",初期設定!$C6)","v":"社会"},"1回","2回","3回","4回","5回","6回","7回","8回","9回","10回","11回","12回"]
[null,"実施日",{"$f":"IF(テストデータ!AN$2=\"\",\"\",テストデータ!AN$2)","v":"4/5"},{"$f":"IF(テストデータ!AO$2=\"\",\"\",テストデータ!AO$2)","v":"5/2"},{"$f":"IF(テストデータ!AP$2=\"\",\"\",テストデータ!AP$2)","v":"6/5"},{"$f":"IF(テストデータ!AQ$2=\"\",\"\",テストデータ!AQ$2)","v":"7/18"},{"$f":"IF(テストデータ!AR$2=\"\",\"\",テストデータ!AR$2)","v":"8/5"},{"$f":"IF(テストデータ!AS$2=\"\",\"\",テストデータ!AS$2)","v":"9/7"},{"$f":"IF(テストデータ!AT$2=\"\",\"\",テストデータ!AT$2)","v":"10/5"},{"$f":"IF(テストデータ!AU$2=\"\",\"\",テストデータ!AU$2)","v":"11/30"},{"$f":"IF(テストデータ!AV$2=\"\",\"\",テストデータ!AV$2)","v":"12/4"},{"$f":"IF(テストデータ!AW$2=\"\",\"\",テストデータ!AW$2)","v":"1/9"},{"$f":"IF(テストデータ!AX$2=\"\",\"\",テストデータ!AX$2)","v":""},{"$f":"IF(テストデータ!AY$2=\"\",\"\",テストデータ!AY$2)","v":""}]
[null,"得点",{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JL$503,40,FALSE)=\"\",IF(INDIRECT(ADDRESS(ROW()-1,COLUMN()))=\"\",\"\",\"欠\"),VLOOKUP($H$2,テストデータ!$A$4:$JL$503,40,FALSE))","v":90},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JL$503,41,FALSE)=\"\",IF(INDIRECT(ADDRESS(ROW()-1,COLUMN()))=\"\",\"\",\"欠\"),VLOOKUP($H$2,テストデータ!$A$4:$JL$503,41,FALSE))","v":50},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JL$503,42,FALSE)=\"\",IF(INDIRECT(ADDRESS(ROW()-1,COLUMN()))=\"\",\"\",\"欠\"),VLOOKUP($H$2,テストデータ!$A$4:$JL$503,42,FALSE))","v":12},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JL$503,43,FALSE)=\"\",IF(INDIRECT(ADDRESS(ROW()-1,COLUMN()))=\"\",\"\",\"欠\"),VLOOKUP($H$2,テストデータ!$A$4:$JL$503,43,FALSE))","v":72},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JL$503,44,FALSE)=\"\",IF(INDIRECT(ADDRESS(ROW()-1,COLUMN()))=\"\",\"\",\"欠\"),VLOOKUP($H$2,テストデータ!$A$4:$JL$503,44,FALSE))","v":31},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JL$503,45,FALSE)=\"\",IF(INDIRECT(ADDRESS(ROW()-1,COLUMN()))=\"\",\"\",\"欠\"),VLOOKUP($H$2,テストデータ!$A$4:$JL$503,45,FALSE))","v":60},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JL$503,46,FALSE)=\"\",IF(INDIRECT(ADDRESS(ROW()-1,COLUMN()))=\"\",\"\",\"欠\"),VLOOKUP($H$2,テストデータ!$A$4:$JL$503,46,FALSE))","v":13},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JL$503,47,FALSE)=\"\",IF(INDIRECT(ADDRESS(ROW()-1,COLUMN()))=\"\",\"\",\"欠\"),VLOOKUP($H$2,テストデータ!$A$4:$JL$503,47,FALSE))","v":86},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JL$503,48,FALSE)=\"\",IF(INDIRECT(ADDRESS(ROW()-1,COLUMN()))=\"\",\"\",\"欠\"),VLOOKUP($H$2,テストデータ!$A$4:$JL$503,48,FALSE))","v":66},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JL$503,49,FALSE)=\"\",IF(INDIRECT(ADDRESS(ROW()-1,COLUMN()))=\"\",\"\",\"欠\"),VLOOKUP($H$2,テストデータ!$A$4:$JL$503,49,FALSE))","v":23},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JL$503,50,FALSE)=\"\",IF(INDIRECT(ADDRESS(ROW()-1,COLUMN()))=\"\",\"\",\"欠\"),VLOOKUP($H$2,テストデータ!$A$4:$JL$503,50,FALSE))","v":""},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JL$503,51,FALSE)=\"\",IF(INDIRECT(ADDRESS(ROW()-1,COLUMN()))=\"\",\"\",\"欠\"),VLOOKUP($H$2,テストデータ!$A$4:$JL$503,51,FALSE))","v":""}]
[null,"平均点",{"$f":"IF(COUNT(OFFSET(テストデータ!$D$3,1,12*3+0):OFFSET(テストデータ!$D$3,500,12*3+0))=0,NA(),AVERAGE(OFFSET(テストデータ!$D$3,1,12*3+0):OFFSET(テストデータ!$D$3,500,12*3+0)))","v":54.25},{"$f":"IF(COUNT(OFFSET(テストデータ!$D$3,1,12*3+1):OFFSET(テストデータ!$D$3,500,12*3+1))=0,NA(),AVERAGE(OFFSET(テストデータ!$D$3,1,12*3+1):OFFSET(テストデータ!$D$3,500,12*3+1)))","v":54.4},{"$f":"IF(COUNT(OFFSET(テストデータ!$D$3,1,12*3+2):OFFSET(テストデータ!$D$3,500,12*3+2))=0,NA(),AVERAGE(OFFSET(テストデータ!$D$3,1,12*3+2):OFFSET(テストデータ!$D$3,500,12*3+2)))","v":47.3},{"$f":"IF(COUNT(OFFSET(テストデータ!$D$3,1,12*3+3):OFFSET(テストデータ!$D$3,500,12*3+3))=0,NA(),AVERAGE(OFFSET(テストデータ!$D$3,1,12*3+3):OFFSET(テストデータ!$D$3,500,12*3+3)))","v":66.89473684210526},{"$f":"IF(COUNT(OFFSET(テストデータ!$D$3,1,12*3+4):OFFSET(テストデータ!$D$3,500,12*3+4))=0,NA(),AVERAGE(OFFSET(テストデータ!$D$3,1,12*3+4):OFFSET(テストデータ!$D$3,500,12*3+4)))","v":50.263157894736842},{"$f":"IF(COUNT(OFFSET(テストデータ!$D$3,1,12*3+5):OFFSET(テストデータ!$D$3,500,12*3+5))=0,NA(),AVERAGE(OFFSET(テストデータ!$D$3,1,12*3+5):OFFSET(テストデータ!$D$3,500,12*3+5)))","v":58.1},{"$f":"IF(COUNT(OFFSET(テストデータ!$D$3,1,12*3+6):OFFSET(テストデータ!$D$3,500,12*3+6))=0,NA(),AVERAGE(OFFSET(テストデータ!$D$3,1,12*3+6):OFFSET(テストデータ!$D$3,500,12*3+6)))","v":59.85},{"$f":"IF(COUNT(OFFSET(テストデータ!$D$3,1,12*3+7):OFFSET(テストデータ!$D$3,500,12*3+7))=0,NA(),AVERAGE(OFFSET(テストデータ!$D$3,1,12*3+7):OFFSET(テストデータ!$D$3,500,12*3+7)))","v":49},{"$f":"IF(COUNT(OFFSET(テストデータ!$D$3,1,12*3+8):OFFSET(テストデータ!$D$3,500,12*3+8))=0,NA(),AVERAGE(OFFSET(テストデータ!$D$3,1,12*3+8):OFFSET(テストデータ!$D$3,500,12*3+8)))","v":51},{"$f":"IF(COUNT(OFFSET(テストデータ!$D$3,1,12*3+9):OFFSET(テストデータ!$D$3,500,12*3+9))=0,NA(),AVERAGE(OFFSET(テストデータ!$D$3,1,12*3+9):OFFSET(テストデータ!$D$3,500,12*3+9)))","v":59.85},{"$f":"IF(COUNT(OFFSET(テストデータ!$D$3,1,12*3+10):OFFSET(テストデータ!$D$3,500,12*3+10))=0,NA(),AVERAGE(OFFSET(テストデータ!$D$3,1,12*3+10):OFFSET(テストデータ!$D$3,500,12*3+10)))","v":{"$error":"#N/A"}},{"$f":"IF(COUNT(OFFSET(テストデータ!$D$3,1,12*3+11):OFFSET(テストデータ!$D$3,500,12*3+11))=0,NA(),AVERAGE(OFFSET(テストデータ!$D$3,1,12*3+11):OFFSET(テストデータ!$D$3,500,12*3+11)))","v":{"$error":"#N/A"}}]
[null,"塾内順位",{"$f":"IF(OR(INDIRECT(ADDRESS(ROW()-2,COLUMN()))=\"欠\",INDIRECT(ADDRESS(ROW()-2,COLUMN()))=\"\"),\"\",RANK(INDIRECT(ADDRESS(ROW()-2,COLUMN())),OFFSET(テストデータ!AN$3,1,0):OFFSET(テストデータ!AN$3,500,0)))","v":3},{"$f":"IF(OR(INDIRECT(ADDRESS(ROW()-2,COLUMN()))=\"欠\",INDIRECT(ADDRESS(ROW()-2,COLUMN()))=\"\"),\"\",RANK(INDIRECT(ADDRESS(ROW()-2,COLUMN())),OFFSET(テストデータ!AO$3,1,0):OFFSET(テストデータ!AO$3,500,0)))","v":10},{"$f":"IF(OR(INDIRECT(ADDRESS(ROW()-2,COLUMN()))=\"欠\",INDIRECT(ADDRESS(ROW()-2,COLUMN()))=\"\"),\"\",RANK(INDIRECT(ADDRESS(ROW()-2,COLUMN())),OFFSET(テストデータ!AP$3,1,0):OFFSET(テストデータ!AP$3,500,0)))","v":20},{"$f":"IF(OR(INDIRECT(ADDRESS(ROW()-2,COLUMN()))=\"欠\",INDIRECT(ADDRESS(ROW()-2,COLUMN()))=\"\"),\"\",RANK(INDIRECT(ADDRESS(ROW()-2,COLUMN())),OFFSET(テストデータ!AQ$3,1,0):OFFSET(テストデータ!AQ$3,500,0)))","v":11},{"$f":"IF(OR(INDIRECT(ADDRESS(ROW()-2,COLUMN()))=\"欠\",INDIRECT(ADDRESS(ROW()-2,COLUMN()))=\"\"),\"\",RANK(INDIRECT(ADDRESS(ROW()-2,COLUMN())),OFFSET(テストデータ!AR$3,1,0):OFFSET(テストデータ!AR$3,500,0)))","v":13},{"$f":"IF(OR(INDIRECT(ADDRESS(ROW()-2,COLUMN()))=\"欠\",INDIRECT(ADDRESS(ROW()-2,COLUMN()))=\"\"),\"\",RANK(INDIRECT(ADDRESS(ROW()-2,COLUMN())),OFFSET(テストデータ!AS$3,1,0):OFFSET(テストデータ!AS$3,500,0)))","v":9},{"$f":"IF(OR(INDIRECT(ADDRESS(ROW()-2,COLUMN()))=\"欠\",INDIRECT(ADDRESS(ROW()-2,COLUMN()))=\"\"),\"\",RANK(INDIRECT(ADDRESS(ROW()-2,COLUMN())),OFFSET(テストデータ!AT$3,1,0):OFFSET(テストデータ!AT$3,500,0)))","v":19},{"$f":"IF(OR(INDIRECT(ADDRESS(ROW()-2,COLUMN()))=\"欠\",INDIRECT(ADDRESS(ROW()-2,COLUMN()))=\"\"),\"\",RANK(INDIRECT(ADDRESS(ROW()-2,COLUMN())),OFFSET(テストデータ!AU$3,1,0):OFFSET(テストデータ!AU$3,500,0)))","v":4},{"$f":"IF(OR(INDIRECT(ADDRESS(ROW()-2,COLUMN()))=\"欠\",INDIRECT(ADDRESS(ROW()-2,COLUMN()))=\"\"),\"\",RANK(INDIRECT(ADDRESS(ROW()-2,COLUMN())),OFFSET(テストデータ!AV$3,1,0):OFFSET(テストデータ!AV$3,500,0)))","v":7},{"$f":"IF(OR(INDIRECT(ADDRESS(ROW()-2,COLUMN()))=\"欠\",INDIRECT(ADDRESS(ROW()-2,COLUMN()))=\"\"),\"\",RANK(INDIRECT(ADDRESS(ROW()-2,COLUMN())),OFFSET(テストデータ!AW$3,1,0):OFFSET(テストデータ!AW$3,500,0)))","v":18},{"$f":"IF(OR(INDIRECT(ADDRESS(ROW()-2,COLUMN()))=\"欠\",INDIRECT(ADDRESS(ROW()-2,COLUMN()))=\"\"),\"\",RANK(INDIRECT(ADDRESS(ROW()-2,COLUMN())),OFFSET(テストデータ!AX$3,1,0):OFFSET(テストデータ!AX$3,500,0)))","v":""},{"$f":"IF(OR(INDIRECT(ADDRESS(ROW()-2,COLUMN()))=\"欠\",INDIRECT(ADDRESS(ROW()-2,COLUMN()))=\"\"),\"\",RANK(INDIRECT(ADDRESS(ROW()-2,COLUMN())),OFFSET(テストデータ!AY$3,1,0):OFFSET(テストデータ!AY$3,500,0)))","v":""}]
[null,{"$f":"IF(初期設定!$C7=\"\",\"\",初期設定!$C7)","v":"理科"},"1回","2回","3回","4回","5回","6回","7回","8回","9回","10回","11回","12回"]
[null,"実施日",{"$f":"IF(テストデータ!AZ$2=\"\",\"\",テストデータ!AZ$2)","v":"4/5"},{"$f":"IF(テストデータ!BA$2=\"\",\"\",テストデータ!BA$2)","v":"5/2"},{"$f":"IF(テストデータ!BB$2=\"\",\"\",テストデータ!BB$2)","v":"6/4"},{"$f":"IF(テストデータ!BC$2=\"\",\"\",テストデータ!BC$2)","v":"7/18"},{"$f":"IF(テストデータ!BD$2=\"\",\"\",テストデータ!BD$2)","v":"8/10"},{"$f":"IF(テストデータ!BE$2=\"\",\"\",テストデータ!BE$2)","v":"9/7"},{"$f":"IF(テストデータ!BF$2=\"\",\"\",テストデータ!BF$2)","v":"10/5"},{"$f":"IF(テストデータ!BG$2=\"\",\"\",テストデータ!BG$2)","v":"11/21"},{"$f":"IF(テストデータ!BH$2=\"\",\"\",テストデータ!BH$2)","v":"12/4"},{"$f":"IF(テストデータ!BI$2=\"\",\"\",テストデータ!BI$2)","v":"1/25"},{"$f":"IF(テストデータ!BJ$2=\"\",\"\",テストデータ!BJ$2)","v":""},{"$f":"IF(テストデータ!BK$2=\"\",\"\",テストデータ!BK$2)","v":""}]
[null,"得点",{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JL$503,52,FALSE)=\"\",IF(INDIRECT(ADDRESS(ROW()-1,COLUMN()))=\"\",\"\",\"欠\"),VLOOKUP($H$2,テストデータ!$A$4:$JL$503,52,FALSE))","v":78},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JL$503,53,FALSE)=\"\",IF(INDIRECT(ADDRESS(ROW()-1,COLUMN()))=\"\",\"\",\"欠\"),VLOOKUP($H$2,テストデータ!$A$4:$JL$503,53,FALSE))","v":94},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JL$503,54,FALSE)=\"\",IF(INDIRECT(ADDRESS(ROW()-1,COLUMN()))=\"\",\"\",\"欠\"),VLOOKUP($H$2,テストデータ!$A$4:$JL$503,54,FALSE))","v":10},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JL$503,55,FALSE)=\"\",IF(INDIRECT(ADDRESS(ROW()-1,COLUMN()))=\"\",\"\",\"欠\"),VLOOKUP($H$2,テストデータ!$A$4:$JL$503,55,FALSE))","v":88},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JL$503,56,FALSE)=\"\",IF(INDIRECT(ADDRESS(ROW()-1,COLUMN()))=\"\",\"\",\"欠\"),VLOOKUP($H$2,テストデータ!$A$4:$JL$503,56,FALSE))","v":35},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JL$503,57,FALSE)=\"\",IF(INDIRECT(ADDRESS(ROW()-1,COLUMN()))=\"\",\"\",\"欠\"),VLOOKUP($H$2,テストデータ!$A$4:$JL$503,57,FALSE))","v":27},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JL$503,58,FALSE)=\"\",IF(INDIRECT(ADDRESS(ROW()-1,COLUMN()))=\"\",\"\",\"欠\"),VLOOKUP($H$2,テストデータ!$A$4:$JL$503,58,FALSE))","v":87},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JL$503,59,FALSE)=\"\",IF(INDIRECT(ADDRESS(ROW()-1,COLUMN()))=\"\",\"\",\"欠\"),VLOOKUP($H$2,テストデータ!$A$4:$JL$503,59,FALSE))","v":44},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JL$503,60,FALSE)=\"\",IF(INDIRECT(ADDRESS(ROW()-1,COLUMN()))=\"\",\"\",\"欠\"),VLOOKUP($H$2,テストデータ!$A$4:$JL$503,60,FALSE))","v":17},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JL$503,61,FALSE)=\"\",IF(INDIRECT(ADDRESS(ROW()-1,COLUMN()))=\"\",\"\",\"欠\"),VLOOKUP($H$2,テストデータ!$A$4:$JL$503,61,FALSE))","v":27},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JL$503,62,FALSE)=\"\",IF(INDIRECT(ADDRESS(ROW()-1,COLUMN()))=\"\",\"\",\"欠\"),VLOOKUP($H$2,テストデータ!$A$4:$JL$503,62,FALSE))","v":""},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JL$503,63,FALSE)=\"\",IF(INDIRECT(ADDRESS(ROW()-1,COLUMN()))=\"\",\"\",\"欠\"),VLOOKUP($H$2,テストデータ!$A$4:$JL$503,63,FALSE))","v":""}]
[null,"平均点",{"$f":"IF(COUNT(OFFSET(テストデータ!$D$3,1,12*4+0):OFFSET(テストデータ!$D$3,500,12*4+0))=0,NA(),AVERAGE(OFFSET(テストデータ!$D$3,1,12*4+0):OFFSET(テストデータ!$D$3,500,12*4+0)))","v":52.75},{"$f":"IF(COUNT(OFFSET(テストデータ!$D$3,1,12*4+1):OFFSET(テストデータ!$D$3,500,12*4+1))=0,NA(),AVERAGE(OFFSET(テストデータ!$D$3,1,12*4+1):OFFSET(テストデータ!$D$3,500,12*4+1)))","v":58.6},{"$f":"IF(COUNT(OFFSET(テストデータ!$D$3,1,12*4+2):OFFSET(テストデータ!$D$3,500,12*4+2))=0,NA(),AVERAGE(OFFSET(テストデータ!$D$3,1,12*4+2):OFFSET(テストデータ!$D$3,500,12*4+2)))","v":58.1},{"$f":"IF(COUNT(OFFSET(テストデータ!$D$3,1,12*4+3):OFFSET(テストデータ!$D$3,500,12*4+3))=0,NA(),AVERAGE(OFFSET(テストデータ!$D$3,1,12*4+3):OFFSET(テストデータ!$D$3,500,12*4+3)))","v":54.157894736842103},{"$f":"IF(COUNT(OFFSET(テストデータ!$D$3,1,12*4+4):OFFSET(テストデータ!$D$3,500,12*4+4))=0,NA(),AVERAGE(OFFSET(テストデータ!$D$3,1,12*4+4):OFFSET(テストデータ!$D$3,500,12*4+4)))","v":59.315789473684212},{"$f":"IF(COUNT(OFFSET(テストデータ!$D$3,1,12*4+5):OFFSET(テストデータ!$D$3,500,12*4+5))=0,NA(),AVERAGE(OFFSET(テストデータ!$D$3,1,12*4+5):OFFSET(テストデータ!$D$3,500,12*4+5)))","v":53.4},{"$f":"IF(COUNT(OFFSET(テストデータ!$D$3,1,12*4+6):OFFSET(テストデータ!$D$3,500,12*4+6))=0,NA(),AVERAGE(OFFSET(テストデータ!$D$3,1,12*4+6):OFFSET(テストデータ!$D$3,500,12*4+6)))","v":50.421052631578945},{"$f":"IF(COUNT(OFFSET(テストデータ!$D$3,1,12*4+7):OFFSET(テストデータ!$D$3,500,12*4+7))=0,NA(),AVERAGE(OFFSET(テストデータ!$D$3,1,12*4+7):OFFSET(テストデータ!$D$3,500,12*4+7)))","v":60.9},{"$f":"IF(COUNT(OFFSET(テストデータ!$D$3,1,12*4+8):OFFSET(テストデータ!$D$3,500,12*4+8))=0,NA(),AVERAGE(OFFSET(テストデータ!$D$3,1,12*4+8):OFFSET(テストデータ!$D$3,500,12*4+8)))","v":59.944444444444443},{"$f":"IF(COUNT(OFFSET(テストデータ!$D$3,1,12*4+9):OFFSET(テストデータ!$D$3,500,12*4+9))=0,NA(),AVERAGE(OFFSET(テストデータ!$D$3,1,12*4+9):OFFSET(テストデータ!$D$3,500,12*4+9)))","v":53.55},{"$f":"IF(COUNT(OFFSET(テストデータ!$D$3,1,12*4+10):OFFSET(テストデータ!$D$3,500,12*4+10))=0,NA(),AVERAGE(OFFSET(テストデータ!$D$3,1,12*4+10):OFFSET(テストデータ!$D$3,500,12*4+10)))","v":{"$error":"#N/A"}},{"$f":"IF(COUNT(OFFSET(テストデータ!$D$3,1,12*4+11):OFFSET(テストデータ!$D$3,500,12*4+11))=0,NA(),AVERAGE(OFFSET(テストデータ!$D$3,1,12*4+11):OFFSET(テストデータ!$D$3,500,12*4+11)))","v":{"$error":"#N/A"}}]
[null,"塾内順位",{"$f":"IF(OR(INDIRECT(ADDRESS(ROW()-2,COLUMN()))=\"欠\",INDIRECT(ADDRESS(ROW()-2,COLUMN()))=\"\"),\"\",RANK(INDIRECT(ADDRESS(ROW()-2,COLUMN())),OFFSET(テストデータ!AZ$3,1,0):OFFSET(テストデータ!AZ$3,500,0)))","v":4},{"$f":"IF(OR(INDIRECT(ADDRESS(ROW()-2,COLUMN()))=\"欠\",INDIRECT(ADDRESS(ROW()-2,COLUMN()))=\"\"),\"\",RANK(INDIRECT(ADDRESS(ROW()-2,COLUMN())),OFFSET(テストデータ!BA$3,1,0):OFFSET(テストデータ!BA$3,500,0)))","v":4},{"$f":"IF(OR(INDIRECT(ADDRESS(ROW()-2,COLUMN()))=\"欠\",INDIRECT(ADDRESS(ROW()-2,COLUMN()))=\"\"),\"\",RANK(INDIRECT(ADDRESS(ROW()-2,COLUMN())),OFFSET(テストデータ!BB$3,1,0):OFFSET(テストデータ!BB$3,500,0)))","v":20},{"$f":"IF(OR(INDIRECT(ADDRESS(ROW()-2,COLUMN()))=\"欠\",INDIRECT(ADDRESS(ROW()-2,COLUMN()))=\"\"),\"\",RANK(INDIRECT(ADDRESS(ROW()-2,COLUMN())),OFFSET(テストデータ!BC$3,1,0):OFFSET(テストデータ!BC$3,500,0)))","v":3},{"$f":"IF(OR(INDIRECT(ADDRESS(ROW()-2,COLUMN()))=\"欠\",INDIRECT(ADDRESS(ROW()-2,COLUMN()))=\"\"),\"\",RANK(INDIRECT(ADDRESS(ROW()-2,COLUMN())),OFFSET(テストデータ!BD$3,1,0):OFFSET(テストデータ!BD$3,500,0)))","v":14},{"$f":"IF(OR(INDIRECT(ADDRESS(ROW()-2,COLUMN()))=\"欠\",INDIRECT(ADDRESS(ROW()-2,COLUMN()))=\"\"),\"\",RANK(INDIRECT(ADDRESS(ROW()-2,COLUMN())),OFFSET(テストデータ!BE$3,1,0):OFFSET(テストデータ!BE$3,500,0)))","v":18},{"$f":"IF(OR(INDIRECT(ADDRESS(ROW()-2,COLUMN()))=\"欠\",INDIRECT(ADDRESS(ROW()-2,COLUMN()))=\"\"),\"\",RANK(INDIRECT(ADDRESS(ROW()-2,COLUMN())),OFFSET(テストデータ!BF$3,1,0):OFFSET(テストデータ!BF$3,500,0)))","v":2},{"$f":"IF(OR(INDIRECT(ADDRESS(ROW()-2,COLUMN()))=\"欠\",INDIRECT(ADDRESS(ROW()-2,COLUMN()))=\"\"),\"\",RANK(INDIRECT(ADDRESS(ROW()-2,COLUMN())),OFFSET(テストデータ!BG$3,1,0):OFFSET(テストデータ!BG$3,500,0)))","v":15},{"$f":"IF(OR(INDIRECT(ADDRESS(ROW()-2,COLUMN()))=\"欠\",INDIRECT(ADDRESS(ROW()-2,COLUMN()))=\"\"),\"\",RANK(INDIRECT(ADDRESS(ROW()-2,COLUMN())),OFFSET(テストデータ!BH$3,1,0):OFFSET(テストデータ!BH$3,500,0)))","v":18},{"$f":"IF(OR(INDIRECT(ADDRESS(ROW()-2,COLUMN()))=\"欠\",INDIRECT(ADDRESS(ROW()-2,COLUMN()))=\"\"),\"\",RANK(INDIRECT(ADDRESS(ROW()-2,COLUMN())),OFFSET(テストデータ!BI$3,1,0):OFFSET(テストデータ!BI$3,500,0)))","v":17},{"$f":"IF(OR(INDIRECT(ADDRESS(ROW()-2,COLUMN()))=\"欠\",INDIRECT(ADDRESS(ROW()-2,COLUMN()))=\"\"),\"\",RANK(INDIRECT(ADDRESS(ROW()-2,COLUMN())),OFFSET(テストデータ!BJ$3,1,0):OFFSET(テストデータ!BJ$3,500,0)))","v":""},{"$f":"IF(OR(INDIRECT(ADDRESS(ROW()-2,COLUMN()))=\"欠\",INDIRECT(ADDRESS(ROW()-2,COLUMN()))=\"\"),\"\",RANK(INDIRECT(ADDRESS(ROW()-2,COLUMN())),OFFSET(テストデータ!BK$3,1,0):OFFSET(テストデータ!BK$3,500,0)))","v":""}]
[]
[]
[null,{"$f":"IF(初期設定!$C8=\"\",\"\",初期設定!$C8)","v":"模擬試験"},null,null,null,null,"ID:",{"$f":"H2","v":1},"ｸﾗｽ",{"$f":"IF(I2=\"\",\"\",I2)","v":"3-1"},"氏名",{"$f":"IF(K2=\"\",\"\",K2)","v":"鈴木A男"},null,null,null,null,null,null,{"$f":"IF(初期設定!C1=\"\",\"\",初期設定!C1)","v":"20xx年度"},null,{"$f":"初期設定!B44","v":"微風進学塾"}]
[]
[null,"テスト名","実施日","科目",null,{"$f":"IF(初期設定!$C9=\"\",\"\",初期設定!$C9)","v":"国語"},{"$f":"IF(初期設定!$C10=\"\",\"\",初期設定!$C10)","v":"英語"},{"$f":"IF(初期設定!$C11=\"\",\"\",初期設定!$C11)","v":"数学"},{"$f":"IF(初期設定!$C12=\"\",\"\",初期設定!$C12)","v":"社会"},{"$f":"IF(初期設定!$C13=\"\",\"\",初期設定!$C13)","v":"理科"},"3科","5科","公立志望校",null,null,null,"判定","私立志望校",null,null,null,"判定"]
[null,{"$f":"IF(テストデータ!BR1=\"\",\"\",テストデータ!BR1)","v":"北辰テスト"},{"$f":"IF(テストデータ!BL2=\"\",\"\",テストデータ!BL2)","v":"4/10"},"得点",null,{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JM$503,64,FALSE)=\"\",IF(C34=\"\",\"\",\"欠\"),VLOOKUP($H$2,テストデータ!$A$4:$JM$503,64,FALSE))","v":52},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JM$503,66,FALSE)=\"\",IF(C34=\"\",\"\",\"欠\"),VLOOKUP($H$2,テストデータ!$A$4:$JM$503,66,FALSE))","v":35},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JM$503,68,FALSE)=\"\",IF(C34=\"\",\"\",\"欠\"),VLOOKUP($H$2,テストデータ!$A$4:$JM$503,68,FALSE))","v":82},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JM$503,70,FALSE)=\"\",IF(C34=\"\",\"\",\"欠\"),VLOOKUP($H$2,テストデータ!$A$4:$JM$503,70,FALSE))","v":92},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JM$503,72,FALSE)=\"\",IF(C34=\"\",\"\",\"欠\"),VLOOKUP($H$2,テストデータ!$A$4:$JM$503,72,FALSE))","v":79},{"$f":"IF(SUM(F34:H34)=0,\"\",SUM(F34:H34))","v":169},{"$f":"IF(SUM(F34:J34)=0,\"\",SUM(F34:J34))","v":340},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JM$503,76,FALSE)=\"\",\"\",VLOOKUP($H$2,テストデータ!$A$4:$JM$503,76,FALSE))","v":"県立千葉"},null,null,null,{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JM$503,76+1,FALSE)=\"\",\"\",VLOOKUP($H$2,テストデータ!$A$4:$JM$503,76+1,FALSE))","v":"E"},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JM$503,76+4,FALSE)=\"\",\"\",VLOOKUP($H$2,テストデータ!$A$4:$JM$503,76+4,FALSE))","v":"渋谷幕張"},null,null,null,{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JM$503,76+5,FALSE)=\"\",\"\",VLOOKUP($H$2,テストデータ!$A$4:$JM$503,76+5,FALSE))","v":"C"}]
[null,null,null,"偏差値",null,{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JM$503,65,FALSE)=\"\",NA(),VLOOKUP($H$2,テストデータ!$A$4:$JM$503,65,FALSE))","v":50},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JM$503,67,FALSE)=\"\",NA(),VLOOKUP($H$2,テストデータ!$A$4:$JM$503,67,FALSE))","v":41},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JM$503,69,FALSE)=\"\",NA(),VLOOKUP($H$2,テストデータ!$A$4:$JM$503,69,FALSE))","v":66},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JM$503,71,FALSE)=\"\",NA(),VLOOKUP($H$2,テストデータ!$A$4:$JM$503,71,FALSE))","v":71},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JM$503,73,FALSE)=\"\",NA(),VLOOKUP($H$2,テストデータ!$A$4:$JM$503,73,FALSE))","v":61},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JM$503,74,FALSE)=\"\",NA(),VLOOKUP($H$2,テストデータ!$A$4:$JM$503,74,FALSE))","v":62},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JM$503,75,FALSE)=\"\",NA(),VLOOKUP($H$2,テストデータ!$A$4:$JM$503,75,FALSE))","v":61},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JM$503,76+2,FALSE)=\"\",\"\",VLOOKUP($H$2,テストデータ!$A$4:$JM$503,76+2,FALSE))","v":"千葉東"},null,null,null,{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JM$503,76+3,FALSE)=\"\",\"\",VLOOKUP($H$2,テストデータ!$A$4:$JM$503,76+3,FALSE))","v":"D"},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JM$503,76+6,FALSE)=\"\",\"\",VLOOKUP($H$2,テストデータ!$A$4:$JM$503,76+6,FALSE))","v":"成田"},null,null,null,{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JM$503,76+7,FALSE)=\"\",\"\",VLOOKUP($H$2,テストデータ!$A$4:$JM$503,76+7,FALSE))","v":"B"}]
[null,{"$f":"IF(テストデータ!CL1=\"\",\"\",テストデータ!CL1)","v":"進研模試"},{"$f":"IF(テストデータ!CF2=\"\",\"\",テストデータ!CF2)","v":"5/11"},"得点",null,{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JM$503,84,FALSE)=\"\",IF(C36=\"\",\"\",\"欠\"),VLOOKUP($H$2,テストデータ!$A$4:$JM$503,84,FALSE))","v":81},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JM$503,86,FALSE)=\"\",IF(C36=\"\",\"\",\"欠\"),VLOOKUP($H$2,テストデータ!$A$4:$JM$503,86,FALSE))","v":21},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JM$503,88,FALSE)=\"\",IF(C36=\"\",\"\",\"欠\"),VLOOKUP($H$2,テストデータ!$A$4:$JM$503,88,FALSE))","v":67},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JM$503,90,FALSE)=\"\",IF(C36=\"\",\"\",\"欠\"),VLOOKUP($H$2,テストデータ!$A$4:$JM$503,90,FALSE))","v":77},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JM$503,92,FALSE)=\"\",IF(C36=\"\",\"\",\"欠\"),VLOOKUP($H$2,テストデータ!$A$4:$JM$503,92,FALSE))","v":22},{"$f":"IF(SUM(F36:H36)=0,\"\",SUM(F36:H36))","v":169},{"$f":"IF(SUM(F36:J36)=0,\"\",SUM(F36:J36))","v":268},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JM$503,96,FALSE)=\"\",\"\",VLOOKUP($H$2,テストデータ!$A$4:$JM$503,96,FALSE))","v":"県立千葉"},null,null,null,{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JM$503,96+1,FALSE)=\"\",\"\",VLOOKUP($H$2,テストデータ!$A$4:$JM$503,96+1,FALSE))","v":"E"},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JM$503,96+4,FALSE)=\"\",\"\",VLOOKUP($H$2,テストデータ!$A$4:$JM$503,96+4,FALSE))","v":"渋谷幕張"},null,null,null,{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JM$503,96+5,FALSE)=\"\",\"\",VLOOKUP($H$2,テストデータ!$A$4:$JM$503,96+5,FALSE))","v":"C"}]
[null,null,null,"偏差値",null,{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JM$503,85,FALSE)=\"\",NA(),VLOOKUP($H$2,テストデータ!$A$4:$JM$503,85,FALSE))","v":65},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JM$503,87,FALSE)=\"\",NA(),VLOOKUP($H$2,テストデータ!$A$4:$JM$503,87,FALSE))","v":73},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JM$503,89,FALSE)=\"\",NA(),VLOOKUP($H$2,テストデータ!$A$4:$JM$503,89,FALSE))","v":20},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JM$503,91,FALSE)=\"\",NA(),VLOOKUP($H$2,テストデータ!$A$4:$JM$503,91,FALSE))","v":46},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JM$503,93,FALSE)=\"\",NA(),VLOOKUP($H$2,テストデータ!$A$4:$JM$503,93,FALSE))","v":19},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JM$503,94,FALSE)=\"\",NA(),VLOOKUP($H$2,テストデータ!$A$4:$JM$503,94,FALSE))","v":54},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JM$503,95,FALSE)=\"\",NA(),VLOOKUP($H$2,テストデータ!$A$4:$JM$503,95,FALSE))","v":40},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JM$503,96+2,FALSE)=\"\",\"\",VLOOKUP($H$2,テストデータ!$A$4:$JM$503,96+2,FALSE))","v":"千葉東"},null,null,null,{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JM$503,96+3,FALSE)=\"\",\"\",VLOOKUP($H$2,テストデータ!$A$4:$JM$503,96+3,FALSE))","v":"D"},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JM$503,96+6,FALSE)=\"\",\"\",VLOOKUP($H$2,テストデータ!$A$4:$JM$503,96+6,FALSE))","v":"成田"},null,null,null,{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JM$503,96+7,FALSE)=\"\",\"\",VLOOKUP($H$2,テストデータ!$A$4:$JM$503,96+7,FALSE))","v":"B"}]
[null,{"$f":"IF(テストデータ!DF1=\"\",\"\",テストデータ!DF1)","v":"北辰テスト"},{"$f":"IF(テストデータ!CZ2=\"\",\"\",テストデータ!CZ2)","v":"6/13"},"得点",null,{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JM$503,104,FALSE)=\"\",IF(C38=\"\",\"\",\"欠\"),VLOOKUP($H$2,テストデータ!$A$4:$JM$503,104,FALSE))","v":52},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JM$503,106,FALSE)=\"\",IF(C38=\"\",\"\",\"欠\"),VLOOKUP($H$2,テストデータ!$A$4:$JM$503,106,FALSE))","v":35},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JM$503,108,FALSE)=\"\",IF(C38=\"\",\"\",\"欠\"),VLOOKUP($H$2,テストデータ!$A$4:$JM$503,108,FALSE))","v":82},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JM$503,110,FALSE)=\"\",IF(C38=\"\",\"\",\"欠\"),VLOOKUP($H$2,テストデータ!$A$4:$JM$503,110,FALSE))","v":92},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JM$503,112,FALSE)=\"\",IF(C38=\"\",\"\",\"欠\"),VLOOKUP($H$2,テストデータ!$A$4:$JM$503,112,FALSE))","v":79},{"$f":"IF(SUM(F38:H38)=0,\"\",SUM(F38:H38))","v":169},{"$f":"IF(SUM(F38:J38)=0,\"\",SUM(F38:J38))","v":340},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JM$503,116,FALSE)=\"\",\"\",VLOOKUP($H$2,テストデータ!$A$4:$JM$503,116,FALSE))","v":"県立千葉"},null,null,null,{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JM$503,116+1,FALSE)=\"\",\"\",VLOOKUP($H$2,テストデータ!$A$4:$JM$503,116+1,FALSE))","v":"E"},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JM$503,116+4,FALSE)=\"\",\"\",VLOOKUP($H$2,テストデータ!$A$4:$JM$503,116+4,FALSE))","v":"渋谷幕張"},null,null,null,{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JM$503,116+5,FALSE)=\"\",\"\",VLOOKUP($H$2,テストデータ!$A$4:$JM$503,116+5,FALSE))","v":"C"}]
[null,null,null,"偏差値",null,{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JM$503,105,FALSE)=\"\",NA(),VLOOKUP($H$2,テストデータ!$A$4:$JM$503,105,FALSE))","v":50},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JM$503,107,FALSE)=\"\",NA(),VLOOKUP($H$2,テストデータ!$A$4:$JM$503,107,FALSE))","v":41},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JM$503,109,FALSE)=\"\",NA(),VLOOKUP($H$2,テストデータ!$A$4:$JM$503,109,FALSE))","v":66},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JM$503,111,FALSE)=\"\",NA(),VLOOKUP($H$2,テストデータ!$A$4:$JM$503,111,FALSE))","v":71},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JM$503,113,FALSE)=\"\",NA(),VLOOKUP($H$2,テストデータ!$A$4:$JM$503,113,FALSE))","v":61},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JM$503,114,FALSE)=\"\",NA(),VLOOKUP($H$2,テストデータ!$A$4:$JM$503,114,FALSE))","v":62},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JM$503,115,FALSE)=\"\",NA(),VLOOKUP($H$2,テストデータ!$A$4:$JM$503,115,FALSE))","v":61},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JM$503,116+2,FALSE)=\"\",\"\",VLOOKUP($H$2,テストデータ!$A$4:$JM$503,116+2,FALSE))","v":"千葉東"},null,null,null,{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JM$503,116+3,FALSE)=\"\",\"\",VLOOKUP($H$2,テストデータ!$A$4:$JM$503,116+3,FALSE))","v":"D"},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JM$503,116+6,FALSE)=\"\",\"\",VLOOKUP($H$2,テストデータ!$A$4:$JM$503,116+6,FALSE))","v":"成田"},null,null,null,{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JM$503,116+7,FALSE)=\"\",\"\",VLOOKUP($H$2,テストデータ!$A$4:$JM$503,116+7,FALSE))","v":"B"}]
[null,{"$f":"IF(テストデータ!DZ1=\"\",\"\",テストデータ!DZ1)","v":"進研模試"},{"$f":"IF(テストデータ!DT2=\"\",\"\",テストデータ!DT2)","v":"7/20"},"得点",null,{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JM$503,124,FALSE)=\"\",IF(C40=\"\",\"\",\"欠\"),VLOOKUP($H$2,テストデータ!$A$4:$JM$503,124,FALSE))","v":"欠"},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JM$503,126,FALSE)=\"\",IF(C40=\"\",\"\",\"欠\"),VLOOKUP($H$2,テストデータ!$A$4:$JM$503,126,FALSE))","v":"欠"},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JM$503,128,FALSE)=\"\",IF(C40=\"\",\"\",\"欠\"),VLOOKUP($H$2,テストデータ!$A$4:$JM$503,128,FALSE))","v":"欠"},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JM$503,130,FALSE)=\"\",IF(C40=\"\",\"\",\"欠\"),VLOOKUP($H$2,テストデータ!$A$4:$JM$503,130,FALSE))","v":"欠"},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JM$503,132,FALSE)=\"\",IF(C40=\"\",\"\",\"欠\"),VLOOKUP($H$2,テストデータ!$A$4:$JM$503,132,FALSE))","v":"欠"},{"$f":"IF(SUM(F40:H40)=0,\"\",SUM(F40:H40))","v":""},{"$f":"IF(SUM(F40:J40)=0,\"\",SUM(F40:J40))","v":""},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JM$503,136,FALSE)=\"\",\"\",VLOOKUP($H$2,テストデータ!$A$4:$JM$503,136,FALSE))","v":"県立千葉"},null,null,null,{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JM$503,136+1,FALSE)=\"\",\"\",VLOOKUP($H$2,テストデータ!$A$4:$JM$503,136+1,FALSE))","v":"E"},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JM$503,136+4,FALSE)=\"\",\"\",VLOOKUP($H$2,テストデータ!$A$4:$JM$503,136+4,FALSE))","v":"渋谷幕張"},null,null,null,{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JM$503,136+5,FALSE)=\"\",\"\",VLOOKUP($H$2,テストデータ!$A$4:$JM$503,136+5,FALSE))","v":"C"}]
[null,null,null,"偏差値",null,{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JM$503,125,FALSE)=\"\",NA(),VLOOKUP($H$2,テストデータ!$A$4:$JM$503,125,FALSE))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JM$503,127,FALSE)=\"\",NA(),VLOOKUP($H$2,テストデータ!$A$4:$JM$503,127,FALSE))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JM$503,129,FALSE)=\"\",NA(),VLOOKUP($H$2,テストデータ!$A$4:$JM$503,129,FALSE))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JM$503,131,FALSE)=\"\",NA(),VLOOKUP($H$2,テストデータ!$A$4:$JM$503,131,FALSE))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JM$503,133,FALSE)=\"\",NA(),VLOOKUP($H$2,テストデータ!$A$4:$JM$503,133,FALSE))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JM$503,134,FALSE)=\"\",NA(),VLOOKUP($H$2,テストデータ!$A$4:$JM$503,134,FALSE))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JM$503,135,FALSE)=\"\",NA(),VLOOKUP($H$2,テストデータ!$A$4:$JM$503,135,FALSE))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JM$503,136+2,FALSE)=\"\",\"\",VLOOKUP($H$2,テストデータ!$A$4:$JM$503,136+2,FALSE))","v":"千葉東"},null,null,null,{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JM$503,136+3,FALSE)=\"\",\"\",VLOOKUP($H$2,テストデータ!$A$4:$JM$503,136+3,FALSE))","v":"D"},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JM$503,136+6,FALSE)=\"\",\"\",VLOOKUP($H$2,テストデータ!$A$4:$JM$503,136+6,FALSE))","v":"成田"},null,null,null,{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JM$503,136+7,FALSE)=\"\",\"\",VLOOKUP($H$2,テストデータ!$A$4:$JM$503,136+7,FALSE))","v":"B"}]
[null,{"$f":"IF(テストデータ!ET1=\"\",\"\",テストデータ!ET1)","v":"総進模試"},{"$f":"IF(テストデータ!EN2=\"\",\"\",テストデータ!EN2)","v":"8/25"},"得点",null,null,null,null,null,null,null,null,{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JM$503,156,FALSE)=\"\",\"\",VLOOKUP($H$2,テストデータ!$A$4:$JM$503,156,FALSE))","v":"県立千葉"},null,null,null,{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JM$503,156+1,FALSE)=\"\",\"\",VLOOKUP($H$2,テストデータ!$A$4:$JM$503,156+1,FALSE))","v":"E"},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JM$503,156+4,FALSE)=\"\",\"\",VLOOKUP($H$2,テストデータ!$A$4:$JM$503,156+4,FALSE))","v":"渋谷幕張"},null,null,null,{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JM$503,156+5,FALSE)=\"\",\"\",VLOOKUP($H$2,テストデータ!$A$4:$JM$503,156+5,FALSE))","v":"C"}]
[null,null,null,"偏差値",null,null,null,null,null,null,null,null,{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JM$503,156+2,FALSE)=\"\",\"\",VLOOKUP($H$2,テストデータ!$A$4:$JM$503,156+2,FALSE))","v":"千葉東"},null,null,null,{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JM$503,156+3,FALSE)=\"\",\"\",VLOOKUP($H$2,テストデータ!$A$4:$JM$503,156+3,FALSE))","v":"D"},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JM$503,156+6,FALSE)=\"\",\"\",VLOOKUP($H$2,テストデータ!$A$4:$JM$503,156+6,FALSE))","v":"成田"},null,null,null,{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JM$503,156+7,FALSE)=\"\",\"\",VLOOKUP($H$2,テストデータ!$A$4:$JM$503,156+7,FALSE))","v":"B"}]
[null,{"$f":"IF(テストデータ!FN1=\"\",\"\",テストデータ!FN1)","v":"北辰テスト"},{"$f":"IF(テストデータ!FH2=\"\",\"\",テストデータ!FH2)","v":"9/25"},"得点",null,null,null,null,null,null,null,null,{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JM$503,176,FALSE)=\"\",\"\",VLOOKUP($H$2,テストデータ!$A$4:$JM$503,176,FALSE))","v":"県立千葉"},null,null,null,{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JM$503,176+1,FALSE)=\"\",\"\",VLOOKUP($H$2,テストデータ!$A$4:$JM$503,176+1,FALSE))","v":"E"},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JM$503,176+4,FALSE)=\"\",\"\",VLOOKUP($H$2,テストデータ!$A$4:$JM$503,176+4,FALSE))","v":"渋谷幕張"},null,null,null,{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JM$503,176+5,FALSE)=\"\",\"\",VLOOKUP($H$2,テストデータ!$A$4:$JM$503,176+5,FALSE))","v":"C"}]
[null,null,null,"偏差値",null,null,null,null,null,null,null,null,{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JM$503,176+2,FALSE)=\"\",\"\",VLOOKUP($H$2,テストデータ!$A$4:$JM$503,176+2,FALSE))","v":"千葉東"},null,null,null,{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JM$503,176+3,FALSE)=\"\",\"\",VLOOKUP($H$2,テストデータ!$A$4:$JM$503,176+3,FALSE))","v":"D"},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JM$503,176+6,FALSE)=\"\",\"\",VLOOKUP($H$2,テストデータ!$A$4:$JM$503,176+6,FALSE))","v":"成田"},null,null,null,{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JM$503,176+7,FALSE)=\"\",\"\",VLOOKUP($H$2,テストデータ!$A$4:$JM$503,176+7,FALSE))","v":"B"}]
[null,{"$f":"IF(テストデータ!GH1=\"\",\"\",テストデータ!GH1)","v":"総進模試"},{"$f":"IF(テストデータ!GB2=\"\",\"\",テストデータ!GB2)","v":"10/21"},"得点",null,null,null,null,null,null,null,null,{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JM$503,196,FALSE)=\"\",\"\",VLOOKUP($H$2,テストデータ!$A$4:$JM$503,196,FALSE))","v":"県立千葉"},null,null,null,{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JM$503,196+1,FALSE)=\"\",\"\",VLOOKUP($H$2,テストデータ!$A$4:$JM$503,196+1,FALSE))","v":"E"},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JM$503,196+4,FALSE)=\"\",\"\",VLOOKUP($H$2,テストデータ!$A$4:$JM$503,196+4,FALSE))","v":"渋谷幕張"},null,null,null,{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JM$503,196+5,FALSE)=\"\",\"\",VLOOKUP($H$2,テストデータ!$A$4:$JM$503,196+5,FALSE))","v":"C"}]
[null,null,null,"偏差値",null,null,null,null,null,null,null,null,{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JM$503,196+2,FALSE)=\"\",\"\",VLOOKUP($H$2,テストデータ!$A$4:$JM$503,196+2,FALSE))","v":"千葉東"},null,null,null,{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JM$503,196+3,FALSE)=\"\",\"\",VLOOKUP($H$2,テストデータ!$A$4:$JM$503,196+3,FALSE))","v":"D"},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JM$503,196+6,FALSE)=\"\",\"\",VLOOKUP($H$2,テストデータ!$A$4:$JM$503,196+6,FALSE))","v":"成田"},null,null,null,{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JM$503,196+7,FALSE)=\"\",\"\",VLOOKUP($H$2,テストデータ!$A$4:$JM$503,196+7,FALSE))","v":"B"}]
[null,{"$f":"IF(テストデータ!HB1=\"\",\"\",テストデータ!HB1)","v":"北辰テスト"},{"$f":"IF(テストデータ!GV2=\"\",\"\",テストデータ!GV2)","v":"11/3"},"得点",null,null,null,null,null,null,null,null,{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JM$503,216,FALSE)=\"\",\"\",VLOOKUP($H$2,テストデータ!$A$4:$JM$503,216,FALSE))","v":"県立千葉"},null,null,null,{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JM$503,216+1,FALSE)=\"\",\"\",VLOOKUP($H$2,テストデータ!$A$4:$JM$503,216+1,FALSE))","v":"E"},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JM$503,216+4,FALSE)=\"\",\"\",VLOOKUP($H$2,テストデータ!$A$4:$JM$503,216+4,FALSE))","v":"渋谷幕張"},null,null,null,{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JM$503,216+5,FALSE)=\"\",\"\",VLOOKUP($H$2,テストデータ!$A$4:$JM$503,216+5,FALSE))","v":"C"}]
[null,null,null,"偏差値",null,null,null,null,null,null,null,null,{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JM$503,216+2,FALSE)=\"\",\"\",VLOOKUP($H$2,テストデータ!$A$4:$JM$503,216+2,FALSE))","v":"千葉東"},null,null,null,{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JM$503,216+3,FALSE)=\"\",\"\",VLOOKUP($H$2,テストデータ!$A$4:$JM$503,216+3,FALSE))","v":"D"},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JM$503,216+6,FALSE)=\"\",\"\",VLOOKUP($H$2,テストデータ!$A$4:$JM$503,216+6,FALSE))","v":"成田"},null,null,null,{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JM$503,216+7,FALSE)=\"\",\"\",VLOOKUP($H$2,テストデータ!$A$4:$JM$503,216+7,FALSE))","v":"B"}]
[null,{"$f":"IF(テストデータ!HV1=\"\",\"\",テストデータ!HV1)","v":"進研模試"},{"$f":"IF(テストデータ!HP2=\"\",\"\",テストデータ!HP2)","v":"12/15"},"得点",null,null,null,null,null,null,null,null,{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JM$503,236,FALSE)=\"\",\"\",VLOOKUP($H$2,テストデータ!$A$4:$JM$503,236,FALSE))","v":"県立千葉"},null,null,null,{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JM$503,236+1,FALSE)=\"\",\"\",VLOOKUP($H$2,テストデータ!$A$4:$JM$503,236+1,FALSE))","v":"E"},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JM$503,236+4,FALSE)=\"\",\"\",VLOOKUP($H$2,テストデータ!$A$4:$JM$503,236+4,FALSE))","v":"渋谷幕張"},null,null,null,{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JM$503,236+5,FALSE)=\"\",\"\",VLOOKUP($H$2,テストデータ!$A$4:$JM$503,236+5,FALSE))","v":"C"}]
[null,null,null,"偏差値",null,null,null,null,null,null,null,null,{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JM$503,236+2,FALSE)=\"\",\"\",VLOOKUP($H$2,テストデータ!$A$4:$JM$503,236+2,FALSE))","v":"千葉東"},null,null,null,{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JM$503,236+3,FALSE)=\"\",\"\",VLOOKUP($H$2,テストデータ!$A$4:$JM$503,236+3,FALSE))","v":"D"},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JM$503,236+6,FALSE)=\"\",\"\",VLOOKUP($H$2,テストデータ!$A$4:$JM$503,236+6,FALSE))","v":"成田"},null,null,null,{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JM$503,236+7,FALSE)=\"\",\"\",VLOOKUP($H$2,テストデータ!$A$4:$JM$503,236+7,FALSE))","v":"B"}]
["　5科目 偏差値",null,null,null,{"$f":"IF(初期設定!$C9=\"\",\"\",初期設定!$C9)&\" 偏差値\"","v":"国語 偏差値"},null,null,null,{"$f":"IF(初期設定!$C10=\"\",\"\",初期設定!$C10)&\" 偏差値\"","v":"英語 偏差値"},null,null,null,{"$f":"IF(初期設定!$C11=\"\",\"\",初期設定!$C11)&\" 偏差値\"","v":"数学 偏差値"},null,null,null,{"$f":"IF(初期設定!$C12=\"\",\"\",初期設定!$C12)&\" 偏差値\"","v":"社会 偏差値"},null,null,null,{"$f":"IF(初期設定!$C13=\"\",\"\",初期設定!$C13)&\" 偏差値\"","v":"理科 偏差値"}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"IF(初期設定!$C20=\"\",\"\",初期設定!$C20)","v":"定期テスト"}]
[null,"テスト名",null,{"$f":"IF(初期設定!$C21=\"\",\"\",初期設定!$C21)","v":"国語"},{"$f":"IF(初期設定!$C22=\"\",\"\",初期設定!$C22)","v":"英語"},{"$f":"IF(初期設定!$C23=\"\",\"\",初期設定!$C23)","v":"数学"},{"$f":"IF(初期設定!$C24=\"\",\"\",初期設定!$C24)","v":"社会"},{"$f":"IF(初期設定!$C25=\"\",\"\",初期設定!$C25)","v":"理科"},"3科","5科","順位"]
[null,{"$f":"IF(テストデータ!IJ1=\"\",\"\",テストデータ!IJ1)","v":"1学期中間"},null,{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JM$503,244,FALSE)=\"\",\"\",VLOOKUP($H$2,テストデータ!$A$4:$JM$503,244,FALSE))","v":36},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JM$503,244+1,FALSE)=\"\",\"\",VLOOKUP($H$2,テストデータ!$A$4:$JM$503,244+1,FALSE))","v":58},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JM$503,244+2,FALSE)=\"\",\"\",VLOOKUP($H$2,テストデータ!$A$4:$JM$503,244+2,FALSE))","v":41},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JM$503,244+3,FALSE)=\"\",\"\",VLOOKUP($H$2,テストデータ!$A$4:$JM$503,244+3,FALSE))","v":92},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JM$503,244+4,FALSE)=\"\",\"\",VLOOKUP($H$2,テストデータ!$A$4:$JM$503,244+4,FALSE))","v":88},{"$f":"IF(SUM(D63:F63)=0,\"\",SUM(D63:F63))","v":135},{"$f":"IF(SUM(D63:H63)=0,\"\",SUM(D63:H63))","v":315},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JM$503,244+5,FALSE)=\"\",NA(),VLOOKUP($H$2,テストデータ!$A$4:$JM$503,244+5,FALSE))","v":21}]
[null,{"$f":"IF(テストデータ!IP1=\"\",\"\",テストデータ!IP1)","v":"1学期期末"},null,{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JM$503,250,FALSE)=\"\",\"\",VLOOKUP($H$2,テストデータ!$A$4:$JM$503,250,FALSE))","v":53},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JM$503,250+1,FALSE)=\"\",\"\",VLOOKUP($H$2,テストデータ!$A$4:$JM$503,250+1,FALSE))","v":89},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JM$503,250+2,FALSE)=\"\",\"\",VLOOKUP($H$2,テストデータ!$A$4:$JM$503,250+2,FALSE))","v":90},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JM$503,250+3,FALSE)=\"\",\"\",VLOOKUP($H$2,テストデータ!$A$4:$JM$503,250+3,FALSE))","v":23},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JM$503,250+4,FALSE)=\"\",\"\",VLOOKUP($H$2,テストデータ!$A$4:$JM$503,250+4,FALSE))","v":89},{"$f":"IF(SUM(D64:F64)=0,\"\",SUM(D64:F64))","v":232},{"$f":"IF(SUM(D64:H64)=0,\"\",SUM(D64:H64))","v":344},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JM$503,250+5,FALSE)=\"\",NA(),VLOOKUP($H$2,テストデータ!$A$4:$JM$503,250+5,FALSE))","v":15}]
[null,{"$f":"IF(テストデータ!IV1=\"\",\"\",テストデータ!IV1)","v":"2学期中間"},null,{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JM$503,256,FALSE)=\"\",\"\",VLOOKUP($H$2,テストデータ!$A$4:$JM$503,256,FALSE))","v":36},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JM$503,256+1,FALSE)=\"\",\"\",VLOOKUP($H$2,テストデータ!$A$4:$JM$503,256+1,FALSE))","v":58},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JM$503,256+2,FALSE)=\"\",\"\",VLOOKUP($H$2,テストデータ!$A$4:$JM$503,256+2,FALSE))","v":41},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JM$503,256+3,FALSE)=\"\",\"\",VLOOKUP($H$2,テストデータ!$A$4:$JM$503,256+3,FALSE))","v":92},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JM$503,256+4,FALSE)=\"\",\"\",VLOOKUP($H$2,テストデータ!$A$4:$JM$503,256+4,FALSE))","v":88},{"$f":"IF(SUM(D65:F65)=0,\"\",SUM(D65:F65))","v":135},{"$f":"IF(SUM(D65:H65)=0,\"\",SUM(D65:H65))","v":315},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JM$503,256+5,FALSE)=\"\",NA(),VLOOKUP($H$2,テストデータ!$A$4:$JM$503,256+5,FALSE))","v":21}]
[null,{"$f":"IF(テストデータ!JB1=\"\",\"\",テストデータ!JB1)","v":"2学期期末"},null,{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JM$503,262,FALSE)=\"\",\"\",VLOOKUP($H$2,テストデータ!$A$4:$JM$503,262,FALSE))","v":53},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JM$503,262+1,FALSE)=\"\",\"\",VLOOKUP($H$2,テストデータ!$A$4:$JM$503,262+1,FALSE))","v":89},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JM$503,262+2,FALSE)=\"\",\"\",VLOOKUP($H$2,テストデータ!$A$4:$JM$503,262+2,FALSE))","v":90},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JM$503,262+3,FALSE)=\"\",\"\",VLOOKUP($H$2,テストデータ!$A$4:$JM$503,262+3,FALSE))","v":23},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JM$503,262+4,FALSE)=\"\",\"\",VLOOKUP($H$2,テストデータ!$A$4:$JM$503,262+4,FALSE))","v":89},{"$f":"IF(SUM(D66:F66)=0,\"\",SUM(D66:F66))","v":232},{"$f":"IF(SUM(D66:H66)=0,\"\",SUM(D66:H66))","v":344},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$JM$503,262+5,FALSE)=\"\",NA(),VLOOKUP($H$2,テストデータ!$A$4:$JM$503,262+5,FALSE))","v":15}]
[null,{"$f":"IF(テストデータ!JH1=\"\",\"\",テストデータ!JH1)","v":"3学期期末"}]

{"sheet":"科目別テスト集計","index":2,"n_rows":505,"n_cols":9,"rows_kept":505,"cut":false,"hidden":false,"merged":[[5,7,5,8],[2,1,2,2],[1,1,1,3]]}
[]
[null,{"$f":"IF(初期設定!$C2=\"\",\"\",初期設定!$C2)","v":"月例テスト"}]
[null,"科目：",null,"英語","クラス：","全クラス","実施日：","12/11"]
[]
[null,"ID","class","氏名","得点","順位",null,"平均点：","52.7点"]
[null,1,"3-1","鈴木A男",72,{"$f":"IF(E6=\"\",\"\",RANK(E6,$E$6:$E$505))","v":6},null,"クラス別平均点"]
[null,2,"3-1","鈴木B男",35,{"$f":"IF(E7=\"\",\"\",RANK(E7,$E$6:$E$505))","v":13}]
[null,3,"3-1","鈴木C男",46,10]
[null,4,"3-1","鈴木D男",null,""]
[null,5,"3-1","鈴木E男",36,12]
[null,6,"3-1","鈴木F男",83,3]
[null,7,"3-2","鈴木G男",32,15]
[null,8,"3-2","鈴木H男",26,17]
[null,9,"3-2","鈴木I男",12,19]
[null,10,"3-2","鈴木J男",26,17]
[null,11,"3-2","鈴木K男",64,8]
[null,12,"3-2","鈴木L男",94,1]
[null,13,"3-3","鈴木M男",64,8]
[null,14,"3-3","鈴木N男",33,14]
[null,15,"3-3","鈴木O男",29,16]
[null,16,"3-3","鈴木P男",79,4]
[null,17,"3-3","鈴木Q男",40,11]
[null,18,"3-3","鈴木R男",66,7]
[null,19,"3-3","鈴木S男",73,5]
[null,20,"3-3","鈴木T男",92,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,{"$f":"IF(E31=\"\",\"\",RANK(E31,$E$6:$E$505))","v":""}]
[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,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,{"$f":"IF(E71=\"\",\"\",RANK(E71,$E$6:$E$505))","v":""}]
[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,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,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,null,null,{"$f":"IF(E135=\"\",\"\",RANK(E135,$E$6:$E$505))","v":""}]
[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,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,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,null,null,{"$f":"IF(E199=\"\",\"\",RANK(E199,$E$6:$E$505))","v":""}]
[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,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,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,null,null,{"$f":"IF(E263=\"\",\"\",RANK(E263,$E$6:$E$505))","v":""}]
[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,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,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,null,null,{"$f":"IF(E327=\"\",\"\",RANK(E327,$E$6:$E$505))","v":""}]
[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,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,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,null,null,{"$f":"IF(E391=\"\",\"\",RANK(E391,$E$6:$E$505))","v":""}]
[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,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,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,null,null,{"$f":"IF(E455=\"\",\"\",RANK(E455,$E$6:$E$505))","v":""}]
[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,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,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,""]

{"sheet":"模試・実力テスト集計","index":3,"n_rows":505,"n_cols":9,"rows_kept":505,"cut":false,"hidden":false,"merged":[[2,13,2,14],[2,1,2,2],[5,7,5,8],[1,4,1,6],[1,1,1,3]]}
[]
[null,{"$f":"IF(初期設定!$C8=\"\",\"\",初期設定!$C8)","v":"模擬試験"},null,null,"第１回北辰テスト"]
[null,"実施：",null,"第１回","科目：","国語","クラス：","全クラス"]
[]
[null,"ID","class","氏名","得点","偏差値","順位","平均点：","58.6点"]
[null,1,"3-1","鈴木A男",52,50,{"$f":"IF(E6=\"\",\"\",RANK(E6,$E$6:$E$505))","v":14},"クラス別平均点"]
[null,2,"3-1","鈴木B男",60,56,{"$f":"IF(E7=\"\",\"\",RANK(E7,$E$6:$E$505))","v":8}]
[null,3,"3-1","鈴木C男",62,58,7]
[null,4,"3-1","鈴木D男",58,52,10]
[null,5,"3-1","鈴木E男",38,44,18]
[null,6,"3-1","鈴木F男",86,66,1]
[null,7,"3-2","鈴木G男",55,54,13]
[null,8,"3-2","鈴木H男",52,50,14]
[null,9,"3-2","鈴木I男",58,52,10]
[null,10,"3-2","鈴木J男",75,60,4]
[null,11,"3-2","鈴木K男",58,52,10]
[null,12,"3-2","鈴木L男",36,40,19]
[null,13,"3-3","鈴木M男",24,36,20]
[null,14,"3-3","鈴木N男",60,56,8]
[null,15,"3-3","鈴木O男",40,46,17]
[null,16,"3-3","鈴木P男",42,48,16]
[null,17,"3-3","鈴木Q男",80,62,3]
[null,18,"3-3","鈴木R男",85,65,2]
[null,19,"3-3","鈴木S男",75,60,4]
[null,20,"3-3","鈴木T男",75,60,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,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,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,""]
[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,{"$f":"IF(E71=\"\",\"\",RANK(E71,$E$6:$E$505))","v":""}]
[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,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,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,""]
[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,{"$f":"IF(E135=\"\",\"\",RANK(E135,$E$6:$E$505))","v":""}]
[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,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,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,""]
[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,{"$f":"IF(E199=\"\",\"\",RANK(E199,$E$6:$E$505))","v":""}]
[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,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,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,""]
[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,{"$f":"IF(E263=\"\",\"\",RANK(E263,$E$6:$E$505))","v":""}]
[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,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,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,""]
[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,{"$f":"IF(E327=\"\",\"\",RANK(E327,$E$6:$E$505))","v":""}]
[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,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,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,""]
[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,{"$f":"IF(E391=\"\",\"\",RANK(E391,$E$6:$E$505))","v":""}]
[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,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,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,""]
[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,{"$f":"IF(E455=\"\",\"\",RANK(E455,$E$6:$E$505))","v":""}]
[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,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,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,""]

{"sheet":"定期テスト集計","index":4,"n_rows":25,"n_cols":9,"rows_kept":25,"cut":false,"hidden":false,"merged":[[2,1,2,2],[2,13,2,14],[5,7,5,8],[1,4,1,6],[1,1,1,3]]}
[]
[null,{"$f":"IF(初期設定!$C20=\"\",\"\",初期設定!$C20)","v":"定期テスト"},null,null,"1学期中間"]
[null,"実施：",null,"第１回","科目：","国語","クラス：","全クラス"]
[]
[null,"ID","class","氏名","得点",null,null,"平均点：","57.5点"]
[null,1,"3-1","鈴木A男",36,null,null,"クラス別平均点"]
[null,2,"3-1","鈴木B男"]
[null,3,"3-1","鈴木C男",93]
[null,4,"3-1","鈴木D男",39]
[null,5,"3-1","鈴木E男"]
[null,6,"3-1","鈴木F男",27]
[null,7,"3-2","鈴木G男",72]
[null,8,"3-2","鈴木H男",79]
[null,9,"3-2","鈴木I男",57]
[null,10,"3-2","鈴木J男",29]
[null,11,"3-2","鈴木K男",45]
[null,12,"3-2","鈴木L男",59]
[null,13,"3-3","鈴木M男",75]
[null,14,"3-3","鈴木N男",29]
[null,15,"3-3","鈴木O男",86]
[null,16,"3-3","鈴木P男",15]
[null,17,"3-3","鈴木Q男",83]
[null,18,"3-3","鈴木R男",37]
[null,19,"3-3","鈴木S男",80]
[null,20,"3-3","鈴木T男",94]

{"sheet":"連続印刷","index":5,"n_rows":20,"n_cols":11,"rows_kept":20,"cut":false,"hidden":false,"merged":[[7,10,7,13],[3,4,3,7],[3,8,3,9],[7,7,7,9],[7,4,7,6]]}
[]
["ID","class","氏名",null,"●名簿の表示"]
[]
[null,null,null,null,"印刷するclass：",null,null,null,"A",null,"→"]
[]
[null,null,null,null,"●印刷ページ指定"]
[]
[null,null,null,null,"成績表シートを",null,null,"1ページのみ",null,null," を印刷する"]
[]
[null,null,null,null,"●範囲指定印刷"]
[null,null,null,null,"from",null,"to"]
[null,null,null,null,null,"～",null,"→"]
[null,null,null,null,"↑",null,"↑"]
[null,null,null,null,"ID番号を指定してください(半角)"]
[]
[null,null,null,null,"●番号指定印刷"]
[]
[null,null,null,null,null,null,null,null,null,"→"]
[null,null,null,null,"↑","↑","↑","↑","↑"]
[null,null,null,null,"ID番号を指定してください(半角)"]

{"sheet":"初期設定","index":6,"n_rows":44,"n_cols":7,"rows_kept":44,"cut":false,"hidden":false,"merged":[[0,3,0,4]]}
[null,"本年度","20xx年度","模試志望校入力用"]
[null,"科目別テスト成績表タイトル","月例テスト","公立高校","私立高校"]
[null,"科目1","英語"]
[null,"科目2","数学"]
[null,"科目3","国語"]
[null,"科目4","社会"]
[null,"科目5","理科"]
[null,"模試・実力テスト成績表タイトル","模擬試験",null,null,"模試","定期"]
[null,"科目1","国語",null,null,{"$f":"IF(C9=\"\",\"\",C9)","v":"国語"},{"$f":"IF(C21=\"\",\"\",C21)","v":"国語"}]
[null,"科目2","英語",null,null,{"$f":"IF(C10=\"\",\"\",C10)","v":"英語"},{"$f":"IF(C22=\"\",\"\",C22)","v":"英語"}]
[null,"科目3","数学",null,null,"数学","数学"]
[null,"科目4","社会",null,null,"社会","社会"]
[null,"科目5","理科",null,null,"理科","理科"]
[null,"模試テスト名1",null,null,null,"３科目","３科目"]
[null,"模試テスト名2",null,null,null,"５科目","５科目"]
[null,"模試テスト名3"]
[null,"模試テスト名4"]
[null,"模試テスト名5"]
[null,"模試テスト名6"]
[null,"定期テスト成績表タイトル","定期テスト"]
[null,"科目1","国語"]
[null,"科目2","英語"]
[null,"科目3","数学"]
[null,"科目4","社会"]
[null,"科目5","理科"]
[null,"定期テスト名1","1学期中間"]
[null,"定期テスト名2","1学期期末"]
[null,"定期テスト名3","2学期中間"]
[null,"定期テスト名4","2学期期末"]
[null,"定期テスト名5","3学期期末"]
[null,"クラス名","全クラス"]
[null,"クラス1","A"]
[null,"クラス2","B"]
[null,"クラス3","C"]
[null,"クラス4"]
[null,"クラス5"]
[null,"クラス6"]
[null,"クラス7"]
[null,"クラス8"]
[null,"クラス9"]
[null,"クラス10"]
[null,"クラス11"]
[null,"クラス12"]
[null,"微風進学塾"]