{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["설명서","1점단위배점","배점1~4안","문항번호","배점5~8안","비율1~4안","비율5~8안"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":14,"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":16,"n_cols":13,"rows_kept":16,"cut":false,"hidden":false,"merged":[[12,2,12,16],[13,2,13,16],[14,2,14,16],[15,2,15,10],[15,12,15,16],[11,2,11,16],[2,2,2,16],[3,2,3,16],[4,2,4,16],[6,2,6,16],[7,2,7,16],[8,2,8,16],[9,2,9,16],[10,2,10,16],[5,2,5,10]]}
[]
[]
[null,null,"점수 배점 검토"]
[]
[]
[null,null,"예시 탭을 참고하시고, 입력 탭에 입력하시면 됩니다."]
[]
[null,null,"난이도와 점수 두가지를 입력합니다."]
[]
[null,null,"난이도 입력(숫자1,2,3)  /  결과(하,중,상)     -    상단의 % 참고"]
[]
[null,null,"점수는 여러칸을 선택후 숫자를 적은 후 (Ctrl + 엔터)를 누르면"]
[null,null,"여러칸에 동일한 내용을 입력할 수 있습니다."]
[]
[null,null,"100점 과부족과 역배점은 빨간색으로 표시됩니다."]
[null,null,null,null,null,null,null,null,null,null,null,null,"https://withseok.tistory.com/263?category=830379"]

{"sheet":"1점단위배점","index":1,"n_rows":45,"n_cols":32,"rows_kept":45,"cut":false,"hidden":false,"merged":[[34,30,34,31],[35,30,35,31],[28,30,28,31],[29,30,29,31],[30,30,30,31],[31,30,31,31],[32,30,32,31],[33,30,33,31],[22,30,22,31],[23,30,23,31],[24,30,24,31],[25,30,25,31],[26,30,26,31],[27,30,27,31],[16,30,16,31],[17,30,17,31],[18,30,18,31],[19,30,19,31],[20,30,20,31],[21,30,21,31],[10,30,10,31],[11,30,11,31],[12,30,12,31],[13,30,13,31],[14,30,14,31],[15,30,15,31],[3,30,3,31],[4,3,4,4],[4,10,4,11],[4,17,4,18],[4,24,4,25],[9,30,9,31]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"zcrong"]
[null,null,"만점",100,null,null,null,null,null,"만점",100,null,null,null,null,null,"만점",100,null,null,null,null,null,"만점"]
[null,null,"배점",{"$f":"SUM(F6:F45)","v":100},{"$f":"IF(D3<D2,\"부족\",IF(D3>D2,\"과함\",IF(D3=D2,\"OK\",\"오류\")))","v":"OK"},null,"하",{"$f":"COUNTIF(E$6:E$45,G3)&\"개 (\"&ROUND(COUNTIF(E$6:E$45,G3)/(40-COUNTBLANK(E$6:E$45))*100,0)&\"%)\"","v":"5개 (29%)"},null,{"$f":"C3","v":"배점"},{"$f":"SUM(M6:M45)","v":100},{"$f":"IF(K3<K2,\"부족\",IF(K3>K2,\"과함\",IF(K3=K2,\"OK\",\"오류\")))","v":"OK"},null,"하",{"$f":"COUNTIF(L$6:L$45,N3)&\"개 (\"&ROUND(COUNTIF(L$6:L$45,N3)/(40-COUNTBLANK(L$6:L$45))*100,0)&\"%)\"","v":"9개 (50%)"},null,{"$f":"C3","v":"배점"},{"$f":"SUM(T6:T45)","v":100},{"$f":"IF(R3<R2,\"부족\",IF(R3>R2,\"과함\",IF(R3=R2,\"OK\",\"오류\")))","v":"OK"},null,"하",{"$f":"COUNTIF(S$6:S$45,U3)&\"개 (\"&ROUND(COUNTIF(S$6:S$45,U3)/(40-COUNTBLANK(S$6:S$45))*100,0)&\"%)\"","v":"8개 (31%)"},null,{"$f":"C3","v":"배점"},{"$f":"SUM(AA6:AA45)","v":0},{"$f":"IF(Y3<Y2,\"부족\",IF(Y3>Y2,\"과함\",IF(Y3=Y2,\"OK\",\"오류\")))","v":"OK"},null,"하",{"$f":"COUNTIF(Z$6:Z$45,AB3)&\"개 (\"&ROUND(COUNTIF(Z$6:Z$45,AB3)/(40-COUNTBLANK(Z$6:Z$45))*100,0)&\"%)\"","v":{"$error":"#DIV/0!"}},null,"엑셀멘토 WH","만든이 JS"]
[null,null,"분산",{"$f":"VARP(F6:F45)","v":3.884297520661157},null,null,"중",{"$f":"COUNTIF(E$6:E$45,G4)&\"개 (\"&ROUND(COUNTIF(E$6:E$45,G4)/(40-COUNTBLANK(E$6:E$45))*100,0)&\"%)\"","v":"9개 (53%)"},null,"분산",{"$f":"VARP(M6:M45)","v":4.0529300567107747},null,null,"중",{"$f":"COUNTIF(L$6:L$45,N4)&\"개 (\"&ROUND(COUNTIF(L$6:L$45,N4)/(40-COUNTBLANK(L$6:L$45))*100,0)&\"%)\"","v":"5개 (28%)"},null,"분산",{"$f":"VARP(T6:T45)","v":0.43786982248520712},null,null,"중",{"$f":"COUNTIF(S$6:S$45,U4)&\"개 (\"&ROUND(COUNTIF(S$6:S$45,U4)/(40-COUNTBLANK(S$6:S$45))*100,0)&\"%)\"","v":"13개 (50%)"},null,"분산",{"$f":"VARP(AA6:AA45)","v":{"$error":"#DIV/0!"}},null,null,"중",{"$f":"COUNTIF(Z$6:Z$45,AB4)&\"개 (\"&ROUND(COUNTIF(Z$6:Z$45,AB4)/(40-COUNTBLANK(Z$6:Z$45))*100,0)&\"%)\"","v":{"$error":"#DIV/0!"}},null,"난이도"]
[null,null,"번호","난이도",null,"점수","상","3개 (18%)",null,"번호","난이도",null,"점수","상","4개 (22%)",null,"번호","난이도",null,"점수","상","5개 (19%)",null,"번호","난이도",null,"점수","상",{"$error":"#DIV/0!"},null,"입력","결과"]
[null,null,1,1,{"$f":"IF(D6=1,\"하\",IF(D6=2,\"중\",IF(D6=3,\"상\",\"\")))","v":"하"},3,"총",{"$f":"COUNTA(D6:D45)&\"문항\"","v":"17문항"},{"$f":"IF(D6=\"\",\"\",IF(D6=1,IF(F6>MIN(H$16,H$20),2,1),IF(D6=2,IF(F6>H$20,2,1),1)))","v":1},1,1,{"$f":"IF(K6=1,\"하\",IF(K6=2,\"중\",IF(K6=3,\"상\",\"\")))","v":"하"},3,"총",{"$f":"COUNTA(K6:K45)&\"문항\"","v":"18문항"},{"$f":"IF(K6=\"\",\"\",IF(K6=1,IF(M6>MIN(O$16,O$20),2,1),IF(K6=2,IF(M6>O$20,2,1),1)))","v":1},1,1,{"$f":"IF(R6=1,\"하\",IF(R6=2,\"중\",IF(R6=3,\"상\",\"\")))","v":"하"},3,"총",{"$f":"COUNTA(R6:R45)&\"문항\"","v":"26문항"},{"$f":"IF(R6=\"\",\"\",IF(R6=1,IF(T6>MIN(V$16,V$20),2,1),IF(R6=2,IF(T6>V$20,2,1),1)))","v":1},1,null,{"$f":"IF(Y6=1,\"하\",IF(Y6=2,\"중\",IF(Y6=3,\"상\",\"\")))","v":""},null,"총",{"$f":"COUNTA(Y6:Y45)&\"문항\"","v":"0문항"},{"$f":"IF(Y6=\"\",\"\",IF(Y6=1,IF(AA6>MIN(AC$16,AC$20),2,1),IF(Y6=2,IF(AA6>AC$20,2,1),1)))","v":""},1,"하"]
[null,null,2,1,{"$f":"IF(D7=1,\"하\",IF(D7=2,\"중\",IF(D7=3,\"상\",\"\")))","v":"하"},3,null,null,{"$f":"IF(D7=\"\",\"\",IF(D7=1,IF(F7>MIN(H$16,H$20),2,1),IF(D7=2,IF(F7>H$20,2,1),1)))","v":1},2,1,{"$f":"IF(K7=1,\"하\",IF(K7=2,\"중\",IF(K7=3,\"상\",\"\")))","v":"하"},3,null,null,{"$f":"IF(K7=\"\",\"\",IF(K7=1,IF(M7>MIN(O$16,O$20),2,1),IF(K7=2,IF(M7>O$20,2,1),1)))","v":1},2,1,{"$f":"IF(R7=1,\"하\",IF(R7=2,\"중\",IF(R7=3,\"상\",\"\")))","v":"하"},3,null,null,{"$f":"IF(R7=\"\",\"\",IF(R7=1,IF(T7>MIN(V$16,V$20),2,1),IF(R7=2,IF(T7>V$20,2,1),1)))","v":1},2,null,{"$f":"IF(Y7=1,\"하\",IF(Y7=2,\"중\",IF(Y7=3,\"상\",\"\")))","v":""},null,null,null,{"$f":"IF(Y7=\"\",\"\",IF(Y7=1,IF(AA7>MIN(AC$16,AC$20),2,1),IF(Y7=2,IF(AA7>AC$20,2,1),1)))","v":""},2,"중"]
[null,null,3,1,"하",3,null,"역배점",1,3,1,"하",3,null,"역배점",1,3,1,"하",3,null,"역배점",1,3,null,"",null,null,"역배점","",3,"상"]
[null,null,4,1,"하",3,null,"검토",1,4,1,"하",3,null,"검토",1,4,1,"하",3,null,"검토",1,4,null,"",null,null,"검토",""]
[null,null,5,1,"하",3,null,null,1,5,2,"중",3,null,null,1,5,1,"하",3,null,null,1,5,null,"",null,null,null,"",{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,6,2,"중",3,null,"하",1,6,2,"중",3,null,"하",1,6,1,"하",3,null,"하",1,6,null,"",null,null,"하","",{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,7,2,"중",3,"최저",{"$f":"INDEX(F$6:F$45,MATCH(MIN(IF(D$6:D$45=1,D$6:D$45,7)*IF(F$6:F$45=\"\",7,F$6:F$45)*1),F$6:F$45,0),)","v":3},1,7,1,"하",3,"최저",{"$f":"INDEX(M$6:M$45,MATCH(MIN(IF(K$6:K$45=1,K$6:K$45,7)*IF(M$6:M$45=\"\",7,M$6:M$45)*1),M$6:M$45,0),)","v":3},1,7,1,"하",3,"최저",{"$f":"INDEX(T$6:T$45,MATCH(MIN(IF(R$6:R$45=1,R$6:R$45,7)*IF(T$6:T$45=\"\",7,T$6:T$45)*1),T$6:T$45,0),)","v":3},1,7,null,"",null,"최저",{"$f":"INDEX(AA$6:AA$45,MATCH(MIN(IF(Y$6:Y$45=1,Y$6:Y$45,7)*IF(AA$6:AA$45=\"\",7,AA$6:AA$45)*1),AA$6:AA$45,0),)","v":{"$error":"#N/A"}},""]
[null,null,8,2,"중",3,"최고",{"$f":"INDEX(F$6:F$45,MATCH(MAX((D$6:D$45=1)*F$6:F$45*1),F$6:F$45,0))","v":3},1,8,1,"하",3,"최고",{"$f":"INDEX(M$6:M$45,MATCH(MAX((K$6:K$45=1)*M$6:M$45*1),M$6:M$45,0))","v":3},1,8,1,"하",3,"최고",{"$f":"INDEX(T$6:T$45,MATCH(MAX((R$6:R$45=1)*T$6:T$45*1),T$6:T$45,0))","v":3},1,8,null,"",null,"최고",{"$f":"INDEX(AA$6:AA$45,MATCH(MAX((Y$6:Y$45=1)*AA$6:AA$45*1),AA$6:AA$45,0))","v":{"$error":"#N/A"}},"",{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,9,2,"중",3,null,null,1,9,1,"하",3,null,null,1,9,2,"중",4,null,null,1,9,null,"",null,null,null,"",{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,10,2,"중",3,null,"중",1,10,1,"하",3,null,"중",1,10,2,"중",4,null,"중",1,10,null,"",null,null,"중",""]
[null,null,11,2,"중",4,"최저",{"$f":"INDEX(F$6:F$45,MATCH(MIN(IF(D$6:D$45=2,1,7)*IF(F$6:F$45=\"\",7,F$6:F$45)*1),F$6:F$45,0),)","v":3},1,11,1,"하",3,"최저",{"$f":"INDEX(M$6:M$45,MATCH(MIN(IF(K$6:K$45=2,1,7)*IF(M$6:M$45=\"\",7,M$6:M$45)*1),M$6:M$45,0),)","v":3},1,11,2,"중",4,"최저",{"$f":"INDEX(T$6:T$45,MATCH(MIN(IF(R$6:R$45=2,1,7)*IF(T$6:T$45=\"\",7,T$6:T$45)*1),T$6:T$45,0),)","v":4},1,11,null,"",null,"최저",{"$f":"INDEX(AA$6:AA$45,MATCH(MIN(IF(Y$6:Y$45=2,1,7)*IF(AA$6:AA$45=\"\",7,AA$6:AA$45)*1),AA$6:AA$45,0),)","v":{"$error":"#N/A"}},"",{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,12,2,"중",4,"최고",{"$f":"INDEX(F$6:F$45,MATCH(MAX((D$6:D$45=2)*F$6:F$45),F$6:F$45,0))","v":4},1,12,2,"중",3,"최고",{"$f":"INDEX(M$6:M$45,MATCH(MAX((K$6:K$45=2)*M$6:M$45),M$6:M$45,0))","v":3},1,12,2,"중",4,"최고",{"$f":"INDEX(T$6:T$45,MATCH(MAX((R$6:R$45=2)*T$6:T$45),T$6:T$45,0))","v":4},1,12,null,"",null,"최고",{"$f":"INDEX(AA$6:AA$45,MATCH(MAX((Y$6:Y$45=2)*AA$6:AA$45),AA$6:AA$45,0))","v":{"$error":"#N/A"}},"",{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,13,2,"중",4,null,null,1,13,2,"중",3,null,null,1,13,2,"중",4,null,null,1,13,null,"",null,null,null,"",{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,14,2,"중",4,null,"상",1,14,2,"중",3,null,"상",1,14,2,"중",4,null,"상",1,14,null,"",null,null,"상","",{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,15,3,"상",4,"최저",{"$f":"INDEX(F$6:F$45,MATCH(MIN(IF(D$6:D$45=3,1,7)*IF(F$6:F$45=\"\",7,F$6:F$45)*1),F$6:F$45,0),)","v":4},1,15,3,"상",4,"최저",{"$f":"INDEX(M$6:M$45,MATCH(MIN(IF(K$6:K$45=3,1,7)*IF(M$6:M$45=\"\",7,M$6:M$45)*1),M$6:M$45,0),)","v":4},1,15,2,"중",4,"최저",{"$f":"INDEX(T$6:T$45,MATCH(MIN(IF(R$6:R$45=3,1,7)*IF(T$6:T$45=\"\",7,T$6:T$45)*1),T$6:T$45,0),)","v":4},1,15,null,"",null,"최저",{"$f":"INDEX(AA$6:AA$45,MATCH(MIN(IF(Y$6:Y$45=3,1,7)*IF(AA$6:AA$45=\"\",7,AA$6:AA$45)*1),AA$6:AA$45,0),)","v":{"$error":"#N/A"}},"",{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,16,3,"상",5,"최고",{"$f":"INDEX(F$6:F$45,MATCH(MAX((D$6:D$45=3)*F$6:F$45),F$6:F$45,0))","v":5},1,16,3,"상",4,"최고",{"$f":"INDEX(M$6:M$45,MATCH(MAX((K$6:K$45=3)*M$6:M$45),M$6:M$45,0))","v":5},1,16,2,"중",4,"최고",{"$f":"INDEX(T$6:T$45,MATCH(MAX((R$6:R$45=3)*T$6:T$45),T$6:T$45,0))","v":5},1,16,null,"",null,"최고",{"$f":"INDEX(AA$6:AA$45,MATCH(MAX((Y$6:Y$45=3)*AA$6:AA$45),AA$6:AA$45,0))","v":{"$error":"#N/A"}},"",{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,17,3,"상",5,null,null,1,17,3,"상",5,null,null,1,17,2,"중",4,null,null,1,17,null,"",null,null,null,"",{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,18,null,"",8,null,null,"",18,3,"상",5,null,null,1,18,2,"중",4,null,null,1,18,null,"",null,null,null,"",{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,19,null,"",8,null,null,"",19,null,"",8,null,null,"",19,2,"중",4,null,null,1,19,null,"",null,null,null,"",{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,20,null,"",8,null,null,"",20,null,"",8,null,null,"",20,2,"중",4,null,null,1,20,null,"",null,null,null,"",{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,21,null,"",8,null,null,"",21,null,"",8,null,null,"",21,2,"중",4,null,null,1,21,null,"",null,null,null,"",{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,22,null,"",8,null,null,"",22,null,"",8,null,null,"",22,3,"상",4,null,null,1,22,null,"",null,null,null,""]
[null,null,23,null,"",null,null,null,"",23,null,"",8,null,null,"",23,3,"상",5,null,null,1,23,null,"",null,null,null,"",{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,24,null,"",null,null,null,"",24,null,"",null,null,null,"",24,3,"상",5,null,null,1,24,null,"",null,null,null,"",{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,25,null,"",null,null,null,"",25,null,"",null,null,null,"",25,3,"상",5,null,null,1,25,null,"",null,null,null,"",{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,26,null,"",null,null,null,"",26,null,"",null,null,null,"",26,3,"상",5,null,null,1,26,null,"",null,null,null,"",{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,27,null,"",null,null,null,"",27,null,"",null,null,null,"",27,null,"",null,null,null,"",27,null,"",null,null,null,""]
[null,null,28,null,"",null,null,null,"",28,null,"",null,null,null,"",28,null,"",null,null,null,"",28,null,"",null,null,null,""]
[null,null,29,null,null,null,null,null,"",29,null,null,null,null,null,"",29,null,null,null,null,null,"",29,null,null,null,null,null,""]
[null,null,30,null,null,null,null,null,"",30,null,null,null,null,null,"",30,null,null,null,null,null,"",30,null,null,null,null,null,""]
[null,null,31,null,null,null,null,null,"",31,null,null,null,null,null,"",31,null,null,null,null,null,"",31,null,null,null,null,null,""]
[null,null,32,null,null,null,null,null,"",32,null,null,null,null,null,"",32,null,null,null,null,null,"",32,null,null,null,null,null,""]
[null,null,33,null,null,null,null,null,"",33,null,null,null,null,null,"",33,null,null,null,null,null,"",33,null,null,null,null,null,""]
[null,null,34,null,null,null,null,null,"",34,null,null,null,null,null,"",34,null,null,null,null,null,"",34,null,null,null,null,null,""]
[null,null,35,null,"",null,null,null,"",35,null,{"$f":"IF(K40=1,\"하\",IF(K40=2,\"중\",IF(K40=3,\"상\",\"\")))","v":""},null,null,null,"",35,null,{"$f":"IF(R40=1,\"하\",IF(R40=2,\"중\",IF(R40=3,\"상\",\"\")))","v":""},null,null,null,"",35,null,{"$f":"IF(Y40=1,\"하\",IF(Y40=2,\"중\",IF(Y40=3,\"상\",\"\")))","v":""},null,null,null,""]
[null,null,36,null,"",null,null,null,"",36,null,"",null,null,null,"",36,null,"",null,null,null,"",36,null,"",null,null,null,""]
[null,null,37,null,"",null,null,null,"",37,null,"",null,null,null,"",37,null,"",null,null,null,"",37,null,"",null,null,null,""]
[null,null,38,null,"",null,null,null,"",38,null,"",null,null,null,"",38,null,"",null,null,null,"",38,null,"",null,null,null,""]
[null,null,39,null,"",null,null,null,"",39,null,"",null,null,null,"",39,null,"",null,null,null,"",39,null,"",null,null,null,""]
[null,null,40,null,"",null,null,null,"",40,null,"",null,null,null,"",40,null,"",null,null,null,"",40,null,"",null,null,null,""]

{"sheet":"배점1~4안","index":2,"n_rows":45,"n_cols":32,"rows_kept":45,"cut":false,"hidden":false,"merged":[[35,30,35,31],[14,30,14,31],[29,30,29,31],[30,30,30,31],[31,30,31,31],[32,30,32,31],[33,30,33,31],[34,30,34,31],[23,30,23,31],[24,30,24,31],[25,30,25,31],[26,30,26,31],[27,30,27,31],[28,30,28,31],[17,30,17,31],[18,30,18,31],[19,30,19,31],[20,30,20,31],[21,30,21,31],[22,30,22,31],[16,30,16,31],[9,30,9,31],[3,30,3,31],[4,3,4,4],[4,10,4,11],[4,17,4,18],[4,24,4,25],[10,30,10,31],[11,30,11,31],[12,30,12,31],[13,30,13,31],[15,30,15,31]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"zcrong"]
[null,null,"만점",100,null,null,null,null,null,"만점",100,null,null,null,null,null,"만점",100,null,null,null,null,null,"만점"]
[null,null,"배점",{"$f":"SUM(F6:F45)","v":100},{"$f":"IF(D3<D2,\"부족\",IF(D3>D2,\"과함\",IF(D3=D2,\"OK\",\"오류\")))","v":"OK"},null,"하",{"$f":"COUNTIF(E$6:E$45,G3)&\"개 (\"&ROUND(COUNTIF(E$6:E$45,G3)/(40-COUNTBLANK(E$6:E$45))*100,0)&\"%)\"","v":"5개 (29%)"},null,{"$f":"C3","v":"배점"},{"$f":"SUM(M6:M45)","v":100.00000000000001},{"$f":"IF(K3<K2,\"부족\",IF(K3>K2,\"과함\",IF(K3=K2,\"OK\",\"오류\")))","v":"OK"},null,"하",{"$f":"COUNTIF(L$6:L$45,N3)&\"개 (\"&ROUND(COUNTIF(L$6:L$45,N3)/(40-COUNTBLANK(L$6:L$45))*100,0)&\"%)\"","v":"7개 (32%)"},null,{"$f":"C3","v":"배점"},{"$f":"SUM(T6:T45)","v":99.999999999999986},{"$f":"IF(R3<R2,\"부족\",IF(R3>R2,\"과함\",IF(R3=R2,\"OK\",\"오류\")))","v":"OK"},null,"하",{"$f":"COUNTIF(S$6:S$45,U3)&\"개 (\"&ROUND(COUNTIF(S$6:S$45,U3)/(40-COUNTBLANK(S$6:S$45))*100,0)&\"%)\"","v":"8개 (36%)"},null,{"$f":"C3","v":"배점"},{"$f":"SUM(AA6:AA45)","v":0},{"$f":"IF(Y3<Y2,\"부족\",IF(Y3>Y2,\"과함\",IF(Y3=Y2,\"OK\",\"오류\")))","v":"OK"},null,"하",{"$f":"COUNTIF(Z$6:Z$45,AB3)&\"개 (\"&ROUND(COUNTIF(Z$6:Z$45,AB3)/(40-COUNTBLANK(Z$6:Z$45))*100,0)&\"%)\"","v":{"$error":"#DIV/0!"}},null,"엑셀멘토 WH","만든이 JS"]
[null,null,"분산",{"$f":"VARP(F6:F45)","v":3.884297520661157},null,null,"중",{"$f":"COUNTIF(E$6:E$45,G4)&\"개 (\"&ROUND(COUNTIF(E$6:E$45,G4)/(40-COUNTBLANK(E$6:E$45))*100,0)&\"%)\"","v":"9개 (53%)"},null,"분산",{"$f":"VARP(M6:M45)","v":0.20157024793388431},null,null,"중",{"$f":"COUNTIF(L$6:L$45,N4)&\"개 (\"&ROUND(COUNTIF(L$6:L$45,N4)/(40-COUNTBLANK(L$6:L$45))*100,0)&\"%)\"","v":"11개 (50%)"},null,"분산",{"$f":"VARP(T6:T45)","v":0.17975206611570257},null,null,"중",{"$f":"COUNTIF(S$6:S$45,U4)&\"개 (\"&ROUND(COUNTIF(S$6:S$45,U4)/(40-COUNTBLANK(S$6:S$45))*100,0)&\"%)\"","v":"9개 (41%)"},null,"분산",{"$f":"VARP(AA6:AA45)","v":{"$error":"#DIV/0!"}},null,null,"중",{"$f":"COUNTIF(Z$6:Z$45,AB4)&\"개 (\"&ROUND(COUNTIF(Z$6:Z$45,AB4)/(40-COUNTBLANK(Z$6:Z$45))*100,0)&\"%)\"","v":{"$error":"#DIV/0!"}},null,"난이도"]
[null,null,"번호","난이도",null,"점수","상","3개 (18%)",null,"번호","난이도",null,"점수","상","4개 (18%)",null,"번호","난이도",null,"점수","상","5개 (23%)",null,"번호","난이도",null,"점수","상",{"$error":"#DIV/0!"},null,"입력","결과"]
[null,null,1,1,{"$f":"IF(D6=1,\"하\",IF(D6=2,\"중\",IF(D6=3,\"상\",\"\")))","v":"하"},3,"총",{"$f":"COUNTA(D6:D45)&\"문항\"","v":"17문항"},{"$f":"IF(D6=\"\",\"\",IF(D6=1,IF(F6>MIN(H$16,H$20),2,1),IF(D6=2,IF(F6>H$20,2,1),1)))","v":1},1,1,{"$f":"IF(K6=1,\"하\",IF(K6=2,\"중\",IF(K6=3,\"상\",\"\")))","v":"하"},4,"총",{"$f":"COUNTA(K6:K45)&\"문항\"","v":"22문항"},{"$f":"IF(K6=\"\",\"\",IF(K6=1,IF(M6>MIN(O$16,O$20),2,1),IF(K6=2,IF(M6>O$20,2,1),1)))","v":1},1,1,{"$f":"IF(R6=1,\"하\",IF(R6=2,\"중\",IF(R6=3,\"상\",\"\")))","v":"하"},4,"총",{"$f":"COUNTA(R6:R45)&\"문항\"","v":"22문항"},{"$f":"IF(R6=\"\",\"\",IF(R6=1,IF(T6>MIN(V$16,V$20),2,1),IF(R6=2,IF(T6>V$20,2,1),1)))","v":1},1,null,{"$f":"IF(Y6=1,\"하\",IF(Y6=2,\"중\",IF(Y6=3,\"상\",\"\")))","v":""},null,"총",{"$f":"COUNTA(Y6:Y45)&\"문항\"","v":"0문항"},{"$f":"IF(Y6=\"\",\"\",IF(Y6=1,IF(AA6>MIN(AC$16,AC$20),2,1),IF(Y6=2,IF(AA6>AC$20,2,1),1)))","v":""},1,"하"]
[null,null,2,1,{"$f":"IF(D7=1,\"하\",IF(D7=2,\"중\",IF(D7=3,\"상\",\"\")))","v":"하"},3,null,null,{"$f":"IF(D7=\"\",\"\",IF(D7=1,IF(F7>MIN(H$16,H$20),2,1),IF(D7=2,IF(F7>H$20,2,1),1)))","v":1},2,1,{"$f":"IF(K7=1,\"하\",IF(K7=2,\"중\",IF(K7=3,\"상\",\"\")))","v":"하"},4,null,null,{"$f":"IF(K7=\"\",\"\",IF(K7=1,IF(M7>MIN(O$16,O$20),2,1),IF(K7=2,IF(M7>O$20,2,1),1)))","v":1},2,1,{"$f":"IF(R7=1,\"하\",IF(R7=2,\"중\",IF(R7=3,\"상\",\"\")))","v":"하"},4,null,null,{"$f":"IF(R7=\"\",\"\",IF(R7=1,IF(T7>MIN(V$16,V$20),2,1),IF(R7=2,IF(T7>V$20,2,1),1)))","v":1},2,null,{"$f":"IF(Y7=1,\"하\",IF(Y7=2,\"중\",IF(Y7=3,\"상\",\"\")))","v":""},null,null,null,{"$f":"IF(Y7=\"\",\"\",IF(Y7=1,IF(AA7>MIN(AC$16,AC$20),2,1),IF(Y7=2,IF(AA7>AC$20,2,1),1)))","v":""},2,"중"]
[null,null,3,1,"하",3,null,"역배점",1,3,1,"하",4,null,"역배점",1,3,1,"하",4.2,null,"역배점",1,3,null,"",null,null,"역배점","",3,"상"]
[null,null,4,1,"하",3,null,"검토",1,4,1,"하",4.0999999999999996,null,"검토",1,4,1,"하",4.2,null,"검토",1,4,null,"",null,null,"검토",""]
[null,null,5,1,"하",3,null,null,1,5,1,"하",4.0999999999999996,null,null,1,5,1,"하",4.2,null,null,1,5,null,"",null,null,null,"",{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,6,2,"중",3,null,"하",1,6,1,"하",4.2,null,"하",1,6,2,"중",4.2,null,"하",1,6,null,"",null,null,"하","",{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,7,2,"중",3,"최저",{"$f":"INDEX(F$6:F$45,MATCH(MIN(IF(D$6:D$45=1,D$6:D$45,7)*IF(F$6:F$45=\"\",7,F$6:F$45)*1),F$6:F$45,0),)","v":3},1,7,1,"하",4.2,"최저",{"$f":"INDEX(M$6:M$45,MATCH(MIN(IF(K$6:K$45=1,K$6:K$45,7)*IF(M$6:M$45=\"\",7,M$6:M$45)*1),M$6:M$45,0),)","v":4},1,7,2,"중",4.8999999999999995,"최저",{"$f":"INDEX(T$6:T$45,MATCH(MIN(IF(R$6:R$45=1,R$6:R$45,7)*IF(T$6:T$45=\"\",7,T$6:T$45)*1),T$6:T$45,0),)","v":4},1,7,null,"",null,"최저",{"$f":"INDEX(AA$6:AA$45,MATCH(MIN(IF(Y$6:Y$45=1,Y$6:Y$45,7)*IF(AA$6:AA$45=\"\",7,AA$6:AA$45)*1),AA$6:AA$45,0),)","v":{"$error":"#N/A"}},""]
[null,null,8,2,"중",3,"최고",{"$f":"INDEX(F$6:F$45,MATCH(MAX((D$6:D$45=1)*F$6:F$45*1),F$6:F$45,0))","v":3},1,8,2,"중",4.2,"최고",{"$f":"INDEX(M$6:M$45,MATCH(MAX((K$6:K$45=1)*M$6:M$45*1),M$6:M$45,0))","v":4.2},1,8,2,"중",4.3999999999999995,"최고",{"$f":"INDEX(T$6:T$45,MATCH(MAX((R$6:R$45=1)*T$6:T$45*1),T$6:T$45,0))","v":4.2},1,8,null,"",null,"최고",{"$f":"INDEX(AA$6:AA$45,MATCH(MAX((Y$6:Y$45=1)*AA$6:AA$45*1),AA$6:AA$45,0))","v":{"$error":"#N/A"}},"",{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,9,2,"중",3,null,null,1,9,2,"중",4.2,null,null,1,9,2,"중",4.8,null,null,1,9,null,"",null,null,null,"",{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,10,2,"중",3,null,"중",1,10,2,"중",4.4000000000000004,null,"중",1,10,1,"하",4.0999999999999996,null,"중",1,10,null,"",null,null,"중",""]
[null,null,11,2,"중",4,"최저",{"$f":"INDEX(F$6:F$45,MATCH(MIN(IF(D$6:D$45=2,1,7)*IF(F$6:F$45=\"\",7,F$6:F$45)*1),F$6:F$45,0),)","v":3},1,11,2,"중",4.4000000000000004,"최저",{"$f":"INDEX(M$6:M$45,MATCH(MIN(IF(K$6:K$45=2,1,7)*IF(M$6:M$45=\"\",7,M$6:M$45)*1),M$6:M$45,0),)","v":4.2},1,11,1,"하",4.1999999999999993,"최저",{"$f":"INDEX(T$6:T$45,MATCH(MIN(IF(R$6:R$45=2,1,7)*IF(T$6:T$45=\"\",7,T$6:T$45)*1),T$6:T$45,0),)","v":4.2},1,11,null,"",null,"최저",{"$f":"INDEX(AA$6:AA$45,MATCH(MIN(IF(Y$6:Y$45=2,1,7)*IF(AA$6:AA$45=\"\",7,AA$6:AA$45)*1),AA$6:AA$45,0),)","v":{"$error":"#N/A"}},"",{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,12,2,"중",4,"최고",{"$f":"INDEX(F$6:F$45,MATCH(MAX((D$6:D$45=2)*F$6:F$45),F$6:F$45,0))","v":4},1,12,2,"중",4.5,"최고",{"$f":"INDEX(M$6:M$45,MATCH(MAX((K$6:K$45=2)*M$6:M$45),M$6:M$45,0))","v":5},1,12,2,"중",4.9000000000000004,"최고",{"$f":"INDEX(T$6:T$45,MATCH(MAX((R$6:R$45=2)*T$6:T$45),T$6:T$45,0))","v":4.9000000000000004},1,12,null,"",null,"최고",{"$f":"INDEX(AA$6:AA$45,MATCH(MAX((Y$6:Y$45=2)*AA$6:AA$45),AA$6:AA$45,0))","v":{"$error":"#N/A"}},"",{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,13,2,"중",4,null,null,1,13,2,"중",4.5,null,null,1,13,3,"상",5,null,null,1,13,null,"",null,null,null,"",{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,14,2,"중",4,null,"상",1,14,2,"중",4.7,null,"상",1,14,1,"하",4.0999999999999996,null,"상",1,14,null,"",null,null,"상","",{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,15,3,"상",4,"최저",{"$f":"INDEX(F$6:F$45,MATCH(MIN(IF(D$6:D$45=3,1,7)*IF(F$6:F$45=\"\",7,F$6:F$45)*1),F$6:F$45,0),)","v":4},1,15,2,"중",4.7,"최저",{"$f":"INDEX(M$6:M$45,MATCH(MIN(IF(K$6:K$45=3,1,7)*IF(M$6:M$45=\"\",7,M$6:M$45)*1),M$6:M$45,0),)","v":5},1,15,2,"중",4.4000000000000004,"최저",{"$f":"INDEX(T$6:T$45,MATCH(MIN(IF(R$6:R$45=3,1,7)*IF(T$6:T$45=\"\",7,T$6:T$45)*1),T$6:T$45,0),)","v":5},1,15,null,"",null,"최저",{"$f":"INDEX(AA$6:AA$45,MATCH(MIN(IF(Y$6:Y$45=3,1,7)*IF(AA$6:AA$45=\"\",7,AA$6:AA$45)*1),AA$6:AA$45,0),)","v":{"$error":"#N/A"}},"",{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,16,3,"상",5,"최고",{"$f":"INDEX(F$6:F$45,MATCH(MAX((D$6:D$45=3)*F$6:F$45),F$6:F$45,0))","v":5},1,16,2,"중",4.9000000000000004,"최고",{"$f":"INDEX(M$6:M$45,MATCH(MAX((K$6:K$45=3)*M$6:M$45),M$6:M$45,0))","v":5.5},1,16,2,"중",4.5999999999999996,"최고",{"$f":"INDEX(T$6:T$45,MATCH(MAX((R$6:R$45=3)*T$6:T$45),T$6:T$45,0))","v":5.4},1,16,null,"",null,"최고",{"$f":"INDEX(AA$6:AA$45,MATCH(MAX((Y$6:Y$45=3)*AA$6:AA$45),AA$6:AA$45,0))","v":{"$error":"#N/A"}},"",{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,17,3,"상",5,null,null,1,17,2,"중",4.9000000000000004,null,null,1,17,3,"상",5,null,null,1,17,null,"",null,null,null,"",{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,18,null,"",8,null,null,"",18,2,"중",5,null,null,1,18,2,"중",4.3000000000000007,null,null,1,18,null,"",null,null,null,"",{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,19,null,"",8,null,null,"",19,3,"상",5,null,null,1,19,2,"중",4.8000000000000007,null,null,1,19,null,"",null,null,null,"",{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,20,null,"",8,null,null,"",20,3,"상",5.2,null,null,1,20,3,"상",5.1000000000000005,null,null,1,20,null,"",null,null,null,"",{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,21,null,"",8,null,null,"",21,3,"상",5.3,null,null,1,21,3,"상",5.2,null,null,1,21,null,"",null,null,null,"",{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,22,null,"",8,null,null,"",22,3,"상",5.5,null,null,1,22,3,"상",5.4,null,null,1,22,null,"",null,null,null,""]
[null,null,23,null,"",null,null,null,"",23,null,"",null,null,null,"",23,null,"",null,null,null,"",23,null,"",null,null,null,"",{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,24,null,"",null,null,null,"",24,null,"",null,null,null,"",24,null,"",null,null,null,"",24,null,"",null,null,null,"",{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,25,null,"",null,null,null,"",25,null,"",null,null,null,"",25,null,"",null,null,null,"",25,null,"",null,null,null,"",{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,26,null,"",null,null,null,"",26,null,"",null,null,null,"",26,null,"",null,null,null,"",26,null,"",null,null,null,"",{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,27,null,"",null,null,null,"",27,null,"",null,null,null,"",27,null,"",null,null,null,"",27,null,"",null,null,null,""]
[null,null,28,null,"",null,null,null,"",28,null,"",null,null,null,"",28,null,"",null,null,null,"",28,null,"",null,null,null,""]
[null,null,29,null,null,null,null,null,"",29,null,null,null,null,null,"",29,null,null,null,null,null,"",29,null,null,null,null,null,""]
[null,null,30,null,null,null,null,null,"",30,null,null,null,null,null,"",30,null,null,null,null,null,"",30,null,null,null,null,null,""]
[null,null,31,null,null,null,null,null,"",31,null,null,null,null,null,"",31,null,null,null,null,null,"",31,null,null,null,null,null,""]
[null,null,32,null,null,null,null,null,"",32,null,null,null,null,null,"",32,null,null,null,null,null,"",32,null,null,null,null,null,""]
[null,null,33,null,null,null,null,null,"",33,null,null,null,null,null,"",33,null,null,null,null,null,"",33,null,null,null,null,null,""]
[null,null,34,null,null,null,null,null,"",34,null,null,null,null,null,"",34,null,null,null,null,null,"",34,null,null,null,null,null,""]
[null,null,35,null,"",null,null,null,"",35,null,{"$f":"IF(K40=1,\"하\",IF(K40=2,\"중\",IF(K40=3,\"상\",\"\")))","v":""},null,null,null,"",35,null,{"$f":"IF(R40=1,\"하\",IF(R40=2,\"중\",IF(R40=3,\"상\",\"\")))","v":""},null,null,null,"",35,null,{"$f":"IF(Y40=1,\"하\",IF(Y40=2,\"중\",IF(Y40=3,\"상\",\"\")))","v":""},null,null,null,""]
[null,null,36,null,"",null,null,null,"",36,null,"",null,null,null,"",36,null,"",null,null,null,"",36,null,"",null,null,null,""]
[null,null,37,null,"",null,null,null,"",37,null,"",null,null,null,"",37,null,"",null,null,null,"",37,null,"",null,null,null,""]
[null,null,38,null,"",null,null,null,"",38,null,"",null,null,null,"",38,null,"",null,null,null,"",38,null,"",null,null,null,""]
[null,null,39,null,"",null,null,null,"",39,null,"",null,null,null,"",39,null,"",null,null,null,"",39,null,"",null,null,null,""]
[null,null,40,null,"",null,null,null,"",40,null,"",null,null,null,"",40,null,"",null,null,null,"",40,null,"",null,null,null,""]

{"sheet":"문항번호","index":3,"n_rows":59,"n_cols":8,"rows_kept":59,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"총갯수"]
[null,"계",{"$f":"SUM(C10:C59)","v":0},{"$f":"SUM(D10:D59)","v":0},0,0,1,{"$f":"SUM(C7:G7)","v":1}]
[null,"보기",1,2,3,4,5]
[null,"문항번호"]
[null,1,null,null,null,null,1]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]
[null,21]
[null,22]
[null,23]
[null,24]
[null,25]
[null,26]
[null,27]
[null,28]
[null,29]
[null,30]
[null,31]
[null,32]
[null,33]
[null,34]
[null,35]
[null,36]
[null,37]
[null,38]
[null,39]
[null,40]
[null,41]
[null,42]
[null,43]
[null,44]
[null,45]
[null,46]
[null,47]
[null,48]
[null,49]
[null,50]

{"sheet":"배점5~8안","index":4,"n_rows":45,"n_cols":32,"rows_kept":45,"cut":false,"hidden":false,"merged":[[33,30,33,31],[34,30,34,31],[35,30,35,31],[27,30,27,31],[28,30,28,31],[29,30,29,31],[30,30,30,31],[31,30,31,31],[32,30,32,31],[26,30,26,31],[15,30,15,31],[16,30,16,31],[17,30,17,31],[18,30,18,31],[19,30,19,31],[20,30,20,31],[21,30,21,31],[22,30,22,31],[23,30,23,31],[24,30,24,31],[25,30,25,31],[14,30,14,31],[3,30,3,31],[4,3,4,4],[4,10,4,11],[4,17,4,18],[4,24,4,25],[9,30,9,31],[10,30,10,31],[11,30,11,31],[12,30,12,31],[13,30,13,31]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"zcrong"]
[null,null,"만점",100,null,null,null,null,null,"만점",100,null,null,null,null,null,"만점",100,null,null,null,null,null,"만점",100]
[null,null,"배점",{"$f":"SUM(F6:F45)","v":100.00000000000003},{"$f":"IF(D3<D2,\"부족\",IF(D3>D2,\"과함\",IF(D3=D2,\"OK\",\"오류\")))","v":"OK"},null,"하",{"$f":"COUNTIF(E$6:E$45,G3)&\"개 (\"&ROUND(COUNTIF(E$6:E$45,G3)/(40-COUNTBLANK(E$6:E$45))*100,0)&\"%)\"","v":"10개 (26%)"},null,{"$f":"C3","v":"배점"},{"$f":"SUM(M6:M45)","v":100},{"$f":"IF(K3<K2,\"부족\",IF(K3>K2,\"과함\",IF(K3=K2,\"OK\",\"오류\")))","v":"OK"},null,"하",{"$f":"COUNTIF(L$6:L$45,N3)&\"개 (\"&ROUND(COUNTIF(L$6:L$45,N3)/(40-COUNTBLANK(L$6:L$45))*100,0)&\"%)\"","v":"10개 (30%)"},null,{"$f":"C3","v":"배점"},{"$f":"SUM(T6:T45)","v":99.999999999999972},{"$f":"IF(R3<R2,\"부족\",IF(R3>R2,\"과함\",IF(R3=R2,\"OK\",\"오류\")))","v":"OK"},null,"하",{"$f":"COUNTIF(S$6:S$45,U3)&\"개 (\"&ROUND(COUNTIF(S$6:S$45,U3)/(40-COUNTBLANK(S$6:S$45))*100,0)&\"%)\"","v":"10개 (29%)"},null,{"$f":"C3","v":"배점"},{"$f":"SUM(AA6:AA45)","v":99.999999999999972},{"$f":"IF(Y3<Y2,\"부족\",IF(Y3>Y2,\"과함\",IF(Y3=Y2,\"OK\",\"오류\")))","v":"OK"},null,"하",{"$f":"COUNTIF(Z$6:Z$45,AB3)&\"개 (\"&ROUND(COUNTIF(Z$6:Z$45,AB3)/(40-COUNTBLANK(Z$6:Z$45))*100,0)&\"%)\"","v":"10개 (29%)"},null,"엑셀멘토 WH","만든이 JS"]
[null,null,"분산",{"$f":"VARP(F6:F45)","v":1.8711374095989532E-2},null,null,"중",{"$f":"COUNTIF(E$6:E$45,G4)&\"개 (\"&ROUND(COUNTIF(E$6:E$45,G4)/(40-COUNTBLANK(E$6:E$45))*100,0)&\"%)\"","v":"12개 (31%)"},null,"분산",{"$f":"VARP(M6:M45)","v":2.9384756657483999E-2},null,null,"중",{"$f":"COUNTIF(L$6:L$45,N4)&\"개 (\"&ROUND(COUNTIF(L$6:L$45,N4)/(40-COUNTBLANK(L$6:L$45))*100,0)&\"%)\"","v":"12개 (36%)"},null,"분산",{"$f":"VARP(T6:T45)","v":2.9306122448979646E-2},null,null,"중",{"$f":"COUNTIF(S$6:S$45,U4)&\"개 (\"&ROUND(COUNTIF(S$6:S$45,U4)/(40-COUNTBLANK(S$6:S$45))*100,0)&\"%)\"","v":"12개 (34%)"},null,"분산",{"$f":"VARP(AA6:AA45)","v":2.9306122448979646E-2},null,null,"중",{"$f":"COUNTIF(Z$6:Z$45,AB4)&\"개 (\"&ROUND(COUNTIF(Z$6:Z$45,AB4)/(40-COUNTBLANK(Z$6:Z$45))*100,0)&\"%)\"","v":"12개 (34%)"},null,"난이도"]
[null,null,"번호","난이도",null,"점수","상","17개 (44%)",null,"번호","난이도",null,"점수","상","11개 (33%)",null,"번호","난이도",null,"점수","상","13개 (37%)",null,"번호","난이도",null,"점수","상","13개 (37%)",null,"입력","결과"]
[null,null,1,1,{"$f":"IF(D6=1,\"하\",IF(D6=2,\"중\",IF(D6=3,\"상\",\"\")))","v":"하"},2.1999999999999993,"총",{"$f":"COUNTA(D6:D45)&\"문항\"","v":"39문항"},{"$f":"IF(D6=\"\",\"\",IF(D6=1,IF(F6>MIN(H$16,H$20),2,1),IF(D6=2,IF(F6>H$20,2,1),1)))","v":1},1,1,{"$f":"IF(K6=1,\"하\",IF(K6=2,\"중\",IF(K6=3,\"상\",\"\")))","v":"하"},2.5999999999999996,"총",{"$f":"COUNTA(K6:K45)&\"문항\"","v":"33문항"},{"$f":"IF(K6=\"\",\"\",IF(K6=1,IF(M6>MIN(O$16,O$20),2,1),IF(K6=2,IF(M6>O$20,2,1),1)))","v":1},1,1,{"$f":"IF(R6=1,\"하\",IF(R6=2,\"중\",IF(R6=3,\"상\",\"\")))","v":"하"},2.4999999999999996,"총",{"$f":"COUNTA(R6:R45)&\"문항\"","v":"35문항"},{"$f":"IF(R6=\"\",\"\",IF(R6=1,IF(T6>MIN(V$16,V$20),2,1),IF(R6=2,IF(T6>V$20,2,1),1)))","v":1},1,1,{"$f":"IF(Y6=1,\"하\",IF(Y6=2,\"중\",IF(Y6=3,\"상\",\"\")))","v":"하"},2.4999999999999996,"총",{"$f":"COUNTA(Y6:Y45)&\"문항\"","v":"35문항"},{"$f":"IF(Y6=\"\",\"\",IF(Y6=1,IF(AA6>MIN(AC$16,AC$20),2,1),IF(Y6=2,IF(AA6>AC$20,2,1),1)))","v":1},1,"하"]
[null,null,2,1,{"$f":"IF(D7=1,\"하\",IF(D7=2,\"중\",IF(D7=3,\"상\",\"\")))","v":"하"},2.1999999999999993,null,null,{"$f":"IF(D7=\"\",\"\",IF(D7=1,IF(F7>MIN(H$16,H$20),2,1),IF(D7=2,IF(F7>H$20,2,1),1)))","v":1},2,1,{"$f":"IF(K7=1,\"하\",IF(K7=2,\"중\",IF(K7=3,\"상\",\"\")))","v":"하"},2.5999999999999996,null,null,{"$f":"IF(K7=\"\",\"\",IF(K7=1,IF(M7>MIN(O$16,O$20),2,1),IF(K7=2,IF(M7>O$20,2,1),1)))","v":1},2,1,{"$f":"IF(R7=1,\"하\",IF(R7=2,\"중\",IF(R7=3,\"상\",\"\")))","v":"하"},2.4999999999999996,null,null,{"$f":"IF(R7=\"\",\"\",IF(R7=1,IF(T7>MIN(V$16,V$20),2,1),IF(R7=2,IF(T7>V$20,2,1),1)))","v":1},2,1,{"$f":"IF(Y7=1,\"하\",IF(Y7=2,\"중\",IF(Y7=3,\"상\",\"\")))","v":"하"},2.4999999999999996,null,null,{"$f":"IF(Y7=\"\",\"\",IF(Y7=1,IF(AA7>MIN(AC$16,AC$20),2,1),IF(Y7=2,IF(AA7>AC$20,2,1),1)))","v":1},2,"중"]
[null,null,3,1,"하",2.2999999999999994,null,"역배점",1,3,1,"하",2.6999999999999997,null,"역배점",1,3,1,"하",2.5999999999999996,null,"역배점",1,3,1,"하",2.5999999999999996,null,"역배점",1,3,"상"]
[null,null,4,1,"하",2.2999999999999994,null,"검토",1,4,1,"하",2.6999999999999997,null,"검토",1,4,1,"하",2.5999999999999996,null,"검토",1,4,1,"하",2.5999999999999996,null,"검토",1]
[null,null,5,1,"하",2.3999999999999995,null,null,1,5,1,"하",2.9,null,null,1,5,1,"하",2.6999999999999997,null,null,1,5,1,"하",2.6999999999999997,null,null,1,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,6,1,"하",2.3999999999999995,null,"하",1,6,1,"하",2.9,null,"하",1,6,1,"하",2.6999999999999997,null,"하",1,6,1,"하",2.6999999999999997,null,"하",1,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,7,1,"하",2.3999999999999995,"최저",{"$f":"INDEX(F$6:F$45,MATCH(MIN(IF(D$6:D$45=1,D$6:D$45,7)*IF(F$6:F$45=\"\",7,F$6:F$45)*1),F$6:F$45,0),)","v":2.1999999999999993},1,7,1,"하",2.9,"최저",{"$f":"INDEX(M$6:M$45,MATCH(MIN(IF(K$6:K$45=1,K$6:K$45,7)*IF(M$6:M$45=\"\",7,M$6:M$45)*1),M$6:M$45,0),)","v":2.5999999999999996},1,7,1,"하",2.6999999999999997,"최저",{"$f":"INDEX(T$6:T$45,MATCH(MIN(IF(R$6:R$45=1,R$6:R$45,7)*IF(T$6:T$45=\"\",7,T$6:T$45)*1),T$6:T$45,0),)","v":2.4999999999999996},1,7,1,"하",2.6999999999999997,"최저",{"$f":"INDEX(AA$6:AA$45,MATCH(MIN(IF(Y$6:Y$45=1,Y$6:Y$45,7)*IF(AA$6:AA$45=\"\",7,AA$6:AA$45)*1),AA$6:AA$45,0),)","v":2.4999999999999996},1]
[null,null,8,1,"하",2.4999999999999996,"최고",{"$f":"INDEX(F$6:F$45,MATCH(MAX((D$6:D$45=1)*F$6:F$45*1),F$6:F$45,0))","v":2.4999999999999996},1,8,1,"하",3,"최고",{"$f":"INDEX(M$6:M$45,MATCH(MAX((K$6:K$45=1)*M$6:M$45*1),M$6:M$45,0))","v":3},1,8,1,"하",2.8,"최고",{"$f":"INDEX(T$6:T$45,MATCH(MAX((R$6:R$45=1)*T$6:T$45*1),T$6:T$45,0))","v":2.8},1,8,1,"하",2.8,"최고",{"$f":"INDEX(AA$6:AA$45,MATCH(MAX((Y$6:Y$45=1)*AA$6:AA$45*1),AA$6:AA$45,0))","v":2.8},1,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,9,1,"하",2.4999999999999996,null,null,1,9,1,"하",3,null,null,1,9,1,"하",2.8,null,null,1,9,1,"하",2.8,null,null,1,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,10,1,"하",2.4999999999999996,null,"중",1,10,1,"하",3,null,"중",1,10,1,"하",2.8,null,"중",1,10,1,"하",2.8,null,"중",1]
[null,null,11,2,"중",2.4999999999999996,"최저",{"$f":"INDEX(F$6:F$45,MATCH(MIN(IF(D$6:D$45=2,1,7)*IF(F$6:F$45=\"\",7,F$6:F$45)*1),F$6:F$45,0),)","v":2.4999999999999996},1,11,2,"중",3,"최저",{"$f":"INDEX(M$6:M$45,MATCH(MIN(IF(K$6:K$45=2,1,7)*IF(M$6:M$45=\"\",7,M$6:M$45)*1),M$6:M$45,0),)","v":3},1,11,2,"중",2.8,"최저",{"$f":"INDEX(T$6:T$45,MATCH(MIN(IF(R$6:R$45=2,1,7)*IF(T$6:T$45=\"\",7,T$6:T$45)*1),T$6:T$45,0),)","v":2.8},1,11,2,"중",2.8,"최저",{"$f":"INDEX(AA$6:AA$45,MATCH(MIN(IF(Y$6:Y$45=2,1,7)*IF(AA$6:AA$45=\"\",7,AA$6:AA$45)*1),AA$6:AA$45,0),)","v":2.8},1,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,12,2,"중",2.4999999999999996,"최고",{"$f":"INDEX(F$6:F$45,MATCH(MAX((D$6:D$45=2)*F$6:F$45),F$6:F$45,0))","v":2.5999999999999996},1,12,2,"중",3,"최고",{"$f":"INDEX(M$6:M$45,MATCH(MAX((K$6:K$45=2)*M$6:M$45),M$6:M$45,0))","v":3.1},1,12,2,"중",2.8,"최고",{"$f":"INDEX(T$6:T$45,MATCH(MAX((R$6:R$45=2)*T$6:T$45),T$6:T$45,0))","v":2.9},1,12,2,"중",2.8,"최고",{"$f":"INDEX(AA$6:AA$45,MATCH(MAX((Y$6:Y$45=2)*AA$6:AA$45),AA$6:AA$45,0))","v":2.9},1,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,13,2,"중",2.5999999999999996,null,null,1,13,2,"중",3,null,null,1,13,2,"중",2.8,null,null,1,13,2,"중",2.8,null,null,1,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,14,2,"중",2.5999999999999996,null,"상",1,14,2,"중",3,null,"상",1,14,2,"중",2.8,null,"상",1,14,2,"중",2.8,null,"상",1,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,15,2,"중",2.5999999999999996,"최저",{"$f":"INDEX(F$6:F$45,MATCH(MIN(IF(D$6:D$45=3,1,7)*IF(F$6:F$45=\"\",7,F$6:F$45)*1),F$6:F$45,0),)","v":2.5999999999999996},1,15,2,"중",3,"최저",{"$f":"INDEX(M$6:M$45,MATCH(MIN(IF(K$6:K$45=3,1,7)*IF(M$6:M$45=\"\",7,M$6:M$45)*1),M$6:M$45,0),)","v":3.1},1,15,2,"중",2.8,"최저",{"$f":"INDEX(T$6:T$45,MATCH(MIN(IF(R$6:R$45=3,1,7)*IF(T$6:T$45=\"\",7,T$6:T$45)*1),T$6:T$45,0),)","v":2.9},1,15,2,"중",2.8,"최저",{"$f":"INDEX(AA$6:AA$45,MATCH(MIN(IF(Y$6:Y$45=3,1,7)*IF(AA$6:AA$45=\"\",7,AA$6:AA$45)*1),AA$6:AA$45,0),)","v":2.9},1,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,16,2,"중",2.5999999999999996,"최고",{"$f":"INDEX(F$6:F$45,MATCH(MAX((D$6:D$45=3)*F$6:F$45),F$6:F$45,0))","v":2.6999999999999997},1,16,2,"중",3.1,"최고",{"$f":"INDEX(M$6:M$45,MATCH(MAX((K$6:K$45=3)*M$6:M$45),M$6:M$45,0))","v":3.3000000000000003},1,16,2,"중",2.8,"최고",{"$f":"INDEX(T$6:T$45,MATCH(MAX((R$6:R$45=3)*T$6:T$45),T$6:T$45,0))","v":3.2},1,16,2,"중",2.8,"최고",{"$f":"INDEX(AA$6:AA$45,MATCH(MAX((Y$6:Y$45=3)*AA$6:AA$45),AA$6:AA$45,0))","v":3.2},1,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,17,2,"중",2.5999999999999996,null,null,1,17,2,"중",3.1,null,null,1,17,2,"중",2.8,null,null,1,17,2,"중",2.8,null,null,1,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,18,2,"중",2.5999999999999996,null,null,1,18,2,"중",3.1,null,null,1,18,2,"중",2.8,null,null,1,18,2,"중",2.8,null,null,1,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,19,2,"중",2.5999999999999996,null,null,1,19,2,"중",3.1,null,null,1,19,2,"중",2.8,null,null,1,19,2,"중",2.8,null,null,1,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,20,2,"중",2.5999999999999996,null,null,1,20,2,"중",3.1,null,null,1,20,2,"중",2.9,null,null,1,20,2,"중",2.9,null,null,1,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,21,2,"중",2.5999999999999996,null,null,1,21,2,"중",3.1,null,null,1,21,2,"중",2.9,null,null,1,21,2,"중",2.9,null,null,1,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,22,2,"중",2.5999999999999996,null,null,1,22,2,"중",3.1,null,null,1,22,2,"중",2.9,null,null,1,22,2,"중",2.9,null,null,1]
[null,null,23,3,"상",2.5999999999999996,null,null,1,23,3,"상",3.1,null,null,1,23,3,"상",2.9,null,null,1,23,3,"상",2.9,null,null,1,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,24,3,"상",2.5999999999999996,null,null,1,24,3,"상",3.1,null,null,1,24,3,"상",2.9,null,null,1,24,3,"상",2.9,null,null,1,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,25,3,"상",2.5999999999999996,null,null,1,25,3,"상",3.1,null,null,1,25,3,"상",2.9,null,null,1,25,3,"상",2.9,null,null,1,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,26,3,"상",2.5999999999999996,null,null,1,26,3,"상",3.2,null,null,1,26,3,"상",3,null,null,1,26,3,"상",3,null,null,1,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,27,3,"상",2.5999999999999996,null,null,1,27,3,"상",3.2,null,null,1,27,3,"상",3,null,null,1,27,3,"상",3,null,null,1]
[null,null,28,3,"상",2.5999999999999996,null,null,1,28,3,"상",3.2,null,null,1,28,3,"상",3,null,null,1,28,3,"상",3,null,null,1]
[null,null,29,3,"상",2.6999999999999997,null,null,1,29,3,"상",3.2,null,null,1,29,3,"상",3,null,null,1,29,3,"상",3,null,null,1]
[null,null,30,3,"상",2.6999999999999997,null,null,1,30,3,"상",3.2,null,null,1,30,3,"상",3,null,null,1,30,3,"상",3,null,null,1]
[null,null,31,3,"상",2.6999999999999997,null,null,1,31,3,"상",3.2,null,null,1,31,3,"상",3.1,null,null,1,31,3,"상",3.1,null,null,1]
[null,null,32,3,"상",2.6999999999999997,null,null,1,32,3,"상",3.2,null,null,1,32,3,"상",3.1,null,null,1,32,3,"상",3.1,null,null,1]
[null,null,33,3,"상",2.6999999999999997,null,null,1,33,3,"상",3.3000000000000003,null,null,1,33,3,"상",3.1,null,null,1,33,3,"상",3.1,null,null,1]
[null,null,34,3,"상",2.6999999999999997,null,null,1,34,null,"",null,null,null,"",34,3,"상",3.2,null,null,1,34,3,"상",3.2,null,null,1]
[null,null,35,3,"상",2.6999999999999997,null,null,1,35,null,{"$f":"IF(K40=1,\"하\",IF(K40=2,\"중\",IF(K40=3,\"상\",\"\")))","v":""},null,null,null,"",35,3,{"$f":"IF(R40=1,\"하\",IF(R40=2,\"중\",IF(R40=3,\"상\",\"\")))","v":"상"},3.2,null,null,1,35,3,"상",3.2,null,null,1]
[null,null,36,3,"상",2.6999999999999997,null,null,1,36,null,"",null,null,null,"",36,null,"",null,null,null,"",36,null,"",null,null,null,""]
[null,null,37,3,"상",2.6999999999999997,null,null,1,37,null,"",null,null,null,"",37,null,"",null,null,null,"",37,null,"",null,null,null,""]
[null,null,38,3,"상",2.6999999999999997,null,null,1,38,null,"",null,null,null,"",38,null,"",null,null,null,"",38,null,"",null,null,null,""]
[null,null,39,3,"상",2.6999999999999997,null,null,1,39,null,"",null,null,null,"",39,null,"",null,null,null,"",39,null,"",null,null,null,""]
[null,null,40,null,"",null,null,null,"",40,null,"",null,null,null,"",40,null,"",null,null,null,"",40,null,"",null,null,null,""]

{"sheet":"비율1~4안","index":5,"n_rows":24,"n_cols":20,"rows_kept":24,"cut":false,"hidden":false,"merged":[[11,3,11,4],[11,12,11,13],[23,3,23,4],[23,12,23,13]]}
[null,null,null,null,"* 서술형 평가는 지필평가 내에서 20% 이상"]
[null,null,null,"1안",null,"시험1","시험2","시험3","시험4","시험5","점검",null,"2안",null,"시험1","시험2","시험3","시험4","시험5","점검"]
[null,null,null,null,null,"중간고사","기말고사","수행평가",null,null,null,null,null,null,"중간고사","기말고사","수행평가"]
[null,null,null,null,"비율",40,40,20,null,null,{"$f":"SUM(F4:J4)","v":100},null,null,"비율",40,40,20,null,null,{"$f":"SUM(O4:S4)","v":100}]
[null,null,null,null,"합계",{"$f":"IF(SUM(F6:F7)=0,\"\",SUM(F6:F7))","v":100},{"$f":"IF(SUM(G6:G7)=0,\"\",SUM(G6:G7))","v":100},"","","",null,null,null,"합계",{"$f":"IF(SUM(O6:O7)=0,\"\",SUM(O6:O7))","v":100},{"$f":"IF(SUM(P6:P7)=0,\"\",SUM(P6:P7))","v":100},"","",""]
[null,null,null,null,"지필",60,80,null,null,null,null,null,null,"지필",60,100]
[null,null,null,null,"서술",40,20,null,null,null,null,null,null,"서술",40]
[null,null,null,null,"수행",null,null,100,null,null,null,null,null,"수행",null,null,100]
[null,null,null,null,{"$f":"IF(E6=\"\",\"\",E6&\" % \")","v":"지필 % "},{"$f":"IF(F6=\"\",\"\",F6*F$4/100)","v":24},{"$f":"IF(G6=\"\",\"\",G6*G$4/100)","v":32},"","","",{"$f":"SUM(F9:J11)","v":100},null,null,{"$f":"IF(N6=\"\",\"\",N6&\" % \")","v":"지필 % "},{"$f":"IF(O6=\"\",\"\",O6*O$4/100)","v":24},{"$f":"IF(P6=\"\",\"\",P6*P$4/100)","v":40},"","","",{"$f":"SUM(O9:S11)","v":100}]
[null,null,null,null,{"$f":"IF(E7=\"\",\"\",E7&\" % \")","v":"서술 % "},{"$f":"IF(F7=\"\",\"\",F7*F$4/100)","v":16},8,"","","",null,null,null,{"$f":"IF(N7=\"\",\"\",N7&\" % \")","v":"서술 % "},{"$f":"IF(O7=\"\",\"\",O7*O$4/100)","v":16},{"$f":"IF(P7=\"\",\"\",P7*P$4/100)","v":""},"","",""]
[null,null,null,null,"수행%",{"$f":"IF(F8=\"\",\"\",F8*F$4/100)","v":""},"",20,"","",null,null,null,"수행%",{"$f":"IF(O8=\"\",\"\",O8*O$4/100)","v":""},{"$f":"IF(P8=\"\",\"\",P8*P$4/100)","v":""},20,"",""]
[null,null,null,"(지필내서술비율)",null,{"$f":"F7*F4/($F$4*SUM($F$6:$F$7)+$G$4*SUM($G$6:$G$7)+$H$4*SUM($H$6:$H$7)+$I$4*SUM($I$6:$I$7)+$J$4*SUM($J$6:$J$7))*100","v":20},{"$f":"G7*G4/($F$4*SUM($F$6:$F$7)+$G$4*SUM($G$6:$G$7)+$H$4*SUM($H$6:$H$7)+$I$4*SUM($I$6:$I$7)+$J$4*SUM($J$6:$J$7))*100","v":10},0,0,0,{"$f":"SUM(F12:J12)","v":30},null,"(지필내서술비율)",null,{"$f":"O7*O4/($O$4*SUM($O$6:$O$7)+$P$4*SUM($P$6:$P$7)+$Q$4*SUM($Q$6:$Q$7)+$R$4*SUM($R$6:$R$7)+$S$4*SUM($S$6:$S$7))*100","v":20},{"$f":"P7*P4/($O$4*SUM($O$6:$O$7)+$P$4*SUM($P$6:$P$7)+$Q$4*SUM($Q$6:$Q$7)+$R$4*SUM($R$6:$R$7)+$S$4*SUM($S$6:$S$7))*100","v":0},0,0,0,{"$f":"SUM(O12:S12)","v":20}]
[]
[null,null,null,"3안",null,"시험1","시험2","시험3","시험4","시험5","점검",null,"4안",null,"시험1","시험2","시험3","시험4","시험5","점검"]
[null,null,null,null,null,"중간고사","기말고사","수행평가",null,null,null,null,null,null,"중간고사","기말고사","수행평가"]
[null,null,null,null,"비율",32,48,20,null,null,{"$f":"SUM(F16:J16)","v":100},null,null,"비율",20,30,50,null,null,{"$f":"SUM(O16:S16)","v":100}]
[null,null,null,null,"합계",{"$f":"IF(SUM(F18:F19)=0,\"\",SUM(F18:F19))","v":100},{"$f":"IF(SUM(G18:G19)=0,\"\",SUM(G18:G19))","v":100},"","","",null,null,null,"합계",{"$f":"IF(SUM(O18:O19)=0,\"\",SUM(O18:O19))","v":100},{"$f":"IF(SUM(P18:P19)=0,\"\",SUM(P18:P19))","v":100},"","",""]
[null,null,null,null,"지필",45,100,null,null,null,null,null,null,"지필",100,50]
[null,null,null,null,"서술",55,null,null,null,null,null,null,null,"서술",null,50]
[null,null,null,null,"수행",null,null,100,null,null,null,null,null,"수행",null,null,100]
[null,null,null,null,{"$f":"IF(E18=\"\",\"\",E18&\" % \")","v":"지필 % "},{"$f":"IF(F18=\"\",\"\",F18*F$4/100)","v":18},{"$f":"IF(G18=\"\",\"\",G18*G$4/100)","v":40},"","","",{"$f":"SUM(F21:J23)","v":100},null,null,{"$f":"IF(N18=\"\",\"\",N18&\" % \")","v":"지필 % "},{"$f":"IF(O18=\"\",\"\",O18*O$4/100)","v":40},{"$f":"IF(P18=\"\",\"\",P18*P$4/100)","v":20},"","","",{"$f":"SUM(O21:S23)","v":100}]
[null,null,null,null,{"$f":"IF(E19=\"\",\"\",E19&\" % \")","v":"서술 % "},{"$f":"IF(F19=\"\",\"\",F19*F$4/100)","v":22},{"$f":"IF(G19=\"\",\"\",G19*G$4/100)","v":""},"","","",null,null,null,{"$f":"IF(N19=\"\",\"\",N19&\" % \")","v":"서술 % "},{"$f":"IF(O19=\"\",\"\",O19*O$4/100)","v":""},{"$f":"IF(P19=\"\",\"\",P19*P$4/100)","v":20},"","",""]
[null,null,null,null,"수행%",{"$f":"IF(F20=\"\",\"\",F20*F$4/100)","v":""},{"$f":"IF(G20=\"\",\"\",G20*G$4/100)","v":""},20,"","",null,null,null,"수행%",{"$f":"IF(O20=\"\",\"\",O20*O$4/100)","v":""},{"$f":"IF(P20=\"\",\"\",P20*P$4/100)","v":""},20,"",""]
[null,null,null,"(지필내서술비율)",null,{"$f":"F19*F16/($F$16*SUM($F$18:$F$19)+$G$16*SUM($G$18:$G$19)+$H$16*SUM($H$18:$H$19)+$I$16*SUM($I$18:$I$19)+$J$16*SUM($J$18:$J$19))*100","v":22},{"$f":"G19*G16/($F$16*SUM($F$18:$F$19)+$G$16*SUM($G$18:$G$19)+$H$16*SUM($H$18:$H$19)+$I$16*SUM($I$18:$I$19)+$J$16*SUM($J$18:$J$19))*100","v":0},0,0,0,{"$f":"SUM(F24:J24)","v":22},null,"(지필내서술비율)",null,{"$f":"O19*O16/($O$16*SUM($O$18:$O$19)+$P$16*SUM($P$18:$P$19)+$Q$16*SUM($Q$18:$Q$19)+$R$16*SUM($R$18:$R$19)+$S$16*SUM($S$18:$S$19))*100","v":0},{"$f":"P19*P16/($O$16*SUM($O$18:$O$19)+$P$16*SUM($P$18:$P$19)+$Q$16*SUM($Q$18:$Q$19)+$R$16*SUM($R$18:$R$19)+$S$16*SUM($S$18:$S$19))*100","v":30},0,0,0,{"$f":"SUM(O24:S24)","v":30}]

{"sheet":"비율5~8안","index":6,"n_rows":24,"n_cols":20,"rows_kept":24,"cut":false,"hidden":false,"merged":[[11,3,11,4],[11,12,11,13],[23,3,23,4],[23,12,23,13]]}
[null,null,null,null,"* 서술형 평가는 지필평가 내에서 20% 이상"]
[null,null,null,"5안",null,"시험1","시험2","시험3","시험4","시험5","점검",null,"6안",null,"시험1","시험2","시험3","시험4","시험5","점검"]
[null,null,null,null,null,"중간고사","기말고사","수행평가",null,null,null,null,null,null,"중간고사","기말고사","수행평가"]
[null,null,null,null,"비율",35,45,20,null,null,{"$f":"SUM(F4:J4)","v":100},null,null,"비율",35,45,20,null,null,{"$f":"SUM(O4:S4)","v":100}]
[null,null,null,null,"합계",{"$f":"IF(SUM(F6:F7)=0,\"\",SUM(F6:F7))","v":100},{"$f":"IF(SUM(G6:G7)=0,\"\",SUM(G6:G7))","v":100},"","","",null,null,null,"합계",{"$f":"IF(SUM(O6:O7)=0,\"\",SUM(O6:O7))","v":100},{"$f":"IF(SUM(P6:P7)=0,\"\",SUM(P6:P7))","v":100},"","",""]
[null,null,null,null,"지필",50,100,null,null,null,null,null,null,"지필",54,100]
[null,null,null,null,"서술",50,null,null,null,null,null,null,null,"서술",46]
[null,null,null,null,"수행",null,null,100,null,null,null,null,null,"수행",null,null,100]
[null,null,null,null,{"$f":"IF(E6=\"\",\"\",E6&\" % \")","v":"지필 % "},{"$f":"IF(F6=\"\",\"\",F6*F$4/100)","v":17.5},{"$f":"IF(G6=\"\",\"\",G6*G$4/100)","v":45},"","","",{"$f":"SUM(F9:J11)","v":100},null,null,{"$f":"IF(N6=\"\",\"\",N6&\" % \")","v":"지필 % "},{"$f":"IF(O6=\"\",\"\",O6*O$4/100)","v":18.899999999999999},{"$f":"IF(P6=\"\",\"\",P6*P$4/100)","v":45},"","","",{"$f":"SUM(O9:S11)","v":100}]
[null,null,null,null,{"$f":"IF(E7=\"\",\"\",E7&\" % \")","v":"서술 % "},{"$f":"IF(F7=\"\",\"\",F7*F$4/100)","v":17.5},"","","","",null,null,null,{"$f":"IF(N7=\"\",\"\",N7&\" % \")","v":"서술 % "},{"$f":"IF(O7=\"\",\"\",O7*O$4/100)","v":16.100000000000001},"","","",""]
[null,null,null,null,"수행%",{"$f":"IF(F8=\"\",\"\",F8*F$4/100)","v":""},"",20,"","",null,null,null,"수행%",{"$f":"IF(O8=\"\",\"\",O8*O$4/100)","v":""},"",20,"",""]
[null,null,null,"(지필내서술비율)",null,{"$f":"F7*F4/($F$4*SUM($F$6:$F$7)+$G$4*SUM($G$6:$G$7)+$H$4*SUM($H$6:$H$7)+$I$4*SUM($I$6:$I$7)+$J$4*SUM($J$6:$J$7))*100","v":21.875},{"$f":"G7*G4/($F$4*SUM($F$6:$F$7)+$G$4*SUM($G$6:$G$7)+$H$4*SUM($H$6:$H$7)+$I$4*SUM($I$6:$I$7)+$J$4*SUM($J$6:$J$7))*100","v":0},0,0,0,{"$f":"SUM(F12:J12)","v":21.875},null,"(지필내서술비율)",null,{"$f":"O7*O4/($O$4*SUM($O$6:$O$7)+$P$4*SUM($P$6:$P$7)+$Q$4*SUM($Q$6:$Q$7)+$R$4*SUM($R$6:$R$7)+$S$4*SUM($S$6:$S$7))*100","v":20.125},{"$f":"P7*P4/($O$4*SUM($O$6:$O$7)+$P$4*SUM($P$6:$P$7)+$Q$4*SUM($Q$6:$Q$7)+$R$4*SUM($R$6:$R$7)+$S$4*SUM($S$6:$S$7))*100","v":0},0,0,0,{"$f":"SUM(O12:S12)","v":20.125}]
[]
[null,null,null,"7안",null,"시험1","시험2","시험3","시험4","시험5","점검",null,"8안",null,"시험1","시험2","시험3","시험4","시험5","점검"]
[null,null,null,null,null,"중간고사","기말고사","수행평가",null,null,null,null,null,null,"중간고사","기말고사","수행평가"]
[null,null,null,null,"비율",30,50,20,null,null,{"$f":"SUM(F16:J16)","v":100},null,null,"비율",20,30,50,null,null,{"$f":"SUM(O16:S16)","v":100}]
[null,null,null,null,"합계",{"$f":"IF(SUM(F18:F19)=0,\"\",SUM(F18:F19))","v":100},{"$f":"IF(SUM(G18:G19)=0,\"\",SUM(G18:G19))","v":100},"","","",null,null,null,"합계",{"$f":"IF(SUM(O18:O19)=0,\"\",SUM(O18:O19))","v":100},{"$f":"IF(SUM(P18:P19)=0,\"\",SUM(P18:P19))","v":100},"","",""]
[null,null,null,null,"지필",45,100,null,null,null,null,null,null,"지필",100,65]
[null,null,null,null,"서술",55,null,null,null,null,null,null,null,"서술",null,35]
[null,null,null,null,"수행",null,null,100,null,null,null,null,null,"수행",null,null,100]
[null,null,null,null,{"$f":"IF(E18=\"\",\"\",E18&\" % \")","v":"지필 % "},{"$f":"IF(F18=\"\",\"\",F18*F$4/100)","v":15.75},{"$f":"IF(G18=\"\",\"\",G18*G$4/100)","v":45},"","","",{"$f":"SUM(F21:J23)","v":100},null,null,{"$f":"IF(N18=\"\",\"\",N18&\" % \")","v":"지필 % "},{"$f":"IF(O18=\"\",\"\",O18*O$4/100)","v":35},{"$f":"IF(P18=\"\",\"\",P18*P$4/100)","v":29.25},"","","",{"$f":"SUM(O21:S23)","v":100}]
[null,null,null,null,{"$f":"IF(E19=\"\",\"\",E19&\" % \")","v":"서술 % "},{"$f":"IF(F19=\"\",\"\",F19*F$4/100)","v":19.25},"","","","",null,null,null,{"$f":"IF(N19=\"\",\"\",N19&\" % \")","v":"서술 % "},{"$f":"IF(O19=\"\",\"\",O19*O$4/100)","v":""},15.75,"","",""]
[null,null,null,null,"수행%",{"$f":"IF(F20=\"\",\"\",F20*F$4/100)","v":""},"",20,"","",null,null,null,"수행%",{"$f":"IF(O20=\"\",\"\",O20*O$4/100)","v":""},"",20,"",""]
[null,null,null,"(지필내서술비율)",null,{"$f":"F19*F16/($F$16*SUM($F$18:$F$19)+$G$16*SUM($G$18:$G$19)+$H$16*SUM($H$18:$H$19)+$I$16*SUM($I$18:$I$19)+$J$16*SUM($J$18:$J$19))*100","v":20.625},{"$f":"G19*G16/($F$16*SUM($F$18:$F$19)+$G$16*SUM($G$18:$G$19)+$H$16*SUM($H$18:$H$19)+$I$16*SUM($I$18:$I$19)+$J$16*SUM($J$18:$J$19))*100","v":0},0,0,0,{"$f":"SUM(F24:J24)","v":20.625},null,"(지필내서술비율)",null,{"$f":"O19*O16/($O$16*SUM($O$18:$O$19)+$P$16*SUM($P$18:$P$19)+$Q$16*SUM($Q$18:$Q$19)+$R$16*SUM($R$18:$R$19)+$S$16*SUM($S$18:$S$19))*100","v":0},{"$f":"P19*P16/($O$16*SUM($O$18:$O$19)+$P$16*SUM($P$18:$P$19)+$Q$16*SUM($Q$18:$Q$19)+$R$16*SUM($R$18:$R$19)+$S$16*SUM($S$18:$S$19))*100","v":21},{"$f":"Q19*Q16/($O$16*SUM($O$18:$O$19)+$P$16*SUM($P$18:$P$19)+$Q$16*SUM($Q$18:$Q$19)+$R$16*SUM($R$18:$R$19)+$S$16*SUM($S$18:$S$19))*100","v":0},0,0,{"$f":"SUM(O24:S24)","v":21}]