{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["기본작업-1","기본작업-2","기본작업-3","계산작업","분석작업-1","분석작업-2","매크로작업","차트작업"],"not_rendered":{"charts":1,"images":8,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"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":"기본작업-1","index":0,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["상공홈쇼핑 3월 판매현황"]

{"sheet":"기본작업-2","index":1,"n_rows":14,"n_cols":8,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["사원별 제품 판매 현황"]
[]
["사원명","직위","분기",null,null,null,"합계","판매총액"]
[null,null,"1분기","2분기","3분기","4분기"]
["남유진","과장",193,154,269,227,843,33720000]
["손규창","과장",143,191,205,201,740,29600000]
["이보성","대리",231,277,204,249,961,38440000]
["전희수","대리",198,218,191,151,758,30320000]
["박민철","대리",181,187,211,207,786,31440000]
["권준헌","대리",136,118,145,115,514,20560000]
["유찬영","사원",237,257,265,214,973,38920000]
["노세진","사원",145,164,172,189,670,26800000]
["안상욱","사원",194,191,215,189,789,31560000]
["우명주","사원",118,136,125,131,510,20400000]

{"sheet":"기본작업-3","index":2,"n_rows":18,"n_cols":7,"rows_kept":18,"cut":false,"hidden":false,"merged":[[0,0,0,6]]}
["사원별 인사 관리 현황"]
[]
["사원코드","사원명","성별","부서명","직위","호봉","급여"]
["SG-1001","남종민","남","생산부","부장",5,4800000]
["SG-1002","김유진","여","생산부","과장",3,3800000]
["SG-1003","이정우","남","생산부","대리",3,3100000]
["SG-1004","박찬호","남","생산부","사원",2,2450000]
["SG-1005","이채영","여","생산부","사원",1,2350000]
["SG-1006","조제성","남","영업부","부장",4,4700000]
["SG-1007","한소희","여","영업부","과장",5,4000000]
["SG-1008","고선정","여","영업부","과장",2,3500000]
["SG-1009","정민호","남","영업부","대리",2,3000000]
["SG-1010","신수영","여","영업부","사원",3,2550000]
["SG-1011","최경민","남","총무부","과장",4,3900000]
["SG-1012","최미연","여","총무부","대리",4,3200000]
["SG-1013","손성준","남","총무부","대리",2,3000000]
["SG-1014","김준용","남","총무부","사원",3,2550000]
["SG-1015","이보현","여","총무부","사원",2,2450000]

{"sheet":"계산작업","index":3,"n_rows":40,"n_cols":10,"rows_kept":40,"cut":false,"hidden":false,"merged":[[11,0,11,3]]}
["[표1]","신입사원 채용결과",null,null,null,null,"[표2]","스포츠센터 회원 현황"]
["응시번호","이름","성별","필기","면접",null,"회원명","가입년도","주민등록번호","성별"]
["21A101","배이준","남",83,67,null,"윤다현","2018년","800621-1******"]
["21A102","이지수","여",91,75,null,"오지윤","2016년","920101-2******"]
["21A103","박선호","남",88,83,null,"송주명","2019년","000317-4******"]
["21A104","서희상","남",73,72,null,"양명준","2018년","960725-1******"]
["21A105","허재희","여",65,70,null,"안성수","2017년","950226-1******"]
["21A106","정윤형","남",94,98,null,"윤정민","2016년","881109-2******"]
["21A107","신다은","여",55,51,null,"유혜진","2018년","850430-2******"]
["21A108","강철수","남",89,79,null,"진경원","2019년","010823-3******"]
["21A109","남상미","여",90,84,null,"송주혜","2017년","931214-2******"]
["합격자수",null,null,null,null,null,"황소민","2018년","970922-2******"]
[]
["[표3]","문화센터 출석현황",null,null,null,null,null,"[표4]","제품 생산 현황"]
["수강자명","1주차","2주차","3주차","4주차","출석률",null,"분류","생산일자","제품코드"]
["남종완","O","O","O","O",null,null,"com","2020-11-06"]
["홍소율",null,"O","O","O",null,null,"mou","2020-11-06"]
["박이준","O","O","O","O",null,null,"key","2020-11-06"]
["문하준","O",null,"O","O",null,null,"com","2020-12-05"]
["노윤혁","O","O",null,"O",null,null,"mou","2020-12-05"]
["우영희","O","O","O","O",null,null,"key","2020-12-05"]
["박윤도","O","O","O","O",null,null,"com","2021-01-03"]
["권채안","O",null,"O",null,null,null,"mou","2021-01-03"]
["김선호","O","O","O","O",null,null,"key","2021-01-03"]
[]
["[표5]","쇼핑몰 회원관리현황"]
["회원코드","성별","구입총액","마일리지","등급"]
["김유진","여",667000,20010]
["임선호","남",575800,17274]
["강혜진","여",768100,23043]
["박미현","여",913600,27408]
["홍정화","여",866000,25980]
["유태원","남",468200,14046]
["김정석","남",511000,15330]
["최미경","여",978400,29352]
["신성철","남",810000,24300]
[]
["<등급표>"]
["순위",1,3,5,7]
["등급","골드","실버","브론즈","일반"]

{"sheet":"분석작업-1","index":4,"n_rows":15,"n_cols":8,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,0,0,7]]}
["사원 급여명세서"]
[]
["사원명","부서명","직위","호봉","기본급","수당","세금","실수령액"]
["양예슬","생산부","부장",6,3800000,1600000,700000,4700000]
["남대인","생산부","과장",5,3000000,1400000,570000,3830000]
["전상희","생산부","대리",1,2000000,1100000,400000,2700000]
["배종재","생산부","사원",3,1900000,900000,360000,2440000]
["주하정","영업부","부장",1,3200000,1500000,610000,4090000]
["오송연","영업부","과장",2,2440000,1350000,490000,3300000]
["서송빈","영업부","대리",4,2200000,1200000,440000,2960000]
["고인숙","영업부","사원",2,1850000,900000,360000,2390000]
["김주성","홍보부","부장",4,3700000,1500000,680000,4520000]
["한은주","홍보부","과장",4,2880000,1350000,550000,3680000]
["이장원","홍보부","대리",3,2100000,1200000,430000,2870000]
["김선길","홍보부","사원",1,1800000,800000,340000,2260000]

{"sheet":"분석작업-2","index":5,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[[0,0,0,1]]}
["정기적금"]
["목표액",30000000,null,null,"월납입액"]
["월납입액",{"$f":"PMT(B4/12,B5*12,,-B2)","v":469920.84816440829},null,"이자(년)"]
["이자(년)",2.5000000000000001E-2,null,0.02]
["기간(년)",5,null,2.5000000000000001E-2]
[null,null,null,0.03]
[null,null,null,3.5000000000000003E-2]
[null,null,null,0.04]
[null,null,null,4.4999999999999998E-2]
[null,null,null,0.05]

{"sheet":"매크로작업","index":6,"n_rows":10,"n_cols":6,"rows_kept":10,"cut":false,"hidden":false,"merged":[[0,0,0,5]]}
["1월 상공채널 드라마 시청률"]
[null,null,null,null,null,"(단위 : %)"]
["프로그램명","1주","2주","3주","4주","평균"]
["스카이하우스",21.8,22.9,23.2,23.8]
["찬란한빛",12.4,11.9,12.8,13.2]
["경이로운인생",8.9,9.6999999999999993,10.3,10.1]
["라이브",6.8,6.1,5.9,6.4]
["겨울아부탁해",13.5,14.2,13.8,13.2]
["날아라불새",20.100000000000001,20.8,22.1,21.3]
["복수의소문",16.5,16.100000000000001,15.7,16.3]

{"sheet":"차트작업","index":7,"n_rows":8,"n_cols":5,"rows_kept":8,"cut":false,"hidden":false,"merged":[[0,0,0,4]]}
["가전제품 목표/생산 현황"]
[]
["제품명","목표량","생산량","생산단가","달성률"]
["TV",1000,1102,1150000,{"$f":"C4/B4","v":1.1020000000000001}]
["냉장고",1350,1267,1320000,{"$f":"C5/B5","v":0.93851851851851853}]
["세탁기",1200,1384,640000,1.1533333333333333]
["의류건조기",900,932,920000,1.0355555555555556]
["인덕션",1150,1036,680000,0.90086956521739125]