{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["テストデータ","成績表","科目別テスト集計","模試・実力テスト集計","連続印刷","初期設定"],"not_rendered":{"charts":12,"images":1,"macros":1,"external_links":0,"defined_names":3,"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":136,"rows_kept":503,"cut":false,"hidden":false,"merged":[[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],[1,99,1,110],[1,111,1,122],[1,123,1,134],[0,99,0,103],[0,104,0,110],[0,111,0,115],[0,116,0,122],[0,123,0,127],[0,128,0,134],[2,51,2,62],[0,51,0,62],[1,63,1,74],[1,75,1,86],[1,87,1,98],[0,63,0,67],[0,68,0,74],[0,75,0,79],[0,80,0,86],[0,87,0,91],[0,92,0,98]]}
["ｶｰｿﾙ方向切り替え",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,"実施日→","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/1",null,null,null,null,null,null,null,null,null,null,null,"5/1",null,null,null,null,null,null,null,null,null,null,null,"7/1",null,null,null,null,null,null,null,null,null,null,null,"9/1",null,null,null,null,null,null,null,null,null,null,null,"11/1",null,null,null,null,null,null,null,null,null,null,null,"1/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":""},"2偏","4偏",{"$f":"IF(BL3=\"\",\"\",BL3)","v":"国語"},{"$f":"IF(BM3=\"\",\"\",BM3)","v":"国偏"},"算数","算偏","理科","理偏","社会","社偏","","","2偏","4偏",{"$f":"IF(BX3=\"\",\"\",BX3)","v":"国語"},"国偏","算数","算偏","理科","理偏","社会","社偏","","","2偏","4偏",{"$f":"IF(CJ3=\"\",\"\",CJ3)","v":"国語"},"国偏","算数","算偏","理科","理偏","社会","社偏","","","2偏","4偏",{"$f":"IF(CV3=\"\",\"\",CV3)","v":"国語"},"国偏","算数","算偏","理科","理偏","社会","社偏","","","2偏","4偏",{"$f":"IF(DH3=\"\",\"\",DH3)","v":"国語"},"国偏","算数","算偏","理科","理偏","社会","社偏","","","2偏","4偏",{"$f":"#REF!","v":{"$error":"#REF!"}}]
[1,"6-A","鈴木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,77,null,null,78,94,10,88,35,27,87,44,17,27,null,null,52,50,35,41,80,60,55,48,null,null,62,61,45,44,90,65,75,59,40,46,null,null,50,55,52,50,35,41,82,66,92,71,null,null,62,61,null,null,null,null,null,null,null,null,null,null,null,null,52,50,35,41,82,66,92,71,null,null,62,61,50,55,60,54,88,62,90,67,null,null,56,55]
[2,"6-A","鈴木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,88,null,null,24,74,37,44,56,80,64,16,42,77,null,null,null,null,null,null,null,null,null,null,null,null,null,null,50,48,36,30,45,26,71,56,null,null,45,55,null,null,null,null,null,null,null,null,null,null,null,null,50,48,36,30,45,26,71,56,null,null,45,55,null,null,null,null,null,null,null,null,null,null,null,null,50,48,36,30,45,26,71,56,null,null,45,55]
[3,"6-A","鈴木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,null,null,61,58,60,54,72,61,80,65,53,56,null,null,61,59,62,58,68,63,57,60,69,59,null,null,61,58,60,54,72,61,80,65,53,56,null,null,61,59,62,58,68,63,57,60,69,59,null,null,61,58,60,54,72,61,80,65,53,56,null,null,61,59]
[4,"6-A","鈴木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,null,null,43,13,42,31,56,22,46,45,18,34,null,null,42,58,58,52,77,58,49,60,46,49,null,null,43,13,42,31,56,22,46,45,18,34,null,null,42,58,58,52,77,58,49,60,46,49,null,null,43,13,42,31,56,22,46,45,18,34,null,null,42,58]
[5,"6-A","鈴木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,null,null,52,85,19,40,19,35,82,47,56,45,null,null,54,36,38,44,98,66,21,12,12,30,null,null,52,85,19,40,19,35,82,47,56,45,null,null,54,36,38,44,98,66,21,12,12,30,null,null,52,85,19,40,19,35,82,47,56,45,null,null,54,36]
[6,"6-A","鈴木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,null,null,47,45,66,54,73,41,12,32,12,42,null,null,63,63,86,66,69,42,14,51,31,42,null,null,47,45,66,54,73,41,12,32,12,42,null,null,63,63,86,66,69,42,14,51,31,42,null,null,47,45,66,54,73,41,12,32,12,42,null,null,63,63]
[7,"6-B","鈴木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,null,null,35,15,94,48,97,45,35,41,41,68,null,null,58,44,55,54,72,59,11,21,26,39,null,null,35,15,94,48,97,45,35,41,41,68,null,null,58,44,55,54,72,59,11,21,26,39,null,null,35,15,94,48,97,45,35,41,41,68,null,null,58,44]
[8,"6-B","鈴木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,null,null,24,43,95,60,55,44,25,13,27,73,null,null,62,25,52,50,86,55,56,70,21,57,null,null,24,43,95,60,55,44,25,13,27,73,null,null,62,25,52,50,86,55,56,70,21,57,null,null,24,43,95,60,55,44,25,13,27,73,null,null,62,25]
[9,"6-B","鈴木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,null,null,33,28,86,20,68,63,32,64,98,57,null,null,56,44,58,52,42,80,57,72,64,45,null,null,33,28,86,20,68,63,32,64,98,57,null,null,56,44,58,52,42,80,57,72,64,45,null,null,33,28,86,20,68,63,32,64,98,57,null,null,56,44]
[10,"6-B","鈴木J男",100,80,92,27,47,28,19,73,48,26,null,null,94,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,11,null,null,75,60,80,55,93,81,23,28,null,null,41,45,33,30,92,62,73,48,69,15,null,null,60,64,75,60,80,55,93,81,23,28,null,null,41,45,33,30,92,62,73,48,69,15,null,null,60,64,75,60,80,55,93,81,23,28,null,null,41,45,33,30,92,62,73,48,69,15,null,null,60,64]
[11,"6-B","鈴木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,null,null,43,50,83,74,28,61,49,62,76,58,null,null,47,62,58,52,80,65,70,30,85,68,null,null,43,50,83,74,28,61,49,62,76,58,null,null,47,62,58,52,80,65,70,30,85,68,null,null,43,50,83,74,28,61,49,62,76,58,null,null,47,62]
[12,"6-B","鈴木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,null,null,39,57,24,35,48,54,48,60,57,33,null,null,41,52,36,40,54,63,14,24,33,18,null,null,39,57,24,35,48,54,48,60,57,33,null,null,41,52,36,40,54,63,14,24,33,18,null,null,39,57,24,35,48,54,48,60,57,33,null,null,41,52]
[13,"6-C","鈴木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,null,null,18,40,81,65,21,73,67,20,77,46,null,null,54,40,24,36,92,67,79,32,30,22,null,null,18,40,81,65,21,73,67,20,77,46,null,null,54,40,24,36,92,67,79,32,30,22,null,null,18,40,81,65,21,73,67,20,77,46,null,null,54,40]
[14,"6-C","鈴木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,null,null,48,61,83,33,94,67,46,58,35,12,null,null,23,45,60,56,92,60,65,38,57,78,null,null,48,61,83,33,94,67,46,58,35,12,null,null,23,45,60,56,92,60,65,38,57,78,null,null,48,61,83,33,94,67,46,58,35,12,null,null,23,45]
[15,"6-C","鈴木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,null,null,62,65,33,68,93,69,17,21,35,22,null,null,52,25,40,46,38,25,80,34,30,47,null,null,62,65,33,68,93,69,17,21,35,22,null,null,52,25,40,46,38,25,80,34,30,47,null,null,62,65,33,68,93,69,17,21,35,22,null,null,52,25]
[16,"6-C","鈴木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,null,null,43,18,82,66,26,49,57,32,87,29,null,null,50,33,42,48,37,62,81,43,84,55,null,null,43,18,82,66,26,49,57,32,87,29,null,null,50,33,42,48,37,62,81,43,84,55,null,null,43,18,82,66,26,49,57,32,87,29,null,null,50,33]
[17,"6-C","鈴木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,null,null,48,52,29,31,47,39,48,56,21,53,null,null,64,38,80,62,40,31,63,62,59,35,null,null,48,52,29,31,47,39,48,56,21,53,null,null,64,38,80,62,40,31,63,62,59,35,null,null,48,52,29,31,47,39,48,56,21,53,null,null,64,38]
[18,"6-C","鈴木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,null,null,39,62,79,63,61,58,31,21,39,25,null,null,50,25,85,65,28,67,61,76,78,58,null,null,39,62,79,63,61,58,31,21,39,25,null,null,50,25,85,65,28,67,61,76,78,58,null,null,39,62,79,63,61,58,31,21,39,25,null,null,50,25]
[19,"6-C","鈴木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,null,null,59,46,84,66,81,61,68,26,83,45,null,null,38,45,75,60,92,54,76,58,27,33,null,null,59,46,84,66,81,61,68,26,83,45,null,null,38,45,75,60,92,54,76,58,27,33,null,null,59,46,84,66,81,61,68,26,83,45,null,null,38,45]
[20,"6-C","鈴木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,null,null,45,15,99,65,55,13,55,45,57,55,null,null,45,47,75,60,41,28,45,51,23,25,null,null,45,15,99,65,55,13,55,45,57,55,null,null,45,47,75,60,41,28,45,51,23,25,null,null,45,15,99,65,55,13,55,45,57,55,null,null,45,47]
[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":59,"n_cols":18,"rows_kept":59,"cut":false,"hidden":false,"merged":[[30,4,30,5],[60,1,70,19],[43,0,44,0],[33,0,34,0],[35,0,36,0],[37,0,38,0],[39,0,40,0],[41,0,42,0],[44,3,44,4],[43,3,43,4],[42,3,42,4],[41,3,41,4],[35,1,36,1],[39,1,40,1],[39,2,40,2],[43,2,44,2],[43,1,44,1],[40,3,40,4],[35,3,35,4],[37,2,38,2],[41,1,42,1],[41,2,42,2],[39,3,39,4],[38,3,38,4],[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],[30,8,30,10],[34,3,34,4],[33,3,33,4],[32,3,32,4],[36,3,36,4],[30,17,30,19],[2,11,2,13],[1,17,1,20],[31,8,31,10]]}
[]
[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":"6-A"},"氏名",{"$f":"IF(VLOOKUP($H2,テストデータ!$A$4:$C503,3,FALSE)=\"\",\"\",VLOOKUP($H2,テストデータ!$A$4:$C503,3,FALSE))","v":"鈴木A男"},null,null,null,null,null,null,{"$f":"IF(初期設定!B44=\"\",\"\",初期設定!B44)","v":"微風進学塾"}]
[null,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:$EF$503,4,FALSE)=\"\",IF(INDIRECT(ADDRESS(ROW()-1,COLUMN()))=\"\",\"\",\"欠\"),VLOOKUP($H$2,テストデータ!$A$4:$EF$503,4,FALSE))","v":"欠"},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$EF$503,5,FALSE)=\"\",IF(INDIRECT(ADDRESS(ROW()-1,COLUMN()))=\"\",\"\",\"欠\"),VLOOKUP($H$2,テストデータ!$A$4:$EF$503,5,FALSE))","v":50},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$EF$503,6,FALSE)=\"\",IF(INDIRECT(ADDRESS(ROW()-1,COLUMN()))=\"\",\"\",\"欠\"),VLOOKUP($H$2,テストデータ!$A$4:$EF$503,6,FALSE))","v":97},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$EF$503,7,FALSE)=\"\",IF(INDIRECT(ADDRESS(ROW()-1,COLUMN()))=\"\",\"\",\"欠\"),VLOOKUP($H$2,テストデータ!$A$4:$EF$503,7,FALSE))","v":72},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$EF$503,8,FALSE)=\"\",IF(INDIRECT(ADDRESS(ROW()-1,COLUMN()))=\"\",\"\",\"欠\"),VLOOKUP($H$2,テストデータ!$A$4:$EF$503,8,FALSE))","v":90},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$EF$503,9,FALSE)=\"\",IF(INDIRECT(ADDRESS(ROW()-1,COLUMN()))=\"\",\"\",\"欠\"),VLOOKUP($H$2,テストデータ!$A$4:$EF$503,9,FALSE))","v":25},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$EF$503,10,FALSE)=\"\",IF(INDIRECT(ADDRESS(ROW()-1,COLUMN()))=\"\",\"\",\"欠\"),VLOOKUP($H$2,テストデータ!$A$4:$EF$503,10,FALSE))","v":90},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$EF$503,11,FALSE)=\"\",IF(INDIRECT(ADDRESS(ROW()-1,COLUMN()))=\"\",\"\",\"欠\"),VLOOKUP($H$2,テストデータ!$A$4:$EF$503,11,FALSE))","v":50},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$EF$503,12,FALSE)=\"\",IF(INDIRECT(ADDRESS(ROW()-1,COLUMN()))=\"\",\"\",\"欠\"),VLOOKUP($H$2,テストデータ!$A$4:$EF$505,12,FALSE))","v":97},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$EF$503,13,FALSE)=\"\",IF(INDIRECT(ADDRESS(ROW()-1,COLUMN()))=\"\",\"\",\"欠\"),VLOOKUP($H$2,テストデータ!$A$4:$EF$503,13,FALSE))","v":72},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$EF$503,14,FALSE)=\"\",IF(INDIRECT(ADDRESS(ROW()-1,COLUMN()))=\"\",\"\",\"欠\"),VLOOKUP($H$2,テストデータ!$A$4:$EF$503,14,FALSE))","v":""},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$EF$503,15,FALSE)=\"\",IF(INDIRECT(ADDRESS(ROW()-1,COLUMN()))=\"\",\"\",\"欠\"),VLOOKUP($H$2,テストデータ!$A$4:$EF$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,"実施日",{"$f":"IF(テストデータ!P$2=\"\",\"\",テストデータ!P$2)","v":"4/8"},{"$f":"IF(テストデータ!Q$2=\"\",\"\",テストデータ!Q$2)","v":"5/8"},{"$f":"IF(テストデータ!R$2=\"\",\"\",テストデータ!R$2)","v":"6/8"},{"$f":"IF(テストデータ!S$2=\"\",\"\",テストデータ!S$2)","v":"7/8"},{"$f":"IF(テストデータ!T$2=\"\",\"\",テストデータ!T$2)","v":"8/8"},{"$f":"IF(テストデータ!U$2=\"\",\"\",テストデータ!U$2)","v":"9/8"},{"$f":"IF(テストデータ!V$2=\"\",\"\",テストデータ!V$2)","v":"10/8"},{"$f":"IF(テストデータ!W$2=\"\",\"\",テストデータ!W$2)","v":"11/8"},{"$f":"IF(テストデータ!X$2=\"\",\"\",テストデータ!X$2)","v":"12/8"},{"$f":"IF(テストデータ!Y$2=\"\",\"\",テストデータ!Y$2)","v":"1/8"},{"$f":"IF(テストデータ!Z$2=\"\",\"\",テストデータ!Z$2)","v":""},{"$f":"IF(テストデータ!AA$2=\"\",\"\",テストデータ!AA$2)","v":""}]
[null,"得点",{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$EF$503,16,FALSE)=\"\",IF(INDIRECT(ADDRESS(ROW()-1,COLUMN()))=\"\",\"\",\"欠\"),VLOOKUP($H$2,テストデータ!$A$4:$EF$503,16,FALSE))","v":"欠"},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$EF$503,17,FALSE)=\"\",IF(INDIRECT(ADDRESS(ROW()-1,COLUMN()))=\"\",\"\",\"欠\"),VLOOKUP($H$2,テストデータ!$A$4:$EF$503,17,FALSE))","v":50},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$EF$503,18,FALSE)=\"\",IF(INDIRECT(ADDRESS(ROW()-1,COLUMN()))=\"\",\"\",\"欠\"),VLOOKUP($H$2,テストデータ!$A$4:$EF$503,18,FALSE))","v":97},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$EF$503,19,FALSE)=\"\",IF(INDIRECT(ADDRESS(ROW()-1,COLUMN()))=\"\",\"\",\"欠\"),VLOOKUP($H$2,テストデータ!$A$4:$EF$503,19,FALSE))","v":72},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$EF$503,20,FALSE)=\"\",IF(INDIRECT(ADDRESS(ROW()-1,COLUMN()))=\"\",\"\",\"欠\"),VLOOKUP($H$2,テストデータ!$A$4:$EF$503,20,FALSE))","v":90},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$EF$503,21,FALSE)=\"\",IF(INDIRECT(ADDRESS(ROW()-1,COLUMN()))=\"\",\"\",\"欠\"),VLOOKUP($H$2,テストデータ!$A$4:$EF$503,21,FALSE))","v":25},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$EF$503,22,FALSE)=\"\",IF(INDIRECT(ADDRESS(ROW()-1,COLUMN()))=\"\",\"\",\"欠\"),VLOOKUP($H$2,テストデータ!$A$4:$EF$503,22,FALSE))","v":90},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$EF$503,23,FALSE)=\"\",IF(INDIRECT(ADDRESS(ROW()-1,COLUMN()))=\"\",\"\",\"欠\"),VLOOKUP($H$2,テストデータ!$A$4:$EF$503,23,FALSE))","v":50},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$EF$503,24,FALSE)=\"\",IF(INDIRECT(ADDRESS(ROW()-1,COLUMN()))=\"\",\"\",\"欠\"),VLOOKUP($H$2,テストデータ!$A$4:$EF$503,24,FALSE))","v":97},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$EF$503,25,FALSE)=\"\",IF(INDIRECT(ADDRESS(ROW()-1,COLUMN()))=\"\",\"\",\"欠\"),VLOOKUP($H$2,テストデータ!$A$4:$EF$503,25,FALSE))","v":72},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$EF$503,26,FALSE)=\"\",IF(INDIRECT(ADDRESS(ROW()-1,COLUMN()))=\"\",\"\",\"欠\"),VLOOKUP($H$2,テストデータ!$A$4:$EF$503,26,FALSE))","v":""},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$EF$503,27,FALSE)=\"\",IF(INDIRECT(ADDRESS(ROW()-1,COLUMN()))=\"\",\"\",\"欠\"),VLOOKUP($H$2,テストデータ!$A$4:$EF$503,27,FALSE))","v":""}]
[null,"平均点",{"$f":"IF(COUNT(OFFSET(テストデータ!$D$3,1,12*1+0):OFFSET(テストデータ!$D$3,500,12*1+0))=0,NA(),AVERAGE(OFFSET(テストデータ!$D$3,1,12*1+0):OFFSET(テストデータ!$D$3,500,12*1+0)))","v":54.94736842105263},{"$f":"IF(COUNT(OFFSET(テストデータ!$D$3,1,12*1+1):OFFSET(テストデータ!$D$3,500,12*1+1))=0,NA(),AVERAGE(OFFSET(テストデータ!$D$3,1,12*1+1):OFFSET(テストデータ!$D$3,500,12*1+1)))","v":47.882352941176471},{"$f":"IF(COUNT(OFFSET(テストデータ!$D$3,1,12*1+2):OFFSET(テストデータ!$D$3,500,12*1+2))=0,NA(),AVERAGE(OFFSET(テストデータ!$D$3,1,12*1+2):OFFSET(テストデータ!$D$3,500,12*1+2)))","v":64.375},{"$f":"IF(COUNT(OFFSET(テストデータ!$D$3,1,12*1+3):OFFSET(テストデータ!$D$3,500,12*1+3))=0,NA(),AVERAGE(OFFSET(テストデータ!$D$3,1,12*1+3):OFFSET(テストデータ!$D$3,500,12*1+3)))","v":59.2},{"$f":"IF(COUNT(OFFSET(テストデータ!$D$3,1,12*1+4):OFFSET(テストデータ!$D$3,500,12*1+4))=0,NA(),AVERAGE(OFFSET(テストデータ!$D$3,1,12*1+4):OFFSET(テストデータ!$D$3,500,12*1+4)))","v":59.8},{"$f":"IF(COUNT(OFFSET(テストデータ!$D$3,1,12*1+5):OFFSET(テストデータ!$D$3,500,12*1+5))=0,NA(),AVERAGE(OFFSET(テストデータ!$D$3,1,12*1+5):OFFSET(テストデータ!$D$3,500,12*1+5)))","v":64.349999999999994},{"$f":"IF(COUNT(OFFSET(テストデータ!$D$3,1,12*1+6):OFFSET(テストデータ!$D$3,500,12*1+6))=0,NA(),AVERAGE(OFFSET(テストデータ!$D$3,1,12*1+6):OFFSET(テストデータ!$D$3,500,12*1+6)))","v":45.05263157894737},{"$f":"IF(COUNT(OFFSET(テストデータ!$D$3,1,12*1+7):OFFSET(テストデータ!$D$3,500,12*1+7))=0,NA(),AVERAGE(OFFSET(テストデータ!$D$3,1,12*1+7):OFFSET(テストデータ!$D$3,500,12*1+7)))","v":55.736842105263158},{"$f":"IF(COUNT(OFFSET(テストデータ!$D$3,1,12*1+8):OFFSET(テストデータ!$D$3,500,12*1+8))=0,NA(),AVERAGE(OFFSET(テストデータ!$D$3,1,12*1+8):OFFSET(テストデータ!$D$3,500,12*1+8)))","v":55.789473684210527},{"$f":"IF(COUNT(OFFSET(テストデータ!$D$3,1,12*1+9):OFFSET(テストデータ!$D$3,500,12*1+9))=0,NA(),AVERAGE(OFFSET(テストデータ!$D$3,1,12*1+9):OFFSET(テストデータ!$D$3,500,12*1+9)))","v":49.9},{"$f":"IF(COUNT(OFFSET(テストデータ!$D$3,1,12*1+10):OFFSET(テストデータ!$D$3,500,12*1+10))=0,NA(),AVERAGE(OFFSET(テストデータ!$D$3,1,12*1+10):OFFSET(テストデータ!$D$3,500,12*1+10)))","v":{"$error":"#N/A"}},{"$f":"IF(COUNT(OFFSET(テストデータ!$D$3,1,12*1+11):OFFSET(テストデータ!$D$3,500,12*1+11))=0,NA(),AVERAGE(OFFSET(テストデータ!$D$3,1,12*1+11):OFFSET(テストデータ!$D$3,500,12*1+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(テストデータ!P$3,1,0):OFFSET(テストデータ!P$3,500,0)))","v":""},{"$f":"IF(OR(INDIRECT(ADDRESS(ROW()-2,COLUMN()))=\"欠\",INDIRECT(ADDRESS(ROW()-2,COLUMN()))=\"\"),\"\",RANK(INDIRECT(ADDRESS(ROW()-2,COLUMN())),OFFSET(テストデータ!Q$3,1,0):OFFSET(テストデータ!Q$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(テストデータ!R$3,1,0):OFFSET(テストデータ!R$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(テストデータ!S$3,1,0):OFFSET(テストデータ!S$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(テストデータ!T$3,1,0):OFFSET(テストデータ!T$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(テストデータ!U$3,1,0):OFFSET(テストデータ!U$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(テストデータ!V$3,1,0):OFFSET(テストデータ!V$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(テストデータ!W$3,1,0):OFFSET(テストデータ!W$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(テストデータ!X$3,1,0):OFFSET(テストデータ!X$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(テストデータ!Y$3,1,0):OFFSET(テストデータ!Y$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(テストデータ!Z$3,1,0):OFFSET(テストデータ!Z$3,500,0)))","v":""},{"$f":"IF(OR(INDIRECT(ADDRESS(ROW()-2,COLUMN()))=\"欠\",INDIRECT(ADDRESS(ROW()-2,COLUMN()))=\"\"),\"\",RANK(INDIRECT(ADDRESS(ROW()-2,COLUMN())),OFFSET(テストデータ!AA$3,1,0):OFFSET(テストデータ!AA$3,500,0)))","v":""}]
[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:$EF$503,28,FALSE)=\"\",IF(INDIRECT(ADDRESS(ROW()-1,COLUMN()))=\"\",\"\",\"欠\"),VLOOKUP($H$2,テストデータ!$A$4:$EF$503,28,FALSE))","v":"欠"},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$EF$503,29,FALSE)=\"\",IF(INDIRECT(ADDRESS(ROW()-1,COLUMN()))=\"\",\"\",\"欠\"),VLOOKUP($H$2,テストデータ!$A$4:$EF$503,29,FALSE))","v":50},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$EF$503,30,FALSE)=\"\",IF(INDIRECT(ADDRESS(ROW()-1,COLUMN()))=\"\",\"\",\"欠\"),VLOOKUP($H$2,テストデータ!$A$4:$EF$503,30,FALSE))","v":97},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$EF$503,31,FALSE)=\"\",IF(INDIRECT(ADDRESS(ROW()-1,COLUMN()))=\"\",\"\",\"欠\"),VLOOKUP($H$2,テストデータ!$A$4:$EF$503,31,FALSE))","v":72},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$EF$503,32,FALSE)=\"\",IF(INDIRECT(ADDRESS(ROW()-1,COLUMN()))=\"\",\"\",\"欠\"),VLOOKUP($H$2,テストデータ!$A$4:$EF$503,32,FALSE))","v":25},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$EF$503,33,FALSE)=\"\",IF(INDIRECT(ADDRESS(ROW()-1,COLUMN()))=\"\",\"\",\"欠\"),VLOOKUP($H$2,テストデータ!$A$4:$EF$503,33,FALSE))","v":25},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$EF$503,34,FALSE)=\"\",IF(INDIRECT(ADDRESS(ROW()-1,COLUMN()))=\"\",\"\",\"欠\"),VLOOKUP($H$2,テストデータ!$A$4:$EF$503,34,FALSE))","v":90},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$EF$503,35,FALSE)=\"\",IF(INDIRECT(ADDRESS(ROW()-1,COLUMN()))=\"\",\"\",\"欠\"),VLOOKUP($H$2,テストデータ!$A$4:$EF$503,35,FALSE))","v":50},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$EF$503,36,FALSE)=\"\",IF(INDIRECT(ADDRESS(ROW()-1,COLUMN()))=\"\",\"\",\"欠\"),VLOOKUP($H$2,テストデータ!$A$4:$EF$503,36,FALSE))","v":97},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$EF$503,37,FALSE)=\"\",IF(INDIRECT(ADDRESS(ROW()-1,COLUMN()))=\"\",\"\",\"欠\"),VLOOKUP($H$2,テストデータ!$A$4:$EF$503,37,FALSE))","v":72},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$EF$503,38,FALSE)=\"\",IF(INDIRECT(ADDRESS(ROW()-1,COLUMN()))=\"\",\"\",\"欠\"),VLOOKUP($H$2,テストデータ!$A$4:$EF$503,38,FALSE))","v":""},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$EF$503,39,FALSE)=\"\",IF(INDIRECT(ADDRESS(ROW()-1,COLUMN()))=\"\",\"\",\"欠\"),VLOOKUP($H$2,テストデータ!$A$4:$EF$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,"実施日"]
[null,"得点"]
[null,"平均点"]
[null,"塾内順位"]
[null,{"$f":"IF(初期設定!$C7=\"\",\"\",初期設定!$C7)","v":"英語"},"1回","2回","3回","4回","5回","6回","7回","8回","9回","10回","11回","12回"]
[null,"実施日"]
[null,"得点"]
[null,"平均点"]
[null,"塾内順位"]
[]
[]
[null,{"$f":"IF(初期設定!$C8=\"\",\"\",初期設定!$C8)","v":"模擬テスト"},null,null,{"$f":"\"ID:\"&H2","v":"ID:1"},null,{"$f":"IF(I2=\"\",\"\",I2)","v":"6-A"},"氏名",{"$f":"IF(K2=\"\",\"\",K2)","v":"鈴木A男"},null,null,null,null,null,null,null,null,{"$f":"IF(初期設定!B44=\"\",\"\",初期設定!B44)","v":"微風進学塾"}]
[null,null,null,null,null,null,null,null,{"$f":"IF(初期設定!C1=\"\",\"\",初期設定!C1)","v":"20xx年"}]
[null,"模試名","実施日","科目",null,{"$f":"IF(初期設定!$C9=\"\",\"\",初期設定!$C9)","v":"国語"},{"$f":"IF(初期設定!$C10=\"\",\"\",初期設定!$C10)","v":"算数"},{"$f":"IF(初期設定!$C11=\"\",\"\",初期設定!$C11)","v":"理科"},{"$f":"IF(初期設定!$C12=\"\",\"\",初期設定!$C12)","v":"社会"},"2科","4科"]
[null,{"$f":"IF(テストデータ!BQ1=\"\",\"\",テストデータ!BQ1)","v":""},{"$f":"IF(テストデータ!BL2=\"\",\"\",テストデータ!BL2)","v":"4/1"},"得点",null,{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$EF$503,64,FALSE)=\"\",IF(C34=\"\",\"\",\"欠\"),VLOOKUP($H$2,テストデータ!$A$4:$EF$503,64,FALSE))","v":52},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$EF$503,66,FALSE)=\"\",IF(C34=\"\",\"\",\"欠\"),VLOOKUP($H$2,テストデータ!$A$4:$EF$503,66,FALSE))","v":35},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$EF$503,68,FALSE)=\"\",IF(C34=\"\",\"\",\"欠\"),VLOOKUP($H$2,テストデータ!$A$4:$EF$503,68,FALSE))","v":80},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$EF$503,70,FALSE)=\"\",IF(C34=\"\",\"\",\"欠\"),VLOOKUP($H$2,テストデータ!$A$4:$EF$503,70,FALSE))","v":55},{"$f":"IF(SUM(F34:G34)=0,\"\",SUM(F34:G34))","v":87},{"$f":"IF(SUM(F34:I34)=0,\"\",SUM(F34:I34))","v":222}]
[null,null,null,"偏差値",null,{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$EF$503,65,FALSE)=\"\",NA(),VLOOKUP($H$2,テストデータ!$A$4:$EF$503,65,FALSE))","v":50},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$EF$503,67,FALSE)=\"\",NA(),VLOOKUP($H$2,テストデータ!$A$4:$EF$503,67,FALSE))","v":41},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$EF$503,69,FALSE)=\"\",NA(),VLOOKUP($H$2,テストデータ!$A$4:$EF$503,69,FALSE))","v":60},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$EF$503,71,FALSE)=\"\",NA(),VLOOKUP($H$2,テストデータ!$A$4:$EF$503,71,FALSE))","v":48},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$EF$503,74,FALSE)=\"\",NA(),VLOOKUP($H$2,テストデータ!$A$4:$EF$503,74,FALSE))","v":62},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$EF$503,75,FALSE)=\"\",NA(),VLOOKUP($H$2,テストデータ!$A$4:$EF$503,75,FALSE))","v":61}]
[null,{"$f":"IF(テストデータ!CC1=\"\",\"\",テストデータ!CC1)","v":""},{"$f":"IF(テストデータ!BX2=\"\",\"\",テストデータ!BX2)","v":"5/1"},"得点",null,{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$EF$503,76,FALSE)=\"\",IF(C36=\"\",\"\",\"欠\"),VLOOKUP($H$2,テストデータ!$A$4:$EF$503,76,FALSE))","v":45},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$EF$503,78,FALSE)=\"\",IF(C36=\"\",\"\",\"欠\"),VLOOKUP($H$2,テストデータ!$A$4:$EF$503,78,FALSE))","v":90},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$EF$503,80,FALSE)=\"\",IF(C36=\"\",\"\",\"欠\"),VLOOKUP($H$2,テストデータ!$A$4:$EF$503,80,FALSE))","v":75},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$EF$503,82,FALSE)=\"\",IF(C36=\"\",\"\",\"欠\"),VLOOKUP($H$2,テストデータ!$A$4:$EF$503,82,FALSE))","v":40},{"$f":"IF(SUM(F36:G36)=0,\"\",SUM(F36:G36))","v":135},{"$f":"IF(SUM(F36:I36)=0,\"\",SUM(F36:I36))","v":250}]
[null,null,null,"偏差値",null,{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$EF$503,77,FALSE)=\"\",NA(),VLOOKUP($H$2,テストデータ!$A$4:$EF$503,77,FALSE))","v":44},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$EF$503,79,FALSE)=\"\",NA(),VLOOKUP($H$2,テストデータ!$A$4:$EF$503,79,FALSE))","v":65},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$EF$503,81,FALSE)=\"\",NA(),VLOOKUP($H$2,テストデータ!$A$4:$EF$503,81,FALSE))","v":59},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$EF$503,83,FALSE)=\"\",NA(),VLOOKUP($H$2,テストデータ!$A$4:$EF$503,83,FALSE))","v":46},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$EF$503,86,FALSE)=\"\",NA(),VLOOKUP($H$2,テストデータ!$A$4:$EF$503,86,FALSE))","v":50},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$EF$503,87,FALSE)=\"\",NA(),VLOOKUP($H$2,テストデータ!$A$4:$EF$503,87,FALSE))","v":55}]
[null,{"$f":"IF(テストデータ!CO1=\"\",\"\",テストデータ!CO1)","v":""},{"$f":"IF(テストデータ!CJ2=\"\",\"\",テストデータ!CJ2)","v":"7/1"},"得点",null,{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$EF$503,88,FALSE)=\"\",IF(C38=\"\",\"\",\"欠\"),VLOOKUP($H$2,テストデータ!$A$4:$EF$503,88,FALSE))","v":52},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$EF$503,90,FALSE)=\"\",IF(C38=\"\",\"\",\"欠\"),VLOOKUP($H$2,テストデータ!$A$4:$EF$503,90,FALSE))","v":35},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$EF$503,92,FALSE)=\"\",IF(C38=\"\",\"\",\"欠\"),VLOOKUP($H$2,テストデータ!$A$4:$EF$503,92,FALSE))","v":82},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$EF$503,94,FALSE)=\"\",IF(C38=\"\",\"\",\"欠\"),VLOOKUP($H$2,テストデータ!$A$4:$EF$503,94,FALSE))","v":92},{"$f":"IF(SUM(F38:G38)=0,\"\",SUM(F38:G38))","v":87},{"$f":"IF(SUM(F38:I38)=0,\"\",SUM(F38:I38))","v":261}]
[null,null,null,"偏差値",null,{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$EF$503,89,FALSE)=\"\",NA(),VLOOKUP($H$2,テストデータ!$A$4:$EF$503,89,FALSE))","v":50},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$EF$503,91,FALSE)=\"\",NA(),VLOOKUP($H$2,テストデータ!$A$4:$EF$503,91,FALSE))","v":41},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$EF$503,93,FALSE)=\"\",NA(),VLOOKUP($H$2,テストデータ!$A$4:$EF$503,93,FALSE))","v":66},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$EF$503,95,FALSE)=\"\",NA(),VLOOKUP($H$2,テストデータ!$A$4:$EF$503,95,FALSE))","v":71},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$EF$503,98,FALSE)=\"\",NA(),VLOOKUP($H$2,テストデータ!$A$4:$EF$503,98,FALSE))","v":62},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$EF$503,99,FALSE)=\"\",NA(),VLOOKUP($H$2,テストデータ!$A$4:$EF$503,99,FALSE))","v":61}]
[null,{"$f":"IF(テストデータ!DA1=\"\",\"\",テストデータ!DA1)","v":""},{"$f":"IF(テストデータ!CV2=\"\",\"\",テストデータ!CV2)","v":"9/1"},"得点",null,{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$EF$503,100,FALSE)=\"\",IF(C40=\"\",\"\",\"欠\"),VLOOKUP($H$2,テストデータ!$A$4:$EF$503,100,FALSE))","v":"欠"},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$EF$503,102,FALSE)=\"\",IF(C40=\"\",\"\",\"欠\"),VLOOKUP($H$2,テストデータ!$A$4:$EF$503,102,FALSE))","v":"欠"},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$EF$503,104,FALSE)=\"\",IF(C40=\"\",\"\",\"欠\"),VLOOKUP($H$2,テストデータ!$A$4:$EF$503,104,FALSE))","v":"欠"},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$EF$503,106,FALSE)=\"\",IF(C40=\"\",\"\",\"欠\"),VLOOKUP($H$2,テストデータ!$A$4:$EF$503,106,FALSE))","v":"欠"},{"$f":"IF(SUM(F40:G40)=0,\"\",SUM(F40:G40))","v":""},{"$f":"IF(SUM(F40:I40)=0,\"\",SUM(F40:I40))","v":""}]
[null,null,null,"偏差値",null,{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$EF$503,101,FALSE)=\"\",NA(),VLOOKUP($H$2,テストデータ!$A$4:$EF$503,101,FALSE))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$EF$503,103,FALSE)=\"\",NA(),VLOOKUP($H$2,テストデータ!$A$4:$EF$503,103,FALSE))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$EF$503,105,FALSE)=\"\",NA(),VLOOKUP($H$2,テストデータ!$A$4:$EF$503,105,FALSE))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$EF$503,107,FALSE)=\"\",NA(),VLOOKUP($H$2,テストデータ!$A$4:$EF$503,107,FALSE))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$EF$503,110,FALSE)=\"\",NA(),VLOOKUP($H$2,テストデータ!$A$4:$EF$503,110,FALSE))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$EF$503,111,FALSE)=\"\",NA(),VLOOKUP($H$2,テストデータ!$A$4:$EF$503,111,FALSE))","v":{"$error":"#N/A"}}]
[null,{"$f":"IF(テストデータ!DM1=\"\",\"\",テストデータ!DM1)","v":""},{"$f":"IF(テストデータ!DH2=\"\",\"\",テストデータ!DH2)","v":"11/1"},"得点",null,{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$EF$503,112,FALSE)=\"\",IF(C42=\"\",\"\",\"欠\"),VLOOKUP($H$2,テストデータ!$A$4:$EF$503,112,FALSE))","v":52},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$EF$503,114,FALSE)=\"\",IF(C42=\"\",\"\",\"欠\"),VLOOKUP($H$2,テストデータ!$A$4:$EF$503,114,FALSE))","v":35},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$EF$503,116,FALSE)=\"\",IF(C42=\"\",\"\",\"欠\"),VLOOKUP($H$2,テストデータ!$A$4:$EF$503,116,FALSE))","v":82},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$EF$503,118,FALSE)=\"\",IF(C42=\"\",\"\",\"欠\"),VLOOKUP($H$2,テストデータ!$A$4:$EF$503,118,FALSE))","v":92},{"$f":"IF(SUM(F42:G42)=0,\"\",SUM(F42:G42))","v":87},{"$f":"IF(SUM(F42:I42)=0,\"\",SUM(F42:I42))","v":261}]
[null,null,null,"偏差値",null,{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$EF$503,113,FALSE)=\"\",NA(),VLOOKUP($H$2,テストデータ!$A$4:$EF$503,113,FALSE))","v":50},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$EF$503,115,FALSE)=\"\",NA(),VLOOKUP($H$2,テストデータ!$A$4:$EF$503,115,FALSE))","v":41},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$EF$503,117,FALSE)=\"\",NA(),VLOOKUP($H$2,テストデータ!$A$4:$EF$503,117,FALSE))","v":66},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$EF$503,119,FALSE)=\"\",NA(),VLOOKUP($H$2,テストデータ!$A$4:$EF$503,119,FALSE))","v":71},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$EF$503,122,FALSE)=\"\",NA(),VLOOKUP($H$2,テストデータ!$A$4:$EF$503,122,FALSE))","v":62},{"$f":"IF(VLOOKUP($H$2,テストデータ!$A$4:$EF$503,123,FALSE)=\"\",NA(),VLOOKUP($H$2,テストデータ!$A$4:$EF$503,123,FALSE))","v":61}]
[null,{"$f":"IF(テストデータ!DY1=\"\",\"\",テストデータ!DY1)","v":""},{"$f":"IF(テストデータ!DT2=\"\",\"\",テストデータ!DT2)","v":"1/15"},"得点"]
[null,null,null,"偏差値"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"アドバイス"]

{"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]]}
[]
[null,{"$f":"IF(初期設定!$C2=\"\",\"\",初期設定!$C2)","v":"月例テスト"}]
[null,"科目：",null,"算数","クラス：","6-A","実施日：","1/8"]
[]
[null,"ID","class","氏名","点数","順位",null,"平均点：","51.3点"]
[null,1,"6-A","鈴木A男",72,{"$f":"IF(E6=\"\",\"\",RANK(E6,$E$6:$E$505))","v":3},null,"クラス別平均点"]
[null,2,"6-A","鈴木B男",16,{"$f":"IF(E7=\"\",\"\",RANK(E7,$E$6:$E$505))","v":6},null,"6-A：","51.3点"]
[null,3,"6-A","鈴木C男",87,2]
[null,4,"6-A","鈴木D男",91,1]
[null,5,"6-A","鈴木E男",18,5]
[null,6,"6-A","鈴木F男",24,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,{"$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]]}
[]
[null,{"$f":"IF(初期設定!$C8=\"\",\"\",初期設定!$C8)","v":"模擬テスト"}]
[null,"実施：",null,"第２回","科目：","算数","クラス：","全クラス"]
[]
[null,"ID","class","氏名","得点","偏差値","順位","平均点：","60.6点"]
[null,1,"6-A","鈴木A男",90,65,{"$f":"IF(E6=\"\",\"\",RANK(E6,$E$6:$E$505))","v":5},"クラス別平均点"]
[null,2,"6-A","鈴木B男",36,30,{"$f":"IF(E7=\"\",\"\",RANK(E7,$E$6:$E$505))","v":16},"6-A：","57.7点"]
[null,3,"6-A","鈴木C男",72,61,8,"6-B：","64.7点"]
[null,4,"6-A","鈴木D男",56,22,11,"6-C：","59.8点"]
[null,5,"6-A","鈴木E男",19,35,20]
[null,6,"6-A","鈴木F男",73,41,7]
[null,7,"6-B","鈴木G男",97,45,1]
[null,8,"6-B","鈴木H男",55,44,12]
[null,9,"6-B","鈴木I男",68,63,9]
[null,10,"6-B","鈴木J男",92,62,4]
[null,11,"6-B","鈴木K男",28,61,17]
[null,12,"6-B","鈴木L男",48,54,14]
[null,13,"6-C","鈴木M男",21,73,19]
[null,14,"6-C","鈴木N男",94,67,2]
[null,15,"6-C","鈴木O男",93,69,3]
[null,16,"6-C","鈴木P男",26,49,18]
[null,17,"6-C","鈴木Q男",47,39,15]
[null,18,"6-C","鈴木R男",61,58,10]
[null,19,"6-C","鈴木S男",81,61,6]
[null,20,"6-C","鈴木T男",55,13,12]
[]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[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":20,"n_cols":11,"rows_kept":20,"cut":false,"hidden":false,"merged":[[3,4,3,7],[3,8,3,9],[7,4,7,6],[7,7,7,9],[7,10,7,13]]}
[]
["ID","class","氏名",null,"●名簿の表示"]
[7,"6-B","鈴木G男"]
[8,"6-B","鈴木H男",null,"印刷するclass：",null,null,null,"6-B",null,"→"]
[9,"6-B","鈴木I男"]
[10,"6-B","鈴木J男",null,"●印刷ページ指定"]
[11,"6-B","鈴木K男"]
[12,"6-B","鈴木L男",null,"成績表シートを",null,null,"1・2ページ両方",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":5,"n_rows":44,"n_cols":7,"rows_kept":44,"cut":false,"hidden":false,"merged":[]}
[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,"２科目","２科目"]
[null,"模試テスト名1",null,null,null,"４科目","４科目"]
[null,"模試テスト名2"]
[null,"模試テスト名3"]
[null,"模試テスト名4"]
[null,"模試テスト名5"]
[null,"模試テスト名6"]
[null,"定期テスト成績表タイトル"]
[null,"科目1","国語"]
[null,"科目2","算数"]
[null,"科目3","理科"]
[null,"科目4","社会"]
[null,"科目5"]
[null,"定期テスト名1"]
[null,"定期テスト名2"]
[null,"定期テスト名3"]
[null,"定期テスト名4"]
[null,"定期テスト名5"]
[null,"クラス名","全クラス"]
[null,"クラス1","6-A"]
[null,"クラス2","6-B"]
[null,"クラス3","6-C"]
[null,"クラス4"]
[null,"クラス5"]
[null,"クラス6"]
[null,"クラス7"]
[null,"クラス8"]
[null,"クラス9"]
[null,"クラス10"]
[null,"クラス11"]
[null,"クラス12"]
[null,"微風進学塾"]