{"text_format":"2","workbook":"xlsx","n_sheets":2,"sheets":["대학원생","수료후연구생"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"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":25,"n_cols":20,"rows_kept":25,"cut":false,"hidden":false,"merged":[[0,0,0,19]]}
["2024학년도 공모전 등 입상장학금 신청현황표"]
["★재학생★ Sheet"]
[{"$nulls":12},"2024. 3. 1. ~ 2025. 2.1.",{"$nulls":6},"(단위: 원)"]
["연번","단과대학","학과","대상과정","학번","성명","지도교수","실적구분","대회명","주최기관","작품명","수상명","수상날짜","은행명","계좌번호","예금주 ","신청금액(원)","1차 검토자(학과)","2차 검토자(단과대학)","비고"]
[1,{"$nulls":11},"2024-03-02",null,null,null,200000]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]
["■ 필요시 칸을 추가하여 작성",{"$nulls":14},"합계",{"$f":"SUM(Q5:Q24)","v":200000}]

{"sheet":"수료후연구생","index":1,"n_rows":25,"n_cols":28,"rows_kept":25,"cut":false,"hidden":false,"merged":[[0,0,0,27],[2,18,2,24]]}
["2024학년도 공모전 등 입상장학금 신청현황표"]
["★수료후연구생★ Sheet"]
[{"$nulls":12},"2024. 3. 1. ~ 2025. 2.1.",{"$nulls":4},"125,000원 초과 시 세금부과","서식수정금지",{"$nulls":8},"(단위: 원)"]
["연번","단과대학","학과","대상과정","학번","성명","지도교수","실적구분","대회명","주최기관","작품명","수상명","수상날짜","주민등록번호","은행명","계좌번호","예금주 ","신청금액(원)\n(A)","필요경비\n(B=A*60%)","소득금액\n(C=A-B)","세율(%)","소득세\n(D=C*20%)","지방소득세\n(E=D*10%)","세금 계\n(F=D+E)","실지급액(원)\n(G=A-F)","1차 검토자(학과)","2차 검토자(단과대학)","비고"]
[1,{"$nulls":11},"2024-03-02","수료후연구생만 작성",null,null,null,200000,{"$f":"IF(R5>125000,R5*60%,0)","v":120000},{"$f":"IF(R5>125000,R5-S5,0)","v":80000},0.2,{"$f":"T5*20%","v":16000},{"$f":"V5*10%","v":1600},{"$f":"V5+W5","v":17600},{"$f":"R5-X5","v":182400}]
[2,{"$nulls":16},200000,{"$f":"IF(R6>125000,R6*60%,0)","v":120000},{"$f":"IF(R6>125000,R6-S6,0)","v":80000},0.2,{"$f":"T6*20%","v":16000},{"$f":"V6*10%","v":1600},{"$f":"V6+W6","v":17600},{"$f":"R6-X6","v":182400}]
[3,{"$nulls":17},{"$f":"IF(R7>125000,R7*60%,0)","v":0},0,0.2,0,0,0,0]
[4,{"$nulls":17},0,0,0.2,0,0,0,0]
[5,{"$nulls":17},0,0,0.2,0,0,0,0]
[6,{"$nulls":17},0,0,0.2,0,0,0,0]
[7,{"$nulls":17},0,0,0.2,{"$f":"T11*20%","v":0},0,{"$f":"V11+W11","v":0},0]
[8,{"$nulls":17},0,0,0.2,0,0,0,0]
[9,{"$nulls":17},0,0,0.2,0,0,0,0]
[10,{"$nulls":17},0,0,0.2,0,0,0,0]
[11,{"$nulls":17},0,0,0.2,0,0,0,0]
[12,{"$nulls":17},0,0,0.2,0,0,0,{"$f":"R16-X16","v":0}]
[13,{"$nulls":17},{"$f":"IF(R17>125000,R17*60%,0)","v":0},{"$f":"IF(R17>125000,R17-S17,0)","v":0},0.2,0,0,0,0]
[14,{"$nulls":17},0,0,0.2,0,0,0,0]
[15,{"$nulls":17},0,0,0.2,{"$f":"T19*20%","v":0},0,0,0]
[16,{"$nulls":17},0,0,0.2,{"$f":"T20*20%","v":0},0,0,{"$f":"R20-X20","v":0}]
[17,{"$nulls":17},0,0,0.2,0,0,0,0]
[18,{"$nulls":17},0,0,0.2,0,0,0,0]
[19,{"$nulls":17},0,0,0.2,0,0,0,0]
[20,{"$nulls":17},0,0,0.2,0,0,0,0]
["■ 필요시 칸을 추가하여 작성",{"$nulls":15},"합계",{"$f":"SUM(R5:R24)","v":400000},{"$nulls":6},{"$f":"SUM(Y5:Y24)","v":364800}]