{"text_format":"2","workbook":"xlsx","n_sheets":4,"sheets":["학과별 지원금 합계","소학회별 지원금","소학회 피벗","Sheet4"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":1},"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":46,"n_cols":9,"rows_kept":46,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,3,1,5],[1,6,1,8]]}
["▣ 학과별 통계"]
["소속","합계",null,"전공소학회",null,null,"비전공소학회"]
["지원기준액","소학회수","지원금액","단체수 ","지원금","신규","단체수","지원금","신규"]
["공과대학",{"$f":"$D4+$F4+$G4+$I4","v":45},{"$f":"SUM(E4,H4)","v":9365000},{"$f":"SUM(D5:D13)","v":27},{"$f":"$D4*255000","v":6885000},{"$f":"SUM(F$5:F$13)","v":2},{"$f":"SUM(G5:G13)","v":16},{"$f":"$G4*155000","v":2480000},{"$f":"SUM(I$5:I$13)","v":0}]
["기계공학과",8,{"$f":"$E5+$H5","v":1840000},{"$f":"COUNTIFS('소학회별 지원금'!$C$3:$C$126,$A5,'소학회별 지원금'!$D$3:$D$126,\"전공\")","v":6},1530000,{"$f":"COUNTIFS('소학회별 지원금'!$C$127:$C$135,$A5,'소학회별 지원금'!$D$127:$D$135,\"전공\")","v":0},{"$f":"COUNTIFS('소학회별 지원금'!$C$3:$C$126,$A5,'소학회별 지원금'!$D$3:$D$126,\"비전공\")","v":2},310000,{"$f":"COUNTIFS('소학회별 지원금'!$C$127:$C$135,$A5,'소학회별 지원금'!$D$127:$D$135,\"비전공\")","v":0}]
["응용화학생명공학과",4,620000,{"$f":"COUNTIFS('소학회별 지원금'!$C$3:$C$126,$A6,'소학회별 지원금'!$D$3:$D$126,\"전공\")","v":0},0,{"$f":"COUNTIFS('소학회별 지원금'!$C$127:$C$135,$A6,'소학회별 지원금'!$D$127:$D$135,\"전공\")","v":0},{"$f":"COUNTIFS('소학회별 지원금'!$C$3:$C$126,$A6,'소학회별 지원금'!$D$3:$D$126,\"비전공\")","v":4},620000,{"$f":"COUNTIFS('소학회별 지원금'!$C$127:$C$135,$A6,'소학회별 지원금'!$D$127:$D$135,\"비전공\")","v":0}]
["환경안전공학과",3,565000,{"$f":"COUNTIFS('소학회별 지원금'!$C$3:$C$126,$A7,'소학회별 지원금'!$D$3:$D$126,\"전공\")","v":1},255000,{"$f":"COUNTIFS('소학회별 지원금'!$C$127:$C$135,$A7,'소학회별 지원금'!$D$127:$D$135,\"전공\")","v":0},{"$f":"COUNTIFS('소학회별 지원금'!$C$3:$C$126,$A7,'소학회별 지원금'!$D$3:$D$126,\"비전공\")","v":2},310000,{"$f":"COUNTIFS('소학회별 지원금'!$C$127:$C$135,$A7,'소학회별 지원금'!$D$127:$D$135,\"비전공\")","v":0}]
["산업공학과",6,1175000,{"$f":"COUNTIFS('소학회별 지원금'!$C$3:$C$126,$A8,'소학회별 지원금'!$D$3:$D$126,\"전공\")","v":4},1020000,{"$f":"COUNTIFS('소학회별 지원금'!$C$127:$C$135,$A8,'소학회별 지원금'!$D$127:$D$135,\"전공\")","v":1},{"$f":"COUNTIFS('소학회별 지원금'!$C$3:$C$126,$A8,'소학회별 지원금'!$D$3:$D$126,\"비전공\")","v":1},155000,{"$f":"COUNTIFS('소학회별 지원금'!$C$127:$C$135,$A8,'소학회별 지원금'!$D$127:$D$135,\"비전공\")","v":0}]
["건설시스템공학과",5,1075000,{"$f":"COUNTIFS('소학회별 지원금'!$C$3:$C$126,$A9,'소학회별 지원금'!$D$3:$D$126,\"전공\")","v":3},765000,{"$f":"COUNTIFS('소학회별 지원금'!$C$127:$C$135,$A9,'소학회별 지원금'!$D$127:$D$135,\"전공\")","v":0},{"$f":"COUNTIFS('소학회별 지원금'!$C$3:$C$126,$A9,'소학회별 지원금'!$D$3:$D$126,\"비전공\")","v":2},310000,{"$f":"COUNTIFS('소학회별 지원금'!$C$127:$C$135,$A9,'소학회별 지원금'!$D$127:$D$135,\"비전공\")","v":0}]
["화학공학과",2,155000,{"$f":"COUNTIFS('소학회별 지원금'!$C$3:$C$126,$A10,'소학회별 지원금'!$D$3:$D$126,\"전공\")","v":0},0,{"$f":"COUNTIFS('소학회별 지원금'!$C$127:$C$135,$A10,'소학회별 지원금'!$D$127:$D$135,\"전공\")","v":1},{"$f":"COUNTIFS('소학회별 지원금'!$C$3:$C$126,$A10,'소학회별 지원금'!$D$3:$D$126,\"비전공\")","v":1},155000,{"$f":"COUNTIFS('소학회별 지원금'!$C$127:$C$135,$A10,'소학회별 지원금'!$D$127:$D$135,\"비전공\")","v":0}]
["교통시스템공학과",5,1075000,{"$f":"COUNTIFS('소학회별 지원금'!$C$3:$C$126,$A11,'소학회별 지원금'!$D$3:$D$126,\"전공\")","v":3},765000,{"$f":"COUNTIFS('소학회별 지원금'!$C$127:$C$135,$A11,'소학회별 지원금'!$D$127:$D$135,\"전공\")","v":0},{"$f":"COUNTIFS('소학회별 지원금'!$C$3:$C$126,$A11,'소학회별 지원금'!$D$3:$D$126,\"비전공\")","v":2},310000,{"$f":"COUNTIFS('소학회별 지원금'!$C$127:$C$135,$A11,'소학회별 지원금'!$D$127:$D$135,\"비전공\")","v":0}]
["신소재공학과",3,665000,{"$f":"COUNTIFS('소학회별 지원금'!$C$3:$C$126,$A12,'소학회별 지원금'!$D$3:$D$126,\"전공\")","v":2},510000,{"$f":"COUNTIFS('소학회별 지원금'!$C$127:$C$135,$A12,'소학회별 지원금'!$D$127:$D$135,\"전공\")","v":0},{"$f":"COUNTIFS('소학회별 지원금'!$C$3:$C$126,$A12,'소학회별 지원금'!$D$3:$D$126,\"비전공\")","v":1},155000,{"$f":"COUNTIFS('소학회별 지원금'!$C$127:$C$135,$A12,'소학회별 지원금'!$D$127:$D$135,\"비전공\")","v":0}]
["건축학과",9,2195000,{"$f":"COUNTIFS('소학회별 지원금'!$C$3:$C$126,$A13,'소학회별 지원금'!$D$3:$D$126,\"전공\")","v":8},2040000,{"$f":"COUNTIFS('소학회별 지원금'!$C$127:$C$135,$A13,'소학회별 지원금'!$D$127:$D$135,\"전공\")","v":0},{"$f":"COUNTIFS('소학회별 지원금'!$C$3:$C$126,$A13,'소학회별 지원금'!$D$3:$D$126,\"비전공\")","v":1},155000,{"$f":"COUNTIFS('소학회별 지원금'!$C$127:$C$135,$A13,'소학회별 지원금'!$D$127:$D$135,\"비전공\")","v":0}]
["정보통신대학",21,4555000,{"$f":"SUM(D15:D20)","v":13},3315000,{"$f":"SUM(F15:F20)","v":0},{"$f":"SUM(G15:G20)","v":8},1240000,{"$f":"SUM(I15:I20)","v":0}]
["정보통신대학 공통",3,565000,{"$f":"COUNTIFS('소학회별 지원금'!$C$3:$C$126,$A15,'소학회별 지원금'!$D$3:$D$126,\"전공\")","v":1},255000,{"$f":"COUNTIFS('소학회별 지원금'!$C$127:$C$135,$A15,'소학회별 지원금'!$D$127:$D$135,\"전공\")","v":0},{"$f":"COUNTIFS('소학회별 지원금'!$C$3:$C$126,$A15,'소학회별 지원금'!$D$3:$D$126,\"비전공\")","v":2},310000,{"$f":"COUNTIFS('소학회별 지원금'!$C$127:$C$135,$A15,'소학회별 지원금'!$D$127:$D$135,\"비전공\")","v":0}]
["전자공학과",7,1385000,{"$f":"COUNTIFS('소학회별 지원금'!$C$3:$C$126,$A16,'소학회별 지원금'!$D$3:$D$126,\"전공\")","v":3},765000,{"$f":"COUNTIFS('소학회별 지원금'!$C$127:$C$135,$A16,'소학회별 지원금'!$D$127:$D$135,\"전공\")","v":0},{"$f":"COUNTIFS('소학회별 지원금'!$C$3:$C$126,$A16,'소학회별 지원금'!$D$3:$D$126,\"비전공\")","v":4},620000,{"$f":"COUNTIFS('소학회별 지원금'!$C$127:$C$135,$A16,'소학회별 지원금'!$D$127:$D$135,\"비전공\")","v":0}]
["소프트웨어학과",3,665000,{"$f":"COUNTIFS('소학회별 지원금'!$C$3:$C$126,$A17,'소학회별 지원금'!$D$3:$D$126,\"전공\")","v":2},510000,{"$f":"COUNTIFS('소학회별 지원금'!$C$127:$C$135,$A17,'소학회별 지원금'!$D$127:$D$135,\"전공\")","v":0},{"$f":"COUNTIFS('소학회별 지원금'!$C$3:$C$126,$A17,'소학회별 지원금'!$D$3:$D$126,\"비전공\")","v":1},155000,{"$f":"COUNTIFS('소학회별 지원금'!$C$127:$C$135,$A17,'소학회별 지원금'!$D$127:$D$135,\"비전공\")","v":0}]
["미디어학과",5,1275000,{"$f":"COUNTIFS('소학회별 지원금'!$C$3:$C$126,$A18,'소학회별 지원금'!$D$3:$D$126,\"전공\")","v":5},1275000,{"$f":"COUNTIFS('소학회별 지원금'!$C$127:$C$135,$A18,'소학회별 지원금'!$D$127:$D$135,\"전공\")","v":0},{"$f":"COUNTIFS('소학회별 지원금'!$C$3:$C$126,$A18,'소학회별 지원금'!$D$3:$D$126,\"비전공\")","v":0},0,{"$f":"COUNTIFS('소학회별 지원금'!$C$127:$C$135,$A18,'소학회별 지원금'!$D$127:$D$135,\"비전공\")","v":0}]
["국방디지털융합학과",1,155000,{"$f":"COUNTIFS('소학회별 지원금'!$C$3:$C$126,$A19,'소학회별 지원금'!$D$3:$D$126,\"전공\")","v":0},0,{"$f":"COUNTIFS('소학회별 지원금'!$C$127:$C$135,$A19,'소학회별 지원금'!$D$127:$D$135,\"전공\")","v":0},{"$f":"COUNTIFS('소학회별 지원금'!$C$3:$C$126,$A19,'소학회별 지원금'!$D$3:$D$126,\"비전공\")","v":1},155000,{"$f":"COUNTIFS('소학회별 지원금'!$C$127:$C$135,$A19,'소학회별 지원금'!$D$127:$D$135,\"비전공\")","v":0}]
["사이버보안학과",2,510000,{"$f":"COUNTIFS('소학회별 지원금'!$C$3:$C$126,$A20,'소학회별 지원금'!$D$3:$D$126,\"전공\")","v":2},510000,{"$f":"COUNTIFS('소학회별 지원금'!$C$127:$C$135,$A20,'소학회별 지원금'!$D$127:$D$135,\"전공\")","v":0},{"$f":"COUNTIFS('소학회별 지원금'!$C$3:$C$126,$A20,'소학회별 지원금'!$D$3:$D$126,\"비전공\")","v":0},0,{"$f":"COUNTIFS('소학회별 지원금'!$C$127:$C$135,$A20,'소학회별 지원금'!$D$127:$D$135,\"비전공\")","v":0}]
["자연과학대학",6,1230000,{"$f":"SUM(D22:D25)","v":3},765000,{"$f":"SUM(F22:F25)","v":0},{"$f":"SUM(G22:G25)","v":3},465000,{"$f":"SUM(I22:I25)","v":0}]
["자연과학대학 공통",2,310000,{"$f":"COUNTIFS('소학회별 지원금'!$C$3:$C$126,$A22,'소학회별 지원금'!$D$3:$D$126,\"전공\")","v":0},0,{"$f":"COUNTIFS('소학회별 지원금'!$C$127:$C$135,$A22,'소학회별 지원금'!$D$127:$D$135,\"전공\")","v":0},{"$f":"COUNTIFS('소학회별 지원금'!$C$3:$C$126,$A22,'소학회별 지원금'!$D$3:$D$126,\"비전공\")","v":2},310000,{"$f":"COUNTIFS('소학회별 지원금'!$C$127:$C$135,$A22,'소학회별 지원금'!$D$127:$D$135,\"비전공\")","v":0}]
["수학과",2,510000,{"$f":"COUNTIFS('소학회별 지원금'!$C$3:$C$126,$A23,'소학회별 지원금'!$D$3:$D$126,\"전공\")","v":2},510000,{"$f":"COUNTIFS('소학회별 지원금'!$C$127:$C$135,$A23,'소학회별 지원금'!$D$127:$D$135,\"전공\")","v":0},{"$f":"COUNTIFS('소학회별 지원금'!$C$3:$C$126,$A23,'소학회별 지원금'!$D$3:$D$126,\"비전공\")","v":0},0,{"$f":"COUNTIFS('소학회별 지원금'!$C$127:$C$135,$A23,'소학회별 지원금'!$D$127:$D$135,\"비전공\")","v":0}]
["물리학과",2,410000,{"$f":"COUNTIFS('소학회별 지원금'!$C$3:$C$126,$A24,'소학회별 지원금'!$D$3:$D$126,\"전공\")","v":1},255000,{"$f":"COUNTIFS('소학회별 지원금'!$C$127:$C$135,$A24,'소학회별 지원금'!$D$127:$D$135,\"전공\")","v":0},{"$f":"COUNTIFS('소학회별 지원금'!$C$3:$C$126,$A24,'소학회별 지원금'!$D$3:$D$126,\"비전공\")","v":1},155000,{"$f":"COUNTIFS('소학회별 지원금'!$C$127:$C$135,$A24,'소학회별 지원금'!$D$127:$D$135,\"비전공\")","v":0}]
["화학과",0,0,{"$f":"COUNTIFS('소학회별 지원금'!$C$3:$C$126,$A25,'소학회별 지원금'!$D$3:$D$126,\"전공\")","v":0},0,{"$f":"COUNTIFS('소학회별 지원금'!$C$127:$C$135,$A25,'소학회별 지원금'!$D$127:$D$135,\"전공\")","v":0},{"$f":"COUNTIFS('소학회별 지원금'!$C$3:$C$126,$A25,'소학회별 지원금'!$D$3:$D$126,\"비전공\")","v":0},0,{"$f":"COUNTIFS('소학회별 지원금'!$C$127:$C$135,$A25,'소학회별 지원금'!$D$127:$D$135,\"비전공\")","v":0}]
["경영대학",8,1940000,{"$f":"SUM(D27:D29)","v":7},1785000,{"$f":"SUM(F27:F29)","v":0},{"$f":"SUM(G27:G29)","v":1},155000,{"$f":"SUM(I27:I29)","v":0}]
["경영학과",4,920000,{"$f":"COUNTIFS('소학회별 지원금'!$C$3:$C$126,$A27,'소학회별 지원금'!$D$3:$D$126,\"전공\")","v":3},765000,{"$f":"COUNTIFS('소학회별 지원금'!$C$127:$C$135,$A27,'소학회별 지원금'!$D$127:$D$135,\"전공\")","v":0},{"$f":"COUNTIFS('소학회별 지원금'!$C$3:$C$126,$A27,'소학회별 지원금'!$D$3:$D$126,\"비전공\")","v":1},155000,{"$f":"COUNTIFS('소학회별 지원금'!$C$127:$C$135,$A27,'소학회별 지원금'!$D$127:$D$135,\"비전공\")","v":0}]
["금융공학과",2,510000,{"$f":"COUNTIFS('소학회별 지원금'!$C$3:$C$126,$A28,'소학회별 지원금'!$D$3:$D$126,\"전공\")","v":2},510000,{"$f":"COUNTIFS('소학회별 지원금'!$C$127:$C$135,$A28,'소학회별 지원금'!$D$127:$D$135,\"전공\")","v":0},{"$f":"COUNTIFS('소학회별 지원금'!$C$3:$C$126,$A28,'소학회별 지원금'!$D$3:$D$126,\"비전공\")","v":0},0,{"$f":"COUNTIFS('소학회별 지원금'!$C$127:$C$135,$A28,'소학회별 지원금'!$D$127:$D$135,\"비전공\")","v":0}]
["e-비즈니스학과",2,510000,{"$f":"COUNTIFS('소학회별 지원금'!$C$3:$C$126,$A29,'소학회별 지원금'!$D$3:$D$126,\"전공\")","v":2},510000,{"$f":"COUNTIFS('소학회별 지원금'!$C$127:$C$135,$A29,'소학회별 지원금'!$D$127:$D$135,\"전공\")","v":0},{"$f":"COUNTIFS('소학회별 지원금'!$C$3:$C$126,$A29,'소학회별 지원금'!$D$3:$D$126,\"비전공\")","v":0},0,{"$f":"COUNTIFS('소학회별 지원금'!$C$127:$C$135,$A29,'소학회별 지원금'!$D$127:$D$135,\"비전공\")","v":0}]
["인문대학",15,2760000,{"$f":"SUM(D31:D35)","v":9},2295000,{"$f":"SUM(F31:F35)","v":2},{"$f":"SUM(G31:G35)","v":3},465000,{"$f":"SUM(I31:I35)","v":1}]
["국어국문학과",3,665000,{"$f":"COUNTIFS('소학회별 지원금'!$C$3:$C$126,$A31,'소학회별 지원금'!$D$3:$D$126,\"전공\")","v":2},510000,{"$f":"COUNTIFS('소학회별 지원금'!$C$127:$C$135,$A31,'소학회별 지원금'!$D$127:$D$135,\"전공\")","v":0},{"$f":"COUNTIFS('소학회별 지원금'!$C$3:$C$126,$A31,'소학회별 지원금'!$D$3:$D$126,\"비전공\")","v":1},155000,{"$f":"COUNTIFS('소학회별 지원금'!$C$127:$C$135,$A31,'소학회별 지원금'!$D$127:$D$135,\"비전공\")","v":0}]
["영어영문학과",2,410000,{"$f":"COUNTIFS('소학회별 지원금'!$C$3:$C$126,$A32,'소학회별 지원금'!$D$3:$D$126,\"전공\")","v":1},255000,{"$f":"COUNTIFS('소학회별 지원금'!$C$127:$C$135,$A32,'소학회별 지원금'!$D$127:$D$135,\"전공\")","v":0},{"$f":"COUNTIFS('소학회별 지원금'!$C$3:$C$126,$A32,'소학회별 지원금'!$D$3:$D$126,\"비전공\")","v":1},155000,{"$f":"COUNTIFS('소학회별 지원금'!$C$127:$C$135,$A32,'소학회별 지원금'!$D$127:$D$135,\"비전공\")","v":0}]
["불어불문학과",2,255000,{"$f":"COUNTIFS('소학회별 지원금'!$C$3:$C$126,$A33,'소학회별 지원금'!$D$3:$D$126,\"전공\")","v":1},255000,{"$f":"COUNTIFS('소학회별 지원금'!$C$127:$C$135,$A33,'소학회별 지원금'!$D$127:$D$135,\"전공\")","v":1},{"$f":"COUNTIFS('소학회별 지원금'!$C$3:$C$126,$A33,'소학회별 지원금'!$D$3:$D$126,\"비전공\")","v":0},0,{"$f":"COUNTIFS('소학회별 지원금'!$C$127:$C$135,$A33,'소학회별 지원금'!$D$127:$D$135,\"비전공\")","v":0}]
["사학과",3,410000,{"$f":"COUNTIFS('소학회별 지원금'!$C$3:$C$126,$A34,'소학회별 지원금'!$D$3:$D$126,\"전공\")","v":1},255000,{"$f":"COUNTIFS('소학회별 지원금'!$C$127:$C$135,$A34,'소학회별 지원금'!$D$127:$D$135,\"전공\")","v":0},{"$f":"COUNTIFS('소학회별 지원금'!$C$3:$C$126,$A34,'소학회별 지원금'!$D$3:$D$126,\"비전공\")","v":1},155000,{"$f":"COUNTIFS('소학회별 지원금'!$C$127:$C$135,$A34,'소학회별 지원금'!$D$127:$D$135,\"비전공\")","v":1}]
["문화콘텐츠학과",5,1020000,{"$f":"COUNTIFS('소학회별 지원금'!$C$3:$C$126,$A35,'소학회별 지원금'!$D$3:$D$126,\"전공\")","v":4},1020000,{"$f":"COUNTIFS('소학회별 지원금'!$C$127:$C$135,$A35,'소학회별 지원금'!$D$127:$D$135,\"전공\")","v":1},{"$f":"COUNTIFS('소학회별 지원금'!$C$3:$C$126,$A35,'소학회별 지원금'!$D$3:$D$126,\"비전공\")","v":0},0,{"$f":"COUNTIFS('소학회별 지원금'!$C$127:$C$135,$A35,'소학회별 지원금'!$D$127:$D$135,\"비전공\")","v":0}]
["사회과학대학",21,4045000,{"$f":"SUM(D37:D41)","v":11},2805000,{"$f":"SUM(F37:F41)","v":1},{"$f":"SUM(G37:G41)","v":8},1240000,{"$f":"SUM(I37:I41)","v":1}]
["경제학과",4,820000,{"$f":"COUNTIFS('소학회별 지원금'!$C$3:$C$126,$A37,'소학회별 지원금'!$D$3:$D$126,\"전공\")","v":2},510000,{"$f":"COUNTIFS('소학회별 지원금'!$C$127:$C$135,$A37,'소학회별 지원금'!$D$127:$D$135,\"전공\")","v":0},{"$f":"COUNTIFS('소학회별 지원금'!$C$3:$C$126,$A37,'소학회별 지원금'!$D$3:$D$126,\"비전공\")","v":2},310000,{"$f":"COUNTIFS('소학회별 지원금'!$C$127:$C$135,$A37,'소학회별 지원금'!$D$127:$D$135,\"비전공\")","v":0}]
["행정학과",3,410000,{"$f":"COUNTIFS('소학회별 지원금'!$C$3:$C$126,$A38,'소학회별 지원금'!$D$3:$D$126,\"전공\")","v":1},255000,{"$f":"COUNTIFS('소학회별 지원금'!$C$127:$C$135,$A38,'소학회별 지원금'!$D$127:$D$135,\"전공\")","v":0},{"$f":"COUNTIFS('소학회별 지원금'!$C$3:$C$126,$A38,'소학회별 지원금'!$D$3:$D$126,\"비전공\")","v":1},155000,{"$f":"COUNTIFS('소학회별 지원금'!$C$127:$C$135,$A38,'소학회별 지원금'!$D$127:$D$135,\"비전공\")","v":1}]
["심리학과",8,1840000,{"$f":"COUNTIFS('소학회별 지원금'!$C$3:$C$126,$A39,'소학회별 지원금'!$D$3:$D$126,\"전공\")","v":6},1530000,{"$f":"COUNTIFS('소학회별 지원금'!$C$127:$C$135,$A39,'소학회별 지원금'!$D$127:$D$135,\"전공\")","v":0},{"$f":"COUNTIFS('소학회별 지원금'!$C$3:$C$126,$A39,'소학회별 지원금'!$D$3:$D$126,\"비전공\")","v":2},310000,{"$f":"COUNTIFS('소학회별 지원금'!$C$127:$C$135,$A39,'소학회별 지원금'!$D$127:$D$135,\"비전공\")","v":0}]
["사회학과",2,255000,{"$f":"COUNTIFS('소학회별 지원금'!$C$3:$C$126,$A40,'소학회별 지원금'!$D$3:$D$126,\"전공\")","v":1},255000,{"$f":"COUNTIFS('소학회별 지원금'!$C$127:$C$135,$A40,'소학회별 지원금'!$D$127:$D$135,\"전공\")","v":1},{"$f":"COUNTIFS('소학회별 지원금'!$C$3:$C$126,$A40,'소학회별 지원금'!$D$3:$D$126,\"비전공\")","v":0},0,{"$f":"COUNTIFS('소학회별 지원금'!$C$127:$C$135,$A40,'소학회별 지원금'!$D$127:$D$135,\"비전공\")","v":0}]
["정치외교학과",4,720000,{"$f":"COUNTIFS('소학회별 지원금'!$C$3:$C$126,$A41,'소학회별 지원금'!$D$3:$D$126,\"전공\")","v":1},255000,{"$f":"COUNTIFS('소학회별 지원금'!$C$127:$C$135,$A41,'소학회별 지원금'!$D$127:$D$135,\"전공\")","v":0},{"$f":"COUNTIFS('소학회별 지원금'!$C$3:$C$126,$A41,'소학회별 지원금'!$D$3:$D$126,\"비전공\")","v":3},465000,{"$f":"COUNTIFS('소학회별 지원금'!$C$127:$C$135,$A41,'소학회별 지원금'!$D$127:$D$135,\"비전공\")","v":0}]
["약학대학",13,2005000,{"$f":"SUM(D43)","v":3},765000,{"$f":"SUM(F43)","v":1},{"$f":"SUM(G43)","v":8},1240000,{"$f":"SUM(I43)","v":1}]
["약학과",13,2005000,{"$f":"COUNTIFS('소학회별 지원금'!$C$3:$C$126,$A43,'소학회별 지원금'!$D$3:$D$126,\"전공\")","v":3},765000,{"$f":"COUNTIFS('소학회별 지원금'!$C$127:$C$135,$A43,'소학회별 지원금'!$D$127:$D$135,\"전공\")","v":1},{"$f":"COUNTIFS('소학회별 지원금'!$C$3:$C$126,$A43,'소학회별 지원금'!$D$3:$D$126,\"비전공\")","v":8},1240000,{"$f":"COUNTIFS('소학회별 지원금'!$C$127:$C$135,$A43,'소학회별 지원금'!$D$127:$D$135,\"비전공\")","v":1}]
["국제학부",4,1020000,{"$f":"SUM(D45)","v":4},1020000,{"$f":"COUNTIFS('소학회별 지원금'!$C$127:$C$135,$A44)","v":0},{"$f":"SUM(G45)","v":0},0,{"$f":"SUM(I45)","v":0}]
["국제학부",4,1020000,{"$f":"COUNTIFS('소학회별 지원금'!$C$3:$C$126,$A45,'소학회별 지원금'!$D$3:$D$126,\"전공\")","v":4},1020000,{"$f":"COUNTIFS('소학회별 지원금'!$C$127:$C$135,$A45,'소학회별 지원금'!$D$127:$D$135,\"전공\")","v":0},{"$f":"COUNTIFS('소학회별 지원금'!$C$3:$C$126,$A45,'소학회별 지원금'!$D$3:$D$126,\"비전공\")","v":0},0,{"$f":"COUNTIFS('소학회별 지원금'!$C$127:$C$135,$A45,'소학회별 지원금'!$D$127:$D$135,\"비전공\")","v":0}]
["합계",{"$f":"$D46+$F46+$G46+$I46","v":133},{"$f":"SUM(E46,H46)","v":26920000},{"$f":"SUM(D$4,D$14,D$21,D$26,D$30,D$36,D$42,D$44)","v":77},{"$f":"SUM(E4,E14,E21,E26,E30,E36,E42,E44)","v":19635000},{"$f":"SUM(F$4,F$14,F$21,F$26,F$30,F$36,F$42,F$44)","v":6},{"$f":"SUM(G4,G14,G21,G26,G30,G36,G42,G44)","v":47},{"$f":"SUM(H4,H14,H21,H26,H30,H36,H42,H44)","v":7285000},{"$f":"SUM(I$4,I$14,I$21,I$26,I$30,I$36,I$42,I$44)","v":3}]

{"sheet":"소학회별 지원금","index":1,"n_rows":135,"n_cols":5,"rows_kept":135,"cut":false,"hidden":false,"merged":[]}
["▣ 소학회별 현황"]
["소학회명","대학","학과","구분","지원금"]
["A-FA(Ajou Future Automobile)","공과대학","기계공학과","전공",255000]
["AFEC (Ajou Fluid Engineers Club)","공과대학","기계공학과","전공",255000]
["A-TRIZ(Ajou-Teoriya Resheniya Izobretatelskikh Zadatch)","공과대학","기계공학과","전공",255000]
["ACCA","공과대학","기계공학과","전공",255000]
["OFFSIDE","공과대학","기계공학과","비전공",155000]
["노루막이","공과대학","기계공학과","비전공",155000]
["소금쟁이","공과대학","기계공학과","전공",255000]
["ACE","공과대학","기계공학과","전공",255000]
["아콘(Archon)","공과대학","산업공학과","전공",255000]
["ASECON (Auto Security Control)","공과대학","산업공학과","전공",255000]
["FC 프라임","공과대학","산업공학과","비전공",155000]
["M&S","공과대학","산업공학과","전공",255000]
["LIST21(물류소학회)","공과대학","산업공학과","전공",255000]
["터뷸런스","공과대학","화학공학과","비전공",155000]
["A.R.A.M. (Advanced Research of Ajou Material engineers)","공과대학","신소재공학과","전공",255000]
["fcc (신소재공학과 축구소학회)","공과대학","신소재공학과","비전공",155000]
["가치","공과대학","신소재공학과","전공",255000]
["B.C. Fullerene","공과대학","응용화학생명공학과","비전공",155000]
["FC 빽태클","공과대학","응용화학생명공학과","비전공",155000]
["소리바람","공과대학","응용화학생명공학과","비전공",155000]
["아로마틱","공과대학","응용화학생명공학과","비전공",155000]
["자비지","공과대학","환경안전공학과","비전공",155000]
["지구방위대","공과대학","환경안전공학과","비전공",155000]
["터지기","공과대학","환경안전공학과","전공",255000]
["가람지기","공과대학","건설시스템공학과","전공",255000]
["미공","공과대학","건설시스템공학과","전공",255000]
["아토쓰","공과대학","건설시스템공학과","비전공",155000]
["적토마","공과대학","건설시스템공학과","비전공",155000]
["창건","공과대학","건설시스템공학과","전공",255000]
["ATFC(Ajou Transportaion Football Club)","공과대학","교통시스템공학과","비전공",155000]
["ATs (Ajou Transportation Study)","공과대학","교통시스템공학과","전공",255000]
["Cheer-Up(취얼업)","공과대학","교통시스템공학과","전공",255000]
["FLY HIGH","공과대학","교통시스템공학과","비전공",155000]
["TuF(Transportation Under Friendship)","공과대학","교통시스템공학과","전공",255000]
["A2 (Ajou Architecture Football Club)","공과대학","건축학과","비전공",155000]
["A-Bit","공과대학","건축학과","전공",255000]
["DP&E","공과대학","건축학과","전공",255000]
["DSA","공과대학","건축학과","전공",255000]
["FACE (Frontier of Architectural Construction Engineering)","공과대학","건축학과","전공",255000]
["M'IT (Matlab IT)","공과대학","건축학과","전공",255000]
["Studio I.S.M.","공과대학","건축학과","전공",255000]
["바로서기","공과대학","건축학과","전공",255000]
["이큐빅(E-CUBIC)","공과대학","건축학과","전공",255000]
["볼랜드(Balland)","정보통신대학","정보통신대학 공통","비전공",155000]
["CHAOS","정보통신대학","정보통신대학 공통","비전공",155000]
["TML (Total Multimedia Lovers)","정보통신대학","정보통신대학 공통","전공",255000]
["COMP D&A","정보통신대학","전자공학과","전공",255000]
["X_TAL(크리스탈)","정보통신대학","전자공학과","전공",255000]
["네트로닉스(netrinics)","정보통신대학","전자공학과","전공",255000]
["새","정보통신대학","전자공학과","비전공",155000]
["오반칙","정보통신대학","전자공학과","비전공",155000]
["일레븐","정보통신대학","전자공학과","비전공",155000]
["하늘음표","정보통신대학","전자공학과","비전공",155000]
["CONNECT","정보통신대학","미디어학과","전공",255000]
["고래","정보통신대학","미디어학과","전공",255000]
["브레인스톰(BrainStrom)","정보통신대학","미디어학과","전공",255000]
["ARTISAN(아티젠)","정보통신대학","미디어학과","전공",255000]
["잉크","정보통신대학","미디어학과","전공",255000]
["A.N.S.I","정보통신대학","소프트웨어학과","전공",255000]
["세미콜론","정보통신대학","소프트웨어학과","비전공",155000]
["HANTOR(한터)","정보통신대학","소프트웨어학과","전공",255000]
["HaMer","정보통신대학","사이버보안학과","전공",255000]
["Whois","정보통신대학","사이버보안학과","전공",255000]
["FC봄봄","정보통신대학","국방디지털융합학과","비전공",155000]
["MOSS","자연과학대학","자연과학대학 공통","비전공",155000]
["늑대야","자연과학대학","자연과학대학 공통","비전공",155000]
["MathLab","자연과학대학","수학과","전공",255000]
["MiC(Mathematics in Coding)","자연과학대학","수학과","전공",255000]
["GPS","자연과학대학","물리학과","전공",255000]
["LCC","자연과학대학","물리학과","비전공",155000]
["AFIA(Ajou Financial Investment Association)","경영대학","경영학과","전공",255000]
["RPM","경영대학","경영학과","전공",255000]
["비더비즈","경영대학","경영학과","비전공",155000]
["증권연구회","경영대학","경영학과","전공",255000]
["B-Cube(Broad Business Builder)","경영대학","e-비즈니스학과","전공",255000]
["d2I(data to Intelligence)","경영대학","e-비즈니스학과","전공",255000]
["AFLO (Ajou Financial Leaders Organization)","경영대학","금융공학과","전공",255000]
["FEPSI(Finance Engineering Programming Study Institute)","경영대학","금융공학과","전공",255000]
["FC바투","인문대학","국어국문학과","비전공",155000]
["나들목","인문대학","국어국문학과","전공",255000]
["시숲","인문대학","국어국문학과","전공",255000]
["더사리","인문대학","영어영문학과","비전공",155000]
["샘N샘(샘앤샘)","인문대학","영어영문학과","전공",255000]
["레자마떼","인문대학","불어불문학과","전공",255000]
["바우","인문대학","사학과","비전공",155000]
["역사기행반","인문대학","사학과","전공",255000]
["머스타드(MustAD)","인문대학","문화콘텐츠학과","전공",255000]
["시나리오 나무","인문대학","문화콘텐츠학과","전공",255000]
["징검다리","인문대학","문화콘텐츠학과","전공",255000]
["콜","인문대학","문화콘텐츠학과","전공",255000]
["몸부림","사회과학대학","경제학과","전공",255000]
["율스트릿","사회과학대학","경제학과","전공",255000]
["싸커노믹스","사회과학대학","경제학과","비전공",155000]
["씨알의 소리","사회과학대학","경제학과","비전공",155000]
["LUKAS Band(루카스)","사회과학대학","행정학과","비전공",155000]
["등줄기","사회과학대학","행정학과","전공",255000]
["See-Real","사회과학대학","심리학과","전공",255000]
["낮에 나온 반달","사회과학대학","심리학과","전공",255000]
["범인","사회과학대학","심리학과","전공",255000]
["사람과사회","사회과학대학","심리학과","전공",255000]
["심볼","사회과학대학","심리학과","비전공",155000]
["심씨네","사회과학대학","심리학과","전공",255000]
["안한숙 밴드","사회과학대학","심리학과","비전공",155000]
["이중자아","사회과학대학","심리학과","전공",255000]
["반딧불이","사회과학대학","사회학과","전공",255000]
["ARETE(아레테)","사회과학대학","정치외교학과","비전공",155000]
["삭트(S.A.C.T)","사회과학대학","정치외교학과","비전공",155000]
["민중사랑 (민사)","사회과학대학","정치외교학과","전공",255000]
["카리스마","사회과학대학","정치외교학과","비전공",155000]
["일본연구회","국제학부","국제학부","전공",255000]
["국제통상연구회","국제학부","국제학부","전공",255000]
["중국연구회","국제학부","국제학부","전공",255000]
["한국학 연구회","국제학부","국제학부","전공",255000]
["A.P.C (Ajou pharm Photo Club)","약학대학","약학과","비전공",155000]
["아벨","약학대학","약학과","전공",255000]
["pap crew","약학대학","약학과","비전공",155000]
["구사모","약학대학","약학과","비전공",155000]
["맛동","약학대학","약학과","비전공",155000]
["아뮤너스","약학대학","약학과","전공",255000]
["아약스","약학대학","약학과","비전공",155000]
["야키스","약학대학","약학과","비전공",155000]
["약오름","약학대학","약학과","비전공",155000]
["전어","약학대학","약학과","비전공",155000]
["청춘책방","약학대학","약학과","전공",255000]
["진돗개","인문대학","사학과","비전공",0]
["PASS","사회과학대학","행정학과","비전공",0]
["아주콕","약학대학","약학과","비전공",0]
["WAI(Who Am I)","공과대학","산업공학과","전공",0]
["컨트롤","공과대학","화학공학과","전공",0]
["아프로(AFRO)","인문대학","불어불문학과","전공",0]
["B.road(비로드)","인문대학","문화콘텐츠학과","전공",0]
["사고뭉치","사회과학대학","사회학과","전공",0]
["FAS","약학대학","약학과","전공",0]

{"sheet":"소학회 피벗","index":2,"n_rows":48,"n_cols":6,"rows_kept":48,"cut":false,"hidden":true,"merged":[]}
["전공 여부","(모두)"]
[]
["개수 : 소학회명","열 레이블"]
["행 레이블",0,"A","B","C","총합계"]
["경영대학",1,2,4,2,9]
["e-비즈니스학과",null,1,1,null,2]
["경영학과",null,1,2,1,4]
["금융공학과",1,null,1,1,3]
["공과대학",3,4,24,16,47]
["건설시스템공학과",null,null,4,2,6]
["건축학과",2,null,5,5,12]
["교통시스템공학과",null,null,3,2,5]
["기계공학과",null,3,3,1,7]
["산업공학과",null,1,3,1,5]
["신소재공학과",null,null,2,1,3]
["응용화학생명공학과",null,null,1,3,4]
["화학공학과",1,null,1,null,2]
["환경안전공학과",null,null,2,1,3]
["국제학부",null,null,1,3,4]
["국제학부",null,null,1,3,4]
["사회과학대학",2,1,15,4,22]
["경제학과",null,null,4,null,4]
["사회과학대학 공통",1,null,null,null,1]
["사회학과",1,null,1,1,3]
["심리학과",null,1,7,null,8]
["정치외교학과",null,null,2,2,4]
["행정학과",null,null,1,1,2]
["약학대학",null,null,11,null,11]
["약학과",null,null,11,null,11]
["인문대학",null,2,5,6,13]
["국어국문학과",null,null,1,2,3]
["문화콘텐츠학과",null,2,1,1,4]
["불어불문학과",null,null,1,null,1]
["사학과",null,null,1,2,3]
["영어영문학과",null,null,1,1,2]
["자연과학대학",2,null,3,5,10]
["물리학과",null,null,null,3,3]
["수학과",1,null,1,1,3]
["자연과학대학 공통",null,null,2,1,3]
["화학과",1,null,null,null,1]
["정보통신대학",null,3,15,8,26]
["국방디지털융합학과",null,null,null,3,3]
["미디어학과",null,null,4,3,7]
["사이버보안학과",null,1,1,null,2]
["소프트웨어학과",null,1,3,null,4]
["전자공학과",null,1,6,null,7]
["정보통신대학 공통",null,null,1,2,3]
["총합계",8,12,78,44,142]

{"sheet":"Sheet4","index":3,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["⑤⑥⑦⑧⑨⑩⑪⑫\n\n① 평가자별 평균(raw data)\n② 평가자 전체 평균\n③ 보정계수 산출(전체평균 대비 팀 평균 차이 계산)= 전체 평균 / 평가자별 평균 (② / ①)\n④ 보정점수(각 평가점수*③)의 평균 및 편차 => 평가자별 평균이 모두 같아짐\n⑤ 표준점수화 = (개별 보정점수-보정평균)*(보정점수의 표준편차/평가자별 보정점수 표준편차)+전체 평균(raw) => 표준편차 동일"]