{"text_format":"2","workbook":"xlsx","n_sheets":3,"sheets":["2024-1 방학중 계획","2023-1 방학중 계획","계산"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":4,"comments":2,"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":"2024-1 방학중 계획","index":0,"n_rows":62,"n_cols":9,"rows_kept":62,"cut":false,"hidden":false,"merged":[[60,0,60,2],[61,0,61,2],[0,0,0,8],[1,0,1,8],[2,0,2,8],[3,0,3,8],[4,0,4,8],[11,1,15,1],[23,1,25,1],[51,1,58,1],[36,1,41,1],[32,1,34,1],[42,1,44,1],[26,1,27,1],[28,1,31,1],[18,1,22,1],[48,0,48,2],[49,0,49,2],[5,0,5,8],[7,1,9,2],[7,3,7,6],[7,7,8,7],[7,8,9,8],[6,0,6,8],[7,0,9,0]]}
["2024학년도 1학기 방학 중 부서별 근로장학생 배정 내역"]
["1. 근로기간 : 2024. 6. 25.~2024. 8. 31. (주5일 [48일간], 토요일 [10일], 주6일 [58일간])"]
["2. 근로단가"]
["  가. 국가근로[변동 가능] - 교내일반 : 9,860원, 교외일반 : 12,220원"]
["  나. 대학근로 - 일반 : 9,860원, 육체(식당) : 12,320원"]
["3. 학생별 1일 근로시간은 각 해당부서에서 결정(학기 중 국가근로는 1인이 1일 8시간 / 주당 40시간 / 학기당 520시간을 초과할 수 없음)"]
["4. 부서별 배정 내역"]
["근로구분","부서명",null,"1일 근로시간",null,null,null,"선발인원","근로장소"]
[null,null,null,"국가근로\n(일반/주5일)","대학근로\n(일반/주5일)","대학근로\n(육체근로/5일)","대학근로\n(육체근로/6일)"]
[null,null,null,48,48,48,58]
["국가근로(교내일반)","교무처","교무과",5,null,null,null,"미정","본관 303호"]
["국가근로(교내일반)","학생성공처","학생지원팀",5,null,null,null,"미정","본관 101호"]
["국가근로(교내일반)",null,"의료지원실",3,null,null,null,"미정","학생회관 103호"]
["국가근로(교내일반)",null,"학생상담센터",5,null,null,null,"미정","학생회관 201호"]
["국가근로(교내일반)",null,"학생복지팀, 갤러리",23,null,null,null,"미정","학생회관 102호 / 학생회관 지하1층"]
["국가근로(교내일반)",null,"취업지원팀",5,null,null,null,"미정","도서관 210호"]
["국가근로(교내일반)","기획협력처","기획협력과",5,null,null,null,"미정","본관 601호"]
["국가근로(교내일반)","입학처","입학정책팀, 입학홍보팀",5,null,null,null,"미정","본관 301호"]
["국가근로(교내일반)","사무국","재무,재산관리팀",5,null,null,null,"미정","본관 505호"]
["국가근로(교내일반)",null,"총무팀",5,null,null,null,"미정","본관 502호"]
["국가근로(교내일반)",null,"기록관",2,null,null,null,"미정","본관305호"]
["국가근로(교내일반)",null,"예비군연대",5,null,null,null,"미정","디지털관 222호"]
["국가근로(교내일반) / 대학근로(일반)",null,"시설안전과",5,4,null,null,"미정","본관 402~403호 / 테크노관 B104호"]
["국가근로(교내일반)","미래교육혁신본부","교육혁신과",5,null,null,null,"미정","공동실험실습관 303호"]
["국가근로(교내일반)",null,"공학교육혁신센터",5,null,null,null,"미정","그린에너지관 313호"]
["국가근로(교내일반)",null,"교수학습혁신센터",5,null,null,null,"미정","벤처창업관 317호, 318호"]
["국가근로(교내일반)","대학원행정실","대학원지원팀",5,null,null,null,"미정","본관 201호"]
["국가근로(교내일반)",null,"산업대학원(최고경영자과정팀)",3,null,null,null,"미정","글로벌관 445호"]
["국가근로(교내일반)","종합학사행정실","테크노관행정실",16,null,null,null,"미정","테크노관"]
["국가근로(교내일반)",null,"디지털관행정실",16,null,null,null,"미정","디지털관"]
["국가근로(교내일반)",null,"글로벌관행정실",16,null,null,null,"미정","글로벌관"]
["국가근로(교내일반)",null,"교육관(신평동)",3,null,null,null,"미정","교육관(신평동)"]
["국가근로(교내일반)","교육기본시설","도서관(양호동)",49,null,null,null,"미정","도서관(양호동)"]
["국가근로(교내일반)",null,"도서관(신평동)",9,null,null,null,"미정","도서관(신평동 아름책마루도서관)"]
["국가근로(교내일반)",null,"정보전산원",5,null,null,null,"미정","도서관 3, 4층"]
["국가근로(교내일반) / 대학근로(일반,육체)","지원시설","생활관",5,8,28,7,"미정","푸름관"]
["국가근로(교내일반)","부속시설","공학종합실습센터",5,null,null,null,"미정","공동실험실습관 126호"]
["국가근로(교내일반)",null,"공동실험실습관",5,null,null,null,"미정","그린에너지관 202, 401호"]
["국가근로(교내일반)",null,"과학영재교육원",5,null,null,null,"미정","테크노관 254호"]
["국가근로(교내일반)",null,"대외협력실",5,null,null,null,"미정","산학협력관 507호"]
["국가근로(교내일반)",null,"지자체-대학협력기반지역혁신사업단",3,null,null,null,"미정","글로벌관 566호"]
["국가근로(교내일반)",null,"SW전문인재양성사업단",3,null,null,null,"미정","도서관 417호"]
["국가근로(교내일반)","지역협력단","평생교육원(신평동)",5,null,null,null,"미정","신평동 평생교육원 102호"]
["국가근로(교내일반)",null,"국제교류교육원",5,null,null,null,"미정","국제교육관 E103호"]
["국가근로(교내일반) / 대학근로(일반)",null,"체육문화센터",5,4,null,null,"미정","골프학습관 / 체육관, 헬스장"]
["국가근로(교내일반)","교양학부","교양학부",6,null,null,null,"미정","글로벌관 103호"]
["국가근로(교내일반)","교수회","교수회",4,null,null,null,"미정","글로벌관 601호"]
["국가근로(교내일반)","학생군사교육단","152학생군사교육단",0,null,null,null,"미정","학생군사교육단"]
["교내 소계"]
[null,null,null,48]
["국가근로(교외일반)","산학협력단","산학협력단",40,null,null,null,"미정","산학협력관 302호, 305호"]
["국가근로(교외일반)","산학협력시설","기업협력실(기업지원팀)",6,null,null,null,"미정","산학협력관 203호"]
["국가근로(교외일반)",null,"기업협력실(산학교육팀)",6,null,null,null,"미정","산학협력관 501호"]
["국가근로(교외일반)",null,"그린에너지산업화지원센터",6,null,null,null,"미정","산학협력관 610호"]
["국가근로(교외일반)",null,"강소특구육성사업단",6,null,null,null,"미정","공동실험실습관 201호"]
["국가근로(교외일반)",null,"창의지식재산센터",6,null,null,null,"미정","산학협력관 206호"]
["국가근로(교외일반)",null,"기술창업지원실",6,null,null,null,"미정","벤처창업관 313호"]
["국가근로(교외일반)",null,"산학기획실",6,null,null,null,"미정","산학협력관 505호"]
["국가근로(교외일반)",null,"구미정책개발센터",4,null,null,null,"미정","글로벌관 128호"]
["국가근로(교외일반)","생활협동조합","생활협동조합",30,null,null,null,"미정","학생회관"]
["교외 소계"]
["총 계"]

{"sheet":"2023-1 방학중 계획","index":1,"n_rows":67,"n_cols":14,"rows_kept":67,"cut":false,"hidden":true,"merged":[[11,0,17,0],[20,0,25,0],[26,0,29,0],[31,0,34,0],[65,0,65,1],[63,0,63,1],[39,0,40,0],[42,0,50,0],[52,0,52,1],[53,0,53,1],[55,0,61,0],[64,0,64,1],[36,0,38,0],[6,0,6,13],[7,0,9,1],[7,6,8,6],[7,7,8,7],[7,8,8,8],[7,9,8,9],[7,10,8,10],[7,11,9,11],[7,12,9,12],[7,13,9,13],[7,2,7,5],[5,0,5,13],[0,0,0,13],[1,0,1,13],[2,0,2,13],[3,0,3,13],[4,0,4,13]]}
["2023학년도 1학기 학기 중 부서별 근로장학생 배정 내역"]
["1. 근로기간 : 2023. 3. 1.~2023. 6. 21. (주5일 [78일간], 토요일 [15일], 주6일 [93일간])"]
["2. 근로단가"]
["  가. 국가근로[변동 가능] - 교내일반 : 9,620원, 교외일반 : 11,150원"]
["  나. 대학근로 - 일반 : 9,620원, 육체(식당) : 12,020원"]
["3. 학생별 1일 근로시간은 각 해당부서에서 결정(학기 중 국가근로는 1인이 1일 8시간 / 주당 20시간 / 학기당 520시간을 초과할 수 없음)"]
["4. 부서별 배정 내역"]
["부서명",null,"1일 근로시간",null,null,null,"선발인원","국고\n(교내 80%, \n교외 100%)","대응\n(20%)","대학일반","대학육체","근로장소","담당자","메일주소"]
[null,null,"국가근로\n(일반/주5일)","대학근로\n(일반/주5일)","대학근로\n(육체근로/5일)","대학근로\n(육체근로/6일)"]
[null,null,50,50,50,60,null,7696,1924,9620,12020]
["교무처","교무과",5,null,null,null,"미정",{"$f":"C11*$C$10*$H$10","v":1924000},{"$f":"C11*$C$10*$I$10","v":481000},{"$f":"D11*$D$10*$J$10","v":0},{"$f":"(E11*$E$10*$K$10)+($F$10*$F11*$K$10)","v":0},"본관 303호","안미애","\tamaasd@kumoh.ac.kr"]
["학생성공처","학생지원팀",5,null,null,null,"미정",1924000,481000,0,{"$f":"(E12*$E$10*$K$10)+($F$10*$F12*$K$10)","v":0},"본관 101호","박현정","guswjd9684@kumoh.ac.kr"]
[null,"장애대학생도우미",0,null,null,null,"미정",0,0,0,0,null,"박현정","guswjd9684@kumoh.ac.kr"]
[null,"의료지원실",3,null,null,null,"미정",1154400,288600,0,0,"학생회관 103호","류정희","rjh@kumoh.ac.kr"]
[null,"학생상담센터",4,null,null,null,"미정",1539200,384800,0,0,"학생회관 201호","최윤영","e00452@kumoh.ac.kr"]
[null,"학생복지팀, 갤러리",22,null,null,null,"미정",8465600,2116400,0,0,"학생회관 102호, 학생회관 지하1층","이진옥","e00430@kumoh.ac.kr"]
[null,"대학식당(양호동캠퍼스)",null,8,34,null,"미정",0,0,3848000,20434000,"대학식당(양호동)","이정희","ace@kumoh.ac.kr"]
[null,"취업지원팀",5,null,null,null,"미정",1924000,481000,0,0,"도서관 210호","김선희","yjunehyuk@kumoh.ac.kr"]
["기획협력처","기획협력과",5,null,null,null,"미정",1924000,481000,0,0,"본관 601호","양미연","aldus2528@kumoh.ac.kr"]
["입학처","입학정책팀, 입학홍보팀",5,null,null,null,"미정",1924000,481000,0,0,"본관 301호","변경아","bka0717@kumoh.ac.kr"]
["사무국","재무,재산관리팀",5,null,null,null,"미정",1924000,481000,0,0,"본관 505호","김지영","jykim88228@kumoh.ac.kr"]
[null,"총무팀",5,null,null,null,"미정",1924000,481000,0,0,"본관 502호","김지영","jykim88228@kumoh.ac.kr"]
[null,"기록관",2,null,null,null,"미정",769600,192400,0,0,"본관305호","김지영","jykim88228@kumoh.ac.kr"]
[null,"시설안전과",10,null,null,null,"미정",3848000,962000,0,0,"본관 402~403호, 테크노관 B104호","최효신","chs9528@kumoh.ac.kr"]
[null,"체육관, 헬스장",null,4,null,null,"미정",0,0,1924000,0,"체육관, 헬스장","최효신(최태순)","tsc777@kumoh.ac.kr"]
[null,"예비군연대",4,null,null,null,"미정",1539200,384800,0,0,"디지털관 222호","손희정","sonhj@kumoh.ac.kr"]
["미래교육혁신본부","교육혁신과",5,null,null,null,"미정",1924000,481000,0,0,"공동실험실습관 303호","박민경","shw00248@kumoh.ac.kr"]
[null,"AI.SW교육센터",3,null,null,null,"미정",1154400,288600,0,0,"벤처창업관 314호, 315호","박정애","pja1127@kumoh.ac.kr"]
[null,"공학교육혁신센터",4,2,null,null,"미정",1539200,384800,962000,0,"그린에너지관 313호","정혜선","kit82@kumoh.ac.kr"]
[null,"교수학습혁신센터",4,null,null,null,"미정",1539200,384800,0,0,"벤처창업관 317호, 318호","정현호","hhjung@kumoh.ac.kr"]
["교수회","교수회",5,null,null,null,"미정",1924000,481000,0,0,"디지털관 B111호","김민아","makim@kumoh.ac.kr"]
["학사행정실","테크노관행정실",16,null,null,null,"미정",6156800,1539200,0,0,"테크노관","박상모","park0195@kumoh.ac.kr"]
[null,"디지털관행정실",16,null,null,null,"미정",6156800,1539200,0,0,"디지털관","윤진아","qortjf414@kumoh.ac.kr"]
[null,"글로벌관행정실",16,null,null,null,"미정",6156800,1539200,0,0,"글로벌관","신명기","scent417@kumoh.ac.kr"]
[null,"교육관(신평동)",3,null,null,null,"미정",1154400,288600,0,0,"교육관(신평동)","신명기","scent417@kumoh.ac.kr"]
["교양교직과정부","교양교직과정부",5,null,null,null,"미정",1924000,481000,0,0,"글로벌관 103호","김혜진","hjkim@kumoh.ac.kr"]
["대학원","대학원지원팀",4,null,null,null,"미정",1539200,384800,0,0,"본관 201호","강선화","ksh@kumoh.ac.kr"]
[null,"컨설팅대학원",3,null,null,null,"미정",1154400,288600,0,0,"글로벌관 458호","류윤영","ru0304@kumoh.ac.kr"]
[null,"산업대학원(최고경영자과정팀)",3,null,null,null,"미정",1154400,288600,0,0,"글로벌관 445호","정윤","jungyoon@kumoh.ac.kr"]
["교육기본시설","도서관",52,null,null,null,"미정",20009600,5002400,0,0,"도서관","박지나","parkjn@kumoh.ac.kr"]
[null,"정보전산원",5,null,null,null,"미정",1924000,481000,0,0,"도서관 3, 4층","장현영","hun124@kumoh.ac.kr"]
["지원시설","생활관",7,null,null,6,"미정",2693600,673400,0,4327200,"푸름관","김용자","poten123@kumoh.ac.kr"]
["부속시설","공학종합실습센터",3,null,null,null,"미정",1154400,288600,0,0,"공동실험실습관 126호","권중성","cagibamito@kumoh.ac.kr"]
[null,"AI빅데이터센터",3,null,null,null,"미정",1154400,288600,0,0,"도서관 417호","양철순","ycs@kumoh.ac.kr"]
[null,"평생교육원(신평동)",7,null,null,null,"미정",2693600,673400,0,0,"신평동 평생교육원 102호","한지수","jsjshjs@kumoh.ac.kr"]
[null,"공동실험실습관",7,null,null,null,"미정",2693600,673400,0,0,"그린에너지관 202, 401호","이은진","nana2696@kumoh.ac.kr"]
[null,"과학영재교육원",3,null,null,null,"미정",1154400,288600,0,0,"테크노관 254호","김현정","hjmwhj@kumoh.ac.kr"]
[null,"국제교류교육원",4,null,null,null,"미정",1539200,384800,0,0,"테크노관 458호","권민경","mkkwon@kumoh.ac.kr"]
[null,"외국인유학생지원",0,null,null,null,"미정",0,0,{"$f":"D49*$D$10*$J$10","v":0},{"$f":"(E49*$E$10*$K$10)+($F$10*$F49*$K$10)","v":0}]
[null,"산학전략실",4,null,null,null,"미정",1539200,384800,0,0,"산학협력관 507호","원보빈","wbobeen@kumoh.ac.kr"]
[null,"지자체-대학협력기반지역혁신사업단",3,null,null,null,"미정",1154400,288600,0,0,"글로벌관 566호","진유림","yrj@kumoh.ac.kr"]
["학생군사교육단","152학생군사교육단",0,null,null,null,"미정",0,0,0,0,"학생군사교육단","백승환","amatus@kumoh.ac.kr"]
["교내 소계",null,{"$f":"SUM(C11:C52)","v":265},{"$f":"SUM(D11:D52)","v":14},{"$f":"SUM(E11:E52)","v":34},{"$f":"SUM(F11:F52)","v":6},null,{"$f":"SUM(H11:H52)","v":101972000},{"$f":"SUM(I11:I52)","v":25493000},6734000,24761200]
[null,null,50,{"$nulls":4},11150]
["산학협력단","산학협력단",48,null,null,null,"미정",{"$f":"C55*$C$54*$H$54","v":26760000},0,0,0,"산학협력관 302호, 305호","박은희","ppeh6521@kumoh.ac.kr"]
["산학협력시설","중소기업산학협력센터",6,null,null,null,"미정",{"$f":"C56*$C$54*$H$54","v":3345000},0,0,0,"산학협력관 203호","유광희","sanhack@kumoh.ac.kr"]
[null,"그린에너지산업화지원센터",6,null,null,null,"미정",3345000,0,0,0,"산학협력관 610호","구연정","b00543@kumoh.ac.kr"]
[null,"강소특구육성사업단",6,null,null,null,"미정",3345000,0,0,0,"공동실험실습관 201호","성상아","ssasera@kumoh.ac.kr"]
[null,"창의지식재산센터",6,null,null,null,"미정",3345000,0,0,0,"산학협력관 206호","김아름","arkim@kumoh.ac.kr"]
[null,"창업원(창업보육센터)",6,null,null,null,"미정",3345000,0,0,0,"벤처창업관 313호","김소연","kimsy@kumoh.ac.kr"]
[null,"산학교육원",6,null,null,null,"미정",3345000,0,0,0,"산학협력관 501호","김소연","ksykit@kumoh.ac.kr"]
[null,"사업운영본부",6,null,null,null,"미정",3345000,0,0,0,"산학협력관 505호","이경복","lkb0114@kumoh.ac.kr"]
["생활협동조합","생활협동조합",30,null,null,null,"미정",16725000,0,0,0,"학생회관","김민지","mjee1125@kumoh.ac.kr"]
["방학중교외집중근로",null,350,null,null,null,"미정",195125000,0,0,0]
["교외 소계",null,{"$f":"SUM(C55:C64)","v":470},{"$f":"SUM(D55:D63)","v":0},{"$f":"SUM(E55:E63)","v":0},{"$f":"SUM(F55:F63)","v":0},null,{"$f":"SUM(H55:H64)","v":262025000},{"$f":"SUM(I55:I63)","v":0},{"$f":"SUM(J55:J63)","v":0},{"$f":"SUM(K55:K63)","v":0}]
["총 계",null,{"$f":"C53+C65","v":735},{"$f":"D53+D65","v":14},{"$f":"E53+E65","v":34},{"$f":"F53+F65","v":6},null,{"$f":"H53+H65","v":363997000},{"$f":"I53+I65","v":25493000},{"$f":"J53+J65","v":6734000},{"$f":"K53+K65","v":24761200}]
[{"$nulls":9},"총계",{"$f":"SUM(H66:K66)","v":420985200}]

{"sheet":"계산","index":2,"n_rows":12,"n_cols":9,"rows_kept":12,"cut":false,"hidden":true,"merged":[[1,1,1,4],[1,5,1,8],[2,1,3,1],[2,4,3,4],[2,5,3,5],[2,8,3,8],[10,1,11,2],[4,1,5,1],[4,4,5,4],[4,5,5,5],[4,8,5,8],[6,1,7,1],[6,4,7,4],[6,5,7,5],[6,8,7,8]]}
[]
[null,"국고",null,null,null,"대학회계"]
[null,"학기중","교내",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"D3+D4","v":{"$error":"#REF!"}},"학기중","대응",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"H3+H4","v":{"$error":"#REF!"}}]
[null,null,"교외",{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,"대학근로",{"$f":"#REF!+#REF!","v":{"$error":"#REF!"}}]
[null,"방학중","교내",{"$f":"'2023-1 방학중 계획'!H53","v":101972000},{"$f":"D5+D6","v":363997000},"방학중","대응",{"$f":"'2023-1 방학중 계획'!I53","v":25493000},{"$f":"H5+H6","v":56988200}]
[null,null,"교외",{"$f":"'2023-1 방학중 계획'!H65","v":262025000},null,null,"대학근로",{"$f":"'2023-1 방학중 계획'!J53+'2023-1 방학중 계획'!K53","v":31495200}]
[null,"연간예산","교내",{"$f":"(D3+D5)*2","v":{"$error":"#REF!"}},{"$f":"(E3+E5)*2","v":{"$error":"#REF!"}},"연간예산","대응",{"$f":"(H3+H5)*2","v":{"$error":"#REF!"}},{"$f":"(I3+I5)*2","v":{"$error":"#REF!"}}]
[null,null,"교외",{"$f":"(D4+D6)*2","v":{"$error":"#REF!"}},null,null,"대학근로",{"$f":"(H4+H6)*2","v":{"$error":"#REF!"}}]
[]
[]
[null,"2학기 외국인 유학생 지원\n(일 8시간)",null,"국고",4802304]
[null,null,null,"대응",1200576]