{"text_format":"2","workbook":"xlsx","n_sheets":3,"sheets":["등록금","에너지","2021-2 장학선정"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":4,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":9,"rows_kept":34,"cut":false,"hidden":false,"merged":[[31,1,33,1],[25,1,27,1],[28,1,30,1],[21,1,21,8],[14,1,16,1],[9,4,9,8],[17,1,19,1],[0,1,0,8],[7,1,7,8],[23,1,24,1],[23,2,24,2],[23,3,24,3],[23,4,23,8],[9,1,10,1],[9,3,10,3],[9,2,10,2],[11,1,13,1]]}
[null,"2021 등록금 "]
[]
[{"$nulls":4},"이학","공학"]
[null,null,null,"전공","에너지물리\n 에너지화학","화공재료환경"]
[null,null,null,"수업료",5380000,6225000]
[]
[]
[null,"에너지시스템 장학내용(공학과정)"]
[]
[null,"과정","장학이름","배정비율","공학"]
[{"$nulls":4},"장학내용","감면금액","BK지원금","교비지원금","합계"]
[null,"석사","에너지특별장학S",0.3,"등록금 25% 감면 \n+BK지원금(70만원)",{"$f":"F5*0.25","v":1556250},4200000,0,{"$f":"F12+G12+H12","v":5756250}]
[null,null,"에너지우수장학A",0.4,"등록금 10% 감면 \n+BK지원금(70만원)",{"$f":"F5*0.1","v":622500},4200000,0,4822500]
[null,null,"에너지연구장학B",0.3,"등록금 5% 감면\n+교비지원금(60만원)",{"$f":"F5*0.05","v":311250},0,3600000,3911250]
[null,"박사","에너지BK장학S",0.2,"등록금 25% 감면 \n+BK지원금(130만원)\n+교비지원금(20만원)",{"$f":"F5*0.25","v":1556250},7800000,1200000,10556250]
[null,null,"에너지BK장학A",0.5,"등록금 20% 감면 \n+BK지원금(130만원)",{"$f":"F5*0.2","v":1245000},7800000,0,9045000]
[null,null,"에너지아주장학B",0.3,"등록금 45% 감면 \n+교비지원금(80만원)",{"$f":"F5*0.45","v":2801250},0,4800000,7601250]
[null,"박사\n수료","에너지BK장학S",0.2,"BK지원금(100만원)\n+교비지원금(20만원)",null,6000000,1200000,7200000]
[null,null,"에너지BK장학A",0.5,"BK지원금(100만원)",null,6000000,null,6000000]
[null,null,"에너지아주장학B",0.3,"교비지원금(80만원)",null,null,4800000,4800000]
[]
[null,"에너지시스템 장학내용(이학과정)"]
[]
[null,"과정","장학이름","배정비율","이학"]
[{"$nulls":4},"장학내용","감면금액","BK지원금","교비지원금","합계"]
[null,"석사","에너지특별장학S",0.3,"등록금 25% 감면 \n+BK지원금(70만원)",{"$f":"E5*0.25","v":1345000},4200000,0,{"$f":"F26+G26+H26","v":5545000}]
[null,null,"에너지우수장학A",0.4,"등록금 10% 감면\n+BK지원금(70만원)",{"$f":"E5*0.1","v":538000},4200000,0,4738000]
[null,null,"에너지연구장학B",0.3,"교비지원금(60만원)",{"$f":"F5*0","v":0},0,3600000,3600000]
[null,"박사","에너지BK장학S",0.2,"등록금 25% 감면 \n+BK지원금(130만원)\n+교비지원금(20만원)",{"$f":"E5*0.25","v":1345000},7800000,1200000,10345000]
[null,null,"에너지BK장학A",0.5,"등록금 20% 감면 \n+BK지원금(130만원)",{"$f":"E5*0.2","v":1076000},7800000,0,8876000]
[null,null,"에너지아주장학B",0.3,"등록금 45% 감면 \n+교비지원금(80만원)",{"$f":"E5*0.45","v":2421000},0,4800000,7221000]
[null,"박사 \n수료","에너지BK장학S",0.2,"BK지원금(100만원)\n+교비지원금(20만원)",null,6000000,1200000,7200000]
[null,null,"에너지BK장학A",0.5,"BK지원금(100만원)",null,6000000,null,6000000]
[null,null,"에너지아주장학B",0.3,"교비지원금(80만원)",null,null,4800000,4800000]

{"sheet":"에너지","index":1,"n_rows":14,"n_cols":24,"rows_kept":14,"cut":false,"hidden":true,"merged":[[3,10,4,10],[3,11,4,11],[3,12,3,21]]}
[]
["에너지"]
[]
["연번","이름","지도교수","과정","2020-2\n기준 학기","총점","장학(안)","비고","학번",null,"배정\n비율","장학내용","공학"]
["에너지","NOORFATIMA NADYA","정재성","석사",4,null,null,"외국인연구장학(석사 60%)",201924262,null,null,null,"감면금액","BK지원금",null,"합계","배정인원",null,"감면금액","BK지원금",null,"교비지원금",null,"공학"]
[{"$nulls":10},"석사","등록금의 40%",{"$f":"X7*40%","v":2463200},null,null,{"$f":"SUM(M6:O6)","v":2463200},1,null,{"$f":"M6*(Q6-1)","v":0},{"$f":"N6*(Q6)","v":0},{"$f":"O6*Q6","v":0},null,null,"화공재료"]
["연번","이름","지도교수","과정","2020-2\n기준 학기","총점","장학(안)","비고","학번",null,"박사","등록금의 80%",{"$f":"X7*80%","v":4926400},null,null,{"$f":"SUM(M7:O7)","v":4926400},7,null,{"$f":"M7*(Q7-4)","v":14779200},{"$f":"N7*(Q7-0)","v":0},{"$f":"O7*R7","v":0},{"$f":"N7*(0)","v":0},null,6158000]
["에너지","ISHFAQ MUHAMMAD","정재성","박사",2,null,null,null,202025695,null,null,"* 대학원 일반 장학 비율",{"$nulls":6},{"$f":"SUM(S6:S7)","v":14779200},{"$f":"SUM(T6:T7)","v":0},{"$f":"SUM(U6:U7)","v":0},{"$f":"SUM(V6:V7)","v":0}]
["에너지","WIDIPUTRA VICTOR","정재성","박사",8,null,null,"인도네시아/외국인A/수료",201725198]
["에너지","공준혁","정재성","통합(박사)",8,null,null,"수료",201725127]
["에너지","서홍석","원지도 : 김형택","박사",7,null,null,"수료",201725300]
["에너지","양예진","정재성","통합(박사)",6,null,null,null,201824496]
["에너지","장동욱","정재성","박사",4,null,null,null,201925073]
["신입","김문태"]

{"sheet":"2021-2 장학선정","index":2,"n_rows":110,"n_cols":15,"rows_kept":110,"cut":false,"hidden":false,"merged":[[3,10,5,10],[6,10,8,10],[20,10,22,10],[9,10,11,10]]}
[]
["연번","계열","세부전공","학번","장학","장학명","감면액","BK지원금","교비"]
[1,"공학","에너지",202024822,null,"외국인연구장학(석사)",{"$nulls":5},"공학","감면금액","BK지원금","교비지원금"]
[2,"공학","에너지",201924262,null,"외국인연구장학(박사)",{"$nulls":4},"석사","에너지특별장학S",1556250,4200000,0]
[3,"공학","에너지",202025797,null,"박사연구장학",{"$f":"6225000*80%","v":4980000},{"$nulls":4},"에너지우수장학A",622500,4200000,0]
[4,"공학","에너지환경공학",202124171,"S","에너지특별장학S",1556250,4200000,0,null,null,"에너지연구장학B",311250,0,3600000]
[5,"공학","에너지환경공학",202124168,"S","에너지특별장학S",1556250,null,4200000,null,"박사","에너지BK장학S",1556250,7800000,1200000]
[6,"공학","에너지화학공학",202024618,"S","에너지특별장학S",1556250,4200000,0,null,null,"에너지BK장학A",1245000,7800000,0]
[7,"공학","에너지화학공학",202124167,"S","에너지특별장학S",1556250,4200000,0,null,null,"에너지아주장학B",2801250,0,4800000]
[8,"공학","에너지화학공학",202124173,"S","에너지특별장학S",1556250,4200000,0,null,"수료","에너지BK장학S",null,6000000,1200000]
[9,"공학","에너지화학공학",202024846,"A","에너지우수장학A",622500,4200000,0,null,null,"에너지BK장학A",null,6000000]
[10,"공학","에너지화학공학",202124169,"B","에너지연구장학B",311250,0,3600000,null,null,"에너지아주장학B",null,null,4800000]
[11,"공학","에너지화학공학",202124174,"B","에너지연구장학B",311250,0,3600000]
[12,"공학","에너지화학공학",202124166,"B","에너지연구장학B",311250,0,3600000,null,null,"이학","감면금액","BK지원금","교비지원금"]
[13,"공학","에너지화학공학",202124172,"B","에너지연구장학B",311250,0,3600000,null,"석사","에너지특별장학S",1345000,4200000,0]
[14,"공학","에너지화학공학",202124170,"B","에너지연구장학B",311250,0,3600000,null,null,"에너지우수장학A",538000,4200000,0]
[15,"공학","에너지화학공학",201925575,"S","에너지BK장학S",null,6000000,1200000,null,null,"에너지연구장학B",0,0,3600000]
[16,"공학","에너지화학공학",202025740,"A","에너지BK장학A",1245000,7800000,0,null,"박사","에너지BK장학S",1345000,7800000,1200000]
[17,"공학","에너지화학공학",202025741,"A","에너지BK장학A",1245000,7800000,0,null,null,"에너지BK장학A",1076000,7800000,0]
[18,"공학","에너지화학공학",201724769,"A","에너지BK장학A",null,6000000,0,null,null,"에너지아주장학B",2421000,0,4800000]
[19,"공학","에너지화학공학",202125860,"A","에너지BK장학A",null,7800000,0,null,"수료","에너지BK장학S",null,6000000,1200000]
[20,"공학","에너지화학공학",201925620,"B","에너지아주장학B",null,null,4800000,null,null,"에너지BK장학A",null,6000000]
[21,"공학","에너지화학공학",202125859,"B","에너지아주장학B",null,0,4800000,null,null,"에너지아주장학B",null,null,4800000]
[22,"공학","에너지화학공학",201925656,"B","에너지아주장학B",null,0,4800000]
[23,"공학","에너지재료공학",202024622,"S","에너지특별장학S",1556250,4200000,0]
[24,"공학","에너지재료공학",202024619,"S","에너지특별장학S",1556250,4200000,0]
[25,"공학","에너지재료공학",202024620,"S","에너지특별장학S",1556250,4200000,0]
[26,"공학","에너지재료공학",202024849,"S","에너지특별장학S",1556250,4200000,0]
[27,"공학","에너지재료공학",202024624,"S","에너지특별장학S",null,4200000,0]
[28,"공학","에너지재료공학",202124286,"S","에너지특별장학S",1556250,4200000,0]
[29,"공학","에너지재료공학",202024623,"A","에너지우수장학A",622500,4200000,0]
[30,"공학","에너지재료공학",202024805,"A","에너지우수장학A",622500,4200000,0]
[31,"공학","에너지재료공학",202024848,"A","에너지우수장학A",622500,4200000,0]
[32,"공학","에너지재료공학",202024621,"B","에너지연구장학B",311250,0,3600000]
[33,"공학","에너지재료공학",202124175,"B","에너지연구장학B",311250,0,3600000]
[34,"공학","에너지재료공학",202124285,"B","에너지연구장학B",311250,0,3600000]
[35,"공학","에너지재료공학",202124287,"B","에너지연구장학B",311250,0,3600000]
[36,"공학","에너지재료공학",202124288,"B","에너지연구장학B",311250,0,3600000]
[37,"공학","에너지재료공학",202025024,"B","에너지연구장학B",null,0,3600000]
[38,"공학","에너지재료공학",201925020,"S","에너지BK장학S",1556250,7800000,1200000]
[39,"공학","에너지재료공학",201825375,"S","에너지BK장학S",null,6000000,1200000]
[40,"공학","에너지재료공학",201924221,"S","에너지BK장학S",1556250,7800000,1200000]
[41,"공학","에너지재료공학",201825529,"A","에너지BK장학A",null,6000000]
[42,"공학","에너지재료공학",201624275,"A","에너지BK장학A",null,6000000]
[43,"공학","에너지재료공학",201924264,"A","에너지BK장학A",null,7800000,0]
[44,"공학","에너지재료공학",201924223,"A","에너지BK장학A",1245000,7800000,0]
[45,"공학","에너지재료공학",201924359,"A","에너지BK장학A",1245000,7800000,0]
[46,"공학","에너지재료공학",201925549,"A","에너지BK장학A",null,7800000,0]
[47,"공학","에너지재료공학",202025697,"B","에너지아주장학B",null,0,4800000]
[48,"공학","에너지재료공학",202025698,"B","에너지아주장학B",null,0,4800000]
[49,"공학","에너지재료공학",202125861,"B","에너지아주장학B",null,0,4800000]
[50,"공학","에너지재료공학",201725129,"B","에너지아주장학B",null,null,4800000]
[51,"공학","에너지재료공학",202025788,"B","에너지아주장학B",null,0,4800000]
[52,"공학","에너지재료공학",202125862,"B","에너지아주장학B",null,0,4800000]
[53,"이학","에너지화학",202024615,"S","에너지특별장학S",1345000,4200000,0]
[54,"이학","에너지화학",202024803,"S","에너지특별장학S",1345000,4200000,0]
[55,"이학","에너지화학",202024613,"S","에너지특별장학S",1345000,4200000,0]
[56,"이학","에너지화학",202124162,"S","에너지특별장학S",1345000,4200000,0]
[57,"이학","에너지화학",202024609,"S","에너지특별장학S",1345000,4200000,0]
[58,"이학","에너지화학",202024804,"A","에너지우수장학A",538000,4200000,0]
[59,"이학","에너지화학",202124163,"B","에너지연구장학B",0,0,3600000]
[60,"이학","에너지화학",202124164,"B","에너지연구장학B",0,0,3600000]
[61,"이학","에너지화학",202124165,"B","에너지연구장학B",0,0,3600000]
[62,"이학","에너지화학",202024607,"B","에너지연구장학B",0,0,3600000]
[63,"이학","에너지화학",202124161,"B","에너지연구장학B",0,0,3600000]
[64,"이학","에너지화학",202024610,"B","에너지연구장학B",0,0,3600000]
[65,"이학","에너지화학",202024614,"B","에너지연구장학B",0,0,3600000]
[66,"이학","에너지화학",202024612,"B","에너지연구장학B",0,0,3600000]
[67,"이학","에너지화학",201825370,"S","에너지BK장학S",null,6000000,1200000]
[68,"이학","에너지화학",201824478,"S","에너지BK장학S",null,6000000,1200000]
[69,"이학","에너지화학",201824668,"A","에너지BK장학A",1076000,7800000,0]
[70,"이학","에너지화학",201924208,"A","에너지BK장학A",1076000,7800000,0]
[71,"이학","에너지화학",201624269,"A","에너지BK장학A",null,6000000]
[72,"이학","에너지화학",201924355,"A","에너지BK장학A",1076000,7800000,0]
[73,"이학","에너지화학",201924210,"B","에너지아주장학B",2421000,0,4800000]
[74,"이학","에너지화학",201825256,"B","에너지아주장학B",null,null,4800000]
[75,"이학","에너지화학",201925619,"B","에너지아주장학B",null,null,4800000]
[76,"이학","에너지화학",201924212,"B","에너지아주장학B",2421000,0,4800000]
[77,"이학","에너지화학",201925558,"B","에너지아주장학B",null,null,4800000]
[78,"이학","에너지물리",202024605,"S","에너지특별장학S",1345000,4200000,0]
[79,"이학","에너지물리",202024604,"S","에너지특별장학S",1345000,4200000,0]
[80,"이학","에너지물리",202024801,"S","에너지특별장학S",1345000,4200000,0]
[81,"이학","에너지물리",202024599,"S","에너지특별장학S",1345000,4200000,0]
[82,"이학","에너지물리",202024601,"S","에너지특별장학S",1345000,4200000,0]
[83,"이학","에너지물리",202024603,"S","에너지특별장학S",1345000,4200000,0]
[84,"이학","에너지물리",202124156,"A","에너지우수장학A",538000,4200000,0]
[85,"이학","에너지물리",202024606,"A","에너지우수장학A",538000,4200000,0]
[86,"이학","에너지물리",202024800,"A","에너지우수장학A",538000,4200000,0]
[87,"이학","에너지물리",202124159,"A","에너지우수장학A",538000,4200000,0]
[88,"이학","에너지물리",202124154,"A","에너지우수장학A",null,4200000,0]
[89,"이학","에너지물리",202024602,"A","에너지우수장학A",538000,4200000,0]
[90,"이학","에너지물리",202024799,"A","에너지우수장학A",538000,4200000,0]
[91,"이학","에너지물리",202124155,"B","에너지연구장학B",0,0,3600000]
[92,"이학","에너지물리",202024797,"B","에너지연구장학B",0,0,3600000]
[93,"이학","에너지물리",202124158,"B","에너지연구장학B",0,0,3600000]
[94,"이학","에너지물리",202024845,"B","에너지연구장학B",0,0,3600000]
[95,"이학","에너지물리",202124157,"B","에너지연구장학B",0,0,3600000]
[96,"이학","에너지물리",202124160,"B","에너지연구장학B",0,0,3600000]
[97,"이학","에너지물리",201925071,"S","에너지BK장학S",null,6000000,1200000]
[98,"이학","에너지물리",201825255,"S","에너지BK장학S",null,6000000,1200000]
[99,"이학","에너지물리",201725126,"S","에너지BK장학S",null,6000000,1200000]
[100,"이학","에너지물리",201925574,"A","에너지BK장학A",null,6000000]
[101,"이학","에너지물리",202025693,"A","에너지BK장학A",null,7800000,0]
[102,"이학","에너지물리",201924351,"A","에너지BK장학A",1076000,7800000,0]
[103,"이학","에너지물리",201924352,"A","에너지BK장학A",1076000,7800000,0]
[104,"이학","에너지물리",201824470,"B","에너지아주장학B",null,null,4800000]
[105,"이학","에너지물리",202025737,"B","에너지아주장학B",2421000,0,4800000]
[106,"이학","에너지물리",202025786,"B","에너지아주장학B",null,0,4800000]
[107,"이학","에너지물리",202025738,"B","에너지아주장학B",2421000,0,4800000]
[108,"이학","에너지물리",202125858,"B","에너지아주장학B",null,0,4800000]