{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["성적일람표","계산"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"comments":2,"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":34,"n_cols":18,"rows_kept":34,"cut":false,"hidden":false,"merged":[[9,1,10,1],[9,17,10,17],[11,1,12,1],[11,17,12,17],[7,0,10,0],[11,0,14,0],[13,1,14,1],[13,17,14,17],[7,17,8,17],[7,1,8,1],[18,12,19,14],[18,15,19,17],[21,12,21,17],[22,0,24,1],[21,0,21,1],[22,6,24,6],[22,8,24,9],[21,8,21,11],[22,10,24,11],[22,2,24,4],[22,7,24,7],[21,2,21,4],[21,5,21,7],[22,12,27,17],[33,0,33,17],[26,8,26,9],[31,14,31,16],[25,10,27,11],[27,8,27,9],[31,6,31,7],[31,8,31,10],[31,1,31,2],[28,10,29,11],[28,7,29,7],[28,8,29,9],[28,5,29,6],[28,2,29,4],[25,8,25,9],[28,12,28,17],[31,12,31,13],[1,0,1,17],[5,0,5,2],[6,0,6,2],[3,3,3,8],[3,9,3,12],[3,13,3,17],[3,0,3,2],[5,17,6,17],[5,10,6,10],[5,3,6,3],[5,4,6,4],[5,5,6,5],[5,6,6,6],[5,15,6,15],[5,7,6,7],[5,8,6,8],[32,5,32,8],[28,0,29,1],[25,2,27,4],[25,0,27,1],[22,5,24,5],[29,12,29,17],[30,0,30,17],[5,9,6,9],[5,16,6,16],[5,11,6,11],[5,12,6,12],[5,13,6,13],[5,14,6,14],[15,0,16,0],[15,1,16,1],[15,17,16,17],[20,12,20,14],[17,0,19,0],[17,1,19,11],[17,12,17,14],[17,15,17,17]]}
[]
["개인 성적 일람표"]
[]
["1. 전형구분",null,null,"특별전형",null,null,null,null,null,"2. 지원구분",null,null,null,"졸업예정자"]
["3. 교과 성적 산출 "]
["          과목",null,null,"국어","도덕","사회","역사","수학","과학","기술가정","영어","한문","체육","미술","음악",null,null,"석차\n백분율\n평균"]
[" 학년    "]
["1\n학\n년","1학기","성취도",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(계산!R8=\"\",\"\",IF($D$4=\"일반전형\",계산!R8*2.25,계산!R8*1.35))","v":""}]
[null,null,"원점수"]
[null,"2학기","성취도",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(계산!R10=\"\",\"\",IF($D$4=\"일반전형\",계산!R10*2.25,계산!R10*1.35))","v":""}]
[null,null,"원점수"]
["2\n학\n년","1학기","성취도",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(계산!R12=\"\",\"\",IF($D$4=\"일반전형\",계산!R12*3,계산!R12*1.8))","v":""}]
[null,null,"원점수"]
[null,"2학기","성취도",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(계산!R14=\"\",\"\",IF($D$4=\"일반전형\",계산!R14*3,계산!R14*1.8))","v":""}]
[null,null,"원점수"]
["3\n학\n년","1학기","성취도",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(계산!R16=\"\",\"\",IF($D$4=\"일반전형\",계산!R16*4.5,계산!R16*2.7))","v":""}]
[null,null,"원점수"]
["유\n의\n사\n항","▷ [전형구분]을 반드시 항목에서 선택합니다.(직접입력금지)\n▷ [전형구분]에서 \"일반전형\",\"특별전형\"항목이 선택되지 않으면 점수계산이 되지 않습니다.\n▷ 교과목의 성취도를 선택하고 원점수를 입력합니다.(예체능은 성취도만)\n▷ 학기 중 미이수 교과목은 아무것도 입력하지 않습니다.[공란처리] \n▷ 표에 없는 교과목은 [음악]옆의 빈칸에 추가합니다.\n▷ 성취도, 원점수를 제외한 부분은 \"셀보호\"가 설정되어 있습니다.",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(계산!M19=\"\",\"\",IF(D4=\"일반전형\",계산!M19*2,계산!M19*1.2))","v":""},null,null,{"$f":"IF(AND(R8<>\"\",R10<>\"\",R12<>\"\",R14<>\"\",R16<>\"\"),SUM(R8:R17,M19),\"\")","v":""}]
[]
["4. 출결, 봉사활동, 특별활동, 자격증 점수 산출"]
["구  분",null,"내  용",null,null,"입 력",null,null,"점 수",null,null,null,"유의 사항"]
["출    결",null," 환산 결석 일수\n(무단)",null,null,"전학년",null,"일",{"$f":"IF(G23=\"\",\"\",IF(D4=\"일반전형\",IF(G23=\"\",\"\",IF(G23=0,20,IF(G23>=10,0,CHOOSE(G23,18,16,14,12,10,8,6,4,2)))),IF(D4=\"특별전형\",IF(G23=\"\",\"\",IF(G23=0,40,IF(G23>=10,0,CHOOSE(G23,36,32,28,24,20,16,12,8,4)))),\"\")))","v":""},null,{"$f":"IF(I23=\"\",\"\",SUM(I23:J25))","v":""},null,"\n▷ 개인별 성적일람표는 입학원서와 함께 제출해야 합니다.\n▷ 3학년 1학기 까지의 출결, 봉사활동은 점수로 산출합니다. [기준일 : 2014.08.31]\n▷ 무단으로 인한 지각, 조퇴, 결과는 이를 합산하여 3회를 무단결석 1일로 계산하며, 질병 기타로 인한 경우는 결석일수에 포함시키지 않습니다.\n▷ 동일 자격증은 최상위 자격증 1개만 인정합니다.\n▷ 출결에서 결석이 없는 경우 반드시 \"0\"을 입력하시기 바랍니다.\n▷ 자격증 가산점수가 없는 경우 반드시 \"0\"을 입력하시기 바랍니다.\n▷ 기타 전형요강을 참조하시어 입력바랍니다."]
[]
[]
["봉사활동",null,"봉사활동 시간",null,null,"1학년",null,"시간",{"$f":"IF(G26=\"\",\"\",IF(D4=\"일반전형\",IF(G26=\"\",2,IF(G26>=20,6,IF(G26>=16,5,IF(G26>=12,4,IF(G26>=8,3,2))))),IF(D4=\"특별전형\",IF(G26=\"\",6,IF(G26>=20,12,IF(G26>=16,10.5,IF(G26>=12,9,IF(G26>=8,7.5,6))))),\"\")))","v":""},null,{"$f":"IF(OR(I26=\"\",I27=\"\",I28=\"\"),\"\",SUM(I26:J28))","v":""}]
[null,null,null,null,null,"2학년",null,"시간",{"$f":"IF(G27=\"\",\"\",IF(D4=\"일반전형\",IF(G27=\"\",2,IF(G27>=20,6,IF(G27>=16,5,IF(G27>=12,4,IF(G27>=8,3,2))))),IF(D4=\"특별전형\",IF(G27=\"\",6,IF(G27>=20,12,IF(G27>=16,10.5,IF(G27>=12,9,IF(G27>=8,7.5,6))))),\"\")))","v":""}]
[null,null,null,null,null,"3학년",null,"시간",{"$f":"IF(G28=\"\",\"\",IF(D4=\"일반전형\",IF(G28=\"\",0,IF(G28>=10,4,IF(G28>=8,3,IF(G28>=6,2,IF(G28>=4,1,0))))),IF(D4=\"특별전형\",IF(G28=\"\",6,IF(G28>=10,12,IF(G28>=8,10.5,IF(G28>=6,9,IF(G28>=4,7.5,6))))),\"\")))","v":""}]
["자 격 증",null,"최상위 자격증을 \n점수로 입력",null,null,null,null,"점",null,null,{"$f":"IF(OR(F29=\"\",D4=\"\"),\"\",F29)","v":""},null,"총   점"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(P19=\"\",K23=\"\",K26=\"\",K29=\"\"),\"\",SUM(P19,K23,K26,K29))","v":""}]
["  상기 사항이 이상 없이 기록되었으며 상기 사항의 오류는 지원자 본인에게 있음을 확인합니다."]
[null,"2014년",null,"10월",null,"일","지원자",null,null,null,null,"(인),","작성 교사",null,null,null,null,"(인)"]
[null,null,null,null,null,null,null,null,null,"중 학 교 장 (직인)"]
["원주의료고등학교장  귀하"]

{"sheet":"계산","index":1,"n_rows":34,"n_cols":24,"rows_kept":34,"cut":false,"hidden":true,"merged":[[32,5,32,8],[33,0,33,17],[28,12,28,17],[29,12,29,17],[30,0,30,17],[31,1,31,2],[31,6,31,7],[31,8,31,10],[31,12,31,13],[31,14,31,16],[28,0,29,1],[28,2,29,4],[28,5,29,6],[28,7,29,7],[28,8,29,9],[28,10,29,11],[22,10,24,11],[22,12,27,17],[25,0,27,1],[25,2,27,4],[25,8,25,9],[25,10,27,11],[26,8,26,9],[27,8,27,9],[22,0,24,1],[22,2,24,4],[22,5,24,5],[22,6,24,6],[22,7,24,7],[22,8,24,9],[20,12,20,14],[21,0,21,1],[21,2,21,4],[21,5,21,7],[21,8,21,11],[21,12,21,17],[15,0,16,0],[15,1,16,1],[15,17,16,17],[17,0,19,0],[17,1,19,11],[17,12,17,14],[17,15,17,17],[18,12,19,14],[18,15,19,17],[5,17,6,17],[11,0,14,0],[11,1,12,1],[11,17,12,17],[13,1,14,1],[13,17,14,17],[7,0,10,0],[7,1,8,1],[7,17,8,17],[9,1,10,1],[9,17,10,17],[5,10,6,10],[5,13,6,13],[5,14,6,14],[5,15,6,15],[5,16,6,16],[5,11,6,11],[5,12,6,12],[1,0,1,17],[3,0,3,2],[3,3,3,8],[3,9,3,12],[3,13,3,17],[5,0,5,2],[5,3,6,3],[5,4,6,4],[5,5,6,5],[5,6,6,6],[6,0,6,2],[5,7,6,7],[5,8,6,8],[5,9,6,9]]}
[]
["개인 성적 일람표[계산]"]
[]
["1. 전형구분",null,null,"특별전형",null,null,null,null,null,"2. 지원구분",null,null,null,"졸업예정자"]
["3. 교과 성적 산출 "]
["          과목",null,null,"국어","도덕","사회","역사","수학","과학","기술가정","영어","한문","체육","미술","음악",null,null,"석차\n백분율\n평균"]
[" 학년    "]
["1\n학\n년","1학기","성취도",{"$f":"IF(성적일람표!D8=\"\",\"\",IF(성적일람표!D8=\"A\",5,IF(성적일람표!D8=\"B\",4,IF(성적일람표!D8=\"C\",3,IF(성적일람표!D8=\"D\",2,1)))))","v":""},{"$f":"IF(성적일람표!E8=\"\",\"\",IF(성적일람표!E8=\"A\",5,IF(성적일람표!E8=\"B\",4,IF(성적일람표!E8=\"C\",3,IF(성적일람표!E8=\"D\",2,1)))))","v":""},{"$f":"IF(성적일람표!F8=\"\",\"\",IF(성적일람표!F8=\"A\",5,IF(성적일람표!F8=\"B\",4,IF(성적일람표!F8=\"C\",3,IF(성적일람표!F8=\"D\",2,1)))))","v":""},{"$f":"IF(성적일람표!G8=\"\",\"\",IF(성적일람표!G8=\"A\",5,IF(성적일람표!G8=\"B\",4,IF(성적일람표!G8=\"C\",3,IF(성적일람표!G8=\"D\",2,1)))))","v":""},{"$f":"IF(성적일람표!H8=\"\",\"\",IF(성적일람표!H8=\"A\",10,IF(성적일람표!H8=\"B\",8,IF(성적일람표!H8=\"C\",6,IF(성적일람표!H8=\"D\",4,2)))))","v":""},{"$f":"IF(성적일람표!I8=\"\",\"\",IF(성적일람표!I8=\"A\",5,IF(성적일람표!I8=\"B\",4,IF(성적일람표!I8=\"C\",3,IF(성적일람표!I8=\"D\",2,1)))))","v":""},{"$f":"IF(성적일람표!J8=\"\",\"\",IF(성적일람표!J8=\"A\",10,IF(성적일람표!J8=\"B\",8,IF(성적일람표!J8=\"C\",6,IF(성적일람표!J8=\"D\",4,2)))))","v":""},{"$f":"IF(성적일람표!K8=\"\",\"\",IF(성적일람표!K8=\"A\",10,IF(성적일람표!K8=\"B\",8,IF(성적일람표!K8=\"C\",6,IF(성적일람표!K8=\"D\",4,2)))))","v":""},{"$f":"IF(성적일람표!L8=\"\",\"\",IF(성적일람표!L8=\"A\",5,IF(성적일람표!L8=\"B\",4,IF(성적일람표!L8=\"C\",3,IF(성적일람표!L8=\"D\",2,1)))))","v":""},{"$f":"IF(성적일람표!M8=\"\",\"\",IF(성적일람표!M8=\"A\",5,IF(성적일람표!M8=\"B\",4,IF(성적일람표!M8=\"C\",3,IF(성적일람표!M8=\"D\",2,1)))))","v":""},{"$f":"IF(성적일람표!N8=\"\",\"\",IF(성적일람표!N8=\"A\",5,IF(성적일람표!N8=\"B\",4,IF(성적일람표!N8=\"C\",3,IF(성적일람표!N8=\"D\",2,1)))))","v":""},{"$f":"IF(성적일람표!O8=\"\",\"\",IF(성적일람표!O8=\"A\",5,IF(성적일람표!O8=\"B\",4,IF(성적일람표!O8=\"C\",3,IF(성적일람표!O8=\"D\",2,1)))))","v":""},{"$f":"IF(성적일람표!P8=\"\",\"\",IF(성적일람표!P8=\"A\",5,IF(성적일람표!P8=\"B\",4,IF(성적일람표!P8=\"C\",3,IF(성적일람표!P8=\"D\",2,1)))))","v":""},{"$f":"IF(성적일람표!Q8=\"\",\"\",IF(성적일람표!Q8=\"A\",5,IF(성적일람표!Q8=\"B\",4,IF(성적일람표!Q8=\"C\",3,IF(성적일람표!Q8=\"D\",2,1)))))","v":""},{"$f":"IF(T9=0,\"\",SUM(D8:L8,P8:Q8)/T9+(SUM(D9:L9,P9:Q9)/T9)*0.01)","v":""},{"$f":"COUNT(D8:L8,P8:Q8,H8,J8:K8)","v":0}]
[null,null,"원점수",{"$f":"IF(성적일람표!D9=\"\",\"\",SUM(성적일람표!D9))","v":""},{"$f":"IF(성적일람표!E9=\"\",\"\",SUM(성적일람표!E9))","v":""},{"$f":"IF(성적일람표!F9=\"\",\"\",SUM(성적일람표!F9))","v":""},{"$f":"IF(성적일람표!G9=\"\",\"\",SUM(성적일람표!G9))","v":""},{"$f":"IF(성적일람표!H9=\"\",\"\",SUM(성적일람표!H9)*2)","v":""},{"$f":"IF(성적일람표!I9=\"\",\"\",SUM(성적일람표!I9))","v":""},{"$f":"IF(성적일람표!J9=\"\",\"\",SUM(성적일람표!J9)*2)","v":""},{"$f":"IF(성적일람표!K9=\"\",\"\",SUM(성적일람표!K9)*2)","v":""},{"$f":"IF(성적일람표!L9=\"\",\"\",SUM(성적일람표!L9))","v":""},null,{"$f":"SUM(M8:O8)","v":0},{"$f":"SUM(V9:X9)","v":0},{"$f":"IF(성적일람표!P9=\"\",\"\",SUM(성적일람표!P9))","v":""},{"$f":"IF(성적일람표!Q9=\"\",\"\",SUM(성적일람표!Q9))","v":""},null,{"$f":"COUNT(D9:L9,P9:Q9,H9,J9:K9)","v":0},{"$f":"IF(S8=S9,S8,\"error\")","v":0},null,{"$f":"IF(COUNT(M8)=1,1,\"\")","v":""},{"$f":"IF(COUNT(N8)=1,1,\"\")","v":""},{"$f":"IF(COUNT(O8)=1,1,\"\")","v":""}]
[null,"2학기","성취도",{"$f":"IF(성적일람표!D10=\"\",\"\",IF(성적일람표!D10=\"A\",5,IF(성적일람표!D10=\"B\",4,IF(성적일람표!D10=\"C\",3,IF(성적일람표!D10=\"D\",2,1)))))","v":""},{"$f":"IF(성적일람표!E10=\"\",\"\",IF(성적일람표!E10=\"A\",5,IF(성적일람표!E10=\"B\",4,IF(성적일람표!E10=\"C\",3,IF(성적일람표!E10=\"D\",2,1)))))","v":""},{"$f":"IF(성적일람표!F10=\"\",\"\",IF(성적일람표!F10=\"A\",5,IF(성적일람표!F10=\"B\",4,IF(성적일람표!F10=\"C\",3,IF(성적일람표!F10=\"D\",2,1)))))","v":""},{"$f":"IF(성적일람표!G10=\"\",\"\",IF(성적일람표!G10=\"A\",5,IF(성적일람표!G10=\"B\",4,IF(성적일람표!G10=\"C\",3,IF(성적일람표!G10=\"D\",2,1)))))","v":""},{"$f":"IF(성적일람표!H10=\"\",\"\",IF(성적일람표!H10=\"A\",10,IF(성적일람표!H10=\"B\",8,IF(성적일람표!H10=\"C\",6,IF(성적일람표!H10=\"D\",4,2)))))","v":""},{"$f":"IF(성적일람표!I10=\"\",\"\",IF(성적일람표!I10=\"A\",5,IF(성적일람표!I10=\"B\",4,IF(성적일람표!I10=\"C\",3,IF(성적일람표!I10=\"D\",2,1)))))","v":""},{"$f":"IF(성적일람표!J10=\"\",\"\",IF(성적일람표!J10=\"A\",10,IF(성적일람표!J10=\"B\",8,IF(성적일람표!J10=\"C\",6,IF(성적일람표!J10=\"D\",4,2)))))","v":""},{"$f":"IF(성적일람표!K10=\"\",\"\",IF(성적일람표!K10=\"A\",10,IF(성적일람표!K10=\"B\",8,IF(성적일람표!K10=\"C\",6,IF(성적일람표!K10=\"D\",4,2)))))","v":""},{"$f":"IF(성적일람표!L10=\"\",\"\",IF(성적일람표!L10=\"A\",5,IF(성적일람표!L10=\"B\",4,IF(성적일람표!L10=\"C\",3,IF(성적일람표!L10=\"D\",2,1)))))","v":""},{"$f":"IF(성적일람표!M10=\"\",\"\",IF(성적일람표!M10=\"A\",5,IF(성적일람표!M10=\"B\",4,IF(성적일람표!M10=\"C\",3,IF(성적일람표!M10=\"D\",2,1)))))","v":""},{"$f":"IF(성적일람표!N10=\"\",\"\",IF(성적일람표!N10=\"A\",5,IF(성적일람표!N10=\"B\",4,IF(성적일람표!N10=\"C\",3,IF(성적일람표!N10=\"D\",2,1)))))","v":""},{"$f":"IF(성적일람표!O10=\"\",\"\",IF(성적일람표!O10=\"A\",5,IF(성적일람표!O10=\"B\",4,IF(성적일람표!O10=\"C\",3,IF(성적일람표!O10=\"D\",2,1)))))","v":""},{"$f":"IF(성적일람표!P10=\"\",\"\",IF(성적일람표!P10=\"A\",5,IF(성적일람표!P10=\"B\",4,IF(성적일람표!P10=\"C\",3,IF(성적일람표!P10=\"D\",2,1)))))","v":""},{"$f":"IF(성적일람표!Q10=\"\",\"\",IF(성적일람표!Q10=\"A\",5,IF(성적일람표!Q10=\"B\",4,IF(성적일람표!Q10=\"C\",3,IF(성적일람표!Q10=\"D\",2,1)))))","v":""},{"$f":"IF(T11=0,\"\",SUM(D10:L10,P10:Q10)/T11+(SUM(D11:L11,P11:Q11)/T11)*0.01)","v":""},{"$f":"COUNT(D10:L10,P10:Q10)","v":0}]
[null,null,"원점수",{"$f":"IF(성적일람표!D11=\"\",\"\",SUM(성적일람표!D11))","v":""},{"$f":"IF(성적일람표!E11=\"\",\"\",SUM(성적일람표!E11))","v":""},{"$f":"IF(성적일람표!F11=\"\",\"\",SUM(성적일람표!F11))","v":""},{"$f":"IF(성적일람표!G11=\"\",\"\",SUM(성적일람표!G11))","v":""},{"$f":"IF(성적일람표!H11=\"\",\"\",SUM(성적일람표!H11)*2)","v":""},{"$f":"IF(성적일람표!I11=\"\",\"\",SUM(성적일람표!I11))","v":""},{"$f":"IF(성적일람표!J11=\"\",\"\",SUM(성적일람표!J11)*2)","v":""},{"$f":"IF(성적일람표!K11=\"\",\"\",SUM(성적일람표!K11)*2)","v":""},{"$f":"IF(성적일람표!L11=\"\",\"\",SUM(성적일람표!L11))","v":""},null,{"$f":"SUM(M10:O10)","v":0},{"$f":"SUM(V11:X11)","v":0},{"$f":"IF(성적일람표!P11=\"\",\"\",SUM(성적일람표!P11))","v":""},{"$f":"IF(성적일람표!Q11=\"\",\"\",SUM(성적일람표!Q11))","v":""},null,0,{"$f":"IF(S10=S11,S10,\"error\")","v":0},null,{"$f":"IF(COUNT(M10)=1,1,\"\")","v":""},{"$f":"IF(COUNT(N10)=1,1,\"\")","v":""},{"$f":"IF(COUNT(O10)=1,1,\"\")","v":""}]
["2\n학\n년","1학기","성취도",{"$f":"IF(성적일람표!D12=\"\",\"\",IF(성적일람표!D12=\"A\",5,IF(성적일람표!D12=\"B\",4,IF(성적일람표!D12=\"C\",3,IF(성적일람표!D12=\"D\",2,1)))))","v":""},{"$f":"IF(성적일람표!E12=\"\",\"\",IF(성적일람표!E12=\"A\",5,IF(성적일람표!E12=\"B\",4,IF(성적일람표!E12=\"C\",3,IF(성적일람표!E12=\"D\",2,1)))))","v":""},{"$f":"IF(성적일람표!F12=\"\",\"\",IF(성적일람표!F12=\"A\",5,IF(성적일람표!F12=\"B\",4,IF(성적일람표!F12=\"C\",3,IF(성적일람표!F12=\"D\",2,1)))))","v":""},{"$f":"IF(성적일람표!G12=\"\",\"\",IF(성적일람표!G12=\"A\",5,IF(성적일람표!G12=\"B\",4,IF(성적일람표!G12=\"C\",3,IF(성적일람표!G12=\"D\",2,1)))))","v":""},{"$f":"IF(성적일람표!H12=\"\",\"\",IF(성적일람표!H12=\"A\",10,IF(성적일람표!H12=\"B\",8,IF(성적일람표!H12=\"C\",6,IF(성적일람표!H12=\"D\",4,2)))))","v":""},{"$f":"IF(성적일람표!I12=\"\",\"\",IF(성적일람표!I12=\"A\",5,IF(성적일람표!I12=\"B\",4,IF(성적일람표!I12=\"C\",3,IF(성적일람표!I12=\"D\",2,1)))))","v":""},{"$f":"IF(성적일람표!J12=\"\",\"\",IF(성적일람표!J12=\"A\",10,IF(성적일람표!J12=\"B\",8,IF(성적일람표!J12=\"C\",6,IF(성적일람표!J12=\"D\",4,2)))))","v":""},{"$f":"IF(성적일람표!K12=\"\",\"\",IF(성적일람표!K12=\"A\",10,IF(성적일람표!K12=\"B\",8,IF(성적일람표!K12=\"C\",6,IF(성적일람표!K12=\"D\",4,2)))))","v":""},{"$f":"IF(성적일람표!L12=\"\",\"\",IF(성적일람표!L12=\"A\",5,IF(성적일람표!L12=\"B\",4,IF(성적일람표!L12=\"C\",3,IF(성적일람표!L12=\"D\",2,1)))))","v":""},{"$f":"IF(성적일람표!M12=\"\",\"\",IF(성적일람표!M12=\"A\",5,IF(성적일람표!M12=\"B\",4,IF(성적일람표!M12=\"C\",3,IF(성적일람표!M12=\"D\",2,1)))))","v":""},{"$f":"IF(성적일람표!N12=\"\",\"\",IF(성적일람표!N12=\"A\",5,IF(성적일람표!N12=\"B\",4,IF(성적일람표!N12=\"C\",3,IF(성적일람표!N12=\"D\",2,1)))))","v":""},{"$f":"IF(성적일람표!O12=\"\",\"\",IF(성적일람표!O12=\"A\",5,IF(성적일람표!O12=\"B\",4,IF(성적일람표!O12=\"C\",3,IF(성적일람표!O12=\"D\",2,1)))))","v":""},{"$f":"IF(성적일람표!P12=\"\",\"\",IF(성적일람표!P12=\"A\",5,IF(성적일람표!P12=\"B\",4,IF(성적일람표!P12=\"C\",3,IF(성적일람표!P12=\"D\",2,1)))))","v":""},{"$f":"IF(성적일람표!Q12=\"\",\"\",IF(성적일람표!Q12=\"A\",5,IF(성적일람표!Q12=\"B\",4,IF(성적일람표!Q12=\"C\",3,IF(성적일람표!Q12=\"D\",2,1)))))","v":""},{"$f":"IF(T13=0,\"\",SUM(D12:L12,P12:Q12)/T13+(SUM(D13:L13,P13:Q13)/T13)*0.01)","v":""},0]
[null,null,"원점수",{"$f":"IF(성적일람표!D13=\"\",\"\",SUM(성적일람표!D13))","v":""},{"$f":"IF(성적일람표!E13=\"\",\"\",SUM(성적일람표!E13))","v":""},{"$f":"IF(성적일람표!F13=\"\",\"\",SUM(성적일람표!F13))","v":""},{"$f":"IF(성적일람표!G13=\"\",\"\",SUM(성적일람표!G13))","v":""},{"$f":"IF(성적일람표!H13=\"\",\"\",SUM(성적일람표!H13)*2)","v":""},{"$f":"IF(성적일람표!I13=\"\",\"\",SUM(성적일람표!I13))","v":""},{"$f":"IF(성적일람표!J13=\"\",\"\",SUM(성적일람표!J13)*2)","v":""},{"$f":"IF(성적일람표!K13=\"\",\"\",SUM(성적일람표!K13)*2)","v":""},{"$f":"IF(성적일람표!L13=\"\",\"\",SUM(성적일람표!L13))","v":""},null,{"$f":"SUM(M12:O12)","v":0},{"$f":"SUM(V13:X13)","v":0},{"$f":"IF(성적일람표!P13=\"\",\"\",SUM(성적일람표!P13))","v":""},{"$f":"IF(성적일람표!Q13=\"\",\"\",SUM(성적일람표!Q13))","v":""},null,0,{"$f":"IF(S12=S13,S12,\"error\")","v":0},null,{"$f":"IF(COUNT(M12)=1,1,\"\")","v":""},{"$f":"IF(COUNT(N12)=1,1,\"\")","v":""},{"$f":"IF(COUNT(O12)=1,1,\"\")","v":""}]
[null,"2학기","성취도",{"$f":"IF(성적일람표!D14=\"\",\"\",IF(성적일람표!D14=\"A\",5,IF(성적일람표!D14=\"B\",4,IF(성적일람표!D14=\"C\",3,IF(성적일람표!D14=\"D\",2,1)))))","v":""},{"$f":"IF(성적일람표!E14=\"\",\"\",IF(성적일람표!E14=\"A\",5,IF(성적일람표!E14=\"B\",4,IF(성적일람표!E14=\"C\",3,IF(성적일람표!E14=\"D\",2,1)))))","v":""},{"$f":"IF(성적일람표!F14=\"\",\"\",IF(성적일람표!F14=\"A\",5,IF(성적일람표!F14=\"B\",4,IF(성적일람표!F14=\"C\",3,IF(성적일람표!F14=\"D\",2,1)))))","v":""},{"$f":"IF(성적일람표!G14=\"\",\"\",IF(성적일람표!G14=\"A\",5,IF(성적일람표!G14=\"B\",4,IF(성적일람표!G14=\"C\",3,IF(성적일람표!G14=\"D\",2,1)))))","v":""},{"$f":"IF(성적일람표!H14=\"\",\"\",IF(성적일람표!H14=\"A\",10,IF(성적일람표!H14=\"B\",8,IF(성적일람표!H14=\"C\",6,IF(성적일람표!H14=\"D\",4,2)))))","v":""},{"$f":"IF(성적일람표!I14=\"\",\"\",IF(성적일람표!I14=\"A\",5,IF(성적일람표!I14=\"B\",4,IF(성적일람표!I14=\"C\",3,IF(성적일람표!I14=\"D\",2,1)))))","v":""},{"$f":"IF(성적일람표!J14=\"\",\"\",IF(성적일람표!J14=\"A\",10,IF(성적일람표!J14=\"B\",8,IF(성적일람표!J14=\"C\",6,IF(성적일람표!J14=\"D\",4,2)))))","v":""},{"$f":"IF(성적일람표!K14=\"\",\"\",IF(성적일람표!K14=\"A\",10,IF(성적일람표!K14=\"B\",8,IF(성적일람표!K14=\"C\",6,IF(성적일람표!K14=\"D\",4,2)))))","v":""},{"$f":"IF(성적일람표!L14=\"\",\"\",IF(성적일람표!L14=\"A\",5,IF(성적일람표!L14=\"B\",4,IF(성적일람표!L14=\"C\",3,IF(성적일람표!L14=\"D\",2,1)))))","v":""},{"$f":"IF(성적일람표!M14=\"\",\"\",IF(성적일람표!M14=\"A\",5,IF(성적일람표!M14=\"B\",4,IF(성적일람표!M14=\"C\",3,IF(성적일람표!M14=\"D\",2,1)))))","v":""},{"$f":"IF(성적일람표!N14=\"\",\"\",IF(성적일람표!N14=\"A\",5,IF(성적일람표!N14=\"B\",4,IF(성적일람표!N14=\"C\",3,IF(성적일람표!N14=\"D\",2,1)))))","v":""},{"$f":"IF(성적일람표!O14=\"\",\"\",IF(성적일람표!O14=\"A\",5,IF(성적일람표!O14=\"B\",4,IF(성적일람표!O14=\"C\",3,IF(성적일람표!O14=\"D\",2,1)))))","v":""},{"$f":"IF(성적일람표!P14=\"\",\"\",IF(성적일람표!P14=\"A\",5,IF(성적일람표!P14=\"B\",4,IF(성적일람표!P14=\"C\",3,IF(성적일람표!P14=\"D\",2,1)))))","v":""},{"$f":"IF(성적일람표!Q14=\"\",\"\",IF(성적일람표!Q14=\"A\",5,IF(성적일람표!Q14=\"B\",4,IF(성적일람표!Q14=\"C\",3,IF(성적일람표!Q14=\"D\",2,1)))))","v":""},{"$f":"IF(T15=0,\"\",SUM(D14:L14,P14:Q14)/T15+(SUM(D15:L15,P15:Q15)/T15)*0.01)","v":""},0]
[null,null,"원점수",{"$f":"IF(성적일람표!D15=\"\",\"\",SUM(성적일람표!D15))","v":""},{"$f":"IF(성적일람표!E15=\"\",\"\",SUM(성적일람표!E15))","v":""},{"$f":"IF(성적일람표!F15=\"\",\"\",SUM(성적일람표!F15))","v":""},{"$f":"IF(성적일람표!G15=\"\",\"\",SUM(성적일람표!G15))","v":""},{"$f":"IF(성적일람표!H15=\"\",\"\",SUM(성적일람표!H15)*2)","v":""},{"$f":"IF(성적일람표!I15=\"\",\"\",SUM(성적일람표!I15))","v":""},{"$f":"IF(성적일람표!J15=\"\",\"\",SUM(성적일람표!J15)*2)","v":""},{"$f":"IF(성적일람표!K15=\"\",\"\",SUM(성적일람표!K15)*2)","v":""},{"$f":"IF(성적일람표!L15=\"\",\"\",SUM(성적일람표!L15))","v":""},null,{"$f":"SUM(M14:O14)","v":0},{"$f":"SUM(V15:X15)","v":0},{"$f":"IF(성적일람표!P15=\"\",\"\",SUM(성적일람표!P15))","v":""},{"$f":"IF(성적일람표!Q15=\"\",\"\",SUM(성적일람표!Q15))","v":""},null,0,{"$f":"IF(S14=S15,S14,\"error\")","v":0},null,{"$f":"IF(COUNT(M14)=1,1,\"\")","v":""},{"$f":"IF(COUNT(N14)=1,1,\"\")","v":""},{"$f":"IF(COUNT(O14)=1,1,\"\")","v":""}]
["3\n학\n년","1학기","성취도",{"$f":"IF(성적일람표!D16=\"\",\"\",IF(성적일람표!D16=\"A\",5,IF(성적일람표!D16=\"B\",4,IF(성적일람표!D16=\"C\",3,IF(성적일람표!D16=\"D\",2,1)))))","v":""},{"$f":"IF(성적일람표!E16=\"\",\"\",IF(성적일람표!E16=\"A\",5,IF(성적일람표!E16=\"B\",4,IF(성적일람표!E16=\"C\",3,IF(성적일람표!E16=\"D\",2,1)))))","v":""},{"$f":"IF(성적일람표!F16=\"\",\"\",IF(성적일람표!F16=\"A\",5,IF(성적일람표!F16=\"B\",4,IF(성적일람표!F16=\"C\",3,IF(성적일람표!F16=\"D\",2,1)))))","v":""},{"$f":"IF(성적일람표!G16=\"\",\"\",IF(성적일람표!G16=\"A\",5,IF(성적일람표!G16=\"B\",4,IF(성적일람표!G16=\"C\",3,IF(성적일람표!G16=\"D\",2,1)))))","v":""},{"$f":"IF(성적일람표!H16=\"\",\"\",IF(성적일람표!H16=\"A\",10,IF(성적일람표!H16=\"B\",8,IF(성적일람표!H16=\"C\",6,IF(성적일람표!H16=\"D\",4,2)))))","v":""},{"$f":"IF(성적일람표!I16=\"\",\"\",IF(성적일람표!I16=\"A\",5,IF(성적일람표!I16=\"B\",4,IF(성적일람표!I16=\"C\",3,IF(성적일람표!I16=\"D\",2,1)))))","v":""},{"$f":"IF(성적일람표!J16=\"\",\"\",IF(성적일람표!J16=\"A\",10,IF(성적일람표!J16=\"B\",8,IF(성적일람표!J16=\"C\",6,IF(성적일람표!J16=\"D\",4,2)))))","v":""},{"$f":"IF(성적일람표!K16=\"\",\"\",IF(성적일람표!K16=\"A\",10,IF(성적일람표!K16=\"B\",8,IF(성적일람표!K16=\"C\",6,IF(성적일람표!K16=\"D\",4,2)))))","v":""},{"$f":"IF(성적일람표!L16=\"\",\"\",IF(성적일람표!L16=\"A\",5,IF(성적일람표!L16=\"B\",4,IF(성적일람표!L16=\"C\",3,IF(성적일람표!L16=\"D\",2,1)))))","v":""},{"$f":"IF(성적일람표!M16=\"\",\"\",IF(성적일람표!M16=\"A\",5,IF(성적일람표!M16=\"B\",4,IF(성적일람표!M16=\"C\",3,IF(성적일람표!M16=\"D\",2,1)))))","v":""},{"$f":"IF(성적일람표!N16=\"\",\"\",IF(성적일람표!N16=\"A\",5,IF(성적일람표!N16=\"B\",4,IF(성적일람표!N16=\"C\",3,IF(성적일람표!N16=\"D\",2,1)))))","v":""},{"$f":"IF(성적일람표!O16=\"\",\"\",IF(성적일람표!O16=\"A\",5,IF(성적일람표!O16=\"B\",4,IF(성적일람표!O16=\"C\",3,IF(성적일람표!O16=\"D\",2,1)))))","v":""},{"$f":"IF(성적일람표!P16=\"\",\"\",IF(성적일람표!P16=\"A\",5,IF(성적일람표!P16=\"B\",4,IF(성적일람표!P16=\"C\",3,IF(성적일람표!P16=\"D\",2,1)))))","v":""},{"$f":"IF(성적일람표!Q16=\"\",\"\",IF(성적일람표!Q16=\"A\",5,IF(성적일람표!Q16=\"B\",4,IF(성적일람표!Q16=\"C\",3,IF(성적일람표!Q16=\"D\",2,1)))))","v":""},{"$f":"IF(T17=0,\"\",SUM(D16:L16,P16:Q16)/T17+(SUM(D17:L17,P17:Q17)/T17)*0.01)","v":""},0]
[null,null,"원점수",{"$f":"IF(성적일람표!D17=\"\",\"\",SUM(성적일람표!D17))","v":""},{"$f":"IF(성적일람표!E17=\"\",\"\",SUM(성적일람표!E17))","v":""},{"$f":"IF(성적일람표!F17=\"\",\"\",SUM(성적일람표!F17))","v":""},{"$f":"IF(성적일람표!G17=\"\",\"\",SUM(성적일람표!G17))","v":""},{"$f":"IF(성적일람표!H17=\"\",\"\",SUM(성적일람표!H17)*2)","v":""},{"$f":"IF(성적일람표!I17=\"\",\"\",SUM(성적일람표!I17))","v":""},{"$f":"IF(성적일람표!J17=\"\",\"\",SUM(성적일람표!J17)*2)","v":""},{"$f":"IF(성적일람표!K17=\"\",\"\",SUM(성적일람표!K17)*2)","v":""},{"$f":"IF(성적일람표!L17=\"\",\"\",SUM(성적일람표!L17))","v":""},null,{"$f":"SUM(M16:O16)","v":0},{"$f":"SUM(V17:X17)","v":0},{"$f":"IF(성적일람표!P17=\"\",\"\",SUM(성적일람표!P17))","v":""},{"$f":"IF(성적일람표!Q17=\"\",\"\",SUM(성적일람표!Q17))","v":""},null,0,{"$f":"IF(S16=S17,S16,\"error\")","v":0},null,{"$f":"IF(COUNT(M16)=1,1,\"\")","v":""},{"$f":"IF(COUNT(N16)=1,1,\"\")","v":""},{"$f":"IF(COUNT(O16)=1,1,\"\")","v":""}]
["유\n의\n사\n항","▷ [전형구분]과 [지원구분]은 반드시 항목에서 선택합니다.(직접입력금지)\n▷ [전형구분]에서 \"일반전형\",\"특별전형\"항목이 선택되지 않으면 점수계산이 되지 않습니다.\n▷ 체육, 미술, 음악 교과는 [우수],[보통],[미흡]중에서 선택합니다.\n   (재적수는 입력하지 않습니다.) \n▷ 졸업생도 3학년 1학기 성적까지만 기록합니다.\n▷ 석차와 재적수는 숫자로 입력합니다.(동석차 무시)\n▷ 과목명, 석차, 재적수를 제외한 부분은 \"셀보호\"가 설정되어 있습니다.",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(AND(O9=0,O11=0,O13=0,O15=0,O17=0),\"\",SUM(N9,N11,N13,N15,N17)/SUM(O9,O11,O13,O15,O17))","v":""},null,null,{"$f":"SUM(R8:R17,M19)","v":0}]
[]
["4. 출결, 봉사활동, 특별활동, 자격증 점수 산출"]
["구  분",null,"내  용",null,null,"입 력",null,null,"점 수",null,null,null,"유의 사항"]
["출    결",null," 환산 결석 일수\n(무단)",null,null,"전학년",null,"일",{"$f":"IF(G23=\"\",\"\",IF(D4=\"일반전형\",IF(G23=\"\",\"\",IF(G23=0,20,IF(G23>=10,0,CHOOSE(G23,18,16,14,12,10,8,6,4,2)))),IF(D4=\"특별전형\",IF(G23=\"\",\"\",IF(G23=0,40,IF(G23>=10,0,CHOOSE(G23,36,32,28,24,20,16,12,8,4)))),\"\")))","v":""},null,{"$f":"IF(I23=\"\",\"\",SUM(I23:J25))","v":""},null,"\n▷ 개인별 성적일람표는 입학원서와 함께 제출해야 합니다.\n▷ 3학년 1학기 까지의 출결, 봉사활동은 점수로 산출합니다. [기준일 : 2014.08.31]\n▷ 무단으로 인한 지각, 조퇴, 결과는 이를 합산하여 3회를 무단결석 1일로 계산하며, 질병 기타로 인한 경우는 결석일수에 포함시키지 않습니다.\n▷ 동일 자격증은 최상위 자격증 1개만 인정합니다.\n▷ 출결에서 결석이 없는 경우 반드시 \"0\"을 입력하시기 바랍니다.\n▷ 기타 전형요강을 참조하시어 입력바랍니다."]
[]
[]
["봉사활동",null,"봉사활동 시간",null,null,"1학년",null,"시간",{"$f":"IF(G26=\"\",\"\",IF(D4=\"일반전형\",IF(G26=\"\",2,IF(G26>=20,6,IF(G26>=16,5,IF(G26>=12,4,IF(G26>=8,3,2))))),IF(D4=\"특별전형\",IF(G26=\"\",6,IF(G26>=20,12,IF(G26>=16,10.5,IF(G26>=12,9,IF(G26>=8,7.5,6))))),\"\")))","v":""},null,{"$f":"IF(OR(I26=\"\",I27=\"\",I28=\"\"),\"\",SUM(I26:J28))","v":""}]
[null,null,null,null,null,"2학년",null,"시간",{"$f":"IF(G27=\"\",\"\",IF(D4=\"일반전형\",IF(G27=\"\",2,IF(G27>=20,6,IF(G27>=16,5,IF(G27>=12,4,IF(G27>=8,3,2))))),IF(D4=\"특별전형\",IF(G27=\"\",6,IF(G27>=20,12,IF(G27>=16,10.5,IF(G27>=12,9,IF(G27>=8,7.5,6))))),\"\")))","v":""}]
[null,null,null,null,null,"3학년",null,"시간",{"$f":"IF(G28=\"\",\"\",IF(D4=\"일반전형\",IF(G28=\"\",0,IF(G28>=10,4,IF(G28>=8,3,IF(G28>=6,2,IF(G28>=4,1,0))))),IF(D4=\"특별전형\",IF(G28=\"\",6,IF(G28>=10,12,IF(G28>=8,10.5,IF(G28>=6,9,IF(G28>=4,7.5,6))))),\"\")))","v":""}]
["자 격 증",null,"최상위 자격증을 \n점수로 입력",null,null,null,null,"점",null,null,{"$f":"IF(OR(F29=\"\",D4=\"\"),\"\",F29)","v":""},null,"총   점"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(M19=\"\",K23=\"\",K26=\"\",K29=\"\"),\"\",SUM($M$19,$K$23,$K$26,$K$29,))","v":""}]
["  상기 사항이 이상 없이 기록되었으며 상기 사항의 오류는 지원자 본인에게 있음을 확인합니다."]
[null,"2014년",null,"10월",null,"일","지원자",null,null,null,null,"(인),","작성 교사",null,null,null,null,"(인)"]
[null,null,null,null,null,null,null,null,null,"중 학 교 장 (직인)"]
["원주의료고등학교장  귀하"]