{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["MAIN","Sheet1","Sheet2"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":2,"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":"MAIN","index":0,"n_rows":50,"n_cols":14,"rows_kept":50,"cut":false,"hidden":false,"merged":[[19,2,19,13],[28,7,29,13],[30,7,30,13],[21,4,21,5],[23,7,23,9],[26,7,26,13],[27,7,27,13],[21,3,22,3],[21,2,22,2],[21,7,21,9],[21,10,21,13],[22,10,22,13],[34,2,34,13],[47,10,47,13],[45,10,45,13],[45,2,46,3],[45,4,45,6],[46,4,46,6],[37,7,37,13],[36,2,43,6],[41,7,43,13],[36,7,36,13],[49,10,49,13]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"학생부 반영 방법"]
[]
[null,null,"석차등급","석차백분위","배점",null,null,"학년별 반영비율",null,null,"교과별 반영비율(%)"]
[null,null,null,null,"전체 전형","가천바람개비",null,"1학년","2학년","3학년 1학기","반영교과의 점수가 높은순"]
[null,null,1,0.04,100,100,null,"교과 성적(석차등급) 100% ",null,null,0.35,0.25,0.25,0.15]
[null,null,2,0.11,99.5,98]
[null,null,3,0.23,99,97]
[null,null,4,0.4,98.5,95,null,"※ 반영교과 : 국어, 수학, 영어, 사회(과학)"]
[null,null,5,0.6,98,80,null,"※ 반영교과별 우수 5과목씩 반영합니다."]
[null,null,6,0.77,95,75,null,"※ 교과별 이수 과목이 3학년 1학기 까지 5과목 미만일 경우 이수한 교과목까지만 반영합니다. \n   (학년, 학기 구분 없음)"]
[null,null,7,0.89,85,70]
[null,null,8,0.96,60,60,null,"※ 단, 의예과/한의예과는 국어, 수학, 영어, 과학 교과별 전과목을 반영합니다."]
[null,null,9,1,30,30]
[]
[]
[null,null,"전형별 학생부 반영 비율"]
[]
[null,null,"학생부 우수자\n학생부 우수자 성적산출의 경우 우측의 비교과 20% 실질반영점수와 Sheet1에서 산출되는 학생부 교과 80% 점수를\n합산해야 합니다. (자동합산 안됨)",null,null,null,null,"학생부 교과 80% + 비교과 20%"]
[null,null,null,null,null,null,null,"※ 비교과 20% 반영방법"]
[null,null,null,null,null,null,null,"무단결석일수","0~3일","4~6일","7~9일","10~12일","13~15일","16일 이상"]
[null,null,null,null,null,null,null,"봉사시간","28시간이상","27~25시간","24~22시간","21~19시간","18~16시간","15시간 이하"]
[null,null,null,null,null,null,null,"실질반영점수",100,95,90,85,80,75]
[null,null,null,null,null,null,null,"예) 무단결석일수 1일 + 봉사시간 28시간 이상의 경우\n     무단결석일수 0~3일 해당 = 100점, 봉사시간 28시간이상 해당 = 100점\n     → 100점 + 100점 = 200점"]
[]
[]
[]
[null,null,"가천바람개비",null,"1단계: 학생부 교과 100% (6배수 선발)",null,null,null,"적성우수자",null,"적성고사 40% + 학생부 교과 60%"]
[null,null,null,null,"2단계: (1단계)60% + 면접 40%"]
[null,null,null,null,null,null,null,null,"실기우수자",null,"학생부 교과 30% + 실기 70%"]
[]
[null,null,null,null,null,null,null,null,"농어촌(적성)",null,"적성고사 40% + 학생부 교과 60%"]

{"sheet":"Sheet1","index":1,"n_rows":63,"n_cols":41,"rows_kept":63,"cut":false,"hidden":false,"merged":[[9,0,18,0],[19,0,28,0],[29,0,38,0],[49,0,58,0],[39,0,48,0],[17,22,18,22],[17,23,18,24],[11,25,12,26],[13,25,14,26],[15,25,16,26],[17,25,18,26],[11,22,12,22],[13,22,14,22],[15,22,16,22],[11,23,12,24],[13,23,14,24],[15,23,16,24]]}
["Step. 1","전형선택"]
[null,"학생부우수자"]
[]
[]
[]
[]
["Step. 2","학생부 성적 입력"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"전형선택","전형선택",null,null,null,null,null,null,"국어","수학","영어","사회","과학"]
["교과","번호","code","과목\n순위","등급","이수\n단위","등급\n점수","row","반영\n점수","반영\n여부",null,null,null,"내신등급",1,2,null,"학생부우수자",1,8,null,null,{"$f":"IFERROR(SUMIF($J$10:$J$19,\"Y\",$I$10:$I$19)/SUMIF($J$10:$J$19,\"y\",$F$10:$F$19),\"\")","v":""},{"$f":"IFERROR(SUMIF($J$20:$J$29,\"Y\",$I$20:$I$29)/SUMIF($J$20:$J$29,\"y\",$F$20:$F$29),\"\")","v":""},{"$f":"IFERROR(SUMIF($J$30:$J$39,\"Y\",$I$30:$I$39)/SUMIF($J$30:$J$39,\"y\",$F$30:$F$39),\"\")","v":""},{"$f":"IFERROR(SUMIF($J$40:$J$49,\"Y\",$I$40:$I$49)/SUMIF($J$40:$J$49,\"y\",$F$40:$F$49),\"\")","v":""},{"$f":"IFERROR(SUMIF($J$50:$J$59,\"Y\",$I$50:$I$59)/SUMIF($J$50:$J$59,\"y\",$F$50:$F$59),\"\")","v":""},null,null,null,null,null,"번호","code","과목\n순위","등급","이수\n단위","등급\n점수","row","반영\n점수","반영\n여부"]
["국어\n교과",1,"a1",1,null,null,{"$f":"IFERROR(VLOOKUP(E10,$N$10:$P$19,IF($S$16>1,\"3\",\"2\"),FALSE),\"0\")","v":"0"},{"$f":"ROW()-9","v":1},{"$f":"G10*F10","v":0},{"$f":"VLOOKUP(C10,$AH$10:$AO$59,8,FALSE)","v":""},null,null,null,1,100,100,null,"적성우수자",1,6,null,null,null,null,null,null,null,null,null,null,null,null,1,"a1",1,null,null,{"$f":"IFERROR(VLOOKUP(AJ10,$N$10:$P$19,IF($S$16>1,\"3\",\"2\"),FALSE),\"0\")","v":"0"},{"$f":"ROW()-9","v":1},{"$f":"AL10*AK10","v":0},{"$f":"IF(OR(AJ10=0,AK10=0),\"\",IF(AK10=\"\",\"\",IF(AM10<=5,\"Y\",\"\")))","v":""}]
[null,2,"a2",1,null,null,{"$f":"IFERROR(VLOOKUP(E11,$N$10:$P$19,IF($S$16>1,\"3\",\"2\"),FALSE),\"0\")","v":"0"},{"$f":"ROW()-9","v":2},0,{"$f":"VLOOKUP(C11,$AH$10:$AO$59,8,FALSE)","v":""},null,null,null,2,99.5,98,null,"농어촌(적성)",1,6,null,null,null,null,null,null,null,null,null,null,null,null,2,"a2",1,null,null,"0",2,0,{"$f":"IF(OR(AJ11=0,AK11=0),\"\",IF(AK11=\"\",\"\",IF(AM11<=5,\"Y\",\"\")))","v":""}]
[null,3,"a3",1,null,null,"0",3,0,"",null,null,null,3,99,97,null,"실기우수자",1,3,null,null,"계열","점수",null,"반영비율적용",null,null,null,null,null,null,3,"a3",1,null,null,"0",3,0,""]
[null,4,"a4",1,null,null,"0",4,0,"",null,null,null,4,98.5,95,null,"가천바람개비",2,6,null,null,null,null,null,null,null,null,null,null,null,null,4,"a4",1,null,null,"0",4,0,""]
[null,5,"a5",1,null,null,"0",5,0,"",null,null,null,5,98,80,null,null,null,null,null,null,"인문",{"$f":"IFERROR($R$33,\"\")","v":""},null,{"$f":"IFERROR(IF($B$2=\"실기우수자\",\"-\",X14*VLOOKUP($B$2,$R$9:$T$14,3,FALSE)),\"-\")","v":"-"},null,null,null,null,null,null,5,"a5",1,null,null,"0",5,0,""]
[null,6,"a6",1,null,null,"0",6,0,"",null,null,null,6,95,75,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,"a6",1,null,null,"0",6,0,""]
[null,7,"a7",1,null,null,"0",7,0,"",null,null,null,7,85,70,null,"전형선택",{"$f":"VLOOKUP(B2,$R$9:$S$14,2,FALSE)","v":1},null,null,null,"자연",{"$f":"IFERROR($R$38,\"\")","v":""},null,{"$f":"IFERROR(IF($B$2=\"실기우수자\",\"-\",X16*VLOOKUP($B$2,$R$9:$T$14,3,FALSE)),\"-\")","v":"-"},null,null,null,null,null,null,7,"a7",1,null,null,"0",7,0,""]
[null,8,"a8",1,null,null,"0",8,0,"",null,null,null,8,60,60,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,"a8",1,null,null,"0",8,0,""]
[null,9,"a9",1,null,null,"0",9,0,"",null,null,null,9,30,30,null,null,null,null,null,null,"예체능",{"$f":"IFERROR($R$41,\"\")","v":""},null,{"$f":"IFERROR(IF($B$2=\"실기우수자\",X18*3,\"-\"),\"-\")","v":"-"},null,null,null,null,null,null,9,"a9",1,null,null,"0",9,0,""]
[null,10,"a10",1,null,null,"0",10,0,"",null,null,null,"-",0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,"a10",1,null,null,"0",10,0,""]
["수학\n교과",1,"b1",2,null,null,"0",{"$f":"ROW()-19","v":1},0,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"b1",2,null,null,"0",{"$f":"ROW()-19","v":1},0,""]
[null,2,"b2",2,null,null,"0",{"$f":"ROW()-19","v":2},0,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"b2",2,null,null,"0",2,0,""]
[null,3,"b3",2,null,null,"0",3,0,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"b3",2,null,null,"0",3,0,""]
[null,4,"b4",2,null,null,"0",4,0,"",null,null,null,null,"모집단위","계열",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"b4",2,null,null,"0",4,0,""]
[null,5,"b5",2,null,null,"0",5,0,"",null,null,null,null,"인문계열",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,"b5",2,null,null,"0",5,0,""]
[null,6,"b6",2,null,null,"0",6,0,"",null,null,null,null,"자연계열",2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,"b6",2,null,null,"0",6,0,""]
[null,7,"b7",2,null,null,"0",7,0,"",null,null,null,null,"예체능계열",3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,"b7",2,null,null,"0",7,0,""]
[null,8,"b8",2,null,null,"0",8,0,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,"b8",2,null,null,"0",8,0,""]
[null,9,"b9",2,null,null,"0",9,0,"",null,"인문",null,"순위","중복","순수 순위","비율",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,"b9",2,null,null,"0",9,0,""]
[null,10,"b10",2,null,null,"0",10,0,"",null,1,{"$f":"W9","v":""},{"$f":"RANK(M29,$M$29:$M$32)","v":{"$error":"#VALUE!"}},{"$f":"COUNTIF($N$29:N29,N29)-1","v":0},{"$f":"N29+O29","v":{"$error":"#VALUE!"}},{"$f":"VLOOKUP(P29,$P$44:$Q$47,2,FALSE)","v":{"$error":"#VALUE!"}},{"$f":"ROUND(M29*Q29,3)","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,"b10",2,null,null,"0",10,0,""]
["영어\n교과",1,"c1",3,null,null,"0",{"$f":"ROW()-29","v":1},0,"",null,2,{"$f":"X9","v":""},{"$f":"RANK(M30,$M$29:$M$32)","v":{"$error":"#VALUE!"}},{"$f":"COUNTIF($N$29:N30,N30)-1","v":1},{"$f":"N30+O30","v":{"$error":"#VALUE!"}},{"$f":"VLOOKUP(P30,$P$44:$Q$47,2,FALSE)","v":{"$error":"#VALUE!"}},{"$f":"ROUND(M30*Q30,3)","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"c1",3,null,null,"0",{"$f":"ROW()-29","v":1},0,""]
[null,2,"c2",3,null,null,"0",{"$f":"ROW()-29","v":2},0,"",null,3,{"$f":"Y9","v":""},{"$error":"#VALUE!"},{"$f":"COUNTIF($N$29:N31,N31)-1","v":2},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"ROUND(M31*Q31,3)","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"c2",3,null,null,"0",2,0,""]
[null,3,"c3",3,null,null,"0",3,0,"",null,4,{"$f":"Z9","v":""},{"$error":"#VALUE!"},{"$f":"COUNTIF($N$29:N32,N32)-1","v":3},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"ROUND(M32*Q32,3)","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"c3",3,null,null,"0",3,0,""]
[null,4,"c4",3,null,null,"0",4,0,"",null,"자연",null,null,null,null,null,{"$f":"SUM(R29:R32)","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"c4",3,null,null,"0",4,0,""]
[null,5,"c5",3,null,null,"0",5,0,"",null,1,{"$f":"W9","v":""},{"$f":"RANK(M34,$M$34:$M$37)","v":{"$error":"#VALUE!"}},{"$f":"COUNTIF($N$34:N34,N34)-1","v":0},{"$f":"N34+O34","v":{"$error":"#VALUE!"}},{"$f":"VLOOKUP(P34,$P$44:$Q$47,2,FALSE)","v":{"$error":"#VALUE!"}},{"$f":"ROUND(Q34*M34,3)","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,"c5",3,null,null,"0",5,0,""]
[null,6,"c6",3,null,null,"0",6,0,"",null,2,{"$f":"X9","v":""},{"$f":"RANK(M35,$M$34:$M$37)","v":{"$error":"#VALUE!"}},{"$f":"COUNTIF($N$34:N35,N35)-1","v":1},{"$f":"N35+O35","v":{"$error":"#VALUE!"}},{"$f":"VLOOKUP(P35,$P$44:$Q$47,2,FALSE)","v":{"$error":"#VALUE!"}},{"$f":"ROUND(Q35*M35,3)","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,"c6",3,null,null,"0",6,0,""]
[null,7,"c7",3,null,null,"0",7,0,"",null,3,{"$f":"Y9","v":""},{"$error":"#VALUE!"},{"$f":"COUNTIF($N$34:N36,N36)-1","v":2},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"ROUND(Q36*M36,3)","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,"c7",3,null,null,"0",7,0,""]
[null,8,"c8",3,null,null,"0",8,0,"",null,4,{"$f":"AA9","v":""},{"$error":"#VALUE!"},{"$f":"COUNTIF($N$34:N37,N37)-1","v":3},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"ROUND(Q37*M37,3)","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,"c8",3,null,null,"0",8,0,""]
[null,9,"c9",3,null,null,"0",9,0,"",null,"예체능",null,null,null,null,null,{"$f":"SUM(R34:R37)","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,"c9",3,null,null,"0",9,0,""]
[null,10,"c10",3,null,null,"0",10,0,"",null,1,{"$f":"W9","v":""},null,null,null,0.5,{"$f":"ROUND(M39*Q39,3)","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,"c10",3,null,null,"0",10,0,""]
["사회\n교과",1,"d1",4,null,null,"0",{"$f":"ROW()-39","v":1},0,"",null,2,{"$f":"Y9","v":""},null,null,null,0.5,{"$f":"ROUND(Q40*M40,3)","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"d1",4,null,null,"0",{"$f":"ROW()-39","v":1},0,""]
[null,2,"d2",4,null,null,"0",{"$f":"ROW()-39","v":2},0,"",null,null,null,null,null,null,null,{"$f":"SUM(R39:R40)","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"d2",4,null,null,"0",2,0,""]
[null,3,"d3",4,null,null,"0",3,{"$f":"G42*F42","v":0},"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"d3",4,null,null,{"$f":"IFERROR(VLOOKUP(AJ42,$N$10:$P$19,IF($S$16>1,\"3\",\"2\"),FALSE),\"0\")","v":"0"},3,{"$f":"AL42*AK42","v":0},""]
[null,4,"d4",4,null,null,"0",4,0,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"d4",4,null,null,"0",4,0,""]
[null,5,"d5",4,null,null,"0",5,0,"",null,null,null,null,null,1,0.35,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,"d5",4,null,null,"0",5,0,""]
[null,6,"d6",4,null,null,"0",6,0,"",null,null,null,null,null,2,0.25,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,"d6",4,null,null,"0",6,0,""]
[null,7,"d7",4,null,null,"0",7,0,"",null,null,null,null,null,3,0.25,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,"d7",4,null,null,"0",7,0,""]
[null,8,"d8",4,null,null,"0",8,0,"",null,null,null,null,null,4,0.15,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,"d8",4,null,null,"0",8,0,""]
[null,9,"d9",4,null,null,"0",9,0,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,"d9",4,null,null,"0",9,0,""]
[null,10,"d10",4,null,null,"0",10,0,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,"d10",4,null,null,"0",10,0,""]
["과학\n교과",1,"e1",5,null,null,"0",{"$f":"ROW()-49","v":1},0,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"e1",5,null,null,"0",{"$f":"ROW()-49","v":1},0,""]
[null,2,"e2",5,null,null,"0",{"$f":"ROW()-49","v":2},0,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"e2",5,null,null,"0",2,0,""]
[null,3,"e3",5,null,null,"0",3,0,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"e3",5,null,null,"0",3,0,""]
[null,4,"e4",5,null,null,"0",4,0,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"e4",5,null,null,"0",4,0,""]
[null,5,"e5",5,null,null,"0",5,0,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,"e5",5,null,null,"0",5,0,""]
[null,6,"e6",5,null,null,"0",6,0,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,"e6",5,null,null,"0",6,0,""]
[null,7,"e7",5,null,null,"0",7,0,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,"e7",5,null,null,"0",7,0,""]
[null,8,"e8",5,null,null,"0",8,0,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,"e8",5,null,null,"0",8,0,""]
[null,9,"e9",5,null,null,"0",9,0,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,"e9",5,null,null,"0",9,0,""]
[null,10,"e10",5,null,null,"0",10,0,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,"e10",5,null,null,"0",10,0,""]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"인문계열",{"$f":"IFERROR($R$33,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"자연계열",{"$f":"IFERROR($R$38,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"예체능계열",{"$f":"IFERROR($R$41,\"\")","v":""}]

{"sheet":"Sheet2","index":2,"n_rows":49,"n_cols":26,"rows_kept":49,"cut":false,"hidden":false,"merged":[[34,0,48,0],[4,0,13,0],[6,22,7,22],[6,23,7,23],[6,24,7,25],[8,22,9,22],[8,23,9,23],[8,24,9,25],[10,22,11,22],[10,23,11,24],[10,25,11,25],[12,22,13,22],[12,23,13,24],[12,25,13,25],[14,0,23,0],[24,0,33,0]]}
["의예과, 한의예과(학생부우수자 전형) 학생부 성적 산출"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"국어","수학","영어","과학"]
["교과","번호","code","과목\n순위","등급","이수\n단위","등급\n점수","row","반영\n점수","반영\n여부",null,null,null,"내신등급",1,null,null,null,null,null,null,null,{"$f":"IFERROR(O18,\"\")","v":""},{"$f":"IFERROR(O19,\"\")","v":""},{"$f":"IFERROR(O20,\"\")","v":""},{"$f":"IFERROR(O21,\"\")","v":""}]
["국어\n교과",1,"a1",1,null,null,{"$f":"IFERROR(VLOOKUP(E5,$N$5:$P$14,IF($S$11>1,\"3\",\"2\"),FALSE),\"0\")","v":"0"},{"$f":"ROW()-9","v":-4},{"$f":"G5*F5","v":0},null,null,null,null,1,100]
[null,2,"a2",1,null,null,"0",{"$f":"ROW()-9","v":-3},0,null,null,null,null,2,99.5]
[null,3,"a3",1,null,null,"0",-2,0,null,null,null,null,3,99,null,null,null,null,null,null,null,"계열","점수","반영비율적용"]
[null,4,"a4",1,null,null,"0",-1,0,null,null,null,null,4,98.5]
[null,5,"a5",1,null,null,"0",0,0,null,null,null,null,5,98,null,null,null,null,null,null,null,"의예/한의예",{"$f":"IFERROR($T$22,\"\")","v":""},{"$f":"IFERROR(X9*10,\"\")","v":""}]
[null,6,"a6",1,null,null,"0",1,0,null,null,null,null,6,95]
[null,7,"a7",1,null,null,"0",2,0,null,null,null,null,7,85]
[null,8,"a8",1,null,null,"0",3,0,null,null,null,null,8,60]
[null,9,"a9",1,null,null,"0",4,0,null,null,null,null,9,30]
[null,10,"a10",1,null,null,"0",5,0,null,null,null,null,"-",0]
["수학\n교과",1,"b1",2,null,null,"0",{"$f":"ROW()-19","v":-4},0]
[null,2,"b2",2,null,null,"0",{"$f":"ROW()-19","v":-3},0]
[null,3,"b3",2,null,null,"0",-2,0]
[null,4,"b4",2,null,null,"0",-1,0,null,null,null,null,"국어",{"$f":"SUM(I5:I14)/SUM(F5:F14)","v":{"$error":"#DIV/0!"}},{"$f":"RANK(O18,$O$18:$O$21)","v":{"$error":"#DIV/0!"}},{"$f":"COUNTIF($P$18:P18,P18)-1","v":0},{"$f":"P18+Q18","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP(R18,$N$25:$O$28,2,FALSE)","v":{"$error":"#DIV/0!"}},{"$f":"O18*S18","v":{"$error":"#DIV/0!"}}]
[null,5,"b5",2,null,null,"0",0,0,null,null,null,null,"수학",{"$f":"SUM(I15:I24)/SUM(F15:F24)","v":{"$error":"#DIV/0!"}},{"$f":"RANK(O19,$O$18:$O$21)","v":{"$error":"#DIV/0!"}},{"$f":"COUNTIF($P$18:P19,P19)-1","v":1},{"$f":"P19+Q19","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP(R19,$N$25:$O$28,2,FALSE)","v":{"$error":"#DIV/0!"}},{"$f":"O19*S19","v":{"$error":"#DIV/0!"}}]
[null,6,"b6",2,null,null,"0",1,0,null,null,null,null,"영어",{"$f":"SUM(I25:I34)/SUM(F25:F34)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"COUNTIF($P$18:P20,P20)-1","v":2},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,7,"b7",2,null,null,"0",2,0,null,null,null,null,"과학",{"$f":"SUM(I35:I49)/SUM(F35:F49)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"COUNTIF($P$18:P21,P21)-1","v":3},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,8,"b8",2,null,null,"0",3,0,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(T18:T21)","v":{"$error":"#DIV/0!"}}]
[null,9,"b9",2,null,null,"0",4,0]
[null,10,"b10",2,null,null,"0",5,0]
["영어\n교과",1,"c1",3,null,null,"0",{"$f":"ROW()-29","v":-4},0,null,null,null,null,1,0.35]
[null,2,"c2",3,null,null,"0",{"$f":"ROW()-29","v":-3},0,null,null,null,null,2,0.25]
[null,3,"c3",3,null,null,"0",-2,0,null,null,null,null,3,0.25]
[null,4,"c4",3,null,null,"0",-1,0,null,null,null,null,4,0.15]
[null,5,"c5",3,null,null,"0",0,0]
[null,6,"c6",3,null,null,"0",1,0]
[null,7,"c7",3,null,null,"0",2,0]
[null,8,"c8",3,null,null,"0",3,0]
[null,9,"c9",3,null,null,"0",4,0]
[null,10,"c10",3,null,null,"0",5,0]
["과학\n교과",1,"e1",5,null,null,"0",{"$f":"ROW()-49","v":-14},0]
[null,2,"e2",5,null,null,"0",{"$f":"ROW()-49","v":-13},0]
[null,3,"e3",5,null,null,"0",-12,0]
[null,4,"e4",5,null,null,"0",-11,0]
[null,5,"e5",5,null,null,"0",null,0]
[null,6,"e6",5,null,null,"0",null,0]
[null,7,"e7",5,null,null,"0",null,0]
[null,8,"e8",5,null,null,"0",null,0]
[null,9,"e9",5,null,null,"0",null,0]
[null,10,"e10",5,null,null,"0",-5,0]
[null,11,"e11",5,null,null,"0",-4,0]
[null,12,"e12",5,null,null,"0",-3,0]
[null,13,"e13",5,null,null,"0",-2,0]
[null,14,"e14",5,null,null,"0",-1,0]
[null,15,"e15",5,null,null,"0",0,0]