{"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":[[49,10,49,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],[19,2,19,13],[28,7,29,13],[30,7,30,13],[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],[21,4,21,5]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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.75]
[null,null,3,0.23,99,97.5]
[null,null,4,0.4,98.5,96.25,null,"※ 반영교과 : 국어, 수학, 영어, 사회(과학)"]
[null,null,5,0.6,98,95,null,"※ 반영교과별 우수 5과목씩(논술전형 3과목씩) 반영합니다."]
[null,null,6,0.77,95,93.75,null,"※ 교과별 이수 과목이 3학년 1학기 까지 5과목 미만일 경우 이수한 교과목까지만 반영합니다. \n   (학년, 학기 구분 없음)"]
[null,null,7,0.89,85,82.5]
[null,null,8,0.96,60,70,null,"※ 단, 의예과/한의예과/약학과는 국어, 수학, 영어, 과학 교과별 전과목을 반영합니다."]
[null,null,9,1,30,60,null,"※ 자유전공학부는 인문계열, 자연계열 반영 점수중 수험생에게 유리한 점수를 적용합니다."]
[]
[]
[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,null,null,null,null,null,"논술",null,"학생부 교과 40% + 논술고사 60%"]
[]
[null,null,null,null,null,null,null,null,"실기우수자",null,"학생부 교과 30% + 실기 70%"]
[]
[null,null,null,null,null,null,null,null,"지역균형, 농어촌(교과)",null,"학생부 교과 60% + 면접 40%"]

{"sheet":"Sheet1","index":1,"n_rows":63,"n_cols":74,"rows_kept":63,"cut":false,"hidden":false,"merged":[[17,25,18,26],[11,22,12,22],[13,22,14,22],[15,22,16,22],[13,23,14,23],[15,23,16,23],[17,23,18,23],[11,23,12,23],[17,24,18,24],[17,22,18,22],[11,24,12,24],[13,24,14,24],[15,24,16,24],[11,25,12,26],[13,25,14,26],[15,25,16,26],[55,0,56,0],[9,0,14,0],[15,0,16,0],[19,0,24,0],[25,0,26,0],[29,0,34,0],[35,0,36,0],[39,0,44,0],[45,0,46,0],[49,0,54,0]]}
["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,null,null,null,null,null,null,null,null,null,null,null,null,null,"전형선택","전형선택",null,null,null,null,null,"인문",{"$f":"IFERROR(ROUND(SUMIF($AO$10:$AO$19,\"Y\",$BE$10:$BE$19)/SUMIF($AO$10:$AO$19,\"y\",$AK$10:$AK$19),4),\"\")","v":""},{"$f":"IFERROR(ROUND(SUMIF($AO$20:$AO$29,\"Y\",$BE$20:$BE$29)/SUMIF($AO$20:$AO$29,\"y\",$AK$20:$AK$29),4),\"\")","v":""},{"$f":"IFERROR(ROUND(SUMIF($AO$30:$AO$39,\"Y\",$BE$30:$BE$39)/SUMIF($AO$30:$AO$39,\"y\",$AK$30:$AK$39),4),\"\")","v":""},{"$f":"IFERROR(ROUND(SUMIF($AO$40:$AO$49,\"Y\",$BE$40:$BE$49)/SUMIF($AO$40:$AO$49,\"y\",$AK$40:$AK$49),4),\"\")","v":""},{"$f":"IFERROR(ROUND(SUMIF($AO$50:$AO$59,\"Y\",$BE$50:$BE$59)/SUMIF($AO$50:$AO$59,\"y\",$AK$50:$AK$59),4),\"\")","v":""}]
["교과","번호","code","과목\n순위","등급","이수\n단위","등급\n점수","row","반영\n점수","반영\n여부",null,null,null,"내신등급",1,2,null,"학생부우수자",1,8,null,"자연",{"$f":"IFERROR(ROUND(SUMIF($AO$10:$AO$19,\"Y\",$BN$10:$BN$19)/SUMIF($AO$10:$AO$19,\"y\",$AK$10:$AK$19),4),\"\")","v":""},{"$f":"IFERROR(ROUND(SUMIF($AO$20:$AO$29,\"Y\",$BN$20:$BN$29)/SUMIF($AO$20:$AO$29,\"y\",$AK$20:$AK$29),4),\"\")","v":""},{"$f":"IFERROR(ROUND(SUMIF($AO$30:$AO$39,\"Y\",$BN$30:$BN$39)/SUMIF($AO$30:$AO$39,\"y\",$AK$30:$AK$39),4),\"\")","v":""},{"$f":"IFERROR(ROUND(SUMIF($AO$40:$AO$49,\"Y\",$BN$40:$BN$49)/SUMIF($AO$40:$AO$49,\"y\",$AK$40:$AK$49),4),\"\")","v":""},{"$f":"IFERROR(ROUND(SUMIF($AO$50:$AO$59,\"Y\",$BN$50:$BN$59)/SUMIF($AO$50:$AO$59,\"y\",$AK$50:$AK$59),4),\"\")","v":""},null,null,null,null,null,"번호","code","과목\n순위","등급","이수\n단위","등급\n점수","row","반영\n점수","반영\n여부",null,null,"인문","인문방영비율랭킹","자연","자연방영비율랭킹","예체능","인문","인문 등급 최하","인문 반영비율","반영비율등급까지 같을 때","인문과목순위","인문최종","인문최종등급","인문등급점수","반영점수","자연","자연 등급 최하","자연 반영비율","반영비율등급까지 같을 때","자연 과목순위","자연최종","자연최종등급","자연등급점수","반영점수","예체능","예체능","예체능","예체능","예체능최종","예체능최종등급","예체능등급점수","반영점수"]
["국어\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":""},{"$f":"LEFT(C10,1)","v":"a"},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":""},{"$f":"IF(AO10=\"\",\"\",COUNTIFS($AI$10:$AI$59,AI10,$AO$10:$AO$59,\"Y\"))","v":""},{"$f":"IF(AP10=AM10,\"최저\",\"\")","v":""},{"$f":"IFERROR(IF($AQ10=\"\",\"\",VLOOKUP(AI10,$L$29:$Q$32,6,FALSE)),\"\")","v":""},{"$f":"IF($AW10=\"\",\"\",VLOOKUP($AI10,$L$29:$P$37,5,FALSE))","v":""},{"$f":"IFERROR(IF($AQ10=\"\",\"\",VLOOKUP(AI10,$L$34:$Q$37,6,FALSE)),\"\")","v":""},{"$f":"IF($BF10=\"\",\"\",VLOOKUP($AI10,$L$29:$P$37,5,FALSE))","v":""},{"$f":"IFERROR(IF($AQ10=\"\",\"\",VLOOKUP(AI10,$L$39:$Q$40,6,FALSE)),\"\")","v":""},{"$f":"IF(OR($AR10=\"\",$A$18<>\"있음\"),\"\",$AJ10)","v":""},{"$f":"IF($AW10=\"\",\"\",COUNTIFS($AW$10:$AW$59,\">\"&$AW10))","v":""},{"$f":"IF($AW10=\"\",\"\",COUNTIFS($AW$10:$AW$59,$AW10,$AR$10:$AR$59,\">\"&$AR10))","v":""},{"$f":"IF($AW10=\"\",\"\",COUNTIFS($AW$10:$AW$59,$AW10,$AR$10:$AR$59,$AR10,$AS$10:$AS$59,\"<\"&$AS10))","v":""},{"$f":"IF($AW10=\"\",\"\",COUNTIFS($AW$10:$AW$59,$AW10,$AR$10:$AR$59,$AR10,$AZ$10:$AZ$59,$AZ10,$AI$10:$AI$59,\">\"&$AI10))","v":""},{"$f":"IF($AW10=\"\",\"\",SUM(AX10:BA10))","v":""},{"$f":"IF(OR($AJ10=\"\",$AO10<>\"Y\"),\"\",IF($AJ10=1,$AJ10,IF(OR($BB10=\"\",$AO10<>\"Y\"),$AJ10,IF(OR($BB10=0,$BB10=1),$AJ10-1,$AJ10))))","v":""},{"$f":"IFERROR(VLOOKUP($BC10,$N$10:$P$19,IF($S$16>1,\"3\",\"2\"),FALSE),\"0\")","v":"0"},{"$f":"BD10*$AK10","v":0},{"$f":"IF(OR($AT10=\"\",$A$18<>\"있음\"),\"\",$AJ10)","v":""},{"$f":"IF($BF10=\"\",\"\",COUNTIFS($BF$10:$BF$59,\">\"&$BF10))","v":""},{"$f":"IF($BF10=\"\",\"\",COUNTIFS($BF$10:$BF$59,$BF10,$AT$10:$AT$59,\">\"&$AT10))","v":""},{"$f":"IF($BF10=\"\",\"\",COUNTIFS($BF$10:$BF$59,$BF10,$AT$10:$AT$59,$AT10,$AU$10:$AU$59,\"<\"&$AU10))","v":""},{"$f":"IF($BF10=\"\",\"\",COUNTIFS($BF$10:$BF$59,$BF10,$AT$10:$AT$59,$AT10,$BI$10:$BI$59,$BI10,$AI$10:$AI$59,\">\"&$AI10))","v":""},{"$f":"IF($BF10=\"\",\"\",SUM(BG10:BJ10))","v":""},{"$f":"IF(OR($AJ10=\"\",$AO10<>\"Y\"),\"\",IF($AJ10=1,$AJ10,IF(OR($BK10=\"\",$AO10<>\"Y\"),$AJ10,IF(OR($BK10=0,$BK10=1),$AJ10-1,$AJ10))))","v":""},{"$f":"IFERROR(VLOOKUP($BL10,$N$10:$P$19,IF($S$16>1,\"3\",\"2\"),FALSE),\"0\")","v":"0"},{"$f":"BM10*$AK10","v":0},{"$f":"IF(OR($AV10=\"\",$A$18<>\"있음\"),\"\",$AJ10)","v":""},{"$f":"IF($BO10=\"\",\"\",COUNTIFS($BO$10:$BO$59,\">\"&$BO10))","v":""},{"$f":"IF($BO10=\"\",\"\",COUNTIFS($BO$10:$BO$59,$BO10,$AV$10:$AV$59,\">\"&$AV10))","v":""},{"$f":"IF($BO10=\"\",\"\",COUNTIFS($BO$10:$BO$59,$BO10,$AV$10:$AV$59,$AV10,$AI$10:$AI$59,\">\"&$AI10))","v":""},{"$f":"IF($BO10=\"\",\"\",SUM(BP10:BR10))","v":""},{"$f":"IF(OR($AJ10=\"\",$AO10<>\"Y\"),\"\",IF($AJ10=1,$AJ10,IF(OR($BS10=\"\",$AO10<>\"Y\"),$AJ10,IF(OR($BS10=0,$BS10=1),$AJ10-1,$AJ10))))","v":""},{"$f":"IFERROR(VLOOKUP($BT10,$N$10:$P$19,IF($S$16>1,\"3\",\"2\"),FALSE),\"0\")","v":"0"},{"$f":"BU10*$AK10","v":0}]
[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":""},{"$f":"LEFT(C11,1)","v":"a"},null,null,2,99.5,98.75,null,"농어촌(교과)",1,6,null,null,null,null,null,null,null,null,null,null,null,null,2,"a2",1,null,null,{"$f":"IFERROR(VLOOKUP(AJ11,$N$10:$P$19,IF($S$16>1,\"3\",\"2\"),FALSE),\"0\")","v":"0"},{"$f":"ROW()-9","v":2},{"$f":"AL11*AK11","v":0},{"$f":"IF(OR(AJ11=0,AK11=0),\"\",IF(AK11=\"\",\"\",IF(AM11<=5,\"Y\",\"\")))","v":""},"","","","","",{"$f":"IF($BF11=\"\",\"\",VLOOKUP($AI11,$L$29:$P$37,5,FALSE))","v":""},"","","","",{"$f":"IF($AW11=\"\",\"\",COUNTIFS($AW$10:$AW$59,$AW11,$AR$10:$AR$59,$AR11,$AS$10:$AS$59,\"<\"&$AS11))","v":""},"","","","0",{"$f":"BD11*$AK11","v":0},"",{"$f":"IF($BF11=\"\",\"\",COUNTIFS($BF$10:$BF$59,\">\"&$BF11))","v":""},"",{"$f":"IF($BF11=\"\",\"\",COUNTIFS($BF$10:$BF$59,$BF11,$AT$10:$AT$59,$AT11,$AU$10:$AU$59,\"<\"&$AU11))","v":""},{"$f":"IF($BF11=\"\",\"\",COUNTIFS($BF$10:$BF$59,$BF11,$AT$10:$AT$59,$AT11,$BI$10:$BI$59,$BI11,$AI$10:$AI$59,\">\"&$AI11))","v":""},{"$f":"IF($BF11=\"\",\"\",SUM(BG11:BJ11))","v":""},"","0",{"$f":"BM11*$AK11","v":0},"",{"$f":"IF($BO11=\"\",\"\",COUNTIFS($BO$10:$BO$59,\">\"&$BO11))","v":""},"","",{"$f":"IF($BO11=\"\",\"\",SUM(BP11:BR11))","v":""},"","0",{"$f":"BU11*$AK11","v":0}]
[null,3,"a3",1,null,null,"0",3,0,"","a",null,null,3,99,97.5,null,"실기우수자",1,3,null,null,"계열","점수","등급","반영비율적용",null,null,null,null,null,null,3,"a3",1,null,null,{"$f":"IFERROR(VLOOKUP(AJ12,$N$10:$P$19,IF($S$16>1,\"3\",\"2\"),FALSE),\"0\")","v":"0"},{"$f":"ROW()-9","v":3},{"$f":"AL12*AK12","v":0},"","","","","","","","","","","","","","","","0",0,"","","","","","","","0",0,"","","","","","","0",0]
[null,4,"a4",1,null,null,"0",4,0,"","a",null,null,4,98.5,96.25,null,"논술",2,4,null,null,null,null,null,null,null,null,null,null,null,null,4,"a4",1,null,null,{"$f":"IFERROR(VLOOKUP(AJ13,$N$10:$P$19,IF($S$16>1,\"3\",\"2\"),FALSE),\"0\")","v":"0"},{"$f":"ROW()-9","v":4},{"$f":"AL13*AK13","v":0},"","","","","","","","","","","","","","","","0",0,"","","","","","","","0",0,"","","","","","","0",0]
[null,5,"a5",1,null,null,"0",5,0,"","a",null,null,5,98,95,null,null,null,null,null,null,"인문",{"$f":"IFERROR($R$33,\"\")","v":""},{"$f":"IFERROR(ROUND(SUMIFS($E$10:$E$59,$J$10:$J$59,\"Y\",$K$10:$K$59,\"<>\"&\"e\")/COUNTIFS($J$10:$J$59,\"Y\",$K$10:$K$59,\"<>\"&\"e\"),2),\"\")","v":""},{"$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,{"$f":"IFERROR(VLOOKUP(AJ14,$N$10:$P$19,IF($S$16>1,\"3\",\"2\"),FALSE),\"0\")","v":"0"},{"$f":"ROW()-9","v":5},{"$f":"AL14*AK14","v":0},"","","","","","","","","","","","","","","","0",0,"","","","","","","","0",0,"","","","","","","0",0]
[null,6,"a6",1,null,null,"0",6,0,"","a",null,null,6,97.5,93.75,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,"a6",1,null,null,{"$f":"IFERROR(VLOOKUP(AJ15,$N$10:$P$19,IF($S$16>1,\"3\",\"2\"),FALSE),\"0\")","v":"0"},{"$f":"ROW()-9","v":6},{"$f":"AL15*AK15","v":0},"","","","","","","","","","","","","","","","0",0,"","","","","","","","0",0,"","","","","","","0",0]
["진로선택A여부",7,"a7",1,null,null,"0",7,0,"","a",null,null,7,85,82.5,null,"전형선택",{"$f":"VLOOKUP(B2,$R$9:$S$14,2,FALSE)","v":1},null,null,null,"자연",{"$f":"IFERROR($R$38,\"\")","v":""},{"$f":"IFERROR(ROUND(SUMIFS($E$10:$E$59,$J$10:$J$59,\"Y\",$K$10:$K$59,\"<>\"&\"d\")/COUNTIFS($J$10:$J$59,\"Y\",$K$10:$K$59,\"<>\"&\"d\"),2),\"\")","v":""},{"$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,{"$f":"IFERROR(VLOOKUP(AJ16,$N$10:$P$19,IF($S$16>1,\"3\",\"2\"),FALSE),\"0\")","v":"0"},{"$f":"ROW()-9","v":7},{"$f":"AL16*AK16","v":0},"","","","","","","","","","","","","","","","0",0,"","","","","","","","0",0,"","","","","","","0",0]
[null,8,"a8",1,null,null,"0",8,0,"","a",null,null,8,60,70,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,"a8",1,null,null,{"$f":"IFERROR(VLOOKUP(AJ17,$N$10:$P$19,IF($S$16>1,\"3\",\"2\"),FALSE),\"0\")","v":"0"},{"$f":"ROW()-9","v":8},{"$f":"AL17*AK17","v":0},"","","","","","","","","","","","","","","","0",0,"","","","","","","","0",0,"","","","","","","0",0]
["없음",9,"a9",1,null,null,"0",9,0,"","a",null,null,9,30,60,null,null,null,null,null,null,"예체능",{"$f":"IFERROR($R$41,\"\")","v":""},{"$f":"IFERROR(ROUND(SUMIFS($E$10:$E$59,$J$10:$J$59,\"Y\",$K$10:$K$59,\"<>\"&\"b\",$K$10:$K$59,\"<>\"&\"d\",$K$10:$K$59,\"<>\"&\"e\")/COUNTIFS($J$10:$J$59,\"Y\",$K$10:$K$59,\"<>\"&\"b\",$K$10:$K$59,\"<>\"&\"d\",$K$10:$K$59,\"<>\"&\"e\"),2),\"\")","v":""},{"$f":"IFERROR(IF($B$2=\"실기우수자\",X18*3,\"-\"),\"-\")","v":"-"},null,null,null,null,null,null,9,"a9",1,null,null,{"$f":"IFERROR(VLOOKUP(AJ18,$N$10:$P$19,IF($S$16>1,\"3\",\"2\"),FALSE),\"0\")","v":"0"},{"$f":"ROW()-9","v":9},{"$f":"AL18*AK18","v":0},"","","","","","","","","","","","","","","","0",0,"","","","","","","","0",0,"","","","","","","0",0]
[null,10,"a10",1,null,null,"0",10,0,"","a",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,{"$f":"IFERROR(VLOOKUP(AJ19,$N$10:$P$19,IF($S$16>1,\"3\",\"2\"),FALSE),\"0\")","v":"0"},{"$f":"ROW()-9","v":10},{"$f":"AL19*AK19","v":0},"","","","","","","","","","","","","","","","0",0,"","","","","","","","0",0,"","","","","","","0",0]
["수학\n교과",1,"b1",2,null,null,"0",{"$f":"ROW()-19","v":1},0,"","b",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,{"$f":"IFERROR(VLOOKUP(AJ20,$N$10:$P$19,IF($S$16>1,\"3\",\"2\"),FALSE),\"0\")","v":"0"},{"$f":"ROW()-19","v":1},{"$f":"AL20*AK20","v":0},"","","","","","","","",{"$f":"IF(OR($AR20=\"\",$A$28<>\"있음\"),\"\",$AJ20)","v":""},"","","","","","","0",0,{"$f":"IF(OR($AT20=\"\",$A$28<>\"있음\"),\"\",$AJ20)","v":""},"","","","","","","0",0,{"$f":"IF(OR($AV20=\"\",$A$28<>\"있음\"),\"\",$AJ20)","v":""},"","","","","","0",0]
[null,2,"b2",2,null,null,"0",{"$f":"ROW()-19","v":2},0,"","b",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,{"$f":"IFERROR(VLOOKUP(AJ21,$N$10:$P$19,IF($S$16>1,\"3\",\"2\"),FALSE),\"0\")","v":"0"},{"$f":"ROW()-19","v":2},{"$f":"AL21*AK21","v":0},"","","","","","","","","","","","","","","","0",0,"","","","","","","","0",0,"","","","","","","0",0]
[null,3,"b3",2,null,null,"0",3,0,"","b",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,{"$f":"IFERROR(VLOOKUP(AJ22,$N$10:$P$19,IF($S$16>1,\"3\",\"2\"),FALSE),\"0\")","v":"0"},{"$f":"ROW()-19","v":3},{"$f":"AL22*AK22","v":0},"","","","","","","","","","","","","","","","0",0,"","","","","","","","0",0,"","","","","","","0",0]
[null,4,"b4",2,null,null,"0",4,0,"","b",null,null,null,"모집단위","계열",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"b4",2,null,null,{"$f":"IFERROR(VLOOKUP(AJ23,$N$10:$P$19,IF($S$16>1,\"3\",\"2\"),FALSE),\"0\")","v":"0"},{"$f":"ROW()-19","v":4},{"$f":"AL23*AK23","v":0},"","","","","","","","","","","","","","","","0",0,"","","","","","","","0",0,"","","","","","","0",0]
[null,5,"b5",2,null,null,"0",5,0,"","b",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,{"$f":"IFERROR(VLOOKUP(AJ24,$N$10:$P$19,IF($S$16>1,\"3\",\"2\"),FALSE),\"0\")","v":"0"},{"$f":"ROW()-19","v":5},{"$f":"AL24*AK24","v":0},"","","","","","","","","","","","","","","","0",0,"","","","","","","","0",0,"","","","","","","0",0]
[null,6,"b6",2,null,null,"0",6,0,"","b",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,{"$f":"IFERROR(VLOOKUP(AJ25,$N$10:$P$19,IF($S$16>1,\"3\",\"2\"),FALSE),\"0\")","v":"0"},{"$f":"ROW()-19","v":6},{"$f":"AL25*AK25","v":0},"","","","","","","","","","","","","","","","0",0,"","","","","","","","0",0,"","","","","","","0",0]
["진로선택A여부",7,"b7",2,null,null,"0",7,0,"","b",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,{"$f":"IFERROR(VLOOKUP(AJ26,$N$10:$P$19,IF($S$16>1,\"3\",\"2\"),FALSE),\"0\")","v":"0"},{"$f":"ROW()-19","v":7},{"$f":"AL26*AK26","v":0},"","","","","","","","","","","","","","","","0",0,"","","","","","","","0",0,"","","","","","","0",0]
[null,8,"b8",2,null,null,"0",8,0,"","b",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,{"$f":"IFERROR(VLOOKUP(AJ27,$N$10:$P$19,IF($S$16>1,\"3\",\"2\"),FALSE),\"0\")","v":"0"},{"$f":"ROW()-19","v":8},{"$f":"AL27*AK27","v":0},"","","","","","","","","","","","","","","","0",0,"","","","","","","","0",0,"","","","","","","0",0]
["없음",9,"b9",2,null,null,"0",9,0,"","b","인문","진선반영전","순위","진로선택순위","최종 순위","비율",null,null,"진로선택A여부","과목순위",null,null,null,null,null,null,null,null,null,null,null,9,"b9",2,null,null,{"$f":"IFERROR(VLOOKUP(AJ28,$N$10:$P$19,IF($S$16>1,\"3\",\"2\"),FALSE),\"0\")","v":"0"},{"$f":"ROW()-19","v":9},{"$f":"AL28*AK28","v":0},"","","","","","","","","","","","","","","","0",0,"","","","","","","","0",0,"","","","","","","0",0]
[null,10,"b10",2,null,null,"0",10,0,"","b",1,{"$f":"IFERROR(ROUND(SUMIF($J$10:$J$19,\"Y\",$I$10:$I$19)/SUMIF($J$10:$J$19,\"y\",$F$10:$F$19),4),\"\")","v":""},{"$f":"COUNTIFS($M$29:$M$32,\">\"&$M29)+1","v":1},{"$f":"COUNTIFS($M$29:$M$32,$M29,$T$29:$T$32,\">\"&$T29)","v":0},{"$f":"N29+O29+U29","v":1},{"$f":"VLOOKUP(P29,$P$44:$Q$47,2,FALSE)","v":0.35},{"$f":"ROUND(Q29*S29,3)","v":{"$error":"#VALUE!"}},{"$f":"W8","v":""},{"$f":"COUNTIFS($A$10:$A$59,\"있음\",$D$10:$D$59,$L29)","v":0},{"$f":"COUNTIFS($M$29:$M$32,$M29,$T$29:$T$32,$T29,$L$29:$L$32,\"<\"&$L29)","v":0},null,null,null,null,null,null,null,null,null,null,null,10,"b10",2,null,null,{"$f":"IFERROR(VLOOKUP(AJ29,$N$10:$P$19,IF($S$16>1,\"3\",\"2\"),FALSE),\"0\")","v":"0"},{"$f":"ROW()-19","v":10},{"$f":"AL29*AK29","v":0},"","","","","","","","","","","","","","","","0",0,"","","","","","","","0",0,"","","","","","","0",0]
["영어\n교과",1,"c1",3,null,null,"0",{"$f":"ROW()-29","v":1},0,"","c",2,{"$f":"IFERROR(ROUND(SUMIF($J$20:$J$29,\"Y\",$I$20:$I$29)/SUMIF($J$20:$J$29,\"y\",$F$20:$F$29),4),\"\")","v":""},{"$f":"COUNTIFS($M$29:$M$32,\">\"&$M30)+1","v":1},{"$f":"COUNTIFS($M$29:$M$32,$M30,$T$29:$T$32,\">\"&$T30)","v":0},{"$f":"N30+O30+U30","v":2},{"$f":"VLOOKUP(P30,$P$44:$Q$47,2,FALSE)","v":0.25},{"$f":"ROUND(Q30*S30,3)","v":{"$error":"#VALUE!"}},{"$f":"X8","v":""},{"$f":"COUNTIFS($A$10:$A$59,\"있음\",$D$10:$D$59,$L30)","v":0},{"$f":"COUNTIFS($M$29:$M$32,$M30,$T$29:$T$32,$T30,$L$29:$L$32,\"<\"&$L30)","v":1},null,null,null,null,null,null,null,null,null,null,null,1,"c1",3,null,null,{"$f":"IFERROR(VLOOKUP(AJ30,$N$10:$P$19,IF($S$16>1,\"3\",\"2\"),FALSE),\"0\")","v":"0"},{"$f":"ROW()-29","v":1},{"$f":"AL30*AK30","v":0},"","","","","","","","",{"$f":"IF(OR($AR30=\"\",$A$38<>\"있음\"),\"\",$AJ30)","v":""},"","","","","","","0",0,{"$f":"IF(OR($AT30=\"\",$A$38<>\"있음\"),\"\",$AJ30)","v":""},"","","","","","","0",0,{"$f":"IF(OR($AV30=\"\",$A$38<>\"있음\"),\"\",$AJ30)","v":""},"","","","","","0",0]
[null,2,"c2",3,null,null,"0",{"$f":"ROW()-29","v":2},0,"","c",3,{"$f":"IFERROR(ROUND(SUMIF($J$30:$J$39,\"Y\",$I$30:$I$39)/SUMIF($J$30:$J$39,\"y\",$F$30:$F$39),4),\"\")","v":""},1,0,3,0.25,{"$error":"#VALUE!"},{"$f":"Y8","v":""},0,2,null,null,null,null,null,null,null,null,null,null,null,2,"c2",3,null,null,{"$f":"IFERROR(VLOOKUP(AJ31,$N$10:$P$19,IF($S$16>1,\"3\",\"2\"),FALSE),\"0\")","v":"0"},{"$f":"ROW()-29","v":2},{"$f":"AL31*AK31","v":0},"","","","","","","","","","","","","","","","0",0,"","","","","","","","0",0,"","","","","","","0",0]
[null,3,"c3",3,null,null,"0",3,0,"","c",4,{"$f":"IFERROR(ROUND(SUMIF($J$40:$J$49,\"Y\",$I$40:$I$49)/SUMIF($J$40:$J$49,\"y\",$F$40:$F$49),4),\"\")","v":""},1,0,4,0.15,{"$error":"#VALUE!"},{"$f":"Z8","v":""},0,3,null,null,null,null,null,null,null,null,null,null,null,3,"c3",3,null,null,{"$f":"IFERROR(VLOOKUP(AJ32,$N$10:$P$19,IF($S$16>1,\"3\",\"2\"),FALSE),\"0\")","v":"0"},{"$f":"ROW()-29","v":3},{"$f":"AL32*AK32","v":0},"","","","","","","","","","","","","","","","0",0,"","","","","","","","0",0,"","","","","","","0",0]
[null,4,"c4",3,null,null,"0",4,0,"","c","자연",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,{"$f":"IFERROR(VLOOKUP(AJ33,$N$10:$P$19,IF($S$16>1,\"3\",\"2\"),FALSE),\"0\")","v":"0"},{"$f":"ROW()-29","v":4},{"$f":"AL33*AK33","v":0},"","","","","","","","","","","","","","","","0",0,"","","","","","","","0",0,"","","","","","","0",0]
[null,5,"c5",3,null,null,"0",5,0,"","c",1,{"$f":"IFERROR(ROUND(SUMIF($J$10:$J$19,\"Y\",$I$10:$I$19)/SUMIF($J$10:$J$19,\"y\",$F$10:$F$19),4),\"\")","v":""},{"$f":"COUNTIFS($M$34:$M$37,\">\"&$M34)+1","v":1},{"$f":"COUNTIFS($M$34:$M$37,$M34,$T$34:$T$37,\">\"&$T34)","v":0},1,{"$f":"VLOOKUP(P34,$P$44:$Q$47,2,FALSE)","v":0.35},{"$f":"ROUND(Q34*S34,3)","v":{"$error":"#VALUE!"}},{"$f":"W9","v":""},0,{"$f":"COUNTIFS($M$34:$M$37,$M34,$T$29:$T$32,$T34,$L$34:$L$37,\"<\"&$L34)","v":0},null,null,null,null,null,null,null,null,null,null,null,5,"c5",3,null,null,{"$f":"IFERROR(VLOOKUP(AJ34,$N$10:$P$19,IF($S$16>1,\"3\",\"2\"),FALSE),\"0\")","v":"0"},{"$f":"ROW()-29","v":5},{"$f":"AL34*AK34","v":0},"","","","","","","","","","","","","","","","0",0,"","","","","","","","0",0,"","","","","","","0",0]
[null,6,"c6",3,null,null,"0",6,0,"","c",2,{"$f":"IFERROR(ROUND(SUMIF($J$20:$J$29,\"Y\",$I$20:$I$29)/SUMIF($J$20:$J$29,\"y\",$F$20:$F$29),4),\"\")","v":""},{"$f":"COUNTIFS($M$34:$M$37,\">\"&$M35)+1","v":1},{"$f":"COUNTIFS($M$34:$M$37,$M35,$T$34:$T$37,\">\"&$T35)","v":0},2,{"$f":"VLOOKUP(P35,$P$44:$Q$47,2,FALSE)","v":0.25},{"$f":"ROUND(Q35*S35,3)","v":{"$error":"#VALUE!"}},{"$f":"X9","v":""},0,{"$f":"COUNTIFS($M$34:$M$37,$M35,$T$29:$T$32,$T35,$L$34:$L$37,\"<\"&$L35)","v":1},null,null,null,null,null,null,null,null,null,null,null,6,"c6",3,null,null,{"$f":"IFERROR(VLOOKUP(AJ35,$N$10:$P$19,IF($S$16>1,\"3\",\"2\"),FALSE),\"0\")","v":"0"},{"$f":"ROW()-29","v":6},{"$f":"AL35*AK35","v":0},"","","","","","","","","","","","","","","","0",0,"","","","","","","","0",0,"","","","","","","0",0]
["진로선택A여부",7,"c7",3,null,null,"0",7,0,"","c",3,{"$f":"IFERROR(ROUND(SUMIF($J$30:$J$39,\"Y\",$I$30:$I$39)/SUMIF($J$30:$J$39,\"y\",$F$30:$F$39),4),\"\")","v":""},1,0,3,0.25,{"$error":"#VALUE!"},{"$f":"Y9","v":""},0,2,null,null,null,null,null,null,null,null,null,null,null,7,"c7",3,null,null,{"$f":"IFERROR(VLOOKUP(AJ36,$N$10:$P$19,IF($S$16>1,\"3\",\"2\"),FALSE),\"0\")","v":"0"},{"$f":"ROW()-29","v":7},{"$f":"AL36*AK36","v":0},"","","","","","","","","","","","","","","","0",0,"","","","","","","","0",0,"","","","","","","0",0]
[null,8,"c8",3,null,null,"0",8,0,"","c",5,{"$f":"IFERROR(ROUND(SUMIF($J$50:$J$59,\"Y\",$I$50:$I$59)/SUMIF($J$50:$J$59,\"y\",$F$50:$F$59),4),\"\")","v":""},1,0,4,0.15,{"$error":"#VALUE!"},{"$f":"AA9","v":""},0,3,null,null,null,null,null,null,null,null,null,null,null,8,"c8",3,null,null,{"$f":"IFERROR(VLOOKUP(AJ37,$N$10:$P$19,IF($S$16>1,\"3\",\"2\"),FALSE),\"0\")","v":"0"},{"$f":"ROW()-29","v":8},{"$f":"AL37*AK37","v":0},"","","","","","","","","","","","","","","","0",0,"","","","","","","","0",0,"","","","","","","0",0]
["없음",9,"c9",3,null,null,"0",9,0,"","c","예체능",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,{"$f":"IFERROR(VLOOKUP(AJ38,$N$10:$P$19,IF($S$16>1,\"3\",\"2\"),FALSE),\"0\")","v":"0"},{"$f":"ROW()-29","v":9},{"$f":"AL38*AK38","v":0},"","","","","","","","","","","","","","","","0",0,"","","","","","","","0",0,"","","","","","","0",0]
[null,10,"c10",3,null,null,"0",10,0,"","c",1,{"$f":"IFERROR(ROUND(SUMIF($J$10:$J$19,\"Y\",$I$10:$I$19)/SUMIF($J$10:$J$19,\"y\",$F$10:$F$19),4),\"\")","v":""},null,null,null,0.5,{"$f":"ROUND(S39*Q39,3)","v":{"$error":"#VALUE!"}},{"$f":"IFERROR(ROUND(SUMIF($AO$10:$AO$19,\"Y\",$BV$10:$BV$19)/SUMIF($AO$10:$AO$19,\"y\",$AK$10:$AK$19),4),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,10,"c10",3,null,null,{"$f":"IFERROR(VLOOKUP(AJ39,$N$10:$P$19,IF($S$16>1,\"3\",\"2\"),FALSE),\"0\")","v":"0"},{"$f":"ROW()-29","v":10},{"$f":"AL39*AK39","v":0},"","","","","","","","","","","","","","","","0",0,"","","","","","","","0",0,"","","","","","","0",0]
["사회\n교과",1,"d1",4,null,null,"0",{"$f":"ROW()-39","v":1},0,"","d",3,{"$f":"IFERROR(ROUND(SUMIF($J$30:$J$39,\"Y\",$I$30:$I$39)/SUMIF($J$30:$J$39,\"y\",$F$30:$F$39),4),\"\")","v":""},null,null,null,0.5,{"$f":"ROUND(S40*Q40,3)","v":{"$error":"#VALUE!"}},{"$f":"IFERROR(ROUND(SUMIF($AO$30:$AO$39,\"Y\",$BV$30:$BV$39)/SUMIF($AO$30:$AO$39,\"y\",$AK$30:$AK$39),4),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,1,"d1",4,null,null,{"$f":"IFERROR(VLOOKUP(AJ40,$N$10:$P$19,IF($S$16>1,\"3\",\"2\"),FALSE),\"0\")","v":"0"},{"$f":"ROW()-39","v":1},{"$f":"AL40*AK40","v":0},"","","","","","","","",{"$f":"IF(OR($AR40=\"\",$A$48<>\"있음\"),\"\",$AJ40)","v":""},"","","","","","","0",0,{"$f":"IF(OR($AT40=\"\",$A$48<>\"있음\"),\"\",$AJ40)","v":""},"","","","","","","0",0,{"$f":"IF(OR($AV40=\"\",$A$48<>\"있음\"),\"\",$AJ40)","v":""},"","","","","","0",0]
[null,2,"d2",4,null,null,"0",{"$f":"ROW()-39","v":2},0,"","d",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,{"$f":"IFERROR(VLOOKUP(AJ41,$N$10:$P$19,IF($S$16>1,\"3\",\"2\"),FALSE),\"0\")","v":"0"},{"$f":"ROW()-39","v":2},{"$f":"AL41*AK41","v":0},"","","","","","","","","","","","","","","","0",0,"","","","","","","","0",0,"","","","","","","0",0]
[null,3,"d3",4,null,null,"0",3,{"$f":"G42*F42","v":0},"","d",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"},{"$f":"ROW()-39","v":3},{"$f":"AL42*AK42","v":0},"",{"$f":"IF(AO42=\"\",\"\",COUNTIFS($AI$10:$AI$59,AI42,$AO$10:$AO$59,\"Y\"))","v":""},{"$f":"IF(AP42=AM42,\"최저\",\"\")","v":""},{"$f":"IFERROR(IF($AQ42=\"\",\"\",VLOOKUP(AI42,$L$29:$Q$32,6,FALSE)),\"\")","v":""},{"$f":"IF($AW42=\"\",\"\",VLOOKUP($AI42,$L$29:$P$37,5,FALSE))","v":""},{"$f":"IFERROR(IF($AQ42=\"\",\"\",VLOOKUP(AI42,$L$34:$Q$37,6,FALSE)),\"\")","v":""},"",{"$f":"IFERROR(IF($AQ42=\"\",\"\",VLOOKUP(AI42,$L$39:$Q$40,6,FALSE)),\"\")","v":""},"",{"$f":"IF($AW42=\"\",\"\",COUNTIFS($AW$10:$AW$59,\">\"&$AW42))","v":""},{"$f":"IF($AW42=\"\",\"\",COUNTIFS($AW$10:$AW$59,$AW42,$AR$10:$AR$59,\">\"&$AR42))","v":""},"",{"$f":"IF($AW42=\"\",\"\",COUNTIFS($AW$10:$AW$59,$AW42,$AR$10:$AR$59,$AR42,$AZ$10:$AZ$59,$AZ42,$AI$10:$AI$59,\">\"&$AI42))","v":""},{"$f":"IF($AW42=\"\",\"\",SUM(AX42:BA42))","v":""},{"$f":"IF(OR($AJ42=\"\",$AO42<>\"Y\"),\"\",IF($AJ42=1,$AJ42,IF(OR($BB42=\"\",$AO42<>\"Y\"),$AJ42,IF(OR($BB42=0,$BB42=1),$AJ42-1,$AJ42))))","v":""},{"$f":"IFERROR(VLOOKUP($BC42,$N$10:$P$19,IF($S$16>1,\"3\",\"2\"),FALSE),\"0\")","v":"0"},0,"","",{"$f":"IF($BF42=\"\",\"\",COUNTIFS($BF$10:$BF$59,$BF42,$AT$10:$AT$59,\">\"&$AT42))","v":""},"","","",{"$f":"IF(OR($AJ42=\"\",$AO42<>\"Y\"),\"\",IF($AJ42=1,$AJ42,IF(OR($BK42=\"\",$AO42<>\"Y\"),$AJ42,IF(OR($BK42=0,$BK42=1),$AJ42-1,$AJ42))))","v":""},{"$f":"IFERROR(VLOOKUP($BL42,$N$10:$P$19,IF($S$16>1,\"3\",\"2\"),FALSE),\"0\")","v":"0"},0,"","",{"$f":"IF($BO42=\"\",\"\",COUNTIFS($BO$10:$BO$59,$BO42,$AV$10:$AV$59,\">\"&$AV42))","v":""},{"$f":"IF($BO42=\"\",\"\",COUNTIFS($BO$10:$BO$59,$BO42,$AV$10:$AV$59,$AV42,$AI$10:$AI$59,\">\"&$AI42))","v":""},"",{"$f":"IF(OR($AJ42=\"\",$AO42<>\"Y\"),\"\",IF($AJ42=1,$AJ42,IF(OR($BS42=\"\",$AO42<>\"Y\"),$AJ42,IF(OR($BS42=0,$BS42=1),$AJ42-1,$AJ42))))","v":""},{"$f":"IFERROR(VLOOKUP($BT42,$N$10:$P$19,IF($S$16>1,\"3\",\"2\"),FALSE),\"0\")","v":"0"},0]
[null,4,"d4",4,null,null,"0",4,0,"","d",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,{"$f":"IFERROR(VLOOKUP(AJ43,$N$10:$P$19,IF($S$16>1,\"3\",\"2\"),FALSE),\"0\")","v":"0"},{"$f":"ROW()-39","v":4},{"$f":"AL43*AK43","v":0},"","","","","","","","","","","","","","","","0",0,"","","","","","","","0",0,"","","","","","","0",0]
[null,5,"d5",4,null,null,"0",5,0,"","d",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,{"$f":"IFERROR(VLOOKUP(AJ44,$N$10:$P$19,IF($S$16>1,\"3\",\"2\"),FALSE),\"0\")","v":"0"},{"$f":"ROW()-39","v":5},{"$f":"AL44*AK44","v":0},"","","","","","","","","","","","","","","","0",0,"","","","","","","","0",0,"","","","","","","0",0]
[null,6,"d6",4,null,null,"0",6,0,"","d",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,{"$f":"IFERROR(VLOOKUP(AJ45,$N$10:$P$19,IF($S$16>1,\"3\",\"2\"),FALSE),\"0\")","v":"0"},{"$f":"ROW()-39","v":6},{"$f":"AL45*AK45","v":0},"","","","","","","","","","","","","","","","0",0,"","","","","","","","0",0,"","","","","","","0",0]
["진로선택A여부",7,"d7",4,null,null,"0",7,0,"","d",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,{"$f":"IFERROR(VLOOKUP(AJ46,$N$10:$P$19,IF($S$16>1,\"3\",\"2\"),FALSE),\"0\")","v":"0"},{"$f":"ROW()-39","v":7},{"$f":"AL46*AK46","v":0},"","","","","","","","","","","","","","","","0",0,"","","","","","","","0",0,"","","","","","","0",0]
[null,8,"d8",4,null,null,"0",8,0,"","d",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,{"$f":"IFERROR(VLOOKUP(AJ47,$N$10:$P$19,IF($S$16>1,\"3\",\"2\"),FALSE),\"0\")","v":"0"},{"$f":"ROW()-39","v":8},{"$f":"AL47*AK47","v":0},"","","","","","","","","","","","","","","","0",0,"","","","","","","","0",0,"","","","","","","0",0]
["없음",9,"d9",4,null,null,"0",9,0,"","d",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,{"$f":"IFERROR(VLOOKUP(AJ48,$N$10:$P$19,IF($S$16>1,\"3\",\"2\"),FALSE),\"0\")","v":"0"},{"$f":"ROW()-39","v":9},{"$f":"AL48*AK48","v":0},"","","","","","","","","","","","","","","","0",0,"","","","","","","","0",0,"","","","","","","0",0]
[null,10,"d10",4,null,null,"0",10,0,"","d",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,{"$f":"IFERROR(VLOOKUP(AJ49,$N$10:$P$19,IF($S$16>1,\"3\",\"2\"),FALSE),\"0\")","v":"0"},{"$f":"ROW()-39","v":10},{"$f":"AL49*AK49","v":0},"","","","","","","","","","","","","","","","0",0,"","","","","","","","0",0,"","","","","","","0",0]
["과학\n교과",1,"e1",5,null,null,"0",{"$f":"ROW()-49","v":1},0,"","e",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,{"$f":"IFERROR(VLOOKUP(AJ50,$N$10:$P$19,IF($S$16>1,\"3\",\"2\"),FALSE),\"0\")","v":"0"},{"$f":"ROW()-49","v":1},{"$f":"AL50*AK50","v":0},"","","","","","","","",{"$f":"IF(OR($AR50=\"\",$A$58<>\"있음\"),\"\",$AJ50)","v":""},"","","","","","","0",0,{"$f":"IF(OR($AT50=\"\",$A$58<>\"있음\"),\"\",$AJ50)","v":""},"","","","","","","0",0,{"$f":"IF(OR($AV50=\"\",$A$58<>\"있음\"),\"\",$AJ50)","v":""},"","","","","","0",0]
[null,2,"e2",5,null,null,"0",{"$f":"ROW()-49","v":2},0,"","e",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,{"$f":"IFERROR(VLOOKUP(AJ51,$N$10:$P$19,IF($S$16>1,\"3\",\"2\"),FALSE),\"0\")","v":"0"},{"$f":"ROW()-49","v":2},{"$f":"AL51*AK51","v":0},"","","","","","","","","","","","","","","","0",0,"","","","","","","","0",0,"","","","","","","0",0]
[null,3,"e3",5,null,null,"0",3,0,"","e",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,{"$f":"IFERROR(VLOOKUP(AJ52,$N$10:$P$19,IF($S$16>1,\"3\",\"2\"),FALSE),\"0\")","v":"0"},{"$f":"ROW()-49","v":3},{"$f":"AL52*AK52","v":0},"","","","","","","","","","","","","","","","0",0,"","","","","","","","0",0,"","","","","","","0",0]
[null,4,"e4",5,null,null,"0",4,0,"","e",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,{"$f":"IFERROR(VLOOKUP(AJ53,$N$10:$P$19,IF($S$16>1,\"3\",\"2\"),FALSE),\"0\")","v":"0"},{"$f":"ROW()-49","v":4},{"$f":"AL53*AK53","v":0},"","","","","","","","","","","","","","","","0",0,"","","","","","","","0",0,"","","","","","","0",0]
[null,5,"e5",5,null,null,"0",5,0,"","e",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,{"$f":"IFERROR(VLOOKUP(AJ54,$N$10:$P$19,IF($S$16>1,\"3\",\"2\"),FALSE),\"0\")","v":"0"},{"$f":"ROW()-49","v":5},{"$f":"AL54*AK54","v":0},"","","","","","","","","","","","","","","","0",0,"","","","","","","","0",0,"","","","","","","0",0]
[null,6,"e6",5,null,null,"0",6,0,"","e",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,{"$f":"IFERROR(VLOOKUP(AJ55,$N$10:$P$19,IF($S$16>1,\"3\",\"2\"),FALSE),\"0\")","v":"0"},{"$f":"ROW()-49","v":6},{"$f":"AL55*AK55","v":0},"","","","","","","","","","","","","","","","0",0,"","","","","","","","0",0,"","","","","","","0",0]
["진로선택A여부",7,"e7",5,null,null,"0",7,0,"","e",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,{"$f":"IFERROR(VLOOKUP(AJ56,$N$10:$P$19,IF($S$16>1,\"3\",\"2\"),FALSE),\"0\")","v":"0"},{"$f":"ROW()-49","v":7},{"$f":"AL56*AK56","v":0},"","","","","","","","","","","","","","","","0",0,"","","","","","","","0",0,"","","","","","","0",0]
[null,8,"e8",5,null,null,"0",8,0,"","e",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,{"$f":"IFERROR(VLOOKUP(AJ57,$N$10:$P$19,IF($S$16>1,\"3\",\"2\"),FALSE),\"0\")","v":"0"},{"$f":"ROW()-49","v":8},{"$f":"AL57*AK57","v":0},"","","","","","","","","","","","","","","","0",0,"","","","","","","","0",0,"","","","","","","0",0]
["없음",9,"e9",5,null,null,"0",9,0,"","e",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,{"$f":"IFERROR(VLOOKUP(AJ58,$N$10:$P$19,IF($S$16>1,\"3\",\"2\"),FALSE),\"0\")","v":"0"},{"$f":"ROW()-49","v":9},{"$f":"AL58*AK58","v":0},"","","","","","","","","","","","","","","","0",0,"","","","","","","","0",0,"","","","","","","0",0]
[null,10,"e10",5,null,null,"0",10,0,"","e",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,{"$f":"IFERROR(VLOOKUP(AJ59,$N$10:$P$19,IF($S$16>1,\"3\",\"2\"),FALSE),\"0\")","v":"0"},{"$f":"ROW()-49","v":10},{"$f":"AL59*AK59","v":0},"","","","","","","","","","","","","","","","0",0,"","","","","","","","0",0,"","","","","","","0",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,{"$f":"IFERROR(VLOOKUP(E6,$N$5:$P$14,IF($S$11>1,\"3\",\"2\"),FALSE),\"0\")","v":"0"},{"$f":"ROW()-9","v":-3},0,null,null,null,null,2,99.5]
[null,3,"a3",1,null,null,{"$f":"IFERROR(VLOOKUP(E7,$N$5:$P$14,IF($S$11>1,\"3\",\"2\"),FALSE),\"0\")","v":"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,"의예/한의예\n/약학",{"$f":"IFERROR($T$22,\"\")","v":""},{"$f":"IFERROR(X9*6,\"\")","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]