{"text_format":"3","workbook":"xlsx","n_sheets":7,"sheets":["논문발표현황","부분합","필터","매크로","피벗테이블 정답","피벗테이블","차트"],"not_rendered":{"charts":1,"images":1,"macros":1,"defined_names":3,"pivot_tables":1},"read":"whole","date_system":"1900"}

{"sheet":"논문발표현황","index":0,"n_rows":15,"n_cols":8,"rows_kept":15,"merged":[[12,0,12,3],[12,4,12,5],[12,6,14,7],[13,0,13,3],[13,4,13,5],[14,0,14,3],[14,4,14,5]]}
[]
["학술자료","분류","2011년","2012년","2013년","합계","순위","비고"]
["역사학","인문과학",{"v":11179,"d":"11,179"},{"v":8255,"d":"8,255"},{"v":6346,"d":"6,346"},{"$f":"SUM(C3:E3)","v":{"v":25780,"d":"25,780"}},{"$f":"RANK(E3,$E$3:$E$12)","v":{"v":10,"d":"10위"}},{"$f":"IF(F3>=30000,\"우수\",\"\")","v":""}]
["경영학","사회과학",{"v":21604,"d":"21,604"},{"v":17633,"d":"17,633"},{"v":15126,"d":"15,126"},{"$f":"SUM(C4:E4)","v":{"v":54363,"d":"54,363"}},{"$f":"RANK(E4,$E$3:$E$12)","v":{"v":3,"d":"3위"}},{"$f":"IF(F4>=30000,\"우수\",\"\")","v":"우수"}]
["경제학","사회과학",{"v":22353,"d":"22,353"},{"v":14653,"d":"14,653"},{"v":13400,"d":"13,400"},{"v":50406,"d":"50,406"},{"v":4,"d":"4위"},"우수"]
["건축공학","공학",{"v":17147,"d":"17,147"},{"v":17278,"d":"17,278"},{"v":11371,"d":"11,371"},{"v":45796,"d":"45,796"},{"v":5,"d":"5위"},"우수"]
["언어학","인문과학",{"v":10712,"d":"10,712"},{"v":9304,"d":"9,304"},{"v":8403,"d":"8,403"},{"v":28419,"d":"28,419"},{"v":7,"d":"7위"},""]
["심리학","사회과학",{"v":16505,"d":"16,505"},{"v":9580,"d":"9,580"},{"v":8509,"d":"8,509"},{"v":34594,"d":"34,594"},{"v":6,"d":"6위"},"우수"]
["문학","인문과학",{"v":10053,"d":"10,053"},{"v":8575,"d":"8,575"},{"v":6712,"d":"6,712"},{"v":25340,"d":"25,340"},{"v":9,"d":"9위"},""]
["재료공학","공학",{"v":20661,"d":"20,661"},{"v":18551,"d":"18,551"},{"v":15926,"d":"15,926"},{"v":55138,"d":"55,138"},{"v":1,"d":"1위"},"우수"]
["생명공학","의약학",{"v":13540,"d":"13,540"},{"v":9059,"d":"9,059"},{"v":15589,"d":"15,589"},{"v":38188,"d":"38,188"},{"v":2,"d":"2위"},"우수"]
["약학","의약학",{"v":11604,"d":"11,604"},{"v":8397,"d":"8,397"},{"v":7569,"d":"7,569"},{"v":27570,"d":"27,570"},{"v":8,"d":"8위"},""]
["분류가 '인문과학'인 2013년의 평균",{"$nulls":3},{"$f":"DAVERAGE(A2:H12,E2,B2:B3)","v":{"v":7153.666666666667,"d":"7,154"}}]
["합계의 최대값-최소값 차이",{"$nulls":3},{"$f":"MAX(F3:F12)-MIN(F3:F12)","v":{"v":29798,"d":"29,798"}}]
["분류가 '사회과학'인 건수",{"$nulls":3},{"$f":"COUNTIF(B3:B12,\"사회과학\")","v":{"v":3,"d":"3건"}}]

{"sheet":"부분합","index":1,"n_rows":22,"n_cols":6,"rows_kept":22}
[]
["학술자료","분류","2011년","2012년","2013년","합계"]
["건축공학","공학",{"v":17147,"d":"17,147"},{"v":17278,"d":"17,278"},{"v":11371,"d":"11,371"},{"v":45796,"d":"45,796"}]
["재료공학","공학",{"v":20661,"d":"20,661"},{"v":18551,"d":"18,551"},{"v":15926,"d":"15,926"},{"v":55138,"d":"55,138"}]
[null,"공학 최대값",null,null,{"$f":"SUBTOTAL(4,E3:E4)","v":{"v":15926,"d":"15,926"}}]
[null,"공학 평균",{"$f":"SUBTOTAL(1,C3:C4)","v":{"v":18904,"d":"18,904"}},{"$f":"SUBTOTAL(1,D3:D4)","v":{"v":17914.5,"d":"17,915"}}]
["경영학","사회과학",{"v":21604,"d":"21,604"},{"v":17633,"d":"17,633"},{"v":15126,"d":"15,126"},{"v":54363,"d":"54,363"}]
["경제학","사회과학",{"v":22353,"d":"22,353"},{"v":14653,"d":"14,653"},{"v":13400,"d":"13,400"},{"v":50406,"d":"50,406"}]
["심리학","사회과학",{"v":16505,"d":"16,505"},{"v":9580,"d":"9,580"},{"v":8509,"d":"8,509"},{"v":34594,"d":"34,594"}]
[null,"사회과학 최대값",null,null,{"$f":"SUBTOTAL(4,E7:E9)","v":{"v":15126,"d":"15,126"}}]
[null,"사회과학 평균",{"$f":"SUBTOTAL(1,C7:C9)","v":{"v":20154,"d":"20,154"}},{"$f":"SUBTOTAL(1,D7:D9)","v":{"v":13955.333333333334,"d":"13,955"}}]
["생명공학","의약학",{"v":13540,"d":"13,540"},{"v":9059,"d":"9,059"},{"v":15589,"d":"15,589"},{"v":38188,"d":"38,188"}]
["약학","의약학",{"v":11604,"d":"11,604"},{"v":8397,"d":"8,397"},{"v":7569,"d":"7,569"},{"v":27570,"d":"27,570"}]
[null,"의약학 최대값",null,null,{"$f":"SUBTOTAL(4,E12:E13)","v":{"v":15589,"d":"15,589"}}]
[null,"의약학 평균",{"$f":"SUBTOTAL(1,C12:C13)","v":{"v":12572,"d":"12,572"}},{"$f":"SUBTOTAL(1,D12:D13)","v":{"v":8728,"d":"8,728"}}]
["역사학","인문과학",{"v":11179,"d":"11,179"},{"v":8255,"d":"8,255"},{"v":6346,"d":"6,346"},{"v":25780,"d":"25,780"}]
["언어학","인문과학",{"v":10712,"d":"10,712"},{"v":9304,"d":"9,304"},{"v":8403,"d":"8,403"},{"v":28419,"d":"28,419"}]
["문학","인문과학",{"v":10053,"d":"10,053"},{"v":8575,"d":"8,575"},{"v":6712,"d":"6,712"},{"v":25340,"d":"25,340"}]
[null,"인문과학 최대값",null,null,{"$f":"SUBTOTAL(4,E16:E18)","v":{"v":8403,"d":"8,403"}}]
[null,"인문과학 평균",{"$f":"SUBTOTAL(1,C16:C18)","v":{"v":10648,"d":"10,648"}},{"$f":"SUBTOTAL(1,D16:D18)","v":{"v":8711.333333333334,"d":"8,711"}}]
[null,"전체 최대값",null,null,{"$f":"SUBTOTAL(4,E3:E18)","v":{"v":15926,"d":"15,926"}}]
[null,"전체 평균",{"$f":"SUBTOTAL(1,C3:C18)","v":{"v":15535.8,"d":"15,536"}},{"$f":"SUBTOTAL(1,D3:D18)","v":{"v":12128.5,"d":"12,129"}}]

{"sheet":"필터","index":2,"n_rows":21,"n_cols":6,"rows_kept":21}
[]
["학술자료","분류","2011년","2012년","2013년","합계"]
["역사학","인문과학",{"v":11179,"d":"11,179"},{"v":8255,"d":"8,255"},{"v":6346,"d":"6,346"},{"v":25780,"d":"25,780"}]
["경영학","사회과학",{"v":21604,"d":"21,604"},{"v":17633,"d":"17,633"},{"v":15126,"d":"15,126"},{"v":54363,"d":"54,363"}]
["경제학","사회과학",{"v":22353,"d":"22,353"},{"v":14653,"d":"14,653"},{"v":13400,"d":"13,400"},{"v":50406,"d":"50,406"}]
["건축공학","공학",{"v":17147,"d":"17,147"},{"v":17278,"d":"17,278"},{"v":11371,"d":"11,371"},{"v":45796,"d":"45,796"}]
["언어학","인문과학",{"v":10712,"d":"10,712"},{"v":9304,"d":"9,304"},{"v":8403,"d":"8,403"},{"v":28419,"d":"28,419"}]
["심리학","사회과학",{"v":16505,"d":"16,505"},{"v":9580,"d":"9,580"},{"v":8509,"d":"8,509"},{"v":34594,"d":"34,594"}]
["문학","인문과학",{"v":10053,"d":"10,053"},{"v":8575,"d":"8,575"},{"v":6712,"d":"6,712"},{"v":25340,"d":"25,340"}]
["재료공학","공학",{"v":20661,"d":"20,661"},{"v":18551,"d":"18,551"},{"v":15926,"d":"15,926"},{"v":55138,"d":"55,138"}]
["생명공학","의약학",{"v":13540,"d":"13,540"},{"v":9059,"d":"9,059"},{"v":15589,"d":"15,589"},{"v":38188,"d":"38,188"}]
["약학","의약학",{"v":11604,"d":"11,604"},{"v":8397,"d":"8,397"},{"v":7569,"d":"7,569"},{"v":27570,"d":"27,570"}]
[]
["조건"]
[{"$f":"OR(B3=\"공학\",F3>=50000)","v":false}]
[]
["학술자료","분류","2013년","합계"]
["경영학","사회과학",{"v":15126,"d":"15,126"},{"v":54363,"d":"54,363"}]
["경제학","사회과학",{"v":13400,"d":"13,400"},{"v":50406,"d":"50,406"}]
["건축공학","공학",{"v":11371,"d":"11,371"},{"v":45796,"d":"45,796"}]
["재료공학","공학",{"v":15926,"d":"15,926"},{"v":55138,"d":"55,138"}]

{"sheet":"매크로","index":3,"n_rows":12,"n_cols":6,"rows_kept":12}
[]
["학술자료","분류","2011년","2012년","2013년","합계"]
["역사학","인문과학",{"v":11179,"d":"11,179"},{"v":8255,"d":"8,255"},{"v":6346,"d":"6,346"},{"v":25780,"d":"25,780"}]
["경영학","사회과학",{"v":21604,"d":"21,604"},{"v":17633,"d":"17,633"},{"v":15126,"d":"15,126"},{"v":54363,"d":"54,363"}]
["경제학","사회과학",{"v":22353,"d":"22,353"},{"v":14653,"d":"14,653"},{"v":13400,"d":"13,400"},{"v":50406,"d":"50,406"}]
["건축공학","공학",{"v":17147,"d":"17,147"},{"v":17278,"d":"17,278"},{"v":11371,"d":"11,371"},{"v":45796,"d":"45,796"}]
["언어학","인문과학",{"v":10712,"d":"10,712"},{"v":9304,"d":"9,304"},{"v":8403,"d":"8,403"},{"v":28419,"d":"28,419"}]
["심리학","사회과학",{"v":16505,"d":"16,505"},{"v":9580,"d":"9,580"},{"v":8509,"d":"8,509"},{"v":34594,"d":"34,594"}]
["문학","인문과학",{"v":10053,"d":"10,053"},{"v":8575,"d":"8,575"},{"v":6712,"d":"6,712"},{"v":25340,"d":"25,340"}]
["재료공학","공학",{"v":20661,"d":"20,661"},{"v":18551,"d":"18,551"},{"v":15926,"d":"15,926"},{"v":55138,"d":"55,138"}]
["생명공학","의약학",{"v":13540,"d":"13,540"},{"v":9059,"d":"9,059"},{"v":15589,"d":"15,589"},{"v":38188,"d":"38,188"}]
["약학","의약학",{"v":11604,"d":"11,604"},{"v":8397,"d":"8,397"},{"v":7569,"d":"7,569"},{"v":27570,"d":"27,570"}]

{"sheet":"피벗테이블 정답","index":4,"n_rows":13,"n_cols":6,"rows_kept":13,"merged":[[4,0,6,0],[7,0,9,0],[10,0,10,1],[11,0,11,1],[12,0,12,1]]}
[]
[]
[null,null,"학술자료"]
["분류","값","건축공학","생명공학","약학","재료공학"]
["공학","평균 : 2011년",{"v":17147,"d":"17,147"},"**","**",{"v":20661,"d":"20,661"}]
[null,"평균 : 2012년",{"v":17278,"d":"17,278"},"**","**",{"v":18551,"d":"18,551"}]
[null,"평균 : 2013년",{"v":11371,"d":"11,371"},"**","**",{"v":15926,"d":"15,926"}]
["의약학","평균 : 2011년","**",{"v":13540,"d":"13,540"},{"v":11604,"d":"11,604"},"**"]
[null,"평균 : 2012년","**",{"v":9059,"d":"9,059"},{"v":8397,"d":"8,397"},"**"]
[null,"평균 : 2013년","**",{"v":15589,"d":"15,589"},{"v":7569,"d":"7,569"},"**"]
["전체 평균 : 2011년",null,{"v":17147,"d":"17,147"},{"v":13540,"d":"13,540"},{"v":11604,"d":"11,604"},{"v":20661,"d":"20,661"}]
["전체 평균 : 2012년",null,{"v":17278,"d":"17,278"},{"v":9059,"d":"9,059"},{"v":8397,"d":"8,397"},{"v":18551,"d":"18,551"}]
["전체 평균 : 2013년",null,{"v":11371,"d":"11,371"},{"v":15589,"d":"15,589"},{"v":7569,"d":"7,569"},{"v":15926,"d":"15,926"}]

{"sheet":"피벗테이블","index":5,"n_rows":12,"n_cols":6,"rows_kept":12}
[]
["학술자료","분류","2011년","2012년","2013년","합계"]
["역사학","인문과학",11179,8255,6346,25780]
["경영학","사회과학",21604,17633,15126,54363]
["경제학","사회과학",22353,14653,13400,50406]
["건축공학","공학",17147,17278,11371,45796]
["언어학","인문과학",10712,9304,8403,28419]
["심리학","사회과학",16505,9580,8509,34594]
["문학","인문과학",10053,8575,6712,25340]
["재료공학","공학",20661,18551,15926,55138]
["생명공학","의약학",13540,9059,15589,38188]
["약학","의약학",11604,8397,7569,27570]

{"sheet":"차트","index":6,"n_rows":5,"n_cols":4,"rows_kept":5}
[]
["학술자료","2011년","2012년","2013년"]
["경영학",{"v":21604,"d":"21,604"},{"v":17633,"d":"17,633"},{"v":15126,"d":"15,126"}]
["경제학",{"v":22353,"d":"22,353"},{"v":14653,"d":"14,653"},{"v":13400,"d":"13,400"}]
["심리학",{"v":16505,"d":"16,505"},{"v":9580,"d":"9,580"},{"v":8509,"d":"8,509"}]