{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["기본작업-1","기본작업-2","기본작업-3","계산작업","분석작업-1","분석작업-2","매크로작업","차트작업"],"not_rendered":{"charts":1,"images":0,"macros":0,"external_links":0,"defined_names":3,"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":[]}
["거래처 연락처 현황"]

{"sheet":"기본작업-2","index":1,"n_rows":14,"n_cols":7,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[null,"컴퓨터 학원 수강등록 현황"]
[]
[null,"과목","수강요일","강사명","수강기간","수강시간","수강료"]
[null,"정보처리","월, 수, 금","서진화","25일(75시간)","3시간",180000]
[null,"정보처리","화, 목, 토","서진화","25일(75시간)","3시간",180000]
[null,"워드","월, 수, 금","남성미","20일(40시간)","2시간",100000]
[null,"워드","화, 목, 토","남성미","20일(40시간)","2시간",100000]
[null,"컴활1급","월, 수, 금","한종영","30일(90시간)","3시간",200000]
[null,"컴활1급","화, 목, 토","한종영","30일(90시간)","3시간",200000]
[null,"컴활2급","월, 수, 금","조여진","20일(40시간)","2시간",120000]
[null,"컴활2급","화, 목, 토","조여진","20일(40시간)","2시간",120000]
[null,"사무자동화","월, 수, 금","임진구","20일(60시간)","3시간",160000]
[null,"사무자동화","화, 목, 토","임진구","20일(60시간)","3시간",160000]
[null,"합계",null,null,null,null,{"$f":"SUM(G4:G13)","v":1520000}]

{"sheet":"기본작업-3","index":2,"n_rows":13,"n_cols":8,"rows_kept":13,"cut":false,"hidden":false,"merged":[[0,0,0,7]]}
["건강검진 결과"]
[]
["성명","성별","키","몸무게","시력","혈액형","청력","혈압"]
["최유영","여",165,50,1.2,"A","정상","115/70"]
["김선호","남",176,70,0.4,"O","정상","125/85"]
["장승지","여",157,51,1.5,"B","정상","120/80"]
["최회식","남",185,74,1.5,"B","정상","135/98"]
["이윤성","여",162,49,1.2,"A","정상","118/80"]
["이시라","여",160,50,0.7,"AB","정상","120/75"]
["서진수","남",170,72,0.1,"A","정상","132/90"]
["안창민","남",172,65,1.2,"O","정상","121/81"]
["한미라","여",161,60,1.5,"AB","정상","120/79"]
["임상욱","남",183,85,0.4,"B","정상","122/82"]

{"sheet":"계산작업","index":3,"n_rows":40,"n_cols":10,"rows_kept":40,"cut":false,"hidden":false,"merged":[]}
["[표1]","심야고속버스 예매 현황",null,null,null,null,"[표2]","회원 관리 현황"]
["구간","출발시간","요금","잔여좌석","비고",null,"성명","성별","아이디","메일주소"]
["서울-통영","22:00:00",34200,2,null,null,"최명호","남",null,"hiji23@nate.com"]
["서울-울산","21:30:00",32200,3,null,null,"하진성","남",null,"now55@daum.net"]
["서울-원주","23:00:00",10000,12,null,null,"박건섭","남",null,"lsh457@naver.com"]
["서울-대구","21:00:00",25200,1,null,null,"노철민","남",null,"ten10@daum.net"]
["서울-속초","23:20:00",24200,9,null,null,"김인기","남",null,"evermk@nate.com"]
["서울-청주","21:00:00",7900,5,null,null,"홍은철","남",null,"m2m@daum.net"]
["서울-남원","22:20:00",25600,11,null,null,"성소진","여",null,"last007@naver.com"]
["서울-전주","20:30:00",12800,8,null,null,"나유원","여",null,"gchoo@naver.com"]
["서울-안동","22:00:00",18200,5,null,null,"도지희","여",null,"alrud7@daum.net"]
["서울-춘천","21:30:00",8000,7,null,null,"김예소","여",null,"kes20@nate.com"]
[]
["[표3]","영어 발표 대회",null,null,null,null,"[표4]","세계여행 정보"]
["번호","성명","성별","점수","수상",null,"지역","국가","수도","국가/수도"]
[1,"이방주","남",86,null,null,"아시아","korea","seoul"]
[2,"황영희","여",45,null,null,"유럽","frace","paris"]
[3,"손기중","남",78,null,null,"아메리카","brasil","brasilia"]
[4,"김보라","여",92,null,null,"아시아","japan","tokyo"]
[5,"엄이봉","남",76,null,null,"아메리카","canada","ottawa"]
[6,"김경삼","남",98,null,null,"아프리카","morocco","rabat"]
[7,"한우경","여",87,null,null,"아시아","china","beijing"]
[8,"김상희","여",91,null,null,"유럽","spain","madrid"]
[9,"임선빈","남",64,null,null,"아프리카","kenya","nairobi"]
[]
["[표5]","제품 판매 현황"]
["대리점","제품명","판매가","판매량","할인액"]
["강남점","마우스",20000,1247]
["강남점","키보드",18000,865]
["강남점","헤드폰",15000,1021]
["마포점","마우스",20000,758]
["마포점","외장하드",45000,248]
["마포점","헤드폰",15000,675]
["노원점","마우스",20000,957]
["노원점","키보드",18000,893]
["노원점","스피커",17500,768]
[]
["<할인율표>"]
["제품명","마우스","키보드","헤드폰"]
["할인율",0.08,0.1,0.14000000000000001]

{"sheet":"분석작업-1","index":4,"n_rows":19,"n_cols":6,"rows_kept":19,"cut":false,"hidden":false,"merged":[[0,1,0,2],[2,1,2,2],[11,1,11,2]]}
[null,"4월 급여명세서"]
[]
[null,"지급액",null,null,"국민연금율",4.4999999999999998E-2]
[null,"기본급",1600000,null,"건강보험율",0.03]
[null,"야간수당",150000,null,"고용보험율",5.0000000000000001E-3]
[null,"휴일수당",300000]
[null,"상여금",500000]
[null,"교통비",200000]
[null,"식비",200000]
[null,"통신비",50000]
[null,"소계",{"$f":"SUM(C4:C10)","v":3000000}]
[null,"공제내역"]
[null,"소득세",17100]
[null,"지방소득세",1710]
[null,"국민연금",{"$f":"C11*F3","v":135000}]
[null,"건강보험",{"$f":"C11*F4","v":90000}]
[null,"고용보험",{"$f":"C11*F5","v":15000}]
[null,"소계",{"$f":"SUM(C13:C17)","v":258810}]
[null,"차감지급액",{"$f":"C11-C18","v":2741190}]

{"sheet":"분석작업-2","index":5,"n_rows":21,"n_cols":7,"rows_kept":21,"cut":false,"hidden":false,"merged":[[0,0,0,6]]}
["사원별 휴가 사용 현황"]
[]
["사원명","성별","부서명","직위","근무년수","휴가일수","사용일수"]
["강영준","남","영업부","대리",4,16,11]
["고인송","여","생산부","과장",13,20,17]
["김영택","남","홍보부","사원",3,14,11]
["김은소","여","홍보부","과장",14,20,16]
["김은주","여","생산부","대리",1,15,11]
["김지향","여","영업부","과장",16,22,13]
["박광희","남","영업부","과장",14,20,18]
["박승우","남","생산부","대리",6,16,12]
["박신영","여","생산부","사원",1,13,8]
["성우영","남","홍보부","대리",7,18,11]
["안지희","여","홍보부","대리",6,16,12]
["유진녀","여","영업부","대리",5,16,15]
["이동우","남","영업부","사원",2,14,13]
["이수협","남","생산부","사원",2,14,7]
["정은경","여","홍보부","사원",2,14,10]
["조정수","남","영업부","대리",8,18,16]
["최종현","남","생산부","대리",5,16,14]
["한민성","남","홍보부","과장",15,20,18]

{"sheet":"매크로작업","index":6,"n_rows":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,0,0,5]]}
["서점별 매출 현황"]
[]
["서점명","판매량","판매액","평균할인율","할인액","판매이익"]
["대한서점",988,9682000,0.15,{"$f":"C4*D4","v":1452300}]
["상공서점",1275,12495000,0.18,{"$f":"C5*D5","v":2249100}]
["한강문고",413,4047000,0.12,485640]
["서울문고",1024,10035000,0.15,1505250]
["대주서점",867,8497000,0.16,1359520]
["부영문고",1101,10790000,0.15,1618500]
["인하문고",992,9722000,0.18,1749960]
["유명서점",786,7703000,0.16,1232480]
["보아문고",831,8144000,0.15,1221600]

{"sheet":"차트작업","index":7,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[[0,0,0,3]]}
["전국체전 메달 획득 현황"]
[]
["지역","금","은","동"]
["강원도",3,11,5]
["경기",27,9,12]
["경상도",13,11,15]
["광주",20,10,9]
["대구",19,15,4]
["대전",3,9,11]
["부산",12,14,8]
["서울",22,25,9]
["인천",18,8,12]
["전라도",12,10,7]
["충청도",9,12,13]